DBA Data[Home] [Help]

APPS.CAC_VIEW_UTIL_PVT dependencies on CAC_VIEW_UTIL_PVT

Line 1: PACKAGE BODY CAC_VIEW_UTIL_PVT as

1: PACKAGE BODY CAC_VIEW_UTIL_PVT as
2: /* $Header: cacpvutb.pls 120.7 2006/01/09 23:57:17 deeprao noship $ */
3: /*======================================================================+
4: | Copyright (c) 2004 Oracle Corporation Redwood Shores, California, USA|
5: | All rights reserved. |

Line 441: CAC_VIEW_UTIL_PVT.AdjustForTimezone

437: l_repeat_start_date DATE;
438: l_repeat_end_date DATE;
439: BEGIN
440: -- Convert base start date time
441: CAC_VIEW_UTIL_PVT.AdjustForTimezone
442: ( p_source_tz_id => p_source_tz_id
443: , p_dest_tz_id => p_dest_tz_id
444: , p_source_day_time => p_base_start_datetime
445: , x_dest_day_time => l_converted_basetime

Line 458: CAC_VIEW_UTIL_PVT.AdjustForTimezone

454: l_repeat_end_date := TO_DATE(TO_CHAR(p_end_date_active, 'DD-MON-YYYY')||' '||
455: TO_CHAR(p_base_end_datetime, 'HH24:MI:SS'),
456: 'DD-MON-YYYY HH24:MI:SS');
457:
458: CAC_VIEW_UTIL_PVT.AdjustForTimezone
459: ( p_source_tz_id => p_source_tz_id
460: , p_dest_tz_id => p_dest_tz_id
461: , p_source_day_time => l_repeat_start_date
462: , x_dest_day_time => x_start_date_active

Line 465: CAC_VIEW_UTIL_PVT.AdjustForTimezone

461: , p_source_day_time => l_repeat_start_date
462: , x_dest_day_time => x_start_date_active
463: );
464:
465: CAC_VIEW_UTIL_PVT.AdjustForTimezone
466: ( p_source_tz_id => p_source_tz_id
467: , p_dest_tz_id => p_dest_tz_id
468: , p_source_day_time => l_repeat_end_date
469: , x_dest_day_time => x_end_date_active

Line 609: END CAC_VIEW_UTIL_PVT;

605:
606: RETURN l_result_text;
607: END GET_DURATION_DESCRIPTION;
608:
609: END CAC_VIEW_UTIL_PVT;