142: l_current_user_id integer;
143: l_object_version_number number;
144: --
145: Begin
146: hr_utility.set_location('Entering:'||l_proc, 5);
147: --
148: l_current_user_id := fnd_global.user_id;
149: --
150: -- Because we are updating a row we must get the next object
155: (p_attribute_id => p_attribute_id
156: ,p_application_id => p_application_id
157: );
158: --
159: hr_utility.set_location(l_proc, 10);
160: --
161: --
162: -- Update the specified datetrack row setting the effective
163: -- end date to the specified new effective end date.
175: ;
176: --
177: --
178: p_object_version_number := l_object_version_number;
179: hr_utility.set_location(' Leaving:'||l_proc, 15);
180: --
181: End upd_end_date;
182: --
183: -- ----------------------------------------------------------------------------
224: --
225: --
226: --
227: Begin
228: hr_utility.set_location('Entering:'||l_proc, 5);
229: --
230: -- Ensure that all the mandatory arguments are not null
231: --
232: hr_api.mandatory_arg_error(p_api_name => l_proc
298: p_validation_start_date := ame_atu_shd.g_old_rec.start_date;
299: p_validation_end_date := ame_atu_shd.g_old_rec.end_date;
300: end if;
301: --
302: hr_utility.set_location(' Leaving:'||l_proc, 30);
303: begin
304: select null
305: into l_dummy
306: from ame_attributes