[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: hr_cle_ins.g_soc_ins_contr_lvls_id_i := p_soc_ins_contr_lvls_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: hr_cle_ins.g_soc_ins_contr_lvls_id_i := p_soc_ins_contr_lvls_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 hr_de_soc_ins_contr_lvls_f.last_updated_by%TYPE;
102: l_last_update_login hr_de_soc_ins_contr_lvls_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;
276: ,l_last_update_login
277: );
278: --
279: --
280: hr_utility.set_location(' Leaving:'||l_proc, 15);
281: --
282: Exception
283: When hr_api.check_integrity_violated Then
284: -- A check constraint has been violated
308: --
309: l_proc varchar2(72) := g_package||'insert_dml';
310: --
311: Begin
312: hr_utility.set_location('Entering:'||l_proc, 5);
313: --
314: hr_cle_ins.dt_insert_dml
315: (p_rec => p_rec
316: ,p_effective_date => p_effective_date
318: ,p_validation_start_date => p_validation_start_date
319: ,p_validation_end_date => p_validation_end_date
320: );
321: --
322: hr_utility.set_location(' Leaving:'||l_proc, 10);
323: End insert_dml;
324: --
325: -- ----------------------------------------------------------------------------
326: -- |------------------------------< pre_insert >------------------------------|
380: l_proc varchar2(72) := g_package||'pre_insert';
381: l_exists varchar2(1);
382: --
383: Begin
384: hr_utility.set_location('Entering:'||l_proc, 5);
385: --
386: If (hr_cle_ins.g_soc_ins_contr_lvls_id_i is not null) Then
387: --
388: -- Verify registered primary key values not already in use
417: Close C_Sel1;
418: End If;
419: --
420: --
421: hr_utility.set_location(' Leaving:'||l_proc, 10);
422: End pre_insert;
423: --
424: -- ----------------------------------------------------------------------------
425: -- |----------------------------< post_insert >-------------------------------|
463: --
464: l_proc varchar2(72) := g_package||'post_insert';
465: --
466: Begin
467: hr_utility.set_location('Entering:'||l_proc, 5);
468: begin
469: --
470: hr_cle_rki.after_insert
471: (p_effective_date
593: ,p_hook_type => 'AI');
594: --
595: end;
596: --
597: hr_utility.set_location(' Leaving:'||l_proc, 10);
598: End post_insert;
599: --
600: -- ----------------------------------------------------------------------------
601: -- |-------------------------------< ins_lck >--------------------------------|
645: l_validation_start_date date;
646: l_validation_end_date date;
647: --
648: Begin
649: hr_utility.set_location('Entering:'||l_proc, 5);
650: --
651: -- Validate the datetrack mode mode getting the validation start
652: -- and end dates for the specified datetrack operation.
653: --
666: --
667: p_validation_start_date := l_validation_start_date;
668: p_validation_end_date := l_validation_end_date;
669: --
670: hr_utility.set_location(' Leaving:'||l_proc, 10);
671: --
672: End ins_lck;
673: --
674: -- ----------------------------------------------------------------------------
684: l_validation_start_date date;
685: l_validation_end_date date;
686: --
687: Begin
688: hr_utility.set_location('Entering:'||l_proc, 5);
689: --
690: -- Call the lock operation
691: --
692: hr_cle_ins.ins_lck
736: ,p_validation_start_date => l_validation_start_date
737: ,p_validation_end_date => l_validation_end_date
738: );
739: --
740: hr_utility.set_location('Leaving:'||l_proc,10);
741: end ins;
742: --
743: -- ----------------------------------------------------------------------------
744: -- |---------------------------------< ins >----------------------------------|
804: l_rec hr_cle_shd.g_rec_type;
805: l_proc varchar2(72) := g_package||'ins';
806: --
807: Begin
808: hr_utility.set_location('Entering:'||l_proc, 5);
809: --
810: -- Call conversion function to turn arguments into the
811: -- p_rec structure.
812: --
884: p_effective_end_date := l_rec.effective_end_date;
885: p_object_version_number := l_rec.object_version_number;
886: --
887: --
888: hr_utility.set_location(' Leaving:'||l_proc, 10);
889: End ins;
890: --
891: end hr_cle_ins;