[Home] [Help]
PACKAGE: APPS.FA_RET_TYPES
Source
1 PACKAGE FA_RET_TYPES AUTHID CURRENT_USER as
2 /* $Header: fartypes.pls 120.9 2009/09/29 16:32:26 yyoon ship $*/
3
4 --
5 -- For RETIREMENT Processes
6 --
7 FA_DPR_DETAIL_SIZE CONSTANT NUMBER := 10;
8
9 --
10 -- Structures needed for gain/loss program
11 --
12 TYPE ret_struct is RECORD(
13 retirement_id FA_RETIREMENTS.retirement_id%type,
14 asset_id FA_RETIREMENTS.asset_id%type,
15 units_retired FA_RETIREMENTS.units%type,
16 stl_life FA_RETIREMENTS.stl_life_in_months%type,
17 itc_recapid FA_RETIREMENTS.itc_recapture_id%type,
18 th_id_in FA_RETIREMENTS.transaction_header_id_in%type,
19 stl_method_code FA_RETIREMENTS.stl_method_code%type,
20 status FA_RETIREMENTS.status%type,
21 wip_asset INTEGER,
22 cost_retired FA_RETIREMENTS.cost_retired%type,
23 rsv_retired NUMBER,
24 reval_rsv_retired FA_RETIREMENTS.reval_reserve_retired%type,
25 proceeds_of_sale FA_RETIREMENTS.proceeds_of_sale%type,
26 cost_of_removal FA_RETIREMENTS.cost_of_removal%type,
27 asset_number FA_ADDITIONS_B.asset_number%type,
28 date_retired FA_RETIREMENTS.date_retired%type,
29 prorate_convention FA_RETIREMENTS.retirement_prorate_convention%type,
30 date_effective FA_RETIREMENTS.date_effective%type,
31 book FA_RETIREMENTS.book_type_code%type,
32 dpr_evenly NUMBER,
33 retirement_type_code fa_retirements.retirement_type_code%type,
34 gain_loss_amount number,
35 bonus_rsv_retired number,
36 impair_rsv_retired number,
37 recognize_gain_loss FA_RETIREMENTS.recognize_gain_loss%type,
38 recapture_reserve_flag FA_RETIREMENTS.recapture_reserve_flag%type,
39 limit_proceeds_flag FA_RETIREMENTS.limit_proceeds_flag%type,
40 terminal_gain_loss FA_RETIREMENTS.terminal_gain_loss%type,
41 reduction_rate FA_RETIREMENTS.reduction_rate%type,
42 eofy_reserve FA_RETIREMENTS.eofy_reserve%type,
43 recapture_amount FA_RETIREMENTS.recapture_amount%type,
44 reserve_retired FA_RETIREMENTS.reserve_retired%type,
45 mrc_sob_type_code varchar2(1),
46 set_of_books_id FA_BOOK_CONTROLS.set_of_books_id%type
47 );
48
49 TYPE book_struct is RECORD(
50 lifemonths FA_BOOKS.life_in_months%type,
51 prorate_mth NUMBER,
52 prorate_fy NUMBER,
53 dsd_mth NUMBER,
54 dsd_fy NUMBER,
55 itc_used FA_BOOKS.itc_basis%type,
56 rate_source_rule INTEGER,
57 deprn_basis_rule INTEGER,
58 cur_units FA_ADDITIONS_B.current_units%type,
59 jdis NUMBER,
60 prorate_jdate NUMBER,
61 deprn_start_jdate NUMBER,
62 pers_per_yr NUMBER,
63 cpd_fiscal_year FA_BOOK_CONTROLS.current_fiscal_year%type,
64 ret_fiscal_year NUMBER,
65 method_code FA_METHODS.method_code%type,
66 raf FA_BOOKS.rate_adjustment_factor%type,
67 adj_rate FA_BOOKS.adjusted_rate%type,
68 adjusted_cost FA_BOOKS.adjusted_cost%type,
69 current_cost FA_BOOKS.cost%type,
70 recoverable_cost FA_BOOKS.recoverable_cost%type,
71 salvage_value FA_BOOKS.salvage_value%type,
72 itc_amount FA_BOOKS.itc_amount%type,
73 capitalize BOOLEAN,
74 depreciate BOOLEAN,
75 fully_reserved BOOLEAN,
76 depreciate_lastyr BOOLEAN,
77 book_class BOOLEAN,
78 prorate_date FA_BOOKS.prorate_date%type,
79 deprn_start_date FA_BOOKS.deprn_start_date%type,
80 date_in_srv FA_BOOKS.date_placed_in_service%type,
81 p_cal FA_BOOK_CONTROLS.prorate_calendar%type,
82 d_cal FA_BOOK_CONTROLS.deprn_calendar%type,
83 ret_prorate_date FA_CONVENTIONS.prorate_date%type,
84 dis_book FA_BOOK_CONTROLS.distribution_source_book%type,
85 ceiling_name FA_BOOKS.ceiling_name%type,
86 bonus_rule FA_BOOKS.bonus_rule%type,
87 reval_amort_basis FA_BOOKS.reval_amortization_basis%type,
88 unrevalued_cost FA_BOOKS.unrevalued_cost%type,
89 adj_capacity FA_BOOKS.adjusted_capacity%type,
90 capacity FA_BOOKS.production_capacity%type,
91 fiscal_year_name FA_BOOK_CONTROLS.fiscal_year_name%type,
92 adj_rec_cost number,
93 deprn_rounding_flag integer,
94 -- FA_BOOKS.ANNUAL_DEPRN_ROUNDING_FLAG
95 -- NULL->0, 'ADD'->1, 'ADJ'->2
96 -- 'RET'->3, 'REV'->4, 'TRF'->5
97 -- Others->-1
98 short_fiscal_year_flag FA_BOOKS.short_fiscal_year_flag%type,
99 conversion_date FA_BOOKS.conversion_date%type,
100 orig_deprn_start_date FA_BOOKS.original_deprn_start_date%type,
101 formula_factor FA_BOOKS.formula_factor%type,
102 old_adj_cost FA_BOOKS.old_adjusted_cost%type,
103 allowed_deprn_limit_amount FA_BOOKS.allowed_deprn_limit_amount%type,
104 group_asset_id FA_BOOKS.group_asset_id%type,
105 recognize_gain_loss FA_BOOKS.RECOGNIZE_GAIN_LOSS%TYPE,
106 recapture_reserve_flag FA_BOOKS.RECAPTURE_RESERVE_FLAG%TYPE,
107 limit_proceeds_flag FA_BOOKS.LIMIT_PROCEEDS_FLAG%TYPE,
108 terminal_gain_loss FA_BOOKS.TERMINAL_GAIN_LOSS%TYPE,
109 tracking_method FA_BOOKS.TRACKING_METHOD%TYPE,
110 exclude_fully_rsv_flag FA_BOOKS.EXCLUDE_FULLY_RSV_FLAG%TYPE,
111 excess_allocation_option FA_BOOKS.EXCESS_ALLOCATION_OPTION%TYPE,
112 depreciation_option FA_BOOKS.DEPRECIATION_OPTION%TYPE,
113 member_rollup_flag FA_BOOKS.MEMBER_ROLLUP_FLAG%TYPE,
114 ltd_proceeds FA_BOOKS.LTD_PROCEEDS%TYPE,
115 allocate_to_fully_rsv_flag FA_BOOKS.ALLOCATE_TO_FULLY_RSV_FLAG%TYPE,
116 allocate_to_fully_ret_flag FA_BOOKS.ALLOCATE_TO_FULLY_RET_FLAG%TYPE,
117 eofy_reserve FA_BOOKS.EOFY_RESERVE%TYPE,
118 cip_cost FA_BOOKS.CIP_COST%TYPE,
119 ltd_cost_of_removal FA_BOOKS.LTD_COST_OF_REMOVAL%TYPE,
120 prior_eofy_reserve FA_BOOKS.PRIOR_EOFY_RESERVE%TYPE,
121 eop_adj_cost FA_BOOKS.EOP_ADJ_COST%TYPE,
122 eop_formula_factor FA_BOOKS.EOP_FORMULA_FACTOR%TYPE,
123 exclude_proceeds_from_basis FA_BOOKS.EXCLUDE_PROCEEDS_FROM_BASIS%TYPE,
124 retirement_deprn_option FA_BOOKS.RETIREMENT_DEPRN_OPTION%TYPE,
125 terminal_gain_loss_amount FA_BOOKS.terminal_gain_loss_amount%type,
126 adjusted_recoverable_cost NUMBER,
127 pc_fully_reserved NUMBER,
128 depr_first_year_ret NUMBER,
129 fully_extended BOOLEAN, -- Bug 6660490
130 pc_fully_extended NUMBER, -- Bug 6660490
131 extended_flag BOOLEAN, -- Bug 6660490
132 pc_extended NUMBER, -- Bug 8211842
133 start_extended BOOLEAN -- Bug 8211842
134 );
135
136 TYPE dpr_detail_struct IS RECORD(
137 dist_id fa_std_types.number_tbl_type,
138 ccid fa_std_types.number_tbl_type,
139 deprn_amount fa_std_types.number_tbl_type,
140 adj_amount fa_std_types.number_tbl_type,
141 annualized_adj fa_std_types.number_tbl_type
142 );
143
144 END FA_RET_TYPES;