[Home] [Help]
20: --
21: l_proc varchar2(72) := g_package||'set_base_key_value';
22: --
23: Begin
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: ben_jrt_ins.g_job_rt_id_i := p_job_rt_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: ben_jrt_ins.g_job_rt_id_i := p_job_rt_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: End set_base_key_value;
30: --
31: --
32: -- ----------------------------------------------------------------------------
101: l_last_updated_by ben_job_rt_f.last_updated_by%TYPE;
102: l_last_update_login ben_job_rt_f.last_update_login%TYPE;
103: --
104: Begin
105: hr_utility.set_location('Entering:'||l_proc, 5);
106: --
107: -- Get the object version number for the insert
108: --
109: p_rec.object_version_number :=
122: -- If the datetrack_mode is not INSERT then we must populate the WHO
123: -- columns with the 'old' creation values and 'new' updated values.
124: --
125: If (p_datetrack_mode <> hr_api.g_insert) then
126: hr_utility.set_location(l_proc, 10);
127: --
128: -- Select the 'old' created values
129: --
130: Open C_Sel1;
248: ,l_last_update_login
249: );
250: --
251: --
252: hr_utility.set_location(' Leaving:'||l_proc, 15);
253: --
254: Exception
255: When hr_api.check_integrity_violated Then
256: -- A check constraint has been violated
280: --
281: l_proc varchar2(72) := g_package||'insert_dml';
282: --
283: Begin
284: hr_utility.set_location('Entering:'||l_proc, 5);
285: --
286: ben_jrt_ins.dt_insert_dml
287: (p_rec => p_rec
288: ,p_effective_date => p_effective_date
290: ,p_validation_start_date => p_validation_start_date
291: ,p_validation_end_date => p_validation_end_date
292: );
293: --
294: hr_utility.set_location(' Leaving:'||l_proc, 10);
295: End insert_dml;
296: --
297: -- ----------------------------------------------------------------------------
298: -- |------------------------------< pre_insert >------------------------------|
352: l_proc varchar2(72) := g_package||'pre_insert';
353: l_exists varchar2(1);
354: --
355: Begin
356: hr_utility.set_location('Entering:'||l_proc, 5);
357: --
358: If (ben_jrt_ins.g_job_rt_id_i is not null) Then
359: --
360: -- Verify registered primary key values not already in use
389: Close C_Sel1;
390: End If;
391: --
392: --
393: hr_utility.set_location(' Leaving:'||l_proc, 10);
394: End pre_insert;
395: --
396: -- ----------------------------------------------------------------------------
397: -- |----------------------------< post_insert >-------------------------------|
435: --
436: l_proc varchar2(72) := g_package||'post_insert';
437: --
438: Begin
439: hr_utility.set_location('Entering:'||l_proc, 5);
440: begin
441: --
442: ben_jrt_rki.after_insert
443: (p_effective_date
537: ,p_hook_type => 'AI');
538: --
539: end;
540: --
541: hr_utility.set_location(' Leaving:'||l_proc, 10);
542: End post_insert;
543: --
544: -- ----------------------------------------------------------------------------
545: -- |-------------------------------< ins_lck >--------------------------------|
589: l_validation_start_date date;
590: l_validation_end_date date;
591: --
592: Begin
593: hr_utility.set_location('Entering:'||l_proc, 5);
594: --
595: -- Validate the datetrack mode mode getting the validation start
596: -- and end dates for the specified datetrack operation.
597: --
613: --
614: p_validation_start_date := l_validation_start_date;
615: p_validation_end_date := l_validation_end_date;
616: --
617: hr_utility.set_location(' Leaving:'||l_proc, 10);
618: --
619: End ins_lck;
620: --
621: -- ----------------------------------------------------------------------------
631: l_validation_start_date date;
632: l_validation_end_date date;
633: --
634: Begin
635: hr_utility.set_location('Entering:'||l_proc, 5);
636: --
637: -- Call the lock operation
638: --
639: ben_jrt_ins.ins_lck
689: --
690: -- Call to raise any errors on multi-message list
691: hr_multi_message.end_validation_set;
692: --
693: hr_utility.set_location('Leaving:'||l_proc,10);
694: end ins;
695: --
696: -- ----------------------------------------------------------------------------
697: -- |---------------------------------< ins >----------------------------------|
743: l_rec ben_jrt_shd.g_rec_type;
744: l_proc varchar2(72) := g_package||'ins';
745: --
746: Begin
747: hr_utility.set_location('Entering:'||l_proc, 5);
748: --
749: -- Call conversion function to turn arguments into the
750: -- p_rec structure.
751: --
809: p_effective_end_date := l_rec.effective_end_date;
810: p_object_version_number := l_rec.object_version_number;
811: --
812: --
813: hr_utility.set_location(' Leaving:'||l_proc, 10);
814: End ins;
815: --
816: end ben_jrt_ins;