[Home] [Help]
39: tl_for_rl VARCHAR2(1),
40: tl_for_fl VARCHAR2(1) );
41: --}
42:
43: g_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
44:
45: PROCEDURE localdebug(p_txt IN VARCHAR2);
46:
47: PROCEDURE display_ra_ar_gt
196: -- Structure to keep the input amount and the output amount of the proration
197: --
198: TYPE pro_res_tbl_type IS RECORD
199: ( -- Groupe
200: GROUPE DBMS_SQL.VARCHAR2_TABLE,
201: -- Base
202: -- ADJ and APP
203: base_pro_amt DBMS_SQL.NUMBER_TABLE,
204: base_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
199: ( -- Groupe
200: GROUPE DBMS_SQL.VARCHAR2_TABLE,
201: -- Base
202: -- ADJ and APP
203: base_pro_amt DBMS_SQL.NUMBER_TABLE,
204: base_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
205: BASE_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
206: BASE_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
207: base_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
200: GROUPE DBMS_SQL.VARCHAR2_TABLE,
201: -- Base
202: -- ADJ and APP
203: base_pro_amt DBMS_SQL.NUMBER_TABLE,
204: base_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
205: BASE_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
206: BASE_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
207: base_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
208: base_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
201: -- Base
202: -- ADJ and APP
203: base_pro_amt DBMS_SQL.NUMBER_TABLE,
204: base_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
205: BASE_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
206: BASE_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
207: base_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
208: base_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
209: base_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
202: -- ADJ and APP
203: base_pro_amt DBMS_SQL.NUMBER_TABLE,
204: base_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
205: BASE_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
206: BASE_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
207: base_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
208: base_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
209: base_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
210: base_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
203: base_pro_amt DBMS_SQL.NUMBER_TABLE,
204: base_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
205: BASE_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
206: BASE_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
207: base_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
208: base_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
209: base_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
210: base_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
211: -- ED
204: base_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
205: BASE_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
206: BASE_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
207: base_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
208: base_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
209: base_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
210: base_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
211: -- ED
212: base_ed_pro_amt DBMS_SQL.NUMBER_TABLE,
205: BASE_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
206: BASE_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
207: base_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
208: base_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
209: base_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
210: base_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
211: -- ED
212: base_ed_pro_amt DBMS_SQL.NUMBER_TABLE,
213: base_ed_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
206: BASE_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
207: base_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
208: base_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
209: base_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
210: base_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
211: -- ED
212: base_ed_pro_amt DBMS_SQL.NUMBER_TABLE,
213: base_ed_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
214: BASE_ed_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
208: base_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
209: base_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
210: base_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
211: -- ED
212: base_ed_pro_amt DBMS_SQL.NUMBER_TABLE,
213: base_ed_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
214: BASE_ed_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
215: BASE_ed_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
216: base_ed_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
209: base_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
210: base_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
211: -- ED
212: base_ed_pro_amt DBMS_SQL.NUMBER_TABLE,
213: base_ed_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
214: BASE_ed_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
215: BASE_ed_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
216: base_ed_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
217: base_ed_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
210: base_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
211: -- ED
212: base_ed_pro_amt DBMS_SQL.NUMBER_TABLE,
213: base_ed_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
214: BASE_ed_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
215: BASE_ed_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
216: base_ed_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
217: base_ed_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
218: base_ed_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
211: -- ED
212: base_ed_pro_amt DBMS_SQL.NUMBER_TABLE,
213: base_ed_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
214: BASE_ed_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
215: BASE_ed_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
216: base_ed_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
217: base_ed_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
218: base_ed_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
219: base_ed_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
212: base_ed_pro_amt DBMS_SQL.NUMBER_TABLE,
213: base_ed_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
214: BASE_ed_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
215: BASE_ed_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
216: base_ed_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
217: base_ed_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
218: base_ed_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
219: base_ed_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
220: -- UNED
213: base_ed_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
214: BASE_ed_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
215: BASE_ed_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
216: base_ed_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
217: base_ed_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
218: base_ed_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
219: base_ed_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
220: -- UNED
221: base_uned_pro_amt DBMS_SQL.NUMBER_TABLE,
214: BASE_ed_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
215: BASE_ed_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
216: base_ed_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
217: base_ed_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
218: base_ed_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
219: base_ed_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
220: -- UNED
221: base_uned_pro_amt DBMS_SQL.NUMBER_TABLE,
222: base_uned_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
215: BASE_ed_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
216: base_ed_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
217: base_ed_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
218: base_ed_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
219: base_ed_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
220: -- UNED
221: base_uned_pro_amt DBMS_SQL.NUMBER_TABLE,
222: base_uned_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
223: BASE_uned_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
217: base_ed_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
218: base_ed_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
219: base_ed_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
220: -- UNED
221: base_uned_pro_amt DBMS_SQL.NUMBER_TABLE,
222: base_uned_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
223: BASE_uned_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
224: BASE_uned_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
225: base_uned_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
218: base_ed_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
219: base_ed_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
220: -- UNED
221: base_uned_pro_amt DBMS_SQL.NUMBER_TABLE,
222: base_uned_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
223: BASE_uned_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
224: BASE_uned_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
225: base_uned_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
226: base_uned_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
219: base_ed_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
220: -- UNED
221: base_uned_pro_amt DBMS_SQL.NUMBER_TABLE,
222: base_uned_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
223: BASE_uned_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
224: BASE_uned_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
225: base_uned_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
226: base_uned_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
227: base_uned_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
220: -- UNED
221: base_uned_pro_amt DBMS_SQL.NUMBER_TABLE,
222: base_uned_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
223: BASE_uned_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
224: BASE_uned_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
225: base_uned_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
226: base_uned_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
227: base_uned_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
228: base_uned_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
221: base_uned_pro_amt DBMS_SQL.NUMBER_TABLE,
222: base_uned_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
223: BASE_uned_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
224: BASE_uned_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
225: base_uned_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
226: base_uned_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
227: base_uned_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
228: base_uned_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
229: -- Element numerator
222: base_uned_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
223: BASE_uned_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
224: BASE_uned_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
225: base_uned_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
226: base_uned_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
227: base_uned_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
228: base_uned_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
229: -- Element numerator
230: -- ADJ and APP
223: BASE_uned_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
224: BASE_uned_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
225: base_uned_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
226: base_uned_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
227: base_uned_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
228: base_uned_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
229: -- Element numerator
230: -- ADJ and APP
231: elmt_pro_amt DBMS_SQL.NUMBER_TABLE,
224: BASE_uned_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
225: base_uned_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
226: base_uned_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
227: base_uned_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
228: base_uned_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
229: -- Element numerator
230: -- ADJ and APP
231: elmt_pro_amt DBMS_SQL.NUMBER_TABLE,
232: elmt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
227: base_uned_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
228: base_uned_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
229: -- Element numerator
230: -- ADJ and APP
231: elmt_pro_amt DBMS_SQL.NUMBER_TABLE,
232: elmt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
233: ELMT_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
234: ELMT_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
235: elmt_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
228: base_uned_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
229: -- Element numerator
230: -- ADJ and APP
231: elmt_pro_amt DBMS_SQL.NUMBER_TABLE,
232: elmt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
233: ELMT_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
234: ELMT_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
235: elmt_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
236: elmt_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
229: -- Element numerator
230: -- ADJ and APP
231: elmt_pro_amt DBMS_SQL.NUMBER_TABLE,
232: elmt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
233: ELMT_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
234: ELMT_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
235: elmt_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
236: elmt_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
237: elmt_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
230: -- ADJ and APP
231: elmt_pro_amt DBMS_SQL.NUMBER_TABLE,
232: elmt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
233: ELMT_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
234: ELMT_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
235: elmt_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
236: elmt_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
237: elmt_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
238: elmt_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
231: elmt_pro_amt DBMS_SQL.NUMBER_TABLE,
232: elmt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
233: ELMT_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
234: ELMT_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
235: elmt_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
236: elmt_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
237: elmt_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
238: elmt_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
239: -- ED
232: elmt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
233: ELMT_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
234: ELMT_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
235: elmt_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
236: elmt_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
237: elmt_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
238: elmt_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
239: -- ED
240: elmt_ed_pro_amt DBMS_SQL.NUMBER_TABLE,
233: ELMT_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
234: ELMT_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
235: elmt_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
236: elmt_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
237: elmt_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
238: elmt_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
239: -- ED
240: elmt_ed_pro_amt DBMS_SQL.NUMBER_TABLE,
241: elmt_ed_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
234: ELMT_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
235: elmt_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
236: elmt_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
237: elmt_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
238: elmt_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
239: -- ED
240: elmt_ed_pro_amt DBMS_SQL.NUMBER_TABLE,
241: elmt_ed_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
242: ELMT_ed_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
236: elmt_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
237: elmt_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
238: elmt_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
239: -- ED
240: elmt_ed_pro_amt DBMS_SQL.NUMBER_TABLE,
241: elmt_ed_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
242: ELMT_ed_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
243: ELMT_ed_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
244: elmt_ed_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
237: elmt_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
238: elmt_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
239: -- ED
240: elmt_ed_pro_amt DBMS_SQL.NUMBER_TABLE,
241: elmt_ed_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
242: ELMT_ed_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
243: ELMT_ed_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
244: elmt_ed_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
245: elmt_ed_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
238: elmt_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
239: -- ED
240: elmt_ed_pro_amt DBMS_SQL.NUMBER_TABLE,
241: elmt_ed_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
242: ELMT_ed_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
243: ELMT_ed_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
244: elmt_ed_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
245: elmt_ed_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
246: elmt_ed_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
239: -- ED
240: elmt_ed_pro_amt DBMS_SQL.NUMBER_TABLE,
241: elmt_ed_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
242: ELMT_ed_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
243: ELMT_ed_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
244: elmt_ed_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
245: elmt_ed_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
246: elmt_ed_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
247: elmt_ed_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
240: elmt_ed_pro_amt DBMS_SQL.NUMBER_TABLE,
241: elmt_ed_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
242: ELMT_ed_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
243: ELMT_ed_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
244: elmt_ed_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
245: elmt_ed_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
246: elmt_ed_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
247: elmt_ed_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
248: -- UNED
241: elmt_ed_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
242: ELMT_ed_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
243: ELMT_ed_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
244: elmt_ed_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
245: elmt_ed_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
246: elmt_ed_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
247: elmt_ed_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
248: -- UNED
249: elmt_uned_pro_amt DBMS_SQL.NUMBER_TABLE,
242: ELMT_ed_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
243: ELMT_ed_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
244: elmt_ed_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
245: elmt_ed_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
246: elmt_ed_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
247: elmt_ed_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
248: -- UNED
249: elmt_uned_pro_amt DBMS_SQL.NUMBER_TABLE,
250: elmt_uned_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
243: ELMT_ed_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
244: elmt_ed_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
245: elmt_ed_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
246: elmt_ed_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
247: elmt_ed_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
248: -- UNED
249: elmt_uned_pro_amt DBMS_SQL.NUMBER_TABLE,
250: elmt_uned_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
251: ELMT_uned_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
245: elmt_ed_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
246: elmt_ed_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
247: elmt_ed_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
248: -- UNED
249: elmt_uned_pro_amt DBMS_SQL.NUMBER_TABLE,
250: elmt_uned_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
251: ELMT_uned_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
252: ELMT_uned_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
253: elmt_uned_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
246: elmt_ed_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
247: elmt_ed_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
248: -- UNED
249: elmt_uned_pro_amt DBMS_SQL.NUMBER_TABLE,
250: elmt_uned_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
251: ELMT_uned_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
252: ELMT_uned_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
253: elmt_uned_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
254: elmt_uned_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
247: elmt_ed_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
248: -- UNED
249: elmt_uned_pro_amt DBMS_SQL.NUMBER_TABLE,
250: elmt_uned_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
251: ELMT_uned_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
252: ELMT_uned_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
253: elmt_uned_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
254: elmt_uned_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
255: elmt_uned_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
248: -- UNED
249: elmt_uned_pro_amt DBMS_SQL.NUMBER_TABLE,
250: elmt_uned_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
251: ELMT_uned_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
252: ELMT_uned_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
253: elmt_uned_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
254: elmt_uned_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
255: elmt_uned_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
256: elmt_uned_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
249: elmt_uned_pro_amt DBMS_SQL.NUMBER_TABLE,
250: elmt_uned_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
251: ELMT_uned_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
252: ELMT_uned_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
253: elmt_uned_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
254: elmt_uned_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
255: elmt_uned_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
256: elmt_uned_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
257: -- Amount to be allocated -- ADJ and APP
250: elmt_uned_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
251: ELMT_uned_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
252: ELMT_uned_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
253: elmt_uned_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
254: elmt_uned_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
255: elmt_uned_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
256: elmt_uned_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
257: -- Amount to be allocated -- ADJ and APP
258: buc_alloc_amt DBMS_SQL.NUMBER_TABLE,
251: ELMT_uned_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
252: ELMT_uned_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
253: elmt_uned_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
254: elmt_uned_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
255: elmt_uned_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
256: elmt_uned_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
257: -- Amount to be allocated -- ADJ and APP
258: buc_alloc_amt DBMS_SQL.NUMBER_TABLE,
259: buc_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
252: ELMT_uned_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
253: elmt_uned_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
254: elmt_uned_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
255: elmt_uned_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
256: elmt_uned_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
257: -- Amount to be allocated -- ADJ and APP
258: buc_alloc_amt DBMS_SQL.NUMBER_TABLE,
259: buc_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
260: buc_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
254: elmt_uned_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
255: elmt_uned_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
256: elmt_uned_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
257: -- Amount to be allocated -- ADJ and APP
258: buc_alloc_amt DBMS_SQL.NUMBER_TABLE,
259: buc_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
260: buc_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
261: buc_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
262: buc_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
255: elmt_uned_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
256: elmt_uned_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
257: -- Amount to be allocated -- ADJ and APP
258: buc_alloc_amt DBMS_SQL.NUMBER_TABLE,
259: buc_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
260: buc_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
261: buc_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
262: buc_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
263: buc_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
256: elmt_uned_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
257: -- Amount to be allocated -- ADJ and APP
258: buc_alloc_amt DBMS_SQL.NUMBER_TABLE,
259: buc_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
260: buc_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
261: buc_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
262: buc_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
263: buc_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
264: buc_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
257: -- Amount to be allocated -- ADJ and APP
258: buc_alloc_amt DBMS_SQL.NUMBER_TABLE,
259: buc_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
260: buc_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
261: buc_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
262: buc_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
263: buc_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
264: buc_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
265: buc_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
258: buc_alloc_amt DBMS_SQL.NUMBER_TABLE,
259: buc_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
260: buc_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
261: buc_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
262: buc_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
263: buc_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
264: buc_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
265: buc_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
266: -- ED
259: buc_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
260: buc_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
261: buc_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
262: buc_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
263: buc_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
264: buc_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
265: buc_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
266: -- ED
267: buc_ed_alloc_amt DBMS_SQL.NUMBER_TABLE,
260: buc_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
261: buc_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
262: buc_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
263: buc_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
264: buc_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
265: buc_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
266: -- ED
267: buc_ed_alloc_amt DBMS_SQL.NUMBER_TABLE,
268: buc_ed_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
261: buc_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
262: buc_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
263: buc_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
264: buc_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
265: buc_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
266: -- ED
267: buc_ed_alloc_amt DBMS_SQL.NUMBER_TABLE,
268: buc_ed_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
269: buc_ed_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
263: buc_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
264: buc_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
265: buc_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
266: -- ED
267: buc_ed_alloc_amt DBMS_SQL.NUMBER_TABLE,
268: buc_ed_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
269: buc_ed_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
270: buc_ed_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
271: buc_ed_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
264: buc_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
265: buc_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
266: -- ED
267: buc_ed_alloc_amt DBMS_SQL.NUMBER_TABLE,
268: buc_ed_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
269: buc_ed_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
270: buc_ed_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
271: buc_ed_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
272: buc_ed_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
265: buc_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
266: -- ED
267: buc_ed_alloc_amt DBMS_SQL.NUMBER_TABLE,
268: buc_ed_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
269: buc_ed_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
270: buc_ed_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
271: buc_ed_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
272: buc_ed_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
273: buc_ed_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
266: -- ED
267: buc_ed_alloc_amt DBMS_SQL.NUMBER_TABLE,
268: buc_ed_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
269: buc_ed_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
270: buc_ed_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
271: buc_ed_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
272: buc_ed_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
273: buc_ed_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
274: buc_ed_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
267: buc_ed_alloc_amt DBMS_SQL.NUMBER_TABLE,
268: buc_ed_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
269: buc_ed_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
270: buc_ed_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
271: buc_ed_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
272: buc_ed_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
273: buc_ed_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
274: buc_ed_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
275: -- UNED
268: buc_ed_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
269: buc_ed_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
270: buc_ed_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
271: buc_ed_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
272: buc_ed_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
273: buc_ed_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
274: buc_ed_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
275: -- UNED
276: buc_uned_alloc_amt DBMS_SQL.NUMBER_TABLE,
269: buc_ed_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
270: buc_ed_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
271: buc_ed_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
272: buc_ed_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
273: buc_ed_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
274: buc_ed_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
275: -- UNED
276: buc_uned_alloc_amt DBMS_SQL.NUMBER_TABLE,
277: buc_uned_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
270: buc_ed_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
271: buc_ed_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
272: buc_ed_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
273: buc_ed_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
274: buc_ed_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
275: -- UNED
276: buc_uned_alloc_amt DBMS_SQL.NUMBER_TABLE,
277: buc_uned_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
278: buc_uned_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
272: buc_ed_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
273: buc_ed_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
274: buc_ed_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
275: -- UNED
276: buc_uned_alloc_amt DBMS_SQL.NUMBER_TABLE,
277: buc_uned_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
278: buc_uned_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
279: buc_uned_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
280: buc_uned_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
273: buc_ed_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
274: buc_ed_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
275: -- UNED
276: buc_uned_alloc_amt DBMS_SQL.NUMBER_TABLE,
277: buc_uned_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
278: buc_uned_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
279: buc_uned_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
280: buc_uned_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
281: buc_uned_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
274: buc_ed_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
275: -- UNED
276: buc_uned_alloc_amt DBMS_SQL.NUMBER_TABLE,
277: buc_uned_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
278: buc_uned_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
279: buc_uned_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
280: buc_uned_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
281: buc_uned_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
282: buc_uned_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
275: -- UNED
276: buc_uned_alloc_amt DBMS_SQL.NUMBER_TABLE,
277: buc_uned_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
278: buc_uned_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
279: buc_uned_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
280: buc_uned_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
281: buc_uned_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
282: buc_uned_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
283: buc_uned_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
276: buc_uned_alloc_amt DBMS_SQL.NUMBER_TABLE,
277: buc_uned_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
278: buc_uned_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
279: buc_uned_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
280: buc_uned_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
281: buc_uned_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
282: buc_uned_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
283: buc_uned_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
284: -- Currency
277: buc_uned_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
278: buc_uned_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
279: buc_uned_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
280: buc_uned_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
281: buc_uned_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
282: buc_uned_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
283: buc_uned_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
284: -- Currency
285: FROM_CURRENCY DBMS_SQL.VARCHAR2_TABLE,
278: buc_uned_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
279: buc_uned_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
280: buc_uned_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
281: buc_uned_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
282: buc_uned_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
283: buc_uned_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
284: -- Currency
285: FROM_CURRENCY DBMS_SQL.VARCHAR2_TABLE,
286: TO_CURRENCY DBMS_SQL.VARCHAR2_TABLE,
279: buc_uned_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
280: buc_uned_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
281: buc_uned_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
282: buc_uned_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
283: buc_uned_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
284: -- Currency
285: FROM_CURRENCY DBMS_SQL.VARCHAR2_TABLE,
286: TO_CURRENCY DBMS_SQL.VARCHAR2_TABLE,
287: BASE_CURRENCY DBMS_SQL.VARCHAR2_TABLE,
281: buc_uned_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
282: buc_uned_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
283: buc_uned_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
284: -- Currency
285: FROM_CURRENCY DBMS_SQL.VARCHAR2_TABLE,
286: TO_CURRENCY DBMS_SQL.VARCHAR2_TABLE,
287: BASE_CURRENCY DBMS_SQL.VARCHAR2_TABLE,
288: -- Result of the allocation
289: -- ADJ and APP
282: buc_uned_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
283: buc_uned_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
284: -- Currency
285: FROM_CURRENCY DBMS_SQL.VARCHAR2_TABLE,
286: TO_CURRENCY DBMS_SQL.VARCHAR2_TABLE,
287: BASE_CURRENCY DBMS_SQL.VARCHAR2_TABLE,
288: -- Result of the allocation
289: -- ADJ and APP
290: tl_alloc_amt DBMS_SQL.NUMBER_TABLE,
283: buc_uned_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
284: -- Currency
285: FROM_CURRENCY DBMS_SQL.VARCHAR2_TABLE,
286: TO_CURRENCY DBMS_SQL.VARCHAR2_TABLE,
287: BASE_CURRENCY DBMS_SQL.VARCHAR2_TABLE,
288: -- Result of the allocation
289: -- ADJ and APP
290: tl_alloc_amt DBMS_SQL.NUMBER_TABLE,
291: tl_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
286: TO_CURRENCY DBMS_SQL.VARCHAR2_TABLE,
287: BASE_CURRENCY DBMS_SQL.VARCHAR2_TABLE,
288: -- Result of the allocation
289: -- ADJ and APP
290: tl_alloc_amt DBMS_SQL.NUMBER_TABLE,
291: tl_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
292: tl_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
293: tl_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
294: tl_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
287: BASE_CURRENCY DBMS_SQL.VARCHAR2_TABLE,
288: -- Result of the allocation
289: -- ADJ and APP
290: tl_alloc_amt DBMS_SQL.NUMBER_TABLE,
291: tl_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
292: tl_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
293: tl_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
294: tl_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
295: tl_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
288: -- Result of the allocation
289: -- ADJ and APP
290: tl_alloc_amt DBMS_SQL.NUMBER_TABLE,
291: tl_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
292: tl_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
293: tl_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
294: tl_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
295: tl_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
296: tl_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
289: -- ADJ and APP
290: tl_alloc_amt DBMS_SQL.NUMBER_TABLE,
291: tl_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
292: tl_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
293: tl_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
294: tl_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
295: tl_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
296: tl_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
297: tl_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
290: tl_alloc_amt DBMS_SQL.NUMBER_TABLE,
291: tl_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
292: tl_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
293: tl_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
294: tl_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
295: tl_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
296: tl_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
297: tl_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
298: -- ED
291: tl_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
292: tl_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
293: tl_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
294: tl_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
295: tl_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
296: tl_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
297: tl_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
298: -- ED
299: tl_ed_alloc_amt DBMS_SQL.NUMBER_TABLE,
292: tl_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
293: tl_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
294: tl_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
295: tl_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
296: tl_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
297: tl_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
298: -- ED
299: tl_ed_alloc_amt DBMS_SQL.NUMBER_TABLE,
300: tl_ed_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
293: tl_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
294: tl_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
295: tl_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
296: tl_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
297: tl_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
298: -- ED
299: tl_ed_alloc_amt DBMS_SQL.NUMBER_TABLE,
300: tl_ed_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
301: tl_ed_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
295: tl_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
296: tl_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
297: tl_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
298: -- ED
299: tl_ed_alloc_amt DBMS_SQL.NUMBER_TABLE,
300: tl_ed_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
301: tl_ed_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
302: tl_ed_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
303: tl_ed_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
296: tl_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
297: tl_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
298: -- ED
299: tl_ed_alloc_amt DBMS_SQL.NUMBER_TABLE,
300: tl_ed_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
301: tl_ed_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
302: tl_ed_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
303: tl_ed_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
304: tl_ed_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
297: tl_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
298: -- ED
299: tl_ed_alloc_amt DBMS_SQL.NUMBER_TABLE,
300: tl_ed_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
301: tl_ed_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
302: tl_ed_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
303: tl_ed_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
304: tl_ed_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
305: tl_ed_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
298: -- ED
299: tl_ed_alloc_amt DBMS_SQL.NUMBER_TABLE,
300: tl_ed_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
301: tl_ed_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
302: tl_ed_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
303: tl_ed_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
304: tl_ed_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
305: tl_ed_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
306: tl_ed_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
299: tl_ed_alloc_amt DBMS_SQL.NUMBER_TABLE,
300: tl_ed_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
301: tl_ed_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
302: tl_ed_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
303: tl_ed_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
304: tl_ed_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
305: tl_ed_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
306: tl_ed_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
307: -- UNED
300: tl_ed_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
301: tl_ed_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
302: tl_ed_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
303: tl_ed_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
304: tl_ed_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
305: tl_ed_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
306: tl_ed_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
307: -- UNED
308: tl_uned_alloc_amt DBMS_SQL.NUMBER_TABLE,
301: tl_ed_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
302: tl_ed_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
303: tl_ed_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
304: tl_ed_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
305: tl_ed_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
306: tl_ed_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
307: -- UNED
308: tl_uned_alloc_amt DBMS_SQL.NUMBER_TABLE,
309: tl_uned_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
302: tl_ed_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
303: tl_ed_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
304: tl_ed_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
305: tl_ed_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
306: tl_ed_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
307: -- UNED
308: tl_uned_alloc_amt DBMS_SQL.NUMBER_TABLE,
309: tl_uned_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
310: tl_uned_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
304: tl_ed_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
305: tl_ed_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
306: tl_ed_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
307: -- UNED
308: tl_uned_alloc_amt DBMS_SQL.NUMBER_TABLE,
309: tl_uned_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
310: tl_uned_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
311: tl_uned_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
312: tl_uned_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
305: tl_ed_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
306: tl_ed_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
307: -- UNED
308: tl_uned_alloc_amt DBMS_SQL.NUMBER_TABLE,
309: tl_uned_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
310: tl_uned_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
311: tl_uned_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
312: tl_uned_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
313: tl_uned_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
306: tl_ed_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
307: -- UNED
308: tl_uned_alloc_amt DBMS_SQL.NUMBER_TABLE,
309: tl_uned_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
310: tl_uned_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
311: tl_uned_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
312: tl_uned_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
313: tl_uned_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
314: tl_uned_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
307: -- UNED
308: tl_uned_alloc_amt DBMS_SQL.NUMBER_TABLE,
309: tl_uned_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
310: tl_uned_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
311: tl_uned_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
312: tl_uned_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
313: tl_uned_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
314: tl_uned_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
315: tl_uned_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
308: tl_uned_alloc_amt DBMS_SQL.NUMBER_TABLE,
309: tl_uned_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
310: tl_uned_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
311: tl_uned_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
312: tl_uned_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
313: tl_uned_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
314: tl_uned_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
315: tl_uned_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
316: --
309: tl_uned_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
310: tl_uned_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
311: tl_uned_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
312: tl_uned_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
313: tl_uned_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
314: tl_uned_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
315: tl_uned_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
316: --
317: ROWID_ID DBMS_SQL.VARCHAR2_TABLE,
310: tl_uned_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
311: tl_uned_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
312: tl_uned_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
313: tl_uned_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
314: tl_uned_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
315: tl_uned_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
316: --
317: ROWID_ID DBMS_SQL.VARCHAR2_TABLE,
318: line_type DBMS_SQL.VARCHAR2_TABLE);
311: tl_uned_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
312: tl_uned_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
313: tl_uned_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
314: tl_uned_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
315: tl_uned_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
316: --
317: ROWID_ID DBMS_SQL.VARCHAR2_TABLE,
318: line_type DBMS_SQL.VARCHAR2_TABLE);
319:
313: tl_uned_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
314: tl_uned_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
315: tl_uned_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
316: --
317: ROWID_ID DBMS_SQL.VARCHAR2_TABLE,
318: line_type DBMS_SQL.VARCHAR2_TABLE);
319:
320: --
321: -- Internal structure for safety on proration
314: tl_uned_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
315: tl_uned_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
316: --
317: ROWID_ID DBMS_SQL.VARCHAR2_TABLE,
318: line_type DBMS_SQL.VARCHAR2_TABLE);
319:
320: --
321: -- Internal structure for safety on proration
322: --
320: --
321: -- Internal structure for safety on proration
322: --
323: TYPE group_tbl_type IS RECORD
324: ( GROUPE DBMS_SQL.VARCHAR2_TABLE,
325: -- ADJ and APP
326: RUN_ALLOC DBMS_SQL.NUMBER_TABLE,
327: RUN_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
328: RUN_AMT DBMS_SQL.NUMBER_TABLE,
322: --
323: TYPE group_tbl_type IS RECORD
324: ( GROUPE DBMS_SQL.VARCHAR2_TABLE,
325: -- ADJ and APP
326: RUN_ALLOC DBMS_SQL.NUMBER_TABLE,
327: RUN_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
328: RUN_AMT DBMS_SQL.NUMBER_TABLE,
329: RUN_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
330: RUN_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
323: TYPE group_tbl_type IS RECORD
324: ( GROUPE DBMS_SQL.VARCHAR2_TABLE,
325: -- ADJ and APP
326: RUN_ALLOC DBMS_SQL.NUMBER_TABLE,
327: RUN_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
328: RUN_AMT DBMS_SQL.NUMBER_TABLE,
329: RUN_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
330: RUN_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
331: RUN_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
324: ( GROUPE DBMS_SQL.VARCHAR2_TABLE,
325: -- ADJ and APP
326: RUN_ALLOC DBMS_SQL.NUMBER_TABLE,
327: RUN_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
328: RUN_AMT DBMS_SQL.NUMBER_TABLE,
329: RUN_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
330: RUN_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
331: RUN_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
332: RUN_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
325: -- ADJ and APP
326: RUN_ALLOC DBMS_SQL.NUMBER_TABLE,
327: RUN_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
328: RUN_AMT DBMS_SQL.NUMBER_TABLE,
329: RUN_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
330: RUN_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
331: RUN_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
332: RUN_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
333: RUN_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
326: RUN_ALLOC DBMS_SQL.NUMBER_TABLE,
327: RUN_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
328: RUN_AMT DBMS_SQL.NUMBER_TABLE,
329: RUN_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
330: RUN_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
331: RUN_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
332: RUN_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
333: RUN_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
334: RUN_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
327: RUN_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
328: RUN_AMT DBMS_SQL.NUMBER_TABLE,
329: RUN_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
330: RUN_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
331: RUN_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
332: RUN_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
333: RUN_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
334: RUN_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
335: RUN_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
328: RUN_AMT DBMS_SQL.NUMBER_TABLE,
329: RUN_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
330: RUN_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
331: RUN_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
332: RUN_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
333: RUN_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
334: RUN_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
335: RUN_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
336: RUN_FRT_AMT DBMS_SQL.NUMBER_TABLE,
329: RUN_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
330: RUN_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
331: RUN_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
332: RUN_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
333: RUN_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
334: RUN_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
335: RUN_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
336: RUN_FRT_AMT DBMS_SQL.NUMBER_TABLE,
337: RUN_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
330: RUN_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
331: RUN_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
332: RUN_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
333: RUN_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
334: RUN_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
335: RUN_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
336: RUN_FRT_AMT DBMS_SQL.NUMBER_TABLE,
337: RUN_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
338: RUN_TAX_ALLOC DBMS_SQL.NUMBER_TABLE,
331: RUN_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
332: RUN_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
333: RUN_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
334: RUN_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
335: RUN_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
336: RUN_FRT_AMT DBMS_SQL.NUMBER_TABLE,
337: RUN_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
338: RUN_TAX_ALLOC DBMS_SQL.NUMBER_TABLE,
339: RUN_TAX_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
332: RUN_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
333: RUN_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
334: RUN_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
335: RUN_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
336: RUN_FRT_AMT DBMS_SQL.NUMBER_TABLE,
337: RUN_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
338: RUN_TAX_ALLOC DBMS_SQL.NUMBER_TABLE,
339: RUN_TAX_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
340: RUN_TAX_AMT DBMS_SQL.NUMBER_TABLE,
333: RUN_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
334: RUN_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
335: RUN_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
336: RUN_FRT_AMT DBMS_SQL.NUMBER_TABLE,
337: RUN_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
338: RUN_TAX_ALLOC DBMS_SQL.NUMBER_TABLE,
339: RUN_TAX_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
340: RUN_TAX_AMT DBMS_SQL.NUMBER_TABLE,
341: RUN_TAX_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
334: RUN_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
335: RUN_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
336: RUN_FRT_AMT DBMS_SQL.NUMBER_TABLE,
337: RUN_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
338: RUN_TAX_ALLOC DBMS_SQL.NUMBER_TABLE,
339: RUN_TAX_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
340: RUN_TAX_AMT DBMS_SQL.NUMBER_TABLE,
341: RUN_TAX_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
342: -- ED
335: RUN_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
336: RUN_FRT_AMT DBMS_SQL.NUMBER_TABLE,
337: RUN_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
338: RUN_TAX_ALLOC DBMS_SQL.NUMBER_TABLE,
339: RUN_TAX_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
340: RUN_TAX_AMT DBMS_SQL.NUMBER_TABLE,
341: RUN_TAX_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
342: -- ED
343: RUN_ED_ALLOC DBMS_SQL.NUMBER_TABLE,
336: RUN_FRT_AMT DBMS_SQL.NUMBER_TABLE,
337: RUN_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
338: RUN_TAX_ALLOC DBMS_SQL.NUMBER_TABLE,
339: RUN_TAX_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
340: RUN_TAX_AMT DBMS_SQL.NUMBER_TABLE,
341: RUN_TAX_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
342: -- ED
343: RUN_ED_ALLOC DBMS_SQL.NUMBER_TABLE,
344: RUN_ED_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
337: RUN_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
338: RUN_TAX_ALLOC DBMS_SQL.NUMBER_TABLE,
339: RUN_TAX_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
340: RUN_TAX_AMT DBMS_SQL.NUMBER_TABLE,
341: RUN_TAX_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
342: -- ED
343: RUN_ED_ALLOC DBMS_SQL.NUMBER_TABLE,
344: RUN_ED_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
345: RUN_ED_AMT DBMS_SQL.NUMBER_TABLE,
339: RUN_TAX_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
340: RUN_TAX_AMT DBMS_SQL.NUMBER_TABLE,
341: RUN_TAX_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
342: -- ED
343: RUN_ED_ALLOC DBMS_SQL.NUMBER_TABLE,
344: RUN_ED_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
345: RUN_ED_AMT DBMS_SQL.NUMBER_TABLE,
346: RUN_ED_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
347: RUN_ED_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
340: RUN_TAX_AMT DBMS_SQL.NUMBER_TABLE,
341: RUN_TAX_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
342: -- ED
343: RUN_ED_ALLOC DBMS_SQL.NUMBER_TABLE,
344: RUN_ED_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
345: RUN_ED_AMT DBMS_SQL.NUMBER_TABLE,
346: RUN_ED_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
347: RUN_ED_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
348: RUN_ED_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
341: RUN_TAX_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
342: -- ED
343: RUN_ED_ALLOC DBMS_SQL.NUMBER_TABLE,
344: RUN_ED_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
345: RUN_ED_AMT DBMS_SQL.NUMBER_TABLE,
346: RUN_ED_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
347: RUN_ED_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
348: RUN_ED_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
349: RUN_ED_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
342: -- ED
343: RUN_ED_ALLOC DBMS_SQL.NUMBER_TABLE,
344: RUN_ED_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
345: RUN_ED_AMT DBMS_SQL.NUMBER_TABLE,
346: RUN_ED_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
347: RUN_ED_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
348: RUN_ED_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
349: RUN_ED_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
350: RUN_ED_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
343: RUN_ED_ALLOC DBMS_SQL.NUMBER_TABLE,
344: RUN_ED_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
345: RUN_ED_AMT DBMS_SQL.NUMBER_TABLE,
346: RUN_ED_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
347: RUN_ED_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
348: RUN_ED_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
349: RUN_ED_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
350: RUN_ED_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
351: RUN_ED_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
344: RUN_ED_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
345: RUN_ED_AMT DBMS_SQL.NUMBER_TABLE,
346: RUN_ED_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
347: RUN_ED_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
348: RUN_ED_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
349: RUN_ED_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
350: RUN_ED_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
351: RUN_ED_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
352: RUN_ED_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
345: RUN_ED_AMT DBMS_SQL.NUMBER_TABLE,
346: RUN_ED_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
347: RUN_ED_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
348: RUN_ED_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
349: RUN_ED_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
350: RUN_ED_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
351: RUN_ED_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
352: RUN_ED_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
353: RUN_ED_FRT_AMT DBMS_SQL.NUMBER_TABLE,
346: RUN_ED_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
347: RUN_ED_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
348: RUN_ED_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
349: RUN_ED_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
350: RUN_ED_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
351: RUN_ED_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
352: RUN_ED_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
353: RUN_ED_FRT_AMT DBMS_SQL.NUMBER_TABLE,
354: RUN_ED_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
347: RUN_ED_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
348: RUN_ED_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
349: RUN_ED_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
350: RUN_ED_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
351: RUN_ED_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
352: RUN_ED_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
353: RUN_ED_FRT_AMT DBMS_SQL.NUMBER_TABLE,
354: RUN_ED_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
355: RUN_ED_TAX_ALLOC DBMS_SQL.NUMBER_TABLE,
348: RUN_ED_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
349: RUN_ED_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
350: RUN_ED_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
351: RUN_ED_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
352: RUN_ED_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
353: RUN_ED_FRT_AMT DBMS_SQL.NUMBER_TABLE,
354: RUN_ED_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
355: RUN_ED_TAX_ALLOC DBMS_SQL.NUMBER_TABLE,
356: RUN_ED_TAX_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
349: RUN_ED_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
350: RUN_ED_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
351: RUN_ED_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
352: RUN_ED_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
353: RUN_ED_FRT_AMT DBMS_SQL.NUMBER_TABLE,
354: RUN_ED_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
355: RUN_ED_TAX_ALLOC DBMS_SQL.NUMBER_TABLE,
356: RUN_ED_TAX_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
357: RUN_ED_TAX_AMT DBMS_SQL.NUMBER_TABLE,
350: RUN_ED_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
351: RUN_ED_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
352: RUN_ED_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
353: RUN_ED_FRT_AMT DBMS_SQL.NUMBER_TABLE,
354: RUN_ED_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
355: RUN_ED_TAX_ALLOC DBMS_SQL.NUMBER_TABLE,
356: RUN_ED_TAX_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
357: RUN_ED_TAX_AMT DBMS_SQL.NUMBER_TABLE,
358: RUN_ED_TAX_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
351: RUN_ED_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
352: RUN_ED_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
353: RUN_ED_FRT_AMT DBMS_SQL.NUMBER_TABLE,
354: RUN_ED_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
355: RUN_ED_TAX_ALLOC DBMS_SQL.NUMBER_TABLE,
356: RUN_ED_TAX_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
357: RUN_ED_TAX_AMT DBMS_SQL.NUMBER_TABLE,
358: RUN_ED_TAX_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
359: -- UNED
352: RUN_ED_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
353: RUN_ED_FRT_AMT DBMS_SQL.NUMBER_TABLE,
354: RUN_ED_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
355: RUN_ED_TAX_ALLOC DBMS_SQL.NUMBER_TABLE,
356: RUN_ED_TAX_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
357: RUN_ED_TAX_AMT DBMS_SQL.NUMBER_TABLE,
358: RUN_ED_TAX_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
359: -- UNED
360: RUN_UNED_ALLOC DBMS_SQL.NUMBER_TABLE,
353: RUN_ED_FRT_AMT DBMS_SQL.NUMBER_TABLE,
354: RUN_ED_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
355: RUN_ED_TAX_ALLOC DBMS_SQL.NUMBER_TABLE,
356: RUN_ED_TAX_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
357: RUN_ED_TAX_AMT DBMS_SQL.NUMBER_TABLE,
358: RUN_ED_TAX_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
359: -- UNED
360: RUN_UNED_ALLOC DBMS_SQL.NUMBER_TABLE,
361: RUN_UNED_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
354: RUN_ED_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
355: RUN_ED_TAX_ALLOC DBMS_SQL.NUMBER_TABLE,
356: RUN_ED_TAX_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
357: RUN_ED_TAX_AMT DBMS_SQL.NUMBER_TABLE,
358: RUN_ED_TAX_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
359: -- UNED
360: RUN_UNED_ALLOC DBMS_SQL.NUMBER_TABLE,
361: RUN_UNED_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
362: RUN_UNED_AMT DBMS_SQL.NUMBER_TABLE,
356: RUN_ED_TAX_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
357: RUN_ED_TAX_AMT DBMS_SQL.NUMBER_TABLE,
358: RUN_ED_TAX_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
359: -- UNED
360: RUN_UNED_ALLOC DBMS_SQL.NUMBER_TABLE,
361: RUN_UNED_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
362: RUN_UNED_AMT DBMS_SQL.NUMBER_TABLE,
363: RUN_UNED_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
364: RUN_UNED_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
357: RUN_ED_TAX_AMT DBMS_SQL.NUMBER_TABLE,
358: RUN_ED_TAX_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
359: -- UNED
360: RUN_UNED_ALLOC DBMS_SQL.NUMBER_TABLE,
361: RUN_UNED_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
362: RUN_UNED_AMT DBMS_SQL.NUMBER_TABLE,
363: RUN_UNED_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
364: RUN_UNED_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
365: RUN_UNED_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
358: RUN_ED_TAX_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
359: -- UNED
360: RUN_UNED_ALLOC DBMS_SQL.NUMBER_TABLE,
361: RUN_UNED_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
362: RUN_UNED_AMT DBMS_SQL.NUMBER_TABLE,
363: RUN_UNED_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
364: RUN_UNED_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
365: RUN_UNED_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
366: RUN_UNED_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
359: -- UNED
360: RUN_UNED_ALLOC DBMS_SQL.NUMBER_TABLE,
361: RUN_UNED_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
362: RUN_UNED_AMT DBMS_SQL.NUMBER_TABLE,
363: RUN_UNED_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
364: RUN_UNED_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
365: RUN_UNED_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
366: RUN_UNED_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
367: RUN_UNED_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
360: RUN_UNED_ALLOC DBMS_SQL.NUMBER_TABLE,
361: RUN_UNED_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
362: RUN_UNED_AMT DBMS_SQL.NUMBER_TABLE,
363: RUN_UNED_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
364: RUN_UNED_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
365: RUN_UNED_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
366: RUN_UNED_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
367: RUN_UNED_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
368: RUN_UNED_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
361: RUN_UNED_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
362: RUN_UNED_AMT DBMS_SQL.NUMBER_TABLE,
363: RUN_UNED_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
364: RUN_UNED_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
365: RUN_UNED_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
366: RUN_UNED_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
367: RUN_UNED_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
368: RUN_UNED_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
369: RUN_UNED_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
362: RUN_UNED_AMT DBMS_SQL.NUMBER_TABLE,
363: RUN_UNED_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
364: RUN_UNED_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
365: RUN_UNED_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
366: RUN_UNED_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
367: RUN_UNED_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
368: RUN_UNED_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
369: RUN_UNED_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
370: RUN_UNED_FRT_AMT DBMS_SQL.NUMBER_TABLE,
363: RUN_UNED_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
364: RUN_UNED_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
365: RUN_UNED_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
366: RUN_UNED_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
367: RUN_UNED_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
368: RUN_UNED_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
369: RUN_UNED_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
370: RUN_UNED_FRT_AMT DBMS_SQL.NUMBER_TABLE,
371: RUN_UNED_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
364: RUN_UNED_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
365: RUN_UNED_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
366: RUN_UNED_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
367: RUN_UNED_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
368: RUN_UNED_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
369: RUN_UNED_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
370: RUN_UNED_FRT_AMT DBMS_SQL.NUMBER_TABLE,
371: RUN_UNED_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
372: RUN_UNED_TAX_ALLOC DBMS_SQL.NUMBER_TABLE,
365: RUN_UNED_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
366: RUN_UNED_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
367: RUN_UNED_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
368: RUN_UNED_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
369: RUN_UNED_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
370: RUN_UNED_FRT_AMT DBMS_SQL.NUMBER_TABLE,
371: RUN_UNED_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
372: RUN_UNED_TAX_ALLOC DBMS_SQL.NUMBER_TABLE,
373: RUN_UNED_TAX_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
366: RUN_UNED_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
367: RUN_UNED_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
368: RUN_UNED_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
369: RUN_UNED_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
370: RUN_UNED_FRT_AMT DBMS_SQL.NUMBER_TABLE,
371: RUN_UNED_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
372: RUN_UNED_TAX_ALLOC DBMS_SQL.NUMBER_TABLE,
373: RUN_UNED_TAX_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
374: RUN_UNED_TAX_AMT DBMS_SQL.NUMBER_TABLE,
367: RUN_UNED_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
368: RUN_UNED_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
369: RUN_UNED_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
370: RUN_UNED_FRT_AMT DBMS_SQL.NUMBER_TABLE,
371: RUN_UNED_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
372: RUN_UNED_TAX_ALLOC DBMS_SQL.NUMBER_TABLE,
373: RUN_UNED_TAX_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
374: RUN_UNED_TAX_AMT DBMS_SQL.NUMBER_TABLE,
375: RUN_UNED_TAX_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
368: RUN_UNED_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
369: RUN_UNED_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
370: RUN_UNED_FRT_AMT DBMS_SQL.NUMBER_TABLE,
371: RUN_UNED_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
372: RUN_UNED_TAX_ALLOC DBMS_SQL.NUMBER_TABLE,
373: RUN_UNED_TAX_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
374: RUN_UNED_TAX_AMT DBMS_SQL.NUMBER_TABLE,
375: RUN_UNED_TAX_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
376: GROUPE_INDEX CHAR_HASH_TABLE);
369: RUN_UNED_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
370: RUN_UNED_FRT_AMT DBMS_SQL.NUMBER_TABLE,
371: RUN_UNED_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
372: RUN_UNED_TAX_ALLOC DBMS_SQL.NUMBER_TABLE,
373: RUN_UNED_TAX_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
374: RUN_UNED_TAX_AMT DBMS_SQL.NUMBER_TABLE,
375: RUN_UNED_TAX_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
376: GROUPE_INDEX CHAR_HASH_TABLE);
377:
370: RUN_UNED_FRT_AMT DBMS_SQL.NUMBER_TABLE,
371: RUN_UNED_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
372: RUN_UNED_TAX_ALLOC DBMS_SQL.NUMBER_TABLE,
373: RUN_UNED_TAX_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
374: RUN_UNED_TAX_AMT DBMS_SQL.NUMBER_TABLE,
375: RUN_UNED_TAX_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
376: GROUPE_INDEX CHAR_HASH_TABLE);
377:
378:
371: RUN_UNED_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
372: RUN_UNED_TAX_ALLOC DBMS_SQL.NUMBER_TABLE,
373: RUN_UNED_TAX_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
374: RUN_UNED_TAX_AMT DBMS_SQL.NUMBER_TABLE,
375: RUN_UNED_TAX_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
376: GROUPE_INDEX CHAR_HASH_TABLE);
377:
378:
379: --HY Cash Basis Upgrade
9486: FROM ra_cust_trx_line_gl_dist
9487: WHERE customer_trx_id = p_customer_trx_id
9488: GROUP BY customer_trx_line_id;
9489:
9490: l_amt_tab DBMS_SQL.NUMBER_TABLE;
9491: l_acctd_amt_tab DBMS_SQL.NUMBER_TABLE;
9492: l_ctl_tab DBMS_SQL.NUMBER_TABLE;
9493: l_last_fetch BOOLEAN := FALSE;
9494: l_found VARCHAR2(1) := 'N';
9487: WHERE customer_trx_id = p_customer_trx_id
9488: GROUP BY customer_trx_line_id;
9489:
9490: l_amt_tab DBMS_SQL.NUMBER_TABLE;
9491: l_acctd_amt_tab DBMS_SQL.NUMBER_TABLE;
9492: l_ctl_tab DBMS_SQL.NUMBER_TABLE;
9493: l_last_fetch BOOLEAN := FALSE;
9494: l_found VARCHAR2(1) := 'N';
9495: l_trx_type VARCHAR2(30);
9488: GROUP BY customer_trx_line_id;
9489:
9490: l_amt_tab DBMS_SQL.NUMBER_TABLE;
9491: l_acctd_amt_tab DBMS_SQL.NUMBER_TABLE;
9492: l_ctl_tab DBMS_SQL.NUMBER_TABLE;
9493: l_last_fetch BOOLEAN := FALSE;
9494: l_found VARCHAR2(1) := 'N';
9495: l_trx_type VARCHAR2(30);
9496: l_c c%ROWTYPE;
9589: customer_trx_line_id customer_trx_line_id
9590: FROM psa_mf_balances_view
9591: WHERE customer_trx_id = p_customer_trx_id
9592: GROUP BY customer_trx_line_id;
9593: l_rem_amt_tab DBMS_SQL.NUMBER_TABLE;
9594: l_orig_amt_tab DBMS_SQL.NUMBER_TABLE;
9595: l_ctl_tab DBMS_SQL.NUMBER_TABLE;
9596: l_last_fetch BOOLEAN := FALSE;
9597: l_found VARCHAR2(1);
9590: FROM psa_mf_balances_view
9591: WHERE customer_trx_id = p_customer_trx_id
9592: GROUP BY customer_trx_line_id;
9593: l_rem_amt_tab DBMS_SQL.NUMBER_TABLE;
9594: l_orig_amt_tab DBMS_SQL.NUMBER_TABLE;
9595: l_ctl_tab DBMS_SQL.NUMBER_TABLE;
9596: l_last_fetch BOOLEAN := FALSE;
9597: l_found VARCHAR2(1);
9598: BEGIN
9591: WHERE customer_trx_id = p_customer_trx_id
9592: GROUP BY customer_trx_line_id;
9593: l_rem_amt_tab DBMS_SQL.NUMBER_TABLE;
9594: l_orig_amt_tab DBMS_SQL.NUMBER_TABLE;
9595: l_ctl_tab DBMS_SQL.NUMBER_TABLE;
9596: l_last_fetch BOOLEAN := FALSE;
9597: l_found VARCHAR2(1);
9598: BEGIN
9599: IF PG_DEBUG = 'Y' THEN
9725: GROUP BY b.customer_trx_line_id,
9726: b.sum_orig,
9727: b.sum_acctd_orig;
9728:
9729: l_sum_orig DBMS_SQL.NUMBER_TABLE;
9730: l_sum_acctd_orig DBMS_SQL.NUMBER_TABLE;
9731: l_CHRG_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
9732: l_ACCTD_CHRG_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
9733: l_FRT_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
9726: b.sum_orig,
9727: b.sum_acctd_orig;
9728:
9729: l_sum_orig DBMS_SQL.NUMBER_TABLE;
9730: l_sum_acctd_orig DBMS_SQL.NUMBER_TABLE;
9731: l_CHRG_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
9732: l_ACCTD_CHRG_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
9733: l_FRT_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
9734: l_ACCTD_FRT_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
9727: b.sum_acctd_orig;
9728:
9729: l_sum_orig DBMS_SQL.NUMBER_TABLE;
9730: l_sum_acctd_orig DBMS_SQL.NUMBER_TABLE;
9731: l_CHRG_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
9732: l_ACCTD_CHRG_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
9733: l_FRT_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
9734: l_ACCTD_FRT_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
9735: l_ED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
9728:
9729: l_sum_orig DBMS_SQL.NUMBER_TABLE;
9730: l_sum_acctd_orig DBMS_SQL.NUMBER_TABLE;
9731: l_CHRG_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
9732: l_ACCTD_CHRG_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
9733: l_FRT_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
9734: l_ACCTD_FRT_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
9735: l_ED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
9736: l_ACCTD_ED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
9729: l_sum_orig DBMS_SQL.NUMBER_TABLE;
9730: l_sum_acctd_orig DBMS_SQL.NUMBER_TABLE;
9731: l_CHRG_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
9732: l_ACCTD_CHRG_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
9733: l_FRT_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
9734: l_ACCTD_FRT_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
9735: l_ED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
9736: l_ACCTD_ED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
9737: l_UNED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
9730: l_sum_acctd_orig DBMS_SQL.NUMBER_TABLE;
9731: l_CHRG_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
9732: l_ACCTD_CHRG_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
9733: l_FRT_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
9734: l_ACCTD_FRT_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
9735: l_ED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
9736: l_ACCTD_ED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
9737: l_UNED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
9738: l_ACCTD_UNED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
9731: l_CHRG_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
9732: l_ACCTD_CHRG_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
9733: l_FRT_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
9734: l_ACCTD_FRT_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
9735: l_ED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
9736: l_ACCTD_ED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
9737: l_UNED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
9738: l_ACCTD_UNED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
9739: l_REM_TYPE_LINE DBMS_SQL.VARCHAR2_TABLE;
9732: l_ACCTD_CHRG_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
9733: l_FRT_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
9734: l_ACCTD_FRT_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
9735: l_ED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
9736: l_ACCTD_ED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
9737: l_UNED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
9738: l_ACCTD_UNED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
9739: l_REM_TYPE_LINE DBMS_SQL.VARCHAR2_TABLE;
9740: l_ACCTD_REM_TYPE_LINE DBMS_SQL.NUMBER_TABLE;
9733: l_FRT_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
9734: l_ACCTD_FRT_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
9735: l_ED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
9736: l_ACCTD_ED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
9737: l_UNED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
9738: l_ACCTD_UNED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
9739: l_REM_TYPE_LINE DBMS_SQL.VARCHAR2_TABLE;
9740: l_ACCTD_REM_TYPE_LINE DBMS_SQL.NUMBER_TABLE;
9741: l_CUSTOMER_TRX_LINE_ID DBMS_SQL.NUMBER_TABLE;
9734: l_ACCTD_FRT_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
9735: l_ED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
9736: l_ACCTD_ED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
9737: l_UNED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
9738: l_ACCTD_UNED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
9739: l_REM_TYPE_LINE DBMS_SQL.VARCHAR2_TABLE;
9740: l_ACCTD_REM_TYPE_LINE DBMS_SQL.NUMBER_TABLE;
9741: l_CUSTOMER_TRX_LINE_ID DBMS_SQL.NUMBER_TABLE;
9742:
9735: l_ED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
9736: l_ACCTD_ED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
9737: l_UNED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
9738: l_ACCTD_UNED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
9739: l_REM_TYPE_LINE DBMS_SQL.VARCHAR2_TABLE;
9740: l_ACCTD_REM_TYPE_LINE DBMS_SQL.NUMBER_TABLE;
9741: l_CUSTOMER_TRX_LINE_ID DBMS_SQL.NUMBER_TABLE;
9742:
9743: l_last_fetch BOOLEAN := FALSE;
9736: l_ACCTD_ED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
9737: l_UNED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
9738: l_ACCTD_UNED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
9739: l_REM_TYPE_LINE DBMS_SQL.VARCHAR2_TABLE;
9740: l_ACCTD_REM_TYPE_LINE DBMS_SQL.NUMBER_TABLE;
9741: l_CUSTOMER_TRX_LINE_ID DBMS_SQL.NUMBER_TABLE;
9742:
9743: l_last_fetch BOOLEAN := FALSE;
9744:
9737: l_UNED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
9738: l_ACCTD_UNED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
9739: l_REM_TYPE_LINE DBMS_SQL.VARCHAR2_TABLE;
9740: l_ACCTD_REM_TYPE_LINE DBMS_SQL.NUMBER_TABLE;
9741: l_CUSTOMER_TRX_LINE_ID DBMS_SQL.NUMBER_TABLE;
9742:
9743: l_last_fetch BOOLEAN := FALSE;
9744:
9745: BEGIN
9849: );
9850:
9851:
9852:
9853: l_amt_tab DBMS_SQL.NUMBER_TABLE;
9854: l_acctd_amt_tab DBMS_SQL.NUMBER_TABLE;
9855: l_ctl_tab DBMS_SQL.NUMBER_TABLE;
9856: l_ctl_hd_tab DBMS_SQL.NUMBER_TABLE;
9857: l_ctl_app_tab DBMS_SQL.NUMBER_TABLE;
9850:
9851:
9852:
9853: l_amt_tab DBMS_SQL.NUMBER_TABLE;
9854: l_acctd_amt_tab DBMS_SQL.NUMBER_TABLE;
9855: l_ctl_tab DBMS_SQL.NUMBER_TABLE;
9856: l_ctl_hd_tab DBMS_SQL.NUMBER_TABLE;
9857: l_ctl_app_tab DBMS_SQL.NUMBER_TABLE;
9858: l_customer_trx ra_customer_trx%ROWTYPE;
9851:
9852:
9853: l_amt_tab DBMS_SQL.NUMBER_TABLE;
9854: l_acctd_amt_tab DBMS_SQL.NUMBER_TABLE;
9855: l_ctl_tab DBMS_SQL.NUMBER_TABLE;
9856: l_ctl_hd_tab DBMS_SQL.NUMBER_TABLE;
9857: l_ctl_app_tab DBMS_SQL.NUMBER_TABLE;
9858: l_customer_trx ra_customer_trx%ROWTYPE;
9859: l_last_fetch BOOLEAN := FALSE;
9852:
9853: l_amt_tab DBMS_SQL.NUMBER_TABLE;
9854: l_acctd_amt_tab DBMS_SQL.NUMBER_TABLE;
9855: l_ctl_tab DBMS_SQL.NUMBER_TABLE;
9856: l_ctl_hd_tab DBMS_SQL.NUMBER_TABLE;
9857: l_ctl_app_tab DBMS_SQL.NUMBER_TABLE;
9858: l_customer_trx ra_customer_trx%ROWTYPE;
9859: l_last_fetch BOOLEAN := FALSE;
9860:
9853: l_amt_tab DBMS_SQL.NUMBER_TABLE;
9854: l_acctd_amt_tab DBMS_SQL.NUMBER_TABLE;
9855: l_ctl_tab DBMS_SQL.NUMBER_TABLE;
9856: l_ctl_hd_tab DBMS_SQL.NUMBER_TABLE;
9857: l_ctl_app_tab DBMS_SQL.NUMBER_TABLE;
9858: l_customer_trx ra_customer_trx%ROWTYPE;
9859: l_last_fetch BOOLEAN := FALSE;
9860:
9861: l_msg RA_INTERFACE_ERRORS.MESSAGE_TEXT%TYPE;
10863: FROM ra_customer_trx
10864: WHERE customer_trx_id = p_customer_trx_id;
10865: l_inv_currency VARCHAR2(30) := NULL;
10866: l_exchange_rate ra_customer_trx.exchange_rate%type;
10867: l_sum_line_rem_amt DBMS_SQL.NUMBER_TABLE;
10868: l_sum_line_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
10869: l_sum_line_orig_amt DBMS_SQL.NUMBER_TABLE;
10870: l_sum_line_orig_acctd_amt DBMS_SQL.NUMBER_TABLE;
10871: l_sum_line_chrg_rem_amt DBMS_SQL.NUMBER_TABLE;
10864: WHERE customer_trx_id = p_customer_trx_id;
10865: l_inv_currency VARCHAR2(30) := NULL;
10866: l_exchange_rate ra_customer_trx.exchange_rate%type;
10867: l_sum_line_rem_amt DBMS_SQL.NUMBER_TABLE;
10868: l_sum_line_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
10869: l_sum_line_orig_amt DBMS_SQL.NUMBER_TABLE;
10870: l_sum_line_orig_acctd_amt DBMS_SQL.NUMBER_TABLE;
10871: l_sum_line_chrg_rem_amt DBMS_SQL.NUMBER_TABLE;
10872: l_sum_line_chrg_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
10865: l_inv_currency VARCHAR2(30) := NULL;
10866: l_exchange_rate ra_customer_trx.exchange_rate%type;
10867: l_sum_line_rem_amt DBMS_SQL.NUMBER_TABLE;
10868: l_sum_line_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
10869: l_sum_line_orig_amt DBMS_SQL.NUMBER_TABLE;
10870: l_sum_line_orig_acctd_amt DBMS_SQL.NUMBER_TABLE;
10871: l_sum_line_chrg_rem_amt DBMS_SQL.NUMBER_TABLE;
10872: l_sum_line_chrg_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
10873: --
10866: l_exchange_rate ra_customer_trx.exchange_rate%type;
10867: l_sum_line_rem_amt DBMS_SQL.NUMBER_TABLE;
10868: l_sum_line_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
10869: l_sum_line_orig_amt DBMS_SQL.NUMBER_TABLE;
10870: l_sum_line_orig_acctd_amt DBMS_SQL.NUMBER_TABLE;
10871: l_sum_line_chrg_rem_amt DBMS_SQL.NUMBER_TABLE;
10872: l_sum_line_chrg_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
10873: --
10874: l_sum_line_frt_rem_amt DBMS_SQL.NUMBER_TABLE;
10867: l_sum_line_rem_amt DBMS_SQL.NUMBER_TABLE;
10868: l_sum_line_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
10869: l_sum_line_orig_amt DBMS_SQL.NUMBER_TABLE;
10870: l_sum_line_orig_acctd_amt DBMS_SQL.NUMBER_TABLE;
10871: l_sum_line_chrg_rem_amt DBMS_SQL.NUMBER_TABLE;
10872: l_sum_line_chrg_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
10873: --
10874: l_sum_line_frt_rem_amt DBMS_SQL.NUMBER_TABLE;
10875: l_sum_line_frt_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
10868: l_sum_line_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
10869: l_sum_line_orig_amt DBMS_SQL.NUMBER_TABLE;
10870: l_sum_line_orig_acctd_amt DBMS_SQL.NUMBER_TABLE;
10871: l_sum_line_chrg_rem_amt DBMS_SQL.NUMBER_TABLE;
10872: l_sum_line_chrg_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
10873: --
10874: l_sum_line_frt_rem_amt DBMS_SQL.NUMBER_TABLE;
10875: l_sum_line_frt_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
10876: l_sum_line_frt_orig_amt DBMS_SQL.NUMBER_TABLE;
10870: l_sum_line_orig_acctd_amt DBMS_SQL.NUMBER_TABLE;
10871: l_sum_line_chrg_rem_amt DBMS_SQL.NUMBER_TABLE;
10872: l_sum_line_chrg_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
10873: --
10874: l_sum_line_frt_rem_amt DBMS_SQL.NUMBER_TABLE;
10875: l_sum_line_frt_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
10876: l_sum_line_frt_orig_amt DBMS_SQL.NUMBER_TABLE;
10877: l_sum_line_frt_orig_acctd_amt DBMS_SQL.NUMBER_TABLE;
10878: --
10871: l_sum_line_chrg_rem_amt DBMS_SQL.NUMBER_TABLE;
10872: l_sum_line_chrg_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
10873: --
10874: l_sum_line_frt_rem_amt DBMS_SQL.NUMBER_TABLE;
10875: l_sum_line_frt_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
10876: l_sum_line_frt_orig_amt DBMS_SQL.NUMBER_TABLE;
10877: l_sum_line_frt_orig_acctd_amt DBMS_SQL.NUMBER_TABLE;
10878: --
10879: l_sum_line_tax_rem_amt DBMS_SQL.NUMBER_TABLE;
10872: l_sum_line_chrg_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
10873: --
10874: l_sum_line_frt_rem_amt DBMS_SQL.NUMBER_TABLE;
10875: l_sum_line_frt_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
10876: l_sum_line_frt_orig_amt DBMS_SQL.NUMBER_TABLE;
10877: l_sum_line_frt_orig_acctd_amt DBMS_SQL.NUMBER_TABLE;
10878: --
10879: l_sum_line_tax_rem_amt DBMS_SQL.NUMBER_TABLE;
10880: l_sum_line_tax_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
10873: --
10874: l_sum_line_frt_rem_amt DBMS_SQL.NUMBER_TABLE;
10875: l_sum_line_frt_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
10876: l_sum_line_frt_orig_amt DBMS_SQL.NUMBER_TABLE;
10877: l_sum_line_frt_orig_acctd_amt DBMS_SQL.NUMBER_TABLE;
10878: --
10879: l_sum_line_tax_rem_amt DBMS_SQL.NUMBER_TABLE;
10880: l_sum_line_tax_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
10881: l_sum_line_tax_orig_amt DBMS_SQL.NUMBER_TABLE;
10875: l_sum_line_frt_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
10876: l_sum_line_frt_orig_amt DBMS_SQL.NUMBER_TABLE;
10877: l_sum_line_frt_orig_acctd_amt DBMS_SQL.NUMBER_TABLE;
10878: --
10879: l_sum_line_tax_rem_amt DBMS_SQL.NUMBER_TABLE;
10880: l_sum_line_tax_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
10881: l_sum_line_tax_orig_amt DBMS_SQL.NUMBER_TABLE;
10882: l_sum_line_tax_orig_acctd_amt DBMS_SQL.NUMBER_TABLE;
10883: --
10876: l_sum_line_frt_orig_amt DBMS_SQL.NUMBER_TABLE;
10877: l_sum_line_frt_orig_acctd_amt DBMS_SQL.NUMBER_TABLE;
10878: --
10879: l_sum_line_tax_rem_amt DBMS_SQL.NUMBER_TABLE;
10880: l_sum_line_tax_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
10881: l_sum_line_tax_orig_amt DBMS_SQL.NUMBER_TABLE;
10882: l_sum_line_tax_orig_acctd_amt DBMS_SQL.NUMBER_TABLE;
10883: --
10884: l_line_type DBMS_SQL.VARCHAR2_TABLE;
10877: l_sum_line_frt_orig_acctd_amt DBMS_SQL.NUMBER_TABLE;
10878: --
10879: l_sum_line_tax_rem_amt DBMS_SQL.NUMBER_TABLE;
10880: l_sum_line_tax_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
10881: l_sum_line_tax_orig_amt DBMS_SQL.NUMBER_TABLE;
10882: l_sum_line_tax_orig_acctd_amt DBMS_SQL.NUMBER_TABLE;
10883: --
10884: l_line_type DBMS_SQL.VARCHAR2_TABLE;
10885: l_ra_ar_gt ra_ar_gt%ROWTYPE;
10878: --
10879: l_sum_line_tax_rem_amt DBMS_SQL.NUMBER_TABLE;
10880: l_sum_line_tax_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
10881: l_sum_line_tax_orig_amt DBMS_SQL.NUMBER_TABLE;
10882: l_sum_line_tax_orig_acctd_amt DBMS_SQL.NUMBER_TABLE;
10883: --
10884: l_line_type DBMS_SQL.VARCHAR2_TABLE;
10885: l_ra_ar_gt ra_ar_gt%ROWTYPE;
10886: invoice_has_no_lines EXCEPTION;
10880: l_sum_line_tax_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
10881: l_sum_line_tax_orig_amt DBMS_SQL.NUMBER_TABLE;
10882: l_sum_line_tax_orig_acctd_amt DBMS_SQL.NUMBER_TABLE;
10883: --
10884: l_line_type DBMS_SQL.VARCHAR2_TABLE;
10885: l_ra_ar_gt ra_ar_gt%ROWTYPE;
10886: invoice_has_no_lines EXCEPTION;
10887: not_an_adjustment EXCEPTION;
10888: l_freight_boundary_done VARCHAR2(1) := 'N';
13475: b.customer_trx_line_id
13476: FROM ra_customer_trx_lines_gt b
13477: WHERE b.customer_trx_id = p_customer_trx_id;
13478:
13479: l_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
13480: l_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
13481: l_amt_orig_tab DBMS_SQL.NUMBER_TABLE;
13482: l_acctd_amt_orig_tab DBMS_SQL.NUMBER_TABLE;
13483: l_chrg_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
13476: FROM ra_customer_trx_lines_gt b
13477: WHERE b.customer_trx_id = p_customer_trx_id;
13478:
13479: l_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
13480: l_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
13481: l_amt_orig_tab DBMS_SQL.NUMBER_TABLE;
13482: l_acctd_amt_orig_tab DBMS_SQL.NUMBER_TABLE;
13483: l_chrg_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
13484: l_chrg_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
13477: WHERE b.customer_trx_id = p_customer_trx_id;
13478:
13479: l_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
13480: l_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
13481: l_amt_orig_tab DBMS_SQL.NUMBER_TABLE;
13482: l_acctd_amt_orig_tab DBMS_SQL.NUMBER_TABLE;
13483: l_chrg_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
13484: l_chrg_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
13485: l_frt_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
13478:
13479: l_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
13480: l_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
13481: l_amt_orig_tab DBMS_SQL.NUMBER_TABLE;
13482: l_acctd_amt_orig_tab DBMS_SQL.NUMBER_TABLE;
13483: l_chrg_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
13484: l_chrg_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
13485: l_frt_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
13486: l_frt_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
13479: l_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
13480: l_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
13481: l_amt_orig_tab DBMS_SQL.NUMBER_TABLE;
13482: l_acctd_amt_orig_tab DBMS_SQL.NUMBER_TABLE;
13483: l_chrg_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
13484: l_chrg_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
13485: l_frt_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
13486: l_frt_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
13487: l_frt_ed_amt_tab DBMS_SQL.NUMBER_TABLE;
13480: l_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
13481: l_amt_orig_tab DBMS_SQL.NUMBER_TABLE;
13482: l_acctd_amt_orig_tab DBMS_SQL.NUMBER_TABLE;
13483: l_chrg_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
13484: l_chrg_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
13485: l_frt_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
13486: l_frt_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
13487: l_frt_ed_amt_tab DBMS_SQL.NUMBER_TABLE;
13488: l_frt_ed_acctd_amt_tab DBMS_SQL.NUMBER_TABLE;
13481: l_amt_orig_tab DBMS_SQL.NUMBER_TABLE;
13482: l_acctd_amt_orig_tab DBMS_SQL.NUMBER_TABLE;
13483: l_chrg_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
13484: l_chrg_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
13485: l_frt_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
13486: l_frt_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
13487: l_frt_ed_amt_tab DBMS_SQL.NUMBER_TABLE;
13488: l_frt_ed_acctd_amt_tab DBMS_SQL.NUMBER_TABLE;
13489: l_frt_uned_amt_tab DBMS_SQL.NUMBER_TABLE;
13482: l_acctd_amt_orig_tab DBMS_SQL.NUMBER_TABLE;
13483: l_chrg_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
13484: l_chrg_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
13485: l_frt_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
13486: l_frt_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
13487: l_frt_ed_amt_tab DBMS_SQL.NUMBER_TABLE;
13488: l_frt_ed_acctd_amt_tab DBMS_SQL.NUMBER_TABLE;
13489: l_frt_uned_amt_tab DBMS_SQL.NUMBER_TABLE;
13490: l_frt_uned_acctd_amt_tab DBMS_SQL.NUMBER_TABLE;
13483: l_chrg_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
13484: l_chrg_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
13485: l_frt_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
13486: l_frt_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
13487: l_frt_ed_amt_tab DBMS_SQL.NUMBER_TABLE;
13488: l_frt_ed_acctd_amt_tab DBMS_SQL.NUMBER_TABLE;
13489: l_frt_uned_amt_tab DBMS_SQL.NUMBER_TABLE;
13490: l_frt_uned_acctd_amt_tab DBMS_SQL.NUMBER_TABLE;
13491: l_ctl_id_tab DBMS_SQL.NUMBER_TABLE;
13484: l_chrg_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
13485: l_frt_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
13486: l_frt_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
13487: l_frt_ed_amt_tab DBMS_SQL.NUMBER_TABLE;
13488: l_frt_ed_acctd_amt_tab DBMS_SQL.NUMBER_TABLE;
13489: l_frt_uned_amt_tab DBMS_SQL.NUMBER_TABLE;
13490: l_frt_uned_acctd_amt_tab DBMS_SQL.NUMBER_TABLE;
13491: l_ctl_id_tab DBMS_SQL.NUMBER_TABLE;
13492: l_last_fetch BOOLEAN := FALSE;
13485: l_frt_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
13486: l_frt_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
13487: l_frt_ed_amt_tab DBMS_SQL.NUMBER_TABLE;
13488: l_frt_ed_acctd_amt_tab DBMS_SQL.NUMBER_TABLE;
13489: l_frt_uned_amt_tab DBMS_SQL.NUMBER_TABLE;
13490: l_frt_uned_acctd_amt_tab DBMS_SQL.NUMBER_TABLE;
13491: l_ctl_id_tab DBMS_SQL.NUMBER_TABLE;
13492: l_last_fetch BOOLEAN := FALSE;
13493:
13486: l_frt_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
13487: l_frt_ed_amt_tab DBMS_SQL.NUMBER_TABLE;
13488: l_frt_ed_acctd_amt_tab DBMS_SQL.NUMBER_TABLE;
13489: l_frt_uned_amt_tab DBMS_SQL.NUMBER_TABLE;
13490: l_frt_uned_acctd_amt_tab DBMS_SQL.NUMBER_TABLE;
13491: l_ctl_id_tab DBMS_SQL.NUMBER_TABLE;
13492: l_last_fetch BOOLEAN := FALSE;
13493:
13494: /* 12902724 */
13487: l_frt_ed_amt_tab DBMS_SQL.NUMBER_TABLE;
13488: l_frt_ed_acctd_amt_tab DBMS_SQL.NUMBER_TABLE;
13489: l_frt_uned_amt_tab DBMS_SQL.NUMBER_TABLE;
13490: l_frt_uned_acctd_amt_tab DBMS_SQL.NUMBER_TABLE;
13491: l_ctl_id_tab DBMS_SQL.NUMBER_TABLE;
13492: l_last_fetch BOOLEAN := FALSE;
13493:
13494: /* 12902724 */
13495: l_count number;
18759: l_uned_amt NUMBER := 0;
18760: l_uned_acctd_amt NUMBER := 0;
18761:
18762:
18763: l_amt_tab DBMS_SQL.NUMBER_TABLE;
18764: l_acctd_amt_tab DBMS_SQL.NUMBER_TABLE;
18765: l_activity_tab DBMS_SQL.VARCHAR2_TABLE;
18766:
18767: l_check_precision VARCHAR2(1) := 'N';
18760: l_uned_acctd_amt NUMBER := 0;
18761:
18762:
18763: l_amt_tab DBMS_SQL.NUMBER_TABLE;
18764: l_acctd_amt_tab DBMS_SQL.NUMBER_TABLE;
18765: l_activity_tab DBMS_SQL.VARCHAR2_TABLE;
18766:
18767: l_check_precision VARCHAR2(1) := 'N';
18768: l_acctd_amt_sum NUMBER;
18761:
18762:
18763: l_amt_tab DBMS_SQL.NUMBER_TABLE;
18764: l_acctd_amt_tab DBMS_SQL.NUMBER_TABLE;
18765: l_activity_tab DBMS_SQL.VARCHAR2_TABLE;
18766:
18767: l_check_precision VARCHAR2(1) := 'N';
18768: l_acctd_amt_sum NUMBER;
18769: