APPS.BOM_BOMRASSY_XMLP_PKG dependencies on BOM_LISTS_S

Line 38: BOM_LISTS_S.NEXTVAL

34: END IF;
35: END IF;
36: IF P_ALL_ORGS = 1 THEN
37: SELECT
38: BOM_LISTS_S.NEXTVAL
39: INTO P_SEQUENCE_ID
40: FROM
41: DUAL;
42: FOR C1 IN (SELECT

Line 75: BOM_LISTS_S.NEXTVAL

71: INV_ORGHIERARCHY_PVT.ORG_HIERARCHY_LIST(P_ORG_HIERARCHY
72: ,P_ORG_ID
73: ,T_ORG_CODE_LIST);
74: SELECT
75: BOM_LISTS_S.NEXTVAL
76: INTO P_SEQUENCE_ID
77: FROM
78: DUAL;
79: FOR I IN T_ORG_CODE_LIST.FIRST .. T_ORG_CODE_LIST.LAST LOOP

Line 90: BOM_LISTS_S.NEXTVAL

86: ,T_ORG_CODE_LIST(I));
87: END LOOP;
88: ELSIF P_ORG_HIERARCHY IS NULL THEN
89: SELECT
90: BOM_LISTS_S.NEXTVAL
91: INTO P_SEQUENCE_ID
92: FROM
93: DUAL;
94: INSERT INTO BOM_LISTS

Line 102: BOM_LISTS_S.NEXTVAL

98: ,P_SEQUENCE_ID);
99: END IF;
100: ELSE
101: SELECT
102: BOM_LISTS_S.NEXTVAL
103: INTO P_SEQUENCE_ID
104: FROM
105: DUAL;
106: INSERT INTO BOM_LISTS