APPS.HXC_HTR_INS dependencies on HXC_HTR_SHD

Line 56: (p_rec in out nocopy hxc_htr_shd.g_rec_type

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

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

Line 111: hxc_htr_shd.g_api_dml := false; -- Unset the api dml status

107: ,sysdate
108: ,fnd_global.login_id
109: );
110: --
111: hxc_htr_shd.g_api_dml := false; -- Unset the api dml status
112: --
113: if g_debug then
114: hr_utility.set_location(' Leaving:'||l_proc, 10);
115: end if;

Line 119: hxc_htr_shd.g_api_dml := false; -- Unset the api dml status

115: end if;
116: Exception
117: When hr_api.check_integrity_violated Then
118: -- A check constraint has been violated
119: hxc_htr_shd.g_api_dml := false; -- Unset the api dml status
120: hxc_htr_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.parent_integrity_violated Then
123: -- Parent integrity has been violated

Line 120: hxc_htr_shd.constraint_error

116: Exception
117: When hr_api.check_integrity_violated Then
118: -- A check constraint has been violated
119: hxc_htr_shd.g_api_dml := false; -- Unset the api dml status
120: hxc_htr_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.parent_integrity_violated Then
123: -- Parent integrity has been violated
124: hxc_htr_shd.g_api_dml := false; -- Unset the api dml status

Line 124: hxc_htr_shd.g_api_dml := false; -- Unset the api dml status

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

Line 125: hxc_htr_shd.constraint_error

121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.parent_integrity_violated Then
123: -- Parent integrity has been violated
124: hxc_htr_shd.g_api_dml := false; -- Unset the api dml status
125: hxc_htr_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.unique_integrity_violated Then
128: -- Unique integrity has been violated
129: hxc_htr_shd.g_api_dml := false; -- Unset the api dml status

Line 129: hxc_htr_shd.g_api_dml := false; -- Unset the api dml status

125: hxc_htr_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.unique_integrity_violated Then
128: -- Unique integrity has been violated
129: hxc_htr_shd.g_api_dml := false; -- Unset the api dml status
130: hxc_htr_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When Others Then
133: hxc_htr_shd.g_api_dml := false; -- Unset the api dml status

Line 130: hxc_htr_shd.constraint_error

126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.unique_integrity_violated Then
128: -- Unique integrity has been violated
129: hxc_htr_shd.g_api_dml := false; -- Unset the api dml status
130: hxc_htr_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When Others Then
133: hxc_htr_shd.g_api_dml := false; -- Unset the api dml status
134: Raise;

Line 133: hxc_htr_shd.g_api_dml := false; -- Unset the api dml status

129: hxc_htr_shd.g_api_dml := false; -- Unset the api dml status
130: hxc_htr_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When Others Then
133: hxc_htr_shd.g_api_dml := false; -- Unset the api dml status
134: Raise;
135: End insert_dml;
136: --
137: -- ----------------------------------------------------------------------------

Line 175: (p_rec in out nocopy hxc_htr_shd.g_rec_type

171: --
172: -- {End Of Comments}
173: -- ----------------------------------------------------------------------------
174: Procedure pre_insert
175: (p_rec in out nocopy hxc_htr_shd.g_rec_type
176: ) is
177: --
178: l_proc varchar2(72);
179: --

Line 236: ,p_rec in hxc_htr_shd.g_rec_type

232: -- {End Of Comments}
233: -- ----------------------------------------------------------------------------
234: Procedure post_insert
235: (p_effective_date in date
236: ,p_rec in hxc_htr_shd.g_rec_type
237: ) is
238: --
239: l_proc varchar2(72);
240: --

Line 296: ,p_rec in out nocopy hxc_htr_shd.g_rec_type

292: -- |---------------------------------< ins >----------------------------------|
293: -- ----------------------------------------------------------------------------
294: Procedure ins
295: (p_effective_date in date
296: ,p_rec in out nocopy hxc_htr_shd.g_rec_type
297: ) is
298: --
299: l_proc varchar2(72);
300: --

Line 354: l_rec hxc_htr_shd.g_rec_type;

350: ,p_time_recipient_id out nocopy number
351: ,p_object_version_number out nocopy number
352: ) is
353: --
354: l_rec hxc_htr_shd.g_rec_type;
355: l_proc varchar2(72);
356: --
357: Begin
358: g_debug := hr_utility.debug_enabled;

Line 369: hxc_htr_shd.convert_args

365: -- Call conversion function to turn arguments into the
366: -- p_rec structure.
367: --
368: l_rec :=
369: hxc_htr_shd.convert_args
370: (null
371: ,p_name
372: ,p_appl_retrieval_function
373: ,p_appl_update_process