1 PACKAGE FA_REC_PVT_PKG2 AUTHID CURRENT_USER AS
2 /* $Header: FAXVRC2S.pls 120.3 2009/03/27 04:49:14 bridgway ship $ */
3
4 /*=====================================================================================+
5 |
6 | Name: Validate_Redefault
7 |
8 | Description: Checks if depreciation rules can be redefaulted from the new
9 | category. Calls other child modules to perform the validation.
10 |
11 | Parameters: p_asset_id - Asset ID.
12 | p_new_category_id - New category to change to.
13 | p_book_type_code - Book(corporate or tax) the asset belongs to.
14 | p_amortize_flag - Indicates whether to amortize the adjustment
15 | or not.
16 | p_mr_req_id - Mass request ID. -1 by default for single transaction.
17 | x_rule_change_exists - OUT NOCOPY value. Indicates whether
18 | depreciation rule change exists from redefaulting the rules
19 | from the new category.
20 | x_old_rules - OUT NOCOPY value. Current depreciation rules record.
21 | x_new_rules - OUT NOCOPY value. New depreciation rules record from
22 | the new category.
23 | x_use_rules - OUT NOCOPY value. Indicates whether to use the
24 | old and new rules record or not. Providing this value,
25 | since PL/SQL record cannot be compared against NULL.
26 | x_prorate_date - OUT NOCOPY value. New prorate date from the new
27 | prorate convention.
28 | -- Next two arguments to implement short tax years.
29 | x_rate_source_rule - OUT NOCOPY value. Identifies depreciation
30 | rate source.
31 | x_deprn_basis_rule - OUT NOCOPY value. Depreciable basis --
32 | cost or NBV.
33 |
34 | Returns: TRUE or FALSE (BOOLEAN)
35 | TRUE - Validation sucess.
36 | FALSE - Validation failed.
37 |
38 | Notes: Called from Redefault_Asset.
39 |
40 +====================================================================================*/
41
42 FUNCTION Validate_Redefault(
43 p_asset_id IN NUMBER,
44 p_new_category_id IN NUMBER,
45 p_book_type_code IN VARCHAR2,
46 p_amortize_flag IN VARCHAR2 := 'NO',
47 p_mr_req_id IN NUMBER := -1,
48 x_rule_change_exists OUT NOCOPY BOOLEAN,
49 x_old_rules OUT NOCOPY FA_LOAD_TBL_PKG.asset_deprn_info,
50 x_new_rules OUT NOCOPY FA_LOAD_TBL_PKG.asset_deprn_info,
51 x_use_rules OUT NOCOPY BOOLEAN,
52 x_prorate_date OUT NOCOPY DATE,
53 x_rate_source_rule OUT NOCOPY VARCHAR2,
54 x_deprn_basis_rule OUT NOCOPY VARCHAR2
55 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
56
57
58 /*=====================================================================================+
59 |
60 | Name: Validate_Adjustment
61 |
62 | Description: Function to validate an adjustment transaction.
63 |
64 | Parameters: p_asset_id - Asset ID.
65 | p_book_type_code - Book(corporate or tax) the asset belongs to.
66 | p_amortize_flag - Indicates whether to amortize the adjustment
67 | or not.
68 | p_mr_req_id - Mass request ID. -1 by default for single transaction.
69 |
70 | Returns: TRUE or FALSE (BOOLEAN)
71 | TRUE - Validation sucess.
72 | FALSE - Validation failed.
73 |
74 | Notes: Called from Validate_Redefault.
75 |
76 +====================================================================================*/
77
78 FUNCTION Validate_Adjustment(
79 p_asset_id IN NUMBER,
80 p_book_type_code IN VARCHAR2,
81 p_amortize_flag IN VARCHAR2,
82 p_mr_req_id IN NUMBER := -1
83 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
84
85 END FA_REC_PVT_PKG2;
[Home] [Help]