APPS.JAI_BOE_GENERAL_PKG dependencies on AP_INVOICES_ALL

Line 214: FROM ap_invoices_all ai, ap_invoice_payments_all aip

210: ai.reference_key2,
211: ai.reference_key3,
212: ai.reference_key4,
213: ai.reference_key5
214: FROM ap_invoices_all ai, ap_invoice_payments_all aip
215: WHERE ai.invoice_id = aip.invoice_id
216: AND aip.check_id = pn_check_id;
217:
218: lv_return_code VARCHAR2(1);

Line 363: FROM ap_invoices_all ai, ap_invoice_payments_all aip

359: ai.reference_key2,
360: ai.reference_key3,
361: ai.reference_key4,
362: ai.reference_key5
363: FROM ap_invoices_all ai, ap_invoice_payments_all aip
364: WHERE ai.invoice_id = aip.invoice_id
365: AND aip.check_id = pn_check_id;
366:
367: ln_applicaton_id ap_invoices_all.application_id%TYPE;

Line 367: ln_applicaton_id ap_invoices_all.application_id%TYPE;

363: FROM ap_invoices_all ai, ap_invoice_payments_all aip
364: WHERE ai.invoice_id = aip.invoice_id
365: AND aip.check_id = pn_check_id;
366:
367: ln_applicaton_id ap_invoices_all.application_id%TYPE;
368: lv_product_table ap_invoices_all.product_table%TYPE;
369: lv_reference_key1 ap_invoices_all.reference_key1%TYPE;
370: lv_reference_key2 ap_invoices_all.reference_key2%TYPE;
371: lv_reference_key3 ap_invoices_all.reference_key3%TYPE;

Line 368: lv_product_table ap_invoices_all.product_table%TYPE;

364: WHERE ai.invoice_id = aip.invoice_id
365: AND aip.check_id = pn_check_id;
366:
367: ln_applicaton_id ap_invoices_all.application_id%TYPE;
368: lv_product_table ap_invoices_all.product_table%TYPE;
369: lv_reference_key1 ap_invoices_all.reference_key1%TYPE;
370: lv_reference_key2 ap_invoices_all.reference_key2%TYPE;
371: lv_reference_key3 ap_invoices_all.reference_key3%TYPE;
372: lv_reference_key4 ap_invoices_all.reference_key4%TYPE;

Line 369: lv_reference_key1 ap_invoices_all.reference_key1%TYPE;

365: AND aip.check_id = pn_check_id;
366:
367: ln_applicaton_id ap_invoices_all.application_id%TYPE;
368: lv_product_table ap_invoices_all.product_table%TYPE;
369: lv_reference_key1 ap_invoices_all.reference_key1%TYPE;
370: lv_reference_key2 ap_invoices_all.reference_key2%TYPE;
371: lv_reference_key3 ap_invoices_all.reference_key3%TYPE;
372: lv_reference_key4 ap_invoices_all.reference_key4%TYPE;
373: lv_reference_key5 ap_invoices_all.reference_key5%TYPE;

Line 370: lv_reference_key2 ap_invoices_all.reference_key2%TYPE;

366:
367: ln_applicaton_id ap_invoices_all.application_id%TYPE;
368: lv_product_table ap_invoices_all.product_table%TYPE;
369: lv_reference_key1 ap_invoices_all.reference_key1%TYPE;
370: lv_reference_key2 ap_invoices_all.reference_key2%TYPE;
371: lv_reference_key3 ap_invoices_all.reference_key3%TYPE;
372: lv_reference_key4 ap_invoices_all.reference_key4%TYPE;
373: lv_reference_key5 ap_invoices_all.reference_key5%TYPE;
374: lv_return VARCHAR2(1);

Line 371: lv_reference_key3 ap_invoices_all.reference_key3%TYPE;

367: ln_applicaton_id ap_invoices_all.application_id%TYPE;
368: lv_product_table ap_invoices_all.product_table%TYPE;
369: lv_reference_key1 ap_invoices_all.reference_key1%TYPE;
370: lv_reference_key2 ap_invoices_all.reference_key2%TYPE;
371: lv_reference_key3 ap_invoices_all.reference_key3%TYPE;
372: lv_reference_key4 ap_invoices_all.reference_key4%TYPE;
373: lv_reference_key5 ap_invoices_all.reference_key5%TYPE;
374: lv_return VARCHAR2(1);
375:

Line 372: lv_reference_key4 ap_invoices_all.reference_key4%TYPE;

368: lv_product_table ap_invoices_all.product_table%TYPE;
369: lv_reference_key1 ap_invoices_all.reference_key1%TYPE;
370: lv_reference_key2 ap_invoices_all.reference_key2%TYPE;
371: lv_reference_key3 ap_invoices_all.reference_key3%TYPE;
372: lv_reference_key4 ap_invoices_all.reference_key4%TYPE;
373: lv_reference_key5 ap_invoices_all.reference_key5%TYPE;
374: lv_return VARCHAR2(1);
375:
376: BEGIN

Line 373: lv_reference_key5 ap_invoices_all.reference_key5%TYPE;

369: lv_reference_key1 ap_invoices_all.reference_key1%TYPE;
370: lv_reference_key2 ap_invoices_all.reference_key2%TYPE;
371: lv_reference_key3 ap_invoices_all.reference_key3%TYPE;
372: lv_reference_key4 ap_invoices_all.reference_key4%TYPE;
373: lv_reference_key5 ap_invoices_all.reference_key5%TYPE;
374: lv_return VARCHAR2(1);
375:
376: BEGIN
377: OPEN get_invoice_info_cur;