[Home] [Help]
332: WHERE PROJECT_ID = c_project_id
333: AND element_version_id = c_element_version_id;
334:
335: CURSOR c_get_dlv_status(c_task_id NUMBER) IS
336: SELECT 'Y' FROM DUAL
337: WHERE EXISTS
338: (SELECT 'xyz'
339: FROM pa_percent_completes
340: WHERE project_id = p_project_id
1529: --l_lowest_task := p_lowest_task;
1530: -- Loop thru all the parents of the passed task
1531:
1532: SELECT PA_PROJ_ROLLUP_TEMP_S.nextval
1533: INTO l_process_number_temp FROM dual;
1534:
1535: IF p_rollup_entire_wbs = 'N' THEN
1536: INSERT INTO pa_proj_rollup_temp(process_number, object_id, object_type, wbs_level)
1537: SELECT distinct l_process_number_temp, object_id_from1, 'PA_TASKS', 1
1542: CONNECT BY PRIOR object_id_from1 = object_id_to1
1543: AND relationship_type = 'S'
1544: UNION ALL -- 4563049 : Rollup Structure also if passed, so that it can populate ETC from PJI
1545: SELECT distinct l_process_number_temp, l_task_version_id object_id_from1, 'PA_TASKS', 1
1546: FROM dual
1547: WHERE l_task_version_id = p_structure_version_id
1548: ;
1549: ELSE
1550: IF g1_debug_mode = 'Y' THEN
1585: AND PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(element_version_id) = 'Y'
1586: AND object_type = 'PA_TASKS'
1587: UNION
1588: SELECT l_process_number_temp, p_structure_version_id object_id_from1, 'PA_TASKS', 1
1589: FROM dual
1590: ;
1591: END IF;
1592: END IF;
1593:
2357: AND l_actual_lowest_task = 'N' -- Bug 4392189
2358: THEN
2359: INSERT INTO pa_proj_rollup_temp(process_number, object_id, object_type, wbs_level)
2360: SELECT l_process_number_temp, p_task_version_id, 'PA_TASKS', 1
2361: FROM dual;
2362:
2363: FOR cur_tasks_rec in cur_tasks(1) LOOP
2364: IF cur_tasks_rec.object_type = 'PA_TASKS' THEN
2365: IF g1_debug_mode = 'Y' THEN
2743: l_child_rollup_rec_exists := 'N';
2744: IF p_rollup_entire_wbs='Y' THEN
2745: BEGIN
2746: SELECT 'Y' into l_child_rollup_rec_exists
2747: FROM dual
2748: WHERE exists
2749: (
2750: SELECT 'xyz'
2751: from pa_proj_rollup_temp
3857: , l_tsk_prog_pa_period_name_tab(i)
3858: , l_tsk_prog_gl_period_name_tab(i)
3859: , l_tsk_base_percent_comp_tab(i) -- 4392189 : Program Reporting Changes - Phase 2
3860: FROM
3861: DUAL
3862: WHERE l_tsk_create_required(i) = 'Y'
3863: ;
3864: END IF; -- IF p_calling_mode <> 'FUTURE_ROLLUP' OR p_calling_mode IS NULL THEN
3865:
4765: CLOSE cur_get_status_weight;
4766:
4767: SELECT GREATEST(l_par_progress_status_weight, l_child_progress_status_weight)
4768: INTO l_progress_status_weight
4769: FROM DUAL;
4770:
4771: IF g1_debug_mode = 'Y' THEN
4772: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.PROGRAM_ROLLUP_PVT', x_Msg => 'l_par_progress_status_weight='||l_par_progress_status_weight, x_Log_Level=> 3);
4773: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.PROGRAM_ROLLUP_PVT', x_Msg => 'l_child_progress_status_weight='||l_child_progress_status_weight, x_Log_Level=> 3);
4796:
4797: IF l_sub_project_rec.ACTUAL_START_DATE IS NOT NULL AND l_parent_task_rec.ACTUAL_START_DATE IS NOT NULL THEN
4798: SELECT LEAST(l_sub_project_rec.ACTUAL_START_DATE, l_parent_task_rec.ACTUAL_START_DATE)
4799: INTO l_actual_start_date
4800: FROM DUAL;
4801: ELSIF l_sub_project_rec.ACTUAL_START_DATE IS NULL AND l_parent_task_rec.ACTUAL_START_DATE IS NOT NULL THEN
4802: l_actual_start_date := l_parent_task_rec.ACTUAL_START_DATE;
4803: ELSIF l_sub_project_rec.ACTUAL_START_DATE IS NOT NULL AND l_parent_task_rec.ACTUAL_START_DATE IS NULL THEN
4804: l_actual_start_date := l_sub_project_rec.ACTUAL_START_DATE;
4808:
4809: IF l_sub_project_rec.ACTUAL_FINISH_DATE IS NOT NULL AND l_parent_task_rec.ACTUAL_FINISH_DATE IS NOT NULL THEN
4810: SELECT GREATEST(l_sub_project_rec.ACTUAL_FINISH_DATE, l_parent_task_rec.ACTUAL_FINISH_DATE)
4811: INTO l_actual_finish_date
4812: FROM DUAL;
4813: ELSIF l_sub_project_rec.ACTUAL_FINISH_DATE IS NULL AND l_parent_task_rec.ACTUAL_FINISH_DATE IS NOT NULL THEN
4814: l_actual_finish_date := l_parent_task_rec.ACTUAL_FINISH_DATE;
4815: ELSIF l_sub_project_rec.ACTUAL_FINISH_DATE IS NOT NULL AND l_parent_task_rec.ACTUAL_FINISH_DATE IS NULL THEN
4816: l_actual_finish_date := l_sub_project_rec.ACTUAL_FINISH_DATE;
4820:
4821: IF l_sub_project_rec.ESTIMATED_START_DATE IS NOT NULL AND l_parent_task_rec.ESTIMATED_START_DATE IS NOT NULL THEN
4822: SELECT LEAST(l_sub_project_rec.ESTIMATED_START_DATE, l_parent_task_rec.ESTIMATED_START_DATE)
4823: INTO l_estimated_start_date
4824: FROM DUAL;
4825: ELSIF l_sub_project_rec.ESTIMATED_START_DATE IS NULL AND l_parent_task_rec.ESTIMATED_START_DATE IS NOT NULL THEN
4826: l_estimated_start_date := l_parent_task_rec.ESTIMATED_START_DATE;
4827: ELSIF l_sub_project_rec.ESTIMATED_START_DATE IS NOT NULL AND l_parent_task_rec.ESTIMATED_START_DATE IS NULL THEN
4828: l_estimated_start_date := l_sub_project_rec.ESTIMATED_START_DATE;
4832:
4833: IF l_sub_project_rec.ESTIMATED_FINISH_DATE IS NOT NULL AND l_parent_task_rec.ESTIMATED_FINISH_DATE IS NOT NULL THEN
4834: SELECT GREATEST(l_sub_project_rec.ESTIMATED_FINISH_DATE, l_parent_task_rec.ESTIMATED_FINISH_DATE)
4835: INTO l_estimated_finish_date
4836: FROM DUAL;
4837: ELSIF l_sub_project_rec.ESTIMATED_FINISH_DATE IS NULL AND l_parent_task_rec.ESTIMATED_FINISH_DATE IS NOT NULL THEN
4838: l_estimated_finish_date := l_parent_task_rec.ESTIMATED_FINISH_DATE;
4839: ELSIF l_sub_project_rec.ESTIMATED_START_DATE IS NOT NULL AND l_parent_task_rec.ESTIMATED_FINISH_DATE IS NULL THEN
4840: l_estimated_finish_date := l_sub_project_rec.ESTIMATED_FINISH_DATE;
6666: -- Bug 3956299 End
6667:
6668: -- Bug 3922325 Begin
6669: CURSOR c_get_dlv_status IS
6670: SELECT 'Y' FROM DUAL
6671: WHERE EXISTS
6672: (SELECT 'xyz'
6673: FROM pa_percent_completes
6674: WHERE project_id = p_project_id
9311:
9312:
9313: select PA_PERCENT_COMPLETES_S.nextval
9314: into x_percent_complete_id
9315: from dual;
9316:
9317: select PA_PROGRESS_ROLLUP_S.nextval
9318: into X_PROGRESS_ROLLUP_ID
9319: from dual;
9315: from dual;
9316:
9317: select PA_PROGRESS_ROLLUP_S.nextval
9318: into X_PROGRESS_ROLLUP_ID
9319: from dual;
9320: IF g1_debug_mode = 'Y' THEN
9321: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.convert_task_prog_to_assgn', x_Msg => 'Before Inserting into pa_percent_completes', x_Log_Level=> 3);
9322: END IF;
9323: INSERT INTO pa_percent_completes(