125: l_proc varchar2(72) := g_package||'upd_end_date';
126: l_object_version_number number;
127: --
128: Begin
129: hr_utility.set_location('Entering:'||l_proc, 5);
130: --
131: -- Because we are updating a row we must get the next object
132: -- version number.
133: --
135: ame_atr_shd.get_object_version_number
136: (p_attribute_id => p_attribute_id
137: );
138: --
139: hr_utility.set_location(l_proc, 10);
140: --
141: --
142: -- Update the specified datetrack row setting the effective
143: -- end date to the specified new effective end date.
151: ;
152: --
153: --
154: p_object_version_number := l_object_version_number;
155: hr_utility.set_location(' Leaving:'||l_proc, 15);
156: --
157: End upd_end_date;
158: --
159: -- ----------------------------------------------------------------------------
198: --
199: --
200: --
201: Begin
202: hr_utility.set_location('Entering:'||l_proc, 5);
203: --
204: -- Ensure that all the mandatory arguments are not null
205: --
206: hr_api.mandatory_arg_error(p_api_name => l_proc
269: p_validation_start_date := p_effective_date;
270: p_validation_end_date := p_effective_date;
271: end if;
272: --
273: hr_utility.set_location(' Leaving:'||l_proc, 30);
274: --
275: -- We need to trap the ORA LOCK exception
276: --
277: Exception