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

Line 417: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;

413: l_ReqTmplt_line_status PLS_INTEGER;
414: l_current_ctx_item_rec ICX_CAT_POPULATE_ITEM_PVT.g_ctx_item_rec_type;
415:
416: ----- Start of declaring columns selected in the cursor -----
417: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
418: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
419: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
420: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
421: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 418: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;

414: l_current_ctx_item_rec ICX_CAT_POPULATE_ITEM_PVT.g_ctx_item_rec_type;
415:
416: ----- Start of declaring columns selected in the cursor -----
417: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
418: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
419: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
420: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
421: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
422: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 419: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;

415:
416: ----- Start of declaring columns selected in the cursor -----
417: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
418: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
419: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
420: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
421: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
422: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
423: l_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 420: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;

416: ----- Start of declaring columns selected in the cursor -----
417: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
418: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
419: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
420: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
421: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
422: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
423: l_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
424: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 421: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;

417: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
418: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
419: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
420: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
421: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
422: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
423: l_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
424: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
425: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 422: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;

418: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
419: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
420: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
421: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
422: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
423: l_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
424: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
425: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
426: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 423: l_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;

419: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
420: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
421: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
422: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
423: l_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
424: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
425: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
426: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
427: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 424: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;

420: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
421: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
422: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
423: l_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
424: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
425: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
426: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
427: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
428: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 425: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;

421: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
422: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
423: l_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
424: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
425: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
426: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
427: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
428: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
429: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 426: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;

422: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
423: l_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
424: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
425: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
426: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
427: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
428: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
429: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
430: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 427: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;

423: l_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
424: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
425: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
426: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
427: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
428: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
429: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
430: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
431: l_inactive_date_tbl DBMS_SQL.DATE_TABLE;

Line 428: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;

424: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
425: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
426: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
427: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
428: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
429: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
430: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
431: l_inactive_date_tbl DBMS_SQL.DATE_TABLE;
432: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 429: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;

425: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
426: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
427: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
428: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
429: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
430: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
431: l_inactive_date_tbl DBMS_SQL.DATE_TABLE;
432: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
433: l_req_template_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 430: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;

426: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
427: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
428: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
429: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
430: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
431: l_inactive_date_tbl DBMS_SQL.DATE_TABLE;
432: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
433: l_req_template_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
434: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 431: l_inactive_date_tbl DBMS_SQL.DATE_TABLE;

427: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
428: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
429: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
430: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
431: l_inactive_date_tbl DBMS_SQL.DATE_TABLE;
432: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
433: l_req_template_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
434: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
435: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 432: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;

428: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
429: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
430: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
431: l_inactive_date_tbl DBMS_SQL.DATE_TABLE;
432: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
433: l_req_template_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
434: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
435: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
436: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 433: l_req_template_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;

429: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
430: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
431: l_inactive_date_tbl DBMS_SQL.DATE_TABLE;
432: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
433: l_req_template_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
434: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
435: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
436: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
437: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;

Line 434: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;

430: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
431: l_inactive_date_tbl DBMS_SQL.DATE_TABLE;
432: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
433: l_req_template_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
434: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
435: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
436: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
437: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
438: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 435: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;

431: l_inactive_date_tbl DBMS_SQL.DATE_TABLE;
432: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
433: l_req_template_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
434: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
435: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
436: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
437: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
438: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
439: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 436: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;

432: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
433: l_req_template_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
434: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
435: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
436: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
437: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
438: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
439: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
440: l_suggested_quantity_tbl DBMS_SQL.NUMBER_TABLE;

Line 437: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;

433: l_req_template_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
434: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
435: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
436: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
437: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
438: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
439: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
440: l_suggested_quantity_tbl DBMS_SQL.NUMBER_TABLE;
441: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;

Line 438: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;

434: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
435: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
436: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
437: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
438: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
439: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
440: l_suggested_quantity_tbl DBMS_SQL.NUMBER_TABLE;
441: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
442: l_amount_tbl DBMS_SQL.NUMBER_TABLE;

Line 439: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;

435: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
436: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
437: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
438: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
439: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
440: l_suggested_quantity_tbl DBMS_SQL.NUMBER_TABLE;
441: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
442: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
443: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 440: l_suggested_quantity_tbl DBMS_SQL.NUMBER_TABLE;

436: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
437: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
438: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
439: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
440: l_suggested_quantity_tbl DBMS_SQL.NUMBER_TABLE;
441: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
442: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
443: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
444: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 441: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;

437: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
438: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
439: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
440: l_suggested_quantity_tbl DBMS_SQL.NUMBER_TABLE;
441: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
442: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
443: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
444: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
445: l_rate_date_tbl DBMS_SQL.DATE_TABLE;

Line 442: l_amount_tbl DBMS_SQL.NUMBER_TABLE;

438: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
439: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
440: l_suggested_quantity_tbl DBMS_SQL.NUMBER_TABLE;
441: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
442: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
443: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
444: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
445: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
446: l_rate_tbl DBMS_SQL.NUMBER_TABLE;

Line 443: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;

439: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
440: l_suggested_quantity_tbl DBMS_SQL.NUMBER_TABLE;
441: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
442: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
443: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
444: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
445: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
446: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
447: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 444: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;

440: l_suggested_quantity_tbl DBMS_SQL.NUMBER_TABLE;
441: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
442: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
443: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
444: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
445: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
446: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
447: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
448: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 445: l_rate_date_tbl DBMS_SQL.DATE_TABLE;

441: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
442: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
443: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
444: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
445: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
446: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
447: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
448: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
449: l_rfq_required_flag_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 446: l_rate_tbl DBMS_SQL.NUMBER_TABLE;

442: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
443: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
444: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
445: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
446: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
447: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
448: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
449: l_rfq_required_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
450: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 447: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;

443: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
444: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
445: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
446: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
447: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
448: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
449: l_rfq_required_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
450: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
451: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 448: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;

444: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
445: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
446: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
447: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
448: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
449: l_rfq_required_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
450: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
451: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
452: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 449: l_rfq_required_flag_tbl DBMS_SQL.VARCHAR2_TABLE;

445: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
446: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
447: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
448: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
449: l_rfq_required_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
450: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
451: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
452: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
453: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 450: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;

446: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
447: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
448: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
449: l_rfq_required_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
450: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
451: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
452: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
453: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
454: l_approved_date_tbl DBMS_SQL.DATE_TABLE;

Line 451: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;

447: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
448: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
449: l_rfq_required_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
450: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
451: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
452: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
453: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
454: l_approved_date_tbl DBMS_SQL.DATE_TABLE;
455: l_authorization_status_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 452: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;

448: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
449: l_rfq_required_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
450: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
451: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
452: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
453: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
454: l_approved_date_tbl DBMS_SQL.DATE_TABLE;
455: l_authorization_status_tbl DBMS_SQL.VARCHAR2_TABLE;
456: l_frozen_flag_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 453: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;

449: l_rfq_required_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
450: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
451: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
452: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
453: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
454: l_approved_date_tbl DBMS_SQL.DATE_TABLE;
455: l_authorization_status_tbl DBMS_SQL.VARCHAR2_TABLE;
456: l_frozen_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
457: l_hdr_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 454: l_approved_date_tbl DBMS_SQL.DATE_TABLE;

450: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
451: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
452: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
453: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
454: l_approved_date_tbl DBMS_SQL.DATE_TABLE;
455: l_authorization_status_tbl DBMS_SQL.VARCHAR2_TABLE;
456: l_frozen_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
457: l_hdr_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
458: l_line_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 455: l_authorization_status_tbl DBMS_SQL.VARCHAR2_TABLE;

451: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
452: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
453: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
454: l_approved_date_tbl DBMS_SQL.DATE_TABLE;
455: l_authorization_status_tbl DBMS_SQL.VARCHAR2_TABLE;
456: l_frozen_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
457: l_hdr_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
458: l_line_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
459: l_hdr_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 456: l_frozen_flag_tbl DBMS_SQL.VARCHAR2_TABLE;

452: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
453: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
454: l_approved_date_tbl DBMS_SQL.DATE_TABLE;
455: l_authorization_status_tbl DBMS_SQL.VARCHAR2_TABLE;
456: l_frozen_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
457: l_hdr_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
458: l_line_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
459: l_hdr_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
460: l_line_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 457: l_hdr_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;

453: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
454: l_approved_date_tbl DBMS_SQL.DATE_TABLE;
455: l_authorization_status_tbl DBMS_SQL.VARCHAR2_TABLE;
456: l_frozen_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
457: l_hdr_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
458: l_line_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
459: l_hdr_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
460: l_line_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
461: l_end_date_tbl DBMS_SQL.DATE_TABLE;

Line 458: l_line_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;

454: l_approved_date_tbl DBMS_SQL.DATE_TABLE;
455: l_authorization_status_tbl DBMS_SQL.VARCHAR2_TABLE;
456: l_frozen_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
457: l_hdr_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
458: l_line_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
459: l_hdr_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
460: l_line_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
461: l_end_date_tbl DBMS_SQL.DATE_TABLE;
462: l_expiration_date_tbl DBMS_SQL.DATE_TABLE;

Line 459: l_hdr_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;

455: l_authorization_status_tbl DBMS_SQL.VARCHAR2_TABLE;
456: l_frozen_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
457: l_hdr_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
458: l_line_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
459: l_hdr_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
460: l_line_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
461: l_end_date_tbl DBMS_SQL.DATE_TABLE;
462: l_expiration_date_tbl DBMS_SQL.DATE_TABLE;
463: l_system_date_tbl DBMS_SQL.DATE_TABLE;

Line 460: l_line_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;

456: l_frozen_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
457: l_hdr_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
458: l_line_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
459: l_hdr_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
460: l_line_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
461: l_end_date_tbl DBMS_SQL.DATE_TABLE;
462: l_expiration_date_tbl DBMS_SQL.DATE_TABLE;
463: l_system_date_tbl DBMS_SQL.DATE_TABLE;
464: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 461: l_end_date_tbl DBMS_SQL.DATE_TABLE;

457: l_hdr_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
458: l_line_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
459: l_hdr_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
460: l_line_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
461: l_end_date_tbl DBMS_SQL.DATE_TABLE;
462: l_expiration_date_tbl DBMS_SQL.DATE_TABLE;
463: l_system_date_tbl DBMS_SQL.DATE_TABLE;
464: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
465: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 462: l_expiration_date_tbl DBMS_SQL.DATE_TABLE;

458: l_line_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
459: l_hdr_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
460: l_line_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
461: l_end_date_tbl DBMS_SQL.DATE_TABLE;
462: l_expiration_date_tbl DBMS_SQL.DATE_TABLE;
463: l_system_date_tbl DBMS_SQL.DATE_TABLE;
464: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
465: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
466: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 463: l_system_date_tbl DBMS_SQL.DATE_TABLE;

459: l_hdr_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
460: l_line_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
461: l_end_date_tbl DBMS_SQL.DATE_TABLE;
462: l_expiration_date_tbl DBMS_SQL.DATE_TABLE;
463: l_system_date_tbl DBMS_SQL.DATE_TABLE;
464: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
465: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
466: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
467: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 464: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;

460: l_line_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
461: l_end_date_tbl DBMS_SQL.DATE_TABLE;
462: l_expiration_date_tbl DBMS_SQL.DATE_TABLE;
463: l_system_date_tbl DBMS_SQL.DATE_TABLE;
464: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
465: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
466: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
467: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
468: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 465: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;

461: l_end_date_tbl DBMS_SQL.DATE_TABLE;
462: l_expiration_date_tbl DBMS_SQL.DATE_TABLE;
463: l_system_date_tbl DBMS_SQL.DATE_TABLE;
464: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
465: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
466: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
467: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
468: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
469: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 466: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;

462: l_expiration_date_tbl DBMS_SQL.DATE_TABLE;
463: l_system_date_tbl DBMS_SQL.DATE_TABLE;
464: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
465: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
466: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
467: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
468: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
469: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
470: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 467: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;

463: l_system_date_tbl DBMS_SQL.DATE_TABLE;
464: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
465: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
466: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
467: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
468: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
469: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
470: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
471: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 468: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;

464: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
465: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
466: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
467: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
468: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
469: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
470: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
471: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
472: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 469: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;

465: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
466: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
467: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
468: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
469: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
470: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
471: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
472: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
473: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 470: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;

466: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
467: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
468: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
469: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
470: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
471: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
472: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
473: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
474: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 471: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;

467: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
468: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
469: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
470: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
471: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
472: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
473: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
474: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
475: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;

Line 472: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;

468: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
469: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
470: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
471: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
472: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
473: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
474: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
475: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;
476: ------ End of declaring columns selected in the cursor ------

Line 473: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;

469: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
470: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
471: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
472: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
473: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
474: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
475: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;
476: ------ End of declaring columns selected in the cursor ------
477:

Line 474: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;

470: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
471: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
472: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
473: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
474: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
475: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;
476: ------ End of declaring columns selected in the cursor ------
477:
478: BEGIN

Line 475: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;

471: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
472: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
473: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
474: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
475: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;
476: ------ End of declaring columns selected in the cursor ------
477:
478: BEGIN
479: l_err_loc := 100;