DBA Data[Home] [Help]

APPS.AP_ACCTG_PREPAY_DIST_PKG dependencies on AP_UTILITIES_PKG

Line 1285: l_prorated_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY

1281:
1282: ELSE
1283:
1284: IF (p_inv_dist_rec.line_type_lookup_code = 'AWT') THEN
1285: l_prorated_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY
1286: (p_prepay_dist_rec.amount * (-1*p_inv_dist_rec.amount)
1287: / l_total_dist_amount,
1288: p_inv_rec.invoice_currency_code);
1289: ELSE

Line 1290: l_prorated_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY

1286: (p_prepay_dist_rec.amount * (-1*p_inv_dist_rec.amount)
1287: / l_total_dist_amount,
1288: p_inv_rec.invoice_currency_code);
1289: ELSE
1290: l_prorated_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY
1291: (p_prepay_dist_rec.amount * p_inv_dist_rec.amount
1292: / p_inv_rec.invoice_amount,
1293: p_inv_rec.invoice_currency_code);
1294: END IF; -- IF AWT line type

Line 1330: l_prorated_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY

1326:
1327: -- In case of cascade events we will recalculate the prorated amount and subtract
1328: -- this amount from the already calculated amount previously so that this would
1329: -- give us the amount that needs to be adjusted
1330: l_prorated_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY
1331: (((p_inv_dist_rec.amount * p_prepay_dist_rec.amount)
1332: / p_inv_rec.invoice_amount)
1333: - AP_Accounting_Pay_Pkg.get_casc_prepay_sum
1334: (p_inv_dist_rec.invoice_distribution_id,

Line 1388: l_prorated_pay_amt := AP_UTILITIES_PKG.AP_Round_Currency(

1384: l_curr_calling_sequence);
1385:
1386:
1387: IF (p_inv_rec.invoice_currency_code <> p_pay_hist_rec.pmt_currency_code) THEN
1388: l_prorated_pay_amt := AP_UTILITIES_PKG.AP_Round_Currency(
1389: l_prorated_amount * p_inv_rec.payment_cross_rate,
1390: p_pay_hist_rec.pmt_currency_code);
1391: ELSE
1392: l_prorated_pay_amt := l_prorated_amount;

Line 1406: l_prorated_clr_amt := AP_UTILITIES_PKG.AP_Round_Currency(

1402: l_curr_calling_sequence);
1403:
1404: IF (p_clr_hist_rec.pmt_currency_code <> p_clr_hist_rec.bank_currency_code) THEN
1405:
1406: l_prorated_clr_amt := AP_UTILITIES_PKG.AP_Round_Currency(
1407: l_prorated_pay_amt * p_clr_hist_rec.pmt_to_base_xrate,
1408: p_pay_hist_rec.bank_currency_code);
1409: ELSE
1410: l_prorated_clr_amt := l_prorated_pay_amt;

Line 1444: l_qty_variance := AP_Utilities_PKG.AP_Round_Currency(

1440:
1441: IF p_inv_dist_rec.amount = 0 THEN
1442: l_qty_variance := 0;
1443: ELSE
1444: l_qty_variance := AP_Utilities_PKG.AP_Round_Currency(
1445: ((p_inv_dist_rec.quantity_variance * l_prorated_amount) /
1446: p_inv_dist_rec.amount),
1447: p_inv_rec.invoice_currency_code);
1448: END IF;

Line 1453: l_base_qty_variance := AP_Utilities_PKG.AP_Round_Currency(

1449:
1450: IF p_inv_dist_rec.base_amount = 0 THEN
1451: l_base_qty_variance := 0;
1452: ELSE
1453: l_base_qty_variance := AP_Utilities_PKG.AP_Round_Currency(
1454: ((p_inv_dist_rec.base_quantity_variance
1455: * l_pad_rec.base_amount)
1456: / p_inv_dist_rec.base_amount),
1457: p_inv_rec.base_currency_code);

Line 1467: l_amt_variance := AP_Utilities_PKG.AP_Round_Currency(

1463:
1464: IF p_inv_dist_rec.amount = 0 THEN
1465: l_amt_variance := 0;
1466: ELSE
1467: l_amt_variance := AP_Utilities_PKG.AP_Round_Currency(
1468: ((p_inv_dist_rec.amount_variance * l_prorated_amount) /
1469: p_inv_dist_rec.amount),
1470: p_inv_rec.invoice_currency_code);
1471: END IF;

Line 1476: l_base_amt_variance := AP_Utilities_PKG.AP_Round_Currency(

1472:
1473: IF p_inv_dist_rec.base_amount = 0 THEN
1474: l_base_amt_variance := 0;
1475: ELSE
1476: l_base_amt_variance := AP_Utilities_PKG.AP_Round_Currency(
1477: ((p_inv_dist_rec.base_amount_variance
1478: * l_pad_rec.base_amount)
1479: / p_inv_dist_rec.base_amount),
1480: p_inv_rec.base_currency_code);

Line 1628: l_prorated_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY

1624: IF p_inv_rec.invoice_amount = 0 THEN
1625: l_prorated_amount := 0;
1626:
1627: ELSE
1628: l_prorated_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY
1629: (p_prepay_dist_rec.prepay_tax_diff_amount * p_inv_dist_rec.amount
1630: / p_inv_rec.invoice_amount,
1631: p_inv_rec.invoice_currency_code);
1632:

Line 1650: l_prorated_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY

1646:
1647: -- In case of cascade events we will recalculate the prorated amount and subtract
1648: -- this amount from the already calculated amount previously so that this would
1649: -- give us the amount that needs to be adjusted
1650: l_prorated_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY
1651: (((p_inv_dist_rec.amount * p_prepay_dist_rec.prepay_tax_diff_amount)
1652: / p_inv_rec.invoice_amount)
1653: - AP_Accounting_Pay_Pkg.get_casc_tax_diff_sum
1654: (p_inv_dist_rec.invoice_distribution_id,

Line 1721: l_prorated_clr_amt := AP_UTILITIES_PKG.AP_Round_Currency(

1717: l_curr_calling_sequence);
1718:
1719: IF (p_clr_hist_rec.pmt_currency_code <> p_clr_hist_rec.bank_currency_code) THEN
1720:
1721: l_prorated_clr_amt := AP_UTILITIES_PKG.AP_Round_Currency(
1722: l_prorated_pay_amt * p_clr_hist_rec.pmt_to_base_xrate,
1723: p_pay_hist_rec.bank_currency_code);
1724: ELSE
1725: l_prorated_clr_amt := l_prorated_pay_amt;

Line 1852: l_pay_erv_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

1848:
1849: /* For Cash Basis ERV is Difference between Payment Exchange Rate and
1850: either Receipt Exchange rate or PO distributions exchange rate */
1851:
1852: l_pay_erv_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
1853: (p_pay_hist_rec.pmt_to_base_xrate - l_po_pay_exchange_rate) *
1854: p_prorated_amount, p_pay_hist_rec.pmt_currency_code);
1855:
1856:

Line 1868: l_clr_erv_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

1864: calculated based on the difference between Prepay payment clearing exchange rate
1865: and either Receipt Exchange rate or PO distributions exchange rate */
1866:
1867: IF p_clr_hist_rec.pmt_currency_code IS NOT NULL THEN -- Bug 5701788.
1868: l_clr_erv_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
1869: (p_clr_hist_rec.pmt_to_base_xrate - l_po_pay_exchange_rate) *
1870: p_inv_dist_rec.amount, p_clr_hist_rec.pmt_currency_code);
1871: END IF;
1872:

Line 1885: l_inv_erv_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

1881: Exchange Rate and either Receipt Exchange rate or PO distributions
1882: exchange rate. This calculated ERV amount will be stored in the
1883: invoice_dist_base_amount column */
1884:
1885: l_inv_erv_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
1886: (p_inv_rec.exchange_rate - l_po_exchange_rate) *
1887: p_prorated_amount, p_inv_rec.invoice_currency_code);
1888:
1889: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN