APPS.HXC_HAS_INS dependencies on HXC_HAS_SHD

Line 55: (p_rec in out nocopy hxc_has_shd.g_rec_type

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

Line 67: hxc_has_shd.g_api_dml := true; -- Set the api dml status

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

Line 104: hxc_has_shd.g_api_dml := false; -- Unset the api dml status

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

Line 112: hxc_has_shd.g_api_dml := false; -- Unset the api dml status

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

Line 113: hxc_has_shd.constraint_error

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

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

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

Line 118: hxc_has_shd.constraint_error

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

Line 122: hxc_has_shd.g_api_dml := false; -- Unset the api dml status

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

Line 123: hxc_has_shd.constraint_error

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

Line 126: hxc_has_shd.g_api_dml := false; -- Unset the api dml status

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

Line 168: (p_rec in out nocopy hxc_has_shd.g_rec_type

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

Line 226: (p_rec in hxc_has_shd.g_rec_type

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

Line 278: (p_rec in out nocopy hxc_has_shd.g_rec_type

274: -- ----------------------------------------------------------------------------
275: -- |---------------------------------< ins >----------------------------------|
276: -- ----------------------------------------------------------------------------
277: Procedure ins
278: (p_rec in out nocopy hxc_has_shd.g_rec_type
279: ) is
280: --
281: l_proc varchar2(72);
282: --

Line 330: l_rec hxc_has_shd.g_rec_type;

326: ,p_approval_style_id out nocopy number
327: ,p_object_version_number out nocopy number
328: ) is
329: --
330: l_rec hxc_has_shd.g_rec_type;
331: l_proc varchar2(72);
332: --
333: Begin
334: g_debug:=hr_utility.debug_enabled;

Line 344: hxc_has_shd.convert_args

340: -- Call conversion function to turn arguments into the
341: -- p_rec structure.
342: --
343: l_rec :=
344: hxc_has_shd.convert_args
345: (null
346: ,null
347: ,p_name
348: ,p_business_group_id