DBA Data[Home] [Help]

APPS.WSH_DELIVERY_DETAILS_UTILITIES dependencies on WSH_PICK_LIST

Line 1100: WSH_DEBUG_SV.log(l_module_name, 'WSH_PICK_LIST.G_BATCH_ID', WSH_PICK_LIST.G_BATCH_ID);

1096: WSH_DEBUG_SV.log(l_module_name, 'p_group_by_header', p_group_by_header);
1097: WSH_DEBUG_SV.log(l_module_name, 'p_commit', p_commit);
1098: WSH_DEBUG_SV.log(l_module_name, 'p_lock_rows', p_lock_rows);
1099: WSH_DEBUG_SV.log(l_module_name, 'p_check_fte_compatibility', p_check_fte_compatibility);
1100: WSH_DEBUG_SV.log(l_module_name, 'WSH_PICK_LIST.G_BATCH_ID', WSH_PICK_LIST.G_BATCH_ID);
1101:
1102: END IF;
1103:
1104: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 1158: IF NVL(p_append_flag, l_appending_limit) = 'N' and WSH_PICK_LIST.G_BATCH_ID is NULL THEN

1154: -- lock the delivery detail record
1155: select delivery_detail_id into l_delivery_detail_id from wsh_delivery_details where
1156: delivery_detail_id = p_delivery_detail_tbl(l_index) for update nowait;
1157: END IF;
1158: IF NVL(p_append_flag, l_appending_limit) = 'N' and WSH_PICK_LIST.G_BATCH_ID is NULL THEN
1159: x_unappended_det_tbl(x_unappended_det_tbl.count+1) := l_detail_info(l_index).entity_id;
1160: l_detail_info.delete(l_index);
1161: ELSIF NVL(p_append_flag, l_appending_limit) = 'N' and WSH_PICK_LIST.G_BATCH_ID is NOT NULL THEN
1162: l_detail_info(l_index).batch_id := WSH_PICK_LIST.G_BATCH_ID;

Line 1161: ELSIF NVL(p_append_flag, l_appending_limit) = 'N' and WSH_PICK_LIST.G_BATCH_ID is NOT NULL THEN

1157: END IF;
1158: IF NVL(p_append_flag, l_appending_limit) = 'N' and WSH_PICK_LIST.G_BATCH_ID is NULL THEN
1159: x_unappended_det_tbl(x_unappended_det_tbl.count+1) := l_detail_info(l_index).entity_id;
1160: l_detail_info.delete(l_index);
1161: ELSIF NVL(p_append_flag, l_appending_limit) = 'N' and WSH_PICK_LIST.G_BATCH_ID is NOT NULL THEN
1162: l_detail_info(l_index).batch_id := WSH_PICK_LIST.G_BATCH_ID;
1163:
1164: END IF;
1165: END IF;

Line 1162: l_detail_info(l_index).batch_id := WSH_PICK_LIST.G_BATCH_ID;

1158: IF NVL(p_append_flag, l_appending_limit) = 'N' and WSH_PICK_LIST.G_BATCH_ID is NULL THEN
1159: x_unappended_det_tbl(x_unappended_det_tbl.count+1) := l_detail_info(l_index).entity_id;
1160: l_detail_info.delete(l_index);
1161: ELSIF NVL(p_append_flag, l_appending_limit) = 'N' and WSH_PICK_LIST.G_BATCH_ID is NOT NULL THEN
1162: l_detail_info(l_index).batch_id := WSH_PICK_LIST.G_BATCH_ID;
1163:
1164: END IF;
1165: END IF;
1166: <>