DBA Data[Home] [Help]

APPS.AP_RCT_AMT_MATCH_PKG dependencies on AP_UTILITIES_PKG

Line 663: l_max_amount_to_recoup := ap_utilities_pkg.ap_round_currency(

659: l_debug_info := 'Calculate the maximum amount that can be recouped from this invoice line';
660:
661: l_line_amt_net_retainage := x_amount + nvl(l_retained_amount,0);
662:
663: l_max_amount_to_recoup := ap_utilities_pkg.ap_round_currency(
664: (x_amount * g_recoupment_rate / 100) ,g_invoice_currency_code);
665:
666: IF (l_line_amt_net_retainage < l_max_amount_to_recoup) THEN
667: l_amount_to_recoup := l_line_amt_net_retainage;

Line 862: g_line_base_amount := ap_utilities_pkg.ap_round_currency(

858: AND asp.set_of_books_id = fsp.set_of_books_id
859: AND ai.invoice_currency_code = fc.currency_code (+);
860:
861: IF (g_invoice_currency_code <> g_base_currency_code) THEN
862: g_line_base_amount := ap_utilities_pkg.ap_round_currency(
863: x_match_amount * g_exchange_rate,
864: g_base_currency_code);
865: END IF;
866:

Line 921: g_asset_book_type_code := Ap_Utilities_Pkg.Ledger_Asset_Book

917:
918: END IF;
919:
920: /* Bug 5572876 */
921: g_asset_book_type_code := Ap_Utilities_Pkg.Ledger_Asset_Book
922: (g_set_of_books_id);
923:
924: /*
925: BEGIN

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

938: l_debug_info := 'select period for accounting date';
939:
940: --get_current_gl_date will return NULL if the date passed to it doesn't fall in a
941: --open period.
942: g_period_name := AP_UTILITIES_PKG.get_current_gl_date(g_accounting_date,
943: g_org_id);
944:
945: IF (g_period_name IS NULL) THEN
946:

Line 952: ap_utilities_pkg.get_open_gl_date(p_date => g_accounting_date,

948:
949: -- Bug16216470 Used l_accounting_date instead of g_accounting_date. Using
950: --same variable for in/out parmeters causing to make in parameters
951: -- as Null
952: ap_utilities_pkg.get_open_gl_date(p_date => g_accounting_date,
953: p_period_name => g_period_name,
954: p_gl_date => l_accounting_date, --Bug16216470
955: p_org_id => g_org_id);
956:

Line 1161: --using ap_utilities_pkg.ap_round_currency

1157:
1158: l_amount_billed := nvl(l_amount_billed,0);
1159:
1160: --Introduced rounding for bug#13973676 for all amounts
1161: --using ap_utilities_pkg.ap_round_currency
1162: IF l_matching_case = 'DB' THEN
1163:
1164: IF (x_match_mode = 'STD-PS') THEN
1165: l_amount_invoiced := ap_utilities_pkg.ap_round_currency((X_match_amount * (l_amount_delivered - l_amount_billed)/

Line 1165: l_amount_invoiced := ap_utilities_pkg.ap_round_currency((X_match_amount * (l_amount_delivered - l_amount_billed)/

1161: --using ap_utilities_pkg.ap_round_currency
1162: IF l_matching_case = 'DB' THEN
1163:
1164: IF (x_match_mode = 'STD-PS') THEN
1165: l_amount_invoiced := ap_utilities_pkg.ap_round_currency((X_match_amount * (l_amount_delivered - l_amount_billed)/
1166: l_total_amount),g_invoice_currency_code);
1167:
1168: --bugfix:5639042
1169: ELSE /*-ve invoices */

Line 1170: l_amount_invoiced := ap_utilities_pkg.ap_round_currency((X_match_amount * l_amount_billed/

1166: l_total_amount),g_invoice_currency_code);
1167:
1168: --bugfix:5639042
1169: ELSE /*-ve invoices */
1170: l_amount_invoiced := ap_utilities_pkg.ap_round_currency((X_match_amount * l_amount_billed/
1171: l_total_amount),g_invoice_currency_code);
1172: END IF;
1173:
1174: ELSIF l_matching_case = 'OB' THEN

Line 1176: l_amount_invoiced := ap_utilities_pkg.ap_round_currency((X_match_amount * (l_amount_ordered - l_amount_billed)/

1172: END IF;
1173:
1174: ELSIF l_matching_case = 'OB' THEN
1175: IF(x_match_mode = 'STD-PS') THEN
1176: l_amount_invoiced := ap_utilities_pkg.ap_round_currency((X_match_amount * (l_amount_ordered - l_amount_billed)/
1177: l_total_amount),g_invoice_currency_code);
1178: ELSE /*for -ve invoices */
1179: l_amount_invoiced := ap_utilities_pkg.ap_round_currency((X_match_amount * l_amount_billed/
1180: l_total_amount),g_invoice_currency_code);

Line 1179: l_amount_invoiced := ap_utilities_pkg.ap_round_currency((X_match_amount * l_amount_billed/

1175: IF(x_match_mode = 'STD-PS') THEN
1176: l_amount_invoiced := ap_utilities_pkg.ap_round_currency((X_match_amount * (l_amount_ordered - l_amount_billed)/
1177: l_total_amount),g_invoice_currency_code);
1178: ELSE /*for -ve invoices */
1179: l_amount_invoiced := ap_utilities_pkg.ap_round_currency((X_match_amount * l_amount_billed/
1180: l_total_amount),g_invoice_currency_code);
1181: END IF;
1182:
1183: ELSE

Line 1186: l_amount_invoiced := ap_utilities_pkg.ap_round_currency((X_match_amount * l_amount_ordered/

1182:
1183: ELSE
1184: --Introduced IF clause and ELSE part for bug#13555741
1185: IF(x_match_mode = 'STD-PS') THEN
1186: l_amount_invoiced := ap_utilities_pkg.ap_round_currency((X_match_amount * l_amount_ordered/
1187: l_total_amount),g_invoice_currency_code);
1188: ELSE /*for -ve invoices */
1189: l_amount_invoiced := ap_utilities_pkg.ap_round_currency((X_match_amount * l_amount_billed/
1190: l_total_amount),g_invoice_currency_code);

Line 1189: l_amount_invoiced := ap_utilities_pkg.ap_round_currency((X_match_amount * l_amount_billed/

1185: IF(x_match_mode = 'STD-PS') THEN
1186: l_amount_invoiced := ap_utilities_pkg.ap_round_currency((X_match_amount * l_amount_ordered/
1187: l_total_amount),g_invoice_currency_code);
1188: ELSE /*for -ve invoices */
1189: l_amount_invoiced := ap_utilities_pkg.ap_round_currency((X_match_amount * l_amount_billed/
1190: l_total_amount),g_invoice_currency_code);
1191: END IF;
1192: END IF;
1193:

Line 1410: l_base_amount := ap_utilities_pkg.ap_round_currency(

1406:
1407: --Populate Base Amount
1408: --Need to populate the base amount for foreign currency invoices only.
1409: IF (g_exchange_rate IS NOT NULL) THEN
1410: l_base_amount := ap_utilities_pkg.ap_round_currency(
1411: x_dist_tab(i).amount * g_exchange_rate,
1412: g_base_currency_code);
1413: x_dist_tab(i).base_amount := l_base_amount;
1414:

Line 1448: IF (AP_UTILITIES_PKG.overlay_segments(

1444: g_overlay_dist_code_concat IS NOT NULL) THEN
1445:
1446: l_dist_ccid := nvl(x_dist_tab(i).dist_ccid,x_dist_tab(i).po_ccid);
1447:
1448: IF (AP_UTILITIES_PKG.overlay_segments(
1449: g_balancing_segment,
1450: g_cost_center_segment,
1451: g_account_segment,
1452: g_overlay_dist_code_concat,

Line 2113: AP_UTILITIES_PKG.Ap_Round_Currency(

2109: NULL, --def_acctg_number_of_periods
2110: NULL, --def_acctg_period_type
2111: G_SET_OF_BOOKS_ID, --set_of_books_id
2112: X_AMOUNT, --amount
2113: AP_UTILITIES_PKG.Ap_Round_Currency(
2114: NVL(X_AMOUNT, 0) * G_EXCHANGE_RATE,
2115: G_BASE_CURRENCY_CODE), --base_amount
2116: NULL, --rounding_amount
2117: X_QUANTITY_INVOICED, --quantity_invoiced

Line 2466: AP_UTILITIES_PKG.Ap_Round_Currency(

2462: NULL, --def_acctg_number_of_periods
2463: NULL, --def_acctg_period_type
2464: AIL.SET_OF_BOOKS_ID, --set_of_books_id
2465: X_AMOUNT, --amount
2466: AP_UTILITIES_PKG.Ap_Round_Currency(
2467: NVL(X_AMOUNT, 0) * G_EXCHANGE_RATE,
2468: G_BASE_CURRENCY_CODE), --base_amount
2469: NULL, --rounding_amount
2470: NULL, --quantity_invoiced

Line 3293: l_max_amount_to_recoup := ap_utilities_pkg.ap_round_currency(

3289: l_debug_info := 'Calculate the maximum amount that can be recouped from this invoice line';
3290:
3291: l_line_amt_net_retainage := x_correction_amount + nvl(l_retained_amount,0);
3292:
3293: l_max_amount_to_recoup := ap_utilities_pkg.ap_round_currency(
3294: (x_correction_amount * g_recoupment_rate / 100) ,g_invoice_currency_code);
3295:
3296: IF (l_line_amt_net_retainage < l_max_amount_to_recoup) THEN
3297: l_amount_to_recoup := l_line_amt_net_retainage;

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

3492: --Populating the base_amount column, after proration related rounding
3493: --has been done if it is a foreign currency invoice.
3494:
3495: IF (g_exchange_rate IS NOT NULL) THEN
3496: x_corr_dist_tab(i).base_amount := ap_utilities_pkg.ap_round_currency(
3497: x_corr_dist_tab(i).amount * g_exchange_rate,
3498: g_base_currency_code);
3499:
3500: l_sum_dist_base_amount := l_sum_dist_base_amount + x_corr_dist_tab(i).base_amount ;

Line 3849: AP_UTILITIES_PKG.Ap_Round_Currency(

3845: NULL, --def_acctg_number_of_periods
3846: NULL, --def_acctg_period_type
3847: g_set_of_books_id, --set_of_books_id
3848: x_amount, --amount
3849: AP_UTILITIES_PKG.Ap_Round_Currency(
3850: NVL(X_AMOUNT, 0) * G_EXCHANGE_RATE,
3851: G_BASE_CURRENCY_CODE), --base_amount
3852: NULL, --rounding_amount
3853: Null, --quantity_invoiced