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 2251: SELECT wsh_exception_definitions_s.nextval INTO l_exception_definition_id FROM SYS.DUAL;

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

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

4144:
4145: END LOOP;
4146: END IF;
4147: -- get dummy stop if caller is FTE or IB or TP Release.
4148: -- also caller shud not be TRIP (above), so that there is no dual count
4149: IF ( nvl(p_caller,'@@@') like 'FTE%'
4150: OR nvl(p_caller,'@@@') like 'WSH_IB%'
4151: OR nvl(p_caller,'@@@') like 'WSH_TP_RELEASE%'
4152: ) AND NOT ( nvl(p_caller,'@@@') like '%TRIP%') THEN

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

4602: END LOOP;
4603: END IF;
4604:
4605: -- get dummy stop if caller is FTE or IB or TP Release.
4606: -- also caller shud not be TRIP (above), so that there is no dual count
4607: IF ( nvl(p_caller,'@@@') like 'FTE%'
4608: OR nvl(p_caller,'@@@') like 'WSH_IB%'
4609: OR nvl(p_caller,'@@@') like 'WSH_TP_RELEASE%'
4610: ) AND NOT ( nvl(p_caller,'@@@') like '%TRIP%') THEN