57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
60: Begin
61: hr_utility.set_location('Entering:'||l_proc, 5);
62: --
63: -- Increment the object version
64: p_rec.object_version_number := p_rec.object_version_number + 1;
65: --
77: where communication_topic_id = p_rec.communication_topic_id;
78: --
79: --
80: --
81: hr_utility.set_location(' Leaving:'||l_proc, 10);
82: --
83: Exception
84: When hr_api.check_integrity_violated Then
85: -- A check constraint has been violated
139: --
140: l_proc varchar2(72) := g_package||'pre_update';
141: --
142: Begin
143: hr_utility.set_location('Entering:'||l_proc, 5);
144: --
145: hr_utility.set_location(' Leaving:'||l_proc, 10);
146: End pre_update;
147: --
141: --
142: Begin
143: hr_utility.set_location('Entering:'||l_proc, 5);
144: --
145: hr_utility.set_location(' Leaving:'||l_proc, 10);
146: End pre_update;
147: --
148: -- ----------------------------------------------------------------------------
149: -- |-----------------------------< post_update >------------------------------|
184: --
185: l_proc varchar2(72) := g_package||'post_update';
186: --
187: Begin
188: hr_utility.set_location('Entering:'||l_proc, 5);
189: begin
190: --
191: irc_cmt_rku.after_update
192: (p_effective_date => p_effective_date
219: ,p_hook_type => 'AU');
220: --
221: end;
222: --
223: hr_utility.set_location(' Leaving:'||l_proc, 10);
224: End post_update;
225: --
226: -- ----------------------------------------------------------------------------
227: -- |-----------------------------< convert_defs >-----------------------------|
302: --
303: l_proc varchar2(72) := g_package||'upd';
304: --
305: Begin
306: hr_utility.set_location('Entering:'||l_proc, 5);
307: --
308: -- We must lock the row which we need to update.
309: --
310: irc_cmt_shd.lck
361: l_rec irc_cmt_shd.g_rec_type;
362: l_proc varchar2(72) := g_package||'upd';
363: --
364: Begin
365: hr_utility.set_location('Entering:'||l_proc, 5);
366: --
367: -- Call conversion function to turn arguments into the
368: -- l_rec structure.
369: --
385: ,l_rec
386: );
387: p_object_version_number := l_rec.object_version_number;
388: --
389: hr_utility.set_location(' Leaving:'||l_proc, 10);
390: End upd;
391: --
392: end irc_cmt_upd;