eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FP_MULTI_CURRENCY_PKG dependencies on GL_CURRENCY_API

Line 439: l_converted_amount := gl_currency_api.convert_amount_sql

435: pa_debug.g_err_stage := 'pfc cost rate type' || p_projfunc_cost_rate_type_tab(i);
436: IF P_PA_DEBUG_MODE = 'Y' THEN
437: pa_debug.write('conv_mc_bulk: ' || g_module_name,pa_debug.g_err_stage,3);
438: END IF;
439: l_converted_amount := gl_currency_api.convert_amount_sql
440: ( X_FROM_CURRENCY => p_txn_currency_code_tab(i)
441: ,X_TO_CURRENCY => p_projfunc_currency_code_tab(i)
442: ,X_CONVERSION_DATE => p_projfunc_cost_rate_date_tab(i)
443: ,X_CONVERSION_TYPE => p_projfunc_cost_rate_type_tab(i)

Line 448: l_converted_amount := GL_CURRENCY_API.convert_closest_amount_sql

444: ,X_AMOUNT => p_txn_raw_cost_tab(i));
445: IF l_converted_amount = -1 THEN
446: /* Added the If block for Bug#5395732 */
447: IF (p_calling_module IN ('BUDGET_GENERATION','FORECAST_GENERATION','UPDATE_PLAN_TRANSACTION','AMG_API')) THEN --Bug 9586291 --Bug 16448547
448: l_converted_amount := GL_CURRENCY_API.convert_closest_amount_sql
449: ( x_from_currency => p_txn_currency_code_tab(i)
450: ,x_to_currency => p_projfunc_currency_code_tab(i)
451: ,x_conversion_date => p_projfunc_cost_rate_date_tab(i)
452: ,x_conversion_type => p_projfunc_cost_rate_type_tab(i)

Line 525: l_numerator := GL_CURRENCY_API.get_closest_rate_numerator_sql

521: END IF;
522: IF l_converted_amount <> -1 AND l_converted_amount <> -2 THEN -- Added for Bug#5395732
523: --hr_utility.trace(to_char(l_stage));
524: IF l_call_closest_flag = 'T' THEN -- Added for Bug#5395732
525: l_numerator := GL_CURRENCY_API.get_closest_rate_numerator_sql
526: ( p_txn_currency_code_tab(i)
527: ,p_projfunc_currency_code_tab(i)
528: ,p_projfunc_cost_rate_date_tab(i)
529: ,p_projfunc_cost_rate_type_tab(i)

Line 532: l_numerator := gl_currency_api.get_rate_numerator_sql

528: ,p_projfunc_cost_rate_date_tab(i)
529: ,p_projfunc_cost_rate_type_tab(i)
530: ,-1);
531: ELSE
532: l_numerator := gl_currency_api.get_rate_numerator_sql
533: ( X_FROM_CURRENCY => p_txn_currency_code_tab(i)
534: ,X_TO_CURRENCY => p_projfunc_currency_code_tab(i)
535: ,X_CONVERSION_DATE => p_projfunc_cost_rate_date_tab(i)
536: ,X_CONVERSION_TYPE => p_projfunc_cost_rate_type_tab(i));

Line 542: l_denominator := GL_CURRENCY_API.get_closest_rate_denom_sql

538: l_stage := 1800;
539: END IF;
540: --hr_utility.trace(to_char(l_stage));
541: IF l_call_closest_flag = 'T' THEN -- Added for Bug#5395732
542: l_denominator := GL_CURRENCY_API.get_closest_rate_denom_sql
543: ( p_txn_currency_code_tab(i)
544: ,p_projfunc_currency_code_tab(i)
545: ,p_projfunc_cost_rate_date_tab(i)
546: ,p_projfunc_cost_rate_type_tab(i)

Line 549: l_denominator := gl_currency_api.get_rate_denominator_sql

545: ,p_projfunc_cost_rate_date_tab(i)
546: ,p_projfunc_cost_rate_type_tab(i)
547: ,-1);
548: ELSE
549: l_denominator := gl_currency_api.get_rate_denominator_sql
550: ( X_FROM_CURRENCY => p_txn_currency_code_tab(i)
551: ,X_TO_CURRENCY => p_projfunc_currency_code_tab(i)
552: ,X_CONVERSION_DATE => p_projfunc_cost_rate_date_tab(i)
553: ,X_CONVERSION_TYPE => p_projfunc_cost_rate_type_tab(i));

Line 611: l_converted_amount := gl_currency_api.convert_amount_sql

607: IF P_PA_DEBUG_MODE = 'Y' THEN
608: pa_debug.write('conv_mc_bulk: ' || g_module_name,pa_debug.g_err_stage,3);
609: END IF;
610:
611: l_converted_amount := gl_currency_api.convert_amount_sql
612: ( X_FROM_CURRENCY => p_txn_currency_code_tab(i)
613: ,X_TO_CURRENCY => p_projfunc_currency_code_tab(i)
614: ,X_CONVERSION_DATE => p_projfunc_cost_rate_date_tab(i)
615: ,X_CONVERSION_TYPE => p_projfunc_cost_rate_type_tab(i)

Line 620: l_converted_amount := GL_CURRENCY_API.convert_closest_amount_sql

616: ,X_AMOUNT => p_txn_burdened_cost_tab(i));
617: IF l_converted_amount = -1 THEN
618: /* Added the If block for Bug#5395732 */
619: IF (p_calling_module IN ('BUDGET_GENERATION','FORECAST_GENERATION','UPDATE_PLAN_TRANSACTION','AMG_API')) THEN --Bug 9586291 --Bug 16448547
620: l_converted_amount := GL_CURRENCY_API.convert_closest_amount_sql
621: ( x_from_currency => p_txn_currency_code_tab(i)
622: ,x_to_currency => p_projfunc_currency_code_tab(i)
623: ,x_conversion_date => p_projfunc_cost_rate_date_tab(i)
624: ,x_conversion_type => p_projfunc_cost_rate_type_tab(i)

Line 694: l_numerator := GL_CURRENCY_API.get_closest_rate_numerator_sql

690: l_stage := 2600;
691: --hr_utility.trace(to_char(l_stage));
692: IF l_converted_amount <> -1 AND l_converted_amount <> -2 THEN -- Added for Bug#5395732
693: IF l_call_closest_flag = 'T' THEN -- Added for Bug#5395732
694: l_numerator := GL_CURRENCY_API.get_closest_rate_numerator_sql
695: ( p_txn_currency_code_tab(i)
696: ,p_projfunc_currency_code_tab(i)
697: ,p_projfunc_cost_rate_date_tab(i)
698: ,p_projfunc_cost_rate_type_tab(i)

Line 701: l_numerator := gl_currency_api.get_rate_numerator_sql

697: ,p_projfunc_cost_rate_date_tab(i)
698: ,p_projfunc_cost_rate_type_tab(i)
699: ,-1);
700: ELSE
701: l_numerator := gl_currency_api.get_rate_numerator_sql
702: ( X_FROM_CURRENCY => p_txn_currency_code_tab(i)
703: ,X_TO_CURRENCY => p_projfunc_currency_code_tab(i)
704: ,X_CONVERSION_DATE => p_projfunc_cost_rate_date_tab(i)
705: ,X_CONVERSION_TYPE => p_projfunc_cost_rate_type_tab(i));

Line 710: l_denominator := GL_CURRENCY_API.get_closest_rate_denom_sql

706: END IF;
707: l_stage := 2700;
708: --hr_utility.trace(to_char(l_stage));
709: IF l_call_closest_flag = 'T' THEN -- Added for Bug#5395732
710: l_denominator := GL_CURRENCY_API.get_closest_rate_denom_sql
711: ( p_txn_currency_code_tab(i)
712: ,p_projfunc_currency_code_tab(i)
713: ,p_projfunc_cost_rate_date_tab(i)
714: ,p_projfunc_cost_rate_type_tab(i)

Line 717: l_denominator := gl_currency_api.get_rate_denominator_sql

713: ,p_projfunc_cost_rate_date_tab(i)
714: ,p_projfunc_cost_rate_type_tab(i)
715: ,-1);
716: ELSE
717: l_denominator := gl_currency_api.get_rate_denominator_sql
718: ( X_FROM_CURRENCY => p_txn_currency_code_tab(i)
719: ,X_TO_CURRENCY => p_projfunc_currency_code_tab(i)
720: ,X_CONVERSION_DATE => p_projfunc_cost_rate_date_tab(i)
721: ,X_CONVERSION_TYPE => p_projfunc_cost_rate_type_tab(i));

Line 859: l_converted_amount := gl_currency_api.convert_amount_sql

855: END IF; -- CachedRowTab.COUNT > 0
856: IF l_done_flag = 'N' THEN
857: l_stage := 3600;
858: --hr_utility.trace(to_char(l_stage));
859: l_converted_amount := gl_currency_api.convert_amount_sql
860: ( X_FROM_CURRENCY => p_txn_currency_code_tab(i)
861: ,X_TO_CURRENCY => p_projfunc_currency_code_tab(i)
862: ,X_CONVERSION_DATE => p_projfunc_rev_rate_date_tab(i)
863: ,X_CONVERSION_TYPE => p_projfunc_rev_rate_type_tab(i)

Line 869: l_converted_amount := GL_CURRENCY_API.convert_closest_amount_sql

865:
866: IF l_converted_amount = -1 THEN
867: /* Added the If block for Bug#5395732 */
868: IF (p_calling_module IN ('BUDGET_GENERATION','FORECAST_GENERATION','UPDATE_PLAN_TRANSACTION','AMG_API')) THEN --Bug 9586291 --Bug 16448547
869: l_converted_amount := GL_CURRENCY_API.convert_closest_amount_sql
870: ( x_from_currency => p_txn_currency_code_tab(i)
871: ,x_to_currency => p_projfunc_currency_code_tab(i)
872: ,x_conversion_date => p_projfunc_rev_rate_date_tab(i)
873: ,x_conversion_type => p_projfunc_rev_rate_type_tab(i)

Line 942: l_numerator := GL_CURRENCY_API.get_closest_rate_numerator_sql

938: l_stage := 4000;
939: --hr_utility.trace(to_char(l_stage));
940: IF l_converted_amount <> -1 AND l_converted_amount <> -2 THEN -- Added for Bug#5395732
941: IF l_call_closest_flag = 'T' THEN -- Added for Bug#5395732
942: l_numerator := GL_CURRENCY_API.get_closest_rate_numerator_sql
943: ( p_txn_currency_code_tab(i)
944: ,p_projfunc_currency_code_tab(i)
945: ,p_projfunc_rev_rate_date_tab(i)
946: ,p_projfunc_rev_rate_type_tab(i)

Line 950: l_numerator := gl_currency_api.get_rate_numerator_sql

946: ,p_projfunc_rev_rate_type_tab(i)
947: ,-1);
948: ELSE
949:
950: l_numerator := gl_currency_api.get_rate_numerator_sql
951: ( X_FROM_CURRENCY => p_txn_currency_code_tab(i)
952: ,X_TO_CURRENCY => p_projfunc_currency_code_tab(i)
953: ,X_CONVERSION_DATE => p_projfunc_rev_rate_date_tab(i)
954: ,X_CONVERSION_TYPE => p_projfunc_rev_rate_type_tab(i));

Line 959: l_denominator := GL_CURRENCY_API.get_closest_rate_denom_sql

955: END IF;
956: l_stage := 4100;
957: --hr_utility.trace(to_char(l_stage));
958: IF l_call_closest_flag = 'T' THEN -- Added for Bug#5395732
959: l_denominator := GL_CURRENCY_API.get_closest_rate_denom_sql
960: ( p_txn_currency_code_tab(i)
961: ,p_projfunc_currency_code_tab(i)
962: ,p_projfunc_rev_rate_date_tab(i)
963: ,p_projfunc_rev_rate_type_tab(i)

Line 966: l_denominator := gl_currency_api.get_rate_denominator_sql

962: ,p_projfunc_rev_rate_date_tab(i)
963: ,p_projfunc_rev_rate_type_tab(i)
964: ,-1);
965: ELSE
966: l_denominator := gl_currency_api.get_rate_denominator_sql
967: ( X_FROM_CURRENCY => p_txn_currency_code_tab(i)
968: ,X_TO_CURRENCY => p_projfunc_currency_code_tab(i)
969: ,X_CONVERSION_DATE => p_projfunc_rev_rate_date_tab(i)
970: ,X_CONVERSION_TYPE => p_projfunc_rev_rate_type_tab(i));

Line 1135: l_converted_amount := gl_currency_api.convert_amount_sql

1131: --hr_utility.trace(to_char(l_stage));
1132: IF nvl(p_txn_raw_cost_tab(i),0) <> 0 THEN
1133: l_stage := 5500;
1134: --hr_utility.trace(to_char(l_stage));
1135: l_converted_amount := gl_currency_api.convert_amount_sql
1136: ( X_FROM_CURRENCY => p_txn_currency_code_tab(i)
1137: ,X_TO_CURRENCY => p_proj_currency_code_tab(i)
1138: ,X_CONVERSION_DATE => p_proj_cost_rate_date_tab(i)
1139: ,X_CONVERSION_TYPE => p_proj_cost_rate_type_tab(i)

Line 1153: l_converted_amount := GL_CURRENCY_API.convert_closest_amount_sql

1149: END IF;
1150: IF l_converted_amount = -1 THEN
1151: /* Added the If block for Bug#5395732 */
1152: IF (p_calling_module IN ('BUDGET_GENERATION','FORECAST_GENERATION','UPDATE_PLAN_TRANSACTION','AMG_API')) THEN --Bug 9586291 --Bug 16448547
1153: l_converted_amount := GL_CURRENCY_API.convert_closest_amount_sql
1154: ( x_from_currency => p_txn_currency_code_tab(i)
1155: ,x_to_currency => p_proj_currency_code_tab(i)
1156: ,x_conversion_date => p_proj_cost_rate_date_tab(i)
1157: ,x_conversion_type => p_proj_cost_rate_type_tab(i)

Line 1230: l_numerator := GL_CURRENCY_API.get_closest_rate_numerator_sql

1226: l_stage := 5900;
1227: --hr_utility.trace(to_char(l_stage));
1228: IF l_converted_amount <> -1 AND l_converted_amount <> -2 THEN -- Added for Bug#5395732
1229: IF l_call_closest_flag = 'T' THEN -- Added for Bug#5395732
1230: l_numerator := GL_CURRENCY_API.get_closest_rate_numerator_sql
1231: ( p_txn_currency_code_tab(i)
1232: ,p_proj_currency_code_tab(i)
1233: ,p_proj_cost_rate_date_tab(i)
1234: ,p_proj_cost_rate_type_tab(i)

Line 1237: l_numerator := gl_currency_api.get_rate_numerator_sql

1233: ,p_proj_cost_rate_date_tab(i)
1234: ,p_proj_cost_rate_type_tab(i)
1235: ,-1);
1236: ELSE
1237: l_numerator := gl_currency_api.get_rate_numerator_sql
1238: ( X_FROM_CURRENCY => p_txn_currency_code_tab(i)
1239: ,X_TO_CURRENCY => p_proj_currency_code_tab(i)
1240: ,X_CONVERSION_DATE => p_proj_cost_rate_date_tab(i)
1241: ,X_CONVERSION_TYPE => p_proj_cost_rate_type_tab(i));

Line 1246: l_denominator := GL_CURRENCY_API.get_closest_rate_denom_sql

1242: END IF;
1243: l_stage := 6000;
1244: --hr_utility.trace(to_char(l_stage));
1245: IF l_call_closest_flag = 'T' THEN -- Added for Bug#5395732
1246: l_denominator := GL_CURRENCY_API.get_closest_rate_denom_sql
1247: ( p_txn_currency_code_tab(i)
1248: ,p_proj_currency_code_tab(i)
1249: ,p_proj_cost_rate_date_tab(i)
1250: ,p_proj_cost_rate_type_tab(i)

Line 1253: l_denominator := gl_currency_api.get_rate_denominator_sql

1249: ,p_proj_cost_rate_date_tab(i)
1250: ,p_proj_cost_rate_type_tab(i)
1251: ,-1);
1252: ELSE
1253: l_denominator := gl_currency_api.get_rate_denominator_sql
1254: ( X_FROM_CURRENCY => p_txn_currency_code_tab(i)
1255: ,X_TO_CURRENCY => p_proj_currency_code_tab(i)
1256: ,X_CONVERSION_DATE => p_proj_cost_rate_date_tab(i)
1257: ,X_CONVERSION_TYPE => p_proj_cost_rate_type_tab(i));

Line 1301: l_converted_amount := gl_currency_api.convert_amount_sql

1297: l_call_closest_flag := 'N'; -- Added for Bug#5395732 Resetting.
1298: ELSE -- Raw Cost IS NULL or 0
1299: l_stage := 6400;
1300: --hr_utility.trace(to_char(l_stage));
1301: l_converted_amount := gl_currency_api.convert_amount_sql
1302: ( X_FROM_CURRENCY => p_txn_currency_code_tab(i)
1303: ,X_TO_CURRENCY => p_proj_currency_code_tab(i)
1304: ,X_CONVERSION_DATE => p_proj_cost_rate_date_tab(i)
1305: ,X_CONVERSION_TYPE => p_proj_cost_rate_type_tab(i)

Line 1310: l_converted_amount := GL_CURRENCY_API.convert_closest_amount_sql

1306: ,X_AMOUNT => p_txn_burdened_cost_tab(i));
1307: IF l_converted_amount = -1 THEN
1308: /* Added the If block for Bug#5395732 */
1309: IF (p_calling_module IN ('BUDGET_GENERATION','FORECAST_GENERATION','UPDATE_PLAN_TRANSACTION','AMG_API')) THEN --Bug 9586291 --Bug 16448547
1310: l_converted_amount := GL_CURRENCY_API.convert_closest_amount_sql
1311: ( x_from_currency => p_txn_currency_code_tab(i)
1312: ,x_to_currency => p_proj_currency_code_tab(i)
1313: ,x_conversion_date => p_proj_cost_rate_date_tab(i)
1314: ,x_conversion_type => p_proj_cost_rate_type_tab(i)

Line 1384: l_numerator := GL_CURRENCY_API.get_closest_rate_numerator_sql

1380: l_stage := 6800;
1381: --hr_utility.trace(to_char(l_stage));
1382: IF l_converted_amount <> -1 AND l_converted_amount <> -2 THEN -- Added for Bug#5395732
1383: IF l_call_closest_flag = 'T' THEN -- Added for Bug#5395732
1384: l_numerator := GL_CURRENCY_API.get_closest_rate_numerator_sql
1385: ( p_txn_currency_code_tab(i)
1386: ,p_proj_currency_code_tab(i)
1387: ,p_proj_cost_rate_date_tab(i)
1388: ,p_proj_cost_rate_type_tab(i)

Line 1391: l_numerator := gl_currency_api.get_rate_numerator_sql

1387: ,p_proj_cost_rate_date_tab(i)
1388: ,p_proj_cost_rate_type_tab(i)
1389: ,-1);
1390: ELSE
1391: l_numerator := gl_currency_api.get_rate_numerator_sql
1392: ( X_FROM_CURRENCY => p_txn_currency_code_tab(i)
1393: ,X_TO_CURRENCY => p_proj_currency_code_tab(i)
1394: ,X_CONVERSION_DATE => p_proj_cost_rate_date_tab(i)
1395: ,X_CONVERSION_TYPE => p_proj_cost_rate_type_tab(i));

Line 1400: l_denominator := GL_CURRENCY_API.get_closest_rate_denom_sql

1396: END IF;
1397: l_stage := 6900;
1398: --hr_utility.trace(to_char(l_stage));
1399: IF l_call_closest_flag = 'T' THEN -- Added for Bug#5395732
1400: l_denominator := GL_CURRENCY_API.get_closest_rate_denom_sql
1401: ( p_txn_currency_code_tab(i)
1402: ,p_proj_currency_code_tab(i)
1403: ,p_proj_cost_rate_date_tab(i)
1404: ,p_proj_cost_rate_type_tab(i)

Line 1408: l_denominator := gl_currency_api.get_rate_denominator_sql

1404: ,p_proj_cost_rate_type_tab(i)
1405: ,-1);
1406: ELSE
1407:
1408: l_denominator := gl_currency_api.get_rate_denominator_sql
1409: ( X_FROM_CURRENCY => p_txn_currency_code_tab(i)
1410: ,X_TO_CURRENCY => p_proj_currency_code_tab(i)
1411: ,X_CONVERSION_DATE => p_proj_cost_rate_date_tab(i)
1412: ,X_CONVERSION_TYPE => p_proj_cost_rate_type_tab(i));

Line 1551: l_converted_amount := gl_currency_api.convert_amount_sql

1547: END IF; -- CachedRowTab.COUNT > 0
1548: IF l_done_flag = 'N' THEN
1549: l_stage := 7700;
1550: --hr_utility.trace(to_char(l_stage));
1551: l_converted_amount := gl_currency_api.convert_amount_sql
1552: ( X_FROM_CURRENCY => p_txn_currency_code_tab(i)
1553: ,X_TO_CURRENCY => p_proj_currency_code_tab(i)
1554: ,X_CONVERSION_DATE => p_proj_rev_rate_date_tab(i)
1555: ,X_CONVERSION_TYPE => p_proj_rev_rate_type_tab(i)

Line 1569: l_converted_amount := GL_CURRENCY_API.convert_closest_amount_sql

1565: END IF;
1566: IF l_converted_amount = -1 THEN
1567: /* Added the If block for Bug#5395732 */
1568: IF (p_calling_module IN ('BUDGET_GENERATION','FORECAST_GENERATION','UPDATE_PLAN_TRANSACTION','AMG_API')) THEN --Bug 9586291 --Bug 16448547
1569: l_converted_amount := GL_CURRENCY_API.convert_closest_amount_sql
1570: ( x_from_currency => p_txn_currency_code_tab(i)
1571: ,x_to_currency => p_proj_currency_code_tab(i)
1572: ,x_conversion_date => p_proj_rev_rate_date_tab(i)
1573: ,x_conversion_type => p_proj_rev_rate_type_tab(i)

Line 1649: l_numerator := GL_CURRENCY_API.get_closest_rate_numerator_sql

1645: l_stage := 8100;
1646: --hr_utility.trace(to_char(l_stage));
1647: IF l_converted_amount <> -1 AND l_converted_amount <> -2 THEN -- Added for Bug#5395732
1648: IF l_call_closest_flag = 'T' THEN -- Added for Bug#5395732
1649: l_numerator := GL_CURRENCY_API.get_closest_rate_numerator_sql
1650: ( p_txn_currency_code_tab(i)
1651: ,p_proj_currency_code_tab(i)
1652: ,p_proj_rev_rate_date_tab(i)
1653: ,p_proj_rev_rate_type_tab(i)

Line 1657: l_numerator := gl_currency_api.get_rate_numerator_sql

1653: ,p_proj_rev_rate_type_tab(i)
1654: ,-1);
1655: ELSE
1656:
1657: l_numerator := gl_currency_api.get_rate_numerator_sql
1658: ( X_FROM_CURRENCY => p_txn_currency_code_tab(i)
1659: ,X_TO_CURRENCY => p_proj_currency_code_tab(i)
1660: ,X_CONVERSION_DATE => p_proj_rev_rate_date_tab(i)
1661: ,X_CONVERSION_TYPE => p_proj_rev_rate_type_tab(i));

Line 1667: l_denominator := GL_CURRENCY_API.get_closest_rate_denom_sql

1663:
1664: l_stage := 8200;
1665: --hr_utility.trace(to_char(l_stage));
1666: IF l_call_closest_flag = 'T' THEN -- Added for Bug#5395732
1667: l_denominator := GL_CURRENCY_API.get_closest_rate_denom_sql
1668: ( p_txn_currency_code_tab(i)
1669: ,p_proj_currency_code_tab(i)
1670: ,p_proj_rev_rate_date_tab(i)
1671: ,p_proj_rev_rate_type_tab(i)

Line 1674: l_denominator := gl_currency_api.get_rate_denominator_sql

1670: ,p_proj_rev_rate_date_tab(i)
1671: ,p_proj_rev_rate_type_tab(i)
1672: ,-1);
1673: ELSE
1674: l_denominator := gl_currency_api.get_rate_denominator_sql
1675: ( X_FROM_CURRENCY => p_txn_currency_code_tab(i)
1676: ,X_TO_CURRENCY => p_proj_currency_code_tab(i)
1677: ,X_CONVERSION_DATE => p_proj_rev_rate_date_tab(i)
1678: ,X_CONVERSION_TYPE => p_proj_rev_rate_type_tab(i));