DBA Data[Home] [Help]

APPS.PAY_DK_ABSENCE_USER dependencies on HR_UTILITY

Line 88: hr_utility.set_location('Entering: Element_populate ', 10);

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

Line 89: hr_utility.set_location('p_absence_attendance_id'|| p_absence_attendance_id, 10);

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

Line 417: hr_utility.trace('****************Inside***************');

413: AND fnd_date.canonical_to_date(p_date_earned) BETWEEN ASG.EFFECTIVE_START_DATE AND ASG.EFFECTIVE_END_DATE;
414: l_count VARCHAR2(2):='N';
415: l_duration_freq VARCHAR2(80);
416: Begin
417: hr_utility.trace('****************Inside***************');
418: FOR csr_abs_details in csr_absence
419: Loop
420: hr_utility.trace('****csr_abs_details.expected_dob**'||csr_abs_details.expected_dob);
421: p_expected_dob := csr_abs_details.expected_dob;

Line 420: hr_utility.trace('****csr_abs_details.expected_dob**'||csr_abs_details.expected_dob);

416: Begin
417: hr_utility.trace('****************Inside***************');
418: FOR csr_abs_details in csr_absence
419: Loop
420: hr_utility.trace('****csr_abs_details.expected_dob**'||csr_abs_details.expected_dob);
421: p_expected_dob := csr_abs_details.expected_dob;
422: hr_utility.trace('****p_expected_dob**'||p_expected_dob);
423: p_actual_dob := csr_abs_details.actual_dob;
424: p_pre_birth_duration := csr_abs_details.pre_birth_duration;

Line 422: hr_utility.trace('****p_expected_dob**'||p_expected_dob);

418: FOR csr_abs_details in csr_absence
419: Loop
420: hr_utility.trace('****csr_abs_details.expected_dob**'||csr_abs_details.expected_dob);
421: p_expected_dob := csr_abs_details.expected_dob;
422: hr_utility.trace('****p_expected_dob**'||p_expected_dob);
423: p_actual_dob := csr_abs_details.actual_dob;
424: p_pre_birth_duration := csr_abs_details.pre_birth_duration;
425: p_post_birth_duration := csr_abs_details.post_birth_duration;
426: p_maternity_weeks_transfer := csr_abs_details.maternity_weeks_transfer;

Line 1138: hr_utility.trace(' l_abs_start : '||l_abs_start||' l_abs_end :'||l_abs_end);

1134:
1135: l_abs_start:= p_abs_start_date - to_number(to_char(p_abs_start_date,'D'))+1;
1136: l_abs_end := l_abs_start+6;
1137:
1138: hr_utility.trace(' l_abs_start : '||l_abs_start||' l_abs_end :'||l_abs_end);
1139:
1140: 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);
1141: 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);
1142: