DBA Data[Home] [Help]

APPS.WSH_TRX_HANDLER dependencies on WSH_DELIVERY_DETAILS

Line 167: UPDATE wsh_delivery_details

163: WSH_DEBUG_SV.log(l_module_name,'Rows Delete in mtl_transactions_interface',SQL%ROWCOUNT);
164: END IF;
165:
166: FORALL i IN p_start_index..p_end_index
167: UPDATE wsh_delivery_details
168: SET inv_interfaced_flag='P'
169: WHERE delivery_detail_id = decode(p_mtl_txn_if_rec.error_flag(i),
170: 'N',p_mtl_txn_if_rec.picking_line_id(i),
171: 'Y',-99999);

Line 173: WSH_DEBUG_SV.log(l_module_name,'Rows Updated in wsh_delivery_details',SQL%ROWCOUNT);

169: WHERE delivery_detail_id = decode(p_mtl_txn_if_rec.error_flag(i),
170: 'N',p_mtl_txn_if_rec.picking_line_id(i),
171: 'Y',-99999);
172: IF l_debug_on THEN
173: WSH_DEBUG_SV.log(l_module_name,'Rows Updated in wsh_delivery_details',SQL%ROWCOUNT);
174: END IF;
175:
176: IF l_debug_on THEN
177: WSH_DEBUG_SV.pop(l_module_name);