1: PACKAGE BODY FARX_DP AS
2: /* $Header: farxdpb.pls 120.22 2011/02/16 14:12:18 gigupta ship $ */
3:
4: --
5: -- Structure to hold values of all parameters
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: --
187: param.mrcsobtype := 'P';
188: end if;
189: -- End MRC
190:
191: fnd_profile.get('USER_ID',farx_dp.var.user_id);
192:
193: farx_dp.var.login_id := login_id;
194:
195: IF (g_print_debug) THEN
189: -- End MRC
190:
191: fnd_profile.get('USER_ID',farx_dp.var.user_id);
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);
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: --
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;',
218: null);
219:
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;',
218: null);
219:
220: --
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;',
218: null);
219:
220: --
221: -- Run the report
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;
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);
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:
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,
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);
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);
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);
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);
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);
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');
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);
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');
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');
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');
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');
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');
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');
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');
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');
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');
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);
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');
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');
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');
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');
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');
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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');
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',
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);
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',
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);
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',
526: 'farx_dp.var.cost_center_description','VARCHAR2',240);
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);
528: fa_rx_util_pkg.assign_column('44',null, 'functional_currency_code','farx_dp.var.currency_code','VARCHAR2',15);
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');
530: fa_rx_util_pkg.assign_column('46',null, 'set_of_books_id','farx_dp.var.set_of_books_id','NUMBER');
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);
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);
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);
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);
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);
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);
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);
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);
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');
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
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<<--
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:
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:
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: --
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: /*
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);
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:
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';
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;
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;