[Home] [Help]
128: --
129: l_proc varchar2(72) := g_package||'find_dt_upd_modes';
130: --
131: Begin
132: hr_utility.set_location('Entering:'||l_proc, 5);
133: --
134: -- Call the corresponding datetrack api
135: --
136: dt_api.find_dt_upd_modes
143: ,p_update_override => p_update_override
144: ,p_update_change_insert => p_update_change_insert
145: );
146: --
147: hr_utility.set_location(' Leaving:'||l_proc, 10);
148: End find_dt_upd_modes;
149: --
150: -- ----------------------------------------------------------------------------
151: -- |---------------------------< find_dt_del_modes >--------------------------|
173: and p_effective_date
174: between t.effective_start_date and t.effective_end_date;
175: --
176: Begin
177: hr_utility.set_location('Entering:'||l_proc, 5);
178: Open C_sel1;
179: Fetch C_Sel1 Into
180: l_parent_key_value1
181: ,l_parent_key_value2;
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 => 'element_type_usage_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: -- ----------------------------------------------------------------------------
297: --
298: --
299: --
300: Begin
301: hr_utility.set_location('Entering:'||l_proc, 5);
302: --
303: -- Ensure that all the mandatory arguments are not null
304: --
305: hr_api.mandatory_arg_error(p_api_name => l_proc
381: --
382: p_validation_start_date := l_validation_start_date;
383: p_validation_end_date := l_validation_end_date;
384: --
385: hr_utility.set_location(' Leaving:'||l_proc, 30);
386: --
387: -- We need to trap the ORA LOCK exception
388: --
389: Exception