40: RETURN BOOLEAN AS
41: l_ret_flag BOOLEAN;
42: BEGIN
43:
44: l_ret_flag := igi_iac_common_utils.get_Period_Info_for_Counter( P_book_type_Code,
45: p_period_Counter,
46: P_prd_rec );
47: RETURN TRUE;
48:
375: FETCH c_get_dpis INTO l_dpis;
376: CLOSE c_get_dpis;
377:
378: -- Get the period info for the dpis
379: l_ret_flag := igi_iac_common_utils.Get_period_info_for_date(p_book_code,
380: l_dpis,
381: l_dpis_prd_rec
382: );
383:
521: FETCH c_get_periods_in_year INTO l_periods_in_year;
522: CLOSE c_get_periods_in_year;
523:
524: -- Get the period info for the dpis
525: l_ret_flag := igi_iac_common_utils.Get_period_info_for_date(p_book_code,
526: l_asset_rec.date_placed_in_service,
527: l_dpis_prd_rec
528: );
529: l_total_periods := ceil((l_asset_rec.life_in_months*l_periods_in_year)/12);
981: END IF;
982: CLOSE c_get_proj;
983:
984: -- get period name for start period counter
985: l_ret_flag := igi_iac_common_utils.get_period_info_for_counter( l_book_type_code,
986: l_start_period_counter,
987: l_prd_rec );
988: l_start_period_name := l_prd_rec.period_name;
989:
987: l_prd_rec );
988: l_start_period_name := l_prd_rec.period_name;
989:
990: -- get period name for end period counter
991: l_ret_flag := igi_iac_common_utils.get_period_info_for_counter( l_book_type_code,
992: l_end_period_counter,
993: l_prd_rec );
994:
995: l_end_period_name := l_prd_rec.period_name;
1057: END IF;
1058: CLOSE c_get_asset_dpis;
1059:
1060: -- get the period counter associated with the dpis
1061: l_ret_flag := igi_iac_common_utils.get_period_info_for_date(l_book_type_code,
1062: l_asset_dpis_date,
1063: l_dpis_info_rec);
1064:
1065: -- check if the asset is fully reserved
1088: END IF;
1089:
1090: -- bug 3188025, end 2
1091: -- To get company name in company
1092: l_ret_flag := igi_iac_common_utils.get_account_segment_value(l_sob_id,
1093: l_get_asset_bal_rec.code_combination_id,
1094: 'GL_BALANCING',
1095: l_company_seg);
1096:
1094: 'GL_BALANCING',
1095: l_company_seg);
1096:
1097: -- To get cost center in l_cost_center
1098: l_ret_flag := igi_iac_common_utils.get_account_segment_value(l_sob_id,
1099: l_get_asset_bal_rec.code_combination_id,
1100: 'FA_COST_CTR',
1101: l_cc_seg);
1102:
1290: l_proj_rec.asset_exception(l_count) := 'NON_DEPR_ASSET';
1291: END IF;
1292:
1293: -- round the calculated amounts
1294: l_ret_flag := igi_iac_common_utils.iac_round(l_proj_rec.latest_reval_cost(l_count),l_book_type_code);
1295: l_ret_flag := igi_iac_common_utils.iac_round(l_proj_rec.deprn_period(l_count),l_book_type_code);
1296: l_ret_flag := igi_iac_common_utils.iac_round(l_proj_rec.deprn_ytd(l_count),l_book_type_code);
1297:
1298: -- Get the next period ctr and store it in l_next_period_ctr
1291: END IF;
1292:
1293: -- round the calculated amounts
1294: l_ret_flag := igi_iac_common_utils.iac_round(l_proj_rec.latest_reval_cost(l_count),l_book_type_code);
1295: l_ret_flag := igi_iac_common_utils.iac_round(l_proj_rec.deprn_period(l_count),l_book_type_code);
1296: l_ret_flag := igi_iac_common_utils.iac_round(l_proj_rec.deprn_ytd(l_count),l_book_type_code);
1297:
1298: -- Get the next period ctr and store it in l_next_period_ctr
1299: get_next_period_ctr(l_period_info_rec,l_book_type_code,l_next_period_ctr);
1292:
1293: -- round the calculated amounts
1294: l_ret_flag := igi_iac_common_utils.iac_round(l_proj_rec.latest_reval_cost(l_count),l_book_type_code);
1295: l_ret_flag := igi_iac_common_utils.iac_round(l_proj_rec.deprn_period(l_count),l_book_type_code);
1296: l_ret_flag := igi_iac_common_utils.iac_round(l_proj_rec.deprn_ytd(l_count),l_book_type_code);
1297:
1298: -- Get the next period ctr and store it in l_next_period_ctr
1299: get_next_period_ctr(l_period_info_rec,l_book_type_code,l_next_period_ctr);
1300: