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

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

Line: 55


        Update PA_PROJECT_ACCUM_ACTUALS  PAA SET
         RAW_COST_ITD = RAW_COST_ITD + X_Raw_Cost,
         RAW_COST_YTD = RAW_COST_YTD + X_Raw_Cost,
         RAW_COST_PTD = RAW_COST_PTD + X_Raw_Cost,
         BILLABLE_RAW_COST_ITD = BILLABLE_RAW_COST_ITD +
                                 X_Billable_Raw_Cost,
         BILLABLE_RAW_COST_YTD = BILLABLE_RAW_COST_YTD +
                                 X_Billable_Raw_Cost,
         BILLABLE_RAW_COST_PTD = BILLABLE_RAW_COST_PTD +
                                 X_Billable_Raw_Cost,
         BURDENED_COST_ITD     = BURDENED_COST_ITD + X_Burdened_Cost,
         BURDENED_COST_YTD     = BURDENED_COST_YTD + X_Burdened_Cost,
         BURDENED_COST_PTD     = BURDENED_COST_PTD + X_Burdened_Cost,
         BILLABLE_BURDENED_COST_ITD = BILLABLE_BURDENED_COST_ITD +
                                      X_Billable_Burdened_Cost,
         BILLABLE_BURDENED_COST_YTD = BILLABLE_BURDENED_COST_YTD +
                                      X_Billable_Burdened_Cost,
         BILLABLE_BURDENED_COST_PTD = BILLABLE_BURDENED_COST_PTD +
                                      X_Billable_Burdened_Cost,
         LABOR_HOURS_ITD            = LABOR_HOURS_ITD + X_Labor_Hours,
         LABOR_HOURS_YTD            = LABOR_HOURS_YTD + X_Labor_Hours,
         LABOR_HOURS_PTD            = LABOR_HOURS_PTD + X_Labor_Hours,
         BILLABLE_LABOR_HOURS_ITD   = BILLABLE_LABOR_HOURS_ITD +
                                      X_Billable_Labor_Hours,
         BILLABLE_LABOR_HOURS_YTD   = BILLABLE_LABOR_HOURS_YTD +
                                      X_Billable_Labor_Hours,
         BILLABLE_LABOR_HOURS_PTD   = BILLABLE_LABOR_HOURS_PTD +
                                      X_Billable_Labor_Hours,
         QUANTITY_ITD               = QUANTITY_ITD + X_Quantity,
         QUANTITY_YTD               = QUANTITY_YTD + X_Quantity,
         QUANTITY_PTD               = QUANTITY_PTD + X_Quantity,
         BILLABLE_QUANTITY_ITD      = BILLABLE_QUANTITY_ITD + X_Billable_Quantity,
         BILLABLE_QUANTITY_YTD      = BILLABLE_QUANTITY_YTD + X_Billable_Quantity,
         BILLABLE_QUANTITY_PTD      = BILLABLE_QUANTITY_PTD + X_Billable_Quantity,
         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: 103


        Update PA_PROJECT_ACCUM_ACTUALS  PAA SET
         REVENUE_ITD                = REVENUE_ITD + X_Revenue,
         REVENUE_YTD                = REVENUE_YTD + X_Revenue,
         REVENUE_PTD                = REVENUE_PTD + X_Revenue,
         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: 180


        Update PA_PROJECT_ACCUM_ACTUALS  PAA SET
         RAW_COST_ITD                   = RAW_COST_ITD + X_Raw_Cost,
         RAW_COST_YTD                   = RAW_COST_YTD + X_Raw_Cost,
         RAW_COST_PP                    = RAW_COST_PP + X_Raw_Cost,
         BILLABLE_RAW_COST_ITD          = BILLABLE_RAW_COST_ITD +
                                          X_Billable_Raw_Cost,
         BILLABLE_RAW_COST_YTD          = BILLABLE_RAW_COST_YTD +
                                          X_Billable_Raw_Cost,
         BILLABLE_RAW_COST_PP           = BILLABLE_RAW_COST_PP +
                                          X_Billable_Raw_Cost,
         BURDENED_COST_ITD              = BURDENED_COST_ITD + X_Burdened_Cost,
         BURDENED_COST_YTD              = BURDENED_COST_YTD + X_Burdened_Cost,
         BURDENED_COST_PP               = BURDENED_COST_PP + X_Burdened_Cost,
         BILLABLE_BURDENED_COST_ITD     = BILLABLE_BURDENED_COST_ITD +
                                          X_Billable_Burdened_Cost,
         BILLABLE_BURDENED_COST_YTD     = BILLABLE_BURDENED_COST_YTD +
                                          X_Billable_Burdened_Cost,
         BILLABLE_BURDENED_COST_PP      = BILLABLE_BURDENED_COST_PP +
                                          X_Billable_Burdened_Cost,
         LABOR_HOURS_ITD                = LABOR_HOURS_ITD + X_Labor_Hours,
         LABOR_HOURS_YTD                = LABOR_HOURS_YTD + X_Labor_Hours,
         LABOR_HOURS_PP                 = LABOR_HOURS_PP + X_Labor_Hours,
         BILLABLE_LABOR_HOURS_ITD       = BILLABLE_LABOR_HOURS_ITD +
                                          X_Billable_Labor_Hours,
         BILLABLE_LABOR_HOURS_YTD       = BILLABLE_LABOR_HOURS_YTD +
                                          X_Billable_Labor_Hours,
         BILLABLE_LABOR_HOURS_PP        = BILLABLE_LABOR_HOURS_PP +
                                          X_Billable_Labor_Hours,
         QUANTITY_ITD                   = QUANTITY_ITD + X_Quantity,
         QUANTITY_YTD                   = QUANTITY_YTD + X_Quantity,
         QUANTITY_PP                    = QUANTITY_PP + X_Quantity,
         BILLABLE_QUANTITY_ITD          = BILLABLE_QUANTITY_ITD +
                                          X_Billable_Quantity,
         BILLABLE_QUANTITY_YTD          = BILLABLE_QUANTITY_YTD +
                                          X_Billable_Quantity,
         BILLABLE_QUANTITY_PP           = BILLABLE_QUANTITY_PP  +
                                          X_Billable_Quantity,
         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: 231


        Update PA_PROJECT_ACCUM_ACTUALS  PAA SET
         REVENUE_ITD                    = REVENUE_ITD + X_Revenue,
         REVENUE_YTD                    = REVENUE_YTD + X_Revenue,
         REVENUE_PP                     = REVENUE_PP + X_Revenue,
         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: 308


        Update PA_PROJECT_ACCUM_ACTUALS  PAA SET
         RAW_COST_ITD               = RAW_COST_ITD + X_Raw_Cost,
         RAW_COST_PP                = RAW_COST_PP + X_Raw_Cost,
         BILLABLE_RAW_COST_ITD      = BILLABLE_RAW_COST_ITD +
                                      X_Billable_Raw_Cost,
         BILLABLE_RAW_COST_PP       = BILLABLE_RAW_COST_PP +
                                      X_Billable_Raw_Cost,
         BURDENED_COST_ITD          = BURDENED_COST_ITD + X_Burdened_Cost,
         BURDENED_COST_PP           = BURDENED_COST_PP + X_Burdened_Cost,
         BILLABLE_BURDENED_COST_ITD = BILLABLE_BURDENED_COST_ITD +
                                      X_Billable_Burdened_Cost,
         BILLABLE_BURDENED_COST_PP  = BILLABLE_BURDENED_COST_PP +
                                      X_Billable_Burdened_Cost,
         LABOR_HOURS_ITD            = LABOR_HOURS_ITD + X_Labor_Hours,
         LABOR_HOURS_PP             = LABOR_HOURS_PP + X_Labor_Hours,
         BILLABLE_LABOR_HOURS_ITD   = BILLABLE_LABOR_HOURS_ITD +
                                      X_Billable_Labor_Hours,
         BILLABLE_LABOR_HOURS_PP    = BILLABLE_LABOR_HOURS_PP +
                                      X_Billable_Labor_Hours,
         QUANTITY_ITD               = QUANTITY_ITD + X_Quantity,
         QUANTITY_PP                = QUANTITY_PP + X_Quantity,
         BILLABLE_QUANTITY_ITD      = BILLABLE_QUANTITY_ITD + X_Billable_Quantity,
         BILLABLE_QUANTITY_PP       = BILLABLE_QUANTITY_PP + X_Billable_Quantity,
         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: 345


        Update PA_PROJECT_ACCUM_ACTUALS  PAA SET
         REVENUE_ITD                = REVENUE_ITD + X_Revenue,
         REVENUE_PP                 = REVENUE_PP + X_Revenue,
         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: 419


        Update PA_PROJECT_ACCUM_ACTUALS  PAA SET
         RAW_COST_ITD               = RAW_COST_ITD + X_Raw_Cost,
         RAW_COST_YTD               = RAW_COST_YTD + X_Raw_Cost,
         BILLABLE_RAW_COST_ITD      = BILLABLE_RAW_COST_ITD +
                                      X_Billable_Raw_Cost,
         BILLABLE_RAW_COST_YTD      = BILLABLE_RAW_COST_YTD +
                                      X_Billable_Raw_Cost,
         BURDENED_COST_ITD          = BURDENED_COST_ITD + X_Burdened_Cost,
         BURDENED_COST_YTD          = BURDENED_COST_YTD + X_Burdened_Cost,
         BILLABLE_BURDENED_COST_ITD = BILLABLE_BURDENED_COST_ITD +
                                      X_Billable_Burdened_Cost,
         BILLABLE_BURDENED_COST_YTD = BILLABLE_BURDENED_COST_YTD +
                                      X_Billable_Burdened_Cost,
         LABOR_HOURS_ITD            = LABOR_HOURS_ITD + X_Labor_Hours,
         LABOR_HOURS_YTD            = LABOR_HOURS_YTD + X_Labor_Hours,
         BILLABLE_LABOR_HOURS_ITD   = BILLABLE_LABOR_HOURS_ITD +
                                      X_Billable_Labor_Hours,
         BILLABLE_LABOR_HOURS_YTD   = BILLABLE_LABOR_HOURS_YTD +
                                      X_Billable_Labor_Hours,
         QUANTITY_ITD               = QUANTITY_ITD + X_Quantity,
         QUANTITY_YTD               = QUANTITY_YTD + X_Quantity,
         BILLABLE_QUANTITY_ITD      = BILLABLE_QUANTITY_ITD + X_Billable_Quantity,
         BILLABLE_QUANTITY_YTD      = BILLABLE_QUANTITY_YTD + X_Billable_Quantity,
         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: 456


        Update PA_PROJECT_ACCUM_ACTUALS  PAA SET
         REVENUE_ITD                = REVENUE_ITD + X_Revenue,
         REVENUE_YTD                = REVENUE_YTD + X_Revenue,
         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: 531


        Update PA_PROJECT_ACCUM_ACTUALS  PAA SET
         RAW_COST_ITD               = RAW_COST_ITD + X_Raw_Cost,
         BILLABLE_RAW_COST_ITD      = BILLABLE_RAW_COST_ITD +
                                      X_Billable_Raw_Cost,
         BURDENED_COST_ITD          = BURDENED_COST_ITD + X_Burdened_Cost,
         BILLABLE_BURDENED_COST_ITD = BILLABLE_BURDENED_COST_ITD +
                                      X_Billable_Burdened_Cost,
         LABOR_HOURS_ITD            = LABOR_HOURS_ITD + X_Labor_Hours,
         BILLABLE_LABOR_HOURS_ITD   = BILLABLE_LABOR_HOURS_ITD +
                                      X_Billable_Labor_Hours,
         QUANTITY_ITD               = QUANTITY_ITD + X_Quantity,
         BILLABLE_QUANTITY_ITD      = BILLABLE_QUANTITY_ITD + X_Billable_Quantity,
         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: 557


        Update PA_PROJECT_ACCUM_ACTUALS  PAA SET
         REVENUE_ITD                = REVENUE_ITD + X_Revenue,
         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: 581


Procedure Insert_Headers_res (X_project_id In Number,
                              x_task_id In Number,
                              x_resource_list_id in Number,
                              x_resource_list_Member_id in Number,
                              x_resource_id in Number,
                              x_resource_list_assignment_id in Number,
                              x_current_period In Varchar2,
                              x_accum_id In Number,
                              x_err_stack     In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
                              x_err_stage     In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
                              x_err_code      In Out NOCOPY Number ) IS --File.Sql.39 bug 4440895

-- Insert_Headers_res    - Inserts Header records in the
--                         PA_PROJECT_ACCUM_HEADERS table for the given
--                         Project-Task-Resource combination

V_Old_Stack       Varchar2(630);

Line: 602


        x_err_stack||'->PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res';

Line: 605


        Insert into PA_PROJECT_ACCUM_HEADERS
        (PROJECT_ACCUM_ID,PROJECT_ID,TASK_ID,ACCUM_PERIOD,RESOURCE_ID,
         RESOURCE_LIST_ID,RESOURCE_LIST_ASSIGNMENT_ID,
         RESOURCE_LIST_MEMBER_ID,LAST_UPDATED_BY,LAST_UPDATE_DATE,
         REQUEST_ID,CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN )
         Values (x_Accum_id,X_project_id,x_task_id,
                 x_current_period,
                 x_resource_id,x_resource_list_id,
                 x_resource_list_assignment_id,x_resource_list_Member_id,
                 pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),pa_proj_accum_main.x_request_id,trunc(sysdate),
                 pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login );

Line: 624


End Insert_Headers_res ;