DBA Data[Home] [Help]

APPS.CSF_TASK_ADDRESS_PVT dependencies on CSF_TIMEZONES_PVT

Line 135: TRUNC (csf_timezones_pvt.date_to_client_tz_date (SYSDATE));

131: --
132: IF p_start_date IS NULL
133: THEN
134: l_start_date :=
135: TRUNC (csf_timezones_pvt.date_to_client_tz_date (SYSDATE));
136: -- convert to server timezone
137: l_start_date :=
138: csf_timezones_pvt.date_to_server_tz_date (l_start_date);
139: ELSE

Line 138: csf_timezones_pvt.date_to_server_tz_date (l_start_date);

134: l_start_date :=
135: TRUNC (csf_timezones_pvt.date_to_client_tz_date (SYSDATE));
136: -- convert to server timezone
137: l_start_date :=
138: csf_timezones_pvt.date_to_server_tz_date (l_start_date);
139: ELSE
140: -- all fnd_date converts to server timezone so need for conversion
141: l_start_date := fnd_date.canonical_to_date (p_start_date);
142: END IF;

Line 172: l_start_date := csf_timezones_pvt.date_to_server_tz_date (l_start_date);

168: put_stream (g_output, fnd_message.get);
169: --
170: -- finally convert the date range to server timezone before processing
171: --
172: l_start_date := csf_timezones_pvt.date_to_server_tz_date (l_start_date);
173: l_end_date := csf_timezones_pvt.date_to_server_tz_date (l_end_date);
174: retrieve_data (p_api_version => 1.0,
175: p_init_msg_list => fnd_api.g_false,
176: p_commit => fnd_api.g_false,

Line 173: l_end_date := csf_timezones_pvt.date_to_server_tz_date (l_end_date);

169: --
170: -- finally convert the date range to server timezone before processing
171: --
172: l_start_date := csf_timezones_pvt.date_to_server_tz_date (l_start_date);
173: l_end_date := csf_timezones_pvt.date_to_server_tz_date (l_end_date);
174: retrieve_data (p_api_version => 1.0,
175: p_init_msg_list => fnd_api.g_false,
176: p_commit => fnd_api.g_false,
177: p_validation_level => fnd_api.g_valid_level_full,