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.

[Home] [Help]

APPS.PA_REPORT_UTIL dependencies on FND_PROFILE

Line 191: l_period_type := FND_PROFILE.VALUE('PA_ORG_UTIL_DEF_PERIOD_TYPE');

187: END IF;
188:
189:
190: -- Populating default period type using profile options
191: l_period_type := FND_PROFILE.VALUE('PA_ORG_UTIL_DEF_PERIOD_TYPE');
192:
193: /* NPE Changes Begin */
194: -- Populating default period percentage using profile options
195: l_def_show_percentages_by := FND_PROFILE.VALUE('PA_ORG_UTIL_DEF_CALC_METHOD');

Line 195: l_def_show_percentages_by := FND_PROFILE.VALUE('PA_ORG_UTIL_DEF_CALC_METHOD');

191: l_period_type := FND_PROFILE.VALUE('PA_ORG_UTIL_DEF_PERIOD_TYPE');
192:
193: /* NPE Changes Begin */
194: -- Populating default period percentage using profile options
195: l_def_show_percentages_by := FND_PROFILE.VALUE('PA_ORG_UTIL_DEF_CALC_METHOD');
196:
197: l_global_week_start_day := FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY');
198:
199: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name1

Line 197: l_global_week_start_day := FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY');

193: /* NPE Changes Begin */
194: -- Populating default period percentage using profile options
195: l_def_show_percentages_by := FND_PROFILE.VALUE('PA_ORG_UTIL_DEF_CALC_METHOD');
196:
197: l_global_week_start_day := FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY');
198:
199: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name1
200: FROM fnd_profile_options_tl
201: WHERE profile_option_name='PA_ORG_UTIL_DEF_CALC_METHOD'

Line 200: FROM fnd_profile_options_tl

196:
197: l_global_week_start_day := FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY');
198:
199: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name1
200: FROM fnd_profile_options_tl
201: WHERE profile_option_name='PA_ORG_UTIL_DEF_CALC_METHOD'
202: AND language=userenv('LANG');
203:
204: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name2

Line 205: FROM fnd_profile_options_tl

201: WHERE profile_option_name='PA_ORG_UTIL_DEF_CALC_METHOD'
202: AND language=userenv('LANG');
203:
204: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name2
205: FROM fnd_profile_options_tl
206: WHERE profile_option_name='PA_ORG_UTIL_DEF_PERIOD_TYPE'
207: AND language=userenv('LANG');
208:
209: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name3

Line 210: FROM fnd_profile_options_tl

206: WHERE profile_option_name='PA_ORG_UTIL_DEF_PERIOD_TYPE'
207: AND language=userenv('LANG');
208:
209: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name3
210: FROM fnd_profile_options_tl
211: WHERE profile_option_name='PA_GLOBAL_WEEK_START_DAY'
212: AND language=userenv('LANG');
213:
214:

Line 496: TO_CHAR(NEXT_DAY(l_default_date, NVL(TO_NUMBER(FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY')),0)) -1,l_date_format)

492: /** Fix for bug 2387429 and 2091182 starts here **/
493: /* -- NPE Changes, it is shifted to above in the code l_date_format := icx_sec.getID(icx_sec.PV_DATE_FORMAT); */
494:
495: SELECT
496: TO_CHAR(NEXT_DAY(l_default_date, NVL(TO_NUMBER(FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY')),0)) -1,l_date_format)
497: INTO x_def_period_name
498: FROM sys.dual;
499: /*
500: SELECT

Line 501: TO_CHAR( NEXT_DAY(l_default_date, NVL( TO_NUMBER(FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY')),0)) -1, 'DD-MON-YYYY')

497: INTO x_def_period_name
498: FROM sys.dual;
499: /*
500: SELECT
501: TO_CHAR( NEXT_DAY(l_default_date, NVL( TO_NUMBER(FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY')),0)) -1, 'DD-MON-YYYY')
502: INTO x_def_period_name
503: FROM sys.dual;
504: */
505: /** Bug 2387429 and 2091182 Code Fix Ends **/

Line 1156: l_period_type := FND_PROFILE.VALUE_SPECIFIC('PA_RES_UTIL_DEF_PERIOD_TYPE');

1152: END;
1153: /* Bug2440313 End */
1154:
1155: -- Populating default period type using profile options
1156: l_period_type := FND_PROFILE.VALUE_SPECIFIC('PA_RES_UTIL_DEF_PERIOD_TYPE');
1157:
1158: /* NPE Changes Begins */
1159:
1160: l_def_show_percentages_by := FND_PROFILE.VALUE('PA_RES_UTIL_DEF_CALC_METHOD');

Line 1160: l_def_show_percentages_by := FND_PROFILE.VALUE('PA_RES_UTIL_DEF_CALC_METHOD');

1156: l_period_type := FND_PROFILE.VALUE_SPECIFIC('PA_RES_UTIL_DEF_PERIOD_TYPE');
1157:
1158: /* NPE Changes Begins */
1159:
1160: l_def_show_percentages_by := FND_PROFILE.VALUE('PA_RES_UTIL_DEF_CALC_METHOD');
1161: l_global_week_start_day := FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY');
1162:
1163: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name1
1164: FROM fnd_profile_options_tl

Line 1161: l_global_week_start_day := FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY');

1157:
1158: /* NPE Changes Begins */
1159:
1160: l_def_show_percentages_by := FND_PROFILE.VALUE('PA_RES_UTIL_DEF_CALC_METHOD');
1161: l_global_week_start_day := FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY');
1162:
1163: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name1
1164: FROM fnd_profile_options_tl
1165: WHERE profile_option_name='PA_RES_UTIL_DEF_CALC_METHOD'

Line 1164: FROM fnd_profile_options_tl

1160: l_def_show_percentages_by := FND_PROFILE.VALUE('PA_RES_UTIL_DEF_CALC_METHOD');
1161: l_global_week_start_day := FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY');
1162:
1163: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name1
1164: FROM fnd_profile_options_tl
1165: WHERE profile_option_name='PA_RES_UTIL_DEF_CALC_METHOD'
1166: AND language=userenv('LANG');
1167:
1168: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name2

Line 1169: FROM fnd_profile_options_tl

1165: WHERE profile_option_name='PA_RES_UTIL_DEF_CALC_METHOD'
1166: AND language=userenv('LANG');
1167:
1168: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name2
1169: FROM fnd_profile_options_tl
1170: WHERE profile_option_name='PA_RES_UTIL_DEF_PERIOD_TYPE'
1171: AND language=userenv('LANG');
1172:
1173: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name3

Line 1174: FROM fnd_profile_options_tl

1170: WHERE profile_option_name='PA_RES_UTIL_DEF_PERIOD_TYPE'
1171: AND language=userenv('LANG');
1172:
1173: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name3
1174: FROM fnd_profile_options_tl
1175: WHERE profile_option_name='PA_GLOBAL_WEEK_START_DAY'
1176: AND language=userenv('LANG');
1177:
1178:

Line 1470: TO_CHAR(NEXT_DAY(l_default_date, NVL(TO_NUMBER(FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY')),0)) -1,'DD-MON-YYYY')

1466: -- Populating period name
1467: /** Bug 2387429 and 2091182 Code Fix Starts **/
1468: /*
1469: SELECT
1470: TO_CHAR(NEXT_DAY(l_default_date, NVL(TO_NUMBER(FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY')),0)) -1,'DD-MON-YYYY')
1471: INTO x_def_period_name
1472: FROM sys.dual;
1473: */
1474:

Line 1478: TO_CHAR(NEXT_DAY(l_default_date, NVL(TO_NUMBER(FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY')),0)) -1,l_date_format)

1474:
1475: /* NPE Changes -- Shifted this code to the above in this code l_date_format := icx_sec.getID(icx_sec.PV_DATE_FORMAT);*/
1476:
1477: SELECT
1478: TO_CHAR(NEXT_DAY(l_default_date, NVL(TO_NUMBER(FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY')),0)) -1,l_date_format)
1479: INTO x_def_period_name
1480: FROM sys.dual;
1481:
1482: /** Bug 2387429 and 2091182 Code Fix Ends **/