APPS.PA_PROJ_ELEMENTS_UTILS dependencies on PA_PROJECT_STRUCTURE_UTILS

Line 71: -- IF (PA_PROJECT_STRUCTURE_UTILS.Check_Struc_Ver_Published(p_project_id, p_structure_version_id) = 'Y') THEN

67: END IF;
68: CLOSE c1;
69:
70: --check if this is published
71: -- IF (PA_PROJECT_STRUCTURE_UTILS.Check_Struc_Ver_Published(p_project_id, p_structure_version_id) = 'Y') THEN
72: -- return 'N';
73: -- END IF;
74: IF ('N' = PA_PROJECT_STRUCTURE_UTILS.check_edit_wp_ok(p_project_id, p_structure_version_id)) THEN
75: -- Bug 4533152

Line 74: IF ('N' = PA_PROJECT_STRUCTURE_UTILS.check_edit_wp_ok(p_project_id, p_structure_version_id)) THEN

70: --check if this is published
71: -- IF (PA_PROJECT_STRUCTURE_UTILS.Check_Struc_Ver_Published(p_project_id, p_structure_version_id) = 'Y') THEN
72: -- return 'N';
73: -- END IF;
74: IF ('N' = PA_PROJECT_STRUCTURE_UTILS.check_edit_wp_ok(p_project_id, p_structure_version_id)) THEN
75: -- Bug 4533152
76: IF p_add_error_flag = 'Y' THEN
77: PA_UTILS.ADD_MESSAGE
78: (p_app_short_name => 'PA',

Line 100: l_lock := PA_PROJECT_STRUCTURE_UTILS.IS_STRUC_VER_LOCKED_BY_USER(FND_GLOBAL.USER_ID, p_structure_version_id);

96: IF (l_version_enable_flag = 'Y') THEN
97: -- The following API returns 'Y' if locked by current user , '0' if Locked by some other user and 'N' if no one is locking
98: -- If no one is locking we can still allow editing.
99: --bug 4239490
100: l_lock := PA_PROJECT_STRUCTURE_UTILS.IS_STRUC_VER_LOCKED_BY_USER(FND_GLOBAL.USER_ID, p_structure_version_id);
101:
102: -- Bug Fix: 4725901
103: -- DHI ER:
104: -- Need to consider the p_require_lock_flag.

Line 479: x_element_version_id := PA_PROJECT_STRUCTURE_UTILS.get_last_updated_working_ver(l_structure_id);

475: OPEN cur_elem_ver_stru3;
476: FETCH cur_elem_ver_stru3 into l_structure_id;
477: CLOSE cur_elem_ver_stru3;
478:
479: x_element_version_id := PA_PROJECT_STRUCTURE_UTILS.get_last_updated_working_ver(l_structure_id);
480:
481: OPEN cur_elem_ver_stru4(l_structure_id, x_element_version_id);
482: FETCH cur_elem_ver_stru4 INTO
483: l_date1

Line 909: -- If (PA_PROJECT_STRUCTURE_UTILS.Check_Struc_Ver_Published(p_project_id, p_parent_structure_ver_id) = 'Y') THEN

905: --Check if this is a published version
906: --hsiu
907: --versioning changes
908: --
909: -- If (PA_PROJECT_STRUCTURE_UTILS.Check_Struc_Ver_Published(p_project_id, p_parent_structure_ver_id) = 'Y') THEN
910: --version is published. Error.
911: -- x_return_status := FND_API.G_RET_STS_ERROR;
912: -- x_error_message_code := 'PA_PS_STRUC_VER_LOCKED';
913: -- return;

Line 975: IF pa_project_structure_utils.check_task_progress_exist(l_proj_element_id) = 'Y' THEN

971:
972: -- 4201927 commented below code as check_task_progress_exist is deriving project id and then
973: -- calling check_object_has_prog api
974: /*
975: IF pa_project_structure_utils.check_task_progress_exist(l_proj_element_id) = 'Y' THEN
976: x_return_status := FND_API.G_RET_STS_ERROR;
977: x_error_message_code := 'PA_PS_TASK_HAS_PROG';
978: raise FND_API.G_EXC_ERROR;
979: END IF;

Line 2687: l_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_FIN_STRUC_VER_ID(p_project_id);

2683: and proj_element_id = p_task_id;
2684: l_structure_version_id NUMBER;
2685: l_task_version_id NUMBER;
2686: BEGIN
2687: l_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_FIN_STRUC_VER_ID(p_project_id);
2688:
2689: OPEN c1(l_structure_version_id);
2690: FETCH c1 into l_task_version_id;
2691: CLOSE c1;

Line 3029: IF (PA_PROJECT_STRUCTURE_UTILS.check_dep_on_summary_tk_ok(l_project_id) = 'N') THEN

3025: --end bug 3055708
3026:
3027: --bug 3305199: cannot create subtask if dep exists in parent when
3028: --option for no dep in summary task is Y
3029: IF (PA_PROJECT_STRUCTURE_UTILS.check_dep_on_summary_tk_ok(l_project_id) = 'N') THEN
3030: IF ('Y' = PA_RELATIONSHIP_UTILS.CHECK_DEP_EXISTS(p_parent_task_ver_id)) THEN
3031: x_return_status := 'N';
3032: x_error_message_code := 'PA_DEP_ON_SUMM_TSK';
3033: return;

Line 3777: PA_PROJECT_STRUCTURE_UTILS.get_last_updated_working_ver(p_structure_id);

3773: */
3774: IF p_structure_type = 'WORKPLAN' THEN
3775: IF p_is_wp_separate_from_fn = 'Y' AND p_is_wp_versioning_enabled = 'Y' THEN
3776: x_structure_version_id :=
3777: PA_PROJECT_STRUCTURE_UTILS.get_last_updated_working_ver(p_structure_id);
3778: x_task_unpub_ver_status_code := 'WORKING';
3779: END IF;
3780:
3781: IF x_structure_version_id is null THEN