[Home] [Help]
154: --
155: l_proc varchar2(72) := g_package||'find_dt_upd_modes';
156: --
157: Begin
158: hr_utility.set_location('Entering:'||l_proc, 5);
159: --
160: -- Call the corresponding datetrack api
161: --
162: dt_api.find_dt_upd_modes
169: ,p_update_override => p_update_override
170: ,p_update_change_insert => p_update_change_insert
171: );
172: --
173: hr_utility.set_location(' Leaving:'||l_proc, 10);
174: End find_dt_upd_modes;
175: --
176: -- ----------------------------------------------------------------------------
177: -- |---------------------------< 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 => 'job_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: -- ----------------------------------------------------------------------------
347: --
348: --
349: --
350: Begin
351: hr_utility.set_location('Entering:'||l_proc, 5);
352: --
353: -- Ensure that all the mandatory arguments are not null
354: --
355: hr_api.mandatory_arg_error(p_api_name => l_proc
428: --
429: p_validation_start_date := l_validation_start_date;
430: p_validation_end_date := l_validation_end_date;
431: --
432: hr_utility.set_location(' Leaving:'||l_proc, 30);
433: --
434: -- We need to trap the ORA LOCK exception
435: --
436: Exception