[Home] [Help]
PACKAGE BODY: APPS.PAY_RANGE_TABLE_API
Source
1 Package Body pay_range_table_api as
2 /* $Header: pyprfapi.pkb 120.0 2005/05/29 07:48:44 appldev noship $ */
3
4 procedure create_range_table
5 (
6 p_EFFECTIVE_START_DATE in DATE default NULL
7 ,p_EFFECTIVE_END_DATE in DATE default NULL
8 ,p_RANGE_TABLE_NUMBER in NUMBER default NULL
9 ,p_ROW_VALUE_UOM in VARCHAR2 default NULL
10 ,p_PERIOD_FREQUENCY in VARCHAR2 default NULL
11 ,p_EARNINGS_TYPE in VARCHAR2 default NULL
12 ,p_BUSINESS_GROUP_ID in NUMBER default NULL
13 ,p_LEGISLATION_CODE in VARCHAR2 default NULL
14 ,p_ATTRIBUTE_CATEGORY in VARCHAR2 default NULL
15 ,p_ATTRIBUTE1 in VARCHAR2 default NULL
16 ,p_ATTRIBUTE2 in VARCHAR2 default NULL
17 ,p_ATTRIBUTE3 in VARCHAR2 default NULL
18 ,p_ATTRIBUTE4 in VARCHAR2 default NULL
19 ,p_ATTRIBUTE5 in VARCHAR2 default NULL
20 ,p_ATTRIBUTE6 in VARCHAR2 default NULL
21 ,p_ATTRIBUTE7 in VARCHAR2 default NULL
22 ,p_ATTRIBUTE8 in VARCHAR2 default NULL
23 ,p_ATTRIBUTE9 in VARCHAR2 default NULL
24 ,p_ATTRIBUTE10 in VARCHAR2 default NULL
25 ,p_ATTRIBUTE11 in VARCHAR2 default NULL
26 ,p_ATTRIBUTE12 in VARCHAR2 default NULL
27 ,p_ATTRIBUTE13 in VARCHAR2 default NULL
28 ,p_ATTRIBUTE14 in VARCHAR2 default NULL
29 ,p_ATTRIBUTE15 in VARCHAR2 default NULL
30 ,p_ATTRIBUTE16 in VARCHAR2 default NULL
31 ,p_ATTRIBUTE17 in VARCHAR2 default NULL
32 ,p_ATTRIBUTE18 in VARCHAR2 default NULL
33 ,p_ATTRIBUTE19 in VARCHAR2 default NULL
34 ,p_ATTRIBUTE20 in VARCHAR2 default NULL
35 ,p_ATTRIBUTE21 in VARCHAR2 default NULL
36 ,p_ATTRIBUTE22 in VARCHAR2 default NULL
37 ,p_ATTRIBUTE23 in VARCHAR2 default NULL
38 ,p_ATTRIBUTE24 in VARCHAR2 default NULL
39 ,p_ATTRIBUTE25 in VARCHAR2 default NULL
40 ,p_ATTRIBUTE26 in VARCHAR2 default NULL
41 ,p_ATTRIBUTE27 in VARCHAR2 default NULL
42 ,p_ATTRIBUTE28 in VARCHAR2 default NULL
43 ,p_ATTRIBUTE29 in VARCHAR2 default NULL
44 ,p_ATTRIBUTE30 in VARCHAR2 default NULL
45 ,p_RAN_INFORMATION_CATEGORY in VARCHAR2 default NULL
46 ,p_RAN_INFORMATION1 in VARCHAR2 default NULL
47 ,p_RAN_INFORMATION2 in VARCHAR2 default NULL
48 ,p_RAN_INFORMATION3 in VARCHAR2 default NULL
49 ,p_RAN_INFORMATION4 in VARCHAR2 default NULL
50 ,p_RAN_INFORMATION5 in VARCHAR2 default NULL
51 ,p_RAN_INFORMATION6 in VARCHAR2 default NULL
52 ,p_RAN_INFORMATION7 in VARCHAR2 default NULL
53 ,p_RAN_INFORMATION8 in VARCHAR2 default NULL
54 ,p_RAN_INFORMATION9 in VARCHAR2 default NULL
55 ,p_RAN_INFORMATION10 in VARCHAR2 default NULL
56 ,p_RAN_INFORMATION11 in VARCHAR2 default NULL
57 ,p_RAN_INFORMATION12 in VARCHAR2 default NULL
58 ,p_RAN_INFORMATION13 in VARCHAR2 default NULL
59 ,p_RAN_INFORMATION14 in VARCHAR2 default NULL
60 ,p_RAN_INFORMATION15 in VARCHAR2 default NULL
61 ,p_RAN_INFORMATION16 in VARCHAR2 default NULL
62 ,p_RAN_INFORMATION17 in VARCHAR2 default NULL
63 ,p_RAN_INFORMATION18 in VARCHAR2 default NULL
64 ,p_RAN_INFORMATION19 in VARCHAR2 default NULL
65 ,p_RAN_INFORMATION20 in VARCHAR2 default NULL
66 ,p_RAN_INFORMATION21 in VARCHAR2 default NULL
67 ,p_RAN_INFORMATION22 in VARCHAR2 default NULL
68 ,p_RAN_INFORMATION23 in VARCHAR2 default NULL
69 ,p_RAN_INFORMATION24 in VARCHAR2 default NULL
70 ,p_RAN_INFORMATION25 in VARCHAR2 default NULL
71 ,p_RAN_INFORMATION26 in VARCHAR2 default NULL
72 ,p_RAN_INFORMATION27 in VARCHAR2 default NULL
73 ,p_RAN_INFORMATION28 in VARCHAR2 default NULL
74 ,p_RAN_INFORMATION29 in VARCHAR2 default NULL
75 ,p_RAN_INFORMATION30 in VARCHAR2 default NULL
76 ,p_object_version_number OUT nocopy number
77 ,p_range_table_id OUT nocopy number
78 )
79
80 IS
81
82 l_object_version_number number;
83 l_range_table_id number;
84 l_legislation_code varchar2(2);
85
86
87 Cursor Sel_Bus Is
88 select inf.org_information9
89 from hr_organization_information hoi
90 , hr_organization_information inf
91 where hoi.organization_id = p_BUSINESS_GROUP_ID
92 and hoi.org_information_context||'' = 'CLASS'
93 and hoi.org_information1 = 'HR_BG'
94 and hoi.org_information2 = 'Y'
95 and inf.organization_id = hoi.organization_id
96 and inf.org_information_context || '' = 'Business Group Information';
97
98 Cursor Sel_leg is
99 select distinct h.legislation_code
100 from HR_LEGISLATION_INSTALLATIONS h
101 where h.legislation_code = p_legislation_code
102 and h.status = 'I';
103
104
105 BEGIN
106
107 l_object_version_number := 1;
108
109 --
110 --Check for the Effective start date and End Date
111 --
112 IF p_effective_start_date > p_effective_end_date THEN
113 fnd_message.set_name('PAY','PAY_NO_DATE_INVALID');
114 fnd_message.raise_error;
115 END IF;
116
117 /*
118
119 --
120 --Check for the Validity if Legislation Code
121 --
122 if p_legislation_code is NOT NULL then
123 Open Sel_leg;
124 fetch Sel_leg Into l_legislation_code;
125
126 if Sel_leg%notfound then
127 Close Sel_leg;
128 fnd_message.set_name('PAY', 'PAY_NO_API_LEG_CODE_INVALID');
129 fnd_message.raise_error;
130 else
131 Close Sel_leg;
132 end if;
133 end if;
134
135 --
136 --Check for the validity of Business Group ID and Legislation code Match.
137 --
138 if p_BUSINESS_GROUP_ID is NOT NULL then
139
140 Open Sel_Bus;
141 fetch Sel_Bus Into l_legislation_code;
142
143 if Sel_Bus%notfound then
144 Close Sel_Bus;
145 fnd_message.set_name('PAY', 'HR_7208_API_BUS_GRP_INVALID');
146 fnd_message.raise_error;
147 else
148 Close Sel_Bus;
149 end if;
150
151 if l_legislation_code <> p_legislation_code then
152 fnd_message.set_name('PAY', 'PAY_NO_LEG_CODE_BG_MISMATCH');
153 fnd_message.raise_error;
154 end if;
155
156 end if;
157
158 */
159
160 pay_prf_ins.ins
161 (
162 p_EFFECTIVE_START_DATE => p_EFFECTIVE_START_DATE
163 ,p_EFFECTIVE_END_DATE => p_EFFECTIVE_END_DATE
164 ,p_RANGE_TABLE_NUMBER => p_RANGE_TABLE_NUMBER
165 ,p_ROW_VALUE_UOM => p_ROW_VALUE_UOM
166 ,p_PERIOD_FREQUENCY => p_PERIOD_FREQUENCY
167 ,p_EARNINGS_TYPE => p_EARNINGS_TYPE
168 ,p_BUSINESS_GROUP_ID => p_BUSINESS_GROUP_ID
169 ,p_LEGISLATION_CODE => p_LEGISLATION_CODE
170 ,p_ATTRIBUTE_CATEGORY => p_ATTRIBUTE_CATEGORY
171 ,p_ATTRIBUTE1 => p_ATTRIBUTE1
172 ,p_ATTRIBUTE2 => p_ATTRIBUTE2
173 ,p_ATTRIBUTE3 => p_ATTRIBUTE3
174 ,p_ATTRIBUTE4 => p_ATTRIBUTE4
175 ,p_ATTRIBUTE5 => p_ATTRIBUTE5
176 ,p_ATTRIBUTE6 => p_ATTRIBUTE6
177 ,p_ATTRIBUTE7 => p_ATTRIBUTE7
178 ,p_ATTRIBUTE8 => p_ATTRIBUTE8
179 ,p_ATTRIBUTE9 => p_ATTRIBUTE9
180 ,p_ATTRIBUTE10 => p_ATTRIBUTE10
181 ,p_ATTRIBUTE11 => p_ATTRIBUTE11
182 ,p_ATTRIBUTE12 => p_ATTRIBUTE12
183 ,p_ATTRIBUTE13 => p_ATTRIBUTE13
184 ,p_ATTRIBUTE14 => p_ATTRIBUTE14
185 ,p_ATTRIBUTE15 => p_ATTRIBUTE15
186 ,p_ATTRIBUTE16 => p_ATTRIBUTE16
187 ,p_ATTRIBUTE17 => p_ATTRIBUTE17
188 ,p_ATTRIBUTE18 => p_ATTRIBUTE18
189 ,p_ATTRIBUTE19 => p_ATTRIBUTE19
190 ,p_ATTRIBUTE20 => p_ATTRIBUTE20
191 ,p_ATTRIBUTE21 => p_ATTRIBUTE21
192 ,p_ATTRIBUTE22 => p_ATTRIBUTE22
193 ,p_ATTRIBUTE23 => p_ATTRIBUTE23
194 ,p_ATTRIBUTE24 => p_ATTRIBUTE24
195 ,p_ATTRIBUTE25 => p_ATTRIBUTE25
196 ,p_ATTRIBUTE26 => p_ATTRIBUTE26
197 ,p_ATTRIBUTE27 => p_ATTRIBUTE27
198 ,p_ATTRIBUTE28 => p_ATTRIBUTE28
199 ,p_ATTRIBUTE29 => p_ATTRIBUTE29
200 ,p_ATTRIBUTE30 => p_ATTRIBUTE30
201 ,p_RAN_INFORMATION_CATEGORY => p_RAN_INFORMATION_CATEGORY
202 ,p_RAN_INFORMATION1 => p_RAN_INFORMATION1
203 ,p_RAN_INFORMATION2 => p_RAN_INFORMATION2
204 ,p_RAN_INFORMATION3 => p_RAN_INFORMATION3
205 ,p_RAN_INFORMATION4 => p_RAN_INFORMATION4
206 ,p_RAN_INFORMATION5 => p_RAN_INFORMATION5
207 ,p_RAN_INFORMATION6 => p_RAN_INFORMATION6
208 ,p_RAN_INFORMATION7 => p_RAN_INFORMATION7
209 ,p_RAN_INFORMATION8 => p_RAN_INFORMATION8
210 ,p_RAN_INFORMATION9 => p_RAN_INFORMATION9
211 ,p_RAN_INFORMATION10 => p_RAN_INFORMATION10
212 ,p_RAN_INFORMATION11 => p_RAN_INFORMATION11
213 ,p_RAN_INFORMATION12 => p_RAN_INFORMATION12
214 ,p_RAN_INFORMATION13 => p_RAN_INFORMATION13
215 ,p_RAN_INFORMATION14 => p_RAN_INFORMATION14
216 ,p_RAN_INFORMATION15 => p_RAN_INFORMATION15
217 ,p_RAN_INFORMATION16 => p_RAN_INFORMATION16
218 ,p_RAN_INFORMATION17 => p_RAN_INFORMATION17
219 ,p_RAN_INFORMATION18 => p_RAN_INFORMATION18
220 ,p_RAN_INFORMATION19 => p_RAN_INFORMATION19
221 ,p_RAN_INFORMATION20 => p_RAN_INFORMATION20
222 ,p_RAN_INFORMATION21 => p_RAN_INFORMATION21
223 ,p_RAN_INFORMATION22 => p_RAN_INFORMATION22
224 ,p_RAN_INFORMATION23 => p_RAN_INFORMATION23
225 ,p_RAN_INFORMATION24 => p_RAN_INFORMATION24
226 ,p_RAN_INFORMATION25 => p_RAN_INFORMATION25
227 ,p_RAN_INFORMATION26 => p_RAN_INFORMATION26
228 ,p_RAN_INFORMATION27 => p_RAN_INFORMATION27
229 ,p_RAN_INFORMATION28 => p_RAN_INFORMATION28
230 ,p_RAN_INFORMATION29 => p_RAN_INFORMATION29
231 ,p_RAN_INFORMATION30 => p_RAN_INFORMATION30
232 ,p_RANGE_TABLE_ID => l_range_table_id
233 ,p_object_version_number => l_object_version_number
234 );
235
236
237 p_object_version_number := l_object_version_number;
238 p_RANGE_TABLE_ID := l_range_table_id;
239
240
241 end create_range_table;
242
243
244 procedure update_range_table
245 ( p_range_table_id in number
246 ,p_object_version_number in out nocopy number
247 ,p_range_table_number in number default hr_api.g_number
248 ,p_period_frequency in varchar2 default hr_api.g_varchar2
249 ,p_effective_start_date in date default hr_api.g_date
250 ,p_effective_end_date in date default hr_api.g_date
251 ,p_row_value_uom in varchar2 default hr_api.g_varchar2
252 ,p_earnings_type in varchar2 default hr_api.g_varchar2
253 ,p_business_group_id in number default hr_api.g_number
254 ,p_legislation_code in varchar2 default hr_api.g_varchar2
255 ,p_last_updated_login in number default hr_api.g_number
256 ,p_created_date in date default hr_api.g_date
257 ,p_attribute_category in varchar2 default hr_api.g_varchar2
258 ,p_attribute1 in varchar2 default hr_api.g_varchar2
259 ,p_attribute2 in varchar2 default hr_api.g_varchar2
260 ,p_attribute3 in varchar2 default hr_api.g_varchar2
261 ,p_attribute4 in varchar2 default hr_api.g_varchar2
262 ,p_attribute5 in varchar2 default hr_api.g_varchar2
263 ,p_attribute6 in varchar2 default hr_api.g_varchar2
264 ,p_attribute7 in varchar2 default hr_api.g_varchar2
265 ,p_attribute8 in varchar2 default hr_api.g_varchar2
266 ,p_attribute9 in varchar2 default hr_api.g_varchar2
267 ,p_attribute10 in varchar2 default hr_api.g_varchar2
268 ,p_attribute11 in varchar2 default hr_api.g_varchar2
269 ,p_attribute12 in varchar2 default hr_api.g_varchar2
270 ,p_attribute13 in varchar2 default hr_api.g_varchar2
271 ,p_attribute14 in varchar2 default hr_api.g_varchar2
272 ,p_attribute15 in varchar2 default hr_api.g_varchar2
273 ,p_attribute16 in varchar2 default hr_api.g_varchar2
274 ,p_attribute17 in varchar2 default hr_api.g_varchar2
275 ,p_attribute18 in varchar2 default hr_api.g_varchar2
276 ,p_attribute19 in varchar2 default hr_api.g_varchar2
277 ,p_attribute20 in varchar2 default hr_api.g_varchar2
278 ,p_attribute21 in varchar2 default hr_api.g_varchar2
279 ,p_attribute22 in varchar2 default hr_api.g_varchar2
280 ,p_attribute23 in varchar2 default hr_api.g_varchar2
281 ,p_attribute24 in varchar2 default hr_api.g_varchar2
282 ,p_attribute25 in varchar2 default hr_api.g_varchar2
283 ,p_attribute26 in varchar2 default hr_api.g_varchar2
284 ,p_attribute27 in varchar2 default hr_api.g_varchar2
285 ,p_attribute28 in varchar2 default hr_api.g_varchar2
286 ,p_attribute29 in varchar2 default hr_api.g_varchar2
287 ,p_attribute30 in varchar2 default hr_api.g_varchar2
288 ,p_ran_information_category in varchar2 default hr_api.g_varchar2
289 ,p_ran_information1 in varchar2 default hr_api.g_varchar2
290 ,p_ran_information2 in varchar2 default hr_api.g_varchar2
291 ,p_ran_information3 in varchar2 default hr_api.g_varchar2
292 ,p_ran_information4 in varchar2 default hr_api.g_varchar2
293 ,p_ran_information5 in varchar2 default hr_api.g_varchar2
294 ,p_ran_information6 in varchar2 default hr_api.g_varchar2
295 ,p_ran_information7 in varchar2 default hr_api.g_varchar2
296 ,p_ran_information8 in varchar2 default hr_api.g_varchar2
297 ,p_ran_information9 in varchar2 default hr_api.g_varchar2
298 ,p_ran_information10 in varchar2 default hr_api.g_varchar2
299 ,p_ran_information11 in varchar2 default hr_api.g_varchar2
300 ,p_ran_information12 in varchar2 default hr_api.g_varchar2
301 ,p_ran_information13 in varchar2 default hr_api.g_varchar2
302 ,p_ran_information14 in varchar2 default hr_api.g_varchar2
303 ,p_ran_information15 in varchar2 default hr_api.g_varchar2
304 ,p_ran_information16 in varchar2 default hr_api.g_varchar2
305 ,p_ran_information17 in varchar2 default hr_api.g_varchar2
306 ,p_ran_information18 in varchar2 default hr_api.g_varchar2
307 ,p_ran_information19 in varchar2 default hr_api.g_varchar2
308 ,p_ran_information20 in varchar2 default hr_api.g_varchar2
309 ,p_ran_information21 in varchar2 default hr_api.g_varchar2
310 ,p_ran_information22 in varchar2 default hr_api.g_varchar2
311 ,p_ran_information23 in varchar2 default hr_api.g_varchar2
312 ,p_ran_information24 in varchar2 default hr_api.g_varchar2
313 ,p_ran_information25 in varchar2 default hr_api.g_varchar2
314 ,p_ran_information26 in varchar2 default hr_api.g_varchar2
315 ,p_ran_information27 in varchar2 default hr_api.g_varchar2
316 ,p_ran_information28 in varchar2 default hr_api.g_varchar2
317 ,p_ran_information29 in varchar2 default hr_api.g_varchar2
318 ,p_ran_information30 in varchar2 default hr_api.g_varchar2
319 )
320
321 IS
322
323 l_object_version_number number;
324 l_legislation_code varchar2(2);
325
326
327 Cursor Sel_Bus Is
328 select inf.org_information9
329 from hr_organization_information hoi
330 , hr_organization_information inf
331 where hoi.organization_id = p_BUSINESS_GROUP_ID
332 and hoi.org_information_context||'' = 'CLASS'
333 and hoi.org_information1 = 'HR_BG'
334 and hoi.org_information2 = 'Y'
335 and inf.organization_id = hoi.organization_id
336 and inf.org_information_context || '' = 'Business Group Information';
337
338 Cursor Sel_leg is
339 select distinct h.legislation_code
340 from HR_LEGISLATION_INSTALLATIONS h
341 where h.legislation_code = p_legislation_code
342 and h.status = 'I';
343
344 BEGIN
345
346 l_object_version_number := p_object_version_number;
347
348 --
349 --Check for the Effective start date and End Date
350 --
351 IF p_effective_start_date > p_effective_end_date THEN
352 fnd_message.set_name('PAY','PAY_NO_DATE_INVALID');
353 fnd_message.raise_error;
354 END IF;
355
356 /*
357 --
358 --Check for the Validity if Legislation Code
359 --
360 if p_legislation_code is NOT NULL or p_legislation_code <>hr_api.g_varchar2 then
361 Open Sel_leg;
362 fetch Sel_leg Into l_legislation_code;
363
364 if Sel_leg%notfound then
365 Close Sel_leg;
366 fnd_message.set_name('PAY', 'PAY_NO_API_LEG_CODE_INVALID');
367 fnd_message.raise_error;
368 else
369 Close Sel_leg;
370 end if;
371 end if;
372
373 --
374 --Check for the validity of Business Group ID and Legislation code Match.
375 --
376 if p_BUSINESS_GROUP_ID is NOT NULL or p_BUSINESS_GROUP_ID <>hr_api.g_number then
377
378 Open Sel_Bus;
379 fetch Sel_Bus Into l_legislation_code;
380
381 if Sel_Bus%notfound then
382 Close Sel_Bus;
383 fnd_message.set_name('PAY', 'API_BUS_GRP_INVALID');
384 fnd_message.raise_error;
385 else
386 Close Sel_Bus;
387 end if;
388
389 if l_legislation_code <> p_legislation_code then
390 fnd_message.set_name('PAY', 'PAY_NO_LEG_CODE_BG_MISMATCH');
391 fnd_message.raise_error;
392 end if;
393
394 end if;
395
396 */
397
398 pay_prf_upd.upd
399 (p_RANGE_TABLE_ID => p_range_table_id
400 ,p_EFFECTIVE_START_DATE => p_EFFECTIVE_START_DATE
401 ,p_EFFECTIVE_END_DATE => p_EFFECTIVE_END_DATE
402 ,p_RANGE_TABLE_NUMBER => p_RANGE_TABLE_NUMBER
403 ,p_ROW_VALUE_UOM => p_ROW_VALUE_UOM
404 ,p_PERIOD_FREQUENCY => p_PERIOD_FREQUENCY
405 ,p_EARNINGS_TYPE => p_EARNINGS_TYPE
406 ,p_BUSINESS_GROUP_ID => p_BUSINESS_GROUP_ID
407 ,p_LEGISLATION_CODE => p_LEGISLATION_CODE
408 ,p_ATTRIBUTE_CATEGORY => p_ATTRIBUTE_CATEGORY
409 ,p_ATTRIBUTE1 => p_ATTRIBUTE1
410 ,p_ATTRIBUTE2 => p_ATTRIBUTE2
411 ,p_ATTRIBUTE3 => p_ATTRIBUTE3
412 ,p_ATTRIBUTE4 => p_ATTRIBUTE4
413 ,p_ATTRIBUTE5 => p_ATTRIBUTE5
414 ,p_ATTRIBUTE6 => p_ATTRIBUTE6
415 ,p_ATTRIBUTE7 => p_ATTRIBUTE7
416 ,p_ATTRIBUTE8 => p_ATTRIBUTE8
417 ,p_ATTRIBUTE9 => p_ATTRIBUTE9
418 ,p_ATTRIBUTE10 => p_ATTRIBUTE10
419 ,p_ATTRIBUTE11 => p_ATTRIBUTE11
420 ,p_ATTRIBUTE12 => p_ATTRIBUTE12
421 ,p_ATTRIBUTE13 => p_ATTRIBUTE13
422 ,p_ATTRIBUTE14 => p_ATTRIBUTE14
423 ,p_ATTRIBUTE15 => p_ATTRIBUTE15
424 ,p_ATTRIBUTE16 => p_ATTRIBUTE16
425 ,p_ATTRIBUTE17 => p_ATTRIBUTE17
426 ,p_ATTRIBUTE18 => p_ATTRIBUTE18
427 ,p_ATTRIBUTE19 => p_ATTRIBUTE19
428 ,p_ATTRIBUTE20 => p_ATTRIBUTE20
429 ,p_ATTRIBUTE21 => p_ATTRIBUTE21
430 ,p_ATTRIBUTE22 => p_ATTRIBUTE22
431 ,p_ATTRIBUTE23 => p_ATTRIBUTE23
432 ,p_ATTRIBUTE24 => p_ATTRIBUTE24
433 ,p_ATTRIBUTE25 => p_ATTRIBUTE25
434 ,p_ATTRIBUTE26 => p_ATTRIBUTE26
435 ,p_ATTRIBUTE27 => p_ATTRIBUTE27
436 ,p_ATTRIBUTE28 => p_ATTRIBUTE28
437 ,p_ATTRIBUTE29 => p_ATTRIBUTE29
438 ,p_ATTRIBUTE30 => p_ATTRIBUTE30
439 ,p_RAN_INFORMATION_CATEGORY => p_RAN_INFORMATION_CATEGORY
440 ,p_RAN_INFORMATION1 => p_RAN_INFORMATION1
441 ,p_RAN_INFORMATION2 => p_RAN_INFORMATION2
442 ,p_RAN_INFORMATION3 => p_RAN_INFORMATION3
443 ,p_RAN_INFORMATION4 => p_RAN_INFORMATION4
444 ,p_RAN_INFORMATION5 => p_RAN_INFORMATION5
445 ,p_RAN_INFORMATION6 => p_RAN_INFORMATION6
446 ,p_RAN_INFORMATION7 => p_RAN_INFORMATION7
447 ,p_RAN_INFORMATION8 => p_RAN_INFORMATION8
448 ,p_RAN_INFORMATION9 => p_RAN_INFORMATION9
449 ,p_RAN_INFORMATION10 => p_RAN_INFORMATION10
450 ,p_RAN_INFORMATION11 => p_RAN_INFORMATION11
451 ,p_RAN_INFORMATION12 => p_RAN_INFORMATION12
452 ,p_RAN_INFORMATION13 => p_RAN_INFORMATION13
453 ,p_RAN_INFORMATION14 => p_RAN_INFORMATION14
454 ,p_RAN_INFORMATION15 => p_RAN_INFORMATION15
455 ,p_RAN_INFORMATION16 => p_RAN_INFORMATION16
456 ,p_RAN_INFORMATION17 => p_RAN_INFORMATION17
457 ,p_RAN_INFORMATION18 => p_RAN_INFORMATION18
458 ,p_RAN_INFORMATION19 => p_RAN_INFORMATION19
459 ,p_RAN_INFORMATION20 => p_RAN_INFORMATION20
460 ,p_RAN_INFORMATION21 => p_RAN_INFORMATION21
461 ,p_RAN_INFORMATION22 => p_RAN_INFORMATION22
462 ,p_RAN_INFORMATION23 => p_RAN_INFORMATION23
463 ,p_RAN_INFORMATION24 => p_RAN_INFORMATION24
464 ,p_RAN_INFORMATION25 => p_RAN_INFORMATION25
465 ,p_RAN_INFORMATION26 => p_RAN_INFORMATION26
466 ,p_RAN_INFORMATION27 => p_RAN_INFORMATION27
467 ,p_RAN_INFORMATION28 => p_RAN_INFORMATION28
468 ,p_RAN_INFORMATION29 => p_RAN_INFORMATION29
469 ,p_RAN_INFORMATION30 => p_RAN_INFORMATION30
470 ,p_object_version_number => l_object_version_number
471 );
472
473
474
475 p_object_version_number := l_object_version_number;
476
477 end update_range_table;
478
479
480
481 procedure delete_range_table
482 ( p_range_table_id in number
483 ,p_object_version_number in number
484 )
485
486 IS
487
488
489 BEGIN
490
491
492 pay_prf_del.del
493 (
494 p_range_table_id => p_range_table_id
495 ,p_OBJECT_VERSION_NUMBER => p_object_version_number
496 );
497
498
499 end delete_range_table;
500
501 END pay_range_table_api;