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

Line 604: FROM igi_iac_asset_balances iab,

600: iab.general_fund,
601: iab.last_reval_date,
602: iab.current_reval_factor,
603: iab.cumulative_reval_factor
604: FROM igi_iac_asset_balances iab,
605: (SELECT a.book_type_code,
606: a.asset_id,
607: max(a.period_counter) period_counter
608: FROM igi_iac_asset_balances a

Line 608: FROM igi_iac_asset_balances a

604: FROM igi_iac_asset_balances iab,
605: (SELECT a.book_type_code,
606: a.asset_id,
607: max(a.period_counter) period_counter
608: FROM igi_iac_asset_balances a
609: WHERE a.asset_id= p_asset_id
610: AND a.book_type_code= p_book_type_code
611: GROUP BY a.book_type_code, a.asset_id) mpc
612: WHERE iab.asset_id= p_asset_id

Line 675: l_ab_op_exp igi_iac_asset_balances.operating_acct%TYPE;

671: l_iac_fa_deprn c_iac_fa_deprn%ROWTYPE;
672:
673: l_historic_deprn_expense fa_deprn_summary.deprn_amount%TYPE;
674: l_expense_diff igi_iac_det_balances.deprn_period%TYPE;
675: l_ab_op_exp igi_iac_asset_balances.operating_acct%TYPE;
676:
677: l_mesg VARCHAR2(500);
678: l_path varchar2(150);
679:

Line 687: -- from igi_iac_asset_balances

683:
684: l_path := g_path||'Calc_Asset_Amounts';
685:
686: -- Get the IAC position for the asset for the current period counter
687: -- from igi_iac_asset_balances
688: OPEN c_amounts;
689: FETCH c_amounts INTO l_ab_amounts;
690: IF c_amounts%NOTFOUND THEN
691: RAISE NO_DATA_FOUND;

Line 1204: l_deprn_amount igi_iac_asset_balances.deprn_amount%TYPE;

1200:
1201: l_get_asset_book c_get_asset_book%ROWTYPE;
1202: l_iac_deprn_period_amount NUMBER;
1203: l_fa_deprn_period_amount NUMBER;
1204: l_deprn_amount igi_iac_asset_balances.deprn_amount%TYPE;
1205:
1206: l_adj_offset_type igi_iac_adjustments.adjustment_offset_type%TYPE;
1207: l_report_ccid igi_iac_adjustments.report_ccid%TYPE;
1208:

Line 1224: from igi_iac_asset_balances

1220: , cp_asset_id in number
1221: , cp_book_type_code in varchar2
1222: ) is
1223: select cumulative_reval_factor, current_reval_factor
1224: from igi_iac_asset_balances
1225: where asset_id = cp_asset_id
1226: and book_type_code = cp_book_type_code
1227: and period_counter = cp_period_counter
1228: ;

Line 2481: IGI_IAC_ASSET_BALANCES_PKG.update_row (

2477: ELSE
2478: l_iac_deprn_period_amount := 0;
2479: END IF;
2480:
2481: IGI_IAC_ASSET_BALANCES_PKG.update_row (
2482: x_asset_id =>p_asset_hdr_rec.asset_id,
2483: x_book_type_code =>p_asset_hdr_rec.book_type_code,
2484: x_period_counter =>l_current_period_counter,
2485: x_net_book_value =>l_ab_amounts.net_book_value,

Line 2518: IGI_IAC_ASSET_BALANCES_PKG.update_row (

2514: l_iac_deprn_period_amount := 0;
2515: END IF;
2516: l_rowid := NULL;
2517: IF l_exists THEN
2518: IGI_IAC_ASSET_BALANCES_PKG.update_row (
2519: x_asset_id =>p_asset_hdr_rec.asset_id,
2520: x_book_type_code =>p_asset_hdr_rec.book_type_code,
2521: x_period_counter =>l_current_period_counter,
2522: x_net_book_value =>l_ab_amounts.net_book_value,

Line 2536: IGI_IAC_ASSET_BALANCES_PKG.insert_row (

2532: x_cumulative_reval_factor =>l_ab_amounts.cumulative_reval_factor,
2533: x_mode =>'R'
2534: );
2535: ELSE
2536: IGI_IAC_ASSET_BALANCES_PKG.insert_row (
2537: x_rowid => l_rowid,
2538: x_asset_id =>p_asset_hdr_rec.asset_id,
2539: x_book_type_code =>p_asset_hdr_rec.book_type_code,
2540: x_period_counter =>l_current_period_counter,

Line 2770: CURSOR c_amounts(c_period_counter in IGI_IAC_ASSET_BALANCES.period_counter%type,

2766:
2767: /* Cursor to find the amounts that need to be transferred to the new dist
2768: created by transfer */
2769:
2770: CURSOR c_amounts(c_period_counter in IGI_IAC_ASSET_BALANCES.period_counter%type,
2771: cp_asset_id IGI_IAC_ASSET_BALANCES.asset_id%TYPE) IS
2772: SELECT *
2773: FROM igi_iac_asset_balances
2774: WHERE asset_id = cp_asset_id

Line 2771: cp_asset_id IGI_IAC_ASSET_BALANCES.asset_id%TYPE) IS

2767: /* Cursor to find the amounts that need to be transferred to the new dist
2768: created by transfer */
2769:
2770: CURSOR c_amounts(c_period_counter in IGI_IAC_ASSET_BALANCES.period_counter%type,
2771: cp_asset_id IGI_IAC_ASSET_BALANCES.asset_id%TYPE) IS
2772: SELECT *
2773: FROM igi_iac_asset_balances
2774: WHERE asset_id = cp_asset_id
2775: AND book_type_code = p_book_type_code

Line 2773: FROM igi_iac_asset_balances

2769:
2770: CURSOR c_amounts(c_period_counter in IGI_IAC_ASSET_BALANCES.period_counter%type,
2771: cp_asset_id IGI_IAC_ASSET_BALANCES.asset_id%TYPE) IS
2772: SELECT *
2773: FROM igi_iac_asset_balances
2774: WHERE asset_id = cp_asset_id
2775: AND book_type_code = p_book_type_code
2776: AND period_counter = p_period_counter;
2777:

Line 2902: IGI_IAC_ASSET_BALANCES_PKG.update_row (

2898: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
2899: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Updating Asset balances ...');
2900: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
2901:
2902: IGI_IAC_ASSET_BALANCES_PKG.update_row (
2903: x_asset_id =>l_trans_headers.asset_id,
2904: x_book_type_code =>p_book_type_code,
2905: x_period_counter =>p_period_counter,
2906: x_net_book_value =>l_amounts.net_book_value,