50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure insert_dml
54: (p_rec in out nocopy irc_idt_shd.g_rec_type
55: ) is
56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: --
94: ,empty_clob()
95: ,empty_clob()
96: );
97: --
98: irc_idt_shd.clob_dml(p_rec => p_rec
99: ,p_api_updating => false);
100: --
101: hr_utility.set_location(' Leaving:'||l_proc, 10);
102: Exception
102: Exception
103: When hr_api.check_integrity_violated Then
104: -- A check constraint has been violated
105: --
106: irc_idt_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When hr_api.parent_integrity_violated Then
109: -- Parent integrity has been violated
110: --
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When hr_api.parent_integrity_violated Then
109: -- Parent integrity has been violated
110: --
111: irc_idt_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When hr_api.unique_integrity_violated Then
114: -- Unique integrity has been violated
115: --
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When hr_api.unique_integrity_violated Then
114: -- Unique integrity has been violated
115: --
116: irc_idt_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When Others Then
119: --
120: Raise;
157: --
158: -- {End Of Comments}
159: -- ----------------------------------------------------------------------------
160: Procedure pre_insert
161: (p_rec in out nocopy irc_idt_shd.g_rec_type
162: ,p_default_posting_id in number
163: ) is
164: --
165: l_proc varchar2(72) := g_package||'pre_insert';
204: --
205: -- {End Of Comments}
206: -- ----------------------------------------------------------------------------
207: Procedure post_insert
208: (p_rec in irc_idt_shd.g_rec_type
209: ) is
210: --
211: l_proc varchar2(72) := g_package||'post_insert';
212: --
259: -- ----------------------------------------------------------------------------
260: -- |---------------------------------< ins >----------------------------------|
261: -- ----------------------------------------------------------------------------
262: Procedure ins
263: (p_rec in out nocopy irc_idt_shd.g_rec_type
264: ,p_default_posting_id in number
265: ) is
266: --
267: l_proc varchar2(72) := g_package||'ins';
313: ,p_image_url in varchar2
314: ,p_image_url_alt in varchar2
315: ) is
316: --
317: l_rec irc_idt_shd.g_rec_type;
318: l_proc varchar2(72) := g_package||'ins';
319: --
320: Begin
321: hr_utility.set_location('Entering:'||l_proc, 5);
323: -- Call conversion function to turn arguments into the
324: -- p_rec structure.
325: --
326: l_rec :=
327: irc_idt_shd.convert_args
328: (null
329: ,p_language
330: ,p_source_language
331: ,p_org_name