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_MANDATORY_ENROLL_UTIL dependencies on OTA_BOOKING_STATUS_TYPES

Line 130: ota_booking_status_types bst,

126: bst.booking_status_type_id status_id,
127: decode(bst.type, 'C', 0,'R',1, 'W',2, 'P',3,'E',4, 'A',5) status_number,
128: nvl(tdb.is_mandatory_enrollment,'N') mandatory_enrollment_flag
129: FROM ota_delegate_bookings tdb,
130: ota_booking_status_types bst,
131: ota_booking_status_types_tl btt
132: WHERE tdb.delegate_person_id = p_learner_id
133: AND tdb.event_id = p_event_id
134: AND tdb.booking_status_type_id = bst.booking_status_type_id

Line 131: ota_booking_status_types_tl btt

127: decode(bst.type, 'C', 0,'R',1, 'W',2, 'P',3,'E',4, 'A',5) status_number,
128: nvl(tdb.is_mandatory_enrollment,'N') mandatory_enrollment_flag
129: FROM ota_delegate_bookings tdb,
130: ota_booking_status_types bst,
131: ota_booking_status_types_tl btt
132: WHERE tdb.delegate_person_id = p_learner_id
133: AND tdb.event_id = p_event_id
134: AND tdb.booking_status_type_id = bst.booking_status_type_id
135: AND bst.booking_status_type_id = btt.booking_status_type_id

Line 643: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%type;

639: AND nvl(assg.effective_end_date,trunc(sysdate+1));
640:
641: l_error_message ota_mandatory_enr_req_members.error_message%type;
642: l_mandaotory_enr_request_id ota_mandatory_enr_req_members.mandatory_enr_request_id%type;
643: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%type;
644: l_booking_status ota_booking_status_types_tl.name%type;
645:
646: l_request_rec get_all_mandatory_enr_requests%rowtype;
647: l_req_member_rec csr_get_request_members%rowtype;

Line 644: l_booking_status ota_booking_status_types_tl.name%type;

640:
641: l_error_message ota_mandatory_enr_req_members.error_message%type;
642: l_mandaotory_enr_request_id ota_mandatory_enr_req_members.mandatory_enr_request_id%type;
643: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%type;
644: l_booking_status ota_booking_status_types_tl.name%type;
645:
646: l_request_rec get_all_mandatory_enr_requests%rowtype;
647: l_req_member_rec csr_get_request_members%rowtype;
648: l_booking_id ota_delegate_bookings.booking_id%type;