39: tl_for_rl VARCHAR2(1),
40: tl_for_fl VARCHAR2(1) );
41: --}
42:
43: g_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
44: g_adj_yn VARCHAR2(1) := 'N';
45:
46: PROCEDURE localdebug(p_txt IN VARCHAR2);
47:
195: -- Structure to keep the input amount and the output amount of the proration
196: --
197: TYPE pro_res_tbl_type IS RECORD
198: ( -- Groupe
199: GROUPE DBMS_SQL.VARCHAR2_TABLE,
200: -- Base
201: -- ADJ and APP
202: base_pro_amt DBMS_SQL.NUMBER_TABLE,
203: base_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
198: ( -- Groupe
199: GROUPE DBMS_SQL.VARCHAR2_TABLE,
200: -- Base
201: -- ADJ and APP
202: base_pro_amt DBMS_SQL.NUMBER_TABLE,
203: base_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
204: BASE_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
205: BASE_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
206: base_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
199: GROUPE DBMS_SQL.VARCHAR2_TABLE,
200: -- Base
201: -- ADJ and APP
202: base_pro_amt DBMS_SQL.NUMBER_TABLE,
203: base_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
204: BASE_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
205: BASE_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
206: base_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
207: base_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
200: -- Base
201: -- ADJ and APP
202: base_pro_amt DBMS_SQL.NUMBER_TABLE,
203: base_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
204: BASE_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
205: BASE_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
206: base_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
207: base_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
208: base_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
201: -- ADJ and APP
202: base_pro_amt DBMS_SQL.NUMBER_TABLE,
203: base_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
204: BASE_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
205: BASE_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
206: base_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
207: base_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
208: base_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
209: base_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
202: base_pro_amt DBMS_SQL.NUMBER_TABLE,
203: base_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
204: BASE_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
205: BASE_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
206: base_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
207: base_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
208: base_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
209: base_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
210: -- ED
203: base_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
204: BASE_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
205: BASE_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
206: base_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
207: base_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
208: base_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
209: base_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
210: -- ED
211: base_ed_pro_amt DBMS_SQL.NUMBER_TABLE,
204: BASE_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
205: BASE_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
206: base_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
207: base_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
208: base_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
209: base_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
210: -- ED
211: base_ed_pro_amt DBMS_SQL.NUMBER_TABLE,
212: base_ed_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
205: BASE_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
206: base_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
207: base_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
208: base_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
209: base_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
210: -- ED
211: base_ed_pro_amt DBMS_SQL.NUMBER_TABLE,
212: base_ed_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
213: BASE_ed_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
207: base_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
208: base_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
209: base_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
210: -- ED
211: base_ed_pro_amt DBMS_SQL.NUMBER_TABLE,
212: base_ed_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
213: BASE_ed_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
214: BASE_ed_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
215: base_ed_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
208: base_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
209: base_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
210: -- ED
211: base_ed_pro_amt DBMS_SQL.NUMBER_TABLE,
212: base_ed_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
213: BASE_ed_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
214: BASE_ed_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
215: base_ed_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
216: base_ed_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
209: base_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
210: -- ED
211: base_ed_pro_amt DBMS_SQL.NUMBER_TABLE,
212: base_ed_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
213: BASE_ed_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
214: BASE_ed_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
215: base_ed_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
216: base_ed_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
217: base_ed_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
210: -- ED
211: base_ed_pro_amt DBMS_SQL.NUMBER_TABLE,
212: base_ed_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
213: BASE_ed_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
214: BASE_ed_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
215: base_ed_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
216: base_ed_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
217: base_ed_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
218: base_ed_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
211: base_ed_pro_amt DBMS_SQL.NUMBER_TABLE,
212: base_ed_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
213: BASE_ed_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
214: BASE_ed_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
215: base_ed_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
216: base_ed_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
217: base_ed_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
218: base_ed_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
219: -- UNED
212: base_ed_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
213: BASE_ed_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
214: BASE_ed_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
215: base_ed_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
216: base_ed_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
217: base_ed_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
218: base_ed_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
219: -- UNED
220: base_uned_pro_amt DBMS_SQL.NUMBER_TABLE,
213: BASE_ed_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
214: BASE_ed_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
215: base_ed_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
216: base_ed_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
217: base_ed_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
218: base_ed_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
219: -- UNED
220: base_uned_pro_amt DBMS_SQL.NUMBER_TABLE,
221: base_uned_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
214: BASE_ed_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
215: base_ed_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
216: base_ed_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
217: base_ed_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
218: base_ed_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
219: -- UNED
220: base_uned_pro_amt DBMS_SQL.NUMBER_TABLE,
221: base_uned_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
222: BASE_uned_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
216: base_ed_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
217: base_ed_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
218: base_ed_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
219: -- UNED
220: base_uned_pro_amt DBMS_SQL.NUMBER_TABLE,
221: base_uned_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
222: BASE_uned_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
223: BASE_uned_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
224: base_uned_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
217: base_ed_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
218: base_ed_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
219: -- UNED
220: base_uned_pro_amt DBMS_SQL.NUMBER_TABLE,
221: base_uned_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
222: BASE_uned_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
223: BASE_uned_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
224: base_uned_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
225: base_uned_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
218: base_ed_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
219: -- UNED
220: base_uned_pro_amt DBMS_SQL.NUMBER_TABLE,
221: base_uned_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
222: BASE_uned_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
223: BASE_uned_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
224: base_uned_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
225: base_uned_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
226: base_uned_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
219: -- UNED
220: base_uned_pro_amt DBMS_SQL.NUMBER_TABLE,
221: base_uned_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
222: BASE_uned_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
223: BASE_uned_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
224: base_uned_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
225: base_uned_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
226: base_uned_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
227: base_uned_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
220: base_uned_pro_amt DBMS_SQL.NUMBER_TABLE,
221: base_uned_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
222: BASE_uned_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
223: BASE_uned_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
224: base_uned_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
225: base_uned_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
226: base_uned_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
227: base_uned_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
228: -- Element numerator
221: base_uned_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
222: BASE_uned_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
223: BASE_uned_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
224: base_uned_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
225: base_uned_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
226: base_uned_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
227: base_uned_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
228: -- Element numerator
229: -- ADJ and APP
222: BASE_uned_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
223: BASE_uned_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
224: base_uned_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
225: base_uned_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
226: base_uned_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
227: base_uned_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
228: -- Element numerator
229: -- ADJ and APP
230: elmt_pro_amt DBMS_SQL.NUMBER_TABLE,
223: BASE_uned_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
224: base_uned_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
225: base_uned_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
226: base_uned_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
227: base_uned_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
228: -- Element numerator
229: -- ADJ and APP
230: elmt_pro_amt DBMS_SQL.NUMBER_TABLE,
231: elmt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
226: base_uned_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
227: base_uned_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
228: -- Element numerator
229: -- ADJ and APP
230: elmt_pro_amt DBMS_SQL.NUMBER_TABLE,
231: elmt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
232: ELMT_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
233: ELMT_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
234: elmt_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
227: base_uned_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
228: -- Element numerator
229: -- ADJ and APP
230: elmt_pro_amt DBMS_SQL.NUMBER_TABLE,
231: elmt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
232: ELMT_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
233: ELMT_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
234: elmt_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
235: elmt_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
228: -- Element numerator
229: -- ADJ and APP
230: elmt_pro_amt DBMS_SQL.NUMBER_TABLE,
231: elmt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
232: ELMT_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
233: ELMT_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
234: elmt_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
235: elmt_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
236: elmt_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
229: -- ADJ and APP
230: elmt_pro_amt DBMS_SQL.NUMBER_TABLE,
231: elmt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
232: ELMT_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
233: ELMT_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
234: elmt_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
235: elmt_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
236: elmt_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
237: elmt_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
230: elmt_pro_amt DBMS_SQL.NUMBER_TABLE,
231: elmt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
232: ELMT_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
233: ELMT_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
234: elmt_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
235: elmt_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
236: elmt_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
237: elmt_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
238: -- ED
231: elmt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
232: ELMT_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
233: ELMT_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
234: elmt_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
235: elmt_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
236: elmt_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
237: elmt_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
238: -- ED
239: elmt_ed_pro_amt DBMS_SQL.NUMBER_TABLE,
232: ELMT_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
233: ELMT_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
234: elmt_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
235: elmt_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
236: elmt_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
237: elmt_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
238: -- ED
239: elmt_ed_pro_amt DBMS_SQL.NUMBER_TABLE,
240: elmt_ed_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
233: ELMT_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
234: elmt_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
235: elmt_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
236: elmt_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
237: elmt_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
238: -- ED
239: elmt_ed_pro_amt DBMS_SQL.NUMBER_TABLE,
240: elmt_ed_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
241: ELMT_ed_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
235: elmt_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
236: elmt_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
237: elmt_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
238: -- ED
239: elmt_ed_pro_amt DBMS_SQL.NUMBER_TABLE,
240: elmt_ed_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
241: ELMT_ed_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
242: ELMT_ed_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
243: elmt_ed_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
236: elmt_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
237: elmt_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
238: -- ED
239: elmt_ed_pro_amt DBMS_SQL.NUMBER_TABLE,
240: elmt_ed_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
241: ELMT_ed_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
242: ELMT_ed_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
243: elmt_ed_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
244: elmt_ed_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
237: elmt_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
238: -- ED
239: elmt_ed_pro_amt DBMS_SQL.NUMBER_TABLE,
240: elmt_ed_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
241: ELMT_ed_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
242: ELMT_ed_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
243: elmt_ed_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
244: elmt_ed_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
245: elmt_ed_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
238: -- ED
239: elmt_ed_pro_amt DBMS_SQL.NUMBER_TABLE,
240: elmt_ed_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
241: ELMT_ed_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
242: ELMT_ed_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
243: elmt_ed_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
244: elmt_ed_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
245: elmt_ed_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
246: elmt_ed_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
239: elmt_ed_pro_amt DBMS_SQL.NUMBER_TABLE,
240: elmt_ed_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
241: ELMT_ed_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
242: ELMT_ed_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
243: elmt_ed_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
244: elmt_ed_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
245: elmt_ed_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
246: elmt_ed_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
247: -- UNED
240: elmt_ed_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
241: ELMT_ed_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
242: ELMT_ed_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
243: elmt_ed_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
244: elmt_ed_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
245: elmt_ed_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
246: elmt_ed_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
247: -- UNED
248: elmt_uned_pro_amt DBMS_SQL.NUMBER_TABLE,
241: ELMT_ed_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
242: ELMT_ed_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
243: elmt_ed_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
244: elmt_ed_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
245: elmt_ed_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
246: elmt_ed_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
247: -- UNED
248: elmt_uned_pro_amt DBMS_SQL.NUMBER_TABLE,
249: elmt_uned_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
242: ELMT_ed_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
243: elmt_ed_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
244: elmt_ed_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
245: elmt_ed_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
246: elmt_ed_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
247: -- UNED
248: elmt_uned_pro_amt DBMS_SQL.NUMBER_TABLE,
249: elmt_uned_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
250: ELMT_uned_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
244: elmt_ed_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
245: elmt_ed_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
246: elmt_ed_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
247: -- UNED
248: elmt_uned_pro_amt DBMS_SQL.NUMBER_TABLE,
249: elmt_uned_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
250: ELMT_uned_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
251: ELMT_uned_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
252: elmt_uned_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
245: elmt_ed_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
246: elmt_ed_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
247: -- UNED
248: elmt_uned_pro_amt DBMS_SQL.NUMBER_TABLE,
249: elmt_uned_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
250: ELMT_uned_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
251: ELMT_uned_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
252: elmt_uned_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
253: elmt_uned_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
246: elmt_ed_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
247: -- UNED
248: elmt_uned_pro_amt DBMS_SQL.NUMBER_TABLE,
249: elmt_uned_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
250: ELMT_uned_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
251: ELMT_uned_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
252: elmt_uned_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
253: elmt_uned_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
254: elmt_uned_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
247: -- UNED
248: elmt_uned_pro_amt DBMS_SQL.NUMBER_TABLE,
249: elmt_uned_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
250: ELMT_uned_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
251: ELMT_uned_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
252: elmt_uned_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
253: elmt_uned_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
254: elmt_uned_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
255: elmt_uned_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
248: elmt_uned_pro_amt DBMS_SQL.NUMBER_TABLE,
249: elmt_uned_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
250: ELMT_uned_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
251: ELMT_uned_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
252: elmt_uned_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
253: elmt_uned_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
254: elmt_uned_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
255: elmt_uned_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
256: -- Amount to be allocated -- ADJ and APP
249: elmt_uned_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
250: ELMT_uned_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
251: ELMT_uned_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
252: elmt_uned_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
253: elmt_uned_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
254: elmt_uned_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
255: elmt_uned_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
256: -- Amount to be allocated -- ADJ and APP
257: buc_alloc_amt DBMS_SQL.NUMBER_TABLE,
250: ELMT_uned_CHRG_PRO_AMT DBMS_SQL.NUMBER_TABLE,
251: ELMT_uned_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
252: elmt_uned_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
253: elmt_uned_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
254: elmt_uned_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
255: elmt_uned_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
256: -- Amount to be allocated -- ADJ and APP
257: buc_alloc_amt DBMS_SQL.NUMBER_TABLE,
258: buc_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
251: ELMT_uned_CHRG_PRO_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
252: elmt_uned_frt_pro_amt DBMS_SQL.NUMBER_TABLE,
253: elmt_uned_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
254: elmt_uned_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
255: elmt_uned_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
256: -- Amount to be allocated -- ADJ and APP
257: buc_alloc_amt DBMS_SQL.NUMBER_TABLE,
258: buc_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
259: buc_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
253: elmt_uned_frt_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
254: elmt_uned_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
255: elmt_uned_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
256: -- Amount to be allocated -- ADJ and APP
257: buc_alloc_amt DBMS_SQL.NUMBER_TABLE,
258: buc_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
259: buc_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
260: buc_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
261: buc_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
254: elmt_uned_tax_pro_amt DBMS_SQL.NUMBER_TABLE,
255: elmt_uned_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
256: -- Amount to be allocated -- ADJ and APP
257: buc_alloc_amt DBMS_SQL.NUMBER_TABLE,
258: buc_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
259: buc_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
260: buc_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
261: buc_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
262: buc_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
255: elmt_uned_tax_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
256: -- Amount to be allocated -- ADJ and APP
257: buc_alloc_amt DBMS_SQL.NUMBER_TABLE,
258: buc_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
259: buc_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
260: buc_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
261: buc_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
262: buc_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
263: buc_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
256: -- Amount to be allocated -- ADJ and APP
257: buc_alloc_amt DBMS_SQL.NUMBER_TABLE,
258: buc_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
259: buc_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
260: buc_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
261: buc_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
262: buc_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
263: buc_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
264: buc_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
257: buc_alloc_amt DBMS_SQL.NUMBER_TABLE,
258: buc_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
259: buc_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
260: buc_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
261: buc_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
262: buc_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
263: buc_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
264: buc_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
265: -- ED
258: buc_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
259: buc_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
260: buc_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
261: buc_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
262: buc_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
263: buc_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
264: buc_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
265: -- ED
266: buc_ed_alloc_amt DBMS_SQL.NUMBER_TABLE,
259: buc_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
260: buc_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
261: buc_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
262: buc_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
263: buc_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
264: buc_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
265: -- ED
266: buc_ed_alloc_amt DBMS_SQL.NUMBER_TABLE,
267: buc_ed_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
260: buc_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
261: buc_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
262: buc_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
263: buc_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
264: buc_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
265: -- ED
266: buc_ed_alloc_amt DBMS_SQL.NUMBER_TABLE,
267: buc_ed_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
268: buc_ed_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
262: buc_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
263: buc_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
264: buc_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
265: -- ED
266: buc_ed_alloc_amt DBMS_SQL.NUMBER_TABLE,
267: buc_ed_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
268: buc_ed_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
269: buc_ed_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
270: buc_ed_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
263: buc_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
264: buc_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
265: -- ED
266: buc_ed_alloc_amt DBMS_SQL.NUMBER_TABLE,
267: buc_ed_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
268: buc_ed_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
269: buc_ed_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
270: buc_ed_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
271: buc_ed_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
264: buc_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
265: -- ED
266: buc_ed_alloc_amt DBMS_SQL.NUMBER_TABLE,
267: buc_ed_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
268: buc_ed_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
269: buc_ed_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
270: buc_ed_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
271: buc_ed_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
272: buc_ed_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
265: -- ED
266: buc_ed_alloc_amt DBMS_SQL.NUMBER_TABLE,
267: buc_ed_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
268: buc_ed_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
269: buc_ed_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
270: buc_ed_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
271: buc_ed_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
272: buc_ed_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
273: buc_ed_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
266: buc_ed_alloc_amt DBMS_SQL.NUMBER_TABLE,
267: buc_ed_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
268: buc_ed_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
269: buc_ed_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
270: buc_ed_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
271: buc_ed_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
272: buc_ed_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
273: buc_ed_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
274: -- UNED
267: buc_ed_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
268: buc_ed_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
269: buc_ed_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
270: buc_ed_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
271: buc_ed_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
272: buc_ed_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
273: buc_ed_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
274: -- UNED
275: buc_uned_alloc_amt DBMS_SQL.NUMBER_TABLE,
268: buc_ed_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
269: buc_ed_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
270: buc_ed_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
271: buc_ed_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
272: buc_ed_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
273: buc_ed_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
274: -- UNED
275: buc_uned_alloc_amt DBMS_SQL.NUMBER_TABLE,
276: buc_uned_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
269: buc_ed_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
270: buc_ed_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
271: buc_ed_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
272: buc_ed_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
273: buc_ed_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
274: -- UNED
275: buc_uned_alloc_amt DBMS_SQL.NUMBER_TABLE,
276: buc_uned_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
277: buc_uned_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
271: buc_ed_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
272: buc_ed_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
273: buc_ed_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
274: -- UNED
275: buc_uned_alloc_amt DBMS_SQL.NUMBER_TABLE,
276: buc_uned_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
277: buc_uned_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
278: buc_uned_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
279: buc_uned_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
272: buc_ed_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
273: buc_ed_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
274: -- UNED
275: buc_uned_alloc_amt DBMS_SQL.NUMBER_TABLE,
276: buc_uned_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
277: buc_uned_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
278: buc_uned_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
279: buc_uned_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
280: buc_uned_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
273: buc_ed_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
274: -- UNED
275: buc_uned_alloc_amt DBMS_SQL.NUMBER_TABLE,
276: buc_uned_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
277: buc_uned_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
278: buc_uned_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
279: buc_uned_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
280: buc_uned_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
281: buc_uned_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
274: -- UNED
275: buc_uned_alloc_amt DBMS_SQL.NUMBER_TABLE,
276: buc_uned_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
277: buc_uned_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
278: buc_uned_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
279: buc_uned_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
280: buc_uned_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
281: buc_uned_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
282: buc_uned_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
275: buc_uned_alloc_amt DBMS_SQL.NUMBER_TABLE,
276: buc_uned_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
277: buc_uned_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
278: buc_uned_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
279: buc_uned_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
280: buc_uned_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
281: buc_uned_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
282: buc_uned_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
283: -- Currency
276: buc_uned_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
277: buc_uned_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
278: buc_uned_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
279: buc_uned_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
280: buc_uned_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
281: buc_uned_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
282: buc_uned_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
283: -- Currency
284: FROM_CURRENCY DBMS_SQL.VARCHAR2_TABLE,
277: buc_uned_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
278: buc_uned_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
279: buc_uned_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
280: buc_uned_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
281: buc_uned_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
282: buc_uned_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
283: -- Currency
284: FROM_CURRENCY DBMS_SQL.VARCHAR2_TABLE,
285: TO_CURRENCY DBMS_SQL.VARCHAR2_TABLE,
278: buc_uned_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
279: buc_uned_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
280: buc_uned_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
281: buc_uned_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
282: buc_uned_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
283: -- Currency
284: FROM_CURRENCY DBMS_SQL.VARCHAR2_TABLE,
285: TO_CURRENCY DBMS_SQL.VARCHAR2_TABLE,
286: BASE_CURRENCY DBMS_SQL.VARCHAR2_TABLE,
280: buc_uned_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
281: buc_uned_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
282: buc_uned_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
283: -- Currency
284: FROM_CURRENCY DBMS_SQL.VARCHAR2_TABLE,
285: TO_CURRENCY DBMS_SQL.VARCHAR2_TABLE,
286: BASE_CURRENCY DBMS_SQL.VARCHAR2_TABLE,
287: -- Result of the allocation
288: -- ADJ and APP
281: buc_uned_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
282: buc_uned_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
283: -- Currency
284: FROM_CURRENCY DBMS_SQL.VARCHAR2_TABLE,
285: TO_CURRENCY DBMS_SQL.VARCHAR2_TABLE,
286: BASE_CURRENCY DBMS_SQL.VARCHAR2_TABLE,
287: -- Result of the allocation
288: -- ADJ and APP
289: tl_alloc_amt DBMS_SQL.NUMBER_TABLE,
282: buc_uned_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
283: -- Currency
284: FROM_CURRENCY DBMS_SQL.VARCHAR2_TABLE,
285: TO_CURRENCY DBMS_SQL.VARCHAR2_TABLE,
286: BASE_CURRENCY DBMS_SQL.VARCHAR2_TABLE,
287: -- Result of the allocation
288: -- ADJ and APP
289: tl_alloc_amt DBMS_SQL.NUMBER_TABLE,
290: tl_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
285: TO_CURRENCY DBMS_SQL.VARCHAR2_TABLE,
286: BASE_CURRENCY DBMS_SQL.VARCHAR2_TABLE,
287: -- Result of the allocation
288: -- ADJ and APP
289: tl_alloc_amt DBMS_SQL.NUMBER_TABLE,
290: tl_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
291: tl_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
292: tl_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
293: tl_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
286: BASE_CURRENCY DBMS_SQL.VARCHAR2_TABLE,
287: -- Result of the allocation
288: -- ADJ and APP
289: tl_alloc_amt DBMS_SQL.NUMBER_TABLE,
290: tl_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
291: tl_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
292: tl_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
293: tl_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
294: tl_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
287: -- Result of the allocation
288: -- ADJ and APP
289: tl_alloc_amt DBMS_SQL.NUMBER_TABLE,
290: tl_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
291: tl_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
292: tl_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
293: tl_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
294: tl_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
295: tl_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
288: -- ADJ and APP
289: tl_alloc_amt DBMS_SQL.NUMBER_TABLE,
290: tl_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
291: tl_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
292: tl_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
293: tl_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
294: tl_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
295: tl_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
296: tl_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
289: tl_alloc_amt DBMS_SQL.NUMBER_TABLE,
290: tl_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
291: tl_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
292: tl_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
293: tl_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
294: tl_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
295: tl_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
296: tl_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
297: -- ED
290: tl_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
291: tl_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
292: tl_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
293: tl_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
294: tl_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
295: tl_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
296: tl_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
297: -- ED
298: tl_ed_alloc_amt DBMS_SQL.NUMBER_TABLE,
291: tl_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
292: tl_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
293: tl_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
294: tl_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
295: tl_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
296: tl_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
297: -- ED
298: tl_ed_alloc_amt DBMS_SQL.NUMBER_TABLE,
299: tl_ed_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
292: tl_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
293: tl_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
294: tl_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
295: tl_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
296: tl_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
297: -- ED
298: tl_ed_alloc_amt DBMS_SQL.NUMBER_TABLE,
299: tl_ed_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
300: tl_ed_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
294: tl_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
295: tl_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
296: tl_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
297: -- ED
298: tl_ed_alloc_amt DBMS_SQL.NUMBER_TABLE,
299: tl_ed_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
300: tl_ed_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
301: tl_ed_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
302: tl_ed_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
295: tl_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
296: tl_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
297: -- ED
298: tl_ed_alloc_amt DBMS_SQL.NUMBER_TABLE,
299: tl_ed_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
300: tl_ed_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
301: tl_ed_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
302: tl_ed_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
303: tl_ed_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
296: tl_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
297: -- ED
298: tl_ed_alloc_amt DBMS_SQL.NUMBER_TABLE,
299: tl_ed_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
300: tl_ed_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
301: tl_ed_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
302: tl_ed_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
303: tl_ed_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
304: tl_ed_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
297: -- ED
298: tl_ed_alloc_amt DBMS_SQL.NUMBER_TABLE,
299: tl_ed_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
300: tl_ed_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
301: tl_ed_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
302: tl_ed_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
303: tl_ed_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
304: tl_ed_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
305: tl_ed_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
298: tl_ed_alloc_amt DBMS_SQL.NUMBER_TABLE,
299: tl_ed_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
300: tl_ed_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
301: tl_ed_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
302: tl_ed_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
303: tl_ed_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
304: tl_ed_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
305: tl_ed_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
306: -- UNED
299: tl_ed_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
300: tl_ed_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
301: tl_ed_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
302: tl_ed_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
303: tl_ed_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
304: tl_ed_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
305: tl_ed_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
306: -- UNED
307: tl_uned_alloc_amt DBMS_SQL.NUMBER_TABLE,
300: tl_ed_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
301: tl_ed_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
302: tl_ed_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
303: tl_ed_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
304: tl_ed_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
305: tl_ed_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
306: -- UNED
307: tl_uned_alloc_amt DBMS_SQL.NUMBER_TABLE,
308: tl_uned_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
301: tl_ed_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
302: tl_ed_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
303: tl_ed_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
304: tl_ed_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
305: tl_ed_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
306: -- UNED
307: tl_uned_alloc_amt DBMS_SQL.NUMBER_TABLE,
308: tl_uned_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
309: tl_uned_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
303: tl_ed_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
304: tl_ed_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
305: tl_ed_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
306: -- UNED
307: tl_uned_alloc_amt DBMS_SQL.NUMBER_TABLE,
308: tl_uned_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
309: tl_uned_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
310: tl_uned_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
311: tl_uned_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
304: tl_ed_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
305: tl_ed_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
306: -- UNED
307: tl_uned_alloc_amt DBMS_SQL.NUMBER_TABLE,
308: tl_uned_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
309: tl_uned_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
310: tl_uned_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
311: tl_uned_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
312: tl_uned_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
305: tl_ed_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
306: -- UNED
307: tl_uned_alloc_amt DBMS_SQL.NUMBER_TABLE,
308: tl_uned_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
309: tl_uned_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
310: tl_uned_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
311: tl_uned_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
312: tl_uned_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
313: tl_uned_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
306: -- UNED
307: tl_uned_alloc_amt DBMS_SQL.NUMBER_TABLE,
308: tl_uned_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
309: tl_uned_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
310: tl_uned_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
311: tl_uned_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
312: tl_uned_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
313: tl_uned_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
314: tl_uned_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
307: tl_uned_alloc_amt DBMS_SQL.NUMBER_TABLE,
308: tl_uned_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
309: tl_uned_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
310: tl_uned_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
311: tl_uned_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
312: tl_uned_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
313: tl_uned_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
314: tl_uned_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
315: --
308: tl_uned_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
309: tl_uned_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
310: tl_uned_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
311: tl_uned_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
312: tl_uned_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
313: tl_uned_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
314: tl_uned_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
315: --
316: ROWID_ID DBMS_SQL.VARCHAR2_TABLE);
309: tl_uned_chrg_alloc_amt DBMS_SQL.NUMBER_TABLE,
310: tl_uned_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
311: tl_uned_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
312: tl_uned_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
313: tl_uned_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
314: tl_uned_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
315: --
316: ROWID_ID DBMS_SQL.VARCHAR2_TABLE);
317:
310: tl_uned_chrg_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
311: tl_uned_frt_alloc_amt DBMS_SQL.NUMBER_TABLE,
312: tl_uned_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
313: tl_uned_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
314: tl_uned_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
315: --
316: ROWID_ID DBMS_SQL.VARCHAR2_TABLE);
317:
318: --
312: tl_uned_frt_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
313: tl_uned_tax_alloc_amt DBMS_SQL.NUMBER_TABLE,
314: tl_uned_tax_alloc_acctd_amt DBMS_SQL.NUMBER_TABLE,
315: --
316: ROWID_ID DBMS_SQL.VARCHAR2_TABLE);
317:
318: --
319: -- Internal structure for safety on proration
320: --
318: --
319: -- Internal structure for safety on proration
320: --
321: TYPE group_tbl_type IS RECORD
322: ( GROUPE DBMS_SQL.VARCHAR2_TABLE,
323: -- ADJ and APP
324: RUN_ALLOC DBMS_SQL.NUMBER_TABLE,
325: RUN_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
326: RUN_AMT DBMS_SQL.NUMBER_TABLE,
320: --
321: TYPE group_tbl_type IS RECORD
322: ( GROUPE DBMS_SQL.VARCHAR2_TABLE,
323: -- ADJ and APP
324: RUN_ALLOC DBMS_SQL.NUMBER_TABLE,
325: RUN_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
326: RUN_AMT DBMS_SQL.NUMBER_TABLE,
327: RUN_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
328: RUN_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
321: TYPE group_tbl_type IS RECORD
322: ( GROUPE DBMS_SQL.VARCHAR2_TABLE,
323: -- ADJ and APP
324: RUN_ALLOC DBMS_SQL.NUMBER_TABLE,
325: RUN_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
326: RUN_AMT DBMS_SQL.NUMBER_TABLE,
327: RUN_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
328: RUN_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
329: RUN_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
322: ( GROUPE DBMS_SQL.VARCHAR2_TABLE,
323: -- ADJ and APP
324: RUN_ALLOC DBMS_SQL.NUMBER_TABLE,
325: RUN_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
326: RUN_AMT DBMS_SQL.NUMBER_TABLE,
327: RUN_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
328: RUN_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
329: RUN_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
330: RUN_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
323: -- ADJ and APP
324: RUN_ALLOC DBMS_SQL.NUMBER_TABLE,
325: RUN_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
326: RUN_AMT DBMS_SQL.NUMBER_TABLE,
327: RUN_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
328: RUN_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
329: RUN_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
330: RUN_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
331: RUN_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
324: RUN_ALLOC DBMS_SQL.NUMBER_TABLE,
325: RUN_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
326: RUN_AMT DBMS_SQL.NUMBER_TABLE,
327: RUN_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
328: RUN_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
329: RUN_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
330: RUN_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
331: RUN_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
332: RUN_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
325: RUN_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
326: RUN_AMT DBMS_SQL.NUMBER_TABLE,
327: RUN_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
328: RUN_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
329: RUN_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
330: RUN_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
331: RUN_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
332: RUN_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
333: RUN_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
326: RUN_AMT DBMS_SQL.NUMBER_TABLE,
327: RUN_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
328: RUN_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
329: RUN_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
330: RUN_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
331: RUN_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
332: RUN_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
333: RUN_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
334: RUN_FRT_AMT DBMS_SQL.NUMBER_TABLE,
327: RUN_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
328: RUN_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
329: RUN_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
330: RUN_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
331: RUN_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
332: RUN_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
333: RUN_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
334: RUN_FRT_AMT DBMS_SQL.NUMBER_TABLE,
335: RUN_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
328: RUN_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
329: RUN_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
330: RUN_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
331: RUN_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
332: RUN_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
333: RUN_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
334: RUN_FRT_AMT DBMS_SQL.NUMBER_TABLE,
335: RUN_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
336: RUN_TAX_ALLOC DBMS_SQL.NUMBER_TABLE,
329: RUN_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
330: RUN_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
331: RUN_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
332: RUN_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
333: RUN_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
334: RUN_FRT_AMT DBMS_SQL.NUMBER_TABLE,
335: RUN_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
336: RUN_TAX_ALLOC DBMS_SQL.NUMBER_TABLE,
337: RUN_TAX_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
330: RUN_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
331: RUN_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
332: RUN_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
333: RUN_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
334: RUN_FRT_AMT DBMS_SQL.NUMBER_TABLE,
335: RUN_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
336: RUN_TAX_ALLOC DBMS_SQL.NUMBER_TABLE,
337: RUN_TAX_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
338: RUN_TAX_AMT DBMS_SQL.NUMBER_TABLE,
331: RUN_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
332: RUN_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
333: RUN_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
334: RUN_FRT_AMT DBMS_SQL.NUMBER_TABLE,
335: RUN_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
336: RUN_TAX_ALLOC DBMS_SQL.NUMBER_TABLE,
337: RUN_TAX_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
338: RUN_TAX_AMT DBMS_SQL.NUMBER_TABLE,
339: RUN_TAX_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
332: RUN_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
333: RUN_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
334: RUN_FRT_AMT DBMS_SQL.NUMBER_TABLE,
335: RUN_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
336: RUN_TAX_ALLOC DBMS_SQL.NUMBER_TABLE,
337: RUN_TAX_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
338: RUN_TAX_AMT DBMS_SQL.NUMBER_TABLE,
339: RUN_TAX_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
340: -- ED
333: RUN_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
334: RUN_FRT_AMT DBMS_SQL.NUMBER_TABLE,
335: RUN_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
336: RUN_TAX_ALLOC DBMS_SQL.NUMBER_TABLE,
337: RUN_TAX_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
338: RUN_TAX_AMT DBMS_SQL.NUMBER_TABLE,
339: RUN_TAX_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
340: -- ED
341: RUN_ED_ALLOC DBMS_SQL.NUMBER_TABLE,
334: RUN_FRT_AMT DBMS_SQL.NUMBER_TABLE,
335: RUN_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
336: RUN_TAX_ALLOC DBMS_SQL.NUMBER_TABLE,
337: RUN_TAX_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
338: RUN_TAX_AMT DBMS_SQL.NUMBER_TABLE,
339: RUN_TAX_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
340: -- ED
341: RUN_ED_ALLOC DBMS_SQL.NUMBER_TABLE,
342: RUN_ED_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
335: RUN_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
336: RUN_TAX_ALLOC DBMS_SQL.NUMBER_TABLE,
337: RUN_TAX_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
338: RUN_TAX_AMT DBMS_SQL.NUMBER_TABLE,
339: RUN_TAX_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
340: -- ED
341: RUN_ED_ALLOC DBMS_SQL.NUMBER_TABLE,
342: RUN_ED_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
343: RUN_ED_AMT DBMS_SQL.NUMBER_TABLE,
337: RUN_TAX_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
338: RUN_TAX_AMT DBMS_SQL.NUMBER_TABLE,
339: RUN_TAX_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
340: -- ED
341: RUN_ED_ALLOC DBMS_SQL.NUMBER_TABLE,
342: RUN_ED_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
343: RUN_ED_AMT DBMS_SQL.NUMBER_TABLE,
344: RUN_ED_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
345: RUN_ED_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
338: RUN_TAX_AMT DBMS_SQL.NUMBER_TABLE,
339: RUN_TAX_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
340: -- ED
341: RUN_ED_ALLOC DBMS_SQL.NUMBER_TABLE,
342: RUN_ED_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
343: RUN_ED_AMT DBMS_SQL.NUMBER_TABLE,
344: RUN_ED_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
345: RUN_ED_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
346: RUN_ED_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
339: RUN_TAX_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
340: -- ED
341: RUN_ED_ALLOC DBMS_SQL.NUMBER_TABLE,
342: RUN_ED_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
343: RUN_ED_AMT DBMS_SQL.NUMBER_TABLE,
344: RUN_ED_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
345: RUN_ED_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
346: RUN_ED_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
347: RUN_ED_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
340: -- ED
341: RUN_ED_ALLOC DBMS_SQL.NUMBER_TABLE,
342: RUN_ED_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
343: RUN_ED_AMT DBMS_SQL.NUMBER_TABLE,
344: RUN_ED_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
345: RUN_ED_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
346: RUN_ED_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
347: RUN_ED_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
348: RUN_ED_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
341: RUN_ED_ALLOC DBMS_SQL.NUMBER_TABLE,
342: RUN_ED_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
343: RUN_ED_AMT DBMS_SQL.NUMBER_TABLE,
344: RUN_ED_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
345: RUN_ED_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
346: RUN_ED_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
347: RUN_ED_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
348: RUN_ED_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
349: RUN_ED_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
342: RUN_ED_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
343: RUN_ED_AMT DBMS_SQL.NUMBER_TABLE,
344: RUN_ED_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
345: RUN_ED_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
346: RUN_ED_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
347: RUN_ED_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
348: RUN_ED_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
349: RUN_ED_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
350: RUN_ED_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
343: RUN_ED_AMT DBMS_SQL.NUMBER_TABLE,
344: RUN_ED_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
345: RUN_ED_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
346: RUN_ED_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
347: RUN_ED_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
348: RUN_ED_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
349: RUN_ED_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
350: RUN_ED_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
351: RUN_ED_FRT_AMT DBMS_SQL.NUMBER_TABLE,
344: RUN_ED_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
345: RUN_ED_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
346: RUN_ED_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
347: RUN_ED_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
348: RUN_ED_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
349: RUN_ED_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
350: RUN_ED_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
351: RUN_ED_FRT_AMT DBMS_SQL.NUMBER_TABLE,
352: RUN_ED_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
345: RUN_ED_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
346: RUN_ED_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
347: RUN_ED_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
348: RUN_ED_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
349: RUN_ED_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
350: RUN_ED_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
351: RUN_ED_FRT_AMT DBMS_SQL.NUMBER_TABLE,
352: RUN_ED_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
353: RUN_ED_TAX_ALLOC DBMS_SQL.NUMBER_TABLE,
346: RUN_ED_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
347: RUN_ED_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
348: RUN_ED_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
349: RUN_ED_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
350: RUN_ED_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
351: RUN_ED_FRT_AMT DBMS_SQL.NUMBER_TABLE,
352: RUN_ED_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
353: RUN_ED_TAX_ALLOC DBMS_SQL.NUMBER_TABLE,
354: RUN_ED_TAX_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
347: RUN_ED_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
348: RUN_ED_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
349: RUN_ED_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
350: RUN_ED_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
351: RUN_ED_FRT_AMT DBMS_SQL.NUMBER_TABLE,
352: RUN_ED_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
353: RUN_ED_TAX_ALLOC DBMS_SQL.NUMBER_TABLE,
354: RUN_ED_TAX_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
355: RUN_ED_TAX_AMT DBMS_SQL.NUMBER_TABLE,
348: RUN_ED_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
349: RUN_ED_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
350: RUN_ED_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
351: RUN_ED_FRT_AMT DBMS_SQL.NUMBER_TABLE,
352: RUN_ED_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
353: RUN_ED_TAX_ALLOC DBMS_SQL.NUMBER_TABLE,
354: RUN_ED_TAX_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
355: RUN_ED_TAX_AMT DBMS_SQL.NUMBER_TABLE,
356: RUN_ED_TAX_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
349: RUN_ED_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
350: RUN_ED_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
351: RUN_ED_FRT_AMT DBMS_SQL.NUMBER_TABLE,
352: RUN_ED_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
353: RUN_ED_TAX_ALLOC DBMS_SQL.NUMBER_TABLE,
354: RUN_ED_TAX_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
355: RUN_ED_TAX_AMT DBMS_SQL.NUMBER_TABLE,
356: RUN_ED_TAX_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
357: -- UNED
350: RUN_ED_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
351: RUN_ED_FRT_AMT DBMS_SQL.NUMBER_TABLE,
352: RUN_ED_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
353: RUN_ED_TAX_ALLOC DBMS_SQL.NUMBER_TABLE,
354: RUN_ED_TAX_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
355: RUN_ED_TAX_AMT DBMS_SQL.NUMBER_TABLE,
356: RUN_ED_TAX_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
357: -- UNED
358: RUN_UNED_ALLOC DBMS_SQL.NUMBER_TABLE,
351: RUN_ED_FRT_AMT DBMS_SQL.NUMBER_TABLE,
352: RUN_ED_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
353: RUN_ED_TAX_ALLOC DBMS_SQL.NUMBER_TABLE,
354: RUN_ED_TAX_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
355: RUN_ED_TAX_AMT DBMS_SQL.NUMBER_TABLE,
356: RUN_ED_TAX_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
357: -- UNED
358: RUN_UNED_ALLOC DBMS_SQL.NUMBER_TABLE,
359: RUN_UNED_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
352: RUN_ED_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
353: RUN_ED_TAX_ALLOC DBMS_SQL.NUMBER_TABLE,
354: RUN_ED_TAX_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
355: RUN_ED_TAX_AMT DBMS_SQL.NUMBER_TABLE,
356: RUN_ED_TAX_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
357: -- UNED
358: RUN_UNED_ALLOC DBMS_SQL.NUMBER_TABLE,
359: RUN_UNED_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
360: RUN_UNED_AMT DBMS_SQL.NUMBER_TABLE,
354: RUN_ED_TAX_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
355: RUN_ED_TAX_AMT DBMS_SQL.NUMBER_TABLE,
356: RUN_ED_TAX_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
357: -- UNED
358: RUN_UNED_ALLOC DBMS_SQL.NUMBER_TABLE,
359: RUN_UNED_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
360: RUN_UNED_AMT DBMS_SQL.NUMBER_TABLE,
361: RUN_UNED_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
362: RUN_UNED_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
355: RUN_ED_TAX_AMT DBMS_SQL.NUMBER_TABLE,
356: RUN_ED_TAX_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
357: -- UNED
358: RUN_UNED_ALLOC DBMS_SQL.NUMBER_TABLE,
359: RUN_UNED_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
360: RUN_UNED_AMT DBMS_SQL.NUMBER_TABLE,
361: RUN_UNED_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
362: RUN_UNED_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
363: RUN_UNED_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
356: RUN_ED_TAX_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
357: -- UNED
358: RUN_UNED_ALLOC DBMS_SQL.NUMBER_TABLE,
359: RUN_UNED_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
360: RUN_UNED_AMT DBMS_SQL.NUMBER_TABLE,
361: RUN_UNED_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
362: RUN_UNED_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
363: RUN_UNED_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
364: RUN_UNED_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
357: -- UNED
358: RUN_UNED_ALLOC DBMS_SQL.NUMBER_TABLE,
359: RUN_UNED_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
360: RUN_UNED_AMT DBMS_SQL.NUMBER_TABLE,
361: RUN_UNED_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
362: RUN_UNED_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
363: RUN_UNED_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
364: RUN_UNED_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
365: RUN_UNED_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
358: RUN_UNED_ALLOC DBMS_SQL.NUMBER_TABLE,
359: RUN_UNED_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
360: RUN_UNED_AMT DBMS_SQL.NUMBER_TABLE,
361: RUN_UNED_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
362: RUN_UNED_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
363: RUN_UNED_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
364: RUN_UNED_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
365: RUN_UNED_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
366: RUN_UNED_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
359: RUN_UNED_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
360: RUN_UNED_AMT DBMS_SQL.NUMBER_TABLE,
361: RUN_UNED_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
362: RUN_UNED_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
363: RUN_UNED_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
364: RUN_UNED_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
365: RUN_UNED_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
366: RUN_UNED_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
367: RUN_UNED_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
360: RUN_UNED_AMT DBMS_SQL.NUMBER_TABLE,
361: RUN_UNED_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
362: RUN_UNED_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
363: RUN_UNED_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
364: RUN_UNED_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
365: RUN_UNED_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
366: RUN_UNED_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
367: RUN_UNED_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
368: RUN_UNED_FRT_AMT DBMS_SQL.NUMBER_TABLE,
361: RUN_UNED_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
362: RUN_UNED_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
363: RUN_UNED_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
364: RUN_UNED_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
365: RUN_UNED_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
366: RUN_UNED_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
367: RUN_UNED_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
368: RUN_UNED_FRT_AMT DBMS_SQL.NUMBER_TABLE,
369: RUN_UNED_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
362: RUN_UNED_CHRG_ALLOC DBMS_SQL.NUMBER_TABLE,
363: RUN_UNED_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
364: RUN_UNED_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
365: RUN_UNED_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
366: RUN_UNED_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
367: RUN_UNED_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
368: RUN_UNED_FRT_AMT DBMS_SQL.NUMBER_TABLE,
369: RUN_UNED_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
370: RUN_UNED_TAX_ALLOC DBMS_SQL.NUMBER_TABLE,
363: RUN_UNED_CHRG_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
364: RUN_UNED_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
365: RUN_UNED_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
366: RUN_UNED_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
367: RUN_UNED_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
368: RUN_UNED_FRT_AMT DBMS_SQL.NUMBER_TABLE,
369: RUN_UNED_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
370: RUN_UNED_TAX_ALLOC DBMS_SQL.NUMBER_TABLE,
371: RUN_UNED_TAX_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
364: RUN_UNED_CHRG_AMT DBMS_SQL.NUMBER_TABLE,
365: RUN_UNED_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
366: RUN_UNED_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
367: RUN_UNED_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
368: RUN_UNED_FRT_AMT DBMS_SQL.NUMBER_TABLE,
369: RUN_UNED_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
370: RUN_UNED_TAX_ALLOC DBMS_SQL.NUMBER_TABLE,
371: RUN_UNED_TAX_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
372: RUN_UNED_TAX_AMT DBMS_SQL.NUMBER_TABLE,
365: RUN_UNED_CHRG_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
366: RUN_UNED_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
367: RUN_UNED_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
368: RUN_UNED_FRT_AMT DBMS_SQL.NUMBER_TABLE,
369: RUN_UNED_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
370: RUN_UNED_TAX_ALLOC DBMS_SQL.NUMBER_TABLE,
371: RUN_UNED_TAX_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
372: RUN_UNED_TAX_AMT DBMS_SQL.NUMBER_TABLE,
373: RUN_UNED_TAX_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
366: RUN_UNED_FRT_ALLOC DBMS_SQL.NUMBER_TABLE,
367: RUN_UNED_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
368: RUN_UNED_FRT_AMT DBMS_SQL.NUMBER_TABLE,
369: RUN_UNED_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
370: RUN_UNED_TAX_ALLOC DBMS_SQL.NUMBER_TABLE,
371: RUN_UNED_TAX_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
372: RUN_UNED_TAX_AMT DBMS_SQL.NUMBER_TABLE,
373: RUN_UNED_TAX_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
374: GROUPE_INDEX CHAR_HASH_TABLE);
367: RUN_UNED_FRT_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
368: RUN_UNED_FRT_AMT DBMS_SQL.NUMBER_TABLE,
369: RUN_UNED_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
370: RUN_UNED_TAX_ALLOC DBMS_SQL.NUMBER_TABLE,
371: RUN_UNED_TAX_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
372: RUN_UNED_TAX_AMT DBMS_SQL.NUMBER_TABLE,
373: RUN_UNED_TAX_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
374: GROUPE_INDEX CHAR_HASH_TABLE);
375:
368: RUN_UNED_FRT_AMT DBMS_SQL.NUMBER_TABLE,
369: RUN_UNED_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
370: RUN_UNED_TAX_ALLOC DBMS_SQL.NUMBER_TABLE,
371: RUN_UNED_TAX_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
372: RUN_UNED_TAX_AMT DBMS_SQL.NUMBER_TABLE,
373: RUN_UNED_TAX_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
374: GROUPE_INDEX CHAR_HASH_TABLE);
375:
376:
369: RUN_UNED_FRT_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
370: RUN_UNED_TAX_ALLOC DBMS_SQL.NUMBER_TABLE,
371: RUN_UNED_TAX_ACCTD_ALLOC DBMS_SQL.NUMBER_TABLE,
372: RUN_UNED_TAX_AMT DBMS_SQL.NUMBER_TABLE,
373: RUN_UNED_TAX_ACCTD_AMT DBMS_SQL.NUMBER_TABLE,
374: GROUPE_INDEX CHAR_HASH_TABLE);
375:
376:
377: --HY Cash Basis Upgrade
8069: FROM ra_cust_trx_line_gl_dist
8070: WHERE customer_trx_id = p_customer_trx_id
8071: GROUP BY customer_trx_line_id;
8072:
8073: l_amt_tab DBMS_SQL.NUMBER_TABLE;
8074: l_acctd_amt_tab DBMS_SQL.NUMBER_TABLE;
8075: l_ctl_tab DBMS_SQL.NUMBER_TABLE;
8076: l_last_fetch BOOLEAN := FALSE;
8077: l_found VARCHAR2(1) := 'N';
8070: WHERE customer_trx_id = p_customer_trx_id
8071: GROUP BY customer_trx_line_id;
8072:
8073: l_amt_tab DBMS_SQL.NUMBER_TABLE;
8074: l_acctd_amt_tab DBMS_SQL.NUMBER_TABLE;
8075: l_ctl_tab DBMS_SQL.NUMBER_TABLE;
8076: l_last_fetch BOOLEAN := FALSE;
8077: l_found VARCHAR2(1) := 'N';
8078: l_trx_type VARCHAR2(30);
8071: GROUP BY customer_trx_line_id;
8072:
8073: l_amt_tab DBMS_SQL.NUMBER_TABLE;
8074: l_acctd_amt_tab DBMS_SQL.NUMBER_TABLE;
8075: l_ctl_tab DBMS_SQL.NUMBER_TABLE;
8076: l_last_fetch BOOLEAN := FALSE;
8077: l_found VARCHAR2(1) := 'N';
8078: l_trx_type VARCHAR2(30);
8079: l_c c%ROWTYPE;
8172: customer_trx_line_id customer_trx_line_id
8173: FROM psa_mf_balances_view
8174: WHERE customer_trx_id = p_customer_trx_id
8175: GROUP BY customer_trx_line_id;
8176: l_rem_amt_tab DBMS_SQL.NUMBER_TABLE;
8177: l_orig_amt_tab DBMS_SQL.NUMBER_TABLE;
8178: l_ctl_tab DBMS_SQL.NUMBER_TABLE;
8179: l_last_fetch BOOLEAN := FALSE;
8180: l_found VARCHAR2(1);
8173: FROM psa_mf_balances_view
8174: WHERE customer_trx_id = p_customer_trx_id
8175: GROUP BY customer_trx_line_id;
8176: l_rem_amt_tab DBMS_SQL.NUMBER_TABLE;
8177: l_orig_amt_tab DBMS_SQL.NUMBER_TABLE;
8178: l_ctl_tab DBMS_SQL.NUMBER_TABLE;
8179: l_last_fetch BOOLEAN := FALSE;
8180: l_found VARCHAR2(1);
8181: BEGIN
8174: WHERE customer_trx_id = p_customer_trx_id
8175: GROUP BY customer_trx_line_id;
8176: l_rem_amt_tab DBMS_SQL.NUMBER_TABLE;
8177: l_orig_amt_tab DBMS_SQL.NUMBER_TABLE;
8178: l_ctl_tab DBMS_SQL.NUMBER_TABLE;
8179: l_last_fetch BOOLEAN := FALSE;
8180: l_found VARCHAR2(1);
8181: BEGIN
8182: IF PG_DEBUG = 'Y' THEN
8308: GROUP BY a.ref_customer_trx_line_id,
8309: b.sum_orig,
8310: b.sum_acctd_orig;
8311:
8312: l_sum_orig DBMS_SQL.NUMBER_TABLE;
8313: l_sum_acctd_orig DBMS_SQL.NUMBER_TABLE;
8314: l_CHRG_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
8315: l_ACCTD_CHRG_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
8316: l_FRT_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
8309: b.sum_orig,
8310: b.sum_acctd_orig;
8311:
8312: l_sum_orig DBMS_SQL.NUMBER_TABLE;
8313: l_sum_acctd_orig DBMS_SQL.NUMBER_TABLE;
8314: l_CHRG_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
8315: l_ACCTD_CHRG_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
8316: l_FRT_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
8317: l_ACCTD_FRT_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
8310: b.sum_acctd_orig;
8311:
8312: l_sum_orig DBMS_SQL.NUMBER_TABLE;
8313: l_sum_acctd_orig DBMS_SQL.NUMBER_TABLE;
8314: l_CHRG_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
8315: l_ACCTD_CHRG_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
8316: l_FRT_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
8317: l_ACCTD_FRT_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
8318: l_ED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
8311:
8312: l_sum_orig DBMS_SQL.NUMBER_TABLE;
8313: l_sum_acctd_orig DBMS_SQL.NUMBER_TABLE;
8314: l_CHRG_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
8315: l_ACCTD_CHRG_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
8316: l_FRT_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
8317: l_ACCTD_FRT_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
8318: l_ED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
8319: l_ACCTD_ED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
8312: l_sum_orig DBMS_SQL.NUMBER_TABLE;
8313: l_sum_acctd_orig DBMS_SQL.NUMBER_TABLE;
8314: l_CHRG_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
8315: l_ACCTD_CHRG_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
8316: l_FRT_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
8317: l_ACCTD_FRT_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
8318: l_ED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
8319: l_ACCTD_ED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
8320: l_UNED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
8313: l_sum_acctd_orig DBMS_SQL.NUMBER_TABLE;
8314: l_CHRG_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
8315: l_ACCTD_CHRG_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
8316: l_FRT_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
8317: l_ACCTD_FRT_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
8318: l_ED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
8319: l_ACCTD_ED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
8320: l_UNED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
8321: l_ACCTD_UNED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
8314: l_CHRG_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
8315: l_ACCTD_CHRG_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
8316: l_FRT_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
8317: l_ACCTD_FRT_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
8318: l_ED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
8319: l_ACCTD_ED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
8320: l_UNED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
8321: l_ACCTD_UNED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
8322: l_REM_TYPE_LINE DBMS_SQL.VARCHAR2_TABLE;
8315: l_ACCTD_CHRG_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
8316: l_FRT_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
8317: l_ACCTD_FRT_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
8318: l_ED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
8319: l_ACCTD_ED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
8320: l_UNED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
8321: l_ACCTD_UNED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
8322: l_REM_TYPE_LINE DBMS_SQL.VARCHAR2_TABLE;
8323: l_ACCTD_REM_TYPE_LINE DBMS_SQL.NUMBER_TABLE;
8316: l_FRT_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
8317: l_ACCTD_FRT_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
8318: l_ED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
8319: l_ACCTD_ED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
8320: l_UNED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
8321: l_ACCTD_UNED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
8322: l_REM_TYPE_LINE DBMS_SQL.VARCHAR2_TABLE;
8323: l_ACCTD_REM_TYPE_LINE DBMS_SQL.NUMBER_TABLE;
8324: l_CUSTOMER_TRX_LINE_ID DBMS_SQL.NUMBER_TABLE;
8317: l_ACCTD_FRT_ON_REV_LINE DBMS_SQL.NUMBER_TABLE;
8318: l_ED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
8319: l_ACCTD_ED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
8320: l_UNED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
8321: l_ACCTD_UNED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
8322: l_REM_TYPE_LINE DBMS_SQL.VARCHAR2_TABLE;
8323: l_ACCTD_REM_TYPE_LINE DBMS_SQL.NUMBER_TABLE;
8324: l_CUSTOMER_TRX_LINE_ID DBMS_SQL.NUMBER_TABLE;
8325:
8318: l_ED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
8319: l_ACCTD_ED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
8320: l_UNED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
8321: l_ACCTD_UNED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
8322: l_REM_TYPE_LINE DBMS_SQL.VARCHAR2_TABLE;
8323: l_ACCTD_REM_TYPE_LINE DBMS_SQL.NUMBER_TABLE;
8324: l_CUSTOMER_TRX_LINE_ID DBMS_SQL.NUMBER_TABLE;
8325:
8326: l_last_fetch BOOLEAN := FALSE;
8319: l_ACCTD_ED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
8320: l_UNED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
8321: l_ACCTD_UNED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
8322: l_REM_TYPE_LINE DBMS_SQL.VARCHAR2_TABLE;
8323: l_ACCTD_REM_TYPE_LINE DBMS_SQL.NUMBER_TABLE;
8324: l_CUSTOMER_TRX_LINE_ID DBMS_SQL.NUMBER_TABLE;
8325:
8326: l_last_fetch BOOLEAN := FALSE;
8327:
8320: l_UNED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
8321: l_ACCTD_UNED_FRT_REV_LINE DBMS_SQL.NUMBER_TABLE;
8322: l_REM_TYPE_LINE DBMS_SQL.VARCHAR2_TABLE;
8323: l_ACCTD_REM_TYPE_LINE DBMS_SQL.NUMBER_TABLE;
8324: l_CUSTOMER_TRX_LINE_ID DBMS_SQL.NUMBER_TABLE;
8325:
8326: l_last_fetch BOOLEAN := FALSE;
8327:
8328: BEGIN
8432: );
8433:
8434:
8435:
8436: l_amt_tab DBMS_SQL.NUMBER_TABLE;
8437: l_acctd_amt_tab DBMS_SQL.NUMBER_TABLE;
8438: l_ctl_tab DBMS_SQL.NUMBER_TABLE;
8439: l_ctl_hd_tab DBMS_SQL.NUMBER_TABLE;
8440: l_ctl_app_tab DBMS_SQL.NUMBER_TABLE;
8433:
8434:
8435:
8436: l_amt_tab DBMS_SQL.NUMBER_TABLE;
8437: l_acctd_amt_tab DBMS_SQL.NUMBER_TABLE;
8438: l_ctl_tab DBMS_SQL.NUMBER_TABLE;
8439: l_ctl_hd_tab DBMS_SQL.NUMBER_TABLE;
8440: l_ctl_app_tab DBMS_SQL.NUMBER_TABLE;
8441: l_customer_trx ra_customer_trx%ROWTYPE;
8434:
8435:
8436: l_amt_tab DBMS_SQL.NUMBER_TABLE;
8437: l_acctd_amt_tab DBMS_SQL.NUMBER_TABLE;
8438: l_ctl_tab DBMS_SQL.NUMBER_TABLE;
8439: l_ctl_hd_tab DBMS_SQL.NUMBER_TABLE;
8440: l_ctl_app_tab DBMS_SQL.NUMBER_TABLE;
8441: l_customer_trx ra_customer_trx%ROWTYPE;
8442: l_last_fetch BOOLEAN := FALSE;
8435:
8436: l_amt_tab DBMS_SQL.NUMBER_TABLE;
8437: l_acctd_amt_tab DBMS_SQL.NUMBER_TABLE;
8438: l_ctl_tab DBMS_SQL.NUMBER_TABLE;
8439: l_ctl_hd_tab DBMS_SQL.NUMBER_TABLE;
8440: l_ctl_app_tab DBMS_SQL.NUMBER_TABLE;
8441: l_customer_trx ra_customer_trx%ROWTYPE;
8442: l_last_fetch BOOLEAN := FALSE;
8443:
8436: l_amt_tab DBMS_SQL.NUMBER_TABLE;
8437: l_acctd_amt_tab DBMS_SQL.NUMBER_TABLE;
8438: l_ctl_tab DBMS_SQL.NUMBER_TABLE;
8439: l_ctl_hd_tab DBMS_SQL.NUMBER_TABLE;
8440: l_ctl_app_tab DBMS_SQL.NUMBER_TABLE;
8441: l_customer_trx ra_customer_trx%ROWTYPE;
8442: l_last_fetch BOOLEAN := FALSE;
8443:
8444: l_msg RA_INTERFACE_ERRORS.MESSAGE_TEXT%TYPE;
9433: FROM ra_customer_trx
9434: WHERE customer_trx_id = p_customer_trx_id;
9435: l_inv_currency VARCHAR2(30) := NULL;
9436: l_exchange_rate ra_customer_trx.exchange_rate%type;
9437: l_sum_line_rem_amt DBMS_SQL.NUMBER_TABLE;
9438: l_sum_line_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
9439: l_sum_line_orig_amt DBMS_SQL.NUMBER_TABLE;
9440: l_sum_line_orig_acctd_amt DBMS_SQL.NUMBER_TABLE;
9441: l_sum_line_chrg_rem_amt DBMS_SQL.NUMBER_TABLE;
9434: WHERE customer_trx_id = p_customer_trx_id;
9435: l_inv_currency VARCHAR2(30) := NULL;
9436: l_exchange_rate ra_customer_trx.exchange_rate%type;
9437: l_sum_line_rem_amt DBMS_SQL.NUMBER_TABLE;
9438: l_sum_line_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
9439: l_sum_line_orig_amt DBMS_SQL.NUMBER_TABLE;
9440: l_sum_line_orig_acctd_amt DBMS_SQL.NUMBER_TABLE;
9441: l_sum_line_chrg_rem_amt DBMS_SQL.NUMBER_TABLE;
9442: l_sum_line_chrg_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
9435: l_inv_currency VARCHAR2(30) := NULL;
9436: l_exchange_rate ra_customer_trx.exchange_rate%type;
9437: l_sum_line_rem_amt DBMS_SQL.NUMBER_TABLE;
9438: l_sum_line_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
9439: l_sum_line_orig_amt DBMS_SQL.NUMBER_TABLE;
9440: l_sum_line_orig_acctd_amt DBMS_SQL.NUMBER_TABLE;
9441: l_sum_line_chrg_rem_amt DBMS_SQL.NUMBER_TABLE;
9442: l_sum_line_chrg_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
9443: --
9436: l_exchange_rate ra_customer_trx.exchange_rate%type;
9437: l_sum_line_rem_amt DBMS_SQL.NUMBER_TABLE;
9438: l_sum_line_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
9439: l_sum_line_orig_amt DBMS_SQL.NUMBER_TABLE;
9440: l_sum_line_orig_acctd_amt DBMS_SQL.NUMBER_TABLE;
9441: l_sum_line_chrg_rem_amt DBMS_SQL.NUMBER_TABLE;
9442: l_sum_line_chrg_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
9443: --
9444: l_sum_line_frt_rem_amt DBMS_SQL.NUMBER_TABLE;
9437: l_sum_line_rem_amt DBMS_SQL.NUMBER_TABLE;
9438: l_sum_line_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
9439: l_sum_line_orig_amt DBMS_SQL.NUMBER_TABLE;
9440: l_sum_line_orig_acctd_amt DBMS_SQL.NUMBER_TABLE;
9441: l_sum_line_chrg_rem_amt DBMS_SQL.NUMBER_TABLE;
9442: l_sum_line_chrg_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
9443: --
9444: l_sum_line_frt_rem_amt DBMS_SQL.NUMBER_TABLE;
9445: l_sum_line_frt_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
9438: l_sum_line_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
9439: l_sum_line_orig_amt DBMS_SQL.NUMBER_TABLE;
9440: l_sum_line_orig_acctd_amt DBMS_SQL.NUMBER_TABLE;
9441: l_sum_line_chrg_rem_amt DBMS_SQL.NUMBER_TABLE;
9442: l_sum_line_chrg_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
9443: --
9444: l_sum_line_frt_rem_amt DBMS_SQL.NUMBER_TABLE;
9445: l_sum_line_frt_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
9446: l_sum_line_frt_orig_amt DBMS_SQL.NUMBER_TABLE;
9440: l_sum_line_orig_acctd_amt DBMS_SQL.NUMBER_TABLE;
9441: l_sum_line_chrg_rem_amt DBMS_SQL.NUMBER_TABLE;
9442: l_sum_line_chrg_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
9443: --
9444: l_sum_line_frt_rem_amt DBMS_SQL.NUMBER_TABLE;
9445: l_sum_line_frt_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
9446: l_sum_line_frt_orig_amt DBMS_SQL.NUMBER_TABLE;
9447: l_sum_line_frt_orig_acctd_amt DBMS_SQL.NUMBER_TABLE;
9448: --
9441: l_sum_line_chrg_rem_amt DBMS_SQL.NUMBER_TABLE;
9442: l_sum_line_chrg_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
9443: --
9444: l_sum_line_frt_rem_amt DBMS_SQL.NUMBER_TABLE;
9445: l_sum_line_frt_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
9446: l_sum_line_frt_orig_amt DBMS_SQL.NUMBER_TABLE;
9447: l_sum_line_frt_orig_acctd_amt DBMS_SQL.NUMBER_TABLE;
9448: --
9449: l_sum_line_tax_rem_amt DBMS_SQL.NUMBER_TABLE;
9442: l_sum_line_chrg_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
9443: --
9444: l_sum_line_frt_rem_amt DBMS_SQL.NUMBER_TABLE;
9445: l_sum_line_frt_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
9446: l_sum_line_frt_orig_amt DBMS_SQL.NUMBER_TABLE;
9447: l_sum_line_frt_orig_acctd_amt DBMS_SQL.NUMBER_TABLE;
9448: --
9449: l_sum_line_tax_rem_amt DBMS_SQL.NUMBER_TABLE;
9450: l_sum_line_tax_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
9443: --
9444: l_sum_line_frt_rem_amt DBMS_SQL.NUMBER_TABLE;
9445: l_sum_line_frt_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
9446: l_sum_line_frt_orig_amt DBMS_SQL.NUMBER_TABLE;
9447: l_sum_line_frt_orig_acctd_amt DBMS_SQL.NUMBER_TABLE;
9448: --
9449: l_sum_line_tax_rem_amt DBMS_SQL.NUMBER_TABLE;
9450: l_sum_line_tax_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
9451: l_sum_line_tax_orig_amt DBMS_SQL.NUMBER_TABLE;
9445: l_sum_line_frt_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
9446: l_sum_line_frt_orig_amt DBMS_SQL.NUMBER_TABLE;
9447: l_sum_line_frt_orig_acctd_amt DBMS_SQL.NUMBER_TABLE;
9448: --
9449: l_sum_line_tax_rem_amt DBMS_SQL.NUMBER_TABLE;
9450: l_sum_line_tax_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
9451: l_sum_line_tax_orig_amt DBMS_SQL.NUMBER_TABLE;
9452: l_sum_line_tax_orig_acctd_amt DBMS_SQL.NUMBER_TABLE;
9453: --
9446: l_sum_line_frt_orig_amt DBMS_SQL.NUMBER_TABLE;
9447: l_sum_line_frt_orig_acctd_amt DBMS_SQL.NUMBER_TABLE;
9448: --
9449: l_sum_line_tax_rem_amt DBMS_SQL.NUMBER_TABLE;
9450: l_sum_line_tax_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
9451: l_sum_line_tax_orig_amt DBMS_SQL.NUMBER_TABLE;
9452: l_sum_line_tax_orig_acctd_amt DBMS_SQL.NUMBER_TABLE;
9453: --
9454: l_line_type DBMS_SQL.VARCHAR2_TABLE;
9447: l_sum_line_frt_orig_acctd_amt DBMS_SQL.NUMBER_TABLE;
9448: --
9449: l_sum_line_tax_rem_amt DBMS_SQL.NUMBER_TABLE;
9450: l_sum_line_tax_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
9451: l_sum_line_tax_orig_amt DBMS_SQL.NUMBER_TABLE;
9452: l_sum_line_tax_orig_acctd_amt DBMS_SQL.NUMBER_TABLE;
9453: --
9454: l_line_type DBMS_SQL.VARCHAR2_TABLE;
9455: l_ra_ar_gt ra_ar_gt%ROWTYPE;
9448: --
9449: l_sum_line_tax_rem_amt DBMS_SQL.NUMBER_TABLE;
9450: l_sum_line_tax_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
9451: l_sum_line_tax_orig_amt DBMS_SQL.NUMBER_TABLE;
9452: l_sum_line_tax_orig_acctd_amt DBMS_SQL.NUMBER_TABLE;
9453: --
9454: l_line_type DBMS_SQL.VARCHAR2_TABLE;
9455: l_ra_ar_gt ra_ar_gt%ROWTYPE;
9456: invoice_has_no_lines EXCEPTION;
9450: l_sum_line_tax_rem_acctd_amt DBMS_SQL.NUMBER_TABLE;
9451: l_sum_line_tax_orig_amt DBMS_SQL.NUMBER_TABLE;
9452: l_sum_line_tax_orig_acctd_amt DBMS_SQL.NUMBER_TABLE;
9453: --
9454: l_line_type DBMS_SQL.VARCHAR2_TABLE;
9455: l_ra_ar_gt ra_ar_gt%ROWTYPE;
9456: invoice_has_no_lines EXCEPTION;
9457: not_an_adjustment EXCEPTION;
9458: l_freight_boundary_done VARCHAR2(1) := 'N';
11942: b.customer_trx_line_id
11943: FROM ra_customer_trx_lines_gt b
11944: WHERE b.customer_trx_id = p_customer_trx_id;
11945:
11946: l_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
11947: l_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
11948: l_amt_orig_tab DBMS_SQL.NUMBER_TABLE;
11949: l_acctd_amt_orig_tab DBMS_SQL.NUMBER_TABLE;
11950: l_chrg_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
11943: FROM ra_customer_trx_lines_gt b
11944: WHERE b.customer_trx_id = p_customer_trx_id;
11945:
11946: l_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
11947: l_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
11948: l_amt_orig_tab DBMS_SQL.NUMBER_TABLE;
11949: l_acctd_amt_orig_tab DBMS_SQL.NUMBER_TABLE;
11950: l_chrg_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
11951: l_chrg_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
11944: WHERE b.customer_trx_id = p_customer_trx_id;
11945:
11946: l_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
11947: l_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
11948: l_amt_orig_tab DBMS_SQL.NUMBER_TABLE;
11949: l_acctd_amt_orig_tab DBMS_SQL.NUMBER_TABLE;
11950: l_chrg_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
11951: l_chrg_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
11952: l_frt_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
11945:
11946: l_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
11947: l_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
11948: l_amt_orig_tab DBMS_SQL.NUMBER_TABLE;
11949: l_acctd_amt_orig_tab DBMS_SQL.NUMBER_TABLE;
11950: l_chrg_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
11951: l_chrg_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
11952: l_frt_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
11953: l_frt_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
11946: l_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
11947: l_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
11948: l_amt_orig_tab DBMS_SQL.NUMBER_TABLE;
11949: l_acctd_amt_orig_tab DBMS_SQL.NUMBER_TABLE;
11950: l_chrg_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
11951: l_chrg_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
11952: l_frt_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
11953: l_frt_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
11954: l_frt_ed_amt_tab DBMS_SQL.NUMBER_TABLE;
11947: l_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
11948: l_amt_orig_tab DBMS_SQL.NUMBER_TABLE;
11949: l_acctd_amt_orig_tab DBMS_SQL.NUMBER_TABLE;
11950: l_chrg_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
11951: l_chrg_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
11952: l_frt_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
11953: l_frt_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
11954: l_frt_ed_amt_tab DBMS_SQL.NUMBER_TABLE;
11955: l_frt_ed_acctd_amt_tab DBMS_SQL.NUMBER_TABLE;
11948: l_amt_orig_tab DBMS_SQL.NUMBER_TABLE;
11949: l_acctd_amt_orig_tab DBMS_SQL.NUMBER_TABLE;
11950: l_chrg_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
11951: l_chrg_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
11952: l_frt_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
11953: l_frt_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
11954: l_frt_ed_amt_tab DBMS_SQL.NUMBER_TABLE;
11955: l_frt_ed_acctd_amt_tab DBMS_SQL.NUMBER_TABLE;
11956: l_frt_uned_amt_tab DBMS_SQL.NUMBER_TABLE;
11949: l_acctd_amt_orig_tab DBMS_SQL.NUMBER_TABLE;
11950: l_chrg_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
11951: l_chrg_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
11952: l_frt_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
11953: l_frt_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
11954: l_frt_ed_amt_tab DBMS_SQL.NUMBER_TABLE;
11955: l_frt_ed_acctd_amt_tab DBMS_SQL.NUMBER_TABLE;
11956: l_frt_uned_amt_tab DBMS_SQL.NUMBER_TABLE;
11957: l_frt_uned_acctd_amt_tab DBMS_SQL.NUMBER_TABLE;
11950: l_chrg_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
11951: l_chrg_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
11952: l_frt_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
11953: l_frt_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
11954: l_frt_ed_amt_tab DBMS_SQL.NUMBER_TABLE;
11955: l_frt_ed_acctd_amt_tab DBMS_SQL.NUMBER_TABLE;
11956: l_frt_uned_amt_tab DBMS_SQL.NUMBER_TABLE;
11957: l_frt_uned_acctd_amt_tab DBMS_SQL.NUMBER_TABLE;
11958: l_ctl_id_tab DBMS_SQL.NUMBER_TABLE;
11951: l_chrg_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
11952: l_frt_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
11953: l_frt_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
11954: l_frt_ed_amt_tab DBMS_SQL.NUMBER_TABLE;
11955: l_frt_ed_acctd_amt_tab DBMS_SQL.NUMBER_TABLE;
11956: l_frt_uned_amt_tab DBMS_SQL.NUMBER_TABLE;
11957: l_frt_uned_acctd_amt_tab DBMS_SQL.NUMBER_TABLE;
11958: l_ctl_id_tab DBMS_SQL.NUMBER_TABLE;
11959: l_last_fetch BOOLEAN := FALSE;
11952: l_frt_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
11953: l_frt_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
11954: l_frt_ed_amt_tab DBMS_SQL.NUMBER_TABLE;
11955: l_frt_ed_acctd_amt_tab DBMS_SQL.NUMBER_TABLE;
11956: l_frt_uned_amt_tab DBMS_SQL.NUMBER_TABLE;
11957: l_frt_uned_acctd_amt_tab DBMS_SQL.NUMBER_TABLE;
11958: l_ctl_id_tab DBMS_SQL.NUMBER_TABLE;
11959: l_last_fetch BOOLEAN := FALSE;
11960: BEGIN
11953: l_frt_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
11954: l_frt_ed_amt_tab DBMS_SQL.NUMBER_TABLE;
11955: l_frt_ed_acctd_amt_tab DBMS_SQL.NUMBER_TABLE;
11956: l_frt_uned_amt_tab DBMS_SQL.NUMBER_TABLE;
11957: l_frt_uned_acctd_amt_tab DBMS_SQL.NUMBER_TABLE;
11958: l_ctl_id_tab DBMS_SQL.NUMBER_TABLE;
11959: l_last_fetch BOOLEAN := FALSE;
11960: BEGIN
11961: IF PG_DEBUG = 'Y' THEN
11954: l_frt_ed_amt_tab DBMS_SQL.NUMBER_TABLE;
11955: l_frt_ed_acctd_amt_tab DBMS_SQL.NUMBER_TABLE;
11956: l_frt_uned_amt_tab DBMS_SQL.NUMBER_TABLE;
11957: l_frt_uned_acctd_amt_tab DBMS_SQL.NUMBER_TABLE;
11958: l_ctl_id_tab DBMS_SQL.NUMBER_TABLE;
11959: l_last_fetch BOOLEAN := FALSE;
11960: BEGIN
11961: IF PG_DEBUG = 'Y' THEN
11962: localdebug('arp_det_dist_pkg.final_update_inv_ctl_rem_orig()+');
17009: l_uned_amt NUMBER := 0;
17010: l_uned_acctd_amt NUMBER := 0;
17011:
17012:
17013: l_amt_tab DBMS_SQL.NUMBER_TABLE;
17014: l_acctd_amt_tab DBMS_SQL.NUMBER_TABLE;
17015: l_activity_tab DBMS_SQL.VARCHAR2_TABLE;
17016: BEGIN
17017: IF PG_DEBUG = 'Y' THEN
17010: l_uned_acctd_amt NUMBER := 0;
17011:
17012:
17013: l_amt_tab DBMS_SQL.NUMBER_TABLE;
17014: l_acctd_amt_tab DBMS_SQL.NUMBER_TABLE;
17015: l_activity_tab DBMS_SQL.VARCHAR2_TABLE;
17016: BEGIN
17017: IF PG_DEBUG = 'Y' THEN
17018: localdebug('arp_det_dist_pkg.reconciliation()+');
17011:
17012:
17013: l_amt_tab DBMS_SQL.NUMBER_TABLE;
17014: l_acctd_amt_tab DBMS_SQL.NUMBER_TABLE;
17015: l_activity_tab DBMS_SQL.VARCHAR2_TABLE;
17016: BEGIN
17017: IF PG_DEBUG = 'Y' THEN
17018: localdebug('arp_det_dist_pkg.reconciliation()+');
17019: END IF;