DBA Data[Home] [Help]

APPS.WSH_UTIL_VALIDATE dependencies on WSH_PICKING_BATCHES

Line 5001: -- wsh_picking_Batches. If both values are specified then only

4997: --========================================================================
4998: -- PROCEDURE : Validate_Picking_Batch_Name
4999: --
5000: -- COMMENT : Validates picking_Batch_Id/Picking_Batch_Name against table
5001: -- wsh_picking_Batches. If both values are specified then only
5002: -- picking_Batch_Id is used
5003: --========================================================================
5004:
5005: PROCEDURE Validate_Picking_Batch_Name

Line 5012: FROM wsh_picking_Batches

5008: x_return_status OUT NOCOPY VARCHAR2 ) IS
5009:
5010: CURSOR check_picking_batch_name IS
5011: SELECT batch_id
5012: FROM wsh_picking_Batches
5013: WHERE p_picking_batch_id IS NOT NULL
5014: AND batch_id = p_picking_batch_id
5015: UNION ALL
5016: SELECT batch_id

Line 5017: FROM wsh_picking_batches

5013: WHERE p_picking_batch_id IS NOT NULL
5014: AND batch_id = p_picking_batch_id
5015: UNION ALL
5016: SELECT batch_id
5017: FROM wsh_picking_batches
5018: WHERE p_picking_batch_id IS NULL
5019: AND name = p_picking_batch_name;
5020:
5021: --