DBA Data[Home] [Help]

APPS.PA_TASK_PUB1 dependencies on PA_WORKPLAN_ATTR_UTILS

Line 2375: IF (PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(l_task_info_rec.project_id) = 'Y') THEN

2371: THEN
2372: --bug 4501280
2373: IF (PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(l_task_info_rec.project_id) = 'Y') THEN
2374: --sharing enabled
2375: IF (PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(l_task_info_rec.project_id) = 'Y') THEN
2376: --versioning on
2377: IF (l_task_info_rec.task_unpub_ver_status_code = 'PUBLISHED' OR
2378: l_task_info_rec.task_unpub_ver_status_code = 'TO_BE_DELETED')
2379: AND p_called_from_api <> 'DELETE_STRUCTURE_VERSION' THEN -- Bug 3056077. We need to delete the task versions

Line 2436: IF (PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(l_task_info_rec.project_id) = 'Y') THEN

2432: --Financial structure
2433: NULL; --continue to delete
2434: ELSE --Workplan structure
2435: --check if versioning is on
2436: IF (PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(l_task_info_rec.project_id) = 'Y') THEN
2437: --versioning on
2438: IF (l_task_info_rec.task_unpub_ver_status_code = 'PUBLISHED' OR
2439: l_task_info_rec.task_unpub_ver_status_code = 'TO_BE_DELETED')
2440: AND p_called_from_api <> 'DELETE_STRUCTURE_VERSION' THEN -- Bug 3056077. We need to delete the task versions

Line 4178: PA_WORKPLAN_ATTR_UTILS.Check_Wp_Versioning_Enabled(l_dest_project_id);

4174: /*4201927 : Moved this code outside the Loop*/
4175:
4176: /*4201927 : Deriving whether versioned or not only once*/
4177: l_ver_enabled :=
4178: PA_WORKPLAN_ATTR_UTILS.Check_Wp_Versioning_Enabled(l_dest_project_id);
4179:
4180: /*4201927 : <> Value for Copy External Flag*/
4181: IF p_src_project_id = l_dest_project_id
4182: THEN

Line 4569: IF ('Y' = PA_WORKPLAN_ATTR_UTILS.Check_Wp_Versioning_Enabled(l_dest_project_id)) THEN

4565: -- 'PUBLISHED' if financial
4566: -- check if versioned
4567: -- 'WORKING' if versioend; 'PUBLISHED' if not
4568: IF ('Y' = PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(l_dest_project_id)) THEN
4569: IF ('Y' = PA_WORKPLAN_ATTR_UTILS.Check_Wp_Versioning_Enabled(l_dest_project_id)) THEN
4570: l_task_unpub_ver_status_code := 'WORKING';
4571: ELSE
4572: l_task_unpub_ver_status_code := 'PUBLISHED';
4573: END IF;

Line 4579: IF ('Y' = PA_WORKPLAN_ATTR_UTILS.Check_Wp_Versioning_Enabled(l_dest_project_id)) THEN

4575: IF ('Y' = PA_PROJECT_STRUCTURE_UTILS.get_struc_type_for_structure(l_structure_id, 'FINANCIAL') AND
4576: 'N' = PA_PROJECT_STRUCTURE_UTILS.get_struc_type_for_structure(l_structure_id, 'WORKPLAN')) THEN
4577: l_task_unpub_ver_status_code := 'PUBLISHED';
4578: ELSE --workplan only
4579: IF ('Y' = PA_WORKPLAN_ATTR_UTILS.Check_Wp_Versioning_Enabled(l_dest_project_id)) THEN
4580: l_task_unpub_ver_status_code := 'WORKING';
4581: ELSE
4582: l_task_unpub_ver_status_code := 'PUBLISHED';
4583: END IF;

Line 5148: l_versioned := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(

5144: CLOSE cur_pub_versions;
5145:
5146: --hsiu
5147: --changes for versioning
5148: l_versioned := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(
5149: l_project_id);
5150: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(
5151: l_project_id);
5152:

Line 5245: /*IF ('N' = PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(l_dest_project_id)) AND*/

5241: --hsiu added for task status
5242: --if versioning is off, rollup.
5243:
5244: /* 4201927 : Replaced Call to Version ENabled with l_ver_enabled */
5245: /*IF ('N' = PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(l_dest_project_id)) AND*/
5246: IF ('N' = l_ver_enabled) AND
5247: (l_rollup_task_id IS NOT NULL) THEN
5248: PA_STRUCT_TASK_ROLLUP_PUB.Task_Status_Rollup(
5249: p_structure_version_id => p_dest_structure_version_id

Line 5919: l_versioned := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(l_cur_project_id);

5915: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id,'WORKPLAN');
5916: l_check_third_party_flag := PA_Project_Structure_Utils.Check_Third_Party_Sch_Flag(l_cur_project_id);
5917: l_weighting_basis_Code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(l_cur_project_id);
5918: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(l_cur_project_id);
5919: l_versioned := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(l_cur_project_id);
5920:
5921: END IF; /*4269830*/
5922:
5923: --bug 3911698

Line 6291: l_versioned := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(

6287: --changes for versioning
6288: /* 4269830 :
6289: This code has been moved to block tagged by <<--A-->>
6290:
6291: l_versioned := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(
6292: l_project_id);
6293: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(
6294: l_project_id);
6295: */

Line 6632: IF ('N' = PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(l_project_id)) THEN

6628: end if;
6629:
6630: --hsiu added for task status
6631: --if versioning is off, rollup.
6632: IF ('N' = PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(l_project_id)) THEN
6633: PA_STRUCT_TASK_ROLLUP_PUB.Task_Status_Rollup(
6634: p_structure_version_id => l_structure_ver_id
6635: ,p_element_version_id => p_task_version_id
6636: ,x_return_status => l_return_status

Line 7211: l_versioned := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(

7207: CLOSE cur_pub_versions;
7208:
7209: --hsiu
7210: --changes for versioning
7211: l_versioned := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(
7212: l_project_id);
7213: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(
7214: l_project_id);
7215:

Line 7305: IF ('N' = PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(l_project_id)) THEN

7301: end if;
7302:
7303: --hsiu added for task status
7304: --if versioning is off, rollup.
7305: IF ('N' = PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(l_project_id)) THEN
7306: PA_STRUCT_TASK_ROLLUP_PUB.Task_Status_Rollup(
7307: p_structure_version_id => p_structure_version_id
7308: ,p_element_version_id => p_task_version_id
7309: ,x_return_status => l_return_status

Line 7693: l_versioned := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(

7689: CLOSE cur_pub_versions;
7690:
7691: --hsiu
7692: --changes for versioning
7693: l_versioned := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(
7694: l_project_id);
7695: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(
7696: l_project_id);
7697: IF (NVL( l_published_version, 'N' ) = 'N') OR (l_published_version = 'Y' AND l_versioned = 'N' AND l_shared = 'Y')

Line 7789: IF ('N' = PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(l_project_id)) THEN

7785: end if;
7786:
7787: --hsiu added for task status
7788: --if versioning is off, rollup.
7789: IF ('N' = PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(l_project_id)) THEN
7790: PA_STRUCT_TASK_ROLLUP_PUB.Task_Status_Rollup(
7791: p_structure_version_id => p_structure_version_id
7792: ,p_element_version_id => l_rollup_task_id
7793: ,x_return_status => l_return_status

Line 8051: l_versioned := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(

8047: l_weighting_basis_Code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(p_project_id);
8048:
8049: --bug 3010538
8050: --Added the following lines to cache versioning and sharing information
8051: l_versioned := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(
8052: p_project_id);
8053: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(
8054: p_project_id);
8055: --check whether there exists any published version.

Line 8403: -- IF ('Y' = PA_WORKPLAN_ATTR_UTILS.Check_Wp_Versioning_Enabled(p_project_id)) THEN --Replaced these line with the following for performance.

8399: -- 'PUBLISHED' if financial
8400: -- check if versioned
8401: -- 'WORKING' if versioend; 'PUBLISHED' if not
8402: -- IF ('Y' = PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(p_project_id)) THEN
8403: -- IF ('Y' = PA_WORKPLAN_ATTR_UTILS.Check_Wp_Versioning_Enabled(p_project_id)) THEN --Replaced these line with the following for performance.
8404: --Code added for bug 3010538 also does the same check.
8405: IF ('Y' = l_shared) THEN
8406: IF ('Y' = l_versioned) THEN
8407:

Line 8417: --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.

8413: IF ('Y' = PA_PROJECT_STRUCTURE_UTILS.get_struc_type_for_structure(p_structure_id, 'FINANCIAL') AND
8414: 'N' = PA_PROJECT_STRUCTURE_UTILS.get_struc_type_for_structure(p_structure_id, 'WORKPLAN')) THEN
8415: l_task_unpub_ver_status_code := 'PUBLISHED';
8416: ELSE --workplan only
8417: --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.
8418: IF ('Y' = l_versioned) THEN
8419: l_task_unpub_ver_status_code := 'WORKING';
8420: ELSE
8421: l_task_unpub_ver_status_code := 'PUBLISHED';

Line 8718: -- (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.

8714: raise API_ERROR;
8715: end if;
8716:
8717: -- IF (PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(p_project_id) = 'Y') AND
8718: -- (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.
8719: IF (l_shared = 'Y') AND
8720: (l_versioned = 'N')
8721: THEN
8722:

Line 10484: l_versioned := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(

10480: FETCH cur_pub_versions INTO l_published_version;
10481: CLOSE cur_pub_versions;
10482:
10483:
10484: l_versioned := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(
10485: l_project_id);
10486: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(
10487: l_project_id);
10488:

Line 10686: IF ('N' = PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(l_project_id)) THEN

10682: end if;
10683:
10684: --hsiu added for task status
10685: --if versioning is off, rollup.
10686: IF ('N' = PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(l_project_id)) THEN
10687: PA_STRUCT_TASK_ROLLUP_PUB.Task_Status_Rollup(
10688: p_structure_version_id => p_structure_version_id
10689: ,p_element_version_id => p_task_version_id
10690: ,x_return_status => l_return_status

Line 12100: l_versioned := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(

12096: FETCH cur_pub_versions INTO l_published_version;
12097: CLOSE cur_pub_versions;
12098:
12099:
12100: l_versioned := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(
12101: l_project_id);
12102: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(
12103: l_project_id);
12104:

Line 12361: IF ('N' = PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(l_project_id)) THEN

12357: raise FND_API.G_EXC_ERROR;
12358: end if;
12359:
12360: --if versioning is off, rollup.
12361: IF ('N' = PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(l_project_id)) THEN
12362: PA_STRUCT_TASK_ROLLUP_PUB.Task_Status_Rollup(
12363: p_structure_version_id => p_structure_version_id
12364: ,p_element_version_id => l_rollup_task_id
12365: ,x_return_status => l_return_status

Line 14013: l_version_enabled := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(p_project_id); --maansari5/9

14009: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_percent_complete='||p_percent_complete, x_Log_Level=> 3);
14010: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_res_assign_id='||p_res_assign_id, x_Log_Level=> 3);
14011: END IF;
14012:
14013: l_version_enabled := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(p_project_id); --maansari5/9
14014:
14015: --The following actions are to be performed only when p_object_type = 'PA_TASKS'
14016:
14017: --IF (p_object_type = 'PA_TASKS') THEN --- Bug 4498610

Line 15463: PA_WORKPLAN_ATTR_UTILS.Check_Wp_Versioning_Enabled(l_dest_project_id);

15459: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(
15460: l_dest_project_id);
15461:
15462: l_ver_enabled :=
15463: PA_WORKPLAN_ATTR_UTILS.Check_Wp_Versioning_Enabled(l_dest_project_id);
15464:
15465: /* Derive the value for Copy External Flag*/
15466: IF p_src_project_id = l_dest_project_id
15467: THEN

Line 15835: l_versioned := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(p_ref_project_id);

15831: l_fin_type := PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'FINANCIAL');
15832:
15833: -- End of Bug Fix 4764891.
15834:
15835: l_versioned := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(p_ref_project_id);
15836: l_weighting_basis_Code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(p_ref_project_id);
15837: l_check_third_party_flag := PA_Project_Structure_Utils.Check_Third_Party_Sch_Flag(p_ref_project_id);
15838:
15839: IF nvl(p_task_version_id_tbl.LAST,0)>0 THEN

Line 16535: l_version_enabled := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(p_project_id);

16531: IF (x_return_status <> 'S') THEN
16532: raise FND_API.G_EXC_ERROR;
16533: END IF;
16534:
16535: l_version_enabled := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(p_project_id);
16536:
16537: IF l_debug_mode = 'Y' THEN
16538: pa_debug.write(l_module_name,'Call Delete_SubProject_Association l_version_enabled='||l_version_enabled, 3);
16539: END IF;