APPS.PA_SCHEDULE_OBJECTS_PVT dependencies on PA_PROJ_ROLLUP_BULK_TEMP_S

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 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 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)