APPS.PA_FCST_GLOBAL dependencies on FND_PROFILE

Line 127: /* select fnd_profile.value('PA_FORECASTING_PERIOD_TYPE')

123:
124: /* NPE Changes Begin - Added displaying error messages for missing period type profile*/
125:
126: -- Not needed as the value is alreday coming from pa_fcst_global.Global_period_type
127: /* select fnd_profile.value('PA_FORECASTING_PERIOD_TYPE')
128: into l_period_type
129: from dual; */
130:
131:

Line 136: FROM fnd_profile_options_tl

132: If l_period_type is null THEN
133: x_return_status := FND_API.G_RET_STS_ERROR;
134:
135: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name1
136: FROM fnd_profile_options_tl
137: WHERE profile_option_name='PA_FORECASTING_PERIOD_TYPE'
138: AND language=userenv('LANG');
139:
140: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

Line 207: l_default_calendar := FND_PROFILE.VALUE('PA_PRM_DEFAULT_CALENDAR');

203:
204: WHEN NO_DATA_FOUND THEN
205:
206: x_return_status := FND_API.G_RET_STS_ERROR;
207: l_default_calendar := FND_PROFILE.VALUE('PA_PRM_DEFAULT_CALENDAR');
208: select count(*) into org_count from pa_implementations;
209:
210: IF l_default_calendar is null THEN
211: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name2

Line 212: FROM fnd_profile_options_tl

208: select count(*) into org_count from pa_implementations;
209:
210: IF l_default_calendar is null THEN
211: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name2
212: FROM fnd_profile_options_tl
213: WHERE profile_option_name='PA_PRM_DEFAULT_CALENDAR'
214: AND language=userenv('LANG');
215:
216: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

Line 369: select fnd_profile.value('PA_FORECASTING_PERIOD_TYPE')

365: l_period_type := pa_fcst_global.global_period_type;
366:
367: /* NPE Changes Begin - Added displaying error messages for missing period type profile*/
368: /*
369: select fnd_profile.value('PA_FORECASTING_PERIOD_TYPE')
370: into l_period_type
371: from dual;
372: */
373: If l_period_type is null THEN

Line 377: FROM fnd_profile_options_tl

373: If l_period_type is null THEN
374: x_return_status := FND_API.G_RET_STS_ERROR;
375:
376: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name1
377: FROM fnd_profile_options_tl
378: WHERE profile_option_name='PA_FORECASTING_PERIOD_TYPE'
379: AND language=userenv('LANG');
380:
381: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

Line 438: l_default_calendar := FND_PROFILE.VALUE('PA_PRM_DEFAULT_CALENDAR');

434:
435: WHEN NO_DATA_FOUND THEN
436:
437: x_return_status := FND_API.G_RET_STS_ERROR;
438: l_default_calendar := FND_PROFILE.VALUE('PA_PRM_DEFAULT_CALENDAR');
439: select count(*) into org_count from pa_implementations;
440:
441: IF l_default_calendar is null THEN
442: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name2

Line 443: FROM fnd_profile_options_tl

439: select count(*) into org_count from pa_implementations;
440:
441: IF l_default_calendar is null THEN
442: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name2
443: FROM fnd_profile_options_tl
444: WHERE profile_option_name='PA_PRM_DEFAULT_CALENDAR'
445: AND language=userenv('LANG');
446:
447: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

Line 1157: IF fnd_profile.value_specific('PA_SUPER_PROJECT',l_user_id,

1153: l_person_id := pa_utils.GetEmpIdFromUser( l_user_id );
1154: l_resp_id := fnd_global.resp_id;
1155: l_resp_appl_id := fnd_global.resp_appl_id;
1156:
1157: IF fnd_profile.value_specific('PA_SUPER_PROJECT',l_user_id,
1158: l_resp_id, l_resp_appl_id) = 'Y' THEN
1159: l_cross_view_user := 'Y';
1160: ELSE
1161: l_cross_view_user := 'N';

Line 1166: IF fnd_profile.value_specific('PA_SUPER_PROJECT_VIEW',l_user_id,

1162: END IF;
1163:
1164: IF l_cross_view_user = 'N' THEN
1165:
1166: IF fnd_profile.value_specific('PA_SUPER_PROJECT_VIEW',l_user_id,
1167: l_resp_id, l_resp_appl_id) = 'Y' THEN
1168: l_cross_view_user := 'Y';
1169: END IF;
1170: END IF;

Line 1183: l_period_type VARCHAR2(2):= FND_PROFILE.VALUE('PA_FORECASTING_PERIOD_TYPE');

1179: END IsCrossProjectViewUser;
1180:
1181: Procedure Populate_Fcst_Periods IS
1182:
1183: l_period_type VARCHAR2(2):= FND_PROFILE.VALUE('PA_FORECASTING_PERIOD_TYPE');
1184:
1185: BEGIN
1186: BEGIN
1187: DELETE pa_fcst_periods_tmp;