APPS.PA_XC_PROJECT_PUB dependencies on PA_TEMP_IMPORT_TASKS

Line 110: FROM PA_TEMP_IMPORT_TASKS

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

Line 224: delete from PA_TEMP_IMPORT_TASKS where project_id = p_project_id;

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

Line 357: INSERT INTO PA_TEMP_IMPORT_TASKS

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
359: ,TASK_REFERENCE
360: ,TASK_ID)
361: VALUES

Line 528: FROM pa_temp_import_tasks

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
529: WHERE project_id = l_project_id
530: ORDER BY 1;
531: */
532:

Line 541: FROM pa_temp_import_tasks

537: WHERE project_id = l_project_id
538: AND task_id not in
539: (
540: SELECT task_id
541: FROM pa_temp_import_tasks
542: WHERE project_id = l_project_id
543: AND task_id = ttask.task_id
544: )
545: ORDER BY ttask.wbs_level desc;

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

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
1133: and temp.task_reference = pt.pm_task_reference)
1134: WHERE pt.project_id = p_project_id;
1135: