1 PACKAGE BODY Ibc_Audit_Logs_Pkg AS
2 /* $Header: ibctlogb.pls 115.10 2002/11/15 00:31:42 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,
21 p_OBJECT_VALUE3 IN VARCHAR2,
22 p_OBJECT_VALUE4 IN VARCHAR2,
23 p_OBJECT_VALUE5 IN VARCHAR2,
24 p_DESCRIPTION IN VARCHAR2,
25
26 P_OBJECT_STATUS IN VARCHAR2,
27 P_INTERNAL_FLAG IN VARCHAR2,
28 P_MESSAGE_APPLICATION IN VARCHAR2,
29 P_MESSAGE_NAME IN VARCHAR2,
30 P_EXTRA_INFO1_TYPE IN VARCHAR2,
31 P_EXTRA_INFO1_REF_TYPE IN VARCHAR2,
32 P_EXTRA_INFO1_VALUE IN VARCHAR2,
33 P_EXTRA_INFO2_TYPE IN VARCHAR2,
34 P_EXTRA_INFO2_REF_TYPE IN VARCHAR2,
35 P_EXTRA_INFO2_VALUE IN VARCHAR2,
36 P_EXTRA_INFO3_TYPE IN VARCHAR2,
37 P_EXTRA_INFO3_REF_TYPE IN VARCHAR2,
38 P_EXTRA_INFO3_VALUE IN VARCHAR2,
39 P_EXTRA_INFO4_TYPE IN VARCHAR2,
40 P_EXTRA_INFO4_REF_TYPE IN VARCHAR2,
41 P_EXTRA_INFO4_VALUE IN VARCHAR2,
42 P_EXTRA_INFO5_TYPE IN VARCHAR2,
43 P_EXTRA_INFO5_REF_TYPE IN VARCHAR2,
44 P_EXTRA_INFO5_VALUE IN VARCHAR2,
45
46 p_OBJECT_VERSION_NUMBER IN NUMBER,
47 p_CREATION_DATE IN DATE,
48 p_CREATED_BY IN NUMBER,
49 p_LAST_UPDATE_DATE IN DATE,
50 p_LAST_UPDATED_BY IN NUMBER,
51 p_LAST_UPDATE_LOGIN IN NUMBER,
52 x_ROWID OUT NOCOPY VARCHAR2)
53 IS
54 CURSOR C IS SELECT ROWID FROM IBC_AUDIT_LOGS
55 WHERE AUDIT_LOG_ID = px_AUDIT_LOG_ID;
56 CURSOR c2 IS SELECT ibc_audit_logs_s1.NEXTVAL FROM dual;
57
58 BEGIN
59
60 -- Primary key validation check
61 IF ((px_AUDIT_LOG_ID IS NULL) OR
62 (px_AUDIT_LOG_ID = FND_API.G_MISS_NUM))
63 THEN
64 OPEN c2;
65 FETCH c2 INTO px_AUDIT_LOG_ID;
66 CLOSE c2;
67 END IF;
68
69 INSERT INTO IBC_AUDIT_LOGS (
70 AUDIT_LOG_ID,
71 parent_value,
72 ACTIVITY,
73 USER_ID,
74 TIME_STAMP,
75 OBJECT_TYPE,
76 OBJECT_VALUE1,
77 OBJECT_VALUE2,
78 OBJECT_VALUE3,
79 OBJECT_VALUE4,
80 OBJECT_VALUE5,
81 DESCRIPTION,
82
83 APPLICATION_ID,
84 OBJECT_STATUS,
85 INTERNAL_FLAG,
86 MESSAGE_APPLICATION,
87 MESSAGE_NAME,
88 EXTRA_INFO1_TYPE,
89 EXTRA_INFO1_REF_TYPE,
90 EXTRA_INFO1_VALUE,
91 EXTRA_INFO2_TYPE,
92 EXTRA_INFO2_REF_TYPE,
93 EXTRA_INFO2_VALUE,
94 EXTRA_INFO3_TYPE,
95 EXTRA_INFO3_REF_TYPE,
96 EXTRA_INFO3_VALUE,
97 EXTRA_INFO4_TYPE,
98 EXTRA_INFO4_REF_TYPE,
99 EXTRA_INFO4_VALUE,
100 EXTRA_INFO5_TYPE,
101 EXTRA_INFO5_REF_TYPE,
102 EXTRA_INFO5_VALUE,
103
104 OBJECT_VERSION_NUMBER,
105 CREATION_DATE,
106 CREATED_BY,
107 LAST_UPDATE_DATE,
108 LAST_UPDATED_BY,
109 LAST_UPDATE_LOGIN
110 ) VALUES (
111 px_AUDIT_LOG_ID,
112 p_parent_value,
113 p_ACTIVITY,
114 p_USER_ID,
115 p_TIME_STAMP,
116 p_OBJECT_TYPE,
117 p_OBJECT_VALUE1,
118 DECODE(p_OBJECT_VALUE2,FND_API.G_MISS_CHAR,NULL,p_OBJECT_VALUE2),
119 DECODE(p_OBJECT_VALUE3,FND_API.G_MISS_CHAR,NULL,p_OBJECT_VALUE3),
120 DECODE(p_OBJECT_VALUE4,FND_API.G_MISS_CHAR,NULL,p_OBJECT_VALUE4),
121 DECODE(p_OBJECT_VALUE5,FND_API.G_MISS_CHAR,NULL,p_OBJECT_VALUE5),
122 DECODE(p_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,p_DESCRIPTION),
123
124 FND_GLOBAL.RESP_APPL_ID,
125 DECODE(P_OBJECT_STATUS,FND_API.G_MISS_CHAR,NULL,P_OBJECT_STATUS),
126 DECODE(P_INTERNAL_FLAG,FND_API.G_MISS_CHAR,NULL,P_INTERNAL_FLAG),
127 DECODE(P_MESSAGE_APPLICATION,FND_API.G_MISS_CHAR,NULL,P_MESSAGE_APPLICATION),
128 DECODE(P_MESSAGE_NAME,FND_API.G_MISS_CHAR,NULL,P_MESSAGE_NAME),
129 DECODE(P_EXTRA_INFO1_TYPE,FND_API.G_MISS_CHAR,NULL,p_EXTRA_INFO1_TYPE),
130 DECODE(P_EXTRA_INFO1_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO1_REF_TYPE),
131 DECODE(P_EXTRA_INFO1_VALUE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO1_VALUE),
132 DECODE(P_EXTRA_INFO2_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO2_TYPE),
133 DECODE(P_EXTRA_INFO2_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO2_REF_TYPE),
134 DECODE(P_EXTRA_INFO2_VALUE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO2_VALUE),
135 DECODE(P_EXTRA_INFO3_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO3_TYPE),
136 DECODE(P_EXTRA_INFO3_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO3_REF_TYPE),
137 DECODE(P_EXTRA_INFO3_VALUE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO3_VALUE),
138 DECODE(P_EXTRA_INFO4_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO4_TYPE),
139 DECODE(P_EXTRA_INFO4_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO4_REF_TYPE),
140 DECODE(P_EXTRA_INFO4_VALUE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO4_VALUE),
141 DECODE(P_EXTRA_INFO5_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO5_TYPE),
142 DECODE(P_EXTRA_INFO5_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO5_REF_TYPE),
143 DECODE(P_EXTRA_INFO5_VALUE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO5_VALUE),
144
145 p_OBJECT_VERSION_NUMBER,
146 DECODE(p_creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
147 p_creation_date),
148 DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
149 NULL, FND_GLOBAL.user_id, p_created_by),
150 DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
151 p_last_update_date),
152 DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
153 NULL, FND_GLOBAL.user_id, p_last_updated_by),
154 DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
155 NULL, FND_GLOBAL.login_id, p_last_update_login)
156 );
157
158
159 OPEN c;
160 FETCH c INTO x_ROWID;
161 IF (c%NOTFOUND) THEN
162 CLOSE c;
163 RAISE NO_DATA_FOUND;
164 END IF;
165 CLOSE c;
166
167 END INSERT_ROW;
171 p_ACTIVITY IN VARCHAR2,
168
169 PROCEDURE LOCK_ROW (
170 p_AUDIT_LOG_ID IN NUMBER,
172 p_USER_ID IN NUMBER,
173 p_TIME_STAMP IN DATE,
174 p_OBJECT_TYPE IN VARCHAR2,
175 p_OBJECT_VALUE1 IN VARCHAR2,
176 p_OBJECT_VALUE2 IN VARCHAR2,
177 p_OBJECT_VALUE3 IN VARCHAR2,
178 p_OBJECT_VALUE4 IN VARCHAR2,
179 p_OBJECT_VALUE5 IN VARCHAR2,
180 p_DESCRIPTION IN VARCHAR2,
181
182 P_OBJECT_STATUS IN VARCHAR2,
183 P_INTERNAL_FLAG IN VARCHAR2,
184 P_MESSAGE_APPLICATION IN VARCHAR2,
185 P_MESSAGE_NAME IN VARCHAR2,
186 P_EXTRA_INFO1_TYPE IN VARCHAR2,
187 P_EXTRA_INFO1_REF_TYPE IN VARCHAR2,
188 P_EXTRA_INFO1_VALUE IN VARCHAR2,
189 P_EXTRA_INFO2_TYPE IN VARCHAR2,
190 P_EXTRA_INFO2_REF_TYPE IN VARCHAR2,
191 P_EXTRA_INFO2_VALUE IN VARCHAR2,
192 P_EXTRA_INFO3_TYPE IN VARCHAR2,
193 P_EXTRA_INFO3_REF_TYPE IN VARCHAR2,
194 P_EXTRA_INFO3_VALUE IN VARCHAR2,
195 P_EXTRA_INFO4_TYPE IN VARCHAR2,
196 P_EXTRA_INFO4_REF_TYPE IN VARCHAR2,
197 P_EXTRA_INFO4_VALUE IN VARCHAR2,
198 P_EXTRA_INFO5_TYPE IN VARCHAR2,
199 P_EXTRA_INFO5_REF_TYPE IN VARCHAR2,
200 P_EXTRA_INFO5_VALUE IN VARCHAR2,
201
202 p_OBJECT_VERSION_NUMBER IN NUMBER
203 ) IS
204 CURSOR c IS SELECT
205 ACTIVITY,
206 USER_ID,
207 TIME_STAMP,
208 OBJECT_TYPE,
209 OBJECT_VALUE1,
210 OBJECT_VALUE2,
211 OBJECT_VALUE3,
212 OBJECT_VALUE4,
213 OBJECT_VALUE5,
214 DESCRIPTION,
215
216 OBJECT_STATUS,
217 INTERNAL_FLAG,
218 MESSAGE_APPLICATION,
219 MESSAGE_NAME,
220 EXTRA_INFO1_TYPE,
221 EXTRA_INFO1_REF_TYPE,
222 EXTRA_INFO1_VALUE,
223 EXTRA_INFO2_TYPE,
224 EXTRA_INFO2_REF_TYPE,
225 EXTRA_INFO2_VALUE,
226 EXTRA_INFO3_TYPE,
227 EXTRA_INFO3_REF_TYPE,
228 EXTRA_INFO3_VALUE,
229 EXTRA_INFO4_TYPE,
230 EXTRA_INFO4_REF_TYPE,
231 EXTRA_INFO4_VALUE,
232 EXTRA_INFO5_TYPE,
233 EXTRA_INFO5_REF_TYPE,
234 EXTRA_INFO5_VALUE,
235
236 OBJECT_VERSION_NUMBER
237 FROM IBC_AUDIT_LOGS
238 WHERE AUDIT_LOG_ID = p_AUDIT_LOG_ID
239 FOR UPDATE OF AUDIT_LOG_ID NOWAIT;
240 recinfo c%ROWTYPE;
241
242
243 BEGIN
244 OPEN c;
245 FETCH c INTO recinfo;
246 IF (c%NOTFOUND) THEN
247 CLOSE c;
248 fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
249 app_exception.raise_exception;
250 END IF;
251 CLOSE c;
252 IF ( (recinfo.ACTIVITY = p_ACTIVITY)
253 AND (recinfo.USER_ID = p_USER_ID)
254 AND (recinfo.TIME_STAMP = p_TIME_STAMP)
255 AND (recinfo.OBJECT_TYPE = p_OBJECT_TYPE)
256 AND (recinfo.OBJECT_VALUE1 = p_OBJECT_VALUE1)
257 AND ((recinfo.OBJECT_VALUE2 = p_OBJECT_VALUE2)
258 OR ((recinfo.OBJECT_VALUE2 IS NULL) AND (p_OBJECT_VALUE2 IS NULL)))
259 AND ((recinfo.OBJECT_VALUE3 = p_OBJECT_VALUE3)
260 OR ((recinfo.OBJECT_VALUE3 IS NULL) AND (p_OBJECT_VALUE3 IS NULL)))
261 AND ((recinfo.OBJECT_VALUE4 = p_OBJECT_VALUE4)
262 OR ((recinfo.OBJECT_VALUE4 IS NULL) AND (p_OBJECT_VALUE4 IS NULL)))
263 AND ((recinfo.OBJECT_VALUE5 = p_OBJECT_VALUE5)
264 OR ((recinfo.OBJECT_VALUE5 IS NULL) AND (p_OBJECT_VALUE5 IS NULL)))
265 AND ((recinfo.DESCRIPTION = p_DESCRIPTION)
266 OR ((recinfo.DESCRIPTION IS NULL) AND (p_DESCRIPTION IS NULL)))
267
268 AND ((recinfo.OBJECT_STATUS = p_OBJECT_STATUS)
269 OR ((recinfo.OBJECT_STATUS IS NULL) AND (p_OBJECT_STATUS IS NULL)))
270 AND ((recinfo.INTERNAL_FLAG = p_INTERNAL_FLAG)
271 OR ((recinfo.INTERNAL_FLAG IS NULL) AND (p_INTERNAL_FLAG IS NULL)))
272 AND ((recinfo.MESSAGE_APPLICATION = p_MESSAGE_APPLICATION)
273 OR ((recinfo.MESSAGE_APPLICATION IS NULL) AND (p_MESSAGE_APPLICATION IS NULL)))
277 OR ((recinfo.EXTRA_INFO1_TYPE IS NULL) AND (p_EXTRA_INFO1_TYPE IS NULL)))
274 AND ((recinfo.MESSAGE_NAME = p_MESSAGE_NAME)
275 OR ((recinfo.MESSAGE_NAME IS NULL) AND (p_MESSAGE_NAME IS NULL)))
276 AND ((recinfo.EXTRA_INFO1_TYPE = p_EXTRA_INFO1_TYPE)
278 AND ((recinfo.EXTRA_INFO1_REF_TYPE = p_EXTRA_INFO1_REF_TYPE)
279 OR ((recinfo.EXTRA_INFO1_REF_TYPE IS NULL) AND (p_EXTRA_INFO1_REF_TYPE IS NULL)))
280 AND ((recinfo.EXTRA_INFO1_VALUE = p_EXTRA_INFO1_VALUE)
281 OR ((recinfo.EXTRA_INFO1_VALUE IS NULL) AND (p_EXTRA_INFO1_VALUE IS NULL)))
282 AND ((recinfo.EXTRA_INFO2_TYPE = p_EXTRA_INFO2_TYPE)
283 OR ((recinfo.EXTRA_INFO2_TYPE IS NULL) AND (p_EXTRA_INFO2_TYPE IS NULL)))
284 AND ((recinfo.EXTRA_INFO2_REF_TYPE = p_EXTRA_INFO2_REF_TYPE)
285 OR ((recinfo.EXTRA_INFO2_REF_TYPE IS NULL) AND (p_EXTRA_INFO2_REF_TYPE IS NULL)))
286 AND ((recinfo.EXTRA_INFO2_VALUE = p_EXTRA_INFO2_VALUE)
287 OR ((recinfo.EXTRA_INFO2_VALUE IS NULL) AND (p_EXTRA_INFO2_VALUE IS NULL)))
288 AND ((recinfo.EXTRA_INFO3_TYPE = p_EXTRA_INFO3_TYPE)
289 OR ((recinfo.EXTRA_INFO3_TYPE IS NULL) AND (p_EXTRA_INFO3_TYPE IS NULL)))
290 AND ((recinfo.EXTRA_INFO3_REF_TYPE = p_EXTRA_INFO3_REF_TYPE)
291 OR ((recinfo.EXTRA_INFO3_REF_TYPE IS NULL) AND (p_EXTRA_INFO3_REF_TYPE IS NULL)))
292 AND ((recinfo.EXTRA_INFO3_VALUE = p_EXTRA_INFO3_VALUE)
293 OR ((recinfo.EXTRA_INFO3_VALUE IS NULL) AND (p_EXTRA_INFO3_VALUE IS NULL)))
294 AND ((recinfo.EXTRA_INFO4_TYPE = p_EXTRA_INFO4_TYPE)
295 OR ((recinfo.EXTRA_INFO4_TYPE IS NULL) AND (p_EXTRA_INFO4_TYPE IS NULL)))
296 AND ((recinfo.EXTRA_INFO4_REF_TYPE = p_EXTRA_INFO4_REF_TYPE)
297 OR ((recinfo.EXTRA_INFO4_REF_TYPE IS NULL) AND (p_EXTRA_INFO4_REF_TYPE IS NULL)))
298 AND ((recinfo.EXTRA_INFO4_VALUE = p_EXTRA_INFO4_VALUE)
299 OR ((recinfo.EXTRA_INFO4_VALUE IS NULL) AND (p_EXTRA_INFO4_VALUE IS NULL)))
300 AND ((recinfo.EXTRA_INFO5_TYPE = p_EXTRA_INFO5_TYPE)
301 OR ((recinfo.EXTRA_INFO5_TYPE IS NULL) AND (p_EXTRA_INFO5_TYPE IS NULL)))
302 AND ((recinfo.EXTRA_INFO5_REF_TYPE = p_EXTRA_INFO5_REF_TYPE)
303 OR ((recinfo.EXTRA_INFO5_REF_TYPE IS NULL) AND (p_EXTRA_INFO5_REF_TYPE IS NULL)))
304 AND ((recinfo.EXTRA_INFO5_VALUE = p_EXTRA_INFO5_VALUE)
305 OR ((recinfo.EXTRA_INFO5_VALUE IS NULL) AND (p_EXTRA_INFO5_VALUE IS NULL)))
306
307 AND (recinfo.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER)
308 ) THEN
309 NULL;
310 ELSE
311 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
312 app_exception.raise_exception;
313 END IF;
314
315 RETURN;
316 END LOCK_ROW;
317
318 /*PROCEDURE UPDATE_ROW (
319 p_AUDIT_LOG_ID IN NUMBER,
320 p_ACTIVITY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
321 p_parent_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
322 p_DESCRIPTION IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
323 p_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
324 p_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
325 p_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,
326 p_OBJECT_TYPE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
327 p_OBJECT_VALUE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
328 p_OBJECT_VALUE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
329 p_OBJECT_VALUE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
330 p_OBJECT_VALUE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
331 p_OBJECT_VALUE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
332
333 P_OBJECT_STATUS IN VARCHAR2 DEFAULT NULL,
334 P_INTERNAL_FLAG IN VARCHAR2 DEFAULT NULL,
335 P_MESSAGE_APPLICATION IN VARCHAR2 DEFAULT NULL,
336 P_MESSAGE_NAME IN VARCHAR2 DEFAULT NULL,
337 P_EXTRA_INFO1_TYPE IN VARCHAR2 DEFAULT NULL,
338 P_EXTRA_INFO1_REF_TYPE IN VARCHAR2 DEFAULT NULL,
339 P_EXTRA_INFO1_VALUE IN VARCHAR2 DEFAULT NULL,
340 P_EXTRA_INFO2_TYPE IN VARCHAR2 DEFAULT NULL,
341 P_EXTRA_INFO2_REF_TYPE IN VARCHAR2 DEFAULT NULL,
342 P_EXTRA_INFO2_VALUE IN VARCHAR2 DEFAULT NULL,
343 P_EXTRA_INFO3_TYPE IN VARCHAR2 DEFAULT NULL,
344 P_EXTRA_INFO3_REF_TYPE IN VARCHAR2 DEFAULT NULL,
345 P_EXTRA_INFO3_VALUE IN VARCHAR2 DEFAULT NULL,
346 P_EXTRA_INFO4_TYPE IN VARCHAR2 DEFAULT NULL,
347 P_EXTRA_INFO4_REF_TYPE IN VARCHAR2 DEFAULT NULL,
348 P_EXTRA_INFO4_VALUE IN VARCHAR2 DEFAULT NULL,
349 P_EXTRA_INFO5_TYPE IN VARCHAR2 DEFAULT NULL,
353 p_OBJECT_VERSION_NUMBER IN NUMBER DEFAULT FND_API.G_MISS_NUM,
350 P_EXTRA_INFO5_REF_TYPE IN VARCHAR2 DEFAULT NULL,
351 P_EXTRA_INFO5_VALUE IN VARCHAR2 DEFAULT NULL,
352
354 p_TIME_STAMP IN DATE DEFAULT FND_API.G_MISS_DATE,
355 p_USER_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM
356 ) IS
357 BEGIN
358 UPDATE IBC_AUDIT_LOGS SET
359 ACTIVITY = DECODE(p_ACTIVITY,FND_API.G_MISS_CHAR,ACTIVITY,p_ACTIVITY),
360 PARENT_ID = DECODE(p_parent_id,FND_API.G_MISS_CHAR,parent_id,p_parent_id),
361 USER_ID = DECODE(p_USER_ID,FND_API.G_MISS_NUM,USER_ID,p_USER_ID),
362 TIME_STAMP = DECODE(p_TIME_STAMP,FND_API.G_MISS_DATE,TIME_STAMP,p_TIME_STAMP),
363 OBJECT_TYPE = DECODE(p_OBJECT_TYPE,FND_API.G_MISS_CHAR,OBJECT_TYPE,p_OBJECT_TYPE),
364 OBJECT_VALUE1 = DECODE(p_OBJECT_VALUE1,FND_API.G_MISS_CHAR,OBJECT_VALUE1,p_OBJECT_VALUE1),
365 OBJECT_VALUE2 = DECODE(p_OBJECT_VALUE2,FND_API.G_MISS_CHAR,OBJECT_VALUE2,p_OBJECT_VALUE2),
366 OBJECT_VALUE3 = DECODE(p_OBJECT_VALUE3,FND_API.G_MISS_CHAR,OBJECT_VALUE3,p_OBJECT_VALUE3),
367 OBJECT_VALUE4 = DECODE(p_OBJECT_VALUE4,FND_API.G_MISS_CHAR,OBJECT_VALUE4,p_OBJECT_VALUE4),
368 OBJECT_VALUE5 = DECODE(p_OBJECT_VALUE5,FND_API.G_MISS_CHAR,OBJECT_VALUE5,p_OBJECT_VALUE5),
369 DESCRIPTION = DECODE(p_DESCRIPTION,FND_API.G_MISS_CHAR,DESCRIPTION,p_DESCRIPTION),
370 OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
371 last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,
372 NULL, SYSDATE, p_last_update_date),
373 last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM,
374 FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
375 p_last_updated_by),
376 last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM,
377 FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
378 p_last_update_login)
379
380 WHERE AUDIT_LOG_ID = p_AUDIT_LOG_ID
381 AND object_version_number = DECODE(p_object_version_number,
382 FND_API.G_MISS_NUM,
383 object_version_number,
384 p_object_version_number);
385
386 IF (SQL%NOTFOUND) THEN
387 RAISE NO_DATA_FOUND;
388 END IF;
389
390
391 END UPDATE_ROW;
392 */
393
394 PROCEDURE DELETE_ROW (
395 p_AUDIT_LOG_ID IN NUMBER
396 ) IS
397 BEGIN
398
399 DELETE FROM IBC_AUDIT_LOGS
400 WHERE AUDIT_LOG_ID = p_AUDIT_LOG_ID;
401
402 IF (SQL%NOTFOUND) THEN
403 RAISE NO_DATA_FOUND;
404 END IF;
405 END DELETE_ROW;
406
407
408 END Ibc_Audit_Logs_Pkg;
[Home] [Help]