[Home] [Help]
696:
697: -- Bug Fix 5609629.
698: -- Caching the wp_version_enable_flag in a local variable in order to avoid the function call
699: -- during the insert statements. This will avoid the multiple executions of the same select.
700: -- The project id is passed as a parameter to the pa_workplan_attr_utils.check_wp_versioning_enabled
701: -- As the project id is not going to change during the insert statement records we can safely cache
702: -- the value in a local variable and use that during the insert statment.
703:
704: l_versioning_enabled_flag pa_proj_workplan_attr.wp_enable_version_flag%TYPE;
733: l_no := PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('YES_NO','N');
734:
735: -- Bug Fix 5609629
736: -- Caching the versioning_enabled_flag attribute value locally.
737: l_versioning_enabled_flag := pa_workplan_attr_utils.check_wp_versioning_enabled(p_project_id);
738: -- End of Bug Fix 5609629
739:
740: --Populate published versions records first.
741: -- Bug # 4875311.
1238: -- Fix for Bug # 4447949.
1239: , decode(ppvs.status_code, 'STRUCTURE_PUBLISHED', 'Y', 'N') -- Fix for Bug # 4447949.
1240: ,ppru.CUMULATIVE_WORK_QUANTITY
1241: -- Bug 6156686
1242: ,ppwa.wp_enable_version_flag--pa_workplan_attr_utils.check_wp_versioning_enabled(ppe.project_id)
1243: ,ppe.phase_version_id
1244: ,ppe5.name
1245: ,ppe5.element_number
1246: ,pt.attribute_category
1815: -- Fix for Bug # 4447949.
1816: , decode(ppvs.status_code, 'STRUCTURE_PUBLISHED', 'Y', 'N') -- Fix for Bug # 4447949.
1817: ,ppru.CUMULATIVE_WORK_QUANTITY
1818: -- Bug 6156686
1819: ,ppwa.wp_enable_version_flag--pa_workplan_attr_utils.check_wp_versioning_enabled(ppe.project_id)
1820: ,ppe.phase_version_id
1821: ,ppe5.name
1822: ,ppe5.element_number
1823: ,pt.attribute_category
2635: , decode(ppvs.status_code, 'STRUCTURE_PUBLISHED', 'Y', 'N') -- Fix for Bug # 4447949.
2636: ,ppru.CUMULATIVE_WORK_QUANTITY
2637: -- Bug Fix 5609629
2638: -- Replaced the following function call with local variable.
2639: -- pa_workplan_attr_utils.check_wp_versioning_enabled(ppe.project_id)
2640: , l_versioning_enabled_flag
2641: -- End of Bug Fix 5609629
2642: ,ppe.phase_version_id
2643: ,ppe5.name
3215: , decode(ppvs.status_code, 'STRUCTURE_PUBLISHED', 'Y', 'N') -- Fix for Bug # 4447949.
3216: ,ppru.CUMULATIVE_WORK_QUANTITY
3217: -- Bug Fix 5609629
3218: -- Replaced the following function call with local variable.
3219: -- pa_workplan_attr_utils.check_wp_versioning_enabled(ppe.project_id)
3220: , l_versioning_enabled_flag
3221: -- End of Bug Fix 5609629
3222: ,ppe.phase_version_id
3223: ,ppe5.name
4090: , decode(ppvs.status_code, 'STRUCTURE_PUBLISHED', 'Y', 'N') -- Fix for Bug # 4447949.
4091: ,ppru.CUMULATIVE_WORK_QUANTITY
4092: -- Bug Fix 5609629
4093: -- Replaced the following function call with local variable.
4094: -- pa_workplan_attr_utils.check_wp_versioning_enabled(ppe.project_id)
4095: , l_versioning_enabled_flag
4096: -- End of Bug Fix 5609629
4097: ,ppe.phase_version_id
4098: ,ppe5.name
4665: , decode(ppvs.status_code, 'STRUCTURE_PUBLISHED', 'Y', 'N') -- Fix for Bug # 4447949.
4666: ,ppru.CUMULATIVE_WORK_QUANTITY
4667: -- Bug Fix 5609629
4668: -- Replaced the following function call with local variable.
4669: -- pa_workplan_attr_utils.check_wp_versioning_enabled(ppe.project_id)
4670: , l_versioning_enabled_flag
4671: -- End of Bug Fix 5609629
4672: ,ppe.phase_version_id
4673: ,ppe5.name
5185:
5186: -- Bug Fix 5609629.
5187: -- Caching the wp_version_enable_flag in a local variable in order to avoid the function call
5188: -- during the insert statements. This will avoid the multiple executions of the same select.
5189: -- The project id is passed as a parameter to the pa_workplan_attr_utils.check_wp_versioning_enabled
5190: -- As the project id is not going to change during the insert statement records we can safely cache
5191: -- the value in a local variable and use that during the insert statment.
5192:
5193: l_versioning_enabled_flag pa_proj_workplan_attr.wp_enable_version_flag%TYPE;
5225: -- Bug # 4875311.
5226:
5227: -- Bug Fix 5609629
5228: -- Caching the versioning_enabled_flag attribute value locally.
5229: l_versioning_enabled_flag := pa_workplan_attr_utils.check_wp_versioning_enabled(p_project_id);
5230: -- End of Bug Fix 5609629
5231:
5232: -- ************************************************************************************************************************
5233: -- if only p_structure_version_id is passed in, populate all task records for the given structure version.
5657: , decode(ppvs.status_code, 'STRUCTURE_PUBLISHED', 'Y', 'N') -- Fix for Bug # 4447949.
5658: ,ppru.CUMULATIVE_WORK_QUANTITY
5659: -- Bug Fix 5609629
5660: -- Replaced the following function call with local variable.
5661: -- pa_workplan_attr_utils.check_wp_versioning_enabled(ppe.project_id)
5662: , l_versioning_enabled_flag
5663: -- End of Bug Fix 5609629
5664: ,ppe.phase_version_id
5665: ,ppe5.name
6483: , decode(ppvs.status_code, 'STRUCTURE_PUBLISHED', 'Y', 'N') -- Fix for Bug # 4447949.
6484: ,ppru.CUMULATIVE_WORK_QUANTITY
6485: -- Bug Fix 5609629
6486: -- Replaced the following function call with local variable.
6487: -- pa_workplan_attr_utils.check_wp_versioning_enabled(ppe.project_id)
6488: , l_versioning_enabled_flag
6489: -- End of Bug Fix 5609629
6490: ,ppe.phase_version_id
6491: ,ppe5.name
7310: , decode(ppvs.status_code, 'STRUCTURE_PUBLISHED', 'Y', 'N') -- Fix for Bug # 4447949.
7311: ,ppru.CUMULATIVE_WORK_QUANTITY
7312: -- Bug Fix 5609629
7313: -- Replaced the following function call with local variable.
7314: -- pa_workplan_attr_utils.check_wp_versioning_enabled(ppe.project_id)
7315: , l_versioning_enabled_flag
7316: -- End of Bug Fix 5609629
7317: ,ppe.phase_version_id
7318: ,ppe5.name
7828:
7829: -- Bug Fix 5609629.
7830: -- Caching the wp_version_enable_flag in a local variable in order to avoid the function call
7831: -- during the insert statements. This will avoid the multiple executions of the same select.
7832: -- The project id is passed as a parameter to the pa_workplan_attr_utils.check_wp_versioning_enabled
7833: -- As the project id is not going to change during the insert statement records we can safely cache
7834: -- the value in a local variable and use that during the insert statment.
7835:
7836: l_versioning_enabled_flag pa_proj_workplan_attr.wp_enable_version_flag%TYPE;
7900:
7901:
7902: -- Bug Fix 5609629
7903: -- Caching the versioning_enabled_flag attribute value locally.
7904: l_versioning_enabled_flag := pa_workplan_attr_utils.check_wp_versioning_enabled(p_project_id);
7905: -- End of Bug Fix 5609629
7906:
7907:
7908: -- bug 4416432: insert working structures
8296: , decode(ppvs.status_code, 'STRUCTURE_PUBLISHED', 'Y', 'N') -- Fix for Bug # 4447949.
8297: ,ppru.CUMULATIVE_WORK_QUANTITY
8298: -- Bug Fix 5609629
8299: -- Replaced the following function call with local variable.
8300: -- pa_workplan_attr_utils.check_wp_versioning_enabled(ppe.project_id)
8301: , l_versioning_enabled_flag
8302: -- End of Bug Fix 5609629
8303: ,ppe.phase_version_id
8304: ,to_char(null)
8781: , decode(ppvs.status_code, 'STRUCTURE_PUBLISHED', 'Y', 'N') -- Fix for Bug # 4447949.
8782: ,ppru.CUMULATIVE_WORK_QUANTITY
8783: -- Bug Fix 5609629
8784: -- Replaced the following function call with local variable.
8785: -- pa_workplan_attr_utils.check_wp_versioning_enabled(ppe.project_id)
8786: , l_versioning_enabled_flag
8787: -- End of Bug Fix 5609629
8788: ,ppe.phase_version_id
8789: ,to_char(null)
9289: , decode(ppvs.status_code, 'STRUCTURE_PUBLISHED', 'Y', 'N') -- Fix for Bug # 4447949.
9290: ,ppru.CUMULATIVE_WORK_QUANTITY
9291: -- Bug Fix 5609629
9292: -- Replaced the following function call with local variable.
9293: -- pa_workplan_attr_utils.check_wp_versioning_enabled(ppe.project_id)
9294: , l_versioning_enabled_flag
9295: -- End of Bug Fix 5609629
9296: ,ppe.phase_version_id
9297: ,to_char(null)
9774:
9775: -- Bug Fix 5609629.
9776: -- Caching the wp_version_enable_flag in a local variable in order to avoid the function call
9777: -- during the insert statements. This will avoid the multiple executions of the same select.
9778: -- The project id is passed as a parameter to the pa_workplan_attr_utils.check_wp_versioning_enabled
9779: -- As the project id is not going to change during the insert statement records we can safely cache
9780: -- the value in a local variable and use that during the insert statment.
9781:
9782: l_versioning_enabled_flag pa_proj_workplan_attr.wp_enable_version_flag%TYPE;
9807: x_return_status := FND_API.G_RET_STS_SUCCESS;
9808:
9809: -- Bug Fix 5609629
9810: -- Caching the versioning_enabled_flag attribute value locally.
9811: l_versioning_enabled_flag := pa_workplan_attr_utils.check_wp_versioning_enabled(p_project_id);
9812: -- End of Bug Fix 5609629
9813:
9814: --Populate published versions records first.
9815: INSERT INTO pa_structures_tasks_tmp
10201: , decode(ppvs.status_code, 'STRUCTURE_PUBLISHED', 'Y', 'N') -- Fix for Bug # 4447949.
10202: ,ppru.CUMULATIVE_WORK_QUANTITY
10203: -- Bug Fix 5609629
10204: -- Replaced the following function call with local variable.
10205: -- pa_workplan_attr_utils.check_wp_versioning_enabled(ppe.project_id)
10206: , l_versioning_enabled_flag
10207: -- End of Bug Fix 5609629
10208: ,ppe.phase_version_id
10209: ,ppe5.name
10534:
10535: -- Bug Fix 5609629.
10536: -- Caching the wp_version_enable_flag in a local variable in order to avoid the function call
10537: -- during the insert statements. This will avoid the multiple executions of the same select.
10538: -- The project id is passed as a parameter to the pa_workplan_attr_utils.check_wp_versioning_enabled
10539: -- As the project id is not going to change during the insert statement records we can safely cache
10540: -- the value in a local variable and use that during the insert statment.
10541:
10542: l_versioning_enabled_flag pa_proj_workplan_attr.wp_enable_version_flag%TYPE;
10567: x_return_status := FND_API.G_RET_STS_SUCCESS;
10568:
10569: -- Bug Fix 5609629
10570: -- Caching the versioning_enabled_flag attribute value locally.
10571: l_versioning_enabled_flag := pa_workplan_attr_utils.check_wp_versioning_enabled(p_project_id);
10572: -- End of Bug Fix 5609629
10573:
10574:
10575: INSERT INTO pa_structures_tasks_tmp
10960: , decode(ppvs.status_code, 'STRUCTURE_PUBLISHED', 'Y', 'N') -- Fix for Bug # 4447949.
10961: ,ppru.CUMULATIVE_WORK_QUANTITY
10962: -- Bug Fix 5609629
10963: -- Replaced the following function call with local variable.
10964: -- pa_workplan_attr_utils.check_wp_versioning_enabled(ppe.project_id)
10965: , l_versioning_enabled_flag
10966: -- End of Bug Fix 5609629
10967: ,ppe.phase_version_id
10968: ,ppe5.name
11775: , null)) estimated_remaining_effort
11776: -- Fix for Bug # 4319171.
11777: ,null -- not needed in VO PA_PROJECT_STRUCTURE_UTILS.Check_Struc_Ver_Published(ppv.project_id, ppv.parent_structure_version_id)
11778: ,ppru.CUMULATIVE_WORK_QUANTITY
11779: ,null -- not needed in VO pa_workplan_attr_utils.check_wp_versioning_enabled(ppe.project_id)
11780: ,ppe.phase_version_id
11781: ,pps5.project_status_name
11782: ,null --Phase Short Name
11783: ,pt.attribute_category
12603: , null)) estimated_remaining_effort
12604: -- Fix for Bug # 4319171.
12605: ,null -- not needed in VO PA_PROJECT_STRUCTURE_UTILS.Check_Struc_Ver_Published(ppv.project_id, ppv.parent_structure_version_id)
12606: ,ppru.CUMULATIVE_WORK_QUANTITY
12607: ,null -- not needed in VO pa_workplan_attr_utils.check_wp_versioning_enabled(ppe.project_id)
12608: ,ppe.phase_version_id
12609: ,pps5.project_status_name
12610: ,null --Phase Short Name
12611: ,pt.attribute_category
13432: , null)) estimated_remaining_effort
13433: -- Fix for Bug # 4319171.
13434: ,null -- not needed in VO PA_PROJECT_STRUCTURE_UTILS.Check_Struc_Ver_Published(ppv.project_id, ppv.parent_structure_version_id)
13435: ,ppru.CUMULATIVE_WORK_QUANTITY
13436: ,null -- not needed in VO pa_workplan_attr_utils.check_wp_versioning_enabled(ppe.project_id)
13437: ,ppe.phase_version_id
13438: ,pps5.project_status_name
13439: ,null --Phase Short Name
13440: ,pt.attribute_category
14396: , null)) estimated_remaining_effort
14397: -- Fix for Bug # 4319171.
14398: ,null -- not needed in VO PA_PROJECT_STRUCTURE_UTILS.Check_Struc_Ver_Published(ppv.project_id, ppv.parent_structure_version_id)
14399: ,ppru.CUMULATIVE_WORK_QUANTITY
14400: ,null -- not needed in VO pa_workplan_attr_utils.check_wp_versioning_enabled(ppe.project_id)
14401: ,ppe.phase_version_id
14402: ,pps5.project_status_name
14403: ,null --Phase Short Name
14404: ,pt.attribute_category
15193: , null)) estimated_remaining_effort
15194: -- Fix for Bug # 4319171.
15195: ,null -- not needed in VO PA_PROJECT_STRUCTURE_UTILS.Check_Struc_Ver_Published(ppv.project_id, ppv.parent_structure_version_id)
15196: ,ppru.CUMULATIVE_WORK_QUANTITY
15197: ,null -- not needed in VO pa_workplan_attr_utils.check_wp_versioning_enabled(ppe.project_id)
15198: ,ppe.phase_version_id
15199: ,pps5.project_status_name
15200: ,null --Phase Short Name
15201: ,pt.attribute_category
15991: , null)) estimated_remaining_effort
15992: -- Fix for Bug # 4319171.
15993: ,null -- not needed in VO PA_PROJECT_STRUCTURE_UTILS.Check_Struc_Ver_Published(ppv.project_id, ppv.parent_structure_version_id)
15994: ,ppru.CUMULATIVE_WORK_QUANTITY
15995: ,null -- not needed in VO pa_workplan_attr_utils.check_wp_versioning_enabled(ppe.project_id)
15996: ,ppe.phase_version_id
15997: ,pps5.project_status_name
15998: ,null --Phase Short Name
15999: ,pt.attribute_category