APPS.CTO_UTILITY_PK dependencies on DBMS_LOCK

Line 6891: dbms_lock.allocate_unique(

6887: -- added expiration seconds equal to 1 day instead of
6888: -- the default 10 days
6889: -- ntungare
6890: --
6891: dbms_lock.allocate_unique(
6892: lockname => utl_raw.cast_to_raw(l_lock_name)
6893: ,lockhandle => l_lock_handle
6894: ,expiration_secs => 86400);
6895: return l_lock_handle;

Line 7058: x_lock_status := dbms_lock.request(

7054: --
7055: -- request lock with release_on_commit TRUE so that we dont have to manually
7056: -- release the lock later.
7057: --
7058: x_lock_status := dbms_lock.request(
7059: lockhandle => l_lock_handle
7060: ,lockmode => dbms_lock.x_mode
7061: ,timeout => dbms_lock.maxwait
7062: ,release_on_commit => TRUE);

Line 7060: ,lockmode => dbms_lock.x_mode

7056: -- release the lock later.
7057: --
7058: x_lock_status := dbms_lock.request(
7059: lockhandle => l_lock_handle
7060: ,lockmode => dbms_lock.x_mode
7061: ,timeout => dbms_lock.maxwait
7062: ,release_on_commit => TRUE);
7063:
7064: IF PG_DEBUG <> 0 THEN

Line 7061: ,timeout => dbms_lock.maxwait

7057: --
7058: x_lock_status := dbms_lock.request(
7059: lockhandle => l_lock_handle
7060: ,lockmode => dbms_lock.x_mode
7061: ,timeout => dbms_lock.maxwait
7062: ,release_on_commit => TRUE);
7063:
7064: IF PG_DEBUG <> 0 THEN
7065: oe_debug_pub.add ('lock_for_match: Returning from lock_for_match.');

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

7124: --get lock handle by calling helper function
7125: l_lock_handle := get_lock_handle( p_hash_string => p_hash_value);
7126:
7127:
7128: l_status := dbms_lock.release(l_lock_handle);
7129:
7130: --if success (status = 0) or session does not own lock (status=4),
7131: -- do nothing
7132: --if parameter error or illegal lock handle (internal error)