1090: WSH_DEBUG_SV.log(l_module_name, 'p_group_by_header', p_group_by_header);
1091: WSH_DEBUG_SV.log(l_module_name, 'p_commit', p_commit);
1092: WSH_DEBUG_SV.log(l_module_name, 'p_lock_rows', p_lock_rows);
1093: WSH_DEBUG_SV.log(l_module_name, 'p_check_fte_compatibility', p_check_fte_compatibility);
1094: WSH_DEBUG_SV.log(l_module_name, 'WSH_PICK_LIST.G_BATCH_ID', WSH_PICK_LIST.G_BATCH_ID);
1095:
1096: END IF;
1097:
1098: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1148: -- lock the delivery detail record
1149: select delivery_detail_id into l_delivery_detail_id from wsh_delivery_details where
1150: delivery_detail_id = p_delivery_detail_tbl(l_index) for update nowait;
1151: END IF;
1152: IF NVL(p_append_flag, l_appending_limit) = 'N' and WSH_PICK_LIST.G_BATCH_ID is NULL THEN
1153: x_unappended_det_tbl(x_unappended_det_tbl.count+1) := l_detail_info(l_index).entity_id;
1154: l_detail_info.delete(l_index);
1155: ELSIF NVL(p_append_flag, l_appending_limit) = 'N' and WSH_PICK_LIST.G_BATCH_ID is NOT NULL THEN
1156: l_detail_info(l_index).batch_id := WSH_PICK_LIST.G_BATCH_ID;
1151: END IF;
1152: IF NVL(p_append_flag, l_appending_limit) = 'N' and WSH_PICK_LIST.G_BATCH_ID is NULL THEN
1153: x_unappended_det_tbl(x_unappended_det_tbl.count+1) := l_detail_info(l_index).entity_id;
1154: l_detail_info.delete(l_index);
1155: ELSIF NVL(p_append_flag, l_appending_limit) = 'N' and WSH_PICK_LIST.G_BATCH_ID is NOT NULL THEN
1156: l_detail_info(l_index).batch_id := WSH_PICK_LIST.G_BATCH_ID;
1157:
1158: END IF;
1159: END IF;
1152: IF NVL(p_append_flag, l_appending_limit) = 'N' and WSH_PICK_LIST.G_BATCH_ID is NULL THEN
1153: x_unappended_det_tbl(x_unappended_det_tbl.count+1) := l_detail_info(l_index).entity_id;
1154: l_detail_info.delete(l_index);
1155: ELSIF NVL(p_append_flag, l_appending_limit) = 'N' and WSH_PICK_LIST.G_BATCH_ID is NOT NULL THEN
1156: l_detail_info(l_index).batch_id := WSH_PICK_LIST.G_BATCH_ID;
1157:
1158: END IF;
1159: END IF;
1160: <