218:
219:
220: -- Initialize all PLSQL tables
221:
222: --l_dist_line_num_tbl PA_PLSQL_DATATYPES.NumTabTyp;
223: l_accounted_cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
224: l_accounted_dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
225: l_accounted_nr_tax_tbl PA_PLSQL_DATATYPES.NumTabTyp;
226: l_acct_exch_rate_tbl PA_PLSQL_DATATYPES.NumTabTyp;
219:
220: -- Initialize all PLSQL tables
221:
222: --l_dist_line_num_tbl PA_PLSQL_DATATYPES.NumTabTyp;
223: l_accounted_cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
224: l_accounted_dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
225: l_accounted_nr_tax_tbl PA_PLSQL_DATATYPES.NumTabTyp;
226: l_acct_exch_rate_tbl PA_PLSQL_DATATYPES.NumTabTyp;
227: l_acct_pay_cc_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
220: -- Initialize all PLSQL tables
221:
222: --l_dist_line_num_tbl PA_PLSQL_DATATYPES.NumTabTyp;
223: l_accounted_cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
224: l_accounted_dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
225: l_accounted_nr_tax_tbl PA_PLSQL_DATATYPES.NumTabTyp;
226: l_acct_exch_rate_tbl PA_PLSQL_DATATYPES.NumTabTyp;
227: l_acct_pay_cc_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
228: l_acct_rate_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
221:
222: --l_dist_line_num_tbl PA_PLSQL_DATATYPES.NumTabTyp;
223: l_accounted_cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
224: l_accounted_dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
225: l_accounted_nr_tax_tbl PA_PLSQL_DATATYPES.NumTabTyp;
226: l_acct_exch_rate_tbl PA_PLSQL_DATATYPES.NumTabTyp;
227: l_acct_pay_cc_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
228: l_acct_rate_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
229: l_acct_rate_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
222: --l_dist_line_num_tbl PA_PLSQL_DATATYPES.NumTabTyp;
223: l_accounted_cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
224: l_accounted_dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
225: l_accounted_nr_tax_tbl PA_PLSQL_DATATYPES.NumTabTyp;
226: l_acct_exch_rate_tbl PA_PLSQL_DATATYPES.NumTabTyp;
227: l_acct_pay_cc_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
228: l_acct_rate_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
229: l_acct_rate_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
230: l_acct_raw_cost_tbl PA_PLSQL_DATATYPES.NumTabTyp;
223: l_accounted_cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
224: l_accounted_dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
225: l_accounted_nr_tax_tbl PA_PLSQL_DATATYPES.NumTabTyp;
226: l_acct_exch_rate_tbl PA_PLSQL_DATATYPES.NumTabTyp;
227: l_acct_pay_cc_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
228: l_acct_rate_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
229: l_acct_rate_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
230: l_acct_raw_cost_tbl PA_PLSQL_DATATYPES.NumTabTyp;
231: l_adj_exp_item_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;--NEW
224: l_accounted_dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
225: l_accounted_nr_tax_tbl PA_PLSQL_DATATYPES.NumTabTyp;
226: l_acct_exch_rate_tbl PA_PLSQL_DATATYPES.NumTabTyp;
227: l_acct_pay_cc_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
228: l_acct_rate_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
229: l_acct_rate_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
230: l_acct_raw_cost_tbl PA_PLSQL_DATATYPES.NumTabTyp;
231: l_adj_exp_item_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;--NEW
232: l_amount_tbl PA_PLSQL_DATATYPES.NumTabTyp;
225: l_accounted_nr_tax_tbl PA_PLSQL_DATATYPES.NumTabTyp;
226: l_acct_exch_rate_tbl PA_PLSQL_DATATYPES.NumTabTyp;
227: l_acct_pay_cc_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
228: l_acct_rate_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
229: l_acct_rate_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
230: l_acct_raw_cost_tbl PA_PLSQL_DATATYPES.NumTabTyp;
231: l_adj_exp_item_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;--NEW
232: l_amount_tbl PA_PLSQL_DATATYPES.NumTabTyp;
233: l_attribute10_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
226: l_acct_exch_rate_tbl PA_PLSQL_DATATYPES.NumTabTyp;
227: l_acct_pay_cc_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
228: l_acct_rate_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
229: l_acct_rate_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
230: l_acct_raw_cost_tbl PA_PLSQL_DATATYPES.NumTabTyp;
231: l_adj_exp_item_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;--NEW
232: l_amount_tbl PA_PLSQL_DATATYPES.NumTabTyp;
233: l_attribute10_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
234: l_attribute1_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
227: l_acct_pay_cc_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
228: l_acct_rate_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
229: l_acct_rate_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
230: l_acct_raw_cost_tbl PA_PLSQL_DATATYPES.NumTabTyp;
231: l_adj_exp_item_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;--NEW
232: l_amount_tbl PA_PLSQL_DATATYPES.NumTabTyp;
233: l_attribute10_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
234: l_attribute1_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
235: l_attribute2_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
228: l_acct_rate_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
229: l_acct_rate_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
230: l_acct_raw_cost_tbl PA_PLSQL_DATATYPES.NumTabTyp;
231: l_adj_exp_item_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;--NEW
232: l_amount_tbl PA_PLSQL_DATATYPES.NumTabTyp;
233: l_attribute10_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
234: l_attribute1_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
235: l_attribute2_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
236: l_attribute3_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
229: l_acct_rate_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
230: l_acct_raw_cost_tbl PA_PLSQL_DATATYPES.NumTabTyp;
231: l_adj_exp_item_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;--NEW
232: l_amount_tbl PA_PLSQL_DATATYPES.NumTabTyp;
233: l_attribute10_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
234: l_attribute1_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
235: l_attribute2_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
236: l_attribute3_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
237: l_attribute4_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
230: l_acct_raw_cost_tbl PA_PLSQL_DATATYPES.NumTabTyp;
231: l_adj_exp_item_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;--NEW
232: l_amount_tbl PA_PLSQL_DATATYPES.NumTabTyp;
233: l_attribute10_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
234: l_attribute1_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
235: l_attribute2_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
236: l_attribute3_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
237: l_attribute4_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
238: l_attribute5_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
231: l_adj_exp_item_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;--NEW
232: l_amount_tbl PA_PLSQL_DATATYPES.NumTabTyp;
233: l_attribute10_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
234: l_attribute1_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
235: l_attribute2_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
236: l_attribute3_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
237: l_attribute4_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
238: l_attribute5_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
239: l_attribute6_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
232: l_amount_tbl PA_PLSQL_DATATYPES.NumTabTyp;
233: l_attribute10_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
234: l_attribute1_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
235: l_attribute2_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
236: l_attribute3_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
237: l_attribute4_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
238: l_attribute5_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
239: l_attribute6_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
240: l_attribute7_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
233: l_attribute10_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
234: l_attribute1_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
235: l_attribute2_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
236: l_attribute3_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
237: l_attribute4_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
238: l_attribute5_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
239: l_attribute6_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
240: l_attribute7_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
241: l_attribute8_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
234: l_attribute1_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
235: l_attribute2_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
236: l_attribute3_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
237: l_attribute4_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
238: l_attribute5_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
239: l_attribute6_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
240: l_attribute7_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
241: l_attribute8_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
242: l_attribute9_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
235: l_attribute2_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
236: l_attribute3_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
237: l_attribute4_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
238: l_attribute5_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
239: l_attribute6_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
240: l_attribute7_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
241: l_attribute8_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
242: l_attribute9_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
243: l_attribute_cat_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
236: l_attribute3_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
237: l_attribute4_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
238: l_attribute5_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
239: l_attribute6_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
240: l_attribute7_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
241: l_attribute8_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
242: l_attribute9_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
243: l_attribute_cat_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
244: l_batch_name_tbl PA_PLSQL_DATATYPES.Char50TabTyp;
237: l_attribute4_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
238: l_attribute5_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
239: l_attribute6_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
240: l_attribute7_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
241: l_attribute8_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
242: l_attribute9_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
243: l_attribute_cat_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
244: l_batch_name_tbl PA_PLSQL_DATATYPES.Char50TabTyp;
245: l_bus_grp_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
238: l_attribute5_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
239: l_attribute6_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
240: l_attribute7_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
241: l_attribute8_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
242: l_attribute9_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
243: l_attribute_cat_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
244: l_batch_name_tbl PA_PLSQL_DATATYPES.Char50TabTyp;
245: l_bus_grp_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
246: l_cancel_flag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;--NEW
239: l_attribute6_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
240: l_attribute7_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
241: l_attribute8_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
242: l_attribute9_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
243: l_attribute_cat_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
244: l_batch_name_tbl PA_PLSQL_DATATYPES.Char50TabTyp;
245: l_bus_grp_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
246: l_cancel_flag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;--NEW
247: l_cc_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
240: l_attribute7_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
241: l_attribute8_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
242: l_attribute9_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
243: l_attribute_cat_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
244: l_batch_name_tbl PA_PLSQL_DATATYPES.Char50TabTyp;
245: l_bus_grp_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
246: l_cancel_flag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;--NEW
247: l_cc_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
248: l_cdl_sys_ref4_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
241: l_attribute8_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
242: l_attribute9_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
243: l_attribute_cat_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
244: l_batch_name_tbl PA_PLSQL_DATATYPES.Char50TabTyp;
245: l_bus_grp_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
246: l_cancel_flag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;--NEW
247: l_cc_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
248: l_cdl_sys_ref4_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
249: l_cdl_sys_ref3_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
242: l_attribute9_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
243: l_attribute_cat_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
244: l_batch_name_tbl PA_PLSQL_DATATYPES.Char50TabTyp;
245: l_bus_grp_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
246: l_cancel_flag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;--NEW
247: l_cc_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
248: l_cdl_sys_ref4_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
249: l_cdl_sys_ref3_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
250: l_created_by_tbl PA_PLSQL_DATATYPES.NumTabTyp;
243: l_attribute_cat_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
244: l_batch_name_tbl PA_PLSQL_DATATYPES.Char50TabTyp;
245: l_bus_grp_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
246: l_cancel_flag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;--NEW
247: l_cc_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
248: l_cdl_sys_ref4_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
249: l_cdl_sys_ref3_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
250: l_created_by_tbl PA_PLSQL_DATATYPES.NumTabTyp;
251: l_cur_conv_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
244: l_batch_name_tbl PA_PLSQL_DATATYPES.Char50TabTyp;
245: l_bus_grp_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
246: l_cancel_flag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;--NEW
247: l_cc_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
248: l_cdl_sys_ref4_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
249: l_cdl_sys_ref3_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
250: l_created_by_tbl PA_PLSQL_DATATYPES.NumTabTyp;
251: l_cur_conv_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
252: l_cur_conv_rate_tbl PA_PLSQL_DATATYPES.NumTabTyp;
245: l_bus_grp_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
246: l_cancel_flag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;--NEW
247: l_cc_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
248: l_cdl_sys_ref4_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
249: l_cdl_sys_ref3_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
250: l_created_by_tbl PA_PLSQL_DATATYPES.NumTabTyp;
251: l_cur_conv_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
252: l_cur_conv_rate_tbl PA_PLSQL_DATATYPES.NumTabTyp;
253: l_cur_conv_type_tbl PA_PLSQL_DATATYPES.CHAR30TabTyp;
246: l_cancel_flag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;--NEW
247: l_cc_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
248: l_cdl_sys_ref4_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
249: l_cdl_sys_ref3_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
250: l_created_by_tbl PA_PLSQL_DATATYPES.NumTabTyp;
251: l_cur_conv_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
252: l_cur_conv_rate_tbl PA_PLSQL_DATATYPES.NumTabTyp;
253: l_cur_conv_type_tbl PA_PLSQL_DATATYPES.CHAR30TabTyp;
254: l_denom_cur_code_tbl PA_PLSQL_DATATYPES.CHAR15TabTyp;
247: l_cc_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
248: l_cdl_sys_ref4_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
249: l_cdl_sys_ref3_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
250: l_created_by_tbl PA_PLSQL_DATATYPES.NumTabTyp;
251: l_cur_conv_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
252: l_cur_conv_rate_tbl PA_PLSQL_DATATYPES.NumTabTyp;
253: l_cur_conv_type_tbl PA_PLSQL_DATATYPES.CHAR30TabTyp;
254: l_denom_cur_code_tbl PA_PLSQL_DATATYPES.CHAR15TabTyp;
255: l_denom_raw_cost_tbl PA_PLSQL_DATATYPES.NumTabTyp;
248: l_cdl_sys_ref4_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
249: l_cdl_sys_ref3_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
250: l_created_by_tbl PA_PLSQL_DATATYPES.NumTabTyp;
251: l_cur_conv_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
252: l_cur_conv_rate_tbl PA_PLSQL_DATATYPES.NumTabTyp;
253: l_cur_conv_type_tbl PA_PLSQL_DATATYPES.CHAR30TabTyp;
254: l_denom_cur_code_tbl PA_PLSQL_DATATYPES.CHAR15TabTyp;
255: l_denom_raw_cost_tbl PA_PLSQL_DATATYPES.NumTabTyp;
256: l_description_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
249: l_cdl_sys_ref3_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
250: l_created_by_tbl PA_PLSQL_DATATYPES.NumTabTyp;
251: l_cur_conv_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
252: l_cur_conv_rate_tbl PA_PLSQL_DATATYPES.NumTabTyp;
253: l_cur_conv_type_tbl PA_PLSQL_DATATYPES.CHAR30TabTyp;
254: l_denom_cur_code_tbl PA_PLSQL_DATATYPES.CHAR15TabTyp;
255: l_denom_raw_cost_tbl PA_PLSQL_DATATYPES.NumTabTyp;
256: l_description_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
257: l_dest_typ_code_tbl PA_PLSQL_DATATYPES.Char25TabTyp;
250: l_created_by_tbl PA_PLSQL_DATATYPES.NumTabTyp;
251: l_cur_conv_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
252: l_cur_conv_rate_tbl PA_PLSQL_DATATYPES.NumTabTyp;
253: l_cur_conv_type_tbl PA_PLSQL_DATATYPES.CHAR30TabTyp;
254: l_denom_cur_code_tbl PA_PLSQL_DATATYPES.CHAR15TabTyp;
255: l_denom_raw_cost_tbl PA_PLSQL_DATATYPES.NumTabTyp;
256: l_description_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
257: l_dest_typ_code_tbl PA_PLSQL_DATATYPES.Char25TabTyp;
258: l_dist_cc_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
251: l_cur_conv_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
252: l_cur_conv_rate_tbl PA_PLSQL_DATATYPES.NumTabTyp;
253: l_cur_conv_type_tbl PA_PLSQL_DATATYPES.CHAR30TabTyp;
254: l_denom_cur_code_tbl PA_PLSQL_DATATYPES.CHAR15TabTyp;
255: l_denom_raw_cost_tbl PA_PLSQL_DATATYPES.NumTabTyp;
256: l_description_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
257: l_dest_typ_code_tbl PA_PLSQL_DATATYPES.Char25TabTyp;
258: l_dist_cc_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
259: l_ei_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
252: l_cur_conv_rate_tbl PA_PLSQL_DATATYPES.NumTabTyp;
253: l_cur_conv_type_tbl PA_PLSQL_DATATYPES.CHAR30TabTyp;
254: l_denom_cur_code_tbl PA_PLSQL_DATATYPES.CHAR15TabTyp;
255: l_denom_raw_cost_tbl PA_PLSQL_DATATYPES.NumTabTyp;
256: l_description_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
257: l_dest_typ_code_tbl PA_PLSQL_DATATYPES.Char25TabTyp;
258: l_dist_cc_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
259: l_ei_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
260: l_employee_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
253: l_cur_conv_type_tbl PA_PLSQL_DATATYPES.CHAR30TabTyp;
254: l_denom_cur_code_tbl PA_PLSQL_DATATYPES.CHAR15TabTyp;
255: l_denom_raw_cost_tbl PA_PLSQL_DATATYPES.NumTabTyp;
256: l_description_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
257: l_dest_typ_code_tbl PA_PLSQL_DATATYPES.Char25TabTyp;
258: l_dist_cc_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
259: l_ei_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
260: l_employee_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
261: l_entered_cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
254: l_denom_cur_code_tbl PA_PLSQL_DATATYPES.CHAR15TabTyp;
255: l_denom_raw_cost_tbl PA_PLSQL_DATATYPES.NumTabTyp;
256: l_description_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
257: l_dest_typ_code_tbl PA_PLSQL_DATATYPES.Char25TabTyp;
258: l_dist_cc_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
259: l_ei_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
260: l_employee_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
261: l_entered_cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
262: l_entered_dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
255: l_denom_raw_cost_tbl PA_PLSQL_DATATYPES.NumTabTyp;
256: l_description_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
257: l_dest_typ_code_tbl PA_PLSQL_DATATYPES.Char25TabTyp;
258: l_dist_cc_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
259: l_ei_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
260: l_employee_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
261: l_entered_cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
262: l_entered_dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
263: l_entered_nr_tax_tbl PA_PLSQL_DATATYPES.NumTabTyp;
256: l_description_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
257: l_dest_typ_code_tbl PA_PLSQL_DATATYPES.Char25TabTyp;
258: l_dist_cc_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
259: l_ei_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
260: l_employee_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
261: l_entered_cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
262: l_entered_dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
263: l_entered_nr_tax_tbl PA_PLSQL_DATATYPES.NumTabTyp;
264: l_exp_end_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
257: l_dest_typ_code_tbl PA_PLSQL_DATATYPES.Char25TabTyp;
258: l_dist_cc_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
259: l_ei_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
260: l_employee_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
261: l_entered_cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
262: l_entered_dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
263: l_entered_nr_tax_tbl PA_PLSQL_DATATYPES.NumTabTyp;
264: l_exp_end_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
265: l_exp_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
258: l_dist_cc_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
259: l_ei_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
260: l_employee_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
261: l_entered_cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
262: l_entered_dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
263: l_entered_nr_tax_tbl PA_PLSQL_DATATYPES.NumTabTyp;
264: l_exp_end_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
265: l_exp_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
266: l_exp_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
259: l_ei_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
260: l_employee_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
261: l_entered_cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
262: l_entered_dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
263: l_entered_nr_tax_tbl PA_PLSQL_DATATYPES.NumTabTyp;
264: l_exp_end_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
265: l_exp_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
266: l_exp_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
267: l_fc_document_type_tbl PA_PLSQL_DATATYPES.CHAR15TabTyp;--NEW
260: l_employee_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
261: l_entered_cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
262: l_entered_dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
263: l_entered_nr_tax_tbl PA_PLSQL_DATATYPES.NumTabTyp;
264: l_exp_end_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
265: l_exp_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
266: l_exp_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
267: l_fc_document_type_tbl PA_PLSQL_DATATYPES.CHAR15TabTyp;--NEW
268: l_fc_enabled_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;--NEW
261: l_entered_cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
262: l_entered_dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
263: l_entered_nr_tax_tbl PA_PLSQL_DATATYPES.NumTabTyp;
264: l_exp_end_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
265: l_exp_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
266: l_exp_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
267: l_fc_document_type_tbl PA_PLSQL_DATATYPES.CHAR15TabTyp;--NEW
268: l_fc_enabled_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;--NEW
269: l_gl_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
262: l_entered_dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
263: l_entered_nr_tax_tbl PA_PLSQL_DATATYPES.NumTabTyp;
264: l_exp_end_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
265: l_exp_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
266: l_exp_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
267: l_fc_document_type_tbl PA_PLSQL_DATATYPES.CHAR15TabTyp;--NEW
268: l_fc_enabled_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;--NEW
269: l_gl_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
270: l_insert_flag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;
263: l_entered_nr_tax_tbl PA_PLSQL_DATATYPES.NumTabTyp;
264: l_exp_end_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
265: l_exp_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
266: l_exp_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
267: l_fc_document_type_tbl PA_PLSQL_DATATYPES.CHAR15TabTyp;--NEW
268: l_fc_enabled_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;--NEW
269: l_gl_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
270: l_insert_flag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;
271: l_interface_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
264: l_exp_end_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
265: l_exp_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
266: l_exp_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
267: l_fc_document_type_tbl PA_PLSQL_DATATYPES.CHAR15TabTyp;--NEW
268: l_fc_enabled_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;--NEW
269: l_gl_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
270: l_insert_flag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;
271: l_interface_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
272: l_inv_pay_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
265: l_exp_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
266: l_exp_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
267: l_fc_document_type_tbl PA_PLSQL_DATATYPES.CHAR15TabTyp;--NEW
268: l_fc_enabled_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;--NEW
269: l_gl_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
270: l_insert_flag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;
271: l_interface_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
272: l_inv_pay_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
273: -- l_inv_typ_code_tbl PA_PLSQL_DATATYPES.Char25TabTyp;
266: l_exp_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
267: l_fc_document_type_tbl PA_PLSQL_DATATYPES.CHAR15TabTyp;--NEW
268: l_fc_enabled_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;--NEW
269: l_gl_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
270: l_insert_flag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;
271: l_interface_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
272: l_inv_pay_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
273: -- l_inv_typ_code_tbl PA_PLSQL_DATATYPES.Char25TabTyp;
274: l_inv_type_code_tbl PA_PLSQL_DATATYPES.Char25TabTyp;
267: l_fc_document_type_tbl PA_PLSQL_DATATYPES.CHAR15TabTyp;--NEW
268: l_fc_enabled_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;--NEW
269: l_gl_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
270: l_insert_flag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;
271: l_interface_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
272: l_inv_pay_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
273: -- l_inv_typ_code_tbl PA_PLSQL_DATATYPES.Char25TabTyp;
274: l_inv_type_code_tbl PA_PLSQL_DATATYPES.Char25TabTyp;
275: l_invoice_dist_id PA_PLSQL_DATATYPES.IdTabTyp; --NEw
268: l_fc_enabled_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;--NEW
269: l_gl_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
270: l_insert_flag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;
271: l_interface_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
272: l_inv_pay_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
273: -- l_inv_typ_code_tbl PA_PLSQL_DATATYPES.Char25TabTyp;
274: l_inv_type_code_tbl PA_PLSQL_DATATYPES.Char25TabTyp;
275: l_invoice_dist_id PA_PLSQL_DATATYPES.IdTabTyp; --NEw
276: l_invoice_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
269: l_gl_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
270: l_insert_flag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;
271: l_interface_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
272: l_inv_pay_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
273: -- l_inv_typ_code_tbl PA_PLSQL_DATATYPES.Char25TabTyp;
274: l_inv_type_code_tbl PA_PLSQL_DATATYPES.Char25TabTyp;
275: l_invoice_dist_id PA_PLSQL_DATATYPES.IdTabTyp; --NEw
276: l_invoice_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
277: l_invoice_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
270: l_insert_flag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;
271: l_interface_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
272: l_inv_pay_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
273: -- l_inv_typ_code_tbl PA_PLSQL_DATATYPES.Char25TabTyp;
274: l_inv_type_code_tbl PA_PLSQL_DATATYPES.Char25TabTyp;
275: l_invoice_dist_id PA_PLSQL_DATATYPES.IdTabTyp; --NEw
276: l_invoice_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
277: l_invoice_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
278: l_invoice_num_tbl PA_PLSQL_DATATYPES.Char50TabTyp;
271: l_interface_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
272: l_inv_pay_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
273: -- l_inv_typ_code_tbl PA_PLSQL_DATATYPES.Char25TabTyp;
274: l_inv_type_code_tbl PA_PLSQL_DATATYPES.Char25TabTyp;
275: l_invoice_dist_id PA_PLSQL_DATATYPES.IdTabTyp; --NEw
276: l_invoice_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
277: l_invoice_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
278: l_invoice_num_tbl PA_PLSQL_DATATYPES.Char50TabTyp;
279: l_job_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
272: l_inv_pay_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
273: -- l_inv_typ_code_tbl PA_PLSQL_DATATYPES.Char25TabTyp;
274: l_inv_type_code_tbl PA_PLSQL_DATATYPES.Char25TabTyp;
275: l_invoice_dist_id PA_PLSQL_DATATYPES.IdTabTyp; --NEw
276: l_invoice_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
277: l_invoice_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
278: l_invoice_num_tbl PA_PLSQL_DATATYPES.Char50TabTyp;
279: l_job_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
280: l_justification_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
273: -- l_inv_typ_code_tbl PA_PLSQL_DATATYPES.Char25TabTyp;
274: l_inv_type_code_tbl PA_PLSQL_DATATYPES.Char25TabTyp;
275: l_invoice_dist_id PA_PLSQL_DATATYPES.IdTabTyp; --NEw
276: l_invoice_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
277: l_invoice_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
278: l_invoice_num_tbl PA_PLSQL_DATATYPES.Char50TabTyp;
279: l_job_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
280: l_justification_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
281: l_ln_type_lookup_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
274: l_inv_type_code_tbl PA_PLSQL_DATATYPES.Char25TabTyp;
275: l_invoice_dist_id PA_PLSQL_DATATYPES.IdTabTyp; --NEw
276: l_invoice_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
277: l_invoice_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
278: l_invoice_num_tbl PA_PLSQL_DATATYPES.Char50TabTyp;
279: l_job_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
280: l_justification_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
281: l_ln_type_lookup_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
282: l_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
275: l_invoice_dist_id PA_PLSQL_DATATYPES.IdTabTyp; --NEw
276: l_invoice_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
277: l_invoice_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
278: l_invoice_num_tbl PA_PLSQL_DATATYPES.Char50TabTyp;
279: l_job_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
280: l_justification_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
281: l_ln_type_lookup_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
282: l_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
283: l_pa_add_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
276: l_invoice_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
277: l_invoice_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
278: l_invoice_num_tbl PA_PLSQL_DATATYPES.Char50TabTyp;
279: l_job_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
280: l_justification_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
281: l_ln_type_lookup_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
282: l_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
283: l_pa_add_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
284: l_paid_emp_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
277: l_invoice_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
278: l_invoice_num_tbl PA_PLSQL_DATATYPES.Char50TabTyp;
279: l_job_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
280: l_justification_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
281: l_ln_type_lookup_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
282: l_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
283: l_pa_add_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
284: l_paid_emp_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
285: l_parent_pmt_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; --NEW
278: l_invoice_num_tbl PA_PLSQL_DATATYPES.Char50TabTyp;
279: l_job_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
280: l_justification_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
281: l_ln_type_lookup_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
282: l_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
283: l_pa_add_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
284: l_paid_emp_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
285: l_parent_pmt_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; --NEW
286: l_parent_rcv_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; -- NEW --added for full return reversal logic
279: l_job_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
280: l_justification_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
281: l_ln_type_lookup_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
282: l_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
283: l_pa_add_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
284: l_paid_emp_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
285: l_parent_pmt_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; --NEW
286: l_parent_rcv_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; -- NEW --added for full return reversal logic
287: l_rcv_amount_tbl PA_PLSQL_DATATYPES.NumTabTyp; -- NEW --added for full return reversal logic
280: l_justification_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
281: l_ln_type_lookup_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
282: l_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
283: l_pa_add_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
284: l_paid_emp_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
285: l_parent_pmt_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; --NEW
286: l_parent_rcv_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; -- NEW --added for full return reversal logic
287: l_rcv_amount_tbl PA_PLSQL_DATATYPES.NumTabTyp; -- NEW --added for full return reversal logic
288: l_parent_rev_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;--NEW
281: l_ln_type_lookup_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
282: l_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
283: l_pa_add_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
284: l_paid_emp_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
285: l_parent_pmt_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; --NEW
286: l_parent_rcv_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; -- NEW --added for full return reversal logic
287: l_rcv_amount_tbl PA_PLSQL_DATATYPES.NumTabTyp; -- NEW --added for full return reversal logic
288: l_parent_rev_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;--NEW
289: l_pay_cc_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
282: l_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
283: l_pa_add_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
284: l_paid_emp_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
285: l_parent_pmt_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; --NEW
286: l_parent_rcv_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; -- NEW --added for full return reversal logic
287: l_rcv_amount_tbl PA_PLSQL_DATATYPES.NumTabTyp; -- NEW --added for full return reversal logic
288: l_parent_rev_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;--NEW
289: l_pay_cc_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
290: l_po_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
283: l_pa_add_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
284: l_paid_emp_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
285: l_parent_pmt_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; --NEW
286: l_parent_rcv_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; -- NEW --added for full return reversal logic
287: l_rcv_amount_tbl PA_PLSQL_DATATYPES.NumTabTyp; -- NEW --added for full return reversal logic
288: l_parent_rev_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;--NEW
289: l_pay_cc_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
290: l_po_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
291: l_po_head_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
284: l_paid_emp_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
285: l_parent_pmt_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; --NEW
286: l_parent_rcv_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; -- NEW --added for full return reversal logic
287: l_rcv_amount_tbl PA_PLSQL_DATATYPES.NumTabTyp; -- NEW --added for full return reversal logic
288: l_parent_rev_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;--NEW
289: l_pay_cc_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
290: l_po_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
291: l_po_head_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
292: l_po_num_tbl PA_PLSQL_DATATYPES.Char20TabTyp;
285: l_parent_pmt_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; --NEW
286: l_parent_rcv_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; -- NEW --added for full return reversal logic
287: l_rcv_amount_tbl PA_PLSQL_DATATYPES.NumTabTyp; -- NEW --added for full return reversal logic
288: l_parent_rev_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;--NEW
289: l_pay_cc_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
290: l_po_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
291: l_po_head_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
292: l_po_num_tbl PA_PLSQL_DATATYPES.Char20TabTyp;
293: l_proj_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
286: l_parent_rcv_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; -- NEW --added for full return reversal logic
287: l_rcv_amount_tbl PA_PLSQL_DATATYPES.NumTabTyp; -- NEW --added for full return reversal logic
288: l_parent_rev_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;--NEW
289: l_pay_cc_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
290: l_po_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
291: l_po_head_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
292: l_po_num_tbl PA_PLSQL_DATATYPES.Char20TabTyp;
293: l_proj_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
294: l_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
287: l_rcv_amount_tbl PA_PLSQL_DATATYPES.NumTabTyp; -- NEW --added for full return reversal logic
288: l_parent_rev_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;--NEW
289: l_pay_cc_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
290: l_po_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
291: l_po_head_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
292: l_po_num_tbl PA_PLSQL_DATATYPES.Char20TabTyp;
293: l_proj_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
294: l_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
295: l_quantity_tbl PA_PLSQL_DATATYPES.NumTabTyp;
288: l_parent_rev_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;--NEW
289: l_pay_cc_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
290: l_po_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
291: l_po_head_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
292: l_po_num_tbl PA_PLSQL_DATATYPES.Char20TabTyp;
293: l_proj_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
294: l_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
295: l_quantity_tbl PA_PLSQL_DATATYPES.NumTabTyp;
296: l_rcv_acct_evt_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; -- pricing changes
289: l_pay_cc_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
290: l_po_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
291: l_po_head_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
292: l_po_num_tbl PA_PLSQL_DATATYPES.Char20TabTyp;
293: l_proj_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
294: l_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
295: l_quantity_tbl PA_PLSQL_DATATYPES.NumTabTyp;
296: l_rcv_acct_evt_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; -- pricing changes
297: l_rcv_acct_evt_typ_tbl PA_PLSQL_DATATYPES.Char30TabTyp; -- pricing changes
290: l_po_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
291: l_po_head_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
292: l_po_num_tbl PA_PLSQL_DATATYPES.Char20TabTyp;
293: l_proj_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
294: l_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
295: l_quantity_tbl PA_PLSQL_DATATYPES.NumTabTyp;
296: l_rcv_acct_evt_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; -- pricing changes
297: l_rcv_acct_evt_typ_tbl PA_PLSQL_DATATYPES.Char30TabTyp; -- pricing changes
298: l_rcv_acct_rec_tax_tbl PA_PLSQL_DATATYPES.NumTabTyp; -- pricing changes
291: l_po_head_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
292: l_po_num_tbl PA_PLSQL_DATATYPES.Char20TabTyp;
293: l_proj_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
294: l_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
295: l_quantity_tbl PA_PLSQL_DATATYPES.NumTabTyp;
296: l_rcv_acct_evt_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; -- pricing changes
297: l_rcv_acct_evt_typ_tbl PA_PLSQL_DATATYPES.Char30TabTyp; -- pricing changes
298: l_rcv_acct_rec_tax_tbl PA_PLSQL_DATATYPES.NumTabTyp; -- pricing changes
299: l_rcv_ent_rec_tax_tbl PA_PLSQL_DATATYPES.NumTabTyp; -- pricing changes
292: l_po_num_tbl PA_PLSQL_DATATYPES.Char20TabTyp;
293: l_proj_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
294: l_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
295: l_quantity_tbl PA_PLSQL_DATATYPES.NumTabTyp;
296: l_rcv_acct_evt_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; -- pricing changes
297: l_rcv_acct_evt_typ_tbl PA_PLSQL_DATATYPES.Char30TabTyp; -- pricing changes
298: l_rcv_acct_rec_tax_tbl PA_PLSQL_DATATYPES.NumTabTyp; -- pricing changes
299: l_rcv_ent_rec_tax_tbl PA_PLSQL_DATATYPES.NumTabTyp; -- pricing changes
300: l_rcv_txn_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
293: l_proj_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
294: l_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
295: l_quantity_tbl PA_PLSQL_DATATYPES.NumTabTyp;
296: l_rcv_acct_evt_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; -- pricing changes
297: l_rcv_acct_evt_typ_tbl PA_PLSQL_DATATYPES.Char30TabTyp; -- pricing changes
298: l_rcv_acct_rec_tax_tbl PA_PLSQL_DATATYPES.NumTabTyp; -- pricing changes
299: l_rcv_ent_rec_tax_tbl PA_PLSQL_DATATYPES.NumTabTyp; -- pricing changes
300: l_rcv_txn_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
301: l_rec_conv_rate_tbl PA_PLSQL_DATATYPES.NumTabTyp;
294: l_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
295: l_quantity_tbl PA_PLSQL_DATATYPES.NumTabTyp;
296: l_rcv_acct_evt_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; -- pricing changes
297: l_rcv_acct_evt_typ_tbl PA_PLSQL_DATATYPES.Char30TabTyp; -- pricing changes
298: l_rcv_acct_rec_tax_tbl PA_PLSQL_DATATYPES.NumTabTyp; -- pricing changes
299: l_rcv_ent_rec_tax_tbl PA_PLSQL_DATATYPES.NumTabTyp; -- pricing changes
300: l_rcv_txn_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
301: l_rec_conv_rate_tbl PA_PLSQL_DATATYPES.NumTabTyp;
302: l_rec_cur_amt_tbl PA_PLSQL_DATATYPES.NumTabTyp;
295: l_quantity_tbl PA_PLSQL_DATATYPES.NumTabTyp;
296: l_rcv_acct_evt_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; -- pricing changes
297: l_rcv_acct_evt_typ_tbl PA_PLSQL_DATATYPES.Char30TabTyp; -- pricing changes
298: l_rcv_acct_rec_tax_tbl PA_PLSQL_DATATYPES.NumTabTyp; -- pricing changes
299: l_rcv_ent_rec_tax_tbl PA_PLSQL_DATATYPES.NumTabTyp; -- pricing changes
300: l_rcv_txn_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
301: l_rec_conv_rate_tbl PA_PLSQL_DATATYPES.NumTabTyp;
302: l_rec_cur_amt_tbl PA_PLSQL_DATATYPES.NumTabTyp;
303: l_rec_cur_code_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
296: l_rcv_acct_evt_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; -- pricing changes
297: l_rcv_acct_evt_typ_tbl PA_PLSQL_DATATYPES.Char30TabTyp; -- pricing changes
298: l_rcv_acct_rec_tax_tbl PA_PLSQL_DATATYPES.NumTabTyp; -- pricing changes
299: l_rcv_ent_rec_tax_tbl PA_PLSQL_DATATYPES.NumTabTyp; -- pricing changes
300: l_rcv_txn_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
301: l_rec_conv_rate_tbl PA_PLSQL_DATATYPES.NumTabTyp;
302: l_rec_cur_amt_tbl PA_PLSQL_DATATYPES.NumTabTyp;
303: l_rec_cur_code_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
304: l_record_type_tbl PA_PLSQL_DATATYPES.CHAR20TabTyp;
297: l_rcv_acct_evt_typ_tbl PA_PLSQL_DATATYPES.Char30TabTyp; -- pricing changes
298: l_rcv_acct_rec_tax_tbl PA_PLSQL_DATATYPES.NumTabTyp; -- pricing changes
299: l_rcv_ent_rec_tax_tbl PA_PLSQL_DATATYPES.NumTabTyp; -- pricing changes
300: l_rcv_txn_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
301: l_rec_conv_rate_tbl PA_PLSQL_DATATYPES.NumTabTyp;
302: l_rec_cur_amt_tbl PA_PLSQL_DATATYPES.NumTabTyp;
303: l_rec_cur_code_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
304: l_record_type_tbl PA_PLSQL_DATATYPES.CHAR20TabTyp;
305: l_reversal_flag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp; --NEW
298: l_rcv_acct_rec_tax_tbl PA_PLSQL_DATATYPES.NumTabTyp; -- pricing changes
299: l_rcv_ent_rec_tax_tbl PA_PLSQL_DATATYPES.NumTabTyp; -- pricing changes
300: l_rcv_txn_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
301: l_rec_conv_rate_tbl PA_PLSQL_DATATYPES.NumTabTyp;
302: l_rec_cur_amt_tbl PA_PLSQL_DATATYPES.NumTabTyp;
303: l_rec_cur_code_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
304: l_record_type_tbl PA_PLSQL_DATATYPES.CHAR20TabTyp;
305: l_reversal_flag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp; --NEW
306: l_sort_var_tbl PA_PLSQL_DATATYPES.NumTabTyp;
299: l_rcv_ent_rec_tax_tbl PA_PLSQL_DATATYPES.NumTabTyp; -- pricing changes
300: l_rcv_txn_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
301: l_rec_conv_rate_tbl PA_PLSQL_DATATYPES.NumTabTyp;
302: l_rec_cur_amt_tbl PA_PLSQL_DATATYPES.NumTabTyp;
303: l_rec_cur_code_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
304: l_record_type_tbl PA_PLSQL_DATATYPES.CHAR20TabTyp;
305: l_reversal_flag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp; --NEW
306: l_sort_var_tbl PA_PLSQL_DATATYPES.NumTabTyp;
307: l_source_tbl PA_PLSQL_DATATYPES.Char25TabTyp;
300: l_rcv_txn_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
301: l_rec_conv_rate_tbl PA_PLSQL_DATATYPES.NumTabTyp;
302: l_rec_cur_amt_tbl PA_PLSQL_DATATYPES.NumTabTyp;
303: l_rec_cur_code_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
304: l_record_type_tbl PA_PLSQL_DATATYPES.CHAR20TabTyp;
305: l_reversal_flag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp; --NEW
306: l_sort_var_tbl PA_PLSQL_DATATYPES.NumTabTyp;
307: l_source_tbl PA_PLSQL_DATATYPES.Char25TabTyp;
308: l_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
301: l_rec_conv_rate_tbl PA_PLSQL_DATATYPES.NumTabTyp;
302: l_rec_cur_amt_tbl PA_PLSQL_DATATYPES.NumTabTyp;
303: l_rec_cur_code_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
304: l_record_type_tbl PA_PLSQL_DATATYPES.CHAR20TabTyp;
305: l_reversal_flag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp; --NEW
306: l_sort_var_tbl PA_PLSQL_DATATYPES.NumTabTyp;
307: l_source_tbl PA_PLSQL_DATATYPES.Char25TabTyp;
308: l_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
309: l_trx_type_tbl PA_PLSQL_DATATYPES.Char25TabTyp;
302: l_rec_cur_amt_tbl PA_PLSQL_DATATYPES.NumTabTyp;
303: l_rec_cur_code_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
304: l_record_type_tbl PA_PLSQL_DATATYPES.CHAR20TabTyp;
305: l_reversal_flag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp; --NEW
306: l_sort_var_tbl PA_PLSQL_DATATYPES.NumTabTyp;
307: l_source_tbl PA_PLSQL_DATATYPES.Char25TabTyp;
308: l_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
309: l_trx_type_tbl PA_PLSQL_DATATYPES.Char25TabTyp;
310: l_txn_rej_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
303: l_rec_cur_code_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
304: l_record_type_tbl PA_PLSQL_DATATYPES.CHAR20TabTyp;
305: l_reversal_flag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp; --NEW
306: l_sort_var_tbl PA_PLSQL_DATATYPES.NumTabTyp;
307: l_source_tbl PA_PLSQL_DATATYPES.Char25TabTyp;
308: l_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
309: l_trx_type_tbl PA_PLSQL_DATATYPES.Char25TabTyp;
310: l_txn_rej_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
311: l_txn_src_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
304: l_record_type_tbl PA_PLSQL_DATATYPES.CHAR20TabTyp;
305: l_reversal_flag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp; --NEW
306: l_sort_var_tbl PA_PLSQL_DATATYPES.NumTabTyp;
307: l_source_tbl PA_PLSQL_DATATYPES.Char25TabTyp;
308: l_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
309: l_trx_type_tbl PA_PLSQL_DATATYPES.Char25TabTyp;
310: l_txn_rej_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
311: l_txn_src_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
312: l_txn_status_code_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
305: l_reversal_flag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp; --NEW
306: l_sort_var_tbl PA_PLSQL_DATATYPES.NumTabTyp;
307: l_source_tbl PA_PLSQL_DATATYPES.Char25TabTyp;
308: l_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
309: l_trx_type_tbl PA_PLSQL_DATATYPES.Char25TabTyp;
310: l_txn_rej_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
311: l_txn_src_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
312: l_txn_status_code_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
313: l_user_txn_src_tbl PA_PLSQL_DATATYPES.Char80TabTyp;
306: l_sort_var_tbl PA_PLSQL_DATATYPES.NumTabTyp;
307: l_source_tbl PA_PLSQL_DATATYPES.Char25TabTyp;
308: l_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
309: l_trx_type_tbl PA_PLSQL_DATATYPES.Char25TabTyp;
310: l_txn_rej_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
311: l_txn_src_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
312: l_txn_status_code_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
313: l_user_txn_src_tbl PA_PLSQL_DATATYPES.Char80TabTyp;
314: l_vendor_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
307: l_source_tbl PA_PLSQL_DATATYPES.Char25TabTyp;
308: l_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
309: l_trx_type_tbl PA_PLSQL_DATATYPES.Char25TabTyp;
310: l_txn_rej_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
311: l_txn_src_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
312: l_txn_status_code_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
313: l_user_txn_src_tbl PA_PLSQL_DATATYPES.Char80TabTyp;
314: l_vendor_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
315: l_si_assts_add_flg_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
308: l_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
309: l_trx_type_tbl PA_PLSQL_DATATYPES.Char25TabTyp;
310: l_txn_rej_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
311: l_txn_src_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
312: l_txn_status_code_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
313: l_user_txn_src_tbl PA_PLSQL_DATATYPES.Char80TabTyp;
314: l_vendor_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
315: l_si_assts_add_flg_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
316: l_mrc_exchange_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
309: l_trx_type_tbl PA_PLSQL_DATATYPES.Char25TabTyp;
310: l_txn_rej_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
311: l_txn_src_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
312: l_txn_status_code_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
313: l_user_txn_src_tbl PA_PLSQL_DATATYPES.Char80TabTyp;
314: l_vendor_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
315: l_si_assts_add_flg_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
316: l_mrc_exchange_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
317: l_payment_status_flag_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
310: l_txn_rej_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
311: l_txn_src_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
312: l_txn_status_code_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
313: l_user_txn_src_tbl PA_PLSQL_DATATYPES.Char80TabTyp;
314: l_vendor_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
315: l_si_assts_add_flg_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
316: l_mrc_exchange_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
317: l_payment_status_flag_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
318: l_net_zero_flag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;--NEW
311: l_txn_src_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
312: l_txn_status_code_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
313: l_user_txn_src_tbl PA_PLSQL_DATATYPES.Char80TabTyp;
314: l_vendor_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
315: l_si_assts_add_flg_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
316: l_mrc_exchange_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
317: l_payment_status_flag_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
318: l_net_zero_flag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;--NEW
319: l_sc_xfer_code_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;--NEW
312: l_txn_status_code_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
313: l_user_txn_src_tbl PA_PLSQL_DATATYPES.Char80TabTyp;
314: l_vendor_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
315: l_si_assts_add_flg_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
316: l_mrc_exchange_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
317: l_payment_status_flag_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
318: l_net_zero_flag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;--NEW
319: l_sc_xfer_code_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;--NEW
320: l_rcv_sub_ledger_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
313: l_user_txn_src_tbl PA_PLSQL_DATATYPES.Char80TabTyp;
314: l_vendor_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
315: l_si_assts_add_flg_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
316: l_mrc_exchange_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
317: l_payment_status_flag_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
318: l_net_zero_flag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;--NEW
319: l_sc_xfer_code_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;--NEW
320: l_rcv_sub_ledger_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
321: l_rev_parent_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
314: l_vendor_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
315: l_si_assts_add_flg_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
316: l_mrc_exchange_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
317: l_payment_status_flag_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
318: l_net_zero_flag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;--NEW
319: l_sc_xfer_code_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;--NEW
320: l_rcv_sub_ledger_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
321: l_rev_parent_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
322: l_rev_child_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
315: l_si_assts_add_flg_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
316: l_mrc_exchange_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
317: l_payment_status_flag_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
318: l_net_zero_flag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;--NEW
319: l_sc_xfer_code_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;--NEW
320: l_rcv_sub_ledger_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
321: l_rev_parent_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
322: l_rev_child_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
323: l_rev_parent_dist_ind_tbl PA_PLSQL_DATATYPES.IdTabTyp;
316: l_mrc_exchange_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
317: l_payment_status_flag_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
318: l_net_zero_flag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;--NEW
319: l_sc_xfer_code_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;--NEW
320: l_rcv_sub_ledger_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
321: l_rev_parent_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
322: l_rev_child_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
323: l_rev_parent_dist_ind_tbl PA_PLSQL_DATATYPES.IdTabTyp;
324: l_hist_flag_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
317: l_payment_status_flag_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
318: l_net_zero_flag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;--NEW
319: l_sc_xfer_code_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;--NEW
320: l_rcv_sub_ledger_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
321: l_rev_parent_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
322: l_rev_child_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
323: l_rev_parent_dist_ind_tbl PA_PLSQL_DATATYPES.IdTabTyp;
324: l_hist_flag_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
325: l_prepay_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
318: l_net_zero_flag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;--NEW
319: l_sc_xfer_code_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;--NEW
320: l_rcv_sub_ledger_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
321: l_rev_parent_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
322: l_rev_child_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
323: l_rev_parent_dist_ind_tbl PA_PLSQL_DATATYPES.IdTabTyp;
324: l_hist_flag_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
325: l_prepay_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
326: l_pay_hist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
319: l_sc_xfer_code_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;--NEW
320: l_rcv_sub_ledger_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
321: l_rev_parent_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
322: l_rev_child_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
323: l_rev_parent_dist_ind_tbl PA_PLSQL_DATATYPES.IdTabTyp;
324: l_hist_flag_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
325: l_prepay_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
326: l_pay_hist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
327: l_exp_cst_rt_flg_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;--NEW
320: l_rcv_sub_ledger_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
321: l_rev_parent_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
322: l_rev_child_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
323: l_rev_parent_dist_ind_tbl PA_PLSQL_DATATYPES.IdTabTyp;
324: l_hist_flag_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
325: l_prepay_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
326: l_pay_hist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
327: l_exp_cst_rt_flg_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;--NEW
328: l_po_tax_qty_tbl PA_PLSQL_DATATYPES.NumTabTyp;
321: l_rev_parent_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
322: l_rev_child_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
323: l_rev_parent_dist_ind_tbl PA_PLSQL_DATATYPES.IdTabTyp;
324: l_hist_flag_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
325: l_prepay_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
326: l_pay_hist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
327: l_exp_cst_rt_flg_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;--NEW
328: l_po_tax_qty_tbl PA_PLSQL_DATATYPES.NumTabTyp;
329: /* Fixed value global variables */
322: l_rev_child_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
323: l_rev_parent_dist_ind_tbl PA_PLSQL_DATATYPES.IdTabTyp;
324: l_hist_flag_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
325: l_prepay_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
326: l_pay_hist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
327: l_exp_cst_rt_flg_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;--NEW
328: l_po_tax_qty_tbl PA_PLSQL_DATATYPES.NumTabTyp;
329: /* Fixed value global variables */
330: G_OUTPUT_SQLPLUS NUMBER := 1;
323: l_rev_parent_dist_ind_tbl PA_PLSQL_DATATYPES.IdTabTyp;
324: l_hist_flag_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
325: l_prepay_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
326: l_pay_hist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
327: l_exp_cst_rt_flg_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;--NEW
328: l_po_tax_qty_tbl PA_PLSQL_DATATYPES.NumTabTyp;
329: /* Fixed value global variables */
330: G_OUTPUT_SQLPLUS NUMBER := 1;
331: G_OUTPUT_PADEBUG NUMBER := 2;
324: l_hist_flag_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
325: l_prepay_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
326: l_pay_hist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
327: l_exp_cst_rt_flg_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;--NEW
328: l_po_tax_qty_tbl PA_PLSQL_DATATYPES.NumTabTyp;
329: /* Fixed value global variables */
330: G_OUTPUT_SQLPLUS NUMBER := 1;
331: G_OUTPUT_PADEBUG NUMBER := 2;
332: G_OUTPUT_FND NUMBER := 3;