DBA Data[Home] [Help]

APPS.PA_ASSIGNMENT_UTILS dependencies on FND_PROFILE

Line 190: x_starting_oa_status := fnd_profile.value ('DEF_OA_STARTING_STATUS');

186: x_error_message_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
187:
188: BEGIN
189: pa_debug.init_err_stack ('pa_assignment_utils.Get_Def_Asgmt_Statuses');
190: x_starting_oa_status := fnd_profile.value ('DEF_OA_STARTING_STATUS');
191: x_starting_sa_status := fnd_profile.value ('DEF_SA_STARTING_STATUS');
192: x_starting_fa_status := fnd_profile.value ('DEF_FA_STATUS');
193: -- While it is ok for the other two statuses to be not defined,
194: -- an installation must always have a default filled status defined

Line 191: x_starting_sa_status := fnd_profile.value ('DEF_SA_STARTING_STATUS');

187:
188: BEGIN
189: pa_debug.init_err_stack ('pa_assignment_utils.Get_Def_Asgmt_Statuses');
190: x_starting_oa_status := fnd_profile.value ('DEF_OA_STARTING_STATUS');
191: x_starting_sa_status := fnd_profile.value ('DEF_SA_STARTING_STATUS');
192: x_starting_fa_status := fnd_profile.value ('DEF_FA_STATUS');
193: -- While it is ok for the other two statuses to be not defined,
194: -- an installation must always have a default filled status defined
195: -- in order for the assignments to be marked as filled whenever

Line 192: x_starting_fa_status := fnd_profile.value ('DEF_FA_STATUS');

188: BEGIN
189: pa_debug.init_err_stack ('pa_assignment_utils.Get_Def_Asgmt_Statuses');
190: x_starting_oa_status := fnd_profile.value ('DEF_OA_STARTING_STATUS');
191: x_starting_sa_status := fnd_profile.value ('DEF_SA_STARTING_STATUS');
192: x_starting_fa_status := fnd_profile.value ('DEF_FA_STATUS');
193: -- While it is ok for the other two statuses to be not defined,
194: -- an installation must always have a default filled status defined
195: -- in order for the assignments to be marked as filled whenever
196: -- an open assignment is filled with a resource

Line 1346: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); -- 5345129

1342: and project_id = p_project_id
1343: and rownum = 1;
1344:
1345: l_team_role_exists VARCHAR2(1):= 'F';
1346: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); -- 5345129
1347:
1348: BEGIN
1349: IF l_debug_mode = 'Y' THEN -- 5345129
1350: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENT_UTILS.Associate_Planning_Resources'