APPS.WIP_WS_UTIL dependencies on DBMS_LOCK

Line 1285: dbms_lock.allocate_unique(

1281: l_lock_name VARCHAR2(30);
1282: BEGIN
1283: l_lock_name := p_lock_prefix || p_org_id;
1284: trace_log('get_lock_handle: lock_name='||l_lock_name);
1285: dbms_lock.allocate_unique(
1286: lockname => l_lock_name
1287: ,lockhandle => l_lock_handle);
1288: trace_log('get_lock_handle: lock_handle='||l_lock_handle);
1289: return l_lock_handle;

Line 1308: x_lock_status := dbms_lock.request(

1304: l_lock_handle := get_lock_handle (p_org_id => p_org_id,
1305: p_lock_prefix => p_lock_prefix);
1306: -- request lock with release_on_commit TRUE so that we dont have to manually
1307: -- release the lock later.
1308: x_lock_status := dbms_lock.request(
1309: lockhandle => l_lock_handle,
1310: lockmode => dbms_lock.x_mode,
1311: timeout => dbms_lock.maxwait,
1312: release_on_commit => TRUE);

Line 1310: lockmode => dbms_lock.x_mode,

1306: -- request lock with release_on_commit TRUE so that we dont have to manually
1307: -- release the lock later.
1308: x_lock_status := dbms_lock.request(
1309: lockhandle => l_lock_handle,
1310: lockmode => dbms_lock.x_mode,
1311: timeout => dbms_lock.maxwait,
1312: release_on_commit => TRUE);
1313: trace_log('get_lock: got lock for lock handle with status ='||x_lock_status);
1314: trace_log('get_lock: Returning from lock_for_match');

Line 1311: timeout => dbms_lock.maxwait,

1307: -- release the lock later.
1308: x_lock_status := dbms_lock.request(
1309: lockhandle => l_lock_handle,
1310: lockmode => dbms_lock.x_mode,
1311: timeout => dbms_lock.maxwait,
1312: release_on_commit => TRUE);
1313: trace_log('get_lock: got lock for lock handle with status ='||x_lock_status);
1314: trace_log('get_lock: Returning from lock_for_match');
1315: EXCEPTION

Line 1344: l_status := dbms_lock.release(l_lock_handle);

1340: l_lock_handle := get_lock_handle(p_org_id => p_org_id,
1341: p_lock_prefix => p_lock_prefix);
1342: trace_log('release_lock: lock_handle='||l_lock_handle);
1343:
1344: l_status := dbms_lock.release(l_lock_handle);
1345: trace_log('release_lock: release returned with status:'||l_status);
1346:
1347: --if success (status = 0) or session does not own lock (status=4),
1348: -- do nothing