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_DET_BALANCES

Line 268: CURSOR c_get_detail_balance(p_asset_id igi_iac_det_balances.asset_id%TYPE

264: FROM fa_additions
265: WHERE asset_id = p_asset_id;
266:
267: /* Cursor to get balance information for each distribution of asset */
268: CURSOR c_get_detail_balance(p_asset_id igi_iac_det_balances.asset_id%TYPE
269: ,p_prev_adjustment_id igi_iac_det_balances.adjustment_id%TYPE) IS
270: SELECT *
271: FROM igi_iac_det_balances
272: WHERE asset_id = p_asset_id

Line 269: ,p_prev_adjustment_id igi_iac_det_balances.adjustment_id%TYPE) IS

265: WHERE asset_id = p_asset_id;
266:
267: /* Cursor to get balance information for each distribution of asset */
268: CURSOR c_get_detail_balance(p_asset_id igi_iac_det_balances.asset_id%TYPE
269: ,p_prev_adjustment_id igi_iac_det_balances.adjustment_id%TYPE) IS
270: SELECT *
271: FROM igi_iac_det_balances
272: WHERE asset_id = p_asset_id
273: AND book_type_code = p_book_type_code

Line 271: FROM igi_iac_det_balances

267: /* Cursor to get balance information for each distribution of asset */
268: CURSOR c_get_detail_balance(p_asset_id igi_iac_det_balances.asset_id%TYPE
269: ,p_prev_adjustment_id igi_iac_det_balances.adjustment_id%TYPE) IS
270: SELECT *
271: FROM igi_iac_det_balances
272: WHERE asset_id = p_asset_id
273: AND book_type_code = p_book_type_code
274: AND adjustment_id = p_prev_adjustment_id ;
275:

Line 277: CURSOR c_get_distribution_units(p_distribution_id igi_iac_det_balances.distribution_id%TYPE) IS

273: AND book_type_code = p_book_type_code
274: AND adjustment_id = p_prev_adjustment_id ;
275:
276: /* Cursor to get number of units assigned for each distribution from FA */
277: CURSOR c_get_distribution_units(p_distribution_id igi_iac_det_balances.distribution_id%TYPE) IS
278: SELECT units_assigned
279: FROM fa_distribution_history
280: WHERE distribution_id = p_distribution_id ;
281:

Line 294: CURSOR c_get_prev_year_inactive_dist(cp_asset_id igi_iac_det_balances.asset_id%TYPE

290: FROM fa_calendar_types
291: WHERE calendar_type = p_calendar_type;
292: /* Bug 2434532 vgadde 28/06/2002 End(1) */
293:
294: CURSOR c_get_prev_year_inactive_dist(cp_asset_id igi_iac_det_balances.asset_id%TYPE
295: ,cp_distribution_id igi_iac_det_balances.distribution_id%TYPE) IS
296: SELECT 'X'
297: FROM igi_iac_det_balances
298: WHERE book_type_code = p_book_type_code

Line 295: ,cp_distribution_id igi_iac_det_balances.distribution_id%TYPE) IS

291: WHERE calendar_type = p_calendar_type;
292: /* Bug 2434532 vgadde 28/06/2002 End(1) */
293:
294: CURSOR c_get_prev_year_inactive_dist(cp_asset_id igi_iac_det_balances.asset_id%TYPE
295: ,cp_distribution_id igi_iac_det_balances.distribution_id%TYPE) IS
296: SELECT 'X'
297: FROM igi_iac_det_balances
298: WHERE book_type_code = p_book_type_code
299: AND asset_id = cp_asset_id

Line 297: FROM igi_iac_det_balances

293:
294: CURSOR c_get_prev_year_inactive_dist(cp_asset_id igi_iac_det_balances.asset_id%TYPE
295: ,cp_distribution_id igi_iac_det_balances.distribution_id%TYPE) IS
296: SELECT 'X'
297: FROM igi_iac_det_balances
298: WHERE book_type_code = p_book_type_code
299: AND asset_id = cp_asset_id
300: AND distribution_id = cp_distribution_id
301: AND period_counter = p_period_counter - 1

Line 330: l_detail_balance igi_iac_det_balances%ROWTYPE;

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;
334: l_category_id fa_additions.asset_category_id%TYPE;

Line 337: l_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE ;

333: l_prev_adjustment_id igi_iac_adjustments.adjustment_id%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;

Line 342: l_reval_rsv_net igi_iac_det_balances.reval_reserve_net%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;
346: l_prd_rec igi_iac_types.prd_rec ;

Line 343: l_reval_rsv_gen_fund igi_iac_det_balances.reval_reserve_gen_fund%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;
346: l_prd_rec igi_iac_types.prd_rec ;
347: l_errbuf varchar2(2000) ;

Line 344: l_gen_fund_per igi_iac_det_balances.general_fund_per%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;
346: l_prd_rec igi_iac_types.prd_rec ;
347: l_errbuf varchar2(2000) ;
348: l_is_first_period boolean ;

Line 345: l_gen_fund_acc igi_iac_det_balances.general_fund_acc%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;
346: l_prd_rec igi_iac_types.prd_rec ;
347: l_errbuf varchar2(2000) ;
348: l_is_first_period boolean ;
349: l_amount number ;

Line 803: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Inserting into igi_iac_det_balances');

799:
800: l_rowid := null ;
801:
802: IF (nvl(l_detail_balance.active_flag,'Y') <> 'N') THEN
803: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Inserting into igi_iac_det_balances');
804: /* Bug 2407393 vgadde 07/06/2002 Start(1) */
805: IF (l_asset_balance.adjusted_cost > 0) THEN
806: l_reval_rsv_net := l_detail_balance.reval_reserve_net - l_amount;
807: l_reval_rsv_gen_fund := l_detail_balance.reval_reserve_gen_fund + l_amount;

Line 818: igi_iac_det_balances_pkg.insert_row(

814: l_gen_fund_per := 0;
815: END IF;
816: /* Bug 2407393 vgadde 07/06/2002 Start(1) */
817:
818: igi_iac_det_balances_pkg.insert_row(
819: X_rowid => l_rowid ,
820: X_adjustment_id => l_adjustment_id ,
821: X_asset_id => l_asset_balance.asset_id ,
822: X_distribution_id => l_detail_balance.distribution_id ,

Line 852: igi_iac_det_balances_pkg.insert_row(

848:
849: IF ((nvl(l_detail_balance.active_flag,'Y') = 'N') AND (NOT l_is_first_period)) THEN
850: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Processing inactive distribution');
851: l_rowid := null;
852: igi_iac_det_balances_pkg.insert_row(
853: X_rowid => l_rowid ,
854: X_adjustment_id => l_adjustment_id ,
855: X_asset_id => l_asset_balance.asset_id ,
856: X_distribution_id => l_detail_balance.distribution_id ,

Line 892: igi_iac_det_balances_pkg.insert_row(

888:
889: IF l_prev_year_inactive_dist IS NULL THEN
890: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Processing inactive distribution in first period');
891: l_rowid := null;
892: igi_iac_det_balances_pkg.insert_row(
893: X_rowid => l_rowid ,
894: X_adjustment_id => l_adjustment_id ,
895: X_asset_id => l_asset_balance.asset_id ,
896: X_distribution_id => l_detail_balance.distribution_id ,