DBA Data[Home] [Help]

APPS.WSH_UTIL_VALIDATE dependencies on WSH_PICKING_BATCHES

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

4953: --========================================================================
4954: -- PROCEDURE : Validate_Picking_Batch_Name
4955: --
4956: -- COMMENT : Validates picking_Batch_Id/Picking_Batch_Name against table
4957: -- wsh_picking_Batches. If both values are specified then only
4958: -- picking_Batch_Id is used
4959: --========================================================================
4960:
4961: PROCEDURE Validate_Picking_Batch_Name

Line 4968: FROM wsh_picking_Batches

4964: x_return_status OUT NOCOPY VARCHAR2 ) IS
4965:
4966: CURSOR check_picking_batch_name IS
4967: SELECT batch_id
4968: FROM wsh_picking_Batches
4969: WHERE p_picking_batch_id IS NOT NULL
4970: AND batch_id = p_picking_batch_id
4971: UNION ALL
4972: SELECT batch_id

Line 4973: FROM wsh_picking_batches

4969: WHERE p_picking_batch_id IS NOT NULL
4970: AND batch_id = p_picking_batch_id
4971: UNION ALL
4972: SELECT batch_id
4973: FROM wsh_picking_batches
4974: WHERE p_picking_batch_id IS NULL
4975: AND name = p_picking_batch_name;
4976:
4977: --