APPS.PA_RESOURCE_UTILS dependencies on DBMS_LOCK

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

3716: END get_resource_type;
3717:
3718:
3719: -- This function returns a lock handle for retrieving
3720: -- and releasing a dbms_lock. We have made it as
3721: -- an autonomous transaction because it issues a commit.
3722: -- However, requesting and releasing a lock does not
3723: -- issue a commit;
3724: PROCEDURE allocate_unique(p_lock_name IN VARCHAR2,

Line 3729: dbms_lock.allocate_unique(

3725: p_lock_handle OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
3726: IS
3727: PRAGMA AUTONOMOUS_TRANSACTION;
3728: BEGIN
3729: dbms_lock.allocate_unique(
3730: lockname => p_lock_name,
3731: lockhandle => p_lock_handle);
3732: commit;
3733:

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

3775: p_lock_handle =>lockhndl);
3776:
3777: IF ( lockhndl IS NOT NULL ) then
3778: /* Request the lock */
3779: lock_status := dbms_lock.request( lockhandle => lockhndl,
3780: lockmode => lock_mode,
3781: release_on_commit => lock_CommitMode,
3782: timeout => 1);
3783:

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

3828: p_lock_name =>lock_name,
3829: p_lock_handle =>lockhndl);
3830:
3831: IF ( lockhndl IS NOT NULL ) then
3832: lock_status := dbms_lock.release(lockhandle =>lockhndl);
3833:
3834: IF ( lock_status = 0 ) then -- Got the lock
3835: Return 0;
3836: ELSE