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.JTF_CALENDAR_PUB_24HR dependencies on HZ_TIMEZONE_PUB

Line 255: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(p_res_Timezone_id,

251: -- p_res_Timezone_id to modify exception from resource timezone to server timezone
252: cursor c_cal_except(p_calendar_id NUMBER, p_start date, p_end date, p_res_id NUMBER, p_res_type VARCHAR2,p_tz_enabled VARCHAR2,p_server_tz_id NUMBER,p_res_Timezone_id NUMBER) is
253: select Decode(p_tz_enabled,'Y',
254: Decode(p_res_Timezone_id,NULL, e.start_date_time,
255: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(p_res_Timezone_id,
256: p_server_tz_id,
257: e.start_date_time),
258: e.start_date_time)
259: ),

Line 263: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(p_res_Timezone_id,

259: ),
260: e.start_date_time) start_except,
261: Decode(p_tz_enabled,'Y',
262: Decode(p_res_Timezone_id,NULL, e.end_date_time,
263: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(p_res_Timezone_id,
264: p_server_tz_id,
265: e.end_date_time),
266: e.end_date_time)
267: ),

Line 271: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(p_res_Timezone_id,

267: ),
268: e.end_date_time) end_except,
269: nvl(Decode(p_tz_enabled,'Y',
270: Decode(p_res_Timezone_id,NULL, a.start_date_active,
271: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(p_res_Timezone_id,
272: p_server_tz_id,
273: a.start_date_active),
274: a.start_date_active)
275: ),

Line 279: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(p_res_Timezone_id,

275: ),
276: a.start_date_active) ,p_start) start_assign,
277: nvl(Decode(p_tz_enabled,'Y',
278: Decode(p_res_Timezone_id,NULL, a.end_date_active,
279: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(p_res_Timezone_id,
280: p_server_tz_id,
281: a.end_date_active),
282: a.end_date_active)
283: ),

Line 291: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(p_res_Timezone_id,

287: where a.calendar_id = p_calendar_id
288: and a.exception_id = e.exception_id
289: and Decode(p_tz_enabled,'Y',
290: Decode(p_res_Timezone_id,NULL, e.start_date_time,
291: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(p_res_Timezone_id,
292: p_server_tz_id,
293: e.start_date_time),
294: e.start_date_time)
295: ),

Line 299: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(p_res_Timezone_id,

295: ),
296: e.start_date_time) <= p_end
297: and Decode(p_tz_enabled,'Y',
298: Decode(p_res_Timezone_id,NULL, e.end_date_time,
299: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(p_res_Timezone_id,
300: p_server_tz_id,
301: e.end_date_time),
302: e.end_date_time)
303: ),

Line 307: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(p_res_Timezone_id,

303: ),
304: e.end_date_time) >= p_start
305: and nvl(Decode(p_tz_enabled,'Y',
306: Decode(p_res_Timezone_id,NULL, a.start_date_active,
307: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(p_res_Timezone_id,
308: p_server_tz_id,
309: a.start_date_active),
310: a.start_date_active)
311: ),

Line 315: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(p_res_Timezone_id,

311: ),
312: a.start_date_active),p_end) <= p_end --starts before end of range
313: and nvl(Decode(p_tz_enabled,'Y',
314: Decode(p_res_Timezone_id,NULL, a.end_date_active,
315: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(p_res_Timezone_id,
316: p_server_tz_id,
317: a.end_date_active),
318: a.end_date_active)
319: ),

Line 328: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,

324: -- Removed /*+ index_ss(T JTF_TASKS_B_N12) */ Hint to address performance issue Bug # 5167257 By MPADHIAR
325:
326: select Decode(p_tz_enabled,'Y',
327: Decode(t.timezone_id,NULL, t.scheduled_start_date,
328: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,
329: p_server_tz_id,
330: t.scheduled_start_date),
331: t.scheduled_start_date)
332: ),

Line 336: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,

332: ),
333: t.scheduled_start_date) start_except,
334: Decode(p_tz_enabled,'Y',
335: Decode(t.timezone_id,NULL, t.scheduled_end_date,
336: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,
337: p_server_tz_id,
338: t.scheduled_end_date),
339: t.scheduled_end_date)
340: ),

Line 351: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,

347: where a.resource_id = p_res_id
348: and a.resource_type_code = p_res_type
349: and Decode(p_tz_enabled,'Y',
350: Decode(t.timezone_id,NULL, t.scheduled_start_date,
351: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,
352: p_server_tz_id,
353: t.scheduled_start_date),
354: t.scheduled_start_date)
355: ),

Line 360: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,

356: t.scheduled_start_date)
357: <= (trunc(p_end)+86399/84400)
358: and Decode(p_tz_enabled,'Y',
359: Decode(t.timezone_id,NULL, t.scheduled_end_date,
360: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,
361: p_server_tz_id,
362: t.scheduled_end_date),
363: t.scheduled_end_date)
364: ),

Line 2522: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,

2518: -- column schedule_end_date for index search
2519: select /*+ index_ss(T JTF_TASKS_B_N12) */
2520: trunc(Decode(p_tz_enabled,'Y',
2521: Decode(t.timezone_id,NULL, t.scheduled_start_date,
2522: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,
2523: p_server_tz_id,
2524: t.scheduled_start_date),
2525: t.scheduled_start_date)
2526: ),

Line 2531: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,

2527: t.scheduled_start_date)
2528: ) task_start_date,
2529: trunc(Decode(p_tz_enabled,'Y',
2530: Decode(t.timezone_id,NULL, t.scheduled_end_date,
2531: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,
2532: p_server_tz_id,
2533: t.scheduled_end_date),
2534: t.scheduled_end_date)
2535: ),

Line 2540: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,

2536: t.scheduled_end_date)
2537: ) task_end_date,
2538: Decode(p_tz_enabled,'Y',
2539: Decode(t.timezone_id,NULL, t.scheduled_start_date,
2540: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,
2541: p_server_tz_id,
2542: t.scheduled_start_date),
2543: t.scheduled_start_date)
2544: ),

Line 2548: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,

2544: ),
2545: t.scheduled_start_date) task_start_time,
2546: Decode(p_tz_enabled,'Y',
2547: Decode(t.timezone_id,NULL, t.scheduled_end_date,
2548: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,
2549: p_server_tz_id,
2550: t.scheduled_end_date),
2551: t.scheduled_end_date)
2552: ),

Line 2562: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,

2558: and a.resource_type_code = p_res_type
2559: and p_req_date between
2560: trunc(Decode(p_tz_enabled,'Y',
2561: Decode(t.timezone_id,NULL, t.scheduled_start_date,
2562: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,
2563: p_server_tz_id,
2564: t.scheduled_start_date),
2565: t.scheduled_start_date)
2566: ),

Line 2572: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,

2568: )
2569: and
2570: Decode(p_tz_enabled,'Y',
2571: Decode(t.timezone_id,NULL, t.scheduled_end_date,
2572: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,
2573: p_server_tz_id,
2574: t.scheduled_end_date),
2575: t.scheduled_end_date)
2576: ),

Line 3044: HZ_TIMEZONE_PUB.Get_Time( l_API_VERSION

3040:
3041: -- Initialize API return status to success
3042: x_return_status := FND_API.G_RET_STS_SUCCESS;
3043:
3044: HZ_TIMEZONE_PUB.Get_Time( l_API_VERSION
3045: , l_INIT_MSG_LIST
3046: , P_Resource_TZ_Id
3047: , p_Server_TZ_id
3048: , P_Resource_DtTime