51: l_rec ghr_nre_shd.g_rec_type;
52: --
53: Begin
54: l_proc := g_package||'update_dml';
55: hr_utility.set_location('Entering:'||l_proc, 5);
56:
57: l_rec := p_rec;
58: --
59: -- Increment the object version
75: object_version_number = p_rec.object_version_number
76: where noac_remark_id = p_rec.noac_remark_id;
77: --
78: --
79: hr_utility.set_location(' Leaving:'||l_proc, 10);
80: --
81: Exception
82: When hr_api.check_integrity_violated Then
83: -- A check constraint has been violated
136: l_proc varchar2(72);
137: --
138: Begin
139: l_proc := g_package||'pre_update';
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: Begin
139: l_proc := g_package||'pre_update';
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: l_proc varchar2(72);
181: --
182: Begin
183: l_proc := g_package||'post_update';
184: hr_utility.set_location('Entering:'||l_proc, 5);
185: --
186: --
187: -- Start of API User Hook for post_update.
188: --
220: --
221: -- End of API User Hook for post_update.
222: --
223: --
224: hr_utility.set_location(' Leaving:'||l_proc, 10);
225: End post_update;
226: --
227: -- ----------------------------------------------------------------------------
228: -- |-----------------------------< convert_defs >-----------------------------|
274: --
275: Begin
276: --
277: l_proc := g_package||'convert_defs';
278: hr_utility.set_location('Entering:'||l_proc, 5);
279: l_rec := p_rec;
280: --
281: -- We must now examine each argument value in the
282: -- p_rec plsql record structure
308: ghr_nre_shd.g_old_rec.date_to;
309: End If;
310:
311: --
312: hr_utility.set_location(' Leaving:'||l_proc, 10);
313: --
314: exception
315: when others then
316: p_rec := l_rec;
330: l_rec ghr_nre_shd.g_rec_type;
331: --
332: Begin
333: l_proc := g_package||'upd';
334: hr_utility.set_location('Entering:'||l_proc, 5);
335: l_rec := p_rec;
336: --
337: -- We must lock the row which we need to update.
338: --
391: l_object_version_number number;
392: --
393: Begin
394: l_proc := g_package||'upd';
395: hr_utility.set_location('Entering:'||l_proc, 5);
396: l_object_version_number := p_object_version_number;
397: --
398: -- Call conversion function to turn arguments into the
399: -- l_rec structure.
418: upd(
419: p_effective_date,l_rec);
420: p_object_version_number := l_rec.object_version_number;
421: --
422: hr_utility.set_location(' Leaving:'||l_proc, 10);
423: exception
424: when others then
425: p_object_version_number := l_object_version_number;
426: raise;