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 3838: from pa_object_relationships b

3834: -- This line is not reqd. Its used only for testing
3835: where a.Parent_Structure_Version_ID = P_Version_ID
3836: and a.Element_Version_ID IN (
3837: Select b.OBJECT_ID_FROM1
3838: from pa_object_relationships b
3839: where b.Relationship_Type = 'S'
3840: and b.Object_Type_From = 'PA_TASKS'
3841: ) )
3842: Loop

Line 3846: from pa_object_relationships b

3842: Loop
3843: Begin
3844: Select 'Y'
3845: Into l_Exist_Flag
3846: from pa_object_relationships b
3847: where Rec.Element_Version_ID IN ( b.Object_ID_From1, b.Object_ID_To1 )
3848: and b.Object_Type_From = 'PA_TASKS'
3849: and b.Object_Type_To = 'PA_TASKS'
3850: and b.Relationship_Type = 'D';

Line 4109: pa_object_relationships por

4105: --bug 4087964: changed sql
4106: CURSOR check_subproj_exists IS
4107: SELECT '1'
4108: FROM pa_proj_element_Versions ppev,
4109: pa_object_relationships por
4110: where ppev.parent_structure_version_id = p_structure_ver_id
4111: and ppev.element_version_id = por.object_id_from1
4112: and ppev.project_id = p_project_id
4113: and por.relationship_type IN ('LW', 'LF');

Line 4120: pa_object_relationships por

4116: --bug 4541039
4117: CURSOR check_subproj_exists_wp IS
4118: SELECT '1'
4119: FROM pa_proj_element_Versions ppev,
4120: pa_object_relationships por
4121: where ppev.parent_structure_version_id = p_structure_ver_id
4122: and ppev.element_version_id = por.object_id_from1
4123: and ppev.project_id = p_project_id
4124: and por.relationship_type = 'LW';

Line 4129: pa_object_relationships por

4125:
4126: CURSOR check_subproj_exists_fn IS
4127: SELECT '1'
4128: FROM pa_proj_element_Versions ppev,
4129: pa_object_relationships por
4130: where ppev.parent_structure_version_id = p_structure_ver_id
4131: and ppev.element_version_id = por.object_id_from1
4132: and ppev.project_id = p_project_id
4133: and por.relationship_type = 'LF';

Line 4997: FROM pa_object_relationships por,

4993:
4994: CURSOR link_exists_cur IS
4995: SELECT 1 FROM DUAL WHERE EXISTS (
4996: SELECT por.object_relationship_id
4997: FROM pa_object_relationships por,
4998: pa_proj_element_versions ppev
4999: WHERE por.object_id_from1 = ppev.element_version_id
5000: AND por.relationship_type in ('LW', 'LF')
5001: AND ppev.parent_structure_version_id = p_structure_version_id

Line 5004: FROM pa_object_relationships por,

5000: AND por.relationship_type in ('LW', 'LF')
5001: AND ppev.parent_structure_version_id = p_structure_version_id
5002: UNION ALL
5003: SELECT por. object_relationship_id
5004: FROM pa_object_relationships por,
5005: pa_proj_element_versions ppev
5006: WHERE por.object_id_to1 = ppev.element_version_id
5007: AND por.relationship_type in ('LW', 'LF')
5008: AND ppev.parent_structure_version_id = p_structure_version_id);