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: --
75: where apl_profile_access_id = p_rec.apl_profile_access_id;
76: --
77: --
78: --
79: hr_utility.set_location(' Leaving:'||l_proc, 10);
80: --
81: Exception
82: When hr_api.check_integrity_violated Then
83: -- A check constraint has been violated
137: --
138: l_proc varchar2(72) := g_package||'pre_update';
139: --
140: Begin
141: hr_utility.set_location('Entering:'||l_proc, 5);
142: --
143: hr_utility.set_location(' Leaving:'||l_proc, 10);
144: End pre_update;
145: --
139: --
140: Begin
141: hr_utility.set_location('Entering:'||l_proc, 5);
142: --
143: hr_utility.set_location(' Leaving:'||l_proc, 10);
144: End pre_update;
145: --
146: -- ----------------------------------------------------------------------------
147: -- |-----------------------------< post_update >------------------------------|
181: --
182: l_proc varchar2(72) := g_package||'post_update';
183: --
184: Begin
185: hr_utility.set_location('Entering:'||l_proc, 5);
186: begin
187: --
188: irc_apa_rku.after_update
189: (p_apl_profile_access_id
207: ,p_hook_type => 'AU');
208: --
209: end;
210: --
211: hr_utility.set_location(' Leaving:'||l_proc, 10);
212: End post_update;
213: --
214: -- ----------------------------------------------------------------------------
215: -- |-----------------------------< convert_defs >-----------------------------|
281: --
282: l_proc varchar2(72) := g_package||'upd';
283: --
284: Begin
285: hr_utility.set_location('Entering:'||l_proc, 5);
286: --
287: -- We must lock the row which we need to update.
288: --
289: irc_apa_shd.lck
335: l_rec irc_apa_shd.g_rec_type;
336: l_proc varchar2(72) := g_package||'upd';
337: --
338: Begin
339: hr_utility.set_location('Entering:'||l_proc, 5);
340: --
341: -- Call conversion function to turn arguments into the
342: -- l_rec structure.
343: --
356: (l_rec
357: );
358: p_object_version_number := l_rec.object_version_number;
359: --
360: hr_utility.set_location(' Leaving:'||l_proc, 10);
361: End upd;
362: --
363: end irc_apa_upd;