DBA Data[Home] [Help]

APPS.PAY_EEI_MIG_INS dependencies on PAY_EEI_MIG_SHD

Line 54: (p_rec in out nocopy pay_eei_mig_shd.g_rec_type

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure insert_dml
54: (p_rec in out nocopy pay_eei_mig_shd.g_rec_type
55: ) is
56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: --

Line 63: pay_eei_mig_shd.g_api_dml := true; -- Set the api dml status

59: Begin
60: hr_utility.set_location('Entering:'||l_proc, 5);
61: p_rec.object_version_number := 1; -- Initialise the object version
62: --
63: pay_eei_mig_shd.g_api_dml := true; -- Set the api dml status
64: --
65: -- Insert the row into: pay_element_type_extra_info
66: --
67: insert into pay_element_type_extra_info

Line 192: pay_eei_mig_shd.g_api_dml := false; -- Unset the api dml status

188: ,p_rec.eei_information30
189: ,p_rec.object_version_number
190: );
191: --
192: pay_eei_mig_shd.g_api_dml := false; -- Unset the api dml status
193: --
194: hr_utility.set_location(' Leaving:'||l_proc, 10);
195: Exception
196: When hr_api.check_integrity_violated Then

Line 198: pay_eei_mig_shd.g_api_dml := false; -- Unset the api dml status

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

Line 199: pay_eei_mig_shd.constraint_error

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

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

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

Line 204: pay_eei_mig_shd.constraint_error

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

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

204: pay_eei_mig_shd.constraint_error
205: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
206: When hr_api.unique_integrity_violated Then
207: -- Unique integrity has been violated
208: pay_eei_mig_shd.g_api_dml := false; -- Unset the api dml status
209: pay_eei_mig_shd.constraint_error
210: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
211: When Others Then
212: pay_eei_mig_shd.g_api_dml := false; -- Unset the api dml status

Line 209: pay_eei_mig_shd.constraint_error

205: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
206: When hr_api.unique_integrity_violated Then
207: -- Unique integrity has been violated
208: pay_eei_mig_shd.g_api_dml := false; -- Unset the api dml status
209: pay_eei_mig_shd.constraint_error
210: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
211: When Others Then
212: pay_eei_mig_shd.g_api_dml := false; -- Unset the api dml status
213: Raise;

Line 212: pay_eei_mig_shd.g_api_dml := false; -- Unset the api dml status

208: pay_eei_mig_shd.g_api_dml := false; -- Unset the api dml status
209: pay_eei_mig_shd.constraint_error
210: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
211: When Others Then
212: pay_eei_mig_shd.g_api_dml := false; -- Unset the api dml status
213: Raise;
214: End insert_dml;
215: --
216: -- ----------------------------------------------------------------------------

Line 254: (p_rec in out nocopy pay_eei_mig_shd.g_rec_type

250: --
251: -- {End Of Comments}
252: -- ----------------------------------------------------------------------------
253: Procedure pre_insert
254: (p_rec in out nocopy pay_eei_mig_shd.g_rec_type
255: ) is
256: --
257: l_proc varchar2(72) := g_package||'pre_insert';
258: --

Line 307: (p_rec in pay_eei_mig_shd.g_rec_type

303: --
304: -- {End Of Comments}
305: -- ----------------------------------------------------------------------------
306: Procedure post_insert
307: (p_rec in pay_eei_mig_shd.g_rec_type
308: ) is
309: --
310: l_proc varchar2(72) := g_package||'post_insert';
311: --

Line 456: (p_rec in out nocopy pay_eei_mig_shd.g_rec_type

452: -- ----------------------------------------------------------------------------
453: -- |---------------------------------< ins >----------------------------------|
454: -- ----------------------------------------------------------------------------
455: Procedure ins
456: (p_rec in out nocopy pay_eei_mig_shd.g_rec_type
457: ) is
458: --
459: l_proc varchar2(72) := g_package||'ins';
460: --

Line 553: l_rec pay_eei_mig_shd.g_rec_type;

549: ,p_element_type_extra_info_id out nocopy number
550: ,p_object_version_number out nocopy number
551: ) is
552: --
553: l_rec pay_eei_mig_shd.g_rec_type;
554: l_proc varchar2(72) := g_package||'ins';
555: --
556: Begin
557: hr_utility.set_location('Entering:'||l_proc, 5);

Line 563: pay_eei_mig_shd.convert_args

559: -- Call conversion function to turn arguments into the
560: -- p_rec structure.
561: --
562: l_rec :=
563: pay_eei_mig_shd.convert_args
564: (null
565: ,p_element_type_id
566: ,p_information_type
567: ,p_request_id