[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: --
278: );
279: --
280: ben_cpd_shd.g_api_dml := false; -- Unset the api dml status
281: --
282: hr_utility.set_location(' Leaving:'||l_proc, 10);
283: Exception
284: When hr_api.check_integrity_violated Then
285: -- A check constraint has been violated
286: ben_cpd_shd.g_api_dml := false; -- Unset the api dml status
355: l_proc varchar2(72) := g_package||'pre_insert';
356: l_exists varchar2(1);
357: --
358: Begin
359: hr_utility.set_location('Entering:'||l_proc, 5);
360: --
361: If (ben_cpd_ins.g_pl_id_i is not null or
362: ben_cpd_ins.g_lf_evt_ocrd_dt_i is not null or
363: ben_cpd_ins.g_oipl_id_i is not null) Then
401: Fetch C_Sel1 Into p_rec.oipl_id;
402: Close C_Sel1; */
403: End If;
404: --
405: hr_utility.set_location(' Leaving:'||l_proc, 10);
406: End pre_insert;
407: --
408: -- ----------------------------------------------------------------------------
409: -- |-----------------------------< post_insert >------------------------------|
443: --
444: l_proc varchar2(72) := g_package||'post_insert';
445: --
446: Begin
447: hr_utility.set_location('Entering:'||l_proc, 5);
448: begin
449: --
450: ben_cpd_rki.after_insert
451: (p_pl_id
639: ,p_hook_type => 'AI');
640: --
641: end;
642: --
643: hr_utility.set_location(' Leaving:'||l_proc, 10);
644: End post_insert;
645: --
646: -- ----------------------------------------------------------------------------
647: -- |---------------------------------< ins >----------------------------------|
652: --
653: l_proc varchar2(72) := g_package||'ins';
654: --
655: Begin
656: hr_utility.set_location('Entering:'||l_proc, 5);
657: --
658: -- Call the supporting insert validate operations
659: --
660: ben_cpd_bus.insert_validate
680: --
681: -- Call to raise any errors on multi-message list
682: hr_multi_message.end_validation_set;
683: --
684: hr_utility.set_location('Leaving:'||l_proc, 20);
685: end ins;
686: --
687: -- ----------------------------------------------------------------------------
688: -- |---------------------------------< ins >----------------------------------|
783: l_rec ben_cpd_shd.g_rec_type;
784: l_proc varchar2(72) := g_package||'ins';
785: --
786: Begin
787: hr_utility.set_location('Entering:'||l_proc, 5);
788: --
789: -- Call conversion function to turn arguments into the
790: -- p_rec structure.
791: --
894: -- are specified as an OUT's we must set these values.
895: --
896: p_object_version_number := l_rec.object_version_number;
897: --
898: hr_utility.set_location(' Leaving:'||l_proc, 10);
899: End ins;
900: --
901: end ben_cpd_ins;