APPS.PA_PROJECT_DATES_PVT dependencies on PA_PROJECTS_ALL

Line 68: from pa_projects_all

64: l_res_max_date DATE;
65:
66: CURSOR get_cal_id IS
67: select calendar_id
68: from pa_projects_all
69: where project_id = p_project_id;
70:
71: BEGIN
72: if (p_debug_mode = 'Y') then

Line 83: FROM pa_projects_all

79:
80: if p_validate_only <> FND_API.G_TRUE then
81: BEGIN
82: SELECT 'x' INTO l_dummy
83: FROM pa_projects_all
84: WHERE project_id = p_project_id
85: AND record_version_number = p_record_version_number
86: FOR UPDATE OF record_version_number NOWAIT;
87: EXCEPTION

Line 114: FROM pa_projects_all

110: END;
111: else
112: BEGIN
113: SELECT 'x' INTO l_dummy
114: FROM pa_projects_all
115: WHERE project_id = p_project_id
116: AND record_version_number = p_record_version_number;
117: EXCEPTION
118: when NO_DATA_FOUND then

Line 246: UPDATE PA_PROJECTS_ALL

242:
243: End if; -- PA_VALIDATE_ASSIGN_DATES='Y' and version_enabled='Y'
244: /*Bug 6860603 End*/
245:
246: UPDATE PA_PROJECTS_ALL
247: SET start_date = l_start_date,
248: completion_date = l_finish_date,
249: last_update_date = sysdate,
250: record_version_number = p_record_version_number + 1,

Line 255: UPDATE PA_PROJECTS_ALL

251: last_updated_by = fnd_global.user_id,
252: last_update_login = fnd_global.login_id
253: WHERE project_id = p_project_id;
254: elsif p_date_type = 'TARGET' then
255: UPDATE PA_PROJECTS_ALL
256: SET target_start_date = l_start_date,
257: target_finish_date = l_finish_date,
258: last_update_date = sysdate,
259: record_version_number = p_record_version_number + 1,

Line 264: UPDATE PA_PROJECTS_ALL

260: last_updated_by = fnd_global.user_id,
261: last_update_login = fnd_global.login_id
262: WHERE project_id = p_project_id;
263: elsif p_date_type = 'ACTUAL' then
264: UPDATE PA_PROJECTS_ALL
265: SET actual_start_date = l_start_date,
266: actual_finish_date = l_finish_date,
267: actual_duration = l_duration,
268: last_update_date = sysdate,

Line 274: UPDATE PA_PROJECTS_ALL

270: last_updated_by = fnd_global.user_id,
271: last_update_login = fnd_global.login_id
272: WHERE project_id = p_project_id;
273: elsif p_date_type = 'BASELINE' then
274: UPDATE PA_PROJECTS_ALL
275: SET baseline_start_date = l_start_date,
276: baseline_finish_date = l_finish_date,
277: baseline_duration = l_duration,
278: baseline_as_of_date = sysdate,

Line 285: UPDATE PA_PROJECTS_ALL

281: last_updated_by = fnd_global.user_id,
282: last_update_login = fnd_global.login_id
283: WHERE project_id = p_project_id;
284: elsif p_date_type = 'SCHEDULED' then
285: UPDATE PA_PROJECTS_ALL
286: SET scheduled_start_date = l_start_date,
287: scheduled_finish_date = l_finish_date,
288: scheduled_duration = l_duration,
289: scheduled_as_of_date = sysdate,