282: SELECT
283: BOM_LISTS_S.NEXTVAL
284: INTO P_SEQUENCE_ID1
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
301: SELECT
302: BOM_LISTS_S.NEXTVAL
303: INTO L_SEQ_ID
304: FROM
305: DUAL;
306:
307: P_SEQUENCE_ID := L_SEQ_ID;
308: TABLE_NAME := 'Locator_flex';
309: TABLE_NAME := 'Item_flex';