APPS.HXC_HTS_INS dependencies on HXC_HTS_SHD

Line 56: (p_rec in out nocopy hxc_hts_shd.g_rec_type

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

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

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

91: ,sysdate
92: ,fnd_global.login_id
93: );
94: --
95: hxc_hts_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_hts_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_hts_shd.g_api_dml := false; -- Unset the api dml status
104: hxc_hts_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_hts_shd.constraint_error

100: Exception
101: When hr_api.check_integrity_violated Then
102: -- A check constraint has been violated
103: hxc_hts_shd.g_api_dml := false; -- Unset the api dml status
104: hxc_hts_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_hts_shd.g_api_dml := false; -- Unset the api dml status

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

104: hxc_hts_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_hts_shd.g_api_dml := false; -- Unset the api dml status
109: hxc_hts_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_hts_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_hts_shd.g_api_dml := false; -- Unset the api dml status
109: hxc_hts_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_hts_shd.g_api_dml := false; -- Unset the api dml status

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

109: hxc_hts_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_hts_shd.g_api_dml := false; -- Unset the api dml status
114: hxc_hts_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When Others Then
117: hxc_hts_shd.g_api_dml := false; -- Unset the api dml status

Line 114: hxc_hts_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_hts_shd.g_api_dml := false; -- Unset the api dml status
114: hxc_hts_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When Others Then
117: hxc_hts_shd.g_api_dml := false; -- Unset the api dml status
118: Raise;

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

113: hxc_hts_shd.g_api_dml := false; -- Unset the api dml status
114: hxc_hts_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When Others Then
117: hxc_hts_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_hts_shd.g_rec_type

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

Line 220: ,p_rec in hxc_hts_shd.g_rec_type

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

Line 264: ,p_rec in out nocopy hxc_hts_shd.g_rec_type

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

Line 314: l_rec hxc_hts_shd.g_rec_type;

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

Line 329: hxc_hts_shd.convert_args

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