313: l_current_ctx_item_rec ICX_CAT_POPULATE_ITEM_PVT.g_ctx_item_rec_type;
314: l_current_flag_rec ICX_CAT_POPULATE_ITEM_PVT.g_bpa_online_flag_rec_type;
315:
316: ----- Start of declaring columns selected in the cursor -----
317: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
318: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
319: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
320: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
321: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
314: l_current_flag_rec ICX_CAT_POPULATE_ITEM_PVT.g_bpa_online_flag_rec_type;
315:
316: ----- Start of declaring columns selected in the cursor -----
317: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
318: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
319: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
320: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
321: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
322: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
315:
316: ----- Start of declaring columns selected in the cursor -----
317: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
318: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
319: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
320: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
321: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
322: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
323: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
316: ----- Start of declaring columns selected in the cursor -----
317: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
318: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
319: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
320: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
321: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
322: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
323: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
324: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
317: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
318: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
319: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
320: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
321: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
322: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
323: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
324: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
325: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
318: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
319: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
320: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
321: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
322: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
323: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
324: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
325: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
326: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
319: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
320: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
321: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
322: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
323: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
324: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
325: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
326: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
327: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
320: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
321: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
322: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
323: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
324: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
325: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
326: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
327: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
328: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
321: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
322: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
323: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
324: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
325: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
326: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
327: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
328: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
329: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
322: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
323: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
324: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
325: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
326: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
327: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
328: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
329: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
330: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
323: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
324: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
325: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
326: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
327: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
328: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
329: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
330: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
331: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
324: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
325: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
326: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
327: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
328: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
329: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
330: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
331: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
332: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
325: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
326: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
327: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
328: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
329: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
330: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
331: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
332: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
333: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
326: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
327: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
328: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
329: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
330: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
331: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
332: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
333: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
334: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
327: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
328: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
329: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
330: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
331: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
332: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
333: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
334: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
335: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
328: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
329: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
330: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
331: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
332: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
333: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
334: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
335: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
336: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
329: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
330: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
331: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
332: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
333: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
334: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
335: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
336: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
337: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
330: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
331: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
332: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
333: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
334: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
335: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
336: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
337: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
338: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
331: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
332: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
333: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
334: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
335: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
336: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
337: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
338: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
339: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
332: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
333: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
334: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
335: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
336: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
337: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
338: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
339: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
340: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
333: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
334: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
335: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
336: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
337: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
338: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
339: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
340: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
341: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
334: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
335: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
336: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
337: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
338: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
339: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
340: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
341: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
342: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
335: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
336: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
337: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
338: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
339: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
340: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
341: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
342: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
343: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
336: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
337: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
338: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
339: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
340: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
341: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
342: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
343: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
344: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
337: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
338: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
339: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
340: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
341: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
342: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
343: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
344: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
345: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
338: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
339: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
340: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
341: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
342: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
343: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
344: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
345: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
346: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
339: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
340: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
341: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
342: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
343: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
344: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
345: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
346: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
347: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
340: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
341: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
342: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
343: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
344: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
345: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
346: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
347: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
348: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
341: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
342: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
343: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
344: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
345: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
346: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
347: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
348: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
349: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
342: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
343: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
344: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
345: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
346: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
347: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
348: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
349: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
350: l_approved_date_tbl DBMS_SQL.DATE_TABLE;
343: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
344: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
345: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
346: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
347: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
348: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
349: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
350: l_approved_date_tbl DBMS_SQL.DATE_TABLE;
351: l_authorization_status_tbl DBMS_SQL.VARCHAR2_TABLE;
344: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
345: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
346: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
347: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
348: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
349: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
350: l_approved_date_tbl DBMS_SQL.DATE_TABLE;
351: l_authorization_status_tbl DBMS_SQL.VARCHAR2_TABLE;
352: l_frozen_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
345: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
346: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
347: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
348: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
349: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
350: l_approved_date_tbl DBMS_SQL.DATE_TABLE;
351: l_authorization_status_tbl DBMS_SQL.VARCHAR2_TABLE;
352: l_frozen_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
353: l_hdr_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
346: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
347: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
348: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
349: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
350: l_approved_date_tbl DBMS_SQL.DATE_TABLE;
351: l_authorization_status_tbl DBMS_SQL.VARCHAR2_TABLE;
352: l_frozen_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
353: l_hdr_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
354: l_line_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
347: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
348: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
349: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
350: l_approved_date_tbl DBMS_SQL.DATE_TABLE;
351: l_authorization_status_tbl DBMS_SQL.VARCHAR2_TABLE;
352: l_frozen_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
353: l_hdr_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
354: l_line_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
355: l_hdr_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
348: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
349: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
350: l_approved_date_tbl DBMS_SQL.DATE_TABLE;
351: l_authorization_status_tbl DBMS_SQL.VARCHAR2_TABLE;
352: l_frozen_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
353: l_hdr_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
354: l_line_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
355: l_hdr_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
356: l_line_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
349: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
350: l_approved_date_tbl DBMS_SQL.DATE_TABLE;
351: l_authorization_status_tbl DBMS_SQL.VARCHAR2_TABLE;
352: l_frozen_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
353: l_hdr_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
354: l_line_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
355: l_hdr_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
356: l_line_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
357: l_end_date_tbl DBMS_SQL.DATE_TABLE;
350: l_approved_date_tbl DBMS_SQL.DATE_TABLE;
351: l_authorization_status_tbl DBMS_SQL.VARCHAR2_TABLE;
352: l_frozen_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
353: l_hdr_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
354: l_line_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
355: l_hdr_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
356: l_line_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
357: l_end_date_tbl DBMS_SQL.DATE_TABLE;
358: l_expiration_date_tbl DBMS_SQL.DATE_TABLE;
351: l_authorization_status_tbl DBMS_SQL.VARCHAR2_TABLE;
352: l_frozen_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
353: l_hdr_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
354: l_line_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
355: l_hdr_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
356: l_line_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
357: l_end_date_tbl DBMS_SQL.DATE_TABLE;
358: l_expiration_date_tbl DBMS_SQL.DATE_TABLE;
359: l_system_date_tbl DBMS_SQL.DATE_TABLE;
352: l_frozen_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
353: l_hdr_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
354: l_line_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
355: l_hdr_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
356: l_line_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
357: l_end_date_tbl DBMS_SQL.DATE_TABLE;
358: l_expiration_date_tbl DBMS_SQL.DATE_TABLE;
359: l_system_date_tbl DBMS_SQL.DATE_TABLE;
360: l_created_by_tbl DBMS_SQL.NUMBER_TABLE;
353: l_hdr_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
354: l_line_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
355: l_hdr_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
356: l_line_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
357: l_end_date_tbl DBMS_SQL.DATE_TABLE;
358: l_expiration_date_tbl DBMS_SQL.DATE_TABLE;
359: l_system_date_tbl DBMS_SQL.DATE_TABLE;
360: l_created_by_tbl DBMS_SQL.NUMBER_TABLE;
361: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
354: l_line_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
355: l_hdr_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
356: l_line_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
357: l_end_date_tbl DBMS_SQL.DATE_TABLE;
358: l_expiration_date_tbl DBMS_SQL.DATE_TABLE;
359: l_system_date_tbl DBMS_SQL.DATE_TABLE;
360: l_created_by_tbl DBMS_SQL.NUMBER_TABLE;
361: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
362: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
355: l_hdr_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
356: l_line_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
357: l_end_date_tbl DBMS_SQL.DATE_TABLE;
358: l_expiration_date_tbl DBMS_SQL.DATE_TABLE;
359: l_system_date_tbl DBMS_SQL.DATE_TABLE;
360: l_created_by_tbl DBMS_SQL.NUMBER_TABLE;
361: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
362: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
363: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
356: l_line_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
357: l_end_date_tbl DBMS_SQL.DATE_TABLE;
358: l_expiration_date_tbl DBMS_SQL.DATE_TABLE;
359: l_system_date_tbl DBMS_SQL.DATE_TABLE;
360: l_created_by_tbl DBMS_SQL.NUMBER_TABLE;
361: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
362: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
363: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
364: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
357: l_end_date_tbl DBMS_SQL.DATE_TABLE;
358: l_expiration_date_tbl DBMS_SQL.DATE_TABLE;
359: l_system_date_tbl DBMS_SQL.DATE_TABLE;
360: l_created_by_tbl DBMS_SQL.NUMBER_TABLE;
361: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
362: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
363: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
364: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
365: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
358: l_expiration_date_tbl DBMS_SQL.DATE_TABLE;
359: l_system_date_tbl DBMS_SQL.DATE_TABLE;
360: l_created_by_tbl DBMS_SQL.NUMBER_TABLE;
361: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
362: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
363: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
364: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
365: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
366: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
359: l_system_date_tbl DBMS_SQL.DATE_TABLE;
360: l_created_by_tbl DBMS_SQL.NUMBER_TABLE;
361: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
362: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
363: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
364: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
365: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
366: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
367: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
360: l_created_by_tbl DBMS_SQL.NUMBER_TABLE;
361: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
362: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
363: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
364: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
365: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
366: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
367: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
368: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
361: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
362: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
363: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
364: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
365: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
366: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
367: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
368: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
369: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
362: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
363: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
364: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
365: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
366: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
367: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
368: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
369: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
370: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
363: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
364: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
365: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
366: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
367: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
368: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
369: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
370: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
371: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
364: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
365: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
366: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
367: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
368: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
369: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
370: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
371: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
372: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;
365: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
366: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
367: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
368: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
369: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
370: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
371: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
372: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;
373: ------ End of declaring columns selected in the cursor ------
366: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
367: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
368: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
369: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
370: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
371: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
372: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;
373: ------ End of declaring columns selected in the cursor ------
374:
367: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
368: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
369: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
370: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
371: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
372: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;
373: ------ End of declaring columns selected in the cursor ------
374:
375: BEGIN
368: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
369: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
370: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
371: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
372: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;
373: ------ End of declaring columns selected in the cursor ------
374:
375: BEGIN
376: l_err_loc := 100;
1168: l_current_flag_rec ICX_CAT_POPULATE_ITEM_PVT.g_bpa_online_flag_rec_type;
1169: l_authorization_status VARCHAR(25); --bug 16374319
1170:
1171: ----- Start of declaring columns selected in the cursor -----
1172: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1173: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
1174: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1175: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
1176: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1169: l_authorization_status VARCHAR(25); --bug 16374319
1170:
1171: ----- Start of declaring columns selected in the cursor -----
1172: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1173: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
1174: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1175: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
1176: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1177: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1170:
1171: ----- Start of declaring columns selected in the cursor -----
1172: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1173: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
1174: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1175: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
1176: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1177: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1178: l_owning_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1171: ----- Start of declaring columns selected in the cursor -----
1172: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1173: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
1174: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1175: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
1176: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1177: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1178: l_owning_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1179: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1172: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1173: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
1174: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1175: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
1176: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1177: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1178: l_owning_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1179: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1180: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1173: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
1174: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1175: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
1176: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1177: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1178: l_owning_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1179: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1180: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1181: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1174: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1175: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
1176: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1177: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1178: l_owning_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1179: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1180: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1181: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1182: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1175: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
1176: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1177: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1178: l_owning_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1179: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1180: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1181: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1182: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1183: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1176: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1177: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1178: l_owning_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1179: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1180: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1181: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1182: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1183: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1184: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1177: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1178: l_owning_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1179: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1180: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1181: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1182: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1183: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1184: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1185: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
1178: l_owning_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1179: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1180: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1181: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1182: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1183: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1184: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1185: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
1186: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1179: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1180: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1181: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1182: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1183: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1184: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1185: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
1186: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1187: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
1180: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1181: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1182: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1183: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1184: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1185: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
1186: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1187: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
1188: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
1181: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1182: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1183: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1184: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1185: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
1186: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1187: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
1188: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
1189: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
1182: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1183: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1184: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1185: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
1186: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1187: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
1188: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
1189: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
1190: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1183: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1184: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1185: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
1186: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1187: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
1188: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
1189: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
1190: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1191: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
1184: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1185: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
1186: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1187: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
1188: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
1189: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
1190: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1191: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
1192: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
1185: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
1186: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1187: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
1188: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
1189: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
1190: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1191: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
1192: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
1193: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1186: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1187: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
1188: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
1189: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
1190: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1191: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
1192: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
1193: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1194: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
1187: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
1188: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
1189: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
1190: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1191: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
1192: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
1193: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1194: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
1195: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
1188: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
1189: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
1190: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1191: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
1192: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
1193: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1194: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
1195: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
1196: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1189: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
1190: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1191: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
1192: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
1193: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1194: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
1195: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
1196: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1197: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1190: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1191: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
1192: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
1193: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1194: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
1195: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
1196: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1197: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1198: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
1191: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
1192: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
1193: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1194: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
1195: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
1196: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1197: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1198: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
1199: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
1192: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
1193: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1194: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
1195: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
1196: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1197: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1198: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
1199: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
1200: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
1193: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1194: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
1195: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
1196: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1197: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1198: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
1199: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
1200: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
1201: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
1194: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
1195: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
1196: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1197: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1198: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
1199: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
1200: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
1201: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
1202: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1195: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
1196: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1197: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1198: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
1199: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
1200: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
1201: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
1202: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1203: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1196: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1197: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1198: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
1199: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
1200: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
1201: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
1202: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1203: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1204: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
1197: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1198: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
1199: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
1200: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
1201: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
1202: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1203: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1204: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
1205: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1198: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
1199: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
1200: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
1201: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
1202: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1203: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1204: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
1205: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1206: l_enabled_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1199: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
1200: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
1201: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
1202: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1203: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1204: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
1205: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1206: l_enabled_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1207: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1200: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
1201: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
1202: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1203: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1204: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
1205: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1206: l_enabled_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1207: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1208: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1201: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
1202: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1203: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1204: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
1205: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1206: l_enabled_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1207: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1208: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1209: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1202: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1203: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1204: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
1205: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1206: l_enabled_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1207: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1208: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1209: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1210: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1203: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1204: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
1205: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1206: l_enabled_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1207: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1208: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1209: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1210: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1211: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1204: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
1205: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1206: l_enabled_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1207: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1208: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1209: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1210: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1211: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1212: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1205: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1206: l_enabled_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1207: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1208: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1209: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1210: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1211: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1212: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1213: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1206: l_enabled_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1207: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1208: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1209: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1210: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1211: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1212: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1213: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1214: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1207: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1208: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1209: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1210: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1211: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1212: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1213: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1214: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1215: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1208: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1209: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1210: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1211: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1212: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1213: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1214: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1215: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1216: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1209: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1210: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1211: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1212: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1213: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1214: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1215: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1216: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1217: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1210: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1211: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1212: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1213: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1214: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1215: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1216: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1217: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1218: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;
1211: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1212: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1213: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1214: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1215: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1216: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1217: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1218: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;
1219: ------ End of declaring columns selected in the cursor ------
1212: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1213: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1214: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1215: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1216: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1217: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1218: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;
1219: ------ End of declaring columns selected in the cursor ------
1220:
1213: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1214: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1215: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1216: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1217: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1218: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;
1219: ------ End of declaring columns selected in the cursor ------
1220:
1221: BEGIN
1214: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1215: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1216: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1217: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1218: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;
1219: ------ End of declaring columns selected in the cursor ------
1220:
1221: BEGIN
1222: l_err_loc := 100;
1867: l_podoc_status PLS_INTEGER;
1868: l_current_ctx_item_rec ICX_CAT_POPULATE_ITEM_PVT.g_ctx_item_rec_type;
1869:
1870: ----- Start of declaring columns selected in the cursor -----
1871: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1872: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
1873: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1874: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
1875: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1868: l_current_ctx_item_rec ICX_CAT_POPULATE_ITEM_PVT.g_ctx_item_rec_type;
1869:
1870: ----- Start of declaring columns selected in the cursor -----
1871: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1872: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
1873: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1874: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
1875: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1876: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1869:
1870: ----- Start of declaring columns selected in the cursor -----
1871: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1872: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
1873: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1874: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
1875: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1876: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1877: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1870: ----- Start of declaring columns selected in the cursor -----
1871: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1872: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
1873: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1874: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
1875: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1876: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1877: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1878: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1871: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1872: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
1873: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1874: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
1875: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1876: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1877: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1878: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1879: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1872: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
1873: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1874: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
1875: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1876: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1877: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1878: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1879: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1880: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1873: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1874: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
1875: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1876: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1877: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1878: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1879: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1880: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1881: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1874: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
1875: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1876: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1877: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1878: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1879: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1880: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1881: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1882: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1875: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1876: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1877: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1878: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1879: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1880: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1881: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1882: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1883: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
1876: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1877: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1878: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1879: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1880: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1881: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1882: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1883: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
1884: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1877: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1878: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1879: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1880: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1881: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1882: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1883: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
1884: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1885: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
1878: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1879: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1880: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1881: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1882: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1883: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
1884: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1885: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
1886: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
1879: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1880: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1881: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1882: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1883: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
1884: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1885: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
1886: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
1887: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
1880: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1881: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1882: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1883: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
1884: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1885: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
1886: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
1887: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
1888: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1881: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1882: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1883: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
1884: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1885: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
1886: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
1887: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
1888: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1889: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
1882: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1883: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
1884: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1885: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
1886: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
1887: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
1888: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1889: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
1890: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
1883: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
1884: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1885: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
1886: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
1887: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
1888: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1889: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
1890: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
1891: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1884: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1885: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
1886: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
1887: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
1888: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1889: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
1890: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
1891: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1892: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
1885: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
1886: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
1887: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
1888: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1889: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
1890: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
1891: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1892: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
1893: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
1886: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
1887: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
1888: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1889: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
1890: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
1891: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1892: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
1893: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
1894: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1887: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
1888: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1889: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
1890: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
1891: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1892: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
1893: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
1894: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1895: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1888: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1889: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
1890: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
1891: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1892: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
1893: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
1894: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1895: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1896: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
1889: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
1890: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
1891: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1892: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
1893: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
1894: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1895: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1896: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
1897: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
1890: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
1891: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1892: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
1893: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
1894: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1895: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1896: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
1897: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
1898: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
1891: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1892: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
1893: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
1894: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1895: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1896: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
1897: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
1898: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
1899: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
1892: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
1893: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
1894: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1895: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1896: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
1897: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
1898: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
1899: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
1900: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1893: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
1894: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1895: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1896: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
1897: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
1898: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
1899: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
1900: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1901: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1894: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1895: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1896: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
1897: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
1898: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
1899: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
1900: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1901: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1902: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
1895: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1896: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
1897: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
1898: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
1899: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
1900: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1901: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1902: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
1903: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1896: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
1897: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
1898: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
1899: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
1900: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1901: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1902: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
1903: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1904: l_quote_status_tbl DBMS_SQL.VARCHAR2_TABLE;
1897: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
1898: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
1899: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
1900: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1901: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1902: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
1903: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1904: l_quote_status_tbl DBMS_SQL.VARCHAR2_TABLE;
1905: l_approved_date_tbl DBMS_SQL.DATE_TABLE;
1898: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
1899: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
1900: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1901: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1902: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
1903: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1904: l_quote_status_tbl DBMS_SQL.VARCHAR2_TABLE;
1905: l_approved_date_tbl DBMS_SQL.DATE_TABLE;
1906: l_authorization_status_tbl DBMS_SQL.VARCHAR2_TABLE;
1899: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
1900: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1901: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1902: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
1903: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1904: l_quote_status_tbl DBMS_SQL.VARCHAR2_TABLE;
1905: l_approved_date_tbl DBMS_SQL.DATE_TABLE;
1906: l_authorization_status_tbl DBMS_SQL.VARCHAR2_TABLE;
1907: l_frozen_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1900: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1901: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1902: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
1903: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1904: l_quote_status_tbl DBMS_SQL.VARCHAR2_TABLE;
1905: l_approved_date_tbl DBMS_SQL.DATE_TABLE;
1906: l_authorization_status_tbl DBMS_SQL.VARCHAR2_TABLE;
1907: l_frozen_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1908: l_hdr_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1901: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1902: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
1903: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1904: l_quote_status_tbl DBMS_SQL.VARCHAR2_TABLE;
1905: l_approved_date_tbl DBMS_SQL.DATE_TABLE;
1906: l_authorization_status_tbl DBMS_SQL.VARCHAR2_TABLE;
1907: l_frozen_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1908: l_hdr_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1909: l_line_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1902: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
1903: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1904: l_quote_status_tbl DBMS_SQL.VARCHAR2_TABLE;
1905: l_approved_date_tbl DBMS_SQL.DATE_TABLE;
1906: l_authorization_status_tbl DBMS_SQL.VARCHAR2_TABLE;
1907: l_frozen_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1908: l_hdr_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1909: l_line_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1910: l_hdr_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1903: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1904: l_quote_status_tbl DBMS_SQL.VARCHAR2_TABLE;
1905: l_approved_date_tbl DBMS_SQL.DATE_TABLE;
1906: l_authorization_status_tbl DBMS_SQL.VARCHAR2_TABLE;
1907: l_frozen_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1908: l_hdr_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1909: l_line_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1910: l_hdr_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1911: l_line_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1904: l_quote_status_tbl DBMS_SQL.VARCHAR2_TABLE;
1905: l_approved_date_tbl DBMS_SQL.DATE_TABLE;
1906: l_authorization_status_tbl DBMS_SQL.VARCHAR2_TABLE;
1907: l_frozen_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1908: l_hdr_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1909: l_line_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1910: l_hdr_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1911: l_line_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1912: l_end_date_tbl DBMS_SQL.DATE_TABLE;
1905: l_approved_date_tbl DBMS_SQL.DATE_TABLE;
1906: l_authorization_status_tbl DBMS_SQL.VARCHAR2_TABLE;
1907: l_frozen_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1908: l_hdr_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1909: l_line_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1910: l_hdr_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1911: l_line_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1912: l_end_date_tbl DBMS_SQL.DATE_TABLE;
1913: l_expiration_date_tbl DBMS_SQL.DATE_TABLE;
1906: l_authorization_status_tbl DBMS_SQL.VARCHAR2_TABLE;
1907: l_frozen_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1908: l_hdr_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1909: l_line_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1910: l_hdr_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1911: l_line_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1912: l_end_date_tbl DBMS_SQL.DATE_TABLE;
1913: l_expiration_date_tbl DBMS_SQL.DATE_TABLE;
1914: l_system_date_tbl DBMS_SQL.DATE_TABLE;
1907: l_frozen_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1908: l_hdr_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1909: l_line_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1910: l_hdr_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1911: l_line_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1912: l_end_date_tbl DBMS_SQL.DATE_TABLE;
1913: l_expiration_date_tbl DBMS_SQL.DATE_TABLE;
1914: l_system_date_tbl DBMS_SQL.DATE_TABLE;
1915: l_created_by_tbl DBMS_SQL.NUMBER_TABLE;
1908: l_hdr_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1909: l_line_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1910: l_hdr_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1911: l_line_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1912: l_end_date_tbl DBMS_SQL.DATE_TABLE;
1913: l_expiration_date_tbl DBMS_SQL.DATE_TABLE;
1914: l_system_date_tbl DBMS_SQL.DATE_TABLE;
1915: l_created_by_tbl DBMS_SQL.NUMBER_TABLE;
1916: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1909: l_line_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1910: l_hdr_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1911: l_line_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1912: l_end_date_tbl DBMS_SQL.DATE_TABLE;
1913: l_expiration_date_tbl DBMS_SQL.DATE_TABLE;
1914: l_system_date_tbl DBMS_SQL.DATE_TABLE;
1915: l_created_by_tbl DBMS_SQL.NUMBER_TABLE;
1916: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1917: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1910: l_hdr_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1911: l_line_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1912: l_end_date_tbl DBMS_SQL.DATE_TABLE;
1913: l_expiration_date_tbl DBMS_SQL.DATE_TABLE;
1914: l_system_date_tbl DBMS_SQL.DATE_TABLE;
1915: l_created_by_tbl DBMS_SQL.NUMBER_TABLE;
1916: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1917: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1918: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1911: l_line_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1912: l_end_date_tbl DBMS_SQL.DATE_TABLE;
1913: l_expiration_date_tbl DBMS_SQL.DATE_TABLE;
1914: l_system_date_tbl DBMS_SQL.DATE_TABLE;
1915: l_created_by_tbl DBMS_SQL.NUMBER_TABLE;
1916: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1917: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1918: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1919: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1912: l_end_date_tbl DBMS_SQL.DATE_TABLE;
1913: l_expiration_date_tbl DBMS_SQL.DATE_TABLE;
1914: l_system_date_tbl DBMS_SQL.DATE_TABLE;
1915: l_created_by_tbl DBMS_SQL.NUMBER_TABLE;
1916: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1917: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1918: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1919: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1920: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1913: l_expiration_date_tbl DBMS_SQL.DATE_TABLE;
1914: l_system_date_tbl DBMS_SQL.DATE_TABLE;
1915: l_created_by_tbl DBMS_SQL.NUMBER_TABLE;
1916: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1917: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1918: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1919: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1920: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1921: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1914: l_system_date_tbl DBMS_SQL.DATE_TABLE;
1915: l_created_by_tbl DBMS_SQL.NUMBER_TABLE;
1916: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1917: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1918: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1919: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1920: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1921: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1922: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1915: l_created_by_tbl DBMS_SQL.NUMBER_TABLE;
1916: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1917: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1918: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1919: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1920: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1921: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1922: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1923: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1916: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1917: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1918: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1919: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1920: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1921: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1922: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1923: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1924: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1917: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1918: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1919: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1920: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1921: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1922: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1923: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1924: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1925: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1918: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1919: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1920: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1921: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1922: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1923: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1924: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1925: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1926: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1919: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1920: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1921: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1922: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1923: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1924: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1925: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1926: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1927: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;
1920: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1921: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1922: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1923: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1924: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1925: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1926: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1927: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;
1928: ------ End of declaring columns selected in the cursor ------
1921: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1922: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1923: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1924: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1925: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1926: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1927: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;
1928: ------ End of declaring columns selected in the cursor ------
1929:
1922: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1923: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1924: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1925: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1926: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1927: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;
1928: ------ End of declaring columns selected in the cursor ------
1929:
1930: BEGIN
1923: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1924: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1925: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1926: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1927: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;
1928: ------ End of declaring columns selected in the cursor ------
1929:
1930: BEGIN
1931: l_err_loc := 100;
2414: l_GBPA_line_status PLS_INTEGER;
2415: l_current_ctx_item_rec ICX_CAT_POPULATE_ITEM_PVT.g_ctx_item_rec_type;
2416:
2417: ----- Start of declaring columns selected in the cursor -----
2418: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2419: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
2420: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2421: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
2422: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2415: l_current_ctx_item_rec ICX_CAT_POPULATE_ITEM_PVT.g_ctx_item_rec_type;
2416:
2417: ----- Start of declaring columns selected in the cursor -----
2418: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2419: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
2420: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2421: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
2422: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2423: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2416:
2417: ----- Start of declaring columns selected in the cursor -----
2418: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2419: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
2420: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2421: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
2422: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2423: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2424: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2417: ----- Start of declaring columns selected in the cursor -----
2418: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2419: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
2420: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2421: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
2422: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2423: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2424: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2425: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
2418: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2419: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
2420: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2421: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
2422: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2423: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2424: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2425: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
2426: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
2419: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
2420: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2421: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
2422: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2423: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2424: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2425: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
2426: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
2427: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
2420: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2421: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
2422: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2423: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2424: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2425: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
2426: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
2427: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
2428: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
2421: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
2422: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2423: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2424: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2425: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
2426: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
2427: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
2428: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
2429: l_status_tbl DBMS_SQL.VARCHAR2_TABLE;
2422: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2423: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2424: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2425: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
2426: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
2427: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
2428: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
2429: l_status_tbl DBMS_SQL.VARCHAR2_TABLE;
2430: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2423: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2424: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2425: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
2426: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
2427: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
2428: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
2429: l_status_tbl DBMS_SQL.VARCHAR2_TABLE;
2430: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2431: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
2424: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2425: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
2426: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
2427: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
2428: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
2429: l_status_tbl DBMS_SQL.VARCHAR2_TABLE;
2430: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2431: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
2432: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
2425: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
2426: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
2427: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
2428: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
2429: l_status_tbl DBMS_SQL.VARCHAR2_TABLE;
2430: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2431: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
2432: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
2433: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
2426: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
2427: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
2428: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
2429: l_status_tbl DBMS_SQL.VARCHAR2_TABLE;
2430: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2431: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
2432: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
2433: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
2434: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
2427: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
2428: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
2429: l_status_tbl DBMS_SQL.VARCHAR2_TABLE;
2430: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2431: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
2432: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
2433: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
2434: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
2435: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
2428: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
2429: l_status_tbl DBMS_SQL.VARCHAR2_TABLE;
2430: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2431: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
2432: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
2433: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
2434: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
2435: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
2436: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
2429: l_status_tbl DBMS_SQL.VARCHAR2_TABLE;
2430: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2431: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
2432: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
2433: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
2434: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
2435: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
2436: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
2437: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
2430: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2431: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
2432: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
2433: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
2434: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
2435: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
2436: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
2437: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
2438: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
2431: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
2432: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
2433: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
2434: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
2435: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
2436: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
2437: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
2438: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
2439: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
2432: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
2433: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
2434: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
2435: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
2436: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
2437: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
2438: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
2439: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
2440: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
2433: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
2434: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
2435: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
2436: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
2437: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
2438: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
2439: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
2440: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
2441: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
2434: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
2435: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
2436: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
2437: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
2438: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
2439: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
2440: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
2441: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
2442: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
2435: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
2436: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
2437: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
2438: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
2439: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
2440: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
2441: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
2442: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
2443: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2436: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
2437: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
2438: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
2439: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
2440: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
2441: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
2442: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
2443: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2444: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
2437: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
2438: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
2439: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
2440: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
2441: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
2442: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
2443: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2444: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
2445: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
2438: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
2439: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
2440: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
2441: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
2442: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
2443: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2444: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
2445: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
2446: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
2439: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
2440: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
2441: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
2442: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
2443: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2444: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
2445: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
2446: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
2447: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
2440: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
2441: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
2442: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
2443: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2444: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
2445: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
2446: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
2447: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
2448: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
2441: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
2442: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
2443: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2444: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
2445: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
2446: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
2447: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
2448: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
2449: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
2442: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
2443: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2444: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
2445: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
2446: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
2447: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
2448: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
2449: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
2450: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2443: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2444: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
2445: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
2446: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
2447: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
2448: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
2449: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
2450: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2451: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2444: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
2445: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
2446: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
2447: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
2448: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
2449: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
2450: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2451: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2452: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2445: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
2446: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
2447: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
2448: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
2449: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
2450: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2451: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2452: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2453: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2446: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
2447: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
2448: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
2449: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
2450: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2451: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2452: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2453: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2454: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
2447: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
2448: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
2449: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
2450: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2451: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2452: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2453: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2454: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
2455: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
2448: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
2449: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
2450: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2451: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2452: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2453: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2454: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
2455: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
2456: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
2449: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
2450: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2451: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2452: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2453: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2454: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
2455: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
2456: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
2457: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
2450: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2451: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2452: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2453: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2454: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
2455: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
2456: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
2457: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
2458: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2451: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2452: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2453: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2454: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
2455: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
2456: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
2457: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
2458: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2459: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2452: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2453: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2454: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
2455: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
2456: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
2457: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
2458: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2459: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2460: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
2453: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2454: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
2455: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
2456: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
2457: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
2458: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2459: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2460: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
2461: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;
2454: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
2455: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
2456: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
2457: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
2458: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2459: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2460: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
2461: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;
2462: ------ End of declaring columns selected in the cursor ------
2455: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
2456: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
2457: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
2458: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2459: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2460: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
2461: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;
2462: ------ End of declaring columns selected in the cursor ------
2463:
2456: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
2457: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
2458: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2459: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2460: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
2461: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;
2462: ------ End of declaring columns selected in the cursor ------
2463:
2464: BEGIN
2457: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
2458: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2459: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2460: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
2461: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;
2462: ------ End of declaring columns selected in the cursor ------
2463:
2464: BEGIN
2465: l_err_loc := 100;