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 FA_DEPRN_DETAIL

Line 207: CURSOR c_fa_deprn_adjust_amt(cp_asset_id fa_deprn_detail.book_type_code%TYPE,

203: AND iifd.distribution_id = cp_distribution_id
204: AND iifd.active_flag IS NULL;
205:
206: -- cursor to get the fa_depreciation adjustment amount
207: CURSOR c_fa_deprn_adjust_amt(cp_asset_id fa_deprn_detail.book_type_code%TYPE,
208: cp_book_type_code fa_deprn_detail.book_type_code%TYPE,
209: cp_period_counter fa_deprn_detail.period_counter%TYPE)
210: IS
211: SELECT SUM(NVL(deprn_amount,0)) deprn_amount,

Line 208: cp_book_type_code fa_deprn_detail.book_type_code%TYPE,

204: AND iifd.active_flag IS NULL;
205:
206: -- cursor to get the fa_depreciation adjustment amount
207: CURSOR c_fa_deprn_adjust_amt(cp_asset_id fa_deprn_detail.book_type_code%TYPE,
208: cp_book_type_code fa_deprn_detail.book_type_code%TYPE,
209: cp_period_counter fa_deprn_detail.period_counter%TYPE)
210: IS
211: SELECT SUM(NVL(deprn_amount,0)) deprn_amount,
212: SUM(NVL(deprn_adjustment_amount,0)) deprn_adjustment_amount,

Line 209: cp_period_counter fa_deprn_detail.period_counter%TYPE)

205:
206: -- cursor to get the fa_depreciation adjustment amount
207: CURSOR c_fa_deprn_adjust_amt(cp_asset_id fa_deprn_detail.book_type_code%TYPE,
208: cp_book_type_code fa_deprn_detail.book_type_code%TYPE,
209: cp_period_counter fa_deprn_detail.period_counter%TYPE)
210: IS
211: SELECT SUM(NVL(deprn_amount,0)) deprn_amount,
212: SUM(NVL(deprn_adjustment_amount,0)) deprn_adjustment_amount,
213: SUM(NVL(deprn_reserve,0)) deprn_reserve

Line 214: FROM fa_deprn_detail

210: IS
211: SELECT SUM(NVL(deprn_amount,0)) deprn_amount,
212: SUM(NVL(deprn_adjustment_amount,0)) deprn_adjustment_amount,
213: SUM(NVL(deprn_reserve,0)) deprn_reserve
214: FROM fa_deprn_detail
215: WHERE book_type_code = cp_book_type_code
216: AND asset_id = cp_asset_id
217: AND period_counter = cp_period_counter;
218:

Line 258: l_fa_deprn_adj_amount fa_deprn_detail.deprn_adjustment_amount%TYPE;

254: l_new_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
255: l_rsvd_pc igi_iac_transaction_headers.period_counter%TYPE;
256: l_iac_asset_bal c_iac_asset_bal%ROWTYPE;
257:
258: l_fa_deprn_adj_amount fa_deprn_detail.deprn_adjustment_amount%TYPE;
259: l_iac_new_deprn_adj_amt igi_iac_asset_balances.deprn_amount%TYPE;
260: l_iac_new_deprn_period igi_iac_asset_balances.deprn_amount%TYPE;
261: l_iac_new_deprn_reserve igi_iac_asset_balances.deprn_reserve%TYPE;
262:

Line 295: l_deprn_amount fa_deprn_detail.deprn_amount%TYPE;

291: l_reval_rsv_ccid igi_iac_adjustments.code_combination_id%TYPE;
292: l_exists NUMBER;
293: l_ret BOOLEAN;
294:
295: l_deprn_amount fa_deprn_detail.deprn_amount%TYPE;
296: l_deprn_reserve fa_deprn_detail.deprn_reserve%TYPE;
297: l_prev_cost fa_books.cost%TYPE;
298: l_prev_salvage fa_books.salvage_value%TYPE;
299: l_curr_cost fa_books.cost%TYPE;

Line 296: l_deprn_reserve fa_deprn_detail.deprn_reserve%TYPE;

292: l_exists NUMBER;
293: l_ret BOOLEAN;
294:
295: l_deprn_amount fa_deprn_detail.deprn_amount%TYPE;
296: l_deprn_reserve fa_deprn_detail.deprn_reserve%TYPE;
297: l_prev_cost fa_books.cost%TYPE;
298: l_prev_salvage fa_books.salvage_value%TYPE;
299: l_curr_cost fa_books.cost%TYPE;
300: l_curr_Salvage fa_books.salvage_value%TYPE;

Line 488: -- fetch from fa_deprn_detail

484: p_string => 'Latest period counter: '||l_last_period_counter);
485:
486: -- Calculate the new revalued FA depreciation amount
487: IF (p_asset_iac_adj_info.deprn_adjustment_amount = 0) THEN
488: -- fetch from fa_deprn_detail
489: OPEN c_fa_deprn_adjust_amt(l_asset_id,
490: l_book_type_code,
491: l_last_period_counter);
492: FETCH c_fa_deprn_adjust_amt INTO l_deprn_amount,

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

886: FETCH c_get_fa_iac_deprn INTO l_fa_deprn_ytd, l_fa_deprn_period, l_fa_deprn_reserve;
887: IF c_get_fa_iac_deprn%NOTFOUND THEN
888: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
889: p_full_path => l_path_name,
890: p_string => 'Fetching FA deprn detail values for IGI_IAC_FA_DEPRN');
891: l_fa_deprn_period := p_asset_iac_dist_info(l_fa_idx).deprn_adjustment_amount;
892: l_fa_deprn_ytd := p_asset_iac_dist_info(l_fa_idx).ytd_deprn;
893: l_fa_deprn_reserve := p_asset_iac_dist_info(l_fa_idx).deprn_reserve;
894: ELSE

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

893: l_fa_deprn_reserve := p_asset_iac_dist_info(l_fa_idx).deprn_reserve;
894: ELSE
895: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
896: p_full_path => l_path_name,
897: p_string => 'Fetching IAC FA deprn detail values for IGI_IAC_FA_DEPRN');
898: l_fa_deprn_period := l_fa_deprn_adj_amount;
899: l_fa_deprn_ytd := l_fa_deprn_ytd + l_fa_deprn_adj_amount;
900: l_fa_deprn_reserve := l_fa_deprn_reserve + l_fa_deprn_adj_amount;
901: END IF;