APPS.PA_PURGE_VALIDATE dependencies on PA_PROJECTS

Line 74: pa_projects p, Commented for bug 2715317 */

70: pp.purge_actuals_flag,
71: pp.purge_budgets_flag,
72: pp.txn_to_date
73: /* from pa_project_types pt,
74: pa_projects p, Commented for bug 2715317 */
75: from pa_purge_projects pp
76: where pp.purge_batch_id = p_purge_batch_id
77: /* and p.project_type = pt.project_type
78: and nvl(pt.org_id, -99) = nvl(p.org_id, -99)

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 144: pa_projects p

140: p.project_status_code
141: into l_project_type_class_code,
142: l_project_status_code
143: from pa_project_types pt,
144: pa_projects p
145: where p.project_type = pt.project_type
146: and p.project_id = l_GetProjectsInBatch_csr.project_id;
147: /* Bug 2715317 ends */
148:

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 417: -- PA_PROJECTS to 'PENDING_PURGE'.

413:
414: -- This means there are no errors for this validation run. So delete
415: -- all the errors from the previous run if exists and update the
416: -- project to Valid. Also update the status of the project in
417: -- PA_PROJECTS to 'PENDING_PURGE'.
418:
419: pa_debug.debug('Updating purge_project_status_code to valid for project '||to_char(p_project_id)) ;
420: X_err_stage := 'No errors . Updating purge_project_status_code to valid for project '||to_char(p_project_id) ;
421:

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