1 Package ben_eligy_crit_values_api AS
2 /* $Header: beecvapi.pkh 120.1 2005/07/29 09:50:47 rbingi noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_eligy_crit_values >------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 --
11 -- Prerequisites:
12 --
13 --
14 -- In Parameters:
15 -- Name Reqd Type Description
16 -- p_validate Yes boolean Commit or Rollback.
17 -- p_eligy_prfl_id Yes Number
18 -- p_eligy_criteria_id Yes Number
19 -- p_ordr_num No Number
20 -- p_number_value1 No Number
21 -- p_number_value2 No Number
22 -- p_char_value1 No Varchar2
23 -- p_char_value2 No Varchar2
24 -- p_date_value1 No Date
25 -- p_date_value2 No Date
26 -- p_excld_flag Yes Varchar2
27 -- p_business_group_id Yes Number Business Group of Record
28 -- p_ecv_attribute_category No Varchar2 Descriptive Flexfield
29 -- p_ecv_attribute1 No Varchar2 Descriptive Flexfield
30 -- p_ecv_attribute2 No Varchar2 Descriptive Flexfield
31 -- p_ecv_attribute3 No Varchar2 Descriptive Flexfield
32 -- p_ecv_attribute4 No Varchar2 Descriptive Flexfield
33 -- p_ecv_attribute5 No Varchar2 Descriptive Flexfield
34 -- p_ecv_attribute6 No Varchar2 Descriptive Flexfield
35 -- p_ecv_attribute7 No Varchar2 Descriptive Flexfield
36 -- p_ecv_attribute8 No Varchar2 Descriptive Flexfield
37 -- p_ecv_attribute9 No Varchar2 Descriptive Flexfield
38 -- p_ecv_attribute10 No Varchar2 Descriptive Flexfield
39 -- p_ecv_attribute11 No Varchar2 Descriptive Flexfield
40 -- p_ecv_attribute12 No Varchar2 Descriptive Flexfield
41 -- p_ecv_attribute13 No Varchar2 Descriptive Flexfield
42 -- p_ecv_attribute14 No Varchar2 Descriptive Flexfield
43 -- p_ecv_attribute15 No Varchar2 Descriptive Flexfield
44 -- p_ecv_attribute16 No Varchar2 Descriptive Flexfield
45 -- p_ecv_attribute17 No Varchar2 Descriptive Flexfield
46 -- p_ecv_attribute18 No Varchar2 Descriptive Flexfield
47 -- p_ecv_attribute19 No Varchar2 Descriptive Flexfield
48 -- p_ecv_attribute20 No Varchar2 Descriptive Flexfield
49 -- p_ecv_attribute21 No Varchar2 Descriptive Flexfield
50 -- p_ecv_attribute22 No Varchar2 Descriptive Flexfield
51 -- p_ecv_attribute23 No Varchar2 Descriptive Flexfield
52 -- p_ecv_attribute24 No Varchar2 Descriptive Flexfield
53 -- p_ecv_attribute25 No Varchar2 Descriptive Flexfield
54 -- p_ecv_attribute26 No Varchar2 Descriptive Flexfield
55 -- p_ecv_attribute27 No Varchar2 Descriptive Flexfield
56 -- p_ecv_attribute28 No Varchar2 Descriptive Flexfield
57 -- p_ecv_attribute29 No Varchar2 Descriptive Flexfield
58 -- p_ecv_attribute30 No Varchar2 Descriptive Flexfield
59 -- p_effective_date Yes date Session Date.
60 --
61 -- Post Success:
62 --
63 -- Out Parameters:
64 -- Name Type Description
65 -- p_eligy_crit_values_id Yes Number PK of record
66 -- p_effective_start_date Yes Date Effective start Date of Record
67 -- p_effective_end_date Yes Date Effective End Date of Record
68 -- p_object_version_number No Number OVN of Record
69 --
70 -- Post Failure:
71 --
72 -- Access Status:
73 -- Public.
74 --
75 -- {End Of Comments}
76 --
77 procedure create_eligy_crit_values
78 (
79 p_validate In Boolean default false
80 ,p_eligy_crit_values_id Out nocopy Number
81 ,p_eligy_prfl_id In Number default NULL
82 ,p_eligy_criteria_id In Number default NULL
83 ,p_effective_start_date Out nocopy Date
84 ,p_effective_end_date Out nocopy Date
85 ,p_ordr_num In Number default NULL
86 ,p_number_value1 In Number default NULL
87 ,p_number_value2 In Number default NULL
88 ,p_char_value1 In Varchar2 default NULL
89 ,p_char_value2 In Varchar2 default NULL
90 ,p_date_value1 In Date default NULL
91 ,p_date_value2 In Date default NULL
92 ,p_excld_flag In Varchar2 default 'N'
93 ,p_business_group_id In Number default NULL
94 ,p_ecv_attribute_category In Varchar2 default NULL
95 ,p_ecv_attribute1 In Varchar2 default NULL
96 ,p_ecv_attribute2 In Varchar2 default NULL
97 ,p_ecv_attribute3 In Varchar2 default NULL
98 ,p_ecv_attribute4 In Varchar2 default NULL
99 ,p_ecv_attribute5 In Varchar2 default NULL
100 ,p_ecv_attribute6 In Varchar2 default NULL
101 ,p_ecv_attribute7 In Varchar2 default NULL
102 ,p_ecv_attribute8 In Varchar2 default NULL
103 ,p_ecv_attribute9 In Varchar2 default NULL
104 ,p_ecv_attribute10 In Varchar2 default NULL
105 ,p_ecv_attribute11 In Varchar2 default NULL
106 ,p_ecv_attribute12 In Varchar2 default NULL
107 ,p_ecv_attribute13 In Varchar2 default NULL
108 ,p_ecv_attribute14 In Varchar2 default NULL
109 ,p_ecv_attribute15 In Varchar2 default NULL
110 ,p_ecv_attribute16 In Varchar2 default NULL
111 ,p_ecv_attribute17 In Varchar2 default NULL
112 ,p_ecv_attribute18 In Varchar2 default NULL
113 ,p_ecv_attribute19 In Varchar2 default NULL
114 ,p_ecv_attribute20 In Varchar2 default NULL
115 ,p_ecv_attribute21 In Varchar2 default NULL
116 ,p_ecv_attribute22 In Varchar2 default NULL
117 ,p_ecv_attribute23 In Varchar2 default NULL
118 ,p_ecv_attribute24 In Varchar2 default NULL
119 ,p_ecv_attribute25 In Varchar2 default NULL
120 ,p_ecv_attribute26 In Varchar2 default NULL
121 ,p_ecv_attribute27 In Varchar2 default NULL
122 ,p_ecv_attribute28 In Varchar2 default NULL
123 ,p_ecv_attribute29 In Varchar2 default NULL
124 ,p_ecv_attribute30 In Varchar2 default NULL
125 ,p_object_version_number Out nocopy Number
126 ,p_effective_date In Date
127 ,p_criteria_score In Number default NULL
128 ,p_criteria_weight In Number default NULL
129 ,p_char_value3 In Varchar2 default NULL
130 ,p_char_value4 In Varchar2 default NULL
131 ,p_number_value3 In Number default NULL
132 ,p_number_value4 In Number default NULL
133 ,p_date_value3 In Date default NULL
134 ,p_date_value4 In Date default NULL
135 );
136 -- ----------------------------------------------------------------------------
137 -- |------------------------< update_eligy_crit_values >------------------------|
138 -- ----------------------------------------------------------------------------
139 -- {Start Of Comments}
140 --
141 -- Description:
142 --
143 -- Prerequisites:
144 --
145 --
146 -- In Parameters:
147 -- Name Reqd Type Description
148 -- p_validate Yes boolean Commit or Rollback.
149 -- p_eligy_crit_values_id yes Number PK of record
150 -- p_eligy_prfl_id Yes Number
151 -- p_eligy_criteria_id Yes Number
152 -- p_ordr_num No Number
153 -- p_number_value1 No Number
154 -- p_number_value2 No Number
155 -- p_char_value1 No Varchar2
156 -- p_char_value2 No Varchar2
157 -- p_date_value1 No Date
158 -- p_date_value2 No Date
159 -- p_excld_flag Yes Varchar2
160 -- p_business_group_id Yes Number Business Group of Record
161 -- p_ecv_attribute_category No Varchar2 Descriptive Flexfield
162 -- p_ecv_attribute1 No Varchar2 Descriptive Flexfield
163 -- p_ecv_attribute2 No Varchar2 Descriptive Flexfield
164 -- p_ecv_attribute3 No Varchar2 Descriptive Flexfield
165 -- p_ecv_attribute4 No Varchar2 Descriptive Flexfield
166 -- p_ecv_attribute5 No Varchar2 Descriptive Flexfield
167 -- p_ecv_attribute6 No Varchar2 Descriptive Flexfield
168 -- p_ecv_attribute7 No Varchar2 Descriptive Flexfield
169 -- p_ecv_attribute8 No Varchar2 Descriptive Flexfield
170 -- p_ecv_attribute9 No Varchar2 Descriptive Flexfield
171 -- p_ecv_attribute10 No Varchar2 Descriptive Flexfield
172 -- p_ecv_attribute11 No Varchar2 Descriptive Flexfield
173 -- p_ecv_attribute12 No Varchar2 Descriptive Flexfield
174 -- p_ecv_attribute13 No Varchar2 Descriptive Flexfield
175 -- p_ecv_attribute14 No Varchar2 Descriptive Flexfield
176 -- p_ecv_attribute15 No Varchar2 Descriptive Flexfield
177 -- p_ecv_attribute16 No Varchar2 Descriptive Flexfield
178 -- p_ecv_attribute17 No Varchar2 Descriptive Flexfield
179 -- p_ecv_attribute18 No Varchar2 Descriptive Flexfield
180 -- p_ecv_attribute19 No Varchar2 Descriptive Flexfield
184 -- p_ecv_attribute23 No Varchar2 Descriptive Flexfield
181 -- p_ecv_attribute20 No Varchar2 Descriptive Flexfield
182 -- p_ecv_attribute21 No Varchar2 Descriptive Flexfield
183 -- p_ecv_attribute22 No Varchar2 Descriptive Flexfield
185 -- p_ecv_attribute24 No Varchar2 Descriptive Flexfield
186 -- p_ecv_attribute25 No Varchar2 Descriptive Flexfield
187 -- p_ecv_attribute26 No Varchar2 Descriptive Flexfield
188 -- p_ecv_attribute27 No Varchar2 Descriptive Flexfield
189 -- p_ecv_attribute28 No Varchar2 Descriptive Flexfield
190 -- p_ecv_attribute29 No Varchar2 Descriptive Flexfield
191 -- p_ecv_attribute30 No Varchar2 Descriptive Flexfield
192 -- p_effective_date Yes date Session Date.
193 -- p_datetrack_mode Yes varchar2 Datetrack mode.
194 --
195 -- Post Success:
196 --
197 -- Name Type Description
198 -- p_effective_start_date Yes date Effective Start Date of Record
199 -- p_effective_end_date Yes date Effective End Date of Record
200 -- p_object_version_number No number OVN of record
201 --
202 -- Post Failure:
203 --
204 -- Access Status:
205 -- Public.
206 --
207 -- {End Of Comments}
208 --
209 procedure update_eligy_crit_values
210 (
211 p_validate In Boolean default false
212 ,p_eligy_crit_values_id In Number
213 ,p_eligy_prfl_id In Number default hr_api.g_number
214 ,p_eligy_criteria_id In Number default hr_api.g_number
215 ,p_effective_start_date Out nocopy Date
216 ,p_effective_end_date Out nocopy Date
217 ,p_ordr_num In Number default hr_api.g_number
218 ,p_number_value1 In Number default hr_api.g_number
219 ,p_number_value2 In Number default hr_api.g_number
220 ,p_char_value1 In Varchar2 default hr_api.g_varchar2
221 ,p_char_value2 In Varchar2 default hr_api.g_varchar2
222 ,p_date_value1 In Date default hr_api.g_date
223 ,p_date_value2 In Date default hr_api.g_date
224 ,p_excld_flag In Varchar2 default hr_api.g_varchar2
225 ,p_business_group_id In Number default hr_api.g_number
226 ,p_ecv_attribute_category In Varchar2 default hr_api.g_varchar2
227 ,p_ecv_attribute1 In Varchar2 default hr_api.g_varchar2
228 ,p_ecv_attribute2 In Varchar2 default hr_api.g_varchar2
229 ,p_ecv_attribute3 In Varchar2 default hr_api.g_varchar2
230 ,p_ecv_attribute4 In Varchar2 default hr_api.g_varchar2
231 ,p_ecv_attribute5 In Varchar2 default hr_api.g_varchar2
232 ,p_ecv_attribute6 In Varchar2 default hr_api.g_varchar2
233 ,p_ecv_attribute7 In Varchar2 default hr_api.g_varchar2
234 ,p_ecv_attribute8 In Varchar2 default hr_api.g_varchar2
235 ,p_ecv_attribute9 In Varchar2 default hr_api.g_varchar2
236 ,p_ecv_attribute10 In Varchar2 default hr_api.g_varchar2
237 ,p_ecv_attribute11 In Varchar2 default hr_api.g_varchar2
238 ,p_ecv_attribute12 In Varchar2 default hr_api.g_varchar2
239 ,p_ecv_attribute13 In Varchar2 default hr_api.g_varchar2
240 ,p_ecv_attribute14 In Varchar2 default hr_api.g_varchar2
241 ,p_ecv_attribute15 In Varchar2 default hr_api.g_varchar2
242 ,p_ecv_attribute16 In Varchar2 default hr_api.g_varchar2
243 ,p_ecv_attribute17 In Varchar2 default hr_api.g_varchar2
244 ,p_ecv_attribute18 In Varchar2 default hr_api.g_varchar2
245 ,p_ecv_attribute19 In Varchar2 default hr_api.g_varchar2
246 ,p_ecv_attribute20 In Varchar2 default hr_api.g_varchar2
247 ,p_ecv_attribute21 In Varchar2 default hr_api.g_varchar2
248 ,p_ecv_attribute22 In Varchar2 default hr_api.g_varchar2
249 ,p_ecv_attribute23 In Varchar2 default hr_api.g_varchar2
250 ,p_ecv_attribute24 In Varchar2 default hr_api.g_varchar2
251 ,p_ecv_attribute25 In Varchar2 default hr_api.g_varchar2
252 ,p_ecv_attribute26 In Varchar2 default hr_api.g_varchar2
253 ,p_ecv_attribute27 In Varchar2 default hr_api.g_varchar2
254 ,p_ecv_attribute28 In Varchar2 default hr_api.g_varchar2
255 ,p_ecv_attribute29 In Varchar2 default hr_api.g_varchar2
256 ,p_ecv_attribute30 In Varchar2 default hr_api.g_varchar2
257 ,p_object_version_number In Out nocopy Number
258 ,p_effective_date In Date
259 ,p_datetrack_mode In varchar2
260 ,p_criteria_score In Number default hr_api.g_number
261 ,p_criteria_weight In Number default hr_api.g_number
262 ,p_char_value3 In Varchar2 default hr_api.g_varchar2
263 ,p_char_value4 In Varchar2 default hr_api.g_varchar2
264 ,p_number_value3 In Number default hr_api.g_number
265 ,p_number_value4 In Number default hr_api.g_number
266 ,p_date_value3 In Date default hr_api.g_date
267 ,p_date_value4 In Date default hr_api.g_date
268 );
269 --
270 -- ----------------------------------------------------------------------------
271 -- |------------------------< delete_eligy_crit_values >------------------------|
272 -- ----------------------------------------------------------------------------
273 -- {Start Of Comments}
274 --
275 -- Description:
276 --
277 -- Prerequisites:
278 --
279 --
280 -- In Parameters:
281 -- Name Reqd Type Description
282 -- p_validate Yes boolean Commit or Rollback.
283 -- p_eligy_crit_values_id Yes number PK of record
284 -- p_effective_date Yes Date Session Date
285 -- p_datetrack_mode Yes Varchar2 Datetrack mode.
286 --
287 -- Post Success:
288 --
289 -- Name Type Description
290 -- p_effective_start_date Yes date Effective Start Date of Record
291 -- p_effective_end_date Yes date Effective End Date of Record
292 -- p_object_version_number No number OVN of record
293 --
294 -- Post Failure:
295 --
296 -- Access Status:
297 -- Public.
298 --
299 -- {End Of Comments}
300 --
301 procedure delete_eligy_crit_values
302 (
303 p_validate In Boolean default false
304 ,p_eligy_crit_values_id In Number
305 ,p_effective_start_date Out nocopy date
306 ,p_effective_end_date Out nocopy date
307 ,p_object_version_number In Out nocopy number
308 ,p_effective_date In Date
309 ,p_datetrack_mode In Varchar2
310 );
311 --
312 -- ----------------------------------------------------------------------------
313 -- |----------------------------------< lck >---------------------------------|
314 -- ----------------------------------------------------------------------------
315 -- {Start Of Comments}
316 --
317 -- Description:
318 --
319 -- Prerequisites:
320 --
321 --
322 -- In Parameters:
323 -- Name Reqd Type Description
324 -- p_eligy_crit_values_id Yes number PK of record
325 -- p_object_version_number Yes number OVN of record
326 -- p_effective_date Yes date Session Date.
327 -- p_datetrack_mode Yes varchar2 Datetrack mode.
328 --
329 -- Post Success:
330 --
331 -- Name Type Description
332 -- p_validation_start_date Yes Derived Effective Start Date.
333 -- p_validation_end_date Yes Derived Effective End Date.
334 --
335 -- Post Failure:
336 --
337 -- Access Status:
338 -- Public.
339 --
340 -- {End Of Comments}
341 --
342 procedure lck
343 (
344 p_eligy_crit_values_id In Number
345 ,p_object_version_number In Number
346 ,p_effective_date In Date
347 ,p_datetrack_mode In Varchar2
351 --
348 ,p_validation_start_date Out nocopy Date
349 ,p_validation_end_date Out nocopy Date
350 );
352 end ben_eligy_crit_values_api;