APPS.INV_TABLE_LOCK_PVT dependencies on DBMS_LOCK

Line 53: l_status := dbms_lock.request(

49: inv_log_util.trace('Lock Name is...:' ||l_lock_name , 'INV_TABLE_LOCK_PVT', 9);
50: inv_log_util.trace('Lock Handle is...:' ||l_lock_handle , 'INV_TABLE_LOCK_PVT', 9);
51: END IF;
52:
53: l_status := dbms_lock.request(
54: lockhandle => l_lock_handle
55: ,lockmode => dbms_lock.x_mode
56: ,timeout => dbms_lock.maxwait
57: ,release_on_commit => TRUE);

Line 55: ,lockmode => dbms_lock.x_mode

51: END IF;
52:
53: l_status := dbms_lock.request(
54: lockhandle => l_lock_handle
55: ,lockmode => dbms_lock.x_mode
56: ,timeout => dbms_lock.maxwait
57: ,release_on_commit => TRUE);
58: end if;
59: -- l_status = 4.No need to insert into temp table when lock is already

Line 56: ,timeout => dbms_lock.maxwait

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

Line 87: dbms_lock.allocate_unique(

83: , p_lock_name IN VARCHAR2
84: , x_lock_handle OUT NOCOPY VARCHAR2) IS
85: PRAGMA AUTONOMOUS_TRANSACTION;
86: BEGIN
87: dbms_lock.allocate_unique(
88: lockname => p_lock_name
89: , lockhandle => x_lock_handle);
90: INSERT INTO mtl_onhand_lock_temp(
91: lock_handle

Line 115: l_ret_status := dbms_lock.release(table_handle(i));

111: inv_log_util.trace('No user locks to Release' , 'INV_TABLE_LOCK_PVT', 9);
112: END IF;
113: else
114: for i in table_handle.FIRST .. table_handle.LAST loop
115: l_ret_status := dbms_lock.release(table_handle(i));
116: if l_ret_status = 0 then
117: IF (l_debug = 1 ) THEN /* Bug#5401181*/
118: inv_log_util.trace('Lock released successfully' , 'INV_TABLE_LOCK_PVT', 9);
119: END IF;

Line 168: l_ret_status := DBMS_LOCK.release(table_handle(i));

164: inv_log_util.TRACE('No user locks to Release', 'INV_TABLE_LOCK_PVT', 9);
165: END IF;
166: ELSE
167: FOR i IN table_handle.FIRST .. table_handle.LAST LOOP
168: l_ret_status := DBMS_LOCK.release(table_handle(i));
169:
170: IF l_ret_status = 0 THEN
171: IF (l_debug = 1 ) THEN/* Bug#5401181*/
172: inv_log_util.TRACE('Lock released successfully', 'INV_TABLE_LOCK_PVT', 9);