APPS.BISM_EXPORT_READER SQL Statements

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

Line: 3

PROCEDURE delete_objects(a_timeinsecs integer)
IS
v_secs INTEGER;

Line: 21

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

Line: 36

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

Line: 38

EXECUTE IMMEDIATE 'delete from bism_export_temp where to_char(time_created, ''DD-MON-YY HH24.MI.SS'') < :1' using v_temp;

Line: 48

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

Line: 74

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

Line: 75

EXECUTE IMMEDIATE 'DELETE FROM BISM_EXPORT_TEMP WHERE group_name= :1 AND group_id = :2 AND file_name = :3' using a_gname , a_guid, a_filename;

Line: 77

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

Line: 78

EXECUTE IMMEDIATE 'DELETE FROM BISM_EXPORT_TEMP WHERE group_name= :1 AND file_name = :2' using a_gname , a_filename;

Line: 80

DELETE FROM BISM_EXPORT WHERE group_name= a_gname;

Line: 81

EXECUTE IMMEDIATE 'DELETE FROM BISM_EXPORT_TEMP WHERE group_name= :1' using a_gname;

Line: 123

v_publishdata := 'INSERT into BISM_EXPORT_TEMP(GROUP_NAME, GROUP_ID, FILE_NAME, TIME_CREATED, TEXT, BINARYDATA) '||
                  'values (:1,:2,:3, '||
									'(SELECT time_created FROM bism_export WHERE '||
   										'group_name = :4 and '||
	 										'group_id = :5 AND ' ||
	 										'file_name = :6 ),'||
	  							'(SELECT text FROM bism_export WHERE '||
   										'group_name = :7 and '||
	 										'group_id = :8 AND ' ||
	 										'file_name = :9 ),'||
                  '(SELECT binarydata FROM bism_export WHERE '||
   										'group_name = :10 and '||
	 										'group_id = :11 AND ' ||
	 										'file_name = :12 ) )';

Line: 139

v_query := 'SELECT text,binarydata FROM BISM_EXPORT_TEMP WHERE '||
						'group_name = '||''''|| a_gname ||''''||' and '||
						'group_id = '|| '''' || a_guid || ''''||' and '||
						'file_name = '|| '''' || a_filename || '''';

Line: 157

v_publishdata := 'INSERT into BISM_EXPORT_TEMP(GROUP_NAME, GROUP_ID, FILE_NAME, TIME_CREATED, TEXT, BINARYDATA) '||
	 								'values (:1,null,:2, '||
	 								'(select time_created from bism_export WHERE '||
   								'group_name = :3 and file_name =  :4),'||
	  							'(SELECT text FROM bism_export WHERE '||
   								'group_name = :5 and '||
	 								'file_name =  :6),'||
                  '(SELECT binarydata FROM bism_export WHERE '||
   								'group_name = :7 and '||
	 								'file_name =  :8))';

Line: 168

v_query := 'SELECT text,binarydata FROM BISM_EXPORT_TEMP WHERE '||
						'group_name = '|| '''' || a_gname||''''||' and '||
						'file_name = '|| '''' || a_filename || '''';

Line: 172

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

Line: 186

v_publishdata := 'INSERT into BISM_EXPORT_TEMP(GROUP_NAME, GROUP_ID, FILE_NAME, TIME_CREATED, TEXT, BINARYDATA) '||
	 								'values (:1,null,null, '||
	 								'(SELECT time_created FROM bism_export WHERE '||
   								'group_name = :2), '||
	  							'(SELECT text FROM bism_export WHERE '||
   								'group_name = :3), null)';

Line: 193

v_query := 'SELECT text FROM BISM_EXPORT_TEMP WHERE '||
						'group_name = '|| '''' || a_gname||'''';

Line: 196

SELECT group_id into a_guid FROM BISM_EXPORT WHERE group_name = a_gname ;