APPS.OTA_MANDATORY_ENROLL_UTIL dependencies on OTA_EVENTS

Line 13: FROM OTA_EVENTS_TL

9: AND person_id = p_person_id;
10:
11: CURSOR get_class_name(p_event_id IN NUMBER) IS
12: SELECT title
13: FROM OTA_EVENTS_TL
14: WHERE event_id = p_event_id
15: AND language=userenv('LANG');
16:
17: CURSOR get_all_mandatory_enr_requests(p_conc_request_id IN NUMBER) IS

Line 43: ota_events_tl evt_tl

39: reqm.create_enrollment create_enrollment,
40: reqm.error_message error_message
41: FROM
42: ota_mandatory_enr_req_members reqm,
43: ota_events_tl evt_tl
44: WHERE
45: evt_tl.event_id = reqm.event_id
46: AND(reqm.create_enrollment = 'N' or reqm.error_message IS NOT NULL)
47: AND evt_tl.language=userenv('LANG');

Line 61: ,p_event_id IN ota_events.event_id%type)

57: RETURN VARCHAR2;
58:
59: FUNCTION learner_is_notSelected(p_person_id IN per_all_people_f.person_id%type
60: ,p_assignment_id per_all_assignments_f.assignment_id%type
61: ,p_event_id IN ota_events.event_id%type)
62: RETURN Boolean;
63:
64: PROCEDURE process_mandatory_event_assoc(ERRBUF OUT NOCOPY VARCHAR2
65: ,RETCODE OUT NOCOPY VARCHAR2