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.AME_CONDITIONS_API2 dependencies on DUAL

Line 293: from dual;

289: end if;
290: if X_PARAMETER_ONE is not null then
291: select to_number(X_PARAMETER_ONE)
292: into X_PARAMETER_ONE_NUMBER
293: from dual;
294: end if;
295: if X_PARAMETER_TWO is not null then
296: select to_number(X_PARAMETER_TWO)
297: into X_PARAMETER_TWO_NUMBER

Line 298: from dual;

294: end if;
295: if X_PARAMETER_TWO is not null then
296: select to_number(X_PARAMETER_TWO)
297: into X_PARAMETER_TWO_NUMBER
298: from dual;
299: end if;
300: end if;
301:
302: if X_ATTRIBUTE_TYPE = ame_util.currencyAttributeType then

Line 317: from dual;

313: end if;
314: if X_PARAMETER_ONE is not null then
315: select to_number(X_PARAMETER_ONE)
316: into X_PARAMETER_ONE_NUMBER
317: from dual;
318: end if;
319: if X_PARAMETER_TWO is not null then
320: select to_number(X_PARAMETER_TWO)
321: into X_PARAMETER_TWO_NUMBER

Line 322: from dual;

318: end if;
319: if X_PARAMETER_TWO is not null then
320: select to_number(X_PARAMETER_TWO)
321: into X_PARAMETER_TWO_NUMBER
322: from dual;
323: end if;
324: end if;
325:
326: if X_ATTRIBUTE_TYPE = ame_util.dateAttributeType then

Line 340: from dual;

336: end if;
337: if X_PARAMETER_ONE is not null then
338: select to_date(X_PARAMETER_ONE,'YYYY:MM:DD:HH24:MI:SS')
339: into X_PARAMETER_ONE_DATE
340: from dual;
341: end if;
342: if X_PARAMETER_TWO is not null then
343: select to_date(X_PARAMETER_TWO,'YYYY:MM:DD:HH24:MI:SS')
344: into X_PARAMETER_TWO_DATE

Line 345: from dual;

341: end if;
342: if X_PARAMETER_TWO is not null then
343: select to_date(X_PARAMETER_TWO,'YYYY:MM:DD:HH24:MI:SS')
344: into X_PARAMETER_TWO_DATE
345: from dual;
346: end if;
347: end if;
348:
349: if X_ATTRIBUTE_TYPE = ame_util.stringAttributeType then

Line 460: from sys.dual

456: X_LAST_UPDATE_LOGIN,
457: X_START_DATE,
458: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,
459: X_OBJECT_VERSION_NUMBER
460: from sys.dual
461: where not exists (select NULL
462: from AME_CONDITIONS
463: where CONDITION_KEY = X_CONDITION_KEY);
464: end if;

Line 528: from sys.dual

524: X_LAST_UPDATE_LOGIN,
525: X_START_DATE,
526: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,
527: X_OBJECT_VERSION_NUMBER
528: from sys.dual
529: where not exists (select NULL
530: from AME_CONDITIONS
531: where CONDITION_ID = X_CONDITION_ID);
532: