[Home] [Help]
PACKAGE BODY: APPS.BEN_ICD_PKG
Source
1 PACKAGE BODY BEN_ICD_PKG AS
2 /* $Header: beicd.pkb 120.0 2007/03/26 13:02:49 sparimi noship $ */
3 g_package varchar2(30) :='BEN_PDW_COPY_BEN_TO_STG';
4
5 procedure CREATE_TRANSACTION
6 (
7 P_ICD_TRANSACTION_ID IN NUMBER
8 ,P_ICD_CHC_RATE_ID IN NUMBER
9 ,P_BUSINESS_GROUP_ID IN NUMBER
10 ,P_PERSON_ID IN NUMBER
11 ,P_ASSIGNMENT_ID IN NUMBER
12 ,P_TRANSACTION_ID IN NUMBER
13 ,P_TRANSACTION_STEP_ID IN NUMBER
14 ,P_EFFECTIVE_START_DATE IN DATE
15 ,P_EFFECTIVE_END_DATE IN DATE
16 ,P_DML_OPERATION IN VARCHAR
17 ,P_DATETRACK_MODE IN VARCHAR
18 ,P_EFFECTIVE_DATE IN DATE
19 ,P_PL_TYP_ID IN NUMBER
20 ,P_PL_ID IN NUMBER
21 ,P_OPT_ID IN NUMBER
22 ,P_OIPL_ID IN NUMBER
23 ,P_ACTY_BASE_RT_ID IN NUMBER
24 ,P_RT_STRT_DT_CD IN VARCHAR
25 ,P_RT_STRT_DT IN DATE
26 ,P_RT_STRT_DT_RL IN NUMBER
27 ,P_RT_END_DT_CD IN VARCHAR
28 ,P_RT_END_DT IN DATE
29 ,P_RT_END_DT_RL IN NUMBER
30 ,P_NNMNTRY_UOM IN VARCHAR
31 ,P_BNF_RQD_FLAG IN VARCHAR
32 ,P_ELEMENT_TYPE_ID IN NUMBER
33 ,P_ELEMENT_LINK_ID IN NUMBER
34 ,P_ELEMENT_ENTRY_ID IN NUMBER
35 ,P_ELEMENT_TYPE_CONTEXT IN VARCHAR
36 ,P_INPUT_VALUE_ID1 IN NUMBER
37 ,P_INPUT_VALUE1 IN VARCHAR
38 ,P_INPUT_VALUE_ID2 IN NUMBER
39 ,P_INPUT_VALUE2 IN VARCHAR
40 ,P_INPUT_VALUE_ID3 IN NUMBER
41 ,P_INPUT_VALUE3 IN VARCHAR
42 ,P_INPUT_VALUE_ID4 IN NUMBER
43 ,P_INPUT_VALUE4 IN VARCHAR
44 ,P_INPUT_VALUE_ID5 IN NUMBER
45 ,P_INPUT_VALUE5 IN VARCHAR
46 ,P_INPUT_VALUE_ID6 IN NUMBER
47 ,P_INPUT_VALUE6 IN VARCHAR
48 ,P_INPUT_VALUE_ID7 IN NUMBER
49 ,P_INPUT_VALUE7 IN VARCHAR
50 ,P_INPUT_VALUE_ID8 IN NUMBER
51 ,P_INPUT_VALUE8 IN VARCHAR
52 ,P_INPUT_VALUE_ID9 IN NUMBER
53 ,P_INPUT_VALUE9 IN VARCHAR
54 ,P_INPUT_VALUE_ID10 IN NUMBER
55 ,P_INPUT_VALUE10 IN VARCHAR
56 ,P_INPUT_VALUE_ID11 IN NUMBER
57 ,P_INPUT_VALUE11 IN VARCHAR
58 ,P_INPUT_VALUE_ID12 IN NUMBER
59 ,P_INPUT_VALUE12 IN VARCHAR
60 ,P_INPUT_VALUE_ID13 IN NUMBER
61 ,P_INPUT_VALUE13 IN VARCHAR
62 ,P_INPUT_VALUE_ID14 IN NUMBER
63 ,P_INPUT_VALUE14 IN VARCHAR
64 ,P_INPUT_VALUE_ID15 IN NUMBER
65 ,P_INPUT_VALUE15 IN VARCHAR
66 ,P_ITEM_TYPE IN VARCHAR
67 ,P_ITEM_KEY IN VARCHAR
68 ,P_STATUS IN VARCHAR
69 ,P_PL_ORDR_NUM IN NUMBER
70 ,P_OIPL_ORDR_NUM IN NUMBER
71 ,P_REASON IN VARCHAR
72 ,P_FUTURE_DATA_EXISTS IN VARCHAR
73 ,P_OBJECT_VERSION_NUMBER IN NUMBER
74 ,P_E_OBJECT_VERSION_NUMBER IN NUMBER
75 ,P_COST_ALLOCATION_KEYFLEX_ID IN NUMBER
76 ,P_ATTRIBUTE_CATEGORY IN VARCHAR
77 ,P_ATTRIBUTE1 IN VARCHAR
78 ,P_ATTRIBUTE2 IN VARCHAR
79 ,P_ATTRIBUTE3 IN VARCHAR
80 ,P_ATTRIBUTE4 IN VARCHAR
81 ,P_ATTRIBUTE5 IN VARCHAR
82 ,P_ATTRIBUTE6 IN VARCHAR
83 ,P_ATTRIBUTE7 IN VARCHAR
84 ,P_ATTRIBUTE8 IN VARCHAR
85 ,P_ATTRIBUTE9 IN VARCHAR
86 ,P_ATTRIBUTE10 IN VARCHAR
87 ,P_ATTRIBUTE11 IN VARCHAR
88 ,P_ATTRIBUTE12 IN VARCHAR
89 ,P_ATTRIBUTE13 IN VARCHAR
90 ,P_ATTRIBUTE14 IN VARCHAR
91 ,P_ATTRIBUTE15 IN VARCHAR
92 ,P_ATTRIBUTE16 IN VARCHAR
93 ,P_ATTRIBUTE17 IN VARCHAR
94 ,P_ATTRIBUTE18 IN VARCHAR
95 ,P_ATTRIBUTE19 IN VARCHAR
96 ,P_ATTRIBUTE20 IN VARCHAR
97 ,P_ENTRY_INFORMATION_CATEGORY IN VARCHAR
98 ,P_ENTRY_INFORMATION1 IN VARCHAR
99 ,P_ENTRY_INFORMATION2 IN VARCHAR
100 ,P_ENTRY_INFORMATION3 IN VARCHAR
101 ,P_ENTRY_INFORMATION4 IN VARCHAR
102 ,P_ENTRY_INFORMATION5 IN VARCHAR
103 ,P_ENTRY_INFORMATION6 IN VARCHAR
104 ,P_ENTRY_INFORMATION7 IN VARCHAR
105 ,P_ENTRY_INFORMATION8 IN VARCHAR
106 ,P_ENTRY_INFORMATION9 IN VARCHAR
107 ,P_ENTRY_INFORMATION10 IN VARCHAR
108 ,P_ENTRY_INFORMATION11 IN VARCHAR
109 ,P_ENTRY_INFORMATION12 IN VARCHAR
110 ,P_ENTRY_INFORMATION13 IN VARCHAR
111 ,P_ENTRY_INFORMATION14 IN VARCHAR
112 ,P_ENTRY_INFORMATION15 IN VARCHAR
113 ,P_ENTRY_INFORMATION16 IN VARCHAR
114 ,P_ENTRY_INFORMATION17 IN VARCHAR
115 ,P_ENTRY_INFORMATION18 IN VARCHAR
116 ,P_ENTRY_INFORMATION19 IN VARCHAR
117 ,P_ENTRY_INFORMATION20 IN VARCHAR
118 ,P_ENTRY_INFORMATION21 IN VARCHAR
119 ,P_ENTRY_INFORMATION22 IN VARCHAR
120 ,P_ENTRY_INFORMATION23 IN VARCHAR
121 ,P_ENTRY_INFORMATION24 IN VARCHAR
122 ,P_ENTRY_INFORMATION25 IN VARCHAR
123 ,P_ENTRY_INFORMATION26 IN VARCHAR
124 ,P_ENTRY_INFORMATION27 IN VARCHAR
125 ,P_ENTRY_INFORMATION28 IN VARCHAR
126 ,P_ENTRY_INFORMATION29 IN VARCHAR
127 ,P_ENTRY_INFORMATION30 IN VARCHAR
128 ) is
129 begin
130
131 INSERT INTO BEN_ICD_TRANSACTION
132 (
133 ICD_TRANSACTION_ID
134 ,ICD_CHC_RATE_ID
135 ,BUSINESS_GROUP_ID
136 ,PERSON_ID
137 ,ASSIGNMENT_ID
138 ,TRANSACTION_ID
139 ,TRANSACTION_STEP_ID
140 ,EFFECTIVE_START_DATE
141 ,EFFECTIVE_END_DATE
142 ,DML_OPERATION
143 ,DATETRACK_MODE
144 ,EFFECTIVE_DATE
145 ,PL_TYP_ID
146 ,PL_ID
147 ,OPT_ID
148 ,OIPL_ID
149 ,ACTY_BASE_RT_ID
150 ,RT_STRT_DT_CD
151 ,RT_STRT_DT
152 ,RT_STRT_DT_RL
153 ,RT_END_DT_CD
154 ,RT_END_DT
155 ,RT_END_DT_RL
156 ,NNMNTRY_UOM
157 ,BNF_RQD_FLAG
158 ,ELEMENT_TYPE_ID
159 ,ELEMENT_LINK_ID
160 ,ELEMENT_ENTRY_ID
161 ,ELEMENT_TYPE_CONTEXT
162 ,INPUT_VALUE_ID1
163 ,INPUT_VALUE1
164 ,INPUT_VALUE_ID2
165 ,INPUT_VALUE2
166 ,INPUT_VALUE_ID3
167 ,INPUT_VALUE3
168 ,INPUT_VALUE_ID4
169 ,INPUT_VALUE4
170 ,INPUT_VALUE_ID5
171 ,INPUT_VALUE5
172 ,INPUT_VALUE_ID6
173 ,INPUT_VALUE6
174 ,INPUT_VALUE_ID7
175 ,INPUT_VALUE7
176 ,INPUT_VALUE_ID8
177 ,INPUT_VALUE8
178 ,INPUT_VALUE_ID9
179 ,INPUT_VALUE9
180 ,INPUT_VALUE_ID10
181 ,INPUT_VALUE10
182 ,INPUT_VALUE_ID11
183 ,INPUT_VALUE11
184 ,INPUT_VALUE_ID12
185 ,INPUT_VALUE12
186 ,INPUT_VALUE_ID13
187 ,INPUT_VALUE13
188 ,INPUT_VALUE_ID14
189 ,INPUT_VALUE14
190 ,INPUT_VALUE_ID15
191 ,INPUT_VALUE15
192 ,ITEM_TYPE
193 ,ITEM_KEY
194 ,STATUS
195 ,PL_ORDR_NUM
196 ,OIPL_ORDR_NUM
197 ,REASON
198 ,FUTURE_DATA_EXISTS
199 ,OBJECT_VERSION_NUMBER
200 ,E_OBJECT_VERSION_NUMBER
201 ,COST_ALLOCATION_KEYFLEX_ID
202 ,ATTRIBUTE_CATEGORY
203 ,ATTRIBUTE1
204 ,ATTRIBUTE2
205 ,ATTRIBUTE3
206 ,ATTRIBUTE4
207 ,ATTRIBUTE5
208 ,ATTRIBUTE6
209 ,ATTRIBUTE7
210 ,ATTRIBUTE8
211 ,ATTRIBUTE9
212 ,ATTRIBUTE10
213 ,ATTRIBUTE11
214 ,ATTRIBUTE12
215 ,ATTRIBUTE13
216 ,ATTRIBUTE14
217 ,ATTRIBUTE15
218 ,ATTRIBUTE16
219 ,ATTRIBUTE17
220 ,ATTRIBUTE18
221 ,ATTRIBUTE19
222 ,ATTRIBUTE20
223 ,ENTRY_INFORMATION_CATEGORY
224 ,ENTRY_INFORMATION1
225 ,ENTRY_INFORMATION2
226 ,ENTRY_INFORMATION3
227 ,ENTRY_INFORMATION4
228 ,ENTRY_INFORMATION5
229 ,ENTRY_INFORMATION6
230 ,ENTRY_INFORMATION7
231 ,ENTRY_INFORMATION8
232 ,ENTRY_INFORMATION9
233 ,ENTRY_INFORMATION10
234 ,ENTRY_INFORMATION11
235 ,ENTRY_INFORMATION12
236 ,ENTRY_INFORMATION13
237 ,ENTRY_INFORMATION14
238 ,ENTRY_INFORMATION15
239 ,ENTRY_INFORMATION16
240 ,ENTRY_INFORMATION17
241 ,ENTRY_INFORMATION18
242 ,ENTRY_INFORMATION19
243 ,ENTRY_INFORMATION20
244 ,ENTRY_INFORMATION21
245 ,ENTRY_INFORMATION22
246 ,ENTRY_INFORMATION23
247 ,ENTRY_INFORMATION24
248 ,ENTRY_INFORMATION25
249 ,ENTRY_INFORMATION26
250 ,ENTRY_INFORMATION27
251 ,ENTRY_INFORMATION28
252 ,ENTRY_INFORMATION29
253 ,ENTRY_INFORMATION30
254 )
255
256 VALUES
257 (
258 P_ICD_TRANSACTION_ID
259 ,P_ICD_CHC_RATE_ID
260 ,P_BUSINESS_GROUP_ID
261 ,P_PERSON_ID
262 ,P_ASSIGNMENT_ID
263 ,P_TRANSACTION_ID
264 ,P_TRANSACTION_STEP_ID
265 ,P_EFFECTIVE_START_DATE
266 ,P_EFFECTIVE_END_DATE
267 ,P_DML_OPERATION
268 ,P_DATETRACK_MODE
269 ,P_EFFECTIVE_DATE
270 ,P_PL_TYP_ID
271 ,P_PL_ID
272 ,P_OPT_ID
273 ,P_OIPL_ID
274 ,P_ACTY_BASE_RT_ID
275 ,P_RT_STRT_DT_CD
276 ,P_RT_STRT_DT
277 ,P_RT_STRT_DT_RL
278 ,P_RT_END_DT_CD
279 ,P_RT_END_DT
280 ,P_RT_END_DT_RL
281 ,P_NNMNTRY_UOM
282 ,P_BNF_RQD_FLAG
283 ,P_ELEMENT_TYPE_ID
284 ,P_ELEMENT_LINK_ID
285 ,P_ELEMENT_ENTRY_ID
286 ,P_ELEMENT_TYPE_CONTEXT
287 ,P_INPUT_VALUE_ID1
288 ,P_INPUT_VALUE1
289 ,P_INPUT_VALUE_ID2
290 ,P_INPUT_VALUE2
291 ,P_INPUT_VALUE_ID3
292 ,P_INPUT_VALUE3
293 ,P_INPUT_VALUE_ID4
294 ,P_INPUT_VALUE4
295 ,P_INPUT_VALUE_ID5
296 ,P_INPUT_VALUE5
297 ,P_INPUT_VALUE_ID6
298 ,P_INPUT_VALUE6
299 ,P_INPUT_VALUE_ID7
300 ,P_INPUT_VALUE7
301 ,P_INPUT_VALUE_ID8
302 ,P_INPUT_VALUE8
303 ,P_INPUT_VALUE_ID9
304 ,P_INPUT_VALUE9
305 ,P_INPUT_VALUE_ID10
306 ,P_INPUT_VALUE10
307 ,P_INPUT_VALUE_ID11
308 ,P_INPUT_VALUE11
309 ,P_INPUT_VALUE_ID12
310 ,P_INPUT_VALUE12
311 ,P_INPUT_VALUE_ID13
312 ,P_INPUT_VALUE13
313 ,P_INPUT_VALUE_ID14
314 ,P_INPUT_VALUE14
315 ,P_INPUT_VALUE_ID15
316 ,P_INPUT_VALUE15
317 ,P_ITEM_TYPE
318 ,P_ITEM_KEY
319 ,P_STATUS
320 ,P_PL_ORDR_NUM
321 ,P_OIPL_ORDR_NUM
322 ,P_REASON
323 ,P_FUTURE_DATA_EXISTS
324 ,P_OBJECT_VERSION_NUMBER
325 ,P_E_OBJECT_VERSION_NUMBER
326 ,P_COST_ALLOCATION_KEYFLEX_ID
327 ,P_ATTRIBUTE_CATEGORY
328 ,P_ATTRIBUTE1
329 ,P_ATTRIBUTE2
330 ,P_ATTRIBUTE3
331 ,P_ATTRIBUTE4
332 ,P_ATTRIBUTE5
333 ,P_ATTRIBUTE6
334 ,P_ATTRIBUTE7
335 ,P_ATTRIBUTE8
336 ,P_ATTRIBUTE9
337 ,P_ATTRIBUTE10
338 ,P_ATTRIBUTE11
339 ,P_ATTRIBUTE12
340 ,P_ATTRIBUTE13
341 ,P_ATTRIBUTE14
342 ,P_ATTRIBUTE15
343 ,P_ATTRIBUTE16
344 ,P_ATTRIBUTE17
345 ,P_ATTRIBUTE18
346 ,P_ATTRIBUTE19
347 ,P_ATTRIBUTE20
348 ,P_ENTRY_INFORMATION_CATEGORY
349 ,P_ENTRY_INFORMATION1
350 ,P_ENTRY_INFORMATION2
351 ,P_ENTRY_INFORMATION3
352 ,P_ENTRY_INFORMATION4
353 ,P_ENTRY_INFORMATION5
354 ,P_ENTRY_INFORMATION6
358 ,P_ENTRY_INFORMATION10
355 ,P_ENTRY_INFORMATION7
356 ,P_ENTRY_INFORMATION8
357 ,P_ENTRY_INFORMATION9
359 ,P_ENTRY_INFORMATION11
360 ,P_ENTRY_INFORMATION12
361 ,P_ENTRY_INFORMATION13
362 ,P_ENTRY_INFORMATION14
363 ,P_ENTRY_INFORMATION15
364 ,P_ENTRY_INFORMATION16
365 ,P_ENTRY_INFORMATION17
366 ,P_ENTRY_INFORMATION18
367 ,P_ENTRY_INFORMATION19
368 ,P_ENTRY_INFORMATION20
369 ,P_ENTRY_INFORMATION21
370 ,P_ENTRY_INFORMATION22
371 ,P_ENTRY_INFORMATION23
372 ,P_ENTRY_INFORMATION24
373 ,P_ENTRY_INFORMATION25
374 ,P_ENTRY_INFORMATION26
375 ,P_ENTRY_INFORMATION27
376 ,P_ENTRY_INFORMATION28
377 ,P_ENTRY_INFORMATION29
378 ,P_ENTRY_INFORMATION30
379 );
380
381
382 end CREATE_TRANSACTION;
383
384 procedure UPDATE_TRANSACTION
385 (
386 P_ICD_TRANSACTION_ID IN NUMBER
387 ,P_ICD_CHC_RATE_ID IN NUMBER
388 ,P_BUSINESS_GROUP_ID IN NUMBER
389 ,P_PERSON_ID IN NUMBER
390 ,P_ASSIGNMENT_ID IN NUMBER
391 ,P_TRANSACTION_ID IN NUMBER
392 ,P_TRANSACTION_STEP_ID IN NUMBER
393 ,P_EFFECTIVE_START_DATE IN DATE
394 ,P_EFFECTIVE_END_DATE IN DATE
395 ,P_DML_OPERATION IN VARCHAR
396 ,P_DATETRACK_MODE IN VARCHAR
397 ,P_EFFECTIVE_DATE IN DATE
398 ,P_PL_TYP_ID IN NUMBER
399 ,P_PL_ID IN NUMBER
400 ,P_OPT_ID IN NUMBER
401 ,P_OIPL_ID IN NUMBER
402 ,P_ACTY_BASE_RT_ID IN NUMBER
403 ,P_RT_STRT_DT_CD IN VARCHAR
404 ,P_RT_STRT_DT IN DATE
405 ,P_RT_STRT_DT_RL IN NUMBER
406 ,P_RT_END_DT_CD IN VARCHAR
407 ,P_RT_END_DT IN DATE
408 ,P_RT_END_DT_RL IN NUMBER
409 ,P_NNMNTRY_UOM IN VARCHAR
410 ,P_BNF_RQD_FLAG IN VARCHAR
411 ,P_ELEMENT_TYPE_ID IN NUMBER
412 ,P_ELEMENT_LINK_ID IN NUMBER
413 ,P_ELEMENT_ENTRY_ID IN NUMBER
414 ,P_ELEMENT_TYPE_CONTEXT IN VARCHAR
415 ,P_INPUT_VALUE_ID1 IN NUMBER
416 ,P_INPUT_VALUE1 IN VARCHAR
417 ,P_INPUT_VALUE_ID2 IN NUMBER
418 ,P_INPUT_VALUE2 IN VARCHAR
419 ,P_INPUT_VALUE_ID3 IN NUMBER
420 ,P_INPUT_VALUE3 IN VARCHAR
421 ,P_INPUT_VALUE_ID4 IN NUMBER
422 ,P_INPUT_VALUE4 IN VARCHAR
423 ,P_INPUT_VALUE_ID5 IN NUMBER
424 ,P_INPUT_VALUE5 IN VARCHAR
425 ,P_INPUT_VALUE_ID6 IN NUMBER
426 ,P_INPUT_VALUE6 IN VARCHAR
427 ,P_INPUT_VALUE_ID7 IN NUMBER
428 ,P_INPUT_VALUE7 IN VARCHAR
429 ,P_INPUT_VALUE_ID8 IN NUMBER
430 ,P_INPUT_VALUE8 IN VARCHAR
431 ,P_INPUT_VALUE_ID9 IN NUMBER
432 ,P_INPUT_VALUE9 IN VARCHAR
433 ,P_INPUT_VALUE_ID10 IN NUMBER
434 ,P_INPUT_VALUE10 IN VARCHAR
435 ,P_INPUT_VALUE_ID11 IN NUMBER
436 ,P_INPUT_VALUE11 IN VARCHAR
437 ,P_INPUT_VALUE_ID12 IN NUMBER
438 ,P_INPUT_VALUE12 IN VARCHAR
439 ,P_INPUT_VALUE_ID13 IN NUMBER
440 ,P_INPUT_VALUE13 IN VARCHAR
441 ,P_INPUT_VALUE_ID14 IN NUMBER
442 ,P_INPUT_VALUE14 IN VARCHAR
443 ,P_INPUT_VALUE_ID15 IN NUMBER
444 ,P_INPUT_VALUE15 IN VARCHAR
445 ,P_ITEM_TYPE IN VARCHAR
446 ,P_ITEM_KEY IN VARCHAR
447 ,P_STATUS IN VARCHAR
448 ,P_PL_ORDR_NUM IN NUMBER
449 ,P_OIPL_ORDR_NUM IN NUMBER
450 ,P_REASON IN VARCHAR
451 ,P_FUTURE_DATA_EXISTS IN VARCHAR
452 ,P_OBJECT_VERSION_NUMBER IN NUMBER
453 ,P_E_OBJECT_VERSION_NUMBER IN NUMBER
454 ,P_COST_ALLOCATION_KEYFLEX_ID IN NUMBER
455 ,P_ATTRIBUTE_CATEGORY IN VARCHAR
456 ,P_ATTRIBUTE1 IN VARCHAR
457 ,P_ATTRIBUTE2 IN VARCHAR
458 ,P_ATTRIBUTE3 IN VARCHAR
459 ,P_ATTRIBUTE4 IN VARCHAR
460 ,P_ATTRIBUTE5 IN VARCHAR
461 ,P_ATTRIBUTE6 IN VARCHAR
462 ,P_ATTRIBUTE7 IN VARCHAR
463 ,P_ATTRIBUTE8 IN VARCHAR
464 ,P_ATTRIBUTE9 IN VARCHAR
465 ,P_ATTRIBUTE10 IN VARCHAR
466 ,P_ATTRIBUTE11 IN VARCHAR
467 ,P_ATTRIBUTE12 IN VARCHAR
468 ,P_ATTRIBUTE13 IN VARCHAR
469 ,P_ATTRIBUTE14 IN VARCHAR
470 ,P_ATTRIBUTE15 IN VARCHAR
471 ,P_ATTRIBUTE16 IN VARCHAR
472 ,P_ATTRIBUTE17 IN VARCHAR
473 ,P_ATTRIBUTE18 IN VARCHAR
474 ,P_ATTRIBUTE19 IN VARCHAR
475 ,P_ATTRIBUTE20 IN VARCHAR
476 ,P_ENTRY_INFORMATION_CATEGORY IN VARCHAR
477 ,P_ENTRY_INFORMATION1 IN VARCHAR
478 ,P_ENTRY_INFORMATION2 IN VARCHAR
479 ,P_ENTRY_INFORMATION3 IN VARCHAR
480 ,P_ENTRY_INFORMATION4 IN VARCHAR
481 ,P_ENTRY_INFORMATION5 IN VARCHAR
482 ,P_ENTRY_INFORMATION6 IN VARCHAR
483 ,P_ENTRY_INFORMATION7 IN VARCHAR
484 ,P_ENTRY_INFORMATION8 IN VARCHAR
485 ,P_ENTRY_INFORMATION9 IN VARCHAR
486 ,P_ENTRY_INFORMATION10 IN VARCHAR
487 ,P_ENTRY_INFORMATION11 IN VARCHAR
491 ,P_ENTRY_INFORMATION15 IN VARCHAR
488 ,P_ENTRY_INFORMATION12 IN VARCHAR
489 ,P_ENTRY_INFORMATION13 IN VARCHAR
490 ,P_ENTRY_INFORMATION14 IN VARCHAR
492 ,P_ENTRY_INFORMATION16 IN VARCHAR
493 ,P_ENTRY_INFORMATION17 IN VARCHAR
494 ,P_ENTRY_INFORMATION18 IN VARCHAR
495 ,P_ENTRY_INFORMATION19 IN VARCHAR
496 ,P_ENTRY_INFORMATION20 IN VARCHAR
497 ,P_ENTRY_INFORMATION21 IN VARCHAR
498 ,P_ENTRY_INFORMATION22 IN VARCHAR
499 ,P_ENTRY_INFORMATION23 IN VARCHAR
500 ,P_ENTRY_INFORMATION24 IN VARCHAR
501 ,P_ENTRY_INFORMATION25 IN VARCHAR
502 ,P_ENTRY_INFORMATION26 IN VARCHAR
503 ,P_ENTRY_INFORMATION27 IN VARCHAR
504 ,P_ENTRY_INFORMATION28 IN VARCHAR
505 ,P_ENTRY_INFORMATION29 IN VARCHAR
506 ,P_ENTRY_INFORMATION30 IN VARCHAR
507 ) is
508 begin
509 update
510 ben_icd_transaction
511 set
512 ICD_CHC_RATE_ID = P_ICD_CHC_RATE_ID
513 ,BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
514 ,PERSON_ID = P_PERSON_ID
515 ,ASSIGNMENT_ID = P_ASSIGNMENT_ID
516 ,TRANSACTION_ID = P_TRANSACTION_ID
517 ,TRANSACTION_STEP_ID = P_TRANSACTION_STEP_ID
518 ,EFFECTIVE_START_DATE = P_EFFECTIVE_START_DATE
519 ,EFFECTIVE_END_DATE = P_EFFECTIVE_END_DATE
520 ,DML_OPERATION = P_DML_OPERATION
521 ,DATETRACK_MODE = P_DATETRACK_MODE
522 ,EFFECTIVE_DATE = P_EFFECTIVE_DATE
523 ,PL_TYP_ID = P_PL_TYP_ID
524 ,PL_ID = P_PL_ID
525 ,OPT_ID = P_OPT_ID
526 ,OIPL_ID = P_OIPL_ID
527 ,ACTY_BASE_RT_ID = P_ACTY_BASE_RT_ID
528 ,RT_STRT_DT_CD = P_RT_STRT_DT_CD
529 ,RT_STRT_DT = P_RT_STRT_DT
530 ,RT_STRT_DT_RL = P_RT_STRT_DT_RL
531 ,RT_END_DT_CD = P_RT_END_DT_CD
532 ,RT_END_DT = P_RT_END_DT
533 ,RT_END_DT_RL = P_RT_END_DT_RL
534 ,NNMNTRY_UOM = P_NNMNTRY_UOM
535 ,BNF_RQD_FLAG = P_BNF_RQD_FLAG
536 ,FUTURE_DATA_EXISTS = P_FUTURE_DATA_EXISTS
537 ,OBJECT_VERSION_NUMBER = P_OBJECT_VERSION_NUMBER
538 ,E_OBJECT_VERSION_NUMBER = P_E_OBJECT_VERSION_NUMBER
539 ,ELEMENT_TYPE_ID = P_ELEMENT_TYPE_ID
540 ,ELEMENT_LINK_ID = P_ELEMENT_LINK_ID
541 ,ELEMENT_ENTRY_ID = P_ELEMENT_ENTRY_ID
542 ,ELEMENT_TYPE_CONTEXT = P_ELEMENT_TYPE_CONTEXT
543 ,INPUT_VALUE_ID1 = P_INPUT_VALUE_ID1
544 ,INPUT_VALUE1 = P_INPUT_VALUE1
545 ,INPUT_VALUE_ID2 = P_INPUT_VALUE_ID2
546 ,INPUT_VALUE2 = P_INPUT_VALUE2
547 ,INPUT_VALUE_ID3 = P_INPUT_VALUE_ID3
548 ,INPUT_VALUE3 = P_INPUT_VALUE3
549 ,INPUT_VALUE_ID4 = P_INPUT_VALUE_ID4
550 ,INPUT_VALUE4 = P_INPUT_VALUE4
551 ,INPUT_VALUE_ID5 = P_INPUT_VALUE_ID5
552 ,INPUT_VALUE5 = P_INPUT_VALUE5
553 ,INPUT_VALUE_ID6 = P_INPUT_VALUE_ID6
554 ,INPUT_VALUE6 = P_INPUT_VALUE6
555 ,INPUT_VALUE_ID7 = P_INPUT_VALUE_ID7
556 ,INPUT_VALUE7 = P_INPUT_VALUE7
557 ,INPUT_VALUE_ID8 = P_INPUT_VALUE_ID8
558 ,INPUT_VALUE8 = P_INPUT_VALUE8
559 ,INPUT_VALUE_ID9 = P_INPUT_VALUE_ID9
560 ,INPUT_VALUE9 = P_INPUT_VALUE9
561 ,INPUT_VALUE_ID10 = P_INPUT_VALUE_ID10
562 ,INPUT_VALUE10 = P_INPUT_VALUE10
563 ,INPUT_VALUE_ID11 = P_INPUT_VALUE_ID11
564 ,INPUT_VALUE11 = P_INPUT_VALUE11
565 ,INPUT_VALUE_ID12 = P_INPUT_VALUE_ID12
566 ,INPUT_VALUE12 = P_INPUT_VALUE12
567 ,INPUT_VALUE_ID13 = P_INPUT_VALUE_ID13
568 ,INPUT_VALUE13 = P_INPUT_VALUE13
569 ,INPUT_VALUE_ID14 = P_INPUT_VALUE_ID14
570 ,INPUT_VALUE14 = P_INPUT_VALUE14
571 ,INPUT_VALUE_ID15 = P_INPUT_VALUE_ID15
572 ,INPUT_VALUE15 = P_INPUT_VALUE15
573 ,ITEM_TYPE = P_ITEM_TYPE
574 ,ITEM_KEY = P_ITEM_KEY
575 ,STATUS = P_STATUS
576 ,PL_ORDR_NUM = P_PL_ORDR_NUM
577 ,OIPL_ORDR_NUM = P_OIPL_ORDR_NUM
578 ,REASON = P_REASON
579 ,COST_ALLOCATION_KEYFLEX_ID = P_COST_ALLOCATION_KEYFLEX_ID
580 ,ATTRIBUTE_CATEGORY = P_ATTRIBUTE_CATEGORY
581 ,ATTRIBUTE1 = P_ATTRIBUTE1
582 ,ATTRIBUTE2 = P_ATTRIBUTE2
583 ,ATTRIBUTE3 = P_ATTRIBUTE3
584 ,ATTRIBUTE4 = P_ATTRIBUTE4
585 ,ATTRIBUTE5 = P_ATTRIBUTE5
586 ,ATTRIBUTE6 = P_ATTRIBUTE6
587 ,ATTRIBUTE7 = P_ATTRIBUTE7
588 ,ATTRIBUTE8 = P_ATTRIBUTE8
589 ,ATTRIBUTE9 = P_ATTRIBUTE9
590 ,ATTRIBUTE10 = P_ATTRIBUTE10
591 ,ATTRIBUTE11 = P_ATTRIBUTE11
592 ,ATTRIBUTE12 = P_ATTRIBUTE12
593 ,ATTRIBUTE13 = P_ATTRIBUTE13
594 ,ATTRIBUTE14 = P_ATTRIBUTE14
595 ,ATTRIBUTE15 = P_ATTRIBUTE15
596 ,ATTRIBUTE16 = P_ATTRIBUTE16
597 ,ATTRIBUTE17 = P_ATTRIBUTE17
598 ,ATTRIBUTE18 = P_ATTRIBUTE18
599 ,ATTRIBUTE19 = P_ATTRIBUTE19
600 ,ATTRIBUTE20 = P_ATTRIBUTE20
601 ,ENTRY_INFORMATION_CATEGORY = P_ENTRY_INFORMATION_CATEGORY
602 ,ENTRY_INFORMATION1 = P_ENTRY_INFORMATION1
603 ,ENTRY_INFORMATION2 = P_ENTRY_INFORMATION2
604 ,ENTRY_INFORMATION3 = P_ENTRY_INFORMATION3
605 ,ENTRY_INFORMATION4 = P_ENTRY_INFORMATION4
606 ,ENTRY_INFORMATION5 = P_ENTRY_INFORMATION5
607 ,ENTRY_INFORMATION6 = P_ENTRY_INFORMATION6
608 ,ENTRY_INFORMATION7 = P_ENTRY_INFORMATION7
609 ,ENTRY_INFORMATION8 = P_ENTRY_INFORMATION8
610 ,ENTRY_INFORMATION9 = P_ENTRY_INFORMATION9
611 ,ENTRY_INFORMATION10 = P_ENTRY_INFORMATION10
612 ,ENTRY_INFORMATION11 = P_ENTRY_INFORMATION11
613 ,ENTRY_INFORMATION12 = P_ENTRY_INFORMATION12
614 ,ENTRY_INFORMATION13 = P_ENTRY_INFORMATION13
615 ,ENTRY_INFORMATION14 = P_ENTRY_INFORMATION14
616 ,ENTRY_INFORMATION15 = P_ENTRY_INFORMATION15
617 ,ENTRY_INFORMATION16 = P_ENTRY_INFORMATION16
618 ,ENTRY_INFORMATION17 = P_ENTRY_INFORMATION17
619 ,ENTRY_INFORMATION18 = P_ENTRY_INFORMATION18
620 ,ENTRY_INFORMATION19 = P_ENTRY_INFORMATION19
621 ,ENTRY_INFORMATION20 = P_ENTRY_INFORMATION20
622 ,ENTRY_INFORMATION21 = P_ENTRY_INFORMATION21
623 ,ENTRY_INFORMATION22 = P_ENTRY_INFORMATION22
624 ,ENTRY_INFORMATION23 = P_ENTRY_INFORMATION23
625 ,ENTRY_INFORMATION24 = P_ENTRY_INFORMATION24
626 ,ENTRY_INFORMATION25 = P_ENTRY_INFORMATION25
627 ,ENTRY_INFORMATION26 = P_ENTRY_INFORMATION26
628 ,ENTRY_INFORMATION27 = P_ENTRY_INFORMATION27
629 ,ENTRY_INFORMATION28 = P_ENTRY_INFORMATION28
630 ,ENTRY_INFORMATION29 = P_ENTRY_INFORMATION29
631 ,ENTRY_INFORMATION30 = P_ENTRY_INFORMATION30
632 where
633 icd_transaction_id = P_ICD_TRANSACTION_ID;
634 end UPDATE_TRANSACTION;
635
636
637
638 END BEN_ICD_PKG;
639