DBA Data[Home] [Help]

PACKAGE: APPS.FA_BONUS_RATES_PKG

Source


1 PACKAGE FA_BONUS_RATES_PKG as
2 /* $Header: faxibors.pls 120.4 2005/07/18 09:05:56 glchen ship $ */
3 
4 procedure INSERT_ROW (
5    X_ROWID in out nocopy VARCHAR2,
6    X_BONUS_RULE in VARCHAR2,
7    X_START_YEAR in NUMBER,
8    X_END_YEAR in NUMBER,
9    X_BONUS_RATE in NUMBER,
10    X_ATTRIBUTE1 in VARCHAR2,
11    X_ATTRIBUTE2 in VARCHAR2,
12    X_ATTRIBUTE3 in VARCHAR2,
13    X_ATTRIBUTE4 in VARCHAR2,
14    X_ATTRIBUTE5 in VARCHAR2,
15    X_ATTRIBUTE6 in VARCHAR2,
16    X_ATTRIBUTE7 in VARCHAR2,
17    X_ATTRIBUTE8 in VARCHAR2,
18    X_ATTRIBUTE9 in VARCHAR2,
19    X_ATTRIBUTE10 in VARCHAR2,
20    X_ATTRIBUTE11 in VARCHAR2,
21    X_ATTRIBUTE12 in VARCHAR2,
22    X_ATTRIBUTE13 in VARCHAR2,
23    X_ATTRIBUTE14 in VARCHAR2,
24    X_ATTRIBUTE15 in VARCHAR2,
25    X_ATTRIBUTE_CATEGORY_CODE in VARCHAR2,
26    X_CREATION_DATE in DATE,
27    X_CREATED_BY in NUMBER,
28    X_LAST_UPDATE_DATE in DATE,
29    X_LAST_UPDATED_BY in NUMBER,
30    X_LAST_UPDATE_LOGIN in NUMBER,
31    p_log_level_rec    in      fa_api_types.log_level_rec_type default null);
32 
33 procedure LOCK_ROW (
34    X_BONUS_RULE in VARCHAR2,
35    X_START_YEAR in NUMBER,
36    X_END_YEAR in NUMBER,
37    X_BONUS_RATE in NUMBER,
38    X_ATTRIBUTE1 in VARCHAR2,
39    X_ATTRIBUTE2 in VARCHAR2,
40    X_ATTRIBUTE3 in VARCHAR2,
41    X_ATTRIBUTE4 in VARCHAR2,
42    X_ATTRIBUTE5 in VARCHAR2,
43    X_ATTRIBUTE6 in VARCHAR2,
44    X_ATTRIBUTE7 in VARCHAR2,
45    X_ATTRIBUTE8 in VARCHAR2,
46    X_ATTRIBUTE9 in VARCHAR2,
47    X_ATTRIBUTE10 in VARCHAR2,
48    X_ATTRIBUTE11 in VARCHAR2,
49    X_ATTRIBUTE12 in VARCHAR2,
50    X_ATTRIBUTE13 in VARCHAR2,
51    X_ATTRIBUTE14 in VARCHAR2,
52    X_ATTRIBUTE15 in VARCHAR2,
53    X_ATTRIBUTE_CATEGORY_CODE in VARCHAR2,
54    p_log_level_rec    in      fa_api_types.log_level_rec_type default null
55 );
56 
57 procedure UPDATE_ROW (
58    X_BONUS_RULE in VARCHAR2,
59    X_START_YEAR in NUMBER,
60    X_END_YEAR in NUMBER,
61    X_BONUS_RATE in NUMBER,
62    X_ATTRIBUTE1 in VARCHAR2,
63    X_ATTRIBUTE2 in VARCHAR2,
64    X_ATTRIBUTE3 in VARCHAR2,
65    X_ATTRIBUTE4 in VARCHAR2,
66    X_ATTRIBUTE5 in VARCHAR2,
67    X_ATTRIBUTE6 in VARCHAR2,
68    X_ATTRIBUTE7 in VARCHAR2,
69    X_ATTRIBUTE8 in VARCHAR2,
70    X_ATTRIBUTE9 in VARCHAR2,
71    X_ATTRIBUTE10 in VARCHAR2,
72    X_ATTRIBUTE11 in VARCHAR2,
73    X_ATTRIBUTE12 in VARCHAR2,
74    X_ATTRIBUTE13 in VARCHAR2,
75    X_ATTRIBUTE14 in VARCHAR2,
76    X_ATTRIBUTE15 in VARCHAR2,
77    X_ATTRIBUTE_CATEGORY_CODE in VARCHAR2,
78    X_LAST_UPDATE_DATE in DATE,
79    X_LAST_UPDATED_BY in NUMBER,
80    X_LAST_UPDATE_LOGIN in NUMBER,
81    p_log_level_rec    in      fa_api_types.log_level_rec_type default null
82 );
83 procedure DELETE_ROW (
84    X_BONUS_RULE in VARCHAR2,
85    X_START_YEAR in NUMBER,
86    p_log_level_rec    in      fa_api_types.log_level_rec_type default null
87 );
88 
89 procedure LOAD_ROW (
90    X_CUSTOM_MODE in VARCHAR2,
91    X_BONUS_RULE in VARCHAR2,
92    X_OWNER in VARCHAR2,
93    X_LAST_UPDATE_DATE in DATE,
94    X_START_YEAR in NUMBER,
95    X_END_YEAR in NUMBER,
96    X_BONUS_RATE in VARCHAR2,
97    X_ATTRIBUTE1 in VARCHAR2,
98    X_ATTRIBUTE2 in VARCHAR2,
99    X_ATTRIBUTE3 in VARCHAR2,
100    X_ATTRIBUTE4 in VARCHAR2,
101    X_ATTRIBUTE5 in VARCHAR2,
102    X_ATTRIBUTE6 in VARCHAR2,
103    X_ATTRIBUTE7 in VARCHAR2,
104    X_ATTRIBUTE8 in VARCHAR2,
105    X_ATTRIBUTE9 in VARCHAR2,
106    X_ATTRIBUTE10 in VARCHAR2,
107    X_ATTRIBUTE11 in VARCHAR2,
108    X_ATTRIBUTE12 in VARCHAR2,
109    X_ATTRIBUTE13 in VARCHAR2,
110    X_ATTRIBUTE14 in VARCHAR2,
111    X_ATTRIBUTE15 in VARCHAR2,
112    X_ATTRIBUTE_CATEGORY_CODE in VARCHAR2,
113    p_log_level_rec    in      fa_api_types.log_level_rec_type default null
114 );
115 
116 procedure LOAD_SEED_ROW (
117              x_upload_mode              IN VARCHAR2,
118              x_custom_mode              IN VARCHAR2,
119              x_bonus_rule               IN VARCHAR2,
120              x_owner                    IN VARCHAR2,
121              x_last_update_date         IN DATE,
122              x_start_year               IN NUMBER,
123              x_end_year                 IN NUMBER,
124              x_bonus_rate               IN NUMBER,
125              x_attribute1               IN VARCHAR2,
126              x_attribute2               IN VARCHAR2,
127              x_attribute3               IN VARCHAR2,
128              x_attribute4               IN VARCHAR2,
129              x_attribute5               IN VARCHAR2,
130              x_attribute6               IN VARCHAR2,
131              x_attribute7               IN VARCHAR2,
132              x_attribute8               IN VARCHAR2,
133              x_attribute9               IN VARCHAR2,
134              x_attribute10              IN VARCHAR2,
135              x_attribute11              IN VARCHAR2,
136              x_attribute12              IN VARCHAR2,
137              x_attribute13              IN VARCHAR2,
138              x_attribute14              IN VARCHAR2,
139              x_attribute15              IN VARCHAR2,
140              x_attribute_category_code  IN VARCHAR2);
141 
142 END FA_BONUS_RATES_PKG;