APPS.JAI_AP_MATCH_TAX_PROC_PKG dependencies on AP_PAYMENT_SCHEDULES_ALL

Line 180: v_payment_num ap_payment_schedules_all.payment_num%type;

176: FUNCTION update_payment_schedule (p_total_tax NUMBER, p_invoice_id NUMBER, p_precision NUMBER) RETURN boolean IS
177:
178: v_total_tax_in_payment number;
179: v_tax_installment number;
180: v_payment_num ap_payment_schedules_all.payment_num%type;
181: v_total_payment_amt number;
182: v_diff_tax_amount number;
183:
184: cursor c_total_payment_amt is

Line 186: from ap_payment_schedules_all

182: v_diff_tax_amount number;
183:
184: cursor c_total_payment_amt is
185: select sum(gross_amount)
186: from ap_payment_schedules_all
187: where invoice_id = p_invoice_id;
188:
189: l_api_name CONSTANT VARCHAR2(30) := 'update_payment_schedule';
190: BEGIN

Line 220: from ap_payment_schedules_all

216: for c_installments in
217: (
218: select gross_amount,
219: payment_num
220: from ap_payment_schedules_all
221: where invoice_id = p_invoice_id
222: order by payment_num
223: )
224: loop

Line 233: update ap_payment_schedules_all

229: v_tax_installment := p_total_tax * (c_installments.gross_amount / nvl(v_total_payment_amt,1));
230:
231: v_tax_installment := round(v_tax_installment, p_precision);
232:
233: update ap_payment_schedules_all
234: set gross_amount = gross_amount + v_tax_installment,
235: amount_remaining = amount_remaining + v_tax_installment,
236: inv_curr_gross_amount = inv_curr_gross_amount + v_tax_installment,
237: payment_status_flag = decode(payment_status_flag, 'Y', 'P', payment_status_flag)

Line 253: update ap_payment_schedules_all

249: if v_total_tax_in_payment <> p_total_tax then
250:
251: v_diff_tax_amount := round( p_total_tax - v_total_tax_in_payment,p_precision);
252:
253: update ap_payment_schedules_all
254: set gross_amount = gross_amount + v_diff_tax_amount,
255: amount_remaining = amount_remaining + v_diff_tax_amount,
256: inv_curr_gross_amount = inv_curr_gross_amount + v_diff_tax_amount
257: where invoice_id = p_invoice_id