APPS.WSH_DETAILS_VALIDATIONS dependencies on DUAL

Line 3423: SELECT 1 FROM DUAL

3419:
3420: -- frontport bug 5478065 of 11i10 performance bug 5439331:
3421: -- this cursor is tuned to check for existence.
3422: CURSOR c_staged_content( p_container_id IN NUMBER) IS
3423: SELECT 1 FROM DUAL
3424: WHERE EXISTS
3425: ( SELECT wdd.delivery_detail_id
3426: FROM wsh_delivery_details wdd
3427: WHERE wdd.delivery_detail_id IN

Line 6942: -- items with dual UOM indicator 2 or 3

6938: -- mandatory and should be positive
6939: --
6940: -- 3. If item is under lot control, then validate lot number
6941: -- 4. Check that secondary quantity is within tolerance for
6942: -- items with dual UOM indicator 2 or 3
6943: -- 5. get secondary quantity from primary quantity by applying UOM conversion
6944: -- - for items with dual UOM indicator 1 (Always)
6945: --
6946: -- ----------------------------------------------------------------------

Line 6944: -- - for items with dual UOM indicator 1 (Always)

6940: -- 3. If item is under lot control, then validate lot number
6941: -- 4. Check that secondary quantity is within tolerance for
6942: -- items with dual UOM indicator 2 or 3
6943: -- 5. get secondary quantity from primary quantity by applying UOM conversion
6944: -- - for items with dual UOM indicator 1 (Always)
6945: --
6946: -- ----------------------------------------------------------------------
6947: -- HW OPMCONV - Added p_caller parameter
6948: PROCEDURE validate_secondary_quantity

Line 7203: -- items with dual UOM indicator 2 or 3

7199: END IF;
7200: --
7201: --
7202: -- Check if secondary quantity is within tolerance for
7203: -- items with dual UOM indicator 2 or 3
7204: --
7205: -- HW OPMCONV - Check for two types only (Default and No Default)
7206: IF ( l_item_info.secondary_default_ind in ('D','N') ) OR
7207: ( p_caller = 'WSH_PUB' AND l_item_info.secondary_default_ind in ('F','D','N'))

Line 7240: -- for items with dual UOM indicator 1 (Always)

7236:
7237: --
7238: --
7239: -- get secondary quantity from primary quantity by applying UOM conversion
7240: -- for items with dual UOM indicator 1 (Always)
7241: --
7242: --
7243: -- HW OPMCONV - Changed condition to check for secondary_default_ind
7244: IF l_outside_tolerance AND l_item_info.secondary_default_ind in ('F','D')