DBA Data[Home] [Help]

APPS.PA_FP_WEBADI_PKG dependencies on PA_VARCHAR2_30_TBL_TYPE

Line 188: p_error_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE(),

184: PROCEDURE process_errors
185: ( p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE ,
186: p_context IN VARCHAR2 DEFAULT NULL,
187: p_periodic_flag IN VARCHAR2 DEFAULT NULL,
188: p_error_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE(),
189: p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
190: p_rlm_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
191: p_txn_curr_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE(),
192: p_amount_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE(),

Line 191: p_txn_curr_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE(),

187: p_periodic_flag IN VARCHAR2 DEFAULT NULL,
188: p_error_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE(),
189: p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
190: p_rlm_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
191: p_txn_curr_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE(),
192: p_amount_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE(),
193: p_request_id IN pa_budget_versions.request_id%TYPE DEFAULT NULL,
194: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
195: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 192: p_amount_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE(),

188: p_error_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE(),
189: p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
190: p_rlm_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
191: p_txn_curr_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE(),
192: p_amount_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE(),
193: p_request_id IN pa_budget_versions.request_id%TYPE DEFAULT NULL,
194: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
195: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
196: x_msg_count OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895

Line 207: p_etc_method_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),

203: p_rlm_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type(),
204: p_ra_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type(),
205: p_spread_curve_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type(),
206: p_mfc_cost_type_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type(),
207: p_etc_method_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),
208: p_sp_fixed_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type(),
209: p_res_class_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),
210: p_rate_based_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type(),
211: p_rbs_elem_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type(),

Line 209: p_res_class_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),

205: p_spread_curve_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type(),
206: p_mfc_cost_type_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type(),
207: p_etc_method_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),
208: p_sp_fixed_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type(),
209: p_res_class_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),
210: p_rate_based_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type(),
211: p_rbs_elem_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type(),
212: p_txn_currency_code_tbl IN SYSTEM.pa_varchar2_15_tbl_type DEFAULT SYSTEM.pa_varchar2_15_tbl_type(),
213: p_planning_start_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type(),

Line 224: p_proj_cost_rate_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),

220: p_burdened_cost_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type(),
221: p_bill_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type(),
222: p_line_start_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type(),
223: p_line_end_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type(),
224: p_proj_cost_rate_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),
225: p_proj_cost_rate_date_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),
226: p_proj_cost_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type(),
227: p_proj_cost_rate_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type(),
228: p_proj_rev_rate_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),

Line 225: p_proj_cost_rate_date_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),

221: p_bill_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type(),
222: p_line_start_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type(),
223: p_line_end_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type(),
224: p_proj_cost_rate_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),
225: p_proj_cost_rate_date_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),
226: p_proj_cost_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type(),
227: p_proj_cost_rate_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type(),
228: p_proj_rev_rate_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),
229: p_proj_rev_rate_date_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),

Line 228: p_proj_rev_rate_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),

224: p_proj_cost_rate_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),
225: p_proj_cost_rate_date_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),
226: p_proj_cost_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type(),
227: p_proj_cost_rate_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type(),
228: p_proj_rev_rate_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),
229: p_proj_rev_rate_date_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),
230: p_proj_rev_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type(),
231: p_proj_rev_rate_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type(),
232: p_pfunc_cost_rate_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),

Line 229: p_proj_rev_rate_date_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),

225: p_proj_cost_rate_date_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),
226: p_proj_cost_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type(),
227: p_proj_cost_rate_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type(),
228: p_proj_rev_rate_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),
229: p_proj_rev_rate_date_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),
230: p_proj_rev_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type(),
231: p_proj_rev_rate_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type(),
232: p_pfunc_cost_rate_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),
233: p_pfunc_cost_rate_date_typ_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),

Line 232: p_pfunc_cost_rate_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),

228: p_proj_rev_rate_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),
229: p_proj_rev_rate_date_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),
230: p_proj_rev_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type(),
231: p_proj_rev_rate_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type(),
232: p_pfunc_cost_rate_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),
233: p_pfunc_cost_rate_date_typ_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),
234: p_pfunc_cost_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type(),
235: p_pfunc_cost_rate_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type(),
236: p_pfunc_rev_rate_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),

Line 233: p_pfunc_cost_rate_date_typ_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),

229: p_proj_rev_rate_date_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),
230: p_proj_rev_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type(),
231: p_proj_rev_rate_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type(),
232: p_pfunc_cost_rate_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),
233: p_pfunc_cost_rate_date_typ_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),
234: p_pfunc_cost_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type(),
235: p_pfunc_cost_rate_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type(),
236: p_pfunc_rev_rate_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),
237: p_pfunc_rev_rate_date_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),

Line 236: p_pfunc_rev_rate_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),

232: p_pfunc_cost_rate_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),
233: p_pfunc_cost_rate_date_typ_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),
234: p_pfunc_cost_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type(),
235: p_pfunc_cost_rate_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type(),
236: p_pfunc_rev_rate_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),
237: p_pfunc_rev_rate_date_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),
238: p_pfunc_rev_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type(),
239: p_pfunc_rev_rate_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type(),
240: p_change_reason_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),

Line 237: p_pfunc_rev_rate_date_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),

233: p_pfunc_cost_rate_date_typ_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),
234: p_pfunc_cost_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type(),
235: p_pfunc_cost_rate_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type(),
236: p_pfunc_rev_rate_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),
237: p_pfunc_rev_rate_date_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),
238: p_pfunc_rev_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type(),
239: p_pfunc_rev_rate_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type(),
240: p_change_reason_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),
241: p_description_tbl IN SYSTEM.pa_varchar2_2000_tbl_type DEFAULT SYSTEM.pa_varchar2_2000_tbl_type(),

Line 240: p_change_reason_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),

236: p_pfunc_rev_rate_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),
237: p_pfunc_rev_rate_date_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),
238: p_pfunc_rev_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type(),
239: p_pfunc_rev_rate_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type(),
240: p_change_reason_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(),
241: p_description_tbl IN SYSTEM.pa_varchar2_2000_tbl_type DEFAULT SYSTEM.pa_varchar2_2000_tbl_type(),
242: p_delete_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type(),
243: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
244: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895