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