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