DBA Data[Home] [Help]

APPS.PA_PROJ_FP_OPTIONS_PUB dependencies on PA_VARCHAR2_30_TBL_TYPE

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

4391: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4392: ) IS
4393:
4394: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
4395: l_cost_amount_types_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
4396: l_rev_amount_types_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
4397: l_all_amount_types_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
4398: l_cost_layout_type_code VARCHAR2(30);
4399: l_revenue_layout_type_code VARCHAR2(30);

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

4392: ) IS
4393:
4394: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
4395: l_cost_amount_types_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
4396: l_rev_amount_types_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
4397: l_all_amount_types_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
4398: l_cost_layout_type_code VARCHAR2(30);
4399: l_revenue_layout_type_code VARCHAR2(30);
4400: l_all_layout_type_code VARCHAR2(30);

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

4393:
4394: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
4395: l_cost_amount_types_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
4396: l_rev_amount_types_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
4397: l_all_amount_types_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
4398: l_cost_layout_type_code VARCHAR2(30);
4399: l_revenue_layout_type_code VARCHAR2(30);
4400: l_all_layout_type_code VARCHAR2(30);
4401: l_debug_mode VARCHAR2(30);

Line 4976: ,p_add_cost_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type

4972: -- This procedure is used to update the amount types for the periodic budget or forcasts of an existing plan type
4973: PROCEDURE update_amt_types (
4974: p_project_id IN pa_projects_all.project_id%TYPE
4975: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
4976: ,p_add_cost_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4977: ,p_del_cost_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4978: ,p_add_rev_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4979: ,p_del_rev_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4980: ,p_add_all_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type

Line 4977: ,p_del_cost_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type

4973: PROCEDURE update_amt_types (
4974: p_project_id IN pa_projects_all.project_id%TYPE
4975: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
4976: ,p_add_cost_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4977: ,p_del_cost_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4978: ,p_add_rev_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4979: ,p_del_rev_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4980: ,p_add_all_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4981: ,p_del_all_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type

Line 4978: ,p_add_rev_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type

4974: p_project_id IN pa_projects_all.project_id%TYPE
4975: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
4976: ,p_add_cost_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4977: ,p_del_cost_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4978: ,p_add_rev_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4979: ,p_del_rev_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4980: ,p_add_all_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4981: ,p_del_all_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4982: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 4979: ,p_del_rev_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type

4975: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
4976: ,p_add_cost_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4977: ,p_del_cost_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4978: ,p_add_rev_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4979: ,p_del_rev_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4980: ,p_add_all_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4981: ,p_del_all_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4982: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4983: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 4980: ,p_add_all_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type

4976: ,p_add_cost_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4977: ,p_del_cost_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4978: ,p_add_rev_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4979: ,p_del_rev_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4980: ,p_add_all_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4981: ,p_del_all_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4982: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4983: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4984: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 4981: ,p_del_all_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type

4977: ,p_del_cost_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4978: ,p_add_rev_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4979: ,p_del_rev_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4980: ,p_add_all_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4981: ,p_del_all_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4982: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4983: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4984: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4985: ) IS