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_MI_PVT dependencies on DBMS_SQL

Line 947: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;

943: l_item_type VARCHAR2(8);
944: l_current_ctx_item_rec ICX_CAT_POPULATE_ITEM_PVT.g_ctx_item_rec_type;
945:
946: ----- Start of declaring columns selected in the cursor -----
947: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
948: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
949: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
950: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
951: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 948: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;

944: l_current_ctx_item_rec ICX_CAT_POPULATE_ITEM_PVT.g_ctx_item_rec_type;
945:
946: ----- Start of declaring columns selected in the cursor -----
947: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
948: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
949: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
950: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
951: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
952: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 949: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;

945:
946: ----- Start of declaring columns selected in the cursor -----
947: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
948: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
949: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
950: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
951: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
952: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
953: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 950: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;

946: ----- Start of declaring columns selected in the cursor -----
947: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
948: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
949: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
950: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
951: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
952: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
953: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
954: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 951: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;

947: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
948: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
949: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
950: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
951: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
952: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
953: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
954: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
955: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 952: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;

948: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
949: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
950: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
951: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
952: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
953: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
954: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
955: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
956: l_category_key_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 953: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;

949: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
950: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
951: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
952: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
953: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
954: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
955: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
956: l_category_key_tbl DBMS_SQL.VARCHAR2_TABLE;
957: l_intrnl_order_enbld_flag_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 954: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;

950: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
951: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
952: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
953: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
954: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
955: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
956: l_category_key_tbl DBMS_SQL.VARCHAR2_TABLE;
957: l_intrnl_order_enbld_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
958: l_purchasing_enabled_flag_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 955: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;

951: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
952: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
953: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
954: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
955: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
956: l_category_key_tbl DBMS_SQL.VARCHAR2_TABLE;
957: l_intrnl_order_enbld_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
958: l_purchasing_enabled_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
959: l_outside_operation_flag_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 956: l_category_key_tbl DBMS_SQL.VARCHAR2_TABLE;

952: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
953: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
954: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
955: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
956: l_category_key_tbl DBMS_SQL.VARCHAR2_TABLE;
957: l_intrnl_order_enbld_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
958: l_purchasing_enabled_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
959: l_outside_operation_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
960: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 957: l_intrnl_order_enbld_flag_tbl DBMS_SQL.VARCHAR2_TABLE;

953: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
954: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
955: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
956: l_category_key_tbl DBMS_SQL.VARCHAR2_TABLE;
957: l_intrnl_order_enbld_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
958: l_purchasing_enabled_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
959: l_outside_operation_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
960: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
961: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 958: l_purchasing_enabled_flag_tbl DBMS_SQL.VARCHAR2_TABLE;

954: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
955: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
956: l_category_key_tbl DBMS_SQL.VARCHAR2_TABLE;
957: l_intrnl_order_enbld_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
958: l_purchasing_enabled_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
959: l_outside_operation_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
960: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
961: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
962: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 959: l_outside_operation_flag_tbl DBMS_SQL.VARCHAR2_TABLE;

955: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
956: l_category_key_tbl DBMS_SQL.VARCHAR2_TABLE;
957: l_intrnl_order_enbld_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
958: l_purchasing_enabled_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
959: l_outside_operation_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
960: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
961: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
962: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
963: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;

Line 960: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;

956: l_category_key_tbl DBMS_SQL.VARCHAR2_TABLE;
957: l_intrnl_order_enbld_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
958: l_purchasing_enabled_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
959: l_outside_operation_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
960: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
961: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
962: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
963: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
964: l_rfq_required_flag_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 961: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;

957: l_intrnl_order_enbld_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
958: l_purchasing_enabled_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
959: l_outside_operation_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
960: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
961: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
962: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
963: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
964: l_rfq_required_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
965: l_description_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 962: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;

958: l_purchasing_enabled_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
959: l_outside_operation_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
960: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
961: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
962: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
963: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
964: l_rfq_required_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
965: l_description_tbl DBMS_SQL.VARCHAR2_TABLE;
966: --Bug6599217

Line 963: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;

959: l_outside_operation_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
960: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
961: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
962: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
963: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
964: l_rfq_required_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
965: l_description_tbl DBMS_SQL.VARCHAR2_TABLE;
966: --Bug6599217
967: l_long_description_tbl ICX_CAT_POPULATE_MI_PVT.VARCHAR4_TABLE;

Line 964: l_rfq_required_flag_tbl DBMS_SQL.VARCHAR2_TABLE;

960: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
961: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
962: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
963: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
964: l_rfq_required_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
965: l_description_tbl DBMS_SQL.VARCHAR2_TABLE;
966: --Bug6599217
967: l_long_description_tbl ICX_CAT_POPULATE_MI_PVT.VARCHAR4_TABLE;
968: l_organization_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 965: l_description_tbl DBMS_SQL.VARCHAR2_TABLE;

961: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
962: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
963: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
964: l_rfq_required_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
965: l_description_tbl DBMS_SQL.VARCHAR2_TABLE;
966: --Bug6599217
967: l_long_description_tbl ICX_CAT_POPULATE_MI_PVT.VARCHAR4_TABLE;
968: l_organization_id_tbl DBMS_SQL.NUMBER_TABLE;
969: l_master_organization_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 968: l_organization_id_tbl DBMS_SQL.NUMBER_TABLE;

964: l_rfq_required_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
965: l_description_tbl DBMS_SQL.VARCHAR2_TABLE;
966: --Bug6599217
967: l_long_description_tbl ICX_CAT_POPULATE_MI_PVT.VARCHAR4_TABLE;
968: l_organization_id_tbl DBMS_SQL.NUMBER_TABLE;
969: l_master_organization_id_tbl DBMS_SQL.NUMBER_TABLE;
970: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
971: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
972: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 969: l_master_organization_id_tbl DBMS_SQL.NUMBER_TABLE;

965: l_description_tbl DBMS_SQL.VARCHAR2_TABLE;
966: --Bug6599217
967: l_long_description_tbl ICX_CAT_POPULATE_MI_PVT.VARCHAR4_TABLE;
968: l_organization_id_tbl DBMS_SQL.NUMBER_TABLE;
969: l_master_organization_id_tbl DBMS_SQL.NUMBER_TABLE;
970: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
971: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
972: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
973: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 970: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;

966: --Bug6599217
967: l_long_description_tbl ICX_CAT_POPULATE_MI_PVT.VARCHAR4_TABLE;
968: l_organization_id_tbl DBMS_SQL.NUMBER_TABLE;
969: l_master_organization_id_tbl DBMS_SQL.NUMBER_TABLE;
970: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
971: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
972: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
973: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
974: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 971: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;

967: l_long_description_tbl ICX_CAT_POPULATE_MI_PVT.VARCHAR4_TABLE;
968: l_organization_id_tbl DBMS_SQL.NUMBER_TABLE;
969: l_master_organization_id_tbl DBMS_SQL.NUMBER_TABLE;
970: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
971: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
972: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
973: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
974: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
975: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 972: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;

968: l_organization_id_tbl DBMS_SQL.NUMBER_TABLE;
969: l_master_organization_id_tbl DBMS_SQL.NUMBER_TABLE;
970: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
971: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
972: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
973: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
974: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
975: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
976: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 973: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;

969: l_master_organization_id_tbl DBMS_SQL.NUMBER_TABLE;
970: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
971: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
972: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
973: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
974: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
975: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
976: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
977: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 974: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;

970: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
971: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
972: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
973: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
974: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
975: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
976: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
977: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
978: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 975: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;

971: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
972: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
973: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
974: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
975: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
976: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
977: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
978: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
979: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 976: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;

972: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
973: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
974: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
975: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
976: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
977: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
978: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
979: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
980: l_ctx_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 977: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;

973: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
974: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
975: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
976: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
977: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
978: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
979: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
980: l_ctx_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
981: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;

Line 978: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;

974: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
975: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
976: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
977: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
978: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
979: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
980: l_ctx_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
981: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;
982: ------ End of declaring columns selected in the cursor ------

Line 979: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;

975: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
976: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
977: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
978: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
979: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
980: l_ctx_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
981: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;
982: ------ End of declaring columns selected in the cursor ------
983:

Line 980: l_ctx_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;

976: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
977: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
978: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
979: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
980: l_ctx_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
981: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;
982: ------ End of declaring columns selected in the cursor ------
983:
984: BEGIN

Line 981: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;

977: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
978: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
979: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
980: l_ctx_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
981: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;
982: ------ End of declaring columns selected in the cursor ------
983:
984: BEGIN
985: l_err_loc := 100;

Line 1445: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;

1441: AND fsp.inventory_organization_id = mparams.organization_id
1442: AND fsp.org_id = ctx.org_id;
1443:
1444: ----- Start of declaring columns selected in the cursor -----
1445: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1446: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1447: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
1448: ------ End of declaring columns selected in the cursor ------
1449:

Line 1446: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;

1442: AND fsp.org_id = ctx.org_id;
1443:
1444: ----- Start of declaring columns selected in the cursor -----
1445: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1446: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1447: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
1448: ------ End of declaring columns selected in the cursor ------
1449:
1450: l_api_name CONSTANT VARCHAR2(30) := 'populateItemDelete';

Line 1447: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;

1443:
1444: ----- Start of declaring columns selected in the cursor -----
1445: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1446: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1447: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
1448: ------ End of declaring columns selected in the cursor ------
1449:
1450: l_api_name CONSTANT VARCHAR2(30) := 'populateItemDelete';
1451: l_err_loc PLS_INTEGER;

Line 1604: ( P_MTL_CATEGORY_ID_TBL IN DBMS_SQL.NUMBER_TABLE

1600: RAISE;
1601: END populateItemCatgDelete;
1602:
1603: PROCEDURE populateCategoryItems
1604: ( P_MTL_CATEGORY_ID_TBL IN DBMS_SQL.NUMBER_TABLE
1605: )
1606: IS
1607: l_api_name CONSTANT VARCHAR2(30) := 'populateCategoryItems';
1608: l_err_loc PLS_INTEGER;