[Home] [Help]
1270: FETCH cur_pa_temp_import INTO l_dummy_char;
1271: IF cur_pa_temp_import%NOTFOUND
1272: THEN
1273:
1274: l_versioned := PA_WORKPLAN_ATTR_UTILS.Check_Wp_Versioning_Enabled(p_project_id);
1275: l_shared := PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(p_project_id);
1276:
1277: IF p_task_id IS NOT NULL AND p_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1278: THEN
1739: --
1740:
1741: IF ('Y' = l_sharing_enabled) THEN
1742: -- Bug 4067757 used l_versioned instead of calling Check_Wp_Versioning_Enabled multiple times
1743: /* IF ('Y' = PA_WORKPLAN_ATTR_UTILS.Check_Wp_Versioning_Enabled(p_project_id)) THEN */
1744: IF (l_versioned = 'Y') THEN
1745: l_task_unpub_ver_status_code := 'WORKING';
1746: ELSE
1747: l_task_unpub_ver_status_code := 'PUBLISHED';
1751: 'N' = PA_PROJECT_STRUCTURE_UTILS.get_struc_type_for_structure(l_structure_id, 'WORKPLAN')) THEN
1752: l_task_unpub_ver_status_code := 'PUBLISHED';
1753: ELSE --workplan only
1754: -- Bug 4067757 used l_versioned instead of calling Check_Wp_Versioning_Enabled multiple times
1755: /* IF ('Y' = PA_WORKPLAN_ATTR_UTILS.Check_Wp_Versioning_Enabled(p_project_id)) THEN */
1756: IF (l_versioned = 'Y') THEN
1757: l_task_unpub_ver_status_code := 'WORKING';
1758: ELSE
1759: l_task_unpub_ver_status_code := 'PUBLISHED';
1884: where element_version_id = l_task_version_id;
1885:
1886: IF (PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(p_project_id) = 'Y') AND
1887: -- Bug 4067757 used l_versioned instead of calling Check_Wp_Versioning_Enabled multiple times
1888: /* (PA_WORKPLAN_ATTR_UTILS.Check_Wp_Versioning_Enabled(p_project_id) = 'N') AND */
1889: (l_versioned = 'N') AND NVL(PA_PROJECT_PUB.G_ROLLUP_DEFER, 'N') = 'N' AND -- Check roll up flag to defer roll ups 14556729
1890: (PA_PROJECT_STRUCTURE_UTILS.get_struc_type_for_structure(l_structure_id, 'WORKPLAN') = 'Y') THEN
1891: PA_STRUCT_TASK_ROLLUP_PUB.Task_Status_Rollup(
1892: p_structure_version_id => l_parent_struc_ver_id
5656: l_return_value VARCHAR2(1) := 'Y';
5657:
5658: BEGIN
5659: --Call Andrews API to check whether a workplan versioning is enabled or not.
5660: l_return_value := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED( p_project_id );
5661: RETURN ( NVL( l_return_value, 'N' ) );
5662:
5663: END IS_WP_VERSIONING_ENABLED;
5664:
6014: OPEN cur_pa_proj_elems;
6015: FETCH cur_pa_proj_elems INTO l_proj_element_id;
6016: CLOSE cur_pa_proj_elems;
6017:
6018: l_return_value := PA_WORKPLAN_ATTR_UTILS.CHECK_AUTO_DATE_SYNC_ENABLED( l_proj_element_id );
6019: RETURN l_return_value;
6020: END DATE_SYNC_UP_METHOD;
6021:
6022: PROCEDURE update_trans_dates(
9100:
9101: -- gboomina added for bug 9659119 - start
9102: -- Create workflow notification for published version during online project creation
9103: if (l_dest_status_code = 'STRUCTURE_PUBLISHED') then
9104: if PA_WORKPLAN_ATTR_UTILS.CHECK_AUTO_PUB_AT_CREATION(p_src_project_id) = 'Y' then
9105:
9106: OPEN get_record_version_number(p_dest_project_id, rec_dest_wp_struc_versions.element_version_id);
9107: FETCH get_record_version_number into l_record_version_number;
9108: CLOSE get_record_version_number;
10451:
10452: --Need To Sync Up Transaction Dates If Auto Sync Is On
10453: IF l_shared = 'Y' THEN
10454:
10455: IF (PA_WORKPLAN_ATTR_UTILS.CHECK_AUTO_DATE_SYNC_ENABLED(l_dest_shared_struc_id) = 'Y')
10456: AND (PA_WORKPLAN_ATTR_UTILS.CHECK_AUTO_PUB_AT_CREATION(p_src_project_id) = 'Y') THEN
10457: --Copy to transaction date
10458: PA_PROJECT_DATES_PUB.COPY_PROJECT_DATES(
10459: p_project_id => p_dest_project_id,
10452: --Need To Sync Up Transaction Dates If Auto Sync Is On
10453: IF l_shared = 'Y' THEN
10454:
10455: IF (PA_WORKPLAN_ATTR_UTILS.CHECK_AUTO_DATE_SYNC_ENABLED(l_dest_shared_struc_id) = 'Y')
10456: AND (PA_WORKPLAN_ATTR_UTILS.CHECK_AUTO_PUB_AT_CREATION(p_src_project_id) = 'Y') THEN
10457: --Copy to transaction date
10458: PA_PROJECT_DATES_PUB.COPY_PROJECT_DATES(
10459: p_project_id => p_dest_project_id,
10460: x_return_status => l_return_status,
13164: OPEN get_shared_struc_id;
13165: FETCH get_shared_struc_id into l_structure_id;
13166: CLOSE get_shared_struc_id;
13167:
13168: If (PA_WORKPLAN_ATTR_UTILS.CHECK_AUTO_DATE_SYNC_ENABLED(l_structure_id) = 'Y') AND (PA_WORKPLAN_ATTR_UTILS.CHECK_AUTO_PUB_AT_CREATION(p_src_project_id) = 'Y')THEN
13169:
13170: --Copy to transaction date
13171: PA_PROJECT_DATES_PUB.COPY_PROJECT_DATES(
13172: p_project_id => p_dest_project_id,
20356: OPEN get_struc_id(l_project_id, l_pub_ver_id);
20357: FETCH get_struc_id INTO l_proj_element_id;
20358: CLOSE get_struc_id;
20359:
20360: IF (PA_WORKPLAN_ATTR_UTILS.CHECK_AUTO_DATE_SYNC_ENABLED(l_proj_element_id) = 'Y') THEN
20361: --Copy to transaction date
20362: IF l_debug_mode = 'Y' THEN
20363: pa_debug.write(G_PKG_NAME, 'Calling COPY_PROJECT_DATES', 3);
20364: END IF;
20879: pa_debug.write(G_PKG_NAME, 'After RE_ROLLUP_PROGRESS x_return_status='|| x_return_status, 3);
20880: END IF;
20881:
20882: -- Bug 4575855 : Added call of ROLLUP_PROG_FROM_SUBPROJS
20883: IF PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(p_project_id) = 'N' THEN
20884: IF l_debug_mode = 'Y' THEN
20885: pa_debug.write(G_PKG_NAME, 'Calling ROLLUP_PROG_FROM_SUBPROJS', 3);
20886: END IF;
20887:
22226:
22227: --Current Phase name to id conversion
22228: IF ((p_current_lifecycle_phase_id <> FND_API.G_MISS_NUM) AND (p_current_lifecycle_phase_id is not NULL)) OR
22229: ((p_current_lifecycle_phase <> FND_API.G_MISS_CHAR) AND (p_current_lifecycle_phase is not NULL)) then
22230: PA_WORKPLAN_ATTR_UTILS.CHECK_LIFECYCLE_PHASE_NAME_ID
22231: ( p_lifecycle_id => l_life_cycle_version_id
22232: ,p_current_lifecycle_phase_id => p_current_lifecycle_phase_id
22233: ,p_current_lifecycle_phase => p_current_lifecycle_phase
22234: ,p_check_id_flag => 'Y'