[Home] [Help]
187: --
188: l_proc varchar2(72) := g_package||'find_dt_upd_modes';
189: --
190: Begin
191: hr_utility.set_location('Entering:'||l_proc, 5);
192: --
193: -- Call the corresponding datetrack api
194: --
195: dt_api.find_dt_upd_modes
202: ,p_update_override => p_update_override
203: ,p_update_change_insert => p_update_change_insert
204: );
205: --
206: hr_utility.set_location(' Leaving:'||l_proc, 10);
207: End find_dt_upd_modes;
208: --
209: -- ----------------------------------------------------------------------------
210: -- |---------------------------< find_dt_del_modes >--------------------------|
221: l_proc varchar2(72) := g_package||'find_dt_del_modes';
222: --
223: --
224: Begin
225: hr_utility.set_location('Entering:'||l_proc, 5);
226: --
227: -- Call the corresponding datetrack api
228: --
229: dt_api.find_dt_del_modes
236: ,p_future_change => p_future_change
237: ,p_delete_next_change => p_delete_next_change
238: );
239: --
240: hr_utility.set_location(' Leaving:'||l_proc, 10);
241: End find_dt_del_modes;
242: --
243: -- ----------------------------------------------------------------------------
244: -- |-----------------------< upd_effective_end_date >-------------------------|
255: l_proc varchar2(72) := g_package||'upd_effective_end_date';
256: l_object_version_number number;
257: --
258: Begin
259: hr_utility.set_location('Entering:'||l_proc, 5);
260: --
261: -- Because we are updating a row we must get the next object
262: -- version number.
263: --
267: ,p_base_key_column => 'vehicle_allocation_id'
268: ,p_base_key_value => p_base_key_value
269: );
270: --
271: hr_utility.set_location(l_proc, 10);
272: --
273: --
274: -- Update the specified datetrack row setting the effective
275: -- end date to the specified new effective end date.
282: between t.effective_start_date and t.effective_end_date;
283: --
284: --
285: p_object_version_number := l_object_version_number;
286: hr_utility.set_location(' Leaving:'||l_proc, 15);
287: --
288: End upd_effective_end_date;
289: --
290: -- ----------------------------------------------------------------------------
381: --
382: --
383: --
384: Begin
385: hr_utility.set_location('Entering:'||l_proc, 5);
386: --
387: -- Ensure that all the mandatory arguments are not null
388: --
389: hr_api.mandatory_arg_error(p_api_name => l_proc
459: --
460: p_validation_start_date := l_validation_start_date;
461: p_validation_end_date := l_validation_end_date;
462: --
463: hr_utility.set_location(' Leaving:'||l_proc, 30);
464: --
465: -- We need to trap the ORA LOCK exception
466: --
467: Exception