DBA Data[Home] [Help]

APPS.AP_RECT_MATCH_PKG dependencies on AP_UTILITIES_PKG

Line 624: l_max_amount_to_recoup := ap_utilities_pkg.ap_round_currency(

620: END IF;
621:
622: l_line_amt_net_retainage := x_amount + nvl(l_retained_amount,0);
623:
624: l_max_amount_to_recoup := ap_utilities_pkg.ap_round_currency(
625: (x_amount * g_recoupment_rate / 100) ,g_invoice_currency_code);
626:
627: IF (l_line_amt_net_retainage < l_max_amount_to_recoup) THEN
628: l_amount_to_recoup := l_line_amt_net_retainage;

Line 838: g_line_base_amount := ap_utilities_pkg.ap_round_currency(

834: AND asp.set_of_books_id = fsp.set_of_books_id
835: AND ai.invoice_currency_code = fc.currency_code (+);
836:
837: IF (g_invoice_currency_code <> g_base_currency_code) THEN
838: g_line_base_amount := ap_utilities_pkg.ap_round_currency(
839: x_match_amount * g_exchange_rate,
840: g_base_currency_code);
841: END IF;
842:

Line 897: g_asset_book_type_code := Ap_Utilities_Pkg.Ledger_Asset_Book

893: END IF;
894:
895:
896: /* Bug 5572876 */
897: g_asset_book_type_code := Ap_Utilities_Pkg.Ledger_Asset_Book
898: (g_set_of_books_id);
899:
900: /*
901: BEGIN

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

917: END IF;
918:
919: --Get_current_gl_date will return NULL if the date passed to it doesn't fall in a
920: --open period.
921: g_period_name := AP_UTILITIES_PKG.get_current_gl_date(g_accounting_date,
922: g_org_id); /* bug 5174518 */
923:
924: IF (g_period_name IS NULL) THEN
925:

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

923:
924: IF (g_period_name IS NULL) THEN
925:
926: --Get gl_period and Date from a future period for the accounting date
927: ap_utilities_pkg.get_only_open_gl_date(p_date => g_accounting_date,
928: p_period_name => g_period_name,
929: p_gl_date => g_accounting_date,
930: p_org_id => g_org_id); /*bug 5174518 */
931:

Line 1154: l_amount := ap_utilities_pkg.ap_round_currency(

1150: IF l_matching_case = 'DB' THEN
1151:
1152: IF( x_match_mode = 'STD-PS') THEN
1153:
1154: l_amount := ap_utilities_pkg.ap_round_currency(
1155: (X_match_amount * (l_delivered_txn_qty - l_billed_txn_qty)/
1156: l_total_quantity),g_invoice_currency_code);
1157:
1158: l_quantity_invoiced := ROUND(X_match_quantity *

Line 1165: l_amount := ap_utilities_pkg.ap_round_currency(

1161:
1162: --bugfix:5639042
1163: ELSE /*-VE invoices */
1164:
1165: l_amount := ap_utilities_pkg.ap_round_currency(
1166: (X_match_amount * l_billed_txn_qty)/l_total_quantity,
1167: g_invoice_currency_code);
1168:
1169: l_quantity_invoiced := ROUND((X_match_quantity * l_billed_txn_qty)

Line 1178: l_amount := ap_utilities_pkg.ap_round_currency(

1174:
1175: ELSIF l_matching_case = 'OB' THEN
1176:
1177: IF(x_match_mode = 'STD-PS') THEN
1178: l_amount := ap_utilities_pkg.ap_round_currency(
1179: (X_match_amount * (l_ordered_txn_qty - l_billed_txn_qty)/
1180: l_total_quantity),g_invoice_currency_code);
1181:
1182: l_quantity_invoiced := ROUND(x_match_quantity *

Line 1187: l_amount := ap_utilities_pkg.ap_round_currency(

1183: ((l_ordered_txn_qty - l_billed_txn_qty)/
1184: l_total_quantity),15);
1185:
1186: ELSE /*for -ve invoices */
1187: l_amount := ap_utilities_pkg.ap_round_currency(
1188: (X_match_amount * l_billed_txn_qty)/l_total_quantity,
1189: g_invoice_currency_code);
1190:
1191: l_quantity_invoiced := ROUND((X_match_quantity * l_billed_txn_qty)

Line 1197: l_amount := ap_utilities_pkg.ap_round_currency(

1193: END IF;
1194:
1195: ELSE
1196:
1197: l_amount := ap_utilities_pkg.ap_round_currency(
1198: x_match_amount * l_ordered_txn_qty/l_total_quantity,
1199: g_invoice_currency_code);
1200: l_quantity_invoiced := ROUND(x_match_quantity * l_ordered_txn_qty/l_total_quantity,15);
1201:

Line 1419: l_base_amount := ap_utilities_pkg.ap_round_currency(

1415: --Populate Base Amount
1416: --Need to populate the base amount for foreign currency invoices only
1417:
1418: IF (g_exchange_rate IS NOT NULL) THEN
1419: l_base_amount := ap_utilities_pkg.ap_round_currency(
1420: x_dist_tab(i).amount * g_exchange_rate,
1421: g_base_currency_code);
1422: x_dist_tab(i).base_amount := l_base_amount;
1423:

Line 1454: IF (AP_UTILITIES_PKG.overlay_segments(

1450: g_overlay_dist_code_concat IS NOT NULL) THEN
1451:
1452: l_dist_ccid := nvl(x_dist_tab(i).dist_ccid,x_dist_tab(i).po_ccid);
1453:
1454: IF (AP_UTILITIES_PKG.overlay_segments(
1455: g_balancing_segment,
1456: g_cost_center_segment,
1457: g_account_segment,
1458: g_overlay_dist_code_concat,

Line 1969: AP_UTILITIES_PKG.Ap_Round_Currency(

1965: NULL, --def_acctg_number_of_periods
1966: NULL, --def_acctg_period_type
1967: G_SET_OF_BOOKS_ID, --set_of_books_id
1968: X_AMOUNT, --amount
1969: AP_UTILITIES_PKG.Ap_Round_Currency(
1970: NVL(X_AMOUNT, 0) * G_EXCHANGE_RATE,
1971: G_BASE_CURRENCY_CODE), --base_amount
1972: NULL, --rounding_amount
1973: X_QUANTITY_INVOICED, --quantity_invoiced

Line 2360: AP_UTILITIES_PKG.AP_Round_Currency(

2356: NULL, --def_acctg_number_of_periods
2357: NULL, --def_acctg_period_type
2358: AIL.SET_OF_BOOKS_ID, --set_of_books_id
2359: X_AMOUNT, --amount
2360: AP_UTILITIES_PKG.AP_Round_Currency(
2361: NVL(X_AMOUNT, 0) * G_EXCHANGE_RATE,
2362: G_BASE_CURRENCY_CODE), --base_amount
2363: NULL, --rounding_amount
2364: NULL, --quantity_invoiced

Line 3434: l_max_amount_to_recoup := ap_utilities_pkg.ap_round_currency(

3430: END IF;
3431:
3432: l_line_amt_net_retainage := x_correction_amount + nvl(l_retained_amount,0);
3433:
3434: l_max_amount_to_recoup := ap_utilities_pkg.ap_round_currency(
3435: (x_correction_amount * g_recoupment_rate / 100) ,g_invoice_currency_code);
3436:
3437: IF (l_line_amt_net_retainage < l_max_amount_to_recoup) THEN
3438: l_amount_to_recoup := l_line_amt_net_retainage;

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

3789: --Populating the base_amount column, after proration related rounding
3790: --has been done if it is a foreign currency invoice.
3791:
3792: IF (g_exchange_rate IS NOT NULL) THEN
3793: x_corr_dist_tab(i).base_amount := ap_utilities_pkg.ap_round_currency(
3794: x_corr_dist_tab(i).amount * g_exchange_rate,
3795: g_base_currency_code);
3796:
3797: l_sum_dist_base_amount := l_sum_dist_base_amount + x_corr_dist_tab(i).base_amount ;

Line 4191: AP_UTILITIES_PKG.Ap_Round_Currency(

4187: NULL, --def_acctg_number_of_periods
4188: NULL, --def_acctg_period_type
4189: g_set_of_books_id, --set_of_books_id
4190: x_amount, --amount
4191: AP_UTILITIES_PKG.Ap_Round_Currency(
4192: NVL(X_AMOUNT, 0) * G_EXCHANGE_RATE,
4193: G_BASE_CURRENCY_CODE), --base_amount
4194: NULL, --rounding_amount
4195: x_quantity, --quantity_invoiced