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_DEPRN_PKG dependencies on IGI_IAC_ASSET_BALANCES

Line 142: FROM igi_iac_asset_balances ab

138: AND bk.depreciate_flag = 'NO'
139: AND bk.adjustment_required_status = 'ADD'
140: AND bk.asset_id = ad.asset_id
141: AND NOT EXISTS (SELECT 'X'
142: FROM igi_iac_asset_balances ab
143: WHERE book_type_code = p_book_type_code
144: AND ab.asset_id = bk.asset_id);
145: l_path VARCHAR2(100);
146:

Line 245: CURSOR c_get_max_period_counter(p_asset_id igi_iac_asset_balances.asset_id%TYPE) IS

241: AND book_type_code = p_book_type_code
242: AND adjustment_id_out is NULL ;
243:
244: /* Cursor to get the latest period for the asset for which balances exist */
245: CURSOR c_get_max_period_counter(p_asset_id igi_iac_asset_balances.asset_id%TYPE) IS
246: SELECT max(period_counter)
247: FROM igi_iac_asset_balances
248: WHERE asset_id = p_asset_id
249: AND book_type_code = p_book_type_code

Line 247: FROM igi_iac_asset_balances

243:
244: /* Cursor to get the latest period for the asset for which balances exist */
245: CURSOR c_get_max_period_counter(p_asset_id igi_iac_asset_balances.asset_id%TYPE) IS
246: SELECT max(period_counter)
247: FROM igi_iac_asset_balances
248: WHERE asset_id = p_asset_id
249: AND book_type_code = p_book_type_code
250: AND period_counter <= p_period_counter;
251:

Line 253: CURSOR c_get_asset_balance (p_asset_id igi_iac_asset_balances.asset_id%TYPE,

249: AND book_type_code = p_book_type_code
250: AND period_counter <= p_period_counter;
251:
252: /* Cursor to get balance information for the Asset */
253: CURSOR c_get_asset_balance (p_asset_id igi_iac_asset_balances.asset_id%TYPE,
254: p_period_counter igi_iac_asset_balances.period_counter%TYPE ) IS
255: SELECT *
256: FROM igi_iac_asset_balances
257: WHERE asset_id = p_asset_id

Line 254: p_period_counter igi_iac_asset_balances.period_counter%TYPE ) IS

250: AND period_counter <= p_period_counter;
251:
252: /* Cursor to get balance information for the Asset */
253: CURSOR c_get_asset_balance (p_asset_id igi_iac_asset_balances.asset_id%TYPE,
254: p_period_counter igi_iac_asset_balances.period_counter%TYPE ) IS
255: SELECT *
256: FROM igi_iac_asset_balances
257: WHERE asset_id = p_asset_id
258: AND book_type_code = p_book_type_code

Line 256: FROM igi_iac_asset_balances

252: /* Cursor to get balance information for the Asset */
253: CURSOR c_get_asset_balance (p_asset_id igi_iac_asset_balances.asset_id%TYPE,
254: p_period_counter igi_iac_asset_balances.period_counter%TYPE ) IS
255: SELECT *
256: FROM igi_iac_asset_balances
257: WHERE asset_id = p_asset_id
258: AND book_type_code = p_book_type_code
259: AND period_counter = p_period_counter ;
260:

Line 327: l_asset_balance igi_iac_asset_balances%ROWTYPE;

323: l_fully_retired fa_books.period_counter_fully_retired%TYPE ;
324: l_life_in_months fa_books.life_in_months%TYPE ;
325: l_depreciate_flag fa_books.depreciate_flag%TYPE;
326: l_prev_life_months fa_books.life_in_months%TYPE ;
327: l_asset_balance igi_iac_asset_balances%ROWTYPE;
328: l_asset_balance_next igi_iac_asset_balances%ROWTYPE;
329: l_asset_balance_curr igi_iac_asset_balances%ROWTYPE;
330: l_detail_balance igi_iac_det_balances%ROWTYPE;
331: l_adjustment_id igi_iac_adjustments.adjustment_id%TYPE;

Line 328: l_asset_balance_next igi_iac_asset_balances%ROWTYPE;

324: l_life_in_months fa_books.life_in_months%TYPE ;
325: l_depreciate_flag fa_books.depreciate_flag%TYPE;
326: l_prev_life_months fa_books.life_in_months%TYPE ;
327: l_asset_balance igi_iac_asset_balances%ROWTYPE;
328: l_asset_balance_next igi_iac_asset_balances%ROWTYPE;
329: l_asset_balance_curr igi_iac_asset_balances%ROWTYPE;
330: l_detail_balance igi_iac_det_balances%ROWTYPE;
331: l_adjustment_id igi_iac_adjustments.adjustment_id%TYPE;
332: l_adjustment_id_out igi_iac_adjustments.adjustment_id%TYPE;

Line 329: l_asset_balance_curr igi_iac_asset_balances%ROWTYPE;

325: l_depreciate_flag fa_books.depreciate_flag%TYPE;
326: l_prev_life_months fa_books.life_in_months%TYPE ;
327: l_asset_balance igi_iac_asset_balances%ROWTYPE;
328: l_asset_balance_next igi_iac_asset_balances%ROWTYPE;
329: l_asset_balance_curr igi_iac_asset_balances%ROWTYPE;
330: l_detail_balance igi_iac_det_balances%ROWTYPE;
331: l_adjustment_id igi_iac_adjustments.adjustment_id%TYPE;
332: l_adjustment_id_out igi_iac_adjustments.adjustment_id%TYPE;
333: l_prev_adjustment_id igi_iac_adjustments.adjustment_id%TYPE;

Line 338: l_deprn_amount igi_iac_asset_balances.deprn_amount%TYPE;

334: l_category_id fa_additions.asset_category_id%TYPE;
335: l_asset_units fa_additions.current_units%TYPE;
336: l_distribution_units fa_distribution_history.units_assigned%TYPE;
337: l_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE ;
338: l_deprn_amount igi_iac_asset_balances.deprn_amount%TYPE;
339: l_deprn_adj_amount fa_deprn_detail.deprn_adjustment_amount%TYPE;
340: l_reval_reserve igi_iac_asset_balances.reval_reserve%TYPE;
341: l_general_fund igi_iac_asset_balances.general_fund%TYPE;
342: l_reval_rsv_net igi_iac_det_balances.reval_reserve_net%TYPE;

Line 340: l_reval_reserve igi_iac_asset_balances.reval_reserve%TYPE;

336: l_distribution_units fa_distribution_history.units_assigned%TYPE;
337: l_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE ;
338: l_deprn_amount igi_iac_asset_balances.deprn_amount%TYPE;
339: l_deprn_adj_amount fa_deprn_detail.deprn_adjustment_amount%TYPE;
340: l_reval_reserve igi_iac_asset_balances.reval_reserve%TYPE;
341: l_general_fund igi_iac_asset_balances.general_fund%TYPE;
342: l_reval_rsv_net igi_iac_det_balances.reval_reserve_net%TYPE;
343: l_reval_rsv_gen_fund igi_iac_det_balances.reval_reserve_gen_fund%TYPE;
344: l_gen_fund_per igi_iac_det_balances.general_fund_per%TYPE;

Line 341: l_general_fund igi_iac_asset_balances.general_fund%TYPE;

337: l_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE ;
338: l_deprn_amount igi_iac_asset_balances.deprn_amount%TYPE;
339: l_deprn_adj_amount fa_deprn_detail.deprn_adjustment_amount%TYPE;
340: l_reval_reserve igi_iac_asset_balances.reval_reserve%TYPE;
341: l_general_fund igi_iac_asset_balances.general_fund%TYPE;
342: l_reval_rsv_net igi_iac_det_balances.reval_reserve_net%TYPE;
343: l_reval_rsv_gen_fund igi_iac_det_balances.reval_reserve_gen_fund%TYPE;
344: l_gen_fund_per igi_iac_det_balances.general_fund_per%TYPE;
345: l_gen_fund_acc igi_iac_det_balances.general_fund_acc%TYPE;

Line 358: l_dpis_period_counter igi_iac_asset_balances.period_counter%TYPE;

354: l_set_of_books_id number(15) ;
355: l_chart_of_accts_id number(15) ;
356: l_currency_code varchar2(15) ;
357: l_precision varchar2(1) ;
358: l_dpis_period_counter igi_iac_asset_balances.period_counter%TYPE;
359: l_deprn_calendar fa_calendar_types.calendar_type%TYPE;
360: l_periods_in_year fa_calendar_types.number_per_fiscal_year%TYPE;
361: l_total_periods NUMBER;
362: l_last_period_counter NUMBER;

Line 391: FUNCTION is_asset_revalued_once(p_asset_id igi_iac_asset_balances.asset_id%TYPE )

387: l_fa_deprn_amount deprn_amount_tbl_type;
388: l_loop_count number;
389: -- Bulk changes
390:
391: FUNCTION is_asset_revalued_once(p_asset_id igi_iac_asset_balances.asset_id%TYPE )
392: RETURN boolean IS
393: /* This function returns True if asset is revalued atleast once in IAC else returns False */
394: CURSOR c_asset_reval_info IS
395: SELECT count(*) from igi_iac_asset_balances

Line 395: SELECT count(*) from igi_iac_asset_balances

391: FUNCTION is_asset_revalued_once(p_asset_id igi_iac_asset_balances.asset_id%TYPE )
392: RETURN boolean IS
393: /* This function returns True if asset is revalued atleast once in IAC else returns False */
394: CURSOR c_asset_reval_info IS
395: SELECT count(*) from igi_iac_asset_balances
396: WHERE asset_id = p_asset_id
397: AND book_type_code = p_book_type_code ;
398:
399: l_reval_count number;

Line 1014: igi_iac_asset_balances_pkg.update_row(

1010: FETCH c_get_asset_balance INTO l_asset_balance_curr;
1011: IF c_get_asset_balance%FOUND THEN
1012:
1013: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Updating asset balances for the current period');
1014: igi_iac_asset_balances_pkg.update_row(
1015: X_asset_id => l_asset_balance.asset_id ,
1016: X_book_type_code => p_book_type_code ,
1017: X_period_counter => p_period_counter ,
1018: X_net_book_value => l_asset_balance.net_book_value - l_deprn_expense ,

Line 1032: igi_iac_asset_balances_pkg.insert_row(

1028: X_cumulative_reval_factor => l_asset_balance.cumulative_reval_factor ) ;
1029: ELSE
1030: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Inserting asset balances for the current period');
1031: l_rowid := NULL;
1032: igi_iac_asset_balances_pkg.insert_row(
1033: X_rowid => l_rowid ,
1034: X_asset_id => l_asset_balance.asset_id ,
1035: X_book_type_code => p_book_type_code ,
1036: X_period_counter => p_period_counter ,

Line 1056: igi_iac_asset_balances_pkg.update_row(

1052: FETCH c_get_asset_balance INTO l_asset_balance_next;
1053: IF c_get_asset_balance%FOUND THEN
1054:
1055: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Updating asset balances for the next period');
1056: igi_iac_asset_balances_pkg.update_row(
1057: X_asset_id => l_asset_balance.asset_id ,
1058: X_book_type_code => p_book_type_code ,
1059: X_period_counter => p_period_counter + 1 ,
1060: X_net_book_value => l_asset_balance.net_book_value - l_deprn_expense ,

Line 1074: igi_iac_asset_balances_pkg.insert_row(

1070: X_cumulative_reval_factor => l_asset_balance.cumulative_reval_factor ) ;
1071: ELSE
1072: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Inserting asset balances for the next period');
1073: l_rowid := NULL;
1074: igi_iac_asset_balances_pkg.insert_row(
1075: X_rowid => l_rowid ,
1076: X_asset_id => l_asset_balance.asset_id ,
1077: X_book_type_code => p_book_type_code ,
1078: X_period_counter => p_period_counter + 1 ,