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_ADJ_COST_REVAL_PKG dependencies on FA_BOOKS

Line 112: FUNCTION Chk_Asset_Life(p_book_code fa_books.book_type_code%TYPE,

108: -- -------------------------------------------------------------------
109: -- FUNCTION Chk_Asset_Life: Find if the life of asset is completed in
110: -- the given period
111: -- -------------------------------------------------------------------
112: FUNCTION Chk_Asset_Life(p_book_code fa_books.book_type_code%TYPE,
113: p_period_counter fa_deprn_periods.period_counter%TYPE,
114: p_asset_id fa_books.asset_id%TYPE,
115: l_last_period_counter OUT NOCOPY fa_deprn_periods.period_counter%TYPE
116: )

Line 114: p_asset_id fa_books.asset_id%TYPE,

110: -- the given period
111: -- -------------------------------------------------------------------
112: FUNCTION Chk_Asset_Life(p_book_code fa_books.book_type_code%TYPE,
113: p_period_counter fa_deprn_periods.period_counter%TYPE,
114: p_asset_id fa_books.asset_id%TYPE,
115: l_last_period_counter OUT NOCOPY fa_deprn_periods.period_counter%TYPE
116: )
117: RETURN BOOLEAN
118: IS

Line 120: CURSOR c_get_asset_det(n_book_code fa_books.book_type_code%TYPE,

116: )
117: RETURN BOOLEAN
118: IS
119:
120: CURSOR c_get_asset_det(n_book_code fa_books.book_type_code%TYPE,
121: n_asset_id fa_books.asset_id%TYPE
122: )
123: IS
124: SELECT date_placed_in_service,

Line 121: n_asset_id fa_books.asset_id%TYPE

117: RETURN BOOLEAN
118: IS
119:
120: CURSOR c_get_asset_det(n_book_code fa_books.book_type_code%TYPE,
121: n_asset_id fa_books.asset_id%TYPE
122: )
123: IS
124: SELECT date_placed_in_service,
125: life_in_months

Line 126: FROM fa_books

122: )
123: IS
124: SELECT date_placed_in_service,
125: life_in_months
126: FROM fa_books
127: WHERE book_type_code = n_book_code
128: AND asset_id = n_asset_id
129: AND transaction_header_id_out IS NULL;
130:

Line 131: CURSOR c_get_periods_in_year(n_book_code fa_books.book_type_code%TYPE)

127: WHERE book_type_code = n_book_code
128: AND asset_id = n_asset_id
129: AND transaction_header_id_out IS NULL;
130:
131: CURSOR c_get_periods_in_year(n_book_code fa_books.book_type_code%TYPE)
132: IS
133: SELECT number_per_fiscal_year
134: FROM fa_calendar_types
135: WHERE calendar_type = (SELECT deprn_calendar

Line 369: cp_asset_id fa_books.asset_id%TYPE,

365: AND period_counter = cp_period_counter;
366:
367: -- cursor to get the detail balances for a distribution
368: CURSOR c_det_bal(cp_adjust_id igi_iac_det_balances.adjustment_id%TYPE,
369: cp_asset_id fa_books.asset_id%TYPE,
370: cp_book_type_code fa_books.book_type_code%TYPE,
371: cp_dist_id igi_iac_det_balances.distribution_id%TYPE)
372: IS
373: SELECT iidb.adjustment_id,

Line 370: cp_book_type_code fa_books.book_type_code%TYPE,

366:
367: -- cursor to get the detail balances for a distribution
368: CURSOR c_det_bal(cp_adjust_id igi_iac_det_balances.adjustment_id%TYPE,
369: cp_asset_id fa_books.asset_id%TYPE,
370: cp_book_type_code fa_books.book_type_code%TYPE,
371: cp_dist_id igi_iac_det_balances.distribution_id%TYPE)
372: IS
373: SELECT iidb.adjustment_id,
374: iidb.distribution_id,

Line 418: /* CURSOR c_asset_non_depr(cp_asset_id fa_books.asset_id%TYPE,

414: AND iifd.distribution_id = cp_distribution_id
415: AND iifd.active_flag IS NULL;
416:
417: -- cursor to check if asset is non depreciating
418: /* CURSOR c_asset_non_depr(cp_asset_id fa_books.asset_id%TYPE,
419: cp_book_type_code fa_books.book_type_code%TYPE)
420: IS
421: SELECT depreciate_flag
422: FROM fa_books

Line 419: cp_book_type_code fa_books.book_type_code%TYPE)

415: AND iifd.active_flag IS NULL;
416:
417: -- cursor to check if asset is non depreciating
418: /* CURSOR c_asset_non_depr(cp_asset_id fa_books.asset_id%TYPE,
419: cp_book_type_code fa_books.book_type_code%TYPE)
420: IS
421: SELECT depreciate_flag
422: FROM fa_books
423: WHERE book_type_code = cp_book_type_code

Line 422: FROM fa_books

418: /* CURSOR c_asset_non_depr(cp_asset_id fa_books.asset_id%TYPE,
419: cp_book_type_code fa_books.book_type_code%TYPE)
420: IS
421: SELECT depreciate_flag
422: FROM fa_books
423: WHERE book_type_code = cp_book_type_code
424: AND asset_id = cp_asset_id
425: AND date_ineffective IS NULL;
426: */

Line 428: l_asset_id fa_books.asset_id%TYPE;

424: AND asset_id = cp_asset_id
425: AND date_ineffective IS NULL;
426: */
427: -- local variables
428: l_asset_id fa_books.asset_id%TYPE;
429: l_book_type_code fa_books.book_type_code%TYPE;
430: l_fully_rsvd_pc fa_books.period_counter_fully_reserved%TYPE;
431: -- l_deprn_flag fa_books.depreciate_flag%TYPE;
432: l_adj_id_out igi_iac_transaction_headers.adjustment_id_out%TYPE;

Line 429: l_book_type_code fa_books.book_type_code%TYPE;

425: AND date_ineffective IS NULL;
426: */
427: -- local variables
428: l_asset_id fa_books.asset_id%TYPE;
429: l_book_type_code fa_books.book_type_code%TYPE;
430: l_fully_rsvd_pc fa_books.period_counter_fully_reserved%TYPE;
431: -- l_deprn_flag fa_books.depreciate_flag%TYPE;
432: l_adj_id_out igi_iac_transaction_headers.adjustment_id_out%TYPE;
433:

Line 430: l_fully_rsvd_pc fa_books.period_counter_fully_reserved%TYPE;

426: */
427: -- local variables
428: l_asset_id fa_books.asset_id%TYPE;
429: l_book_type_code fa_books.book_type_code%TYPE;
430: l_fully_rsvd_pc fa_books.period_counter_fully_reserved%TYPE;
431: -- l_deprn_flag fa_books.depreciate_flag%TYPE;
432: l_adj_id_out igi_iac_transaction_headers.adjustment_id_out%TYPE;
433:
434: l_latest_trx_type igi_iac_transaction_headers.transaction_type_code%TYPE;

Line 431: -- l_deprn_flag fa_books.depreciate_flag%TYPE;

427: -- local variables
428: l_asset_id fa_books.asset_id%TYPE;
429: l_book_type_code fa_books.book_type_code%TYPE;
430: l_fully_rsvd_pc fa_books.period_counter_fully_reserved%TYPE;
431: -- l_deprn_flag fa_books.depreciate_flag%TYPE;
432: l_adj_id_out igi_iac_transaction_headers.adjustment_id_out%TYPE;
433:
434: l_latest_trx_type igi_iac_transaction_headers.transaction_type_code%TYPE;
435: l_latest_trx_id igi_iac_transaction_headers.transaction_header_id%TYPE;