APPS.JTF_CALENDAR_PUB dependencies on HZ_TIMEZONE_PUB

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

360: UNION ALL
361: -- we are picking up from scheduled date form tasks.
362: select Decode(p_tz_enabled,'Y',
363: Decode(t.timezone_id,NULL, t.scheduled_start_date,
364: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,
365: p_server_tz_id,
366: t.scheduled_start_date),
367: t.scheduled_start_date)
368: ),

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

368: ),
369: t.scheduled_start_date) start_except,
370: Decode(p_tz_enabled,'Y',
371: Decode(t.timezone_id,NULL, t.scheduled_end_date,
372: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,
373: p_server_tz_id,
374: t.scheduled_end_date),
375: t.scheduled_end_date)
376: ),

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

381: where a.resource_id = p_res_id
382: and a.resource_type_code = p_res_type
383: and Decode(p_tz_enabled,'Y',
384: Decode(t.timezone_id,NULL, t.scheduled_end_date,
385: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,
386: p_server_tz_id,
387: t.scheduled_end_date),
388: t.scheduled_end_date)
389: ),

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

389: ),
390: t.scheduled_end_date) >= p_day -- Changed to "schedule_end_date" for bug 2817811 by A.Raina.
391: and Decode(p_tz_enabled,'Y',
392: Decode(t.timezone_id,NULL, t.scheduled_start_date,
393: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,
394: p_server_tz_id,
395: t.scheduled_start_date),
396: t.scheduled_start_date)
397: ),

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

2024: -- column schedule_end_date for index search
2025: select /*+ index_ss(T JTF_TASKS_B_N12) */
2026: trunc(Decode(p_tz_enabled,'Y',
2027: Decode(t.timezone_id,NULL, t.scheduled_start_date,
2028: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,
2029: p_server_tz_id,
2030: t.scheduled_start_date),
2031: t.scheduled_start_date)
2032: ),

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

2033: t.scheduled_start_date)
2034: ) task_start_date,
2035: trunc(Decode(p_tz_enabled,'Y',
2036: Decode(t.timezone_id,NULL, t.scheduled_end_date,
2037: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,
2038: p_server_tz_id,
2039: t.scheduled_end_date),
2040: t.scheduled_end_date)
2041: ),

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

2042: t.scheduled_end_date)
2043: ) task_end_date,
2044: to_char(Decode(p_tz_enabled,'Y',
2045: Decode(t.timezone_id,NULL, t.scheduled_start_date,
2046: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,
2047: p_server_tz_id,
2048: t.scheduled_start_date),
2049: t.scheduled_start_date)
2050: ),

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

2051: t.scheduled_start_date), 'HH24.MI'
2052: ) task_start_time,
2053: to_char(Decode(p_tz_enabled,'Y',
2054: Decode(t.timezone_id,NULL, t.scheduled_end_date,
2055: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,
2056: p_server_tz_id,
2057: t.scheduled_end_date),
2058: t.scheduled_end_date)
2059: ),

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

2066: and a.resource_type_code = p_res_type
2067: and p_req_date between
2068: trunc(Decode(p_tz_enabled,'Y',
2069: Decode(t.timezone_id,NULL, t.scheduled_start_date,
2070: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,
2071: p_server_tz_id,
2072: t.scheduled_start_date),
2073: t.scheduled_start_date)
2074: ),

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

2076: )
2077: and
2078: Decode(p_tz_enabled,'Y',
2079: Decode(t.timezone_id,NULL, t.scheduled_end_date,
2080: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,
2081: p_server_tz_id,
2082: t.scheduled_end_date),
2083: t.scheduled_end_date)
2084: ),

Line 2482: HZ_TIMEZONE_PUB.Get_Time( l_API_VERSION

2478:
2479: -- Initialize API return status to success
2480: x_return_status := FND_API.G_RET_STS_SUCCESS;
2481:
2482: HZ_TIMEZONE_PUB.Get_Time( l_API_VERSION
2483: , l_INIT_MSG_LIST
2484: , P_Resource_TZ_Id
2485: , p_Server_TZ_id
2486: , P_Resource_DtTime