APPS.FND_SIGNON dependencies on FND_LOGIN_RESP_FORMS

Line 34: UPDATE FND_LOGIN_RESP_FORMS FLRF

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

Line 121: UPDATE FND_LOGIN_RESP_FORMS FLRF

117: -- Stamp end time on current form record.
118: --
119: begin
120: -- JWSMITH bug 1879642 - added FLRF.END_TIME is null
121: UPDATE FND_LOGIN_RESP_FORMS FLRF
122: SET END_TIME = SYSDATE
123: WHERE FLRF.LOGIN_ID = audit_form.login_id
124: AND FLRF.LOGIN_RESP_ID = audit_form.login_resp_id
125: AND FLRF.END_TIME IS NULL

Line 142: INSERT INTO FND_LOGIN_RESP_FORMS

138: -- BEGIN_FORM call
139: -- If form level auditing insert new form record.
140: --
141: if (audit_level = 'D') then
142: INSERT INTO FND_LOGIN_RESP_FORMS
143: (LOGIN_ID, LOGIN_RESP_ID, FORM_APPL_ID, FORM_ID, START_TIME,
144: AUDSID)
145: SELECT audit_form.login_id, audit_form.login_resp_id,
146: A.APPLICATION_ID, F.FORM_ID, SYSDATE,