APPS.FND_SIGNON dependencies on FND_LOGIN_RESP_FORMS

Line 36: UPDATE FND_LOGIN_RESP_FORMS FLRF

32: return;
33: end if;
34:
35: -- Stamp end time on any current form for this login in FLRF
36: UPDATE FND_LOGIN_RESP_FORMS FLRF
37: SET END_TIME = pend_time
38: WHERE FLRF.LOGIN_ID = audit_form_end.login_id
39: AND FLRF.END_TIME is NULL;
40:

Line 145: UPDATE FND_LOGIN_RESP_FORMS FLRF

141: -- Stamp end time on current form record.
142: --
143: begin
144: -- JWSMITH bug 1879642 - added FLRF.END_TIME is null
145: UPDATE FND_LOGIN_RESP_FORMS FLRF
146: SET END_TIME = SYSDATE
147: WHERE FLRF.LOGIN_ID = audit_form.login_id
148: AND FLRF.LOGIN_RESP_ID = audit_form.login_resp_id
149: AND FLRF.END_TIME IS NULL

Line 166: INSERT INTO FND_LOGIN_RESP_FORMS

162: -- BEGIN_FORM call
163: -- If form level auditing insert new form record.
164: --
165: if (audit_level = 'D') then
166: INSERT INTO FND_LOGIN_RESP_FORMS
167: (LOGIN_ID, LOGIN_RESP_ID, FORM_APPL_ID, FORM_ID, START_TIME,
168: AUDSID)
169: SELECT audit_form.login_id, audit_form.login_resp_id,
170: A.APPLICATION_ID, F.FORM_ID, SYSDATE,