DBA Data[Home] [Help]

PACKAGE: APPS.FA_DEPRN_BASIS_RULES_PKG

Source


1 PACKAGE FA_DEPRN_BASIS_RULES_PKG as
2 /* $Header: faxtdbrs.pls 120.6 2005/08/16 21:12:47 glchen noship $ */
3 
4   PROCEDURE Insert_Row(	X_deprn_basis_rule_id		IN OUT NOCOPY NUMBER,
5 			X_rule_name			   VARCHAR2,
6 			X_user_rule_name		VARCHAR2 DEFAULT NULL,
7 			X_last_update_date	DATE,
8 			X_last_updated_by		NUMBER,
9 			X_created_by			NUMBER,
10 			X_creation_date		DATE,
11 			X_last_update_login	NUMBER,
12 			X_rate_source			VARCHAR2 DEFAULT NULL,
13 			X_calculation_basis  VARCHAR2 DEFAULT NULL,
14 			X_enabled_flag			VARCHAR2,
15 			X_program_name			VARCHAR2,
16          X_description        VARCHAR2 DEFAULT NULL,
17          p_log_level_rec      IN     FA_API_TYPES.log_level_rec_type default null );
18 
19   PROCEDURE Lock_Row (	X_deprn_basis_rule_id	NUMBER,
20 			X_rule_name			   VARCHAR2,
21 			X_user_rule_name		VARCHAR2 DEFAULT NULL,
22 			X_last_update_date	DATE,
23 			X_last_updated_by		NUMBER,
24 			X_last_update_login	NUMBER,
25 			X_rate_source			VARCHAR2 DEFAULT NULL,
26 			X_calculation_basis	VARCHAR2 DEFAULT NULL,
27 			X_enabled_flag			VARCHAR2,
28 			X_program_name			VARCHAR2,
29          X_description        VARCHAR2 DEFAULT NULL,
30          p_log_level_rec      IN     FA_API_TYPES.log_level_rec_type default null );
31 
32 
33   PROCEDURE Update_Row( X_deprn_basis_rule_id		NUMBER,
34 			X_rule_name			   VARCHAR2,
35 			X_user_rule_name		VARCHAR2 DEFAULT NULL,
36 			X_last_update_date	DATE,
37 			X_last_updated_by		NUMBER,
38 			X_last_update_login	NUMBER,
39 			X_rate_source			VARCHAR2 DEFAULT NULL,
40 			X_calculation_basis	VARCHAR2 DEFAULT NULL,
41 			X_enabled_flag			VARCHAR2,
42 			X_program_name			VARCHAR2,
43          X_description        VARCHAR2 DEFAULT NULL,
44          p_log_level_rec      IN     FA_API_TYPES.log_level_rec_type default null );
45 
46   PROCEDURE Delete_Row(X_deprn_basis_rule_id 	NUMBER,
47                        p_log_level_rec   IN     FA_API_TYPES.log_level_rec_type default null);
48 
49   PROCEDURE LOAD_ROW (X_custom_mode         IN VARCHAR2,
50                       X_deprn_basis_rule_id IN NUMBER,
51                       X_owner               IN VARCHAR2,
52                       X_last_update_date    IN DATE,
53                       X_rule_name           IN VARCHAR2,
54                       X_user_rule_name      IN VARCHAR2 DEFAULT NULL,
55                       X_rate_source         IN VARCHAR2 DEFAULT NULL,
56                       X_calculation_basis   IN VARCHAR2 DEFAULT NULL,
57                       X_enabled_flag        IN VARCHAR2,
58                       X_program_name        IN VARCHAR2,
59                       X_description         IN VARCHAR2 DEFAULT NULL,
60                       p_log_level_rec       IN FA_API_TYPES.log_level_rec_type
61                                                         DEFAULT NULL);
62 
63 procedure TRANSLATE_ROW (
64       X_CUSTOM_MODE         in VARCHAR2,
65       X_DEPRN_BASIS_RULE_ID in NUMBER,
66       X_OWNER	            in VARCHAR2,
67       X_LAST_UPDATE_DATE    in DATE,
68       X_USER_RULE_NAME      in VARCHAR2 DEFAULT NULL,
69       X_RULE_NAME           in VARCHAR2 DEFAULT NULL,
70       X_DESCRIPTION         in VARCHAR2 DEFAULT NULL,
71       p_log_level_rec       IN FA_API_TYPES.log_level_rec_type default null );
72 
73 procedure LOAD_SEED_ROW (
74                 X_upload_mode                   IN VARCHAR2,
75                 X_custom_mode                   IN VARCHAR2,
76                 X_deprn_basis_rule_id           IN NUMBER,
77                 X_owner                         IN VARCHAR2,
78                 X_last_update_date              IN DATE,
79                 X_rule_name                     IN VARCHAR2,
80                 X_user_rule_name                IN VARCHAR2,
81                 X_description                   IN VARCHAR2,
82                 X_enabled_flag                  IN VARCHAR2,
83                 X_program_name                  IN VARCHAR2);
84 
85 END FA_DEPRN_BASIS_RULES_PKG;