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

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

Line: 17


      insert into
      fnd_log_messages
      (module,
       log_level,
       message_text,
       user_id,
        timestamp,
       log_sequence)
      values
      (p_module,
       1,
       p_msg,
       fnd_global.user_id,
       sysdate,
       fnd_log_messages_s.nextval);

Line: 363


l_update_flag_tab               SYSTEM.pa_num_tbl_type  := SYSTEM.pa_num_tbl_type();

Line: 365


l_child_update_required         VARCHAR2(1);

Line: 366


l_parent_update_required         VARCHAR2(1);

Line: 558


l_update_date_flag_tab1		SYSTEM.PA_VARCHAR2_1_TBL_TYPE	  := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

Line: 559


l_update_date_flag_tab2		SYSTEM.PA_VARCHAR2_1_TBL_TYPE	  := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

Line: 560


l_update_date_flag_tab3		SYSTEM.PA_VARCHAR2_1_TBL_TYPE	  := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

Line: 561


l_update_date_flag_tab4		SYSTEM.PA_VARCHAR2_1_TBL_TYPE	  := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

Line: 562


l_update_date_flag_tab5		SYSTEM.PA_VARCHAR2_1_TBL_TYPE	  := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

Line: 563


l_update_date_flag_tab6		SYSTEM.PA_VARCHAR2_1_TBL_TYPE	  := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

Line: 582


l_update_requ_flag_tab1		SYSTEM.PA_VARCHAR2_1_TBL_TYPE	  := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

Line: 583


l_update_requ_flag_tab2		SYSTEM.PA_VARCHAR2_1_TBL_TYPE	  := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

Line: 584


l_update_requ_flag_tab3		SYSTEM.PA_VARCHAR2_1_TBL_TYPE	  := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

Line: 585


l_update_requ_flag_tab4		SYSTEM.PA_VARCHAR2_1_TBL_TYPE	  := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

Line: 586


l_update_requ_flag_tab5		SYSTEM.PA_VARCHAR2_1_TBL_TYPE	  := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

Line: 587


l_update_requ_flag_tab6		SYSTEM.PA_VARCHAR2_1_TBL_TYPE	  := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

Line: 635


l_update_required		VARCHAR2(1):= 'N';

Line: 707


SELECT /*+ index(PA_PROJ_ROLLUP_BULK_TEMP PA_PROJ_ROLLUP_BULK_TEMP_U1) */ --added hint for bug  13109678
OBJECT_TYPE,
OBJECT_ID,
PARENT_OBJECT_TYPE,
PARENT_OBJECT_ID,
CALENDAR_ID,
CONSTRAINT_TYPE_CODE,
CONSTRAINT_DATE,
WBS_LEVEL,
START_DATE1,
START_DATE_OVERRIDE1,
FINISH_DATE1,
DURATION1,
TASK_STATUS1,
PROGRESS_STATUS_WEIGHT1,
PROGRESS_OVERRIDE1,
REMAINING_EFFORT1,
PERCENT_COMPLETE1,
PERCENT_OVERRIDE1,
TASK_WEIGHT1,
NUMBER_FIELD1,
ROLLUP_NODE1,
DIRTY_FLAG1,
ETC_Cost1,
PPL_ETC_COST1,
EQPMT_ETC_COST1,
PPL_UNPLAND_EFFORT1,
EQPMT_ETC_EFFORT1,
SUB_PRJ_ETC_COST1,
SUB_PRJ_PPL_ETC_COST1,
SUB_PRJ_EQPMT_ETC_COST1,
SUB_PRJ_PPL_ETC_EFFORT1,
SUB_PRJ_EQPMT_ETC_EFFORT1,
EARNED_VALUE1,
BAC_VALUE1,
START_DATE2,
START_DATE_OVERRIDE2,
FINISH_DATE2,
DURATION2,
TASK_STATUS2,
PROGRESS_STATUS_WEIGHT2,
PROGRESS_OVERRIDE2,
REMAINING_EFFORT2,
PERCENT_COMPLETE2,
PERCENT_OVERRIDE2,
TASK_WEIGHT2,
NUMBER_FIELD2,
ROLLUP_NODE2,
DIRTY_FLAG2,
ETC_Cost2,
PPL_ETC_COST2,
EQPMT_ETC_COST2,
PPL_UNPLAND_EFFORT2,
EQPMT_ETC_EFFORT2,
SUB_PRJ_ETC_COST2,
SUB_PRJ_PPL_ETC_COST2,
SUB_PRJ_EQPMT_ETC_COST2,
SUB_PRJ_PPL_ETC_EFFORT2,
SUB_PRJ_EQPMT_ETC_EFFORT2,
EARNED_VALUE2,
BAC_VALUE2,
START_DATE3,
START_DATE_OVERRIDE3,
FINISH_DATE3,
DURATION3,
TASK_STATUS3,
PROGRESS_STATUS_WEIGHT3,
PROGRESS_OVERRIDE3,
REMAINING_EFFORT3,
PERCENT_COMPLETE3,
PERCENT_OVERRIDE3,
TASK_WEIGHT3,
NUMBER_FIELD3,
ROLLUP_NODE3,
DIRTY_FLAG3,
ETC_Cost3,
PPL_ETC_COST3,
EQPMT_ETC_COST3,
PPL_UNPLAND_EFFORT3,
EQPMT_ETC_EFFORT3,
SUB_PRJ_ETC_COST3,
SUB_PRJ_PPL_ETC_COST3,
SUB_PRJ_EQPMT_ETC_COST3,
SUB_PRJ_PPL_ETC_EFFORT3,
SUB_PRJ_EQPMT_ETC_EFFORT3,
EARNED_VALUE3,
BAC_VALUE3,
START_DATE4,
START_DATE_OVERRIDE4,
FINISH_DATE4,
DURATION4,
TASK_STATUS4,
PROGRESS_STATUS_WEIGHT4,
PROGRESS_OVERRIDE4,
REMAINING_EFFORT4,
PERCENT_COMPLETE4,
PERCENT_OVERRIDE4,
TASK_WEIGHT4,
NUMBER_FIELD4,
ROLLUP_NODE4,
DIRTY_FLAG4,
ETC_Cost4,
PPL_ETC_COST4,
EQPMT_ETC_COST4,
PPL_UNPLAND_EFFORT4,
EQPMT_ETC_EFFORT4,
SUB_PRJ_ETC_COST4,
SUB_PRJ_PPL_ETC_COST4,
SUB_PRJ_EQPMT_ETC_COST4,
SUB_PRJ_PPL_ETC_EFFORT4,
SUB_PRJ_EQPMT_ETC_EFFORT4,
EARNED_VALUE4,
BAC_VALUE4,
START_DATE5,
START_DATE_OVERRIDE5,
FINISH_DATE5,
DURATION5,
TASK_STATUS5,
PROGRESS_STATUS_WEIGHT5,
PROGRESS_OVERRIDE5,
REMAINING_EFFORT5,
PERCENT_COMPLETE5,
PERCENT_OVERRIDE5,
TASK_WEIGHT5,
NUMBER_FIELD5,
ROLLUP_NODE5,
DIRTY_FLAG5,
ETC_Cost5,
PPL_ETC_COST5,
EQPMT_ETC_COST5,
PPL_UNPLAND_EFFORT5,
EQPMT_ETC_EFFORT5,
SUB_PRJ_ETC_COST5,
SUB_PRJ_PPL_ETC_COST5,
SUB_PRJ_EQPMT_ETC_COST5,
SUB_PRJ_PPL_ETC_EFFORT5,
SUB_PRJ_EQPMT_ETC_EFFORT5,
EARNED_VALUE5,
BAC_VALUE5,
START_DATE6,
START_DATE_OVERRIDE6,
FINISH_DATE6,
DURATION6,
TASK_STATUS6,
PROGRESS_STATUS_WEIGHT6,
PROGRESS_OVERRIDE6,
REMAINING_EFFORT6,
PERCENT_COMPLETE6,
PERCENT_OVERRIDE6,
TASK_WEIGHT6,
NUMBER_FIELD6,
ROLLUP_NODE6,
DIRTY_FLAG6,
ETC_Cost6,
PPL_ETC_COST6,
EQPMT_ETC_COST6,
PPL_UNPLAND_EFFORT6,
EQPMT_ETC_EFFORT6,
SUB_PRJ_ETC_COST6,
SUB_PRJ_PPL_ETC_COST6,
SUB_PRJ_EQPMT_ETC_COST6,
SUB_PRJ_PPL_ETC_EFFORT6,
SUB_PRJ_EQPMT_ETC_EFFORT6,
EARNED_VALUE6,
BAC_VALUE6,
PERC_COMP_DERIVATIVE_CODE1,
PERC_COMP_DERIVATIVE_CODE2,
PERC_COMP_DERIVATIVE_CODE3,
PERC_COMP_DERIVATIVE_CODE4,
PERC_COMP_DERIVATIVE_CODE5,
PERC_COMP_DERIVATIVE_CODE6,
SUMMARY_OBJECT_FLAG -- 4370746
FROM PA_PROJ_ROLLUP_BULK_TEMP
WHERE PROCESS_NUMBER  = C_Process_Number
order by Object_Type, Object_ID;

Line: 885


SELECT /*+ index(PA_PROJ_ROLLUP_BULK_TEMP PA_PROJ_ROLLUP_BULK_TEMP_U1) */ --added hint for bug 13109678
OBJECT_TYPE,
OBJECT_ID,
PARENT_OBJECT_TYPE,
PARENT_OBJECT_ID,
CALENDAR_ID,
CONSTRAINT_TYPE_CODE,
CONSTRAINT_DATE,
WBS_LEVEL,
START_DATE1,
START_DATE_OVERRIDE1,
FINISH_DATE1,
DURATION1,
TASK_STATUS1,
PROGRESS_STATUS_WEIGHT1,
PROGRESS_OVERRIDE1,
REMAINING_EFFORT1,
PERCENT_COMPLETE1,
PERCENT_OVERRIDE1,
TASK_WEIGHT1,
NUMBER_FIELD1,
ROLLUP_NODE1,
DIRTY_FLAG1,
ETC_Cost1,
PPL_ETC_COST1,
EQPMT_ETC_COST1,
PPL_UNPLAND_EFFORT1,
EQPMT_ETC_EFFORT1,
SUB_PRJ_ETC_COST1,
SUB_PRJ_PPL_ETC_COST1,
SUB_PRJ_EQPMT_ETC_COST1,
SUB_PRJ_PPL_ETC_EFFORT1,
SUB_PRJ_EQPMT_ETC_EFFORT1,
EARNED_VALUE1,
BAC_VALUE1,
START_DATE2,
START_DATE_OVERRIDE2,
FINISH_DATE2,
DURATION2,
TASK_STATUS2,
PROGRESS_STATUS_WEIGHT2,
PROGRESS_OVERRIDE2,
REMAINING_EFFORT2,
PERCENT_COMPLETE2,
PERCENT_OVERRIDE2,
TASK_WEIGHT2,
NUMBER_FIELD2,
ROLLUP_NODE2,
DIRTY_FLAG2,
ETC_Cost2,
PPL_ETC_COST2,
EQPMT_ETC_COST2,
PPL_UNPLAND_EFFORT2,
EQPMT_ETC_EFFORT2,
SUB_PRJ_ETC_COST2,
SUB_PRJ_PPL_ETC_COST2,
SUB_PRJ_EQPMT_ETC_COST2,
SUB_PRJ_PPL_ETC_EFFORT2,
SUB_PRJ_EQPMT_ETC_EFFORT2,
EARNED_VALUE2,
BAC_VALUE2,
START_DATE3,
START_DATE_OVERRIDE3,
FINISH_DATE3,
DURATION3,
TASK_STATUS3,
PROGRESS_STATUS_WEIGHT3,
PROGRESS_OVERRIDE3,
REMAINING_EFFORT3,
PERCENT_COMPLETE3,
PERCENT_OVERRIDE3,
TASK_WEIGHT3,
NUMBER_FIELD3,
ROLLUP_NODE3,
DIRTY_FLAG3,
ETC_Cost3,
PPL_ETC_COST3,
EQPMT_ETC_COST3,
PPL_UNPLAND_EFFORT3,
EQPMT_ETC_EFFORT3,
SUB_PRJ_ETC_COST3,
SUB_PRJ_PPL_ETC_COST3,
SUB_PRJ_EQPMT_ETC_COST3,
SUB_PRJ_PPL_ETC_EFFORT3,
SUB_PRJ_EQPMT_ETC_EFFORT3,
EARNED_VALUE3,
BAC_VALUE3,
START_DATE4,
START_DATE_OVERRIDE4,
FINISH_DATE4,
DURATION4,
TASK_STATUS4,
PROGRESS_STATUS_WEIGHT4,
PROGRESS_OVERRIDE4,
REMAINING_EFFORT4,
PERCENT_COMPLETE4,
PERCENT_OVERRIDE4,
TASK_WEIGHT4,
NUMBER_FIELD4,
ROLLUP_NODE4,
DIRTY_FLAG4,
ETC_Cost4,
PPL_ETC_COST4,
EQPMT_ETC_COST4,
PPL_UNPLAND_EFFORT4,
EQPMT_ETC_EFFORT4,
SUB_PRJ_ETC_COST4,
SUB_PRJ_PPL_ETC_COST4,
SUB_PRJ_EQPMT_ETC_COST4,
SUB_PRJ_PPL_ETC_EFFORT4,
SUB_PRJ_EQPMT_ETC_EFFORT4,
EARNED_VALUE4,
BAC_VALUE4,
START_DATE5,
START_DATE_OVERRIDE5,
FINISH_DATE5,
DURATION5,
TASK_STATUS5,
PROGRESS_STATUS_WEIGHT5,
PROGRESS_OVERRIDE5,
REMAINING_EFFORT5,
PERCENT_COMPLETE5,
PERCENT_OVERRIDE5,
TASK_WEIGHT5,
NUMBER_FIELD5,
ROLLUP_NODE5,
DIRTY_FLAG5,
ETC_Cost5,
PPL_ETC_COST5,
EQPMT_ETC_COST5,
PPL_UNPLAND_EFFORT5,
EQPMT_ETC_EFFORT5,
SUB_PRJ_ETC_COST5,
SUB_PRJ_PPL_ETC_COST5,
SUB_PRJ_EQPMT_ETC_COST5,
SUB_PRJ_PPL_ETC_EFFORT5,
SUB_PRJ_EQPMT_ETC_EFFORT5,
EARNED_VALUE5,
BAC_VALUE5,
START_DATE6,
START_DATE_OVERRIDE6,
FINISH_DATE6,
DURATION6,
TASK_STATUS6,
PROGRESS_STATUS_WEIGHT6,
PROGRESS_OVERRIDE6,
REMAINING_EFFORT6,
PERCENT_COMPLETE6,
PERCENT_OVERRIDE6,
TASK_WEIGHT6,
NUMBER_FIELD6,
ROLLUP_NODE6,
DIRTY_FLAG6,
ETC_Cost6,
PPL_ETC_COST6,
EQPMT_ETC_COST6,
PPL_UNPLAND_EFFORT6,
EQPMT_ETC_EFFORT6,
SUB_PRJ_ETC_COST6,
SUB_PRJ_PPL_ETC_COST6,
SUB_PRJ_EQPMT_ETC_COST6,
SUB_PRJ_PPL_ETC_EFFORT6,
SUB_PRJ_EQPMT_ETC_EFFORT6,
EARNED_VALUE6,
BAC_VALUE6,
PERC_COMP_DERIVATIVE_CODE1,
PERC_COMP_DERIVATIVE_CODE2,
PERC_COMP_DERIVATIVE_CODE3,
PERC_COMP_DERIVATIVE_CODE4,
PERC_COMP_DERIVATIVE_CODE5,
PERC_COMP_DERIVATIVE_CODE6,
SUMMARY_OBJECT_FLAG -- 4370746
FROM PA_PROJ_ROLLUP_BULK_TEMP
WHERE PROCESS_NUMBER  = C_Process_Number
order by calendar_id;

Line: 1062


SELECT object_id, object_type, start_date1, start_date2, start_date3,
start_date4, start_date5, start_date6, finish_date1,finish_date2, finish_date3,
finish_date4, finish_date5, finish_date6, duration1, duration2, duration3, duration4,
duration5, duration6, dirty_flag1, dirty_flag2, dirty_flag3, dirty_flag4, dirty_flag5, dirty_flag6
, 'N', 'N', 'N', 'N', 'N', 'N'
FROM   PA_PROJ_ROLLUP_BULK_TEMP t1
WHERE  PROCESS_NUMBER  = l_process_number
-- 4218507 : This could be made dependenct on dirty_flag1='Y' only. Not sure whethere this will improve performance
AND    (dirty_flag1='Y' OR dirty_flag2='Y' OR dirty_flag3='Y' OR dirty_flag4='Y' OR dirty_flag5='Y'
OR dirty_flag6='Y')
AND    Not Exists (select * from PA_PROJ_ROLLUP_BULK_TEMP t2
where t2.PROCESS_NUMBER = l_process_number
and t2.parent_object_id = t1.object_id
AND ROWNUM < 2);

Line: 1078


SELECT object_id, object_type, start_date1, start_date2, start_date3,
start_date4, start_date5, start_date6, finish_date1,finish_date2, finish_date3,
finish_date4, finish_date5, finish_date6, duration1, duration2, duration3, duration4,
duration5, duration6, dirty_flag1, dirty_flag2, dirty_flag3, dirty_flag4, dirty_flag5, dirty_flag6,
start_date_override1, start_date_override2, start_date_override3, start_date_override4,
start_date_override5, start_date_override6
FROM   PA_PROJ_ROLLUP_BULK_TEMP
WHERE  PROCESS_NUMBER   = l_process_number
-- 4218507 : This could be made dependent on dirty_flag1=Y only
AND    (dirty_flag1='Y' OR dirty_flag2='Y' OR dirty_flag3='Y' OR dirty_flag4='Y' OR dirty_flag5='Y' OR
dirty_flag6='Y')
AND object_id <> c_object_id
START  WITH object_id   = c_object_ID
CONNECT BY object_id  = PRIOR parent_object_id
order by wbs_level desc;

Line: 1096


SELECT object_id, object_type,REMAINING_EFFORT1,REMAINING_EFFORT2, REMAINING_EFFORT3, REMAINING_EFFORT4
, REMAINING_EFFORT5, REMAINING_EFFORT6
FROM   PA_PROJ_ROLLUP_BULK_TEMP t1
WHERE  process_number = l_process_number
AND OBJECT_TYPE <> 'PA_DELIVERABLES'
AND Exists (SELECT * from PA_PROJ_ROLLUP_BULK_TEMP t2
WHERE t2.OBJECT_TYPE <> 'PA_DELIVERABLES'
AND t2.parent_object_id = t1.object_id
AND t2.parent_object_type IN ('PA_STRUCTURES','PA_TASKS') -- Bug 4450587
AND process_number = l_process_number
AND ROWNUM < 2)
Order By WBS_LEVEL DESC;

Line: 1111


SELECT /*+ INDEX(T1 PA_PROJ_ROLLUP_BULK_TEMP_U1) */ Object_ID, object_type, PROGRESS_STATUS_WEIGHT1, PROGRESS_STATUS_WEIGHT2, PROGRESS_STATUS_WEIGHT3 -- Added for Bug14040849
, PROGRESS_STATUS_WEIGHT4, PROGRESS_STATUS_WEIGHT5, PROGRESS_STATUS_WEIGHT6
FROM   PA_PROJ_ROLLUP_BULK_TEMP t1
--WHERE  OBJECT_TYPE IN ('PA_TASKS', 'PA_STRUCTURES', 'PA_DELIVERABLES')
WHERE  OBJECT_TYPE IN ('PA_TASKS', 'PA_STRUCTURES')
AND process_number = l_process_number
AND Exists (Select /*+ index(t2 PA_PROJ_ROLLUP_BULK_TEMP_N3 )  */ * From PA_PROJ_ROLLUP_BULK_TEMP t2 --14040849
--	 Where t2.OBJECT_TYPE IN ('PA_TASKS', 'PA_STRUCTURES', 'PA_DELIVERABLES', 'PA_SUBPROJECTS')
Where t2.OBJECT_TYPE IN ('PA_TASKS', 'PA_STRUCTURES', 'PA_SUBPROJECTS')
AND t2.parent_object_id = t1.object_id
AND t2.parent_object_type IN ('PA_STRUCTURES','PA_TASKS') -- Bug 4450587
AND process_number = l_process_number
AND ROWNUM < 2)
Order By WBS_LEVEL DESC;

Line: 1128


SELECT /*+ INDEX (t1 PA_PROJ_ROLLUP_BULK_TEMP_N3)*/   --9796902
object_id, object_type, task_status1, task_status2, task_status3, task_status4, task_status5, task_status6
FROM PA_PROJ_ROLLUP_BULK_TEMP t1
WHERE PROCESS_NUMBER = l_process_number
AND OBJECT_TYPE <> 'PA_ASSIGNMENTS'
AND Exists (SELECT /*+ INDEX (t2 PA_PROJ_ROLLUP_BULK_TEMP_N3)*/   --9796902
* From PA_PROJ_ROLLUP_BULK_TEMP t2
Where t2.PROCESS_NUMBER = l_process_number
AND OBJECT_TYPE <> 'PA_ASSIGNMENTS'
AND t2.parent_object_id = t1.object_id
AND t2.parent_object_type IN ('PA_STRUCTURES','PA_TASKS') -- Bug 4450587
AND RowNum < 2)
Order By WBS_LEVEL DESC;

Line: 1143


SELECT decode(rollup_node1, 'Y', TASK_STATUS1, -1)
, decode(rollup_node2, 'Y', TASK_STATUS2, -1)
, decode(rollup_node3, 'Y', TASK_STATUS3, -1)
, decode(rollup_node4, 'Y', TASK_STATUS4, -1)
, decode(rollup_node5, 'Y', TASK_STATUS5, -1)
, decode(rollup_node6, 'Y', TASK_STATUS6, -1)
FROM PA_PROJ_ROLLUP_BULK_TEMP
WHERE PROCESS_NUMBER = l_process_number
AND OBJECT_TYPE <> 'PA_ASSIGNMENTS'
AND parent_object_id = p_parent_id
AND parent_object_type IN ('PA_STRUCTURES','PA_TASKS') -- Bug 4450587
;

Line: 1157


SELECT /*+ INDEX (PA_PROJ_ROLLUP_BULK_TEMP PA_PROJ_ROLLUP_BULK_TEMP_N3)*/  --9796902
TASK_STATUS1, TASK_STATUS2, TASK_STATUS3, TASK_STATUS4, TASK_STATUS5, TASK_STATUS6
FROM PA_PROJ_ROLLUP_BULK_TEMP
WHERE PROCESS_NUMBER = l_process_number
AND OBJECT_TYPE <> 'PA_ASSIGNMENTS'
AND parent_object_id = p_parent_id
AND parent_object_type IN ('PA_STRUCTURES','PA_TASKS') -- Bug 4450587
;

Line: 1168


SELECT /*+ INDEX(T1 PA_PROJ_ROLLUP_BULK_TEMP_U1)  */ object_id, OBJECT_TYPE, Perc_Comp_Derivative_Code1, BAC_VALUE1, BAC_VALUE2, BAC_VALUE3, BAC_VALUE4, -- Added for 14040849
BAC_VALUE5, BAC_VALUE6, PERCENT_COMPLETE1, PERCENT_COMPLETE2, PERCENT_COMPLETE3,
PERCENT_COMPLETE4, PERCENT_COMPLETE5, PERCENT_COMPLETE6, PERCENT_OVERRIDE1, PERCENT_OVERRIDE2,
PERCENT_OVERRIDE3, PERCENT_OVERRIDE4, PERCENT_OVERRIDE5, PERCENT_OVERRIDE6, EARNED_VALUE1, EARNED_VALUE2
, EARNED_VALUE3, EARNED_VALUE4, EARNED_VALUE5, EARNED_VALUE6
FROM PA_PROJ_ROLLUP_BULK_TEMP t1
WHERE PROCESS_NUMBER = l_process_number
AND OBJECT_TYPE IN ('PA_TASKS', 'PA_STRUCTURES')
AND nvl(SUMMARY_OBJECT_FLAG, 'N') NOT IN ('Y', 'L') -- 4370746 -- 4586449 : Added 'L'
AND not Exists (Select /*+ index(t2 PA_PROJ_ROLLUP_BULK_TEMP_N3 )  */ * From PA_PROJ_ROLLUP_BULK_TEMP t2 --Added for Bug14040849
		  Where t2.PROCESS_NUMBER = l_process_number
      		  AND t2.OBJECT_TYPE IN ('PA_TASKS', 'PA_STRUCTURES')
		  And t2.parent_object_id = t1.object_id
                  AND t2.parent_object_type IN ('PA_STRUCTURES','PA_TASKS') -- Bug 4450587
		  AND ROWNUM < 2);

Line: 1185


SELECT /*+ INDEX(T1 PA_PROJ_ROLLUP_BULK_TEMP_U1)  */ object_id, OBJECT_TYPE, Perc_Comp_Derivative_Code1, BAC_VALUE1, BAC_VALUE2, BAC_VALUE3, BAC_VALUE4, -- Added for 14040849
BAC_VALUE5, BAC_VALUE6, PERCENT_COMPLETE1, PERCENT_COMPLETE2, PERCENT_COMPLETE3,
PERCENT_COMPLETE4, PERCENT_COMPLETE5, PERCENT_COMPLETE6, PERCENT_OVERRIDE1, PERCENT_OVERRIDE2,
PERCENT_OVERRIDE3, PERCENT_OVERRIDE4, PERCENT_OVERRIDE5, PERCENT_OVERRIDE6, EARNED_VALUE1, EARNED_VALUE2
, EARNED_VALUE3, EARNED_VALUE4, EARNED_VALUE5, EARNED_VALUE6
, summary_object_flag -- 4587517
FROM PA_PROJ_ROLLUP_BULK_TEMP t1
WHERE PROCESS_NUMBER = l_process_number
AND OBJECT_TYPE IN ('PA_TASKS', 'PA_STRUCTURES')
-- 4530036 : SUMMARY_OBJECT_FLAG is added so that
-- earned value gets recalculated even if no childs are passed to summary level
AND( nvl(SUMMARY_OBJECT_FLAG, 'N') IN ('Y','L') -- 4586449 : Added 'L'
OR Exists (Select /*+ index(t2 PA_PROJ_ROLLUP_BULK_TEMP_N3 )  */ * From PA_PROJ_ROLLUP_BULK_TEMP t2 -- Added for 14040849
		  Where t2.PROCESS_NUMBER = l_process_number
      		  AND t2.OBJECT_TYPE IN ('PA_TASKS', 'PA_STRUCTURES')
		  And t2.parent_object_id = t1.object_id
                  AND t2.parent_object_type IN ('PA_STRUCTURES','PA_TASKS') -- Bug 4450587
		  AND ROWNUM < 2)
   )
Order By WBS_LEVEL DESC;

Line: 1207


SELECT object_id, object_type, ETC_Cost1, ETC_Cost2, ETC_Cost3, ETC_Cost4, ETC_Cost5, ETC_Cost6
, PPL_ETC_COST1, PPL_ETC_COST2, PPL_ETC_COST3, PPL_ETC_COST4, PPL_ETC_COST5, PPL_ETC_COST6
, EQPMT_ETC_COST1, EQPMT_ETC_COST2, EQPMT_ETC_COST3, EQPMT_ETC_COST4, EQPMT_ETC_COST5, EQPMT_ETC_COST6
, PPL_UNPLAND_EFFORT1, PPL_UNPLAND_EFFORT2, PPL_UNPLAND_EFFORT3, PPL_UNPLAND_EFFORT4, PPL_UNPLAND_EFFORT5, PPL_UNPLAND_EFFORT6
, EQPMT_ETC_EFFORT1, EQPMT_ETC_EFFORT2, EQPMT_ETC_EFFORT3, EQPMT_ETC_EFFORT4, EQPMT_ETC_EFFORT5, EQPMT_ETC_EFFORT6
, SUB_PRJ_ETC_COST1, SUB_PRJ_ETC_COST2, SUB_PRJ_ETC_COST3, SUB_PRJ_ETC_COST4, SUB_PRJ_ETC_COST5, SUB_PRJ_ETC_COST6
, SUB_PRJ_PPL_ETC_COST1, SUB_PRJ_PPL_ETC_COST2, SUB_PRJ_PPL_ETC_COST3, SUB_PRJ_PPL_ETC_COST4, SUB_PRJ_PPL_ETC_COST5, SUB_PRJ_PPL_ETC_COST6
, SUB_PRJ_EQPMT_ETC_COST1, SUB_PRJ_EQPMT_ETC_COST2, SUB_PRJ_EQPMT_ETC_COST3, SUB_PRJ_EQPMT_ETC_COST4, SUB_PRJ_EQPMT_ETC_COST5, SUB_PRJ_EQPMT_ETC_COST6
, SUB_PRJ_PPL_ETC_EFFORT1, SUB_PRJ_PPL_ETC_EFFORT2, SUB_PRJ_PPL_ETC_EFFORT3, SUB_PRJ_PPL_ETC_EFFORT4, SUB_PRJ_PPL_ETC_EFFORT5, SUB_PRJ_PPL_ETC_EFFORT6
, SUB_PRJ_EQPMT_ETC_EFFORT1, SUB_PRJ_EQPMT_ETC_EFFORT2, SUB_PRJ_EQPMT_ETC_EFFORT3, SUB_PRJ_EQPMT_ETC_EFFORT4, SUB_PRJ_EQPMT_ETC_EFFORT5, SUB_PRJ_EQPMT_ETC_EFFORT6
, REMAINING_EFFORT1, REMAINING_EFFORT2, REMAINING_EFFORT3, REMAINING_EFFORT4, REMAINING_EFFORT5, REMAINING_EFFORT6
FROM   PA_PROJ_ROLLUP_BULK_TEMP t1
WHERE  PROCESS_NUMBER = l_process_number
AND OBJECT_TYPE NOT IN ( 'PA_DELIVERABLES',  'PA_ASSIGNMENTS', 'PA_SUBPROJECTS')
AND Exists (SELECT /*+ index(T2 PA_PROJ_ROLLUP_BULK_TEMP_N3) */ * -- added hint for bug#12945266
from PA_PROJ_ROLLUP_BULK_TEMP t2
WHERE t2.PROCESS_NUMBER = l_process_number
AND t2.OBJECT_TYPE <> 'PA_DELIVERABLES'
AND t2.parent_object_id = t1.object_id
AND t2.parent_object_type IN ('PA_STRUCTURES','PA_TASKS') -- Bug 4450587
AND ROWNUM < 2)
Order By WBS_LEVEL DESC;

Line: 1231


SELECT /*+ index(t1 PA_PROJ_ROLLUP_BULK_TEMP_N3) */  -- added hint for bug 13109678
object_id, object_type, dirty_flag1, dirty_flag2, dirty_flag3, dirty_flag4, dirty_flag5, dirty_flag6
FROM PA_PROJ_ROLLUP_BULK_TEMP t1
WHERE PROCESS_NUMBER = l_process_number
AND OBJECT_TYPE <> 'PA_DELIVERABLES'
AND (Dirty_flag1 ='Y' OR Dirty_flag2 ='Y' OR Dirty_flag3 ='Y' OR Dirty_flag4 ='Y' OR Dirty_flag5 ='Y'
OR Dirty_flag6 ='Y')
AND Exists (select /*+ index (t2 PA_PROJ_ROLLUP_BULK_TEMP_N3) */ 1 -- added hint for bug 13109678
from PA_PROJ_ROLLUP_BULK_TEMP t2
where t2.PROCESS_NUMBER = l_process_number
and t2.OBJECT_TYPE <> 'PA_DELIVERABLES'
and t2.parent_object_id = t1.object_id
-- AND ROWNUM < 2  -- commented for bug 13109678
);

Line: 1249


SELECT t.Object_ID, t.object_type, t.dirty_flag1, t.dirty_flag2, t.dirty_flag3
, t.dirty_flag4, t.dirty_flag5, t.dirty_flag6, c_dirty_flag1 ref_dirty_flag1
, c_dirty_flag2 ref_dirty_flag2, c_dirty_flag3 ref_dirty_flag3, c_dirty_flag4 ref_dirty_flag4
, c_dirty_flag5 ref_dirty_flag5, c_dirty_flag6 ref_dirty_flag6
FROM
(SELECT t2.Object_ID, t2.object_type, t2.dirty_flag1, t2.dirty_flag2, t2.dirty_flag3
, t2.dirty_flag4, t2.dirty_flag5, t2.dirty_flag6,t2.wbs_level order_by_clause
FROM PA_PROJ_ROLLUP_BULK_TEMP T2
WHERE T2.PROCESS_NUMBER = l_process_number
AND T2.Object_ID <> c_object_id
START WITH T2.PROCESS_NUMBER = l_process_number
AND        T2.Object_ID = c_object_id
CONNECT BY T2.PROCESS_NUMBER = l_process_number
AND        T2.Parent_Object_ID = PRIOR T2.Object_ID) t
order by order_by_clause desc;

Line: 1266


SELECT /*+ index(t1 PA_PROJ_ROLLUP_BULK_TEMP_N3) */  -- added hint for bug 13109678
object_id, object_type, dirty_flag1, dirty_flag2, dirty_flag3, dirty_flag4, dirty_flag5, dirty_flag6
FROM PA_PROJ_ROLLUP_BULK_TEMP t1
WHERE PROCESS_NUMBER = l_process_number
AND OBJECT_TYPE <> 'PA_DELIVERABLES'
AND (Dirty_flag1 ='Y' OR Dirty_flag2 ='Y' OR Dirty_flag3 ='Y' OR Dirty_flag4 ='Y' OR Dirty_flag5 ='Y'
OR Dirty_flag6 ='Y')
AND NOT Exists (select /*+ index (t2 PA_PROJ_ROLLUP_BULK_TEMP_N3) */ 1 -- added hint for bug 13109678
from PA_PROJ_ROLLUP_BULK_TEMP t2
where t2.PROCESS_NUMBER = l_process_number
and t2.OBJECT_TYPE <> 'PA_DELIVERABLES'
and t2.parent_object_id = t1.object_id
--	  AND ROWNUM < 2 -- commented for bug 13109678
);

Line: 1284


SELECT t.Object_ID, t.object_type, t.dirty_flag1, t.dirty_flag2, t.dirty_flag3
, t.dirty_flag4, t.dirty_flag5, t.dirty_flag6, c_dirty_flag1 ref_dirty_flag1
, c_dirty_flag2 ref_dirty_flag2, c_dirty_flag3 ref_dirty_flag3, c_dirty_flag4 ref_dirty_flag4
, c_dirty_flag5 ref_dirty_flag5, c_dirty_flag6 ref_dirty_flag6
FROM
(   SELECT /*+ dynamic_sampling(t2 3) */ t2.Object_ID, t2.object_type, t2.dirty_flag1, t2.dirty_flag2, t2.dirty_flag3 -- Added for 14040849
         , t2.dirty_flag4, t2.dirty_flag5, t2.dirty_flag6, t2.wbs_level order_by_clause
FROM PA_PROJ_ROLLUP_BULK_TEMP T2
WHERE T2.PROCESS_NUMBER = l_process_number
AND T2.Object_ID <> c_object_id
START WITH T2.PROCESS_NUMBER = l_process_number
AND        T2.Object_ID = c_object_id
CONNECT BY T2.PROCESS_NUMBER = l_process_number
AND        T2.Object_ID = PRIOR T2.Parent_Object_ID) t
order by t.order_by_clause asc;

Line: 1302


SELECT /*+ index(pa_proj_rollup_bulk_temp PA_PROJ_ROLLUP_BULK_TEMP_N3) */  -- added hint for bug 13109678
object_id, object_type, start_date1, start_date2, start_date3,
start_date4, start_date5, start_date6, finish_date1,finish_date2, finish_date3,
finish_date4, finish_date5, finish_date6, duration1, duration2, duration3, duration4,
duration5, duration6, dirty_flag1, dirty_flag2, dirty_flag3, dirty_flag4, dirty_flag5, dirty_flag6,
start_date_override1, start_date_override2, start_date_override3, start_date_override4,
start_date_override5, start_date_override6, 'N', 'N', 'N', 'N', 'N', 'N' , 'N', 'N', 'N', 'N', 'N', 'N'
FROM   PA_PROJ_ROLLUP_BULK_TEMP
WHERE  PROCESS_NUMBER   = l_process_number
AND    (dirty_flag1='Y' OR dirty_flag2='Y' OR dirty_flag3='Y' OR dirty_flag4='Y' OR dirty_flag5='Y' OR
dirty_flag6='Y')
order by wbs_level desc;

Line: 1331


SELECT PA_PROJ_ROLLUP_BULK_TEMP_S.nextval
INTO   l_Process_Number FROM dual;

Line: 1723


INSERT INTO PA_PROJ_ROLLUP_BULK_TEMP(
PROCESS_NUMBER,
OBJECT_TYPE,
OBJECT_ID,
PARENT_OBJECT_TYPE,
PARENT_OBJECT_ID,
CALENDAR_ID,
CONSTRAINT_TYPE_CODE,
CONSTRAINT_DATE,
WBS_LEVEL,
START_DATE1,
START_DATE_OVERRIDE1,
FINISH_DATE1,
DURATION1,
TASK_STATUS1,
PROGRESS_STATUS_WEIGHT1,
PROGRESS_OVERRIDE1,
REMAINING_EFFORT1,
PERCENT_COMPLETE1,
PERCENT_OVERRIDE1,
TASK_WEIGHT1,
NUMBER_FIELD1,
ROLLUP_NODE1,
DIRTY_FLAG1,
ETC_Cost1,
PPL_ETC_COST1,
EQPMT_ETC_COST1,
PPL_UNPLAND_EFFORT1,
EQPMT_ETC_EFFORT1,
SUB_PRJ_ETC_COST1,
SUB_PRJ_PPL_ETC_COST1,
SUB_PRJ_EQPMT_ETC_COST1,
SUB_PRJ_PPL_ETC_EFFORT1,
SUB_PRJ_EQPMT_ETC_EFFORT1,
EARNED_VALUE1,
BAC_VALUE1,
PERC_COMP_DERIVATIVE_CODE1,
START_DATE2,
START_DATE_OVERRIDE2,
FINISH_DATE2,
DURATION2,
TASK_STATUS2,
PROGRESS_STATUS_WEIGHT2,
PROGRESS_OVERRIDE2,
REMAINING_EFFORT2,
PERCENT_COMPLETE2,
PERCENT_OVERRIDE2,
TASK_WEIGHT2,
NUMBER_FIELD2,
ROLLUP_NODE2,
DIRTY_FLAG2,
ETC_Cost2,
PPL_ETC_COST2,
EQPMT_ETC_COST2,
PPL_UNPLAND_EFFORT2,
EQPMT_ETC_EFFORT2,
SUB_PRJ_ETC_COST2,
SUB_PRJ_PPL_ETC_COST2,
SUB_PRJ_EQPMT_ETC_COST2,
SUB_PRJ_PPL_ETC_EFFORT2,
SUB_PRJ_EQPMT_ETC_EFFORT2,
EARNED_VALUE2,
BAC_VALUE2,
PERC_COMP_DERIVATIVE_CODE2,
START_DATE3,
START_DATE_OVERRIDE3,
FINISH_DATE3,
DURATION3,
TASK_STATUS3,
PROGRESS_STATUS_WEIGHT3,
PROGRESS_OVERRIDE3,
REMAINING_EFFORT3,
PERCENT_COMPLETE3,
PERCENT_OVERRIDE3,
TASK_WEIGHT3,
NUMBER_FIELD3,
ROLLUP_NODE3,
DIRTY_FLAG3,
ETC_Cost3,
PPL_ETC_COST3,
EQPMT_ETC_COST3,
PPL_UNPLAND_EFFORT3,
EQPMT_ETC_EFFORT3,
SUB_PRJ_ETC_COST3,
SUB_PRJ_PPL_ETC_COST3,
SUB_PRJ_EQPMT_ETC_COST3,
SUB_PRJ_PPL_ETC_EFFORT3,
SUB_PRJ_EQPMT_ETC_EFFORT3,
EARNED_VALUE3,
BAC_VALUE3,
PERC_COMP_DERIVATIVE_CODE3,
START_DATE4,
START_DATE_OVERRIDE4,
FINISH_DATE4,
DURATION4,
TASK_STATUS4,
PROGRESS_STATUS_WEIGHT4,
PROGRESS_OVERRIDE4,
REMAINING_EFFORT4,
PERCENT_COMPLETE4,
PERCENT_OVERRIDE4,
TASK_WEIGHT4,
NUMBER_FIELD4,
ROLLUP_NODE4,
DIRTY_FLAG4,
ETC_Cost4,
PPL_ETC_COST4,
EQPMT_ETC_COST4,
PPL_UNPLAND_EFFORT4,
EQPMT_ETC_EFFORT4,
SUB_PRJ_ETC_COST4,
SUB_PRJ_PPL_ETC_COST4,
SUB_PRJ_EQPMT_ETC_COST4,
SUB_PRJ_PPL_ETC_EFFORT4,
SUB_PRJ_EQPMT_ETC_EFFORT4,
EARNED_VALUE4,
BAC_VALUE4,
PERC_COMP_DERIVATIVE_CODE4,
START_DATE5,
START_DATE_OVERRIDE5,
FINISH_DATE5,
DURATION5,
TASK_STATUS5,
PROGRESS_STATUS_WEIGHT5,
PROGRESS_OVERRIDE5,
REMAINING_EFFORT5,
PERCENT_COMPLETE5,
PERCENT_OVERRIDE5,
TASK_WEIGHT5,
NUMBER_FIELD5,
ROLLUP_NODE5,
DIRTY_FLAG5,
ETC_Cost5,
PPL_ETC_COST5,
EQPMT_ETC_COST5,
PPL_UNPLAND_EFFORT5,
EQPMT_ETC_EFFORT5,
SUB_PRJ_ETC_COST5,
SUB_PRJ_PPL_ETC_COST5,
SUB_PRJ_EQPMT_ETC_COST5,
SUB_PRJ_PPL_ETC_EFFORT5,
SUB_PRJ_EQPMT_ETC_EFFORT5,
EARNED_VALUE5,
BAC_VALUE5,
PERC_COMP_DERIVATIVE_CODE5,
START_DATE6,
START_DATE_OVERRIDE6,
FINISH_DATE6,
DURATION6,
TASK_STATUS6,
PROGRESS_STATUS_WEIGHT6,
PROGRESS_OVERRIDE6,
REMAINING_EFFORT6,
PERCENT_COMPLETE6,
PERCENT_OVERRIDE6,
TASK_WEIGHT6,
NUMBER_FIELD6,
ROLLUP_NODE6,
DIRTY_FLAG6,
ETC_Cost6,
PPL_ETC_COST6,
EQPMT_ETC_COST6,
PPL_UNPLAND_EFFORT6,
EQPMT_ETC_EFFORT6,
SUB_PRJ_ETC_COST6,
SUB_PRJ_PPL_ETC_COST6,
SUB_PRJ_EQPMT_ETC_COST6,
SUB_PRJ_PPL_ETC_EFFORT6,
SUB_PRJ_EQPMT_ETC_EFFORT6,
EARNED_VALUE6,
BAC_VALUE6,
PERC_COMP_DERIVATIVE_CODE6,
SUMMARY_OBJECT_FLAG -- 4370746
) VALUES (
l_process_number,
l_OBJECT_TYPE(i),
l_OBJECT_ID(i),
l_PARENT_OBJECT_TYPE(i),
l_PARENT_OBJECT_ID(i),
l_CALENDAR_ID(i),
l_CONSTRAINT_TYPE_CODE(i),
l_CONSTRAINT_DATE(i),
l_WBS_LEVEL(i),
l_START_DATE1(i),
l_START_DATE_OVERRIDE1(i),
l_FINISH_DATE1(i),
l_DURATION1(i),
l_TASK_STATUS1(i),
l_PROGRESS_STATUS_WEIGHT1(i),
l_PROGRESS_OVERRIDE1(i),
l_REMAINING_EFFORT1(i),
l_PERCENT_COMPLETE1(i),
l_PERCENT_OVERRIDE1(i),
l_TASK_WEIGHT1(i),
l_NUMBER_FIELD1(i),
l_ROLLUP_NODE1(i),
l_DIRTY_FLAG1(i),
l_Etc_Cost1(i),
l_PPL_ETC_Cost1(i),
l_EQPMT_ETC_COST1(i),
l_PPL_UNPLAND_EFFORT1(i),
l_EQPMT_ETC_EFFORT1(i),
l_SUB_PRJ_ETC_COST1(i),
l_SUB_PRJ_PPL_ETC_COST1(i),
l_SUB_PRJ_EQPMT_ETC_COST1(i),
l_SUB_PRJ_PPL_ETC_EFFORT1(i),
l_SUB_PRJ_EQPMT_ETC_EFFORT1(i),
l_EARNED_VALUE1(i),
l_BAC_VALUE1(i),
l_Perc_Comp_Deriv_Code1(i),
l_START_DATE2(i),
l_START_DATE_OVERRIDE2(i),
l_FINISH_DATE2(i),
l_DURATION2(i),
l_TASK_STATUS2(i),
l_PROGRESS_STATUS_WEIGHT2(i),
l_PROGRESS_OVERRIDE2(i),
l_REMAINING_EFFORT2(i),
l_PERCENT_COMPLETE2(i),
l_PERCENT_OVERRIDE2(i),
l_TASK_WEIGHT2(i),
l_NUMBER_FIELD2(i),
l_ROLLUP_NODE2(i),
l_DIRTY_FLAG2(i),
l_Etc_Cost2(i),
l_PPL_ETC_Cost2(i),
l_EQPMT_ETC_COST2(i),
l_PPL_UNPLAND_EFFORT2(i),
l_EQPMT_ETC_EFFORT2(i),
l_SUB_PRJ_ETC_COST2(i),
l_SUB_PRJ_PPL_ETC_COST2(i),
l_SUB_PRJ_EQPMT_ETC_COST2(i),
l_SUB_PRJ_PPL_ETC_EFFORT2(i),
l_SUB_PRJ_EQPMT_ETC_EFFORT2(i),
l_EARNED_VALUE2(i),
l_BAC_VALUE2(i),
l_Perc_Comp_Deriv_Code2(i),
l_START_DATE3(i),
l_START_DATE_OVERRIDE3(i),
l_FINISH_DATE3(i),
l_DURATION3(i),
l_TASK_STATUS3(i),
l_PROGRESS_STATUS_WEIGHT3(i),
l_PROGRESS_OVERRIDE3(i),
l_REMAINING_EFFORT3(i),
l_PERCENT_COMPLETE3(i),
l_PERCENT_OVERRIDE3(i),
l_TASK_WEIGHT3(i),
l_NUMBER_FIELD3(i),
l_ROLLUP_NODE3(i),
l_DIRTY_FLAG3(i),
l_Etc_Cost3(i),
l_PPL_ETC_Cost3(i),
l_EQPMT_ETC_COST3(i),
l_PPL_UNPLAND_EFFORT3(i),
l_EQPMT_ETC_EFFORT3(i),
l_SUB_PRJ_ETC_COST3(i),
l_SUB_PRJ_PPL_ETC_COST3(i),
l_SUB_PRJ_EQPMT_ETC_COST3(i),
l_SUB_PRJ_PPL_ETC_EFFORT3(i),
l_SUB_PRJ_EQPMT_ETC_EFFORT3(i),
l_EARNED_VALUE3(i),
l_BAC_VALUE3(i),
l_Perc_Comp_Deriv_Code3(i),
l_START_DATE4(i),
l_START_DATE_OVERRIDE4(i),
l_FINISH_DATE4(i),
l_DURATION4(i),
l_TASK_STATUS4(i),
l_PROGRESS_STATUS_WEIGHT4(i),
l_PROGRESS_OVERRIDE4(i),
l_REMAINING_EFFORT4(i),
l_PERCENT_COMPLETE4(i),
l_PERCENT_OVERRIDE4(i),
l_TASK_WEIGHT4(i),
l_NUMBER_FIELD4(i),
l_ROLLUP_NODE4(i),
l_DIRTY_FLAG4(i),
l_Etc_Cost4(i),
l_PPL_ETC_Cost4(i),
l_EQPMT_ETC_COST4(i),
l_PPL_UNPLAND_EFFORT4(i),
l_EQPMT_ETC_EFFORT4(i),
l_SUB_PRJ_ETC_COST4(i),
l_SUB_PRJ_PPL_ETC_COST4(i),
l_SUB_PRJ_EQPMT_ETC_COST4(i),
l_SUB_PRJ_PPL_ETC_EFFORT4(i),
l_SUB_PRJ_EQPMT_ETC_EFFORT4(i),
l_EARNED_VALUE4(i),
l_BAC_VALUE4(i),
l_Perc_Comp_Deriv_Code4(i),
l_START_DATE5(i),
l_START_DATE_OVERRIDE5(i),
l_FINISH_DATE5(i),
l_DURATION5(i),
l_TASK_STATUS5(i),
l_PROGRESS_STATUS_WEIGHT5(i),
l_PROGRESS_OVERRIDE5(i),
l_REMAINING_EFFORT5(i),
l_PERCENT_COMPLETE5(i),
l_PERCENT_OVERRIDE5(i),
l_TASK_WEIGHT5(i),
l_NUMBER_FIELD5(i),
l_ROLLUP_NODE5(i),
l_DIRTY_FLAG5(i),
l_Etc_Cost5(i),
l_PPL_ETC_Cost5(i),
l_EQPMT_ETC_COST5(i),
l_PPL_UNPLAND_EFFORT5(i),
l_EQPMT_ETC_EFFORT5(i),
l_SUB_PRJ_ETC_COST5(i),
l_SUB_PRJ_PPL_ETC_COST5(i),
l_SUB_PRJ_EQPMT_ETC_COST5(i),
l_SUB_PRJ_PPL_ETC_EFFORT5(i),
l_SUB_PRJ_EQPMT_ETC_EFFORT5(i),
l_EARNED_VALUE5(i),
l_BAC_VALUE5(i),
l_Perc_Comp_Deriv_Code5(i),
l_START_DATE6(i),
l_START_DATE_OVERRIDE6(i),
l_FINISH_DATE6(i),
l_DURATION6(i),
l_TASK_STATUS6(i),
l_PROGRESS_STATUS_WEIGHT6(i),
l_PROGRESS_OVERRIDE6(i),
l_REMAINING_EFFORT6(i),
l_PERCENT_COMPLETE6(i),
l_PERCENT_OVERRIDE6(i),
l_TASK_WEIGHT6(i),
l_NUMBER_FIELD6(i),
l_ROLLUP_NODE6(i),
l_DIRTY_FLAG6(i),
l_Etc_Cost6(i),
l_PPL_ETC_Cost6(i),
l_EQPMT_ETC_COST6(i),
l_PPL_UNPLAND_EFFORT6(i),
l_EQPMT_ETC_EFFORT6(i),
l_SUB_PRJ_ETC_COST6(i),
l_SUB_PRJ_PPL_ETC_COST6(i),
l_SUB_PRJ_EQPMT_ETC_COST6(i),
l_SUB_PRJ_PPL_ETC_EFFORT6(i),
l_SUB_PRJ_EQPMT_ETC_EFFORT6(i),
l_EARNED_VALUE6(i),
l_BAC_VALUE6(i),
l_Perc_Comp_Deriv_Code6(i),
l_SUMMARY_OBJECT_FLAG(i) -- 4370746
);

Line: 2072


pa_debug.write(x_Module=>'PA_SCHEDULE_OBJECTS_PVT.GENERATE_SCHEDULE', x_Msg => 'After insertion into table', x_Log_Level=> 3);

Line: 2089


l_temp_object_ids_tab.delete;

Line: 2090


l_temp_object_types_tab.delete;

Line: 2091


l_temp_dirty_flag_tab1.delete;

Line: 2092


l_temp_dirty_flag_tab2.delete;

Line: 2093


l_temp_dirty_flag_tab3.delete;

Line: 2094


l_temp_dirty_flag_tab4.delete;

Line: 2095


l_temp_dirty_flag_tab5.delete;

Line: 2096


l_temp_dirty_flag_tab6.delete;

Line: 2097


l_object_ids_tab.delete;

Line: 2098


l_object_types_tab.delete;

Line: 2099


l_dirty_flag_tab1.delete;

Line: 2100


l_dirty_flag_tab2.delete;

Line: 2101


l_dirty_flag_tab3.delete;

Line: 2102


l_dirty_flag_tab4.delete;

Line: 2103


l_dirty_flag_tab5.delete;

Line: 2104


l_dirty_flag_tab6.delete;

Line: 2113


l_int_object_ids_tab.delete;

Line: 2114


l_int_object_types_tab.delete;

Line: 2115


l_int_dirty_flag_tab1.delete;

Line: 2116


l_int_dirty_flag_tab2.delete;

Line: 2117


l_int_dirty_flag_tab3.delete;

Line: 2118


l_int_dirty_flag_tab4.delete;

Line: 2119


l_int_dirty_flag_tab5.delete;

Line: 2120


l_int_dirty_flag_tab6.delete;

Line: 2121


l_int_ref_dirty_flag_tab1.delete;

Line: 2122


l_int_ref_dirty_flag_tab2.delete;

Line: 2123


l_int_ref_dirty_flag_tab3.delete;

Line: 2124


l_int_ref_dirty_flag_tab4.delete;

Line: 2125


l_int_ref_dirty_flag_tab5.delete;

Line: 2126


l_int_ref_dirty_flag_tab6.delete;

Line: 2215


UPDATE  /*+ INDEX( T1 PA_PROJ_ROLLUP_BULK_TEMP_U1) */ PA_PROJ_ROLLUP_BULK_TEMP T1
SET    T1.DIRTY_FLAG1=l_dirty_flag_tab1(i)
, T1.DIRTY_FLAG2=l_dirty_flag_tab2(i)
, T1.DIRTY_FLAG3=l_dirty_flag_tab3(i)
, T1.DIRTY_FLAG4=l_dirty_flag_tab4(i)
, T1.DIRTY_FLAG5=l_dirty_flag_tab5(i)
, T1.DIRTY_FLAG6=l_dirty_flag_tab6(i)
WHERE T1.object_id = l_object_ids_tab(i)
AND T1.object_type = l_object_types_tab(i)
AND process_number = l_Process_Number
;

Line: 2228


l_temp_object_ids_tab.delete;

Line: 2229


l_temp_object_types_tab.delete;

Line: 2230


l_temp_dirty_flag_tab1.delete;

Line: 2231


l_temp_dirty_flag_tab2.delete;

Line: 2232


l_temp_dirty_flag_tab3.delete;

Line: 2233


l_temp_dirty_flag_tab4.delete;

Line: 2234


l_temp_dirty_flag_tab5.delete;

Line: 2235


l_temp_dirty_flag_tab6.delete;

Line: 2236


l_object_ids_tab.delete;

Line: 2237


l_object_types_tab.delete;

Line: 2238


l_dirty_flag_tab1.delete;

Line: 2239


l_dirty_flag_tab2.delete;

Line: 2240


l_dirty_flag_tab3.delete;

Line: 2241


l_dirty_flag_tab4.delete;

Line: 2242


l_dirty_flag_tab5.delete;

Line: 2243


l_dirty_flag_tab6.delete;

Line: 2253


l_int_object_ids_tab.delete;

Line: 2254


l_int_object_types_tab.delete;

Line: 2255


l_int_dirty_flag_tab1.delete;

Line: 2256


l_int_dirty_flag_tab2.delete;

Line: 2257


l_int_dirty_flag_tab3.delete;

Line: 2258


l_int_dirty_flag_tab4.delete;

Line: 2259


l_int_dirty_flag_tab5.delete;

Line: 2260


l_int_dirty_flag_tab6.delete;

Line: 2261


l_int_ref_dirty_flag_tab1.delete;

Line: 2262


l_int_ref_dirty_flag_tab2.delete;

Line: 2263


l_int_ref_dirty_flag_tab3.delete;

Line: 2264


l_int_ref_dirty_flag_tab4.delete;

Line: 2265


l_int_ref_dirty_flag_tab5.delete;

Line: 2266


l_int_ref_dirty_flag_tab6.delete;

Line: 2352


UPDATE  /*+ INDEX( T1 PA_PROJ_ROLLUP_BULK_TEMP_U1) */ PA_PROJ_ROLLUP_BULK_TEMP T1
SET    T1.DIRTY_FLAG1=l_dirty_flag_tab1(i)
, T1.DIRTY_FLAG2=l_dirty_flag_tab2(i)
, T1.DIRTY_FLAG3=l_dirty_flag_tab3(i)
, T1.DIRTY_FLAG4=l_dirty_flag_tab4(i)
, T1.DIRTY_FLAG5=l_dirty_flag_tab5(i)
, T1.DIRTY_FLAG6=l_dirty_flag_tab6(i)
WHERE T1.object_id = l_object_ids_tab(i)
AND T1.object_type = l_object_types_tab(i)
AND process_number = l_Process_Number
;

Line: 2408


, l_update_date_flag_tab1
, l_update_date_flag_tab2
, l_update_date_flag_tab3
, l_update_date_flag_tab4
, l_update_date_flag_tab5
, l_update_date_flag_tab6
, l_update_requ_flag_tab1
, l_update_requ_flag_tab2
, l_update_requ_flag_tab3
, l_update_requ_flag_tab4
, l_update_requ_flag_tab5
, l_update_requ_flag_tab6
;

Line: 2453


l_parent_update_required := 'N';

Line: 2512


SELECT /*+ index(PA_PROJ_ROLLUP_BULK_TEMP PA_PROJ_ROLLUP_BULK_TEMP_N3 ) */ --Added hint for bug 12945266
MIN(decode(p_partial_dates_flag1, 'Y', decode(rollup_node1, 'Y', start_date1, null), start_date1))
, MAX(decode(p_partial_dates_flag1, 'Y', decode(rollup_node1, 'Y', finish_date1, null), finish_date1))
, MAX(decode(p_partial_dates_flag1, 'Y', decode(rollup_node1, 'Y', DECODE(finish_date1,NULL,1,0), 0), 0))
, MAX(decode(p_partial_dates_flag1, 'Y', decode(rollup_node1, 'Y', 1, 0), 1))
, MIN(decode(p_partial_dates_flag2, 'Y', decode(rollup_node2, 'Y', start_date2, null), start_date2))
, MAX(decode(p_partial_dates_flag2, 'Y', decode(rollup_node2, 'Y', finish_date2, null), finish_date2))
, MAX(decode(p_partial_dates_flag2, 'Y', decode(rollup_node2, 'Y', DECODE(finish_date2,NULL,1,0), 0), 0))
, MAX(decode(p_partial_dates_flag2, 'Y', decode(rollup_node2, 'Y', 1, 0), 1))
, MIN(decode(p_partial_dates_flag3, 'Y', decode(rollup_node3, 'Y', start_date3, null), start_date3))
, MAX(decode(p_partial_dates_flag3, 'Y', decode(rollup_node3, 'Y', finish_date3, null), finish_date3))
, MAX(decode(p_partial_dates_flag3, 'Y', decode(rollup_node3, 'Y', DECODE(finish_date3,NULL,1,0), 0), 0))
, MAX(decode(p_partial_dates_flag3, 'Y', decode(rollup_node3, 'Y', 1, 0), 1))
, MIN(decode(p_partial_dates_flag4, 'Y', decode(rollup_node4, 'Y', start_date4, null), start_date4))
, MAX(decode(p_partial_dates_flag4, 'Y', decode(rollup_node4, 'Y', finish_date4, null), finish_date4))
, MAX(decode(p_partial_dates_flag4, 'Y', decode(rollup_node4, 'Y', DECODE(finish_date4,NULL,1,0), 0), 0))
, MAX(decode(p_partial_dates_flag4, 'Y', decode(rollup_node4, 'Y', 1, 0), 1))
, MIN(decode(p_partial_dates_flag5, 'Y', decode(rollup_node5, 'Y', start_date5, null), start_date5))
, MAX(decode(p_partial_dates_flag5, 'Y', decode(rollup_node5, 'Y', finish_date5, null), finish_date5))
, MAX(decode(p_partial_dates_flag5, 'Y', decode(rollup_node5, 'Y', DECODE(finish_date5,NULL,1,0), 0), 0))
, MAX(decode(p_partial_dates_flag5, 'Y', decode(rollup_node5, 'Y', 1, 0), 1))
, MIN(decode(p_partial_dates_flag6, 'Y', decode(rollup_node6, 'Y', start_date6, null), start_date6))
, MAX(decode(p_partial_dates_flag6, 'Y', decode(rollup_node6, 'Y', finish_date6, null), finish_date6))
, MAX(decode(p_partial_dates_flag6, 'Y', decode(rollup_node6, 'Y', DECODE(finish_date6,NULL,1,0), 0), 0))
, MAX(decode(p_partial_dates_flag6, 'Y', decode(rollup_node6, 'Y', 1, 0), 1))
, MAX(DECODE(OBJECT_TYPE,'PA_TASKS',1,0))
INTO
l_new_start_date1
, l_new_completion_date1
, l_null_flag1
, l_task_count1
, l_new_start_date2
, l_new_completion_date2
, l_null_flag2
, l_task_count2
, l_new_start_date3
, l_new_completion_date3
, l_null_flag3
, l_task_count3
, l_new_start_date4
, l_new_completion_date4
, l_null_flag4
, l_task_count4
, l_new_start_date5
, l_new_completion_date5
, l_null_flag5
, l_task_count5
, l_new_start_date6
, l_new_completion_date6
, l_null_flag6
, l_task_count6
, l_task_flag
FROM PA_PROJ_ROLLUP_BULK_TEMP
WHERE PROCESS_NUMBER = l_process_number
AND parent_object_id = l_parent_object_ids_tab(j)
AND parent_object_type IN ('PA_STRUCTURES','PA_TASKS') -- Bug 4450587
;

Line: 2570


SELECT /*+ INDEX (PA_PROJ_ROLLUP_BULK_TEMP PA_PROJ_ROLLUP_BULK_TEMP_N3)*/  --9796902
MIN(start_date1)
, MAX(finish_date1)
, MAX(DECODE(finish_date1,NULL,1,0))
, MAX(1)
, MIN(start_date2)
, MAX(finish_date2)
, MAX(DECODE(finish_date2,NULL,1,0))
, MAX(1)
, MIN(start_date3)
, MAX(finish_date3)
, MAX(DECODE(finish_date3,NULL,1,0))
, MAX(1)
, MIN(start_date4)
, MAX(finish_date4)
, MAX(DECODE(finish_date4,NULL,1,0))
, MAX(1)
, MIN(start_date5)
, MAX(finish_date5)
, MAX(DECODE(finish_date5,NULL,1,0))
, MAX(1)
, MIN(start_date6)
, MAX(finish_date6)
, MAX(DECODE(finish_date6,NULL,1,0))
, MAX(1)
, MAX(DECODE(OBJECT_TYPE,'PA_TASKS',1,0))
INTO
l_new_start_date1
, l_new_completion_date1
, l_null_flag1
, l_task_count1
, l_new_start_date2
, l_new_completion_date2
, l_null_flag2
, l_task_count2
, l_new_start_date3
, l_new_completion_date3
, l_null_flag3
, l_task_count3
, l_new_start_date4
, l_new_completion_date4
, l_null_flag4
, l_task_count4
, l_new_start_date5
, l_new_completion_date5
, l_null_flag5
, l_task_count5
, l_new_start_date6
, l_new_completion_date6
, l_null_flag6
, l_task_count6
, l_task_flag
FROM PA_PROJ_ROLLUP_BULK_TEMP
WHERE PROCESS_NUMBER = l_process_number
AND parent_object_id = l_parent_object_ids_tab(j)
AND parent_object_type IN ('PA_STRUCTURES','PA_TASKS') -- Bug 4450587
;

Line: 2631


SELECT
/*+ INDEX (PA_PROJ_ROLLUP_BULK_TEMP PA_PROJ_ROLLUP_BULK_TEMP_N3)*/
MAX(DECODE(finish_date1,NULL,1,0)),
MAX(DECODE(finish_date2,NULL,1,0))
INTO l_null_flag1,
l_null_flag2
FROM PA_PROJ_ROLLUP_BULK_TEMP
WHERE PROCESS_NUMBER  = l_process_number
AND parent_object_id    = l_parent_object_ids_tab(j)
AND parent_object_type IN ('PA_STRUCTURES','PA_TASKS')
AND object_type        <> 'PA_ASSIGNMENTS';

Line: 2665


l_update_requ_flag_tab1(j) := 'N';

Line: 2669


l_update_requ_flag_tab1(j) := 'N';

Line: 2671


l_parent_update_required := 'Y';

Line: 2672


l_update_requ_flag_tab1(j) := 'Y';

Line: 2676


l_update_date_flag_tab1(j) := 'N';

Line: 2678


l_update_date_flag_tab1(j) := 'Y';

Line: 2684


l_update_date_flag_tab1(j) := 'N';

Line: 2686


l_update_date_flag_tab1(j) := 'Y';

Line: 2692


l_update_date_flag_tab1(j) := 'Y';

Line: 2694


l_update_date_flag_tab1(j) := 'Y';

Line: 2701


l_update_requ_flag_tab1(j) := 'N';

Line: 2703


l_parent_update_required := 'Y';

Line: 2704


l_update_requ_flag_tab1(j) := 'Y';

Line: 2719


l_update_date_flag_tab1(j) :='Y';

Line: 2722


l_update_date_flag_tab1(j) :='N';

Line: 2724


l_update_date_flag_tab1(j) :='Y';

Line: 2731


l_update_requ_flag_tab2(j) := 'N';

Line: 2735


l_update_requ_flag_tab2(j) := 'N';

Line: 2737


l_parent_update_required := 'Y';

Line: 2738


l_update_requ_flag_tab2(j) := 'Y';

Line: 2742


l_update_date_flag_tab2(j) := 'N';

Line: 2744


l_update_date_flag_tab2(j) := 'Y';

Line: 2750


l_update_date_flag_tab2(j) := 'N';

Line: 2752


l_update_date_flag_tab2(j) := 'Y';

Line: 2758


l_update_date_flag_tab2(j) := 'Y';

Line: 2760


l_update_date_flag_tab2(j) := 'Y';

Line: 2767


l_update_requ_flag_tab2(j) := 'N';

Line: 2769


l_parent_update_required := 'Y';

Line: 2770


l_update_requ_flag_tab2(j) := 'Y';

Line: 2785


l_update_date_flag_tab2(j) :='Y';

Line: 2788


l_update_date_flag_tab2(j) :='N';

Line: 2790


l_update_date_flag_tab2(j) :='Y';

Line: 2797


l_update_requ_flag_tab3(j) := 'N';

Line: 2801


l_update_requ_flag_tab3(j) := 'N';

Line: 2803


l_parent_update_required := 'Y';

Line: 2804


l_update_requ_flag_tab3(j) := 'Y';

Line: 2808


l_update_date_flag_tab3(j) := 'N';

Line: 2810


l_update_date_flag_tab3(j) := 'Y';

Line: 2816


l_update_date_flag_tab3(j) := 'N';

Line: 2818


l_update_date_flag_tab3(j) := 'Y';

Line: 2824


l_update_date_flag_tab3(j) := 'Y';

Line: 2826


l_update_date_flag_tab3(j) := 'Y';

Line: 2833


l_update_requ_flag_tab3(j) := 'N';

Line: 2835


l_parent_update_required := 'Y';

Line: 2836


l_update_requ_flag_tab3(j) := 'Y';

Line: 2851


l_update_date_flag_tab3(j) :='Y';

Line: 2854


l_update_date_flag_tab3(j) :='N';

Line: 2856


l_update_date_flag_tab3(j) :='Y';

Line: 2863


l_update_requ_flag_tab4(j) := 'N';

Line: 2867


l_update_requ_flag_tab4(j) := 'N';

Line: 2869


l_parent_update_required := 'Y';

Line: 2870


l_update_requ_flag_tab4(j) := 'Y';

Line: 2874


l_update_date_flag_tab4(j) := 'N';

Line: 2876


l_update_date_flag_tab4(j) := 'Y';

Line: 2882


l_update_date_flag_tab4(j) := 'N';

Line: 2884


l_update_date_flag_tab4(j) := 'Y';

Line: 2890


l_update_date_flag_tab4(j) := 'Y';

Line: 2892


l_update_date_flag_tab4(j) := 'Y';

Line: 2899


l_update_requ_flag_tab4(j) := 'N';

Line: 2901


l_parent_update_required := 'Y';

Line: 2902


l_update_requ_flag_tab4(j) := 'Y';

Line: 2917


l_update_date_flag_tab4(j) :='Y';

Line: 2920


l_update_date_flag_tab4(j) :='N';

Line: 2922


l_update_date_flag_tab4(j) :='Y';

Line: 2929


l_update_requ_flag_tab5(j) := 'N';

Line: 2933


l_update_requ_flag_tab5(j) := 'N';

Line: 2935


l_parent_update_required := 'Y';

Line: 2936


l_update_requ_flag_tab5(j) := 'Y';

Line: 2940


l_update_date_flag_tab5(j) := 'N';

Line: 2942


l_update_date_flag_tab5(j) := 'Y';

Line: 2948


l_update_date_flag_tab5(j) := 'N';

Line: 2950


l_update_date_flag_tab5(j) := 'Y';

Line: 2956


l_update_date_flag_tab5(j) := 'Y';

Line: 2958


l_update_date_flag_tab5(j) := 'Y';

Line: 2965


l_update_requ_flag_tab5(j) := 'N';

Line: 2967


l_parent_update_required := 'Y';

Line: 2968


l_update_requ_flag_tab5(j) := 'Y';

Line: 2983


l_update_date_flag_tab5(j) :='Y';

Line: 2986


l_update_date_flag_tab5(j) :='N';

Line: 2988


l_update_date_flag_tab5(j) :='Y';

Line: 2995


l_update_requ_flag_tab6(j) := 'N';

Line: 2999


l_update_requ_flag_tab6(j) := 'N';

Line: 3001


l_parent_update_required := 'Y';

Line: 3002


l_update_requ_flag_tab6(j) := 'Y';

Line: 3006


l_update_date_flag_tab6(j) := 'N';

Line: 3008


l_update_date_flag_tab6(j) := 'Y';

Line: 3014


l_update_date_flag_tab6(j) := 'N';

Line: 3016


l_update_date_flag_tab6(j) := 'Y';

Line: 3022


l_update_date_flag_tab6(j) := 'Y';

Line: 3024


l_update_date_flag_tab6(j) := 'Y';

Line: 3031


l_update_requ_flag_tab6(j) := 'N';

Line: 3033


l_parent_update_required := 'Y';

Line: 3034


l_update_requ_flag_tab6(j) := 'Y';

Line: 3049


l_update_date_flag_tab6(j) :='Y';

Line: 3052


l_update_date_flag_tab6(j) :='N';

Line: 3054


l_update_date_flag_tab6(j) :='Y';

Line: 3062


IF (l_update_requ_flag_tab1(j) = 'Y') THEN
IF (l_update_date_flag_tab1(j) = 'Y') THEN
l_parent_start_date1_tmp  := l_parent_start_date_tab1(j);

Line: 3071


IF (l_update_requ_flag_tab2(j) = 'Y') THEN
IF (l_update_date_flag_tab2(j) = 'Y') THEN
l_parent_start_date2_tmp  := l_parent_start_date_tab2(j);

Line: 3080


IF (l_update_requ_flag_tab3(j) = 'Y') THEN
IF (l_update_date_flag_tab3(j) = 'Y') THEN
l_parent_start_date3_tmp  := l_parent_start_date_tab3(j);

Line: 3089


IF (l_update_requ_flag_tab4(j) = 'Y') THEN
IF (l_update_date_flag_tab4(j) = 'Y') THEN
l_parent_start_date4_tmp  := l_parent_start_date_tab4(j);

Line: 3098


IF (l_update_requ_flag_tab5(j) = 'Y') THEN
IF (l_update_date_flag_tab5(j) = 'Y') THEN
l_parent_start_date5_tmp  := l_parent_start_date_tab5(j);

Line: 3107


IF (l_update_requ_flag_tab6(j) = 'Y') THEN
IF (l_update_date_flag_tab6(j) = 'Y') THEN
l_parent_start_date6_tmp  := l_parent_start_date_tab6(j);

Line: 3118


IF l_parent_update_required = 'Y' THEN
/* Commented the following update statement and introduced a new one for bug#6185523
UPDATE  + INDEX( SchTmp PA_PROJ_ROLLUP_BULK_TEMP_U1)   PA_PROJ_ROLLUP_BULK_TEMP SchTmp SET
start_date1  = decode(l_update_requ_flag_tab1(j), 'Y', decode(l_update_date_flag_tab1(j), 'Y', l_parent_start_date_tab1(j), start_date1), start_date1)
, finish_date1 = decode(l_update_requ_flag_tab1(j), 'Y', decode(l_update_date_flag_tab1(j), 'Y', l_parent_finish_date_tab1(j),finish_date1),finish_date1)
, duration1    = decode(l_update_requ_flag_tab1(j), 'Y', decode(l_update_date_flag_tab1(j), 'Y', l_parent_duration_tab1(j), duration1), duration1)
, start_date2  = decode(l_update_requ_flag_tab2(j), 'Y', decode(l_update_date_flag_tab2(j), 'Y', l_parent_start_date_tab2(j), start_date2), start_date2)
, finish_date2 = decode(l_update_requ_flag_tab2(j), 'Y', decode(l_update_date_flag_tab2(j), 'Y', l_parent_finish_date_tab2(j), finish_date2), finish_date2)
, duration2    = decode(l_update_requ_flag_tab2(j), 'Y', decode(l_update_date_flag_tab2(j), 'Y', l_parent_duration_tab2(j), duration2), duration2)
, start_date3  = decode(l_update_requ_flag_tab3(j), 'Y', decode(l_update_date_flag_tab3(j), 'Y', l_parent_start_date_tab3(j), start_date3), start_date3)
, finish_date3 = decode(l_update_requ_flag_tab3(j), 'Y', decode(l_update_date_flag_tab3(j), 'Y', l_parent_finish_date_tab3(j), finish_date3), finish_date3)
, duration3    = decode(l_update_requ_flag_tab3(j), 'Y', decode(l_update_date_flag_tab3(j), 'Y', l_parent_duration_tab3(j), duration3), duration3)
, start_date4  = decode(l_update_requ_flag_tab4(j), 'Y', decode(l_update_date_flag_tab4(j), 'Y', l_parent_start_date_tab4(j), start_date4), start_date4)
, finish_date4 = decode(l_update_requ_flag_tab4(j), 'Y', decode(l_update_date_flag_tab4(j), 'Y', l_parent_finish_date_tab4(j), finish_date4), finish_date4)
, duration4    = decode(l_update_requ_flag_tab4(j), 'Y', decode(l_update_date_flag_tab4(j), 'Y', l_parent_duration_tab4(j), duration4), duration4)
, start_date5  = decode(l_update_requ_flag_tab5(j), 'Y', decode(l_update_date_flag_tab5(j), 'Y', l_parent_start_date_tab5(j), start_date5), start_date5)
, finish_date5 = decode(l_update_requ_flag_tab5(j), 'Y', decode(l_update_date_flag_tab5(j), 'Y', l_parent_finish_date_tab5(j), finish_date5), finish_date5)
, duration5    = decode(l_update_requ_flag_tab5(j), 'Y', decode(l_update_date_flag_tab5(j), 'Y', l_parent_duration_tab5(j), duration5), duration5)
, start_date6  = decode(l_update_requ_flag_tab6(j), 'Y', decode(l_update_date_flag_tab6(j), 'Y', l_parent_start_date_tab6(j), start_date6), start_date6)
, finish_date6 = decode(l_update_requ_flag_tab6(j), 'Y', decode(l_update_date_flag_tab6(j), 'Y', l_parent_finish_date_tab6(j), finish_date6), finish_date6)
, duration6    = decode(l_update_requ_flag_tab6(j), 'Y', decode(l_update_date_flag_tab6(j), 'Y', l_parent_duration_tab6(j), duration6), duration6)
, dirty_flag1  = decode(l_update_requ_flag_tab1(j), 'Y', 'N',dirty_flag1)
, dirty_flag2  = decode(l_update_requ_flag_tab2(j), 'Y', 'N',dirty_flag2)
, dirty_flag3  = decode(l_update_requ_flag_tab3(j), 'Y', 'N',dirty_flag3)
, dirty_flag4  = decode(l_update_requ_flag_tab4(j), 'Y', 'N',dirty_flag4)
, dirty_flag5  = decode(l_update_requ_flag_tab5(j), 'Y', 'N',dirty_flag5)
, dirty_flag6  = decode(l_update_requ_flag_tab6(j), 'Y', 'N',dirty_flag6)
WHERE object_id = l_parent_object_ids_tab(j)
AND object_type = l_parent_object_types_tab(j)
and process_number = l_process_number;

Line: 3148


Ends commented code for bug#6185523 And added the below update*/

UPDATE  /*+ INDEX( SchTmp PA_PROJ_ROLLUP_BULK_TEMP_U1) */  PA_PROJ_ROLLUP_BULK_TEMP SchTmp SET
start_date1  = nvl(l_parent_start_date1_tmp, start_date1)
, finish_date1 = nvl(l_parent_finish_date1_tmp, finish_date1)
, duration1    = nvl(l_parent_duration1_tmp, duration1)
, start_date2  = nvl(l_parent_start_date2_tmp, start_date2)
, finish_date2 = nvl(l_parent_finish_date2_tmp, finish_date2)
, duration2    = nvl(l_parent_duration2_tmp, duration2)
, start_date3  = nvl(l_parent_start_date3_tmp, start_date3)
, finish_date3 = nvl(l_parent_finish_date3_tmp, finish_date3)
, duration3    = nvl(l_parent_duration3_tmp, duration3)
, start_date4  = nvl(l_parent_start_date4_tmp, start_date4)
, finish_date4 = nvl(l_parent_finish_date4_tmp, finish_date4)
, duration4    = nvl(l_parent_duration4_tmp, duration4)
, start_date5  = nvl(l_parent_start_date5_tmp, start_date5)
, finish_date5 = nvl(l_parent_finish_date5_tmp, finish_date5)
, duration5    = nvl(l_parent_duration5_tmp, duration5)
, start_date6  = nvl(l_parent_start_date6_tmp, start_date6)
, finish_date6 = nvl(l_parent_finish_date6_tmp, finish_date6)
, duration6    = nvl(l_parent_duration6_tmp, duration6)
, dirty_flag1  = nvl(dirty_flag1_tmp, dirty_flag1)
, dirty_flag2  = nvl(dirty_flag2_tmp, dirty_flag2)
, dirty_flag3  = nvl(dirty_flag3_tmp, dirty_flag3)
, dirty_flag4  = nvl(dirty_flag4_tmp, dirty_flag4)
, dirty_flag5  = nvl(dirty_flag5_tmp, dirty_flag5)
, dirty_flag6  = nvl(dirty_flag6_tmp, dirty_flag6)
WHERE object_id = l_parent_object_ids_tab(j)
AND object_type = l_parent_object_types_tab(j)
and process_number = l_process_number;

Line: 3193


l_child_update_required := 'N';

Line: 3236


l_child_update_required := 'N';

Line: 3246


l_child_update_required := 'Y';

Line: 3256


l_child_update_required := 'Y';

Line: 3266


l_child_update_required := 'Y';

Line: 3281


l_child_update_required := 'Y';

Line: 3291


l_child_update_required := 'Y';

Line: 3301


l_child_update_required := 'Y';

Line: 3316


l_child_update_required := 'Y';

Line: 3326


l_child_update_required := 'Y';

Line: 3336


l_child_update_required := 'Y';

Line: 3351


l_child_update_required := 'Y';

Line: 3361


l_child_update_required := 'Y';

Line: 3371


l_child_update_required := 'Y';

Line: 3386


l_child_update_required := 'Y';

Line: 3396


l_child_update_required := 'Y';

Line: 3406


l_child_update_required := 'Y';

Line: 3421


l_child_update_required := 'Y';

Line: 3431


l_child_update_required := 'Y';

Line: 3441


l_child_update_required := 'Y';

Line: 3453


IF l_child_update_required = 'Y' THEN
FORALL i in 1..l_child_object_ids_tab.count
UPDATE PA_PROJ_ROLLUP_BULK_TEMP T1
SET    T1.start_date1=decode(l_child_upd_req_flag_tab1(i), 'Y', l_child_start_date_tab1(i), T1.start_date1)
, T1.start_date2=decode(l_child_upd_req_flag_tab2(i), 'Y', l_child_start_date_tab2(i), T1.start_date2)
, T1.start_date3=decode(l_child_upd_req_flag_tab3(i), 'Y', l_child_start_date_tab3(i), T1.start_date3)
, T1.start_date4=decode(l_child_upd_req_flag_tab4(i), 'Y', l_child_start_date_tab4(i), T1.start_date4)
, T1.start_date5=decode(l_child_upd_req_flag_tab5(i), 'Y', l_child_start_date_tab5(i), T1.start_date5)
, T1.start_date6=decode(l_child_upd_req_flag_tab6(i), 'Y', l_child_start_date_tab6(i), T1.start_date6)
, T1.finish_date1=decode(l_child_upd_req_flag_tab1(i), 'Y', l_child_finish_date_tab1(i), T1.finish_date1)
, T1.finish_date2=decode(l_child_upd_req_flag_tab2(i), 'Y', l_child_finish_date_tab2(i), T1.finish_date2)
, T1.finish_date3=decode(l_child_upd_req_flag_tab3(i), 'Y', l_child_finish_date_tab3(i), T1.finish_date3)
, T1.finish_date4=decode(l_child_upd_req_flag_tab4(i), 'Y', l_child_finish_date_tab4(i), T1.finish_date4)
, T1.finish_date5=decode(l_child_upd_req_flag_tab5(i), 'Y', l_child_finish_date_tab5(i), T1.finish_date5)
, T1.finish_date6=decode(l_child_upd_req_flag_tab6(i), 'Y', l_child_finish_date_tab6(i), T1.finish_date6)
, T1.duration1=decode(l_child_upd_req_flag_tab1(i), 'Y', l_child_duration_tab1(i), T1.duration1)
, T1.duration2=decode(l_child_upd_req_flag_tab2(i), 'Y', l_child_duration_tab2(i), T1.duration2)
, T1.duration3=decode(l_child_upd_req_flag_tab3(i), 'Y', l_child_duration_tab3(i), T1.duration3)
, T1.duration4=decode(l_child_upd_req_flag_tab4(i), 'Y', l_child_duration_tab4(i), T1.duration4)
, T1.duration5=decode(l_child_upd_req_flag_tab5(i), 'Y', l_child_duration_tab5(i), T1.duration5)
, T1.duration6=decode(l_child_upd_req_flag_tab6(i), 'Y', l_child_duration_tab6(i), T1.duration6)
, T1.DIRTY_FLAG1=decode(l_child_upd_req_flag_tab1(i), 'Y', 'N', T1.DIRTY_FLAG1)
, T1.DIRTY_FLAG2=decode(l_child_upd_req_flag_tab2(i), 'Y', 'N', T1.DIRTY_FLAG2)
, T1.DIRTY_FLAG3=decode(l_child_upd_req_flag_tab3(i), 'Y', 'N', T1.DIRTY_FLAG3)
, T1.DIRTY_FLAG4=decode(l_child_upd_req_flag_tab4(i), 'Y', 'N', T1.DIRTY_FLAG4)
, T1.DIRTY_FLAG5=decode(l_child_upd_req_flag_tab5(i), 'Y', 'N', T1.DIRTY_FLAG5)
, T1.DIRTY_FLAG6=decode(l_child_upd_req_flag_tab6(i), 'Y', 'N', T1.DIRTY_FLAG6)
WHERE T1.object_id = l_child_object_ids_tab(i)
AND T1.object_type = l_child_object_types_tab(i)
AND process_number = l_Process_Number;

Line: 3485


l_object_ids_tab.delete;

Line: 3486


l_object_types_tab.delete;

Line: 3489


l_parent_object_ids_tab.delete;

Line: 3490


l_parent_object_types_tab.delete;

Line: 3491


l_parent_start_date_tab1.delete;

Line: 3492


l_parent_start_date_tab2.delete;

Line: 3493


l_parent_start_date_tab3.delete;

Line: 3494


l_parent_start_date_tab4.delete;

Line: 3495


l_parent_start_date_tab5.delete;

Line: 3496


l_parent_start_date_tab6.delete;

Line: 3497


l_parent_finish_date_tab1.delete;

Line: 3498


l_parent_finish_date_tab2.delete;

Line: 3499


l_parent_finish_date_tab3.delete;

Line: 3500


l_parent_finish_date_tab4.delete;

Line: 3501


l_parent_finish_date_tab5.delete;

Line: 3502


l_parent_finish_date_tab6.delete;

Line: 3503


l_parent_duration_tab1.delete;

Line: 3504


l_parent_duration_tab2.delete;

Line: 3505


l_parent_duration_tab3.delete;

Line: 3506


l_parent_duration_tab4.delete;

Line: 3507


l_parent_duration_tab5.delete;

Line: 3508


l_parent_duration_tab6.delete;

Line: 3509


l_parent_dirty_flag_tab1.delete;

Line: 3510


l_parent_dirty_flag_tab2.delete;

Line: 3511


l_parent_dirty_flag_tab3.delete;

Line: 3512


l_parent_dirty_flag_tab4.delete;

Line: 3513


l_parent_dirty_flag_tab5.delete;

Line: 3514


l_parent_dirty_flag_tab6.delete;

Line: 3515


l_parent_start_date_or_tab1.delete;

Line: 3516


l_parent_start_date_or_tab2.delete;

Line: 3517


l_parent_start_date_or_tab3.delete;

Line: 3518


l_parent_start_date_or_tab4.delete;

Line: 3519


l_parent_start_date_or_tab5.delete;

Line: 3520


l_parent_start_date_or_tab6.delete;

Line: 3574


SELECT MAX(decode(p_partial_dates_flag1, 'Y',decode(rollup_node1, 'Y', decode(dirty_flag1,'Y',1,0), 0),decode(dirty_flag1,'Y',1,0)))
, MAX(decode(p_partial_dates_flag2, 'Y',decode(rollup_node2, 'Y', decode(dirty_flag2,'Y',1,0), 0),decode(dirty_flag2,'Y',1,0)))
, MAX(decode(p_partial_dates_flag3, 'Y',decode(rollup_node3, 'Y', decode(dirty_flag3,'Y',1,0), 0),decode(dirty_flag3,'Y',1,0)))
, MAX(decode(p_partial_dates_flag4, 'Y',decode(rollup_node4, 'Y', decode(dirty_flag4,'Y',1,0), 0),decode(dirty_flag4,'Y',1,0)))
, MAX(decode(p_partial_dates_flag5, 'Y',decode(rollup_node5, 'Y', decode(dirty_flag5,'Y',1,0), 0),decode(dirty_flag5,'Y',1,0)))
, MAX(decode(p_partial_dates_flag6, 'Y',decode(rollup_node6, 'Y', decode(dirty_flag6,'Y',1,0), 0),decode(dirty_flag6,'Y',1,0)))
INTO l_count1, l_count2, l_count3, l_count4, l_count5, l_count6
FROM PA_PROJ_ROLLUP_BULK_TEMP
WHERE PROCESS_NUMBER = l_process_number
AND parent_object_id = l_parent_object_ids_tab(j)
AND (DIRTY_FLAG1 = 'Y' OR DIRTY_FLAG2 = 'Y'  OR DIRTY_FLAG3 = 'Y'
OR DIRTY_FLAG4 = 'Y' OR DIRTY_FLAG5 = 'Y' OR DIRTY_FLAG6 = 'Y')
;

Line: 3627


l_update_date_flag_tab1.extend(1);

Line: 3628


l_update_date_flag_tab2.extend(1);

Line: 3629


l_update_date_flag_tab3.extend(1);

Line: 3630


l_update_date_flag_tab4.extend(1);

Line: 3631


l_update_date_flag_tab5.extend(1);

Line: 3632


l_update_date_flag_tab6.extend(1);

Line: 3651


l_update_requ_flag_tab1.extend(1);

Line: 3652


l_update_requ_flag_tab2.extend(1);

Line: 3653


l_update_requ_flag_tab3.extend(1);

Line: 3654


l_update_requ_flag_tab4.extend(1);

Line: 3655


l_update_requ_flag_tab5.extend(1);

Line: 3656


l_update_requ_flag_tab6.extend(1);

Line: 3678


l_parent_update_required := 'N';

Line: 3695


SELECT
MIN(decode(p_partial_dates_flag1, 'Y', decode(rollup_node1, 'Y', start_date1, null), start_date1))
, MAX(decode(p_partial_dates_flag1, 'Y', decode(rollup_node1, 'Y', finish_date1, null), finish_date1))
, MAX(decode(p_partial_dates_flag1, 'Y', decode(rollup_node1, 'Y', DECODE(finish_date1,NULL,1,0), 0), 0))
, MAX(decode(p_partial_dates_flag1, 'Y', decode(rollup_node1, 'Y', 1, 0), 1))
, MIN(decode(p_partial_dates_flag2, 'Y', decode(rollup_node2, 'Y', start_date2, null), null))
, MAX(decode(p_partial_dates_flag2, 'Y', decode(rollup_node2, 'Y', finish_date2, null), null))
, MAX(decode(p_partial_dates_flag2, 'Y', decode(rollup_node2, 'Y', DECODE(finish_date2,NULL,1,0), 0), 0))
, MAX(decode(p_partial_dates_flag2, 'Y', decode(rollup_node2, 'Y', 1, 0), 1))
, MIN(decode(p_partial_dates_flag3, 'Y', decode(rollup_node3, 'Y', start_date3, null), null))
, MAX(decode(p_partial_dates_flag3, 'Y', decode(rollup_node3, 'Y', finish_date3, null), null))
, MAX(decode(p_partial_dates_flag3, 'Y', decode(rollup_node3, 'Y', DECODE(finish_date3,NULL,1,0), 0), 0))
, MAX(decode(p_partial_dates_flag3, 'Y', decode(rollup_node3, 'Y', 1, 0), 1))
, MIN(decode(p_partial_dates_flag4, 'Y', decode(rollup_node4, 'Y', start_date4, null), null))
, MAX(decode(p_partial_dates_flag4, 'Y', decode(rollup_node4, 'Y', finish_date4, null), null))
, MAX(decode(p_partial_dates_flag4, 'Y', decode(rollup_node4, 'Y', DECODE(finish_date4,NULL,1,0), 0), 0))
, MAX(decode(p_partial_dates_flag4, 'Y', decode(rollup_node4, 'Y', 1, 0), 1))
, MIN(decode(p_partial_dates_flag5, 'Y', decode(rollup_node5, 'Y', start_date5, null), null))
, MAX(decode(p_partial_dates_flag5, 'Y', decode(rollup_node5, 'Y', finish_date5, null), null))
, MAX(decode(p_partial_dates_flag5, 'Y', decode(rollup_node5, 'Y', DECODE(finish_date5,NULL,1,0), 0), 0))
, MAX(decode(p_partial_dates_flag5, 'Y', decode(rollup_node5, 'Y', 1, 0), 1))
, MIN(decode(p_partial_dates_flag6, 'Y', decode(rollup_node6, 'Y', start_date6, null), null))
, MAX(decode(p_partial_dates_flag6, 'Y', decode(rollup_node6, 'Y', finish_date6, null), null))
, MAX(decode(p_partial_dates_flag6, 'Y', decode(rollup_node6, 'Y', DECODE(finish_date6,NULL,1,0), 0), 0))
, MAX(decode(p_partial_dates_flag6, 'Y', decode(rollup_node6, 'Y', 1, 0), 1))
, MAX(DECODE(OBJECT_TYPE,'PA_TASKS',1,0))

INTO
l_new_start_date1(l_counter)
, l_new_completion_date1(l_counter)
, l_null_flag1
, l_task_count1
, l_new_start_date2(l_counter)
, l_new_completion_date2(l_counter)
, l_null_flag2
, l_task_count2
, l_new_start_date3(l_counter)
, l_new_completion_date3(l_counter)
, l_null_flag3
, l_task_count3
, l_new_start_date4(l_counter)
, l_new_completion_date4(l_counter)
, l_null_flag4
, l_task_count4
, l_new_start_date5(l_counter)
, l_new_completion_date5(l_counter)
, l_null_flag5
, l_task_count5
, l_new_start_date6(l_counter)
, l_new_completion_date6(l_counter)
, l_null_flag6
, l_task_count6
, l_task_flag
FROM PA_PROJ_ROLLUP_BULK_TEMP
WHERE PROCESS_NUMBER = l_process_number
AND parent_object_id = l_parent_object_ids_tab(j);

Line: 3764


l_update_requ_flag_tab1(l_counter) := 'N';

Line: 3778


l_update_date_flag_tab1(l_counter) :='Y';

Line: 3781


l_update_date_flag_tab1(l_counter) :='N';

Line: 3783


l_update_date_flag_tab1(l_counter) :='Y';

Line: 3788


l_update_requ_flag_tab1(l_counter) := 'N';

Line: 3790


l_update_requ_flag_tab1(l_counter) := 'Y';

Line: 3791


l_parent_update_required := 'Y';

Line: 3795


l_update_requ_flag_tab2(l_counter) := 'N';

Line: 3809


l_update_date_flag_tab2(l_counter) :='Y';

Line: 3812


l_update_date_flag_tab2(l_counter) :='N';

Line: 3814


l_update_date_flag_tab2(l_counter) :='Y';

Line: 3819


l_update_requ_flag_tab2(l_counter) := 'N';

Line: 3821


l_update_requ_flag_tab2(l_counter) := 'Y';

Line: 3822


l_parent_update_required := 'Y';

Line: 3826


l_update_requ_flag_tab3(l_counter) := 'N';

Line: 3840


l_update_date_flag_tab3(l_counter) :='Y';

Line: 3843


l_update_date_flag_tab3(l_counter) :='N';

Line: 3845


l_update_date_flag_tab3(l_counter) :='Y';

Line: 3850


l_update_requ_flag_tab3(l_counter) := 'N';

Line: 3852


l_update_requ_flag_tab3(l_counter) := 'Y';

Line: 3853


l_parent_update_required := 'Y';

Line: 3857


l_update_requ_flag_tab4(l_counter) := 'N';

Line: 3871


l_update_date_flag_tab4(l_counter) :='Y';

Line: 3874


l_update_date_flag_tab4(l_counter) :='N';

Line: 3876


l_update_date_flag_tab4(l_counter) :='Y';

Line: 3881


l_update_requ_flag_tab4(l_counter) := 'N';

Line: 3883


l_update_requ_flag_tab4(l_counter) := 'Y';

Line: 3884


l_parent_update_required := 'Y';

Line: 3888


l_update_requ_flag_tab5(l_counter) := 'N';

Line: 3902


l_update_date_flag_tab5(l_counter) :='Y';

Line: 3905


l_update_date_flag_tab5(l_counter) :='N';

Line: 3907


l_update_date_flag_tab5(l_counter) :='Y';

Line: 3912


l_update_requ_flag_tab5(l_counter) := 'N';

Line: 3914


l_update_requ_flag_tab5(l_counter) := 'Y';

Line: 3915


l_parent_update_required := 'Y';

Line: 3919


l_update_requ_flag_tab6(l_counter) := 'N';

Line: 3933


l_update_date_flag_tab6(l_counter) :='Y';

Line: 3936


l_update_date_flag_tab6(l_counter) :='N';

Line: 3938


l_update_date_flag_tab6(l_counter) :='Y';

Line: 3943


l_update_requ_flag_tab6(l_counter) := 'N';

Line: 3945


l_update_requ_flag_tab6(l_counter) := 'Y';

Line: 3946


l_parent_update_required := 'Y';

Line: 3955


IF l_parent_update_required = 'Y' THEN
UPDATE PA_PROJ_ROLLUP_BULK_TEMP SET
start_date1  = decode(l_update_requ_flag_tab1(l_counter), 'Y', decode(l_update_date_flag_tab1(l_counter), 'Y', l_new_start_date1(l_counter), start_date1),start_date1)
, finish_date1 = decode(l_update_requ_flag_tab1(l_counter), 'Y', decode(l_update_date_flag_tab1(l_counter), 'Y', l_new_completion_date1(l_counter),finish_date1),finish_date1)
, duration1    = decode(l_update_requ_flag_tab1(l_counter), 'Y', decode(l_update_date_flag_tab1(l_counter), 'Y', l_new_duration1(l_counter), duration1), duration1)
, start_date2  = decode(l_update_requ_flag_tab2(l_counter), 'Y', decode(l_update_date_flag_tab2(l_counter), 'Y', l_new_start_date2(l_counter), start_date2), start_date2)
, finish_date2 = decode(l_update_requ_flag_tab2(l_counter), 'Y', decode(l_update_date_flag_tab2(l_counter), 'Y', l_new_completion_date2(l_counter), finish_date2), finish_date2)
, duration2    = decode(l_update_requ_flag_tab2(l_counter), 'Y', decode(l_update_date_flag_tab2(l_counter), 'Y', l_new_duration2(l_counter), duration2), duration2)
, start_date3  = decode(l_update_requ_flag_tab3(l_counter), 'Y', decode(l_update_date_flag_tab3(l_counter), 'Y', l_new_start_date3(l_counter), start_date3), start_date3)
, finish_date3 = decode(l_update_requ_flag_tab3(l_counter), 'Y', decode(l_update_date_flag_tab3(l_counter), 'Y', l_new_completion_date3(l_counter), finish_date3), finish_date3)
, duration3    = decode(l_update_requ_flag_tab3(l_counter), 'Y', decode(l_update_date_flag_tab3(l_counter), 'Y', l_new_duration3(l_counter), duration3), duration3)
, start_date4  = decode(l_update_requ_flag_tab4(l_counter), 'Y', decode(l_update_date_flag_tab4(l_counter), 'Y', l_new_start_date4(l_counter), start_date4), start_date4)
, finish_date4 = decode(l_update_requ_flag_tab4(l_counter), 'Y', decode(l_update_date_flag_tab4(l_counter), 'Y', l_new_completion_date4(l_counter), finish_date4), finish_date4)
, duration4    = decode(l_update_requ_flag_tab4(l_counter), 'Y', decode(l_update_date_flag_tab4(l_counter), 'Y', l_new_duration4(l_counter), duration4), duration4)
, start_date5  = decode(l_update_requ_flag_tab5(l_counter), 'Y', decode(l_update_date_flag_tab5(l_counter), 'Y', l_new_start_date5(l_counter), start_date5), start_date5)
, finish_date5 = decode(l_update_requ_flag_tab5(l_counter), 'Y', decode(l_update_date_flag_tab5(l_counter), 'Y', l_new_completion_date5(l_counter), finish_date5), finish_date5)
, duration5    = decode(l_update_requ_flag_tab5(l_counter), 'Y', decode(l_update_date_flag_tab5(l_counter), 'Y', l_new_duration5(l_counter), duration5), duration5)
, start_date6  = decode(l_update_requ_flag_tab6(l_counter), 'Y', decode(l_update_date_flag_tab6(l_counter), 'Y', l_new_start_date6(l_counter), start_date6), start_date6)
, finish_date6 = decode(l_update_requ_flag_tab6(l_counter), 'Y', decode(l_update_date_flag_tab6(l_counter), 'Y', l_new_completion_date6(l_counter), finish_date6), finish_date6)
, duration6    = decode(l_update_requ_flag_tab6(l_counter), 'Y', decode(l_update_date_flag_tab6(l_counter), 'Y', l_new_duration6(l_counter), duration6), duration6)
, dirty_flag1  = decode(l_update_requ_flag_tab1(l_counter), 'Y', 'N', dirty_flag1)
, dirty_flag2  = decode(l_update_requ_flag_tab2(l_counter), 'Y', 'N', dirty_flag2)
, dirty_flag3  = decode(l_update_requ_flag_tab3(l_counter), 'Y', 'N', dirty_flag3)
, dirty_flag4  = decode(l_update_requ_flag_tab4(l_counter), 'Y', 'N', dirty_flag4)
, dirty_flag5  = decode(l_update_requ_flag_tab5(l_counter), 'Y', 'N', dirty_flag5)
, dirty_flag6  = decode(l_update_requ_flag_tab6(l_counter), 'Y', 'N', dirty_flag6)
WHERE object_id = l_object_ids_tab(l_counter)
AND object_type = l_object_types_tab(l_counter)
and process_number = l_process_number;

Line: 3994


IF l_parent_update_required = 'Y' THEN
FORALL k in 1..l_object_ids_tab.count
UPDATE PA_PROJ_ROLLUP_BULK_TEMP SET
start_date1  = decode(l_update_requ_flag_tab1(k), 'Y', decode(l_update_date_flag_tab1(k), 'Y', l_new_start_date1(k), start_date1),start_date1)
, finish_date1 = decode(l_update_requ_flag_tab1(k), 'Y', decode(l_update_date_flag_tab1(k), 'Y', l_new_completion_date1(k),finish_date1),finish_date1)
, duration1    = decode(l_update_requ_flag_tab1(k), 'Y', decode(l_update_date_flag_tab1(k), 'Y', l_new_duration1(k), duration1), duration1)
, start_date2  = decode(l_update_requ_flag_tab2(k), 'Y', decode(l_update_date_flag_tab2(k), 'Y', l_new_start_date2(k), start_date2), start_date2)
, finish_date2 = decode(l_update_requ_flag_tab2(k), 'Y', decode(l_update_date_flag_tab2(k), 'Y', l_new_completion_date2(k), finish_date2), finish_date2)
, duration2    = decode(l_update_requ_flag_tab2(k), 'Y', decode(l_update_date_flag_tab2(k), 'Y', l_new_duration2(k), duration2), duration2)
, start_date3  = decode(l_update_requ_flag_tab3(k), 'Y', decode(l_update_date_flag_tab3(k), 'Y', l_new_start_date3(k), start_date3), start_date3)
, finish_date3 = decode(l_update_requ_flag_tab3(k), 'Y', decode(l_update_date_flag_tab3(k), 'Y', l_new_completion_date3(k), finish_date3), finish_date3)
, duration3    = decode(l_update_requ_flag_tab3(k), 'Y', decode(l_update_date_flag_tab3(k), 'Y', l_new_duration3(k), duration3), duration3)
, start_date4  = decode(l_update_requ_flag_tab4(k), 'Y', decode(l_update_date_flag_tab4(k), 'Y', l_new_start_date4(k), start_date4), start_date4)
, finish_date4 = decode(l_update_requ_flag_tab4(k), 'Y', decode(l_update_date_flag_tab4(k), 'Y', l_new_completion_date4(k), finish_date4), finish_date4)
, duration4    = decode(l_update_requ_flag_tab4(k), 'Y', decode(l_update_date_flag_tab4(k), 'Y', l_new_duration4(k), duration4), duration4)
, start_date5  = decode(l_update_requ_flag_tab5(k), 'Y', decode(l_update_date_flag_tab5(k), 'Y', l_new_start_date5(k), start_date5), start_date5)
, finish_date5 = decode(l_update_requ_flag_tab5(k), 'Y', decode(l_update_date_flag_tab5(k), 'Y', l_new_completion_date5(k), finish_date5), finish_date5)
, duration5    = decode(l_update_requ_flag_tab5(k), 'Y', decode(l_update_date_flag_tab5(k), 'Y', l_new_duration5(k), duration5), duration5)
, start_date6  = decode(l_update_requ_flag_tab6(k), 'Y', decode(l_update_date_flag_tab6(k), 'Y', l_new_start_date6(k), start_date6), start_date6)
, finish_date6 = decode(l_update_requ_flag_tab6(k), 'Y', decode(l_update_date_flag_tab6(k), 'Y', l_new_completion_date6(k), finish_date6), finish_date6)
, duration6    = decode(l_update_requ_flag_tab6(k), 'Y', decode(l_update_date_flag_tab6(k), 'Y', l_new_duration6(k), duration6), duration6)
, dirty_flag1  = decode(l_update_requ_flag_tab1(k), 'Y', 'N', dirty_flag1)
, dirty_flag2  = decode(l_update_requ_flag_tab2(k), 'Y', 'N', dirty_flag2)
, dirty_flag3  = decode(l_update_requ_flag_tab3(k), 'Y', 'N', dirty_flag3)
, dirty_flag4  = decode(l_update_requ_flag_tab4(k), 'Y', 'N', dirty_flag4)
, dirty_flag5  = decode(l_update_requ_flag_tab5(k), 'Y', 'N', dirty_flag5)
, dirty_flag6  = decode(l_update_requ_flag_tab6(k), 'Y', 'N', dirty_flag6)
WHERE object_id = l_object_ids_tab(k)
AND object_type = l_object_types_tab(k)
and process_number = l_process_number;

Line: 4024


END IF; -- l_parent_update_required = 'Y'

Line: 4052


l_object_ids_tab.delete;

Line: 4053


l_object_types_tab.delete;

Line: 4054


l_sum_tab1.delete;

Line: 4055


l_sum_tab2.delete;

Line: 4056


l_sum_tab3.delete;

Line: 4057


l_sum_tab4.delete;

Line: 4058


l_sum_tab5.delete;

Line: 4059


l_sum_tab6.delete;

Line: 4060


l_update_required := 'N';

Line: 4089


SELECT MAX(decode(rollup_node1, 'Y', nvl(PROGRESS_OVERRIDE1, nvl(PROGRESS_STATUS_WEIGHT1, -99)), -99))
, MAX(decode(rollup_node2, 'Y', nvl(PROGRESS_OVERRIDE2, nvl(PROGRESS_STATUS_WEIGHT2, -99)), -99))
, MAX(decode(rollup_node3, 'Y', nvl(PROGRESS_OVERRIDE3, nvl(PROGRESS_STATUS_WEIGHT3, -99)), -99))
, MAX(decode(rollup_node4, 'Y', nvl(PROGRESS_OVERRIDE4, nvl(PROGRESS_STATUS_WEIGHT4, -99)), -99))
, MAX(decode(rollup_node5, 'Y', nvl(PROGRESS_OVERRIDE5, nvl(PROGRESS_STATUS_WEIGHT5, -99)), -99))
, MAX(decode(rollup_node6, 'Y', nvl(PROGRESS_OVERRIDE6, nvl(PROGRESS_STATUS_WEIGHT6, -99)), -99))
, count(*)
INTO   l_weight1, l_weight2, l_weight3, l_weight4, l_weight5, l_weight6, l_count
FROM   PA_PROJ_ROLLUP_BULK_TEMP
WHERE  PROCESS_NUMBER   = l_process_number
AND    Parent_Object_ID = l_object_ids_tab(i)
--AND    OBJECT_TYPE IN ('PA_TASKS', 'PA_STRUCTURES', 'PA_DELIVERABLES', 'PA_SUBPROJECTS')
-- 4366733 : Deliverable Progress Status should not rollup
AND    OBJECT_TYPE IN ('PA_TASKS', 'PA_STRUCTURES', 'PA_SUBPROJECTS')
;

Line: 4105


SELECT MAX(nvl(PROGRESS_OVERRIDE1, nvl(PROGRESS_STATUS_WEIGHT1, -99)))
, MAX(nvl(PROGRESS_OVERRIDE2, nvl(PROGRESS_STATUS_WEIGHT2, -99)))
, MAX(nvl(PROGRESS_OVERRIDE3, nvl(PROGRESS_STATUS_WEIGHT3, -99)))
, MAX(nvl(PROGRESS_OVERRIDE4, nvl(PROGRESS_STATUS_WEIGHT4, -99)))
, MAX(nvl(PROGRESS_OVERRIDE5, nvl(PROGRESS_STATUS_WEIGHT5, -99)))
, MAX(nvl(PROGRESS_OVERRIDE6, nvl(PROGRESS_STATUS_WEIGHT6, -99)))
, count(*)
INTO   l_weight1, l_weight2, l_weight3, l_weight4, l_weight5, l_weight6, l_count
FROM   PA_PROJ_ROLLUP_BULK_TEMP
WHERE  PROCESS_NUMBER   = l_process_number
AND    Parent_Object_ID = l_object_ids_tab(i)
--AND    OBJECT_TYPE IN ('PA_TASKS', 'PA_STRUCTURES', 'PA_DELIVERABLES','PA_SUBPROJECTS')
-- 4366733 : Deliverable Progress Status should not rollup
AND    OBJECT_TYPE IN ('PA_TASKS', 'PA_STRUCTURES', 'PA_SUBPROJECTS')
;

Line: 4160


l_update_required := 'Y';

Line: 4181


IF l_update_required = 'Y' THEN
/* Added the hint to force the unique index for bug#6185523 */
UPDATE  /*+ INDEX( T1 PA_PROJ_ROLLUP_BULK_TEMP_U1) */ PA_PROJ_ROLLUP_BULK_TEMP T1
SET    T1.PROGRESS_STATUS_WEIGHT1=l_sum_tab1(i)
, T1.PROGRESS_STATUS_WEIGHT2=l_sum_tab2(i)
, T1.PROGRESS_STATUS_WEIGHT3=l_sum_tab3(i)
, T1.PROGRESS_STATUS_WEIGHT4=l_sum_tab4(i)
, T1.PROGRESS_STATUS_WEIGHT5=l_sum_tab5(i)
, T1.PROGRESS_STATUS_WEIGHT6=l_sum_tab6(i)
WHERE T1.Process_Number = l_Process_Number
AND T1.object_id = l_object_ids_tab(i)
AND T1.object_type = l_object_types_tab(i)
;

Line: 4198


IF l_update_required = 'Y' THEN
FORALL i in 1..l_object_ids_tab.count
UPDATE PA_PROJ_ROLLUP_BULK_TEMP T1
SET    T1.PROGRESS_STATUS_WEIGHT1=l_sum_tab1(i)
, T1.PROGRESS_STATUS_WEIGHT2=l_sum_tab2(i)
, T1.PROGRESS_STATUS_WEIGHT3=l_sum_tab3(i)
, T1.PROGRESS_STATUS_WEIGHT4=l_sum_tab4(i)
, T1.PROGRESS_STATUS_WEIGHT5=l_sum_tab5(i)
, T1.PROGRESS_STATUS_WEIGHT6=l_sum_tab6(i)
WHERE T1.Process_Number = l_Process_Number
AND T1.object_id = l_object_ids_tab(i)
AND T1.object_type = l_object_types_tab(i)
;

Line: 4211


END IF; -- l_update_required = 'Y' THEN

Line: 4233


l_object_ids_tab.delete;

Line: 4234


l_object_types_tab.delete;

Line: 4235


l_sum_tab1.delete;

Line: 4236


l_sum_tab2.delete;

Line: 4237


l_sum_tab3.delete;

Line: 4238


l_sum_tab4.delete;

Line: 4239


l_sum_tab5.delete;

Line: 4240


l_sum_tab6.delete;

Line: 4241


l_update_required := 'N';

Line: 4250


l_update_required := 'N';

Line: 4252


l_task_status_tab1.delete;

Line: 4253


l_task_status_tab2.delete;

Line: 4254


l_task_status_tab3.delete;

Line: 4255


l_task_status_tab4.delete;

Line: 4256


l_task_status_tab5.delete;

Line: 4257


l_task_status_tab6.delete;

Line: 4296


l_update_required := 'Y';

Line: 4326


l_update_required := 'Y';

Line: 4355


l_update_required := 'Y';

Line: 4384


l_update_required := 'Y';

Line: 4413


l_update_required := 'Y';

Line: 4442


l_update_required := 'Y';

Line: 4451


IF l_update_required = 'Y' THEN
/* Added the hint to force the unique index for bug#6185523 */
UPDATE /*+ INDEX( T1 PA_PROJ_ROLLUP_BULK_TEMP_U1) */ PA_PROJ_ROLLUP_BULK_TEMP T1
SET    T1.TASK_STATUS1= l_sum_tab1(i)
, T1.TASK_STATUS2=l_sum_tab2(i)
, T1.TASK_STATUS3=l_sum_tab3(i)
, T1.TASK_STATUS4=l_sum_tab4(i)
, T1.TASK_STATUS5=l_sum_tab5(i)
, T1.TASK_STATUS6=l_sum_tab6(i)
WHERE T1.Process_Number = l_Process_Number
AND T1.object_id = l_object_ids_tab(i)
AND T1.object_type = l_object_types_tab(i);

Line: 4467


IF l_update_required = 'Y' THEN
FORALL i in 1..l_object_ids_tab.count
UPDATE PA_PROJ_ROLLUP_BULK_TEMP T1
SET    T1.TASK_STATUS1= l_sum_tab1(i)
, T1.TASK_STATUS2=l_sum_tab2(i)
, T1.TASK_STATUS3=l_sum_tab3(i)
, T1.TASK_STATUS4=l_sum_tab4(i)
, T1.TASK_STATUS5=l_sum_tab5(i)
, T1.TASK_STATUS6=l_sum_tab6(i)
WHERE T1.Process_Number = l_Process_Number
AND T1.object_id = l_object_ids_tab(i)
AND T1.object_type = l_object_types_tab(i)
;

Line: 4480


END IF; -- l_update_required = 'Y' THEN

Line: 4502


l_object_ids_tab.delete;

Line: 4503


l_object_types_tab.delete;

Line: 4504


l_perc_comp_deriv_code_tab.delete;

Line: 4505


l_bac_value_tab1.delete;

Line: 4506


l_bac_value_tab2.delete;

Line: 4507


l_bac_value_tab3.delete;

Line: 4508


l_bac_value_tab4.delete;

Line: 4509


l_bac_value_tab5.delete;

Line: 4510


l_bac_value_tab6.delete;

Line: 4511


l_percent_complete_tab1.delete;

Line: 4512


l_percent_complete_tab2.delete;

Line: 4513


l_percent_complete_tab3.delete;

Line: 4514


l_percent_complete_tab4.delete;

Line: 4515


l_percent_complete_tab5.delete;

Line: 4516


l_percent_complete_tab6.delete;

Line: 4517


l_percent_override_tab1.delete;

Line: 4518


l_percent_override_tab2.delete;

Line: 4519


l_percent_override_tab3.delete;

Line: 4520


l_percent_override_tab4.delete;

Line: 4521


l_percent_override_tab5.delete;

Line: 4522


l_percent_override_tab6.delete;

Line: 4523


l_earned_value_tab1.delete;

Line: 4524


l_earned_value_tab2.delete;

Line: 4525


l_earned_value_tab3.delete;

Line: 4526


l_earned_value_tab4.delete;

Line: 4527


l_earned_value_tab5.delete;

Line: 4528


l_earned_value_tab6.delete;

Line: 4529


l_update_required := 'N';

Line: 4561


SELECT sum(nvl(percent_override1, nvl(percent_complete1, 0))*nvl(task_weight1, 0))/100,
sum(nvl(task_weight1, 0)),
sum(nvl(percent_override2, nvl(percent_complete2, 0))*nvl(task_weight2, 0))/100,
sum(nvl(task_weight2, 0)),
sum(nvl(percent_override3, nvl(percent_complete3, 0))*nvl(task_weight3, 0))/100,
sum(nvl(task_weight3, 0)),
sum(nvl(percent_override4, nvl(percent_complete4, 0))*nvl(task_weight4, 0))/100,
sum(nvl(task_weight4, 0)),
sum(nvl(percent_override5, nvl(percent_complete5, 0))*nvl(task_weight5, 0))/100,
sum(nvl(task_weight5, 0)),
sum(nvl(percent_override6, nvl(percent_complete6, 0))*nvl(task_weight6, 0))/100,
sum(nvl(task_weight6, 0)),
count(*)
INTO   l_actual_duration1, l_pc_duration1
, l_actual_duration2, l_pc_duration2
, l_actual_duration3, l_pc_duration3
, l_actual_duration4, l_pc_duration4
, l_actual_duration5, l_pc_duration5
, l_actual_duration6, l_pc_duration6
, l_count
FROM   PA_PROJ_ROLLUP_BULK_TEMP
WHERE  Process_Number    = l_Process_Number
AND    OBJECT_TYPE = 'PA_DELIVERABLES'
AND    Parent_Object_ID  = l_object_ids_tab(i)
AND    parent_object_type IN ('PA_STRUCTURES','PA_TASKS') -- Bug 4450587
;

Line: 4593


select sum(nvl(earned_value1, 0)), sum(nvl(bac_value1, 0))
, sum(nvl(earned_value2, 0)), sum(nvl(bac_value2, 0))
, sum(nvl(earned_value3, 0)), sum(nvl(bac_value3, 0))
, sum(nvl(earned_value4, 0)), sum(nvl(bac_value4, 0))
, sum(nvl(earned_value5, 0)), sum(nvl(bac_value5, 0))
, sum(nvl(earned_value6, 0)), sum(nvl(bac_value6, 0))
,  count(*)
INTO   l_actual_duration1, l_pc_duration1
, l_actual_duration2, l_pc_duration2
, l_actual_duration3, l_pc_duration3
, l_actual_duration4, l_pc_duration4
, l_actual_duration5, l_pc_duration5
, l_actual_duration6, l_pc_duration6
, l_count
FROM   PA_PROJ_ROLLUP_BULK_TEMP
WHERE  Process_Number    = l_Process_Number
AND    OBJECT_TYPE IN ('PA_ASSIGNMENTS', 'PA_SUBPROJECTS')
AND    Parent_Object_ID  = l_object_ids_tab(i)
AND    parent_object_type IN ('PA_STRUCTURES','PA_TASKS') -- Bug 4450587
;

Line: 4623


l_update_required := 'Y';

Line: 4645


l_update_required := 'Y';

Line: 4664


l_update_required := 'Y';

Line: 4683


l_update_required := 'Y';

Line: 4702


l_update_required := 'Y';

Line: 4721


l_update_required := 'Y';

Line: 4741


l_update_required := 'Y';

Line: 4745


l_update_required := 'Y';

Line: 4749


l_update_required := 'Y';

Line: 4753


l_update_required := 'Y';

Line: 4757


l_update_required := 'Y';

Line: 4761


l_update_required := 'Y';

Line: 4767


IF l_update_required = 'Y' THEN
FORALL i in 1..l_object_ids_tab.count
/* Added the hint to force the unique index for bug#6185523 */
UPDATE  /*+ INDEX( T1 PA_PROJ_ROLLUP_BULK_TEMP_U1) */ PA_PROJ_ROLLUP_BULK_TEMP T1
SET    t1.percent_complete1=l_percent_complete_tab1(i)
, t1.percent_complete2=l_percent_complete_tab2(i)
, t1.percent_complete3=l_percent_complete_tab3(i)
, t1.percent_complete4=l_percent_complete_tab4(i)
, t1.percent_complete5=l_percent_complete_tab5(i)
, t1.percent_complete6=l_percent_complete_tab6(i)
, t1.earned_value1=l_earned_value_tab1(i)
, t1.earned_value2=l_earned_value_tab2(i)
, t1.earned_value3=l_earned_value_tab3(i)
, t1.earned_value4=l_earned_value_tab4(i)
, t1.earned_value5=l_earned_value_tab5(i)
, t1.earned_value6=l_earned_value_tab6(i)
WHERE T1.Process_Number = l_Process_Number
AND T1.object_id = l_object_ids_tab(i)
AND T1.object_type = l_object_types_tab(i)
;

Line: 4787


END IF; -- l_update_required = 'Y' THEN

Line: 4792


l_object_ids_tab.delete;

Line: 4793


l_object_types_tab.delete;

Line: 4794


l_perc_comp_deriv_code_tab.delete;

Line: 4795


l_bac_value_tab1.delete;

Line: 4796


l_bac_value_tab2.delete;

Line: 4797


l_bac_value_tab3.delete;

Line: 4798


l_bac_value_tab4.delete;

Line: 4799


l_bac_value_tab5.delete;

Line: 4800


l_bac_value_tab6.delete;

Line: 4801


l_percent_complete_tab1.delete;

Line: 4802


l_percent_complete_tab2.delete;

Line: 4803


l_percent_complete_tab3.delete;

Line: 4804


l_percent_complete_tab4.delete;

Line: 4805


l_percent_complete_tab5.delete;

Line: 4806


l_percent_complete_tab6.delete;

Line: 4807


l_percent_override_tab1.delete;

Line: 4808


l_percent_override_tab2.delete;

Line: 4809


l_percent_override_tab3.delete;

Line: 4810


l_percent_override_tab4.delete;

Line: 4811


l_percent_override_tab5.delete;

Line: 4812


l_percent_override_tab6.delete;

Line: 4813


l_earned_value_tab1.delete;

Line: 4814


l_earned_value_tab2.delete;

Line: 4815


l_earned_value_tab3.delete;

Line: 4816


l_earned_value_tab4.delete;

Line: 4817


l_earned_value_tab5.delete;

Line: 4818


l_earned_value_tab6.delete;

Line: 4819


l_summ_obj_flag_tab.delete; -- 4587517

Line: 4820


l_update_required := 'N';

Line: 4836


l_update_required := 'N';

Line: 4855


SELECT sum(nvl(percent_override1, nvl(percent_complete1, 0))*nvl(task_weight1, 0))/100,
sum(nvl(task_weight1, 0)),
sum(nvl(percent_override2, nvl(percent_complete2, 0))*nvl(task_weight2, 0))/100,
sum(nvl(task_weight2, 0)),
sum(nvl(percent_override3, nvl(percent_complete3, 0))*nvl(task_weight3, 0))/100,
sum(nvl(task_weight3, 0)),
sum(nvl(percent_override4, nvl(percent_complete4, 0))*nvl(task_weight4, 0))/100,
sum(nvl(task_weight4, 0)),
sum(nvl(percent_override5, nvl(percent_complete5, 0))*nvl(task_weight5, 0))/100,
sum(nvl(task_weight5, 0)),
sum(nvl(percent_override6, nvl(percent_complete6, 0))*nvl(task_weight6, 0))/100,
sum(nvl(task_weight6, 0)),
count(*)
INTO   l_actual_duration1, l_pc_duration1
, l_actual_duration2, l_pc_duration2
, l_actual_duration3, l_pc_duration3
, l_actual_duration4, l_pc_duration4
, l_actual_duration5, l_pc_duration5
, l_actual_duration6, l_pc_duration6
, l_count
FROM   PA_PROJ_ROLLUP_BULK_TEMP
WHERE  Process_Number    = l_Process_Number
AND    OBJECT_TYPE = 'PA_DELIVERABLES'
AND    Parent_Object_ID  = l_object_ids_tab(i)
AND    parent_object_type IN ('PA_STRUCTURES','PA_TASKS') -- Bug 4450587
;

Line: 4926


SELECT sum(nvl(earned_value1, 0)), sum(nvl(bac_value1, 0))
, sum(nvl(earned_value2, 0)), sum(nvl(bac_value2, 0))
, sum(nvl(earned_value3, 0)), sum(nvl(bac_value3, 0))
, sum(nvl(earned_value4, 0)), sum(nvl(bac_value4, 0))
, sum(nvl(earned_value5, 0)), sum(nvl(bac_value5, 0))
, sum(nvl(earned_value6, 0)), sum(nvl(bac_value6, 0))
,  count(*)
INTO   l_actual_duration1_a, l_duration1_a
, l_actual_duration2_a, l_duration2_a
, l_actual_duration3_a, l_duration3_a
, l_actual_duration4_a, l_duration4_a
, l_actual_duration5_a, l_duration5_a
, l_actual_duration6_a, l_duration6_a
, l_count
FROM   PA_PROJ_ROLLUP_BULK_TEMP
WHERE  Process_Number = l_Process_Number
AND    OBJECT_TYPE = 'PA_ASSIGNMENTS'
AND    Parent_Object_ID  = l_object_ids_tab(i)
AND    parent_object_type = 'PA_TASKS'
;

Line: 5017


SELECT sum(nvl(percent_override1, nvl(percent_complete1, 0))*nvl(bac_value1, 0)/100)
, sum(nvl(bac_value1, 0))
, sum(nvl(percent_override2, nvl(percent_complete2, 0))*nvl(bac_value2, 0)/100)
, sum(nvl(bac_value2, 0))
, sum(nvl(percent_override3, nvl(percent_complete3, 0))*nvl(bac_value3, 0)/100)
, sum(nvl(bac_value3, 0))
, sum(nvl(percent_override4, nvl(percent_complete4, 0))*nvl(bac_value4, 0)/100)
, sum(nvl(bac_value4, 0))
, sum(nvl(percent_override5, nvl(percent_complete5, 0))*nvl(bac_value5, 0)/100)
, sum(nvl(bac_value5, 0))
, sum(nvl(percent_override6, nvl(percent_complete6, 0))*nvl(bac_value6, 0)/100)
, sum(nvl(bac_value6, 0))
,  count(*)
INTO   l_actual_duration1_t, l_duration1_t
, l_actual_duration2_t, l_duration2_t
, l_actual_duration3_t, l_duration3_t
, l_actual_duration4_t, l_duration4_t
, l_actual_duration5_t, l_duration5_t
, l_actual_duration6_t, l_duration6_t
, l_count1
FROM   PA_PROJ_ROLLUP_BULK_TEMP
WHERE  Process_Number    = l_Process_Number
AND    OBJECT_TYPE = 'PA_SUBPROJECTS'
AND    Parent_Object_ID  = l_object_ids_tab(i)
AND    parent_object_type = 'PA_TASKS'
;

Line: 5101


SELECT sum(nvl(earned_value1, 0)), sum(nvl(bac_value1, 0))
, sum(nvl(earned_value2, 0)), sum(nvl(bac_value2, 0))
, sum(nvl(earned_value3, 0)), sum(nvl(bac_value3, 0))
, sum(nvl(earned_value4, 0)), sum(nvl(bac_value4, 0))
, sum(nvl(earned_value5, 0)), sum(nvl(bac_value5, 0))
, sum(nvl(earned_value6, 0)), sum(nvl(bac_value6, 0))
,  count(*)
INTO   l_actual_duration1_a, l_duration1_a
, l_actual_duration2_a, l_duration2_a
, l_actual_duration3_a, l_duration3_a
, l_actual_duration4_a, l_duration4_a
, l_actual_duration5_a, l_duration5_a
, l_actual_duration6_a, l_duration6_a
, l_count
FROM   PA_PROJ_ROLLUP_BULK_TEMP
WHERE  Process_Number = l_Process_Number
AND    OBJECT_TYPE = 'PA_ASSIGNMENTS'
AND    Parent_Object_ID  = l_object_ids_tab(i)
AND    parent_object_type IN ('PA_STRUCTURES','PA_TASKS') -- Bug 4450587
;

Line: 5192


SELECT sum(nvl(percent_override1, nvl(percent_complete1, 0))*nvl(bac_value1, 0)/100)
, sum(nvl(bac_value1, 0))
, sum(nvl(percent_override2, nvl(percent_complete2, 0))*nvl(bac_value2, 0)/100)
, sum(nvl(bac_value2, 0))
, sum(nvl(percent_override3, nvl(percent_complete3, 0))*nvl(bac_value3, 0)/100)
, sum(nvl(bac_value3, 0))
, sum(nvl(percent_override4, nvl(percent_complete4, 0))*nvl(bac_value4, 0)/100)
, sum(nvl(bac_value4, 0))
, sum(nvl(percent_override5, nvl(percent_complete5, 0))*nvl(bac_value5, 0)/100)
, sum(nvl(bac_value5, 0))
, sum(nvl(percent_override6, nvl(percent_complete6, 0))*nvl(bac_value6, 0)/100)
, sum(nvl(bac_value6, 0))
,  count(*) -- Bug 4343615
INTO   l_actual_duration1_t, l_duration1_t
, l_actual_duration2_t, l_duration2_t
, l_actual_duration3_t, l_duration3_t
, l_actual_duration4_t, l_duration4_t
, l_actual_duration5_t, l_duration5_t
, l_actual_duration6_t, l_duration6_t
, l_count1 -- Bug 4343615
FROM   PA_PROJ_ROLLUP_BULK_TEMP
WHERE  Process_Number    = l_Process_Number
--AND    OBJECT_TYPE = 'PA_TASKS' --4582956
AND    OBJECT_TYPE IN ('PA_TASKS','PA_SUBPROJECTS') --4582956 : Added PA_SUBPROJECTS
AND    Parent_Object_ID  = l_object_ids_tab(i)
AND    parent_object_type IN ('PA_STRUCTURES','PA_TASKS') -- Bug 4450587
;

Line: 5251


SELECT sum(nvl(percent_override1, nvl(percent_complete1, 0))*nvl(task_weight1, 0))/100
, sum(nvl(task_weight1, 0))
, sum(nvl(percent_override2, nvl(percent_complete2, 0))*nvl(task_weight2, 0))/100
, sum(nvl(task_weight2, 0))
, sum(nvl(percent_override3, nvl(percent_complete3, 0))*nvl(task_weight3, 0))/100
, sum(nvl(task_weight3, 0))
, sum(nvl(percent_override4, nvl(percent_complete4, 0))*nvl(task_weight4, 0))/100
, sum(nvl(task_weight4, 0))
, sum(nvl(percent_override5, nvl(percent_complete5, 0))*nvl(task_weight5, 0))/100
, sum(nvl(task_weight5, 0))
, sum(nvl(percent_override6, nvl(percent_complete6, 0))*nvl(task_weight6, 0))/100
, sum(nvl(task_weight6, 0))
,  count(*)
INTO   l_actual_duration1, l_pc_duration1
, l_actual_duration2, l_pc_duration2
, l_actual_duration3, l_pc_duration3
, l_actual_duration4, l_pc_duration4
, l_actual_duration5, l_pc_duration5
, l_actual_duration6, l_pc_duration6
, l_count
FROM   PA_PROJ_ROLLUP_BULK_TEMP
WHERE  Process_Number    = l_Process_Number
AND    OBJECT_TYPE = 'PA_TASKS'
AND    Parent_Object_ID  = l_object_ids_tab(i)
AND    parent_object_type IN ('PA_STRUCTURES','PA_TASKS') -- Bug 4450587
;

Line: 5289


l_update_required := 'Y';

Line: 5303


l_update_required := 'Y';

Line: 5317


l_update_required := 'Y';

Line: 5331


l_update_required := 'Y';

Line: 5345


l_update_required := 'Y';

Line: 5359


l_update_required := 'Y';

Line: 5374


l_update_required := 'Y';

Line: 5378


l_update_required := 'Y';

Line: 5382


l_update_required := 'Y';

Line: 5386


l_update_required := 'Y';

Line: 5390


l_update_required := 'Y';

Line: 5394


l_update_required := 'Y';

Line: 5399


IF l_update_required = 'Y' THEN
/* Added the hint to force the unique index for bug#6185523 */
UPDATE  /*+ INDEX( T1 PA_PROJ_ROLLUP_BULK_TEMP_U1) */ PA_PROJ_ROLLUP_BULK_TEMP T1
SET    T1.PERCENT_COMPLETE1=l_PERCENT_COMPLETE_tab1(i)
, T1.PERCENT_COMPLETE2=l_PERCENT_COMPLETE_tab2(i)
, T1.PERCENT_COMPLETE3=l_PERCENT_COMPLETE_tab3(i)
, T1.PERCENT_COMPLETE4=l_PERCENT_COMPLETE_tab4(i)
, T1.PERCENT_COMPLETE5=l_PERCENT_COMPLETE_tab5(i)
, T1.PERCENT_COMPLETE6=l_PERCENT_COMPLETE_tab6(i)
, T1.EARNED_VALUE1=l_EARNED_VALUE_tab1(i)
, T1.EARNED_VALUE2=l_EARNED_VALUE_tab2(i)
, T1.EARNED_VALUE3=l_EARNED_VALUE_tab3(i)
, T1.EARNED_VALUE4=l_EARNED_VALUE_tab4(i)
, T1.EARNED_VALUE5=l_EARNED_VALUE_tab5(i)
, T1.EARNED_VALUE6=l_EARNED_VALUE_tab6(i)
WHERE T1.Process_Number = l_Process_Number
AND T1.object_id = l_object_ids_tab(i)
AND T1.object_type = l_object_types_tab(i)
;

Line: 5422


IF l_update_required = 'Y' THEN
FORALL i in 1..l_object_ids_tab.count
UPDATE PA_PROJ_ROLLUP_BULK_TEMP T1
SET    T1.PERCENT_COMPLETE1=l_PERCENT_COMPLETE_tab1(i)
, T1.PERCENT_COMPLETE2=l_PERCENT_COMPLETE_tab2(i)
, T1.PERCENT_COMPLETE3=l_PERCENT_COMPLETE_tab3(i)
, T1.PERCENT_COMPLETE4=l_PERCENT_COMPLETE_tab4(i)
, T1.PERCENT_COMPLETE5=l_PERCENT_COMPLETE_tab5(i)
, T1.PERCENT_COMPLETE6=l_PERCENT_COMPLETE_tab6(i)
, T1.EARNED_VALUE1=l_EARNED_VALUE_tab1(i)
, T1.EARNED_VALUE2=l_EARNED_VALUE_tab2(i)
, T1.EARNED_VALUE3=l_EARNED_VALUE_tab3(i)
, T1.EARNED_VALUE4=l_EARNED_VALUE_tab4(i)
, T1.EARNED_VALUE5=l_EARNED_VALUE_tab5(i)
, T1.EARNED_VALUE6=l_EARNED_VALUE_tab6(i)
WHERE T1.Process_Number = l_Process_Number
AND T1.object_id = l_object_ids_tab(i)
AND T1.object_type = l_object_types_tab(i)
;

Line: 5441


END IF; -- l_update_required = 'Y' THEN

Line: 5467


l_object_ids_tab.delete;

Line: 5468


l_object_types_tab.delete;

Line: 5469


l_update_required := 'N';

Line: 5471


l_sum_tab1.delete;

Line: 5472


l_sum_tab2.delete;

Line: 5473


l_sum_tab3.delete;

Line: 5474


l_sum_tab4.delete;

Line: 5475


l_sum_tab5.delete;

Line: 5476


l_sum_tab6.delete;

Line: 5497


l_update_required := 'N';

Line: 5503


SELECT Sum(decode(rollup_node1, 'Y', NVL(ETC_Cost1,0),0)),
Sum(decode(rollup_node2, 'Y', NVL(ETC_Cost2,0),0)),
Sum(decode(rollup_node3, 'Y', NVL(ETC_Cost3,0),0)),
Sum(decode(rollup_node4, 'Y', NVL(ETC_Cost4,0),0)),
Sum(decode(rollup_node5, 'Y', NVL(ETC_Cost5,0),0)),
Sum(decode(rollup_node6, 'Y', NVL(ETC_Cost6,0),0)),
Sum(decode(rollup_node1, 'Y', NVL(PPL_ETC_COST1,0),0)),
Sum(decode(rollup_node2, 'Y', NVL(PPL_ETC_COST2,0),0)),
Sum(decode(rollup_node3, 'Y', NVL(PPL_ETC_COST3,0),0)),
Sum(decode(rollup_node4, 'Y', NVL(PPL_ETC_COST4,0),0)),
Sum(decode(rollup_node5, 'Y', NVL(PPL_ETC_COST5,0),0)),
Sum(decode(rollup_node6, 'Y', NVL(PPL_ETC_COST6,0),0)),
Sum(decode(rollup_node1, 'Y', NVL(EQPMT_ETC_COST1,0),0)),
Sum(decode(rollup_node2, 'Y', NVL(EQPMT_ETC_COST2,0),0)),
Sum(decode(rollup_node3, 'Y', NVL(EQPMT_ETC_COST3,0),0)),
Sum(decode(rollup_node4, 'Y', NVL(EQPMT_ETC_COST4,0),0)),
Sum(decode(rollup_node5, 'Y', NVL(EQPMT_ETC_COST5,0),0)),
Sum(decode(rollup_node6, 'Y', NVL(EQPMT_ETC_COST6,0),0)),
Sum(decode(rollup_node1, 'Y', NVL(PPL_UNPLAND_EFFORT1,0),0)),
Sum(decode(rollup_node2, 'Y', NVL(PPL_UNPLAND_EFFORT2,0),0)),
Sum(decode(rollup_node3, 'Y', NVL(PPL_UNPLAND_EFFORT3,0),0)),
Sum(decode(rollup_node4, 'Y', NVL(PPL_UNPLAND_EFFORT4,0),0)),
Sum(decode(rollup_node5, 'Y', NVL(PPL_UNPLAND_EFFORT5,0),0)),
Sum(decode(rollup_node6, 'Y', NVL(PPL_UNPLAND_EFFORT6,0),0)),
Sum(decode(rollup_node1, 'Y', NVL(EQPMT_ETC_EFFORT1,0),0)),
Sum(decode(rollup_node2, 'Y', NVL(EQPMT_ETC_EFFORT2,0),0)),
Sum(decode(rollup_node3, 'Y', NVL(EQPMT_ETC_EFFORT3,0),0)),
Sum(decode(rollup_node4, 'Y', NVL(EQPMT_ETC_EFFORT4,0),0)),
Sum(decode(rollup_node5, 'Y', NVL(EQPMT_ETC_EFFORT5,0),0)),
Sum(decode(rollup_node6, 'Y', NVL(EQPMT_ETC_EFFORT6,0),0)),
Sum(decode(rollup_node1, 'Y', NVL(SUB_PRJ_ETC_COST1,0),0)),
Sum(decode(rollup_node2, 'Y', NVL(SUB_PRJ_ETC_COST2,0),0)),
Sum(decode(rollup_node3, 'Y', NVL(SUB_PRJ_ETC_COST3,0),0)),
Sum(decode(rollup_node4, 'Y', NVL(SUB_PRJ_ETC_COST4,0),0)),
Sum(decode(rollup_node5, 'Y', NVL(SUB_PRJ_ETC_COST5,0),0)),
Sum(decode(rollup_node6, 'Y', NVL(SUB_PRJ_ETC_COST6,0),0)),
Sum(decode(rollup_node1, 'Y', NVL(SUB_PRJ_PPL_ETC_COST1,0),0)),
Sum(decode(rollup_node2, 'Y', NVL(SUB_PRJ_PPL_ETC_COST2,0),0)),
Sum(decode(rollup_node3, 'Y', NVL(SUB_PRJ_PPL_ETC_COST3,0),0)),
Sum(decode(rollup_node4, 'Y', NVL(SUB_PRJ_PPL_ETC_COST4,0),0)),
Sum(decode(rollup_node5, 'Y', NVL(SUB_PRJ_PPL_ETC_COST5,0),0)),
Sum(decode(rollup_node6, 'Y', NVL(SUB_PRJ_PPL_ETC_COST6,0),0)),
Sum(decode(rollup_node1, 'Y', NVL(SUB_PRJ_EQPMT_ETC_COST1,0),0)),
Sum(decode(rollup_node2, 'Y', NVL(SUB_PRJ_EQPMT_ETC_COST2,0),0)),
Sum(decode(rollup_node3, 'Y', NVL(SUB_PRJ_EQPMT_ETC_COST3,0),0)),
Sum(decode(rollup_node4, 'Y', NVL(SUB_PRJ_EQPMT_ETC_COST4,0),0)),
Sum(decode(rollup_node5, 'Y', NVL(SUB_PRJ_EQPMT_ETC_COST5,0),0)),
Sum(decode(rollup_node6, 'Y', NVL(SUB_PRJ_EQPMT_ETC_COST6,0),0)),
Sum(decode(rollup_node1, 'Y', NVL(SUB_PRJ_PPL_ETC_EFFORT1,0),0)),
Sum(decode(rollup_node2, 'Y', NVL(SUB_PRJ_PPL_ETC_EFFORT2,0),0)),
Sum(decode(rollup_node3, 'Y', NVL(SUB_PRJ_PPL_ETC_EFFORT3,0),0)),
Sum(decode(rollup_node4, 'Y', NVL(SUB_PRJ_PPL_ETC_EFFORT4,0),0)),
Sum(decode(rollup_node5, 'Y', NVL(SUB_PRJ_PPL_ETC_EFFORT5,0),0)),
Sum(decode(rollup_node6, 'Y', NVL(SUB_PRJ_PPL_ETC_EFFORT6,0),0)),
Sum(decode(rollup_node1, 'Y', NVL(SUB_PRJ_EQPMT_ETC_EFFORT1,0),0)),
Sum(decode(rollup_node2, 'Y', NVL(SUB_PRJ_EQPMT_ETC_EFFORT2,0),0)),
Sum(decode(rollup_node3, 'Y', NVL(SUB_PRJ_EQPMT_ETC_EFFORT3,0),0)),
Sum(decode(rollup_node4, 'Y', NVL(SUB_PRJ_EQPMT_ETC_EFFORT4,0),0)),
Sum(decode(rollup_node5, 'Y', NVL(SUB_PRJ_EQPMT_ETC_EFFORT5,0),0)),
Sum(decode(rollup_node6, 'Y', NVL(SUB_PRJ_EQPMT_ETC_EFFORT6,0),0)),
Sum(decode(rollup_node1, 'Y', NVL(REMAINING_EFFORT1,0),0)),
Sum(decode(rollup_node2, 'Y', NVL(REMAINING_EFFORT2,0),0)),
Sum(decode(rollup_node3, 'Y', NVL(REMAINING_EFFORT3,0),0)),
Sum(decode(rollup_node4, 'Y', NVL(REMAINING_EFFORT4,0),0)),
Sum(decode(rollup_node5, 'Y', NVL(REMAINING_EFFORT5,0),0)),
Sum(decode(rollup_node6, 'Y', NVL(REMAINING_EFFORT6,0),0)),
Count(*)
INTO   l_ETC_Cost_tab1(i),
l_ETC_Cost_tab2(i),
l_ETC_Cost_tab3(i),
l_ETC_Cost_tab4(i),
l_ETC_Cost_tab5(i),
l_ETC_Cost_tab6(i),
l_PPL_ETC_COST_tab1(i),
l_PPL_ETC_COST_tab2(i),
l_PPL_ETC_COST_tab3(i),
l_PPL_ETC_COST_tab4(i),
l_PPL_ETC_COST_tab5(i),
l_PPL_ETC_COST_tab6(i),
l_EQPMT_ETC_COST_tab1(i),
l_EQPMT_ETC_COST_tab2(i),
l_EQPMT_ETC_COST_tab3(i),
l_EQPMT_ETC_COST_tab4(i),
l_EQPMT_ETC_COST_tab5(i),
l_EQPMT_ETC_COST_tab6(i),
l_PPL_UNPLAND_EFFORT_tab1(i),
l_PPL_UNPLAND_EFFORT_tab2(i),
l_PPL_UNPLAND_EFFORT_tab3(i),
l_PPL_UNPLAND_EFFORT_tab4(i),
l_PPL_UNPLAND_EFFORT_tab5(i),
l_PPL_UNPLAND_EFFORT_tab6(i),
l_EQPMT_ETC_EFFORT_tab1(i),
l_EQPMT_ETC_EFFORT_tab2(i),
l_EQPMT_ETC_EFFORT_tab3(i),
l_EQPMT_ETC_EFFORT_tab4(i),
l_EQPMT_ETC_EFFORT_tab5(i),
l_EQPMT_ETC_EFFORT_tab6(i),
l_SUB_PRJ_ETC_COST_tab1(i),
l_SUB_PRJ_ETC_COST_tab2(i),
l_SUB_PRJ_ETC_COST_tab3(i),
l_SUB_PRJ_ETC_COST_tab4(i),
l_SUB_PRJ_ETC_COST_tab5(i),
l_SUB_PRJ_ETC_COST_tab6(i),
l_SUB_PRJ_PPL_ETC_COST_tab1(i),
l_SUB_PRJ_PPL_ETC_COST_tab2(i),
l_SUB_PRJ_PPL_ETC_COST_tab3(i),
l_SUB_PRJ_PPL_ETC_COST_tab4(i),
l_SUB_PRJ_PPL_ETC_COST_tab5(i),
l_SUB_PRJ_PPL_ETC_COST_tab6(i),
l_SUB_PRJ_EQPMT_ETC_COST_tab1(i),
l_SUB_PRJ_EQPMT_ETC_COST_tab2(i),
l_SUB_PRJ_EQPMT_ETC_COST_tab3(i),
l_SUB_PRJ_EQPMT_ETC_COST_tab4(i),
l_SUB_PRJ_EQPMT_ETC_COST_tab5(i),
l_SUB_PRJ_EQPMT_ETC_COST_tab6(i),
l_SUB_PRJ_PPL_ETC_EFFORT_tab1(i),
l_SUB_PRJ_PPL_ETC_EFFORT_tab2(i),
l_SUB_PRJ_PPL_ETC_EFFORT_tab3(i),
l_SUB_PRJ_PPL_ETC_EFFORT_tab4(i),
l_SUB_PRJ_PPL_ETC_EFFORT_tab5(i),
l_SUB_PRJ_PPL_ETC_EFFORT_tab6(i),
L_SP_EQPMT_ETC_EFFORT_TAB1(i),
L_SP_EQPMT_ETC_EFFORT_TAB2(i),
L_SP_EQPMT_ETC_EFFORT_TAB3(i),
L_SP_EQPMT_ETC_EFFORT_TAB4(i),
L_SP_EQPMT_ETC_EFFORT_TAB5(i),
L_SP_EQPMT_ETC_EFFORT_TAB6(i),
l_sum_tab1(i),
l_sum_tab2(i),
l_sum_tab3(i),
l_sum_tab4(i),
l_sum_tab5(i),
l_sum_tab6(i),
l_Count
FROM   PA_PROJ_ROLLUP_BULK_TEMP
WHERE  Process_Number    = l_Process_Number
AND    OBJECT_TYPE <> 'PA_DELIVERABLES'
AND    Parent_Object_ID  =l_object_ids_tab(i)
AND    parent_object_type IN ('PA_STRUCTURES','PA_TASKS') -- Bug 4450587
;

Line: 5644


SELECT Sum(NVL(ETC_Cost1,0)),
Sum(NVL(ETC_Cost2,0)),
Sum(NVL(ETC_Cost3,0)),
Sum(NVL(ETC_Cost4,0)),
Sum(NVL(ETC_Cost5,0)),
Sum(NVL(ETC_Cost6,0)),
Sum(NVL(PPL_ETC_COST1,0)),
Sum(NVL(PPL_ETC_COST2,0)),
Sum(NVL(PPL_ETC_COST3,0)),
Sum(NVL(PPL_ETC_COST4,0)),
Sum(NVL(PPL_ETC_COST5,0)),
Sum(NVL(PPL_ETC_COST6,0)),
Sum(NVL(EQPMT_ETC_COST1,0)),
Sum(NVL(EQPMT_ETC_COST2,0)),
Sum(NVL(EQPMT_ETC_COST3,0)),
Sum(NVL(EQPMT_ETC_COST4,0)),
Sum(NVL(EQPMT_ETC_COST5,0)),
Sum(NVL(EQPMT_ETC_COST6,0)),
Sum(NVL(PPL_UNPLAND_EFFORT1,0)),
Sum(NVL(PPL_UNPLAND_EFFORT2,0)),
Sum(NVL(PPL_UNPLAND_EFFORT3,0)),
Sum(NVL(PPL_UNPLAND_EFFORT4,0)),
Sum(NVL(PPL_UNPLAND_EFFORT5,0)),
Sum(NVL(PPL_UNPLAND_EFFORT6,0)),
Sum(NVL(EQPMT_ETC_EFFORT1,0)),
Sum(NVL(EQPMT_ETC_EFFORT2,0)),
Sum(NVL(EQPMT_ETC_EFFORT3,0)),
Sum(NVL(EQPMT_ETC_EFFORT4,0)),
Sum(NVL(EQPMT_ETC_EFFORT5,0)),
Sum(NVL(EQPMT_ETC_EFFORT6,0)),
Sum(NVL(SUB_PRJ_ETC_COST1,0)),
Sum(NVL(SUB_PRJ_ETC_COST2,0)),
Sum(NVL(SUB_PRJ_ETC_COST3,0)),
Sum(NVL(SUB_PRJ_ETC_COST4,0)),
Sum(NVL(SUB_PRJ_ETC_COST5,0)),
Sum(NVL(SUB_PRJ_ETC_COST6,0)),
Sum(NVL(SUB_PRJ_PPL_ETC_COST1,0)),
Sum(NVL(SUB_PRJ_PPL_ETC_COST2,0)),
Sum(NVL(SUB_PRJ_PPL_ETC_COST3,0)),
Sum(NVL(SUB_PRJ_PPL_ETC_COST4,0)),
Sum(NVL(SUB_PRJ_PPL_ETC_COST5,0)),
Sum(NVL(SUB_PRJ_PPL_ETC_COST6,0)),
Sum(NVL(SUB_PRJ_EQPMT_ETC_COST1,0)),
Sum(NVL(SUB_PRJ_EQPMT_ETC_COST2,0)),
Sum(NVL(SUB_PRJ_EQPMT_ETC_COST3,0)),
Sum(NVL(SUB_PRJ_EQPMT_ETC_COST4,0)),
Sum(NVL(SUB_PRJ_EQPMT_ETC_COST5,0)),
Sum(NVL(SUB_PRJ_EQPMT_ETC_COST6,0)),
Sum(NVL(SUB_PRJ_PPL_ETC_EFFORT1,0)),
Sum(NVL(SUB_PRJ_PPL_ETC_EFFORT2,0)),
Sum(NVL(SUB_PRJ_PPL_ETC_EFFORT3,0)),
Sum(NVL(SUB_PRJ_PPL_ETC_EFFORT4,0)),
Sum(NVL(SUB_PRJ_PPL_ETC_EFFORT5,0)),
Sum(NVL(SUB_PRJ_PPL_ETC_EFFORT6,0)),
Sum(NVL(SUB_PRJ_EQPMT_ETC_EFFORT1,0)),
Sum(NVL(SUB_PRJ_EQPMT_ETC_EFFORT2,0)),
Sum(NVL(SUB_PRJ_EQPMT_ETC_EFFORT3,0)),
Sum(NVL(SUB_PRJ_EQPMT_ETC_EFFORT4,0)),
Sum(NVL(SUB_PRJ_EQPMT_ETC_EFFORT5,0)),
Sum(NVL(SUB_PRJ_EQPMT_ETC_EFFORT6,0)),
Sum(NVL(REMAINING_EFFORT1,0)),
Sum(NVL(REMAINING_EFFORT2,0)),
Sum(NVL(REMAINING_EFFORT3,0)),
Sum(NVL(REMAINING_EFFORT4,0)),
Sum(NVL(REMAINING_EFFORT5,0)),
Sum(NVL(REMAINING_EFFORT6,0)),
Count(*)
INTO   l_ETC_Cost_tab1(i),
l_ETC_Cost_tab2(i),
l_ETC_Cost_tab3(i),
l_ETC_Cost_tab4(i),
l_ETC_Cost_tab5(i),
l_ETC_Cost_tab6(i),
l_PPL_ETC_COST_tab1(i),
l_PPL_ETC_COST_tab2(i),
l_PPL_ETC_COST_tab3(i),
l_PPL_ETC_COST_tab4(i),
l_PPL_ETC_COST_tab5(i),
l_PPL_ETC_COST_tab6(i),
l_EQPMT_ETC_COST_tab1(i),
l_EQPMT_ETC_COST_tab2(i),
l_EQPMT_ETC_COST_tab3(i),
l_EQPMT_ETC_COST_tab4(i),
l_EQPMT_ETC_COST_tab5(i),
l_EQPMT_ETC_COST_tab6(i),
l_PPL_UNPLAND_EFFORT_tab1(i),
l_PPL_UNPLAND_EFFORT_tab2(i),
l_PPL_UNPLAND_EFFORT_tab3(i),
l_PPL_UNPLAND_EFFORT_tab4(i),
l_PPL_UNPLAND_EFFORT_tab5(i),
l_PPL_UNPLAND_EFFORT_tab6(i),
l_EQPMT_ETC_EFFORT_tab1(i),
l_EQPMT_ETC_EFFORT_tab2(i),
l_EQPMT_ETC_EFFORT_tab3(i),
l_EQPMT_ETC_EFFORT_tab4(i),
l_EQPMT_ETC_EFFORT_tab5(i),
l_EQPMT_ETC_EFFORT_tab6(i),
l_SUB_PRJ_ETC_COST_tab1(i),
l_SUB_PRJ_ETC_COST_tab2(i),
l_SUB_PRJ_ETC_COST_tab3(i),
l_SUB_PRJ_ETC_COST_tab4(i),
l_SUB_PRJ_ETC_COST_tab5(i),
l_SUB_PRJ_ETC_COST_tab6(i),
l_SUB_PRJ_PPL_ETC_COST_tab1(i),
l_SUB_PRJ_PPL_ETC_COST_tab2(i),
l_SUB_PRJ_PPL_ETC_COST_tab3(i),
l_SUB_PRJ_PPL_ETC_COST_tab4(i),
l_SUB_PRJ_PPL_ETC_COST_tab5(i),
l_SUB_PRJ_PPL_ETC_COST_tab6(i),
l_SUB_PRJ_EQPMT_ETC_COST_tab1(i),
l_SUB_PRJ_EQPMT_ETC_COST_tab2(i),
l_SUB_PRJ_EQPMT_ETC_COST_tab3(i),
l_SUB_PRJ_EQPMT_ETC_COST_tab4(i),
l_SUB_PRJ_EQPMT_ETC_COST_tab5(i),
l_SUB_PRJ_EQPMT_ETC_COST_tab6(i),
l_SUB_PRJ_PPL_ETC_EFFORT_tab1(i),
l_SUB_PRJ_PPL_ETC_EFFORT_tab2(i),
l_SUB_PRJ_PPL_ETC_EFFORT_tab3(i),
l_SUB_PRJ_PPL_ETC_EFFORT_tab4(i),
l_SUB_PRJ_PPL_ETC_EFFORT_tab5(i),
l_SUB_PRJ_PPL_ETC_EFFORT_tab6(i),
L_SP_EQPMT_ETC_EFFORT_TAB1(i),
L_SP_EQPMT_ETC_EFFORT_TAB2(i),
L_SP_EQPMT_ETC_EFFORT_TAB3(i),
L_SP_EQPMT_ETC_EFFORT_TAB4(i),
L_SP_EQPMT_ETC_EFFORT_TAB5(i),
L_SP_EQPMT_ETC_EFFORT_TAB6(i),
l_sum_tab1(i),
l_sum_tab2(i),
l_sum_tab3(i),
l_sum_tab4(i),
l_sum_tab5(i),
l_sum_tab6(i),
l_Count
FROM   PA_PROJ_ROLLUP_BULK_TEMP
WHERE  Process_Number    = l_Process_Number
AND    OBJECT_TYPE <> 'PA_DELIVERABLES'
AND    Parent_Object_ID  =l_object_ids_tab(i)
AND    parent_object_type IN ('PA_STRUCTURES','PA_TASKS') -- Bug 4450587
;

Line: 5790


l_update_required := 'Y';

Line: 5792


UPDATE  /*+ INDEX( T1 PA_PROJ_ROLLUP_BULK_TEMP_U1) */ PA_PROJ_ROLLUP_BULK_TEMP T1
SET    T1.ETC_Cost1=l_ETC_Cost_tab1(i)
, T1.ETC_Cost2=l_ETC_Cost_tab2(i)
, T1.ETC_Cost3=l_ETC_Cost_tab3(i)
, T1.ETC_Cost4=l_ETC_Cost_tab4(i)
, T1.ETC_Cost5=l_ETC_Cost_tab5(i)
, T1.ETC_Cost6=l_ETC_Cost_tab6(i)
, T1.PPL_ETC_COST1=l_PPL_ETC_COST_tab1(i)
, T1.PPL_ETC_COST2=l_PPL_ETC_COST_tab2(i)
, T1.PPL_ETC_COST3=l_PPL_ETC_COST_tab3(i)
, T1.PPL_ETC_COST4=l_PPL_ETC_COST_tab4(i)
, T1.PPL_ETC_COST5=l_PPL_ETC_COST_tab5(i)
, T1.PPL_ETC_COST6=l_PPL_ETC_COST_tab6(i)
, T1.EQPMT_ETC_COST1=l_EQPMT_ETC_COST_tab1(i)
, T1.EQPMT_ETC_COST2=l_EQPMT_ETC_COST_tab2(i)
, T1.EQPMT_ETC_COST3=l_EQPMT_ETC_COST_tab3(i)
, T1.EQPMT_ETC_COST4=l_EQPMT_ETC_COST_tab4(i)
, T1.EQPMT_ETC_COST5=l_EQPMT_ETC_COST_tab5(i)
, T1.EQPMT_ETC_COST6=l_EQPMT_ETC_COST_tab6(i)
, T1.PPL_UNPLAND_EFFORT1=l_PPL_UNPLAND_EFFORT_tab1(i)
, T1.PPL_UNPLAND_EFFORT2=l_PPL_UNPLAND_EFFORT_tab2(i)
, T1.PPL_UNPLAND_EFFORT3=l_PPL_UNPLAND_EFFORT_tab3(i)
, T1.PPL_UNPLAND_EFFORT4=l_PPL_UNPLAND_EFFORT_tab4(i)
, T1.PPL_UNPLAND_EFFORT5=l_PPL_UNPLAND_EFFORT_tab5(i)
, T1.PPL_UNPLAND_EFFORT6=l_PPL_UNPLAND_EFFORT_tab6(i)
, T1.EQPMT_ETC_EFFORT1=l_EQPMT_ETC_EFFORT_tab1(i)
, T1.EQPMT_ETC_EFFORT2=l_EQPMT_ETC_EFFORT_tab2(i)
, T1.EQPMT_ETC_EFFORT3=l_EQPMT_ETC_EFFORT_tab3(i)
, T1.EQPMT_ETC_EFFORT4=l_EQPMT_ETC_EFFORT_tab4(i)
, T1.EQPMT_ETC_EFFORT5=l_EQPMT_ETC_EFFORT_tab5(i)
, T1.EQPMT_ETC_EFFORT6=l_EQPMT_ETC_EFFORT_tab6(i)
, T1.SUB_PRJ_ETC_COST1=l_SUB_PRJ_ETC_COST_tab1(i)
, T1.SUB_PRJ_ETC_COST2=l_SUB_PRJ_ETC_COST_tab2(i)
, T1.SUB_PRJ_ETC_COST3=l_SUB_PRJ_ETC_COST_tab3(i)
, T1.SUB_PRJ_ETC_COST4=l_SUB_PRJ_ETC_COST_tab4(i)
, T1.SUB_PRJ_ETC_COST5=l_SUB_PRJ_ETC_COST_tab5(i)
, T1.SUB_PRJ_ETC_COST6=l_SUB_PRJ_ETC_COST_tab6(i)
, T1.SUB_PRJ_PPL_ETC_COST1=l_SUB_PRJ_PPL_ETC_COST_tab1(i)
, T1.SUB_PRJ_PPL_ETC_COST2=l_SUB_PRJ_PPL_ETC_COST_tab2(i)
, T1.SUB_PRJ_PPL_ETC_COST3=l_SUB_PRJ_PPL_ETC_COST_tab3(i)
, T1.SUB_PRJ_PPL_ETC_COST4=l_SUB_PRJ_PPL_ETC_COST_tab4(i)
, T1.SUB_PRJ_PPL_ETC_COST5=l_SUB_PRJ_PPL_ETC_COST_tab5(i)
, T1.SUB_PRJ_PPL_ETC_COST6=l_SUB_PRJ_PPL_ETC_COST_tab6(i)
, T1.SUB_PRJ_EQPMT_ETC_COST1=l_SUB_PRJ_EQPMT_ETC_COST_tab1(i)
, T1.SUB_PRJ_EQPMT_ETC_COST2=l_SUB_PRJ_EQPMT_ETC_COST_tab2(i)
, T1.SUB_PRJ_EQPMT_ETC_COST3=l_SUB_PRJ_EQPMT_ETC_COST_tab3(i)
, T1.SUB_PRJ_EQPMT_ETC_COST4=l_SUB_PRJ_EQPMT_ETC_COST_tab4(i)
, T1.SUB_PRJ_EQPMT_ETC_COST5=l_SUB_PRJ_EQPMT_ETC_COST_tab5(i)
, T1.SUB_PRJ_EQPMT_ETC_COST6=l_SUB_PRJ_EQPMT_ETC_COST_tab6(i)
, T1.SUB_PRJ_PPL_ETC_EFFORT1=l_SUB_PRJ_PPL_ETC_EFFORT_tab1(i)
, T1.SUB_PRJ_PPL_ETC_EFFORT2=l_SUB_PRJ_PPL_ETC_EFFORT_tab2(i)
, T1.SUB_PRJ_PPL_ETC_EFFORT3=l_SUB_PRJ_PPL_ETC_EFFORT_tab3(i)
, T1.SUB_PRJ_PPL_ETC_EFFORT4=l_SUB_PRJ_PPL_ETC_EFFORT_tab4(i)
, T1.SUB_PRJ_PPL_ETC_EFFORT5=l_SUB_PRJ_PPL_ETC_EFFORT_tab5(i)
, T1.SUB_PRJ_PPL_ETC_EFFORT6=l_SUB_PRJ_PPL_ETC_EFFORT_tab6(i)
, T1.SUB_PRJ_EQPMT_ETC_EFFORT1=L_SP_EQPMT_ETC_EFFORT_TAB1(i)
, T1.SUB_PRJ_EQPMT_ETC_EFFORT2=L_SP_EQPMT_ETC_EFFORT_TAB2(i)
, T1.SUB_PRJ_EQPMT_ETC_EFFORT3=L_SP_EQPMT_ETC_EFFORT_TAB3(i)
, T1.SUB_PRJ_EQPMT_ETC_EFFORT4=L_SP_EQPMT_ETC_EFFORT_TAB4(i)
, T1.SUB_PRJ_EQPMT_ETC_EFFORT5=L_SP_EQPMT_ETC_EFFORT_TAB5(i)
, T1.SUB_PRJ_EQPMT_ETC_EFFORT6=L_SP_EQPMT_ETC_EFFORT_TAB6(i)
, T1.REMAINING_EFFORT1 = l_sum_tab1(i)
, T1.REMAINING_EFFORT2 = l_sum_tab2(i)
, T1.REMAINING_EFFORT3 = l_sum_tab3(i)
, T1.REMAINING_EFFORT4 = l_sum_tab4(i)
, T1.REMAINING_EFFORT5 = l_sum_tab5(i)
, T1.REMAINING_EFFORT6 = l_sum_tab6(i)
WHERE T1.Process_Number = l_Process_Number
AND T1.object_id = l_object_ids_tab(i)
AND T1.object_type = l_object_types_tab(i)
;

Line: 5867


IF l_update_required = 'Y' THEN
FORALL i in 1..l_object_ids_tab.count
UPDATE PA_PROJ_ROLLUP_BULK_TEMP T1
SET    T1.ETC_Cost1=l_ETC_Cost_tab1(i)
, T1.ETC_Cost2=l_ETC_Cost_tab2(i)
, T1.ETC_Cost3=l_ETC_Cost_tab3(i)
, T1.ETC_Cost4=l_ETC_Cost_tab4(i)
, T1.ETC_Cost5=l_ETC_Cost_tab5(i)
, T1.ETC_Cost6=l_ETC_Cost_tab6(i)
, T1.PPL_ETC_COST1=l_PPL_ETC_COST_tab1(i)
, T1.PPL_ETC_COST2=l_PPL_ETC_COST_tab2(i)
, T1.PPL_ETC_COST3=l_PPL_ETC_COST_tab3(i)
, T1.PPL_ETC_COST4=l_PPL_ETC_COST_tab4(i)
, T1.PPL_ETC_COST5=l_PPL_ETC_COST_tab5(i)
, T1.PPL_ETC_COST6=l_PPL_ETC_COST_tab6(i)
, T1.EQPMT_ETC_COST1=l_EQPMT_ETC_COST_tab1(i)
, T1.EQPMT_ETC_COST2=l_EQPMT_ETC_COST_tab2(i)
, T1.EQPMT_ETC_COST3=l_EQPMT_ETC_COST_tab3(i)
, T1.EQPMT_ETC_COST4=l_EQPMT_ETC_COST_tab4(i)
, T1.EQPMT_ETC_COST5=l_EQPMT_ETC_COST_tab5(i)
, T1.EQPMT_ETC_COST6=l_EQPMT_ETC_COST_tab6(i)
, T1.PPL_UNPLAND_EFFORT1=l_PPL_UNPLAND_EFFORT_tab1(i)
, T1.PPL_UNPLAND_EFFORT2=l_PPL_UNPLAND_EFFORT_tab2(i)
, T1.PPL_UNPLAND_EFFORT3=l_PPL_UNPLAND_EFFORT_tab3(i)
, T1.PPL_UNPLAND_EFFORT4=l_PPL_UNPLAND_EFFORT_tab4(i)
, T1.PPL_UNPLAND_EFFORT5=l_PPL_UNPLAND_EFFORT_tab5(i)
, T1.PPL_UNPLAND_EFFORT6=l_PPL_UNPLAND_EFFORT_tab6(i)
, T1.EQPMT_ETC_EFFORT1=l_EQPMT_ETC_EFFORT_tab1(i)
, T1.EQPMT_ETC_EFFORT2=l_EQPMT_ETC_EFFORT_tab2(i)
, T1.EQPMT_ETC_EFFORT3=l_EQPMT_ETC_EFFORT_tab3(i)
, T1.EQPMT_ETC_EFFORT4=l_EQPMT_ETC_EFFORT_tab4(i)
, T1.EQPMT_ETC_EFFORT5=l_EQPMT_ETC_EFFORT_tab5(i)
, T1.EQPMT_ETC_EFFORT6=l_EQPMT_ETC_EFFORT_tab6(i)
, T1.SUB_PRJ_ETC_COST1=l_SUB_PRJ_ETC_COST_tab1(i)
, T1.SUB_PRJ_ETC_COST2=l_SUB_PRJ_ETC_COST_tab2(i)
, T1.SUB_PRJ_ETC_COST3=l_SUB_PRJ_ETC_COST_tab3(i)
, T1.SUB_PRJ_ETC_COST4=l_SUB_PRJ_ETC_COST_tab4(i)
, T1.SUB_PRJ_ETC_COST5=l_SUB_PRJ_ETC_COST_tab5(i)
, T1.SUB_PRJ_ETC_COST6=l_SUB_PRJ_ETC_COST_tab6(i)
, T1.SUB_PRJ_PPL_ETC_COST1=l_SUB_PRJ_PPL_ETC_COST_tab1(i)
, T1.SUB_PRJ_PPL_ETC_COST2=l_SUB_PRJ_PPL_ETC_COST_tab2(i)
, T1.SUB_PRJ_PPL_ETC_COST3=l_SUB_PRJ_PPL_ETC_COST_tab3(i)
, T1.SUB_PRJ_PPL_ETC_COST4=l_SUB_PRJ_PPL_ETC_COST_tab4(i)
, T1.SUB_PRJ_PPL_ETC_COST5=l_SUB_PRJ_PPL_ETC_COST_tab5(i)
, T1.SUB_PRJ_PPL_ETC_COST6=l_SUB_PRJ_PPL_ETC_COST_tab6(i)
, T1.SUB_PRJ_EQPMT_ETC_COST1=l_SUB_PRJ_EQPMT_ETC_COST_tab1(i)
, T1.SUB_PRJ_EQPMT_ETC_COST2=l_SUB_PRJ_EQPMT_ETC_COST_tab2(i)
, T1.SUB_PRJ_EQPMT_ETC_COST3=l_SUB_PRJ_EQPMT_ETC_COST_tab3(i)
, T1.SUB_PRJ_EQPMT_ETC_COST4=l_SUB_PRJ_EQPMT_ETC_COST_tab4(i)
, T1.SUB_PRJ_EQPMT_ETC_COST5=l_SUB_PRJ_EQPMT_ETC_COST_tab5(i)
, T1.SUB_PRJ_EQPMT_ETC_COST6=l_SUB_PRJ_EQPMT_ETC_COST_tab6(i)
, T1.SUB_PRJ_PPL_ETC_EFFORT1=l_SUB_PRJ_PPL_ETC_EFFORT_tab1(i)
, T1.SUB_PRJ_PPL_ETC_EFFORT2=l_SUB_PRJ_PPL_ETC_EFFORT_tab2(i)
, T1.SUB_PRJ_PPL_ETC_EFFORT3=l_SUB_PRJ_PPL_ETC_EFFORT_tab3(i)
, T1.SUB_PRJ_PPL_ETC_EFFORT4=l_SUB_PRJ_PPL_ETC_EFFORT_tab4(i)
, T1.SUB_PRJ_PPL_ETC_EFFORT5=l_SUB_PRJ_PPL_ETC_EFFORT_tab5(i)
, T1.SUB_PRJ_PPL_ETC_EFFORT6=l_SUB_PRJ_PPL_ETC_EFFORT_tab6(i)
, T1.SUB_PRJ_EQPMT_ETC_EFFORT1=L_SP_EQPMT_ETC_EFFORT_TAB1(i)
, T1.SUB_PRJ_EQPMT_ETC_EFFORT2=L_SP_EQPMT_ETC_EFFORT_TAB2(i)
, T1.SUB_PRJ_EQPMT_ETC_EFFORT3=L_SP_EQPMT_ETC_EFFORT_TAB3(i)
, T1.SUB_PRJ_EQPMT_ETC_EFFORT4=L_SP_EQPMT_ETC_EFFORT_TAB4(i)
, T1.SUB_PRJ_EQPMT_ETC_EFFORT5=L_SP_EQPMT_ETC_EFFORT_TAB5(i)
, T1.SUB_PRJ_EQPMT_ETC_EFFORT6=L_SP_EQPMT_ETC_EFFORT_TAB6(i)
WHERE T1.Process_Number = l_Process_Number
AND T1.object_id = l_object_ids_tab(i)
AND T1.object_type = l_object_types_tab(i)
;

Line: 5934


END IF; -- l_update_required = 'Y' THEN

Line: 5978


delete /*+ index(pa_proj_rollup_bulk_temp PA_PROJ_ROLLUP_BULK_TEMP_N3) */ -- added hint for bug 13109678
from PA_PROJ_ROLLUP_BULK_TEMP where process_number = l_process_number;

Line: 6399


p_data_structure.delete;