DBA Data[Home] [Help]

APPS.AP_PO_AMT_MATCH_PKG dependencies on AP_UTILITIES_PKG

Line 658: l_max_amount_to_recoup := ap_utilities_pkg.ap_round_currency(

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

Line 827: g_line_base_amount := ap_utilities_pkg.ap_round_currency(

823: AND ai.invoice_currency_code = fc.currency_code (+);
824:
825:
826: IF (x_match_amount IS NOT NULL AND g_invoice_currency_code <> g_base_currency_code) THEN
827: g_line_base_amount := ap_utilities_pkg.ap_round_currency(
828: x_match_amount * g_exchange_rate,
829: g_base_currency_code);
830: END IF;
831:

Line 878: g_asset_book_type_code := Ap_Utilities_Pkg.Ledger_Asset_Book

874: FROM ap_invoice_lines ail
875: WHERE ail.invoice_id = x_invoice_id;
876:
877: /* Bug 5572876 */
878: g_asset_book_type_code := Ap_Utilities_Pkg.Ledger_Asset_Book
879: (g_set_of_books_id);
880:
881: /*
882: BEGIN

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

906: l_debug_info := 'select period for accounting date';
907:
908: --get_current_gl_date will return NULL if the date passed to it doesn't fall in a
909: --open period.
910: g_period_name := AP_UTILITIES_PKG.get_current_gl_date(g_accounting_date,
911: g_org_id);
912:
913: IF (g_period_name IS NULL) THEN
914:

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

916:
917: -- Bug16216470 Used l_accounting_date instead of g_accounting_date. Using
918: --same variable for in/out parmeters causing to make in parameters
919: -- as Null
920: ap_utilities_pkg.get_open_gl_date(p_date => g_accounting_date,
921: p_period_name => g_period_name,
922: p_gl_date => l_accounting_date, --Bug16216470
923: p_org_id => g_org_id);
924:

Line 1310: l_base_amount := ap_utilities_pkg.ap_round_currency(

1306:
1307: --Populate Base Amount
1308: --Need to populate the base amount for foreign currency invoices only.
1309: IF (g_exchange_rate IS NOT NULL) THEN
1310: l_base_amount := ap_utilities_pkg.ap_round_currency(
1311: x_dist_tab(i).amount * g_exchange_rate,
1312: g_base_currency_code);
1313: x_dist_tab(i).base_amount := l_base_amount;
1314:

Line 1345: IF (AP_UTILITIES_PKG.overlay_segments(

1341: g_overlay_dist_code_concat IS NOT NULL) THEN
1342:
1343: l_dist_ccid := nvl(x_dist_tab(i).dist_ccid,x_dist_tab(i).po_ccid);
1344:
1345: IF (AP_UTILITIES_PKG.overlay_segments(
1346: g_balancing_segment,
1347: g_cost_center_segment,
1348: g_account_segment,
1349: g_overlay_dist_code_concat,

Line 1976: AP_UTILITIES_PKG.Ap_Round_Currency(

1972: NULL, --def_acctg_number_of_periods
1973: NULL, --def_acctg_period_type
1974: G_SET_OF_BOOKS_ID, --set_of_books_id
1975: X_AMOUNT, --amount
1976: AP_UTILITIES_PKG.Ap_Round_Currency(
1977: NVL(X_AMOUNT, 0) * G_EXCHANGE_RATE,
1978: G_BASE_CURRENCY_CODE), --base_amount
1979: NULL, --rounding_amount
1980: X_QUANTITY_INVOICED, --quantity_invoiced

Line 2377: AP_UTILITIES_PKG.Ap_Round_Currency(

2373: NULL, --def_acctg_number_of_periods
2374: NULL, --def_acctg_period_type
2375: AIL.SET_OF_BOOKS_ID, --set_of_books_id
2376: X_AMOUNT, --amount
2377: AP_UTILITIES_PKG.Ap_Round_Currency(
2378: NVL(X_AMOUNT, 0) * G_EXCHANGE_RATE,
2379: G_BASE_CURRENCY_CODE), --base_amount
2380: NULL, --rounding_amount
2381: NULL, --quantity_invoiced

Line 3224: l_max_amount_to_recoup := ap_utilities_pkg.ap_round_currency(

3220: l_debug_info := 'Calculate the maximum amount that can be recouped from this invoice line';
3221:
3222: l_line_amt_net_retainage := x_correction_amount + nvl(l_retained_amount,0);
3223:
3224: l_max_amount_to_recoup := ap_utilities_pkg.ap_round_currency(
3225: (x_correction_amount * g_recoupment_rate / 100) ,g_invoice_currency_code);
3226:
3227: IF (l_line_amt_net_retainage < l_max_amount_to_recoup) THEN
3228: l_amount_to_recoup := l_line_amt_net_retainage;

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

3416: --Populating the base_amount column, after proration related rounding
3417: --has been done if it is a foreign currency invoice.
3418:
3419: IF (g_exchange_rate IS NOT NULL) THEN
3420: x_corr_dist_tab(i).base_amount := ap_utilities_pkg.ap_round_currency(
3421: x_corr_dist_tab(i).amount * g_exchange_rate,
3422: g_base_currency_code);
3423:
3424: l_sum_dist_base_amount := l_sum_dist_base_amount + x_corr_dist_tab(i).base_amount ;

Line 3816: AP_UTILITIES_PKG.Ap_Round_Currency(

3812: NULL, --def_acctg_number_of_periods
3813: NULL, --def_acctg_period_type
3814: g_set_of_books_id, --set_of_books_id
3815: x_amount, --amount
3816: AP_UTILITIES_PKG.Ap_Round_Currency(
3817: NVL(X_AMOUNT, 0) * G_EXCHANGE_RATE,
3818: G_BASE_CURRENCY_CODE), --base_amount
3819: NULL, --rounding_amount
3820: Null, --quantity_invoiced