eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGI_IAC_ADJ_AMORT_PKG dependencies on IGI_IAC_FA_DEPRN

Line 217: -- igi_iac_fa_deprn

213: AND iidb.active_flag IS NULL
214: ORDER BY iidb.distribution_id;
215:
216: -- cursor to get the latest fa figures from
217: -- igi_iac_fa_deprn
218: CURSOR c_get_fa_iac_deprn(cp_distribution_id igi_iac_fa_deprn.distribution_id%TYPE,
219: cp_adjustment_id igi_iac_fa_deprn.adjustment_id%TYPE)
220: IS
221: SELECT iifd.deprn_ytd,

Line 218: CURSOR c_get_fa_iac_deprn(cp_distribution_id igi_iac_fa_deprn.distribution_id%TYPE,

214: ORDER BY iidb.distribution_id;
215:
216: -- cursor to get the latest fa figures from
217: -- igi_iac_fa_deprn
218: CURSOR c_get_fa_iac_deprn(cp_distribution_id igi_iac_fa_deprn.distribution_id%TYPE,
219: cp_adjustment_id igi_iac_fa_deprn.adjustment_id%TYPE)
220: IS
221: SELECT iifd.deprn_ytd,
222: iifd.deprn_period,

Line 219: cp_adjustment_id igi_iac_fa_deprn.adjustment_id%TYPE)

215:
216: -- cursor to get the latest fa figures from
217: -- igi_iac_fa_deprn
218: CURSOR c_get_fa_iac_deprn(cp_distribution_id igi_iac_fa_deprn.distribution_id%TYPE,
219: cp_adjustment_id igi_iac_fa_deprn.adjustment_id%TYPE)
220: IS
221: SELECT iifd.deprn_ytd,
222: iifd.deprn_period,
223: iifd.deprn_reserve

Line 224: FROM igi_iac_fa_deprn iifd

220: IS
221: SELECT iifd.deprn_ytd,
222: iifd.deprn_period,
223: iifd.deprn_reserve
224: FROM igi_iac_fa_deprn iifd
225: WHERE iifd.adjustment_id = cp_adjustment_id
226: AND iifd.distribution_id = cp_distribution_id
227: AND iifd.active_flag IS NULL;
228:

Line 309: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;

305: l_new_dist_gf_per igi_iac_det_balances.general_fund_per%TYPE;
306: l_new_dist_gf_acc igi_iac_det_balances.general_fund_acc%TYPE;
307:
308: l_round_diff NUMBER ;
309: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;
310: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;
311: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
312:
313: l_ccid igi_iac_adjustments.code_combination_id%TYPE;

Line 310: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;

306: l_new_dist_gf_acc igi_iac_det_balances.general_fund_acc%TYPE;
307:
308: l_round_diff NUMBER ;
309: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;
310: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;
311: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
312:
313: l_ccid igi_iac_adjustments.code_combination_id%TYPE;
314: l_reval_rsv_ccid igi_iac_adjustments.code_combination_id%TYPE;

Line 311: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

307:
308: l_round_diff NUMBER ;
309: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;
310: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;
311: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
312:
313: l_ccid igi_iac_adjustments.code_combination_id%TYPE;
314: l_reval_rsv_ccid igi_iac_adjustments.code_combination_id%TYPE;
315: l_exists NUMBER;

Line 903: -- do the igi_iac_fa_deprn active distributions

899: END IF; -- reval factor >= 1
900: END IF; -- if iac deprn adjustment amount <> 0
901: END LOOP;
902:
903: -- do the igi_iac_fa_deprn active distributions
904: FOR l_fa_idx IN p_asset_iac_dist_info.FIRST.. p_asset_iac_dist_info.LAST LOOP
905: l_fa_deprn_adj_amount := p_asset_iac_dist_info(l_fa_idx).deprn_adjustment_amount;
906:
907: -- calculate the IAC maintained YTD figures

Line 915: p_string => 'Fetching FA deprn detail values for IGI_IAC_FA_DEPRN');

911: FETCH c_get_fa_iac_deprn INTO l_fa_deprn_ytd, l_fa_deprn_period, l_fa_deprn_reserve;
912: IF c_get_fa_iac_deprn%NOTFOUND THEN
913: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
914: p_full_path => l_path_name,
915: p_string => 'Fetching FA deprn detail values for IGI_IAC_FA_DEPRN');
916: l_fa_deprn_period := p_asset_iac_dist_info(l_fa_idx).deprn_adjustment_amount;
917: l_fa_deprn_ytd := p_asset_iac_dist_info(l_fa_idx).ytd_deprn;
918: l_fa_deprn_reserve := p_asset_iac_dist_info(l_fa_idx).deprn_reserve;
919: ELSE

Line 922: p_string => 'Fetching IAC FA deprn detail values for IGI_IAC_FA_DEPRN');

918: l_fa_deprn_reserve := p_asset_iac_dist_info(l_fa_idx).deprn_reserve;
919: ELSE
920: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
921: p_full_path => l_path_name,
922: p_string => 'Fetching IAC FA deprn detail values for IGI_IAC_FA_DEPRN');
923: l_fa_deprn_period := l_fa_deprn_adj_amount;
924: l_fa_deprn_ytd := l_fa_deprn_ytd + l_fa_deprn_adj_amount;
925: l_fa_deprn_reserve := l_fa_deprn_reserve + l_fa_deprn_adj_amount;
926: END IF;

Line 944: -- insert into igi_iac_fa_deprn

940: l_fa_deprn_period_amount := 0;
941: ELSE
942: l_fa_deprn_period_amount := l_fa_deprn_period;
943: END IF;
944: -- insert into igi_iac_fa_deprn
945: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
946: x_rowid => l_rowid,
947: x_book_type_code => l_book_type_code,
948: x_asset_id => l_asset_id,

Line 945: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

941: ELSE
942: l_fa_deprn_period_amount := l_fa_deprn_period;
943: END IF;
944: -- insert into igi_iac_fa_deprn
945: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
946: x_rowid => l_rowid,
947: x_book_type_code => l_book_type_code,
948: x_asset_id => l_asset_id,
949: x_period_counter => l_last_period_counter,