DBA Data[Home] [Help]

APPS.FII_FIN_CAT_MAINTAIN_PKG dependencies on DBMS_LOCK

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

131: -- generate the name for the user-defined lock
132: lkname := 'FND_FLEX_AHE_VS_' || to_char(fvsid);
133:
134: -- get Oracle-assigned lock handle
135: dbms_lock.allocate_unique( lkname, lkhandle, expiration_secs );
136:
137: -- request a lock in the ROW SHARE mode
138: lkresult := dbms_lock.request( lkhandle, rs_mode, timout, TRUE );
139:

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

134: -- get Oracle-assigned lock handle
135: dbms_lock.allocate_unique( lkname, lkhandle, expiration_secs );
136:
137: -- request a lock in the ROW SHARE mode
138: lkresult := dbms_lock.request( lkhandle, rs_mode, timout, TRUE );
139:
140: if ( lkresult = 0 ) then
141: -- locking was successful
142: return;