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_PROCESS_ACCUM_CMT_RES SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 31


SELECT Project_Accum_Id
FROM
PA_PROJECT_ACCUM_HEADERS
WHERE Project_id = X_project_id
AND   Task_Id = 0
AND Resource_list_Member_id = X_resource_list_member_id;

Line: 105


        Update PA_PROJECT_ACCUM_COMMITMENTS  PAA SET
         CMT_RAW_COST_ITD      = CMT_RAW_COST_ITD + X_Raw_Cost,
         CMT_RAW_COST_YTD      = CMT_RAW_COST_YTD + X_Raw_Cost,
         CMT_RAW_COST_PTD      = CMT_RAW_COST_PTD + X_Raw_Cost,
         CMT_BURDENED_COST_ITD     = CMT_BURDENED_COST_ITD + X_Burdened_Cost,
         CMT_BURDENED_COST_YTD     = CMT_BURDENED_COST_YTD + X_Burdened_Cost,
         CMT_BURDENED_COST_PTD     = CMT_BURDENED_COST_PTD + X_Burdened_Cost,
         CMT_QUANTITY_ITD          = CMT_QUANTITY_ITD + V_Qty,
         CMT_QUANTITY_YTD          = CMT_QUANTITY_YTD + V_Qty,
         CMT_QUANTITY_PTD          = CMT_QUANTITY_PTD + V_Qty,
         LAST_UPDATED_BY           = pa_proj_accum_main.x_last_updated_by,
         LAST_UPDATE_DATE          = Trunc(Sysdate),
         LAST_UPDATE_LOGIN         = pa_proj_accum_main.x_last_update_login
         Where PAA.Project_Accum_id     In
        (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
         Where Pah.Project_id = x_project_id and
         pah.Resource_list_member_id = x_resource_list_Member_id and
         Pah.Task_id in ( select 0 from sys.dual union
         Select Pt.Task_Id from PA_TASKS pt
         start with pt.task_id = x_task_id
         connect by prior pt.parent_task_id = pt.task_id));

Line: 160


        Select PA_PROJECT_ACCUM_HEADERS_S.Nextval
        into V_Accum_id
        From Dual;

Line: 163


        PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res
                             (X_project_id,
                              v_task_array(i),
                              x_resource_list_id ,
                              x_resource_list_Member_id ,
                              x_resource_id ,
                              x_resource_list_assignment_id ,
                              x_current_period,
                              v_accum_id,
                              x_err_stack,
                              x_err_stage,
                              x_err_code);

Line: 177


       Insert into PA_PROJECT_ACCUM_COMMITMENTS (
       PROJECT_ACCUM_ID,CMT_RAW_COST_ITD,CMT_RAW_COST_YTD,CMT_RAW_COST_PP,
       CMT_RAW_COST_PTD,
       CMT_BURDENED_COST_ITD,CMT_BURDENED_COST_YTD,
       CMT_BURDENED_COST_PP,CMT_BURDENED_COST_PTD,
       CMT_QUANTITY_ITD,CMT_QUANTITY_YTD,CMT_QUANTITY_PP,
       CMT_QUANTITY_PTD,
       CMT_UNIT_OF_MEASURE,
       REQUEST_ID,LAST_UPDATED_BY,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,
       LAST_UPDATE_LOGIN) Values
       (V_Accum_id,X_Raw_Cost,X_Raw_Cost,0,X_Raw_Cost,
        X_Burdened_Cost,X_Burdened_Cost,
        0,X_Burdened_Cost,
        V_Qty,V_Qty,0,V_Qty,
        X_Unit_Of_Measure,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
        Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);

Line: 203


       Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
       From Dual;

Line: 205


       PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res
                          (X_project_id,
                           0,
                           x_resource_list_id ,
                           x_resource_list_Member_id ,
                           x_resource_id ,
                           x_resource_list_assignment_id ,
                           x_current_period,
                           v_accum_id,
                           x_err_stack,
                           x_err_stage,
                           x_err_code);

Line: 219


       Insert into PA_PROJECT_ACCUM_COMMITMENTS (
       PROJECT_ACCUM_ID,CMT_RAW_COST_ITD,CMT_RAW_COST_YTD,CMT_RAW_COST_PP,
       CMT_RAW_COST_PTD,
       CMT_BURDENED_COST_ITD,CMT_BURDENED_COST_YTD,
       CMT_BURDENED_COST_PP,CMT_BURDENED_COST_PTD,
       CMT_QUANTITY_ITD,CMT_QUANTITY_YTD,CMT_QUANTITY_PP,
       CMT_QUANTITY_PTD,
       CMT_UNIT_OF_MEASURE,
       REQUEST_ID,LAST_UPDATED_BY,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,
       LAST_UPDATE_LOGIN) Values
       (V_Accum_id,X_Raw_Cost,X_Raw_Cost,0,X_Raw_Cost,
        X_Burdened_Cost,X_Burdened_Cost,
        0,X_Burdened_Cost,
        V_Qty,V_Qty,0,V_Qty,
        X_Unit_Of_Measure,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
        Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);

Line: 275


SELECT Project_Accum_Id
FROM
PA_PROJECT_ACCUM_HEADERS
WHERE Project_id = X_project_id
AND Task_Id = 0
AND Resource_list_Member_id = X_resource_list_member_id;

Line: 348


        Update PA_PROJECT_ACCUM_COMMITMENTS  PAA SET
         CMT_RAW_COST_ITD          = CMT_RAW_COST_ITD + X_Raw_Cost,
         CMT_RAW_COST_YTD          = CMT_RAW_COST_YTD + X_Raw_Cost,
         CMT_RAW_COST_PP           = CMT_RAW_COST_PP + X_Raw_Cost,
         CMT_BURDENED_COST_ITD     = CMT_BURDENED_COST_ITD + X_Burdened_Cost,
         CMT_BURDENED_COST_YTD     = CMT_BURDENED_COST_YTD + X_Burdened_Cost,
         CMT_BURDENED_COST_PP      = CMT_BURDENED_COST_PP + X_Burdened_Cost,
         CMT_QUANTITY_ITD          = CMT_QUANTITY_ITD + V_Qty,
         CMT_QUANTITY_YTD          = CMT_QUANTITY_YTD + V_Qty,
         CMT_QUANTITY_PP           = CMT_QUANTITY_PP + V_Qty,
         LAST_UPDATED_BY           = pa_proj_accum_main.x_last_updated_by,
         LAST_UPDATE_DATE          = Trunc(Sysdate),
         LAST_UPDATE_LOGIN         = pa_proj_accum_main.x_last_update_login
         Where PAA.Project_Accum_id     In
         (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
         Where Pah.Project_id = x_project_id and
         pah.Resource_list_member_id = x_resource_list_Member_id and
         Pah.Task_id in (select 0 from sys.dual union
         Select Pt.Task_Id from PA_TASKS pt
         start with pt.task_id = x_task_id
         connect by prior pt.parent_task_id = pt.task_id));

Line: 403


        Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
        From Dual;

Line: 405


        PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res
                             (X_project_id,
                              v_task_array(i),
                              x_resource_list_id ,
                              x_resource_list_Member_id ,
                              x_resource_id ,
                              x_resource_list_assignment_id ,
                              x_current_period,
                              v_accum_id,
                              x_err_stack,
                              x_err_stage,
                              x_err_code);

Line: 419


       Insert into PA_PROJECT_ACCUM_COMMITMENTS (
       PROJECT_ACCUM_ID,CMT_RAW_COST_ITD,CMT_RAW_COST_YTD,CMT_RAW_COST_PP,
       CMT_RAW_COST_PTD,
       CMT_BURDENED_COST_ITD,CMT_BURDENED_COST_YTD,
       CMT_BURDENED_COST_PP,CMT_BURDENED_COST_PTD,
       CMT_QUANTITY_ITD,CMT_QUANTITY_YTD,CMT_QUANTITY_PP,
       CMT_QUANTITY_PTD,
       CMT_UNIT_OF_MEASURE,
       REQUEST_ID,LAST_UPDATED_BY,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,
       LAST_UPDATE_LOGIN) Values
       (V_Accum_id,X_Raw_Cost,X_Raw_Cost,X_Raw_Cost,0,
        X_Burdened_Cost,X_Burdened_Cost,
        X_Burdened_Cost,0,
        V_Qty,V_Qty,V_Qty,0,
        X_Unit_Of_Measure,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
        Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);

Line: 445


       Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
       From Dual;

Line: 447


       PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res
                          (X_project_id,
                           0,
                           x_resource_list_id ,
                           x_resource_list_Member_id ,
                           x_resource_id ,
                           x_resource_list_assignment_id ,
                           x_current_period,
                           v_accum_id,
                           x_err_stack,
                           x_err_stage,
                           x_err_code);

Line: 462


       Insert into PA_PROJECT_ACCUM_COMMITMENTS (
       PROJECT_ACCUM_ID,CMT_RAW_COST_ITD,CMT_RAW_COST_YTD,CMT_RAW_COST_PP,
       CMT_RAW_COST_PTD,
       CMT_BURDENED_COST_ITD,CMT_BURDENED_COST_YTD,
       CMT_BURDENED_COST_PP,CMT_BURDENED_COST_PTD,
       CMT_QUANTITY_ITD,CMT_QUANTITY_YTD,CMT_QUANTITY_PP,
       CMT_QUANTITY_PTD,
       CMT_UNIT_OF_MEASURE,
       REQUEST_ID,LAST_UPDATED_BY,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,
       LAST_UPDATE_LOGIN) Values
       (V_Accum_id,X_Raw_Cost,X_Raw_Cost,X_Raw_Cost,0,
        X_Burdened_Cost,X_Burdened_Cost,
        X_Burdened_Cost,0,
        V_Qty,V_Qty,V_Qty,0,
        X_Unit_Of_Measure,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
        Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);

Line: 520


SELECT Project_Accum_Id
FROM
PA_PROJECT_ACCUM_HEADERS
WHERE Project_id = X_project_id
AND Task_Id = 0
AND Resource_list_Member_id = X_resource_list_member_id;

Line: 594


        Update PA_PROJECT_ACCUM_COMMITMENTS  PAA SET
         CMT_RAW_COST_ITD        = CMT_RAW_COST_ITD + X_Raw_Cost,
         CMT_RAW_COST_PP         = CMT_RAW_COST_PP + X_Raw_Cost,
         CMT_BURDENED_COST_ITD   = CMT_BURDENED_COST_ITD + X_Burdened_Cost,
         CMT_BURDENED_COST_PP    = CMT_BURDENED_COST_PP + X_Burdened_Cost,
         CMT_QUANTITY_ITD        = CMT_QUANTITY_ITD + V_Qty,
         CMT_QUANTITY_PP         = CMT_QUANTITY_PP + V_Qty,
         LAST_UPDATED_BY         = pa_proj_accum_main.x_last_updated_by,
         LAST_UPDATE_DATE        = Trunc(Sysdate),
         LAST_UPDATE_LOGIN       = pa_proj_accum_main.x_last_update_login
         Where PAA.Project_Accum_id     In

        (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
         Where Pah.Project_id = x_project_id and
         pah.Resource_list_member_id = x_resource_list_Member_id and
         Pah.Task_id in (select 0 from sys.dual union
         Select Pt.Task_Id from PA_TASKS pt
         start with pt.task_id = x_task_id
         connect by prior pt.parent_task_id = pt.task_id));

Line: 647


        Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
        From Dual;

Line: 649


        PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res
                             (X_project_id,
                              v_task_array(i),
                              x_resource_list_id ,
                              x_resource_list_Member_id ,
                              x_resource_id ,
                              x_resource_list_assignment_id ,
                              x_current_period,
                              v_accum_id,
                              x_err_stack,
                              x_err_stage,
                              x_err_code);

Line: 663


       Insert into PA_PROJECT_ACCUM_COMMITMENTS (
       PROJECT_ACCUM_ID,CMT_RAW_COST_ITD,CMT_RAW_COST_YTD,CMT_RAW_COST_PP,
       CMT_RAW_COST_PTD,
       CMT_BURDENED_COST_ITD,CMT_BURDENED_COST_YTD,
       CMT_BURDENED_COST_PP,CMT_BURDENED_COST_PTD,
       CMT_QUANTITY_ITD,CMT_QUANTITY_YTD,CMT_QUANTITY_PP,
       CMT_QUANTITY_PTD,
       CMT_UNIT_OF_MEASURE,
       REQUEST_ID,LAST_UPDATED_BY,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,
       LAST_UPDATE_LOGIN) Values
       (V_Accum_id,X_Raw_Cost,0,X_Raw_Cost,0,
        X_Burdened_Cost,0,
        X_Burdened_Cost,0,
        V_Qty,0,V_Qty,0,
        X_Unit_Of_Measure,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
        Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);

Line: 689


       Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
       From Dual;

Line: 691


       PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res
                             (X_project_id,
                              0,
                              x_resource_list_id ,
                              x_resource_list_Member_id ,
                              x_resource_id ,
                              x_resource_list_assignment_id ,
                              x_current_period,
                              v_accum_id,
                              x_err_stack,
                              x_err_stage,
                              x_err_code);

Line: 705


       Insert into PA_PROJECT_ACCUM_COMMITMENTS (
       PROJECT_ACCUM_ID,CMT_RAW_COST_ITD,CMT_RAW_COST_YTD,CMT_RAW_COST_PP,
       CMT_RAW_COST_PTD,
       CMT_BURDENED_COST_ITD,CMT_BURDENED_COST_YTD,
       CMT_BURDENED_COST_PP,CMT_BURDENED_COST_PTD,
       CMT_QUANTITY_ITD,CMT_QUANTITY_YTD,CMT_QUANTITY_PP,
       CMT_QUANTITY_PTD,
       CMT_UNIT_OF_MEASURE,
       REQUEST_ID,LAST_UPDATED_BY,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,
       LAST_UPDATE_LOGIN) Values
       (V_Accum_id,X_Raw_Cost,0,X_Raw_Cost,0,
       X_Burdened_Cost,0,
       X_Burdened_Cost,0,
       V_Qty,0,V_Qty,0,
       X_Unit_Of_Measure,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
       Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);

Line: 764


SELECT Project_Accum_Id
FROM
PA_PROJECT_ACCUM_HEADERS
WHERE Project_id = X_project_id
AND Task_Id = 0
AND Resource_list_Member_id = X_resource_list_member_id;

Line: 838


        Update PA_PROJECT_ACCUM_COMMITMENTS  PAA SET
         CMT_RAW_COST_ITD         = CMT_RAW_COST_ITD + X_Raw_Cost,
         CMT_RAW_COST_YTD         = CMT_RAW_COST_YTD + X_Raw_Cost,
         CMT_BURDENED_COST_ITD    = CMT_BURDENED_COST_ITD + X_Burdened_Cost,
         CMT_BURDENED_COST_YTD    = CMT_BURDENED_COST_YTD + X_Burdened_Cost,
         CMT_QUANTITY_ITD         = CMT_QUANTITY_ITD + V_Qty,
         CMT_QUANTITY_YTD         = CMT_QUANTITY_YTD + V_Qty,
         LAST_UPDATED_BY          = pa_proj_accum_main.x_last_updated_by,
         LAST_UPDATE_DATE         = Trunc(Sysdate),
         LAST_UPDATE_LOGIN        = pa_proj_accum_main.x_last_update_login
         Where PAA.Project_Accum_id     In
        (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
         Where Pah.Project_id = x_project_id and
         pah.Resource_list_member_id = x_resource_list_Member_id and
         Pah.Task_id in (select 0 from sys.dual union
         Select Pt.Task_Id from PA_TASKS pt
         start with pt.task_id = x_task_id
         connect by prior pt.parent_task_id = pt.task_id));

Line: 890


        Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
        From Dual;

Line: 892


        PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res
                             (X_project_id,
                              v_task_array(i),
                              x_resource_list_id ,
                              x_resource_list_Member_id ,
                              x_resource_id ,
                              x_resource_list_assignment_id ,
                              x_current_period,
                              v_accum_id,
                              x_err_stack,
                              x_err_stage,
                              x_err_code);

Line: 906


       Insert into PA_PROJECT_ACCUM_COMMITMENTS (
       PROJECT_ACCUM_ID,CMT_RAW_COST_ITD,CMT_RAW_COST_YTD,CMT_RAW_COST_PP,
       CMT_RAW_COST_PTD,
       CMT_BURDENED_COST_ITD,CMT_BURDENED_COST_YTD,
       CMT_BURDENED_COST_PP,CMT_BURDENED_COST_PTD,
       CMT_QUANTITY_ITD,CMT_QUANTITY_YTD,CMT_QUANTITY_PP,
       CMT_QUANTITY_PTD,
       CMT_UNIT_OF_MEASURE,
       REQUEST_ID,LAST_UPDATED_BY,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,
       LAST_UPDATE_LOGIN) Values
       (V_Accum_id,X_Raw_Cost,X_Raw_Cost,0,0,
        X_Burdened_Cost,X_Burdened_Cost,
        0,0,
        V_Qty,V_Qty,0,0,
        X_Unit_Of_Measure,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
        Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);

Line: 932


       Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
       From Dual;

Line: 934


       PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res
                          (X_project_id,
                           0,
                           x_resource_list_id ,
                           x_resource_list_Member_id ,
                           x_resource_id ,
                           x_resource_list_assignment_id ,
                           x_current_period,
                           v_accum_id,
                           x_err_stack,
                           x_err_stage,
                           x_err_code);

Line: 948


       Insert into PA_PROJECT_ACCUM_COMMITMENTS (
       PROJECT_ACCUM_ID,CMT_RAW_COST_ITD,CMT_RAW_COST_YTD,CMT_RAW_COST_PP,
       CMT_RAW_COST_PTD,
       CMT_BURDENED_COST_ITD,CMT_BURDENED_COST_YTD,
       CMT_BURDENED_COST_PP,CMT_BURDENED_COST_PTD,
       CMT_QUANTITY_ITD,CMT_QUANTITY_YTD,CMT_QUANTITY_PP,
       CMT_QUANTITY_PTD,
       CMT_UNIT_OF_MEASURE,
       REQUEST_ID,LAST_UPDATED_BY,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,
       LAST_UPDATE_LOGIN) Values
       (V_Accum_id,X_Raw_Cost,X_Raw_Cost,0,0,
        X_Burdened_Cost,X_Burdened_Cost,
        0,0,
        V_Qty,V_Qty,0,0,
        X_Unit_Of_Measure,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
        Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);

Line: 1005


SELECT Project_Accum_Id
FROM
PA_PROJECT_ACCUM_HEADERS
WHERE Project_id = X_project_id
AND Task_Id = 0
AND Resource_list_Member_id = X_resource_list_member_id;

Line: 1079


        Update PA_PROJECT_ACCUM_COMMITMENTS  PAA SET
         CMT_RAW_COST_ITD          = CMT_RAW_COST_ITD + X_Raw_Cost,
         CMT_BURDENED_COST_ITD     = CMT_BURDENED_COST_ITD + X_Burdened_Cost,
         CMT_QUANTITY_ITD          = CMT_QUANTITY_ITD + V_Qty,
         LAST_UPDATE_DATE          = Trunc(Sysdate),
         LAST_UPDATE_LOGIN         = pa_proj_accum_main.x_last_update_login
         Where PAA.Project_Accum_id     In
        (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
         Where Pah.Project_id = x_project_id and
         pah.Resource_list_member_id = x_resource_list_Member_id and
         Pah.Task_id in (select 0 from sys.dual union
         Select Pt.Task_Id from PA_TASKS pt
         start with pt.task_id = x_task_id
         connect by prior pt.parent_task_id = pt.task_id));

Line: 1127


        Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
        From Dual;

Line: 1129


        PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res
                             (X_project_id,
                              v_task_array(i),
                              x_resource_list_id ,
                              x_resource_list_Member_id ,
                              x_resource_id ,
                              x_resource_list_assignment_id ,
                              x_current_period,
                              v_accum_id,
                              x_err_stack,
                              x_err_stage,
                              x_err_code);

Line: 1143


       Insert into PA_PROJECT_ACCUM_COMMITMENTS (
       PROJECT_ACCUM_ID,CMT_RAW_COST_ITD,CMT_RAW_COST_YTD,CMT_RAW_COST_PP,
       CMT_RAW_COST_PTD,
       CMT_BURDENED_COST_ITD,CMT_BURDENED_COST_YTD,
       CMT_BURDENED_COST_PP,CMT_BURDENED_COST_PTD,
       CMT_QUANTITY_ITD,CMT_QUANTITY_YTD,CMT_QUANTITY_PP,
       CMT_QUANTITY_PTD,
       CMT_UNIT_OF_MEASURE,
       REQUEST_ID,LAST_UPDATED_BY,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,
       LAST_UPDATE_LOGIN) Values
       (V_Accum_id,X_Raw_Cost,0,0,0,
        X_Burdened_Cost,0,0,0,
        V_Qty,0,0,0,
        X_Unit_Of_Measure,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
        Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);

Line: 1168


       Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
       From Dual;

Line: 1170


       PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res
                             (X_project_id,
                           0,
                           x_resource_list_id ,
                           x_resource_list_Member_id ,
                           x_resource_id ,
                           x_resource_list_assignment_id ,
                           x_current_period,
                           v_accum_id,
                           x_err_stack,
                           x_err_stage,
                           x_err_code);

Line: 1184


       Insert into PA_PROJECT_ACCUM_COMMITMENTS (
       PROJECT_ACCUM_ID,CMT_RAW_COST_ITD,CMT_RAW_COST_YTD,CMT_RAW_COST_PP,
       CMT_RAW_COST_PTD,
       CMT_BURDENED_COST_ITD,CMT_BURDENED_COST_YTD,
       CMT_BURDENED_COST_PP,CMT_BURDENED_COST_PTD,
       CMT_QUANTITY_ITD,CMT_QUANTITY_YTD,CMT_QUANTITY_PP,
       CMT_QUANTITY_PTD,
       CMT_UNIT_OF_MEASURE,
       REQUEST_ID,LAST_UPDATED_BY,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,
       LAST_UPDATE_LOGIN) Values
       (V_Accum_id,X_Raw_Cost,0,0,0,
        X_Burdened_Cost,0,0,0,
        V_Qty,0,0,0,
        X_Unit_Of_Measure,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
        Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);

Line: 1227


SELECT task_id
FROM pa_tasks pt
WHERE project_id = x_project_id
AND NOT EXISTS
(SELECT 'x'
 FROM
 pa_project_accum_headers pah
 WHERE pah.project_id = x_project_id
 AND pah.task_id = pt.task_id
 AND pah.resource_list_member_id = x_resource_list_member_id)
 START WITH task_id = x_task_id
 CONNECT BY PRIOR parent_task_id = task_id;