[Home] [Help]
129: --
130: l_proc varchar2(72) := g_package||'find_dt_upd_modes';
131: --
132: Begin
133: hr_utility.set_location('Entering:'||l_proc, 5);
134: --
135: -- Call the corresponding datetrack api
136: --
137: dt_api.find_dt_upd_modes
144: ,p_update_override => p_update_override
145: ,p_update_change_insert => p_update_change_insert
146: );
147: --
148: hr_utility.set_location(' Leaving:'||l_proc, 10);
149: End find_dt_upd_modes;
150: --
151: -- ----------------------------------------------------------------------------
152: -- |---------------------------< 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: ,l_parent_key_value2;
207: ,p_future_change => p_future_change
208: ,p_delete_next_change => p_delete_next_change
209: );
210: --
211: hr_utility.set_location(' Leaving:'||l_proc, 10);
212: End find_dt_del_modes;
213: --
214: -- ----------------------------------------------------------------------------
215: -- |-----------------------< upd_effective_end_date >-------------------------|
226: l_proc varchar2(72) := g_package||'upd_effective_end_date';
227: l_object_version_number number;
228: --
229: Begin
230: hr_utility.set_location('Entering:'||l_proc, 5);
231: --
232: -- Because we are updating a row we must get the next object
233: -- version number.
234: --
238: ,p_base_key_column => 'run_type_org_method_id'
239: ,p_base_key_value => p_base_key_value
240: );
241: --
242: hr_utility.set_location(l_proc, 10);
243: --
244: --
245: -- Update the specified datetrack row setting the effective
246: -- end date to the specified new effective end date.
253: between t.effective_start_date and t.effective_end_date;
254: --
255: --
256: p_object_version_number := l_object_version_number;
257: hr_utility.set_location(' Leaving:'||l_proc, 15);
258: --
259: End upd_effective_end_date;
260: --
261: -- ----------------------------------------------------------------------------
299: --
300: --
301: --
302: Begin
303: hr_utility.set_location('Entering:'||l_proc, 5);
304: --
305: -- Ensure that all the mandatory arguments are not null
306: --
307: hr_api.mandatory_arg_error(p_api_name => l_proc
383: --
384: p_validation_start_date := l_validation_start_date;
385: p_validation_end_date := l_validation_end_date;
386: --
387: hr_utility.set_location(' Leaving:'||l_proc, 30);
388: --
389: -- We need to trap the ORA LOCK exception
390: --
391: Exception