[Home] [Help]
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:
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: