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_RETIREMENT dependencies on IGI_IAC_COMMON_UTILS

Line 362: IF NOT (igi_iac_common_utils.get_latest_transaction(P_Book_Type_Code,

358:
359: debug(g_state_level,l_path_name,'Asset ID '||P_Asset_Id);
360: -- get the latest tranaction for the asset id
361:
362: IF NOT (igi_iac_common_utils.get_latest_transaction(P_Book_Type_Code,
363: P_Asset_Id,
364: l_Transaction_Type_Code,
365: l_Transaction_Id,
366: l_Mass_Reference_ID ,

Line 567: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.adjustment_cost,P_Book_Type_Code) ;

563: l_fa_unround_deprn_prd := l_fa_retire_deprn_prd;
564: l_fa_unround_deprn_ytd := l_fa_retire_deprn_ytd;
565:
566:
567: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.adjustment_cost,P_Book_Type_Code) ;
568: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_cost,P_Book_Type_Code) ;
569: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_reserve,P_Book_Type_Code) ;
570: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_reserve_backlog,P_Book_Type_Code) ;
571: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_net,P_Book_Type_Code) ;

Line 568: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_cost,P_Book_Type_Code) ;

564: l_fa_unround_deprn_ytd := l_fa_retire_deprn_ytd;
565:
566:
567: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.adjustment_cost,P_Book_Type_Code) ;
568: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_cost,P_Book_Type_Code) ;
569: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_reserve,P_Book_Type_Code) ;
570: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_reserve_backlog,P_Book_Type_Code) ;
571: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_net,P_Book_Type_Code) ;
572: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_period,P_Book_Type_Code) ;

Line 569: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_reserve,P_Book_Type_Code) ;

565:
566:
567: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.adjustment_cost,P_Book_Type_Code) ;
568: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_cost,P_Book_Type_Code) ;
569: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_reserve,P_Book_Type_Code) ;
570: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_reserve_backlog,P_Book_Type_Code) ;
571: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_net,P_Book_Type_Code) ;
572: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_period,P_Book_Type_Code) ;
573: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.general_fund_acc,P_Book_Type_Code) ;

Line 570: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_reserve_backlog,P_Book_Type_Code) ;

566:
567: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.adjustment_cost,P_Book_Type_Code) ;
568: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_cost,P_Book_Type_Code) ;
569: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_reserve,P_Book_Type_Code) ;
570: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_reserve_backlog,P_Book_Type_Code) ;
571: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_net,P_Book_Type_Code) ;
572: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_period,P_Book_Type_Code) ;
573: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.general_fund_acc,P_Book_Type_Code) ;
574: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.general_fund_per,P_Book_Type_Code) ;

Line 571: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_net,P_Book_Type_Code) ;

567: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.adjustment_cost,P_Book_Type_Code) ;
568: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_cost,P_Book_Type_Code) ;
569: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_reserve,P_Book_Type_Code) ;
570: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_reserve_backlog,P_Book_Type_Code) ;
571: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_net,P_Book_Type_Code) ;
572: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_period,P_Book_Type_Code) ;
573: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.general_fund_acc,P_Book_Type_Code) ;
574: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.general_fund_per,P_Book_Type_Code) ;
575: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_gen_fund,P_Book_Type_Code) ;

Line 572: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_period,P_Book_Type_Code) ;

568: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_cost,P_Book_Type_Code) ;
569: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_reserve,P_Book_Type_Code) ;
570: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_reserve_backlog,P_Book_Type_Code) ;
571: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_net,P_Book_Type_Code) ;
572: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_period,P_Book_Type_Code) ;
573: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.general_fund_acc,P_Book_Type_Code) ;
574: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.general_fund_per,P_Book_Type_Code) ;
575: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_gen_fund,P_Book_Type_Code) ;
576: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_backlog,P_Book_Type_Code) ;

Line 573: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.general_fund_acc,P_Book_Type_Code) ;

569: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_reserve,P_Book_Type_Code) ;
570: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_reserve_backlog,P_Book_Type_Code) ;
571: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_net,P_Book_Type_Code) ;
572: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_period,P_Book_Type_Code) ;
573: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.general_fund_acc,P_Book_Type_Code) ;
574: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.general_fund_per,P_Book_Type_Code) ;
575: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_gen_fund,P_Book_Type_Code) ;
576: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_backlog,P_Book_Type_Code) ;
577: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_cost,P_Book_Type_Code) ;

Line 574: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.general_fund_per,P_Book_Type_Code) ;

570: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_reserve_backlog,P_Book_Type_Code) ;
571: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_net,P_Book_Type_Code) ;
572: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_period,P_Book_Type_Code) ;
573: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.general_fund_acc,P_Book_Type_Code) ;
574: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.general_fund_per,P_Book_Type_Code) ;
575: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_gen_fund,P_Book_Type_Code) ;
576: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_backlog,P_Book_Type_Code) ;
577: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_cost,P_Book_Type_Code) ;
578: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_net,P_Book_Type_Code) ;

Line 575: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_gen_fund,P_Book_Type_Code) ;

571: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_net,P_Book_Type_Code) ;
572: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_period,P_Book_Type_Code) ;
573: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.general_fund_acc,P_Book_Type_Code) ;
574: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.general_fund_per,P_Book_Type_Code) ;
575: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_gen_fund,P_Book_Type_Code) ;
576: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_backlog,P_Book_Type_Code) ;
577: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_cost,P_Book_Type_Code) ;
578: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_net,P_Book_Type_Code) ;
579: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_backlog,P_Book_Type_Code) ;

Line 576: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_backlog,P_Book_Type_Code) ;

572: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_period,P_Book_Type_Code) ;
573: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.general_fund_acc,P_Book_Type_Code) ;
574: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.general_fund_per,P_Book_Type_Code) ;
575: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_gen_fund,P_Book_Type_Code) ;
576: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_backlog,P_Book_Type_Code) ;
577: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_cost,P_Book_Type_Code) ;
578: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_net,P_Book_Type_Code) ;
579: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_backlog,P_Book_Type_Code) ;
580: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_ytd,P_Book_Type_Code) ;

Line 577: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_cost,P_Book_Type_Code) ;

573: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.general_fund_acc,P_Book_Type_Code) ;
574: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.general_fund_per,P_Book_Type_Code) ;
575: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_gen_fund,P_Book_Type_Code) ;
576: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_backlog,P_Book_Type_Code) ;
577: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_cost,P_Book_Type_Code) ;
578: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_net,P_Book_Type_Code) ;
579: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_backlog,P_Book_Type_Code) ;
580: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_ytd,P_Book_Type_Code) ;
581:

Line 578: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_net,P_Book_Type_Code) ;

574: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.general_fund_per,P_Book_Type_Code) ;
575: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_gen_fund,P_Book_Type_Code) ;
576: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_backlog,P_Book_Type_Code) ;
577: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_cost,P_Book_Type_Code) ;
578: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_net,P_Book_Type_Code) ;
579: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_backlog,P_Book_Type_Code) ;
580: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_ytd,P_Book_Type_Code) ;
581:
582: l_ret:= igi_iac_common_utils.iac_round(l_fa_retire_acc_deprn,P_Book_Type_Code) ;

Line 579: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_backlog,P_Book_Type_Code) ;

575: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_gen_fund,P_Book_Type_Code) ;
576: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_backlog,P_Book_Type_Code) ;
577: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_cost,P_Book_Type_Code) ;
578: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_net,P_Book_Type_Code) ;
579: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_backlog,P_Book_Type_Code) ;
580: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_ytd,P_Book_Type_Code) ;
581:
582: l_ret:= igi_iac_common_utils.iac_round(l_fa_retire_acc_deprn,P_Book_Type_Code) ;
583: l_ret:= igi_iac_common_utils.iac_round(l_fa_retire_deprn_prd,P_Book_Type_Code) ;

Line 580: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_ytd,P_Book_Type_Code) ;

576: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_backlog,P_Book_Type_Code) ;
577: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_cost,P_Book_Type_Code) ;
578: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_net,P_Book_Type_Code) ;
579: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_backlog,P_Book_Type_Code) ;
580: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_ytd,P_Book_Type_Code) ;
581:
582: l_ret:= igi_iac_common_utils.iac_round(l_fa_retire_acc_deprn,P_Book_Type_Code) ;
583: l_ret:= igi_iac_common_utils.iac_round(l_fa_retire_deprn_prd,P_Book_Type_Code) ;
584: l_ret:= igi_iac_common_utils.iac_round(l_fa_retire_deprn_ytd,P_Book_Type_Code) ;

Line 582: l_ret:= igi_iac_common_utils.iac_round(l_fa_retire_acc_deprn,P_Book_Type_Code) ;

578: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_net,P_Book_Type_Code) ;
579: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_backlog,P_Book_Type_Code) ;
580: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_ytd,P_Book_Type_Code) ;
581:
582: l_ret:= igi_iac_common_utils.iac_round(l_fa_retire_acc_deprn,P_Book_Type_Code) ;
583: l_ret:= igi_iac_common_utils.iac_round(l_fa_retire_deprn_prd,P_Book_Type_Code) ;
584: l_ret:= igi_iac_common_utils.iac_round(l_fa_retire_deprn_ytd,P_Book_Type_Code) ;
585:
586: l_detail_balances_rnd_tot.adjustment_cost:= l_detail_balances_rnd_tot.adjustment_cost;

Line 583: l_ret:= igi_iac_common_utils.iac_round(l_fa_retire_deprn_prd,P_Book_Type_Code) ;

579: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_backlog,P_Book_Type_Code) ;
580: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_ytd,P_Book_Type_Code) ;
581:
582: l_ret:= igi_iac_common_utils.iac_round(l_fa_retire_acc_deprn,P_Book_Type_Code) ;
583: l_ret:= igi_iac_common_utils.iac_round(l_fa_retire_deprn_prd,P_Book_Type_Code) ;
584: l_ret:= igi_iac_common_utils.iac_round(l_fa_retire_deprn_ytd,P_Book_Type_Code) ;
585:
586: l_detail_balances_rnd_tot.adjustment_cost:= l_detail_balances_rnd_tot.adjustment_cost;
587:

Line 584: l_ret:= igi_iac_common_utils.iac_round(l_fa_retire_deprn_ytd,P_Book_Type_Code) ;

580: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_ytd,P_Book_Type_Code) ;
581:
582: l_ret:= igi_iac_common_utils.iac_round(l_fa_retire_acc_deprn,P_Book_Type_Code) ;
583: l_ret:= igi_iac_common_utils.iac_round(l_fa_retire_deprn_prd,P_Book_Type_Code) ;
584: l_ret:= igi_iac_common_utils.iac_round(l_fa_retire_deprn_ytd,P_Book_Type_Code) ;
585:
586: l_detail_balances_rnd_tot.adjustment_cost:= l_detail_balances_rnd_tot.adjustment_cost;
587:
588: l_detail_balances_rnd_tot.adjustment_cost := l_detail_balances_rnd_tot.adjustment_cost +

Line 688: IF NOT (igi_iac_common_utils.get_account_ccid(P_Book_Type_Code,P_Asset_Id,l_detail_balances.distribution_id,

684:
685:
686:
687: /* Create adjustment to reverse out NOCOPY old balances */
688: IF NOT (igi_iac_common_utils.get_account_ccid(P_Book_Type_Code,P_Asset_Id,l_detail_balances.distribution_id,
689: 'ASSET_COST_ACCT',g_retire_rec.detail_info.transaction_header_id_in,
690: 'RETIREMENT',l_cost_account_ccid
691: )) THEN
692: RAISE e_no_account_ccid ;

Line 700: IF NOT (igi_iac_common_utils.get_account_ccid(P_Book_Type_Code,P_Asset_Id,l_detail_balances.distribution_id,

696: l_rowid := NULL ;
697: debug( g_state_level, l_path_name,'done cost adjustment');
698: debug( g_state_level, l_path_name,'dist id: '||l_detail_balances.distribution_id);
699: l_acc_deprn_account_ccid := NULL;
700: IF NOT (igi_iac_common_utils.get_account_ccid(P_Book_Type_Code,P_Asset_Id,l_detail_balances.distribution_id,
701: 'DEPRN_RESERVE_ACCT',g_retire_rec.detail_info.transaction_header_id_in,
702: 'RETIREMENT',l_acc_deprn_account_ccid
703: )) THEN
704: RAISE e_no_account_ccid ;

Line 709: IF NOT (igi_iac_common_utils.get_account_ccid(P_Book_Type_Code,P_Asset_Id,l_detail_balances.distribution_id,

705: END IF ;
706: debug( g_state_level,l_path_name,'done deprn rsv ccid');
707: debug( g_state_level,l_path_name, '*' ||l_acc_deprn_account_ccid || '*');
708:
709: IF NOT (igi_iac_common_utils.get_account_ccid(P_Book_Type_Code,P_Asset_Id,l_detail_balances.distribution_id,
710: 'REVAL_RESERVE_ACCT',g_retire_rec.detail_info.transaction_header_id_in,
711: 'RETIREMENT',l_reval_rsv_account_ccid
712: )) THEN
713: RAISE e_no_account_ccid ;

Line 716: IF NOT (igi_iac_common_utils.get_account_ccid(P_Book_Type_Code,P_Asset_Id,l_detail_balances.distribution_id,

712: )) THEN
713: RAISE e_no_account_ccid ;
714: END IF ;
715: debug( g_state_level,l_path_name,'done reval rsv ccid');
716: IF NOT (igi_iac_common_utils.get_account_ccid(P_Book_Type_Code,P_Asset_Id,l_detail_balances.distribution_id,
717: 'BACKLOG_DEPRN_RSV_ACCT',g_retire_rec.detail_info.transaction_header_id_in,
718: 'RETIREMENT',l_backlog_account_ccid
719: )) THEN
720: RAISE e_no_account_ccid ;

Line 729: IF NOT (igi_iac_common_utils.get_account_ccid(P_Book_Type_Code,P_Asset_Id,l_detail_balances.distribution_id,

725:
726: IF ((l_detail_balances_retire.adjustment_cost-l_detail_balances_retire.deprn_reserve)<> 0) OR
727: (l_detail_balances_retire.deprn_reserve_backlog <> 0) THEN
728:
729: IF NOT (igi_iac_common_utils.get_account_ccid(P_Book_Type_Code,P_Asset_Id,l_detail_balances.distribution_id,
730: 'NBV_RETIRED_GAIN_ACCT',g_retire_rec.detail_info.transaction_header_id_in,
731: 'RETIREMENT',l_nbv_retired_account_ccid
732: )) THEN
733: RAISE e_no_account_ccid ;

Line 790: IF NOT (igi_iac_common_utils.get_account_ccid(P_Book_Type_Code,P_Asset_Id,l_detail_balances.distribution_id,

786: END IF;
787:
788: IF l_detail_balances_retire.reval_reserve_net <> 0 THEN
789:
790: IF NOT (igi_iac_common_utils.get_account_ccid(P_Book_Type_Code,P_Asset_Id,l_detail_balances.distribution_id,
791: 'REVAL_RESERVE_RETIRED_ACCT',g_retire_rec.detail_info.transaction_header_id_in,
792: 'RETIREMENT',l_reval_rsv_ret_acct_ccid
793: )) THEN
794: RAISE e_no_account_ccid ;

Line 872: IF NOT (igi_iac_common_utils.get_account_ccid(P_Book_Type_Code,P_Asset_Id,l_detail_balances.distribution_id,

868: END IF;
869:
870: IF l_detail_balances_retire.operating_acct_backlog <> 0 THEN
871:
872: IF NOT (igi_iac_common_utils.get_account_ccid(P_Book_Type_Code,P_Asset_Id,l_detail_balances.distribution_id,
873: 'OPERATING_EXPENSE_ACCT',g_retire_rec.detail_info.transaction_header_id_in,
874: 'RETIREMENT',l_op_exp_ccid
875: )) THEN
876: RAISE e_no_account_ccid ;

Line 1074: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances.deprn_ytd,P_Book_Type_Code);

1070: l_fa_deprn_ytd := 0;
1071: ELSE
1072: l_detail_balances.deprn_ytd:= l_detail_balances.deprn_ytd * p_retirement_factor;
1073: l_fa_deprn_ytd := l_fa_deprn_ytd *p_retirement_factor;
1074: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances.deprn_ytd,P_Book_Type_Code);
1075: l_ret:= igi_iac_common_utils.iac_round(l_fa_deprn_ytd,P_Book_Type_Code);
1076: END IF;
1077:
1078: igi_iac_det_balances_pkg.insert_row(

Line 1075: l_ret:= igi_iac_common_utils.iac_round(l_fa_deprn_ytd,P_Book_Type_Code);

1071: ELSE
1072: l_detail_balances.deprn_ytd:= l_detail_balances.deprn_ytd * p_retirement_factor;
1073: l_fa_deprn_ytd := l_fa_deprn_ytd *p_retirement_factor;
1074: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances.deprn_ytd,P_Book_Type_Code);
1075: l_ret:= igi_iac_common_utils.iac_round(l_fa_deprn_ytd,P_Book_Type_Code);
1076: END IF;
1077:
1078: igi_iac_det_balances_pkg.insert_row(
1079: X_rowid => l_rowid ,

Line 1321: IF NOT (igi_iac_common_utils.get_latest_transaction(P_Book_Type_Code,

1317:
1318: debug(g_state_level,l_path_name,'Asset ID '||P_Asset_Id);
1319: -- get the latest tranaction for the asset id
1320:
1321: IF NOT (igi_iac_common_utils.get_latest_transaction(P_Book_Type_Code,
1322: P_Asset_Id,
1323: l_Transaction_Type_Code,
1324: l_Transaction_Id,
1325: l_Mass_Reference_ID ,

Line 1420: l_ret:= igi_iac_common_utils.iac_round(l_retire_amount,P_Book_Type_Code) ;

1416: p_current_period,
1417: l_detail_balances.distribution_id ) LOOP
1418:
1419: l_retire_amount := l_all_occ_reval.amount * P_retirement_factor;
1420: l_ret:= igi_iac_common_utils.iac_round(l_retire_amount,P_Book_Type_Code) ;
1421: l_rowid := NULL ;
1422: igi_iac_adjustments_pkg.insert_row(
1423: X_rowid => l_rowid ,
1424: X_adjustment_id => l_retirement_adjustment_id ,

Line 1714: l_ret:= igi_iac_common_utils.iac_round(l_retire_amount,P_Book_Type_Code) ;

1710: p_current_period,
1711: l_detail_balances.distribution_id ) LOOP
1712:
1713: l_retire_amount := l_all_prd_reval.amount * P_retirement_factor;
1714: l_ret:= igi_iac_common_utils.iac_round(l_retire_amount,P_Book_Type_Code) ;
1715: l_rowid := NULL ;
1716: igi_iac_adjustments_pkg.insert_row(
1717: X_rowid => l_rowid ,
1718: X_adjustment_id => l_retirement_adjustment_id ,

Line 2042: IF NOT (igi_iac_common_utils.get_latest_transaction(P_Book_Type_Code,

2038:
2039: debug(g_state_level,l_path_name,'Asset ID '||P_Asset_Id);
2040: -- get the latest tranaction for the asset id
2041:
2042: IF NOT (igi_iac_common_utils.get_latest_transaction(P_Book_Type_Code,
2043: P_Asset_Id,
2044: l_Transaction_Type_Code,
2045: l_Transaction_Id,
2046: l_Mass_Reference_ID ,

Line 2274: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.adjustment_cost,P_Book_Type_Code) ;

2270: l_fa_unround_deprn_prd := l_fa_retire_deprn_prd;
2271: l_fa_unround_deprn_ytd := l_fa_retire_deprn_ytd;
2272:
2273:
2274: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.adjustment_cost,P_Book_Type_Code) ;
2275: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_cost,P_Book_Type_Code) ;
2276: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_reserve,P_Book_Type_Code) ;
2277: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_reserve_backlog,P_Book_Type_Code) ;
2278: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_net,P_Book_Type_Code) ;

Line 2275: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_cost,P_Book_Type_Code) ;

2271: l_fa_unround_deprn_ytd := l_fa_retire_deprn_ytd;
2272:
2273:
2274: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.adjustment_cost,P_Book_Type_Code) ;
2275: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_cost,P_Book_Type_Code) ;
2276: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_reserve,P_Book_Type_Code) ;
2277: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_reserve_backlog,P_Book_Type_Code) ;
2278: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_net,P_Book_Type_Code) ;
2279: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_period,P_Book_Type_Code) ;

Line 2276: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_reserve,P_Book_Type_Code) ;

2272:
2273:
2274: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.adjustment_cost,P_Book_Type_Code) ;
2275: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_cost,P_Book_Type_Code) ;
2276: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_reserve,P_Book_Type_Code) ;
2277: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_reserve_backlog,P_Book_Type_Code) ;
2278: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_net,P_Book_Type_Code) ;
2279: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_period,P_Book_Type_Code) ;
2280: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.general_fund_acc,P_Book_Type_Code) ;

Line 2277: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_reserve_backlog,P_Book_Type_Code) ;

2273:
2274: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.adjustment_cost,P_Book_Type_Code) ;
2275: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_cost,P_Book_Type_Code) ;
2276: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_reserve,P_Book_Type_Code) ;
2277: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_reserve_backlog,P_Book_Type_Code) ;
2278: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_net,P_Book_Type_Code) ;
2279: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_period,P_Book_Type_Code) ;
2280: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.general_fund_acc,P_Book_Type_Code) ;
2281: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.general_fund_per,P_Book_Type_Code) ;

Line 2278: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_net,P_Book_Type_Code) ;

2274: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.adjustment_cost,P_Book_Type_Code) ;
2275: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_cost,P_Book_Type_Code) ;
2276: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_reserve,P_Book_Type_Code) ;
2277: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_reserve_backlog,P_Book_Type_Code) ;
2278: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_net,P_Book_Type_Code) ;
2279: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_period,P_Book_Type_Code) ;
2280: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.general_fund_acc,P_Book_Type_Code) ;
2281: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.general_fund_per,P_Book_Type_Code) ;
2282: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_gen_fund,P_Book_Type_Code) ;

Line 2279: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_period,P_Book_Type_Code) ;

2275: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_cost,P_Book_Type_Code) ;
2276: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_reserve,P_Book_Type_Code) ;
2277: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_reserve_backlog,P_Book_Type_Code) ;
2278: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_net,P_Book_Type_Code) ;
2279: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_period,P_Book_Type_Code) ;
2280: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.general_fund_acc,P_Book_Type_Code) ;
2281: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.general_fund_per,P_Book_Type_Code) ;
2282: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_gen_fund,P_Book_Type_Code) ;
2283: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_backlog,P_Book_Type_Code) ;

Line 2280: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.general_fund_acc,P_Book_Type_Code) ;

2276: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_reserve,P_Book_Type_Code) ;
2277: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_reserve_backlog,P_Book_Type_Code) ;
2278: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_net,P_Book_Type_Code) ;
2279: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_period,P_Book_Type_Code) ;
2280: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.general_fund_acc,P_Book_Type_Code) ;
2281: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.general_fund_per,P_Book_Type_Code) ;
2282: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_gen_fund,P_Book_Type_Code) ;
2283: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_backlog,P_Book_Type_Code) ;
2284: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_cost,P_Book_Type_Code) ;

Line 2281: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.general_fund_per,P_Book_Type_Code) ;

2277: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_reserve_backlog,P_Book_Type_Code) ;
2278: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_net,P_Book_Type_Code) ;
2279: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_period,P_Book_Type_Code) ;
2280: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.general_fund_acc,P_Book_Type_Code) ;
2281: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.general_fund_per,P_Book_Type_Code) ;
2282: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_gen_fund,P_Book_Type_Code) ;
2283: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_backlog,P_Book_Type_Code) ;
2284: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_cost,P_Book_Type_Code) ;
2285: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_net,P_Book_Type_Code) ;

Line 2282: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_gen_fund,P_Book_Type_Code) ;

2278: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_net,P_Book_Type_Code) ;
2279: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_period,P_Book_Type_Code) ;
2280: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.general_fund_acc,P_Book_Type_Code) ;
2281: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.general_fund_per,P_Book_Type_Code) ;
2282: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_gen_fund,P_Book_Type_Code) ;
2283: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_backlog,P_Book_Type_Code) ;
2284: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_cost,P_Book_Type_Code) ;
2285: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_net,P_Book_Type_Code) ;
2286: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_backlog,P_Book_Type_Code) ;

Line 2283: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_backlog,P_Book_Type_Code) ;

2279: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_period,P_Book_Type_Code) ;
2280: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.general_fund_acc,P_Book_Type_Code) ;
2281: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.general_fund_per,P_Book_Type_Code) ;
2282: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_gen_fund,P_Book_Type_Code) ;
2283: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_backlog,P_Book_Type_Code) ;
2284: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_cost,P_Book_Type_Code) ;
2285: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_net,P_Book_Type_Code) ;
2286: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_backlog,P_Book_Type_Code) ;
2287: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_ytd,P_Book_Type_Code) ;

Line 2284: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_cost,P_Book_Type_Code) ;

2280: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.general_fund_acc,P_Book_Type_Code) ;
2281: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.general_fund_per,P_Book_Type_Code) ;
2282: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_gen_fund,P_Book_Type_Code) ;
2283: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_backlog,P_Book_Type_Code) ;
2284: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_cost,P_Book_Type_Code) ;
2285: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_net,P_Book_Type_Code) ;
2286: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_backlog,P_Book_Type_Code) ;
2287: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_ytd,P_Book_Type_Code) ;
2288:

Line 2285: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_net,P_Book_Type_Code) ;

2281: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.general_fund_per,P_Book_Type_Code) ;
2282: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_gen_fund,P_Book_Type_Code) ;
2283: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_backlog,P_Book_Type_Code) ;
2284: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_cost,P_Book_Type_Code) ;
2285: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_net,P_Book_Type_Code) ;
2286: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_backlog,P_Book_Type_Code) ;
2287: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_ytd,P_Book_Type_Code) ;
2288:
2289: l_ret:= igi_iac_common_utils.iac_round(l_fa_retire_acc_deprn,P_Book_Type_Code) ;

Line 2286: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_backlog,P_Book_Type_Code) ;

2282: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_gen_fund,P_Book_Type_Code) ;
2283: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_backlog,P_Book_Type_Code) ;
2284: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_cost,P_Book_Type_Code) ;
2285: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_net,P_Book_Type_Code) ;
2286: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_backlog,P_Book_Type_Code) ;
2287: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_ytd,P_Book_Type_Code) ;
2288:
2289: l_ret:= igi_iac_common_utils.iac_round(l_fa_retire_acc_deprn,P_Book_Type_Code) ;
2290: l_ret:= igi_iac_common_utils.iac_round(l_fa_retire_deprn_prd,P_Book_Type_Code) ;

Line 2287: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_ytd,P_Book_Type_Code) ;

2283: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_backlog,P_Book_Type_Code) ;
2284: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_cost,P_Book_Type_Code) ;
2285: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_net,P_Book_Type_Code) ;
2286: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_backlog,P_Book_Type_Code) ;
2287: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_ytd,P_Book_Type_Code) ;
2288:
2289: l_ret:= igi_iac_common_utils.iac_round(l_fa_retire_acc_deprn,P_Book_Type_Code) ;
2290: l_ret:= igi_iac_common_utils.iac_round(l_fa_retire_deprn_prd,P_Book_Type_Code) ;
2291: l_ret:= igi_iac_common_utils.iac_round(l_fa_retire_deprn_ytd,P_Book_Type_Code) ;

Line 2289: l_ret:= igi_iac_common_utils.iac_round(l_fa_retire_acc_deprn,P_Book_Type_Code) ;

2285: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.operating_acct_net,P_Book_Type_Code) ;
2286: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_backlog,P_Book_Type_Code) ;
2287: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_ytd,P_Book_Type_Code) ;
2288:
2289: l_ret:= igi_iac_common_utils.iac_round(l_fa_retire_acc_deprn,P_Book_Type_Code) ;
2290: l_ret:= igi_iac_common_utils.iac_round(l_fa_retire_deprn_prd,P_Book_Type_Code) ;
2291: l_ret:= igi_iac_common_utils.iac_round(l_fa_retire_deprn_ytd,P_Book_Type_Code) ;
2292:
2293: l_detail_balances_rnd_tot.adjustment_cost:= l_detail_balances_rnd_tot.adjustment_cost;

Line 2290: l_ret:= igi_iac_common_utils.iac_round(l_fa_retire_deprn_prd,P_Book_Type_Code) ;

2286: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.reval_reserve_backlog,P_Book_Type_Code) ;
2287: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_ytd,P_Book_Type_Code) ;
2288:
2289: l_ret:= igi_iac_common_utils.iac_round(l_fa_retire_acc_deprn,P_Book_Type_Code) ;
2290: l_ret:= igi_iac_common_utils.iac_round(l_fa_retire_deprn_prd,P_Book_Type_Code) ;
2291: l_ret:= igi_iac_common_utils.iac_round(l_fa_retire_deprn_ytd,P_Book_Type_Code) ;
2292:
2293: l_detail_balances_rnd_tot.adjustment_cost:= l_detail_balances_rnd_tot.adjustment_cost;
2294:

Line 2291: l_ret:= igi_iac_common_utils.iac_round(l_fa_retire_deprn_ytd,P_Book_Type_Code) ;

2287: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances_retire.deprn_ytd,P_Book_Type_Code) ;
2288:
2289: l_ret:= igi_iac_common_utils.iac_round(l_fa_retire_acc_deprn,P_Book_Type_Code) ;
2290: l_ret:= igi_iac_common_utils.iac_round(l_fa_retire_deprn_prd,P_Book_Type_Code) ;
2291: l_ret:= igi_iac_common_utils.iac_round(l_fa_retire_deprn_ytd,P_Book_Type_Code) ;
2292:
2293: l_detail_balances_rnd_tot.adjustment_cost:= l_detail_balances_rnd_tot.adjustment_cost;
2294:
2295: l_detail_balances_rnd_tot.adjustment_cost := l_detail_balances_rnd_tot.adjustment_cost +

Line 2375: IF NOT (igi_iac_common_utils.get_account_ccid(P_Book_Type_Code,P_Asset_Id,l_detail_balances.distribution_id,

2371:
2372: END IF;
2373:
2374: /* Create adjustment to reverse out NOCOPY old balances */
2375: IF NOT (igi_iac_common_utils.get_account_ccid(P_Book_Type_Code,P_Asset_Id,l_detail_balances.distribution_id,
2376: 'ASSET_COST_ACCT',g_retire_rec.detail_info.transaction_header_id_in,
2377: 'RETIREMENT',l_cost_account_ccid
2378: )) THEN
2379: RAISE e_no_account_ccid ;

Line 2387: IF NOT (igi_iac_common_utils.get_account_ccid(P_Book_Type_Code,P_Asset_Id,l_detail_balances.distribution_id,

2383: l_rowid := NULL ;
2384: debug( g_state_level, l_path_name,'done cost adjustment');
2385: debug( g_state_level, l_path_name,'dist id: '||l_detail_balances.distribution_id);
2386: l_acc_deprn_account_ccid := NULL;
2387: IF NOT (igi_iac_common_utils.get_account_ccid(P_Book_Type_Code,P_Asset_Id,l_detail_balances.distribution_id,
2388: 'DEPRN_RESERVE_ACCT',g_retire_rec.detail_info.transaction_header_id_in,
2389: 'RETIREMENT',l_acc_deprn_account_ccid
2390: )) THEN
2391: RAISE e_no_account_ccid ;

Line 2395: IF NOT (igi_iac_common_utils.get_account_ccid(P_Book_Type_Code,P_Asset_Id,l_detail_balances.distribution_id,

2391: RAISE e_no_account_ccid ;
2392: END IF ;
2393: debug( g_state_level,l_path_name,'done deprn rsv ccid');
2394: debug( g_state_level,l_path_name, '*' ||l_acc_deprn_account_ccid || '*');
2395: IF NOT (igi_iac_common_utils.get_account_ccid(P_Book_Type_Code,P_Asset_Id,l_detail_balances.distribution_id,
2396: 'REVAL_RESERVE_ACCT',g_retire_rec.detail_info.transaction_header_id_in,
2397: 'RETIREMENT',l_reval_rsv_account_ccid
2398: )) THEN
2399: RAISE e_no_account_ccid ;

Line 2403: IF NOT (igi_iac_common_utils.get_account_ccid(P_Book_Type_Code,P_Asset_Id,l_detail_balances.distribution_id,

2399: RAISE e_no_account_ccid ;
2400: END IF ;
2401: debug( g_state_level,l_path_name,'done reval rsv ccid');
2402:
2403: IF NOT (igi_iac_common_utils.get_account_ccid(P_Book_Type_Code,P_Asset_Id,l_detail_balances.distribution_id,
2404: 'BACKLOG_DEPRN_RSV_ACCT',g_retire_rec.detail_info.transaction_header_id_in,
2405: 'RETIREMENT',l_backlog_account_ccid
2406: )) THEN
2407: RAISE e_no_account_ccid ;

Line 2414: IF NOT (igi_iac_common_utils.get_account_ccid(P_Book_Type_Code,P_Asset_Id,l_detail_balances.distribution_id,

2410:
2411: /* Create new adjustments for retirement part */
2412:
2413: IF ((l_detail_balances.adjustment_cost-l_detail_balances.deprn_reserve<>0) OR (l_detail_balances.deprn_reserve_backlog <>0)) THEN
2414: IF NOT (igi_iac_common_utils.get_account_ccid(P_Book_Type_Code,P_Asset_Id,l_detail_balances.distribution_id,
2415: 'NBV_RETIRED_GAIN_ACCT',g_retire_rec.detail_info.transaction_header_id_in,
2416: 'RETIREMENT',l_nbv_retired_account_ccid
2417: )) THEN
2418: RAISE e_no_account_ccid ;

Line 2470: IF NOT (igi_iac_common_utils.get_account_ccid(P_Book_Type_Code,P_Asset_Id,l_detail_balances.distribution_id,

2466: END IF;
2467:
2468:
2469: IF l_detail_balances.reval_reserve_net <> 0 THEN
2470: IF NOT (igi_iac_common_utils.get_account_ccid(P_Book_Type_Code,P_Asset_Id,l_detail_balances.distribution_id,
2471: 'REVAL_RESERVE_RETIRED_ACCT',g_retire_rec.detail_info.transaction_header_id_in,
2472: 'RETIREMENT',l_reval_rsv_ret_acct_ccid
2473: )) THEN
2474: RAISE e_no_account_ccid ;

Line 2551: IF NOT (igi_iac_common_utils.get_account_ccid(P_Book_Type_Code,P_Asset_Id,l_detail_balances.distribution_id,

2547: END IF;
2548:
2549: IF l_detail_balances.operating_acct_backlog <> 0 THEN
2550:
2551: IF NOT (igi_iac_common_utils.get_account_ccid(P_Book_Type_Code,P_Asset_Id,l_detail_balances.distribution_id,
2552: 'OPERATING_EXPENSE_ACCT',g_retire_rec.detail_info.transaction_header_id_in,
2553: 'RETIREMENT',l_op_exp_ccid
2554: )) THEN
2555: RAISE e_no_account_ccid ;

Line 2658: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances.deprn_ytd,P_Book_Type_Code);

2654: l_detail_balances.deprn_ytd:=0;
2655: l_fa_deprn.deprn_ytd :=0;
2656: ELSE
2657: l_detail_balances.deprn_ytd:=l_detail_balances.deprn_ytd *(1-l_retirement_factor);
2658: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances.deprn_ytd,P_Book_Type_Code);
2659: l_fa_deprn.deprn_ytd:=l_fa_deprn.deprn_ytd *(1-l_retirement_factor);
2660: l_ret:= igi_iac_common_utils.iac_round(l_fa_deprn.deprn_ytd,P_Book_Type_Code);
2661: END IF;
2662:

Line 2660: l_ret:= igi_iac_common_utils.iac_round(l_fa_deprn.deprn_ytd,P_Book_Type_Code);

2656: ELSE
2657: l_detail_balances.deprn_ytd:=l_detail_balances.deprn_ytd *(1-l_retirement_factor);
2658: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances.deprn_ytd,P_Book_Type_Code);
2659: l_fa_deprn.deprn_ytd:=l_fa_deprn.deprn_ytd *(1-l_retirement_factor);
2660: l_ret:= igi_iac_common_utils.iac_round(l_fa_deprn.deprn_ytd,P_Book_Type_Code);
2661: END IF;
2662:
2663: l_rowid := NULL ;
2664:

Line 2732: IF NOT (igi_iac_common_utils.get_account_ccid(P_Book_Type_Code,P_Asset_Id,l_new_fa_dist.distribution_id,

2728: IF l_retirement_factor <> 1 THEN -- for new distribution created
2729:
2730: --Create balances and adjustments for new distriution create in partial retirement
2731: l_cost_account_ccid:=NULL;
2732: IF NOT (igi_iac_common_utils.get_account_ccid(P_Book_Type_Code,P_Asset_Id,l_new_fa_dist.distribution_id,
2733: 'ASSET_COST_ACCT',g_retire_rec.detail_info.transaction_header_id_in,
2734: 'RETIREMENT',l_cost_account_ccid
2735: )) THEN
2736: RAISE e_no_account_ccid ;

Line 2745: IF NOT (igi_iac_common_utils.get_account_ccid(P_Book_Type_Code,P_Asset_Id,l_new_fa_dist.distribution_id,

2741: debug( g_state_level, l_path_name,'done cost adjustment for new dist');
2742:
2743: l_acc_deprn_account_ccid := NULL;
2744:
2745: IF NOT (igi_iac_common_utils.get_account_ccid(P_Book_Type_Code,P_Asset_Id,l_new_fa_dist.distribution_id,
2746: 'DEPRN_RESERVE_ACCT',g_retire_rec.detail_info.transaction_header_id_in,
2747: 'RETIREMENT',l_acc_deprn_account_ccid
2748: )) THEN
2749: RAISE e_no_account_ccid ;

Line 2753: IF NOT (igi_iac_common_utils.get_account_ccid(P_Book_Type_Code,P_Asset_Id,l_new_fa_dist.distribution_id,

2749: RAISE e_no_account_ccid ;
2750: END IF ;
2751: debug( g_state_level,l_path_name,'done deprn rsv ccid for new dist');
2752: debug( g_state_level,l_path_name, '*' ||l_acc_deprn_account_ccid || '*');
2753: IF NOT (igi_iac_common_utils.get_account_ccid(P_Book_Type_Code,P_Asset_Id,l_new_fa_dist.distribution_id,
2754: 'REVAL_RESERVE_ACCT',g_retire_rec.detail_info.transaction_header_id_in,
2755: 'RETIREMENT',l_reval_rsv_account_ccid
2756: )) THEN
2757: RAISE e_no_account_ccid ;

Line 2760: IF NOT (igi_iac_common_utils.get_account_ccid(P_Book_Type_Code,P_Asset_Id,l_new_fa_dist.distribution_id,

2756: )) THEN
2757: RAISE e_no_account_ccid ;
2758: END IF ;
2759: debug( g_state_level,l_path_name,'done reval rsv ccid for new dist');
2760: IF NOT (igi_iac_common_utils.get_account_ccid(P_Book_Type_Code,P_Asset_Id,l_new_fa_dist.distribution_id,
2761: 'BACKLOG_DEPRN_RSV_ACCT',g_retire_rec.detail_info.transaction_header_id_in,
2762: 'RETIREMENT',l_backlog_account_ccid
2763: )) THEN
2764: RAISE e_no_account_ccid ;

Line 3335: IF NOT (igi_iac_common_utils.get_latest_transaction(P_Book_Type_Code,

3331:
3332: debug(g_state_level,l_path_name,'Asset ID '||P_Asset_Id);
3333: -- get the latest tranaction for the asset id
3334:
3335: IF NOT (igi_iac_common_utils.get_latest_transaction(P_Book_Type_Code,
3336: P_Asset_Id,
3337: l_Transaction_Type_Code,
3338: l_Transaction_Id,
3339: l_Mass_Reference_ID ,

Line 3465: --l_ret:= igi_iac_common_utils.iac_round(l_retire_amount,P_Book_Type_Code);

3461: l_detail_balances.distribution_id ) LOOP
3462:
3463:
3464: l_retire_amount:=l_all_occ_reval.amount;
3465: --l_ret:= igi_iac_common_utils.iac_round(l_retire_amount,P_Book_Type_Code);
3466: l_rowid := NULL ;
3467: igi_iac_adjustments_pkg.insert_row(
3468: X_rowid => l_rowid ,
3469: X_adjustment_id => l_retirement_adjustment_id ,

Line 3494: l_ret:= igi_iac_common_utils.iac_round(l_retire_amount,P_Book_Type_Code);

3490:
3491: IF l_retirement_factor <> 1 THEN
3492:
3493: l_retire_amount:=l_all_occ_reval.amount * l_retirement_factor ;
3494: l_ret:= igi_iac_common_utils.iac_round(l_retire_amount,P_Book_Type_Code);
3495:
3496: l_rowid := NULL ;
3497: igi_iac_adjustments_pkg.insert_row(
3498: X_rowid => l_rowid ,

Line 3859: --l_ret:= igi_iac_common_utils.iac_round(l_retire_amount,P_Book_Type_Code);

3855: p_current_period,
3856: l_detail_balances.distribution_id ) LOOP
3857:
3858: l_retire_amount:=l_all_prd_reval.amount;
3859: --l_ret:= igi_iac_common_utils.iac_round(l_retire_amount,P_Book_Type_Code);
3860: l_rowid := NULL ;
3861: igi_iac_adjustments_pkg.insert_row(
3862: X_rowid => l_rowid ,
3863: X_adjustment_id => l_retirement_adjustment_id ,

Line 3888: l_ret:= igi_iac_common_utils.iac_round(l_retire_amount,P_Book_Type_Code);

3884:
3885: IF l_retirement_factor <> 1 THEN
3886:
3887: l_retire_amount:=l_all_prd_reval.amount * l_retirement_factor ;
3888: l_ret:= igi_iac_common_utils.iac_round(l_retire_amount,P_Book_Type_Code);
3889:
3890: l_rowid := NULL ;
3891: igi_iac_adjustments_pkg.insert_row(
3892: X_rowid => l_rowid ,

Line 4199: IF not igi_iac_common_utils.get_period_info_for_counter(X_book_type_code,l_iac_transaction.period_counter

4195: fetch c_get_prior_transactions into l_iac_transaction;
4196: If l_iac_transaction.period_counter is not null Then
4197: close c_get_prior_transactions;
4198: l_iac_transaction.period_counter := l_iac_transaction.period_counter + 1;
4199: IF not igi_iac_common_utils.get_period_info_for_counter(X_book_type_code,l_iac_transaction.period_counter
4200: ,l_prd_rec) THEN
4201: Null;
4202:
4203: END iF;

Line 4220: IF NOT (igi_iac_common_utils.is_asset_proc(P_Book_Type_Code,P_Asset_Id)) THEN

4216: BEGIN
4217:
4218: g_path_name := g_path||'.Do_IAC_Retirement';
4219:
4220: IF NOT (igi_iac_common_utils.is_asset_proc(P_Book_Type_Code,P_Asset_Id)) THEN
4221: RAISE e_is_asset_proc ;
4222: END IF ;
4223: debug( g_state_level,g_path_name,'asset processed by IAC');
4224:

Line 4226: IF NOT igi_iac_common_utils.populate_iac_fa_deprn_data(p_book_type_code,'RETIREMENT') THEN

4222: END IF ;
4223: debug( g_state_level,g_path_name,'asset processed by IAC');
4224:
4225: -- if no entries exist for the book in the table
4226: IF NOT igi_iac_common_utils.populate_iac_fa_deprn_data(p_book_type_code,'RETIREMENT') THEN
4227: debug( g_error_level,g_path_name,'Problems creating rows in igi_iac_fa_deprn');
4228: RAISE e_iac_fa_deprn;
4229: END IF;
4230:

Line 4231: IF NOT (igi_iac_common_utils.get_open_period_info(P_Book_Type_Code,g_prd_rec)) THEN

4227: debug( g_error_level,g_path_name,'Problems creating rows in igi_iac_fa_deprn');
4228: RAISE e_iac_fa_deprn;
4229: END IF;
4230:
4231: IF NOT (igi_iac_common_utils.get_open_period_info(P_Book_Type_Code,g_prd_rec)) THEN
4232: RAISE e_no_open_prd_info ;
4233: END IF ;
4234: debug( g_state_level,g_path_name,'got open period info');
4235:

Line 4236: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_book_type_code,g_prd_rec.period_counter,

4232: RAISE e_no_open_prd_info ;
4233: END IF ;
4234: debug( g_state_level,g_path_name,'got open period info');
4235:
4236: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_book_type_code,g_prd_rec.period_counter,
4237: g_period_rec) THEN
4238: debug( g_state_level,g_path_name,
4239: 'Could not retreive period information for the current period '||g_prd_rec.period_counter);
4240: RETURN FALSE;

Line 4253: IF NOT (igi_iac_common_utils.get_period_info_for_date(P_Book_Type_Code,

4249: RAISE e_no_retire_rec ;
4250: END IF ;
4251: debug( g_state_level,g_path_name,'got retirement record');
4252:
4253: IF NOT (igi_iac_common_utils.get_period_info_for_date(P_Book_Type_Code,
4254: g_retire_rec.date_retired,
4255: g_retire_prd_rec )) THEN
4256: RAISE e_no_retire_period ;
4257: END IF ;

Line 4287: IF NOT (igi_iac_common_utils.get_retirement_type(P_Book_Type_Code,

4283: END IF;
4284:
4285: g_prior_prd_count := g_prd_rec.period_counter - g_retire_prd_rec.period_counter ;
4286:
4287: IF NOT (igi_iac_common_utils.get_retirement_type(P_Book_Type_Code,
4288: P_Asset_id,
4289: P_Retirement_Id,
4290: g_retirement_type)) THEN
4291: RAISE e_no_retire_type ;

Line 4341: IF NOT (igi_iac_common_utils.get_book_gl_info(P_Book_Type_Code,

4337: g_is_first_period := FALSE;
4338: END IF;
4339:
4340:
4341: IF NOT (igi_iac_common_utils.get_book_gl_info(P_Book_Type_Code,
4342: g_sob_id,
4343: g_coa_id,
4344: g_currency,
4345: g_precision

Line 4367: IF NOT (igi_iac_common_utils.get_cost_retirement_factor(P_Book_Type_Code,

4363: IF g_retirement_type IN('FULL','COST') THEN
4364:
4365: -- get the reitement factor partial cost or retirement
4366: IF g_retirement_type <> 'FULL' THEN
4367: IF NOT (igi_iac_common_utils.get_cost_retirement_factor(P_Book_Type_Code,
4368: P_Asset_Id,
4369: P_Retirement_Id,
4370: g_retirement_factor)) THEN
4371: RAISE e_no_cost_retire ;