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 3802: Ap_Utilities_Pkg.Ap_Round_Currency (

3798: P_Tab_Inv_Amounts(i).taxable_base_amount := 0 ;
3799: END IF;
3800:
3801: P_Tab_Inv_Amounts(i).taxable_base_amount :=
3802: Ap_Utilities_Pkg.Ap_Round_Currency (
3803: P_Tab_Inv_Amounts(i).taxable_base_amount,
3804: P_Currency_Code);
3805:
3806:

Line 3825: Ap_Utilities_Pkg.Ap_Round_Currency (

3821: P_Tab_Inv_Amounts(i).prorated_tax_incl_amt := 0;
3822: END IF;
3823:
3824: P_Tab_Inv_Amounts(i).prorated_tax_incl_amt :=
3825: Ap_Utilities_Pkg.Ap_Round_Currency (
3826: P_Tab_Inv_Amounts(i).prorated_tax_incl_amt,
3827: P_Currency_Code);
3828:
3829: -- Debug Information

Line 4874: SET amount_remaining = ap_utilities_pkg.ap_round_currency(

4870: --------------------------------------------------------
4871: -- Updates the amount remaining of the payment schedule
4872: --------------------------------------------------------
4873: UPDATE ap_payment_schedules
4874: SET amount_remaining = ap_utilities_pkg.ap_round_currency(
4875: amount_remaining - (l_withhold_amount * nvl(l_payment_cross_rate, 1)),
4876: l_payment_currency_code),
4877: payment_status_flag = decode( ap_utilities_pkg.ap_round_currency(amount_remaining -
4878: (l_withhold_amount *

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

4873: UPDATE ap_payment_schedules
4874: SET amount_remaining = ap_utilities_pkg.ap_round_currency(
4875: amount_remaining - (l_withhold_amount * nvl(l_payment_cross_rate, 1)),
4876: l_payment_currency_code),
4877: payment_status_flag = decode( ap_utilities_pkg.ap_round_currency(amount_remaining -
4878: (l_withhold_amount *
4879: nvl(l_payment_cross_rate, 1)),l_payment_currency_code),
4880: 0, 'Y',
4881: amount_remaining,

Line 4891: SET amount_paid = ap_utilities_pkg.ap_round_currency(

4887: -- Updates the amount paid of the invoice
4888: -- amount_paid does not affect MRC
4889: ------------------------------------------
4890: UPDATE ap_invoices
4891: SET amount_paid = ap_utilities_pkg.ap_round_currency(
4892: nvl(amount_paid, 0) +
4893: (l_withhold_amount *
4894: nvl(l_payment_cross_rate, 1)),l_payment_currency_code),
4895: payment_status_flag = AP_INVOICES_UTILITY_PKG.get_payment_status(l_invoice_id)

Line 4903: l_pay_amount := ap_utilities_pkg.ap_round_currency(

4899: -- Updates the payment amount
4900: -- Calling the AP Table Handler to update ap_invoice_payments.
4901: -- Bug 1827398
4902: --------------------------------------------------------------
4903: l_pay_amount := ap_utilities_pkg.ap_round_currency(
4904: l_pay_amount + (l_withhold_amount *
4905: nvl(l_payment_cross_rate, 1)), l_payment_currency_code);
4906:
4907: l_invoice_base_amount := ap_utilities_pkg.ap_round_currency(

Line 4907: l_invoice_base_amount := ap_utilities_pkg.ap_round_currency(

4903: l_pay_amount := ap_utilities_pkg.ap_round_currency(
4904: l_pay_amount + (l_withhold_amount *
4905: nvl(l_payment_cross_rate, 1)), l_payment_currency_code);
4906:
4907: l_invoice_base_amount := ap_utilities_pkg.ap_round_currency(
4908: l_invoice_base_amount +
4909: (l_withhold_amount * nvl(l_inv_exchange_rate, 1)), l_payment_currency_code);
4910:
4911: l_payment_base_amount := ap_utilities_pkg.ap_round_currency(

Line 4911: l_payment_base_amount := ap_utilities_pkg.ap_round_currency(

4907: l_invoice_base_amount := ap_utilities_pkg.ap_round_currency(
4908: l_invoice_base_amount +
4909: (l_withhold_amount * nvl(l_inv_exchange_rate, 1)), l_payment_currency_code);
4910:
4911: l_payment_base_amount := ap_utilities_pkg.ap_round_currency(
4912: l_payment_base_amount +
4913: (l_withhold_amount * nvl(l_payment_cross_rate, 1) *
4914: nvl(l_pay_exchange_rate, 1)),l_payment_currency_code);
4915:

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

4946: OPEN c_checks (P_Check_Id);
4947: FETCH c_checks INTO l_amount, l_base_amount, l_payment_currency_code;
4948: IF (NOT c_checks%NOTFOUND) THEN
4949:
4950: l_amount := ap_utilities_pkg.ap_round_currency((l_amount + l_total_wh_amount),l_payment_currency_code);
4951: l_base_amount := ap_utilities_pkg.ap_round_currency((l_base_amount + l_total_wh_base_amount),
4952: l_payment_currency_code);
4953:
4954: AP_AC_TABLE_HANDLER_PKG.Update_Amounts(

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

4947: FETCH c_checks INTO l_amount, l_base_amount, l_payment_currency_code;
4948: IF (NOT c_checks%NOTFOUND) THEN
4949:
4950: l_amount := ap_utilities_pkg.ap_round_currency((l_amount + l_total_wh_amount),l_payment_currency_code);
4951: l_base_amount := ap_utilities_pkg.ap_round_currency((l_base_amount + l_total_wh_base_amount),
4952: l_payment_currency_code);
4953:
4954: AP_AC_TABLE_HANDLER_PKG.Update_Amounts(
4955: P_check_id

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

5200: rec_sel_inv.payment_exchange_rate *
5201: -- Payment Exchange Rate ER 8648739 End 10
5202: rec_sel_inv.payment_cross_rate;
5203:
5204: l_withholding_amount := ap_utilities_pkg.ap_round_currency(l_withholding_amount,
5205: l_payment_currency_code);
5206:
5207:
5208:

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

5222: -- RG Update Documents in PMT table
5223: -- As discussed with Ryan , we will keep updating ap selected invoices
5224:
5225: UPDATE ap_selected_invoices apsi
5226: SET apsi.proposed_payment_amount = ap_utilities_pkg.ap_round_currency(
5227: apsi.proposed_payment_amount - l_withholding_amount,
5228: l_payment_currency_code),
5229: apsi.payment_amount = ap_utilities_pkg.ap_round_currency(
5230: apsi.payment_amount - l_withholding_amount,

Line 5229: apsi.payment_amount = ap_utilities_pkg.ap_round_currency(

5225: UPDATE ap_selected_invoices apsi
5226: SET apsi.proposed_payment_amount = ap_utilities_pkg.ap_round_currency(
5227: apsi.proposed_payment_amount - l_withholding_amount,
5228: l_payment_currency_code),
5229: apsi.payment_amount = ap_utilities_pkg.ap_round_currency(
5230: apsi.payment_amount - l_withholding_amount,
5231: l_payment_currency_code),
5232: -- bug: 9037712 :: Amount_remaining should not be updated.
5233: -- JL code modified to be in sync with AP side processing for PPRs.

Line 5234: -- apsi.amount_remaining = ap_utilities_pkg.ap_round_currency(

5230: apsi.payment_amount - l_withholding_amount,
5231: l_payment_currency_code),
5232: -- bug: 9037712 :: Amount_remaining should not be updated.
5233: -- JL code modified to be in sync with AP side processing for PPRs.
5234: -- apsi.amount_remaining = ap_utilities_pkg.ap_round_currency(
5235: -- apsi.amount_remaining - l_withholding_amount,
5236: -- l_payment_currency_code),
5237: apsi.withholding_amount = ap_utilities_pkg.ap_round_currency(
5238: l_withholding_amount, l_payment_currency_code)

Line 5237: apsi.withholding_amount = ap_utilities_pkg.ap_round_currency(

5233: -- JL code modified to be in sync with AP side processing for PPRs.
5234: -- apsi.amount_remaining = ap_utilities_pkg.ap_round_currency(
5235: -- apsi.amount_remaining - l_withholding_amount,
5236: -- l_payment_currency_code),
5237: apsi.withholding_amount = ap_utilities_pkg.ap_round_currency(
5238: l_withholding_amount, l_payment_currency_code)
5239: WHERE invoice_id = rec_sel_inv.invoice_id
5240: AND payment_num = rec_sel_inv.payment_num; --bug 12921144
5241: -- WHERE CURRENT OF c_selected_invoices;

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

5240: AND payment_num = rec_sel_inv.payment_num; --bug 12921144
5241: -- WHERE CURRENT OF c_selected_invoices;
5242:
5243: UPDATE iby_hook_docs_in_pmt_t docs
5244: SET docs.document_amount = ap_utilities_pkg.ap_round_currency(
5245: docs.document_amount - l_withholding_amount,
5246: l_payment_currency_code),
5247: docs.amount_withheld = ap_utilities_pkg.ap_round_currency(
5248: l_withholding_amount, l_payment_currency_code)

Line 5247: docs.amount_withheld = ap_utilities_pkg.ap_round_currency(

5243: UPDATE iby_hook_docs_in_pmt_t docs
5244: SET docs.document_amount = ap_utilities_pkg.ap_round_currency(
5245: docs.document_amount - l_withholding_amount,
5246: l_payment_currency_code),
5247: docs.amount_withheld = ap_utilities_pkg.ap_round_currency(
5248: l_withholding_amount, l_payment_currency_code)
5249: WHERE document_payable_id = rec_sel_inv.document_payable_id;
5250:
5251: l_total_wh_amount := l_total_wh_amount +

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

5272: IF (NOT c_selected_invoice_checks%NOTFOUND) THEN
5273:
5274: /* RG
5275: UPDATE ap_selected_invoice_checks apsic
5276: SET apsic.check_amount = ap_utilities_pkg.ap_round_currency(
5277: NVL(l_prop_payment_amount, l_check_amount ) -
5278: l_total_wh_amount, apsic.currency_code),
5279: apsic.vendor_amount = ap_utilities_pkg.ap_round_currency(
5280: -1 * l_total_wh_amount, apsic.currency_code)

Line 5279: apsic.vendor_amount = ap_utilities_pkg.ap_round_currency(

5275: UPDATE ap_selected_invoice_checks apsic
5276: SET apsic.check_amount = ap_utilities_pkg.ap_round_currency(
5277: NVL(l_prop_payment_amount, l_check_amount ) -
5278: l_total_wh_amount, apsic.currency_code),
5279: apsic.vendor_amount = ap_utilities_pkg.ap_round_currency(
5280: -1 * l_total_wh_amount, apsic.currency_code)
5281: WHERE CURRENT OF c_selected_invoice_checks;
5282: */
5283: UPDATE iby_hook_payments_t ipmt

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

5280: -1 * l_total_wh_amount, apsic.currency_code)
5281: WHERE CURRENT OF c_selected_invoice_checks;
5282: */
5283: UPDATE iby_hook_payments_t ipmt
5284: SET ipmt.payment_amount = ap_utilities_pkg.ap_round_currency(
5285: NVL(l_prop_payment_amount, l_check_amount ) -
5286: l_total_wh_amount, ipmt.payment_currency_code)
5287: WHERE CURRENT OF c_selected_invoice_checks;
5288: