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: booking_id ota_delegate_bookings.booking_id%TYPE,
216: is_history_flag ota_delegate_bookings.is_history_flag%TYPE,
217: date_status_changed ota_delegate_bookings.date_status_changed%TYPE,

Line 215: booking_id ota_delegate_bookings.booking_id%TYPE,

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: booking_id ota_delegate_bookings.booking_id%TYPE,
216: is_history_flag ota_delegate_bookings.is_history_flag%TYPE,
217: date_status_changed ota_delegate_bookings.date_status_changed%TYPE,
218: successful_attendance_flag ota_delegate_bookings.successful_attendance_flag%TYPE,
219: is_mandatory_enrollment ota_delegate_bookings.is_mandatory_enrollment%TYPE

Line 216: is_history_flag ota_delegate_bookings.is_history_flag%TYPE,

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

Line 217: date_status_changed ota_delegate_bookings.date_status_changed%TYPE,

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

Line 218: successful_attendance_flag ota_delegate_bookings.successful_attendance_flag%TYPE,

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

Line 219: is_mandatory_enrollment ota_delegate_bookings.is_mandatory_enrollment%TYPE

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

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

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

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

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