[Home] [Help]
PACKAGE BODY: APPS.PAY_PSS_TX_STEPS_PKG
Source
1 package body pay_pss_tx_steps_pkg as
2 /* $Header: pypsst.pkb 120.0.12010000.2 2009/09/26 06:12:35 pgongada ship $ */
3 ---------------------------------< create_row >----------------------------
4 procedure insert_row
5 (p_transaction_id in out nocopy number
6 ,p_transaction_step_id out nocopy number
7 ,p_source_table in varchar2
8 ,p_state in varchar2
9 ,p_personal_payment_method_id in number
10 ,p_update_ovn in number
11 ,p_delete_ovn in number
12 ,p_update_datetrack_mode in varchar2
13 ,p_delete_datetrack_mode in varchar2
14 ,p_delete_disabled in varchar2
15 ,p_effective_date in date
16 ,p_org_payment_method_id in number
17 ,p_assignment_id in number
18 ,p_payment_type in varchar2
19 ,p_currency_code in varchar2
20 ,p_territory_code in varchar2
21 ,p_run_type_id in number
22 ,p_real_priority in number
23 ,p_logical_priority in number
24 ,p_amount_type in varchar2
25 ,p_amount in number
26 ,p_external_account_id in number
27 ,p_attribute_category in varchar2
28 ,p_attribute1 in varchar2
29 ,p_attribute2 in varchar2
30 ,p_attribute3 in varchar2
31 ,p_attribute4 in varchar2
32 ,p_attribute5 in varchar2
33 ,p_attribute6 in varchar2
34 ,p_attribute7 in varchar2
35 ,p_attribute8 in varchar2
36 ,p_attribute9 in varchar2
37 ,p_attribute10 in varchar2
38 ,p_attribute11 in varchar2
39 ,p_attribute12 in varchar2
40 ,p_attribute13 in varchar2
41 ,p_attribute14 in varchar2
42 ,p_attribute15 in varchar2
43 ,p_attribute16 in varchar2
44 ,p_attribute17 in varchar2
45 ,p_attribute18 in varchar2
46 ,p_attribute19 in varchar2
47 ,p_attribute20 in varchar2
48 ,p_o_real_priority in number
49 ,p_o_logical_priority in number
50 ,p_o_amount_type in varchar2
51 ,p_o_amount in number
52 ,p_o_external_account_id in number
53 ,p_o_attribute_category in varchar2
54 ,p_o_attribute1 in varchar2
55 ,p_o_attribute2 in varchar2
56 ,p_o_attribute3 in varchar2
57 ,p_o_attribute4 in varchar2
58 ,p_o_attribute5 in varchar2
59 ,p_o_attribute6 in varchar2
60 ,p_o_attribute7 in varchar2
61 ,p_o_attribute8 in varchar2
62 ,p_o_attribute9 in varchar2
63 ,p_o_attribute10 in varchar2
64 ,p_o_attribute11 in varchar2
65 ,p_o_attribute12 in varchar2
66 ,p_o_attribute13 in varchar2
67 ,p_o_attribute14 in varchar2
68 ,p_o_attribute15 in varchar2
69 ,p_o_attribute16 in varchar2
70 ,p_o_attribute17 in varchar2
71 ,p_o_attribute18 in varchar2
72 ,p_o_attribute19 in varchar2
73 ,p_o_attribute20 in varchar2
74 ,p_ppm_information_category in varchar2
75 ,p_ppm_information1 in varchar2
76 ,p_ppm_information2 in varchar2
77 ,p_ppm_information3 in varchar2
78 ,p_ppm_information4 in varchar2
79 ,p_ppm_information5 in varchar2
80 ,p_ppm_information6 in varchar2
81 ,p_ppm_information7 in varchar2
82 ,p_ppm_information8 in varchar2
83 ,p_ppm_information9 in varchar2
84 ,p_ppm_information10 in varchar2
85 ,p_ppm_information11 in varchar2
86 ,p_ppm_information12 in varchar2
87 ,p_ppm_information13 in varchar2
88 ,p_ppm_information14 in varchar2
89 ,p_ppm_information15 in varchar2
90 ,p_ppm_information16 in varchar2
91 ,p_ppm_information17 in varchar2
92 ,p_ppm_information18 in varchar2
93 ,p_ppm_information19 in varchar2
94 ,p_ppm_information20 in varchar2
95 ,p_ppm_information21 in varchar2
96 ,p_ppm_information22 in varchar2
97 ,p_ppm_information23 in varchar2
98 ,p_ppm_information24 in varchar2
99 ,p_ppm_information25 in varchar2
100 ,p_ppm_information26 in varchar2
101 ,p_ppm_information27 in varchar2
102 ,p_ppm_information28 in varchar2
103 ,p_ppm_information29 in varchar2
104 ,p_ppm_information30 in varchar2
105 ,p_o_ppm_information_category in varchar2
106 ,p_o_ppm_information1 in varchar2
107 ,p_o_ppm_information2 in varchar2
108 ,p_o_ppm_information3 in varchar2
109 ,p_o_ppm_information4 in varchar2
110 ,p_o_ppm_information5 in varchar2
111 ,p_o_ppm_information6 in varchar2
112 ,p_o_ppm_information7 in varchar2
113 ,p_o_ppm_information8 in varchar2
114 ,p_o_ppm_information9 in varchar2
115 ,p_o_ppm_information10 in varchar2
116 ,p_o_ppm_information11 in varchar2
117 ,p_o_ppm_information12 in varchar2
118 ,p_o_ppm_information13 in varchar2
119 ,p_o_ppm_information14 in varchar2
120 ,p_o_ppm_information15 in varchar2
121 ,p_o_ppm_information16 in varchar2
122 ,p_o_ppm_information17 in varchar2
123 ,p_o_ppm_information18 in varchar2
124 ,p_o_ppm_information19 in varchar2
125 ,p_o_ppm_information20 in varchar2
126 ,p_o_ppm_information21 in varchar2
127 ,p_o_ppm_information22 in varchar2
128 ,p_o_ppm_information23 in varchar2
129 ,p_o_ppm_information24 in varchar2
130 ,p_o_ppm_information25 in varchar2
131 ,p_o_ppm_information26 in varchar2
132 ,p_o_ppm_information27 in varchar2
133 ,p_o_ppm_information28 in varchar2
134 ,p_o_ppm_information29 in varchar2
135 ,p_o_ppm_information30 in varchar2
136 ) is
137 l_transaction_id number := p_transaction_id;
138 l_transaction_step_id number;
139 begin
140 --
141 -- Create (and return) transaction_id, if necessary.
142 --
143 if l_transaction_id is null then
144 select pay_pss_transactions_s.nextval
145 into l_transaction_id
146 from dual;
147 p_transaction_id := l_transaction_id;
148 end if;
149 --
150 -- Create and return the transaction_step_id.
151 --
152 select pay_pss_transaction_steps_s.nextval
153 into l_transaction_step_id
154 from dual;
155 p_transaction_step_id := l_transaction_step_id;
156 --
157 -- Do the insert.
158 --
159 insert into pay_pss_transaction_steps
160 (transaction_step_id
161 ,transaction_id
162 ,source_table
163 ,state
164 ,personal_payment_method_id
165 ,update_ovn
166 ,delete_ovn
167 ,update_datetrack_mode
168 ,delete_datetrack_mode
169 ,delete_disabled
170 ,effective_date
171 ,org_payment_method_id
172 ,assignment_id
173 ,payment_type
174 ,currency_code
175 ,territory_code
176 ,real_priority
177 ,logical_priority
178 ,amount_type
179 ,amount
180 ,external_account_id
181 ,attribute_category
182 ,attribute1
183 ,attribute2
184 ,attribute3
185 ,attribute4
186 ,attribute5
187 ,attribute6
188 ,attribute7
189 ,attribute8
190 ,attribute9
191 ,attribute10
192 ,attribute11
193 ,attribute12
194 ,attribute13
195 ,attribute14
196 ,attribute15
197 ,attribute16
198 ,attribute17
199 ,attribute18
200 ,attribute19
201 ,attribute20
202 ,o_real_priority
203 ,o_logical_priority
204 ,o_amount_type
205 ,o_amount
206 ,o_external_account_id
207 ,o_attribute_category
208 ,o_attribute1
209 ,o_attribute2
210 ,o_attribute3
211 ,o_attribute4
212 ,o_attribute5
213 ,o_attribute6
214 ,o_attribute7
215 ,o_attribute8
216 ,o_attribute9
217 ,o_attribute10
218 ,o_attribute11
219 ,o_attribute12
220 ,o_attribute13
221 ,o_attribute14
222 ,o_attribute15
223 ,o_attribute16
224 ,o_attribute17
225 ,o_attribute18
226 ,o_attribute19
227 ,o_attribute20
228 ,run_type_id
229 ,ppm_information_category
230 ,ppm_information1
231 ,ppm_information2
232 ,ppm_information3
233 ,ppm_information4
234 ,ppm_information5
235 ,ppm_information6
236 ,ppm_information7
237 ,ppm_information8
238 ,ppm_information9
239 ,ppm_information10
240 ,ppm_information11
241 ,ppm_information12
242 ,ppm_information13
243 ,ppm_information14
244 ,ppm_information15
245 ,ppm_information16
246 ,ppm_information17
247 ,ppm_information18
248 ,ppm_information19
249 ,ppm_information20
250 ,ppm_information21
251 ,ppm_information22
252 ,ppm_information23
253 ,ppm_information24
254 ,ppm_information25
255 ,ppm_information26
256 ,ppm_information27
257 ,ppm_information28
258 ,ppm_information29
259 ,ppm_information30
260 ,o_ppm_information_category
261 ,o_ppm_information1
262 ,o_ppm_information2
263 ,o_ppm_information3
264 ,o_ppm_information4
265 ,o_ppm_information5
266 ,o_ppm_information6
267 ,o_ppm_information7
268 ,o_ppm_information8
269 ,o_ppm_information9
270 ,o_ppm_information10
271 ,o_ppm_information11
272 ,o_ppm_information12
273 ,o_ppm_information13
274 ,o_ppm_information14
275 ,o_ppm_information15
276 ,o_ppm_information16
277 ,o_ppm_information17
278 ,o_ppm_information18
279 ,o_ppm_information19
280 ,o_ppm_information20
281 ,o_ppm_information21
282 ,o_ppm_information22
283 ,o_ppm_information23
284 ,o_ppm_information24
285 ,o_ppm_information25
286 ,o_ppm_information26
287 ,o_ppm_information27
288 ,o_ppm_information28
289 ,o_ppm_information29
290 ,o_ppm_information30
291 )
292 values
293 (l_transaction_step_id
294 ,l_transaction_id
295 ,p_source_table
296 ,p_state
297 ,p_personal_payment_method_id
298 ,p_update_ovn
299 ,p_delete_ovn
300 ,p_update_datetrack_mode
301 ,p_delete_datetrack_mode
302 ,p_delete_disabled
303 ,p_effective_date
304 ,p_org_payment_method_id
305 ,p_assignment_id
306 ,p_payment_type
307 ,p_currency_code
308 ,p_territory_code
309 ,p_real_priority
310 ,p_logical_priority
311 ,p_amount_type
312 ,p_amount
313 ,p_external_account_id
314 ,p_attribute_category
315 ,p_attribute1
316 ,p_attribute2
317 ,p_attribute3
318 ,p_attribute4
319 ,p_attribute5
320 ,p_attribute6
321 ,p_attribute7
322 ,p_attribute8
323 ,p_attribute9
324 ,p_attribute10
325 ,p_attribute11
326 ,p_attribute12
327 ,p_attribute13
328 ,p_attribute14
329 ,p_attribute15
330 ,p_attribute16
331 ,p_attribute17
332 ,p_attribute18
333 ,p_attribute19
334 ,p_attribute20
335 ,p_o_real_priority
336 ,p_o_logical_priority
337 ,p_o_amount_type
338 ,p_o_amount
339 ,p_o_external_account_id
340 ,p_o_attribute_category
341 ,p_o_attribute1
342 ,p_o_attribute2
343 ,p_o_attribute3
344 ,p_o_attribute4
345 ,p_o_attribute5
346 ,p_o_attribute6
347 ,p_o_attribute7
348 ,p_o_attribute8
349 ,p_o_attribute9
350 ,p_o_attribute10
351 ,p_o_attribute11
352 ,p_o_attribute12
353 ,p_o_attribute13
354 ,p_o_attribute14
355 ,p_o_attribute15
356 ,p_o_attribute16
357 ,p_o_attribute17
358 ,p_o_attribute18
359 ,p_o_attribute19
360 ,p_o_attribute20
361 ,p_run_type_id
362 ,p_ppm_information_category
363 ,p_ppm_information1
364 ,p_ppm_information2
365 ,p_ppm_information3
366 ,p_ppm_information4
367 ,p_ppm_information5
368 ,p_ppm_information6
369 ,p_ppm_information7
370 ,p_ppm_information8
371 ,p_ppm_information9
372 ,p_ppm_information10
373 ,p_ppm_information11
374 ,p_ppm_information12
375 ,p_ppm_information13
376 ,p_ppm_information14
377 ,p_ppm_information15
378 ,p_ppm_information16
379 ,p_ppm_information17
380 ,p_ppm_information18
381 ,p_ppm_information19
382 ,p_ppm_information20
383 ,p_ppm_information21
384 ,p_ppm_information22
385 ,p_ppm_information23
386 ,p_ppm_information24
387 ,p_ppm_information25
388 ,p_ppm_information26
389 ,p_ppm_information27
390 ,p_ppm_information28
391 ,p_ppm_information29
392 ,p_ppm_information30
393 ,p_o_ppm_information_category
394 ,p_o_ppm_information1
395 ,p_o_ppm_information2
396 ,p_o_ppm_information3
397 ,p_o_ppm_information4
398 ,p_o_ppm_information5
399 ,p_o_ppm_information6
400 ,p_o_ppm_information7
401 ,p_o_ppm_information8
402 ,p_o_ppm_information9
403 ,p_o_ppm_information10
404 ,p_o_ppm_information11
405 ,p_o_ppm_information12
406 ,p_o_ppm_information13
407 ,p_o_ppm_information14
408 ,p_o_ppm_information15
409 ,p_o_ppm_information16
410 ,p_o_ppm_information17
411 ,p_o_ppm_information18
412 ,p_o_ppm_information19
413 ,p_o_ppm_information20
414 ,p_o_ppm_information21
415 ,p_o_ppm_information22
416 ,p_o_ppm_information23
417 ,p_o_ppm_information24
418 ,p_o_ppm_information25
419 ,p_o_ppm_information26
420 ,p_o_ppm_information27
421 ,p_o_ppm_information28
422 ,p_o_ppm_information29
423 ,p_o_ppm_information30
424 );
425 end insert_row;
426 ----------------------------------< update_row >----------------------------
427 procedure update_row
428 (p_transaction_step_id in number
429 ,p_source_table in varchar2
430 ,p_state in varchar2
434 ,p_update_datetrack_mode in varchar2
431 ,p_personal_payment_method_id in number
432 ,p_update_ovn in number
433 ,p_delete_ovn in number
435 ,p_delete_datetrack_mode in varchar2
436 ,p_delete_disabled in varchar2
437 ,p_effective_date in date
438 ,p_org_payment_method_id in number
439 ,p_assignment_id in number
440 ,p_payment_type in varchar2
441 ,p_currency_code in varchar2
442 ,p_territory_code in varchar2
443 ,p_run_type_id in number
444 ,p_real_priority in number
445 ,p_logical_priority in number
446 ,p_amount_type in varchar2
447 ,p_amount in number
448 ,p_external_account_id in number
449 ,p_attribute_category in varchar2
450 ,p_attribute1 in varchar2
451 ,p_attribute2 in varchar2
452 ,p_attribute3 in varchar2
453 ,p_attribute4 in varchar2
454 ,p_attribute5 in varchar2
455 ,p_attribute6 in varchar2
456 ,p_attribute7 in varchar2
457 ,p_attribute8 in varchar2
458 ,p_attribute9 in varchar2
459 ,p_attribute10 in varchar2
460 ,p_attribute11 in varchar2
461 ,p_attribute12 in varchar2
462 ,p_attribute13 in varchar2
463 ,p_attribute14 in varchar2
464 ,p_attribute15 in varchar2
465 ,p_attribute16 in varchar2
466 ,p_attribute17 in varchar2
467 ,p_attribute18 in varchar2
468 ,p_attribute19 in varchar2
469 ,p_attribute20 in varchar2
470 ,p_o_real_priority in number
471 ,p_o_logical_priority in number
472 ,p_o_amount_type in varchar2
473 ,p_o_amount in number
474 ,p_o_external_account_id in number
475 ,p_o_attribute_category in varchar2
476 ,p_o_attribute1 in varchar2
477 ,p_o_attribute2 in varchar2
478 ,p_o_attribute3 in varchar2
479 ,p_o_attribute4 in varchar2
480 ,p_o_attribute5 in varchar2
481 ,p_o_attribute6 in varchar2
482 ,p_o_attribute7 in varchar2
483 ,p_o_attribute8 in varchar2
484 ,p_o_attribute9 in varchar2
485 ,p_o_attribute10 in varchar2
486 ,p_o_attribute11 in varchar2
487 ,p_o_attribute12 in varchar2
488 ,p_o_attribute13 in varchar2
489 ,p_o_attribute14 in varchar2
490 ,p_o_attribute15 in varchar2
491 ,p_o_attribute16 in varchar2
492 ,p_o_attribute17 in varchar2
493 ,p_o_attribute18 in varchar2
494 ,p_o_attribute19 in varchar2
495 ,p_o_attribute20 in varchar2
496 ,p_ppm_information_category in varchar2
497 ,p_ppm_information1 in varchar2
498 ,p_ppm_information2 in varchar2
499 ,p_ppm_information3 in varchar2
500 ,p_ppm_information4 in varchar2
501 ,p_ppm_information5 in varchar2
502 ,p_ppm_information6 in varchar2
503 ,p_ppm_information7 in varchar2
504 ,p_ppm_information8 in varchar2
505 ,p_ppm_information9 in varchar2
506 ,p_ppm_information10 in varchar2
507 ,p_ppm_information11 in varchar2
508 ,p_ppm_information12 in varchar2
509 ,p_ppm_information13 in varchar2
510 ,p_ppm_information14 in varchar2
511 ,p_ppm_information15 in varchar2
512 ,p_ppm_information16 in varchar2
513 ,p_ppm_information17 in varchar2
514 ,p_ppm_information18 in varchar2
515 ,p_ppm_information19 in varchar2
516 ,p_ppm_information20 in varchar2
517 ,p_ppm_information21 in varchar2
518 ,p_ppm_information22 in varchar2
519 ,p_ppm_information23 in varchar2
520 ,p_ppm_information24 in varchar2
521 ,p_ppm_information25 in varchar2
522 ,p_ppm_information26 in varchar2
526 ,p_ppm_information30 in varchar2
523 ,p_ppm_information27 in varchar2
524 ,p_ppm_information28 in varchar2
525 ,p_ppm_information29 in varchar2
527 ,p_o_ppm_information_category in varchar2
528 ,p_o_ppm_information1 in varchar2
529 ,p_o_ppm_information2 in varchar2
530 ,p_o_ppm_information3 in varchar2
531 ,p_o_ppm_information4 in varchar2
532 ,p_o_ppm_information5 in varchar2
533 ,p_o_ppm_information6 in varchar2
534 ,p_o_ppm_information7 in varchar2
535 ,p_o_ppm_information8 in varchar2
536 ,p_o_ppm_information9 in varchar2
537 ,p_o_ppm_information10 in varchar2
538 ,p_o_ppm_information11 in varchar2
539 ,p_o_ppm_information12 in varchar2
540 ,p_o_ppm_information13 in varchar2
541 ,p_o_ppm_information14 in varchar2
542 ,p_o_ppm_information15 in varchar2
543 ,p_o_ppm_information16 in varchar2
544 ,p_o_ppm_information17 in varchar2
545 ,p_o_ppm_information18 in varchar2
546 ,p_o_ppm_information19 in varchar2
547 ,p_o_ppm_information20 in varchar2
548 ,p_o_ppm_information21 in varchar2
549 ,p_o_ppm_information22 in varchar2
550 ,p_o_ppm_information23 in varchar2
551 ,p_o_ppm_information24 in varchar2
552 ,p_o_ppm_information25 in varchar2
553 ,p_o_ppm_information26 in varchar2
554 ,p_o_ppm_information27 in varchar2
555 ,p_o_ppm_information28 in varchar2
556 ,p_o_ppm_information29 in varchar2
557 ,p_o_ppm_information30 in varchar2
558 ) is
559 begin
560 update pay_pss_transaction_steps p
561 set p.source_table = p_source_table
562 , p.state = p_state
563 , p.personal_payment_method_id = p_personal_payment_method_id
564 , p.update_ovn = p_update_ovn
565 , p.delete_ovn = p_delete_ovn
566 , p.update_datetrack_mode = p_update_datetrack_mode
567 , p.delete_datetrack_mode = p_delete_datetrack_mode
568 , p.delete_disabled = p_delete_disabled
569 , p.effective_date = p_effective_date
570 , p.org_payment_method_id = p_org_payment_method_id
571 , p.assignment_id = p_assignment_id
572 , p.payment_type = p_payment_type
573 , p.currency_code = p_currency_code
574 , p.territory_code = p_territory_code
575 , p.real_priority = p_real_priority
576 , p.logical_priority = p_logical_priority
577 , p.amount_type = p_amount_type
578 , p.amount = p_amount
579 , p.external_account_id = p_external_account_id
580 , p.attribute_category = p_attribute_category
581 , p.attribute1 = p_attribute1
582 , p.attribute2 = p_attribute2
583 , p.attribute3 = p_attribute3
584 , p.attribute4 = p_attribute4
585 , p.attribute5 = p_attribute5
586 , p.attribute6 = p_attribute6
587 , p.attribute7 = p_attribute7
588 , p.attribute8 = p_attribute8
589 , p.attribute9 = p_attribute9
590 , p.attribute10 = p_attribute10
591 , p.attribute11 = p_attribute11
592 , p.attribute12 = p_attribute12
593 , p.attribute13 = p_attribute13
594 , p.attribute14 = p_attribute14
595 , p.attribute15 = p_attribute15
596 , p.attribute16 = p_attribute16
597 , p.attribute17 = p_attribute17
598 , p.attribute18 = p_attribute18
599 , p.attribute19 = p_attribute19
600 , p.attribute20 = p_attribute20
601 , p.o_real_priority = p_o_real_priority
602 , p.o_logical_priority = p_o_logical_priority
603 , p.o_amount_type = p_o_amount_type
604 , p.o_amount = p_o_amount
605 , p.o_external_account_id = p_o_external_account_id
606 , p.o_attribute_category = p_o_attribute_category
607 , p.o_attribute1 = p_o_attribute1
608 , p.o_attribute2 = p_o_attribute2
609 , p.o_attribute3 = p_o_attribute3
610 , p.o_attribute4 = p_o_attribute4
611 , p.o_attribute5 = p_o_attribute5
612 , p.o_attribute6 = p_o_attribute6
613 , p.o_attribute7 = p_o_attribute7
614 , p.o_attribute8 = p_o_attribute8
615 , p.o_attribute9 = p_o_attribute9
616 , p.o_attribute10 = p_o_attribute10
617 , p.o_attribute11 = p_o_attribute11
618 , p.o_attribute12 = p_o_attribute12
619 , p.o_attribute13 = p_o_attribute13
620 , p.o_attribute14 = p_o_attribute14
621 , p.o_attribute15 = p_o_attribute15
622 , p.o_attribute16 = p_o_attribute16
623 , p.o_attribute17 = p_o_attribute17
624 , p.o_attribute18 = p_o_attribute18
625 , p.o_attribute19 = p_o_attribute19
626 , p.o_attribute20 = p_o_attribute20
627 , p.run_type_id = p_run_type_id
628 , p.ppm_information_category = p_ppm_information_category
629 , p.ppm_information1 = p_ppm_information1
630 , p.ppm_information2 = p_ppm_information2
631 , p.ppm_information3 = p_ppm_information3
632 , p.ppm_information4 = p_ppm_information4
633 , p.ppm_information5 = p_ppm_information5
634 , p.ppm_information6 = p_ppm_information6
635 , p.ppm_information7 = p_ppm_information7
636 , p.ppm_information8 = p_ppm_information8
637 , p.ppm_information9 = p_ppm_information9
638 , p.ppm_information10 = p_ppm_information10
639 , p.ppm_information11 = p_ppm_information11
640 , p.ppm_information12 = p_ppm_information12
641 , p.ppm_information13 = p_ppm_information13
642 , p.ppm_information14 = p_ppm_information14
643 , p.ppm_information15 = p_ppm_information15
644 , p.ppm_information16 = p_ppm_information16
648 , p.ppm_information20 = p_ppm_information20
645 , p.ppm_information17 = p_ppm_information17
646 , p.ppm_information18 = p_ppm_information18
647 , p.ppm_information19 = p_ppm_information19
649 , p.ppm_information21 = p_ppm_information21
650 , p.ppm_information22 = p_ppm_information22
651 , p.ppm_information23 = p_ppm_information23
652 , p.ppm_information24 = p_ppm_information24
653 , p.ppm_information25 = p_ppm_information25
654 , p.ppm_information26 = p_ppm_information26
655 , p.ppm_information27 = p_ppm_information27
656 , p.ppm_information28 = p_ppm_information28
657 , p.ppm_information29 = p_ppm_information29
658 , p.ppm_information30 = p_ppm_information30
659 , p.o_ppm_information_category = p_o_ppm_information_category
660 , p.o_ppm_information1 = p_o_ppm_information1
661 , p.o_ppm_information2 = p_o_ppm_information2
662 , p.o_ppm_information3 = p_o_ppm_information3
663 , p.o_ppm_information4 = p_o_ppm_information4
664 , p.o_ppm_information5 = p_o_ppm_information5
665 , p.o_ppm_information6 = p_o_ppm_information6
666 , p.o_ppm_information7 = p_o_ppm_information7
667 , p.o_ppm_information8 = p_o_ppm_information8
668 , p.o_ppm_information9 = p_o_ppm_information9
669 , p.o_ppm_information10 = p_o_ppm_information10
670 , p.o_ppm_information11 = p_o_ppm_information11
671 , p.o_ppm_information12 = p_o_ppm_information12
672 , p.o_ppm_information13 = p_o_ppm_information13
673 , p.o_ppm_information14 = p_o_ppm_information14
674 , p.o_ppm_information15 = p_o_ppm_information15
675 , p.o_ppm_information16 = p_o_ppm_information16
676 , p.o_ppm_information17 = p_o_ppm_information17
677 , p.o_ppm_information18 = p_o_ppm_information18
678 , p.o_ppm_information19 = p_o_ppm_information19
679 , p.o_ppm_information20 = p_o_ppm_information20
680 , p.o_ppm_information21 = p_o_ppm_information21
681 , p.o_ppm_information22 = p_o_ppm_information22
682 , p.o_ppm_information23 = p_o_ppm_information23
683 , p.o_ppm_information24 = p_o_ppm_information24
684 , p.o_ppm_information25 = p_o_ppm_information25
685 , p.o_ppm_information26 = p_o_ppm_information26
686 , p.o_ppm_information27 = p_o_ppm_information27
687 , p.o_ppm_information28 = p_o_ppm_information28
688 , p.o_ppm_information29 = p_o_ppm_information29
689 , p.o_ppm_information30 = p_o_ppm_information30
690 where p.transaction_step_id = p_transaction_step_id;
691 end update_row;
692 ----------------------------------< delete_row >----------------------------
693 procedure delete_row
694 (p_transaction_step_id in number
695 ) is
696 begin
697 delete
698 from pay_pss_transaction_steps
699 where transaction_step_id = p_transaction_step_id;
700 end delete_row;
701 ---------------------------------< delete_rows >----------------------------
702 procedure delete_rows
703 (p_transaction_id in number
704 ) is
705 begin
706 delete
707 from pay_pss_transaction_steps
708 where transaction_id = p_transaction_id;
709 end delete_rows;
710 --
711 end pay_pss_tx_steps_pkg;