4 -- ----------------------------------------------------------------------------
1 Package ben_dpnt_elig_crit_val_api AUTHID CURRENT_USER AS
2 /* $Header: beedvapi.pkh 120.2 2010/05/18 07:13:16 sgnanama noship $ */
3 --
5 -- |------------------------< create_dpnt_eligy_crit_val >------------------------|
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_dpnt_cvg_eligy_prfl_id Yes Number
18 -- p_eligy_criteria_dpnt_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_edc_attribute_category No Varchar2 Descriptive Flexfield
29 -- p_edc_attribute1 No Varchar2 Descriptive Flexfield
30 -- p_edc_attribute2 No Varchar2 Descriptive Flexfield
31 -- p_edc_attribute3 No Varchar2 Descriptive Flexfield
32 -- p_edc_attribute4 No Varchar2 Descriptive Flexfield
33 -- p_edc_attribute5 No Varchar2 Descriptive Flexfield
34 -- p_edc_attribute6 No Varchar2 Descriptive Flexfield
35 -- p_edc_attribute7 No Varchar2 Descriptive Flexfield
36 -- p_edc_attribute8 No Varchar2 Descriptive Flexfield
37 -- p_edc_attribute9 No Varchar2 Descriptive Flexfield
38 -- p_edc_attribute10 No Varchar2 Descriptive Flexfield
39 -- p_edc_attribute11 No Varchar2 Descriptive Flexfield
40 -- p_edc_attribute12 No Varchar2 Descriptive Flexfield
41 -- p_edc_attribute13 No Varchar2 Descriptive Flexfield
42 -- p_edc_attribute14 No Varchar2 Descriptive Flexfield
43 -- p_edc_attribute15 No Varchar2 Descriptive Flexfield
44 -- p_edc_attribute16 No Varchar2 Descriptive Flexfield
45 -- p_edc_attribute17 No Varchar2 Descriptive Flexfield
46 -- p_edc_attribute18 No Varchar2 Descriptive Flexfield
47 -- p_edc_attribute19 No Varchar2 Descriptive Flexfield
48 -- p_edc_attribute20 No Varchar2 Descriptive Flexfield
49 -- p_edc_attribute21 No Varchar2 Descriptive Flexfield
50 -- p_edc_attribute22 No Varchar2 Descriptive Flexfield
51 -- p_edc_attribute23 No Varchar2 Descriptive Flexfield
52 -- p_edc_attribute24 No Varchar2 Descriptive Flexfield
53 -- p_edc_attribute25 No Varchar2 Descriptive Flexfield
54 -- p_edc_attribute26 No Varchar2 Descriptive Flexfield
55 -- p_edc_attribute27 No Varchar2 Descriptive Flexfield
56 -- p_edc_attribute28 No Varchar2 Descriptive Flexfield
57 -- p_edc_attribute29 No Varchar2 Descriptive Flexfield
58 -- p_edc_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_dpnt_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_dpnt_eligy_crit_val
78 (
79 p_validate In Boolean default false
80 ,p_dpnt_eligy_crit_values_id Out nocopy Number
81 ,p_dpnt_cvg_eligy_prfl_id In Number default NULL
82 ,p_eligy_criteria_dpnt_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_edc_attribute_category In Varchar2 default NULL
95 ,p_edc_attribute1 In Varchar2 default NULL
96 ,p_edc_attribute2 In Varchar2 default NULL
97 ,p_edc_attribute3 In Varchar2 default NULL
98 ,p_edc_attribute4 In Varchar2 default NULL
102 ,p_edc_attribute8 In Varchar2 default NULL
99 ,p_edc_attribute5 In Varchar2 default NULL
100 ,p_edc_attribute6 In Varchar2 default NULL
101 ,p_edc_attribute7 In Varchar2 default NULL
103 ,p_edc_attribute9 In Varchar2 default NULL
104 ,p_edc_attribute10 In Varchar2 default NULL
105 ,p_edc_attribute11 In Varchar2 default NULL
106 ,p_edc_attribute12 In Varchar2 default NULL
107 ,p_edc_attribute13 In Varchar2 default NULL
108 ,p_edc_attribute14 In Varchar2 default NULL
109 ,p_edc_attribute15 In Varchar2 default NULL
110 ,p_edc_attribute16 In Varchar2 default NULL
111 ,p_edc_attribute17 In Varchar2 default NULL
112 ,p_edc_attribute18 In Varchar2 default NULL
113 ,p_edc_attribute19 In Varchar2 default NULL
114 ,p_edc_attribute20 In Varchar2 default NULL
115 ,p_edc_attribute21 In Varchar2 default NULL
116 ,p_edc_attribute22 In Varchar2 default NULL
117 ,p_edc_attribute23 In Varchar2 default NULL
118 ,p_edc_attribute24 In Varchar2 default NULL
119 ,p_edc_attribute25 In Varchar2 default NULL
120 ,p_edc_attribute26 In Varchar2 default NULL
121 ,p_edc_attribute27 In Varchar2 default NULL
122 ,p_edc_attribute28 In Varchar2 default NULL
123 ,p_edc_attribute29 In Varchar2 default NULL
124 ,p_edc_attribute30 In Varchar2 default NULL
125 ,p_object_version_number Out nocopy Number
126 ,p_effective_date In Date
127 ,p_char_value3 In Varchar2 default NULL
128 ,p_char_value4 In Varchar2 default NULL
129 ,p_number_value3 In Number default NULL
130 ,p_number_value4 In Number default NULL
131 ,p_date_value3 In Date default NULL
132 ,p_date_value4 In Date default NULL
133 );
134 -- ----------------------------------------------------------------------------
135 -- |------------------------< update_dpnt_eligy_crit_val >------------------------|
136 -- ----------------------------------------------------------------------------
137 -- {Start Of Comments}
138 --
139 -- Description:
140 --
141 -- Prerequisites:
142 --
143 --
144 -- In Parameters:
145 -- Name Reqd Type Description
146 -- p_validate Yes boolean Commit or Rollback.
147 -- p_dpnt_eligy_crit_values_id yes Number PK of record
148 -- p_dpnt_cvg_eligy_prfl_id Yes Number
149 -- p_eligy_criteria_dpnt_id Yes Number
150 -- p_ordr_num No Number
151 -- p_number_value1 No Number
152 -- p_number_value2 No Number
153 -- p_char_value1 No Varchar2
154 -- p_char_value2 No Varchar2
155 -- p_date_value1 No Date
156 -- p_date_value2 No Date
157 -- p_excld_flag Yes Varchar2
158 -- p_business_group_id Yes Number Business Group of Record
159 -- p_edc_attribute_category No Varchar2 Descriptive Flexfield
160 -- p_edc_attribute1 No Varchar2 Descriptive Flexfield
161 -- p_edc_attribute2 No Varchar2 Descriptive Flexfield
162 -- p_edc_attribute3 No Varchar2 Descriptive Flexfield
163 -- p_edc_attribute4 No Varchar2 Descriptive Flexfield
164 -- p_edc_attribute5 No Varchar2 Descriptive Flexfield
165 -- p_edc_attribute6 No Varchar2 Descriptive Flexfield
166 -- p_edc_attribute7 No Varchar2 Descriptive Flexfield
167 -- p_edc_attribute8 No Varchar2 Descriptive Flexfield
168 -- p_edc_attribute9 No Varchar2 Descriptive Flexfield
169 -- p_edc_attribute10 No Varchar2 Descriptive Flexfield
170 -- p_edc_attribute11 No Varchar2 Descriptive Flexfield
171 -- p_edc_attribute12 No Varchar2 Descriptive Flexfield
172 -- p_edc_attribute13 No Varchar2 Descriptive Flexfield
173 -- p_edc_attribute14 No Varchar2 Descriptive Flexfield
174 -- p_edc_attribute15 No Varchar2 Descriptive Flexfield
175 -- p_edc_attribute16 No Varchar2 Descriptive Flexfield
176 -- p_edc_attribute17 No Varchar2 Descriptive Flexfield
177 -- p_edc_attribute18 No Varchar2 Descriptive Flexfield
178 -- p_edc_attribute19 No Varchar2 Descriptive Flexfield
179 -- p_edc_attribute20 No Varchar2 Descriptive Flexfield
180 -- p_edc_attribute21 No Varchar2 Descriptive Flexfield
181 -- p_edc_attribute22 No Varchar2 Descriptive Flexfield
182 -- p_edc_attribute23 No Varchar2 Descriptive Flexfield
183 -- p_edc_attribute24 No Varchar2 Descriptive Flexfield
184 -- p_edc_attribute25 No Varchar2 Descriptive Flexfield
185 -- p_edc_attribute26 No Varchar2 Descriptive Flexfield
186 -- p_edc_attribute27 No Varchar2 Descriptive Flexfield
187 -- p_edc_attribute28 No Varchar2 Descriptive Flexfield
188 -- p_edc_attribute29 No Varchar2 Descriptive Flexfield
189 -- p_edc_attribute30 No Varchar2 Descriptive Flexfield
190 -- p_effective_date Yes date Session Date.
191 -- p_datetrack_mode Yes varchar2 Datetrack mode.
192 --
193 -- Post Success:
194 --
195 -- Name Type Description
196 -- p_effective_start_date Yes date Effective Start Date of Record
200 -- Post Failure:
197 -- p_effective_end_date Yes date Effective End Date of Record
198 -- p_object_version_number No number OVN of record
199 --
201 --
202 -- Access Status:
203 -- Public.
204 --
205 -- {End Of Comments}
206 --
207 procedure update_dpnt_eligy_crit_val
208 (
209 p_validate In Boolean default false
210 ,p_dpnt_eligy_crit_values_id In Number
211 ,p_dpnt_cvg_eligy_prfl_id In Number default hr_api.g_number
212 ,p_eligy_criteria_dpnt_id In Number default hr_api.g_number
213 ,p_effective_start_date Out nocopy Date
214 ,p_effective_end_date Out nocopy Date
215 ,p_ordr_num In Number default hr_api.g_number
216 ,p_number_value1 In Number default hr_api.g_number
217 ,p_number_value2 In Number default hr_api.g_number
218 ,p_char_value1 In Varchar2 default hr_api.g_varchar2
219 ,p_char_value2 In Varchar2 default hr_api.g_varchar2
220 ,p_date_value1 In Date default hr_api.g_date
221 ,p_date_value2 In Date default hr_api.g_date
222 ,p_excld_flag In Varchar2 default hr_api.g_varchar2
223 ,p_business_group_id In Number default hr_api.g_number
224 ,p_edc_attribute_category In Varchar2 default hr_api.g_varchar2
225 ,p_edc_attribute1 In Varchar2 default hr_api.g_varchar2
226 ,p_edc_attribute2 In Varchar2 default hr_api.g_varchar2
227 ,p_edc_attribute3 In Varchar2 default hr_api.g_varchar2
228 ,p_edc_attribute4 In Varchar2 default hr_api.g_varchar2
229 ,p_edc_attribute5 In Varchar2 default hr_api.g_varchar2
230 ,p_edc_attribute6 In Varchar2 default hr_api.g_varchar2
231 ,p_edc_attribute7 In Varchar2 default hr_api.g_varchar2
232 ,p_edc_attribute8 In Varchar2 default hr_api.g_varchar2
233 ,p_edc_attribute9 In Varchar2 default hr_api.g_varchar2
234 ,p_edc_attribute10 In Varchar2 default hr_api.g_varchar2
235 ,p_edc_attribute11 In Varchar2 default hr_api.g_varchar2
236 ,p_edc_attribute12 In Varchar2 default hr_api.g_varchar2
237 ,p_edc_attribute13 In Varchar2 default hr_api.g_varchar2
238 ,p_edc_attribute14 In Varchar2 default hr_api.g_varchar2
239 ,p_edc_attribute15 In Varchar2 default hr_api.g_varchar2
240 ,p_edc_attribute16 In Varchar2 default hr_api.g_varchar2
241 ,p_edc_attribute17 In Varchar2 default hr_api.g_varchar2
242 ,p_edc_attribute18 In Varchar2 default hr_api.g_varchar2
243 ,p_edc_attribute19 In Varchar2 default hr_api.g_varchar2
244 ,p_edc_attribute20 In Varchar2 default hr_api.g_varchar2
245 ,p_edc_attribute21 In Varchar2 default hr_api.g_varchar2
246 ,p_edc_attribute22 In Varchar2 default hr_api.g_varchar2
247 ,p_edc_attribute23 In Varchar2 default hr_api.g_varchar2
248 ,p_edc_attribute24 In Varchar2 default hr_api.g_varchar2
249 ,p_edc_attribute25 In Varchar2 default hr_api.g_varchar2
250 ,p_edc_attribute26 In Varchar2 default hr_api.g_varchar2
251 ,p_edc_attribute27 In Varchar2 default hr_api.g_varchar2
252 ,p_edc_attribute28 In Varchar2 default hr_api.g_varchar2
253 ,p_edc_attribute29 In Varchar2 default hr_api.g_varchar2
254 ,p_edc_attribute30 In Varchar2 default hr_api.g_varchar2
255 ,p_object_version_number In Out nocopy Number
256 ,p_effective_date In Date
257 ,p_datetrack_mode In varchar2
258 ,p_char_value3 In Varchar2 default hr_api.g_varchar2
259 ,p_char_value4 In Varchar2 default hr_api.g_varchar2
260 ,p_number_value3 In Number default hr_api.g_number
261 ,p_number_value4 In Number default hr_api.g_number
262 ,p_date_value3 In Date default hr_api.g_date
263 ,p_date_value4 In Date default hr_api.g_date
264 );
265 --
266 -- ----------------------------------------------------------------------------
267 -- |------------------------< delete_dpnt_eligy_crit_val >------------------------|
268 -- ----------------------------------------------------------------------------
269 -- {Start Of Comments}
270 --
271 -- Description:
272 --
273 -- Prerequisites:
274 --
275 --
276 -- In Parameters:
277 -- Name Reqd Type Description
278 -- p_validate Yes boolean Commit or Rollback.
279 -- p_dpnt_eligy_crit_values_id Yes number PK of record
280 -- p_effective_date Yes Date Session Date
281 -- p_datetrack_mode Yes Varchar2 Datetrack mode.
282 --
283 -- Post Success:
284 --
285 -- Name Type Description
286 -- p_effective_start_date Yes date Effective Start Date of Record
287 -- p_effective_end_date Yes date Effective End Date of Record
288 -- p_object_version_number No number OVN of record
289 --
290 -- Post Failure:
291 --
292 -- Access Status:
293 -- Public.
294 --
295 -- {End Of Comments}
296 --
297 procedure delete_dpnt_eligy_crit_val
298 (
299 p_validate In Boolean default false
300 ,p_dpnt_eligy_crit_values_id In Number
301 ,p_effective_start_date Out nocopy date
302 ,p_effective_end_date Out nocopy date
306 );
303 ,p_object_version_number In Out nocopy number
304 ,p_effective_date In Date
305 ,p_datetrack_mode In Varchar2
307 --
308 -- ----------------------------------------------------------------------------
309 -- |----------------------------------< lck >---------------------------------|
310 -- ----------------------------------------------------------------------------
311 -- {Start Of Comments}
312 --
313 -- Description:
314 --
315 -- Prerequisites:
316 --
317 --
318 -- In Parameters:
319 -- Name Reqd Type Description
320 -- p_dpnt_eligy_crit_values_id Yes number PK of record
321 -- p_object_version_number Yes number OVN of record
322 -- p_effective_date Yes date Session Date.
323 -- p_datetrack_mode Yes varchar2 Datetrack mode.
324 --
325 -- Post Success:
326 --
327 -- Name Type Description
328 -- p_validation_start_date Yes Derived Effective Start Date.
329 -- p_validation_end_date Yes Derived Effective End Date.
330 --
331 -- Post Failure:
332 --
333 -- Access Status:
334 -- Public.
335 --
336 -- {End Of Comments}
337 --
338 procedure lck
339 (
340 p_dpnt_eligy_crit_values_id In Number
341 ,p_object_version_number In Number
342 ,p_effective_date In Date
343 ,p_datetrack_mode In Varchar2
344 ,p_validation_start_date Out nocopy Date
345 ,p_validation_end_date Out nocopy Date
346 );
347 --
348 end ben_dpnt_elig_crit_val_api;