DBA Data[Home] [Help]

APPS.WSH_UTIL_VALIDATE dependencies on WSH_REPORT_SETS

Line 2145: -- wsh_report_sets. If both values are specified then only

2141: --========================================================================
2142: -- PROCEDURE : Validate_Report_Set
2143: --
2144: -- COMMENT : Validates Report_set_id/Report_set name against table
2145: -- wsh_report_sets. If both values are specified then only
2146: -- report_set_id is used
2147: --========================================================================
2148:
2149: PROCEDURE Validate_Report_Set

Line 2156: FROM wsh_report_sets

2152: x_return_status OUT NOCOPY VARCHAR2 ) IS
2153:
2154: CURSOR check_report_set IS
2155: SELECT report_set_id
2156: FROM wsh_report_sets
2157: WHERE p_report_set_id IS NOT NULL AND
2158: report_set_id = p_report_set_id AND
2159: start_date_active <= sysdate AND
2160: nvl(end_date_active,sysdate) >= sysdate

Line 2163: FROM wsh_report_sets

2159: start_date_active <= sysdate AND
2160: nvl(end_date_active,sysdate) >= sysdate
2161: UNION ALL
2162: SELECT report_set_id
2163: FROM wsh_report_sets
2164: WHERE p_report_set_id IS NULL AND
2165: name = p_report_set_name AND
2166: start_date_active <= sysdate AND
2167: nvl(end_date_active,sysdate) >= sysdate;