DBA Data[Home] [Help]

APPS.AP_ACCTG_PREPAY_DIST_PKG dependencies on AP_UTILITIES_PKG

Line 1911: l_prorated_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY

1907:
1908: ELSE
1909:
1910: IF (p_inv_dist_rec.line_type_lookup_code = 'AWT') THEN
1911: l_prorated_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY
1912: (p_prepay_dist_rec.amount * (-1*p_inv_dist_rec.amount)
1913: / l_total_dist_amount,
1914: p_inv_rec.invoice_currency_code);
1915: ELSE

Line 1916: /* l_prorated_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY

1912: (p_prepay_dist_rec.amount * (-1*p_inv_dist_rec.amount)
1913: / l_total_dist_amount,
1914: p_inv_rec.invoice_currency_code);
1915: ELSE
1916: /* l_prorated_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY
1917: (p_prepay_dist_rec.amount * p_inv_dist_rec.amount
1918: / g_total_inv_amount, --8244163
1919: p_inv_rec.invoice_currency_code);
1920: */

Line 1941: l_prorated_amount := ap_utilities_pkg.ap_round_currency(l_prorated_amount, p_inv_rec.invoice_currency_code);

1937: ), 0)
1938: INTO l_prorated_amount
1939: from sys.dual ;
1940:
1941: l_prorated_amount := ap_utilities_pkg.ap_round_currency(l_prorated_amount, p_inv_rec.invoice_currency_code);
1942:
1943: END IF; -- IF AWT line type
1944:
1945: END IF;

Line 1979: l_prorated_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY

1975:
1976: -- In case of cascade events we will recalculate the prorated amount and subtract
1977: -- this amount from the already calculated amount previously so that this would
1978: -- give us the amount that needs to be adjusted
1979: l_prorated_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY
1980: (((p_inv_dist_rec.amount * p_prepay_dist_rec.amount)
1981: / g_total_inv_amount) --8244163
1982: - AP_Accounting_Pay_Pkg.get_casc_prepay_sum
1983: (p_inv_dist_rec.invoice_distribution_id,

Line 2055: l_prorated_pay_amt := AP_UTILITIES_PKG.AP_Round_Currency(

2051: l_curr_calling_sequence);
2052:
2053:
2054: IF (p_inv_rec.invoice_currency_code <> p_pay_hist_rec.pmt_currency_code) THEN
2055: l_prorated_pay_amt := AP_UTILITIES_PKG.AP_Round_Currency(
2056: l_prorated_amount * p_inv_rec.payment_cross_rate,
2057: p_pay_hist_rec.pmt_currency_code);
2058: ELSE
2059: l_prorated_pay_amt := l_prorated_amount;

Line 2073: l_prorated_clr_amt := AP_UTILITIES_PKG.AP_Round_Currency(

2069: l_curr_calling_sequence);
2070:
2071: IF (p_clr_hist_rec.pmt_currency_code <> p_clr_hist_rec.bank_currency_code) THEN
2072:
2073: l_prorated_clr_amt := AP_UTILITIES_PKG.AP_Round_Currency(
2074: l_prorated_pay_amt * p_clr_hist_rec.pmt_to_base_xrate,
2075: p_pay_hist_rec.bank_currency_code);
2076: ELSE
2077: l_prorated_clr_amt := l_prorated_pay_amt;

Line 2111: l_qty_variance := AP_Utilities_PKG.AP_Round_Currency(

2107:
2108: IF p_inv_dist_rec.amount = 0 THEN
2109: l_qty_variance := 0;
2110: ELSE
2111: l_qty_variance := AP_Utilities_PKG.AP_Round_Currency(
2112: ((p_inv_dist_rec.quantity_variance * l_prorated_amount) /
2113: p_inv_dist_rec.amount),
2114: p_inv_rec.invoice_currency_code);
2115: END IF;

Line 2120: l_base_qty_variance := AP_Utilities_PKG.AP_Round_Currency(

2116:
2117: IF p_inv_dist_rec.base_amount = 0 THEN
2118: l_base_qty_variance := 0;
2119: ELSE
2120: l_base_qty_variance := AP_Utilities_PKG.AP_Round_Currency(
2121: ((p_inv_dist_rec.base_quantity_variance
2122: * l_pad_rec.base_amount)
2123: / p_inv_dist_rec.base_amount),
2124: p_inv_rec.base_currency_code);

Line 2134: l_amt_variance := AP_Utilities_PKG.AP_Round_Currency(

2130:
2131: IF p_inv_dist_rec.amount = 0 THEN
2132: l_amt_variance := 0;
2133: ELSE
2134: l_amt_variance := AP_Utilities_PKG.AP_Round_Currency(
2135: ((p_inv_dist_rec.amount_variance * l_prorated_amount) /
2136: p_inv_dist_rec.amount),
2137: p_inv_rec.invoice_currency_code);
2138: END IF;

Line 2143: l_base_amt_variance := AP_Utilities_PKG.AP_Round_Currency(

2139:
2140: IF p_inv_dist_rec.base_amount = 0 THEN
2141: l_base_amt_variance := 0;
2142: ELSE
2143: l_base_amt_variance := AP_Utilities_PKG.AP_Round_Currency(
2144: ((p_inv_dist_rec.base_amount_variance
2145: * l_pad_rec.base_amount)
2146: / p_inv_dist_rec.base_amount),
2147: p_inv_rec.base_currency_code);

Line 2295: l_prorated_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY

2291: IF g_total_inv_amount = 0 THEN --8244163
2292: l_prorated_amount := 0;
2293:
2294: ELSE
2295: l_prorated_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY
2296: (p_prepay_dist_rec.prepay_tax_diff_amount * p_inv_dist_rec.amount
2297: / g_total_inv_amount,
2298: p_inv_rec.invoice_currency_code);
2299:

Line 2317: l_prorated_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY

2313:
2314: -- In case of cascade events we will recalculate the prorated amount and subtract
2315: -- this amount from the already calculated amount previously so that this would
2316: -- give us the amount that needs to be adjusted
2317: l_prorated_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY
2318: (((p_inv_dist_rec.amount * p_prepay_dist_rec.prepay_tax_diff_amount)
2319: / g_total_inv_amount)
2320: - AP_Accounting_Pay_Pkg.get_casc_tax_diff_sum
2321: (p_inv_dist_rec.invoice_distribution_id,

Line 2388: l_prorated_clr_amt := AP_UTILITIES_PKG.AP_Round_Currency(

2384: l_curr_calling_sequence);
2385:
2386: IF (p_clr_hist_rec.pmt_currency_code <> p_clr_hist_rec.bank_currency_code) THEN
2387:
2388: l_prorated_clr_amt := AP_UTILITIES_PKG.AP_Round_Currency(
2389: l_prorated_pay_amt * p_clr_hist_rec.pmt_to_base_xrate,
2390: p_pay_hist_rec.bank_currency_code);
2391: ELSE
2392: l_prorated_clr_amt := l_prorated_pay_amt;

Line 2519: l_pay_erv_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

2515:
2516: /* For Cash Basis ERV is Difference between Payment Exchange Rate and
2517: either Receipt Exchange rate or PO distributions exchange rate */
2518:
2519: l_pay_erv_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
2520: (p_pay_hist_rec.pmt_to_base_xrate - l_po_pay_exchange_rate) *
2521: p_prorated_amount, p_pay_hist_rec.pmt_currency_code);
2522:
2523:

Line 2535: l_clr_erv_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

2531: calculated based on the difference between Prepay payment clearing exchange rate
2532: and either Receipt Exchange rate or PO distributions exchange rate */
2533:
2534: IF p_clr_hist_rec.pmt_currency_code IS NOT NULL THEN -- Bug 5701788.
2535: l_clr_erv_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
2536: (p_clr_hist_rec.pmt_to_base_xrate - l_po_pay_exchange_rate) *
2537: p_inv_dist_rec.amount, p_clr_hist_rec.pmt_currency_code);
2538: END IF;
2539:

Line 2552: l_inv_erv_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

2548: Exchange Rate and either Receipt Exchange rate or PO distributions
2549: exchange rate. This calculated ERV amount will be stored in the
2550: invoice_dist_base_amount column */
2551:
2552: l_inv_erv_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
2553: (p_inv_rec.exchange_rate - l_po_exchange_rate) *
2554: p_prorated_amount, p_inv_rec.invoice_currency_code);
2555:
2556: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN