APPS.HR_ORI_INS dependencies on HR_ORI_SHD

Line 75: (p_rec in out nocopy hr_ori_shd.g_rec_type

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

Line 84: hr_ori_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_ori_shd.g_api_dml := true; -- Set the api dml status
85: --
86: -- Insert the row into: hr_organization_information
87: --
88: insert into hr_organization_information

Line 183: hr_ori_shd.g_api_dml := false; -- Unset the api dml status

179: ,p_rec.attribute20
180: ,p_rec.object_version_number
181: );
182: --
183: hr_ori_shd.g_api_dml := false; -- Unset the api dml status
184: --
185: hr_utility.set_location(' Leaving:'||l_proc, 10);
186: Exception
187: When hr_api.check_integrity_violated Then

Line 189: hr_ori_shd.g_api_dml := false; -- Unset the api dml status

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

Line 190: hr_ori_shd.constraint_error

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

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

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

Line 195: hr_ori_shd.constraint_error

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

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

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

Line 200: hr_ori_shd.constraint_error

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

Line 203: hr_ori_shd.g_api_dml := false; -- Unset the api dml status

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

Line 245: (p_rec in out nocopy hr_ori_shd.g_rec_type

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

Line 299: ,p_rec in hr_ori_shd.g_rec_type

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

Line 420: ,p_rec in out nocopy hr_ori_shd.g_rec_type

416: -- |---------------------------------< ins >----------------------------------|
417: -- ----------------------------------------------------------------------------
418: Procedure ins
419: (p_effective_date in date
420: ,p_rec in out nocopy hr_ori_shd.g_rec_type
421: ) is
422: --
423: l_proc varchar2(72) := g_package||'ins';
424: --

Line 505: l_rec hr_ori_shd.g_rec_type;

501: ,p_org_information_id out nocopy number
502: ,p_object_version_number out nocopy number
503: ) is
504: --
505: l_rec hr_ori_shd.g_rec_type;
506: l_proc varchar2(72) := g_package||'ins';
507: --
508: Begin
509: hr_utility.set_location('Entering:'||l_proc, 5);

Line 515: hr_ori_shd.convert_args

511: -- Call conversion function to turn arguments into the
512: -- p_rec structure.
513: --
514: l_rec :=
515: hr_ori_shd.convert_args
516: (null
517: ,p_org_information_context
518: ,p_organization_id
519: ,p_org_information1