eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_CME_UTIL dependencies on OTA_DELEGATE_BOOKINGS

Line 23: ota_delegate_bookings tdb,

19: evt.COURSE_END_DATE,
20: tdb.successful_attendance_flag,
21: tdb.sign_eval_status ---added for sign in cert.10164130
22: FROM ota_events evt,
23: ota_delegate_bookings tdb,
24: ota_booking_status_types bst
25: WHERE evt.event_id = tdb.event_id
26: AND bst.booking_status_type_id = tdb.booking_status_type_id
27: and (

Line 50: p_date_status_changed OUT NOCOPY ota_delegate_bookings.date_status_changed%TYPE)

46:
47: PROCEDURE get_enrl_status_on_update(p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,
48: p_cert_prd_enrollment_id IN ota_cert_prd_enrollments.cert_prd_enrollment_id%TYPE,
49: p_booking_status_type OUT NOCOPY ota_booking_status_types.type%TYPE,
50: p_date_status_changed OUT NOCOPY ota_delegate_bookings.date_status_changed%TYPE)
51: IS
52:
53: CURSOR csr_cert_enrl IS
54: SELECT cre.person_id, cre.contact_id, cpe.cert_period_start_date, cpe.cert_period_end_date

Line 68: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;

64: l_cert_period_start_date ota_cert_prd_enrollments.cert_period_start_date%type;
65: l_cert_period_end_date ota_cert_prd_enrollments.cert_period_start_date%type;
66:
67: l_enroll_status VARCHAR2(30);
68: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;
69:
70: BEGIN
71:
72: hr_utility.set_location(' Step:'|| l_proc, 10);

Line 106: p_date_status_changed OUT NOCOPY ota_delegate_bookings.date_status_changed%TYPE,

102:
103: PROCEDURE get_enrl_status_on_update(p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,
104: p_cert_prd_enrollment_id IN ota_cert_prd_enrollments.cert_prd_enrollment_id%TYPE,
105: p_booking_status_type OUT NOCOPY ota_booking_status_types.type%TYPE,
106: p_date_status_changed OUT NOCOPY ota_delegate_bookings.date_status_changed%TYPE,
107: p_successful_attendance_flag OUT NOCOPY ota_delegate_bookings.successful_attendance_flag%TYPE)
108: IS
109:
110: CURSOR csr_cert_enrl IS

Line 107: p_successful_attendance_flag OUT NOCOPY ota_delegate_bookings.successful_attendance_flag%TYPE)

103: PROCEDURE get_enrl_status_on_update(p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,
104: p_cert_prd_enrollment_id IN ota_cert_prd_enrollments.cert_prd_enrollment_id%TYPE,
105: p_booking_status_type OUT NOCOPY ota_booking_status_types.type%TYPE,
106: p_date_status_changed OUT NOCOPY ota_delegate_bookings.date_status_changed%TYPE,
107: p_successful_attendance_flag OUT NOCOPY ota_delegate_bookings.successful_attendance_flag%TYPE)
108: IS
109:
110: CURSOR csr_cert_enrl IS
111: SELECT cre.person_id, cre.contact_id, cpe.cert_period_start_date, cpe.cert_period_end_date

Line 125: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;

121: l_cert_period_start_date ota_cert_prd_enrollments.cert_period_start_date%type;
122: l_cert_period_end_date ota_cert_prd_enrollments.cert_period_start_date%type;
123:
124: l_enroll_status VARCHAR2(30);
125: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;
126: l_successful_attendance_flag ota_delegate_bookings.successful_attendance_flag%TYPE;
127:
128: BEGIN
129:

Line 126: l_successful_attendance_flag ota_delegate_bookings.successful_attendance_flag%TYPE;

122: l_cert_period_end_date ota_cert_prd_enrollments.cert_period_start_date%type;
123:
124: l_enroll_status VARCHAR2(30);
125: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;
126: l_successful_attendance_flag ota_delegate_bookings.successful_attendance_flag%TYPE;
127:
128: BEGIN
129:
130: hr_utility.set_location(' Step:'|| l_proc, 10);

Line 197: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;

193: l_cert_period_start_date ota_cert_prd_enrollments.cert_period_start_date%type;
194: l_cert_period_end_date ota_cert_prd_enrollments.cert_period_start_date%type;
195:
196: l_enroll_status VARCHAR2(30);
197: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;
198: l_event_type ota_events.event_type%type;
199: l_course_start_date ota_events.course_start_date%type;
200: l_course_end_date ota_events.course_end_date%type;
201: l_successful_attendance_flag ota_delegate_bookings.successful_attendance_flag%TYPE;

Line 201: l_successful_attendance_flag ota_delegate_bookings.successful_attendance_flag%TYPE;

197: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;
198: l_event_type ota_events.event_type%type;
199: l_course_start_date ota_events.course_start_date%type;
200: l_course_end_date ota_events.course_end_date%type;
201: l_successful_attendance_flag ota_delegate_bookings.successful_attendance_flag%TYPE;
202: l_sign_eval_status ota_delegate_bookings.sign_eval_status%type; --10164130
203: l_cert_prd_count number := 0; --Bug 15938221
204:
205: BEGIN

Line 202: l_sign_eval_status ota_delegate_bookings.sign_eval_status%type; --10164130

198: l_event_type ota_events.event_type%type;
199: l_course_start_date ota_events.course_start_date%type;
200: l_course_end_date ota_events.course_end_date%type;
201: l_successful_attendance_flag ota_delegate_bookings.successful_attendance_flag%TYPE;
202: l_sign_eval_status ota_delegate_bookings.sign_eval_status%type; --10164130
203: l_cert_prd_count number := 0; --Bug 15938221
204:
205: BEGIN
206:

Line 353: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;

349: l_online_flag ota_category_usages.online_flag%type;
350: l_enroll_type ota_booking_status_types.type%TYPE;
351: l_member_status_code ota_cert_mbr_enrollments.member_status_code%TYPE;
352: l_completion_date ota_cert_mbr_enrollments.completion_date%TYPE;
353: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;
354:
355: --variables to store old values
356: l_old_member_status ota_cert_mbr_enrollments.member_status_code%TYPE;
357:

Line 360: l_successful_attendance_flag ota_delegate_bookings.successful_attendance_flag%TYPE;

356: l_old_member_status ota_cert_mbr_enrollments.member_status_code%TYPE;
357:
358: l_cert_prd_enrollment_id ota_cert_prd_enrollments.cert_prd_enrollment_id%TYPE;
359: l_cert_prd_enrollment_ids varchar2(4000) := '';
360: l_successful_attendance_flag ota_delegate_bookings.successful_attendance_flag%TYPE;
361:
362: BEGIN
363:
364: hr_utility.set_location(' Step:'||l_proc,10);

Line 561: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;

557:
558: l_enroll_type ota_booking_status_types.type%TYPE;
559: l_member_status_code ota_cert_mbr_enrollments.member_status_code%TYPE;
560: l_completion_date ota_cert_mbr_enrollments.completion_date%TYPE;
561: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;
562:
563: --variables to store old values
564: l_old_member_status ota_cert_mbr_enrollments.member_status_code%TYPE;
565:

Line 570: l_successful_attendance_flag ota_delegate_bookings.successful_attendance_flag%TYPE;

566: l_cert_prd_enrollment_id ota_cert_prd_enrollments.cert_prd_enrollment_id%TYPE;
567: l_cert_prd_enrollment_ids varchar2(4000) := '';
568:
569: rec_cme_info csr_cme_info%ROWTYPE;
570: l_successful_attendance_flag ota_delegate_bookings.successful_attendance_flag%TYPE;
571:
572: BEGIN
573:
574: hr_utility.set_location(' Step:'||l_proc,10);

Line 891: ota_delegate_bookings b,

887: s.type Enrollment_Status_Type
888: FROM ota_events e,
889: ota_events_tl et,
890: ota_activity_versions a,
891: ota_delegate_bookings b,
892: ota_booking_status_types_VL s,
893: ota_cert_enrollments cre,
894: ota_cert_prd_enrollments cpe,
895: ota_cert_mbr_enrollments cme,