DBA Data[Home] [Help]

APPS.INV_TABLE_LOCK_PVT dependencies on WIP_CONSTANTS

Line 183: IF (wip_constants.wip_move_worker <> 'Y') THEN

179:
180: IF (p_commit = 1) THEN
181: -- should not delete the temp rows for wip move trx's are this will
182: -- be done BY wip move worker when they call the release_locks api.
183: IF (wip_constants.wip_move_worker <> 'Y') THEN
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:

Line 185: inv_log_util.TRACE('In rel locks,wip_move= .. ' || wip_constants.wip_move_worker, 'INV_TABLE_LOCK_PVT', 9);

181: -- should not delete the temp rows for wip move trx's are this will
182: -- be done BY wip move worker when they call the release_locks api.
183: IF (wip_constants.wip_move_worker <> 'Y') THEN
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;