[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_ias_ins.g_assignment_status_id_i := p_assignment_status_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: irc_ias_ins.g_assignment_status_id_i := p_assignment_status_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: irc_ias_shd.g_api_dml := true; -- Set the api dml status
86: --
104: );
105: --
106: irc_ias_shd.g_api_dml := false; -- Unset the api dml status
107: --
108: hr_utility.set_location(' Leaving:'||l_proc, 10);
109: Exception
110: When hr_api.check_integrity_violated Then
111: -- A check constraint has been violated
112: irc_ias_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_ias_ins.g_assignment_status_id_i is not null) Then
191: --
192: -- Verify registered primary key values not already in use
220: Fetch C_Sel1 Into p_rec.assignment_status_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_ias_rki.after_insert
270: (
291: ,p_hook_type => 'AI');
292: --
293: end;
294: --
295: hr_utility.set_location(' Leaving:'||l_proc, 10);
296: End post_insert;
297: --
298: -- ----------------------------------------------------------------------------
299: -- |---------------------------------< ins >----------------------------------|
304: --
305: l_proc varchar2(72) := g_package||'ins';
306: --
307: Begin
308: hr_utility.set_location('Entering:'||l_proc, 5);
309: --
310: -- Call the supporting insert validate operations
311: --
312: irc_ias_bus.insert_validate (p_rec);
326: irc_ias_ins.post_insert (p_rec );
327: --
328: -- Call to raise any errors on multi-message list
329: hr_multi_message.end_validation_set;
330: hr_utility.set_location('Leaving:'||l_proc, 20);
331: end ins;
332: --
333: -- ----------------------------------------------------------------------------
334: -- |---------------------------------< ins >----------------------------------|
346: l_rec irc_ias_shd.g_rec_type;
347: l_proc varchar2(72) := g_package||'ins';
348: --
349: Begin
350: hr_utility.set_location('Entering:'||l_proc, 5);
351: --
352: -- Call conversion function to turn arguments into the
353: -- p_rec structure.
354: --
372: --
373: p_assignment_status_id := l_rec.assignment_status_id;
374: p_object_version_number := l_rec.object_version_number;
375: --
376: hr_utility.set_location(' Leaving:'||l_proc, 10);
377: End ins;
378: --
379: end irc_ias_ins;