49: --
50: l_proc varchar2(72) := g_package||'update_dml';
51: --
52: Begin
53: hr_utility.set_location('Entering:'||l_proc, 5);
54: --
55: -- Increment the object version
56: --
57: p_rec.object_version_number := p_rec.object_version_number + 1;
90: attribute20 = p_rec.attribute20,
91: object_version_number = p_rec.object_version_number
92: where std_holiday_absences_id = p_rec.std_holiday_absences_id;
93: --
94: hr_utility.set_location(' Leaving:'||l_proc, 10);
95: --
96: Exception
97: When hr_api.check_integrity_violated Then
98: -- A check constraint has been violated
146: --
147: l_proc varchar2(72) := g_package||'pre_update';
148: --
149: Begin
150: hr_utility.set_location('Entering:'||l_proc, 5);
151: --
152: hr_utility.set_location(' Leaving:'||l_proc, 10);
153: End pre_update;
154: --
148: --
149: Begin
150: hr_utility.set_location('Entering:'||l_proc, 5);
151: --
152: hr_utility.set_location(' Leaving:'||l_proc, 10);
153: End pre_update;
154: --
155: -- ----------------------------------------------------------------------------
156: -- |-----------------------------< 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: --
194: --
195: -- Start of API User Hook for post_update.
196: begin
260: ,p_hook_type => 'AU'
261: );
262: end;
263: -- End of API User Hook for post_update.
264: hr_utility.set_location(' Leaving:'||l_proc, 10);
265: End post_update;
266: --
267: -- ----------------------------------------------------------------------------
268: -- |-----------------------------< convert_defs >-----------------------------|
313: l_proc varchar2(72) := g_package||'convert_defs';
314: --
315: Begin
316: --
317: hr_utility.set_location('Entering:'||l_proc, 5);
318: --
319: -- We must now examine each argument value in the
320: -- p_rec plsql record structure
321: -- to see if a system default is being used. If a system default
430: per_sha_shd.g_old_rec.attribute20;
431: End If;
432:
433: --
434: hr_utility.set_location(' Leaving:'||l_proc, 10);
435: --
436: End convert_defs;
437: --
438: -- ----------------------------------------------------------------------------
445: --
446: l_proc varchar2(72) := g_package||'upd';
447: --
448: Begin
449: hr_utility.set_location('Entering:'||l_proc, 5);
450: --
451: -- We must lock the row which we need to update.
452: --
453: per_sha_shd.lck
517: l_rec per_sha_shd.g_rec_type;
518: l_proc varchar2(72) := g_package||'upd';
519: --
520: Begin
521: hr_utility.set_location('Entering:'||l_proc, 5);
522: --
523: -- Call conversion function to turn arguments into the
524: -- l_rec structure.
525: --
563: --
564: upd(l_rec);
565: p_object_version_number := l_rec.object_version_number;
566: --
567: hr_utility.set_location(' Leaving:'||l_proc, 10);
568: End upd;
569: --
570: end per_sha_upd;