[Home] [Help]
158: --
159: l_proc varchar2(72) := g_package||'find_dt_upd_modes';
160: --
161: Begin
162: hr_utility.set_location('Entering:'||l_proc, 5);
163: --
164: -- Call the corresponding datetrack api
165: --
166: dt_api.find_dt_upd_modes
173: ,p_update_override => p_update_override
174: ,p_update_change_insert => p_update_change_insert
175: );
176: --
177: hr_utility.set_location(' Leaving:'||l_proc, 10);
178: End find_dt_upd_modes;
179: --
180: -- ----------------------------------------------------------------------------
181: -- |---------------------------< find_dt_del_modes >--------------------------|
192: l_proc varchar2(72) := g_package||'find_dt_del_modes';
193: --
194: --
195: Begin
196: hr_utility.set_location('Entering:'||l_proc, 5);
197: --
198: -- Call the corresponding datetrack api
199: --
200: dt_api.find_dt_del_modes
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 => 'grade_rule_id'
239: ,p_base_key_value => p_base_key_value
240: );
241: --
242: hr_utility.set_location(l_proc, 10);
243: pay_pgr_shd.g_api_dml := true; -- Set the api dml status
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: pay_pgr_shd.g_api_dml := false; -- Unset the api dml status
256: p_object_version_number := l_object_version_number;
257: hr_utility.set_location(' Leaving:'||l_proc, 15);
258: --
259: Exception
260: When Others Then
261: pay_pgr_shd.g_api_dml := false; -- Unset the api dml status
311: --
312: --
313: --
314: Begin
315: hr_utility.set_location('Entering:'||l_proc, 5);
316: --
317: -- Ensure that all the mandatory arguments are not null
318: --
319: hr_api.mandatory_arg_error(p_api_name => l_proc
335: ,p_argument => 'object_version_number'
336: ,p_argument_value => p_object_version_number
337: );
338:
339: hr_utility.set_location(l_proc, 10);
340: --
341: -- Check to ensure the datetrack mode is not INSERT.
342: --
343: If (p_datetrack_mode <> hr_api.g_insert) then
366: -- and end dates for the specified datetrack operation.
367: --
368: IF pay_pgr_shd.g_old_rec.rate_type = 'A' THEN
369: --
370: hr_utility.set_location(l_proc, 20);
371: --
372: dt_api.validate_dt_mode
373: (p_effective_date => p_effective_date
374: ,p_datetrack_mode => p_datetrack_mode
383: ,p_validation_end_date => l_validation_end_date);
384: --
385: else
386: --
387: hr_utility.set_location(l_proc, 30);
388: --
389: dt_api.validate_dt_mode
390: (p_effective_date => p_effective_date
391: ,p_datetrack_mode => p_datetrack_mode
415: --
416: p_validation_start_date := l_validation_start_date;
417: p_validation_end_date := l_validation_end_date;
418: --
419: hr_utility.set_location(' Leaving:'||l_proc, 30);
420: --
421: -- We need to trap the ORA LOCK exception
422: --
423: Exception