[Home] [Help]
131: --
132: l_proc varchar2(72) := g_package||'find_dt_upd_modes';
133: --
134: Begin
135: hr_utility.set_location('Entering:'||l_proc, 5);
136: --
137: -- Call the corresponding datetrack api
138: --
139: dt_api.find_dt_upd_modes
146: ,p_update_override => p_update_override
147: ,p_update_change_insert => p_update_change_insert
148: );
149: --
150: hr_utility.set_location(' Leaving:'||l_proc, 10);
151: End find_dt_upd_modes;
152: --
153: -- ----------------------------------------------------------------------------
154: -- |---------------------------< find_dt_del_modes >--------------------------|
174: and p_effective_date
175: between t.effective_start_date and t.effective_end_date;
176: --
177: Begin
178: hr_utility.set_location('Entering:'||l_proc, 5);
179: Open C_sel1;
180: Fetch C_Sel1 Into
181: l_parent_key_value1;
182: If C_Sel1%NOTFOUND then
203: ,p_future_change => p_future_change
204: ,p_delete_next_change => p_delete_next_change
205: );
206: --
207: hr_utility.set_location(' Leaving:'||l_proc, 10);
208: End find_dt_del_modes;
209: --
210: -- ----------------------------------------------------------------------------
211: -- |-----------------------< upd_effective_end_date >-------------------------|
222: l_proc varchar2(72) := g_package||'upd_effective_end_date';
223: l_object_version_number number;
224: --
225: Begin
226: hr_utility.set_location('Entering:'||l_proc, 5);
227: --
228: -- Because we are updating a row we must get the next object
229: -- version number.
230: --
234: ,p_base_key_column => 'social_benefit_id'
235: ,p_base_key_value => p_base_key_value
236: );
237: --
238: hr_utility.set_location(l_proc, 10);
239: --
240: --
241: -- Update the specified datetrack row setting the effective
242: -- end date to the specified new effective end date.
249: between t.effective_start_date and t.effective_end_date;
250: --
251: --
252: p_object_version_number := l_object_version_number;
253: hr_utility.set_location(' Leaving:'||l_proc, 15);
254: --
255: End upd_effective_end_date;
256: --
257: -- ----------------------------------------------------------------------------
301: --
302: --
303: --
304: Begin
305: hr_utility.set_location('Entering:'||l_proc, 5);
306: --
307: -- Ensure that all the mandatory arguments are not null
308: --
309: hr_api.mandatory_arg_error(p_api_name => l_proc
382: --
383: p_validation_start_date := l_validation_start_date;
384: p_validation_end_date := l_validation_end_date;
385: --
386: hr_utility.set_location(' Leaving:'||l_proc, 30);
387: --
388: -- We need to trap the ORA LOCK exception
389: --
390: Exception