[Home] [Help]
PACKAGE: APPS.FA_REC_PVT_PKG3
Source
1 PACKAGE FA_REC_PVT_PKG3 AUTHID CURRENT_USER AS
2 /* $Header: FAXVRC3S.pls 120.3 2009/03/27 04:52:11 bridgway 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) RETURN BOOLEAN;
45
46
47 /*=====================================================================================+
48 |
49 | Name: Validate_Ceiling
50 |
51 | Description: Validates new depreciation ceiling.
52 |
53 | Parameters: p_asset_id - Asset ID.
54 | p_book_type_code - Book(corporate or tax) the asset belongs to.
55 | p_old_ceiling_name - Current ceiling name.
56 | p_new_ceiling_name - New ceiling name.
57 |
58 | Returns: TRUE or FALSE (BOOLEAN)
59 | TRUE - Validation sucess.
60 | FALSE - Validation failed.
61 |
62 | Notes: Called from Validate_Rule_Changes.
63 |
64 +====================================================================================*/
65
66 FUNCTION Validate_Ceiling(
67 p_asset_id IN NUMBER,
68 p_book_type_code IN VARCHAR2,
69 p_old_ceiling_name IN VARCHAR2,
70 p_new_ceiling_name IN VARCHAR2
71 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
72
73
74 /*=====================================================================================+
75 |
76 | Name: Validate_Deprn_Flag
77 |
78 | Description: Validates new depreciation flag.
79 |
80 | Parameters: p_old_rules - Current asset depreciation rules.
81 | p_new_rules - New asset depreciation rules.
82 |
83 | Returns: TRUE or FALSE (BOOLEAN)
84 | TRUE - Validation sucess.
85 | FALSE - Validation failed.
86 |
87 | Notes: Called from Validate_Rule_Changes.
88 |
89 +====================================================================================*/
90
91 FUNCTION Validate_Deprn_Flag(
92 p_old_rules IN FA_LOAD_TBL_PKG.asset_deprn_info,
93 p_new_rules IN FA_LOAD_TBL_PKG.asset_deprn_info
94 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
95
96
97 /*=====================================================================================+
98 |
99 | Name: Validate_Convention
100 |
101 | Description: Validates new prorate convention.
102 |
103 | Parameters: p_asset_id - Asset ID.
104 | p_book_type_code - Book(corporate or tax) the asset belongs to.
105 | p_date_placed_in_service - Date placed in service.
106 | p_old_conv - Current prorate convention.
107 | p_new_conv - New prorate convention.
108 | p_amortize_flag - Indicates whether to amortize the adjustment
109 | or not.
110 | x_prorate_date - OUT NOCOPY value. New prorate date from the new
111 | prorate convention.
112 |
113 | Returns: TRUE or FALSE (BOOLEAN)
114 | TRUE - Validation sucess.
115 | FALSE - Validation failed.
116 |
117 | Notes: Called from Validate_Rule_Changes.
118 |
119 +====================================================================================*/
120
121 FUNCTION Validate_Convention(
122 p_asset_id IN NUMBER,
123 p_book_type_code IN VARCHAR2,
124 p_date_placed_in_service IN DATE,
125 p_old_conv IN VARCHAR2,
126 p_new_conv IN VARCHAR2,
127 p_amortize_flag IN VARCHAR2,
128 x_prorate_date OUT NOCOPY DATE
129 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
130
131
132 /*=====================================================================================+
133 |
134 | Name: Validate_Deprn_Method
135 |
136 | Description: Validates new depreciation method.
137 |
138 | Parameters: p_asset_id - Asset ID.
139 | p_book_type_code - Book(corporate or tax) the asset belongs to.
140 | p_old_deprn_method - Current depreciation method.
141 | p_new_deprn_method - New depreciation method.
142 | p_new_category_id - New category to change to.
143 | -- Next two arguments to implement short tax years.
144 | x_rate_source_rule - OUT NOCOPY value. Identifies depreciation
145 | rate source.
146 | x_deprn_basis_rule - OUT NOCOPY value. Depreciable basis --
147 | cost or NBV.
148 |
149 | Returns: TRUE or FALSE (BOOLEAN)
150 | TRUE - Validation sucess.
151 | FALSE - Validation failed.
152 |
153 | Notes: Called from Validate_Rule_Changes.
154 |
155 +====================================================================================*/
156
157 FUNCTION Validate_Deprn_Method(
158 p_asset_id IN NUMBER,
159 p_book_type_code IN VARCHAR2,
160 p_old_deprn_method IN VARCHAR2,
161 p_new_deprn_method IN VARCHAR2,
162 p_new_category_id IN NUMBER,
163 x_rate_source_rule OUT NOCOPY VARCHAR2,
164 x_deprn_basis_rule OUT NOCOPY VARCHAR2
165 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
166
167
168 /*=====================================================================================+
169 |
170 | Name: Validate_Life_Rates
171 |
172 | Description: Ensure that new life and rate values exist in the tables
173 | for the new depreciation method.
174 |
175 | Parameters: p_deprn_method - New depreciation method.
176 | p_basic_rate - New basic rate.
177 | p_adjusted_rate - New adjusted rate.
178 | p_life_in_months - New life.
179 |
180 | Returns: TRUE or FALSE (BOOLEAN)
181 | TRUE - Validation sucess.
182 | FALSE - Validation failed.
183 |
184 | Notes: Called from Validate_Rule_Changes.
185 |
186 +====================================================================================*/
187
188 FUNCTION Validate_Life_Rates(
189 p_deprn_method IN VARCHAR2,
190 p_basic_rate IN NUMBER,
191 p_adjusted_rate IN NUMBER,
192 p_life_in_months IN NUMBER
193 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
194
195
196 END FA_REC_PVT_PKG3;