APPS.OTA_CME_UTIL dependencies on OTA_EVENTS

Line 20: FROM ota_events evt,

16: evt.event_type,
17: tdb.DATE_STATUS_CHANGED,
18: evt.COURSE_START_DATE,
19: evt.COURSE_END_DATE
20: FROM ota_events evt,
21: ota_delegate_bookings tdb,
22: ota_booking_status_types bst
23: WHERE evt.event_id = tdb.event_id
24: AND bst.booking_status_type_id = tdb.booking_status_type_id

Line 127: l_event_type ota_events.event_type%type;

123: l_cert_period_end_date ota_cert_prd_enrollments.cert_period_start_date%type;
124:
125: l_enroll_status VARCHAR2(30);
126: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;
127: l_event_type ota_events.event_type%type;
128: l_course_start_date ota_events.course_start_date%type;
129: l_course_end_date ota_events.course_end_date%type;
130:
131: BEGIN

Line 128: l_course_start_date ota_events.course_start_date%type;

124:
125: l_enroll_status VARCHAR2(30);
126: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;
127: l_event_type ota_events.event_type%type;
128: l_course_start_date ota_events.course_start_date%type;
129: l_course_end_date ota_events.course_end_date%type;
130:
131: BEGIN
132:

Line 129: l_course_end_date ota_events.course_end_date%type;

125: l_enroll_status VARCHAR2(30);
126: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;
127: l_event_type ota_events.event_type%type;
128: l_course_start_date ota_events.course_start_date%type;
129: l_course_end_date ota_events.course_end_date%type;
130:
131: BEGIN
132:
133: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 211: PROCEDURE update_cme_status (p_event_id IN ota_events.event_id%TYPE,

207:
208: -- ---------------------------------------------------------------------------
209: -- |----------------------< update_cme_status >-------------------|
210: -- ---------------------------------------------------------------------------
211: PROCEDURE update_cme_status (p_event_id IN ota_events.event_id%TYPE,
212: p_person_id IN ota_cert_enrollments.person_id%TYPE,
213: p_contact_id IN ota_cert_enrollments.contact_id%TYPE,
214: p_cert_prd_enrollment_ids OUT NOCOPY varchar2)
215: IS

Line 222: FROM ota_events evt,

218:
219: CURSOR evt_det IS
220: SELECT evt.activity_version_id,
221: ocu.online_flag
222: FROM ota_events evt,
223: ota_offerings ofr,
224: ota_category_usages ocu
225: WHERE evt.event_id = p_event_id
226: AND evt.parent_offering_id = ofr.offering_id

Line 776: FROM ota_events e,

772:
773: cursor csr_active_enrl is
774: SELECT
775: s.type Enrollment_Status_Type
776: FROM ota_events e,
777: ota_events_tl et,
778: ota_activity_versions a,
779: ota_delegate_bookings b,
780: ota_booking_status_types_VL s,

Line 777: ota_events_tl et,

773: cursor csr_active_enrl is
774: SELECT
775: s.type Enrollment_Status_Type
776: FROM ota_events e,
777: ota_events_tl et,
778: ota_activity_versions a,
779: ota_delegate_bookings b,
780: ota_booking_status_types_VL s,
781: ota_cert_enrollments cre,