DBA Data[Home] [Help]

APPS.AP_ISP_UTILITIES_PKG dependencies on AP_UTILITIES_PKG

Line 1310: ap_utilities_pkg.get_exchange_rate(

1306: DECODE(asp.default_exchange_rate_type,
1307: NULL, 'Corporate',
1308: 'User', 'Corporate' ,
1309: asp.default_exchange_rate_type),
1310: ap_utilities_pkg.get_exchange_rate(
1311: ai.invoice_currency_code,
1312: asp.base_currency_code,
1313: DECODE(asp.default_exchange_rate_type,
1314: NULL, 'Corporate',

Line 1357: SET base_amount = ap_utilities_pkg.ap_round_currency(

1353: /* Bug 9768308 begin */
1354: IF (l_default_exchange_rate_type = 'User') THEN
1355:
1356: UPDATE ap_invoices_all
1357: SET base_amount = ap_utilities_pkg.ap_round_currency(
1358: invoice_amount * l_exchange_rate,
1359: l_base_currency_code)
1360: WHERE invoice_id = p_invoice_id ;
1361:

Line 1656: AP_UTILITIES_PKG.Get_gl_date_and_period_1(

1652: FROM ap_invoices_all ai
1653: WHERE ai.invoice_id = p_invoice_id ;
1654:
1655: -- Bug 8405782
1656: AP_UTILITIES_PKG.Get_gl_date_and_period_1(
1657: P_Date => l_invoice_date,
1658: P_Period_Name => l_period_name,
1659: P_GL_Date => l_gl_date,
1660: P_Org_Id => l_org_id) ;

Line 1814: ap_utilities_pkg.get_exchange_rate(

1810: DECODE(asp.default_exchange_rate_type,
1811: NULL, 'Corporate',
1812: 'User', 'Corporate' ,
1813: asp.default_exchange_rate_type),
1814: ap_utilities_pkg.get_exchange_rate(
1815: ai.invoice_currency_code,
1816: asp.base_currency_code,
1817: DECODE(asp.default_exchange_rate_type,
1818: NULL, 'Corporate',

Line 1861: SET base_amount = ap_utilities_pkg.ap_round_currency(

1857: /* Bug 9768308 begin */
1858: IF (l_default_exchange_rate_type = 'User') THEN
1859:
1860: UPDATE ap_invoices_all
1861: SET base_amount = ap_utilities_pkg.ap_round_currency(
1862: invoice_amount * l_exchange_rate,
1863: l_base_currency_code)
1864: WHERE invoice_id = p_invoice_id ;
1865: