[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
Select Distinct
Resource_list_id
FROM
PA_RESOURCE_LIST_ASSIGNMENTS
WHERE Project_id = X_project_id;
SELECT
PTA.TXN_ACCUM_ID,
nvl(PT.parent_task_id,PT.task_id) parent_task_id,
PTA.TASK_ID task_id,
PTA.PA_PERIOD,
PTA.GL_PERIOD,
decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_REVENUE,0),NVL(PTA.I_TOT_REVENUE,0)) I_TOT_REVENUE,
decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_RAW_COST,0),NVL(PTA.I_TOT_RAW_COST,0)) I_TOT_RAW_COST,
decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BURDENED_COST,0),NVL(PTA.I_TOT_BURDENED_COST,0)) I_TOT_BURDENED_COST,
decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_QUANTITY,0),NVL(PTA.I_TOT_QUANTITY,0)) I_TOT_QUANTITY,
decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_LABOR_HOURS,0),NVL(PTA.I_TOT_LABOR_HOURS,0)) I_TOT_LABOR_HOURS,
decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_RAW_COST,0),NVL(PTA.I_TOT_BILLABLE_RAW_COST,0)) I_TOT_BILLABLE_RAW_COST ,
decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_BURDENED_COST,0),NVL(PTA.I_TOT_BILLABLE_BURDENED_COST,0)) I_TOT_BILLABLE_BURDENED_COST,
decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_QUANTITY,0),NVL(PTA.I_TOT_BILLABLE_QUANTITY,0))I_TOT_BILLABLE_QUANTITY,
decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_LABOR_HOURS,0),NVL(PTA.I_TOT_BILLABLE_LABOR_HOURS,0)) I_TOT_BILLABLE_LABOR_HOURS,
NVL(PTA.TOT_CMT_RAW_COST,0) TOT_CMT_RAW_COST,
NVL(PTA.TOT_CMT_BURDENED_COST,0) TOT_CMT_BURDENED_COST,
NVL(PTA.TOT_CMT_QUANTITY,0) TOT_CMT_QUANTITY,
PTA.actual_cost_rollup_flag,
PTA.revenue_rollup_flag,
PTA.cmt_rollup_flag,
GPS.PERIOD_YEAR,
Para.RESOURCE_LIST_ASSIGNMENT_ID,
Para.RESOURCE_LIST_ID,
Para.RESOURCE_LIST_MEMBER_ID,
Para.RESOURCE_ID ,
Parl.TRACK_AS_LABOR_FLAG,
Par.ROLLUP_QUANTITY_FLAG ,
Par.UNIT_OF_MEASURE,
PT.wbs_level
FROM
PA_TXN_ACCUM PTA,
PA_TASKS PT,
GL_PERIOD_STATUSES GPS,
PA_IMPLEMENTATIONS PI,
PA_RESOURCE_ACCUM_DETAILS Para,
PA_RESOURCES Par,
PA_RESOURCE_LIST_MEMBERS Parl
Where Parl.resource_list_id = nvl(x_resource_list_id,Parl.resource_list_id) and
Para.Resource_list_id = Parl.Resource_list_id and
Para.Resource_list_member_id = Parl.Resource_list_member_id and
Para.Resource_id = Par.Resource_Id and
PTA.Project_Id = x_project_id and
nvl(parl.migration_code,'-99') <> 'N' and
(PTA.ACTUAL_COST_Rollup_flag = DECODE(x_Actual_Cost_Flag,'Y','Y','X')
OR PTA.REVENUE_Rollup_flag = DECODE(x_revenue_Flag,'Y','Y','X')
OR PTA.CMT_Rollup_flag = DECODE(x_commitments_Flag,'Y','Y','X')
OR pa_proj_accum_main.x_summ_process = 'RL') and
-- gps.application_id = decode(x_impl_opt,'PA',275,'GL',pa_period_process_pkg.application_id) and
----- commented and added for bug 2569461
-- Added TO_NUMBER(SUBSTR(USERENV('CLIENT_INFO'),1,10)) for bug 2834359
-- bug 3147957: Replaced TO_NUMBER(SUBSTR(USERENV('CLIENT_INFO'),1,10)) with p_org_id
gps.application_id = decode(x_impl_opt,'PA',decode(PA_Period_Process_PKG.Use_Same_PA_GL_Period(p_org_id),'Y',
pa_period_process_pkg.application_id,'N',275),'GL',pa_period_process_pkg.application_id) and
gps.set_of_books_id = pi.set_of_books_id and
gps.period_name = decode(x_impl_opt,'PA',PTA.pa_period,'GL',PTA.gl_period) and
gps.END_DATE <= x_current_end_date and
PT.task_id = PTA.Task_id and
Para.Txn_Accum_id = PTA.Txn_Accum_id
union
select
PTA.TXN_ACCUM_ID,
0 parent_task_id,
0 task_id,
PTA.PA_PERIOD,
PTA.GL_PERIOD,
decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_REVENUE,0),NVL(PTA.I_TOT_REVENUE,0)) I_TOT_REVENUE,
decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_RAW_COST,0),NVL(PTA.I_TOT_RAW_COST,0)) I_TOT_RAW_COST,
decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BURDENED_COST,0),NVL(PTA.I_TOT_BURDENED_COST,0)) I_TOT_BURDENED_COST,
decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_QUANTITY,0),NVL(PTA.I_TOT_QUANTITY,0)) I_TOT_QUANTITY,
decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_LABOR_HOURS,0),NVL(PTA.I_TOT_LABOR_HOURS,0)) I_TOT_LABOR_HOURS,
decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_RAW_COST,0),NVL(PTA.I_TOT_BILLABLE_RAW_COST,0)) I_TOT_BILLABLE_RAW_COST ,
decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_BURDENED_COST,0),NVL(PTA.I_TOT_BILLABLE_BURDENED_COST,0)) I_TOT_BILLABLE_BURDENED_COST,
decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_QUANTITY,0),NVL(PTA.I_TOT_BILLABLE_QUANTITY,0))I_TOT_BILLABLE_QUANTITY,
decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_LABOR_HOURS,0),NVL(PTA.I_TOT_BILLABLE_LABOR_HOURS,0)) I_TOT_BILLABLE_LABOR_HOURS,
NVL(PTA.TOT_CMT_RAW_COST,0) TOT_CMT_RAW_COST,
NVL(PTA.TOT_CMT_BURDENED_COST,0) TOT_CMT_BURDENED_COST,
NVL(PTA.TOT_CMT_QUANTITY,0) TOT_CMT_QUANTITY,
PTA.actual_cost_rollup_flag,
PTA.revenue_rollup_flag,
PTA.cmt_rollup_flag,
GPS.PERIOD_YEAR,
Para.RESOURCE_LIST_ASSIGNMENT_ID,
Para.RESOURCE_LIST_ID,
Para.RESOURCE_LIST_MEMBER_ID,
Para.RESOURCE_ID ,
Parl.TRACK_AS_LABOR_FLAG,
Par.ROLLUP_QUANTITY_FLAG ,
Par.UNIT_OF_MEASURE,
0 wbs_level
FROM
PA_TXN_ACCUM PTA,
GL_PERIOD_STATUSES GPS,
PA_IMPLEMENTATIONS PI,
PA_RESOURCE_ACCUM_DETAILS Para,
PA_RESOURCES Par,
PA_RESOURCE_LIST_MEMBERS Parl
Where Parl.resource_list_id = nvl(x_resource_list_id,Parl.resource_list_id) and
Para.Resource_list_id = Parl.Resource_list_id and
Para.Resource_list_member_id = Parl.Resource_list_member_id and
Para.Resource_id = Par.Resource_Id and
PTA.Project_Id = x_project_id and
nvl(parl.migration_code,'-99') <> 'N' and
(PTA.ACTUAL_COST_Rollup_flag = DECODE(x_Actual_Cost_Flag,'Y','Y','X')
OR PTA.REVENUE_Rollup_flag = DECODE(x_revenue_Flag,'Y','Y','X')
OR PTA.CMT_Rollup_flag = DECODE(x_commitments_Flag,'Y','Y','X')
OR pa_proj_accum_main.x_summ_process = 'RL') and
-- gps.application_id = decode(x_impl_opt,'PA',275,'GL',pa_period_process_pkg.application_id) and
-- commented and added for bug 2569461
-- Added TO_NUMBER(SUBSTR(USERENV('CLIENT_INFO'),1,10)) for bug 2834359
-- bug 3147957: Replaced TO_NUMBER(SUBSTR(USERENV('CLIENT_INFO'),1,10)) with p_org_id
gps.application_id = decode(x_impl_opt,'PA',decode(PA_Period_Process_PKG.Use_Same_PA_GL_Period(p_org_id),'Y',
pa_period_process_pkg.application_id,'N',275),'GL',pa_period_process_pkg.application_id) and
gps.set_of_books_id = pi.set_of_books_id and
gps.period_name = decode(x_impl_opt,'PA',PTA.pa_period,'GL',PTA.gl_period) and
gps.END_DATE <= x_current_end_date and
Para.Txn_Accum_id = PTA.Txn_Accum_id
Order By 2,29,3,24; --Parent_Task_id,WBS_Level,Task_id,Para.Resource_List_Member_id;
SELECT DISTINCT
PTA.TXN_ACCUM_ID,
nvl(PT.parent_task_id,nvl(pt.task_id,0)) top_task_id,
PTA.TASK_ID,
PTA.PA_PERIOD,
PTA.GL_PERIOD,
NVL(PTA.I_TOT_REVENUE,0) I_TOT_REVENUE,
NVL(PTA.I_TOT_RAW_COST,0) I_TOT_RAW_COST,
NVL(PTA.I_TOT_BURDENED_COST,0) I_TOT_BURDENED_COST,
NVL(PTA.I_TOT_QUANTITY,0) I_TOT_QUANTITY,
NVL(PTA.I_TOT_LABOR_HOURS,0) I_TOT_LABOR_HOURS,
NVL(PTA.I_TOT_BILLABLE_RAW_COST,0) I_TOT_BILLABLE_RAW_COST ,
NVL(PTA.I_TOT_BILLABLE_BURDENED_COST,0) I_TOT_BILLABLE_BURDENED_COST,
NVL(PTA.I_TOT_BILLABLE_QUANTITY,0) I_TOT_BILLABLE_QUANTITY,
NVL(PTA.I_TOT_BILLABLE_LABOR_HOURS,0) I_TOT_BILLABLE_LABOR_HOURS,
NVL(PTA.TOT_CMT_RAW_COST,0) TOT_CMT_RAW_COST,
NVL(PTA.TOT_CMT_BURDENED_COST,0) TOT_CMT_BURDENED_COST,
NVL(PTA.TOT_CMT_QUANTITY,0) TOT_CMT_QUANTITY,
PTA.actual_cost_rollup_flag,
PTA.revenue_rollup_flag,
PTA.cmt_rollup_flag,
PTA.UNIT_OF_MEASURE,
GPS.PERIOD_YEAR,
nvl(PT.WBS_Level,0)
FROM
PA_TXN_ACCUM PTA,
PA_TASKS PT,
GL_PERIOD_STATUSES GPS,
PA_IMPLEMENTATIONS PI
Where PTA.Project_Id = x_project_id
and PTA.task_id = PT.task_id(+)
and (PTA.ACTUAL_COST_Rollup_flag = DECODE(x_Actual_Cost_Flag,'Y','Y','X')
OR PTA.REVENUE_Rollup_flag = DECODE(x_revenue_Flag,'Y','Y','X')
OR PTA.CMT_Rollup_flag = DECODE(x_commitments_Flag,'Y','Y','X')
OR pa_proj_accum_main.x_summ_process = 'RL')
-- and gps.application_id = decode(x_impl_opt,'PA',275,'GL',pa_period_process_pkg.application_id)
----- commented and added for bug 2569461
-- Added TO_NUMBER(SUBSTR(USERENV('CLIENT_INFO'),1,10)) for bug 2834359
-- bug 3147957: Replaced TO_NUMBER(SUBSTR(USERENV('CLIENT_INFO'),1,10)) with p_org_id
and gps.application_id = decode(x_impl_opt,'PA',decode(PA_Period_Process_PKG.Use_Same_PA_GL_Period(p_org_id),'Y',
pa_period_process_pkg.application_id,'N',275),'GL',pa_period_process_pkg.application_id)
and gps.set_of_books_id = pi.set_of_books_id
and gps.period_name = decode(x_impl_opt,'PA',PTA.pa_period,'GL',PTA.gl_period)
and gps.END_DATE <= x_current_end_date
Order By 2,23,3; --Parent_Task_id,WBS_Level,Task_id
SELECT
PTA.TXN_ACCUM_ID,
nvl(PT.parent_task_id,PT.task_id) parent_task_id,
PTA.TASK_ID task_id,
PTA.PA_PERIOD,
PTA.GL_PERIOD,
decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_REVENUE,0),NVL(PTA.I_TOT_REVENUE,0)) I_TOT_REVENUE,
decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_RAW_COST,0),NVL(PTA.I_TOT_RAW_COST,0)) I_TOT_RAW_COST,
decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BURDENED_COST,0),NVL(PTA.I_TOT_BURDENED_COST,0)) I_TOT_BURDENED_COST,
decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_QUANTITY,0),NVL(PTA.I_TOT_QUANTITY,0)) I_TOT_QUANTITY,
decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_LABOR_HOURS,0),NVL(PTA.I_TOT_LABOR_HOURS,0)) I_TOT_LABOR_HOURS,
decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_RAW_COST,0),NVL(PTA.I_TOT_BILLABLE_RAW_COST,0)) I_TOT_BILLABLE_RAW_COST ,
decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_BURDENED_COST,0),NVL(PTA.I_TOT_BILLABLE_BURDENED_COST,0)) I_TOT_BILLABLE_BURDENED_COST,
decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_QUANTITY,0),NVL(PTA.I_TOT_BILLABLE_QUANTITY,0))I_TOT_BILLABLE_QUANTITY,
decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_LABOR_HOURS,0),NVL(PTA.I_TOT_BILLABLE_LABOR_HOURS,0)) I_TOT_BILLABLE_LABOR_HOURS,
NVL(PTA.TOT_CMT_RAW_COST,0) TOT_CMT_RAW_COST,
NVL(PTA.TOT_CMT_BURDENED_COST,0) TOT_CMT_BURDENED_COST,
NVL(PTA.TOT_CMT_QUANTITY,0) TOT_CMT_QUANTITY,
PTA.actual_cost_rollup_flag,
PTA.revenue_rollup_flag,
PTA.cmt_rollup_flag,
GPS.PERIOD_YEAR,
Para.RESOURCE_LIST_ASSIGNMENT_ID,
Para.RESOURCE_LIST_ID,
Para.RESOURCE_LIST_MEMBER_ID,
Para.RESOURCE_ID ,
Parl.TRACK_AS_LABOR_FLAG,
Par.ROLLUP_QUANTITY_FLAG ,
Par.UNIT_OF_MEASURE,
PT.wbs_level
FROM
PA_TXN_ACCUM PTA,
PA_TASKS PT,
GL_PERIODS GPS,
PA_IMPLEMENTATIONS PI,
PA_RESOURCE_ACCUM_DETAILS Para,
PA_RESOURCES Par,
PA_RESOURCE_LIST_MEMBERS Parl
Where Parl.resource_list_id = nvl(x_resource_list_id,Parl.resource_list_id) and
Para.Resource_list_id = Parl.Resource_list_id and
Para.Resource_list_member_id = Parl.Resource_list_member_id and
Para.Resource_id = Par.Resource_Id and
PTA.Project_Id = x_project_id and
nvl(parl.migration_code,'-99') <> 'N' and
(PTA.ACTUAL_COST_Rollup_flag = DECODE(x_Actual_Cost_Flag,'Y','Y','X')
OR PTA.REVENUE_Rollup_flag = DECODE(x_revenue_Flag,'Y','Y','X')
OR PTA.CMT_Rollup_flag = DECODE(x_commitments_Flag,'Y','Y','X')
OR pa_proj_accum_main.x_summ_process = 'RL') and
gps.period_set_name = pi.period_set_name and
/* Commented for bug 4631058 gps.period_type = pi.pa_period_type and */
gps.adjustment_period_flag = 'N' and
-- Removed the fix done for Bug# 5019025
gps.period_name = decode(x_impl_opt,'PA',PTA.pa_period,'GL',PTA.gl_period) and
trunc(gps.END_DATE) <= x_current_end_date and -- added trunc for the bug 4532088
PT.task_id = PTA.Task_id and
Para.Txn_Accum_id = PTA.Txn_Accum_id
union
select
PTA.TXN_ACCUM_ID,
0 parent_task_id,
0 task_id,
PTA.PA_PERIOD,
PTA.GL_PERIOD,
decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_REVENUE,0),NVL(PTA.I_TOT_REVENUE,0)) I_TOT_REVENUE,
decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_RAW_COST,0),NVL(PTA.I_TOT_RAW_COST,0)) I_TOT_RAW_COST,
decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BURDENED_COST,0),NVL(PTA.I_TOT_BURDENED_COST,0)) I_TOT_BURDENED_COST,
decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_QUANTITY,0),NVL(PTA.I_TOT_QUANTITY,0)) I_TOT_QUANTITY,
decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_LABOR_HOURS,0),NVL(PTA.I_TOT_LABOR_HOURS,0)) I_TOT_LABOR_HOURS,
decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_RAW_COST,0),NVL(PTA.I_TOT_BILLABLE_RAW_COST,0)) I_TOT_BILLABLE_RAW_COST ,
decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_BURDENED_COST,0),NVL(PTA.I_TOT_BILLABLE_BURDENED_COST,0)) I_TOT_BILLABLE_BURDENED_COST,
decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_QUANTITY,0),NVL(PTA.I_TOT_BILLABLE_QUANTITY,0))I_TOT_BILLABLE_QUANTITY,
decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_LABOR_HOURS,0),NVL(PTA.I_TOT_BILLABLE_LABOR_HOURS,0)) I_TOT_BILLABLE_LABOR_HOURS,
NVL(PTA.TOT_CMT_RAW_COST,0) TOT_CMT_RAW_COST,
NVL(PTA.TOT_CMT_BURDENED_COST,0) TOT_CMT_BURDENED_COST,
NVL(PTA.TOT_CMT_QUANTITY,0) TOT_CMT_QUANTITY,
PTA.actual_cost_rollup_flag,
PTA.revenue_rollup_flag,
PTA.cmt_rollup_flag,
GPS.PERIOD_YEAR,
Para.RESOURCE_LIST_ASSIGNMENT_ID,
Para.RESOURCE_LIST_ID,
Para.RESOURCE_LIST_MEMBER_ID,
Para.RESOURCE_ID ,
Parl.TRACK_AS_LABOR_FLAG,
Par.ROLLUP_QUANTITY_FLAG ,
Par.UNIT_OF_MEASURE,
0 wbs_level
FROM
PA_TXN_ACCUM PTA,
GL_PERIODS GPS,
PA_IMPLEMENTATIONS PI,
PA_RESOURCE_ACCUM_DETAILS Para,
PA_RESOURCES Par,
PA_RESOURCE_LIST_MEMBERS Parl
Where Parl.resource_list_id = nvl(x_resource_list_id,Parl.resource_list_id) and
Para.Resource_list_id = Parl.Resource_list_id and
Para.Resource_list_member_id = Parl.Resource_list_member_id and
Para.Resource_id = Par.Resource_Id and
PTA.Project_Id = x_project_id and
nvl(parl.migration_code,'-99') <> 'N' and
(PTA.ACTUAL_COST_Rollup_flag = DECODE(x_Actual_Cost_Flag,'Y','Y','X')
OR PTA.REVENUE_Rollup_flag = DECODE(x_revenue_Flag,'Y','Y','X')
OR PTA.CMT_Rollup_flag = DECODE(x_commitments_Flag,'Y','Y','X')
OR pa_proj_accum_main.x_summ_process = 'RL') and
gps.period_set_name = pi.period_set_name and
/* Commented for bug 4631058 gps.period_type = pi.pa_period_type and */
gps.adjustment_period_flag = 'N' and
-- Removed the fix done for Bug# 5019025
gps.period_name = decode(x_impl_opt,'PA',PTA.pa_period,'GL',PTA.gl_period) and
trunc(gps.END_DATE) <= x_current_end_date and -- added trunc for the bug 4532088
Para.Txn_Accum_id = PTA.Txn_Accum_id
Order By 2,29,3,24; --Parent_Task_id,WBS_Level,Task_id,Para.Resource_List_Member_id;
SELECT DISTINCT
PTA.TXN_ACCUM_ID,
nvl(PT.parent_task_id,nvl(pt.task_id,0)) top_task_id,
PTA.TASK_ID,
PTA.PA_PERIOD,
PTA.GL_PERIOD,
NVL(PTA.I_TOT_REVENUE,0) I_TOT_REVENUE,
NVL(PTA.I_TOT_RAW_COST,0) I_TOT_RAW_COST,
NVL(PTA.I_TOT_BURDENED_COST,0) I_TOT_BURDENED_COST,
NVL(PTA.I_TOT_QUANTITY,0) I_TOT_QUANTITY,
NVL(PTA.I_TOT_LABOR_HOURS,0) I_TOT_LABOR_HOURS,
NVL(PTA.I_TOT_BILLABLE_RAW_COST,0) I_TOT_BILLABLE_RAW_COST ,
NVL(PTA.I_TOT_BILLABLE_BURDENED_COST,0) I_TOT_BILLABLE_BURDENED_COST,
NVL(PTA.I_TOT_BILLABLE_QUANTITY,0) I_TOT_BILLABLE_QUANTITY,
NVL(PTA.I_TOT_BILLABLE_LABOR_HOURS,0) I_TOT_BILLABLE_LABOR_HOURS,
NVL(PTA.TOT_CMT_RAW_COST,0) TOT_CMT_RAW_COST,
NVL(PTA.TOT_CMT_BURDENED_COST,0) TOT_CMT_BURDENED_COST,
NVL(PTA.TOT_CMT_QUANTITY,0) TOT_CMT_QUANTITY,
PTA.actual_cost_rollup_flag,
PTA.revenue_rollup_flag,
PTA.cmt_rollup_flag,
PTA.UNIT_OF_MEASURE,
GPS.PERIOD_YEAR,
nvl(PT.WBS_Level,0)
FROM
PA_TXN_ACCUM PTA,
PA_TASKS PT,
GL_PERIODS GPS,
PA_IMPLEMENTATIONS PI
Where PTA.Project_Id = x_project_id
and PTA.task_id = PT.task_id(+)
and (PTA.ACTUAL_COST_Rollup_flag = DECODE(x_Actual_Cost_Flag,'Y','Y','X')
OR PTA.REVENUE_Rollup_flag = DECODE(x_revenue_Flag,'Y','Y','X')
OR PTA.CMT_Rollup_flag = DECODE(x_commitments_Flag,'Y','Y','X')
OR pa_proj_accum_main.x_summ_process = 'RL')
and gps.period_set_name = pi.period_set_name
/* Commented for bug 4631058 and gps.period_type = pi.pa_period_type */
and gps.adjustment_period_flag = 'N'
-- Removed the fix done for Bug# 5019025
and gps.period_name = decode(x_impl_opt,'PA',PTA.pa_period,'GL',PTA.gl_period)
and trunc(gps.END_DATE) <= x_current_end_date -- added trunc for the bug 4532088
Order By 2,23,3; --Parent_Task_id,WBS_Level,Task_id
-- (Update only ITD,YTD and PP figures )- Task level figures
-- without resources
IF x_txn_accum_rec.PERIOD_YEAR = x_current_year THEN
IF x_actual_cost_flag = 'Y' and
x_txn_accum_rec.actual_cost_rollup_flag = 'Y' THEN
New_raw_cost_itd := New_raw_cost_itd +
NVL(x_txn_accum_rec.I_TOT_RAW_COST,0);
-- (Update only ITD and PP figures )-Task level
-- figures without resources
IF x_actual_cost_flag = 'Y' and
x_txn_accum_rec.actual_cost_rollup_flag = 'Y' THEN
New_raw_cost_itd := New_raw_cost_itd +
NVL(x_txn_accum_rec.I_TOT_RAW_COST,0);
-- (Update only ITD and YTD figures)- Task level
-- figures without resources
IF x_txn_accum_rec.PERIOD_YEAR = x_current_year
and pa_proj_accum_main.x_summ_process <> 'RL' Then
IF x_actual_cost_flag = 'Y' and
x_txn_accum_rec.actual_cost_rollup_flag = 'Y' THEN
New_raw_cost_itd := New_raw_cost_itd +
NVL(x_txn_accum_rec.I_TOT_RAW_COST,0);
-- current year (Update only ITD figures )-
-- Task level figures without resources
If pa_proj_accum_main.x_summ_process <> 'RL' then
IF x_actual_cost_flag = 'Y' and
x_txn_accum_rec.actual_cost_rollup_flag = 'Y' THEN
New_raw_cost_itd := New_raw_cost_itd +
NVL(x_txn_accum_rec.I_TOT_RAW_COST,0);
-- Store the value onto variables to be later updated on Project
-- Level (task = 0 and rlmid = 0) record.
if pa_proj_accum_main.x_summ_process <> 'RL' then
add_project_amounts;
-- (Update only ITD,YTD and PTD figures)-
-- Task level figures without resources
IF (x_commitments_flag = 'Y' and
x_res_accum_rec.cmt_rollup_flag = 'Y') or
pa_proj_accum_main.x_summ_process = 'RL' THEN
New_cmt_quantity_itd := New_cmt_quantity_itd
+ x_cmt_quantity;
-- (Update only ITD,YTD and PP figures )- Task level figures
-- without resources
IF x_res_accum_rec.PERIOD_YEAR = x_current_year THEN
IF (x_actual_cost_flag = 'Y' and
x_res_accum_rec.actual_cost_rollup_flag = 'Y') or
pa_proj_accum_main.x_summ_process = 'RL' THEN
New_raw_cost_itd := New_raw_cost_itd +
NVL(x_res_accum_rec.I_TOT_RAW_COST,0);
-- (Update only ITD and PP figures )-Task level
-- figures without resources
IF (x_actual_cost_flag = 'Y' and
x_res_accum_rec.actual_cost_rollup_flag = 'Y') or
pa_proj_accum_main.x_summ_process = 'RL' THEN
New_raw_cost_itd := New_raw_cost_itd +
NVL(x_res_accum_rec.I_TOT_RAW_COST,0);
-- (Update only ITD and YTD figures)- Task level
-- figures without resources
IF x_res_accum_rec.PERIOD_YEAR = x_current_year Then
IF (x_actual_cost_flag = 'Y' and
x_res_accum_rec.actual_cost_rollup_flag = 'Y') or
pa_proj_accum_main.x_summ_process = 'RL' THEN
New_raw_cost_itd := New_raw_cost_itd +
NVL(x_res_accum_rec.I_TOT_RAW_COST,0);
-- current year (Update only ITD figures )-
-- Task level figures without resources
IF (x_actual_cost_flag = 'Y' and
x_res_accum_rec.actual_cost_rollup_flag = 'Y') or
pa_proj_accum_main.x_summ_process = 'RL' THEN
New_raw_cost_itd := New_raw_cost_itd +
NVL(x_res_accum_rec.I_TOT_RAW_COST,0);
Update PA_TXN_ACCUM Set
TOT_REVENUE = NVL(TOT_REVENUE,0) + NVL(I_TOT_REVENUE,0),
TOT_RAW_COST = NVL(TOT_RAW_COST,0) + NVL(I_TOT_RAW_COST,0),
TOT_BURDENED_COST = NVL(TOT_BURDENED_COST,0) +
NVL(I_TOT_BURDENED_COST,0),
TOT_LABOR_HOURS = NVL(TOT_LABOR_HOURS,0) +
NVL(I_TOT_LABOR_HOURS,0),
TOT_QUANTITY = NVL(TOT_QUANTITY,0) + NVL(I_TOT_QUANTITY,0),
TOT_BILLABLE_QUANTITY = NVL(TOT_BILLABLE_QUANTITY,0) +
NVL(I_TOT_BILLABLE_QUANTITY,0),
TOT_BILLABLE_RAW_COST = NVL(TOT_BILLABLE_RAW_COST,0) +
NVL(I_TOT_BILLABLE_RAW_COST,0),
TOT_BILLABLE_BURDENED_COST = NVL(TOT_BILLABLE_BURDENED_COST,0) +
NVL(I_TOT_BILLABLE_BURDENED_COST,0),
TOT_BILLABLE_LABOR_HOURS = NVL(TOT_BILLABLE_LABOR_HOURS,0) +
NVL(I_TOT_BILLABLE_LABOR_HOURS,0),
I_TOT_REVENUE = 0,
I_TOT_RAW_COST = 0,
I_TOT_BURDENED_COST = 0,
I_TOT_LABOR_HOURS = 0,
I_TOT_QUANTITY = 0,
I_TOT_BILLABLE_QUANTITY = 0,
I_TOT_BILLABLE_RAW_COST = 0,
I_TOT_BILLABLE_BURDENED_COST = 0,
I_TOT_BILLABLE_LABOR_HOURS = 0,
ACTUAL_COST_ROLLUP_FLAG = decode(x_actual_cost_flag,'Y','N',actual_cost_rollup_flag),
REVENUE_ROLLUP_FLAG = decode(x_revenue_flag,'Y','N',revenue_rollup_flag),
CMT_ROLLUP_FLAG = decode(x_commitments_flag,'Y','N',cmt_rollup_flag),
last_updated_by = pa_proj_accum_main.x_last_updated_by,
last_update_date = SYSDATE,
request_id = pa_proj_accum_main.x_request_id,
program_application_id =
pa_proj_accum_main.x_program_application_id,
program_id = pa_proj_accum_main.x_program_id,
program_update_date = SYSDATE
Where TXN_ACCUM_ID = x_txn_accum_rec.txn_accum_id;
UPDATE Pa_Project_Accum_actuals PAA SET
Raw_cost_itd = nvl(raw_cost_itd,0) + Tsk_raw_cost_itd,
Raw_cost_ytd = nvl(raw_cost_ytd,0) + Tsk_raw_cost_ytd,
Raw_cost_pp = nvl(raw_cost_pp,0) + Tsk_raw_cost_pp,
Raw_cost_ptd = nvl(raw_cost_ptd,0) + Tsk_raw_cost_ptd,
billable_raw_cost_itd = nvl(billable_raw_cost_itd,0) +
Tsk_bill_raw_cost_itd,
billable_raw_cost_ytd = nvl(billable_raw_cost_ytd,0) +
Tsk_bill_raw_cost_ytd,
billable_raw_cost_pp = nvl(billable_raw_cost_pp,0) +
Tsk_bill_raw_cost_pp,
billable_raw_cost_ptd = nvl(billable_raw_cost_ptd,0) +
Tsk_bill_raw_cost_ptd,
burdened_cost_itd = nvl(burdened_cost_itd,0) +
Tsk_burd_cost_itd,
burdened_cost_ytd = nvl(burdened_cost_ytd,0) + Tsk_burd_cost_ytd,
burdened_cost_pp = nvl(burdened_cost_pp,0) + Tsk_burd_cost_pp,
burdened_cost_ptd = nvl(burdened_cost_ptd,0) + Tsk_burd_cost_ptd,
billable_burdened_cost_itd = nvl(billable_burdened_cost_itd,0) + Tsk_bill_burd_cost_itd,
billable_burdened_cost_ytd = nvl(billable_burdened_cost_ytd,0) + Tsk_bill_burd_cost_ytd,
billable_burdened_cost_pp = nvl(billable_burdened_cost_pp,0) + Tsk_bill_burd_cost_pp,
billable_burdened_cost_ptd = nvl(billable_burdened_cost_ptd,0) + Tsk_bill_burd_cost_ptd,
quantity_itd = nvl(quantity_itd,0) + Tsk_quantity_itd,
quantity_ytd = nvl(quantity_ytd,0) + Tsk_quantity_ytd,
quantity_pp = nvl(quantity_pp,0) + Tsk_quantity_pp,
quantity_ptd = nvl(quantity_ptd,0) + Tsk_quantity_ptd,
labor_hours_itd = nvl(labor_hours_itd,0) + Tsk_labor_hours_itd,
labor_hours_ytd = nvl(labor_hours_ytd,0) + Tsk_labor_hours_ytd,
labor_hours_pp = nvl(labor_hours_pp,0) + Tsk_labor_hours_pp,
labor_hours_ptd = nvl(labor_hours_ptd,0) + Tsk_labor_hours_ptd,
billable_quantity_itd = nvl(billable_quantity_itd,0) + Tsk_bill_quantity_itd,
billable_quantity_ytd = nvl(billable_quantity_ytd,0) + Tsk_bill_quantity_ytd,
billable_quantity_pp = nvl(billable_quantity_pp,0) + Tsk_bill_quantity_pp,
billable_quantity_ptd = nvl(billable_quantity_ptd,0) + Tsk_bill_quantity_ptd,
billable_labor_hours_itd = nvl(billable_labor_hours_itd,0) + Tsk_bill_labor_hours_itd,
billable_labor_hours_ytd = nvl(billable_labor_hours_ytd,0) + Tsk_bill_labor_hours_ytd,
billable_labor_hours_pp = nvl(billable_labor_hours_pp,0) + Tsk_bill_labor_hours_pp,
billable_labor_hours_ptd = nvl(billable_labor_hours_ptd,0) + Tsk_bill_labor_hours_ptd,
revenue_itd = nvl(revenue_itd,0) + Tsk_revenue_itd,
revenue_ytd = nvl(revenue_ytd,0) + Tsk_revenue_ytd,
revenue_pp = nvl(revenue_pp,0) + Tsk_revenue_pp,
revenue_ptd = nvl(revenue_ptd,0) + Tsk_revenue_ptd,
txn_unit_of_measure = NULL,
request_id = pa_proj_accum_main.x_request_id,
last_updated_by = pa_proj_accum_main.x_last_updated_by,
last_update_date = Trunc(sysdate),
creation_date = Trunc(Sysdate),
created_by = pa_proj_accum_main.x_created_by,
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 = 0 and
Pah.Task_id = 0);
Select project_accum_id into v_accum_id
from pa_project_accum_headers
where project_id = x_project_id
and task_id = 0
and resource_list_member_id = 0;
Insert into PA_PROJECT_ACCUM_ACTUALS (
PROJECT_ACCUM_ID,RAW_COST_ITD,RAW_COST_YTD,RAW_COST_PP,RAW_COST_PTD,
BILLABLE_RAW_COST_ITD,BILLABLE_RAW_COST_YTD,BILLABLE_RAW_COST_PP,
BILLABLE_RAW_COST_PTD,BURDENED_COST_ITD,BURDENED_COST_YTD,
BURDENED_COST_PP,BURDENED_COST_PTD,BILLABLE_BURDENED_COST_ITD,
BILLABLE_BURDENED_COST_YTD,BILLABLE_BURDENED_COST_PP,
BILLABLE_BURDENED_COST_PTD,QUANTITY_ITD,QUANTITY_YTD,QUANTITY_PP,
QUANTITY_PTD,LABOR_HOURS_ITD,LABOR_HOURS_YTD,LABOR_HOURS_PP,
LABOR_HOURS_PTD,BILLABLE_QUANTITY_ITD,BILLABLE_QUANTITY_YTD,
BILLABLE_QUANTITY_PP,BILLABLE_QUANTITY_PTD,
BILLABLE_LABOR_HOURS_ITD,BILLABLE_LABOR_HOURS_YTD,
BILLABLE_LABOR_HOURS_PP,BILLABLE_LABOR_HOURS_PTD,REVENUE_ITD,
REVENUE_YTD,REVENUE_PP,REVENUE_PTD,TXN_UNIT_OF_MEASURE,
REQUEST_ID,LAST_UPDATED_BY,LAST_UPDATE_DATE,CREATION_DATE,
CREATED_BY,LAST_UPDATE_LOGIN)
Values (V_Accum_id,
Tsk_raw_cost_itd,
Tsk_raw_cost_ytd,
Tsk_raw_cost_pp,
Tsk_raw_cost_ptd,
Tsk_bill_raw_cost_itd,
Tsk_bill_raw_cost_ytd,
Tsk_bill_raw_cost_pp,
Tsk_bill_raw_cost_ptd,
Tsk_burd_cost_itd,
Tsk_burd_cost_ytd,
Tsk_burd_cost_pp,
Tsk_burd_cost_ptd,
Tsk_bill_burd_cost_itd,
Tsk_bill_burd_cost_ytd,
Tsk_bill_burd_cost_pp,
Tsk_bill_burd_cost_ptd,
Tsk_quantity_itd,
Tsk_quantity_ytd,
Tsk_quantity_pp,
Tsk_quantity_ptd,
Tsk_labor_hours_itd,
Tsk_labor_hours_ytd,
Tsk_labor_hours_pp,
Tsk_labor_hours_ptd,
Tsk_bill_quantity_itd,
Tsk_bill_quantity_ytd,
Tsk_bill_quantity_pp,
Tsk_bill_quantity_ptd,
Tsk_bill_labor_hours_itd,
Tsk_bill_labor_hours_ytd,
Tsk_bill_labor_hours_pp,
Tsk_bill_labor_hours_ptd,
Tsk_revenue_itd,
Tsk_revenue_ytd,
Tsk_revenue_pp,
Tsk_revenue_ptd,
NULL,
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);
UPDATE Pa_Project_Accum_Commitments PAA SET
Cmt_Raw_cost_itd = nvl(Cmt_Raw_cost_itd,0) + Tsk_cmt_raw_cost_itd,
Cmt_Raw_cost_ytd = nvl(Cmt_Raw_cost_ytd,0) + Tsk_cmt_raw_cost_ytd,
Cmt_Raw_cost_pp = nvl(Cmt_Raw_cost_pp,0) + Tsk_cmt_raw_cost_pp,
Cmt_Raw_cost_ptd = nvl(Cmt_Raw_cost_ptd,0) + Tsk_cmt_raw_cost_ptd,
Cmt_burdened_cost_itd = nvl(Cmt_burdened_cost_itd,0) + Tsk_cmt_burd_cost_itd,
Cmt_burdened_cost_ytd = nvl(Cmt_burdened_cost_ytd,0) + Tsk_cmt_burd_cost_ytd,
Cmt_burdened_cost_pp = nvl(Cmt_burdened_cost_pp,0) + Tsk_cmt_burd_cost_pp,
Cmt_burdened_cost_ptd = nvl(Cmt_burdened_cost_ptd,0) + Tsk_cmt_burd_cost_ptd,
Cmt_quantity_itd = nvl(Cmt_quantity_itd,0) + Tsk_cmt_quantity_itd,
Cmt_quantity_ytd = nvl(Cmt_quantity_ytd,0) + Tsk_cmt_quantity_ytd,
Cmt_quantity_pp = nvl(Cmt_quantity_pp,0) + Tsk_cmt_quantity_pp,
Cmt_quantity_ptd = nvl(Cmt_quantity_ptd,0) + Tsk_cmt_quantity_ptd,
cmt_unit_of_measure = NULL,
request_id = pa_proj_accum_main.x_request_id,
last_updated_by = pa_proj_accum_main.x_last_updated_by,
last_update_date = Trunc(sysdate),
creation_date = Trunc(Sysdate),
created_by = pa_proj_accum_main.x_created_by,
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 = 0 and
Pah.Task_id = 0);
Select project_accum_id into v_accum_id
from pa_project_accum_headers
where project_id = x_project_id
and task_id = 0
and resource_list_member_id = 0;
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,
LAST_UPDATED_BY,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,
LAST_UPDATE_LOGIN)
Values (V_Accum_id,
Tsk_cmt_raw_cost_itd,
Tsk_cmt_raw_cost_ytd,
Tsk_cmt_raw_cost_pp,
Tsk_cmt_raw_cost_ptd,
Tsk_cmt_burd_cost_itd,
Tsk_cmt_burd_cost_ytd,
Tsk_cmt_burd_cost_pp,
Tsk_cmt_burd_cost_ptd,
Tsk_cmt_quantity_itd,
Tsk_cmt_quantity_ytd,
Tsk_cmt_quantity_pp,
Tsk_cmt_quantity_ptd,
NULL,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);
update pa_resource_list_assignments
set resource_list_accumulated_flag = 'Y'
where project_id = x_project_id
and resource_list_id = nvl(x_resource_list_id,resource_list_id);
SELECT project_accum_id INTO V_accum_id
FROM Pa_Project_Accum_Headers PAH
WHERE PAH.Project_id = x_project_id
AND PAH.Task_id = x_task_id
AND PAH.Resource_List_Member_id = x_resource_list_member_id;
Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
From Dual;
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 (v_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 );
Insert into PA_PROJECT_ACCUM_ACTUALS (
PROJECT_ACCUM_ID,RAW_COST_ITD,RAW_COST_YTD,RAW_COST_PP,RAW_COST_PTD,
BILLABLE_RAW_COST_ITD,BILLABLE_RAW_COST_YTD,BILLABLE_RAW_COST_PP,
BILLABLE_RAW_COST_PTD,BURDENED_COST_ITD,BURDENED_COST_YTD,
BURDENED_COST_PP,BURDENED_COST_PTD,BILLABLE_BURDENED_COST_ITD,
BILLABLE_BURDENED_COST_YTD,BILLABLE_BURDENED_COST_PP,
BILLABLE_BURDENED_COST_PTD,QUANTITY_ITD,QUANTITY_YTD,QUANTITY_PP,
QUANTITY_PTD,LABOR_HOURS_ITD,LABOR_HOURS_YTD,LABOR_HOURS_PP,
LABOR_HOURS_PTD,BILLABLE_QUANTITY_ITD,BILLABLE_QUANTITY_YTD,
BILLABLE_QUANTITY_PP,BILLABLE_QUANTITY_PTD,
BILLABLE_LABOR_HOURS_ITD,BILLABLE_LABOR_HOURS_YTD,
BILLABLE_LABOR_HOURS_PP,BILLABLE_LABOR_HOURS_PTD,REVENUE_ITD,
REVENUE_YTD,REVENUE_PP,REVENUE_PTD,TXN_UNIT_OF_MEASURE,
REQUEST_ID,LAST_UPDATED_BY,LAST_UPDATE_DATE,CREATION_DATE,
CREATED_BY,LAST_UPDATE_LOGIN)
Values (V_Accum_id,
New_raw_cost_itd,
New_raw_cost_ytd,
New_raw_cost_pp,
New_raw_cost_ptd,
New_bill_raw_cost_itd,
New_bill_raw_cost_ytd,
New_bill_raw_cost_pp,
New_bill_raw_cost_ptd,
New_burd_cost_itd,
New_burd_cost_ytd,
New_burd_cost_pp,
New_burd_cost_ptd,
New_bill_burd_cost_itd,
New_bill_burd_cost_ytd,
New_bill_burd_cost_pp,
New_bill_burd_cost_ptd,
New_quantity_itd,
New_quantity_ytd,
New_quantity_pp,
New_quantity_ptd,
New_labor_hours_itd,
New_labor_hours_ytd,
New_labor_hours_pp,
New_labor_hours_ptd,
New_bill_quantity_itd,
New_bill_quantity_ytd,
New_bill_quantity_pp,
New_bill_quantity_ptd,
New_bill_labor_hours_itd,
New_bill_labor_hours_ytd,
New_bill_labor_hours_pp,
New_bill_labor_hours_ptd,
New_revenue_itd,
New_revenue_ytd,
New_revenue_pp,
New_revenue_ptd,
NULL,
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);
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,
LAST_UPDATED_BY,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,
LAST_UPDATE_LOGIN)
Values (V_Accum_id,
New_cmt_raw_cost_itd,
New_cmt_raw_cost_ytd,
New_cmt_raw_cost_pp,
New_cmt_raw_cost_ptd,
New_cmt_burd_cost_itd,
New_cmt_burd_cost_ytd,
New_cmt_burd_cost_pp,
New_cmt_burd_cost_ptd,
New_cmt_quantity_itd,
New_cmt_quantity_ytd,
New_cmt_quantity_pp,
New_cmt_quantity_ptd,
NULL,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);
UPDATE Pa_Project_Accum_actuals PAA SET
Raw_cost_itd = nvl(Raw_cost_itd,0) + New_raw_cost_itd,
Raw_cost_ytd = nvl(Raw_cost_ytd,0) + New_raw_cost_ytd,
Raw_cost_pp = nvl(Raw_cost_pp,0) + New_raw_cost_pp,
Raw_cost_ptd = nvl(Raw_cost_ptd,0) + New_raw_cost_ptd,
billable_raw_cost_itd = nvl(billable_raw_cost_itd,0) + New_bill_raw_cost_itd,
billable_raw_cost_ytd = nvl(billable_raw_cost_ytd,0) + New_bill_raw_cost_ytd,
billable_raw_cost_pp = nvl(billable_raw_cost_pp,0) + New_bill_raw_cost_pp,
billable_raw_cost_ptd = nvl(billable_raw_cost_ptd,0) + New_bill_raw_cost_ptd,
burdened_cost_itd = nvl(burdened_cost_itd,0) + New_burd_cost_itd,
burdened_cost_ytd = nvl(burdened_cost_ytd,0) + New_burd_cost_ytd,
burdened_cost_pp = nvl(burdened_cost_pp,0) + New_burd_cost_pp,
burdened_cost_ptd = nvl(burdened_cost_ptd,0) + New_burd_cost_ptd,
billable_burdened_cost_itd = nvl(billable_burdened_cost_itd,0) + New_bill_burd_cost_itd,
billable_burdened_cost_ytd = nvl(billable_burdened_cost_ytd,0) + New_bill_burd_cost_ytd,
billable_burdened_cost_pp = nvl(billable_burdened_cost_pp,0) + New_bill_burd_cost_pp,
billable_burdened_cost_ptd = nvl(billable_burdened_cost_ptd,0) + New_bill_burd_cost_ptd,
quantity_itd = nvl(quantity_itd,0) + New_quantity_itd,
quantity_ytd = nvl(quantity_ytd,0) + New_quantity_ytd,
quantity_pp = nvl(quantity_pp,0) + New_quantity_pp,
quantity_ptd = nvl(quantity_ptd,0) + New_quantity_ptd,
labor_hours_itd = nvl(labor_hours_itd,0) + New_labor_hours_itd,
labor_hours_ytd = nvl(labor_hours_ytd,0) + New_labor_hours_ytd,
labor_hours_pp = nvl(labor_hours_pp,0) + New_labor_hours_pp,
labor_hours_ptd = nvl(labor_hours_ptd,0) + New_labor_hours_ptd,
billable_quantity_itd = nvl(billable_quantity_itd,0) + New_bill_quantity_itd,
billable_quantity_ytd = nvl(billable_quantity_ytd,0) + New_bill_quantity_ytd,
billable_quantity_pp = nvl(billable_quantity_pp,0) + New_bill_quantity_pp,
billable_quantity_ptd = nvl(billable_quantity_ptd,0) + New_bill_quantity_ptd,
billable_labor_hours_itd = nvl(billable_labor_hours_itd,0) + New_bill_labor_hours_itd,
billable_labor_hours_ytd = nvl(billable_labor_hours_ytd,0) + New_bill_labor_hours_ytd,
billable_labor_hours_pp = nvl(billable_labor_hours_pp,0) + New_bill_labor_hours_pp,
billable_labor_hours_ptd = nvl(billable_labor_hours_ptd,0) + New_bill_labor_hours_ptd,
revenue_itd = nvl(revenue_itd,0) + New_revenue_itd,
revenue_ytd = nvl(revenue_ytd,0) + New_revenue_ytd,
revenue_pp = nvl(revenue_pp,0) + New_revenue_pp,
revenue_ptd = nvl(revenue_ptd,0) + New_revenue_ptd,
txn_unit_of_measure = NULL,
request_id = pa_proj_accum_main.x_request_id,
last_updated_by = pa_proj_accum_main.x_last_updated_by,
last_update_date = Trunc(sysdate),
creation_date = Trunc(Sysdate),
created_by = pa_proj_accum_main.x_created_by,
last_update_login = pa_proj_accum_main.x_last_update_login
Where PAA.Project_Accum_id = v_accum_id;
Insert into PA_PROJECT_ACCUM_ACTUALS (
PROJECT_ACCUM_ID,RAW_COST_ITD,RAW_COST_YTD,RAW_COST_PP,RAW_COST_PTD,
BILLABLE_RAW_COST_ITD,BILLABLE_RAW_COST_YTD,BILLABLE_RAW_COST_PP,
BILLABLE_RAW_COST_PTD,BURDENED_COST_ITD,BURDENED_COST_YTD,
BURDENED_COST_PP,BURDENED_COST_PTD,BILLABLE_BURDENED_COST_ITD,
BILLABLE_BURDENED_COST_YTD,BILLABLE_BURDENED_COST_PP,
BILLABLE_BURDENED_COST_PTD,QUANTITY_ITD,QUANTITY_YTD,QUANTITY_PP,
QUANTITY_PTD,LABOR_HOURS_ITD,LABOR_HOURS_YTD,LABOR_HOURS_PP,
LABOR_HOURS_PTD,BILLABLE_QUANTITY_ITD,BILLABLE_QUANTITY_YTD,
BILLABLE_QUANTITY_PP,BILLABLE_QUANTITY_PTD,
BILLABLE_LABOR_HOURS_ITD,BILLABLE_LABOR_HOURS_YTD,
BILLABLE_LABOR_HOURS_PP,BILLABLE_LABOR_HOURS_PTD,REVENUE_ITD,
REVENUE_YTD,REVENUE_PP,REVENUE_PTD,TXN_UNIT_OF_MEASURE,
REQUEST_ID,LAST_UPDATED_BY,LAST_UPDATE_DATE,CREATION_DATE,
CREATED_BY,LAST_UPDATE_LOGIN)
Values (V_Accum_id,
New_raw_cost_itd,
New_raw_cost_ytd,
New_raw_cost_pp,
New_raw_cost_ptd,
New_bill_raw_cost_itd,
New_bill_raw_cost_ytd,
New_bill_raw_cost_pp,
New_bill_raw_cost_ptd,
New_burd_cost_itd,
New_burd_cost_ytd,
New_burd_cost_pp,
New_burd_cost_ptd,
New_bill_burd_cost_itd,
New_bill_burd_cost_ytd,
New_bill_burd_cost_pp,
New_bill_burd_cost_ptd,
New_quantity_itd,
New_quantity_ytd,
New_quantity_pp,
New_quantity_ptd,
New_labor_hours_itd,
New_labor_hours_ytd,
New_labor_hours_pp,
New_labor_hours_ptd,
New_bill_quantity_itd,
New_bill_quantity_ytd,
New_bill_quantity_pp,
New_bill_quantity_ptd,
New_bill_labor_hours_itd,
New_bill_labor_hours_ytd,
New_bill_labor_hours_pp,
New_bill_labor_hours_ptd,
New_revenue_itd,
New_revenue_ytd,
New_revenue_pp,
New_revenue_ptd,
NULL,
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);
UPDATE Pa_Project_Accum_Commitments PAA SET
Cmt_Raw_cost_itd = nvl(Cmt_Raw_cost_itd,0) + New_cmt_raw_cost_itd,
Cmt_Raw_cost_ytd = nvl(Cmt_Raw_cost_ytd,0) + New_cmt_raw_cost_ytd,
Cmt_Raw_cost_pp = nvl(Cmt_Raw_cost_pp,0) + New_cmt_raw_cost_pp,
Cmt_Raw_cost_ptd = nvl(Cmt_Raw_cost_ptd,0) + New_cmt_raw_cost_ptd,
Cmt_burdened_cost_itd = nvl(Cmt_burdened_cost_itd,0) + New_cmt_burd_cost_itd,
Cmt_burdened_cost_ytd = nvl(Cmt_burdened_cost_ytd,0) + New_cmt_burd_cost_ytd,
Cmt_burdened_cost_pp = nvl(Cmt_burdened_cost_pp,0) + New_cmt_burd_cost_pp,
Cmt_burdened_cost_ptd = nvl(Cmt_burdened_cost_ptd,0) + New_cmt_burd_cost_ptd,
Cmt_quantity_itd = nvl(Cmt_quantity_itd,0) + New_cmt_quantity_itd,
Cmt_quantity_ytd = nvl(Cmt_quantity_ytd,0) + New_cmt_quantity_ytd,
Cmt_quantity_pp = nvl(Cmt_quantity_pp,0) + New_cmt_quantity_pp,
Cmt_quantity_ptd = nvl(Cmt_quantity_ptd,0) + New_cmt_quantity_ptd,
cmt_unit_of_measure = NULL,
request_id = pa_proj_accum_main.x_request_id,
last_updated_by = pa_proj_accum_main.x_last_updated_by,
last_update_date = Trunc(sysdate),
creation_date = Trunc(Sysdate),
created_by = pa_proj_accum_main.x_created_by,
last_update_login = pa_proj_accum_main.x_last_update_login
Where PAA.Project_Accum_id = v_accum_id;
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,
LAST_UPDATED_BY,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,
LAST_UPDATE_LOGIN)
Values (V_Accum_id,
New_cmt_raw_cost_itd,
New_cmt_raw_cost_ytd,
New_cmt_raw_cost_pp,
New_cmt_raw_cost_ptd,
New_cmt_burd_cost_itd,
New_cmt_burd_cost_ytd,
New_cmt_burd_cost_pp,
New_cmt_burd_cost_ptd,
New_cmt_quantity_itd,
New_cmt_quantity_ytd,
New_cmt_quantity_pp,
New_cmt_quantity_ptd,
NULL,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);
SELECT project_accum_id INTO V_accum_id
FROM Pa_Project_Accum_Headers PAH
WHERE PAH.Project_id = x_project_id
AND PAH.Task_id = x_task_id
AND PAH.Resource_List_Member_id = x_resource_list_member_id;
Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
From Dual;
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 (v_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 );
Insert into PA_PROJECT_ACCUM_ACTUALS (
PROJECT_ACCUM_ID,RAW_COST_ITD,RAW_COST_YTD,RAW_COST_PP,RAW_COST_PTD,
BILLABLE_RAW_COST_ITD,BILLABLE_RAW_COST_YTD,BILLABLE_RAW_COST_PP,
BILLABLE_RAW_COST_PTD,BURDENED_COST_ITD,BURDENED_COST_YTD,
BURDENED_COST_PP,BURDENED_COST_PTD,BILLABLE_BURDENED_COST_ITD,
BILLABLE_BURDENED_COST_YTD,BILLABLE_BURDENED_COST_PP,
BILLABLE_BURDENED_COST_PTD,QUANTITY_ITD,QUANTITY_YTD,QUANTITY_PP,
QUANTITY_PTD,LABOR_HOURS_ITD,LABOR_HOURS_YTD,LABOR_HOURS_PP,
LABOR_HOURS_PTD,BILLABLE_QUANTITY_ITD,BILLABLE_QUANTITY_YTD,
BILLABLE_QUANTITY_PP,BILLABLE_QUANTITY_PTD,
BILLABLE_LABOR_HOURS_ITD,BILLABLE_LABOR_HOURS_YTD,
BILLABLE_LABOR_HOURS_PP,BILLABLE_LABOR_HOURS_PTD,REVENUE_ITD,
REVENUE_YTD,REVENUE_PP,REVENUE_PTD,TXN_UNIT_OF_MEASURE,
REQUEST_ID,LAST_UPDATED_BY,LAST_UPDATE_DATE,CREATION_DATE,
CREATED_BY,LAST_UPDATE_LOGIN)
Values (V_Accum_id,
Prt_raw_cost_itd,
Prt_raw_cost_ytd,
Prt_raw_cost_pp,
Prt_raw_cost_ptd,
Prt_bill_raw_cost_itd,
Prt_bill_raw_cost_ytd,
Prt_bill_raw_cost_pp,
Prt_bill_raw_cost_ptd,
Prt_burd_cost_itd,
Prt_burd_cost_ytd,
Prt_burd_cost_pp,
Prt_burd_cost_ptd,
Prt_bill_burd_cost_itd,
Prt_bill_burd_cost_ytd,
Prt_bill_burd_cost_pp,
Prt_bill_burd_cost_ptd,
Prt_quantity_itd,
Prt_quantity_ytd,
Prt_quantity_pp,
Prt_quantity_ptd,
Prt_labor_hours_itd,
Prt_labor_hours_ytd,
Prt_labor_hours_pp,
Prt_labor_hours_ptd,
Prt_bill_quantity_itd,
Prt_bill_quantity_ytd,
Prt_bill_quantity_pp,
Prt_bill_quantity_ptd,
Prt_bill_labor_hours_itd,
Prt_bill_labor_hours_ytd,
Prt_bill_labor_hours_pp,
Prt_bill_labor_hours_ptd,
Prt_revenue_itd,
Prt_revenue_ytd,
Prt_revenue_pp,
Prt_revenue_ptd,
NULL,
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);
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,
LAST_UPDATED_BY,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,
LAST_UPDATE_LOGIN)
Values (V_Accum_id,
Prt_cmt_raw_cost_itd,
Prt_cmt_raw_cost_ytd,
Prt_cmt_raw_cost_pp,
Prt_cmt_raw_cost_ptd,
Prt_cmt_burd_cost_itd,
Prt_cmt_burd_cost_ytd,
Prt_cmt_burd_cost_pp,
Prt_cmt_burd_cost_ptd,
Prt_cmt_quantity_itd,
Prt_cmt_quantity_ytd,
Prt_cmt_quantity_pp,
Prt_cmt_quantity_ptd,
NULL,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);
UPDATE Pa_Project_Accum_actuals PAA SET
Raw_cost_itd = nvl(Raw_cost_itd,0) + Prt_raw_cost_itd,
Raw_cost_ytd = nvl(Raw_cost_ytd,0) + Prt_raw_cost_ytd,
Raw_cost_pp = nvl(Raw_cost_pp,0) + Prt_raw_cost_pp,
Raw_cost_ptd = nvl(Raw_cost_ptd,0) + Prt_raw_cost_ptd,
billable_raw_cost_itd = nvl(billable_raw_cost_itd,0) + Prt_bill_raw_cost_itd,
billable_raw_cost_ytd = nvl(billable_raw_cost_ytd,0) + Prt_bill_raw_cost_ytd,
billable_raw_cost_pp = nvl(billable_raw_cost_pp,0) + Prt_bill_raw_cost_pp,
billable_raw_cost_ptd = nvl(billable_raw_cost_ptd,0) + Prt_bill_raw_cost_ptd,
burdened_cost_itd = nvl(burdened_cost_itd,0) + Prt_burd_cost_itd,
burdened_cost_ytd = nvl(burdened_cost_ytd,0) + Prt_burd_cost_ytd,
burdened_cost_pp = nvl(burdened_cost_pp,0) + Prt_burd_cost_pp,
burdened_cost_ptd = nvl(burdened_cost_ptd,0) + Prt_burd_cost_ptd,
billable_burdened_cost_itd = nvl(billable_burdened_cost_itd,0) + Prt_bill_burd_cost_itd,
billable_burdened_cost_ytd = nvl(billable_burdened_cost_ytd,0) + Prt_bill_burd_cost_ytd,
billable_burdened_cost_pp = nvl(billable_burdened_cost_pp,0) + Prt_bill_burd_cost_pp,
billable_burdened_cost_ptd = nvl(billable_burdened_cost_ptd,0) + Prt_bill_burd_cost_ptd,
quantity_itd = nvl(quantity_itd,0) + Prt_quantity_itd,
quantity_ytd = nvl(quantity_ytd,0) + Prt_quantity_ytd,
quantity_pp = nvl(quantity_pp,0) + Prt_quantity_pp,
quantity_ptd = nvl(quantity_ptd,0) + Prt_quantity_ptd,
labor_hours_itd = nvl(labor_hours_itd,0) + Prt_labor_hours_itd,
labor_hours_ytd = nvl(labor_hours_ytd,0) + Prt_labor_hours_ytd,
labor_hours_pp = nvl(labor_hours_pp,0) + Prt_labor_hours_pp,
labor_hours_ptd = nvl(labor_hours_ptd,0) + Prt_labor_hours_ptd,
billable_quantity_itd = nvl(billable_quantity_itd,0) + Prt_bill_quantity_itd,
billable_quantity_ytd = nvl(billable_quantity_ytd,0) + Prt_bill_quantity_ytd,
billable_quantity_pp = nvl(billable_quantity_pp,0) + Prt_bill_quantity_pp,
billable_quantity_ptd = nvl(billable_quantity_ptd,0) + Prt_bill_quantity_ptd,
billable_labor_hours_itd = nvl(billable_labor_hours_itd,0) + Prt_bill_labor_hours_itd,
billable_labor_hours_ytd = nvl(billable_labor_hours_ytd,0) + Prt_bill_labor_hours_ytd,
billable_labor_hours_pp = nvl(billable_labor_hours_pp,0) + Prt_bill_labor_hours_pp,
billable_labor_hours_ptd = nvl(billable_labor_hours_ptd,0) + Prt_bill_labor_hours_ptd,
revenue_itd = nvl(revenue_itd,0) + Prt_revenue_itd,
revenue_ytd = nvl(revenue_ytd,0) + Prt_revenue_ytd,
revenue_pp = nvl(revenue_pp,0) + Prt_revenue_pp,
revenue_ptd = nvl(revenue_ptd,0) + Prt_revenue_ptd,
txn_unit_of_measure = NULL,
request_id = pa_proj_accum_main.x_request_id,
last_updated_by = pa_proj_accum_main.x_last_updated_by,
last_update_date = Trunc(sysdate),
creation_date = Trunc(Sysdate),
created_by = pa_proj_accum_main.x_created_by,
last_update_login = pa_proj_accum_main.x_last_update_login
Where PAA.Project_Accum_id = v_accum_id;
Insert into PA_PROJECT_ACCUM_ACTUALS (
PROJECT_ACCUM_ID,RAW_COST_ITD,RAW_COST_YTD,RAW_COST_PP,RAW_COST_PTD,
BILLABLE_RAW_COST_ITD,BILLABLE_RAW_COST_YTD,BILLABLE_RAW_COST_PP,
BILLABLE_RAW_COST_PTD,BURDENED_COST_ITD,BURDENED_COST_YTD,
BURDENED_COST_PP,BURDENED_COST_PTD,BILLABLE_BURDENED_COST_ITD,
BILLABLE_BURDENED_COST_YTD,BILLABLE_BURDENED_COST_PP,
BILLABLE_BURDENED_COST_PTD,QUANTITY_ITD,QUANTITY_YTD,QUANTITY_PP,
QUANTITY_PTD,LABOR_HOURS_ITD,LABOR_HOURS_YTD,LABOR_HOURS_PP,
LABOR_HOURS_PTD,BILLABLE_QUANTITY_ITD,BILLABLE_QUANTITY_YTD,
BILLABLE_QUANTITY_PP,BILLABLE_QUANTITY_PTD,
BILLABLE_LABOR_HOURS_ITD,BILLABLE_LABOR_HOURS_YTD,
BILLABLE_LABOR_HOURS_PP,BILLABLE_LABOR_HOURS_PTD,REVENUE_ITD,
REVENUE_YTD,REVENUE_PP,REVENUE_PTD,TXN_UNIT_OF_MEASURE,
REQUEST_ID,LAST_UPDATED_BY,LAST_UPDATE_DATE,CREATION_DATE,
CREATED_BY,LAST_UPDATE_LOGIN)
Values (V_Accum_id,
Prt_raw_cost_itd,
Prt_raw_cost_ytd,
Prt_raw_cost_pp,
Prt_raw_cost_ptd,
Prt_bill_raw_cost_itd,
Prt_bill_raw_cost_ytd,
Prt_bill_raw_cost_pp,
Prt_bill_raw_cost_ptd,
Prt_burd_cost_itd,
Prt_burd_cost_ytd,
Prt_burd_cost_pp,
Prt_burd_cost_ptd,
Prt_bill_burd_cost_itd,
Prt_bill_burd_cost_ytd,
Prt_bill_burd_cost_pp,
Prt_bill_burd_cost_ptd,
Prt_quantity_itd,
Prt_quantity_ytd,
Prt_quantity_pp,
Prt_quantity_ptd,
Prt_labor_hours_itd,
Prt_labor_hours_ytd,
Prt_labor_hours_pp,
Prt_labor_hours_ptd,
Prt_bill_quantity_itd,
Prt_bill_quantity_ytd,
Prt_bill_quantity_pp,
Prt_bill_quantity_ptd,
Prt_bill_labor_hours_itd,
Prt_bill_labor_hours_ytd,
Prt_bill_labor_hours_pp,
Prt_bill_labor_hours_ptd,
Prt_revenue_itd,
Prt_revenue_ytd,
Prt_revenue_pp,
Prt_revenue_ptd,
NULL,
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);
UPDATE Pa_Project_Accum_Commitments PAA SET
Cmt_Raw_cost_itd = nvl(Cmt_Raw_cost_itd,0) + Prt_cmt_raw_cost_itd,
Cmt_Raw_cost_ytd = nvl(Cmt_Raw_cost_ytd,0) + Prt_cmt_raw_cost_ytd,
Cmt_Raw_cost_pp = nvl(Cmt_Raw_cost_pp,0) + Prt_cmt_raw_cost_pp,
Cmt_Raw_cost_ptd = nvl(Cmt_Raw_cost_ptd,0) + Prt_cmt_raw_cost_ptd,
Cmt_burdened_cost_itd = nvl(Cmt_burdened_cost_itd,0) + Prt_cmt_burd_cost_itd,
Cmt_burdened_cost_ytd = nvl(Cmt_burdened_cost_ytd,0) + Prt_cmt_burd_cost_ytd,
Cmt_burdened_cost_pp = nvl(Cmt_burdened_cost_pp,0) + Prt_cmt_burd_cost_pp,
Cmt_burdened_cost_ptd = nvl(Cmt_burdened_cost_ptd,0) + Prt_cmt_burd_cost_ptd,
Cmt_quantity_itd = nvl(Cmt_quantity_itd,0) + Prt_cmt_quantity_itd,
Cmt_quantity_ytd = nvl(Cmt_quantity_ytd,0) + Prt_cmt_quantity_ytd,
Cmt_quantity_pp = nvl(Cmt_quantity_pp,0) + Prt_cmt_quantity_pp,
Cmt_quantity_ptd = nvl(Cmt_quantity_ptd,0) + Prt_cmt_quantity_ptd,
cmt_unit_of_measure = NULL,
request_id = pa_proj_accum_main.x_request_id,
last_updated_by = pa_proj_accum_main.x_last_updated_by,
last_update_date = Trunc(sysdate),
creation_date = Trunc(Sysdate),
created_by = pa_proj_accum_main.x_created_by,
last_update_login = pa_proj_accum_main.x_last_update_login
Where PAA.Project_Accum_id = v_accum_id;
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,
LAST_UPDATED_BY,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,
LAST_UPDATE_LOGIN)
Values (V_Accum_id,
Prt_cmt_raw_cost_itd,
Prt_cmt_raw_cost_ytd,
Prt_cmt_raw_cost_pp,
Prt_cmt_raw_cost_ptd,
Prt_cmt_burd_cost_itd,
Prt_cmt_burd_cost_ytd,
Prt_cmt_burd_cost_pp,
Prt_cmt_burd_cost_ptd,
Prt_cmt_quantity_itd,
Prt_cmt_quantity_ytd,
Prt_cmt_quantity_pp,
Prt_cmt_quantity_ptd,
NULL,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);
SELECT task_id
FROM
pa_tasks pt
WHERE project_id = x_project_id
start with task_id = x_task_id
connect by prior parent_task_id = task_id;
Procedure Insert_Headers_tasks (X_project_id In Number,
x_task_id In Number,
x_current_period In Varchar2,
x_accum_id In Number,
x_err_stack In Out NOCOPY Varchar2,
x_err_stage In Out NOCOPY Varchar2,
x_err_code In Out NOCOPY Number ) IS
-- Insert_Headers_tasks - Inserts Header records in the
-- PA_PROJECT_ACCUM_HEADERS table
V_Old_Stack Varchar2(630);
x_err_stack||'->PA_PROCESS_ACCUM_ACTUALS.Insert_Headers_tasks';
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,
CREATION_DATE,REQUEST_ID,CREATED_BY,LAST_UPDATE_LOGIN )
Values (x_Accum_id,X_project_id,x_task_id,
x_current_period,
0,0,0,0,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),trunc(sysdate),
pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
End Insert_Headers_tasks;
Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
From Dual;
Insert_Headers_tasks
(X_project_id,
v_task_array(i),
x_current_period,
v_accum_id,
x_err_stack,
x_err_stage,
x_err_code);
Insert into PA_PROJECT_ACCUM_ACTUALS (
PROJECT_ACCUM_ID,RAW_COST_ITD,RAW_COST_YTD,RAW_COST_PP,RAW_COST_PTD,
BILLABLE_RAW_COST_ITD,BILLABLE_RAW_COST_YTD,BILLABLE_RAW_COST_PP,
BILLABLE_RAW_COST_PTD,BURDENED_COST_ITD,BURDENED_COST_YTD,
BURDENED_COST_PP,BURDENED_COST_PTD,BILLABLE_BURDENED_COST_ITD,
BILLABLE_BURDENED_COST_YTD,BILLABLE_BURDENED_COST_PP,
BILLABLE_BURDENED_COST_PTD,QUANTITY_ITD,QUANTITY_YTD,QUANTITY_PP,
QUANTITY_PTD,LABOR_HOURS_ITD,LABOR_HOURS_YTD,LABOR_HOURS_PP,
LABOR_HOURS_PTD,BILLABLE_QUANTITY_ITD,BILLABLE_QUANTITY_YTD,
BILLABLE_QUANTITY_PP,BILLABLE_QUANTITY_PTD,
BILLABLE_LABOR_HOURS_ITD,BILLABLE_LABOR_HOURS_YTD,
BILLABLE_LABOR_HOURS_PP,BILLABLE_LABOR_HOURS_PTD,REVENUE_ITD,
REVENUE_YTD,REVENUE_PP,REVENUE_PTD,TXN_UNIT_OF_MEASURE,
REQUEST_ID,LAST_UPDATED_BY,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,
LAST_UPDATE_LOGIN) Values
(V_Accum_id,0,0,0,0,
0,0,0,0,
0,0,
0,0,0,
0,0,0,
0,0,0,0,0,0,0,0,
0,0,0,0,0,0,
0,0,0,0,
0,0,NULL,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);
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;
Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
From Dual;
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);
Insert into PA_PROJECT_ACCUM_ACTUALS (
PROJECT_ACCUM_ID,RAW_COST_ITD,RAW_COST_YTD,RAW_COST_PP,RAW_COST_PTD,
BILLABLE_RAW_COST_ITD,BILLABLE_RAW_COST_YTD,BILLABLE_RAW_COST_PP,
BILLABLE_RAW_COST_PTD,BURDENED_COST_ITD,BURDENED_COST_YTD,
BURDENED_COST_PP,BURDENED_COST_PTD,BILLABLE_BURDENED_COST_ITD,
BILLABLE_BURDENED_COST_YTD,BILLABLE_BURDENED_COST_PP,
BILLABLE_BURDENED_COST_PTD,QUANTITY_ITD,QUANTITY_YTD,QUANTITY_PP,
QUANTITY_PTD,LABOR_HOURS_ITD,LABOR_HOURS_YTD,LABOR_HOURS_PP,
LABOR_HOURS_PTD,BILLABLE_QUANTITY_ITD,BILLABLE_QUANTITY_YTD,
BILLABLE_QUANTITY_PP,BILLABLE_QUANTITY_PTD,
BILLABLE_LABOR_HOURS_ITD,BILLABLE_LABOR_HOURS_YTD,
BILLABLE_LABOR_HOURS_PP,BILLABLE_LABOR_HOURS_PTD,REVENUE_ITD,
REVENUE_YTD,REVENUE_PP,REVENUE_PTD,TXN_UNIT_OF_MEASURE,
REQUEST_ID,LAST_UPDATED_BY,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,
LAST_UPDATE_LOGIN) Values
(V_Accum_id,0,0,0,0,
0,0,0,
0,0,0,
0,0,0,
0,0,0,
0,0,0,0,0,0,0,0,
0,0,0,0,
0,0,0,
0,0,0,0,
0,NULL,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);
Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
From Dual;
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);
Insert into PA_PROJECT_ACCUM_ACTUALS (
PROJECT_ACCUM_ID,RAW_COST_ITD,RAW_COST_YTD,RAW_COST_PP,RAW_COST_PTD,
BILLABLE_RAW_COST_ITD,BILLABLE_RAW_COST_YTD,BILLABLE_RAW_COST_PP,
BILLABLE_RAW_COST_PTD,BURDENED_COST_ITD,BURDENED_COST_YTD,
BURDENED_COST_PP,BURDENED_COST_PTD,BILLABLE_BURDENED_COST_ITD,
BILLABLE_BURDENED_COST_YTD,BILLABLE_BURDENED_COST_PP,
BILLABLE_BURDENED_COST_PTD,QUANTITY_ITD,QUANTITY_YTD,QUANTITY_PP,
QUANTITY_PTD,LABOR_HOURS_ITD,LABOR_HOURS_YTD,LABOR_HOURS_PP,
LABOR_HOURS_PTD,BILLABLE_QUANTITY_ITD,BILLABLE_QUANTITY_YTD,
BILLABLE_QUANTITY_PP,BILLABLE_QUANTITY_PTD,
BILLABLE_LABOR_HOURS_ITD,BILLABLE_LABOR_HOURS_YTD,
BILLABLE_LABOR_HOURS_PP,BILLABLE_LABOR_HOURS_PTD,REVENUE_ITD,
REVENUE_YTD,REVENUE_PP,REVENUE_PTD,TXN_UNIT_OF_MEASURE,
REQUEST_ID,LAST_UPDATED_BY,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,
LAST_UPDATE_LOGIN) Values
(V_Accum_id,0,0,0,0,
0,0,0,
0,0,0,
0,0,0,
0,0,0,
0,0,0,0,0,0,0,0,
0,0,0,0,
0,0,0,
0,0,0,0,
0,NULL,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);
Update PA_PROJECT_ACCUM_ACTUALS SET
RAW_COST_YTD = 0,
RAW_COST_PP = RAW_COST_PTD,
RAW_COST_PTD = 0,
BILLABLE_RAW_COST_YTD = 0,
BILLABLE_RAW_COST_PP =BILLABLE_RAW_COST_PTD,
BILLABLE_RAW_COST_PTD = 0,BURDENED_COST_YTD = 0,
BURDENED_COST_PP = BURDENED_COST_PTD,
BURDENED_COST_PTD = 0,
BILLABLE_BURDENED_COST_YTD = 0,
BILLABLE_BURDENED_COST_PP = BILLABLE_BURDENED_COST_PTD,
BILLABLE_BURDENED_COST_PTD = 0,QUANTITY_YTD = 0,
QUANTITY_PP = QUANTITY_PTD,
QUANTITY_PTD = 0,LABOR_HOURS_YTD = 0,
LABOR_HOURS_PP = LABOR_HOURS_PTD,
LABOR_HOURS_PTD = 0,BILLABLE_QUANTITY_YTD = 0,
BILLABLE_QUANTITY_PP = BILLABLE_QUANTITY_PTD,
BILLABLE_QUANTITY_PTD = 0,
BILLABLE_LABOR_HOURS_YTD = 0,
BILLABLE_LABOR_HOURS_PP = BILLABLE_LABOR_HOURS_PTD,
BILLABLE_LABOR_HOURS_PTD = 0,REVENUE_YTD = 0,
REVENUE_PP = REVENUE_PTD,REVENUE_PTD = 0,
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 Project_Accum_id IN
(Select Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH Where
PAH.Project_Id = x_project_id);
Update PA_PROJECT_ACCUM_ACTUALS SET
RAW_COST_PP = RAW_COST_PTD,
RAW_COST_PTD = 0,
BILLABLE_RAW_COST_PP = BILLABLE_RAW_COST_PTD,
BILLABLE_RAW_COST_PTD = 0,
BURDENED_COST_PP = BURDENED_COST_PTD,
BURDENED_COST_PTD = 0,
BILLABLE_BURDENED_COST_PP = BILLABLE_BURDENED_COST_PTD,
BILLABLE_BURDENED_COST_PTD = 0,
QUANTITY_PP = QUANTITY_PTD,
QUANTITY_PTD = 0,
LABOR_HOURS_PP = LABOR_HOURS_PTD,
LABOR_HOURS_PTD = 0,
BILLABLE_QUANTITY_PP = BILLABLE_QUANTITY_PTD,
BILLABLE_QUANTITY_PTD = 0,
BILLABLE_LABOR_HOURS_PP = BILLABLE_LABOR_HOURS_PTD,
BILLABLE_LABOR_HOURS_PTD = 0,
REVENUE_PP = REVENUE_PTD,
REVENUE_PTD = 0,
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 Project_Accum_id IN
(Select Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH Where
PAH.Project_Id = x_project_id);
Update PA_PROJECT_ACCUM_ACTUALS SET
RAW_COST_YTD = 0,RAW_COST_PP = 0,
RAW_COST_PTD = 0,
BILLABLE_RAW_COST_YTD = 0,
BILLABLE_RAW_COST_PP =0,
BILLABLE_RAW_COST_PTD = 0,BURDENED_COST_YTD = 0,
BURDENED_COST_PP = 0,
BURDENED_COST_PTD = 0,
BILLABLE_BURDENED_COST_YTD = 0,
BILLABLE_BURDENED_COST_PP = 0,
BILLABLE_BURDENED_COST_PTD = 0,QUANTITY_YTD = 0,
QUANTITY_PP = 0,
QUANTITY_PTD = 0,LABOR_HOURS_YTD = 0,
LABOR_HOURS_PP = 0,
LABOR_HOURS_PTD = 0,BILLABLE_QUANTITY_YTD = 0,
BILLABLE_QUANTITY_PP = 0,
BILLABLE_QUANTITY_PTD = 0,
BILLABLE_LABOR_HOURS_YTD = 0,
BILLABLE_LABOR_HOURS_PP = 0,
BILLABLE_LABOR_HOURS_PTD = 0,REVENUE_YTD = 0,
REVENUE_PP = 0,REVENUE_PTD = 0,
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 Project_Accum_id IN
(Select Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH Where
PAH.Project_Id = x_project_id);
Update PA_PROJECT_ACCUM_ACTUALS SET
RAW_COST_PP = 0,
RAW_COST_PTD = 0,
BILLABLE_RAW_COST_PP = 0,
BILLABLE_RAW_COST_PTD = 0,
BURDENED_COST_PP = 0,
BURDENED_COST_PTD = 0,
BILLABLE_BURDENED_COST_PP = 0,
BILLABLE_BURDENED_COST_PTD = 0,
QUANTITY_PP = 0,
QUANTITY_PTD = 0,
LABOR_HOURS_PP = 0,
LABOR_HOURS_PTD = 0,
BILLABLE_QUANTITY_PP = 0,
BILLABLE_QUANTITY_PTD = 0,
BILLABLE_LABOR_HOURS_PP = 0,
BILLABLE_LABOR_HOURS_PTD = 0,
REVENUE_PP = 0,
REVENUE_PTD = 0,
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 Project_Accum_id IN
(Select Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH Where
PAH.Project_Id = x_project_id);
Update PA_PROJECT_ACCUM_BUDGETS SET
BASE_RAW_COST_YTD = 0,
BASE_RAW_COST_PP = BASE_RAW_COST_PTD,
BASE_RAW_COST_PTD = 0,
ORIG_RAW_COST_YTD = 0,
ORIG_RAW_COST_PP = ORIG_RAW_COST_PTD,
ORIG_RAW_COST_PTD = 0,
BASE_BURDENED_COST_YTD = 0,
BASE_BURDENED_COST_PP = BASE_BURDENED_COST_PTD,
BASE_BURDENED_COST_PTD = 0,
ORIG_BURDENED_COST_YTD = 0,
ORIG_BURDENED_COST_PP = ORIG_BURDENED_COST_PTD,
ORIG_BURDENED_COST_PTD = 0,
BASE_QUANTITY_YTD = 0,
BASE_QUANTITY_PP = BASE_QUANTITY_PTD,
BASE_QUANTITY_PTD = 0,
ORIG_QUANTITY_YTD = 0,
ORIG_QUANTITY_PP = ORIG_QUANTITY_PTD,
ORIG_QUANTITY_PTD = 0,
BASE_LABOR_HOURS_YTD = 0,
BASE_LABOR_HOURS_PP = BASE_LABOR_HOURS_PTD,
BASE_LABOR_HOURS_PTD = 0,
ORIG_LABOR_HOURS_YTD = 0,
ORIG_LABOR_HOURS_PP = ORIG_LABOR_HOURS_PTD,
ORIG_LABOR_HOURS_PTD = 0,
BASE_REVENUE_YTD = 0,
BASE_REVENUE_PP = BASE_REVENUE_PTD,
BASE_REVENUE_PTD = 0,
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 Project_Accum_id IN
(Select Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH Where
PAH.Project_Id = x_project_id) And
Budget_Type_Code <> Nvl(x_budget_type,'00');
Update PA_PROJECT_ACCUM_BUDGETS SET
BASE_RAW_COST_PP = BASE_RAW_COST_PTD,
BASE_RAW_COST_PTD = 0,
ORIG_RAW_COST_PP = ORIG_RAW_COST_PTD,
ORIG_RAW_COST_PTD = 0,
BASE_BURDENED_COST_PP = BASE_BURDENED_COST_PTD,
BASE_BURDENED_COST_PTD = 0,
ORIG_BURDENED_COST_PP = ORIG_BURDENED_COST_PTD,
ORIG_BURDENED_COST_PTD = 0,
BASE_QUANTITY_PP = BASE_QUANTITY_PTD,
BASE_QUANTITY_PTD = 0,
ORIG_QUANTITY_PP = ORIG_QUANTITY_PTD,
ORIG_QUANTITY_PTD = 0,
BASE_LABOR_HOURS_PP = BASE_LABOR_HOURS_PTD,
BASE_LABOR_HOURS_PTD = 0,
ORIG_LABOR_HOURS_PP = ORIG_LABOR_HOURS_PTD,
ORIG_LABOR_HOURS_PTD = 0,
BASE_REVENUE_PP = BASE_REVENUE_PTD,
BASE_REVENUE_PTD = 0,
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 Project_Accum_id IN
(Select Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH Where
PAH.Project_Id = x_project_id) And
Budget_Type_Code <> Nvl(x_budget_type,'00');
Update PA_PROJECT_ACCUM_BUDGETS SET
BASE_RAW_COST_YTD = 0,
BASE_RAW_COST_PP = 0,
BASE_RAW_COST_PTD = 0,
ORIG_RAW_COST_YTD = 0,
ORIG_RAW_COST_PP = 0,
ORIG_RAW_COST_PTD = 0,
BASE_BURDENED_COST_YTD = 0,
BASE_BURDENED_COST_PP = 0,
BASE_BURDENED_COST_PTD = 0,
ORIG_BURDENED_COST_YTD = 0,
ORIG_BURDENED_COST_PP = 0,
ORIG_BURDENED_COST_PTD = 0,
BASE_QUANTITY_YTD = 0,
BASE_QUANTITY_PP = 0,
BASE_QUANTITY_PTD = 0,
ORIG_QUANTITY_YTD = 0,
ORIG_QUANTITY_PP = 0,
ORIG_QUANTITY_PTD = 0,
BASE_LABOR_HOURS_YTD = 0,
BASE_LABOR_HOURS_PP = 0,
BASE_LABOR_HOURS_PTD = 0,
ORIG_LABOR_HOURS_YTD = 0,
ORIG_LABOR_HOURS_PP = 0,
ORIG_LABOR_HOURS_PTD = 0,
BASE_REVENUE_YTD = 0,
BASE_REVENUE_PP = 0,
BASE_REVENUE_PTD = 0,
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 Project_Accum_id IN
(Select Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH Where
PAH.Project_Id = x_project_id) And
Budget_Type_Code <> Nvl(x_budget_type,'00');
Update PA_PROJECT_ACCUM_BUDGETS SET
BASE_RAW_COST_PP = 0,
BASE_RAW_COST_PTD = 0,
ORIG_RAW_COST_PP = 0,
ORIG_RAW_COST_PTD = 0,
BASE_BURDENED_COST_PP = 0,
BASE_BURDENED_COST_PTD = 0,
ORIG_BURDENED_COST_PP = 0,
ORIG_BURDENED_COST_PTD = 0,
BASE_QUANTITY_PP = 0,
BASE_QUANTITY_PTD = 0,
ORIG_QUANTITY_PP = 0,
ORIG_QUANTITY_PTD = 0,
BASE_LABOR_HOURS_PP = 0,
BASE_LABOR_HOURS_PTD = 0,
ORIG_LABOR_HOURS_PP = 0,
ORIG_LABOR_HOURS_PTD = 0,
BASE_REVENUE_PP = 0,
BASE_REVENUE_PTD = 0,
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 Project_Accum_id IN
(Select Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH Where
PAH.Project_Id = x_project_id) And
Budget_Type_Code <> Nvl(x_budget_type,'00');
Update Pa_Budget_Versions
Set Resource_Accumulated_Flag ='N'
Where Current_Flag = 'Y'
And Project_id = x_project_id
AND Budget_type_code <> nvl(x_budget_type,'00');
Update PA_PROJECT_ACCUM_COMMITMENTS SET
CMT_RAW_COST_YTD = 0,
CMT_RAW_COST_PP = CMT_RAW_COST_PTD,
CMT_RAW_COST_PTD = 0,
CMT_BURDENED_COST_YTD = 0,
CMT_BURDENED_COST_PP = CMT_BURDENED_COST_PTD,
CMT_BURDENED_COST_PTD = 0,
CMT_QUANTITY_YTD = 0,
CMT_QUANTITY_PP = CMT_QUANTITY_PTD,
CMT_QUANTITY_PTD = 0,
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 Project_Accum_id IN
(Select Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH Where
PAH.Project_Id = x_project_id);
Update PA_PROJECT_ACCUM_COMMITMENTS SET
CMT_RAW_COST_PP = CMT_RAW_COST_PTD,
CMT_RAW_COST_PTD = 0,
CMT_BURDENED_COST_PP = CMT_BURDENED_COST_PTD,
CMT_BURDENED_COST_PTD = 0,
CMT_QUANTITY_PP = CMT_QUANTITY_PTD,
CMT_QUANTITY_PTD = 0,
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 Project_Accum_id IN
(Select Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH Where
PAH.Project_Id = x_project_id);
Update PA_PROJECT_ACCUM_COMMITMENTS SET
CMT_RAW_COST_YTD = 0,
CMT_RAW_COST_PP = 0,
CMT_RAW_COST_PTD = 0,
CMT_BURDENED_COST_YTD = 0,
CMT_BURDENED_COST_PP = 0,
CMT_BURDENED_COST_PTD = 0,
CMT_QUANTITY_YTD = 0,
CMT_QUANTITY_PP = 0,
CMT_QUANTITY_PTD = 0,
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 Project_Accum_id IN
(Select Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH Where
PAH.Project_Id = x_project_id);
Update PA_PROJECT_ACCUM_COMMITMENTS SET
CMT_RAW_COST_PP = 0,
CMT_RAW_COST_PTD = 0,
CMT_BURDENED_COST_PP = 0,
CMT_BURDENED_COST_PTD = 0,
CMT_QUANTITY_PP = 0,
CMT_QUANTITY_PTD = 0,
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 Project_Accum_id IN
(Select Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH Where
PAH.Project_Id = x_project_id);