APPS.JAI_AP_ST_REVERSE_PROCESS dependencies on AP_PAYMENT_SCHEDULES_ALL

Line 3752: v_payment_num ap_payment_schedules_all.payment_num%type;

3748: FUNCTION update_payment_schedule (p_total_tax NUMBER) RETURN boolean IS -- bug # 3218978
3749:
3750: v_total_tax_in_payment number;
3751: v_tax_installment number;
3752: v_payment_num ap_payment_schedules_all.payment_num%type;
3753: v_total_payment_amt number;
3754: v_diff_tax_amount number;
3755:
3756: cursor c_total_payment_amt is

Line 3758: from ap_payment_schedules_all

3754: v_diff_tax_amount number;
3755:
3756: cursor c_total_payment_amt is
3757: select sum(gross_amount)
3758: from ap_payment_schedules_all
3759: where invoice_id = inv_id;
3760:
3761: begin
3762:

Line 3783: from ap_payment_schedules_all

3779: for c_installments in
3780: (
3781: select gross_amount,
3782: payment_num
3783: from ap_payment_schedules_all
3784: where invoice_id = inv_id
3785: order by payment_num
3786: )
3787: loop

Line 3796: update ap_payment_schedules_all

3792: v_tax_installment := p_total_tax * (c_installments.gross_amount / nvl(v_total_payment_amt,1));
3793:
3794: v_tax_installment := round(v_tax_installment, ln_precision);
3795:
3796: update ap_payment_schedules_all
3797: set gross_amount = gross_amount + v_tax_installment,
3798: amount_remaining = amount_remaining + v_tax_installment,
3799: inv_curr_gross_amount = inv_curr_gross_amount + v_tax_installment,
3800: payment_status_flag = decode(payment_status_flag, 'Y', 'P', payment_status_flag)

Line 3814: update ap_payment_schedules_all

3810: if v_total_tax_in_payment <> p_total_tax then
3811:
3812: v_diff_tax_amount := round( p_total_tax - v_total_tax_in_payment,ln_precision);
3813:
3814: update ap_payment_schedules_all
3815: set gross_amount = gross_amount + v_diff_tax_amount,
3816: amount_remaining = amount_remaining + v_diff_tax_amount,
3817: inv_curr_gross_amount = inv_curr_gross_amount + v_diff_tax_amount
3818: where invoice_id = inv_id

Line 5781: v_payment_num ap_payment_schedules_all.payment_num%type;

5777: FUNCTION update_payment_schedule (p_total_tax NUMBER) RETURN boolean IS -- bug # 3218978
5778:
5779: v_total_tax_in_payment number;
5780: v_tax_installment number;
5781: v_payment_num ap_payment_schedules_all.payment_num%type;
5782: v_total_payment_amt number;
5783: v_diff_tax_amount number;
5784:
5785: cursor c_total_payment_amt is

Line 5787: from ap_payment_schedules_all

5783: v_diff_tax_amount number;
5784:
5785: cursor c_total_payment_amt is
5786: select sum(gross_amount)
5787: from ap_payment_schedules_all
5788: where invoice_id = inv_id;
5789:
5790: begin
5791:

Line 5812: from ap_payment_schedules_all

5808: for c_installments in
5809: (
5810: select gross_amount,
5811: payment_num
5812: from ap_payment_schedules_all
5813: where invoice_id = inv_id
5814: order by payment_num
5815: )
5816: loop

Line 5825: update ap_payment_schedules_all

5821: v_tax_installment := p_total_tax * (c_installments.gross_amount / nvl(v_total_payment_amt,1));
5822:
5823: v_tax_installment := round(v_tax_installment, ln_precision);
5824:
5825: update ap_payment_schedules_all
5826: set gross_amount = gross_amount + v_tax_installment,
5827: amount_remaining = amount_remaining + v_tax_installment,
5828: inv_curr_gross_amount = inv_curr_gross_amount + v_tax_installment,
5829: payment_status_flag = decode(payment_status_flag, 'Y', 'P', payment_status_flag)

Line 5845: update ap_payment_schedules_all

5841: v_diff_tax_amount := p_total_tax - v_total_tax_in_payment;
5842:
5843: v_diff_tax_amount := round(v_diff_tax_amount,ln_precision);
5844:
5845: update ap_payment_schedules_all
5846: set gross_amount = gross_amount + v_diff_tax_amount,
5847: amount_remaining = amount_remaining + v_diff_tax_amount,
5848: inv_curr_gross_amount = inv_curr_gross_amount + v_diff_tax_amount,
5849: payment_status_flag = decode(payment_status_flag, 'Y', 'P', payment_status_flag)