[Home] [Help]
134: --
135: l_proc varchar2(72) := g_package||'find_dt_upd_modes';
136: --
137: Begin
138: hr_utility.set_location('Entering:'||l_proc, 5);
139: --
140: -- Call the corresponding datetrack api
141: --
142: dt_api.find_dt_upd_modes
149: ,p_update_override => p_update_override
150: ,p_update_change_insert => p_update_change_insert
151: );
152: --
153: hr_utility.set_location(' Leaving:'||l_proc, 10);
154: End find_dt_upd_modes;
155: --
156: -- ----------------------------------------------------------------------------
157: -- |---------------------------< find_dt_del_modes >--------------------------|
168: l_proc varchar2(72) := g_package||'find_dt_del_modes';
169: --
170: --
171: Begin
172: hr_utility.set_location('Entering:'||l_proc, 5);
173: --
174: -- Call the corresponding datetrack api
175: --
176: dt_api.find_dt_del_modes
183: ,p_future_change => p_future_change
184: ,p_delete_next_change => p_delete_next_change
185: );
186: --
187: hr_utility.set_location(' Leaving:'||l_proc, 10);
188: End find_dt_del_modes;
189: --
190: -- ----------------------------------------------------------------------------
191: -- |-----------------------< upd_effective_end_date >-------------------------|
202: l_proc varchar2(72) := g_package||'upd_effective_end_date';
203: l_object_version_number number;
204: --
205: Begin
206: hr_utility.set_location('Entering:'||l_proc, 5);
207: --
208: -- Because we are updating a row we must get the next object
209: -- version number.
210: --
214: ,p_base_key_column => 'event_qualifier_id'
215: ,p_base_key_value => p_base_key_value
216: );
217: --
218: hr_utility.set_location(l_proc, 10);
219: --
220: --
221: -- Update the specified datetrack row setting the effective
222: -- end date to the specified new effective end date.
229: between t.effective_start_date and t.effective_end_date;
230: --
231: --
232: p_object_version_number := l_object_version_number;
233: hr_utility.set_location(' Leaving:'||l_proc, 15);
234: --
235: End upd_effective_end_date;
236: --
237: -- ----------------------------------------------------------------------------
279: --
280: --
281: --
282: Begin
283: hr_utility.set_location('Entering:'||l_proc, 5);
284: --
285: -- Ensure that all the mandatory arguments are not null
286: --
287: hr_api.mandatory_arg_error(p_api_name => l_proc
360: --
361: p_validation_start_date := l_validation_start_date;
362: p_validation_end_date := l_validation_end_date;
363: --
364: hr_utility.set_location(' Leaving:'||l_proc, 30);
365: --
366: -- We need to trap the ORA LOCK exception
367: --
368: Exception