APPS.BOM_BOMRBOMS_XMLP_PKG dependencies on BOM_LISTS

Line 283: BOM_LISTS_S.NEXTVAL

279: T_ORG_CODE_LIST(1) := LP_ORGANIZATION_ID;
280: END IF;
281:
282: SELECT
283: BOM_LISTS_S.NEXTVAL
284: INTO P_SEQUENCE_ID1
285: FROM
286: DUAL;
287:

Line 289: INSERT INTO BOM_LISTS

285: FROM
286: DUAL;
287:
288: FOR I IN T_ORG_CODE_LIST.FIRST .. T_ORG_CODE_LIST.LAST LOOP
289: INSERT INTO BOM_LISTS
290: (ORGANIZATION_ID
291: ,SEQUENCE_ID
292: ,ALTERNATE_DESIGNATOR)
293: VALUES (T_ORG_CODE_LIST(I)

Line 302: BOM_LISTS_S.NEXTVAL

298: FOR I IN T_ORG_CODE_LIST.FIRST .. T_ORG_CODE_LIST.LAST LOOP
299: LP_ORGANIZATION_ID := T_ORG_CODE_LIST(I);
300: TABLE_NAME := 'Select_sequence';
301: SELECT
302: BOM_LISTS_S.NEXTVAL
303: INTO L_SEQ_ID
304: FROM
305: DUAL;
306:

Line 337: TABLE_NAME := 'bom_lists';

333: END IF;
334: END IF;
335: END IF;
336:
337: TABLE_NAME := 'bom_lists';
338: CURSOR_NAME := DBMS_SQL.OPEN_CURSOR;
339: /***** Commented out to fix bug #6769853 ********
340: P_ASS_BETWEEN := BOMRBOMS_NEW.P_ASS_BETWEEN;
341: P_CAT_BETWEEN := BOMRBOMS_NEW.P_CAT_BETWEEN;

Line 346: L_STR := 'INSERT INTO BOM_LISTS (SEQUENCE_ID,ASSEMBLY_ITEM_ID,ALTERNATE_DESIGNATOR) ';

342: ***** Commented out to fix bug #6769853 ********/
343: -- P_ASS_BETWEEN := BOM_BOMRBOMS_XMLP_PKG.P_ASS_BETWEEN; Commented for bug 9364923
344: P_CAT_BETWEEN := BOM_BOMRBOMS_XMLP_PKG.P_CAT_BETWEEN;
345:
346: L_STR := 'INSERT INTO BOM_LISTS (SEQUENCE_ID,ASSEMBLY_ITEM_ID,ALTERNATE_DESIGNATOR) ';
347: TABLE_NAME := 'l_string';
348:
349: IF P_RANGE_OPTION_TYPE = 1 THEN
350: FLAG := TRUE;

Line 590: DELETE FROM BOM_LISTS

586: BEGIN
587: BEGIN
588: ROLLBACK;
589: /*SRW.USER_EXIT('FND SRWEXIT')*/NULL;
590: DELETE FROM BOM_LISTS
591: WHERE SEQUENCE_ID = P_SEQUENCE_ID1;
592: EXCEPTION
593: WHEN OTHERS THEN
594: RETURN (TRUE);