DBA Data[Home] [Help]

APPS.INV_TABLE_LOCK_PVT dependencies on WIP_CONSTANTS

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

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

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

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