[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_ino_ins.g_note_id_i := p_note_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: irc_ino_ins.g_note_id_i := p_note_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: End set_base_key_value;
30: --
31: --
32: -- ----------------------------------------------------------------------------
79: l_proc varchar2(72) := g_package||'insert_dml';
80: l_note_text clob;
81: --
82: Begin
83: hr_utility.set_location('Entering:'||l_proc, 5);
84: p_rec.object_version_number := 1; -- Initialise the object version
85: --
86: irc_ino_shd.g_api_dml := true; -- Set the api dml status
87: --
101: )
102: returning note_text into l_note_text;
103: --
104: if (p_rec.note_text is not null) then
105: hr_utility.set_location(l_proc, 10);
106: dbms_lob.write(l_note_text
107: ,length(p_rec.note_text)
108: ,1
109: ,p_rec.note_text);
109: ,p_rec.note_text);
110: end if;
111: irc_ino_shd.g_api_dml := false; -- Unset the api dml status
112: --
113: hr_utility.set_location(' Leaving:'||l_proc, 10);
114: Exception
115: When hr_api.check_integrity_violated Then
116: -- A check constraint has been violated
117: irc_ino_shd.g_api_dml := false; -- Unset the api dml status
184: l_proc varchar2(72) := g_package||'pre_insert';
185: l_exists varchar2(1);
186: --
187: Begin
188: hr_utility.set_location('Entering:'||l_proc, 5);
189: --
190: If (irc_ino_ins.g_note_id_i is not null) Then
191: --
192: -- Verify registered primary key values not already in use
220: Fetch C_Sel1 Into p_rec.note_id;
221: Close C_Sel1;
222: End If;
223: --
224: hr_utility.set_location(' Leaving:'||l_proc, 10);
225: End pre_insert;
226: --
227: -- ----------------------------------------------------------------------------
228: -- |-----------------------------< post_insert >------------------------------|
262: --
263: l_proc varchar2(72) := g_package||'post_insert';
264: --
265: Begin
266: hr_utility.set_location('Entering:'||l_proc, 5);
267: begin
268: --
269: irc_ino_rki.after_insert
270: (p_note_id
286: ,p_hook_type => 'AI');
287: --
288: end;
289: --
290: hr_utility.set_location(' Leaving:'||l_proc, 10);
291: End post_insert;
292: --
293: -- ----------------------------------------------------------------------------
294: -- |---------------------------------< ins >----------------------------------|
299: --
300: l_proc varchar2(72) := g_package||'ins';
301: --
302: Begin
303: hr_utility.set_location('Entering:'||l_proc, 5);
304: --
305: -- Call the supporting insert validate operations
306: --
307: irc_ino_bus.insert_validate
327: --
328: -- Call to raise any errors on multi-message list
329: hr_multi_message.end_validation_set;
330: --
331: hr_utility.set_location('Leaving:'||l_proc, 20);
332: end ins;
333: --
334: -- ----------------------------------------------------------------------------
335: -- |---------------------------------< ins >----------------------------------|
344: l_rec irc_ino_shd.g_rec_type;
345: l_proc varchar2(72) := g_package||'ins';
346: --
347: Begin
348: hr_utility.set_location('Entering:'||l_proc, 5);
349: --
350: -- Call conversion function to turn arguments into the
351: -- p_rec structure.
352: --
370: --
371: p_note_id := l_rec.note_id;
372: p_object_version_number := l_rec.object_version_number;
373: --
374: hr_utility.set_location(' Leaving:'||l_proc, 10);
375: End ins;
376: --
377: end irc_ino_ins;