APPS.INV_RESERVATION_LOCK_PVT dependencies on DBMS_LOCK

Line 63: l_status := dbms_lock.request

59:
60: inv_log_util.trace('Lock Name is...:' ||l_lock_name , 'INV_RESERVATION_LOCK_PVT', 9);
61: inv_log_util.trace('Lock Handle is...:' ||l_lock_handle , 'INV_RESERVATION_LOCK_PVT', 9);
62:
63: l_status := dbms_lock.request
64: (
65: lockhandle => l_lock_handle
66: ,lockmode => dbms_lock.x_mode
67: ,timeout => dbms_lock.maxwait

Line 66: ,lockmode => dbms_lock.x_mode

62:
63: l_status := dbms_lock.request
64: (
65: lockhandle => l_lock_handle
66: ,lockmode => dbms_lock.x_mode
67: ,timeout => dbms_lock.maxwait
68: ,release_on_commit => TRUE);
69: -- l_status = 4.No need to insert into temp table when lock is already
70: -- owned by this session.it will become duplicate entry if we insert

Line 67: ,timeout => dbms_lock.maxwait

63: l_status := dbms_lock.request
64: (
65: lockhandle => l_lock_handle
66: ,lockmode => dbms_lock.x_mode
67: ,timeout => dbms_lock.maxwait
68: ,release_on_commit => TRUE);
69: -- l_status = 4.No need to insert into temp table when lock is already
70: -- owned by this session.it will become duplicate entry if we insert
71: -- and release lock may fail in this case for the second time.

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

69: -- l_status = 4.No need to insert into temp table when lock is already
70: -- owned by this session.it will become duplicate entry if we insert
71: -- and release lock may fail in this case for the second time.
72:
73: inv_log_util.trace('l_status returns from dbms_lock.request = ' || l_status, 'INV_RESERVATION_LOCK_PVT', 9);
74:
75: if (l_status <> 0 AND l_status <> 4) then
76: if (l_status = 1 OR l_status = 2) then
77: l_lock_status := 0;

Line 99: dbms_lock.allocate_unique

95:
96: PRAGMA AUTONOMOUS_TRANSACTION;
97: begin
98: inv_log_util.trace('p_lock_name = ' || p_lock_name, 'INV_RESERVATION_LOCK_PVT', 9);
99: dbms_lock.allocate_unique
100: (lockname => p_lock_name
101: ,lockhandle => x_lock_handle);
102: commit;
103: end;

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

107: l_ret_status NUMBER;
108: BEGIN
109: inv_log_util.trace('Begin release locks.. ' , 'INV_RESERVATION_LOCK_PVT', 9);
110:
111: l_ret_status := dbms_lock.release(p_lock_handle);
112: if l_ret_status = 0 then
113: inv_log_util.trace('Lock released successfully' , 'INV_RESERVATION_LOCK_PVT', 9);
114: else
115: inv_log_util.trace('Error in releasing the lock'||l_ret_status, 'INV_RESERVATION_LOCK_PVT', 9);