[Home] [Help]
32: Version Date Author ER/CR No. Description of Change
33: -------+---------+----------+---------+--------------------------
34: 70.0 11-FEB-93 SZWILLIA Date Created
35: 70.1 18-FEB-93 SZWILLIA Corrected deletes from
36: PER_BOOKINGS and PER_EVENTS.
37: Also, added future actions
38: check to cancellations.
39: Added messages
40: 70.2 11-MAR-93 NKHAN Added 'exit' to end
350: hr_utility.set_location(l_proc,1);
351: -- Remove booking and event where the event is for the assignment
352: --
353: --
354: -- 3735333 Modified the query of per_bookings for better performance.
355: --
356: --
357: DELETE per_bookings pb
358: WHERE event_id in ( SELECT event_id
353: --
354: -- 3735333 Modified the query of per_bookings for better performance.
355: --
356: --
357: DELETE per_bookings pb
358: WHERE event_id in ( SELECT event_id
359: FROM per_events pev
360: WHERE pev.assignment_id = p_assignment_id
361: AND pev.date_start > p_actual_termination_date
523: AND paa.date_start > p_actual_termination_date;
524: --
525: hr_utility.set_location(l_proc,5);
526: -- Remove bookings on employee events
527: DELETE per_bookings pb
528: WHERE pb.person_id = p_person_id
529: AND EXISTS (SELECT ''
530: FROM per_events pev
531: WHERE pev.date_start > p_actual_termination_date
535: --
536: hr_utility.set_location(l_proc,7);
537: -- Remove bookings as an interviewer for either employee or applicant
538: -- interviews
539: DELETE per_bookings pb
540: WHERE pb.person_id = p_person_id
541: AND EXISTS (SELECT ''
542: FROM per_events pev
543: WHERE pev.event_id = pb.event_id