APPS.MSD_COMMON_UTILITIES dependencies on DBMS_LOB

Line 1178: aw_command := dbms_lob.substr(dbms_aw_interp(aw_command));

1174: aw_command varchar2(4000);
1175: begin
1176: -- construct dml command
1177: aw_command := 'shw nafill(filterlines(aw(list) if value eq ''EXPRESS'' then na else joinchars(''aw detach noq '' value '';'')) '' '')';
1178: aw_command := dbms_lob.substr(dbms_aw_interp(aw_command));
1179: -- execute detach commands
1180: dbms_aw_interp_silent(aw_command);
1181: execute immediate 'begin dbms_aw.shutdown;end;';
1182: end detach_all_aws;