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: --
82: where rec_team_member_id = p_rec.rec_team_member_id;
83: --
84: --
85: --
86: hr_utility.set_location(' Leaving:'||l_proc, 10);
87: --
88: Exception
89: When hr_api.check_integrity_violated Then
90: -- A check constraint has been violated
144: --
145: l_proc varchar2(72) := g_package||'pre_update';
146: --
147: Begin
148: hr_utility.set_location('Entering:'||l_proc, 5);
149: --
150: hr_utility.set_location(' Leaving:'||l_proc, 10);
151: End pre_update;
152: --
146: --
147: Begin
148: hr_utility.set_location('Entering:'||l_proc, 5);
149: --
150: hr_utility.set_location(' Leaving:'||l_proc, 10);
151: End pre_update;
152: --
153: -- ----------------------------------------------------------------------------
154: -- |-----------------------------< post_update >------------------------------|
188: --
189: l_proc varchar2(72) := g_package||'post_update';
190: --
191: Begin
192: hr_utility.set_location('Entering:'||l_proc, 5);
193: begin
194: --
195: irc_rtm_rku.after_update
196: (p_party_id
240: ,p_hook_type => 'AU');
241: --
242: end;
243: --
244: hr_utility.set_location(' Leaving:'||l_proc, 10);
245: End post_update;
246: --
247: -- ----------------------------------------------------------------------------
248: -- |-----------------------------< convert_defs >-----------------------------|
346: --
347: l_proc varchar2(72) := g_package||'upd';
348: --
349: Begin
350: hr_utility.set_location('Entering:'||l_proc, 5);
351: --
352: -- We must lock the row which we need to update.
353: --
354: irc_rtm_shd.lck
406: l_rec irc_rtm_shd.g_rec_type;
407: l_proc varchar2(72) := g_package||'upd';
408: --
409: Begin
410: hr_utility.set_location('Entering:'||l_proc, 5);
411: --
412: -- Call conversion function to turn arguments into the
413: -- l_rec structure.
414: --
435: (l_rec
436: );
437: p_object_version_number := l_rec.object_version_number;
438: --
439: hr_utility.set_location(' Leaving:'||l_proc, 10);
440: End upd;
441: --
442: end irc_rtm_upd;