DBA Data[Home] [Help]

APPS.HXC_MAP_INS dependencies on HXC_MAP_SHD

Line 56: (p_rec in out nocopy hxc_map_shd.g_rec_type

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

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

Line 95: hxc_map_shd.g_api_dml := false; -- Unset the api dml status

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

Line 103: hxc_map_shd.g_api_dml := false; -- Unset the api dml status

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

Line 104: hxc_map_shd.constraint_error

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

Line 108: hxc_map_shd.g_api_dml := false; -- Unset the api dml status

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

Line 109: hxc_map_shd.constraint_error

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

Line 113: hxc_map_shd.g_api_dml := false; -- Unset the api dml status

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

Line 114: hxc_map_shd.constraint_error

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

Line 117: hxc_map_shd.g_api_dml := false; -- Unset the api dml status

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

Line 159: (p_rec in out nocopy hxc_map_shd.g_rec_type

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

Line 219: (p_rec in hxc_map_shd.g_rec_type

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

Line 261: (p_rec in out nocopy hxc_map_shd.g_rec_type

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

Line 308: l_rec hxc_map_shd.g_rec_type;

304: ,p_mapping_id out nocopy number
305: ,p_object_version_number out nocopy number
306: ) is
307: --
308: l_rec hxc_map_shd.g_rec_type;
309: l_proc varchar2(72);
310: --
311: Begin
312: g_debug := hr_utility.debug_enabled;

Line 323: hxc_map_shd.convert_args

319: -- Call conversion function to turn arguments into the
320: -- p_rec structure.
321: --
322: l_rec :=
323: hxc_map_shd.convert_args
324: (null
325: ,p_name
326: ,null
327: );