[Home] [Help]
PACKAGE: APPS.FA_STD_TYPES
Source
1 PACKAGE FA_STD_TYPES as
2 /* $Header: faxstds.pls 120.26.12010000.1 2008/07/28 13:27:55 appldev ship $ */
3
4 --
5 -- Private Inter-Package Types
6 --
7 -- Following types are used to construct nested record type of table type
8 --
9 TYPE number_tbl_type IS TABLE OF NUMBER
10 INDEX BY BINARY_INTEGER;
11
12 TYPE date_tbl_type IS TABLE OF DATE
13 INDEX BY BINARY_INTEGER;
14
15 TYPE boolean_tbl_type IS TABLE OF BOOLEAN
16 INDEX BY BINARY_INTEGER;
17
18 TYPE varchar2_tbl_type IS TABLE OF VARCHAR2(1000)
19 INDEX BY BINARY_INTEGER;
20
21 -- Global variable holding the accessability against FA_OVERRIDE_TABLE
22 deprn_override_trigger_enabled Boolean:= TRUE;
23
24 --
25 -- Standard data types for all summary modules
26 --
27
28 --
29 -- Usage : An IN parameter to Depreciation Engine.
30 -- Arguments :
31 -- adj_cost : Adjusted Cost
32 -- rec_cost : Recoverable Cost
33 -- reval_amo_basis : Revlauation Amortization
34 -- deprn_rsv : Depreciation Reserve
35 -- reval_rsv : Revaluation Reserve
36 -- adj_rate : Adjusted Rate (Flat Rates)
37 -- rate_adj_factor : Rate Adjustment Factor
38 -- capacity : Production Capacity
39 -- adj_capacity : Adjusted Capacity
40 -- ltd_prod : Life-to-date Production
41 -- asset_num : Asset Number
42 -- calendar_type : Depreciation Calendar
43 -- ceil_name : Ceiling Name
44 -- bonus_rule : Bonus Rule
45 -- book : Book Type Code
46 -- method_code : Depreciation Method Code
47 -- asset_id : Asset ID
48 -- jdate_in_service : DPIS (Julian Date)
49 -- prorate_jdate : Prorate Date (Julian Date)
50 -- deprn_start_jdate : Deprn Start Date (Julian Date)
51 -- jdate_retired : Date Retired (Julian Date)
52 -- ret_prorate_jdate : Retirement Prorate Date (JJulian Date)
53 -- life : Asset Life in Months
54 -- y_begin : Year to Begin calculation
55 -- y_end : Year to End calculation
56 -- p_cl_begin : Period to Begin calculation
57 -- p_cl_end : Period to End calculation
58 -- rsv_known_flag : Reserve (deprn_rsv) is valid
59 -- salvage_value : Salvage Value
60 -- pc_life_end : Period Counter Life Complete
61 -- adj_rec_cost : Adjusted Recoverable Cost
62 -- prior_fy_exp : Total Prior FY Depreciation Expenases
63 -- deprn_rounding_flag : Annual Deprn Rounding Flag
64 -- ytd_deprn : YTD Depreciation Expense
65 --
66
67 TYPE dpr_struct IS RECORD (
68 adj_cost FA_BOOKS.Adjusted_Cost%TYPE,
69 rec_cost FA_BOOKS.Recoverable_Cost%TYPE,
70 reval_amo_basis FA_BOOKS.Reval_Amortization_Basis%TYPE,
71 deprn_rsv FA_DEPRN_SUMMARY.Deprn_Reserve%TYPE,
72 reval_rsv FA_DEPRN_SUMMARY.Reval_Reserve%TYPE,
73 adj_rate FA_BOOKS.Adjusted_Rate%TYPE,
74 rate_adj_factor FA_BOOKS.Rate_Adjustment_Factor%TYPE,
75 capacity FA_BOOKS.Production_Capacity%TYPE,
76 adj_capacity FA_BOOKS.Adjusted_Capacity%TYPE,
77 ltd_prod FA_DEPRN_SUMMARY.Ltd_Production%TYPE,
78 asset_num FA_ADDITIONS.Asset_Number%TYPE,
79 calendar_type FA_CALENDAR_TYPES.Calendar_Type%TYPE,
80 ceil_name FA_BOOKS.Ceiling_Name%TYPE,
81 bonus_rule FA_BOOKS.Bonus_Rule%TYPE,
82 book FA_BOOKS.Book_Type_Code%TYPE,
83 method_code FA_BOOKS.Deprn_Method_Code%TYPE,
84 asset_id FA_BOOKS.Asset_Id%TYPE,
85 jdate_in_service NUMBER,
86 prorate_jdate NUMBER,
87 deprn_start_jdate NUMBER,
88 jdate_retired NUMBER,
89 ret_prorate_jdate NUMBER,
90 life FA_BOOKS.Life_In_Months%TYPE,
91 y_begin NUMBER,
92 y_end NUMBER,
93 p_cl_begin NUMBER,
94 p_cl_end NUMBER,
95 rsv_known_flag BOOLEAN,
96 salvage_value FA_BOOKS.Salvage_Value%TYPE,
97 pc_life_end FA_BOOKS.Period_Counter_Life_Complete%TYPE,
98 adj_rec_cost FA_BOOKS.Adjusted_Recoverable_Cost%TYPE,
99 prior_fy_exp FA_DEPRN_SUMMARY.Prior_Fy_Expense%TYPE,
100 deprn_rounding_flag FA_BOOKS.Annual_Deprn_Rounding_Flag%TYPE,
101 deprn_override_flag FA_DEPRN_SUMMARY.Deprn_Override_Flag%TYPE,
102 used_by_adjustment BOOLEAN,
103 ytd_deprn FA_DEPRN_SUMMARY.Ytd_Deprn%TYPE,
104 short_fiscal_year_flag FA_BOOKS.short_fiscal_year_flag%TYPE,
105 conversion_date FA_BOOKS.conversion_date%TYPE,
106 prorate_date FA_BOOKS.prorate_date%TYPE,
107 orig_deprn_start_date FA_BOOKS.original_deprn_start_date%TYPE,
108 old_adj_cost FA_BOOKS.old_adjusted_cost%TYPE,
109 formula_factor FA_BOOKS.formula_factor%TYPE,
110 bonus_deprn_exp FA_DEPRN_SUMMARY.Bonus_Deprn_Amount%TYPE, -- YYOON
111 bonus_ytd_deprn FA_DEPRN_SUMMARY.Bonus_Ytd_Deprn%TYPE,
112 bonus_deprn_rsv FA_DEPRN_SUMMARY.Bonus_Deprn_Reserve%TYPE,
113 prior_fy_bonus_exp FA_DEPRN_SUMMARY.Prior_FY_Bonus_Expense%TYPE,
114 mrc_sob_type_code VARCHAR2(1),
115 tracking_method FA_BOOKS.Tracking_Method%TYPE,
116 allocate_to_fully_ret_flag FA_BOOKS.Allocate_to_Fully_Ret_Flag%TYPE,
117 allocate_to_fully_rsv_flag FA_BOOKS.Allocate_to_Fully_Rsv_Flag%TYPE,
118 excess_allocation_option FA_BOOKS.Excess_Allocation_Option%TYPE,
119 depreciation_option FA_BOOKS.Depreciation_Option%TYPE,
120 member_rollup_flag FA_BOOKS.Member_Rollup_Flag%TYPE,
121 eofy_reserve FA_BOOKS.eofy_reserve%TYPE,
122 update_override_status BOOLEAN,
123 over_depreciate_option FA_BOOKS.Over_Depreciate_Option%TYPE,
124 super_group_id FA_BOOKS.super_group_id%TYPE,
125 cost FA_BOOKS.cost%TYPE,
126 asset_type FA_ADDITIONS_B.ASSET_TYPE%TYPE,
127 impairment_exp FA_DEPRN_SUMMARY.IMPAIRMENT_AMOUNT%TYPE,
128 ytd_impairment FA_DEPRN_SUMMARY.YTD_IMPAIRMENT%TYPE,
129 impairment_rsv FA_DEPRN_SUMMARY.impairment_reserve%TYPE,
130 calc_catchup BOOLEAN, -- Bug 5738004
131 cost_frac NUMBER, -- Bug 5948890
132 transaction_type_code FA_TRANSACTION_HEADERS.Transaction_Type_Code%TYPE -- Bug:6665510
133 );
134
135
136 -- Usage : A OUT parameter from Depreciation Engine.
137 -- Arguments :
138 -- new_deprn_rsv : New Deprn Reserve
139 -- new_adj_cost : New Adjusted Cost
140 -- new_reval_rsv : New Revaluation Reserve
141 -- new_reval_amo_basis : New Revaluation Amortization Basis
142 -- new_adj_capacity : New Adjusted Capacity
143 -- new_ltd_prod : New Life-To-Date Production
144 -- deprn_exp : Depreciation Expense
145 -- reval_exp : Deprn Expense due to Revaluation
146 -- reval_amo : Revaluation Reserve Amortization
147 -- prod : Units of Production
148 -- ann_adj_exp : Annualized Adjustment to Deprn Expense
149 -- ann_adj_reval_exp : Annualized Adjustment to Deprn Expense due to Reval
150 -- ann_adj_reval_amo : Annualized Adjustment to Revaluation Amortization
151 -- bonus_rate_used : Bonus Rate used
152 -- deprn_factor_used : Deprn Factor used
153 -- alternate_deprn_factor_used
154 -- : Alternate Deprn Factor used
155 -- full_rsv_flag : Asset Fully-Reserved flag
156 -- life_comp_flag : Asset Life Complete flag
157 -- new_prior_fy_exp : New Depreciation Expense for all Prior Fiscal Years
158 -- new_bonus_deprn_rsv : New Bonus Deprn Reserve
159 -- new_ytd_deprn : New Year to date Depreciation
160 -- new_eofy_reserve : New Eofy Amount
161 --
162 TYPE dpr_out_struct IS RECORD (
163 new_deprn_rsv FA_DEPRN_DETAIL.Deprn_reserve%TYPE,
164 new_adj_cost FA_BOOKS.Adjusted_Cost%TYPE,
165 new_reval_rsv FA_DEPRN_SUMMARY.Reval_Reserve%TYPE,
166 new_reval_amo_basis FA_BOOKS.Reval_Amortization_Basis%TYPE,
167 new_adj_capacity FA_BOOKS.Adjusted_Capacity%TYPE,
168 new_ltd_prod FA_DEPRN_SUMMARY.Ltd_Production%TYPE,
169 deprn_exp FA_DEPRN_DETAIL.Reval_deprn_expense%TYPE,
170 reval_exp FA_DEPRN_DETAIL.Reval_deprn_expense%TYPE,
171 reval_amo FA_DEPRN_DETAIL.Reval_amortization%TYPE,
172 prod FA_DISTRIBUTION_HISTORY.Units_Assigned%TYPE,
173 ann_adj_exp FA_DEPRN_DETAIL.Reval_Deprn_Expense%TYPE,
174 ann_adj_reval_exp FA_DEPRN_DETAIL.Ytd_Reval_Deprn_Expense%TYPE,
175 ann_adj_reval_amo FA_DEPRN_DETAIL.Reval_Amortization%TYPE,
176 bonus_rate_used NUMBER,
177 deprn_factor_used NUMBER,
178 alternate_deprn_factor_used
179 NUMBER,
180 full_rsv_flag BOOLEAN,
181 life_comp_flag BOOLEAN,
182 bonus_deprn_exp FA_DEPRN_SUMMARY.Bonus_Deprn_Amount%TYPE, -- YYOON
183 impairment_exp FA_DEPRN_SUMMARY.Impairment_Amount%TYPE,
184 new_prior_fy_exp FA_DEPRN_SUMMARY.Prior_Fy_Expense%TYPE,
185 new_bonus_deprn_rsv FA_DEPRN_SUMMARY.Bonus_Deprn_Reserve%TYPE,
186 new_prior_fy_bonus_exp FA_DEPRN_SUMMARY.Prior_FY_Bonus_Expense%TYPE,
187 new_impairment_rsv FA_DEPRN_SUMMARY.impairment_reserve%TYPE,
188 deprn_override_flag FA_DEPRN_SUMMARY.Deprn_Override_Flag%TYPE,
189 new_ytd_deprn FA_DEPRN_SUMMARY.Ytd_Deprn%TYPE,
190 new_eofy_reserve FA_BOOKS.eofy_reserve%TYPE
191 );
192 --
193 -- bonus? necessary? from fa_cde_pkg:if so we need to add to dpr_out_struct.
194 -- dpr_out.bonus_deprn_amount := bonus_deprn_exp_sum;
195
196
197 -- Usage : Used to store depreciaton info for an asset
198 -- Arguments : Union of all columns in FA_DEPRN_DETAIL and
199 -- FA_DEPRN_SUMMARY tables
200 --
201 TYPE fa_deprn_row_struct IS RECORD (
202 asset_id NUMBER,
203 book VARCHAR2(15),
204 dist_id NUMBER,
205 period_ctr NUMBER,
206 adjusted_flag BOOLEAN,
207 deprn_exp NUMBER,
208 reval_deprn_exp NUMBER,
209 reval_amo NUMBER,
210 prod NUMBER,
211 ytd_deprn NUMBER,
212 ytd_reval_deprn_exp NUMBER,
213 ytd_prod NUMBER,
214 deprn_rsv NUMBER,
215 reval_rsv NUMBER,
216 ltd_prod NUMBER,
217 cost NUMBER,
218 add_cost_to_clear NUMBER,
219 adj_cost NUMBER,
220 reval_amo_basis NUMBER,
221 bonus_rate NUMBER,
222 deprn_adjust_exp NUMBER,
223 deprn_source_code VARCHAR2(15),
224 prior_fy_exp NUMBER,
225 bonus_deprn_rsv NUMBER,
226 bonus_ytd_deprn NUMBER,
227 bonus_deprn_amount NUMBER,
228 prior_fy_bonus_exp NUMBER,
229 impairment_rsv NUMBER,
230 ytd_impairment NUMBER,
231 impairment_amount NUMBER,
232 deprn_override_flag VARCHAR2(1),
233 asset_type VARCHAR2(30),
234 member_rollup_flag VARCHAR2(1),
235 mrc_sob_type_code VARCHAR2(1));
236
237 -- Usage : To construct fa_deprn_row_struct record type of table
238 -- Arguments : Should match the same arguments in fa_deprn_row_struct type
239 --
240 TYPE table_fa_deprn_row_struct IS RECORD (
241 asset_id number_tbl_type,
242 book varchar2_tbl_type,
243 dist_id number_tbl_type,
244 period_ctr number_tbl_type,
245 adjusted_flag boolean_tbl_type,
246 deprn_exp number_tbl_type,
247 reval_deprn_exp number_tbl_type,
248 reval_amo number_tbl_type,
249 prod number_tbl_type,
250 ytd_deprn number_tbl_type,
251 ytd_reval_deprn_exp number_tbl_type,
252 ytd_prod number_tbl_type,
253 deprn_rsv number_tbl_type,
254 reval_rsv number_tbl_type,
255 ltd_prod number_tbl_type,
256 cost number_tbl_type,
257 add_cost_to_clear number_tbl_type,
258 adj_cost number_tbl_type,
259 reval_amo_basis number_tbl_type,
260 bonus_rate number_tbl_type,
261 deprn_adjust_exp number_tbl_type,
262 deprn_source_code varchar2_tbl_type,
263 prior_fy_exp number_tbl_type,
264 bonus_deprn_rsv number_tbl_type,
265 bonus_ytd_deprn number_tbl_type,
266 bonus_deprn_amount number_tbl_type,
267 prior_fy_bonus_exp number_tbl_type,
268 impairment_rsv number_tbl_type,
269 ytd_impairment number_tbl_type,
270 impairment_amount number_tbl_type);
271
272 --
273 -- Usage : Stores fraction of fiscal year for periods based on
274 -- period start date, period end date and deprn_alloc_code.
275 -- It is used by depreciation engine to calcuate deprn rate.
276 -- Arguments:
277 -- frac : Fraction of Fiscal Year
278 -- start_jdate : Period Start Date (Julian Date)
279 -- end_jdate : period End Date (Julian)
280 --
281 TYPE fa_cp_struct IS RECORD (
282 frac NUMBER,
283 start_jdate NUMBER,
284 end_jdate NUMBER);
285
286 TYPE table_fa_cp_struct is TABLE of fa_cp_struct
287 INDEX BY BINARY_INTEGER;
288
289
290 TYPE dpr_arr_rec_type IS RECORD (
291 value number,
292 bonus_value number,
293 period_num number,
294 fiscal_year number);
295
296 TYPE dpr_arr_type is TABLE of dpr_arr_rec_type
297 index by binary_integer;
298
299 -- Usage : Used to store values used in processing financial
300 -- changes (Amortized or Expensed) of an asset
301 -- Arguments :
302 -- asset_id : Asset ID
303 -- category_id : Asset's Category ID
304 -- transaction_id : Transaction Header ID
305 -- jdate_in_svc : Date Placed in Svc (Julian Date)
306 -- period_ctr : Current Period Counter
307 -- dep_flag : Depreciate Flag: 'YES'=TRUE, 'NO'=FALSE
308 -- book : Book
309 -- asset_number : Asset Number
310 -- asset_type : Asset Type
311 -- date_placed_in_svc : Date Placed in Svc, Format: DD-MON-YYYY
312 -- prorate_date : Prorate Date, Format: DD-MON-YYYY
313 -- deprn_start_date : Deprn Start Date, Format: DD-MON-YYYY
314 -- ceiling_name : Ceiling Name
315 -- bonus_rule : Bonus Rule Name
316 -- current_time : Sysdate for Last Update Date
317 -- Format:DD-MON-YYYY HH24:MI:SS
318 -- method_code : Deprn Method Code
319 -- cost : Cost AFTER change
320 -- old_cost : Cost BEFORE change
321 -- rec_cost : Recoverable Cost
322 -- adj_cost : Adjusted Cost
323 -- rate_adj_factor : Rate Adjustment Factor
324 -- adj_rate : Adjusted Rate
325 -- units : Current Units
326 -- reval_amo_basis : Reval Amort Basis
327 -- capacity : Production Capacity
328 -- adj_capacity : Adjusted Capacity
329 -- life : Asset Life in Months
330 -- adj_rec_cost : Adjusted Recoverable Cost
331 -- salvage_value : Salvage Value
332 -- deprn_rounding_flag: Annual Deprn Rounding Flag
333 -- amortization_start_date :Amortization Start Date(Dated Adjustment)
334 -- adj_amount : Adjustment Amount(Dated Adjustment)
335 --
336
337 TYPE fin_info_struct IS RECORD (
338 asset_id NUMBER,
339 category_id NUMBER,
340 transaction_id NUMBER,
341 jdate_in_svc NUMBER,
342 period_ctr NUMBER,
343 dep_flag BOOLEAN,
344 book VARCHAR2(15),
345 asset_number VARCHAR2(15),
346 asset_type VARCHAR2(11),
347 date_placed_in_svc DATE,
351 bonus_rule VARCHAR2(30),
348 prorate_date DATE,
349 deprn_start_date DATE,
350 ceiling_name VARCHAR2(30),
352 current_time DATE,
353 method_code VARCHAR2(12),
354 cost NUMBER,
355 old_cost NUMBER,
356 rec_cost NUMBER,
357 adj_cost NUMBER,
358 rate_adj_factor NUMBER,
359 adj_rate NUMBER,
360 units NUMBER,
361 reval_amo_basis NUMBER,
362 capacity NUMBER,
363 adj_capacity NUMBER,
364 life NUMBER,
365 adj_rec_cost NUMBER,
366 salvage_value NUMBER,
367 deprn_rounding_flag VARCHAR2(5),
368 amortization_start_date DATE,
369 adj_amount NUMBER,
370 short_fiscal_year_flag VARCHAR2(3),
371 conversion_date DATE,
372 orig_deprn_start_date DATE,
373 old_adj_cost NUMBER,
374 formula_factor NUMBER,
375 running_mode NUMBER,
376 used_by_revaluation NUMBER,
377 deprn_override_flag Varchar2(1));
378
379
380 -- Usage : Used by INSERT_DETAIL user_exit to insert row into
381 -- FA_DEPRN_DETAIL table
382 -- Arguments :
383 --
384 TYPE dpr_dtl_row_struct IS RECORD (
385 book VARCHAR2(15),
386 asset_id NUMBER,
387 period_counter NUMBER,
388 cost NUMBER,
389 ytd NUMBER,
390 deprn_reserve NUMBER,
391 /* Bug 525654 Modification */
392 deprn_adjustment_amount NUMBER,
393 reval_reserve NUMBER,
394 ytd_reval_dep_exp NUMBER,
395 reval_rsv_flag BOOLEAN,
396 ytd_reval_dep_exp_flag BOOLEAN,
397 bonus_ytd NUMBER,
398 bonus_deprn_reserve NUMBER,
399 bonus_deprn_amount NUMBER,
400 bonus_deprn_adj_amount NUMBER,
401 deprn_amount NUMBER,
402 reval_amortization NUMBER,
403 reval_deprn_expense NUMBER,
404 impairment_amount NUMBER,
405 ytd_impairment NUMBER,
406 impairment_reserve NUMBER);
407
408 --
409 -- The following data types are used in Depreciation Module
410 --
411
412 TYPE fa_dp_global_info IS RECORD (
413 undistributed_assets NUMBER,
414 user_Id NUMBER,
415 login_id NUMBER,
416 request_id NUMBER,
417 total_requests NUMBER,
418 request_number NUMBER);
419
420 TYPE fa_dp_book_info IS RECORD (
421 book VARCHAR2(15),
422 deprn_calendar VARCHAR2(15),
423 rate_calendar VARCHAR2(15),
424 dist_book VARCHAR2(15),
425 fy_name VARCHAR2(30),
426 cp_start_date DATE,
427 cp_end_date DATE,
428 last_update_date DATE,
429 ccp_start_date DATE,
430 ccp_end_date DATE,
431 cur_per_ctr NUMBER,
432 cur_per_num NUMBER,
433 cur_fy NUMBER,
434 pers_per_yr NUMBER,
435 rate_pers_per_yr NUMBER);
436
437 TYPE dh_adj_type IS RECORD (
438 dist_id NUMBER,
439 ccid NUMBER,
440 units NUMBER,
441 active_flag BOOLEAN,
442 deprn fa_deprn_row_struct);
443
444 TYPE table_dh_adj_type IS RECORD (
445 dist_id number_tbl_type,
446 ccid number_tbl_type,
447 units number_tbl_type,
448 active_flag boolean_tbl_type,
449 deprn table_fa_deprn_row_struct,
450 num_of_rows NUMBER);
451
452 TYPE fa_dp_asset_info IS RECORD (
453 asset_id NUMBER,
454 category_id NUMBER,
455 thid NUMBER,
456 adj_reqd NUMBER,
457 cost_change BOOLEAN,
458 ret_pending BOOLEAN,
459 fully_ret NUMBER,
460 fully_rsv BOOLEAN,
461 active_dists BOOLEAN,
462 annual_deprn_rounding_flag VARCHAR2(5),
463 life_complete BOOLEAN,
464 dpr dpr_struct,
465 dpr_out dpr_out_struct,
466 summary dh_adj_type,
467 dists table_dh_adj_type);
468
469 TYPE inv_type IS RECORD (
470 pay_ccid NUMBER,
471 asset_inv_id NUMBER,
472 cost NUMBER,
473 cost_inserted NUMBER);
474
475 TYPE fa_adj_row_struct IS RECORD (
476 transaction_header_id NUMBER,
477 asset_invoice_id NUMBER,
478 source_type_code VARCHAR2(15),
479 adjustment_type VARCHAR2(15),
480 debit_credit_flag VARCHAR2(2),
481 code_combination_id NUMBER,
482 book_type_code VARCHAR2(15),
483 period_counter_created NUMBER,
484 asset_id NUMBER,
485 adjustment_amount NUMBER,
486 period_counter_adjusted NUMBER,
487 distribution_id NUMBER,
488 annualized_adjustment NUMBER,
489 last_update_date DATE,
490 account VARCHAR2(25),
491 account_type VARCHAR2(55),
492 current_units NUMBER,
493 selection_mode NUMBER,
494 selection_thid NUMBER,
495 selection_retid NUMBER,
496 flush_adj_flag NUMBER,
497 gen_ccid_flag NUMBER,
498 amount_inserted NUMBER,
499 units_retired NUMBER,
500 leveling_flag NUMBER);
501
502 TYPE txn_hdr_rec IS RECORD (
503 transaction_header_id NUMBER(15),
504 book_type_code VARCHAR2(15),
508 date_effective DATE,
505 asset_id NUMBER(15),
506 transaction_type_code VARCHAR2(20),
507 transaction_date_entered DATE,
509 last_update_date DATE,
510 last_updated_by NUMBER(15),
511 transaction_name VARCHAR2(30),
512 invoice_transaction_id NUMBER(15),
513 source_transaction_header_id NUMBER(15),
514 mass_reference_id NUMBER(15),
515 last_update_login NUMBER(15),
516 transaction_subtype VARCHAR2(9),
517 attribute1 VARCHAR2(150),
518 attribute2 VARCHAR2(150),
519 attribute3 VARCHAR2(150),
520 attribute4 VARCHAR2(150),
521 attribute5 VARCHAR2(150),
522 attribute6 VARCHAR2(150),
523 attribute7 VARCHAR2(150),
524 attribute8 VARCHAR2(150),
525 attribute9 VARCHAR2(150),
526 attribute10 VARCHAR2(150),
527 attribute11 VARCHAR2(150),
528 attribute12 VARCHAR2(150),
529 attribute13 VARCHAR2(150),
530 attribute14 VARCHAR2(150),
531 attribute15 VARCHAR2(150),
532 attribute_category_code VARCHAR2(30),
533 transaction_key VARCHAR2(1));
534
535 TYPE book_rec IS RECORD (
536 book_type_code VARCHAR2(15),
537 asset_id NUMBER(15),
538 date_placed_in_service DATE,
539 date_effective DATE,
540 deprn_start_date DATE,
541 deprn_method_code VARCHAR2(12),
542 life_in_months NUMBER(4),
543 rate_adjustment_factor NUMBER,
544 adjusted_cost NUMBER,
545 cost NUMBER,
546 original_cost NUMBER,
547 salvage_value NUMBER,
548 prorate_convention_code VARCHAR2(10),
549 prorate_date DATE,
550 cost_change_flag VARCHAR2(3),
551 adjustment_required_status VARCHAR2(4),
552 capitalize_flag VARCHAR2(3),
553 retirement_pending_flag VARCHAR2(3),
554 depreciate_flag VARCHAR2(3),
555 last_update_date DATE,
556 last_updated_by NUMBER(15),
557 date_ineffective DATE,
558 transaction_header_id_in NUMBER(15),
559 transaction_header_id_out NUMBER(15),
560 itc_amount_id NUMBER(15),
561 itc_amount NUMBER,
562 retirement_id NUMBER(15),
563 tax_request_id NUMBER(15),
564 itc_basis NUMBER,
565 basic_rate NUMBER,
566 adjusted_rate NUMBER,
567 bonus_rule VARCHAR2(30),
568 ceiling_name VARCHAR2(30),
569 recoverable_cost NUMBER,
570 last_update_login NUMBER(15),
571 adjusted_capacity NUMBER,
572 fully_rsvd_revals_counter NUMBER(5),
573 idled_flag VARCHAR2(3),
574 period_counter_capitalized NUMBER(15),
575 period_counter_fully_reserved NUMBER(15),
576 period_counter_fully_retired NUMBER(15),
577 production_capacity NUMBER,
578 reval_amortization_basis NUMBER,
579 reval_ceiling NUMBER,
580 unit_of_measure VARCHAR2(25),
581 unrevalued_cost NUMBER,
582 annual_deprn_rounding_flag VARCHAR2(5),
583 percent_salvage_value NUMBER,
584 allowed_deprn_limit NUMBER,
585 allowed_deprn_limit_amount NUMBER,
586 period_counter_life_complete NUMBER(15),
587 adjusted_recoverable_cost NUMBER,
588 annual_rounding_flag VARCHAR2(5),
589 short_fiscal_year_flag VARCHAR2(3),
590 conversion_date DATE,
591 orig_deprn_start_date DATE,
592 old_adj_cost NUMBER,
593 formula_factor NUMBER,
594 rate_source_rule VARCHAR2(10),
595 global_attribute1 VARCHAR2(150),
596 global_attribute2 VARCHAR2(150),
597 global_attribute3 VARCHAR2(150),
598 global_attribute4 VARCHAR2(150),
599 global_attribute5 VARCHAR2(150),
600 global_attribute6 VARCHAR2(150),
601 global_attribute7 VARCHAR2(150),
602 global_attribute8 VARCHAR2(150),
603 global_attribute9 VARCHAR2(150),
604 global_attribute10 VARCHAR2(150),
605 global_attribute11 VARCHAR2(150),
606 global_attribute12 VARCHAR2(150),
607 global_attribute13 VARCHAR2(150),
608 global_attribute14 VARCHAR2(150),
609 global_attribute15 VARCHAR2(150),
610 global_attribute16 VARCHAR2(150),
611 global_attribute17 VARCHAR2(150),
612 global_attribute18 VARCHAR2(150),
613 global_attribute19 VARCHAR2(150),
614 global_attribute20 VARCHAR2(150),
615 global_attribute_category VARCHAR2(30));
616
617 -- Depreciable Basis Formula IN Parameters
618
619 TYPE fa_deprn_rule_in_struct is RECORD (
620 event_type VARCHAR2(20),
621 asset_id NUMBER(15),
622 group_asset_id NUMBER,
623 book_type_code VARCHAR2(15),
624 asset_type VARCHAR2(11),
625 depreciate_flag VARCHAR2(3),
626 method_code VARCHAR2(12),
627 life_in_months NUMBER(4),
628 method_id NUMBER(15),
629 method_type VARCHAR2(10),
630 calc_basis VARCHAR2(4),
631 adjustment_amount NUMBER,
632 transaction_flag VARCHAR2(3),
633 cost NUMBER,
634 salvage_value NUMBER,
635 recoverable_cost NUMBER,
636 adjusted_cost NUMBER,
637 current_total_rsv NUMBER,
638 current_rsv NUMBER,
639 current_total_ytd NUMBER,
640 current_ytd NUMBER,
641 hyp_basis NUMBER,
642 hyp_total_rsv NUMBER,
643 hyp_rsv NUMBER,
644 hyp_total_ytd NUMBER,
645 hyp_ytd NUMBER,
646 old_cost NUMBER,
647 old_adjusted_cost NUMBER,
648 old_total_adjusted_cost NUMBER,
649 old_raf NUMBER,
650 old_formula_factor NUMBER,
651 old_reduction_amount NUMBER,
652 -- Added for Group Depreciation
656 member_proceeds NUMBER,
653 transaction_header_id NUMBER(15),
654 member_transaction_header_id NUMBER(15),
655 member_transaction_type_code VARCHAR2(30),
657 transaction_date_entered DATE,
658 amortization_start_date DATE,
659 adj_transaction_header_id NUMBER(15),
660 adj_mem_transaction_header_id NUMBER(15),
661 adj_transaction_date_entered DATE,
662 period_counter NUMBER(15),
663 fiscal_year NUMBER(4),
664 period_num NUMBER,
665 proceeds_of_sale NUMBER,
666 cost_of_removal NUMBER,
667 nbv_retired NUMBER,
668 reduction_rate NUMBER,
669 eofy_reserve NUMBER,
670 adj_reserve NUMBER,
671 reserve_retired NUMBER,
672 recognize_gain_loss VARCHAR2(30),
673 tracking_method VARCHAR2(30),
674 allocate_to_fully_rsv_flag VARCHAR2(1),
675 allocate_to_fully_ret_flag VARCHAR2(1),
676 excess_allocation_option VARCHAR2(30),
677 depreciation_option VARCHAR2(30),
678 member_rollup_flag VARCHAR2(30),
679 unplanned_amount NUMBER,
680 eofy_recoverable_cost NUMBER,
681 eop_recoverable_cost NUMBER,
682 eofy_salvage_value NUMBER,
683 eop_salvage_value NUMBER,
684 used_by_adjustment VARCHAR2(30),
685 eofy_flag VARCHAR2(1),
686 apply_reduction_flag VARCHAR2(1),
687 mrc_sob_type_code VARCHAR2(1),
688 reduction_amount NUMBER,
689 use_old_adj_cost_flag VARCHAR2(1),
690 polish_rule NUMBER,
691 deprn_factor NUMBER,
692 alternate_deprn_factor NUMBER,
693 short_fy_flag VARCHAR2(3),
694 impairment_reserve NUMBER,
695 use_passed_imp_rsv_flag VARCHAR2(1)
696 );
697
698 -- Depreciable Basis Formula OUT Parameters
699
700 TYPE fa_deprn_rule_out_struct is RECORD (
701 new_adjusted_cost NUMBER,
702 new_total_adjusted_cost NUMBER,
703 new_raf NUMBER,
704 new_formula_factor NUMBER,
705 new_reduction_amount NUMBER,
706 new_deprn_rounding_flag VARCHAR2(5) );
707
708 TYPE reval_out_struct is RECORD (
709 deprn_rsv_adj NUMBER, -- Adjustment to Deprn Reserve
710 bonus_deprn_rsv_adj NUMBER, -- Adjustment to Bonus Deprn Reserve
711 impairment_rsv_adj NUMBER, -- Adjustment to Impairment Reserve
712 cost_adj NUMBER, -- Adjustment to Cost
713 reval_rsv_adj NUMBER, -- Adjustment to Reval Reserve
714 new_life NUMBER, -- New Life
715 new_adj_cost NUMBER, -- New Adjusted Cost
716 new_raf NUMBER, -- New Rate Adjustment Factor
717 new_fully_rsvd_revals_ctr NUMBER,
718 new_rec_cost NUMBER, -- New Recoverable Cost
719 new_adj_capacity NUMBER, -- New Adjusted Capacity
720 life_notdef NUMBER, -- life in months that needs to be
721 -- defined in FA_METHODS
722 pc_fully_res NUMBER,
723 -- GBertot: Added new member to structure to enable YTD Deprn.
724 ytd_deprn_adj NUMBER, -- Adjustment to YTD Deprn.
725 bonus_ytd_deprn_adj NUMBER, -- Adjustment to Bonus YTD Deprn.
726 ytd_impairment_adj NUMBER, -- Adjustment to YTD Impairment
727 new_formula_factor NUMBER,
728 new_salvage_value NUMBER, -- Newly calculated salvage value
729 insert_txn_flag BOOLEAN);
730
731 -- COMMON CONSTANT
732 --
733 -- Defines for modes for calling Depreciation Engine faxcde()
734
735 FA_DPR_PROJECT CONSTANT NUMBER := 1;
736 FA_DPR_CLEANUP CONSTANT NUMBER := 2;
737 FA_DPR_NORMAL CONSTANT NUMBER := 3;
738 FA_DPR_RETIRE CONSTANT NUMBER := 4;
739 FA_DPR_CATCHUP CONSTANT NUMBER := 5; -- Bug 5738004
740
741 -- Constants for Depreciation Rounding Flag in dpr_struct
742 FA_DPR_NO_ROUND CONSTANT VARCHAR2(3) := null;
743 FA_DPR_ROUND_ADD CONSTANT VARCHAR2(3) := 'ADD';
744 FA_DPR_ROUND_ADJ CONSTANT VARCHAR2(3) := 'ADJ';
745 FA_DPR_ROUND_RET CONSTANT VARCHAR2(3) := 'RET';
746 FA_DPR_ROUND_REV CONSTANT VARCHAR2(3) := 'REV';
747 FA_DPR_ROUND_TFR CONSTANT VARCHAR2(3) := 'TFR';
748 FA_DPR_ROUND_RES CONSTANT VARCHAR2(3) := 'RES';
749 FA_DPR_ROUND_OVE CONSTANT VARCHAR2(3) := 'OVE';
750
751 -- Constants for Override Flag
752 FA_NO_OVERRIDE CONSTANT VARCHAR2(1):= 'N';
753 FA_OVERRIDE_DPR CONSTANT VARCHAR2(1):= 'D';
754 FA_OVERRIDE_BONUS CONSTANT VARCHAR2(1):= 'B';
755 FA_OVERRIDE_DPR_BONUS CONSTANT VARCHAR2(1):= 'A';
756 FA_OVERRIDE_IMPAIR CONSTANT VARCHAR2(1):= 'I';
757 FA_OVERRIDE_DPR_IMPAIR CONSTANT VARCHAR2(1):= 'M';
758 FA_OVERRIDE_RECURSIVE CONSTANT VARCHAR2(1):= 'R';
759 -- FA_OVERRIDE_ERR CONSTANT VARCHAR2(1):= 'E';
760
761 -- Constants used in Depreciation Module
762
763 FA_DEF_NBV_FRAC CONSTANT NUMBER := 0.0001;
764 FA_DEF_NBV_AMT CONSTANT NUMBER := 0.10;
765 FA_DPR_SMALL_RAF CONSTANT NUMBER := 0.000000000000000000001;
766 FA_ROUND_DECIMAL CONSTANT NUMBER := 7;
767
768 FA_DPR_ADJ_DEPRN_EXP CONSTANT NUMBER := 1;
769 FA_DPR_ADJ_REVAL_EXP CONSTANT NUMBER := 2;
770 FA_DPR_ADJ_REVAL_AMO CONSTANT NUMBER := 3;
771 FA_DPR_ADJ_DEPRN_RSV CONSTANT NUMBER := 4;
772 FA_DPR_ADJ_REVAL_RSV CONSTANT NUMBER := 5;
773 FA_INTERCO_AP CONSTANT NUMBER := 6;
774 FA_INTERCO_AR CONSTANT NUMBER := 7;
775 -- BONUS
776 -- FA_DPR_ADJ_BONUS_DEPRN_RSV ???????
777
778 -- Defines for Rate Source Rule element values in dpr_struct
779 FAD_RSR_CALC CONSTANT VARCHAR2(10) := 'CALCULATED';
780 FAD_RSR_TABLE CONSTANT VARCHAR2(10) := 'TABLE';
781 FAD_RSR_FLAT CONSTANT VARCHAR2(10) := 'FLAT';
782 FAD_RSR_PROD CONSTANT VARCHAR2(10) := 'PRODUCTION';
783 FAD_RSR_FORMULA CONSTANT VARCHAR2(10) := 'FORMULA';
784
785 -- Defines for Deprn Basis Rule element values in dpr_struct
786 FAD_DBR_COST CONSTANT VARCHAR2(10) := 'COST';
787 FAD_DBR_NBV CONSTANT VARCHAR2(10) := 'NBV';
788
789 -- Constants for Deprn Basis Rule Polish Mechanisms
790 FAD_DBR_POLISH_NONE CONSTANT NUMBER := 0;
791 FAD_DBR_POLISH_1 CONSTANT NUMBER := 1;
792 FAD_DBR_POLISH_2 CONSTANT NUMBER := 2;
793 FAD_DBR_POLISH_3 CONSTANT NUMBER := 3;
794 FAD_DBR_POLISH_4 CONSTANT NUMBER := 4;
795 FAD_DBR_POLISH_5 CONSTANT NUMBER := 5;
796
797 -- Constants for Over Depreciate Option in dpr_struct
798 FA_OVER_DEPR_NULL CONSTANT VARCHAR2(30) := null;
799 FA_OVER_DEPR_NO CONSTANT VARCHAR2(30) := 'NO';
800 FA_OVER_DEPR_YES CONSTANT VARCHAR2(30) := 'YES';
801 FA_OVER_DEPR_DEPRN CONSTANT VARCHAR2(30) := 'DEPRN';
802
803 -- Defines for fatime() modes
804
805 FA_ENTER CONSTANT NUMBER := 1;
806 FA_EXIT CONSTANT NUMBER := 2;
807
808 -- Defines for modes for inserting adjustment rows in fainaj()
809 --
810 MAX_ADJ_CACHE_ROWS CONSTANT NUMBER := 200; /* the maximum number of cache
811 entries */
812 FA_AJ_ACTIVE CONSTANT NUMBER := 1; /* ACTIVE mode value */
813 FA_AJ_SINGLE CONSTANT NUMBER := 2; /* SINGLE mode value */
814 FA_AJ_CLEAR CONSTANT NUMBER := 3; /* CLEAR mode value */
815 FA_AJ_RETIRE CONSTANT NUMBER := 4; /* RETIRE mode value */
816 FA_AJ_TRANSFER_SINGLE CONSTANT NUMBER := 5; /* SINGLE mode for transfer/reclass */
817 FA_AJ_ACTIVE_REVAL CONSTANT NUMBER := 6; /* ACTIVE mode for reval./
818 Propagated from pro*c version. YYOON */
819 FA_AJ_CLEAR_PARTIAL CONSTANT NUMBER := 7; /* Mode for affected rows: Enhancement for Bug# 4617352 */
820 FA_AJ_ACTIVE_PARTIAL CONSTANT NUMBER := 8; /* Mode for affected rows: Enhancement for Bug# 4617352 */
821
822
823 END FA_STD_TYPES;