[Home] [Help]
143: --
144: l_proc varchar2(72) := g_package||'find_dt_upd_modes';
145: --
146: Begin
147: hr_utility.set_location('Entering:'||l_proc, 5);
148: --
149: -- Call the corresponding datetrack api
150: --
151: dt_api.find_dt_upd_modes
158: ,p_update_override => p_update_override
159: ,p_update_change_insert => p_update_change_insert
160: );
161: --
162: hr_utility.set_location(' Leaving:'||l_proc, 10);
163: End find_dt_upd_modes;
164: --
165: -- ----------------------------------------------------------------------------
166: -- |---------------------------< find_dt_del_modes >--------------------------|
188: and p_effective_date
189: between t.effective_start_date and t.effective_end_date;
190: --
191: Begin
192: hr_utility.set_location('Entering:'||l_proc, 5);
193: Open C_sel1;
194: Fetch C_Sel1 Into
195: l_parent_key_value1,
196: l_parent_key_value2;
221: ,p_future_change => p_future_change
222: ,p_delete_next_change => p_delete_next_change
223: );
224: --
225: hr_utility.set_location(' Leaving:'||l_proc, 10);
226: End find_dt_del_modes;
227: --
228: -- ----------------------------------------------------------------------------
229: -- |-----------------------< upd_effective_end_date >-------------------------|
240: l_proc varchar2(72) := g_package||'upd_effective_end_date';
241: l_object_version_number number;
242: --
243: Begin
244: hr_utility.set_location('Entering:'||l_proc, 5);
245: --
246: -- Because we are updating a row we must get the next object
247: -- version number.
248: --
252: ,p_base_key_column => 'elig_obj_elig_prfl_id'
253: ,p_base_key_value => p_base_key_value
254: );
255: --
256: hr_utility.set_location(l_proc, 10);
257: --
258: --
259: -- Update the specified datetrack row setting the effective
260: -- end date to the specified new effective end date.
267: between t.effective_start_date and t.effective_end_date;
268: --
269: --
270: p_object_version_number := l_object_version_number;
271: hr_utility.set_location(' Leaving:'||l_proc, 15);
272: --
273: End upd_effective_end_date;
274: --
275: -- ----------------------------------------------------------------------------
331: --
332: --
333: --
334: Begin
335: hr_utility.set_location('Entering:'||l_proc, 5);
336: --
337: -- Ensure that all the mandatory arguments are not null
338: --
339: hr_api.mandatory_arg_error(p_api_name => l_proc
415: --
416: p_validation_start_date := l_validation_start_date;
417: p_validation_end_date := l_validation_end_date;
418: --
419: hr_utility.set_location(' Leaving:'||l_proc, 30);
420: --
421: -- We need to trap the ORA LOCK exception
422: --
423: Exception