APPS.WSH_UTIL_VALIDATE dependencies on WSH_SHIP_CONFIRM_RULES

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

4875: --========================================================================
4876: -- PROCEDURE : Validate_Ship_Con_Rule_Name
4877: --
4878: -- COMMENT : Validates Ship_Confirm_Rule_Id/Ship_Confirm_Rule_Name against table
4879: -- wsh_ship_confirm_rules. If both values are specified then only
4880: -- Ship_Confirm_Rule_Id is used
4881: --========================================================================
4882:
4883: PROCEDURE Validate_Ship_Con_Rule_Name

Line 4890: FROM wsh_Ship_Confirm_rules

4886: x_return_status OUT NOCOPY VARCHAR2 ) IS
4887:
4888: CURSOR check_Ship_Confirm_rule_name IS
4889: SELECT Ship_Confirm_rule_id
4890: FROM wsh_Ship_Confirm_rules
4891: WHERE p_Ship_Confirm_rule_id IS NOT NULL
4892: AND Ship_Confirm_rule_id = p_Ship_Confirm_rule_id
4893: AND trunc(sysdate) BETWEEN nvl(effective_start_date,trunc(sysdate)) AND nvl(effective_end_date,trunc(sysdate) + 1)
4894: UNION ALL

Line 4896: FROM wsh_Ship_Confirm_rules

4892: AND Ship_Confirm_rule_id = p_Ship_Confirm_rule_id
4893: AND trunc(sysdate) BETWEEN nvl(effective_start_date,trunc(sysdate)) AND nvl(effective_end_date,trunc(sysdate) + 1)
4894: UNION ALL
4895: SELECT Ship_Confirm_rule_id
4896: FROM wsh_Ship_Confirm_rules
4897: WHERE p_Ship_Confirm_rule_id IS NULL
4898: AND name = p_Ship_Confirm_rule_name
4899: AND trunc(sysdate) BETWEEN nvl(effective_start_date,trunc(sysdate)) AND nvl(effective_end_date,trunc(sysdate) + 1);
4900: