APPS.FLM_SEQ_UI dependencies on FLM_TIMEZONE

Line 200: flm_timezone.init_timezone(p_organization_id);

196: l_debug_line := 10;
197: x_return_status := FND_API.G_RET_STS_SUCCESS;
198:
199: --fix bug#3170105
200: flm_timezone.init_timezone(p_organization_id);
201:
202: l_start_date := p_start_date;
203: l_end_date := p_end_date;
204:

Line 208: flm_timezone.server_to_calendar(l_start_date));

204:
205: l_debug_line := 20;
206: l_start_day := MRP_CALENDAR.NEXT_WORK_DAY(p_organization_id,
207: 1,
208: flm_timezone.server_to_calendar(l_start_date));
209:
210: l_debug_line := 30;
211: l_end_day := MRP_CALENDAR.PREV_WORK_DAY(p_organization_id,
212: 1,

Line 213: flm_timezone.server_to_calendar(l_end_date));

209:
210: l_debug_line := 30;
211: l_end_day := MRP_CALENDAR.PREV_WORK_DAY(p_organization_id,
212: 1,
213: flm_timezone.server_to_calendar(l_end_date));
214:
215: if (l_start_day = flm_timezone.server_to_calendar(l_start_date)) then
216: --fix bug#3872600: Modified to get time component in client timezone
217: l_temp_date := flm_timezone.server_to_client(l_start_date);

Line 215: if (l_start_day = flm_timezone.server_to_calendar(l_start_date)) then

211: l_end_day := MRP_CALENDAR.PREV_WORK_DAY(p_organization_id,
212: 1,
213: flm_timezone.server_to_calendar(l_end_date));
214:
215: if (l_start_day = flm_timezone.server_to_calendar(l_start_date)) then
216: --fix bug#3872600: Modified to get time component in client timezone
217: l_temp_date := flm_timezone.server_to_client(l_start_date);
218: l_start_time := to_char(l_temp_date, 'SSSSS');
219: else

Line 217: l_temp_date := flm_timezone.server_to_client(l_start_date);

213: flm_timezone.server_to_calendar(l_end_date));
214:
215: if (l_start_day = flm_timezone.server_to_calendar(l_start_date)) then
216: --fix bug#3872600: Modified to get time component in client timezone
217: l_temp_date := flm_timezone.server_to_client(l_start_date);
218: l_start_time := to_char(l_temp_date, 'SSSSS');
219: else
220: l_start_time := -1;
221: end if;

Line 223: if (l_end_day = flm_timezone.server_to_calendar(l_end_date)) then

219: else
220: l_start_time := -1;
221: end if;
222:
223: if (l_end_day = flm_timezone.server_to_calendar(l_end_date)) then
224: --fix bug#3872600: Modified to get time component in client timezone
225: l_temp_date := flm_timezone.server_to_client(l_end_date);
226: l_end_time := to_char(l_temp_date, 'SSSSS');
227: else

Line 225: l_temp_date := flm_timezone.server_to_client(l_end_date);

221: end if;
222:
223: if (l_end_day = flm_timezone.server_to_calendar(l_end_date)) then
224: --fix bug#3872600: Modified to get time component in client timezone
225: l_temp_date := flm_timezone.server_to_client(l_end_date);
226: l_end_time := to_char(l_temp_date, 'SSSSS');
227: else
228: l_end_time := -1;
229: end if;

Line 245: l_temp_date := flm_timezone.server_to_client(l_temp_date);

241: l_debug_line := 50;
242:
243: --fix bug#3872600: Modified to get client version of the passed start and end time
244: l_temp_date := trunc(sysdate) + (p_start_time/86400);
245: l_temp_date := flm_timezone.server_to_client(l_temp_date);
246: l_in_start_time := to_char(l_temp_date, 'SSSSS');
247:
248: l_temp_date := trunc(sysdate) + (p_stop_time/86400);
249: l_temp_date := flm_timezone.server_to_client(l_temp_date);

Line 249: l_temp_date := flm_timezone.server_to_client(l_temp_date);

245: l_temp_date := flm_timezone.server_to_client(l_temp_date);
246: l_in_start_time := to_char(l_temp_date, 'SSSSS');
247:
248: l_temp_date := trunc(sysdate) + (p_stop_time/86400);
249: l_temp_date := flm_timezone.server_to_client(l_temp_date);
250: l_in_stop_time := to_char(l_temp_date, 'SSSSS');
251:
252: l_debug_line := 60;
253: l_working_hours := (l_in_stop_time - l_in_start_time)/3600;

Line 858: WHERE scheduled_completion_date >= flm_timezone.client00_in_server(p_start_date) --fix bug#3170105

854:
855: SELECT min(wip_entity_id)
856: INTO x_wip_entity_id
857: FROM WIP_FLOW_SCHEDULES
858: WHERE scheduled_completion_date >= flm_timezone.client00_in_server(p_start_date) --fix bug#3170105
859: AND organization_id = p_org_id;
860:
861: l_debug_line := 20;
862: EXCEPTION