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 331: ota_booking_status_types bst

327: bst.booking_status_type_id status_id,
328: decode(bst.type, 'C', 0,'R',1, 'W',2, 'P',3,'E',4, 'A',5) status_number,
329: nvl(tdb.is_mandatory_enrollment,'N') mandatory_enrollment_flag
330: FROM ota_delegate_bookings tdb,
331: ota_booking_status_types bst
332: WHERE tdb.delegate_person_id = p_learner_id
333: AND tdb.event_id = p_event_id
334: AND tdb.booking_status_type_id = bst.booking_status_type_id
335: ORDER BY mandatory_enrollment_flag desc, status_number desc;

Line 1759: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%type;

1755: AND nvl(assg.effective_end_date,trunc(sysdate+1));
1756:
1757: l_error_message ota_mandatory_enr_req_members.error_message%type;
1758: l_mandaotory_enr_request_id ota_mandatory_enr_req_members.mandatory_enr_request_id%type;
1759: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%type;
1760: l_booking_status ota_booking_status_types_tl.name%type;
1761:
1762: l_request_rec get_all_mandatory_enr_requests%rowtype;
1763: l_req_member_rec csr_get_request_members%rowtype;

Line 1760: l_booking_status ota_booking_status_types_tl.name%type;

1756:
1757: l_error_message ota_mandatory_enr_req_members.error_message%type;
1758: l_mandaotory_enr_request_id ota_mandatory_enr_req_members.mandatory_enr_request_id%type;
1759: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%type;
1760: l_booking_status ota_booking_status_types_tl.name%type;
1761:
1762: l_request_rec get_all_mandatory_enr_requests%rowtype;
1763: l_req_member_rec csr_get_request_members%rowtype;
1764: l_booking_id ota_delegate_bookings.booking_id%type;

Line 1919: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%type;

1915: FOR UPDATE OF ran.range_status_cd;
1916:
1917: l_error_message OTA_MAND_MULTI_ENR_REQ_MEMBERS.error_message%type;
1918: l_mandaotory_enr_request_id OTA_MAND_MULTI_ENR_REQ_MEMBERS.mandatory_enr_request_id%type;
1919: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%type;
1920: l_booking_status ota_booking_status_types_tl.name%type;
1921:
1922: l_request_rec get_all_mandatory_enr_requests%rowtype;
1923: l_req_member_rec csr_get_request_members%rowtype;

Line 1920: l_booking_status ota_booking_status_types_tl.name%type;

1916:
1917: l_error_message OTA_MAND_MULTI_ENR_REQ_MEMBERS.error_message%type;
1918: l_mandaotory_enr_request_id OTA_MAND_MULTI_ENR_REQ_MEMBERS.mandatory_enr_request_id%type;
1919: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%type;
1920: l_booking_status ota_booking_status_types_tl.name%type;
1921:
1922: l_request_rec get_all_mandatory_enr_requests%rowtype;
1923: l_req_member_rec csr_get_request_members%rowtype;
1924: l_booking_id ota_delegate_bookings.booking_id%type;