APPS.PA_PURGE_VALIDATE dependencies on PA_PURGE_PROJECTS

Line 75: from pa_purge_projects pp

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)
79: and pp.project_id = p.project_id Commented for bug 2715317 */

Line 85: from pa_purge_projects pp

81:
82: /* bug 4255353 starts here*/
83: cursor Getpurge_summaryflag(p_project_id IN NUMBER) is
84: select pp.purge_summary_flag
85: from pa_purge_projects pp
86: where pp.purge_batch_id = p_purge_batch_id
87: and pp.project_id=p_project_id;
88:
89: l_GetProjectsInBatch_csr GetProjectsInBatch%rowtype;

Line 100: l_purge_project_status_code pa_purge_projects.purge_project_status_code%TYPE;

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
103: Open GetBatchDet ;
104: Fetch GetBatchDet into l_GetBatchDet_csr ;

Line 305: from pa_purge_projects

301: x_Err_Code => l_err_code );
302:
303: select purge_project_status_code
304: into l_purge_project_status_code
305: from pa_purge_projects
306: where project_id = c_prj_in_batch.project_id
307: and purge_batch_id = p_purge_batch_id ;
308:
309: if ( (l_purge_project_status_code <> c_prj_in_batch.purge_project_status_code) and

Line 422: update pa_purge_projects pp

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:
422: update pa_purge_projects pp
423: set pp.purge_project_status_code = 'V',
424: pp.request_id = pa_purge_validate.g_request_id,
425: pp.program_application_id = pa_purge_validate.g_program_application_id,
426: pp.program_id = pa_purge_validate.g_program_id ,

Line 494: update pa_purge_projects pp

490: END LOOP ;
491:
492: pa_debug.debug('Updating purge_project_status_code to invalid for project '||to_char(p_project_id));
493: X_err_stage := 'Updating purge_project_status_code to invalid for project '||to_char(p_project_id) ;
494: update pa_purge_projects pp
495: set pp.purge_project_status_code = 'I',
496: pp.request_id = pa_purge_validate.g_request_id,
497: pp.program_application_id = pa_purge_validate.g_program_application_id,
498: pp.program_id = pa_purge_validate.g_program_id ,