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

Line 1961: , ota_timezone_util.get_date_time(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), 'Y', ota_timezone_util.get_server_timezone_code, 'HH24:MI:SS') Comp_Date_Tz

1957: , tst.grade_flag
1958: , to_char(opf.completed_date)
1959: , to_char(opf.completed_date, 'HH24:MI:SS')
1960: , opf.lesson_status
1961: , ota_timezone_util.get_date_time(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), 'Y', ota_timezone_util.get_server_timezone_code, 'HH24:MI:SS') Comp_Date_Tz
1962: From OTA_LEARNING_OBJECTS olo, OTA_PERFORMANCES opf,
1963: OTA_TESTS tst
1964: Where
1965: olo.learning_object_id = opf.learning_object_id(+)

Line 2153: l_sysdate := ota_timezone_util.convert_date(sysdate, to_char(sysdate,'HH24:MI'), ota_timezone_util.get_server_timezone_code, l_timezone);

2149: open c_event_time_info;
2150: fetch c_event_time_info into l_course_start_time, l_course_end_time, l_timezone;
2151: close c_event_time_info;
2152:
2153: l_sysdate := ota_timezone_util.convert_date(sysdate, to_char(sysdate,'HH24:MI'), ota_timezone_util.get_server_timezone_code, l_timezone);
2154:
2155: if (p_event_type = 'SCHEDULED') then
2156:
2157: --Bug 5107276

Line 2610: v_wait_duration := ota_timezone_util.get_date_time(wait_dur_date, wait_dur_time, 'Y', ota_timezone_util.get_server_timezone_code, 'HH24:MI:SS');

2606:
2607: --Bug 5166350
2608: wait_dur_date := substr(v_wait_duration, 1, length(v_wait_duration)-9);
2609: wait_dur_time := substr(v_wait_duration, length(v_wait_duration)-7);
2610: v_wait_duration := ota_timezone_util.get_date_time(wait_dur_date, wait_dur_time, 'Y', ota_timezone_util.get_server_timezone_code, 'HH24:MI:SS');
2611:
2612: if v_wait_duration is not null then
2613: fnd_message.set_name('OTA', 'OTA_443502_TEST_WAIT_DRTN_TEXT');
2614: fnd_message.set_token('DATETIME', v_wait_duration);

Line 3018: ota_timezone_util.convert_date(sysdate, to_char(sysdate,'HH24:MI'), ota_timezone_util.get_server_timezone_code, oev.timezone)

3014: --Bug 5222464
3015: CURSOR c_delivery_mode IS
3016: SELECT ocu.online_flag, ofr.learning_object_id,
3017: to_date(to_char(nvl(oev.course_end_date, to_date('4712/12/31','YYYY/MM/DD')),'YYYY/MM/DD') || ' ' || nvl(oev.course_end_time, '23:59'), 'YYYY/MM/DD HH24:MI'),
3018: ota_timezone_util.convert_date(sysdate, to_char(sysdate,'HH24:MI'), ota_timezone_util.get_server_timezone_code, oev.timezone)
3019: FROM ota_events oev, ota_offerings ofr, ota_category_usages ocu
3020: WHERE oev.parent_offering_id = ofr.offering_id
3021: AND ofr.delivery_mode_id = ocu.category_usage_id
3022: AND oev.event_id = p_event_id;

Line 3390: ota_timezone_util.get_date_time(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), 'Y', ota_timezone_util.get_server_timezone_code, 'HH24:MI:SS') Comp_Date_Tz

3386: -- (Select Synchronous_Flag from ota_category_usages where Category_Usage_Id = ofr.Delivery_Mode_Id) Sync_Flag,
3387: -- (Select Online_Flag from ota_category_usages where Category_Usage_Id = ofr.Delivery_Mode_Id) Online_Flag
3388: ocu.Synchronous_Flag Sync_Flag,
3389: ocu.Online_Flag Online_Flag,
3390: ota_timezone_util.get_date_time(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), 'Y', ota_timezone_util.get_server_timezone_code, 'HH24:MI:SS') Comp_Date_Tz
3391: From OTA_EVENTS oev, OTA_OFFERINGS ofr, OTA_PERFORMANCES opf, ota_category_usages ocu
3392: Where
3393: oev.parent_offering_id = ofr.offering_id
3394: And ofr.learning_object_id = opf.learning_object_id(+)

Line 3478: ota_timezone_util.get_date_time(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), 'Y', ota_timezone_util.get_server_timezone_code, 'HH24:MI:SS') Comp_Date_Tz,

3474: to_char(opf.completed_date, 'HH24:MI:SS'),
3475: opf.lesson_status,
3476: ocu.Synchronous_Flag Sync_Flag,
3477: ocu.Online_Flag Online_Flag,
3478: ota_timezone_util.get_date_time(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), 'Y', ota_timezone_util.get_server_timezone_code, 'HH24:MI:SS') Comp_Date_Tz,
3479: 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) Comp_Date
3480: From OTA_EVENTS oev, OTA_OFFERINGS ofr, OTA_PERFORMANCES opf, ota_category_usages ocu
3481: Where
3482: oev.parent_offering_id = ofr.offering_id

Line 3479: 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) Comp_Date

3475: opf.lesson_status,
3476: ocu.Synchronous_Flag Sync_Flag,
3477: ocu.Online_Flag Online_Flag,
3478: ota_timezone_util.get_date_time(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), 'Y', ota_timezone_util.get_server_timezone_code, 'HH24:MI:SS') Comp_Date_Tz,
3479: 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) Comp_Date
3480: From OTA_EVENTS oev, OTA_OFFERINGS ofr, OTA_PERFORMANCES opf, ota_category_usages ocu
3481: Where
3482: oev.parent_offering_id = ofr.offering_id
3483: And ofr.learning_object_id = opf.learning_object_id(+)

Line 3706: , ota_timezone_util.get_date_time(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), 'Y', ota_timezone_util.get_server_timezone_code, 'HH24:MI:SS') Comp_Date_Tz

3702: , tst.grade_flag
3703: , to_char(opf.completed_date)
3704: , to_char(opf.completed_date, 'HH24:MI:SS')
3705: , opf.lesson_status
3706: , ota_timezone_util.get_date_time(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), 'Y', ota_timezone_util.get_server_timezone_code, 'HH24:MI:SS') Comp_Date_Tz
3707: From OTA_LEARNING_OBJECTS olo, OTA_PERFORMANCES opf,
3708: OTA_TESTS tst
3709: Where
3710: olo.learning_object_id = opf.learning_object_id(+)