DBA Data[Home] [Help]

APPS.PA_FIN_PLAN_PVT dependencies on PA_CI_IMPACTS

Line 14: ci_impact_id pa_ci_impacts.ci_impact_id%TYPE,

10:
11: TYPE ci_rec IS RECORD (
12: ci_id pa_control_items.ci_id%TYPE,
13: ci_plan_version_id pa_budget_versions.budget_version_id%TYPE,
14: ci_impact_id pa_ci_impacts.ci_impact_id%TYPE,
15: record_version_number pa_ci_impacts.record_version_number%TYPE,
16: version_type pa_fp_merged_ctrl_items.version_type%TYPE,
17: impl_pfc_raw_cost pa_fp_merged_ctrl_items.impl_proj_func_raw_cost%TYPE,
18: impl_pfc_burd_cost pa_fp_merged_ctrl_items.impl_proj_func_burdened_cost%TYPE,

Line 15: record_version_number pa_ci_impacts.record_version_number%TYPE,

11: TYPE ci_rec IS RECORD (
12: ci_id pa_control_items.ci_id%TYPE,
13: ci_plan_version_id pa_budget_versions.budget_version_id%TYPE,
14: ci_impact_id pa_ci_impacts.ci_impact_id%TYPE,
15: record_version_number pa_ci_impacts.record_version_number%TYPE,
16: version_type pa_fp_merged_ctrl_items.version_type%TYPE,
17: impl_pfc_raw_cost pa_fp_merged_ctrl_items.impl_proj_func_raw_cost%TYPE,
18: impl_pfc_burd_cost pa_fp_merged_ctrl_items.impl_proj_func_burdened_cost%TYPE,
19: impl_pfc_revenue pa_fp_merged_ctrl_items.impl_proj_func_revenue%TYPE,

Line 147: ,p_impact_status IN pa_ci_impacts.status_code%TYPE DEFAULT NULL

143:
144: PROCEDURE Get_Included_Ci
145: ( p_from_bv_id IN pa_budget_versions.budget_version_id%TYPE
146: ,p_to_bv_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
147: ,p_impact_status IN pa_ci_impacts.status_code%TYPE DEFAULT NULL
148: ,x_ci_rec_tab OUT NOCOPY pa_fin_plan_pvt.ci_rec_tab
149: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
150: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
151: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895