APPS.ICX_SEC dependencies on WF_EVENT

Line 4288: WF_EVENT.Raise(p_event_name=>'oracle.apps.icx.security.session.created',

4284:
4285: --Raise the event
4286: --htp.p('####NSRE-5####');--debug mputman
4287:
4288: WF_EVENT.Raise(p_event_name=>'oracle.apps.icx.security.session.created',
4289: p_event_key=>to_char(sysdate, 'HH:MI:SS'),
4290: p_parameters=>l_parameterList);
4291: --htp.p('####NSRE-6####');--debug mputman
4292:

Line 4300: p_evtMsg in out NOCOPY wf_event_t) return varchar2 is

4296: --disable all other sessions for the user_id except the session_id
4297: --(user_id and session_id are retrieved from the p_evtMsg type).
4298: --mputman 1513025
4299: function doNewSessionEvent (p_guid in raw,
4300: p_evtMsg in out NOCOPY wf_event_t) return varchar2 is
4301: l_user_id VARCHAR2(80);
4302: l_user_name VARCHAR2(240);
4303: l_session_id VARCHAR2(80);
4304: l_except_ids VARCHAR2(4000);

Line 4321: WF_EVENT.setErrorInfo(p_evtMsg, 'ERROR');

4317: WHERE user_id=l_user_id;
4318: EXCEPTION
4319: WHEN OTHERS THEN
4320: WF_CORE.CONTEXT('icx_sec', 'doNewSessionEvent',p_evtMsg.getEventName( ), p_guid);
4321: WF_EVENT.setErrorInfo(p_evtMsg, 'ERROR');
4322: return 'ERROR';
4323: END;
4324:
4325: BEGIN

Line 4329: FROM wf_event_subscriptions

4325: BEGIN
4326:
4327: SELECT substrb(parameters,(instrb(parameters,'=',1)+1))
4328: INTO l_except_ids
4329: FROM wf_event_subscriptions
4330: WHERE guid=p_guid;
4331:
4332:
4333:

Line 4337: WF_EVENT.setErrorInfo(p_evtMsg, 'ERROR');

4333:
4334: EXCEPTION
4335: WHEN no_data_found THEN
4336: WF_CORE.CONTEXT('icx_sec', 'doNewSessionEvent',p_evtMsg.getEventName( ), p_guid);
4337: WF_EVENT.setErrorInfo(p_evtMsg, 'ERROR');
4338: return 'ERROR';
4339:
4340: END;
4341:

Line 4356: WF_EVENT.setErrorInfo(p_evtMsg, 'ERROR');

4352:
4353: EXCEPTION
4354: WHEN OTHERS THEN
4355: WF_CORE.CONTEXT('icx_sec', 'doNewSessionEvent',p_evtMsg.getEventName( ), p_guid);
4356: WF_EVENT.setErrorInfo(p_evtMsg, 'ERROR');
4357:
4358: return 'ERROR';
4359: END;
4360: NULL;