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 937: PA_PROJECT_STRUCTURE_UTILS.get_Structure_Sharing_Code(p_project_id) = 'SHARE_FULL' then

933: -- 11928067: bypassing the validation done in bug#9724427 if it for linking a project to a program
934: IF (p_context = 'TASK') THEN
935: if p_ref_task_id is not null and
936: p_ref_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM and
937: PA_PROJECT_STRUCTURE_UTILS.get_Structure_Sharing_Code(p_project_id) = 'SHARE_FULL' then
938: -- 12700283: added if-else condition to check workplan versioning is enabled or not.
939: -- If versioning is not enabled, then used existing PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION(p_project_id)
940: -- function to get parent_structure_version_id for this project.
941: l_version_enabled_flag := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(p_project_id);

Line 939: -- If versioning is not enabled, then used existing PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION(p_project_id)

935: if p_ref_task_id is not null and
936: p_ref_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM and
937: PA_PROJECT_STRUCTURE_UTILS.get_Structure_Sharing_Code(p_project_id) = 'SHARE_FULL' then
938: -- 12700283: added if-else condition to check workplan versioning is enabled or not.
939: -- If versioning is not enabled, then used existing PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION(p_project_id)
940: -- function to get parent_structure_version_id for this project.
941: l_version_enabled_flag := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(p_project_id);
942: --13551360: A template will not have a published version. So for template, control always goes to else part
943: open cur_proj_tmp;

Line 952: PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION(p_project_id);

948: into l_ref_parent_task_ver_id
949: from pa_proj_element_versions
950: where proj_element_id = p_ref_task_id
951: and parent_structure_version_id =
952: PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION(p_project_id);
953: else
954: select element_version_id
955: into l_ref_parent_task_ver_id
956: from pa_proj_element_versions

Line 959: PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(p_project_id);

955: into l_ref_parent_task_ver_id
956: from pa_proj_element_versions
957: where proj_element_id = p_ref_task_id
958: and parent_structure_version_id =
959: PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(p_project_id);
960: end if;
961: -- 12700283: added if-else condition to check workplan versioning is enabled or not.. end.
962: -- 13102269: bypassing all validations of Check_create_subtask_ok API for peer task.
963: IF p_peer_or_sub = 'SUB' then

Line 1144: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(

1140: l_versioned := 'N';
1141: END IF;
1142: --end bug 3597226
1143:
1144: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(
1145: p_project_id);
1146:
1147: -- Modified for FP_M changes
1148: -- Tracking Bug 3305199

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

1145: p_project_id);
1146:
1147: -- Modified for FP_M changes
1148: -- Tracking Bug 3305199
1149: l_full_shared := PA_PROJECT_STRUCTURE_UTILS.get_Structure_Sharing_Code( p_project_id);
1150:
1151: /* IF (NVL( l_publised_version, 'N' ) = 'N' and l_full_shared = 'SHARE_FULL') OR
1152: (l_publised_version = 'Y' AND l_versioned = 'N' AND l_shared = 'Y' AND l_full_shared = 'SHARE_FULL') OR
1153: p_structure_type = 'FINANCIAL' -- Bug 3305199

Line 1381: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(

1377: IF cur_struc_type%FOUND
1378: THEN
1379: l_versioned := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(
1380: p_project_id);
1381: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(
1382: p_project_id);
1383:
1384: IF (NVL( l_publised_version, 'N' ) = 'N') OR
1385: (l_publised_version = 'Y' AND l_versioned = 'N' AND l_shared = 'Y') THEN

Line 1916: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(

1912: --moved from below to be used for bug 3010538 to improve performance.
1913: l_versioned := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(
1914: l_project_id);
1915: /* Commented the below statement and moved into the if condition for bug 3451073
1916: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(
1917: l_project_id); */
1918: /* Added the If conidtion for Bug 3451073 to improve performance*/
1919: IF p_shared = 'X'
1920: THEN

Line 1921: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(

1917: l_project_id); */
1918: /* Added the If conidtion for Bug 3451073 to improve performance*/
1919: IF p_shared = 'X'
1920: THEN
1921: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(
1922: l_project_id);
1923: ELSE
1924: l_shared := p_shared;
1925: END IF;

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

1924: l_shared := p_shared;
1925: END IF;
1926:
1927: --3035902: process update flag changes
1928: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Structure(v_cur_proj_elems_rec.PARENT_STRUCTURE_ID, 'WORKPLAN');
1929: --3035902: end process update flag changes
1930:
1931: --moving up for better performance by using the same code for bug 3010538
1932: -- Bug 2827063 Put the code to get structure id here instead of down.

Line 2912: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(

2908: --changes for versioning
2909: /* --moved for bug 3010538 for performance
2910: l_versioned := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(
2911: l_project_id);
2912: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(
2913: l_project_id);
2914: */ --moved for bug 3010538 for performance
2915:
2916: -- Modified for FP_M changes

Line 4202: l_Share_Code := PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(L_PROJECT_ID);

4198: BEGIN
4199:
4200: -- 14556729:Huawei code change :get the Sharing code and process below code only if its fully shared
4201: SELECT PROJECT_ID INTO L_PROJECT_ID FROM pa_proj_element_versions WHERE element_version_id = p_task_version_id ;
4202: l_Share_Code := PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(L_PROJECT_ID);
4203: IF (l_Share_Code='SHARE_FULL') THEN
4204: if ( p_action = 'MOVE' ) then
4205: select project_id, wbs_level,display_sequence
4206: into l2_project_id , l2_ref_task_wbs_level, l2_ref_task_display_seq

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

5637: from pa_proj_element_versions
5638: where element_version_id = p_task_version_id;
5639:
5640: -- 4201927 Retrieving structure sharding code once and using it for further processing
5641: l_structure_sharing_code := PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(l_Project_id); -- dthakker added
5642:
5643: -- 4201927 Commented below code as for PARTIALLY SHARED structure, Delete Button is not
5644: -- shown financial tab
5645:

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

5645:
5646: /*
5647: -- Tracking bug 3305199
5648: If p_Structure_Type = 'FINANCIAL' and
5649: PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(l_Project_id )= 'SHARE_PARTIAL'
5650: then
5651: PA_Tasks_Maint_Utils.Check_WorkPlan_Task_Exists (
5652: p_api_version => p_api_version
5653: , p_calling_module => p_calling_module

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

5717: --bug 3301192
5718:
5719:
5720: l_wp_str_exists := PA_PROJ_TASK_STRUC_PUB.wp_str_exists(l_project_id);
5721: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(l_project_id);
5722: --bug 3301192
5723:
5724: --bug 4006401
5725:

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

5761: --end bug 4006401
5762:
5763: -- 4201927 For performance fix :: retrieve below values once and using it for further processing
5764:
5765: l_structure_type_fin := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version( p_structure_version_id => p_structure_version_id
5766: ,p_structure_type => 'FINANCIAL' );
5767:
5768: l_structure_type_wp := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version( p_structure_version_id => p_structure_version_id
5769: ,p_structure_type => 'WORKPLAN' );

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

5764:
5765: l_structure_type_fin := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version( p_structure_version_id => p_structure_version_id
5766: ,p_structure_type => 'FINANCIAL' );
5767:
5768: l_structure_type_wp := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version( p_structure_version_id => p_structure_version_id
5769: ,p_structure_type => 'WORKPLAN' );
5770:
5771: -- 4201927 end
5772:

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

5771: -- 4201927 end
5772:
5773: --added for bug 4006401
5774: -- 4201927 Using local values rather than calling api
5775: --IF (PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version( p_structure_version_id => p_structure_version_id
5776: -- ,p_structure_type => 'FINANCIAL' ) = 'Y') THEN -- 4201927 commented
5777: IF l_structure_type_fin = 'Y' THEN -- 4201927 added
5778: IF nvl(l_shared,'N') = 'N' THEN
5779: l_delete_flag := 'Y';

Line 5786: IF PA_PROJECT_STRUCTURE_UTILS.CHECK_PUBLISHED_VER_EXISTS(

5782: FROM pa_proj_element_versions
5783: WHERE element_version_id = p_structure_version_id
5784: AND project_id = l_project_id;
5785:
5786: IF PA_PROJECT_STRUCTURE_UTILS.CHECK_PUBLISHED_VER_EXISTS(
5787: p_project_id => l_project_id
5788: ,p_structure_id => l_structure_id ) = 'N'
5789: THEN
5790: l_delete_flag := 'Y';

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

5789: THEN
5790: l_delete_flag := 'Y';
5791: ELSE
5792: -- 4201927 Using local values rather than calling api
5793: --IF ( PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version( p_structure_version_id => p_structure_version_id
5794: -- ,p_structure_type => 'WORKPLAN' ) = 'Y') THEN -- 4201927 commented
5795: IF l_structure_type_wp = 'Y' THEN -- 4201927 added
5796: IF PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(l_project_id) = 'N' THEN
5797: l_delete_flag := 'Y';

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

5805: -- Added for FP_M changes Bug 3305199 Bhumesh
5806: THEN
5807:
5808: -- Added for FP_M changes
5809: If PA_Project_Structure_Utils.Check_Third_Party_Sch_Flag(l_Project_ID) = 'Y' then
5810:
5811: PA_PROJECT_STRUCTURE_PVT1.update_sch_dirty_flag(
5812: p_structure_version_id => P_Structure_Version_ID
5813: ,p_dirty_flag => 'Y' --bug 3902282

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

5971:
5972: -- Added by skannoji
5973: -- Deleteing planning transactions for all given element version id
5974: -- IF ( (PA_PROJ_TASK_STRUC_PUB.wp_str_exists(x_project_id) = 'Y') OR
5975: -- (PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(x_project_id) = 'Y') ) THEN
5976: /*
5977: IF l_wp_str_exists = 'Y' OR
5978: l_shared = 'Y'
5979: THEN

Line 6015: IF ( PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(

6011: -- While deletion of task, the task mapping should be deleted
6012:
6013: -- 4201927 Commented below code , Using local derived values rather than calling api
6014: /*
6015: IF ( PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(
6016: p_structure_version_id => x_parent_struc_ver_id
6017: ,p_structure_type => 'WORKPLAN' ) = 'Y') AND
6018: (PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(x_project_id )= 'SPLIT_MAPPING')
6019: */

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

6014: /*
6015: IF ( PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(
6016: p_structure_version_id => x_parent_struc_ver_id
6017: ,p_structure_type => 'WORKPLAN' ) = 'Y') AND
6018: (PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(x_project_id )= 'SPLIT_MAPPING')
6019: */
6020: IF l_structure_type_wp = 'Y' AND l_structure_sharing_code = 'SPLIT_MAPPING'
6021: -- 4201927 end
6022: then

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

6052:
6053: /*
6054: IF cur_child_tasks%ROWCOUNT = 1
6055: THEN
6056: IF ( PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version( p_structure_version_id => x_parent_struc_ver_id
6057: ,p_structure_type => 'FINANCIAL' ) = 'Y')
6058: THEN
6059: --If structure has any published versions.
6060: -- IF ( PA_PROJECT_STRUCTURE_UTILS.Check_Struc_Ver_Published( p_project_id => x_project_id

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

6056: IF ( PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version( p_structure_version_id => x_parent_struc_ver_id
6057: ,p_structure_type => 'FINANCIAL' ) = 'Y')
6058: THEN
6059: --If structure has any published versions.
6060: -- IF ( PA_PROJECT_STRUCTURE_UTILS.Check_Struc_Ver_Published( p_project_id => x_project_id
6061: -- ,p_structure_version_id => x_parent_struc_ver_id ) = 'N' )
6062: --THEN
6063:
6064: -- Bug#3834117

Line 6077: IF PA_PROJECT_STRUCTURE_UTILS.CHECK_PUBLISHED_VER_EXISTS(

6073: FROM pa_proj_element_versions
6074: WHERE element_version_id = x_parent_struc_ver_id
6075: AND project_id = x_project_id;
6076:
6077: IF PA_PROJECT_STRUCTURE_UTILS.CHECK_PUBLISHED_VER_EXISTS(
6078: p_project_id => x_project_id
6079: ,p_structure_id => l_structure_id ) = 'N'
6080: THEN
6081: l_delete_flag := 'Y';

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

6079: ,p_structure_id => l_structure_id ) = 'N'
6080: THEN
6081: l_delete_flag := 'Y';
6082: ELSE
6083: IF ( PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version( p_structure_version_id => x_parent_struc_ver_id
6084: ,p_structure_type => 'WORKPLAN' ) = 'Y') THEN
6085: IF PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(x_project_id) = 'N' THEN
6086: l_delete_flag := 'Y';
6087: END IF;

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

6098: -- Added for FP_M changes Bug 3305199 Bhumesh
6099: THEN
6100:
6101: -- Added for FP_M changes
6102: If PA_Project_Structure_Utils.Check_Third_Party_Sch_Flag(x_Project_ID) = 'Y' then
6103:
6104: PA_PROJECT_STRUCTURE_PVT1.update_sch_dirty_flag(
6105: p_structure_version_id => P_Structure_Version_ID
6106: ,p_dirty_flag => 'Y' --bug 3902282

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

6380: --dbms_output.put_line( 'Task Id '||l_proj_element_id );
6381:
6382: -- Added by skannoji
6383: -- Deleting deliverable task
6384: If (PA_PROJECT_STRUCTURE_UTILS.check_Deliverable_enabled(x_project_id) = 'Y' ) THEN
6385: PA_DELIVERABLE_PUB.delete_dlv_task_asscn_in_bulk(
6386: p_task_element_id => l_proj_element_id
6387: ,p_project_id => x_project_id
6388: ,p_task_version_id => cur_child_tasks_rec.object_id_to1

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

6626: END IF; -- End of changes for bug 13923366
6627: --hsiu added, for dates rollup
6628: IF (l_peer_tasks_exist = 'Y') THEN
6629: -- 4201927 Using local variable rather than calling api again
6630: --IF PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(x_parent_struc_ver_id, 'WORKPLAN') = 'Y' then -- 4201927 commented
6631:
6632: IF l_structure_type_wp = 'Y' then -- 4201927 Added
6633: -- 14556729:Huawei Code change to defer the roll up API when G_ROLLUP_DEFER is set to Y , so that all the roll up is processed once at the end .
6634: IF NVL(PA_PROJECT_PUB.G_ROLLUP_DEFER,'N') = 'N'

Line 6801: --IF PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(

6797: --end task weighting changes
6798:
6799: --bug 3010538 (delete )
6800:
6801: --IF PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(
6802: -- x_parent_struc_ver_id, 'WORKPLAN') = 'Y' then --bug 3051413
6803:
6804: --bug 3053281 --set flag if not (Workplan and Effort)
6805: --l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(x_project_id);

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

6801: --IF PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(
6802: -- x_parent_struc_ver_id, 'WORKPLAN') = 'Y' then --bug 3051413
6803:
6804: --bug 3053281 --set flag if not (Workplan and Effort)
6805: --l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(x_project_id);
6806: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(x_parent_struc_ver_id, 'WORKPLAN');
6807: l_weighting_basis_Code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(x_project_id);
6808: --3035902: process update flag changes
6809: --Bug No 3450684 SMukka Commented if condition

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

6802: -- x_parent_struc_ver_id, 'WORKPLAN') = 'Y' then --bug 3051413
6803:
6804: --bug 3053281 --set flag if not (Workplan and Effort)
6805: --l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(x_project_id);
6806: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(x_parent_struc_ver_id, 'WORKPLAN');
6807: l_weighting_basis_Code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(x_project_id);
6808: --3035902: process update flag changes
6809: --Bug No 3450684 SMukka Commented if condition
6810: --IF ((l_wp_type = 'Y') AND

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

7590: END IF;
7591: --end bug 3305199
7592:
7593: -- Added for FP_M changes 3305199 Bhumesh
7594: If PA_Project_Structure_Utils.Check_Third_Party_Sch_Flag(l_Project_ID)= 'Y' Then
7595:
7596: Select Parent_Structure_Version_ID INTO l_Structure_Version_ID
7597: From PA_Proj_Element_Versions
7598: Where Element_Version_ID = P_Element_Version_ID;

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

8715: END IF;
8716: --end bug 3035902
8717:
8718: -- Added for FP_M changes 3305199 Bhumesh
8719: If PA_Project_Structure_Utils.Check_Third_Party_Sch_Flag(l_Project_ID)= 'Y' Then
8720:
8721: PA_PROJECT_STRUCTURE_PVT1.update_sch_dirty_flag(
8722: p_structure_version_id => l_Structure_Version_ID
8723: ,p_dirty_flag => 'Y' --bug 3902282

Line 8763: IF (PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(cur_proj_elem_ver_sch_rec.project_id) IN ('SHARE_FULL','SHARE_PARTIAL'))

8759: -- if the 'Automatically Update Task Transaction Dates' flag is checked.
8760: -- As of now these checks are done only for Fully Shared and Partially Shared Structure Projects
8761: -- Later this needs to be implemented for Splt Mapping also by mapping the corresponding Financial Taks
8762:
8763: IF (PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(cur_proj_elem_ver_sch_rec.project_id) IN ('SHARE_FULL','SHARE_PARTIAL'))
8764: THEN
8765:
8766: SELECT financial_task_flag into l_financial_task_flag_tmp
8767: FROM pa_proj_element_versions

Line 8784: WHERE element_version_id = PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(cur_proj_elem_ver_sch_rec.project_id);

8780: IF nvl(l_workplan_version_enable_flag,'N') = 'Y' THEN
8781:
8782: SELECT proj_element_id into l_proj_element_id_temp
8783: FROM pa_proj_element_versions
8784: WHERE element_version_id = PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(cur_proj_elem_ver_sch_rec.project_id);
8785: ELSE
8786: -- Added the code below for Huawei enhancement - bug 13923366
8787: -- Caching structure element ID
8788: IF PA_PROJECT_PUB.G_MASS_UPDATE_TASKS = 'Y' THEN

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

8935: OPEN get_parent_struc_Ver_id(cur_proj_elem_ver_sch_rec.element_version_id);
8936: FETCH get_parent_struc_Ver_id INTO l_parent_struc_Ver_id;
8937: CLOSE get_parent_struc_ver_id;
8938:
8939: IF ('Y' = PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(l_parent_struc_ver_id,'WORKPLAN') ) AND
8940: ('Y' = l_schedule_update_flag ) THEN
8941:
8942: --bug 4153366
8943: IF (p_calling_module = 'AMG')

Line 9837: 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

9833: CLOSE cur_sch_ver;
9834:
9835: -- Added by skannoji
9836: -- Deleteing planning transactions for all given element version id
9837: 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
9838: l_element_version_id_tbl.extend(1); /* Venky */
9839: l_element_version_id_tbl(1) := cur_child_tasks_rec.object_id_to1;
9840:
9841: /* 4317547 : The fix 4172646 has caused DHI bug 4317547

Line 9883: IF ( PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(

9879: --END IF;
9880:
9881: -- Added by skannoji
9882: -- While deletion of task, the task mapping should be deleted
9883: IF ( PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(
9884: p_structure_version_id => x_parent_struc_ver_id
9885: ,p_structure_type => 'WORKPLAN' ) = 'Y') AND
9886: (PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(x_project_id )= 'SPLIT_MAPPING')
9887: then

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

9882: -- While deletion of task, the task mapping should be deleted
9883: IF ( PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(
9884: p_structure_version_id => x_parent_struc_ver_id
9885: ,p_structure_type => 'WORKPLAN' ) = 'Y') AND
9886: (PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(x_project_id )= 'SPLIT_MAPPING')
9887: then
9888: --Get fp task version id to delete mapping.
9889: OPEN cur_fp_tsk_ver_id( cur_child_tasks_rec.object_id_to1 );
9890: FETCH cur_fp_tsk_ver_id INTO l_fp_task_version_id;

Line 9913: IF ( PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(

9909: --Do financial task check
9910: --If financial
9911:
9912: IF cur_child_tasks%ROWCOUNT = 1 THEN
9913: IF ( PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(
9914: p_structure_version_id => x_parent_struc_ver_id
9915: ,p_structure_type => 'FINANCIAL' ) = 'Y') THEN
9916:
9917: SELECT proj_element_id INTO l_structure_id

Line 9922: IF (PA_PROJECT_STRUCTURE_UTILS.CHECK_PUBLISHED_VER_EXISTS(

9918: FROM pa_proj_element_versions
9919: WHERE element_version_id = x_parent_struc_ver_id
9920: AND project_id = x_project_id;
9921:
9922: IF (PA_PROJECT_STRUCTURE_UTILS.CHECK_PUBLISHED_VER_EXISTS(
9923: p_project_id => x_project_id
9924: ,p_structure_id => l_structure_id ) = 'N') OR
9925: (PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(
9926: x_project_id) = 'N') THEN

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

10150: CLOSE cur_proj_elems;
10151:
10152: -- Added by skannoji
10153: -- Deleting deliverable task
10154: If (PA_PROJECT_STRUCTURE_UTILS.check_Deliverable_enabled(x_project_id) = 'Y' ) THEN
10155: PA_DELIVERABLE_PUB.delete_dlv_task_asscn_in_bulk(
10156: p_task_element_id => l_proj_element_id
10157: ,p_project_id => x_project_id
10158: ,p_task_version_id => cur_child_tasks_rec.object_id_to1

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

10279: END;
10280:
10281: --hsiu added, for dates rollup
10282: IF (l_peer_tasks_exist = 'Y') THEN
10283: IF PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(x_parent_struc_ver_id, 'WORKPLAN') = 'Y' then
10284: PA_STRUCT_TASK_ROLLUP_PUB.Tasks_Rollup(
10285: p_commit => FND_API.G_FALSE,
10286: p_element_versions => l_tasks_ver_ids,
10287: x_return_status => l_return_status,

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

10369: END IF;
10370: --end task weighting changes
10371:
10372: --3035902: process update flag changes
10373: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(x_parent_struc_ver_id, 'WORKPLAN');
10374: l_weighting_basis_Code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(x_project_id);
10375: --Bug No 3450684 SMukka Commented if condition
10376: --IF ((l_wp_type = 'Y') AND
10377: -- (l_weighting_basis_Code = 'EFFORT') AND