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: --
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: --
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: --
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;
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: --
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: --
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
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
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: --
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: --
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: --
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;
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;
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: --
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: --
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: --
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;
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