APPS.HR_ORU_INS dependencies on HR_ORU_SHD

Line 75: (p_rec in out nocopy hr_oru_shd.g_rec_type

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

Line 84: hr_oru_shd.g_api_dml := true; -- Set the api dml status

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

Line 185: hr_oru_shd.g_api_dml := false; -- Unset the api dml status

181: --End Enhancement 4040086
182: ,p_rec.object_version_number
183: );
184: --
185: hr_oru_shd.g_api_dml := false; -- Unset the api dml status
186: --
187: hr_utility.set_location(' Leaving:'||l_proc, 10);
188: Exception
189: When hr_api.check_integrity_violated Then

Line 191: hr_oru_shd.g_api_dml := false; -- Unset the api dml status

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

Line 192: hr_oru_shd.constraint_error

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

Line 196: hr_oru_shd.g_api_dml := false; -- Unset the api dml status

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

Line 197: hr_oru_shd.constraint_error

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

Line 201: hr_oru_shd.g_api_dml := false; -- Unset the api dml status

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

Line 202: hr_oru_shd.constraint_error

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

Line 205: hr_oru_shd.g_api_dml := false; -- Unset the api dml status

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

Line 247: (p_rec in out nocopy hr_oru_shd.g_rec_type

243: --
244: -- {End Of Comments}
245: -- ----------------------------------------------------------------------------
246: Procedure pre_insert
247: (p_rec in out nocopy hr_oru_shd.g_rec_type
248: ) is
249: --
250: l_proc varchar2(72) := g_package||'pre_insert';
251: --

Line 301: ,p_rec in hr_oru_shd.g_rec_type

297: -- {End Of Comments}
298: -- ----------------------------------------------------------------------------
299: Procedure post_insert
300: (p_effective_date in date
301: ,p_rec in hr_oru_shd.g_rec_type
302: ) is
303: --
304: l_proc varchar2(72) := g_package||'post_insert';
305: --

Line 422: ,p_rec in out nocopy hr_oru_shd.g_rec_type

418: -- |---------------------------------< ins >----------------------------------|
419: -- ----------------------------------------------------------------------------
420: Procedure ins
421: (p_effective_date in date
422: ,p_rec in out nocopy hr_oru_shd.g_rec_type
423: ,p_duplicate_org_warning out nocopy boolean
424: ) is
425: --
426: -- Fix 3565334

Line 536: l_rec hr_oru_shd.g_rec_type;

532: ,p_object_version_number out nocopy number
533: ,p_duplicate_org_warning out nocopy boolean
534: ) is
535: --
536: l_rec hr_oru_shd.g_rec_type;
537: l_proc varchar2(72) := g_package||'ins';
538: --
539: Begin
540: hr_utility.set_location('Entering:'||l_proc, 5);

Line 546: hr_oru_shd.convert_args

542: -- Call conversion function to turn arguments into the
543: -- p_rec structure.
544: --
545: l_rec :=
546: hr_oru_shd.convert_args
547: (null
548: ,p_business_group_id
549: ,p_cost_allocation_keyflex_id
550: ,p_location_id