APPS.IGI_IAC_TRANSFERS_PKG dependencies on IGI_IAC_ASSET_BALANCES

Line 534: FROM igi_iac_asset_balances iab,

530: iab.general_fund,
531: iab.last_reval_date,
532: iab.current_reval_factor,
533: iab.cumulative_reval_factor
534: FROM igi_iac_asset_balances iab,
535: (SELECT a.book_type_code,
536: a.asset_id,
537: max(a.period_counter) period_counter
538: FROM igi_iac_asset_balances a

Line 538: FROM igi_iac_asset_balances a

534: FROM igi_iac_asset_balances iab,
535: (SELECT a.book_type_code,
536: a.asset_id,
537: max(a.period_counter) period_counter
538: FROM igi_iac_asset_balances a
539: WHERE a.asset_id= p_asset_id
540: AND a.book_type_code= p_book_type_code
541: GROUP BY a.book_type_code, a.asset_id) mpc
542: WHERE iab.asset_id= p_asset_id

Line 605: l_ab_op_exp igi_iac_asset_balances.operating_acct%TYPE;

601: l_iac_fa_deprn c_iac_fa_deprn%ROWTYPE;
602:
603: l_historic_deprn_expense fa_deprn_summary.deprn_amount%TYPE;
604: l_expense_diff igi_iac_det_balances.deprn_period%TYPE;
605: l_ab_op_exp igi_iac_asset_balances.operating_acct%TYPE;
606:
607: l_mesg VARCHAR2(500);
608: l_path varchar2(150);
609:

Line 617: -- from igi_iac_asset_balances

613:
614: l_path := g_path||'Calc_Asset_Amounts';
615:
616: -- Get the IAC position for the asset for the current period counter
617: -- from igi_iac_asset_balances
618: OPEN c_amounts;
619: FETCH c_amounts INTO l_ab_amounts;
620: IF c_amounts%NOTFOUND THEN
621: RAISE NO_DATA_FOUND;

Line 1113: l_deprn_amount igi_iac_asset_balances.deprn_amount%TYPE;

1109:
1110: l_get_asset_book c_get_asset_book%ROWTYPE;
1111: l_iac_deprn_period_amount NUMBER;
1112: l_fa_deprn_period_amount NUMBER;
1113: l_deprn_amount igi_iac_asset_balances.deprn_amount%TYPE;
1114:
1115: l_adj_offset_type igi_iac_adjustments.adjustment_offset_type%TYPE;
1116: l_report_ccid igi_iac_adjustments.report_ccid%TYPE;
1117:

Line 2262: IGI_IAC_ASSET_BALANCES_PKG.update_row (

2258: ELSE
2259: l_iac_deprn_period_amount := 0;
2260: END IF;
2261:
2262: IGI_IAC_ASSET_BALANCES_PKG.update_row (
2263: x_asset_id =>p_asset_hdr_rec.asset_id,
2264: x_book_type_code =>p_asset_hdr_rec.book_type_code,
2265: x_period_counter =>l_current_period_counter,
2266: x_net_book_value =>l_ab_amounts.net_book_value,

Line 2298: IGI_IAC_ASSET_BALANCES_PKG.insert_row (

2294: ELSE
2295: l_iac_deprn_period_amount := 0;
2296: END IF;
2297: l_rowid := NULL;
2298: IGI_IAC_ASSET_BALANCES_PKG.insert_row (
2299: x_rowid => l_rowid,
2300: x_asset_id =>p_asset_hdr_rec.asset_id,
2301: x_book_type_code =>p_asset_hdr_rec.book_type_code,
2302: x_period_counter =>l_current_period_counter,

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

2527:
2528: /* Cursor to find the amounts that need to be transferred to the new dist
2529: created by transfer */
2530:
2531: CURSOR c_amounts(c_period_counter in IGI_IAC_ASSET_BALANCES.period_counter%type,
2532: cp_asset_id IGI_IAC_ASSET_BALANCES.asset_id%TYPE) IS
2533: SELECT *
2534: FROM igi_iac_asset_balances
2535: WHERE asset_id = cp_asset_id

Line 2532: cp_asset_id IGI_IAC_ASSET_BALANCES.asset_id%TYPE) IS

2528: /* Cursor to find the amounts that need to be transferred to the new dist
2529: created by transfer */
2530:
2531: CURSOR c_amounts(c_period_counter in IGI_IAC_ASSET_BALANCES.period_counter%type,
2532: cp_asset_id IGI_IAC_ASSET_BALANCES.asset_id%TYPE) IS
2533: SELECT *
2534: FROM igi_iac_asset_balances
2535: WHERE asset_id = cp_asset_id
2536: AND book_type_code = p_book_type_code

Line 2534: FROM igi_iac_asset_balances

2530:
2531: CURSOR c_amounts(c_period_counter in IGI_IAC_ASSET_BALANCES.period_counter%type,
2532: cp_asset_id IGI_IAC_ASSET_BALANCES.asset_id%TYPE) IS
2533: SELECT *
2534: FROM igi_iac_asset_balances
2535: WHERE asset_id = cp_asset_id
2536: AND book_type_code = p_book_type_code
2537: AND period_counter = p_period_counter;
2538:

Line 2663: IGI_IAC_ASSET_BALANCES_PKG.update_row (

2659: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
2660: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Updating Asset balances ...');
2661: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
2662:
2663: IGI_IAC_ASSET_BALANCES_PKG.update_row (
2664: x_asset_id =>l_trans_headers.asset_id,
2665: x_book_type_code =>p_book_type_code,
2666: x_period_counter =>p_period_counter,
2667: x_net_book_value =>l_amounts.net_book_value,