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.

[Home] [Help]

APPS.IGI_IAC_ADJ_COST_REVAL_PKG dependencies on IGI_IAC_FA_DEPRN

Line 226: -- igi_iac_fa_deprn for a adjustment_id and

222: AND iidb.book_type_code = cp_book_type_code
223: AND iidb.active_flag = 'N';
224:
225: -- Cursor to fetch depreciation balances from
226: -- igi_iac_fa_deprn for a adjustment_id and
227: -- distribution_id
228: CURSOR c_get_fa_deprn(cp_adjustment_id igi_iac_fa_deprn.adjustment_id%TYPE,
229: cp_distribution_id igi_iac_fa_deprn.distribution_id%TYPE)
230: IS

Line 228: CURSOR c_get_fa_deprn(cp_adjustment_id igi_iac_fa_deprn.adjustment_id%TYPE,

224:
225: -- Cursor to fetch depreciation balances from
226: -- igi_iac_fa_deprn for a adjustment_id and
227: -- distribution_id
228: CURSOR c_get_fa_deprn(cp_adjustment_id igi_iac_fa_deprn.adjustment_id%TYPE,
229: cp_distribution_id igi_iac_fa_deprn.distribution_id%TYPE)
230: IS
231: SELECT iifd.deprn_ytd
232: FROM igi_iac_fa_deprn iifd

Line 229: cp_distribution_id igi_iac_fa_deprn.distribution_id%TYPE)

225: -- Cursor to fetch depreciation balances from
226: -- igi_iac_fa_deprn for a adjustment_id and
227: -- distribution_id
228: CURSOR c_get_fa_deprn(cp_adjustment_id igi_iac_fa_deprn.adjustment_id%TYPE,
229: cp_distribution_id igi_iac_fa_deprn.distribution_id%TYPE)
230: IS
231: SELECT iifd.deprn_ytd
232: FROM igi_iac_fa_deprn iifd
233: WHERE iifd.adjustment_id = cp_adjustment_id

Line 232: FROM igi_iac_fa_deprn iifd

228: CURSOR c_get_fa_deprn(cp_adjustment_id igi_iac_fa_deprn.adjustment_id%TYPE,
229: cp_distribution_id igi_iac_fa_deprn.distribution_id%TYPE)
230: IS
231: SELECT iifd.deprn_ytd
232: FROM igi_iac_fa_deprn iifd
233: WHERE iifd.adjustment_id = cp_adjustment_id
234: AND iifd.distribution_id = cp_distribution_id
235: AND iifd.active_flag = 'N';
236:

Line 258: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

254: GROUP BY fdd.distribution_id;
255:
256: -- local variables
257: l_get_ytd c_get_ytd%ROWTYPE;
258: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
259:
260: BEGIN
261: FOR l_get_ytd IN c_get_ytd(p_prev_adj_id,p_asset_id, p_book_type_code) LOOP
262: -- insert into igi_iac_det_balances with reinstatement adjustment_id

Line 293: -- roll forward YTD rows for igi_iac_fa_deprn as well

289: x_cumulative_reval_factor => l_get_ytd.cumulative_reval_factor,
290: x_active_flag => l_get_ytd.active_flag
291: );
292:
293: -- roll forward YTD rows for igi_iac_fa_deprn as well
294: OPEN c_get_fa_deprn(l_get_ytd.adjustment_id,
295: l_get_ytd.distribution_id);
296: FETCH c_get_fa_deprn INTO l_fa_deprn_ytd;
297: IF c_get_fa_deprn%NOTFOUND THEN

Line 309: -- insert into igi_iac_fa_deprn with the new adjustment_id

305: CLOSE c_get_fa_ytd;
306: END IF;
307: CLOSE c_get_fa_deprn;
308:
309: -- insert into igi_iac_fa_deprn with the new adjustment_id
310: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
311: x_rowid => l_rowid,
312: x_book_type_code => p_book_type_code,
313: x_asset_id => p_asset_id,

Line 310: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

306: END IF;
307: CLOSE c_get_fa_deprn;
308:
309: -- insert into igi_iac_fa_deprn with the new adjustment_id
310: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
311: x_rowid => l_rowid,
312: x_book_type_code => p_book_type_code,
313: x_asset_id => p_asset_id,
314: x_period_counter => p_prd_counter,

Line 405: -- igi_iac_fa_deprn

401: AND iidb.active_flag IS NULL
402: ORDER BY iidb.distribution_id;
403:
404: -- cursor to get the latest fa figures from
405: -- igi_iac_fa_deprn
406: CURSOR c_get_fa_iac_deprn(cp_adjustment_id igi_iac_fa_deprn.adjustment_id%TYPE,
407: cp_distribution_id igi_iac_fa_deprn.distribution_id%TYPE)
408: IS
409: SELECT iifd.deprn_ytd,

Line 406: CURSOR c_get_fa_iac_deprn(cp_adjustment_id igi_iac_fa_deprn.adjustment_id%TYPE,

402: ORDER BY iidb.distribution_id;
403:
404: -- cursor to get the latest fa figures from
405: -- igi_iac_fa_deprn
406: CURSOR c_get_fa_iac_deprn(cp_adjustment_id igi_iac_fa_deprn.adjustment_id%TYPE,
407: cp_distribution_id igi_iac_fa_deprn.distribution_id%TYPE)
408: IS
409: SELECT iifd.deprn_ytd,
410: iifd.deprn_period,

Line 407: cp_distribution_id igi_iac_fa_deprn.distribution_id%TYPE)

403:
404: -- cursor to get the latest fa figures from
405: -- igi_iac_fa_deprn
406: CURSOR c_get_fa_iac_deprn(cp_adjustment_id igi_iac_fa_deprn.adjustment_id%TYPE,
407: cp_distribution_id igi_iac_fa_deprn.distribution_id%TYPE)
408: IS
409: SELECT iifd.deprn_ytd,
410: iifd.deprn_period,
411: iifd.deprn_reserve

Line 412: FROM igi_iac_fa_deprn iifd

408: IS
409: SELECT iifd.deprn_ytd,
410: iifd.deprn_period,
411: iifd.deprn_reserve
412: FROM igi_iac_fa_deprn iifd
413: WHERE iifd.adjustment_id = cp_adjustment_id
414: AND iifd.distribution_id = cp_distribution_id
415: AND iifd.active_flag IS NULL;
416:

Line 463: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;

459: l_new_dist_rr_net igi_iac_det_balances.reval_reserve_net%TYPE;
460: l_new_dist_op_cost igi_iac_det_balances.operating_acct_cost%TYPE;
461: l_new_dist_op_net igi_iac_det_balances.operating_acct_net%TYPE;
462:
463: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;
464: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;
465: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
466:
467: l_dr_cr_flag_c igi_iac_adjustments.dr_cr_flag%TYPE;

Line 464: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;

460: l_new_dist_op_cost igi_iac_det_balances.operating_acct_cost%TYPE;
461: l_new_dist_op_net igi_iac_det_balances.operating_acct_net%TYPE;
462:
463: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;
464: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;
465: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
466:
467: l_dr_cr_flag_c igi_iac_adjustments.dr_cr_flag%TYPE;
468: l_dr_cr_flag_ro igi_iac_adjustments.dr_cr_flag%TYPE;

Line 465: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;

461: l_new_dist_op_net igi_iac_det_balances.operating_acct_net%TYPE;
462:
463: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;
464: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;
465: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
466:
467: l_dr_cr_flag_c igi_iac_adjustments.dr_cr_flag%TYPE;
468: l_dr_cr_flag_ro igi_iac_adjustments.dr_cr_flag%TYPE;
469: l_adjust_type VARCHAR2(15);

Line 804: -- create distributions for igi_iac_fa_deprn for the new adjustment_id as well

800: x_active_flag => null,
801: x_mode => 'R'
802: );
803:
804: -- create distributions for igi_iac_fa_deprn for the new adjustment_id as well
805: OPEN c_get_fa_iac_deprn(l_det_bal.adjustment_id,
806: l_det_bal.distribution_id);
807: FETCH c_get_fa_iac_deprn INTO l_fa_deprn_ytd, l_fa_deprn_period, l_fa_deprn_reserve;
808: IF c_get_fa_iac_deprn%NOTFOUND THEN

Line 821: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

817: END LOOP;
818: END IF;
819: CLOSE c_get_fa_iac_deprn;
820:
821: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
822: x_rowid => l_rowid,
823: x_book_type_code => l_book_type_code,
824: x_asset_id => l_asset_id,
825: x_period_counter => l_last_period_counter,