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 1160: FROM pa_object_relationships

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

Line 1169: from pa_object_relationships a,

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

Line 1170: pa_object_relationships b

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

Line 1184: FROM pa_object_relationships por,

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

Line 1208: FROM pa_object_relationships por,

1204: SELECT NULL
1205: FROM DUAL
1206: WHERE EXISTS
1207: (SELECT NULL
1208: FROM pa_object_relationships por,
1209: pa_proj_element_versions pev,
1210: pa_proj_elements pe
1211: WHERE por.object_id_from1 = p_element_version_id
1212: AND por.object_type_from ='PA_TASKS'

Line 1468: FROM PA_PROJ_ELEMENT_VERSIONS pev, PA_OBJECT_RELATIONSHIPS rel

1464: IS
1465: CURSOR TASK_INFO_CSR(c_task_id NUMBER)
1466: IS
1467: SELECT rel.object_id_from1 parent_task_id, pev.wbs_number
1468: FROM PA_PROJ_ELEMENT_VERSIONS pev, PA_OBJECT_RELATIONSHIPS rel
1469: WHERE pev.element_version_id = c_task_id
1470: AND pev.object_type = 'PA_TASKS'
1471: AND rel.object_id_to1 = pev.element_version_id
1472: AND rel.relationship_type = 'S'

Line 1513: FROM PA_PROJ_ELEMENT_VERSIONS pev, PA_OBJECT_RELATIONSHIPS rel

1509: WHERE parent_structure_version_id = c_parent_structure_ver_id
1510: AND object_type = 'PA_TASKS'
1511: AND display_sequence =
1512: (SELECT max(pev.display_sequence)
1513: FROM PA_PROJ_ELEMENT_VERSIONS pev, PA_OBJECT_RELATIONSHIPS rel
1514: WHERE rel.object_type_from = 'PA_TASKS'
1515: AND rel.object_id_from1 = c_parent_task_id
1516: AND rel.relationship_type = 'S'
1517: AND rel.object_type_to = 'PA_TASKS'

Line 1542: FROM PA_PROJ_ELEMENT_VERSIONS pev, PA_OBJECT_RELATIONSHIPS rel

1538: WHERE parent_structure_version_id = c_parent_structure_ver_id
1539: AND object_type = 'PA_TASKS'
1540: AND display_sequence =
1541: (SELECT max(pev.display_sequence)
1542: FROM PA_PROJ_ELEMENT_VERSIONS pev, PA_OBJECT_RELATIONSHIPS rel
1543: WHERE rel.object_type_from = 'PA_STRUCTURES'
1544: AND rel.object_id_from1 = c_parent_structure_ver_id
1545: AND rel.relationship_type = 'S'
1546: AND rel.object_type_to = 'PA_TASKS'

Line 1574: l_parent_task_id PA_OBJECT_RELATIONSHIPS.object_id_from1%TYPE;

1570:
1571: API_ERROR EXCEPTION;
1572: l_number NUMBER; -- Bug 2786662
1573: --Bug 13895419 start
1574: l_parent_task_id PA_OBJECT_RELATIONSHIPS.object_id_from1%TYPE;
1575: l_ref_parent_task_id PA_OBJECT_RELATIONSHIPS.object_id_from1%TYPE;
1576: --Bug 13895419 end
1577: BEGIN
1578: if p_commit = 'Y' then

Line 1575: l_ref_parent_task_id PA_OBJECT_RELATIONSHIPS.object_id_from1%TYPE;

1571: API_ERROR EXCEPTION;
1572: l_number NUMBER; -- Bug 2786662
1573: --Bug 13895419 start
1574: l_parent_task_id PA_OBJECT_RELATIONSHIPS.object_id_from1%TYPE;
1575: l_ref_parent_task_id PA_OBJECT_RELATIONSHIPS.object_id_from1%TYPE;
1576: --Bug 13895419 end
1577: BEGIN
1578: if p_commit = 'Y' then
1579: savepoint update_wbs_numbers;

Line 1601: FROM PA_PROJ_ELEMENT_VERSIONS pev, PA_OBJECT_RELATIONSHIPS rel

1597: -- Added the leading hint below for bug 3416314
1598: -- Smukka Merging branch 40 as of now with main branch
1599: SELECT /*+ LEADING (rel) */ count(pev.element_version_id)
1600: INTO l_count
1601: FROM PA_PROJ_ELEMENT_VERSIONS pev, PA_OBJECT_RELATIONSHIPS rel
1602: WHERE pev.parent_structure_version_id = p_parent_structure_ver_id
1603: AND pev.object_type = 'PA_TASKS'
1604: AND abs(pev.display_sequence) <= abs(p_display_seq)
1605: AND rel.object_id_to1 = pev.element_version_id

Line 1682: FROM PA_PROJ_ELEMENT_VERSIONS pev, PA_OBJECT_RELATIONSHIPS rel

1678: --Bug 13895419 start
1679: --Fetch parent_task_id and ref_parent_task_id for source task and target task respectively from db.
1680: begin
1681: SELECT rel.object_id_from1 INTO l_parent_task_id
1682: FROM PA_PROJ_ELEMENT_VERSIONS pev, PA_OBJECT_RELATIONSHIPS rel
1683: WHERE pev.element_version_id = p_task_version_id
1684: AND pev.object_type = 'PA_TASKS'
1685: AND rel.object_id_to1 = pev.element_version_id
1686: AND rel.relationship_type = 'S'

Line 1690: FROM PA_PROJ_ELEMENT_VERSIONS pev, PA_OBJECT_RELATIONSHIPS rel

1686: AND rel.relationship_type = 'S'
1687: AND rel.object_type_from in ('PA_TASKS', 'PA_STRUCTURES');
1688:
1689: SELECT rel.object_id_from1 INTO l_ref_parent_task_id
1690: FROM PA_PROJ_ELEMENT_VERSIONS pev, PA_OBJECT_RELATIONSHIPS rel
1691: WHERE pev.element_version_id = p_ref_task_version_id
1692: AND pev.object_type = 'PA_TASKS'
1693: AND rel.object_id_to1 = pev.element_version_id
1694: AND rel.relationship_type = 'S'

Line 2194: FROM pa_object_relationships

2190:
2191: CURSOR cur_obj_rel
2192: IS
2193: SELECT object_id_to1
2194: FROM pa_object_relationships
2195: WHERE object_id_from1 = p_cur_element_version_id
2196: AND relationship_type = 'L';
2197: l_linked_task_ver_id NUMBER;
2198: BEGIN

Line 2277: from pa_object_relationships

2273: p_link_task_flag VARCHAR2)
2274: RETURN NUMBER IS
2275: cursor get_display_parent_id IS
2276: select object_id_from1
2277: from pa_object_relationships
2278: where relationship_type = 'S'
2279: and object_id_to1 = p_parent_element_version_id;
2280: l_display_parent_version_id NUMBER;
2281: BEGIN

Line 2814: from pa_object_relationships

2810: )
2811: IS
2812: CURSOR c1 IS
2813: select object_Id_to1
2814: from pa_object_relationships
2815: where object_type_to = 'PA_TASKS'
2816: and relationship_type = 'S'
2817: start with object_id_from1 = p_task_version_id
2818: and object_type_from = 'PA_TASKS'

Line 3378: from pa_object_relationships

3374: select distinct ppe.proj_element_id
3375: from pa_proj_element_versions ppe
3376: where ppe.element_version_id IN (
3377: select object_id_to1
3378: from pa_object_relationships
3379: where relationship_type = 'S'
3380: start with object_id_from1 IN (
3381: select a.element_version_id
3382: from pa_proj_element_versions a,

Line 3398: from pa_object_relationships

3394: select ppe.proj_element_id
3395: from pa_proj_element_versions ppe
3396: where ppe.element_version_id IN (
3397: select object_id_to1
3398: from pa_object_relationships
3399: where relationship_type = 'S'
3400: start with object_id_from1 = p_task_version_id
3401: and object_type_from = 'PA_TASKS'
3402: and relationship_type = 'S'

Line 3538: (select null from pa_object_relationships

3534: -- Bug 6156686
3535: cursor child_exist IS
3536: select null
3537: from dual where exists
3538: (select null from pa_object_relationships
3539: where object_id_from1 = p_element_version_id
3540: and relationship_type = 'S');
3541: BEGIN
3542:

Line 4337: from pa_object_relationships

4333: is
4334: --bug 4043647 , start
4335: /*cursor C1 is
4336: select object_id_from1
4337: from pa_object_relationships
4338: where relationship_type='S'
4339: and object_type_from='PA_TASKS'
4340: connect by prior object_id_from1 = object_id_to1
4341: and prior relationship_type = relationship_type

Line 4349: from pa_object_relationships

4345: select p_element_version_id from dual ; --bug 3429648*/
4346:
4347: cursor C1 is
4348: select object_id_to1
4349: from pa_object_relationships
4350: where relationship_type='S'
4351: and object_type_from='PA_STRUCTURES'
4352: and object_type_to='PA_TASKS'
4353: connect by prior object_id_from1 = object_id_to1

Line 4362: from pa_object_relationships a, pa_proj_element_versions b

4358:
4359: /*
4360: intersect
4361: select a.object_id_to1
4362: from pa_object_relationships a, pa_proj_element_versions b
4363: where b.element_version_id = p_element_version_id
4364: and b.parent_structure_version_id = a.object_id_from1
4365: and a.relationship_type = 'S';
4366: */

Line 4386: from pa_object_relationships

4382: cursor C1 (evid number) is
4383: select proj_element_id from pa_proj_element_versions
4384: where element_version_id IN (
4385: /*select object_id_from1 --bug 4043647
4386: from pa_object_relationships
4387: where relationship_type='S'
4388: and object_type_from='PA_TASKS'
4389: connect by prior object_id_from1 = object_id_to1
4390: and prior relationship_type = relationship_type

Line 4396: from pa_object_relationships

4392: and relationship_type = 'S'
4393: union
4394: select p_element_version_id from dual ); --bug 3429648*/
4395: select object_id_to1
4396: from pa_object_relationships
4397: where relationship_type='S'
4398: and object_type_from='PA_STRUCTURES'
4399: and object_type_to='PA_TASKS'
4400: connect by prior object_id_from1 = object_id_to1

Line 4408: from pa_object_relationships a, pa_proj_element_versions b

4404:
4405: /*
4406: intersect
4407: select a.object_id_to1
4408: from pa_object_relationships a, pa_proj_element_versions b
4409: where b.element_version_id = p_element_version_id
4410: and b.parent_structure_version_id = a.object_id_from1
4411: and a.relationship_type = 'S');
4412: */

Line 4434: from pa_object_relationships

4430: function GET_TASK_LEVEL(p_element_version_id IN number) return varchar2
4431: is
4432: cursor C1 (evid number) is
4433: select 1
4434: from pa_object_relationships
4435: where object_id_to1 = evid
4436: and relationship_type='S'
4437: and object_type_from='PA_STRUCTURES';
4438:

Line 4441: from pa_object_relationships

4437: and object_type_from='PA_STRUCTURES';
4438:
4439: cursor C2 (evid number) is
4440: select 1
4441: from pa_object_relationships
4442: where object_id_from1 = evid
4443: and relationship_type='S';
4444:
4445: c1rec C1%ROWTYPE;

Line 4638: FROM pa_object_relationships, pa_proj_element_versions

4634: function GET_PARENT_TASK_ID(p_element_version_id IN number) return number
4635: is
4636: CURSOR c1 IS
4637: SELECT proj_element_id
4638: FROM pa_object_relationships, pa_proj_element_versions
4639: WHERE object_id_to1 = p_element_version_id
4640: AND object_type_from='PA_TASKS'
4641: AND object_id_from1 = element_version_id
4642: AND relationship_type = 'S'; -- added for bug 16170622 to eliminate 'D' dependency records

Line 4664: FROM pa_object_relationships

4660:
4661:
4662: CURSOR c1 IS
4663: SELECT object_id_from1
4664: FROM pa_object_relationships
4665: WHERE object_id_to1 = p_element_version_id
4666: AND object_type_from='PA_TASKS'
4667: AND relationship_type = 'S';
4668:

Line 4703: select object_relationship_id into l_relationship_id from pa_object_relationships

4699: ,p_object_id_to1 IN NUMBER) return NUMBER
4700: is
4701: l_relationship_id NUMBER;
4702: begin
4703: select object_relationship_id into l_relationship_id from pa_object_relationships
4704: where object_id_from1 = p_object_id_from1
4705: and object_id_to1 = p_object_id_to1
4706: and relationship_type = 'D';
4707:

Line 4729: FROM pa_object_relationships

4725: AND ppev.object_type = 'PA_TASKS'
4726: AND ppe.object_type = 'PA_TASKS'
4727: AND ppev.element_version_id IN (
4728: SELECT object_id_to1
4729: FROM pa_object_relationships
4730: WHERE relationship_type = 'S'
4731: START WITH object_id_to1 = cp_task_version_id --24628
4732: AND object_type_to = 'PA_TASKS'
4733: and relationship_type = 'S'

Line 4774: FROM pa_object_relationships

4770: AND ppev.object_type = 'PA_TASKS'
4771: AND ppe.object_type = 'PA_TASKS'
4772: AND ppev.element_version_id IN (
4773: SELECT object_id_to1
4774: FROM pa_object_relationships
4775: WHERE relationship_type = 'S'
4776: START WITH object_id_to1 = cp_target_task_version_id
4777: AND object_type_to = 'PA_TASKS'
4778: and relationship_type = 'S'

Line 4793: FROM pa_object_relationships

4789: AND ppev.object_type = 'PA_TASKS'
4790: AND ppe.object_type = 'PA_TASKS'
4791: AND ppev.element_version_id IN (
4792: SELECT object_id_to1
4793: FROM pa_object_relationships
4794: WHERE relationship_type = 'S'
4795: START WITH object_id_to1 = cp_task_version_id
4796: AND object_type_to = 'PA_TASKS'
4797: and relationship_type = 'S'

Line 4843: pa_object_relationships rel1

4839: /* This cursor get all the leaf nodes for a given structure*/
4840: CURSOR get_leaf_node_cur(cp_structure_elem_id NUMBER) IS
4841: SELECT object_id_to1
4842: FROM pa_proj_element_versions ppev,
4843: pa_object_relationships rel1
4844: WHERE ppev.parent_structure_version_id = cp_structure_elem_id --19671
4845: AND rel1.relationship_type = 'S'
4846: AND ppev.element_version_id = rel1.object_id_to1
4847: AND NOT EXISTS (SELECT 'XYZ'

Line 4848: FROM pa_object_relationships rel2

4844: WHERE ppev.parent_structure_version_id = cp_structure_elem_id --19671
4845: AND rel1.relationship_type = 'S'
4846: AND ppev.element_version_id = rel1.object_id_to1
4847: AND NOT EXISTS (SELECT 'XYZ'
4848: FROM pa_object_relationships rel2
4849: WHERE rel2.object_id_from1 = rel1.object_id_to1);
4850: get_leaf_node_rec get_leaf_node_cur%ROWTYPE;
4851:
4852: /* This cursor goes from leaf node to top of the branch*/

Line 4863: FROM pa_object_relationships

4859: AND ppev.object_type = 'PA_TASKS'
4860: AND ppe.object_type = 'PA_TASKS'
4861: AND ppev.element_version_id IN (
4862: SELECT object_id_to1
4863: FROM pa_object_relationships
4864: WHERE relationship_type = 'S'
4865: START WITH object_id_to1 = cp_task_version_id --24628
4866: AND object_type_to = 'PA_TASKS'
4867: and relationship_type = 'S'

Line 5064: FROM pa_object_relationships

5060: --
5061: --
5062: CURSOR c1 IS
5063: SELECT object_id_to1
5064: FROM pa_object_relationships
5065: WHERE object_id_from1 = p_task_version_id
5066: AND object_type_to='PA_TASKS'
5067: AND relationship_type = 'S';
5068: --

Line 5093: FROM pa_object_relationships

5089: AND ppev.object_type = 'PA_TASKS'
5090: AND ppe.object_type = 'PA_TASKS'
5091: AND ppev.element_version_id IN (
5092: SELECT object_id_to1
5093: FROM pa_object_relationships
5094: WHERE relationship_type = 'S'
5095: START WITH object_id_to1 = cp_target_task_version_id
5096: AND object_type_to = 'PA_TASKS'
5097: and relationship_type = 'S'

Line 5112: FROM pa_object_relationships

5108: AND ppev.object_type = 'PA_TASKS'
5109: AND ppe.object_type = 'PA_TASKS'
5110: AND ppev.element_version_id IN (
5111: SELECT object_id_to1
5112: FROM pa_object_relationships
5113: WHERE relationship_type = 'S'
5114: START WITH object_id_to1 = cp_task_version_id
5115: AND object_type_to = 'PA_TASKS'
5116: and relationship_type = 'S'

Line 5236: from pa_object_relationships por1, pa_proj_element_versions ppev1

5232: , c_include_sub_proj_flag VARCHAR2) -- Fix for Bug # 4290042.
5233: is
5234: -- This query checks if the task version has a financial sub-task.
5235: select 'N'
5236: from pa_object_relationships por1, pa_proj_element_versions ppev1
5237: where por1.object_id_to1 = ppev1.element_version_id
5238: and por1.relationship_type = 'S'
5239: and ppev1.project_id = c_project_id
5240: and por1.object_id_from1 = c_task_version_id

Line 5246: from pa_object_relationships por2, pa_proj_element_versions ppev2

5242: union all
5243: -- This query checks if the task version has a linking sub-task that has a financial link to
5244: -- a sub-project if the input p_include_sub_proj_flag = 'Y'.
5245: select 'N'
5246: from pa_object_relationships por2, pa_proj_element_versions ppev2
5247: where por2.object_id_to1 = ppev2.element_version_id
5248: and por2.relationship_type = 'S'
5249: and ppev2.project_id = c_project_id
5250: and por2.object_id_from1 = c_task_version_id

Line 5252: from pa_object_relationships por3

5248: and por2.relationship_type = 'S'
5249: and ppev2.project_id = c_project_id
5250: and por2.object_id_from1 = c_task_version_id
5251: and exists (select 'Y'
5252: from pa_object_relationships por3
5253: where por3.object_id_from1 = ppev2.element_version_id
5254: and por3.object_id_from2 = ppev2.project_id
5255: and por3.relationship_type = 'LF')
5256: and c_include_sub_proj_flag = 'Y'; -- Fix for Bug # 4290042.

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

6138: l_dummy number;
6139: cursor child_exist IS
6140: select 1 from dual where exists(
6141: select 1
6142: from pa_object_relationships por, pa_proj_element_versions ppev, pa_proj_elements ppe
6143: where por.object_type_from = 'PA_TASKS'
6144: and por.object_id_from1 = p_task_version_id
6145: and por.relationship_type = 'S'
6146: and por.object_id_to1 = ppev.element_version_id