Showing posts from October, 2023

Only one Schedule/Vassel Approval by Party

Setp-1 : ======= Create Interactive Report  SQL Query : For Check Box APEX_ITEM.CHECKBOX(1,ID,'UNCHECKED')    SELECTED Setp-2 : ====== Processes : VASSEL_APPROVAL Declare  v_count          number:= 0; v_appCont    number ; begin FOR i in 1…

"PREFIX+AUTO_NUMBER" customize set In Invoice

Step : 1  ====== CREATE TABLE AUTO_NUMBER_GENERATE     ( ID                           NUMBER ,  TYPE                     VARCHAR2(25 CHAR) NOT NULL ENABLE,  AUTO_NUMBER   NUMBER,  PREFIX                  VARCHAR2(25 CHAR),  CREATE_BY        …

PL/SQL OVERLOADING PACKAGE

================ Package Specification ======================= Create or Replace Package OVERLOADING_PACKAGE AS    PROCEDURE DISPLAY_Result (p_lower IN NUMBER, p_upper IN NUMBER);     PROCEDURE DISPLAY_Result ( V1 IN NUMBER, V2 IN NUMBER, V3 IN NU…

Additional Outputs & Popup LOVs Column Size Customize

Step 1: Select LOV Item and set Initialization JavaScript Function : //Javascript Codes function(options) {     var columns = options.columns;     // set minimum width for the LOV dialog     options.minWidth = 600 ;     // TRIP_ID     if (columns.T…

Load More
That is All