APPS.PA_ACCUM_UTILS dependencies on PA_PROJECT_ACCUM_COMMITMENTS

Line 141: INSERT INTO PA_PROJECT_ACCUM_COMMITMENTS (

137: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
138: pa_debug.debug('Proj_level_record: ' || 'Creating Project Level Header record for Commitments');
139: END IF;
140:
141: INSERT INTO PA_PROJECT_ACCUM_COMMITMENTS (
142: PROJECT_ACCUM_ID,CMT_RAW_COST_ITD,CMT_RAW_COST_YTD,CMT_RAW_COST_PP,
143: CMT_RAW_COST_PTD,CMT_BURDENED_COST_ITD,CMT_BURDENED_COST_YTD,
144: CMT_BURDENED_COST_PP,CMT_BURDENED_COST_PTD,
145: CMT_QUANTITY_ITD,CMT_QUANTITY_YTD,CMT_QUANTITY_PP,CMT_QUANTITY_PTD,

Line 662: -- PA_PROJECT_ACCUM_COMMITMENTS table. It is possible

658:
659: -- Check_Cmt_Details - For the given Project,Task and Resource
660: -- combination in the PA_PROJECT_ACCUM_HEADERS table,
661: -- checks for detail records in
662: -- PA_PROJECT_ACCUM_COMMITMENTS table. It is possible
663: -- that the Headers table might have a record
664: -- but no corresponding detail record. This procedure
665: -- creates the detail records for all the tasks in
666: -- the hierarchy

Line 678: -- corresponding record in PA_PROJECT_ACCUM_COMMITMENTS

674: V_Old_Stack Varchar2(630);
675:
676: -- This cursor gets the Accum_id for the given Project,Task and Resource
677: -- combination which has a record in PA_PROJECT_ACCUM_HEADERS but no
678: -- corresponding record in PA_PROJECT_ACCUM_COMMITMENTS
679:
680: CURSOR Get_Accum_Id_Cur is
681: Select Project_accum_id
682: from

Line 690: PA_PROJECT_ACCUM_COMMITMENTS pac

686: and RESOURCE_LIST_MEMBER_ID = x_resource_list_member_id
687: and not exists
688: (Select Project_accum_id
689: from
690: PA_PROJECT_ACCUM_COMMITMENTS pac
691: where pac.project_accum_id = pah.project_accum_id);
692:
693: Begin
694: V_Old_Stack := x_err_stack;

Line 706: Insert into PA_PROJECT_ACCUM_COMMITMENTS (

702: -- If we get such a record in Headers, then we insert one record in
703: -- the Commitments Detail table
704:
705: If Get_Accum_Id_Cur%FOUND Then
706: Insert into PA_PROJECT_ACCUM_COMMITMENTS (
707: PROJECT_ACCUM_ID,CMT_RAW_COST_ITD,CMT_RAW_COST_YTD,CMT_RAW_COST_PP,
708: CMT_RAW_COST_PTD,
709: CMT_BURDENED_COST_ITD,CMT_BURDENED_COST_YTD,
710: CMT_BURDENED_COST_PP,CMT_BURDENED_COST_PTD,

Line 747: Insert into PA_PROJECT_ACCUM_COMMITMENTS (

743: -- tasks, if they have not been created.
744:
745: If v_noof_tasks > 0 then
746: FOR i in 1..v_noof_tasks LOOP
747: Insert into PA_PROJECT_ACCUM_COMMITMENTS (
748: PROJECT_ACCUM_ID,CMT_RAW_COST_ITD,CMT_RAW_COST_YTD,CMT_RAW_COST_PP,
749: CMT_RAW_COST_PTD,
750: CMT_BURDENED_COST_ITD,CMT_BURDENED_COST_YTD,
751: CMT_BURDENED_COST_PP,CMT_BURDENED_COST_PTD,

Line 763: Not Exists (Select 'x' from PA_PROJECT_ACCUM_COMMITMENTS PAC Where

759: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login
760: from PA_PROJECT_ACCUM_HEADERS PAH
761: Where Project_Id = x_project_id and Task_id = v_task_array(i) and
762: Resource_list_member_id = x_Resource_list_member_id and
763: Not Exists (Select 'x' from PA_PROJECT_ACCUM_COMMITMENTS PAC Where
764: PAH.PROJECT_ACCUM_ID = PAC.PROJECT_ACCUM_ID);
765: v_recs_processed := V_recs_processed + 1;
766: END LOOP;
767: End If;

Line 792: -- PA_PROJECT_ACCUM_COMMITMENTS table. It is possible

788:
789: -- Check_Budget_Details - For the given Project,Task and Resource
790: -- combination in the PA_PROJECT_ACCUM_HEADERS table,
791: -- checks for detail records in
792: -- PA_PROJECT_ACCUM_COMMITMENTS table. It is possible
793: -- that the Headers table might have a record
794: -- but no corresponding detail record. This procedure
795: -- creates the detail records for all the tasks in
796: -- the hierarchy