Showing posts from February, 2025
CREATE or replace function GET_SIM_REQ_APPROVED_DTL (in_type in varchar2,in_id in number) return varchar2 is v_name varchar2(256); begin if in_type = ' OPERATOR_REQ_QTY ' then select LISTAGG(RPAD(OPERATOR_NAME, 18, ' ') || ':…
First Look at the picture. I want to Data/Row Insert Predefine number-wise . ========================================== Step 1: ==== Create Two Interactive Grid Regions. 1. Predefine number Region. --- Static ID: Show_Dept 2. Predefine number …
Step:1 ==== Create two Interactive Grid Regions. My 1st Region--> Details Collection (For Insert the checkbox value) My 2nd Region--> SIM Request Of Approved List (For Checkbox Region) Step:2 ==== Function and Global Variable Declaration: // …
Step:1 ===== Go to Ajax Callback Process. Create Process. Name: INSERT_PAYMENT Type: Execute Code PLSQL Code: DECLARE V_PK_ID NUMBER; V_AUTO_NUMBER NUMBER; V_INVOICE_NO VARCHAR2 (50); BEGIN IF :P31_ID IS NULL THEN …
Execute when Page Loads: ================= $(document).ready(function () { let h = $(window).height() * 78 / 100; $("#invoicereg_ig").css("height", `${h}px`); // invoicereg -- Static ID }); $(document).ready(function () {…
