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 dependencies on PA_PROJ_ROLLUP_BULK_TEMP

Line 851: FROM PA_PROJ_ROLLUP_BULK_TEMP

847: PERC_COMP_DERIVATIVE_CODE4,
848: PERC_COMP_DERIVATIVE_CODE5,
849: PERC_COMP_DERIVATIVE_CODE6,
850: SUMMARY_OBJECT_FLAG -- 4370746
851: FROM PA_PROJ_ROLLUP_BULK_TEMP
852: WHERE PROCESS_NUMBER = C_Process_Number
853: order by Object_Type, Object_ID;
854:
855: -- Bug 4218507 : Added Processed_Data_Structure_rollup

Line 1029: FROM PA_PROJ_ROLLUP_BULK_TEMP

1025: PERC_COMP_DERIVATIVE_CODE4,
1026: PERC_COMP_DERIVATIVE_CODE5,
1027: PERC_COMP_DERIVATIVE_CODE6,
1028: SUMMARY_OBJECT_FLAG -- 4370746
1029: FROM PA_PROJ_ROLLUP_BULK_TEMP
1030: WHERE PROCESS_NUMBER = C_Process_Number
1031: order by calendar_id;
1032:
1033: CURSOR lowest_dirty_object_list_dates IS

Line 1039: FROM PA_PROJ_ROLLUP_BULK_TEMP t1

1035: start_date4, start_date5, start_date6, finish_date1,finish_date2, finish_date3,
1036: finish_date4, finish_date5, finish_date6, duration1, duration2, duration3, duration4,
1037: duration5, duration6, dirty_flag1, dirty_flag2, dirty_flag3, dirty_flag4, dirty_flag5, dirty_flag6
1038: , 'N', 'N', 'N', 'N', 'N', 'N'
1039: FROM PA_PROJ_ROLLUP_BULK_TEMP t1
1040: WHERE PROCESS_NUMBER = l_process_number
1041: -- 4218507 : This could be made dependenct on dirty_flag1='Y' only. Not sure whethere this will improve performance
1042: AND (dirty_flag1='Y' OR dirty_flag2='Y' OR dirty_flag3='Y' OR dirty_flag4='Y' OR dirty_flag5='Y'
1043: OR dirty_flag6='Y')

Line 1044: AND Not Exists (select * from PA_PROJ_ROLLUP_BULK_TEMP t2

1040: WHERE PROCESS_NUMBER = l_process_number
1041: -- 4218507 : This could be made dependenct on dirty_flag1='Y' only. Not sure whethere this will improve performance
1042: AND (dirty_flag1='Y' OR dirty_flag2='Y' OR dirty_flag3='Y' OR dirty_flag4='Y' OR dirty_flag5='Y'
1043: OR dirty_flag6='Y')
1044: AND Not Exists (select * from PA_PROJ_ROLLUP_BULK_TEMP t2
1045: where t2.PROCESS_NUMBER = l_process_number
1046: and t2.parent_object_id = t1.object_id
1047: AND ROWNUM < 2);
1048:

Line 1056: FROM PA_PROJ_ROLLUP_BULK_TEMP

1052: finish_date4, finish_date5, finish_date6, duration1, duration2, duration3, duration4,
1053: duration5, duration6, dirty_flag1, dirty_flag2, dirty_flag3, dirty_flag4, dirty_flag5, dirty_flag6,
1054: start_date_override1, start_date_override2, start_date_override3, start_date_override4,
1055: start_date_override5, start_date_override6
1056: FROM PA_PROJ_ROLLUP_BULK_TEMP
1057: WHERE PROCESS_NUMBER = l_process_number
1058: -- 4218507 : This could be made dependent on dirty_flag1=Y only
1059: AND (dirty_flag1='Y' OR dirty_flag2='Y' OR dirty_flag3='Y' OR dirty_flag4='Y' OR dirty_flag5='Y' OR
1060: dirty_flag6='Y')

Line 1070: FROM PA_PROJ_ROLLUP_BULK_TEMP t1

1066:
1067: CURSOR Parent_Objects_List_Effort IS
1068: SELECT object_id, object_type,REMAINING_EFFORT1,REMAINING_EFFORT2, REMAINING_EFFORT3, REMAINING_EFFORT4
1069: , REMAINING_EFFORT5, REMAINING_EFFORT6
1070: FROM PA_PROJ_ROLLUP_BULK_TEMP t1
1071: WHERE process_number = l_process_number
1072: AND OBJECT_TYPE <> 'PA_DELIVERABLES'
1073: AND Exists (SELECT * from PA_PROJ_ROLLUP_BULK_TEMP t2
1074: WHERE t2.OBJECT_TYPE <> 'PA_DELIVERABLES'

Line 1073: AND Exists (SELECT * from PA_PROJ_ROLLUP_BULK_TEMP t2

1069: , REMAINING_EFFORT5, REMAINING_EFFORT6
1070: FROM PA_PROJ_ROLLUP_BULK_TEMP t1
1071: WHERE process_number = l_process_number
1072: AND OBJECT_TYPE <> 'PA_DELIVERABLES'
1073: AND Exists (SELECT * from PA_PROJ_ROLLUP_BULK_TEMP t2
1074: WHERE t2.OBJECT_TYPE <> 'PA_DELIVERABLES'
1075: AND t2.parent_object_id = t1.object_id
1076: AND t2.parent_object_type IN ('PA_STRUCTURES','PA_TASKS') -- Bug 4450587
1077: AND process_number = l_process_number

Line 1085: FROM PA_PROJ_ROLLUP_BULK_TEMP t1

1081: -- 4366733 : Deliverable Progress Status should not rollup
1082: CURSOR Parent_Objects_List_prog_sts IS
1083: SELECT Object_ID, object_type, PROGRESS_STATUS_WEIGHT1, PROGRESS_STATUS_WEIGHT2, PROGRESS_STATUS_WEIGHT3
1084: , PROGRESS_STATUS_WEIGHT4, PROGRESS_STATUS_WEIGHT5, PROGRESS_STATUS_WEIGHT6
1085: FROM PA_PROJ_ROLLUP_BULK_TEMP t1
1086: --WHERE OBJECT_TYPE IN ('PA_TASKS', 'PA_STRUCTURES', 'PA_DELIVERABLES')
1087: WHERE OBJECT_TYPE IN ('PA_TASKS', 'PA_STRUCTURES')
1088: AND process_number = l_process_number
1089: AND Exists (Select * From PA_PROJ_ROLLUP_BULK_TEMP t2

Line 1089: AND Exists (Select * From PA_PROJ_ROLLUP_BULK_TEMP t2

1085: FROM PA_PROJ_ROLLUP_BULK_TEMP t1
1086: --WHERE OBJECT_TYPE IN ('PA_TASKS', 'PA_STRUCTURES', 'PA_DELIVERABLES')
1087: WHERE OBJECT_TYPE IN ('PA_TASKS', 'PA_STRUCTURES')
1088: AND process_number = l_process_number
1089: AND Exists (Select * From PA_PROJ_ROLLUP_BULK_TEMP t2
1090: -- Where t2.OBJECT_TYPE IN ('PA_TASKS', 'PA_STRUCTURES', 'PA_DELIVERABLES', 'PA_SUBPROJECTS')
1091: Where t2.OBJECT_TYPE IN ('PA_TASKS', 'PA_STRUCTURES', 'PA_SUBPROJECTS')
1092: AND t2.parent_object_id = t1.object_id
1093: AND t2.parent_object_type IN ('PA_STRUCTURES','PA_TASKS') -- Bug 4450587

Line 1101: FROM PA_PROJ_ROLLUP_BULK_TEMP t1

1097:
1098:
1099: CURSOR parent_objects_list_task_sts IS
1100: SELECT object_id, object_type, task_status1, task_status2, task_status3, task_status4, task_status5, task_status6
1101: FROM PA_PROJ_ROLLUP_BULK_TEMP t1
1102: WHERE PROCESS_NUMBER = l_process_number
1103: AND OBJECT_TYPE <> 'PA_ASSIGNMENTS'
1104: AND Exists (Select * From PA_PROJ_ROLLUP_BULK_TEMP t2
1105: Where t2.PROCESS_NUMBER = l_process_number

Line 1104: AND Exists (Select * From PA_PROJ_ROLLUP_BULK_TEMP t2

1100: SELECT object_id, object_type, task_status1, task_status2, task_status3, task_status4, task_status5, task_status6
1101: FROM PA_PROJ_ROLLUP_BULK_TEMP t1
1102: WHERE PROCESS_NUMBER = l_process_number
1103: AND OBJECT_TYPE <> 'PA_ASSIGNMENTS'
1104: AND Exists (Select * From PA_PROJ_ROLLUP_BULK_TEMP t2
1105: Where t2.PROCESS_NUMBER = l_process_number
1106: AND OBJECT_TYPE <> 'PA_ASSIGNMENTS'
1107: AND t2.parent_object_id = t1.object_id
1108: AND t2.parent_object_type IN ('PA_STRUCTURES','PA_TASKS') -- Bug 4450587

Line 1119: FROM PA_PROJ_ROLLUP_BULK_TEMP

1115: , decode(rollup_node3, 'Y', TASK_STATUS3, -1)
1116: , decode(rollup_node4, 'Y', TASK_STATUS4, -1)
1117: , decode(rollup_node5, 'Y', TASK_STATUS5, -1)
1118: , decode(rollup_node6, 'Y', TASK_STATUS6, -1)
1119: FROM PA_PROJ_ROLLUP_BULK_TEMP
1120: WHERE PROCESS_NUMBER = l_process_number
1121: AND OBJECT_TYPE <> 'PA_ASSIGNMENTS'
1122: AND parent_object_id = p_parent_id
1123: AND parent_object_type IN ('PA_STRUCTURES','PA_TASKS') -- Bug 4450587

Line 1128: FROM PA_PROJ_ROLLUP_BULK_TEMP

1124: ;
1125:
1126: CURSOR Child_Task_Status_full(p_parent_id NUMBER) IS
1127: SELECT TASK_STATUS1, TASK_STATUS2, TASK_STATUS3, TASK_STATUS4, TASK_STATUS5, TASK_STATUS6
1128: FROM PA_PROJ_ROLLUP_BULK_TEMP
1129: WHERE PROCESS_NUMBER = l_process_number
1130: AND OBJECT_TYPE <> 'PA_ASSIGNMENTS'
1131: AND parent_object_id = p_parent_id
1132: AND parent_object_type IN ('PA_STRUCTURES','PA_TASKS') -- Bug 4450587

Line 1142: FROM PA_PROJ_ROLLUP_BULK_TEMP t1

1138: BAC_VALUE5, BAC_VALUE6, PERCENT_COMPLETE1, PERCENT_COMPLETE2, PERCENT_COMPLETE3,
1139: PERCENT_COMPLETE4, PERCENT_COMPLETE5, PERCENT_COMPLETE6, PERCENT_OVERRIDE1, PERCENT_OVERRIDE2,
1140: PERCENT_OVERRIDE3, PERCENT_OVERRIDE4, PERCENT_OVERRIDE5, PERCENT_OVERRIDE6, EARNED_VALUE1, EARNED_VALUE2
1141: , EARNED_VALUE3, EARNED_VALUE4, EARNED_VALUE5, EARNED_VALUE6
1142: FROM PA_PROJ_ROLLUP_BULK_TEMP t1
1143: WHERE PROCESS_NUMBER = l_process_number
1144: AND OBJECT_TYPE IN ('PA_TASKS', 'PA_STRUCTURES')
1145: AND nvl(SUMMARY_OBJECT_FLAG, 'N') NOT IN ('Y', 'L') -- 4370746 -- 4586449 : Added 'L'
1146: AND not Exists (Select * From PA_PROJ_ROLLUP_BULK_TEMP t2

Line 1146: AND not Exists (Select * From PA_PROJ_ROLLUP_BULK_TEMP t2

1142: FROM PA_PROJ_ROLLUP_BULK_TEMP t1
1143: WHERE PROCESS_NUMBER = l_process_number
1144: AND OBJECT_TYPE IN ('PA_TASKS', 'PA_STRUCTURES')
1145: AND nvl(SUMMARY_OBJECT_FLAG, 'N') NOT IN ('Y', 'L') -- 4370746 -- 4586449 : Added 'L'
1146: AND not Exists (Select * From PA_PROJ_ROLLUP_BULK_TEMP t2
1147: Where t2.PROCESS_NUMBER = l_process_number
1148: AND t2.OBJECT_TYPE IN ('PA_TASKS', 'PA_STRUCTURES')
1149: And t2.parent_object_id = t1.object_id
1150: AND t2.parent_object_type IN ('PA_STRUCTURES','PA_TASKS') -- Bug 4450587

Line 1160: FROM PA_PROJ_ROLLUP_BULK_TEMP t1

1156: PERCENT_COMPLETE4, PERCENT_COMPLETE5, PERCENT_COMPLETE6, PERCENT_OVERRIDE1, PERCENT_OVERRIDE2,
1157: PERCENT_OVERRIDE3, PERCENT_OVERRIDE4, PERCENT_OVERRIDE5, PERCENT_OVERRIDE6, EARNED_VALUE1, EARNED_VALUE2
1158: , EARNED_VALUE3, EARNED_VALUE4, EARNED_VALUE5, EARNED_VALUE6
1159: , summary_object_flag -- 4587517
1160: FROM PA_PROJ_ROLLUP_BULK_TEMP t1
1161: WHERE PROCESS_NUMBER = l_process_number
1162: AND OBJECT_TYPE IN ('PA_TASKS', 'PA_STRUCTURES')
1163: -- 4530036 : SUMMARY_OBJECT_FLAG is added so that
1164: -- earned value gets recalculated even if no childs are passed to summary level

Line 1166: OR Exists (Select * From PA_PROJ_ROLLUP_BULK_TEMP t2

1162: AND OBJECT_TYPE IN ('PA_TASKS', 'PA_STRUCTURES')
1163: -- 4530036 : SUMMARY_OBJECT_FLAG is added so that
1164: -- earned value gets recalculated even if no childs are passed to summary level
1165: AND( nvl(SUMMARY_OBJECT_FLAG, 'N') IN ('Y','L') -- 4586449 : Added 'L'
1166: OR Exists (Select * From PA_PROJ_ROLLUP_BULK_TEMP t2
1167: Where t2.PROCESS_NUMBER = l_process_number
1168: AND t2.OBJECT_TYPE IN ('PA_TASKS', 'PA_STRUCTURES')
1169: And t2.parent_object_id = t1.object_id
1170: AND t2.parent_object_type IN ('PA_STRUCTURES','PA_TASKS') -- Bug 4450587

Line 1187: FROM PA_PROJ_ROLLUP_BULK_TEMP t1

1183: , 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
1184: , 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
1185: , 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
1186: , REMAINING_EFFORT1, REMAINING_EFFORT2, REMAINING_EFFORT3, REMAINING_EFFORT4, REMAINING_EFFORT5, REMAINING_EFFORT6
1187: FROM PA_PROJ_ROLLUP_BULK_TEMP t1
1188: WHERE PROCESS_NUMBER = l_process_number
1189: AND OBJECT_TYPE NOT IN ( 'PA_DELIVERABLES', 'PA_ASSIGNMENTS', 'PA_SUBPROJECTS')
1190: AND Exists (SELECT * from PA_PROJ_ROLLUP_BULK_TEMP t2
1191: WHERE t2.PROCESS_NUMBER = l_process_number

Line 1190: AND Exists (SELECT * from PA_PROJ_ROLLUP_BULK_TEMP t2

1186: , REMAINING_EFFORT1, REMAINING_EFFORT2, REMAINING_EFFORT3, REMAINING_EFFORT4, REMAINING_EFFORT5, REMAINING_EFFORT6
1187: FROM PA_PROJ_ROLLUP_BULK_TEMP t1
1188: WHERE PROCESS_NUMBER = l_process_number
1189: AND OBJECT_TYPE NOT IN ( 'PA_DELIVERABLES', 'PA_ASSIGNMENTS', 'PA_SUBPROJECTS')
1190: AND Exists (SELECT * from PA_PROJ_ROLLUP_BULK_TEMP t2
1191: WHERE t2.PROCESS_NUMBER = l_process_number
1192: AND t2.OBJECT_TYPE <> 'PA_DELIVERABLES'
1193: AND t2.parent_object_id = t1.object_id
1194: AND t2.parent_object_type IN ('PA_STRUCTURES','PA_TASKS') -- Bug 4450587

Line 1200: FROM PA_PROJ_ROLLUP_BULK_TEMP t1

1196: Order By WBS_LEVEL DESC;
1197:
1198: CURSOR all_dirty_object_list_summary IS
1199: SELECT object_id, object_type, dirty_flag1, dirty_flag2, dirty_flag3, dirty_flag4, dirty_flag5, dirty_flag6
1200: FROM PA_PROJ_ROLLUP_BULK_TEMP t1
1201: WHERE PROCESS_NUMBER = l_process_number
1202: AND OBJECT_TYPE <> 'PA_DELIVERABLES'
1203: AND (Dirty_flag1 ='Y' OR Dirty_flag2 ='Y' OR Dirty_flag3 ='Y' OR Dirty_flag4 ='Y' OR Dirty_flag5 ='Y'
1204: OR Dirty_flag6 ='Y')

Line 1205: AND Exists (select 1 from PA_PROJ_ROLLUP_BULK_TEMP t2

1201: WHERE PROCESS_NUMBER = l_process_number
1202: AND OBJECT_TYPE <> 'PA_DELIVERABLES'
1203: AND (Dirty_flag1 ='Y' OR Dirty_flag2 ='Y' OR Dirty_flag3 ='Y' OR Dirty_flag4 ='Y' OR Dirty_flag5 ='Y'
1204: OR Dirty_flag6 ='Y')
1205: AND Exists (select 1 from PA_PROJ_ROLLUP_BULK_TEMP t2
1206: where t2.PROCESS_NUMBER = l_process_number
1207: and t2.OBJECT_TYPE <> 'PA_DELIVERABLES'
1208: and t2.parent_object_id = t1.object_id
1209: AND ROWNUM < 2

Line 1222: FROM PA_PROJ_ROLLUP_BULK_TEMP T2

1218: , c_dirty_flag5 ref_dirty_flag5, c_dirty_flag6 ref_dirty_flag6
1219: FROM
1220: (SELECT t2.Object_ID, t2.object_type, t2.dirty_flag1, t2.dirty_flag2, t2.dirty_flag3
1221: , t2.dirty_flag4, t2.dirty_flag5, t2.dirty_flag6,t2.wbs_level order_by_clause
1222: FROM PA_PROJ_ROLLUP_BULK_TEMP T2
1223: WHERE T2.PROCESS_NUMBER = l_process_number
1224: AND T2.Object_ID <> c_object_id
1225: START WITH T2.PROCESS_NUMBER = l_process_number
1226: AND T2.Object_ID = c_object_id

Line 1233: FROM PA_PROJ_ROLLUP_BULK_TEMP t1

1229: order by order_by_clause desc;
1230:
1231: CURSOR all_dirty_object_list_lowest IS
1232: SELECT object_id, object_type, dirty_flag1, dirty_flag2, dirty_flag3, dirty_flag4, dirty_flag5, dirty_flag6
1233: FROM PA_PROJ_ROLLUP_BULK_TEMP t1
1234: WHERE PROCESS_NUMBER = l_process_number
1235: AND OBJECT_TYPE <> 'PA_DELIVERABLES'
1236: AND (Dirty_flag1 ='Y' OR Dirty_flag2 ='Y' OR Dirty_flag3 ='Y' OR Dirty_flag4 ='Y' OR Dirty_flag5 ='Y'
1237: OR Dirty_flag6 ='Y')

Line 1238: AND NOT Exists (select 1 from PA_PROJ_ROLLUP_BULK_TEMP t2

1234: WHERE PROCESS_NUMBER = l_process_number
1235: AND OBJECT_TYPE <> 'PA_DELIVERABLES'
1236: AND (Dirty_flag1 ='Y' OR Dirty_flag2 ='Y' OR Dirty_flag3 ='Y' OR Dirty_flag4 ='Y' OR Dirty_flag5 ='Y'
1237: OR Dirty_flag6 ='Y')
1238: AND NOT Exists (select 1 from PA_PROJ_ROLLUP_BULK_TEMP t2
1239: where t2.PROCESS_NUMBER = l_process_number
1240: and t2.OBJECT_TYPE <> 'PA_DELIVERABLES'
1241: and t2.parent_object_id = t1.object_id
1242: AND ROWNUM < 2

Line 1255: FROM PA_PROJ_ROLLUP_BULK_TEMP T2

1251: , c_dirty_flag5 ref_dirty_flag5, c_dirty_flag6 ref_dirty_flag6
1252: FROM
1253: ( SELECT t2.Object_ID, t2.object_type, t2.dirty_flag1, t2.dirty_flag2, t2.dirty_flag3
1254: , t2.dirty_flag4, t2.dirty_flag5, t2.dirty_flag6, t2.wbs_level order_by_clause
1255: FROM PA_PROJ_ROLLUP_BULK_TEMP T2
1256: WHERE T2.PROCESS_NUMBER = l_process_number
1257: AND T2.Object_ID <> c_object_id
1258: START WITH T2.PROCESS_NUMBER = l_process_number
1259: AND T2.Object_ID = c_object_id

Line 1272: FROM PA_PROJ_ROLLUP_BULK_TEMP

1268: finish_date4, finish_date5, finish_date6, duration1, duration2, duration3, duration4,
1269: duration5, duration6, dirty_flag1, dirty_flag2, dirty_flag3, dirty_flag4, dirty_flag5, dirty_flag6,
1270: start_date_override1, start_date_override2, start_date_override3, start_date_override4,
1271: start_date_override5, start_date_override6, 'N', 'N', 'N', 'N', 'N', 'N' , 'N', 'N', 'N', 'N', 'N', 'N'
1272: FROM PA_PROJ_ROLLUP_BULK_TEMP
1273: WHERE PROCESS_NUMBER = l_process_number
1274: AND (dirty_flag1='Y' OR dirty_flag2='Y' OR dirty_flag3='Y' OR dirty_flag4='Y' OR dirty_flag5='Y' OR
1275: dirty_flag6='Y')
1276: order by wbs_level desc;

Line 1294: SELECT PA_PROJ_ROLLUP_BULK_TEMP_S.nextval

1290:
1291: SAVEPOINT GENERATE_SCHEDULE_SP;
1292:
1293: -- Derive the next Process Number
1294: SELECT PA_PROJ_ROLLUP_BULK_TEMP_S.nextval
1295: INTO l_Process_Number FROM dual;
1296:
1297: x_Process_Number := l_Process_Number;
1298:

Line 1686: INSERT INTO PA_PROJ_ROLLUP_BULK_TEMP(

1682: pa_debug.write(x_Module=>'PA_SCHEDULE_OBJECTS_PVT.GENERATE_SCHEDULE', x_Msg => 'After building the table', x_Log_Level=> 3);
1683: END IF;
1684:
1685: FORALL i IN 1..P_Data_Structure.COUNT
1686: INSERT INTO PA_PROJ_ROLLUP_BULK_TEMP(
1687: PROCESS_NUMBER,
1688: OBJECT_TYPE,
1689: OBJECT_ID,
1690: PARENT_OBJECT_TYPE,

Line 2178: UPDATE /+ INDEX( T1 PA_PROJ_ROLLUP_BULK_TEMP_U1) / PA_PROJ_ROLLUP_BULK_TEMP T1

2174:
2175:
2176: FORALL i in 1..l_object_ids_tab.count
2177: /* Added the hint to force the unique index for bug#6185523 */
2178: UPDATE /*+ INDEX( T1 PA_PROJ_ROLLUP_BULK_TEMP_U1) */ PA_PROJ_ROLLUP_BULK_TEMP T1
2179: SET T1.DIRTY_FLAG1=l_dirty_flag_tab1(i)
2180: , T1.DIRTY_FLAG2=l_dirty_flag_tab2(i)
2181: , T1.DIRTY_FLAG3=l_dirty_flag_tab3(i)
2182: , T1.DIRTY_FLAG4=l_dirty_flag_tab4(i)

Line 2315: UPDATE /+ INDEX( T1 PA_PROJ_ROLLUP_BULK_TEMP_U1) / PA_PROJ_ROLLUP_BULK_TEMP T1

2311: END LOOP; -- FOR i IN 1..l_temp_object_ids_tab.count LOOP
2312:
2313: FORALL i in 1..l_object_ids_tab.count
2314: /* Added the hint to force the unique index for bug#6185523 */
2315: UPDATE /*+ INDEX( T1 PA_PROJ_ROLLUP_BULK_TEMP_U1) */ PA_PROJ_ROLLUP_BULK_TEMP T1
2316: SET T1.DIRTY_FLAG1=l_dirty_flag_tab1(i)
2317: , T1.DIRTY_FLAG2=l_dirty_flag_tab2(i)
2318: , T1.DIRTY_FLAG3=l_dirty_flag_tab3(i)
2319: , T1.DIRTY_FLAG4=l_dirty_flag_tab4(i)

Line 2527: FROM PA_PROJ_ROLLUP_BULK_TEMP

2523: , l_new_completion_date6
2524: , l_null_flag6
2525: , l_task_count6
2526: , l_task_flag
2527: FROM PA_PROJ_ROLLUP_BULK_TEMP
2528: WHERE PROCESS_NUMBER = l_process_number
2529: AND parent_object_id = l_parent_object_ids_tab(j)
2530: AND parent_object_type IN ('PA_STRUCTURES','PA_TASKS') -- Bug 4450587
2531: ;

Line 2585: FROM PA_PROJ_ROLLUP_BULK_TEMP

2581: , l_new_completion_date6
2582: , l_null_flag6
2583: , l_task_count6
2584: , l_task_flag
2585: FROM PA_PROJ_ROLLUP_BULK_TEMP
2586: WHERE PROCESS_NUMBER = l_process_number
2587: AND parent_object_id = l_parent_object_ids_tab(j)
2588: AND parent_object_type IN ('PA_STRUCTURES','PA_TASKS') -- Bug 4450587
2589: ;

Line 3066: UPDATE + INDEX( SchTmp PA_PROJ_ROLLUP_BULK_TEMP_U1) PA_PROJ_ROLLUP_BULK_TEMP SchTmp SET

3062: /* Ends Added the following logic for bug#6185523 */
3063:
3064: IF l_parent_update_required = 'Y' THEN
3065: /* Commented the following update statement and introduced a new one for bug#6185523
3066: UPDATE + INDEX( SchTmp PA_PROJ_ROLLUP_BULK_TEMP_U1) PA_PROJ_ROLLUP_BULK_TEMP SchTmp SET
3067: 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)
3068: , 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)
3069: , duration1 = decode(l_update_requ_flag_tab1(j), 'Y', decode(l_update_date_flag_tab1(j), 'Y', l_parent_duration_tab1(j), duration1), duration1)
3070: , 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)

Line 3096: UPDATE /+ INDEX( SchTmp PA_PROJ_ROLLUP_BULK_TEMP_U1) / PA_PROJ_ROLLUP_BULK_TEMP SchTmp SET

3092: AND object_type = l_parent_object_types_tab(j)
3093: and process_number = l_process_number;
3094: Ends commented code for bug#6185523 And added the below update*/
3095:
3096: UPDATE /*+ INDEX( SchTmp PA_PROJ_ROLLUP_BULK_TEMP_U1) */ PA_PROJ_ROLLUP_BULK_TEMP SchTmp SET
3097: start_date1 = nvl(l_parent_start_date1_tmp, start_date1)
3098: , finish_date1 = nvl(l_parent_finish_date1_tmp, finish_date1)
3099: , duration1 = nvl(l_parent_duration1_tmp, duration1)
3100: , start_date2 = nvl(l_parent_start_date2_tmp, start_date2)

Line 3401: UPDATE PA_PROJ_ROLLUP_BULK_TEMP T1

3397: END LOOP; -- FOR i IN 1..l_child_object_ids_tab.count LOOP
3398:
3399: IF l_child_update_required = 'Y' THEN
3400: FORALL i in 1..l_child_object_ids_tab.count
3401: UPDATE PA_PROJ_ROLLUP_BULK_TEMP T1
3402: SET T1.start_date1=decode(l_child_upd_req_flag_tab1(i), 'Y', l_child_start_date_tab1(i), T1.start_date1)
3403: , T1.start_date2=decode(l_child_upd_req_flag_tab2(i), 'Y', l_child_start_date_tab2(i), T1.start_date2)
3404: , T1.start_date3=decode(l_child_upd_req_flag_tab3(i), 'Y', l_child_start_date_tab3(i), T1.start_date3)
3405: , T1.start_date4=decode(l_child_upd_req_flag_tab4(i), 'Y', l_child_start_date_tab4(i), T1.start_date4)

Line 3527: FROM PA_PROJ_ROLLUP_BULK_TEMP

3523: , MAX(decode(p_partial_dates_flag4, 'Y',decode(rollup_node4, 'Y', decode(dirty_flag4,'Y',1,0), 0),decode(dirty_flag4,'Y',1,0)))
3524: , MAX(decode(p_partial_dates_flag5, 'Y',decode(rollup_node5, 'Y', decode(dirty_flag5,'Y',1,0), 0),decode(dirty_flag5,'Y',1,0)))
3525: , MAX(decode(p_partial_dates_flag6, 'Y',decode(rollup_node6, 'Y', decode(dirty_flag6,'Y',1,0), 0),decode(dirty_flag6,'Y',1,0)))
3526: INTO l_count1, l_count2, l_count3, l_count4, l_count5, l_count6
3527: FROM PA_PROJ_ROLLUP_BULK_TEMP
3528: WHERE PROCESS_NUMBER = l_process_number
3529: AND parent_object_id = l_parent_object_ids_tab(j)
3530: AND (DIRTY_FLAG1 = 'Y' OR DIRTY_FLAG2 = 'Y' OR DIRTY_FLAG3 = 'Y'
3531: OR DIRTY_FLAG4 = 'Y' OR DIRTY_FLAG5 = 'Y' OR DIRTY_FLAG6 = 'Y')

Line 3694: FROM PA_PROJ_ROLLUP_BULK_TEMP

3690: , l_new_completion_date6(l_counter)
3691: , l_null_flag6
3692: , l_task_count6
3693: , l_task_flag
3694: FROM PA_PROJ_ROLLUP_BULK_TEMP
3695: WHERE PROCESS_NUMBER = l_process_number
3696: AND parent_object_id = l_parent_object_ids_tab(j);
3697: EXCEPTION
3698: WHEN OTHERS THEN

Line 3902: UPDATE PA_PROJ_ROLLUP_BULK_TEMP SET

3898: -- 2. Update at each node level in database and do not do bulk update.
3899: -- Currently implementing this approach as it seems more performant.
3900:
3901: IF l_parent_update_required = 'Y' THEN
3902: UPDATE PA_PROJ_ROLLUP_BULK_TEMP SET
3903: 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)
3904: , 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)
3905: , 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)
3906: , 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)

Line 3942: UPDATE PA_PROJ_ROLLUP_BULK_TEMP SET

3938: -- Currently implementing this approach as it seems more performant.
3939: /* Do not remove
3940: IF l_parent_update_required = 'Y' THEN
3941: FORALL k in 1..l_object_ids_tab.count
3942: UPDATE PA_PROJ_ROLLUP_BULK_TEMP SET
3943: 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)
3944: , 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)
3945: , duration1 = decode(l_update_requ_flag_tab1(k), 'Y', decode(l_update_date_flag_tab1(k), 'Y', l_new_duration1(k), duration1), duration1)
3946: , 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)

Line 4043: FROM PA_PROJ_ROLLUP_BULK_TEMP

4039: , MAX(decode(rollup_node5, 'Y', nvl(PROGRESS_OVERRIDE5, nvl(PROGRESS_STATUS_WEIGHT5, -99)), -99))
4040: , MAX(decode(rollup_node6, 'Y', nvl(PROGRESS_OVERRIDE6, nvl(PROGRESS_STATUS_WEIGHT6, -99)), -99))
4041: , count(*)
4042: INTO l_weight1, l_weight2, l_weight3, l_weight4, l_weight5, l_weight6, l_count
4043: FROM PA_PROJ_ROLLUP_BULK_TEMP
4044: WHERE PROCESS_NUMBER = l_process_number
4045: AND Parent_Object_ID = l_object_ids_tab(i)
4046: --AND OBJECT_TYPE IN ('PA_TASKS', 'PA_STRUCTURES', 'PA_DELIVERABLES', 'PA_SUBPROJECTS')
4047: -- 4366733 : Deliverable Progress Status should not rollup

Line 4059: FROM PA_PROJ_ROLLUP_BULK_TEMP

4055: , MAX(nvl(PROGRESS_OVERRIDE5, nvl(PROGRESS_STATUS_WEIGHT5, -99)))
4056: , MAX(nvl(PROGRESS_OVERRIDE6, nvl(PROGRESS_STATUS_WEIGHT6, -99)))
4057: , count(*)
4058: INTO l_weight1, l_weight2, l_weight3, l_weight4, l_weight5, l_weight6, l_count
4059: FROM PA_PROJ_ROLLUP_BULK_TEMP
4060: WHERE PROCESS_NUMBER = l_process_number
4061: AND Parent_Object_ID = l_object_ids_tab(i)
4062: --AND OBJECT_TYPE IN ('PA_TASKS', 'PA_STRUCTURES', 'PA_DELIVERABLES','PA_SUBPROJECTS')
4063: -- 4366733 : Deliverable Progress Status should not rollup

Line 4129: UPDATE /+ INDEX( T1 PA_PROJ_ROLLUP_BULK_TEMP_U1) / PA_PROJ_ROLLUP_BULK_TEMP T1

4125: END IF;
4126: END IF;
4127: IF l_update_required = 'Y' THEN
4128: /* Added the hint to force the unique index for bug#6185523 */
4129: UPDATE /*+ INDEX( T1 PA_PROJ_ROLLUP_BULK_TEMP_U1) */ PA_PROJ_ROLLUP_BULK_TEMP T1
4130: SET T1.PROGRESS_STATUS_WEIGHT1=l_sum_tab1(i)
4131: , T1.PROGRESS_STATUS_WEIGHT2=l_sum_tab2(i)
4132: , T1.PROGRESS_STATUS_WEIGHT3=l_sum_tab3(i)
4133: , T1.PROGRESS_STATUS_WEIGHT4=l_sum_tab4(i)

Line 4146: UPDATE PA_PROJ_ROLLUP_BULK_TEMP T1

4142: -- Note that Bulk Update is not implemented due to the reasons mentioned in Date Rollup section
4143: /* Please Do no remove
4144: IF l_update_required = 'Y' THEN
4145: FORALL i in 1..l_object_ids_tab.count
4146: UPDATE PA_PROJ_ROLLUP_BULK_TEMP T1
4147: SET T1.PROGRESS_STATUS_WEIGHT1=l_sum_tab1(i)
4148: , T1.PROGRESS_STATUS_WEIGHT2=l_sum_tab2(i)
4149: , T1.PROGRESS_STATUS_WEIGHT3=l_sum_tab3(i)
4150: , T1.PROGRESS_STATUS_WEIGHT4=l_sum_tab4(i)

Line 4399: UPDATE /+ INDEX( T1 PA_PROJ_ROLLUP_BULK_TEMP_U1) / PA_PROJ_ROLLUP_BULK_TEMP T1

4395: END IF;
4396:
4397: IF l_update_required = 'Y' THEN
4398: /* Added the hint to force the unique index for bug#6185523 */
4399: UPDATE /*+ INDEX( T1 PA_PROJ_ROLLUP_BULK_TEMP_U1) */ PA_PROJ_ROLLUP_BULK_TEMP T1
4400: SET T1.TASK_STATUS1= l_sum_tab1(i)
4401: , T1.TASK_STATUS2=l_sum_tab2(i)
4402: , T1.TASK_STATUS3=l_sum_tab3(i)
4403: , T1.TASK_STATUS4=l_sum_tab4(i)

Line 4415: UPDATE PA_PROJ_ROLLUP_BULK_TEMP T1

4411: -- Note that Bulk Update is not implemented due to the reasons mentioned in Date Rollup section
4412: /* Please Do no remove
4413: IF l_update_required = 'Y' THEN
4414: FORALL i in 1..l_object_ids_tab.count
4415: UPDATE PA_PROJ_ROLLUP_BULK_TEMP T1
4416: SET T1.TASK_STATUS1= l_sum_tab1(i)
4417: , T1.TASK_STATUS2=l_sum_tab2(i)
4418: , T1.TASK_STATUS3=l_sum_tab3(i)
4419: , T1.TASK_STATUS4=l_sum_tab4(i)

Line 4527: FROM PA_PROJ_ROLLUP_BULK_TEMP

4523: , l_actual_duration4, l_pc_duration4
4524: , l_actual_duration5, l_pc_duration5
4525: , l_actual_duration6, l_pc_duration6
4526: , l_count
4527: FROM PA_PROJ_ROLLUP_BULK_TEMP
4528: WHERE Process_Number = l_Process_Number
4529: AND OBJECT_TYPE = 'PA_DELIVERABLES'
4530: AND Parent_Object_ID = l_object_ids_tab(i)
4531: AND parent_object_type IN ('PA_STRUCTURES','PA_TASKS') -- Bug 4450587

Line 4553: FROM PA_PROJ_ROLLUP_BULK_TEMP

4549: , l_actual_duration4, l_pc_duration4
4550: , l_actual_duration5, l_pc_duration5
4551: , l_actual_duration6, l_pc_duration6
4552: , l_count
4553: FROM PA_PROJ_ROLLUP_BULK_TEMP
4554: WHERE Process_Number = l_Process_Number
4555: AND OBJECT_TYPE IN ('PA_ASSIGNMENTS', 'PA_SUBPROJECTS')
4556: AND Parent_Object_ID = l_object_ids_tab(i)
4557: AND parent_object_type IN ('PA_STRUCTURES','PA_TASKS') -- Bug 4450587

Line 4686: UPDATE /+ INDEX( T1 PA_PROJ_ROLLUP_BULK_TEMP_U1) / PA_PROJ_ROLLUP_BULK_TEMP T1

4682:
4683: IF l_update_required = 'Y' THEN
4684: FORALL i in 1..l_object_ids_tab.count
4685: /* Added the hint to force the unique index for bug#6185523 */
4686: UPDATE /*+ INDEX( T1 PA_PROJ_ROLLUP_BULK_TEMP_U1) */ PA_PROJ_ROLLUP_BULK_TEMP T1
4687: SET t1.percent_complete1=l_percent_complete_tab1(i)
4688: , t1.percent_complete2=l_percent_complete_tab2(i)
4689: , t1.percent_complete3=l_percent_complete_tab3(i)
4690: , t1.percent_complete4=l_percent_complete_tab4(i)

Line 4791: FROM PA_PROJ_ROLLUP_BULK_TEMP

4787: , l_actual_duration4, l_pc_duration4
4788: , l_actual_duration5, l_pc_duration5
4789: , l_actual_duration6, l_pc_duration6
4790: , l_count
4791: FROM PA_PROJ_ROLLUP_BULK_TEMP
4792: WHERE Process_Number = l_Process_Number
4793: AND OBJECT_TYPE = 'PA_DELIVERABLES'
4794: AND Parent_Object_ID = l_object_ids_tab(i)
4795: AND parent_object_type IN ('PA_STRUCTURES','PA_TASKS') -- Bug 4450587

Line 4856: FROM PA_PROJ_ROLLUP_BULK_TEMP

4852: , l_actual_duration4_a, l_duration4_a
4853: , l_actual_duration5_a, l_duration5_a
4854: , l_actual_duration6_a, l_duration6_a
4855: , l_count
4856: FROM PA_PROJ_ROLLUP_BULK_TEMP
4857: WHERE Process_Number = l_Process_Number
4858: AND OBJECT_TYPE = 'PA_ASSIGNMENTS'
4859: AND Parent_Object_ID = l_object_ids_tab(i)
4860: AND parent_object_type = 'PA_TASKS'

Line 4953: FROM PA_PROJ_ROLLUP_BULK_TEMP

4949: , l_actual_duration4_t, l_duration4_t
4950: , l_actual_duration5_t, l_duration5_t
4951: , l_actual_duration6_t, l_duration6_t
4952: , l_count1
4953: FROM PA_PROJ_ROLLUP_BULK_TEMP
4954: WHERE Process_Number = l_Process_Number
4955: AND OBJECT_TYPE = 'PA_SUBPROJECTS'
4956: AND Parent_Object_ID = l_object_ids_tab(i)
4957: AND parent_object_type = 'PA_TASKS'

Line 5031: FROM PA_PROJ_ROLLUP_BULK_TEMP

5027: , l_actual_duration4_a, l_duration4_a
5028: , l_actual_duration5_a, l_duration5_a
5029: , l_actual_duration6_a, l_duration6_a
5030: , l_count
5031: FROM PA_PROJ_ROLLUP_BULK_TEMP
5032: WHERE Process_Number = l_Process_Number
5033: AND OBJECT_TYPE = 'PA_ASSIGNMENTS'
5034: AND Parent_Object_ID = l_object_ids_tab(i)
5035: AND parent_object_type IN ('PA_STRUCTURES','PA_TASKS') -- Bug 4450587

Line 5128: FROM PA_PROJ_ROLLUP_BULK_TEMP

5124: , l_actual_duration4_t, l_duration4_t
5125: , l_actual_duration5_t, l_duration5_t
5126: , l_actual_duration6_t, l_duration6_t
5127: , l_count1 -- Bug 4343615
5128: FROM PA_PROJ_ROLLUP_BULK_TEMP
5129: WHERE Process_Number = l_Process_Number
5130: --AND OBJECT_TYPE = 'PA_TASKS' --4582956
5131: AND OBJECT_TYPE IN ('PA_TASKS','PA_SUBPROJECTS') --4582956 : Added PA_SUBPROJECTS
5132: AND Parent_Object_ID = l_object_ids_tab(i)

Line 5187: FROM PA_PROJ_ROLLUP_BULK_TEMP

5183: , l_actual_duration4, l_pc_duration4
5184: , l_actual_duration5, l_pc_duration5
5185: , l_actual_duration6, l_pc_duration6
5186: , l_count
5187: FROM PA_PROJ_ROLLUP_BULK_TEMP
5188: WHERE Process_Number = l_Process_Number
5189: AND OBJECT_TYPE = 'PA_TASKS'
5190: AND Parent_Object_ID = l_object_ids_tab(i)
5191: AND parent_object_type IN ('PA_STRUCTURES','PA_TASKS') -- Bug 4450587

Line 5317: UPDATE /+ INDEX( T1 PA_PROJ_ROLLUP_BULK_TEMP_U1) / PA_PROJ_ROLLUP_BULK_TEMP T1

5313: END IF; -- l_count > 0
5314:
5315: IF l_update_required = 'Y' THEN
5316: /* Added the hint to force the unique index for bug#6185523 */
5317: UPDATE /*+ INDEX( T1 PA_PROJ_ROLLUP_BULK_TEMP_U1) */ PA_PROJ_ROLLUP_BULK_TEMP T1
5318: SET T1.PERCENT_COMPLETE1=l_PERCENT_COMPLETE_tab1(i)
5319: , T1.PERCENT_COMPLETE2=l_PERCENT_COMPLETE_tab2(i)
5320: , T1.PERCENT_COMPLETE3=l_PERCENT_COMPLETE_tab3(i)
5321: , T1.PERCENT_COMPLETE4=l_PERCENT_COMPLETE_tab4(i)

Line 5340: UPDATE PA_PROJ_ROLLUP_BULK_TEMP T1

5336: -- Note that Bulk Update is not implemnted due to reason mentioned in Dates Rollup section
5337: /* Please do not remove
5338: IF l_update_required = 'Y' THEN
5339: FORALL i in 1..l_object_ids_tab.count
5340: UPDATE PA_PROJ_ROLLUP_BULK_TEMP T1
5341: SET T1.PERCENT_COMPLETE1=l_PERCENT_COMPLETE_tab1(i)
5342: , T1.PERCENT_COMPLETE2=l_PERCENT_COMPLETE_tab2(i)
5343: , T1.PERCENT_COMPLETE3=l_PERCENT_COMPLETE_tab3(i)
5344: , T1.PERCENT_COMPLETE4=l_PERCENT_COMPLETE_tab4(i)

Line 5553: FROM PA_PROJ_ROLLUP_BULK_TEMP

5549: l_sum_tab4(i),
5550: l_sum_tab5(i),
5551: l_sum_tab6(i),
5552: l_Count
5553: FROM PA_PROJ_ROLLUP_BULK_TEMP
5554: WHERE Process_Number = l_Process_Number
5555: AND OBJECT_TYPE <> 'PA_DELIVERABLES'
5556: AND Parent_Object_ID =l_object_ids_tab(i)
5557: AND parent_object_type IN ('PA_STRUCTURES','PA_TASKS') -- Bug 4450587

Line 5694: FROM PA_PROJ_ROLLUP_BULK_TEMP

5690: l_sum_tab4(i),
5691: l_sum_tab5(i),
5692: l_sum_tab6(i),
5693: l_Count
5694: FROM PA_PROJ_ROLLUP_BULK_TEMP
5695: WHERE Process_Number = l_Process_Number
5696: AND OBJECT_TYPE <> 'PA_DELIVERABLES'
5697: AND Parent_Object_ID =l_object_ids_tab(i)
5698: AND parent_object_type IN ('PA_STRUCTURES','PA_TASKS') -- Bug 4450587

Line 5708: UPDATE /+ INDEX( T1 PA_PROJ_ROLLUP_BULK_TEMP_U1) / PA_PROJ_ROLLUP_BULK_TEMP T1

5704: END;
5705: IF (l_count > 0) THEN
5706: l_update_required := 'Y';
5707: /* Added the hint to force the unique index for bug#6185523 */
5708: UPDATE /*+ INDEX( T1 PA_PROJ_ROLLUP_BULK_TEMP_U1) */ PA_PROJ_ROLLUP_BULK_TEMP T1
5709: SET T1.ETC_Cost1=l_ETC_Cost_tab1(i)
5710: , T1.ETC_Cost2=l_ETC_Cost_tab2(i)
5711: , T1.ETC_Cost3=l_ETC_Cost_tab3(i)
5712: , T1.ETC_Cost4=l_ETC_Cost_tab4(i)

Line 5785: UPDATE PA_PROJ_ROLLUP_BULK_TEMP T1

5781: -- NOte that Bulk Update is not done due to problem mentioned in Dates Rollup Section
5782: /* Please do not remove
5783: IF l_update_required = 'Y' THEN
5784: FORALL i in 1..l_object_ids_tab.count
5785: UPDATE PA_PROJ_ROLLUP_BULK_TEMP T1
5786: SET T1.ETC_Cost1=l_ETC_Cost_tab1(i)
5787: , T1.ETC_Cost2=l_ETC_Cost_tab2(i)
5788: , T1.ETC_Cost3=l_ETC_Cost_tab3(i)
5789: , T1.ETC_Cost4=l_ETC_Cost_tab4(i)

Line 5894: delete from PA_PROJ_ROLLUP_BULK_TEMP where process_number = l_process_number;

5890: END IF;
5891:
5892: -- Bug 4289748 : removed rollback, used delete instead
5893: --ROLLBACK TO SAVEPOINT GENERATE_SCHEDULE_SP;
5894: delete from PA_PROJ_ROLLUP_BULK_TEMP where process_number = l_process_number;
5895: --4538049 : No need to check for x_msg_count
5896: --x_msg_count := FND_MSG_PUB.Count_Msg;
5897: --IF x_msg_count = 1 THEN
5898: -- pa_interface_utils_pub.get_messages (