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_PROGRESS_PVT dependencies on PA_PROJ_ELEMENTS_TMP

Line 15279: FROM PA_PROJ_ELEMENTS_TMP r

15275: */
15276: cursor c_progress_parent(c_project_id number)
15277: IS
15278: SELECT /*+ CONNECT_BY_FILTERING */ element_version_id object_id_from1
15279: FROM PA_PROJ_ELEMENTS_TMP r
15280: START WITH r.TASK_ID in ( select distinct parent_task_id from PA_PROJ_ELEMENTS_TMP t1 where t1.defer_code = 'P' ) CONNECT BY
15281: r.TASK_ID = prior r.PARENT_TASK_ID;
15282:
15283: type NumberArray

Line 15280: START WITH r.TASK_ID in ( select distinct parent_task_id from PA_PROJ_ELEMENTS_TMP t1 where t1.defer_code = 'P' ) CONNECT BY

15276: cursor c_progress_parent(c_project_id number)
15277: IS
15278: SELECT /*+ CONNECT_BY_FILTERING */ element_version_id object_id_from1
15279: FROM PA_PROJ_ELEMENTS_TMP r
15280: START WITH r.TASK_ID in ( select distinct parent_task_id from PA_PROJ_ELEMENTS_TMP t1 where t1.defer_code = 'P' ) CONNECT BY
15281: r.TASK_ID = prior r.PARENT_TASK_ID;
15282:
15283: type NumberArray
15284: IS

Line 15447: FROM PA_PROJ_ELEMENTS_TMP r

15443: SELECT l_process_number_temp, p_structure_version_id object_id_from1, 'PA_TASKS', 1
15444: FROM dual;*/
15445: /*INSERT INTO pa_proj_rollup_temp(process_number, object_id, object_type, wbs_level)
15446: SELECT l_process_number_temp, element_version_id object_id_from1, 'PA_TASKS', 1
15447: FROM PA_PROJ_ELEMENTS_TMP r
15448: START WITH r.TASK_ID in ( select distinct parent_task_id from PA_PROJ_ELEMENTS_TMP t1 where t1.defer_code = 'P' ) CONNECT BY
15449: r.TASK_ID = prior r.PARENT_TASK_ID
15450: UNION
15451: SELECT l_process_number_temp, p_structure_version_id object_id_from1, 'PA_TASKS', 1

Line 15448: START WITH r.TASK_ID in ( select distinct parent_task_id from PA_PROJ_ELEMENTS_TMP t1 where t1.defer_code = 'P' ) CONNECT BY

15444: FROM dual;*/
15445: /*INSERT INTO pa_proj_rollup_temp(process_number, object_id, object_type, wbs_level)
15446: SELECT l_process_number_temp, element_version_id object_id_from1, 'PA_TASKS', 1
15447: FROM PA_PROJ_ELEMENTS_TMP r
15448: START WITH r.TASK_ID in ( select distinct parent_task_id from PA_PROJ_ELEMENTS_TMP t1 where t1.defer_code = 'P' ) CONNECT BY
15449: r.TASK_ID = prior r.PARENT_TASK_ID
15450: UNION
15451: SELECT l_process_number_temp, p_structure_version_id object_id_from1, 'PA_TASKS', 1
15452: FROM dual

Line 15455: FROM PA_PROJ_ELEMENTS_TMP r where connect_by_isleaf = 0

15451: SELECT l_process_number_temp, p_structure_version_id object_id_from1, 'PA_TASKS', 1
15452: FROM dual
15453: UNION
15454: SELECT l_process_number_temp, element_version_id object_id_from1, 'PA_TASKS', 1
15455: FROM PA_PROJ_ELEMENTS_TMP r where connect_by_isleaf = 0
15456: START WITH r.TASK_ID in ( select distinct task_id from PA_PROJ_ELEMENTS_TMP t1 where t1.defer_code = 'S' ) CONNECT BY
15457: prior r.TASK_ID = r.PARENT_TASK_ID
15458: UNION
15459: SELECT l_process_number_temp, element_version_id object_id_from1, 'PA_TASKS', 1

Line 15456: START WITH r.TASK_ID in ( select distinct task_id from PA_PROJ_ELEMENTS_TMP t1 where t1.defer_code = 'S' ) CONNECT BY

15452: FROM dual
15453: UNION
15454: SELECT l_process_number_temp, element_version_id object_id_from1, 'PA_TASKS', 1
15455: FROM PA_PROJ_ELEMENTS_TMP r where connect_by_isleaf = 0
15456: START WITH r.TASK_ID in ( select distinct task_id from PA_PROJ_ELEMENTS_TMP t1 where t1.defer_code = 'S' ) CONNECT BY
15457: prior r.TASK_ID = r.PARENT_TASK_ID
15458: UNION
15459: SELECT l_process_number_temp, element_version_id object_id_from1, 'PA_TASKS', 1
15460: FROM PA_PROJ_ELEMENTS_TMP r where r.defer_code = 'S' ;*/

Line 15460: FROM PA_PROJ_ELEMENTS_TMP r where r.defer_code = 'S' ;*/

15456: START WITH r.TASK_ID in ( select distinct task_id from PA_PROJ_ELEMENTS_TMP t1 where t1.defer_code = 'S' ) CONNECT BY
15457: prior r.TASK_ID = r.PARENT_TASK_ID
15458: UNION
15459: SELECT l_process_number_temp, element_version_id object_id_from1, 'PA_TASKS', 1
15460: FROM PA_PROJ_ELEMENTS_TMP r where r.defer_code = 'S' ;*/
15461: INSERT INTO pa_proj_rollup_temp(process_number, object_id, object_type, wbs_level)
15462: SELECT /*+ CONNECT_BY_FILTERING */ l_process_number_temp, element_version_id object_id_from1, 'PA_TASKS', 1
15463: FROM PA_PROJ_ELEMENTS_TMP r
15464: START WITH r.TASK_ID in ( select distinct parent_task_id from PA_PROJ_ELEMENTS_TMP t1 where t1.defer_code in ( 'P','C') ) CONNECT BY

Line 15463: FROM PA_PROJ_ELEMENTS_TMP r

15459: SELECT l_process_number_temp, element_version_id object_id_from1, 'PA_TASKS', 1
15460: FROM PA_PROJ_ELEMENTS_TMP r where r.defer_code = 'S' ;*/
15461: INSERT INTO pa_proj_rollup_temp(process_number, object_id, object_type, wbs_level)
15462: SELECT /*+ CONNECT_BY_FILTERING */ l_process_number_temp, element_version_id object_id_from1, 'PA_TASKS', 1
15463: FROM PA_PROJ_ELEMENTS_TMP r
15464: START WITH r.TASK_ID in ( select distinct parent_task_id from PA_PROJ_ELEMENTS_TMP t1 where t1.defer_code in ( 'P','C') ) CONNECT BY
15465: r.TASK_ID = prior r.PARENT_TASK_ID
15466: UNION
15467: SELECT l_process_number_temp, p_structure_version_id object_id_from1, 'PA_TASKS', 1

Line 15464: START WITH r.TASK_ID in ( select distinct parent_task_id from PA_PROJ_ELEMENTS_TMP t1 where t1.defer_code in ( 'P','C') ) CONNECT BY

15460: FROM PA_PROJ_ELEMENTS_TMP r where r.defer_code = 'S' ;*/
15461: INSERT INTO pa_proj_rollup_temp(process_number, object_id, object_type, wbs_level)
15462: SELECT /*+ CONNECT_BY_FILTERING */ l_process_number_temp, element_version_id object_id_from1, 'PA_TASKS', 1
15463: FROM PA_PROJ_ELEMENTS_TMP r
15464: START WITH r.TASK_ID in ( select distinct parent_task_id from PA_PROJ_ELEMENTS_TMP t1 where t1.defer_code in ( 'P','C') ) CONNECT BY
15465: r.TASK_ID = prior r.PARENT_TASK_ID
15466: UNION
15467: SELECT l_process_number_temp, p_structure_version_id object_id_from1, 'PA_TASKS', 1
15468: FROM dual

Line 15471: FROM PA_PROJ_ELEMENTS_TMP r where connect_by_isleaf = 0

15467: SELECT l_process_number_temp, p_structure_version_id object_id_from1, 'PA_TASKS', 1
15468: FROM dual
15469: UNION
15470: SELECT /*+ CONNECT_BY_FILTERING */ l_process_number_temp, element_version_id object_id_from1, 'PA_TASKS', 1
15471: FROM PA_PROJ_ELEMENTS_TMP r where connect_by_isleaf = 0
15472: START WITH r.TASK_ID in ( select distinct task_id from PA_PROJ_ELEMENTS_TMP t1 where t1.defer_code in ('D', 'S' )) CONNECT BY
15473: r.TASK_ID = Prior r.PARENT_TASK_ID
15474: UNION
15475: SELECT l_process_number_temp, element_version_id object_id_from1, 'PA_TASKS', 1

Line 15472: START WITH r.TASK_ID in ( select distinct task_id from PA_PROJ_ELEMENTS_TMP t1 where t1.defer_code in ('D', 'S' )) CONNECT BY

15468: FROM dual
15469: UNION
15470: SELECT /*+ CONNECT_BY_FILTERING */ l_process_number_temp, element_version_id object_id_from1, 'PA_TASKS', 1
15471: FROM PA_PROJ_ELEMENTS_TMP r where connect_by_isleaf = 0
15472: START WITH r.TASK_ID in ( select distinct task_id from PA_PROJ_ELEMENTS_TMP t1 where t1.defer_code in ('D', 'S' )) CONNECT BY
15473: r.TASK_ID = Prior r.PARENT_TASK_ID
15474: UNION
15475: SELECT l_process_number_temp, element_version_id object_id_from1, 'PA_TASKS', 1
15476: FROM PA_PROJ_ELEMENTS_TMP r where r.defer_code in ('D','S')

Line 15476: FROM PA_PROJ_ELEMENTS_TMP r where r.defer_code in ('D','S')

15472: START WITH r.TASK_ID in ( select distinct task_id from PA_PROJ_ELEMENTS_TMP t1 where t1.defer_code in ('D', 'S' )) CONNECT BY
15473: r.TASK_ID = Prior r.PARENT_TASK_ID
15474: UNION
15475: SELECT l_process_number_temp, element_version_id object_id_from1, 'PA_TASKS', 1
15476: FROM PA_PROJ_ELEMENTS_TMP r where r.defer_code in ('D','S')
15477: UNION
15478: SELECT l_process_number_temp, element_version_id object_id_from1, 'PA_TASKS', 1
15479: FROM PA_PROJ_ELEMENTS_TMP r where r.task_id in ( select distinct tt.top_task_id from PA_PROJ_ELEMENTS_TMP tt where tt.defer_code in ('D','S','C','P') ) ;
15480:

Line 15479: FROM PA_PROJ_ELEMENTS_TMP r where r.task_id in ( select distinct tt.top_task_id from PA_PROJ_ELEMENTS_TMP tt where tt.defer_code in ('D','S','C','P') ) ;

15475: SELECT l_process_number_temp, element_version_id object_id_from1, 'PA_TASKS', 1
15476: FROM PA_PROJ_ELEMENTS_TMP r where r.defer_code in ('D','S')
15477: UNION
15478: SELECT l_process_number_temp, element_version_id object_id_from1, 'PA_TASKS', 1
15479: FROM PA_PROJ_ELEMENTS_TMP r where r.task_id in ( select distinct tt.top_task_id from PA_PROJ_ELEMENTS_TMP tt where tt.defer_code in ('D','S','C','P') ) ;
15480:
15481:
15482: l_tmp_prog.delete;
15483: OPEN c_progress_parent(p_project_id);