APPS.PA_PROJECT_STRUCTURE_UTILS dependencies on PA_WORKPLAN_ATTR_UTILS

Line 2522: l_versioned := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(

2518: BEGIN
2519: l_published := PA_PROJECT_STRUCTURE_UTILS.Check_Struc_Ver_Published(
2520: p_project_id,
2521: p_structure_version_id);
2522: l_versioned := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(
2523: p_project_id);
2524: IF (l_published = 'Y' and l_versioned = 'Y') THEN
2525: return 'N';
2526: ELSE

Line 2558: l_versioned := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(

2554: BEGIN
2555: l_published := PA_PROJECT_STRUCTURE_UTILS.Check_Struc_Ver_Published(
2556: p_project_id,
2557: p_structure_version_id);
2558: l_versioned := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(
2559: p_project_id);
2560:
2561: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(
2562: p_project_id);

Line 3176: IF (PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(l_project_id) = 'Y')

3172: --check if shared or split
3173: IF (PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(l_project_id) = 'Y')
3174: THEN
3175: --shared; check structure version status
3176: IF (PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(l_project_id) = 'Y')
3177: THEN
3178: --versioning enabled. Check structure version status
3179: OPEN c2;
3180: FETCH c2 into l_dummy;

Line 3214: IF (PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(l_project_id) = 'Y')

3210: --split financial; ok to edit
3211: return 'Y';
3212: ELSE
3213: --split workplan; check versioning
3214: IF (PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(l_project_id) = 'Y')
3215: THEN
3216: --versioning enabled. Check structure version status
3217: OPEN c2;
3218: FETCH c2 into l_dummy;

Line 3478: IF (PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(p_project_id) = 'Y') THEN

3474: ELSE
3475: --Workplan enabled; check if it is shared of split
3476: IF (PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(p_project_id) = 'Y') THEN
3477: --this is a shared project; check if versioning is enabled
3478: IF (PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(p_project_id) = 'Y') THEN
3479: --get latest published, if published exist
3480: l_struc_ver_id := PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_FIN_STRUC_VER_ID(p_project_id);
3481: IF l_struc_ver_id IS NULL THEN
3482: --get working version, which is the only version

Line 3813: l_versioned := PA_WORKPLAN_ATTR_UTILS.Check_Wp_Versioning_Enabled(p_project_id);

3809:
3810: l_versioned VARCHAR2(1) ;
3811:
3812: BEGIN
3813: l_versioned := PA_WORKPLAN_ATTR_UTILS.Check_Wp_Versioning_Enabled(p_project_id);
3814:
3815: IF nvl(l_versioned,'N') = 'Y' then
3816: --Version Enabled Find CWV
3817:

Line 4060: AND ((ppevs.CURRENT_FLAG = 'Y') OR ((ppevs.CURRENT_FLAG = 'N') AND (PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(cp_proj_id) = 'N') ) )

4056: AND ppe.project_id = cp_proj_id
4057: AND ppe.object_type = 'PA_STRUCTURES'
4058: AND ppev.element_version_id = ppevs.ELEMENT_VERSION_ID
4059: AND ppev.project_id = ppevs.project_id
4060: AND ((ppevs.CURRENT_FLAG = 'Y') OR ((ppevs.CURRENT_FLAG = 'N') AND (PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(cp_proj_id) = 'N') ) )
4061: --Added for the fix of 7658505
4062: AND pst.structure_type_id = ppst.structure_type_id
4063: AND ppst.proj_element_id = ppe.proj_element_id
4064: AND pst.structure_type_class_code = 'WORKPLAN';

Line 5321: IF (PA_WORKPLAN_ATTR_UTILS.CHECK_AUTO_DATE_SYNC_ENABLED(l_structure_id) = 'N') THEN

5317: OPEN get_structure_id;
5318: FETCH get_structure_id INTO l_structure_id;
5319: CLOSE get_structure_id;
5320:
5321: IF (PA_WORKPLAN_ATTR_UTILS.CHECK_AUTO_DATE_SYNC_ENABLED(l_structure_id) = 'N') THEN
5322: RETURN;
5323: END IF;
5324:
5325: OPEN get_buffer(l_structure_id);