DBA Data[Home] [Help]

APPS.HXC_HAT_UPD dependencies on HXC_HAT_SHD

Line 56: (p_rec in out nocopy hxc_hat_shd.g_rec_type

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

Line 96: hxc_hat_shd.constraint_error

92: Exception
93: When hr_api.check_integrity_violated Then
94: -- A check constraint has been violated
95: --
96: hxc_hat_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.parent_integrity_violated Then
99: -- Parent integrity has been violated
100: --

Line 101: hxc_hat_shd.constraint_error

97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.parent_integrity_violated Then
99: -- Parent integrity has been violated
100: --
101: hxc_hat_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.unique_integrity_violated Then
104: -- Unique integrity has been violated
105: --

Line 106: hxc_hat_shd.constraint_error

102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.unique_integrity_violated Then
104: -- Unique integrity has been violated
105: --
106: hxc_hat_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When Others Then
109: --
110: Raise;

Line 146: (p_rec in hxc_hat_shd.g_rec_type

142: --
143: -- {End Of Comments}
144: -- ----------------------------------------------------------------------------
145: Procedure pre_update
146: (p_rec in hxc_hat_shd.g_rec_type
147: ) is
148: --
149: l_proc varchar2(72);
150: --

Line 193: (p_rec in hxc_hat_shd.g_rec_type

189: --
190: -- {End Of Comments}
191: -- ----------------------------------------------------------------------------
192: Procedure post_update
193: (p_rec in hxc_hat_shd.g_rec_type
194: ) is
195: --
196: l_proc varchar2(72);
197: --

Line 215: => hxc_hat_shd.g_old_rec.alias_type

211: => p_rec.reference_object
212: ,p_object_version_number
213: => p_rec.object_version_number
214: ,p_alias_type_o
215: => hxc_hat_shd.g_old_rec.alias_type
216: ,p_reference_object_o
217: => hxc_hat_shd.g_old_rec.reference_object
218: ,p_object_version_number_o
219: => hxc_hat_shd.g_old_rec.object_version_number

Line 217: => hxc_hat_shd.g_old_rec.reference_object

213: => p_rec.object_version_number
214: ,p_alias_type_o
215: => hxc_hat_shd.g_old_rec.alias_type
216: ,p_reference_object_o
217: => hxc_hat_shd.g_old_rec.reference_object
218: ,p_object_version_number_o
219: => hxc_hat_shd.g_old_rec.object_version_number
220: );
221: --

Line 219: => hxc_hat_shd.g_old_rec.object_version_number

215: => hxc_hat_shd.g_old_rec.alias_type
216: ,p_reference_object_o
217: => hxc_hat_shd.g_old_rec.reference_object
218: ,p_object_version_number_o
219: => hxc_hat_shd.g_old_rec.object_version_number
220: );
221: --
222: exception
223: --

Line 281: (p_rec in out nocopy hxc_hat_shd.g_rec_type

277: --
278: -- {End Of Comments}
279: -- ----------------------------------------------------------------------------
280: Procedure convert_defs
281: (p_rec in out nocopy hxc_hat_shd.g_rec_type
282: ) is
283: --
284: Begin
285: --

Line 293: hxc_hat_shd.g_old_rec.alias_type;

289: -- is being used then we must set to the 'current' argument value.
290: --
291: If (p_rec.alias_type = hr_api.g_varchar2) then
292: p_rec.alias_type :=
293: hxc_hat_shd.g_old_rec.alias_type;
294: End If;
295: If (p_rec.reference_object = hr_api.g_varchar2) then
296: p_rec.reference_object :=
297: hxc_hat_shd.g_old_rec.reference_object;

Line 297: hxc_hat_shd.g_old_rec.reference_object;

293: hxc_hat_shd.g_old_rec.alias_type;
294: End If;
295: If (p_rec.reference_object = hr_api.g_varchar2) then
296: p_rec.reference_object :=
297: hxc_hat_shd.g_old_rec.reference_object;
298: End If;
299: --
300: End convert_defs;
301: --

Line 306: (p_rec in out nocopy hxc_hat_shd.g_rec_type

302: -- ----------------------------------------------------------------------------
303: -- |---------------------------------< upd >----------------------------------|
304: -- ----------------------------------------------------------------------------
305: Procedure upd
306: (p_rec in out nocopy hxc_hat_shd.g_rec_type
307: ) is
308: --
309: l_proc varchar2(72);
310: --

Line 320: hxc_hat_shd.lck

316: end if;
317: --
318: -- We must lock the row which we need to update.
319: --
320: hxc_hat_shd.lck
321: (p_rec.alias_type_id
322: ,p_rec.object_version_number
323: );
324: --

Line 367: l_rec hxc_hat_shd.g_rec_type;

363: ,p_alias_type in varchar2 default hr_api.g_varchar2
364: ,p_reference_object in varchar2 default hr_api.g_varchar2
365: ) is
366: --
367: l_rec hxc_hat_shd.g_rec_type;
368: l_proc varchar2(72);
369: --
370: Begin
371: g_debug:=hr_utility.debug_enabled;

Line 381: hxc_hat_shd.convert_args

377: -- Call conversion function to turn arguments into the
378: -- l_rec structure.
379: --
380: l_rec :=
381: hxc_hat_shd.convert_args
382: (p_alias_type_id
383: ,p_alias_type
384: ,p_reference_object
385: ,p_object_version_number