55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin
59: hr_utility.set_location('Entering:'||l_proc, 5);
60: --
61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
76: where cagr_grade_id = p_rec.cagr_grade_id;
77: --
78: per_gra_shd.g_api_dml := false; -- Unset the api dml status
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
137: --
138: l_proc varchar2(72) := g_package||'pre_update';
139: --
140: Begin
141: hr_utility.set_location('Entering:'||l_proc, 5);
142: --
143: hr_utility.set_location(' Leaving:'||l_proc, 10);
144: End pre_update;
145: --
139: --
140: Begin
141: hr_utility.set_location('Entering:'||l_proc, 5);
142: --
143: hr_utility.set_location(' Leaving:'||l_proc, 10);
144: End pre_update;
145: --
146: -- ----------------------------------------------------------------------------
147: -- |-----------------------------< 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: --
186: --
187: -- Start of API User Hook for post_update.
188: --
214: --
215: -- End of API User Hook for post_update.
216: --
217: --
218: hr_utility.set_location(' Leaving:'||l_proc, 10);
219: End post_update;
220: --
221: -- ----------------------------------------------------------------------------
222: -- |-----------------------------< convert_defs >-----------------------------|
266: l_proc varchar2(72) := g_package||'convert_defs';
267: --
268: Begin
269: --
270: hr_utility.set_location('Entering:'||l_proc, 5);
271: --
272: -- We must now examine each argument value in the
273: -- p_rec plsql record structure
274: -- to see if a system default is being used. If a system default
287: per_gra_shd.g_old_rec.sequence;
288: End If;
289:
290: --
291: hr_utility.set_location(' Leaving:'||l_proc, 10);
292: --
293: End convert_defs;
294: --
295: -- ----------------------------------------------------------------------------
303: --
304: l_proc varchar2(72) := g_package||'upd';
305: --
306: Begin
307: hr_utility.set_location('Entering:'||l_proc, 5);
308: --
309: -- We must lock the row which we need to update.
310: --
311: per_gra_shd.lck
338: --
339: post_update(p_rec =>p_rec,
340: p_effective_date =>p_effective_date);
341: --
342: hr_utility.set_location(' Leaving:'||l_proc, 10);
343: --
344: End upd;
345: --
346: -- ----------------------------------------------------------------------------
359: l_rec per_gra_shd.g_rec_type;
360: l_proc varchar2(72) := g_package||'upd';
361: --
362: Begin
363: hr_utility.set_location('Entering:'||l_proc, 5);
364: --
365: -- Call conversion function to turn arguments into the
366: -- l_rec structure.
367: --
382: upd(p_rec => l_rec,
383: p_effective_date =>p_effective_date);
384: p_object_version_number := l_rec.object_version_number;
385: --
386: hr_utility.set_location(' Leaving:'||l_proc, 10);
387: End upd;
388: --
389: end per_gra_upd;