[Home] [Help]
155: --
156: l_proc varchar2(72) := g_package||'find_dt_upd_modes';
157: --
158: Begin
159: hr_utility.set_location('Entering:'||l_proc, 5);
160: --
161: -- Call the corresponding datetrack api
162: --
163: dt_api.find_dt_upd_modes
170: ,p_update_override => p_update_override
171: ,p_update_change_insert => p_update_change_insert
172: );
173: --
174: hr_utility.set_location(' Leaving:'||l_proc, 10);
175: End find_dt_upd_modes;
176: --
177: -- ----------------------------------------------------------------------------
178: -- |---------------------------< find_dt_del_modes >--------------------------|
197: and p_effective_date
198: between t.effective_start_date and t.effective_end_date;
199: --
200: Begin
201: hr_utility.set_location('Entering:'||l_proc, 5);
202: Open C_sel1;
203: Fetch C_Sel1 Into
204: l_parent_key_value1;
205: If C_Sel1%NOTFOUND then
226: ,p_future_change => p_future_change
227: ,p_delete_next_change => p_delete_next_change
228: );
229: --
230: hr_utility.set_location(' Leaving:'||l_proc, 10);
231: End find_dt_del_modes;
232: --
233: -- ----------------------------------------------------------------------------
234: -- |-----------------------< upd_effective_end_date >-------------------------|
245: l_proc varchar2(72) := g_package||'upd_effective_end_date';
246: l_object_version_number number;
247: --
248: Begin
249: hr_utility.set_location('Entering:'||l_proc, 5);
250: --
251: -- Because we are updating a row we must get the next object
252: -- version number.
253: --
257: ,p_base_key_column => 'comptncy_rt_id'
258: ,p_base_key_value => p_base_key_value
259: );
260: --
261: hr_utility.set_location(l_proc, 10);
262: --
263: --
264: -- Update the specified datetrack row setting the effective
265: -- end date to the specified new effective end date.
272: between t.effective_start_date and t.effective_end_date;
273: --
274: --
275: p_object_version_number := l_object_version_number;
276: hr_utility.set_location(' Leaving:'||l_proc, 15);
277: --
278: End upd_effective_end_date;
279: --
280: -- ----------------------------------------------------------------------------
348: --
349: --
350: --
351: Begin
352: hr_utility.set_location('Entering:'||l_proc, 5);
353: --
354: -- Ensure that all the mandatory arguments are not null
355: --
356: hr_api.mandatory_arg_error(p_api_name => l_proc
429: --
430: p_validation_start_date := l_validation_start_date;
431: p_validation_end_date := l_validation_end_date;
432: --
433: hr_utility.set_location(' Leaving:'||l_proc, 30);
434: --
435: -- We need to trap the ORA LOCK exception
436: --
437: Exception