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_FA_DEPRN

Line 637: FROM igi_iac_fa_deprn iadb

633: IS
634: SELECT nvl(sum(iadb.deprn_period), 0) deprn_period,
635: nvl(sum(iadb.deprn_reserve), 0) deprn_reserve,
636: nvl(sum(iadb.deprn_ytd), 0) deprn_ytd
637: FROM igi_iac_fa_deprn iadb
638: WHERE iadb.adjustment_id = cp_adjustment_id
639: AND iadb.active_flag IS NULL;
640:
641: --To fetch depreciation expense from fa_adjustments for the transfer transaction (keep)

Line 881: FROM igi_iac_fa_deprn

877: -- get fa inactive rows for a distribution (keep)
878: CURSOR c_fa_inactive_dist(cp_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE)
879: IS
880: SELECT *
881: FROM igi_iac_fa_deprn
882: WHERE adjustment_id = cp_adjustment_id
883: AND book_type_code = p_book_type_code
884: AND asset_id = p_asset_id
885: AND active_flag = 'N';

Line 922: igi_iac_fa_deprn_pkg.insert_row(

918:
919: FOR l_fa_inactive_dist IN c_fa_inactive_dist(p_adjustment_id)
920: LOOP
921: l_rowid := NULL;
922: igi_iac_fa_deprn_pkg.insert_row(
923: x_rowid => l_rowid,
924: x_book_type_code => l_fa_inactive_dist.book_type_code,
925: x_asset_id => l_fa_inactive_dist.asset_id,
926: x_distribution_id => l_fa_inactive_dist.distribution_id,

Line 1079: CURSOR c_fa_dist_data(cp_adjustment_id igi_iac_fa_deprn.adjustment_id%TYPE,

1075: AND bc.book_type_code = p_book_type_code
1076: AND nvl(bc.intercompany_posting_flag,'Y') = 'Y';
1077:
1078: -- Cursor to select the fa amounts for a distribution (keep)
1079: CURSOR c_fa_dist_data(cp_adjustment_id igi_iac_fa_deprn.adjustment_id%TYPE,
1080: cp_dist_id igi_iac_fa_deprn.distribution_id%TYPE)
1081: IS
1082: SELECT *
1083: FROM igi_iac_fa_deprn

Line 1080: cp_dist_id igi_iac_fa_deprn.distribution_id%TYPE)

1076: AND nvl(bc.intercompany_posting_flag,'Y') = 'Y';
1077:
1078: -- Cursor to select the fa amounts for a distribution (keep)
1079: CURSOR c_fa_dist_data(cp_adjustment_id igi_iac_fa_deprn.adjustment_id%TYPE,
1080: cp_dist_id igi_iac_fa_deprn.distribution_id%TYPE)
1081: IS
1082: SELECT *
1083: FROM igi_iac_fa_deprn
1084: WHERE book_type_code = p_asset_hdr_rec.book_type_code

Line 1083: FROM igi_iac_fa_deprn

1079: CURSOR c_fa_dist_data(cp_adjustment_id igi_iac_fa_deprn.adjustment_id%TYPE,
1080: cp_dist_id igi_iac_fa_deprn.distribution_id%TYPE)
1081: IS
1082: SELECT *
1083: FROM igi_iac_fa_deprn
1084: WHERE book_type_code = p_asset_hdr_rec.book_type_code
1085: AND adjustment_id = cp_adjustment_id
1086: AND asset_id = p_asset_hdr_rec.asset_id
1087: AND distribution_id = cp_dist_id;

Line 1193: l_fa_dist_data igi_iac_fa_deprn%ROWTYPE;

1189: l_fa_deprn_expense NUMBER;
1190: l_fa_deprn_expense_old_sum NUMBER;
1191: l_fa_deprn_expense_imp_sum NUMBER;
1192:
1193: l_fa_dist_data igi_iac_fa_deprn%ROWTYPE;
1194: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;
1195: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1196: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;
1197: l_fa_deprn_period_sum igi_iac_fa_deprn.deprn_period%TYPE;

Line 1194: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;

1190: l_fa_deprn_expense_old_sum NUMBER;
1191: l_fa_deprn_expense_imp_sum NUMBER;
1192:
1193: l_fa_dist_data igi_iac_fa_deprn%ROWTYPE;
1194: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;
1195: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1196: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;
1197: l_fa_deprn_period_sum igi_iac_fa_deprn.deprn_period%TYPE;
1198: l_fa_deprn_ytd_sum igi_iac_fa_deprn.deprn_ytd%TYPE;

Line 1195: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

1191: l_fa_deprn_expense_imp_sum NUMBER;
1192:
1193: l_fa_dist_data igi_iac_fa_deprn%ROWTYPE;
1194: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;
1195: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1196: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;
1197: l_fa_deprn_period_sum igi_iac_fa_deprn.deprn_period%TYPE;
1198: l_fa_deprn_ytd_sum igi_iac_fa_deprn.deprn_ytd%TYPE;
1199: l_fa_deprn_reserve_sum igi_iac_fa_deprn.deprn_reserve%TYPE;

Line 1196: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;

1192:
1193: l_fa_dist_data igi_iac_fa_deprn%ROWTYPE;
1194: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;
1195: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1196: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;
1197: l_fa_deprn_period_sum igi_iac_fa_deprn.deprn_period%TYPE;
1198: l_fa_deprn_ytd_sum igi_iac_fa_deprn.deprn_ytd%TYPE;
1199: l_fa_deprn_reserve_sum igi_iac_fa_deprn.deprn_reserve%TYPE;
1200:

Line 1197: l_fa_deprn_period_sum igi_iac_fa_deprn.deprn_period%TYPE;

1193: l_fa_dist_data igi_iac_fa_deprn%ROWTYPE;
1194: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;
1195: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1196: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;
1197: l_fa_deprn_period_sum igi_iac_fa_deprn.deprn_period%TYPE;
1198: l_fa_deprn_ytd_sum igi_iac_fa_deprn.deprn_ytd%TYPE;
1199: l_fa_deprn_reserve_sum igi_iac_fa_deprn.deprn_reserve%TYPE;
1200:
1201: l_get_asset_book c_get_asset_book%ROWTYPE;

Line 1198: l_fa_deprn_ytd_sum igi_iac_fa_deprn.deprn_ytd%TYPE;

1194: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;
1195: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1196: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;
1197: l_fa_deprn_period_sum igi_iac_fa_deprn.deprn_period%TYPE;
1198: l_fa_deprn_ytd_sum igi_iac_fa_deprn.deprn_ytd%TYPE;
1199: l_fa_deprn_reserve_sum igi_iac_fa_deprn.deprn_reserve%TYPE;
1200:
1201: l_get_asset_book c_get_asset_book%ROWTYPE;
1202: l_iac_deprn_period_amount NUMBER;

Line 1199: l_fa_deprn_reserve_sum igi_iac_fa_deprn.deprn_reserve%TYPE;

1195: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1196: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;
1197: l_fa_deprn_period_sum igi_iac_fa_deprn.deprn_period%TYPE;
1198: l_fa_deprn_ytd_sum igi_iac_fa_deprn.deprn_ytd%TYPE;
1199: l_fa_deprn_reserve_sum igi_iac_fa_deprn.deprn_reserve%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;

Line 1303: -- populate igi_iac_fa_deprn table with asset detials if no rows exist for that

1299: RAISE e_no_gl_info;
1300: END IF;
1301: END IF;
1302:
1303: -- populate igi_iac_fa_deprn table with asset detials if no rows exist for that
1304: -- asset
1305: IF NOT igi_iac_common_utils.populate_iac_fa_deprn_data(p_asset_hdr_rec.book_type_code,
1306: 'TRANSFER') THEN
1307: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'*** Error in Synchronizing Depreciation Data ***');

Line 1565: -- now prorate for the impacted dist in igi_iac_fa_deprn

1561: p_op_blog => l_operating_acct_backlog,
1562: p_gf_per => l_general_fund_per
1563: );
1564:
1565: -- now prorate for the impacted dist in igi_iac_fa_deprn
1566: Prorate_amount_for_fa_dist(P_dist_id => l_all_dist.distribution_id,
1567: P_units_dist => l_all_dist.units_assigned,
1568: P_units_total => l_units,
1569: P_ab_amounts => l_iac_fa_dep_amounts,

Line 1624: -- retrieve the values from igi_iac_fa_deprn

1620: l_general_fund_per := l_iac_dist.general_fund_per;
1621: l_reval_reserve_backlog := l_iac_dist.reval_reserve_backlog;
1622: l_operating_acct_backlog:= l_iac_dist.operating_acct_backlog;
1623:
1624: -- retrieve the values from igi_iac_fa_deprn
1625: OPEN c_fa_dist_data(l_prev_adjustment_id,
1626: l_all_dist.distribution_id
1627: );
1628: FETCH c_fa_dist_data INTO l_fa_dist_data;

Line 1686: -- igi_iac_fa_deprn and igi_iac_adjustments

1682: RETURN FALSE;
1683: END IF;
1684:
1685: -- prepare distribution data for igi_iac_det_balances
1686: -- igi_iac_fa_deprn and igi_iac_adjustments
1687: -- Rounding All amounts
1688: IF IGI_IAC_COMMON_UTILS.Iac_round(l_reval_reserve,
1689: p_asset_hdr_rec.book_type_code) THEN
1690: null;

Line 2314: igi_iac_fa_deprn_pkg.insert_row(

2310: l_ab_amounts.last_reval_date
2311: );
2312:
2313: l_rowid := NULL;
2314: igi_iac_fa_deprn_pkg.insert_row(
2315: x_rowid => l_rowid,
2316: x_book_type_code => p_asset_hdr_rec.book_type_code,
2317: x_asset_id => p_asset_hdr_rec.asset_id,
2318: x_distribution_id => l_all_dist.distribution_id,

Line 2374: -- insert into igi_iac_fa_deprn

2370: l_operating_acct_backlog, --0,
2371: l_ab_amounts.last_reval_date
2372: );
2373:
2374: -- insert into igi_iac_fa_deprn
2375: IF l_get_asset_book.period_counter_fully_reserved IS NULL THEN
2376: l_fa_deprn_period_amount := l_fa_deprn_period;
2377: ELSE
2378: l_fa_deprn_period_amount := 0;

Line 2382: igi_iac_fa_deprn_pkg.insert_row(

2378: l_fa_deprn_period_amount := 0;
2379: END IF;
2380:
2381: l_rowid := NULL;
2382: igi_iac_fa_deprn_pkg.insert_row(
2383: x_rowid => l_rowid,
2384: x_book_type_code => p_asset_hdr_rec.book_type_code,
2385: x_asset_id => p_asset_hdr_rec.asset_id,
2386: x_distribution_id => l_all_dist.distribution_id,

Line 2429: -- insert into igi_iac_fa_deprn

2425: l_operating_acct_backlog,
2426: l_ab_amounts.last_reval_date
2427: );
2428:
2429: -- insert into igi_iac_fa_deprn
2430: IF l_get_asset_book.period_counter_fully_reserved IS NULL THEN
2431: l_fa_deprn_period_amount := l_fa_dist_data.deprn_period;
2432: ELSE
2433: l_fa_deprn_period_amount := 0;

Line 2437: igi_iac_fa_deprn_pkg.insert_row(

2433: l_fa_deprn_period_amount := 0;
2434: END IF;
2435:
2436: l_rowid := NULL;
2437: igi_iac_fa_deprn_pkg.insert_row(
2438: x_rowid => l_rowid,
2439: x_book_type_code => p_asset_hdr_rec.book_type_code,
2440: x_asset_id => p_asset_hdr_rec.asset_id,
2441: x_distribution_id => l_all_dist.distribution_id,

Line 2786: cp_asset_id igi_iac_fa_deprn.asset_id%TYPE) IS

2782: FROM igi_iac_det_balances
2783: WHERE adjustment_id=c_adjustment_id;
2784:
2785: CURSOR c_fa_dist(cp_adjustment_id igi_iac_adjustments.adjustment_id%type,
2786: cp_asset_id igi_iac_fa_deprn.asset_id%TYPE) IS
2787: SELECT book_type_code,asset_id,period_counter,distribution_id,adjustment_id
2788: FROM igi_iac_fa_deprn
2789: WHERE asset_id = cp_asset_id
2790: AND book_type_code = p_book_type_code

Line 2788: FROM igi_iac_fa_deprn

2784:
2785: CURSOR c_fa_dist(cp_adjustment_id igi_iac_adjustments.adjustment_id%type,
2786: cp_asset_id igi_iac_fa_deprn.asset_id%TYPE) IS
2787: SELECT book_type_code,asset_id,period_counter,distribution_id,adjustment_id
2788: FROM igi_iac_fa_deprn
2789: WHERE asset_id = cp_asset_id
2790: AND book_type_code = p_book_type_code
2791: AND adjustment_id = cp_adjustment_id;
2792:

Line 2862: IGI_IAC_FA_DEPRN_PKG.delete_row(

2858: );
2859: End loop;
2860:
2861: FOR l_fa_dist IN c_fa_dist(l_trans_headers.adjustment_id,l_trans_headers.asset_id) LOOP
2862: IGI_IAC_FA_DEPRN_PKG.delete_row(
2863: x_adjustment_id =>l_fa_dist.adjustment_id,
2864: x_asset_id =>l_fa_dist.asset_id,
2865: x_distribution_id =>l_fa_dist.distribution_id,
2866: x_book_type_code =>l_fa_dist.book_type_code,