[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 >--------------------------|
177: and p_effective_date
178: between t.effective_start_date and t.effective_end_date;
179: --
180: Begin
181: hr_utility.set_location('Entering:'||l_proc, 5);
182: Open C_sel1;
183: Fetch C_Sel1 Into
184: l_parent_key_value1;
185: If C_Sel1%NOTFOUND then
206: ,p_future_change => p_future_change
207: ,p_delete_next_change => p_delete_next_change
208: );
209: --
210: hr_utility.set_location(' Leaving:'||l_proc, 10);
211: End find_dt_del_modes;
212: --
213: -- ----------------------------------------------------------------------------
214: -- |-----------------------< upd_effective_end_date >-------------------------|
225: l_proc varchar2(72) := g_package||'upd_effective_end_date';
226: l_object_version_number number;
227: --
228: Begin
229: hr_utility.set_location('Entering:'||l_proc, 5);
230: --
231: -- Because we are updating a row we must get the next object
232: -- version number.
233: --
237: ,p_base_key_column => 'paye_details_id'
238: ,p_base_key_value => p_base_key_value
239: );
240: --
241: hr_utility.set_location(l_proc, 10);
242: --
243: --
244: -- Update the specified datetrack row setting the effective
245: -- end date to the specified new effective end date.
252: between t.effective_start_date and t.effective_end_date;
253: --
254: --
255: p_object_version_number := l_object_version_number;
256: hr_utility.set_location(' Leaving:'||l_proc, 15);
257: --
258: End upd_effective_end_date;
259: --
260: -- ----------------------------------------------------------------------------
307: --
308: --
309: --
310: Begin
311: hr_utility.set_location('Entering:'||l_proc, 5);
312: --
313: -- Ensure that all the mandatory arguments are not null
314: --
315: hr_api.mandatory_arg_error(p_api_name => l_proc
388: --
389: p_validation_start_date := l_validation_start_date;
390: p_validation_end_date := l_validation_end_date;
391: --
392: hr_utility.set_location(' Leaving:'||l_proc, 30);
393: --
394: -- We need to trap the ORA LOCK exception
395: --
396: Exception