APPS.PA_STRUCT_TASK_ROLLUP_PUB dependencies on PA_PROJECT_STRUCTURE_UTILS

Line 673: ((PA_PROJECT_STRUCTURE_UTILS.get_structrue_version_status(l_lnk_task_project_id, l_structure_version_id) <> 'STRUCTURE_PUBLISHED')

669: IF ((PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(l_lnk_task_project_id) ='N') AND
670: (PA_RELATIONSHIP_UTILS.IS_AUTO_ROLLUP(l_lnk_task_project_id) = 'Y')) OR
671: ((PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(l_lnk_task_project_id) ='Y') AND
672: (PA_RELATIONSHIP_UTILS.IS_AUTO_ROLLUP(l_lnk_task_project_id) = 'Y') AND
673: ((PA_PROJECT_STRUCTURE_UTILS.get_structrue_version_status(l_lnk_task_project_id, l_structure_version_id) <> 'STRUCTURE_PUBLISHED')
674: OR ( p_published_str_ver_id = l_structure_version_id)) --bug5861729
675: )THEN
676: FOR i IN l_rollup_table.FIRST..l_rollup_table.LAST LOOP
677: l_sch_start_date_tbl(i) := l_rollup_table(i).start_date1;

Line 844: (PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(l_struc_project_id) = 'SHARE_FULL')) AND

840: CLOSE get_structure_id;
841:
842: --auto sync changes
843: IF ((PA_WORKPLAN_ATTR_UTILS.CHECK_AUTO_DATE_SYNC_ENABLED(l_structure_id) = 'Y') AND
844: (PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(l_struc_project_id) = 'SHARE_FULL')) AND
845: (l_versioning = 'N') THEN
846: --copy to transaction dates
847: IF (l_debug_mode = 'Y') THEN
848: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject_Unltd', 'Before calling PA_PROJECT_DATES_PUB.COPY_PROJECT_DATES', 3);

Line 1961: (PA_PROJECT_STRUCTURE_UTILS.CHECK_SHARING_ENABLED(l_struc_project_id) = 'Y')) AND

1957: CLOSE get_structure_id;
1958:
1959: /* bug 3676078
1960: IF ((PA_WORKPLAN_ATTR_UTILS.CHECK_AUTO_DATE_SYNC_ENABLED(l_structure_id) = 'Y') AND
1961: (PA_PROJECT_STRUCTURE_UTILS.CHECK_SHARING_ENABLED(l_struc_project_id) = 'Y')) AND
1962: (PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(l_struc_project_id) = 'N') THEN
1963: */
1964: IF ((PA_WORKPLAN_ATTR_UTILS.CHECK_AUTO_DATE_SYNC_ENABLED(l_structure_id) = 'Y') AND
1965: (PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(l_struc_project_id) = 'SHARE_FULL')) AND

Line 1965: (PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(l_struc_project_id) = 'SHARE_FULL')) AND

1961: (PA_PROJECT_STRUCTURE_UTILS.CHECK_SHARING_ENABLED(l_struc_project_id) = 'Y')) AND
1962: (PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(l_struc_project_id) = 'N') THEN
1963: */
1964: IF ((PA_WORKPLAN_ATTR_UTILS.CHECK_AUTO_DATE_SYNC_ENABLED(l_structure_id) = 'Y') AND
1965: (PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(l_struc_project_id) = 'SHARE_FULL')) AND
1966: (PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(l_struc_project_id) = 'N') THEN
1967: --copy to transaction dates
1968:
1969: IF (l_debug_mode = 'Y') THEN

Line 2003: G_IS_SUBPROJECT_EXISTS := PA_PROJECT_STRUCTURE_UTILS.Check_Subproject_Exists(l_struc_project_id,l_structure_version_id, 'WORKPLAN');

1999: --
2000: -- Caching - added below IF block for Huawei enhancement bug 13923366 skkoppul
2001: IF G_STRUCTURE_VERSION_ID IS NULL OR G_STRUCTURE_VERSION_ID <> l_structure_version_id THEN
2002: G_STRUCTURE_VERSION_ID := l_structure_version_id;
2003: G_IS_SUBPROJECT_EXISTS := PA_PROJECT_STRUCTURE_UTILS.Check_Subproject_Exists(l_struc_project_id,l_structure_version_id, 'WORKPLAN');
2004: END IF;
2005:
2006: IF G_IS_SUBPROJECT_EXISTS = 'Y' THEN
2007:

Line 2180: -- IF PA_PROJECT_STRUCTURE_UTILS.CHECK_PUBLISHED_VER_EXISTS(get_str_ver_ic_lnk_tasks_rec.parent_proj_id,

2176: CLOSE check_pub_str;
2177: CLOSE chk_str_working_ver; --this shold be inside ELSE otherwise its giving invalid cursor. --maansari 4293726
2178: END IF; --chk_str_working_ver
2179: ELSE
2180: -- IF PA_PROJECT_STRUCTURE_UTILS.CHECK_PUBLISHED_VER_EXISTS(get_str_ver_ic_lnk_tasks_rec.parent_proj_id,
2181: -- parent_task_str_ver_id) = 'Y' THEN
2182: l_index := 1;
2183: l_parent_task_ver_id_tbl.extend;
2184: l_parent_task_ver_id_tbl(l_index):=get_str_ver_ic_lnk_tasks_rec.parent_task_ver_id;