DBA Data[Home] [Help]

APPS.HXC_HSD_UPD dependencies on HXC_HSD_SHD

Line 56: (p_rec in out nocopy hxc_hsd_shd.g_rec_type

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

Line 91: hxc_hsd_shd.constraint_error

87: Exception
88: When hr_api.check_integrity_violated Then
89: -- A check constraint has been violated
90: --
91: hxc_hsd_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When hr_api.parent_integrity_violated Then
94: -- Parent integrity has been violated
95: --

Line 96: hxc_hsd_shd.constraint_error

92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When hr_api.parent_integrity_violated Then
94: -- Parent integrity has been violated
95: --
96: hxc_hsd_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.unique_integrity_violated Then
99: -- Unique integrity has been violated
100: --

Line 101: hxc_hsd_shd.constraint_error

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

Line 141: (p_rec in hxc_hsd_shd.g_rec_type

137: --
138: -- {End Of Comments}
139: -- ----------------------------------------------------------------------------
140: Procedure pre_update
141: (p_rec in hxc_hsd_shd.g_rec_type
142: ) is
143: --
144: l_proc varchar2(72);
145: --

Line 188: (p_rec in hxc_hsd_shd.g_rec_type

184: --
185: -- {End Of Comments}
186: -- ----------------------------------------------------------------------------
187: Procedure post_update
188: (p_rec in hxc_hsd_shd.g_rec_type
189: ) is
190: --
191: l_proc varchar2(72);
192: --

Line 210: => hxc_hsd_shd.g_old_rec.hxc_required

206: => p_rec.hxc_required
207: ,p_owner_application_id
208: => p_rec.owner_application_id
209: ,p_hxc_required_o
210: => hxc_hsd_shd.g_old_rec.hxc_required
211: ,p_owner_application_id_o
212: => hxc_hsd_shd.g_old_rec.owner_application_id
213: );
214: --

Line 212: => hxc_hsd_shd.g_old_rec.owner_application_id

208: => p_rec.owner_application_id
209: ,p_hxc_required_o
210: => hxc_hsd_shd.g_old_rec.hxc_required
211: ,p_owner_application_id_o
212: => hxc_hsd_shd.g_old_rec.owner_application_id
213: );
214: --
215: exception
216: --

Line 274: (p_rec in out nocopy hxc_hsd_shd.g_rec_type

270: --
271: -- {End Of Comments}
272: -- ----------------------------------------------------------------------------
273: Procedure convert_defs
274: (p_rec in out nocopy hxc_hsd_shd.g_rec_type
275: ) is
276: --
277: Begin
278: --

Line 286: hxc_hsd_shd.g_old_rec.hxc_required;

282: -- is being used then we must set to the 'current' argument value.
283: --
284: If (p_rec.hxc_required = hr_api.g_varchar2) then
285: p_rec.hxc_required :=
286: hxc_hsd_shd.g_old_rec.hxc_required;
287: End If;
288: If (p_rec.owner_application_id = hr_api.g_number) then
289: p_rec.owner_application_id :=
290: hxc_hsd_shd.g_old_rec.owner_application_id;

Line 290: hxc_hsd_shd.g_old_rec.owner_application_id;

286: hxc_hsd_shd.g_old_rec.hxc_required;
287: End If;
288: If (p_rec.owner_application_id = hr_api.g_number) then
289: p_rec.owner_application_id :=
290: hxc_hsd_shd.g_old_rec.owner_application_id;
291: End If;
292: --
293: End convert_defs;
294: --

Line 299: (p_rec in out nocopy hxc_hsd_shd.g_rec_type

295: -- ----------------------------------------------------------------------------
296: -- |---------------------------------< upd >----------------------------------|
297: -- ----------------------------------------------------------------------------
298: Procedure upd
299: (p_rec in out nocopy hxc_hsd_shd.g_rec_type
300: ) is
301: --
302: l_proc varchar2(72);
303: --

Line 313: hxc_hsd_shd.lck

309: end if;
310: --
311: -- We must lock the row which we need to update.
312: --
313: hxc_hsd_shd.lck
314: (p_rec.object_id
315: ,p_rec.object_type
316: );
317: --

Line 360: l_rec hxc_hsd_shd.g_rec_type;

356: ,p_hxc_required in varchar2 default hr_api.g_varchar2
357: ,p_owner_application_id in number default hr_api.g_number
358: ) is
359: --
360: l_rec hxc_hsd_shd.g_rec_type;
361: l_proc varchar2(72);
362: --
363: Begin
364: g_debug:=hr_utility.debug_enabled;

Line 374: hxc_hsd_shd.convert_args

370: -- Call conversion function to turn arguments into the
371: -- l_rec structure.
372: --
373: l_rec :=
374: hxc_hsd_shd.convert_args
375: (p_object_id
376: ,p_object_type
377: ,p_hxc_required
378: ,p_owner_application_id