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 112: l_status := dbms_lock.request(

108: l_lock_name := 'INV_MLN_' || p_organization_id || '_' || p_inventory_item_id || '_' || p_lot;
109:
110: get_lot_lock_handle( l_lock_name, x_lock_handle);
111:
112: l_status := dbms_lock.request(
113: lockhandle => x_lock_handle
114: ,lockmode => dbms_lock.x_mode
115: ,timeout => dbms_lock.maxwait
116: ,release_on_commit => TRUE);

Line 114: ,lockmode => dbms_lock.x_mode

110: get_lot_lock_handle( l_lock_name, x_lock_handle);
111:
112: l_status := dbms_lock.request(
113: lockhandle => x_lock_handle
114: ,lockmode => dbms_lock.x_mode
115: ,timeout => dbms_lock.maxwait
116: ,release_on_commit => TRUE);
117: END;
118:

Line 115: ,timeout => dbms_lock.maxwait

111:
112: l_status := dbms_lock.request(
113: lockhandle => x_lock_handle
114: ,lockmode => dbms_lock.x_mode
115: ,timeout => dbms_lock.maxwait
116: ,release_on_commit => TRUE);
117: END;
118:
119: -- Bug 6636261: Acquiring lock handle for a row in MLN

Line 126: dbms_lock.allocate_unique(

122: PRAGMA AUTONOMOUS_TRANSACTION;
123:
124: BEGIN
125:
126: dbms_lock.allocate_unique(
127: lockname => p_lock_name
128: ,lockhandle => x_lock_handle);
129:
130: END;

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

146: inv_log_util.trace('No user locks to Release' , 'INV_TABLE_LOCK_PVT', 9);
147: END IF;
148: else
149: for i in table_handle.FIRST .. table_handle.LAST loop
150: l_ret_status := dbms_lock.release(table_handle(i));
151: if l_ret_status = 0 then
152: IF (l_debug = 1 ) THEN /* Bug#5401181*/
153: inv_log_util.trace('Lock released successfully' , 'INV_TABLE_LOCK_PVT', 9);
154: END IF;

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

199: inv_log_util.TRACE('No user locks to Release', 'INV_TABLE_LOCK_PVT', 9);
200: END IF;
201: ELSE
202: FOR i IN table_handle.FIRST .. table_handle.LAST LOOP
203: l_ret_status := DBMS_LOCK.release(table_handle(i));
204:
205: IF l_ret_status = 0 THEN
206: IF (l_debug = 1 ) THEN/* Bug#5401181*/
207: inv_log_util.TRACE('Lock released successfully', 'INV_TABLE_LOCK_PVT', 9);