DBA Data[Home] [Help]

APPS.AP_PAYMENT_SCHEDULES_PKG dependencies on AP_UTILITIES_PKG

Line 116: l_pay_curr_invoice_amount := ap_utilities_pkg.ap_round_currency(

112: l_pay_curr_orig_inv_amt;
113: debug_info := 'Close cursor invoice_cursor';
114: close invoice_cursor;
115:
116: l_pay_curr_invoice_amount := ap_utilities_pkg.ap_round_currency(
117: X_invoice_amount * l_payment_cross_rate,
118: l_payment_currency_code);
119: l_net_amount_to_adjust := X_invoice_amount - l_original_invoice_amount;
120: l_pay_curr_net_amt_to_adj := l_pay_curr_invoice_amount -

Line 479: select nvl(ap_utilities_pkg.ap_round_currency(

475: RETURN NUMBER
476: IS
477: l_wt_amt_to_subtract number :=0;
478: BEGIN
479: select nvl(ap_utilities_pkg.ap_round_currency(
480: ap_invoices_pkg.get_amount_withheld(ai.invoice_id)*
481: ai.payment_cross_rate,X_currency_code),0)*
482: X_gross_amount/decode(ai.pay_curr_invoice_amount, 0, 1,
483: nvl(ai.pay_curr_invoice_amount, 1))

Line 506: select nvl(ap_utilities_pkg.ap_round_currency(

502: l_gross_amount NUMBER; -- BUG 3741934
503: BEGIN
504:
505: -- bug 3484292 Added the select stmt below.
506: select nvl(ap_utilities_pkg.ap_round_currency(
507: ap_invoices_pkg.get_amount_withheld(ai.invoice_id)*
508: ai.payment_cross_rate,X_currency_code),0)*
509: aps.gross_amount/decode(ai.pay_curr_invoice_amount, 0, 1,
510: nvl(ai.pay_curr_invoice_amount, 1)),

Line 526: SELECT NVL(ap_utilities_pkg.ap_round_currency(

522: */
523:
524: IF l_wt_amt_to_subtract <> l_gross_amount
525: THEN
526: SELECT NVL(ap_utilities_pkg.ap_round_currency(
527: DECODE(gross_amount, 0, 0,
528: DECODE(air.always_take_disc_flag, 'Y', discount_amount_available, --Bug7717053, added the table alias
529: GREATEST(
530: DECODE(SIGN(X_check_date -