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_GENERAL dependencies on OTA_EVENTS

Line 69: l_event_name ota_events.title%TYPE;

65: function get_event_name (p_event_id in number)
66: return varchar2
67: IS
68:
69: l_event_name ota_events.title%TYPE;
70:
71: CURSOR c_get_event_name
72: IS
73: SELECT title from ota_events_vl

Line 73: SELECT title from ota_events_vl

69: l_event_name ota_events.title%TYPE;
70:
71: CURSOR c_get_event_name
72: IS
73: SELECT title from ota_events_vl
74: where
75: event_id = p_event_id;
76:
77: BEGIN

Line 127: FROM OTA_ACTIVITY_VERSIONS_TL oav,ota_events oev

123:
124: CURSOR c_get_course_name2
125: IS
126: SELECT oav.version_name
127: FROM OTA_ACTIVITY_VERSIONS_TL oav,ota_events oev
128: WHERE oav.activity_version_id = oev.activity_version_id
129: AND oav.language=userenv('LANG')
130: and oev.event_id = p_eventid;
131: