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 21: ota_delegate_bookings tdb,

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
25: and (

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

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

Line 66: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;

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

Line 126: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;

122: l_cert_period_start_date ota_cert_prd_enrollments.cert_period_start_date%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:

Line 258: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;

254: l_online_flag ota_category_usages.online_flag%type;
255: l_enroll_type ota_booking_status_types.type%TYPE;
256: l_member_status_code ota_cert_mbr_enrollments.member_status_code%TYPE;
257: l_completion_date ota_cert_mbr_enrollments.completion_date%TYPE;
258: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;
259:
260: --variables to store old values
261: l_old_member_status ota_cert_mbr_enrollments.member_status_code%TYPE;
262:

Line 458: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;

454:
455: l_enroll_type ota_booking_status_types.type%TYPE;
456: l_member_status_code ota_cert_mbr_enrollments.member_status_code%TYPE;
457: l_completion_date ota_cert_mbr_enrollments.completion_date%TYPE;
458: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;
459:
460: --variables to store old values
461: l_old_member_status ota_cert_mbr_enrollments.member_status_code%TYPE;
462:

Line 779: ota_delegate_bookings b,

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,
782: ota_cert_prd_enrollments cpe,
783: ota_cert_mbr_enrollments cme,