eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.IBC_AUDIT_LOGS_PKG

Source


1 PACKAGE Ibc_Audit_Logs_Pkg AUTHID CURRENT_USER AS
2 /* $Header: ibctlogs.pls 115.10 2002/11/15 00:31:15 svatsa noship $*/
3 
4 -- Purpose: Table Handler for Ibc_Audit_Logs table.
5 
6 -- MODIFICATION HISTORY
7 -- Person            Date        Comments
8 -- ---------         ------      ------------------------------------------
9 -- Sri Rangarajan    01/06/2002      Created Package
10 -- shitij.vatsa      11/04/2002      Updated for NOCOPY
11 
12 PROCEDURE INSERT_ROW (
13   px_AUDIT_LOG_ID IN OUT NOCOPY NUMBER,
14   p_ACTIVITY IN VARCHAR2,
15   p_parent_value  IN VARCHAR2,
16   p_USER_ID IN NUMBER,
17   p_TIME_STAMP IN DATE,
18   p_OBJECT_TYPE IN VARCHAR2,
19   p_OBJECT_VALUE1 IN VARCHAR2,
20   p_OBJECT_VALUE2 IN VARCHAR2 DEFAULT NULL,
21   p_OBJECT_VALUE3 IN VARCHAR2 DEFAULT NULL,
22   p_OBJECT_VALUE4 IN VARCHAR2 DEFAULT NULL,
23   p_OBJECT_VALUE5 IN VARCHAR2 DEFAULT NULL,
24   p_DESCRIPTION IN VARCHAR2 DEFAULT NULL,
25 
26   P_OBJECT_STATUS IN VARCHAR2 DEFAULT NULL,
27   P_INTERNAL_FLAG IN VARCHAR2 DEFAULT NULL,
28   P_MESSAGE_APPLICATION IN VARCHAR2 DEFAULT NULL,
29   P_MESSAGE_NAME IN VARCHAR2 DEFAULT NULL,
30   P_EXTRA_INFO1_TYPE IN VARCHAR2 DEFAULT NULL,
31   P_EXTRA_INFO1_REF_TYPE IN VARCHAR2 DEFAULT NULL,
32   P_EXTRA_INFO1_VALUE IN VARCHAR2 DEFAULT NULL,
33   P_EXTRA_INFO2_TYPE IN VARCHAR2 DEFAULT NULL,
34   P_EXTRA_INFO2_REF_TYPE IN VARCHAR2 DEFAULT NULL,
35   P_EXTRA_INFO2_VALUE IN VARCHAR2 DEFAULT NULL,
36   P_EXTRA_INFO3_TYPE IN VARCHAR2 DEFAULT NULL,
37   P_EXTRA_INFO3_REF_TYPE IN VARCHAR2 DEFAULT NULL,
38   P_EXTRA_INFO3_VALUE IN VARCHAR2 DEFAULT NULL,
39   P_EXTRA_INFO4_TYPE IN VARCHAR2 DEFAULT NULL,
40   P_EXTRA_INFO4_REF_TYPE IN VARCHAR2 DEFAULT NULL,
41   P_EXTRA_INFO4_VALUE IN VARCHAR2 DEFAULT NULL,
42   P_EXTRA_INFO5_TYPE IN VARCHAR2 DEFAULT NULL,
43   P_EXTRA_INFO5_REF_TYPE IN VARCHAR2 DEFAULT NULL,
44   P_EXTRA_INFO5_VALUE IN VARCHAR2 DEFAULT NULL,
45 
46   p_OBJECT_VERSION_NUMBER IN NUMBER,
47   p_CREATION_DATE IN DATE      DEFAULT NULL,
48   p_CREATED_BY IN NUMBER     DEFAULT NULL,
49   p_LAST_UPDATE_DATE IN DATE    DEFAULT NULL,
50   p_LAST_UPDATED_BY IN NUMBER   DEFAULT NULL,
51   p_LAST_UPDATE_LOGIN IN NUMBER  DEFAULT NULL,
52   x_ROWID OUT NOCOPY VARCHAR2);
53 
54 PROCEDURE LOCK_ROW (
55   p_AUDIT_LOG_ID IN NUMBER,
56   p_ACTIVITY IN VARCHAR2,
57   p_USER_ID IN NUMBER,
58   p_TIME_STAMP IN DATE,
59   p_OBJECT_TYPE IN VARCHAR2,
60   p_OBJECT_VALUE1 IN VARCHAR2,
61   p_OBJECT_VALUE2 IN VARCHAR2,
62   p_OBJECT_VALUE3 IN VARCHAR2,
63   p_OBJECT_VALUE4 IN VARCHAR2,
64   p_OBJECT_VALUE5 IN VARCHAR2,
65   p_DESCRIPTION IN VARCHAR2,
66 
67   P_OBJECT_STATUS IN VARCHAR2 DEFAULT NULL,
68   P_INTERNAL_FLAG IN VARCHAR2 DEFAULT NULL,
69   P_MESSAGE_APPLICATION IN VARCHAR2 DEFAULT NULL,
70   P_MESSAGE_NAME IN VARCHAR2 DEFAULT NULL,
71   P_EXTRA_INFO1_TYPE IN VARCHAR2 DEFAULT NULL,
72   P_EXTRA_INFO1_REF_TYPE IN VARCHAR2 DEFAULT NULL,
73   P_EXTRA_INFO1_VALUE IN VARCHAR2 DEFAULT NULL,
74   P_EXTRA_INFO2_TYPE IN VARCHAR2 DEFAULT NULL,
75   P_EXTRA_INFO2_REF_TYPE IN VARCHAR2 DEFAULT NULL,
76   P_EXTRA_INFO2_VALUE IN VARCHAR2 DEFAULT NULL,
77   P_EXTRA_INFO3_TYPE IN VARCHAR2 DEFAULT NULL,
78   P_EXTRA_INFO3_REF_TYPE IN VARCHAR2 DEFAULT NULL,
79   P_EXTRA_INFO3_VALUE IN VARCHAR2 DEFAULT NULL,
80   P_EXTRA_INFO4_TYPE IN VARCHAR2 DEFAULT NULL,
81   P_EXTRA_INFO4_REF_TYPE IN VARCHAR2 DEFAULT NULL,
82   P_EXTRA_INFO4_VALUE IN VARCHAR2 DEFAULT NULL,
83   P_EXTRA_INFO5_TYPE IN VARCHAR2 DEFAULT NULL,
84   P_EXTRA_INFO5_REF_TYPE IN VARCHAR2 DEFAULT NULL,
85   P_EXTRA_INFO5_VALUE IN VARCHAR2 DEFAULT NULL,
86 
87   p_OBJECT_VERSION_NUMBER IN NUMBER
88 );
89 
90 /*PROCEDURE UPDATE_ROW (
91   p_AUDIT_LOG_ID    IN  NUMBER,
92   p_ACTIVITY    IN  VARCHAR2 DEFAULT  FND_API.G_MISS_CHAR,
93   p_parent_value  IN VARCHAR2 DEFAULT  FND_API.G_MISS_CHAR,
94   p_DESCRIPTION    IN  VARCHAR2 DEFAULT  FND_API.G_MISS_CHAR,
95   p_LAST_UPDATED_BY    IN  NUMBER DEFAULT  FND_API.G_MISS_NUM,
96   p_LAST_UPDATE_DATE    IN  DATE DEFAULT  FND_API.G_MISS_DATE,
97   p_LAST_UPDATE_LOGIN    IN  NUMBER DEFAULT  FND_API.G_MISS_NUM,
98   p_OBJECT_TYPE    IN  VARCHAR2 DEFAULT  FND_API.G_MISS_CHAR,
99   p_OBJECT_VALUE1    IN  VARCHAR2 DEFAULT  FND_API.G_MISS_CHAR,
100   p_OBJECT_VALUE2    IN  VARCHAR2 DEFAULT  FND_API.G_MISS_CHAR,
101   p_OBJECT_VALUE3    IN  VARCHAR2 DEFAULT  FND_API.G_MISS_CHAR,
102   p_OBJECT_VALUE4    IN  VARCHAR2 DEFAULT  FND_API.G_MISS_CHAR,
103   p_OBJECT_VALUE5    IN  VARCHAR2 DEFAULT  FND_API.G_MISS_CHAR,
104 
105   P_OBJECT_STATUS IN VARCHAR2 DEFAULT NULL,
106   P_INTERNAL_FLAG IN VARCHAR2 DEFAULT NULL,
107   P_MESSAGE_NAME IN VARCHAR2 DEFAULT NULL,
108   P_EXTRA_INFO1_TYPE IN VARCHAR2 DEFAULT NULL,
109   P_EXTRA_INFO1_REF_TYPE IN VARCHAR2 DEFAULT NULL,
110   P_EXTRA_INFO1_VALUE IN VARCHAR2 DEFAULT NULL,
111   P_EXTRA_INFO2_TYPE IN VARCHAR2 DEFAULT NULL,
112   P_EXTRA_INFO2_REF_TYPE IN VARCHAR2 DEFAULT NULL,
113   P_EXTRA_INFO2_VALUE IN VARCHAR2 DEFAULT NULL,
114   P_EXTRA_INFO3_TYPE IN VARCHAR2 DEFAULT NULL,
115   P_EXTRA_INFO3_REF_TYPE IN VARCHAR2 DEFAULT NULL,
116   P_EXTRA_INFO3_VALUE IN VARCHAR2 DEFAULT NULL,
117   P_EXTRA_INFO4_TYPE IN VARCHAR2 DEFAULT NULL,
118   P_EXTRA_INFO4_REF_TYPE IN VARCHAR2 DEFAULT NULL,
119   P_EXTRA_INFO4_VALUE IN VARCHAR2 DEFAULT NULL,
120   P_EXTRA_INFO5_TYPE IN VARCHAR2 DEFAULT NULL,
121   P_EXTRA_INFO5_REF_TYPE IN VARCHAR2 DEFAULT NULL,
122   P_EXTRA_INFO5_VALUE IN VARCHAR2 DEFAULT NULL,
123 
124   p_OBJECT_VERSION_NUMBER    IN  NUMBER DEFAULT  FND_API.G_MISS_NUM,
125   p_TIME_STAMP    IN  DATE DEFAULT  FND_API.G_MISS_DATE,
126   p_USER_ID    IN  NUMBER DEFAULT  FND_API.G_MISS_NUM
127 );
128 */
129 
130 PROCEDURE DELETE_ROW (
131   p_AUDIT_LOG_ID IN NUMBER
132 );
133 
134 END Ibc_Audit_Logs_Pkg;
135