APPS.MSD_AW_RENAME SQL Statements

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

Line: 36

v_stmt_str := 'select sid as session_id, serial# as serial_no, owner as session_owner from ' ||
               'all_aws daws,v$aw_olap vawo,v$session '||
			    ' where  daws.aw_number=vawo.aw_number and sid=vawo.session_id  '||
				' and (daws.aw_name like ''%XWDEVKIT'' or daws.aw_name like ''%ODPCODE'')';

Line: 47

v_stmt_str1:= 'select 1  from all_aws where AW_NAME=''' || patch_edition_name||'''';

Line: 52

select user into current_user_name from dual;

Line: 82

  	dbms_aw.aw_delete(backup_name);

Line: 88

		err_msg := 'Delete BackUp- Backup for the AW '||aw_name||' does not exist ';

Line: 91

    err_msg := 'Delete BackUp- '||aw_name||' - '||SQLCODE||' -ERROR- '||SQLERRM;