APPS.HXC_APS_INS dependencies on HXC_APS_SHD

Line 55: (p_rec in out nocopy hxc_aps_shd.g_rec_type

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

Line 67: hxc_aps_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_aps_shd.g_api_dml := true; -- Set the api dml status
68: --
69: -- Insert the row into: hxc_approval_period_sets
70: --
71: insert into hxc_approval_period_sets

Line 92: hxc_aps_shd.g_api_dml := false; -- Unset the api dml status

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

Line 100: hxc_aps_shd.g_api_dml := false; -- Unset the api dml status

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

Line 101: hxc_aps_shd.constraint_error

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

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

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

Line 106: hxc_aps_shd.constraint_error

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

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

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

Line 111: hxc_aps_shd.constraint_error

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

Line 114: hxc_aps_shd.g_api_dml := false; -- Unset the api dml status

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

Line 156: (p_rec in out nocopy hxc_aps_shd.g_rec_type

152: --
153: -- {End Of Comments}
154: -- ----------------------------------------------------------------------------
155: Procedure pre_insert
156: (p_rec in out nocopy hxc_aps_shd.g_rec_type
157: ) is
158: --
159: l_proc varchar2(72);
160: --

Line 214: (p_rec in hxc_aps_shd.g_rec_type

210: --
211: -- {End Of Comments}
212: -- ----------------------------------------------------------------------------
213: Procedure post_insert
214: (p_rec in hxc_aps_shd.g_rec_type
215: ) is
216: --
217: l_proc varchar2(72);
218: --

Line 255: (p_rec in out nocopy hxc_aps_shd.g_rec_type

251: -- ----------------------------------------------------------------------------
252: -- |---------------------------------< ins >----------------------------------|
253: -- ----------------------------------------------------------------------------
254: Procedure ins
255: (p_rec in out nocopy hxc_aps_shd.g_rec_type
256: ) is
257: --
258: l_proc varchar2(72);
259: --

Line 301: l_rec hxc_aps_shd.g_rec_type;

297: ,p_approval_period_set_id out nocopy number
298: ,p_object_version_number out nocopy number
299: ) is
300: --
301: l_rec hxc_aps_shd.g_rec_type;
302: l_proc varchar2(72);
303: --
304: Begin
305: g_debug:=hr_utility.debug_enabled;

Line 315: hxc_aps_shd.convert_args

311: -- Call conversion function to turn arguments into the
312: -- p_rec structure.
313: --
314: l_rec :=
315: hxc_aps_shd.convert_args
316: (null
317: ,p_name
318: ,null
319: );