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_PROJ_ELEMENT_VERSIONS

Line 50: from pa_proj_element_versions

46: l_project_id_to NUMBER;
47:
48: cursor Get_Element_Id(c_element_version_id NUMBER) IS
49: select proj_element_id, object_type
50: from pa_proj_element_versions
51: where element_version_id = c_element_version_id;
52:
53: cursor Is_linked(c_element_version_id NUMBER) IS
54: select '1'

Line 68: from pa_proj_element_versions

64: and object_type_from = 'PA_STRUCTURES';
65:
66: cursor Get_Struc_Ver_Id(c_element_version_id NUMBER) IS
67: select parent_structure_version_id, project_id
68: from pa_proj_element_versions
69: where element_version_id = c_element_version_id;
70: l_from_struc_ver_id NUMBER;
71:
72: cursor Check_PA_TASKS_Exists(c_task_id NUMBER) IS

Line 80: pa_proj_element_versions pev1a,

76:
77: cursor Is_Same_Struc(c_elem_ver_from NUMBER, c_elem_ver_to NUMBER) IS
78: select '1'
79: from pa_proj_elements pe1,
80: pa_proj_element_versions pev1a,
81: pa_proj_element_versions pev1b,
82: pa_proj_element_versions pev2a,
83: pa_proj_element_versions pev2b
84: where pev1b.element_version_id = c_elem_ver_from

Line 81: pa_proj_element_versions pev1b,

77: cursor Is_Same_Struc(c_elem_ver_from NUMBER, c_elem_ver_to NUMBER) IS
78: select '1'
79: from pa_proj_elements pe1,
80: pa_proj_element_versions pev1a,
81: pa_proj_element_versions pev1b,
82: pa_proj_element_versions pev2a,
83: pa_proj_element_versions pev2b
84: where pev1b.element_version_id = c_elem_ver_from
85: and pev1b.parent_structure_version_id = pev1a.element_version_id

Line 82: pa_proj_element_versions pev2a,

78: select '1'
79: from pa_proj_elements pe1,
80: pa_proj_element_versions pev1a,
81: pa_proj_element_versions pev1b,
82: pa_proj_element_versions pev2a,
83: pa_proj_element_versions pev2b
84: where pev1b.element_version_id = c_elem_ver_from
85: and pev1b.parent_structure_version_id = pev1a.element_version_id
86: and pev1a.proj_element_id = pe1.proj_element_id

Line 83: pa_proj_element_versions pev2b

79: from pa_proj_elements pe1,
80: pa_proj_element_versions pev1a,
81: pa_proj_element_versions pev1b,
82: pa_proj_element_versions pev2a,
83: pa_proj_element_versions pev2b
84: where pev1b.element_version_id = c_elem_ver_from
85: and pev1b.parent_structure_version_id = pev1a.element_version_id
86: and pev1a.proj_element_id = pe1.proj_element_id
87: and pev2b.element_version_id = c_elem_ver_to

Line 97: pa_proj_element_versions pev1a,

93:
94: /* cursor Is_Diff_Version_Linked(c_elem_ver_from NUMBER, c_elem_ver_to NUMBER) IS
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

Line 98: pa_proj_element_versions pev1b,

94: /* cursor Is_Diff_Version_Linked(c_elem_ver_from NUMBER, c_elem_ver_to NUMBER) IS
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

Line 108: pa_proj_element_versions pev2a,

104: and pev1b.element_version_id = r.object_id_to1
105: and r.object_id_from1 IN
106: (select pev2b.element_version_id
107: from pa_proj_elements pe2,
108: pa_proj_element_versions pev2a,
109: pa_proj_element_versions pev2b
110: where pev2a.element_version_id = c_elem_ver_to
111: and pev2a.proj_element_id = pe2.proj_element_id
112: and pe2.project_id = pev2b.project_id

Line 109: pa_proj_element_versions pev2b

105: and r.object_id_from1 IN
106: (select pev2b.element_version_id
107: from pa_proj_elements pe2,
108: pa_proj_element_versions pev2a,
109: pa_proj_element_versions pev2b
110: where pev2a.element_version_id = c_elem_ver_to
111: and pev2a.proj_element_id = pe2.proj_element_id
112: and pe2.project_id = pev2b.project_id
113: and pe2.proj_element_id = pev2b.proj_element_id);

Line 119: pa_proj_element_versions pev1a,

115:
116: cursor Is_Diff_Version_Linked(c_elem_ver_from NUMBER, c_elem_ver_to NUMBER) IS
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

Line 120: pa_proj_element_versions pev1b,

116: cursor Is_Diff_Version_Linked(c_elem_ver_from NUMBER, c_elem_ver_to NUMBER) IS
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

Line 130: pa_proj_element_versions pev2a,

126: and pev1b.element_version_id = r.object_id_to1
127: and EXISTS
128: (select pev2b.element_version_id
129: from pa_proj_elements pe2,
130: pa_proj_element_versions pev2a,
131: pa_proj_element_versions pev2b
132: where pev2a.element_version_id = c_elem_ver_to
133: and pev2a.proj_element_id = pe2.proj_element_id
134: and pe2.project_id = pev2b.project_id

Line 131: pa_proj_element_versions pev2b

127: and EXISTS
128: (select pev2b.element_version_id
129: from pa_proj_elements pe2,
130: pa_proj_element_versions pev2a,
131: pa_proj_element_versions pev2b
132: where pev2a.element_version_id = c_elem_ver_to
133: and pev2a.proj_element_id = pe2.proj_element_id
134: and pe2.project_id = pev2b.project_id
135: and pe2.proj_element_id = pev2b.proj_element_id

Line 140: from pa_proj_element_versions a,

136: and r.object_id_from1 = pev2b.element_version_id);
137:
138: cursor Is_Circular_Link(c_from NUMBER, c_to NUMBER) IS
139: select '1'
140: from pa_proj_element_versions a,
141: pa_proj_element_versions b
142: where a.element_version_id = c_from
143: and a.proj_element_id = b.proj_element_id
144: and a.project_id = b.project_id

Line 141: pa_proj_element_versions b

137:
138: cursor Is_Circular_Link(c_from NUMBER, c_to NUMBER) IS
139: select '1'
140: from pa_proj_element_versions a,
141: pa_proj_element_versions b
142: where a.element_version_id = c_from
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 (

Line 150: from pa_proj_element_versions a,

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
152: where a.element_version_id = c_to
153: and a.proj_element_id = b.proj_element_id
154: and a.project_id = b.project_id

Line 151: pa_proj_element_versions b

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
152: where a.element_version_id = c_to
153: and a.proj_element_id = b.proj_element_id
154: and a.project_id = b.project_id
155: )

Line 194: from pa_proj_element_versions pev1b,

190: and relationship_type IN ('L','S')
191: intersect
192: (
193: select pev1b.element_version_id
194: from pa_proj_element_versions pev1b,
195: pa_proj_elements pe1,
196: pa_proj_element_versions pev1a
197: where pev1b.project_id = pe1.project_id
198: and pev1b.proj_element_id = pe1.proj_element_id

Line 196: pa_proj_element_versions pev1a

192: (
193: select pev1b.element_version_id
194: from pa_proj_element_versions pev1b,
195: pa_proj_elements pe1,
196: pa_proj_element_versions pev1a
197: where pev1b.project_id = pe1.project_id
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

Line 218: from pa_proj_element_versions

214: -- connect by prior object_id_from1 = object_id_to1
215: -- and relationship_type IN ('S','L')
216: UNION
217: select element_version_id
218: from pa_proj_element_versions
219: where element_version_id = c_linking_node_id
220: )
221: );
222: l_existing_elem_ver_id NUMBER;

Line 537: ,pa_proj_element_versions ppv1 /* to get link task version id */

533: CURSOR cur_parent_lp_link
534: IS
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'

Line 538: ,pa_proj_element_versions ppv2 /* to get sub project structure version ids */

534: IS
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

Line 886: FROM pa_proj_element_versions

882:
883: CURSOR CUR_valid_sucsr_proj_task
884: IS
885: SELECT 'x'
886: FROM pa_proj_element_versions
887: WHERE project_id = p_project_id
888: AND element_version_id = p_task_ver_id
889: ;
890:

Line 895: FROM pa_proj_element_versions

891:
892: CURSOR CUR_valid_pred_proj_task
893: IS
894: SELECT 'x'
895: FROM pa_proj_element_versions
896: WHERE project_id = p_pre_project_id
897: AND element_version_id = p_pre_task_ver_id
898: ;
899:

Line 1067: FROM pa_proj_element_versions ppev,

1063: l_task_count NUMBER:=0;
1064: CURSOR cur_task_names( c_element_version_id NUMBER )
1065: IS
1066: SELECT ppe.name task_name
1067: FROM pa_proj_element_versions ppev,
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

Line 1137: pa_proj_element_versions ppev

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
1141: and por.object_id_to2 = p_project_id;

Line 1182: pa_proj_element_versions ppev

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
1186: and por.object_id_to2 = p_project_id;

Line 1233: pa_proj_element_versions ppev

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
1237: and object_id_to2 = c_child_project_id

Line 1301: from pa_proj_element_versions

1297: RETURN VARCHAR2
1298: IS
1299: CURSOR get_project_id(c_element_version_id NUMBER) IS
1300: select project_id
1301: from pa_proj_element_versions
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.

Line 1330: FROM pa_proj_element_versions ppev,

1326: WHERE project_id =c_project_id;
1327:
1328: CURSOR get_parent_sub_proj(c_project_id NUMBER) IS
1329: SELECT ppa.sys_program_flag
1330: FROM pa_proj_element_versions ppev,
1331: pa_proj_elements ppe,
1332: pa_projects_all ppa
1333: WHERE ppe.project_id = ppev.project_id
1334: AND ppe.proj_element_id = ppev.proj_element_id

Line 1362: and exists (select 1 from PA_PROJ_ELEMENT_VERSIONS elv /* Added the exists for Bug 6148092 */

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 */
1363: where elv.element_version_id = a.object_id_from1
1364: and ((elv.PARENT_STRUCTURE_VERSION_ID =
1365: PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(elv.project_id))
1366: or (elv.PARENT_STRUCTURE_VERSION_ID =

Line 1385: from pa_proj_elem_ver_structure ppevs, pa_proj_element_versions ppev

1381: -- Begin Fix for Bug # 4297715.
1382:
1383: cursor cur_get_status_code(c_task_version_id NUMBER) is
1384: select ppevs.status_code
1385: from pa_proj_elem_ver_structure ppevs, pa_proj_element_versions ppev
1386: where ppev.element_version_id = c_task_version_id
1387: and ppev.project_id = ppevs.project_id -- Bug # 4868867.
1388: and ppev.parent_structure_version_id = ppevs.element_version_id;
1389:

Line 1633: pa_proj_element_versions ppev,

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
1637: and ppe.project_id = ppev.project_id

Line 1677: pa_proj_element_versions ppev,

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
1681: and ppe.project_id = ppev.project_id

Line 2026: from pa_proj_element_versions ppev

2022: and pslv.parent_task_version_id = c_task_version_id;
2023:
2024: cursor cur_task_version_id (c_project_id NUMBER, c_task_id NUMBER, c_structure_version_id NUMBER) is
2025: select ppev.element_version_id
2026: from pa_proj_element_versions ppev
2027: where ppev.project_id = c_project_id
2028: and ppev.proj_element_id = c_task_id
2029: and ppev.parent_structure_version_id = c_structure_version_id;
2030:

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