DBA Data[Home] [Help]

APPS.HXC_TER_INS dependencies on HXC_TER_SHD

Line 56: (p_rec in out nocopy hxc_ter_shd.g_rec_type

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

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

Line 176: hxc_ter_shd.g_api_dml := false; -- Unset the api dml status

172: --
173: if g_debug then
174: hr_utility.trace('error is '||SUBSTR(SQLERRM,1,60));
175: end if;
176: hxc_ter_shd.g_api_dml := false; -- Unset the api dml status
177: --
178: if g_debug then
179: hr_utility.set_location(' Leaving:'||l_proc, 10);
180: end if;

Line 187: hxc_ter_shd.g_api_dml := false; -- Unset the api dml status

183: if g_debug then
184: hr_utility.trace('error is '||SUBSTR(SQLERRM,1,60));
185: end if;
186: -- A check constraint has been violated
187: hxc_ter_shd.g_api_dml := false; -- Unset the api dml status
188: hxc_ter_shd.constraint_error
189: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
190: When hr_api.parent_integrity_violated Then
191: -- Parent integrity has been violated

Line 188: hxc_ter_shd.constraint_error

184: hr_utility.trace('error is '||SUBSTR(SQLERRM,1,60));
185: end if;
186: -- A check constraint has been violated
187: hxc_ter_shd.g_api_dml := false; -- Unset the api dml status
188: hxc_ter_shd.constraint_error
189: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
190: When hr_api.parent_integrity_violated Then
191: -- Parent integrity has been violated
192: if g_debug then

Line 195: hxc_ter_shd.g_api_dml := false; -- Unset the api dml status

191: -- Parent integrity has been violated
192: if g_debug then
193: hr_utility.trace('error is '||SUBSTR(SQLERRM,1,60));
194: end if;
195: hxc_ter_shd.g_api_dml := false; -- Unset the api dml status
196: hxc_ter_shd.constraint_error
197: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
198: When hr_api.unique_integrity_violated Then
199: -- Unique integrity has been violated

Line 196: hxc_ter_shd.constraint_error

192: if g_debug then
193: hr_utility.trace('error is '||SUBSTR(SQLERRM,1,60));
194: end if;
195: hxc_ter_shd.g_api_dml := false; -- Unset the api dml status
196: hxc_ter_shd.constraint_error
197: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
198: When hr_api.unique_integrity_violated Then
199: -- Unique integrity has been violated
200: if g_debug then

Line 203: hxc_ter_shd.g_api_dml := false; -- Unset the api dml status

199: -- Unique integrity has been violated
200: if g_debug then
201: hr_utility.trace('error is '||SUBSTR(SQLERRM,1,60));
202: end if;
203: hxc_ter_shd.g_api_dml := false; -- Unset the api dml status
204: hxc_ter_shd.constraint_error
205: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
206: When Others Then
207: if g_debug then

Line 204: hxc_ter_shd.constraint_error

200: if g_debug then
201: hr_utility.trace('error is '||SUBSTR(SQLERRM,1,60));
202: end if;
203: hxc_ter_shd.g_api_dml := false; -- Unset the api dml status
204: hxc_ter_shd.constraint_error
205: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
206: When Others Then
207: if g_debug then
208: hr_utility.trace('error is '||SUBSTR(SQLERRM,1,60));

Line 210: hxc_ter_shd.g_api_dml := false; -- Unset the api dml status

206: When Others Then
207: if g_debug then
208: hr_utility.trace('error is '||SUBSTR(SQLERRM,1,60));
209: end if;
210: hxc_ter_shd.g_api_dml := false; -- Unset the api dml status
211: Raise;
212: End insert_dml;
213: --
214: -- ----------------------------------------------------------------------------

Line 252: (p_rec in out nocopy hxc_ter_shd.g_rec_type

248: --
249: -- {End Of Comments}
250: -- ----------------------------------------------------------------------------
251: Procedure pre_insert
252: (p_rec in out nocopy hxc_ter_shd.g_rec_type
253: ) is
254: --
255: l_proc varchar2(72);
256: --

Line 313: ,p_rec in hxc_ter_shd.g_rec_type

309: -- {End Of Comments}
310: -- ----------------------------------------------------------------------------
311: Procedure post_insert
312: (p_effective_date in date
313: ,p_rec in hxc_ter_shd.g_rec_type
314: ) is
315: --
316: l_proc varchar2(72);
317: --

Line 424: ,p_rec in out nocopy hxc_ter_shd.g_rec_type

420: -- |---------------------------------< ins >----------------------------------|
421: -- ----------------------------------------------------------------------------
422: Procedure ins
423: (p_effective_date in date
424: ,p_rec in out nocopy hxc_ter_shd.g_rec_type
425: ) is
426: --
427: l_proc varchar2(72);
428: --

Line 513: l_rec hxc_ter_shd.g_rec_type;

509: ,p_attribute29 in varchar2 default null
510: ,p_attribute30 in varchar2 default null
511: ) is
512: --
513: l_rec hxc_ter_shd.g_rec_type;
514: l_proc varchar2(72);
515: --
516: Begin
517: g_debug := hr_utility.debug_enabled;

Line 528: hxc_ter_shd.convert_args

524: -- Call conversion function to turn arguments into the
525: -- p_rec structure.
526: --
527: l_rec :=
528: hxc_ter_shd.convert_args
529: (null
530: ,p_name
531: ,p_business_group_id
532: ,p_legislation_code