[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_cty_ins.g_comptncy_rt_id_i := p_comptncy_rt_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: ben_cty_ins.g_comptncy_rt_id_i := p_comptncy_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_comptncy_rt_f.last_updated_by%TYPE;
102: l_last_update_login ben_comptncy_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;
250: ,l_last_update_login
251: );
252: --
253: --
254: hr_utility.set_location(' Leaving:'||l_proc, 15);
255: --
256: Exception
257: When hr_api.check_integrity_violated Then
258: -- A check constraint has been violated
282: --
283: l_proc varchar2(72) := g_package||'insert_dml';
284: --
285: Begin
286: hr_utility.set_location('Entering:'||l_proc, 5);
287: --
288: ben_cty_ins.dt_insert_dml
289: (p_rec => p_rec
290: ,p_effective_date => p_effective_date
292: ,p_validation_start_date => p_validation_start_date
293: ,p_validation_end_date => p_validation_end_date
294: );
295: --
296: hr_utility.set_location(' Leaving:'||l_proc, 10);
297: End insert_dml;
298: --
299: -- ----------------------------------------------------------------------------
300: -- |------------------------------< pre_insert >------------------------------|
354: l_proc varchar2(72) := g_package||'pre_insert';
355: l_exists varchar2(1);
356: --
357: Begin
358: hr_utility.set_location('Entering:'||l_proc, 5);
359: --
360: If (ben_cty_ins.g_comptncy_rt_id_i is not null) Then
361: --
362: -- Verify registered primary key values not already in use
391: Close C_Sel1;
392: End If;
393: --
394: --
395: hr_utility.set_location(' Leaving:'||l_proc, 10);
396: End pre_insert;
397: --
398: -- ----------------------------------------------------------------------------
399: -- |----------------------------< post_insert >-------------------------------|
437: --
438: l_proc varchar2(72) := g_package||'post_insert';
439: --
440: Begin
441: hr_utility.set_location('Entering:'||l_proc, 5);
442: begin
443: --
444: ben_cty_rki.after_insert
445: (p_effective_date
541: ,p_hook_type => 'AI');
542: --
543: end;
544: --
545: hr_utility.set_location(' Leaving:'||l_proc, 10);
546: End post_insert;
547: --
548: -- ----------------------------------------------------------------------------
549: -- |-------------------------------< ins_lck >--------------------------------|
593: l_validation_start_date date;
594: l_validation_end_date date;
595: --
596: Begin
597: hr_utility.set_location('Entering:'||l_proc, 5);
598: --
599: -- Validate the datetrack mode mode getting the validation start
600: -- and end dates for the specified datetrack operation.
601: --
617: --
618: p_validation_start_date := l_validation_start_date;
619: p_validation_end_date := l_validation_end_date;
620: --
621: hr_utility.set_location(' Leaving:'||l_proc, 10);
622: --
623: End ins_lck;
624: --
625: -- ----------------------------------------------------------------------------
635: l_validation_start_date date;
636: l_validation_end_date date;
637: --
638: Begin
639: hr_utility.set_location('Entering:'||l_proc, 5);
640: --
641: -- Call the lock operation
642: --
643: ben_cty_ins.ins_lck
693: --
694: -- Call to raise any errors on multi-message list
695: hr_multi_message.end_validation_set;
696: --
697: hr_utility.set_location('Leaving:'||l_proc,10);
698: end ins;
699: --
700: -- ----------------------------------------------------------------------------
701: -- |---------------------------------< ins >----------------------------------|
748: l_rec ben_cty_shd.g_rec_type;
749: l_proc varchar2(72) := g_package||'ins';
750: --
751: Begin
752: hr_utility.set_location('Entering:'||l_proc, 5);
753: --
754: -- Call conversion function to turn arguments into the
755: -- p_rec structure.
756: --
815: p_effective_end_date := l_rec.effective_end_date;
816: p_object_version_number := l_rec.object_version_number;
817: --
818: --
819: hr_utility.set_location(' Leaving:'||l_proc, 10);
820: End ins;
821: --
822: end ben_cty_ins;