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.IGI_IAC_RECLASS_PKG dependencies on IGI_IAC_DET_BALANCES

Line 380: | Procedure to insert data into IGI_IAC_DET_BALANCES |

376:
377:
378: /*
379: +===============================================================================+
380: | Procedure to insert data into IGI_IAC_DET_BALANCES |
381: ================================================================================+
382: */
383:
384: PROCEDURE insert_data_det(p_adjustment_id in IGI_IAC_DET_BALANCES.adjustment_id%type,

Line 384: PROCEDURE insert_data_det(p_adjustment_id in IGI_IAC_DET_BALANCES.adjustment_id%type,

380: | Procedure to insert data into IGI_IAC_DET_BALANCES |
381: ================================================================================+
382: */
383:
384: PROCEDURE insert_data_det(p_adjustment_id in IGI_IAC_DET_BALANCES.adjustment_id%type,
385: p_asset_id in IGI_IAC_DET_BALANCES.asset_id%type,
386: p_distribution_id in IGI_IAC_DET_BALANCES.distribution_id%type,
387: p_period_counter in IGI_IAC_DET_BALANCES.period_counter%type,
388: p_book_type_code in IGI_IAC_DET_BALANCES.book_type_code%type,

Line 385: p_asset_id in IGI_IAC_DET_BALANCES.asset_id%type,

381: ================================================================================+
382: */
383:
384: PROCEDURE insert_data_det(p_adjustment_id in IGI_IAC_DET_BALANCES.adjustment_id%type,
385: p_asset_id in IGI_IAC_DET_BALANCES.asset_id%type,
386: p_distribution_id in IGI_IAC_DET_BALANCES.distribution_id%type,
387: p_period_counter in IGI_IAC_DET_BALANCES.period_counter%type,
388: p_book_type_code in IGI_IAC_DET_BALANCES.book_type_code%type,
389: p_adjusted_cost in IGI_IAC_DET_BALANCES.adjustment_cost%type,

Line 386: p_distribution_id in IGI_IAC_DET_BALANCES.distribution_id%type,

382: */
383:
384: PROCEDURE insert_data_det(p_adjustment_id in IGI_IAC_DET_BALANCES.adjustment_id%type,
385: p_asset_id in IGI_IAC_DET_BALANCES.asset_id%type,
386: p_distribution_id in IGI_IAC_DET_BALANCES.distribution_id%type,
387: p_period_counter in IGI_IAC_DET_BALANCES.period_counter%type,
388: p_book_type_code in IGI_IAC_DET_BALANCES.book_type_code%type,
389: p_adjusted_cost in IGI_IAC_DET_BALANCES.adjustment_cost%type,
390: p_net_book_value in IGI_IAC_DET_BALANCES.net_book_value%type,

Line 387: p_period_counter in IGI_IAC_DET_BALANCES.period_counter%type,

383:
384: PROCEDURE insert_data_det(p_adjustment_id in IGI_IAC_DET_BALANCES.adjustment_id%type,
385: p_asset_id in IGI_IAC_DET_BALANCES.asset_id%type,
386: p_distribution_id in IGI_IAC_DET_BALANCES.distribution_id%type,
387: p_period_counter in IGI_IAC_DET_BALANCES.period_counter%type,
388: p_book_type_code in IGI_IAC_DET_BALANCES.book_type_code%type,
389: p_adjusted_cost in IGI_IAC_DET_BALANCES.adjustment_cost%type,
390: p_net_book_value in IGI_IAC_DET_BALANCES.net_book_value%type,
391: p_reval_reserve in IGI_IAC_DET_BALANCES.reval_reserve_cost%type,

Line 388: p_book_type_code in IGI_IAC_DET_BALANCES.book_type_code%type,

384: PROCEDURE insert_data_det(p_adjustment_id in IGI_IAC_DET_BALANCES.adjustment_id%type,
385: p_asset_id in IGI_IAC_DET_BALANCES.asset_id%type,
386: p_distribution_id in IGI_IAC_DET_BALANCES.distribution_id%type,
387: p_period_counter in IGI_IAC_DET_BALANCES.period_counter%type,
388: p_book_type_code in IGI_IAC_DET_BALANCES.book_type_code%type,
389: p_adjusted_cost in IGI_IAC_DET_BALANCES.adjustment_cost%type,
390: p_net_book_value in IGI_IAC_DET_BALANCES.net_book_value%type,
391: p_reval_reserve in IGI_IAC_DET_BALANCES.reval_reserve_cost%type,
392: p_reval_reserve_gen_fund in IGI_IAC_DET_BALANCES.reval_reserve_gen_fund%type,

Line 389: p_adjusted_cost in IGI_IAC_DET_BALANCES.adjustment_cost%type,

385: p_asset_id in IGI_IAC_DET_BALANCES.asset_id%type,
386: p_distribution_id in IGI_IAC_DET_BALANCES.distribution_id%type,
387: p_period_counter in IGI_IAC_DET_BALANCES.period_counter%type,
388: p_book_type_code in IGI_IAC_DET_BALANCES.book_type_code%type,
389: p_adjusted_cost in IGI_IAC_DET_BALANCES.adjustment_cost%type,
390: p_net_book_value in IGI_IAC_DET_BALANCES.net_book_value%type,
391: p_reval_reserve in IGI_IAC_DET_BALANCES.reval_reserve_cost%type,
392: p_reval_reserve_gen_fund in IGI_IAC_DET_BALANCES.reval_reserve_gen_fund%type,
393: p_reval_reserve_backlog in IGI_IAC_DET_BALANCES.reval_reserve_backlog%type,

Line 390: p_net_book_value in IGI_IAC_DET_BALANCES.net_book_value%type,

386: p_distribution_id in IGI_IAC_DET_BALANCES.distribution_id%type,
387: p_period_counter in IGI_IAC_DET_BALANCES.period_counter%type,
388: p_book_type_code in IGI_IAC_DET_BALANCES.book_type_code%type,
389: p_adjusted_cost in IGI_IAC_DET_BALANCES.adjustment_cost%type,
390: p_net_book_value in IGI_IAC_DET_BALANCES.net_book_value%type,
391: p_reval_reserve in IGI_IAC_DET_BALANCES.reval_reserve_cost%type,
392: p_reval_reserve_gen_fund in IGI_IAC_DET_BALANCES.reval_reserve_gen_fund%type,
393: p_reval_reserve_backlog in IGI_IAC_DET_BALANCES.reval_reserve_backlog%type,
394: p_reval_reserve_net in IGI_IAC_DET_BALANCES.reval_reserve_net%type,

Line 391: p_reval_reserve in IGI_IAC_DET_BALANCES.reval_reserve_cost%type,

387: p_period_counter in IGI_IAC_DET_BALANCES.period_counter%type,
388: p_book_type_code in IGI_IAC_DET_BALANCES.book_type_code%type,
389: p_adjusted_cost in IGI_IAC_DET_BALANCES.adjustment_cost%type,
390: p_net_book_value in IGI_IAC_DET_BALANCES.net_book_value%type,
391: p_reval_reserve in IGI_IAC_DET_BALANCES.reval_reserve_cost%type,
392: p_reval_reserve_gen_fund in IGI_IAC_DET_BALANCES.reval_reserve_gen_fund%type,
393: p_reval_reserve_backlog in IGI_IAC_DET_BALANCES.reval_reserve_backlog%type,
394: p_reval_reserve_net in IGI_IAC_DET_BALANCES.reval_reserve_net%type,
395: p_op_acct in IGI_IAC_DET_BALANCES.operating_acct_cost%type,

Line 392: p_reval_reserve_gen_fund in IGI_IAC_DET_BALANCES.reval_reserve_gen_fund%type,

388: p_book_type_code in IGI_IAC_DET_BALANCES.book_type_code%type,
389: p_adjusted_cost in IGI_IAC_DET_BALANCES.adjustment_cost%type,
390: p_net_book_value in IGI_IAC_DET_BALANCES.net_book_value%type,
391: p_reval_reserve in IGI_IAC_DET_BALANCES.reval_reserve_cost%type,
392: p_reval_reserve_gen_fund in IGI_IAC_DET_BALANCES.reval_reserve_gen_fund%type,
393: p_reval_reserve_backlog in IGI_IAC_DET_BALANCES.reval_reserve_backlog%type,
394: p_reval_reserve_net in IGI_IAC_DET_BALANCES.reval_reserve_net%type,
395: p_op_acct in IGI_IAC_DET_BALANCES.operating_acct_cost%type,
396: p_op_acct_net in IGI_IAC_DET_BALANCES.operating_acct_net%type,

Line 393: p_reval_reserve_backlog in IGI_IAC_DET_BALANCES.reval_reserve_backlog%type,

389: p_adjusted_cost in IGI_IAC_DET_BALANCES.adjustment_cost%type,
390: p_net_book_value in IGI_IAC_DET_BALANCES.net_book_value%type,
391: p_reval_reserve in IGI_IAC_DET_BALANCES.reval_reserve_cost%type,
392: p_reval_reserve_gen_fund in IGI_IAC_DET_BALANCES.reval_reserve_gen_fund%type,
393: p_reval_reserve_backlog in IGI_IAC_DET_BALANCES.reval_reserve_backlog%type,
394: p_reval_reserve_net in IGI_IAC_DET_BALANCES.reval_reserve_net%type,
395: p_op_acct in IGI_IAC_DET_BALANCES.operating_acct_cost%type,
396: p_op_acct_net in IGI_IAC_DET_BALANCES.operating_acct_net%type,
397: p_deprn_reserve in IGI_IAC_DET_BALANCES.deprn_reserve%type,

Line 394: p_reval_reserve_net in IGI_IAC_DET_BALANCES.reval_reserve_net%type,

390: p_net_book_value in IGI_IAC_DET_BALANCES.net_book_value%type,
391: p_reval_reserve in IGI_IAC_DET_BALANCES.reval_reserve_cost%type,
392: p_reval_reserve_gen_fund in IGI_IAC_DET_BALANCES.reval_reserve_gen_fund%type,
393: p_reval_reserve_backlog in IGI_IAC_DET_BALANCES.reval_reserve_backlog%type,
394: p_reval_reserve_net in IGI_IAC_DET_BALANCES.reval_reserve_net%type,
395: p_op_acct in IGI_IAC_DET_BALANCES.operating_acct_cost%type,
396: p_op_acct_net in IGI_IAC_DET_BALANCES.operating_acct_net%type,
397: p_deprn_reserve in IGI_IAC_DET_BALANCES.deprn_reserve%type,
398: p_deprn_reserve_backlog in IGI_IAC_DET_BALANCES.deprn_reserve_backlog%type,

Line 395: p_op_acct in IGI_IAC_DET_BALANCES.operating_acct_cost%type,

391: p_reval_reserve in IGI_IAC_DET_BALANCES.reval_reserve_cost%type,
392: p_reval_reserve_gen_fund in IGI_IAC_DET_BALANCES.reval_reserve_gen_fund%type,
393: p_reval_reserve_backlog in IGI_IAC_DET_BALANCES.reval_reserve_backlog%type,
394: p_reval_reserve_net in IGI_IAC_DET_BALANCES.reval_reserve_net%type,
395: p_op_acct in IGI_IAC_DET_BALANCES.operating_acct_cost%type,
396: p_op_acct_net in IGI_IAC_DET_BALANCES.operating_acct_net%type,
397: p_deprn_reserve in IGI_IAC_DET_BALANCES.deprn_reserve%type,
398: p_deprn_reserve_backlog in IGI_IAC_DET_BALANCES.deprn_reserve_backlog%type,
399: p_deprn_ytd in IGI_IAC_DET_BALANCES.deprn_ytd%type,

Line 396: p_op_acct_net in IGI_IAC_DET_BALANCES.operating_acct_net%type,

392: p_reval_reserve_gen_fund in IGI_IAC_DET_BALANCES.reval_reserve_gen_fund%type,
393: p_reval_reserve_backlog in IGI_IAC_DET_BALANCES.reval_reserve_backlog%type,
394: p_reval_reserve_net in IGI_IAC_DET_BALANCES.reval_reserve_net%type,
395: p_op_acct in IGI_IAC_DET_BALANCES.operating_acct_cost%type,
396: p_op_acct_net in IGI_IAC_DET_BALANCES.operating_acct_net%type,
397: p_deprn_reserve in IGI_IAC_DET_BALANCES.deprn_reserve%type,
398: p_deprn_reserve_backlog in IGI_IAC_DET_BALANCES.deprn_reserve_backlog%type,
399: p_deprn_ytd in IGI_IAC_DET_BALANCES.deprn_ytd%type,
400: p_deprn_period in IGI_IAC_DET_BALANCES.deprn_period%type,

Line 397: p_deprn_reserve in IGI_IAC_DET_BALANCES.deprn_reserve%type,

393: p_reval_reserve_backlog in IGI_IAC_DET_BALANCES.reval_reserve_backlog%type,
394: p_reval_reserve_net in IGI_IAC_DET_BALANCES.reval_reserve_net%type,
395: p_op_acct in IGI_IAC_DET_BALANCES.operating_acct_cost%type,
396: p_op_acct_net in IGI_IAC_DET_BALANCES.operating_acct_net%type,
397: p_deprn_reserve in IGI_IAC_DET_BALANCES.deprn_reserve%type,
398: p_deprn_reserve_backlog in IGI_IAC_DET_BALANCES.deprn_reserve_backlog%type,
399: p_deprn_ytd in IGI_IAC_DET_BALANCES.deprn_ytd%type,
400: p_deprn_period in IGI_IAC_DET_BALANCES.deprn_period%type,
401: p_gen_fund_acc in IGI_IAC_DET_BALANCES.general_fund_acc%type,

Line 398: p_deprn_reserve_backlog in IGI_IAC_DET_BALANCES.deprn_reserve_backlog%type,

394: p_reval_reserve_net in IGI_IAC_DET_BALANCES.reval_reserve_net%type,
395: p_op_acct in IGI_IAC_DET_BALANCES.operating_acct_cost%type,
396: p_op_acct_net in IGI_IAC_DET_BALANCES.operating_acct_net%type,
397: p_deprn_reserve in IGI_IAC_DET_BALANCES.deprn_reserve%type,
398: p_deprn_reserve_backlog in IGI_IAC_DET_BALANCES.deprn_reserve_backlog%type,
399: p_deprn_ytd in IGI_IAC_DET_BALANCES.deprn_ytd%type,
400: p_deprn_period in IGI_IAC_DET_BALANCES.deprn_period%type,
401: p_gen_fund_acc in IGI_IAC_DET_BALANCES.general_fund_acc%type,
402: p_gen_fund_per in IGI_IAC_DET_BALANCES.general_fund_acc%type,

Line 399: p_deprn_ytd in IGI_IAC_DET_BALANCES.deprn_ytd%type,

395: p_op_acct in IGI_IAC_DET_BALANCES.operating_acct_cost%type,
396: p_op_acct_net in IGI_IAC_DET_BALANCES.operating_acct_net%type,
397: p_deprn_reserve in IGI_IAC_DET_BALANCES.deprn_reserve%type,
398: p_deprn_reserve_backlog in IGI_IAC_DET_BALANCES.deprn_reserve_backlog%type,
399: p_deprn_ytd in IGI_IAC_DET_BALANCES.deprn_ytd%type,
400: p_deprn_period in IGI_IAC_DET_BALANCES.deprn_period%type,
401: p_gen_fund_acc in IGI_IAC_DET_BALANCES.general_fund_acc%type,
402: p_gen_fund_per in IGI_IAC_DET_BALANCES.general_fund_acc%type,
403: p_current_reval_factor in IGI_IAC_DET_BALANCES.current_reval_factor%type,

Line 400: p_deprn_period in IGI_IAC_DET_BALANCES.deprn_period%type,

396: p_op_acct_net in IGI_IAC_DET_BALANCES.operating_acct_net%type,
397: p_deprn_reserve in IGI_IAC_DET_BALANCES.deprn_reserve%type,
398: p_deprn_reserve_backlog in IGI_IAC_DET_BALANCES.deprn_reserve_backlog%type,
399: p_deprn_ytd in IGI_IAC_DET_BALANCES.deprn_ytd%type,
400: p_deprn_period in IGI_IAC_DET_BALANCES.deprn_period%type,
401: p_gen_fund_acc in IGI_IAC_DET_BALANCES.general_fund_acc%type,
402: p_gen_fund_per in IGI_IAC_DET_BALANCES.general_fund_acc%type,
403: p_current_reval_factor in IGI_IAC_DET_BALANCES.current_reval_factor%type,
404: p_cumulative_reval_factor in IGI_IAC_DET_BALANCES.cumulative_reval_factor%type,

Line 401: p_gen_fund_acc in IGI_IAC_DET_BALANCES.general_fund_acc%type,

397: p_deprn_reserve in IGI_IAC_DET_BALANCES.deprn_reserve%type,
398: p_deprn_reserve_backlog in IGI_IAC_DET_BALANCES.deprn_reserve_backlog%type,
399: p_deprn_ytd in IGI_IAC_DET_BALANCES.deprn_ytd%type,
400: p_deprn_period in IGI_IAC_DET_BALANCES.deprn_period%type,
401: p_gen_fund_acc in IGI_IAC_DET_BALANCES.general_fund_acc%type,
402: p_gen_fund_per in IGI_IAC_DET_BALANCES.general_fund_acc%type,
403: p_current_reval_factor in IGI_IAC_DET_BALANCES.current_reval_factor%type,
404: p_cumulative_reval_factor in IGI_IAC_DET_BALANCES.cumulative_reval_factor%type,
405: p_reval_flag in IGI_IAC_DET_BALANCES.active_flag%type,

Line 402: p_gen_fund_per in IGI_IAC_DET_BALANCES.general_fund_acc%type,

398: p_deprn_reserve_backlog in IGI_IAC_DET_BALANCES.deprn_reserve_backlog%type,
399: p_deprn_ytd in IGI_IAC_DET_BALANCES.deprn_ytd%type,
400: p_deprn_period in IGI_IAC_DET_BALANCES.deprn_period%type,
401: p_gen_fund_acc in IGI_IAC_DET_BALANCES.general_fund_acc%type,
402: p_gen_fund_per in IGI_IAC_DET_BALANCES.general_fund_acc%type,
403: p_current_reval_factor in IGI_IAC_DET_BALANCES.current_reval_factor%type,
404: p_cumulative_reval_factor in IGI_IAC_DET_BALANCES.cumulative_reval_factor%type,
405: p_reval_flag in IGI_IAC_DET_BALANCES.active_flag%type,
406: p_op_acct_ytd in IGI_IAC_DET_BALANCES.operating_acct_ytd%type,

Line 403: p_current_reval_factor in IGI_IAC_DET_BALANCES.current_reval_factor%type,

399: p_deprn_ytd in IGI_IAC_DET_BALANCES.deprn_ytd%type,
400: p_deprn_period in IGI_IAC_DET_BALANCES.deprn_period%type,
401: p_gen_fund_acc in IGI_IAC_DET_BALANCES.general_fund_acc%type,
402: p_gen_fund_per in IGI_IAC_DET_BALANCES.general_fund_acc%type,
403: p_current_reval_factor in IGI_IAC_DET_BALANCES.current_reval_factor%type,
404: p_cumulative_reval_factor in IGI_IAC_DET_BALANCES.cumulative_reval_factor%type,
405: p_reval_flag in IGI_IAC_DET_BALANCES.active_flag%type,
406: p_op_acct_ytd in IGI_IAC_DET_BALANCES.operating_acct_ytd%type,
407: p_operating_acct_backlog in IGI_IAC_DET_BALANCES.operating_acct_backlog%type,

Line 404: p_cumulative_reval_factor in IGI_IAC_DET_BALANCES.cumulative_reval_factor%type,

400: p_deprn_period in IGI_IAC_DET_BALANCES.deprn_period%type,
401: p_gen_fund_acc in IGI_IAC_DET_BALANCES.general_fund_acc%type,
402: p_gen_fund_per in IGI_IAC_DET_BALANCES.general_fund_acc%type,
403: p_current_reval_factor in IGI_IAC_DET_BALANCES.current_reval_factor%type,
404: p_cumulative_reval_factor in IGI_IAC_DET_BALANCES.cumulative_reval_factor%type,
405: p_reval_flag in IGI_IAC_DET_BALANCES.active_flag%type,
406: p_op_acct_ytd in IGI_IAC_DET_BALANCES.operating_acct_ytd%type,
407: p_operating_acct_backlog in IGI_IAC_DET_BALANCES.operating_acct_backlog%type,
408: p_last_reval_date in IGI_IAC_DET_BALANCES.last_reval_date%type

Line 405: p_reval_flag in IGI_IAC_DET_BALANCES.active_flag%type,

401: p_gen_fund_acc in IGI_IAC_DET_BALANCES.general_fund_acc%type,
402: p_gen_fund_per in IGI_IAC_DET_BALANCES.general_fund_acc%type,
403: p_current_reval_factor in IGI_IAC_DET_BALANCES.current_reval_factor%type,
404: p_cumulative_reval_factor in IGI_IAC_DET_BALANCES.cumulative_reval_factor%type,
405: p_reval_flag in IGI_IAC_DET_BALANCES.active_flag%type,
406: p_op_acct_ytd in IGI_IAC_DET_BALANCES.operating_acct_ytd%type,
407: p_operating_acct_backlog in IGI_IAC_DET_BALANCES.operating_acct_backlog%type,
408: p_last_reval_date in IGI_IAC_DET_BALANCES.last_reval_date%type
409: ) IS

Line 406: p_op_acct_ytd in IGI_IAC_DET_BALANCES.operating_acct_ytd%type,

402: p_gen_fund_per in IGI_IAC_DET_BALANCES.general_fund_acc%type,
403: p_current_reval_factor in IGI_IAC_DET_BALANCES.current_reval_factor%type,
404: p_cumulative_reval_factor in IGI_IAC_DET_BALANCES.cumulative_reval_factor%type,
405: p_reval_flag in IGI_IAC_DET_BALANCES.active_flag%type,
406: p_op_acct_ytd in IGI_IAC_DET_BALANCES.operating_acct_ytd%type,
407: p_operating_acct_backlog in IGI_IAC_DET_BALANCES.operating_acct_backlog%type,
408: p_last_reval_date in IGI_IAC_DET_BALANCES.last_reval_date%type
409: ) IS
410:

Line 407: p_operating_acct_backlog in IGI_IAC_DET_BALANCES.operating_acct_backlog%type,

403: p_current_reval_factor in IGI_IAC_DET_BALANCES.current_reval_factor%type,
404: p_cumulative_reval_factor in IGI_IAC_DET_BALANCES.cumulative_reval_factor%type,
405: p_reval_flag in IGI_IAC_DET_BALANCES.active_flag%type,
406: p_op_acct_ytd in IGI_IAC_DET_BALANCES.operating_acct_ytd%type,
407: p_operating_acct_backlog in IGI_IAC_DET_BALANCES.operating_acct_backlog%type,
408: p_last_reval_date in IGI_IAC_DET_BALANCES.last_reval_date%type
409: ) IS
410:
411: l_rowid VARCHAR2(25);

Line 408: p_last_reval_date in IGI_IAC_DET_BALANCES.last_reval_date%type

404: p_cumulative_reval_factor in IGI_IAC_DET_BALANCES.cumulative_reval_factor%type,
405: p_reval_flag in IGI_IAC_DET_BALANCES.active_flag%type,
406: p_op_acct_ytd in IGI_IAC_DET_BALANCES.operating_acct_ytd%type,
407: p_operating_acct_backlog in IGI_IAC_DET_BALANCES.operating_acct_backlog%type,
408: p_last_reval_date in IGI_IAC_DET_BALANCES.last_reval_date%type
409: ) IS
410:
411: l_rowid VARCHAR2(25);
412: l_mesg VARCHAR2(500);

Line 417: /* Call to TBH for insert into IGI_IAC_DET_BALANCES */

413: l_path_name VARCHAR2(150);
414: BEGIN
415: l_path_name := g_path||'insert_data_det';
416:
417: /* Call to TBH for insert into IGI_IAC_DET_BALANCES */
418: IGI_IAC_DET_BALANCES_PKG.insert_row(
419: x_rowid =>l_rowid,
420: x_adjustment_id =>p_adjustment_id,
421: x_asset_id =>p_asset_id,

Line 418: IGI_IAC_DET_BALANCES_PKG.insert_row(

414: BEGIN
415: l_path_name := g_path||'insert_data_det';
416:
417: /* Call to TBH for insert into IGI_IAC_DET_BALANCES */
418: IGI_IAC_DET_BALANCES_PKG.insert_row(
419: x_rowid =>l_rowid,
420: x_adjustment_id =>p_adjustment_id,
421: x_asset_id =>p_asset_id,
422: x_distribution_id =>p_distribution_id,

Line 542: , fp_det_balances in igi_iac_det_balances%rowtype

538: , p_amount in number
539: , l_adjust_type in varchar2
540: , l_cr_dr_flag in varchar2
541: , l_set_of_books_id in number
542: , fp_det_balances in igi_iac_det_balances%rowtype
543: , l_adjust_offset_type in varchar2 Default Null
544: , l_Report_CCID in varchar2 Default Null
545: , p_event_id in number
546: )

Line 593: ( fp_det_balances in IGI_IAC_DET_BALANCES%ROWTYPE

589:
590: end;
591:
592: function create_iac_acctg
593: ( fp_det_balances in IGI_IAC_DET_BALANCES%ROWTYPE
594: , fp_create_acctg_flag in boolean
595: , fp_adjustement_type in Varchar2
596: , l_Adjust_offset_type in varchar2 Default Null
597: , l_Report_CCID in varchar2 Default Null

Line 1509: FROM igi_iac_det_balances iadb,fa_distribution_history fdh

1505: CURSOR c_backlog_data(c_current_period_Counter fa_deprn_periods.period_counter%TYPE) IS
1506: SELECT sum(nvl(iadb.reval_reserve_backlog,0)) reval_reserve_backlog,
1507: sum(nvl(iadb.operating_acct_backlog,0)) operating_acct_backlog,
1508: sum(nvl(iadb.general_fund_per,0)) general_fund_per
1509: FROM igi_iac_det_balances iadb,fa_distribution_history fdh
1510: WHERE iadb.book_type_code = l_asset_hdr_rec.book_type_code
1511: AND iadb.period_counter = c_current_period_counter
1512: AND iadb.asset_id=l_asset_hdr_rec.asset_id
1513: AND iadb.asset_id=fdh.asset_id

Line 1529: FROM igi_iac_det_balances

1525: /* get the closing det balances record */
1526: CURSOR c_closing_det_balances( p_old_dist IGI_IAC_ADJUSTMENTS.distribution_id%TYPE,
1527: p_adjustment_id IGI_IAC_ADJUSTMENTS.adjustment_id%TYPE)IS
1528: SELECT *
1529: FROM igi_iac_det_balances
1530: WHERE asset_id=l_asset_hdr_rec.asset_id
1531: AND book_type_code = l_asset_hdr_rec.book_type_code
1532: AND distribution_id = p_old_dist
1533: AND adjustment_id = p_adjustment_id;

Line 1539: FROM igi_iac_det_balances

1535: /* Cursor to get incactive distributuiions to be carried forward */
1536: CURSOR get_all_prev_inactive_dist (C_prev_data_adjustment_id NUMBER)
1537: IS
1538: SELECT *
1539: FROM igi_iac_det_balances
1540: WHERE asset_id=l_asset_hdr_rec.asset_id
1541: AND book_type_code = l_asset_hdr_rec.book_type_code
1542: AND adjustment_id = C_prev_data_adjustment_id;
1543: -- AND nvl(active_flag,'Y') = 'N';

Line 1577: l_reval_reserve IGI_IAC_DET_BALANCES.reval_reserve_cost%TYPE;

1573: l_start_period_counter FA_DEPRN_PERIODS.period_counter%TYPE;
1574:
1575: l_asset_num FA_ADDITIONS.asset_number%TYPE;
1576: l_units FA_DISTRIBUTION_HISTORY.units_assigned%TYPE;
1577: l_reval_reserve IGI_IAC_DET_BALANCES.reval_reserve_cost%TYPE;
1578: l_general_fund IGI_IAC_DET_BALANCES.general_fund_acc%TYPE;
1579: l_Backlog_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve_backlog%TYPE;
1580: l_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve%TYPE;
1581: l_adjusted_cost IGI_IAC_DET_BALANCES.adjustment_cost%TYPE;

Line 1578: l_general_fund IGI_IAC_DET_BALANCES.general_fund_acc%TYPE;

1574:
1575: l_asset_num FA_ADDITIONS.asset_number%TYPE;
1576: l_units FA_DISTRIBUTION_HISTORY.units_assigned%TYPE;
1577: l_reval_reserve IGI_IAC_DET_BALANCES.reval_reserve_cost%TYPE;
1578: l_general_fund IGI_IAC_DET_BALANCES.general_fund_acc%TYPE;
1579: l_Backlog_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve_backlog%TYPE;
1580: l_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve%TYPE;
1581: l_adjusted_cost IGI_IAC_DET_BALANCES.adjustment_cost%TYPE;
1582: l_net_book_value IGI_IAC_DET_BALANCES.net_book_value%TYPE;

Line 1579: l_Backlog_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve_backlog%TYPE;

1575: l_asset_num FA_ADDITIONS.asset_number%TYPE;
1576: l_units FA_DISTRIBUTION_HISTORY.units_assigned%TYPE;
1577: l_reval_reserve IGI_IAC_DET_BALANCES.reval_reserve_cost%TYPE;
1578: l_general_fund IGI_IAC_DET_BALANCES.general_fund_acc%TYPE;
1579: l_Backlog_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve_backlog%TYPE;
1580: l_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve%TYPE;
1581: l_adjusted_cost IGI_IAC_DET_BALANCES.adjustment_cost%TYPE;
1582: l_net_book_value IGI_IAC_DET_BALANCES.net_book_value%TYPE;
1583: l_deprn_per IGI_IAC_DET_BALANCES.deprn_period%TYPE;

Line 1580: l_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve%TYPE;

1576: l_units FA_DISTRIBUTION_HISTORY.units_assigned%TYPE;
1577: l_reval_reserve IGI_IAC_DET_BALANCES.reval_reserve_cost%TYPE;
1578: l_general_fund IGI_IAC_DET_BALANCES.general_fund_acc%TYPE;
1579: l_Backlog_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve_backlog%TYPE;
1580: l_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve%TYPE;
1581: l_adjusted_cost IGI_IAC_DET_BALANCES.adjustment_cost%TYPE;
1582: l_net_book_value IGI_IAC_DET_BALANCES.net_book_value%TYPE;
1583: l_deprn_per IGI_IAC_DET_BALANCES.deprn_period%TYPE;
1584: l_ytd_deprn IGI_IAC_DET_BALANCES.deprn_ytd%TYPE;

Line 1581: l_adjusted_cost IGI_IAC_DET_BALANCES.adjustment_cost%TYPE;

1577: l_reval_reserve IGI_IAC_DET_BALANCES.reval_reserve_cost%TYPE;
1578: l_general_fund IGI_IAC_DET_BALANCES.general_fund_acc%TYPE;
1579: l_Backlog_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve_backlog%TYPE;
1580: l_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve%TYPE;
1581: l_adjusted_cost IGI_IAC_DET_BALANCES.adjustment_cost%TYPE;
1582: l_net_book_value IGI_IAC_DET_BALANCES.net_book_value%TYPE;
1583: l_deprn_per IGI_IAC_DET_BALANCES.deprn_period%TYPE;
1584: l_ytd_deprn IGI_IAC_DET_BALANCES.deprn_ytd%TYPE;
1585: l_op_acct IGI_IAC_DET_BALANCES.operating_acct_ytd%TYPE;

Line 1582: l_net_book_value IGI_IAC_DET_BALANCES.net_book_value%TYPE;

1578: l_general_fund IGI_IAC_DET_BALANCES.general_fund_acc%TYPE;
1579: l_Backlog_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve_backlog%TYPE;
1580: l_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve%TYPE;
1581: l_adjusted_cost IGI_IAC_DET_BALANCES.adjustment_cost%TYPE;
1582: l_net_book_value IGI_IAC_DET_BALANCES.net_book_value%TYPE;
1583: l_deprn_per IGI_IAC_DET_BALANCES.deprn_period%TYPE;
1584: l_ytd_deprn IGI_IAC_DET_BALANCES.deprn_ytd%TYPE;
1585: l_op_acct IGI_IAC_DET_BALANCES.operating_acct_ytd%TYPE;
1586: l_op_acct_ytd IGI_IAC_DET_BALANCES.operating_acct_ytd%TYPE;

Line 1583: l_deprn_per IGI_IAC_DET_BALANCES.deprn_period%TYPE;

1579: l_Backlog_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve_backlog%TYPE;
1580: l_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve%TYPE;
1581: l_adjusted_cost IGI_IAC_DET_BALANCES.adjustment_cost%TYPE;
1582: l_net_book_value IGI_IAC_DET_BALANCES.net_book_value%TYPE;
1583: l_deprn_per IGI_IAC_DET_BALANCES.deprn_period%TYPE;
1584: l_ytd_deprn IGI_IAC_DET_BALANCES.deprn_ytd%TYPE;
1585: l_op_acct IGI_IAC_DET_BALANCES.operating_acct_ytd%TYPE;
1586: l_op_acct_ytd IGI_IAC_DET_BALANCES.operating_acct_ytd%TYPE;
1587: l_general_fund_per IGI_IAC_DET_BALANCES.general_fund_per%TYPE;

Line 1584: l_ytd_deprn IGI_IAC_DET_BALANCES.deprn_ytd%TYPE;

1580: l_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve%TYPE;
1581: l_adjusted_cost IGI_IAC_DET_BALANCES.adjustment_cost%TYPE;
1582: l_net_book_value IGI_IAC_DET_BALANCES.net_book_value%TYPE;
1583: l_deprn_per IGI_IAC_DET_BALANCES.deprn_period%TYPE;
1584: l_ytd_deprn IGI_IAC_DET_BALANCES.deprn_ytd%TYPE;
1585: l_op_acct IGI_IAC_DET_BALANCES.operating_acct_ytd%TYPE;
1586: l_op_acct_ytd IGI_IAC_DET_BALANCES.operating_acct_ytd%TYPE;
1587: l_general_fund_per IGI_IAC_DET_BALANCES.general_fund_per%TYPE;
1588: l_reval_reserve_backlog IGI_IAC_DET_BALANCES.reval_reserve_backlog%TYPE;

Line 1585: l_op_acct IGI_IAC_DET_BALANCES.operating_acct_ytd%TYPE;

1581: l_adjusted_cost IGI_IAC_DET_BALANCES.adjustment_cost%TYPE;
1582: l_net_book_value IGI_IAC_DET_BALANCES.net_book_value%TYPE;
1583: l_deprn_per IGI_IAC_DET_BALANCES.deprn_period%TYPE;
1584: l_ytd_deprn IGI_IAC_DET_BALANCES.deprn_ytd%TYPE;
1585: l_op_acct IGI_IAC_DET_BALANCES.operating_acct_ytd%TYPE;
1586: l_op_acct_ytd IGI_IAC_DET_BALANCES.operating_acct_ytd%TYPE;
1587: l_general_fund_per IGI_IAC_DET_BALANCES.general_fund_per%TYPE;
1588: l_reval_reserve_backlog IGI_IAC_DET_BALANCES.reval_reserve_backlog%TYPE;
1589: l_operating_acct_backlog IGI_IAC_DET_BALANCES.operating_acct_backlog%TYPE;

Line 1586: l_op_acct_ytd IGI_IAC_DET_BALANCES.operating_acct_ytd%TYPE;

1582: l_net_book_value IGI_IAC_DET_BALANCES.net_book_value%TYPE;
1583: l_deprn_per IGI_IAC_DET_BALANCES.deprn_period%TYPE;
1584: l_ytd_deprn IGI_IAC_DET_BALANCES.deprn_ytd%TYPE;
1585: l_op_acct IGI_IAC_DET_BALANCES.operating_acct_ytd%TYPE;
1586: l_op_acct_ytd IGI_IAC_DET_BALANCES.operating_acct_ytd%TYPE;
1587: l_general_fund_per IGI_IAC_DET_BALANCES.general_fund_per%TYPE;
1588: l_reval_reserve_backlog IGI_IAC_DET_BALANCES.reval_reserve_backlog%TYPE;
1589: l_operating_acct_backlog IGI_IAC_DET_BALANCES.operating_acct_backlog%TYPE;
1590: l_reval_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;

Line 1587: l_general_fund_per IGI_IAC_DET_BALANCES.general_fund_per%TYPE;

1583: l_deprn_per IGI_IAC_DET_BALANCES.deprn_period%TYPE;
1584: l_ytd_deprn IGI_IAC_DET_BALANCES.deprn_ytd%TYPE;
1585: l_op_acct IGI_IAC_DET_BALANCES.operating_acct_ytd%TYPE;
1586: l_op_acct_ytd IGI_IAC_DET_BALANCES.operating_acct_ytd%TYPE;
1587: l_general_fund_per IGI_IAC_DET_BALANCES.general_fund_per%TYPE;
1588: l_reval_reserve_backlog IGI_IAC_DET_BALANCES.reval_reserve_backlog%TYPE;
1589: l_operating_acct_backlog IGI_IAC_DET_BALANCES.operating_acct_backlog%TYPE;
1590: l_reval_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1591: l_gen_fund_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;

Line 1588: l_reval_reserve_backlog IGI_IAC_DET_BALANCES.reval_reserve_backlog%TYPE;

1584: l_ytd_deprn IGI_IAC_DET_BALANCES.deprn_ytd%TYPE;
1585: l_op_acct IGI_IAC_DET_BALANCES.operating_acct_ytd%TYPE;
1586: l_op_acct_ytd IGI_IAC_DET_BALANCES.operating_acct_ytd%TYPE;
1587: l_general_fund_per IGI_IAC_DET_BALANCES.general_fund_per%TYPE;
1588: l_reval_reserve_backlog IGI_IAC_DET_BALANCES.reval_reserve_backlog%TYPE;
1589: l_operating_acct_backlog IGI_IAC_DET_BALANCES.operating_acct_backlog%TYPE;
1590: l_reval_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1591: l_gen_fund_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1592: l_backlog_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;

Line 1589: l_operating_acct_backlog IGI_IAC_DET_BALANCES.operating_acct_backlog%TYPE;

1585: l_op_acct IGI_IAC_DET_BALANCES.operating_acct_ytd%TYPE;
1586: l_op_acct_ytd IGI_IAC_DET_BALANCES.operating_acct_ytd%TYPE;
1587: l_general_fund_per IGI_IAC_DET_BALANCES.general_fund_per%TYPE;
1588: l_reval_reserve_backlog IGI_IAC_DET_BALANCES.reval_reserve_backlog%TYPE;
1589: l_operating_acct_backlog IGI_IAC_DET_BALANCES.operating_acct_backlog%TYPE;
1590: l_reval_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1591: l_gen_fund_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1592: l_backlog_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1593: l_deprn_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;

Line 1597: l_Expense_diff IGI_IAC_DET_BALANCES.deprn_period%TYPE;

1593: l_deprn_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1594: l_cost_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1595: l_prior_period_counter IGI_IAC_TRANSACTION_HEADERS.period_counter%TYPE;
1596: l_historic_deprn_expense FA_DEPRN_SUMMARY.deprn_amount%TYPE;
1597: l_Expense_diff IGI_IAC_DET_BALANCES.deprn_period%TYPE;
1598: l_expense_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1599: l_closing_det_balances IGI_IAC_DET_BALANCES%ROWTYPE;
1600: l_adjustment_id IGI_IAC_ADJUSTMENTS.adjustment_id%TYPE;
1601: l_get_all_prev_dist get_all_prev_inactive_dist%ROWTYPE;

Line 1599: l_closing_det_balances IGI_IAC_DET_BALANCES%ROWTYPE;

1595: l_prior_period_counter IGI_IAC_TRANSACTION_HEADERS.period_counter%TYPE;
1596: l_historic_deprn_expense FA_DEPRN_SUMMARY.deprn_amount%TYPE;
1597: l_Expense_diff IGI_IAC_DET_BALANCES.deprn_period%TYPE;
1598: l_expense_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1599: l_closing_det_balances IGI_IAC_DET_BALANCES%ROWTYPE;
1600: l_adjustment_id IGI_IAC_ADJUSTMENTS.adjustment_id%TYPE;
1601: l_get_all_prev_dist get_all_prev_inactive_dist%ROWTYPE;
1602:
1603: l_rowid ROWID;

Line 1857: -- create entries in igi_iac_det_balances for the new dist

1853: UPDATE igi_iac_transaction_headers
1854: SET category_id = l_asset_cat_rec_new.category_id
1855: WHERE adjustment_id = l_adj_id;
1856:
1857: -- create entries in igi_iac_det_balances for the new dist
1858: insert_data_det(p_adjustment_id =>l_adj_id,
1859: p_asset_id =>l_asset_hdr_rec.asset_id,
1860: p_distribution_id =>l_impacted_dist.distribution_id,
1861: p_period_counter =>l_current_period_counter,

Line 2188: FROM igi_iac_det_balances iadb,fa_distribution_history fdh

2184: CURSOR c_backlog_data(c_current_period_Counter fa_deprn_periods.period_counter%type) IS
2185: SELECT sum(nvl(iadb.reval_reserve_backlog,0)) reval_reserve_backlog,
2186: sum(nvl(iadb.operating_acct_backlog,0)) operating_acct_backlog,
2187: sum(nvl(iadb.general_fund_per,0)) general_fund_per
2188: FROM igi_iac_det_balances iadb,fa_distribution_history fdh
2189: WHERE iadb.book_type_code = l_asset_hdr_rec.book_type_code
2190: AND iadb.period_counter = c_current_period_counter
2191: AND iadb.asset_id=l_asset_hdr_rec.asset_id
2192: AND iadb.asset_id=fdh.asset_id

Line 2208: FROM igi_iac_det_balances

2204: /* get the closing det balances record */
2205: CURSOR c_closing_det_balances( p_old_dist IGI_IAC_ADJUSTMENTS.distribution_id%type,
2206: p_adjustment_id IGI_IAC_ADJUSTMENTS.adjustment_id%type)is
2207: SELECT *
2208: FROM igi_iac_det_balances
2209: WHERE asset_id=l_asset_hdr_rec.asset_id
2210: AND book_type_code = l_asset_hdr_rec.book_type_code
2211: AND distribution_id = p_old_dist
2212: AND adjustment_id = p_adjustment_id;

Line 2218: FROM igi_iac_det_balances

2214: /* Cursor to get incactive distributuiions to be carried forward */
2215: CURSOR get_all_prev_inactive_dist (C_prev_data_adjustment_id Number)
2216: is
2217: SELECT *
2218: FROM igi_iac_det_balances
2219: WHERE asset_id=l_asset_hdr_rec.asset_id
2220: AND book_type_code = l_asset_hdr_rec.book_type_code
2221: AND adjustment_id = C_prev_data_adjustment_id;
2222: -- AND nvl(active_flag,'Y') = 'N';

Line 2255: l_reval_reserve IGI_IAC_DET_BALANCES.reval_reserve_cost%type;

2251: l_start_period_counter FA_DEPRN_PERIODS.period_counter%type;
2252:
2253: l_asset_num FA_ADDITIONS.asset_number%type;
2254: l_units FA_DISTRIBUTION_HISTORY.units_assigned%type;
2255: l_reval_reserve IGI_IAC_DET_BALANCES.reval_reserve_cost%type;
2256: l_general_fund IGI_IAC_DET_BALANCES.general_fund_acc%type;
2257: l_Backlog_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve_backlog%type;
2258: l_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve%type;
2259: l_adjusted_cost IGI_IAC_DET_BALANCES.adjustment_cost%type;

Line 2256: l_general_fund IGI_IAC_DET_BALANCES.general_fund_acc%type;

2252:
2253: l_asset_num FA_ADDITIONS.asset_number%type;
2254: l_units FA_DISTRIBUTION_HISTORY.units_assigned%type;
2255: l_reval_reserve IGI_IAC_DET_BALANCES.reval_reserve_cost%type;
2256: l_general_fund IGI_IAC_DET_BALANCES.general_fund_acc%type;
2257: l_Backlog_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve_backlog%type;
2258: l_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve%type;
2259: l_adjusted_cost IGI_IAC_DET_BALANCES.adjustment_cost%type;
2260: l_net_book_value IGI_IAC_DET_BALANCES.net_book_value%type;

Line 2257: l_Backlog_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve_backlog%type;

2253: l_asset_num FA_ADDITIONS.asset_number%type;
2254: l_units FA_DISTRIBUTION_HISTORY.units_assigned%type;
2255: l_reval_reserve IGI_IAC_DET_BALANCES.reval_reserve_cost%type;
2256: l_general_fund IGI_IAC_DET_BALANCES.general_fund_acc%type;
2257: l_Backlog_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve_backlog%type;
2258: l_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve%type;
2259: l_adjusted_cost IGI_IAC_DET_BALANCES.adjustment_cost%type;
2260: l_net_book_value IGI_IAC_DET_BALANCES.net_book_value%type;
2261: l_deprn_per IGI_IAC_DET_BALANCES.deprn_period%type;

Line 2258: l_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve%type;

2254: l_units FA_DISTRIBUTION_HISTORY.units_assigned%type;
2255: l_reval_reserve IGI_IAC_DET_BALANCES.reval_reserve_cost%type;
2256: l_general_fund IGI_IAC_DET_BALANCES.general_fund_acc%type;
2257: l_Backlog_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve_backlog%type;
2258: l_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve%type;
2259: l_adjusted_cost IGI_IAC_DET_BALANCES.adjustment_cost%type;
2260: l_net_book_value IGI_IAC_DET_BALANCES.net_book_value%type;
2261: l_deprn_per IGI_IAC_DET_BALANCES.deprn_period%type;
2262: l_ytd_deprn IGI_IAC_DET_BALANCES.deprn_ytd%type;

Line 2259: l_adjusted_cost IGI_IAC_DET_BALANCES.adjustment_cost%type;

2255: l_reval_reserve IGI_IAC_DET_BALANCES.reval_reserve_cost%type;
2256: l_general_fund IGI_IAC_DET_BALANCES.general_fund_acc%type;
2257: l_Backlog_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve_backlog%type;
2258: l_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve%type;
2259: l_adjusted_cost IGI_IAC_DET_BALANCES.adjustment_cost%type;
2260: l_net_book_value IGI_IAC_DET_BALANCES.net_book_value%type;
2261: l_deprn_per IGI_IAC_DET_BALANCES.deprn_period%type;
2262: l_ytd_deprn IGI_IAC_DET_BALANCES.deprn_ytd%type;
2263: l_op_acct IGI_IAC_DET_BALANCES.operating_acct_ytd%type;

Line 2260: l_net_book_value IGI_IAC_DET_BALANCES.net_book_value%type;

2256: l_general_fund IGI_IAC_DET_BALANCES.general_fund_acc%type;
2257: l_Backlog_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve_backlog%type;
2258: l_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve%type;
2259: l_adjusted_cost IGI_IAC_DET_BALANCES.adjustment_cost%type;
2260: l_net_book_value IGI_IAC_DET_BALANCES.net_book_value%type;
2261: l_deprn_per IGI_IAC_DET_BALANCES.deprn_period%type;
2262: l_ytd_deprn IGI_IAC_DET_BALANCES.deprn_ytd%type;
2263: l_op_acct IGI_IAC_DET_BALANCES.operating_acct_ytd%type;
2264: l_op_acct_ytd IGI_IAC_DET_BALANCES.operating_acct_ytd%type;

Line 2261: l_deprn_per IGI_IAC_DET_BALANCES.deprn_period%type;

2257: l_Backlog_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve_backlog%type;
2258: l_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve%type;
2259: l_adjusted_cost IGI_IAC_DET_BALANCES.adjustment_cost%type;
2260: l_net_book_value IGI_IAC_DET_BALANCES.net_book_value%type;
2261: l_deprn_per IGI_IAC_DET_BALANCES.deprn_period%type;
2262: l_ytd_deprn IGI_IAC_DET_BALANCES.deprn_ytd%type;
2263: l_op_acct IGI_IAC_DET_BALANCES.operating_acct_ytd%type;
2264: l_op_acct_ytd IGI_IAC_DET_BALANCES.operating_acct_ytd%type;
2265: l_general_fund_per IGI_IAC_DET_BALANCES.general_fund_per%type;

Line 2262: l_ytd_deprn IGI_IAC_DET_BALANCES.deprn_ytd%type;

2258: l_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve%type;
2259: l_adjusted_cost IGI_IAC_DET_BALANCES.adjustment_cost%type;
2260: l_net_book_value IGI_IAC_DET_BALANCES.net_book_value%type;
2261: l_deprn_per IGI_IAC_DET_BALANCES.deprn_period%type;
2262: l_ytd_deprn IGI_IAC_DET_BALANCES.deprn_ytd%type;
2263: l_op_acct IGI_IAC_DET_BALANCES.operating_acct_ytd%type;
2264: l_op_acct_ytd IGI_IAC_DET_BALANCES.operating_acct_ytd%type;
2265: l_general_fund_per IGI_IAC_DET_BALANCES.general_fund_per%type;
2266: l_reval_reserve_backlog IGI_IAC_DET_BALANCES.reval_reserve_backlog%type;

Line 2263: l_op_acct IGI_IAC_DET_BALANCES.operating_acct_ytd%type;

2259: l_adjusted_cost IGI_IAC_DET_BALANCES.adjustment_cost%type;
2260: l_net_book_value IGI_IAC_DET_BALANCES.net_book_value%type;
2261: l_deprn_per IGI_IAC_DET_BALANCES.deprn_period%type;
2262: l_ytd_deprn IGI_IAC_DET_BALANCES.deprn_ytd%type;
2263: l_op_acct IGI_IAC_DET_BALANCES.operating_acct_ytd%type;
2264: l_op_acct_ytd IGI_IAC_DET_BALANCES.operating_acct_ytd%type;
2265: l_general_fund_per IGI_IAC_DET_BALANCES.general_fund_per%type;
2266: l_reval_reserve_backlog IGI_IAC_DET_BALANCES.reval_reserve_backlog%type;
2267: l_operating_acct_backlog IGI_IAC_DET_BALANCES.operating_acct_backlog%type;

Line 2264: l_op_acct_ytd IGI_IAC_DET_BALANCES.operating_acct_ytd%type;

2260: l_net_book_value IGI_IAC_DET_BALANCES.net_book_value%type;
2261: l_deprn_per IGI_IAC_DET_BALANCES.deprn_period%type;
2262: l_ytd_deprn IGI_IAC_DET_BALANCES.deprn_ytd%type;
2263: l_op_acct IGI_IAC_DET_BALANCES.operating_acct_ytd%type;
2264: l_op_acct_ytd IGI_IAC_DET_BALANCES.operating_acct_ytd%type;
2265: l_general_fund_per IGI_IAC_DET_BALANCES.general_fund_per%type;
2266: l_reval_reserve_backlog IGI_IAC_DET_BALANCES.reval_reserve_backlog%type;
2267: l_operating_acct_backlog IGI_IAC_DET_BALANCES.operating_acct_backlog%type;
2268: l_reval_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;

Line 2265: l_general_fund_per IGI_IAC_DET_BALANCES.general_fund_per%type;

2261: l_deprn_per IGI_IAC_DET_BALANCES.deprn_period%type;
2262: l_ytd_deprn IGI_IAC_DET_BALANCES.deprn_ytd%type;
2263: l_op_acct IGI_IAC_DET_BALANCES.operating_acct_ytd%type;
2264: l_op_acct_ytd IGI_IAC_DET_BALANCES.operating_acct_ytd%type;
2265: l_general_fund_per IGI_IAC_DET_BALANCES.general_fund_per%type;
2266: l_reval_reserve_backlog IGI_IAC_DET_BALANCES.reval_reserve_backlog%type;
2267: l_operating_acct_backlog IGI_IAC_DET_BALANCES.operating_acct_backlog%type;
2268: l_reval_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2269: l_gen_fund_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;

Line 2266: l_reval_reserve_backlog IGI_IAC_DET_BALANCES.reval_reserve_backlog%type;

2262: l_ytd_deprn IGI_IAC_DET_BALANCES.deprn_ytd%type;
2263: l_op_acct IGI_IAC_DET_BALANCES.operating_acct_ytd%type;
2264: l_op_acct_ytd IGI_IAC_DET_BALANCES.operating_acct_ytd%type;
2265: l_general_fund_per IGI_IAC_DET_BALANCES.general_fund_per%type;
2266: l_reval_reserve_backlog IGI_IAC_DET_BALANCES.reval_reserve_backlog%type;
2267: l_operating_acct_backlog IGI_IAC_DET_BALANCES.operating_acct_backlog%type;
2268: l_reval_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2269: l_gen_fund_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2270: l_backlog_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;

Line 2267: l_operating_acct_backlog IGI_IAC_DET_BALANCES.operating_acct_backlog%type;

2263: l_op_acct IGI_IAC_DET_BALANCES.operating_acct_ytd%type;
2264: l_op_acct_ytd IGI_IAC_DET_BALANCES.operating_acct_ytd%type;
2265: l_general_fund_per IGI_IAC_DET_BALANCES.general_fund_per%type;
2266: l_reval_reserve_backlog IGI_IAC_DET_BALANCES.reval_reserve_backlog%type;
2267: l_operating_acct_backlog IGI_IAC_DET_BALANCES.operating_acct_backlog%type;
2268: l_reval_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2269: l_gen_fund_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2270: l_backlog_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2271: l_deprn_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;

Line 2275: l_Expense_diff IGI_IAC_DET_BALANCES.deprn_period%type;

2271: l_deprn_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2272: l_cost_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2273: l_prior_period_counter IGI_IAC_TRANSACTION_HEADERS.period_counter%type;
2274: l_historic_deprn_expense FA_DEPRN_SUMMARY.deprn_amount%type;
2275: l_Expense_diff IGI_IAC_DET_BALANCES.deprn_period%type;
2276: l_expense_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2277: l_closing_det_balances IGI_IAC_DET_BALANCES%ROWTYPE;
2278: l_adjustment_id IGI_IAC_ADJUSTMENTS.adjustment_id%type;
2279: l_get_all_prev_dist get_all_prev_inactive_dist%ROWTYPE;

Line 2277: l_closing_det_balances IGI_IAC_DET_BALANCES%ROWTYPE;

2273: l_prior_period_counter IGI_IAC_TRANSACTION_HEADERS.period_counter%type;
2274: l_historic_deprn_expense FA_DEPRN_SUMMARY.deprn_amount%type;
2275: l_Expense_diff IGI_IAC_DET_BALANCES.deprn_period%type;
2276: l_expense_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2277: l_closing_det_balances IGI_IAC_DET_BALANCES%ROWTYPE;
2278: l_adjustment_id IGI_IAC_ADJUSTMENTS.adjustment_id%type;
2279: l_get_all_prev_dist get_all_prev_inactive_dist%ROWTYPE;
2280:
2281: l_rowid rowid;