[Home] [Help]
404: CURSOR cur_obj_rel
405: IS
406: select object_id_to1 from pa_object_relationships
407: where object_id_to1 = l_element_version_id and
408: object_id_from1 = PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(l_project_id)
409: and object_type_from = 'PA_STRUCTURES'
410: and relationship_type = 'S';
411: /*
412: CURSOR cur_obj_rel
436: from pa_resource_assignments ra,
437: pa_proj_element_versions pelm
438: where ra.resource_assignment_id = p_resource_assignment_id
439: AND pelm.proj_element_id(+)=ra.task_id
440: AND pelm.parent_structure_Version_id(+)=PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(ra.project_id);
441: EXCEPTION
442: when NO_DATA_FOUND then
443: return l_return_value;
444: END;
2789: IF l_debug_mode = 'Y' THEN
2790: pa_debug.g_err_stage:='Fetching PARENT_STRUCTURE_VERSION_ID';
2791: pa_debug.write('PAFPPEUB.add_new_resource_assignments',pa_debug.g_err_stage,3);
2792: END IF;
2793: l_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(p_project_id);
2794:
2795: l_Cbs_Enabled := PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(p_Project_Id => p_project_id); -- bug#16481402
2796:
2797: /*
3174: l_edit_plan_bv_id <> NVL(p_budget_version_id,-99)) THEN
3175:
3176: SELECT DECODE(wp_version_flag,
3177: 'Y',project_structure_version_id,
3178: PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(project_id))
3179: INTO l_edit_plan_struct_id
3180: FROM pa_budget_versions
3181: WHERE budget_Version_id=p_budget_version_id;
3182:
3295: l_return_value := null;
3296: l_structure_version_id :=
3297: pa_planning_element_utils.get_fin_struct_id(p_project_id,p_budget_version_id);
3298: l_structure_status_flag :=
3299: PA_PROJECT_STRUCTURE_UTILS.Check_Struc_Ver_Published(
3300: p_project_id,
3301: l_structure_version_id);
3302: if l_structure_status_flag = 'Y' then
3303: l_structure_status := 'PUBLISHED';