[Home] [Help]
PACKAGE: APPS.FA_CDE_PKG
Source
1 PACKAGE FA_CDE_PKG as
2 /* $Header: FACDES.pls 120.15.12010000.1 2008/07/28 13:10:50 appldev ship $ */
3
4 last_book varchar2(16);
5 last_divide_evenly_flag boolean;
6 last_pro_cal varchar2(16);
7 p_pers_per_yr number;
8
9 /*
10 --------------------------------------------------------------------------
11 *
12 * Name
13 * faxgpr
14 *
15 * Description
16 *
17 * Parameters
18 * X_dpr_ptr - Depreciation structure
19 * X_period - Structure containing period information
20 * X_projecting_flag - Flag indicating depreciation projection
21 * X_prodn - production (OUT)
22 *
23 * Modifies
24 * X_prodn
25 * fa_periodic_production.used_flag
26 *
27 * Returns
28 * True on successful retrieval. Otherwise False.
29 *
30 * Notes
31 *
32 * History
33 *
34 *--------------------------------------------------------------------------
35 */
36 FUNCTION faxgpr (X_dpr_ptr fa_std_types.dpr_struct,
37 X_period fa_std_types.fa_cp_struct,
38 X_projecting_flag BOOLEAN, X_prodn in out nocopy NUMBER,
39 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
40 return boolean;
41
42
43 /*
44 --------------------------------------------------------------------------
45 *
46 * Name
47 * faxgtr
48 *
49 * Description
50 * Get table-based depreciation rate
51 *
52 * Parameters
53 * X_method_id - Depreciation method id
54 * X_year_of_life - Year
55 * X_prorate_period - Prorate period
56 * X_rate out - Depreciation rate (OUT)
57 *
58 * Modifies
59 * X_rate
60 *
61 * Returns
62 * True on successful retrieval. Otherwise False.
63 *
64 * Notes
65 *
66 * History
67 *
68 *--------------------------------------------------------------------------
69 */
70 FUNCTION faxgtr (X_method_id number, X_year_of_life number,
71 X_prorate_period number, X_rate out nocopy number,
72 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
73 return boolean;
74
75
76
77 /*
78 --------------------------------------------------------------------------
79 *
80 * Name
81 * faxcfyf
82 *
83 * Description
84 * Returns the fraction of depreciation to be taken during
85 * the first fiscal year of an asset's life and the year
86 * retired for use under Straight-Line and Flat-Rate methods
87 *
88 * Parameters
89 * X_dpr - Depreciation structure (IN OUT)
90 * X_d_pers_per_yr - # of periods/year in deprn calendar
91 * X_rate_source_rule - Rate source rule
92 * X_y_begin - Year to begin calculation
93 * X_y_dead - Year in which the asset will be fully reserved
94 * X_y_ret - Year in which the asset will be retired
95 * X_dp_begin - Depreciation start period
96 * X_dpp_begin - Depreciation start prorate period
97 * X_dp_d_ptr - Deprn Period in which the asset will be
98 * fully reserved (IN OUT)
99 * X_dp_r_ptr - Deprn Period in which the asset will be
100 * fully retired
101 * X_dpp_r_ptr - Deprn prorate period in which the asset will be
102 * fully retired
103 * X_pp_begin - Prorate period to begin calculation
104 * X_pp_dead - Prorate period in which asset will be fully
105 * reserved
106 * X_pp_ret - Prorate period in which asset will be fully
107 * retired
108 * X_by_factor - Factor used to calc first year deprn without
109 * considering deprn ceilings (IN OUT)
110 * X_bp_frac - fraction of annual deprn to be allocated to
111 * first period of life (IN OUT)
112 * X_dp_frac - fraction of annual deprn to be allocated to
113 * last period of life (IN OUT)
114 * X_rp_frac - fraction of annual deprn to be allocated to
115 * retirement period (IN OUT)
116 * X_by_frac - fraction of annual deprn to be allocated to
117 * first year (IN OUT)
118 * X_dy_frac - fraction of annual deprn to be allocated to
119 * last year of life (IN OUT)
120 * X_ry_frac - fraction of annual deprn to be allocated to
121 * retirement year (IN OUT)
122 *
123 * Modifies
124 * X_dpr
125 * X_dp_d_ptr
126 * X_by_factor
127 * X_bp_frac
128 * X_dp_frac
129 * X_rp_frac
130 * X_by_frac
131 * X_dy_frac
132 * X_ry_frac
133 * Returns
134 * True on successful retrieval. Otherwise False.
135 *
136 * Notes
137 *
138 * History
139 *
140 *--------------------------------------------------------------------------
141 */
142 --Bug6187408
143 --Added additional parameter x_prd_flag to check for retirement in period of addition
144 FUNCTION faxcfyf (X_dpr in out nocopy fa_std_types.dpr_struct, X_d_pers_per_yr number,
145 X_rate_source_rule varchar2, X_y_begin number,
146 X_y_dead number, X_y_ret number, X_dp_begin number,
147 X_dpp_begin number, X_dp_d_ptr in out nocopy number,
148 X_dp_r_ptr number, X_dpp_r_ptr number, X_pp_begin number,
149 X_pp_dead number, X_pp_ret number, X_by_factor in out nocopy number,
150 X_bp_frac in out nocopy number, X_dp_frac in out number,
151 X_rp_frac in out nocopy number, X_by_frac in out number,
152 X_dy_frac in out nocopy number, X_ry_frac in out number,
153 x_prd_flag varchar2,
154 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
155 return boolean;
156
157 /*
158 --------------------------------------------------------------------------
159 *
160 * Name
161 * faxcde
162 *
163 * Description
164 * Calculate Depreciation Expense
165 *
166 * Parameters
167 * dpr_in - Depreciation "in" structure
168 * dpr_arr - (IN OUT)
169 * dpr_out - Depreciation "out" structure (OUT)
170 * fmode
171 *
172 * Modifies
173 * dpr_out
174 * dpr_arr
175 *
176 * Returns
177 * True on successful retrieval. Otherwise False.
178 *
179 * Notes
180 * Variable names have been changed from the C version
181 * See table in body code that maps new names to old
182 * names.
183 *
184 * History
185 *
186 *--------------------------------------------------------------------------
187 */
188 FUNCTION faxcde ( dpr_in in out nocopy fa_std_types.dpr_struct
189 , dpr_arr in out nocopy fa_std_types.dpr_arr_type
190 , dpr_out in out nocopy fa_std_types.dpr_out_struct
191 , fmode number
192 , p_ind binary_integer default 0,
193 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
194 return boolean;
195
196 /*
197 --------------------------------------------------------------------------
198 *
199 * Name
200 * faprds
201 *
202 * Description
203 * Print depreciation IN structure
204 *
205 * Parameters
206 * X_dpr - Depreciation "in" structure
207 *
208 * Modifies
209 *
210 * Returns
211 * True on successful completion. Otherwise False.
212 *
213 * Notes
214 *
215 * History
216 *
217 *--------------------------------------------------------------------------
218 */
219 FUNCTION faprds (X_dpr fa_std_types.dpr_struct,
220 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
221 return boolean;
222
223 /*
224 --------------------------------------------------------------------------
225 *
226 * Name
227 * faprdos
228 *
229 * Description
230 * Print depreciation OUT structure
231 *
232 * Parameters
233 * X_dpr - Depreciation "out" structure
234 *
235 * Modifies
236 *
237 * Returns
238 * True on successful completion. Otherwise False.
239 *
240 * Notes
241 *
242 * History
243 *
244 *--------------------------------------------------------------------------
245 */
246 FUNCTION faprdos (X_dpr fa_std_types.dpr_out_struct,
247 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
248 return boolean;
249
250 procedure faxgfr (X_Book_Type_Code IN VARCHAR2,
251 X_Asset_Id IN NUMBER,
252 X_Short_Fiscal_Year_Flag IN VARCHAR2,
253 X_Conversion_Date IN DATE := NULL,
254 X_Prorate_Date IN DATE := NULL,
255 X_Orig_Deprn_Start_Date IN DATE := NULL,
256 C_Prorate_Date IN VARCHAR2 := NULL,
257 C_Conversion_Date IN VARCHAR2 := NULL,
258 C_Orig_Deprn_Start_Date IN VARCHAR2 := NULL,
259 X_Method_Code IN VARCHAR2,
260 X_Life_In_Months IN INTEGER,
261 X_Fiscal_Year IN NUMBER,
262 X_Current_Period IN NUMBER,
263
264 -- Bug 6665510: FP: Japan Tax Reform Project
265 X_calling_interface IN VARCHAR2 DEFAULT NULL,
266 X_new_cost IN NUMBER DEFAULT NULL,
267 X_adjusted_cost IN NUMBER DEFAULT NULL,
268
269 X_Rate OUT NOCOPY NUMBER,
270 X_Method_Type OUT NOCOPY NUMBER,
271 X_Success OUT NOCOPY INTEGER,
272 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
273 );
274
275 FUNCTION faxgrl(
276 X_Asset_Id IN NUMBER,
277 X_Book_Type_Code IN VARCHAR2,
278 X_Short_Fiscal_Year_Flag IN VARCHAR2,
279 X_Prorate_Date IN DATE,
280 X_Conversion_Date IN DATE,
281 X_Orig_Deprn_Start_Date IN DATE,
282 X_Fiscal_Year IN NUMBER,
283 X_Life_In_Months IN NUMBER,
284 X_Method_Code IN VARCHAR2,
285 X_Current_Period IN NUMBER,
286 X_rem_life1 OUT NOCOPY NUMBER,
287 X_rem_life2 OUT NOCOPY NUMBER,
288 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
289 return boolean;
290
291 /*
292 --------------------------------------------------------------------------
293 *
294 * Name
295 * fadgpoar()
296 *
297 * Description
298 * Get the Profile Option of Annual Rounding
299 * Parameters
300 *
301 * Modifies
302 *
303 * Returns
304 * returns integer. (1-always round 0-round with restrictions)
305 *
306 * Notes
307 *
308 * History
309 * Mar 1, 2001 astakaha created
310 *--------------------------------------------------------------------------
311 */
312 FUNCTION fadgpoar
313 return integer;
314
315 /*
316 --------------------------------------------------------------------------
317 *
318 * Name
319 * faodda()
320 *
321 * Description
322 * Override the Default Depreciation Amounts
323 * Parameters
324 *
325 * Modifies
326 *
327 * Returns
328 * True on successful completion. Otherwise False.
329 *
330 * Notes
331 * p_recoverable_cost and p_salvage_value are used
332 * only when used_by_adjustment is true.
333 *
334 * History
335 * SEP 1, 2001 astakaha created
336 * OCT 2, 2002 ynatsui added parameters
337 * DEC 5, 2002 ynatsui added ytd parameters
338 * DEC 19, 2002 ynatsui added p_update_override_status
339 *--------------------------------------------------------------------------
340 */
341 FUNCTION faodda(Book IN VARCHAR2,
342 Used_By_Adjustment IN BOOLEAN,
343 Asset_ID IN NUMBER,
344 Bonus_Rule IN VARCHAR2,
345 Fyctr IN NUMBER,
346 Perd_Ctr IN NUMBER,
347 Prod_Rate_Src_Flag IN BOOLEAN,
348 Deprn_Projecting_Flag IN BOOLEAN,
349 p_ytd_deprn IN NUMBER,
350 p_bonus_ytd_deprn IN NUMBER,
351 Override_Depr_Amt OUT NOCOPY NUMBER,
352 Override_Bonus_Amt OUT NOCOPY NUMBER,
353 Deprn_Override_Flag OUT NOCOPY VARCHAR2,
354 Return_Code OUT NOCOPY NUMBER,
355 p_mrc_sob_type_code IN VARCHAR2 DEFAULT NULL,
356 p_recoverable_cost IN NUMBER DEFAULT NULL,
357 p_salvage_value IN NUMBER DEFAULT NULL,
358 p_update_override_status IN BOOLEAN DEFAULT TRUE,
359 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
360 ) return boolean;
361
362 ------------------------------------------------------------------
363 -- Function:
364 -- FATRKM
365 --
366 -- Description:
367 -- Main entry to call Tracking feature
368 -- This function will call TRACK_MEMBER function
369 --
370 ------------------------------------------------------------------
371 FUNCTION fatrkm(p_dpr in fa_std_types.dpr_struct,
372 p_perd_deprn_exp in number,
373 p_perd_bonus_deprn_amount in number,
374 p_perd_ctr in number,
375 p_fyctr in number,
376 p_loop_end_year in number default null,
377 p_loop_end_period in number default null,
378 p_exclude_salvage_value_flag in boolean,
379 p_deprn_basis_rule in varchar2,
380 p_deprn_override_flag in out nocopy varchar2,
381 p_subtract_ytd_flag in varchar2,
382 p_life_complete_flag in boolean,
383 p_fully_reserved_flag in boolean,
384 p_year_deprn_exp in number,
385 p_recoverable_cost in number,
386 p_adj_rec_cost in number,
387 p_current_deprn_reserve in number,
388 p_nbv_threshold in number,
389 p_nbv_thresh_amount in number,
390 p_rec_cost_abs_value in number,
391 p_mode in varchar2 default NULL,
392 x_new_perd_exp out nocopy number,
393 x_new_perd_bonus_deprn_amount out nocopy number,
394 x_life_complete_flag out nocopy boolean,
395 x_fully_reserved_flag out nocopy boolean,
396 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
397 ) return boolean;
398
399 procedure faxgpolr (X_Book_Type_Code IN VARCHAR2,
400 X_Asset_Id IN NUMBER,
401 X_Polish_Rule IN NUMBER,
402 X_Deprn_Factor IN NUMBER,
403 X_Alternate_Deprn_Factor IN NUMBER,
404 X_Polish_Adj_Calc_Basis_Flag
405 IN VARCHAR2,
406 X_Recoverable_Cost IN NUMBER,
407 X_Fiscal_Year IN NUMBER,
408 X_Current_Period IN NUMBER,
409 X_Periods_Per_Year IN NUMBER,
410 X_Year_Retired IN BOOLEAN,
414 X_Depreciate_Flag IN OUT NOCOPY BOOLEAN,
411 X_Projecting_Flag IN BOOLEAN,
412 X_MRC_Sob_Type_Code IN VARCHAR2,
413 X_Rate IN OUT NOCOPY NUMBER,
415 X_Current_Adjusted_Cost IN OUT NOCOPY NUMBER,
416 X_Adjusted_Recoverable_Cost
417 IN OUT NOCOPY NUMBER,
418 X_Success OUT NOCOPY INTEGER,
419 X_Calling_Fn IN VARCHAR2,
420 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
421 );
422
423 END FA_CDE_PKG;