1832:
1833: IS
1834: l_batch_id NUMBER;
1835: l_mode VARCHAR2(20);
1836: l_item_id_tab dbms_sql.VARCHAR2_table;
1837: l_org_id_tab dbms_sql.VARCHAR2_table;
1838: l_rev_id_tab dbms_sql.VARCHAR2_table;
1839: l_seq_num_tab dbms_sql.VARCHAR2_table;
1840: l_rev_date_tab dbms_sql.VARCHAR2_table; -- Bug 8659192
1833: IS
1834: l_batch_id NUMBER;
1835: l_mode VARCHAR2(20);
1836: l_item_id_tab dbms_sql.VARCHAR2_table;
1837: l_org_id_tab dbms_sql.VARCHAR2_table;
1838: l_rev_id_tab dbms_sql.VARCHAR2_table;
1839: l_seq_num_tab dbms_sql.VARCHAR2_table;
1840: l_rev_date_tab dbms_sql.VARCHAR2_table; -- Bug 8659192
1841:
1834: l_batch_id NUMBER;
1835: l_mode VARCHAR2(20);
1836: l_item_id_tab dbms_sql.VARCHAR2_table;
1837: l_org_id_tab dbms_sql.VARCHAR2_table;
1838: l_rev_id_tab dbms_sql.VARCHAR2_table;
1839: l_seq_num_tab dbms_sql.VARCHAR2_table;
1840: l_rev_date_tab dbms_sql.VARCHAR2_table; -- Bug 8659192
1841:
1842: batch_entity_rec EGO_PUB_FWK_PK.TBL_OF_BAT_ENT_OBJ_TYPE;
1835: l_mode VARCHAR2(20);
1836: l_item_id_tab dbms_sql.VARCHAR2_table;
1837: l_org_id_tab dbms_sql.VARCHAR2_table;
1838: l_rev_id_tab dbms_sql.VARCHAR2_table;
1839: l_seq_num_tab dbms_sql.VARCHAR2_table;
1840: l_rev_date_tab dbms_sql.VARCHAR2_table; -- Bug 8659192
1841:
1842: batch_entity_rec EGO_PUB_FWK_PK.TBL_OF_BAT_ENT_OBJ_TYPE;
1843: l_alt_desg VARCHAR2(100) := null;
1836: l_item_id_tab dbms_sql.VARCHAR2_table;
1837: l_org_id_tab dbms_sql.VARCHAR2_table;
1838: l_rev_id_tab dbms_sql.VARCHAR2_table;
1839: l_seq_num_tab dbms_sql.VARCHAR2_table;
1840: l_rev_date_tab dbms_sql.VARCHAR2_table; -- Bug 8659192
1841:
1842: batch_entity_rec EGO_PUB_FWK_PK.TBL_OF_BAT_ENT_OBJ_TYPE;
1843: l_alt_desg VARCHAR2(100) := null;
1844: l_rev_date DATE;
2339: p_odi_session_id IN NUMBER)
2340:
2341: IS
2342:
2343: l_lang_code_tab dbms_sql.varchar2_table;
2344: l_lang_name_tab dbms_sql.varchar2_table; -- Bug 8670897
2345: l_uda_attr_name_tab dbms_sql.varchar2_table;
2346: l_uda_attr_id_tab dbms_sql.varchar2_table;
2347: l_ta_attr_id_tab dbms_sql.varchar2_table;
2340:
2341: IS
2342:
2343: l_lang_code_tab dbms_sql.varchar2_table;
2344: l_lang_name_tab dbms_sql.varchar2_table; -- Bug 8670897
2345: l_uda_attr_name_tab dbms_sql.varchar2_table;
2346: l_uda_attr_id_tab dbms_sql.varchar2_table;
2347: l_ta_attr_id_tab dbms_sql.varchar2_table;
2348: l_ta_attr_name_tab dbms_sql.varchar2_table;
2341: IS
2342:
2343: l_lang_code_tab dbms_sql.varchar2_table;
2344: l_lang_name_tab dbms_sql.varchar2_table; -- Bug 8670897
2345: l_uda_attr_name_tab dbms_sql.varchar2_table;
2346: l_uda_attr_id_tab dbms_sql.varchar2_table;
2347: l_ta_attr_id_tab dbms_sql.varchar2_table;
2348: l_ta_attr_name_tab dbms_sql.varchar2_table;
2349:
2342:
2343: l_lang_code_tab dbms_sql.varchar2_table;
2344: l_lang_name_tab dbms_sql.varchar2_table; -- Bug 8670897
2345: l_uda_attr_name_tab dbms_sql.varchar2_table;
2346: l_uda_attr_id_tab dbms_sql.varchar2_table;
2347: l_ta_attr_id_tab dbms_sql.varchar2_table;
2348: l_ta_attr_name_tab dbms_sql.varchar2_table;
2349:
2350: PUBLISH_OP_ATTR_GROUPS VARCHAR2(10);
2343: l_lang_code_tab dbms_sql.varchar2_table;
2344: l_lang_name_tab dbms_sql.varchar2_table; -- Bug 8670897
2345: l_uda_attr_name_tab dbms_sql.varchar2_table;
2346: l_uda_attr_id_tab dbms_sql.varchar2_table;
2347: l_ta_attr_id_tab dbms_sql.varchar2_table;
2348: l_ta_attr_name_tab dbms_sql.varchar2_table;
2349:
2350: PUBLISH_OP_ATTR_GROUPS VARCHAR2(10);
2351:
2344: l_lang_name_tab dbms_sql.varchar2_table; -- Bug 8670897
2345: l_uda_attr_name_tab dbms_sql.varchar2_table;
2346: l_uda_attr_id_tab dbms_sql.varchar2_table;
2347: l_ta_attr_id_tab dbms_sql.varchar2_table;
2348: l_ta_attr_name_tab dbms_sql.varchar2_table;
2349:
2350: PUBLISH_OP_ATTR_GROUPS VARCHAR2(10);
2351:
2352: l_node_exists NUMBER;
3483: l_segment_18 mtl_system_items_b.segment18%TYPE;
3484: l_segment_19 mtl_system_items_b.segment19%TYPE;
3485: l_segment_20 mtl_system_items_b.segment20%TYPE;
3486:
3487: l_item_id_tab dbms_sql.VARCHAR2_table;
3488: l_org_id_tab dbms_sql.VARCHAR2_table;
3489: l_org_code_tab dbms_sql.VARCHAR2_table;
3490: l_rev_id_tab dbms_sql.VARCHAR2_table;
3491: l_rev_tab dbms_sql.VARCHAR2_table;
3484: l_segment_19 mtl_system_items_b.segment19%TYPE;
3485: l_segment_20 mtl_system_items_b.segment20%TYPE;
3486:
3487: l_item_id_tab dbms_sql.VARCHAR2_table;
3488: l_org_id_tab dbms_sql.VARCHAR2_table;
3489: l_org_code_tab dbms_sql.VARCHAR2_table;
3490: l_rev_id_tab dbms_sql.VARCHAR2_table;
3491: l_rev_tab dbms_sql.VARCHAR2_table;
3492:
3485: l_segment_20 mtl_system_items_b.segment20%TYPE;
3486:
3487: l_item_id_tab dbms_sql.VARCHAR2_table;
3488: l_org_id_tab dbms_sql.VARCHAR2_table;
3489: l_org_code_tab dbms_sql.VARCHAR2_table;
3490: l_rev_id_tab dbms_sql.VARCHAR2_table;
3491: l_rev_tab dbms_sql.VARCHAR2_table;
3492:
3493: l_list_inv_id NUMBER;
3486:
3487: l_item_id_tab dbms_sql.VARCHAR2_table;
3488: l_org_id_tab dbms_sql.VARCHAR2_table;
3489: l_org_code_tab dbms_sql.VARCHAR2_table;
3490: l_rev_id_tab dbms_sql.VARCHAR2_table;
3491: l_rev_tab dbms_sql.VARCHAR2_table;
3492:
3493: l_list_inv_id NUMBER;
3494: l_list_org_id NUMBER;
3487: l_item_id_tab dbms_sql.VARCHAR2_table;
3488: l_org_id_tab dbms_sql.VARCHAR2_table;
3489: l_org_code_tab dbms_sql.VARCHAR2_table;
3490: l_rev_id_tab dbms_sql.VARCHAR2_table;
3491: l_rev_tab dbms_sql.VARCHAR2_table;
3492:
3493: l_list_inv_id NUMBER;
3494: l_list_org_id NUMBER;
3495: l_list_rev_id NUMBER;
3494: l_list_org_id NUMBER;
3495: l_list_rev_id NUMBER;
3496: l_list_rev_date DATE;
3497:
3498: l_segment_1_tab dbms_sql.VARCHAR2_table;
3499: l_segment_2_tab dbms_sql.VARCHAR2_table;
3500: l_segment_3_tab dbms_sql.VARCHAR2_table;
3501: l_segment_4_tab dbms_sql.VARCHAR2_table;
3502: l_segment_5_tab dbms_sql.VARCHAR2_table;
3495: l_list_rev_id NUMBER;
3496: l_list_rev_date DATE;
3497:
3498: l_segment_1_tab dbms_sql.VARCHAR2_table;
3499: l_segment_2_tab dbms_sql.VARCHAR2_table;
3500: l_segment_3_tab dbms_sql.VARCHAR2_table;
3501: l_segment_4_tab dbms_sql.VARCHAR2_table;
3502: l_segment_5_tab dbms_sql.VARCHAR2_table;
3503: l_segment_6_tab dbms_sql.VARCHAR2_table;
3496: l_list_rev_date DATE;
3497:
3498: l_segment_1_tab dbms_sql.VARCHAR2_table;
3499: l_segment_2_tab dbms_sql.VARCHAR2_table;
3500: l_segment_3_tab dbms_sql.VARCHAR2_table;
3501: l_segment_4_tab dbms_sql.VARCHAR2_table;
3502: l_segment_5_tab dbms_sql.VARCHAR2_table;
3503: l_segment_6_tab dbms_sql.VARCHAR2_table;
3504: l_segment_7_tab dbms_sql.VARCHAR2_table;
3497:
3498: l_segment_1_tab dbms_sql.VARCHAR2_table;
3499: l_segment_2_tab dbms_sql.VARCHAR2_table;
3500: l_segment_3_tab dbms_sql.VARCHAR2_table;
3501: l_segment_4_tab dbms_sql.VARCHAR2_table;
3502: l_segment_5_tab dbms_sql.VARCHAR2_table;
3503: l_segment_6_tab dbms_sql.VARCHAR2_table;
3504: l_segment_7_tab dbms_sql.VARCHAR2_table;
3505: l_segment_8_tab dbms_sql.VARCHAR2_table;
3498: l_segment_1_tab dbms_sql.VARCHAR2_table;
3499: l_segment_2_tab dbms_sql.VARCHAR2_table;
3500: l_segment_3_tab dbms_sql.VARCHAR2_table;
3501: l_segment_4_tab dbms_sql.VARCHAR2_table;
3502: l_segment_5_tab dbms_sql.VARCHAR2_table;
3503: l_segment_6_tab dbms_sql.VARCHAR2_table;
3504: l_segment_7_tab dbms_sql.VARCHAR2_table;
3505: l_segment_8_tab dbms_sql.VARCHAR2_table;
3506: l_segment_9_tab dbms_sql.VARCHAR2_table;
3499: l_segment_2_tab dbms_sql.VARCHAR2_table;
3500: l_segment_3_tab dbms_sql.VARCHAR2_table;
3501: l_segment_4_tab dbms_sql.VARCHAR2_table;
3502: l_segment_5_tab dbms_sql.VARCHAR2_table;
3503: l_segment_6_tab dbms_sql.VARCHAR2_table;
3504: l_segment_7_tab dbms_sql.VARCHAR2_table;
3505: l_segment_8_tab dbms_sql.VARCHAR2_table;
3506: l_segment_9_tab dbms_sql.VARCHAR2_table;
3507: l_segment_10_tab dbms_sql.VARCHAR2_table;
3500: l_segment_3_tab dbms_sql.VARCHAR2_table;
3501: l_segment_4_tab dbms_sql.VARCHAR2_table;
3502: l_segment_5_tab dbms_sql.VARCHAR2_table;
3503: l_segment_6_tab dbms_sql.VARCHAR2_table;
3504: l_segment_7_tab dbms_sql.VARCHAR2_table;
3505: l_segment_8_tab dbms_sql.VARCHAR2_table;
3506: l_segment_9_tab dbms_sql.VARCHAR2_table;
3507: l_segment_10_tab dbms_sql.VARCHAR2_table;
3508: l_segment_11_tab dbms_sql.VARCHAR2_table;
3501: l_segment_4_tab dbms_sql.VARCHAR2_table;
3502: l_segment_5_tab dbms_sql.VARCHAR2_table;
3503: l_segment_6_tab dbms_sql.VARCHAR2_table;
3504: l_segment_7_tab dbms_sql.VARCHAR2_table;
3505: l_segment_8_tab dbms_sql.VARCHAR2_table;
3506: l_segment_9_tab dbms_sql.VARCHAR2_table;
3507: l_segment_10_tab dbms_sql.VARCHAR2_table;
3508: l_segment_11_tab dbms_sql.VARCHAR2_table;
3509: l_segment_12_tab dbms_sql.VARCHAR2_table;
3502: l_segment_5_tab dbms_sql.VARCHAR2_table;
3503: l_segment_6_tab dbms_sql.VARCHAR2_table;
3504: l_segment_7_tab dbms_sql.VARCHAR2_table;
3505: l_segment_8_tab dbms_sql.VARCHAR2_table;
3506: l_segment_9_tab dbms_sql.VARCHAR2_table;
3507: l_segment_10_tab dbms_sql.VARCHAR2_table;
3508: l_segment_11_tab dbms_sql.VARCHAR2_table;
3509: l_segment_12_tab dbms_sql.VARCHAR2_table;
3510: l_segment_13_tab dbms_sql.VARCHAR2_table;
3503: l_segment_6_tab dbms_sql.VARCHAR2_table;
3504: l_segment_7_tab dbms_sql.VARCHAR2_table;
3505: l_segment_8_tab dbms_sql.VARCHAR2_table;
3506: l_segment_9_tab dbms_sql.VARCHAR2_table;
3507: l_segment_10_tab dbms_sql.VARCHAR2_table;
3508: l_segment_11_tab dbms_sql.VARCHAR2_table;
3509: l_segment_12_tab dbms_sql.VARCHAR2_table;
3510: l_segment_13_tab dbms_sql.VARCHAR2_table;
3511: l_segment_14_tab dbms_sql.VARCHAR2_table;
3504: l_segment_7_tab dbms_sql.VARCHAR2_table;
3505: l_segment_8_tab dbms_sql.VARCHAR2_table;
3506: l_segment_9_tab dbms_sql.VARCHAR2_table;
3507: l_segment_10_tab dbms_sql.VARCHAR2_table;
3508: l_segment_11_tab dbms_sql.VARCHAR2_table;
3509: l_segment_12_tab dbms_sql.VARCHAR2_table;
3510: l_segment_13_tab dbms_sql.VARCHAR2_table;
3511: l_segment_14_tab dbms_sql.VARCHAR2_table;
3512: l_segment_15_tab dbms_sql.VARCHAR2_table;
3505: l_segment_8_tab dbms_sql.VARCHAR2_table;
3506: l_segment_9_tab dbms_sql.VARCHAR2_table;
3507: l_segment_10_tab dbms_sql.VARCHAR2_table;
3508: l_segment_11_tab dbms_sql.VARCHAR2_table;
3509: l_segment_12_tab dbms_sql.VARCHAR2_table;
3510: l_segment_13_tab dbms_sql.VARCHAR2_table;
3511: l_segment_14_tab dbms_sql.VARCHAR2_table;
3512: l_segment_15_tab dbms_sql.VARCHAR2_table;
3513: l_segment_16_tab dbms_sql.VARCHAR2_table;
3506: l_segment_9_tab dbms_sql.VARCHAR2_table;
3507: l_segment_10_tab dbms_sql.VARCHAR2_table;
3508: l_segment_11_tab dbms_sql.VARCHAR2_table;
3509: l_segment_12_tab dbms_sql.VARCHAR2_table;
3510: l_segment_13_tab dbms_sql.VARCHAR2_table;
3511: l_segment_14_tab dbms_sql.VARCHAR2_table;
3512: l_segment_15_tab dbms_sql.VARCHAR2_table;
3513: l_segment_16_tab dbms_sql.VARCHAR2_table;
3514: l_segment_17_tab dbms_sql.VARCHAR2_table;
3507: l_segment_10_tab dbms_sql.VARCHAR2_table;
3508: l_segment_11_tab dbms_sql.VARCHAR2_table;
3509: l_segment_12_tab dbms_sql.VARCHAR2_table;
3510: l_segment_13_tab dbms_sql.VARCHAR2_table;
3511: l_segment_14_tab dbms_sql.VARCHAR2_table;
3512: l_segment_15_tab dbms_sql.VARCHAR2_table;
3513: l_segment_16_tab dbms_sql.VARCHAR2_table;
3514: l_segment_17_tab dbms_sql.VARCHAR2_table;
3515: l_segment_18_tab dbms_sql.VARCHAR2_table;
3508: l_segment_11_tab dbms_sql.VARCHAR2_table;
3509: l_segment_12_tab dbms_sql.VARCHAR2_table;
3510: l_segment_13_tab dbms_sql.VARCHAR2_table;
3511: l_segment_14_tab dbms_sql.VARCHAR2_table;
3512: l_segment_15_tab dbms_sql.VARCHAR2_table;
3513: l_segment_16_tab dbms_sql.VARCHAR2_table;
3514: l_segment_17_tab dbms_sql.VARCHAR2_table;
3515: l_segment_18_tab dbms_sql.VARCHAR2_table;
3516: l_segment_19_tab dbms_sql.VARCHAR2_table;
3509: l_segment_12_tab dbms_sql.VARCHAR2_table;
3510: l_segment_13_tab dbms_sql.VARCHAR2_table;
3511: l_segment_14_tab dbms_sql.VARCHAR2_table;
3512: l_segment_15_tab dbms_sql.VARCHAR2_table;
3513: l_segment_16_tab dbms_sql.VARCHAR2_table;
3514: l_segment_17_tab dbms_sql.VARCHAR2_table;
3515: l_segment_18_tab dbms_sql.VARCHAR2_table;
3516: l_segment_19_tab dbms_sql.VARCHAR2_table;
3517: l_segment_20_tab dbms_sql.VARCHAR2_table;
3510: l_segment_13_tab dbms_sql.VARCHAR2_table;
3511: l_segment_14_tab dbms_sql.VARCHAR2_table;
3512: l_segment_15_tab dbms_sql.VARCHAR2_table;
3513: l_segment_16_tab dbms_sql.VARCHAR2_table;
3514: l_segment_17_tab dbms_sql.VARCHAR2_table;
3515: l_segment_18_tab dbms_sql.VARCHAR2_table;
3516: l_segment_19_tab dbms_sql.VARCHAR2_table;
3517: l_segment_20_tab dbms_sql.VARCHAR2_table;
3518:
3511: l_segment_14_tab dbms_sql.VARCHAR2_table;
3512: l_segment_15_tab dbms_sql.VARCHAR2_table;
3513: l_segment_16_tab dbms_sql.VARCHAR2_table;
3514: l_segment_17_tab dbms_sql.VARCHAR2_table;
3515: l_segment_18_tab dbms_sql.VARCHAR2_table;
3516: l_segment_19_tab dbms_sql.VARCHAR2_table;
3517: l_segment_20_tab dbms_sql.VARCHAR2_table;
3518:
3519: v_is_valid_item BOOLEAN;
3512: l_segment_15_tab dbms_sql.VARCHAR2_table;
3513: l_segment_16_tab dbms_sql.VARCHAR2_table;
3514: l_segment_17_tab dbms_sql.VARCHAR2_table;
3515: l_segment_18_tab dbms_sql.VARCHAR2_table;
3516: l_segment_19_tab dbms_sql.VARCHAR2_table;
3517: l_segment_20_tab dbms_sql.VARCHAR2_table;
3518:
3519: v_is_valid_item BOOLEAN;
3520: v_is_valid_org BOOLEAN;
3513: l_segment_16_tab dbms_sql.VARCHAR2_table;
3514: l_segment_17_tab dbms_sql.VARCHAR2_table;
3515: l_segment_18_tab dbms_sql.VARCHAR2_table;
3516: l_segment_19_tab dbms_sql.VARCHAR2_table;
3517: l_segment_20_tab dbms_sql.VARCHAR2_table;
3518:
3519: v_is_valid_item BOOLEAN;
3520: v_is_valid_org BOOLEAN;
3521: v_is_valid_rev BOOLEAN;