[Home] [Help]
194: --
195: l_proc varchar2(72) := g_package||'find_dt_upd_modes';
196: --
197: Begin
198: hr_utility.set_location('Entering:'||l_proc, 5);
199: --
200: -- Call the corresponding datetrack api
201: --
202: dt_api.find_dt_upd_modes
209: ,p_update_override => p_update_override
210: ,p_update_change_insert => p_update_change_insert
211: );
212: --
213: hr_utility.set_location(' Leaving:'||l_proc, 10);
214: End find_dt_upd_modes;
215: --
216: -- ----------------------------------------------------------------------------
217: -- |---------------------------< find_dt_del_modes >--------------------------|
237: and p_effective_date
238: between t.effective_start_date and t.effective_end_date;
239: --
240: Begin
241: hr_utility.set_location('Entering:'||l_proc, 5);
242: Open C_sel1;
243: Fetch C_Sel1 Into
244: l_parent_key_value1;
245: If C_Sel1%NOTFOUND then
266: ,p_future_change => p_future_change
267: ,p_delete_next_change => p_delete_next_change
268: );
269: --
270: hr_utility.set_location(' Leaving:'||l_proc, 10);
271: End find_dt_del_modes;
272: --
273: -- ----------------------------------------------------------------------------
274: -- |-----------------------< upd_effective_end_date >-------------------------|
285: l_proc varchar2(72) := g_package||'upd_effective_end_date';
286: l_object_version_number number;
287: --
288: Begin
289: hr_utility.set_location('Entering:'||l_proc, 5);
290: --
291: -- Because we are updating a row we must get the next object
292: -- version number.
293: --
297: ,p_base_key_column => 'assignment_acco_id'
298: ,p_base_key_value => p_base_key_value
299: );
300: --
301: hr_utility.set_location(l_proc, 10);
302: --
303: --
304: -- Update the specified datetrack row setting the effective
305: -- end date to the specified new effective end date.
312: between t.effective_start_date and t.effective_end_date;
313: --
314: --
315: p_object_version_number := l_object_version_number;
316: hr_utility.set_location(' Leaving:'||l_proc, 15);
317: --
318: End upd_effective_end_date;
319: --
320: -- ----------------------------------------------------------------------------
427: --
428: --
429: --
430: Begin
431: hr_utility.set_location('Entering:'||l_proc, 5);
432: --
433: -- Ensure that all the mandatory arguments are not null
434: --
435: hr_api.mandatory_arg_error(p_api_name => l_proc
508: --
509: p_validation_start_date := l_validation_start_date;
510: p_validation_end_date := l_validation_end_date;
511: --
512: hr_utility.set_location(' Leaving:'||l_proc, 30);
513: --
514: -- We need to trap the ORA LOCK exception
515: --
516: Exception