DBA Data[Home] [Help]

APPS.CSF_TRIPS_PUB dependencies on FND_DATE

Line 117: -- AOL doesnt initialize FND_DATE package properly. Refer bugs 3183418 and 3115188.

113: l_date DATE;
114: BEGIN
115: l_date := p_date;
116: IF p_convert_to_client_tz IS NULL OR p_convert_to_client_tz = fnd_api.g_true THEN
117: -- AOL doesnt initialize FND_DATE package properly. Refer bugs 3183418 and 3115188.
118: -- Because of this, dates werent printed with TZ Conversion. Bypassing FND_DATE.
119: IF g_tz_enabled = 'Y' THEN
120: l_date := fnd_timezones_pvt.adjust_datetime(
121: date_time => p_date

Line 118: -- Because of this, dates werent printed with TZ Conversion. Bypassing FND_DATE.

114: BEGIN
115: l_date := p_date;
116: IF p_convert_to_client_tz IS NULL OR p_convert_to_client_tz = fnd_api.g_true THEN
117: -- AOL doesnt initialize FND_DATE package properly. Refer bugs 3183418 and 3115188.
118: -- Because of this, dates werent printed with TZ Conversion. Bypassing FND_DATE.
119: IF g_tz_enabled = 'Y' THEN
120: l_date := fnd_timezones_pvt.adjust_datetime(
121: date_time => p_date
122: , from_tz => g_server_tz_code

Line 3599: l_start_date := fnd_date.canonical_to_date(p_start_date);

3595: /************* Concurrent Program Input Parameters Validation *************/
3596:
3597: -- Get the Start Date (with Timezone Conversions) from the passed Start Date
3598: IF p_start_date IS NOT NULL THEN
3599: l_start_date := fnd_date.canonical_to_date(p_start_date);
3600:
3601: IF l_start_date < SYSDATE AND p_action IN (g_action_create_trip, g_action_replace_trip) THEN
3602: l_start_date := NULL;
3603: END IF;

Line 3607: fnd_date_tz.init_timezones_for_fnd_date;

3603: END IF;
3604: END IF;
3605: IF NOT (g_init_timezone)
3606: THEN
3607: fnd_date_tz.init_timezones_for_fnd_date;
3608: g_init_timezone:=TRUE;
3609: END IF;
3610:
3611: IF l_start_date IS NULL THEN