[Home] [Help]
131: l_current_user_id integer;
132: l_object_version_number number;
133: --
134: Begin
135: hr_utility.set_location('Entering:'||l_proc, 5);
136: --
137: -- Because we are updating a row we must get the next object
138: -- version number.
139: --
142: (p_item_class_id => p_item_class_id
143: ,p_application_id => p_application_id
144: );
145: --
146: hr_utility.set_location(l_proc, 10);
147: --
148: l_current_user_id := fnd_global.user_id;
149: --
150: -- Update the specified datetrack row setting the effective
162: and nvl(t.end_date - (1/86400),sysdate);
163: --
164: --
165: p_object_version_number := l_object_version_number;
166: hr_utility.set_location(' Leaving:'||l_proc, 15);
167: --
168: End upd_effective_end_date;
169: --
170: -- ----------------------------------------------------------------------------
208: --
209: --
210: --
211: Begin
212: hr_utility.set_location('Entering:'||l_proc, 5);
213: --
214: -- Ensure that all the mandatory arguments are not null
215: --
216: hr_api.mandatory_arg_error(p_api_name => l_proc
277: p_validation_start_date := p_effective_date;
278: p_validation_end_date := p_effective_date;
279: end if;
280: --
281: hr_utility.set_location(' Leaving:'||l_proc, 30);
282: --
283: -- We need to trap the ORA LOCK exception
284: --
285: Exception