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
90: ,ytd_deprn_mvmt fa_deprn_summary.ytd_deprn%TYPE default 0
91: ,curr_ytd_deprn_first fa_deprn_summary.ytd_deprn%TYPE default 0
92: ,curr_ytd_deprn_next fa_deprn_summary.ytd_deprn%TYPE default 0
93: ,prev_ytd_opacc fa_deprn_summary.ytd_deprn%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
90: ,ytd_deprn_mvmt fa_deprn_summary.ytd_deprn%TYPE default 0
91: ,curr_ytd_deprn_first fa_deprn_summary.ytd_deprn%TYPE default 0
92: ,curr_ytd_deprn_next fa_deprn_summary.ytd_deprn%TYPE default 0
93: ,prev_ytd_opacc fa_deprn_summary.ytd_deprn%TYPE default 0
94: ,curr_ytd_opacc_first fa_deprn_summary.ytd_deprn%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
90: ,ytd_deprn_mvmt fa_deprn_summary.ytd_deprn%TYPE default 0
91: ,curr_ytd_deprn_first fa_deprn_summary.ytd_deprn%TYPE default 0
92: ,curr_ytd_deprn_next fa_deprn_summary.ytd_deprn%TYPE default 0
93: ,prev_ytd_opacc fa_deprn_summary.ytd_deprn%TYPE default 0
94: ,curr_ytd_opacc_first fa_deprn_summary.ytd_deprn%TYPE default 0
95: ,curr_ytd_opacc_next fa_deprn_summary.ytd_deprn%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
90: ,ytd_deprn_mvmt fa_deprn_summary.ytd_deprn%TYPE default 0
91: ,curr_ytd_deprn_first fa_deprn_summary.ytd_deprn%TYPE default 0
92: ,curr_ytd_deprn_next fa_deprn_summary.ytd_deprn%TYPE default 0
93: ,prev_ytd_opacc fa_deprn_summary.ytd_deprn%TYPE default 0
94: ,curr_ytd_opacc_first fa_deprn_summary.ytd_deprn%TYPE default 0
95: ,curr_ytd_opacc_next fa_deprn_summary.ytd_deprn%TYPE default 0
96: );
89: ,prev_ytd_deprn fa_deprn_summary.ytd_deprn%TYPE default 0
90: ,ytd_deprn_mvmt fa_deprn_summary.ytd_deprn%TYPE default 0
91: ,curr_ytd_deprn_first fa_deprn_summary.ytd_deprn%TYPE default 0
92: ,curr_ytd_deprn_next fa_deprn_summary.ytd_deprn%TYPE default 0
93: ,prev_ytd_opacc fa_deprn_summary.ytd_deprn%TYPE default 0
94: ,curr_ytd_opacc_first fa_deprn_summary.ytd_deprn%TYPE default 0
95: ,curr_ytd_opacc_next fa_deprn_summary.ytd_deprn%TYPE default 0
96: );
97:
90: ,ytd_deprn_mvmt fa_deprn_summary.ytd_deprn%TYPE default 0
91: ,curr_ytd_deprn_first fa_deprn_summary.ytd_deprn%TYPE default 0
92: ,curr_ytd_deprn_next fa_deprn_summary.ytd_deprn%TYPE default 0
93: ,prev_ytd_opacc fa_deprn_summary.ytd_deprn%TYPE default 0
94: ,curr_ytd_opacc_first fa_deprn_summary.ytd_deprn%TYPE default 0
95: ,curr_ytd_opacc_next fa_deprn_summary.ytd_deprn%TYPE default 0
96: );
97:
98: type fa_hist_asset_info IS RECORD
91: ,curr_ytd_deprn_first fa_deprn_summary.ytd_deprn%TYPE default 0
92: ,curr_ytd_deprn_next fa_deprn_summary.ytd_deprn%TYPE default 0
93: ,prev_ytd_opacc fa_deprn_summary.ytd_deprn%TYPE default 0
94: ,curr_ytd_opacc_first fa_deprn_summary.ytd_deprn%TYPE default 0
95: ,curr_ytd_opacc_next fa_deprn_summary.ytd_deprn%TYPE default 0
96: );
97:
98: type fa_hist_asset_info IS RECORD
99: (
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
119: ,deprn_start_date fa_books.deprn_start_date%TYPE default null
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
119: ,deprn_start_date fa_books.deprn_start_date%TYPE default null
120: ,depreciate_flag fa_books.depreciate_flag%Type default null
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
119: ,deprn_start_date fa_books.deprn_start_date%TYPE default null
120: ,depreciate_flag fa_books.depreciate_flag%Type default null
121: );
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
119: ,deprn_start_date fa_books.deprn_start_date%TYPE default null
120: ,depreciate_flag fa_books.depreciate_flag%Type default null
121: );
122:
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
196: ,deprn_start_date fa_books.deprn_start_date%TYPE default null
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
196: ,deprn_start_date fa_books.deprn_start_date%TYPE default null
197: ,depreciate_flag fa_books.depreciate_flag%Type default null
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
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
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
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: