APPS.PA_SCHEDULE_OBJECTS_PVT dependencies on PA_PROJ_ROLLUP_BULK_TEMP_S

Line 1331: SELECT PA_PROJ_ROLLUP_BULK_TEMP_S.nextval

1327:
1328: SAVEPOINT GENERATE_SCHEDULE_SP;
1329:
1330: -- Derive the next Process Number
1331: SELECT PA_PROJ_ROLLUP_BULK_TEMP_S.nextval
1332: INTO l_Process_Number FROM dual;
1333:
1334: x_Process_Number := l_Process_Number;
1335:

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

3116: /* Ends Added the following logic for bug#6185523 */
3117:
3118: IF l_parent_update_required = 'Y' THEN
3119: /* Commented the following update statement and introduced a new one for bug#6185523
3120: UPDATE + INDEX( SchTmp PA_PROJ_ROLLUP_BULK_TEMP_U1) PA_PROJ_ROLLUP_BULK_TEMP SchTmp SET
3121: 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)
3122: , 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)
3123: , duration1 = decode(l_update_requ_flag_tab1(j), 'Y', decode(l_update_date_flag_tab1(j), 'Y', l_parent_duration_tab1(j), duration1), duration1)
3124: , 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 3150: UPDATE /*+ INDEX( SchTmp PA_PROJ_ROLLUP_BULK_TEMP_U1) */ PA_PROJ_ROLLUP_BULK_TEMP SchTmp SET

3146: AND object_type = l_parent_object_types_tab(j)
3147: and process_number = l_process_number;
3148: Ends commented code for bug#6185523 And added the below update*/
3149:
3150: UPDATE /*+ INDEX( SchTmp PA_PROJ_ROLLUP_BULK_TEMP_U1) */ PA_PROJ_ROLLUP_BULK_TEMP SchTmp SET
3151: start_date1 = nvl(l_parent_start_date1_tmp, start_date1)
3152: , finish_date1 = nvl(l_parent_finish_date1_tmp, finish_date1)
3153: , duration1 = nvl(l_parent_duration1_tmp, duration1)
3154: , start_date2 = nvl(l_parent_start_date2_tmp, start_date2)

Line 3956: UPDATE PA_PROJ_ROLLUP_BULK_TEMP SET

3952: -- 2. Update at each node level in database and do not do bulk update.
3953: -- Currently implementing this approach as it seems more performant.
3954:
3955: IF l_parent_update_required = 'Y' THEN
3956: UPDATE PA_PROJ_ROLLUP_BULK_TEMP SET
3957: 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)
3958: , 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)
3959: , 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)
3960: , 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 3996: UPDATE PA_PROJ_ROLLUP_BULK_TEMP SET

3992: -- Currently implementing this approach as it seems more performant.
3993: /* Do not remove
3994: IF l_parent_update_required = 'Y' THEN
3995: FORALL k in 1..l_object_ids_tab.count
3996: UPDATE PA_PROJ_ROLLUP_BULK_TEMP SET
3997: 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)
3998: , 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)
3999: , duration1 = decode(l_update_requ_flag_tab1(k), 'Y', decode(l_update_date_flag_tab1(k), 'Y', l_new_duration1(k), duration1), duration1)
4000: , 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)