64: --
65: l_proc varchar2(72) := g_package||'dt_update_dml';
66: --
67: Begin
68: hr_utility.set_location('Entering:'||l_proc, 5);
69: --
70: If (p_datetrack_mode = hr_api.g_correction) then
71: hr_utility.set_location(l_proc, 10);
72: --
67: Begin
68: hr_utility.set_location('Entering:'||l_proc, 5);
69: --
70: If (p_datetrack_mode = hr_api.g_correction) then
71: hr_utility.set_location(l_proc, 10);
72: --
73: -- Because we are updating a row we must get the next object
74: -- version number.
75: --
105: p_rec.effective_start_date := p_validation_start_date;
106: p_rec.effective_end_date := p_validation_end_date;
107: End If;
108: --
109: hr_utility.set_location(' Leaving:'||l_proc, 15);
110: Exception
111: When hr_api.check_integrity_violated Then
112: -- A check constraint has been violated
113: --
164: --
165: l_proc varchar2(72) := g_package||'update_dml';
166: --
167: Begin
168: hr_utility.set_location('Entering:'||l_proc, 5);
169: --
170: irc_iad_upd.dt_update_dml
171: (p_rec => p_rec
172: ,p_effective_date => p_effective_date
174: ,p_validation_start_date => p_validation_start_date
175: ,p_validation_end_date => p_validation_end_date
176: );
177: --
178: hr_utility.set_location(' Leaving:'||l_proc, 10);
179: End update_dml;
180: --
181: -- ----------------------------------------------------------------------------
182: -- |----------------------------< dt_pre_update >-----------------------------|
232: l_proc varchar2(72) := g_package||'dt_pre_update';
233: l_dummy_version_number number;
234: --
235: Begin
236: hr_utility.set_location('Entering:'||l_proc, 5);
237: If (p_datetrack_mode <> hr_api.g_correction) then
238: --
239: -- Update the current effective end date
240: --
237: If (p_datetrack_mode <> hr_api.g_correction) then
238: --
239: -- Update the current effective end date
240: --
241: hr_utility.set_location(l_proc, 10);
242: irc_iad_shd.upd_effective_end_date
243: (p_effective_date => p_effective_date
244: ,p_base_key_value => p_rec.assignment_id
245: ,p_new_effective_end_date => (p_validation_start_date - 1)
252: --
253: -- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
254: -- delete any future rows
255: --
256: hr_utility.set_location(l_proc, 20);
257: irc_iad_del.delete_dml
258: (p_rec => p_rec
259: ,p_effective_date => p_effective_date
260: ,p_datetrack_mode => p_datetrack_mode
265: Else
266: -- Correction mode
267: --
268: -- Reset the Latest Details flag for the current effective date range rows.
269: hr_utility.set_location(l_proc, 30);
270: p_rec.object_version_number :=
271: dt_api.get_object_version_number
272: (p_base_table_name => 'irc_assignment_details_f'
273: ,p_base_key_column => 'assignment_id'
283: End If;
284: --
285: -- We need to insert a new row, so get a new surrogate key if necessary.
286: --
287: hr_utility.set_location(l_proc, 40);
288: irc_iad_ins.pre_insert
289: (p_rec => p_rec
290: ,p_effective_date => p_effective_date
291: ,p_datetrack_mode => p_datetrack_mode
301: ,p_datetrack_mode => p_datetrack_mode
302: ,p_validation_start_date => p_validation_start_date
303: ,p_validation_end_date => p_validation_end_date
304: );
305: hr_utility.set_location(' Leaving:'||l_proc, 50);
306: End dt_pre_update;
307: --
308: -- ----------------------------------------------------------------------------
309: -- |------------------------------< pre_update >------------------------------|
347: --
348: l_proc varchar2(72) := g_package||'pre_update';
349: --
350: Begin
351: hr_utility.set_location('Entering:'||l_proc, 5);
352: --
353: --
354: --
355: dt_pre_update
359: ,p_validation_start_date => p_validation_start_date
360: ,p_validation_end_date => p_validation_end_date
361: );
362: --
363: hr_utility.set_location(' Leaving:'||l_proc, 10);
364: End pre_update;
365: --
366: -- ----------------------------------------------------------------------------
367: -- |----------------------------< post_update >-------------------------------|
405: --
406: l_proc varchar2(72) := g_package||'post_update';
407: --
408: Begin
409: hr_utility.set_location('Entering:'||l_proc, 5);
410: begin
411: --
412: irc_iad_rku.after_update
413: (p_effective_date
467: ,p_hook_type => 'AU');
468: --
469: end;
470: --
471: hr_utility.set_location(' Leaving:'||l_proc, 10);
472: End post_update;
473: --
474: -- ----------------------------------------------------------------------------
475: -- |-----------------------------< convert_defs >-----------------------------|
565: l_validation_start_date date;
566: l_validation_end_date date;
567: --
568: Begin
569: hr_utility.set_location('Entering:'||l_proc, 5);
570: --
571: -- Ensure that the DateTrack update mode is valid
572: --
573: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
650: l_rec irc_iad_shd.g_rec_type;
651: l_proc varchar2(72) := g_package||'upd';
652: --
653: Begin
654: hr_utility.set_location('Entering:'||l_proc, 5);
655: --
656: -- Call conversion function to turn arguments into the
657: -- l_rec structure.
658: --
689: p_effective_start_date := l_rec.effective_start_date;
690: p_effective_end_date := l_rec.effective_end_date;
691: --
692: --
693: hr_utility.set_location(' Leaving:'||l_proc, 10);
694: End upd;
695: --
696: end irc_iad_upd;