[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
362: hr_utility.set_location(l_proc,1);
363: -- Remove booking and event where the event is for the assignment
364: --
365: --
366: -- 3735333 Modified the query of per_bookings for better performance.
367: --
368: --
369: DELETE per_bookings pb
370: WHERE event_id in ( SELECT event_id
365: --
366: -- 3735333 Modified the query of per_bookings for better performance.
367: --
368: --
369: DELETE per_bookings pb
370: WHERE event_id in ( SELECT event_id
371: FROM per_events pev
372: WHERE pev.assignment_id = p_assignment_id
373: AND pev.date_start > p_actual_termination_date
535: AND paa.date_start > p_actual_termination_date;
536: --
537: hr_utility.set_location(l_proc,5);
538: -- Remove bookings on employee events
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.date_start > p_actual_termination_date
547: --
548: hr_utility.set_location(l_proc,7);
549: -- Remove bookings as an interviewer for either employee or applicant
550: -- interviews
551: DELETE per_bookings pb
552: WHERE pb.person_id = p_person_id
553: AND EXISTS (SELECT ''
554: FROM per_events pev
555: WHERE pev.event_id = pb.event_id