DBA Data[Home] [Help]

APPS.PA_PROJECTS_MAINT_PVT dependencies on PA_PROJECT_STUS_UTILS

Line 5222: IF Pa_project_stus_utils.is_project_status_closed

5218: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5219: p_msg_name => 'PA_PROJECT_STATUS_INVALID');
5220: END IF;
5221: -- special case for update to and from 'CLOSED'
5222: IF Pa_project_stus_utils.is_project_status_closed
5223: (p_project_status_code) = 'Y' THEN
5224: l_closing_project := 'Y';
5225: l_project_status_changed := 'Y';
5226:

Line 5233: ELSIF Pa_project_stus_utils.is_project_status_closed

5229: UPDATE pa_projects_all -- Bug#3807805 : Modifed pa_projects to pa_projects_all
5230: SET closed_date = trunc(sysdate)
5231: WHERE project_id = p_project_id;
5232: -- anlee end of changes
5233: ELSIF Pa_project_stus_utils.is_project_status_closed
5234: (l_project_old_rec.project_status_code) = 'Y' THEN
5235: l_reopening_project := 'Y';
5236: l_project_status_changed := 'Y';
5237: ELSE

Line 5252: x_status_changeable := PA_Project_Stus_Utils.allow_status_change

5248: THEN
5249: IF p_project_status_code <>
5250: l_project_old_rec.project_status_code
5251: THEN
5252: x_status_changeable := PA_Project_Stus_Utils.allow_status_change
5253: (l_project_old_rec.project_status_code,
5254: p_project_status_code);
5255:
5256: IF (x_status_changeable = 'N')

Line 5265: Pa_project_stus_utils.Handle_Project_Status_Change

5261: END IF;
5262: END IF;
5263:
5264: IF l_project_status_changed = 'Y' THEN
5265: Pa_project_stus_utils.Handle_Project_Status_Change
5266: (x_calling_module => 'UPDATE_PROJECT'
5267: ,X_project_id => l_project_old_rec.project_id
5268: ,X_old_proj_status_code => l_project_old_rec.project_status_code
5269: ,X_new_proj_status_code => p_project_status_code