[Home] [Help]
171: -- Added for bug 3583748
172: select project_type_class_code
173: into l_project_type_class
174: from pa_project_types_all ppt
175: ,pa_projects_all ppa
176: where ppt.project_type = ppa.project_type
177: and ppt.org_id = ppa.org_id /* added for Bug 5099516*/ -- Removed NVL for bug#5908179 by vvjoshi
178: and project_id = p_project_id;
179:
293:
294: -- For closed projects set the project status to fully purged or partially purged
295: -- For active projects set the project status code to old project status code
296:
297: pa_debug.debug('--Before update of pa_projects_all batch id :
298: '|| p_batch_id || ' project id : '|| p_project_id);
299:
300:
301: l_project_status_code := pa_purge.get_post_purge_status(p_project_id,p_batch_id);
299:
300:
301: l_project_status_code := pa_purge.get_post_purge_status(p_project_id,p_batch_id);
302:
303: update pa_projects_all
304: set project_status_code = l_project_status_code
305: where project_id = p_project_id;
306: commit;
307: pa_debug.debug('--After update of pa_projects_all batch id :
303: update pa_projects_all
304: set project_status_code = l_project_status_code
305: where project_id = p_project_id;
306: commit;
307: pa_debug.debug('--After update of pa_projects_all batch id :
308: '|| p_batch_id || ' project id : '|| p_project_id);
309:
310: X_err_stack := l_old_err_stack;
311:
822: -- traeting this as it has been purged for capital data completely.
823:
824: Select pt.project_type_class_code
825: into l_project_type_class_code
826: From pa_projects_all p, pa_project_types_all pt
827: where p.project_type = pt.project_type
828: and p.org_id = pt.org_id -- Removed NVL for bug#5908179 by vvjoshi
829: and p.project_id = p_project_id;
830: