[Home] [Help]
1214: l_lock_handle VARCHAR2(128);
1215: BEGIN
1216: l_lock_name := 'FND.FLEX.VSET.HIERARCHY_COMPILER.' || p_lock_name;
1217: l_lock_handle := null;
1218: fnd_flex_server.request_lock(l_lock_name, l_lock_handle);
1219: x_lock_handle := l_lock_handle;
1220: END request_lock;
1221:
1222:
1224: p_lock_handle IN VARCHAR2)
1225: IS
1226: BEGIN
1227: IF (p_lock_handle IS NOT NULL) THEN
1228: fnd_flex_server.release_lock(p_lock_name, p_lock_handle);
1229: END IF;
1230: END release_lock;
1231:
1232:
1359: with orig vsetid and then we update the vsetid*(-1) with the
1360: orig vsetid. After that is done, we release the lock. If another
1361: process wants to read the hier security data it cannot until the
1362: lock is released. At this time the only code that is reading the
1363: hier rules data is fnd_flex_server.check_value_security and
1364: this is called in FND_FLEX_SERVER1.check_security. In the function
1365: check_security() we check to see if a lock exists and if there is a
1366: lock we do not process until the lock is released meaning the data
1367: is now updated and correct.
1360: orig vsetid. After that is done, we release the lock. If another
1361: process wants to read the hier security data it cannot until the
1362: lock is released. At this time the only code that is reading the
1363: hier rules data is fnd_flex_server.check_value_security and
1364: this is called in FND_FLEX_SERVER1.check_security. In the function
1365: check_security() we check to see if a lock exists and if there is a
1366: lock we do not process until the lock is released meaning the data
1367: is now updated and correct.
1368: *******************************************************************/