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
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
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:
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