5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' per_pat_upd.'; -- Global package name
9: g_debug boolean := hr_utility.debug_enabled;
10: --
11: -- ----------------------------------------------------------------------------
12: -- |------------------------------< update_dml >------------------------------|
13: -- ----------------------------------------------------------------------------
80:
81: --9383452
82: --
83: Begin
84: hr_utility.set_location('Entering:'||l_proc, 5);
85: --
86: -- Increment the object version
87: p_rec.object_version_number := p_rec.object_version_number + 1;
88: --
181:
182: end if;
183: -- end fix9383452
184: --
185: hr_utility.set_location(' Leaving:'||l_proc, 10);
186: --
187: Exception
188: When hr_api.check_integrity_violated Then
189: -- A check constraint has been violated
243: --
244: l_proc varchar2(72) := g_package||'pre_update';
245: --
246: Begin
247: hr_utility.set_location('Entering:'||l_proc, 5);
248: --
249: hr_utility.set_location(' Leaving:'||l_proc, 10);
250: End pre_update;
251: --
245: --
246: Begin
247: hr_utility.set_location('Entering:'||l_proc, 5);
248: --
249: hr_utility.set_location(' Leaving:'||l_proc, 10);
250: End pre_update;
251: --
252: -- ----------------------------------------------------------------------------
253: -- |-----------------------------< post_update >------------------------------|
288: --
289: l_proc varchar2(72) := g_package||'post_update';
290: --
291: Begin
292: hr_utility.set_location('Entering:'||l_proc, 5);
293: begin
294: --
295: per_pat_rku.after_update
296: (p_effective_date => p_effective_date
535: ,p_hook_type => 'AU');
536: --
537: end;
538: --
539: hr_utility.set_location(' Leaving:'||l_proc, 10);
540: End post_update;
541: --
542: -- ----------------------------------------------------------------------------
543: -- |-----------------------------< convert_defs >-----------------------------|
830: --
831: l_proc varchar2(72) := g_package||'upd';
832: --
833: Begin
834: hr_utility.set_location('Entering:'||l_proc, 5);
835: --
836: -- We must lock the row which we need to update.
837: --
838: per_pat_shd.lck
942: l_rec per_pat_shd.g_rec_type;
943: l_proc varchar2(72) := g_package||'upd';
944: --
945: Begin
946: hr_utility.set_location('Entering:'||l_proc, 5);
947: --
948: -- Call conversion function to turn arguments into the
949: -- l_rec structure.
950: --
1019: ,l_rec
1020: );
1021: p_object_version_number := l_rec.object_version_number;
1022: --
1023: hr_utility.set_location(' Leaving:'||l_proc, 10);
1024: End upd;
1025: --
1026: end per_pat_upd;