APPS.PA_RESOURCE_UTILS dependencies on DBMS_LOCK

Line 4056: -- and releasing a dbms_lock. We have made it as

4052: END get_resource_type;
4053:
4054:
4055: -- This function returns a lock handle for retrieving
4056: -- and releasing a dbms_lock. We have made it as
4057: -- an autonomous transaction because it issues a commit.
4058: -- However, requesting and releasing a lock does not
4059: -- issue a commit;
4060: PROCEDURE allocate_unique(p_lock_name IN VARCHAR2,

Line 4065: dbms_lock.allocate_unique(

4061: p_lock_handle OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
4062: IS
4063: PRAGMA AUTONOMOUS_TRANSACTION;
4064: BEGIN
4065: dbms_lock.allocate_unique(
4066: lockname => p_lock_name,
4067: lockhandle => p_lock_handle);
4068: commit;
4069:

Line 4115: lock_status := dbms_lock.request( lockhandle => lockhndl,

4111: p_lock_handle =>lockhndl);
4112:
4113: IF ( lockhndl IS NOT NULL ) then
4114: /* Request the lock */
4115: lock_status := dbms_lock.request( lockhandle => lockhndl,
4116: lockmode => lock_mode,
4117: release_on_commit => lock_CommitMode,
4118: timeout => 1);
4119:

Line 4168: lock_status := dbms_lock.release(lockhandle =>lockhndl);

4164: p_lock_name =>lock_name,
4165: p_lock_handle =>lockhndl);
4166:
4167: IF ( lockhndl IS NOT NULL ) then
4168: lock_status := dbms_lock.release(lockhandle =>lockhndl);
4169:
4170: IF ( lock_status = 0 ) then -- Got the lock
4171: Return 0;
4172: ELSE