DBA Data[Home] [Help]

APPS.PA_FP_CI_INCLUDE_PKG dependencies on PA_BUDGET_VERSIONS

Line 9: p_project_id IN pa_budget_versions.project_id%TYPE,

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 ,

Line 11: p_target_ci_id IN pa_budget_versions.ci_id%TYPE,

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,

Line 23: l_approved_cost_flag pa_budget_versions.approved_cost_plan_type_flag%TYPE;

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:

Line 24: l_approved_rev_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;

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

Line 25: l_ci_id pa_budget_versions.ci_id%TYPE;

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;

Line 26: l_second_bv_id pa_budget_versions.budget_version_id%TYPE;

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;

Line 35: l_s_fp_ci_id pa_budget_versions.ci_id%TYPE;

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;

Line 36: l_t_fp_ci_id pa_budget_versions.ci_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:

Line 38: l_source_version_id pa_budget_versions.budget_version_id%TYPE;

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;

Line 39: l_target_version_id pa_budget_versions.budget_version_id%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;

Line 48: l_s_version_type pa_budget_versions.version_type%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);

Line 49: l_s_ci_id pa_budget_versions.ci_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);
53: l_debug_mode VARCHAR2(30);

Line 327: ,p_source_ci_id IN pa_budget_versions.ci_id%TYPE

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

Line 328: ,p_target_ci_id IN pa_budget_versions.ci_id%TYPE

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