eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JL_AR_AP_WITHHOLDING_PKG dependencies on AP_UTILITIES_PKG

Line 3628: Ap_Utilities_Pkg.Ap_Round_Currency (

3624: P_Tab_Inv_Amounts(i).taxable_base_amount := 0 ;
3625: END IF;
3626:
3627: P_Tab_Inv_Amounts(i).taxable_base_amount :=
3628: Ap_Utilities_Pkg.Ap_Round_Currency (
3629: P_Tab_Inv_Amounts(i).taxable_base_amount,
3630: P_Currency_Code);
3631:
3632:

Line 3651: Ap_Utilities_Pkg.Ap_Round_Currency (

3647: P_Tab_Inv_Amounts(i).prorated_tax_incl_amt := 0;
3648: END IF;
3649:
3650: P_Tab_Inv_Amounts(i).prorated_tax_incl_amt :=
3651: Ap_Utilities_Pkg.Ap_Round_Currency (
3652: P_Tab_Inv_Amounts(i).prorated_tax_incl_amt,
3653: P_Currency_Code);
3654:
3655: -- Debug Information

Line 4637: SET amount_remaining = ap_utilities_pkg.ap_round_currency(

4633: --------------------------------------------------------
4634: -- Updates the amount remaining of the payment schedule
4635: --------------------------------------------------------
4636: UPDATE ap_payment_schedules
4637: SET amount_remaining = ap_utilities_pkg.ap_round_currency(
4638: amount_remaining - (l_withhold_amount * nvl(l_payment_cross_rate, 1)),
4639: l_payment_currency_code),
4640: payment_status_flag = decode( ap_utilities_pkg.ap_round_currency(amount_remaining -
4641: (l_withhold_amount *

Line 4640: payment_status_flag = decode( ap_utilities_pkg.ap_round_currency(amount_remaining -

4636: UPDATE ap_payment_schedules
4637: SET amount_remaining = ap_utilities_pkg.ap_round_currency(
4638: amount_remaining - (l_withhold_amount * nvl(l_payment_cross_rate, 1)),
4639: l_payment_currency_code),
4640: payment_status_flag = decode( ap_utilities_pkg.ap_round_currency(amount_remaining -
4641: (l_withhold_amount *
4642: nvl(l_payment_cross_rate, 1)),l_payment_currency_code),
4643: 0, 'Y',
4644: amount_remaining,

Line 4654: SET amount_paid = ap_utilities_pkg.ap_round_currency(

4650: -- Updates the amount paid of the invoice
4651: -- amount_paid does not affect MRC
4652: ------------------------------------------
4653: UPDATE ap_invoices
4654: SET amount_paid = ap_utilities_pkg.ap_round_currency(
4655: nvl(amount_paid, 0) +
4656: (l_withhold_amount *
4657: nvl(l_payment_cross_rate, 1)),l_payment_currency_code),
4658: payment_status_flag = AP_INVOICES_UTILITY_PKG.get_payment_status(l_invoice_id)

Line 4666: l_pay_amount := ap_utilities_pkg.ap_round_currency(

4662: -- Updates the payment amount
4663: -- Calling the AP Table Handler to update ap_invoice_payments.
4664: -- Bug 1827398
4665: --------------------------------------------------------------
4666: l_pay_amount := ap_utilities_pkg.ap_round_currency(
4667: l_pay_amount + (l_withhold_amount *
4668: nvl(l_payment_cross_rate, 1)), l_payment_currency_code);
4669:
4670: l_invoice_base_amount := ap_utilities_pkg.ap_round_currency(

Line 4670: l_invoice_base_amount := ap_utilities_pkg.ap_round_currency(

4666: l_pay_amount := ap_utilities_pkg.ap_round_currency(
4667: l_pay_amount + (l_withhold_amount *
4668: nvl(l_payment_cross_rate, 1)), l_payment_currency_code);
4669:
4670: l_invoice_base_amount := ap_utilities_pkg.ap_round_currency(
4671: l_invoice_base_amount +
4672: (l_withhold_amount * nvl(l_inv_exchange_rate, 1)), l_payment_currency_code);
4673:
4674: l_payment_base_amount := ap_utilities_pkg.ap_round_currency(

Line 4674: l_payment_base_amount := ap_utilities_pkg.ap_round_currency(

4670: l_invoice_base_amount := ap_utilities_pkg.ap_round_currency(
4671: l_invoice_base_amount +
4672: (l_withhold_amount * nvl(l_inv_exchange_rate, 1)), l_payment_currency_code);
4673:
4674: l_payment_base_amount := ap_utilities_pkg.ap_round_currency(
4675: l_payment_base_amount +
4676: (l_withhold_amount * nvl(l_payment_cross_rate, 1) *
4677: nvl(l_pay_exchange_rate, 1)),l_payment_currency_code);
4678:

Line 4713: l_amount := ap_utilities_pkg.ap_round_currency((l_amount + l_total_wh_amount),l_payment_currency_code);

4709: OPEN c_checks (P_Check_Id);
4710: FETCH c_checks INTO l_amount, l_base_amount, l_payment_currency_code;
4711: IF (NOT c_checks%NOTFOUND) THEN
4712:
4713: l_amount := ap_utilities_pkg.ap_round_currency((l_amount + l_total_wh_amount),l_payment_currency_code);
4714: l_base_amount := ap_utilities_pkg.ap_round_currency((l_base_amount + l_total_wh_base_amount),
4715: l_payment_currency_code);
4716:
4717: AP_AC_TABLE_HANDLER_PKG.Update_Amounts(

Line 4714: l_base_amount := ap_utilities_pkg.ap_round_currency((l_base_amount + l_total_wh_base_amount),

4710: FETCH c_checks INTO l_amount, l_base_amount, l_payment_currency_code;
4711: IF (NOT c_checks%NOTFOUND) THEN
4712:
4713: l_amount := ap_utilities_pkg.ap_round_currency((l_amount + l_total_wh_amount),l_payment_currency_code);
4714: l_base_amount := ap_utilities_pkg.ap_round_currency((l_base_amount + l_total_wh_base_amount),
4715: l_payment_currency_code);
4716:
4717: AP_AC_TABLE_HANDLER_PKG.Update_Amounts(
4718: P_check_id

Line 4960: l_withholding_amount := ap_utilities_pkg.ap_round_currency(l_withholding_amount,

4956: l_withholding_amount := l_withholding_amount /
4957: rec_sel_inv.invoice_exchange_rate *
4958: rec_sel_inv.payment_cross_rate;
4959:
4960: l_withholding_amount := ap_utilities_pkg.ap_round_currency(l_withholding_amount,
4961: l_payment_currency_code);
4962:
4963:
4964:

Line 4982: SET apsi.proposed_payment_amount = ap_utilities_pkg.ap_round_currency(

4978: -- RG Update Documents in PMT table
4979: -- As discussed with Ryan , we will keep updating ap selected invoices
4980:
4981: UPDATE ap_selected_invoices apsi
4982: SET apsi.proposed_payment_amount = ap_utilities_pkg.ap_round_currency(
4983: apsi.proposed_payment_amount - l_withholding_amount,
4984: l_payment_currency_code),
4985: apsi.payment_amount = ap_utilities_pkg.ap_round_currency(
4986: apsi.payment_amount - l_withholding_amount,

Line 4985: apsi.payment_amount = ap_utilities_pkg.ap_round_currency(

4981: UPDATE ap_selected_invoices apsi
4982: SET apsi.proposed_payment_amount = ap_utilities_pkg.ap_round_currency(
4983: apsi.proposed_payment_amount - l_withholding_amount,
4984: l_payment_currency_code),
4985: apsi.payment_amount = ap_utilities_pkg.ap_round_currency(
4986: apsi.payment_amount - l_withholding_amount,
4987: l_payment_currency_code),
4988: apsi.amount_remaining = ap_utilities_pkg.ap_round_currency(
4989: apsi.amount_remaining - l_withholding_amount,

Line 4988: apsi.amount_remaining = ap_utilities_pkg.ap_round_currency(

4984: l_payment_currency_code),
4985: apsi.payment_amount = ap_utilities_pkg.ap_round_currency(
4986: apsi.payment_amount - l_withholding_amount,
4987: l_payment_currency_code),
4988: apsi.amount_remaining = ap_utilities_pkg.ap_round_currency(
4989: apsi.amount_remaining - l_withholding_amount,
4990: l_payment_currency_code),
4991: apsi.withholding_amount = ap_utilities_pkg.ap_round_currency(
4992: l_withholding_amount, l_payment_currency_code)

Line 4991: apsi.withholding_amount = ap_utilities_pkg.ap_round_currency(

4987: l_payment_currency_code),
4988: apsi.amount_remaining = ap_utilities_pkg.ap_round_currency(
4989: apsi.amount_remaining - l_withholding_amount,
4990: l_payment_currency_code),
4991: apsi.withholding_amount = ap_utilities_pkg.ap_round_currency(
4992: l_withholding_amount, l_payment_currency_code)
4993: WHERE invoice_id = rec_sel_inv.invoice_id ;
4994: -- WHERE CURRENT OF c_selected_invoices;
4995:

Line 4998: SET docs.document_amount = ap_utilities_pkg.ap_round_currency(

4994: -- WHERE CURRENT OF c_selected_invoices;
4995:
4996:
4997: UPDATE iby_hook_docs_in_pmt_t docs
4998: SET docs.document_amount = ap_utilities_pkg.ap_round_currency(
4999: docs.document_amount - l_withholding_amount,
5000: l_payment_currency_code),
5001: docs.amount_withheld = ap_utilities_pkg.ap_round_currency(
5002: l_withholding_amount, l_payment_currency_code)

Line 5001: docs.amount_withheld = ap_utilities_pkg.ap_round_currency(

4997: UPDATE iby_hook_docs_in_pmt_t docs
4998: SET docs.document_amount = ap_utilities_pkg.ap_round_currency(
4999: docs.document_amount - l_withholding_amount,
5000: l_payment_currency_code),
5001: docs.amount_withheld = ap_utilities_pkg.ap_round_currency(
5002: l_withholding_amount, l_payment_currency_code)
5003: WHERE document_payable_id = rec_sel_inv.document_payable_id;
5004:
5005: l_total_wh_amount := l_total_wh_amount +

Line 5030: SET apsic.check_amount = ap_utilities_pkg.ap_round_currency(

5026: IF (NOT c_selected_invoice_checks%NOTFOUND) THEN
5027:
5028: /* RG
5029: UPDATE ap_selected_invoice_checks apsic
5030: SET apsic.check_amount = ap_utilities_pkg.ap_round_currency(
5031: NVL(l_prop_payment_amount, l_check_amount ) -
5032: l_total_wh_amount, apsic.currency_code),
5033: apsic.vendor_amount = ap_utilities_pkg.ap_round_currency(
5034: -1 * l_total_wh_amount, apsic.currency_code)

Line 5033: apsic.vendor_amount = ap_utilities_pkg.ap_round_currency(

5029: UPDATE ap_selected_invoice_checks apsic
5030: SET apsic.check_amount = ap_utilities_pkg.ap_round_currency(
5031: NVL(l_prop_payment_amount, l_check_amount ) -
5032: l_total_wh_amount, apsic.currency_code),
5033: apsic.vendor_amount = ap_utilities_pkg.ap_round_currency(
5034: -1 * l_total_wh_amount, apsic.currency_code)
5035: WHERE CURRENT OF c_selected_invoice_checks;
5036: */
5037: UPDATE iby_hook_payments_t ipmt

Line 5038: SET ipmt.payment_amount = ap_utilities_pkg.ap_round_currency(

5034: -1 * l_total_wh_amount, apsic.currency_code)
5035: WHERE CURRENT OF c_selected_invoice_checks;
5036: */
5037: UPDATE iby_hook_payments_t ipmt
5038: SET ipmt.payment_amount = ap_utilities_pkg.ap_round_currency(
5039: NVL(l_prop_payment_amount, l_check_amount ) -
5040: l_total_wh_amount, ipmt.payment_currency_code)
5041: WHERE CURRENT OF c_selected_invoice_checks;
5042: