54: --
55: l_proc varchar2(72) := g_package||'insert_dml';
56: --
57: Begin
58: hr_utility.set_location('Entering:'||l_proc, 5);
59: --
60: --
61: ota_tea_shd.g_api_dml := true; -- Set the api dml status
62: --
124: );
125: --
126: ota_tea_shd.g_api_dml := false; -- Unset the api dml status
127: --
128: hr_utility.set_location(' Leaving:'||l_proc, 10);
129: Exception
130: When hr_api.check_integrity_violated Then
131: -- A check constraint has been violated
132: ota_tea_shd.g_api_dml := false; -- Unset the api dml status
190: --
191: Cursor C_Sel1 is select ota_event_associations_s.nextval from sys.dual;
192: --
193: Begin
194: hr_utility.set_location('Entering:'||l_proc, 5);
195: --
196: --
197: -- Select the next sequence number
198: --
199: Open C_Sel1;
200: Fetch C_Sel1 Into p_rec.event_association_id;
201: Close C_Sel1;
202: --
203: hr_utility.set_location(' Leaving:'||l_proc, 10);
204: End pre_insert;
205: --
206: -- ----------------------------------------------------------------------------
207: -- |-----------------------------< post_insert >------------------------------|
266: l_tdb_ovn number;
267: l_booking_id number;
268: begin
269: --
270: hr_utility.set_location('Entering:'||l_proc,5);
271: --
272: ota_event_associations_pkg.maintain_delegate_bookings
273: (p_validate => p_validate
274: ,p_price_basis => p_price_basis
302: );
303: p_booking_id := l_booking_id;
304: p_tdb_object_version_number := l_tdb_ovn;
305: --
306: hr_utility.set_location('Leaving:'||l_proc,10);
307: --
308: end post_insert;
309: --
310: --
342: --
343: l_proc varchar2(72) := g_package||'ins';
344: --
345: Begin
346: hr_utility.set_location('Entering:'||l_proc, 5);
347: --
348: -- Determine if the business process is to be validated.
349: --
350: If p_validate then
402: If p_validate then
403: Raise HR_Api.Validate_Enabled;
404: End If;
405: --
406: hr_utility.set_location(' Leaving:'||l_proc, 10);
407: Exception
408: When HR_Api.Validate_Enabled Then
409: --
410: -- As the Validate_Enabled exception has been raised
476: l_rec ota_tea_shd.g_rec_type;
477: l_proc varchar2(72) := g_package||'ins';
478: --
479: Begin
480: hr_utility.set_location('Entering:'||l_proc, 5);
481: --
482: -- Call conversion function to turn arguments into the
483: -- p_rec structure.
484: --
549: --
550: p_event_association_id := l_rec.event_association_id;
551: --
552: --
553: hr_utility.set_location(' Leaving:'||l_proc, 10);
554: End ins;
555: --
556: Procedure ins
557: (