APPS.BISM_EXPORT_WRITER dependencies on DUAL

Line 10: select sys_guid() into oid1 from dual;

6: oid1 raw(16);
7: oid2 raw(16);
8: BEGIN
9:
10: select sys_guid() into oid1 from dual;
11: select sys_guid() into oid2 from dual;
12: return oid1||oid2;
13:
14: END;

Line 11: select sys_guid() into oid2 from dual;

7: oid2 raw(16);
8: BEGIN
9:
10: select sys_guid() into oid1 from dual;
11: select sys_guid() into oid2 from dual;
12: return oid1||oid2;
13:
14: END;
15:

Line 123: + TO_CHAR(systimestamp,'SS') into v_secs FROM dual;

119: -- time in secs since the beginning of the day
120: SELECT
121: TO_CHAR(systimestamp,'HH24') * 60*60+
122: + TO_CHAR(systimestamp,'MI') * 60
123: + TO_CHAR(systimestamp,'SS') into v_secs FROM dual;
124:
125: v_secs := v_secs - a_timeinsecs;
126:
127: -- reconstruct the time after substracting the time duration

Line 135: SELECT to_timestamp(v_temp, 'DD-MON-YY HH24.MI.SS') into v_timestamp from dual;

131: -- stage it as character data
132: v_temp := to_char(sysdate,'DD-MON-YY') || ' '|| v_hour||'.'||v_min||'.'||v_sec;
133: -- create timestamp
134:
135: SELECT to_timestamp(v_temp, 'DD-MON-YY HH24.MI.SS') into v_timestamp from dual;
136: -- delete the objects
137:
138: delete from bism_export where to_char(time_created, 'DD-MON-YY HH24.MI.SS') < v_temp;
139: COMMIT;