DBA Data[Home] [Help]

APPS.AP_PO_AMT_MATCH_PKG dependencies on AP_UTILITIES_PKG

Line 570: l_max_amount_to_recoup := ap_utilities_pkg.ap_round_currency(

566: l_debug_info := 'Calculate the maximum amount that can be recouped from this invoice line';
567:
568: l_line_amt_net_retainage := x_amount + nvl(l_retained_amount,0);
569:
570: l_max_amount_to_recoup := ap_utilities_pkg.ap_round_currency(
571: (x_amount * g_recoupment_rate / 100) ,g_invoice_currency_code);
572:
573: IF (l_line_amt_net_retainage < l_max_amount_to_recoup) THEN
574: l_amount_to_recoup := l_line_amt_net_retainage;

Line 736: g_line_base_amount := ap_utilities_pkg.ap_round_currency(

732: AND ai.invoice_currency_code = fc.currency_code (+);
733:
734:
735: IF (x_match_amount IS NOT NULL AND g_invoice_currency_code <> g_base_currency_code) THEN
736: g_line_base_amount := ap_utilities_pkg.ap_round_currency(
737: x_match_amount * g_exchange_rate,
738: g_base_currency_code);
739: END IF;
740:

Line 785: g_asset_book_type_code := Ap_Utilities_Pkg.Ledger_Asset_Book

781: FROM ap_invoice_lines ail
782: WHERE ail.invoice_id = x_invoice_id;
783:
784: /* Bug 5572876 */
785: g_asset_book_type_code := Ap_Utilities_Pkg.Ledger_Asset_Book
786: (g_set_of_books_id);
787:
788: /*
789: BEGIN

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

813: l_debug_info := 'select period for accounting date';
814:
815: --get_current_gl_date will return NULL if the date passed to it doesn't fall in a
816: --open period.
817: g_period_name := AP_UTILITIES_PKG.get_current_gl_date(g_accounting_date,
818: g_org_id);
819:
820: IF (g_period_name IS NULL) THEN
821:

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

819:
820: IF (g_period_name IS NULL) THEN
821:
822: --Get gl_period and Date from a future period for the accounting date
823: ap_utilities_pkg.get_open_gl_date(p_date => g_accounting_date,
824: p_period_name => g_period_name,
825: p_gl_date => g_accounting_date,
826: p_org_id => g_org_id);
827:

Line 1209: l_base_amount := ap_utilities_pkg.ap_round_currency(

1205:
1206: --Populate Base Amount
1207: --Need to populate the base amount for foreign currency invoices only.
1208: IF (g_exchange_rate IS NOT NULL) THEN
1209: l_base_amount := ap_utilities_pkg.ap_round_currency(
1210: x_dist_tab(i).amount * g_exchange_rate,
1211: g_base_currency_code);
1212: x_dist_tab(i).base_amount := l_base_amount;
1213:

Line 1244: IF (AP_UTILITIES_PKG.overlay_segments(

1240: g_overlay_dist_code_concat IS NOT NULL) THEN
1241:
1242: l_dist_ccid := nvl(x_dist_tab(i).dist_ccid,x_dist_tab(i).po_ccid);
1243:
1244: IF (AP_UTILITIES_PKG.overlay_segments(
1245: g_balancing_segment,
1246: g_cost_center_segment,
1247: g_account_segment,
1248: g_overlay_dist_code_concat,

Line 1859: AP_UTILITIES_PKG.Ap_Round_Currency(

1855: NULL, --def_acctg_number_of_periods
1856: NULL, --def_acctg_period_type
1857: G_SET_OF_BOOKS_ID, --set_of_books_id
1858: X_AMOUNT, --amount
1859: AP_UTILITIES_PKG.Ap_Round_Currency(
1860: NVL(X_AMOUNT, 0) * G_EXCHANGE_RATE,
1861: G_BASE_CURRENCY_CODE), --base_amount
1862: NULL, --rounding_amount
1863: X_QUANTITY_INVOICED, --quantity_invoiced

Line 2256: AP_UTILITIES_PKG.Ap_Round_Currency(

2252: NULL, --def_acctg_number_of_periods
2253: NULL, --def_acctg_period_type
2254: AIL.SET_OF_BOOKS_ID, --set_of_books_id
2255: X_AMOUNT, --amount
2256: AP_UTILITIES_PKG.Ap_Round_Currency(
2257: NVL(X_AMOUNT, 0) * G_EXCHANGE_RATE,
2258: G_BASE_CURRENCY_CODE), --base_amount
2259: NULL, --rounding_amount
2260: NULL, --quantity_invoiced

Line 3071: l_max_amount_to_recoup := ap_utilities_pkg.ap_round_currency(

3067: l_debug_info := 'Calculate the maximum amount that can be recouped from this invoice line';
3068:
3069: l_line_amt_net_retainage := x_correction_amount + nvl(l_retained_amount,0);
3070:
3071: l_max_amount_to_recoup := ap_utilities_pkg.ap_round_currency(
3072: (x_correction_amount * g_recoupment_rate / 100) ,g_invoice_currency_code);
3073:
3074: IF (l_line_amt_net_retainage < l_max_amount_to_recoup) THEN
3075: l_amount_to_recoup := l_line_amt_net_retainage;

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

3261: --Populating the base_amount column, after proration related rounding
3262: --has been done if it is a foreign currency invoice.
3263:
3264: IF (g_exchange_rate IS NOT NULL) THEN
3265: x_corr_dist_tab(i).base_amount := ap_utilities_pkg.ap_round_currency(
3266: x_corr_dist_tab(i).amount * g_exchange_rate,
3267: g_base_currency_code);
3268:
3269: l_sum_dist_base_amount := l_sum_dist_base_amount + x_corr_dist_tab(i).base_amount ;

Line 3660: AP_UTILITIES_PKG.Ap_Round_Currency(

3656: NULL, --def_acctg_number_of_periods
3657: NULL, --def_acctg_period_type
3658: g_set_of_books_id, --set_of_books_id
3659: x_amount, --amount
3660: AP_UTILITIES_PKG.Ap_Round_Currency(
3661: NVL(X_AMOUNT, 0) * G_EXCHANGE_RATE,
3662: G_BASE_CURRENCY_CODE), --base_amount
3663: NULL, --rounding_amount
3664: Null, --quantity_invoiced