APPS.OTA_LEARNER_ACCESS_UTIL dependencies on OTA_TIMEZONE_UTIL

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

542: AND OEV.business_group_id = ota_general.get_business_group_id
543: AND OFR.delivery_mode_id = OCU.category_usage_id
544: AND OCU.type ='DM'
545: AND trunc(sysdate) BETWEEN nvl(trunc(OAV.start_date),trunc(sysdate)) AND nvl(trunc(OAV.end_date),trunc(sysdate+1))
546: AND ota_timezone_util.convert_date(sysdate, to_char(sysdate,'HH24:MI'), ota_timezone_util.get_server_timezone_code, OEV.timezone)
547: BETWEEN to_date(to_char(OEV.enrolment_start_date,'YYYY/MM/DD') || ' ' || '00:00' , 'YYYY/MM/DD HH24:MI')
548: 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')
549: AND OEV.event_type IN ('SCHEDULED','SELFPACED')
550: AND OEV.book_independent_flag = 'N'

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

650: event_type in ('SCHEDULED','SELFPACED') and
651: event_status in('P','N','F') and
652: -- l_date between nvl(enrolment_start_date, l_date) AND nvl(enrolment_end_date, l_date);
653: -- Modified for Bug#5107347
654: ota_timezone_util.convert_date(trunc(p_date),to_char(p_date,'HH24:MI'), ota_timezone_util.get_server_timezone_code , oev.timezone)
655: BETWEEN decode(oev.enrolment_start_date, NULL, to_date('0001/01/01','YYYY/MM/DD'),
656: to_date( to_char(oev.enrolment_start_date, 'YYYY/MM/DD') || ' ' || '00:00', 'YYYY/MM/DD HH24:MI'))
657: AND decode(oev.enrolment_end_date, NULL, to_date('4712/12/31','YYYY/MM/DD'),
658: to_date( to_char(oev.enrolment_end_date, 'YYYY/MM/DD') || ' ' || '23:59', 'YYYY/MM/DD HH24:MI'));

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

659: -- and l_date <= nvl(course_end_date, l_date); -- Bug 4767809
660:
661: If upper(l_synchronous_flag) = 'N' then
662: -- l_start_date := sysdate;
663: l_start_date := ota_timezone_util.convert_date(trunc(sysdate)
664: , to_char(sysdate,'HH24:MI')
665: , ota_timezone_util.get_server_timezone_code
666: , l_timezone);
667: Else

Line 665: , ota_timezone_util.get_server_timezone_code

661: If upper(l_synchronous_flag) = 'N' then
662: -- l_start_date := sysdate;
663: l_start_date := ota_timezone_util.convert_date(trunc(sysdate)
664: , to_char(sysdate,'HH24:MI')
665: , ota_timezone_util.get_server_timezone_code
666: , l_timezone);
667: Else
668: If l_event_status = 'P' then
669: -- l_start_date := sysdate;

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

666: , l_timezone);
667: Else
668: If l_event_status = 'P' then
669: -- l_start_date := sysdate;
670: l_start_date := ota_timezone_util.convert_date(trunc(sysdate)
671: , to_char(sysdate,'HH24:MI')
672: , ota_timezone_util.get_server_timezone_code
673: , l_timezone);
674: Else

Line 672: , ota_timezone_util.get_server_timezone_code

668: If l_event_status = 'P' then
669: -- l_start_date := sysdate;
670: l_start_date := ota_timezone_util.convert_date(trunc(sysdate)
671: , to_char(sysdate,'HH24:MI')
672: , ota_timezone_util.get_server_timezone_code
673: , l_timezone);
674: Else
675: l_start_date := to_date(to_char(l_event_end_date,'YYYY/MM/DD')
676: || ' ' || nvl(l_event_end_time,'23:59'), 'YYYY/MM/DD HH24:MI') ;