DBA Data[Home] [Help]

APPS.CAC_VIEW_PVT dependencies on CAC_VIEW_UTIL_PVT

Line 405: CAC_VIEW_UTIL_PVT.AdjustForTimezone

401: l_EndDate := r_Bookings.EndDate;
402:
403: if p_TimezoneId is not null
404: then
405: CAC_VIEW_UTIL_PVT.AdjustForTimezone
406: ( p_source_tz_id => to_number(r_Bookings.TimezoneID)
407: , p_dest_tz_id => p_TimezoneId
408: , p_source_day_time => l_StartDate
409: , x_dest_day_time => l_NewStartDate

Line 412: CAC_VIEW_UTIL_PVT.AdjustForTimezone

408: , p_source_day_time => l_StartDate
409: , x_dest_day_time => l_NewStartDate
410: );
411:
412: CAC_VIEW_UTIL_PVT.AdjustForTimezone
413: ( p_source_tz_id => to_number(r_Bookings.TimezoneID)
414: , p_dest_tz_id => p_TimezoneId
415: , p_source_day_time => l_EndDate
416: , x_dest_day_time => l_NewEndDate

Line 421: CAC_VIEW_UTIL_PVT.AdjustForTimezone

417: );
418:
419: else
420:
421: CAC_VIEW_UTIL_PVT.AdjustForTimezone
422: ( p_source_tz_id => r_Bookings.TimezoneID
423: , p_dest_tz_id => to_number(NVL(FND_PROFILE.Value('CLIENT_TIMEZONE_ID'),'4'))
424: , p_source_day_time => l_StartDate
425: , x_dest_day_time => l_NewStartDate

Line 428: CAC_VIEW_UTIL_PVT.AdjustForTimezone

424: , p_source_day_time => l_StartDate
425: , x_dest_day_time => l_NewStartDate
426: );
427:
428: CAC_VIEW_UTIL_PVT.AdjustForTimezone
429: ( p_source_tz_id => r_Bookings.TimezoneID
430: , p_dest_tz_id => to_number(NVL(FND_PROFILE.Value('CLIENT_TIMEZONE_ID'),'4'))
431: , p_source_day_time => l_EndDate
432: , x_dest_day_time => l_NewEndDate

Line 815: CAC_VIEW_UTIL_PVT.AdjustForTimezone

811: l_EndDate := r_PersonalApt.EndDate;
812:
813: if p_TimezoneId is not null
814: then
815: CAC_VIEW_UTIL_PVT.AdjustForTimezone
816: ( p_source_tz_id => to_number(r_PersonalApt.TimezoneID)
817: , p_dest_tz_id => p_TimezoneId
818: , p_source_day_time => l_StartDate
819: , x_dest_day_time => l_NewStartDate

Line 822: CAC_VIEW_UTIL_PVT.AdjustForTimezone

818: , p_source_day_time => l_StartDate
819: , x_dest_day_time => l_NewStartDate
820: );
821:
822: CAC_VIEW_UTIL_PVT.AdjustForTimezone
823: ( p_source_tz_id => to_number(r_PersonalApt.TimezoneID)
824: , p_dest_tz_id => p_TimezoneId
825: , p_source_day_time => l_EndDate
826: , x_dest_day_time => l_NewEndDate

Line 830: CAC_VIEW_UTIL_PVT.AdjustForTimezone

826: , x_dest_day_time => l_NewEndDate
827: );
828:
829: else
830: CAC_VIEW_UTIL_PVT.AdjustForTimezone
831: ( p_source_tz_id => r_PersonalApt.TimezoneID
832: , p_dest_tz_id => to_number(NVL(FND_PROFILE.Value('CLIENT_TIMEZONE_ID'),'4'))
833: , p_source_day_time => l_StartDate
834: , x_dest_day_time => l_NewStartDate

Line 837: CAC_VIEW_UTIL_PVT.AdjustForTimezone

833: , p_source_day_time => l_StartDate
834: , x_dest_day_time => l_NewStartDate
835: );
836:
837: CAC_VIEW_UTIL_PVT.AdjustForTimezone
838: ( p_source_tz_id => r_PersonalApt.TimezoneID
839: , p_dest_tz_id => to_number(NVL(FND_PROFILE.Value('CLIENT_TIMEZONE_ID'),'4'))
840: , p_source_day_time => l_EndDate
841: , x_dest_day_time => l_NewEndDate

Line 996: CAC_VIEW_UTIL_PVT.AdjustForTimezone

992: l_EndDate := r_PersonalTask.CALENDAR_END_DATE;
993:
994: if p_TimezoneId is not null
995: then
996: CAC_VIEW_UTIL_PVT.AdjustForTimezone
997: ( p_source_tz_id => to_number(r_PersonalTask.TIMEZONE_ID)
998: , p_dest_tz_id => p_TimezoneId
999: , p_source_day_time => l_StartDate
1000: , x_dest_day_time => l_NewStartDate

Line 1003: CAC_VIEW_UTIL_PVT.AdjustForTimezone

999: , p_source_day_time => l_StartDate
1000: , x_dest_day_time => l_NewStartDate
1001: );
1002:
1003: CAC_VIEW_UTIL_PVT.AdjustForTimezone
1004: ( p_source_tz_id => to_number(r_PersonalTask.TIMEZONE_ID)
1005: , p_dest_tz_id => p_TimezoneId
1006: , p_source_day_time => l_EndDate
1007: , x_dest_day_time => l_NewEndDate

Line 1011: CAC_VIEW_UTIL_PVT.AdjustForTimezone

1007: , x_dest_day_time => l_NewEndDate
1008: );
1009:
1010: else
1011: CAC_VIEW_UTIL_PVT.AdjustForTimezone
1012: ( p_source_tz_id => r_PersonalTask.TIMEZONE_ID
1013: , p_dest_tz_id => to_number(NVL(FND_PROFILE.Value('CLIENT_TIMEZONE_ID'),'4'))
1014: , p_source_day_time => l_StartDate
1015: , x_dest_day_time => l_NewStartDate

Line 1018: CAC_VIEW_UTIL_PVT.AdjustForTimezone

1014: , p_source_day_time => l_StartDate
1015: , x_dest_day_time => l_NewStartDate
1016: );
1017:
1018: CAC_VIEW_UTIL_PVT.AdjustForTimezone
1019: ( p_source_tz_id => r_PersonalTask.TIMEZONE_ID
1020: , p_dest_tz_id => to_number(NVL(FND_PROFILE.Value('CLIENT_TIMEZONE_ID'),'4'))
1021: , p_source_day_time => l_EndDate
1022: , x_dest_day_time => l_NewEndDate

Line 1302: CAC_VIEW_UTIL_PVT.AdjustForTimezone

1298: l_EndDate := r_PersonalItem .Enddate;
1299:
1300: if p_TimezoneId is not null
1301: then
1302: CAC_VIEW_UTIL_PVT.AdjustForTimezone
1303: ( p_source_tz_id => TO_NUMBER(r_PersonalItem .TimezoneID)
1304: , p_dest_tz_id => p_TimezoneId
1305: , p_source_day_time => l_StartDate
1306: , x_dest_day_time => l_NewStartDate

Line 1309: CAC_VIEW_UTIL_PVT.AdjustForTimezone

1305: , p_source_day_time => l_StartDate
1306: , x_dest_day_time => l_NewStartDate
1307: );
1308:
1309: CAC_VIEW_UTIL_PVT.AdjustForTimezone
1310: ( p_source_tz_id => TO_NUMBER(r_PersonalItem .TimezoneID)
1311: , p_dest_tz_id => p_TimezoneId
1312: , p_source_day_time => l_EndDate
1313: , x_dest_day_time => l_NewEndDate

Line 1316: CAC_VIEW_UTIL_PVT.AdjustForTimezone

1312: , p_source_day_time => l_EndDate
1313: , x_dest_day_time => l_NewEndDate
1314: );
1315: else
1316: CAC_VIEW_UTIL_PVT.AdjustForTimezone
1317: ( p_source_tz_id => r_PersonalItem .TimezoneID
1318: , p_dest_tz_id => TO_NUMBER(NVL(Fnd_Profile.Value('CLIENT_TIMEZONE_ID'),'4'))
1319: , p_source_day_time => l_StartDate
1320: , x_dest_day_time => l_NewStartDate

Line 1323: CAC_VIEW_UTIL_PVT.AdjustForTimezone

1319: , p_source_day_time => l_StartDate
1320: , x_dest_day_time => l_NewStartDate
1321: );
1322:
1323: CAC_VIEW_UTIL_PVT.AdjustForTimezone
1324: ( p_source_tz_id => r_PersonalItem .TimezoneID
1325: , p_dest_tz_id => TO_NUMBER(NVL(Fnd_Profile.Value('CLIENT_TIMEZONE_ID'),'4'))
1326: , p_source_day_time => l_EndDate
1327: , x_dest_day_time => l_NewEndDate

Line 1542: CAC_VIEW_UTIL_PVT.AdjustForTimezone

1538:
1539: IF p_timezone_id IS NOT NULL
1540: THEN
1541:
1542: CAC_VIEW_UTIL_PVT.AdjustForTimezone
1543: ( p_source_tz_id => p_timezone_id
1544: , p_dest_tz_id => to_number(NVL(FND_PROFILE.Value('CLIENT_TIMEZONE_ID'),'4'))
1545: , p_source_day_time => l_schedule_daytime(k).start_date_time
1546: , x_dest_day_time => l_new_start_date

Line 1549: CAC_VIEW_UTIL_PVT.AdjustForTimezone

1545: , p_source_day_time => l_schedule_daytime(k).start_date_time
1546: , x_dest_day_time => l_new_start_date
1547: );
1548:
1549: CAC_VIEW_UTIL_PVT.AdjustForTimezone
1550: ( p_source_tz_id => p_timezone_id
1551: , p_dest_tz_id => to_number(NVL(FND_PROFILE.Value('CLIENT_TIMEZONE_ID'),'4'))
1552: , p_source_day_time => l_schedule_daytime(k).end_date_time
1553: , x_dest_day_time => l_new_end_date

Line 1558: CAC_VIEW_UTIL_PVT.AdjustForTimezone

1554: );
1555:
1556: ELSIF p_view_timezone is not null
1557: then
1558: CAC_VIEW_UTIL_PVT.AdjustForTimezone
1559: ( p_source_tz_id => to_number(NVL(FND_PROFILE.Value('SERVER_TIMEZONE_ID'),'4'))
1560: , p_dest_tz_id => p_view_timezone
1561: , p_source_day_time => l_schedule_daytime(k).start_date_time
1562: , x_dest_day_time => l_new_start_date

Line 1565: CAC_VIEW_UTIL_PVT.AdjustForTimezone

1561: , p_source_day_time => l_schedule_daytime(k).start_date_time
1562: , x_dest_day_time => l_new_start_date
1563: );
1564:
1565: CAC_VIEW_UTIL_PVT.AdjustForTimezone
1566: ( p_source_tz_id => to_number(NVL(FND_PROFILE.Value('SERVER_TIMEZONE_ID'),'4'))
1567: , p_dest_tz_id => p_view_timezone
1568: , p_source_day_time => l_schedule_daytime(k).end_date_time
1569: , x_dest_day_time => l_new_end_date