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 cwb_matrix_dtl_id = p_rec.cwb_matrix_dtl_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 >------------------------------|
187: --
188: l_proc varchar2(72) := g_package||'post_update';
189: --
190: Begin
191: hr_utility.set_location('Entering:'||l_proc, 5);
192: begin
193: --
194: ben_bcd_rku.after_update
195: (p_cwb_matrix_dtl_id
237: ,p_hook_type => 'AU');
238: --
239: end;
240: --
241: hr_utility.set_location(' Leaving:'||l_proc, 10);
242: End post_update;
243: --
244: -- ----------------------------------------------------------------------------
245: -- |-----------------------------< convert_defs >-----------------------------|
335: --
336: l_proc varchar2(72) := g_package||'upd';
337: --
338: Begin
339: hr_utility.set_location('Entering:'||l_proc, 5);
340: --
341: -- We must lock the row which we need to update.
342: --
343: ben_bcd_shd.lck
395: l_rec ben_bcd_shd.g_rec_type;
396: l_proc varchar2(72) := g_package||'upd';
397: --
398: Begin
399: hr_utility.set_location('Entering:'||l_proc, 5);
400: --
401: -- Call conversion function to turn arguments into the
402: -- l_rec structure.
403: --
422: (l_rec
423: );
424: p_object_version_number := l_rec.object_version_number;
425: --
426: hr_utility.set_location(' Leaving:'||l_proc, 10);
427: End upd;
428: --
429: end ben_bcd_upd;