DBA Data[Home] [Help]

APPS.PA_FP_UPGRADE_PKG dependencies on PA_NUM_TBL_TYPE

Line 135: ,p_resource_assignment_id_tbl IN SYSTEM.pa_num_tbl_type

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

Line 137: ,p_quantity_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

Line 138: ,p_txn_raw_cost_tbl IN SYSTEM.pa_num_tbl_type

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

Line 139: ,p_txn_burdened_cost_tbl IN SYSTEM.pa_num_tbl_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
143: ,x_txn_raw_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895

Line 140: ,p_txn_revenue_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
144: ,x_txn_burdened_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895

Line 142: ,x_quantity_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

Line 143: ,x_txn_raw_cost_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

Line 144: ,x_txn_burdened_cost_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

Line 145: ,x_txn_revenue_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

Line 146: ,x_raw_cost_override_rate_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

Line 147: ,x_burd_cost_override_rate_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
151: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 148: ,x_bill_override_rate_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
152: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 149: ,x_non_rb_ra_id_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
153: