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 204: from dual;

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

Line 209: from dual;

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

Line 219: from dual;

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

Line 230: from dual;

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

Line 242: from dual;

238: 'DAYS', GREATEST(p_repeat_interval,1/1440),
239: 'MONTHS', ADD_MONTHS(req_date,p_repeat_interval)-req_date,
240: 1)
241: into req_date
242: from dual;
243: end loop;
244:
245:
246: p_start_date := req_date;

Line 269: dual_no_rows exception;

265:
266: relseqno number;
267: relclassname varchar2(20);
268: relclass_insert_error exception;
269: dual_no_rows exception;
270: dual_too_many_rows exception;
271:
272: begin
273:

Line 270: dual_too_many_rows exception;

266: relseqno number;
267: relclassname varchar2(20);
268: relclass_insert_error exception;
269: dual_no_rows exception;
270: dual_too_many_rows exception;
271:
272: begin
273:
274: begin

Line 277: From Sys.Dual;

273:
274: begin
275: Select Fnd_Conc_Release_Classes_S.nextval
276: Into relseqno
277: From Sys.Dual;
278:
279: exception
280: when no_data_found then
281: raise dual_no_rows;

Line 281: raise dual_no_rows;

277: From Sys.Dual;
278:
279: exception
280: when no_data_found then
281: raise dual_no_rows;
282: when too_many_rows then
283: raise dual_too_many_rows;
284: when others then
285: raise;

Line 283: raise dual_too_many_rows;

279: exception
280: when no_data_found then
281: raise dual_no_rows;
282: when too_many_rows then
283: raise dual_too_many_rows;
284: when others then
285: raise;
286: end;
287:

Line 325: when dual_no_rows then

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

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

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

Line 328: when dual_too_many_rows then

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

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

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