DBA Data[Home] [Help]

APPS.PA_PURGE_VALIDATE dependencies on PA_PROJECTS_ALL

Line 98: l_project_status_code pa_projects_all.project_status_code%type;

94: l_error_msg VARCHAR2(30);
95: l_error_code NUMBER := 0;
96: /* Added l_project_type_class_code ,l_project_status_code for bug 2715317 */
97: l_project_type_class_code pa_project_types_all.project_type_class_code%type;
98: l_project_status_code pa_projects_all.project_status_code%type;
99: /* Bug#2416385 Added the variable l_purge_project_status_code for Phase -III Archive and Purge */
100: l_purge_project_status_code pa_purge_projects.purge_project_status_code%TYPE;
101: l_warnings_only_flag VARCHAR2(1) := 'N'; --bug3134205
102: BEGIN

Line 312: update pa_projects_all p

308:
309: if ( (l_purge_project_status_code <> c_prj_in_batch.purge_project_status_code) and
310: (l_purge_project_status_code = 'I') ) then
311:
312: update pa_projects_all p
313: set p.project_status_code = c_prj_in_batch.last_project_status_code,
314: p.last_update_date = sysdate,
315: p.last_updated_by = -1,
316: p.last_update_login = -1

Line 431: /* Bug#2416385 Modified the pa_projects to pa_projects_all for Phase -III Archive and Purge */

427: pp.program_update_date = sysdate
428: where pp.project_id = p_project_id
429: and pp.purge_batch_id = p_purge_batch_id ;
430:
431: /* Bug#2416385 Modified the pa_projects to pa_projects_all for Phase -III Archive and Purge */
432: update pa_projects_all p
433: set p.project_status_code = 'PENDING_PURGE',
434: p.last_update_date = sysdate,
435: p.last_updated_by = -1,

Line 432: update pa_projects_all p

428: where pp.project_id = p_project_id
429: and pp.purge_batch_id = p_purge_batch_id ;
430:
431: /* Bug#2416385 Modified the pa_projects to pa_projects_all for Phase -III Archive and Purge */
432: update pa_projects_all p
433: set p.project_status_code = 'PENDING_PURGE',
434: p.last_update_date = sysdate,
435: p.last_updated_by = -1,
436: p.last_update_login = -1