APPS.HXC_MCU_INS dependencies on HXC_MCU_SHD

Line 56: (p_rec in out nocopy hxc_mcu_shd.g_rec_type

52: --
53: -- {End Of Comments}
54: -- ----------------------------------------------------------------------------
55: Procedure insert_dml
56: (p_rec in out nocopy hxc_mcu_shd.g_rec_type
57: ) is
58: --
59: l_proc varchar2(72);
60: --

Line 70: hxc_mcu_shd.g_api_dml := true; -- Set the api dml status

66: hr_utility.set_location('Entering:'||l_proc, 5);
67: end if;
68: p_rec.object_version_number := 1; -- Initialise the object version
69: --
70: hxc_mcu_shd.g_api_dml := true; -- Set the api dml status
71: --
72: -- Insert the row into: hxc_mapping_comp_usages
73: --
74: insert into hxc_mapping_comp_usages

Line 97: hxc_mcu_shd.g_api_dml := false; -- Unset the api dml status

93: ,sysdate
94: ,fnd_global.login_id
95: );
96: --
97: hxc_mcu_shd.g_api_dml := false; -- Unset the api dml status
98: --
99: if g_debug then
100: hr_utility.set_location(' Leaving:'||l_proc, 10);
101: end if;

Line 105: hxc_mcu_shd.g_api_dml := false; -- Unset the api dml status

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

Line 106: hxc_mcu_shd.constraint_error

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

Line 110: hxc_mcu_shd.g_api_dml := false; -- Unset the api dml status

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

Line 111: hxc_mcu_shd.constraint_error

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

Line 115: hxc_mcu_shd.g_api_dml := false; -- Unset the api dml status

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

Line 116: hxc_mcu_shd.constraint_error

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

Line 119: hxc_mcu_shd.g_api_dml := false; -- Unset the api dml status

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

Line 161: (p_rec in out nocopy hxc_mcu_shd.g_rec_type

157: --
158: -- {End Of Comments}
159: -- ----------------------------------------------------------------------------
160: Procedure pre_insert
161: (p_rec in out nocopy hxc_mcu_shd.g_rec_type
162: ) is
163: --
164: l_proc varchar2(72);
165: --

Line 221: (p_rec in hxc_mcu_shd.g_rec_type

217: --
218: -- {End Of Comments}
219: -- ----------------------------------------------------------------------------
220: Procedure post_insert
221: (p_rec in hxc_mcu_shd.g_rec_type
222: ) is
223: --
224: l_proc varchar2(72);
225: --

Line 265: (p_rec in out nocopy hxc_mcu_shd.g_rec_type

261: -- ----------------------------------------------------------------------------
262: -- |---------------------------------< ins >----------------------------------|
263: -- ----------------------------------------------------------------------------
264: Procedure ins
265: (p_rec in out nocopy hxc_mcu_shd.g_rec_type
266: ) is
267: --
268: l_proc varchar2(72);
269: --

Line 314: l_rec hxc_mcu_shd.g_rec_type;

310: ,p_mapping_comp_usage_id out nocopy number
311: ,p_object_version_number out nocopy number
312: ) is
313: --
314: l_rec hxc_mcu_shd.g_rec_type;
315: l_proc varchar2(72);
316: --
317: Begin
318: g_debug := hr_utility.debug_enabled;

Line 329: hxc_mcu_shd.convert_args

325: -- Call conversion function to turn arguments into the
326: -- p_rec structure.
327: --
328: l_rec :=
329: hxc_mcu_shd.convert_args
330: (null
331: ,null
332: ,p_mapping_component_id
333: ,p_mapping_id