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: --
104: where organization_structure_id = p_rec.organization_structure_id;
105: --
106: per_ors_shd.g_api_dml := false; -- Unset the api dml status
107: --
108: hr_utility.set_location(' Leaving:'||l_proc, 10);
109: --
110: Exception
111: When hr_api.check_integrity_violated Then
112: -- A check constraint has been violated
166: --
167: l_proc varchar2(72) := g_package||'pre_update';
168: --
169: Begin
170: hr_utility.set_location('Entering:'||l_proc, 5);
171: --
172: hr_utility.set_location(' Leaving:'||l_proc, 10);
173: End pre_update;
174: --
168: --
169: Begin
170: hr_utility.set_location('Entering:'||l_proc, 5);
171: --
172: hr_utility.set_location(' Leaving:'||l_proc, 10);
173: End pre_update;
174: --
175: -- ----------------------------------------------------------------------------
176: -- |-----------------------------< post_update >------------------------------|
211: --
212: l_proc varchar2(72) := g_package||'post_update';
213: --
214: Begin
215: hr_utility.set_location('Entering:'||l_proc, 5);
216: begin
217: --
218: per_ors_rku.after_update
219: (p_effective_date => p_effective_date
354: ,p_hook_type => 'AU');
355: --
356: end;
357: --
358: hr_utility.set_location(' Leaving:'||l_proc, 10);
359: End post_update;
360: --
361: -- ----------------------------------------------------------------------------
362: -- |-----------------------------< convert_defs >-----------------------------|
545: --
546: l_proc varchar2(72) := g_package||'upd';
547: --
548: Begin
549: hr_utility.set_location('Entering:'||l_proc, 5);
550: --
551: -- We must lock the row which we need to update.
552: --
553: per_ors_shd.lck
625: l_rec per_ors_shd.g_rec_type;
626: l_proc varchar2(72) := g_package||'upd';
627: --
628: Begin
629: hr_utility.set_location('Entering:'||l_proc, 5);
630: --
631: -- Call conversion function to turn arguments into the
632: -- l_rec structure.
633: --
676: ,l_rec
677: );
678: p_object_version_number := l_rec.object_version_number;
679: --
680: hr_utility.set_location(' Leaving:'||l_proc, 10);
681: End upd;
682: --
683: end per_ors_upd;