[Home] [Help]
44: 22-JUN-2001 P.K.Attwood 115.4 1841141 To support OPS (Oracle Parallel
45: Server) inside the
46: delete_ses_rows procedure
47: changed references from
48: v$session to gv$session.
49: 13-SEP-2001 P.K.Attwood 115.5 Added set_effective_date
50: procedure.
51: 19-DEC-2001 G.Perry 115.6 Added dbdrv
52: 31-JAN-2002 G.Sayers 115.7 Added validation to get_dates and
283: -- views with filter INST_ID = userenv('Instance').
284: --
285: cursor csr_v_ses (p_session_id number) is
286: select null
287: from gv$session
288: where audsid = p_session_id;
289: --
290: -- Declare exceptions to be handled
291: --
312: -- the FND_SESSIONS delete logic.
313: --
314: -- When this process obtains the table lock then it should go
315: -- on to remove old session rows from FND_SESSIONS. i.e. Where
316: -- there is no corresponding row in GV$SESSION. When this
317: -- process does not obtain the table lock it indicates that
318: -- another process must be performing the FND_SESSIONS delete
319: -- logic. So this session does not need to do anything extra.
320: --
324: -- If this point is reached then the table lock
325: -- has been obtained by this process.
326: --
327: -- For each row in FND_SESSIONS see if a corresponding
328: -- row exists in GV$SESSION. When there is no matching
329: -- row delete the FND_SESSIONS row.
330: --
331: for l_fnd_ses in csr_fnd_ses loop
332: --