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_DFF_PKG dependencies on FUN_RULE_UTILITY_PKG

Line 38: g_is_use_instance := FUN_RULE_UTILITY_PKG.IS_USE_INSTANCE(X_RULE_OBJECT_ID);

34: If its a rule object instance, then the Rule Obejct Id will be populated in
35: the DFF table, else the Rule Object id will be a NULL value.
36: */
37:
38: g_is_use_instance := FUN_RULE_UTILITY_PKG.IS_USE_INSTANCE(X_RULE_OBJECT_ID);
39:
40: -- Prepare a cursor to select from the source table:
41:
42: source_cursor := dbms_sql.open_cursor;

Line 193: ' FUN_RULE_UTILITY_PKG.CREATED_BY, '||

189: ' :X_ATTRIBUTE12, '||
190: ' :X_ATTRIBUTE13, '||
191: ' :X_ATTRIBUTE14, '||
192: ' :X_ATTRIBUTE15, '||
193: ' FUN_RULE_UTILITY_PKG.CREATED_BY, '||
194: ' FUN_RULE_UTILITY_PKG.CREATION_DATE, '||
195: ' FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN, '||
196: ' FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE, '||
197: ' FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY, '||

Line 194: ' FUN_RULE_UTILITY_PKG.CREATION_DATE, '||

190: ' :X_ATTRIBUTE13, '||
191: ' :X_ATTRIBUTE14, '||
192: ' :X_ATTRIBUTE15, '||
193: ' FUN_RULE_UTILITY_PKG.CREATED_BY, '||
194: ' FUN_RULE_UTILITY_PKG.CREATION_DATE, '||
195: ' FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN, '||
196: ' FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE, '||
197: ' FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY, '||
198: ' :X_RULE_OBJECT_ID )',

Line 195: ' FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN, '||

191: ' :X_ATTRIBUTE14, '||
192: ' :X_ATTRIBUTE15, '||
193: ' FUN_RULE_UTILITY_PKG.CREATED_BY, '||
194: ' FUN_RULE_UTILITY_PKG.CREATION_DATE, '||
195: ' FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN, '||
196: ' FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE, '||
197: ' FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY, '||
198: ' :X_RULE_OBJECT_ID )',
199: DBMS_SQL.native);

Line 196: ' FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE, '||

192: ' :X_ATTRIBUTE15, '||
193: ' FUN_RULE_UTILITY_PKG.CREATED_BY, '||
194: ' FUN_RULE_UTILITY_PKG.CREATION_DATE, '||
195: ' FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN, '||
196: ' FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE, '||
197: ' FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY, '||
198: ' :X_RULE_OBJECT_ID )',
199: DBMS_SQL.native);
200: else

Line 197: ' FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY, '||

193: ' FUN_RULE_UTILITY_PKG.CREATED_BY, '||
194: ' FUN_RULE_UTILITY_PKG.CREATION_DATE, '||
195: ' FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN, '||
196: ' FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE, '||
197: ' FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY, '||
198: ' :X_RULE_OBJECT_ID )',
199: DBMS_SQL.native);
200: else
201: DBMS_SQL.PARSE(destination_cursor,

Line 244: ' FUN_RULE_UTILITY_PKG.CREATED_BY, '||

240: ' :X_ATTRIBUTE12, '||
241: ' :X_ATTRIBUTE13, '||
242: ' :X_ATTRIBUTE14, '||
243: ' :X_ATTRIBUTE15, '||
244: ' FUN_RULE_UTILITY_PKG.CREATED_BY, '||
245: ' FUN_RULE_UTILITY_PKG.CREATION_DATE, '||
246: ' FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN, '||
247: ' FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE, '||
248: ' FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY )',

Line 245: ' FUN_RULE_UTILITY_PKG.CREATION_DATE, '||

241: ' :X_ATTRIBUTE13, '||
242: ' :X_ATTRIBUTE14, '||
243: ' :X_ATTRIBUTE15, '||
244: ' FUN_RULE_UTILITY_PKG.CREATED_BY, '||
245: ' FUN_RULE_UTILITY_PKG.CREATION_DATE, '||
246: ' FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN, '||
247: ' FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE, '||
248: ' FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY )',
249: DBMS_SQL.native);

Line 246: ' FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN, '||

242: ' :X_ATTRIBUTE14, '||
243: ' :X_ATTRIBUTE15, '||
244: ' FUN_RULE_UTILITY_PKG.CREATED_BY, '||
245: ' FUN_RULE_UTILITY_PKG.CREATION_DATE, '||
246: ' FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN, '||
247: ' FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE, '||
248: ' FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY )',
249: DBMS_SQL.native);
250: end if;

Line 247: ' FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE, '||

243: ' :X_ATTRIBUTE15, '||
244: ' FUN_RULE_UTILITY_PKG.CREATED_BY, '||
245: ' FUN_RULE_UTILITY_PKG.CREATION_DATE, '||
246: ' FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN, '||
247: ' FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE, '||
248: ' FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY )',
249: DBMS_SQL.native);
250: end if;
251:

Line 248: ' FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY )',

244: ' FUN_RULE_UTILITY_PKG.CREATED_BY, '||
245: ' FUN_RULE_UTILITY_PKG.CREATION_DATE, '||
246: ' FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN, '||
247: ' FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE, '||
248: ' FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY )',
249: DBMS_SQL.native);
250: end if;
251:
252: DBMS_SQL.BIND_VARIABLE(destination_cursor, 'X_RULE_DETAIL_ID', X_RULE_DETAIL_ID);

Line 340: ' CREATED_BY = FUN_RULE_UTILITY_PKG.CREATED_BY, '||

336: ' ATTRIBUTE12 = :X_ATTRIBUTE12, '||
337: ' ATTRIBUTE13 = :X_ATTRIBUTE13, '||
338: ' ATTRIBUTE14 = :X_ATTRIBUTE14, '||
339: ' ATTRIBUTE15 = :X_ATTRIBUTE15, '||
340: ' CREATED_BY = FUN_RULE_UTILITY_PKG.CREATED_BY, '||
341: ' CREATION_DATE = FUN_RULE_UTILITY_PKG.CREATION_DATE, '||
342: ' LAST_UPDATE_LOGIN = FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN, '||
343: ' LAST_UPDATE_DATE = FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE, '||
344: ' LAST_UPDATED_BY = FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY '||

Line 341: ' CREATION_DATE = FUN_RULE_UTILITY_PKG.CREATION_DATE, '||

337: ' ATTRIBUTE13 = :X_ATTRIBUTE13, '||
338: ' ATTRIBUTE14 = :X_ATTRIBUTE14, '||
339: ' ATTRIBUTE15 = :X_ATTRIBUTE15, '||
340: ' CREATED_BY = FUN_RULE_UTILITY_PKG.CREATED_BY, '||
341: ' CREATION_DATE = FUN_RULE_UTILITY_PKG.CREATION_DATE, '||
342: ' LAST_UPDATE_LOGIN = FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN, '||
343: ' LAST_UPDATE_DATE = FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE, '||
344: ' LAST_UPDATED_BY = FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY '||
345: ' WHERE RULE_DETAIL_ID = :X_RULE_DETAIL_ID AND RULE_OBJECT_ID = :X_RULE_OBJECT_ID',

Line 342: ' LAST_UPDATE_LOGIN = FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN, '||

338: ' ATTRIBUTE14 = :X_ATTRIBUTE14, '||
339: ' ATTRIBUTE15 = :X_ATTRIBUTE15, '||
340: ' CREATED_BY = FUN_RULE_UTILITY_PKG.CREATED_BY, '||
341: ' CREATION_DATE = FUN_RULE_UTILITY_PKG.CREATION_DATE, '||
342: ' LAST_UPDATE_LOGIN = FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN, '||
343: ' LAST_UPDATE_DATE = FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE, '||
344: ' LAST_UPDATED_BY = FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY '||
345: ' WHERE RULE_DETAIL_ID = :X_RULE_DETAIL_ID AND RULE_OBJECT_ID = :X_RULE_OBJECT_ID',
346: DBMS_SQL.native);

Line 343: ' LAST_UPDATE_DATE = FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE, '||

339: ' ATTRIBUTE15 = :X_ATTRIBUTE15, '||
340: ' CREATED_BY = FUN_RULE_UTILITY_PKG.CREATED_BY, '||
341: ' CREATION_DATE = FUN_RULE_UTILITY_PKG.CREATION_DATE, '||
342: ' LAST_UPDATE_LOGIN = FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN, '||
343: ' LAST_UPDATE_DATE = FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE, '||
344: ' LAST_UPDATED_BY = FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY '||
345: ' WHERE RULE_DETAIL_ID = :X_RULE_DETAIL_ID AND RULE_OBJECT_ID = :X_RULE_OBJECT_ID',
346: DBMS_SQL.native);
347: else

Line 344: ' LAST_UPDATED_BY = FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY '||

340: ' CREATED_BY = FUN_RULE_UTILITY_PKG.CREATED_BY, '||
341: ' CREATION_DATE = FUN_RULE_UTILITY_PKG.CREATION_DATE, '||
342: ' LAST_UPDATE_LOGIN = FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN, '||
343: ' LAST_UPDATE_DATE = FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE, '||
344: ' LAST_UPDATED_BY = FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY '||
345: ' WHERE RULE_DETAIL_ID = :X_RULE_DETAIL_ID AND RULE_OBJECT_ID = :X_RULE_OBJECT_ID',
346: DBMS_SQL.native);
347: else
348: DBMS_SQL.PARSE(destination_cursor,

Line 366: ' CREATED_BY = FUN_RULE_UTILITY_PKG.CREATED_BY, '||

362: ' ATTRIBUTE12 = :X_ATTRIBUTE12, '||
363: ' ATTRIBUTE13 = :X_ATTRIBUTE13, '||
364: ' ATTRIBUTE14 = :X_ATTRIBUTE14, '||
365: ' ATTRIBUTE15 = :X_ATTRIBUTE15, '||
366: ' CREATED_BY = FUN_RULE_UTILITY_PKG.CREATED_BY, '||
367: ' CREATION_DATE = FUN_RULE_UTILITY_PKG.CREATION_DATE, '||
368: ' LAST_UPDATE_LOGIN = FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN, '||
369: ' LAST_UPDATE_DATE = FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE, '||
370: ' LAST_UPDATED_BY = FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY '||

Line 367: ' CREATION_DATE = FUN_RULE_UTILITY_PKG.CREATION_DATE, '||

363: ' ATTRIBUTE13 = :X_ATTRIBUTE13, '||
364: ' ATTRIBUTE14 = :X_ATTRIBUTE14, '||
365: ' ATTRIBUTE15 = :X_ATTRIBUTE15, '||
366: ' CREATED_BY = FUN_RULE_UTILITY_PKG.CREATED_BY, '||
367: ' CREATION_DATE = FUN_RULE_UTILITY_PKG.CREATION_DATE, '||
368: ' LAST_UPDATE_LOGIN = FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN, '||
369: ' LAST_UPDATE_DATE = FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE, '||
370: ' LAST_UPDATED_BY = FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY '||
371: ' WHERE RULE_DETAIL_ID = :X_RULE_DETAIL_ID',

Line 368: ' LAST_UPDATE_LOGIN = FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN, '||

364: ' ATTRIBUTE14 = :X_ATTRIBUTE14, '||
365: ' ATTRIBUTE15 = :X_ATTRIBUTE15, '||
366: ' CREATED_BY = FUN_RULE_UTILITY_PKG.CREATED_BY, '||
367: ' CREATION_DATE = FUN_RULE_UTILITY_PKG.CREATION_DATE, '||
368: ' LAST_UPDATE_LOGIN = FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN, '||
369: ' LAST_UPDATE_DATE = FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE, '||
370: ' LAST_UPDATED_BY = FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY '||
371: ' WHERE RULE_DETAIL_ID = :X_RULE_DETAIL_ID',
372: DBMS_SQL.native);

Line 369: ' LAST_UPDATE_DATE = FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE, '||

365: ' ATTRIBUTE15 = :X_ATTRIBUTE15, '||
366: ' CREATED_BY = FUN_RULE_UTILITY_PKG.CREATED_BY, '||
367: ' CREATION_DATE = FUN_RULE_UTILITY_PKG.CREATION_DATE, '||
368: ' LAST_UPDATE_LOGIN = FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN, '||
369: ' LAST_UPDATE_DATE = FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE, '||
370: ' LAST_UPDATED_BY = FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY '||
371: ' WHERE RULE_DETAIL_ID = :X_RULE_DETAIL_ID',
372: DBMS_SQL.native);
373: end if;

Line 370: ' LAST_UPDATED_BY = FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY '||

366: ' CREATED_BY = FUN_RULE_UTILITY_PKG.CREATED_BY, '||
367: ' CREATION_DATE = FUN_RULE_UTILITY_PKG.CREATION_DATE, '||
368: ' LAST_UPDATE_LOGIN = FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN, '||
369: ' LAST_UPDATE_DATE = FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE, '||
370: ' LAST_UPDATED_BY = FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY '||
371: ' WHERE RULE_DETAIL_ID = :X_RULE_DETAIL_ID',
372: DBMS_SQL.native);
373: end if;
374: