APPS.EGO_WF_WRAPPER_PVT dependencies on DUAL

Line 311: SELECT MTL_BUSINESS_EVENTS_S.NEXTVAL into l_event_num FROM dual; --Bug: 5606011

307:
308: l_event_name := p_event_name ;
309: --l_event_key := SUBSTRB(l_event_name, 1, 225) || '-' || TO_CHAR(SYSDATE, 'J.SSSSS');
310:
311: SELECT MTL_BUSINESS_EVENTS_S.NEXTVAL into l_event_num FROM dual; --Bug: 5606011
312: l_event_key := SUBSTRB(l_event_name, 1, 255) || '-' || l_event_num;
313:
314:
315: --Adding the parameters

Line 384: SELECT MTL_BUSINESS_EVENTS_S.NEXTVAL into l_event_num FROM dual; --Bug: 5606011

380:
381: l_event_name := p_event_name ;
382: --l_event_key := SUBSTRB(l_event_name, 1, 225) || '-' || TO_CHAR(SYSDATE, 'J.SSSSS');
383:
384: SELECT MTL_BUSINESS_EVENTS_S.NEXTVAL into l_event_num FROM dual; --Bug: 5606011
385: l_event_key := SUBSTRB(l_event_name, 1, 255) || '-' || l_event_num;
386:
387:
388: --Adding the parameters

Line 478: SELECT MTL_BUSINESS_EVENTS_S.NEXTVAL into l_event_num FROM dual; --Bug: 5606011

474: BEGIN
475: l_event_name := p_event_name ;
476: --l_event_key := SUBSTRB(l_event_name, 1, 225) || '-' || TO_CHAR(SYSDATE, 'J.SSSSS');
477:
478: SELECT MTL_BUSINESS_EVENTS_S.NEXTVAL into l_event_num FROM dual; --Bug: 5606011
479: l_event_key := SUBSTRB(l_event_name, 1, 255) || '-' || l_event_num;
480:
481: IF p_request_id IS NOT NULL THEN --in case of Bulk Load
482: wf_event.AddParameterToList( p_name => 'REQUEST_ID'

Line 643: SELECT MTL_BUSINESS_EVENTS_S.NEXTVAL into l_event_num FROM dual; --Bug: 5606011

639: BEGIN
640: l_event_name := p_event_name ;
641: --l_event_key := SUBSTRB(l_event_name, 1, 225) || '-' || TO_CHAR(SYSDATE, 'J.SSSSS');
642:
643: SELECT MTL_BUSINESS_EVENTS_S.NEXTVAL into l_event_num FROM dual; --Bug: 5606011
644: l_event_key := SUBSTRB(l_event_name, 1, 255) || '-' || l_event_num;
645:
646: IF p_dml_type IS NOT NULL THEN
647: wf_event.AddParameterToList( p_name => 'DML_TYPE'

Line 736: FROM DUAL;

732: l_event_name := p_event_name ;
733:
734: SELECT TO_CHAR( SYSTIMESTAMP, 'dd-mon-yyyy hh24:mi:ss:ffff' )
735: INTO l_event_key
736: FROM DUAL;
737:
738: WF_EVENT.AddParameterToList( p_name => 'ENTITY_NAME'
739: ,p_value => p_entity_name
740: ,p_ParameterList => l_parameter_List);