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')) THEN
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')) THEN
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')) THEN
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 1144: l_converted_amount := GL_CURRENCY_API.convert_closest_amount_sql

1140: ,X_AMOUNT => p_txn_raw_cost_tab(i));
1141: IF l_converted_amount = -1 THEN
1142: /* Added the If block for Bug#5395732 */
1143: IF (p_calling_module IN ('BUDGET_GENERATION','FORECAST_GENERATION')) THEN
1144: l_converted_amount := GL_CURRENCY_API.convert_closest_amount_sql
1145: ( x_from_currency => p_txn_currency_code_tab(i)
1146: ,x_to_currency => p_proj_currency_code_tab(i)
1147: ,x_conversion_date => p_proj_cost_rate_date_tab(i)
1148: ,x_conversion_type => p_proj_cost_rate_type_tab(i)

Line 1213: l_numerator := GL_CURRENCY_API.get_closest_rate_numerator_sql

1209: l_stage := 5900;
1210: --hr_utility.trace(to_char(l_stage));
1211: IF l_converted_amount <> -1 AND l_converted_amount <> -2 THEN -- Added for Bug#5395732
1212: IF l_call_closest_flag = 'T' THEN -- Added for Bug#5395732
1213: l_numerator := GL_CURRENCY_API.get_closest_rate_numerator_sql
1214: ( p_txn_currency_code_tab(i)
1215: ,p_proj_currency_code_tab(i)
1216: ,p_proj_cost_rate_date_tab(i)
1217: ,p_proj_cost_rate_type_tab(i)

Line 1220: l_numerator := gl_currency_api.get_rate_numerator_sql

1216: ,p_proj_cost_rate_date_tab(i)
1217: ,p_proj_cost_rate_type_tab(i)
1218: ,-1);
1219: ELSE
1220: l_numerator := gl_currency_api.get_rate_numerator_sql
1221: ( X_FROM_CURRENCY => p_txn_currency_code_tab(i)
1222: ,X_TO_CURRENCY => p_proj_currency_code_tab(i)
1223: ,X_CONVERSION_DATE => p_proj_cost_rate_date_tab(i)
1224: ,X_CONVERSION_TYPE => p_proj_cost_rate_type_tab(i));

Line 1229: l_denominator := GL_CURRENCY_API.get_closest_rate_denom_sql

1225: END IF;
1226: l_stage := 6000;
1227: --hr_utility.trace(to_char(l_stage));
1228: IF l_call_closest_flag = 'T' THEN -- Added for Bug#5395732
1229: l_denominator := GL_CURRENCY_API.get_closest_rate_denom_sql
1230: ( p_txn_currency_code_tab(i)
1231: ,p_proj_currency_code_tab(i)
1232: ,p_proj_cost_rate_date_tab(i)
1233: ,p_proj_cost_rate_type_tab(i)

Line 1236: l_denominator := gl_currency_api.get_rate_denominator_sql

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

Line 1284: l_converted_amount := gl_currency_api.convert_amount_sql

1280: l_call_closest_flag := 'N'; -- Added for Bug#5395732 Resetting.
1281: ELSE -- Raw Cost IS NULL or 0
1282: l_stage := 6400;
1283: --hr_utility.trace(to_char(l_stage));
1284: l_converted_amount := gl_currency_api.convert_amount_sql
1285: ( X_FROM_CURRENCY => p_txn_currency_code_tab(i)
1286: ,X_TO_CURRENCY => p_proj_currency_code_tab(i)
1287: ,X_CONVERSION_DATE => p_proj_cost_rate_date_tab(i)
1288: ,X_CONVERSION_TYPE => p_proj_cost_rate_type_tab(i)

Line 1293: l_converted_amount := GL_CURRENCY_API.convert_closest_amount_sql

1289: ,X_AMOUNT => p_txn_burdened_cost_tab(i));
1290: IF l_converted_amount = -1 THEN
1291: /* Added the If block for Bug#5395732 */
1292: IF (p_calling_module IN ('BUDGET_GENERATION','FORECAST_GENERATION')) THEN
1293: l_converted_amount := GL_CURRENCY_API.convert_closest_amount_sql
1294: ( x_from_currency => p_txn_currency_code_tab(i)
1295: ,x_to_currency => p_proj_currency_code_tab(i)
1296: ,x_conversion_date => p_proj_cost_rate_date_tab(i)
1297: ,x_conversion_type => p_proj_cost_rate_type_tab(i)

Line 1367: l_numerator := GL_CURRENCY_API.get_closest_rate_numerator_sql

1363: l_stage := 6800;
1364: --hr_utility.trace(to_char(l_stage));
1365: IF l_converted_amount <> -1 AND l_converted_amount <> -2 THEN -- Added for Bug#5395732
1366: IF l_call_closest_flag = 'T' THEN -- Added for Bug#5395732
1367: l_numerator := GL_CURRENCY_API.get_closest_rate_numerator_sql
1368: ( p_txn_currency_code_tab(i)
1369: ,p_proj_currency_code_tab(i)
1370: ,p_proj_cost_rate_date_tab(i)
1371: ,p_proj_cost_rate_type_tab(i)

Line 1374: l_numerator := gl_currency_api.get_rate_numerator_sql

1370: ,p_proj_cost_rate_date_tab(i)
1371: ,p_proj_cost_rate_type_tab(i)
1372: ,-1);
1373: ELSE
1374: l_numerator := gl_currency_api.get_rate_numerator_sql
1375: ( X_FROM_CURRENCY => p_txn_currency_code_tab(i)
1376: ,X_TO_CURRENCY => p_proj_currency_code_tab(i)
1377: ,X_CONVERSION_DATE => p_proj_cost_rate_date_tab(i)
1378: ,X_CONVERSION_TYPE => p_proj_cost_rate_type_tab(i));

Line 1383: l_denominator := GL_CURRENCY_API.get_closest_rate_denom_sql

1379: END IF;
1380: l_stage := 6900;
1381: --hr_utility.trace(to_char(l_stage));
1382: IF l_call_closest_flag = 'T' THEN -- Added for Bug#5395732
1383: l_denominator := GL_CURRENCY_API.get_closest_rate_denom_sql
1384: ( p_txn_currency_code_tab(i)
1385: ,p_proj_currency_code_tab(i)
1386: ,p_proj_cost_rate_date_tab(i)
1387: ,p_proj_cost_rate_type_tab(i)

Line 1391: l_denominator := gl_currency_api.get_rate_denominator_sql

1387: ,p_proj_cost_rate_type_tab(i)
1388: ,-1);
1389: ELSE
1390:
1391: l_denominator := gl_currency_api.get_rate_denominator_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 1534: l_converted_amount := gl_currency_api.convert_amount_sql

1530: END IF; -- CachedRowTab.COUNT > 0
1531: IF l_done_flag = 'N' THEN
1532: l_stage := 7700;
1533: --hr_utility.trace(to_char(l_stage));
1534: l_converted_amount := gl_currency_api.convert_amount_sql
1535: ( X_FROM_CURRENCY => p_txn_currency_code_tab(i)
1536: ,X_TO_CURRENCY => p_proj_currency_code_tab(i)
1537: ,X_CONVERSION_DATE => p_proj_rev_rate_date_tab(i)
1538: ,X_CONVERSION_TYPE => p_proj_rev_rate_type_tab(i)

Line 1544: l_converted_amount := GL_CURRENCY_API.convert_closest_amount_sql

1540:
1541: IF l_converted_amount = -1 THEN
1542: /* Added the If block for Bug#5395732 */
1543: IF (p_calling_module IN ('BUDGET_GENERATION','FORECAST_GENERATION')) THEN
1544: l_converted_amount := GL_CURRENCY_API.convert_closest_amount_sql
1545: ( x_from_currency => p_txn_currency_code_tab(i)
1546: ,x_to_currency => p_proj_currency_code_tab(i)
1547: ,x_conversion_date => p_proj_rev_rate_date_tab(i)
1548: ,x_conversion_type => p_proj_rev_rate_type_tab(i)

Line 1616: l_numerator := GL_CURRENCY_API.get_closest_rate_numerator_sql

1612: l_stage := 8100;
1613: --hr_utility.trace(to_char(l_stage));
1614: IF l_converted_amount <> -1 AND l_converted_amount <> -2 THEN -- Added for Bug#5395732
1615: IF l_call_closest_flag = 'T' THEN -- Added for Bug#5395732
1616: l_numerator := GL_CURRENCY_API.get_closest_rate_numerator_sql
1617: ( p_txn_currency_code_tab(i)
1618: ,p_proj_currency_code_tab(i)
1619: ,p_proj_rev_rate_date_tab(i)
1620: ,p_proj_rev_rate_type_tab(i)

Line 1624: l_numerator := gl_currency_api.get_rate_numerator_sql

1620: ,p_proj_rev_rate_type_tab(i)
1621: ,-1);
1622: ELSE
1623:
1624: l_numerator := gl_currency_api.get_rate_numerator_sql
1625: ( X_FROM_CURRENCY => p_txn_currency_code_tab(i)
1626: ,X_TO_CURRENCY => p_proj_currency_code_tab(i)
1627: ,X_CONVERSION_DATE => p_proj_rev_rate_date_tab(i)
1628: ,X_CONVERSION_TYPE => p_proj_rev_rate_type_tab(i));

Line 1634: l_denominator := GL_CURRENCY_API.get_closest_rate_denom_sql

1630:
1631: l_stage := 8200;
1632: --hr_utility.trace(to_char(l_stage));
1633: IF l_call_closest_flag = 'T' THEN -- Added for Bug#5395732
1634: l_denominator := GL_CURRENCY_API.get_closest_rate_denom_sql
1635: ( p_txn_currency_code_tab(i)
1636: ,p_proj_currency_code_tab(i)
1637: ,p_proj_rev_rate_date_tab(i)
1638: ,p_proj_rev_rate_type_tab(i)

Line 1641: l_denominator := gl_currency_api.get_rate_denominator_sql

1637: ,p_proj_rev_rate_date_tab(i)
1638: ,p_proj_rev_rate_type_tab(i)
1639: ,-1);
1640: ELSE
1641: l_denominator := gl_currency_api.get_rate_denominator_sql
1642: ( X_FROM_CURRENCY => p_txn_currency_code_tab(i)
1643: ,X_TO_CURRENCY => p_proj_currency_code_tab(i)
1644: ,X_CONVERSION_DATE => p_proj_rev_rate_date_tab(i)
1645: ,X_CONVERSION_TYPE => p_proj_rev_rate_type_tab(i));