DBA Data[Home] [Help]

APPS.PA_PROJ_FP_OPTIONS_PUB dependencies on PA_FIN_PLAN_TYPES_B

Line 221: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE

217: Initial Creation
218: ===================================================================================*/
219: PROCEDURE Create_amt_types (
220: p_project_id IN pa_projects_all.project_id%TYPE
221: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
222: ,p_plan_preference_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE
223: ,p_cost_layout_code IN pa_proj_fp_options.cost_layout_code%TYPE
224: ,p_revenue_layout_code IN pa_proj_fp_options.revenue_layout_code%TYPE
225: ,p_all_layout_code IN pa_proj_fp_options.all_layout_code%TYPE

Line 241: ,p_source_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE

237: ===================================================================================*/
238:
239: PROCEDURE copy_amt_types (
240: p_source_project_id IN pa_projects_all.project_id%TYPE
241: ,p_source_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
242: ,p_target_project_id IN pa_projects_all.project_id%TYPE
243: ,p_target_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
244: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
245: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 243: ,p_target_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE

239: PROCEDURE copy_amt_types (
240: p_source_project_id IN pa_projects_all.project_id%TYPE
241: ,p_source_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
242: ,p_target_project_id IN pa_projects_all.project_id%TYPE
243: ,p_target_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
244: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
245: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
246: ,x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
247:

Line 260: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE

256:
257:
258: PROCEDURE update_amt_types (
259: p_project_id IN pa_projects_all.project_id%TYPE
260: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
261: ,p_add_cost_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
262: ,p_del_cost_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
263: ,p_add_rev_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
264: ,p_del_rev_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type