APPS.INV_RESERVATION_LOCK_PVT dependencies on DBMS_LOCK

Line 55: l_status := dbms_lock.request

51:
52: inv_log_util.trace('Lock Name is...:' ||l_lock_name , 'INV_RESERVATION_LOCK_PVT', 9);
53: inv_log_util.trace('Lock Handle is...:' ||l_lock_handle , 'INV_RESERVATION_LOCK_PVT', 9);
54:
55: l_status := dbms_lock.request
56: (
57: lockhandle => l_lock_handle
58: ,lockmode => dbms_lock.x_mode
59: ,timeout => dbms_lock.maxwait

Line 58: ,lockmode => dbms_lock.x_mode

54:
55: l_status := dbms_lock.request
56: (
57: lockhandle => l_lock_handle
58: ,lockmode => dbms_lock.x_mode
59: ,timeout => dbms_lock.maxwait
60: ,release_on_commit => TRUE);
61: -- l_status = 4.No need to insert into temp table when lock is already
62: -- owned by this session.it will become duplicate entry if we insert

Line 59: ,timeout => dbms_lock.maxwait

55: l_status := dbms_lock.request
56: (
57: lockhandle => l_lock_handle
58: ,lockmode => dbms_lock.x_mode
59: ,timeout => dbms_lock.maxwait
60: ,release_on_commit => TRUE);
61: -- l_status = 4.No need to insert into temp table when lock is already
62: -- owned by this session.it will become duplicate entry if we insert
63: -- and release lock may fail in this case for the second time.

Line 65: inv_log_util.trace('l_status returns from dbms_lock.request = ' || l_status, 'INV_RESERVATION_LOCK_PVT', 9);

61: -- l_status = 4.No need to insert into temp table when lock is already
62: -- owned by this session.it will become duplicate entry if we insert
63: -- and release lock may fail in this case for the second time.
64:
65: inv_log_util.trace('l_status returns from dbms_lock.request = ' || l_status, 'INV_RESERVATION_LOCK_PVT', 9);
66:
67: if (l_status <> 0 AND l_status <> 4) then
68: if (l_status = 1 OR l_status = 2) then
69: l_lock_status := 0;

Line 91: dbms_lock.allocate_unique

87:
88: PRAGMA AUTONOMOUS_TRANSACTION;
89: begin
90: inv_log_util.trace('p_lock_name = ' || p_lock_name, 'INV_RESERVATION_LOCK_PVT', 9);
91: dbms_lock.allocate_unique
92: (lockname => p_lock_name
93: ,lockhandle => x_lock_handle);
94: commit;
95: end;

Line 103: l_ret_status := dbms_lock.release(p_lock_handle);

99: l_ret_status NUMBER;
100: BEGIN
101: inv_log_util.trace('Begin release locks.. ' , 'INV_RESERVATION_LOCK_PVT', 9);
102:
103: l_ret_status := dbms_lock.release(p_lock_handle);
104: if l_ret_status = 0 then
105: inv_log_util.trace('Lock released successfully' , 'INV_RESERVATION_LOCK_PVT', 9);
106: else
107: inv_log_util.trace('Error in releasing the lock'||l_ret_status, 'INV_RESERVATION_LOCK_PVT', 9);