DBA Data[Home] [Help]

APPS.OKS_RULE_MIGRATE dependencies on OKS_LEVEL_ELEMENTS

Line 26517: UPDATE OKS_LEVEL_ELEMENTS

26513: CLOSE L_LVL_CSR;
26514:
26515: IF RUL_IDI.COUNT > 0 THEN
26516: FORALL I IN RUL_IDI.FIRST..RUL_IDI.LAST
26517: UPDATE OKS_LEVEL_ELEMENTS
26518: SET CLE_ID = CLE_IDI(I)
26519: , DNZ_CHR_ID = DNZ_CHR_IDI(I)
26520: , PARENT_CLE_ID = PARENT_CLE_IDI(I)
26521: WHERE RUL_ID = RUL_IDI(I);

Line 37348: UPDATE OKS_LEVEL_ELEMENTS

37344: ,PARENT_CLE_IDI;
37345: CLOSE L_LVL_CSR;
37346: IF RUL_IDI.COUNT > 0 THEN
37347: FORALL I IN RUL_IDI.FIRST..RUL_IDI.LAST
37348: UPDATE OKS_LEVEL_ELEMENTS
37349: SET CLE_ID = CLE_IDI(I)
37350: , DNZ_CHR_ID = DNZ_CHR_IDI(I)
37351: , PARENT_CLE_ID = PARENT_CLE_IDI(I)
37352: WHERE RUL_ID = RUL_IDI(I);

Line 37355: FND_FILE.PUT_LINE(FND_FILE.LOG ,'Successful update of oks_level_elements table ');

37351: , PARENT_CLE_ID = PARENT_CLE_IDI(I)
37352: WHERE RUL_ID = RUL_IDI(I);
37353: END IF;
37354:
37355: FND_FILE.PUT_LINE(FND_FILE.LOG ,'Successful update of oks_level_elements table ');
37356:
37357: -- New code addition on Mar-16-2004 ends
37358:
37359: