APPS.PA_PURGE dependencies on PA_PURGE_PROJECTS

Line 273: pa_debug.debug('--Before update of pa_purge_projects batch id :

269: X_Err_Code => X_Err_Code);
270:
271:
272: -- Set completed status for the project
273: pa_debug.debug('--Before update of pa_purge_projects batch id :
274: '|| p_batch_id || ' project id : '|| p_project_id);
275:
276: update pa_purge_projects
277: set

Line 276: update pa_purge_projects

272: -- Set completed status for the project
273: pa_debug.debug('--Before update of pa_purge_projects batch id :
274: '|| p_batch_id || ' project id : '|| p_project_id);
275:
276: update pa_purge_projects
277: set
278: purged_date=sysdate
279: ,last_update_date=sysdate
280: ,last_updated_by=fnd_global.user_id

Line 291: pa_debug.debug('--After update of pa_purge_projects batch id :

287: and project_id = p_project_id;
288:
289: commit;
290:
291: pa_debug.debug('--After update of pa_purge_projects batch id :
292: '|| p_batch_id || ' project id : '|| p_project_id);
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

Line 427: From pa_purge_projects

423: txn_to_date,
424: last_project_status_code,
425: next_pp_project_status_code,
426: next_p_project_status_code
427: From pa_purge_projects
428: Where purge_batch_id = p_Batch_Id
429: And purged_date is NULL
430: Order By project_id
431: )

Line 769: l_last_project_status_code pa_purge_projects.Last_project_status_code%TYPE;

765:
766: /* Changed the data length of l_next_p_project_status_code and l_next_pp_project_status_code to 90 for UTF8.
767: l_last_project_status_code VARCHAR2(30);
768: */
769: l_last_project_status_code pa_purge_projects.Last_project_status_code%TYPE;
770: l_project_type_class_code VARCHAR2(30);
771:
772:
773: CURSOR next_p_pp_status IS

Line 775: FROM pa_purge_projects

771:
772:
773: CURSOR next_p_pp_status IS
774: SELECT next_p_project_status_code, next_pp_project_status_code
775: FROM pa_purge_projects
776: WHERE purge_batch_id = p_batch_id
777: AND project_id = p_project_id;
778:
779: /* Changed the data length of l_next_p_project_status_code and l_next_pp_project_status_code to 90 for UTF8.

Line 784: l_next_p_project_status_code pa_purge_projects.next_p_project_status_code%TYPE;

780: l_next_p_project_status_code VARCHAR2(30);
781: l_next_pp_project_status_code VARCHAR2(30);
782: */
783:
784: l_next_p_project_status_code pa_purge_projects.next_p_project_status_code%TYPE;
785: l_next_pp_project_status_code pa_purge_projects.next_pp_project_status_code%TYPE;
786:
787: BEGIN
788:

Line 785: l_next_pp_project_status_code pa_purge_projects.next_pp_project_status_code%TYPE;

781: l_next_pp_project_status_code VARCHAR2(30);
782: */
783:
784: l_next_p_project_status_code pa_purge_projects.next_p_project_status_code%TYPE;
785: l_next_pp_project_status_code pa_purge_projects.next_pp_project_status_code%TYPE;
786:
787: BEGIN
788:
789: pa_debug.debug(' In function get_post_purge_status ');

Line 810: From pa_purge_projects

806: Into l_purge_actuals_flag,
807: l_purge_capital_flag,
808: l_purge_budgets_flag,
809: l_purge_summary_flag
810: From pa_purge_projects
811: Where project_id = p_project_id
812: And purged_date is not null;
813:
814: OPEN next_p_pp_status;

Line 819: -- Here if the Project is not a Capital Project then "purge_capital_flag" On pa_purge_projects

815: FETCH next_p_pp_status into l_next_p_project_status_code,
816: l_next_pp_project_status_code;
817: CLOSE next_p_pp_status;
818:
819: -- Here if the Project is not a Capital Project then "purge_capital_flag" On pa_purge_projects
820: -- Will not be Y and will return the status as 'PARTIALLY PURGED' as there is no question
821: -- of purging any capital data for non capital project. So is project is NON CAPITAL then
822: -- traeting this as it has been purged for capital data completely.
823:

Line 850: From pa_purge_projects

846: End if;
847: ELSE
848: Select LAST_PROJECT_STATUS_CODE
849: Into l_last_project_status_code
850: From pa_purge_projects
851: Where project_id = p_project_id
852: And purge_batch_id = p_batch_id;
853:
854: Return (l_last_project_status_code);