[Home] [Help]
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin
59: hr_utility.set_location('Entering:'||l_proc, 5);
60: --
61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
139: where event_id = p_rec.event_id;
140: --
141: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
142: --
143: hr_utility.set_location(' Leaving:'||l_proc, 10);
144: --
145: Exception
146: When hr_api.check_integrity_violated Then
147: -- A check constraint has been violated
199: --
200: l_proc varchar2(72) := g_package||'pre_update';
201: --
202: Begin
203: hr_utility.set_location('Entering:'||l_proc, 5);
204: --
205: hr_utility.set_location(' Leaving:'||l_proc, 10);
206: End pre_update;
207: --
201: --
202: Begin
203: hr_utility.set_location('Entering:'||l_proc, 5);
204: --
205: hr_utility.set_location(' Leaving:'||l_proc, 10);
206: End pre_update;
207: --
208: -- ----------------------------------------------------------------------------
209: -- |-----------------------------< post_update >------------------------------|
241: --
242: l_proc varchar2(72) := g_package||'post_update';
243: --
244: Begin
245: hr_utility.set_location('Entering:'||l_proc, 5);
246: --
247: ota_evt_bus.chk_status_changed
248: (p_line_id => p_rec.line_id
249: ,p_event_status => p_rec.event_status
251: ,p_org_id => p_rec.org_id
252: ,p_owner_id => p_rec.owner_id
253: ,p_event_title => p_rec.title);
254:
255: hr_utility.set_location(' Leaving:'||l_proc, 10);
256: End post_update;
257: --
258: -- ----------------------------------------------------------------------------
259: -- |-----------------------------< convert_defs >-----------------------------|
304: l_proc varchar2(72) := g_package||'convert_defs';
305: --
306: Begin
307: --
308: hr_utility.set_location('Entering:'||l_proc, 5);
309: --
310: -- We must now examine each argument value in the
311: -- p_rec plsql record structure
312: -- to see if a system default is being used. If a system default
584:
585: --
586: -- Return the plsql record structure.
587: --
588: hr_utility.set_location(' Leaving:'||l_proc, 10);
589: Return(p_rec);
590: --
591: End convert_defs;
592: --
610: l_training_center_id_changed boolean;
611: l_class_title_changed boolean;
612: --
613: Begin
614: hr_utility.set_location('Entering:'||l_proc, 5);
615: --
616: -- Determine if the business process is to be validated.
617: --
618: If p_validate then
778: end if;
779: end if;
780:
781: --
782: hr_utility.set_location(' Leaving:'||l_proc, 10);
783: Exception
784: When HR_Api.Validate_Enabled Then
785: --
786: -- As the Validate_Enabled exception has been raised
871: l_rec ota_evt_shd.g_rec_type;
872: l_proc varchar2(72) := g_package||'upd';
873: --
874: Begin
875: hr_utility.set_location('Entering:'||l_proc, 5);
876: --
877: -- Call conversion function to turn arguments into the
878: -- l_rec structure.
879: --
956: --
957: upd(l_rec, p_validate);
958: p_object_version_number := l_rec.object_version_number;
959: --
960: hr_utility.set_location(' Leaving:'||l_proc, 10);
961: End upd;
962: end ota_evt_upd;