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: --
76: where template_data_group_id = p_rec.template_data_group_id;
77: --
78: --
79: --
80: hr_utility.set_location(' Leaving:'||l_proc, 10);
81: --
82: Exception
83: When hr_api.check_integrity_violated Then
84: -- A check constraint has been violated
138: --
139: l_proc varchar2(72) := g_package||'pre_update';
140: --
141: Begin
142: hr_utility.set_location('Entering:'||l_proc, 5);
143: --
144: hr_utility.set_location(' Leaving:'||l_proc, 10);
145: End pre_update;
146: --
140: --
141: Begin
142: hr_utility.set_location('Entering:'||l_proc, 5);
143: --
144: hr_utility.set_location(' Leaving:'||l_proc, 10);
145: End pre_update;
146: --
147: -- ----------------------------------------------------------------------------
148: -- |-----------------------------< post_update >------------------------------|
182: --
183: l_proc varchar2(72) := g_package||'post_update';
184: --
185: Begin
186: hr_utility.set_location('Entering:'||l_proc, 5);
187: begin
188: --
189: hr_tdg_rku.after_update
190: (p_template_data_group_id
212: ,p_hook_type => 'AU');
213: --
214: end;
215: --
216: hr_utility.set_location(' Leaving:'||l_proc, 10);
217: End post_update;
218: --
219: -- ----------------------------------------------------------------------------
220: -- |-----------------------------< convert_defs >-----------------------------|
290: --
291: l_proc varchar2(72) := g_package||'upd';
292: --
293: Begin
294: hr_utility.set_location('Entering:'||l_proc, 5);
295: --
296: -- We must lock the row which we need to update.
297: --
298: hr_tdg_shd.lck
339: l_rec hr_tdg_shd.g_rec_type;
340: l_proc varchar2(72) := g_package||'upd';
341: --
342: Begin
343: hr_utility.set_location('Entering:'||l_proc, 5);
344: --
345: -- Call conversion function to turn arguments into the
346: -- l_rec structure.
347: --
361: (l_rec
362: );
363: p_object_version_number := l_rec.object_version_number;
364: --
365: hr_utility.set_location(' Leaving:'||l_proc, 10);
366: End upd;
367: --
368: end hr_tdg_upd;