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: --
81: where chat_id = p_rec.chat_id;
82: --
83: --
84: --
85: hr_utility.set_location(' Leaving:'||l_proc, 10);
86: --
87: Exception
88: When hr_api.check_integrity_violated Then
89: -- A check constraint has been violated
143: --
144: l_proc varchar2(72) := g_package||'pre_update';
145: --
146: Begin
147: hr_utility.set_location('Entering:'||l_proc, 5);
148: --
149: hr_utility.set_location(' Leaving:'||l_proc, 10);
150: End pre_update;
151: --
145: --
146: Begin
147: hr_utility.set_location('Entering:'||l_proc, 5);
148: --
149: hr_utility.set_location(' Leaving:'||l_proc, 10);
150: End pre_update;
151: --
152: -- ----------------------------------------------------------------------------
153: -- |-----------------------------< 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: ota_cha_rku.after_update
196: (p_effective_date => p_effective_date
239: ,p_hook_type => 'AU');
240: --
241: end;
242: --
243: hr_utility.set_location(' Leaving:'||l_proc, 10);
244: End post_update;
245: --
246: -- ----------------------------------------------------------------------------
247: -- |-----------------------------< convert_defs >-----------------------------|
338: --
339: l_proc varchar2(72) := g_package||'upd';
340: --
341: Begin
342: hr_utility.set_location('Entering:'||l_proc, 5);
343: --
344: -- We must lock the row which we need to update.
345: --
346: ota_cha_shd.lck
401: l_rec ota_cha_shd.g_rec_type;
402: l_proc varchar2(72) := g_package||'upd';
403: --
404: Begin
405: hr_utility.set_location('Entering:'||l_proc, 5);
406: --
407: -- Call conversion function to turn arguments into the
408: -- l_rec structure.
409: --
429: ,l_rec
430: );
431: p_object_version_number := l_rec.object_version_number;
432: --
433: hr_utility.set_location(' Leaving:'||l_proc, 10);
434: End upd;
435: --
436: end ota_cha_upd;