[Home] [Help]
3542:
3543: -- frontport bug 5478065 of 11i10 performance bug 5439331:
3544: -- this cursor is tuned to check for existence.
3545: CURSOR c_staged_content( p_container_id IN NUMBER) IS
3546: SELECT 1 FROM DUAL
3547: WHERE EXISTS
3548: ( SELECT wdd.delivery_detail_id
3549: FROM wsh_delivery_details wdd
3550: WHERE wdd.delivery_detail_id IN
7228: -- mandatory and should be positive
7229: --
7230: -- 3. If item is under lot control, then validate lot number
7231: -- 4. Check that secondary quantity is within tolerance for
7232: -- items with dual UOM indicator 2 or 3
7233: -- 5. get secondary quantity from primary quantity by applying UOM conversion
7234: -- - for items with dual UOM indicator 1 (Always)
7235: --
7236: -- ----------------------------------------------------------------------
7230: -- 3. If item is under lot control, then validate lot number
7231: -- 4. Check that secondary quantity is within tolerance for
7232: -- items with dual UOM indicator 2 or 3
7233: -- 5. get secondary quantity from primary quantity by applying UOM conversion
7234: -- - for items with dual UOM indicator 1 (Always)
7235: --
7236: -- ----------------------------------------------------------------------
7237: -- HW OPMCONV - Added p_caller parameter
7238: PROCEDURE validate_secondary_quantity
7489: END IF;
7490: --
7491: --
7492: -- Check if secondary quantity is within tolerance for
7493: -- items with dual UOM indicator 2 or 3
7494: --
7495: -- HW OPMCONV - Check for two types only (Default and No Default)
7496: IF ( l_item_info.secondary_default_ind in ('D','N') ) OR
7497: ( p_caller = 'WSH_PUB' AND l_item_info.secondary_default_ind in ('F','D','N'))
7526:
7527: --
7528: --
7529: -- get secondary quantity from primary quantity by applying UOM conversion
7530: -- for items with dual UOM indicator 1 (Always)
7531: --
7532: --
7533: -- HW OPMCONV - Changed condition to check for secondary_default_ind
7534: IF l_outside_tolerance AND l_item_info.secondary_default_ind in ('F','D')