DBA Data[Home] [Help]

APPS.HXC_HRT_UPD dependencies on HXC_HRT_SHD

Line 56: (p_rec in out nocopy hxc_hrt_shd.g_rec_type

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

Line 97: hxc_hrt_shd.constraint_error

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

Line 102: hxc_hrt_shd.constraint_error

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

Line 107: hxc_hrt_shd.constraint_error

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

Line 147: (p_rec in hxc_hrt_shd.g_rec_type

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

Line 195: ,p_rec in hxc_hrt_shd.g_rec_type

191: -- {End Of Comments}
192: -- ----------------------------------------------------------------------------
193: Procedure post_update
194: (p_effective_date in date
195: ,p_rec in hxc_hrt_shd.g_rec_type
196: ) is
197: --
198: l_proc varchar2(72);
199: --

Line 220: => hxc_hrt_shd.g_old_rec.time_recipient_id

216: => p_rec.mapping_id
217: ,p_object_version_number
218: => p_rec.object_version_number
219: ,p_time_recipient_id_o
220: => hxc_hrt_shd.g_old_rec.time_recipient_id
221: ,p_name_o
222: => hxc_hrt_shd.g_old_rec.name
223: ,p_mapping_id_o
224: => hxc_hrt_shd.g_old_rec.mapping_id

Line 222: => hxc_hrt_shd.g_old_rec.name

218: => p_rec.object_version_number
219: ,p_time_recipient_id_o
220: => hxc_hrt_shd.g_old_rec.time_recipient_id
221: ,p_name_o
222: => hxc_hrt_shd.g_old_rec.name
223: ,p_mapping_id_o
224: => hxc_hrt_shd.g_old_rec.mapping_id
225: ,p_object_version_number_o
226: => hxc_hrt_shd.g_old_rec.object_version_number

Line 224: => hxc_hrt_shd.g_old_rec.mapping_id

220: => hxc_hrt_shd.g_old_rec.time_recipient_id
221: ,p_name_o
222: => hxc_hrt_shd.g_old_rec.name
223: ,p_mapping_id_o
224: => hxc_hrt_shd.g_old_rec.mapping_id
225: ,p_object_version_number_o
226: => hxc_hrt_shd.g_old_rec.object_version_number
227: );
228: --

Line 226: => hxc_hrt_shd.g_old_rec.object_version_number

222: => hxc_hrt_shd.g_old_rec.name
223: ,p_mapping_id_o
224: => hxc_hrt_shd.g_old_rec.mapping_id
225: ,p_object_version_number_o
226: => hxc_hrt_shd.g_old_rec.object_version_number
227: );
228: --
229: exception
230: --

Line 288: (p_rec in out nocopy hxc_hrt_shd.g_rec_type

284: --
285: -- {End Of Comments}
286: -- ----------------------------------------------------------------------------
287: Procedure convert_defs
288: (p_rec in out nocopy hxc_hrt_shd.g_rec_type
289: ) is
290: --
291: Begin
292: --

Line 300: hxc_hrt_shd.g_old_rec.time_recipient_id;

296: -- is being used then we must set to the 'current' argument value.
297: --
298: If (p_rec.time_recipient_id = hr_api.g_number) then
299: p_rec.time_recipient_id :=
300: hxc_hrt_shd.g_old_rec.time_recipient_id;
301: End If;
302: If (p_rec.name = hr_api.g_varchar2) then
303: p_rec.name :=
304: hxc_hrt_shd.g_old_rec.name;

Line 304: hxc_hrt_shd.g_old_rec.name;

300: hxc_hrt_shd.g_old_rec.time_recipient_id;
301: End If;
302: If (p_rec.name = hr_api.g_varchar2) then
303: p_rec.name :=
304: hxc_hrt_shd.g_old_rec.name;
305: End If;
306: If (p_rec.mapping_id = hr_api.g_number) then
307: p_rec.mapping_id :=
308: hxc_hrt_shd.g_old_rec.mapping_id;

Line 308: hxc_hrt_shd.g_old_rec.mapping_id;

304: hxc_hrt_shd.g_old_rec.name;
305: End If;
306: If (p_rec.mapping_id = hr_api.g_number) then
307: p_rec.mapping_id :=
308: hxc_hrt_shd.g_old_rec.mapping_id;
309: End If;
310: --
311: End convert_defs;
312: --

Line 318: ,p_rec in out nocopy hxc_hrt_shd.g_rec_type

314: -- |---------------------------------< upd >----------------------------------|
315: -- ----------------------------------------------------------------------------
316: Procedure upd
317: (p_effective_date in date
318: ,p_rec in out nocopy hxc_hrt_shd.g_rec_type
319: ) is
320: --
321: l_proc varchar2(72);
322: --

Line 332: hxc_hrt_shd.lck

328: end if;
329: --
330: -- We must lock the row which we need to update.
331: --
332: hxc_hrt_shd.lck
333: (p_rec.retrieval_process_id
334: ,p_rec.object_version_number
335: );
336: --

Line 377: l_rec hxc_hrt_shd.g_rec_type;

373: ,p_name in varchar2 default hr_api.g_varchar2
374: ,p_mapping_id in number default hr_api.g_number
375: ) is
376: --
377: l_rec hxc_hrt_shd.g_rec_type;
378: l_proc varchar2(72);
379: --
380: Begin
381: g_debug:=hr_utility.debug_enabled;

Line 391: hxc_hrt_shd.convert_args

387: -- Call conversion function to turn arguments into the
388: -- l_rec structure.
389: --
390: l_rec :=
391: hxc_hrt_shd.convert_args
392: (p_retrieval_process_id
393: ,p_time_recipient_id
394: ,p_name
395: ,p_mapping_id