APPS.BOM_BOMRBOMS_XMLP_PKG dependencies on BOM_LISTS

Line 280: BOM_LISTS_S.NEXTVAL

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

Line 286: INSERT INTO BOM_LISTS

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

Line 299: BOM_LISTS_S.NEXTVAL

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

Line 334: TABLE_NAME := 'bom_lists';

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

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

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

Line 519: DELETE FROM BOM_LISTS

515: BEGIN
516: BEGIN
517: ROLLBACK;
518: /*SRW.USER_EXIT('FND SRWEXIT')*/NULL;
519: DELETE FROM BOM_LISTS
520: WHERE SEQUENCE_ID = P_SEQUENCE_ID1;
521: EXCEPTION
522: WHEN OTHERS THEN
523: RETURN (TRUE);