APPS.ICX_SEC dependencies on WF_EVENT

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

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

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

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

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

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

Line 4326: FROM wf_event_subscriptions

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

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

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

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

4348:
4349: EXCEPTION
4350: WHEN OTHERS THEN
4351: WF_CORE.CONTEXT('icx_sec', 'doNewSessionEvent',p_evtMsg.getEventName( ), p_guid);
4352: WF_EVENT.setErrorInfo(p_evtMsg, 'ERROR');
4353:
4354: return 'ERROR';
4355: END;
4356: NULL;