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_API dependencies on DUAL

Line 143: from dual;

139: end if;
140: if X_PARAMETER_ONE is not null then
141: select to_number(X_PARAMETER_ONE)
142: into X_PARAMETER_ONE_NUMBER
143: from dual;
144: end if;
145: if X_PARAMETER_TWO is not null then
146: select to_number(X_PARAMETER_TWO)
147: into X_PARAMETER_TWO_NUMBER

Line 148: from dual;

144: end if;
145: if X_PARAMETER_TWO is not null then
146: select to_number(X_PARAMETER_TWO)
147: into X_PARAMETER_TWO_NUMBER
148: from dual;
149: end if;
150: end if;
151:
152: if X_ATTRIBUTE_TYPE = ame_util.currencyAttributeType then

Line 167: from dual;

163: end if;
164: if X_PARAMETER_ONE is not null then
165: select to_number(X_PARAMETER_ONE)
166: into X_PARAMETER_ONE_NUMBER
167: from dual;
168: end if;
169: if X_PARAMETER_TWO is not null then
170: select to_number(X_PARAMETER_TWO)
171: into X_PARAMETER_TWO_NUMBER

Line 172: from dual;

168: end if;
169: if X_PARAMETER_TWO is not null then
170: select to_number(X_PARAMETER_TWO)
171: into X_PARAMETER_TWO_NUMBER
172: from dual;
173: end if;
174: end if;
175:
176: if X_ATTRIBUTE_TYPE = ame_util.dateAttributeType then

Line 190: from dual;

186: end if;
187: if X_PARAMETER_ONE is not null then
188: select to_date(X_PARAMETER_ONE,'YYYY:MM:DD:HH24:MI:SS')
189: into X_PARAMETER_ONE_DATE
190: from dual;
191: end if;
192: if X_PARAMETER_TWO is not null then
193: select to_date(X_PARAMETER_TWO,'YYYY:MM:DD:HH24:MI:SS')
194: into X_PARAMETER_TWO_DATE

Line 195: from dual;

191: end if;
192: if X_PARAMETER_TWO is not null then
193: select to_date(X_PARAMETER_TWO,'YYYY:MM:DD:HH24:MI:SS')
194: into X_PARAMETER_TWO_DATE
195: from dual;
196: end if;
197: end if;
198:
199: if X_ATTRIBUTE_TYPE = ame_util.stringAttributeType then

Line 314: from sys.dual

310: X_LAST_UPDATE_LOGIN,
311: X_START_DATE,
312: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,
313: X_OBJECT_VERSION_NUMBER
314: from sys.dual
315: where not exists (select NULL
316: from AME_CONDITIONS
317: where ((CONDITION_ID = X_CONDITION_ID
318: and sysdate < nvl(END_DATE - (1/86400), sysdate + (1/86400)))

Line 356: select AME_CONDITION_KEYS_S.NEXTVAL into X_CONDITION_KEY_ID from dual;

352: end if;
353: close GET_DBID_CURSOR;
354: loop
355: -- derive CONDITION_KEY value
356: select AME_CONDITION_KEYS_S.NEXTVAL into X_CONDITION_KEY_ID from dual;
357: X_NEW_CONDITION_KEY := X_DATABASE_ID ||':'|| X_CONDITION_KEY_ID;
358: select count(*)
359: into X_CONDITION_COUNT
360: from AME_CONDITIONS