APPS.AML_MONITOR_CONDITIONS_PKG dependencies on AML_MONITOR_CONDITIONS

Line 1: PACKAGE BODY aml_MONITOR_CONDITIONS_PKG as

1: PACKAGE BODY aml_MONITOR_CONDITIONS_PKG as
2: /* $Header: amltlmcb.pls 115.2 2002/12/13 22:44:06 swkhanna noship $ */
3: -- Start of Comments
4: -- Package name : aml_MONITOR_CONDITIONS_PKG
5: -- Purpose :

Line 4: -- Package name : aml_MONITOR_CONDITIONS_PKG

1: PACKAGE BODY aml_MONITOR_CONDITIONS_PKG as
2: /* $Header: amltlmcb.pls 115.2 2002/12/13 22:44:06 swkhanna noship $ */
3: -- Start of Comments
4: -- Package name : aml_MONITOR_CONDITIONS_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

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

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

Line 60: CURSOR C2 IS SELECT aml_MONITOR_CONDITIONS_S.nextval FROM sys.dual;

56: ,p_ATTRIBUTE14 VARCHAR2
57: ,p_ATTRIBUTE15 VARCHAR2
58: )
59: IS
60: CURSOR C2 IS SELECT aml_MONITOR_CONDITIONS_S.nextval FROM sys.dual;
61: BEGIN
62: If (px_MONITOR_CONDITION_ID IS NULL) OR (px_MONITOR_CONDITION_ID = FND_API.G_MISS_NUM) then
63: OPEN C2;
64: FETCH C2 INTO px_MONITOR_CONDITION_ID;

Line 67: INSERT INTO aml_MONITOR_CONDITIONS(

63: OPEN C2;
64: FETCH C2 INTO px_MONITOR_CONDITION_ID;
65: CLOSE C2;
66: End If;
67: INSERT INTO aml_MONITOR_CONDITIONS(
68: MONITOR_CONDITION_ID
69: ,LAST_UPDATE_DATE
70: ,LAST_UPDATED_BY
71: ,CREATION_DATE

Line 205: Update aml_MONITOR_CONDITIONS

201: ,p_ATTRIBUTE15 VARCHAR2
202: )
203: IS
204: BEGIN
205: Update aml_MONITOR_CONDITIONS
206: SET
207: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
208: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
209: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)

Line 260: DELETE FROM amL_MONITOR_CONDITIONS

256: PROCEDURE Delete_Row(
257: p_process_rule_id NUMBER)
258: IS
259: BEGIN
260: DELETE FROM amL_MONITOR_CONDITIONS
261: WHERE PROCESS_RULE_ID = p_process_rule_id;
262: If (SQL%NOTFOUND) then
263: RAISE NO_DATA_FOUND;
264: End If;

Line 315: FROM amL_MONITOR_CONDITIONS

311: )
312: IS
313: CURSOR C IS
314: SELECT *
315: FROM amL_MONITOR_CONDITIONS
316: WHERE MONITOR_CONDITION_ID = p_MONITOR_CONDITION_ID
317: FOR UPDATE of MONITOR_CONDITION_ID NOWAIT;
318: Recinfo C%ROWTYPE;
319: BEGIN

Line 464: End aml_MONITOR_CONDITIONS_PKG;

460: APP_EXCEPTION.RAISE_EXCEPTION;
461: End If;
462: END Lock_Row;
463:
464: End aml_MONITOR_CONDITIONS_PKG;