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_ACTIVITY_VERSIONS_TL

Line 115: l_course_name OTA_ACTIVITY_VERSIONS_TL.version_name%TYPE;

111: function get_course_name (p_activity_version_id in number default null,p_eventid in number default null)
112: return varchar2
113: IS
114: l_business_group_id number;
115: l_course_name OTA_ACTIVITY_VERSIONS_TL.version_name%TYPE;
116:
117: CURSOR c_get_course_name
118: IS
119: SELECT version_name

Line 120: FROM OTA_ACTIVITY_VERSIONS_TL

116:
117: CURSOR c_get_course_name
118: IS
119: SELECT version_name
120: FROM OTA_ACTIVITY_VERSIONS_TL
121: WHERE activity_version_id = p_activity_version_id
122: AND language=userenv('LANG');
123:
124: CURSOR c_get_course_name2

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: