[Home] [Help]
1829: --Bug No 3450684 SMukka Commented if condition
1830: --IF NOT ( p_structure_type = 'WORKPLAN' AND
1831: -- l_shared = 'N' AND
1832: -- ( PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(p_project_id) = 'MANUAL' OR
1833: -- pa_task_type_utils.check_tk_type_progressable(l_task_type_id)='N') )
1834: --THEN
1835:
1836: PA_PROJ_TASK_STRUC_PUB.SET_UPDATE_WBS_FLAG
1837: ( p_calling_context => p_calling_module
1954: WHERE proj_element_id = l_task_id
1955: AND project_id = p_project_id;
1956: */
1957:
1958: IF ('N' = PA_TASK_TYPE_UTILS.check_tk_type_wq_enabled(l_task_type_id) OR
1959: 'N' = PA_PROGRESS_UTILS.get_project_wq_flag(p_project_id)) THEN
1960: IF (P_PLANNED_WORK_QUANTITY <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND P_PLANNED_WORK_QUANTITY IS NOT NULL) THEN
1961: l_wq_planned_quantity := NULL;
1962: END IF;
3219: --WHERE proj_element_id = p_task_id, rtarway, BUG 3666023, replace by l_task_id
3220: WHERE proj_element_id = l_task_id
3221: AND project_id = p_project_id;
3222:
3223: IF ('N' = PA_TASK_TYPE_UTILS.check_tk_type_wq_enabled(l_task_type_id) OR
3224: 'N' = PA_PROGRESS_UTILS.get_project_wq_flag(p_project_id)) THEN
3225: IF (P_PLANNED_WORK_QUANTITY <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND P_PLANNED_WORK_QUANTITY IS NOT NULL) THEN
3226: l_wq_planned_quantity := NULL;
3227: END IF;
15765: ELSE
15766: open cur_task_type_id(l_task_id);
15767: fetch cur_task_type_id into l_task_type_id;
15768: close cur_task_type_id;
15769: IF pa_task_type_utils.check_tk_type_progressable(l_task_type_id) = 'Y' THEN -- progressible task
15770: l_weighting_percentage_tbl(l_task_id) := 100;
15771: l_child_indicator_tbl(l_parent_version_id) := 'Y';
15772: ELSE -- non progressible task
15773: l_weighting_percentage_tbl(l_task_id) := 0;
15788: ELSE
15789: open cur_task_type_id(l_task_id);
15790: fetch cur_task_type_id into l_task_type_id;
15791: close cur_task_type_id;
15792: IF pa_task_type_utils.check_tk_type_progressable(l_task_type_id) = 'Y' THEN -- progressible task
15793: l_weighting_percentage_tbl(l_task_id) := 100;
15794: l_child_indicator_tbl(l_parent_version_id) := 'Y';
15795: l_existing_task_set_max_wt := 'Y';
15796: ELSE -- non progressible task
16654: END IF;
16655:
16656: -- Need to check if the project and the task type allows for planned work quantity. If not allowed then
16657: -- set the value to null so that it can be passed on to create_schedule_version api.
16658: IF ('N' = PA_TASK_TYPE_UTILS.check_tk_type_wq_enabled(l_task_type_id) OR
16659: 'N' = PA_PROGRESS_UTILS.get_project_wq_flag(p_project_id))
16660: THEN
16661: IF (l_task_in_rec.PLANNED_WORK_QUANTITY <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
16662: l_task_in_rec.PLANNED_WORK_QUANTITY IS NOT NULL)
16676:
16677: END IF;
16678:
16679: --bug 3035902 maansari
16680: IF pa_task_type_utils.check_tk_type_progressable(l_task_TYPE_ID) = 'Y'
16681: AND NVL( l_progressable_task, 'N' ) = 'N'
16682: THEN
16683: l_progressable_task := 'Y';
16684: END IF;
16698: OPEN cur_task_type_id(l_task_in_rec.pa_task_id);
16699: FETCH cur_task_type_id INTO l_task_type_id;
16700: CLOSE cur_task_type_id;
16701:
16702: IF ('N' = PA_TASK_TYPE_UTILS.check_tk_type_wq_enabled(l_task_type_id) OR
16703: 'N' = PA_PROGRESS_UTILS.get_project_wq_flag(p_project_id)) THEN
16704: l_wq_planned_quantity := null;
16705: ELSE
16706: IF (l_task_in_rec.PLANNED_WORK_QUANTITY = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
16714:
16715: END IF;
16716:
16717: --bug 3035902 maansari
16718: IF pa_task_type_utils.check_tk_type_progressable(l_task_TYPE_ID) = 'Y'
16719: AND NVL( l_progressable_task, 'N' ) = 'N'
16720: THEN
16721: l_progressable_task := 'Y';
16722: END IF;