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: // …