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.

[Home] [Help]

APPS.IGI_IAC_RECLASS_PKG dependencies on IGI_IAC_DET_BALANCES

Line 357: | Procedure to insert data into IGI_IAC_DET_BALANCES |

353:
354:
355: /*
356: +===============================================================================+
357: | Procedure to insert data into IGI_IAC_DET_BALANCES |
358: ================================================================================+
359: */
360:
361: PROCEDURE insert_data_det(p_adjustment_id in IGI_IAC_DET_BALANCES.adjustment_id%type,

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

357: | Procedure to insert data into IGI_IAC_DET_BALANCES |
358: ================================================================================+
359: */
360:
361: PROCEDURE insert_data_det(p_adjustment_id in IGI_IAC_DET_BALANCES.adjustment_id%type,
362: p_asset_id in IGI_IAC_DET_BALANCES.asset_id%type,
363: p_distribution_id in IGI_IAC_DET_BALANCES.distribution_id%type,
364: p_period_counter in IGI_IAC_DET_BALANCES.period_counter%type,
365: p_book_type_code in IGI_IAC_DET_BALANCES.book_type_code%type,

Line 362: p_asset_id in IGI_IAC_DET_BALANCES.asset_id%type,

358: ================================================================================+
359: */
360:
361: PROCEDURE insert_data_det(p_adjustment_id in IGI_IAC_DET_BALANCES.adjustment_id%type,
362: p_asset_id in IGI_IAC_DET_BALANCES.asset_id%type,
363: p_distribution_id in IGI_IAC_DET_BALANCES.distribution_id%type,
364: p_period_counter in IGI_IAC_DET_BALANCES.period_counter%type,
365: p_book_type_code in IGI_IAC_DET_BALANCES.book_type_code%type,
366: p_adjusted_cost in IGI_IAC_DET_BALANCES.adjustment_cost%type,

Line 363: p_distribution_id in IGI_IAC_DET_BALANCES.distribution_id%type,

359: */
360:
361: PROCEDURE insert_data_det(p_adjustment_id in IGI_IAC_DET_BALANCES.adjustment_id%type,
362: p_asset_id in IGI_IAC_DET_BALANCES.asset_id%type,
363: p_distribution_id in IGI_IAC_DET_BALANCES.distribution_id%type,
364: p_period_counter in IGI_IAC_DET_BALANCES.period_counter%type,
365: p_book_type_code in IGI_IAC_DET_BALANCES.book_type_code%type,
366: p_adjusted_cost in IGI_IAC_DET_BALANCES.adjustment_cost%type,
367: p_net_book_value in IGI_IAC_DET_BALANCES.net_book_value%type,

Line 364: p_period_counter in IGI_IAC_DET_BALANCES.period_counter%type,

360:
361: PROCEDURE insert_data_det(p_adjustment_id in IGI_IAC_DET_BALANCES.adjustment_id%type,
362: p_asset_id in IGI_IAC_DET_BALANCES.asset_id%type,
363: p_distribution_id in IGI_IAC_DET_BALANCES.distribution_id%type,
364: p_period_counter in IGI_IAC_DET_BALANCES.period_counter%type,
365: p_book_type_code in IGI_IAC_DET_BALANCES.book_type_code%type,
366: p_adjusted_cost in IGI_IAC_DET_BALANCES.adjustment_cost%type,
367: p_net_book_value in IGI_IAC_DET_BALANCES.net_book_value%type,
368: p_reval_reserve in IGI_IAC_DET_BALANCES.reval_reserve_cost%type,

Line 365: p_book_type_code in IGI_IAC_DET_BALANCES.book_type_code%type,

361: PROCEDURE insert_data_det(p_adjustment_id in IGI_IAC_DET_BALANCES.adjustment_id%type,
362: p_asset_id in IGI_IAC_DET_BALANCES.asset_id%type,
363: p_distribution_id in IGI_IAC_DET_BALANCES.distribution_id%type,
364: p_period_counter in IGI_IAC_DET_BALANCES.period_counter%type,
365: p_book_type_code in IGI_IAC_DET_BALANCES.book_type_code%type,
366: p_adjusted_cost in IGI_IAC_DET_BALANCES.adjustment_cost%type,
367: p_net_book_value in IGI_IAC_DET_BALANCES.net_book_value%type,
368: p_reval_reserve in IGI_IAC_DET_BALANCES.reval_reserve_cost%type,
369: p_reval_reserve_gen_fund in IGI_IAC_DET_BALANCES.reval_reserve_gen_fund%type,

Line 366: p_adjusted_cost in IGI_IAC_DET_BALANCES.adjustment_cost%type,

362: p_asset_id in IGI_IAC_DET_BALANCES.asset_id%type,
363: p_distribution_id in IGI_IAC_DET_BALANCES.distribution_id%type,
364: p_period_counter in IGI_IAC_DET_BALANCES.period_counter%type,
365: p_book_type_code in IGI_IAC_DET_BALANCES.book_type_code%type,
366: p_adjusted_cost in IGI_IAC_DET_BALANCES.adjustment_cost%type,
367: p_net_book_value in IGI_IAC_DET_BALANCES.net_book_value%type,
368: p_reval_reserve in IGI_IAC_DET_BALANCES.reval_reserve_cost%type,
369: p_reval_reserve_gen_fund in IGI_IAC_DET_BALANCES.reval_reserve_gen_fund%type,
370: p_reval_reserve_backlog in IGI_IAC_DET_BALANCES.reval_reserve_backlog%type,

Line 367: p_net_book_value in IGI_IAC_DET_BALANCES.net_book_value%type,

363: p_distribution_id in IGI_IAC_DET_BALANCES.distribution_id%type,
364: p_period_counter in IGI_IAC_DET_BALANCES.period_counter%type,
365: p_book_type_code in IGI_IAC_DET_BALANCES.book_type_code%type,
366: p_adjusted_cost in IGI_IAC_DET_BALANCES.adjustment_cost%type,
367: p_net_book_value in IGI_IAC_DET_BALANCES.net_book_value%type,
368: p_reval_reserve in IGI_IAC_DET_BALANCES.reval_reserve_cost%type,
369: p_reval_reserve_gen_fund in IGI_IAC_DET_BALANCES.reval_reserve_gen_fund%type,
370: p_reval_reserve_backlog in IGI_IAC_DET_BALANCES.reval_reserve_backlog%type,
371: p_reval_reserve_net in IGI_IAC_DET_BALANCES.reval_reserve_net%type,

Line 368: p_reval_reserve in IGI_IAC_DET_BALANCES.reval_reserve_cost%type,

364: p_period_counter in IGI_IAC_DET_BALANCES.period_counter%type,
365: p_book_type_code in IGI_IAC_DET_BALANCES.book_type_code%type,
366: p_adjusted_cost in IGI_IAC_DET_BALANCES.adjustment_cost%type,
367: p_net_book_value in IGI_IAC_DET_BALANCES.net_book_value%type,
368: p_reval_reserve in IGI_IAC_DET_BALANCES.reval_reserve_cost%type,
369: p_reval_reserve_gen_fund in IGI_IAC_DET_BALANCES.reval_reserve_gen_fund%type,
370: p_reval_reserve_backlog in IGI_IAC_DET_BALANCES.reval_reserve_backlog%type,
371: p_reval_reserve_net in IGI_IAC_DET_BALANCES.reval_reserve_net%type,
372: p_op_acct in IGI_IAC_DET_BALANCES.operating_acct_cost%type,

Line 369: p_reval_reserve_gen_fund in IGI_IAC_DET_BALANCES.reval_reserve_gen_fund%type,

365: p_book_type_code in IGI_IAC_DET_BALANCES.book_type_code%type,
366: p_adjusted_cost in IGI_IAC_DET_BALANCES.adjustment_cost%type,
367: p_net_book_value in IGI_IAC_DET_BALANCES.net_book_value%type,
368: p_reval_reserve in IGI_IAC_DET_BALANCES.reval_reserve_cost%type,
369: p_reval_reserve_gen_fund in IGI_IAC_DET_BALANCES.reval_reserve_gen_fund%type,
370: p_reval_reserve_backlog in IGI_IAC_DET_BALANCES.reval_reserve_backlog%type,
371: p_reval_reserve_net in IGI_IAC_DET_BALANCES.reval_reserve_net%type,
372: p_op_acct in IGI_IAC_DET_BALANCES.operating_acct_cost%type,
373: p_op_acct_net in IGI_IAC_DET_BALANCES.operating_acct_net%type,

Line 370: p_reval_reserve_backlog in IGI_IAC_DET_BALANCES.reval_reserve_backlog%type,

366: p_adjusted_cost in IGI_IAC_DET_BALANCES.adjustment_cost%type,
367: p_net_book_value in IGI_IAC_DET_BALANCES.net_book_value%type,
368: p_reval_reserve in IGI_IAC_DET_BALANCES.reval_reserve_cost%type,
369: p_reval_reserve_gen_fund in IGI_IAC_DET_BALANCES.reval_reserve_gen_fund%type,
370: p_reval_reserve_backlog in IGI_IAC_DET_BALANCES.reval_reserve_backlog%type,
371: p_reval_reserve_net in IGI_IAC_DET_BALANCES.reval_reserve_net%type,
372: p_op_acct in IGI_IAC_DET_BALANCES.operating_acct_cost%type,
373: p_op_acct_net in IGI_IAC_DET_BALANCES.operating_acct_net%type,
374: p_deprn_reserve in IGI_IAC_DET_BALANCES.deprn_reserve%type,

Line 371: p_reval_reserve_net in IGI_IAC_DET_BALANCES.reval_reserve_net%type,

367: p_net_book_value in IGI_IAC_DET_BALANCES.net_book_value%type,
368: p_reval_reserve in IGI_IAC_DET_BALANCES.reval_reserve_cost%type,
369: p_reval_reserve_gen_fund in IGI_IAC_DET_BALANCES.reval_reserve_gen_fund%type,
370: p_reval_reserve_backlog in IGI_IAC_DET_BALANCES.reval_reserve_backlog%type,
371: p_reval_reserve_net in IGI_IAC_DET_BALANCES.reval_reserve_net%type,
372: p_op_acct in IGI_IAC_DET_BALANCES.operating_acct_cost%type,
373: p_op_acct_net in IGI_IAC_DET_BALANCES.operating_acct_net%type,
374: p_deprn_reserve in IGI_IAC_DET_BALANCES.deprn_reserve%type,
375: p_deprn_reserve_backlog in IGI_IAC_DET_BALANCES.deprn_reserve_backlog%type,

Line 372: p_op_acct in IGI_IAC_DET_BALANCES.operating_acct_cost%type,

368: p_reval_reserve in IGI_IAC_DET_BALANCES.reval_reserve_cost%type,
369: p_reval_reserve_gen_fund in IGI_IAC_DET_BALANCES.reval_reserve_gen_fund%type,
370: p_reval_reserve_backlog in IGI_IAC_DET_BALANCES.reval_reserve_backlog%type,
371: p_reval_reserve_net in IGI_IAC_DET_BALANCES.reval_reserve_net%type,
372: p_op_acct in IGI_IAC_DET_BALANCES.operating_acct_cost%type,
373: p_op_acct_net in IGI_IAC_DET_BALANCES.operating_acct_net%type,
374: p_deprn_reserve in IGI_IAC_DET_BALANCES.deprn_reserve%type,
375: p_deprn_reserve_backlog in IGI_IAC_DET_BALANCES.deprn_reserve_backlog%type,
376: p_deprn_ytd in IGI_IAC_DET_BALANCES.deprn_ytd%type,

Line 373: p_op_acct_net in IGI_IAC_DET_BALANCES.operating_acct_net%type,

369: p_reval_reserve_gen_fund in IGI_IAC_DET_BALANCES.reval_reserve_gen_fund%type,
370: p_reval_reserve_backlog in IGI_IAC_DET_BALANCES.reval_reserve_backlog%type,
371: p_reval_reserve_net in IGI_IAC_DET_BALANCES.reval_reserve_net%type,
372: p_op_acct in IGI_IAC_DET_BALANCES.operating_acct_cost%type,
373: p_op_acct_net in IGI_IAC_DET_BALANCES.operating_acct_net%type,
374: p_deprn_reserve in IGI_IAC_DET_BALANCES.deprn_reserve%type,
375: p_deprn_reserve_backlog in IGI_IAC_DET_BALANCES.deprn_reserve_backlog%type,
376: p_deprn_ytd in IGI_IAC_DET_BALANCES.deprn_ytd%type,
377: p_deprn_period in IGI_IAC_DET_BALANCES.deprn_period%type,

Line 374: p_deprn_reserve in IGI_IAC_DET_BALANCES.deprn_reserve%type,

370: p_reval_reserve_backlog in IGI_IAC_DET_BALANCES.reval_reserve_backlog%type,
371: p_reval_reserve_net in IGI_IAC_DET_BALANCES.reval_reserve_net%type,
372: p_op_acct in IGI_IAC_DET_BALANCES.operating_acct_cost%type,
373: p_op_acct_net in IGI_IAC_DET_BALANCES.operating_acct_net%type,
374: p_deprn_reserve in IGI_IAC_DET_BALANCES.deprn_reserve%type,
375: p_deprn_reserve_backlog in IGI_IAC_DET_BALANCES.deprn_reserve_backlog%type,
376: p_deprn_ytd in IGI_IAC_DET_BALANCES.deprn_ytd%type,
377: p_deprn_period in IGI_IAC_DET_BALANCES.deprn_period%type,
378: p_gen_fund_acc in IGI_IAC_DET_BALANCES.general_fund_acc%type,

Line 375: p_deprn_reserve_backlog in IGI_IAC_DET_BALANCES.deprn_reserve_backlog%type,

371: p_reval_reserve_net in IGI_IAC_DET_BALANCES.reval_reserve_net%type,
372: p_op_acct in IGI_IAC_DET_BALANCES.operating_acct_cost%type,
373: p_op_acct_net in IGI_IAC_DET_BALANCES.operating_acct_net%type,
374: p_deprn_reserve in IGI_IAC_DET_BALANCES.deprn_reserve%type,
375: p_deprn_reserve_backlog in IGI_IAC_DET_BALANCES.deprn_reserve_backlog%type,
376: p_deprn_ytd in IGI_IAC_DET_BALANCES.deprn_ytd%type,
377: p_deprn_period in IGI_IAC_DET_BALANCES.deprn_period%type,
378: p_gen_fund_acc in IGI_IAC_DET_BALANCES.general_fund_acc%type,
379: p_gen_fund_per in IGI_IAC_DET_BALANCES.general_fund_acc%type,

Line 376: p_deprn_ytd in IGI_IAC_DET_BALANCES.deprn_ytd%type,

372: p_op_acct in IGI_IAC_DET_BALANCES.operating_acct_cost%type,
373: p_op_acct_net in IGI_IAC_DET_BALANCES.operating_acct_net%type,
374: p_deprn_reserve in IGI_IAC_DET_BALANCES.deprn_reserve%type,
375: p_deprn_reserve_backlog in IGI_IAC_DET_BALANCES.deprn_reserve_backlog%type,
376: p_deprn_ytd in IGI_IAC_DET_BALANCES.deprn_ytd%type,
377: p_deprn_period in IGI_IAC_DET_BALANCES.deprn_period%type,
378: p_gen_fund_acc in IGI_IAC_DET_BALANCES.general_fund_acc%type,
379: p_gen_fund_per in IGI_IAC_DET_BALANCES.general_fund_acc%type,
380: p_current_reval_factor in IGI_IAC_DET_BALANCES.current_reval_factor%type,

Line 377: p_deprn_period in IGI_IAC_DET_BALANCES.deprn_period%type,

373: p_op_acct_net in IGI_IAC_DET_BALANCES.operating_acct_net%type,
374: p_deprn_reserve in IGI_IAC_DET_BALANCES.deprn_reserve%type,
375: p_deprn_reserve_backlog in IGI_IAC_DET_BALANCES.deprn_reserve_backlog%type,
376: p_deprn_ytd in IGI_IAC_DET_BALANCES.deprn_ytd%type,
377: p_deprn_period in IGI_IAC_DET_BALANCES.deprn_period%type,
378: p_gen_fund_acc in IGI_IAC_DET_BALANCES.general_fund_acc%type,
379: p_gen_fund_per in IGI_IAC_DET_BALANCES.general_fund_acc%type,
380: p_current_reval_factor in IGI_IAC_DET_BALANCES.current_reval_factor%type,
381: p_cumulative_reval_factor in IGI_IAC_DET_BALANCES.cumulative_reval_factor%type,

Line 378: p_gen_fund_acc in IGI_IAC_DET_BALANCES.general_fund_acc%type,

374: p_deprn_reserve in IGI_IAC_DET_BALANCES.deprn_reserve%type,
375: p_deprn_reserve_backlog in IGI_IAC_DET_BALANCES.deprn_reserve_backlog%type,
376: p_deprn_ytd in IGI_IAC_DET_BALANCES.deprn_ytd%type,
377: p_deprn_period in IGI_IAC_DET_BALANCES.deprn_period%type,
378: p_gen_fund_acc in IGI_IAC_DET_BALANCES.general_fund_acc%type,
379: p_gen_fund_per in IGI_IAC_DET_BALANCES.general_fund_acc%type,
380: p_current_reval_factor in IGI_IAC_DET_BALANCES.current_reval_factor%type,
381: p_cumulative_reval_factor in IGI_IAC_DET_BALANCES.cumulative_reval_factor%type,
382: p_reval_flag in IGI_IAC_DET_BALANCES.active_flag%type,

Line 379: p_gen_fund_per in IGI_IAC_DET_BALANCES.general_fund_acc%type,

375: p_deprn_reserve_backlog in IGI_IAC_DET_BALANCES.deprn_reserve_backlog%type,
376: p_deprn_ytd in IGI_IAC_DET_BALANCES.deprn_ytd%type,
377: p_deprn_period in IGI_IAC_DET_BALANCES.deprn_period%type,
378: p_gen_fund_acc in IGI_IAC_DET_BALANCES.general_fund_acc%type,
379: p_gen_fund_per in IGI_IAC_DET_BALANCES.general_fund_acc%type,
380: p_current_reval_factor in IGI_IAC_DET_BALANCES.current_reval_factor%type,
381: p_cumulative_reval_factor in IGI_IAC_DET_BALANCES.cumulative_reval_factor%type,
382: p_reval_flag in IGI_IAC_DET_BALANCES.active_flag%type,
383: p_op_acct_ytd in IGI_IAC_DET_BALANCES.operating_acct_ytd%type,

Line 380: p_current_reval_factor in IGI_IAC_DET_BALANCES.current_reval_factor%type,

376: p_deprn_ytd in IGI_IAC_DET_BALANCES.deprn_ytd%type,
377: p_deprn_period in IGI_IAC_DET_BALANCES.deprn_period%type,
378: p_gen_fund_acc in IGI_IAC_DET_BALANCES.general_fund_acc%type,
379: p_gen_fund_per in IGI_IAC_DET_BALANCES.general_fund_acc%type,
380: p_current_reval_factor in IGI_IAC_DET_BALANCES.current_reval_factor%type,
381: p_cumulative_reval_factor in IGI_IAC_DET_BALANCES.cumulative_reval_factor%type,
382: p_reval_flag in IGI_IAC_DET_BALANCES.active_flag%type,
383: p_op_acct_ytd in IGI_IAC_DET_BALANCES.operating_acct_ytd%type,
384: p_operating_acct_backlog in IGI_IAC_DET_BALANCES.operating_acct_backlog%type,

Line 381: p_cumulative_reval_factor in IGI_IAC_DET_BALANCES.cumulative_reval_factor%type,

377: p_deprn_period in IGI_IAC_DET_BALANCES.deprn_period%type,
378: p_gen_fund_acc in IGI_IAC_DET_BALANCES.general_fund_acc%type,
379: p_gen_fund_per in IGI_IAC_DET_BALANCES.general_fund_acc%type,
380: p_current_reval_factor in IGI_IAC_DET_BALANCES.current_reval_factor%type,
381: p_cumulative_reval_factor in IGI_IAC_DET_BALANCES.cumulative_reval_factor%type,
382: p_reval_flag in IGI_IAC_DET_BALANCES.active_flag%type,
383: p_op_acct_ytd in IGI_IAC_DET_BALANCES.operating_acct_ytd%type,
384: p_operating_acct_backlog in IGI_IAC_DET_BALANCES.operating_acct_backlog%type,
385: p_last_reval_date in IGI_IAC_DET_BALANCES.last_reval_date%type

Line 382: p_reval_flag in IGI_IAC_DET_BALANCES.active_flag%type,

378: p_gen_fund_acc in IGI_IAC_DET_BALANCES.general_fund_acc%type,
379: p_gen_fund_per in IGI_IAC_DET_BALANCES.general_fund_acc%type,
380: p_current_reval_factor in IGI_IAC_DET_BALANCES.current_reval_factor%type,
381: p_cumulative_reval_factor in IGI_IAC_DET_BALANCES.cumulative_reval_factor%type,
382: p_reval_flag in IGI_IAC_DET_BALANCES.active_flag%type,
383: p_op_acct_ytd in IGI_IAC_DET_BALANCES.operating_acct_ytd%type,
384: p_operating_acct_backlog in IGI_IAC_DET_BALANCES.operating_acct_backlog%type,
385: p_last_reval_date in IGI_IAC_DET_BALANCES.last_reval_date%type
386: ) IS

Line 383: p_op_acct_ytd in IGI_IAC_DET_BALANCES.operating_acct_ytd%type,

379: p_gen_fund_per in IGI_IAC_DET_BALANCES.general_fund_acc%type,
380: p_current_reval_factor in IGI_IAC_DET_BALANCES.current_reval_factor%type,
381: p_cumulative_reval_factor in IGI_IAC_DET_BALANCES.cumulative_reval_factor%type,
382: p_reval_flag in IGI_IAC_DET_BALANCES.active_flag%type,
383: p_op_acct_ytd in IGI_IAC_DET_BALANCES.operating_acct_ytd%type,
384: p_operating_acct_backlog in IGI_IAC_DET_BALANCES.operating_acct_backlog%type,
385: p_last_reval_date in IGI_IAC_DET_BALANCES.last_reval_date%type
386: ) IS
387:

Line 384: p_operating_acct_backlog in IGI_IAC_DET_BALANCES.operating_acct_backlog%type,

380: p_current_reval_factor in IGI_IAC_DET_BALANCES.current_reval_factor%type,
381: p_cumulative_reval_factor in IGI_IAC_DET_BALANCES.cumulative_reval_factor%type,
382: p_reval_flag in IGI_IAC_DET_BALANCES.active_flag%type,
383: p_op_acct_ytd in IGI_IAC_DET_BALANCES.operating_acct_ytd%type,
384: p_operating_acct_backlog in IGI_IAC_DET_BALANCES.operating_acct_backlog%type,
385: p_last_reval_date in IGI_IAC_DET_BALANCES.last_reval_date%type
386: ) IS
387:
388: l_rowid VARCHAR2(25);

Line 385: p_last_reval_date in IGI_IAC_DET_BALANCES.last_reval_date%type

381: p_cumulative_reval_factor in IGI_IAC_DET_BALANCES.cumulative_reval_factor%type,
382: p_reval_flag in IGI_IAC_DET_BALANCES.active_flag%type,
383: p_op_acct_ytd in IGI_IAC_DET_BALANCES.operating_acct_ytd%type,
384: p_operating_acct_backlog in IGI_IAC_DET_BALANCES.operating_acct_backlog%type,
385: p_last_reval_date in IGI_IAC_DET_BALANCES.last_reval_date%type
386: ) IS
387:
388: l_rowid VARCHAR2(25);
389: l_mesg VARCHAR2(500);

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

390: l_path_name VARCHAR2(150);
391: BEGIN
392: l_path_name := g_path||'insert_data_det';
393:
394: /* Call to TBH for insert into IGI_IAC_DET_BALANCES */
395: IGI_IAC_DET_BALANCES_PKG.insert_row(
396: x_rowid =>l_rowid,
397: x_adjustment_id =>p_adjustment_id,
398: x_asset_id =>p_asset_id,

Line 395: IGI_IAC_DET_BALANCES_PKG.insert_row(

391: BEGIN
392: l_path_name := g_path||'insert_data_det';
393:
394: /* Call to TBH for insert into IGI_IAC_DET_BALANCES */
395: IGI_IAC_DET_BALANCES_PKG.insert_row(
396: x_rowid =>l_rowid,
397: x_adjustment_id =>p_adjustment_id,
398: x_asset_id =>p_asset_id,
399: x_distribution_id =>p_distribution_id,

Line 509: , fp_det_balances in igi_iac_det_balances%rowtype

505: , p_amount in number
506: , l_adjust_type in varchar2
507: , l_cr_dr_flag in varchar2
508: , l_set_of_books_id in number
509: , fp_det_balances in igi_iac_det_balances%rowtype
510: , l_adjust_offset_type in varchar2 Default Null
511: , l_Report_CCID in varchar2 Default Null
512: , p_event_id in number
513: )

Line 560: ( fp_det_balances in IGI_IAC_DET_BALANCES%ROWTYPE

556:
557: end;
558:
559: function create_iac_acctg
560: ( fp_det_balances in IGI_IAC_DET_BALANCES%ROWTYPE
561: , fp_create_acctg_flag in boolean
562: , fp_adjustement_type in Varchar2
563: , l_Adjust_offset_type in varchar2 Default Null
564: , l_Report_CCID in varchar2 Default Null

Line 1476: FROM igi_iac_det_balances iadb,fa_distribution_history fdh

1472: CURSOR c_backlog_data(c_current_period_Counter fa_deprn_periods.period_counter%TYPE) IS
1473: SELECT sum(nvl(iadb.reval_reserve_backlog,0)) reval_reserve_backlog,
1474: sum(nvl(iadb.operating_acct_backlog,0)) operating_acct_backlog,
1475: sum(nvl(iadb.general_fund_per,0)) general_fund_per
1476: FROM igi_iac_det_balances iadb,fa_distribution_history fdh
1477: WHERE iadb.book_type_code = l_asset_hdr_rec.book_type_code
1478: AND iadb.period_counter = c_current_period_counter
1479: AND iadb.asset_id=l_asset_hdr_rec.asset_id
1480: AND iadb.asset_id=fdh.asset_id

Line 1496: FROM igi_iac_det_balances

1492: /* get the closing det balances record */
1493: CURSOR c_closing_det_balances( p_old_dist IGI_IAC_ADJUSTMENTS.distribution_id%TYPE,
1494: p_adjustment_id IGI_IAC_ADJUSTMENTS.adjustment_id%TYPE)IS
1495: SELECT *
1496: FROM igi_iac_det_balances
1497: WHERE asset_id=l_asset_hdr_rec.asset_id
1498: AND book_type_code = l_asset_hdr_rec.book_type_code
1499: AND distribution_id = p_old_dist
1500: AND adjustment_id = p_adjustment_id;

Line 1506: FROM igi_iac_det_balances

1502: /* Cursor to get incactive distributuiions to be carried forward */
1503: CURSOR get_all_prev_inactive_dist (C_prev_data_adjustment_id NUMBER)
1504: IS
1505: SELECT *
1506: FROM igi_iac_det_balances
1507: WHERE asset_id=l_asset_hdr_rec.asset_id
1508: AND book_type_code = l_asset_hdr_rec.book_type_code
1509: AND adjustment_id = C_prev_data_adjustment_id;
1510: -- AND nvl(active_flag,'Y') = 'N';

Line 1544: l_reval_reserve IGI_IAC_DET_BALANCES.reval_reserve_cost%TYPE;

1540: l_start_period_counter FA_DEPRN_PERIODS.period_counter%TYPE;
1541:
1542: l_asset_num FA_ADDITIONS.asset_number%TYPE;
1543: l_units FA_DISTRIBUTION_HISTORY.units_assigned%TYPE;
1544: l_reval_reserve IGI_IAC_DET_BALANCES.reval_reserve_cost%TYPE;
1545: l_general_fund IGI_IAC_DET_BALANCES.general_fund_acc%TYPE;
1546: l_Backlog_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve_backlog%TYPE;
1547: l_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve%TYPE;
1548: l_adjusted_cost IGI_IAC_DET_BALANCES.adjustment_cost%TYPE;

Line 1545: l_general_fund IGI_IAC_DET_BALANCES.general_fund_acc%TYPE;

1541:
1542: l_asset_num FA_ADDITIONS.asset_number%TYPE;
1543: l_units FA_DISTRIBUTION_HISTORY.units_assigned%TYPE;
1544: l_reval_reserve IGI_IAC_DET_BALANCES.reval_reserve_cost%TYPE;
1545: l_general_fund IGI_IAC_DET_BALANCES.general_fund_acc%TYPE;
1546: l_Backlog_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve_backlog%TYPE;
1547: l_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve%TYPE;
1548: l_adjusted_cost IGI_IAC_DET_BALANCES.adjustment_cost%TYPE;
1549: l_net_book_value IGI_IAC_DET_BALANCES.net_book_value%TYPE;

Line 1546: l_Backlog_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve_backlog%TYPE;

1542: l_asset_num FA_ADDITIONS.asset_number%TYPE;
1543: l_units FA_DISTRIBUTION_HISTORY.units_assigned%TYPE;
1544: l_reval_reserve IGI_IAC_DET_BALANCES.reval_reserve_cost%TYPE;
1545: l_general_fund IGI_IAC_DET_BALANCES.general_fund_acc%TYPE;
1546: l_Backlog_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve_backlog%TYPE;
1547: l_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve%TYPE;
1548: l_adjusted_cost IGI_IAC_DET_BALANCES.adjustment_cost%TYPE;
1549: l_net_book_value IGI_IAC_DET_BALANCES.net_book_value%TYPE;
1550: l_deprn_per IGI_IAC_DET_BALANCES.deprn_period%TYPE;

Line 1547: l_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve%TYPE;

1543: l_units FA_DISTRIBUTION_HISTORY.units_assigned%TYPE;
1544: l_reval_reserve IGI_IAC_DET_BALANCES.reval_reserve_cost%TYPE;
1545: l_general_fund IGI_IAC_DET_BALANCES.general_fund_acc%TYPE;
1546: l_Backlog_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve_backlog%TYPE;
1547: l_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve%TYPE;
1548: l_adjusted_cost IGI_IAC_DET_BALANCES.adjustment_cost%TYPE;
1549: l_net_book_value IGI_IAC_DET_BALANCES.net_book_value%TYPE;
1550: l_deprn_per IGI_IAC_DET_BALANCES.deprn_period%TYPE;
1551: l_ytd_deprn IGI_IAC_DET_BALANCES.deprn_ytd%TYPE;

Line 1548: l_adjusted_cost IGI_IAC_DET_BALANCES.adjustment_cost%TYPE;

1544: l_reval_reserve IGI_IAC_DET_BALANCES.reval_reserve_cost%TYPE;
1545: l_general_fund IGI_IAC_DET_BALANCES.general_fund_acc%TYPE;
1546: l_Backlog_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve_backlog%TYPE;
1547: l_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve%TYPE;
1548: l_adjusted_cost IGI_IAC_DET_BALANCES.adjustment_cost%TYPE;
1549: l_net_book_value IGI_IAC_DET_BALANCES.net_book_value%TYPE;
1550: l_deprn_per IGI_IAC_DET_BALANCES.deprn_period%TYPE;
1551: l_ytd_deprn IGI_IAC_DET_BALANCES.deprn_ytd%TYPE;
1552: l_op_acct IGI_IAC_DET_BALANCES.operating_acct_ytd%TYPE;

Line 1549: l_net_book_value IGI_IAC_DET_BALANCES.net_book_value%TYPE;

1545: l_general_fund IGI_IAC_DET_BALANCES.general_fund_acc%TYPE;
1546: l_Backlog_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve_backlog%TYPE;
1547: l_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve%TYPE;
1548: l_adjusted_cost IGI_IAC_DET_BALANCES.adjustment_cost%TYPE;
1549: l_net_book_value IGI_IAC_DET_BALANCES.net_book_value%TYPE;
1550: l_deprn_per IGI_IAC_DET_BALANCES.deprn_period%TYPE;
1551: l_ytd_deprn IGI_IAC_DET_BALANCES.deprn_ytd%TYPE;
1552: l_op_acct IGI_IAC_DET_BALANCES.operating_acct_ytd%TYPE;
1553: l_op_acct_ytd IGI_IAC_DET_BALANCES.operating_acct_ytd%TYPE;

Line 1550: l_deprn_per IGI_IAC_DET_BALANCES.deprn_period%TYPE;

1546: l_Backlog_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve_backlog%TYPE;
1547: l_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve%TYPE;
1548: l_adjusted_cost IGI_IAC_DET_BALANCES.adjustment_cost%TYPE;
1549: l_net_book_value IGI_IAC_DET_BALANCES.net_book_value%TYPE;
1550: l_deprn_per IGI_IAC_DET_BALANCES.deprn_period%TYPE;
1551: l_ytd_deprn IGI_IAC_DET_BALANCES.deprn_ytd%TYPE;
1552: l_op_acct IGI_IAC_DET_BALANCES.operating_acct_ytd%TYPE;
1553: l_op_acct_ytd IGI_IAC_DET_BALANCES.operating_acct_ytd%TYPE;
1554: l_general_fund_per IGI_IAC_DET_BALANCES.general_fund_per%TYPE;

Line 1551: l_ytd_deprn IGI_IAC_DET_BALANCES.deprn_ytd%TYPE;

1547: l_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve%TYPE;
1548: l_adjusted_cost IGI_IAC_DET_BALANCES.adjustment_cost%TYPE;
1549: l_net_book_value IGI_IAC_DET_BALANCES.net_book_value%TYPE;
1550: l_deprn_per IGI_IAC_DET_BALANCES.deprn_period%TYPE;
1551: l_ytd_deprn IGI_IAC_DET_BALANCES.deprn_ytd%TYPE;
1552: l_op_acct IGI_IAC_DET_BALANCES.operating_acct_ytd%TYPE;
1553: l_op_acct_ytd IGI_IAC_DET_BALANCES.operating_acct_ytd%TYPE;
1554: l_general_fund_per IGI_IAC_DET_BALANCES.general_fund_per%TYPE;
1555: l_reval_reserve_backlog IGI_IAC_DET_BALANCES.reval_reserve_backlog%TYPE;

Line 1552: l_op_acct IGI_IAC_DET_BALANCES.operating_acct_ytd%TYPE;

1548: l_adjusted_cost IGI_IAC_DET_BALANCES.adjustment_cost%TYPE;
1549: l_net_book_value IGI_IAC_DET_BALANCES.net_book_value%TYPE;
1550: l_deprn_per IGI_IAC_DET_BALANCES.deprn_period%TYPE;
1551: l_ytd_deprn IGI_IAC_DET_BALANCES.deprn_ytd%TYPE;
1552: l_op_acct IGI_IAC_DET_BALANCES.operating_acct_ytd%TYPE;
1553: l_op_acct_ytd IGI_IAC_DET_BALANCES.operating_acct_ytd%TYPE;
1554: l_general_fund_per IGI_IAC_DET_BALANCES.general_fund_per%TYPE;
1555: l_reval_reserve_backlog IGI_IAC_DET_BALANCES.reval_reserve_backlog%TYPE;
1556: l_operating_acct_backlog IGI_IAC_DET_BALANCES.operating_acct_backlog%TYPE;

Line 1553: l_op_acct_ytd IGI_IAC_DET_BALANCES.operating_acct_ytd%TYPE;

1549: l_net_book_value IGI_IAC_DET_BALANCES.net_book_value%TYPE;
1550: l_deprn_per IGI_IAC_DET_BALANCES.deprn_period%TYPE;
1551: l_ytd_deprn IGI_IAC_DET_BALANCES.deprn_ytd%TYPE;
1552: l_op_acct IGI_IAC_DET_BALANCES.operating_acct_ytd%TYPE;
1553: l_op_acct_ytd IGI_IAC_DET_BALANCES.operating_acct_ytd%TYPE;
1554: l_general_fund_per IGI_IAC_DET_BALANCES.general_fund_per%TYPE;
1555: l_reval_reserve_backlog IGI_IAC_DET_BALANCES.reval_reserve_backlog%TYPE;
1556: l_operating_acct_backlog IGI_IAC_DET_BALANCES.operating_acct_backlog%TYPE;
1557: l_reval_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;

Line 1554: l_general_fund_per IGI_IAC_DET_BALANCES.general_fund_per%TYPE;

1550: l_deprn_per IGI_IAC_DET_BALANCES.deprn_period%TYPE;
1551: l_ytd_deprn IGI_IAC_DET_BALANCES.deprn_ytd%TYPE;
1552: l_op_acct IGI_IAC_DET_BALANCES.operating_acct_ytd%TYPE;
1553: l_op_acct_ytd IGI_IAC_DET_BALANCES.operating_acct_ytd%TYPE;
1554: l_general_fund_per IGI_IAC_DET_BALANCES.general_fund_per%TYPE;
1555: l_reval_reserve_backlog IGI_IAC_DET_BALANCES.reval_reserve_backlog%TYPE;
1556: l_operating_acct_backlog IGI_IAC_DET_BALANCES.operating_acct_backlog%TYPE;
1557: l_reval_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1558: l_gen_fund_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;

Line 1555: l_reval_reserve_backlog IGI_IAC_DET_BALANCES.reval_reserve_backlog%TYPE;

1551: l_ytd_deprn IGI_IAC_DET_BALANCES.deprn_ytd%TYPE;
1552: l_op_acct IGI_IAC_DET_BALANCES.operating_acct_ytd%TYPE;
1553: l_op_acct_ytd IGI_IAC_DET_BALANCES.operating_acct_ytd%TYPE;
1554: l_general_fund_per IGI_IAC_DET_BALANCES.general_fund_per%TYPE;
1555: l_reval_reserve_backlog IGI_IAC_DET_BALANCES.reval_reserve_backlog%TYPE;
1556: l_operating_acct_backlog IGI_IAC_DET_BALANCES.operating_acct_backlog%TYPE;
1557: l_reval_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1558: l_gen_fund_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1559: l_backlog_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;

Line 1556: l_operating_acct_backlog IGI_IAC_DET_BALANCES.operating_acct_backlog%TYPE;

1552: l_op_acct IGI_IAC_DET_BALANCES.operating_acct_ytd%TYPE;
1553: l_op_acct_ytd IGI_IAC_DET_BALANCES.operating_acct_ytd%TYPE;
1554: l_general_fund_per IGI_IAC_DET_BALANCES.general_fund_per%TYPE;
1555: l_reval_reserve_backlog IGI_IAC_DET_BALANCES.reval_reserve_backlog%TYPE;
1556: l_operating_acct_backlog IGI_IAC_DET_BALANCES.operating_acct_backlog%TYPE;
1557: l_reval_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1558: l_gen_fund_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1559: l_backlog_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1560: l_deprn_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;

Line 1564: l_Expense_diff IGI_IAC_DET_BALANCES.deprn_period%TYPE;

1560: l_deprn_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1561: l_cost_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1562: l_prior_period_counter IGI_IAC_TRANSACTION_HEADERS.period_counter%TYPE;
1563: l_historic_deprn_expense FA_DEPRN_SUMMARY.deprn_amount%TYPE;
1564: l_Expense_diff IGI_IAC_DET_BALANCES.deprn_period%TYPE;
1565: l_expense_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1566: l_closing_det_balances IGI_IAC_DET_BALANCES%ROWTYPE;
1567: l_adjustment_id IGI_IAC_ADJUSTMENTS.adjustment_id%TYPE;
1568: l_get_all_prev_dist get_all_prev_inactive_dist%ROWTYPE;

Line 1566: l_closing_det_balances IGI_IAC_DET_BALANCES%ROWTYPE;

1562: l_prior_period_counter IGI_IAC_TRANSACTION_HEADERS.period_counter%TYPE;
1563: l_historic_deprn_expense FA_DEPRN_SUMMARY.deprn_amount%TYPE;
1564: l_Expense_diff IGI_IAC_DET_BALANCES.deprn_period%TYPE;
1565: l_expense_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1566: l_closing_det_balances IGI_IAC_DET_BALANCES%ROWTYPE;
1567: l_adjustment_id IGI_IAC_ADJUSTMENTS.adjustment_id%TYPE;
1568: l_get_all_prev_dist get_all_prev_inactive_dist%ROWTYPE;
1569:
1570: l_rowid ROWID;

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

1820: UPDATE igi_iac_transaction_headers
1821: SET category_id = l_asset_cat_rec_new.category_id
1822: WHERE adjustment_id = l_adj_id;
1823:
1824: -- create entries in igi_iac_det_balances for the new dist
1825: insert_data_det(p_adjustment_id =>l_adj_id,
1826: p_asset_id =>l_asset_hdr_rec.asset_id,
1827: p_distribution_id =>l_impacted_dist.distribution_id,
1828: p_period_counter =>l_current_period_counter,

Line 2155: FROM igi_iac_det_balances iadb,fa_distribution_history fdh

2151: CURSOR c_backlog_data(c_current_period_Counter fa_deprn_periods.period_counter%type) IS
2152: SELECT sum(nvl(iadb.reval_reserve_backlog,0)) reval_reserve_backlog,
2153: sum(nvl(iadb.operating_acct_backlog,0)) operating_acct_backlog,
2154: sum(nvl(iadb.general_fund_per,0)) general_fund_per
2155: FROM igi_iac_det_balances iadb,fa_distribution_history fdh
2156: WHERE iadb.book_type_code = l_asset_hdr_rec.book_type_code
2157: AND iadb.period_counter = c_current_period_counter
2158: AND iadb.asset_id=l_asset_hdr_rec.asset_id
2159: AND iadb.asset_id=fdh.asset_id

Line 2175: FROM igi_iac_det_balances

2171: /* get the closing det balances record */
2172: CURSOR c_closing_det_balances( p_old_dist IGI_IAC_ADJUSTMENTS.distribution_id%type,
2173: p_adjustment_id IGI_IAC_ADJUSTMENTS.adjustment_id%type)is
2174: SELECT *
2175: FROM igi_iac_det_balances
2176: WHERE asset_id=l_asset_hdr_rec.asset_id
2177: AND book_type_code = l_asset_hdr_rec.book_type_code
2178: AND distribution_id = p_old_dist
2179: AND adjustment_id = p_adjustment_id;

Line 2185: FROM igi_iac_det_balances

2181: /* Cursor to get incactive distributuiions to be carried forward */
2182: CURSOR get_all_prev_inactive_dist (C_prev_data_adjustment_id Number)
2183: is
2184: SELECT *
2185: FROM igi_iac_det_balances
2186: WHERE asset_id=l_asset_hdr_rec.asset_id
2187: AND book_type_code = l_asset_hdr_rec.book_type_code
2188: AND adjustment_id = C_prev_data_adjustment_id;
2189: -- AND nvl(active_flag,'Y') = 'N';

Line 2222: l_reval_reserve IGI_IAC_DET_BALANCES.reval_reserve_cost%type;

2218: l_start_period_counter FA_DEPRN_PERIODS.period_counter%type;
2219:
2220: l_asset_num FA_ADDITIONS.asset_number%type;
2221: l_units FA_DISTRIBUTION_HISTORY.units_assigned%type;
2222: l_reval_reserve IGI_IAC_DET_BALANCES.reval_reserve_cost%type;
2223: l_general_fund IGI_IAC_DET_BALANCES.general_fund_acc%type;
2224: l_Backlog_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve_backlog%type;
2225: l_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve%type;
2226: l_adjusted_cost IGI_IAC_DET_BALANCES.adjustment_cost%type;

Line 2223: l_general_fund IGI_IAC_DET_BALANCES.general_fund_acc%type;

2219:
2220: l_asset_num FA_ADDITIONS.asset_number%type;
2221: l_units FA_DISTRIBUTION_HISTORY.units_assigned%type;
2222: l_reval_reserve IGI_IAC_DET_BALANCES.reval_reserve_cost%type;
2223: l_general_fund IGI_IAC_DET_BALANCES.general_fund_acc%type;
2224: l_Backlog_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve_backlog%type;
2225: l_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve%type;
2226: l_adjusted_cost IGI_IAC_DET_BALANCES.adjustment_cost%type;
2227: l_net_book_value IGI_IAC_DET_BALANCES.net_book_value%type;

Line 2224: l_Backlog_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve_backlog%type;

2220: l_asset_num FA_ADDITIONS.asset_number%type;
2221: l_units FA_DISTRIBUTION_HISTORY.units_assigned%type;
2222: l_reval_reserve IGI_IAC_DET_BALANCES.reval_reserve_cost%type;
2223: l_general_fund IGI_IAC_DET_BALANCES.general_fund_acc%type;
2224: l_Backlog_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve_backlog%type;
2225: l_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve%type;
2226: l_adjusted_cost IGI_IAC_DET_BALANCES.adjustment_cost%type;
2227: l_net_book_value IGI_IAC_DET_BALANCES.net_book_value%type;
2228: l_deprn_per IGI_IAC_DET_BALANCES.deprn_period%type;

Line 2225: l_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve%type;

2221: l_units FA_DISTRIBUTION_HISTORY.units_assigned%type;
2222: l_reval_reserve IGI_IAC_DET_BALANCES.reval_reserve_cost%type;
2223: l_general_fund IGI_IAC_DET_BALANCES.general_fund_acc%type;
2224: l_Backlog_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve_backlog%type;
2225: l_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve%type;
2226: l_adjusted_cost IGI_IAC_DET_BALANCES.adjustment_cost%type;
2227: l_net_book_value IGI_IAC_DET_BALANCES.net_book_value%type;
2228: l_deprn_per IGI_IAC_DET_BALANCES.deprn_period%type;
2229: l_ytd_deprn IGI_IAC_DET_BALANCES.deprn_ytd%type;

Line 2226: l_adjusted_cost IGI_IAC_DET_BALANCES.adjustment_cost%type;

2222: l_reval_reserve IGI_IAC_DET_BALANCES.reval_reserve_cost%type;
2223: l_general_fund IGI_IAC_DET_BALANCES.general_fund_acc%type;
2224: l_Backlog_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve_backlog%type;
2225: l_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve%type;
2226: l_adjusted_cost IGI_IAC_DET_BALANCES.adjustment_cost%type;
2227: l_net_book_value IGI_IAC_DET_BALANCES.net_book_value%type;
2228: l_deprn_per IGI_IAC_DET_BALANCES.deprn_period%type;
2229: l_ytd_deprn IGI_IAC_DET_BALANCES.deprn_ytd%type;
2230: l_op_acct IGI_IAC_DET_BALANCES.operating_acct_ytd%type;

Line 2227: l_net_book_value IGI_IAC_DET_BALANCES.net_book_value%type;

2223: l_general_fund IGI_IAC_DET_BALANCES.general_fund_acc%type;
2224: l_Backlog_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve_backlog%type;
2225: l_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve%type;
2226: l_adjusted_cost IGI_IAC_DET_BALANCES.adjustment_cost%type;
2227: l_net_book_value IGI_IAC_DET_BALANCES.net_book_value%type;
2228: l_deprn_per IGI_IAC_DET_BALANCES.deprn_period%type;
2229: l_ytd_deprn IGI_IAC_DET_BALANCES.deprn_ytd%type;
2230: l_op_acct IGI_IAC_DET_BALANCES.operating_acct_ytd%type;
2231: l_op_acct_ytd IGI_IAC_DET_BALANCES.operating_acct_ytd%type;

Line 2228: l_deprn_per IGI_IAC_DET_BALANCES.deprn_period%type;

2224: l_Backlog_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve_backlog%type;
2225: l_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve%type;
2226: l_adjusted_cost IGI_IAC_DET_BALANCES.adjustment_cost%type;
2227: l_net_book_value IGI_IAC_DET_BALANCES.net_book_value%type;
2228: l_deprn_per IGI_IAC_DET_BALANCES.deprn_period%type;
2229: l_ytd_deprn IGI_IAC_DET_BALANCES.deprn_ytd%type;
2230: l_op_acct IGI_IAC_DET_BALANCES.operating_acct_ytd%type;
2231: l_op_acct_ytd IGI_IAC_DET_BALANCES.operating_acct_ytd%type;
2232: l_general_fund_per IGI_IAC_DET_BALANCES.general_fund_per%type;

Line 2229: l_ytd_deprn IGI_IAC_DET_BALANCES.deprn_ytd%type;

2225: l_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve%type;
2226: l_adjusted_cost IGI_IAC_DET_BALANCES.adjustment_cost%type;
2227: l_net_book_value IGI_IAC_DET_BALANCES.net_book_value%type;
2228: l_deprn_per IGI_IAC_DET_BALANCES.deprn_period%type;
2229: l_ytd_deprn IGI_IAC_DET_BALANCES.deprn_ytd%type;
2230: l_op_acct IGI_IAC_DET_BALANCES.operating_acct_ytd%type;
2231: l_op_acct_ytd IGI_IAC_DET_BALANCES.operating_acct_ytd%type;
2232: l_general_fund_per IGI_IAC_DET_BALANCES.general_fund_per%type;
2233: l_reval_reserve_backlog IGI_IAC_DET_BALANCES.reval_reserve_backlog%type;

Line 2230: l_op_acct IGI_IAC_DET_BALANCES.operating_acct_ytd%type;

2226: l_adjusted_cost IGI_IAC_DET_BALANCES.adjustment_cost%type;
2227: l_net_book_value IGI_IAC_DET_BALANCES.net_book_value%type;
2228: l_deprn_per IGI_IAC_DET_BALANCES.deprn_period%type;
2229: l_ytd_deprn IGI_IAC_DET_BALANCES.deprn_ytd%type;
2230: l_op_acct IGI_IAC_DET_BALANCES.operating_acct_ytd%type;
2231: l_op_acct_ytd IGI_IAC_DET_BALANCES.operating_acct_ytd%type;
2232: l_general_fund_per IGI_IAC_DET_BALANCES.general_fund_per%type;
2233: l_reval_reserve_backlog IGI_IAC_DET_BALANCES.reval_reserve_backlog%type;
2234: l_operating_acct_backlog IGI_IAC_DET_BALANCES.operating_acct_backlog%type;

Line 2231: l_op_acct_ytd IGI_IAC_DET_BALANCES.operating_acct_ytd%type;

2227: l_net_book_value IGI_IAC_DET_BALANCES.net_book_value%type;
2228: l_deprn_per IGI_IAC_DET_BALANCES.deprn_period%type;
2229: l_ytd_deprn IGI_IAC_DET_BALANCES.deprn_ytd%type;
2230: l_op_acct IGI_IAC_DET_BALANCES.operating_acct_ytd%type;
2231: l_op_acct_ytd IGI_IAC_DET_BALANCES.operating_acct_ytd%type;
2232: l_general_fund_per IGI_IAC_DET_BALANCES.general_fund_per%type;
2233: l_reval_reserve_backlog IGI_IAC_DET_BALANCES.reval_reserve_backlog%type;
2234: l_operating_acct_backlog IGI_IAC_DET_BALANCES.operating_acct_backlog%type;
2235: l_reval_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;

Line 2232: l_general_fund_per IGI_IAC_DET_BALANCES.general_fund_per%type;

2228: l_deprn_per IGI_IAC_DET_BALANCES.deprn_period%type;
2229: l_ytd_deprn IGI_IAC_DET_BALANCES.deprn_ytd%type;
2230: l_op_acct IGI_IAC_DET_BALANCES.operating_acct_ytd%type;
2231: l_op_acct_ytd IGI_IAC_DET_BALANCES.operating_acct_ytd%type;
2232: l_general_fund_per IGI_IAC_DET_BALANCES.general_fund_per%type;
2233: l_reval_reserve_backlog IGI_IAC_DET_BALANCES.reval_reserve_backlog%type;
2234: l_operating_acct_backlog IGI_IAC_DET_BALANCES.operating_acct_backlog%type;
2235: l_reval_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2236: l_gen_fund_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;

Line 2233: l_reval_reserve_backlog IGI_IAC_DET_BALANCES.reval_reserve_backlog%type;

2229: l_ytd_deprn IGI_IAC_DET_BALANCES.deprn_ytd%type;
2230: l_op_acct IGI_IAC_DET_BALANCES.operating_acct_ytd%type;
2231: l_op_acct_ytd IGI_IAC_DET_BALANCES.operating_acct_ytd%type;
2232: l_general_fund_per IGI_IAC_DET_BALANCES.general_fund_per%type;
2233: l_reval_reserve_backlog IGI_IAC_DET_BALANCES.reval_reserve_backlog%type;
2234: l_operating_acct_backlog IGI_IAC_DET_BALANCES.operating_acct_backlog%type;
2235: l_reval_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2236: l_gen_fund_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2237: l_backlog_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;

Line 2234: l_operating_acct_backlog IGI_IAC_DET_BALANCES.operating_acct_backlog%type;

2230: l_op_acct IGI_IAC_DET_BALANCES.operating_acct_ytd%type;
2231: l_op_acct_ytd IGI_IAC_DET_BALANCES.operating_acct_ytd%type;
2232: l_general_fund_per IGI_IAC_DET_BALANCES.general_fund_per%type;
2233: l_reval_reserve_backlog IGI_IAC_DET_BALANCES.reval_reserve_backlog%type;
2234: l_operating_acct_backlog IGI_IAC_DET_BALANCES.operating_acct_backlog%type;
2235: l_reval_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2236: l_gen_fund_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2237: l_backlog_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2238: l_deprn_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;

Line 2242: l_Expense_diff IGI_IAC_DET_BALANCES.deprn_period%type;

2238: l_deprn_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2239: l_cost_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2240: l_prior_period_counter IGI_IAC_TRANSACTION_HEADERS.period_counter%type;
2241: l_historic_deprn_expense FA_DEPRN_SUMMARY.deprn_amount%type;
2242: l_Expense_diff IGI_IAC_DET_BALANCES.deprn_period%type;
2243: l_expense_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2244: l_closing_det_balances IGI_IAC_DET_BALANCES%ROWTYPE;
2245: l_adjustment_id IGI_IAC_ADJUSTMENTS.adjustment_id%type;
2246: l_get_all_prev_dist get_all_prev_inactive_dist%ROWTYPE;

Line 2244: l_closing_det_balances IGI_IAC_DET_BALANCES%ROWTYPE;

2240: l_prior_period_counter IGI_IAC_TRANSACTION_HEADERS.period_counter%type;
2241: l_historic_deprn_expense FA_DEPRN_SUMMARY.deprn_amount%type;
2242: l_Expense_diff IGI_IAC_DET_BALANCES.deprn_period%type;
2243: l_expense_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2244: l_closing_det_balances IGI_IAC_DET_BALANCES%ROWTYPE;
2245: l_adjustment_id IGI_IAC_ADJUSTMENTS.adjustment_id%type;
2246: l_get_all_prev_dist get_all_prev_inactive_dist%ROWTYPE;
2247:
2248: l_rowid rowid;