[Home] [Help]
122: --
123: l_proc varchar2(72) := g_package||'find_dt_upd_modes';
124: --
125: Begin
126: hr_utility.set_location('Entering:'||l_proc, 5);
127: --
128: -- Call the corresponding datetrack api
129: --
130: dt_api.find_dt_upd_modes
137: ,p_update_override => p_update_override
138: ,p_update_change_insert => p_update_change_insert
139: );
140: --
141: hr_utility.set_location(' Leaving:'||l_proc, 10);
142: End find_dt_upd_modes;
143: --
144: -- ----------------------------------------------------------------------------
145: -- |---------------------------< find_dt_del_modes >--------------------------|
169: and p_effective_date
170: between t.effective_start_date and t.effective_end_date;
171: --
172: Begin
173: hr_utility.set_location('Entering:'||l_proc, 5);
174: Open C_sel1;
175: Fetch C_Sel1 Into
176: l_parent_tab1,
177: l_parent_column1,
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 => 'elig_obj_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: -- ----------------------------------------------------------------------------
289: --
290: --
291: --
292: Begin
293: hr_utility.set_location('Entering:'||l_proc, 5);
294: --
295: -- Ensure that all the mandatory arguments are not null
296: --
297: hr_api.mandatory_arg_error(p_api_name => l_proc
370: --
371: p_validation_start_date := l_validation_start_date;
372: p_validation_end_date := l_validation_end_date;
373: --
374: hr_utility.set_location(' Leaving:'||l_proc, 30);
375: --
376: -- We need to trap the ORA LOCK exception
377: --
378: Exception