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.

[Home] [Help]

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 6061: l_struct_elem_version_id pa_proj_element_versions.element_version_id%TYPE;

6057: l_fp_option_level_code pa_proj_fp_options.fin_plan_option_level_code%TYPE;
6058: l_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
6059: l_appr_cost_plan_type_flag pa_proj_fp_options.approved_cost_plan_type_flag%TYPE;
6060: l_appr_rev_plan_type_flag pa_proj_fp_options.approved_rev_plan_type_flag%TYPE;
6061: l_struct_elem_version_id pa_proj_element_versions.element_version_id%TYPE;
6062: l_budget_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
6063: l_src_budget_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
6064:
6065:

Line 8738: p_source_project_id IN pa_proj_element_versions.project_id%TYPE

8734: ============================================================================================================*/
8735:
8736: PROCEDURE copy_wp_budget_versions
8737: (
8738: p_source_project_id IN pa_proj_element_versions.project_id%TYPE
8739: ,p_target_project_id IN pa_proj_element_versions.element_version_id%TYPE
8740: ,p_src_sv_ids_tbl IN SYSTEM.pa_num_tbl_type
8741: ,p_target_sv_ids_tbl IN SYSTEM.pa_num_tbl_type
8742: ,p_copy_act_from_str_ids_tbl IN SYSTEM.pa_num_tbl_type -- bug 3847386

Line 8739: ,p_target_project_id IN pa_proj_element_versions.element_version_id%TYPE

8735:
8736: PROCEDURE copy_wp_budget_versions
8737: (
8738: p_source_project_id IN pa_proj_element_versions.project_id%TYPE
8739: ,p_target_project_id IN pa_proj_element_versions.element_version_id%TYPE
8740: ,p_src_sv_ids_tbl IN SYSTEM.pa_num_tbl_type
8741: ,p_target_sv_ids_tbl IN SYSTEM.pa_num_tbl_type
8742: ,p_copy_act_from_str_ids_tbl IN SYSTEM.pa_num_tbl_type -- bug 3847386
8743: ,p_copy_people_flag IN VARCHAR2

Line 8801: ,c_src_struct_ver_id pa_proj_element_versions.element_version_id%TYPE

8797:
8798: --Cursor for getting the source and target element version ids. This will be used in calling the
8799: --Copy Planning Txn API
8800: CURSOR l_prep_plan_txn_csr(c_source_plan_version_id pa_budget_versions.budget_version_id%TYPE
8801: ,c_src_struct_ver_id pa_proj_element_versions.element_version_id%TYPE
8802: ,c_targ_struct_ver_id pa_proj_element_versions.element_version_id%TYPE)
8803: IS
8804: SELECT selv.element_version_id
8805: ,telv.element_version_id

Line 8802: ,c_targ_struct_ver_id pa_proj_element_versions.element_version_id%TYPE)

8798: --Cursor for getting the source and target element version ids. This will be used in calling the
8799: --Copy Planning Txn API
8800: CURSOR l_prep_plan_txn_csr(c_source_plan_version_id pa_budget_versions.budget_version_id%TYPE
8801: ,c_src_struct_ver_id pa_proj_element_versions.element_version_id%TYPE
8802: ,c_targ_struct_ver_id pa_proj_element_versions.element_version_id%TYPE)
8803: IS
8804: SELECT selv.element_version_id
8805: ,telv.element_version_id
8806: FROM pa_proj_element_versions telv

Line 8806: FROM pa_proj_element_versions telv

8802: ,c_targ_struct_ver_id pa_proj_element_versions.element_version_id%TYPE)
8803: IS
8804: SELECT selv.element_version_id
8805: ,telv.element_version_id
8806: FROM pa_proj_element_versions telv
8807: ,pa_proj_element_versions selv
8808: ,pa_proj_elements spe
8809: ,pa_proj_elements tpe
8810: WHERE spe.project_id=p_source_project_id

Line 8807: ,pa_proj_element_versions selv

8803: IS
8804: SELECT selv.element_version_id
8805: ,telv.element_version_id
8806: FROM pa_proj_element_versions telv
8807: ,pa_proj_element_versions selv
8808: ,pa_proj_elements spe
8809: ,pa_proj_elements tpe
8810: WHERE spe.project_id=p_source_project_id
8811: AND tpe.project_id=p_target_project_id