[Home] [Help]
PACKAGE: APPS.FA_DEPRN_BASIS_RULES_PKG
Source
1 PACKAGE FA_DEPRN_BASIS_RULES_PKG AUTHID CURRENT_USER as
2 /* $Header: faxtdbrs.pls 120.8.12020000.2 2012/07/19 12:45:23 dvjoshi ship $ */
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);
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);
31
32 PROCEDURE Update_Row( X_deprn_basis_rule_id NUMBER,
33 X_rule_name VARCHAR2,
34 X_user_rule_name VARCHAR2 DEFAULT NULL,
35 X_last_update_date DATE,
36 X_last_updated_by NUMBER,
37 X_last_update_login NUMBER,
38 X_rate_source VARCHAR2 DEFAULT NULL,
39 X_calculation_basis VARCHAR2 DEFAULT NULL,
40 X_enabled_flag VARCHAR2,
41 X_program_name VARCHAR2,
42 X_description VARCHAR2 DEFAULT NULL
43 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
44
45 PROCEDURE Delete_Row(X_deprn_basis_rule_id NUMBER
46 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
47
48 PROCEDURE LOAD_ROW ( X_deprn_basis_rule_id NUMBER,
49 X_owner VARCHAR2,
50 X_rule_name VARCHAR2,
51 X_user_rule_name VARCHAR2 DEFAULT NULL,
52 X_rate_source VARCHAR2 DEFAULT NULL,
53 X_calculation_basis VARCHAR2 DEFAULT NULL,
54 X_enabled_flag VARCHAR2,
55 X_program_name VARCHAR2,
56 X_description VARCHAR2 DEFAULT NULL
57 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
58
59 /*Bug 8355119 overloading function for release specific signatures*/
60 PROCEDURE LOAD_ROW (X_custom_mode IN VARCHAR2,
61 X_deprn_basis_rule_id IN NUMBER,
62 X_owner IN VARCHAR2,
63 X_last_update_date IN DATE,
64 X_rule_name IN VARCHAR2,
65 X_user_rule_name IN VARCHAR2 DEFAULT NULL,
66 X_rate_source IN VARCHAR2 DEFAULT NULL,
67 X_calculation_basis IN VARCHAR2 DEFAULT NULL,
68 X_enabled_flag IN VARCHAR2,
69 X_program_name IN VARCHAR2,
70 X_description IN VARCHAR2 DEFAULT NULL,
71 p_log_level_rec IN FA_API_TYPES.log_level_rec_type
72 DEFAULT NULL);
73
74 procedure TRANSLATE_ROW (
75 X_DEPRN_BASIS_RULE_ID in NUMBER,
76 X_OWNER in VARCHAR2,
77 X_USER_RULE_NAME in VARCHAR2 DEFAULT NULL,
78 X_RULE_NAME in VARCHAR2 DEFAULT NULL,
79 X_DESCRIPTION in VARCHAR2 DEFAULT NULL
80 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
81 /*Bug 8355119 overloading function for release specific signatures*/
82 procedure TRANSLATE_ROW (
83 X_CUSTOM_MODE in VARCHAR2,
84 X_DEPRN_BASIS_RULE_ID in NUMBER,
85 X_OWNER in VARCHAR2,
86 X_LAST_UPDATE_DATE in DATE,
87 X_USER_RULE_NAME in VARCHAR2 DEFAULT NULL,
88 X_RULE_NAME in VARCHAR2 DEFAULT NULL,
89 X_DESCRIPTION in VARCHAR2 DEFAULT NULL,
90 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null );
91 /*bug 8355119 adding R12 specific funtion LOAD_SEED_ROW*/
92 procedure LOAD_SEED_ROW (
93 X_upload_mode IN VARCHAR2,
94 X_custom_mode IN VARCHAR2,
95 X_deprn_basis_rule_id IN NUMBER,
96 X_owner IN VARCHAR2,
97 X_last_update_date IN DATE,
98 X_rule_name IN VARCHAR2,
99 X_user_rule_name IN VARCHAR2,
100 X_description IN VARCHAR2,
101 X_enabled_flag IN VARCHAR2,
102 X_program_name IN VARCHAR2);
103
104 END FA_DEPRN_BASIS_RULES_PKG;