eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ICX_CAT_POPULATE_CATG_PVT dependencies on DBMS_SQL

Line 11: gInsMapRtCategoryIdTbl DBMS_SQL.NUMBER_TABLE;

7:
8: gTotalRowCount PLS_INTEGER:= 0;
9:
10: -- Insert into icx_por_category_data_sources and icx_por_category_order_map
11: gInsMapRtCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
12: gInsMapCategoryKeyTbl DBMS_SQL.VARCHAR2_TABLE;
13: gInsMapLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
14:
15: -- Insert into icx_cat_categories_tl

Line 12: gInsMapCategoryKeyTbl DBMS_SQL.VARCHAR2_TABLE;

8: gTotalRowCount PLS_INTEGER:= 0;
9:
10: -- Insert into icx_por_category_data_sources and icx_por_category_order_map
11: gInsMapRtCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
12: gInsMapCategoryKeyTbl DBMS_SQL.VARCHAR2_TABLE;
13: gInsMapLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
14:
15: -- Insert into icx_cat_categories_tl
16: gInsRtCategoryIdTbl DBMS_SQL.NUMBER_TABLE;

Line 13: gInsMapLanguageTbl DBMS_SQL.VARCHAR2_TABLE;

9:
10: -- Insert into icx_por_category_data_sources and icx_por_category_order_map
11: gInsMapRtCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
12: gInsMapCategoryKeyTbl DBMS_SQL.VARCHAR2_TABLE;
13: gInsMapLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
14:
15: -- Insert into icx_cat_categories_tl
16: gInsRtCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
17: gInsCategoryKeyTbl DBMS_SQL.VARCHAR2_TABLE;

Line 16: gInsRtCategoryIdTbl DBMS_SQL.NUMBER_TABLE;

12: gInsMapCategoryKeyTbl DBMS_SQL.VARCHAR2_TABLE;
13: gInsMapLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
14:
15: -- Insert into icx_cat_categories_tl
16: gInsRtCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
17: gInsCategoryKeyTbl DBMS_SQL.VARCHAR2_TABLE;
18: gInsCategoryNameTbl DBMS_SQL.VARCHAR2_TABLE;
19: gInsLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
20: gInsSourceLangTbl DBMS_SQL.VARCHAR2_TABLE;

Line 17: gInsCategoryKeyTbl DBMS_SQL.VARCHAR2_TABLE;

13: gInsMapLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
14:
15: -- Insert into icx_cat_categories_tl
16: gInsRtCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
17: gInsCategoryKeyTbl DBMS_SQL.VARCHAR2_TABLE;
18: gInsCategoryNameTbl DBMS_SQL.VARCHAR2_TABLE;
19: gInsLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
20: gInsSourceLangTbl DBMS_SQL.VARCHAR2_TABLE;
21:

Line 18: gInsCategoryNameTbl DBMS_SQL.VARCHAR2_TABLE;

14:
15: -- Insert into icx_cat_categories_tl
16: gInsRtCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
17: gInsCategoryKeyTbl DBMS_SQL.VARCHAR2_TABLE;
18: gInsCategoryNameTbl DBMS_SQL.VARCHAR2_TABLE;
19: gInsLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
20: gInsSourceLangTbl DBMS_SQL.VARCHAR2_TABLE;
21:
22: -- Insert items into icx_cat_items_ctx_hdrs_tlp and icx_cat_items_ctx_dtls_tlp tables

Line 19: gInsLanguageTbl DBMS_SQL.VARCHAR2_TABLE;

15: -- Insert into icx_cat_categories_tl
16: gInsRtCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
17: gInsCategoryKeyTbl DBMS_SQL.VARCHAR2_TABLE;
18: gInsCategoryNameTbl DBMS_SQL.VARCHAR2_TABLE;
19: gInsLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
20: gInsSourceLangTbl DBMS_SQL.VARCHAR2_TABLE;
21:
22: -- Insert items into icx_cat_items_ctx_hdrs_tlp and icx_cat_items_ctx_dtls_tlp tables
23: gInsPOCategoryIdTbl DBMS_SQL.NUMBER_TABLE;

Line 20: gInsSourceLangTbl DBMS_SQL.VARCHAR2_TABLE;

16: gInsRtCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
17: gInsCategoryKeyTbl DBMS_SQL.VARCHAR2_TABLE;
18: gInsCategoryNameTbl DBMS_SQL.VARCHAR2_TABLE;
19: gInsLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
20: gInsSourceLangTbl DBMS_SQL.VARCHAR2_TABLE;
21:
22: -- Insert items into icx_cat_items_ctx_hdrs_tlp and icx_cat_items_ctx_dtls_tlp tables
23: gInsPOCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
24:

Line 23: gInsPOCategoryIdTbl DBMS_SQL.NUMBER_TABLE;

19: gInsLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
20: gInsSourceLangTbl DBMS_SQL.VARCHAR2_TABLE;
21:
22: -- Insert items into icx_cat_items_ctx_hdrs_tlp and icx_cat_items_ctx_dtls_tlp tables
23: gInsPOCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
24:
25: -- Update icx_cat_categories_tl
26: gUpdRtCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
27: gUpdCategoryNameTbl DBMS_SQL.VARCHAR2_TABLE;

Line 26: gUpdRtCategoryIdTbl DBMS_SQL.NUMBER_TABLE;

22: -- Insert items into icx_cat_items_ctx_hdrs_tlp and icx_cat_items_ctx_dtls_tlp tables
23: gInsPOCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
24:
25: -- Update icx_cat_categories_tl
26: gUpdRtCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
27: gUpdCategoryNameTbl DBMS_SQL.VARCHAR2_TABLE;
28: gUpdLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
29: gUpdSourceLangTbl DBMS_SQL.VARCHAR2_TABLE;
30:

Line 27: gUpdCategoryNameTbl DBMS_SQL.VARCHAR2_TABLE;

23: gInsPOCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
24:
25: -- Update icx_cat_categories_tl
26: gUpdRtCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
27: gUpdCategoryNameTbl DBMS_SQL.VARCHAR2_TABLE;
28: gUpdLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
29: gUpdSourceLangTbl DBMS_SQL.VARCHAR2_TABLE;
30:
31: -- Delete from icx_cat_items_ctx_hdrs_tlp and icx_cat_items_ctx_dtls_tlp tables

Line 28: gUpdLanguageTbl DBMS_SQL.VARCHAR2_TABLE;

24:
25: -- Update icx_cat_categories_tl
26: gUpdRtCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
27: gUpdCategoryNameTbl DBMS_SQL.VARCHAR2_TABLE;
28: gUpdLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
29: gUpdSourceLangTbl DBMS_SQL.VARCHAR2_TABLE;
30:
31: -- Delete from icx_cat_items_ctx_hdrs_tlp and icx_cat_items_ctx_dtls_tlp tables
32: gDelPoCategoryIdTbl DBMS_SQL.NUMBER_TABLE;

Line 29: gUpdSourceLangTbl DBMS_SQL.VARCHAR2_TABLE;

25: -- Update icx_cat_categories_tl
26: gUpdRtCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
27: gUpdCategoryNameTbl DBMS_SQL.VARCHAR2_TABLE;
28: gUpdLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
29: gUpdSourceLangTbl DBMS_SQL.VARCHAR2_TABLE;
30:
31: -- Delete from icx_cat_items_ctx_hdrs_tlp and icx_cat_items_ctx_dtls_tlp tables
32: gDelPoCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
33:

Line 32: gDelPoCategoryIdTbl DBMS_SQL.NUMBER_TABLE;

28: gUpdLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
29: gUpdSourceLangTbl DBMS_SQL.VARCHAR2_TABLE;
30:
31: -- Delete from icx_cat_items_ctx_hdrs_tlp and icx_cat_items_ctx_dtls_tlp tables
32: gDelPoCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
33:
34: PROCEDURE clearTables
35: ( p_action_mode IN VARCHAR2
36: )

Line 391: l_rowid_tbl DBMS_SQL.UROWID_TABLE;

387: IS
388:
389: l_api_name CONSTANT VARCHAR2(30) := 'updateCategories';
390: l_continue BOOLEAN := TRUE;
391: l_rowid_tbl DBMS_SQL.UROWID_TABLE;
392: l_err_loc PLS_INTEGER;
393: l_action_mode VARCHAR2(80);
394: l_searchable NUMBER;
395: l_section_tag NUMBER;

Line 561: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;

557: IS
558:
559: l_api_name CONSTANT VARCHAR2(30) := 'deleteCategories';
560: l_continue BOOLEAN := TRUE;
561: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
562: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
563: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
564: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
565: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 562: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;

558:
559: l_api_name CONSTANT VARCHAR2(30) := 'deleteCategories';
560: l_continue BOOLEAN := TRUE;
561: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
562: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
563: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
564: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
565: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
566: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 563: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;

559: l_api_name CONSTANT VARCHAR2(30) := 'deleteCategories';
560: l_continue BOOLEAN := TRUE;
561: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
562: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
563: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
564: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
565: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
566: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
567: l_err_loc PLS_INTEGER;

Line 564: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;

560: l_continue BOOLEAN := TRUE;
561: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
562: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
563: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
564: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
565: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
566: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
567: l_err_loc PLS_INTEGER;
568: l_action_mode VARCHAR2(80);

Line 565: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;

561: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
562: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
563: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
564: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
565: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
566: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
567: l_err_loc PLS_INTEGER;
568: l_action_mode VARCHAR2(80);
569: l_row_count PLS_INTEGER;

Line 566: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;

562: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
563: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
564: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
565: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
566: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
567: l_err_loc PLS_INTEGER;
568: l_action_mode VARCHAR2(80);
569: l_row_count PLS_INTEGER;
570: BEGIN

Line 804: l_mtl_category_id_tbl DBMS_SQL.NUMBER_TABLE;

800: l_index PLS_INTEGER;
801: l_category_name_is_valid BOOLEAN := FALSE;
802:
803: ----- Start of declaring columns selected in the cursor -----
804: l_mtl_category_id_tbl DBMS_SQL.NUMBER_TABLE;
805: l_mtl_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
806: l_mtl_language_tbl DBMS_SQL.VARCHAR2_TABLE;
807: l_mtl_source_lang_tbl DBMS_SQL.VARCHAR2_TABLE;
808: l_rt_category_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 805: l_mtl_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;

801: l_category_name_is_valid BOOLEAN := FALSE;
802:
803: ----- Start of declaring columns selected in the cursor -----
804: l_mtl_category_id_tbl DBMS_SQL.NUMBER_TABLE;
805: l_mtl_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
806: l_mtl_language_tbl DBMS_SQL.VARCHAR2_TABLE;
807: l_mtl_source_lang_tbl DBMS_SQL.VARCHAR2_TABLE;
808: l_rt_category_id_tbl DBMS_SQL.NUMBER_TABLE;
809: l_old_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 806: l_mtl_language_tbl DBMS_SQL.VARCHAR2_TABLE;

802:
803: ----- Start of declaring columns selected in the cursor -----
804: l_mtl_category_id_tbl DBMS_SQL.NUMBER_TABLE;
805: l_mtl_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
806: l_mtl_language_tbl DBMS_SQL.VARCHAR2_TABLE;
807: l_mtl_source_lang_tbl DBMS_SQL.VARCHAR2_TABLE;
808: l_rt_category_id_tbl DBMS_SQL.NUMBER_TABLE;
809: l_old_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
810: l_end_date_active_tbl DBMS_SQL.DATE_TABLE;

Line 807: l_mtl_source_lang_tbl DBMS_SQL.VARCHAR2_TABLE;

803: ----- Start of declaring columns selected in the cursor -----
804: l_mtl_category_id_tbl DBMS_SQL.NUMBER_TABLE;
805: l_mtl_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
806: l_mtl_language_tbl DBMS_SQL.VARCHAR2_TABLE;
807: l_mtl_source_lang_tbl DBMS_SQL.VARCHAR2_TABLE;
808: l_rt_category_id_tbl DBMS_SQL.NUMBER_TABLE;
809: l_old_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
810: l_end_date_active_tbl DBMS_SQL.DATE_TABLE;
811: l_disable_date_tbl DBMS_SQL.DATE_TABLE;

Line 808: l_rt_category_id_tbl DBMS_SQL.NUMBER_TABLE;

804: l_mtl_category_id_tbl DBMS_SQL.NUMBER_TABLE;
805: l_mtl_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
806: l_mtl_language_tbl DBMS_SQL.VARCHAR2_TABLE;
807: l_mtl_source_lang_tbl DBMS_SQL.VARCHAR2_TABLE;
808: l_rt_category_id_tbl DBMS_SQL.NUMBER_TABLE;
809: l_old_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
810: l_end_date_active_tbl DBMS_SQL.DATE_TABLE;
811: l_disable_date_tbl DBMS_SQL.DATE_TABLE;
812: l_system_date_tbl DBMS_SQL.DATE_TABLE;

Line 809: l_old_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;

805: l_mtl_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
806: l_mtl_language_tbl DBMS_SQL.VARCHAR2_TABLE;
807: l_mtl_source_lang_tbl DBMS_SQL.VARCHAR2_TABLE;
808: l_rt_category_id_tbl DBMS_SQL.NUMBER_TABLE;
809: l_old_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
810: l_end_date_active_tbl DBMS_SQL.DATE_TABLE;
811: l_disable_date_tbl DBMS_SQL.DATE_TABLE;
812: l_system_date_tbl DBMS_SQL.DATE_TABLE;
813:

Line 810: l_end_date_active_tbl DBMS_SQL.DATE_TABLE;

806: l_mtl_language_tbl DBMS_SQL.VARCHAR2_TABLE;
807: l_mtl_source_lang_tbl DBMS_SQL.VARCHAR2_TABLE;
808: l_rt_category_id_tbl DBMS_SQL.NUMBER_TABLE;
809: l_old_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
810: l_end_date_active_tbl DBMS_SQL.DATE_TABLE;
811: l_disable_date_tbl DBMS_SQL.DATE_TABLE;
812: l_system_date_tbl DBMS_SQL.DATE_TABLE;
813:
814: ------ End of declaring columns selected in the cursor ------

Line 811: l_disable_date_tbl DBMS_SQL.DATE_TABLE;

807: l_mtl_source_lang_tbl DBMS_SQL.VARCHAR2_TABLE;
808: l_rt_category_id_tbl DBMS_SQL.NUMBER_TABLE;
809: l_old_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
810: l_end_date_active_tbl DBMS_SQL.DATE_TABLE;
811: l_disable_date_tbl DBMS_SQL.DATE_TABLE;
812: l_system_date_tbl DBMS_SQL.DATE_TABLE;
813:
814: ------ End of declaring columns selected in the cursor ------
815:

Line 812: l_system_date_tbl DBMS_SQL.DATE_TABLE;

808: l_rt_category_id_tbl DBMS_SQL.NUMBER_TABLE;
809: l_old_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
810: l_end_date_active_tbl DBMS_SQL.DATE_TABLE;
811: l_disable_date_tbl DBMS_SQL.DATE_TABLE;
812: l_system_date_tbl DBMS_SQL.DATE_TABLE;
813:
814: ------ End of declaring columns selected in the cursor ------
815:
816: BEGIN