DBA Data[Home] [Help]

APPS.PA_PROJ_FP_OPTIONS_PUB dependencies on PA_FIN_PLAN_TYPES_B

Line 215: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE

211: Initial Creation
212: ===================================================================================*/
213: PROCEDURE Create_amt_types (
214: p_project_id IN pa_projects_all.project_id%TYPE
215: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
216: ,p_plan_preference_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE
217: ,p_cost_layout_code IN pa_proj_fp_options.cost_layout_code%TYPE
218: ,p_revenue_layout_code IN pa_proj_fp_options.revenue_layout_code%TYPE
219: ,p_all_layout_code IN pa_proj_fp_options.all_layout_code%TYPE

Line 235: ,p_source_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE

231: ===================================================================================*/
232:
233: PROCEDURE copy_amt_types (
234: p_source_project_id IN pa_projects_all.project_id%TYPE
235: ,p_source_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
236: ,p_target_project_id IN pa_projects_all.project_id%TYPE
237: ,p_target_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
238: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
239: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 237: ,p_target_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE

233: PROCEDURE copy_amt_types (
234: p_source_project_id IN pa_projects_all.project_id%TYPE
235: ,p_source_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
236: ,p_target_project_id IN pa_projects_all.project_id%TYPE
237: ,p_target_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
238: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
239: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
240: ,x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
241:

Line 254: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE

250:
251:
252: PROCEDURE update_amt_types (
253: p_project_id IN pa_projects_all.project_id%TYPE
254: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
255: ,p_add_cost_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
256: ,p_del_cost_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
257: ,p_add_rev_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
258: ,p_del_rev_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type