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 ),
38: DECODE( X_CASE_SENSITIVE_FLAG, FND_API.G_MISS_CHAR, NULL, X_CASE_SENSITIVE_FLAG ),
39: FUN_RULE_UTILITY_PKG.CREATED_BY,
40: FUN_RULE_UTILITY_PKG.CREATION_DATE,
41: FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN,
42: FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE,
43: FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY,
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 ),
38: DECODE( X_CASE_SENSITIVE_FLAG, FND_API.G_MISS_CHAR, NULL, X_CASE_SENSITIVE_FLAG ),
39: FUN_RULE_UTILITY_PKG.CREATED_BY,
40: FUN_RULE_UTILITY_PKG.CREATION_DATE,
41: FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN,
42: FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE,
43: FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY,
44: 1,
37: DECODE( X_PARAM_VALUE, FND_API.G_MISS_CHAR, NULL, X_PARAM_VALUE ),
38: DECODE( X_CASE_SENSITIVE_FLAG, FND_API.G_MISS_CHAR, NULL, X_CASE_SENSITIVE_FLAG ),
39: FUN_RULE_UTILITY_PKG.CREATED_BY,
40: FUN_RULE_UTILITY_PKG.CREATION_DATE,
41: FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN,
42: FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE,
43: FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY,
44: 1,
45: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE )
38: DECODE( X_CASE_SENSITIVE_FLAG, FND_API.G_MISS_CHAR, NULL, X_CASE_SENSITIVE_FLAG ),
39: FUN_RULE_UTILITY_PKG.CREATED_BY,
40: FUN_RULE_UTILITY_PKG.CREATION_DATE,
41: FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN,
42: FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE,
43: FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY,
44: 1,
45: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE )
46: )RETURNING ROWID INTO X_ROWID;
39: FUN_RULE_UTILITY_PKG.CREATED_BY,
40: FUN_RULE_UTILITY_PKG.CREATION_DATE,
41: FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN,
42: FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE,
43: FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY,
44: 1,
45: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE )
46: )RETURNING ROWID INTO X_ROWID;
47:
66: --Param Value can be NULL, we should not overwrite the value with old value if its not null.
67: PARAM_VALUE = DECODE( X_PARAM_VALUE, FND_API.G_MISS_CHAR, NULL, X_PARAM_VALUE ),
68:
69: CASE_SENSITIVE_FLAG = DECODE( X_CASE_SENSITIVE_FLAG, FND_API.G_MISS_CHAR, NULL, NULL,CASE_SENSITIVE_FLAG, X_CASE_SENSITIVE_FLAG ),
70: CREATED_BY = FUN_RULE_UTILITY_PKG.CREATED_BY,
71: CREATION_DATE = FUN_RULE_UTILITY_PKG.CREATION_DATE,
72: LAST_UPDATE_LOGIN = FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN,
73: LAST_UPDATE_DATE = FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE,
74: LAST_UPDATED_BY = FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY,
67: PARAM_VALUE = DECODE( X_PARAM_VALUE, FND_API.G_MISS_CHAR, NULL, X_PARAM_VALUE ),
68:
69: CASE_SENSITIVE_FLAG = DECODE( X_CASE_SENSITIVE_FLAG, FND_API.G_MISS_CHAR, NULL, NULL,CASE_SENSITIVE_FLAG, X_CASE_SENSITIVE_FLAG ),
70: CREATED_BY = FUN_RULE_UTILITY_PKG.CREATED_BY,
71: CREATION_DATE = FUN_RULE_UTILITY_PKG.CREATION_DATE,
72: LAST_UPDATE_LOGIN = FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN,
73: LAST_UPDATE_DATE = FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE,
74: LAST_UPDATED_BY = FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY,
75: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
68:
69: CASE_SENSITIVE_FLAG = DECODE( X_CASE_SENSITIVE_FLAG, FND_API.G_MISS_CHAR, NULL, NULL,CASE_SENSITIVE_FLAG, X_CASE_SENSITIVE_FLAG ),
70: CREATED_BY = FUN_RULE_UTILITY_PKG.CREATED_BY,
71: CREATION_DATE = FUN_RULE_UTILITY_PKG.CREATION_DATE,
72: LAST_UPDATE_LOGIN = FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN,
73: LAST_UPDATE_DATE = FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE,
74: LAST_UPDATED_BY = FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY,
75: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
76: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, NULL,CREATED_BY_MODULE, X_CREATED_BY_MODULE )
69: CASE_SENSITIVE_FLAG = DECODE( X_CASE_SENSITIVE_FLAG, FND_API.G_MISS_CHAR, NULL, NULL,CASE_SENSITIVE_FLAG, X_CASE_SENSITIVE_FLAG ),
70: CREATED_BY = FUN_RULE_UTILITY_PKG.CREATED_BY,
71: CREATION_DATE = FUN_RULE_UTILITY_PKG.CREATION_DATE,
72: LAST_UPDATE_LOGIN = FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN,
73: LAST_UPDATE_DATE = FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE,
74: LAST_UPDATED_BY = FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY,
75: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
76: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, NULL,CREATED_BY_MODULE, X_CREATED_BY_MODULE )
77: WHERE CRITERIA_ID = X_CRITERIA_ID;
70: CREATED_BY = FUN_RULE_UTILITY_PKG.CREATED_BY,
71: CREATION_DATE = FUN_RULE_UTILITY_PKG.CREATION_DATE,
72: LAST_UPDATE_LOGIN = FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN,
73: LAST_UPDATE_DATE = FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE,
74: LAST_UPDATED_BY = FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY,
75: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
76: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, NULL,CREATED_BY_MODULE, X_CREATED_BY_MODULE )
77: WHERE CRITERIA_ID = X_CRITERIA_ID;
78: