1 package FND_AUDIT_SEQ_PKG As
2 /* $Header: AFATUTLS.pls 120.1 2005/07/02 03:57:32 appldev ship $ */
3
4 --
5 -- Global variables
6 -- FND_AUDIT_GLOBAL number; (current sequence number)
7 FND_AUDIT_GLOBAL number := 0;
8
9 -- FND_AUDIT_COMMIT number; (current commit number)
10 FND_AUDIT_COMMIT number := 0;
11
12 --
13 -- PUBLIC FUNCTIONS
14 --
15
16 --
17 -- Function NXT
18 --
19 -- Purpose
20 -- Returns next sequence number for a new audit row.
21 --
22 -- Arguments
23 -- NONE
24 --
25 Function NXT
26 return NUMBER;
27
28 --
29 -- Function CMT
30 --
31 -- Purpose
32 -- Returns the current commit number; i.e. the number of
33 -- commits done in the current session.
34 -- a lock is requested and if a commit occurs, the lock is released and
35 -- the commit number (FND_AUDIT_COMMIT) is incremented.
36 --
37 -- Arguments
38 -- NONE
39 --
40 Function CMT
41 return NUMBER;
42
43 --
44 -- Function USER_NAME
45 --
46 -- Purpose
47 -- Returns the current Applications user name if an applications context
48 -- exists and the current database account otherwise.
49 --
50 -- Arguments
51 -- NONE
52 --
53 Function USER_NAME
54 return VARCHAR2;
55 End FND_AUDIT_SEQ_PKG;