DBA Data[Home] [Help]

APPS.AP_PAYMENT_SCHEDULES_PKG dependencies on AP_UTILITIES_PKG

Line 122: l_pay_curr_invoice_amount := ap_utilities_pkg.ap_round_currency(

118: l_pay_curr_orig_inv_amt;
119: debug_info := 'Close cursor invoice_cursor';
120: close invoice_cursor;
121:
122: l_pay_curr_invoice_amount := ap_utilities_pkg.ap_round_currency(
123: X_invoice_amount * l_payment_cross_rate,
124: l_payment_currency_code);
125: l_net_amount_to_adjust := X_invoice_amount - l_original_invoice_amount;
126: l_pay_curr_net_amt_to_adj := l_pay_curr_invoice_amount -

Line 492: select nvl(ap_utilities_pkg.ap_round_currency(

488: RETURN NUMBER
489: IS
490: l_wt_amt_to_subtract number :=0;
491: BEGIN
492: select nvl(ap_utilities_pkg.ap_round_currency(
493: ap_invoices_pkg.get_amount_withheld(ai.invoice_id)*
494: ai.payment_cross_rate,X_currency_code),0)*
495: X_gross_amount/decode(ai.pay_curr_invoice_amount, 0, 1,
496: nvl(ai.pay_curr_invoice_amount, 1))

Line 519: select nvl(ap_utilities_pkg.ap_round_currency(

515: l_gross_amount NUMBER; -- BUG 3741934
516: BEGIN
517:
518: -- bug 3484292 Added the select stmt below.
519: select nvl(ap_utilities_pkg.ap_round_currency(
520: ap_invoices_pkg.get_amount_withheld(ai.invoice_id)*
521: ai.payment_cross_rate,X_currency_code),0)*
522: aps.gross_amount/decode(ai.pay_curr_invoice_amount, 0, 1,
523: nvl(ai.pay_curr_invoice_amount, 1)),

Line 539: SELECT NVL(ap_utilities_pkg.ap_round_currency(

535: */
536:
537: IF l_wt_amt_to_subtract <> l_gross_amount
538: THEN
539: SELECT NVL(ap_utilities_pkg.ap_round_currency(
540: DECODE(gross_amount, 0, 0,
541: DECODE(air.always_take_disc_flag, 'Y', discount_amount_available, --Bug7717053, added the table alias
542: GREATEST(
543: DECODE(SIGN(X_check_date -