DBA Data[Home] [Help]

APPS.AP_MATCHING_PKG dependencies on AP_UTILITIES_PKG

Line 620: l_max_amount_to_recoup := ap_utilities_pkg.ap_round_currency(

616: END IF;
617:
618: l_line_amt_net_retainage := x_amount + nvl(l_retained_amount,0);
619:
620: l_max_amount_to_recoup := ap_utilities_pkg.ap_round_currency(
621: (x_amount * g_recoupment_rate / 100) ,g_invoice_currency_code);
622:
623: IF (l_line_amt_net_retainage < l_max_amount_to_recoup) THEN
624: l_amount_to_recoup := l_line_amt_net_retainage;

Line 838: g_line_base_amount := ap_utilities_pkg.ap_round_currency(

834: AND ai.invoice_currency_code = fc.currency_code (+);
835:
836:
837: IF (x_match_amount IS NOT NULL AND 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 888: g_asset_book_type_code := Ap_Utilities_Pkg.Ledger_Asset_Book

884: FROM ap_invoice_lines ail
885: WHERE ail.invoice_id = x_invoice_id;
886:
887: /* Bug 5572876 */
888: g_asset_book_type_code := Ap_Utilities_Pkg.Ledger_Asset_Book
889: (g_set_of_books_id);
890:
891: /*
892: BEGIN

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

919: --get_current_gl_date will return NULL if the date passed to it doesn't fall in a
920: --open period.
921: -- Bug 4460697. Passed the g_org_id as some cases
922: -- mo_global.get_current_org_id does not work
923: g_period_name := AP_UTILITIES_PKG.get_current_gl_date(g_accounting_date,
924: g_org_id);
925:
926: IF (g_period_name IS NULL) THEN
927:

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

931:
932: -- 7463095 Used l_accounting_date instead of g_accounting_date. Using
933: --same variable for in/out parmeters causing to make in parameters
934: -- as Null
935: ap_utilities_pkg.get_open_gl_date(p_date => g_accounting_date,
936: p_period_name => g_period_name,
937: p_gl_date => l_accounting_date,
938: p_org_id => g_org_id);
939:

Line 1399: l_base_amount := ap_utilities_pkg.ap_round_currency(

1395:
1396: --Populate Base Amount
1397: --Need to populate the base amount for foreign currency invoices only.
1398: IF (g_exchange_rate IS NOT NULL) THEN
1399: l_base_amount := ap_utilities_pkg.ap_round_currency(
1400: x_dist_tab(i).amount * g_exchange_rate,
1401: g_base_currency_code);
1402: x_dist_tab(i).base_amount := l_base_amount;
1403:

Line 1435: IF (AP_UTILITIES_PKG.overlay_segments(

1431: g_overlay_dist_code_concat IS NOT NULL) THEN
1432:
1433: l_dist_ccid := nvl(x_dist_tab(i).dist_ccid,x_dist_tab(i).po_ccid);
1434:
1435: IF (AP_UTILITIES_PKG.overlay_segments(
1436: g_balancing_segment,
1437: g_cost_center_segment,
1438: g_account_segment,
1439: g_overlay_dist_code_concat,

Line 1923: AP_UTILITIES_PKG.Ap_Round_Currency(

1919: NULL, --def_acctg_number_of_periods
1920: NULL, --def_acctg_period_type
1921: G_SET_OF_BOOKS_ID, --set_of_books_id
1922: X_AMOUNT, --amount
1923: AP_UTILITIES_PKG.Ap_Round_Currency(
1924: NVL(X_AMOUNT, 0) * G_EXCHANGE_RATE,
1925: G_BASE_CURRENCY_CODE), --base_amount
1926: NULL, --rounding_amount
1927: X_QUANTITY_INVOICED, --quantity_invoiced

Line 2327: AP_UTILITIES_PKG.Ap_Round_Currency(

2323: NULL, --def_acctg_number_of_periods
2324: NULL, --def_acctg_period_type
2325: AIL.SET_OF_BOOKS_ID, --set_of_books_id
2326: X_AMOUNT, --amount
2327: AP_UTILITIES_PKG.Ap_Round_Currency(
2328: NVL(X_AMOUNT, 0) * G_EXCHANGE_RATE,
2329: G_BASE_CURRENCY_CODE), --base_amount
2330: NULL, --rounding_amount
2331: NULL, --quantity_invoiced

Line 3412: l_max_amount_to_recoup := ap_utilities_pkg.ap_round_currency(

3408: END IF;
3409:
3410: l_line_amt_net_retainage := x_correction_amount + nvl(l_retained_amount,0);
3411:
3412: l_max_amount_to_recoup := ap_utilities_pkg.ap_round_currency(
3413: (x_correction_amount * g_recoupment_rate / 100) ,g_invoice_currency_code);
3414:
3415: IF (l_line_amt_net_retainage < l_max_amount_to_recoup) THEN
3416: l_amount_to_recoup := l_line_amt_net_retainage;

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

3762: --Populating the base_amount column, after proration related rounding
3763: --has been done if it is a foreign currency invoice.
3764:
3765: IF (g_exchange_rate IS NOT NULL) THEN
3766: x_corr_dist_tab(i).base_amount := ap_utilities_pkg.ap_round_currency(
3767: x_corr_dist_tab(i).amount * g_exchange_rate,
3768: g_base_currency_code);
3769:
3770: l_sum_dist_base_amount := l_sum_dist_base_amount + x_corr_dist_tab(i).base_amount ;

Line 4244: AP_UTILITIES_PKG.Ap_Round_Currency(

4240: NULL, --def_acctg_number_of_periods
4241: NULL, --def_acctg_period_type
4242: g_set_of_books_id, --set_of_books_id
4243: x_amount, --amount
4244: AP_UTILITIES_PKG.Ap_Round_Currency(
4245: NVL(X_AMOUNT, 0) * G_EXCHANGE_RATE,
4246: G_BASE_CURRENCY_CODE), --base_amount
4247: NULL, --rounding_amount
4248: x_quantity, --quantity_invoiced

Line 4952: ap_utilities_pkg.ap_round_currency(

4948: nvl(pll.amount_billed,0)
4949: )
4950: - nvl(pll.amount_cancelled,0)
4951: ),
4952: ap_utilities_pkg.ap_round_currency(
4953: (pll.quantity - decode(pll.shipment_type,'PREPAYMENT',
4954: nvl(pll.quantity_financed,0),
4955: nvl(pll.quantity_billed,0)
4956: )

Line 5599: l_invoice_base_amount := ap_utilities_pkg.ap_round_currency(

5595:
5596: --Calculate base_amounts and rounding for foriegn currency invoices
5597: IF (g_exchange_rate IS NOT NULL) THEN
5598:
5599: l_invoice_base_amount := ap_utilities_pkg.ap_round_currency(
5600: x_match_amount * g_exchange_rate,
5601: g_base_currency_code);
5602:
5603: --Populate base_amount column for foriegn currency invoice.

Line 5609: l_base_amount := ap_utilities_pkg.ap_round_currency(

5605: --for proration, hence doing in the loop below.
5606:
5607: FOR i IN NVL(X_Shipment_Table.first,0) .. NVL(X_Shipment_Table.last,0) LOOP
5608:
5609: l_base_amount := ap_utilities_pkg.ap_round_currency(
5610: x_shipment_table(i).amount * g_exchange_rate,
5611: g_base_currency_code);
5612:
5613: x_shipment_table(i).base_amount := l_base_amount;