eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSF_GANTT_DATA_PKG dependencies on FND_DATE

Line 425: l_ic_planned_start_date :=fnd_date.adjust_datetime( l_task_rec.planned_start_date,p_server_tz_code,l_res_tz_cd);

421: if p_timezone_enb
422: then
423: if l_res_tz_cd is not null
424: then
425: l_ic_planned_start_date :=fnd_date.adjust_datetime( l_task_rec.planned_start_date,p_server_tz_code,l_res_tz_cd);
426: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_res_tz_cd);
427: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_res_tz_cd);
428: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_res_tz_cd);
429: l_tz_desc :=l_rs_tz_desc;

Line 426: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_res_tz_cd);

422: then
423: if l_res_tz_cd is not null
424: then
425: l_ic_planned_start_date :=fnd_date.adjust_datetime( l_task_rec.planned_start_date,p_server_tz_code,l_res_tz_cd);
426: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_res_tz_cd);
427: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_res_tz_cd);
428: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_res_tz_cd);
429: l_tz_desc :=l_rs_tz_desc;
430: end if;

Line 427: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_res_tz_cd);

423: if l_res_tz_cd is not null
424: then
425: l_ic_planned_start_date :=fnd_date.adjust_datetime( l_task_rec.planned_start_date,p_server_tz_code,l_res_tz_cd);
426: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_res_tz_cd);
427: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_res_tz_cd);
428: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_res_tz_cd);
429: l_tz_desc :=l_rs_tz_desc;
430: end if;
431: else

Line 428: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_res_tz_cd);

424: then
425: l_ic_planned_start_date :=fnd_date.adjust_datetime( l_task_rec.planned_start_date,p_server_tz_code,l_res_tz_cd);
426: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_res_tz_cd);
427: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_res_tz_cd);
428: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_res_tz_cd);
429: l_tz_desc :=l_rs_tz_desc;
430: end if;
431: else
432: l_ic_planned_start_date :=l_task_rec.planned_start_date;

Line 444: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);

440: THEN
441:
442: if p_inc_tz_code ='UTZ'and p_timezone_enb
443: then
444: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
445: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
446: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,p_client_tz_code);
447: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,p_client_tz_code);
448: l_dc_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);

Line 445: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);

441:
442: if p_inc_tz_code ='UTZ'and p_timezone_enb
443: then
444: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
445: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
446: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,p_client_tz_code);
447: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,p_client_tz_code);
448: l_dc_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
449: l_dc_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);

Line 446: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,p_client_tz_code);

442: if p_inc_tz_code ='UTZ'and p_timezone_enb
443: then
444: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
445: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
446: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,p_client_tz_code);
447: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,p_client_tz_code);
448: l_dc_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
449: l_dc_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
450: else

Line 447: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,p_client_tz_code);

443: then
444: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
445: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
446: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,p_client_tz_code);
447: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,p_client_tz_code);
448: l_dc_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
449: l_dc_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
450: else
451: l_dc_planned_start_date :=l_task_rec.planned_start_date;

Line 448: l_dc_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);

444: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
445: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
446: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,p_client_tz_code);
447: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,p_client_tz_code);
448: l_dc_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
449: l_dc_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
450: else
451: l_dc_planned_start_date :=l_task_rec.planned_start_date;
452: l_dc_planned_end_date :=l_task_rec.planned_end_date;

Line 449: l_dc_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);

445: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
446: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,p_client_tz_code);
447: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,p_client_tz_code);
448: l_dc_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
449: l_dc_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
450: else
451: l_dc_planned_start_date :=l_task_rec.planned_start_date;
452: l_dc_planned_end_date :=l_task_rec.planned_end_date;
453: l_dc_scheduled_start_date :=l_task_rec.scheduled_start_date;

Line 461: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,l_task_rec.ic_tz_code);

457: end if;
458: l_actual_start_date :=l_dc_actual_start_date;
459: if l_task_rec.ic_tz_code is not null and p_timezone_enb
460: then
461: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
462: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
463: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
464: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
465: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);

Line 462: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_task_rec.ic_tz_code);

458: l_actual_start_date :=l_dc_actual_start_date;
459: if l_task_rec.ic_tz_code is not null and p_timezone_enb
460: then
461: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
462: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
463: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
464: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
465: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
466: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);

Line 463: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,l_task_rec.ic_tz_code);

459: if l_task_rec.ic_tz_code is not null and p_timezone_enb
460: then
461: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
462: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
463: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
464: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
465: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
466: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
467: l_actual_start_date :=l_ic_actual_start_date;

Line 464: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,l_task_rec.ic_tz_code);

460: then
461: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
462: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
463: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
464: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
465: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
466: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
467: l_actual_start_date :=l_ic_actual_start_date;
468: l_tz_desc :=l_task_rec.tz_desc;

Line 465: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);

461: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
462: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
463: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
464: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
465: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
466: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
467: l_actual_start_date :=l_ic_actual_start_date;
468: l_tz_desc :=l_task_rec.tz_desc;
469: end if;

Line 466: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);

462: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
463: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
464: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
465: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
466: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
467: l_actual_start_date :=l_ic_actual_start_date;
468: l_tz_desc :=l_task_rec.tz_desc;
469: end if;
470:

Line 496: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);

492: l_rec.travel_time := NVL(l_task_rec.actual_travel_duration, 0) || ' ' || l_uom;
493: ELSE
494: if p_inc_tz_code ='UTZ'and p_timezone_enb
495: then
496: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
497: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
498: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
499: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
500: else

Line 497: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);

493: ELSE
494: if p_inc_tz_code ='UTZ'and p_timezone_enb
495: then
496: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
497: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
498: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
499: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
500: else
501: l_dc_planned_start_date :=l_task_rec.planned_start_date;

Line 498: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);

494: if p_inc_tz_code ='UTZ'and p_timezone_enb
495: then
496: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
497: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
498: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
499: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
500: else
501: l_dc_planned_start_date :=l_task_rec.planned_start_date;
502: l_dc_planned_end_date :=l_task_rec.planned_end_date;

Line 499: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);

495: then
496: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
497: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
498: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
499: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
500: else
501: l_dc_planned_start_date :=l_task_rec.planned_start_date;
502: l_dc_planned_end_date :=l_task_rec.planned_end_date;
503: l_dc_scheduled_start_date :=p_start_date;

Line 509: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,l_task_rec.ic_tz_code);

505: end if;
506: l_scheduled_start_date :=l_dc_scheduled_start_date;
507: if l_task_rec.ic_tz_code is not null and p_timezone_enb and l_task_rec.task_type_id not in (20, 21)
508: then
509: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
510: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
511: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
512: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
513: l_scheduled_start_date :=l_ic_scheduled_start_date;

Line 510: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_task_rec.ic_tz_code);

506: l_scheduled_start_date :=l_dc_scheduled_start_date;
507: if l_task_rec.ic_tz_code is not null and p_timezone_enb and l_task_rec.task_type_id not in (20, 21)
508: then
509: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
510: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
511: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
512: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
513: l_scheduled_start_date :=l_ic_scheduled_start_date;
514: l_tz_desc :=l_task_rec.tz_desc;

Line 511: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);

507: if l_task_rec.ic_tz_code is not null and p_timezone_enb and l_task_rec.task_type_id not in (20, 21)
508: then
509: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
510: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
511: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
512: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
513: l_scheduled_start_date :=l_ic_scheduled_start_date;
514: l_tz_desc :=l_task_rec.tz_desc;
515: elsif l_res_tz_cd is not null and p_timezone_enb

Line 512: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);

508: then
509: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
510: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
511: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
512: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
513: l_scheduled_start_date :=l_ic_scheduled_start_date;
514: l_tz_desc :=l_task_rec.tz_desc;
515: elsif l_res_tz_cd is not null and p_timezone_enb
516: then

Line 990: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);

986: THEN
987:
988: if sch_adv_tz ='UTZ' and p_timezone_enb
989: then
990: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
991: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
992: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,p_client_tz_code);
993: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,p_client_tz_code);
994: l_dc_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);

Line 991: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);

987:
988: if sch_adv_tz ='UTZ' and p_timezone_enb
989: then
990: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
991: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
992: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,p_client_tz_code);
993: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,p_client_tz_code);
994: l_dc_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
995: l_dc_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);

Line 992: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,p_client_tz_code);

988: if sch_adv_tz ='UTZ' and p_timezone_enb
989: then
990: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
991: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
992: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,p_client_tz_code);
993: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,p_client_tz_code);
994: l_dc_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
995: l_dc_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
996: l_actual_start_date :=l_dc_actual_start_date;

Line 993: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,p_client_tz_code);

989: then
990: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
991: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
992: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,p_client_tz_code);
993: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,p_client_tz_code);
994: l_dc_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
995: l_dc_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
996: l_actual_start_date :=l_dc_actual_start_date;
997: if l_task_rec.ic_tz_code is not null and p_timezone_enb

Line 994: l_dc_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);

990: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
991: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
992: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,p_client_tz_code);
993: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,p_client_tz_code);
994: l_dc_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
995: l_dc_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
996: l_actual_start_date :=l_dc_actual_start_date;
997: if l_task_rec.ic_tz_code is not null and p_timezone_enb
998: then

Line 995: l_dc_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);

991: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
992: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,p_client_tz_code);
993: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,p_client_tz_code);
994: l_dc_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
995: l_dc_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
996: l_actual_start_date :=l_dc_actual_start_date;
997: if l_task_rec.ic_tz_code is not null and p_timezone_enb
998: then
999: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,l_task_rec.ic_tz_code);

Line 999: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,l_task_rec.ic_tz_code);

995: l_dc_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
996: l_actual_start_date :=l_dc_actual_start_date;
997: if l_task_rec.ic_tz_code is not null and p_timezone_enb
998: then
999: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1000: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1001: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1002: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1003: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);

Line 1000: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_task_rec.ic_tz_code);

996: l_actual_start_date :=l_dc_actual_start_date;
997: if l_task_rec.ic_tz_code is not null and p_timezone_enb
998: then
999: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1000: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1001: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1002: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1003: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1004: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);

Line 1001: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,l_task_rec.ic_tz_code);

997: if l_task_rec.ic_tz_code is not null and p_timezone_enb
998: then
999: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1000: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1001: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1002: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1003: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1004: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1005: l_actual_start_date :=l_ic_actual_start_date;

Line 1002: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,l_task_rec.ic_tz_code);

998: then
999: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1000: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1001: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1002: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1003: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1004: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1005: l_actual_start_date :=l_ic_actual_start_date;
1006: l_tz_desc :=l_task_rec.tz_desc;

Line 1003: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);

999: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1000: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1001: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1002: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1003: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1004: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1005: l_actual_start_date :=l_ic_actual_start_date;
1006: l_tz_desc :=l_task_rec.tz_desc;
1007: end if;

Line 1004: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);

1000: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1001: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1002: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1003: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1004: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1005: l_actual_start_date :=l_ic_actual_start_date;
1006: l_tz_desc :=l_task_rec.tz_desc;
1007: end if;
1008: elsif sch_adv_tz ='CTZ' and p_timezone_enb

Line 1020: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,l_task_rec.ic_tz_code);

1016:
1017: l_actual_start_date :=l_dc_actual_start_date;
1018: if l_task_rec.ic_tz_code is not null and p_timezone_enb
1019: then
1020: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1021: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1022: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1023: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1024: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);

Line 1021: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_task_rec.ic_tz_code);

1017: l_actual_start_date :=l_dc_actual_start_date;
1018: if l_task_rec.ic_tz_code is not null and p_timezone_enb
1019: then
1020: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1021: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1022: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1023: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1024: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1025: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);

Line 1022: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,l_task_rec.ic_tz_code);

1018: if l_task_rec.ic_tz_code is not null and p_timezone_enb
1019: then
1020: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1021: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1022: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1023: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1024: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1025: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1026: l_actual_start_date :=l_ic_actual_start_date;

Line 1023: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,l_task_rec.ic_tz_code);

1019: then
1020: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1021: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1022: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1023: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1024: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1025: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1026: l_actual_start_date :=l_ic_actual_start_date;
1027: l_tz_desc :=l_task_rec.tz_desc;

Line 1024: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);

1020: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1021: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1022: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1023: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1024: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1025: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1026: l_actual_start_date :=l_ic_actual_start_date;
1027: l_tz_desc :=l_task_rec.tz_desc;
1028: end if;

Line 1025: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);

1021: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1022: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1023: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1024: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1025: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1026: l_actual_start_date :=l_ic_actual_start_date;
1027: l_tz_desc :=l_task_rec.tz_desc;
1028: end if;
1029: elsif sch_adv_tz ='ITZ' and p_timezone_enb

Line 1031: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,l_task_rec.ic_tz_code);

1027: l_tz_desc :=l_task_rec.tz_desc;
1028: end if;
1029: elsif sch_adv_tz ='ITZ' and p_timezone_enb
1030: then
1031: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1032: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1033: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1034: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1035: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);

Line 1032: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_task_rec.ic_tz_code);

1028: end if;
1029: elsif sch_adv_tz ='ITZ' and p_timezone_enb
1030: then
1031: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1032: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1033: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1034: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1035: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1036: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);

Line 1033: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,l_task_rec.ic_tz_code);

1029: elsif sch_adv_tz ='ITZ' and p_timezone_enb
1030: then
1031: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1032: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1033: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1034: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1035: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1036: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1037: l_actual_start_date :=l_ic_actual_start_date;

Line 1034: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,l_task_rec.ic_tz_code);

1030: then
1031: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1032: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1033: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1034: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1035: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1036: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1037: l_actual_start_date :=l_ic_actual_start_date;
1038: l_tz_desc := p_inc_tz_desc;

Line 1035: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);

1031: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1032: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1033: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1034: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1035: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1036: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1037: l_actual_start_date :=l_ic_actual_start_date;
1038: l_tz_desc := p_inc_tz_desc;
1039: end if;

Line 1036: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);

1032: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1033: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1034: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1035: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1036: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1037: l_actual_start_date :=l_ic_actual_start_date;
1038: l_tz_desc := p_inc_tz_desc;
1039: end if;
1040:

Line 1066: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);

1062: l_rec.travel_time := NVL(l_task_rec.actual_travel_duration, 0) || ' ' || l_uom;
1063: ELSE
1064: if sch_adv_tz ='UTZ' and p_timezone_enb
1065: then
1066: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
1067: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
1068: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
1069: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
1070: l_scheduled_start_date :=l_dc_scheduled_start_date;

Line 1067: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);

1063: ELSE
1064: if sch_adv_tz ='UTZ' and p_timezone_enb
1065: then
1066: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
1067: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
1068: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
1069: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
1070: l_scheduled_start_date :=l_dc_scheduled_start_date;
1071: if l_task_rec.ic_tz_code is not null

Line 1068: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);

1064: if sch_adv_tz ='UTZ' and p_timezone_enb
1065: then
1066: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
1067: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
1068: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
1069: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
1070: l_scheduled_start_date :=l_dc_scheduled_start_date;
1071: if l_task_rec.ic_tz_code is not null
1072: then

Line 1069: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);

1065: then
1066: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
1067: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
1068: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
1069: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
1070: l_scheduled_start_date :=l_dc_scheduled_start_date;
1071: if l_task_rec.ic_tz_code is not null
1072: then
1073: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,l_task_rec.ic_tz_code);

Line 1073: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,l_task_rec.ic_tz_code);

1069: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
1070: l_scheduled_start_date :=l_dc_scheduled_start_date;
1071: if l_task_rec.ic_tz_code is not null
1072: then
1073: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1074: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1075: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1076: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1077: l_scheduled_start_date :=l_ic_scheduled_start_date;

Line 1074: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_task_rec.ic_tz_code);

1070: l_scheduled_start_date :=l_dc_scheduled_start_date;
1071: if l_task_rec.ic_tz_code is not null
1072: then
1073: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1074: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1075: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1076: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1077: l_scheduled_start_date :=l_ic_scheduled_start_date;
1078: l_tz_desc :=l_task_rec.tz_desc;

Line 1075: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);

1071: if l_task_rec.ic_tz_code is not null
1072: then
1073: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1074: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1075: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1076: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1077: l_scheduled_start_date :=l_ic_scheduled_start_date;
1078: l_tz_desc :=l_task_rec.tz_desc;
1079: end if;

Line 1076: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);

1072: then
1073: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1074: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1075: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1076: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1077: l_scheduled_start_date :=l_ic_scheduled_start_date;
1078: l_tz_desc :=l_task_rec.tz_desc;
1079: end if;
1080: elsif sch_adv_tz ='CTZ' and p_timezone_enb

Line 1089: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,l_task_rec.ic_tz_code);

1085: l_dc_scheduled_end_date :=p_end_date;
1086: l_scheduled_start_date :=l_dc_scheduled_start_date;
1087: if l_task_rec.ic_tz_code is not null
1088: then
1089: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1090: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1091: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1092: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1093: l_scheduled_start_date :=l_ic_scheduled_start_date;

Line 1090: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_task_rec.ic_tz_code);

1086: l_scheduled_start_date :=l_dc_scheduled_start_date;
1087: if l_task_rec.ic_tz_code is not null
1088: then
1089: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1090: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1091: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1092: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1093: l_scheduled_start_date :=l_ic_scheduled_start_date;
1094: l_tz_desc :=l_task_rec.tz_desc;

Line 1091: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);

1087: if l_task_rec.ic_tz_code is not null
1088: then
1089: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1090: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1091: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1092: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1093: l_scheduled_start_date :=l_ic_scheduled_start_date;
1094: l_tz_desc :=l_task_rec.tz_desc;
1095: end if;

Line 1092: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);

1088: then
1089: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1090: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1091: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1092: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1093: l_scheduled_start_date :=l_ic_scheduled_start_date;
1094: l_tz_desc :=l_task_rec.tz_desc;
1095: end if;
1096: elsif sch_adv_tz ='ITZ' and p_timezone_enb

Line 1098: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_inc_tz_code);

1094: l_tz_desc :=l_task_rec.tz_desc;
1095: end if;
1096: elsif sch_adv_tz ='ITZ' and p_timezone_enb
1097: then
1098: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_inc_tz_code);
1099: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_inc_tz_code);
1100: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
1101: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
1102: l_scheduled_start_date :=l_ic_scheduled_start_date;

Line 1099: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_inc_tz_code);

1095: end if;
1096: elsif sch_adv_tz ='ITZ' and p_timezone_enb
1097: then
1098: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_inc_tz_code);
1099: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_inc_tz_code);
1100: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
1101: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
1102: l_scheduled_start_date :=l_ic_scheduled_start_date;
1103: l_tz_desc := p_inc_tz_desc;

Line 1100: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);

1096: elsif sch_adv_tz ='ITZ' and p_timezone_enb
1097: then
1098: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_inc_tz_code);
1099: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_inc_tz_code);
1100: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
1101: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
1102: l_scheduled_start_date :=l_ic_scheduled_start_date;
1103: l_tz_desc := p_inc_tz_desc;
1104: end if;

Line 1101: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);

1097: then
1098: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_inc_tz_code);
1099: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_inc_tz_code);
1100: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
1101: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
1102: l_scheduled_start_date :=l_ic_scheduled_start_date;
1103: l_tz_desc := p_inc_tz_desc;
1104: end if;
1105:

Line 1600: start_date(i) :=fnd_date.adjust_datetime(start_date(i),g_client_tz,g_server_tz );

1596: if g_tz_enabled ='Y' and g_dflt_tz_for_sc='CTZ' and task_id.count > 0
1597: then
1598: FOR i IN task_id.FIRST .. task_id.LAST
1599: LOOP
1600: start_date(i) :=fnd_date.adjust_datetime(start_date(i),g_client_tz,g_server_tz );
1601: end_date(i) :=fnd_date.adjust_datetime(end_date(i) ,g_client_tz,g_server_tz);
1602: END LOOP;
1603: end if;
1604:

Line 1601: end_date(i) :=fnd_date.adjust_datetime(end_date(i) ,g_client_tz,g_server_tz);

1597: then
1598: FOR i IN task_id.FIRST .. task_id.LAST
1599: LOOP
1600: start_date(i) :=fnd_date.adjust_datetime(start_date(i),g_client_tz,g_server_tz );
1601: end_date(i) :=fnd_date.adjust_datetime(end_date(i) ,g_client_tz,g_server_tz);
1602: END LOOP;
1603: end if;
1604:
1605: IF task_id.COUNT IS NULL THEN

Line 1691: l_ic_scheduled_start_date := fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);

1687: IF p_timezone_enb
1688: THEN
1689: IF sch_adv_tz ='ITZ'
1690: THEN
1691: l_ic_scheduled_start_date := fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
1692: l_ic_scheduled_end_date := fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
1693: l_scheduled_start := l_ic_scheduled_start_date;
1694: ELSIF sch_adv_tz = 'UTZ'
1695: THEN

Line 1692: l_ic_scheduled_end_date := fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);

1688: THEN
1689: IF sch_adv_tz ='ITZ'
1690: THEN
1691: l_ic_scheduled_start_date := fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
1692: l_ic_scheduled_end_date := fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
1693: l_scheduled_start := l_ic_scheduled_start_date;
1694: ELSIF sch_adv_tz = 'UTZ'
1695: THEN
1696: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);

Line 1696: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);

1692: l_ic_scheduled_end_date := fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
1693: l_scheduled_start := l_ic_scheduled_start_date;
1694: ELSIF sch_adv_tz = 'UTZ'
1695: THEN
1696: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
1697: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
1698: l_scheduled_start :=l_dc_scheduled_start_date;
1699: IF p_inc_tz_code is not null and l_inc_tz_code is not null
1700: THEN

Line 1697: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);

1693: l_scheduled_start := l_ic_scheduled_start_date;
1694: ELSIF sch_adv_tz = 'UTZ'
1695: THEN
1696: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
1697: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
1698: l_scheduled_start :=l_dc_scheduled_start_date;
1699: IF p_inc_tz_code is not null and l_inc_tz_code is not null
1700: THEN
1701: l_ic_scheduled_start_date := fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_inc_tz_code);

Line 1701: l_ic_scheduled_start_date := fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_inc_tz_code);

1697: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
1698: l_scheduled_start :=l_dc_scheduled_start_date;
1699: IF p_inc_tz_code is not null and l_inc_tz_code is not null
1700: THEN
1701: l_ic_scheduled_start_date := fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_inc_tz_code);
1702: l_ic_scheduled_end_date := fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_inc_tz_code);
1703: END IF;
1704: ELSE
1705: l_dc_scheduled_start_date := p_start_date;

Line 1702: l_ic_scheduled_end_date := fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_inc_tz_code);

1698: l_scheduled_start :=l_dc_scheduled_start_date;
1699: IF p_inc_tz_code is not null and l_inc_tz_code is not null
1700: THEN
1701: l_ic_scheduled_start_date := fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_inc_tz_code);
1702: l_ic_scheduled_end_date := fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_inc_tz_code);
1703: END IF;
1704: ELSE
1705: l_dc_scheduled_start_date := p_start_date;
1706: l_dc_scheduled_end_date := p_end_date;

Line 1710: l_ic_scheduled_start_date := fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_inc_tz_code);

1706: l_dc_scheduled_end_date := p_end_date;
1707: l_scheduled_start := l_dc_scheduled_start_date;
1708: IF p_inc_tz_code is not null and l_inc_tz_code is not null
1709: THEN
1710: l_ic_scheduled_start_date := fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_inc_tz_code);
1711: l_ic_scheduled_end_date := fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_inc_tz_code);
1712: END IF;
1713: END IF;
1714:

Line 1711: l_ic_scheduled_end_date := fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_inc_tz_code);

1707: l_scheduled_start := l_dc_scheduled_start_date;
1708: IF p_inc_tz_code is not null and l_inc_tz_code is not null
1709: THEN
1710: l_ic_scheduled_start_date := fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_inc_tz_code);
1711: l_ic_scheduled_end_date := fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_inc_tz_code);
1712: END IF;
1713: END IF;
1714:
1715: l_departure_time :=

Line 2973: p_shift_start_date(i) :=fnd_date.adjust_datetime(p_shift_start_date(i),g_client_tz,g_server_tz );

2969: if g_tz_enabled ='Y' and g_dflt_tz_for_dc='CTZ' and p_trip_id.count > 0
2970: then
2971: FOR i IN p_trip_id.FIRST .. p_trip_id.LAST
2972: LOOP
2973: p_shift_start_date(i) :=fnd_date.adjust_datetime(p_shift_start_date(i),g_client_tz,g_server_tz );
2974: p_shift_end_date(i) :=fnd_date.adjust_datetime(p_shift_end_date(i) ,g_client_tz,g_server_tz);
2975: END LOOP;
2976: end if;
2977:

Line 2974: p_shift_end_date(i) :=fnd_date.adjust_datetime(p_shift_end_date(i) ,g_client_tz,g_server_tz);

2970: then
2971: FOR i IN p_trip_id.FIRST .. p_trip_id.LAST
2972: LOOP
2973: p_shift_start_date(i) :=fnd_date.adjust_datetime(p_shift_start_date(i),g_client_tz,g_server_tz );
2974: p_shift_end_date(i) :=fnd_date.adjust_datetime(p_shift_end_date(i) ,g_client_tz,g_server_tz);
2975: END LOOP;
2976: end if;
2977:
2978: IF g_use_custom_chromatics

Line 3189: p_vir_start_date(i) :=fnd_date.adjust_datetime(p_vir_start_date(i),g_client_tz,g_server_tz );

3185: END IF;
3186:
3187: IF g_tz_enabled ='Y' and g_dflt_tz_for_dc='CTZ'
3188: THEN
3189: p_vir_start_date(i) :=fnd_date.adjust_datetime(p_vir_start_date(i),g_client_tz,g_server_tz );
3190: p_vir_end_date(i) :=fnd_date.adjust_datetime(p_vir_end_date(i) ,g_client_tz,g_server_tz);
3191: END IF;
3192: END LOOP;
3193: END IF;

Line 3190: p_vir_end_date(i) :=fnd_date.adjust_datetime(p_vir_end_date(i) ,g_client_tz,g_server_tz);

3186:
3187: IF g_tz_enabled ='Y' and g_dflt_tz_for_dc='CTZ'
3188: THEN
3189: p_vir_start_date(i) :=fnd_date.adjust_datetime(p_vir_start_date(i),g_client_tz,g_server_tz );
3190: p_vir_end_date(i) :=fnd_date.adjust_datetime(p_vir_end_date(i) ,g_client_tz,g_server_tz);
3191: END IF;
3192: END LOOP;
3193: END IF;
3194: END IF; -- for p_show_arr_dep_tasks = 'Y'

Line 3588: real_start_date(i) :=fnd_date.adjust_datetime(real_start_date(i),g_client_tz,g_server_tz );

3584: real_color(i) := red;
3585: END IF;
3586: IF g_tz_enabled ='Y' and g_dflt_tz_for_dc='CTZ'
3587: THEN
3588: real_start_date(i) :=fnd_date.adjust_datetime(real_start_date(i),g_client_tz,g_server_tz );
3589: real_end_date(i) :=fnd_date.adjust_datetime(real_end_date(i) ,g_client_tz,g_server_tz);
3590: END IF;
3591: END LOOP;
3592: END IF;

Line 3589: real_end_date(i) :=fnd_date.adjust_datetime(real_end_date(i) ,g_client_tz,g_server_tz);

3585: END IF;
3586: IF g_tz_enabled ='Y' and g_dflt_tz_for_dc='CTZ'
3587: THEN
3588: real_start_date(i) :=fnd_date.adjust_datetime(real_start_date(i),g_client_tz,g_server_tz );
3589: real_end_date(i) :=fnd_date.adjust_datetime(real_end_date(i) ,g_client_tz,g_server_tz);
3590: END IF;
3591: END LOOP;
3592: END IF;
3593: END;

Line 4690: start_date(i) :=fnd_date.adjust_datetime(start_date(i),g_client_tz,g_server_tz );

4686: IF trip_id.COUNT IS NOT NULL AND trip_id.COUNT > 0
4687: THEN
4688: FOR i IN trip_id.FIRST .. trip_id.LAST
4689: LOOP
4690: start_date(i) :=fnd_date.adjust_datetime(start_date(i),g_client_tz,g_server_tz );
4691: end_date(i) :=fnd_date.adjust_datetime(end_date(i) ,g_client_tz,g_server_tz);
4692: END LOOP;
4693: END IF;
4694: elsif g_tz_enabled ='Y' and sch_adv_tz='ITZ' and trip_id.count > 0

Line 4691: end_date(i) :=fnd_date.adjust_datetime(end_date(i) ,g_client_tz,g_server_tz);

4687: THEN
4688: FOR i IN trip_id.FIRST .. trip_id.LAST
4689: LOOP
4690: start_date(i) :=fnd_date.adjust_datetime(start_date(i),g_client_tz,g_server_tz );
4691: end_date(i) :=fnd_date.adjust_datetime(end_date(i) ,g_client_tz,g_server_tz);
4692: END LOOP;
4693: END IF;
4694: elsif g_tz_enabled ='Y' and sch_adv_tz='ITZ' and trip_id.count > 0
4695: then

Line 4700: start_date(i) :=fnd_date.adjust_datetime(start_date(i),g_client_tz,inc_tz_code );

4696: IF trip_id.COUNT IS NOT NULL AND trip_id.COUNT > 0
4697: THEN
4698: FOR i IN trip_id.FIRST .. trip_id.LAST
4699: LOOP
4700: start_date(i) :=fnd_date.adjust_datetime(start_date(i),g_client_tz,inc_tz_code );
4701: end_date(i) :=fnd_date.adjust_datetime(end_date(i) ,g_client_tz,inc_tz_code);
4702: END LOOP;
4703: END IF;
4704: end if;

Line 4701: end_date(i) :=fnd_date.adjust_datetime(end_date(i) ,g_client_tz,inc_tz_code);

4697: THEN
4698: FOR i IN trip_id.FIRST .. trip_id.LAST
4699: LOOP
4700: start_date(i) :=fnd_date.adjust_datetime(start_date(i),g_client_tz,inc_tz_code );
4701: end_date(i) :=fnd_date.adjust_datetime(end_date(i) ,g_client_tz,inc_tz_code);
4702: END LOOP;
4703: END IF;
4704: end if;
4705:

Line 4725: plan_start_date(i):=fnd_date.adjust_datetime(plan_start_date(i),g_client_tz,g_server_tz );

4721: FOR i IN plan_task_key.first..plan_task_key.last
4722: LOOP
4723: IF g_tz_enabled ='Y' AND sch_adv_tz='CTZ'
4724: THEN
4725: plan_start_date(i):=fnd_date.adjust_datetime(plan_start_date(i),g_client_tz,g_server_tz );
4726: ELSIF g_tz_enabled ='Y' AND sch_adv_tz='ITZ'
4727: THEN
4728: plan_start_date(i):=fnd_date.adjust_datetime(plan_start_date(i),g_client_tz,inc_tz_code );
4729: END IF;

Line 4728: plan_start_date(i):=fnd_date.adjust_datetime(plan_start_date(i),g_client_tz,inc_tz_code );

4724: THEN
4725: plan_start_date(i):=fnd_date.adjust_datetime(plan_start_date(i),g_client_tz,g_server_tz );
4726: ELSIF g_tz_enabled ='Y' AND sch_adv_tz='ITZ'
4727: THEN
4728: plan_start_date(i):=fnd_date.adjust_datetime(plan_start_date(i),g_client_tz,inc_tz_code );
4729: END IF;
4730: IF g_tz_enabled ='Y' AND sch_adv_tz='CTZ'
4731: THEN
4732: plan_end_date(i):=fnd_date.adjust_datetime(plan_end_date(i),g_client_tz,g_server_tz);

Line 4732: plan_end_date(i):=fnd_date.adjust_datetime(plan_end_date(i),g_client_tz,g_server_tz);

4728: plan_start_date(i):=fnd_date.adjust_datetime(plan_start_date(i),g_client_tz,inc_tz_code );
4729: END IF;
4730: IF g_tz_enabled ='Y' AND sch_adv_tz='CTZ'
4731: THEN
4732: plan_end_date(i):=fnd_date.adjust_datetime(plan_end_date(i),g_client_tz,g_server_tz);
4733: ELSIF g_tz_enabled ='Y' AND sch_adv_tz='ITZ'
4734: THEN
4735: plan_end_date(i):=fnd_date.adjust_datetime(plan_end_date(i),g_client_tz,inc_tz_code);
4736: END IF;

Line 4735: plan_end_date(i):=fnd_date.adjust_datetime(plan_end_date(i),g_client_tz,inc_tz_code);

4731: THEN
4732: plan_end_date(i):=fnd_date.adjust_datetime(plan_end_date(i),g_client_tz,g_server_tz);
4733: ELSIF g_tz_enabled ='Y' AND sch_adv_tz='ITZ'
4734: THEN
4735: plan_end_date(i):=fnd_date.adjust_datetime(plan_end_date(i),g_client_tz,inc_tz_code);
4736: END IF;
4737: END LOOP;
4738: END IF;
4739:

Line 5142: oth_real_start_date(i) :=fnd_date.adjust_datetime(oth_real_start_date(i),g_client_tz,g_server_tz );

5138: END IF;
5139:
5140: if g_tz_enabled ='Y' and sch_adv_tz='CTZ'
5141: then
5142: oth_real_start_date(i) :=fnd_date.adjust_datetime(oth_real_start_date(i),g_client_tz,g_server_tz );
5143: oth_real_end_date(i) :=fnd_date.adjust_datetime(oth_real_end_date(i) ,g_client_tz,g_server_tz);
5144: elsif g_tz_enabled ='Y' and sch_adv_tz='ITZ'
5145: then
5146: oth_real_start_date(i) :=fnd_date.adjust_datetime(oth_real_start_date(i),g_client_tz,inc_tz_code );

Line 5143: oth_real_end_date(i) :=fnd_date.adjust_datetime(oth_real_end_date(i) ,g_client_tz,g_server_tz);

5139:
5140: if g_tz_enabled ='Y' and sch_adv_tz='CTZ'
5141: then
5142: oth_real_start_date(i) :=fnd_date.adjust_datetime(oth_real_start_date(i),g_client_tz,g_server_tz );
5143: oth_real_end_date(i) :=fnd_date.adjust_datetime(oth_real_end_date(i) ,g_client_tz,g_server_tz);
5144: elsif g_tz_enabled ='Y' and sch_adv_tz='ITZ'
5145: then
5146: oth_real_start_date(i) :=fnd_date.adjust_datetime(oth_real_start_date(i),g_client_tz,inc_tz_code );
5147: oth_real_end_date(i) :=fnd_date.adjust_datetime(oth_real_end_date(i) ,g_client_tz,inc_tz_code);

Line 5146: oth_real_start_date(i) :=fnd_date.adjust_datetime(oth_real_start_date(i),g_client_tz,inc_tz_code );

5142: oth_real_start_date(i) :=fnd_date.adjust_datetime(oth_real_start_date(i),g_client_tz,g_server_tz );
5143: oth_real_end_date(i) :=fnd_date.adjust_datetime(oth_real_end_date(i) ,g_client_tz,g_server_tz);
5144: elsif g_tz_enabled ='Y' and sch_adv_tz='ITZ'
5145: then
5146: oth_real_start_date(i) :=fnd_date.adjust_datetime(oth_real_start_date(i),g_client_tz,inc_tz_code );
5147: oth_real_end_date(i) :=fnd_date.adjust_datetime(oth_real_end_date(i) ,g_client_tz,inc_tz_code);
5148: end if;
5149: END LOOP;
5150: END IF;

Line 5147: oth_real_end_date(i) :=fnd_date.adjust_datetime(oth_real_end_date(i) ,g_client_tz,inc_tz_code);

5143: oth_real_end_date(i) :=fnd_date.adjust_datetime(oth_real_end_date(i) ,g_client_tz,g_server_tz);
5144: elsif g_tz_enabled ='Y' and sch_adv_tz='ITZ'
5145: then
5146: oth_real_start_date(i) :=fnd_date.adjust_datetime(oth_real_start_date(i),g_client_tz,inc_tz_code );
5147: oth_real_end_date(i) :=fnd_date.adjust_datetime(oth_real_end_date(i) ,g_client_tz,inc_tz_code);
5148: end if;
5149: END LOOP;
5150: END IF;
5151:

Line 5270: real_start_date(i) :=fnd_date.adjust_datetime(real_start_date(i),g_client_tz,g_server_tz );

5266: FOR i IN real_task_key.first..real_task_key.last
5267: LOOP
5268: IF g_tz_enabled ='Y' AND sch_adv_tz='CTZ'
5269: THEN
5270: real_start_date(i) :=fnd_date.adjust_datetime(real_start_date(i),g_client_tz,g_server_tz );
5271: ELSIF g_tz_enabled ='Y' AND sch_adv_tz='ITZ'
5272: THEN
5273: real_start_date(i) :=fnd_date.adjust_datetime(real_start_date(i),g_client_tz,inc_tz_code );
5274: END IF;

Line 5273: real_start_date(i) :=fnd_date.adjust_datetime(real_start_date(i),g_client_tz,inc_tz_code );

5269: THEN
5270: real_start_date(i) :=fnd_date.adjust_datetime(real_start_date(i),g_client_tz,g_server_tz );
5271: ELSIF g_tz_enabled ='Y' AND sch_adv_tz='ITZ'
5272: THEN
5273: real_start_date(i) :=fnd_date.adjust_datetime(real_start_date(i),g_client_tz,inc_tz_code );
5274: END IF;
5275: IF g_tz_enabled ='Y' AND sch_adv_tz='CTZ'
5276: THEN
5277: real_end_date(i) :=fnd_date.adjust_datetime(real_end_date(i),g_client_tz,g_server_tz);

Line 5277: real_end_date(i) :=fnd_date.adjust_datetime(real_end_date(i),g_client_tz,g_server_tz);

5273: real_start_date(i) :=fnd_date.adjust_datetime(real_start_date(i),g_client_tz,inc_tz_code );
5274: END IF;
5275: IF g_tz_enabled ='Y' AND sch_adv_tz='CTZ'
5276: THEN
5277: real_end_date(i) :=fnd_date.adjust_datetime(real_end_date(i),g_client_tz,g_server_tz);
5278: ELSIF g_tz_enabled ='Y' AND sch_adv_tz='ITZ'
5279: THEN
5280: real_end_date(i) :=fnd_date.adjust_datetime(real_end_date(i),g_client_tz,inc_tz_code);
5281: END IF;

Line 5280: real_end_date(i) :=fnd_date.adjust_datetime(real_end_date(i),g_client_tz,inc_tz_code);

5276: THEN
5277: real_end_date(i) :=fnd_date.adjust_datetime(real_end_date(i),g_client_tz,g_server_tz);
5278: ELSIF g_tz_enabled ='Y' AND sch_adv_tz='ITZ'
5279: THEN
5280: real_end_date(i) :=fnd_date.adjust_datetime(real_end_date(i),g_client_tz,inc_tz_code);
5281: END IF;
5282:
5283: IF nvl(l_task_depends,'N') ='Y'
5284: THEN