[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: per_abc_ins.g_absence_case_id_i := p_absence_case_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: per_abc_ins.g_absence_case_id_i := p_absence_case_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: End set_base_key_value;
30: --
31: --
32: -- ----------------------------------------------------------------------------
78: --
79: l_proc varchar2(72) := g_package||'insert_dml';
80: --
81: Begin
82: hr_utility.set_location('Entering:'||l_proc, 5);
83: p_rec.object_version_number := 1; -- Initialise the object version
84: --
85: per_abc_shd.g_api_dml := true; -- Set the api dml status
86: --
232: );
233: --
234: per_abc_shd.g_api_dml := false; -- Unset the api dml status
235: --
236: hr_utility.set_location(' Leaving:'||l_proc, 10);
237: Exception
238: When hr_api.check_integrity_violated Then
239: -- A check constraint has been violated
240: per_abc_shd.g_api_dml := false; -- Unset the api dml status
307: l_proc varchar2(72) := g_package||'pre_insert';
308: l_exists varchar2(1);
309: --
310: Begin
311: hr_utility.set_location('Entering:'||l_proc, 5);
312: --
313: If (per_abc_ins.g_absence_case_id_i is not null) Then
314: --
315: -- Verify registered primary key values not already in use
343: Fetch C_Sel1 Into p_rec.absence_case_id;
344: Close C_Sel1;
345: End If;
346: --
347: hr_utility.set_location(' Leaving:'||l_proc, 10);
348: End pre_insert;
349: --
350: -- ----------------------------------------------------------------------------
351: -- |-----------------------------< post_insert >------------------------------|
385: --
386: l_proc varchar2(72) := g_package||'post_insert';
387: --
388: Begin
389: hr_utility.set_location('Entering:'||l_proc, 5);
390: begin
391: --
392: per_abc_rki.after_insert
393: (p_absence_case_id
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 >----------------------------------|
554: --
555: l_proc varchar2(72) := g_package||'ins';
556: --
557: Begin
558: hr_utility.set_location('Entering:'||l_proc, 5);
559: --
560: -- Call the supporting insert validate operations
561: --
562: per_abc_bus.insert_validate
582: --
583: -- Call to raise any errors on multi-message list
584: hr_multi_message.end_validation_set;
585: --
586: hr_utility.set_location('Leaving:'||l_proc, 20);
587: end ins;
588: --
589: -- ----------------------------------------------------------------------------
590: -- |---------------------------------< ins >----------------------------------|
665: l_rec per_abc_shd.g_rec_type;
666: l_proc varchar2(72) := g_package||'ins';
667: --
668: Begin
669: hr_utility.set_location('Entering:'||l_proc, 5);
670: --
671: -- Call conversion function to turn arguments into the
672: -- p_rec structure.
673: --
757: --
758: p_absence_case_id := l_rec.absence_case_id;
759: p_object_version_number := l_rec.object_version_number;
760: --
761: hr_utility.set_location(' Leaving:'||l_proc, 10);
762: End ins;
763: --
764: end per_abc_ins;