[Home] [Help]
PACKAGE: APPS.FA_REC_PVT_PKG3
Source
1 PACKAGE FA_REC_PVT_PKG3 AS
2 /* $Header: FAXVRC3S.pls 120.2 2005/06/24 15:10:53 msiddiqu ship $ */
3
4 /*=====================================================================================+
5 |
6 | Name: Validate_Rule_Changes
7 |
8 | Description: Checks if change can be made on each depreciation rule.
9 |
10 | Parameters: p_asset_id - Asset ID.
11 | p_new_category_id - New category to change to.
12 | p_book_type_code - Book(corporate or tax) the asset belongs to.
13 | p_amortize_flag - Indicates whether to amortize the adjustment
14 | or not.
15 | p_old_rules - Current depreciation rules record from books row.
16 | p_new_rules - New depreciation rules record from the new
17 | category.
18 | x_prorate_date - OUT NOCOPY value. New prorate date from the new
19 | prorate convention.
20 | -- Next two arguments to implement short tax years.
21 | x_rate_source_rule - OUT NOCOPY value. Identifies depreciation
22 | rate source.
23 | x_deprn_basis_rule - OUT NOCOPY value. Depreciable basis --
24 | cost or NBV.
25 |
26 | Returns: TRUE or FALSE (BOOLEAN)
27 | TRUE - Validation sucess.
28 | FALSE - Validation failed.
29 |
30 | Notes: Called from Validate_Redefault.
31 |
32 +====================================================================================*/
33
34 FUNCTION Validate_Rule_Changes(
35 p_asset_id IN NUMBER,
36 p_new_category_id IN NUMBER,
37 p_book_type_code IN VARCHAR2,
38 p_amortize_flag IN VARCHAR2,
39 p_old_rules IN FA_LOAD_TBL_PKG.asset_deprn_info,
40 p_new_rules IN FA_LOAD_TBL_PKG.asset_deprn_info,
41 x_prorate_date OUT NOCOPY DATE,
42 x_rate_source_rule OUT NOCOPY VARCHAR2,
43 x_deprn_basis_rule OUT NOCOPY VARCHAR2,
44 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
45 ) RETURN BOOLEAN;
46
47
48 /*=====================================================================================+
49 |
50 | Name: Validate_Ceiling
51 |
52 | Description: Validates new depreciation ceiling.
53 |
54 | Parameters: p_asset_id - Asset ID.
55 | p_book_type_code - Book(corporate or tax) the asset belongs to.
56 | p_old_ceiling_name - Current ceiling name.
57 | p_new_ceiling_name - New ceiling name.
58 |
59 | Returns: TRUE or FALSE (BOOLEAN)
60 | TRUE - Validation sucess.
61 | FALSE - Validation failed.
62 |
63 | Notes: Called from Validate_Rule_Changes.
64 |
65 +====================================================================================*/
66
67 FUNCTION Validate_Ceiling(
68 p_asset_id IN NUMBER,
69 p_book_type_code IN VARCHAR2,
70 p_old_ceiling_name IN VARCHAR2,
71 p_new_ceiling_name IN VARCHAR2,
72 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
73 ) RETURN BOOLEAN;
74
75
76 /*=====================================================================================+
77 |
78 | Name: Validate_Deprn_Flag
79 |
80 | Description: Validates new depreciation flag.
81 |
82 | Parameters: p_old_rules - Current asset depreciation rules.
83 | p_new_rules - New asset depreciation rules.
84 |
85 | Returns: TRUE or FALSE (BOOLEAN)
86 | TRUE - Validation sucess.
87 | FALSE - Validation failed.
88 |
89 | Notes: Called from Validate_Rule_Changes.
90 |
91 +====================================================================================*/
92
93 FUNCTION Validate_Deprn_Flag(
94 p_old_rules IN FA_LOAD_TBL_PKG.asset_deprn_info,
95 p_new_rules IN FA_LOAD_TBL_PKG.asset_deprn_info,
96 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
97 ) RETURN BOOLEAN;
98
99
100 /*=====================================================================================+
101 |
102 | Name: Validate_Convention
103 |
104 | Description: Validates new prorate convention.
105 |
106 | Parameters: p_asset_id - Asset ID.
107 | p_book_type_code - Book(corporate or tax) the asset belongs to.
108 | p_date_placed_in_service - Date placed in service.
109 | p_old_conv - Current prorate convention.
110 | p_new_conv - New prorate convention.
111 | p_amortize_flag - Indicates whether to amortize the adjustment
112 | or not.
113 | x_prorate_date - OUT NOCOPY value. New prorate date from the new
114 | prorate convention.
115 |
116 | Returns: TRUE or FALSE (BOOLEAN)
117 | TRUE - Validation sucess.
118 | FALSE - Validation failed.
119 |
120 | Notes: Called from Validate_Rule_Changes.
121 |
122 +====================================================================================*/
123
124 FUNCTION Validate_Convention(
125 p_asset_id IN NUMBER,
126 p_book_type_code IN VARCHAR2,
127 p_date_placed_in_service IN DATE,
128 p_old_conv IN VARCHAR2,
129 p_new_conv IN VARCHAR2,
130 p_amortize_flag IN VARCHAR2,
131 x_prorate_date OUT NOCOPY DATE,
132 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
133 ) RETURN BOOLEAN;
134
135
136 /*=====================================================================================+
137 |
138 | Name: Validate_Deprn_Method
139 |
140 | Description: Validates new depreciation method.
141 |
142 | Parameters: p_asset_id - Asset ID.
143 | p_book_type_code - Book(corporate or tax) the asset belongs to.
144 | p_old_deprn_method - Current depreciation method.
145 | p_new_deprn_method - New depreciation method.
146 | p_new_category_id - New category to change to.
147 | -- Next two arguments to implement short tax years.
148 | x_rate_source_rule - OUT NOCOPY value. Identifies depreciation
149 | rate source.
150 | x_deprn_basis_rule - OUT NOCOPY value. Depreciable basis --
151 | cost or NBV.
152 |
153 | Returns: TRUE or FALSE (BOOLEAN)
154 | TRUE - Validation sucess.
155 | FALSE - Validation failed.
156 |
157 | Notes: Called from Validate_Rule_Changes.
158 |
159 +====================================================================================*/
160
161 FUNCTION Validate_Deprn_Method(
162 p_asset_id IN NUMBER,
163 p_book_type_code IN VARCHAR2,
164 p_old_deprn_method IN VARCHAR2,
165 p_new_deprn_method IN VARCHAR2,
166 p_new_category_id IN NUMBER,
167 x_rate_source_rule OUT NOCOPY VARCHAR2,
168 x_deprn_basis_rule OUT NOCOPY VARCHAR2,
169 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
170 ) RETURN BOOLEAN;
171
172
173 /*=====================================================================================+
174 |
175 | Name: Validate_Life_Rates
176 |
177 | Description: Ensure that new life and rate values exist in the tables
178 | for the new depreciation method.
179 |
180 | Parameters: p_deprn_method - New depreciation method.
181 | p_basic_rate - New basic rate.
182 | p_adjusted_rate - New adjusted rate.
183 | p_life_in_months - New life.
184 |
185 | Returns: TRUE or FALSE (BOOLEAN)
186 | TRUE - Validation sucess.
187 | FALSE - Validation failed.
188 |
189 | Notes: Called from Validate_Rule_Changes.
190 |
191 +====================================================================================*/
192
193 FUNCTION Validate_Life_Rates(
194 p_deprn_method IN VARCHAR2,
195 p_basic_rate IN NUMBER,
196 p_adjusted_rate IN NUMBER,
197 p_life_in_months IN NUMBER,
198 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
199 ) RETURN BOOLEAN;
200
201
202 END FA_REC_PVT_PKG3;