APPS.IBC_AUDIT_LOGS_PKG dependencies on IBC_AUDIT_LOGS

Line 1: PACKAGE BODY Ibc_Audit_Logs_Pkg AS

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:

Line 4: -- Purpose: Table Handler for Ibc_Audit_Logs table.

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: -- --------- ------ ------------------------------------------

Line 54: CURSOR C IS SELECT ROWID FROM IBC_AUDIT_LOGS

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

Line 56: CURSOR c2 IS SELECT ibc_audit_logs_s1.NEXTVAL FROM dual;

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

Line 69: INSERT INTO IBC_AUDIT_LOGS (

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,

Line 237: FROM IBC_AUDIT_LOGS

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:

Line 358: UPDATE IBC_AUDIT_LOGS SET

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),

Line 399: DELETE FROM IBC_AUDIT_LOGS

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;

Line 408: END Ibc_Audit_Logs_Pkg;

404: END IF;
405: END DELETE_ROW;
406:
407:
408: END Ibc_Audit_Logs_Pkg;