eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FARX_DP dependencies on FA_RX_UTIL_PKG

Line 142: fa_rx_util_pkg.debug('farx_dp.deprn_run()+');

138: )
139: is
140: BEGIN
141: IF (g_print_debug) THEN
142: fa_rx_util_pkg.debug('farx_dp.deprn_run()+');
143: fa_rx_util_pkg.debug('deprn_run: ' || '********login_id:' || login_id);
144: fa_rx_util_pkg.debug('deprn_run: ' || '********request_id:' || request_id);
145: END IF;
146: --

Line 143: fa_rx_util_pkg.debug('deprn_run: ' || '********login_id:' || login_id);

139: is
140: BEGIN
141: IF (g_print_debug) THEN
142: fa_rx_util_pkg.debug('farx_dp.deprn_run()+');
143: fa_rx_util_pkg.debug('deprn_run: ' || '********login_id:' || login_id);
144: fa_rx_util_pkg.debug('deprn_run: ' || '********request_id:' || request_id);
145: END IF;
146: --
147: -- Assign parameters to global variable

Line 144: fa_rx_util_pkg.debug('deprn_run: ' || '********request_id:' || request_id);

140: BEGIN
141: IF (g_print_debug) THEN
142: fa_rx_util_pkg.debug('farx_dp.deprn_run()+');
143: fa_rx_util_pkg.debug('deprn_run: ' || '********login_id:' || login_id);
144: fa_rx_util_pkg.debug('deprn_run: ' || '********request_id:' || request_id);
145: END IF;
146: --
147: -- Assign parameters to global variable
148: -- These values will be used within the before_report trigger

Line 196: fa_rx_util_pkg.debug('deprn_run: ' || 'Book = '||var.book);

192:
193: farx_dp.var.login_id := login_id;
194:
195: IF (g_print_debug) THEN
196: fa_rx_util_pkg.debug('deprn_run: ' || 'Book = '||var.book);
197: fa_rx_util_pkg.debug('deprn_run: ' || 'Period = '||var.period);
198: fa_rx_util_pkg.debug('deprn_run: ' || 'Report_Style = '||var.report_style);
199: -- MRC
200: fa_rx_util_pkg.debug('deprn_run: ' || 'SOB ID = '||param.sob_id);

Line 197: fa_rx_util_pkg.debug('deprn_run: ' || 'Period = '||var.period);

193: farx_dp.var.login_id := login_id;
194:
195: IF (g_print_debug) THEN
196: fa_rx_util_pkg.debug('deprn_run: ' || 'Book = '||var.book);
197: fa_rx_util_pkg.debug('deprn_run: ' || 'Period = '||var.period);
198: fa_rx_util_pkg.debug('deprn_run: ' || 'Report_Style = '||var.report_style);
199: -- MRC
200: fa_rx_util_pkg.debug('deprn_run: ' || 'SOB ID = '||param.sob_id);
201: fa_rx_util_pkg.debug('deprn_run: ' || 'MRC SOB Type = '||param.mrcsobtype);

Line 198: fa_rx_util_pkg.debug('deprn_run: ' || 'Report_Style = '||var.report_style);

194:
195: IF (g_print_debug) THEN
196: fa_rx_util_pkg.debug('deprn_run: ' || 'Book = '||var.book);
197: fa_rx_util_pkg.debug('deprn_run: ' || 'Period = '||var.period);
198: fa_rx_util_pkg.debug('deprn_run: ' || 'Report_Style = '||var.report_style);
199: -- MRC
200: fa_rx_util_pkg.debug('deprn_run: ' || 'SOB ID = '||param.sob_id);
201: fa_rx_util_pkg.debug('deprn_run: ' || 'MRC SOB Type = '||param.mrcsobtype);
202: -- End MRC

Line 200: fa_rx_util_pkg.debug('deprn_run: ' || 'SOB ID = '||param.sob_id);

196: fa_rx_util_pkg.debug('deprn_run: ' || 'Book = '||var.book);
197: fa_rx_util_pkg.debug('deprn_run: ' || 'Period = '||var.period);
198: fa_rx_util_pkg.debug('deprn_run: ' || 'Report_Style = '||var.report_style);
199: -- MRC
200: fa_rx_util_pkg.debug('deprn_run: ' || 'SOB ID = '||param.sob_id);
201: fa_rx_util_pkg.debug('deprn_run: ' || 'MRC SOB Type = '||param.mrcsobtype);
202: -- End MRC
203: END IF;
204:

Line 201: fa_rx_util_pkg.debug('deprn_run: ' || 'MRC SOB Type = '||param.mrcsobtype);

197: fa_rx_util_pkg.debug('deprn_run: ' || 'Period = '||var.period);
198: fa_rx_util_pkg.debug('deprn_run: ' || 'Report_Style = '||var.report_style);
199: -- MRC
200: fa_rx_util_pkg.debug('deprn_run: ' || 'SOB ID = '||param.sob_id);
201: fa_rx_util_pkg.debug('deprn_run: ' || 'MRC SOB Type = '||param.mrcsobtype);
202: -- End MRC
203: END IF;
204:
205: --

Line 208: fa_rx_util_pkg.init_request('farx_dp.deprn_rep', request_id, 'FA_DEPRN_REP_ITF');

204:
205: --
206: -- Initialize request
207: --
208: fa_rx_util_pkg.init_request('farx_dp.deprn_rep', request_id, 'FA_DEPRN_REP_ITF');
209:
210: --
211: -- Assign report triggers for this report.
212: --

Line 213: fa_rx_util_pkg.assign_report('RESERVE LEDGER',

209:
210: --
211: -- Assign report triggers for this report.
212: --
213: fa_rx_util_pkg.assign_report('RESERVE LEDGER',
214: true,
215: 'farx_dp.before_report;',
216: 'farx_dp.bind(:CURSOR_SELECT);',
217: 'farx_dp.after_fetch;',

Line 223: fa_rx_util_pkg.run_report('farx_dp.deprn_rep', retcode, errbuf);

219:
220: --
221: -- Run the report
222: --
223: fa_rx_util_pkg.run_report('farx_dp.deprn_rep', retcode, errbuf);
224:
225: IF (g_print_debug) THEN
226: fa_rx_util_pkg.debug('farx_dp.deprn_run()-');
227: END IF;

Line 226: fa_rx_util_pkg.debug('farx_dp.deprn_run()-');

222: --
223: fa_rx_util_pkg.run_report('farx_dp.deprn_rep', retcode, errbuf);
224:
225: IF (g_print_debug) THEN
226: fa_rx_util_pkg.debug('farx_dp.deprn_run()-');
227: END IF;
228: exception
229: when others then
230: fa_rx_util_pkg.log(sqlcode);

Line 230: fa_rx_util_pkg.log(sqlcode);

226: fa_rx_util_pkg.debug('farx_dp.deprn_run()-');
227: END IF;
228: exception
229: when others then
230: fa_rx_util_pkg.log(sqlcode);
231: fa_rx_util_pkg.log(sqlerrm);
232:
233: fnd_message.set_name('OFA', mesg_name);
234: if mesg_name in ('FA_SHARED_DELETE_FAILED', 'FA_SHARED_INSERT_FAILED') then

Line 231: fa_rx_util_pkg.log(sqlerrm);

227: END IF;
228: exception
229: when others then
230: fa_rx_util_pkg.log(sqlcode);
231: fa_rx_util_pkg.log(sqlerrm);
232:
233: fnd_message.set_name('OFA', mesg_name);
234: if mesg_name in ('FA_SHARED_DELETE_FAILED', 'FA_SHARED_INSERT_FAILED') then
235: fnd_message.set_token('TABLE', 'FA_DEPRN_REP_ITF', FALSE);

Line 243: fa_rx_util_pkg.debug('deprn_run: ' || mesg_name);

239: end if;
240:
241: mesg_str := fnd_message.get;
242: IF (g_print_debug) THEN
243: fa_rx_util_pkg.debug('deprn_run: ' || mesg_name);
244: END IF;
245: fa_rx_util_pkg.log(mesg_str);
246:
247: if error_errbuf is not null then

Line 245: fa_rx_util_pkg.log(mesg_str);

241: mesg_str := fnd_message.get;
242: IF (g_print_debug) THEN
243: fa_rx_util_pkg.debug('deprn_run: ' || mesg_name);
244: END IF;
245: fa_rx_util_pkg.log(mesg_str);
246:
247: if error_errbuf is not null then
248: retcode := error_retcode;
249: errbuf := error_errbuf;

Line 256: fa_rx_util_pkg.debug('farx_dp.deprn_run(EXCEPTION)-');

252: errbuf := mesg_str;
253: end if;
254:
255: IF (g_print_debug) THEN
256: fa_rx_util_pkg.debug('farx_dp.deprn_run(EXCEPTION)-');
257: END IF;
258: end deprn_run;
259:
260:

Line 279: fa_rx_util_pkg.debug('farx_dp.before_report()+');

275: calendar_period_open_date date;
276: calendar_period_close_date date;
277:
278: begin
279: fa_rx_util_pkg.debug('farx_dp.before_report()+');
280:
281: mesg_name := 'FA_SHARED_NO_FLEX_CHART_ACCTID';
282:
283: select category_flex_structure, location_flex_structure,

Line 348: fa_rx_util_pkg.debug('********book:' || var.book);

344: and period_name = var.period;
345:
346: mesg_name := 'FA_RX_RESERVE_LEDGER';
347:
348: fa_rx_util_pkg.debug('********book:' || var.book);
349: fa_rx_util_pkg.debug('******period:' || var.period);
350: fa_rx_util_pkg.debug('period_close:' || period_closed);
351:
352: /* Removed check of period_closed status on 24th Nov 2000

Line 349: fa_rx_util_pkg.debug('******period:' || var.period);

345:
346: mesg_name := 'FA_RX_RESERVE_LEDGER';
347:
348: fa_rx_util_pkg.debug('********book:' || var.book);
349: fa_rx_util_pkg.debug('******period:' || var.period);
350: fa_rx_util_pkg.debug('period_close:' || period_closed);
351:
352: /* Removed check of period_closed status on 24th Nov 2000
353: to populate assets information of current open period. */

Line 350: fa_rx_util_pkg.debug('period_close:' || period_closed);

346: mesg_name := 'FA_RX_RESERVE_LEDGER';
347:
348: fa_rx_util_pkg.debug('********book:' || var.book);
349: fa_rx_util_pkg.debug('******period:' || var.period);
350: fa_rx_util_pkg.debug('period_close:' || period_closed);
351:
352: /* Removed check of period_closed status on 24th Nov 2000
353: to populate assets information of current open period. */
354:

Line 482: fa_rx_util_pkg.assign_column('1','cc.code_combination_id', null,'farx_dp.var.ccid','NUMBER');

478: --
479: -- Assign SELECT list
480: --
481: -->>SELECT_START<<--
482: fa_rx_util_pkg.assign_column('1','cc.code_combination_id', null,'farx_dp.var.ccid','NUMBER');
483: fa_rx_util_pkg.assign_column('2','fy.fiscal_year', null,'farx_dp.var.fy','NUMBER');
484: fa_rx_util_pkg.assign_column('3','cb.asset_cost_acct', 'asset_cost_acct','farx_dp.var.asset_cost_acct','VARCHAR2', 25);
485: fa_rx_util_pkg.assign_column('4','rsv.deprn_reserve_acct', 'accum_deprn_acct','farx_dp.var.deprn_rsv_acct','VARCHAR2', 25);
486: fa_rx_util_pkg.assign_column('5','ad.asset_number', 'asset_number','farx_dp.var.asset_number','VARCHAR2', 15);

Line 483: fa_rx_util_pkg.assign_column('2','fy.fiscal_year', null,'farx_dp.var.fy','NUMBER');

479: -- Assign SELECT list
480: --
481: -->>SELECT_START<<--
482: fa_rx_util_pkg.assign_column('1','cc.code_combination_id', null,'farx_dp.var.ccid','NUMBER');
483: fa_rx_util_pkg.assign_column('2','fy.fiscal_year', null,'farx_dp.var.fy','NUMBER');
484: fa_rx_util_pkg.assign_column('3','cb.asset_cost_acct', 'asset_cost_acct','farx_dp.var.asset_cost_acct','VARCHAR2', 25);
485: fa_rx_util_pkg.assign_column('4','rsv.deprn_reserve_acct', 'accum_deprn_acct','farx_dp.var.deprn_rsv_acct','VARCHAR2', 25);
486: fa_rx_util_pkg.assign_column('5','ad.asset_number', 'asset_number','farx_dp.var.asset_number','VARCHAR2', 15);
487: fa_rx_util_pkg.assign_column('6','ad.description', 'description','farx_dp.var.description','VARCHAR2', 80);

Line 484: fa_rx_util_pkg.assign_column('3','cb.asset_cost_acct', 'asset_cost_acct','farx_dp.var.asset_cost_acct','VARCHAR2', 25);

480: --
481: -->>SELECT_START<<--
482: fa_rx_util_pkg.assign_column('1','cc.code_combination_id', null,'farx_dp.var.ccid','NUMBER');
483: fa_rx_util_pkg.assign_column('2','fy.fiscal_year', null,'farx_dp.var.fy','NUMBER');
484: fa_rx_util_pkg.assign_column('3','cb.asset_cost_acct', 'asset_cost_acct','farx_dp.var.asset_cost_acct','VARCHAR2', 25);
485: fa_rx_util_pkg.assign_column('4','rsv.deprn_reserve_acct', 'accum_deprn_acct','farx_dp.var.deprn_rsv_acct','VARCHAR2', 25);
486: fa_rx_util_pkg.assign_column('5','ad.asset_number', 'asset_number','farx_dp.var.asset_number','VARCHAR2', 15);
487: fa_rx_util_pkg.assign_column('6','ad.description', 'description','farx_dp.var.description','VARCHAR2', 80);
488: fa_rx_util_pkg.assign_column('7','ad.tag_number', 'tag_number','farx_dp.var.tag_number','VARCHAR2', 15);

Line 485: fa_rx_util_pkg.assign_column('4','rsv.deprn_reserve_acct', 'accum_deprn_acct','farx_dp.var.deprn_rsv_acct','VARCHAR2', 25);

481: -->>SELECT_START<<--
482: fa_rx_util_pkg.assign_column('1','cc.code_combination_id', null,'farx_dp.var.ccid','NUMBER');
483: fa_rx_util_pkg.assign_column('2','fy.fiscal_year', null,'farx_dp.var.fy','NUMBER');
484: fa_rx_util_pkg.assign_column('3','cb.asset_cost_acct', 'asset_cost_acct','farx_dp.var.asset_cost_acct','VARCHAR2', 25);
485: fa_rx_util_pkg.assign_column('4','rsv.deprn_reserve_acct', 'accum_deprn_acct','farx_dp.var.deprn_rsv_acct','VARCHAR2', 25);
486: fa_rx_util_pkg.assign_column('5','ad.asset_number', 'asset_number','farx_dp.var.asset_number','VARCHAR2', 15);
487: fa_rx_util_pkg.assign_column('6','ad.description', 'description','farx_dp.var.description','VARCHAR2', 80);
488: fa_rx_util_pkg.assign_column('7','ad.tag_number', 'tag_number','farx_dp.var.tag_number','VARCHAR2', 15);
489: fa_rx_util_pkg.assign_column('8','ad.serial_number', 'serial_number','farx_dp.var.serial_number','VARCHAR2', 35);

Line 486: fa_rx_util_pkg.assign_column('5','ad.asset_number', 'asset_number','farx_dp.var.asset_number','VARCHAR2', 15);

482: fa_rx_util_pkg.assign_column('1','cc.code_combination_id', null,'farx_dp.var.ccid','NUMBER');
483: fa_rx_util_pkg.assign_column('2','fy.fiscal_year', null,'farx_dp.var.fy','NUMBER');
484: fa_rx_util_pkg.assign_column('3','cb.asset_cost_acct', 'asset_cost_acct','farx_dp.var.asset_cost_acct','VARCHAR2', 25);
485: fa_rx_util_pkg.assign_column('4','rsv.deprn_reserve_acct', 'accum_deprn_acct','farx_dp.var.deprn_rsv_acct','VARCHAR2', 25);
486: fa_rx_util_pkg.assign_column('5','ad.asset_number', 'asset_number','farx_dp.var.asset_number','VARCHAR2', 15);
487: fa_rx_util_pkg.assign_column('6','ad.description', 'description','farx_dp.var.description','VARCHAR2', 80);
488: fa_rx_util_pkg.assign_column('7','ad.tag_number', 'tag_number','farx_dp.var.tag_number','VARCHAR2', 15);
489: fa_rx_util_pkg.assign_column('8','ad.serial_number', 'serial_number','farx_dp.var.serial_number','VARCHAR2', 35);
490: fa_rx_util_pkg.assign_column('9','ad.inventorial', 'inventorial','farx_dp.var.inventorial','VARCHAR2', 3);

Line 487: fa_rx_util_pkg.assign_column('6','ad.description', 'description','farx_dp.var.description','VARCHAR2', 80);

483: fa_rx_util_pkg.assign_column('2','fy.fiscal_year', null,'farx_dp.var.fy','NUMBER');
484: fa_rx_util_pkg.assign_column('3','cb.asset_cost_acct', 'asset_cost_acct','farx_dp.var.asset_cost_acct','VARCHAR2', 25);
485: fa_rx_util_pkg.assign_column('4','rsv.deprn_reserve_acct', 'accum_deprn_acct','farx_dp.var.deprn_rsv_acct','VARCHAR2', 25);
486: fa_rx_util_pkg.assign_column('5','ad.asset_number', 'asset_number','farx_dp.var.asset_number','VARCHAR2', 15);
487: fa_rx_util_pkg.assign_column('6','ad.description', 'description','farx_dp.var.description','VARCHAR2', 80);
488: fa_rx_util_pkg.assign_column('7','ad.tag_number', 'tag_number','farx_dp.var.tag_number','VARCHAR2', 15);
489: fa_rx_util_pkg.assign_column('8','ad.serial_number', 'serial_number','farx_dp.var.serial_number','VARCHAR2', 35);
490: fa_rx_util_pkg.assign_column('9','ad.inventorial', 'inventorial','farx_dp.var.inventorial','VARCHAR2', 3);
491: fa_rx_util_pkg.assign_column('10','rsv.date_placed_in_service','date_placed_in_service','farx_dp.var.date_placed_in_service','DATE');

Line 488: fa_rx_util_pkg.assign_column('7','ad.tag_number', 'tag_number','farx_dp.var.tag_number','VARCHAR2', 15);

484: fa_rx_util_pkg.assign_column('3','cb.asset_cost_acct', 'asset_cost_acct','farx_dp.var.asset_cost_acct','VARCHAR2', 25);
485: fa_rx_util_pkg.assign_column('4','rsv.deprn_reserve_acct', 'accum_deprn_acct','farx_dp.var.deprn_rsv_acct','VARCHAR2', 25);
486: fa_rx_util_pkg.assign_column('5','ad.asset_number', 'asset_number','farx_dp.var.asset_number','VARCHAR2', 15);
487: fa_rx_util_pkg.assign_column('6','ad.description', 'description','farx_dp.var.description','VARCHAR2', 80);
488: fa_rx_util_pkg.assign_column('7','ad.tag_number', 'tag_number','farx_dp.var.tag_number','VARCHAR2', 15);
489: fa_rx_util_pkg.assign_column('8','ad.serial_number', 'serial_number','farx_dp.var.serial_number','VARCHAR2', 35);
490: fa_rx_util_pkg.assign_column('9','ad.inventorial', 'inventorial','farx_dp.var.inventorial','VARCHAR2', 3);
491: fa_rx_util_pkg.assign_column('10','rsv.date_placed_in_service','date_placed_in_service','farx_dp.var.date_placed_in_service','DATE');
492: fa_rx_util_pkg.assign_column('11','rsv.method_code', 'deprn_method','farx_dp.var.method_code', 'VARCHAR2', 15);

Line 489: fa_rx_util_pkg.assign_column('8','ad.serial_number', 'serial_number','farx_dp.var.serial_number','VARCHAR2', 35);

485: fa_rx_util_pkg.assign_column('4','rsv.deprn_reserve_acct', 'accum_deprn_acct','farx_dp.var.deprn_rsv_acct','VARCHAR2', 25);
486: fa_rx_util_pkg.assign_column('5','ad.asset_number', 'asset_number','farx_dp.var.asset_number','VARCHAR2', 15);
487: fa_rx_util_pkg.assign_column('6','ad.description', 'description','farx_dp.var.description','VARCHAR2', 80);
488: fa_rx_util_pkg.assign_column('7','ad.tag_number', 'tag_number','farx_dp.var.tag_number','VARCHAR2', 15);
489: fa_rx_util_pkg.assign_column('8','ad.serial_number', 'serial_number','farx_dp.var.serial_number','VARCHAR2', 35);
490: fa_rx_util_pkg.assign_column('9','ad.inventorial', 'inventorial','farx_dp.var.inventorial','VARCHAR2', 3);
491: fa_rx_util_pkg.assign_column('10','rsv.date_placed_in_service','date_placed_in_service','farx_dp.var.date_placed_in_service','DATE');
492: fa_rx_util_pkg.assign_column('11','rsv.method_code', 'deprn_method','farx_dp.var.method_code', 'VARCHAR2', 15);
493: fa_rx_util_pkg.assign_column('12','rsv.life', null,'farx_dp.var.life','NUMBER');

Line 490: fa_rx_util_pkg.assign_column('9','ad.inventorial', 'inventorial','farx_dp.var.inventorial','VARCHAR2', 3);

486: fa_rx_util_pkg.assign_column('5','ad.asset_number', 'asset_number','farx_dp.var.asset_number','VARCHAR2', 15);
487: fa_rx_util_pkg.assign_column('6','ad.description', 'description','farx_dp.var.description','VARCHAR2', 80);
488: fa_rx_util_pkg.assign_column('7','ad.tag_number', 'tag_number','farx_dp.var.tag_number','VARCHAR2', 15);
489: fa_rx_util_pkg.assign_column('8','ad.serial_number', 'serial_number','farx_dp.var.serial_number','VARCHAR2', 35);
490: fa_rx_util_pkg.assign_column('9','ad.inventorial', 'inventorial','farx_dp.var.inventorial','VARCHAR2', 3);
491: fa_rx_util_pkg.assign_column('10','rsv.date_placed_in_service','date_placed_in_service','farx_dp.var.date_placed_in_service','DATE');
492: fa_rx_util_pkg.assign_column('11','rsv.method_code', 'deprn_method','farx_dp.var.method_code', 'VARCHAR2', 15);
493: fa_rx_util_pkg.assign_column('12','rsv.life', null,'farx_dp.var.life','NUMBER');
494: fa_rx_util_pkg.assign_column('13','rsv.rate', 'adjusted_rate','farx_dp.var.rate','NUMBER');

Line 491: fa_rx_util_pkg.assign_column('10','rsv.date_placed_in_service','date_placed_in_service','farx_dp.var.date_placed_in_service','DATE');

487: fa_rx_util_pkg.assign_column('6','ad.description', 'description','farx_dp.var.description','VARCHAR2', 80);
488: fa_rx_util_pkg.assign_column('7','ad.tag_number', 'tag_number','farx_dp.var.tag_number','VARCHAR2', 15);
489: fa_rx_util_pkg.assign_column('8','ad.serial_number', 'serial_number','farx_dp.var.serial_number','VARCHAR2', 35);
490: fa_rx_util_pkg.assign_column('9','ad.inventorial', 'inventorial','farx_dp.var.inventorial','VARCHAR2', 3);
491: fa_rx_util_pkg.assign_column('10','rsv.date_placed_in_service','date_placed_in_service','farx_dp.var.date_placed_in_service','DATE');
492: fa_rx_util_pkg.assign_column('11','rsv.method_code', 'deprn_method','farx_dp.var.method_code', 'VARCHAR2', 15);
493: fa_rx_util_pkg.assign_column('12','rsv.life', null,'farx_dp.var.life','NUMBER');
494: fa_rx_util_pkg.assign_column('13','rsv.rate', 'adjusted_rate','farx_dp.var.rate','NUMBER');
495: fa_rx_util_pkg.assign_column('14','ds.bonus_rate', null,'farx_dp.var.bonus_rate','NUMBER');

Line 492: fa_rx_util_pkg.assign_column('11','rsv.method_code', 'deprn_method','farx_dp.var.method_code', 'VARCHAR2', 15);

488: fa_rx_util_pkg.assign_column('7','ad.tag_number', 'tag_number','farx_dp.var.tag_number','VARCHAR2', 15);
489: fa_rx_util_pkg.assign_column('8','ad.serial_number', 'serial_number','farx_dp.var.serial_number','VARCHAR2', 35);
490: fa_rx_util_pkg.assign_column('9','ad.inventorial', 'inventorial','farx_dp.var.inventorial','VARCHAR2', 3);
491: fa_rx_util_pkg.assign_column('10','rsv.date_placed_in_service','date_placed_in_service','farx_dp.var.date_placed_in_service','DATE');
492: fa_rx_util_pkg.assign_column('11','rsv.method_code', 'deprn_method','farx_dp.var.method_code', 'VARCHAR2', 15);
493: fa_rx_util_pkg.assign_column('12','rsv.life', null,'farx_dp.var.life','NUMBER');
494: fa_rx_util_pkg.assign_column('13','rsv.rate', 'adjusted_rate','farx_dp.var.rate','NUMBER');
495: fa_rx_util_pkg.assign_column('14','ds.bonus_rate', null,'farx_dp.var.bonus_rate','NUMBER');
496: fa_rx_util_pkg.assign_column('15','rsv.capacity', null,'farx_dp.var.capacity','NUMBER');

Line 493: fa_rx_util_pkg.assign_column('12','rsv.life', null,'farx_dp.var.life','NUMBER');

489: fa_rx_util_pkg.assign_column('8','ad.serial_number', 'serial_number','farx_dp.var.serial_number','VARCHAR2', 35);
490: fa_rx_util_pkg.assign_column('9','ad.inventorial', 'inventorial','farx_dp.var.inventorial','VARCHAR2', 3);
491: fa_rx_util_pkg.assign_column('10','rsv.date_placed_in_service','date_placed_in_service','farx_dp.var.date_placed_in_service','DATE');
492: fa_rx_util_pkg.assign_column('11','rsv.method_code', 'deprn_method','farx_dp.var.method_code', 'VARCHAR2', 15);
493: fa_rx_util_pkg.assign_column('12','rsv.life', null,'farx_dp.var.life','NUMBER');
494: fa_rx_util_pkg.assign_column('13','rsv.rate', 'adjusted_rate','farx_dp.var.rate','NUMBER');
495: fa_rx_util_pkg.assign_column('14','ds.bonus_rate', null,'farx_dp.var.bonus_rate','NUMBER');
496: fa_rx_util_pkg.assign_column('15','rsv.capacity', null,'farx_dp.var.capacity','NUMBER');
497: fa_rx_util_pkg.assign_column('16','rsv.cost', 'cost','farx_dp.var.cost','NUMBER');

Line 494: fa_rx_util_pkg.assign_column('13','rsv.rate', 'adjusted_rate','farx_dp.var.rate','NUMBER');

490: fa_rx_util_pkg.assign_column('9','ad.inventorial', 'inventorial','farx_dp.var.inventorial','VARCHAR2', 3);
491: fa_rx_util_pkg.assign_column('10','rsv.date_placed_in_service','date_placed_in_service','farx_dp.var.date_placed_in_service','DATE');
492: fa_rx_util_pkg.assign_column('11','rsv.method_code', 'deprn_method','farx_dp.var.method_code', 'VARCHAR2', 15);
493: fa_rx_util_pkg.assign_column('12','rsv.life', null,'farx_dp.var.life','NUMBER');
494: fa_rx_util_pkg.assign_column('13','rsv.rate', 'adjusted_rate','farx_dp.var.rate','NUMBER');
495: fa_rx_util_pkg.assign_column('14','ds.bonus_rate', null,'farx_dp.var.bonus_rate','NUMBER');
496: fa_rx_util_pkg.assign_column('15','rsv.capacity', null,'farx_dp.var.capacity','NUMBER');
497: fa_rx_util_pkg.assign_column('16','rsv.cost', 'cost','farx_dp.var.cost','NUMBER');
498: fa_rx_util_pkg.assign_column('17','rsv.deprn_amount', 'deprn_amount','farx_dp.var.deprn_amount','NUMBER');

Line 495: fa_rx_util_pkg.assign_column('14','ds.bonus_rate', null,'farx_dp.var.bonus_rate','NUMBER');

491: fa_rx_util_pkg.assign_column('10','rsv.date_placed_in_service','date_placed_in_service','farx_dp.var.date_placed_in_service','DATE');
492: fa_rx_util_pkg.assign_column('11','rsv.method_code', 'deprn_method','farx_dp.var.method_code', 'VARCHAR2', 15);
493: fa_rx_util_pkg.assign_column('12','rsv.life', null,'farx_dp.var.life','NUMBER');
494: fa_rx_util_pkg.assign_column('13','rsv.rate', 'adjusted_rate','farx_dp.var.rate','NUMBER');
495: fa_rx_util_pkg.assign_column('14','ds.bonus_rate', null,'farx_dp.var.bonus_rate','NUMBER');
496: fa_rx_util_pkg.assign_column('15','rsv.capacity', null,'farx_dp.var.capacity','NUMBER');
497: fa_rx_util_pkg.assign_column('16','rsv.cost', 'cost','farx_dp.var.cost','NUMBER');
498: fa_rx_util_pkg.assign_column('17','rsv.deprn_amount', 'deprn_amount','farx_dp.var.deprn_amount','NUMBER');
499: fa_rx_util_pkg.assign_column('18','rsv.ytd_deprn', 'ytd_deprn','farx_dp.var.ytd_deprn','NUMBER');

Line 496: fa_rx_util_pkg.assign_column('15','rsv.capacity', null,'farx_dp.var.capacity','NUMBER');

492: fa_rx_util_pkg.assign_column('11','rsv.method_code', 'deprn_method','farx_dp.var.method_code', 'VARCHAR2', 15);
493: fa_rx_util_pkg.assign_column('12','rsv.life', null,'farx_dp.var.life','NUMBER');
494: fa_rx_util_pkg.assign_column('13','rsv.rate', 'adjusted_rate','farx_dp.var.rate','NUMBER');
495: fa_rx_util_pkg.assign_column('14','ds.bonus_rate', null,'farx_dp.var.bonus_rate','NUMBER');
496: fa_rx_util_pkg.assign_column('15','rsv.capacity', null,'farx_dp.var.capacity','NUMBER');
497: fa_rx_util_pkg.assign_column('16','rsv.cost', 'cost','farx_dp.var.cost','NUMBER');
498: fa_rx_util_pkg.assign_column('17','rsv.deprn_amount', 'deprn_amount','farx_dp.var.deprn_amount','NUMBER');
499: fa_rx_util_pkg.assign_column('18','rsv.ytd_deprn', 'ytd_deprn','farx_dp.var.ytd_deprn','NUMBER');
500: fa_rx_util_pkg.assign_column('19','rsv.deprn_reserve', 'ltd_deprn','farx_dp.var.reserve','NUMBER');

Line 497: fa_rx_util_pkg.assign_column('16','rsv.cost', 'cost','farx_dp.var.cost','NUMBER');

493: fa_rx_util_pkg.assign_column('12','rsv.life', null,'farx_dp.var.life','NUMBER');
494: fa_rx_util_pkg.assign_column('13','rsv.rate', 'adjusted_rate','farx_dp.var.rate','NUMBER');
495: fa_rx_util_pkg.assign_column('14','ds.bonus_rate', null,'farx_dp.var.bonus_rate','NUMBER');
496: fa_rx_util_pkg.assign_column('15','rsv.capacity', null,'farx_dp.var.capacity','NUMBER');
497: fa_rx_util_pkg.assign_column('16','rsv.cost', 'cost','farx_dp.var.cost','NUMBER');
498: fa_rx_util_pkg.assign_column('17','rsv.deprn_amount', 'deprn_amount','farx_dp.var.deprn_amount','NUMBER');
499: fa_rx_util_pkg.assign_column('18','rsv.ytd_deprn', 'ytd_deprn','farx_dp.var.ytd_deprn','NUMBER');
500: fa_rx_util_pkg.assign_column('19','rsv.deprn_reserve', 'ltd_deprn','farx_dp.var.reserve','NUMBER');
501: fa_rx_util_pkg.assign_column('20','nvl(dh.units_assigned,0)/nvl(ah.units,1)*100','percent','farx_dp.var.percent', 'NUMBER');

Line 498: fa_rx_util_pkg.assign_column('17','rsv.deprn_amount', 'deprn_amount','farx_dp.var.deprn_amount','NUMBER');

494: fa_rx_util_pkg.assign_column('13','rsv.rate', 'adjusted_rate','farx_dp.var.rate','NUMBER');
495: fa_rx_util_pkg.assign_column('14','ds.bonus_rate', null,'farx_dp.var.bonus_rate','NUMBER');
496: fa_rx_util_pkg.assign_column('15','rsv.capacity', null,'farx_dp.var.capacity','NUMBER');
497: fa_rx_util_pkg.assign_column('16','rsv.cost', 'cost','farx_dp.var.cost','NUMBER');
498: fa_rx_util_pkg.assign_column('17','rsv.deprn_amount', 'deprn_amount','farx_dp.var.deprn_amount','NUMBER');
499: fa_rx_util_pkg.assign_column('18','rsv.ytd_deprn', 'ytd_deprn','farx_dp.var.ytd_deprn','NUMBER');
500: fa_rx_util_pkg.assign_column('19','rsv.deprn_reserve', 'ltd_deprn','farx_dp.var.reserve','NUMBER');
501: fa_rx_util_pkg.assign_column('20','nvl(dh.units_assigned,0)/nvl(ah.units,1)*100','percent','farx_dp.var.percent', 'NUMBER');
502: fa_rx_util_pkg.assign_column('21','rsv.transaction_type', null,'farx_dp.var.transaction_type','VARCHAR2', 1);

Line 499: fa_rx_util_pkg.assign_column('18','rsv.ytd_deprn', 'ytd_deprn','farx_dp.var.ytd_deprn','NUMBER');

495: fa_rx_util_pkg.assign_column('14','ds.bonus_rate', null,'farx_dp.var.bonus_rate','NUMBER');
496: fa_rx_util_pkg.assign_column('15','rsv.capacity', null,'farx_dp.var.capacity','NUMBER');
497: fa_rx_util_pkg.assign_column('16','rsv.cost', 'cost','farx_dp.var.cost','NUMBER');
498: fa_rx_util_pkg.assign_column('17','rsv.deprn_amount', 'deprn_amount','farx_dp.var.deprn_amount','NUMBER');
499: fa_rx_util_pkg.assign_column('18','rsv.ytd_deprn', 'ytd_deprn','farx_dp.var.ytd_deprn','NUMBER');
500: fa_rx_util_pkg.assign_column('19','rsv.deprn_reserve', 'ltd_deprn','farx_dp.var.reserve','NUMBER');
501: fa_rx_util_pkg.assign_column('20','nvl(dh.units_assigned,0)/nvl(ah.units,1)*100','percent','farx_dp.var.percent', 'NUMBER');
502: fa_rx_util_pkg.assign_column('21','rsv.transaction_type', null,'farx_dp.var.transaction_type','VARCHAR2', 1);
503: fa_rx_util_pkg.assign_column('22','dh.location_id', null,'farx_dp.var.location_id','NUMBER');

Line 500: fa_rx_util_pkg.assign_column('19','rsv.deprn_reserve', 'ltd_deprn','farx_dp.var.reserve','NUMBER');

496: fa_rx_util_pkg.assign_column('15','rsv.capacity', null,'farx_dp.var.capacity','NUMBER');
497: fa_rx_util_pkg.assign_column('16','rsv.cost', 'cost','farx_dp.var.cost','NUMBER');
498: fa_rx_util_pkg.assign_column('17','rsv.deprn_amount', 'deprn_amount','farx_dp.var.deprn_amount','NUMBER');
499: fa_rx_util_pkg.assign_column('18','rsv.ytd_deprn', 'ytd_deprn','farx_dp.var.ytd_deprn','NUMBER');
500: fa_rx_util_pkg.assign_column('19','rsv.deprn_reserve', 'ltd_deprn','farx_dp.var.reserve','NUMBER');
501: fa_rx_util_pkg.assign_column('20','nvl(dh.units_assigned,0)/nvl(ah.units,1)*100','percent','farx_dp.var.percent', 'NUMBER');
502: fa_rx_util_pkg.assign_column('21','rsv.transaction_type', null,'farx_dp.var.transaction_type','VARCHAR2', 1);
503: fa_rx_util_pkg.assign_column('22','dh.location_id', null,'farx_dp.var.location_id','NUMBER');
504: fa_rx_util_pkg.assign_column('23','ah.category_id', null,'farx_dp.var.category_id','NUMBER');

Line 501: fa_rx_util_pkg.assign_column('20','nvl(dh.units_assigned,0)/nvl(ah.units,1)*100','percent','farx_dp.var.percent', 'NUMBER');

497: fa_rx_util_pkg.assign_column('16','rsv.cost', 'cost','farx_dp.var.cost','NUMBER');
498: fa_rx_util_pkg.assign_column('17','rsv.deprn_amount', 'deprn_amount','farx_dp.var.deprn_amount','NUMBER');
499: fa_rx_util_pkg.assign_column('18','rsv.ytd_deprn', 'ytd_deprn','farx_dp.var.ytd_deprn','NUMBER');
500: fa_rx_util_pkg.assign_column('19','rsv.deprn_reserve', 'ltd_deprn','farx_dp.var.reserve','NUMBER');
501: fa_rx_util_pkg.assign_column('20','nvl(dh.units_assigned,0)/nvl(ah.units,1)*100','percent','farx_dp.var.percent', 'NUMBER');
502: fa_rx_util_pkg.assign_column('21','rsv.transaction_type', null,'farx_dp.var.transaction_type','VARCHAR2', 1);
503: fa_rx_util_pkg.assign_column('22','dh.location_id', null,'farx_dp.var.location_id','NUMBER');
504: fa_rx_util_pkg.assign_column('23','ah.category_id', null,'farx_dp.var.category_id','NUMBER');
505: fa_rx_util_pkg.assign_column('24','ad.asset_key_ccid', null,'farx_dp.var.asset_key_ccid','NUMBER');

Line 502: fa_rx_util_pkg.assign_column('21','rsv.transaction_type', null,'farx_dp.var.transaction_type','VARCHAR2', 1);

498: fa_rx_util_pkg.assign_column('17','rsv.deprn_amount', 'deprn_amount','farx_dp.var.deprn_amount','NUMBER');
499: fa_rx_util_pkg.assign_column('18','rsv.ytd_deprn', 'ytd_deprn','farx_dp.var.ytd_deprn','NUMBER');
500: fa_rx_util_pkg.assign_column('19','rsv.deprn_reserve', 'ltd_deprn','farx_dp.var.reserve','NUMBER');
501: fa_rx_util_pkg.assign_column('20','nvl(dh.units_assigned,0)/nvl(ah.units,1)*100','percent','farx_dp.var.percent', 'NUMBER');
502: fa_rx_util_pkg.assign_column('21','rsv.transaction_type', null,'farx_dp.var.transaction_type','VARCHAR2', 1);
503: fa_rx_util_pkg.assign_column('22','dh.location_id', null,'farx_dp.var.location_id','NUMBER');
504: fa_rx_util_pkg.assign_column('23','ah.category_id', null,'farx_dp.var.category_id','NUMBER');
505: fa_rx_util_pkg.assign_column('24','ad.asset_key_ccid', null,'farx_dp.var.asset_key_ccid','NUMBER');
506: fa_rx_util_pkg.assign_column('25', null, 'life_yr_mo','farx_dp.var.life_yr_mo','NUMBER');

Line 503: fa_rx_util_pkg.assign_column('22','dh.location_id', null,'farx_dp.var.location_id','NUMBER');

499: fa_rx_util_pkg.assign_column('18','rsv.ytd_deprn', 'ytd_deprn','farx_dp.var.ytd_deprn','NUMBER');
500: fa_rx_util_pkg.assign_column('19','rsv.deprn_reserve', 'ltd_deprn','farx_dp.var.reserve','NUMBER');
501: fa_rx_util_pkg.assign_column('20','nvl(dh.units_assigned,0)/nvl(ah.units,1)*100','percent','farx_dp.var.percent', 'NUMBER');
502: fa_rx_util_pkg.assign_column('21','rsv.transaction_type', null,'farx_dp.var.transaction_type','VARCHAR2', 1);
503: fa_rx_util_pkg.assign_column('22','dh.location_id', null,'farx_dp.var.location_id','NUMBER');
504: fa_rx_util_pkg.assign_column('23','ah.category_id', null,'farx_dp.var.category_id','NUMBER');
505: fa_rx_util_pkg.assign_column('24','ad.asset_key_ccid', null,'farx_dp.var.asset_key_ccid','NUMBER');
506: fa_rx_util_pkg.assign_column('25', null, 'life_yr_mo','farx_dp.var.life_yr_mo','NUMBER');
507: fa_rx_util_pkg.assign_column('26',null, 'nbv','farx_dp.var.nbv','NUMBER');

Line 504: fa_rx_util_pkg.assign_column('23','ah.category_id', null,'farx_dp.var.category_id','NUMBER');

500: fa_rx_util_pkg.assign_column('19','rsv.deprn_reserve', 'ltd_deprn','farx_dp.var.reserve','NUMBER');
501: fa_rx_util_pkg.assign_column('20','nvl(dh.units_assigned,0)/nvl(ah.units,1)*100','percent','farx_dp.var.percent', 'NUMBER');
502: fa_rx_util_pkg.assign_column('21','rsv.transaction_type', null,'farx_dp.var.transaction_type','VARCHAR2', 1);
503: fa_rx_util_pkg.assign_column('22','dh.location_id', null,'farx_dp.var.location_id','NUMBER');
504: fa_rx_util_pkg.assign_column('23','ah.category_id', null,'farx_dp.var.category_id','NUMBER');
505: fa_rx_util_pkg.assign_column('24','ad.asset_key_ccid', null,'farx_dp.var.asset_key_ccid','NUMBER');
506: fa_rx_util_pkg.assign_column('25', null, 'life_yr_mo','farx_dp.var.life_yr_mo','NUMBER');
507: fa_rx_util_pkg.assign_column('26',null, 'nbv','farx_dp.var.nbv','NUMBER');
508: fa_rx_util_pkg.assign_column('27',null, 'period_name','farx_dp.var.period','VARCHAR2', 15);

Line 505: fa_rx_util_pkg.assign_column('24','ad.asset_key_ccid', null,'farx_dp.var.asset_key_ccid','NUMBER');

501: fa_rx_util_pkg.assign_column('20','nvl(dh.units_assigned,0)/nvl(ah.units,1)*100','percent','farx_dp.var.percent', 'NUMBER');
502: fa_rx_util_pkg.assign_column('21','rsv.transaction_type', null,'farx_dp.var.transaction_type','VARCHAR2', 1);
503: fa_rx_util_pkg.assign_column('22','dh.location_id', null,'farx_dp.var.location_id','NUMBER');
504: fa_rx_util_pkg.assign_column('23','ah.category_id', null,'farx_dp.var.category_id','NUMBER');
505: fa_rx_util_pkg.assign_column('24','ad.asset_key_ccid', null,'farx_dp.var.asset_key_ccid','NUMBER');
506: fa_rx_util_pkg.assign_column('25', null, 'life_yr_mo','farx_dp.var.life_yr_mo','NUMBER');
507: fa_rx_util_pkg.assign_column('26',null, 'nbv','farx_dp.var.nbv','NUMBER');
508: fa_rx_util_pkg.assign_column('27',null, 'period_name','farx_dp.var.period','VARCHAR2', 15);
509: fa_rx_util_pkg.assign_column('28',null, 'deprn_expense_acct','farx_dp.var.acct_all_segs(farx_dp.var.acct_segnum)','VARCHAR2', 25);

Line 506: fa_rx_util_pkg.assign_column('25', null, 'life_yr_mo','farx_dp.var.life_yr_mo','NUMBER');

502: fa_rx_util_pkg.assign_column('21','rsv.transaction_type', null,'farx_dp.var.transaction_type','VARCHAR2', 1);
503: fa_rx_util_pkg.assign_column('22','dh.location_id', null,'farx_dp.var.location_id','NUMBER');
504: fa_rx_util_pkg.assign_column('23','ah.category_id', null,'farx_dp.var.category_id','NUMBER');
505: fa_rx_util_pkg.assign_column('24','ad.asset_key_ccid', null,'farx_dp.var.asset_key_ccid','NUMBER');
506: fa_rx_util_pkg.assign_column('25', null, 'life_yr_mo','farx_dp.var.life_yr_mo','NUMBER');
507: fa_rx_util_pkg.assign_column('26',null, 'nbv','farx_dp.var.nbv','NUMBER');
508: fa_rx_util_pkg.assign_column('27',null, 'period_name','farx_dp.var.period','VARCHAR2', 15);
509: fa_rx_util_pkg.assign_column('28',null, 'deprn_expense_acct','farx_dp.var.acct_all_segs(farx_dp.var.acct_segnum)','VARCHAR2', 25);
510: fa_rx_util_pkg.assign_column('29',null, 'account_description','farx_dp.var.account_description', 'VARCHAR2', 240);

Line 507: fa_rx_util_pkg.assign_column('26',null, 'nbv','farx_dp.var.nbv','NUMBER');

503: fa_rx_util_pkg.assign_column('22','dh.location_id', null,'farx_dp.var.location_id','NUMBER');
504: fa_rx_util_pkg.assign_column('23','ah.category_id', null,'farx_dp.var.category_id','NUMBER');
505: fa_rx_util_pkg.assign_column('24','ad.asset_key_ccid', null,'farx_dp.var.asset_key_ccid','NUMBER');
506: fa_rx_util_pkg.assign_column('25', null, 'life_yr_mo','farx_dp.var.life_yr_mo','NUMBER');
507: fa_rx_util_pkg.assign_column('26',null, 'nbv','farx_dp.var.nbv','NUMBER');
508: fa_rx_util_pkg.assign_column('27',null, 'period_name','farx_dp.var.period','VARCHAR2', 15);
509: fa_rx_util_pkg.assign_column('28',null, 'deprn_expense_acct','farx_dp.var.acct_all_segs(farx_dp.var.acct_segnum)','VARCHAR2', 25);
510: fa_rx_util_pkg.assign_column('29',null, 'account_description','farx_dp.var.account_description', 'VARCHAR2', 240);
511: fa_rx_util_pkg.assign_column('30',null, 'company','farx_dp.var.acct_all_segs(farx_dp.var.bal_segnum)','VARCHAR2', 25);

Line 508: fa_rx_util_pkg.assign_column('27',null, 'period_name','farx_dp.var.period','VARCHAR2', 15);

504: fa_rx_util_pkg.assign_column('23','ah.category_id', null,'farx_dp.var.category_id','NUMBER');
505: fa_rx_util_pkg.assign_column('24','ad.asset_key_ccid', null,'farx_dp.var.asset_key_ccid','NUMBER');
506: fa_rx_util_pkg.assign_column('25', null, 'life_yr_mo','farx_dp.var.life_yr_mo','NUMBER');
507: fa_rx_util_pkg.assign_column('26',null, 'nbv','farx_dp.var.nbv','NUMBER');
508: fa_rx_util_pkg.assign_column('27',null, 'period_name','farx_dp.var.period','VARCHAR2', 15);
509: fa_rx_util_pkg.assign_column('28',null, 'deprn_expense_acct','farx_dp.var.acct_all_segs(farx_dp.var.acct_segnum)','VARCHAR2', 25);
510: fa_rx_util_pkg.assign_column('29',null, 'account_description','farx_dp.var.account_description', 'VARCHAR2', 240);
511: fa_rx_util_pkg.assign_column('30',null, 'company','farx_dp.var.acct_all_segs(farx_dp.var.bal_segnum)','VARCHAR2', 25);
512: fa_rx_util_pkg.assign_column('31',null, 'cost_center','farx_dp.var.acct_all_segs(farx_dp.var.cc_segnum)','VARCHAR2', 25);

Line 509: fa_rx_util_pkg.assign_column('28',null, 'deprn_expense_acct','farx_dp.var.acct_all_segs(farx_dp.var.acct_segnum)','VARCHAR2', 25);

505: fa_rx_util_pkg.assign_column('24','ad.asset_key_ccid', null,'farx_dp.var.asset_key_ccid','NUMBER');
506: fa_rx_util_pkg.assign_column('25', null, 'life_yr_mo','farx_dp.var.life_yr_mo','NUMBER');
507: fa_rx_util_pkg.assign_column('26',null, 'nbv','farx_dp.var.nbv','NUMBER');
508: fa_rx_util_pkg.assign_column('27',null, 'period_name','farx_dp.var.period','VARCHAR2', 15);
509: fa_rx_util_pkg.assign_column('28',null, 'deprn_expense_acct','farx_dp.var.acct_all_segs(farx_dp.var.acct_segnum)','VARCHAR2', 25);
510: fa_rx_util_pkg.assign_column('29',null, 'account_description','farx_dp.var.account_description', 'VARCHAR2', 240);
511: fa_rx_util_pkg.assign_column('30',null, 'company','farx_dp.var.acct_all_segs(farx_dp.var.bal_segnum)','VARCHAR2', 25);
512: fa_rx_util_pkg.assign_column('31',null, 'cost_center','farx_dp.var.acct_all_segs(farx_dp.var.cc_segnum)','VARCHAR2', 25);
513: fa_rx_util_pkg.assign_column('32',null, 'book_type_code','farx_dp.var.book','VARCHAR2', 15);

Line 510: fa_rx_util_pkg.assign_column('29',null, 'account_description','farx_dp.var.account_description', 'VARCHAR2', 240);

506: fa_rx_util_pkg.assign_column('25', null, 'life_yr_mo','farx_dp.var.life_yr_mo','NUMBER');
507: fa_rx_util_pkg.assign_column('26',null, 'nbv','farx_dp.var.nbv','NUMBER');
508: fa_rx_util_pkg.assign_column('27',null, 'period_name','farx_dp.var.period','VARCHAR2', 15);
509: fa_rx_util_pkg.assign_column('28',null, 'deprn_expense_acct','farx_dp.var.acct_all_segs(farx_dp.var.acct_segnum)','VARCHAR2', 25);
510: fa_rx_util_pkg.assign_column('29',null, 'account_description','farx_dp.var.account_description', 'VARCHAR2', 240);
511: fa_rx_util_pkg.assign_column('30',null, 'company','farx_dp.var.acct_all_segs(farx_dp.var.bal_segnum)','VARCHAR2', 25);
512: fa_rx_util_pkg.assign_column('31',null, 'cost_center','farx_dp.var.acct_all_segs(farx_dp.var.cc_segnum)','VARCHAR2', 25);
513: fa_rx_util_pkg.assign_column('32',null, 'book_type_code','farx_dp.var.book','VARCHAR2', 15);
514: fa_rx_util_pkg.assign_column('33',null, 'category','farx_dp.var.concat_cat_str','VARCHAR2', 500);

Line 511: fa_rx_util_pkg.assign_column('30',null, 'company','farx_dp.var.acct_all_segs(farx_dp.var.bal_segnum)','VARCHAR2', 25);

507: fa_rx_util_pkg.assign_column('26',null, 'nbv','farx_dp.var.nbv','NUMBER');
508: fa_rx_util_pkg.assign_column('27',null, 'period_name','farx_dp.var.period','VARCHAR2', 15);
509: fa_rx_util_pkg.assign_column('28',null, 'deprn_expense_acct','farx_dp.var.acct_all_segs(farx_dp.var.acct_segnum)','VARCHAR2', 25);
510: fa_rx_util_pkg.assign_column('29',null, 'account_description','farx_dp.var.account_description', 'VARCHAR2', 240);
511: fa_rx_util_pkg.assign_column('30',null, 'company','farx_dp.var.acct_all_segs(farx_dp.var.bal_segnum)','VARCHAR2', 25);
512: fa_rx_util_pkg.assign_column('31',null, 'cost_center','farx_dp.var.acct_all_segs(farx_dp.var.cc_segnum)','VARCHAR2', 25);
513: fa_rx_util_pkg.assign_column('32',null, 'book_type_code','farx_dp.var.book','VARCHAR2', 15);
514: fa_rx_util_pkg.assign_column('33',null, 'category','farx_dp.var.concat_cat_str','VARCHAR2', 500);
515: fa_rx_util_pkg.assign_column('34',null, 'location','farx_dp.var.concat_loc_str','VARCHAR2', 500);

Line 512: fa_rx_util_pkg.assign_column('31',null, 'cost_center','farx_dp.var.acct_all_segs(farx_dp.var.cc_segnum)','VARCHAR2', 25);

508: fa_rx_util_pkg.assign_column('27',null, 'period_name','farx_dp.var.period','VARCHAR2', 15);
509: fa_rx_util_pkg.assign_column('28',null, 'deprn_expense_acct','farx_dp.var.acct_all_segs(farx_dp.var.acct_segnum)','VARCHAR2', 25);
510: fa_rx_util_pkg.assign_column('29',null, 'account_description','farx_dp.var.account_description', 'VARCHAR2', 240);
511: fa_rx_util_pkg.assign_column('30',null, 'company','farx_dp.var.acct_all_segs(farx_dp.var.bal_segnum)','VARCHAR2', 25);
512: fa_rx_util_pkg.assign_column('31',null, 'cost_center','farx_dp.var.acct_all_segs(farx_dp.var.cc_segnum)','VARCHAR2', 25);
513: fa_rx_util_pkg.assign_column('32',null, 'book_type_code','farx_dp.var.book','VARCHAR2', 15);
514: fa_rx_util_pkg.assign_column('33',null, 'category','farx_dp.var.concat_cat_str','VARCHAR2', 500);
515: fa_rx_util_pkg.assign_column('34',null, 'location','farx_dp.var.concat_loc_str','VARCHAR2', 500);
516: fa_rx_util_pkg.assign_column('35',null, 'asset_key','farx_dp.var.concat_key_str','VARCHAR2', 240);

Line 513: fa_rx_util_pkg.assign_column('32',null, 'book_type_code','farx_dp.var.book','VARCHAR2', 15);

509: fa_rx_util_pkg.assign_column('28',null, 'deprn_expense_acct','farx_dp.var.acct_all_segs(farx_dp.var.acct_segnum)','VARCHAR2', 25);
510: fa_rx_util_pkg.assign_column('29',null, 'account_description','farx_dp.var.account_description', 'VARCHAR2', 240);
511: fa_rx_util_pkg.assign_column('30',null, 'company','farx_dp.var.acct_all_segs(farx_dp.var.bal_segnum)','VARCHAR2', 25);
512: fa_rx_util_pkg.assign_column('31',null, 'cost_center','farx_dp.var.acct_all_segs(farx_dp.var.cc_segnum)','VARCHAR2', 25);
513: fa_rx_util_pkg.assign_column('32',null, 'book_type_code','farx_dp.var.book','VARCHAR2', 15);
514: fa_rx_util_pkg.assign_column('33',null, 'category','farx_dp.var.concat_cat_str','VARCHAR2', 500);
515: fa_rx_util_pkg.assign_column('34',null, 'location','farx_dp.var.concat_loc_str','VARCHAR2', 500);
516: fa_rx_util_pkg.assign_column('35',null, 'asset_key','farx_dp.var.concat_key_str','VARCHAR2', 240);
517: fa_rx_util_pkg.assign_column('36','cat.description', 'category_description', 'farx_dp.var.category_description','VARCHAR2',240);

Line 514: fa_rx_util_pkg.assign_column('33',null, 'category','farx_dp.var.concat_cat_str','VARCHAR2', 500);

510: fa_rx_util_pkg.assign_column('29',null, 'account_description','farx_dp.var.account_description', 'VARCHAR2', 240);
511: fa_rx_util_pkg.assign_column('30',null, 'company','farx_dp.var.acct_all_segs(farx_dp.var.bal_segnum)','VARCHAR2', 25);
512: fa_rx_util_pkg.assign_column('31',null, 'cost_center','farx_dp.var.acct_all_segs(farx_dp.var.cc_segnum)','VARCHAR2', 25);
513: fa_rx_util_pkg.assign_column('32',null, 'book_type_code','farx_dp.var.book','VARCHAR2', 15);
514: fa_rx_util_pkg.assign_column('33',null, 'category','farx_dp.var.concat_cat_str','VARCHAR2', 500);
515: fa_rx_util_pkg.assign_column('34',null, 'location','farx_dp.var.concat_loc_str','VARCHAR2', 500);
516: fa_rx_util_pkg.assign_column('35',null, 'asset_key','farx_dp.var.concat_key_str','VARCHAR2', 240);
517: fa_rx_util_pkg.assign_column('36','cat.description', 'category_description', 'farx_dp.var.category_description','VARCHAR2',240);
518: fa_rx_util_pkg.assign_column('37','substrb(emp.full_name, 1,50)', 'employee_name','farx_dp.var.emp_name','VARCHAR2',50);

Line 515: fa_rx_util_pkg.assign_column('34',null, 'location','farx_dp.var.concat_loc_str','VARCHAR2', 500);

511: fa_rx_util_pkg.assign_column('30',null, 'company','farx_dp.var.acct_all_segs(farx_dp.var.bal_segnum)','VARCHAR2', 25);
512: fa_rx_util_pkg.assign_column('31',null, 'cost_center','farx_dp.var.acct_all_segs(farx_dp.var.cc_segnum)','VARCHAR2', 25);
513: fa_rx_util_pkg.assign_column('32',null, 'book_type_code','farx_dp.var.book','VARCHAR2', 15);
514: fa_rx_util_pkg.assign_column('33',null, 'category','farx_dp.var.concat_cat_str','VARCHAR2', 500);
515: fa_rx_util_pkg.assign_column('34',null, 'location','farx_dp.var.concat_loc_str','VARCHAR2', 500);
516: fa_rx_util_pkg.assign_column('35',null, 'asset_key','farx_dp.var.concat_key_str','VARCHAR2', 240);
517: fa_rx_util_pkg.assign_column('36','cat.description', 'category_description', 'farx_dp.var.category_description','VARCHAR2',240);
518: fa_rx_util_pkg.assign_column('37','substrb(emp.full_name, 1,50)', 'employee_name','farx_dp.var.emp_name','VARCHAR2',50);
519: fa_rx_util_pkg.assign_column('38','substrb(emp.employee_number, 1, 15)', 'employee_number','farx_dp.var.emp_number','VARCHAR2',15);

Line 516: fa_rx_util_pkg.assign_column('35',null, 'asset_key','farx_dp.var.concat_key_str','VARCHAR2', 240);

512: fa_rx_util_pkg.assign_column('31',null, 'cost_center','farx_dp.var.acct_all_segs(farx_dp.var.cc_segnum)','VARCHAR2', 25);
513: fa_rx_util_pkg.assign_column('32',null, 'book_type_code','farx_dp.var.book','VARCHAR2', 15);
514: fa_rx_util_pkg.assign_column('33',null, 'category','farx_dp.var.concat_cat_str','VARCHAR2', 500);
515: fa_rx_util_pkg.assign_column('34',null, 'location','farx_dp.var.concat_loc_str','VARCHAR2', 500);
516: fa_rx_util_pkg.assign_column('35',null, 'asset_key','farx_dp.var.concat_key_str','VARCHAR2', 240);
517: fa_rx_util_pkg.assign_column('36','cat.description', 'category_description', 'farx_dp.var.category_description','VARCHAR2',240);
518: fa_rx_util_pkg.assign_column('37','substrb(emp.full_name, 1,50)', 'employee_name','farx_dp.var.emp_name','VARCHAR2',50);
519: fa_rx_util_pkg.assign_column('38','substrb(emp.employee_number, 1, 15)', 'employee_number','farx_dp.var.emp_number','VARCHAR2',15);
520: fa_rx_util_pkg.assign_column('39','dh.units_assigned', 'units','farx_dp.var.units','NUMBER');

Line 517: fa_rx_util_pkg.assign_column('36','cat.description', 'category_description', 'farx_dp.var.category_description','VARCHAR2',240);

513: fa_rx_util_pkg.assign_column('32',null, 'book_type_code','farx_dp.var.book','VARCHAR2', 15);
514: fa_rx_util_pkg.assign_column('33',null, 'category','farx_dp.var.concat_cat_str','VARCHAR2', 500);
515: fa_rx_util_pkg.assign_column('34',null, 'location','farx_dp.var.concat_loc_str','VARCHAR2', 500);
516: fa_rx_util_pkg.assign_column('35',null, 'asset_key','farx_dp.var.concat_key_str','VARCHAR2', 240);
517: fa_rx_util_pkg.assign_column('36','cat.description', 'category_description', 'farx_dp.var.category_description','VARCHAR2',240);
518: fa_rx_util_pkg.assign_column('37','substrb(emp.full_name, 1,50)', 'employee_name','farx_dp.var.emp_name','VARCHAR2',50);
519: fa_rx_util_pkg.assign_column('38','substrb(emp.employee_number, 1, 15)', 'employee_number','farx_dp.var.emp_number','VARCHAR2',15);
520: fa_rx_util_pkg.assign_column('39','dh.units_assigned', 'units','farx_dp.var.units','NUMBER');
521: fa_rx_util_pkg.assign_column('40',null, 'company_description',

Line 518: fa_rx_util_pkg.assign_column('37','substrb(emp.full_name, 1,50)', 'employee_name','farx_dp.var.emp_name','VARCHAR2',50);

514: fa_rx_util_pkg.assign_column('33',null, 'category','farx_dp.var.concat_cat_str','VARCHAR2', 500);
515: fa_rx_util_pkg.assign_column('34',null, 'location','farx_dp.var.concat_loc_str','VARCHAR2', 500);
516: fa_rx_util_pkg.assign_column('35',null, 'asset_key','farx_dp.var.concat_key_str','VARCHAR2', 240);
517: fa_rx_util_pkg.assign_column('36','cat.description', 'category_description', 'farx_dp.var.category_description','VARCHAR2',240);
518: fa_rx_util_pkg.assign_column('37','substrb(emp.full_name, 1,50)', 'employee_name','farx_dp.var.emp_name','VARCHAR2',50);
519: fa_rx_util_pkg.assign_column('38','substrb(emp.employee_number, 1, 15)', 'employee_number','farx_dp.var.emp_number','VARCHAR2',15);
520: fa_rx_util_pkg.assign_column('39','dh.units_assigned', 'units','farx_dp.var.units','NUMBER');
521: fa_rx_util_pkg.assign_column('40',null, 'company_description',
522: 'farx_dp.var.company_description','VARCHAR2',240);

Line 519: fa_rx_util_pkg.assign_column('38','substrb(emp.employee_number, 1, 15)', 'employee_number','farx_dp.var.emp_number','VARCHAR2',15);

515: fa_rx_util_pkg.assign_column('34',null, 'location','farx_dp.var.concat_loc_str','VARCHAR2', 500);
516: fa_rx_util_pkg.assign_column('35',null, 'asset_key','farx_dp.var.concat_key_str','VARCHAR2', 240);
517: fa_rx_util_pkg.assign_column('36','cat.description', 'category_description', 'farx_dp.var.category_description','VARCHAR2',240);
518: fa_rx_util_pkg.assign_column('37','substrb(emp.full_name, 1,50)', 'employee_name','farx_dp.var.emp_name','VARCHAR2',50);
519: fa_rx_util_pkg.assign_column('38','substrb(emp.employee_number, 1, 15)', 'employee_number','farx_dp.var.emp_number','VARCHAR2',15);
520: fa_rx_util_pkg.assign_column('39','dh.units_assigned', 'units','farx_dp.var.units','NUMBER');
521: fa_rx_util_pkg.assign_column('40',null, 'company_description',
522: 'farx_dp.var.company_description','VARCHAR2',240);
523: fa_rx_util_pkg.assign_column('41',null, 'expense_acct_description',

Line 520: fa_rx_util_pkg.assign_column('39','dh.units_assigned', 'units','farx_dp.var.units','NUMBER');

516: fa_rx_util_pkg.assign_column('35',null, 'asset_key','farx_dp.var.concat_key_str','VARCHAR2', 240);
517: fa_rx_util_pkg.assign_column('36','cat.description', 'category_description', 'farx_dp.var.category_description','VARCHAR2',240);
518: fa_rx_util_pkg.assign_column('37','substrb(emp.full_name, 1,50)', 'employee_name','farx_dp.var.emp_name','VARCHAR2',50);
519: fa_rx_util_pkg.assign_column('38','substrb(emp.employee_number, 1, 15)', 'employee_number','farx_dp.var.emp_number','VARCHAR2',15);
520: fa_rx_util_pkg.assign_column('39','dh.units_assigned', 'units','farx_dp.var.units','NUMBER');
521: fa_rx_util_pkg.assign_column('40',null, 'company_description',
522: 'farx_dp.var.company_description','VARCHAR2',240);
523: fa_rx_util_pkg.assign_column('41',null, 'expense_acct_description',
524: 'farx_dp.var.expense_acct_description','VARCHAR2',240);

Line 521: fa_rx_util_pkg.assign_column('40',null, 'company_description',

517: fa_rx_util_pkg.assign_column('36','cat.description', 'category_description', 'farx_dp.var.category_description','VARCHAR2',240);
518: fa_rx_util_pkg.assign_column('37','substrb(emp.full_name, 1,50)', 'employee_name','farx_dp.var.emp_name','VARCHAR2',50);
519: fa_rx_util_pkg.assign_column('38','substrb(emp.employee_number, 1, 15)', 'employee_number','farx_dp.var.emp_number','VARCHAR2',15);
520: fa_rx_util_pkg.assign_column('39','dh.units_assigned', 'units','farx_dp.var.units','NUMBER');
521: fa_rx_util_pkg.assign_column('40',null, 'company_description',
522: 'farx_dp.var.company_description','VARCHAR2',240);
523: fa_rx_util_pkg.assign_column('41',null, 'expense_acct_description',
524: 'farx_dp.var.expense_acct_description','VARCHAR2',240);
525: fa_rx_util_pkg.assign_column('42',null, 'cost_center_description',

Line 523: fa_rx_util_pkg.assign_column('41',null, 'expense_acct_description',

519: fa_rx_util_pkg.assign_column('38','substrb(emp.employee_number, 1, 15)', 'employee_number','farx_dp.var.emp_number','VARCHAR2',15);
520: fa_rx_util_pkg.assign_column('39','dh.units_assigned', 'units','farx_dp.var.units','NUMBER');
521: fa_rx_util_pkg.assign_column('40',null, 'company_description',
522: 'farx_dp.var.company_description','VARCHAR2',240);
523: fa_rx_util_pkg.assign_column('41',null, 'expense_acct_description',
524: 'farx_dp.var.expense_acct_description','VARCHAR2',240);
525: fa_rx_util_pkg.assign_column('42',null, 'cost_center_description',
526: 'farx_dp.var.cost_center_description','VARCHAR2',240);
527: fa_rx_util_pkg.assign_column('43',null, 'organization_name','farx_dp.var.organization_name','VARCHAR2',80);

Line 525: fa_rx_util_pkg.assign_column('42',null, 'cost_center_description',

521: fa_rx_util_pkg.assign_column('40',null, 'company_description',
522: 'farx_dp.var.company_description','VARCHAR2',240);
523: fa_rx_util_pkg.assign_column('41',null, 'expense_acct_description',
524: 'farx_dp.var.expense_acct_description','VARCHAR2',240);
525: fa_rx_util_pkg.assign_column('42',null, 'cost_center_description',
526: 'farx_dp.var.cost_center_description','VARCHAR2',240);
527: fa_rx_util_pkg.assign_column('43',null, 'organization_name','farx_dp.var.organization_name','VARCHAR2',80);
528: fa_rx_util_pkg.assign_column('44',null, 'functional_currency_code','farx_dp.var.currency_code','VARCHAR2',15);
529: fa_rx_util_pkg.assign_column('45',null, 'nbv_beginning_fy','farx_dp.var.nbv_beginning_fy','NUMBER');

Line 527: fa_rx_util_pkg.assign_column('43',null, 'organization_name','farx_dp.var.organization_name','VARCHAR2',80);

523: fa_rx_util_pkg.assign_column('41',null, 'expense_acct_description',
524: 'farx_dp.var.expense_acct_description','VARCHAR2',240);
525: fa_rx_util_pkg.assign_column('42',null, 'cost_center_description',
526: 'farx_dp.var.cost_center_description','VARCHAR2',240);
527: fa_rx_util_pkg.assign_column('43',null, 'organization_name','farx_dp.var.organization_name','VARCHAR2',80);
528: fa_rx_util_pkg.assign_column('44',null, 'functional_currency_code','farx_dp.var.currency_code','VARCHAR2',15);
529: fa_rx_util_pkg.assign_column('45',null, 'nbv_beginning_fy','farx_dp.var.nbv_beginning_fy','NUMBER');
530: fa_rx_util_pkg.assign_column('46',null, 'set_of_books_id','farx_dp.var.set_of_books_id','NUMBER');
531: fa_rx_util_pkg.assign_column('47',maj_select_statement, 'major_category','farx_dp.var.major_category','VARCHAR2',240);

Line 528: fa_rx_util_pkg.assign_column('44',null, 'functional_currency_code','farx_dp.var.currency_code','VARCHAR2',15);

524: 'farx_dp.var.expense_acct_description','VARCHAR2',240);
525: fa_rx_util_pkg.assign_column('42',null, 'cost_center_description',
526: 'farx_dp.var.cost_center_description','VARCHAR2',240);
527: fa_rx_util_pkg.assign_column('43',null, 'organization_name','farx_dp.var.organization_name','VARCHAR2',80);
528: fa_rx_util_pkg.assign_column('44',null, 'functional_currency_code','farx_dp.var.currency_code','VARCHAR2',15);
529: fa_rx_util_pkg.assign_column('45',null, 'nbv_beginning_fy','farx_dp.var.nbv_beginning_fy','NUMBER');
530: fa_rx_util_pkg.assign_column('46',null, 'set_of_books_id','farx_dp.var.set_of_books_id','NUMBER');
531: fa_rx_util_pkg.assign_column('47',maj_select_statement, 'major_category','farx_dp.var.major_category','VARCHAR2',240);
532: fa_rx_util_pkg.assign_column('48',min_select_statement, 'minor_category','farx_dp.var.minor_category','VARCHAR2',240);

Line 529: fa_rx_util_pkg.assign_column('45',null, 'nbv_beginning_fy','farx_dp.var.nbv_beginning_fy','NUMBER');

525: fa_rx_util_pkg.assign_column('42',null, 'cost_center_description',
526: 'farx_dp.var.cost_center_description','VARCHAR2',240);
527: fa_rx_util_pkg.assign_column('43',null, 'organization_name','farx_dp.var.organization_name','VARCHAR2',80);
528: fa_rx_util_pkg.assign_column('44',null, 'functional_currency_code','farx_dp.var.currency_code','VARCHAR2',15);
529: fa_rx_util_pkg.assign_column('45',null, 'nbv_beginning_fy','farx_dp.var.nbv_beginning_fy','NUMBER');
530: fa_rx_util_pkg.assign_column('46',null, 'set_of_books_id','farx_dp.var.set_of_books_id','NUMBER');
531: fa_rx_util_pkg.assign_column('47',maj_select_statement, 'major_category','farx_dp.var.major_category','VARCHAR2',240);
532: fa_rx_util_pkg.assign_column('48',min_select_statement, 'minor_category','farx_dp.var.minor_category','VARCHAR2',240);
533: fa_rx_util_pkg.assign_column('49',null, 'major_category_description','farx_dp.var.major_category_desc','VARCHAR2',240);

Line 530: fa_rx_util_pkg.assign_column('46',null, 'set_of_books_id','farx_dp.var.set_of_books_id','NUMBER');

526: 'farx_dp.var.cost_center_description','VARCHAR2',240);
527: fa_rx_util_pkg.assign_column('43',null, 'organization_name','farx_dp.var.organization_name','VARCHAR2',80);
528: fa_rx_util_pkg.assign_column('44',null, 'functional_currency_code','farx_dp.var.currency_code','VARCHAR2',15);
529: fa_rx_util_pkg.assign_column('45',null, 'nbv_beginning_fy','farx_dp.var.nbv_beginning_fy','NUMBER');
530: fa_rx_util_pkg.assign_column('46',null, 'set_of_books_id','farx_dp.var.set_of_books_id','NUMBER');
531: fa_rx_util_pkg.assign_column('47',maj_select_statement, 'major_category','farx_dp.var.major_category','VARCHAR2',240);
532: fa_rx_util_pkg.assign_column('48',min_select_statement, 'minor_category','farx_dp.var.minor_category','VARCHAR2',240);
533: fa_rx_util_pkg.assign_column('49',null, 'major_category_description','farx_dp.var.major_category_desc','VARCHAR2',240);
534: fa_rx_util_pkg.assign_column('50',null, 'minor_category_description','farx_dp.var.minor_category_desc','VARCHAR2',240);

Line 531: fa_rx_util_pkg.assign_column('47',maj_select_statement, 'major_category','farx_dp.var.major_category','VARCHAR2',240);

527: fa_rx_util_pkg.assign_column('43',null, 'organization_name','farx_dp.var.organization_name','VARCHAR2',80);
528: fa_rx_util_pkg.assign_column('44',null, 'functional_currency_code','farx_dp.var.currency_code','VARCHAR2',15);
529: fa_rx_util_pkg.assign_column('45',null, 'nbv_beginning_fy','farx_dp.var.nbv_beginning_fy','NUMBER');
530: fa_rx_util_pkg.assign_column('46',null, 'set_of_books_id','farx_dp.var.set_of_books_id','NUMBER');
531: fa_rx_util_pkg.assign_column('47',maj_select_statement, 'major_category','farx_dp.var.major_category','VARCHAR2',240);
532: fa_rx_util_pkg.assign_column('48',min_select_statement, 'minor_category','farx_dp.var.minor_category','VARCHAR2',240);
533: fa_rx_util_pkg.assign_column('49',null, 'major_category_description','farx_dp.var.major_category_desc','VARCHAR2',240);
534: fa_rx_util_pkg.assign_column('50',null, 'minor_category_description','farx_dp.var.minor_category_desc','VARCHAR2',240);
535: fa_rx_util_pkg.assign_column('51',spec_select_statement, 'specified_category_segment','farx_dp.var.specified_cat_seg','VARCHAR2',240);

Line 532: fa_rx_util_pkg.assign_column('48',min_select_statement, 'minor_category','farx_dp.var.minor_category','VARCHAR2',240);

528: fa_rx_util_pkg.assign_column('44',null, 'functional_currency_code','farx_dp.var.currency_code','VARCHAR2',15);
529: fa_rx_util_pkg.assign_column('45',null, 'nbv_beginning_fy','farx_dp.var.nbv_beginning_fy','NUMBER');
530: fa_rx_util_pkg.assign_column('46',null, 'set_of_books_id','farx_dp.var.set_of_books_id','NUMBER');
531: fa_rx_util_pkg.assign_column('47',maj_select_statement, 'major_category','farx_dp.var.major_category','VARCHAR2',240);
532: fa_rx_util_pkg.assign_column('48',min_select_statement, 'minor_category','farx_dp.var.minor_category','VARCHAR2',240);
533: fa_rx_util_pkg.assign_column('49',null, 'major_category_description','farx_dp.var.major_category_desc','VARCHAR2',240);
534: fa_rx_util_pkg.assign_column('50',null, 'minor_category_description','farx_dp.var.minor_category_desc','VARCHAR2',240);
535: fa_rx_util_pkg.assign_column('51',spec_select_statement, 'specified_category_segment','farx_dp.var.specified_cat_seg','VARCHAR2',240);
536: fa_rx_util_pkg.assign_column('52',null, 'specified_category_seg_desc','farx_dp.var.specified_cat_seg_desc','VARCHAR2',240);

Line 533: fa_rx_util_pkg.assign_column('49',null, 'major_category_description','farx_dp.var.major_category_desc','VARCHAR2',240);

529: fa_rx_util_pkg.assign_column('45',null, 'nbv_beginning_fy','farx_dp.var.nbv_beginning_fy','NUMBER');
530: fa_rx_util_pkg.assign_column('46',null, 'set_of_books_id','farx_dp.var.set_of_books_id','NUMBER');
531: fa_rx_util_pkg.assign_column('47',maj_select_statement, 'major_category','farx_dp.var.major_category','VARCHAR2',240);
532: fa_rx_util_pkg.assign_column('48',min_select_statement, 'minor_category','farx_dp.var.minor_category','VARCHAR2',240);
533: fa_rx_util_pkg.assign_column('49',null, 'major_category_description','farx_dp.var.major_category_desc','VARCHAR2',240);
534: fa_rx_util_pkg.assign_column('50',null, 'minor_category_description','farx_dp.var.minor_category_desc','VARCHAR2',240);
535: fa_rx_util_pkg.assign_column('51',spec_select_statement, 'specified_category_segment','farx_dp.var.specified_cat_seg','VARCHAR2',240);
536: fa_rx_util_pkg.assign_column('52',null, 'specified_category_seg_desc','farx_dp.var.specified_cat_seg_desc','VARCHAR2',240);
537: fa_rx_util_pkg.assign_column('53',null, 'reserve_acct_desc','farx_dp.var.reserve_acct_desc','VARCHAR2',240);

Line 534: fa_rx_util_pkg.assign_column('50',null, 'minor_category_description','farx_dp.var.minor_category_desc','VARCHAR2',240);

530: fa_rx_util_pkg.assign_column('46',null, 'set_of_books_id','farx_dp.var.set_of_books_id','NUMBER');
531: fa_rx_util_pkg.assign_column('47',maj_select_statement, 'major_category','farx_dp.var.major_category','VARCHAR2',240);
532: fa_rx_util_pkg.assign_column('48',min_select_statement, 'minor_category','farx_dp.var.minor_category','VARCHAR2',240);
533: fa_rx_util_pkg.assign_column('49',null, 'major_category_description','farx_dp.var.major_category_desc','VARCHAR2',240);
534: fa_rx_util_pkg.assign_column('50',null, 'minor_category_description','farx_dp.var.minor_category_desc','VARCHAR2',240);
535: fa_rx_util_pkg.assign_column('51',spec_select_statement, 'specified_category_segment','farx_dp.var.specified_cat_seg','VARCHAR2',240);
536: fa_rx_util_pkg.assign_column('52',null, 'specified_category_seg_desc','farx_dp.var.specified_cat_seg_desc','VARCHAR2',240);
537: fa_rx_util_pkg.assign_column('53',null, 'reserve_acct_desc','farx_dp.var.reserve_acct_desc','VARCHAR2',240);
538: fa_rx_util_pkg.assign_column('54','decode(ad.asset_type,''GROUP'',ad.asset_number,nvl(ad1.asset_number,lu.meaning))','group_asset_number','farx_dp.var.group_asset_number','VARCHAR2',15);

Line 535: fa_rx_util_pkg.assign_column('51',spec_select_statement, 'specified_category_segment','farx_dp.var.specified_cat_seg','VARCHAR2',240);

531: fa_rx_util_pkg.assign_column('47',maj_select_statement, 'major_category','farx_dp.var.major_category','VARCHAR2',240);
532: fa_rx_util_pkg.assign_column('48',min_select_statement, 'minor_category','farx_dp.var.minor_category','VARCHAR2',240);
533: fa_rx_util_pkg.assign_column('49',null, 'major_category_description','farx_dp.var.major_category_desc','VARCHAR2',240);
534: fa_rx_util_pkg.assign_column('50',null, 'minor_category_description','farx_dp.var.minor_category_desc','VARCHAR2',240);
535: fa_rx_util_pkg.assign_column('51',spec_select_statement, 'specified_category_segment','farx_dp.var.specified_cat_seg','VARCHAR2',240);
536: fa_rx_util_pkg.assign_column('52',null, 'specified_category_seg_desc','farx_dp.var.specified_cat_seg_desc','VARCHAR2',240);
537: fa_rx_util_pkg.assign_column('53',null, 'reserve_acct_desc','farx_dp.var.reserve_acct_desc','VARCHAR2',240);
538: fa_rx_util_pkg.assign_column('54','decode(ad.asset_type,''GROUP'',ad.asset_number,nvl(ad1.asset_number,lu.meaning))','group_asset_number','farx_dp.var.group_asset_number','VARCHAR2',15);
539: fa_rx_util_pkg.assign_column('55','books.salvage_value', 'salvage_value','farx_dp.var.salvage_value','NUMBER');

Line 536: fa_rx_util_pkg.assign_column('52',null, 'specified_category_seg_desc','farx_dp.var.specified_cat_seg_desc','VARCHAR2',240);

532: fa_rx_util_pkg.assign_column('48',min_select_statement, 'minor_category','farx_dp.var.minor_category','VARCHAR2',240);
533: fa_rx_util_pkg.assign_column('49',null, 'major_category_description','farx_dp.var.major_category_desc','VARCHAR2',240);
534: fa_rx_util_pkg.assign_column('50',null, 'minor_category_description','farx_dp.var.minor_category_desc','VARCHAR2',240);
535: fa_rx_util_pkg.assign_column('51',spec_select_statement, 'specified_category_segment','farx_dp.var.specified_cat_seg','VARCHAR2',240);
536: fa_rx_util_pkg.assign_column('52',null, 'specified_category_seg_desc','farx_dp.var.specified_cat_seg_desc','VARCHAR2',240);
537: fa_rx_util_pkg.assign_column('53',null, 'reserve_acct_desc','farx_dp.var.reserve_acct_desc','VARCHAR2',240);
538: fa_rx_util_pkg.assign_column('54','decode(ad.asset_type,''GROUP'',ad.asset_number,nvl(ad1.asset_number,lu.meaning))','group_asset_number','farx_dp.var.group_asset_number','VARCHAR2',15);
539: fa_rx_util_pkg.assign_column('55','books.salvage_value', 'salvage_value','farx_dp.var.salvage_value','NUMBER');
540: fa_rx_util_pkg.assign_column('56','rsv.impairment_reserve', null,'farx_dp.var.impairment_reserve','NUMBER'); --Bug#10412874

Line 537: fa_rx_util_pkg.assign_column('53',null, 'reserve_acct_desc','farx_dp.var.reserve_acct_desc','VARCHAR2',240);

533: fa_rx_util_pkg.assign_column('49',null, 'major_category_description','farx_dp.var.major_category_desc','VARCHAR2',240);
534: fa_rx_util_pkg.assign_column('50',null, 'minor_category_description','farx_dp.var.minor_category_desc','VARCHAR2',240);
535: fa_rx_util_pkg.assign_column('51',spec_select_statement, 'specified_category_segment','farx_dp.var.specified_cat_seg','VARCHAR2',240);
536: fa_rx_util_pkg.assign_column('52',null, 'specified_category_seg_desc','farx_dp.var.specified_cat_seg_desc','VARCHAR2',240);
537: fa_rx_util_pkg.assign_column('53',null, 'reserve_acct_desc','farx_dp.var.reserve_acct_desc','VARCHAR2',240);
538: fa_rx_util_pkg.assign_column('54','decode(ad.asset_type,''GROUP'',ad.asset_number,nvl(ad1.asset_number,lu.meaning))','group_asset_number','farx_dp.var.group_asset_number','VARCHAR2',15);
539: fa_rx_util_pkg.assign_column('55','books.salvage_value', 'salvage_value','farx_dp.var.salvage_value','NUMBER');
540: fa_rx_util_pkg.assign_column('56','rsv.impairment_reserve', null,'farx_dp.var.impairment_reserve','NUMBER'); --Bug#10412874
541: -->>SELECT_END<<--

Line 538: fa_rx_util_pkg.assign_column('54','decode(ad.asset_type,''GROUP'',ad.asset_number,nvl(ad1.asset_number,lu.meaning))','group_asset_number','farx_dp.var.group_asset_number','VARCHAR2',15);

534: fa_rx_util_pkg.assign_column('50',null, 'minor_category_description','farx_dp.var.minor_category_desc','VARCHAR2',240);
535: fa_rx_util_pkg.assign_column('51',spec_select_statement, 'specified_category_segment','farx_dp.var.specified_cat_seg','VARCHAR2',240);
536: fa_rx_util_pkg.assign_column('52',null, 'specified_category_seg_desc','farx_dp.var.specified_cat_seg_desc','VARCHAR2',240);
537: fa_rx_util_pkg.assign_column('53',null, 'reserve_acct_desc','farx_dp.var.reserve_acct_desc','VARCHAR2',240);
538: fa_rx_util_pkg.assign_column('54','decode(ad.asset_type,''GROUP'',ad.asset_number,nvl(ad1.asset_number,lu.meaning))','group_asset_number','farx_dp.var.group_asset_number','VARCHAR2',15);
539: fa_rx_util_pkg.assign_column('55','books.salvage_value', 'salvage_value','farx_dp.var.salvage_value','NUMBER');
540: fa_rx_util_pkg.assign_column('56','rsv.impairment_reserve', null,'farx_dp.var.impairment_reserve','NUMBER'); --Bug#10412874
541: -->>SELECT_END<<--
542:

Line 539: fa_rx_util_pkg.assign_column('55','books.salvage_value', 'salvage_value','farx_dp.var.salvage_value','NUMBER');

535: fa_rx_util_pkg.assign_column('51',spec_select_statement, 'specified_category_segment','farx_dp.var.specified_cat_seg','VARCHAR2',240);
536: fa_rx_util_pkg.assign_column('52',null, 'specified_category_seg_desc','farx_dp.var.specified_cat_seg_desc','VARCHAR2',240);
537: fa_rx_util_pkg.assign_column('53',null, 'reserve_acct_desc','farx_dp.var.reserve_acct_desc','VARCHAR2',240);
538: fa_rx_util_pkg.assign_column('54','decode(ad.asset_type,''GROUP'',ad.asset_number,nvl(ad1.asset_number,lu.meaning))','group_asset_number','farx_dp.var.group_asset_number','VARCHAR2',15);
539: fa_rx_util_pkg.assign_column('55','books.salvage_value', 'salvage_value','farx_dp.var.salvage_value','NUMBER');
540: fa_rx_util_pkg.assign_column('56','rsv.impairment_reserve', null,'farx_dp.var.impairment_reserve','NUMBER'); --Bug#10412874
541: -->>SELECT_END<<--
542:
543:

Line 540: fa_rx_util_pkg.assign_column('56','rsv.impairment_reserve', null,'farx_dp.var.impairment_reserve','NUMBER'); --Bug#10412874

536: fa_rx_util_pkg.assign_column('52',null, 'specified_category_seg_desc','farx_dp.var.specified_cat_seg_desc','VARCHAR2',240);
537: fa_rx_util_pkg.assign_column('53',null, 'reserve_acct_desc','farx_dp.var.reserve_acct_desc','VARCHAR2',240);
538: fa_rx_util_pkg.assign_column('54','decode(ad.asset_type,''GROUP'',ad.asset_number,nvl(ad1.asset_number,lu.meaning))','group_asset_number','farx_dp.var.group_asset_number','VARCHAR2',15);
539: fa_rx_util_pkg.assign_column('55','books.salvage_value', 'salvage_value','farx_dp.var.salvage_value','NUMBER');
540: fa_rx_util_pkg.assign_column('56','rsv.impairment_reserve', null,'farx_dp.var.impairment_reserve','NUMBER'); --Bug#10412874
541: -->>SELECT_END<<--
542:
543:
544: --

Line 548: fa_rx_util_pkg.From_Clause := 'fa_reserve_ledger_gt rsv,

544: --
545: -- Assign From Clause
546: --
547: if(param.mrcsobtype <> 'R') then -- MRC
548: fa_rx_util_pkg.From_Clause := 'fa_reserve_ledger_gt rsv,
549: fa_distribution_history dh,
550: fa_additions ad,
551: fa_additions ad1,
552: fa_asset_history ah,

Line 565: fa_rx_util_pkg.From_Clause := 'fa_reserve_ledger_gt rsv,

561: fa_deprn_detail dd,
562: fa_lookups lu';
563: -- MRC
564: else
565: fa_rx_util_pkg.From_Clause := 'fa_reserve_ledger_gt rsv,
566: fa_distribution_history dh,
567: fa_additions ad,
568: fa_additions ad1,
569: fa_asset_history ah,

Line 587: fa_rx_util_pkg.Where_Clause := '

583: --
584: -- Assign Where Clause
585: --
586: if(param.mrcsobtype <> 'R') then -- MRC
587: fa_rx_util_pkg.Where_Clause := '
588: rsv.asset_id = ad.asset_id
589: and rsv.asset_id = dh.asset_id
590: and rsv.dh_ccid = dh.code_combination_id
591: and rsv.distribution_id = dh.distribution_id

Line 644: fa_rx_util_pkg.Where_Clause := '

640: )
641: and dd.period_counter = rsv.period_counter ' || l_param_where ;
642: -- MRC
643: else
644: fa_rx_util_pkg.Where_Clause := '
645: rsv.asset_id = ad.asset_id
646: and rsv.asset_id = dh.asset_id
647: and rsv.dh_ccid = dh.code_combination_id
648: and rsv.distribution_id = dh.distribution_id

Line 709: fa_rx_util_pkg.debug('farx_dp.before_report()-');

705: end if;
706: -- End MRC
707:
708: mesg_name := 'FA_DEPRN_SQL_DCUR';
709: fa_rx_util_pkg.debug('farx_dp.before_report()-');
710: end before_report;
711:
712:
713: /*

Line 725: fa_rx_util_pkg.debug('farx_dp.bind()+');

721: -- These bind variables were included in the WHERE clause.
722: --
723:
724: IF (g_print_debug) THEN
725: fa_rx_util_pkg.debug('farx_dp.bind()+');
726: END IF;
727: dbms_sql.bind_variable(c, 'b_book', var.book);
728: dbms_sql.bind_variable(c, 'b_fy_name', var.fy_name);
729: dbms_sql.bind_variable(c, 'b_report_style', var.report_style);

Line 774: fa_rx_util_pkg.debug('farx_dp.bind()-');

770: dbms_sql.bind_variable(c, 'from_cat_seg_val', param.from_cat_seg_val);
771: dbms_sql.bind_variable(c, 'to_cat_seg_val', param.to_cat_seg_val);
772: END IF;
773: IF (g_print_debug) THEN
774: fa_rx_util_pkg.debug('farx_dp.bind()-');
775: END IF;
776: end bind;
777:
778:

Line 786: fa_rx_util_pkg.debug('farx_dp.after_fetch()+');

782: */
783: procedure after_fetch
784: is
785: begin
786: fa_rx_util_pkg.debug('farx_dp.after_fetch()+');
787: var.account_description := fa_rx_shared_pkg.get_flex_val_meaning(
788: NULL, var.acct_valueset_name, var.asset_cost_acct);
789:
790: mesg_name := 'FA_RX_CONCAT_SEGS';

Line 923: fa_rx_util_pkg.debug('farx_dp.after_fetch()-');

919: fnd_number.canonical_to_number(
920: to_char(floor(var.life/12))||'.'||to_char(mod(var.life,12), 'FM00'));
921: END IF;
922: mesg_name := 'FA_SHARED_INSERT_FAILED';
923: fa_rx_util_pkg.debug('farx_dp.after_fetch()-');
924: end after_fetch;
925: END FARX_DP;