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

Line 55: from pa_object_relationships

51: where element_version_id = c_element_version_id;
52:
53: cursor Is_linked(c_element_version_id NUMBER) IS
54: select '1'
55: from pa_object_relationships
56: where object_id_from1 = c_element_version_id
57: and object_type_from = 'PA_TASKS'
58: and relationship_type = 'L';
59:

Line 62: from pa_object_relationships

58: and relationship_type = 'L';
59:
60: cursor Is_structure(c_element_version_id NUMBER) IS
61: select '1'
62: from pa_object_relationships
63: where object_id_from1 = c_element_version_id
64: and object_type_from = 'PA_STRUCTURES';
65:
66: cursor Get_Struc_Ver_Id(c_element_version_id NUMBER) IS

Line 99: pa_object_relationships r

95: select '1'
96: from pa_proj_elements pe1,
97: pa_proj_element_versions pev1a,
98: pa_proj_element_versions pev1b,
99: pa_object_relationships r
100: where pev1a.element_version_id = c_elem_ver_from
101: and pev1a.proj_element_id = pe1.proj_element_id
102: and pe1.project_id = pev1b.project_id
103: and pe1.proj_element_id = pev1b.proj_element_id

Line 121: pa_object_relationships r

117: select '1'
118: from pa_proj_elements pe1,
119: pa_proj_element_versions pev1a,
120: pa_proj_element_versions pev1b,
121: pa_object_relationships r
122: where pev1a.element_version_id = c_elem_ver_from
123: and pev1a.proj_element_id = pe1.proj_element_id
124: and pe1.project_id = pev1b.project_id
125: and pe1.proj_element_id = pev1b.proj_element_id

Line 147: from pa_object_relationships

143: and a.proj_element_id = b.proj_element_id
144: and a.project_id = b.project_id
145: and b.element_version_id IN (
146: select object_id_to1
147: from pa_object_relationships
148: start with object_id_from1 IN (
149: select b.element_version_id
150: from pa_proj_element_versions a,
151: pa_proj_element_versions b

Line 168: from pa_object_relationships a

164:
165:
166: cursor Get_Top_Nodes(c_element_version_id NUMBER) IS
167: select a.object_id_from1
168: from pa_object_relationships a
169: where NOT EXISTS (select '1' from pa_object_relationships b
170: where b.object_id_to1 = a.object_id_from1)
171: start with a.object_id_to1 = c_element_version_id
172: and a.object_type_to IN ('PA_STRUCTURES','PA_TASKS')

Line 169: where NOT EXISTS (select '1' from pa_object_relationships b

165:
166: cursor Get_Top_Nodes(c_element_version_id NUMBER) IS
167: select a.object_id_from1
168: from pa_object_relationships a
169: where NOT EXISTS (select '1' from pa_object_relationships b
170: where b.object_id_to1 = a.object_id_from1)
171: start with a.object_id_to1 = c_element_version_id
172: and a.object_type_to IN ('PA_STRUCTURES','PA_TASKS')
173: connect by prior a.object_id_from1 = a.object_id_to1

Line 177: from pa_object_relationships a

173: connect by prior a.object_id_from1 = a.object_id_to1
174: and a.relationship_type IN ('S','L')
175: union
176: select a.object_id_from1
177: from pa_object_relationships a
178: where a.object_id_from1 = c_element_version_id
179: and object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
180: and relationship_type = 'S';
181: l_top_node_id NUMBER;

Line 185: from pa_object_relationships

181: l_top_node_id NUMBER;
182:
183: cursor Is_Version_Exist(c_top_node_id NUMBER, c_linking_node_id NUMBER) IS
184: select object_id_to1
185: from pa_object_relationships
186: where relationship_type IN ('S', 'L')
187: start with object_id_from1 = c_top_node_id
188: and object_type_from IN ('PA_STRUCTURES','PA_TASKS')
189: connect by object_id_from1 = prior object_id_to1

Line 202: from pa_object_relationships

198: and pev1b.proj_element_id = pe1.proj_element_id
199: and pev1a.proj_element_id = pe1.proj_element_id
200: and pev1a.element_version_id IN
201: ( select object_id_to1
202: from pa_object_relationships
203: where relationship_type IN ('S','L')
204: start with object_id_from1 = c_linking_node_id
205: and object_type_from IN ('PA_STRUCTURES','PA_TASKS')
206: connect by object_id_from1 = prior object_id_to1

Line 210: -- from pa_object_relationships

206: connect by object_id_from1 = prior object_id_to1
207: and relationship_type IN('L','S')
208: -- UNION
209: -- select object_id_from1
210: -- from pa_object_relationships
211: -- where relationship_type IN ('S','L')
212: -- start with object_id_to1 = c_linking_node_id
213: -- and object_type_to IN ('PA_STRUCTURES','PA_TASKS')
214: -- connect by prior object_id_from1 = object_id_to1

Line 539: ,pa_object_relationships por

535: SELECT 'Y'
536: FROM pa_proj_elements ppe
537: ,pa_proj_element_versions ppv1 /* to get link task version id */
538: ,pa_proj_element_versions ppv2 /* to get sub project structure version ids */
539: ,pa_object_relationships por
540: WHERE ppe.project_id = p_parent_project_id
541: AND ppe.link_task_flag = 'Y'
542: AND ppe.project_id = ppv1.project_id
543: AND ppe.proj_element_id = ppv1.proj_element_id

Line 593: -- of pa_object_relationships.

589: --e. You cannot create a dependency between objects that are in the same direct path from lowest
590: -- node to the top node.
591: --
592: -- Notes: The p_pre_<> paramaters are for predecessor tasks and stored in object_id_to1 colunmn
593: -- of pa_object_relationships.
594:
595: procedure check_create_intra_dep_ok(
596: p_pre_project_id IN NUMBER
597: ,p_pre_task_ver_id IN NUMBER

Line 608: FROM pa_object_relationships

604:
605: CURSOR cur_a
606: IS
607: SELECT 'x'
608: FROM pa_object_relationships
609: WHERE object_id_from1 = p_task_ver_id
610: AND object_id_from2 = p_project_id
611: AND object_id_to1 = p_pre_task_ver_id
612: AND object_id_to2 = p_pre_project_id

Line 621: FROM pa_object_relationships por2

617: IS
618: SELECT 'x'
619: FROM (
620: SELECT object_id_to1
621: FROM pa_object_relationships por2
622: WHERE relationship_type = 'D'
623: AND por2.object_id_from2 = por2.object_id_to2 --Bug 3629024
624: START WITH por2.object_id_from1 = p_pre_task_ver_id
625: AND relationship_type = 'D' --bug 3944567

Line 637: FROM pa_object_relationships por1

633: /*Commented out for bug 3629024
634: CURSOR cur_d
635: IS
636: SELECT 'x'
637: FROM pa_object_relationships por1
638: WHERE por1.relationship_type = 'D'
639: AND por1.object_id_to1 = p_task_ver_id
640: AND por1.object_id_from1 IN
641: ( SELECT por2.object_id_to1

Line 642: FROM pa_object_relationships por2

638: WHERE por1.relationship_type = 'D'
639: AND por1.object_id_to1 = p_task_ver_id
640: AND por1.object_id_from1 IN
641: ( SELECT por2.object_id_to1
642: FROM pa_object_relationships por2
643: START WITH por2.object_id_from1 = p_pre_task_ver_id
644: CONNECT BY por2.object_id_from1 = prior por2.object_id_to1
645: AND por2.relationship_type = prior por2.relationship_type
646: AND por2.relationship_type = 'S')

Line 652: FROM pa_object_relationships

648: */
649: CURSOR cur_e1_get_parent( c_child_task_ver_id NUMBER )
650: IS
651: SELECT object_id_from1
652: FROM pa_object_relationships
653: where object_id_to1 = c_child_task_ver_id
654: and relationship_type = 'S'
655: ;
656:

Line 860: -- of pa_object_relationships.

856: -- This check procedure check s the following business rules and returns status 'E' with proper
857: -- error message if any of the rules fails.
858: --a. No duplicates.
859: -- Notes: The p_pre_<> paramaters are for predecessor tasks and stored in object_id_to1 colunmn
860: -- of pa_object_relationships.
861:
862: procedure check_create_inter_dep_ok(
863: p_pre_project_id IN NUMBER
864: ,p_pre_task_ver_id IN NUMBER

Line 875: FROM pa_object_relationships

871:
872: CURSOR cur_a
873: IS
874: SELECT 'x'
875: FROM pa_object_relationships
876: WHERE object_id_from1 = p_task_ver_id
877: AND object_id_from2 = p_project_id
878: AND object_id_to1 = p_pre_task_ver_id
879: AND object_id_to2 = p_pre_project_id

Line 907: from pa_object_relationships por

903:
904: cursor cur_sub_proj_hierarchy(c_pre_project_id NUMBER) is
905: -- This query selects all the parent projects of the predecessor project.
906: select por.object_id_from1 task_ver_id, por.object_id_from2 project_id
907: from pa_object_relationships por
908: where por.relationship_type in ('LW', 'LF')
909: start with por.object_id_to2 = c_pre_project_id
910: connect by prior por.object_id_from2 = por.object_id_to2
911: and prior por.relationship_type = por.relationship_type

Line 916: from pa_object_relationships por

912: and por.relationship_type in ('LW', 'LF')
913: union all
914: -- This query selects all the child projects of the predecessor project.
915: select por.object_id_to1 task_ver_id, por.object_id_to2 project_id
916: from pa_object_relationships por
917: where por.relationship_type in ('LW', 'LF')
918: start with por.object_id_from2 = c_pre_project_id
919: connect by prior por.object_id_to2 = por.object_id_from2
920: and prior por.relationship_type = por.relationship_type

Line 927: from pa_object_relationships por

923: rec_sub_proj_hierarchy cur_sub_proj_hierarchy%ROWTYPE;
924:
925: cursor cur_linking_task(c_task_ver_id NUMBER, c_linking_task_ver_id NUMBER) is
926: select 'Y'
927: from pa_object_relationships por
928: where por.object_id_from1 = c_task_ver_id
929: and por.object_id_to1 = c_linking_task_ver_id
930: and por.relationship_type = 'S';
931:

Line 1072: FROM pa_object_relationships por

1068: pa_proj_elements ppe
1069: WHERE ppev.proj_element_id = ppe.proj_element_id
1070: and ppev.project_id = ppe.project_id
1071: AND ppev.element_version_id IN (SELECT object_id_to1
1072: FROM pa_object_relationships por
1073: WHERE por.object_id_from1 = c_element_version_id
1074: AND por.object_id_from2 = por.object_id_to2
1075: AND por.object_type_from = 'PA_TASKS' --4141109 Replaced LIKE with Equijoin
1076: AND por.object_type_to = 'PA_TASKS' --4141109 Replaced LIKE with Equijoin

Line 1108: SELECT 1 from pa_object_relationships

1104: FUNCTION ChecK_dep_exists(p_element_version_id IN NUMBER)
1105: RETURN VARCHAR2
1106: IS
1107: CURSOR get_dependency IS
1108: SELECT 1 from pa_object_relationships
1109: where relationship_type = 'D'
1110: and (object_id_from1 = p_element_version_id OR
1111: object_id_to1 = p_element_version_id);
1112: l_dummy NUMBER;

Line 1128: --Bug No 3634315 Performance Fix, to avoid full table scan on pa_object_relationships table.

1124:
1125: FUNCTION Is_Proj_Top_Program(p_project_id IN NUMBER)
1126: RETURN VARCHAR2
1127: IS
1128: --Bug No 3634315 Performance Fix, to avoid full table scan on pa_object_relationships table.
1129: /* CURSOR c1 IS
1130: select 1
1131: from pa_object_relationships
1132: where relationship_type IN ('LW', 'LF')

Line 1131: from pa_object_relationships

1127: IS
1128: --Bug No 3634315 Performance Fix, to avoid full table scan on pa_object_relationships table.
1129: /* CURSOR c1 IS
1130: select 1
1131: from pa_object_relationships
1132: where relationship_type IN ('LW', 'LF')
1133: and object_id_to2 = p_project_id;*/
1134: CURSOR c1 IS
1135: select 1

Line 1136: from pa_object_relationships por,

1132: where relationship_type IN ('LW', 'LF')
1133: and object_id_to2 = p_project_id;*/
1134: CURSOR c1 IS
1135: select 1
1136: from pa_object_relationships por,
1137: pa_proj_element_versions ppev
1138: where por.relationship_type IN ('LW', 'LF')
1139: and ppev.element_version_id = por.object_id_to1
1140: and por.object_id_to2 = ppev.project_id

Line 1145: from pa_object_relationships

1141: and por.object_id_to2 = p_project_id;
1142:
1143: CURSOR c2 IS
1144: select 1
1145: from pa_object_relationships
1146: where relationship_type IN ('LW', 'LF')
1147: and object_id_from2 = p_project_id;
1148:
1149: l_dummy number;

Line 1173: --Bug No 3634315 Performance Fix, to avoid full table scan on pa_object_relationships table.

1169:
1170: FUNCTION Is_Proj_Sub_Project(p_project_id IN NUMBER)
1171: RETURN VARCHAR2
1172: IS
1173: --Bug No 3634315 Performance Fix, to avoid full table scan on pa_object_relationships table.
1174: /* CURSOR c1 IS
1175: select 1
1176: from pa_object_relationships
1177: where relationship_type IN ('LW', 'LF')

Line 1176: from pa_object_relationships

1172: IS
1173: --Bug No 3634315 Performance Fix, to avoid full table scan on pa_object_relationships table.
1174: /* CURSOR c1 IS
1175: select 1
1176: from pa_object_relationships
1177: where relationship_type IN ('LW', 'LF')
1178: and object_id_to2 = p_project_id;*/
1179: CURSOR c1 IS
1180: select 1

Line 1181: from pa_object_relationships por,

1177: where relationship_type IN ('LW', 'LF')
1178: and object_id_to2 = p_project_id;*/
1179: CURSOR c1 IS
1180: select 1
1181: from pa_object_relationships por,
1182: pa_proj_element_versions ppev
1183: where por.relationship_type IN ('LW', 'LF')
1184: and ppev.element_version_id = por.object_id_to1
1185: and por.object_id_to2 = ppev.project_id

Line 1205: from pa_object_relationships

1201: RETURN varchar2
1202: IS
1203: CURSOR c1 IS
1204: select 1
1205: from pa_object_relationships
1206: where relationship_type IN ('LW', 'LF')
1207: and object_id_from2 = p_project_id;
1208: l_dummy NUMBER;
1209: BEGIN

Line 1223: --Bug No 3634315 Performance Fix, to avoid full table scan on pa_object_relationships table.

1219:
1220: FUNCTION DISABLE_MULTI_PROG_OK(p_project_id NUMBER)
1221: RETURN varchar2
1222: IS
1223: --Bug No 3634315 Performance Fix, to avoid full table scan on pa_object_relationships table.
1224: /* CURSOR c1(c_parent_project_id NUMBER, c_child_project_id NUMBER) IS
1225: select count(1)
1226: from pa_object_relationships
1227: where relationship_type IN ('LW', 'LF')

Line 1226: from pa_object_relationships

1222: IS
1223: --Bug No 3634315 Performance Fix, to avoid full table scan on pa_object_relationships table.
1224: /* CURSOR c1(c_parent_project_id NUMBER, c_child_project_id NUMBER) IS
1225: select count(1)
1226: from pa_object_relationships
1227: where relationship_type IN ('LW', 'LF')
1228: and object_id_to2 = c_child_project_id
1229: and object_id_from1 <> c_parent_project_id;*/
1230: CURSOR c1(c_parent_project_id NUMBER, c_child_project_id NUMBER) IS

Line 1232: from pa_object_relationships por,

1228: and object_id_to2 = c_child_project_id
1229: and object_id_from1 <> c_parent_project_id;*/
1230: CURSOR c1(c_parent_project_id NUMBER, c_child_project_id NUMBER) IS
1231: select count(1)
1232: from pa_object_relationships por,
1233: pa_proj_element_versions ppev
1234: where relationship_type IN ('LW', 'LF')
1235: and ppev.element_version_id = object_id_to1
1236: and por.object_id_to2 = ppev.project_id

Line 1242: from pa_object_relationships

1238: and object_id_from2 <> c_parent_project_id;--bug 4244482
1239:
1240: CURSOR c2 IS
1241: select object_id_from2, object_Id_to2
1242: from pa_object_relationships
1243: where relationship_type IN ('LW') --bug 3962849
1244: start with object_id_from2 = p_project_id
1245: and relationship_type = 'LW'
1246: connect by prior object_id_to2 = object_id_from2

Line 1251: from pa_object_relationships

1247: and prior relationship_type = relationship_type;
1248:
1249: CURSOR c3 IS
1250: select object_id_from2, object_Id_to2
1251: from pa_object_relationships
1252: where relationship_type IN ('LF') --bug 3962849
1253: start with object_id_from2 = p_project_id
1254: and relationship_type = 'LF'
1255: connect by prior object_id_to2 = object_id_from2

Line 1306: from pa_object_relationships

1302: where element_version_id = c_element_version_id;
1303:
1304: CURSOR get_loop1(c_project_id NUMBER) IS
1305: select object_Id_to2, object_id_from2 -- Fix for Bug # 4297715.
1306: from pa_object_relationships
1307: where relationship_type IN ('LW')
1308: start with object_id_from2 = c_project_id
1309: connect by prior object_id_to2 = object_id_from2
1310: and prior relationship_type = relationship_type

Line 1315: from pa_object_relationships

1311: and relationship_type = 'LW';
1312:
1313: CURSOR get_loop2(c_project_id NUMBER) IS
1314: select object_Id_to2, object_id_from2 -- Fix for Bug # 4297715.
1315: from pa_object_relationships
1316: where relationship_type IN ('LF')
1317: start with object_id_from2 = c_project_id
1318: connect by prior object_id_to2 = object_id_from2
1319: and prior relationship_type = relationship_type

Line 1340: FROM pa_object_relationships

1336: AND ppe.object_type = 'PA_TASKS'
1337: AND ppe.project_id = ppa.project_id
1338: AND ppev.element_version_id IN (
1339: SELECT object_id_from1
1340: FROM pa_object_relationships
1341: WHERE relationship_type IN ('LW','LF')
1342: START WITH object_id_to2 = c_project_id
1343: AND object_type_to = 'PA_STRUCTURES'
1344: CONNECT BY object_id_from2 = prior object_id_to2

Line 1358: from pa_object_relationships a

1354: where project_id = c_project_id;
1355:
1356: CURSOR get_child_links(c_project_id NUMBER, c_parent_proj_id NUMBER) IS
1357: select distinct(object_id_from2)
1358: from pa_object_relationships a
1359: where a.relationship_type IN ('LW','LF')
1360: and a.object_id_to2 = c_project_id
1361: and a.object_id_from2 <> c_parent_proj_id -- Fix for Bug # 4297715.
1362: and exists (select 1 from PA_PROJ_ELEMENT_VERSIONS elv /* Added the exists for Bug 6148092 */

Line 1401: from pa_object_relationships por

1397:
1398: cursor cur_dep_hierarchy(c_src_task_ver_id NUMBER) is
1399: -- This query selects all the successor projects of the source project.
1400: select por.object_id_from2 project_id
1401: from pa_object_relationships por
1402: where por.relationship_type = 'D'
1403: start with por.object_id_to1 = c_src_task_ver_id
1404: -- connect by prior por.object_id_from2 = por.object_id_to2 -- Fix for Bug # 4256435.
1405: connect by prior por.object_id_from1 = por.object_id_to1 -- Fix for Bug # 4256435.

Line 1411: from pa_object_relationships por

1407: and por.relationship_type = 'D'
1408: union all
1409: -- This query selects all the predecessor projects of the source project.
1410: select por.object_id_to2 project_id
1411: from pa_object_relationships por
1412: where por.relationship_type = 'D'
1413: start with por.object_id_from1 = c_src_task_ver_id
1414: -- connect by prior por.object_id_to2 = por.object_id_from2 -- Fix for Bug # 4256435.
1415: connect by prior por.object_id_to1 = por.object_id_from1 -- Fix for Bug # 4256435.

Line 1631: from pa_object_relationships por1,

1627: RETURN NUMBER
1628: IS
1629: CURSOR c1 IS
1630: select por2.object_relationship_id, por2.relationship_type, ppev.element_version_id
1631: from pa_object_relationships por1,
1632: pa_object_relationships por2,
1633: pa_proj_element_versions ppev,
1634: pa_proj_elements ppe
1635: where ppe.proj_element_id = p_task_id

Line 1632: pa_object_relationships por2,

1628: IS
1629: CURSOR c1 IS
1630: select por2.object_relationship_id, por2.relationship_type, ppev.element_version_id
1631: from pa_object_relationships por1,
1632: pa_object_relationships por2,
1633: pa_proj_element_versions ppev,
1634: pa_proj_elements ppe
1635: where ppe.proj_element_id = p_task_id
1636: and ppe.proj_element_id = ppev.proj_element_id

Line 1648: from pa_object_relationships por1,

1644: order by ppev.element_version_id desc ; -- por2.relationship_type desc, -- Fix for Bug # 4477118.
1645:
1646: /*
1647: select por1.object_id_from1
1648: from pa_object_relationships por1,
1649: pa_object_relationships por2
1650: where por2.object_id_to1 = p_structure_ver_id
1651: and por2.object_id_from1 = por1.object_id_to1
1652: and por2.relationship_type IN ('LF', 'LW')

Line 1649: pa_object_relationships por2

1645:
1646: /*
1647: select por1.object_id_from1
1648: from pa_object_relationships por1,
1649: pa_object_relationships por2
1650: where por2.object_id_to1 = p_structure_ver_id
1651: and por2.object_id_from1 = por1.object_id_to1
1652: and por2.relationship_type IN ('LF', 'LW')
1653: and rownum < 2

Line 1675: from pa_object_relationships por1,

1671: RETURN NUMBER
1672: IS
1673: CURSOR c1 IS
1674: select por2.object_relationship_id, por2.relationship_type, ppev.element_version_id
1675: from pa_object_relationships por1,
1676: pa_object_relationships por2,
1677: pa_proj_element_versions ppev,
1678: pa_proj_elements ppe
1679: where ppe.proj_element_id = p_task_id

Line 1676: pa_object_relationships por2,

1672: IS
1673: CURSOR c1 IS
1674: select por2.object_relationship_id, por2.relationship_type, ppev.element_version_id
1675: from pa_object_relationships por1,
1676: pa_object_relationships por2,
1677: pa_proj_element_versions ppev,
1678: pa_proj_elements ppe
1679: where ppe.proj_element_id = p_task_id
1680: and ppe.proj_element_id = ppev.proj_element_id

Line 1706: from pa_object_relationships por1,

1702: RETURN NUMBER
1703: IS
1704: CURSOR c1 IS
1705: select por2.object_id_to1
1706: from pa_object_relationships por1,
1707: pa_object_relationships por2
1708: where por1.object_id_from1 = p_task_ver_id
1709: and por1.object_id_to1 = por2.object_id_from1
1710: and por2.relationship_type IN ('LF', 'LW')

Line 1707: pa_object_relationships por2

1703: IS
1704: CURSOR c1 IS
1705: select por2.object_id_to1
1706: from pa_object_relationships por1,
1707: pa_object_relationships por2
1708: where por1.object_id_from1 = p_task_ver_id
1709: and por1.object_id_to1 = por2.object_id_from1
1710: and por2.relationship_type IN ('LF', 'LW')
1711: and rownum < 2

Line 1757: FROM pa_object_relationships por1

1753: FUNCTION get_predecessors( p_src_task_ver_id IN NUMBER
1754: ,p_orig_succ_task_ver_id IN NUMBER ) RETURN BOOLEAN IS
1755: CURSOR cur_get_predecessors IS
1756: SELECT por1.object_id_to1 RELATED_TASK
1757: FROM pa_object_relationships por1
1758: WHERE por1.relationship_type = 'D'
1759: AND LEVEL = 1
1760: AND por1.object_id_from2 = por1.object_id_to2
1761: START WITH por1.object_id_from1 = p_src_task_ver_id

Line 1801: FROM pa_object_relationships por1

1797: FUNCTION get_parents_childs( p_src_task_ver_id IN NUMBER
1798: ,p_orig_succ_task_ver_id IN NUMBER ) RETURN BOOLEAN IS
1799: CURSOR cur_get_parents_childs IS
1800: SELECT por1.object_id_to1 RELATED_TASK
1801: FROM pa_object_relationships por1
1802: WHERE por1.relationship_type = 'S'
1803: AND por1.relationship_subtype = 'TASK_TO_TASK'
1804: START WITH por1.object_id_from1 = p_src_task_ver_id
1805: AND relationship_type = 'S' --bug 3944567

Line 1810: FROM pa_object_relationships por2

1806: CONNECT BY PRIOR por1.object_id_to1 = por1.object_id_from1
1807: AND PRIOR por1.relationship_type = por1.relationship_type
1808: UNION
1809: SELECT por2.object_id_from1 RELATED_TASK
1810: FROM pa_object_relationships por2
1811: WHERE por2.relationship_type = 'S'
1812: AND por2.relationship_subtype = 'TASK_TO_TASK'
1813: START WITH por2.object_id_to1 = p_src_task_ver_id
1814: AND relationship_type = 'S' --bug 3944567

Line 1825: from pa_object_relationships

1821:
1822: --bug 4145585
1823: Cursor check_intersect IS
1824: select object_id_from1 elem_ver_id
1825: from pa_object_relationships
1826: start with object_id_to1 = p_orig_succ_task_ver_id
1827: and relationship_type = 'D'
1828: connect by object_id_to1 = prior object_id_from1
1829: and relationship_type = prior relationship_type

Line 1833: from pa_object_relationships

1829: and relationship_type = prior relationship_type
1830: and object_id_to2 = object_id_from2
1831: INTERSECT
1832: select object_id_to1
1833: from pa_object_relationships
1834: start with object_id_to1 = p_src_task_ver_id
1835: and relationship_type = 'S'
1836: connect by prior object_id_to1 = object_id_from1
1837: and relationship_type = prior relationship_type;

Line 1872: Select count(1) from pa_object_relationships

1868: ,p_link_type VARCHAR2 DEFAULT 'SHARED' --bug 4532826
1869: ) return VARCHAR2
1870: IS
1871: CURSOR get_count IS
1872: Select count(1) from pa_object_relationships
1873: where relationship_type IN ('LW', 'LF')
1874: and (object_id_from2 = p_project_id or object_id_to2 = p_project_id);
1875:
1876: -- bug 4532826

Line 1878: Select count(1) from pa_object_relationships

1874: and (object_id_from2 = p_project_id or object_id_to2 = p_project_id);
1875:
1876: -- bug 4532826
1877: CURSOR get_count_fn IS
1878: Select count(1) from pa_object_relationships
1879: where relationship_type = 'LF'
1880: and (object_id_from2 = p_project_id or object_id_to2 = p_project_id);
1881:
1882: CURSOR get_count_wp IS

Line 1883: Select count(1) from pa_object_relationships

1879: where relationship_type = 'LF'
1880: and (object_id_from2 = p_project_id or object_id_to2 = p_project_id);
1881:
1882: CURSOR get_count_wp IS
1883: Select count(1) from pa_object_relationships
1884: where relationship_type = 'LW'
1885: and (object_id_from2 = p_project_id or object_id_to2 = p_project_id);
1886: --end bug 4532826
1887:

Line 1951: from pa_object_relationships

1947: ,p_task_ver_id IN NUMBER) RETURN VARCHAR2
1948: IS
1949: CURSOR get_parent_to_child IS
1950: select count(1)
1951: from pa_object_relationships
1952: where relationship_type = 'D'
1953: and object_id_from1 IN ( --get all tasks in upper branch
1954: select object_id_to1
1955: from pa_object_relationships

Line 1955: from pa_object_relationships

1951: from pa_object_relationships
1952: where relationship_type = 'D'
1953: and object_id_from1 IN ( --get all tasks in upper branch
1954: select object_id_to1
1955: from pa_object_relationships
1956: start with object_id_to1 = p_new_parent_task_ver_id
1957: and relationship_type = 'S'
1958: connect by prior object_id_from1 = object_id_to1
1959: and relationship_type = prior relationship_type

Line 1963: from pa_object_relationships

1959: and relationship_type = prior relationship_type
1960: and prior object_type_from = object_type_to)
1961: and object_id_to1 IN ( --get all tasks in lower branch
1962: select object_id_to1
1963: from pa_object_relationships
1964: start with object_id_to1 = p_task_ver_id
1965: and relationship_type = 'S'
1966: connect by prior object_id_to1 = object_id_from1
1967: and relationship_type = prior relationship_type

Line 1972: from pa_object_relationships

1968: and prior object_type_to = object_type_from);
1969:
1970: CURSOR get_child_to_parent IS
1971: select count(1)
1972: from pa_object_relationships
1973: where relationship_type = 'D'
1974: and object_id_from1 IN ( --get tasks in lower branch
1975: select object_id_to1
1976: from pa_object_relationships

Line 1976: from pa_object_relationships

1972: from pa_object_relationships
1973: where relationship_type = 'D'
1974: and object_id_from1 IN ( --get tasks in lower branch
1975: select object_id_to1
1976: from pa_object_relationships
1977: start with object_id_to1 = p_task_ver_id
1978: and relationship_type = 'S'
1979: connect by prior object_id_to1 = object_id_from1
1980: and relationship_type = prior relationship_type

Line 1984: from pa_object_relationships

1980: and relationship_type = prior relationship_type
1981: and prior object_type_to = object_type_from)
1982: and object_id_to1 IN ( --get tasks in upper branch
1983: select object_id_to1
1984: from pa_object_relationships
1985: start with object_id_to1 = p_new_parent_task_ver_id
1986: and relationship_type = 'S'
1987: connect by prior object_id_from1 = object_id_to1
1988: and relationship_type = prior relationship_type

Line 2093: from pa_proj_element_versions pev, pa_object_relationships por, pa_proj_elem_ver_structure ppevs

2089:
2090: select 1
2091: from dual
2092: where exists (select 1
2093: from pa_proj_element_versions pev, pa_object_relationships por, pa_proj_elem_ver_structure ppevs
2094: where pev.parent_structure_version_id = c_object_id_from
2095: and pev.element_version_id = por.object_id_from1
2096: and por.object_id_to1 = ppevs.element_version_id
2097: -- Bug Fix 5077552

Line 2109: from pa_object_relationships por

2105: -- Bug # 4737033.
2106:
2107: select ppevs.status_code status_code
2108: from (select por.object_id_to1
2109: from pa_object_relationships por
2110: where por.object_type_to = 'PA_STRUCTURES'
2111: and relationship_type in (c_relationship_type, 'S')
2112: start with por.object_id_from1 = c_object_id_from
2113: connect by prior por.object_id_to1 = por.object_id_from1

Line 2120: from pa_object_relationships por, pa_proj_elem_ver_structure ppevs

2116: where
2117: por.object_id_to1 = ppevs.element_version_id (+);
2118:
2119: select ppevs.status_code status_code
2120: from pa_object_relationships por, pa_proj_elem_ver_structure ppevs
2121: where por.object_id_to1 = ppevs.element_version_id (+)
2122: and por.object_type_to = 'PA_STRUCTURES'
2123: and relationship_type in (c_relationship_type, 'S')
2124: start with por.object_id_from1 = c_object_id_from

Line 2190: from pa_object_relationships por

2186: )RETURN VARCHAR2
2187: IS
2188: CURSOR check_parentproj_exists IS
2189: SELECT '1'
2190: from pa_object_relationships por
2191: WHERE p_structure_ver_id = por.object_id_to1
2192: and por.object_id_to2 = p_project_id
2193: and por.relationship_type IN ('LW', 'LF');
2194:

Line 2198: from pa_object_relationships por

2194:
2195:
2196: CURSOR check_parentproj_exists_wp IS
2197: SELECT '1'
2198: from pa_object_relationships por
2199: WHERE p_structure_ver_id = por.object_id_to1
2200: and por.object_id_to2 = p_project_id
2201: and por.relationship_type = 'LW';
2202:

Line 2205: from pa_object_relationships por

2201: and por.relationship_type = 'LW';
2202:
2203: CURSOR check_parentproj_exists_fn IS
2204: SELECT '1'
2205: from pa_object_relationships por
2206: WHERE p_structure_ver_id = por.object_id_to1
2207: and por.object_id_to2 = p_project_id
2208: and por.relationship_type = 'LF';
2209:

Line 2255: Select count(1) from pa_object_relationships

2251: ,p_link_type VARCHAR2 DEFAULT 'SHARED' --bug 4532826
2252: ) return VARCHAR2
2253: IS
2254: CURSOR get_count IS
2255: Select count(1) from pa_object_relationships
2256: where relationship_type IN ('LW', 'LF')
2257: and object_id_from2 = p_project_id;
2258:
2259: CURSOR get_count_fn IS

Line 2260: Select count(1) from pa_object_relationships

2256: where relationship_type IN ('LW', 'LF')
2257: and object_id_from2 = p_project_id;
2258:
2259: CURSOR get_count_fn IS
2260: Select count(1) from pa_object_relationships
2261: where relationship_type = 'LF'
2262: and object_id_from2 = p_project_id;
2263:
2264: CURSOR get_count_wp IS

Line 2265: Select count(1) from pa_object_relationships

2261: where relationship_type = 'LF'
2262: and object_id_from2 = p_project_id;
2263:
2264: CURSOR get_count_wp IS
2265: Select count(1) from pa_object_relationships
2266: where relationship_type = 'LW'
2267: and (object_id_from2 = p_project_id);
2268:
2269: