[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;
138: where event_id = p_rec.event_id;
139: --
140: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
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
198: --
199: l_proc varchar2(72) := g_package||'pre_update';
200: --
201: Begin
202: hr_utility.set_location('Entering:'||l_proc, 5);
203: --
204: hr_utility.set_location(' Leaving:'||l_proc, 10);
205: End pre_update;
206: --
200: --
201: Begin
202: hr_utility.set_location('Entering:'||l_proc, 5);
203: --
204: hr_utility.set_location(' Leaving:'||l_proc, 10);
205: End pre_update;
206: --
207: -- ----------------------------------------------------------------------------
208: -- |-----------------------------< post_update >------------------------------|
240: --
241: l_proc varchar2(72) := g_package||'post_update';
242: --
243: Begin
244: hr_utility.set_location('Entering:'||l_proc, 5);
245: --
246: ota_evt_bus.chk_status_changed
247: (p_line_id => p_rec.line_id
248: ,p_event_status => p_rec.event_status
250: ,p_org_id => p_rec.org_id
251: ,p_owner_id => p_rec.owner_id
252: ,p_event_title => p_rec.title);
253:
254: hr_utility.set_location(' Leaving:'||l_proc, 10);
255: End post_update;
256: --
257: -- ----------------------------------------------------------------------------
258: -- |-----------------------------< convert_defs >-----------------------------|
303: l_proc varchar2(72) := g_package||'convert_defs';
304: --
305: Begin
306: --
307: hr_utility.set_location('Entering:'||l_proc, 5);
308: --
309: -- We must now examine each argument value in the
310: -- p_rec plsql record structure
311: -- to see if a system default is being used. If a system default
578:
579: --
580: -- Return the plsql record structure.
581: --
582: hr_utility.set_location(' Leaving:'||l_proc, 10);
583: Return(p_rec);
584: --
585: End convert_defs;
586: --
603: l_location_id_changed boolean;
604: l_training_center_id_changed boolean;
605: --
606: Begin
607: hr_utility.set_location('Entering:'||l_proc, 5);
608: --
609: -- Determine if the business process is to be validated.
610: --
611: If p_validate then
760: end if;
761: end if;
762:
763: --
764: hr_utility.set_location(' Leaving:'||l_proc, 10);
765: Exception
766: When HR_Api.Validate_Enabled Then
767: --
768: -- As the Validate_Enabled exception has been raised
852: l_rec ota_evt_shd.g_rec_type;
853: l_proc varchar2(72) := g_package||'upd';
854: --
855: Begin
856: hr_utility.set_location('Entering:'||l_proc, 5);
857: --
858: -- Call conversion function to turn arguments into the
859: -- l_rec structure.
860: --
936: --
937: upd(l_rec, p_validate);
938: p_object_version_number := l_rec.object_version_number;
939: --
940: hr_utility.set_location(' Leaving:'||l_proc, 10);
941: End upd;
942: end ota_evt_upd;