APPS.AML_RULE_APPLIED_ATTRS_PKG dependencies on AML_RULE_APPLIED_ATTRS

Line 1: PACKAGE BODY AML_RULE_APPLIED_ATTRS_PKG as

1: PACKAGE BODY AML_RULE_APPLIED_ATTRS_PKG as
2: /* $Header: amltrlgb.pls 115.3 2004/04/28 22:53:13 ckapoor noship $ */
3: -- Start of Comments
4: -- Package name : AML_RULE_APPLIED_ATTRS_PKG
5: -- Purpose :

Line 4: -- Package name : AML_RULE_APPLIED_ATTRS_PKG

1: PACKAGE BODY AML_RULE_APPLIED_ATTRS_PKG as
2: /* $Header: amltrlgb.pls 115.3 2004/04/28 22:53:13 ckapoor noship $ */
3: -- Start of Comments
4: -- Package name : AML_RULE_APPLIED_ATTRS_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

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

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

Line 34: CURSOR C2 IS SELECT AML_RULE_APPLIED_ATTRS_S.nextval FROM sys.dual;

30: ,p_ATTRIBUTE_TO_VALUE VARCHAR2
31: ,p_LEAD_VALUE VARCHAR2
32: )
33: IS
34: CURSOR C2 IS SELECT AML_RULE_APPLIED_ATTRS_S.nextval FROM sys.dual;
35: BEGIN
36: If (px_RULE_APPLIED_ATTR_ID IS NULL) OR (px_RULE_APPLIED_ATTR_ID = FND_API.G_MISS_NUM) then
37: OPEN C2;
38: FETCH C2 INTO px_RULE_APPLIED_ATTR_ID;

Line 47: INSERT INTO AML_RULE_APPLIED_ATTRS(

43: THEN
44: RETURN;
45: END IF;
46:
47: INSERT INTO AML_RULE_APPLIED_ATTRS(
48: RULE_APPLIED_ATTR_ID
49: ,LAST_UPDATE_DATE
50: ,LAST_UPDATED_BY
51: ,CREATION_DATE

Line 108: Update AML_RULE_APPLIED_ATTRS

104: ,p_LEAD_VALUE VARCHAR2
105: )
106: IS
107: BEGIN
108: Update AML_RULE_APPLIED_ATTRS
109: SET
110: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
111: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
112: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)

Line 138: DELETE FROM AML_RULE_APPLIED_ATTRS

134: PROCEDURE Delete_Row(
135: p_RULE_APPLIED_ATTR_ID NUMBER)
136: IS
137: BEGIN
138: DELETE FROM AML_RULE_APPLIED_ATTRS
139: WHERE RULE_APPLIED_ATTR_ID = p_RULE_APPLIED_ATTR_ID;
140: If (SQL%NOTFOUND) then
141: RAISE NO_DATA_FOUND;
142: End If;

Line 167: FROM AML_RULE_APPLIED_ATTRS

163: )
164: IS
165: CURSOR C IS
166: SELECT *
167: FROM AML_RULE_APPLIED_ATTRS
168: WHERE RULE_APPLIED_ATTR_ID = p_RULE_APPLIED_ATTR_ID
169: FOR UPDATE of RULE_APPLIED_ATTR_ID NOWAIT;
170: Recinfo C%ROWTYPE;
171: BEGIN

Line 238: End AML_RULE_APPLIED_ATTRS_PKG;

234: APP_EXCEPTION.RAISE_EXCEPTION;
235: End If;
236: END Lock_Row;
237:
238: End AML_RULE_APPLIED_ATTRS_PKG;