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 941: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;

937: l_item_type VARCHAR2(8);
938: l_current_ctx_item_rec ICX_CAT_POPULATE_ITEM_PVT.g_ctx_item_rec_type;
939:
940: ----- Start of declaring columns selected in the cursor -----
941: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
942: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
943: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
944: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
945: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 942: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;

938: l_current_ctx_item_rec ICX_CAT_POPULATE_ITEM_PVT.g_ctx_item_rec_type;
939:
940: ----- Start of declaring columns selected in the cursor -----
941: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
942: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
943: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
944: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
945: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
946: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 943: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;

939:
940: ----- Start of declaring columns selected in the cursor -----
941: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
942: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
943: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
944: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
945: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
946: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
947: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 944: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;

940: ----- Start of declaring columns selected in the cursor -----
941: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
942: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
943: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
944: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
945: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
946: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
947: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
948: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 945: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;

941: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
942: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
943: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
944: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
945: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
946: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
947: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
948: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
949: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 946: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;

942: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
943: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
944: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
945: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
946: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
947: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
948: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
949: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
950: l_category_key_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 947: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;

943: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
944: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
945: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
946: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
947: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
948: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
949: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
950: l_category_key_tbl DBMS_SQL.VARCHAR2_TABLE;
951: l_intrnl_order_enbld_flag_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 948: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;

944: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
945: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
946: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
947: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
948: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
949: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
950: l_category_key_tbl DBMS_SQL.VARCHAR2_TABLE;
951: l_intrnl_order_enbld_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
952: l_purchasing_enabled_flag_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 949: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;

945: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
946: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
947: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
948: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
949: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
950: l_category_key_tbl DBMS_SQL.VARCHAR2_TABLE;
951: l_intrnl_order_enbld_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
952: l_purchasing_enabled_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
953: l_outside_operation_flag_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 950: l_category_key_tbl DBMS_SQL.VARCHAR2_TABLE;

946: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
947: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
948: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
949: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
950: l_category_key_tbl DBMS_SQL.VARCHAR2_TABLE;
951: l_intrnl_order_enbld_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
952: l_purchasing_enabled_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
953: l_outside_operation_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
954: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 951: l_intrnl_order_enbld_flag_tbl DBMS_SQL.VARCHAR2_TABLE;

947: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
948: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
949: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
950: l_category_key_tbl DBMS_SQL.VARCHAR2_TABLE;
951: l_intrnl_order_enbld_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
952: l_purchasing_enabled_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
953: l_outside_operation_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
954: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
955: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 952: l_purchasing_enabled_flag_tbl DBMS_SQL.VARCHAR2_TABLE;

948: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
949: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
950: l_category_key_tbl DBMS_SQL.VARCHAR2_TABLE;
951: l_intrnl_order_enbld_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
952: l_purchasing_enabled_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
953: l_outside_operation_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
954: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
955: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
956: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 953: l_outside_operation_flag_tbl DBMS_SQL.VARCHAR2_TABLE;

949: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
950: l_category_key_tbl DBMS_SQL.VARCHAR2_TABLE;
951: l_intrnl_order_enbld_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
952: l_purchasing_enabled_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
953: l_outside_operation_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
954: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
955: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
956: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
957: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;

Line 954: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;

950: l_category_key_tbl DBMS_SQL.VARCHAR2_TABLE;
951: l_intrnl_order_enbld_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
952: l_purchasing_enabled_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
953: l_outside_operation_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
954: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
955: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
956: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
957: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
958: l_rfq_required_flag_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 955: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;

951: l_intrnl_order_enbld_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
952: l_purchasing_enabled_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
953: l_outside_operation_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
954: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
955: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
956: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
957: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
958: l_rfq_required_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
959: l_description_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 956: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;

952: l_purchasing_enabled_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
953: l_outside_operation_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
954: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
955: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
956: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
957: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
958: l_rfq_required_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
959: l_description_tbl DBMS_SQL.VARCHAR2_TABLE;
960: --Bug6599217

Line 957: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;

953: l_outside_operation_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
954: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
955: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
956: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
957: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
958: l_rfq_required_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
959: l_description_tbl DBMS_SQL.VARCHAR2_TABLE;
960: --Bug6599217
961: l_long_description_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 958: l_rfq_required_flag_tbl DBMS_SQL.VARCHAR2_TABLE;

954: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
955: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
956: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
957: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
958: l_rfq_required_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
959: l_description_tbl DBMS_SQL.VARCHAR2_TABLE;
960: --Bug6599217
961: l_long_description_tbl DBMS_SQL.VARCHAR2_TABLE;
962: l_organization_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 959: l_description_tbl DBMS_SQL.VARCHAR2_TABLE;

955: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
956: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
957: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
958: l_rfq_required_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
959: l_description_tbl DBMS_SQL.VARCHAR2_TABLE;
960: --Bug6599217
961: l_long_description_tbl DBMS_SQL.VARCHAR2_TABLE;
962: l_organization_id_tbl DBMS_SQL.NUMBER_TABLE;
963: l_master_organization_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 961: l_long_description_tbl DBMS_SQL.VARCHAR2_TABLE;

957: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
958: l_rfq_required_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
959: l_description_tbl DBMS_SQL.VARCHAR2_TABLE;
960: --Bug6599217
961: l_long_description_tbl DBMS_SQL.VARCHAR2_TABLE;
962: l_organization_id_tbl DBMS_SQL.NUMBER_TABLE;
963: l_master_organization_id_tbl DBMS_SQL.NUMBER_TABLE;
964: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
965: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 962: l_organization_id_tbl DBMS_SQL.NUMBER_TABLE;

958: l_rfq_required_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
959: l_description_tbl DBMS_SQL.VARCHAR2_TABLE;
960: --Bug6599217
961: l_long_description_tbl DBMS_SQL.VARCHAR2_TABLE;
962: l_organization_id_tbl DBMS_SQL.NUMBER_TABLE;
963: l_master_organization_id_tbl DBMS_SQL.NUMBER_TABLE;
964: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
965: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
966: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 963: l_master_organization_id_tbl DBMS_SQL.NUMBER_TABLE;

959: l_description_tbl DBMS_SQL.VARCHAR2_TABLE;
960: --Bug6599217
961: l_long_description_tbl DBMS_SQL.VARCHAR2_TABLE;
962: l_organization_id_tbl DBMS_SQL.NUMBER_TABLE;
963: l_master_organization_id_tbl DBMS_SQL.NUMBER_TABLE;
964: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
965: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
966: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
967: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 964: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;

960: --Bug6599217
961: l_long_description_tbl DBMS_SQL.VARCHAR2_TABLE;
962: l_organization_id_tbl DBMS_SQL.NUMBER_TABLE;
963: l_master_organization_id_tbl DBMS_SQL.NUMBER_TABLE;
964: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
965: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
966: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
967: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
968: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 965: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;

961: l_long_description_tbl DBMS_SQL.VARCHAR2_TABLE;
962: l_organization_id_tbl DBMS_SQL.NUMBER_TABLE;
963: l_master_organization_id_tbl DBMS_SQL.NUMBER_TABLE;
964: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
965: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
966: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
967: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
968: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
969: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 966: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;

962: l_organization_id_tbl DBMS_SQL.NUMBER_TABLE;
963: l_master_organization_id_tbl DBMS_SQL.NUMBER_TABLE;
964: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
965: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
966: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
967: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
968: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
969: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
970: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 967: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;

963: l_master_organization_id_tbl DBMS_SQL.NUMBER_TABLE;
964: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
965: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
966: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
967: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
968: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
969: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
970: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
971: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 968: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;

964: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
965: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
966: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
967: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
968: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
969: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
970: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
971: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
972: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 969: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;

965: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
966: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
967: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
968: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
969: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
970: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
971: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
972: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
973: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 970: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;

966: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
967: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
968: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
969: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
970: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
971: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
972: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
973: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
974: l_ctx_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 971: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;

967: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
968: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
969: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
970: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
971: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
972: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
973: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
974: l_ctx_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
975: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;

Line 972: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;

968: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
969: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
970: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
971: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
972: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
973: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
974: l_ctx_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
975: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;
976: ------ End of declaring columns selected in the cursor ------

Line 973: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;

969: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
970: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
971: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
972: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
973: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
974: l_ctx_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
975: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;
976: ------ End of declaring columns selected in the cursor ------
977:

Line 974: l_ctx_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;

970: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
971: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
972: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
973: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
974: l_ctx_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
975: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;
976: ------ End of declaring columns selected in the cursor ------
977:
978: BEGIN

Line 975: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;

971: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
972: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
973: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
974: l_ctx_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
975: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;
976: ------ End of declaring columns selected in the cursor ------
977:
978: BEGIN
979: l_err_loc := 100;

Line 1438: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;

1434: AND fsp.inventory_organization_id = mparams.organization_id
1435: AND fsp.org_id = ctx.org_id;
1436:
1437: ----- Start of declaring columns selected in the cursor -----
1438: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1439: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1440: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
1441: ------ End of declaring columns selected in the cursor ------
1442:

Line 1439: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;

1435: AND fsp.org_id = ctx.org_id;
1436:
1437: ----- Start of declaring columns selected in the cursor -----
1438: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1439: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1440: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
1441: ------ End of declaring columns selected in the cursor ------
1442:
1443: l_api_name CONSTANT VARCHAR2(30) := 'populateItemDelete';

Line 1440: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;

1436:
1437: ----- Start of declaring columns selected in the cursor -----
1438: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1439: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1440: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
1441: ------ End of declaring columns selected in the cursor ------
1442:
1443: l_api_name CONSTANT VARCHAR2(30) := 'populateItemDelete';
1444: l_err_loc PLS_INTEGER;

Line 1597: ( P_MTL_CATEGORY_ID_TBL IN DBMS_SQL.NUMBER_TABLE

1593: RAISE;
1594: END populateItemCatgDelete;
1595:
1596: PROCEDURE populateCategoryItems
1597: ( P_MTL_CATEGORY_ID_TBL IN DBMS_SQL.NUMBER_TABLE
1598: )
1599: IS
1600: l_api_name CONSTANT VARCHAR2(30) := 'populateCategoryItems';
1601: l_err_loc PLS_INTEGER;