APPS.MSD_AW_RENAME dependencies on DBMS_LOCK

Line 113: dbms_lock.sleep(5); -- Sleep for 5 seconds to allow locks to get released

109:
110: end loop;
111:
112: close Attached_aws;
113: dbms_lock.sleep(5); -- Sleep for 5 seconds to allow locks to get released
114: exception
115: when others then
116: --null;
117: err_msg := 'Exception - '||aw_name||' - KILL SESSIONS - '||session_id ||'- '||SQLCODE||' -ERROR- '||SQLERRM;