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: --
231: where complaint_id = p_rec.complaint_id;
232: --
233: --
234: --
235: hr_utility.set_location(' Leaving:'||l_proc, 10);
236: --
237: Exception
238: When hr_api.check_integrity_violated Then
239: -- A check constraint has been violated
293: --
294: l_proc varchar2(72) := g_package||'pre_update';
295: --
296: Begin
297: hr_utility.set_location('Entering:'||l_proc, 5);
298: --
299: hr_utility.set_location(' Leaving:'||l_proc, 10);
300: End pre_update;
301: --
295: --
296: Begin
297: hr_utility.set_location('Entering:'||l_proc, 5);
298: --
299: hr_utility.set_location(' Leaving:'||l_proc, 10);
300: End pre_update;
301: --
302: -- ----------------------------------------------------------------------------
303: -- |-----------------------------< post_update >------------------------------|
338: --
339: l_proc varchar2(72) := g_package||'post_update';
340: --
341: Begin
342: hr_utility.set_location('Entering:'||l_proc, 5);
343:
344: begin
345: --
346:
676:
677: end;
678:
679: --
680: hr_utility.set_location(' Leaving:'||l_proc, 10);
681: End post_update;
682: --
683: -- ----------------------------------------------------------------------------
684: -- |-----------------------------< convert_defs >-----------------------------|
1384: --
1385: l_proc varchar2(72) := g_package||'upd';
1386: --
1387: Begin
1388: hr_utility.set_location('Entering:'||l_proc, 5);
1389: --
1390: -- We must lock the row which we need to update.
1391: --
1392: ghr_cmp_shd.lck
1591: l_rec ghr_cmp_shd.g_rec_type;
1592: l_proc varchar2(72) := g_package||'upd';
1593: --
1594: Begin
1595: hr_utility.set_location('Entering:'||l_proc, 5);
1596: --
1597: -- Call conversion function to turn arguments into the
1598: -- l_rec structure.
1599: --
1769: ,l_rec
1770: );
1771: p_object_version_number := l_rec.object_version_number;
1772: --
1773: hr_utility.set_location(' Leaving:'||l_proc, 10);
1774: End upd;
1775: --
1776: end ghr_cmp_upd;