Line 123: dbms_lock.sleep(3); --sleeping for no reason, but leave it anyway :-)
119:
120: l_playload_mesg varchar2(100);
121:
122: BEGIN 123: dbms_lock.sleep(3); --sleeping for no reason, but leave it anyway :-) 124:
125: IF (fa_asset_trace_pkg.g_use_utl_file = 'Y') THEN
126: if (nvl(fa_asset_trace_pkg.g_sla_only, 'N') = 'Y') then
127: l_filename := 'GTUSLA_'||replace(ltrim(rtrim(p_book)),' ','_') || '_' || replace(p_asset_number,' ','_') ||'.log';