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