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 135: FUNCTION Chk_Asset_Life(p_book_code fa_books.book_type_code%TYPE,

131: -- -------------------------------------------------------------------
132: -- FUNCTION Chk_Asset_Life: Find if the life of asset is completed in
133: -- the given period
134: -- -------------------------------------------------------------------
135: FUNCTION Chk_Asset_Life(p_book_code fa_books.book_type_code%TYPE,
136: p_period_counter fa_deprn_periods.period_counter%TYPE,
137: p_asset_id fa_books.asset_id%TYPE,
138: l_last_period_counter OUT NOCOPY fa_deprn_periods.period_counter%TYPE
139: )

Line 137: p_asset_id fa_books.asset_id%TYPE,

133: -- the given period
134: -- -------------------------------------------------------------------
135: FUNCTION Chk_Asset_Life(p_book_code fa_books.book_type_code%TYPE,
136: p_period_counter fa_deprn_periods.period_counter%TYPE,
137: p_asset_id fa_books.asset_id%TYPE,
138: l_last_period_counter OUT NOCOPY fa_deprn_periods.period_counter%TYPE
139: )
140: RETURN BOOLEAN
141: IS

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

139: )
140: RETURN BOOLEAN
141: IS
142:
143: CURSOR c_get_asset_det(n_book_code fa_books.book_type_code%TYPE,
144: n_asset_id fa_books.asset_id%TYPE
145: )
146: IS
147: SELECT date_placed_in_service,

Line 144: n_asset_id fa_books.asset_id%TYPE

140: RETURN BOOLEAN
141: IS
142:
143: CURSOR c_get_asset_det(n_book_code fa_books.book_type_code%TYPE,
144: n_asset_id fa_books.asset_id%TYPE
145: )
146: IS
147: SELECT date_placed_in_service,
148: life_in_months

Line 149: FROM fa_books

145: )
146: IS
147: SELECT date_placed_in_service,
148: life_in_months
149: FROM fa_books
150: WHERE book_type_code = n_book_code
151: AND asset_id = n_asset_id
152: AND transaction_header_id_out IS NULL;
153:

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

150: WHERE book_type_code = n_book_code
151: AND asset_id = n_asset_id
152: AND transaction_header_id_out IS NULL;
153:
154: CURSOR c_get_periods_in_year(n_book_code fa_books.book_type_code%TYPE)
155: IS
156: SELECT number_per_fiscal_year
157: FROM fa_calendar_types
158: WHERE calendar_type = (SELECT deprn_calendar

Line 394: cp_asset_id fa_books.asset_id%TYPE,

390: AND period_counter = cp_period_counter;
391:
392: -- cursor to get the detail balances for a distribution
393: CURSOR c_det_bal(cp_adjust_id igi_iac_det_balances.adjustment_id%TYPE,
394: cp_asset_id fa_books.asset_id%TYPE,
395: cp_book_type_code fa_books.book_type_code%TYPE,
396: cp_dist_id igi_iac_det_balances.distribution_id%TYPE)
397: IS
398: SELECT iidb.adjustment_id,

Line 395: cp_book_type_code fa_books.book_type_code%TYPE,

391:
392: -- cursor to get the detail balances for a distribution
393: CURSOR c_det_bal(cp_adjust_id igi_iac_det_balances.adjustment_id%TYPE,
394: cp_asset_id fa_books.asset_id%TYPE,
395: cp_book_type_code fa_books.book_type_code%TYPE,
396: cp_dist_id igi_iac_det_balances.distribution_id%TYPE)
397: IS
398: SELECT iidb.adjustment_id,
399: iidb.distribution_id,

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

446: WHERE adjustment_id = cp_latest_adj_id;
447:
448:
449: -- cursor to check if asset is non depreciating
450: /* CURSOR c_asset_non_depr(cp_asset_id fa_books.asset_id%TYPE,
451: cp_book_type_code fa_books.book_type_code%TYPE)
452: IS
453: SELECT depreciate_flag
454: FROM fa_books

Line 451: cp_book_type_code fa_books.book_type_code%TYPE)

447:
448:
449: -- cursor to check if asset is non depreciating
450: /* CURSOR c_asset_non_depr(cp_asset_id fa_books.asset_id%TYPE,
451: cp_book_type_code fa_books.book_type_code%TYPE)
452: IS
453: SELECT depreciate_flag
454: FROM fa_books
455: WHERE book_type_code = cp_book_type_code

Line 454: FROM fa_books

450: /* CURSOR c_asset_non_depr(cp_asset_id fa_books.asset_id%TYPE,
451: cp_book_type_code fa_books.book_type_code%TYPE)
452: IS
453: SELECT depreciate_flag
454: FROM fa_books
455: WHERE book_type_code = cp_book_type_code
456: AND asset_id = cp_asset_id
457: AND date_ineffective IS NULL;
458: */

Line 460: l_asset_id fa_books.asset_id%TYPE;

456: AND asset_id = cp_asset_id
457: AND date_ineffective IS NULL;
458: */
459: -- local variables
460: l_asset_id fa_books.asset_id%TYPE;
461: l_book_type_code fa_books.book_type_code%TYPE;
462: l_fully_rsvd_pc fa_books.period_counter_fully_reserved%TYPE;
463: -- l_deprn_flag fa_books.depreciate_flag%TYPE;
464: l_adj_id_out igi_iac_transaction_headers.adjustment_id_out%TYPE;

Line 461: l_book_type_code fa_books.book_type_code%TYPE;

457: AND date_ineffective IS NULL;
458: */
459: -- local variables
460: l_asset_id fa_books.asset_id%TYPE;
461: l_book_type_code fa_books.book_type_code%TYPE;
462: l_fully_rsvd_pc fa_books.period_counter_fully_reserved%TYPE;
463: -- l_deprn_flag fa_books.depreciate_flag%TYPE;
464: l_adj_id_out igi_iac_transaction_headers.adjustment_id_out%TYPE;
465:

Line 462: l_fully_rsvd_pc fa_books.period_counter_fully_reserved%TYPE;

458: */
459: -- local variables
460: l_asset_id fa_books.asset_id%TYPE;
461: l_book_type_code fa_books.book_type_code%TYPE;
462: l_fully_rsvd_pc fa_books.period_counter_fully_reserved%TYPE;
463: -- l_deprn_flag fa_books.depreciate_flag%TYPE;
464: l_adj_id_out igi_iac_transaction_headers.adjustment_id_out%TYPE;
465:
466: l_latest_trx_type igi_iac_transaction_headers.transaction_type_code%TYPE;

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

459: -- local variables
460: l_asset_id fa_books.asset_id%TYPE;
461: l_book_type_code fa_books.book_type_code%TYPE;
462: l_fully_rsvd_pc fa_books.period_counter_fully_reserved%TYPE;
463: -- l_deprn_flag fa_books.depreciate_flag%TYPE;
464: l_adj_id_out igi_iac_transaction_headers.adjustment_id_out%TYPE;
465:
466: l_latest_trx_type igi_iac_transaction_headers.transaction_type_code%TYPE;
467: l_latest_trx_id igi_iac_transaction_headers.transaction_header_id%TYPE;