[Home] [Help]
128: --
129: l_proc varchar2(72) := g_package||'find_dt_upd_modes';
130: --
131: Begin
132: hr_utility.set_location('Entering:'||l_proc, 5);
133: --
134: -- Call the corresponding datetrack api
135: --
136: dt_api.find_dt_upd_modes
143: ,p_update_override => p_update_override
144: ,p_update_change_insert => p_update_change_insert
145: );
146: --
147: hr_utility.set_location(' Leaving:'||l_proc, 10);
148: End find_dt_upd_modes;
149: --
150: -- ----------------------------------------------------------------------------
151: -- |---------------------------< find_dt_del_modes >--------------------------|
171: and p_effective_date
172: between t.effective_start_date and t.effective_end_date;
173: --
174: Begin
175: hr_utility.set_location('Entering:'||l_proc, 5);
176: Open C_sel1;
177: Fetch C_Sel1 Into
178: l_parent_key_value1;
179: If C_Sel1%NOTFOUND then
200: ,p_future_change => p_future_change
201: ,p_delete_next_change => p_delete_next_change
202: );
203: --
204: hr_utility.set_location(' Leaving:'||l_proc, 10);
205: End find_dt_del_modes;
206: --
207: -- ----------------------------------------------------------------------------
208: -- |-----------------------< upd_effective_end_date >-------------------------|
219: l_proc varchar2(72) := g_package||'upd_effective_end_date';
220: l_object_version_number number;
221: --
222: Begin
223: hr_utility.set_location('Entering:'||l_proc, 5);
224: --
225: -- Because we are updating a row we must get the next object
226: -- version number.
227: --
231: ,p_base_key_column => 'event_value_change_id'
232: ,p_base_key_value => p_base_key_value
233: );
234: --
235: hr_utility.set_location(l_proc, 10);
236: --
237: --
238: -- Update the specified datetrack row setting the effective
239: -- end date to the specified new effective end date.
246: between t.effective_start_date and t.effective_end_date;
247: --
248: --
249: p_object_version_number := l_object_version_number;
250: hr_utility.set_location(' Leaving:'||l_proc, 15);
251: --
252: End upd_effective_end_date;
253: --
254: -- ----------------------------------------------------------------------------
295: --
296: --
297: --
298: Begin
299: hr_utility.set_location('Entering:'||l_proc, 5);
300: --
301: -- Ensure that all the mandatory arguments are not null
302: --
303: hr_api.mandatory_arg_error(p_api_name => l_proc
376: --
377: p_validation_start_date := l_validation_start_date;
378: p_validation_end_date := l_validation_end_date;
379: --
380: hr_utility.set_location(' Leaving:'||l_proc, 30);
381: --
382: -- We need to trap the ORA LOCK exception
383: --
384: Exception