APPS.CTO_UTILITY_PK dependencies on DBMS_LOCK

Line 6867: dbms_lock.allocate_unique(

6863: -- added expiration seconds equal to 1 day instead of
6864: -- the default 10 days
6865: -- ntungare
6866: --
6867: dbms_lock.allocate_unique(
6868: lockname => utl_raw.cast_to_raw(l_lock_name)
6869: ,lockhandle => l_lock_handle
6870: ,expiration_secs => 86400);
6871: return l_lock_handle;

Line 7034: x_lock_status := dbms_lock.request(

7030: --
7031: -- request lock with release_on_commit TRUE so that we dont have to manually
7032: -- release the lock later.
7033: --
7034: x_lock_status := dbms_lock.request(
7035: lockhandle => l_lock_handle
7036: ,lockmode => dbms_lock.x_mode
7037: ,timeout => dbms_lock.maxwait
7038: ,release_on_commit => TRUE);

Line 7036: ,lockmode => dbms_lock.x_mode

7032: -- release the lock later.
7033: --
7034: x_lock_status := dbms_lock.request(
7035: lockhandle => l_lock_handle
7036: ,lockmode => dbms_lock.x_mode
7037: ,timeout => dbms_lock.maxwait
7038: ,release_on_commit => TRUE);
7039:
7040: IF PG_DEBUG <> 0 THEN

Line 7037: ,timeout => dbms_lock.maxwait

7033: --
7034: x_lock_status := dbms_lock.request(
7035: lockhandle => l_lock_handle
7036: ,lockmode => dbms_lock.x_mode
7037: ,timeout => dbms_lock.maxwait
7038: ,release_on_commit => TRUE);
7039:
7040: IF PG_DEBUG <> 0 THEN
7041: oe_debug_pub.add ('lock_for_match: Returning from lock_for_match.');

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

7100: --get lock handle by calling helper function
7101: l_lock_handle := get_lock_handle( p_hash_string => p_hash_value);
7102:
7103:
7104: l_status := dbms_lock.release(l_lock_handle);
7105:
7106: --if success (status = 0) or session does not own lock (status=4),
7107: -- do nothing
7108: --if parameter error or illegal lock handle (internal error)