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;
143:
144: --
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;
143:
144: --
145: -- end date defaults to same day as start date (also truncated)
147: IF p_end_date IS NULL
148: THEN
149: l_end_date := l_start_date + 15;
150: ELSE
151: l_end_date := fnd_date.canonical_to_date (p_end_date);
152: END IF;
153:
154: --
155: -- get date format