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_PUB1 dependencies on PA_PROJECT_STRUCTURE_UTILS

Line 2323: IF (PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(l_task_info_rec.project_id) = 'Y') THEN

2319: --bug 4501280
2320: IF l_task_info_rec.link_task_flag = 'N'
2321: THEN
2322: --bug 4501280
2323: IF (PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(l_task_info_rec.project_id) = 'Y') THEN
2324: --sharing enabled
2325: IF (PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(l_task_info_rec.project_id) = 'Y') THEN
2326: --versioning on
2327: IF (l_task_info_rec.task_unpub_ver_status_code = 'PUBLISHED' OR

Line 2381: IF (PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(l_task_info_rec.parent_structure_version_id, 'FINANCIAL') = 'Y') THEN

2377: ELSE -- versioning off
2378: NULL; --continue to delete
2379: END IF;
2380: ELSE --not shared
2381: IF (PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(l_task_info_rec.parent_structure_version_id, 'FINANCIAL') = 'Y') THEN
2382: --Financial structure
2383: NULL; --continue to delete
2384: ELSE --Workplan structure
2385: --check if versioning is on

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

2959: OPEN cur_proj_id;
2960: FETCH cur_proj_id INTO l_project_id;
2961: CLOSE cur_proj_id;
2962:
2963: If PA_Project_Structure_Utils.Check_Third_Party_Sch_Flag(l_Project_ID) = 'Y' Then
2964:
2965: Select a.Parent_Structure_Version_ID
2966: Into l_Structure_Version_ID
2967: From PA_Proj_Element_Versions a, pa_proj_elem_ver_schedule b

Line 3797: PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(l_dest_project_id)

3793: ELSE --If called from Bulk API
3794: l_dest_project_id := p_dest_project_id ;
3795: END IF;
3796: /* If p_structure_type = 'WORKPLAN' and
3797: PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(l_dest_project_id)
3798: IN ('SHARE_PARTIAL')
3799: Then
3800:
3801: PA_TASKS_MAINT_UTILS.CHECK_MOVE_FINANCIAL_TASK_OK (

Line 3824: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(p_dest_structure_version_id, 'WORKPLAN');

3820: IF p_calling_module = 'SELF_SERVICE' THEN
3821:
3822: --3035902: process update flag changes
3823: l_weighting_basis_code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(l_dest_project_id);
3824: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(p_dest_structure_version_id, 'WORKPLAN');
3825: --3035902: end process update flag changes
3826:
3827:
3828: OPEN get_product_code(l_dest_project_id);

Line 3908: PA_PROJECT_STRUCTURE_UTILS.Structure_Name_Or_Id

3904: (p_src_structure_name IS NOT NULL)) OR
3905: ((p_src_structure_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
3906: (p_src_structure_id IS NOT NULL)) THEN
3907: --Call Check API.
3908: PA_PROJECT_STRUCTURE_UTILS.Structure_Name_Or_Id
3909: (
3910: p_project_id => l_src_project_id
3911: ,p_structure_name => p_src_structure_name
3912: ,p_structure_id => p_src_structure_id

Line 3931: PA_PROJECT_STRUCTURE_UTILS.Structure_Version_Name_Or_Id

3927: ((p_src_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
3928: (p_src_structure_version_id IS NOT NULL)) THEN
3929: --Call Check API.
3930: l_src_structure_version_id := p_src_structure_version_id;
3931: PA_PROJECT_STRUCTURE_UTILS.Structure_Version_Name_Or_Id
3932: (
3933: p_structure_id => l_src_structure_id
3934: ,p_structure_version_name => p_src_structure_version_name
3935: ,p_structure_version_id => p_src_structure_version_id

Line 3977: PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(l_dest_project_id) =

3973: -- bug 3301192 financial HTML changes
3974: IF p_structure_type = 'WORKPLAN'
3975: THEN
3976: IF
3977: PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(l_dest_project_id) =
3978: 'SHARE_FULL'
3979: THEN
3980: l_fin_task_flag := 'Y';
3981: ELSE

Line 4004: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(

4000: END IF;
4001: CLOSE cur_proj_is_template;
4002:
4003: /*4201927 : Moved this code outside the Loop*/
4004: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(
4005: l_dest_project_id);
4006: /*4201927 : Moved this code outside the Loop*/
4007:
4008: /*4201927 : Deriving whether versioned or not only once*/

Line 4036: IF ('Y' = PA_PROJECT_STRUCTURE_UTILS.get_struc_type_for_structure(l_structure_id,'FINANCIAL') AND

4032: ELSE
4033: l_task_unpub_ver_status_code := 'PUBLISHED';
4034: END IF;
4035: ELSE --split
4036: IF ('Y' = PA_PROJECT_STRUCTURE_UTILS.get_struc_type_for_structure(l_structure_id,'FINANCIAL') AND
4037: 'N' = PA_PROJECT_STRUCTURE_UTILS.get_struc_type_for_structure(l_structure_id,'WORKPLAN')) THEN
4038: l_task_unpub_ver_status_code := 'PUBLISHED';
4039: ELSE --workplan only
4040: IF ('Y' = l_ver_enabled) THEN

Line 4037: 'N' = PA_PROJECT_STRUCTURE_UTILS.get_struc_type_for_structure(l_structure_id,'WORKPLAN')) THEN

4033: l_task_unpub_ver_status_code := 'PUBLISHED';
4034: END IF;
4035: ELSE --split
4036: IF ('Y' = PA_PROJECT_STRUCTURE_UTILS.get_struc_type_for_structure(l_structure_id,'FINANCIAL') AND
4037: 'N' = PA_PROJECT_STRUCTURE_UTILS.get_struc_type_for_structure(l_structure_id,'WORKPLAN')) THEN
4038: l_task_unpub_ver_status_code := 'PUBLISHED';
4039: ELSE --workplan only
4040: IF ('Y' = l_ver_enabled) THEN
4041: l_task_unpub_ver_status_code := 'WORKING';

Line 4093: l_src_wp_type := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(l_src_structure_version_id,'WORKPLAN');

4089: /* 4201927 : Perf Fix : END IF; --move_task_version check. */
4090:
4091: -- 4223490 Included for Copy External Flow
4092: IF l_copy_external_flag = 'Y' THEN
4093: l_src_wp_type := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(l_src_structure_version_id,'WORKPLAN');
4094: ELSE
4095: l_src_wp_type := l_wp_type;
4096: END IF;
4097:

Line 4196: PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(l_dest_project_id) = 'SHARE_PARTIAL'

4192: --end task status changes
4193: /* not required in the context of copy_task bcoz when a task is copied, copied as financial if copied under Fin tab and
4194: workplan if copied under WP tab for a partial share structures.
4195: If p_structure_type = 'WORKPLAN' and
4196: PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(l_dest_project_id) = 'SHARE_PARTIAL'
4197: Then
4198: IF p_dest_structure_version_id <> p_dest_task_version_id -- reference should not be str ver
4199: THEN
4200: PA_TASKS_MAINT_UTILS.CHECK_MOVE_FINANCIAL_TASK_OK (

Line 4373: IF ('Y' = PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(l_dest_project_id)) THEN

4369: -- if split, check if 'FINANCIAL'
4370: -- 'PUBLISHED' if financial
4371: -- check if versioned
4372: -- 'WORKING' if versioend; 'PUBLISHED' if not
4373: IF ('Y' = PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(l_dest_project_id)) THEN
4374: IF ('Y' = PA_WORKPLAN_ATTR_UTILS.Check_Wp_Versioning_Enabled(l_dest_project_id)) THEN
4375: l_task_unpub_ver_status_code := 'WORKING';
4376: ELSE
4377: l_task_unpub_ver_status_code := 'PUBLISHED';

Line 4380: IF ('Y' = PA_PROJECT_STRUCTURE_UTILS.get_struc_type_for_structure(l_structure_id, 'FINANCIAL') AND

4376: ELSE
4377: l_task_unpub_ver_status_code := 'PUBLISHED';
4378: END IF;
4379: ELSE --split
4380: IF ('Y' = PA_PROJECT_STRUCTURE_UTILS.get_struc_type_for_structure(l_structure_id, 'FINANCIAL') AND
4381: 'N' = PA_PROJECT_STRUCTURE_UTILS.get_struc_type_for_structure(l_structure_id, 'WORKPLAN')) THEN
4382: l_task_unpub_ver_status_code := 'PUBLISHED';
4383: ELSE --workplan only
4384: IF ('Y' = PA_WORKPLAN_ATTR_UTILS.Check_Wp_Versioning_Enabled(l_dest_project_id)) THEN

Line 4381: 'N' = PA_PROJECT_STRUCTURE_UTILS.get_struc_type_for_structure(l_structure_id, 'WORKPLAN')) THEN

4377: l_task_unpub_ver_status_code := 'PUBLISHED';
4378: END IF;
4379: ELSE --split
4380: IF ('Y' = PA_PROJECT_STRUCTURE_UTILS.get_struc_type_for_structure(l_structure_id, 'FINANCIAL') AND
4381: 'N' = PA_PROJECT_STRUCTURE_UTILS.get_struc_type_for_structure(l_structure_id, 'WORKPLAN')) THEN
4382: l_task_unpub_ver_status_code := 'PUBLISHED';
4383: ELSE --workplan only
4384: IF ('Y' = PA_WORKPLAN_ATTR_UTILS.Check_Wp_Versioning_Enabled(l_dest_project_id)) THEN
4385: l_task_unpub_ver_status_code := 'WORKING';

Line 4875: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(

4871: --hsiu
4872: --changes for versioning
4873: l_versioned := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(
4874: l_project_id);
4875: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(
4876: l_project_id);
4877:
4878: IF (NVL( l_published_version, 'N' ) = 'N') OR (l_published_version = 'Y' AND l_versioned = 'N' AND l_shared = 'Y') THEN
4879: -- IF NVL( l_published_version, 'N' ) = 'N'

Line 4941: /*IF PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_dest_structure_version_id, 'WORKPLAN') = 'Y' then

4937: CLOSE cur_struc_type2;
4938: */
4939:
4940: /* 4201927: This value is already derived as the variable l_wp_type */
4941: /*IF PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_dest_structure_version_id, 'WORKPLAN') = 'Y' then
4942: */
4943: IF l_wp_type = 'Y' then
4944: PA_STRUCT_TASK_ROLLUP_PUB.Tasks_Rollup_Unlimited(
4945: p_commit => FND_API.G_FALSE,

Line 5014: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(p_dest_structure_version_id, 'WORKPLAN');

5010: /* 4201927 : This value is already derived l_copy_external_flag VARCHAR2(1); */
5011: begin
5012:
5013: /* 4201927 : This value is already derived
5014: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(p_dest_structure_version_id, 'WORKPLAN');
5015: 4201927 */
5016: --3305199: deliverable changes
5017: IF (p_cp_deliverable_asso_flag = 'Y' AND l_wp_type = 'Y') THEN
5018: PA_DELIVERABLE_PUB.COPY_ASSOCIATIONS

Line 5638: l_sharing_code := PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(l_cur_project_id);

5634: OPEN cur_proj_id;
5635: FETCH cur_proj_id INTO l_cur_project_id;
5636: CLOSE cur_proj_id;
5637:
5638: l_sharing_code := PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(l_cur_project_id);
5639: l_fin_type := PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'FINANCIAL');
5640: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id,'WORKPLAN');
5641: l_check_third_party_flag := PA_Project_Structure_Utils.Check_Third_Party_Sch_Flag(l_cur_project_id);
5642: l_weighting_basis_Code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(l_cur_project_id);

Line 5639: l_fin_type := PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'FINANCIAL');

5635: FETCH cur_proj_id INTO l_cur_project_id;
5636: CLOSE cur_proj_id;
5637:
5638: l_sharing_code := PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(l_cur_project_id);
5639: l_fin_type := PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'FINANCIAL');
5640: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id,'WORKPLAN');
5641: l_check_third_party_flag := PA_Project_Structure_Utils.Check_Third_Party_Sch_Flag(l_cur_project_id);
5642: l_weighting_basis_Code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(l_cur_project_id);
5643: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(l_cur_project_id);

Line 5640: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id,'WORKPLAN');

5636: CLOSE cur_proj_id;
5637:
5638: l_sharing_code := PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(l_cur_project_id);
5639: l_fin_type := PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'FINANCIAL');
5640: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id,'WORKPLAN');
5641: l_check_third_party_flag := PA_Project_Structure_Utils.Check_Third_Party_Sch_Flag(l_cur_project_id);
5642: l_weighting_basis_Code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(l_cur_project_id);
5643: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(l_cur_project_id);
5644: l_versioned := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(l_cur_project_id);

Line 5641: l_check_third_party_flag := PA_Project_Structure_Utils.Check_Third_Party_Sch_Flag(l_cur_project_id);

5637:
5638: l_sharing_code := PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(l_cur_project_id);
5639: l_fin_type := PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'FINANCIAL');
5640: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id,'WORKPLAN');
5641: l_check_third_party_flag := PA_Project_Structure_Utils.Check_Third_Party_Sch_Flag(l_cur_project_id);
5642: l_weighting_basis_Code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(l_cur_project_id);
5643: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(l_cur_project_id);
5644: l_versioned := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(l_cur_project_id);
5645:

Line 5643: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(l_cur_project_id);

5639: l_fin_type := PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'FINANCIAL');
5640: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id,'WORKPLAN');
5641: l_check_third_party_flag := PA_Project_Structure_Utils.Check_Third_Party_Sch_Flag(l_cur_project_id);
5642: l_weighting_basis_Code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(l_cur_project_id);
5643: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(l_cur_project_id);
5644: l_versioned := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(l_cur_project_id);
5645:
5646: END IF; /*4269830*/
5647:

Line 6011: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(

6007: This code has been moved to block tagged by <<--A-->>
6008:
6009: l_versioned := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(
6010: l_project_id);
6011: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(
6012: l_project_id);
6013: */
6014:
6015: IF l_fin_type = 'Y' -- 4269830 this is equivalent to cur_struc_type%FOUND

Line 6184: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(l_parent_struct_ver_id, 'WORKPLAN');

6180: --bug 3053281 --set flag if not (manual and workplan only)
6181:
6182: /* 4269830 :
6183: This code has been moved to block tagged by <<--A-->>
6184: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(l_parent_struct_ver_id, 'WORKPLAN');
6185: l_weighting_basis_Code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(l_project_id);
6186: */
6187: --3035902: process update flag changes
6188: OPEN get_task_type_id(l_proj_element_id);

Line 6414: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(l_structure_ver_id, 'WORKPLAN');

6410: l_task_ver_ids2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */
6411: /*l_wp_type VARCHAR2(1); Commented for 4269830 - This value is already derived*/
6412: begin
6413: /*4269830 Commented for 4269830 - This value is already derived
6414: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(l_structure_ver_id, 'WORKPLAN');
6415: */
6416: IF l_wp_type = 'Y'
6417: AND l_ref_parent_struct_ver_id <> p_ref_task_version_id /* make sure that the reference is not a str ver */
6418: THEN

Line 6916: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(

6912: --hsiu
6913: --changes for versioning
6914: l_versioned := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(
6915: l_project_id);
6916: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(
6917: l_project_id);
6918:
6919: IF (NVL( l_published_version, 'N' ) = 'N') OR (l_published_version = 'Y' AND l_versioned = 'N' AND l_shared = 'Y')
6920: OR ((l_published_version = 'Y') AND (l_shared = 'N')) -- Bug # 5064340. -- To accomodate split financial tasks.

Line 6980: IF PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(l_parent_structure_version_id, 'WORKPLAN') = 'Y' then

6976: END IF;
6977:
6978: --Hsiu added for date rollup; workplan only
6979:
6980: IF PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(l_parent_structure_version_id, 'WORKPLAN') = 'Y' then
6981: l_tasks_ver_ids.extend;
6982: l_tasks_ver_ids(l_tasks_ver_ids.count) := p_task_version_id;
6983:
6984: PA_STRUCT_TASK_ROLLUP_PUB.Tasks_Rollup(

Line 7398: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(

7394: --hsiu
7395: --changes for versioning
7396: l_versioned := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(
7397: l_project_id);
7398: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(
7399: l_project_id);
7400: IF (NVL( l_published_version, 'N' ) = 'N') OR (l_published_version = 'Y' AND l_versioned = 'N' AND l_shared = 'Y')
7401: OR ((l_published_version = 'Y') AND (l_shared = 'N')) -- Bug # 5064340. -- To accomodate split financial tasks.
7402: THEN

Line 7459: IF PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(l_parent_structure_version_id, 'WORKPLAN') = 'Y' then

7455: --dbms_output.put_line( 'After Move task ' );
7456:
7457: --Hsiu added for date rollup; workplan only
7458:
7459: IF PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(l_parent_structure_version_id, 'WORKPLAN') = 'Y' then
7460: l_tasks_ver_ids.extend;
7461: l_tasks_ver_ids(l_tasks_ver_ids.count) := p_task_version_id;
7462:
7463: --added for task status rollup

Line 7749: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(p_structure_version_id, 'WORKPLAN');

7745: raise API_ERROR;
7746: end if;
7747:
7748: --bug 3053281 --set flag if not (manual and workplan only)
7749: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(p_structure_version_id, 'WORKPLAN');
7750: l_weighting_basis_Code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(p_project_id);
7751:
7752: --bug 3010538
7753: --Added the following lines to cache versioning and sharing information

Line 7756: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(

7752: --bug 3010538
7753: --Added the following lines to cache versioning and sharing information
7754: l_versioned := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(
7755: p_project_id);
7756: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(
7757: p_project_id);
7758: --check whether there exists any published version.
7759: l_published_ver_exists := PA_PROJECT_STRUCTURE_UTILS.CHECK_PUBLISHED_VER_EXISTS( p_project_id, p_structure_id );
7760: --end bug 3010538

Line 7759: l_published_ver_exists := PA_PROJECT_STRUCTURE_UTILS.CHECK_PUBLISHED_VER_EXISTS( p_project_id, p_structure_id );

7755: p_project_id);
7756: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(
7757: p_project_id);
7758: --check whether there exists any published version.
7759: l_published_ver_exists := PA_PROJECT_STRUCTURE_UTILS.CHECK_PUBLISHED_VER_EXISTS( p_project_id, p_structure_id );
7760: --end bug 3010538
7761: --3035902: process update flag changes
7762: l_wp_process_flag := 'N';
7763: --3035902: end process update flag changes

Line 7810: l_Share_Code := PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_project_id);

7806: if p_outline_level(i) is null then
7807: exit;
7808: end if;
7809:
7810: l_Share_Code := PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_project_id);
7811: -- Added for FP_M changes. Tracking Bug 3305199 : Bhumesh
7812: /*
7813: IF l_Share_Code IN ('SHARE_FULL', 'SHARE_PARTIAL') then
7814: If P_Structure_Type = 'FINANCIAL' THEN

Line 8061: IF PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'FINANCIAL') = 'Y'

8057: --3035902: end process update flag changes
8058:
8059: --ideally the following calls should have been cached. but due to time constraints
8060: --we need to write the code this way in multiple places.
8061: IF PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'FINANCIAL') = 'Y'
8062: THEN
8063: IF ( l_versioned = 'N' ) OR
8064: ( l_shared = 'N' ) OR --This wont happen bcoz for adding tasks to a financial structure we dont use this api
8065: ( l_versioned = 'Y' AND l_shared = 'Y' AND l_published_ver_exists = 'N' )THEN

Line 8105: -- IF ('Y' = PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(p_project_id)) THEN

8101: -- if split, check if 'FINANCIAL'
8102: -- 'PUBLISHED' if financial
8103: -- check if versioned
8104: -- 'WORKING' if versioend; 'PUBLISHED' if not
8105: -- IF ('Y' = PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(p_project_id)) THEN
8106: -- IF ('Y' = PA_WORKPLAN_ATTR_UTILS.Check_Wp_Versioning_Enabled(p_project_id)) THEN --Replaced these line with the following for performance.
8107: --Code added for bug 3010538 also does the same check.
8108: IF ('Y' = l_shared) THEN
8109: IF ('Y' = l_versioned) THEN

Line 8116: IF ('Y' = PA_PROJECT_STRUCTURE_UTILS.get_struc_type_for_structure(p_structure_id, 'FINANCIAL') AND

8112: ELSE
8113: l_task_unpub_ver_status_code := 'PUBLISHED';
8114: END IF;
8115: ELSE --split
8116: IF ('Y' = PA_PROJECT_STRUCTURE_UTILS.get_struc_type_for_structure(p_structure_id, 'FINANCIAL') AND
8117: 'N' = PA_PROJECT_STRUCTURE_UTILS.get_struc_type_for_structure(p_structure_id, 'WORKPLAN')) THEN
8118: l_task_unpub_ver_status_code := 'PUBLISHED';
8119: ELSE --workplan only
8120: --IF ('Y' = PA_WORKPLAN_ATTR_UTILS.Check_Wp_Versioning_Enabled(p_project_id)) THEN --Replaced these line with the following for performance. Code added for bug 3010538 also does the same check.

Line 8117: 'N' = PA_PROJECT_STRUCTURE_UTILS.get_struc_type_for_structure(p_structure_id, 'WORKPLAN')) THEN

8113: l_task_unpub_ver_status_code := 'PUBLISHED';
8114: END IF;
8115: ELSE --split
8116: IF ('Y' = PA_PROJECT_STRUCTURE_UTILS.get_struc_type_for_structure(p_structure_id, 'FINANCIAL') AND
8117: 'N' = PA_PROJECT_STRUCTURE_UTILS.get_struc_type_for_structure(p_structure_id, 'WORKPLAN')) THEN
8118: l_task_unpub_ver_status_code := 'PUBLISHED';
8119: ELSE --workplan only
8120: --IF ('Y' = PA_WORKPLAN_ATTR_UTILS.Check_Wp_Versioning_Enabled(p_project_id)) THEN --Replaced these line with the following for performance. Code added for bug 3010538 also does the same check.
8121: IF ('Y' = l_versioned) THEN

Line 8189: --my_error_msg( 'before PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION' );

8185: raise API_ERROR;
8186: end if;
8187: --end inherit task type
8188:
8189: --my_error_msg( 'before PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION' );
8190:
8191: if PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'WORKPLAN') = 'Y' then
8192: PA_TASK_PUB1.CREATE_SCHEDULE_VERSION
8193: ( p_validate_only => FND_API.G_FALSE

Line 8191: if PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'WORKPLAN') = 'Y' then

8187: --end inherit task type
8188:
8189: --my_error_msg( 'before PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION' );
8190:
8191: if PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'WORKPLAN') = 'Y' then
8192: PA_TASK_PUB1.CREATE_SCHEDULE_VERSION
8193: ( p_validate_only => FND_API.G_FALSE
8194: ,p_element_version_id => l_task_version_id
8195: ,p_scheduled_start_date => nvl(p_scheduled_start_date(i), sysdate)

Line 8238: if PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'WORKPLAN') = 'Y' then /* this api called should have been cached but we dont have time now to do this. */

8234: end LOOP;
8235:
8236:
8237: --bug 3301192 call the budgets apis
8238: if PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'WORKPLAN') = 'Y' then /* this api called should have been cached but we dont have time now to do this. */
8239: PA_TASK_PUB1.call_add_planning_txns(
8240: p_tasks_ver_ids => l_tasks_ver_ids,
8241: p_planned_effort => p_planned_effort,
8242: p_project_id => p_project_id,

Line 8331: if PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'WORKPLAN') = 'Y' then

8327: --bug 3301192 call the budgets apis
8328:
8329: --Hsiu added for date rollup; workplan only
8330:
8331: if PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'WORKPLAN') = 'Y' then
8332: PA_STRUCT_TASK_ROLLUP_PUB.Tasks_Rollup(
8333: p_commit => FND_API.G_FALSE,
8334: p_element_versions => l_tasks_ver_ids,
8335: x_return_status => l_return_status,

Line 8354: -- IF (PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(p_project_id) = 'Y') AND

8350: end if;
8351: raise API_ERROR;
8352: end if;
8353:
8354: -- IF (PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(p_project_id) = 'Y') AND
8355: -- (PA_WORKPLAN_ATTR_UTILS.Check_Wp_Versioning_Enabled(p_project_id) = 'N') THEN --Replaced these line with the following for performance. Code added for bug 3010538 also does the same check.
8356: IF (l_shared = 'Y') AND
8357: (l_versioned = 'N')
8358: THEN

Line 9604: IF (PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'FINANCIAL') = 'Y') THEN

9600: CLOSE get_parent_version_id;
9601:
9602: --bug 3069306
9603: --if financial task, check if changing parent ok
9604: IF (PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'FINANCIAL') = 'Y') THEN
9605: OPEN get_top_task_ver_id(l_parent_ver_id);
9606: FETCH get_top_task_ver_id into l_new_par_ver_id;
9607: CLOSE get_top_task_ver_id;
9608:

Line 9643: IF (PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'FINANCIAL') = 'Y') THEN

9639: --end bug 4099488
9640: ELSE
9641: --bug 3069306
9642: --if financial task, check if changing parent ok
9643: IF (PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'FINANCIAL') = 'Y') THEN
9644: OPEN get_top_task_ver_id(ref_elem_ver_id);
9645: FETCH get_top_task_ver_id into l_new_par_ver_id;
9646: CLOSE get_top_task_ver_id;
9647:

Line 9684: If PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_project_id)

9680: END IF;
9681:
9682: -- Added for FP_M changes. Bug 3305199 : Bhumesh xxx
9683:
9684: If PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_project_id)
9685: IN ('SHARE_PARTIAL')
9686: Then
9687:
9688: PA_TASKS_MAINT_UTILS.CHECK_MOVE_FINANCIAL_TASK_OK (

Line 10106: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(

10102:
10103:
10104: l_versioned := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(
10105: l_project_id);
10106: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(
10107: l_project_id);
10108:
10109: l_fin_task_flag := PA_Proj_Elements_Utils.CHECK_IS_FINANCIAL_TASK(src_proj_element_id); --indent in corresponding task in pa_tasks
10110:

Line 10249: IF PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'WORKPLAN') = 'Y' then

10245: END IF;
10246: CLOSE cur_struc_type;
10247: -- Merged from 85
10248:
10249: IF PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'WORKPLAN') = 'Y' then
10250:
10251: -- Added for FP_M changes Bug 3305199 : Bhumesh
10252: If PA_Project_Structure_Utils.Check_Third_Party_Sch_Flag(P_Project_ID) = 'Y' Then
10253:

Line 10252: If PA_Project_Structure_Utils.Check_Third_Party_Sch_Flag(P_Project_ID) = 'Y' Then

10248:
10249: IF PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'WORKPLAN') = 'Y' then
10250:
10251: -- Added for FP_M changes Bug 3305199 : Bhumesh
10252: If PA_Project_Structure_Utils.Check_Third_Party_Sch_Flag(P_Project_ID) = 'Y' Then
10253:
10254: PA_PROJECT_STRUCTURE_PVT1.update_sch_dirty_flag(
10255: p_structure_version_id => P_Structure_Version_ID
10256: ,p_dirty_flag => 'Y' --bug 3902282

Line 10338: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(p_structure_version_id, 'WORKPLAN');

10334:
10335: --bug 3010538 (Indent)
10336:
10337: --bug 3053281 --set flag if not (manual and workplan only)
10338: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(p_structure_version_id, 'WORKPLAN');
10339: l_weighting_basis_Code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(p_project_id);
10340:
10341: /*
10342: IF (l_shared = 'N') AND

Line 10403: IF PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'FINANCIAL') = 'Y'

10399: --3035902: end process update flag changes
10400:
10401: --ideally the following calls should have been cached. but due to time constraints
10402: --we need to write the code this way in multiple places.
10403: IF PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'FINANCIAL') = 'Y'
10404: THEN
10405: IF ( l_versioned = 'N' ) OR ( l_versioned = 'Y' and l_shared = 'Y' and l_published_version = 'N' ) THEN
10406: --Indent
10407: pa_fp_refresh_elements_pub.set_process_flag_proj(

Line 11086: IF (PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'FINANCIAL') = 'Y') THEN

11082: CLOSE get_parent_version_id;
11083:
11084: --bug 3069306
11085: --if financial task, check if changing parent ok
11086: IF (PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'FINANCIAL') = 'Y') THEN
11087: OPEN get_top_task_ver_id(l_parent_ver_id);
11088: FETCH get_top_task_ver_id into l_new_par_ver_id;
11089: CLOSE get_top_task_ver_id;
11090:

Line 11117: If PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_project_id)

11113: END IF;
11114:
11115: -- Added for FP_M changes. Bug 3305199 : Bhumesh xxx
11116:
11117: If PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_project_id)
11118: IN ('SHARE_PARTIAL')
11119: Then
11120:
11121: PA_TASKS_MAINT_UTILS.CHECK_MOVE_FINANCIAL_TASK_OK (

Line 11686: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(

11682:
11683:
11684: l_versioned := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(
11685: l_project_id);
11686: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(
11687: l_project_id);
11688:
11689: --o IF (NVL( l_published_version, 'N' ) = 'N') OR (l_published_version = 'Y' AND l_versioned = 'N' AND l_shared = 'Y') THEN
11690: l_fin_task_flag := PA_Proj_Elements_Utils.CHECK_IS_FINANCIAL_TASK(src_proj_element_id); --outdent in corresponding task in pa_tasks

Line 11884: IF PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'WORKPLAN') = 'Y' then

11880: CLOSE cur_struc_type;
11881:
11882: -- Added for date rollup; workplan only
11883:
11884: IF PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'WORKPLAN') = 'Y' then
11885:
11886: -- Added for FP_M changes Bug 3305199 : Bhumesh
11887: If PA_Project_Structure_Utils.Check_Third_Party_Sch_Flag(P_Project_ID) = 'Y' Then
11888:

Line 11887: If PA_Project_Structure_Utils.Check_Third_Party_Sch_Flag(P_Project_ID) = 'Y' Then

11883:
11884: IF PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'WORKPLAN') = 'Y' then
11885:
11886: -- Added for FP_M changes Bug 3305199 : Bhumesh
11887: If PA_Project_Structure_Utils.Check_Third_Party_Sch_Flag(P_Project_ID) = 'Y' Then
11888:
11889: PA_PROJECT_STRUCTURE_PVT1.update_sch_dirty_flag(
11890: p_structure_version_id => P_Structure_Version_ID
11891: ,p_dirty_flag => 'Y' --bug 3902282

Line 11974: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(p_structure_version_id, 'WORKPLAN');

11970: END IF;
11971:
11972: --bug 3010538 ( outdent )
11973: --bug 3053281 --set flag if not (manual and workplan only)
11974: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(p_structure_version_id, 'WORKPLAN');
11975: l_weighting_basis_Code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(p_project_id);
11976: /*
11977: IF (l_shared = 'N') AND
11978: (l_wp_type = 'Y') AND

Line 12039: IF PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'FINANCIAL') = 'Y'

12035: --3035902: end process update flag changes
12036:
12037: --ideally the following calls should have been cached. but due to time constraints
12038: --we need to write the code this way in multiple places.
12039: IF PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'FINANCIAL') = 'Y'
12040: THEN
12041: IF ( l_versioned = 'N' ) OR ( l_versioned = 'Y' and l_shared = 'Y' and l_published_version = 'N' ) THEN
12042:
12043: --Outdent

Line 13705: PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'WORKPLAN') = 'Y'

13701: -- Call: pa_fp_planning_transaction_pub.update_planning_transactions().
13702:
13703: --IF (PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_task_ver_id ) = 'Y' AND
13704: IF (l_lowest_level_task = 'Y' AND --bug 3959087
13705: PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'WORKPLAN') = 'Y'
13706: -- Progress Management Changes, Bug # 3420093.
13707: --AND PA_PROGRESS_UTILS.check_assignment_exists(p_project_id,p_task_ver_id,p_object_type) = 'N' --bug 3864543
13708: AND l_assignment_exists = 'N' --bug 3959087
13709: AND p_object_type = 'PA_TASKS'

Line 14410: p_baselined_str_ver_id => PA_PROJECT_STRUCTURE_UTILS.Get_Baseline_Struct_Ver(p_project_id),

14406: pa_progress_pub.populate_pji_tab_for_plan(
14407: p_init_msg_list => FND_API.G_FALSE,
14408: p_project_id => p_project_id,
14409: p_structure_version_id => p_structure_version_id,
14410: p_baselined_str_ver_id => PA_PROJECT_STRUCTURE_UTILS.Get_Baseline_Struct_Ver(p_project_id),
14411: p_structure_type => 'WORKPLAN',
14412: x_return_status => l_return_status,
14413: x_msg_count => l_msg_count,
14414: x_msg_data => l_msg_data

Line 14510: p_baselined_str_ver_id => PA_PROJECT_STRUCTURE_UTILS.Get_Baseline_Struct_Ver(p_project_id),

14506: p_init_msg_list => FND_API.G_FALSE,
14507: --p_calling_module => p_calling_module,
14508: p_project_id => p_project_id,
14509: p_structure_version_id => p_structure_version_id,
14510: p_baselined_str_ver_id => PA_PROJECT_STRUCTURE_UTILS.Get_Baseline_Struct_Ver(p_project_id),
14511: p_structure_type => 'WORKPLAN',
14512: x_return_status => l_return_status,
14513: x_msg_count => l_msg_count,
14514: x_msg_data => l_msg_data

Line 14837: PA_PROJECT_STRUCTURE_UTILS.Structure_Name_Or_Id

14833: (p_src_structure_name IS NOT NULL)) OR
14834: ((p_src_structure_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
14835: (p_src_structure_id IS NOT NULL)) THEN
14836: --Call Check API.
14837: PA_PROJECT_STRUCTURE_UTILS.Structure_Name_Or_Id
14838: (
14839: p_project_id => l_src_project_id
14840: ,p_structure_name => p_src_structure_name
14841: ,p_structure_id => p_src_structure_id

Line 14861: PA_PROJECT_STRUCTURE_UTILS.Structure_Version_Name_Or_Id

14857: ((p_src_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
14858: (p_src_structure_version_id IS NOT NULL)) THEN
14859: --Call Check API.
14860: l_src_structure_version_id := p_src_structure_version_id;
14861: PA_PROJECT_STRUCTURE_UTILS.Structure_Version_Name_Or_Id
14862: (
14863: p_structure_id => l_src_structure_id
14864: ,p_structure_version_name => p_src_structure_version_name
14865: ,p_structure_version_id => p_src_structure_version_id

Line 14928: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(

14924: FETCH cur_struc_id into l_dest_structure_id ;
14925: CLOSE cur_struc_id ;
14926:
14927: /*4201927 : Derive values for sharing enabled and Versioning Enabled */
14928: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(
14929: l_dest_project_id);
14930:
14931: l_ver_enabled :=
14932: PA_WORKPLAN_ATTR_UTILS.Check_Wp_Versioning_Enabled(l_dest_project_id);

Line 14961: IF ('Y' = PA_PROJECT_STRUCTURE_UTILS.get_struc_type_for_structure(l_dest_structure_id,'FINANCIAL') AND

14957: ELSE
14958: l_task_unpub_ver_status_code := 'PUBLISHED';
14959: END IF;
14960: ELSE --split
14961: IF ('Y' = PA_PROJECT_STRUCTURE_UTILS.get_struc_type_for_structure(l_dest_structure_id,'FINANCIAL') AND
14962: 'N' = PA_PROJECT_STRUCTURE_UTILS.get_struc_type_for_structure(l_dest_structure_id,'WORKPLAN')) THEN
14963: l_task_unpub_ver_status_code := 'PUBLISHED';
14964: ELSE --workplan only
14965: IF ('Y' = l_ver_enabled) THEN

Line 14962: 'N' = PA_PROJECT_STRUCTURE_UTILS.get_struc_type_for_structure(l_dest_structure_id,'WORKPLAN')) THEN

14958: l_task_unpub_ver_status_code := 'PUBLISHED';
14959: END IF;
14960: ELSE --split
14961: IF ('Y' = PA_PROJECT_STRUCTURE_UTILS.get_struc_type_for_structure(l_dest_structure_id,'FINANCIAL') AND
14962: 'N' = PA_PROJECT_STRUCTURE_UTILS.get_struc_type_for_structure(l_dest_structure_id,'WORKPLAN')) THEN
14963: l_task_unpub_ver_status_code := 'PUBLISHED';
14964: ELSE --workplan only
14965: IF ('Y' = l_ver_enabled) THEN
14966: l_task_unpub_ver_status_code := 'WORKING';

Line 14980: PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(l_dest_project_id) =

14976: /*Derive valie for the p_fin_task_flag*/
14977: IF p_structure_type = 'WORKPLAN'
14978: THEN
14979: IF
14980: PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(l_dest_project_id) =
14981: 'SHARE_FULL'
14982: THEN
14983: l_fin_task_flag := 'Y';
14984: ELSE

Line 15288: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(p_ref_project_id);

15284: l_versioned,l_structure_id,l_published_version,l_weighting_basis_Code
15285: ONLY once in the BULK API and pass it as params to the Move Task Version API
15286: */
15287:
15288: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(p_ref_project_id);
15289: l_sharing_code := PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_ref_project_id);
15290:
15291: -- Bug Fix 4764891.
15292: -- The following lines have the structure types usage messed up.

Line 15289: l_sharing_code := PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_ref_project_id);

15285: ONLY once in the BULK API and pass it as params to the Move Task Version API
15286: */
15287:
15288: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(p_ref_project_id);
15289: l_sharing_code := PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_ref_project_id);
15290:
15291: -- Bug Fix 4764891.
15292: -- The following lines have the structure types usage messed up.
15293: -- Correcting the structure types which are passed to the get_struct_type_for_version.

Line 15294: -- l_wp_type := PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'FINANCIAL');

15290:
15291: -- Bug Fix 4764891.
15292: -- The following lines have the structure types usage messed up.
15293: -- Correcting the structure types which are passed to the get_struct_type_for_version.
15294: -- l_wp_type := PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'FINANCIAL');
15295: -- l_fin_type := PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'WORKPLAN');
15296:
15297: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'WORKPLAN');
15298: l_fin_type := PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'FINANCIAL');

Line 15295: -- l_fin_type := PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'WORKPLAN');

15291: -- Bug Fix 4764891.
15292: -- The following lines have the structure types usage messed up.
15293: -- Correcting the structure types which are passed to the get_struct_type_for_version.
15294: -- l_wp_type := PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'FINANCIAL');
15295: -- l_fin_type := PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'WORKPLAN');
15296:
15297: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'WORKPLAN');
15298: l_fin_type := PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'FINANCIAL');
15299:

Line 15297: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'WORKPLAN');

15293: -- Correcting the structure types which are passed to the get_struct_type_for_version.
15294: -- l_wp_type := PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'FINANCIAL');
15295: -- l_fin_type := PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'WORKPLAN');
15296:
15297: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'WORKPLAN');
15298: l_fin_type := PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'FINANCIAL');
15299:
15300: -- End of Bug Fix 4764891.
15301:

Line 15298: l_fin_type := PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'FINANCIAL');

15294: -- l_wp_type := PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'FINANCIAL');
15295: -- l_fin_type := PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'WORKPLAN');
15296:
15297: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'WORKPLAN');
15298: l_fin_type := PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'FINANCIAL');
15299:
15300: -- End of Bug Fix 4764891.
15301:
15302: l_versioned := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(p_ref_project_id);

Line 15304: l_check_third_party_flag := PA_Project_Structure_Utils.Check_Third_Party_Sch_Flag(p_ref_project_id);

15300: -- End of Bug Fix 4764891.
15301:
15302: l_versioned := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(p_ref_project_id);
15303: l_weighting_basis_Code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(p_ref_project_id);
15304: l_check_third_party_flag := PA_Project_Structure_Utils.Check_Third_Party_Sch_Flag(p_ref_project_id);
15305:
15306: IF nvl(p_task_version_id_tbl.LAST,0)>0 THEN
15307: l_task_version_id := p_task_version_id_tbl(1);
15308: