[Home] [Help]
160: --
161: l_proc varchar2(72) := g_package||'find_dt_upd_modes';
162: --
163: Begin
164: hr_utility.set_location('Entering:'||l_proc, 5);
165: --
166: -- Call the corresponding datetrack api
167: --
168: dt_api.find_dt_upd_modes
175: ,p_update_override => p_update_override
176: ,p_update_change_insert => p_update_change_insert
177: );
178: --
179: hr_utility.set_location(' Leaving:'||l_proc, 10);
180: End find_dt_upd_modes;
181: --
182: -- ----------------------------------------------------------------------------
183: -- |---------------------------< find_dt_del_modes >--------------------------|
194: l_proc varchar2(72) := g_package||'find_dt_del_modes';
195: --
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_del_modes
209: ,p_future_change => p_future_change
210: ,p_delete_next_change => p_delete_next_change
211: );
212: --
213: hr_utility.set_location(' Leaving:'||l_proc, 10);
214: End find_dt_del_modes;
215: --
216: -- ----------------------------------------------------------------------------
217: -- |-----------------------< upd_effective_end_date >-------------------------|
228: l_proc varchar2(72) := g_package||'upd_effective_end_date';
229: l_object_version_number number;
230: --
231: Begin
232: hr_utility.set_location('Entering:'||l_proc, 5);
233: --
234: -- Because we are updating a row we must get the next object
235: -- version number.
236: --
240: ,p_base_key_column => 'balance_category_id'
241: ,p_base_key_value => p_base_key_value
242: );
243: --
244: hr_utility.set_location(l_proc, 10);
245: --
246: --
247: -- Update the specified datetrack row setting the effective
248: -- end date to the specified new effective end date.
255: between t.effective_start_date and t.effective_end_date;
256: --
257: --
258: p_object_version_number := l_object_version_number;
259: hr_utility.set_location(' Leaving:'||l_proc, 15);
260: --
261: End upd_effective_end_date;
262: --
263: -- ----------------------------------------------------------------------------
330: --
331: --
332: --
333: Begin
334: hr_utility.set_location('Entering:'||l_proc, 5);
335: --
336: -- Ensure that all the mandatory arguments are not null
337: --
338: hr_api.mandatory_arg_error(p_api_name => l_proc
408: --
409: p_validation_start_date := l_validation_start_date;
410: p_validation_end_date := l_validation_end_date;
411: --
412: hr_utility.set_location(' Leaving:'||l_proc, 30);
413: --
414: -- We need to trap the ORA LOCK exception
415: --
416: Exception