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

Line 636: ota_timezone_util.convert_date(trunc(p_date),to_char(p_date,'HH24:MI'), ota_timezone_util.get_server_timezone_code , oev.timezone)

632: event_type in ('SCHEDULED','SELFPACED') and
633: event_status in('P','N','F') and
634: -- l_date between nvl(enrolment_start_date, l_date) AND nvl(enrolment_end_date, l_date);
635: -- Modified for Bug#5107347
636: ota_timezone_util.convert_date(trunc(p_date),to_char(p_date,'HH24:MI'), ota_timezone_util.get_server_timezone_code , oev.timezone)
637: BETWEEN decode(oev.enrolment_start_date, NULL, to_date('0001/01/01','YYYY/MM/DD'),
638: to_date( to_char(oev.enrolment_start_date, 'YYYY/MM/DD') || ' ' || '00:00', 'YYYY/MM/DD HH24:MI'))
639: AND decode(oev.enrolment_end_date, NULL, to_date('4712/12/31','YYYY/MM/DD'),
640: to_date( to_char(oev.enrolment_end_date, 'YYYY/MM/DD') || ' ' || '23:59', 'YYYY/MM/DD HH24:MI'));

Line 645: l_start_date := ota_timezone_util.convert_date(trunc(sysdate)

641: -- and l_date <= nvl(course_end_date, l_date); -- Bug 4767809
642:
643: If upper(l_synchronous_flag) = 'N' then
644: -- l_start_date := sysdate;
645: l_start_date := ota_timezone_util.convert_date(trunc(sysdate)
646: , to_char(sysdate,'HH24:MI')
647: , ota_timezone_util.get_server_timezone_code
648: , l_timezone);
649: Else

Line 647: , ota_timezone_util.get_server_timezone_code

643: If upper(l_synchronous_flag) = 'N' then
644: -- l_start_date := sysdate;
645: l_start_date := ota_timezone_util.convert_date(trunc(sysdate)
646: , to_char(sysdate,'HH24:MI')
647: , ota_timezone_util.get_server_timezone_code
648: , l_timezone);
649: Else
650: If l_event_status = 'P' then
651: -- l_start_date := sysdate;

Line 652: l_start_date := ota_timezone_util.convert_date(trunc(sysdate)

648: , l_timezone);
649: Else
650: If l_event_status = 'P' then
651: -- l_start_date := sysdate;
652: l_start_date := ota_timezone_util.convert_date(trunc(sysdate)
653: , to_char(sysdate,'HH24:MI')
654: , ota_timezone_util.get_server_timezone_code
655: , l_timezone);
656: Else

Line 654: , ota_timezone_util.get_server_timezone_code

650: If l_event_status = 'P' then
651: -- l_start_date := sysdate;
652: l_start_date := ota_timezone_util.convert_date(trunc(sysdate)
653: , to_char(sysdate,'HH24:MI')
654: , ota_timezone_util.get_server_timezone_code
655: , l_timezone);
656: Else
657: l_start_date := to_date(to_char(l_event_end_date,'YYYY/MM/DD')
658: || ' ' || nvl(l_event_end_time,'23:59'), 'YYYY/MM/DD HH24:MI') ;

Line 2219: AND ota_timezone_util.convert_date(sysdate, to_char(sysdate,'HH24:MI'), p_server_timezone_code, OEV.timezone)

2215: AND OEV.Event_status in('N','P','F')
2216: AND OFR.delivery_mode_id = OCU.category_usage_id
2217: AND OCU.type ='DM'
2218: AND trunc(sysdate) BETWEEN nvl(OAV.start_date, trunc(sysdate)) AND nvl(OAV.end_date, trunc(sysdate+1))
2219: AND ota_timezone_util.convert_date(sysdate, to_char(sysdate,'HH24:MI'), p_server_timezone_code, OEV.timezone)
2220: BETWEEN to_date(to_char(nvl(OEV.enrolment_start_date,to_date('4712/12/31','YYYY/MM/DD')),'YYYY/MM/DD') || ' ' || '00:00' , 'YYYY/MM/DD HH24:MI')
2221: AND to_date(to_char(nvl(OEV.enrolment_end_date,to_date('4712/12/31','YYYY/MM/DD')),'YYYY/MM/DD') || ' ' || '23:59', 'YYYY/MM/DD HH24:MI')
2222: ORDER BY OEV.public_event_flag DESC;
2223:

Line 2246: AND ota_timezone_util.convert_date(sysdate, to_char(sysdate,'HH24:MI'), p_server_timezone_code, OEV.timezone)

2242: AND OEV.Event_status in('N','P','F')
2243: AND OFR.delivery_mode_id = OCU.category_usage_id
2244: AND OCU.type ='DM'
2245: AND trunc(sysdate) BETWEEN nvl(OAV.start_date, trunc(sysdate)) AND nvl(OAV.end_date, trunc(sysdate+1))
2246: AND ota_timezone_util.convert_date(sysdate, to_char(sysdate,'HH24:MI'), p_server_timezone_code, OEV.timezone)
2247: BETWEEN to_date(to_char(nvl(OEV.enrolment_start_date,to_date('4712/12/31','YYYY/MM/DD')),'YYYY/MM/DD') || ' ' || '00:00' , 'YYYY/MM/DD HH24:MI')
2248: AND to_date(to_char(nvl(OEV.enrolment_end_date,to_date('4712/12/31','YYYY/MM/DD')),'YYYY/MM/DD') || ' ' || '23:59', 'YYYY/MM/DD HH24:MI')
2249: AND nvl(OEV.event_availability, 'ALL') = 'ALL'
2250: ORDER BY OEV.public_event_flag DESC;

Line 2257: l_server_timezone_code := ota_timezone_util.get_server_timezone_code;

2253: l_server_timezone_code fnd_timezones_b.timezone_code%type;
2254: begin
2255:
2256: l_business_group_id := ota_general.get_business_group_id;
2257: l_server_timezone_code := ota_timezone_util.get_server_timezone_code;
2258:
2259: if(showLPOnlyClasses = 'Y') then
2260: for assoc in csr_classes_in_course(p_activity_version_id, l_business_group_id, l_server_timezone_code) loop
2261: if learner_can_enroll(p_person_id, p_party_id, assoc.event_id, assoc.public_event_flag, assoc.maximum_internal_attendees, assoc.course_start_date) = 'Y' then