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 2287: , 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

2283: , tst.grade_flag
2284: , to_char(opf.completed_date)
2285: , to_char(opf.completed_date, 'HH24:MI:SS')
2286: , opf.lesson_status
2287: , 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
2288: ,ota_timezone_util.get_dateDT(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), 'Y', ota_timezone_util.get_server_timezone_code) Comp_Date
2289: From OTA_LEARNING_OBJECTS olo, OTA_PERFORMANCES opf,
2290: OTA_TESTS tst
2291: Where

Line 2288: ,ota_timezone_util.get_dateDT(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), 'Y', ota_timezone_util.get_server_timezone_code) Comp_Date

2284: , to_char(opf.completed_date)
2285: , to_char(opf.completed_date, 'HH24:MI:SS')
2286: , opf.lesson_status
2287: , 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
2288: ,ota_timezone_util.get_dateDT(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), 'Y', ota_timezone_util.get_server_timezone_code) Comp_Date
2289: From OTA_LEARNING_OBJECTS olo, OTA_PERFORMANCES opf,
2290: OTA_TESTS tst
2291: Where
2292: olo.learning_object_id = opf.learning_object_id(+)

Line 2322: , 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

2318: , tst.grade_flag
2319: , to_char(opf.completed_date)
2320: , to_char(opf.completed_date, 'HH24:MI:SS')
2321: , opf.lesson_status
2322: , 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
2323: ,ota_timezone_util.get_dateDT(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), 'Y', ota_timezone_util.get_server_timezone_code) Comp_Date
2324: From OTA_LEARNING_OBJECTS olo, OTA_PERFORMANCES opf,
2325: OTA_TESTS tst
2326: Where

Line 2323: ,ota_timezone_util.get_dateDT(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), 'Y', ota_timezone_util.get_server_timezone_code) Comp_Date

2319: , to_char(opf.completed_date)
2320: , to_char(opf.completed_date, 'HH24:MI:SS')
2321: , opf.lesson_status
2322: , 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
2323: ,ota_timezone_util.get_dateDT(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), 'Y', ota_timezone_util.get_server_timezone_code) Comp_Date
2324: From OTA_LEARNING_OBJECTS olo, OTA_PERFORMANCES opf,
2325: OTA_TESTS tst
2326: Where
2327: olo.learning_object_id = opf.learning_object_id(+)

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

2542: open c_event_time_info;
2543: fetch c_event_time_info into l_course_start_time, l_course_end_time, l_timezone;
2544: close c_event_time_info;
2545:
2546: l_sysdate := ota_timezone_util.convert_date(sysdate, to_char(sysdate,'HH24:MI'), ota_timezone_util.get_server_timezone_code, l_timezone);
2547:
2548: if (p_event_type = 'SCHEDULED') then
2549:
2550: --Bug 5107276

Line 2975: 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');

2971:
2972: --Bug 5166350
2973: wait_dur_date := substr(v_wait_duration, 1, length(v_wait_duration)-9);
2974: wait_dur_time := substr(v_wait_duration, length(v_wait_duration)-7);
2975: 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');
2976:
2977: if v_wait_duration is not null then
2978: fnd_message.set_name('OTA', 'OTA_443502_TEST_WAIT_DRTN_TEXT');
2979: fnd_message.set_token('DATETIME', v_wait_duration);

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

3379: --Bug 5222464
3380: CURSOR c_delivery_mode IS
3381: SELECT ocu.online_flag, ofr.learning_object_id,
3382: 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'),
3383: ota_timezone_util.convert_date(sysdate, to_char(sysdate,'HH24:MI'), ota_timezone_util.get_server_timezone_code, oev.timezone)
3384: FROM ota_events oev, ota_offerings ofr, ota_category_usages ocu
3385: WHERE oev.parent_offering_id = ofr.offering_id
3386: AND ofr.delivery_mode_id = ocu.category_usage_id
3387: AND oev.event_id = p_event_id;

Line 3841: 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

3837: 'B', '5',
3838: 'N', '6') decode_lesson_status,
3839: ocu.Synchronous_Flag Sync_Flag,
3840: ocu.Online_Flag Online_Flag,
3841: 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
3842: From OTA_EVENTS oev, OTA_OFFERINGS ofr, OTA_PERFORMANCES opf, ota_category_usages ocu
3843: Where
3844: oev.parent_offering_id = ofr.offering_id
3845: And ofr.learning_object_id = opf.learning_object_id(+)

Line 3861: 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

3857: to_char(opf.completed_date, 'HH24:MI:SS'),
3858: opf.lesson_status,
3859: ocu.Synchronous_Flag Sync_Flag,
3860: ocu.Online_Flag Online_Flag,
3861: 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
3862: From OTA_EVENTS oev, OTA_OFFERINGS ofr, OTA_PERFORMANCES opf, ota_category_usages ocu
3863: Where
3864: oev.parent_offering_id = ofr.offering_id
3865: And ofr.learning_object_id = opf.learning_object_id(+)

Line 3948: 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,

3944: 'B', '5',
3945: 'N', '6') decode_lesson_status,
3946: ocu.Synchronous_Flag Sync_Flag,
3947: ocu.Online_Flag Online_Flag,
3948: 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,
3949: 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
3950: From OTA_EVENTS oev, OTA_OFFERINGS ofr, OTA_PERFORMANCES opf, ota_category_usages ocu
3951: Where
3952: oev.parent_offering_id = ofr.offering_id

Line 3949: 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

3945: 'N', '6') decode_lesson_status,
3946: ocu.Synchronous_Flag Sync_Flag,
3947: ocu.Online_Flag Online_Flag,
3948: 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,
3949: 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
3950: From OTA_EVENTS oev, OTA_OFFERINGS ofr, OTA_PERFORMANCES opf, ota_category_usages ocu
3951: Where
3952: oev.parent_offering_id = ofr.offering_id
3953: And ofr.learning_object_id = opf.learning_object_id(+)

Line 3969: 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,

3965: to_char(opf.completed_date, 'HH24:MI:SS'),
3966: opf.lesson_status,
3967: ocu.Synchronous_Flag Sync_Flag,
3968: ocu.Online_Flag Online_Flag,
3969: 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,
3970: 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
3971: From OTA_EVENTS oev, OTA_OFFERINGS ofr, OTA_PERFORMANCES opf, ota_category_usages ocu
3972: Where
3973: oev.parent_offering_id = ofr.offering_id

Line 3970: 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

3966: opf.lesson_status,
3967: ocu.Synchronous_Flag Sync_Flag,
3968: ocu.Online_Flag Online_Flag,
3969: 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,
3970: 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
3971: From OTA_EVENTS oev, OTA_OFFERINGS ofr, OTA_PERFORMANCES opf, ota_category_usages ocu
3972: Where
3973: oev.parent_offering_id = ofr.offering_id
3974: And ofr.learning_object_id = opf.learning_object_id(+)

Line 4224: , 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

4220: , tst.grade_flag
4221: , to_char(opf.completed_date)
4222: , to_char(opf.completed_date, 'HH24:MI:SS')
4223: , opf.lesson_status
4224: , 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
4225: , ota_timezone_util.get_dateDT(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), 'Y', ota_timezone_util.get_server_timezone_code) Comp_Date
4226: From OTA_LEARNING_OBJECTS olo, OTA_PERFORMANCES opf,
4227: OTA_TESTS tst
4228: Where

Line 4225: , ota_timezone_util.get_dateDT(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), 'Y', ota_timezone_util.get_server_timezone_code) Comp_Date

4221: , to_char(opf.completed_date)
4222: , to_char(opf.completed_date, 'HH24:MI:SS')
4223: , opf.lesson_status
4224: , 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
4225: , ota_timezone_util.get_dateDT(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), 'Y', ota_timezone_util.get_server_timezone_code) Comp_Date
4226: From OTA_LEARNING_OBJECTS olo, OTA_PERFORMANCES opf,
4227: OTA_TESTS tst
4228: Where
4229: olo.learning_object_id = opf.learning_object_id(+)

Line 4258: , 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

4254: , tst.grade_flag
4255: , to_char(opf.completed_date)
4256: , to_char(opf.completed_date, 'HH24:MI:SS')
4257: , opf.lesson_status
4258: , 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
4259: , ota_timezone_util.get_dateDT(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), 'Y', ota_timezone_util.get_server_timezone_code) Comp_Date
4260: From OTA_LEARNING_OBJECTS olo, OTA_PERFORMANCES opf,
4261: OTA_TESTS tst
4262: Where

Line 4259: , ota_timezone_util.get_dateDT(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), 'Y', ota_timezone_util.get_server_timezone_code) Comp_Date

4255: , to_char(opf.completed_date)
4256: , to_char(opf.completed_date, 'HH24:MI:SS')
4257: , opf.lesson_status
4258: , 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
4259: , ota_timezone_util.get_dateDT(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), 'Y', ota_timezone_util.get_server_timezone_code) Comp_Date
4260: From OTA_LEARNING_OBJECTS olo, OTA_PERFORMANCES opf,
4261: OTA_TESTS tst
4262: Where
4263: olo.learning_object_id = opf.learning_object_id(+)