DBA Data[Home] [Help]

APPS.HXC_EGC_INS dependencies on HXC_EGC_SHD

Line 53: (p_rec in out nocopy hxc_egc_shd.g_rec_type

49: -- Internal Row Handler Use Only.
50: --
51: -- ----------------------------------------------------------------------------
52: Procedure insert_dml
53: (p_rec in out nocopy hxc_egc_shd.g_rec_type
54: ) is
55: --
56: l_proc varchar2(72);
57: --

Line 65: hxc_egc_shd.g_api_dml := true; -- Set the api dml status

61: hr_utility.set_location('Entering:'||l_proc, 5);
62: end if;
63: p_rec.object_version_number := 1; -- Initialise the object version
64: --
65: hxc_egc_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Insert the row into: hxc_entity_group_comps
68: --
69: insert into hxc_entity_group_comps

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

152: ,sysdate
153: ,fnd_global.login_id
154: );
155: --
156: hxc_egc_shd.g_api_dml := false; -- Unset the api dml status
157: --
158: if g_debug then
159: hr_utility.set_location(' Leaving:'||l_proc, 10);
160: end if;

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

160: end if;
161: Exception
162: When hr_api.check_integrity_violated Then
163: -- A check constraint has been violated
164: hxc_egc_shd.g_api_dml := false; -- Unset the api dml status
165: hxc_egc_shd.constraint_error
166: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
167: When hr_api.parent_integrity_violated Then
168: -- Parent integrity has been violated

Line 165: hxc_egc_shd.constraint_error

161: Exception
162: When hr_api.check_integrity_violated Then
163: -- A check constraint has been violated
164: hxc_egc_shd.g_api_dml := false; -- Unset the api dml status
165: hxc_egc_shd.constraint_error
166: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
167: When hr_api.parent_integrity_violated Then
168: -- Parent integrity has been violated
169: hxc_egc_shd.g_api_dml := false; -- Unset the api dml status

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

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

Line 170: hxc_egc_shd.constraint_error

166: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
167: When hr_api.parent_integrity_violated Then
168: -- Parent integrity has been violated
169: hxc_egc_shd.g_api_dml := false; -- Unset the api dml status
170: hxc_egc_shd.constraint_error
171: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
172: When hr_api.unique_integrity_violated Then
173: -- Unique integrity has been violated
174: hxc_egc_shd.g_api_dml := false; -- Unset the api dml status

Line 174: hxc_egc_shd.g_api_dml := false; -- Unset the api dml status

170: hxc_egc_shd.constraint_error
171: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
172: When hr_api.unique_integrity_violated Then
173: -- Unique integrity has been violated
174: hxc_egc_shd.g_api_dml := false; -- Unset the api dml status
175: hxc_egc_shd.constraint_error
176: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
177: When Others Then
178: hxc_egc_shd.g_api_dml := false; -- Unset the api dml status

Line 175: hxc_egc_shd.constraint_error

171: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
172: When hr_api.unique_integrity_violated Then
173: -- Unique integrity has been violated
174: hxc_egc_shd.g_api_dml := false; -- Unset the api dml status
175: hxc_egc_shd.constraint_error
176: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
177: When Others Then
178: hxc_egc_shd.g_api_dml := false; -- Unset the api dml status
179: Raise;

Line 178: hxc_egc_shd.g_api_dml := false; -- Unset the api dml status

174: hxc_egc_shd.g_api_dml := false; -- Unset the api dml status
175: hxc_egc_shd.constraint_error
176: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
177: When Others Then
178: hxc_egc_shd.g_api_dml := false; -- Unset the api dml status
179: Raise;
180: End insert_dml;
181: --
182: -- ----------------------------------------------------------------------------

Line 218: (p_rec in out nocopy hxc_egc_shd.g_rec_type

214: -- Internal Row Handler Use Only.
215: --
216: -- ----------------------------------------------------------------------------
217: Procedure pre_insert
218: (p_rec in out nocopy hxc_egc_shd.g_rec_type
219: ) is
220: --
221: l_proc varchar2(72) ;
222: --

Line 275: ,p_rec in hxc_egc_shd.g_rec_type

271: --
272: -- ----------------------------------------------------------------------------
273: Procedure post_insert
274: (p_effective_date in date
275: ,p_rec in hxc_egc_shd.g_rec_type
276: ) is
277: --
278: l_proc varchar2(72);
279: --

Line 383: ,p_rec in out nocopy hxc_egc_shd.g_rec_type

379: -- |---------------------------------< ins >----------------------------------|
380: -- ----------------------------------------------------------------------------
381: Procedure ins
382: (p_effective_date in date
383: ,p_rec in out nocopy hxc_egc_shd.g_rec_type
384: ,p_called_from_form in varchar2
385: ) is
386: --
387: l_proc varchar2(72);

Line 475: l_rec hxc_egc_shd.g_rec_type;

471: ,p_object_version_number out nocopy number
472: ,p_called_from_form in varchar2
473: ) is
474: --
475: l_rec hxc_egc_shd.g_rec_type;
476: l_proc varchar2(72);
477: --
478: Begin
479: g_debug:=hr_utility.debug_enabled;

Line 489: hxc_egc_shd.convert_args

485: -- Call conversion function to turn arguments into the
486: -- p_rec structure.
487: --
488: l_rec :=
489: hxc_egc_shd.convert_args
490: (null
491: ,p_entity_group_id
492: ,p_entity_id
493: ,p_entity_type