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.HR_PERSON_ABSENCE_API dependencies on FND_DATE

Line 1959: fnd_date.date_to_chardate(l_effective_start_date));

1955:
1956: fnd_message.set_name ('PAY', 'HR_6744_ABS_DET_ENTRY_PERIOD');
1957: /* Commented and added as a part of Bug#10239011 Starts
1958: fnd_message.set_token ('PERIOD_FROM',
1959: fnd_date.date_to_chardate(l_effective_start_date));
1960: fnd_message.set_token ('PERIOD_TO',
1961: fnd_date.date_to_chardate(l_effective_end_date)); */
1962: fnd_message.set_token ('PERIOD_FROM',
1963: fnd_date.date_to_chardate(l_effective_start_date, calendar_aware => FND_DATE.calendar_aware_alt));

Line 1961: fnd_date.date_to_chardate(l_effective_end_date)); */

1957: /* Commented and added as a part of Bug#10239011 Starts
1958: fnd_message.set_token ('PERIOD_FROM',
1959: fnd_date.date_to_chardate(l_effective_start_date));
1960: fnd_message.set_token ('PERIOD_TO',
1961: fnd_date.date_to_chardate(l_effective_end_date)); */
1962: fnd_message.set_token ('PERIOD_FROM',
1963: fnd_date.date_to_chardate(l_effective_start_date, calendar_aware => FND_DATE.calendar_aware_alt));
1964: fnd_message.set_token ('PERIOD_TO',
1965: fnd_date.date_to_chardate(l_effective_end_date, calendar_aware => FND_DATE.calendar_aware_alt));

Line 1963: fnd_date.date_to_chardate(l_effective_start_date, calendar_aware => FND_DATE.calendar_aware_alt));

1959: fnd_date.date_to_chardate(l_effective_start_date));
1960: fnd_message.set_token ('PERIOD_TO',
1961: fnd_date.date_to_chardate(l_effective_end_date)); */
1962: fnd_message.set_token ('PERIOD_FROM',
1963: fnd_date.date_to_chardate(l_effective_start_date, calendar_aware => FND_DATE.calendar_aware_alt));
1964: fnd_message.set_token ('PERIOD_TO',
1965: fnd_date.date_to_chardate(l_effective_end_date, calendar_aware => FND_DATE.calendar_aware_alt));
1966: /* Commented and added as a part of Bug#10239011 Ends */
1967: fnd_message.raise_error;

Line 1965: fnd_date.date_to_chardate(l_effective_end_date, calendar_aware => FND_DATE.calendar_aware_alt));

1961: fnd_date.date_to_chardate(l_effective_end_date)); */
1962: fnd_message.set_token ('PERIOD_FROM',
1963: fnd_date.date_to_chardate(l_effective_start_date, calendar_aware => FND_DATE.calendar_aware_alt));
1964: fnd_message.set_token ('PERIOD_TO',
1965: fnd_date.date_to_chardate(l_effective_end_date, calendar_aware => FND_DATE.calendar_aware_alt));
1966: /* Commented and added as a part of Bug#10239011 Ends */
1967: fnd_message.raise_error;
1968:
1969: elsif l_processing_type = 'N' then

Line 3454: l_day_start_time := fnd_date.date_to_canonical(l_schedule(l_idx).START_DATE_TIME);

3450:
3451: --l_day_start_time := TO_CHAR(l_schedule(l_idx).START_DATE_TIME,'DD-MM-YYYY HH24:MI');
3452: --l_day_end_time := TO_CHAR(l_schedule(l_idx).END_DATE_TIME,'DD-MM-YYYY HH24:MI');
3453:
3454: l_day_start_time := fnd_date.date_to_canonical(l_schedule(l_idx).START_DATE_TIME);
3455: l_day_end_time := fnd_date.date_to_canonical(l_schedule(l_idx).END_DATE_TIME);
3456:
3457: absence_records(i).transactionid := l_transactionid;
3458: absence_records(i).absence_type_id:=l_abs_type;

Line 3455: l_day_end_time := fnd_date.date_to_canonical(l_schedule(l_idx).END_DATE_TIME);

3451: --l_day_start_time := TO_CHAR(l_schedule(l_idx).START_DATE_TIME,'DD-MM-YYYY HH24:MI');
3452: --l_day_end_time := TO_CHAR(l_schedule(l_idx).END_DATE_TIME,'DD-MM-YYYY HH24:MI');
3453:
3454: l_day_start_time := fnd_date.date_to_canonical(l_schedule(l_idx).START_DATE_TIME);
3455: l_day_end_time := fnd_date.date_to_canonical(l_schedule(l_idx).END_DATE_TIME);
3456:
3457: absence_records(i).transactionid := l_transactionid;
3458: absence_records(i).absence_type_id:=l_abs_type;
3459: absence_records(i).element_type_id:=l_ele_type;

Line 3494: l_day_start_time := fnd_date.date_to_canonical(l_schedule(l_idx).START_DATE_TIME);

3490:
3491: --l_day_start_time := TO_CHAR(l_schedule(l_idx).START_DATE_TIME,'DD-MM-YYYY HH24:MI');
3492: --l_day_end_time := TO_CHAR(l_schedule(l_idx).END_DATE_TIME,'DD-MM-YYYY HH24:MI');
3493:
3494: l_day_start_time := fnd_date.date_to_canonical(l_schedule(l_idx).START_DATE_TIME);
3495: l_day_end_time := fnd_date.date_to_canonical(l_schedule(l_idx).END_DATE_TIME);
3496:
3497: absence_records(i).transactionid := l_transactionid;
3498: absence_records(i).absence_type_id:=l_abs_type;

Line 3495: l_day_end_time := fnd_date.date_to_canonical(l_schedule(l_idx).END_DATE_TIME);

3491: --l_day_start_time := TO_CHAR(l_schedule(l_idx).START_DATE_TIME,'DD-MM-YYYY HH24:MI');
3492: --l_day_end_time := TO_CHAR(l_schedule(l_idx).END_DATE_TIME,'DD-MM-YYYY HH24:MI');
3493:
3494: l_day_start_time := fnd_date.date_to_canonical(l_schedule(l_idx).START_DATE_TIME);
3495: l_day_end_time := fnd_date.date_to_canonical(l_schedule(l_idx).END_DATE_TIME);
3496:
3497: absence_records(i).transactionid := l_transactionid;
3498: absence_records(i).absence_type_id:=l_abs_type;
3499: absence_records(i).element_type_id:=l_ele_type;

Line 3588: absence_records(i).abs_startdate:= FND_DATE.DATE_TO_CANONICAL(l_start_date_new); -- changed for 8844454

3584: absence_records(i).transactionid := l_transactionid;
3585: absence_records(i).absence_type_id:=l_abs_type;
3586: absence_records(i).element_type_id:=l_ele_type;
3587: absence_records(i).absence_attendance_id:= l_absence_attendance_id;
3588: absence_records(i).abs_startdate:= FND_DATE.DATE_TO_CANONICAL(l_start_date_new); -- changed for 8844454
3589: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_end_date_new); -- changed for 8844454
3590: absence_records(i).modetype:='CreateMode';
3591: absence_records(i).PROGRAM_APPLICATION_ID :='800';
3592: absence_records(i).rec_start_date :=l_rec_start_date;

Line 3589: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_end_date_new); -- changed for 8844454

3585: absence_records(i).absence_type_id:=l_abs_type;
3586: absence_records(i).element_type_id:=l_ele_type;
3587: absence_records(i).absence_attendance_id:= l_absence_attendance_id;
3588: absence_records(i).abs_startdate:= FND_DATE.DATE_TO_CANONICAL(l_start_date_new); -- changed for 8844454
3589: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_end_date_new); -- changed for 8844454
3590: absence_records(i).modetype:='CreateMode';
3591: absence_records(i).PROGRAM_APPLICATION_ID :='800';
3592: absence_records(i).rec_start_date :=l_rec_start_date;
3593: absence_records(i).rec_end_date :=l_rec_end_date;

Line 3611: absence_records(i).abs_startdate:= FND_DATE.DATE_TO_CANONICAL(l_start_date_new); -- changed for 8844454

3607: absence_records(i).transactionid := l_transactionid;
3608: absence_records(i).absence_type_id:=l_abs_type;
3609: absence_records(i).element_type_id:=l_ele_type;
3610: absence_records(i).absence_attendance_id:= l_absence_attendance_id;
3611: absence_records(i).abs_startdate:= FND_DATE.DATE_TO_CANONICAL(l_start_date_new); -- changed for 8844454
3612: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_end_date_new); -- changed for 8844454
3613: absence_records(i).modetype:='CreateMode';
3614: absence_records(i).PROGRAM_APPLICATION_ID :='800';
3615: absence_records(i).rec_start_date :=l_rec_start_date;

Line 3612: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_end_date_new); -- changed for 8844454

3608: absence_records(i).absence_type_id:=l_abs_type;
3609: absence_records(i).element_type_id:=l_ele_type;
3610: absence_records(i).absence_attendance_id:= l_absence_attendance_id;
3611: absence_records(i).abs_startdate:= FND_DATE.DATE_TO_CANONICAL(l_start_date_new); -- changed for 8844454
3612: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_end_date_new); -- changed for 8844454
3613: absence_records(i).modetype:='CreateMode';
3614: absence_records(i).PROGRAM_APPLICATION_ID :='800';
3615: absence_records(i).rec_start_date :=l_rec_start_date;
3616: absence_records(i).rec_end_date :=l_rec_end_date;

Line 3639: absence_records(i).abs_startdate:= FND_DATE.DATE_TO_CANONICAL(l_start_date_new); -- changed for 8844454

3635: absence_records(i).transactionid := l_transactionid;
3636: absence_records(i).absence_type_id:=l_abs_type;
3637: absence_records(i).element_type_id:=l_ele_type;
3638: absence_records(i).absence_attendance_id:= l_absence_attendance_id;
3639: absence_records(i).abs_startdate:= FND_DATE.DATE_TO_CANONICAL(l_start_date_new); -- changed for 8844454
3640: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_end_date_new); -- changed for 8844454
3641: absence_records(i).modetype:='CreateMode';
3642: absence_records(i).PROGRAM_APPLICATION_ID :='800';
3643: absence_records(i).rec_start_date :=l_rec_start_date;

Line 3640: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_end_date_new); -- changed for 8844454

3636: absence_records(i).absence_type_id:=l_abs_type;
3637: absence_records(i).element_type_id:=l_ele_type;
3638: absence_records(i).absence_attendance_id:= l_absence_attendance_id;
3639: absence_records(i).abs_startdate:= FND_DATE.DATE_TO_CANONICAL(l_start_date_new); -- changed for 8844454
3640: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_end_date_new); -- changed for 8844454
3641: absence_records(i).modetype:='CreateMode';
3642: absence_records(i).PROGRAM_APPLICATION_ID :='800';
3643: absence_records(i).rec_start_date :=l_rec_start_date;
3644: absence_records(i).rec_end_date :=l_rec_end_date;

Line 3666: absence_records(i).abs_startdate:= FND_DATE.DATE_TO_CANONICAL(l_start_date_new); -- changed for 8844454

3662: absence_records(i).transactionid := l_transactionid;
3663: absence_records(i).absence_type_id:=l_abs_type;
3664: absence_records(i).element_type_id:=l_ele_type;
3665: absence_records(i).absence_attendance_id:= l_absence_attendance_id;
3666: absence_records(i).abs_startdate:= FND_DATE.DATE_TO_CANONICAL(l_start_date_new); -- changed for 8844454
3667: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_end_date_new); -- changed for 8844454
3668: absence_records(i).modetype:='CreateMode';
3669: absence_records(i).PROGRAM_APPLICATION_ID :='800';
3670: absence_records(i).rec_start_date :=l_rec_start_date;

Line 3667: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_end_date_new); -- changed for 8844454

3663: absence_records(i).absence_type_id:=l_abs_type;
3664: absence_records(i).element_type_id:=l_ele_type;
3665: absence_records(i).absence_attendance_id:= l_absence_attendance_id;
3666: absence_records(i).abs_startdate:= FND_DATE.DATE_TO_CANONICAL(l_start_date_new); -- changed for 8844454
3667: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_end_date_new); -- changed for 8844454
3668: absence_records(i).modetype:='CreateMode';
3669: absence_records(i).PROGRAM_APPLICATION_ID :='800';
3670: absence_records(i).rec_start_date :=l_rec_start_date;
3671: absence_records(i).rec_end_date :=l_rec_end_date;

Line 3744: absence_records_inv(j).abs_startdate := FND_DATE.DATE_TO_CANONICAL(l_start_date); -- changed for 8844454

3740: end if;
3741:
3742: j:=j+1;
3743: absence_records_inv(j).transactionid := l_transactionid;
3744: absence_records_inv(j).abs_startdate := FND_DATE.DATE_TO_CANONICAL(l_start_date); -- changed for 8844454
3745: absence_records_inv(j).abs_enddate := FND_DATE.DATE_TO_CANONICAL(l_end_date); -- changed for 8844454
3746:
3747:
3748: END; -- end of core sql

Line 3745: absence_records_inv(j).abs_enddate := FND_DATE.DATE_TO_CANONICAL(l_end_date); -- changed for 8844454

3741:
3742: j:=j+1;
3743: absence_records_inv(j).transactionid := l_transactionid;
3744: absence_records_inv(j).abs_startdate := FND_DATE.DATE_TO_CANONICAL(l_start_date); -- changed for 8844454
3745: absence_records_inv(j).abs_enddate := FND_DATE.DATE_TO_CANONICAL(l_end_date); -- changed for 8844454
3746:
3747:
3748: END; -- end of core sql
3749:

Line 3758: absence_records_inv(j).abs_startdate := FND_DATE.DATE_TO_CANONICAL(l_start_date); -- changed for 8844454

3754: end if;
3755:
3756: j:=j+1;
3757: absence_records_inv(j).transactionid := l_transactionid;
3758: absence_records_inv(j).abs_startdate := FND_DATE.DATE_TO_CANONICAL(l_start_date); -- changed for 8844454
3759: absence_records_inv(j).abs_enddate := FND_DATE.DATE_TO_CANONICAL(l_end_date); -- changed for 8844454
3760:
3761: -- assigning to old local vars so that rest of process remains same and we do not need to replace the
3762: -- variables with core ones.

Line 3759: absence_records_inv(j).abs_enddate := FND_DATE.DATE_TO_CANONICAL(l_end_date); -- changed for 8844454

3755:
3756: j:=j+1;
3757: absence_records_inv(j).transactionid := l_transactionid;
3758: absence_records_inv(j).abs_startdate := FND_DATE.DATE_TO_CANONICAL(l_start_date); -- changed for 8844454
3759: absence_records_inv(j).abs_enddate := FND_DATE.DATE_TO_CANONICAL(l_end_date); -- changed for 8844454
3760:
3761: -- assigning to old local vars so that rest of process remains same and we do not need to replace the
3762: -- variables with core ones.
3763: --

Line 3852: l_day_start_time := fnd_date.date_to_canonical(l_schedule(l_idx).START_DATE_TIME);

3848: --l_day_start_time := TO_CHAR(l_schedule(l_idx).START_DATE_TIME,'DD-MM-YYYY HH24:MI');
3849: --l_day_end_time := TO_CHAR(l_schedule(l_idx).END_DATE_TIME,'DD-MM-YYYY HH24:MI');
3850:
3851:
3852: l_day_start_time := fnd_date.date_to_canonical(l_schedule(l_idx).START_DATE_TIME);
3853: l_day_end_time := fnd_date.date_to_canonical(l_schedule(l_idx).END_DATE_TIME);
3854: absence_records(i).absence_type_id:=l_abs_type;
3855: absence_records(i).element_type_id:=l_ele_type;
3856: absence_records(i).abs_startdate:=l_day_start_time;

Line 3853: l_day_end_time := fnd_date.date_to_canonical(l_schedule(l_idx).END_DATE_TIME);

3849: --l_day_end_time := TO_CHAR(l_schedule(l_idx).END_DATE_TIME,'DD-MM-YYYY HH24:MI');
3850:
3851:
3852: l_day_start_time := fnd_date.date_to_canonical(l_schedule(l_idx).START_DATE_TIME);
3853: l_day_end_time := fnd_date.date_to_canonical(l_schedule(l_idx).END_DATE_TIME);
3854: absence_records(i).absence_type_id:=l_abs_type;
3855: absence_records(i).element_type_id:=l_ele_type;
3856: absence_records(i).abs_startdate:=l_day_start_time;
3857: absence_records(i).abs_enddate:=l_day_end_time;

Line 3890: l_day_start_time := fnd_date.date_to_canonical(l_schedule(l_idx).START_DATE_TIME);

3886:
3887: --l_day_start_time := TO_CHAR(l_schedule(l_idx).START_DATE_TIME,'DD-MM-YYYY HH24:MI');
3888: --l_day_end_time := TO_CHAR(l_schedule(l_idx).END_DATE_TIME,'DD-MM-YYYY HH24:MI');
3889:
3890: l_day_start_time := fnd_date.date_to_canonical(l_schedule(l_idx).START_DATE_TIME);
3891: l_day_end_time := fnd_date.date_to_canonical(l_schedule(l_idx).END_DATE_TIME);
3892: absence_records(i).absence_attendance_id:= l_absence_attendance_id;
3893: absence_records(i).absence_type_id:=l_abs_type;
3894: absence_records(i).element_type_id:=l_ele_type;

Line 3891: l_day_end_time := fnd_date.date_to_canonical(l_schedule(l_idx).END_DATE_TIME);

3887: --l_day_start_time := TO_CHAR(l_schedule(l_idx).START_DATE_TIME,'DD-MM-YYYY HH24:MI');
3888: --l_day_end_time := TO_CHAR(l_schedule(l_idx).END_DATE_TIME,'DD-MM-YYYY HH24:MI');
3889:
3890: l_day_start_time := fnd_date.date_to_canonical(l_schedule(l_idx).START_DATE_TIME);
3891: l_day_end_time := fnd_date.date_to_canonical(l_schedule(l_idx).END_DATE_TIME);
3892: absence_records(i).absence_attendance_id:= l_absence_attendance_id;
3893: absence_records(i).absence_type_id:=l_abs_type;
3894: absence_records(i).element_type_id:=l_ele_type;
3895: absence_records(i).abs_startdate:=l_day_start_time;

Line 3931: absence_records(i).abs_startdate:=FND_DATE.DATE_TO_CANONICAL(l_start_date); -- changed for 8844454

3927:
3928:
3929: absence_records(i).absence_type_id:=l_abs_type;
3930: absence_records(i).element_type_id:=l_ele_type;
3931: absence_records(i).abs_startdate:=FND_DATE.DATE_TO_CANONICAL(l_start_date); -- changed for 8844454
3932: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_start_date); -- changed for 8844454
3933: absence_records(i).absence_attendance_id:= l_absence_attendance_id;
3934: absence_records(i).PROGRAM_APPLICATION_ID :='800';
3935: absence_records(i).rec_start_date :=l_rec_start_date;

Line 3932: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_start_date); -- changed for 8844454

3928:
3929: absence_records(i).absence_type_id:=l_abs_type;
3930: absence_records(i).element_type_id:=l_ele_type;
3931: absence_records(i).abs_startdate:=FND_DATE.DATE_TO_CANONICAL(l_start_date); -- changed for 8844454
3932: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_start_date); -- changed for 8844454
3933: absence_records(i).absence_attendance_id:= l_absence_attendance_id;
3934: absence_records(i).PROGRAM_APPLICATION_ID :='800';
3935: absence_records(i).rec_start_date :=l_rec_start_date;
3936: absence_records(i).rec_end_date :=l_rec_end_date;

Line 3969: absence_records(i).abs_startdate:=FND_DATE.DATE_TO_CANONICAL(l_start_date_new); -- changed for 8844454

3965: l_end_date_new := TO_DATE(TO_CHAR(l_end_date,'DD-MM-YYYY')||' '||l_time_end_new,'DD-MM-YYYY HH24:MI');
3966:
3967: absence_records(i).absence_type_id:=l_abs_type;
3968: absence_records(i).element_type_id:=l_ele_type;
3969: absence_records(i).abs_startdate:=FND_DATE.DATE_TO_CANONICAL(l_start_date_new); -- changed for 8844454
3970: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_end_date_new); -- changed for 8844454
3971: absence_records(i).absence_attendance_id:= l_absence_attendance_id;
3972: absence_records(i).PROGRAM_APPLICATION_ID :='800';
3973: absence_records(i).rec_start_date :=l_rec_start_date;

Line 3970: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_end_date_new); -- changed for 8844454

3966:
3967: absence_records(i).absence_type_id:=l_abs_type;
3968: absence_records(i).element_type_id:=l_ele_type;
3969: absence_records(i).abs_startdate:=FND_DATE.DATE_TO_CANONICAL(l_start_date_new); -- changed for 8844454
3970: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_end_date_new); -- changed for 8844454
3971: absence_records(i).absence_attendance_id:= l_absence_attendance_id;
3972: absence_records(i).PROGRAM_APPLICATION_ID :='800';
3973: absence_records(i).rec_start_date :=l_rec_start_date;
3974: absence_records(i).rec_end_date :=l_rec_end_date;

Line 3990: absence_records(i).abs_startdate:=FND_DATE.DATE_TO_CANONICAL(l_start_date_new); -- changed for 8844454

3986: l_end_date_new := TO_DATE(TO_CHAR(l_start_date,'DD-MM-YYYY')||' '||l_time_end_new,'DD-MM-YYYY HH24:MI');
3987:
3988: absence_records(i).absence_type_id:=l_abs_type;
3989: absence_records(i).element_type_id:=l_ele_type;
3990: absence_records(i).abs_startdate:=FND_DATE.DATE_TO_CANONICAL(l_start_date_new); -- changed for 8844454
3991: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_end_date_new); -- changed for 8844454
3992: absence_records(i).absence_attendance_id:= l_absence_attendance_id;
3993: absence_records(i).PROGRAM_APPLICATION_ID :='800';
3994: absence_records(i).rec_start_date :=l_rec_start_date;

Line 3991: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_end_date_new); -- changed for 8844454

3987:
3988: absence_records(i).absence_type_id:=l_abs_type;
3989: absence_records(i).element_type_id:=l_ele_type;
3990: absence_records(i).abs_startdate:=FND_DATE.DATE_TO_CANONICAL(l_start_date_new); -- changed for 8844454
3991: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_end_date_new); -- changed for 8844454
3992: absence_records(i).absence_attendance_id:= l_absence_attendance_id;
3993: absence_records(i).PROGRAM_APPLICATION_ID :='800';
3994: absence_records(i).rec_start_date :=l_rec_start_date;
3995: absence_records(i).rec_end_date :=l_rec_end_date;

Line 4016: absence_records(i).abs_startdate:=FND_DATE.DATE_TO_CANONICAL(l_start_date_new); -- changed for 8844454

4012: l_end_date_new := TO_DATE(TO_CHAR(l_start_date,'DD-MM-YYYY')||' '||l_time_end_new,'DD-MM-YYYY HH24:MI');
4013:
4014: absence_records(i).absence_type_id:=l_abs_type;
4015: absence_records(i).element_type_id:=l_ele_type;
4016: absence_records(i).abs_startdate:=FND_DATE.DATE_TO_CANONICAL(l_start_date_new); -- changed for 8844454
4017: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_end_date_new); -- changed for 8844454
4018: absence_records(i).absence_attendance_id:= l_absence_attendance_id;
4019: absence_records(i).PROGRAM_APPLICATION_ID :='800';
4020: absence_records(i).rec_start_date :=l_rec_start_date;

Line 4017: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_end_date_new); -- changed for 8844454

4013:
4014: absence_records(i).absence_type_id:=l_abs_type;
4015: absence_records(i).element_type_id:=l_ele_type;
4016: absence_records(i).abs_startdate:=FND_DATE.DATE_TO_CANONICAL(l_start_date_new); -- changed for 8844454
4017: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_end_date_new); -- changed for 8844454
4018: absence_records(i).absence_attendance_id:= l_absence_attendance_id;
4019: absence_records(i).PROGRAM_APPLICATION_ID :='800';
4020: absence_records(i).rec_start_date :=l_rec_start_date;
4021: absence_records(i).rec_end_date :=l_rec_end_date;

Line 4040: absence_records(i).abs_startdate:=FND_DATE.DATE_TO_CANONICAL(l_start_date_new); -- changed for 8844454

4036:
4037:
4038: absence_records(i).absence_type_id:=l_abs_type;
4039: absence_records(i).element_type_id:=l_ele_type;
4040: absence_records(i).abs_startdate:=FND_DATE.DATE_TO_CANONICAL(l_start_date_new); -- changed for 8844454
4041: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_end_date_new); -- changed for 8844454
4042: absence_records(i).absence_attendance_id:= l_absence_attendance_id;
4043: absence_records(i).PROGRAM_APPLICATION_ID :='800';
4044: absence_records(i).rec_start_date :=l_rec_start_date;

Line 4041: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_end_date_new); -- changed for 8844454

4037:
4038: absence_records(i).absence_type_id:=l_abs_type;
4039: absence_records(i).element_type_id:=l_ele_type;
4040: absence_records(i).abs_startdate:=FND_DATE.DATE_TO_CANONICAL(l_start_date_new); -- changed for 8844454
4041: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_end_date_new); -- changed for 8844454
4042: absence_records(i).absence_attendance_id:= l_absence_attendance_id;
4043: absence_records(i).PROGRAM_APPLICATION_ID :='800';
4044: absence_records(i).rec_start_date :=l_rec_start_date;
4045: absence_records(i).rec_end_date :=l_rec_end_date;

Line 4171: l_day_start_time := fnd_date.date_to_canonical(l_schedule(l_idx).START_DATE_TIME);

4167:
4168: --l_day_start_time := TO_CHAR(l_schedule(l_idx).START_DATE_TIME,'DD-MM-YYYY HH24:MI');
4169: --l_day_end_time := TO_CHAR(l_schedule(l_idx).END_DATE_TIME,'DD-MM-YYYY HH24:MI');
4170:
4171: l_day_start_time := fnd_date.date_to_canonical(l_schedule(l_idx).START_DATE_TIME);
4172: l_day_end_time := fnd_date.date_to_canonical(l_schedule(l_idx).END_DATE_TIME);
4173:
4174: absence_records(i).transactionid := l_transactionid;
4175: absence_records(i).absence_type_id:=l_abs_type;

Line 4172: l_day_end_time := fnd_date.date_to_canonical(l_schedule(l_idx).END_DATE_TIME);

4168: --l_day_start_time := TO_CHAR(l_schedule(l_idx).START_DATE_TIME,'DD-MM-YYYY HH24:MI');
4169: --l_day_end_time := TO_CHAR(l_schedule(l_idx).END_DATE_TIME,'DD-MM-YYYY HH24:MI');
4170:
4171: l_day_start_time := fnd_date.date_to_canonical(l_schedule(l_idx).START_DATE_TIME);
4172: l_day_end_time := fnd_date.date_to_canonical(l_schedule(l_idx).END_DATE_TIME);
4173:
4174: absence_records(i).transactionid := l_transactionid;
4175: absence_records(i).absence_type_id:=l_abs_type;
4176: absence_records(i).element_type_id:=l_ele_type;

Line 4211: l_day_start_time := fnd_date.date_to_canonical(l_schedule(l_idx).START_DATE_TIME);

4207:
4208: --l_day_start_time := TO_CHAR(l_schedule(l_idx).START_DATE_TIME,'DD-MM-YYYY HH24:MI');
4209: --l_day_end_time := TO_CHAR(l_schedule(l_idx).END_DATE_TIME,'DD-MM-YYYY HH24:MI');
4210:
4211: l_day_start_time := fnd_date.date_to_canonical(l_schedule(l_idx).START_DATE_TIME);
4212: l_day_end_time := fnd_date.date_to_canonical(l_schedule(l_idx).END_DATE_TIME);
4213:
4214: absence_records(i).transactionid := l_transactionid;
4215: absence_records(i).absence_type_id:=l_abs_type;

Line 4212: l_day_end_time := fnd_date.date_to_canonical(l_schedule(l_idx).END_DATE_TIME);

4208: --l_day_start_time := TO_CHAR(l_schedule(l_idx).START_DATE_TIME,'DD-MM-YYYY HH24:MI');
4209: --l_day_end_time := TO_CHAR(l_schedule(l_idx).END_DATE_TIME,'DD-MM-YYYY HH24:MI');
4210:
4211: l_day_start_time := fnd_date.date_to_canonical(l_schedule(l_idx).START_DATE_TIME);
4212: l_day_end_time := fnd_date.date_to_canonical(l_schedule(l_idx).END_DATE_TIME);
4213:
4214: absence_records(i).transactionid := l_transactionid;
4215: absence_records(i).absence_type_id:=l_abs_type;
4216: absence_records(i).element_type_id:=l_ele_type;

Line 4256: absence_records(i).abs_startdate:=FND_DATE.DATE_TO_CANONICAL(l_start_date); -- changed for 8844454

4252:
4253: absence_records(i).transactionid := l_transactionid;
4254: absence_records(i).absence_type_id:=l_abs_type;
4255: absence_records(i).element_type_id:=l_ele_type;
4256: absence_records(i).abs_startdate:=FND_DATE.DATE_TO_CANONICAL(l_start_date); -- changed for 8844454
4257: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_start_date); -- changed for 8844454
4258: absence_records(i).modetype:='UpdateMode';
4259: absence_records(i).absence_attendance_id:= l_absence_attendance_id;
4260: absence_records(i).PROGRAM_APPLICATION_ID :='800';

Line 4257: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_start_date); -- changed for 8844454

4253: absence_records(i).transactionid := l_transactionid;
4254: absence_records(i).absence_type_id:=l_abs_type;
4255: absence_records(i).element_type_id:=l_ele_type;
4256: absence_records(i).abs_startdate:=FND_DATE.DATE_TO_CANONICAL(l_start_date); -- changed for 8844454
4257: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_start_date); -- changed for 8844454
4258: absence_records(i).modetype:='UpdateMode';
4259: absence_records(i).absence_attendance_id:= l_absence_attendance_id;
4260: absence_records(i).PROGRAM_APPLICATION_ID :='800';
4261: absence_records(i).rec_start_date :=l_rec_start_date;

Line 4297: absence_records(i).abs_startdate:=FND_DATE.DATE_TO_CANONICAL(l_start_date_new); -- changed for 8844454

4293:
4294: absence_records(i).transactionid := l_transactionid;
4295: absence_records(i).absence_type_id:=l_abs_type;
4296: absence_records(i).element_type_id:=l_ele_type;
4297: absence_records(i).abs_startdate:=FND_DATE.DATE_TO_CANONICAL(l_start_date_new); -- changed for 8844454
4298: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_end_date_new); -- changed for 8844454
4299: absence_records(i).modetype:='UpdateMode';
4300: absence_records(i).absence_attendance_id:= l_absence_attendance_id;
4301: absence_records(i).PROGRAM_APPLICATION_ID :='800';

Line 4298: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_end_date_new); -- changed for 8844454

4294: absence_records(i).transactionid := l_transactionid;
4295: absence_records(i).absence_type_id:=l_abs_type;
4296: absence_records(i).element_type_id:=l_ele_type;
4297: absence_records(i).abs_startdate:=FND_DATE.DATE_TO_CANONICAL(l_start_date_new); -- changed for 8844454
4298: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_end_date_new); -- changed for 8844454
4299: absence_records(i).modetype:='UpdateMode';
4300: absence_records(i).absence_attendance_id:= l_absence_attendance_id;
4301: absence_records(i).PROGRAM_APPLICATION_ID :='800';
4302: absence_records(i).rec_start_date :=l_rec_start_date;

Line 4321: absence_records(i).abs_startdate:=FND_DATE.DATE_TO_CANONICAL(l_start_date_new); -- changed for 8844454

4317:
4318: absence_records(i).transactionid := l_transactionid;
4319: absence_records(i).absence_type_id:=l_abs_type;
4320: absence_records(i).element_type_id:=l_ele_type;
4321: absence_records(i).abs_startdate:=FND_DATE.DATE_TO_CANONICAL(l_start_date_new); -- changed for 8844454
4322: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_end_date_new); -- changed for 8844454
4323: absence_records(i).modetype:='UpdateMode';
4324: absence_records(i).absence_attendance_id:= l_absence_attendance_id;
4325: absence_records(i).PROGRAM_APPLICATION_ID :='800';

Line 4322: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_end_date_new); -- changed for 8844454

4318: absence_records(i).transactionid := l_transactionid;
4319: absence_records(i).absence_type_id:=l_abs_type;
4320: absence_records(i).element_type_id:=l_ele_type;
4321: absence_records(i).abs_startdate:=FND_DATE.DATE_TO_CANONICAL(l_start_date_new); -- changed for 8844454
4322: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_end_date_new); -- changed for 8844454
4323: absence_records(i).modetype:='UpdateMode';
4324: absence_records(i).absence_attendance_id:= l_absence_attendance_id;
4325: absence_records(i).PROGRAM_APPLICATION_ID :='800';
4326: absence_records(i).rec_start_date :=l_rec_start_date;

Line 4350: absence_records(i).abs_startdate:=FND_DATE.DATE_TO_CANONICAL(l_start_date_new); -- changed for 8844454

4346:
4347: absence_records(i).transactionid := l_transactionid;
4348: absence_records(i).absence_type_id:=l_abs_type;
4349: absence_records(i).element_type_id:=l_ele_type;
4350: absence_records(i).abs_startdate:=FND_DATE.DATE_TO_CANONICAL(l_start_date_new); -- changed for 8844454
4351: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_end_date_new); -- changed for 8844454
4352: absence_records(i).modetype:='UpdateMode';
4353: absence_records(i).absence_attendance_id:= l_absence_attendance_id;
4354: absence_records(i).PROGRAM_APPLICATION_ID :='800';

Line 4351: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_end_date_new); -- changed for 8844454

4347: absence_records(i).transactionid := l_transactionid;
4348: absence_records(i).absence_type_id:=l_abs_type;
4349: absence_records(i).element_type_id:=l_ele_type;
4350: absence_records(i).abs_startdate:=FND_DATE.DATE_TO_CANONICAL(l_start_date_new); -- changed for 8844454
4351: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_end_date_new); -- changed for 8844454
4352: absence_records(i).modetype:='UpdateMode';
4353: absence_records(i).absence_attendance_id:= l_absence_attendance_id;
4354: absence_records(i).PROGRAM_APPLICATION_ID :='800';
4355: absence_records(i).rec_start_date :=l_rec_start_date;

Line 4375: absence_records(i).abs_startdate:=FND_DATE.DATE_TO_CANONICAL(l_start_date_new); -- changed for 8844454

4371:
4372: absence_records(i).transactionid := l_transactionid;
4373: absence_records(i).absence_type_id:=l_abs_type;
4374: absence_records(i).element_type_id:=l_ele_type;
4375: absence_records(i).abs_startdate:=FND_DATE.DATE_TO_CANONICAL(l_start_date_new); -- changed for 8844454
4376: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_end_date_new); -- changed for 8844454
4377: absence_records(i).modetype:='UpdateMode';
4378: absence_records(i).absence_attendance_id:= l_absence_attendance_id;
4379: absence_records(i).PROGRAM_APPLICATION_ID :='800';

Line 4376: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_end_date_new); -- changed for 8844454

4372: absence_records(i).transactionid := l_transactionid;
4373: absence_records(i).absence_type_id:=l_abs_type;
4374: absence_records(i).element_type_id:=l_ele_type;
4375: absence_records(i).abs_startdate:=FND_DATE.DATE_TO_CANONICAL(l_start_date_new); -- changed for 8844454
4376: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_end_date_new); -- changed for 8844454
4377: absence_records(i).modetype:='UpdateMode';
4378: absence_records(i).absence_attendance_id:= l_absence_attendance_id;
4379: absence_records(i).PROGRAM_APPLICATION_ID :='800';
4380: absence_records(i).rec_start_date :=l_rec_start_date;

Line 4516: l_day_start_time := fnd_date.date_to_canonical(l_schedule(l_idx).START_DATE_TIME);

4512:
4513: --l_day_start_time := TO_CHAR(l_schedule(l_idx).START_DATE_TIME,'DD-MM-YYYY HH24:MI');
4514: --l_day_end_time := TO_CHAR(l_schedule(l_idx).END_DATE_TIME,'DD-MM-YYYY HH24:MI');
4515:
4516: l_day_start_time := fnd_date.date_to_canonical(l_schedule(l_idx).START_DATE_TIME);
4517: l_day_end_time := fnd_date.date_to_canonical(l_schedule(l_idx).END_DATE_TIME);
4518:
4519: absence_records(i).absence_type_id:=l_abs_type;
4520: absence_records(i).element_type_id:=l_ele_type;

Line 4517: l_day_end_time := fnd_date.date_to_canonical(l_schedule(l_idx).END_DATE_TIME);

4513: --l_day_start_time := TO_CHAR(l_schedule(l_idx).START_DATE_TIME,'DD-MM-YYYY HH24:MI');
4514: --l_day_end_time := TO_CHAR(l_schedule(l_idx).END_DATE_TIME,'DD-MM-YYYY HH24:MI');
4515:
4516: l_day_start_time := fnd_date.date_to_canonical(l_schedule(l_idx).START_DATE_TIME);
4517: l_day_end_time := fnd_date.date_to_canonical(l_schedule(l_idx).END_DATE_TIME);
4518:
4519: absence_records(i).absence_type_id:=l_abs_type;
4520: absence_records(i).element_type_id:=l_ele_type;
4521: absence_records(i).abs_startdate:=l_day_start_time;

Line 4555: l_day_start_time := fnd_date.date_to_canonical(l_schedule(l_idx).START_DATE_TIME);

4551:
4552: -- l_day_start_time := TO_CHAR(l_schedule(l_idx).START_DATE_TIME,'DD-MM-YYYY HH24:MI');
4553: -- l_day_end_time := TO_CHAR(l_schedule(l_idx).END_DATE_TIME,'DD-MM-YYYY HH24:MI');
4554:
4555: l_day_start_time := fnd_date.date_to_canonical(l_schedule(l_idx).START_DATE_TIME);
4556: l_day_end_time := fnd_date.date_to_canonical(l_schedule(l_idx).END_DATE_TIME);
4557:
4558:
4559:

Line 4556: l_day_end_time := fnd_date.date_to_canonical(l_schedule(l_idx).END_DATE_TIME);

4552: -- l_day_start_time := TO_CHAR(l_schedule(l_idx).START_DATE_TIME,'DD-MM-YYYY HH24:MI');
4553: -- l_day_end_time := TO_CHAR(l_schedule(l_idx).END_DATE_TIME,'DD-MM-YYYY HH24:MI');
4554:
4555: l_day_start_time := fnd_date.date_to_canonical(l_schedule(l_idx).START_DATE_TIME);
4556: l_day_end_time := fnd_date.date_to_canonical(l_schedule(l_idx).END_DATE_TIME);
4557:
4558:
4559:
4560: absence_records(i).absence_type_id:=l_abs_type;

Line 4602: absence_records(i).abs_startdate:=FND_DATE.DATE_TO_CANONICAL(l_start_date); -- changed for 8844454

4598:
4599:
4600: absence_records(i).absence_type_id:=l_abs_type;
4601: absence_records(i).element_type_id:=l_ele_type;
4602: absence_records(i).abs_startdate:=FND_DATE.DATE_TO_CANONICAL(l_start_date); -- changed for 8844454
4603: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_start_date); -- changed for 8844454
4604: absence_records(i).absence_attendance_id:= l_absence_attendance_id;
4605: absence_records(i).PROGRAM_APPLICATION_ID :=l_program_application_id;
4606: absence_records(i).rec_start_date :=l_rec_start_date;

Line 4603: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_start_date); -- changed for 8844454

4599:
4600: absence_records(i).absence_type_id:=l_abs_type;
4601: absence_records(i).element_type_id:=l_ele_type;
4602: absence_records(i).abs_startdate:=FND_DATE.DATE_TO_CANONICAL(l_start_date); -- changed for 8844454
4603: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_start_date); -- changed for 8844454
4604: absence_records(i).absence_attendance_id:= l_absence_attendance_id;
4605: absence_records(i).PROGRAM_APPLICATION_ID :=l_program_application_id;
4606: absence_records(i).rec_start_date :=l_rec_start_date;
4607: absence_records(i).rec_end_date :=l_rec_end_date;

Line 4643: absence_records(i).abs_startdate:=FND_DATE.DATE_TO_CANONICAL(l_start_date_new); -- changed for 8844454

4639:
4640:
4641: absence_records(i).absence_type_id:=l_abs_type;
4642: absence_records(i).element_type_id:=l_ele_type;
4643: absence_records(i).abs_startdate:=FND_DATE.DATE_TO_CANONICAL(l_start_date_new); -- changed for 8844454
4644: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_end_date_new); -- changed for 8844454
4645: absence_records(i).absence_attendance_id:= l_absence_attendance_id;
4646: absence_records(i).PROGRAM_APPLICATION_ID :=l_program_application_id;
4647: absence_records(i).rec_start_date :=l_rec_start_date;

Line 4644: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_end_date_new); -- changed for 8844454

4640:
4641: absence_records(i).absence_type_id:=l_abs_type;
4642: absence_records(i).element_type_id:=l_ele_type;
4643: absence_records(i).abs_startdate:=FND_DATE.DATE_TO_CANONICAL(l_start_date_new); -- changed for 8844454
4644: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_end_date_new); -- changed for 8844454
4645: absence_records(i).absence_attendance_id:= l_absence_attendance_id;
4646: absence_records(i).PROGRAM_APPLICATION_ID :=l_program_application_id;
4647: absence_records(i).rec_start_date :=l_rec_start_date;
4648: absence_records(i).rec_end_date :=l_rec_end_date;

Line 4666: absence_records(i).abs_startdate:=FND_DATE.DATE_TO_CANONICAL(l_start_date_new); -- changed for 8844454

4662:
4663:
4664: absence_records(i).absence_type_id:=l_abs_type;
4665: absence_records(i).element_type_id:=l_ele_type;
4666: absence_records(i).abs_startdate:=FND_DATE.DATE_TO_CANONICAL(l_start_date_new); -- changed for 8844454
4667: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_end_date_new); -- changed for 8844454
4668: absence_records(i).absence_attendance_id:= l_absence_attendance_id;
4669: absence_records(i).PROGRAM_APPLICATION_ID :=l_program_application_id;
4670: absence_records(i).rec_start_date :=l_rec_start_date;

Line 4667: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_end_date_new); -- changed for 8844454

4663:
4664: absence_records(i).absence_type_id:=l_abs_type;
4665: absence_records(i).element_type_id:=l_ele_type;
4666: absence_records(i).abs_startdate:=FND_DATE.DATE_TO_CANONICAL(l_start_date_new); -- changed for 8844454
4667: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_end_date_new); -- changed for 8844454
4668: absence_records(i).absence_attendance_id:= l_absence_attendance_id;
4669: absence_records(i).PROGRAM_APPLICATION_ID :=l_program_application_id;
4670: absence_records(i).rec_start_date :=l_rec_start_date;
4671: absence_records(i).rec_end_date :=l_rec_end_date;

Line 4694: absence_records(i).abs_startdate:=FND_DATE.DATE_TO_CANONICAL(l_start_date_new); -- changed for 8844454

4690:
4691:
4692: absence_records(i).absence_type_id:=l_abs_type;
4693: absence_records(i).element_type_id:=l_ele_type;
4694: absence_records(i).abs_startdate:=FND_DATE.DATE_TO_CANONICAL(l_start_date_new); -- changed for 8844454
4695: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_end_date_new); -- changed for 8844454
4696: absence_records(i).absence_attendance_id:= l_absence_attendance_id;
4697: absence_records(i).PROGRAM_APPLICATION_ID :=l_program_application_id;
4698: absence_records(i).rec_start_date :=l_rec_start_date;

Line 4695: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_end_date_new); -- changed for 8844454

4691:
4692: absence_records(i).absence_type_id:=l_abs_type;
4693: absence_records(i).element_type_id:=l_ele_type;
4694: absence_records(i).abs_startdate:=FND_DATE.DATE_TO_CANONICAL(l_start_date_new); -- changed for 8844454
4695: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_end_date_new); -- changed for 8844454
4696: absence_records(i).absence_attendance_id:= l_absence_attendance_id;
4697: absence_records(i).PROGRAM_APPLICATION_ID :=l_program_application_id;
4698: absence_records(i).rec_start_date :=l_rec_start_date;
4699: absence_records(i).rec_end_date :=l_rec_end_date;

Line 4718: absence_records(i).abs_startdate:=FND_DATE.DATE_TO_CANONICAL(l_start_date_new); -- changed for 8844454

4714:
4715:
4716: absence_records(i).absence_type_id:=l_abs_type;
4717: absence_records(i).element_type_id:=l_ele_type;
4718: absence_records(i).abs_startdate:=FND_DATE.DATE_TO_CANONICAL(l_start_date_new); -- changed for 8844454
4719: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_end_date_new); -- changed for 8844454
4720: absence_records(i).absence_attendance_id:= l_absence_attendance_id;
4721: absence_records(i).PROGRAM_APPLICATION_ID :=l_program_application_id;
4722: absence_records(i).rec_start_date :=l_rec_start_date;

Line 4719: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_end_date_new); -- changed for 8844454

4715:
4716: absence_records(i).absence_type_id:=l_abs_type;
4717: absence_records(i).element_type_id:=l_ele_type;
4718: absence_records(i).abs_startdate:=FND_DATE.DATE_TO_CANONICAL(l_start_date_new); -- changed for 8844454
4719: absence_records(i).abs_enddate:=FND_DATE.DATE_TO_CANONICAL(l_end_date_new); -- changed for 8844454
4720: absence_records(i).absence_attendance_id:= l_absence_attendance_id;
4721: absence_records(i).PROGRAM_APPLICATION_ID :=l_program_application_id;
4722: absence_records(i).rec_start_date :=l_rec_start_date;
4723: absence_records(i).rec_end_date :=l_rec_end_date;