APPS.JAI_PA_BILLING_PKG dependencies on AP_INVOICES_ALL

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

35: ------------------------------------------------------------------------------------------------------------------------------*/
36: --
37: -- Forward declaration of private procedures
38: --
39: function update_payment_schedule (p_invoice_id ap_invoices_all.invoice_id%type, p_total_tax number)
40: return boolean ;
41: procedure update_mrc_data (p_invoice_id ap_invoices_all.invoice_id%type);
42: procedure insert_mrc_data (p_invoice_distribution_id number) ;
43:

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

37: -- Forward declaration of private procedures
38: --
39: function update_payment_schedule (p_invoice_id ap_invoices_all.invoice_id%type, p_total_tax number)
40: return boolean ;
41: procedure update_mrc_data (p_invoice_id ap_invoices_all.invoice_id%type);
42: procedure insert_mrc_data (p_invoice_distribution_id number) ;
43:
44: gv_package_body_version constant varchar2(30) := '115.0';
45:

Line 1582: from ap_invoices_all

1578: select invoice_id
1579: , batch_id
1580: , nvl(exchange_rate, 1) exchange_rate
1581: , invoice_currency_code
1582: from ap_invoices_all
1583: where invoice_id in ( select distinct apd.invoice_id
1584: from ap_invoice_distributions_all apd
1585: where ( (pn_request_id is not null and apd.request_id = pn_request_id)
1586: or (pn_invoice_id is not null and apd.invoice_id = pn_invoice_id)

Line 2090: update ap_invoices_all

2086:
2087: -- Invoice level proessing
2088: is_upd_pay_sch_success := update_payment_schedule(r_invs.invoice_id, ln_cum_tax_amt);
2089:
2090: update ap_invoices_all
2091: set invoice_amount = invoice_amount + ln_cum_tax_amt,
2092: approved_amount = approved_amount + ln_cum_tax_amt,
2093: pay_curr_invoice_amount = pay_curr_invoice_amount + ln_cum_tax_amt,
2094: amount_applicable_to_discount = amount_applicable_to_discount + ln_cum_tax_amt,

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

2104:
2105:
2106: /*------------------------------------------------------------------------------------------------------------*/
2107:
2108: function update_payment_schedule (p_invoice_id ap_invoices_all.invoice_id%type, p_total_tax NUMBER)
2109: return boolean is
2110:
2111: v_total_tax_in_payment number;
2112: v_tax_installment number;

Line 2127: from ap_invoices_all

2123:
2124: cursor c_get_inv_currency
2125: is
2126: select invoice_currency_code
2127: from ap_invoices_all
2128: where invoice_id = p_invoice_id;
2129:
2130: r_inv_curr c_get_inv_currency%rowtype;
2131:

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

2204: end update_payment_schedule;
2205:
2206: /*------------------------------------------------------------------------------------------------------------*/
2207:
2208: procedure update_mrc_data (p_invoice_id ap_invoices_all.invoice_id%type)
2209: is
2210: v_mrc_string VARCHAR2(10000);
2211: begin
2212: v_mrc_string := 'BEGIN AP_MRC_ENGINE_PKG.Maintain_MRC_Data (

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

2210: v_mrc_string VARCHAR2(10000);
2211: begin
2212: v_mrc_string := 'BEGIN AP_MRC_ENGINE_PKG.Maintain_MRC_Data (
2213: p_operation_mode => ''UPDATE'',
2214: p_table_name => ''AP_INVOICES_ALL'',
2215: p_key_value => :a,
2216: p_key_value_list => NULL,
2217: p_calling_sequence =>
2218: ''India Local Tax amount added to invoice header (Distribution_matching procedure)''