DBA Data[Home] [Help]

APPS.BEN_CLA_INS dependencies on BEN_CLA_SHD

Line 53: Procedure insert_dml(p_rec in out nocopy ben_cla_shd.g_rec_type) is

49: -- Internal Row Handler Use Only.
50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure insert_dml(p_rec in out nocopy ben_cla_shd.g_rec_type) is
54: --
55: l_proc varchar2(72) := g_package||'insert_dml';
56: --
57: Begin

Line 61: ben_cla_shd.g_api_dml := true; -- Set the api dml status

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

Line 150: ben_cla_shd.g_api_dml := false; -- Unset the api dml status

146: p_rec.object_version_number ,
147: p_rec.name
148: );
149: --
150: ben_cla_shd.g_api_dml := false; -- Unset the api dml status
151: --
152: hr_utility.set_location(' Leaving:'||l_proc, 10);
153: Exception
154: When hr_api.check_integrity_violated Then

Line 156: ben_cla_shd.g_api_dml := false; -- Unset the api dml status

152: hr_utility.set_location(' Leaving:'||l_proc, 10);
153: Exception
154: When hr_api.check_integrity_violated Then
155: -- A check constraint has been violated
156: ben_cla_shd.g_api_dml := false; -- Unset the api dml status
157: ben_cla_shd.constraint_error
158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
159: When hr_api.parent_integrity_violated Then
160: -- Parent integrity has been violated

Line 157: ben_cla_shd.constraint_error

153: Exception
154: When hr_api.check_integrity_violated Then
155: -- A check constraint has been violated
156: ben_cla_shd.g_api_dml := false; -- Unset the api dml status
157: ben_cla_shd.constraint_error
158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
159: When hr_api.parent_integrity_violated Then
160: -- Parent integrity has been violated
161: ben_cla_shd.g_api_dml := false; -- Unset the api dml status

Line 161: ben_cla_shd.g_api_dml := false; -- Unset the api dml status

157: ben_cla_shd.constraint_error
158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
159: When hr_api.parent_integrity_violated Then
160: -- Parent integrity has been violated
161: ben_cla_shd.g_api_dml := false; -- Unset the api dml status
162: ben_cla_shd.constraint_error
163: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
164: When hr_api.unique_integrity_violated Then
165: -- Unique integrity has been violated

Line 162: ben_cla_shd.constraint_error

158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
159: When hr_api.parent_integrity_violated Then
160: -- Parent integrity has been violated
161: ben_cla_shd.g_api_dml := false; -- Unset the api dml status
162: ben_cla_shd.constraint_error
163: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
164: When hr_api.unique_integrity_violated Then
165: -- Unique integrity has been violated
166: ben_cla_shd.g_api_dml := false; -- Unset the api dml status

Line 166: ben_cla_shd.g_api_dml := false; -- Unset the api dml status

162: ben_cla_shd.constraint_error
163: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
164: When hr_api.unique_integrity_violated Then
165: -- Unique integrity has been violated
166: ben_cla_shd.g_api_dml := false; -- Unset the api dml status
167: ben_cla_shd.constraint_error
168: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
169: When Others Then
170: ben_cla_shd.g_api_dml := false; -- Unset the api dml status

Line 167: ben_cla_shd.constraint_error

163: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
164: When hr_api.unique_integrity_violated Then
165: -- Unique integrity has been violated
166: ben_cla_shd.g_api_dml := false; -- Unset the api dml status
167: ben_cla_shd.constraint_error
168: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
169: When Others Then
170: ben_cla_shd.g_api_dml := false; -- Unset the api dml status
171: Raise;

Line 170: ben_cla_shd.g_api_dml := false; -- Unset the api dml status

166: ben_cla_shd.g_api_dml := false; -- Unset the api dml status
167: ben_cla_shd.constraint_error
168: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
169: When Others Then
170: ben_cla_shd.g_api_dml := false; -- Unset the api dml status
171: Raise;
172: End insert_dml;
173: --
174: -- ----------------------------------------------------------------------------

Line 211: Procedure pre_insert(p_rec in out nocopy ben_cla_shd.g_rec_type) is

207: -- Internal Row Handler Use Only.
208: --
209: -- {End Of Comments}
210: -- ----------------------------------------------------------------------------
211: Procedure pre_insert(p_rec in out nocopy ben_cla_shd.g_rec_type) is
212: --
213: l_proc varchar2(72) := g_package||'pre_insert';
214: --
215: Cursor C_Sel1 is select ben_cmbn_age_los_fctr_s.nextval from sys.dual;

Line 262: Procedure post_insert(p_rec in ben_cla_shd.g_rec_type) is

258: -- Internal Row Handler Use Only.
259: --
260: -- {End Of Comments}
261: -- ----------------------------------------------------------------------------
262: Procedure post_insert(p_rec in ben_cla_shd.g_rec_type) is
263: --
264: l_proc varchar2(72) := g_package||'post_insert';
265: --
266: Begin

Line 339: p_rec in out nocopy ben_cla_shd.g_rec_type

335: -- |---------------------------------< ins >----------------------------------|
336: -- ----------------------------------------------------------------------------
337: Procedure ins
338: (
339: p_rec in out nocopy ben_cla_shd.g_rec_type
340: ) is
341: --
342: l_proc varchar2(72) := g_package||'ins';
343: --

Line 411: l_rec ben_cla_shd.g_rec_type;

407: p_object_version_number out nocopy number ,
408: p_name in varchar2
409: ) is
410: --
411: l_rec ben_cla_shd.g_rec_type;
412: l_proc varchar2(72) := g_package||'ins';
413: --
414: Begin
415: hr_utility.set_location('Entering:'||l_proc, 5);

Line 421: ben_cla_shd.convert_args

417: -- Call conversion function to turn arguments into the
418: -- p_rec structure.
419: --
420: l_rec :=
421: ben_cla_shd.convert_args
422: (
423: null,
424: p_business_group_id,
425: p_los_fctr_id,