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_PROJECT_STRUCTURE_UTILS dependencies on PA_OBJECT_RELATIONSHIPS

Line 49: from pa_object_relationships

45: or locked_by_person_id = p_person_id);
46:
47: cursor get_link IS
48: select '1'
49: from pa_object_relationships
50: where (object_id_from1 = p_structure_version_id
51: or object_id_to1 = p_structure_version_id)
52: and relationship_type = 'L';
53:

Line 466: from pa_object_relationships r,

462: ) return varchar2
463: IS
464: CURSOR get_linked_element_parent IS
465: select v1.project_id, v1.parent_structure_version_id
466: from pa_object_relationships r,
467: pa_proj_element_versions v1,
468: pa_proj_element_versions v2
469: where r.relationship_type = 'L'
470: and r.object_type_from IN ('PA_TASKS','PA_STRUCTURES')

Line 1301: pa_object_relationships b,

1297: IS
1298: CURSOR c1 IS
1299: select min(a.scheduled_start_date)
1300: from pa_proj_elem_ver_schedule a,
1301: pa_object_relationships b,
1302: pa_proj_element_versions c
1303: where relationship_type IN ('S', 'L')
1304: and b.object_id_from1 = p_element_version_id
1305: and b.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')

Line 1314: pa_object_relationships b,

1310:
1311: CURSOR c2 IS
1312: select max(a.scheduled_finish_date)
1313: from pa_proj_elem_ver_schedule a,
1314: pa_object_relationships b,
1315: pa_proj_element_versions c
1316: where relationship_type IN ('S', 'L')
1317: and b.object_id_from1 = p_element_version_id
1318: and b.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')

Line 1326: from pa_object_relationships a,

1322: and c.element_version_id = a.element_version_id;
1323:
1324: CURSOR c3 IS
1325: select '1'
1326: from pa_object_relationships a,
1327: pa_proj_elements b,
1328: pa_proj_element_versions c
1329: where a.object_id_from1 = p_element_version_id
1330: and a.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')

Line 1342: pa_object_relationships b,

1338: --add pa_proj_element_versions and add condition project_id to use index
1339: CURSOR c4 IS
1340: select max(a.last_update_date)
1341: from pa_proj_elem_ver_schedule a,
1342: pa_object_relationships b,
1343: pa_proj_element_versions c
1344: where a.element_version_id = c.element_version_id
1345: and a.project_id = c.project_id
1346: and c.element_version_id = b.object_id_to1

Line 2834: pa_object_relationships por

2830: --cursor to select summary tasks
2831: CURSOR c1 IS
2832: select ppev.proj_element_id, ppev.element_version_id
2833: from pa_proj_element_versions ppev,
2834: pa_object_relationships por
2835: where ppev.parent_structure_version_id = p_structure_version_id
2836: and ppev.object_type = 'PA_TASKS'
2837: and ppev.element_version_id = por.object_id_from1
2838: and ppev.object_type = por.object_type_from

Line 2852: pa_object_relationships por

2848: --bug 4068736
2849: CURSOR c2(c_task_ver_id number) IS
2850: select 1
2851: from pa_proj_element_versions ppev,
2852: pa_object_relationships por
2853: where por.object_id_from1 = c_task_ver_id
2854: and por.relationship_type = 'S'
2855: and por.object_id_to1 = ppev.element_version_id
2856: and ppev.financial_task_flag = 'Y'

Line 2968: pa_object_relationships por

2964: IS
2965: CURSOR c1 IS
2966: select ppev.proj_element_id, ppev.element_version_id
2967: from pa_proj_element_versions ppev,
2968: pa_object_relationships por
2969: where ppev.parent_structure_version_id = p_structure_version_id
2970: and ppev.object_type = 'PA_TASKS'
2971: and ppev.element_version_id = por.object_id_from1
2972: and ppev.object_type = por.object_type_from

Line 2991: pa_object_relationships por

2987: select pps.project_system_status_code
2988: from pa_project_statuses pps,
2989: pa_proj_elements ppe,
2990: pa_proj_element_versions ppev,
2991: pa_object_relationships por
2992: where por.object_id_from1 = c_parent_task_ver_id
2993: and por.object_type_from = 'PA_TASKS'
2994: and por.relationship_type = 'S'
2995: and por.object_type_to = 'PA_TASKS'

Line 3316: Select 'x' from pa_object_relationships

3312: l_threshold_task_cnt number;
3313:
3314: CURSOR cur_link_exists
3315: IS
3316: Select 'x' from pa_object_relationships
3317: where relationship_type = 'LW'
3318: and (object_id_from2 = p_project_id or object_id_to2 = p_project_id);
3319:
3320: l_dummy_link_char VARCHAR2(1);

Line 3863: from pa_object_relationships b

3859: -- This line is not reqd. Its used only for testing
3860: where a.Parent_Structure_Version_ID = P_Version_ID
3861: and a.Element_Version_ID IN (
3862: Select b.OBJECT_ID_FROM1
3863: from pa_object_relationships b
3864: where b.Relationship_Type = 'S'
3865: and b.Object_Type_From = 'PA_TASKS'
3866: ) )
3867: Loop

Line 3871: from pa_object_relationships b

3867: Loop
3868: Begin
3869: Select 'Y'
3870: Into l_Exist_Flag
3871: from pa_object_relationships b
3872: where Rec.Element_Version_ID IN ( b.Object_ID_From1, b.Object_ID_To1 )
3873: and b.Object_Type_From = 'PA_TASKS'
3874: and b.Object_Type_To = 'PA_TASKS'
3875: and b.Relationship_Type = 'D';

Line 4134: pa_object_relationships por

4130: --bug 4087964: changed sql
4131: CURSOR check_subproj_exists IS
4132: SELECT '1'
4133: FROM pa_proj_element_Versions ppev,
4134: pa_object_relationships por
4135: where ppev.parent_structure_version_id = p_structure_ver_id
4136: and ppev.element_version_id = por.object_id_from1
4137: and ppev.project_id = p_project_id
4138: and por.relationship_type IN ('LW', 'LF');

Line 4145: pa_object_relationships por

4141: --bug 4541039
4142: CURSOR check_subproj_exists_wp IS
4143: SELECT '1'
4144: FROM pa_proj_element_Versions ppev,
4145: pa_object_relationships por
4146: where ppev.parent_structure_version_id = p_structure_ver_id
4147: and ppev.element_version_id = por.object_id_from1
4148: and ppev.project_id = p_project_id
4149: and por.relationship_type = 'LW';

Line 4154: pa_object_relationships por

4150:
4151: CURSOR check_subproj_exists_fn IS
4152: SELECT '1'
4153: FROM pa_proj_element_Versions ppev,
4154: pa_object_relationships por
4155: where ppev.parent_structure_version_id = p_structure_ver_id
4156: and ppev.element_version_id = por.object_id_from1
4157: and ppev.project_id = p_project_id
4158: and por.relationship_type = 'LF';

Line 5034: FROM pa_object_relationships por,

5030:
5031: CURSOR link_exists_cur IS
5032: SELECT 1 FROM DUAL WHERE EXISTS (
5033: SELECT por.object_relationship_id
5034: FROM pa_object_relationships por,
5035: pa_proj_element_versions ppev
5036: WHERE por.object_id_from1 = ppev.element_version_id
5037: AND por.relationship_type in ('LW', 'LF')
5038: AND ppev.parent_structure_version_id = p_structure_version_id

Line 5041: FROM pa_object_relationships por,

5037: AND por.relationship_type in ('LW', 'LF')
5038: AND ppev.parent_structure_version_id = p_structure_version_id
5039: UNION ALL
5040: SELECT por. object_relationship_id
5041: FROM pa_object_relationships por,
5042: pa_proj_element_versions ppev
5043: WHERE por.object_id_to1 = ppev.element_version_id
5044: AND por.relationship_type in ('LW', 'LF')
5045: AND ppev.parent_structure_version_id = p_structure_version_id);