[Home] [Help]
24: --
25: l_proc varchar2(72) := g_package||'set_base_key_value';
26: --
27: Begin
28: hr_utility.set_location('Entering:'||l_proc, 10);
29: --
30: ben_cpd_ins.g_pl_id_i := p_pl_id;
31: ben_cpd_ins.g_lf_evt_ocrd_dt_i := p_lf_evt_ocrd_dt;
32: ben_cpd_ins.g_oipl_id_i := p_oipl_id;
30: ben_cpd_ins.g_pl_id_i := p_pl_id;
31: ben_cpd_ins.g_lf_evt_ocrd_dt_i := p_lf_evt_ocrd_dt;
32: ben_cpd_ins.g_oipl_id_i := p_oipl_id;
33: --
34: hr_utility.set_location(' Leaving:'||l_proc, 20);
35: End set_base_key_value;
36: --
37: --
38: -- ----------------------------------------------------------------------------
84: --
85: l_proc varchar2(72) := g_package||'insert_dml';
86: --
87: Begin
88: hr_utility.set_location('Entering:'||l_proc, 5);
89: p_rec.object_version_number := 1; -- Initialise the object version
90: --
91: ben_cpd_shd.g_api_dml := true; -- Set the api dml status
92: --
284: );
285: --
286: ben_cpd_shd.g_api_dml := false; -- Unset the api dml status
287: --
288: hr_utility.set_location(' Leaving:'||l_proc, 10);
289: Exception
290: When hr_api.check_integrity_violated Then
291: -- A check constraint has been violated
292: ben_cpd_shd.g_api_dml := false; -- Unset the api dml status
361: l_proc varchar2(72) := g_package||'pre_insert';
362: l_exists varchar2(1);
363: --
364: Begin
365: hr_utility.set_location('Entering:'||l_proc, 5);
366: --
367: If (ben_cpd_ins.g_pl_id_i is not null or
368: ben_cpd_ins.g_lf_evt_ocrd_dt_i is not null or
369: ben_cpd_ins.g_oipl_id_i is not null) Then
407: Fetch C_Sel1 Into p_rec.oipl_id;
408: Close C_Sel1; */
409: End If;
410: --
411: hr_utility.set_location(' Leaving:'||l_proc, 10);
412: End pre_insert;
413: --
414: -- ----------------------------------------------------------------------------
415: -- |-----------------------------< post_insert >------------------------------|
449: --
450: l_proc varchar2(72) := g_package||'post_insert';
451: --
452: Begin
453: hr_utility.set_location('Entering:'||l_proc, 5);
454: begin
455: --
456: ben_cpd_rki.after_insert
457: (p_pl_id
651: ,p_hook_type => 'AI');
652: --
653: end;
654: --
655: hr_utility.set_location(' Leaving:'||l_proc, 10);
656: End post_insert;
657: --
658: -- ----------------------------------------------------------------------------
659: -- |---------------------------------< ins >----------------------------------|
664: --
665: l_proc varchar2(72) := g_package||'ins';
666: --
667: Begin
668: hr_utility.set_location('Entering:'||l_proc, 5);
669: --
670: -- Call the supporting insert validate operations
671: --
672: ben_cpd_bus.insert_validate
692: --
693: -- Call to raise any errors on multi-message list
694: hr_multi_message.end_validation_set;
695: --
696: hr_utility.set_location('Leaving:'||l_proc, 20);
697: end ins;
698: --
699: -- ----------------------------------------------------------------------------
700: -- |---------------------------------< ins >----------------------------------|
803: l_rec ben_cpd_shd.g_rec_type;
804: l_proc varchar2(72) := g_package||'ins';
805: --
806: Begin
807: hr_utility.set_location('Entering:'||l_proc, 5);
808: --
809: -- Call conversion function to turn arguments into the
810: -- p_rec structure.
811: --
922: -- are specified as an OUT's we must set these values.
923: --
924: p_object_version_number := l_rec.object_version_number;
925: --
926: hr_utility.set_location(' Leaving:'||l_proc, 10);
927: End ins;
928: --
929: end ben_cpd_ins;