eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_TASK_PVT1 dependencies on PA_PROJECT_STRUCTURE_UTILS

Line 1036: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(

1032: l_versioned := 'N';
1033: END IF;
1034: --end bug 3597226
1035:
1036: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(
1037: p_project_id);
1038:
1039: -- Modified for FP_M changes
1040: -- Tracking Bug 3305199

Line 1041: l_full_shared := PA_PROJECT_STRUCTURE_UTILS.get_Structure_Sharing_Code( p_project_id);

1037: p_project_id);
1038:
1039: -- Modified for FP_M changes
1040: -- Tracking Bug 3305199
1041: l_full_shared := PA_PROJECT_STRUCTURE_UTILS.get_Structure_Sharing_Code( p_project_id);
1042:
1043: /* IF (NVL( l_publised_version, 'N' ) = 'N' and l_full_shared = 'SHARE_FULL') OR
1044: (l_publised_version = 'Y' AND l_versioned = 'N' AND l_shared = 'Y' AND l_full_shared = 'SHARE_FULL') OR
1045: p_structure_type = 'FINANCIAL' -- Bug 3305199

Line 1273: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(

1269: IF cur_struc_type%FOUND
1270: THEN
1271: l_versioned := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(
1272: p_project_id);
1273: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(
1274: p_project_id);
1275:
1276: IF (NVL( l_publised_version, 'N' ) = 'N') OR
1277: (l_publised_version = 'Y' AND l_versioned = 'N' AND l_shared = 'Y') THEN

Line 1797: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(

1793: --moved from below to be used for bug 3010538 to improve performance.
1794: l_versioned := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(
1795: l_project_id);
1796: /* Commented the below statement and moved into the if condition for bug 3451073
1797: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(
1798: l_project_id); */
1799: /* Added the If conidtion for Bug 3451073 to improve performance*/
1800: IF p_shared = 'X'
1801: THEN

Line 1802: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(

1798: l_project_id); */
1799: /* Added the If conidtion for Bug 3451073 to improve performance*/
1800: IF p_shared = 'X'
1801: THEN
1802: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(
1803: l_project_id);
1804: ELSE
1805: l_shared := p_shared;
1806: END IF;

Line 1809: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Structure(v_cur_proj_elems_rec.PARENT_STRUCTURE_ID, 'WORKPLAN');

1805: l_shared := p_shared;
1806: END IF;
1807:
1808: --3035902: process update flag changes
1809: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Structure(v_cur_proj_elems_rec.PARENT_STRUCTURE_ID, 'WORKPLAN');
1810: --3035902: end process update flag changes
1811:
1812: --moving up for better performance by using the same code for bug 3010538
1813: -- Bug 2827063 Put the code to get structure id here instead of down.

Line 2763: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(

2759: --changes for versioning
2760: /* --moved for bug 3010538 for performance
2761: l_versioned := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(
2762: l_project_id);
2763: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(
2764: l_project_id);
2765: */ --moved for bug 3010538 for performance
2766:
2767: -- Modified for FP_M changes

Line 5139: l_structure_sharing_code := PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(l_Project_id); -- dthakker added

5135: from pa_proj_element_versions
5136: where element_version_id = p_task_version_id;
5137:
5138: -- 4201927 Retrieving structure sharding code once and using it for further processing
5139: l_structure_sharing_code := PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(l_Project_id); -- dthakker added
5140:
5141: -- 4201927 Commented below code as for PARTIALLY SHARED structure, Delete Button is not
5142: -- shown financial tab
5143:

Line 5147: PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(l_Project_id )= 'SHARE_PARTIAL'

5143:
5144: /*
5145: -- Tracking bug 3305199
5146: If p_Structure_Type = 'FINANCIAL' and
5147: PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(l_Project_id )= 'SHARE_PARTIAL'
5148: then
5149: PA_Tasks_Maint_Utils.Check_WorkPlan_Task_Exists (
5150: p_api_version => p_api_version
5151: , p_calling_module => p_calling_module

Line 5219: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(l_project_id);

5215: --bug 3301192
5216:
5217:
5218: l_wp_str_exists := PA_PROJ_TASK_STRUC_PUB.wp_str_exists(l_project_id);
5219: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(l_project_id);
5220: --bug 3301192
5221:
5222: --bug 4006401
5223:

Line 5257: l_structure_type_fin := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version( p_structure_version_id => p_structure_version_id

5253: --end bug 4006401
5254:
5255: -- 4201927 For performance fix :: retrieve below values once and using it for further processing
5256:
5257: l_structure_type_fin := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version( p_structure_version_id => p_structure_version_id
5258: ,p_structure_type => 'FINANCIAL' );
5259:
5260: l_structure_type_wp := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version( p_structure_version_id => p_structure_version_id
5261: ,p_structure_type => 'WORKPLAN' );

Line 5260: l_structure_type_wp := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version( p_structure_version_id => p_structure_version_id

5256:
5257: l_structure_type_fin := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version( p_structure_version_id => p_structure_version_id
5258: ,p_structure_type => 'FINANCIAL' );
5259:
5260: l_structure_type_wp := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version( p_structure_version_id => p_structure_version_id
5261: ,p_structure_type => 'WORKPLAN' );
5262:
5263: -- 4201927 end
5264:

Line 5267: --IF (PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version( p_structure_version_id => p_structure_version_id

5263: -- 4201927 end
5264:
5265: --added for bug 4006401
5266: -- 4201927 Using local values rather than calling api
5267: --IF (PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version( p_structure_version_id => p_structure_version_id
5268: -- ,p_structure_type => 'FINANCIAL' ) = 'Y') THEN -- 4201927 commented
5269: IF l_structure_type_fin = 'Y' THEN -- 4201927 added
5270: IF nvl(l_shared,'N') = 'N' THEN
5271: l_delete_flag := 'Y';

Line 5278: IF PA_PROJECT_STRUCTURE_UTILS.CHECK_PUBLISHED_VER_EXISTS(

5274: FROM pa_proj_element_versions
5275: WHERE element_version_id = p_structure_version_id
5276: AND project_id = l_project_id;
5277:
5278: IF PA_PROJECT_STRUCTURE_UTILS.CHECK_PUBLISHED_VER_EXISTS(
5279: p_project_id => l_project_id
5280: ,p_structure_id => l_structure_id ) = 'N'
5281: THEN
5282: l_delete_flag := 'Y';

Line 5285: --IF ( PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version( p_structure_version_id => p_structure_version_id

5281: THEN
5282: l_delete_flag := 'Y';
5283: ELSE
5284: -- 4201927 Using local values rather than calling api
5285: --IF ( PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version( p_structure_version_id => p_structure_version_id
5286: -- ,p_structure_type => 'WORKPLAN' ) = 'Y') THEN -- 4201927 commented
5287: IF l_structure_type_wp = 'Y' THEN -- 4201927 added
5288: IF PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(l_project_id) = 'N' THEN
5289: l_delete_flag := 'Y';

Line 5301: If PA_Project_Structure_Utils.Check_Third_Party_Sch_Flag(l_Project_ID) = 'Y' then

5297: -- Added for FP_M changes Bug 3305199 Bhumesh
5298: THEN
5299:
5300: -- Added for FP_M changes
5301: If PA_Project_Structure_Utils.Check_Third_Party_Sch_Flag(l_Project_ID) = 'Y' then
5302:
5303: PA_PROJECT_STRUCTURE_PVT1.update_sch_dirty_flag(
5304: p_structure_version_id => P_Structure_Version_ID
5305: ,p_dirty_flag => 'Y' --bug 3902282

Line 5467: -- (PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(x_project_id) = 'Y') ) THEN

5463:
5464: -- Added by skannoji
5465: -- Deleteing planning transactions for all given element version id
5466: -- IF ( (PA_PROJ_TASK_STRUC_PUB.wp_str_exists(x_project_id) = 'Y') OR
5467: -- (PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(x_project_id) = 'Y') ) THEN
5468: /*
5469: IF l_wp_str_exists = 'Y' OR
5470: l_shared = 'Y'
5471: THEN

Line 5507: IF ( PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(

5503: -- While deletion of task, the task mapping should be deleted
5504:
5505: -- 4201927 Commented below code , Using local derived values rather than calling api
5506: /*
5507: IF ( PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(
5508: p_structure_version_id => x_parent_struc_ver_id
5509: ,p_structure_type => 'WORKPLAN' ) = 'Y') AND
5510: (PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(x_project_id )= 'SPLIT_MAPPING')
5511: */

Line 5510: (PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(x_project_id )= 'SPLIT_MAPPING')

5506: /*
5507: IF ( PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(
5508: p_structure_version_id => x_parent_struc_ver_id
5509: ,p_structure_type => 'WORKPLAN' ) = 'Y') AND
5510: (PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(x_project_id )= 'SPLIT_MAPPING')
5511: */
5512: IF l_structure_type_wp = 'Y' AND l_structure_sharing_code = 'SPLIT_MAPPING'
5513: -- 4201927 end
5514: then

Line 5548: IF ( PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version( p_structure_version_id => x_parent_struc_ver_id

5544:
5545: /*
5546: IF cur_child_tasks%ROWCOUNT = 1
5547: THEN
5548: IF ( PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version( p_structure_version_id => x_parent_struc_ver_id
5549: ,p_structure_type => 'FINANCIAL' ) = 'Y')
5550: THEN
5551: --If structure has any published versions.
5552: -- IF ( PA_PROJECT_STRUCTURE_UTILS.Check_Struc_Ver_Published( p_project_id => x_project_id

Line 5552: -- IF ( PA_PROJECT_STRUCTURE_UTILS.Check_Struc_Ver_Published( p_project_id => x_project_id

5548: IF ( PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version( p_structure_version_id => x_parent_struc_ver_id
5549: ,p_structure_type => 'FINANCIAL' ) = 'Y')
5550: THEN
5551: --If structure has any published versions.
5552: -- IF ( PA_PROJECT_STRUCTURE_UTILS.Check_Struc_Ver_Published( p_project_id => x_project_id
5553: -- ,p_structure_version_id => x_parent_struc_ver_id ) = 'N' )
5554: --THEN
5555:
5556: -- Bug#3834117

Line 5569: IF PA_PROJECT_STRUCTURE_UTILS.CHECK_PUBLISHED_VER_EXISTS(

5565: FROM pa_proj_element_versions
5566: WHERE element_version_id = x_parent_struc_ver_id
5567: AND project_id = x_project_id;
5568:
5569: IF PA_PROJECT_STRUCTURE_UTILS.CHECK_PUBLISHED_VER_EXISTS(
5570: p_project_id => x_project_id
5571: ,p_structure_id => l_structure_id ) = 'N'
5572: THEN
5573: l_delete_flag := 'Y';

Line 5575: IF ( PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version( p_structure_version_id => x_parent_struc_ver_id

5571: ,p_structure_id => l_structure_id ) = 'N'
5572: THEN
5573: l_delete_flag := 'Y';
5574: ELSE
5575: IF ( PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version( p_structure_version_id => x_parent_struc_ver_id
5576: ,p_structure_type => 'WORKPLAN' ) = 'Y') THEN
5577: IF PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(x_project_id) = 'N' THEN
5578: l_delete_flag := 'Y';
5579: END IF;

Line 5594: If PA_Project_Structure_Utils.Check_Third_Party_Sch_Flag(x_Project_ID) = 'Y' then

5590: -- Added for FP_M changes Bug 3305199 Bhumesh
5591: THEN
5592:
5593: -- Added for FP_M changes
5594: If PA_Project_Structure_Utils.Check_Third_Party_Sch_Flag(x_Project_ID) = 'Y' then
5595:
5596: PA_PROJECT_STRUCTURE_PVT1.update_sch_dirty_flag(
5597: p_structure_version_id => P_Structure_Version_ID
5598: ,p_dirty_flag => 'Y' --bug 3902282

Line 5870: If (PA_PROJECT_STRUCTURE_UTILS.check_Deliverable_enabled(x_project_id) = 'Y' ) THEN

5866: --dbms_output.put_line( 'Task Id '||l_proj_element_id );
5867:
5868: -- Added by skannoji
5869: -- Deleting deliverable task
5870: If (PA_PROJECT_STRUCTURE_UTILS.check_Deliverable_enabled(x_project_id) = 'Y' ) THEN
5871: PA_DELIVERABLE_PUB.delete_dlv_task_asscn_in_bulk(
5872: p_task_element_id => l_proj_element_id
5873: ,p_project_id => x_project_id
5874: ,p_task_version_id => cur_child_tasks_rec.object_id_to1

Line 6053: --IF PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(x_parent_struc_ver_id, 'WORKPLAN') = 'Y' then -- 4201927 commented

6049:
6050: --hsiu added, for dates rollup
6051: IF (l_peer_tasks_exist = 'Y') THEN
6052: -- 4201927 Using local variable rather than calling api again
6053: --IF PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(x_parent_struc_ver_id, 'WORKPLAN') = 'Y' then -- 4201927 commented
6054:
6055: IF l_structure_type_wp = 'Y' then -- 4201927 Added
6056: PA_STRUCT_TASK_ROLLUP_PUB.Tasks_Rollup(
6057: p_commit => FND_API.G_FALSE,

Line 6198: --IF PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(

6194: --end task weighting changes
6195:
6196: --bug 3010538 (delete )
6197:
6198: --IF PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(
6199: -- x_parent_struc_ver_id, 'WORKPLAN') = 'Y' then --bug 3051413
6200:
6201: --bug 3053281 --set flag if not (Workplan and Effort)
6202: --l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(x_project_id);

Line 6202: --l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(x_project_id);

6198: --IF PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(
6199: -- x_parent_struc_ver_id, 'WORKPLAN') = 'Y' then --bug 3051413
6200:
6201: --bug 3053281 --set flag if not (Workplan and Effort)
6202: --l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(x_project_id);
6203: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(x_parent_struc_ver_id, 'WORKPLAN');
6204: l_weighting_basis_Code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(x_project_id);
6205: --3035902: process update flag changes
6206: --Bug No 3450684 SMukka Commented if condition

Line 6203: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(x_parent_struc_ver_id, 'WORKPLAN');

6199: -- x_parent_struc_ver_id, 'WORKPLAN') = 'Y' then --bug 3051413
6200:
6201: --bug 3053281 --set flag if not (Workplan and Effort)
6202: --l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(x_project_id);
6203: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(x_parent_struc_ver_id, 'WORKPLAN');
6204: l_weighting_basis_Code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(x_project_id);
6205: --3035902: process update flag changes
6206: --Bug No 3450684 SMukka Commented if condition
6207: --IF ((l_wp_type = 'Y') AND

Line 6991: If PA_Project_Structure_Utils.Check_Third_Party_Sch_Flag(l_Project_ID)= 'Y' Then

6987: END IF;
6988: --end bug 3305199
6989:
6990: -- Added for FP_M changes 3305199 Bhumesh
6991: If PA_Project_Structure_Utils.Check_Third_Party_Sch_Flag(l_Project_ID)= 'Y' Then
6992:
6993: Select Parent_Structure_Version_ID INTO l_Structure_Version_ID
6994: From PA_Proj_Element_Versions
6995: Where Element_Version_ID = P_Element_Version_ID;

Line 8091: If PA_Project_Structure_Utils.Check_Third_Party_Sch_Flag(l_Project_ID)= 'Y' Then

8087: END IF;
8088: --end bug 3035902
8089:
8090: -- Added for FP_M changes 3305199 Bhumesh
8091: If PA_Project_Structure_Utils.Check_Third_Party_Sch_Flag(l_Project_ID)= 'Y' Then
8092:
8093: PA_PROJECT_STRUCTURE_PVT1.update_sch_dirty_flag(
8094: p_structure_version_id => l_Structure_Version_ID
8095: ,p_dirty_flag => 'Y' --bug 3902282

Line 8193: IF ('Y' = PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(l_parent_struc_ver_id,'WORKPLAN') ) AND

8189: OPEN get_parent_struc_Ver_id(cur_proj_elem_ver_sch_rec.element_version_id);
8190: FETCH get_parent_struc_Ver_id INTO l_parent_struc_Ver_id;
8191: CLOSE get_parent_struc_ver_id;
8192:
8193: IF ('Y' = PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(l_parent_struc_ver_id,'WORKPLAN') ) AND
8194: ('Y' = l_schedule_update_flag ) THEN
8195:
8196: --bug 4153366
8197: IF (p_calling_module = 'AMG')

Line 9089: IF ( (PA_PROJ_TASK_STRUC_PUB.wp_str_exists(x_project_id) = 'Y') OR (PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(x_project_id) = 'Y') ) THEN

9085: CLOSE cur_sch_ver;
9086:
9087: -- Added by skannoji
9088: -- Deleteing planning transactions for all given element version id
9089: IF ( (PA_PROJ_TASK_STRUC_PUB.wp_str_exists(x_project_id) = 'Y') OR (PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(x_project_id) = 'Y') ) THEN
9090: l_element_version_id_tbl.extend(1); /* Venky */
9091: l_element_version_id_tbl(1) := cur_child_tasks_rec.object_id_to1;
9092:
9093: /* 4317547 : The fix 4172646 has caused DHI bug 4317547

Line 9135: IF ( PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(

9131: --END IF;
9132:
9133: -- Added by skannoji
9134: -- While deletion of task, the task mapping should be deleted
9135: IF ( PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(
9136: p_structure_version_id => x_parent_struc_ver_id
9137: ,p_structure_type => 'WORKPLAN' ) = 'Y') AND
9138: (PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(x_project_id )= 'SPLIT_MAPPING')
9139: then

Line 9138: (PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(x_project_id )= 'SPLIT_MAPPING')

9134: -- While deletion of task, the task mapping should be deleted
9135: IF ( PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(
9136: p_structure_version_id => x_parent_struc_ver_id
9137: ,p_structure_type => 'WORKPLAN' ) = 'Y') AND
9138: (PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(x_project_id )= 'SPLIT_MAPPING')
9139: then
9140: --Get fp task version id to delete mapping.
9141: OPEN cur_fp_tsk_ver_id( cur_child_tasks_rec.object_id_to1 );
9142: FETCH cur_fp_tsk_ver_id INTO l_fp_task_version_id;

Line 9165: IF ( PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(

9161: --Do financial task check
9162: --If financial
9163:
9164: IF cur_child_tasks%ROWCOUNT = 1 THEN
9165: IF ( PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(
9166: p_structure_version_id => x_parent_struc_ver_id
9167: ,p_structure_type => 'FINANCIAL' ) = 'Y') THEN
9168:
9169: SELECT proj_element_id INTO l_structure_id

Line 9174: IF (PA_PROJECT_STRUCTURE_UTILS.CHECK_PUBLISHED_VER_EXISTS(

9170: FROM pa_proj_element_versions
9171: WHERE element_version_id = x_parent_struc_ver_id
9172: AND project_id = x_project_id;
9173:
9174: IF (PA_PROJECT_STRUCTURE_UTILS.CHECK_PUBLISHED_VER_EXISTS(
9175: p_project_id => x_project_id
9176: ,p_structure_id => l_structure_id ) = 'N') OR
9177: (PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(
9178: x_project_id) = 'N') THEN

Line 9397: If (PA_PROJECT_STRUCTURE_UTILS.check_Deliverable_enabled(x_project_id) = 'Y' ) THEN

9393: CLOSE cur_proj_elems;
9394:
9395: -- Added by skannoji
9396: -- Deleting deliverable task
9397: If (PA_PROJECT_STRUCTURE_UTILS.check_Deliverable_enabled(x_project_id) = 'Y' ) THEN
9398: PA_DELIVERABLE_PUB.delete_dlv_task_asscn_in_bulk(
9399: p_task_element_id => l_proj_element_id
9400: ,p_project_id => x_project_id
9401: ,p_task_version_id => cur_child_tasks_rec.object_id_to1

Line 9526: IF PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(x_parent_struc_ver_id, 'WORKPLAN') = 'Y' then

9522: END;
9523:
9524: --hsiu added, for dates rollup
9525: IF (l_peer_tasks_exist = 'Y') THEN
9526: IF PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(x_parent_struc_ver_id, 'WORKPLAN') = 'Y' then
9527: PA_STRUCT_TASK_ROLLUP_PUB.Tasks_Rollup(
9528: p_commit => FND_API.G_FALSE,
9529: p_element_versions => l_tasks_ver_ids,
9530: x_return_status => l_return_status,

Line 9616: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(x_parent_struc_ver_id, 'WORKPLAN');

9612: END IF;
9613: --end task weighting changes
9614:
9615: --3035902: process update flag changes
9616: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(x_parent_struc_ver_id, 'WORKPLAN');
9617: l_weighting_basis_Code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(x_project_id);
9618: --Bug No 3450684 SMukka Commented if condition
9619: --IF ((l_wp_type = 'Y') AND
9620: -- (l_weighting_basis_Code = 'EFFORT') AND