DBA Data[Home] [Help]

APPS.GL_JAHE_PKG dependencies on DBMS_LOCK

Line 432: dbms_lock.allocate_unique( lkname, lkhandle, expiration_secs );

428: -- generate the name for the user-defined lock
429: lkname := 'FND_FLEX_AHE_VS_' || to_char(fvsid);
430:
431: -- get Oracle-assigned lock handle
432: dbms_lock.allocate_unique( lkname, lkhandle, expiration_secs );
433:
434: -- request a lock in the ROW SHARE mode
435: lkresult := dbms_lock.request( lkhandle, rs_mode, timout, TRUE );
436:

Line 435: lkresult := dbms_lock.request( lkhandle, rs_mode, timout, TRUE );

431: -- get Oracle-assigned lock handle
432: dbms_lock.allocate_unique( lkname, lkhandle, expiration_secs );
433:
434: -- request a lock in the ROW SHARE mode
435: lkresult := dbms_lock.request( lkhandle, rs_mode, timout, TRUE );
436:
437: if ( lkresult = 0 ) then
438: -- locking was successful
439: return;

Line 446: fnd_message.set_name('FND', 'FLEX-AHE DBMS_LOCK ERROR');

442: -- print out appropriate warning message
443: fnd_message.set_name('FND', 'FLEX-AHE LOCKING VSET');
444: app_exception.raise_exception;
445: else
446: fnd_message.set_name('FND', 'FLEX-AHE DBMS_LOCK ERROR');
447: app_exception.raise_exception;
448: end if;
449:
450: