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.PJI_UTILS dependencies on FND_PROFILE

Line 187: to_date(FND_PROFILE.VALUE('BIS_GLOBAL_START_DATE'),

183:
184: begin
185:
186: l_global_start_date :=
187: to_date(FND_PROFILE.VALUE('BIS_GLOBAL_START_DATE'),
188: 'MM/DD/YYYY');
189: l_override := FND_PROFILE.VALUE('PJI_GLOBAL_START_DATE_OVERRIDE');
190:
191: if (l_override is not null) then

Line 189: l_override := FND_PROFILE.VALUE('PJI_GLOBAL_START_DATE_OVERRIDE');

185:
186: l_global_start_date :=
187: to_date(FND_PROFILE.VALUE('BIS_GLOBAL_START_DATE'),
188: 'MM/DD/YYYY');
189: l_override := FND_PROFILE.VALUE('PJI_GLOBAL_START_DATE_OVERRIDE');
190:
191: if (l_override is not null) then
192:
193: begin

Line 255: l_output_dest := nvl(FND_PROFILE.VALUE('PJI_OUTPUT_DESTINATION'),

251:
252: if (g_pa_debug_mode = 'Y' or
253: g_debug_level = 5) then
254:
255: l_output_dest := nvl(FND_PROFILE.VALUE('PJI_OUTPUT_DESTINATION'),
256: g_output_dest);
257:
258: if (p_timer_flag) then
259: l_timestamp := ' ' || to_char(sysdate, 'YYYY/MM/DD HH24:MI:SS');

Line 320: l_output_dest := nvl(FND_PROFILE.VALUE('PJI_OUTPUT_DESTINATION'),

316: l_output_dest varchar2(15);
317:
318: begin
319:
320: l_output_dest := nvl(FND_PROFILE.VALUE('PJI_OUTPUT_DESTINATION'),
321: g_output_dest);
322:
323: if (l_output_dest = 'TABLE') then
324:

Line 652: l_global_currency_code := FND_PROFILE.VALUE('BIS_PRIMARY_CURRENCY_CODE');

648: l_rate number;
649:
650: begin
651:
652: l_global_currency_code := FND_PROFILE.VALUE('BIS_PRIMARY_CURRENCY_CODE');
653: l_global_rate_type := FND_PROFILE.VALUE('BIS_PRIMARY_RATE_TYPE');
654: l_max_roll_days := NVL(PJI_UTILS.g_max_roll_days,32);
655: /* 5155692 Introduced the global variable g_max_roll_days, so that for plans we can
656: set it to 1500 and for actuals or default it will be 32 */

Line 653: l_global_rate_type := FND_PROFILE.VALUE('BIS_PRIMARY_RATE_TYPE');

649:
650: begin
651:
652: l_global_currency_code := FND_PROFILE.VALUE('BIS_PRIMARY_CURRENCY_CODE');
653: l_global_rate_type := FND_PROFILE.VALUE('BIS_PRIMARY_RATE_TYPE');
654: l_max_roll_days := NVL(PJI_UTILS.g_max_roll_days,32);
655: /* 5155692 Introduced the global variable g_max_roll_days, so that for plans we can
656: set it to 1500 and for actuals or default it will be 32 */
657:

Line 713: l_warehouse_currency_code := FND_PROFILE.VALUE('BIS_PRIMARY_CURRENCY_CODE');

709: l_warehouse_currency_code varchar2(15);
710:
711: begin
712:
713: l_warehouse_currency_code := FND_PROFILE.VALUE('BIS_PRIMARY_CURRENCY_CODE');
714:
715: select nvl(curr.MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * curr.PRECISION)))
716: into l_mau
717: from FND_CURRENCIES curr

Line 749: l_currency_code := FND_PROFILE.VALUE('BIS_PRIMARY_CURRENCY_CODE');

745: l_currency_code varchar2(30);
746:
747: begin
748:
749: l_currency_code := FND_PROFILE.VALUE('BIS_PRIMARY_CURRENCY_CODE');
750:
751: return l_currency_code;
752:
753: end GET_GLOBAL_PRIMARY_CURRENCY;

Line 776: l_global_currency_code := FND_PROFILE.VALUE('BIS_SECONDARY_CURRENCY_CODE');

772: l_rate number;
773:
774: begin
775:
776: l_global_currency_code := FND_PROFILE.VALUE('BIS_SECONDARY_CURRENCY_CODE');
777: l_global_rate_type := FND_PROFILE.VALUE('BIS_SECONDARY_RATE_TYPE');
778: l_max_roll_days := NVL(PJI_UTILS.g_max_roll_days,32);
779: /* 5155692 Introduced the global variable g_max_roll_days, so that for plans we can
780: set it to 1500 and for actuals or default it will be 32 */

Line 777: l_global_rate_type := FND_PROFILE.VALUE('BIS_SECONDARY_RATE_TYPE');

773:
774: begin
775:
776: l_global_currency_code := FND_PROFILE.VALUE('BIS_SECONDARY_CURRENCY_CODE');
777: l_global_rate_type := FND_PROFILE.VALUE('BIS_SECONDARY_RATE_TYPE');
778: l_max_roll_days := NVL(PJI_UTILS.g_max_roll_days,32);
779: /* 5155692 Introduced the global variable g_max_roll_days, so that for plans we can
780: set it to 1500 and for actuals or default it will be 32 */
781:

Line 838: l_warehouse_currency_code := FND_PROFILE.VALUE('BIS_SECONDARY_CURRENCY_CODE');

834: l_warehouse_currency_code varchar2(15);
835:
836: BEGIN
837:
838: l_warehouse_currency_code := FND_PROFILE.VALUE('BIS_SECONDARY_CURRENCY_CODE');
839:
840: select nvl(curr.MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * curr.PRECISION)))
841: into l_mau
842: from FND_CURRENCIES curr

Line 874: l_currency_code := FND_PROFILE.VALUE('BIS_SECONDARY_CURRENCY_CODE');

870: l_currency_code varchar2(30);
871:
872: begin
873:
874: l_currency_code := FND_PROFILE.VALUE('BIS_SECONDARY_CURRENCY_CODE');
875:
876: return l_currency_code;
877:
878: end GET_GLOBAL_SECONDARY_CURRENCY;

Line 951: return FND_PROFILE.VALUE('BIS_PRIMARY_RATE_TYPE');

947: function GET_RATE_TYPE return varchar2 is
948:
949: begin
950:
951: return FND_PROFILE.VALUE('BIS_PRIMARY_RATE_TYPE');
952:
953: end GET_RATE_TYPE;
954:
955:

Line 1005: l_parallel := floor(fnd_profile.value('EDW_PARALLEL_SRC')); -- gets value of profile option

1001:
1002: begin
1003:
1004: l_parallel := null;
1005: l_parallel := floor(fnd_profile.value('EDW_PARALLEL_SRC')); -- gets value of profile option
1006:
1007: /* Set by the customer, return this value */
1008:
1009: IF (l_parallel IS NOT NULL and l_parallel > 0) THEN

Line 1055: l_period_set_name:=Fnd_Profile.VALUE('BIS_ENTERPRISE_CALENDAR');

1051: -- *** This API returns value for BIS: Enterprise Calendar
1052: -- *** profile.
1053: --
1054: BEGIN
1055: l_period_set_name:=Fnd_Profile.VALUE('BIS_ENTERPRISE_CALENDAR');
1056: RETURN l_period_set_name;
1057: EXCEPTION
1058: WHEN NO_DATA_FOUND THEN
1059: RETURN NULL;

Line 1082: l_start_dayofweek:=Fnd_Profile.VALUE('BIS_START_DAY_OF_WEEK');

1078: -- *** profile.
1079: --
1080: l_start_dayofweek VARCHAR2(30);
1081: BEGIN
1082: l_start_dayofweek:=Fnd_Profile.VALUE('BIS_START_DAY_OF_WEEK');
1083: RETURN l_start_dayofweek;
1084: EXCEPTION
1085: WHEN NO_DATA_FOUND THEN
1086: RETURN NULL;

Line 1109: l_period_type:=Fnd_Profile.VALUE('BIS_PERIOD_TYPE');

1105: -- *** profile.
1106: --
1107: l_period_type VARCHAR2(15);
1108: BEGIN
1109: l_period_type:=Fnd_Profile.VALUE('BIS_PERIOD_TYPE');
1110: RETURN l_period_type;
1111: EXCEPTION
1112: WHEN NO_DATA_FOUND THEN
1113: RETURN NULL;

Line 1524: FROM FND_PROFILE_OPTIONS OP , FND_PROFILE_OPTION_VALUES VAL

1520: BEGIN
1521:
1522: SELECT OP.PROFILE_OPTION_NAME,VAL.PROFILE_OPTION_VALUE BULK COLLECT
1523: INTO prof_opt_tbl,prof_val_tbl
1524: FROM FND_PROFILE_OPTIONS OP , FND_PROFILE_OPTION_VALUES VAL
1525: WHERE OP.PROFILE_OPTION_NAME
1526: IN ('BIS_PRIMARY_CURRENCY_CODE','BIS_PRIMARY_RATE_TYPE','BIS_SECONDARY_CURRENCY_CODE',
1527: 'BIS_SECONDARY_RATE_TYPE','BIS_ENTERPRISE_CALENDAR','BIS_PERIOD_TYPE','BIS_GLOBAL_START_DATE',
1528: 'PJI_GLOBAL_START_DATE_OVERRIDE')

Line 2048: g_pa_debug_mode := fnd_profile.value('PA_DEBUG_MODE');

2044: from v$session
2045: where audsid = userenv('SESSIONID');
2046:
2047: g_session_user_id := fnd_global.user_id;
2048: g_pa_debug_mode := fnd_profile.value('PA_DEBUG_MODE');
2049: g_debug_level := nvl(FND_PROFILE.VALUE('PJI_DEBUG_LEVEL'), 5);
2050:
2051: end;
2052:

Line 2049: g_debug_level := nvl(FND_PROFILE.VALUE('PJI_DEBUG_LEVEL'), 5);

2045: where audsid = userenv('SESSIONID');
2046:
2047: g_session_user_id := fnd_global.user_id;
2048: g_pa_debug_mode := fnd_profile.value('PA_DEBUG_MODE');
2049: g_debug_level := nvl(FND_PROFILE.VALUE('PJI_DEBUG_LEVEL'), 5);
2050:
2051: end;
2052:
2053: