DBA Data[Home] [Help]

APPS.IGI_IAC_ADJ_COST_REVAL_PKG dependencies on IGI_IAC_COMMON_UTILS

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

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

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

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

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

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

Line 190: l_ret_flag := igi_iac_common_utils.Get_period_info_for_date(p_book_code,

186: FETCH c_get_periods_in_year INTO l_periods_in_year;
187: CLOSE c_get_periods_in_year;
188:
189: -- Get the period info for the dpis
190: l_ret_flag := igi_iac_common_utils.Get_period_info_for_date(p_book_code,
191: l_asset_rec.date_placed_in_service,
192: l_dpis_prd_rec
193: );
194: l_total_periods := ceil((l_asset_rec.life_in_months*l_periods_in_year)/12);

Line 561: IF NOT igi_iac_common_utils.get_book_GL_info(l_book_type_code,

557: l_asset_id := p_asset_iac_adj_info.asset_id;
558: l_last_period_counter := p_asset_iac_adj_info.last_period_counter;
559:
560: -- get the GL set of books id
561: IF NOT igi_iac_common_utils.get_book_GL_info(l_book_type_code,
562: l_sob_id,
563: l_coa_id,
564: l_currency,
565: l_precision)

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

566: THEN
567: RAISE e_no_gl_info;
568: END IF;
569:
570: -- Get the latest transaction or adjustment from igi_iac_common_utils.get_latest_transaction
571: -- for the asset and book
572: IF NOT igi_iac_common_utils.get_latest_transaction(l_book_type_code,
573: l_asset_id,
574: l_latest_trx_type,

Line 572: IF NOT igi_iac_common_utils.get_latest_transaction(l_book_type_code,

568: END IF;
569:
570: -- Get the latest transaction or adjustment from igi_iac_common_utils.get_latest_transaction
571: -- for the asset and book
572: IF NOT igi_iac_common_utils.get_latest_transaction(l_book_type_code,
573: l_asset_id,
574: l_latest_trx_type,
575: l_latest_trx_id,
576: l_latest_mref_id,

Line 728: l_ret := igi_iac_common_utils.iac_round(l_iac_new_reval_cost,

724: l_iac_new_reval_cost := p_asset_iac_adj_info.cost*(l_iac_asset_bal.cumulative_reval_factor - 1);
725: do_round(l_iac_new_reval_cost,l_book_type_code);
726:
727: -- round the cost
728: l_ret := igi_iac_common_utils.iac_round(l_iac_new_reval_cost,
729: l_book_type_code) ;
730: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
731: p_full_path => l_path_name,
732: p_string => 'New revalued cost: '||l_iac_new_reval_cost);

Line 756: IF NOT igi_iac_common_utils.prorate_amt_to_active_dists(l_book_type_code,

752: END IF;
753:
754:
755: -- Prorate this amount for the active distributions in the ratio of the units assigned to them
756: IF NOT igi_iac_common_utils.prorate_amt_to_active_dists(l_book_type_code,
757: l_asset_id,
758: l_diff_cost,
759: l_det_table)
760: THEN

Line 793: l_ret := igi_iac_common_utils.iac_round(l_new_dist_cost,

789: l_new_dist_cost := l_det_bal.adjustment_cost + l_add_cost;
790:
791:
792: -- round the new cost
793: l_ret := igi_iac_common_utils.iac_round(l_new_dist_cost,
794: l_book_type_code) ;
795:
796: l_ret := igi_iac_common_utils.iac_round(l_add_cost,
797: l_book_type_code) ;

Line 796: l_ret := igi_iac_common_utils.iac_round(l_add_cost,

792: -- round the new cost
793: l_ret := igi_iac_common_utils.iac_round(l_new_dist_cost,
794: l_book_type_code) ;
795:
796: l_ret := igi_iac_common_utils.iac_round(l_add_cost,
797: l_book_type_code) ;
798:
799:
800: IF (l_new_dist_cost >= 0) THEN

Line 818: l_ret := igi_iac_common_utils.iac_round(l_new_dist_nbv,

814: -- calculate the nbv
815: l_new_dist_nbv := l_det_bal.net_book_value + l_add_cost;
816:
817: -- round the new cost
818: l_ret := igi_iac_common_utils.iac_round(l_new_dist_nbv,
819: l_book_type_code) ;
820: -- maintain the diff due to rounding
821: l_round_diff := l_round_diff + l_new_dist_cost;
822: l_round_diff_nbv := l_round_diff_nbv + l_new_dist_nbv;

Line 910: IF NOT igi_iac_common_utils.get_account_ccid(l_book_type_code,

906: -- find the ccid for COST
907:
908: If l_add_cost <> 0 Then
909: -- get the ccids
910: IF NOT igi_iac_common_utils.get_account_ccid(l_book_type_code,
911: l_asset_id,
912: l_det_bal.distribution_id,
913: 'ASSET_COST_ACCT',
914: l_cost_ccid)

Line 926: IF NOT igi_iac_common_utils.get_account_ccid(l_book_type_code,

922:
923: -- insert into igi_iac_adjustments for REVAL RESERVE or OP EXPENSE
924: IF (l_iac_asset_bal.cumulative_reval_factor >= 1 ) THEN
925: -- find the ccid for COST
926: IF NOT igi_iac_common_utils.get_account_ccid(l_book_type_code,
927: l_asset_id,
928: l_det_bal.distribution_id,
929: 'REVAL_RESERVE_ACCT',
930: l_reval_rsv_ccid)

Line 969: IF NOT igi_iac_common_utils.get_account_ccid(l_book_type_code,

965:
966: -------- OP EXPENSE A/C Entry-------------
967:
968: -- find the ccid for OP EXPENSE
969: IF NOT igi_iac_common_utils.get_account_ccid(l_book_type_code,
970: l_asset_id,
971: l_det_bal.distribution_id,
972: 'OPERATING_EXPENSE_ACCT', -- bug 3449361 'OP_EXPENSE_ACCT',
973: l_op_exp_ccid)