DBA Data[Home] [Help]

APPS.BEN_XCT_INS dependencies on BEN_XCT_SHD

Line 108: Procedure insert_dml(p_rec in out nocopy ben_xct_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_xct_shd.g_rec_type) is
109: --
110: l_proc varchar2(72) := g_package||'insert_dml';
111: --
112: Begin

Line 116: ben_xct_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_xct_shd.g_api_dml := true; -- Set the api dml status
117: --
118: -- Insert the row into: ben_ext_crit_typ
119: --
120: insert into ben_ext_crit_typ

Line 149: ben_xct_shd.g_api_dml := false; -- Unset the api dml status

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

Line 155: ben_xct_shd.g_api_dml := false; -- Unset the api dml status

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

Line 156: ben_xct_shd.constraint_error

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

Line 160: ben_xct_shd.g_api_dml := false; -- Unset the api dml status

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

Line 161: ben_xct_shd.constraint_error

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

Line 165: ben_xct_shd.g_api_dml := false; -- Unset the api dml status

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

Line 166: ben_xct_shd.constraint_error

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

Line 169: ben_xct_shd.g_api_dml := false; -- Unset the api dml status

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

Line 210: Procedure pre_insert(p_rec in out nocopy ben_xct_shd.g_rec_type) is

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

Line 262: p_effective_date in date,p_rec in ben_xct_shd.g_rec_type) is

258: --
259: -- {End Of Comments}
260: -- ----------------------------------------------------------------------------
261: Procedure post_insert(
262: p_effective_date in date,p_rec in ben_xct_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_xct_shd.g_rec_type

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

Line 359: l_rec ben_xct_shd.g_rec_type;

355: p_object_version_number out nocopy number,
356: p_excld_flag in varchar2
357: ) is
358: --
359: l_rec ben_xct_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_xct_shd.convert_args

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