178: X_INSTANCE_LABEL,
179: NVL(X_PARENT_RULE_OBJECT_ID,l_parent_rule_object_id),
180: X_ORG_ID,
181: X_CREATED_BY_MODULE,
182: NVL(X_CREATED_BY,FUN_RULE_UTILITY_PKG.CREATED_BY),
183: NVL(X_CREATION_DATE,FUN_RULE_UTILITY_PKG.CREATION_DATE),
184: NVL(X_LAST_UPDATE_LOGIN,FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN),
185: NVL(X_LAST_UPDATE_DATE,FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE),
186: NVL(X_LAST_UPDATED_BY,FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY)
179: NVL(X_PARENT_RULE_OBJECT_ID,l_parent_rule_object_id),
180: X_ORG_ID,
181: X_CREATED_BY_MODULE,
182: NVL(X_CREATED_BY,FUN_RULE_UTILITY_PKG.CREATED_BY),
183: NVL(X_CREATION_DATE,FUN_RULE_UTILITY_PKG.CREATION_DATE),
184: NVL(X_LAST_UPDATE_LOGIN,FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN),
185: NVL(X_LAST_UPDATE_DATE,FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE),
186: NVL(X_LAST_UPDATED_BY,FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY)
187: )RETURNING ROWID INTO X_ROWID;
180: X_ORG_ID,
181: X_CREATED_BY_MODULE,
182: NVL(X_CREATED_BY,FUN_RULE_UTILITY_PKG.CREATED_BY),
183: NVL(X_CREATION_DATE,FUN_RULE_UTILITY_PKG.CREATION_DATE),
184: NVL(X_LAST_UPDATE_LOGIN,FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN),
185: NVL(X_LAST_UPDATE_DATE,FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE),
186: NVL(X_LAST_UPDATED_BY,FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY)
187: )RETURNING ROWID INTO X_ROWID;
188:
181: X_CREATED_BY_MODULE,
182: NVL(X_CREATED_BY,FUN_RULE_UTILITY_PKG.CREATED_BY),
183: NVL(X_CREATION_DATE,FUN_RULE_UTILITY_PKG.CREATION_DATE),
184: NVL(X_LAST_UPDATE_LOGIN,FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN),
185: NVL(X_LAST_UPDATE_DATE,FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE),
186: NVL(X_LAST_UPDATED_BY,FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY)
187: )RETURNING ROWID INTO X_ROWID;
188:
189:
182: NVL(X_CREATED_BY,FUN_RULE_UTILITY_PKG.CREATED_BY),
183: NVL(X_CREATION_DATE,FUN_RULE_UTILITY_PKG.CREATION_DATE),
184: NVL(X_LAST_UPDATE_LOGIN,FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN),
185: NVL(X_LAST_UPDATE_DATE,FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE),
186: NVL(X_LAST_UPDATED_BY,FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY)
187: )RETURNING ROWID INTO X_ROWID;
188:
189:
190: insert into FUN_RULE_OBJECTS_TL (
201: ) select
202: X_RULE_OBJECT_ID,
203: X_USER_RULE_OBJECT_NAME,
204: X_DESCRIPTION,
205: NVL(X_CREATED_BY,FUN_RULE_UTILITY_PKG.CREATED_BY),
206: NVL(X_CREATION_DATE,FUN_RULE_UTILITY_PKG.CREATION_DATE),
207: NVL(X_LAST_UPDATE_LOGIN,FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN),
208: NVL(X_LAST_UPDATE_DATE,FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE),
209: NVL(X_LAST_UPDATED_BY,FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY),
202: X_RULE_OBJECT_ID,
203: X_USER_RULE_OBJECT_NAME,
204: X_DESCRIPTION,
205: NVL(X_CREATED_BY,FUN_RULE_UTILITY_PKG.CREATED_BY),
206: NVL(X_CREATION_DATE,FUN_RULE_UTILITY_PKG.CREATION_DATE),
207: NVL(X_LAST_UPDATE_LOGIN,FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN),
208: NVL(X_LAST_UPDATE_DATE,FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE),
209: NVL(X_LAST_UPDATED_BY,FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY),
210: L.LANGUAGE_CODE,
203: X_USER_RULE_OBJECT_NAME,
204: X_DESCRIPTION,
205: NVL(X_CREATED_BY,FUN_RULE_UTILITY_PKG.CREATED_BY),
206: NVL(X_CREATION_DATE,FUN_RULE_UTILITY_PKG.CREATION_DATE),
207: NVL(X_LAST_UPDATE_LOGIN,FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN),
208: NVL(X_LAST_UPDATE_DATE,FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE),
209: NVL(X_LAST_UPDATED_BY,FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY),
210: L.LANGUAGE_CODE,
211: userenv('LANG')
204: X_DESCRIPTION,
205: NVL(X_CREATED_BY,FUN_RULE_UTILITY_PKG.CREATED_BY),
206: NVL(X_CREATION_DATE,FUN_RULE_UTILITY_PKG.CREATION_DATE),
207: NVL(X_LAST_UPDATE_LOGIN,FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN),
208: NVL(X_LAST_UPDATE_DATE,FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE),
209: NVL(X_LAST_UPDATED_BY,FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY),
210: L.LANGUAGE_CODE,
211: userenv('LANG')
212: from FND_LANGUAGES L
205: NVL(X_CREATED_BY,FUN_RULE_UTILITY_PKG.CREATED_BY),
206: NVL(X_CREATION_DATE,FUN_RULE_UTILITY_PKG.CREATION_DATE),
207: NVL(X_LAST_UPDATE_LOGIN,FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN),
208: NVL(X_LAST_UPDATE_DATE,FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE),
209: NVL(X_LAST_UPDATED_BY,FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY),
210: L.LANGUAGE_CODE,
211: userenv('LANG')
212: from FND_LANGUAGES L
213: where L.INSTALLED_FLAG in ('I', 'B')
260: values (
261: X_RULE_OBJECT_ID,
262: X_DEFAULT_APPLICATION_ID,
263: X_DEFAULT_VALUE,
264: NVL(X_CREATED_BY,FUN_RULE_UTILITY_PKG.CREATED_BY),
265: NVL(X_CREATION_DATE,FUN_RULE_UTILITY_PKG.CREATION_DATE),
266: NVL(X_LAST_UPDATE_LOGIN,FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN),
267: NVL(X_LAST_UPDATE_DATE,FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE),
268: NVL(X_LAST_UPDATED_BY,FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY)
261: X_RULE_OBJECT_ID,
262: X_DEFAULT_APPLICATION_ID,
263: X_DEFAULT_VALUE,
264: NVL(X_CREATED_BY,FUN_RULE_UTILITY_PKG.CREATED_BY),
265: NVL(X_CREATION_DATE,FUN_RULE_UTILITY_PKG.CREATION_DATE),
266: NVL(X_LAST_UPDATE_LOGIN,FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN),
267: NVL(X_LAST_UPDATE_DATE,FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE),
268: NVL(X_LAST_UPDATED_BY,FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY)
269: );
262: X_DEFAULT_APPLICATION_ID,
263: X_DEFAULT_VALUE,
264: NVL(X_CREATED_BY,FUN_RULE_UTILITY_PKG.CREATED_BY),
265: NVL(X_CREATION_DATE,FUN_RULE_UTILITY_PKG.CREATION_DATE),
266: NVL(X_LAST_UPDATE_LOGIN,FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN),
267: NVL(X_LAST_UPDATE_DATE,FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE),
268: NVL(X_LAST_UPDATED_BY,FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY)
269: );
270:
263: X_DEFAULT_VALUE,
264: NVL(X_CREATED_BY,FUN_RULE_UTILITY_PKG.CREATED_BY),
265: NVL(X_CREATION_DATE,FUN_RULE_UTILITY_PKG.CREATION_DATE),
266: NVL(X_LAST_UPDATE_LOGIN,FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN),
267: NVL(X_LAST_UPDATE_DATE,FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE),
268: NVL(X_LAST_UPDATED_BY,FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY)
269: );
270:
271: open c(X_RULE_OBJECT_ID);
264: NVL(X_CREATED_BY,FUN_RULE_UTILITY_PKG.CREATED_BY),
265: NVL(X_CREATION_DATE,FUN_RULE_UTILITY_PKG.CREATION_DATE),
266: NVL(X_LAST_UPDATE_LOGIN,FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN),
267: NVL(X_LAST_UPDATE_DATE,FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE),
268: NVL(X_LAST_UPDATED_BY,FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY)
269: );
270:
271: open c(X_RULE_OBJECT_ID);
272: fetch c into X_ROWID;
407: USE_INSTANCE_FLAG = NVL(X_USE_INSTANCE_FLAG,'N'),
408: INSTANCE_LABEL = X_INSTANCE_LABEL,
409: PARENT_RULE_OBJECT_ID = X_PARENT_RULE_OBJECT_ID,
410: ORG_ID = X_ORG_ID,
411: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE),
412: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY),
413: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN)
414: where RULE_OBJECT_ID = X_RULE_OBJECT_ID;
415:
408: INSTANCE_LABEL = X_INSTANCE_LABEL,
409: PARENT_RULE_OBJECT_ID = X_PARENT_RULE_OBJECT_ID,
410: ORG_ID = X_ORG_ID,
411: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE),
412: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY),
413: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN)
414: where RULE_OBJECT_ID = X_RULE_OBJECT_ID;
415:
416: if (sql%notfound) then
409: PARENT_RULE_OBJECT_ID = X_PARENT_RULE_OBJECT_ID,
410: ORG_ID = X_ORG_ID,
411: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE),
412: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY),
413: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN)
414: where RULE_OBJECT_ID = X_RULE_OBJECT_ID;
415:
416: if (sql%notfound) then
417: raise no_data_found;
419:
420: update FUN_RULE_OBJECTS_TL set
421: USER_RULE_OBJECT_NAME = X_USER_RULE_OBJECT_NAME,
422: DESCRIPTION = X_DESCRIPTION,
423: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE),
424: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY),
425: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN),
426: SOURCE_LANG = userenv('LANG')
427: where RULE_OBJECT_ID = X_RULE_OBJECT_ID
420: update FUN_RULE_OBJECTS_TL set
421: USER_RULE_OBJECT_NAME = X_USER_RULE_OBJECT_NAME,
422: DESCRIPTION = X_DESCRIPTION,
423: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE),
424: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY),
425: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN),
426: SOURCE_LANG = userenv('LANG')
427: where RULE_OBJECT_ID = X_RULE_OBJECT_ID
428: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
421: USER_RULE_OBJECT_NAME = X_USER_RULE_OBJECT_NAME,
422: DESCRIPTION = X_DESCRIPTION,
423: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE),
424: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY),
425: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN),
426: SOURCE_LANG = userenv('LANG')
427: where RULE_OBJECT_ID = X_RULE_OBJECT_ID
428: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
429:
444: begin
445: update FUN_RULE_OBJ_ATTRIBUTES set
446: DEFAULT_APPLICATION_ID = X_DEFAULT_APPLICATION_ID,
447: DEFAULT_VALUE = X_DEFAULT_VALUE,
448: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE),
449: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY),
450: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN)
451: where RULE_OBJECT_ID = X_RULE_OBJECT_ID;
452:
445: update FUN_RULE_OBJ_ATTRIBUTES set
446: DEFAULT_APPLICATION_ID = X_DEFAULT_APPLICATION_ID,
447: DEFAULT_VALUE = X_DEFAULT_VALUE,
448: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE),
449: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY),
450: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN)
451: where RULE_OBJECT_ID = X_RULE_OBJECT_ID;
452:
453: if (sql%notfound) then
446: DEFAULT_APPLICATION_ID = X_DEFAULT_APPLICATION_ID,
447: DEFAULT_VALUE = X_DEFAULT_VALUE,
448: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE),
449: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY),
450: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN)
451: where RULE_OBJECT_ID = X_RULE_OBJECT_ID;
452:
453: if (sql%notfound) then
454: raise no_data_found;