APPS.HXC_MPC_INS dependencies on HXC_MPC_SHD

Line 56: (p_rec in out nocopy hxc_mpc_shd.g_rec_type

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

Line 70: hxc_mpc_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_mpc_shd.g_api_dml := true; -- Set the api dml status
71: --
72: -- Insert the row into: hxc_mapping_components
73: --
74:

Line 102: hxc_mpc_shd.g_api_dml := false; -- Unset the api dml status

98: ,sysdate
99: ,fnd_global.login_id
100: );
101: --
102: hxc_mpc_shd.g_api_dml := false; -- Unset the api dml status
103: --
104: if g_debug then
105: hr_utility.set_location(' Leaving:'||l_proc, 10);
106: end if;

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

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

Line 111: hxc_mpc_shd.constraint_error

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

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

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

Line 116: hxc_mpc_shd.constraint_error

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

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

116: hxc_mpc_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When hr_api.unique_integrity_violated Then
119: -- Unique integrity has been violated
120: hxc_mpc_shd.g_api_dml := false; -- Unset the api dml status
121: hxc_mpc_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When Others Then
124: hxc_mpc_shd.g_api_dml := false; -- Unset the api dml status

Line 121: hxc_mpc_shd.constraint_error

117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When hr_api.unique_integrity_violated Then
119: -- Unique integrity has been violated
120: hxc_mpc_shd.g_api_dml := false; -- Unset the api dml status
121: hxc_mpc_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When Others Then
124: hxc_mpc_shd.g_api_dml := false; -- Unset the api dml status
125: Raise;

Line 124: hxc_mpc_shd.g_api_dml := false; -- Unset the api dml status

120: hxc_mpc_shd.g_api_dml := false; -- Unset the api dml status
121: hxc_mpc_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When Others Then
124: hxc_mpc_shd.g_api_dml := false; -- Unset the api dml status
125: Raise;
126: End insert_dml;
127: --
128: -- ----------------------------------------------------------------------------

Line 166: (p_rec in out nocopy hxc_mpc_shd.g_rec_type

162: --
163: -- {End Of Comments}
164: -- ----------------------------------------------------------------------------
165: Procedure pre_insert
166: (p_rec in out nocopy hxc_mpc_shd.g_rec_type
167: ) is
168: --
169: l_proc varchar2(72);
170: --

Line 226: (p_rec in hxc_mpc_shd.g_rec_type

222: --
223: -- {End Of Comments}
224: -- ----------------------------------------------------------------------------
225: Procedure post_insert
226: (p_rec in hxc_mpc_shd.g_rec_type
227: ) is
228: --
229: l_proc varchar2(72);
230: --

Line 274: (p_rec in out nocopy hxc_mpc_shd.g_rec_type

270: -- ----------------------------------------------------------------------------
271: -- |---------------------------------< ins >----------------------------------|
272: -- ----------------------------------------------------------------------------
273: Procedure ins
274: (p_rec in out nocopy hxc_mpc_shd.g_rec_type
275: ) is
276: --
277: l_proc varchar2(72);
278: --

Line 325: l_rec hxc_mpc_shd.g_rec_type;

321: ,p_mapping_component_id out nocopy number
322: ,p_object_version_number out nocopy number
323: ) is
324: --
325: l_rec hxc_mpc_shd.g_rec_type;
326: l_proc varchar2(72);
327: --
328: Begin
329: g_debug := hr_utility.debug_enabled;

Line 340: hxc_mpc_shd.convert_args

336: -- Call conversion function to turn arguments into the
337: -- p_rec structure.
338: --
339: l_rec :=
340: hxc_mpc_shd.convert_args
341: (null
342: ,p_field_name
343: ,p_name
344: ,p_bld_blk_info_type_id