APPS.WSH_XC_UTIL dependencies on DUAL

Line 583: -- SELECT wsh_exceptions_s.nextval INTO l_exception_id FROM SYS.DUAL;

579: END IF;
580:
581: -- populate l_exception_id
582: -- Bug 6615016 using the wsh_exceptions_s.nextval directly in the insert statement.
583: -- SELECT wsh_exceptions_s.nextval INTO l_exception_id FROM SYS.DUAL;
584:
585: IF l_debug_on THEN
586: wsh_debug_sv.logmsg(l_module_name, '**** Actual values ****');
587: -- Bug 6615016

Line 2252: SELECT wsh_exception_definitions_s.nextval INTO l_exception_definition_id FROM SYS.DUAL;

2248: end if;
2249: close C2;
2250: else
2251: -- populate l_exception_id
2252: SELECT wsh_exception_definitions_s.nextval INTO l_exception_definition_id FROM SYS.DUAL;
2253: end if;
2254: insert into wsh_exception_definitions_b (
2255: exception_definition_id,
2256: exception_type,

Line 4156: -- also caller shud not be TRIP (above), so that there is no dual count

4152:
4153: END LOOP;
4154: END IF;
4155: -- get dummy stop if caller is FTE or IB or TP Release.
4156: -- also caller shud not be TRIP (above), so that there is no dual count
4157: IF ( nvl(p_caller,'@@@') like 'FTE%'
4158: OR nvl(p_caller,'@@@') like 'WSH_IB%'
4159: OR nvl(p_caller,'@@@') like 'WSH_TP_RELEASE%'
4160: ) AND NOT ( nvl(p_caller,'@@@') like '%TRIP%') THEN

Line 4614: -- also caller shud not be TRIP (above), so that there is no dual count

4610: END LOOP;
4611: END IF;
4612:
4613: -- get dummy stop if caller is FTE or IB or TP Release.
4614: -- also caller shud not be TRIP (above), so that there is no dual count
4615: IF ( nvl(p_caller,'@@@') like 'FTE%'
4616: OR nvl(p_caller,'@@@') like 'WSH_IB%'
4617: OR nvl(p_caller,'@@@') like 'WSH_TP_RELEASE%'
4618: ) AND NOT ( nvl(p_caller,'@@@') like '%TRIP%') THEN