DBA Data[Home] [Help]

APPS.IGI_IAC_ADJ_AMORT_PKG dependencies on IGI_IAC_COMMON_UTILS

Line 339: IF NOT igi_iac_common_utils.get_book_GL_info(l_book_type_code,

335: FROM fa_additions
336: WHERE asset_id = l_asset_id;
337:
338: -- get the GL set of books id
339: IF NOT igi_iac_common_utils.get_book_GL_info(l_book_type_code,
340: l_sob_id,
341: l_coa_id,
342: l_currency,
343: l_precision)

Line 348: -- Get the latest transaction or adjustment from igi_iac_common_utils.get_latest_transaction

344: THEN
345: RAISE e_no_gl_info;
346: END IF;
347:
348: -- Get the latest transaction or adjustment from igi_iac_common_utils.get_latest_transaction
349: -- for the asset and book
350: IF NOT igi_iac_common_utils.get_latest_transaction(l_book_type_code,
351: l_asset_id,
352: l_latest_trx_type,

Line 350: IF NOT igi_iac_common_utils.get_latest_transaction(l_book_type_code,

346: END IF;
347:
348: -- Get the latest transaction or adjustment from igi_iac_common_utils.get_latest_transaction
349: -- for the asset and book
350: IF NOT igi_iac_common_utils.get_latest_transaction(l_book_type_code,
351: l_asset_id,
352: l_latest_trx_type,
353: l_latest_trx_id,
354: l_latest_mref_id,

Line 580: l_ret := igi_iac_common_utils.iac_round(l_iac_new_deprn_adj_amt,

576: -- calculate the new revlaued deprn adjustment amount
577: l_iac_new_deprn_adj_amt := l_fa_deprn_adj_amount*(l_iac_asset_bal.cumulative_reval_factor - 1);
578:
579: -- round the depreciation adjustment amount
580: l_ret := igi_iac_common_utils.iac_round(l_iac_new_deprn_adj_amt,
581: l_book_type_code) ;
582:
583: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
584: p_full_path => l_path_name,

Line 616: IF NOT igi_iac_common_utils.prorate_amt_to_active_dists(l_book_type_code,

612: p_string => 'new deprn reserve: '||l_iac_new_deprn_reserve);
613:
614: -- Prorate th depreciation ajustment amount for the active distributions in the
615: -- ratio of the units assigned to them
616: IF NOT igi_iac_common_utils.prorate_amt_to_active_dists(l_book_type_code,
617: l_asset_id,
618: l_iac_new_deprn_adj_amt,
619: l_det_table)
620: THEN

Line 648: l_ret := igi_iac_common_utils.iac_round(l_dep_adj_amount,

644: RAISE NO_DATA_FOUND ;
645: END IF ;
646: CLOSE c_det_bal;
647: -- round dep_adj_amount
648: l_ret := igi_iac_common_utils.iac_round(l_dep_adj_amount,
649: l_book_type_code);
650: -- maintain the diff due to rounding
651: l_round_diff := l_round_diff + l_dep_adj_amount;
652:

Line 734: IF NOT igi_iac_common_utils.get_account_ccid(l_book_type_code,

730:
731: -- create accounting entries only if iac adjustment is not equal to zero
732: IF (l_dep_adj_amount <> 0) THEN
733: -- find the ccid for EXPENSE
734: IF NOT igi_iac_common_utils.get_account_ccid(l_book_type_code,
735: l_asset_id,
736: l_det_bal.distribution_id,
737: 'DEPRN_EXPENSE_ACCT',
738: l_ccid)

Line 769: IF NOT igi_iac_common_utils.get_account_ccid(l_book_type_code,

765: p_full_path => l_path_name,
766: p_string => 'EXPENSE ccid: '||l_ccid);
767:
768: -- find the ccid for RESERVE
769: IF NOT igi_iac_common_utils.get_account_ccid(l_book_type_code,
770: l_asset_id,
771: l_det_bal.distribution_id,
772: 'DEPRN_RESERVE_ACCT',
773: l_ccid)

Line 805: IF NOT igi_iac_common_utils.get_account_ccid(l_book_type_code,

801: p_string => 'RESERVE ccid: '||l_ccid);
802:
803: IF (l_iac_asset_bal.cumulative_reval_factor >= 1) THEN
804: -- find the ccid for REVAL RESERVE
805: IF NOT igi_iac_common_utils.get_account_ccid(l_book_type_code,
806: l_asset_id,
807: l_det_bal.distribution_id,
808: 'REVAL_RESERVE_ACCT',
809: l_reval_rsv_ccid)

Line 840: IF NOT igi_iac_common_utils.get_account_ccid(l_book_type_code,

836: p_full_path => l_path_name,
837: p_string => 'EXPENSE ccid: '||l_ccid);
838:
839: -- find the ccid for GENERAL FUND
840: IF NOT igi_iac_common_utils.get_account_ccid(l_book_type_code,
841: l_asset_id,
842: l_det_bal.distribution_id,
843: 'GENERAL_FUND_ACCT',
844: l_ccid)