APPS.FUN_RULE_CRITERIA_PKG dependencies on FUN_RULE_CRITERIA

Line 1: PACKAGE BODY FUN_RULE_CRITERIA_PKG AS

1: PACKAGE BODY FUN_RULE_CRITERIA_PKG AS
2: /*$Header: FUNXTMRULRCTTBB.pls 120.0 2005/06/20 04:30:01 ammishra noship $ */
3:
4: PROCEDURE Insert_Row (
5: X_ROWID IN OUT NOCOPY VARCHAR2,

Line 17: INSERT INTO FUN_RULE_CRITERIA (

13: ) IS
14:
15: BEGIN
16:
17: INSERT INTO FUN_RULE_CRITERIA (
18: CRITERIA_ID,
19: RULE_DETAIL_ID,
20: CRITERIA_PARAM_ID,
21: CONDITION,

Line 33: DECODE( X_CRITERIA_ID, NULL , FUN_RULE_CRITERIA_S.NEXTVAL , X_CRITERIA_ID),

29: OBJECT_VERSION_NUMBER,
30: CREATED_BY_MODULE
31: )
32: VALUES (
33: DECODE( X_CRITERIA_ID, NULL , FUN_RULE_CRITERIA_S.NEXTVAL , X_CRITERIA_ID),
34: DECODE( X_RULE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, X_RULE_DETAIL_ID ),
35: DECODE( X_CRITERIA_PARAM_ID, FND_API.G_MISS_NUM, NULL, X_CRITERIA_PARAM_ID ),
36: DECODE( X_CONDITION, FND_API.G_MISS_CHAR, NULL, X_CONDITION ),
37: DECODE( X_PARAM_VALUE, FND_API.G_MISS_CHAR, NULL, X_PARAM_VALUE ),

Line 62: UPDATE FUN_RULE_CRITERIA SET

58: ) IS
59:
60: BEGIN
61:
62: UPDATE FUN_RULE_CRITERIA SET
63: CRITERIA_PARAM_ID = DECODE( X_CRITERIA_PARAM_ID, FND_API.G_MISS_CHAR, NULL, NULL,CRITERIA_PARAM_ID, X_CRITERIA_PARAM_ID ),
64: CONDITION = X_CONDITION,
65:
66: --Param Value can be NULL, we should not overwrite the value with old value if its not null.

Line 91: SELECT OBJECT_VERSION_NUMBER FROM FUN_RULE_CRITERIA

87: X_OBJECT_VERSION_NUMBER IN NUMBER
88: ) IS
89:
90: CURSOR C IS
91: SELECT OBJECT_VERSION_NUMBER FROM FUN_RULE_CRITERIA
92: WHERE CRITERIA_ID = X_CRITERIA_ID
93: FOR UPDATE NOWAIT;
94: Recinfo C%ROWTYPE;
95:

Line 148: FROM FUN_RULE_CRITERIA

144: X_CONDITION,
145: X_PARAM_VALUE,
146: X_CASE_SENSITIVE_FLAG,
147: X_CREATED_BY_MODULE
148: FROM FUN_RULE_CRITERIA
149: WHERE CRITERIA_ID = X_CRITERIA_ID
150: AND ROWNUM = 1;
151:
152:

Line 169: DELETE FUN_RULE_CRITERIA

165: ) IS
166:
167: BEGIN
168:
169: DELETE FUN_RULE_CRITERIA
170: WHERE CRITERIA_ID = X_CRITERIA_ID;
171:
172: IF ( SQL%NOTFOUND ) THEN
173: RAISE NO_DATA_FOUND;

Line 178: END FUN_RULE_CRITERIA_PKG;

174: END IF;
175:
176: END Delete_Row;
177:
178: END FUN_RULE_CRITERIA_PKG;