APPS.PA_PROJECT_DATES_PVT dependencies on FND_GLOBAL

Line 251: last_updated_by = fnd_global.user_id,

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,
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

Line 252: last_update_login = fnd_global.login_id

248: completion_date = l_finish_date,
249: last_update_date = sysdate,
250: record_version_number = p_record_version_number + 1,
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,

Line 260: last_updated_by = fnd_global.user_id,

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,
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

Line 261: last_update_login = fnd_global.login_id

257: target_finish_date = l_finish_date,
258: last_update_date = sysdate,
259: record_version_number = p_record_version_number + 1,
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,

Line 270: last_updated_by = fnd_global.user_id,

266: actual_finish_date = l_finish_date,
267: actual_duration = l_duration,
268: last_update_date = sysdate,
269: record_version_number = p_record_version_number + 1,
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

Line 271: last_update_login = fnd_global.login_id

267: actual_duration = l_duration,
268: last_update_date = sysdate,
269: record_version_number = p_record_version_number + 1,
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,

Line 281: last_updated_by = fnd_global.user_id,

277: baseline_duration = l_duration,
278: baseline_as_of_date = sysdate,
279: last_update_date = sysdate,
280: record_version_number = p_record_version_number + 1,
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

Line 282: last_update_login = fnd_global.login_id

278: baseline_as_of_date = sysdate,
279: last_update_date = sysdate,
280: record_version_number = p_record_version_number + 1,
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,

Line 292: last_updated_by = fnd_global.user_id,

288: scheduled_duration = l_duration,
289: scheduled_as_of_date = sysdate,
290: last_update_date = sysdate,
291: record_version_number = p_record_version_number + 1,
292: last_updated_by = fnd_global.user_id,
293: last_update_login = fnd_global.login_id
294: WHERE project_id = p_project_id;
295: end if;
296: end if;

Line 293: last_update_login = fnd_global.login_id

289: scheduled_as_of_date = sysdate,
290: last_update_date = sysdate,
291: record_version_number = p_record_version_number + 1,
292: last_updated_by = fnd_global.user_id,
293: last_update_login = fnd_global.login_id
294: WHERE project_id = p_project_id;
295: end if;
296: end if;
297: