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.

[Home] [Help]

APPS.PA_PROGRESS_PVT dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 122: , pa_proj_element_versions ppev

118: and relationship_type = 'S'
119: connect by prior object_id_from1 = object_id_to1
120: and relationship_type = 'S'
121: ) pobj
122: , pa_proj_element_versions ppev
123: WHERE element_version_id = object_id_to1
124: and p_rollup_entire_wbs='N'
125: --select structure
126: UNION

Line 128: FROM pa_proj_element_versions

124: and p_rollup_entire_wbs='N'
125: --select structure
126: UNION
127: SELECT proj_element_id, element_version_id, object_type
128: FROM pa_proj_element_versions
129: WHERE element_version_id = p_structure_version_id
130: and project_id = p_project_id
131: and object_type = 'PA_STRUCTURES'
132: and p_rollup_entire_wbs='N'

Line 135: FROM pa_proj_element_versions

131: and object_type = 'PA_STRUCTURES'
132: and p_rollup_entire_wbs='N'
133: UNION
134: SELECT proj_element_id, element_version_id, object_type
135: FROM pa_proj_element_versions
136: WHERE project_id = p_project_id
137: and parent_structure_version_id = p_structure_version_id
138: and object_type IN ('PA_TASKS','PA_STRUCTURES')
139: and p_rollup_entire_wbs='Y'

Line 474: FROM pa_proj_element_versions ppev,

470: , ppr.structure_version_id
471: ,'N' create_required
472: ,'N' update_required
473: , ppr.base_percent_complete -- 4392189 : Program Reporting Changes - Phase 2
474: FROM pa_proj_element_versions ppev,
475: pa_progress_rollup ppr,
476: pa_project_statuses pps1,
477: pa_project_statuses pps2,
478: pa_project_statuses pps3 ,

Line 597: pa_proj_element_versions ppev1,

593: ,'N' update_required
594: , ppr.base_percent_complete -- 4392189 : Program Reporting Changes - Phase 2
595: FROM
596: pa_object_relationships pobj,
597: pa_proj_element_versions ppev1,
598: pa_proj_element_versions ppev2,
599: pa_progress_rollup ppr,
600: pa_proj_elements ppe,
601: pa_project_statuses pps1,

Line 598: pa_proj_element_versions ppev2,

594: , ppr.base_percent_complete -- 4392189 : Program Reporting Changes - Phase 2
595: FROM
596: pa_object_relationships pobj,
597: pa_proj_element_versions ppev1,
598: pa_proj_element_versions ppev2,
599: pa_progress_rollup ppr,
600: pa_proj_elements ppe,
601: pa_project_statuses pps1,
602: pa_project_statuses pps2,

Line 731: FROM pa_proj_element_versions ppev , pa_proj_rollup_temp temp

727: , to_number(null) structure_version_id
728: ,'N' create_required
729: ,'N' update_required
730: , to_number(null) base_percent_complete -- 4392189 : Program Reporting Changes - Phase 2
731: FROM pa_proj_element_versions ppev , pa_proj_rollup_temp temp
732: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
733: --IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
734: element_version_id = temp.object_id
735: AND temp.process_number = l_process_number_temp

Line 840: pa_proj_element_versions ppev1,

836: ,'N' update_required
837: , to_number(null) base_percent_complete -- 4392189 : Program Reporting Changes - Phase 2
838: FROM
839: pa_object_relationships pobj,
840: pa_proj_element_versions ppev1,
841: pa_proj_element_versions ppev2,
842: pa_proj_elements ppe,
843: pa_project_statuses pps4,
844: pa_task_types ttype ,

Line 841: pa_proj_element_versions ppev2,

837: , to_number(null) base_percent_complete -- 4392189 : Program Reporting Changes - Phase 2
838: FROM
839: pa_object_relationships pobj,
840: pa_proj_element_versions ppev1,
841: pa_proj_element_versions ppev2,
842: pa_proj_elements ppe,
843: pa_project_statuses pps4,
844: pa_task_types ttype ,
845: pa_proj_rollup_temp temp

Line 1247: FROM pa_proj_element_versions

1243:
1244: CURSOR cur_get_deepest_task(c_structure_version_id number, c_project_id number)
1245: IS
1246: SELECT element_version_id
1247: FROM pa_proj_element_versions
1248: where project_id = c_project_id
1249: and object_type = 'PA_TASKS'
1250: AND parent_structure_version_id = c_structure_version_id
1251: AND wbs_level = (Select max(wbs_level)

Line 1252: From pa_proj_element_versions

1248: where project_id = c_project_id
1249: and object_type = 'PA_TASKS'
1250: AND parent_structure_version_id = c_structure_version_id
1251: AND wbs_level = (Select max(wbs_level)
1252: From pa_proj_element_versions
1253: where project_id = c_project_id
1254: and object_type = 'PA_TASKS'
1255: AND parent_structure_version_id = c_structure_version_id);
1256:

Line 1266: select 'Y' from pa_proj_element_versions ppev1

1262: l_base_struct_ver_id NUMBER;
1263:
1264: CURSOR check_task_baselined(c_structure_ver_id NUMBER, c_task_version_id NUMBER)
1265: IS
1266: select 'Y' from pa_proj_element_versions ppev1
1267: where ppev1.parent_structure_version_id = c_structure_ver_id
1268: and ppev1.proj_element_id = (select proj_element_id from pa_proj_element_versions ppev2
1269: where ppev2.element_version_id = c_task_version_id
1270: and ppev2.project_id = p_project_id);

Line 1268: and ppev1.proj_element_id = (select proj_element_id from pa_proj_element_versions ppev2

1264: CURSOR check_task_baselined(c_structure_ver_id NUMBER, c_task_version_id NUMBER)
1265: IS
1266: select 'Y' from pa_proj_element_versions ppev1
1267: where ppev1.parent_structure_version_id = c_structure_ver_id
1268: and ppev1.proj_element_id = (select proj_element_id from pa_proj_element_versions ppev2
1269: where ppev2.element_version_id = c_task_version_id
1270: and ppev2.project_id = p_project_id);
1271:
1272: l_task_baselined VARCHAR2(1) := 'N';

Line 1285: , pa_proj_element_versions ver

1281: CURSOR cur_tree_rollup_dates
1282: IS
1283: select /*+ leading (ROLLUP) */ ppr.as_of_date, ver2.proj_element_id child_task_id, ver2.element_version_id child_task_ver_id
1284: from pa_object_relationships obj
1285: , pa_proj_element_versions ver
1286: , pa_progress_rollup ppr
1287: , pa_proj_rollup_temp rollup
1288: , pa_proj_element_versions ver2
1289: where rollup.object_id = obj.object_id_to1

Line 1288: , pa_proj_element_versions ver2

1284: from pa_object_relationships obj
1285: , pa_proj_element_versions ver
1286: , pa_progress_rollup ppr
1287: , pa_proj_rollup_temp rollup
1288: , pa_proj_element_versions ver2
1289: where rollup.object_id = obj.object_id_to1
1290: AND rollup.process_number = l_process_number_temp
1291: AND obj.relationship_type = 'S'
1292: AND obj.object_type_from IN ('PA_STRUCTURES' ,'PA_TASKS')

Line 1320: pa_proj_element_versions ppv2

1316: ,ppv2.proj_element_id sub_proj_element_id
1317: , pa_progress_utils.Get_BAC_Value(ppv2.project_id, c_task_per_comp_deriv_method, ppv2.proj_element_id, ppv2.parent_structure_version_id,
1318: 'WORKPLAN','N') sub_project_bac_value
1319: FROM
1320: pa_proj_element_versions ppv2
1321: ,pa_proj_elem_ver_structure ppevs2
1322: ,pa_object_relationships por1
1323: ,pa_object_relationships por2
1324: WHERE

Line 1589: FROM pa_proj_element_versions

1585: l_mass_rollup_prog_rec_tab.delete;
1586: ELSE
1587: INSERT INTO pa_proj_rollup_temp(process_number, object_id, object_type, wbs_level)
1588: SELECT l_process_number_temp, element_version_id object_id_from1, 'PA_TASKS', 1
1589: FROM pa_proj_element_versions
1590: WHERE project_id = p_project_id
1591: AND parent_structure_version_id = p_structure_version_id
1592: --AND PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(element_version_id) = 'N'
1593: -- 4490532 : changed from IS_LOWEST_TASK to is_summary_task_or_structure

Line 4181: ) pobj, pa_proj_element_versions ppev

4177: --and relationship_type = 'S' -- Bug 3603636
4178: and relationship_type = 'S' -- Bug 4122809 : Added this
4179: connect by prior object_id_from1 = object_id_to1
4180: and relationship_type = 'S' -- Bug 3958686
4181: ) pobj, pa_proj_element_versions ppev
4182: WHERE element_version_id = object_id_to1
4183: AND p_rollup_entire_wbs='N'
4184: UNION -- AMG Changes
4185: SELECT ever.proj_element_id, obj.object_id_from1 object_id_from1, ever.element_version_id object_id_to1, ever.object_type object_type

Line 4186: FROM pa_proj_element_versions ever

4182: WHERE element_version_id = object_id_to1
4183: AND p_rollup_entire_wbs='N'
4184: UNION -- AMG Changes
4185: SELECT ever.proj_element_id, obj.object_id_from1 object_id_from1, ever.element_version_id object_id_to1, ever.object_type object_type
4186: FROM pa_proj_element_versions ever
4187: , pa_object_relationships obj
4188: WHERE ever.project_id = p_project_id
4189: and ever.parent_structure_version_id = p_structure_version_id
4190: -- 4490532 : changed from IS_LOWEST_TASK to is_summary_task_or_structure

Line 4246: from pa_proj_element_versions

4242:
4243: For cur_tree_rec in cur_reverse_tree loop
4244:
4245: select proj_element_id into l_object_id
4246: from pa_proj_element_versions
4247: where element_version_id = cur_tree_rec.object_id_from1;
4248:
4249: IF g1_debug_mode = 'Y' THEN
4250: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ROLLUP_FUTURE_PROGRESS_PVT', x_Msg => 'l_object_id'||l_object_id, x_Log_Level=> 3);

Line 4410: pa_proj_element_versions ppv1

4406: ,ppv1.parent_structure_version_id PARENT_STRUCTURE_VER_ID
4407: ,ppv1.element_version_id PARENT_TASK_VERSION_ID
4408: ,ppv1.proj_element_id PARENT_TASK_ID
4409: FROM
4410: pa_proj_element_versions ppv1
4411: ,pa_proj_elem_ver_structure ppevs1
4412: ,pa_proj_element_versions ppv2
4413: ,pa_proj_elem_ver_structure ppevs2
4414: ,pa_object_relationships por1

Line 4412: ,pa_proj_element_versions ppv2

4408: ,ppv1.proj_element_id PARENT_TASK_ID
4409: FROM
4410: pa_proj_element_versions ppv1
4411: ,pa_proj_elem_ver_structure ppevs1
4412: ,pa_proj_element_versions ppv2
4413: ,pa_proj_elem_ver_structure ppevs2
4414: ,pa_object_relationships por1
4415: ,pa_object_relationships por2
4416: WHERE

Line 5718: FROM pa_proj_element_versions ppev,

5714: , ppr.Oth_quantity_to_date
5715: , ppr.Oth_etc_quantity
5716: -- 4533112 : Added base_progress_status_code
5717: , decode(ppr.base_progress_status_code, 'Y' , 'Y', 'N') base_progress_status_code
5718: FROM pa_proj_element_versions ppev,
5719: pa_object_relationships obj,
5720: pa_progress_rollup ppr,
5721: pa_project_statuses pps1,
5722: pa_project_statuses pps2,

Line 5886: FROM pa_proj_element_versions ppev

5882: , to_number(null) Oth_quantity_to_date
5883: , to_number(null) Oth_etc_quantity
5884: -- 4533112 : Added base_progress_status_code
5885: , 'N' base_progress_status_code
5886: FROM pa_proj_element_versions ppev
5887: WHERE ppev.element_version_id = c_task_ver_id
5888: AND ppev.object_type = 'PA_TASKS'
5889: -- Bug 3879461 Begin
5890: AND NOT EXISTS (SELECT 1

Line 6022: FROM pa_proj_element_versions ppev1,

6018: , ppr.Oth_quantity_to_date
6019: , ppr.Oth_etc_quantity
6020: -- 4533112 : Added base_progress_status_code
6021: , decode(ppr.base_progress_status_code,'Y','Y','N') base_progress_status_code
6022: FROM pa_proj_element_versions ppev1,
6023: pa_proj_element_versions ppev2,
6024: pa_object_relationships obj,
6025: pa_progress_rollup ppr,
6026: pa_project_statuses pps1,

Line 6023: pa_proj_element_versions ppev2,

6019: , ppr.Oth_etc_quantity
6020: -- 4533112 : Added base_progress_status_code
6021: , decode(ppr.base_progress_status_code,'Y','Y','N') base_progress_status_code
6022: FROM pa_proj_element_versions ppev1,
6023: pa_proj_element_versions ppev2,
6024: pa_object_relationships obj,
6025: pa_progress_rollup ppr,
6026: pa_project_statuses pps1,
6027: pa_project_statuses pps2,

Line 6189: FROM pa_proj_element_versions ppev1,

6185: , to_number(null) Oth_quantity_to_date
6186: , to_number(null) Oth_etc_quantity
6187: -- 4533112 : Added base_progress_status_code
6188: , 'N' base_progress_status_code
6189: FROM pa_proj_element_versions ppev1,
6190: pa_proj_element_versions ppev2,
6191: pa_object_relationships obj,
6192: pji_fm_xbs_accum_tmp1 pfxat,
6193: pa_proj_elements ppe -- 4392189

Line 6190: pa_proj_element_versions ppev2,

6186: , to_number(null) Oth_etc_quantity
6187: -- 4533112 : Added base_progress_status_code
6188: , 'N' base_progress_status_code
6189: FROM pa_proj_element_versions ppev1,
6190: pa_proj_element_versions ppev2,
6191: pa_object_relationships obj,
6192: pji_fm_xbs_accum_tmp1 pfxat,
6193: pa_proj_elements ppe -- 4392189
6194: WHERE obj.object_id_from1 = c_task_ver_id

Line 6760: pa_proj_element_versions ppv2

6756: ,ppv2.proj_element_id sub_proj_element_id
6757: , pa_progress_utils.Get_BAC_Value(ppv2.project_id, c_task_per_comp_deriv_method, ppv2.proj_element_id, ppv2.parent_structure_version_id,
6758: 'WORKPLAN','N') sub_project_bac_value
6759: FROM
6760: pa_proj_element_versions ppv2
6761: ,pa_proj_elem_ver_structure ppevs2
6762: ,pa_object_relationships por1
6763: ,pa_object_relationships por2
6764: WHERE

Line 9109: , pa_proj_element_versions ver

9105: , obj2.object_id_to2 subprj_id
9106: , ver.proj_element_id subprj_proj_elem_id
9107: from pa_object_relationships obj1
9108: , pa_object_relationships obj2
9109: , pa_proj_element_versions ver
9110: WHERE obj1.object_id_from1 = p_object_version_id
9111: AND obj1.relationship_type = 'S'
9112: AND obj1.object_id_to1 = obj2.object_id_from1
9113: AND obj2.relationship_type = 'LW'

Line 9725: ,p_source_struct_ver_id IN pa_proj_element_versions.element_version_id%TYPE

9721:
9722: PROCEDURE copy_actuals_for_workplan(
9723: p_calling_context IN VARCHAR2 DEFAULT 'WP_PROGRESS'
9724: ,p_project_id IN pa_projects_all.project_id%TYPE
9725: ,p_source_struct_ver_id IN pa_proj_element_versions.element_version_id%TYPE
9726: ,p_target_struct_ver_id IN pa_proj_element_versions.element_version_id%TYPE
9727: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
9728: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
9729: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 9726: ,p_target_struct_ver_id IN pa_proj_element_versions.element_version_id%TYPE

9722: PROCEDURE copy_actuals_for_workplan(
9723: p_calling_context IN VARCHAR2 DEFAULT 'WP_PROGRESS'
9724: ,p_project_id IN pa_projects_all.project_id%TYPE
9725: ,p_source_struct_ver_id IN pa_proj_element_versions.element_version_id%TYPE
9726: ,p_target_struct_ver_id IN pa_proj_element_versions.element_version_id%TYPE
9727: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
9728: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
9729: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
9730: AS

Line 10261: FROM pa_proj_element_versions a,

10257: a.project_id
10258: , a.element_version_id
10259: , a.prg_level
10260: , ppr.as_of_date
10261: FROM pa_proj_element_versions a,
10262: pa_proj_elem_ver_structure b,
10263: pa_proj_structure_types ppst,
10264: pa_proj_element_versions c,
10265: pa_progress_rollup ppr

Line 10264: pa_proj_element_versions c,

10260: , ppr.as_of_date
10261: FROM pa_proj_element_versions a,
10262: pa_proj_elem_ver_structure b,
10263: pa_proj_structure_types ppst,
10264: pa_proj_element_versions c,
10265: pa_progress_rollup ppr
10266: WHERE
10267: c.project_id = p_project_id
10268: AND c.element_version_id = p_structure_version_id ---5095632

Line 10293: FROM pa_proj_element_versions a,

10289: a.project_id
10290: , a.element_version_id
10291: , a.prg_level
10292: , ppr.as_of_date
10293: FROM pa_proj_element_versions a,
10294: pa_proj_elem_ver_structure b,
10295: pa_proj_structure_types ppst,
10296: pa_proj_element_versions c,
10297: pa_progress_rollup ppr

Line 10296: pa_proj_element_versions c,

10292: , ppr.as_of_date
10293: FROM pa_proj_element_versions a,
10294: pa_proj_elem_ver_structure b,
10295: pa_proj_structure_types ppst,
10296: pa_proj_element_versions c,
10297: pa_progress_rollup ppr
10298: WHERE
10299: c.project_id = p_project_id
10300: AND c.element_version_id = p_structure_version_id -- Backported performance fix from R12 bug 5095632

Line 10478: cursor obj_version_id (x_str_ver_id pa_proj_element_versions.element_version_id%type)is

10474: and element_version_id = p_str_ver_id_to_del));
10475:
10476: l_str_ver_id number;
10477: -- Begin. Bug 5452282
10478: cursor obj_version_id (x_str_ver_id pa_proj_element_versions.element_version_id%type)is
10479: select ppev.element_version_id old_element_version_id,
10480: ppev1.element_version_id new_element_version_id,
10481: ppev.proj_element_id
10482: from pa_proj_element_versions ppev,

Line 10482: from pa_proj_element_versions ppev,

10478: cursor obj_version_id (x_str_ver_id pa_proj_element_versions.element_version_id%type)is
10479: select ppev.element_version_id old_element_version_id,
10480: ppev1.element_version_id new_element_version_id,
10481: ppev.proj_element_id
10482: from pa_proj_element_versions ppev,
10483: pa_proj_element_versions ppev1
10484: where ppev.project_id = p_project_id
10485: and ppev.parent_structure_version_id = p_str_ver_id_to_del
10486: and ppev.proj_element_id = ppev1.proj_element_id

Line 10483: pa_proj_element_versions ppev1

10479: select ppev.element_version_id old_element_version_id,
10480: ppev1.element_version_id new_element_version_id,
10481: ppev.proj_element_id
10482: from pa_proj_element_versions ppev,
10483: pa_proj_element_versions ppev1
10484: where ppev.project_id = p_project_id
10485: and ppev.parent_structure_version_id = p_str_ver_id_to_del
10486: and ppev.proj_element_id = ppev1.proj_element_id
10487: and ppev1.parent_structure_version_id = x_str_ver_id;

Line 10633: , pa_proj_element_versions ppev

10629: and relationship_type = 'S'
10630: connect by prior object_id_from1 = object_id_to1
10631: and relationship_type = 'S'
10632: ) pobj
10633: , pa_proj_element_versions ppev
10634: WHERE element_version_id = object_id_to1
10635: and p_rollup_entire_wbs='N'
10636: --select structure
10637: UNION

Line 10639: FROM pa_proj_element_versions

10635: and p_rollup_entire_wbs='N'
10636: --select structure
10637: UNION
10638: SELECT proj_element_id, element_version_id, object_type
10639: FROM pa_proj_element_versions
10640: WHERE element_version_id = p_structure_version_id
10641: and project_id = p_project_id
10642: and object_type = 'PA_STRUCTURES'
10643: and p_rollup_entire_wbs='N'

Line 10646: FROM pa_proj_element_versions

10642: and object_type = 'PA_STRUCTURES'
10643: and p_rollup_entire_wbs='N'
10644: UNION
10645: SELECT proj_element_id, element_version_id, object_type
10646: FROM pa_proj_element_versions
10647: WHERE project_id = p_project_id
10648: and parent_structure_version_id = p_structure_version_id
10649: and object_type IN ('PA_TASKS','PA_STRUCTURES')
10650: and p_rollup_entire_wbs='Y'

Line 10985: FROM pa_proj_element_versions ppev,

10981: , ppr.structure_version_id
10982: ,'N' create_required
10983: ,'N' update_required
10984: , ppr.base_percent_complete -- 4392189 : Program Reporting Changes - Phase 2
10985: FROM pa_proj_element_versions ppev,
10986: pa_progress_rollup ppr,
10987: pa_project_statuses pps1,
10988: pa_project_statuses pps2,
10989: pa_project_statuses pps3 ,

Line 11108: pa_proj_element_versions ppev1,

11104: ,'N' update_required
11105: , ppr.base_percent_complete -- 4392189 : Program Reporting Changes - Phase 2
11106: FROM
11107: pa_object_relationships pobj,
11108: pa_proj_element_versions ppev1,
11109: pa_proj_element_versions ppev2,
11110: pa_progress_rollup ppr,
11111: pa_proj_elements ppe,
11112: pa_project_statuses pps1,

Line 11109: pa_proj_element_versions ppev2,

11105: , ppr.base_percent_complete -- 4392189 : Program Reporting Changes - Phase 2
11106: FROM
11107: pa_object_relationships pobj,
11108: pa_proj_element_versions ppev1,
11109: pa_proj_element_versions ppev2,
11110: pa_progress_rollup ppr,
11111: pa_proj_elements ppe,
11112: pa_project_statuses pps1,
11113: pa_project_statuses pps2,

Line 11242: FROM pa_proj_element_versions ppev , pa_proj_rollup_temp temp

11238: , to_number(null) structure_version_id
11239: ,'N' create_required
11240: ,'N' update_required
11241: , to_number(null) base_percent_complete -- 4392189 : Program Reporting Changes - Phase 2
11242: FROM pa_proj_element_versions ppev , pa_proj_rollup_temp temp
11243: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
11244: --IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
11245: element_version_id = temp.object_id
11246: AND temp.process_number = l_process_number_temp

Line 11351: pa_proj_element_versions ppev1,

11347: ,'N' update_required
11348: , to_number(null) base_percent_complete -- 4392189 : Program Reporting Changes - Phase 2
11349: FROM
11350: pa_object_relationships pobj,
11351: pa_proj_element_versions ppev1,
11352: pa_proj_element_versions ppev2,
11353: pa_proj_elements ppe,
11354: pa_project_statuses pps4,
11355: pa_task_types ttype ,

Line 11352: pa_proj_element_versions ppev2,

11348: , to_number(null) base_percent_complete -- 4392189 : Program Reporting Changes - Phase 2
11349: FROM
11350: pa_object_relationships pobj,
11351: pa_proj_element_versions ppev1,
11352: pa_proj_element_versions ppev2,
11353: pa_proj_elements ppe,
11354: pa_project_statuses pps4,
11355: pa_task_types ttype ,
11356: pa_proj_rollup_temp temp

Line 11516: FROM pa_proj_element_versions

11512:
11513: CURSOR cur_get_deepest_task(c_structure_version_id number, c_project_id number)
11514: IS
11515: SELECT element_version_id
11516: FROM pa_proj_element_versions
11517: where project_id = c_project_id
11518: and object_type = 'PA_TASKS'
11519: AND parent_structure_version_id = c_structure_version_id
11520: AND wbs_level = (Select max(wbs_level)

Line 11521: From pa_proj_element_versions

11517: where project_id = c_project_id
11518: and object_type = 'PA_TASKS'
11519: AND parent_structure_version_id = c_structure_version_id
11520: AND wbs_level = (Select max(wbs_level)
11521: From pa_proj_element_versions
11522: where project_id = c_project_id
11523: and object_type = 'PA_TASKS'
11524: AND parent_structure_version_id = c_structure_version_id);
11525:

Line 11535: select 'Y' from pa_proj_element_versions ppev1

11531: l_base_struct_ver_id NUMBER;
11532:
11533: CURSOR check_task_baselined(c_structure_ver_id NUMBER, c_task_version_id NUMBER)
11534: IS
11535: select 'Y' from pa_proj_element_versions ppev1
11536: where ppev1.parent_structure_version_id = c_structure_ver_id
11537: and ppev1.proj_element_id = (select proj_element_id from pa_proj_element_versions ppev2
11538: where ppev2.element_version_id = c_task_version_id
11539: and ppev2.project_id = p_project_id);

Line 11537: and ppev1.proj_element_id = (select proj_element_id from pa_proj_element_versions ppev2

11533: CURSOR check_task_baselined(c_structure_ver_id NUMBER, c_task_version_id NUMBER)
11534: IS
11535: select 'Y' from pa_proj_element_versions ppev1
11536: where ppev1.parent_structure_version_id = c_structure_ver_id
11537: and ppev1.proj_element_id = (select proj_element_id from pa_proj_element_versions ppev2
11538: where ppev2.element_version_id = c_task_version_id
11539: and ppev2.project_id = p_project_id);
11540:
11541: l_task_baselined VARCHAR2(1) := 'N';

Line 11554: , pa_proj_element_versions ver

11550: CURSOR cur_tree_rollup_dates
11551: IS
11552: select /*+ leading (ROLLUP) */ ppr.as_of_date, ver2.proj_element_id child_task_id, ver2.element_version_id child_task_ver_id
11553: from pa_object_relationships obj
11554: , pa_proj_element_versions ver
11555: , pa_progress_rollup ppr
11556: , pa_proj_rollup_temp rollup
11557: , pa_proj_element_versions ver2
11558: where rollup.object_id = obj.object_id_to1

Line 11557: , pa_proj_element_versions ver2

11553: from pa_object_relationships obj
11554: , pa_proj_element_versions ver
11555: , pa_progress_rollup ppr
11556: , pa_proj_rollup_temp rollup
11557: , pa_proj_element_versions ver2
11558: where rollup.object_id = obj.object_id_to1
11559: AND rollup.process_number = l_process_number_temp
11560: AND obj.relationship_type = 'S'
11561: AND obj.object_type_from IN ('PA_STRUCTURES' ,'PA_TASKS')

Line 11589: pa_proj_element_versions ppv2

11585: ,ppv2.proj_element_id sub_proj_element_id
11586: , pa_progress_utils.Get_BAC_Value(ppv2.project_id, c_task_per_comp_deriv_method, ppv2.proj_element_id, ppv2.parent_structure_version_id,
11587: 'WORKPLAN','N') sub_project_bac_value
11588: FROM
11589: pa_proj_element_versions ppv2
11590: ,pa_proj_elem_ver_structure ppevs2
11591: ,pa_object_relationships por1
11592: ,pa_object_relationships por2
11593: WHERE

Line 11708: from PA_PROJ_ELEMENT_VERSIONS p where p.project_id = c_project_id and defer_code in ( 'P','S'))

11704: SELECT object_id_from1
11705: FROM pa_object_relationships
11706: WHERE relationship_type = 'S'
11707: START WITH object_id_to1 in (select p.element_version_id
11708: from PA_PROJ_ELEMENT_VERSIONS p where p.project_id = c_project_id and defer_code in ( 'P','S'))
11709: AND relationship_type = 'S'
11710: CONNECT BY PRIOR object_id_from1 = object_id_to1
11711: AND relationship_type = 'S';
11712:

Line 11892: FROM pa_proj_element_versions

11888: l_mass_rollup_prog_rec_tab.delete;
11889: ELSE
11890: INSERT INTO pa_proj_rollup_temp(process_number, object_id, object_type, wbs_level)
11891: SELECT l_process_number_temp, element_version_id object_id_from1, 'PA_TASKS', 1
11892: FROM pa_proj_element_versions
11893: WHERE project_id = p_project_id
11894: AND parent_structure_version_id = p_structure_version_id
11895: AND PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(element_version_id) = 'Y'
11896: AND object_type = 'PA_TASKS'

Line 14193: , pa_proj_element_versions ppev

14189: and relationship_type = 'S'
14190: connect by prior object_id_from1 = object_id_to1
14191: and relationship_type = 'S'
14192: ) pobj
14193: , pa_proj_element_versions ppev
14194: WHERE element_version_id = object_id_to1
14195: and p_rollup_entire_wbs='N'
14196: --select structure
14197: UNION

Line 14199: FROM pa_proj_element_versions

14195: and p_rollup_entire_wbs='N'
14196: --select structure
14197: UNION
14198: SELECT proj_element_id, element_version_id, object_type
14199: FROM pa_proj_element_versions
14200: WHERE element_version_id = p_structure_version_id
14201: and project_id = p_project_id
14202: and object_type = 'PA_STRUCTURES'
14203: and p_rollup_entire_wbs='N'

Line 14206: FROM pa_proj_element_versions

14202: and object_type = 'PA_STRUCTURES'
14203: and p_rollup_entire_wbs='N'
14204: UNION
14205: SELECT proj_element_id, element_version_id, object_type
14206: FROM pa_proj_element_versions
14207: WHERE project_id = p_project_id
14208: and parent_structure_version_id = p_structure_version_id
14209: and object_type IN ('PA_TASKS','PA_STRUCTURES')
14210: and p_rollup_entire_wbs='Y'

Line 14545: FROM pa_proj_element_versions ppev,

14541: , ppr.structure_version_id
14542: ,'N' create_required
14543: ,'N' update_required
14544: , ppr.base_percent_complete -- 4392189 : Program Reporting Changes - Phase 2
14545: FROM pa_proj_element_versions ppev,
14546: pa_progress_rollup ppr,
14547: pa_project_statuses pps1,
14548: pa_project_statuses pps2,
14549: pa_project_statuses pps3 ,

Line 14668: pa_proj_element_versions ppev1,

14664: ,'N' update_required
14665: , ppr.base_percent_complete -- 4392189 : Program Reporting Changes - Phase 2
14666: FROM
14667: pa_object_relationships pobj,
14668: pa_proj_element_versions ppev1,
14669: pa_proj_element_versions ppev2,
14670: pa_progress_rollup ppr,
14671: pa_proj_elements ppe,
14672: pa_project_statuses pps1,

Line 14669: pa_proj_element_versions ppev2,

14665: , ppr.base_percent_complete -- 4392189 : Program Reporting Changes - Phase 2
14666: FROM
14667: pa_object_relationships pobj,
14668: pa_proj_element_versions ppev1,
14669: pa_proj_element_versions ppev2,
14670: pa_progress_rollup ppr,
14671: pa_proj_elements ppe,
14672: pa_project_statuses pps1,
14673: pa_project_statuses pps2,

Line 14802: FROM pa_proj_element_versions ppev , pa_proj_rollup_temp temp

14798: , to_number(null) structure_version_id
14799: ,'N' create_required
14800: ,'N' update_required
14801: , to_number(null) base_percent_complete -- 4392189 : Program Reporting Changes - Phase 2
14802: FROM pa_proj_element_versions ppev , pa_proj_rollup_temp temp
14803: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
14804: --IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
14805: element_version_id = temp.object_id
14806: AND temp.process_number = l_process_number_temp

Line 14911: pa_proj_element_versions ppev1,

14907: ,'N' update_required
14908: , to_number(null) base_percent_complete -- 4392189 : Program Reporting Changes - Phase 2
14909: FROM
14910: pa_object_relationships pobj,
14911: pa_proj_element_versions ppev1,
14912: pa_proj_element_versions ppev2,
14913: pa_proj_elements ppe,
14914: pa_project_statuses pps4,
14915: pa_task_types ttype ,

Line 14912: pa_proj_element_versions ppev2,

14908: , to_number(null) base_percent_complete -- 4392189 : Program Reporting Changes - Phase 2
14909: FROM
14910: pa_object_relationships pobj,
14911: pa_proj_element_versions ppev1,
14912: pa_proj_element_versions ppev2,
14913: pa_proj_elements ppe,
14914: pa_project_statuses pps4,
14915: pa_task_types ttype ,
14916: pa_proj_rollup_temp temp

Line 15077: FROM pa_proj_element_versions

15073:
15074: CURSOR cur_get_deepest_task(c_structure_version_id number, c_project_id number)
15075: IS
15076: SELECT element_version_id
15077: FROM pa_proj_element_versions
15078: where project_id = c_project_id
15079: and object_type = 'PA_TASKS'
15080: AND parent_structure_version_id = c_structure_version_id
15081: AND wbs_level = (Select max(wbs_level)

Line 15082: From pa_proj_element_versions

15078: where project_id = c_project_id
15079: and object_type = 'PA_TASKS'
15080: AND parent_structure_version_id = c_structure_version_id
15081: AND wbs_level = (Select max(wbs_level)
15082: From pa_proj_element_versions
15083: where project_id = c_project_id
15084: and object_type = 'PA_TASKS'
15085: AND parent_structure_version_id = c_structure_version_id);
15086:

Line 15096: select 'Y' from pa_proj_element_versions ppev1

15092: l_base_struct_ver_id NUMBER;
15093:
15094: CURSOR check_task_baselined(c_structure_ver_id NUMBER, c_task_version_id NUMBER)
15095: IS
15096: select 'Y' from pa_proj_element_versions ppev1
15097: where ppev1.parent_structure_version_id = c_structure_ver_id
15098: and ppev1.proj_element_id = (select proj_element_id from pa_proj_element_versions ppev2
15099: where ppev2.element_version_id = c_task_version_id
15100: and ppev2.project_id = p_project_id);

Line 15098: and ppev1.proj_element_id = (select proj_element_id from pa_proj_element_versions ppev2

15094: CURSOR check_task_baselined(c_structure_ver_id NUMBER, c_task_version_id NUMBER)
15095: IS
15096: select 'Y' from pa_proj_element_versions ppev1
15097: where ppev1.parent_structure_version_id = c_structure_ver_id
15098: and ppev1.proj_element_id = (select proj_element_id from pa_proj_element_versions ppev2
15099: where ppev2.element_version_id = c_task_version_id
15100: and ppev2.project_id = p_project_id);
15101:
15102: l_task_baselined VARCHAR2(1) := 'N';

Line 15115: , pa_proj_element_versions ver

15111: CURSOR cur_tree_rollup_dates
15112: IS
15113: select /*+ leading (ROLLUP) */ ppr.as_of_date, ver2.proj_element_id child_task_id, ver2.element_version_id child_task_ver_id
15114: from pa_object_relationships obj
15115: , pa_proj_element_versions ver
15116: , pa_progress_rollup ppr
15117: , pa_proj_rollup_temp rollup
15118: , pa_proj_element_versions ver2
15119: where rollup.object_id = obj.object_id_to1

Line 15118: , pa_proj_element_versions ver2

15114: from pa_object_relationships obj
15115: , pa_proj_element_versions ver
15116: , pa_progress_rollup ppr
15117: , pa_proj_rollup_temp rollup
15118: , pa_proj_element_versions ver2
15119: where rollup.object_id = obj.object_id_to1
15120: AND rollup.process_number = l_process_number_temp
15121: AND obj.relationship_type = 'S'
15122: AND obj.object_type_from IN ('PA_STRUCTURES' ,'PA_TASKS')

Line 15150: pa_proj_element_versions ppv2

15146: ,ppv2.proj_element_id sub_proj_element_id
15147: , pa_progress_utils.Get_BAC_Value(ppv2.project_id, c_task_per_comp_deriv_method, ppv2.proj_element_id, ppv2.parent_structure_version_id,
15148: 'WORKPLAN','N') sub_project_bac_value
15149: FROM
15150: pa_proj_element_versions ppv2
15151: ,pa_proj_elem_ver_structure ppevs2
15152: ,pa_object_relationships por1
15153: ,pa_object_relationships por2
15154: WHERE

Line 15271: from PA_PROJ_ELEMENT_VERSIONS p where p.project_id = c_project_id and defer_code in ( 'P','S'))

15267: SELECT object_id_from1
15268: FROM pa_object_relationships
15269: WHERE relationship_type = 'S'
15270: START WITH object_id_to1 in (select p.element_version_id
15271: from PA_PROJ_ELEMENT_VERSIONS p where p.project_id = c_project_id and defer_code in ( 'P','S'))
15272: AND relationship_type = 'S'
15273: CONNECT BY PRIOR object_id_from1 = object_id_to1
15274: AND relationship_type = 'S';
15275: */

Line 15437: FROM pa_proj_element_versions

15433: null;
15434: ELSE
15435: /*INSERT INTO pa_proj_rollup_temp(process_number, object_id, object_type, wbs_level)
15436: SELECT l_process_number_temp, element_version_id object_id_from1, 'PA_TASKS', 1
15437: FROM pa_proj_element_versions
15438: WHERE project_id = p_project_id
15439: AND parent_structure_version_id = p_structure_version_id
15440: AND PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(element_version_id) = 'Y'
15441: AND object_type = 'PA_TASKS'