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 378: SELECT MTL_BUSINESS_EVENTS_S.NEXTVAL into l_event_num FROM dual; --Bug: 5606011

374:
375: l_event_name := p_event_name ;
376: --l_event_key := SUBSTRB(l_event_name, 1, 225) || '-' || TO_CHAR(SYSDATE, 'J.SSSSS');
377:
378: SELECT MTL_BUSINESS_EVENTS_S.NEXTVAL into l_event_num FROM dual; --Bug: 5606011
379: l_event_key := SUBSTRB(l_event_name, 1, 255) || '-' || l_event_num;
380:
381:
382: --Adding the parameters

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

457: BEGIN
458: l_event_name := p_event_name ;
459: --l_event_key := SUBSTRB(l_event_name, 1, 225) || '-' || TO_CHAR(SYSDATE, 'J.SSSSS');
460:
461: SELECT MTL_BUSINESS_EVENTS_S.NEXTVAL into l_event_num FROM dual; --Bug: 5606011
462: l_event_key := SUBSTRB(l_event_name, 1, 255) || '-' || l_event_num;
463:
464: IF p_request_id IS NOT NULL THEN --in case of Bulk Load
465: wf_event.AddParameterToList( p_name => 'REQUEST_ID'

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

616: BEGIN
617: l_event_name := p_event_name ;
618: --l_event_key := SUBSTRB(l_event_name, 1, 225) || '-' || TO_CHAR(SYSDATE, 'J.SSSSS');
619:
620: SELECT MTL_BUSINESS_EVENTS_S.NEXTVAL into l_event_num FROM dual; --Bug: 5606011
621: l_event_key := SUBSTRB(l_event_name, 1, 255) || '-' || l_event_num;
622:
623: IF p_dml_type IS NOT NULL THEN
624: wf_event.AddParameterToList( p_name => 'DML_TYPE'

Line 713: FROM DUAL;

709: l_event_name := p_event_name ;
710:
711: SELECT TO_CHAR( SYSTIMESTAMP, 'dd-mon-yyyy hh24:mi:ss:ffff' )
712: INTO l_event_key
713: FROM DUAL;
714:
715: WF_EVENT.AddParameterToList( p_name => 'ENTITY_NAME'
716: ,p_value => p_entity_name
717: ,p_ParameterList => l_parameter_List);