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: ,object_version_number = p_rec.object_version_number
77: where cal_entry_value_id = p_rec.cal_entry_value_id;
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 >------------------------------|
183: --
184: l_proc varchar2(72) := g_package||'post_update';
185: --
186: Begin
187: hr_utility.set_location('Entering:'||l_proc, 5);
188: begin
189: --
190: per_env_rku.after_update
191: (p_effective_date => p_effective_date
216: ,p_hook_type => 'AU');
217: --
218: end;
219: --
220: hr_utility.set_location(' Leaving:'||l_proc, 10);
221: End post_update;
222: --
223: -- ----------------------------------------------------------------------------
224: -- |-----------------------------< convert_defs >-----------------------------|
323: --
324: l_proc varchar2(72) := g_package||'upd';
325: --
326: Begin
327: hr_utility.set_location('Entering:'||l_proc, 5);
328: --
329: -- We must lock the row which we need to update.
330: --
331: per_env_shd.lck
383: l_rec per_env_shd.g_rec_type;
384: l_proc varchar2(72) := g_package||'upd';
385: --
386: Begin
387: hr_utility.set_location('Entering:'||l_proc, 5);
388: --
389: -- Call conversion function to turn arguments into the
390: -- l_rec structure.
391: --
414: ,l_rec
415: );
416: p_object_version_number := l_rec.object_version_number;
417: --
418: hr_utility.set_location(' Leaving:'||l_proc, 10);
419: End upd;
420: --
421: end per_env_upd;