APPS.BEN_RTS_INS dependencies on BEN_RTS_SHD

Line 81: (p_rec in out nocopy ben_rts_shd.g_rec_type

77: --
78: -- {End Of Comments}
79: -- ----------------------------------------------------------------------------
80: Procedure insert_dml
81: (p_rec in out nocopy ben_rts_shd.g_rec_type
82: ) is
83: --
84: l_proc varchar2(72) := g_package||'insert_dml';
85: --

Line 92: ben_rts_shd.g_api_dml := true; -- Set the api dml status

88: hr_utility.set_location('Entering:'||l_proc, 5);
89: end if;
90: p_rec.object_version_number := 1; -- Initialise the object version
91: --
92: ben_rts_shd.g_api_dml := true; -- Set the api dml status
93: --
94: -- Insert the row into: ben_cwb_person_rates
95: --
96: insert into ben_cwb_person_rates

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

201: ,p_rec.currency
202: ,p_rec.object_version_number
203: );
204: --
205: ben_rts_shd.g_api_dml := false; -- Unset the api dml status
206: --
207: if g_debug then
208: hr_utility.set_location(' Leaving:'||l_proc, 10);
209: end if;

Line 213: ben_rts_shd.g_api_dml := false; -- Unset the api dml status

209: end if;
210: Exception
211: When hr_api.check_integrity_violated Then
212: -- A check constraint has been violated
213: ben_rts_shd.g_api_dml := false; -- Unset the api dml status
214: ben_rts_shd.constraint_error
215: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
216: When hr_api.parent_integrity_violated Then
217: -- Parent integrity has been violated

Line 214: ben_rts_shd.constraint_error

210: Exception
211: When hr_api.check_integrity_violated Then
212: -- A check constraint has been violated
213: ben_rts_shd.g_api_dml := false; -- Unset the api dml status
214: ben_rts_shd.constraint_error
215: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
216: When hr_api.parent_integrity_violated Then
217: -- Parent integrity has been violated
218: ben_rts_shd.g_api_dml := false; -- Unset the api dml status

Line 218: ben_rts_shd.g_api_dml := false; -- Unset the api dml status

214: ben_rts_shd.constraint_error
215: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
216: When hr_api.parent_integrity_violated Then
217: -- Parent integrity has been violated
218: ben_rts_shd.g_api_dml := false; -- Unset the api dml status
219: ben_rts_shd.constraint_error
220: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
221: When hr_api.unique_integrity_violated Then
222: -- Unique integrity has been violated

Line 219: ben_rts_shd.constraint_error

215: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
216: When hr_api.parent_integrity_violated Then
217: -- Parent integrity has been violated
218: ben_rts_shd.g_api_dml := false; -- Unset the api dml status
219: ben_rts_shd.constraint_error
220: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
221: When hr_api.unique_integrity_violated Then
222: -- Unique integrity has been violated
223: ben_rts_shd.g_api_dml := false; -- Unset the api dml status

Line 223: ben_rts_shd.g_api_dml := false; -- Unset the api dml status

219: ben_rts_shd.constraint_error
220: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
221: When hr_api.unique_integrity_violated Then
222: -- Unique integrity has been violated
223: ben_rts_shd.g_api_dml := false; -- Unset the api dml status
224: ben_rts_shd.constraint_error
225: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
226: When Others Then
227: ben_rts_shd.g_api_dml := false; -- Unset the api dml status

Line 224: ben_rts_shd.constraint_error

220: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
221: When hr_api.unique_integrity_violated Then
222: -- Unique integrity has been violated
223: ben_rts_shd.g_api_dml := false; -- Unset the api dml status
224: ben_rts_shd.constraint_error
225: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
226: When Others Then
227: ben_rts_shd.g_api_dml := false; -- Unset the api dml status
228: Raise;

Line 227: ben_rts_shd.g_api_dml := false; -- Unset the api dml status

223: ben_rts_shd.g_api_dml := false; -- Unset the api dml status
224: ben_rts_shd.constraint_error
225: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
226: When Others Then
227: ben_rts_shd.g_api_dml := false; -- Unset the api dml status
228: Raise;
229: End insert_dml;
230: --
231: -- ----------------------------------------------------------------------------

Line 269: (p_rec in out nocopy ben_rts_shd.g_rec_type

265: --
266: -- {End Of Comments}
267: -- ----------------------------------------------------------------------------
268: Procedure pre_insert
269: (p_rec in out nocopy ben_rts_shd.g_rec_type
270: ) is
271: --
272: Cursor C_Sel1 is select ben_cwb_person_rates_s.nextval from sys.dual;
273: --

Line 360: (p_rec in ben_rts_shd.g_rec_type

356: --
357: -- {End Of Comments}
358: -- ----------------------------------------------------------------------------
359: Procedure post_insert
360: (p_rec in ben_rts_shd.g_rec_type
361: ) is
362: --
363: l_proc varchar2(72) := g_package||'post_insert';
364: --

Line 497: (p_rec in out nocopy ben_rts_shd.g_rec_type

493: -- ----------------------------------------------------------------------------
494: -- |---------------------------------< ins >----------------------------------|
495: -- ----------------------------------------------------------------------------
496: Procedure ins
497: (p_rec in out nocopy ben_rts_shd.g_rec_type
498: ) is
499: --
500: l_proc varchar2(72) := g_package||'ins';
501: --

Line 596: l_rec ben_rts_shd.g_rec_type;

592: ,p_person_rate_id out nocopy number
593: ,p_object_version_number out nocopy number
594: ) is
595: --
596: l_rec ben_rts_shd.g_rec_type;
597: l_proc varchar2(72) := g_package||'ins';
598: --
599: Begin
600: if g_debug then

Line 608: ben_rts_shd.convert_args

604: -- Call conversion function to turn arguments into the
605: -- p_rec structure.
606: --
607: l_rec :=
608: ben_rts_shd.convert_args
609: (null
610: ,p_group_per_in_ler_id
611: ,p_pl_id
612: ,p_oipl_id