84:
85: BEGIN
86:
87:
88: hr_utility.set_location('Entering: Element_populate ', 10);
89: hr_utility.set_location('p_absence_attendance_id'|| p_absence_attendance_id, 10);
90:
91: -- Fetch absence attendance details
92: BEGIN
85: BEGIN
86:
87:
88: hr_utility.set_location('Entering: Element_populate ', 10);
89: hr_utility.set_location('p_absence_attendance_id'|| p_absence_attendance_id, 10);
90:
91: -- Fetch absence attendance details
92: BEGIN
93: SELECT abs.date_start
379: AND fnd_date.canonical_to_date(p_date_earned) BETWEEN ASG.EFFECTIVE_START_DATE AND ASG.EFFECTIVE_END_DATE;
380: l_count VARCHAR2(2):='N';
381: l_duration_freq VARCHAR2(80);
382: Begin
383: hr_utility.trace('****************Inside***************');
384: FOR csr_abs_details in csr_absence
385: Loop
386: hr_utility.trace('****csr_abs_details.expected_dob**'||csr_abs_details.expected_dob);
387: p_expected_dob := csr_abs_details.expected_dob;
382: Begin
383: hr_utility.trace('****************Inside***************');
384: FOR csr_abs_details in csr_absence
385: Loop
386: hr_utility.trace('****csr_abs_details.expected_dob**'||csr_abs_details.expected_dob);
387: p_expected_dob := csr_abs_details.expected_dob;
388: hr_utility.trace('****p_expected_dob**'||p_expected_dob);
389: p_actual_dob := csr_abs_details.actual_dob;
390: p_pre_birth_duration := csr_abs_details.pre_birth_duration;
384: FOR csr_abs_details in csr_absence
385: Loop
386: hr_utility.trace('****csr_abs_details.expected_dob**'||csr_abs_details.expected_dob);
387: p_expected_dob := csr_abs_details.expected_dob;
388: hr_utility.trace('****p_expected_dob**'||p_expected_dob);
389: p_actual_dob := csr_abs_details.actual_dob;
390: p_pre_birth_duration := csr_abs_details.pre_birth_duration;
391: p_post_birth_duration := csr_abs_details.post_birth_duration;
392: p_maternity_weeks_transfer := csr_abs_details.maternity_weeks_transfer;
1096:
1097: l_abs_start:= p_abs_start_date - to_number(to_char(p_abs_start_date,'D'))+1;
1098: l_abs_end := l_abs_start+6;
1099:
1100: hr_utility.trace(' l_abs_start : '||l_abs_start||' l_abs_end :'||l_abs_end);
1101:
1102: l_count := hr_loc_work_schedule.calc_sch_based_dur(p_assignment_id,'H','N',l_abs_start,l_abs_end,'00','00',l_abs_hours_returned);
1103: l_count := hr_loc_work_schedule.calc_sch_based_dur(p_assignment_id,'D','N',l_abs_start,l_abs_end,'00','00',p_weekly_worked_days);
1104: