DBA Data[Home] [Help]

APPS.PA_PROJ_FP_OPTIONS_PUB dependencies on PA_VARCHAR2_30_TBL_TYPE

Line 4350: l_cost_amount_types_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();

4346: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4347: ) IS
4348:
4349: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
4350: l_cost_amount_types_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
4351: l_rev_amount_types_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
4352: l_all_amount_types_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
4353: l_cost_layout_type_code VARCHAR2(30);
4354: l_revenue_layout_type_code VARCHAR2(30);

Line 4351: l_rev_amount_types_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();

4347: ) IS
4348:
4349: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
4350: l_cost_amount_types_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
4351: l_rev_amount_types_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
4352: l_all_amount_types_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
4353: l_cost_layout_type_code VARCHAR2(30);
4354: l_revenue_layout_type_code VARCHAR2(30);
4355: l_all_layout_type_code VARCHAR2(30);

Line 4352: l_all_amount_types_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();

4348:
4349: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
4350: l_cost_amount_types_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
4351: l_rev_amount_types_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
4352: l_all_amount_types_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
4353: l_cost_layout_type_code VARCHAR2(30);
4354: l_revenue_layout_type_code VARCHAR2(30);
4355: l_all_layout_type_code VARCHAR2(30);
4356: l_debug_mode VARCHAR2(30);

Line 4931: ,p_add_cost_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type

4927: -- This procedure is used to update the amount types for the periodic budget or forcasts of an existing plan type
4928: PROCEDURE update_amt_types (
4929: p_project_id IN pa_projects_all.project_id%TYPE
4930: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
4931: ,p_add_cost_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4932: ,p_del_cost_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4933: ,p_add_rev_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4934: ,p_del_rev_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4935: ,p_add_all_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type

Line 4932: ,p_del_cost_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type

4928: PROCEDURE update_amt_types (
4929: p_project_id IN pa_projects_all.project_id%TYPE
4930: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
4931: ,p_add_cost_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4932: ,p_del_cost_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4933: ,p_add_rev_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4934: ,p_del_rev_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4935: ,p_add_all_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4936: ,p_del_all_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type

Line 4933: ,p_add_rev_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type

4929: p_project_id IN pa_projects_all.project_id%TYPE
4930: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
4931: ,p_add_cost_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4932: ,p_del_cost_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4933: ,p_add_rev_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4934: ,p_del_rev_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4935: ,p_add_all_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4936: ,p_del_all_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4937: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 4934: ,p_del_rev_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type

4930: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
4931: ,p_add_cost_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4932: ,p_del_cost_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4933: ,p_add_rev_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4934: ,p_del_rev_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4935: ,p_add_all_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4936: ,p_del_all_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4937: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4938: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 4935: ,p_add_all_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type

4931: ,p_add_cost_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4932: ,p_del_cost_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4933: ,p_add_rev_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4934: ,p_del_rev_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4935: ,p_add_all_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4936: ,p_del_all_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4937: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4938: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4939: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 4936: ,p_del_all_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type

4932: ,p_del_cost_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4933: ,p_add_rev_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4934: ,p_del_rev_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4935: ,p_add_all_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4936: ,p_del_all_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4937: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4938: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4939: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4940: ) IS