DBA Data[Home] [Help]

APPS.BEN_XCV_INS dependencies on BEN_XCV_SHD

Line 108: Procedure insert_dml(p_rec in out nocopy ben_xcv_shd.g_rec_type) is

104: -- Internal Row Handler Use Only.
105: --
106: -- {End Of Comments}
107: -- ----------------------------------------------------------------------------
108: Procedure insert_dml(p_rec in out nocopy ben_xcv_shd.g_rec_type) is
109: --
110: l_proc varchar2(72) := g_package||'insert_dml';
111: --
112: Begin

Line 116: ben_xcv_shd.g_api_dml := true; -- Set the api dml status

112: Begin
113: hr_utility.set_location('Entering:'||l_proc, 5);
114: p_rec.object_version_number := 1; -- Initialise the object version
115: --
116: ben_xcv_shd.g_api_dml := true; -- Set the api dml status
117: --
118: -- Insert the row into: ben_ext_crit_val
119: --
120: insert into ben_ext_crit_val

Line 151: ben_xcv_shd.g_api_dml := false; -- Unset the api dml status

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

Line 157: ben_xcv_shd.g_api_dml := false; -- Unset the api dml status

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

Line 158: ben_xcv_shd.constraint_error

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

Line 162: ben_xcv_shd.g_api_dml := false; -- Unset the api dml status

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

Line 163: ben_xcv_shd.constraint_error

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

Line 167: ben_xcv_shd.g_api_dml := false; -- Unset the api dml status

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

Line 168: ben_xcv_shd.constraint_error

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

Line 171: ben_xcv_shd.g_api_dml := false; -- Unset the api dml status

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

Line 212: Procedure pre_insert(p_rec in out nocopy ben_xcv_shd.g_rec_type) is

208: -- Internal Row Handler Use Only.
209: --
210: -- {End Of Comments}
211: -- ----------------------------------------------------------------------------
212: Procedure pre_insert(p_rec in out nocopy ben_xcv_shd.g_rec_type) is
213: --
214: l_proc varchar2(72) := g_package||'pre_insert';
215: --
216: cursor c1 is

Line 262: Procedure post_insert(p_rec in ben_xcv_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_xcv_shd.g_rec_type) is
263: --
264: l_proc varchar2(72) := g_package||'post_insert';
265: --
266: Begin

Line 312: p_rec in out nocopy ben_xcv_shd.g_rec_type

308: -- ----------------------------------------------------------------------------
309: Procedure ins
310: (
311: p_effective_date in date,
312: p_rec in out nocopy ben_xcv_shd.g_rec_type
313: ) is
314: --
315: l_proc varchar2(72) := g_package||'ins';
316: --

Line 359: l_rec ben_xcv_shd.g_rec_type;

355: p_created_by in number default null,
356: p_object_version_number out nocopy number
357: ) is
358: --
359: l_rec ben_xcv_shd.g_rec_type;
360: l_proc varchar2(72) := g_package||'ins';
361: --
362: Begin
363: hr_utility.set_location('Entering:'||l_proc, 5);

Line 369: ben_xcv_shd.convert_args

365: -- Call conversion function to turn arguments into the
366: -- p_rec structure.
367: --
368: l_rec :=
369: ben_xcv_shd.convert_args
370: (
371: null,
372: p_val_1,
373: p_val_2,