DBA Data[Home] [Help]

APPS.IGI_IAC_ADJ_AMORT_PKG dependencies on IGI_IAC_COMMON_UTILS

Line 37: IF IGI_IAC_COMMON_UTILS.Iac_Round(X_Amount => l_amount, X_Book => p_book_type_code)

33: l_amount_old number := p_amount;
34: --l_path varchar2(150) := g_path||'do_round';
35: begin
36: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'--- Inside Round() ---');
37: IF IGI_IAC_COMMON_UTILS.Iac_Round(X_Amount => l_amount, X_Book => p_book_type_code)
38: THEN
39: p_amount := l_amount;
40: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is TRUE');
41: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);

Line 40: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is TRUE');

36: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'--- Inside Round() ---');
37: IF IGI_IAC_COMMON_UTILS.Iac_Round(X_Amount => l_amount, X_Book => p_book_type_code)
38: THEN
39: p_amount := l_amount;
40: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is TRUE');
41: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);
42: ELSE
43: p_amount := round( l_amount, 2);
44: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is FALSE');

Line 44: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is FALSE');

40: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is TRUE');
41: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);
42: ELSE
43: p_amount := round( l_amount, 2);
44: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is FALSE');
45: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);
46: END IF;
47: exception when others then
48: p_amount := l_amount_old;

Line 362: IF NOT igi_iac_common_utils.get_book_GL_info(l_book_type_code,

358: FROM fa_additions
359: WHERE asset_id = l_asset_id;
360:
361: -- get the GL set of books id
362: IF NOT igi_iac_common_utils.get_book_GL_info(l_book_type_code,
363: l_sob_id,
364: l_coa_id,
365: l_currency,
366: l_precision)

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

367: THEN
368: RAISE e_no_gl_info;
369: END IF;
370:
371: -- Get the latest transaction or adjustment from igi_iac_common_utils.get_latest_transaction
372: -- for the asset and book
373: IF NOT igi_iac_common_utils.get_latest_transaction(l_book_type_code,
374: l_asset_id,
375: l_latest_trx_type,

Line 373: IF NOT igi_iac_common_utils.get_latest_transaction(l_book_type_code,

369: END IF;
370:
371: -- Get the latest transaction or adjustment from igi_iac_common_utils.get_latest_transaction
372: -- for the asset and book
373: IF NOT igi_iac_common_utils.get_latest_transaction(l_book_type_code,
374: l_asset_id,
375: l_latest_trx_type,
376: l_latest_trx_id,
377: l_latest_mref_id,

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

601: -- calculate the new revlaued deprn adjustment amount
602: l_iac_new_deprn_adj_amt := l_fa_deprn_adj_amount*(l_iac_asset_bal.cumulative_reval_factor - 1);
603:
604: -- round the depreciation adjustment amount
605: l_ret := igi_iac_common_utils.iac_round(l_iac_new_deprn_adj_amt,
606: l_book_type_code) ;
607:
608: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
609: p_full_path => l_path_name,

Line 641: IF NOT igi_iac_common_utils.prorate_amt_to_active_dists(l_book_type_code,

637: p_string => 'new deprn reserve: '||l_iac_new_deprn_reserve);
638:
639: -- Prorate th depreciation ajustment amount for the active distributions in the
640: -- ratio of the units assigned to them
641: IF NOT igi_iac_common_utils.prorate_amt_to_active_dists(l_book_type_code,
642: l_asset_id,
643: l_iac_new_deprn_adj_amt,
644: l_det_table)
645: THEN

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

669: RAISE NO_DATA_FOUND ;
670: END IF ;
671: CLOSE c_det_bal;
672: -- round dep_adj_amount
673: l_ret := igi_iac_common_utils.iac_round(l_dep_adj_amount,
674: l_book_type_code);
675: -- maintain the diff due to rounding
676: l_round_diff := l_round_diff + l_dep_adj_amount;
677:

Line 759: IF NOT igi_iac_common_utils.get_account_ccid(l_book_type_code,

755:
756: -- create accounting entries only if iac adjustment is not equal to zero
757: IF (l_dep_adj_amount <> 0) THEN
758: -- find the ccid for EXPENSE
759: IF NOT igi_iac_common_utils.get_account_ccid(l_book_type_code,
760: l_asset_id,
761: l_det_bal.distribution_id,
762: 'DEPRN_EXPENSE_ACCT',
763: l_ccid)

Line 794: IF NOT igi_iac_common_utils.get_account_ccid(l_book_type_code,

790: p_full_path => l_path_name,
791: p_string => 'EXPENSE ccid: '||l_ccid);
792:
793: -- find the ccid for RESERVE
794: IF NOT igi_iac_common_utils.get_account_ccid(l_book_type_code,
795: l_asset_id,
796: l_det_bal.distribution_id,
797: 'DEPRN_RESERVE_ACCT',
798: l_ccid)

Line 830: IF NOT igi_iac_common_utils.get_account_ccid(l_book_type_code,

826: p_string => 'RESERVE ccid: '||l_ccid);
827:
828: IF (l_iac_asset_bal.cumulative_reval_factor >= 1) THEN
829: -- find the ccid for REVAL RESERVE
830: IF NOT igi_iac_common_utils.get_account_ccid(l_book_type_code,
831: l_asset_id,
832: l_det_bal.distribution_id,
833: 'REVAL_RESERVE_ACCT',
834: l_reval_rsv_ccid)

Line 865: IF NOT igi_iac_common_utils.get_account_ccid(l_book_type_code,

861: p_full_path => l_path_name,
862: p_string => 'EXPENSE ccid: '||l_ccid);
863:
864: -- find the ccid for GENERAL FUND
865: IF NOT igi_iac_common_utils.get_account_ccid(l_book_type_code,
866: l_asset_id,
867: l_det_bal.distribution_id,
868: 'GENERAL_FUND_ACCT',
869: l_ccid)