48: X_DATA_TYPE,
49: X_FLEX_VALUE_SET_ID,
50: 1,
51: X_CREATED_BY_MODULE,
52: FUN_RULE_UTILITY_PKG.CREATED_BY,
53: FUN_RULE_UTILITY_PKG.CREATION_DATE,
54: FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN,
55: FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE,
56: FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY
49: X_FLEX_VALUE_SET_ID,
50: 1,
51: X_CREATED_BY_MODULE,
52: FUN_RULE_UTILITY_PKG.CREATED_BY,
53: FUN_RULE_UTILITY_PKG.CREATION_DATE,
54: FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN,
55: FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE,
56: FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY
57: )RETURNING ROWID INTO X_ROWID;
50: 1,
51: X_CREATED_BY_MODULE,
52: FUN_RULE_UTILITY_PKG.CREATED_BY,
53: FUN_RULE_UTILITY_PKG.CREATION_DATE,
54: FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN,
55: FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE,
56: FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY
57: )RETURNING ROWID INTO X_ROWID;
58:
51: X_CREATED_BY_MODULE,
52: FUN_RULE_UTILITY_PKG.CREATED_BY,
53: FUN_RULE_UTILITY_PKG.CREATION_DATE,
54: FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN,
55: FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE,
56: FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY
57: )RETURNING ROWID INTO X_ROWID;
58:
59:
52: FUN_RULE_UTILITY_PKG.CREATED_BY,
53: FUN_RULE_UTILITY_PKG.CREATION_DATE,
54: FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN,
55: FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE,
56: FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY
57: )RETURNING ROWID INTO X_ROWID;
58:
59:
60: insert into FUN_RULE_CRIT_PARAMS_TL (
73: NVL(X_CRITERIA_PARAM_ID,l_seq_val),
74: X_USER_PARAM_NAME,
75: X_DESCRIPTION,
76: X_TIP_TEXT,
77: FUN_RULE_UTILITY_PKG.CREATED_BY,
78: FUN_RULE_UTILITY_PKG.CREATION_DATE,
79: FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN,
80: FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE,
81: FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY,
74: X_USER_PARAM_NAME,
75: X_DESCRIPTION,
76: X_TIP_TEXT,
77: FUN_RULE_UTILITY_PKG.CREATED_BY,
78: FUN_RULE_UTILITY_PKG.CREATION_DATE,
79: FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN,
80: FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE,
81: FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY,
82: L.LANGUAGE_CODE,
75: X_DESCRIPTION,
76: X_TIP_TEXT,
77: FUN_RULE_UTILITY_PKG.CREATED_BY,
78: FUN_RULE_UTILITY_PKG.CREATION_DATE,
79: FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN,
80: FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE,
81: FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY,
82: L.LANGUAGE_CODE,
83: userenv('LANG')
76: X_TIP_TEXT,
77: FUN_RULE_UTILITY_PKG.CREATED_BY,
78: FUN_RULE_UTILITY_PKG.CREATION_DATE,
79: FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN,
80: FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE,
81: FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY,
82: L.LANGUAGE_CODE,
83: userenv('LANG')
84: from FND_LANGUAGES L
77: FUN_RULE_UTILITY_PKG.CREATED_BY,
78: FUN_RULE_UTILITY_PKG.CREATION_DATE,
79: FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN,
80: FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE,
81: FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY,
82: L.LANGUAGE_CODE,
83: userenv('LANG')
84: from FND_LANGUAGES L
85: where L.INSTALLED_FLAG in ('I', 'B')
166: DATA_TYPE = X_DATA_TYPE,
167: FLEX_VALUE_SET_ID = X_FLEX_VALUE_SET_ID,
168: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
169: CREATED_BY_MODULE = X_CREATED_BY_MODULE,
170: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN),
171: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE),
172: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY)
173: where CRITERIA_PARAM_ID = l_rule_criteria_param_id;
174:
167: FLEX_VALUE_SET_ID = X_FLEX_VALUE_SET_ID,
168: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
169: CREATED_BY_MODULE = X_CREATED_BY_MODULE,
170: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN),
171: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE),
172: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY)
173: where CRITERIA_PARAM_ID = l_rule_criteria_param_id;
174:
175: if (sql%notfound) then
168: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
169: CREATED_BY_MODULE = X_CREATED_BY_MODULE,
170: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN),
171: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE),
172: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY)
173: where CRITERIA_PARAM_ID = l_rule_criteria_param_id;
174:
175: if (sql%notfound) then
176: raise no_data_found;
179: update FUN_RULE_CRIT_PARAMS_TL set
180: USER_PARAM_NAME = X_USER_PARAM_NAME,
181: DESCRIPTION = X_DESCRIPTION,
182: TIP_TEXT = X_TIP_TEXT,
183: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN),
184: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE),
185: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY),
186: SOURCE_LANG = userenv('LANG')
187: where CRITERIA_PARAM_ID = l_rule_criteria_param_id
180: USER_PARAM_NAME = X_USER_PARAM_NAME,
181: DESCRIPTION = X_DESCRIPTION,
182: TIP_TEXT = X_TIP_TEXT,
183: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN),
184: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE),
185: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY),
186: SOURCE_LANG = userenv('LANG')
187: where CRITERIA_PARAM_ID = l_rule_criteria_param_id
188: and userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
181: DESCRIPTION = X_DESCRIPTION,
182: TIP_TEXT = X_TIP_TEXT,
183: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN),
184: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE),
185: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY),
186: SOURCE_LANG = userenv('LANG')
187: where CRITERIA_PARAM_ID = l_rule_criteria_param_id
188: and userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
189: