57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
60: Begin
61: hr_utility.set_location('Entering:'||l_proc, 5);
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
64: --
65: --
74: where source_form_template_id = p_rec.source_form_template_id;
75: --
76: --
77: --
78: hr_utility.set_location(' Leaving:'||l_proc, 10);
79: --
80: Exception
81: When hr_api.check_integrity_violated Then
82: -- A check constraint has been violated
136: --
137: l_proc varchar2(72) := g_package||'pre_update';
138: --
139: Begin
140: hr_utility.set_location('Entering:'||l_proc, 5);
141: --
142: hr_utility.set_location(' Leaving:'||l_proc, 10);
143: End pre_update;
144: --
138: --
139: Begin
140: hr_utility.set_location('Entering:'||l_proc, 5);
141: --
142: hr_utility.set_location(' Leaving:'||l_proc, 10);
143: End pre_update;
144: --
145: -- ----------------------------------------------------------------------------
146: -- |-----------------------------< post_update >------------------------------|
180: --
181: l_proc varchar2(72) := g_package||'post_update';
182: --
183: Begin
184: hr_utility.set_location('Entering:'||l_proc, 5);
185: begin
186: --
187: hr_sft_rku.after_update
188: (p_source_form_template_id
210: ,p_hook_type => 'AU');
211: --
212: end;
213: --
214: hr_utility.set_location(' Leaving:'||l_proc, 10);
215: End post_update;
216: --
217: -- ----------------------------------------------------------------------------
218: -- |-----------------------------< convert_defs >-----------------------------|
289: --
290: l_proc varchar2(72) := g_package||'upd';
291: --
292: Begin
293: hr_utility.set_location('Entering:'||l_proc, 5);
294: --
295: -- We must lock the row which we need to update.
296: --
297: hr_sft_shd.lck
338: l_rec hr_sft_shd.g_rec_type;
339: l_proc varchar2(72) := g_package||'upd';
340: --
341: Begin
342: hr_utility.set_location('Entering:'||l_proc, 5);
343: --
344: -- Call conversion function to turn arguments into the
345: -- l_rec structure.
346: --
360: (l_rec
361: );
362: --
363: p_object_version_number := l_rec.object_version_number;
364: hr_utility.set_location(' Leaving:'||l_proc, 10);
365: End upd;
366: --
367: end hr_sft_upd;