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_REPORT_UTIL dependencies on FND_PROFILE

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

164: END IF;
165:
166:
167: -- Populating default period type using profile options
168: l_period_type := FND_PROFILE.VALUE('PA_ORG_UTIL_DEF_PERIOD_TYPE');
169:
170: /* NPE Changes Begin */
171: -- Populating default period percentage using profile options
172: l_def_show_percentages_by := FND_PROFILE.VALUE('PA_ORG_UTIL_DEF_CALC_METHOD');

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

168: l_period_type := FND_PROFILE.VALUE('PA_ORG_UTIL_DEF_PERIOD_TYPE');
169:
170: /* NPE Changes Begin */
171: -- Populating default period percentage using profile options
172: l_def_show_percentages_by := FND_PROFILE.VALUE('PA_ORG_UTIL_DEF_CALC_METHOD');
173:
174: l_global_week_start_day := FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY');
175:
176: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name1

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

170: /* NPE Changes Begin */
171: -- Populating default period percentage using profile options
172: l_def_show_percentages_by := FND_PROFILE.VALUE('PA_ORG_UTIL_DEF_CALC_METHOD');
173:
174: l_global_week_start_day := FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY');
175:
176: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name1
177: FROM fnd_profile_options_tl
178: WHERE profile_option_name='PA_ORG_UTIL_DEF_CALC_METHOD'

Line 177: FROM fnd_profile_options_tl

173:
174: l_global_week_start_day := FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY');
175:
176: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name1
177: FROM fnd_profile_options_tl
178: WHERE profile_option_name='PA_ORG_UTIL_DEF_CALC_METHOD'
179: AND language=userenv('LANG');
180:
181: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name2

Line 182: FROM fnd_profile_options_tl

178: WHERE profile_option_name='PA_ORG_UTIL_DEF_CALC_METHOD'
179: AND language=userenv('LANG');
180:
181: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name2
182: FROM fnd_profile_options_tl
183: WHERE profile_option_name='PA_ORG_UTIL_DEF_PERIOD_TYPE'
184: AND language=userenv('LANG');
185:
186: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name3

Line 187: FROM fnd_profile_options_tl

183: WHERE profile_option_name='PA_ORG_UTIL_DEF_PERIOD_TYPE'
184: AND language=userenv('LANG');
185:
186: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name3
187: FROM fnd_profile_options_tl
188: WHERE profile_option_name='PA_GLOBAL_WEEK_START_DAY'
189: AND language=userenv('LANG');
190:
191:

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

459: /** Fix for bug 2387429 and 2091182 starts here **/
460: /* -- NPE Changes, it is shifted to above in the code l_date_format := icx_sec.getID(icx_sec.PV_DATE_FORMAT); */
461:
462: SELECT
463: TO_CHAR(NEXT_DAY(l_default_date, NVL(TO_NUMBER(FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY')),0)) -1,l_date_format)
464: INTO x_def_period_name
465: FROM sys.dual;
466: /*
467: SELECT

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

464: INTO x_def_period_name
465: FROM sys.dual;
466: /*
467: SELECT
468: TO_CHAR( NEXT_DAY(l_default_date, NVL( TO_NUMBER(FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY')),0)) -1, 'DD-MON-YYYY')
469: INTO x_def_period_name
470: FROM sys.dual;
471: */
472: /** Bug 2387429 and 2091182 Code Fix Ends **/

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

1116: END;
1117: /* Bug2440313 End */
1118:
1119: -- Populating default period type using profile options
1120: l_period_type := FND_PROFILE.VALUE_SPECIFIC('PA_RES_UTIL_DEF_PERIOD_TYPE');
1121:
1122: /* NPE Changes Begins */
1123:
1124: l_def_show_percentages_by := FND_PROFILE.VALUE('PA_RES_UTIL_DEF_CALC_METHOD');

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

1120: l_period_type := FND_PROFILE.VALUE_SPECIFIC('PA_RES_UTIL_DEF_PERIOD_TYPE');
1121:
1122: /* NPE Changes Begins */
1123:
1124: l_def_show_percentages_by := FND_PROFILE.VALUE('PA_RES_UTIL_DEF_CALC_METHOD');
1125: l_global_week_start_day := FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY');
1126:
1127: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name1
1128: FROM fnd_profile_options_tl

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

1121:
1122: /* NPE Changes Begins */
1123:
1124: l_def_show_percentages_by := FND_PROFILE.VALUE('PA_RES_UTIL_DEF_CALC_METHOD');
1125: l_global_week_start_day := FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY');
1126:
1127: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name1
1128: FROM fnd_profile_options_tl
1129: WHERE profile_option_name='PA_RES_UTIL_DEF_CALC_METHOD'

Line 1128: FROM fnd_profile_options_tl

1124: l_def_show_percentages_by := FND_PROFILE.VALUE('PA_RES_UTIL_DEF_CALC_METHOD');
1125: l_global_week_start_day := FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY');
1126:
1127: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name1
1128: FROM fnd_profile_options_tl
1129: WHERE profile_option_name='PA_RES_UTIL_DEF_CALC_METHOD'
1130: AND language=userenv('LANG');
1131:
1132: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name2

Line 1133: FROM fnd_profile_options_tl

1129: WHERE profile_option_name='PA_RES_UTIL_DEF_CALC_METHOD'
1130: AND language=userenv('LANG');
1131:
1132: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name2
1133: FROM fnd_profile_options_tl
1134: WHERE profile_option_name='PA_RES_UTIL_DEF_PERIOD_TYPE'
1135: AND language=userenv('LANG');
1136:
1137: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name3

Line 1138: FROM fnd_profile_options_tl

1134: WHERE profile_option_name='PA_RES_UTIL_DEF_PERIOD_TYPE'
1135: AND language=userenv('LANG');
1136:
1137: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name3
1138: FROM fnd_profile_options_tl
1139: WHERE profile_option_name='PA_GLOBAL_WEEK_START_DAY'
1140: AND language=userenv('LANG');
1141:
1142:

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

1418: -- Populating period name
1419: /** Bug 2387429 and 2091182 Code Fix Starts **/
1420: /*
1421: SELECT
1422: TO_CHAR(NEXT_DAY(l_default_date, NVL(TO_NUMBER(FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY')),0)) -1,'DD-MON-YYYY')
1423: INTO x_def_period_name
1424: FROM sys.dual;
1425: */
1426:

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

1426:
1427: /* NPE Changes -- Shifted this code to the above in this code l_date_format := icx_sec.getID(icx_sec.PV_DATE_FORMAT);*/
1428:
1429: SELECT
1430: TO_CHAR(NEXT_DAY(l_default_date, NVL(TO_NUMBER(FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY')),0)) -1,l_date_format)
1431: INTO x_def_period_name
1432: FROM sys.dual;
1433:
1434: /** Bug 2387429 and 2091182 Code Fix Ends **/