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_LRNG_PATH_MEMBER_UTIL dependencies on OTA_TIMEZONE_UTIL

Line 1366: SELECT ota_timezone_util.get_dateDT(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), ocu.Online_Flag, ota_timezone_util.get_server_timezone_code) completion_date

1362:
1363: CURSOR get_online_compl_date_p(p_event_id IN ota_events.event_id%type,
1364: p_user_id IN ota_attempts.user_id%type,
1365: p_user_type IN ota_attempts.user_type%type) IS
1366: SELECT ota_timezone_util.get_dateDT(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), ocu.Online_Flag, ota_timezone_util.get_server_timezone_code) completion_date
1367: FROM ota_events oev,
1368: ota_offerings ofr,
1369: ota_performances opf,
1370: ota_category_usages ocu,

Line 1388: SELECT ota_timezone_util.get_dateDT(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), ocu.Online_Flag, ota_timezone_util.get_server_timezone_code) completion_date

1384:
1385: CURSOR get_online_compl_date_c(p_event_id IN ota_events.event_id%type,
1386: p_user_id IN ota_attempts.user_id%type,
1387: p_user_type IN ota_attempts.user_type%type) IS
1388: SELECT ota_timezone_util.get_dateDT(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), ocu.Online_Flag, ota_timezone_util.get_server_timezone_code) completion_date
1389: FROM ota_events oev,
1390: ota_offerings ofr,
1391: ota_performances opf,
1392: ota_category_usages ocu,