52: */
53:
54: begin
55:
56: g_debug := hr_utility.debug_enabled;
57:
58: if g_debug THEN
59: hr_utility.set_location('Entering '||l_proc, 10);
60: hr_utility.set_location('p_absence_attendance_id ' || p_absence_attendance_id, 25);
55:
56: g_debug := hr_utility.debug_enabled;
57:
58: if g_debug THEN
59: hr_utility.set_location('Entering '||l_proc, 10);
60: hr_utility.set_location('p_absence_attendance_id ' || p_absence_attendance_id, 25);
61: end if;
62:
63: /* Get the element entry details for the absence element. */
56: g_debug := hr_utility.debug_enabled;
57:
58: if g_debug THEN
59: hr_utility.set_location('Entering '||l_proc, 10);
60: hr_utility.set_location('p_absence_attendance_id ' || p_absence_attendance_id, 25);
61: end if;
62:
63: /* Get the element entry details for the absence element. */
64:
62:
63: /* Get the element entry details for the absence element. */
64:
65: if g_debug THEN
66: hr_utility.set_location(l_proc, 20);
67: end if;
68: open c_get_absence_element(p_absence_attendance_id);
69: fetch c_get_absence_element into l_element_entry_id,
70: l_effective_start_date,
73: l_ovn;
74: close c_get_absence_element;
75:
76: if g_debug THEN
77: hr_utility.set_location('l_element_entry_id ' || l_element_entry_id, 25);
78: hr_utility.set_location('l_effective_start_date ' || l_effective_start_date, 25);
79: hr_utility.set_location('l_effective_end_date ' || l_effective_end_date, 25);
80: hr_utility.set_location('l_processing_type ' || l_processing_type, 25);
81: hr_utility.set_location('l_ovn ' || l_ovn, 25);
74: close c_get_absence_element;
75:
76: if g_debug THEN
77: hr_utility.set_location('l_element_entry_id ' || l_element_entry_id, 25);
78: hr_utility.set_location('l_effective_start_date ' || l_effective_start_date, 25);
79: hr_utility.set_location('l_effective_end_date ' || l_effective_end_date, 25);
80: hr_utility.set_location('l_processing_type ' || l_processing_type, 25);
81: hr_utility.set_location('l_ovn ' || l_ovn, 25);
82: end if;
75:
76: if g_debug THEN
77: hr_utility.set_location('l_element_entry_id ' || l_element_entry_id, 25);
78: hr_utility.set_location('l_effective_start_date ' || l_effective_start_date, 25);
79: hr_utility.set_location('l_effective_end_date ' || l_effective_end_date, 25);
80: hr_utility.set_location('l_processing_type ' || l_processing_type, 25);
81: hr_utility.set_location('l_ovn ' || l_ovn, 25);
82: end if;
83:
76: if g_debug THEN
77: hr_utility.set_location('l_element_entry_id ' || l_element_entry_id, 25);
78: hr_utility.set_location('l_effective_start_date ' || l_effective_start_date, 25);
79: hr_utility.set_location('l_effective_end_date ' || l_effective_end_date, 25);
80: hr_utility.set_location('l_processing_type ' || l_processing_type, 25);
81: hr_utility.set_location('l_ovn ' || l_ovn, 25);
82: end if;
83:
84: /* Call the AU element entry hook package to udpate the element entry values.
77: hr_utility.set_location('l_element_entry_id ' || l_element_entry_id, 25);
78: hr_utility.set_location('l_effective_start_date ' || l_effective_start_date, 25);
79: hr_utility.set_location('l_effective_end_date ' || l_effective_end_date, 25);
80: hr_utility.set_location('l_processing_type ' || l_processing_type, 25);
81: hr_utility.set_location('l_ovn ' || l_ovn, 25);
82: end if;
83:
84: /* Call the AU element entry hook package to udpate the element entry values.
85: Only do for recurring elements. */
93: ,p_creator_id => p_absence_attendance_id
94: );
95:
96: if g_debug THEN
97: hr_utility.set_location(l_proc, 90);
98: end if;
99:
100: end if;
101:
99:
100: end if;
101:
102: if g_debug THEN
103: hr_utility.set_location('Leaving '||l_proc, 99);
104: end if;
105:
106: END update_absence_dev_desc_flex ;
107: