DBA Data[Home] [Help]

PACKAGE: APPS.FA_REC_PVT_PKG2

Source


1 PACKAGE FA_REC_PVT_PKG2 AS
2 /* $Header: FAXVRC2S.pls 120.2 2005/06/24 15:11:53 msiddiqu 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 default null
56         )       RETURN BOOLEAN;
57 
58 
59 /*=====================================================================================+
60 |
61 |   Name:          Validate_Adjustment
62 |
63 |   Description:   Function to validate an adjustment transaction.
64 |
65 |   Parameters:	   p_asset_id - Asset ID.
66 |		   p_book_type_code - Book(corporate or tax) the asset belongs to.
67 |   		   p_amortize_flag - Indicates whether to amortize the adjustment
68 |		   	or not.
69 |		   p_mr_req_id - Mass request ID.  -1 by default for single transaction.
70 |
71 |   Returns:       TRUE or FALSE (BOOLEAN)
72 |                  TRUE - Validation sucess.
73 |                  FALSE - Validation failed.
74 |
75 |   Notes:         Called from Validate_Redefault.
76 |
77 +====================================================================================*/
78 
79 FUNCTION Validate_Adjustment(
80         p_asset_id         IN  NUMBER,
81 	     p_book_type_code	IN	 VARCHAR2,
82 	     p_amortize_flag		IN	 VARCHAR2,
83 	     p_mr_req_id		   IN	 NUMBER := -1,
84         p_log_level_rec    IN  FA_API_TYPES.log_level_rec_type default null
85         )  RETURN BOOLEAN;
86 
87 END FA_REC_PVT_PKG2;