1 PACKAGE FA_SHORT_TAX_YEARS_PKG AS
2 /* $Header: FAXSTYS.pls 120.4 2005/06/24 15:10:44 msiddiqu ship $ */
3
4
5 /*=====================================================================================+
6 |
7 | Name: Calculate_Short_Tax_Vals
8 |
9 | Description: This module calculates remaining life values.
10 | These values are mainly used for assets added in
11 | short tax years that use formula-based depreciation methods.
12 | However, in general it is used for any asset that uses a
13 | formula-based method.
14 |
15 | Parameters: X_Asset_Id - Asset ID.
16 | X_Book_Type_Code - Book the asset belongs to.
17 | X_Short_Fiscal_Year_Flag - Short fiscal year flag in
18 | FA_BOOKS.
19 | X_Deprn_Start_Date - Deprn_Start_Date(in DATE format.)
20 | X_Conversion_Date - Conversion date in FA_BOOKS
21 | (in DATE format.)
22 | X_Curr_Fy_Start_Date - Current fiscal year start date
23 | (in DATE format.)
24 | X_Curr_Fy_End_Date - Current fiscal year end date(in DATE
25 | format.)
26 | C_Deprn_Start_Date - Deprn_Start_Date(in VARCHAR2 format.)
27 | C_Conversion_Date - Conversion date in FA_BOOKS
28 | (in VARCHAR2 format.)
29 | C_Curr_Fy_Start_Date - Current fiscal year start date
30 | (in VARCHAR2 format.)
31 | C_Curr_Fy_End_Date - Current fiscal year end date
32 | (in VARCHAR2 format.)
33 | X_Life_In_Months - Life in months.
34 | X_Rate_Source_Rule - Rate source rule of the depreciation
35 | method for the asset.
36 | X_Remaining_Life1 - OUT NOCOPY parameter. New remaining_life1 value
37 | in FA_BOOKS.
38 | X_Remaining_Life2 - OUT NOCOPY parameter. New remaining_life2 value
39 | in FA_BOOKS.
40 | X_Success - OUT NOCOPY parameter. Indicates whether the procedure
41 | completed successfully or not.
42 | YES - If successful.
43 | No - If failed.
44 |
45 | Returns:
46 |
47 | Notes: 1. Calling modules: depreciation, addition engines, mass
48 | additions, adjustment/reclass - redefault engines, and
49 | mass change program.
50 | 2. 1) If the calling module is a PL/SQL program, the date
51 | values should be passed in DATE types into the
52 | following arguments:
53 | X_Prorate_Date, X_Original_Fyend, X_Curr_Fy_Start_Date,
54 | and X_Curr_Fy_End_Date. (Values are not required for
55 | C_Deprn_Start_Date .. C_Curr_Fy_End_Date in this case.)
56 | 2) If the calling module is a Pro*C program, the date
57 | values should be passed in VARCHAR2 types with
58 | appropriate format masks (DD-MM-YYYY) into the
59 | following arguments:
60 | C_Deprn_Start_Date, C_Original_Fyend, C_Curr_Fy_Start_Date,
61 | and C_Curr_Fy_End_Date. (Values are not required for
62 | X_Deprn_Start_Date .. X_Curr_Fy_End_Date in this case.)
63 |
64 +====================================================================================*/
65
66 PROCEDURE Calculate_Short_Tax_Vals (
67 X_Asset_Id IN NUMBER,
68 X_Book_Type_Code IN VARCHAR2,
69 X_Short_Fiscal_Year_Flag IN VARCHAR2,
70 X_Date_Placed_In_Service IN DATE := NULL,
71 X_Deprn_Start_Date IN DATE := NULL,
72 X_Prorate_Date IN DATE := NULL,
73 X_Conversion_Date IN DATE := NULL,
74 X_Orig_Deprn_Start_Date IN DATE := NULL,
75 X_Curr_Fy_Start_Date IN DATE := NULL,
76 X_Curr_Fy_End_Date IN DATE := NULL,
77 C_Date_Placed_In_Service IN VARCHAR2 := NULL,
78 C_Deprn_Start_Date IN VARCHAR2 := NULL,
79 C_Prorate_Date IN VARCHAR2 := NULL,
80 C_Conversion_Date IN VARCHAR2 := NULL,
81 C_Orig_Deprn_Start_Date IN VARCHAR2 := NULL,
82 C_Curr_Fy_Start_Date IN VARCHAR2 := NULL,
83 C_Curr_Fy_End_Date IN VARCHAR2 := NULL,
84 X_Life_In_Months IN NUMBER,
85 X_Rate_Source_Rule IN VARCHAR2,
86 X_Fiscal_Year IN NUMBER,
87 X_Method_Code IN VARCHAR2,
88 X_Current_Period IN NUMBER,
89 X_Remaining_Life1 OUT NOCOPY NUMBER,
90 X_Remaining_Life2 OUT NOCOPY NUMBER,
91 X_Success OUT NOCOPY VARCHAR2,
92 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null );
93
94
95 END FA_SHORT_TAX_YEARS_PKG;