APPS.HR_EX_EMPLOYEE_API dependencies on PER_EVENTS

Line 74: from per_events pe

70: select 'X'
71: into v_dummy
72: from sys.dual
73: where exists ( select 'Events exist'
74: from per_events pe
75: , per_bookings pb
76: where pe.business_group_id = pb.business_group_id
77: and (pb.business_group_id = p_business_group_id OR
78: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')

Line 98: from per_events pe

94: select 'X'
95: into v_dummy
96: from sys.dual
97: where exists(select 'Interview rows exist'
98: from per_events pe
99: where pe.business_group_id + 0 = p_business_group_id
100: and pe.event_or_interview = 'I'
101: and pe.internal_contact_person_id = p_person_id
102: and pe.date_start > p_session_date

Line 106: from per_events pe

102: and pe.date_start > p_session_date
103: )
104: OR
105: exists(select 'Interview rows exist'
106: from per_events pe
107: ,per_bookings pb
108: where pe.business_group_id = pb.business_group_id
109: and (pb.business_group_id = p_business_group_id OR
110: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')

Line 835: from per_events

831: ---- this procedure is written after discussing with Talent Mgmt team
832: cursor csr_del_events is
833:
834: select event_id,object_version_number
835: from per_events
836: where assignment_id in ( select distinct (assignment_id )
837: from per_all_assignments_f where person_id=p_person_id and period_of_service_id =p_pds_id
838: and assignment_type='E')
839: AND date_start > p_term_date;

Line 860: per_events_api.delete_event(

856: WHERE event_id = csr_events.event_id;
857:
858: hr_utility.set_location(' after bookings ', 342);
859:
860: per_events_api.delete_event(
861: p_event_id => csr_events.event_id ,
862: p_object_version_number => csr_events.object_version_number);
863:
864:

Line 873: FROM per_events pe, per_performance_reviews pr

869: PROCEDURE delete_perf(p_person_id IN NUMBER,p_term_date date) IS
870:
871: cursor csr_perfs(p_person_id NUMBER, p_term_date1 DATE) is
872: select pe.event_id,pe.object_version_number pe_ovn, pr.performance_review_id, pr.object_version_number
873: FROM per_events pe, per_performance_reviews pr
874: WHERE pr.person_id = p_person_id
875: AND pr.event_id = pe.event_id
876: AND pr.review_date > p_term_date1
877: ORDER BY performance_review_id,event_id;

Line 910: per_events_api.delete_event(

906: BEGIN
907: hr_utility.trace('Deleting the event :'||l_prev_event);
908: DELETE from per_bookings
909: WHERE event_id = l_prev_event;
910: per_events_api.delete_event(
911: p_event_id =>l_prev_event,
912: p_object_version_number =>l_prev_ovn);
913: EXCEPTION
914: WHEN Others THEN

Line 928: per_events_api.delete_event(

924: BEGIN
925: hr_utility.trace('Outside loop.. deleting:'||l_prev_event);
926: DELETE from per_bookings
927: WHERE event_id = l_prev_event;
928: per_events_api.delete_event(
929: p_event_id =>l_prev_event,
930: p_object_version_number =>l_prev_ovn);
931: EXCEPTION
932: WHEN Others THEN