DBA Data[Home] [Help]

APPS.PA_PROJECTS_MAINT_PVT dependencies on PA_PROJECT_STUS_UTILS

Line 5224: IF Pa_project_stus_utils.is_project_status_closed

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

Line 5235: ELSIF Pa_project_stus_utils.is_project_status_closed

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

Line 5254: x_status_changeable := PA_Project_Stus_Utils.allow_status_change

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

Line 5267: Pa_project_stus_utils.Handle_Project_Status_Change

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