DBA Data[Home] [Help]

APPS.AP_RECT_MATCH_PKG dependencies on AP_UTILITIES_PKG

Line 713: l_max_amount_to_recoup := ap_utilities_pkg.ap_round_currency(

709: END IF;
710:
711: l_line_amt_net_retainage := x_amount + nvl(l_retained_amount,0);
712:
713: l_max_amount_to_recoup := ap_utilities_pkg.ap_round_currency(
714: (x_amount * g_recoupment_rate / 100) ,g_invoice_currency_code);
715:
716: IF (l_line_amt_net_retainage < l_max_amount_to_recoup) THEN
717: l_amount_to_recoup := l_line_amt_net_retainage;

Line 929: g_line_base_amount := ap_utilities_pkg.ap_round_currency(

925: AND asp.set_of_books_id = fsp.set_of_books_id
926: AND ai.invoice_currency_code = fc.currency_code (+);
927:
928: IF (g_invoice_currency_code <> g_base_currency_code) THEN
929: g_line_base_amount := ap_utilities_pkg.ap_round_currency(
930: x_match_amount * g_exchange_rate,
931: g_base_currency_code);
932: END IF;
933:

Line 990: g_asset_book_type_code := Ap_Utilities_Pkg.Ledger_Asset_Book

986: END IF;
987:
988:
989: /* Bug 5572876 */
990: g_asset_book_type_code := Ap_Utilities_Pkg.Ledger_Asset_Book
991: (g_set_of_books_id);
992:
993: /*
994: BEGIN

Line 1014: g_period_name := AP_UTILITIES_PKG.get_current_gl_date(g_accounting_date,

1010:
1011: --Get_current_gl_date will return NULL if the date passed to it doesn't fall in a
1012: --open period.
1013:
1014: g_period_name := AP_UTILITIES_PKG.get_current_gl_date(g_accounting_date,
1015: g_org_id); /* bug 5174518 */
1016:
1017:
1018: IF (g_period_name IS NULL) THEN

Line 1024: ap_utilities_pkg.get_only_open_gl_date(p_date => g_accounting_date,

1020: --Get gl_period and Date from a future period for the accounting date
1021: -- 8714506 Used l_accounting_date instead of g_accounting_date. Using
1022: -- same variable for in/out parmeters causing to make in parameters
1023: -- as Null
1024: ap_utilities_pkg.get_only_open_gl_date(p_date => g_accounting_date,
1025: p_period_name => g_period_name,
1026: p_gl_date => l_accounting_date,
1027: p_org_id => g_org_id); /*bug 5174518 */
1028:

Line 1270: l_amount := ap_utilities_pkg.ap_round_currency(

1266: IF l_matching_case = 'DB' THEN
1267:
1268: IF( x_match_mode = 'STD-PS') THEN
1269:
1270: l_amount := ap_utilities_pkg.ap_round_currency(
1271: (X_match_amount * (l_delivered_txn_qty - l_billed_txn_qty)/
1272: l_total_quantity),g_invoice_currency_code);
1273:
1274: l_quantity_invoiced := ROUND(X_match_quantity *

Line 1281: l_amount := ap_utilities_pkg.ap_round_currency(

1277:
1278: --bugfix:5639042
1279: ELSE /*-VE invoices */
1280:
1281: l_amount := ap_utilities_pkg.ap_round_currency(
1282: (X_match_amount * l_billed_txn_qty)/l_total_quantity,
1283: g_invoice_currency_code);
1284:
1285: l_quantity_invoiced := ROUND((X_match_quantity * l_billed_txn_qty)

Line 1294: l_amount := ap_utilities_pkg.ap_round_currency(

1290:
1291: ELSIF l_matching_case = 'OB' THEN
1292:
1293: IF(x_match_mode = 'STD-PS') THEN
1294: l_amount := ap_utilities_pkg.ap_round_currency(
1295: (X_match_amount * (l_ordered_txn_qty - l_billed_txn_qty)/
1296: l_total_quantity),g_invoice_currency_code);
1297:
1298: l_quantity_invoiced := ROUND(x_match_quantity *

Line 1303: l_amount := ap_utilities_pkg.ap_round_currency(

1299: ((l_ordered_txn_qty - l_billed_txn_qty)/
1300: l_total_quantity),15);
1301:
1302: ELSE /*for -ve invoices */
1303: l_amount := ap_utilities_pkg.ap_round_currency(
1304: (X_match_amount * l_billed_txn_qty)/l_total_quantity,
1305: g_invoice_currency_code);
1306:
1307: l_quantity_invoiced := ROUND((X_match_quantity * l_billed_txn_qty)

Line 1314: l_amount := ap_utilities_pkg.ap_round_currency(

1310:
1311: ELSE
1312: --Introduced IF clause and ELSE part for bug#13555741
1313: IF(x_match_mode = 'STD-PS') THEN
1314: l_amount := ap_utilities_pkg.ap_round_currency(
1315: x_match_amount * l_ordered_txn_qty/l_total_quantity,
1316: g_invoice_currency_code);
1317: l_quantity_invoiced := ROUND(x_match_quantity * l_ordered_txn_qty/l_total_quantity,15);
1318: ELSE

Line 1319: l_amount := ap_utilities_pkg.ap_round_currency(

1315: x_match_amount * l_ordered_txn_qty/l_total_quantity,
1316: g_invoice_currency_code);
1317: l_quantity_invoiced := ROUND(x_match_quantity * l_ordered_txn_qty/l_total_quantity,15);
1318: ELSE
1319: l_amount := ap_utilities_pkg.ap_round_currency(
1320: (X_match_amount * l_billed_txn_qty)/l_total_quantity,
1321: g_invoice_currency_code);
1322:
1323: l_quantity_invoiced := ROUND((X_match_quantity * l_billed_txn_qty)

Line 1561: l_base_amount := ap_utilities_pkg.ap_round_currency(

1557: --Populate Base Amount
1558: --Need to populate the base amount for foreign currency invoices only
1559:
1560: IF (g_exchange_rate IS NOT NULL) THEN
1561: l_base_amount := ap_utilities_pkg.ap_round_currency(
1562: x_dist_tab(i).amount * g_exchange_rate,
1563: g_base_currency_code);
1564: x_dist_tab(i).base_amount := l_base_amount;
1565:

Line 1596: IF (AP_UTILITIES_PKG.overlay_segments(

1592: g_overlay_dist_code_concat IS NOT NULL) THEN
1593:
1594: l_dist_ccid := nvl(x_dist_tab(i).dist_ccid,x_dist_tab(i).po_ccid);
1595:
1596: IF (AP_UTILITIES_PKG.overlay_segments(
1597: g_balancing_segment,
1598: g_cost_center_segment,
1599: g_account_segment,
1600: g_overlay_dist_code_concat,

Line 2134: AP_UTILITIES_PKG.Ap_Round_Currency(

2130: NULL, --def_acctg_number_of_periods
2131: NULL, --def_acctg_period_type
2132: G_SET_OF_BOOKS_ID, --set_of_books_id
2133: X_AMOUNT, --amount
2134: AP_UTILITIES_PKG.Ap_Round_Currency(
2135: NVL(X_AMOUNT, 0) * G_EXCHANGE_RATE,
2136: G_BASE_CURRENCY_CODE), --base_amount
2137: NULL, --rounding_amount
2138: X_QUANTITY_INVOICED, --quantity_invoiced

Line 2536: AP_UTILITIES_PKG.AP_Round_Currency(

2532: NULL, --def_acctg_number_of_periods
2533: NULL, --def_acctg_period_type
2534: AIL.SET_OF_BOOKS_ID, --set_of_books_id
2535: X_AMOUNT, --amount
2536: AP_UTILITIES_PKG.AP_Round_Currency(
2537: NVL(X_AMOUNT, 0) * G_EXCHANGE_RATE,
2538: G_BASE_CURRENCY_CODE), --base_amount
2539: NULL, --rounding_amount
2540: NULL, --quantity_invoiced

Line 3643: l_max_amount_to_recoup := ap_utilities_pkg.ap_round_currency(

3639: END IF;
3640:
3641: l_line_amt_net_retainage := x_correction_amount + nvl(l_retained_amount,0);
3642:
3643: l_max_amount_to_recoup := ap_utilities_pkg.ap_round_currency(
3644: (x_correction_amount * g_recoupment_rate / 100) ,g_invoice_currency_code);
3645:
3646: IF (l_line_amt_net_retainage < l_max_amount_to_recoup) THEN
3647: l_amount_to_recoup := l_line_amt_net_retainage;

Line 4012: x_corr_dist_tab(i).base_amount := ap_utilities_pkg.ap_round_currency(

4008: --Populating the base_amount column, after proration related rounding
4009: --has been done if it is a foreign currency invoice.
4010:
4011: IF (g_exchange_rate IS NOT NULL) THEN
4012: x_corr_dist_tab(i).base_amount := ap_utilities_pkg.ap_round_currency(
4013: x_corr_dist_tab(i).amount * g_exchange_rate,
4014: g_base_currency_code);
4015:
4016: l_sum_dist_base_amount := l_sum_dist_base_amount + x_corr_dist_tab(i).base_amount ;

Line 4412: AP_UTILITIES_PKG.Ap_Round_Currency(

4408: NULL, --def_acctg_number_of_periods
4409: NULL, --def_acctg_period_type
4410: g_set_of_books_id, --set_of_books_id
4411: x_amount, --amount
4412: AP_UTILITIES_PKG.Ap_Round_Currency(
4413: NVL(X_AMOUNT, 0) * G_EXCHANGE_RATE,
4414: G_BASE_CURRENCY_CODE), --base_amount
4415: NULL, --rounding_amount
4416: x_quantity, --quantity_invoiced