APPS.AML_MONITOR_LOG_PKG dependencies on AML_MONITOR_LOG

Line 1: PACKAGE BODY aml_MONITOR_LOG_PKG as

1: PACKAGE BODY aml_MONITOR_LOG_PKG as
2: /* $Header: amltlmlb.pls 115.4 2003/01/20 18:24:42 swkhanna ship $ */
3: -- Start of Comments
4: -- Package name : aml_MONITOR_LOG_PKG
5: -- Purpose :

Line 4: -- Package name : aml_MONITOR_LOG_PKG

1: PACKAGE BODY aml_MONITOR_LOG_PKG as
2: /* $Header: amltlmlb.pls 115.4 2003/01/20 18:24:42 swkhanna ship $ */
3: -- Start of Comments
4: -- Package name : aml_MONITOR_LOG_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'aml_MONITOR_LOG_PKG';

7: -- NOTE :
8: -- End of Comments
9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'aml_MONITOR_LOG_PKG';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amltlmlb.pls';
13:
14: PROCEDURE Insert_Row(
15: px_MONITOR_LOG_ID IN OUT NOCOPY NUMBER

Line 49: CURSOR C2 IS SELECT aml_MONITOR_LOG_S.nextval FROM sys.dual;

45: ,p_ATTRIBUTE14 VARCHAR2
46: ,p_ATTRIBUTE15 VARCHAR2
47: )
48: IS
49: CURSOR C2 IS SELECT aml_MONITOR_LOG_S.nextval FROM sys.dual;
50: BEGIN
51: If (px_MONITOR_LOG_ID IS NULL) OR (px_MONITOR_LOG_ID = FND_API.G_MISS_NUM) then
52: OPEN C2;
53: FETCH C2 INTO px_MONITOR_LOG_ID;

Line 56: INSERT INTO aml_MONITOR_LOG(

52: OPEN C2;
53: FETCH C2 INTO px_MONITOR_LOG_ID;
54: CLOSE C2;
55: End If;
56: INSERT INTO aml_MONITOR_LOG(
57: MONITOR_LOG_ID
58: ,LAST_UPDATE_DATE
59: ,LAST_UPDATED_BY
60: ,CREATION_DATE

Line 161: Update aml_MONITOR_LOG

157: ,p_ATTRIBUTE15 VARCHAR2
158: )
159: IS
160: BEGIN
161: Update aml_MONITOR_LOG
162: SET
163: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
164: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
165: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)

Line 205: DELETE FROM aml_MONITOR_LOG

201: PROCEDURE Delete_Row(
202: p_MONITOR_LOG_ID NUMBER)
203: IS
204: BEGIN
205: DELETE FROM aml_MONITOR_LOG
206: WHERE MONITOR_LOG_ID = p_MONITOR_LOG_ID;
207: If (SQL%NOTFOUND) then
208: RAISE NO_DATA_FOUND;
209: End If;

Line 249: FROM aml_MONITOR_LOG

245: )
246: IS
247: CURSOR C IS
248: SELECT *
249: FROM aml_MONITOR_LOG
250: WHERE MONITOR_LOG_ID = p_MONITOR_LOG_ID
251: FOR UPDATE of MONITOR_LOG_ID NOWAIT;
252: Recinfo C%ROWTYPE;
253: BEGIN

Line 365: End aml_MONITOR_LOG_PKG;

361: APP_EXCEPTION.RAISE_EXCEPTION;
362: End If;
363: END Lock_Row;
364:
365: End aml_MONITOR_LOG_PKG;