DBA Data[Home] [Help]

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 4035: AND ((ppevs.CURRENT_FLAG = 'Y') OR ((ppevs.CURRENT_FLAG = 'N') AND (PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(cp_proj_id) = 'N') ) )

4031: AND ppe.project_id = cp_proj_id
4032: AND ppe.object_type = 'PA_STRUCTURES'
4033: AND ppev.element_version_id = ppevs.ELEMENT_VERSION_ID
4034: AND ppev.project_id = ppevs.project_id
4035: AND ((ppevs.CURRENT_FLAG = 'Y') OR ((ppevs.CURRENT_FLAG = 'N') AND (PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(cp_proj_id) = 'N') ) )
4036: --Added for the fix of 7658505
4037: AND pst.structure_type_id = ppst.structure_type_id
4038: AND ppst.proj_element_id = ppe.proj_element_id
4039: AND pst.structure_type_class_code = 'WORKPLAN';