[Home] [Help]
127: --
128: l_proc varchar2(72) := g_package||'find_dt_upd_modes';
129: --
130: Begin
131: hr_utility.set_location('Entering:'||l_proc, 5);
132: --
133: -- Call the corresponding datetrack api
134: --
135: dt_api.find_dt_upd_modes
142: ,p_update_override => p_update_override
143: ,p_update_change_insert => p_update_change_insert
144: );
145: --
146: hr_utility.set_location(' Leaving:'||l_proc, 10);
147: End find_dt_upd_modes;
148: --
149: -- ----------------------------------------------------------------------------
150: -- |---------------------------< find_dt_del_modes >--------------------------|
161: l_proc varchar2(72) := g_package||'find_dt_del_modes';
162: --
163: --
164: Begin
165: hr_utility.set_location('Entering:'||l_proc, 5);
166: --
167: -- Call the corresponding datetrack api
168: --
169: dt_api.find_dt_del_modes
176: ,p_future_change => p_future_change
177: ,p_delete_next_change => p_delete_next_change
178: );
179: --
180: hr_utility.set_location(' Leaving:'||l_proc, 10);
181: End find_dt_del_modes;
182: --
183: -- ----------------------------------------------------------------------------
184: -- |-----------------------< upd_effective_end_date >-------------------------|
195: l_proc varchar2(72) := g_package||'upd_effective_end_date';
196: l_object_version_number number;
197: --
198: Begin
199: hr_utility.set_location('Entering:'||l_proc, 5);
200: --
201: -- Because we are updating a row we must get the next object
202: -- version number.
203: --
207: ,p_base_key_column => 'elig_scre_wtg_id'
208: ,p_base_key_value => p_base_key_value
209: );
210: --
211: hr_utility.set_location(l_proc, 10);
212: --
213: --
214: -- Update the specified datetrack row setting the effective
215: -- end date to the specified new effective end date.
222: between t.effective_start_date and t.effective_end_date;
223: --
224: --
225: p_object_version_number := l_object_version_number;
226: hr_utility.set_location(' Leaving:'||l_proc, 15);
227: --
228: End upd_effective_end_date;
229: --
230: -- ----------------------------------------------------------------------------
270: --
271: --
272: --
273: Begin
274: hr_utility.set_location('Entering:'||l_proc, 5);
275: --
276: -- Ensure that all the mandatory arguments are not null
277: --
278: hr_api.mandatory_arg_error(p_api_name => l_proc
348: --
349: p_validation_start_date := l_validation_start_date;
350: p_validation_end_date := l_validation_end_date;
351: --
352: hr_utility.set_location(' Leaving:'||l_proc, 30);
353: --
354: -- We need to trap the ORA LOCK exception
355: --
356: Exception