APPS.PA_PROJECT_PUB dependencies on PA_TASKS_TMP

Line 40621: insert into pa_tasks_tmp (task_id)

40617: */
40618: select proj_element_id INTO l_ref_parent_task_id from pa_proj_element_versions
40619: where element_version_id = l_ref_parent_ver_id and project_id= p_project_id;
40620:
40621: insert into pa_tasks_tmp (task_id)
40622: SELECT task_id
40623: FROM pa_tasks
40624: WHERE project_id = p_project_id
40625: START WITH parent_task_id = l_ref_parent_task_id

Line 40628: insert into pa_tasks_tmp (task_id)

40624: WHERE project_id = p_project_id
40625: START WITH parent_task_id = l_ref_parent_task_id
40626: CONNECT BY parent_task_id = prior task_id;
40627:
40628: insert into pa_tasks_tmp (task_id)
40629: select proj_element_id
40630: from pa_proj_element_versions
40631: where ELEMENT_VERSION_ID = p_task_version_id and project_id = p_project_id and not exists (select null from pa_tasks_tmp where task_id = proj_element_id);
40632:

Line 40631: where ELEMENT_VERSION_ID = p_task_version_id and project_id = p_project_id and not exists (select null from pa_tasks_tmp where task_id = proj_element_id);

40627:
40628: insert into pa_tasks_tmp (task_id)
40629: select proj_element_id
40630: from pa_proj_element_versions
40631: where ELEMENT_VERSION_ID = p_task_version_id and project_id = p_project_id and not exists (select null from pa_tasks_tmp where task_id = proj_element_id);
40632:
40633: SELECT /*+ ordered index(ev1 pa_proj_element_versions_n1) */
40634: element_version_id, proj_element_id, object_type,
40635: project_id, parent_structure_version_id,

Line 40644: FROM pa_tasks_tmp t1 ,

40640: l_project_id_tab, l_parent_str_version_id_tab,
40641: l_display_sequence_tab, l_wbs_level_tab,
40642: l_wbs_number_tab, l_record_version_tab,
40643: l_changed_flag_tab
40644: FROM pa_tasks_tmp t1 ,
40645: pa_proj_element_versions ev1
40646: WHERE
40647: project_id = p_project_id
40648: AND parent_structure_version_id = p_structure_version_id

Line 42001: insert into pa_tasks_tmp (task_id)

41997: ORDER BY display_sequence ;
41998: */
41999: select proj_element_id INTO l_ref_parent_task_id from pa_proj_element_versions where element_version_id = l_ref_parent_ver_id and project_id= p_project_id;
42000:
42001: insert into pa_tasks_tmp (task_id)
42002: SELECT task_id
42003: FROM pa_tasks
42004: WHERE project_id = p_project_id
42005: START WITH parent_task_id = l_ref_parent_task_id

Line 42008: insert into pa_tasks_tmp (task_id)

42004: WHERE project_id = p_project_id
42005: START WITH parent_task_id = l_ref_parent_task_id
42006: CONNECT BY parent_task_id = prior task_id;
42007:
42008: insert into pa_tasks_tmp (task_id)
42009: select proj_element_id
42010: from pa_proj_element_versions
42011: where ELEMENT_VERSION_ID = p_task_version_id and project_id = p_project_id and not exists (select null from pa_tasks_tmp where task_id = proj_element_id);
42012:

Line 42011: where ELEMENT_VERSION_ID = p_task_version_id and project_id = p_project_id and not exists (select null from pa_tasks_tmp where task_id = proj_element_id);

42007:
42008: insert into pa_tasks_tmp (task_id)
42009: select proj_element_id
42010: from pa_proj_element_versions
42011: where ELEMENT_VERSION_ID = p_task_version_id and project_id = p_project_id and not exists (select null from pa_tasks_tmp where task_id = proj_element_id);
42012:
42013: SELECT /*+ ordered index(ev1 pa_proj_element_versions_n1) */
42014: element_version_id, proj_element_id, object_type,
42015: project_id, parent_structure_version_id,

Line 42024: FROM pa_tasks_tmp t1 ,

42020: l_project_id_tab, l_parent_str_version_id_tab,
42021: l_display_sequence_tab, l_wbs_level_tab,
42022: l_wbs_number_tab, l_record_version_tab,
42023: l_changed_flag_tab
42024: FROM pa_tasks_tmp t1 ,
42025: pa_proj_element_versions ev1
42026: WHERE
42027: project_id = p_project_id
42028: AND parent_structure_version_id = p_structure_version_id