131: -- with a default value of 'UI_FLOW'.
132:
133: PROCEDURE Apply_Calculate_FPM_Rules
134: ( p_preference_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE
135: ,p_resource_assignment_id_tbl IN SYSTEM.pa_num_tbl_type
136: ,p_rate_based_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
137: ,p_quantity_tbl IN SYSTEM.pa_num_tbl_type
138: ,p_txn_raw_cost_tbl IN SYSTEM.pa_num_tbl_type
139: ,p_txn_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type
133: PROCEDURE Apply_Calculate_FPM_Rules
134: ( p_preference_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE
135: ,p_resource_assignment_id_tbl IN SYSTEM.pa_num_tbl_type
136: ,p_rate_based_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
137: ,p_quantity_tbl IN SYSTEM.pa_num_tbl_type
138: ,p_txn_raw_cost_tbl IN SYSTEM.pa_num_tbl_type
139: ,p_txn_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type
140: ,p_txn_revenue_tbl IN SYSTEM.pa_num_tbl_type
141: ,p_calling_module IN VARCHAR2 DEFAULT 'UI_FLOW' -- bug 5144013
134: ( p_preference_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE
135: ,p_resource_assignment_id_tbl IN SYSTEM.pa_num_tbl_type
136: ,p_rate_based_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
137: ,p_quantity_tbl IN SYSTEM.pa_num_tbl_type
138: ,p_txn_raw_cost_tbl IN SYSTEM.pa_num_tbl_type
139: ,p_txn_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type
140: ,p_txn_revenue_tbl IN SYSTEM.pa_num_tbl_type
141: ,p_calling_module IN VARCHAR2 DEFAULT 'UI_FLOW' -- bug 5144013
142: ,x_quantity_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
135: ,p_resource_assignment_id_tbl IN SYSTEM.pa_num_tbl_type
136: ,p_rate_based_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
137: ,p_quantity_tbl IN SYSTEM.pa_num_tbl_type
138: ,p_txn_raw_cost_tbl IN SYSTEM.pa_num_tbl_type
139: ,p_txn_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type
140: ,p_txn_revenue_tbl IN SYSTEM.pa_num_tbl_type
141: ,p_calling_module IN VARCHAR2 DEFAULT 'UI_FLOW' -- bug 5144013
142: ,x_quantity_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
143: ,x_txn_raw_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
136: ,p_rate_based_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
137: ,p_quantity_tbl IN SYSTEM.pa_num_tbl_type
138: ,p_txn_raw_cost_tbl IN SYSTEM.pa_num_tbl_type
139: ,p_txn_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type
140: ,p_txn_revenue_tbl IN SYSTEM.pa_num_tbl_type
141: ,p_calling_module IN VARCHAR2 DEFAULT 'UI_FLOW' -- bug 5144013
142: ,x_quantity_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
143: ,x_txn_raw_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
144: ,x_txn_burdened_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
138: ,p_txn_raw_cost_tbl IN SYSTEM.pa_num_tbl_type
139: ,p_txn_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type
140: ,p_txn_revenue_tbl IN SYSTEM.pa_num_tbl_type
141: ,p_calling_module IN VARCHAR2 DEFAULT 'UI_FLOW' -- bug 5144013
142: ,x_quantity_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
143: ,x_txn_raw_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
144: ,x_txn_burdened_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
145: ,x_txn_revenue_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
146: ,x_raw_cost_override_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
139: ,p_txn_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type
140: ,p_txn_revenue_tbl IN SYSTEM.pa_num_tbl_type
141: ,p_calling_module IN VARCHAR2 DEFAULT 'UI_FLOW' -- bug 5144013
142: ,x_quantity_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
143: ,x_txn_raw_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
144: ,x_txn_burdened_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
145: ,x_txn_revenue_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
146: ,x_raw_cost_override_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
147: ,x_burd_cost_override_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
140: ,p_txn_revenue_tbl IN SYSTEM.pa_num_tbl_type
141: ,p_calling_module IN VARCHAR2 DEFAULT 'UI_FLOW' -- bug 5144013
142: ,x_quantity_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
143: ,x_txn_raw_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
144: ,x_txn_burdened_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
145: ,x_txn_revenue_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
146: ,x_raw_cost_override_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
147: ,x_burd_cost_override_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
148: ,x_bill_override_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
141: ,p_calling_module IN VARCHAR2 DEFAULT 'UI_FLOW' -- bug 5144013
142: ,x_quantity_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
143: ,x_txn_raw_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
144: ,x_txn_burdened_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
145: ,x_txn_revenue_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
146: ,x_raw_cost_override_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
147: ,x_burd_cost_override_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
148: ,x_bill_override_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
149: ,x_non_rb_ra_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
142: ,x_quantity_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
143: ,x_txn_raw_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
144: ,x_txn_burdened_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
145: ,x_txn_revenue_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
146: ,x_raw_cost_override_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
147: ,x_burd_cost_override_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
148: ,x_bill_override_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
149: ,x_non_rb_ra_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
150: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
143: ,x_txn_raw_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
144: ,x_txn_burdened_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
145: ,x_txn_revenue_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
146: ,x_raw_cost_override_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
147: ,x_burd_cost_override_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
148: ,x_bill_override_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
149: ,x_non_rb_ra_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
150: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
151: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
144: ,x_txn_burdened_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
145: ,x_txn_revenue_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
146: ,x_raw_cost_override_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
147: ,x_burd_cost_override_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
148: ,x_bill_override_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
149: ,x_non_rb_ra_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
150: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
151: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
152: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
145: ,x_txn_revenue_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
146: ,x_raw_cost_override_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
147: ,x_burd_cost_override_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
148: ,x_bill_override_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
149: ,x_non_rb_ra_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
150: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
151: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
152: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
153: