5:
6:
7: PROCEDURE FP_CI_COPY_CONTROL_ITEMS
8: (
9: p_project_id IN pa_budget_versions.project_id%TYPE,
10: p_source_ci_id_tbl IN PA_PLSQL_DATATYPES.IdTabTyp,
11: p_target_ci_id IN pa_budget_versions.ci_id%TYPE,
12: p_merge_unmerge_mode IN VARCHAR2 ,
13: p_commit_flag IN VARCHAR2 ,
7: PROCEDURE FP_CI_COPY_CONTROL_ITEMS
8: (
9: p_project_id IN pa_budget_versions.project_id%TYPE,
10: p_source_ci_id_tbl IN PA_PLSQL_DATATYPES.IdTabTyp,
11: p_target_ci_id IN pa_budget_versions.ci_id%TYPE,
12: p_merge_unmerge_mode IN VARCHAR2 ,
13: p_commit_flag IN VARCHAR2 ,
14: p_init_msg_list IN VARCHAR2 ,
15: p_calling_context IN VARCHAR2,
19: x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
20: )
21: IS
22: --Defining amount variables
23: l_approved_cost_flag pa_budget_versions.approved_cost_plan_type_flag%TYPE;
24: l_approved_rev_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
25: l_ci_id pa_budget_versions.ci_id%TYPE;
26: l_second_bv_id pa_budget_versions.budget_version_id%TYPE;
27:
20: )
21: IS
22: --Defining amount variables
23: l_approved_cost_flag pa_budget_versions.approved_cost_plan_type_flag%TYPE;
24: l_approved_rev_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
25: l_ci_id pa_budget_versions.ci_id%TYPE;
26: l_second_bv_id pa_budget_versions.budget_version_id%TYPE;
27:
28: --Defining PL/SQL local variables
21: IS
22: --Defining amount variables
23: l_approved_cost_flag pa_budget_versions.approved_cost_plan_type_flag%TYPE;
24: l_approved_rev_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
25: l_ci_id pa_budget_versions.ci_id%TYPE;
26: l_second_bv_id pa_budget_versions.budget_version_id%TYPE;
27:
28: --Defining PL/SQL local variables
29: l_s_fp_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
22: --Defining amount variables
23: l_approved_cost_flag pa_budget_versions.approved_cost_plan_type_flag%TYPE;
24: l_approved_rev_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
25: l_ci_id pa_budget_versions.ci_id%TYPE;
26: l_second_bv_id pa_budget_versions.budget_version_id%TYPE;
27:
28: --Defining PL/SQL local variables
29: l_s_fp_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
30: l_t_fp_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
31:
32: l_s_fp_ci_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
33: l_t_fp_ci_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
34:
35: l_s_fp_ci_id pa_budget_versions.ci_id%TYPE;
36: l_t_fp_ci_id pa_budget_versions.ci_id%TYPE;
37:
38: l_source_version_id pa_budget_versions.budget_version_id%TYPE;
39: l_target_version_id pa_budget_versions.budget_version_id%TYPE;
32: l_s_fp_ci_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
33: l_t_fp_ci_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
34:
35: l_s_fp_ci_id pa_budget_versions.ci_id%TYPE;
36: l_t_fp_ci_id pa_budget_versions.ci_id%TYPE;
37:
38: l_source_version_id pa_budget_versions.budget_version_id%TYPE;
39: l_target_version_id pa_budget_versions.budget_version_id%TYPE;
40:
34:
35: l_s_fp_ci_id pa_budget_versions.ci_id%TYPE;
36: l_t_fp_ci_id pa_budget_versions.ci_id%TYPE;
37:
38: l_source_version_id pa_budget_versions.budget_version_id%TYPE;
39: l_target_version_id pa_budget_versions.budget_version_id%TYPE;
40:
41: l_s_fin_plan_pref_code pa_proj_fp_options. fin_plan_preference_code%TYPE;
42: l_s_multi_curr_flag pa_proj_fp_options. plan_in_multi_curr_flag%TYPE;
35: l_s_fp_ci_id pa_budget_versions.ci_id%TYPE;
36: l_t_fp_ci_id pa_budget_versions.ci_id%TYPE;
37:
38: l_source_version_id pa_budget_versions.budget_version_id%TYPE;
39: l_target_version_id pa_budget_versions.budget_version_id%TYPE;
40:
41: l_s_fin_plan_pref_code pa_proj_fp_options. fin_plan_preference_code%TYPE;
42: l_s_multi_curr_flag pa_proj_fp_options. plan_in_multi_curr_flag%TYPE;
43: l_s_time_phased_code pa_proj_fp_options. all_time_phased_code%TYPE;
44: l_s_resource_list_id pa_proj_fp_options.all_resource_list_id%TYPE;
45: l_s_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;
46: l_s_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag %TYPE;
47: l_s_group_res_type_id pa_resource_lists_all_bg.group_resource_type_id%TYPE;
48: l_s_version_type pa_budget_versions.version_type%TYPE;
49: l_s_ci_id pa_budget_versions.ci_id%TYPE;
50:
51: l_copy_version_flag VARCHAR2(1);
52: l_copy_possible_flag VARCHAR2(1);
45: l_s_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;
46: l_s_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag %TYPE;
47: l_s_group_res_type_id pa_resource_lists_all_bg.group_resource_type_id%TYPE;
48: l_s_version_type pa_budget_versions.version_type%TYPE;
49: l_s_ci_id pa_budget_versions.ci_id%TYPE;
50:
51: l_copy_version_flag VARCHAR2(1);
52: l_copy_possible_flag VARCHAR2(1);
53: l_debug_mode VARCHAR2(30);
323: ==============================================================================*/
324:
325: PROCEDURE populate_ci_fin_impact_records(
326: p_project_id IN pa_projects_all.project_id%TYPE
327: ,p_source_ci_id IN pa_budget_versions.ci_id%TYPE
328: ,p_target_ci_id IN pa_budget_versions.ci_id%TYPE
329: ,p_calling_context IN VARCHAR2
330: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
331: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
324:
325: PROCEDURE populate_ci_fin_impact_records(
326: p_project_id IN pa_projects_all.project_id%TYPE
327: ,p_source_ci_id IN pa_budget_versions.ci_id%TYPE
328: ,p_target_ci_id IN pa_budget_versions.ci_id%TYPE
329: ,p_calling_context IN VARCHAR2
330: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
331: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
332: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895