APPS.OTA_TRB_INS dependencies on OTA_TRB_SHD

Line 76: (p_rec in out nocopy ota_trb_shd.g_rec_type

72: --
73: -- {End Of Comments}
74: -- ----------------------------------------------------------------------------
75: Procedure insert_dml
76: (p_rec in out nocopy ota_trb_shd.g_rec_type
77: ) is
78: --
79: l_proc varchar2(72) := g_package||'insert_dml';
80: --

Line 85: ota_trb_shd.g_api_dml := true; -- Set the api dml status

81: Begin
82: hr_utility.set_location('Entering:'||l_proc, 5);
83: p_rec.object_version_number := 1; -- Initialise the object version
84: --
85: ota_trb_shd.g_api_dml := true; -- Set the api dml status
86: --
87: -- Insert the row into: ota_resource_bookings
88: --
89: insert into ota_resource_bookings

Line 188: ota_trb_shd.g_api_dml := false; -- Unset the api dml status

184: ,p_rec.forum_id
185: ,p_rec.timezone_code
186: );
187: --
188: ota_trb_shd.g_api_dml := false; -- Unset the api dml status
189: --
190: hr_utility.set_location(' Leaving:'||l_proc, 10);
191: Exception
192: When hr_api.check_integrity_violated Then

Line 194: ota_trb_shd.g_api_dml := false; -- Unset the api dml status

190: hr_utility.set_location(' Leaving:'||l_proc, 10);
191: Exception
192: When hr_api.check_integrity_violated Then
193: -- A check constraint has been violated
194: ota_trb_shd.g_api_dml := false; -- Unset the api dml status
195: ota_trb_shd.constraint_error
196: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
197: When hr_api.parent_integrity_violated Then
198: -- Parent integrity has been violated

Line 195: ota_trb_shd.constraint_error

191: Exception
192: When hr_api.check_integrity_violated Then
193: -- A check constraint has been violated
194: ota_trb_shd.g_api_dml := false; -- Unset the api dml status
195: ota_trb_shd.constraint_error
196: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
197: When hr_api.parent_integrity_violated Then
198: -- Parent integrity has been violated
199: ota_trb_shd.g_api_dml := false; -- Unset the api dml status

Line 199: ota_trb_shd.g_api_dml := false; -- Unset the api dml status

195: ota_trb_shd.constraint_error
196: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
197: When hr_api.parent_integrity_violated Then
198: -- Parent integrity has been violated
199: ota_trb_shd.g_api_dml := false; -- Unset the api dml status
200: ota_trb_shd.constraint_error
201: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
202: When hr_api.unique_integrity_violated Then
203: -- Unique integrity has been violated

Line 200: ota_trb_shd.constraint_error

196: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
197: When hr_api.parent_integrity_violated Then
198: -- Parent integrity has been violated
199: ota_trb_shd.g_api_dml := false; -- Unset the api dml status
200: ota_trb_shd.constraint_error
201: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
202: When hr_api.unique_integrity_violated Then
203: -- Unique integrity has been violated
204: ota_trb_shd.g_api_dml := false; -- Unset the api dml status

Line 204: ota_trb_shd.g_api_dml := false; -- Unset the api dml status

200: ota_trb_shd.constraint_error
201: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
202: When hr_api.unique_integrity_violated Then
203: -- Unique integrity has been violated
204: ota_trb_shd.g_api_dml := false; -- Unset the api dml status
205: ota_trb_shd.constraint_error
206: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
207: When Others Then
208: ota_trb_shd.g_api_dml := false; -- Unset the api dml status

Line 205: ota_trb_shd.constraint_error

201: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
202: When hr_api.unique_integrity_violated Then
203: -- Unique integrity has been violated
204: ota_trb_shd.g_api_dml := false; -- Unset the api dml status
205: ota_trb_shd.constraint_error
206: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
207: When Others Then
208: ota_trb_shd.g_api_dml := false; -- Unset the api dml status
209: Raise;

Line 208: ota_trb_shd.g_api_dml := false; -- Unset the api dml status

204: ota_trb_shd.g_api_dml := false; -- Unset the api dml status
205: ota_trb_shd.constraint_error
206: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
207: When Others Then
208: ota_trb_shd.g_api_dml := false; -- Unset the api dml status
209: Raise;
210: End insert_dml;
211: --
212: -- ----------------------------------------------------------------------------

Line 250: (p_rec in out nocopy ota_trb_shd.g_rec_type

246: --
247: -- {End Of Comments}
248: -- ----------------------------------------------------------------------------
249: Procedure pre_insert
250: (p_rec in out nocopy ota_trb_shd.g_rec_type
251: ) is
252: --
253: Cursor C_Sel1 is select ota_resource_bookings_s.nextval from sys.dual;
254: --

Line 397: ,p_rec in ota_trb_shd.g_rec_type

393: -- {End Of Comments}
394: -- ----------------------------------------------------------------------------
395: Procedure post_insert
396: (p_effective_date in date
397: ,p_rec in ota_trb_shd.g_rec_type
398: ) is
399: --
400: l_proc varchar2(72) := g_package||'post_insert';
401: --

Line 522: ,p_rec in out nocopy ota_trb_shd.g_rec_type

518: -- |---------------------------------< ins >----------------------------------|
519: -- ----------------------------------------------------------------------------
520: Procedure ins
521: (p_effective_date in date
522: ,p_rec in out nocopy ota_trb_shd.g_rec_type
523: ) is
524: --
525: l_proc varchar2(72) := g_package||'ins';
526: --

Line 615: l_rec ota_trb_shd.g_rec_type;

611: ,p_object_version_number out nocopy number
612: ,p_timezone_code IN VARCHAR2 DEFAULT NULL
613: ) is
614: --
615: l_rec ota_trb_shd.g_rec_type;
616: l_proc varchar2(72) := g_package||'ins';
617: --
618: Begin
619: hr_utility.set_location('Entering:'||l_proc, 5);

Line 625: ota_trb_shd.convert_args

621: -- Call conversion function to turn arguments into the
622: -- p_rec structure.
623: --
624: l_rec :=
625: ota_trb_shd.convert_args
626: (null
627: ,p_supplied_resource_id
628: ,p_event_id
629: ,p_date_booking_placed