APPS.WSH_UTIL_VALIDATE dependencies on WSH_SHIP_CONFIRM_RULES

Line 4923: -- wsh_ship_confirm_rules. If both values are specified then only

4919: --========================================================================
4920: -- PROCEDURE : Validate_Ship_Con_Rule_Name
4921: --
4922: -- COMMENT : Validates Ship_Confirm_Rule_Id/Ship_Confirm_Rule_Name against table
4923: -- wsh_ship_confirm_rules. If both values are specified then only
4924: -- Ship_Confirm_Rule_Id is used
4925: --========================================================================
4926:
4927: PROCEDURE Validate_Ship_Con_Rule_Name

Line 4934: FROM wsh_Ship_Confirm_rules

4930: x_return_status OUT NOCOPY VARCHAR2 ) IS
4931:
4932: CURSOR check_Ship_Confirm_rule_name IS
4933: SELECT Ship_Confirm_rule_id
4934: FROM wsh_Ship_Confirm_rules
4935: WHERE p_Ship_Confirm_rule_id IS NOT NULL
4936: AND Ship_Confirm_rule_id = p_Ship_Confirm_rule_id
4937: AND trunc(sysdate) BETWEEN nvl(effective_start_date,trunc(sysdate)) AND nvl(effective_end_date,trunc(sysdate) + 1)
4938: UNION ALL

Line 4940: FROM wsh_Ship_Confirm_rules

4936: AND Ship_Confirm_rule_id = p_Ship_Confirm_rule_id
4937: AND trunc(sysdate) BETWEEN nvl(effective_start_date,trunc(sysdate)) AND nvl(effective_end_date,trunc(sysdate) + 1)
4938: UNION ALL
4939: SELECT Ship_Confirm_rule_id
4940: FROM wsh_Ship_Confirm_rules
4941: WHERE p_Ship_Confirm_rule_id IS NULL
4942: AND name = p_Ship_Confirm_rule_name
4943: AND trunc(sysdate) BETWEEN nvl(effective_start_date,trunc(sysdate)) AND nvl(effective_end_date,trunc(sysdate) + 1);
4944: