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_TRAINING_RECORD dependencies on OTA_DELEGATE_BOOKINGS

Line 213: delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE,

209: TYPE event_tabletype IS TABLE OF event_rectype NOT NULL;
210:
211: TYPE booking_rectype IS RECORD
212: (
213: delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE,
214: status ota_booking_status_types_tl.name%TYPE,
215: player_status hr_lookups.meaning%TYPE,
216: booking_id ota_delegate_bookings.booking_id%TYPE,
217: is_history_flag ota_delegate_bookings.is_history_flag%TYPE,

Line 216: booking_id ota_delegate_bookings.booking_id%TYPE,

212: (
213: delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE,
214: status ota_booking_status_types_tl.name%TYPE,
215: player_status hr_lookups.meaning%TYPE,
216: booking_id ota_delegate_bookings.booking_id%TYPE,
217: is_history_flag ota_delegate_bookings.is_history_flag%TYPE,
218: date_status_changed ota_delegate_bookings.date_status_changed%TYPE,
219: successful_attendance_flag ota_delegate_bookings.successful_attendance_flag%TYPE,
220: is_mandatory_enrollment ota_delegate_bookings.is_mandatory_enrollment%TYPE

Line 217: is_history_flag ota_delegate_bookings.is_history_flag%TYPE,

213: delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE,
214: status ota_booking_status_types_tl.name%TYPE,
215: player_status hr_lookups.meaning%TYPE,
216: booking_id ota_delegate_bookings.booking_id%TYPE,
217: is_history_flag ota_delegate_bookings.is_history_flag%TYPE,
218: date_status_changed ota_delegate_bookings.date_status_changed%TYPE,
219: successful_attendance_flag ota_delegate_bookings.successful_attendance_flag%TYPE,
220: is_mandatory_enrollment ota_delegate_bookings.is_mandatory_enrollment%TYPE
221: );

Line 218: date_status_changed ota_delegate_bookings.date_status_changed%TYPE,

214: status ota_booking_status_types_tl.name%TYPE,
215: player_status hr_lookups.meaning%TYPE,
216: booking_id ota_delegate_bookings.booking_id%TYPE,
217: is_history_flag ota_delegate_bookings.is_history_flag%TYPE,
218: date_status_changed ota_delegate_bookings.date_status_changed%TYPE,
219: successful_attendance_flag ota_delegate_bookings.successful_attendance_flag%TYPE,
220: is_mandatory_enrollment ota_delegate_bookings.is_mandatory_enrollment%TYPE
221: );
222: TYPE activity_rectype IS RECORD

Line 219: successful_attendance_flag ota_delegate_bookings.successful_attendance_flag%TYPE,

215: player_status hr_lookups.meaning%TYPE,
216: booking_id ota_delegate_bookings.booking_id%TYPE,
217: is_history_flag ota_delegate_bookings.is_history_flag%TYPE,
218: date_status_changed ota_delegate_bookings.date_status_changed%TYPE,
219: successful_attendance_flag ota_delegate_bookings.successful_attendance_flag%TYPE,
220: is_mandatory_enrollment ota_delegate_bookings.is_mandatory_enrollment%TYPE
221: );
222: TYPE activity_rectype IS RECORD
223: (

Line 220: is_mandatory_enrollment ota_delegate_bookings.is_mandatory_enrollment%TYPE

216: booking_id ota_delegate_bookings.booking_id%TYPE,
217: is_history_flag ota_delegate_bookings.is_history_flag%TYPE,
218: date_status_changed ota_delegate_bookings.date_status_changed%TYPE,
219: successful_attendance_flag ota_delegate_bookings.successful_attendance_flag%TYPE,
220: is_mandatory_enrollment ota_delegate_bookings.is_mandatory_enrollment%TYPE
221: );
222: TYPE activity_rectype IS RECORD
223: (
224: activity_version_id ota_activity_versions_vl.activity_version_id%TYPE,

Line 278: person_id ota_delegate_bookings.delegate_person_id%TYPE DEFAULT NULL,

274: );
275:
276: TYPE course_query_input_rectype IS RECORD
277: (
278: person_id ota_delegate_bookings.delegate_person_id%TYPE DEFAULT NULL,
279: start_person_id ota_cert_enrollments.person_id%TYPE DEFAULT NULL,
280: end_person_id ota_cert_enrollments.person_id%TYPE DEFAULT NULL,
281: course_id ota_activity_versions.activity_id%TYPE DEFAULT NULL,
282: delegate_booking_id ota_delegate_bookings.booking_id%TYPE DEFAULT NULL,

Line 282: delegate_booking_id ota_delegate_bookings.booking_id%TYPE DEFAULT NULL,

278: person_id ota_delegate_bookings.delegate_person_id%TYPE DEFAULT NULL,
279: start_person_id ota_cert_enrollments.person_id%TYPE DEFAULT NULL,
280: end_person_id ota_cert_enrollments.person_id%TYPE DEFAULT NULL,
281: course_id ota_activity_versions.activity_id%TYPE DEFAULT NULL,
282: delegate_booking_id ota_delegate_bookings.booking_id%TYPE DEFAULT NULL,
283: view_history BOOLEAN DEFAULT FALSE,
284: options query_options
285: );
286: /*#