[Home] [Help]
140: --
141: l_proc varchar2(72) := g_package||'find_dt_upd_modes';
142: --
143: Begin
144: hr_utility.set_location('Entering:'||l_proc, 5);
145: --
146: -- Call the corresponding datetrack api
147: --
148: dt_api.find_dt_upd_modes_and_dates
163: ,p_override_start_date => p_override_start_date
164: ,p_override_end_date => p_override_end_date
165: );
166: --
167: hr_utility.set_location(' Leaving:'||l_proc, 10);
168: End find_dt_upd_modes;
169: --
170: -- ----------------------------------------------------------------------------
171: -- |---------------------------< find_dt_del_modes >--------------------------|
182: l_proc varchar2(72) := g_package||'find_dt_del_modes';
183: --
184: --
185: Begin
186: hr_utility.set_location('Entering:'||l_proc, 5);
187: --
188: -- Call the corresponding datetrack api
189: --
190: dt_api.find_dt_del_modes
197: ,p_future_change => p_future_change
198: ,p_delete_next_change => p_delete_next_change
199: );
200: --
201: hr_utility.set_location(' Leaving:'||l_proc, 10);
202: End find_dt_del_modes;
203: --
204: -- ----------------------------------------------------------------------------
205: -- |-----------------------< upd_effective_end_date >-------------------------|
216: l_proc varchar2(72) := g_package||'upd_effective_end_date';
217: l_object_version_number number;
218: --
219: Begin
220: hr_utility.set_location('Entering:'||l_proc, 5);
221: --
222: -- Because we are updating a row we must get the next object
223: -- version number.
224: --
228: ,p_base_key_column => 'paye_details_id'
229: ,p_base_key_value => p_base_key_value
230: );
231: --
232: hr_utility.set_location(l_proc, 10);
233: --
234: --
235: -- Update the specified datetrack row setting the effective
236: -- end date to the specified new effective end date.
243: between t.effective_start_date and t.effective_end_date;
244: --
245: --
246: p_object_version_number := l_object_version_number;
247: hr_utility.set_location(' Leaving:'||l_proc, 15);
248: --
249: End upd_effective_end_date;
250: --
251: -- ----------------------------------------------------------------------------
294: --
295: --
296: --
297: Begin
298: hr_utility.set_location('Entering:'||l_proc, 5);
299: --
300: -- Ensure that all the mandatory arguments are not null
301: --
302: 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