APPS.BISM_EXPORT_WRITER SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 10

select sys_guid() into oid1 from dual;

Line: 11

select sys_guid() into oid2 from dual;

Line: 16

FUNCTION insert_object(a_gname raw,a_guid raw, a_filename nvarchar2, a_data nclob,a_binary_data blob)
RETURN timestamp
IS
v_time timestamp;

Line: 32

SELECT text into v_clob FROM BISM_EXPORT WHERE
group_name=a_gname AND
group_id = a_guid AND
file_name = a_filename for update;

Line: 42

INSERT INTO BISM_EXPORT (GROUP_NAME, GROUP_ID, FILE_NAME, TIME_CREATED, TEXT, BINARYDATA) VALUES(a_gname,a_guid,a_filename,v_time,a_data,null);

Line: 46

SELECT binarydata into v_blob FROM BISM_EXPORT WHERE
group_name=a_gname AND
group_id = a_guid AND
file_name = a_filename for update;

Line: 56

INSERT INTO BISM_EXPORT (GROUP_NAME, GROUP_ID, FILE_NAME, TIME_CREATED, TEXT, BINARYDATA) VALUES(a_gname,a_guid,a_filename,v_time,null,a_binary_data);

Line: 66

PROCEDURE delete_object(a_gname raw,a_guid raw, a_filename nvarchar2)
IS
a_gname_is_not_null BOOLEAN := FALSE;

Line: 86

DELETE FROM BISM_EXPORT WHERE
group_name= a_gname AND
group_id = a_guid AND
file_name=a_filename;

Line: 91

DELETE FROM BISM_EXPORT WHERE
group_name= a_gname AND
file_name=a_filename;

Line: 95

DELETE FROM BISM_EXPORT WHERE
group_name= a_gname;

Line: 102

PROCEDURE delete_objects(a_timeinsecs integer )
IS
v_secs INTEGER;

Line: 120

SELECT
TO_CHAR(systimestamp,'HH24') * 60*60+
+ TO_CHAR(systimestamp,'MI') * 60
+ TO_CHAR(systimestamp,'SS') into v_secs FROM dual;

Line: 135

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

Line: 138

delete from bism_export where to_char(time_created, 'DD-MON-YY HH24.MI.SS') < v_temp;

Line: 168

OPEN v_rc FOR SELECT text,binarydata FROM BISM_EXPORT WHERE group_name = a_gname  and
group_id = a_guid and file_name = a_filename;

Line: 171

SELECT group_id into a_guid FROM BISM_EXPORT WHERE group_name = a_gname and file_name = a_filename;

Line: 172

OPEN v_rc FOR SELECT text,binarydata FROM BISM_EXPORT WHERE group_name = a_gname and  file_name = a_filename;

Line: 174

SELECT group_id into a_guid FROM BISM_EXPORT WHERE group_name = a_gname;

Line: 175

OPEN v_rc FOR SELECT text,binarydata FROM BISM_EXPORT WHERE group_name = a_gname and file_name = a_filename;