[Home] [Help]
203: --
204: l_proc varchar2(72) := g_package||'find_dt_upd_modes';
205: --
206: Begin
207: hr_utility.set_location('Entering:'||l_proc, 5);
208: --
209: -- Call the corresponding datetrack api
210: --
211: dt_api.find_dt_upd_modes
218: ,p_update_override => p_update_override
219: ,p_update_change_insert => p_update_change_insert
220: );
221: --
222: hr_utility.set_location(' Leaving:'||l_proc, 10);
223: End find_dt_upd_modes;
224: --
225: -- ----------------------------------------------------------------------------
226: -- |---------------------------< find_dt_del_modes >--------------------------|
246: and p_effective_date
247: between t.effective_start_date and t.effective_end_date;
248: --
249: Begin
250: hr_utility.set_location('Entering:'||l_proc, 5);
251: Open C_sel1;
252: Fetch C_Sel1 Into
253: l_parent_key_value1;
254: If C_Sel1%NOTFOUND then
275: ,p_future_change => p_future_change
276: ,p_delete_next_change => p_delete_next_change
277: );
278: --
279: hr_utility.set_location(' Leaving:'||l_proc, 10);
280: End find_dt_del_modes;
281: --
282: -- ----------------------------------------------------------------------------
283: -- |-----------------------< upd_effective_end_date >-------------------------|
294: l_proc varchar2(72) := g_package||'upd_effective_end_date';
295: l_object_version_number number;
296: --
297: Begin
298: hr_utility.set_location('Entering:'||l_proc, 5);
299: --
300: -- Because we are updating a row we must get the next object
301: -- version number.
302: --
306: ,p_base_key_column => 'disability_id'
307: ,p_base_key_value => p_base_key_value
308: );
309: --
310: hr_utility.set_location(l_proc, 10);
311: --
312: --
313: -- Update the specified datetrack row setting the effective
314: -- end date to the specified new effective end date.
321: between t.effective_start_date and t.effective_end_date;
322: --
323: --
324: p_object_version_number := l_object_version_number;
325: hr_utility.set_location(' Leaving:'||l_proc, 15);
326: --
327: End upd_effective_end_date;
328: --
329: -- ----------------------------------------------------------------------------
436: --
437: --
438: --
439: Begin
440: hr_utility.set_location('Entering:'||l_proc, 5);
441: --
442: -- Ensure that all the mandatory arguments are not null
443: --
444: hr_api.mandatory_arg_error(p_api_name => l_proc
517: --
518: p_validation_start_date := l_validation_start_date;
519: p_validation_end_date := l_validation_end_date;
520: --
521: hr_utility.set_location(' Leaving:'||l_proc, 30);
522: --
523: -- We need to trap the ORA LOCK exception
524: --
525: Exception