DBA Data[Home] [Help]

APPS.BEN_EIV_INS dependencies on BEN_EIV_SHD

Line 76: (p_rec in out nocopy ben_eiv_shd.g_rec_type

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

Line 85: ben_eiv_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: ben_eiv_shd.g_api_dml := true; -- Set the api dml status
86: --
87: -- Insert the row into: ben_extra_input_values
88: --
89: insert into ben_extra_input_values

Line 172: ben_eiv_shd.g_api_dml := false; -- Unset the api dml status

168: ,p_rec.eiv_attribute30
169: ,p_rec.object_version_number
170: );
171: --
172: ben_eiv_shd.g_api_dml := false; -- Unset the api dml status
173: --
174: hr_utility.set_location(' Leaving:'||l_proc, 10);
175: Exception
176: When hr_api.check_integrity_violated Then

Line 178: ben_eiv_shd.g_api_dml := false; -- Unset the api dml status

174: hr_utility.set_location(' Leaving:'||l_proc, 10);
175: Exception
176: When hr_api.check_integrity_violated Then
177: -- A check constraint has been violated
178: ben_eiv_shd.g_api_dml := false; -- Unset the api dml status
179: ben_eiv_shd.constraint_error
180: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
181: When hr_api.parent_integrity_violated Then
182: -- Parent integrity has been violated

Line 179: ben_eiv_shd.constraint_error

175: Exception
176: When hr_api.check_integrity_violated Then
177: -- A check constraint has been violated
178: ben_eiv_shd.g_api_dml := false; -- Unset the api dml status
179: ben_eiv_shd.constraint_error
180: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
181: When hr_api.parent_integrity_violated Then
182: -- Parent integrity has been violated
183: ben_eiv_shd.g_api_dml := false; -- Unset the api dml status

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

179: ben_eiv_shd.constraint_error
180: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
181: When hr_api.parent_integrity_violated Then
182: -- Parent integrity has been violated
183: ben_eiv_shd.g_api_dml := false; -- Unset the api dml status
184: ben_eiv_shd.constraint_error
185: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
186: When hr_api.unique_integrity_violated Then
187: -- Unique integrity has been violated

Line 184: ben_eiv_shd.constraint_error

180: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
181: When hr_api.parent_integrity_violated Then
182: -- Parent integrity has been violated
183: ben_eiv_shd.g_api_dml := false; -- Unset the api dml status
184: ben_eiv_shd.constraint_error
185: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
186: When hr_api.unique_integrity_violated Then
187: -- Unique integrity has been violated
188: ben_eiv_shd.g_api_dml := false; -- Unset the api dml status

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

184: ben_eiv_shd.constraint_error
185: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
186: When hr_api.unique_integrity_violated Then
187: -- Unique integrity has been violated
188: ben_eiv_shd.g_api_dml := false; -- Unset the api dml status
189: ben_eiv_shd.constraint_error
190: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
191: When Others Then
192: ben_eiv_shd.g_api_dml := false; -- Unset the api dml status

Line 189: ben_eiv_shd.constraint_error

185: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
186: When hr_api.unique_integrity_violated Then
187: -- Unique integrity has been violated
188: ben_eiv_shd.g_api_dml := false; -- Unset the api dml status
189: ben_eiv_shd.constraint_error
190: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
191: When Others Then
192: ben_eiv_shd.g_api_dml := false; -- Unset the api dml status
193: Raise;

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

188: ben_eiv_shd.g_api_dml := false; -- Unset the api dml status
189: ben_eiv_shd.constraint_error
190: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
191: When Others Then
192: ben_eiv_shd.g_api_dml := false; -- Unset the api dml status
193: Raise;
194: End insert_dml;
195: --
196: -- ----------------------------------------------------------------------------

Line 235: ,p_rec in out nocopy ben_eiv_shd.g_rec_type

231: -- {End Of Comments}
232: -- ----------------------------------------------------------------------------
233: Procedure pre_insert
234: (p_effective_date in date
235: ,p_rec in out nocopy ben_eiv_shd.g_rec_type
236: ) is
237: --
238: Cursor C_Sel1 is select ben_extra_input_values_s.nextval from sys.dual;
239: --

Line 288: ,p_rec in ben_eiv_shd.g_rec_type

284: -- {End Of Comments}
285: -- ----------------------------------------------------------------------------
286: Procedure post_insert
287: (p_effective_date in date
288: ,p_rec in ben_eiv_shd.g_rec_type
289: ) is
290: --
291: l_proc varchar2(72) := g_package||'post_insert';
292: --

Line 398: ,p_rec in out nocopy ben_eiv_shd.g_rec_type

394: -- |---------------------------------< ins >----------------------------------|
395: -- ----------------------------------------------------------------------------
396: Procedure ins
397: (p_effective_date in date
398: ,p_rec in out nocopy ben_eiv_shd.g_rec_type
399: ) is
400: --
401: l_proc varchar2(72) := g_package||'ins';
402: --

Line 478: l_rec ben_eiv_shd.g_rec_type;

474: ,p_extra_input_value_id out nocopy number
475: ,p_object_version_number out nocopy number
476: ) is
477: --
478: l_rec ben_eiv_shd.g_rec_type;
479: l_proc varchar2(72) := g_package||'ins';
480: --
481: Begin
482: hr_utility.set_location('Entering:'||l_proc, 5);

Line 488: ben_eiv_shd.convert_args

484: -- Call conversion function to turn arguments into the
485: -- p_rec structure.
486: --
487: l_rec :=
488: ben_eiv_shd.convert_args
489: (null
490: ,p_acty_base_rt_id
491: ,p_input_value_id
492: ,p_input_text