1 PACKAGE AP_WEB_AUDIT_LIST_PVT AS
2 /* $Header: apwvalls.pls 120.3 2006/05/04 07:49:16 sbalaji noship $ */
3
4 /*==================================================*
5 | Type definitions for structures used in the API |
6 *==================================================*/
7 TYPE Date_Range_Type IS RECORD
8 (start_date DATE,
9 end_date DATE,
10 audit_reason_code VARCHAR2(30)
11 );
12
13 TYPE range_table IS TABLE OF Date_Range_Type INDEX BY BINARY_INTEGER;
14
15 /*============================================*
16 | Definitions for constants used in the API |
17 *============================================*/
18 c_min_date CONSTANT DATE DEFAULT to_date('1','J'); -- 01-Jan-4712 BC
19 c_max_date CONSTANT DATE DEFAULT to_date('3442447','J'); -- 31-DEC-4712 AD
20 -- Supported after oracle 8.0 c_max_date DATE := to_date('5373484','J'); -- 31-DEC-9999
21
22 c_termination CONSTANT VARCHAR2(11) DEFAULT 'TERMINATION';
23 c_loa CONSTANT VARCHAR2(16) DEFAULT 'LEAVE_OF_ABSENCE';
24
25 /*========================================================================
26 | PUBLIC FUNCTION includes
27 |
28 | DESCRIPTION
29 | This function detects whether a date range includes a specific date.
30 | Equal dates are considered to be included.
31 |
32 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
33 | audit list API
34 |
35 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
36 |
37 | RETURNS
38 | Boolean indicating whether the date range includes the date.
39 |
40 | PARAMETERS
41 | p_date1_rec IN Date range which is checked.
42 | p_date2 IN Date which is checked.
43 |
44 | MODIFICATION HISTORY
45 | Date Author Description of Changes
46 | 28-Jun-2004 J Rautiainen Created
47 |
48 *=======================================================================*/
49 FUNCTION includes(p_date1_rec IN Date_Range_Type,
50 p_date2 IN DATE) RETURN BOOLEAN;
51
52 /*========================================================================
53 | PUBLIC FUNCTION includes
54 |
55 | DESCRIPTION
56 | This function detects whether a date range includes another date range.
57 | Equal dates are considered to be included.
58 |
59 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
60 | audit list API
61 |
62 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
63 |
64 | RETURNS
65 | Boolean indicating whether the date range includes the other date range.
66 |
67 | PARAMETERS
68 | p_date1_rec IN Date range which is checked whether includes.
69 | p_date2_rec IN Date range which is checked whether included.
70 |
71 | MODIFICATION HISTORY
72 | Date Author Description of Changes
73 | 28-Jun-2004 J Rautiainen Created
74 |
75 *=======================================================================*/
76 FUNCTION includes(p_date1_rec IN Date_Range_Type,
77 p_date2_rec IN Date_Range_Type) RETURN BOOLEAN;
78
79 /*========================================================================
80 | PUBLIC FUNCTION continuous
81 |
82 | DESCRIPTION
83 | This function detects whether two date ranges are continuous eg.
84 | whether the later date range continues immediately after the other.
85 |
86 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
87 | audit list API
88 |
89 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
90 |
91 | RETURNS
92 | Boolean indicating whether the date ranges are continuous.
93 |
94 | PARAMETERS
95 | p_date1_rec IN Date range which is checked.
96 | p_date2_rec IN Date range which is checked.
97 |
98 | MODIFICATION HISTORY
99 | Date Author Description of Changes
100 | 28-Jun-2004 J Rautiainen Created
101 |
102 *=======================================================================*/
103 FUNCTION continuous(p_date1_rec IN Date_Range_Type,
104 p_date2_rec IN Date_Range_Type) RETURN BOOLEAN;
105
106 /*========================================================================
107 | PUBLIC FUNCTION open_date
108 |
109 | DESCRIPTION
110 | This function detects whether a date is a open date eg. NULL which is
111 | considered as infinite.
112 |
113 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
114 | audit list API
115 |
116 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
117 |
118 | RETURNS
119 | Boolean indicating whether the date is a open date.
120 |
121 | PARAMETERS
122 | p_date1 IN Date to be checked.
123 |
124 | MODIFICATION HISTORY
125 | Date Author Description of Changes
126 | 28-Jun-2004 J Rautiainen Created
127 |
128 *=======================================================================*/
129 FUNCTION open_date(p_date IN DATE) RETURN BOOLEAN;
130
131 /*========================================================================
132 | PUBLIC FUNCTION open_end
133 |
134 | DESCRIPTION
135 | This function detects whether range has a open end date.
136 |
137 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
138 | audit list API
139 |
140 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
141 |
142 | RETURNS
143 | Boolean indicating whether the range has a open end date.
144 |
145 | PARAMETERS
146 | p_date_rec IN Date range to be checked.
147 |
148 | MODIFICATION HISTORY
149 | Date Author Description of Changes
150 | 28-Jun-2004 J Rautiainen Created
151 |
152 *=======================================================================*/
153 FUNCTION open_end(p_date_rec IN Date_Range_Type) RETURN BOOLEAN;
154
155 /*========================================================================
156 | PUBLIC FUNCTION start_end
157 |
158 | DESCRIPTION
159 | This function detects whether range has a open start date.
160 |
161 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
162 | audit list API
163 |
164 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
165 |
166 | RETURNS
167 | Boolean indicating whether the range has a open start date.
168 |
169 | PARAMETERS
170 | p_date_rec IN Date range to be checked.
171 |
172 | MODIFICATION HISTORY
173 | Date Author Description of Changes
174 | 28-Jun-2004 J Rautiainen Created
175 |
176 *=======================================================================*/
177 FUNCTION open_start(p_date_rec IN Date_Range_Type) RETURN BOOLEAN;
178
179 /*========================================================================
180 | PUBLIC FUNCTION overlap
181 |
182 | DESCRIPTION
183 | This function detects whether two ranges overlap each other.
184 |
185 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
186 | audit list API
187 |
188 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
189 |
190 | RETURNS
191 | Boolean indicating whether the two ranges overlap each other.
192 |
193 | PARAMETERS
194 | p_date1_rec IN Date range to be checked.
195 | p_date2_rec IN Date range to be checked.
196 |
197 | MODIFICATION HISTORY
198 | Date Author Description of Changes
199 | 28-Jun-2004 J Rautiainen Created
200 |
201 *=======================================================================*/
202 FUNCTION overlap(p_date1_rec IN Date_Range_Type,
203 p_date2_rec IN Date_Range_Type) RETURN BOOLEAN;
204
205 /*========================================================================
206 | PUBLIC FUNCTION gap_between_start_dates
207 |
208 | DESCRIPTION
209 | This function returns the gap between the start dates of two ranges.
210 | Note this is only detected if the first record includes the second.
211 |
212 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
213 | audit list API
214 |
215 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
216 |
217 | RETURNS
218 | Date range for the gap between the start dates.
219 |
220 | PARAMETERS
221 | p_date1_rec IN Date range to be checked.
222 | p_date2_rec IN Date range to be checked.
223 |
224 | MODIFICATION HISTORY
225 | Date Author Description of Changes
226 | 28-Jun-2004 J Rautiainen Created
227 |
228 *=======================================================================*/
229 FUNCTION gap_between_start_dates(p_date1_rec IN Date_Range_Type,
230 p_date2_rec IN Date_Range_Type) RETURN Date_Range_Type;
231
232 /*========================================================================
233 | PUBLIC FUNCTION empty
234 |
235 | DESCRIPTION
236 | This function detects whether a range record is empty.
237 |
238 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
239 | audit list API
240 |
241 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
242 |
243 | RETURNS
244 | Boolean indicating whether the range is empty.
245 |
246 | PARAMETERS
247 | p_date_rec IN Date range to be checked.
248 |
249 | MODIFICATION HISTORY
250 | Date Author Description of Changes
251 | 28-Jun-2004 J Rautiainen Created
252 |
253 *=======================================================================*/
254 FUNCTION empty(p_date_rec IN Date_Range_Type) RETURN BOOLEAN;
255
256 /*========================================================================
257 | PUBLIC FUNCTION equals
258 |
259 | DESCRIPTION
260 | This function detects whether two ranges are equal.
261 |
262 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
263 | audit list API
264 |
265 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
266 |
267 | RETURNS
268 | Boolean indicating whether the ranges are equal.
269 |
270 | PARAMETERS
271 | p_date1_rec IN Date range to be checked.
272 | p_date2_rec IN Date range to be checked.
273 |
274 | MODIFICATION HISTORY
275 | Date Author Description of Changes
276 | 28-Jun-2004 J Rautiainen Created
277 |
278 *=======================================================================*/
279 FUNCTION equals(p_date1_rec IN Date_Range_Type,
280 p_date2_rec IN Date_Range_Type) RETURN BOOLEAN;
281
282 /*========================================================================
283 | PUBLIC FUNCTION before
284 |
285 | DESCRIPTION
286 | This function detects whether a date is before than another date.
287 |
288 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
289 | audit list API
290 |
291 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
292 |
293 | RETURNS
294 | Boolean indicating whether the first date is before the second.
295 |
296 | PARAMETERS
297 | p_date1 IN Date to be checked.
298 | p_date2 IN Date to be checked.
299 |
300 | MODIFICATION HISTORY
301 | Date Author Description of Changes
302 | 28-Jun-2004 J Rautiainen Created
303 |
304 *=======================================================================*/
305 FUNCTION before(p_date1 IN DATE,
306 p_date2 IN DATE) RETURN BOOLEAN;
307
308 /*========================================================================
309 | PUBLIC FUNCTION before
310 |
311 | DESCRIPTION
312 | This function detects whether a date range is before than another
313 | date range.
314 |
315 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
316 | audit list API
317 |
318 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
319 |
320 | RETURNS
321 | Boolean indicating whether the first date range is before the second.
322 |
323 | PARAMETERS
324 | p_date1_rec IN Date range to be checked.
325 | p_date2_rec IN Date range to be checked.
326 |
327 | MODIFICATION HISTORY
328 | Date Author Description of Changes
329 | 28-Jun-2004 J Rautiainen Created
330 |
331 *=======================================================================*/
332 FUNCTION before(p_date1_rec IN Date_Range_Type,
333 p_date2_rec IN Date_Range_Type) RETURN BOOLEAN;
334
335 /*========================================================================
336 | PUBLIC FUNCTION after
337 |
338 | DESCRIPTION
339 | This function detects whether a date is after than another date.
340 |
341 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
342 | audit list API
343 |
344 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
345 |
346 | RETURNS
347 | Boolean indicating whether the first date is after the second.
348 |
349 | PARAMETERS
350 | p_date1 IN Date to be checked.
351 | p_date2 IN Date to be checked.
352 |
353 | MODIFICATION HISTORY
354 | Date Author Description of Changes
355 | 28-Jun-2004 J Rautiainen Created
356 |
357 *=======================================================================*/
358 FUNCTION after(p_date1 IN DATE,
359 p_date2 IN DATE) RETURN BOOLEAN;
360
361 /*========================================================================
362 | PUBLIC FUNCTION after
363 |
364 | DESCRIPTION
365 | This function detects whether a date range is after than another
366 | date range.
367 |
368 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
369 | audit list API
370 |
371 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
372 |
373 | RETURNS
374 | Boolean indicating whether the first date range is after the second.
375 |
376 | PARAMETERS
377 | p_date1_rec IN Date range to be checked.
378 | p_date2_rec IN Date range to be checked.
379 |
380 | MODIFICATION HISTORY
381 | Date Author Description of Changes
382 | 28-Jun-2004 J Rautiainen Created
383 |
384 *=======================================================================*/
385 FUNCTION after(p_date1_rec IN Date_Range_Type,
386 p_date2_rec IN Date_Range_Type) RETURN BOOLEAN;
387
388 /*========================================================================
389 | PUBLIC FUNCTION get_date_range
390 |
391 | DESCRIPTION
392 | This function returns a date range type populated with the values
393 | passed in as parameters.
394 |
395 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
396 | audit list API
397 |
398 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
399 |
400 | RETURNS
401 | Date range type populated with the values passed as parameters.
402 |
403 | PARAMETERS
404 | p_date1 IN Start date of the range.
405 | p_date2 IN End date of the range.
406 | p_audit_reason_code OUT Audit reason for the date range
407 |
408 | MODIFICATION HISTORY
409 | Date Author Description of Changes
413 FUNCTION get_date_range(p_date1 IN DATE,
410 | 28-Jun-2004 J Rautiainen Created
411 |
412 *=======================================================================*/
414 p_date2 IN DATE,
415 p_audit_reason_code IN VARCHAR2) RETURN Date_Range_Type;
416
417 /*========================================================================
418 | PUBLIC FUNCTION get_date_range
419 |
420 | DESCRIPTION
421 | This function returns a date range type populated with the values
422 | passed in as parameters.
423 |
424 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
425 | audit list API
426 |
427 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
428 |
429 | RETURNS
430 | Date range type populated with the values passed as parameters.
431 |
432 | PARAMETERS
433 | p_audit_rec IN Audit record the API was called with.
434 |
435 | MODIFICATION HISTORY
436 | Date Author Description of Changes
437 | 28-Jun-2004 J Rautiainen Created
438 |
439 *=======================================================================*/
440 FUNCTION get_date_range(p_audit_rec IN AP_WEB_AUDIT_LIST_PUB.Audit_Rec_Type) RETURN Date_Range_Type;
441
442 /*========================================================================
443 | PUBLIC PROCEDURE update_audit_list_entry_dates
444 |
445 | DESCRIPTION
446 | This procedure updates a audit list entry data.
447 |
448 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
449 | audit list API
450 |
451 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
452 |
453 | RETURNS
454 | None.
455 |
456 | PARAMETERS
457 | p_auto_audit_id IN Identifier of the record to be updated.
458 | p_start_date IN Start date for the record.
459 | p_end_date IN End date for the record.
460 |
461 | MODIFICATION HISTORY
462 | Date Author Description of Changes
463 | 28-Jun-2004 J Rautiainen Created
464 |
465 *=======================================================================*/
466 PROCEDURE update_audit_list_entry_dates(p_auto_audit_id IN NUMBER,
467 p_start_date IN DATE,
468 p_end_date IN DATE);
469
470 /*========================================================================
471 | PUBLIC PROCEDURE delete_audit_list_entry
472 |
473 | DESCRIPTION
474 | This procedure deletes a given audit list entry.
475 |
476 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
477 | audit list API
478 |
479 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
480 |
481 | RETURNS
482 | None.
483 |
484 | PARAMETERS
485 | p_auto_audit_id IN Identifier of the record to be deleted.
486 |
487 | MODIFICATION HISTORY
488 | Date Author Description of Changes
489 | 28-Jun-2004 J Rautiainen Created
490 |
491 *=======================================================================*/
492 PROCEDURE delete_audit_list_entry(p_auto_audit_id NUMBER);
493
494 /*========================================================================
495 | PUBLIC PROCEDURE insert_to_audit_list
496 |
497 | DESCRIPTION
498 | This procedure inserts date ranges included in a array into the
499 | database.
500 |
501 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
502 | audit list API
503 |
504 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
505 |
506 | RETURNS
507 | None.
508 |
509 | PARAMETERS
510 | p_person_id IN Person to be added.
511 | p_range_table IN Array containing the entries to be created.
512 | p_auto_audit_id OUT Identifier of the new record created, if multiple created returns -1.
513 |
514 | MODIFICATION HISTORY
515 | Date Author Description of Changes
516 | 28-Jun-2004 J Rautiainen Created
517 |
518 *=======================================================================*/
519 PROCEDURE insert_to_audit_list(p_person_id IN NUMBER,
520 p_range_table IN range_table,
521 p_auto_audit_id OUT NOCOPY NUMBER);
522
523 /*========================================================================
524 | PUBLIC PROCEDURE move_existing_entry
525 |
526 | DESCRIPTION
527 | This procedure moves an audit list entry so that it does not overlap
528 | with the new entry.
529 |
530 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
531 | audit list API
532 |
533 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
534 |
535 | RETURNS
536 | None.
537 |
538 | PARAMETERS
539 | p_auto_audit_id IN Identifier of the record to be updated.
540 | p_new_date_range IN The new entry date range.
541 | p_old_date_range IN The old entry date range.
542 |
543 | MODIFICATION HISTORY
544 | Date Author Description of Changes
545 | 28-Jun-2004 J Rautiainen Created
546 |
547 *=======================================================================*/
548 PROCEDURE move_existing_entry(p_auto_audit_id IN NUMBER,
549 p_new_date_range IN Date_Range_Type,
550 p_old_date_range IN Date_Range_Type);
551
552 /*========================================================================
553 | PUBLIC PROCEDURE move_new_entry
554 |
555 | DESCRIPTION
556 | This procedure moves the new entry so that it does not overlap
557 | with the audit list entries.
558 |
559 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
560 | audit list API
561 |
562 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
563 |
564 | RETURNS
565 | None.
566 |
567 | PARAMETERS
568 | p_new_date_range IN The new entry date range.
569 | p_old_date_range IN The old entry date range.
570 |
571 | MODIFICATION HISTORY
572 | Date Author Description of Changes
573 | 28-Jun-2004 J Rautiainen Created
574 |
575 *=======================================================================*/
576 PROCEDURE move_new_entry(p_new_date_range IN OUT NOCOPY Date_Range_Type,
577 p_old_date_range IN Date_Range_Type);
578
579 /*========================================================================
580 | PUBLIC PROCEDURE split_existing_entry
581 |
582 | DESCRIPTION
583 | This procedure adds the new entry in the middle of an existing audit
584 | list entry.
585 |
586 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
587 | audit list API
588 |
589 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
590 |
591 | RETURNS
592 | None.
593 |
594 | PARAMETERS
595 | p_overlap_rec IN The overlapping record.
596 | p_new_date_range IN The new entry date range.
597 | p_old_date_range IN The old entry date range.
598 |
599 | MODIFICATION HISTORY
600 | Date Author Description of Changes
601 | 28-Jun-2004 J Rautiainen Created
602 |
603 *=======================================================================*/
604 PROCEDURE split_existing_entry(p_overlap_rec IN ap_aud_auto_audits%ROWTYPE,
605 p_new_date_range IN Date_Range_Type,
606 p_old_date_range IN Date_Range_Type);
607
608 /*========================================================================
609 | PUBLIC PROCEDURE split_new_entry
610 |
611 | DESCRIPTION
612 | This procedure splits the new entry so that an existing audit list
613 | entry remains in the middle of it.
614 |
615 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
616 | audit list API
617 |
618 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
619 |
620 | RETURNS
621 | None.
622 |
623 | PARAMETERS
624 | p_new_date_range IN The new entry date range.
625 | p_old_date_range IN The old entry date range.
626 | p_range_table IN OUT Array containing the new entries to be created.
627 | p_counter IN OUT Counter storing the count of lines in the array.
628 |
629 | MODIFICATION HISTORY
630 | Date Author Description of Changes
631 | 28-Jun-2004 J Rautiainen Created
632 |
633 *=======================================================================*/
634 PROCEDURE split_new_entry(p_new_date_range IN OUT NOCOPY Date_Range_Type,
635 p_old_date_range IN Date_Range_Type,
636 p_range_table IN OUT NOCOPY range_table,
637 p_counter IN OUT NOCOPY NUMBER);
638
639
640 /*========================================================================
641 | PUBLIC PROCEDURE add_range_to_be_inserted
642 |
643 | DESCRIPTION
647 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
644 | This procedure adds a range to the array used to store the ranges to
645 | be inserted as audit list entries.
646 |
648 | audit list API
649 |
650 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
651 |
652 | RETURNS
653 | None.
654 |
655 | PARAMETERS
656 | p_date_range IN The entry date range.
657 | p_range_table IN OUT Array containing the new entries to be created.
658 | p_counter IN OUT Counter storing the count of lines in the array.
659 |
660 | MODIFICATION HISTORY
661 | Date Author Description of Changes
662 | 28-Jun-2004 J Rautiainen Created
663 |
664 *=======================================================================*/
665 PROCEDURE add_range_to_be_inserted(p_range IN Date_Range_Type,
666 p_range_table IN OUT NOCOPY range_table,
667 counter IN OUT NOCOPY NUMBER);
668
669 /*========================================================================
670 | PUBLIC PROCEDURE end_date_open_entry
671 |
672 | DESCRIPTION
673 | This procedure end dates a existing open end dated record.
674 |
675 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
676 | audit list API
677 |
678 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
679 |
680 | RETURNS
681 | None.
682 |
683 | PARAMETERS
684 | p_emp_rec IN Record containing employee information.
685 | p_audit_rec IN Record containing the new audit list entry information.
686 |
687 | MODIFICATION HISTORY
688 | Date Author Description of Changes
689 | 28-Jun-2004 J Rautiainen Created
690 |
691 *=======================================================================*/
692 PROCEDURE end_date_open_entry(p_emp_rec IN AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type,
693 p_audit_rec IN AP_WEB_AUDIT_LIST_PUB.Audit_Rec_Type);
694
695 /*========================================================================
696 | PUBLIC PROCEDURE process_entry
697 |
698 | DESCRIPTION
699 | This procedure processes new audit list entry.
700 |
701 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
702 | audit list API
703 |
704 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
705 |
706 | RETURNS
707 | None.
708 |
709 | PARAMETERS
710 | p_emp_rec IN Record containing employee information.
711 | p_audit_rec IN Record containing the new audit list entry information.
712 | p_return_status OUT Status whether the action was succesful or not
713 | p_auto_audit_id OUT Identifier of the new record created, if multiple created returns -1.
714 |
715 | MODIFICATION HISTORY
716 | Date Author Description of Changes
717 | 28-Jun-2004 J Rautiainen Created
718 |
719 *=======================================================================*/
720 PROCEDURE process_entry(p_emp_rec IN AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type,
721 p_audit_rec IN AP_WEB_AUDIT_LIST_PUB.Audit_Rec_Type,
722 p_return_status OUT NOCOPY VARCHAR2,
723 p_auto_audit_id OUT NOCOPY NUMBER);
724
725 /*========================================================================
726 | PUBLIC PROCEDURE remove_entries
727 |
728 | DESCRIPTION
729 | This procedure processes audit list entry removal.
730 |
731 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
732 | audit list API
733 |
734 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
735 |
736 | RETURNS
737 | None.
738 |
739 | PARAMETERS
740 | p_emp_rec IN Record containing employee information.
741 | p_date_range_rec IN Record containg date range
742 | p_return_status OUT Status whether the action was succesful or not
743 |
744 | MODIFICATION HISTORY
745 | Date Author Description of Changes
746 | 28-Jun-2004 J Rautiainen Created
747 |
748 *=======================================================================*/
749 PROCEDURE remove_entries(p_emp_rec IN AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type,
750 p_date_range_rec IN AP_WEB_AUDIT_LIST_PUB.Date_Range_Type,
751 p_return_status OUT NOCOPY VARCHAR2);
752
753 END AP_WEB_AUDIT_LIST_PVT;
754