[Home] [Help]
1613: --Bug No 3450684 SMukka Commented if condition
1614: --IF NOT ( p_structure_type = 'WORKPLAN' AND
1615: -- l_shared = 'N' AND
1616: -- ( PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(p_project_id) = 'MANUAL' OR
1617: -- pa_task_type_utils.check_tk_type_progressable(l_task_type_id)='N') )
1618: --THEN
1619:
1620: PA_PROJ_TASK_STRUC_PUB.SET_UPDATE_WBS_FLAG
1621: ( p_calling_context => p_calling_module
1738: WHERE proj_element_id = l_task_id
1739: AND project_id = p_project_id;
1740: */
1741:
1742: IF ('N' = PA_TASK_TYPE_UTILS.check_tk_type_wq_enabled(l_task_type_id) OR
1743: 'N' = PA_PROGRESS_UTILS.get_project_wq_flag(p_project_id)) THEN
1744: IF (P_PLANNED_WORK_QUANTITY <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND P_PLANNED_WORK_QUANTITY IS NOT NULL) THEN
1745: l_wq_planned_quantity := NULL;
1746: END IF;
3001: --WHERE proj_element_id = p_task_id, rtarway, BUG 3666023, replace by l_task_id
3002: WHERE proj_element_id = l_task_id
3003: AND project_id = p_project_id;
3004:
3005: IF ('N' = PA_TASK_TYPE_UTILS.check_tk_type_wq_enabled(l_task_type_id) OR
3006: 'N' = PA_PROGRESS_UTILS.get_project_wq_flag(p_project_id)) THEN
3007: IF (P_PLANNED_WORK_QUANTITY <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND P_PLANNED_WORK_QUANTITY IS NOT NULL) THEN
3008: l_wq_planned_quantity := NULL;
3009: END IF;
15187: ELSE
15188: open cur_task_type_id(l_task_id);
15189: fetch cur_task_type_id into l_task_type_id;
15190: close cur_task_type_id;
15191: IF pa_task_type_utils.check_tk_type_progressable(l_task_type_id) = 'Y' THEN -- progressible task
15192: l_weighting_percentage_tbl(l_task_id) := 100;
15193: l_child_indicator_tbl(l_parent_version_id) := 'Y';
15194: ELSE -- non progressible task
15195: l_weighting_percentage_tbl(l_task_id) := 0;
15210: ELSE
15211: open cur_task_type_id(l_task_id);
15212: fetch cur_task_type_id into l_task_type_id;
15213: close cur_task_type_id;
15214: IF pa_task_type_utils.check_tk_type_progressable(l_task_type_id) = 'Y' THEN -- progressible task
15215: l_weighting_percentage_tbl(l_task_id) := 100;
15216: l_child_indicator_tbl(l_parent_version_id) := 'Y';
15217: l_existing_task_set_max_wt := 'Y';
15218: ELSE -- non progressible task
16076: END IF;
16077:
16078: -- Need to check if the project and the task type allows for planned work quantity. If not allowed then
16079: -- set the value to null so that it can be passed on to create_schedule_version api.
16080: IF ('N' = PA_TASK_TYPE_UTILS.check_tk_type_wq_enabled(l_task_type_id) OR
16081: 'N' = PA_PROGRESS_UTILS.get_project_wq_flag(p_project_id))
16082: THEN
16083: IF (l_task_in_rec.PLANNED_WORK_QUANTITY <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
16084: l_task_in_rec.PLANNED_WORK_QUANTITY IS NOT NULL)
16098:
16099: END IF;
16100:
16101: --bug 3035902 maansari
16102: IF pa_task_type_utils.check_tk_type_progressable(l_task_TYPE_ID) = 'Y'
16103: AND NVL( l_progressable_task, 'N' ) = 'N'
16104: THEN
16105: l_progressable_task := 'Y';
16106: END IF;
16120: OPEN cur_task_type_id(l_task_in_rec.pa_task_id);
16121: FETCH cur_task_type_id INTO l_task_type_id;
16122: CLOSE cur_task_type_id;
16123:
16124: IF ('N' = PA_TASK_TYPE_UTILS.check_tk_type_wq_enabled(l_task_type_id) OR
16125: 'N' = PA_PROGRESS_UTILS.get_project_wq_flag(p_project_id)) THEN
16126: l_wq_planned_quantity := null;
16127: ELSE
16128: IF (l_task_in_rec.PLANNED_WORK_QUANTITY = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
16136:
16137: END IF;
16138:
16139: --bug 3035902 maansari
16140: IF pa_task_type_utils.check_tk_type_progressable(l_task_TYPE_ID) = 'Y'
16141: AND NVL( l_progressable_task, 'N' ) = 'N'
16142: THEN
16143: l_progressable_task := 'Y';
16144: END IF;