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_ILEARNING dependencies on DUAL

Line 191: select trunc(sysdate) into l_sysdate from dual;

187: end if;
188: close cur_get_activity_version_name;
189:
190: /* for Bug 2201416 Added Trunc when selecting sysdate */
191: select trunc(sysdate) into l_sysdate from dual;
192:
193: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Insert Activity with rco_id - '|| p_rco_id);
194: -- Create activity_version
195:

Line 286: select trunc(sysdate) into l_sysdate from dual;

282: -- ,p_rco_id => p_rco_id -- (Input)
283: ,P_validate => false); -- (Input)
284:
285: --Bug 2984480 - arkashya MLS Changes calls to _TL row handler for insert
286: select trunc(sysdate) into l_sysdate from dual;
287: ota_avt_upd.upd_tl
288: (
289: P_effective_date => l_sysdate
290: ,P_language_code => USERENV('LANG')

Line 420: select trunc(sysdate) into l_sysdate from dual;

416: -- ,p_rco_id => p_rco_id -- (Input)
417: ,P_validate => false); -- (Input)
418:
419: --Bug 2984480 - arkashya MLS Changes calls to _TL row handler for Update
420: select trunc(sysdate) into l_sysdate from dual;
421: ota_avt_upd.upd_tl
422: (
423: P_effective_date => l_sysdate
424: ,P_language_code => USERENV('LANG')

Line 627: dual;

623: --Bug#2324698 hdshah changed to MI instead of MM
624: -- to_char(l_date,'HH24:MM')
625: to_char(l_date,'HH24:MI')
626: from
627: dual;
628:
629:
630: cursor cur_check_cat_inclusions is
631: select

Line 714: select to_date('31/12/4712','DD/MM/YYYY') into l_course_end_date from dual;

710: l_event_type := 'SELFPACED';
711: end if; -- if offering type
712:
713: if p_offering_end_date is NULL then --if offering end date is null
714: select to_date('31/12/4712','DD/MM/YYYY') into l_course_end_date from dual;
715: l_course_end_time := '23:59';
716: else
717: open cur_get_date_time(p_offering_end_date);
718: fetch cur_get_date_time into l_course_end_date, l_course_end_time;

Line 1014: select trunc(sysdate) into l_sysdate from dual;

1010: ,P_VALIDATE => false -- (Input)
1011: );
1012:
1013: --Bug 2984480 - arkashya MLS Changes calls to _TL row handler for insert
1014: select trunc(sysdate) into l_sysdate from dual;
1015: OTA_ENT_INS.INS_TL
1016: (
1017: p_effective_date => l_sysdate
1018: ,p_language_code => USERENV('LANG')

Line 1287: select sysdate into l_sysdate from dual;

1283: else
1284: l3_enrollment_end_date := l_enrollment_end_date;
1285: end if;
1286:
1287: select sysdate into l_sysdate from dual;
1288:
1289: open cur_check_enroll_exist;
1290: fetch cur_check_enroll_exist into l_no_of_enrollments;
1291: close cur_check_enroll_exist;

Line 1328: select sysdate into l_sysdate from dual;

1324: -- if Auto Waitlist Active profile is turned ON
1325: if ('Y' = FND_PROFILE.VALUE('OTA_AUTO_WAITLIST_ACTIVE')) then
1326:
1327:
1328: select sysdate into l_sysdate from dual;
1329: l_diff_hours := l_course_start_date_time - l_sysdate ;
1330: l_diff_hours := l_diff_hours * 24 ;
1331: l_waitlist_hours := FND_PROFILE.VALUE('OTA_AUTO_WAITLIST_DAYS');
1332:

Line 1340: SELECT to_char(sysdate,'DD/MM/YYYY:HH24:MI:SS') INTO l_sysdatetime FROM dual;

1336:
1337: -- send notification to event owner if waitlist candidates > 0
1338: if l_waitlist_size > 0 then
1339: -- send notification
1340: SELECT to_char(sysdate,'DD/MM/YYYY:HH24:MI:SS') INTO l_sysdatetime FROM dual;
1341: -- SELECT to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS') INTO l_sysdatetime FROM dual;
1342:
1343: if l_owner_id is null then
1344: OPEN CUR_USER(l_default_event_owner_id);

Line 1341: -- SELECT to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS') INTO l_sysdatetime FROM dual;

1337: -- send notification to event owner if waitlist candidates > 0
1338: if l_waitlist_size > 0 then
1339: -- send notification
1340: SELECT to_char(sysdate,'DD/MM/YYYY:HH24:MI:SS') INTO l_sysdatetime FROM dual;
1341: -- SELECT to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS') INTO l_sysdatetime FROM dual;
1342:
1343: if l_owner_id is null then
1344: OPEN CUR_USER(l_default_event_owner_id);
1345: else

Line 1378: SELECT to_char(sysdate,'DD/MM/YYYY:HH24:MI:SS') INTO l_sysdatetime FROM dual;

1374:
1375: -- send notification to event owner if waitlist candidates > 0
1376: if l_waitlist_size > 0 then
1377: -- send notification
1378: SELECT to_char(sysdate,'DD/MM/YYYY:HH24:MI:SS') INTO l_sysdatetime FROM dual;
1379: -- SELECT to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS') INTO l_sysdatetime FROM dual;
1380:
1381: if l_owner_id is null then
1382: OPEN CUR_USER(l_default_event_owner_id);

Line 1379: -- SELECT to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS') INTO l_sysdatetime FROM dual;

1375: -- send notification to event owner if waitlist candidates > 0
1376: if l_waitlist_size > 0 then
1377: -- send notification
1378: SELECT to_char(sysdate,'DD/MM/YYYY:HH24:MI:SS') INTO l_sysdatetime FROM dual;
1379: -- SELECT to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS') INTO l_sysdatetime FROM dual;
1380:
1381: if l_owner_id is null then
1382: OPEN CUR_USER(l_default_event_owner_id);
1383: else

Line 1463: select trunc(sysdate) into l_sysdate from dual;

1459: );
1460:
1461:
1462: --Bug 2984480 - arkashya MLS Changes calls to _TL row handler for
1463: select trunc(sysdate) into l_sysdate from dual;
1464: OTA_ENT_UPD.UPD_TL
1465: (
1466: p_effective_date => l_sysdate
1467: ,p_language_code => USERENV('LANG')

Line 1876: select sysdate into l_sysdate from dual;

1872:
1873: begin
1874: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Entering:' || l_proc);
1875:
1876: select sysdate into l_sysdate from dual;
1877:
1878: -- if (p_start_date is null) or (p_end_date is null) or (p_start_date > p_end_date) or (p_end_date > l_sysdate) then
1879: if (pl_start_date is null) or (pl_end_date is null) or (pl_start_date > pl_end_date) or (pl_end_date > l_sysdate) then
1880: l_status := 'F';