DBA Data[Home] [Help]

APPS.JAI_RCV_THIRD_PARTY_PKG dependencies on AP_INVOICES_ALL

Line 628: lv_invoice_num ap_invoices_all.invoice_num%type;

624: lv_currency_conversion_rate rcv_transactions.currency_conversion_rate%type;
625: lv_currency_conversion_date date;
626: ln_uid number; --File.Sql.35 Cbabu := fnd_global.user_id;
627: ln_inv_run_no number;
628: lv_invoice_num ap_invoices_all.invoice_num%type;
629: lv_func_currency gl_sets_of_books.currency_code%type;
630: ln_gl_set_of_books_id gl_sets_of_books.set_of_books_id%type;
631: ln_interface_invoice_id number;
632: ln_interface_line_id number;

Line 1465: p_invoice_id IN ap_invoices_all.invoice_id%TYPE,

1461:
1462: /****************************** Start populate_tp_invoice_id ****************************/
1463: procedure populate_tp_invoice_id
1464: (
1465: p_invoice_id IN ap_invoices_all.invoice_id%TYPE,
1466: p_invoice_num IN ap_invoices_all.invoice_num%TYPE,
1467: p_vendor_id IN ap_invoices_all.vendor_id%TYPE,
1468: p_vendor_site_id IN ap_invoices_all.vendor_site_id%TYPE,
1469: p_process_flag OUT NOCOPY VARCHAR2,

Line 1466: p_invoice_num IN ap_invoices_all.invoice_num%TYPE,

1462: /****************************** Start populate_tp_invoice_id ****************************/
1463: procedure populate_tp_invoice_id
1464: (
1465: p_invoice_id IN ap_invoices_all.invoice_id%TYPE,
1466: p_invoice_num IN ap_invoices_all.invoice_num%TYPE,
1467: p_vendor_id IN ap_invoices_all.vendor_id%TYPE,
1468: p_vendor_site_id IN ap_invoices_all.vendor_site_id%TYPE,
1469: p_process_flag OUT NOCOPY VARCHAR2,
1470: p_process_message OUT NOCOPY VARCHAR2

Line 1467: p_vendor_id IN ap_invoices_all.vendor_id%TYPE,

1463: procedure populate_tp_invoice_id
1464: (
1465: p_invoice_id IN ap_invoices_all.invoice_id%TYPE,
1466: p_invoice_num IN ap_invoices_all.invoice_num%TYPE,
1467: p_vendor_id IN ap_invoices_all.vendor_id%TYPE,
1468: p_vendor_site_id IN ap_invoices_all.vendor_site_id%TYPE,
1469: p_process_flag OUT NOCOPY VARCHAR2,
1470: p_process_message OUT NOCOPY VARCHAR2
1471: )

Line 1468: p_vendor_site_id IN ap_invoices_all.vendor_site_id%TYPE,

1464: (
1465: p_invoice_id IN ap_invoices_all.invoice_id%TYPE,
1466: p_invoice_num IN ap_invoices_all.invoice_num%TYPE,
1467: p_vendor_id IN ap_invoices_all.vendor_id%TYPE,
1468: p_vendor_site_id IN ap_invoices_all.vendor_site_id%TYPE,
1469: p_process_flag OUT NOCOPY VARCHAR2,
1470: p_process_message OUT NOCOPY VARCHAR2
1471: )
1472: IS

Line 1476: || This procedure will be called from the trigger - ja_in_ap_aia_before_trg on ap_invoices_all

1472: IS
1473:
1474: /*
1475: || This procedure is added by ssumaith - bug# 4284505 for updating the invoice_id in the jai_Rcv_tp_invoices table
1476: || This procedure will be called from the trigger - ja_in_ap_aia_before_trg on ap_invoices_all
1477: */
1478: BEGIN
1479:
1480: UPDATE jai_rcv_tp_invoices