[Home] [Help]
208: --
209: l_proc varchar2(72) := g_package||'find_dt_upd_modes';
210: --
211: Begin
212: hr_utility.set_location('Entering:'||l_proc, 5);
213: --
214: -- Call the corresponding datetrack api
215: --
216: dt_api.find_dt_upd_modes
223: ,p_update_override => p_update_override
224: ,p_update_change_insert => p_update_change_insert
225: );
226: --
227: hr_utility.set_location(' Leaving:'||l_proc, 10);
228: End find_dt_upd_modes;
229: --
230: -- ----------------------------------------------------------------------------
231: -- |---------------------------< find_dt_del_modes >--------------------------|
242: l_proc varchar2(72) := g_package||'find_dt_del_modes';
243: --
244: --
245: Begin
246: hr_utility.set_location('Entering:'||l_proc, 5);
247: --
248: -- Call the corresponding datetrack api
249: --
250: dt_api.find_dt_del_modes
257: ,p_future_change => p_future_change
258: ,p_delete_next_change => p_delete_next_change
259: );
260: --
261: hr_utility.set_location(' Leaving:'||l_proc, 10);
262: End find_dt_del_modes;
263: --
264: -- ----------------------------------------------------------------------------
265: -- |-----------------------< upd_effective_end_date >-------------------------|
276: l_proc varchar2(72) := g_package||'upd_effective_end_date';
277: l_object_version_number number;
278: --
279: Begin
280: hr_utility.set_location('Entering:'||l_proc, 5);
281: --
282: -- Because we are updating a row we must get the next object
283: -- version number.
284: --
288: ,p_base_key_column => 'accommodation_id'
289: ,p_base_key_value => p_base_key_value
290: );
291: --
292: hr_utility.set_location(l_proc, 10);
293: --
294: --
295: -- Update the specified datetrack row setting the effective
296: -- end date to the specified new effective end date.
303: between t.effective_start_date and t.effective_end_date;
304: --
305: --
306: p_object_version_number := l_object_version_number;
307: hr_utility.set_location(' Leaving:'||l_proc, 15);
308: --
309: End upd_effective_end_date;
310: --
311: -- ----------------------------------------------------------------------------
432: --
433: --
434: --
435: Begin
436: hr_utility.set_location('Entering:'||l_proc, 5);
437: --
438: -- Ensure that all the mandatory arguments are not null
439: --
440: hr_api.mandatory_arg_error(p_api_name => l_proc
513: --
514: p_validation_start_date := l_validation_start_date;
515: p_validation_end_date := l_validation_end_date;
516: --
517: hr_utility.set_location(' Leaving:'||l_proc, 30);
518: --
519: -- We need to trap the ORA LOCK exception
520: --
521: Exception