[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: --
108: );
109: --
110: irc_ias_shd.g_api_dml := false; -- Unset the api dml status
111: --
112: hr_utility.set_location(' Leaving:'||l_proc, 10);
113: Exception
114: When hr_api.check_integrity_violated Then
115: -- A check constraint has been violated
116: irc_ias_shd.g_api_dml := false; -- Unset the api dml status
188: l_proc varchar2(72) := g_package||'pre_insert';
189: l_exists varchar2(1);
190: --
191: Begin
192: hr_utility.set_location('Entering:'||l_proc, 5);
193: --
194: If (irc_ias_ins.g_assignment_status_id_i is not null) Then
195: --
196: -- Verify registered primary key values not already in use
224: Fetch C_Sel1 Into p_rec.assignment_status_id;
225: Close C_Sel1;
226: End If;
227: --
228: hr_utility.set_location(' Leaving:'||l_proc, 10);
229: End pre_insert;
230: --
231: -- ----------------------------------------------------------------------------
232: -- |-----------------------------< post_insert >------------------------------|
266: --
267: l_proc varchar2(72) := g_package||'post_insert';
268: --
269: Begin
270: hr_utility.set_location('Entering:'||l_proc, 5);
271: begin
272: --
273: irc_ias_rki.after_insert
274: (
299: ,p_hook_type => 'AI');
300: --
301: end;
302: --
303: hr_utility.set_location(' Leaving:'||l_proc, 10);
304: End post_insert;
305: --
306: -- ----------------------------------------------------------------------------
307: -- |---------------------------------< ins >----------------------------------|
312: --
313: l_proc varchar2(72) := g_package||'ins';
314: --
315: Begin
316: hr_utility.set_location('Entering:'||l_proc, 5);
317: --
318: -- Call the supporting insert validate operations
319: --
320: irc_ias_bus.insert_validate (p_rec);
334: irc_ias_ins.post_insert (p_rec );
335: --
336: -- Call to raise any errors on multi-message list
337: hr_multi_message.end_validation_set;
338: hr_utility.set_location('Leaving:'||l_proc, 20);
339: end ins;
340: --
341: -- ----------------------------------------------------------------------------
342: -- |---------------------------------< ins >----------------------------------|
356: l_rec irc_ias_shd.g_rec_type;
357: l_proc varchar2(72) := g_package||'ins';
358: --
359: Begin
360: hr_utility.set_location('Entering:'||l_proc, 5);
361: --
362: -- Call conversion function to turn arguments into the
363: -- p_rec structure.
364: --
384: --
385: p_assignment_status_id := l_rec.assignment_status_id;
386: p_object_version_number := l_rec.object_version_number;
387: --
388: hr_utility.set_location(' Leaving:'||l_proc, 10);
389: End ins;
390: --
391: end irc_ias_ins;