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

Line 200: from dual;

196: -- interval unit
197: select decode(substr(curr_info, c1+1, 1),
198: 'M', 'MONTHS', 'D', 'DAYS', 'H', 'HOURS', 'N', 'MINUTES')
199: into p_repeat_interval_unit
200: from dual;
201:
202: -- interval type
203: select decode(substr(curr_info, (c2+1), 1), 'C', 'END', 'START')
204: into p_repeat_interval_type

Line 205: from dual;

201:
202: -- interval type
203: select decode(substr(curr_info, (c2+1), 1), 'C', 'END', 'START')
204: into p_repeat_interval_type
205: from dual;
206:
207:
208: -- now figure out the correct requested start date
209: select floor((sysdate - req_date) / DECODE(p_repeat_interval_unit,

Line 215: from dual;

211: 'HOURS', GREATEST(p_repeat_interval,1/60) / 24,
212: 'DAYS', GREATEST(p_repeat_interval,1/1440),
213: 'MONTHS', GREATEST(p_repeat_interval,1) * 31,1))
214: into tmp_interval
215: from dual;
216:
217: if (tmp_interval > 0) then
218: select req_date +
219: DECODE(p_repeat_interval_unit,

Line 226: from dual;

222: 'DAYS', tmp_interval * GREATEST(p_repeat_interval,1/1440),
223: 'MONTHS', ADD_MONTHS(req_date, tmp_interval * p_repeat_interval)-req_date,
224: 1)
225: into req_date
226: from dual;
227: end if;
228:
229: while (req_date < sysdate) loop
230: select req_date +

Line 238: from dual;

234: 'DAYS', GREATEST(p_repeat_interval,1/1440),
235: 'MONTHS', ADD_MONTHS(req_date,p_repeat_interval)-req_date,
236: 1)
237: into req_date
238: from dual;
239: end loop;
240:
241:
242: p_start_date := req_date;

Line 265: dual_no_rows exception;

261:
262: relseqno number;
263: relclassname varchar2(20);
264: relclass_insert_error exception;
265: dual_no_rows exception;
266: dual_too_many_rows exception;
267:
268: begin
269:

Line 266: dual_too_many_rows exception;

262: relseqno number;
263: relclassname varchar2(20);
264: relclass_insert_error exception;
265: dual_no_rows exception;
266: dual_too_many_rows exception;
267:
268: begin
269:
270: begin

Line 273: From Sys.Dual;

269:
270: begin
271: Select Fnd_Conc_Release_Classes_S.nextval
272: Into relseqno
273: From Sys.Dual;
274:
275: exception
276: when no_data_found then
277: raise dual_no_rows;

Line 277: raise dual_no_rows;

273: From Sys.Dual;
274:
275: exception
276: when no_data_found then
277: raise dual_no_rows;
278: when too_many_rows then
279: raise dual_too_many_rows;
280: when others then
281: raise;

Line 279: raise dual_too_many_rows;

275: exception
276: when no_data_found then
277: raise dual_no_rows;
278: when too_many_rows then
279: raise dual_too_many_rows;
280: when others then
281: raise;
282: end;
283:

Line 321: when dual_no_rows then

317: fnd_message.set_name ('FND', 'CONC-RelClass insert failed');
318: fnd_message.set_token ('APPLICATION', 0, FALSE);
319: fnd_message.set_token ('CLASS', relseqno, FALSE);
320: return (false);
321: when dual_no_rows then
322: fnd_message.set_name ('FND', 'No Rows in Dual');
323: return (false);
324: when dual_too_many_rows then
325: fnd_message.set_name ('FND', 'Too many rows in Dual');

Line 322: fnd_message.set_name ('FND', 'No Rows in Dual');

318: fnd_message.set_token ('APPLICATION', 0, FALSE);
319: fnd_message.set_token ('CLASS', relseqno, FALSE);
320: return (false);
321: when dual_no_rows then
322: fnd_message.set_name ('FND', 'No Rows in Dual');
323: return (false);
324: when dual_too_many_rows then
325: fnd_message.set_name ('FND', 'Too many rows in Dual');
326: return (false);

Line 324: when dual_too_many_rows then

320: return (false);
321: when dual_no_rows then
322: fnd_message.set_name ('FND', 'No Rows in Dual');
323: return (false);
324: when dual_too_many_rows then
325: fnd_message.set_name ('FND', 'Too many rows in Dual');
326: return (false);
327: when others then
328: fnd_message.set_name ('FND', 'SQL-Generic error');

Line 325: fnd_message.set_name ('FND', 'Too many rows in Dual');

321: when dual_no_rows then
322: fnd_message.set_name ('FND', 'No Rows in Dual');
323: return (false);
324: when dual_too_many_rows then
325: fnd_message.set_name ('FND', 'Too many rows in Dual');
326: return (false);
327: when others then
328: fnd_message.set_name ('FND', 'SQL-Generic error');
329: fnd_message.set_token ('ERRNO', sqlcode, FALSE);