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

Line 348: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(p_res_Timezone_id,

344: -- modified the query accordingly. Done by SBARAT on 23/06/2005 for Bug# 4443443
345: cursor c_cal_except(p_calendar_id NUMBER, p_day date, p_res_id NUMBER, p_res_type VARCHAR2,p_tz_enabled VARCHAR2,p_server_tz_id NUMBER,p_res_Timezone_id NUMBER) is
346: select Decode(p_tz_enabled,'Y',
347: Decode(p_res_Timezone_id,NULL, e.start_date_time,
348: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(p_res_Timezone_id,
349: p_server_tz_id,
350: e.start_date_time),
351: e.start_date_time)
352: ),

Line 356: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(p_res_Timezone_id,

352: ),
353: e.start_date_time) start_except,
354: Decode(p_tz_enabled,'Y',
355: Decode(p_res_Timezone_id,NULL, e.end_date_time,
356: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(p_res_Timezone_id,
357: p_server_tz_id,
358: e.end_date_time),
359: e.end_date_time)
360: ),

Line 369: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(p_res_Timezone_id,

365: and a.exception_id = e.exception_id
366: -- validate exception assignment
367: and ( p_day >= trunc(Decode(p_tz_enabled,'Y',
368: Decode(p_res_Timezone_id,NULL, a.start_date_active,
369: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(p_res_Timezone_id,
370: p_server_tz_id,
371: a.start_date_active),
372: a.start_date_active)
373: ),

Line 378: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(p_res_Timezone_id,

374: a.start_date_active))
375: or a.start_date_active is null)
376: and ( p_day <= trunc(Decode(p_tz_enabled,'Y',
377: Decode(p_res_Timezone_id,NULL, a.end_date_active,
378: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(p_res_Timezone_id,
379: p_server_tz_id,
380: a.end_date_active),
381: a.end_date_active)
382: ),

Line 388: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(p_res_Timezone_id,

384: or a.end_date_active is null)
385: -- validate exception
386: and p_day between trunc(Decode(p_tz_enabled,'Y',
387: Decode(p_res_Timezone_id,NULL, e.start_date_time,
388: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(p_res_Timezone_id,
389: p_server_tz_id,
390: e.start_date_time),
391: e.start_date_time)
392: ),

Line 396: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(p_res_Timezone_id,

392: ),
393: e.start_date_time))
394: and trunc(Decode(p_tz_enabled,'Y',
395: Decode(p_res_Timezone_id,NULL, e.end_date_time,
396: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(p_res_Timezone_id,
397: p_server_tz_id,
398: e.end_date_time),
399: e.end_date_time)
400: ),

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

402: UNION ALL
403: -- we are picking up from scheduled date form tasks.
404: select Decode(p_tz_enabled,'Y',
405: Decode(t.timezone_id,NULL, t.scheduled_start_date,
406: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,
407: p_server_tz_id,
408: t.scheduled_start_date),
409: t.scheduled_start_date)
410: ),

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

410: ),
411: t.scheduled_start_date) start_except,
412: Decode(p_tz_enabled,'Y',
413: Decode(t.timezone_id,NULL, t.scheduled_end_date,
414: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,
415: p_server_tz_id,
416: t.scheduled_end_date),
417: t.scheduled_end_date)
418: ),

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

423: where a.resource_id = p_res_id
424: and a.resource_type_code = p_res_type
425: and Decode(p_tz_enabled,'Y',
426: Decode(t.timezone_id,NULL, t.scheduled_end_date,
427: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,
428: p_server_tz_id,
429: t.scheduled_end_date),
430: t.scheduled_end_date)
431: ),

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

431: ),
432: t.scheduled_end_date) >= p_day -- Changed to "schedule_end_date" for bug 2817811 by A.Raina.
433: and Decode(p_tz_enabled,'Y',
434: Decode(t.timezone_id,NULL, t.scheduled_start_date,
435: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,
436: p_server_tz_id,
437: t.scheduled_start_date),
438: t.scheduled_start_date)
439: ),

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

2074: -- column schedule_end_date for index search
2075: select /*+ index_ss(T JTF_TASKS_B_N12) */
2076: trunc(Decode(p_tz_enabled,'Y',
2077: Decode(t.timezone_id,NULL, t.scheduled_start_date,
2078: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,
2079: p_server_tz_id,
2080: t.scheduled_start_date),
2081: t.scheduled_start_date)
2082: ),

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

2083: t.scheduled_start_date)
2084: ) task_start_date,
2085: trunc(Decode(p_tz_enabled,'Y',
2086: Decode(t.timezone_id,NULL, t.scheduled_end_date,
2087: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,
2088: p_server_tz_id,
2089: t.scheduled_end_date),
2090: t.scheduled_end_date)
2091: ),

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

2092: t.scheduled_end_date)
2093: ) task_end_date,
2094: to_char(Decode(p_tz_enabled,'Y',
2095: Decode(t.timezone_id,NULL, t.scheduled_start_date,
2096: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,
2097: p_server_tz_id,
2098: t.scheduled_start_date),
2099: t.scheduled_start_date)
2100: ),

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

2101: t.scheduled_start_date), 'HH24.MI'
2102: ) task_start_time,
2103: to_char(Decode(p_tz_enabled,'Y',
2104: Decode(t.timezone_id,NULL, t.scheduled_end_date,
2105: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,
2106: p_server_tz_id,
2107: t.scheduled_end_date),
2108: t.scheduled_end_date)
2109: ),

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

2116: and a.resource_type_code = p_res_type
2117: and p_req_date between
2118: trunc(Decode(p_tz_enabled,'Y',
2119: Decode(t.timezone_id,NULL, t.scheduled_start_date,
2120: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,
2121: p_server_tz_id,
2122: t.scheduled_start_date),
2123: t.scheduled_start_date)
2124: ),

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

2126: )
2127: and
2128: Decode(p_tz_enabled,'Y',
2129: Decode(t.timezone_id,NULL, t.scheduled_end_date,
2130: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,
2131: p_server_tz_id,
2132: t.scheduled_end_date),
2133: t.scheduled_end_date)
2134: ),

Line 2532: HZ_TIMEZONE_PUB.Get_Time( l_API_VERSION

2528:
2529: -- Initialize API return status to success
2530: x_return_status := FND_API.G_RET_STS_SUCCESS;
2531:
2532: HZ_TIMEZONE_PUB.Get_Time( l_API_VERSION
2533: , l_INIT_MSG_LIST
2534: , P_Resource_TZ_Id
2535: , p_Server_TZ_id
2536: , P_Resource_DtTime