DBA Data[Home] [Help]

APPS.IGI_IAC_ADJ_EXPENSED_PKG dependencies on IGI_IAC_COMMON_UTILS

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

19: l_amount_old number := p_amount;
20: --l_path varchar2(150) := g_path||'do_round';
21: begin
22: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'--- Inside Round() ---');
23: IF IGI_IAC_COMMON_UTILS.Iac_Round(X_Amount => l_amount, X_Book => p_book_type_code)
24: THEN
25: p_amount := l_amount;
26: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is TRUE');
27: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);

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

22: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'--- Inside Round() ---');
23: IF IGI_IAC_COMMON_UTILS.Iac_Round(X_Amount => l_amount, X_Book => p_book_type_code)
24: THEN
25: p_amount := l_amount;
26: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is TRUE');
27: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);
28: ELSE
29: p_amount := round( l_amount, 2);
30: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is FALSE');

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

26: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is TRUE');
27: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);
28: ELSE
29: p_amount := round( l_amount, 2);
30: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is FALSE');
31: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);
32: END IF;
33: exception when others then
34: p_amount := l_amount_old;

Line 164: IF NOT igi_iac_common_utils.get_Period_Info_for_Date(p_asset_iac_adj_info.book_type_code,

160: l_path_name VARCHAR2(150);
161: BEGIN
162: l_path_name := g_path||'Calculate_New_Balances';
163:
164: IF NOT igi_iac_common_utils.get_Period_Info_for_Date(p_asset_iac_adj_info.book_type_code,
165: P_asset_iac_adj_info.date_placed_in_service,
166: l_dpis_period_info) THEN
167: RETURN FALSE;
168: END IF;

Line 170: IF NOT igi_iac_common_utils.get_price_index_value(

166: l_dpis_period_info) THEN
167: RETURN FALSE;
168: END IF;
169:
170: IF NOT igi_iac_common_utils.get_price_index_value(
171: p_asset_iac_adj_info.book_type_code,
172: p_asset_iac_adj_info.asset_id,
173: l_dpis_period_info.period_name,
174: l_dpis_price_index) THEN

Line 242: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_asset_iac_adj_info.book_type_code,

238: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
239: p_full_path => l_path_name,
240: p_string => 'Last revaluation period for the asset : '|| to_char(l_get_curr_reval_rate.period_counter));
241:
242: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_asset_iac_adj_info.book_type_code,
243: l_get_curr_reval_rate.period_counter,
244: l_latest_reval_period_info) THEN
245: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
246: p_full_path => l_path_name,

Line 260: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_asset_iac_adj_info.book_type_code,

256: l_current_backlog:=0;
257:
258: FOR l_period_counter IN l_dpis_period_info.period_counter..(l_latest_reval_period_info.period_counter) LOOP
259:
260: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_asset_iac_adj_info.book_type_code,
261: l_period_counter,
262: l_period_info) THEN
263: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
264: p_full_path => l_path_name,

Line 280: IF NOT (igi_iac_common_utils.get_price_index_value(

276: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
277: p_full_path => l_path_name,
278: p_string => 'Cumulative reval factor from last reval : '||l_cumm_reval_factor);
279: ELSE
280: IF NOT (igi_iac_common_utils.get_price_index_value(
281: p_asset_iac_adj_info.book_type_code,
282: p_asset_iac_adj_info.asset_id,
283: l_period_info.period_name,
284: l_curr_price_index)) THEN

Line 326: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_asset_iac_adj_info.book_type_code,

322: END IF;
323:
324: IF (l_fa_asset_info.last_period_counter < l_period_info.period_counter) THEN
325:
326: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_asset_iac_adj_info.book_type_code,
327: l_fa_asset_info.last_period_counter,
328: l_last_deprn_period) THEN
329: RETURN FALSE;
330: END IF;

Line 436: IF NOT (igi_iac_common_utils.iac_round(l_cumulative_backlog,p_asset_iac_adj_info.book_type_code)) THEN

432: END IF;
433:
434: END LOOP;
435:
436: IF NOT (igi_iac_common_utils.iac_round(l_cumulative_backlog,p_asset_iac_adj_info.book_type_code)) THEN
437: RETURN FALSE;
438: END IF;
439: IF NOT (igi_iac_common_utils.iac_round(l_Reval_Rsv_backlog,p_asset_iac_adj_info.book_type_code)) THEN
440: RETURN FALSE;

Line 439: IF NOT (igi_iac_common_utils.iac_round(l_Reval_Rsv_backlog,p_asset_iac_adj_info.book_type_code)) THEN

435:
436: IF NOT (igi_iac_common_utils.iac_round(l_cumulative_backlog,p_asset_iac_adj_info.book_type_code)) THEN
437: RETURN FALSE;
438: END IF;
439: IF NOT (igi_iac_common_utils.iac_round(l_Reval_Rsv_backlog,p_asset_iac_adj_info.book_type_code)) THEN
440: RETURN FALSE;
441: END IF;
442: IF NOT (igi_iac_common_utils.iac_round(l_Operating_Acct_backlog,p_asset_iac_adj_info.book_type_code)) THEN
443: RETURN FALSE;

Line 442: IF NOT (igi_iac_common_utils.iac_round(l_Operating_Acct_backlog,p_asset_iac_adj_info.book_type_code)) THEN

438: END IF;
439: IF NOT (igi_iac_common_utils.iac_round(l_Reval_Rsv_backlog,p_asset_iac_adj_info.book_type_code)) THEN
440: RETURN FALSE;
441: END IF;
442: IF NOT (igi_iac_common_utils.iac_round(l_Operating_Acct_backlog,p_asset_iac_adj_info.book_type_code)) THEN
443: RETURN FALSE;
444: END IF;
445:
446: p_asset_balance.backlog_deprn_reserve := l_cumulative_backlog;

Line 450: IF NOT (igi_iac_common_utils.iac_round(p_asset_balance.deprn_reserve,p_asset_iac_adj_info.book_type_code)) THEN

446: p_asset_balance.backlog_deprn_reserve := l_cumulative_backlog;
447: p_asset_balance.deprn_reserve := p_asset_iac_adj_info.deprn_reserve * (l_cumm_reval_factor - 1)
448: - l_cumulative_backlog;
449: do_round(p_asset_balance.deprn_reserve,p_asset_iac_adj_info.book_type_code);
450: IF NOT (igi_iac_common_utils.iac_round(p_asset_balance.deprn_reserve,p_asset_iac_adj_info.book_type_code)) THEN
451: RETURN FALSE;
452: END IF;
453:
454: p_asset_balance.net_book_value := p_asset_balance.adjusted_cost - p_asset_balance.deprn_reserve

Line 633: IF NOT igi_iac_common_utils.Get_Latest_Transaction (

629:
630: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
631: p_full_path => l_path_name,
632: p_string => ' Get previous adjustment');
633: IF NOT igi_iac_common_utils.Get_Latest_Transaction (
634: X_book_type_code => p_asset_iac_adj_info.book_type_code,
635: X_asset_id => p_asset_iac_adj_info.asset_id,
636: X_Transaction_Type_Code => l_Transaction_Type_Code,
637: X_Transaction_Id => l_Transaction_Id,

Line 782: IF NOT (igi_iac_common_utils.iac_round(l_curr_asset_balance.deprn_amount,l_curr_asset_balance.book_type_code)) THEN

778: l_curr_asset_balance.deprn_amount := 0;
779: ELSE
780: l_curr_asset_balance.deprn_amount := l_asset_iac_adj_info.deprn_amount * (l_curr_asset_balance.Cumulative_reval_factor-1);
781: do_round(l_curr_asset_balance.deprn_amount,p_asset_iac_adj_info.book_type_code);
782: IF NOT (igi_iac_common_utils.iac_round(l_curr_asset_balance.deprn_amount,l_curr_asset_balance.book_type_code)) THEN
783: RETURN FALSE;
784: END IF;
785: END IF;
786: l_iac_current_ytd := l_asset_iac_adj_info.ytd_deprn * (l_curr_asset_balance.Cumulative_reval_factor-1);

Line 788: IF NOT (igi_iac_common_utils.iac_round(l_iac_current_ytd,l_curr_asset_balance.book_type_code)) THEN

784: END IF;
785: END IF;
786: l_iac_current_ytd := l_asset_iac_adj_info.ytd_deprn * (l_curr_asset_balance.Cumulative_reval_factor-1);
787: do_round(l_iac_current_ytd,p_asset_iac_adj_info.book_type_code);
788: IF NOT (igi_iac_common_utils.iac_round(l_iac_current_ytd,l_curr_asset_balance.book_type_code)) THEN
789: RETURN FALSE;
790: END IF;
791: l_fa_current_ytd := l_asset_iac_adj_info.ytd_deprn;
792: IF NOT (igi_iac_common_utils.iac_round(l_fa_current_ytd,l_curr_asset_balance.book_type_code)) THEN

Line 792: IF NOT (igi_iac_common_utils.iac_round(l_fa_current_ytd,l_curr_asset_balance.book_type_code)) THEN

788: IF NOT (igi_iac_common_utils.iac_round(l_iac_current_ytd,l_curr_asset_balance.book_type_code)) THEN
789: RETURN FALSE;
790: END IF;
791: l_fa_current_ytd := l_asset_iac_adj_info.ytd_deprn;
792: IF NOT (igi_iac_common_utils.iac_round(l_fa_current_ytd,l_curr_asset_balance.book_type_code)) THEN
793: RETURN FALSE;
794: END IF;
795:
796: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

Line 989: IF NOT IGI_IAC_COMMON_UTILS.GET_BOOK_GL_INFO

985:
986: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
987: p_full_path => l_path_name,
988: p_string => ' +acctg creation get gl information');
989: IF NOT IGI_IAC_COMMON_UTILS.GET_BOOK_GL_INFO
990: ( X_BOOK_TYPE_CODE => l_asset_balance_mvmt.book_type_code
991: , SET_OF_BOOKS_ID => l_sob_id
992: , CHART_OF_ACCOUNTS_ID => l_coa_id
993: , CURRENCY => l_currency

Line 1169: IF NOT (igi_iac_common_utils.iac_round(l_current_db.adjustment_cost,l_det_balances.book_type_code)) THEN

1165: l_current_db.current_reval_factor := l_det_balances.current_reval_factor;
1166: l_current_db.cumulative_reval_factor := l_det_balances.cumulative_reval_factor;
1167: l_current_db.active_flag := l_det_balances.active_flag;
1168:
1169: IF NOT (igi_iac_common_utils.iac_round(l_current_db.adjustment_cost,l_det_balances.book_type_code)) THEN
1170: RETURN FALSE;
1171: END IF;
1172: IF NOT (igi_iac_common_utils.iac_round(l_current_db.net_book_value,l_det_balances.book_type_code)) THEN
1173: RETURN FALSE;

Line 1172: IF NOT (igi_iac_common_utils.iac_round(l_current_db.net_book_value,l_det_balances.book_type_code)) THEN

1168:
1169: IF NOT (igi_iac_common_utils.iac_round(l_current_db.adjustment_cost,l_det_balances.book_type_code)) THEN
1170: RETURN FALSE;
1171: END IF;
1172: IF NOT (igi_iac_common_utils.iac_round(l_current_db.net_book_value,l_det_balances.book_type_code)) THEN
1173: RETURN FALSE;
1174: END IF;
1175: IF NOT (igi_iac_common_utils.iac_round(l_current_db.reval_reserve_cost,l_det_balances.book_type_code)) THEN
1176: RETURN FALSE;

Line 1175: IF NOT (igi_iac_common_utils.iac_round(l_current_db.reval_reserve_cost,l_det_balances.book_type_code)) THEN

1171: END IF;
1172: IF NOT (igi_iac_common_utils.iac_round(l_current_db.net_book_value,l_det_balances.book_type_code)) THEN
1173: RETURN FALSE;
1174: END IF;
1175: IF NOT (igi_iac_common_utils.iac_round(l_current_db.reval_reserve_cost,l_det_balances.book_type_code)) THEN
1176: RETURN FALSE;
1177: END IF;
1178: IF NOT (igi_iac_common_utils.iac_round(l_current_db.reval_reserve_backlog,l_det_balances.book_type_code)) THEN
1179: RETURN FALSE;

Line 1178: IF NOT (igi_iac_common_utils.iac_round(l_current_db.reval_reserve_backlog,l_det_balances.book_type_code)) THEN

1174: END IF;
1175: IF NOT (igi_iac_common_utils.iac_round(l_current_db.reval_reserve_cost,l_det_balances.book_type_code)) THEN
1176: RETURN FALSE;
1177: END IF;
1178: IF NOT (igi_iac_common_utils.iac_round(l_current_db.reval_reserve_backlog,l_det_balances.book_type_code)) THEN
1179: RETURN FALSE;
1180: END IF;
1181: IF NOT (igi_iac_common_utils.iac_round(l_current_db.reval_reserve_gen_fund,l_det_balances.book_type_code)) THEN
1182: RETURN FALSE;

Line 1181: IF NOT (igi_iac_common_utils.iac_round(l_current_db.reval_reserve_gen_fund,l_det_balances.book_type_code)) THEN

1177: END IF;
1178: IF NOT (igi_iac_common_utils.iac_round(l_current_db.reval_reserve_backlog,l_det_balances.book_type_code)) THEN
1179: RETURN FALSE;
1180: END IF;
1181: IF NOT (igi_iac_common_utils.iac_round(l_current_db.reval_reserve_gen_fund,l_det_balances.book_type_code)) THEN
1182: RETURN FALSE;
1183: END IF;
1184: IF NOT (igi_iac_common_utils.iac_round(l_current_db.reval_reserve_net,l_det_balances.book_type_code)) THEN
1185: RETURN FALSE;

Line 1184: IF NOT (igi_iac_common_utils.iac_round(l_current_db.reval_reserve_net,l_det_balances.book_type_code)) THEN

1180: END IF;
1181: IF NOT (igi_iac_common_utils.iac_round(l_current_db.reval_reserve_gen_fund,l_det_balances.book_type_code)) THEN
1182: RETURN FALSE;
1183: END IF;
1184: IF NOT (igi_iac_common_utils.iac_round(l_current_db.reval_reserve_net,l_det_balances.book_type_code)) THEN
1185: RETURN FALSE;
1186: END IF;
1187: IF NOT (igi_iac_common_utils.iac_round(l_current_db.operating_acct_cost,l_det_balances.book_type_code)) THEN
1188: RETURN FALSE;

Line 1187: IF NOT (igi_iac_common_utils.iac_round(l_current_db.operating_acct_cost,l_det_balances.book_type_code)) THEN

1183: END IF;
1184: IF NOT (igi_iac_common_utils.iac_round(l_current_db.reval_reserve_net,l_det_balances.book_type_code)) THEN
1185: RETURN FALSE;
1186: END IF;
1187: IF NOT (igi_iac_common_utils.iac_round(l_current_db.operating_acct_cost,l_det_balances.book_type_code)) THEN
1188: RETURN FALSE;
1189: END IF;
1190: IF NOT (igi_iac_common_utils.iac_round(l_current_db.operating_acct_backlog,l_det_balances.book_type_code)) THEN
1191: RETURN FALSE;

Line 1190: IF NOT (igi_iac_common_utils.iac_round(l_current_db.operating_acct_backlog,l_det_balances.book_type_code)) THEN

1186: END IF;
1187: IF NOT (igi_iac_common_utils.iac_round(l_current_db.operating_acct_cost,l_det_balances.book_type_code)) THEN
1188: RETURN FALSE;
1189: END IF;
1190: IF NOT (igi_iac_common_utils.iac_round(l_current_db.operating_acct_backlog,l_det_balances.book_type_code)) THEN
1191: RETURN FALSE;
1192: END IF;
1193: IF NOT (igi_iac_common_utils.iac_round(l_current_db.operating_acct_net,l_det_balances.book_type_code)) THEN
1194: RETURN FALSE;

Line 1193: IF NOT (igi_iac_common_utils.iac_round(l_current_db.operating_acct_net,l_det_balances.book_type_code)) THEN

1189: END IF;
1190: IF NOT (igi_iac_common_utils.iac_round(l_current_db.operating_acct_backlog,l_det_balances.book_type_code)) THEN
1191: RETURN FALSE;
1192: END IF;
1193: IF NOT (igi_iac_common_utils.iac_round(l_current_db.operating_acct_net,l_det_balances.book_type_code)) THEN
1194: RETURN FALSE;
1195: END IF;
1196: IF NOT (igi_iac_common_utils.iac_round(l_current_db.operating_acct_ytd,l_det_balances.book_type_code)) THEN
1197: RETURN FALSE;

Line 1196: IF NOT (igi_iac_common_utils.iac_round(l_current_db.operating_acct_ytd,l_det_balances.book_type_code)) THEN

1192: END IF;
1193: IF NOT (igi_iac_common_utils.iac_round(l_current_db.operating_acct_net,l_det_balances.book_type_code)) THEN
1194: RETURN FALSE;
1195: END IF;
1196: IF NOT (igi_iac_common_utils.iac_round(l_current_db.operating_acct_ytd,l_det_balances.book_type_code)) THEN
1197: RETURN FALSE;
1198: END IF;
1199: IF NOT (igi_iac_common_utils.iac_round(l_current_db.deprn_period,l_det_balances.book_type_code)) THEN
1200: RETURN FALSE;

Line 1199: IF NOT (igi_iac_common_utils.iac_round(l_current_db.deprn_period,l_det_balances.book_type_code)) THEN

1195: END IF;
1196: IF NOT (igi_iac_common_utils.iac_round(l_current_db.operating_acct_ytd,l_det_balances.book_type_code)) THEN
1197: RETURN FALSE;
1198: END IF;
1199: IF NOT (igi_iac_common_utils.iac_round(l_current_db.deprn_period,l_det_balances.book_type_code)) THEN
1200: RETURN FALSE;
1201: END IF;
1202: IF NOT (igi_iac_common_utils.iac_round(l_current_db.deprn_ytd,l_det_balances.book_type_code)) THEN
1203: RETURN FALSE;

Line 1202: IF NOT (igi_iac_common_utils.iac_round(l_current_db.deprn_ytd,l_det_balances.book_type_code)) THEN

1198: END IF;
1199: IF NOT (igi_iac_common_utils.iac_round(l_current_db.deprn_period,l_det_balances.book_type_code)) THEN
1200: RETURN FALSE;
1201: END IF;
1202: IF NOT (igi_iac_common_utils.iac_round(l_current_db.deprn_ytd,l_det_balances.book_type_code)) THEN
1203: RETURN FALSE;
1204: END IF;
1205: IF NOT (igi_iac_common_utils.iac_round(l_current_db.deprn_reserve,l_det_balances.book_type_code)) THEN
1206: RETURN FALSE;

Line 1205: IF NOT (igi_iac_common_utils.iac_round(l_current_db.deprn_reserve,l_det_balances.book_type_code)) THEN

1201: END IF;
1202: IF NOT (igi_iac_common_utils.iac_round(l_current_db.deprn_ytd,l_det_balances.book_type_code)) THEN
1203: RETURN FALSE;
1204: END IF;
1205: IF NOT (igi_iac_common_utils.iac_round(l_current_db.deprn_reserve,l_det_balances.book_type_code)) THEN
1206: RETURN FALSE;
1207: END IF;
1208: IF NOT (igi_iac_common_utils.iac_round(l_current_db.deprn_reserve_backlog,l_det_balances.book_type_code)) THEN
1209: RETURN FALSE;

Line 1208: IF NOT (igi_iac_common_utils.iac_round(l_current_db.deprn_reserve_backlog,l_det_balances.book_type_code)) THEN

1204: END IF;
1205: IF NOT (igi_iac_common_utils.iac_round(l_current_db.deprn_reserve,l_det_balances.book_type_code)) THEN
1206: RETURN FALSE;
1207: END IF;
1208: IF NOT (igi_iac_common_utils.iac_round(l_current_db.deprn_reserve_backlog,l_det_balances.book_type_code)) THEN
1209: RETURN FALSE;
1210: END IF;
1211: IF NOT (igi_iac_common_utils.iac_round(l_current_db.general_fund_per,l_det_balances.book_type_code)) THEN
1212: RETURN FALSE;

Line 1211: IF NOT (igi_iac_common_utils.iac_round(l_current_db.general_fund_per,l_det_balances.book_type_code)) THEN

1207: END IF;
1208: IF NOT (igi_iac_common_utils.iac_round(l_current_db.deprn_reserve_backlog,l_det_balances.book_type_code)) THEN
1209: RETURN FALSE;
1210: END IF;
1211: IF NOT (igi_iac_common_utils.iac_round(l_current_db.general_fund_per,l_det_balances.book_type_code)) THEN
1212: RETURN FALSE;
1213: END IF;
1214: IF NOT (igi_iac_common_utils.iac_round(l_current_db.general_fund_acc,l_det_balances.book_type_code)) THEN
1215: RETURN FALSE;

Line 1214: IF NOT (igi_iac_common_utils.iac_round(l_current_db.general_fund_acc,l_det_balances.book_type_code)) THEN

1210: END IF;
1211: IF NOT (igi_iac_common_utils.iac_round(l_current_db.general_fund_per,l_det_balances.book_type_code)) THEN
1212: RETURN FALSE;
1213: END IF;
1214: IF NOT (igi_iac_common_utils.iac_round(l_current_db.general_fund_acc,l_det_balances.book_type_code)) THEN
1215: RETURN FALSE;
1216: END IF;
1217: IF NOT (igi_iac_common_utils.iac_round(l_current_db_fa.deprn_period,l_det_balances.book_type_code)) THEN
1218: RETURN FALSE;

Line 1217: IF NOT (igi_iac_common_utils.iac_round(l_current_db_fa.deprn_period,l_det_balances.book_type_code)) THEN

1213: END IF;
1214: IF NOT (igi_iac_common_utils.iac_round(l_current_db.general_fund_acc,l_det_balances.book_type_code)) THEN
1215: RETURN FALSE;
1216: END IF;
1217: IF NOT (igi_iac_common_utils.iac_round(l_current_db_fa.deprn_period,l_det_balances.book_type_code)) THEN
1218: RETURN FALSE;
1219: END IF;
1220: IF NOT (igi_iac_common_utils.iac_round(l_current_db_fa.deprn_ytd,l_det_balances.book_type_code)) THEN
1221: RETURN FALSE;

Line 1220: IF NOT (igi_iac_common_utils.iac_round(l_current_db_fa.deprn_ytd,l_det_balances.book_type_code)) THEN

1216: END IF;
1217: IF NOT (igi_iac_common_utils.iac_round(l_current_db_fa.deprn_period,l_det_balances.book_type_code)) THEN
1218: RETURN FALSE;
1219: END IF;
1220: IF NOT (igi_iac_common_utils.iac_round(l_current_db_fa.deprn_ytd,l_det_balances.book_type_code)) THEN
1221: RETURN FALSE;
1222: END IF;
1223: IF NOT (igi_iac_common_utils.iac_round(l_current_db_fa.deprn_reserve,l_det_balances.book_type_code)) THEN
1224: RETURN FALSE;

Line 1223: IF NOT (igi_iac_common_utils.iac_round(l_current_db_fa.deprn_reserve,l_det_balances.book_type_code)) THEN

1219: END IF;
1220: IF NOT (igi_iac_common_utils.iac_round(l_current_db_fa.deprn_ytd,l_det_balances.book_type_code)) THEN
1221: RETURN FALSE;
1222: END IF;
1223: IF NOT (igi_iac_common_utils.iac_round(l_current_db_fa.deprn_reserve,l_det_balances.book_type_code)) THEN
1224: RETURN FALSE;
1225: END IF;
1226:
1227: l_remaining_db.adjustment_cost := nvl(l_remaining_db.adjustment_cost,0)

Line 1301: IF NOT (igi_iac_common_utils.iac_round(l_current_db_fa.deprn_period,l_det_balances.book_type_code)) THEN

1297: l_current_db_fa.deprn_period := l_remaining_db_fa.deprn_period;
1298: l_current_db_fa.deprn_ytd := l_remaining_db_fa.deprn_ytd;
1299: l_current_db_fa.deprn_reserve := l_remaining_db_fa.deprn_reserve;
1300:
1301: IF NOT (igi_iac_common_utils.iac_round(l_current_db_fa.deprn_period,l_det_balances.book_type_code)) THEN
1302: RETURN FALSE;
1303: END IF;
1304:
1305: END IF;

Line 1315: IF NOT IGI_IAC_COMMON_UTILS.get_account_ccid

1311: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1312: p_full_path => l_path_name,
1313: p_string => ' +distribution id '|| l_det_balances.distribution_id );
1314:
1315: IF NOT IGI_IAC_COMMON_UTILS.get_account_ccid
1316: ( X_book_type_code => l_det_balances.book_type_code
1317: , X_asset_id => l_det_balances.asset_id
1318: , X_distribution_id => l_det_balances.distribution_id
1319: , X_account_type => 'REVAL_RESERVE_ACCT'

Line 1329: IF NOT IGI_IAC_COMMON_UTILS.get_account_ccid

1325: p_string => ' Error in fetching reval reserve');
1326: RETURN FALSE;
1327: END IF;
1328:
1329: IF NOT IGI_IAC_COMMON_UTILS.get_account_ccid
1330: ( X_book_type_code => l_det_balances.book_type_code
1331: , X_asset_id => l_det_balances.asset_id
1332: , X_distribution_id => l_det_balances.distribution_id
1333: , X_account_type => 'GENERAL_FUND_ACCT'

Line 1343: IF NOT IGI_IAC_COMMON_UTILS.get_account_ccid

1339: p_string => ' Error in fetching general fund');
1340: RETURN FALSE;
1341: END IF;
1342:
1343: IF NOT IGI_IAC_COMMON_UTILS.get_account_ccid
1344: ( X_book_type_code => l_det_balances.book_type_code
1345: , X_asset_id => l_det_balances.asset_id
1346: , X_distribution_id => l_det_balances.distribution_id
1347: , X_account_type => 'BACKLOG_DEPRN_RSV_ACCT'

Line 1357: IF NOT IGI_IAC_COMMON_UTILS.get_account_ccid

1353: p_string => ' Error in fetching backlog deprn rsv acct');
1354: RETURN FALSE;
1355: END IF;
1356:
1357: IF NOT IGI_IAC_COMMON_UTILS.get_account_ccid
1358: ( X_book_type_code => l_det_balances.book_type_code
1359: , X_asset_id => l_det_balances.asset_id
1360: , X_distribution_id => l_det_balances.distribution_id
1361: , X_account_type => 'OPERATING_EXPENSE_ACCT'

Line 1371: IF NOT IGI_IAC_COMMON_UTILS.get_account_ccid

1367: p_string => ' Error in fetching operating expense acct');
1368: RETURN FALSE;
1369: END IF;
1370:
1371: IF NOT IGI_IAC_COMMON_UTILS.get_account_ccid
1372: ( X_book_type_code => l_det_balances.book_type_code
1373: , X_asset_id => l_det_balances.asset_id
1374: , X_distribution_id => l_det_balances.distribution_id
1375: , X_account_type => 'DEPRN_RESERVE_ACCT'

Line 1385: IF NOT IGI_IAC_COMMON_UTILS.get_account_ccid

1381: p_string => ' Error in fetching deprn reserve');
1382: RETURN FALSE;
1383: END IF;
1384:
1385: IF NOT IGI_IAC_COMMON_UTILS.get_account_ccid
1386: ( X_book_type_code => l_det_balances.book_type_code
1387: , X_asset_id => l_det_balances.asset_id
1388: , X_distribution_id => l_det_balances.distribution_id
1389: , X_account_type => 'DEPRN_EXPENSE_ACCT'