[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
139: BEGIN
140: IF (l_debug = 1 ) THEN /* Bug#5401181*/
141: inv_log_util.trace('Begin release locks.. ' , 'INV_TABLE_LOCK_PVT', 9);
142: END IF;
143: select lock_handle bulk collect into table_handle from mtl_onhand_lock_temp;
144: if (table_handle IS NULL OR table_handle.COUNT = 0) THEN
145: IF (l_debug = 1 ) THEN/* Bug#5401181*/
146: inv_log_util.trace('No user locks to Release' , 'INV_TABLE_LOCK_PVT', 9);
147: END IF;
157: inv_log_util.trace('Error in releasing the lock'||l_ret_status, 'INV_TABLE_LOCK_PVT', 9);
158: END IF;
159: end if;
160: end loop;
161: DELETE MTL_ONHAND_LOCK_TEMP;
162: end if;
163: END release_locks;
164:
165: --Bug #4338316
184: IF (l_debug = 1) /* Bug#5401181*/ THEN
185: inv_log_util.TRACE('In rel locks,wip_move= .. ' || wip_constants.wip_move_worker, 'INV_TABLE_LOCK_PVT', 9);
186: END IF;
187:
188: DELETE mtl_onhand_lock_temp
189: WHERE header_id = p_header_id;
190: END IF;
191: ELSE
192: SELECT lock_handle
190: END IF;
191: ELSE
192: SELECT lock_handle
193: BULK COLLECT INTO table_handle
194: FROM mtl_onhand_lock_temp
195: WHERE header_id = p_header_id;
196:
197: IF (table_handle IS NULL OR table_handle.COUNT = 0) THEN
198: IF (l_debug = 1 ) THEN/* Bug#5401181*/
212: END IF;
213: END IF;
214: END LOOP;
215:
216: DELETE mtl_onhand_lock_temp
217: WHERE header_id = p_header_id;
218: END IF;
219: END IF;
220: END release_locks;