DBA Data[Home] [Help]

APPS.EGO_ITEM_WS_PVT dependencies on DBMS_SQL

Line 1836: l_item_id_tab dbms_sql.VARCHAR2_table;

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

Line 1837: l_org_id_tab dbms_sql.VARCHAR2_table;

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:

Line 1838: l_rev_id_tab dbms_sql.VARCHAR2_table;

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;

Line 1839: l_seq_num_tab dbms_sql.VARCHAR2_table;

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;

Line 1840: l_rev_date_tab dbms_sql.VARCHAR2_table; -- Bug 8659192

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;

Line 2343: l_lang_code_tab dbms_sql.varchar2_table;

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;

Line 2344: l_lang_name_tab dbms_sql.varchar2_table; -- Bug 8670897

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;

Line 2345: l_uda_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:

Line 2346: l_uda_attr_id_tab dbms_sql.varchar2_table;

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);

Line 2347: l_ta_attr_id_tab dbms_sql.varchar2_table;

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:

Line 2348: l_ta_attr_name_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:
2352: l_node_exists NUMBER;

Line 3487: l_item_id_tab dbms_sql.VARCHAR2_table;

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;

Line 3488: l_org_id_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:

Line 3489: l_org_code_tab dbms_sql.VARCHAR2_table;

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;

Line 3490: l_rev_id_tab dbms_sql.VARCHAR2_table;

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;

Line 3491: l_rev_tab dbms_sql.VARCHAR2_table;

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;

Line 3498: l_segment_1_tab dbms_sql.VARCHAR2_table;

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;

Line 3499: l_segment_2_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;

Line 3500: l_segment_3_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;

Line 3501: l_segment_4_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;

Line 3502: l_segment_5_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;

Line 3503: l_segment_6_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;

Line 3504: l_segment_7_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;

Line 3505: l_segment_8_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;

Line 3506: l_segment_9_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;

Line 3507: l_segment_10_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;

Line 3508: l_segment_11_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;

Line 3509: l_segment_12_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;

Line 3510: l_segment_13_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;

Line 3511: l_segment_14_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;

Line 3512: l_segment_15_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;

Line 3513: l_segment_16_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;

Line 3514: l_segment_17_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:

Line 3515: l_segment_18_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:
3519: v_is_valid_item BOOLEAN;

Line 3516: l_segment_19_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;
3520: v_is_valid_org BOOLEAN;

Line 3517: l_segment_20_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;
3521: v_is_valid_rev BOOLEAN;