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: --
146: where situation_id = p_rec.situation_id;
147: --
148: --
149: --
150: hr_utility.set_location(' Leaving:'||l_proc, 10);
151: --
152: Exception
153: When hr_api.check_integrity_violated Then
154: -- A check constraint has been violated
208: --
209: l_proc varchar2(72) := g_package||'pre_update';
210: --
211: Begin
212: hr_utility.set_location('Entering:'||l_proc, 5);
213: --
214: hr_utility.set_location(' Leaving:'||l_proc, 10);
215: End pre_update;
216: --
210: --
211: Begin
212: hr_utility.set_location('Entering:'||l_proc, 5);
213: --
214: hr_utility.set_location(' Leaving:'||l_proc, 10);
215: End pre_update;
216: --
217: -- ----------------------------------------------------------------------------
218: -- |-----------------------------< post_update >------------------------------|
253: --
254: l_proc varchar2(72) := g_package||'post_update';
255: --
256: Begin
257: hr_utility.set_location('Entering:'||l_proc, 5);
258: begin
259: --
260: pqh_los_rku.after_update
261: (p_effective_date => p_effective_date
564: ,p_hook_type => 'AU');
565: --
566: end;
567: --
568: hr_utility.set_location(' Leaving:'||l_proc, 10);
569: End post_update;
570: --
571: -- ----------------------------------------------------------------------------
572: -- |-----------------------------< convert_defs >-----------------------------|
923: --
924: l_proc varchar2(72) := g_package||'upd';
925: --
926: Begin
927: hr_utility.set_location('Entering:'||l_proc, 5);
928: --
929: -- We must lock the row which we need to update.
930: --
931: pqh_los_shd.lck
1051: l_rec pqh_los_shd.g_rec_type;
1052: l_proc varchar2(72) := g_package||'upd';
1053: --
1054: Begin
1055: hr_utility.set_location('Entering:'||l_proc, 5);
1056: --
1057: -- Call conversion function to turn arguments into the
1058: -- l_rec structure.
1059: --
1144: ,l_rec
1145: );
1146: p_object_version_number := l_rec.object_version_number;
1147: --
1148: hr_utility.set_location(' Leaving:'||l_proc, 10);
1149: End upd;
1150: --
1151: end pqh_los_upd;