Below Pseudocode, DECLARE L_RESULT BOOLEAN; L_PO_HEADER_ID NUMBER; — := <PO_HEADER_ID> ; L_TYPE_LOOKUP_CODE VARCHAR2(20); — := <LOOKUP_CODE> ; L_VALIDATION VARCHAR2(10) := ‘N’; — := <VALIDATION_FLAG> ; CURSOR CUR_PO_DEL IS SELECT…
Read MoreWITH csv AS (SELECT ‘AA,BB,CC,D33D,EE,FFDD.MM,GG’ AS csvdata FROM DUAL) SELECT REGEXP_SUBSTR (csv.csvdata, ‘[^,]+’, 1, LEVEL) pivot_char FROM DUAL, csv CONNECT BY REGEXP_SUBSTR (csv.csvdata,'[^,]+’, 1, LEVEL) IS NOT NULL;
Read MoreCreate or Replace Function AMT_IN_WORDS ( P_TOT_AMT float, P_TRANSACTION_CURR Varchar2) return varchar2 IS InvalidNumberFormatModel EXCEPTION; PRAGMA EXCEPTION_INIT(InvalidNumberFormatModel,-1481); InvalidNumber EXCEPTION; PRAGMA EXCEPTION_INIT(InvalidNumber,-1722); TYPE GroupTableType IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;…
Read MoreOverview In order to disable New Record Button, Clear Button and Delete Button, Please follow below step Write the code in the Form Level Trigger (WHEN-NEW-BLOCK-INSTANCE) IF :XXBEX_PRO_BUDGET_HEADER_V.PROJECT_STATUS IN (‘PROJECT…
Read MoreWhen the Disposition Fields = (‘Complete’,’Accept’,’Accept with Variance’,’Reject’) Then Disable or READ ONLY the DFF Help -> diagnose -> custom code-> personalize Condition: Trigger Event: WHEN-NEW-ITEM-INSTANCE Trigger Object: GMDQSMPL.SAMPLE_NO Condition:…
Read MoreOverview Requirement: We have to change the “type” field LOV query for populating the custom values. To achieve this we have to follow the below process. Step-1: Login into the application…
Read MoreOverview Sometimes having a requirement to display all block data whenever form is open. In order to achieve please follow below step, Open Form builder> Open your custom form >Go…
Read MoreSometimes have a requirement to run the running total in XMLP Report and set the record per page by Variable declaration. Step to follow, Add the form field in RTF…
Read MoreSometimes, We have a requirement to disable the DFF at form level. Either have to do disable the DFF as well or Read-Only of the attribute of the DFF. So,…
Read MoreProcess to restrict number of rows per page in xml reports by using following command Let us take example if you want show 5 records per page you can use…
Read More