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: --
138: where training_plan_cost_id = p_rec.training_plan_cost_id;
139: --
140: --
141: --
142: hr_utility.set_location(' Leaving:'||l_proc, 10);
143: --
144: Exception
145: When hr_api.check_integrity_violated Then
146: -- A check constraint has been violated
200: --
201: l_proc varchar2(72) := g_package||'pre_update';
202: --
203: Begin
204: hr_utility.set_location('Entering:'||l_proc, 5);
205: --
206: hr_utility.set_location(' Leaving:'||l_proc, 10);
207: End pre_update;
208: --
202: --
203: Begin
204: hr_utility.set_location('Entering:'||l_proc, 5);
205: --
206: hr_utility.set_location(' Leaving:'||l_proc, 10);
207: End pre_update;
208: --
209: -- ----------------------------------------------------------------------------
210: -- |-----------------------------< post_update >------------------------------|
245: --
246: l_proc varchar2(72) := g_package||'post_update';
247: --
248: Begin
249: hr_utility.set_location('Entering:'||l_proc, 5);
250: begin
251: --
252: ota_tpc_rku.after_update
253: (p_effective_date => p_effective_date
544: ,p_hook_type => 'AU');
545: --
546: end;
547: --
548: hr_utility.set_location(' Leaving:'||l_proc, 10);
549: End post_update;
550: --
551: -- ----------------------------------------------------------------------------
552: -- |-----------------------------< convert_defs >-----------------------------|
891: --
892: l_proc varchar2(72) := g_package||'upd';
893: --
894: Begin
895: hr_utility.set_location('Entering:'||l_proc, 5);
896: --
897: -- We must lock the row which we need to update.
898: --
899: ota_tpc_shd.lck
1005: l_rec ota_tpc_shd.g_rec_type;
1006: l_proc varchar2(72) := g_package||'upd';
1007: --
1008: Begin
1009: hr_utility.set_location('Entering:'||l_proc, 5);
1010: --
1011: -- Call conversion function to turn arguments into the
1012: -- l_rec structure.
1013: --
1095: ,l_rec
1096: );
1097: p_object_version_number := l_rec.object_version_number;
1098: --
1099: hr_utility.set_location(' Leaving:'||l_proc, 10);
1100: End upd;
1101: --
1102: end ota_tpc_upd;