eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FUN_RULE_OBJECTS_PKG dependencies on FUN_RULE_UTILITY_PKG

Line 182: NVL(X_CREATED_BY,FUN_RULE_UTILITY_PKG.CREATED_BY),

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)

Line 183: NVL(X_CREATION_DATE,FUN_RULE_UTILITY_PKG.CREATION_DATE),

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;

Line 184: NVL(X_LAST_UPDATE_LOGIN,FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN),

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:

Line 185: NVL(X_LAST_UPDATE_DATE,FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE),

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:

Line 186: NVL(X_LAST_UPDATED_BY,FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY)

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 (

Line 205: NVL(X_CREATED_BY,FUN_RULE_UTILITY_PKG.CREATED_BY),

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),

Line 206: NVL(X_CREATION_DATE,FUN_RULE_UTILITY_PKG.CREATION_DATE),

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,

Line 207: NVL(X_LAST_UPDATE_LOGIN,FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN),

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')

Line 208: NVL(X_LAST_UPDATE_DATE,FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE),

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

Line 209: NVL(X_LAST_UPDATED_BY,FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY),

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')

Line 264: NVL(X_CREATED_BY,FUN_RULE_UTILITY_PKG.CREATED_BY),

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)

Line 265: NVL(X_CREATION_DATE,FUN_RULE_UTILITY_PKG.CREATION_DATE),

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: );

Line 266: NVL(X_LAST_UPDATE_LOGIN,FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN),

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:

Line 267: NVL(X_LAST_UPDATE_DATE,FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE),

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);

Line 268: NVL(X_LAST_UPDATED_BY,FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY)

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;

Line 411: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE),

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:

Line 412: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY),

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

Line 413: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN)

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;

Line 423: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE),

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

Line 424: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY),

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);

Line 425: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN),

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:

Line 448: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE),

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:

Line 449: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY),

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

Line 450: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN)

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;