55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin
59: hr_utility.set_location('Entering:'||l_proc, 5);
60: --
61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
85: where api_hook_call_id = p_rec.api_hook_call_id;
86: --
87: hr_ahc_shd.g_api_dml := false; -- Unset the api dml status
88: --
89: hr_utility.set_location(' Leaving:'||l_proc, 10);
90: --
91: Exception
92: When hr_api.check_integrity_violated Then
93: -- A check constraint has been violated
145: --
146: l_proc varchar2(72) := g_package||'pre_update';
147: --
148: Begin
149: hr_utility.set_location('Entering:'||l_proc, 5);
150: --
151: hr_utility.set_location(' Leaving:'||l_proc, 10);
152: End pre_update;
153: --
147: --
148: Begin
149: hr_utility.set_location('Entering:'||l_proc, 5);
150: --
151: hr_utility.set_location(' Leaving:'||l_proc, 10);
152: End pre_update;
153: --
154: -- ----------------------------------------------------------------------------
155: -- |-----------------------------< post_update >------------------------------|
187: --
188: l_proc varchar2(72) := g_package||'post_update';
189: --
190: Begin
191: hr_utility.set_location('Entering:'||l_proc, 5);
192: --
193: hr_utility.set_location(' Leaving:'||l_proc, 10);
194: End post_update;
195: --
189: --
190: Begin
191: hr_utility.set_location('Entering:'||l_proc, 5);
192: --
193: hr_utility.set_location(' Leaving:'||l_proc, 10);
194: End post_update;
195: --
196: -- ----------------------------------------------------------------------------
197: -- |-----------------------------< convert_defs >-----------------------------|
242: l_proc varchar2(72) := g_package||'convert_defs';
243: --
244: Begin
245: --
246: hr_utility.set_location('Entering:'||l_proc, 5);
247: --
248: -- We must now examine each argument value in the
249: -- p_rec plsql record structure
250: -- to see if a system default is being used. If a system default
298: p_rec.app_install_status :=
299: hr_ahc_shd.g_old_rec.app_install_status;
300: End If;
301: --
302: hr_utility.set_location(' Leaving:'||l_proc, 10);
303: --
304: End convert_defs;
305: --
306: -- ----------------------------------------------------------------------------
314: --
315: l_proc varchar2(72) := g_package||'upd';
316: --
317: Begin
318: hr_utility.set_location('Entering:'||l_proc, 5);
319: --
320: -- We must lock the row which we need to update.
321: --
322: hr_ahc_shd.lck
367: l_rec hr_ahc_shd.g_rec_type;
368: l_proc varchar2(72) := g_package||'upd';
369: --
370: Begin
371: hr_utility.set_location('Entering:'||l_proc, 5);
372: --
373: -- Call conversion function to turn arguments into the
374: -- l_rec structure.
375: --
398: --
399: upd(l_rec, p_effective_date);
400: p_object_version_number := l_rec.object_version_number;
401: --
402: hr_utility.set_location(' Leaving:'||l_proc, 10);
403: End upd;
404: --
405: end hr_ahc_upd;