APPS.PA_DELETE_ACCUM_RECS dependencies on PA_PROJECT_ACCUM_HEADERS

Line 71: from PA_PROJECT_ACCUM_HEADERS PAH

67:
68: Delete From PA_PROJECT_ACCUM_COMMITMENTS PAC
69: Where PAC.Project_Accum_id IN
70: (Select Project_Accum_id
71: from PA_PROJECT_ACCUM_HEADERS PAH
72: Where PAH.Project_Id = x_project_id
73: and PAH.project_accum_id <> l_Prj_Lvl_Accum_Id -- Skip project-level record
74: )
75: AND rownum <= pa_proj_accum_main.x_commit_size;

Line 308: from PA_PROJECT_ACCUM_HEADERS PAH

304: Delete From PA_PROJECT_ACCUM_BUDGETS
305: Where Budget_Type_Code = Budget_ver_rec.budget_type_code
306: and Project_Accum_id IN
307: (Select Project_Accum_id
308: from PA_PROJECT_ACCUM_HEADERS PAH
309: Where PAH.Project_Id = x_project_id
310: and PAH.project_accum_id <> l_Prj_Lvl_Accum_Id -- Skip project-level records
311: );
312:

Line 384: from PA_PROJECT_ACCUM_HEADERS PAH

380: Delete From PA_PROJECT_ACCUM_BUDGETS
381: Where Budget_Type_Code = Budget_ver_rec.budget_type_code
382: and Project_Accum_id IN
383: (Select Project_Accum_id
384: from PA_PROJECT_ACCUM_HEADERS PAH
385: Where PAH.Project_Id = x_project_id
386: );
387:
388:

Line 476: from PA_PROJECT_ACCUM_HEADERS PAH

472:
473: Delete From PA_PROJECT_ACCUM_ACTUALS PAA
474: Where PAA.Project_Accum_id IN
475: (Select Project_Accum_id
476: from PA_PROJECT_ACCUM_HEADERS PAH
477: Where PAH.Project_Id = x_project_id
478: and PAH.project_accum_id <> l_Prj_Lvl_Accum_Id -- Skip project-level records
479: )
480: AND rownum <= pa_proj_accum_main.x_commit_size;

Line 584: (Select Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH Where

580: Loop
581:
582: Delete From PA_PROJECT_ACCUM_ACTUALS PAA
583: Where Project_Accum_id IN
584: (Select Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH Where
585: PAH.Project_Id = x_project_id and
586: PAH.resource_list_member_id <> 0 and
587: PAH.Resource_List_id = NVL(x_Resource_list_id,PAH.Resource_List_id))
588: and rownum <= pa_proj_accum_main.x_commit_size;

Line 644: (Select Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH Where

640: Loop
641:
642: Delete From PA_PROJECT_ACCUM_COMMITMENTS PAC
643: Where Project_Accum_id IN
644: (Select Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH Where
645: PAH.Project_Id = x_project_id and
646: PAH.resource_list_member_id <> 0 and
647: PAH.Resource_List_id = NVL(x_Resource_list_id,PAH.Resource_List_id))
648: and rownum <= pa_proj_accum_main.x_commit_size;

Line 673: -- This procedure deletes records from PA_PROJECT_ACCUM_HEADERS if there

669: x_err_code := SQLCODE;
670: RAISE;
671: End Delete_Res_List_Commitments;
672:
673: -- This procedure deletes records from PA_PROJECT_ACCUM_HEADERS if there
674: -- are NO corresponding records in ACTUALS,COMMITMENTS and BUDGETS tables
675: -- for the given project.
676: --
677: --

Line 717: x_err_stage := 'deleting PA_PROJECT_ACCUM_HEADERS';

713: V_Old_Stack := x_err_stack;
714: x_err_stack :=
715: x_err_stack ||'->PA_DELETE_ACCUM_RECS.Delete_Project_Accum_Headers';
716: x_err_code := 0;
717: x_err_stage := 'deleting PA_PROJECT_ACCUM_HEADERS';
718: tot_recs_processed := 0;
719:
720: pa_debug.debug(x_err_stack);
721:

Line 736: Delete From PA_PROJECT_ACCUM_HEADERS PAH Where

732:
733: Loop
734:
735:
736: Delete From PA_PROJECT_ACCUM_HEADERS PAH Where
737: PAH.Project_Id = x_project_id
738: AND PAH.project_accum_id <> l_Prj_Lvl_Accum_Id -- Don't delete project-level row details.
739: AND Not Exists
740: (Select 'Yes' from PA_PROJECT_ACCUM_ACTUALS PAA

Line 798: l_Prj_Lvl_Accum_Id pa_project_accum_headers.project_accum_id%TYPE := NULL;

794: ) IS
795:
796:
797:
798: l_Prj_Lvl_Accum_Id pa_project_accum_headers.project_accum_id%TYPE := NULL;
799:
800:
801: BEGIN
802:

Line 819: FROM pa_project_accum_headers

815: -- FETCH New Project-Level Project_Accum_Id
816:
817: SELECT project_accum_id
818: INTO l_Prj_Lvl_Accum_Id
819: FROM pa_project_accum_headers
820: WHERE project_id = p_project_id
821: AND task_id = 0
822: AND resource_list_member_id = 0;
823: