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