85:
86: BEGIN
87:
88: /* Added for GSI Bug 5472781 */
89: IF hr_utility.chk_product_install('Oracle Human Resources', 'IE') THEN
90:
91: hr_utility.set_location('Entering ' || l_proc,10);
92: hr_utility.set_location('p_vehicle_allocation_id = ' ||
93: p_vehicle_allocation_id,10);
87:
88: /* Added for GSI Bug 5472781 */
89: IF hr_utility.chk_product_install('Oracle Human Resources', 'IE') THEN
90:
91: hr_utility.set_location('Entering ' || l_proc,10);
92: hr_utility.set_location('p_vehicle_allocation_id = ' ||
93: p_vehicle_allocation_id,10);
94: hr_utility.set_location('p_effective_date = ' || p_effective_date,10);
95:
88: /* Added for GSI Bug 5472781 */
89: IF hr_utility.chk_product_install('Oracle Human Resources', 'IE') THEN
90:
91: hr_utility.set_location('Entering ' || l_proc,10);
92: hr_utility.set_location('p_vehicle_allocation_id = ' ||
93: p_vehicle_allocation_id,10);
94: hr_utility.set_location('p_effective_date = ' || p_effective_date,10);
95:
96: OPEN csr_vehicle_element_entry;
90:
91: hr_utility.set_location('Entering ' || l_proc,10);
92: hr_utility.set_location('p_vehicle_allocation_id = ' ||
93: p_vehicle_allocation_id,10);
94: hr_utility.set_location('p_effective_date = ' || p_effective_date,10);
95:
96: OPEN csr_vehicle_element_entry;
97: FETCH csr_vehicle_element_entry
98: INTO l_element_entry_id,
99: l_object_version_number,
100: l_max_effective_date,
101: l_max_date_earned; -- 5872123
102:
103: hr_utility.set_location('l_effective_start_date = ' ||
104: to_char(l_element_entry_id),30);
105: hr_utility.set_location('l_effective_end_date = ' ||
106: to_char(l_object_version_number),30);
107: hr_utility.set_location('l_effective_end_date = ' ||
101: l_max_date_earned; -- 5872123
102:
103: hr_utility.set_location('l_effective_start_date = ' ||
104: to_char(l_element_entry_id),30);
105: hr_utility.set_location('l_effective_end_date = ' ||
106: to_char(l_object_version_number),30);
107: hr_utility.set_location('l_effective_end_date = ' ||
108: to_char(l_max_effective_date),30);
109:
103: hr_utility.set_location('l_effective_start_date = ' ||
104: to_char(l_element_entry_id),30);
105: hr_utility.set_location('l_effective_end_date = ' ||
106: to_char(l_object_version_number),30);
107: hr_utility.set_location('l_effective_end_date = ' ||
108: to_char(l_max_effective_date),30);
109:
110: IF csr_vehicle_element_entry%FOUND THEN
111: OPEN csr_pay_period(l_max_effective_date,l_max_date_earned); -- 5872123
111: OPEN csr_pay_period(l_max_effective_date,l_max_date_earned); -- 5872123
112: FETCH csr_pay_period INTO l_period_end_date;
113: CLOSE csr_pay_period;
114:
115: hr_utility.set_location('l_element_entry_id = ' || l_element_entry_id,20);
116: hr_utility.set_location('l_period_end_date = ' || l_period_end_date,20);
117: hr_utility.set_location('Calling delete_element_entry',25);
118:
119: pay_element_entry_api.delete_element_entry (
112: FETCH csr_pay_period INTO l_period_end_date;
113: CLOSE csr_pay_period;
114:
115: hr_utility.set_location('l_element_entry_id = ' || l_element_entry_id,20);
116: hr_utility.set_location('l_period_end_date = ' || l_period_end_date,20);
117: hr_utility.set_location('Calling delete_element_entry',25);
118:
119: pay_element_entry_api.delete_element_entry (
120: p_validate => FALSE,
113: CLOSE csr_pay_period;
114:
115: hr_utility.set_location('l_element_entry_id = ' || l_element_entry_id,20);
116: hr_utility.set_location('l_period_end_date = ' || l_period_end_date,20);
117: hr_utility.set_location('Calling delete_element_entry',25);
118:
119: pay_element_entry_api.delete_element_entry (
120: p_validate => FALSE,
121: p_datetrack_delete_mode => 'DELETE',
126: p_effective_end_date => l_effective_end_date,
127: p_delete_warning => l_delete_warning
128: );
129:
130: hr_utility.set_location('l_effective_start_date = ' ||
131: l_effective_start_date,30);
132: hr_utility.set_location('l_effective_end_date = ' ||
133: l_effective_end_date,30);
134: END IF;
128: );
129:
130: hr_utility.set_location('l_effective_start_date = ' ||
131: l_effective_start_date,30);
132: hr_utility.set_location('l_effective_end_date = ' ||
133: l_effective_end_date,30);
134: END IF;
135:
136: CLOSE csr_vehicle_element_entry;
133: l_effective_end_date,30);
134: END IF;
135:
136: CLOSE csr_vehicle_element_entry;
137: hr_utility.set_location('Leaving ' || l_proc,40);
138:
139: END IF; /* Added for GSI Bug 5472781 */
140:
141: END element_end_date_update;