[Home] [Help]
125: l_current_user_id integer;
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: --
136: (p_attribute_id => p_attribute_id
137: ,p_action_type_id => p_action_type_id
138: );
139: --
140: hr_utility.set_location(l_proc, 10);
141: --
142: l_current_user_id := fnd_global.user_id;
143: --
144: -- Update the specified datetrack row setting the effective
156: and nvl(t.end_date - ame_util.oneSecond,sysdate);
157: --
158: --
159: p_object_version_number := l_object_version_number;
160: hr_utility.set_location(' Leaving:'||l_proc, 15);
161: --
162: End upd_end_date;
163: --
164: -- ----------------------------------------------------------------------------
199: --
200: --
201: --
202: Begin
203: hr_utility.set_location('Entering:'||l_proc, 5);
204: --
205: -- Ensure that all the mandatory arguments are not null
206: --
207: hr_api.mandatory_arg_error(p_api_name => l_proc
270: p_validation_start_date := p_effective_date;
271: p_validation_end_date := p_effective_date;
272: end if;
273: --
274: hr_utility.set_location(' Leaving:'||l_proc, 30);
275: --
276: -- We need to trap the ORA LOCK exception
277: --
278: Exception