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.BOM_CALENDARS_PKG dependencies on BOM_SHIFT_TIMES

Line 172: (select 1 from BOM_SHIFT_TIMES

168: x_end_time NUMBER) IS
169: dummy NUMBER;
170: BEGIN
171: select 1 into dummy from DUAL where not exists
172: (select 1 from BOM_SHIFT_TIMES
173: where calendar_code = x_calendar_code
174: and shift_num = x_shift_num
175: and from_time = x_start_time
176: and to_time = x_end_time

Line 203: (select 1 from BOM_SHIFT_TIMES

199: dummy NUMBER := 0;
200: BEGIN
201: if x_flag = 1 then
202: select count(*) into dummy from dual where not exists
203: (select 1 from BOM_SHIFT_TIMES
204: where calendar_code = x_calendar_code
205: and shift_num = x_shift_num
206: and from_time < to_time
207: and x_start_time > from_time

Line 210: select 1 from BOM_SHIFT_TIMES

206: and from_time < to_time
207: and x_start_time > from_time
208: and x_start_time < to_time
209: union
210: select 1 from BOM_SHIFT_TIMES
211: where calendar_code = x_calendar_code
212: and shift_num = x_shift_num
213: and from_time > to_time
214: and (x_start_time > from_time or x_start_time < to_time)

Line 218: (select 1 from BOM_SHIFT_TIMES

214: and (x_start_time > from_time or x_start_time < to_time)
215: );
216: elsif x_flag = 2 then
217: select count(*) into dummy from dual where not exists
218: (select 1 from BOM_SHIFT_TIMES
219: where calendar_code = x_calendar_code
220: and shift_num = x_shift_num
221: and from_time < to_time
222: and x_start_time > from_time

Line 226: select 1 from BOM_SHIFT_TIMES

222: and x_start_time > from_time
223: and x_start_time < to_time
224: and x_rowid <> x_rowid
225: union
226: select 1 from BOM_SHIFT_TIMES
227: where calendar_code = x_calendar_code
228: and shift_num = x_shift_num
229: and from_time > to_time
230: and (x_start_time > from_time or x_start_time < to_time)

Line 241: (select 1 from BOM_SHIFT_TIMES

237: end if;
238:
239: if x_flag = 1 then
240: select count(*) into dummy from DUAL where not exists
241: (select 1 from BOM_SHIFT_TIMES
242: where calendar_code = x_calendar_code
243: and shift_num = x_shift_num
244: and from_time < to_time
245: and x_end_time > from_time

Line 248: select 1 from BOM_SHIFT_TIMES

244: and from_time < to_time
245: and x_end_time > from_time
246: and x_end_time < to_time
247: union
248: select 1 from BOM_SHIFT_TIMES
249: where calendar_code = x_calendar_code
250: and shift_num = x_shift_num
251: and from_time > to_time
252: and (x_end_time < to_time or x_end_time > from_time)

Line 256: (select 1 from BOM_SHIFT_TIMES

252: and (x_end_time < to_time or x_end_time > from_time)
253: );
254: elsif x_flag = 2 then
255: select count(*) into dummy from DUAL where not exists
256: (select 1 from BOM_SHIFT_TIMES
257: where calendar_code = x_calendar_code
258: and shift_num = x_shift_num
259: and from_time < to_time
260: and x_end_time > from_time

Line 264: select 1 from BOM_SHIFT_TIMES

260: and x_end_time > from_time
261: and x_end_time < to_time
262: and rowid <> x_rowid
263: union
264: select 1 from BOM_SHIFT_TIMES
265: where calendar_code = x_calendar_code
266: and shift_num = x_shift_num
267: and from_time > to_time
268: and (x_end_time < to_time or x_end_time > from_time)

Line 279: (select 1 from BOM_SHIFT_TIMES

275: end if;
276:
277: if x_flag = 1 then
278: select count(*) into dummy from DUAL where not exists
279: (select 1 from BOM_SHIFT_TIMES
280: where calendar_code = x_calendar_code
281: and shift_num = x_shift_num
282: and from_time < to_time
283: and x_start_time < x_end_time

Line 287: select 1 from BOM_SHIFT_TIMES

283: and x_start_time < x_end_time
284: and x_start_time < from_time
285: and x_end_time > to_time
286: union
287: select 1 from BOM_SHIFT_TIMES
288: where calendar_code = x_calendar_code
289: and shift_num = x_shift_num
290: and from_time < to_time
291: and x_start_time < x_end_time

Line 297: (select 1 from BOM_SHIFT_TIMES

293: and x_end_time < to_time
294: );
295: elsif x_flag = 2 then
296: select count(*) into dummy from DUAL where not exists
297: (select 1 from BOM_SHIFT_TIMES
298: where calendar_code = x_calendar_code
299: and shift_num = x_shift_num
300: and from_time < to_time
301: and x_start_time < x_end_time

Line 306: select 1 from BOM_SHIFT_TIMES

302: and x_start_time < from_time
303: and x_end_time > to_time
304: and rowid <> x_rowid
305: union
306: select 1 from BOM_SHIFT_TIMES
307: where calendar_code = x_calendar_code
308: and shift_num = x_shift_num
309: and from_time < to_time
310: and x_start_time < x_end_time

Line 323: (select 1 from BOM_SHIFT_TIMES

319: end if;
320:
321: if x_flag = 1 then
322: select count(*) into dummy from DUAL where not exists
323: (select 1 from BOM_SHIFT_TIMES
324: where calendar_code = x_calendar_code
325: and shift_num = x_shift_num
326: and from_time > to_time
327: and x_start_time > x_end_time

Line 331: select 1 from BOM_SHIFT_TIMES

327: and x_start_time > x_end_time
328: and x_start_time < from_time
329: and x_end_time > to_time
330: union
331: select 1 from BOM_SHIFT_TIMES
332: where calendar_code = x_calendar_code
333: and shift_num = x_shift_num
334: and from_time > to_time
335: and x_start_time > x_end_time

Line 341: (select 1 from BOM_SHIFT_TIMES

337: and x_end_time < to_time
338: );
339: elsif x_flag = 2 then
340: select count(*) into dummy from DUAL where not exists
341: (select 1 from BOM_SHIFT_TIMES
342: where calendar_code = x_calendar_code
343: and shift_num = x_shift_num
344: and from_time > to_time
345: and x_start_time > x_end_time

Line 350: select 1 from BOM_SHIFT_TIMES

346: and x_start_time < from_time
347: and x_end_time > to_time
348: and rowid <> x_rowid
349: union
350: select 1 from BOM_SHIFT_TIMES
351: where calendar_code = x_calendar_code
352: and shift_num = x_shift_num
353: and from_time > to_time
354: and x_start_time > x_end_time