DBA Data[Home] [Help]

APPS.JAI_RCV_THIRD_PARTY_PKG dependencies on AP_INVOICES_ALL

Line 667: lv_invoice_num ap_invoices_all.invoice_num%type;

663: lv_currency_conversion_rate rcv_transactions.currency_conversion_rate%type;
664: lv_currency_conversion_date date;
665: ln_uid number; --File.Sql.35 Cbabu := fnd_global.user_id;
666: ln_inv_run_no number;
667: lv_invoice_num ap_invoices_all.invoice_num%type;
668: lv_func_currency gl_sets_of_books.currency_code%type;
669: ln_gl_set_of_books_id gl_sets_of_books.set_of_books_id%type;
670: ln_interface_invoice_id number;
671: ln_interface_line_id number;

Line 1643: p_invoice_id IN ap_invoices_all.invoice_id%TYPE,

1639:
1640: /****************************** Start populate_tp_invoice_id ****************************/
1641: procedure populate_tp_invoice_id
1642: (
1643: p_invoice_id IN ap_invoices_all.invoice_id%TYPE,
1644: p_invoice_num IN ap_invoices_all.invoice_num%TYPE,
1645: p_vendor_id IN ap_invoices_all.vendor_id%TYPE,
1646: p_vendor_site_id IN ap_invoices_all.vendor_site_id%TYPE,
1647: p_process_flag OUT NOCOPY VARCHAR2,

Line 1644: p_invoice_num IN ap_invoices_all.invoice_num%TYPE,

1640: /****************************** Start populate_tp_invoice_id ****************************/
1641: procedure populate_tp_invoice_id
1642: (
1643: p_invoice_id IN ap_invoices_all.invoice_id%TYPE,
1644: p_invoice_num IN ap_invoices_all.invoice_num%TYPE,
1645: p_vendor_id IN ap_invoices_all.vendor_id%TYPE,
1646: p_vendor_site_id IN ap_invoices_all.vendor_site_id%TYPE,
1647: p_process_flag OUT NOCOPY VARCHAR2,
1648: p_process_message OUT NOCOPY VARCHAR2

Line 1645: p_vendor_id IN ap_invoices_all.vendor_id%TYPE,

1641: procedure populate_tp_invoice_id
1642: (
1643: p_invoice_id IN ap_invoices_all.invoice_id%TYPE,
1644: p_invoice_num IN ap_invoices_all.invoice_num%TYPE,
1645: p_vendor_id IN ap_invoices_all.vendor_id%TYPE,
1646: p_vendor_site_id IN ap_invoices_all.vendor_site_id%TYPE,
1647: p_process_flag OUT NOCOPY VARCHAR2,
1648: p_process_message OUT NOCOPY VARCHAR2
1649: )

Line 1646: p_vendor_site_id IN ap_invoices_all.vendor_site_id%TYPE,

1642: (
1643: p_invoice_id IN ap_invoices_all.invoice_id%TYPE,
1644: p_invoice_num IN ap_invoices_all.invoice_num%TYPE,
1645: p_vendor_id IN ap_invoices_all.vendor_id%TYPE,
1646: p_vendor_site_id IN ap_invoices_all.vendor_site_id%TYPE,
1647: p_process_flag OUT NOCOPY VARCHAR2,
1648: p_process_message OUT NOCOPY VARCHAR2
1649: )
1650: IS

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

1650: IS
1651:
1652: /*
1653: || This procedure is added by ssumaith - bug# 4284505 for updating the invoice_id in the jai_Rcv_tp_invoices table
1654: || This procedure will be called from the trigger - ja_in_ap_aia_before_trg on ap_invoices_all
1655: */
1656: BEGIN
1657:
1658: UPDATE jai_rcv_tp_invoices