eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ICX_CAT_POPULATE_PODOCS_PVT dependencies on DBMS_SQL

Line 317: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;

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;

Line 318: l_po_line_id_tbl DBMS_SQL.NUMBER_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;

Line 319: l_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;

Line 320: l_language_tbl DBMS_SQL.VARCHAR2_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;

Line 321: l_source_type_tbl DBMS_SQL.VARCHAR2_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;

Line 322: l_purchasing_org_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;
326: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 323: l_po_category_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;
327: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 324: l_supplier_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;

Line 325: l_supplier_part_num_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;
329: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 326: l_supplier_part_auxid_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;

Line 327: l_supplier_site_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;
331: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 328: l_ip_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;
332: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 329: l_ip_category_name_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;

Line 330: l_item_revision_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;
334: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 331: l_po_header_id_tbl DBMS_SQL.NUMBER_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;

Line 332: l_document_number_tbl DBMS_SQL.VARCHAR2_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;

Line 333: l_line_num_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;

Line 334: l_allow_prc_override_flag_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;

Line 335: l_not_to_exceed_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;

Line 336: l_line_type_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;
340: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 337: l_unit_meas_lookup_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;

Line 338: l_unit_price_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;
342: l_rate_date_tbl DBMS_SQL.DATE_TABLE;

Line 339: l_amount_tbl DBMS_SQL.NUMBER_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;

Line 340: l_currency_code_tbl DBMS_SQL.VARCHAR2_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;

Line 341: l_rate_type_tbl DBMS_SQL.VARCHAR2_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;

Line 342: l_rate_date_tbl DBMS_SQL.DATE_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;

Line 343: l_rate_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;
347: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 344: l_buyer_id_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;
348: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 345: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_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;

Line 346: l_negotiated_preparer_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;

Line 347: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_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;

Line 348: l_supplier_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;

Line 349: l_global_agreement_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;

Line 350: l_approved_date_tbl DBMS_SQL.DATE_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;

Line 351: l_authorization_status_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;

Line 352: l_frozen_flag_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;

Line 353: l_hdr_cancel_flag_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;

Line 354: l_line_cancel_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;
358: l_expiration_date_tbl DBMS_SQL.DATE_TABLE;

Line 355: l_hdr_closed_code_tbl DBMS_SQL.VARCHAR2_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;

Line 356: l_line_closed_code_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;
360: l_created_by_tbl DBMS_SQL.NUMBER_TABLE;

Line 357: l_end_date_tbl DBMS_SQL.DATE_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;

Line 358: l_expiration_date_tbl DBMS_SQL.DATE_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;

Line 359: l_system_date_tbl DBMS_SQL.DATE_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;

Line 360: l_created_by_tbl DBMS_SQL.NUMBER_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;

Line 361: l_ctx_inventory_item_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;

Line 362: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_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;

Line 363: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_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;

Line 364: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_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;

Line 365: l_ctx_supplier_id_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;
369: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 366: l_ctx_supplier_site_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;

Line 367: l_ctx_supplier_part_num_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;
371: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 368: l_ctx_supplier_part_auxid_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;

Line 369: l_ctx_ip_category_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;
373: ------ End of declaring columns selected in the cursor ------

Line 370: l_ctx_po_category_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 ------
374:

Line 371: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_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:
375: BEGIN

Line 372: l_ctx_rowid_tbl DBMS_SQL.UROWID_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
376: l_err_loc := 100;

Line 1167: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;

1163: l_current_ctx_item_rec ICX_CAT_POPULATE_ITEM_PVT.g_ctx_item_rec_type;
1164: l_current_flag_rec ICX_CAT_POPULATE_ITEM_PVT.g_bpa_online_flag_rec_type;
1165:
1166: ----- Start of declaring columns selected in the cursor -----
1167: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1168: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
1169: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1170: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
1171: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 1168: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;

1164: l_current_flag_rec ICX_CAT_POPULATE_ITEM_PVT.g_bpa_online_flag_rec_type;
1165:
1166: ----- Start of declaring columns selected in the cursor -----
1167: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1168: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
1169: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1170: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
1171: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1172: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 1169: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;

1165:
1166: ----- Start of declaring columns selected in the cursor -----
1167: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1168: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
1169: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1170: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
1171: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1172: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1173: l_owning_org_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 1170: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;

1166: ----- Start of declaring columns selected in the cursor -----
1167: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1168: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
1169: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1170: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
1171: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1172: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1173: l_owning_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1174: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 1171: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;

1167: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1168: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
1169: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1170: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
1171: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1172: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1173: l_owning_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1174: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1175: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 1172: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;

1168: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
1169: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1170: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
1171: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1172: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1173: l_owning_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1174: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1175: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1176: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 1173: l_owning_org_id_tbl DBMS_SQL.NUMBER_TABLE;

1169: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1170: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
1171: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1172: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1173: l_owning_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1174: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1175: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1176: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1177: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 1174: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;

1170: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
1171: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1172: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1173: l_owning_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1174: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1175: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1176: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1177: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1178: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 1175: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;

1171: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1172: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1173: l_owning_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1174: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1175: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1176: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1177: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1178: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1179: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 1176: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;

1172: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1173: l_owning_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1174: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1175: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1176: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1177: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1178: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1179: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1180: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 1177: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;

1173: l_owning_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1174: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1175: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1176: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1177: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1178: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1179: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1180: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
1181: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 1178: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;

1174: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1175: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1176: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1177: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1178: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1179: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1180: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
1181: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1182: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 1179: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;

1175: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1176: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1177: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1178: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1179: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1180: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
1181: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1182: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
1183: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 1180: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;

1176: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1177: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1178: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1179: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1180: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
1181: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1182: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
1183: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
1184: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;

Line 1181: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;

1177: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1178: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1179: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1180: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
1181: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1182: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
1183: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
1184: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
1185: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 1182: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;

1178: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1179: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1180: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
1181: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1182: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
1183: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
1184: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
1185: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1186: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;

Line 1183: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;

1179: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1180: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
1181: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1182: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
1183: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
1184: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
1185: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1186: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
1187: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 1184: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;

1180: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
1181: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1182: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
1183: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
1184: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
1185: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1186: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
1187: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
1188: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 1185: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;

1181: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1182: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
1183: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
1184: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
1185: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1186: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
1187: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
1188: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1189: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;

Line 1186: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;

1182: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
1183: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
1184: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
1185: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1186: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
1187: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
1188: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1189: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
1190: l_amount_tbl DBMS_SQL.NUMBER_TABLE;

Line 1187: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;

1183: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
1184: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
1185: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1186: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
1187: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
1188: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1189: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
1190: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
1191: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 1188: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;

1184: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
1185: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1186: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
1187: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
1188: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1189: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
1190: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
1191: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1192: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 1189: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;

1185: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1186: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
1187: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
1188: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1189: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
1190: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
1191: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1192: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1193: l_rate_date_tbl DBMS_SQL.DATE_TABLE;

Line 1190: l_amount_tbl DBMS_SQL.NUMBER_TABLE;

1186: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
1187: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
1188: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1189: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
1190: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
1191: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1192: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1193: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
1194: l_rate_tbl DBMS_SQL.NUMBER_TABLE;

Line 1191: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;

1187: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
1188: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1189: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
1190: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
1191: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1192: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1193: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
1194: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
1195: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 1192: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;

1188: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1189: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
1190: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
1191: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1192: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1193: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
1194: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
1195: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
1196: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 1193: l_rate_date_tbl DBMS_SQL.DATE_TABLE;

1189: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
1190: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
1191: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1192: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1193: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
1194: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
1195: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
1196: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
1197: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 1194: l_rate_tbl DBMS_SQL.NUMBER_TABLE;

1190: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
1191: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1192: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1193: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
1194: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
1195: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
1196: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
1197: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1198: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 1195: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;

1191: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1192: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1193: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
1194: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
1195: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
1196: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
1197: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1198: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1199: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 1196: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;

1192: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1193: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
1194: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
1195: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
1196: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
1197: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1198: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1199: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
1200: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 1197: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;

1193: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
1194: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
1195: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
1196: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
1197: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1198: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1199: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
1200: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1201: l_enabled_flag_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 1198: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;

1194: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
1195: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
1196: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
1197: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1198: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1199: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
1200: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1201: l_enabled_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1202: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 1199: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;

1195: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
1196: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
1197: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1198: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1199: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
1200: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1201: l_enabled_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1202: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1203: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 1200: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;

1196: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
1197: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1198: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1199: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
1200: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1201: l_enabled_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1202: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1203: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1204: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 1201: l_enabled_flag_tbl DBMS_SQL.VARCHAR2_TABLE;

1197: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1198: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1199: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
1200: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1201: l_enabled_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1202: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1203: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1204: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1205: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 1202: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;

1198: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1199: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
1200: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1201: l_enabled_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1202: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1203: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1204: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1205: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1206: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 1203: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;

1199: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
1200: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1201: l_enabled_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1202: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1203: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1204: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1205: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1206: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1207: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 1204: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;

1200: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1201: l_enabled_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1202: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1203: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1204: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1205: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1206: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1207: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1208: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 1205: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;

1201: l_enabled_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1202: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1203: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1204: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1205: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1206: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1207: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1208: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1209: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 1206: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;

1202: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1203: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1204: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1205: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1206: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1207: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1208: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1209: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1210: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 1207: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;

1203: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1204: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1205: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1206: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1207: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1208: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1209: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1210: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1211: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 1208: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;

1204: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1205: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1206: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1207: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1208: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1209: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1210: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1211: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1212: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 1209: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;

1205: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1206: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1207: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1208: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1209: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1210: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1211: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1212: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1213: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;

Line 1210: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;

1206: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1207: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1208: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1209: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1210: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1211: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1212: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1213: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;
1214: ------ End of declaring columns selected in the cursor ------

Line 1211: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;

1207: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1208: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1209: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1210: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1211: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1212: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1213: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;
1214: ------ End of declaring columns selected in the cursor ------
1215:

Line 1212: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;

1208: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1209: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1210: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1211: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1212: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1213: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;
1214: ------ End of declaring columns selected in the cursor ------
1215:
1216: BEGIN

Line 1213: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;

1209: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1210: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1211: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1212: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1213: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;
1214: ------ End of declaring columns selected in the cursor ------
1215:
1216: BEGIN
1217: l_err_loc := 100;

Line 1857: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;

1853: l_podoc_status PLS_INTEGER;
1854: l_current_ctx_item_rec ICX_CAT_POPULATE_ITEM_PVT.g_ctx_item_rec_type;
1855:
1856: ----- Start of declaring columns selected in the cursor -----
1857: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1858: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
1859: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1860: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
1861: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 1858: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;

1854: l_current_ctx_item_rec ICX_CAT_POPULATE_ITEM_PVT.g_ctx_item_rec_type;
1855:
1856: ----- Start of declaring columns selected in the cursor -----
1857: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1858: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
1859: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1860: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
1861: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1862: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 1859: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;

1855:
1856: ----- Start of declaring columns selected in the cursor -----
1857: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1858: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
1859: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1860: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
1861: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1862: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1863: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 1860: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;

1856: ----- Start of declaring columns selected in the cursor -----
1857: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1858: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
1859: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1860: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
1861: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1862: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1863: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1864: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 1861: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;

1857: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1858: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
1859: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1860: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
1861: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1862: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1863: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1864: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1865: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 1862: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;

1858: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
1859: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1860: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
1861: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1862: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1863: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1864: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1865: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1866: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 1863: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;

1859: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1860: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
1861: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1862: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1863: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1864: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1865: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1866: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1867: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 1864: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;

1860: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
1861: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1862: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1863: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1864: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1865: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1866: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1867: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1868: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 1865: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;

1861: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1862: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1863: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1864: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1865: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1866: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1867: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1868: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1869: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 1866: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;

1862: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1863: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1864: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1865: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1866: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1867: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1868: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1869: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
1870: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 1867: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;

1863: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1864: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1865: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1866: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1867: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1868: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1869: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
1870: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1871: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 1868: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;

1864: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1865: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1866: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1867: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1868: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1869: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
1870: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1871: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
1872: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 1869: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;

1865: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1866: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1867: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1868: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1869: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
1870: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1871: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
1872: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
1873: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;

Line 1870: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;

1866: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1867: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1868: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1869: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
1870: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1871: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
1872: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
1873: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
1874: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 1871: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;

1867: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1868: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1869: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
1870: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1871: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
1872: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
1873: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
1874: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1875: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;

Line 1872: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;

1868: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1869: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
1870: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1871: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
1872: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
1873: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
1874: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1875: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
1876: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 1873: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;

1869: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
1870: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1871: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
1872: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
1873: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
1874: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1875: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
1876: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
1877: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 1874: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;

1870: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1871: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
1872: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
1873: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
1874: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1875: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
1876: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
1877: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1878: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;

Line 1875: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;

1871: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
1872: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
1873: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
1874: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1875: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
1876: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
1877: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1878: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
1879: l_amount_tbl DBMS_SQL.NUMBER_TABLE;

Line 1876: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;

1872: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
1873: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
1874: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1875: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
1876: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
1877: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1878: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
1879: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
1880: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 1877: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;

1873: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
1874: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1875: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
1876: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
1877: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1878: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
1879: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
1880: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1881: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 1878: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;

1874: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1875: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
1876: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
1877: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1878: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
1879: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
1880: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1881: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1882: l_rate_date_tbl DBMS_SQL.DATE_TABLE;

Line 1879: l_amount_tbl DBMS_SQL.NUMBER_TABLE;

1875: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
1876: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
1877: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1878: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
1879: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
1880: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1881: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1882: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
1883: l_rate_tbl DBMS_SQL.NUMBER_TABLE;

Line 1880: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;

1876: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
1877: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1878: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
1879: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
1880: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1881: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1882: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
1883: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
1884: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 1881: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;

1877: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1878: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
1879: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
1880: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1881: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1882: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
1883: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
1884: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
1885: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 1882: l_rate_date_tbl DBMS_SQL.DATE_TABLE;

1878: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
1879: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
1880: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1881: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1882: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
1883: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
1884: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
1885: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
1886: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 1883: l_rate_tbl DBMS_SQL.NUMBER_TABLE;

1879: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
1880: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1881: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1882: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
1883: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
1884: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
1885: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
1886: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1887: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 1884: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;

1880: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1881: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1882: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
1883: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
1884: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
1885: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
1886: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1887: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1888: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 1885: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;

1881: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1882: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
1883: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
1884: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
1885: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
1886: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1887: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1888: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
1889: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 1886: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;

1882: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
1883: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
1884: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
1885: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
1886: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1887: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1888: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
1889: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1890: l_quote_status_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 1887: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;

1883: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
1884: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
1885: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
1886: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1887: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1888: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
1889: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1890: l_quote_status_tbl DBMS_SQL.VARCHAR2_TABLE;
1891: l_approved_date_tbl DBMS_SQL.DATE_TABLE;

Line 1888: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;

1884: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
1885: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
1886: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1887: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1888: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
1889: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1890: l_quote_status_tbl DBMS_SQL.VARCHAR2_TABLE;
1891: l_approved_date_tbl DBMS_SQL.DATE_TABLE;
1892: l_authorization_status_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 1889: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;

1885: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
1886: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1887: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1888: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
1889: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1890: l_quote_status_tbl DBMS_SQL.VARCHAR2_TABLE;
1891: l_approved_date_tbl DBMS_SQL.DATE_TABLE;
1892: l_authorization_status_tbl DBMS_SQL.VARCHAR2_TABLE;
1893: l_frozen_flag_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 1890: l_quote_status_tbl DBMS_SQL.VARCHAR2_TABLE;

1886: l_negotiated_preparer_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1887: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1888: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
1889: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1890: l_quote_status_tbl DBMS_SQL.VARCHAR2_TABLE;
1891: l_approved_date_tbl DBMS_SQL.DATE_TABLE;
1892: l_authorization_status_tbl DBMS_SQL.VARCHAR2_TABLE;
1893: l_frozen_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1894: l_hdr_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 1891: l_approved_date_tbl DBMS_SQL.DATE_TABLE;

1887: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1888: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
1889: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1890: l_quote_status_tbl DBMS_SQL.VARCHAR2_TABLE;
1891: l_approved_date_tbl DBMS_SQL.DATE_TABLE;
1892: l_authorization_status_tbl DBMS_SQL.VARCHAR2_TABLE;
1893: l_frozen_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1894: l_hdr_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1895: l_line_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 1892: l_authorization_status_tbl DBMS_SQL.VARCHAR2_TABLE;

1888: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
1889: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1890: l_quote_status_tbl DBMS_SQL.VARCHAR2_TABLE;
1891: l_approved_date_tbl DBMS_SQL.DATE_TABLE;
1892: l_authorization_status_tbl DBMS_SQL.VARCHAR2_TABLE;
1893: l_frozen_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1894: l_hdr_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1895: l_line_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1896: l_hdr_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 1893: l_frozen_flag_tbl DBMS_SQL.VARCHAR2_TABLE;

1889: l_global_agreement_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1890: l_quote_status_tbl DBMS_SQL.VARCHAR2_TABLE;
1891: l_approved_date_tbl DBMS_SQL.DATE_TABLE;
1892: l_authorization_status_tbl DBMS_SQL.VARCHAR2_TABLE;
1893: l_frozen_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1894: l_hdr_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1895: l_line_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1896: l_hdr_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1897: l_line_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 1894: l_hdr_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;

1890: l_quote_status_tbl DBMS_SQL.VARCHAR2_TABLE;
1891: l_approved_date_tbl DBMS_SQL.DATE_TABLE;
1892: l_authorization_status_tbl DBMS_SQL.VARCHAR2_TABLE;
1893: l_frozen_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1894: l_hdr_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1895: l_line_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1896: l_hdr_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1897: l_line_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1898: l_end_date_tbl DBMS_SQL.DATE_TABLE;

Line 1895: l_line_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;

1891: l_approved_date_tbl DBMS_SQL.DATE_TABLE;
1892: l_authorization_status_tbl DBMS_SQL.VARCHAR2_TABLE;
1893: l_frozen_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1894: l_hdr_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1895: l_line_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1896: l_hdr_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1897: l_line_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1898: l_end_date_tbl DBMS_SQL.DATE_TABLE;
1899: l_expiration_date_tbl DBMS_SQL.DATE_TABLE;

Line 1896: l_hdr_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;

1892: l_authorization_status_tbl DBMS_SQL.VARCHAR2_TABLE;
1893: l_frozen_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1894: l_hdr_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1895: l_line_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1896: l_hdr_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1897: l_line_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1898: l_end_date_tbl DBMS_SQL.DATE_TABLE;
1899: l_expiration_date_tbl DBMS_SQL.DATE_TABLE;
1900: l_system_date_tbl DBMS_SQL.DATE_TABLE;

Line 1897: l_line_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;

1893: l_frozen_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1894: l_hdr_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1895: l_line_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1896: l_hdr_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1897: l_line_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1898: l_end_date_tbl DBMS_SQL.DATE_TABLE;
1899: l_expiration_date_tbl DBMS_SQL.DATE_TABLE;
1900: l_system_date_tbl DBMS_SQL.DATE_TABLE;
1901: l_created_by_tbl DBMS_SQL.NUMBER_TABLE;

Line 1898: l_end_date_tbl DBMS_SQL.DATE_TABLE;

1894: l_hdr_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1895: l_line_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1896: l_hdr_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1897: l_line_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1898: l_end_date_tbl DBMS_SQL.DATE_TABLE;
1899: l_expiration_date_tbl DBMS_SQL.DATE_TABLE;
1900: l_system_date_tbl DBMS_SQL.DATE_TABLE;
1901: l_created_by_tbl DBMS_SQL.NUMBER_TABLE;
1902: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 1899: l_expiration_date_tbl DBMS_SQL.DATE_TABLE;

1895: l_line_cancel_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
1896: l_hdr_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1897: l_line_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1898: l_end_date_tbl DBMS_SQL.DATE_TABLE;
1899: l_expiration_date_tbl DBMS_SQL.DATE_TABLE;
1900: l_system_date_tbl DBMS_SQL.DATE_TABLE;
1901: l_created_by_tbl DBMS_SQL.NUMBER_TABLE;
1902: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1903: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 1900: l_system_date_tbl DBMS_SQL.DATE_TABLE;

1896: l_hdr_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1897: l_line_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1898: l_end_date_tbl DBMS_SQL.DATE_TABLE;
1899: l_expiration_date_tbl DBMS_SQL.DATE_TABLE;
1900: l_system_date_tbl DBMS_SQL.DATE_TABLE;
1901: l_created_by_tbl DBMS_SQL.NUMBER_TABLE;
1902: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1903: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1904: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 1901: l_created_by_tbl DBMS_SQL.NUMBER_TABLE;

1897: l_line_closed_code_tbl DBMS_SQL.VARCHAR2_TABLE;
1898: l_end_date_tbl DBMS_SQL.DATE_TABLE;
1899: l_expiration_date_tbl DBMS_SQL.DATE_TABLE;
1900: l_system_date_tbl DBMS_SQL.DATE_TABLE;
1901: l_created_by_tbl DBMS_SQL.NUMBER_TABLE;
1902: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1903: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1904: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1905: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 1902: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;

1898: l_end_date_tbl DBMS_SQL.DATE_TABLE;
1899: l_expiration_date_tbl DBMS_SQL.DATE_TABLE;
1900: l_system_date_tbl DBMS_SQL.DATE_TABLE;
1901: l_created_by_tbl DBMS_SQL.NUMBER_TABLE;
1902: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1903: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1904: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1905: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1906: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 1903: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;

1899: l_expiration_date_tbl DBMS_SQL.DATE_TABLE;
1900: l_system_date_tbl DBMS_SQL.DATE_TABLE;
1901: l_created_by_tbl DBMS_SQL.NUMBER_TABLE;
1902: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1903: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1904: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1905: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1906: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1907: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 1904: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;

1900: l_system_date_tbl DBMS_SQL.DATE_TABLE;
1901: l_created_by_tbl DBMS_SQL.NUMBER_TABLE;
1902: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1903: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1904: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1905: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1906: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1907: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1908: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 1905: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;

1901: l_created_by_tbl DBMS_SQL.NUMBER_TABLE;
1902: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1903: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1904: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1905: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1906: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1907: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1908: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1909: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 1906: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;

1902: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1903: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1904: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1905: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1906: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1907: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1908: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1909: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1910: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 1907: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;

1903: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1904: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1905: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1906: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1907: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1908: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1909: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1910: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1911: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 1908: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;

1904: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
1905: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1906: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1907: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1908: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1909: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1910: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1911: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1912: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 1909: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;

1905: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1906: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1907: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1908: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1909: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1910: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1911: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1912: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1913: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;

Line 1910: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;

1906: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
1907: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1908: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1909: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1910: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1911: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1912: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1913: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;
1914: ------ End of declaring columns selected in the cursor ------

Line 1911: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;

1907: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
1908: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1909: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1910: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1911: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1912: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1913: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;
1914: ------ End of declaring columns selected in the cursor ------
1915:

Line 1912: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;

1908: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
1909: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1910: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1911: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1912: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1913: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;
1914: ------ End of declaring columns selected in the cursor ------
1915:
1916: BEGIN

Line 1913: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;

1909: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
1910: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1911: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
1912: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
1913: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;
1914: ------ End of declaring columns selected in the cursor ------
1915:
1916: BEGIN
1917: l_err_loc := 100;

Line 2404: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;

2400: l_GBPA_line_status PLS_INTEGER;
2401: l_current_ctx_item_rec ICX_CAT_POPULATE_ITEM_PVT.g_ctx_item_rec_type;
2402:
2403: ----- Start of declaring columns selected in the cursor -----
2404: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2405: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
2406: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2407: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
2408: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 2405: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;

2401: l_current_ctx_item_rec ICX_CAT_POPULATE_ITEM_PVT.g_ctx_item_rec_type;
2402:
2403: ----- Start of declaring columns selected in the cursor -----
2404: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2405: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
2406: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2407: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
2408: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2409: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 2406: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;

2402:
2403: ----- Start of declaring columns selected in the cursor -----
2404: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2405: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
2406: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2407: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
2408: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2409: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2410: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 2407: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;

2403: ----- Start of declaring columns selected in the cursor -----
2404: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2405: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
2406: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2407: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
2408: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2409: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2410: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2411: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 2408: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;

2404: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2405: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
2406: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2407: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
2408: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2409: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2410: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2411: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
2412: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 2409: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;

2405: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
2406: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2407: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
2408: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2409: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2410: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2411: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
2412: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
2413: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 2410: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;

2406: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2407: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
2408: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2409: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2410: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2411: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
2412: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
2413: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
2414: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 2411: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;

2407: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
2408: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2409: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2410: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2411: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
2412: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
2413: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
2414: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
2415: l_status_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 2412: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;

2408: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2409: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2410: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2411: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
2412: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
2413: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
2414: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
2415: l_status_tbl DBMS_SQL.VARCHAR2_TABLE;
2416: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 2413: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;

2409: l_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2410: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2411: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
2412: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
2413: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
2414: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
2415: l_status_tbl DBMS_SQL.VARCHAR2_TABLE;
2416: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2417: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 2414: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;

2410: l_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2411: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
2412: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
2413: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
2414: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
2415: l_status_tbl DBMS_SQL.VARCHAR2_TABLE;
2416: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2417: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
2418: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 2415: l_status_tbl DBMS_SQL.VARCHAR2_TABLE;

2411: l_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
2412: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
2413: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
2414: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
2415: l_status_tbl DBMS_SQL.VARCHAR2_TABLE;
2416: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2417: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
2418: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
2419: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 2416: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;

2412: l_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
2413: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
2414: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
2415: l_status_tbl DBMS_SQL.VARCHAR2_TABLE;
2416: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2417: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
2418: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
2419: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
2420: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 2417: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;

2413: l_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
2414: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
2415: l_status_tbl DBMS_SQL.VARCHAR2_TABLE;
2416: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2417: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
2418: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
2419: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
2420: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
2421: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;

Line 2418: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;

2414: l_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
2415: l_status_tbl DBMS_SQL.VARCHAR2_TABLE;
2416: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2417: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
2418: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
2419: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
2420: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
2421: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
2422: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 2419: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;

2415: l_status_tbl DBMS_SQL.VARCHAR2_TABLE;
2416: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2417: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
2418: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
2419: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
2420: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
2421: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
2422: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
2423: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;

Line 2420: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;

2416: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2417: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
2418: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
2419: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
2420: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
2421: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
2422: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
2423: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
2424: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 2421: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;

2417: l_ip_category_name_tbl DBMS_SQL.VARCHAR2_TABLE;
2418: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
2419: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
2420: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
2421: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
2422: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
2423: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
2424: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
2425: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 2422: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;

2418: l_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
2419: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
2420: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
2421: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
2422: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
2423: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
2424: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
2425: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
2426: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;

Line 2423: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;

2419: l_po_header_id_tbl DBMS_SQL.NUMBER_TABLE;
2420: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
2421: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
2422: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
2423: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
2424: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
2425: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
2426: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
2427: l_amount_tbl DBMS_SQL.NUMBER_TABLE;

Line 2424: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;

2420: l_document_number_tbl DBMS_SQL.VARCHAR2_TABLE;
2421: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
2422: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
2423: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
2424: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
2425: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
2426: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
2427: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
2428: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 2425: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;

2421: l_line_num_tbl DBMS_SQL.NUMBER_TABLE;
2422: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
2423: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
2424: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
2425: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
2426: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
2427: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
2428: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
2429: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 2426: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;

2422: l_allow_prc_override_flag_tbl DBMS_SQL.VARCHAR2_TABLE;
2423: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
2424: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
2425: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
2426: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
2427: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
2428: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
2429: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2430: l_rate_date_tbl DBMS_SQL.DATE_TABLE;

Line 2427: l_amount_tbl DBMS_SQL.NUMBER_TABLE;

2423: l_not_to_exceed_price_tbl DBMS_SQL.NUMBER_TABLE;
2424: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
2425: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
2426: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
2427: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
2428: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
2429: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2430: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
2431: l_rate_tbl DBMS_SQL.NUMBER_TABLE;

Line 2428: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;

2424: l_line_type_id_tbl DBMS_SQL.NUMBER_TABLE;
2425: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
2426: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
2427: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
2428: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
2429: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2430: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
2431: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
2432: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 2429: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;

2425: l_unit_meas_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
2426: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
2427: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
2428: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
2429: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2430: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
2431: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
2432: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
2433: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 2430: l_rate_date_tbl DBMS_SQL.DATE_TABLE;

2426: l_unit_price_tbl DBMS_SQL.NUMBER_TABLE;
2427: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
2428: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
2429: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2430: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
2431: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
2432: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
2433: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
2434: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 2431: l_rate_tbl DBMS_SQL.NUMBER_TABLE;

2427: l_amount_tbl DBMS_SQL.NUMBER_TABLE;
2428: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
2429: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2430: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
2431: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
2432: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
2433: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
2434: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
2435: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 2432: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;

2428: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
2429: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2430: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
2431: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
2432: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
2433: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
2434: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
2435: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
2436: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 2433: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;

2429: l_rate_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2430: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
2431: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
2432: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
2433: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
2434: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
2435: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
2436: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2437: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 2434: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;

2430: l_rate_date_tbl DBMS_SQL.DATE_TABLE;
2431: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
2432: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
2433: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
2434: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
2435: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
2436: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2437: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2438: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 2435: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;

2431: l_rate_tbl DBMS_SQL.NUMBER_TABLE;
2432: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
2433: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
2434: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
2435: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
2436: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2437: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2438: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2439: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 2436: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;

2432: l_buyer_id_tbl DBMS_SQL.NUMBER_TABLE;
2433: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
2434: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
2435: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
2436: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2437: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2438: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2439: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2440: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 2437: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;

2433: l_supplier_contact_id_tbl DBMS_SQL.NUMBER_TABLE;
2434: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
2435: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
2436: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2437: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2438: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2439: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2440: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
2441: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 2438: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;

2434: l_order_type_lookup_code_tbl DBMS_SQL.VARCHAR2_TABLE;
2435: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
2436: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2437: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2438: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2439: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2440: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
2441: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
2442: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 2439: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;

2435: l_supplier_tbl DBMS_SQL.VARCHAR2_TABLE;
2436: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2437: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2438: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2439: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2440: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
2441: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
2442: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
2443: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 2440: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;

2436: l_ctx_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
2437: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2438: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2439: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2440: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
2441: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
2442: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
2443: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
2444: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 2441: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;

2437: l_ctx_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2438: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2439: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2440: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
2441: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
2442: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
2443: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
2444: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2445: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 2442: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;

2438: l_ctx_item_type_tbl DBMS_SQL.VARCHAR2_TABLE;
2439: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2440: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
2441: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
2442: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
2443: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
2444: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2445: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2446: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 2443: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;

2439: l_ctx_purchasing_org_id_tbl DBMS_SQL.NUMBER_TABLE;
2440: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
2441: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
2442: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
2443: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
2444: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2445: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2446: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
2447: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;

Line 2444: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;

2440: l_ctx_supplier_id_tbl DBMS_SQL.NUMBER_TABLE;
2441: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
2442: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
2443: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
2444: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2445: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2446: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
2447: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;
2448: ------ End of declaring columns selected in the cursor ------

Line 2445: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;

2441: l_ctx_supplier_site_id_tbl DBMS_SQL.NUMBER_TABLE;
2442: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
2443: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
2444: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2445: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2446: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
2447: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;
2448: ------ End of declaring columns selected in the cursor ------
2449:

Line 2446: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;

2442: l_ctx_supplier_part_num_tbl DBMS_SQL.VARCHAR2_TABLE;
2443: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
2444: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2445: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2446: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
2447: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;
2448: ------ End of declaring columns selected in the cursor ------
2449:
2450: BEGIN

Line 2447: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;

2443: l_ctx_supplier_part_auxid_tbl DBMS_SQL.VARCHAR2_TABLE;
2444: l_ctx_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2445: l_ctx_po_category_id_tbl DBMS_SQL.NUMBER_TABLE;
2446: l_ctx_item_revision_tbl DBMS_SQL.VARCHAR2_TABLE;
2447: l_ctx_rowid_tbl DBMS_SQL.UROWID_TABLE;
2448: ------ End of declaring columns selected in the cursor ------
2449:
2450: BEGIN
2451: l_err_loc := 100;