[Home] [Help]
234: -- calling fnd_signon.audit_responsibility().
235: --
236: -- If login_resp_id is null, then generate one.
237: if (login_resp_id is null) then
238: select FND_LOGIN_RESPONSIBILITIES_S.nextval into login_resp_id from dual;
239: end if;
240:
241: INSERT INTO FND_LOGIN_RESPONSIBILITIES
242: (LOGIN_ID, LOGIN_RESP_ID, RESP_APPL_ID, RESPONSIBILITY_ID, START_TIME,
286: AUDIT_USER_END(login_id);
287: AUDIT_RESPONSIBILITY_END(login_id);
288:
289: -- Create a new login id
290: SELECT FND_LOGINS_S.NEXTVAL INTO audit_user.login_id FROM SYS.DUAL;
291:
292: -- If auditing turned on insert record in FL for new login
293: -- bug 7160418, skip auditing for guest user
294: if (audit_level <> 'A') AND (user_id <> '6') then
523: end if;
524:
525: SELECT userenv('SESSIONID')
526: INTO l_session_id
527: FROM dual;
528:
529: /*
530: * Special handling of 'SIGNONAUDIT:LEVEL' for proxy sessions
531: */
631: sysdate,
632: update_desktop_object.user_id,
633: update_desktop_object.login_id,
634: 'FUNCTION'
635: from sys.dual;
636: end if;
637: end if;
638: exception
639: when others then
760: EFFECTIVE_DATE)
761: select
762: userenv('SESSIONID'),
763: l_ses_date
764: from sys.dual
765: where not exists
766: (select null
767: from FND_SESSIONS
768: where SESSION_ID = userenv('SESSIONID'));
847: l_session_id NUMBER;
848:
849: BEGIN
850:
851: select userenv('SESSIONID') into l_session_id from dual;
852: l_proxy_user_id := fnd_session_management.isProxySession(null);
853:
854:
855: if (l_proxy_user_id is not NULL) then
930: --
931:
932: SELECT userenv('SESSIONID')
933: INTO l_session_id
934: FROM dual;
935:
936: begin
937: select session_id into l_session_id
938: from ICX_SESSIONS