96: );
97:
98: type fa_hist_asset_info IS RECORD
99: (
100: cost fa_books.cost%TYPE default 0
101: ,adjusted_cost fa_books.adjusted_cost%TYPE default 0
102: ,original_cost fa_books.original_cost%TYPE default 0
103: ,salvage_value fa_books.salvage_value%TYPE default 0
104: ,life_in_months fa_books.life_in_months%TYPE default 0
97:
98: type fa_hist_asset_info IS RECORD
99: (
100: cost fa_books.cost%TYPE default 0
101: ,adjusted_cost fa_books.adjusted_cost%TYPE default 0
102: ,original_cost fa_books.original_cost%TYPE default 0
103: ,salvage_value fa_books.salvage_value%TYPE default 0
104: ,life_in_months fa_books.life_in_months%TYPE default 0
105: ,rate_adjustment_factor fa_books.rate_adjustment_factor%TYPE default 0
98: type fa_hist_asset_info IS RECORD
99: (
100: cost fa_books.cost%TYPE default 0
101: ,adjusted_cost fa_books.adjusted_cost%TYPE default 0
102: ,original_cost fa_books.original_cost%TYPE default 0
103: ,salvage_value fa_books.salvage_value%TYPE default 0
104: ,life_in_months fa_books.life_in_months%TYPE default 0
105: ,rate_adjustment_factor fa_books.rate_adjustment_factor%TYPE default 0
106: ,period_counter_fully_reserved fa_books.period_counter_fully_reserved%TYPE default 0
99: (
100: cost fa_books.cost%TYPE default 0
101: ,adjusted_cost fa_books.adjusted_cost%TYPE default 0
102: ,original_cost fa_books.original_cost%TYPE default 0
103: ,salvage_value fa_books.salvage_value%TYPE default 0
104: ,life_in_months fa_books.life_in_months%TYPE default 0
105: ,rate_adjustment_factor fa_books.rate_adjustment_factor%TYPE default 0
106: ,period_counter_fully_reserved fa_books.period_counter_fully_reserved%TYPE default 0
107: ,adjusted_recoverable_cost fa_books.adjusted_recoverable_cost%TYPE default 0
100: cost fa_books.cost%TYPE default 0
101: ,adjusted_cost fa_books.adjusted_cost%TYPE default 0
102: ,original_cost fa_books.original_cost%TYPE default 0
103: ,salvage_value fa_books.salvage_value%TYPE default 0
104: ,life_in_months fa_books.life_in_months%TYPE default 0
105: ,rate_adjustment_factor fa_books.rate_adjustment_factor%TYPE default 0
106: ,period_counter_fully_reserved fa_books.period_counter_fully_reserved%TYPE default 0
107: ,adjusted_recoverable_cost fa_books.adjusted_recoverable_cost%TYPE default 0
108: ,recoverable_cost fa_books.recoverable_cost%TYPE default 0
101: ,adjusted_cost fa_books.adjusted_cost%TYPE default 0
102: ,original_cost fa_books.original_cost%TYPE default 0
103: ,salvage_value fa_books.salvage_value%TYPE default 0
104: ,life_in_months fa_books.life_in_months%TYPE default 0
105: ,rate_adjustment_factor fa_books.rate_adjustment_factor%TYPE default 0
106: ,period_counter_fully_reserved fa_books.period_counter_fully_reserved%TYPE default 0
107: ,adjusted_recoverable_cost fa_books.adjusted_recoverable_cost%TYPE default 0
108: ,recoverable_cost fa_books.recoverable_cost%TYPE default 0
109: ,date_placed_in_service fa_books.date_placed_in_service%TYPE default null
102: ,original_cost fa_books.original_cost%TYPE default 0
103: ,salvage_value fa_books.salvage_value%TYPE default 0
104: ,life_in_months fa_books.life_in_months%TYPE default 0
105: ,rate_adjustment_factor fa_books.rate_adjustment_factor%TYPE default 0
106: ,period_counter_fully_reserved fa_books.period_counter_fully_reserved%TYPE default 0
107: ,adjusted_recoverable_cost fa_books.adjusted_recoverable_cost%TYPE default 0
108: ,recoverable_cost fa_books.recoverable_cost%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
103: ,salvage_value fa_books.salvage_value%TYPE default 0
104: ,life_in_months fa_books.life_in_months%TYPE default 0
105: ,rate_adjustment_factor fa_books.rate_adjustment_factor%TYPE default 0
106: ,period_counter_fully_reserved fa_books.period_counter_fully_reserved%TYPE default 0
107: ,adjusted_recoverable_cost fa_books.adjusted_recoverable_cost%TYPE default 0
108: ,recoverable_cost fa_books.recoverable_cost%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
104: ,life_in_months fa_books.life_in_months%TYPE default 0
105: ,rate_adjustment_factor fa_books.rate_adjustment_factor%TYPE default 0
106: ,period_counter_fully_reserved fa_books.period_counter_fully_reserved%TYPE default 0
107: ,adjusted_recoverable_cost fa_books.adjusted_recoverable_cost%TYPE default 0
108: ,recoverable_cost fa_books.recoverable_cost%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
105: ,rate_adjustment_factor fa_books.rate_adjustment_factor%TYPE default 0
106: ,period_counter_fully_reserved fa_books.period_counter_fully_reserved%TYPE default 0
107: ,adjusted_recoverable_cost fa_books.adjusted_recoverable_cost%TYPE default 0
108: ,recoverable_cost fa_books.recoverable_cost%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
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
119: ,deprn_start_date fa_books.deprn_start_date%TYPE default null
120: ,depreciate_flag fa_books.depreciate_flag%Type default null
121: );
122:
123: subtype iac_reval_rate_params is igi_iac_revaluation_rates%ROWTYPE;
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
119: ,deprn_start_date fa_books.deprn_start_date%TYPE default null
120: ,depreciate_flag fa_books.depreciate_flag%Type default null
121: );
122:
123: subtype iac_reval_rate_params is igi_iac_revaluation_rates%ROWTYPE;
124:
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
181: ,life_in_months fa_books.life_in_months%TYPE default 0
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
181: ,life_in_months fa_books.life_in_months%TYPE default 0
182: ,rate_adjustment_factor fa_books.rate_adjustment_factor%TYPE default 0
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
181: ,life_in_months fa_books.life_in_months%TYPE default 0
182: ,rate_adjustment_factor fa_books.rate_adjustment_factor%TYPE default 0
183: ,period_counter_fully_reserved fa_books.period_counter_fully_reserved%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
181: ,life_in_months fa_books.life_in_months%TYPE default 0
182: ,rate_adjustment_factor fa_books.rate_adjustment_factor%TYPE default 0
183: ,period_counter_fully_reserved fa_books.period_counter_fully_reserved%TYPE default 0
184: ,adjusted_recoverable_cost fa_books.adjusted_recoverable_cost%TYPE default 0
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
181: ,life_in_months fa_books.life_in_months%TYPE default 0
182: ,rate_adjustment_factor fa_books.rate_adjustment_factor%TYPE default 0
183: ,period_counter_fully_reserved fa_books.period_counter_fully_reserved%TYPE default 0
184: ,adjusted_recoverable_cost fa_books.adjusted_recoverable_cost%TYPE default 0
185: ,recoverable_cost fa_books.recoverable_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
181: ,life_in_months fa_books.life_in_months%TYPE default 0
182: ,rate_adjustment_factor fa_books.rate_adjustment_factor%TYPE default 0
183: ,period_counter_fully_reserved fa_books.period_counter_fully_reserved%TYPE default 0
184: ,adjusted_recoverable_cost fa_books.adjusted_recoverable_cost%TYPE default 0
185: ,recoverable_cost fa_books.recoverable_cost%TYPE default 0
186: ,date_placed_in_service fa_books.date_placed_in_service%TYPE default null
179: ,original_cost fa_books.original_cost%TYPE default 0
180: ,salvage_value fa_books.salvage_value%TYPE default 0
181: ,life_in_months fa_books.life_in_months%TYPE default 0
182: ,rate_adjustment_factor fa_books.rate_adjustment_factor%TYPE default 0
183: ,period_counter_fully_reserved fa_books.period_counter_fully_reserved%TYPE default 0
184: ,adjusted_recoverable_cost fa_books.adjusted_recoverable_cost%TYPE default 0
185: ,recoverable_cost fa_books.recoverable_cost%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
180: ,salvage_value fa_books.salvage_value%TYPE default 0
181: ,life_in_months fa_books.life_in_months%TYPE default 0
182: ,rate_adjustment_factor fa_books.rate_adjustment_factor%TYPE default 0
183: ,period_counter_fully_reserved fa_books.period_counter_fully_reserved%TYPE default 0
184: ,adjusted_recoverable_cost fa_books.adjusted_recoverable_cost%TYPE default 0
185: ,recoverable_cost fa_books.recoverable_cost%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
181: ,life_in_months fa_books.life_in_months%TYPE default 0
182: ,rate_adjustment_factor fa_books.rate_adjustment_factor%TYPE default 0
183: ,period_counter_fully_reserved fa_books.period_counter_fully_reserved%TYPE default 0
184: ,adjusted_recoverable_cost fa_books.adjusted_recoverable_cost%TYPE default 0
185: ,recoverable_cost fa_books.recoverable_cost%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
182: ,rate_adjustment_factor fa_books.rate_adjustment_factor%TYPE default 0
183: ,period_counter_fully_reserved fa_books.period_counter_fully_reserved%TYPE default 0
184: ,adjusted_recoverable_cost fa_books.adjusted_recoverable_cost%TYPE default 0
185: ,recoverable_cost fa_books.recoverable_cost%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
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
196: ,deprn_start_date fa_books.deprn_start_date%TYPE default null
197: ,depreciate_flag fa_books.depreciate_flag%Type default null
198: ,deprn_adjustment_amount fa_deprn_detail.deprn_adjustment_amount%TYPE default 0
199:
200: );
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
196: ,deprn_start_date fa_books.deprn_start_date%TYPE default null
197: ,depreciate_flag fa_books.depreciate_flag%Type default null
198: ,deprn_adjustment_amount fa_deprn_detail.deprn_adjustment_amount%TYPE default 0
199:
200: );
201: