DBA Data[Home] [Help]

APPS.WSH_UTIL_VALIDATE dependencies on WSH_REPORT_SETS

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

2163: --========================================================================
2164: -- PROCEDURE : Validate_Report_Set
2165: --
2166: -- COMMENT : Validates Report_set_id/Report_set name against table
2167: -- wsh_report_sets. If both values are specified then only
2168: -- report_set_id is used
2169: --========================================================================
2170:
2171: PROCEDURE Validate_Report_Set

Line 2178: FROM wsh_report_sets

2174: x_return_status OUT NOCOPY VARCHAR2 ) IS
2175:
2176: CURSOR check_report_set IS
2177: SELECT report_set_id
2178: FROM wsh_report_sets
2179: WHERE p_report_set_id IS NOT NULL AND
2180: report_set_id = p_report_set_id AND
2181: start_date_active <= sysdate AND
2182: nvl(end_date_active,sysdate) >= sysdate

Line 2185: FROM wsh_report_sets

2181: start_date_active <= sysdate AND
2182: nvl(end_date_active,sysdate) >= sysdate
2183: UNION ALL
2184: SELECT report_set_id
2185: FROM wsh_report_sets
2186: WHERE p_report_set_id IS NULL AND
2187: name = p_report_set_name AND
2188: start_date_active <= sysdate AND
2189: nvl(end_date_active,sysdate) >= sysdate;