APPS.WSH_OPSM_ASN_BE_PKG dependencies on DUAL

Line 159: SELECT SYSTIMESTAMP INTO l_start_time FROM dual;

155: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
156: --DECLARE
157: --l_start_time TIMESTAMP;
158: BEGIN
159: SELECT SYSTIMESTAMP INTO l_start_time FROM dual;
160: l_start_timec := TO_CHAR(l_start_time, 'DD-MON-YYYY HH24:MI:SSxFF');
161:
162: FND_LOG.String(
163: LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

Line 1042: SELECT SYSTIMESTAMP INTO l_end_time FROM dual;

1038: --l_end_time TIMESTAMP;
1039: l_time_diff INTERVAL DAY TO SECOND;
1040: --l_time_diff_secs NUMBER;
1041: BEGIN
1042: SELECT SYSTIMESTAMP INTO l_end_time FROM dual;
1043: l_end_timec := TO_CHAR(l_end_time, 'DD-MON-YYYY HH24:MI:SSxFF');
1044:
1045: FND_LOG.String(
1046: LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

Line 1050: SELECT (l_end_time-l_start_time) INTO l_time_diff FROM dual;

1046: LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
1047: MESSAGE => 'end time= '||TO_CHAR(l_end_time, 'DD-MON-YYYY HH24:MI:SSxFF'),
1048: MODULE => 'opsmperf.end');
1049:
1050: SELECT (l_end_time-l_start_time) INTO l_time_diff FROM dual;
1051:
1052: l_time_diff_secs := to_number(extract(second from l_time_diff)) +
1053: to_number(extract(minute from l_time_diff)) * 60 +
1054: to_number(extract(hour from l_time_diff)) * 60 * 60 +

Line 1226: SELECT SYSTIMESTAMP INTO l_start_time FROM dual;

1222: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1223: --DECLARE
1224: --l_start_time TIMESTAMP;
1225: BEGIN
1226: SELECT SYSTIMESTAMP INTO l_start_time FROM dual;
1227: l_start_timec := TO_CHAR(l_start_time, 'DD-MON-YYYY HH24:MI:SSxFF');
1228:
1229: FND_LOG.String(
1230: LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

Line 2105: SELECT SYSTIMESTAMP INTO l_end_time FROM dual;

2101: --l_end_time TIMESTAMP;
2102: l_time_diff INTERVAL DAY TO SECOND;
2103: --l_time_diff_secs NUMBER;
2104: BEGIN
2105: SELECT SYSTIMESTAMP INTO l_end_time FROM dual;
2106: l_end_timec := TO_CHAR(l_end_time, 'DD-MON-YYYY HH24:MI:SSxFF');
2107:
2108: FND_LOG.String(
2109: LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

Line 2113: SELECT (l_end_time-l_start_time) INTO l_time_diff FROM dual;

2109: LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
2110: MESSAGE => 'end time= '||TO_CHAR(l_end_time, 'DD-MON-YYYY HH24:MI:SSxFF'),
2111: MODULE => 'opsmperf.end');
2112:
2113: SELECT (l_end_time-l_start_time) INTO l_time_diff FROM dual;
2114:
2115: l_time_diff_secs := to_number(extract(second from l_time_diff)) +
2116: to_number(extract(minute from l_time_diff)) * 60 +
2117: to_number(extract(hour from l_time_diff)) * 60 * 60 +