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_FP_COPY_FROM_PKG dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 1937: l_src_elem_ver_id pa_proj_element_versions.element_version_id%TYPE;

1933: l_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1934: --End of variables used for debugging
1935: --Bug 4201936
1936: l_temp VARCHAR2(15);
1937: l_src_elem_ver_id pa_proj_element_versions.element_version_id%TYPE;
1938: l_targ_elem_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1939: TYPE src_elem_targ_elem_map_tbl_typ IS TABLE OF NUMBER INDEX BY VARCHAR2(15);
1940: l_src_elem_targ_elem_map_tbl src_elem_targ_elem_map_tbl_typ;
1941:

Line 2149: ,pa_proj_element_versions pelm

2145: ,l_schedule_start_date_tbl(i)
2146: ,l_schedule_end_date_tbl(i)
2147: ,p_targ_rlm_id_tbl(i) -- Bug 3615617
2148: FROM pa_resource_assignments pra
2149: ,pa_proj_element_versions pelm
2150: WHERE pra.resource_assignment_id = p_src_ra_id_tbl(i)
2151: AND pelm.element_version_id=l_targ_elem_ver_id_tbl(i);
2152: END IF; -- p_context
2153:

Line 6048: l_struct_elem_version_id pa_proj_element_versions.element_version_id%TYPE;

6044: l_fp_option_level_code pa_proj_fp_options.fin_plan_option_level_code%TYPE;
6045: l_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
6046: l_appr_cost_plan_type_flag pa_proj_fp_options.approved_cost_plan_type_flag%TYPE;
6047: l_appr_rev_plan_type_flag pa_proj_fp_options.approved_rev_plan_type_flag%TYPE;
6048: l_struct_elem_version_id pa_proj_element_versions.element_version_id%TYPE;
6049: l_budget_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
6050: l_src_budget_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
6051:
6052:

Line 8711: p_source_project_id IN pa_proj_element_versions.project_id%TYPE

8707: ============================================================================================================*/
8708:
8709: PROCEDURE copy_wp_budget_versions
8710: (
8711: p_source_project_id IN pa_proj_element_versions.project_id%TYPE
8712: ,p_target_project_id IN pa_proj_element_versions.element_version_id%TYPE
8713: ,p_src_sv_ids_tbl IN SYSTEM.pa_num_tbl_type
8714: ,p_target_sv_ids_tbl IN SYSTEM.pa_num_tbl_type
8715: ,p_copy_act_from_str_ids_tbl IN SYSTEM.pa_num_tbl_type -- bug 3847386

Line 8712: ,p_target_project_id IN pa_proj_element_versions.element_version_id%TYPE

8708:
8709: PROCEDURE copy_wp_budget_versions
8710: (
8711: p_source_project_id IN pa_proj_element_versions.project_id%TYPE
8712: ,p_target_project_id IN pa_proj_element_versions.element_version_id%TYPE
8713: ,p_src_sv_ids_tbl IN SYSTEM.pa_num_tbl_type
8714: ,p_target_sv_ids_tbl IN SYSTEM.pa_num_tbl_type
8715: ,p_copy_act_from_str_ids_tbl IN SYSTEM.pa_num_tbl_type -- bug 3847386
8716: ,p_copy_people_flag IN VARCHAR2

Line 8774: ,c_src_struct_ver_id pa_proj_element_versions.element_version_id%TYPE

8770:
8771: --Cursor for getting the source and target element version ids. This will be used in calling the
8772: --Copy Planning Txn API
8773: CURSOR l_prep_plan_txn_csr(c_source_plan_version_id pa_budget_versions.budget_version_id%TYPE
8774: ,c_src_struct_ver_id pa_proj_element_versions.element_version_id%TYPE
8775: ,c_targ_struct_ver_id pa_proj_element_versions.element_version_id%TYPE)
8776: IS
8777: SELECT selv.element_version_id
8778: ,telv.element_version_id

Line 8775: ,c_targ_struct_ver_id pa_proj_element_versions.element_version_id%TYPE)

8771: --Cursor for getting the source and target element version ids. This will be used in calling the
8772: --Copy Planning Txn API
8773: CURSOR l_prep_plan_txn_csr(c_source_plan_version_id pa_budget_versions.budget_version_id%TYPE
8774: ,c_src_struct_ver_id pa_proj_element_versions.element_version_id%TYPE
8775: ,c_targ_struct_ver_id pa_proj_element_versions.element_version_id%TYPE)
8776: IS
8777: SELECT selv.element_version_id
8778: ,telv.element_version_id
8779: FROM pa_proj_element_versions telv

Line 8779: FROM pa_proj_element_versions telv

8775: ,c_targ_struct_ver_id pa_proj_element_versions.element_version_id%TYPE)
8776: IS
8777: SELECT selv.element_version_id
8778: ,telv.element_version_id
8779: FROM pa_proj_element_versions telv
8780: ,pa_proj_element_versions selv
8781: ,pa_proj_elements spe
8782: ,pa_proj_elements tpe
8783: WHERE spe.project_id=p_source_project_id

Line 8780: ,pa_proj_element_versions selv

8776: IS
8777: SELECT selv.element_version_id
8778: ,telv.element_version_id
8779: FROM pa_proj_element_versions telv
8780: ,pa_proj_element_versions selv
8781: ,pa_proj_elements spe
8782: ,pa_proj_elements tpe
8783: WHERE spe.project_id=p_source_project_id
8784: AND tpe.project_id=p_target_project_id