DBA Data[Home] [Help]

APPS.ENG_ENGRCNDR_XMLP_PKG dependencies on BOM_LISTS

Line 68: BOM_LISTS_S.NEXTVAL

64: L_RESP_ID NUMBER;
65: L_RESP_APPL_ID NUMBER;
66: BEGIN
67: SELECT
68: BOM_LISTS_S.NEXTVAL
69: INTO P_SEQUENCE_ID
70: FROM
71: DUAL;
72: IF P_ALL_ORGS = 1 THEN

Line 94: INSERT INTO BOM_LISTS

90: ORG_ACCESS_VIEW
91: WHERE RESPONSIBILITY_ID = L_RESP_ID
92: AND RESP_APPLICATION_ID = L_RESP_APPL_ID )) LOOP
93: L_INDEX := L_INDEX + 1;
94: INSERT INTO BOM_LISTS
95: (SEQUENCE_ID
96: ,ORGANIZATION_ID
97: ,ALTERNATE_DESIGNATOR)
98: VALUES (P_SEQUENCE_ID

Line 105: INSERT INTO BOM_LISTS

101: END LOOP;
102: DP_ALL_ORGS := 'Yes';
103: ELSE
104: IF (P_ORG_HIERARCHY IS NULL) THEN
105: INSERT INTO BOM_LISTS
106: (SEQUENCE_ID
107: ,ORGANIZATION_ID
108: ,ALTERNATE_DESIGNATOR)
109: VALUES (P_SEQUENCE_ID

Line 118: INSERT INTO BOM_LISTS

114: ,P_ORG_ID
115: ,L_ORG_CODE_LIST);
116: IF (L_ORG_CODE_LIST.COUNT > 0) THEN
117: FOR l_index IN 1 .. L_ORG_CODE_LIST.COUNT LOOP
118: INSERT INTO BOM_LISTS
119: (SEQUENCE_ID
120: ,ORGANIZATION_ID
121: ,ALTERNATE_DESIGNATOR)
122: VALUES (P_SEQUENCE_ID