[Home] [Help]
63: -- moving the insert stmt to the below procedure.So that we can keep the
64: -- lock handle till the end.Otherewise any commit or rollback will remove
65: -- the data in temp table.
66: /* if (l_status = 0) then
67: insert into mtl_onhand_lock_temp(LOCK_HANDLE) values(l_lock_handle);
68: end if; */
69: if (l_status <> 0 AND l_status <> 4) then
70: --Bug 6520517, changed AND to OR to avoid deadlock
71: if (l_status = 1 OR l_status = 2) then
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
92: , header_id)
93: VALUES (
94: x_lock_handle
104: BEGIN
105: IF (l_debug = 1 ) THEN /* Bug#5401181*/
106: inv_log_util.trace('Begin release locks.. ' , 'INV_TABLE_LOCK_PVT', 9);
107: END IF;
108: select lock_handle bulk collect into table_handle from mtl_onhand_lock_temp;
109: if (table_handle IS NULL OR table_handle.COUNT = 0) THEN
110: IF (l_debug = 1 ) THEN/* Bug#5401181*/
111: inv_log_util.trace('No user locks to Release' , 'INV_TABLE_LOCK_PVT', 9);
112: END IF;
122: inv_log_util.trace('Error in releasing the lock'||l_ret_status, 'INV_TABLE_LOCK_PVT', 9);
123: END IF;
124: end if;
125: end loop;
126: DELETE MTL_ONHAND_LOCK_TEMP;
127: end if;
128: END release_locks;
129:
130: --Bug #4338316
149: IF (l_debug = 1) /* Bug#5401181*/ THEN
150: inv_log_util.TRACE('In rel locks,wip_move= .. ' || wip_constants.wip_move_worker, 'INV_TABLE_LOCK_PVT', 9);
151: END IF;
152:
153: DELETE mtl_onhand_lock_temp
154: WHERE header_id = p_header_id;
155: END IF;
156: ELSE
157: SELECT lock_handle
155: END IF;
156: ELSE
157: SELECT lock_handle
158: BULK COLLECT INTO table_handle
159: FROM mtl_onhand_lock_temp
160: WHERE header_id = p_header_id;
161:
162: IF (table_handle IS NULL OR table_handle.COUNT = 0) THEN
163: IF (l_debug = 1 ) THEN/* Bug#5401181*/
177: END IF;
178: END IF;
179: END LOOP;
180:
181: DELETE mtl_onhand_lock_temp
182: WHERE header_id = p_header_id;
183: END IF;
184: END IF;
185: END release_locks;