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 685: l_ic_planned_start_date :=fnd_date.adjust_datetime( l_task_rec.planned_start_date,p_server_tz_code,l_res_tz_cd);

681: if p_timezone_enb
682: then
683: if l_res_tz_cd is not null
684: then
685: l_ic_planned_start_date :=fnd_date.adjust_datetime( l_task_rec.planned_start_date,p_server_tz_code,l_res_tz_cd);
686: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_res_tz_cd);
687: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_res_tz_cd);
688: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_res_tz_cd);
689: l_tz_desc :=l_rs_tz_desc;

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

682: then
683: if l_res_tz_cd is not null
684: then
685: l_ic_planned_start_date :=fnd_date.adjust_datetime( l_task_rec.planned_start_date,p_server_tz_code,l_res_tz_cd);
686: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_res_tz_cd);
687: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_res_tz_cd);
688: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_res_tz_cd);
689: l_tz_desc :=l_rs_tz_desc;
690: IF l_debug THEN

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

683: if l_res_tz_cd is not null
684: then
685: l_ic_planned_start_date :=fnd_date.adjust_datetime( l_task_rec.planned_start_date,p_server_tz_code,l_res_tz_cd);
686: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_res_tz_cd);
687: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_res_tz_cd);
688: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_res_tz_cd);
689: l_tz_desc :=l_rs_tz_desc;
690: IF l_debug THEN
691: debug(' If timezone is enabled and resource time zone exists then : ' , 'get_tooltip_data_gantt', fnd_log.level_statement);

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

684: then
685: l_ic_planned_start_date :=fnd_date.adjust_datetime( l_task_rec.planned_start_date,p_server_tz_code,l_res_tz_cd);
686: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_res_tz_cd);
687: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_res_tz_cd);
688: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_res_tz_cd);
689: l_tz_desc :=l_rs_tz_desc;
690: IF l_debug THEN
691: debug(' If timezone is enabled and resource time zone exists then : ' , 'get_tooltip_data_gantt', fnd_log.level_statement);
692: debug(' l_ic_planned_start_date : '||to_char(l_ic_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

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

714: THEN
715:
716: if p_inc_tz_code ='UTZ'and p_timezone_enb
717: then
718: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
719: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
720: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,p_client_tz_code);
721: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,p_client_tz_code);
722: l_dc_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);

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

715:
716: if p_inc_tz_code ='UTZ'and p_timezone_enb
717: then
718: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
719: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
720: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,p_client_tz_code);
721: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,p_client_tz_code);
722: l_dc_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
723: l_dc_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);

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

716: if p_inc_tz_code ='UTZ'and p_timezone_enb
717: then
718: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
719: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
720: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,p_client_tz_code);
721: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,p_client_tz_code);
722: l_dc_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
723: l_dc_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
724: IF l_debug THEN

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

717: then
718: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
719: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
720: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,p_client_tz_code);
721: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,p_client_tz_code);
722: l_dc_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
723: l_dc_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
724: IF l_debug THEN
725: debug(' Actual start date : '||l_task_rec.actual_start_date , 'get_tooltip_data_gantt', fnd_log.level_statement);

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

718: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
719: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
720: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,p_client_tz_code);
721: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,p_client_tz_code);
722: l_dc_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
723: l_dc_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
724: IF l_debug THEN
725: debug(' Actual start date : '||l_task_rec.actual_start_date , 'get_tooltip_data_gantt', fnd_log.level_statement);
726: debug(' l_dc_planned_start_date : '||to_char(l_dc_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

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

719: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
720: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,p_client_tz_code);
721: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,p_client_tz_code);
722: l_dc_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
723: l_dc_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
724: IF l_debug THEN
725: debug(' Actual start date : '||l_task_rec.actual_start_date , 'get_tooltip_data_gantt', fnd_log.level_statement);
726: debug(' l_dc_planned_start_date : '||to_char(l_dc_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
727: debug(' l_dc_planned_end_date : '||to_char(l_dc_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

Line 754: 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);

750: end if;
751: l_actual_start_date :=l_dc_actual_start_date;
752: if l_task_rec.ic_tz_code is not null and p_timezone_enb
753: then
754: 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);
755: 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);
756: 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);
757: 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);
758: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);

Line 755: 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);

751: l_actual_start_date :=l_dc_actual_start_date;
752: if l_task_rec.ic_tz_code is not null and p_timezone_enb
753: then
754: 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);
755: 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);
756: 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);
757: 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);
758: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
759: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);

Line 756: 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);

752: if l_task_rec.ic_tz_code is not null and p_timezone_enb
753: then
754: 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);
755: 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);
756: 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);
757: 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);
758: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
759: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
760: l_actual_start_date :=l_ic_actual_start_date;

Line 757: 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);

753: then
754: 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);
755: 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);
756: 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);
757: 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);
758: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
759: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
760: l_actual_start_date :=l_ic_actual_start_date;
761: l_tz_desc :=l_task_rec.tz_desc;

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

754: 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);
755: 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);
756: 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);
757: 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);
758: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
759: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
760: l_actual_start_date :=l_ic_actual_start_date;
761: l_tz_desc :=l_task_rec.tz_desc;
762: IF l_debug THEN

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

755: 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);
756: 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);
757: 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);
758: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
759: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
760: l_actual_start_date :=l_ic_actual_start_date;
761: l_tz_desc :=l_task_rec.tz_desc;
762: IF l_debug THEN
763: debug(' if l_task_rec.ic_tz_code is not null and p_timezone_enb then the values : ' , 'get_tooltip_data_gantt', fnd_log.level_statement);

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

847: END IF;
848: ELSE
849: if p_inc_tz_code ='UTZ'and p_timezone_enb
850: then
851: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
852: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
853: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
854: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
855: IF l_debug THEN

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

848: ELSE
849: if p_inc_tz_code ='UTZ'and p_timezone_enb
850: then
851: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
852: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
853: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
854: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
855: IF l_debug THEN
856: debug(' 1. Incident tz code is UTZ and time zone enabled ' , 'get_tooltip_data_gantt', fnd_log.level_statement);

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

849: if p_inc_tz_code ='UTZ'and p_timezone_enb
850: then
851: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
852: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
853: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
854: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
855: IF l_debug THEN
856: debug(' 1. Incident tz code is UTZ and time zone enabled ' , 'get_tooltip_data_gantt', fnd_log.level_statement);
857: debug(' l_dc_planned_start_date : '||to_char(l_dc_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

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

850: then
851: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
852: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
853: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
854: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
855: IF l_debug THEN
856: debug(' 1. Incident tz code is UTZ and time zone enabled ' , 'get_tooltip_data_gantt', fnd_log.level_statement);
857: debug(' l_dc_planned_start_date : '||to_char(l_dc_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
858: debug(' l_dc_planned_end_date : '||to_char(l_dc_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

Line 880: 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);

876: end if;
877: l_scheduled_start_date :=l_dc_scheduled_start_date;
878: 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)
879: then
880: 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);
881: 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);
882: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
883: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
884: l_scheduled_start_date :=l_ic_scheduled_start_date;

Line 881: 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);

877: l_scheduled_start_date :=l_dc_scheduled_start_date;
878: 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)
879: then
880: 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);
881: 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);
882: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
883: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
884: l_scheduled_start_date :=l_ic_scheduled_start_date;
885: l_tz_desc :=l_task_rec.tz_desc;

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

878: 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)
879: then
880: 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);
881: 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);
882: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
883: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
884: l_scheduled_start_date :=l_ic_scheduled_start_date;
885: l_tz_desc :=l_task_rec.tz_desc;
886: IF l_debug THEN

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

879: then
880: 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);
881: 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);
882: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
883: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
884: l_scheduled_start_date :=l_ic_scheduled_start_date;
885: l_tz_desc :=l_task_rec.tz_desc;
886: IF l_debug THEN
887: debug(' 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) then: ' , 'get_tooltip_data_gantt', fnd_log.level_statement);

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

1750: if p_timezone_enb
1751: then
1752: if l_res_tz_cd is not null
1753: then
1754: l_ic_planned_start_date :=fnd_date.adjust_datetime( l_task_rec.planned_start_date,p_server_tz_code,l_res_tz_cd);
1755: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_res_tz_cd);
1756: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_res_tz_cd);
1757: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_res_tz_cd);
1758: l_tz_desc :=l_rs_tz_desc;

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

1751: then
1752: if l_res_tz_cd is not null
1753: then
1754: l_ic_planned_start_date :=fnd_date.adjust_datetime( l_task_rec.planned_start_date,p_server_tz_code,l_res_tz_cd);
1755: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_res_tz_cd);
1756: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_res_tz_cd);
1757: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_res_tz_cd);
1758: l_tz_desc :=l_rs_tz_desc;
1759: end if;

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

1752: if l_res_tz_cd is not null
1753: then
1754: l_ic_planned_start_date :=fnd_date.adjust_datetime( l_task_rec.planned_start_date,p_server_tz_code,l_res_tz_cd);
1755: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_res_tz_cd);
1756: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_res_tz_cd);
1757: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_res_tz_cd);
1758: l_tz_desc :=l_rs_tz_desc;
1759: end if;
1760: else

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

1753: then
1754: l_ic_planned_start_date :=fnd_date.adjust_datetime( l_task_rec.planned_start_date,p_server_tz_code,l_res_tz_cd);
1755: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,l_res_tz_cd);
1756: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_res_tz_cd);
1757: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_res_tz_cd);
1758: l_tz_desc :=l_rs_tz_desc;
1759: end if;
1760: else
1761: l_ic_planned_start_date :=l_task_rec.planned_start_date;

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

1769: THEN
1770:
1771: if p_inc_tz_code ='UTZ'and p_timezone_enb
1772: then
1773: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
1774: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
1775: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,p_client_tz_code);
1776: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,p_client_tz_code);
1777: l_dc_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);

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

1770:
1771: if p_inc_tz_code ='UTZ'and p_timezone_enb
1772: then
1773: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
1774: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
1775: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,p_client_tz_code);
1776: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,p_client_tz_code);
1777: l_dc_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
1778: l_dc_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);

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

1771: if p_inc_tz_code ='UTZ'and p_timezone_enb
1772: then
1773: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
1774: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
1775: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,p_client_tz_code);
1776: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,p_client_tz_code);
1777: l_dc_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
1778: l_dc_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
1779: else

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

1772: then
1773: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
1774: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
1775: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,p_client_tz_code);
1776: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,p_client_tz_code);
1777: l_dc_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
1778: l_dc_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
1779: else
1780: l_dc_planned_start_date :=l_task_rec.planned_start_date;

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

1773: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
1774: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
1775: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,p_client_tz_code);
1776: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,p_client_tz_code);
1777: l_dc_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
1778: l_dc_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
1779: else
1780: l_dc_planned_start_date :=l_task_rec.planned_start_date;
1781: l_dc_planned_end_date :=l_task_rec.planned_end_date;

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

1774: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
1775: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,p_client_tz_code);
1776: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,p_client_tz_code);
1777: l_dc_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
1778: l_dc_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
1779: else
1780: l_dc_planned_start_date :=l_task_rec.planned_start_date;
1781: l_dc_planned_end_date :=l_task_rec.planned_end_date;
1782: l_dc_scheduled_start_date :=l_task_rec.scheduled_start_date;

Line 1790: 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);

1786: end if;
1787: l_actual_start_date :=l_dc_actual_start_date;
1788: if l_task_rec.ic_tz_code is not null and p_timezone_enb
1789: then
1790: 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);
1791: 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);
1792: 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);
1793: 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);
1794: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);

Line 1791: 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);

1787: l_actual_start_date :=l_dc_actual_start_date;
1788: if l_task_rec.ic_tz_code is not null and p_timezone_enb
1789: then
1790: 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);
1791: 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);
1792: 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);
1793: 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);
1794: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1795: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);

Line 1792: 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);

1788: if l_task_rec.ic_tz_code is not null and p_timezone_enb
1789: then
1790: 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);
1791: 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);
1792: 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);
1793: 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);
1794: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1795: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1796: l_actual_start_date :=l_ic_actual_start_date;

Line 1793: 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);

1789: then
1790: 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);
1791: 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);
1792: 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);
1793: 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);
1794: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1795: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1796: l_actual_start_date :=l_ic_actual_start_date;
1797: l_tz_desc :=l_task_rec.tz_desc;

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

1790: 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);
1791: 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);
1792: 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);
1793: 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);
1794: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1795: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1796: l_actual_start_date :=l_ic_actual_start_date;
1797: l_tz_desc :=l_task_rec.tz_desc;
1798: end if;

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

1791: 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);
1792: 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);
1793: 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);
1794: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1795: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1796: l_actual_start_date :=l_ic_actual_start_date;
1797: l_tz_desc :=l_task_rec.tz_desc;
1798: end if;
1799:

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

1852: END IF;
1853: ELSE
1854: if p_inc_tz_code ='UTZ'and p_timezone_enb
1855: then
1856: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
1857: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
1858: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
1859: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
1860: else

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

1853: ELSE
1854: if p_inc_tz_code ='UTZ'and p_timezone_enb
1855: then
1856: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
1857: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
1858: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
1859: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
1860: else
1861: l_dc_planned_start_date :=l_task_rec.planned_start_date;

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

1854: if p_inc_tz_code ='UTZ'and p_timezone_enb
1855: then
1856: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
1857: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
1858: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
1859: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
1860: else
1861: l_dc_planned_start_date :=l_task_rec.planned_start_date;
1862: l_dc_planned_end_date :=l_task_rec.planned_end_date;

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

1855: then
1856: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
1857: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
1858: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
1859: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
1860: else
1861: l_dc_planned_start_date :=l_task_rec.planned_start_date;
1862: l_dc_planned_end_date :=l_task_rec.planned_end_date;
1863: l_dc_scheduled_start_date :=p_start_date;

Line 1869: 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);

1865: end if;
1866: l_scheduled_start_date :=l_dc_scheduled_start_date;
1867: 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)
1868: then
1869: 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);
1870: 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);
1871: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1872: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1873: l_scheduled_start_date :=l_ic_scheduled_start_date;

Line 1870: 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);

1866: l_scheduled_start_date :=l_dc_scheduled_start_date;
1867: 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)
1868: then
1869: 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);
1870: 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);
1871: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1872: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1873: l_scheduled_start_date :=l_ic_scheduled_start_date;
1874: l_tz_desc :=l_task_rec.tz_desc;

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

1867: 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)
1868: then
1869: 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);
1870: 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);
1871: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1872: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1873: l_scheduled_start_date :=l_ic_scheduled_start_date;
1874: l_tz_desc :=l_task_rec.tz_desc;
1875: elsif l_res_tz_cd is not null and p_timezone_enb

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

1868: then
1869: 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);
1870: 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);
1871: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
1872: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
1873: l_scheduled_start_date :=l_ic_scheduled_start_date;
1874: l_tz_desc :=l_task_rec.tz_desc;
1875: elsif l_res_tz_cd is not null and p_timezone_enb
1876: then

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

2615: THEN
2616:
2617: if sch_adv_tz ='UTZ' and p_timezone_enb
2618: then
2619: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
2620: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
2621: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,p_client_tz_code);
2622: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,p_client_tz_code);
2623: l_dc_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);

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

2616:
2617: if sch_adv_tz ='UTZ' and p_timezone_enb
2618: then
2619: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
2620: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
2621: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,p_client_tz_code);
2622: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,p_client_tz_code);
2623: l_dc_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
2624: l_dc_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);

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

2617: if sch_adv_tz ='UTZ' and p_timezone_enb
2618: then
2619: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
2620: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
2621: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,p_client_tz_code);
2622: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,p_client_tz_code);
2623: l_dc_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
2624: l_dc_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
2625: l_actual_start_date :=l_dc_actual_start_date;

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

2618: then
2619: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
2620: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
2621: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,p_client_tz_code);
2622: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,p_client_tz_code);
2623: l_dc_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
2624: l_dc_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
2625: l_actual_start_date :=l_dc_actual_start_date;
2626: if l_task_rec.ic_tz_code is not null and p_timezone_enb

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

2619: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
2620: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
2621: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,p_client_tz_code);
2622: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,p_client_tz_code);
2623: l_dc_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
2624: l_dc_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
2625: l_actual_start_date :=l_dc_actual_start_date;
2626: if l_task_rec.ic_tz_code is not null and p_timezone_enb
2627: then

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

2620: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
2621: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,p_client_tz_code);
2622: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,p_client_tz_code);
2623: l_dc_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
2624: l_dc_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
2625: l_actual_start_date :=l_dc_actual_start_date;
2626: if l_task_rec.ic_tz_code is not null and p_timezone_enb
2627: then
2628: 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 2628: 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);

2624: l_dc_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
2625: l_actual_start_date :=l_dc_actual_start_date;
2626: if l_task_rec.ic_tz_code is not null and p_timezone_enb
2627: then
2628: 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);
2629: 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);
2630: 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);
2631: 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);
2632: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);

Line 2629: 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);

2625: l_actual_start_date :=l_dc_actual_start_date;
2626: if l_task_rec.ic_tz_code is not null and p_timezone_enb
2627: then
2628: 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);
2629: 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);
2630: 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);
2631: 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);
2632: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
2633: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);

Line 2630: 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);

2626: if l_task_rec.ic_tz_code is not null and p_timezone_enb
2627: then
2628: 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);
2629: 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);
2630: 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);
2631: 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);
2632: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
2633: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
2634: l_actual_start_date :=l_ic_actual_start_date;

Line 2631: 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);

2627: then
2628: 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);
2629: 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);
2630: 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);
2631: 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);
2632: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
2633: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
2634: l_actual_start_date :=l_ic_actual_start_date;
2635: l_tz_desc :=l_task_rec.tz_desc;

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

2628: 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);
2629: 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);
2630: 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);
2631: 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);
2632: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
2633: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
2634: l_actual_start_date :=l_ic_actual_start_date;
2635: l_tz_desc :=l_task_rec.tz_desc;
2636: end if;

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

2629: 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);
2630: 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);
2631: 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);
2632: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
2633: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
2634: l_actual_start_date :=l_ic_actual_start_date;
2635: l_tz_desc :=l_task_rec.tz_desc;
2636: end if;
2637: elsif sch_adv_tz ='CTZ' and p_timezone_enb

Line 2649: 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);

2645:
2646: l_actual_start_date :=l_dc_actual_start_date;
2647: if l_task_rec.ic_tz_code is not null and p_timezone_enb
2648: then
2649: 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);
2650: 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);
2651: 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);
2652: 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);
2653: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);

Line 2650: 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);

2646: l_actual_start_date :=l_dc_actual_start_date;
2647: if l_task_rec.ic_tz_code is not null and p_timezone_enb
2648: then
2649: 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);
2650: 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);
2651: 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);
2652: 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);
2653: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
2654: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);

Line 2651: 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);

2647: if l_task_rec.ic_tz_code is not null and p_timezone_enb
2648: then
2649: 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);
2650: 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);
2651: 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);
2652: 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);
2653: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
2654: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
2655: l_actual_start_date :=l_ic_actual_start_date;

Line 2652: 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);

2648: then
2649: 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);
2650: 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);
2651: 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);
2652: 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);
2653: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
2654: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
2655: l_actual_start_date :=l_ic_actual_start_date;
2656: l_tz_desc :=l_task_rec.tz_desc;

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

2649: 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);
2650: 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);
2651: 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);
2652: 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);
2653: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
2654: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
2655: l_actual_start_date :=l_ic_actual_start_date;
2656: l_tz_desc :=l_task_rec.tz_desc;
2657: end if;

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

2650: 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);
2651: 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);
2652: 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);
2653: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
2654: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
2655: l_actual_start_date :=l_ic_actual_start_date;
2656: l_tz_desc :=l_task_rec.tz_desc;
2657: end if;
2658: elsif sch_adv_tz ='ITZ' and p_timezone_enb

Line 2660: 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);

2656: l_tz_desc :=l_task_rec.tz_desc;
2657: end if;
2658: elsif sch_adv_tz ='ITZ' and p_timezone_enb
2659: then
2660: 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);
2661: 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);
2662: 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);
2663: 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);
2664: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);

Line 2661: 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);

2657: end if;
2658: elsif sch_adv_tz ='ITZ' and p_timezone_enb
2659: then
2660: 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);
2661: 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);
2662: 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);
2663: 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);
2664: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
2665: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);

Line 2662: 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);

2658: elsif sch_adv_tz ='ITZ' and p_timezone_enb
2659: then
2660: 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);
2661: 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);
2662: 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);
2663: 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);
2664: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
2665: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
2666: l_actual_start_date :=l_ic_actual_start_date;

Line 2663: 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);

2659: then
2660: 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);
2661: 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);
2662: 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);
2663: 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);
2664: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
2665: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
2666: l_actual_start_date :=l_ic_actual_start_date;
2667: l_tz_desc := p_inc_tz_desc;

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

2660: 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);
2661: 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);
2662: 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);
2663: 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);
2664: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
2665: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
2666: l_actual_start_date :=l_ic_actual_start_date;
2667: l_tz_desc := p_inc_tz_desc;
2668: end if;

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

2661: 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);
2662: 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);
2663: 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);
2664: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
2665: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
2666: l_actual_start_date :=l_ic_actual_start_date;
2667: l_tz_desc := p_inc_tz_desc;
2668: end if;
2669:

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

2689: l_rec.travel_time := NVL(l_task_rec.actual_travel_duration, 0) || ' ' || l_uom;
2690: ELSE
2691: if sch_adv_tz ='UTZ' and p_timezone_enb
2692: then
2693: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
2694: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
2695: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
2696: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
2697: l_scheduled_start_date :=l_dc_scheduled_start_date;

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

2690: ELSE
2691: if sch_adv_tz ='UTZ' and p_timezone_enb
2692: then
2693: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
2694: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
2695: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
2696: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
2697: l_scheduled_start_date :=l_dc_scheduled_start_date;
2698: if l_task_rec.ic_tz_code is not null

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

2691: if sch_adv_tz ='UTZ' and p_timezone_enb
2692: then
2693: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
2694: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
2695: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
2696: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
2697: l_scheduled_start_date :=l_dc_scheduled_start_date;
2698: if l_task_rec.ic_tz_code is not null
2699: then

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

2692: then
2693: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
2694: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
2695: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
2696: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
2697: l_scheduled_start_date :=l_dc_scheduled_start_date;
2698: if l_task_rec.ic_tz_code is not null
2699: then
2700: 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 2700: 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);

2696: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
2697: l_scheduled_start_date :=l_dc_scheduled_start_date;
2698: if l_task_rec.ic_tz_code is not null
2699: then
2700: 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);
2701: 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);
2702: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
2703: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
2704: l_scheduled_start_date :=l_ic_scheduled_start_date;

Line 2701: 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);

2697: l_scheduled_start_date :=l_dc_scheduled_start_date;
2698: if l_task_rec.ic_tz_code is not null
2699: then
2700: 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);
2701: 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);
2702: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
2703: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
2704: l_scheduled_start_date :=l_ic_scheduled_start_date;
2705: l_tz_desc :=l_task_rec.tz_desc;

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

2698: if l_task_rec.ic_tz_code is not null
2699: then
2700: 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);
2701: 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);
2702: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
2703: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
2704: l_scheduled_start_date :=l_ic_scheduled_start_date;
2705: l_tz_desc :=l_task_rec.tz_desc;
2706: end if;

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

2699: then
2700: 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);
2701: 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);
2702: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
2703: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
2704: l_scheduled_start_date :=l_ic_scheduled_start_date;
2705: l_tz_desc :=l_task_rec.tz_desc;
2706: end if;
2707: elsif sch_adv_tz ='CTZ' and p_timezone_enb

Line 2716: 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);

2712: l_dc_scheduled_end_date :=p_end_date;
2713: l_scheduled_start_date :=l_dc_scheduled_start_date;
2714: if l_task_rec.ic_tz_code is not null
2715: then
2716: 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);
2717: 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);
2718: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
2719: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
2720: l_scheduled_start_date :=l_ic_scheduled_start_date;

Line 2717: 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);

2713: l_scheduled_start_date :=l_dc_scheduled_start_date;
2714: if l_task_rec.ic_tz_code is not null
2715: then
2716: 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);
2717: 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);
2718: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
2719: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
2720: l_scheduled_start_date :=l_ic_scheduled_start_date;
2721: l_tz_desc :=l_task_rec.tz_desc;

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

2714: if l_task_rec.ic_tz_code is not null
2715: then
2716: 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);
2717: 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);
2718: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
2719: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
2720: l_scheduled_start_date :=l_ic_scheduled_start_date;
2721: l_tz_desc :=l_task_rec.tz_desc;
2722: end if;

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

2715: then
2716: 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);
2717: 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);
2718: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
2719: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
2720: l_scheduled_start_date :=l_ic_scheduled_start_date;
2721: l_tz_desc :=l_task_rec.tz_desc;
2722: end if;
2723: elsif sch_adv_tz ='ITZ' and p_timezone_enb

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

2721: l_tz_desc :=l_task_rec.tz_desc;
2722: end if;
2723: elsif sch_adv_tz ='ITZ' and p_timezone_enb
2724: then
2725: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_inc_tz_code);
2726: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_inc_tz_code);
2727: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
2728: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
2729: l_scheduled_start_date :=l_ic_scheduled_start_date;

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

2722: end if;
2723: elsif sch_adv_tz ='ITZ' and p_timezone_enb
2724: then
2725: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_inc_tz_code);
2726: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_inc_tz_code);
2727: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
2728: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
2729: l_scheduled_start_date :=l_ic_scheduled_start_date;
2730: l_tz_desc := p_inc_tz_desc;

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

2723: elsif sch_adv_tz ='ITZ' and p_timezone_enb
2724: then
2725: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_inc_tz_code);
2726: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_inc_tz_code);
2727: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
2728: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
2729: l_scheduled_start_date :=l_ic_scheduled_start_date;
2730: l_tz_desc := p_inc_tz_desc;
2731: end if;

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

2724: then
2725: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_inc_tz_code);
2726: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_inc_tz_code);
2727: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
2728: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
2729: l_scheduled_start_date :=l_ic_scheduled_start_date;
2730: l_tz_desc := p_inc_tz_desc;
2731: end if;
2732: l_rec.departure_time:=(l_scheduled_start_date - (nvl(p_duration,0)/1440));

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

3349: THEN
3350:
3351: if sch_adv_tz ='UTZ' and p_timezone_enb
3352: then
3353: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
3354: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
3355: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,p_client_tz_code);
3356: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,p_client_tz_code);
3357: l_dc_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);

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

3350:
3351: if sch_adv_tz ='UTZ' and p_timezone_enb
3352: then
3353: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
3354: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
3355: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,p_client_tz_code);
3356: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,p_client_tz_code);
3357: l_dc_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
3358: l_dc_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);

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

3351: if sch_adv_tz ='UTZ' and p_timezone_enb
3352: then
3353: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
3354: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
3355: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,p_client_tz_code);
3356: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,p_client_tz_code);
3357: l_dc_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
3358: l_dc_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
3359: l_actual_start_date :=l_dc_actual_start_date;

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

3352: then
3353: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
3354: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
3355: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,p_client_tz_code);
3356: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,p_client_tz_code);
3357: l_dc_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
3358: l_dc_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
3359: l_actual_start_date :=l_dc_actual_start_date;
3360: if l_task_rec.ic_tz_code is not null and p_timezone_enb

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

3353: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
3354: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
3355: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,p_client_tz_code);
3356: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,p_client_tz_code);
3357: l_dc_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
3358: l_dc_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
3359: l_actual_start_date :=l_dc_actual_start_date;
3360: if l_task_rec.ic_tz_code is not null and p_timezone_enb
3361: then

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

3354: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
3355: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_start_date,p_server_tz_code,p_client_tz_code);
3356: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,p_client_tz_code);
3357: l_dc_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
3358: l_dc_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
3359: l_actual_start_date :=l_dc_actual_start_date;
3360: if l_task_rec.ic_tz_code is not null and p_timezone_enb
3361: then
3362: 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 3362: 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);

3358: l_dc_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
3359: l_actual_start_date :=l_dc_actual_start_date;
3360: if l_task_rec.ic_tz_code is not null and p_timezone_enb
3361: then
3362: 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);
3363: 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);
3364: 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);
3365: 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);
3366: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);

Line 3363: 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);

3359: l_actual_start_date :=l_dc_actual_start_date;
3360: if l_task_rec.ic_tz_code is not null and p_timezone_enb
3361: then
3362: 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);
3363: 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);
3364: 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);
3365: 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);
3366: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
3367: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);

Line 3364: 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);

3360: if l_task_rec.ic_tz_code is not null and p_timezone_enb
3361: then
3362: 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);
3363: 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);
3364: 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);
3365: 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);
3366: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
3367: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
3368: l_actual_start_date :=l_ic_actual_start_date;

Line 3365: 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);

3361: then
3362: 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);
3363: 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);
3364: 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);
3365: 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);
3366: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
3367: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
3368: l_actual_start_date :=l_ic_actual_start_date;
3369: l_tz_desc :=l_task_rec.tz_desc;

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

3362: 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);
3363: 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);
3364: 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);
3365: 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);
3366: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
3367: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
3368: l_actual_start_date :=l_ic_actual_start_date;
3369: l_tz_desc :=l_task_rec.tz_desc;
3370: end if;

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

3363: 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);
3364: 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);
3365: 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);
3366: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
3367: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
3368: l_actual_start_date :=l_ic_actual_start_date;
3369: l_tz_desc :=l_task_rec.tz_desc;
3370: end if;
3371: elsif sch_adv_tz ='CTZ' and p_timezone_enb

Line 3383: 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);

3379:
3380: l_actual_start_date :=l_dc_actual_start_date;
3381: if l_task_rec.ic_tz_code is not null and p_timezone_enb
3382: then
3383: 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);
3384: 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);
3385: 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);
3386: 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);
3387: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);

Line 3384: 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);

3380: l_actual_start_date :=l_dc_actual_start_date;
3381: if l_task_rec.ic_tz_code is not null and p_timezone_enb
3382: then
3383: 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);
3384: 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);
3385: 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);
3386: 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);
3387: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
3388: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);

Line 3385: 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);

3381: if l_task_rec.ic_tz_code is not null and p_timezone_enb
3382: then
3383: 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);
3384: 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);
3385: 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);
3386: 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);
3387: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
3388: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
3389: l_actual_start_date :=l_ic_actual_start_date;

Line 3386: 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);

3382: then
3383: 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);
3384: 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);
3385: 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);
3386: 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);
3387: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
3388: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
3389: l_actual_start_date :=l_ic_actual_start_date;
3390: l_tz_desc :=l_task_rec.tz_desc;

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

3383: 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);
3384: 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);
3385: 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);
3386: 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);
3387: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
3388: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
3389: l_actual_start_date :=l_ic_actual_start_date;
3390: l_tz_desc :=l_task_rec.tz_desc;
3391: end if;

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

3384: 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);
3385: 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);
3386: 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);
3387: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
3388: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
3389: l_actual_start_date :=l_ic_actual_start_date;
3390: l_tz_desc :=l_task_rec.tz_desc;
3391: end if;
3392: elsif sch_adv_tz ='ITZ' and p_timezone_enb

Line 3394: 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);

3390: l_tz_desc :=l_task_rec.tz_desc;
3391: end if;
3392: elsif sch_adv_tz ='ITZ' and p_timezone_enb
3393: then
3394: 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);
3395: 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);
3396: 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);
3397: 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);
3398: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);

Line 3395: 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);

3391: end if;
3392: elsif sch_adv_tz ='ITZ' and p_timezone_enb
3393: then
3394: 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);
3395: 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);
3396: 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);
3397: 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);
3398: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
3399: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);

Line 3396: 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);

3392: elsif sch_adv_tz ='ITZ' and p_timezone_enb
3393: then
3394: 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);
3395: 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);
3396: 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);
3397: 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);
3398: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
3399: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
3400: l_actual_start_date :=l_ic_actual_start_date;

Line 3397: 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);

3393: then
3394: 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);
3395: 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);
3396: 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);
3397: 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);
3398: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
3399: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
3400: l_actual_start_date :=l_ic_actual_start_date;
3401: l_tz_desc := p_inc_tz_desc;

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

3394: 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);
3395: 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);
3396: 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);
3397: 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);
3398: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
3399: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
3400: l_actual_start_date :=l_ic_actual_start_date;
3401: l_tz_desc := p_inc_tz_desc;
3402: end if;

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

3395: 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);
3396: 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);
3397: 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);
3398: l_ic_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
3399: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
3400: l_actual_start_date :=l_ic_actual_start_date;
3401: l_tz_desc := p_inc_tz_desc;
3402: end if;
3403:

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

3423: l_rec.travel_time := NVL(l_task_rec.actual_travel_duration, 0) || ' ' || l_uom;
3424: ELSE
3425: if sch_adv_tz ='UTZ' and p_timezone_enb
3426: then
3427: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
3428: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
3429: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
3430: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
3431: l_scheduled_start_date :=l_dc_scheduled_start_date;

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

3424: ELSE
3425: if sch_adv_tz ='UTZ' and p_timezone_enb
3426: then
3427: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
3428: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
3429: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
3430: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
3431: l_scheduled_start_date :=l_dc_scheduled_start_date;
3432: if l_task_rec.ic_tz_code is not null

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

3425: if sch_adv_tz ='UTZ' and p_timezone_enb
3426: then
3427: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
3428: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
3429: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
3430: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
3431: l_scheduled_start_date :=l_dc_scheduled_start_date;
3432: if l_task_rec.ic_tz_code is not null
3433: then

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

3426: then
3427: l_dc_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_client_tz_code);
3428: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
3429: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
3430: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
3431: l_scheduled_start_date :=l_dc_scheduled_start_date;
3432: if l_task_rec.ic_tz_code is not null
3433: then
3434: 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 3434: 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);

3430: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
3431: l_scheduled_start_date :=l_dc_scheduled_start_date;
3432: if l_task_rec.ic_tz_code is not null
3433: then
3434: 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);
3435: 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);
3436: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
3437: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
3438: l_scheduled_start_date :=l_ic_scheduled_start_date;

Line 3435: 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);

3431: l_scheduled_start_date :=l_dc_scheduled_start_date;
3432: if l_task_rec.ic_tz_code is not null
3433: then
3434: 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);
3435: 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);
3436: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
3437: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
3438: l_scheduled_start_date :=l_ic_scheduled_start_date;
3439: l_tz_desc :=l_task_rec.tz_desc;

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

3432: if l_task_rec.ic_tz_code is not null
3433: then
3434: 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);
3435: 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);
3436: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
3437: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
3438: l_scheduled_start_date :=l_ic_scheduled_start_date;
3439: l_tz_desc :=l_task_rec.tz_desc;
3440: end if;

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

3433: then
3434: 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);
3435: 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);
3436: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
3437: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
3438: l_scheduled_start_date :=l_ic_scheduled_start_date;
3439: l_tz_desc :=l_task_rec.tz_desc;
3440: end if;
3441: elsif sch_adv_tz ='CTZ' and p_timezone_enb

Line 3450: 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);

3446: l_dc_scheduled_end_date :=p_end_date;
3447: l_scheduled_start_date :=l_dc_scheduled_start_date;
3448: if l_task_rec.ic_tz_code is not null
3449: then
3450: 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);
3451: 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);
3452: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
3453: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
3454: l_scheduled_start_date :=l_ic_scheduled_start_date;

Line 3451: 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);

3447: l_scheduled_start_date :=l_dc_scheduled_start_date;
3448: if l_task_rec.ic_tz_code is not null
3449: then
3450: 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);
3451: 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);
3452: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
3453: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
3454: l_scheduled_start_date :=l_ic_scheduled_start_date;
3455: l_tz_desc :=l_task_rec.tz_desc;

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

3448: if l_task_rec.ic_tz_code is not null
3449: then
3450: 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);
3451: 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);
3452: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
3453: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
3454: l_scheduled_start_date :=l_ic_scheduled_start_date;
3455: l_tz_desc :=l_task_rec.tz_desc;
3456: end if;

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

3449: then
3450: 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);
3451: 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);
3452: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_task_rec.ic_tz_code);
3453: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
3454: l_scheduled_start_date :=l_ic_scheduled_start_date;
3455: l_tz_desc :=l_task_rec.tz_desc;
3456: end if;
3457: elsif sch_adv_tz ='ITZ' and p_timezone_enb

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

3455: l_tz_desc :=l_task_rec.tz_desc;
3456: end if;
3457: elsif sch_adv_tz ='ITZ' and p_timezone_enb
3458: then
3459: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_inc_tz_code);
3460: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_inc_tz_code);
3461: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
3462: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
3463: l_scheduled_start_date :=l_ic_scheduled_start_date;

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

3456: end if;
3457: elsif sch_adv_tz ='ITZ' and p_timezone_enb
3458: then
3459: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_inc_tz_code);
3460: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_inc_tz_code);
3461: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
3462: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
3463: l_scheduled_start_date :=l_ic_scheduled_start_date;
3464: l_tz_desc := p_inc_tz_desc;

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

3457: elsif sch_adv_tz ='ITZ' and p_timezone_enb
3458: then
3459: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_inc_tz_code);
3460: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_inc_tz_code);
3461: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
3462: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
3463: l_scheduled_start_date :=l_ic_scheduled_start_date;
3464: l_tz_desc := p_inc_tz_desc;
3465: end if;

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

3458: then
3459: l_ic_planned_start_date :=fnd_date.adjust_datetime(l_task_rec.planned_start_date,p_server_tz_code,p_inc_tz_code);
3460: l_ic_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_inc_tz_code);
3461: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
3462: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
3463: l_scheduled_start_date :=l_ic_scheduled_start_date;
3464: l_tz_desc := p_inc_tz_desc;
3465: end if;
3466: l_rec.departure_time:=(l_scheduled_start_date - (nvl(p_duration,0)/1440));

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

4105: if g_tz_enabled ='Y' and g_dflt_tz_for_sc='CTZ' and task_id.count > 0
4106: then
4107: FOR i IN task_id.FIRST .. task_id.LAST
4108: LOOP
4109: start_date(i) :=fnd_date.adjust_datetime(start_date(i),g_client_tz,g_server_tz );
4110: end_date(i) :=fnd_date.adjust_datetime(end_date(i) ,g_client_tz,g_server_tz);
4111: END LOOP;
4112: end if;
4113:

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

4106: then
4107: FOR i IN task_id.FIRST .. task_id.LAST
4108: LOOP
4109: start_date(i) :=fnd_date.adjust_datetime(start_date(i),g_client_tz,g_server_tz );
4110: end_date(i) :=fnd_date.adjust_datetime(end_date(i) ,g_client_tz,g_server_tz);
4111: END LOOP;
4112: end if;
4113:
4114: IF task_id.COUNT IS NULL THEN

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

4222: IF p_timezone_enb
4223: THEN
4224: IF sch_adv_tz ='ITZ'
4225: THEN
4226: l_ic_scheduled_start_date := fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
4227: l_ic_scheduled_end_date := fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
4228: l_scheduled_start := l_ic_scheduled_start_date;
4229: ELSIF sch_adv_tz = 'UTZ'
4230: THEN

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

4223: THEN
4224: IF sch_adv_tz ='ITZ'
4225: THEN
4226: l_ic_scheduled_start_date := fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
4227: l_ic_scheduled_end_date := fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
4228: l_scheduled_start := l_ic_scheduled_start_date;
4229: ELSIF sch_adv_tz = 'UTZ'
4230: THEN
4231: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);

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

4227: l_ic_scheduled_end_date := fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
4228: l_scheduled_start := l_ic_scheduled_start_date;
4229: ELSIF sch_adv_tz = 'UTZ'
4230: THEN
4231: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
4232: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
4233: l_scheduled_start :=l_dc_scheduled_start_date;
4234: IF p_inc_tz_code is not null and l_inc_tz_code is not null
4235: THEN

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

4228: l_scheduled_start := l_ic_scheduled_start_date;
4229: ELSIF sch_adv_tz = 'UTZ'
4230: THEN
4231: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
4232: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
4233: l_scheduled_start :=l_dc_scheduled_start_date;
4234: IF p_inc_tz_code is not null and l_inc_tz_code is not null
4235: THEN
4236: l_ic_scheduled_start_date := fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_inc_tz_code);

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

4232: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
4233: l_scheduled_start :=l_dc_scheduled_start_date;
4234: IF p_inc_tz_code is not null and l_inc_tz_code is not null
4235: THEN
4236: l_ic_scheduled_start_date := fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_inc_tz_code);
4237: l_ic_scheduled_end_date := fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_inc_tz_code);
4238: END IF;
4239: ELSE
4240: l_dc_scheduled_start_date := p_start_date;

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

4233: l_scheduled_start :=l_dc_scheduled_start_date;
4234: IF p_inc_tz_code is not null and l_inc_tz_code is not null
4235: THEN
4236: l_ic_scheduled_start_date := fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_inc_tz_code);
4237: l_ic_scheduled_end_date := fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_inc_tz_code);
4238: END IF;
4239: ELSE
4240: l_dc_scheduled_start_date := p_start_date;
4241: l_dc_scheduled_end_date := p_end_date;

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

4241: l_dc_scheduled_end_date := p_end_date;
4242: l_scheduled_start := l_dc_scheduled_start_date;
4243: IF p_inc_tz_code is not null and l_inc_tz_code is not null
4244: THEN
4245: l_ic_scheduled_start_date := fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_inc_tz_code);
4246: l_ic_scheduled_end_date := fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_inc_tz_code);
4247: END IF;
4248: END IF;
4249:

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

4242: l_scheduled_start := l_dc_scheduled_start_date;
4243: IF p_inc_tz_code is not null and l_inc_tz_code is not null
4244: THEN
4245: l_ic_scheduled_start_date := fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_inc_tz_code);
4246: l_ic_scheduled_end_date := fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_inc_tz_code);
4247: END IF;
4248: END IF;
4249:
4250: l_departure_time :=

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

5817: if g_tz_enabled ='Y' and g_dflt_tz_for_dc='CTZ' and p_trip_id.count > 0
5818: then
5819: FOR i IN p_trip_id.FIRST .. p_trip_id.LAST
5820: LOOP
5821: p_shift_start_date(i) :=fnd_date.adjust_datetime(p_shift_start_date(i),g_client_tz,g_server_tz );
5822: p_shift_end_date(i) :=fnd_date.adjust_datetime(p_shift_end_date(i) ,g_client_tz,g_server_tz);
5823: END LOOP;
5824: end if;
5825:

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

5818: then
5819: FOR i IN p_trip_id.FIRST .. p_trip_id.LAST
5820: LOOP
5821: p_shift_start_date(i) :=fnd_date.adjust_datetime(p_shift_start_date(i),g_client_tz,g_server_tz );
5822: p_shift_end_date(i) :=fnd_date.adjust_datetime(p_shift_end_date(i) ,g_client_tz,g_server_tz);
5823: END LOOP;
5824: end if;
5825:
5826: IF g_use_custom_chromatics

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

6037: END IF;
6038:
6039: IF g_tz_enabled ='Y' and g_dflt_tz_for_dc='CTZ'
6040: THEN
6041: p_vir_start_date(i) :=fnd_date.adjust_datetime(p_vir_start_date(i),g_client_tz,g_server_tz );
6042: p_vir_end_date(i) :=fnd_date.adjust_datetime(p_vir_end_date(i) ,g_client_tz,g_server_tz);
6043: END IF;
6044: END IF; -- l_shift_type
6045: END LOOP;

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

6038:
6039: IF g_tz_enabled ='Y' and g_dflt_tz_for_dc='CTZ'
6040: THEN
6041: p_vir_start_date(i) :=fnd_date.adjust_datetime(p_vir_start_date(i),g_client_tz,g_server_tz );
6042: p_vir_end_date(i) :=fnd_date.adjust_datetime(p_vir_end_date(i) ,g_client_tz,g_server_tz);
6043: END IF;
6044: END IF; -- l_shift_type
6045: END LOOP;
6046: END IF;

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

6550: END IF;
6551:
6552: IF g_tz_enabled ='Y' and g_dflt_tz_for_dc='CTZ'
6553: THEN
6554: real_start_date(i) :=fnd_date.adjust_datetime(real_start_date(i),g_client_tz,g_server_tz );
6555: real_end_date(i) :=fnd_date.adjust_datetime(real_end_date(i) ,g_client_tz,g_server_tz);
6556: END IF;
6557: END LOOP;
6558: END IF;

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

6551:
6552: IF g_tz_enabled ='Y' and g_dflt_tz_for_dc='CTZ'
6553: THEN
6554: real_start_date(i) :=fnd_date.adjust_datetime(real_start_date(i),g_client_tz,g_server_tz );
6555: real_end_date(i) :=fnd_date.adjust_datetime(real_end_date(i) ,g_client_tz,g_server_tz);
6556: END IF;
6557: END LOOP;
6558: END IF;
6559:

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

7786: IF trip_id.COUNT IS NOT NULL AND trip_id.COUNT > 0
7787: THEN
7788: FOR i IN trip_id.FIRST .. trip_id.LAST
7789: LOOP
7790: start_date(i) :=fnd_date.adjust_datetime(start_date(i),g_client_tz,g_server_tz );
7791: end_date(i) :=fnd_date.adjust_datetime(end_date(i) ,g_client_tz,g_server_tz);
7792: END LOOP;
7793: END IF;
7794: elsif g_tz_enabled ='Y' and sch_adv_tz='ITZ' and trip_id.count > 0

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

7787: THEN
7788: FOR i IN trip_id.FIRST .. trip_id.LAST
7789: LOOP
7790: start_date(i) :=fnd_date.adjust_datetime(start_date(i),g_client_tz,g_server_tz );
7791: end_date(i) :=fnd_date.adjust_datetime(end_date(i) ,g_client_tz,g_server_tz);
7792: END LOOP;
7793: END IF;
7794: elsif g_tz_enabled ='Y' and sch_adv_tz='ITZ' and trip_id.count > 0
7795: then

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

7796: IF trip_id.COUNT IS NOT NULL AND trip_id.COUNT > 0
7797: THEN
7798: FOR i IN trip_id.FIRST .. trip_id.LAST
7799: LOOP
7800: start_date(i) :=fnd_date.adjust_datetime(start_date(i),g_client_tz,inc_tz_code );
7801: end_date(i) :=fnd_date.adjust_datetime(end_date(i) ,g_client_tz,inc_tz_code);
7802: END LOOP;
7803: END IF;
7804: end if;

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

7797: THEN
7798: FOR i IN trip_id.FIRST .. trip_id.LAST
7799: LOOP
7800: start_date(i) :=fnd_date.adjust_datetime(start_date(i),g_client_tz,inc_tz_code );
7801: end_date(i) :=fnd_date.adjust_datetime(end_date(i) ,g_client_tz,inc_tz_code);
7802: END LOOP;
7803: END IF;
7804: end if;
7805:

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

7821: FOR i IN plan_task_key.first..plan_task_key.last
7822: LOOP
7823: IF g_tz_enabled ='Y' AND sch_adv_tz='CTZ'
7824: THEN
7825: plan_start_date(i):=fnd_date.adjust_datetime(plan_start_date(i),g_client_tz,g_server_tz );
7826: ELSIF g_tz_enabled ='Y' AND sch_adv_tz='ITZ'
7827: THEN
7828: plan_start_date(i):=fnd_date.adjust_datetime(plan_start_date(i),g_client_tz,inc_tz_code );
7829: END IF;

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

7824: THEN
7825: plan_start_date(i):=fnd_date.adjust_datetime(plan_start_date(i),g_client_tz,g_server_tz );
7826: ELSIF g_tz_enabled ='Y' AND sch_adv_tz='ITZ'
7827: THEN
7828: plan_start_date(i):=fnd_date.adjust_datetime(plan_start_date(i),g_client_tz,inc_tz_code );
7829: END IF;
7830: IF g_tz_enabled ='Y' AND sch_adv_tz='CTZ'
7831: THEN
7832: plan_end_date(i):=fnd_date.adjust_datetime(plan_end_date(i),g_client_tz,g_server_tz);

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

7828: plan_start_date(i):=fnd_date.adjust_datetime(plan_start_date(i),g_client_tz,inc_tz_code );
7829: END IF;
7830: IF g_tz_enabled ='Y' AND sch_adv_tz='CTZ'
7831: THEN
7832: plan_end_date(i):=fnd_date.adjust_datetime(plan_end_date(i),g_client_tz,g_server_tz);
7833: ELSIF g_tz_enabled ='Y' AND sch_adv_tz='ITZ'
7834: THEN
7835: plan_end_date(i):=fnd_date.adjust_datetime(plan_end_date(i),g_client_tz,inc_tz_code);
7836: END IF;

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

7831: THEN
7832: plan_end_date(i):=fnd_date.adjust_datetime(plan_end_date(i),g_client_tz,g_server_tz);
7833: ELSIF g_tz_enabled ='Y' AND sch_adv_tz='ITZ'
7834: THEN
7835: plan_end_date(i):=fnd_date.adjust_datetime(plan_end_date(i),g_client_tz,inc_tz_code);
7836: END IF;
7837: END LOOP;
7838: END IF;
7839:

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

8332: END IF;
8333:
8334: if g_tz_enabled ='Y' and sch_adv_tz='CTZ'
8335: then
8336: oth_real_start_date(i) :=fnd_date.adjust_datetime(oth_real_start_date(i),g_client_tz,g_server_tz );
8337: oth_real_end_date(i) :=fnd_date.adjust_datetime(oth_real_end_date(i) ,g_client_tz,g_server_tz);
8338: elsif g_tz_enabled ='Y' and sch_adv_tz='ITZ'
8339: then
8340: oth_real_start_date(i) :=fnd_date.adjust_datetime(oth_real_start_date(i),g_client_tz,inc_tz_code );

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

8333:
8334: if g_tz_enabled ='Y' and sch_adv_tz='CTZ'
8335: then
8336: oth_real_start_date(i) :=fnd_date.adjust_datetime(oth_real_start_date(i),g_client_tz,g_server_tz );
8337: oth_real_end_date(i) :=fnd_date.adjust_datetime(oth_real_end_date(i) ,g_client_tz,g_server_tz);
8338: elsif g_tz_enabled ='Y' and sch_adv_tz='ITZ'
8339: then
8340: oth_real_start_date(i) :=fnd_date.adjust_datetime(oth_real_start_date(i),g_client_tz,inc_tz_code );
8341: oth_real_end_date(i) :=fnd_date.adjust_datetime(oth_real_end_date(i) ,g_client_tz,inc_tz_code);

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

8336: oth_real_start_date(i) :=fnd_date.adjust_datetime(oth_real_start_date(i),g_client_tz,g_server_tz );
8337: oth_real_end_date(i) :=fnd_date.adjust_datetime(oth_real_end_date(i) ,g_client_tz,g_server_tz);
8338: elsif g_tz_enabled ='Y' and sch_adv_tz='ITZ'
8339: then
8340: oth_real_start_date(i) :=fnd_date.adjust_datetime(oth_real_start_date(i),g_client_tz,inc_tz_code );
8341: oth_real_end_date(i) :=fnd_date.adjust_datetime(oth_real_end_date(i) ,g_client_tz,inc_tz_code);
8342: end if;
8343: END LOOP;
8344: END IF;

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

8337: oth_real_end_date(i) :=fnd_date.adjust_datetime(oth_real_end_date(i) ,g_client_tz,g_server_tz);
8338: elsif g_tz_enabled ='Y' and sch_adv_tz='ITZ'
8339: then
8340: oth_real_start_date(i) :=fnd_date.adjust_datetime(oth_real_start_date(i),g_client_tz,inc_tz_code );
8341: oth_real_end_date(i) :=fnd_date.adjust_datetime(oth_real_end_date(i) ,g_client_tz,inc_tz_code);
8342: end if;
8343: END LOOP;
8344: END IF;
8345:

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

8531: END IF;--This end if is for g_label_on_task
8532:
8533: IF g_tz_enabled ='Y' AND sch_adv_tz='CTZ'
8534: THEN
8535: real_start_date(i) :=fnd_date.adjust_datetime(real_start_date(i),g_client_tz,g_server_tz );
8536: ELSIF g_tz_enabled ='Y' AND sch_adv_tz='ITZ'
8537: THEN
8538: real_start_date(i) :=fnd_date.adjust_datetime(real_start_date(i),g_client_tz,inc_tz_code );
8539: END IF;

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

8534: THEN
8535: real_start_date(i) :=fnd_date.adjust_datetime(real_start_date(i),g_client_tz,g_server_tz );
8536: ELSIF g_tz_enabled ='Y' AND sch_adv_tz='ITZ'
8537: THEN
8538: real_start_date(i) :=fnd_date.adjust_datetime(real_start_date(i),g_client_tz,inc_tz_code );
8539: END IF;
8540: IF g_tz_enabled ='Y' AND sch_adv_tz='CTZ'
8541: THEN
8542: real_end_date(i) :=fnd_date.adjust_datetime(real_end_date(i),g_client_tz,g_server_tz);

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

8538: real_start_date(i) :=fnd_date.adjust_datetime(real_start_date(i),g_client_tz,inc_tz_code );
8539: END IF;
8540: IF g_tz_enabled ='Y' AND sch_adv_tz='CTZ'
8541: THEN
8542: real_end_date(i) :=fnd_date.adjust_datetime(real_end_date(i),g_client_tz,g_server_tz);
8543: ELSIF g_tz_enabled ='Y' AND sch_adv_tz='ITZ'
8544: THEN
8545: real_end_date(i) :=fnd_date.adjust_datetime(real_end_date(i),g_client_tz,inc_tz_code);
8546: END IF;

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

8541: THEN
8542: real_end_date(i) :=fnd_date.adjust_datetime(real_end_date(i),g_client_tz,g_server_tz);
8543: ELSIF g_tz_enabled ='Y' AND sch_adv_tz='ITZ'
8544: THEN
8545: real_end_date(i) :=fnd_date.adjust_datetime(real_end_date(i),g_client_tz,inc_tz_code);
8546: END IF;
8547:
8548: IF nvl(l_task_depends,'N') ='Y'
8549: THEN