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 207: to_date(FND_PROFILE.VALUE('BIS_GLOBAL_START_DATE'),

203:
204: begin
205:
206: l_global_start_date :=
207: to_date(FND_PROFILE.VALUE('BIS_GLOBAL_START_DATE'),
208: 'MM/DD/YYYY');
209: l_override := FND_PROFILE.VALUE('PJI_GLOBAL_START_DATE_OVERRIDE');
210:
211: if (l_override is not null) then

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

205:
206: l_global_start_date :=
207: to_date(FND_PROFILE.VALUE('BIS_GLOBAL_START_DATE'),
208: 'MM/DD/YYYY');
209: l_override := FND_PROFILE.VALUE('PJI_GLOBAL_START_DATE_OVERRIDE');
210:
211: if (l_override is not null) then
212:
213: begin

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

271:
272: if (g_pa_debug_mode = 'Y' or
273: g_debug_level = 5) then
274:
275: l_output_dest := nvl(FND_PROFILE.VALUE('PJI_OUTPUT_DESTINATION'),
276: g_output_dest);
277:
278: if (p_timer_flag) then
279: l_timestamp := ' ' || to_char(sysdate, 'YYYY/MM/DD HH24:MI:SS');

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

336: l_output_dest varchar2(15);
337:
338: begin
339:
340: l_output_dest := nvl(FND_PROFILE.VALUE('PJI_OUTPUT_DESTINATION'),
341: g_output_dest);
342:
343: if (l_output_dest = 'TABLE') then
344:

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

765: l_rate number;
766:
767: begin
768:
769: l_global_currency_code := FND_PROFILE.VALUE('BIS_PRIMARY_CURRENCY_CODE');
770: l_global_rate_type := FND_PROFILE.VALUE('BIS_PRIMARY_RATE_TYPE');
771: l_max_roll_days := NVL(PJI_UTILS.g_max_roll_days,32);
772: /* 5155692 Introduced the global variable g_max_roll_days, so that for plans we can
773: set it to 1500 and for actuals or default it will be 32 */

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

766:
767: begin
768:
769: l_global_currency_code := FND_PROFILE.VALUE('BIS_PRIMARY_CURRENCY_CODE');
770: l_global_rate_type := FND_PROFILE.VALUE('BIS_PRIMARY_RATE_TYPE');
771: l_max_roll_days := NVL(PJI_UTILS.g_max_roll_days,32);
772: /* 5155692 Introduced the global variable g_max_roll_days, so that for plans we can
773: set it to 1500 and for actuals or default it will be 32 */
774:

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

826: l_warehouse_currency_code varchar2(15);
827:
828: begin
829:
830: l_warehouse_currency_code := FND_PROFILE.VALUE('BIS_PRIMARY_CURRENCY_CODE');
831:
832: select nvl(curr.MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * curr.PRECISION)))
833: into l_mau
834: from FND_CURRENCIES curr

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

862: l_currency_code varchar2(30);
863:
864: begin
865:
866: l_currency_code := FND_PROFILE.VALUE('BIS_PRIMARY_CURRENCY_CODE');
867:
868: return l_currency_code;
869:
870: end GET_GLOBAL_PRIMARY_CURRENCY;

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

889: l_rate number;
890:
891: begin
892:
893: l_global_currency_code := FND_PROFILE.VALUE('BIS_SECONDARY_CURRENCY_CODE');
894: l_global_rate_type := FND_PROFILE.VALUE('BIS_SECONDARY_RATE_TYPE');
895: l_max_roll_days := NVL(PJI_UTILS.g_max_roll_days,32);
896: /* 5155692 Introduced the global variable g_max_roll_days, so that for plans we can
897: set it to 1500 and for actuals or default it will be 32 */

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

890:
891: begin
892:
893: l_global_currency_code := FND_PROFILE.VALUE('BIS_SECONDARY_CURRENCY_CODE');
894: l_global_rate_type := FND_PROFILE.VALUE('BIS_SECONDARY_RATE_TYPE');
895: l_max_roll_days := NVL(PJI_UTILS.g_max_roll_days,32);
896: /* 5155692 Introduced the global variable g_max_roll_days, so that for plans we can
897: set it to 1500 and for actuals or default it will be 32 */
898:

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

951: l_warehouse_currency_code varchar2(15);
952:
953: BEGIN
954:
955: l_warehouse_currency_code := FND_PROFILE.VALUE('BIS_SECONDARY_CURRENCY_CODE');
956:
957: select nvl(curr.MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * curr.PRECISION)))
958: into l_mau
959: from FND_CURRENCIES curr

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

987: l_currency_code varchar2(30);
988:
989: begin
990:
991: l_currency_code := FND_PROFILE.VALUE('BIS_SECONDARY_CURRENCY_CODE');
992:
993: return l_currency_code;
994:
995: end GET_GLOBAL_SECONDARY_CURRENCY;

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

1064: function GET_RATE_TYPE return varchar2 is
1065:
1066: begin
1067:
1068: return FND_PROFILE.VALUE('BIS_PRIMARY_RATE_TYPE');
1069:
1070: end GET_RATE_TYPE;
1071:
1072:

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

1118:
1119: begin
1120:
1121: l_parallel := null;
1122: l_parallel := floor(fnd_profile.value('EDW_PARALLEL_SRC')); -- gets value of profile option
1123:
1124: /* Set by the customer, return this value */
1125:
1126: IF (l_parallel IS NOT NULL and l_parallel > 0) THEN

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

1168: -- *** This API returns value for BIS: Enterprise Calendar
1169: -- *** profile.
1170: --
1171: BEGIN
1172: l_period_set_name:=Fnd_Profile.VALUE('BIS_ENTERPRISE_CALENDAR');
1173: RETURN l_period_set_name;
1174: EXCEPTION
1175: WHEN NO_DATA_FOUND THEN
1176: RETURN NULL;

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

1195: -- *** profile.
1196: --
1197: l_start_dayofweek VARCHAR2(30);
1198: BEGIN
1199: l_start_dayofweek:=Fnd_Profile.VALUE('BIS_START_DAY_OF_WEEK');
1200: RETURN l_start_dayofweek;
1201: EXCEPTION
1202: WHEN NO_DATA_FOUND THEN
1203: RETURN NULL;

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

1222: -- *** profile.
1223: --
1224: l_period_type VARCHAR2(15);
1225: BEGIN
1226: l_period_type:=Fnd_Profile.VALUE('BIS_PERIOD_TYPE');
1227: RETURN l_period_type;
1228: EXCEPTION
1229: WHEN NO_DATA_FOUND THEN
1230: RETURN NULL;

Line 1652: FROM FND_PROFILE_OPTIONS OP , FND_PROFILE_OPTION_VALUES VAL

1648: /* Modified the following select statement for bug 6802867 */
1649:
1650: SELECT OP.PROFILE_OPTION_NAME,VAL.PROFILE_OPTION_VALUE BULK COLLECT
1651: INTO prof_opt_tbl,prof_val_tbl
1652: FROM FND_PROFILE_OPTIONS OP , FND_PROFILE_OPTION_VALUES VAL
1653: WHERE OP.PROFILE_OPTION_NAME
1654: IN ('BIS_PRIMARY_CURRENCY_CODE','BIS_PRIMARY_RATE_TYPE','BIS_SECONDARY_CURRENCY_CODE',
1655: 'BIS_SECONDARY_RATE_TYPE','BIS_ENTERPRISE_CALENDAR','BIS_PERIOD_TYPE','BIS_GLOBAL_START_DATE',
1656: 'PJI_GLOBAL_START_DATE_OVERRIDE', 'PJI_EXTRACTION_BATCH_SIZE','PJI_DEF_RPT_CUR_TYPE','PJI_DEF_RPT_CAL_TYPE')

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

2213: from v$session
2214: where audsid = userenv('SESSIONID');
2215:
2216: g_session_user_id := fnd_global.user_id;
2217: g_pa_debug_mode := fnd_profile.value('PA_DEBUG_MODE');
2218: g_debug_level := nvl(FND_PROFILE.VALUE('PJI_DEBUG_LEVEL'), 5);
2219:
2220: end;
2221:

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

2214: where audsid = userenv('SESSIONID');
2215:
2216: g_session_user_id := fnd_global.user_id;
2217: g_pa_debug_mode := fnd_profile.value('PA_DEBUG_MODE');
2218: g_debug_level := nvl(FND_PROFILE.VALUE('PJI_DEBUG_LEVEL'), 5);
2219:
2220: end;
2221:
2222: