DBA Data[Home] [Help]

APPS.HXC_HEG_INS dependencies on HXC_HEG_SHD

Line 53: (p_rec in out nocopy hxc_heg_shd.g_rec_type

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

Line 65: hxc_heg_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_heg_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Insert the row into: hxc_entity_groups
68: --
69: insert into hxc_entity_groups

Line 98: hxc_heg_shd.g_api_dml := false; -- Unset the api dml status

94: ,p_rec.business_group_id
95: ,p_rec.legislation_code
96: );
97: --
98: hxc_heg_shd.g_api_dml := false; -- Unset the api dml status
99: --
100: if g_debug then
101: hr_utility.set_location(' Leaving:'||l_proc, 10);
102: end if;

Line 106: hxc_heg_shd.g_api_dml := false; -- Unset the api dml status

102: end if;
103: Exception
104: When hr_api.check_integrity_violated Then
105: -- A check constraint has been violated
106: hxc_heg_shd.g_api_dml := false; -- Unset the api dml status
107: hxc_heg_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When hr_api.parent_integrity_violated Then
110: -- Parent integrity has been violated

Line 107: hxc_heg_shd.constraint_error

103: Exception
104: When hr_api.check_integrity_violated Then
105: -- A check constraint has been violated
106: hxc_heg_shd.g_api_dml := false; -- Unset the api dml status
107: hxc_heg_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When hr_api.parent_integrity_violated Then
110: -- Parent integrity has been violated
111: hxc_heg_shd.g_api_dml := false; -- Unset the api dml status

Line 111: hxc_heg_shd.g_api_dml := false; -- Unset the api dml status

107: hxc_heg_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When hr_api.parent_integrity_violated Then
110: -- Parent integrity has been violated
111: hxc_heg_shd.g_api_dml := false; -- Unset the api dml status
112: hxc_heg_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.unique_integrity_violated Then
115: -- Unique integrity has been violated

Line 112: hxc_heg_shd.constraint_error

108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When hr_api.parent_integrity_violated Then
110: -- Parent integrity has been violated
111: hxc_heg_shd.g_api_dml := false; -- Unset the api dml status
112: hxc_heg_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.unique_integrity_violated Then
115: -- Unique integrity has been violated
116: hxc_heg_shd.g_api_dml := false; -- Unset the api dml status

Line 116: hxc_heg_shd.g_api_dml := false; -- Unset the api dml status

112: hxc_heg_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.unique_integrity_violated Then
115: -- Unique integrity has been violated
116: hxc_heg_shd.g_api_dml := false; -- Unset the api dml status
117: hxc_heg_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When Others Then
120: hxc_heg_shd.g_api_dml := false; -- Unset the api dml status

Line 117: hxc_heg_shd.constraint_error

113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.unique_integrity_violated Then
115: -- Unique integrity has been violated
116: hxc_heg_shd.g_api_dml := false; -- Unset the api dml status
117: hxc_heg_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When Others Then
120: hxc_heg_shd.g_api_dml := false; -- Unset the api dml status
121: Raise;

Line 120: hxc_heg_shd.g_api_dml := false; -- Unset the api dml status

116: hxc_heg_shd.g_api_dml := false; -- Unset the api dml status
117: hxc_heg_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When Others Then
120: hxc_heg_shd.g_api_dml := false; -- Unset the api dml status
121: Raise;
122: End insert_dml;
123: --
124: -- ----------------------------------------------------------------------------

Line 160: (p_rec in out nocopy hxc_heg_shd.g_rec_type

156: -- Internal Row Handler Use Only.
157: --
158: -- ----------------------------------------------------------------------------
159: Procedure pre_insert
160: (p_rec in out nocopy hxc_heg_shd.g_rec_type
161: ) is
162: --
163: l_proc varchar2(72);
164: --

Line 216: (p_rec in hxc_heg_shd.g_rec_type

212: -- Internal Row Handler Use Only.
213: --
214: -- ----------------------------------------------------------------------------
215: Procedure post_insert
216: (p_rec in hxc_heg_shd.g_rec_type
217: ) is
218: --
219: l_proc varchar2(72);
220: --

Line 262: (p_rec in out nocopy hxc_heg_shd.g_rec_type

258: -- ----------------------------------------------------------------------------
259: -- |---------------------------------< ins >----------------------------------|
260: -- ----------------------------------------------------------------------------
261: Procedure ins
262: (p_rec in out nocopy hxc_heg_shd.g_rec_type
263: ) is
264: --
265: l_proc varchar2(72);
266: --

Line 312: l_rec hxc_heg_shd.g_rec_type;

308: ,p_business_group_id in number default null
309: ,p_legislation_code in varchar2 default null
310: ) is
311: --
312: l_rec hxc_heg_shd.g_rec_type;
313: l_proc varchar2(72);
314: --
315: Begin
316: g_debug:=hr_utility.debug_enabled;

Line 326: hxc_heg_shd.convert_args

322: -- Call conversion function to turn arguments into the
323: -- p_rec structure.
324: --
325: l_rec :=
326: hxc_heg_shd.convert_args
327: (null
328: ,p_name
329: ,p_entity_type
330: ,null