APPS.FUN_RULE_CRITERIA_PKG dependencies on FUN_RULE_CRITERIA_S

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.