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 94: l_long_task_name pa_tasks.long_task_name%TYPE := null; -- Added for bug 5465108

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

Line 122: AND ppe.object_type = 'PA_TASKS'

118: 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
119: FROM PA_PROJ_ELEMENTS ppe, PA_PROJ_ELEMENT_VERSIONS ppev
120: WHERE ppe.project_id = c_project_id
121: AND ppe.project_id = ppev.project_id -- 3693934 added for peformance fix
122: AND ppe.object_type = 'PA_TASKS'
123: AND ppe.proj_element_id = ppev.proj_element_id
124: AND ppev.parent_structure_version_id = c_structure_version_id
125: AND ppev.financial_task_flag = 'Y'
126: ORDER BY ppev.display_sequence;

Line 137: AND ppev.object_type = 'PA_TASKS'

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

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

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

Line 142: CURSOR pa_tasks_dates_csr (c_task_id NUMBER)

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

Line 145: FROM pa_tasks

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

Line 156: AND por.object_type_from = 'PA_TASKS'

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

Line 177: AND ppe.object_type = 'PA_TASKS'

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

Line 187: select task_id from pa_tasks

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

Line 268: update pa_tasks

264:
265:
266: --rbruno bug 12668006 start - task reference and pm_source_reference need to be in synch
267: IF (l_proj_elements_rec.pm_source_reference is NOT NULL) AND (p_task_reference IS NULL) THEN
268: update pa_tasks
269: set pm_task_reference = l_proj_elements_rec.pm_source_reference
270: where task_id = l_proj_elements_rec.proj_element_id;
271: END IF;
272: --rbruno 12668006 end

Line 289: update pa_tasks

285: FETCH get_pa_task into l_exist_pa_task_id;
286:
287: IF (get_pa_task%FOUND) THEN
288:
289: update pa_tasks
290: set pm_task_reference = l_pm_source_reference -- Bug 3302732 l_source_ref_count
291: where task_id = l_exist_pa_task_id;
292:
293: update pa_proj_elements

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

305: end if;
306:
307: l_stage := '3.2';
308:
309: -- fetch the task id from PA_TASKS based on the source reference
310:
311: PA_XC_PROJECT_PUB.fetch_task_id
312: ( p_task_index => l_pm_source_reference -- Bug 3302732 to_number(l_pm_source_reference)
313: ,p_project_id => p_project_id

Line 340: OPEN pa_tasks_dates_csr (l_proj_elements_rec.proj_element_id);

336: end if;
337:
338: l_stage := '3.5';
339:
340: OPEN pa_tasks_dates_csr (l_proj_elements_rec.proj_element_id);
341: FETCH pa_tasks_dates_csr INTO l_task_start_date, l_task_finish_date, l_long_task_name; -- Modified for bug 5465108
342: --bug 2858227 see update *** AAKASH 03/19/03 10:09 pm *** senario 3
343: IF pa_tasks_dates_csr%NOTFOUND
344: THEN

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

337:
338: l_stage := '3.5';
339:
340: OPEN pa_tasks_dates_csr (l_proj_elements_rec.proj_element_id);
341: FETCH pa_tasks_dates_csr INTO l_task_start_date, l_task_finish_date, l_long_task_name; -- Modified for bug 5465108
342: --bug 2858227 see update *** AAKASH 03/19/03 10:09 pm *** senario 3
343: IF pa_tasks_dates_csr%NOTFOUND
344: THEN
345: --Commented and replpaced following for BUG 4278979, rtarway

Line 343: IF pa_tasks_dates_csr%NOTFOUND

339:
340: OPEN pa_tasks_dates_csr (l_proj_elements_rec.proj_element_id);
341: FETCH pa_tasks_dates_csr INTO l_task_start_date, l_task_finish_date, l_long_task_name; -- Modified for bug 5465108
342: --bug 2858227 see update *** AAKASH 03/19/03 10:09 pm *** senario 3
343: IF pa_tasks_dates_csr%NOTFOUND
344: THEN
345: --Commented and replpaced following for BUG 4278979, rtarway
346: --l_task_start_date := null;
347: --l_task_finish_date := null;

Line 356: CLOSE pa_tasks_dates_csr;

352:
353:
354: END IF;
355: --bug 2858227
356: CLOSE pa_tasks_dates_csr;
357:
358: --end if;
359:
360: l_stage := '3.6';

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

361:
362: -- populate the temp table
363: -- note that we are populating with the proj_element_id from PA_PROJ_ELEMENTS,
364: -- not the task_id from fetch_task_id
365: -- this is because fetch_task_id will only return those task ids in PA_TASKS, but
366: -- we need the proj_element_id to sync up with the task ids created by AMG later
367:
368: INSERT INTO PA_TEMP_IMPORT_TASKS
369: ( PROJECT_ID

Line 519: FROM pa_tasks

515: -- needed to get the field values associated to a particular Task_Id
516: CURSOR l_get_task_csr (p_project_id NUMBER)
517: IS
518: SELECT task_id
519: FROM pa_tasks
520: WHERE project_id = p_project_id;
521:
522: -- needed to get the field values associated to a particular Project_id
523: CURSOR l_get_project_csr (p_project_id NUMBER)

Line 535: FROM pa_tasks

531: -- needed to get the the set of tasks to be deleted
532: CURSOR l_get_temp_task_csr(l_project_id NUMBER)
533: IS
534: SELECT PM_TASK_REFERENCE, task_id
535: FROM pa_tasks
536: WHERE project_id = l_project_id
537: MINUS
538: SELECT TASK_REFERENCE, task_id
539: FROM pa_temp_import_tasks

Line 547: FROM pa_tasks ttask

543:
544: CURSOR l_get_temp_task_csr(l_project_id NUMBER)
545: IS
546: SELECT PM_TASK_REFERENCE, task_id
547: FROM pa_tasks ttask
548: WHERE project_id = l_project_id
549: AND task_id not in
550: (
551: SELECT task_id

Line 984: -- Sync pa_proj_elements with pa_tasks

980: */
981:
982: if p_calling_mode = 'PUBLISH' then
983:
984: -- Sync pa_proj_elements with pa_tasks
985:
986: -- get the values associated to the project_id
987:
988: OPEN l_get_project_csr(p_project_id);

Line 1117: update PA_TASKS pt

1113: RAISE FND_API.G_EXC_ERROR;
1114: END IF; -- IF l_return_status
1115:
1116: --hsiu added for publishing bug
1117: update PA_TASKS pt
1118: set pt.parent_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.parent_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 -- Bug 3302732: added this
1123: -- Bug 3302732 and to_number(a.task_reference) = to_number(b.pm_task_reference) : Commented this line
1124: and b.task_id = pt.parent_task_id)

Line 1128: update PA_TASKS pt

1124: and b.task_id = pt.parent_task_id)
1125: where pt.project_id = p_project_id;
1126:
1127: --hsiu added for publishing bug
1128: update PA_TASKS pt
1129: set pt.top_task_id =
1130: (select a.task_id
1131: from pa_tasks b, pa_temp_import_tasks a
1132: where a.project_id = p_project_id

Line 1131: from pa_tasks b, pa_temp_import_tasks a

1127: --hsiu added for publishing bug
1128: update PA_TASKS pt
1129: set pt.top_task_id =
1130: (select a.task_id
1131: from pa_tasks b, pa_temp_import_tasks a
1132: where a.project_id = p_project_id
1133: and a.task_reference = b.pm_task_reference
1134: and b.task_id = pt.top_task_id)
1135: where pt.project_id = p_project_id;

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

1133: and a.task_reference = b.pm_task_reference
1134: and b.task_id = pt.top_task_id)
1135: where pt.project_id = p_project_id;
1136:
1137: -- Need to update pa_tasks so that the newly created financial task have the same task_id
1138: -- as the tasks in pa_proj_elements
1139: UPDATE PA_TASKS pt
1140: SET pt.task_id =
1141: (select task_id

Line 1139: UPDATE PA_TASKS pt

1135: where pt.project_id = p_project_id;
1136:
1137: -- Need to update pa_tasks so that the newly created financial task have the same task_id
1138: -- as the tasks in pa_proj_elements
1139: UPDATE PA_TASKS pt
1140: SET pt.task_id =
1141: (select task_id
1142: from PA_TEMP_IMPORT_TASKS temp
1143: where temp.project_id = p_project_id

Line 1150: from PA_TASKS t

1146:
1147: UPDATE PA_PROJ_ELEMENTS e
1148: set e.pm_source_reference = (
1149: select PM_TASK_REFERENCE
1150: from PA_TASKS t
1151: where t.task_id = e.proj_element_id
1152: ) where e.project_id = p_project_id;
1153:
1154: end if; -- if p_calling_mode = 'PUBLISH' OR l_sync_import = true then

Line 1321: FROM pa_tasks

1317:
1318: CURSOR l_get_task_csr (c_project_id NUMBER, c_pm_task_reference VARCHAR2)
1319: IS
1320: SELECT task_id
1321: FROM pa_tasks
1322: WHERE project_id = c_project_id
1323: AND pm_task_reference = c_pm_task_reference;
1324:
1325: BEGIN

Line 1488: AND OBJECT_TYPE = 'PA_TASKS'; */

1484: AND ppe.project_id = p_project_id
1485: AND ppst.structure_type_id = pst.structure_type_id
1486: AND pst.structure_type = 'WORKPLAN' --specified as workplan as this will only called while publishing workplan strcuture
1487: )
1488: AND OBJECT_TYPE = 'PA_TASKS'; */
1489: -- and rownum = 1; --Commented for Bug 3601700
1490:
1491: ---------------------------------------------------------------
1492: -- The above query is commented out as it can throw

Line 1512: AND OBJECT_TYPE = 'PA_TASKS' ;

1508: AND PPE.PROJECT_ID = P_PROJECT_ID
1509: AND PPST.STRUCTURE_TYPE_ID = PST.STRUCTURE_TYPE_ID
1510: AND PST.STRUCTURE_TYPE = 'WORKPLAN'
1511: )
1512: AND OBJECT_TYPE = 'PA_TASKS' ;
1513:
1514: IF ( L_COUNT > 0 ) THEN
1515: l_unique := 'N' ;
1516: END IF;