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