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

Line 617: FROM pa_object_relationships por, pa_proj_elements ppe, pa_proj_element_versions ppev

613: ) RETURN VARCHAR2 IS
614: CURSOR cur_obj_rel
615: IS
616: SELECT 'x'
617: FROM pa_object_relationships por, pa_proj_elements ppe, pa_proj_element_versions ppev
618: WHERE object_id_from1 = p_structure_version_id
619: AND relationship_type = 'S'
620: AND por.object_id_to1 = ppev.element_version_id
621: AND ppe.proj_element_id = ppev.proj_element_id

Line 658: from pa_object_relationships

654: l_dummy number;
655:
656: cursor child_exist IS
657: select 1
658: from pa_object_relationships
659: where object_type_from = 'PA_TASKS'
660: and object_id_from1 = p_task_version_id
661: and relationship_type = 'S';
662:

Line 837: from pa_object_relationships

833: or locked_by_person_id = p_person_id);
834:
835: cursor get_link IS
836: select '1'
837: from pa_object_relationships
838: where ( object_id_from1 = p_task_version_id
839: or object_id_to1 = p_task_version_id )
840: and relationship_type = 'L';
841:

Line 1158: FROM pa_object_relationships

1154: FUNCTION is_summary_task_or_structure( p_element_version_id NUMBER ) RETURN VARCHAR2 IS
1155: /* CURSOR cur_obj_rel
1156: IS
1157: SELECT 'x'
1158: FROM pa_object_relationships
1159: WHERE object_id_from1 = p_element_version_id
1160: --hsiu: bug 2800553: performance
1161: and rownum < 2
1162: --start with object_id_from1 = p_element_version_id

Line 1167: from pa_object_relationships a,

1163: AND object_type_from = 'PA_TASKS'
1164: AND relationship_type = 'S'
1165: And object_id_to1 NOT IN (
1166: select b.object_id_from1
1167: from pa_object_relationships a,
1168: pa_object_relationships b
1169: where a.object_id_from1 = p_element_version_id
1170: and a.object_id_to1 = b.object_id_from1
1171: and a.relationship_type = 'S'

Line 1168: pa_object_relationships b

1164: AND relationship_type = 'S'
1165: And object_id_to1 NOT IN (
1166: select b.object_id_from1
1167: from pa_object_relationships a,
1168: pa_object_relationships b
1169: where a.object_id_from1 = p_element_version_id
1170: and a.object_id_to1 = b.object_id_from1
1171: and a.relationship_type = 'S'
1172: and b.relationship_type IN ('LW', 'LF'))

Line 1182: FROM pa_object_relationships por,

1178: SELECT NULL
1179: FROM DUAL
1180: WHERE EXISTS
1181: (SELECT NULL
1182: FROM pa_object_relationships por,
1183: pa_proj_element_versions pev,
1184: pa_proj_elements pe
1185: WHERE por.object_id_from1 = p_element_version_id
1186: AND por.object_type_from ='PA_TASKS'

Line 1424: FROM PA_PROJ_ELEMENT_VERSIONS pev, PA_OBJECT_RELATIONSHIPS rel

1420: IS
1421: CURSOR TASK_INFO_CSR(c_task_id NUMBER)
1422: IS
1423: SELECT rel.object_id_from1 parent_task_id, pev.wbs_number
1424: FROM PA_PROJ_ELEMENT_VERSIONS pev, PA_OBJECT_RELATIONSHIPS rel
1425: WHERE pev.element_version_id = c_task_id
1426: AND pev.object_type = 'PA_TASKS'
1427: AND rel.object_id_to1 = pev.element_version_id
1428: AND rel.relationship_type = 'S'

Line 1469: FROM PA_PROJ_ELEMENT_VERSIONS pev, PA_OBJECT_RELATIONSHIPS rel

1465: WHERE parent_structure_version_id = c_parent_structure_ver_id
1466: AND object_type = 'PA_TASKS'
1467: AND display_sequence =
1468: (SELECT max(pev.display_sequence)
1469: FROM PA_PROJ_ELEMENT_VERSIONS pev, PA_OBJECT_RELATIONSHIPS rel
1470: WHERE rel.object_type_from = 'PA_TASKS'
1471: AND rel.object_id_from1 = c_parent_task_id
1472: AND rel.relationship_type = 'S'
1473: AND rel.object_type_to = 'PA_TASKS'

Line 1486: FROM PA_PROJ_ELEMENT_VERSIONS pev, PA_OBJECT_RELATIONSHIPS rel

1482: WHERE parent_structure_version_id = c_parent_structure_ver_id
1483: AND object_type = 'PA_TASKS'
1484: AND display_sequence =
1485: (SELECT max(pev.display_sequence)
1486: FROM PA_PROJ_ELEMENT_VERSIONS pev, PA_OBJECT_RELATIONSHIPS rel
1487: WHERE rel.object_type_from = 'PA_STRUCTURES'
1488: AND rel.object_id_from1 = c_parent_structure_ver_id
1489: AND rel.relationship_type = 'S'
1490: AND rel.object_type_to = 'PA_TASKS'

Line 1541: FROM PA_PROJ_ELEMENT_VERSIONS pev, PA_OBJECT_RELATIONSHIPS rel

1537: -- Added the leading hint below for bug 3416314
1538: -- Smukka Merging branch 40 as of now with main branch
1539: SELECT /*+ LEADING (rel) */ count(pev.element_version_id)
1540: INTO l_count
1541: FROM PA_PROJ_ELEMENT_VERSIONS pev, PA_OBJECT_RELATIONSHIPS rel
1542: WHERE pev.parent_structure_version_id = p_parent_structure_ver_id
1543: AND pev.object_type = 'PA_TASKS'
1544: AND abs(pev.display_sequence) <= abs(p_display_seq)
1545: AND rel.object_id_to1 = pev.element_version_id

Line 2101: FROM pa_object_relationships

2097:
2098: CURSOR cur_obj_rel
2099: IS
2100: SELECT object_id_to1
2101: FROM pa_object_relationships
2102: WHERE object_id_from1 = p_cur_element_version_id
2103: AND relationship_type = 'L';
2104: l_linked_task_ver_id NUMBER;
2105: BEGIN

Line 2184: from pa_object_relationships

2180: p_link_task_flag VARCHAR2)
2181: RETURN NUMBER IS
2182: cursor get_display_parent_id IS
2183: select object_id_from1
2184: from pa_object_relationships
2185: where relationship_type = 'S'
2186: and object_id_to1 = p_parent_element_version_id;
2187: l_display_parent_version_id NUMBER;
2188: BEGIN

Line 2721: from pa_object_relationships

2717: )
2718: IS
2719: CURSOR c1 IS
2720: select object_Id_to1
2721: from pa_object_relationships
2722: where object_type_to = 'PA_TASKS'
2723: and relationship_type = 'S'
2724: start with object_id_from1 = p_task_version_id
2725: and object_type_from = 'PA_TASKS'

Line 3285: from pa_object_relationships

3281: select distinct ppe.proj_element_id
3282: from pa_proj_element_versions ppe
3283: where ppe.element_version_id IN (
3284: select object_id_to1
3285: from pa_object_relationships
3286: where relationship_type = 'S'
3287: start with object_id_from1 IN (
3288: select a.element_version_id
3289: from pa_proj_element_versions a,

Line 3305: from pa_object_relationships

3301: select ppe.proj_element_id
3302: from pa_proj_element_versions ppe
3303: where ppe.element_version_id IN (
3304: select object_id_to1
3305: from pa_object_relationships
3306: where relationship_type = 'S'
3307: start with object_id_from1 = p_task_version_id
3308: and object_type_from = 'PA_TASKS'
3309: and relationship_type = 'S'

Line 3445: (select null from pa_object_relationships

3441: -- Bug 6156686
3442: cursor child_exist IS
3443: select null
3444: from dual where exists
3445: (select null from pa_object_relationships
3446: where object_id_from1 = p_element_version_id
3447: and relationship_type = 'S');
3448: BEGIN
3449:

Line 4244: from pa_object_relationships

4240: is
4241: --bug 4043647 , start
4242: /*cursor C1 is
4243: select object_id_from1
4244: from pa_object_relationships
4245: where relationship_type='S'
4246: and object_type_from='PA_TASKS'
4247: connect by prior object_id_from1 = object_id_to1
4248: and prior relationship_type = relationship_type

Line 4256: from pa_object_relationships

4252: select p_element_version_id from dual ; --bug 3429648*/
4253:
4254: cursor C1 is
4255: select object_id_to1
4256: from pa_object_relationships
4257: where relationship_type='S'
4258: and object_type_from='PA_STRUCTURES'
4259: and object_type_to='PA_TASKS'
4260: connect by prior object_id_from1 = object_id_to1

Line 4269: from pa_object_relationships a, pa_proj_element_versions b

4265:
4266: /*
4267: intersect
4268: select a.object_id_to1
4269: from pa_object_relationships a, pa_proj_element_versions b
4270: where b.element_version_id = p_element_version_id
4271: and b.parent_structure_version_id = a.object_id_from1
4272: and a.relationship_type = 'S';
4273: */

Line 4293: from pa_object_relationships

4289: cursor C1 (evid number) is
4290: select proj_element_id from pa_proj_element_versions
4291: where element_version_id IN (
4292: /*select object_id_from1 --bug 4043647
4293: from pa_object_relationships
4294: where relationship_type='S'
4295: and object_type_from='PA_TASKS'
4296: connect by prior object_id_from1 = object_id_to1
4297: and prior relationship_type = relationship_type

Line 4303: from pa_object_relationships

4299: and relationship_type = 'S'
4300: union
4301: select p_element_version_id from dual ); --bug 3429648*/
4302: select object_id_to1
4303: from pa_object_relationships
4304: where relationship_type='S'
4305: and object_type_from='PA_STRUCTURES'
4306: and object_type_to='PA_TASKS'
4307: connect by prior object_id_from1 = object_id_to1

Line 4315: from pa_object_relationships a, pa_proj_element_versions b

4311:
4312: /*
4313: intersect
4314: select a.object_id_to1
4315: from pa_object_relationships a, pa_proj_element_versions b
4316: where b.element_version_id = p_element_version_id
4317: and b.parent_structure_version_id = a.object_id_from1
4318: and a.relationship_type = 'S');
4319: */

Line 4341: from pa_object_relationships

4337: function GET_TASK_LEVEL(p_element_version_id IN number) return varchar2
4338: is
4339: cursor C1 (evid number) is
4340: select 1
4341: from pa_object_relationships
4342: where object_id_to1 = evid
4343: and relationship_type='S'
4344: and object_type_from='PA_STRUCTURES';
4345:

Line 4348: from pa_object_relationships

4344: and object_type_from='PA_STRUCTURES';
4345:
4346: cursor C2 (evid number) is
4347: select 1
4348: from pa_object_relationships
4349: where object_id_from1 = evid
4350: and relationship_type='S';
4351:
4352: c1rec C1%ROWTYPE;

Line 4545: FROM pa_object_relationships, pa_proj_element_versions

4541: function GET_PARENT_TASK_ID(p_element_version_id IN number) return number
4542: is
4543: CURSOR c1 IS
4544: SELECT proj_element_id
4545: FROM pa_object_relationships, pa_proj_element_versions
4546: WHERE object_id_to1 = p_element_version_id
4547: AND object_type_from='PA_TASKS'
4548: AND object_id_from1 = element_version_id;
4549:

Line 4570: FROM pa_object_relationships

4566:
4567:
4568: CURSOR c1 IS
4569: SELECT object_id_from1
4570: FROM pa_object_relationships
4571: WHERE object_id_to1 = p_element_version_id
4572: AND object_type_from='PA_TASKS'
4573: AND relationship_type = 'S';
4574:

Line 4609: select object_relationship_id into l_relationship_id from pa_object_relationships

4605: ,p_object_id_to1 IN NUMBER) return NUMBER
4606: is
4607: l_relationship_id NUMBER;
4608: begin
4609: select object_relationship_id into l_relationship_id from pa_object_relationships
4610: where object_id_from1 = p_object_id_from1
4611: and object_id_to1 = p_object_id_to1
4612: and relationship_type = 'D';
4613:

Line 4635: FROM pa_object_relationships

4631: AND ppev.object_type = 'PA_TASKS'
4632: AND ppe.object_type = 'PA_TASKS'
4633: AND ppev.element_version_id IN (
4634: SELECT object_id_to1
4635: FROM pa_object_relationships
4636: WHERE relationship_type = 'S'
4637: START WITH object_id_to1 = cp_task_version_id --24628
4638: AND object_type_to = 'PA_TASKS'
4639: and relationship_type = 'S'

Line 4680: FROM pa_object_relationships

4676: AND ppev.object_type = 'PA_TASKS'
4677: AND ppe.object_type = 'PA_TASKS'
4678: AND ppev.element_version_id IN (
4679: SELECT object_id_to1
4680: FROM pa_object_relationships
4681: WHERE relationship_type = 'S'
4682: START WITH object_id_to1 = cp_target_task_version_id
4683: AND object_type_to = 'PA_TASKS'
4684: and relationship_type = 'S'

Line 4699: FROM pa_object_relationships

4695: AND ppev.object_type = 'PA_TASKS'
4696: AND ppe.object_type = 'PA_TASKS'
4697: AND ppev.element_version_id IN (
4698: SELECT object_id_to1
4699: FROM pa_object_relationships
4700: WHERE relationship_type = 'S'
4701: START WITH object_id_to1 = cp_task_version_id
4702: AND object_type_to = 'PA_TASKS'
4703: and relationship_type = 'S'

Line 4749: pa_object_relationships rel1

4745: /* This cursor get all the leaf nodes for a given structure*/
4746: CURSOR get_leaf_node_cur(cp_structure_elem_id NUMBER) IS
4747: SELECT object_id_to1
4748: FROM pa_proj_element_versions ppev,
4749: pa_object_relationships rel1
4750: WHERE ppev.parent_structure_version_id = cp_structure_elem_id --19671
4751: AND rel1.relationship_type = 'S'
4752: AND ppev.element_version_id = rel1.object_id_to1
4753: AND NOT EXISTS (SELECT 'XYZ'

Line 4754: FROM pa_object_relationships rel2

4750: WHERE ppev.parent_structure_version_id = cp_structure_elem_id --19671
4751: AND rel1.relationship_type = 'S'
4752: AND ppev.element_version_id = rel1.object_id_to1
4753: AND NOT EXISTS (SELECT 'XYZ'
4754: FROM pa_object_relationships rel2
4755: WHERE rel2.object_id_from1 = rel1.object_id_to1);
4756: get_leaf_node_rec get_leaf_node_cur%ROWTYPE;
4757:
4758: /* This cursor goes from leaf node to top of the branch*/

Line 4769: FROM pa_object_relationships

4765: AND ppev.object_type = 'PA_TASKS'
4766: AND ppe.object_type = 'PA_TASKS'
4767: AND ppev.element_version_id IN (
4768: SELECT object_id_to1
4769: FROM pa_object_relationships
4770: WHERE relationship_type = 'S'
4771: START WITH object_id_to1 = cp_task_version_id --24628
4772: AND object_type_to = 'PA_TASKS'
4773: and relationship_type = 'S'

Line 4970: FROM pa_object_relationships

4966: --
4967: --
4968: CURSOR c1 IS
4969: SELECT object_id_to1
4970: FROM pa_object_relationships
4971: WHERE object_id_from1 = p_task_version_id
4972: AND object_type_to='PA_TASKS'
4973: AND relationship_type = 'S';
4974: --

Line 4999: FROM pa_object_relationships

4995: AND ppev.object_type = 'PA_TASKS'
4996: AND ppe.object_type = 'PA_TASKS'
4997: AND ppev.element_version_id IN (
4998: SELECT object_id_to1
4999: FROM pa_object_relationships
5000: WHERE relationship_type = 'S'
5001: START WITH object_id_to1 = cp_target_task_version_id
5002: AND object_type_to = 'PA_TASKS'
5003: and relationship_type = 'S'

Line 5018: FROM pa_object_relationships

5014: AND ppev.object_type = 'PA_TASKS'
5015: AND ppe.object_type = 'PA_TASKS'
5016: AND ppev.element_version_id IN (
5017: SELECT object_id_to1
5018: FROM pa_object_relationships
5019: WHERE relationship_type = 'S'
5020: START WITH object_id_to1 = cp_task_version_id
5021: AND object_type_to = 'PA_TASKS'
5022: and relationship_type = 'S'

Line 5142: from pa_object_relationships por1, pa_proj_element_versions ppev1

5138: , c_include_sub_proj_flag VARCHAR2) -- Fix for Bug # 4290042.
5139: is
5140: -- This query checks if the task version has a financial sub-task.
5141: select 'N'
5142: from pa_object_relationships por1, pa_proj_element_versions ppev1
5143: where por1.object_id_to1 = ppev1.element_version_id
5144: and por1.relationship_type = 'S'
5145: and ppev1.project_id = c_project_id
5146: and por1.object_id_from1 = c_task_version_id

Line 5152: from pa_object_relationships por2, pa_proj_element_versions ppev2

5148: union all
5149: -- This query checks if the task version has a linking sub-task that has a financial link to
5150: -- a sub-project if the input p_include_sub_proj_flag = 'Y'.
5151: select 'N'
5152: from pa_object_relationships por2, pa_proj_element_versions ppev2
5153: where por2.object_id_to1 = ppev2.element_version_id
5154: and por2.relationship_type = 'S'
5155: and ppev2.project_id = c_project_id
5156: and por2.object_id_from1 = c_task_version_id

Line 5158: from pa_object_relationships por3

5154: and por2.relationship_type = 'S'
5155: and ppev2.project_id = c_project_id
5156: and por2.object_id_from1 = c_task_version_id
5157: and exists (select 'Y'
5158: from pa_object_relationships por3
5159: where por3.object_id_from1 = ppev2.element_version_id
5160: and por3.object_id_from2 = ppev2.project_id
5161: and por3.relationship_type = 'LF')
5162: and c_include_sub_proj_flag = 'Y'; -- Fix for Bug # 4290042.

Line 5880: from pa_object_relationships por, pa_proj_element_versions ppev, pa_proj_elements ppe

5876: l_dummy number;
5877: cursor child_exist IS
5878: select 1 from dual where exists(
5879: select 1
5880: from pa_object_relationships por, pa_proj_element_versions ppev, pa_proj_elements ppe
5881: where por.object_type_from = 'PA_TASKS'
5882: and por.object_id_from1 = p_task_version_id
5883: and por.relationship_type = 'S'
5884: and por.object_id_to1 = ppev.element_version_id