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_TASKS

Line 57: and object_type_from = 'PA_TASKS'

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:
60: cursor Is_structure(c_element_version_id NUMBER) IS
61: select '1'

Line 72: cursor Check_PA_TASKS_Exists(c_task_id NUMBER) IS

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
73: select '1'
74: from PA_TASKS
75: where task_id = c_task_id;
76:

Line 74: from PA_TASKS

70: l_from_struc_ver_id NUMBER;
71:
72: cursor Check_PA_TASKS_Exists(c_task_id NUMBER) IS
73: select '1'
74: from PA_TASKS
75: where task_id = c_task_id;
76:
77: cursor Is_Same_Struc(c_elem_ver_from NUMBER, c_elem_ver_to NUMBER) IS
78: select '1'

Line 156: and object_type_from IN ('PA_TASKS','PA_STRUCTURES')

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: )
156: and object_type_from IN ('PA_TASKS','PA_STRUCTURES')
157: and object_type_to IN ('PA_TASKS','PA_STRUCTURES')
158: and relationship_type IN ('S','L')
159: connect by prior object_id_to1 = object_id_from1
160: and object_type_from IN ('PA_TASKS','PA_STRUCTURES')

Line 157: and object_type_to IN ('PA_TASKS','PA_STRUCTURES')

153: and a.proj_element_id = b.proj_element_id
154: and a.project_id = b.project_id
155: )
156: and object_type_from IN ('PA_TASKS','PA_STRUCTURES')
157: and object_type_to IN ('PA_TASKS','PA_STRUCTURES')
158: and relationship_type IN ('S','L')
159: connect by prior object_id_to1 = object_id_from1
160: and object_type_from IN ('PA_TASKS','PA_STRUCTURES')
161: and prior object_type_to IN ('PA_TASKS','PA_STRUCTURES')

Line 160: and object_type_from IN ('PA_TASKS','PA_STRUCTURES')

156: and object_type_from IN ('PA_TASKS','PA_STRUCTURES')
157: and object_type_to IN ('PA_TASKS','PA_STRUCTURES')
158: and relationship_type IN ('S','L')
159: connect by prior object_id_to1 = object_id_from1
160: and object_type_from IN ('PA_TASKS','PA_STRUCTURES')
161: and prior object_type_to IN ('PA_TASKS','PA_STRUCTURES')
162: and prior relationship_type IN ('S','L')
163: );
164:

Line 161: and prior object_type_to IN ('PA_TASKS','PA_STRUCTURES')

157: and object_type_to IN ('PA_TASKS','PA_STRUCTURES')
158: and relationship_type IN ('S','L')
159: connect by prior object_id_to1 = object_id_from1
160: and object_type_from IN ('PA_TASKS','PA_STRUCTURES')
161: and prior object_type_to IN ('PA_TASKS','PA_STRUCTURES')
162: and prior relationship_type IN ('S','L')
163: );
164:
165:

Line 172: and a.object_type_to IN ('PA_STRUCTURES','PA_TASKS')

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
174: and a.relationship_type IN ('S','L')
175: union
176: select a.object_id_from1

Line 179: and object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')

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;
182:
183: cursor Is_Version_Exist(c_top_node_id NUMBER, c_linking_node_id NUMBER) IS

Line 188: and object_type_from IN ('PA_STRUCTURES','PA_TASKS')

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
190: and relationship_type IN ('L','S')
191: intersect
192: (

Line 205: and object_type_from IN ('PA_STRUCTURES','PA_TASKS')

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
207: and relationship_type IN('L','S')
208: -- UNION
209: -- select object_id_from1

Line 213: -- and object_type_to IN ('PA_STRUCTURES','PA_TASKS')

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
215: -- and relationship_type IN ('S','L')
216: UNION
217: select element_version_id

Line 291: IF (l_object_type = 'PA_TASKS') THEN

287: l_from_struc_ver_id, 'FINANCIAL') = 'Y') THEN
288: --Check for transaction for this task
289:
290:
291: IF (l_object_type = 'PA_TASKS') THEN
292: --Bug 2183974
293: --Check if this task is valid in PA_TASKS first
294: OPEN Check_PA_TASKS_Exists(l_element_id);
295: FETCH Check_PA_TASKS_Exists into l_dummy;

Line 293: --Check if this task is valid in PA_TASKS first

289:
290:
291: IF (l_object_type = 'PA_TASKS') THEN
292: --Bug 2183974
293: --Check if this task is valid in PA_TASKS first
294: OPEN Check_PA_TASKS_Exists(l_element_id);
295: FETCH Check_PA_TASKS_Exists into l_dummy;
296: IF Check_PA_TASKS_Exists%NOTFOUND THEN
297: CLOSE Check_PA_TASKS_Exists;

Line 294: OPEN Check_PA_TASKS_Exists(l_element_id);

290:
291: IF (l_object_type = 'PA_TASKS') THEN
292: --Bug 2183974
293: --Check if this task is valid in PA_TASKS first
294: OPEN Check_PA_TASKS_Exists(l_element_id);
295: FETCH Check_PA_TASKS_Exists into l_dummy;
296: IF Check_PA_TASKS_Exists%NOTFOUND THEN
297: CLOSE Check_PA_TASKS_Exists;
298: x_error_message_code := 'PA_PS_PA_TASKS_NOT_EXISTS';

Line 295: FETCH Check_PA_TASKS_Exists into l_dummy;

291: IF (l_object_type = 'PA_TASKS') THEN
292: --Bug 2183974
293: --Check if this task is valid in PA_TASKS first
294: OPEN Check_PA_TASKS_Exists(l_element_id);
295: FETCH Check_PA_TASKS_Exists into l_dummy;
296: IF Check_PA_TASKS_Exists%NOTFOUND THEN
297: CLOSE Check_PA_TASKS_Exists;
298: x_error_message_code := 'PA_PS_PA_TASKS_NOT_EXISTS';
299: x_return_status := FND_API.G_RET_STS_ERROR;

Line 296: IF Check_PA_TASKS_Exists%NOTFOUND THEN

292: --Bug 2183974
293: --Check if this task is valid in PA_TASKS first
294: OPEN Check_PA_TASKS_Exists(l_element_id);
295: FETCH Check_PA_TASKS_Exists into l_dummy;
296: IF Check_PA_TASKS_Exists%NOTFOUND THEN
297: CLOSE Check_PA_TASKS_Exists;
298: x_error_message_code := 'PA_PS_PA_TASKS_NOT_EXISTS';
299: x_return_status := FND_API.G_RET_STS_ERROR;
300: return;

Line 297: CLOSE Check_PA_TASKS_Exists;

293: --Check if this task is valid in PA_TASKS first
294: OPEN Check_PA_TASKS_Exists(l_element_id);
295: FETCH Check_PA_TASKS_Exists into l_dummy;
296: IF Check_PA_TASKS_Exists%NOTFOUND THEN
297: CLOSE Check_PA_TASKS_Exists;
298: x_error_message_code := 'PA_PS_PA_TASKS_NOT_EXISTS';
299: x_return_status := FND_API.G_RET_STS_ERROR;
300: return;
301: ELSE

Line 298: x_error_message_code := 'PA_PS_PA_TASKS_NOT_EXISTS';

294: OPEN Check_PA_TASKS_Exists(l_element_id);
295: FETCH Check_PA_TASKS_Exists into l_dummy;
296: IF Check_PA_TASKS_Exists%NOTFOUND THEN
297: CLOSE Check_PA_TASKS_Exists;
298: x_error_message_code := 'PA_PS_PA_TASKS_NOT_EXISTS';
299: x_return_status := FND_API.G_RET_STS_ERROR;
300: return;
301: ELSE
302: --Task exists

Line 303: CLOSE Check_PA_TASKS_Exists;

299: x_return_status := FND_API.G_RET_STS_ERROR;
300: return;
301: ELSE
302: --Task exists
303: CLOSE Check_PA_TASKS_Exists;
304: PA_TASK_UTILS.CHECK_CREATE_SUBTASK_OK(x_task_id => l_element_id,
305: x_err_code => l_err_code,
306: x_err_stack => l_err_stack,
307: x_err_stage => l_err_stage

Line 1075: AND por.object_type_from = 'PA_TASKS' --4141109 Replaced LIKE with Equijoin

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
1077: AND por.relationship_type = 'D'); --4141109 Replaced LIKE with Equijoin
1078: l_cur_task_names_rec cur_task_names%ROWTYPE;
1079: BEGIN

Line 1076: AND por.object_type_to = 'PA_TASKS' --4141109 Replaced LIKE with Equijoin

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
1077: AND por.relationship_type = 'D'); --4141109 Replaced LIKE with Equijoin
1078: l_cur_task_names_rec cur_task_names%ROWTYPE;
1079: BEGIN
1080: OPEN cur_task_names(p_element_version_id);

Line 1335: AND ppev.object_type = 'PA_TASKS'

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
1335: AND ppev.object_type = 'PA_TASKS'
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

Line 1336: AND ppe.object_type = 'PA_TASKS'

1332: pa_projects_all ppa
1333: WHERE ppe.project_id = ppev.project_id
1334: AND ppe.proj_element_id = ppev.proj_element_id
1335: AND ppev.object_type = 'PA_TASKS'
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

Line 1347: AND object_type_from = 'PA_TASKS');

1343: AND object_type_to = 'PA_STRUCTURES'
1344: CONNECT BY object_id_from2 = prior object_id_to2
1345: and prior relationship_type = relationship_type
1346: AND relationship_type IN ('LW','LF')
1347: AND object_type_from = 'PA_TASKS');
1348: -- End of Bug 3621794
1349: --
1350: --bug 3893970
1351: CURSOR get_multi_rollup(c_project_id NUMBER) IS