APPS.PA_XC_PROJECT_PUB dependencies on PA_TEMP_IMPORT_TASKS

Line 112: FROM PA_TEMP_IMPORT_TASKS

108:
109: CURSOR l_get_temp_record (c_project_id NUMBER)
110: IS
111: SELECT PROJECT_ID
112: FROM PA_TEMP_IMPORT_TASKS
113: WHERE PROJECT_ID = c_project_id;
114:
115: -- Retrieve tasks from PA_PROJ_ELEMENTS table
116: CURSOR pa_proj_elements_csr(c_structure_version_id NUMBER, c_project_id NUMBER)

Line 226: delete from PA_TEMP_IMPORT_TASKS where project_id = p_project_id;

222: FETCH l_get_temp_record INTO l_count;
223:
224: IF l_get_temp_record%FOUND THEN
225: CLOSE l_get_temp_record;
226: delete from PA_TEMP_IMPORT_TASKS where project_id = p_project_id;
227: ELSE
228: CLOSE l_get_temp_record;
229: END IF;
230:

Line 368: INSERT INTO PA_TEMP_IMPORT_TASKS

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
370: ,TASK_REFERENCE
371: ,TASK_ID)
372: VALUES

Line 539: FROM pa_temp_import_tasks

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
540: WHERE project_id = l_project_id
541: ORDER BY 1;
542: */
543:

Line 552: FROM pa_temp_import_tasks

548: WHERE project_id = l_project_id
549: AND task_id not in
550: (
551: SELECT task_id
552: FROM pa_temp_import_tasks
553: WHERE project_id = l_project_id
554: AND task_id = ttask.task_id
555: )
556: ORDER BY ttask.wbs_level desc;

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 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 1142: from PA_TEMP_IMPORT_TASKS temp

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
1144: and temp.task_reference = pt.pm_task_reference)
1145: WHERE pt.project_id = p_project_id;
1146: