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