49: --
50: l_proc varchar2(72) := g_package||'update_dml';
51: --
52: Begin
53: hr_utility.set_location('Entering:'||l_proc, 5);
54: --
55: -- Increment the object version
56: --
57: p_rec.object_version_number := p_rec.object_version_number + 1;
71: object_version_number = p_rec.object_version_number
72: where noac_remark_id = p_rec.noac_remark_id;
73: --
74: --
75: hr_utility.set_location(' Leaving:'||l_proc, 10);
76: --
77: Exception
78: When hr_api.check_integrity_violated Then
79: -- A check constraint has been violated
127: --
128: l_proc varchar2(72) := g_package||'pre_update';
129: --
130: Begin
131: hr_utility.set_location('Entering:'||l_proc, 5);
132: --
133: hr_utility.set_location(' Leaving:'||l_proc, 10);
134: End pre_update;
135: --
129: --
130: Begin
131: hr_utility.set_location('Entering:'||l_proc, 5);
132: --
133: hr_utility.set_location(' Leaving:'||l_proc, 10);
134: End pre_update;
135: --
136: -- ----------------------------------------------------------------------------
137: -- |-----------------------------< post_update >------------------------------|
170: --
171: l_proc varchar2(72) := g_package||'post_update';
172: --
173: Begin
174: hr_utility.set_location('Entering:'||l_proc, 5);
175: --
176: --
177: -- Start of API User Hook for post_update.
178: --
210: --
211: -- End of API User Hook for post_update.
212: --
213: --
214: hr_utility.set_location(' Leaving:'||l_proc, 10);
215: End post_update;
216: --
217: -- ----------------------------------------------------------------------------
218: -- |-----------------------------< convert_defs >-----------------------------|
262: l_proc varchar2(72) := g_package||'convert_defs';
263: --
264: Begin
265: --
266: hr_utility.set_location('Entering:'||l_proc, 5);
267: --
268: -- We must now examine each argument value in the
269: -- p_rec plsql record structure
270: -- to see if a system default is being used. If a system default
295: ghr_nre_shd.g_old_rec.date_to;
296: End If;
297:
298: --
299: hr_utility.set_location(' Leaving:'||l_proc, 10);
300: --
301: End convert_defs;
302: --
303: -- ----------------------------------------------------------------------------
311: --
312: l_proc varchar2(72) := g_package||'upd';
313: --
314: Begin
315: hr_utility.set_location('Entering:'||l_proc, 5);
316: --
317: -- We must lock the row which we need to update.
318: --
319: ghr_nre_shd.lck
365: l_rec ghr_nre_shd.g_rec_type;
366: l_proc varchar2(72) := g_package||'upd';
367: --
368: Begin
369: hr_utility.set_location('Entering:'||l_proc, 5);
370: --
371: -- Call conversion function to turn arguments into the
372: -- l_rec structure.
373: --
391: upd(
392: p_effective_date,l_rec);
393: p_object_version_number := l_rec.object_version_number;
394: --
395: hr_utility.set_location(' Leaving:'||l_proc, 10);
396: End upd;
397: --
398: end ghr_nre_upd;