APPS.JAI_PA_BILLING_PKG dependencies on AP_INVOICES_ALL

Line 26: function update_payment_schedule (p_invoice_id ap_invoices_all.invoice_id%type, p_total_tax number)

22: ------------------------------------------------------------------------------------------------------------------------------*/
23: --
24: -- Forward declaration of private procedures
25: --
26: function update_payment_schedule (p_invoice_id ap_invoices_all.invoice_id%type, p_total_tax number)
27: return boolean ;
28: procedure update_mrc_data (p_invoice_id ap_invoices_all.invoice_id%type);
29: procedure insert_mrc_data (p_invoice_distribution_id number) ;
30:

Line 28: procedure update_mrc_data (p_invoice_id ap_invoices_all.invoice_id%type);

24: -- Forward declaration of private procedures
25: --
26: function update_payment_schedule (p_invoice_id ap_invoices_all.invoice_id%type, p_total_tax number)
27: return boolean ;
28: procedure update_mrc_data (p_invoice_id ap_invoices_all.invoice_id%type);
29: procedure insert_mrc_data (p_invoice_distribution_id number) ;
30:
31: gv_package_body_version constant varchar2(30) := '115.0';
32:

Line 1546: from ap_invoices_all

1542: select invoice_id
1543: , batch_id
1544: , nvl(exchange_rate, 1) exchange_rate
1545: , invoice_currency_code
1546: from ap_invoices_all
1547: where invoice_id in ( select distinct apd.invoice_id
1548: from ap_invoice_distributions_all apd
1549: where ( (pn_request_id is not null and apd.request_id = pn_request_id)
1550: or (pn_invoice_id is not null and apd.invoice_id = pn_invoice_id)

Line 2054: update ap_invoices_all

2050:
2051: -- Invoice level proessing
2052: is_upd_pay_sch_success := update_payment_schedule(r_invs.invoice_id, ln_cum_tax_amt);
2053:
2054: update ap_invoices_all
2055: set invoice_amount = invoice_amount + ln_cum_tax_amt,
2056: approved_amount = approved_amount + ln_cum_tax_amt,
2057: pay_curr_invoice_amount = pay_curr_invoice_amount + ln_cum_tax_amt,
2058: amount_applicable_to_discount = amount_applicable_to_discount + ln_cum_tax_amt,

Line 2072: function update_payment_schedule (p_invoice_id ap_invoices_all.invoice_id%type, p_total_tax NUMBER)

2068:
2069:
2070: /*------------------------------------------------------------------------------------------------------------*/
2071:
2072: function update_payment_schedule (p_invoice_id ap_invoices_all.invoice_id%type, p_total_tax NUMBER)
2073: return boolean is
2074:
2075: v_total_tax_in_payment number;
2076: v_tax_installment number;

Line 2091: from ap_invoices_all

2087:
2088: cursor c_get_inv_currency
2089: is
2090: select invoice_currency_code
2091: from ap_invoices_all
2092: where invoice_id = p_invoice_id;
2093:
2094: r_inv_curr c_get_inv_currency%rowtype;
2095:

Line 2172: procedure update_mrc_data (p_invoice_id ap_invoices_all.invoice_id%type)

2168: end update_payment_schedule;
2169:
2170: /*------------------------------------------------------------------------------------------------------------*/
2171:
2172: procedure update_mrc_data (p_invoice_id ap_invoices_all.invoice_id%type)
2173: is
2174: v_mrc_string VARCHAR2(10000);
2175: begin
2176: v_mrc_string := 'BEGIN AP_MRC_ENGINE_PKG.Maintain_MRC_Data (

Line 2178: p_table_name => ''AP_INVOICES_ALL'',

2174: v_mrc_string VARCHAR2(10000);
2175: begin
2176: v_mrc_string := 'BEGIN AP_MRC_ENGINE_PKG.Maintain_MRC_Data (
2177: p_operation_mode => ''UPDATE'',
2178: p_table_name => ''AP_INVOICES_ALL'',
2179: p_key_value => :a,
2180: p_key_value_list => NULL,
2181: p_calling_sequence =>
2182: ''India Local Tax amount added to invoice header (Distribution_matching procedure)''