DBA Data[Home] [Help]

APPS.BEN_XID_INS dependencies on BEN_XID_SHD

Line 107: Procedure insert_dml(p_rec in out nocopy ben_xid_shd.g_rec_type) is

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

Line 115: ben_xid_shd.g_api_dml := true; -- Set the api dml status

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

Line 148: ben_xid_shd.g_api_dml := false; -- Unset the api dml status

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

Line 154: ben_xid_shd.g_api_dml := false; -- Unset the api dml status

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

Line 155: ben_xid_shd.constraint_error

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

Line 159: ben_xid_shd.g_api_dml := false; -- Unset the api dml status

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

Line 160: ben_xid_shd.constraint_error

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

Line 164: ben_xid_shd.g_api_dml := false; -- Unset the api dml status

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

Line 165: ben_xid_shd.constraint_error

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

Line 168: ben_xid_shd.g_api_dml := false; -- Unset the api dml status

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

Line 209: Procedure pre_insert(p_rec in out nocopy ben_xid_shd.g_rec_type) is

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

Line 260: Procedure post_insert(p_rec in ben_xid_shd.g_rec_type) is

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

Line 309: p_rec in out nocopy ben_xid_shd.g_rec_type

305: -- |---------------------------------< ins >----------------------------------|
306: -- ----------------------------------------------------------------------------
307: Procedure ins
308: (
309: p_rec in out nocopy ben_xid_shd.g_rec_type
310: ) is
311: --
312: l_proc varchar2(72) := g_package||'ins';
313: --

Line 353: l_rec ben_xid_shd.g_rec_type;

349: p_object_version_number out nocopy number,
350: p_ext_data_elmt_in_rcd_id in number default null
351: ) is
352: --
353: l_rec ben_xid_shd.g_rec_type;
354: l_proc varchar2(72) := g_package||'ins';
355: --
356: Begin
357: hr_utility.set_location('Entering:'||l_proc, 5);

Line 363: ben_xid_shd.convert_args

359: -- Call conversion function to turn arguments into the
360: -- p_rec structure.
361: --
362: l_rec :=
363: ben_xid_shd.convert_args
364: (
365: null,
366: p_ext_rcd_in_file_id,
367: p_ext_data_elmt_id,