APPS.ECX_DTD_UTILS SQL Statements

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

Line: 15

			delete 	from ecx_dtds
			where 	root_element = i_root_element
			and	( version = i_location or i_location is null )
			and	filename = i_filename;

Line: 20

			insert into ecx_dtds
				(
				dtd_id,
				root_element,
				filename,
				version,
				payload
				)
			values
				(
				ecx_dtd_s.nextval,
				i_root_element,
				i_filename,
				i_location,
				i_payload
				);

Line: 54

			delete 	from ecx_dtds
			where 	root_element = i_root_element
			and	filename = i_filename
			and	( version = i_location or i_location is null );

Line: 60

i_retmsg :=' DTD Successfully Deleted';

Line: 64

	i_retmsg := SQLERRM ||'   DTD cannot be deleted';