[Home] [Help]
148: --
149: l_proc varchar2(72) := g_package||'find_dt_upd_modes';
150: --
151: Begin
152: hr_utility.set_location('Entering:'||l_proc, 5);
153: --
154: -- Call the corresponding datetrack api
155: --
156: dt_api.find_dt_upd_modes_and_dates
171: ,p_upd_chg_start_date => p_upd_chg_start_date
172: ,p_upd_chg_end_date => p_upd_chg_end_date
173: );
174: --
175: hr_utility.set_location(' Leaving:'||l_proc, 10);
176: End find_dt_upd_modes;
177: --
178: -- ----------------------------------------------------------------------------
179: -- |---------------------------< find_dt_del_modes >--------------------------|
190: l_proc varchar2(72) := g_package||'find_dt_del_modes';
191: --
192: --
193: Begin
194: hr_utility.set_location('Entering:'||l_proc, 5);
195: --
196: -- Call the corresponding datetrack api
197: --
198: dt_api.find_dt_del_modes
205: ,p_future_change => p_future_change
206: ,p_delete_next_change => p_delete_next_change
207: );
208: --
209: hr_utility.set_location(' Leaving:'||l_proc, 10);
210: End find_dt_del_modes;
211: --
212: -- ----------------------------------------------------------------------------
213: -- |-----------------------< upd_effective_end_date >-------------------------|
224: l_proc varchar2(72) := g_package||'upd_effective_end_date';
225: l_object_version_number number;
226: --
227: Begin
228: hr_utility.set_location('Entering:'||l_proc, 5);
229: --
230: -- Because we are updating a row we must get the next object
231: -- version number.
232: --
236: ,p_base_key_column => 'sii_details_id'
237: ,p_base_key_value => p_base_key_value
238: );
239: --
240: hr_utility.set_location(l_proc, 10);
241: --
242: --
243: -- Update the specified datetrack row setting the effective
244: -- end date to the specified new effective end date.
251: between t.effective_start_date and t.effective_end_date;
252: --
253: --
254: p_object_version_number := l_object_version_number;
255: hr_utility.set_location(' Leaving:'||l_proc, 15);
256: --
257: End upd_effective_end_date;
258: --
259: -- ----------------------------------------------------------------------------
312: --
313: --
314: --
315: Begin
316: hr_utility.set_location('Entering:'||l_proc, 5);
317: --
318: -- Ensure that all the mandatory arguments are not null
319: --
320: hr_api.mandatory_arg_error(p_api_name => l_proc
425: --
426: p_validation_start_date := l_validation_start_date;
427: p_validation_end_date := l_validation_end_date;
428: --
429: hr_utility.set_location(' Leaving:'||l_proc, 30);
430: --
431: -- We need to trap the ORA LOCK exception
432: --
433: Exception