DBA Data[Home] [Help]

APPS.AP_ACCTG_PAY_DIST_PKG dependencies on AP_UTILITIES_PKG

Line 2186: l_pay_amount_bank_curr := AP_Utilities_Pkg.AP_Round_Currency(

2182: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
2183: END IF;
2184:
2185:
2186: l_pay_amount_bank_curr := AP_Utilities_Pkg.AP_Round_Currency(
2187: p_inv_pay_rec.amount * p_pay_hist_rec.pmt_to_base_xrate
2188: /p_pay_hist_rec.bank_to_base_xrate,
2189: p_pay_hist_rec.bank_currency_code);
2190:

Line 2191: l_dist_amt_bank_curr := AP_Utilities_Pkg.AP_Round_Currency(

2187: p_inv_pay_rec.amount * p_pay_hist_rec.pmt_to_base_xrate
2188: /p_pay_hist_rec.bank_to_base_xrate,
2189: p_pay_hist_rec.bank_currency_code);
2190:
2191: l_dist_amt_bank_curr := AP_Utilities_Pkg.AP_Round_Currency(
2192: l_dist_amt_pay_curr * p_pay_hist_rec.pmt_to_base_xrate
2193: /p_pay_hist_rec.bank_to_base_xrate,
2194: p_pay_hist_rec.bank_currency_code);
2195:

Line 2361: AP_Utilities_Pkg.AP_Round_Currency(

2357: IF ( p_pay_hist_rec.pmt_currency_code <> p_pay_hist_rec.bank_currency_code
2358: AND p_pay_hist_rec.bank_currency_code is not NULL ) THEN
2359:
2360: l_tot_prepaid_amt_bank_curr :=
2361: AP_Utilities_Pkg.AP_Round_Currency(
2362: l_tot_prepaid_amt_pay_curr * p_pay_hist_rec.pmt_to_base_xrate
2363: /p_pay_hist_rec.bank_to_base_xrate,
2364: p_pay_hist_rec.bank_currency_code);
2365:

Line 2464: l_bank_curr_amount := AP_Utilities_Pkg.AP_Round_Currency(

2460:
2461: IF ( p_pay_hist_rec.pmt_currency_code <> p_pay_hist_rec.bank_currency_code
2462: and p_pay_hist_rec.bank_currency_code is not null ) THEN
2463:
2464: l_bank_curr_amount := AP_Utilities_Pkg.AP_Round_Currency(
2465: l_prorated_amount * p_pay_hist_rec.pmt_to_base_xrate
2466: /p_pay_hist_rec.bank_to_base_xrate,
2467: p_pay_hist_rec.bank_currency_code);
2468:

Line 2487: l_prorated_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY

2483:
2484: /* We need to calculate the payment amount and invoice dist amount
2485: seperately to avoid rounding when calculating the base amounts */
2486:
2487: l_prorated_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY
2488: (p_inv_pay_rec.amount * p_inv_dist_rec.amount
2489: / l_proration_divisor,
2490: p_pay_hist_rec.pmt_currency_code);
2491:

Line 2492: l_inv_dist_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY

2488: (p_inv_pay_rec.amount * p_inv_dist_rec.amount
2489: / l_proration_divisor,
2490: p_pay_hist_rec.pmt_currency_code);
2491:
2492: l_inv_dist_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY
2493: (l_pay_amount_inv_curr * p_inv_dist_rec.amount
2494: / l_proration_divisor,
2495: p_inv_rec.invoice_currency_code);
2496:

Line 2499: l_bank_curr_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY

2495: p_inv_rec.invoice_currency_code);
2496:
2497: -- bug 5638490
2498: IF ( p_pay_hist_rec.bank_currency_code is not null ) THEN
2499: l_bank_curr_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY
2500: (l_pay_amount_bank_curr * p_inv_dist_rec.amount
2501: / l_proration_divisor,
2502: p_pay_hist_rec.bank_currency_code);
2503: ELSE

Line 2582: l_bank_curr_amount := AP_Utilities_Pkg.AP_Round_Currency(

2578:
2579: IF ( p_pay_hist_rec.pmt_currency_code <> p_pay_hist_rec.bank_currency_code and
2580: p_pay_hist_rec.bank_currency_code is not NULL ) THEN
2581:
2582: l_bank_curr_amount := AP_Utilities_Pkg.AP_Round_Currency(
2583: l_prorated_amount * p_pay_hist_rec.pmt_to_base_xrate
2584: /p_pay_hist_rec.bank_to_base_xrate,
2585: p_pay_hist_rec.bank_currency_code) -
2586: AP_Accounting_Pay_Pkg.get_casc_bank_curr_sum(

Line 2608: l_prorated_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY

2604:
2605: -- In case of cascade events we will recalculate the prorated amount and subtract
2606: -- this amount from the already calculated amount previously so that this would
2607: -- give us the amount that needs to be adjusted
2608: l_prorated_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY
2609: (((p_inv_dist_rec.amount * p_inv_pay_rec.amount)
2610: / l_proration_divisor)
2611: - AP_Accounting_Pay_Pkg.get_casc_pay_sum
2612: (p_inv_dist_rec.invoice_distribution_id,

Line 2618: l_inv_dist_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY

2614: p_inv_pay_rec.invoice_payment_id,
2615: l_curr_calling_sequence),
2616: p_pay_hist_rec.pmt_currency_code);
2617:
2618: l_inv_dist_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY
2619: (((p_inv_dist_rec.amount * l_pay_amount_inv_curr)
2620: / l_proration_divisor)
2621: - AP_Accounting_Pay_Pkg.get_casc_inv_dist_sum
2622: (p_inv_dist_rec.invoice_distribution_id,

Line 2630: l_bank_curr_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY

2626: p_inv_rec.invoice_currency_code);
2627:
2628: IF ( p_pay_hist_rec.bank_currency_code is not NULL ) THEN
2629:
2630: l_bank_curr_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY
2631: (((p_inv_dist_rec.amount * l_pay_amount_bank_curr)
2632: / l_proration_divisor)
2633: - AP_Accounting_Pay_Pkg.get_casc_bank_curr_sum
2634: (p_inv_dist_rec.invoice_distribution_id,

Line 2803: l_qty_variance := AP_Utilities_PKG.AP_Round_Currency(

2799:
2800: IF p_inv_dist_rec.amount = 0 THEN
2801: l_qty_variance := 0;
2802: ELSE
2803: l_qty_variance := AP_Utilities_PKG.AP_Round_Currency(
2804: ((p_inv_dist_rec.quantity_variance * l_inv_dist_amount) /
2805: p_inv_dist_rec.amount),
2806: p_inv_rec.invoice_currency_code);
2807: END IF;

Line 2812: l_base_qty_variance := AP_Utilities_PKG.AP_Round_Currency(

2808:
2809: IF p_inv_dist_rec.base_amount = 0 THEN
2810: l_base_qty_variance := 0;
2811: ELSE
2812: l_base_qty_variance := AP_Utilities_PKG.AP_Round_Currency(
2813: ((p_inv_dist_rec.base_quantity_variance
2814: * l_pd_rec.invoice_dist_base_amount)
2815: / p_inv_dist_rec.base_amount),
2816: ap_accounting_pay_pkg.g_base_currency_code);

Line 2830: l_amt_variance := AP_Utilities_PKG.AP_Round_Currency(

2826:
2827: IF p_inv_dist_rec.amount = 0 THEN
2828: l_amt_variance := 0;
2829: ELSE
2830: l_amt_variance := AP_Utilities_PKG.AP_Round_Currency(
2831: ((p_inv_dist_rec.amount_variance * l_inv_dist_amount) /
2832: p_inv_dist_rec.amount),
2833: p_inv_rec.invoice_currency_code);
2834: END IF;

Line 2839: l_base_amt_variance := AP_Utilities_PKG.AP_Round_Currency(

2835:
2836: IF p_inv_dist_rec.base_amount = 0 THEN
2837: l_base_amt_variance := 0;
2838: ELSE
2839: l_base_amt_variance := AP_Utilities_PKG.AP_Round_Currency(
2840: ((p_inv_dist_rec.base_amount_variance
2841: * l_pd_rec.invoice_dist_base_amount)
2842: / p_inv_dist_rec.base_amount),
2843: ap_accounting_pay_pkg.g_base_currency_code);

Line 3084: AP_Utilities_Pkg.AP_Round_Currency(

3080: END IF;
3081:
3082:
3083: l_disc_amt_bank_curr :=
3084: AP_Utilities_Pkg.AP_Round_Currency(
3085: p_inv_pay_rec.discount_taken * p_pay_hist_rec.pmt_to_base_xrate
3086: /p_pay_hist_rec.bank_to_base_xrate,
3087: p_pay_hist_rec.bank_currency_code);
3088:

Line 3145: l_prorated_disc_amt := AP_UTILITIES_PKG.AP_ROUND_CURRENCY

3141: l_bank_curr_amount := 0;
3142:
3143: ELSE
3144:
3145: l_prorated_disc_amt := AP_UTILITIES_PKG.AP_ROUND_CURRENCY
3146: (p_inv_pay_rec.discount_taken * p_inv_dist_rec.amount
3147: / l_invoice_amount,
3148: p_pay_hist_rec.pmt_currency_code);
3149:

Line 3150: l_inv_dist_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY

3146: (p_inv_pay_rec.discount_taken * p_inv_dist_rec.amount
3147: / l_invoice_amount,
3148: p_pay_hist_rec.pmt_currency_code);
3149:
3150: l_inv_dist_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY
3151: (l_disc_amt_inv_curr * p_inv_dist_rec.amount
3152: / l_invoice_amount,
3153: p_inv_rec.invoice_currency_code);
3154:

Line 3157: l_bank_curr_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY

3153: p_inv_rec.invoice_currency_code);
3154:
3155:
3156: IF ( p_pay_hist_rec.bank_currency_code is not NULL ) THEN
3157: l_bank_curr_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY
3158: (l_disc_amt_bank_curr * p_inv_dist_rec.amount
3159: / l_invoice_amount,
3160: p_pay_hist_rec.bank_currency_code);
3161:

Line 3184: l_prorated_disc_amt := AP_UTILITIES_PKG.AP_ROUND_CURRENCY

3180: l_log_msg := 'seems cascade mode - p_calc_mode = ' || p_calc_mode;
3181: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
3182: END IF;
3183:
3184: l_prorated_disc_amt := AP_UTILITIES_PKG.AP_ROUND_CURRENCY
3185: (p_inv_pay_rec.discount_taken * p_inv_dist_rec.amount
3186: / l_invoice_amount,
3187: p_pay_hist_rec.pmt_currency_code)
3188: - ap_accounting_pay_pkg.get_casc_discount_sum

Line 3194: l_inv_dist_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY

3190: p_pay_hist_rec.related_event_id,
3191: p_inv_pay_rec.invoice_payment_id,
3192: l_curr_calling_sequence);
3193:
3194: l_inv_dist_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY
3195: (l_disc_amt_inv_curr * p_inv_dist_rec.amount
3196: / l_invoice_amount,
3197: p_inv_rec.invoice_currency_code)
3198: - ap_accounting_pay_pkg.get_casc_inv_dist_disc_sum

Line 3205: l_inv_dist_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY

3201: p_inv_pay_rec.invoice_payment_id,
3202: l_curr_calling_sequence);
3203:
3204: IF ( p_pay_hist_rec.bank_currency_code is not NULL ) THEN
3205: l_inv_dist_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY
3206: (l_disc_amt_bank_curr * p_inv_dist_rec.amount
3207: / l_invoice_amount,
3208: p_pay_hist_rec.bank_currency_code)
3209: - ap_accounting_pay_pkg.get_casc_bank_curr_disc_sum

Line 3444: l_erv_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

3440:
3441: /* For Cash Basis ERV is Difference between Payment Exchange Rate and
3442: either Receipt Exchange rate or PO distributions exchange rate */
3443:
3444: l_erv_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
3445: (p_pay_hist_rec.pmt_to_base_xrate - l_po_pay_exchange_rate) *
3446: p_prorated_amount, p_pay_hist_rec.pmt_currency_code);
3447:
3448:

Line 3455: l_inv_erv_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

3451: Exchange Rate and either Receipt Exchange rate or PO distributions
3452: exchange rate. This calculated ERV amount will be stored in the
3453: invoice_dist_base_amount column */
3454:
3455: l_inv_erv_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
3456: (p_inv_rec.exchange_rate - l_po_pay_exchange_rate) *
3457: p_prorated_amount, p_inv_rec.invoice_currency_code);
3458:
3459:

Line 3637: l_prorated_amt := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

3633:
3634: IF l_total_dist_amt = l_total_pay_amt THEN
3635: l_prorated_amt := l_err_chrg_amount - l_total_prorated_amt;
3636: ELSE
3637: l_prorated_amt := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
3638: l_err_chrg_amount * l_clr_rec.amount
3639: / l_total_pay_amt, p_pay_hist_rec.pmt_currency_code);
3640: END IF;
3641: