APPS.JTF_CALENDAR_PUB_24HR dependencies on HZ_TIMEZONE_PUB

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

267: -- Removed /*+ index_ss(T JTF_TASKS_B_N12) */ Hint to address performance issue Bug # 5167257 By MPADHIAR
268:
269: select Decode(p_tz_enabled,'Y',
270: Decode(t.timezone_id,NULL, t.scheduled_start_date,
271: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,
272: p_server_tz_id,
273: t.scheduled_start_date),
274: t.scheduled_start_date)
275: ),

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

275: ),
276: t.scheduled_start_date) start_except,
277: Decode(p_tz_enabled,'Y',
278: Decode(t.timezone_id,NULL, t.scheduled_end_date,
279: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,
280: p_server_tz_id,
281: t.scheduled_end_date),
282: t.scheduled_end_date)
283: ),

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

290: where a.resource_id = p_res_id
291: and a.resource_type_code = p_res_type
292: and Decode(p_tz_enabled,'Y',
293: Decode(t.timezone_id,NULL, t.scheduled_start_date,
294: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,
295: p_server_tz_id,
296: t.scheduled_start_date),
297: t.scheduled_start_date)
298: ),

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

299: t.scheduled_start_date)
300: <= (trunc(p_end)+86399/84400)
301: and Decode(p_tz_enabled,'Y',
302: Decode(t.timezone_id,NULL, t.scheduled_end_date,
303: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,
304: p_server_tz_id,
305: t.scheduled_end_date),
306: t.scheduled_end_date)
307: ),

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

2448: -- column schedule_end_date for index search
2449: select /*+ index_ss(T JTF_TASKS_B_N12) */
2450: trunc(Decode(p_tz_enabled,'Y',
2451: Decode(t.timezone_id,NULL, t.scheduled_start_date,
2452: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,
2453: p_server_tz_id,
2454: t.scheduled_start_date),
2455: t.scheduled_start_date)
2456: ),

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

2457: t.scheduled_start_date)
2458: ) task_start_date,
2459: trunc(Decode(p_tz_enabled,'Y',
2460: Decode(t.timezone_id,NULL, t.scheduled_end_date,
2461: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,
2462: p_server_tz_id,
2463: t.scheduled_end_date),
2464: t.scheduled_end_date)
2465: ),

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

2466: t.scheduled_end_date)
2467: ) task_end_date,
2468: Decode(p_tz_enabled,'Y',
2469: Decode(t.timezone_id,NULL, t.scheduled_start_date,
2470: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,
2471: p_server_tz_id,
2472: t.scheduled_start_date),
2473: t.scheduled_start_date)
2474: ),

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

2474: ),
2475: t.scheduled_start_date) task_start_time,
2476: Decode(p_tz_enabled,'Y',
2477: Decode(t.timezone_id,NULL, t.scheduled_end_date,
2478: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,
2479: p_server_tz_id,
2480: t.scheduled_end_date),
2481: t.scheduled_end_date)
2482: ),

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

2488: and a.resource_type_code = p_res_type
2489: and p_req_date between
2490: trunc(Decode(p_tz_enabled,'Y',
2491: Decode(t.timezone_id,NULL, t.scheduled_start_date,
2492: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,
2493: p_server_tz_id,
2494: t.scheduled_start_date),
2495: t.scheduled_start_date)
2496: ),

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

2498: )
2499: and
2500: Decode(p_tz_enabled,'Y',
2501: Decode(t.timezone_id,NULL, t.scheduled_end_date,
2502: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,
2503: p_server_tz_id,
2504: t.scheduled_end_date),
2505: t.scheduled_end_date)
2506: ),

Line 2974: HZ_TIMEZONE_PUB.Get_Time( l_API_VERSION

2970:
2971: -- Initialize API return status to success
2972: x_return_status := FND_API.G_RET_STS_SUCCESS;
2973:
2974: HZ_TIMEZONE_PUB.Get_Time( l_API_VERSION
2975: , l_INIT_MSG_LIST
2976: , P_Resource_TZ_Id
2977: , p_Server_TZ_id
2978: , P_Resource_DtTime