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_XC_PROJECT_PUB dependencies on PA_TASKS

Line 92: l_long_task_name pa_tasks.long_task_name%TYPE := null; -- Added for bug 5465108

88: l_task_start_date DATE := NULL;
89: l_task_finish_date DATE := NULL;
90: l_sched_start_date DATE; /* 7245488 */
91: l_sched_fin_date DATE; /* 7245488 */
92: l_long_task_name pa_tasks.long_task_name%TYPE := null; -- Added for bug 5465108
93:
94: l_task_id NUMBER :=NULL;
95: l_task_manager_id NUMBER :=NULL;
96:

Line 120: AND ppe.object_type = 'PA_TASKS'

116: SELECT ppe.proj_element_id, ppe.name, ppe.element_number, ppe.description, ppe.pm_source_reference, ppe.manager_person_id, ppe.carrying_out_organization_id
117: FROM PA_PROJ_ELEMENTS ppe, PA_PROJ_ELEMENT_VERSIONS ppev
118: WHERE ppe.project_id = c_project_id
119: AND ppe.project_id = ppev.project_id -- 3693934 added for peformance fix
120: AND ppe.object_type = 'PA_TASKS'
121: AND ppe.proj_element_id = ppev.proj_element_id
122: AND ppev.parent_structure_version_id = c_structure_version_id
123: AND ppev.financial_task_flag = 'Y'
124: ORDER BY ppev.display_sequence;

Line 135: AND ppev.object_type = 'PA_TASKS'

131: SELECT ppevs.scheduled_start_date, ppevs.scheduled_finish_date
132: FROM PA_PROJ_ELEMENT_VERSIONS ppev, PA_PROJ_ELEM_VER_SCHEDULE ppevs
133: WHERE ppev.element_version_id = ppevs.element_version_id
134: AND ppev.project_id = ppevs.project_id -- 3693934 added for peformance fix
135: AND ppev.object_type = 'PA_TASKS'
136: AND ppev.proj_element_id = c_proj_element_id
137: AND ppev.parent_structure_version_id = c_structure_version_id;
138:
139: -- Retrieve task Start and End Date from PA_TASKS table

Line 139: -- Retrieve task Start and End Date from PA_TASKS table

135: AND ppev.object_type = 'PA_TASKS'
136: AND ppev.proj_element_id = c_proj_element_id
137: AND ppev.parent_structure_version_id = c_structure_version_id;
138:
139: -- Retrieve task Start and End Date from PA_TASKS table
140: CURSOR pa_tasks_dates_csr (c_task_id NUMBER)
141: IS
142: SELECT start_date, completion_date, long_task_name -- Modified for bug 5465108
143: FROM pa_tasks

Line 140: CURSOR pa_tasks_dates_csr (c_task_id NUMBER)

136: AND ppev.proj_element_id = c_proj_element_id
137: AND ppev.parent_structure_version_id = c_structure_version_id;
138:
139: -- Retrieve task Start and End Date from PA_TASKS table
140: CURSOR pa_tasks_dates_csr (c_task_id NUMBER)
141: IS
142: SELECT start_date, completion_date, long_task_name -- Modified for bug 5465108
143: FROM pa_tasks
144: WHERE task_id = c_task_id;

Line 143: FROM pa_tasks

139: -- Retrieve task Start and End Date from PA_TASKS table
140: CURSOR pa_tasks_dates_csr (c_task_id NUMBER)
141: IS
142: SELECT start_date, completion_date, long_task_name -- Modified for bug 5465108
143: FROM pa_tasks
144: WHERE task_id = c_task_id;
145:
146: CURSOR get_parent_id_csr (c_proj_element_id NUMBER)
147: IS

Line 154: AND por.object_type_from = 'PA_TASKS'

150: PA_PROJ_ELEMENT_VERSIONS ppev,
151: PA_PROJ_ELEMENT_VERSIONS ppev2
152: WHERE por.relationship_type = 'S'
153: AND por.object_id_to1 = ppev.element_version_id
154: AND por.object_type_from = 'PA_TASKS'
155: AND ppev.proj_element_id = c_proj_element_id
156: AND ppev.parent_structure_version_id = p_structure_version_id -- Bug 2873691
157: AND ppev2.element_version_id = por.object_id_from1;
158:

Line 175: AND ppe.object_type = 'PA_TASKS'

171: /*cursor l_pm_source_ref(c_structure_version_id NUMBER, c_project_id NUMBER) IS
172: select min(to_Number(ppe.pm_source_reference))
173: FROM PA_PROJ_ELEMENTS ppe, PA_PROJ_ELEMENT_VERSIONS ppev
174: WHERE ppe.project_id = c_project_id
175: AND ppe.object_type = 'PA_TASKS'
176: AND ppe.proj_element_id = ppev.proj_element_id
177: AND ppev.parent_structure_version_id = c_structure_version_id; */
178:
179: --hyau added for debugging unhandled exception stage

Line 185: select task_id from pa_tasks

181: l_counter NUMBER;
182:
183: --hsiu added for initializing pm_source_reference
184: CURSOR get_pa_task(c_proj_element_id NUMBER) IS
185: select task_id from pa_tasks
186: where task_id = c_proj_element_id;
187: l_exist_pa_task_id NUMBER;
188:
189: l_debug_mode VARCHAR2(1); -- Fix for Bug # 4513291.

Line 278: update pa_tasks

274: FETCH get_pa_task into l_exist_pa_task_id;
275:
276: IF (get_pa_task%FOUND) THEN
277:
278: update pa_tasks
279: set pm_task_reference = l_pm_source_reference -- Bug 3302732 l_source_ref_count
280: where task_id = l_exist_pa_task_id;
281:
282: update pa_proj_elements

Line 298: -- fetch the task id from PA_TASKS based on the source reference

294: end if;
295:
296: l_stage := '3.2';
297:
298: -- fetch the task id from PA_TASKS based on the source reference
299:
300: PA_XC_PROJECT_PUB.fetch_task_id
301: ( p_task_index => l_pm_source_reference -- Bug 3302732 to_number(l_pm_source_reference)
302: ,p_project_id => p_project_id

Line 329: OPEN pa_tasks_dates_csr (l_proj_elements_rec.proj_element_id);

325: end if;
326:
327: l_stage := '3.5';
328:
329: OPEN pa_tasks_dates_csr (l_proj_elements_rec.proj_element_id);
330: FETCH pa_tasks_dates_csr INTO l_task_start_date, l_task_finish_date, l_long_task_name; -- Modified for bug 5465108
331: --bug 2858227 see update *** AAKASH 03/19/03 10:09 pm *** senario 3
332: IF pa_tasks_dates_csr%NOTFOUND
333: THEN

Line 330: FETCH pa_tasks_dates_csr INTO l_task_start_date, l_task_finish_date, l_long_task_name; -- Modified for bug 5465108

326:
327: l_stage := '3.5';
328:
329: OPEN pa_tasks_dates_csr (l_proj_elements_rec.proj_element_id);
330: FETCH pa_tasks_dates_csr INTO l_task_start_date, l_task_finish_date, l_long_task_name; -- Modified for bug 5465108
331: --bug 2858227 see update *** AAKASH 03/19/03 10:09 pm *** senario 3
332: IF pa_tasks_dates_csr%NOTFOUND
333: THEN
334: --Commented and replpaced following for BUG 4278979, rtarway

Line 332: IF pa_tasks_dates_csr%NOTFOUND

328:
329: OPEN pa_tasks_dates_csr (l_proj_elements_rec.proj_element_id);
330: FETCH pa_tasks_dates_csr INTO l_task_start_date, l_task_finish_date, l_long_task_name; -- Modified for bug 5465108
331: --bug 2858227 see update *** AAKASH 03/19/03 10:09 pm *** senario 3
332: IF pa_tasks_dates_csr%NOTFOUND
333: THEN
334: --Commented and replpaced following for BUG 4278979, rtarway
335: --l_task_start_date := null;
336: --l_task_finish_date := null;

Line 345: CLOSE pa_tasks_dates_csr;

341:
342:
343: END IF;
344: --bug 2858227
345: CLOSE pa_tasks_dates_csr;
346:
347: --end if;
348:
349: l_stage := '3.6';

Line 354: -- this is because fetch_task_id will only return those task ids in PA_TASKS, but

350:
351: -- populate the temp table
352: -- note that we are populating with the proj_element_id from PA_PROJ_ELEMENTS,
353: -- not the task_id from fetch_task_id
354: -- this is because fetch_task_id will only return those task ids in PA_TASKS, but
355: -- we need the proj_element_id to sync up with the task ids created by AMG later
356:
357: INSERT INTO PA_TEMP_IMPORT_TASKS
358: ( PROJECT_ID

Line 508: FROM pa_tasks

504: -- needed to get the field values associated to a particular Task_Id
505: CURSOR l_get_task_csr (p_project_id NUMBER)
506: IS
507: SELECT task_id
508: FROM pa_tasks
509: WHERE project_id = p_project_id;
510:
511: -- needed to get the field values associated to a particular Project_id
512: CURSOR l_get_project_csr (p_project_id NUMBER)

Line 524: FROM pa_tasks

520: -- needed to get the the set of tasks to be deleted
521: CURSOR l_get_temp_task_csr(l_project_id NUMBER)
522: IS
523: SELECT PM_TASK_REFERENCE, task_id
524: FROM pa_tasks
525: WHERE project_id = l_project_id
526: MINUS
527: SELECT TASK_REFERENCE, task_id
528: FROM pa_temp_import_tasks

Line 536: FROM pa_tasks ttask

532:
533: CURSOR l_get_temp_task_csr(l_project_id NUMBER)
534: IS
535: SELECT PM_TASK_REFERENCE, task_id
536: FROM pa_tasks ttask
537: WHERE project_id = l_project_id
538: AND task_id not in
539: (
540: SELECT task_id

Line 973: -- Sync pa_proj_elements with pa_tasks

969: */
970:
971: if p_calling_mode = 'PUBLISH' then
972:
973: -- Sync pa_proj_elements with pa_tasks
974:
975: -- get the values associated to the project_id
976:
977: OPEN l_get_project_csr(p_project_id);

Line 1106: update PA_TASKS pt

1102: RAISE FND_API.G_EXC_ERROR;
1103: END IF; -- IF l_return_status
1104:
1105: --hsiu added for publishing bug
1106: update PA_TASKS pt
1107: set pt.parent_task_id =
1108: (select a.task_id
1109: from pa_tasks b, pa_temp_import_tasks a
1110: where a.project_id = p_project_id

Line 1109: from pa_tasks b, pa_temp_import_tasks a

1105: --hsiu added for publishing bug
1106: update PA_TASKS pt
1107: set pt.parent_task_id =
1108: (select a.task_id
1109: from pa_tasks b, pa_temp_import_tasks a
1110: where a.project_id = p_project_id
1111: and a.task_reference = b.pm_task_reference -- Bug 3302732: added this
1112: -- Bug 3302732 and to_number(a.task_reference) = to_number(b.pm_task_reference) : Commented this line
1113: and b.task_id = pt.parent_task_id)

Line 1117: update PA_TASKS pt

1113: and b.task_id = pt.parent_task_id)
1114: where pt.project_id = p_project_id;
1115:
1116: --hsiu added for publishing bug
1117: update PA_TASKS pt
1118: set pt.top_task_id =
1119: (select a.task_id
1120: from pa_tasks b, pa_temp_import_tasks a
1121: where a.project_id = p_project_id

Line 1120: from pa_tasks b, pa_temp_import_tasks a

1116: --hsiu added for publishing bug
1117: update PA_TASKS pt
1118: set pt.top_task_id =
1119: (select a.task_id
1120: from pa_tasks b, pa_temp_import_tasks a
1121: where a.project_id = p_project_id
1122: and a.task_reference = b.pm_task_reference
1123: and b.task_id = pt.top_task_id)
1124: where pt.project_id = p_project_id;

Line 1126: -- Need to update pa_tasks so that the newly created financial task have the same task_id

1122: and a.task_reference = b.pm_task_reference
1123: and b.task_id = pt.top_task_id)
1124: where pt.project_id = p_project_id;
1125:
1126: -- Need to update pa_tasks so that the newly created financial task have the same task_id
1127: -- as the tasks in pa_proj_elements
1128: UPDATE PA_TASKS pt
1129: SET pt.task_id =
1130: (select task_id

Line 1128: UPDATE PA_TASKS pt

1124: where pt.project_id = p_project_id;
1125:
1126: -- Need to update pa_tasks so that the newly created financial task have the same task_id
1127: -- as the tasks in pa_proj_elements
1128: UPDATE PA_TASKS pt
1129: SET pt.task_id =
1130: (select task_id
1131: from PA_TEMP_IMPORT_TASKS temp
1132: where temp.project_id = p_project_id

Line 1139: from PA_TASKS t

1135:
1136: UPDATE PA_PROJ_ELEMENTS e
1137: set e.pm_source_reference = (
1138: select PM_TASK_REFERENCE
1139: from PA_TASKS t
1140: where t.task_id = e.proj_element_id
1141: ) where e.project_id = p_project_id;
1142:
1143: end if; -- if p_calling_mode = 'PUBLISH' OR l_sync_import = true then

Line 1310: FROM pa_tasks

1306:
1307: CURSOR l_get_task_csr (c_project_id NUMBER, c_pm_task_reference VARCHAR2)
1308: IS
1309: SELECT task_id
1310: FROM pa_tasks
1311: WHERE project_id = c_project_id
1312: AND pm_task_reference = c_pm_task_reference;
1313:
1314: BEGIN

Line 1475: AND OBJECT_TYPE = 'PA_TASKS';

1471: AND ppe.project_id = p_project_id
1472: AND ppst.structure_type_id = pst.structure_type_id
1473: AND pst.structure_type = 'WORKPLAN' --specified as workplan as this will only called while publishing workplan strcuture
1474: )
1475: AND OBJECT_TYPE = 'PA_TASKS';
1476: -- and rownum = 1; --Commented for Bug 3601700
1477:
1478: return l_unique;
1479: