[Home] [Help]
PACKAGE: APPS.IGI_IAC_TYPES
Source
4 /**
1 PACKAGE IGI_IAC_TYPES AUTHID CURRENT_USER AS
2 -- $Header: igiiatys.pls 120.10.12000000.1 2007/08/01 16:19:39 npandya ship $
3
5 -- Constants to hold the value of the revaluation statuses so that it can
6 -- be shared accross pl/sql routines
7 **/
8 gc_preview_status CONSTANT igi_iac_revaluations.status%TYPE := 'PREVIEW';
9 gc_previewed_status CONSTANT igi_iac_revaluations.status%TYPE := 'PREVIEWED';
10 gc_failedpre_status CONSTANT igi_iac_revaluations.status%TYPE := 'FAILED_PRE';
11 gc_running_status CONSTANT igi_iac_revaluations.status%TYPE := 'RUNNING';
12 gc_completed_status CONSTANT igi_iac_revaluations.status%TYPE := 'COMPLETED';
13 gc_failedrun_status CONSTANT igi_iac_revaluations.status%TYPE := 'FAILED_RUN';
14 /**
15 -- Period record contains the full information about the period
16 **/
17 TYPE prd_rec IS RECORD (Period_Name VARCHAR2(30) default null,
18 Period_Counter NUMBER default 0,
19 Period_Num NUMBER default 0,
20 Fiscal_Year NUMBER default 0,
21 Period_Start_Date DATE default null,
22 Period_End_Date DATE default null
23 );
24 /**
28
25 -- this structure is used to show the proration of the asset amount
26 -- across ACTIVE distributions
27 **/
29 TYPE dist_amt IS RECORD ( distribution_id NUMBER, amount NUMBER,units NUMBER,prorate_factor NUMBER);
30 TYPE dist_amt_tab IS TABLE of dist_amt INDEX by BINARY_INTEGER;
31
32 /**
33 -- this structure is used show the prorations of the asset amount across
34 -- ACTIVE and INACTIVE distributions for that year
35 **/
36 TYPE prorate_dists IS RECORD ( distribution_id NUMBER default 0
37 , ytd_prorate_factor NUMBER default 0
38 , normal_prorate_factor NUMBER default 0
39 , latest_period_counter NUMBER default 0
40 , units_assigned NUMBER default 0
41 , units_active NUMBER default 0
42 , active_flag VARCHAR2(1)
43 );
44
45 TYPE prorate_dists_tab IS TABLE of prorate_dists INDEX by BINARY_INTEGER;
46
47 SUBTYPE dh_rec IS fa_distribution_history%ROWTYPE ;
48
49 SUBTYPE iac_reval_asset_rules IS IGI_IAC_REVAL_ASSET_RULES%ROWTYPE;
50 SUBTYPE iac_det_balances IS IGI_IAC_DET_BALANCES%ROWTYPE;
51
52 TYPE dh_tab IS TABLE of dh_rec INDEX BY BINARY_INTEGER ;
53 /** begin revaluation info **/
54 subtype iac_Reval_input_asset is igi_iac_asset_balances%rowtype;
55
56 type iac_reval_mesg_line is record
57 ( line varchar2(100) default null, message_level number);
58
59 type iac_reval_control_type IS RECORD
60 (
61 revaluation_mode VARCHAR2(1) /* Revaluation modes 'P' - Preview */
62 ,transaction_type_code IGI_IAC_TRANSACTION_HEADERS.TRANSACTION_TYPE_CODE%TYPE
63 ,transaction_sub_type IGI_IAC_TRANSACTION_HEADERS.TRANSACTION_SUB_TYPE%TYPE
64 ,adjustment_status IGI_IAC_TRANSACTION_HEADERS.ADJUSTMENT_STATUS%TYPE
65 ,validate_business_rules BOOLEAN DEFAULT FALSE /* whether the business rules should be validated ? */
66 ,first_time_flag BOOLEAN DEFAULT FALSE /* whether this routine is called for the first time */
67 ,message_level NUMBER DEFAULT 0 /*(0- None, 1 -Low, 2-Normal, 3- high) Message Severity level */
68 ,create_acctg_entries BOOLEAN DEFAULT FALSE /* create accounting entries at the end of the processing */
69 ,crud_allowed BOOLEAN DEFAULT FALSE /* create, update, delete allowed ? */
70 ,modify_balances BOOLEAN DEFAULT FALSE /* Update Balance information at the end of the processing */
71 ,commit_flag BOOLEAN DEFAULT FALSE /* commit the changes at the end ? */
72 ,print_report BOOLEAN DEFAULT FALSE /* Print Revaluation Report */
73 ,mixed_scenario BOOLEAN DEFAULT FALSE /* Mixed Scenario ? */
74 ,show_exceptions BOOLEAN DEFAULT FALSE /* Maintain list of failed validations */
75 ,calling_program VARCHAR2(30) DEFAULT NULL /* how the revaluation is being called */
76 );
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
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
95 ,curr_ytd_opacc_next fa_deprn_summary.ytd_deprn%TYPE default 0
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
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
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
119 ,deprn_start_date fa_books.deprn_start_date%TYPE default null
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
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
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;
134 subtype iac_reval_exceptions_idx is binary_integer;
135
136 TYPE iac_reval_mesg_Table is table of iac_reval_mesg_line index by binary_integer;
137 subtype iac_reval_mesg is iac_reval_mesg_table ;
138 subtype iac_reval_mesg_idx is binary_integer ;
139
140 subtype iac_Reval_output_asset is igi_iac_asset_balances%rowtype;
141
142 subtype iac_reval_output_dists_rec is igi_iac_det_balances%rowtype;
143 TYPE iac_reval_output_dists is table of iac_reval_output_dists_rec ;
144 subtype iac_reval_output_dists_idx is binary_integer ;
145
146 type iac_reval_params is record
147 (
148 reval_control iac_reval_control_type
149 , reval_asset_params iac_reval_asset_params
150 , reval_input_asset iac_reval_input_asset
151 , reval_output_asset iac_reval_output_asset
152 , reval_output_asset_mvmt iac_reval_output_asset
153 , reval_prev_rate_info iac_reval_rate_params
154 , reval_curr_rate_info_first iac_reval_rate_params
155 , reval_curr_rate_info_next iac_reval_rate_params
156 , reval_asset_rules iac_reval_asset_rules
157 , reval_asset_exceptions iac_reval_exception_line
158 , fa_asset_info fa_hist_asset_info
159 ) ;
160
161 -- TYPE iac_reval_params_tab IS TABLE OF iac_reval_params INDEX BY BINARY_INTEGER;
162 TYPE iac_reval_control_tab IS TABLE OF iac_reval_control_type INDEX BY BINARY_INTEGER;
163 TYPE iac_reval_asset_params_tab IS TABLE OF iac_reval_asset_params INDEX BY BINARY_INTEGER;
164 TYPE iac_reval_asset_tab IS TABLE OF iac_reval_input_asset INDEX BY BINARY_INTEGER;
165 TYPE iac_reval_asset_rules_tab IS TABLE OF iac_reval_asset_rules INDEX BY BINARY_INTEGER;
166 TYPE iac_reval_rates_tab IS TABLE OF iac_reval_rate_params INDEX BY BINARY_INTEGER;
167 TYPE iac_reval_exceptions_tab IS TABLE OF iac_reval_exception_line INDEX BY BINARY_INTEGER;
168 TYPE iac_reval_fa_asset_info_tab IS TABLE OF fa_hist_asset_info INDEX BY BINARY_INTEGER;
169 /** end revaluation info **/
170
171 /** begin adjustments info **/
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
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
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
199
200 );
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
211 ,deprn_adjustment_amount fa_deprn_detail.DEPRN_ADJUSTMENT_AMOUNT%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
210 ,deprn_reserve fa_deprn_detail.deprn_reserve%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 );
220
221 TYPE iac_adj_asset_info_tab IS TABLE OF Iac_adj_hist_asset_info INDEX BY BINARY_INTEGER;
222 TYPE iac_adj_dist_info_tab IS TABLE OF Iac_adj_hist_dist_info INDEX BY BINARY_INTEGER;
223 /** end Adjutsmemts info **/
224
225 END;