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: --
83: where compl_claim_id = p_rec.compl_claim_id;
84: --
85: --
86: --
87: hr_utility.set_location(' Leaving:'||l_proc, 10);
88: --
89: Exception
90: When hr_api.check_integrity_violated Then
91: -- 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 >------------------------------|
190: --
191: l_proc varchar2(72) := g_package||'post_update';
192: --
193: Begin
194: hr_utility.set_location('Entering:'||l_proc, 5);
195: begin
196: --
197: ghr_ccl_rku.after_update
198: (p_effective_date => p_effective_date
226: ,p_hook_type => 'AU');
227: --
228: end;
229: --
230: hr_utility.set_location(' Leaving:'||l_proc, 10);
231: End post_update;
232: --
233: -- ----------------------------------------------------------------------------
234: -- |-----------------------------< convert_defs >-----------------------------|
337: --
338: l_proc varchar2(72) := g_package||'upd';
339: --
340: Begin
341: hr_utility.set_location('Entering:'||l_proc, 5);
342: --
343: -- We must lock the row which we need to update.
344: --
345: ghr_ccl_shd.lck
396: l_rec ghr_ccl_shd.g_rec_type;
397: l_proc varchar2(72) := g_package||'upd';
398: --
399: Begin
400: hr_utility.set_location('Entering:'||l_proc, 5);
401: --
402: -- Call conversion function to turn arguments into the
403: -- l_rec structure.
404: --
428: --
429: p_object_version_number := l_rec.object_version_number;
430:
431: --
432: hr_utility.set_location(' Leaving:'||l_proc, 10);
433: End upd;
434: --
435: end ghr_ccl_upd;