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 137: fa_rx_util_pkg.debug('farx_dp.deprn_run()+');

133: )
134: is
135: BEGIN
136: IF (g_print_debug) THEN
137: fa_rx_util_pkg.debug('farx_dp.deprn_run()+');
138: fa_rx_util_pkg.debug('deprn_run: ' || '********login_id:' || login_id);
139: fa_rx_util_pkg.debug('deprn_run: ' || '********request_id:' || request_id);
140: END IF;
141: --

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

134: is
135: BEGIN
136: IF (g_print_debug) THEN
137: fa_rx_util_pkg.debug('farx_dp.deprn_run()+');
138: fa_rx_util_pkg.debug('deprn_run: ' || '********login_id:' || login_id);
139: fa_rx_util_pkg.debug('deprn_run: ' || '********request_id:' || request_id);
140: END IF;
141: --
142: -- Assign parameters to global variable

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

135: BEGIN
136: IF (g_print_debug) THEN
137: fa_rx_util_pkg.debug('farx_dp.deprn_run()+');
138: fa_rx_util_pkg.debug('deprn_run: ' || '********login_id:' || login_id);
139: fa_rx_util_pkg.debug('deprn_run: ' || '********request_id:' || request_id);
140: END IF;
141: --
142: -- Assign parameters to global variable
143: -- These values will be used within the before_report trigger

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

168:
169: farx_dp.var.login_id := login_id;
170:
171: IF (g_print_debug) THEN
172: fa_rx_util_pkg.debug('deprn_run: ' || 'Book = '||var.book);
173: fa_rx_util_pkg.debug('deprn_run: ' || 'Period = '||var.period);
174: fa_rx_util_pkg.debug('deprn_run: ' || 'Report_Style = '||var.report_style);
175: END IF;
176:

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

169: farx_dp.var.login_id := login_id;
170:
171: IF (g_print_debug) THEN
172: fa_rx_util_pkg.debug('deprn_run: ' || 'Book = '||var.book);
173: fa_rx_util_pkg.debug('deprn_run: ' || 'Period = '||var.period);
174: fa_rx_util_pkg.debug('deprn_run: ' || 'Report_Style = '||var.report_style);
175: END IF;
176:
177: --

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

170:
171: IF (g_print_debug) THEN
172: fa_rx_util_pkg.debug('deprn_run: ' || 'Book = '||var.book);
173: fa_rx_util_pkg.debug('deprn_run: ' || 'Period = '||var.period);
174: fa_rx_util_pkg.debug('deprn_run: ' || 'Report_Style = '||var.report_style);
175: END IF;
176:
177: --
178: -- Initialize request

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

176:
177: --
178: -- Initialize request
179: --
180: fa_rx_util_pkg.init_request('farx_dp.deprn_rep', request_id, 'FA_DEPRN_REP_ITF');
181:
182: --
183: -- Assign report triggers for this report.
184: --

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

181:
182: --
183: -- Assign report triggers for this report.
184: --
185: fa_rx_util_pkg.assign_report('RESERVE LEDGER',
186: true,
187: 'farx_dp.before_report;',
188: 'farx_dp.bind(:CURSOR_SELECT);',
189: 'farx_dp.after_fetch;',

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

191:
192: --
193: -- Run the report
194: --
195: fa_rx_util_pkg.run_report('farx_dp.deprn_rep', retcode, errbuf);
196:
197: IF (g_print_debug) THEN
198: fa_rx_util_pkg.debug('farx_dp.deprn_run()-');
199: END IF;

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

194: --
195: fa_rx_util_pkg.run_report('farx_dp.deprn_rep', retcode, errbuf);
196:
197: IF (g_print_debug) THEN
198: fa_rx_util_pkg.debug('farx_dp.deprn_run()-');
199: END IF;
200: exception
201: when others then
202: fa_rx_util_pkg.log(sqlcode);

Line 202: fa_rx_util_pkg.log(sqlcode);

198: fa_rx_util_pkg.debug('farx_dp.deprn_run()-');
199: END IF;
200: exception
201: when others then
202: fa_rx_util_pkg.log(sqlcode);
203: fa_rx_util_pkg.log(sqlerrm);
204:
205: fnd_message.set_name('OFA', mesg_name);
206: if mesg_name in ('FA_SHARED_DELETE_FAILED', 'FA_SHARED_INSERT_FAILED') then

Line 203: fa_rx_util_pkg.log(sqlerrm);

199: END IF;
200: exception
201: when others then
202: fa_rx_util_pkg.log(sqlcode);
203: fa_rx_util_pkg.log(sqlerrm);
204:
205: fnd_message.set_name('OFA', mesg_name);
206: if mesg_name in ('FA_SHARED_DELETE_FAILED', 'FA_SHARED_INSERT_FAILED') then
207: fnd_message.set_token('TABLE', 'FA_DEPRN_REP_ITF', FALSE);

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

211: end if;
212:
213: mesg_str := fnd_message.get;
214: IF (g_print_debug) THEN
215: fa_rx_util_pkg.debug('deprn_run: ' || mesg_name);
216: END IF;
217: fa_rx_util_pkg.log(mesg_str);
218:
219: if error_errbuf is not null then

Line 217: fa_rx_util_pkg.log(mesg_str);

213: mesg_str := fnd_message.get;
214: IF (g_print_debug) THEN
215: fa_rx_util_pkg.debug('deprn_run: ' || mesg_name);
216: END IF;
217: fa_rx_util_pkg.log(mesg_str);
218:
219: if error_errbuf is not null then
220: retcode := error_retcode;
221: errbuf := error_errbuf;

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

224: errbuf := mesg_str;
225: end if;
226:
227: IF (g_print_debug) THEN
228: fa_rx_util_pkg.debug('farx_dp.deprn_run(EXCEPTION)-');
229: END IF;
230: end deprn_run;
231:
232:

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

247: calendar_period_open_date date;
248: calendar_period_close_date date;
249:
250: begin
251: fa_rx_util_pkg.debug('farx_dp.before_report()+');
252:
253: mesg_name := 'FA_SHARED_NO_FLEX_CHART_ACCTID';
254:
255: select category_flex_structure, location_flex_structure,

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

316: and period_name = var.period;
317:
318: mesg_name := 'FA_RX_RESERVE_LEDGER';
319:
320: fa_rx_util_pkg.debug('********book:' || var.book);
321: fa_rx_util_pkg.debug('******period:' || var.period);
322: fa_rx_util_pkg.debug('period_close:' || period_closed);
323:
324: /* Removed check of period_closed status on 24th Nov 2000

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

317:
318: mesg_name := 'FA_RX_RESERVE_LEDGER';
319:
320: fa_rx_util_pkg.debug('********book:' || var.book);
321: fa_rx_util_pkg.debug('******period:' || var.period);
322: fa_rx_util_pkg.debug('period_close:' || period_closed);
323:
324: /* Removed check of period_closed status on 24th Nov 2000
325: to populate assets information of current open period. */

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

318: mesg_name := 'FA_RX_RESERVE_LEDGER';
319:
320: fa_rx_util_pkg.debug('********book:' || var.book);
321: fa_rx_util_pkg.debug('******period:' || var.period);
322: fa_rx_util_pkg.debug('period_close:' || period_closed);
323:
324: /* Removed check of period_closed status on 24th Nov 2000
325: to populate assets information of current open period. */
326:

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

449: --
450: -- Assign SELECT list
451: --
452: -->>SELECT_START<<--
453: fa_rx_util_pkg.assign_column('1','cc.code_combination_id', null,'farx_dp.var.ccid','NUMBER');
454: fa_rx_util_pkg.assign_column('2','fy.fiscal_year', null,'farx_dp.var.fy','NUMBER');
455: fa_rx_util_pkg.assign_column('3','cb.asset_cost_acct', 'asset_cost_acct','farx_dp.var.asset_cost_acct','VARCHAR2', 25);
456: fa_rx_util_pkg.assign_column('4','rsv.deprn_reserve_acct', 'accum_deprn_acct','farx_dp.var.deprn_rsv_acct','VARCHAR2', 25);
457: fa_rx_util_pkg.assign_column('5','ad.asset_number', 'asset_number','farx_dp.var.asset_number','VARCHAR2', 15);

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

450: -- Assign SELECT list
451: --
452: -->>SELECT_START<<--
453: fa_rx_util_pkg.assign_column('1','cc.code_combination_id', null,'farx_dp.var.ccid','NUMBER');
454: fa_rx_util_pkg.assign_column('2','fy.fiscal_year', null,'farx_dp.var.fy','NUMBER');
455: fa_rx_util_pkg.assign_column('3','cb.asset_cost_acct', 'asset_cost_acct','farx_dp.var.asset_cost_acct','VARCHAR2', 25);
456: fa_rx_util_pkg.assign_column('4','rsv.deprn_reserve_acct', 'accum_deprn_acct','farx_dp.var.deprn_rsv_acct','VARCHAR2', 25);
457: fa_rx_util_pkg.assign_column('5','ad.asset_number', 'asset_number','farx_dp.var.asset_number','VARCHAR2', 15);
458: fa_rx_util_pkg.assign_column('6','ad.description', 'description','farx_dp.var.description','VARCHAR2', 80);

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

451: --
452: -->>SELECT_START<<--
453: fa_rx_util_pkg.assign_column('1','cc.code_combination_id', null,'farx_dp.var.ccid','NUMBER');
454: fa_rx_util_pkg.assign_column('2','fy.fiscal_year', null,'farx_dp.var.fy','NUMBER');
455: fa_rx_util_pkg.assign_column('3','cb.asset_cost_acct', 'asset_cost_acct','farx_dp.var.asset_cost_acct','VARCHAR2', 25);
456: fa_rx_util_pkg.assign_column('4','rsv.deprn_reserve_acct', 'accum_deprn_acct','farx_dp.var.deprn_rsv_acct','VARCHAR2', 25);
457: fa_rx_util_pkg.assign_column('5','ad.asset_number', 'asset_number','farx_dp.var.asset_number','VARCHAR2', 15);
458: fa_rx_util_pkg.assign_column('6','ad.description', 'description','farx_dp.var.description','VARCHAR2', 80);
459: fa_rx_util_pkg.assign_column('7','ad.tag_number', 'tag_number','farx_dp.var.tag_number','VARCHAR2', 15);

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

452: -->>SELECT_START<<--
453: fa_rx_util_pkg.assign_column('1','cc.code_combination_id', null,'farx_dp.var.ccid','NUMBER');
454: fa_rx_util_pkg.assign_column('2','fy.fiscal_year', null,'farx_dp.var.fy','NUMBER');
455: fa_rx_util_pkg.assign_column('3','cb.asset_cost_acct', 'asset_cost_acct','farx_dp.var.asset_cost_acct','VARCHAR2', 25);
456: fa_rx_util_pkg.assign_column('4','rsv.deprn_reserve_acct', 'accum_deprn_acct','farx_dp.var.deprn_rsv_acct','VARCHAR2', 25);
457: fa_rx_util_pkg.assign_column('5','ad.asset_number', 'asset_number','farx_dp.var.asset_number','VARCHAR2', 15);
458: fa_rx_util_pkg.assign_column('6','ad.description', 'description','farx_dp.var.description','VARCHAR2', 80);
459: fa_rx_util_pkg.assign_column('7','ad.tag_number', 'tag_number','farx_dp.var.tag_number','VARCHAR2', 15);
460: fa_rx_util_pkg.assign_column('8','ad.serial_number', 'serial_number','farx_dp.var.serial_number','VARCHAR2', 35);

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

453: fa_rx_util_pkg.assign_column('1','cc.code_combination_id', null,'farx_dp.var.ccid','NUMBER');
454: fa_rx_util_pkg.assign_column('2','fy.fiscal_year', null,'farx_dp.var.fy','NUMBER');
455: fa_rx_util_pkg.assign_column('3','cb.asset_cost_acct', 'asset_cost_acct','farx_dp.var.asset_cost_acct','VARCHAR2', 25);
456: fa_rx_util_pkg.assign_column('4','rsv.deprn_reserve_acct', 'accum_deprn_acct','farx_dp.var.deprn_rsv_acct','VARCHAR2', 25);
457: fa_rx_util_pkg.assign_column('5','ad.asset_number', 'asset_number','farx_dp.var.asset_number','VARCHAR2', 15);
458: fa_rx_util_pkg.assign_column('6','ad.description', 'description','farx_dp.var.description','VARCHAR2', 80);
459: fa_rx_util_pkg.assign_column('7','ad.tag_number', 'tag_number','farx_dp.var.tag_number','VARCHAR2', 15);
460: fa_rx_util_pkg.assign_column('8','ad.serial_number', 'serial_number','farx_dp.var.serial_number','VARCHAR2', 35);
461: fa_rx_util_pkg.assign_column('9','ad.inventorial', 'inventorial','farx_dp.var.inventorial','VARCHAR2', 3);

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

454: fa_rx_util_pkg.assign_column('2','fy.fiscal_year', null,'farx_dp.var.fy','NUMBER');
455: fa_rx_util_pkg.assign_column('3','cb.asset_cost_acct', 'asset_cost_acct','farx_dp.var.asset_cost_acct','VARCHAR2', 25);
456: fa_rx_util_pkg.assign_column('4','rsv.deprn_reserve_acct', 'accum_deprn_acct','farx_dp.var.deprn_rsv_acct','VARCHAR2', 25);
457: fa_rx_util_pkg.assign_column('5','ad.asset_number', 'asset_number','farx_dp.var.asset_number','VARCHAR2', 15);
458: fa_rx_util_pkg.assign_column('6','ad.description', 'description','farx_dp.var.description','VARCHAR2', 80);
459: fa_rx_util_pkg.assign_column('7','ad.tag_number', 'tag_number','farx_dp.var.tag_number','VARCHAR2', 15);
460: fa_rx_util_pkg.assign_column('8','ad.serial_number', 'serial_number','farx_dp.var.serial_number','VARCHAR2', 35);
461: fa_rx_util_pkg.assign_column('9','ad.inventorial', 'inventorial','farx_dp.var.inventorial','VARCHAR2', 3);
462: 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 459: fa_rx_util_pkg.assign_column('7','ad.tag_number', 'tag_number','farx_dp.var.tag_number','VARCHAR2', 15);

455: fa_rx_util_pkg.assign_column('3','cb.asset_cost_acct', 'asset_cost_acct','farx_dp.var.asset_cost_acct','VARCHAR2', 25);
456: fa_rx_util_pkg.assign_column('4','rsv.deprn_reserve_acct', 'accum_deprn_acct','farx_dp.var.deprn_rsv_acct','VARCHAR2', 25);
457: fa_rx_util_pkg.assign_column('5','ad.asset_number', 'asset_number','farx_dp.var.asset_number','VARCHAR2', 15);
458: fa_rx_util_pkg.assign_column('6','ad.description', 'description','farx_dp.var.description','VARCHAR2', 80);
459: fa_rx_util_pkg.assign_column('7','ad.tag_number', 'tag_number','farx_dp.var.tag_number','VARCHAR2', 15);
460: fa_rx_util_pkg.assign_column('8','ad.serial_number', 'serial_number','farx_dp.var.serial_number','VARCHAR2', 35);
461: fa_rx_util_pkg.assign_column('9','ad.inventorial', 'inventorial','farx_dp.var.inventorial','VARCHAR2', 3);
462: fa_rx_util_pkg.assign_column('10','rsv.date_placed_in_service','date_placed_in_service','farx_dp.var.date_placed_in_service','DATE');
463: fa_rx_util_pkg.assign_column('11','rsv.method_code', 'deprn_method','farx_dp.var.method_code', 'VARCHAR2', 15);

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

456: fa_rx_util_pkg.assign_column('4','rsv.deprn_reserve_acct', 'accum_deprn_acct','farx_dp.var.deprn_rsv_acct','VARCHAR2', 25);
457: fa_rx_util_pkg.assign_column('5','ad.asset_number', 'asset_number','farx_dp.var.asset_number','VARCHAR2', 15);
458: fa_rx_util_pkg.assign_column('6','ad.description', 'description','farx_dp.var.description','VARCHAR2', 80);
459: fa_rx_util_pkg.assign_column('7','ad.tag_number', 'tag_number','farx_dp.var.tag_number','VARCHAR2', 15);
460: fa_rx_util_pkg.assign_column('8','ad.serial_number', 'serial_number','farx_dp.var.serial_number','VARCHAR2', 35);
461: fa_rx_util_pkg.assign_column('9','ad.inventorial', 'inventorial','farx_dp.var.inventorial','VARCHAR2', 3);
462: fa_rx_util_pkg.assign_column('10','rsv.date_placed_in_service','date_placed_in_service','farx_dp.var.date_placed_in_service','DATE');
463: fa_rx_util_pkg.assign_column('11','rsv.method_code', 'deprn_method','farx_dp.var.method_code', 'VARCHAR2', 15);
464: fa_rx_util_pkg.assign_column('12','rsv.life', null,'farx_dp.var.life','NUMBER');

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

457: fa_rx_util_pkg.assign_column('5','ad.asset_number', 'asset_number','farx_dp.var.asset_number','VARCHAR2', 15);
458: fa_rx_util_pkg.assign_column('6','ad.description', 'description','farx_dp.var.description','VARCHAR2', 80);
459: fa_rx_util_pkg.assign_column('7','ad.tag_number', 'tag_number','farx_dp.var.tag_number','VARCHAR2', 15);
460: fa_rx_util_pkg.assign_column('8','ad.serial_number', 'serial_number','farx_dp.var.serial_number','VARCHAR2', 35);
461: fa_rx_util_pkg.assign_column('9','ad.inventorial', 'inventorial','farx_dp.var.inventorial','VARCHAR2', 3);
462: fa_rx_util_pkg.assign_column('10','rsv.date_placed_in_service','date_placed_in_service','farx_dp.var.date_placed_in_service','DATE');
463: fa_rx_util_pkg.assign_column('11','rsv.method_code', 'deprn_method','farx_dp.var.method_code', 'VARCHAR2', 15);
464: fa_rx_util_pkg.assign_column('12','rsv.life', null,'farx_dp.var.life','NUMBER');
465: fa_rx_util_pkg.assign_column('13','rsv.rate', 'adjusted_rate','farx_dp.var.rate','NUMBER');

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

458: fa_rx_util_pkg.assign_column('6','ad.description', 'description','farx_dp.var.description','VARCHAR2', 80);
459: fa_rx_util_pkg.assign_column('7','ad.tag_number', 'tag_number','farx_dp.var.tag_number','VARCHAR2', 15);
460: fa_rx_util_pkg.assign_column('8','ad.serial_number', 'serial_number','farx_dp.var.serial_number','VARCHAR2', 35);
461: fa_rx_util_pkg.assign_column('9','ad.inventorial', 'inventorial','farx_dp.var.inventorial','VARCHAR2', 3);
462: fa_rx_util_pkg.assign_column('10','rsv.date_placed_in_service','date_placed_in_service','farx_dp.var.date_placed_in_service','DATE');
463: fa_rx_util_pkg.assign_column('11','rsv.method_code', 'deprn_method','farx_dp.var.method_code', 'VARCHAR2', 15);
464: fa_rx_util_pkg.assign_column('12','rsv.life', null,'farx_dp.var.life','NUMBER');
465: fa_rx_util_pkg.assign_column('13','rsv.rate', 'adjusted_rate','farx_dp.var.rate','NUMBER');
466: fa_rx_util_pkg.assign_column('14','ds.bonus_rate', null,'farx_dp.var.bonus_rate','NUMBER');

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

459: fa_rx_util_pkg.assign_column('7','ad.tag_number', 'tag_number','farx_dp.var.tag_number','VARCHAR2', 15);
460: fa_rx_util_pkg.assign_column('8','ad.serial_number', 'serial_number','farx_dp.var.serial_number','VARCHAR2', 35);
461: fa_rx_util_pkg.assign_column('9','ad.inventorial', 'inventorial','farx_dp.var.inventorial','VARCHAR2', 3);
462: fa_rx_util_pkg.assign_column('10','rsv.date_placed_in_service','date_placed_in_service','farx_dp.var.date_placed_in_service','DATE');
463: fa_rx_util_pkg.assign_column('11','rsv.method_code', 'deprn_method','farx_dp.var.method_code', 'VARCHAR2', 15);
464: fa_rx_util_pkg.assign_column('12','rsv.life', null,'farx_dp.var.life','NUMBER');
465: fa_rx_util_pkg.assign_column('13','rsv.rate', 'adjusted_rate','farx_dp.var.rate','NUMBER');
466: fa_rx_util_pkg.assign_column('14','ds.bonus_rate', null,'farx_dp.var.bonus_rate','NUMBER');
467: fa_rx_util_pkg.assign_column('15','rsv.capacity', null,'farx_dp.var.capacity','NUMBER');

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

460: fa_rx_util_pkg.assign_column('8','ad.serial_number', 'serial_number','farx_dp.var.serial_number','VARCHAR2', 35);
461: fa_rx_util_pkg.assign_column('9','ad.inventorial', 'inventorial','farx_dp.var.inventorial','VARCHAR2', 3);
462: fa_rx_util_pkg.assign_column('10','rsv.date_placed_in_service','date_placed_in_service','farx_dp.var.date_placed_in_service','DATE');
463: fa_rx_util_pkg.assign_column('11','rsv.method_code', 'deprn_method','farx_dp.var.method_code', 'VARCHAR2', 15);
464: fa_rx_util_pkg.assign_column('12','rsv.life', null,'farx_dp.var.life','NUMBER');
465: fa_rx_util_pkg.assign_column('13','rsv.rate', 'adjusted_rate','farx_dp.var.rate','NUMBER');
466: fa_rx_util_pkg.assign_column('14','ds.bonus_rate', null,'farx_dp.var.bonus_rate','NUMBER');
467: fa_rx_util_pkg.assign_column('15','rsv.capacity', null,'farx_dp.var.capacity','NUMBER');
468: fa_rx_util_pkg.assign_column('16','rsv.cost', 'cost','farx_dp.var.cost','NUMBER');

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

461: fa_rx_util_pkg.assign_column('9','ad.inventorial', 'inventorial','farx_dp.var.inventorial','VARCHAR2', 3);
462: fa_rx_util_pkg.assign_column('10','rsv.date_placed_in_service','date_placed_in_service','farx_dp.var.date_placed_in_service','DATE');
463: fa_rx_util_pkg.assign_column('11','rsv.method_code', 'deprn_method','farx_dp.var.method_code', 'VARCHAR2', 15);
464: fa_rx_util_pkg.assign_column('12','rsv.life', null,'farx_dp.var.life','NUMBER');
465: fa_rx_util_pkg.assign_column('13','rsv.rate', 'adjusted_rate','farx_dp.var.rate','NUMBER');
466: fa_rx_util_pkg.assign_column('14','ds.bonus_rate', null,'farx_dp.var.bonus_rate','NUMBER');
467: fa_rx_util_pkg.assign_column('15','rsv.capacity', null,'farx_dp.var.capacity','NUMBER');
468: fa_rx_util_pkg.assign_column('16','rsv.cost', 'cost','farx_dp.var.cost','NUMBER');
469: fa_rx_util_pkg.assign_column('17','rsv.deprn_amount', 'deprn_amount','farx_dp.var.deprn_amount','NUMBER');

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

462: fa_rx_util_pkg.assign_column('10','rsv.date_placed_in_service','date_placed_in_service','farx_dp.var.date_placed_in_service','DATE');
463: fa_rx_util_pkg.assign_column('11','rsv.method_code', 'deprn_method','farx_dp.var.method_code', 'VARCHAR2', 15);
464: fa_rx_util_pkg.assign_column('12','rsv.life', null,'farx_dp.var.life','NUMBER');
465: fa_rx_util_pkg.assign_column('13','rsv.rate', 'adjusted_rate','farx_dp.var.rate','NUMBER');
466: fa_rx_util_pkg.assign_column('14','ds.bonus_rate', null,'farx_dp.var.bonus_rate','NUMBER');
467: fa_rx_util_pkg.assign_column('15','rsv.capacity', null,'farx_dp.var.capacity','NUMBER');
468: fa_rx_util_pkg.assign_column('16','rsv.cost', 'cost','farx_dp.var.cost','NUMBER');
469: fa_rx_util_pkg.assign_column('17','rsv.deprn_amount', 'deprn_amount','farx_dp.var.deprn_amount','NUMBER');
470: fa_rx_util_pkg.assign_column('18','rsv.ytd_deprn', 'ytd_deprn','farx_dp.var.ytd_deprn','NUMBER');

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

463: fa_rx_util_pkg.assign_column('11','rsv.method_code', 'deprn_method','farx_dp.var.method_code', 'VARCHAR2', 15);
464: fa_rx_util_pkg.assign_column('12','rsv.life', null,'farx_dp.var.life','NUMBER');
465: fa_rx_util_pkg.assign_column('13','rsv.rate', 'adjusted_rate','farx_dp.var.rate','NUMBER');
466: fa_rx_util_pkg.assign_column('14','ds.bonus_rate', null,'farx_dp.var.bonus_rate','NUMBER');
467: fa_rx_util_pkg.assign_column('15','rsv.capacity', null,'farx_dp.var.capacity','NUMBER');
468: fa_rx_util_pkg.assign_column('16','rsv.cost', 'cost','farx_dp.var.cost','NUMBER');
469: fa_rx_util_pkg.assign_column('17','rsv.deprn_amount', 'deprn_amount','farx_dp.var.deprn_amount','NUMBER');
470: fa_rx_util_pkg.assign_column('18','rsv.ytd_deprn', 'ytd_deprn','farx_dp.var.ytd_deprn','NUMBER');
471: fa_rx_util_pkg.assign_column('19','rsv.deprn_reserve', 'ltd_deprn','farx_dp.var.reserve','NUMBER');

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

464: fa_rx_util_pkg.assign_column('12','rsv.life', null,'farx_dp.var.life','NUMBER');
465: fa_rx_util_pkg.assign_column('13','rsv.rate', 'adjusted_rate','farx_dp.var.rate','NUMBER');
466: fa_rx_util_pkg.assign_column('14','ds.bonus_rate', null,'farx_dp.var.bonus_rate','NUMBER');
467: fa_rx_util_pkg.assign_column('15','rsv.capacity', null,'farx_dp.var.capacity','NUMBER');
468: fa_rx_util_pkg.assign_column('16','rsv.cost', 'cost','farx_dp.var.cost','NUMBER');
469: fa_rx_util_pkg.assign_column('17','rsv.deprn_amount', 'deprn_amount','farx_dp.var.deprn_amount','NUMBER');
470: fa_rx_util_pkg.assign_column('18','rsv.ytd_deprn', 'ytd_deprn','farx_dp.var.ytd_deprn','NUMBER');
471: fa_rx_util_pkg.assign_column('19','rsv.deprn_reserve', 'ltd_deprn','farx_dp.var.reserve','NUMBER');
472: fa_rx_util_pkg.assign_column('20','nvl(dh.units_assigned,0)/nvl(ah.units,1)*100','percent','farx_dp.var.percent', 'NUMBER');

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

465: fa_rx_util_pkg.assign_column('13','rsv.rate', 'adjusted_rate','farx_dp.var.rate','NUMBER');
466: fa_rx_util_pkg.assign_column('14','ds.bonus_rate', null,'farx_dp.var.bonus_rate','NUMBER');
467: fa_rx_util_pkg.assign_column('15','rsv.capacity', null,'farx_dp.var.capacity','NUMBER');
468: fa_rx_util_pkg.assign_column('16','rsv.cost', 'cost','farx_dp.var.cost','NUMBER');
469: fa_rx_util_pkg.assign_column('17','rsv.deprn_amount', 'deprn_amount','farx_dp.var.deprn_amount','NUMBER');
470: fa_rx_util_pkg.assign_column('18','rsv.ytd_deprn', 'ytd_deprn','farx_dp.var.ytd_deprn','NUMBER');
471: fa_rx_util_pkg.assign_column('19','rsv.deprn_reserve', 'ltd_deprn','farx_dp.var.reserve','NUMBER');
472: fa_rx_util_pkg.assign_column('20','nvl(dh.units_assigned,0)/nvl(ah.units,1)*100','percent','farx_dp.var.percent', 'NUMBER');
473: fa_rx_util_pkg.assign_column('21','rsv.transaction_type', null,'farx_dp.var.transaction_type','VARCHAR2', 1);

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

466: fa_rx_util_pkg.assign_column('14','ds.bonus_rate', null,'farx_dp.var.bonus_rate','NUMBER');
467: fa_rx_util_pkg.assign_column('15','rsv.capacity', null,'farx_dp.var.capacity','NUMBER');
468: fa_rx_util_pkg.assign_column('16','rsv.cost', 'cost','farx_dp.var.cost','NUMBER');
469: fa_rx_util_pkg.assign_column('17','rsv.deprn_amount', 'deprn_amount','farx_dp.var.deprn_amount','NUMBER');
470: fa_rx_util_pkg.assign_column('18','rsv.ytd_deprn', 'ytd_deprn','farx_dp.var.ytd_deprn','NUMBER');
471: fa_rx_util_pkg.assign_column('19','rsv.deprn_reserve', 'ltd_deprn','farx_dp.var.reserve','NUMBER');
472: fa_rx_util_pkg.assign_column('20','nvl(dh.units_assigned,0)/nvl(ah.units,1)*100','percent','farx_dp.var.percent', 'NUMBER');
473: fa_rx_util_pkg.assign_column('21','rsv.transaction_type', null,'farx_dp.var.transaction_type','VARCHAR2', 1);
474: fa_rx_util_pkg.assign_column('22','dh.location_id', null,'farx_dp.var.location_id','NUMBER');

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

467: fa_rx_util_pkg.assign_column('15','rsv.capacity', null,'farx_dp.var.capacity','NUMBER');
468: fa_rx_util_pkg.assign_column('16','rsv.cost', 'cost','farx_dp.var.cost','NUMBER');
469: fa_rx_util_pkg.assign_column('17','rsv.deprn_amount', 'deprn_amount','farx_dp.var.deprn_amount','NUMBER');
470: fa_rx_util_pkg.assign_column('18','rsv.ytd_deprn', 'ytd_deprn','farx_dp.var.ytd_deprn','NUMBER');
471: fa_rx_util_pkg.assign_column('19','rsv.deprn_reserve', 'ltd_deprn','farx_dp.var.reserve','NUMBER');
472: fa_rx_util_pkg.assign_column('20','nvl(dh.units_assigned,0)/nvl(ah.units,1)*100','percent','farx_dp.var.percent', 'NUMBER');
473: fa_rx_util_pkg.assign_column('21','rsv.transaction_type', null,'farx_dp.var.transaction_type','VARCHAR2', 1);
474: fa_rx_util_pkg.assign_column('22','dh.location_id', null,'farx_dp.var.location_id','NUMBER');
475: fa_rx_util_pkg.assign_column('23','ah.category_id', null,'farx_dp.var.category_id','NUMBER');

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

468: fa_rx_util_pkg.assign_column('16','rsv.cost', 'cost','farx_dp.var.cost','NUMBER');
469: fa_rx_util_pkg.assign_column('17','rsv.deprn_amount', 'deprn_amount','farx_dp.var.deprn_amount','NUMBER');
470: fa_rx_util_pkg.assign_column('18','rsv.ytd_deprn', 'ytd_deprn','farx_dp.var.ytd_deprn','NUMBER');
471: fa_rx_util_pkg.assign_column('19','rsv.deprn_reserve', 'ltd_deprn','farx_dp.var.reserve','NUMBER');
472: fa_rx_util_pkg.assign_column('20','nvl(dh.units_assigned,0)/nvl(ah.units,1)*100','percent','farx_dp.var.percent', 'NUMBER');
473: fa_rx_util_pkg.assign_column('21','rsv.transaction_type', null,'farx_dp.var.transaction_type','VARCHAR2', 1);
474: fa_rx_util_pkg.assign_column('22','dh.location_id', null,'farx_dp.var.location_id','NUMBER');
475: fa_rx_util_pkg.assign_column('23','ah.category_id', null,'farx_dp.var.category_id','NUMBER');
476: fa_rx_util_pkg.assign_column('24','ad.asset_key_ccid', null,'farx_dp.var.asset_key_ccid','NUMBER');

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

469: fa_rx_util_pkg.assign_column('17','rsv.deprn_amount', 'deprn_amount','farx_dp.var.deprn_amount','NUMBER');
470: fa_rx_util_pkg.assign_column('18','rsv.ytd_deprn', 'ytd_deprn','farx_dp.var.ytd_deprn','NUMBER');
471: fa_rx_util_pkg.assign_column('19','rsv.deprn_reserve', 'ltd_deprn','farx_dp.var.reserve','NUMBER');
472: fa_rx_util_pkg.assign_column('20','nvl(dh.units_assigned,0)/nvl(ah.units,1)*100','percent','farx_dp.var.percent', 'NUMBER');
473: fa_rx_util_pkg.assign_column('21','rsv.transaction_type', null,'farx_dp.var.transaction_type','VARCHAR2', 1);
474: fa_rx_util_pkg.assign_column('22','dh.location_id', null,'farx_dp.var.location_id','NUMBER');
475: fa_rx_util_pkg.assign_column('23','ah.category_id', null,'farx_dp.var.category_id','NUMBER');
476: fa_rx_util_pkg.assign_column('24','ad.asset_key_ccid', null,'farx_dp.var.asset_key_ccid','NUMBER');
477: fa_rx_util_pkg.assign_column('25', null, 'life_yr_mo','farx_dp.var.life_yr_mo','NUMBER');

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

470: fa_rx_util_pkg.assign_column('18','rsv.ytd_deprn', 'ytd_deprn','farx_dp.var.ytd_deprn','NUMBER');
471: fa_rx_util_pkg.assign_column('19','rsv.deprn_reserve', 'ltd_deprn','farx_dp.var.reserve','NUMBER');
472: fa_rx_util_pkg.assign_column('20','nvl(dh.units_assigned,0)/nvl(ah.units,1)*100','percent','farx_dp.var.percent', 'NUMBER');
473: fa_rx_util_pkg.assign_column('21','rsv.transaction_type', null,'farx_dp.var.transaction_type','VARCHAR2', 1);
474: fa_rx_util_pkg.assign_column('22','dh.location_id', null,'farx_dp.var.location_id','NUMBER');
475: fa_rx_util_pkg.assign_column('23','ah.category_id', null,'farx_dp.var.category_id','NUMBER');
476: fa_rx_util_pkg.assign_column('24','ad.asset_key_ccid', null,'farx_dp.var.asset_key_ccid','NUMBER');
477: fa_rx_util_pkg.assign_column('25', null, 'life_yr_mo','farx_dp.var.life_yr_mo','NUMBER');
478: fa_rx_util_pkg.assign_column('26',null, 'nbv','farx_dp.var.nbv','NUMBER');

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

471: fa_rx_util_pkg.assign_column('19','rsv.deprn_reserve', 'ltd_deprn','farx_dp.var.reserve','NUMBER');
472: fa_rx_util_pkg.assign_column('20','nvl(dh.units_assigned,0)/nvl(ah.units,1)*100','percent','farx_dp.var.percent', 'NUMBER');
473: fa_rx_util_pkg.assign_column('21','rsv.transaction_type', null,'farx_dp.var.transaction_type','VARCHAR2', 1);
474: fa_rx_util_pkg.assign_column('22','dh.location_id', null,'farx_dp.var.location_id','NUMBER');
475: fa_rx_util_pkg.assign_column('23','ah.category_id', null,'farx_dp.var.category_id','NUMBER');
476: fa_rx_util_pkg.assign_column('24','ad.asset_key_ccid', null,'farx_dp.var.asset_key_ccid','NUMBER');
477: fa_rx_util_pkg.assign_column('25', null, 'life_yr_mo','farx_dp.var.life_yr_mo','NUMBER');
478: fa_rx_util_pkg.assign_column('26',null, 'nbv','farx_dp.var.nbv','NUMBER');
479: fa_rx_util_pkg.assign_column('27',null, 'period_name','farx_dp.var.period','VARCHAR2', 15);

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

472: fa_rx_util_pkg.assign_column('20','nvl(dh.units_assigned,0)/nvl(ah.units,1)*100','percent','farx_dp.var.percent', 'NUMBER');
473: fa_rx_util_pkg.assign_column('21','rsv.transaction_type', null,'farx_dp.var.transaction_type','VARCHAR2', 1);
474: fa_rx_util_pkg.assign_column('22','dh.location_id', null,'farx_dp.var.location_id','NUMBER');
475: fa_rx_util_pkg.assign_column('23','ah.category_id', null,'farx_dp.var.category_id','NUMBER');
476: fa_rx_util_pkg.assign_column('24','ad.asset_key_ccid', null,'farx_dp.var.asset_key_ccid','NUMBER');
477: fa_rx_util_pkg.assign_column('25', null, 'life_yr_mo','farx_dp.var.life_yr_mo','NUMBER');
478: fa_rx_util_pkg.assign_column('26',null, 'nbv','farx_dp.var.nbv','NUMBER');
479: fa_rx_util_pkg.assign_column('27',null, 'period_name','farx_dp.var.period','VARCHAR2', 15);
480: 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 477: fa_rx_util_pkg.assign_column('25', null, 'life_yr_mo','farx_dp.var.life_yr_mo','NUMBER');

473: fa_rx_util_pkg.assign_column('21','rsv.transaction_type', null,'farx_dp.var.transaction_type','VARCHAR2', 1);
474: fa_rx_util_pkg.assign_column('22','dh.location_id', null,'farx_dp.var.location_id','NUMBER');
475: fa_rx_util_pkg.assign_column('23','ah.category_id', null,'farx_dp.var.category_id','NUMBER');
476: fa_rx_util_pkg.assign_column('24','ad.asset_key_ccid', null,'farx_dp.var.asset_key_ccid','NUMBER');
477: fa_rx_util_pkg.assign_column('25', null, 'life_yr_mo','farx_dp.var.life_yr_mo','NUMBER');
478: fa_rx_util_pkg.assign_column('26',null, 'nbv','farx_dp.var.nbv','NUMBER');
479: fa_rx_util_pkg.assign_column('27',null, 'period_name','farx_dp.var.period','VARCHAR2', 15);
480: fa_rx_util_pkg.assign_column('28',null, 'deprn_expense_acct','farx_dp.var.acct_all_segs(farx_dp.var.acct_segnum)','VARCHAR2', 25);
481: fa_rx_util_pkg.assign_column('29',null, 'account_description','farx_dp.var.account_description', 'VARCHAR2', 240);

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

474: fa_rx_util_pkg.assign_column('22','dh.location_id', null,'farx_dp.var.location_id','NUMBER');
475: fa_rx_util_pkg.assign_column('23','ah.category_id', null,'farx_dp.var.category_id','NUMBER');
476: fa_rx_util_pkg.assign_column('24','ad.asset_key_ccid', null,'farx_dp.var.asset_key_ccid','NUMBER');
477: fa_rx_util_pkg.assign_column('25', null, 'life_yr_mo','farx_dp.var.life_yr_mo','NUMBER');
478: fa_rx_util_pkg.assign_column('26',null, 'nbv','farx_dp.var.nbv','NUMBER');
479: fa_rx_util_pkg.assign_column('27',null, 'period_name','farx_dp.var.period','VARCHAR2', 15);
480: fa_rx_util_pkg.assign_column('28',null, 'deprn_expense_acct','farx_dp.var.acct_all_segs(farx_dp.var.acct_segnum)','VARCHAR2', 25);
481: fa_rx_util_pkg.assign_column('29',null, 'account_description','farx_dp.var.account_description', 'VARCHAR2', 240);
482: fa_rx_util_pkg.assign_column('30',null, 'company','farx_dp.var.acct_all_segs(farx_dp.var.bal_segnum)','VARCHAR2', 25);

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

475: fa_rx_util_pkg.assign_column('23','ah.category_id', null,'farx_dp.var.category_id','NUMBER');
476: fa_rx_util_pkg.assign_column('24','ad.asset_key_ccid', null,'farx_dp.var.asset_key_ccid','NUMBER');
477: fa_rx_util_pkg.assign_column('25', null, 'life_yr_mo','farx_dp.var.life_yr_mo','NUMBER');
478: fa_rx_util_pkg.assign_column('26',null, 'nbv','farx_dp.var.nbv','NUMBER');
479: fa_rx_util_pkg.assign_column('27',null, 'period_name','farx_dp.var.period','VARCHAR2', 15);
480: fa_rx_util_pkg.assign_column('28',null, 'deprn_expense_acct','farx_dp.var.acct_all_segs(farx_dp.var.acct_segnum)','VARCHAR2', 25);
481: fa_rx_util_pkg.assign_column('29',null, 'account_description','farx_dp.var.account_description', 'VARCHAR2', 240);
482: fa_rx_util_pkg.assign_column('30',null, 'company','farx_dp.var.acct_all_segs(farx_dp.var.bal_segnum)','VARCHAR2', 25);
483: fa_rx_util_pkg.assign_column('31',null, 'cost_center','farx_dp.var.acct_all_segs(farx_dp.var.cc_segnum)','VARCHAR2', 25);

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

476: fa_rx_util_pkg.assign_column('24','ad.asset_key_ccid', null,'farx_dp.var.asset_key_ccid','NUMBER');
477: fa_rx_util_pkg.assign_column('25', null, 'life_yr_mo','farx_dp.var.life_yr_mo','NUMBER');
478: fa_rx_util_pkg.assign_column('26',null, 'nbv','farx_dp.var.nbv','NUMBER');
479: fa_rx_util_pkg.assign_column('27',null, 'period_name','farx_dp.var.period','VARCHAR2', 15);
480: fa_rx_util_pkg.assign_column('28',null, 'deprn_expense_acct','farx_dp.var.acct_all_segs(farx_dp.var.acct_segnum)','VARCHAR2', 25);
481: fa_rx_util_pkg.assign_column('29',null, 'account_description','farx_dp.var.account_description', 'VARCHAR2', 240);
482: fa_rx_util_pkg.assign_column('30',null, 'company','farx_dp.var.acct_all_segs(farx_dp.var.bal_segnum)','VARCHAR2', 25);
483: fa_rx_util_pkg.assign_column('31',null, 'cost_center','farx_dp.var.acct_all_segs(farx_dp.var.cc_segnum)','VARCHAR2', 25);
484: fa_rx_util_pkg.assign_column('32',null, 'book_type_code','farx_dp.var.book','VARCHAR2', 15);

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

477: fa_rx_util_pkg.assign_column('25', null, 'life_yr_mo','farx_dp.var.life_yr_mo','NUMBER');
478: fa_rx_util_pkg.assign_column('26',null, 'nbv','farx_dp.var.nbv','NUMBER');
479: fa_rx_util_pkg.assign_column('27',null, 'period_name','farx_dp.var.period','VARCHAR2', 15);
480: fa_rx_util_pkg.assign_column('28',null, 'deprn_expense_acct','farx_dp.var.acct_all_segs(farx_dp.var.acct_segnum)','VARCHAR2', 25);
481: fa_rx_util_pkg.assign_column('29',null, 'account_description','farx_dp.var.account_description', 'VARCHAR2', 240);
482: fa_rx_util_pkg.assign_column('30',null, 'company','farx_dp.var.acct_all_segs(farx_dp.var.bal_segnum)','VARCHAR2', 25);
483: fa_rx_util_pkg.assign_column('31',null, 'cost_center','farx_dp.var.acct_all_segs(farx_dp.var.cc_segnum)','VARCHAR2', 25);
484: fa_rx_util_pkg.assign_column('32',null, 'book_type_code','farx_dp.var.book','VARCHAR2', 15);
485: fa_rx_util_pkg.assign_column('33',null, 'category','farx_dp.var.concat_cat_str','VARCHAR2', 500);

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

478: fa_rx_util_pkg.assign_column('26',null, 'nbv','farx_dp.var.nbv','NUMBER');
479: fa_rx_util_pkg.assign_column('27',null, 'period_name','farx_dp.var.period','VARCHAR2', 15);
480: fa_rx_util_pkg.assign_column('28',null, 'deprn_expense_acct','farx_dp.var.acct_all_segs(farx_dp.var.acct_segnum)','VARCHAR2', 25);
481: fa_rx_util_pkg.assign_column('29',null, 'account_description','farx_dp.var.account_description', 'VARCHAR2', 240);
482: fa_rx_util_pkg.assign_column('30',null, 'company','farx_dp.var.acct_all_segs(farx_dp.var.bal_segnum)','VARCHAR2', 25);
483: fa_rx_util_pkg.assign_column('31',null, 'cost_center','farx_dp.var.acct_all_segs(farx_dp.var.cc_segnum)','VARCHAR2', 25);
484: fa_rx_util_pkg.assign_column('32',null, 'book_type_code','farx_dp.var.book','VARCHAR2', 15);
485: fa_rx_util_pkg.assign_column('33',null, 'category','farx_dp.var.concat_cat_str','VARCHAR2', 500);
486: fa_rx_util_pkg.assign_column('34',null, 'location','farx_dp.var.concat_loc_str','VARCHAR2', 500);

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

479: fa_rx_util_pkg.assign_column('27',null, 'period_name','farx_dp.var.period','VARCHAR2', 15);
480: fa_rx_util_pkg.assign_column('28',null, 'deprn_expense_acct','farx_dp.var.acct_all_segs(farx_dp.var.acct_segnum)','VARCHAR2', 25);
481: fa_rx_util_pkg.assign_column('29',null, 'account_description','farx_dp.var.account_description', 'VARCHAR2', 240);
482: fa_rx_util_pkg.assign_column('30',null, 'company','farx_dp.var.acct_all_segs(farx_dp.var.bal_segnum)','VARCHAR2', 25);
483: fa_rx_util_pkg.assign_column('31',null, 'cost_center','farx_dp.var.acct_all_segs(farx_dp.var.cc_segnum)','VARCHAR2', 25);
484: fa_rx_util_pkg.assign_column('32',null, 'book_type_code','farx_dp.var.book','VARCHAR2', 15);
485: fa_rx_util_pkg.assign_column('33',null, 'category','farx_dp.var.concat_cat_str','VARCHAR2', 500);
486: fa_rx_util_pkg.assign_column('34',null, 'location','farx_dp.var.concat_loc_str','VARCHAR2', 500);
487: fa_rx_util_pkg.assign_column('35',null, 'asset_key','farx_dp.var.concat_key_str','VARCHAR2', 240);

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

480: fa_rx_util_pkg.assign_column('28',null, 'deprn_expense_acct','farx_dp.var.acct_all_segs(farx_dp.var.acct_segnum)','VARCHAR2', 25);
481: fa_rx_util_pkg.assign_column('29',null, 'account_description','farx_dp.var.account_description', 'VARCHAR2', 240);
482: fa_rx_util_pkg.assign_column('30',null, 'company','farx_dp.var.acct_all_segs(farx_dp.var.bal_segnum)','VARCHAR2', 25);
483: fa_rx_util_pkg.assign_column('31',null, 'cost_center','farx_dp.var.acct_all_segs(farx_dp.var.cc_segnum)','VARCHAR2', 25);
484: fa_rx_util_pkg.assign_column('32',null, 'book_type_code','farx_dp.var.book','VARCHAR2', 15);
485: fa_rx_util_pkg.assign_column('33',null, 'category','farx_dp.var.concat_cat_str','VARCHAR2', 500);
486: fa_rx_util_pkg.assign_column('34',null, 'location','farx_dp.var.concat_loc_str','VARCHAR2', 500);
487: fa_rx_util_pkg.assign_column('35',null, 'asset_key','farx_dp.var.concat_key_str','VARCHAR2', 240);
488: fa_rx_util_pkg.assign_column('36','cat.description', 'category_description', 'farx_dp.var.category_description','VARCHAR2',240);

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

481: fa_rx_util_pkg.assign_column('29',null, 'account_description','farx_dp.var.account_description', 'VARCHAR2', 240);
482: fa_rx_util_pkg.assign_column('30',null, 'company','farx_dp.var.acct_all_segs(farx_dp.var.bal_segnum)','VARCHAR2', 25);
483: fa_rx_util_pkg.assign_column('31',null, 'cost_center','farx_dp.var.acct_all_segs(farx_dp.var.cc_segnum)','VARCHAR2', 25);
484: fa_rx_util_pkg.assign_column('32',null, 'book_type_code','farx_dp.var.book','VARCHAR2', 15);
485: fa_rx_util_pkg.assign_column('33',null, 'category','farx_dp.var.concat_cat_str','VARCHAR2', 500);
486: fa_rx_util_pkg.assign_column('34',null, 'location','farx_dp.var.concat_loc_str','VARCHAR2', 500);
487: fa_rx_util_pkg.assign_column('35',null, 'asset_key','farx_dp.var.concat_key_str','VARCHAR2', 240);
488: fa_rx_util_pkg.assign_column('36','cat.description', 'category_description', 'farx_dp.var.category_description','VARCHAR2',240);
489: fa_rx_util_pkg.assign_column('37','substrb(emp.full_name, 1,50)', 'employee_name','farx_dp.var.emp_name','VARCHAR2',50);

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

482: fa_rx_util_pkg.assign_column('30',null, 'company','farx_dp.var.acct_all_segs(farx_dp.var.bal_segnum)','VARCHAR2', 25);
483: fa_rx_util_pkg.assign_column('31',null, 'cost_center','farx_dp.var.acct_all_segs(farx_dp.var.cc_segnum)','VARCHAR2', 25);
484: fa_rx_util_pkg.assign_column('32',null, 'book_type_code','farx_dp.var.book','VARCHAR2', 15);
485: fa_rx_util_pkg.assign_column('33',null, 'category','farx_dp.var.concat_cat_str','VARCHAR2', 500);
486: fa_rx_util_pkg.assign_column('34',null, 'location','farx_dp.var.concat_loc_str','VARCHAR2', 500);
487: fa_rx_util_pkg.assign_column('35',null, 'asset_key','farx_dp.var.concat_key_str','VARCHAR2', 240);
488: fa_rx_util_pkg.assign_column('36','cat.description', 'category_description', 'farx_dp.var.category_description','VARCHAR2',240);
489: fa_rx_util_pkg.assign_column('37','substrb(emp.full_name, 1,50)', 'employee_name','farx_dp.var.emp_name','VARCHAR2',50);
490: fa_rx_util_pkg.assign_column('38','substrb(emp.employee_number, 1, 15)', 'employee_number','farx_dp.var.emp_number','VARCHAR2',15);

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

483: fa_rx_util_pkg.assign_column('31',null, 'cost_center','farx_dp.var.acct_all_segs(farx_dp.var.cc_segnum)','VARCHAR2', 25);
484: fa_rx_util_pkg.assign_column('32',null, 'book_type_code','farx_dp.var.book','VARCHAR2', 15);
485: fa_rx_util_pkg.assign_column('33',null, 'category','farx_dp.var.concat_cat_str','VARCHAR2', 500);
486: fa_rx_util_pkg.assign_column('34',null, 'location','farx_dp.var.concat_loc_str','VARCHAR2', 500);
487: fa_rx_util_pkg.assign_column('35',null, 'asset_key','farx_dp.var.concat_key_str','VARCHAR2', 240);
488: fa_rx_util_pkg.assign_column('36','cat.description', 'category_description', 'farx_dp.var.category_description','VARCHAR2',240);
489: fa_rx_util_pkg.assign_column('37','substrb(emp.full_name, 1,50)', 'employee_name','farx_dp.var.emp_name','VARCHAR2',50);
490: fa_rx_util_pkg.assign_column('38','substrb(emp.employee_number, 1, 15)', 'employee_number','farx_dp.var.emp_number','VARCHAR2',15);
491: fa_rx_util_pkg.assign_column('39','dh.units_assigned', 'units','farx_dp.var.units','NUMBER');

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

484: fa_rx_util_pkg.assign_column('32',null, 'book_type_code','farx_dp.var.book','VARCHAR2', 15);
485: fa_rx_util_pkg.assign_column('33',null, 'category','farx_dp.var.concat_cat_str','VARCHAR2', 500);
486: fa_rx_util_pkg.assign_column('34',null, 'location','farx_dp.var.concat_loc_str','VARCHAR2', 500);
487: fa_rx_util_pkg.assign_column('35',null, 'asset_key','farx_dp.var.concat_key_str','VARCHAR2', 240);
488: fa_rx_util_pkg.assign_column('36','cat.description', 'category_description', 'farx_dp.var.category_description','VARCHAR2',240);
489: fa_rx_util_pkg.assign_column('37','substrb(emp.full_name, 1,50)', 'employee_name','farx_dp.var.emp_name','VARCHAR2',50);
490: fa_rx_util_pkg.assign_column('38','substrb(emp.employee_number, 1, 15)', 'employee_number','farx_dp.var.emp_number','VARCHAR2',15);
491: fa_rx_util_pkg.assign_column('39','dh.units_assigned', 'units','farx_dp.var.units','NUMBER');
492: fa_rx_util_pkg.assign_column('40',null, 'company_description',

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

485: fa_rx_util_pkg.assign_column('33',null, 'category','farx_dp.var.concat_cat_str','VARCHAR2', 500);
486: fa_rx_util_pkg.assign_column('34',null, 'location','farx_dp.var.concat_loc_str','VARCHAR2', 500);
487: fa_rx_util_pkg.assign_column('35',null, 'asset_key','farx_dp.var.concat_key_str','VARCHAR2', 240);
488: fa_rx_util_pkg.assign_column('36','cat.description', 'category_description', 'farx_dp.var.category_description','VARCHAR2',240);
489: fa_rx_util_pkg.assign_column('37','substrb(emp.full_name, 1,50)', 'employee_name','farx_dp.var.emp_name','VARCHAR2',50);
490: fa_rx_util_pkg.assign_column('38','substrb(emp.employee_number, 1, 15)', 'employee_number','farx_dp.var.emp_number','VARCHAR2',15);
491: fa_rx_util_pkg.assign_column('39','dh.units_assigned', 'units','farx_dp.var.units','NUMBER');
492: fa_rx_util_pkg.assign_column('40',null, 'company_description',
493: 'farx_dp.var.company_description','VARCHAR2',240);

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

486: fa_rx_util_pkg.assign_column('34',null, 'location','farx_dp.var.concat_loc_str','VARCHAR2', 500);
487: fa_rx_util_pkg.assign_column('35',null, 'asset_key','farx_dp.var.concat_key_str','VARCHAR2', 240);
488: fa_rx_util_pkg.assign_column('36','cat.description', 'category_description', 'farx_dp.var.category_description','VARCHAR2',240);
489: fa_rx_util_pkg.assign_column('37','substrb(emp.full_name, 1,50)', 'employee_name','farx_dp.var.emp_name','VARCHAR2',50);
490: fa_rx_util_pkg.assign_column('38','substrb(emp.employee_number, 1, 15)', 'employee_number','farx_dp.var.emp_number','VARCHAR2',15);
491: fa_rx_util_pkg.assign_column('39','dh.units_assigned', 'units','farx_dp.var.units','NUMBER');
492: fa_rx_util_pkg.assign_column('40',null, 'company_description',
493: 'farx_dp.var.company_description','VARCHAR2',240);
494: fa_rx_util_pkg.assign_column('41',null, 'expense_acct_description',

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

487: fa_rx_util_pkg.assign_column('35',null, 'asset_key','farx_dp.var.concat_key_str','VARCHAR2', 240);
488: fa_rx_util_pkg.assign_column('36','cat.description', 'category_description', 'farx_dp.var.category_description','VARCHAR2',240);
489: fa_rx_util_pkg.assign_column('37','substrb(emp.full_name, 1,50)', 'employee_name','farx_dp.var.emp_name','VARCHAR2',50);
490: fa_rx_util_pkg.assign_column('38','substrb(emp.employee_number, 1, 15)', 'employee_number','farx_dp.var.emp_number','VARCHAR2',15);
491: fa_rx_util_pkg.assign_column('39','dh.units_assigned', 'units','farx_dp.var.units','NUMBER');
492: fa_rx_util_pkg.assign_column('40',null, 'company_description',
493: 'farx_dp.var.company_description','VARCHAR2',240);
494: fa_rx_util_pkg.assign_column('41',null, 'expense_acct_description',
495: 'farx_dp.var.expense_acct_description','VARCHAR2',240);

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

488: fa_rx_util_pkg.assign_column('36','cat.description', 'category_description', 'farx_dp.var.category_description','VARCHAR2',240);
489: fa_rx_util_pkg.assign_column('37','substrb(emp.full_name, 1,50)', 'employee_name','farx_dp.var.emp_name','VARCHAR2',50);
490: fa_rx_util_pkg.assign_column('38','substrb(emp.employee_number, 1, 15)', 'employee_number','farx_dp.var.emp_number','VARCHAR2',15);
491: fa_rx_util_pkg.assign_column('39','dh.units_assigned', 'units','farx_dp.var.units','NUMBER');
492: fa_rx_util_pkg.assign_column('40',null, 'company_description',
493: 'farx_dp.var.company_description','VARCHAR2',240);
494: fa_rx_util_pkg.assign_column('41',null, 'expense_acct_description',
495: 'farx_dp.var.expense_acct_description','VARCHAR2',240);
496: fa_rx_util_pkg.assign_column('42',null, 'cost_center_description',

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

490: fa_rx_util_pkg.assign_column('38','substrb(emp.employee_number, 1, 15)', 'employee_number','farx_dp.var.emp_number','VARCHAR2',15);
491: fa_rx_util_pkg.assign_column('39','dh.units_assigned', 'units','farx_dp.var.units','NUMBER');
492: fa_rx_util_pkg.assign_column('40',null, 'company_description',
493: 'farx_dp.var.company_description','VARCHAR2',240);
494: fa_rx_util_pkg.assign_column('41',null, 'expense_acct_description',
495: 'farx_dp.var.expense_acct_description','VARCHAR2',240);
496: fa_rx_util_pkg.assign_column('42',null, 'cost_center_description',
497: 'farx_dp.var.cost_center_description','VARCHAR2',240);
498: fa_rx_util_pkg.assign_column('43',null, 'organization_name','farx_dp.var.organization_name','VARCHAR2',80);

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

492: fa_rx_util_pkg.assign_column('40',null, 'company_description',
493: 'farx_dp.var.company_description','VARCHAR2',240);
494: fa_rx_util_pkg.assign_column('41',null, 'expense_acct_description',
495: 'farx_dp.var.expense_acct_description','VARCHAR2',240);
496: fa_rx_util_pkg.assign_column('42',null, 'cost_center_description',
497: 'farx_dp.var.cost_center_description','VARCHAR2',240);
498: fa_rx_util_pkg.assign_column('43',null, 'organization_name','farx_dp.var.organization_name','VARCHAR2',80);
499: fa_rx_util_pkg.assign_column('44',null, 'functional_currency_code','farx_dp.var.currency_code','VARCHAR2',15);
500: fa_rx_util_pkg.assign_column('45',null, 'nbv_beginning_fy','farx_dp.var.nbv_beginning_fy','NUMBER');

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

494: fa_rx_util_pkg.assign_column('41',null, 'expense_acct_description',
495: 'farx_dp.var.expense_acct_description','VARCHAR2',240);
496: fa_rx_util_pkg.assign_column('42',null, 'cost_center_description',
497: 'farx_dp.var.cost_center_description','VARCHAR2',240);
498: fa_rx_util_pkg.assign_column('43',null, 'organization_name','farx_dp.var.organization_name','VARCHAR2',80);
499: fa_rx_util_pkg.assign_column('44',null, 'functional_currency_code','farx_dp.var.currency_code','VARCHAR2',15);
500: fa_rx_util_pkg.assign_column('45',null, 'nbv_beginning_fy','farx_dp.var.nbv_beginning_fy','NUMBER');
501: fa_rx_util_pkg.assign_column('46',null, 'set_of_books_id','farx_dp.var.set_of_books_id','NUMBER');
502: fa_rx_util_pkg.assign_column('47',maj_select_statement, 'major_category','farx_dp.var.major_category','VARCHAR2',240);

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

495: 'farx_dp.var.expense_acct_description','VARCHAR2',240);
496: fa_rx_util_pkg.assign_column('42',null, 'cost_center_description',
497: 'farx_dp.var.cost_center_description','VARCHAR2',240);
498: fa_rx_util_pkg.assign_column('43',null, 'organization_name','farx_dp.var.organization_name','VARCHAR2',80);
499: fa_rx_util_pkg.assign_column('44',null, 'functional_currency_code','farx_dp.var.currency_code','VARCHAR2',15);
500: fa_rx_util_pkg.assign_column('45',null, 'nbv_beginning_fy','farx_dp.var.nbv_beginning_fy','NUMBER');
501: fa_rx_util_pkg.assign_column('46',null, 'set_of_books_id','farx_dp.var.set_of_books_id','NUMBER');
502: fa_rx_util_pkg.assign_column('47',maj_select_statement, 'major_category','farx_dp.var.major_category','VARCHAR2',240);
503: fa_rx_util_pkg.assign_column('48',min_select_statement, 'minor_category','farx_dp.var.minor_category','VARCHAR2',240);

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

496: fa_rx_util_pkg.assign_column('42',null, 'cost_center_description',
497: 'farx_dp.var.cost_center_description','VARCHAR2',240);
498: fa_rx_util_pkg.assign_column('43',null, 'organization_name','farx_dp.var.organization_name','VARCHAR2',80);
499: fa_rx_util_pkg.assign_column('44',null, 'functional_currency_code','farx_dp.var.currency_code','VARCHAR2',15);
500: fa_rx_util_pkg.assign_column('45',null, 'nbv_beginning_fy','farx_dp.var.nbv_beginning_fy','NUMBER');
501: fa_rx_util_pkg.assign_column('46',null, 'set_of_books_id','farx_dp.var.set_of_books_id','NUMBER');
502: fa_rx_util_pkg.assign_column('47',maj_select_statement, 'major_category','farx_dp.var.major_category','VARCHAR2',240);
503: fa_rx_util_pkg.assign_column('48',min_select_statement, 'minor_category','farx_dp.var.minor_category','VARCHAR2',240);
504: fa_rx_util_pkg.assign_column('49',null, 'major_category_description','farx_dp.var.major_category_desc','VARCHAR2',240);

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

497: 'farx_dp.var.cost_center_description','VARCHAR2',240);
498: fa_rx_util_pkg.assign_column('43',null, 'organization_name','farx_dp.var.organization_name','VARCHAR2',80);
499: fa_rx_util_pkg.assign_column('44',null, 'functional_currency_code','farx_dp.var.currency_code','VARCHAR2',15);
500: fa_rx_util_pkg.assign_column('45',null, 'nbv_beginning_fy','farx_dp.var.nbv_beginning_fy','NUMBER');
501: fa_rx_util_pkg.assign_column('46',null, 'set_of_books_id','farx_dp.var.set_of_books_id','NUMBER');
502: fa_rx_util_pkg.assign_column('47',maj_select_statement, 'major_category','farx_dp.var.major_category','VARCHAR2',240);
503: fa_rx_util_pkg.assign_column('48',min_select_statement, 'minor_category','farx_dp.var.minor_category','VARCHAR2',240);
504: fa_rx_util_pkg.assign_column('49',null, 'major_category_description','farx_dp.var.major_category_desc','VARCHAR2',240);
505: fa_rx_util_pkg.assign_column('50',null, 'minor_category_description','farx_dp.var.minor_category_desc','VARCHAR2',240);

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

498: fa_rx_util_pkg.assign_column('43',null, 'organization_name','farx_dp.var.organization_name','VARCHAR2',80);
499: fa_rx_util_pkg.assign_column('44',null, 'functional_currency_code','farx_dp.var.currency_code','VARCHAR2',15);
500: fa_rx_util_pkg.assign_column('45',null, 'nbv_beginning_fy','farx_dp.var.nbv_beginning_fy','NUMBER');
501: fa_rx_util_pkg.assign_column('46',null, 'set_of_books_id','farx_dp.var.set_of_books_id','NUMBER');
502: fa_rx_util_pkg.assign_column('47',maj_select_statement, 'major_category','farx_dp.var.major_category','VARCHAR2',240);
503: fa_rx_util_pkg.assign_column('48',min_select_statement, 'minor_category','farx_dp.var.minor_category','VARCHAR2',240);
504: fa_rx_util_pkg.assign_column('49',null, 'major_category_description','farx_dp.var.major_category_desc','VARCHAR2',240);
505: fa_rx_util_pkg.assign_column('50',null, 'minor_category_description','farx_dp.var.minor_category_desc','VARCHAR2',240);
506: fa_rx_util_pkg.assign_column('51',spec_select_statement, 'specified_category_segment','farx_dp.var.specified_cat_seg','VARCHAR2',240);

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

499: fa_rx_util_pkg.assign_column('44',null, 'functional_currency_code','farx_dp.var.currency_code','VARCHAR2',15);
500: fa_rx_util_pkg.assign_column('45',null, 'nbv_beginning_fy','farx_dp.var.nbv_beginning_fy','NUMBER');
501: fa_rx_util_pkg.assign_column('46',null, 'set_of_books_id','farx_dp.var.set_of_books_id','NUMBER');
502: fa_rx_util_pkg.assign_column('47',maj_select_statement, 'major_category','farx_dp.var.major_category','VARCHAR2',240);
503: fa_rx_util_pkg.assign_column('48',min_select_statement, 'minor_category','farx_dp.var.minor_category','VARCHAR2',240);
504: fa_rx_util_pkg.assign_column('49',null, 'major_category_description','farx_dp.var.major_category_desc','VARCHAR2',240);
505: fa_rx_util_pkg.assign_column('50',null, 'minor_category_description','farx_dp.var.minor_category_desc','VARCHAR2',240);
506: fa_rx_util_pkg.assign_column('51',spec_select_statement, 'specified_category_segment','farx_dp.var.specified_cat_seg','VARCHAR2',240);
507: fa_rx_util_pkg.assign_column('52',null, 'specified_category_seg_desc','farx_dp.var.specified_cat_seg_desc','VARCHAR2',240);

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

500: fa_rx_util_pkg.assign_column('45',null, 'nbv_beginning_fy','farx_dp.var.nbv_beginning_fy','NUMBER');
501: fa_rx_util_pkg.assign_column('46',null, 'set_of_books_id','farx_dp.var.set_of_books_id','NUMBER');
502: fa_rx_util_pkg.assign_column('47',maj_select_statement, 'major_category','farx_dp.var.major_category','VARCHAR2',240);
503: fa_rx_util_pkg.assign_column('48',min_select_statement, 'minor_category','farx_dp.var.minor_category','VARCHAR2',240);
504: fa_rx_util_pkg.assign_column('49',null, 'major_category_description','farx_dp.var.major_category_desc','VARCHAR2',240);
505: fa_rx_util_pkg.assign_column('50',null, 'minor_category_description','farx_dp.var.minor_category_desc','VARCHAR2',240);
506: fa_rx_util_pkg.assign_column('51',spec_select_statement, 'specified_category_segment','farx_dp.var.specified_cat_seg','VARCHAR2',240);
507: fa_rx_util_pkg.assign_column('52',null, 'specified_category_seg_desc','farx_dp.var.specified_cat_seg_desc','VARCHAR2',240);
508: fa_rx_util_pkg.assign_column('53',null, 'reserve_acct_desc','farx_dp.var.reserve_acct_desc','VARCHAR2',240);

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

501: fa_rx_util_pkg.assign_column('46',null, 'set_of_books_id','farx_dp.var.set_of_books_id','NUMBER');
502: fa_rx_util_pkg.assign_column('47',maj_select_statement, 'major_category','farx_dp.var.major_category','VARCHAR2',240);
503: fa_rx_util_pkg.assign_column('48',min_select_statement, 'minor_category','farx_dp.var.minor_category','VARCHAR2',240);
504: fa_rx_util_pkg.assign_column('49',null, 'major_category_description','farx_dp.var.major_category_desc','VARCHAR2',240);
505: fa_rx_util_pkg.assign_column('50',null, 'minor_category_description','farx_dp.var.minor_category_desc','VARCHAR2',240);
506: fa_rx_util_pkg.assign_column('51',spec_select_statement, 'specified_category_segment','farx_dp.var.specified_cat_seg','VARCHAR2',240);
507: fa_rx_util_pkg.assign_column('52',null, 'specified_category_seg_desc','farx_dp.var.specified_cat_seg_desc','VARCHAR2',240);
508: fa_rx_util_pkg.assign_column('53',null, 'reserve_acct_desc','farx_dp.var.reserve_acct_desc','VARCHAR2',240);
509: 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 506: fa_rx_util_pkg.assign_column('51',spec_select_statement, 'specified_category_segment','farx_dp.var.specified_cat_seg','VARCHAR2',240);

502: fa_rx_util_pkg.assign_column('47',maj_select_statement, 'major_category','farx_dp.var.major_category','VARCHAR2',240);
503: fa_rx_util_pkg.assign_column('48',min_select_statement, 'minor_category','farx_dp.var.minor_category','VARCHAR2',240);
504: fa_rx_util_pkg.assign_column('49',null, 'major_category_description','farx_dp.var.major_category_desc','VARCHAR2',240);
505: fa_rx_util_pkg.assign_column('50',null, 'minor_category_description','farx_dp.var.minor_category_desc','VARCHAR2',240);
506: fa_rx_util_pkg.assign_column('51',spec_select_statement, 'specified_category_segment','farx_dp.var.specified_cat_seg','VARCHAR2',240);
507: fa_rx_util_pkg.assign_column('52',null, 'specified_category_seg_desc','farx_dp.var.specified_cat_seg_desc','VARCHAR2',240);
508: fa_rx_util_pkg.assign_column('53',null, 'reserve_acct_desc','farx_dp.var.reserve_acct_desc','VARCHAR2',240);
509: 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);
510: fa_rx_util_pkg.assign_column('55','books.salvage_value', 'salvage_value','farx_dp.var.salvage_value','NUMBER');

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

503: fa_rx_util_pkg.assign_column('48',min_select_statement, 'minor_category','farx_dp.var.minor_category','VARCHAR2',240);
504: fa_rx_util_pkg.assign_column('49',null, 'major_category_description','farx_dp.var.major_category_desc','VARCHAR2',240);
505: fa_rx_util_pkg.assign_column('50',null, 'minor_category_description','farx_dp.var.minor_category_desc','VARCHAR2',240);
506: fa_rx_util_pkg.assign_column('51',spec_select_statement, 'specified_category_segment','farx_dp.var.specified_cat_seg','VARCHAR2',240);
507: fa_rx_util_pkg.assign_column('52',null, 'specified_category_seg_desc','farx_dp.var.specified_cat_seg_desc','VARCHAR2',240);
508: fa_rx_util_pkg.assign_column('53',null, 'reserve_acct_desc','farx_dp.var.reserve_acct_desc','VARCHAR2',240);
509: 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);
510: fa_rx_util_pkg.assign_column('55','books.salvage_value', 'salvage_value','farx_dp.var.salvage_value','NUMBER');
511: -->>SELECT_END<<--

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

504: fa_rx_util_pkg.assign_column('49',null, 'major_category_description','farx_dp.var.major_category_desc','VARCHAR2',240);
505: fa_rx_util_pkg.assign_column('50',null, 'minor_category_description','farx_dp.var.minor_category_desc','VARCHAR2',240);
506: fa_rx_util_pkg.assign_column('51',spec_select_statement, 'specified_category_segment','farx_dp.var.specified_cat_seg','VARCHAR2',240);
507: fa_rx_util_pkg.assign_column('52',null, 'specified_category_seg_desc','farx_dp.var.specified_cat_seg_desc','VARCHAR2',240);
508: fa_rx_util_pkg.assign_column('53',null, 'reserve_acct_desc','farx_dp.var.reserve_acct_desc','VARCHAR2',240);
509: 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);
510: fa_rx_util_pkg.assign_column('55','books.salvage_value', 'salvage_value','farx_dp.var.salvage_value','NUMBER');
511: -->>SELECT_END<<--
512:

Line 509: 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);

505: fa_rx_util_pkg.assign_column('50',null, 'minor_category_description','farx_dp.var.minor_category_desc','VARCHAR2',240);
506: fa_rx_util_pkg.assign_column('51',spec_select_statement, 'specified_category_segment','farx_dp.var.specified_cat_seg','VARCHAR2',240);
507: fa_rx_util_pkg.assign_column('52',null, 'specified_category_seg_desc','farx_dp.var.specified_cat_seg_desc','VARCHAR2',240);
508: fa_rx_util_pkg.assign_column('53',null, 'reserve_acct_desc','farx_dp.var.reserve_acct_desc','VARCHAR2',240);
509: 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);
510: fa_rx_util_pkg.assign_column('55','books.salvage_value', 'salvage_value','farx_dp.var.salvage_value','NUMBER');
511: -->>SELECT_END<<--
512:
513:

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

506: fa_rx_util_pkg.assign_column('51',spec_select_statement, 'specified_category_segment','farx_dp.var.specified_cat_seg','VARCHAR2',240);
507: fa_rx_util_pkg.assign_column('52',null, 'specified_category_seg_desc','farx_dp.var.specified_cat_seg_desc','VARCHAR2',240);
508: fa_rx_util_pkg.assign_column('53',null, 'reserve_acct_desc','farx_dp.var.reserve_acct_desc','VARCHAR2',240);
509: 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);
510: fa_rx_util_pkg.assign_column('55','books.salvage_value', 'salvage_value','farx_dp.var.salvage_value','NUMBER');
511: -->>SELECT_END<<--
512:
513:
514: --

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

513:
514: --
515: -- Assign From Clause
516: --
517: fa_rx_util_pkg.From_Clause := 'fa_reserve_ledger_gt rsv,
518: fa_distribution_history dh,
519: fa_additions ad,
520: fa_additions ad1,
521: fa_asset_history ah,

Line 536: fa_rx_util_pkg.Where_Clause := '

532:
533: --
534: -- Assign Where Clause
535: --
536: fa_rx_util_pkg.Where_Clause := '
537: rsv.asset_id = ad.asset_id
538: and rsv.asset_id = dh.asset_id
539: and rsv.dh_ccid = dh.code_combination_id
540: and rsv.distribution_id = dh.distribution_id

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

589: )
590: and dd.period_counter = rsv.period_counter ' || l_param_where ;
591:
592: mesg_name := 'FA_DEPRN_SQL_DCUR';
593: fa_rx_util_pkg.debug('farx_dp.before_report()-');
594: end before_report;
595:
596:
597: /*

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

605: -- These bind variables were included in the WHERE clause.
606: --
607:
608: IF (g_print_debug) THEN
609: fa_rx_util_pkg.debug('farx_dp.bind()+');
610: END IF;
611: dbms_sql.bind_variable(c, 'b_book', var.book);
612: dbms_sql.bind_variable(c, 'b_fy_name', var.fy_name);
613: dbms_sql.bind_variable(c, 'b_report_style', var.report_style);

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

649: dbms_sql.bind_variable(c, 'from_cat_seg_val', param.from_cat_seg_val);
650: dbms_sql.bind_variable(c, 'to_cat_seg_val', param.to_cat_seg_val);
651: END IF;
652: IF (g_print_debug) THEN
653: fa_rx_util_pkg.debug('farx_dp.bind()-');
654: END IF;
655: end bind;
656:
657:

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

661: */
662: procedure after_fetch
663: is
664: begin
665: fa_rx_util_pkg.debug('farx_dp.after_fetch()+');
666: var.account_description := fa_rx_shared_pkg.get_flex_val_meaning(
667: NULL, var.acct_valueset_name, var.asset_cost_acct);
668:
669: mesg_name := 'FA_RX_CONCAT_SEGS';

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

795: fnd_number.canonical_to_number(
796: to_char(floor(var.life/12))||'.'||to_char(mod(var.life,12), 'FM00'));
797: END IF;
798: mesg_name := 'FA_SHARED_INSERT_FAILED';
799: fa_rx_util_pkg.debug('farx_dp.after_fetch()-');
800: end after_fetch;
801: END FARX_DP;