416: l_ReqTmplt_line_status PLS_INTEGER;
417: l_current_ctx_item_rec ICX_CAT_POPULATE_ITEM_PVT.g_ctx_item_rec_type;
418:
419: ----- Start of declaring columns selected in the cursor -----
420: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
421: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
422: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
423: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
424: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
417: l_current_ctx_item_rec ICX_CAT_POPULATE_ITEM_PVT.g_ctx_item_rec_type;
418:
419: ----- Start of declaring columns selected in the cursor -----
420: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
421: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
422: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
423: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
424: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
425: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
418:
419: ----- Start of declaring columns selected in the cursor -----
420: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
421: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
422: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
423: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
424: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
425: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
426: l_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
419: ----- Start of declaring columns selected in the cursor -----
420: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
421: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
422: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
423: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
424: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
425: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
426: l_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
427: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
420: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
421: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
422: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
423: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
424: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
425: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
426: l_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
427: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
428: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
421: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
422: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
423: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
424: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
425: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
426: l_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
427: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
428: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
429: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
422: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
423: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
424: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
425: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
426: l_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
427: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
428: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
429: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
430: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
423: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
424: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
425: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
426: l_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
427: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
428: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
429: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
430: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
431: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
424: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
425: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
426: l_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
427: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
428: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
429: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
430: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
431: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
432: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
425: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
426: l_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
427: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
428: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
429: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
430: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
431: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
432: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
433: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
426: l_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
427: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
428: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
429: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
430: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
431: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
432: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
433: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
434: l_inactive_date_tbl DBMS_SQL.DATE_TABLE;
427: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
428: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
429: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
430: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
431: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
432: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
433: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
434: l_inactive_date_tbl DBMS_SQL.DATE_TABLE;
435: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
428: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
429: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
430: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
431: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
432: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
433: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
434: l_inactive_date_tbl DBMS_SQL.DATE_TABLE;
435: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
436: l_req_template_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
429: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
430: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
431: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
432: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
433: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
434: l_inactive_date_tbl DBMS_SQL.DATE_TABLE;
435: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
436: l_req_template_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
437: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
430: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
431: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
432: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
433: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
434: l_inactive_date_tbl DBMS_SQL.DATE_TABLE;
435: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
436: l_req_template_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
437: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
438: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
431: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
432: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
433: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
434: l_inactive_date_tbl DBMS_SQL.DATE_TABLE;
435: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
436: l_req_template_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
437: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
438: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
439: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
432: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
433: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
434: l_inactive_date_tbl DBMS_SQL.DATE_TABLE;
435: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
436: l_req_template_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
437: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
438: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
439: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
440: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
433: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
434: l_inactive_date_tbl DBMS_SQL.DATE_TABLE;
435: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
436: l_req_template_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
437: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
438: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
439: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
440: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
441: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
434: l_inactive_date_tbl DBMS_SQL.DATE_TABLE;
435: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
436: l_req_template_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
437: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
438: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
439: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
440: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
441: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
442: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
435: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
436: l_req_template_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
437: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
438: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
439: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
440: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
441: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
442: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
443: l_suggested_quantity_tbl DBMS_SQL.NUMBER_TABLE;
436: l_req_template_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
437: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
438: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
439: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
440: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
441: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
442: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
443: l_suggested_quantity_tbl DBMS_SQL.NUMBER_TABLE;
444: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
437: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
438: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
439: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
440: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
441: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
442: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
443: l_suggested_quantity_tbl DBMS_SQL.NUMBER_TABLE;
444: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
445: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
438: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
439: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
440: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
441: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
442: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
443: l_suggested_quantity_tbl DBMS_SQL.NUMBER_TABLE;
444: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
445: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
446: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
439: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
440: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
441: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
442: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
443: l_suggested_quantity_tbl DBMS_SQL.NUMBER_TABLE;
444: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
445: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
446: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
447: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
440: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
441: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
442: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
443: l_suggested_quantity_tbl DBMS_SQL.NUMBER_TABLE;
444: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
445: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
446: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
447: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
448: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
441: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
442: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
443: l_suggested_quantity_tbl DBMS_SQL.NUMBER_TABLE;
444: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
445: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
446: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
447: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
448: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
449: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
442: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
443: l_suggested_quantity_tbl DBMS_SQL.NUMBER_TABLE;
444: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
445: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
446: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
447: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
448: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
449: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
450: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
443: l_suggested_quantity_tbl DBMS_SQL.NUMBER_TABLE;
444: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
445: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
446: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
447: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
448: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
449: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
450: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
451: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
444: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
445: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
446: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
447: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
448: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
449: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
450: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
451: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
452: l_rfq_required_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
445: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
446: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
447: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
448: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
449: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
450: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
451: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
452: l_rfq_required_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
453: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
446: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
447: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
448: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
449: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
450: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
451: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
452: l_rfq_required_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
453: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
454: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
447: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
448: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
449: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
450: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
451: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
452: l_rfq_required_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
453: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
454: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
455: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
448: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
449: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
450: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
451: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
452: l_rfq_required_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
453: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
454: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
455: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
456: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
449: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
450: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
451: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
452: l_rfq_required_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
453: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
454: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
455: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
456: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
457: l_approved_date_tbl DBMS_SQL.DATE_TABLE;
450: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
451: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
452: l_rfq_required_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
453: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
454: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
455: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
456: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
457: l_approved_date_tbl DBMS_SQL.DATE_TABLE;
458: l_authorization_status_tbl DBMS_SQL.VARCHAR2_TABLE;
451: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
452: l_rfq_required_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
453: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
454: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
455: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
456: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
457: l_approved_date_tbl DBMS_SQL.DATE_TABLE;
458: l_authorization_status_tbl DBMS_SQL.VARCHAR2_TABLE;
459: l_frozen_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
452: l_rfq_required_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
453: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
454: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
455: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
456: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
457: l_approved_date_tbl DBMS_SQL.DATE_TABLE;
458: l_authorization_status_tbl DBMS_SQL.VARCHAR2_TABLE;
459: l_frozen_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
460: l_hdr_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
453: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
454: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
455: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
456: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
457: l_approved_date_tbl DBMS_SQL.DATE_TABLE;
458: l_authorization_status_tbl DBMS_SQL.VARCHAR2_TABLE;
459: l_frozen_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
460: l_hdr_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
461: l_line_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
454: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
455: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
456: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
457: l_approved_date_tbl DBMS_SQL.DATE_TABLE;
458: l_authorization_status_tbl DBMS_SQL.VARCHAR2_TABLE;
459: l_frozen_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
460: l_hdr_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
461: l_line_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
462: l_hdr_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
455: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
456: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
457: l_approved_date_tbl DBMS_SQL.DATE_TABLE;
458: l_authorization_status_tbl DBMS_SQL.VARCHAR2_TABLE;
459: l_frozen_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
460: l_hdr_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
461: l_line_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
462: l_hdr_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
463: l_line_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
456: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
457: l_approved_date_tbl DBMS_SQL.DATE_TABLE;
458: l_authorization_status_tbl DBMS_SQL.VARCHAR2_TABLE;
459: l_frozen_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
460: l_hdr_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
461: l_line_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
462: l_hdr_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
463: l_line_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
464: l_end_date_tbl DBMS_SQL.DATE_TABLE;
457: l_approved_date_tbl DBMS_SQL.DATE_TABLE;
458: l_authorization_status_tbl DBMS_SQL.VARCHAR2_TABLE;
459: l_frozen_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
460: l_hdr_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
461: l_line_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
462: l_hdr_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
463: l_line_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
464: l_end_date_tbl DBMS_SQL.DATE_TABLE;
465: l_expiration_date_tbl DBMS_SQL.DATE_TABLE;
458: l_authorization_status_tbl DBMS_SQL.VARCHAR2_TABLE;
459: l_frozen_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
460: l_hdr_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
461: l_line_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
462: l_hdr_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
463: l_line_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
464: l_end_date_tbl DBMS_SQL.DATE_TABLE;
465: l_expiration_date_tbl DBMS_SQL.DATE_TABLE;
466: l_system_date_tbl DBMS_SQL.DATE_TABLE;
459: l_frozen_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
460: l_hdr_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
461: l_line_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
462: l_hdr_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
463: l_line_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
464: l_end_date_tbl DBMS_SQL.DATE_TABLE;
465: l_expiration_date_tbl DBMS_SQL.DATE_TABLE;
466: l_system_date_tbl DBMS_SQL.DATE_TABLE;
467: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
460: l_hdr_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
461: l_line_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
462: l_hdr_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
463: l_line_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
464: l_end_date_tbl DBMS_SQL.DATE_TABLE;
465: l_expiration_date_tbl DBMS_SQL.DATE_TABLE;
466: l_system_date_tbl DBMS_SQL.DATE_TABLE;
467: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
468: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
461: l_line_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
462: l_hdr_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
463: l_line_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
464: l_end_date_tbl DBMS_SQL.DATE_TABLE;
465: l_expiration_date_tbl DBMS_SQL.DATE_TABLE;
466: l_system_date_tbl DBMS_SQL.DATE_TABLE;
467: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
468: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
469: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
462: l_hdr_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
463: l_line_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
464: l_end_date_tbl DBMS_SQL.DATE_TABLE;
465: l_expiration_date_tbl DBMS_SQL.DATE_TABLE;
466: l_system_date_tbl DBMS_SQL.DATE_TABLE;
467: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
468: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
469: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
470: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
463: l_line_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
464: l_end_date_tbl DBMS_SQL.DATE_TABLE;
465: l_expiration_date_tbl DBMS_SQL.DATE_TABLE;
466: l_system_date_tbl DBMS_SQL.DATE_TABLE;
467: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
468: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
469: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
470: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
471: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
464: l_end_date_tbl DBMS_SQL.DATE_TABLE;
465: l_expiration_date_tbl DBMS_SQL.DATE_TABLE;
466: l_system_date_tbl DBMS_SQL.DATE_TABLE;
467: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
468: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
469: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
470: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
471: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
472: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
465: l_expiration_date_tbl DBMS_SQL.DATE_TABLE;
466: l_system_date_tbl DBMS_SQL.DATE_TABLE;
467: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
468: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
469: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
470: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
471: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
472: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
473: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
466: l_system_date_tbl DBMS_SQL.DATE_TABLE;
467: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
468: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
469: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
470: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
471: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
472: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
473: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
474: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
467: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
468: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
469: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
470: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
471: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
472: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
473: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
474: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
475: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
468: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
469: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
470: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
471: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
472: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
473: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
474: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
475: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
476: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
469: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
470: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
471: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
472: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
473: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
474: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
475: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
476: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
477: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
470: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
471: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
472: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
473: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
474: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
475: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
476: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
477: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
478: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;
471: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
472: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
473: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
474: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
475: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
476: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
477: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
478: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;
479: ------ End of declaring columns selected in the cursor ------
472: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
473: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
474: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
475: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
476: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
477: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
478: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;
479: ------ End of declaring columns selected in the cursor ------
480:
473: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
474: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
475: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
476: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
477: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
478: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;
479: ------ End of declaring columns selected in the cursor ------
480:
481: BEGIN
474: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
475: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
476: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
477: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
478: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;
479: ------ End of declaring columns selected in the cursor ------
480:
481: BEGIN
482: l_err_loc := 100;