[Home] [Help]
739: l_planning_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
740: l_planning_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
741:
742: l_etc_start_date PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE;
743: l_time_phase PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE;
744: l_start_date PA_BUDGET_LINES.START_DATE%TYPE;
745: l_end_date PA_BUDGET_LINES.END_DATE%TYPE;
746: l_period_name PA_BUDGET_LINES.PERIOD_NAME%TYPE;
747: l_pc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
1589: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
1590:
1591: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
1592: l_org_id pa_projects_all.org_id%TYPE;
1593: l_target_ver_period_type pa_proj_fp_options.cost_time_phased_code%TYPE;
1594: l_target_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
1595: l_target_period_name pa_budget_lines.period_name%TYPE;
1596: l_target_start_date pa_budget_lines.start_date%TYPE;
1597: l_target_end_date pa_budget_lines.end_date%TYPE;
1594: l_target_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
1595: l_target_period_name pa_budget_lines.period_name%TYPE;
1596: l_target_start_date pa_budget_lines.start_date%TYPE;
1597: l_target_end_date pa_budget_lines.end_date%TYPE;
1598: l_source_ver_period_type pa_proj_fp_options.cost_time_phased_code%TYPE;
1599: l_source_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
1600: l_source_period_name pa_budget_lines.period_name%TYPE;
1601: l_source_start_date pa_budget_lines.start_date%TYPE;
1602: l_source_end_date pa_budget_lines.end_date%TYPE;
1673: l_source_set_of_books_id,
1674: l_source_bv_id
1675: from pa_resource_assignments ra,
1676: pa_projects_all p,
1677: pa_proj_fp_options po,
1678: pa_implementations_all pia
1679: where ra.resource_assignment_id = p_src_res_asg_id_tab(1) and
1680: ra.project_id = p.project_id and
1681: ra.budget_version_id = po.fin_plan_version_id and
2016:
2017: l_src_version_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2018: l_gen_etc_src_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2019: l_src_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
2020: l_gen_etc_src_code PA_PROJ_FP_OPTIONS.GEN_COST_ETC_SRC_CODE%TYPE;
2021: l_fp_cols_rec_src PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
2022:
2023: l_tgt_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2024: