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: --
85: where org_structure_version_id = p_rec.org_structure_version_id;
86: --
87: per_osv_shd.g_api_dml := false; -- Unset the api dml status
88: --
89: hr_utility.set_location(' Leaving:'||l_proc, 10);
90: --
91: Exception
92: When hr_api.check_integrity_violated Then
93: -- A check constraint has been violated
147: --
148: l_proc varchar2(72) := g_package||'pre_update';
149: --
150: Begin
151: hr_utility.set_location('Entering:'||l_proc, 5);
152: --
153: hr_utility.set_location(' Leaving:'||l_proc, 10);
154: End pre_update;
155: --
149: --
150: Begin
151: hr_utility.set_location('Entering:'||l_proc, 5);
152: --
153: hr_utility.set_location(' Leaving:'||l_proc, 10);
154: End pre_update;
155: --
156: -- ----------------------------------------------------------------------------
157: -- |-----------------------------< post_update >------------------------------|
192: --
193: l_proc varchar2(72) := g_package||'post_update';
194: --
195: Begin
196: hr_utility.set_location('Entering:'||l_proc, 5);
197: begin
198: --
199: per_osv_rku.after_update
200: (p_effective_date => p_effective_date
259: ,p_hook_type => 'AU');
260: --
261: end;
262: --
263: hr_utility.set_location(' Leaving:'||l_proc, 10);
264: End post_update;
265: --
266: -- ----------------------------------------------------------------------------
267: -- |-----------------------------< convert_defs >-----------------------------|
375: --
376: l_proc varchar2(72) := g_package||'upd';
377: --
378: Begin
379: hr_utility.set_location('Entering:'||l_proc, 5);
380: --
381: -- We must lock the row which we need to update.
382: --
383: per_osv_shd.lck
436: l_rec per_osv_shd.g_rec_type;
437: l_proc varchar2(72) := g_package||'upd';
438: --
439: Begin
440: hr_utility.set_location('Entering:'||l_proc, 5);
441: --
442: -- Call conversion function to turn arguments into the
443: -- l_rec structure.
444: --
469: ,p_gap_warning);
470:
471: p_object_version_number := l_rec.object_version_number;
472: --
473: hr_utility.set_location(' Leaving:'||l_proc, 10);
474: End upd;
475: --
476: end per_osv_upd;