APPS.JAI_AP_MATCH_TAX_PKG dependencies on AP_PAYMENT_SCHEDULES_ALL

Line 1083: v_payment_num ap_payment_schedules_all.payment_num%type;

1079: FUNCTION update_payment_schedule (p_total_tax NUMBER) RETURN boolean IS -- bug # 3218978
1080:
1081: v_total_tax_in_payment number;
1082: v_tax_installment number;
1083: v_payment_num ap_payment_schedules_all.payment_num%type;
1084: v_total_payment_amt number;
1085: v_diff_tax_amount number;
1086:
1087: cursor c_total_payment_amt is

Line 1089: from ap_payment_schedules_all

1085: v_diff_tax_amount number;
1086:
1087: cursor c_total_payment_amt is
1088: select sum(gross_amount)
1089: from ap_payment_schedules_all
1090: where invoice_id = inv_id;
1091:
1092: begin
1093:

Line 1112: from ap_payment_schedules_all

1108: for c_installments in
1109: (
1110: select gross_amount,
1111: payment_num
1112: from ap_payment_schedules_all
1113: where invoice_id = inv_id
1114: order by payment_num
1115: )
1116: loop

Line 1125: update ap_payment_schedules_all

1121: v_tax_installment := p_total_tax * (c_installments.gross_amount / v_total_payment_amt);
1122:
1123: v_tax_installment := round(v_tax_installment, ln_precision);
1124:
1125: update ap_payment_schedules_all
1126: set gross_amount = gross_amount + v_tax_installment,
1127: amount_remaining = amount_remaining + v_tax_installment,
1128: inv_curr_gross_amount = inv_curr_gross_amount + v_tax_installment,
1129: payment_status_flag = decode(payment_status_flag, 'Y', 'P', payment_status_flag)

Line 1143: update ap_payment_schedules_all

1139: if v_total_tax_in_payment <> p_total_tax then
1140:
1141: v_diff_tax_amount := round( p_total_tax - v_total_tax_in_payment,ln_precision);
1142:
1143: update ap_payment_schedules_all
1144: set gross_amount = gross_amount + v_diff_tax_amount,
1145: amount_remaining = amount_remaining + v_diff_tax_amount,
1146: inv_curr_gross_amount = inv_curr_gross_amount + v_diff_tax_amount
1147: where invoice_id = inv_id

Line 1633: records into ap_invoices_all , ap_invoices_distributions_all , ap_payment_Schedules_all

1629:
1630: 39. 01/11/2003 ssumaith - bug# 3127834 - file version 115.4
1631:
1632: currency precision was not used for rounding the tax amounts when inserting / updating
1633: records into ap_invoices_all , ap_invoices_distributions_all , ap_payment_Schedules_all
1634: tables. As a result the invoice was going into automatic hold because the invoice amount
1635: does not equal sum of distributions amount.
1636:
1637: This has been resolved in the bug by getting the currency precision for the invoice

Line 2972: * and ap_payment_schedules_all

2968: END LOOP;
2969:
2970: /* Bug 5358788. Added by Lakshmi Gopalsami
2971: * Removed the update which is updating ap_invoices_all
2972: * and ap_payment_schedules_all
2973: */
2974:
2975: ELSIF p_rematch = 'PAY_ON_RECEIPT' THEN
2976:

Line 6090: v_payment_num ap_payment_schedules_all.payment_num%type;

6086: FUNCTION update_payment_schedule (p_total_tax NUMBER) RETURN boolean IS -- bug # 3218978
6087:
6088: v_total_tax_in_payment number;
6089: v_tax_installment number;
6090: v_payment_num ap_payment_schedules_all.payment_num%type;
6091: v_total_payment_amt number;
6092: v_diff_tax_amount number;
6093:
6094: cursor c_total_payment_amt is

Line 6096: from ap_payment_schedules_all

6092: v_diff_tax_amount number;
6093:
6094: cursor c_total_payment_amt is
6095: select sum(gross_amount)
6096: from ap_payment_schedules_all
6097: where invoice_id = inv_id;
6098:
6099: begin
6100:

Line 6119: from ap_payment_schedules_all

6115: for c_installments in
6116: (
6117: select gross_amount,
6118: payment_num
6119: from ap_payment_schedules_all
6120: where invoice_id = inv_id
6121: order by payment_num
6122: )
6123: loop

Line 6132: update ap_payment_schedules_all

6128: v_tax_installment := p_total_tax * (c_installments.gross_amount / v_total_payment_amt);
6129:
6130: v_tax_installment := round(v_tax_installment, ln_precision);
6131:
6132: update ap_payment_schedules_all
6133: set gross_amount = gross_amount + v_tax_installment,
6134: amount_remaining = amount_remaining + v_tax_installment,
6135: inv_curr_gross_amount = inv_curr_gross_amount + v_tax_installment,
6136: payment_status_flag = decode(payment_status_flag, 'Y', 'P', payment_status_flag)

Line 6152: update ap_payment_schedules_all

6148: v_diff_tax_amount := p_total_tax - v_total_tax_in_payment;
6149:
6150: v_diff_tax_amount := round(v_diff_tax_amount,ln_precision);
6151:
6152: update ap_payment_schedules_all
6153: set gross_amount = gross_amount + v_diff_tax_amount,
6154: amount_remaining = amount_remaining + v_diff_tax_amount,
6155: inv_curr_gross_amount = inv_curr_gross_amount + v_diff_tax_amount,
6156: payment_status_flag = decode(payment_status_flag, 'Y', 'P', payment_status_flag)

Line 6295: ap_payment_schedules_all is written for scenario where rcv_transaction_id

6291:
6292: 8. 16/12/2002 cbabu for bug# 2713601, FileVersion # 615.6
6293: AP_PAYMENTS_SCHEDULES_ALL is not getting updated with the tax amount
6294: as soon as AP_INVOICES_ALL isgetting updated. Update statement for
6295: ap_payment_schedules_all is written for scenario where rcv_transaction_id
6296: in ap_invoice_distributions_all is NULL. Thsi happens in PO matching
6297: setup for ERS invoices.
6298:
6299: 9. 20/12/2002 Aparajita for bug # 2689826 Version # 615.7

Line 6503: records into ap_invoices_all , ap_invoices_distributions_all , ap_payment_Schedules_all

6499:
6500: 37. 01/11/2003 ssumaith - bug# 3127834 - file version 115.2
6501:
6502: currency precision was not used for rounding the tax amounts when inserting / updating
6503: records into ap_invoices_all , ap_invoices_distributions_all , ap_payment_Schedules_all
6504: tables. As a result the invoice was going into automatic hold because the invoice amount
6505: does not equal sum of distributions amount.
6506:
6507: This has been resolved in the bug by getting the currency precision for the invoice