DBA Data[Home] [Help]

APPS.FA_ASSET_TRACE_PKG dependencies on DBMS_LOCK

Line 111: dbms_lock.sleep(3); --sleeping for no reason, but leave it anyway :-)

107: error_found1 EXCEPTION;
108: error_found2 EXCEPTION;
109:
110: BEGIN
111: dbms_lock.sleep(3); --sleeping for no reason, but leave it anyway :-)
112:
113: IF (fa_asset_trace_pkg.g_use_utl_file = 'Y') THEN
114: if (nvl(fa_asset_trace_pkg.g_sla_only, 'N') = 'Y') then
115: l_filename := 'GTUSLA_'||replace(ltrim(rtrim(p_book)),' ','_') || '_' || replace(p_asset_number,' ','_') ||'.log';