[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;