eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_DELETE_ACCUM_RECS dependencies on PA_DELETE_ACCUM_RECS

Line 1: PACKAGE BODY PA_DELETE_ACCUM_RECS AS

1: PACKAGE BODY PA_DELETE_ACCUM_RECS AS
2: /* $Header: PAACDELB.pls 120.2 2005/09/26 15:12:32 jwhite noship $ */
3:
4:
5: -- This procedure deletes records from PA_PROJECT_ACCUM_COMMITMENTS

Line 47: x_err_stack ||'->PA_DELETE_ACCUM_RECS.Delete_Project_Commitments';

43:
44: Begin
45: V_Old_Stack := x_err_stack;
46: x_err_stack :=
47: x_err_stack ||'->PA_DELETE_ACCUM_RECS.Delete_Project_Commitments';
48: x_err_code := 0;
49: x_err_stage := 'Deleting PA_PROJECT_ACCUM_COMMITMENTS';
50: tot_recs_processed := 0;
51:

Line 57: PA_DELETE_ACCUM_RECS.Get_Prj_Lvl_Accum_Id (p_project_id => x_project_Id

53:
54:
55: -- Get the Project-Level Project Accum Id.
56: -- Note: No error processing for this procedure as none expected
57: PA_DELETE_ACCUM_RECS.Get_Prj_Lvl_Accum_Id (p_project_id => x_project_Id
58: , x_Prj_Lvl_Accum_Id => l_Prj_Lvl_Accum_Id
59: , x_msg_count => l_msg_count
60: , x_msg_data => l_msg_data
61: , x_return_status => l_return_status);

Line 273: x_err_stack ||'->PA_DELETE_ACCUM_RECS.Delete_Project_Budgets';

269: Begin
270:
271: V_Old_Stack := x_err_stack;
272: x_err_stack :=
273: x_err_stack ||'->PA_DELETE_ACCUM_RECS.Delete_Project_Budgets';
274: x_err_code := 0;
275: x_err_stage := 'deleteing pa_project_accum_budgets';
276:
277: pa_debug.debug(x_err_stack);

Line 282: PA_DELETE_ACCUM_RECS.Get_Prj_Lvl_Accum_Id (p_project_id => x_project_Id

278:
279:
280: -- Get the Project-Level Project Accum Id.
281: -- Note: No error processing for this procedure as none expected
282: PA_DELETE_ACCUM_RECS.Get_Prj_Lvl_Accum_Id (p_project_id => x_project_Id
283: , x_Prj_Lvl_Accum_Id => l_Prj_Lvl_Accum_Id
284: , x_msg_count => l_msg_count
285: , x_msg_data => l_msg_data
286: , x_return_status => l_return_status);

Line 449: x_err_stack ||'->PA_DELETE_ACCUM_RECS.Delete_Project_Actuals';

445:
446: Begin
447: V_Old_Stack := x_err_stack;
448: x_err_stack :=
449: x_err_stack ||'->PA_DELETE_ACCUM_RECS.Delete_Project_Actuals';
450: x_err_code := 0;
451: x_err_stage := 'deleting PA_PROJECT_ACCUM_ACTUALS';
452: tot_recs_processed := 0;
453:

Line 461: PA_DELETE_ACCUM_RECS.Get_Prj_Lvl_Accum_Id (p_project_id => x_project_Id

457:
458:
459: -- Get the Project-Level Project Accum Id.
460: -- Note: No error processing for this procedure as none expected
461: PA_DELETE_ACCUM_RECS.Get_Prj_Lvl_Accum_Id (p_project_id => x_project_Id
462: , x_Prj_Lvl_Accum_Id => l_Prj_Lvl_Accum_Id
463: , x_msg_count => l_msg_count
464: , x_msg_data => l_msg_data
465: , x_return_status => l_return_status);

Line 574: x_err_stack ||'->PA_DELETE_ACCUM_RECS.Delete_Res_List_Actuals';

570: tot_recs_processed Number;
571: Begin
572: V_Old_Stack := x_err_stack;
573: x_err_stack :=
574: x_err_stack ||'->PA_DELETE_ACCUM_RECS.Delete_Res_List_Actuals';
575: x_err_code := 0;
576: x_err_stage := 'deleteing PA_PROJECT_ACCUM_ACTUALS';
577: tot_recs_processed := 0;
578: pa_debug.debug(x_err_stack);

Line 633: x_err_stack ||'->PA_DELETE_ACCUM_RECS.Delete_Res_List_Commitments';

629: tot_recs_processed Number;
630: Begin
631: V_Old_Stack := x_err_stack;
632: x_err_stack :=
633: x_err_stack ||'->PA_DELETE_ACCUM_RECS.Delete_Res_List_Commitments';
634: x_err_code := 0;
635: x_err_stage := 'deleting PA_PROJECT_ACCUM_COMMITMENTS';
636: tot_recs_processed := 0;
637:

Line 715: x_err_stack ||'->PA_DELETE_ACCUM_RECS.Delete_Project_Accum_Headers';

711:
712: Begin
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:

Line 726: PA_DELETE_ACCUM_RECS.Get_Prj_Lvl_Accum_Id (p_project_id => x_project_Id

722:
723:
724: -- Get the Project-Level Project Accum Id.
725: -- Note: No error processing for this procedure as none expected
726: PA_DELETE_ACCUM_RECS.Get_Prj_Lvl_Accum_Id (p_project_id => x_project_Id
727: , x_Prj_Lvl_Accum_Id => l_Prj_Lvl_Accum_Id
728: , x_msg_count => l_msg_count
729: , x_msg_data => l_msg_data
730: , x_return_status => l_return_status);

Line 809: IF (p_project_id <> nvl(PA_DELETE_ACCUM_RECS.G_Prj_Lvl_project_id, '-99')

805: x_msg_count := 0;
806: x_msg_data := NULL;
807:
808:
809: IF (p_project_id <> nvl(PA_DELETE_ACCUM_RECS.G_Prj_Lvl_project_id, '-99')
810: )
811: THEN
812:
813: BEGIN

Line 832: PA_DELETE_ACCUM_RECS.G_Prj_Lvl_project_id := p_project_id;

828: END;
829:
830: -- Store Package Spec Globals for Future Calls to this Procedure.
831:
832: PA_DELETE_ACCUM_RECS.G_Prj_Lvl_project_id := p_project_id;
833: PA_DELETE_ACCUM_RECS.G_Prj_Lvl_Accum_Id := l_Prj_Lvl_Accum_Id;
834:
835:
836:

Line 833: PA_DELETE_ACCUM_RECS.G_Prj_Lvl_Accum_Id := l_Prj_Lvl_Accum_Id;

829:
830: -- Store Package Spec Globals for Future Calls to this Procedure.
831:
832: PA_DELETE_ACCUM_RECS.G_Prj_Lvl_project_id := p_project_id;
833: PA_DELETE_ACCUM_RECS.G_Prj_Lvl_Accum_Id := l_Prj_Lvl_Accum_Id;
834:
835:
836:
837: END IF;

Line 842: x_Prj_Lvl_Accum_Id := PA_DELETE_ACCUM_RECS.G_Prj_Lvl_Accum_Id;

838:
839:
840: -- Return Previously Stored Project-Level Project_Accum_Id
841:
842: x_Prj_Lvl_Accum_Id := PA_DELETE_ACCUM_RECS.G_Prj_Lvl_Accum_Id;
843:
844:
845: EXCEPTION
846: WHEN OTHERS

Line 850: ( p_pkg_name => 'PA_DELETE_ACCUM_RECS'

846: WHEN OTHERS
847: THEN
848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
849: FND_MSG_PUB.Add_Exc_Msg
850: ( p_pkg_name => 'PA_DELETE_ACCUM_RECS'
851: , p_procedure_name => 'GET_PRJ_LVL_ACCUM_ID'
852: , p_error_text => 'ORA-'||LPAD(substr(SQLCODE,2),5,'0')
853: );
854: FND_MSG_PUB.Count_And_Get

Line 866: End PA_DELETE_ACCUM_RECS;

862:
863:
864:
865:
866: End PA_DELETE_ACCUM_RECS;