[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.
1237: -- Fix for Bug # 4447949.
1238: , decode(ppvs.status_code, 'STRUCTURE_PUBLISHED', 'Y', 'N') -- Fix for Bug # 4447949.
1239: ,ppru.CUMULATIVE_WORK_QUANTITY
1240: -- Bug 6156686
1241: ,ppwa.wp_enable_version_flag--pa_workplan_attr_utils.check_wp_versioning_enabled(ppe.project_id)
1242: ,ppe.phase_version_id
1243: ,ppe5.name
1244: ,ppe5.element_number
1245: ,pt.attribute_category
2050: , decode(ppvs.status_code, 'STRUCTURE_PUBLISHED', 'Y', 'N') -- Fix for Bug # 4447949.
2051: ,ppru.CUMULATIVE_WORK_QUANTITY
2052: -- Bug Fix 5609629
2053: -- Replaced the following function call with local variable.
2054: -- pa_workplan_attr_utils.check_wp_versioning_enabled(ppe.project_id)
2055: , l_versioning_enabled_flag
2056: -- End of Bug Fix 5609629
2057: ,ppe.phase_version_id
2058: ,ppe5.name
2913: , decode(ppvs.status_code, 'STRUCTURE_PUBLISHED', 'Y', 'N') -- Fix for Bug # 4447949.
2914: ,ppru.CUMULATIVE_WORK_QUANTITY
2915: -- Bug Fix 5609629
2916: -- Replaced the following function call with local variable.
2917: -- pa_workplan_attr_utils.check_wp_versioning_enabled(ppe.project_id)
2918: , l_versioning_enabled_flag
2919: -- End of Bug Fix 5609629
2920: ,ppe.phase_version_id
2921: ,ppe5.name
3374:
3375: -- Bug Fix 5609629.
3376: -- Caching the wp_version_enable_flag in a local variable in order to avoid the function call
3377: -- during the insert statements. This will avoid the multiple executions of the same select.
3378: -- The project id is passed as a parameter to the pa_workplan_attr_utils.check_wp_versioning_enabled
3379: -- As the project id is not going to change during the insert statement records we can safely cache
3380: -- the value in a local variable and use that during the insert statment.
3381:
3382: l_versioning_enabled_flag pa_proj_workplan_attr.wp_enable_version_flag%TYPE;
3414: -- Bug # 4875311.
3415:
3416: -- Bug Fix 5609629
3417: -- Caching the versioning_enabled_flag attribute value locally.
3418: l_versioning_enabled_flag := pa_workplan_attr_utils.check_wp_versioning_enabled(p_project_id);
3419: -- End of Bug Fix 5609629
3420:
3421: -- ************************************************************************************************************************
3422: -- if only p_structure_version_id is passed in, populate all task records for the given structure version.
3845: , decode(ppvs.status_code, 'STRUCTURE_PUBLISHED', 'Y', 'N') -- Fix for Bug # 4447949.
3846: ,ppru.CUMULATIVE_WORK_QUANTITY
3847: -- Bug Fix 5609629
3848: -- Replaced the following function call with local variable.
3849: -- pa_workplan_attr_utils.check_wp_versioning_enabled(ppe.project_id)
3850: , l_versioning_enabled_flag
3851: -- End of Bug Fix 5609629
3852: ,ppe.phase_version_id
3853: ,ppe5.name
4670: , decode(ppvs.status_code, 'STRUCTURE_PUBLISHED', 'Y', 'N') -- Fix for Bug # 4447949.
4671: ,ppru.CUMULATIVE_WORK_QUANTITY
4672: -- Bug Fix 5609629
4673: -- Replaced the following function call with local variable.
4674: -- pa_workplan_attr_utils.check_wp_versioning_enabled(ppe.project_id)
4675: , l_versioning_enabled_flag
4676: -- End of Bug Fix 5609629
4677: ,ppe.phase_version_id
4678: ,ppe5.name
5496: , decode(ppvs.status_code, 'STRUCTURE_PUBLISHED', 'Y', 'N') -- Fix for Bug # 4447949.
5497: ,ppru.CUMULATIVE_WORK_QUANTITY
5498: -- Bug Fix 5609629
5499: -- Replaced the following function call with local variable.
5500: -- pa_workplan_attr_utils.check_wp_versioning_enabled(ppe.project_id)
5501: , l_versioning_enabled_flag
5502: -- End of Bug Fix 5609629
5503: ,ppe.phase_version_id
5504: ,ppe5.name
6014:
6015: -- Bug Fix 5609629.
6016: -- Caching the wp_version_enable_flag in a local variable in order to avoid the function call
6017: -- during the insert statements. This will avoid the multiple executions of the same select.
6018: -- The project id is passed as a parameter to the pa_workplan_attr_utils.check_wp_versioning_enabled
6019: -- As the project id is not going to change during the insert statement records we can safely cache
6020: -- the value in a local variable and use that during the insert statment.
6021:
6022: l_versioning_enabled_flag pa_proj_workplan_attr.wp_enable_version_flag%TYPE;
6086:
6087:
6088: -- Bug Fix 5609629
6089: -- Caching the versioning_enabled_flag attribute value locally.
6090: l_versioning_enabled_flag := pa_workplan_attr_utils.check_wp_versioning_enabled(p_project_id);
6091: -- End of Bug Fix 5609629
6092:
6093:
6094: -- bug 4416432: insert working structures
6481: , decode(ppvs.status_code, 'STRUCTURE_PUBLISHED', 'Y', 'N') -- Fix for Bug # 4447949.
6482: ,ppru.CUMULATIVE_WORK_QUANTITY
6483: -- Bug Fix 5609629
6484: -- Replaced the following function call with local variable.
6485: -- pa_workplan_attr_utils.check_wp_versioning_enabled(ppe.project_id)
6486: , l_versioning_enabled_flag
6487: -- End of Bug Fix 5609629
6488: ,ppe.phase_version_id
6489: ,to_char(null)
6965: , decode(ppvs.status_code, 'STRUCTURE_PUBLISHED', 'Y', 'N') -- Fix for Bug # 4447949.
6966: ,ppru.CUMULATIVE_WORK_QUANTITY
6967: -- Bug Fix 5609629
6968: -- Replaced the following function call with local variable.
6969: -- pa_workplan_attr_utils.check_wp_versioning_enabled(ppe.project_id)
6970: , l_versioning_enabled_flag
6971: -- End of Bug Fix 5609629
6972: ,ppe.phase_version_id
6973: ,to_char(null)
7444:
7445: -- Bug Fix 5609629.
7446: -- Caching the wp_version_enable_flag in a local variable in order to avoid the function call
7447: -- during the insert statements. This will avoid the multiple executions of the same select.
7448: -- The project id is passed as a parameter to the pa_workplan_attr_utils.check_wp_versioning_enabled
7449: -- As the project id is not going to change during the insert statement records we can safely cache
7450: -- the value in a local variable and use that during the insert statment.
7451:
7452: l_versioning_enabled_flag pa_proj_workplan_attr.wp_enable_version_flag%TYPE;
7477: x_return_status := FND_API.G_RET_STS_SUCCESS;
7478:
7479: -- Bug Fix 5609629
7480: -- Caching the versioning_enabled_flag attribute value locally.
7481: l_versioning_enabled_flag := pa_workplan_attr_utils.check_wp_versioning_enabled(p_project_id);
7482: -- End of Bug Fix 5609629
7483:
7484: --Populate published versions records first.
7485: INSERT INTO pa_structures_tasks_tmp
7871: , decode(ppvs.status_code, 'STRUCTURE_PUBLISHED', 'Y', 'N') -- Fix for Bug # 4447949.
7872: ,ppru.CUMULATIVE_WORK_QUANTITY
7873: -- Bug Fix 5609629
7874: -- Replaced the following function call with local variable.
7875: -- pa_workplan_attr_utils.check_wp_versioning_enabled(ppe.project_id)
7876: , l_versioning_enabled_flag
7877: -- End of Bug Fix 5609629
7878: ,ppe.phase_version_id
7879: ,ppe5.name
8204:
8205: -- Bug Fix 5609629.
8206: -- Caching the wp_version_enable_flag in a local variable in order to avoid the function call
8207: -- during the insert statements. This will avoid the multiple executions of the same select.
8208: -- The project id is passed as a parameter to the pa_workplan_attr_utils.check_wp_versioning_enabled
8209: -- As the project id is not going to change during the insert statement records we can safely cache
8210: -- the value in a local variable and use that during the insert statment.
8211:
8212: l_versioning_enabled_flag pa_proj_workplan_attr.wp_enable_version_flag%TYPE;
8237: x_return_status := FND_API.G_RET_STS_SUCCESS;
8238:
8239: -- Bug Fix 5609629
8240: -- Caching the versioning_enabled_flag attribute value locally.
8241: l_versioning_enabled_flag := pa_workplan_attr_utils.check_wp_versioning_enabled(p_project_id);
8242: -- End of Bug Fix 5609629
8243:
8244:
8245: INSERT INTO pa_structures_tasks_tmp
8630: , decode(ppvs.status_code, 'STRUCTURE_PUBLISHED', 'Y', 'N') -- Fix for Bug # 4447949.
8631: ,ppru.CUMULATIVE_WORK_QUANTITY
8632: -- Bug Fix 5609629
8633: -- Replaced the following function call with local variable.
8634: -- pa_workplan_attr_utils.check_wp_versioning_enabled(ppe.project_id)
8635: , l_versioning_enabled_flag
8636: -- End of Bug Fix 5609629
8637: ,ppe.phase_version_id
8638: ,ppe5.name
9444: , null)) estimated_remaining_effort
9445: -- Fix for Bug # 4319171.
9446: ,null -- not needed in VO PA_PROJECT_STRUCTURE_UTILS.Check_Struc_Ver_Published(ppv.project_id, ppv.parent_structure_version_id)
9447: ,ppru.CUMULATIVE_WORK_QUANTITY
9448: ,null -- not needed in VO pa_workplan_attr_utils.check_wp_versioning_enabled(ppe.project_id)
9449: ,ppe.phase_version_id
9450: ,pps5.project_status_name
9451: ,null --Phase Short Name
9452: ,pt.attribute_category
10271: , null)) estimated_remaining_effort
10272: -- Fix for Bug # 4319171.
10273: ,null -- not needed in VO PA_PROJECT_STRUCTURE_UTILS.Check_Struc_Ver_Published(ppv.project_id, ppv.parent_structure_version_id)
10274: ,ppru.CUMULATIVE_WORK_QUANTITY
10275: ,null -- not needed in VO pa_workplan_attr_utils.check_wp_versioning_enabled(ppe.project_id)
10276: ,ppe.phase_version_id
10277: ,pps5.project_status_name
10278: ,null --Phase Short Name
10279: ,pt.attribute_category
11099: , null)) estimated_remaining_effort
11100: -- Fix for Bug # 4319171.
11101: ,null -- not needed in VO PA_PROJECT_STRUCTURE_UTILS.Check_Struc_Ver_Published(ppv.project_id, ppv.parent_structure_version_id)
11102: ,ppru.CUMULATIVE_WORK_QUANTITY
11103: ,null -- not needed in VO pa_workplan_attr_utils.check_wp_versioning_enabled(ppe.project_id)
11104: ,ppe.phase_version_id
11105: ,pps5.project_status_name
11106: ,null --Phase Short Name
11107: ,pt.attribute_category
12062: , null)) estimated_remaining_effort
12063: -- Fix for Bug # 4319171.
12064: ,null -- not needed in VO PA_PROJECT_STRUCTURE_UTILS.Check_Struc_Ver_Published(ppv.project_id, ppv.parent_structure_version_id)
12065: ,ppru.CUMULATIVE_WORK_QUANTITY
12066: ,null -- not needed in VO pa_workplan_attr_utils.check_wp_versioning_enabled(ppe.project_id)
12067: ,ppe.phase_version_id
12068: ,pps5.project_status_name
12069: ,null --Phase Short Name
12070: ,pt.attribute_category
12858: , null)) estimated_remaining_effort
12859: -- Fix for Bug # 4319171.
12860: ,null -- not needed in VO PA_PROJECT_STRUCTURE_UTILS.Check_Struc_Ver_Published(ppv.project_id, ppv.parent_structure_version_id)
12861: ,ppru.CUMULATIVE_WORK_QUANTITY
12862: ,null -- not needed in VO pa_workplan_attr_utils.check_wp_versioning_enabled(ppe.project_id)
12863: ,ppe.phase_version_id
12864: ,pps5.project_status_name
12865: ,null --Phase Short Name
12866: ,pt.attribute_category
13655: , null)) estimated_remaining_effort
13656: -- Fix for Bug # 4319171.
13657: ,null -- not needed in VO PA_PROJECT_STRUCTURE_UTILS.Check_Struc_Ver_Published(ppv.project_id, ppv.parent_structure_version_id)
13658: ,ppru.CUMULATIVE_WORK_QUANTITY
13659: ,null -- not needed in VO pa_workplan_attr_utils.check_wp_versioning_enabled(ppe.project_id)
13660: ,ppe.phase_version_id
13661: ,pps5.project_status_name
13662: ,null --Phase Short Name
13663: ,pt.attribute_category