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_PROJ_TASK_STRUC_PUB dependencies on PA_PROJECT_COPY_OPTIONS_TMP

Line 7817: -- in the global temporary table PA_PROJECT_COPY_OPTIONS_TMP

7813: -- Type : PUBLIC
7814: -- Purpose : Contains logic for copying WP/FIN structures, versions and tasks alongwith
7815: -- intra and inter project dependencies, mapping, deliverables etc.
7816: -- All this is done only for the SELECTED or DEFAULTED versions that are present
7817: -- in the global temporary table PA_PROJECT_COPY_OPTIONS_TMP
7818: -- Note : **** THIS API HAS BEEN RE-WRITTEN FOR FPM ****
7819: -- Assumptions : All FLAGS and WORKPLAN record(s) have been populated in the global temporary table
7820: -- Parameters Type Required Description and Purpose
7821: -- --------------------------- ------ -------- --------------------------------------------------------

Line 7869: FROM PA_PROJECT_COPY_OPTIONS_TMP

7865: CURSOR cur_min_one_wp_version_sel IS
7866: SELECT 'Y'
7867: FROM dual
7868: WHERE EXISTS( SELECT 'Y'
7869: FROM PA_PROJECT_COPY_OPTIONS_TMP
7870: WHERE CONTEXT = 'WORKPLAN'
7871: AND VERSION_ID IS NOT NULL) ;
7872:
7873: --This cursor retrieves the values of various flags from the global temporary table

Line 7876: FROM PA_PROJECT_COPY_OPTIONS_TMP

7872:
7873: --This cursor retrieves the values of various flags from the global temporary table
7874: CURSOR cur_get_flag(c_flag_name IN VARCHAR2) IS
7875: SELECT FLAG
7876: FROM PA_PROJECT_COPY_OPTIONS_TMP
7877: WHERE CONTEXT = c_flag_name ;
7878:
7879: --This cursor is used to retrieve the destination project's WP/FIN structure id
7880: CURSOR cur_get_dest_structure_id( c_structure_type IN VARCHAR2 ) IS

Line 7906: pa_project_copy_options_tmp ppcot

7902: SELECT ppev.element_version_id
7903: ,ppev.attribute15
7904: ,ppcot.flag
7905: FROM pa_proj_element_versions ppev,
7906: pa_project_copy_options_tmp ppcot
7907: WHERE ppev.project_id = p_dest_project_id
7908: AND ppev.proj_element_id = c_dest_wp_struc_id
7909: AND ppev.attribute15 = ppcot.version_id
7910: AND ppcot.context = 'WORKPLAN' ;

Line 8786: pa_project_copy_options_tmp ppcot

8782: ,NULL --bug 4261419
8783: ,p_dest_project_id
8784: ,'PA_PROJECTS'
8785: FROM pa_proj_element_versions ppev,
8786: pa_project_copy_options_tmp ppcot
8787: WHERE ppcot.context = 'WORKPLAN'
8788: AND ppev.element_version_id = ppcot.version_id
8789: AND ppev.project_id = p_src_project_id
8790: AND ppev.object_type = 'PA_STRUCTURES' ;

Line 8807: FROM pa_project_copy_options_tmp ppcot

8803:
8804: --This cursor gets the WP version which is selected for Publish Upon Creation
8805: CURSOR get_puc_version_id IS
8806: SELECT version_id
8807: FROM pa_project_copy_options_tmp ppcot
8808: WHERE context = 'WORKPLAN'
8809: AND flag = 'Y';
8810:
8811: --Gets the current working version of the source project ONLY if it has been SELECTED for copying

Line 8815: pa_project_copy_options_tmp ppcot

8811: --Gets the current working version of the source project ONLY if it has been SELECTED for copying
8812: CURSOR get_current_working_selected IS
8813: SELECT ppevs.element_version_id
8814: FROM pa_proj_elem_ver_structure ppevs,
8815: pa_project_copy_options_tmp ppcot
8816: WHERE ppevs.current_working_flag = 'Y'
8817: AND ppevs.status_code = 'STRUCTURE_WORKING'
8818: AND ppevs.project_id = p_src_project_id
8819: AND ppevs.element_version_id = ppcot.version_id

Line 8828: pa_project_copy_options_tmp ppcot

8824: CURSOR get_latest_working_version IS
8825: SELECT element_version_id FROM
8826: ( SELECT ppevs.element_version_id
8827: FROM pa_proj_elem_ver_structure ppevs,
8828: pa_project_copy_options_tmp ppcot
8829: WHERE ppevs.element_version_id = ppcot.version_id
8830: AND ppevs.project_id = p_src_project_id
8831: AND ppevs.status_code = 'STRUCTURE_WORKING'
8832: AND ppcot.context = 'WORKPLAN'

Line 8842: pa_project_copy_options_tmp ppcot

8838: --NOT Publish Upon Creation
8839: CURSOR get_latest_published IS
8840: SELECT ppevs.element_version_id
8841: FROM pa_proj_elem_ver_structure ppevs,
8842: pa_project_copy_options_tmp ppcot
8843: WHERE ppevs.latest_eff_published_flag = 'Y'
8844: AND ppevs.status_code = 'STRUCTURE_PUBLISHED'
8845: AND ppevs.element_version_id = ppcot.version_id
8846: AND ppcot.context = 'WORKPLAN'

Line 8856: pa_project_copy_options_tmp ppcot

8852: CURSOR get_last_published IS
8853: SELECT element_version_id FROM
8854: ( SELECT ppevs.element_version_id
8855: FROM pa_proj_elem_ver_structure ppevs,
8856: pa_project_copy_options_tmp ppcot
8857: WHERE ppevs.element_version_id = ppcot.version_id
8858: AND ppevs.status_code = 'STRUCTURE_PUBLISHED'
8859: AND ppevs.project_id = p_src_project_id
8860: AND ppcot.context = 'WORKPLAN'

Line 9447: PA_PROJECT_COPY_OPTIONS_TMP ppcot

9443: AND pt.project_id (+) = p_dest_project_id
9444: AND ppe.proj_element_id IN
9445: ( SELECT distinct ppev.proj_element_id
9446: FROM PA_PROJ_ELEMENT_VERSIONS ppev,
9447: PA_PROJECT_COPY_OPTIONS_TMP ppcot
9448: WHERE ppcot.CONTEXT = 'WORKPLAN'
9449: AND ppev.parent_structure_version_id = ppcot.version_id
9450: AND ppev.project_id = p_src_project_id
9451: AND ppev.object_type = 'PA_TASKS' ) ;

Line 9596: PA_PROJECT_COPY_OPTIONS_TMP ppcot

9592: AND nvl(ppe.link_task_flag,'N') <> 'Y' -- 4348868
9593: AND ppe.proj_element_id IN
9594: ( SELECT distinct ppev.proj_element_id
9595: FROM PA_PROJ_ELEMENT_VERSIONS ppev,
9596: PA_PROJECT_COPY_OPTIONS_TMP ppcot
9597: WHERE ppcot.CONTEXT = 'WORKPLAN'
9598: AND ppev.parent_structure_version_id = ppcot.version_id
9599: AND ppev.project_id = p_src_project_id
9600: AND ppev.object_type = 'PA_TASKS' ) ;