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_PROGRESS_PVT dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 121: , pa_proj_element_versions ppev

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

Line 127: FROM pa_proj_element_versions

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

Line 134: FROM pa_proj_element_versions

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

Line 473: FROM pa_proj_element_versions ppev,

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

Line 595: pa_proj_element_versions ppev1,

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

Line 596: pa_proj_element_versions ppev2,

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

Line 728: FROM pa_proj_element_versions ppev , pa_proj_rollup_temp temp

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

Line 836: pa_proj_element_versions ppev1,

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

Line 837: pa_proj_element_versions ppev2,

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

Line 1242: FROM pa_proj_element_versions

1238:
1239: CURSOR cur_get_deepest_task(c_structure_version_id number, c_project_id number)
1240: IS
1241: SELECT element_version_id
1242: FROM pa_proj_element_versions
1243: where project_id = c_project_id
1244: and object_type = 'PA_TASKS'
1245: AND parent_structure_version_id = c_structure_version_id
1246: AND wbs_level = (Select max(wbs_level)

Line 1247: From pa_proj_element_versions

1243: where project_id = c_project_id
1244: and object_type = 'PA_TASKS'
1245: AND parent_structure_version_id = c_structure_version_id
1246: AND wbs_level = (Select max(wbs_level)
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:

Line 1261: select 'Y' from pa_proj_element_versions ppev1

1257: l_base_struct_ver_id NUMBER;
1258:
1259: CURSOR check_task_baselined(c_structure_ver_id NUMBER, c_task_version_id NUMBER)
1260: IS
1261: select 'Y' from pa_proj_element_versions ppev1
1262: where ppev1.parent_structure_version_id = c_structure_ver_id
1263: and ppev1.proj_element_id = (select proj_element_id from pa_proj_element_versions ppev2
1264: where ppev2.element_version_id = c_task_version_id
1265: and ppev2.project_id = p_project_id);

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

1259: CURSOR check_task_baselined(c_structure_ver_id NUMBER, c_task_version_id NUMBER)
1260: IS
1261: select 'Y' from pa_proj_element_versions ppev1
1262: where ppev1.parent_structure_version_id = c_structure_ver_id
1263: and ppev1.proj_element_id = (select proj_element_id from pa_proj_element_versions ppev2
1264: where ppev2.element_version_id = c_task_version_id
1265: and ppev2.project_id = p_project_id);
1266:
1267: l_task_baselined VARCHAR2(1) := 'N';

Line 1280: , pa_proj_element_versions ver

1276: CURSOR cur_tree_rollup_dates
1277: IS
1278: select ppr.as_of_date, ver2.proj_element_id child_task_id, ver2.element_version_id child_task_ver_id
1279: from pa_object_relationships obj
1280: , pa_proj_element_versions ver
1281: , pa_progress_rollup ppr
1282: , pa_proj_rollup_temp rollup
1283: , pa_proj_element_versions ver2
1284: where rollup.object_id = obj.object_id_to1

Line 1283: , pa_proj_element_versions ver2

1279: from pa_object_relationships obj
1280: , pa_proj_element_versions ver
1281: , pa_progress_rollup ppr
1282: , pa_proj_rollup_temp rollup
1283: , pa_proj_element_versions ver2
1284: where rollup.object_id = obj.object_id_to1
1285: AND rollup.process_number = l_process_number_temp
1286: AND obj.relationship_type = 'S'
1287: AND obj.object_type_from IN ('PA_STRUCTURES' ,'PA_TASKS')

Line 1314: pa_proj_element_versions ppv2

1310: ,ppv2.proj_element_id sub_proj_element_id
1311: , pa_progress_utils.Get_BAC_Value(ppv2.project_id, c_task_per_comp_deriv_method, ppv2.proj_element_id, ppv2.parent_structure_version_id,
1312: 'WORKPLAN','N') sub_project_bac_value
1313: FROM
1314: pa_proj_element_versions ppv2
1315: ,pa_proj_elem_ver_structure ppevs2
1316: ,pa_object_relationships por1
1317: ,pa_object_relationships por2
1318: WHERE

Line 1580: FROM pa_proj_element_versions

1576: l_mass_rollup_prog_rec_tab.delete;
1577: ELSE
1578: INSERT INTO pa_proj_rollup_temp(process_number, object_id, object_type, wbs_level)
1579: SELECT l_process_number_temp, element_version_id object_id_from1, 'PA_TASKS', 1
1580: FROM pa_proj_element_versions
1581: WHERE project_id = p_project_id
1582: AND parent_structure_version_id = p_structure_version_id
1583: --AND PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(element_version_id) = 'N'
1584: -- 4490532 : changed from IS_LOWEST_TASK to is_summary_task_or_structure

Line 4138: ) pobj, pa_proj_element_versions ppev

4134: --and relationship_type = 'S' -- Bug 3603636
4135: and relationship_type = 'S' -- Bug 4122809 : Added this
4136: connect by prior object_id_from1 = object_id_to1
4137: and relationship_type = 'S' -- Bug 3958686
4138: ) pobj, pa_proj_element_versions ppev
4139: WHERE element_version_id = object_id_to1
4140: AND p_rollup_entire_wbs='N'
4141: UNION -- AMG Changes
4142: 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 4143: FROM pa_proj_element_versions ever

4139: WHERE element_version_id = object_id_to1
4140: AND p_rollup_entire_wbs='N'
4141: UNION -- AMG Changes
4142: SELECT ever.proj_element_id, obj.object_id_from1 object_id_from1, ever.element_version_id object_id_to1, ever.object_type object_type
4143: FROM pa_proj_element_versions ever
4144: , pa_object_relationships obj
4145: WHERE ever.project_id = p_project_id
4146: and ever.parent_structure_version_id = p_structure_version_id
4147: -- 4490532 : changed from IS_LOWEST_TASK to is_summary_task_or_structure

Line 4203: from pa_proj_element_versions

4199:
4200: For cur_tree_rec in cur_reverse_tree loop
4201:
4202: select proj_element_id into l_object_id
4203: from pa_proj_element_versions
4204: where element_version_id = cur_tree_rec.object_id_from1;
4205:
4206: IF g1_debug_mode = 'Y' THEN
4207: 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 4367: pa_proj_element_versions ppv1

4363: ,ppv1.parent_structure_version_id PARENT_STRUCTURE_VER_ID
4364: ,ppv1.element_version_id PARENT_TASK_VERSION_ID
4365: ,ppv1.proj_element_id PARENT_TASK_ID
4366: FROM
4367: pa_proj_element_versions ppv1
4368: ,pa_proj_elem_ver_structure ppevs1
4369: ,pa_proj_element_versions ppv2
4370: ,pa_proj_elem_ver_structure ppevs2
4371: ,pa_object_relationships por1

Line 4369: ,pa_proj_element_versions ppv2

4365: ,ppv1.proj_element_id PARENT_TASK_ID
4366: FROM
4367: pa_proj_element_versions ppv1
4368: ,pa_proj_elem_ver_structure ppevs1
4369: ,pa_proj_element_versions ppv2
4370: ,pa_proj_elem_ver_structure ppevs2
4371: ,pa_object_relationships por1
4372: ,pa_object_relationships por2
4373: WHERE

Line 5652: FROM pa_proj_element_versions ppev,

5648: , ppr.Oth_quantity_to_date
5649: , ppr.Oth_etc_quantity
5650: -- 4533112 : Added base_progress_status_code
5651: , decode(ppr.base_progress_status_code, 'Y' , 'Y', 'N') base_progress_status_code
5652: FROM pa_proj_element_versions ppev,
5653: pa_object_relationships obj,
5654: pa_progress_rollup ppr,
5655: pa_project_statuses pps1,
5656: pa_project_statuses pps2,

Line 5820: FROM pa_proj_element_versions ppev

5816: , to_number(null) Oth_quantity_to_date
5817: , to_number(null) Oth_etc_quantity
5818: -- 4533112 : Added base_progress_status_code
5819: , 'N' base_progress_status_code
5820: FROM pa_proj_element_versions ppev
5821: WHERE ppev.element_version_id = c_task_ver_id
5822: AND ppev.object_type = 'PA_TASKS'
5823: -- Bug 3879461 Begin
5824: AND NOT EXISTS (SELECT 1

Line 5956: FROM pa_proj_element_versions ppev1,

5952: , ppr.Oth_quantity_to_date
5953: , ppr.Oth_etc_quantity
5954: -- 4533112 : Added base_progress_status_code
5955: , decode(ppr.base_progress_status_code,'Y','Y','N') base_progress_status_code
5956: FROM pa_proj_element_versions ppev1,
5957: pa_proj_element_versions ppev2,
5958: pa_object_relationships obj,
5959: pa_progress_rollup ppr,
5960: pa_project_statuses pps1,

Line 5957: pa_proj_element_versions ppev2,

5953: , ppr.Oth_etc_quantity
5954: -- 4533112 : Added base_progress_status_code
5955: , decode(ppr.base_progress_status_code,'Y','Y','N') base_progress_status_code
5956: FROM pa_proj_element_versions ppev1,
5957: pa_proj_element_versions ppev2,
5958: pa_object_relationships obj,
5959: pa_progress_rollup ppr,
5960: pa_project_statuses pps1,
5961: pa_project_statuses pps2,

Line 6123: FROM pa_proj_element_versions ppev1,

6119: , to_number(null) Oth_quantity_to_date
6120: , to_number(null) Oth_etc_quantity
6121: -- 4533112 : Added base_progress_status_code
6122: , 'N' base_progress_status_code
6123: FROM pa_proj_element_versions ppev1,
6124: pa_proj_element_versions ppev2,
6125: pa_object_relationships obj,
6126: pji_fm_xbs_accum_tmp1 pfxat,
6127: pa_proj_elements ppe -- 4392189

Line 6124: pa_proj_element_versions ppev2,

6120: , to_number(null) Oth_etc_quantity
6121: -- 4533112 : Added base_progress_status_code
6122: , 'N' base_progress_status_code
6123: FROM pa_proj_element_versions ppev1,
6124: pa_proj_element_versions ppev2,
6125: pa_object_relationships obj,
6126: pji_fm_xbs_accum_tmp1 pfxat,
6127: pa_proj_elements ppe -- 4392189
6128: WHERE obj.object_id_from1 = c_task_ver_id

Line 6694: pa_proj_element_versions ppv2

6690: ,ppv2.proj_element_id sub_proj_element_id
6691: , pa_progress_utils.Get_BAC_Value(ppv2.project_id, c_task_per_comp_deriv_method, ppv2.proj_element_id, ppv2.parent_structure_version_id,
6692: 'WORKPLAN','N') sub_project_bac_value
6693: FROM
6694: pa_proj_element_versions ppv2
6695: ,pa_proj_elem_ver_structure ppevs2
6696: ,pa_object_relationships por1
6697: ,pa_object_relationships por2
6698: WHERE

Line 9043: , pa_proj_element_versions ver

9039: , obj2.object_id_to2 subprj_id
9040: , ver.proj_element_id subprj_proj_elem_id
9041: from pa_object_relationships obj1
9042: , pa_object_relationships obj2
9043: , pa_proj_element_versions ver
9044: WHERE obj1.object_id_from1 = p_object_version_id
9045: AND obj1.relationship_type = 'S'
9046: AND obj1.object_id_to1 = obj2.object_id_from1
9047: AND obj2.relationship_type = 'LW'

Line 9659: ,p_source_struct_ver_id IN pa_proj_element_versions.element_version_id%TYPE

9655:
9656: PROCEDURE copy_actuals_for_workplan(
9657: p_calling_context IN VARCHAR2 DEFAULT 'WP_PROGRESS'
9658: ,p_project_id IN pa_projects_all.project_id%TYPE
9659: ,p_source_struct_ver_id IN pa_proj_element_versions.element_version_id%TYPE
9660: ,p_target_struct_ver_id IN pa_proj_element_versions.element_version_id%TYPE
9661: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
9662: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
9663: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 9660: ,p_target_struct_ver_id IN pa_proj_element_versions.element_version_id%TYPE

9656: PROCEDURE copy_actuals_for_workplan(
9657: p_calling_context IN VARCHAR2 DEFAULT 'WP_PROGRESS'
9658: ,p_project_id IN pa_projects_all.project_id%TYPE
9659: ,p_source_struct_ver_id IN pa_proj_element_versions.element_version_id%TYPE
9660: ,p_target_struct_ver_id IN pa_proj_element_versions.element_version_id%TYPE
9661: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
9662: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
9663: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
9664: AS

Line 10193: FROM pa_proj_element_versions a,

10189: a.project_id
10190: , a.element_version_id
10191: , a.prg_level
10192: , ppr.as_of_date
10193: FROM pa_proj_element_versions a,
10194: pa_proj_elem_ver_structure b,
10195: pa_proj_structure_types ppst,
10196: pa_proj_element_versions c,
10197: pa_progress_rollup ppr

Line 10196: pa_proj_element_versions c,

10192: , ppr.as_of_date
10193: FROM pa_proj_element_versions a,
10194: pa_proj_elem_ver_structure b,
10195: pa_proj_structure_types ppst,
10196: pa_proj_element_versions c,
10197: pa_progress_rollup ppr
10198: WHERE
10199: c.project_id = p_project_id
10200: AND c.element_version_id = p_structure_version_id ---5095632

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

10358: and element_version_id = p_str_ver_id_to_del));
10359:
10360: l_str_ver_id number;
10361: -- Begin. Bug 5452282
10362: cursor obj_version_id (x_str_ver_id pa_proj_element_versions.element_version_id%type)is
10363: select ppev.element_version_id old_element_version_id,
10364: ppev1.element_version_id new_element_version_id,
10365: ppev.proj_element_id
10366: from pa_proj_element_versions ppev,

Line 10366: from pa_proj_element_versions ppev,

10362: cursor obj_version_id (x_str_ver_id pa_proj_element_versions.element_version_id%type)is
10363: select ppev.element_version_id old_element_version_id,
10364: ppev1.element_version_id new_element_version_id,
10365: ppev.proj_element_id
10366: from pa_proj_element_versions ppev,
10367: pa_proj_element_versions ppev1
10368: where ppev.project_id = p_project_id
10369: and ppev.parent_structure_version_id = p_str_ver_id_to_del
10370: and ppev.proj_element_id = ppev1.proj_element_id

Line 10367: pa_proj_element_versions ppev1

10363: select ppev.element_version_id old_element_version_id,
10364: ppev1.element_version_id new_element_version_id,
10365: ppev.proj_element_id
10366: from pa_proj_element_versions ppev,
10367: pa_proj_element_versions ppev1
10368: where ppev.project_id = p_project_id
10369: and ppev.parent_structure_version_id = p_str_ver_id_to_del
10370: and ppev.proj_element_id = ppev1.proj_element_id
10371: and ppev1.parent_structure_version_id = x_str_ver_id;