[Home] [Help]
210: -- calling fnd_signon.audit_responsibility().
211: --
212: -- If login_resp_id is null, then generate one.
213: if (login_resp_id is null) then
214: select FND_LOGIN_RESPONSIBILITIES_S.nextval into login_resp_id from dual;
215: end if;
216:
217: INSERT INTO FND_LOGIN_RESPONSIBILITIES
218: (LOGIN_ID, LOGIN_RESP_ID, RESP_APPL_ID, RESPONSIBILITY_ID, START_TIME,
262: AUDIT_USER_END(login_id);
263: AUDIT_RESPONSIBILITY_END(login_id);
264:
265: -- Create a new login id
266: SELECT FND_LOGINS_S.NEXTVAL INTO audit_user.login_id FROM SYS.DUAL;
267:
268: -- If auditing turned on insert record in FL for new login
269: -- bug 7160418, skip auditing for guest user
270: if (audit_level <> 'A') AND (user_id <> '6') then
499: end if;
500:
501: SELECT userenv('SESSIONID')
502: INTO l_session_id
503: FROM dual;
504:
505: /*
506: * Special handling of 'SIGNONAUDIT:LEVEL' for proxy sessions
507: */
607: sysdate,
608: update_desktop_object.user_id,
609: update_desktop_object.login_id,
610: 'FUNCTION'
611: from sys.dual;
612: end if;
613: end if;
614: exception
615: when others then
736: EFFECTIVE_DATE)
737: select
738: userenv('SESSIONID'),
739: l_ses_date
740: from sys.dual
741: where not exists
742: (select null
743: from FND_SESSIONS
744: where SESSION_ID = userenv('SESSIONID'));
823: l_session_id NUMBER;
824:
825: BEGIN
826:
827: select userenv('SESSIONID') into l_session_id from dual;
828: l_proxy_user_id := fnd_session_management.isProxySession(null);
829:
830:
831: if (l_proxy_user_id is not NULL) then
906: --
907:
908: SELECT userenv('SESSIONID')
909: INTO l_session_id
910: FROM dual;
911:
912: begin
913: select session_id into l_session_id
914: from ICX_SESSIONS