APPS.WMS_CONTAINER_PVT dependencies on DBMS_LOCK

Line 9548: dbms_lock.allocate_unique( lockname => p_type_name ,lockhandle => l_lock_handle);

9544: BEGIN
9545: IF (l_debug = 1) THEN
9546: mdebug('get lock handler ' ||p_type_name,4);
9547: END IF;
9548: dbms_lock.allocate_unique( lockname => p_type_name ,lockhandle => l_lock_handle);
9549: RETURN l_lock_handle;
9550: END get_lock_handle;
9551:
9552: PROCEDURE lock_org_lpn

Line 9584: x_err_code := dbms_lock.request(lockhandle => l_lock_handle ,

9580: IF(l_debug = 1) THEN
9581: mdebug('Got the lockhandle : '||l_lock_handle,4);
9582: END IF;
9583:
9584: x_err_code := dbms_lock.request(lockhandle => l_lock_handle ,
9585: lockmode => dbms_lock.x_mode ,
9586: timeout => 1 ,
9587: release_on_commit => TRUE);
9588:

Line 9585: lockmode => dbms_lock.x_mode ,

9581: mdebug('Got the lockhandle : '||l_lock_handle,4);
9582: END IF;
9583:
9584: x_err_code := dbms_lock.request(lockhandle => l_lock_handle ,
9585: lockmode => dbms_lock.x_mode ,
9586: timeout => 1 ,
9587: release_on_commit => TRUE);
9588:
9589: IF(l_debug = 1) THEN

Line 9590: mdebug('after dbms_lock.request execution completed x_err_code'||x_err_code,4);

9586: timeout => 1 ,
9587: release_on_commit => TRUE);
9588:
9589: IF(l_debug = 1) THEN
9590: mdebug('after dbms_lock.request execution completed x_err_code'||x_err_code,4);
9591: END IF;
9592:
9593: IF (x_err_code = 0 ) THEN
9594: g_lock_handle := l_lock_handle;