[Home] [Help]
PACKAGE: APPS.PAY_JP_PROCESS_CMI_SS
Source
1 package pay_jp_process_cmi_ss authid current_user as
2 /* $Header: pyjpcmis.pkh 120.1 2006/01/15 18:17 keyazawa noship $ */
3 --
4 g_transaction_step_id number;
5 --
6 type t_txn_value_rec is record(
7 name hr_api_transaction_values.name%type,
8 datatype hr_api_transaction_values.datatype%type,
9 varchar2_value hr_api_transaction_values.varchar2_value%type,
10 date_value hr_api_transaction_values.date_value%type,
11 number_value hr_api_transaction_values.number_value%type);
12 --
13 type t_txn_value_tbl is table of t_txn_value_rec index by binary_integer;
14 --
15 g_txn_value_tbl t_txn_value_tbl;
16 --
17 -- ----------------------------------------------------------------------------
18 -- |----------------------------< calc_car_amount >----------------------------|
19 -- ----------------------------------------------------------------------------
20 -- {Start Of Comments}
21 --
22 -- Description:
23 -- This procedure calculates the amount of commutation information for
24 -- traffic tool.
25 --
26 -- Pre-Requisities:
27 -- N/A
28 --
29 -- In Parameters:
30 -- p_business_group_id number
31 -- p_assignment_id number
32 -- p_effective_date date
33 -- p_attribute_category varchar2 default null
34 -- p_attribute1 - 20 varchar2 default null
35 -- p_means_code varchar2 default null
36 -- p_vehicle_info_id number default null
37 -- p_period_code varchar2 default null
38 -- p_distance number default null
39 -- p_fuel_cost_code varchar2 default null
40 -- p_amount number default null
41 -- p_parking_fees number default null
42 -- p_equivalent_cost number default null
43 -- p_pay_start_month varchar2 default null
44 -- p_pay_end_month varchar2 default null
45 -- p_si_start_month_code varchar2 default null
46 -- p_update_date date default null
47 -- p_update_reason_code varchar2 default null
48 -- p_comments varchar2 default null
49 --
50 -- Out Parameters:
51 -- p_new_car_amount nocopy number
52 -- p_val_returned nocopy number
53 -- p_error_message nocopy long
54 --
55 -- Post Success:
56 -- The amount will be calculated.
57 --
58 -- Post Failure:
59 -- The amount will not be calculated and an error will be raised.
60 --
61 -- Developer Implementation Notes:
62 -- N/A
63 --
64 -- Access Status:
65 -- Public
66 --
67 -- {End Of Comments}
68 -------------------------------------------------------------------------------
69 procedure calc_car_amount
70 (
71 p_business_group_id in number,
72 p_assignment_id in number,
73 p_effective_date in date,
74 --
75 p_attribute_category in varchar2 default null,
76 p_attribute1 in varchar2 default null,
77 p_attribute2 in varchar2 default null,
78 p_attribute3 in varchar2 default null,
79 p_attribute4 in varchar2 default null,
80 p_attribute5 in varchar2 default null,
81 p_attribute6 in varchar2 default null,
82 p_attribute7 in varchar2 default null,
83 p_attribute8 in varchar2 default null,
84 p_attribute9 in varchar2 default null,
85 p_attribute10 in varchar2 default null,
86 p_attribute11 in varchar2 default null,
87 p_attribute12 in varchar2 default null,
88 p_attribute13 in varchar2 default null,
89 p_attribute14 in varchar2 default null,
90 p_attribute15 in varchar2 default null,
91 p_attribute16 in varchar2 default null,
92 p_attribute17 in varchar2 default null,
93 p_attribute18 in varchar2 default null,
94 p_attribute19 in varchar2 default null,
95 p_attribute20 in varchar2 default null,
96 --
97 p_means_code in varchar2 default null,
98 p_vehicle_info_id in number default null,
99 p_period_code in varchar2 default null,
100 p_distance in number default null,
101 p_fuel_cost_code in varchar2 default null,
102 p_amount in number default null,
103 p_parking_fees in number default null,
104 p_equivalent_cost in number default null,
105 p_pay_start_month in varchar2 default null,
106 p_pay_end_month in varchar2 default null,
107 p_si_start_month_code in varchar2 default null,
108 p_update_date in date default null,
109 p_update_reason_code in varchar2 default null,
110 p_comments in varchar2 default null,
111 --
112 p_new_car_amount out nocopy number,
113 p_val_returned out nocopy number,
114 --
115 p_error_message out nocopy long
116 --
117 );
118 --
119 -- ----------------------------------------------------------------------------
120 -- |-----------------------< set_train_transaction_step >----------------------|
121 -- ----------------------------------------------------------------------------
122 -- {Start Of Comments}
123 --
124 -- Description:
125 -- This procedure creates a transaction step for transportation information.
126 --
127 -- Pre-Requisities:
128 -- N/A
129 --
130 -- In Parameters:
131 -- p_item_type varchar2
132 -- p_item_key varchar2
133 -- p_activity_id number
134 -- p_login_person_id number
135 -- p_commutation_type varchar2
136 -- p_action_type varchar2
137 -- p_effective_date date default null
138 -- p_date_track_option varchar2 default null
139 -- p_element_entry_id number default null
140 -- p_business_group_id number default null
141 -- p_assignment_id number default null
142 -- p_element_link_id number default null
143 -- p_entry_type number default null
144 -- p_object_version_number number default null
145 -- p_attribute_category varchar2 default null
146 -- p_attribute1 - 20 varchar2 default null
147 -- p_input_value_id1 - 13 number default null
148 -- p_means_code varchar2 default null
149 -- p_departure_place varchar2 default null
150 -- p_arrival_place varchar2 default null
151 -- p_via varchar2 default null
152 -- p_period_code varchar2 default null
153 -- p_payment_option_code varchar2 default null
154 -- p_amount number default null
155 -- p_pay_start_month varchar2 default null
156 -- p_pay_end_month varchar2 default null
157 -- p_si_start_month_code varchar2 default null
158 -- p_update_date date default null
159 -- p_update_reason_code varchar2 default null
160 -- p_comments varchar2 default null
161 --
162 -- Out Patameters:
163 -- p_error_message nocopy long
164 --
165 -- Post Success:
166 -- The transaction step will be created.
167 --
168 -- Post Failure:
169 -- The transaction step will no be created and an error will be raised.
170 --
171 -- Developer Implementation Notes:
172 -- N/A
173 --
174 -- Access Status:
175 -- Public
176 --
177 -- {End Of Comments}
178 -------------------------------------------------------------------------------
179 procedure set_train_transaction_step
180 (
181 --
182 p_item_type in varchar2,
183 p_item_key in varchar2,
184 p_activity_id in number,
185 p_login_person_id in number,
186 --
187 p_action_type in varchar2,
188 p_effective_date in date default null,
189 p_date_track_option in varchar2 default null,
190 p_element_entry_id in number default null,
191 p_business_group_id in number default null,
192 p_assignment_id in number default null,
193 p_element_link_id in number default null,
194 p_entry_type in varchar2 default null,
195 p_object_version_number in number default null,
196 --
197 p_attribute_category in varchar2 default null,
198 p_attribute1 in varchar2 default null,
199 p_attribute2 in varchar2 default null,
200 p_attribute3 in varchar2 default null,
201 p_attribute4 in varchar2 default null,
202 p_attribute5 in varchar2 default null,
203 p_attribute6 in varchar2 default null,
204 p_attribute7 in varchar2 default null,
205 p_attribute8 in varchar2 default null,
206 p_attribute9 in varchar2 default null,
207 p_attribute10 in varchar2 default null,
208 p_attribute11 in varchar2 default null,
209 p_attribute12 in varchar2 default null,
210 p_attribute13 in varchar2 default null,
211 p_attribute14 in varchar2 default null,
212 p_attribute15 in varchar2 default null,
213 p_attribute16 in varchar2 default null,
214 p_attribute17 in varchar2 default null,
215 p_attribute18 in varchar2 default null,
216 p_attribute19 in varchar2 default null,
217 p_attribute20 in varchar2 default null,
218 --
219 p_input_value_id1 in number default null,
220 p_input_value_id2 in number default null,
221 p_input_value_id3 in number default null,
222 p_input_value_id4 in number default null,
223 p_input_value_id5 in number default null,
224 p_input_value_id6 in number default null,
225 p_input_value_id7 in number default null,
226 p_input_value_id8 in number default null,
227 p_input_value_id9 in number default null,
228 p_input_value_id10 in number default null,
229 p_input_value_id11 in number default null,
230 p_input_value_id12 in number default null,
231 p_input_value_id13 in number default null,
232 --
233 p_means_code in varchar2 default null,
234 p_departure_place in varchar2 default null,
235 p_arrival_place in varchar2 default null,
236 p_via in varchar2 default null,
237 p_period_code in varchar2 default null,
238 p_payment_option_code in varchar2 default null,
239 p_amount in number default null,
240 p_pay_start_month in varchar2 default null,
241 p_pay_end_month in varchar2 default null,
242 p_si_start_month_code in varchar2 default null,
243 p_update_date in date default null,
244 p_update_reason_code in varchar2 default null,
245 p_comments in varchar2 default null,
246 --
247 p_error_message out nocopy long
248 --
249 );
250 --
251 -- ----------------------------------------------------------------------------
252 -- |------------------------< set_car_transaction_step >-----------------------|
253 -- ----------------------------------------------------------------------------
254 -- {Start Of Comments}
255 --
256 -- Description:
257 -- This procedure creates a transaction step for traffic tools information.
258 --
259 -- Pre-Requisities:
260 -- N/A
261 --
262 -- In Parameters:
263 -- p_item_type varchar2
264 -- p_item_key varchar2
265 -- p_activity_id number
266 -- p_login_person_id number
267 -- p_commutation_type varchar2
268 -- p_action_type varchar2
269 -- p_effective_date date default null
270 -- p_date_track_option varchar2 default null
271 -- p_element_entry_id number default null
272 -- p_business_group_id number default null
273 -- p_assignment_id number default null
274 -- p_element_link_id number default null
275 -- p_entry_type number default null
276 -- p_object_version_number number default null
277 -- p_attribute_category varchar2 default null
278 -- p_attribute1 - 20 varchar2 default null
279 -- p_input_value_id1 - 14 number default null
283 -- p_distance number default null
280 -- p_means_code varchar2 default null
281 -- p_vehicle_info_id number default null
282 -- p_period_code varchar2 default null
284 -- p_fuel_cost_code varchar2 default null
285 -- p_amount number default null
286 -- p_parking_fees number default null
287 -- p_equivalent_cost number default null
288 -- p_pay_start_month varchar2 default null
289 -- p_pay_end_month varchar2 default null
290 -- p_si_start_month_code varchar2 default null
291 -- p_update_date date default null
292 -- p_update_reason_code varchar2 default null
293 -- p_comments varchar2 default null
294 --
295 -- Out Patameters:
296 -- p_error_message nocopy long
297 --
298 -- Post Success:
299 -- The transaction step will be created.
300 --
301 -- Post Failure:
302 -- The transaction step will no be created and an error will be raised.
303 --
304 -- Developer Implementation Notes:
305 -- N/A
306 --
307 -- Access Status:
308 -- Public
309 --
310 -- {End Of Comments}
311 -------------------------------------------------------------------------------
312 procedure set_car_transaction_step
313 (
314 --
315 p_item_type in varchar2,
316 p_item_key in varchar2,
317 p_activity_id in number,
318 p_login_person_id in number,
319 --
320 p_action_type in varchar2,
321 p_effective_date in date default null,
322 p_date_track_option in varchar2 default null,
323 p_element_entry_id in number default null,
324 p_business_group_id in number default null,
325 p_assignment_id in number default null,
326 p_element_link_id in number default null,
327 p_entry_type in varchar2 default null,
328 p_object_version_number in number default null,
329 --
330 p_attribute_category in varchar2 default null,
331 p_attribute1 in varchar2 default null,
332 p_attribute2 in varchar2 default null,
333 p_attribute3 in varchar2 default null,
334 p_attribute4 in varchar2 default null,
335 p_attribute5 in varchar2 default null,
336 p_attribute6 in varchar2 default null,
337 p_attribute7 in varchar2 default null,
338 p_attribute8 in varchar2 default null,
339 p_attribute9 in varchar2 default null,
340 p_attribute10 in varchar2 default null,
341 p_attribute11 in varchar2 default null,
342 p_attribute12 in varchar2 default null,
343 p_attribute13 in varchar2 default null,
344 p_attribute14 in varchar2 default null,
345 p_attribute15 in varchar2 default null,
346 p_attribute16 in varchar2 default null,
347 p_attribute17 in varchar2 default null,
348 p_attribute18 in varchar2 default null,
349 p_attribute19 in varchar2 default null,
350 p_attribute20 in varchar2 default null,
351 --
352 p_input_value_id1 in number default null,
353 p_input_value_id2 in number default null,
354 p_input_value_id3 in number default null,
355 p_input_value_id4 in number default null,
356 p_input_value_id5 in number default null,
357 p_input_value_id6 in number default null,
358 p_input_value_id7 in number default null,
359 p_input_value_id8 in number default null,
360 p_input_value_id9 in number default null,
361 p_input_value_id10 in number default null,
362 p_input_value_id11 in number default null,
363 p_input_value_id12 in number default null,
364 p_input_value_id13 in number default null,
365 p_input_value_id14 in number default null,
366 --
367 p_means_code in varchar2 default null,
368 p_vehicle_info_id in number default null,
369 p_period_code in varchar2 default null,
370 p_distance in number default null,
371 p_fuel_cost_code in varchar2 default null,
372 p_amount in number default null,
373 p_parking_fees in number default null,
374 p_equivalent_cost in number default null,
375 p_pay_start_month in varchar2 default null,
376 p_pay_end_month in varchar2 default null,
377 p_si_start_month_code in varchar2 default null,
378 p_update_date in date default null,
379 p_update_reason_code in varchar2 default null,
380 p_comments in varchar2 default null,
381 --
382 p_error_message out nocopy long
383 --
384 );
385 --
386 -- ----------------------------------------------------------------------------
387 -- |---------------------------< create_train_entry >--------------------------|
388 -- ----------------------------------------------------------------------------
389 -- {Start Of Comments}
390 --
391 -- Description:
392 -- This procedure creates an element entry for transportation information.
393 --
394 -- Pre-Requisities:
395 -- N/A
396 --
397 -- In Parameters:
398 -- p_validate number default 0
399 -- p_effective_date date
400 -- p_business_group_id number
401 -- p_assignment_id number
405 -- p_attribute1 - 20 varchar2 default null
402 -- p_element_link_id number
403 -- p_entry_type varchar2
404 -- p_attribute_category varchar2 default null
406 -- p_input_value_id1 - 13 number default null
407 -- p_means_code varchar2 default null
408 -- p_departure_place varchar2 default null
409 -- p_arrival_place varchar2 default null
410 -- p_via varchar2 default null
411 -- p_period_code varchar2 default null
412 -- p_payment_option_code varchar2 default null
413 -- p_amount number default null
414 -- p_pay_start_month varchar2 default null
415 -- p_pay_end_month varchar2 default null
416 -- p_si_start_month_code varchar2 default null
417 -- p_update_date date default null
418 -- p_update_reason_code varchar2 default null
419 -- p_comments varchar2 default null
420 --
421 -- Out Parameters:
422 -- p_error_message long
423 --
424 -- Post Success:
425 -- The element entry will be created.
426 --
427 -- Post Failure:
428 -- The element entry will no be created and an error will be raised.
429 --
430 -- Developer Implementation Notes:
431 -- N/A
432 --
433 -- Access Status:
434 -- Public
435 --
436 -- {End Of Comments}
437 -------------------------------------------------------------------------------
438 procedure create_train_entry
439 (
440 --
441 p_validate in number default 0,
442 --
443 p_effective_date in date,
444 p_business_group_id in number,
445 p_assignment_id in number,
446 p_element_link_id in number,
447 p_entry_type in varchar2,
448 --
449 p_attribute_category in varchar2 default null,
450 p_attribute1 in varchar2 default null,
451 p_attribute2 in varchar2 default null,
452 p_attribute3 in varchar2 default null,
453 p_attribute4 in varchar2 default null,
454 p_attribute5 in varchar2 default null,
455 p_attribute6 in varchar2 default null,
456 p_attribute7 in varchar2 default null,
457 p_attribute8 in varchar2 default null,
458 p_attribute9 in varchar2 default null,
459 p_attribute10 in varchar2 default null,
460 p_attribute11 in varchar2 default null,
461 p_attribute12 in varchar2 default null,
462 p_attribute13 in varchar2 default null,
463 p_attribute14 in varchar2 default null,
464 p_attribute15 in varchar2 default null,
465 p_attribute16 in varchar2 default null,
466 p_attribute17 in varchar2 default null,
467 p_attribute18 in varchar2 default null,
468 p_attribute19 in varchar2 default null,
469 p_attribute20 in varchar2 default null,
470 --
471 p_input_value_id1 in number default null,
472 p_input_value_id2 in number default null,
473 p_input_value_id3 in number default null,
474 p_input_value_id4 in number default null,
475 p_input_value_id5 in number default null,
476 p_input_value_id6 in number default null,
477 p_input_value_id7 in number default null,
478 p_input_value_id8 in number default null,
479 p_input_value_id9 in number default null,
480 p_input_value_id10 in number default null,
481 p_input_value_id11 in number default null,
482 p_input_value_id12 in number default null,
483 p_input_value_id13 in number default null,
484 --
485 p_means_code in varchar2 default null,
486 p_departure_place in varchar2 default null,
487 p_arrival_place in varchar2 default null,
488 p_via in varchar2 default null,
489 p_period_code in varchar2 default null,
490 p_payment_option_code in varchar2 default null,
491 p_amount in number default null,
492 p_pay_start_month in varchar2 default null,
493 p_pay_end_month in varchar2 default null,
494 p_si_start_month_code in varchar2 default null,
495 p_update_date in date default null,
496 p_update_reason_code in varchar2 default null,
497 p_comments in varchar2 default null,
498 --
499 p_error_message out nocopy long
500 --
501 );
502 --
503 -- ----------------------------------------------------------------------------
504 -- |---------------------------< update_train_entry >--------------------------|
505 -- ----------------------------------------------------------------------------
506 -- {Start Of Comments}
507 --
508 -- Description:
509 -- This procedure updates an element entry for transportation information.
510 --
511 -- Pre-Requisities:
512 -- N/A
513 --
514 -- In Parameters:
515 -- p_validate number default 0
516 -- p_datetrack_update_mode varchar2
517 -- p_effective_date date
518 -- p_business_group_id number
519 -- p_element_entry_id number
520 -- p_attribute_category varchar2 default null
521 -- p_attribute1 - 20 varchar2 default null
522 -- p_input_value_id1 - 13 number default null
523 -- p_means_code varchar2 default null
524 -- p_departure_place varchar2 default null
525 -- p_arrival_place varchar2 default null
526 -- p_via varchar2 default null
530 -- p_pay_start_month varchar2 default null
527 -- p_period_code varchar2 default null
528 -- p_payment_option_code varchar2 default null
529 -- p_amount number default null
531 -- p_pay_end_month varchar2 default null
532 -- p_si_start_month_code varchar2 default null
533 -- p_update_date date default null
534 -- p_update_reason_code varchar2 default null
535 -- p_comments varchar2 default null
536 --
537 -- Out Parameters:
538 -- p_error_message long
539 --
540 -- In Out Parameters:
541 -- p_object_version_number number
542 --
543 -- Post Success:
544 -- The element entry will be updated.
545 --
546 -- Post Failure:
547 -- The element entry will no be updated and an error will be raised.
548 --
549 -- Developer Implementation Notes:
550 -- N/A
551 --
552 -- Access Status:
553 -- Public
554 --
555 -- {End Of Comments}
556 -------------------------------------------------------------------------------
557 procedure update_train_entry
558 (
559 p_validate in number default 0,
560 --
561 p_datetrack_update_mode in varchar2,
562 p_effective_date in date,
563 p_business_group_id in number,
564 p_element_entry_id in number,
565 p_object_version_number in out nocopy number,
566 --
567 p_attribute_category in varchar2 default null,
568 p_attribute1 in varchar2 default null,
569 p_attribute2 in varchar2 default null,
570 p_attribute3 in varchar2 default null,
571 p_attribute4 in varchar2 default null,
572 p_attribute5 in varchar2 default null,
573 p_attribute6 in varchar2 default null,
574 p_attribute7 in varchar2 default null,
575 p_attribute8 in varchar2 default null,
576 p_attribute9 in varchar2 default null,
577 p_attribute10 in varchar2 default null,
578 p_attribute11 in varchar2 default null,
579 p_attribute12 in varchar2 default null,
580 p_attribute13 in varchar2 default null,
581 p_attribute14 in varchar2 default null,
582 p_attribute15 in varchar2 default null,
583 p_attribute16 in varchar2 default null,
584 p_attribute17 in varchar2 default null,
585 p_attribute18 in varchar2 default null,
586 p_attribute19 in varchar2 default null,
587 p_attribute20 in varchar2 default null,
588 --
589 p_input_value_id1 in number default null,
590 p_input_value_id2 in number default null,
591 p_input_value_id3 in number default null,
592 p_input_value_id4 in number default null,
593 p_input_value_id5 in number default null,
594 p_input_value_id6 in number default null,
595 p_input_value_id7 in number default null,
596 p_input_value_id8 in number default null,
597 p_input_value_id9 in number default null,
598 p_input_value_id10 in number default null,
599 p_input_value_id11 in number default null,
600 p_input_value_id12 in number default null,
601 p_input_value_id13 in number default null,
602 --
603 p_means_code in varchar2 default null,
604 p_departure_place in varchar2 default null,
605 p_arrival_place in varchar2 default null,
606 p_via in varchar2 default null,
607 p_period_code in varchar2 default null,
608 p_payment_option_code in varchar2 default null,
609 p_amount in number default null,
610 p_pay_start_month in varchar2 default null,
611 p_pay_end_month in varchar2 default null,
612 p_si_start_month_code in varchar2 default null,
613 p_update_date in date default null,
614 p_update_reason_code in varchar2 default null,
615 p_comments in varchar2 default null,
616 --
617 p_error_message out nocopy long
618 --
619 );
620 --
621 -- ----------------------------------------------------------------------------
622 -- |----------------------------< create_car_entry >---------------------------|
623 -- ----------------------------------------------------------------------------
624 -- {Start Of Comments}
625 --
626 -- Description:
627 -- This procedure creates an element entry for traffic tools information.
628 --
629 -- Pre-Requisities:
630 -- N/A
631 --
632 -- In Parameters:
633 -- p_validate number default 0
634 -- p_effective_date date
635 -- p_business_group_id number
636 -- p_assignment_id number
637 -- p_element_link_id number
638 -- p_entry_type varchar2
639 -- p_attribute_category varchar2 default null
640 -- p_attribute1 - 20 varchar2 default null
641 -- p_input_value_id1 - 14 number default null
642 -- p_means_code varchar2 default null
643 -- p_vehicle_info_id number default null
644 -- p_period_code varchar2 default null
645 -- p_distance number default null
646 -- p_fuel_cost_code varchar2 default null
647 -- p_amount number default null
648 -- p_parking_fees number default null
649 -- p_equivalent_cost number default null
653 -- p_update_date date default null
650 -- p_pay_start_month varchar2 default null
651 -- p_pay_end_month varchar2 default null
652 -- p_si_start_month_code varchar2 default null
654 -- p_update_reason_code varchar2 default null
655 -- p_comments varchar2 default null
656 --
657 -- Out Parameters:
658 -- p_error_message long
659 --
660 -- Post Success:
661 -- The element entry will be created.
662 --
663 -- Post Failure:
664 -- The element entry will no be created and an error will be raised.
665 --
666 -- Developer Implementation Notes:
667 -- N/A
668 --
669 -- Access Status:
670 -- Public
671 --
672 -- {End Of Comments}
673 -------------------------------------------------------------------------------
674 procedure create_car_entry
675 (
676 --
677 p_validate in number default 0,
678 --
679 p_effective_date in date,
680 p_business_group_id in number,
681 p_assignment_id in number,
682 p_element_link_id in number,
683 p_entry_type in varchar2,
684 --
685 p_attribute_category in varchar2 default null,
686 p_attribute1 in varchar2 default null,
687 p_attribute2 in varchar2 default null,
688 p_attribute3 in varchar2 default null,
689 p_attribute4 in varchar2 default null,
690 p_attribute5 in varchar2 default null,
691 p_attribute6 in varchar2 default null,
692 p_attribute7 in varchar2 default null,
693 p_attribute8 in varchar2 default null,
694 p_attribute9 in varchar2 default null,
695 p_attribute10 in varchar2 default null,
696 p_attribute11 in varchar2 default null,
697 p_attribute12 in varchar2 default null,
698 p_attribute13 in varchar2 default null,
699 p_attribute14 in varchar2 default null,
700 p_attribute15 in varchar2 default null,
701 p_attribute16 in varchar2 default null,
702 p_attribute17 in varchar2 default null,
703 p_attribute18 in varchar2 default null,
704 p_attribute19 in varchar2 default null,
705 p_attribute20 in varchar2 default null,
706 --
707 p_input_value_id1 in number default null,
708 p_input_value_id2 in number default null,
709 p_input_value_id3 in number default null,
710 p_input_value_id4 in number default null,
711 p_input_value_id5 in number default null,
712 p_input_value_id6 in number default null,
713 p_input_value_id7 in number default null,
714 p_input_value_id8 in number default null,
715 p_input_value_id9 in number default null,
716 p_input_value_id10 in number default null,
717 p_input_value_id11 in number default null,
718 p_input_value_id12 in number default null,
719 p_input_value_id13 in number default null,
720 p_input_value_id14 in number default null,
721 --
722 p_means_code in varchar2 default null,
723 p_vehicle_info_id in number default null,
724 p_period_code in varchar2 default null,
725 p_distance in number default null,
726 p_fuel_cost_code in varchar2 default null,
727 p_amount in number default null,
728 p_parking_fees in number default null,
729 p_equivalent_cost in number default null,
730 p_pay_start_month in varchar2 default null,
731 p_pay_end_month in varchar2 default null,
732 p_si_start_month_code in varchar2 default null,
733 p_update_date in date default null,
734 p_update_reason_code in varchar2 default null,
735 p_comments in varchar2 default null,
736 --
737 p_error_message out nocopy long
738 --
739 );
740 --
741 -- ----------------------------------------------------------------------------
742 -- |----------------------------< update_car_entry >---------------------------|
743 -- ----------------------------------------------------------------------------
744 -- {Start Of Comments}
745 --
746 -- Description:
747 -- This procedure updates an element entry for trafic tools information.
748 --
749 -- Pre-Requisities:
750 -- N/A
751 --
752 -- In Parameters:
753 -- p_validate number default 0
754 -- p_datetrack_update_mode varchar2
755 -- p_effective_date date
756 -- p_business_group_id number
757 -- p_element_entry_id number
758 -- p_attribute_category varchar2 default null
759 -- p_attribute1 - 20 varchar2 default null
760 -- p_input_value_id1 - 14 number default null
761 -- p_means_code varchar2 default null
762 -- p_vehicle_info_id number default null
763 -- p_period_code varchar2 default null
764 -- p_distance number default null
765 -- p_fuel_cost_code varchar2 default null
766 -- p_amount number default null
767 -- p_parking_fees number default null
768 -- p_equivalent_cost number default null
769 -- p_pay_start_month varchar2 default null
770 -- p_pay_end_month varchar2 default null
771 -- p_si_start_month_code varchar2 default null
772 -- p_update_date date default null
773 -- p_update_reason_code varchar2 default null
777 -- p_error_message long
774 -- p_comments varchar2 default null
775 --
776 -- Out Parameters:
778 --
779 -- In Out Parameters:
780 -- p_object_version_number number
781 --
782 -- Post Success:
783 -- The element entry will be updated.
784 --
785 -- Post Failure:
786 -- The element entry will no be updated and an error will be raised.
787 --
788 -- Developer Implementation Notes:
789 -- N/A
790 --
791 -- Access Status:
792 -- Public
793 --
794 -- {End Of Comments}
795 -------------------------------------------------------------------------------
796 procedure update_car_entry
797 (
798 --
799 p_validate in number default 0,
800 --
801 p_datetrack_update_mode in varchar2,
802 p_effective_date in date,
803 p_business_group_id in number,
804 p_element_entry_id in number,
805 p_object_version_number in out nocopy number,
806 --
807 p_attribute_category in varchar2 default null,
808 p_attribute1 in varchar2 default null,
809 p_attribute2 in varchar2 default null,
810 p_attribute3 in varchar2 default null,
811 p_attribute4 in varchar2 default null,
812 p_attribute5 in varchar2 default null,
813 p_attribute6 in varchar2 default null,
814 p_attribute7 in varchar2 default null,
815 p_attribute8 in varchar2 default null,
816 p_attribute9 in varchar2 default null,
817 p_attribute10 in varchar2 default null,
818 p_attribute11 in varchar2 default null,
819 p_attribute12 in varchar2 default null,
820 p_attribute13 in varchar2 default null,
821 p_attribute14 in varchar2 default null,
822 p_attribute15 in varchar2 default null,
823 p_attribute16 in varchar2 default null,
824 p_attribute17 in varchar2 default null,
825 p_attribute18 in varchar2 default null,
826 p_attribute19 in varchar2 default null,
827 p_attribute20 in varchar2 default null,
828 --
829 p_input_value_id1 in number default null,
830 p_input_value_id2 in number default null,
831 p_input_value_id3 in number default null,
832 p_input_value_id4 in number default null,
833 p_input_value_id5 in number default null,
834 p_input_value_id6 in number default null,
835 p_input_value_id7 in number default null,
836 p_input_value_id8 in number default null,
837 p_input_value_id9 in number default null,
838 p_input_value_id10 in number default null,
839 p_input_value_id11 in number default null,
840 p_input_value_id12 in number default null,
841 p_input_value_id13 in number default null,
842 p_input_value_id14 in number default null,
843 --
844 p_means_code in varchar2 default null,
845 p_vehicle_info_id in number default null,
846 p_period_code in varchar2 default null,
847 p_distance in number default null,
848 p_fuel_cost_code in varchar2 default null,
849 p_amount in number default null,
850 p_parking_fees in number default null,
851 p_equivalent_cost in number default null,
852 p_pay_start_month in varchar2 default null,
853 p_pay_end_month in varchar2 default null,
854 p_si_start_month_code in varchar2 default null,
855 p_update_date in date default null,
856 p_update_reason_code in varchar2 default null,
857 p_comments in varchar2 default null,
858 --
859 p_error_message out nocopy long
860 --
861 );
862 --
863 -- ----------------------------------------------------------------------------
864 -- |------------------------------< delete_entry >-----------------------------|
865 -- ----------------------------------------------------------------------------
866 -- {Start Of Comments}
867 --
868 -- Description:
869 -- This procedure deletes an element entry for commutation information.
870 --
871 -- Pre-Requisities:
872 -- N/A
873 --
874 -- In Parameters:
875 -- p_validate number default 0
876 -- p_datetrack_delete_mode varchar2
877 -- p_effective_date date
878 -- p_element_entry_id number
879 --
880 -- Out Parameters:
881 -- p_error_message long
882 --
883 -- In Out Parameters:
884 -- p_object_version_number number
885 --
886 -- Post Success:
887 -- The element entry will be deleted.
888 --
889 -- Post Failure:
890 -- The element entry will no be deleted and an error will be raised.
891 --
892 -- Developer Implementation Notes:
893 -- N/A
894 --
895 -- Access Status:
896 -- Public
897 --
898 -- {End Of Comments}
899 -------------------------------------------------------------------------------
900 procedure delete_entry
901 (
902 --
903 p_validate in number default 0,
904 --
905 p_datetrack_delete_mode in varchar2,
906 p_effective_date in date,
907 p_element_entry_id in number,
908 p_object_version_number in out nocopy number,
909 --
910 p_error_message out nocopy long
911 --
912 );
913 --
914 -- ----------------------------------------------------------------------------
915 -- |------------------------------< process_api >-----------------------------|
916 -- ----------------------------------------------------------------------------
917 -- {Start Of Comments}
918 --
919 -- Description:
920 -- This procedure execute create, update or delete commutation information
921 -- APIs depending on the action type.
922 --
923 -- Pre-Requisities:
924 -- Transaction step exists in the database against transaction_step_id
925 -- parameter.
926 --
927 -- In Parameters:
928 -- p_validate boolean default false
929 -- p_transaction_step_id number default null
930 -- p_effective_date varchar2 default null
931 --
932 -- Post Success:
933 -- One of insert, update or delete API will be executed and the record of
934 -- contact extra information will be created, updated or deleted.
935 --
936 -- Post Failure:
937 -- The record of contact extra information will not be created, updated or
938 -- deleted and an error will be raised.
939 --
940 -- Developer Implementation Notes:
941 -- N/A
942 --
943 -- Access Status:
944 -- Public
945 --
946 -- {End Of Comments}
947 -------------------------------------------------------------------------------
948 procedure process_api
949 (
950 p_validate in boolean default false,
951 p_transaction_step_id in number default null,
952 p_effective_date in varchar2 default null
953 );
954 --
955 function get_txn_value_char(
956 p_transaction_step_id in number,
957 p_name in varchar2)
958 return varchar2;
959 --
960 function get_txn_value_date(
961 p_transaction_step_id in number,
962 p_name in varchar2)
963 return date;
964 --
965 function get_txn_value_number(
966 p_transaction_step_id in number,
967 p_name in varchar2)
968 return number;
969 --
970 end pay_jp_process_cmi_ss;