77:
78: type iac_reval_asset_params IS RECORD
79: (
80: asset_id fa_additions.asset_id%TYPE DEFAULT 0
81: ,book_type_code fa_book_controls.book_type_code%TYPE DEFAULT NULL
82: ,revaluation_id igi_iac_revaluations.revaluation_id%TYPE DEFAULT 0
83: ,revaluation_rate igi_iac_reval_asset_rules.revaluation_factor%TYPE DEFAULT 0
84: ,revaluation_date igi_iac_revaluations.revaluation_date%TYPE
85: ,period_counter fa_book_controls.last_period_counter%TYPE DEFAULT 0
81: ,book_type_code fa_book_controls.book_type_code%TYPE DEFAULT NULL
82: ,revaluation_id igi_iac_revaluations.revaluation_id%TYPE DEFAULT 0
83: ,revaluation_rate igi_iac_reval_asset_rules.revaluation_factor%TYPE DEFAULT 0
84: ,revaluation_date igi_iac_revaluations.revaluation_date%TYPE
85: ,period_counter fa_book_controls.last_period_counter%TYPE DEFAULT 0
86: ,category_id fa_additions.asset_category_id%TYPE DEFAULT 0
87: ,first_set_adjustment_id igi_iac_adjustments.adjustment_id%TYPE default 0
88: ,second_set_adjustment_id igi_iac_adjustments.adjustment_id%TYPE default 0
89: ,prev_ytd_deprn fa_deprn_summary.ytd_deprn%TYPE default 0
109: ,date_placed_in_service fa_books.date_placed_in_service%TYPE default null
110: ,deprn_periods_elapsed number(15) default 0
111: ,deprn_periods_current_year number(15) default 0
112: ,deprn_periods_prior_year number(15) default 0
113: ,last_period_counter fa_book_controls.last_period_counter%TYPE default 0
114: ,gl_posting_allowed_flag fa_book_controls.gl_posting_allowed_flag%TYPE default null
115: ,ytd_deprn fa_deprn_summary.ytd_deprn%TYPE default 0
116: ,deprn_reserve fa_deprn_summary.deprn_reserve%TYPE default 0
117: ,pys_deprn_reserve fa_deprn_summary.deprn_reserve%TYPE default 0
110: ,deprn_periods_elapsed number(15) default 0
111: ,deprn_periods_current_year number(15) default 0
112: ,deprn_periods_prior_year number(15) default 0
113: ,last_period_counter fa_book_controls.last_period_counter%TYPE default 0
114: ,gl_posting_allowed_flag fa_book_controls.gl_posting_allowed_flag%TYPE default null
115: ,ytd_deprn fa_deprn_summary.ytd_deprn%TYPE default 0
116: ,deprn_reserve fa_deprn_summary.deprn_reserve%TYPE default 0
117: ,pys_deprn_reserve fa_deprn_summary.deprn_reserve%TYPE default 0
118: ,deprn_amount fa_deprn_summary.deprn_amount%TYPE default 0
125:
126: type iac_reval_exception_line IS RECORD
127: (
128: asset_id fa_additions.asset_id%TYPE DEFAULT 0
129: ,book_type_code fa_book_controls.book_type_code%TYPE DEFAULT NULL
130: ,reason varchar2(2000) DEFAULT NULL -- Bug No. 2647561 (Tpradhan) - Increased the length from 200 to 2000
131: );
132:
133: TYPE iac_reval_exceptions is table of iac_reval_exception_line index by binary_integer;
172:
173: type Iac_adj_hist_asset_info IS RECORD
174: (
175: asset_id fa_additions.asset_id%TYPE DEFAULT 0
176: ,book_type_code fa_book_controls.book_type_code%TYPE DEFAULT NULL
177: ,cost fa_books.cost%TYPE default 0
178: ,adjusted_cost fa_books.adjusted_cost%TYPE default 0
179: ,original_cost fa_books.original_cost%TYPE default 0
180: ,salvage_value fa_books.salvage_value%TYPE default 0
186: ,date_placed_in_service fa_books.date_placed_in_service%TYPE default null
187: ,deprn_periods_elapsed number(15) default 0
188: ,deprn_periods_current_year number(15) default 0
189: ,deprn_periods_prior_year number(15) default 0
190: ,last_period_counter fa_book_controls.last_period_counter%TYPE default 0
191: ,gl_posting_allowed_flag fa_book_controls.gl_posting_allowed_flag%TYPE default null
192: ,ytd_deprn fa_deprn_summary.ytd_deprn%TYPE default 0
193: ,deprn_reserve fa_deprn_summary.deprn_reserve%TYPE default 0
194: ,pys_deprn_reserve fa_deprn_summary.deprn_reserve%TYPE default 0
187: ,deprn_periods_elapsed number(15) default 0
188: ,deprn_periods_current_year number(15) default 0
189: ,deprn_periods_prior_year number(15) default 0
190: ,last_period_counter fa_book_controls.last_period_counter%TYPE default 0
191: ,gl_posting_allowed_flag fa_book_controls.gl_posting_allowed_flag%TYPE default null
192: ,ytd_deprn fa_deprn_summary.ytd_deprn%TYPE default 0
193: ,deprn_reserve fa_deprn_summary.deprn_reserve%TYPE default 0
194: ,pys_deprn_reserve fa_deprn_summary.deprn_reserve%TYPE default 0
195: ,deprn_amount fa_deprn_summary.deprn_amount%TYPE default 0
201:
202: type Iac_adj_hist_dist_info IS RECORD
203: (
204: asset_id fa_additions.asset_id%TYPE DEFAULT 0
205: ,book_type_code fa_book_controls.book_type_code%TYPE DEFAULT NULL
206: ,distribution_id fa_deprn_detail.distribution_id%TYPE default 0
207: ,Period_counter fa_deprn_detail.Period_counter%TYPE default 0
208: ,deprn_amount fa_deprn_detail.deprn_amount%TYPE default 0
209: ,ytd_deprn fa_deprn_detail.ytd_deprn%TYPE default 0
211: ,deprn_adjustment_amount fa_deprn_detail.DEPRN_ADJUSTMENT_AMOUNT%TYPE default 0
212: ,deprn_periods_elapsed number(15) default 0
213: ,deprn_periods_current_year number(15) default 0
214: ,deprn_periods_prior_year number(15) default 0
215: ,start_period_counter fa_book_controls.last_period_counter%TYPE default 0
216: ,last_period_counter fa_book_controls.last_period_counter%TYPE default 0
217: ,pys_deprn_reserve fa_deprn_detail.deprn_reserve%TYPE default 0
218: ,current_deprn_reserve fa_deprn_detail.deprn_reserve%TYPE default 0
219: );
212: ,deprn_periods_elapsed number(15) default 0
213: ,deprn_periods_current_year number(15) default 0
214: ,deprn_periods_prior_year number(15) default 0
215: ,start_period_counter fa_book_controls.last_period_counter%TYPE default 0
216: ,last_period_counter fa_book_controls.last_period_counter%TYPE default 0
217: ,pys_deprn_reserve fa_deprn_detail.deprn_reserve%TYPE default 0
218: ,current_deprn_reserve fa_deprn_detail.deprn_reserve%TYPE default 0
219: );
220: