[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: irc_isc_ins.g_search_criteria_id_i := p_search_criteria_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: irc_isc_ins.g_search_criteria_id_i := p_search_criteria_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: End set_base_key_value;
30: --
31: --
32: -- ----------------------------------------------------------------------------
80: l_description clob;
81: l_geometry mdsys.sdo_geometry :=null;
82: --
83: Begin
84: hr_utility.set_location('Entering:'||l_proc, 5);
85: p_rec.object_version_number := 1; -- Initialise the object version
86: --
87: irc_isc_shd.g_api_dml := true; -- Set the api dml status
88: --
289: )
290: returning description into l_description;
291: --
292: if (p_rec.description is not null) then
293: hr_utility.set_location(l_proc, 10);
294: dbms_lob.write(l_description
295: ,length(p_rec.description)
296: ,1
297: ,p_rec.description);
298: end if;
299:
300: irc_isc_shd.g_api_dml := false; -- Unset the api dml status
301: --
302: hr_utility.set_location(' Leaving:'||l_proc, 20);
303: Exception
304: When hr_api.check_integrity_violated Then
305: -- A check constraint has been violated
306: irc_isc_shd.g_api_dml := false; -- Unset the api dml status
377: l_proc varchar2(72) := g_package||'pre_insert';
378: l_exists varchar2(1);
379: --
380: Begin
381: hr_utility.set_location('Entering:'||l_proc, 5);
382: --
383: If (irc_isc_ins.g_search_criteria_id_i is not null) Then
384: --
385: -- Verify registered primary key values not already in use
413: Fetch C_Sel1 Into p_rec.search_criteria_id;
414: Close C_Sel1;
415: End If;
416: --
417: hr_utility.set_location(' Leaving:'||l_proc, 10);
418: End pre_insert;
419: --
420: -- ----------------------------------------------------------------------------
421: -- |-----------------------------< post_insert >------------------------------|
456: --
457: l_proc varchar2(72) := g_package||'post_insert';
458: --
459: Begin
460: hr_utility.set_location('Entering:'||l_proc, 5);
461: begin
462: --
463: irc_isc_rki.after_insert
464: (p_effective_date => p_effective_date
665: ,p_hook_type => 'AI');
666: --
667: end;
668: --
669: hr_utility.set_location(' Leaving:'||l_proc, 10);
670: End post_insert;
671: --
672: -- ----------------------------------------------------------------------------
673: -- |---------------------------------< ins >----------------------------------|
679: --
680: l_proc varchar2(72) := g_package||'ins';
681: --
682: Begin
683: hr_utility.set_location('Entering:'||l_proc, 5);
684: --
685: -- Call the supporting insert validate operations
686: --
687: irc_isc_bus.insert_validate
709: --
710: -- Call to raise any errors on multi-message list
711: hr_multi_message.end_validation_set;
712: --
713: hr_utility.set_location('Leaving:'||l_proc, 20);
714: end ins;
715: --
716: -- ----------------------------------------------------------------------------
717: -- |---------------------------------< ins >----------------------------------|
819: l_rec irc_isc_shd.g_rec_type;
820: l_proc varchar2(72) := g_package||'ins';
821: --
822: Begin
823: hr_utility.set_location('Entering:'||l_proc, 5);
824: --
825: -- Call conversion function to turn arguments into the
826: -- p_rec structure.
827: --
938: --
939: p_search_criteria_id := l_rec.search_criteria_id;
940: p_object_version_number := l_rec.object_version_number;
941: --
942: hr_utility.set_location(' Leaving:'||l_proc, 10);
943: End ins;
944: --
945: end irc_isc_ins;