DBA Data[Home] [Help]

APPS.HXC_HAN_UPD dependencies on HXC_HAN_SHD

Line 56: (p_rec in out nocopy hxc_han_shd.g_rec_type

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

Line 110: hxc_han_shd.constraint_error

106: Exception
107: When hr_api.check_integrity_violated Then
108: -- A check constraint has been violated
109: --
110: hxc_han_shd.constraint_error
111: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
112: When hr_api.parent_integrity_violated Then
113: -- Parent integrity has been violated
114: --

Line 115: hxc_han_shd.constraint_error

111: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
112: When hr_api.parent_integrity_violated Then
113: -- Parent integrity has been violated
114: --
115: hxc_han_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.unique_integrity_violated Then
118: -- Unique integrity has been violated
119: --

Line 120: hxc_han_shd.constraint_error

116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.unique_integrity_violated Then
118: -- Unique integrity has been violated
119: --
120: hxc_han_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When Others Then
123: --
124: Raise;

Line 160: (p_rec in hxc_han_shd.g_rec_type

156: --
157: -- {End Of Comments}
158: -- ----------------------------------------------------------------------------
159: Procedure pre_update
160: (p_rec in hxc_han_shd.g_rec_type
161: ) is
162: --
163: l_proc varchar2(72) := g_package||'pre_update';
164: --

Line 208: (p_rec in hxc_han_shd.g_rec_type

204: --
205: -- {End Of Comments}
206: -- ----------------------------------------------------------------------------
207: Procedure post_update
208: (p_rec in hxc_han_shd.g_rec_type
209: ) is
210: --
211: l_proc varchar2(72) := g_package||'post_update';
212: --

Line 233: => hxc_han_shd.g_old_rec.notification_number_retries

229: => p_rec.notification_action_code
230: ,p_notification_recipient_code
231: => p_rec.notification_recipient_code
232: ,p_notification_num_retries_o
233: => hxc_han_shd.g_old_rec.notification_number_retries
234: ,p_notification_timeout_value_o
235: => hxc_han_shd.g_old_rec.notification_timeout_value
236: ,p_notification_action_code_o
237: => hxc_han_shd.g_old_rec.notification_action_code

Line 235: => hxc_han_shd.g_old_rec.notification_timeout_value

231: => p_rec.notification_recipient_code
232: ,p_notification_num_retries_o
233: => hxc_han_shd.g_old_rec.notification_number_retries
234: ,p_notification_timeout_value_o
235: => hxc_han_shd.g_old_rec.notification_timeout_value
236: ,p_notification_action_code_o
237: => hxc_han_shd.g_old_rec.notification_action_code
238: ,p_notification_recip_code_o
239: => hxc_han_shd.g_old_rec.notification_recipient_code

Line 237: => hxc_han_shd.g_old_rec.notification_action_code

233: => hxc_han_shd.g_old_rec.notification_number_retries
234: ,p_notification_timeout_value_o
235: => hxc_han_shd.g_old_rec.notification_timeout_value
236: ,p_notification_action_code_o
237: => hxc_han_shd.g_old_rec.notification_action_code
238: ,p_notification_recip_code_o
239: => hxc_han_shd.g_old_rec.notification_recipient_code
240: );
241: --

Line 239: => hxc_han_shd.g_old_rec.notification_recipient_code

235: => hxc_han_shd.g_old_rec.notification_timeout_value
236: ,p_notification_action_code_o
237: => hxc_han_shd.g_old_rec.notification_action_code
238: ,p_notification_recip_code_o
239: => hxc_han_shd.g_old_rec.notification_recipient_code
240: );
241: --
242: exception
243: --

Line 301: (p_rec in out nocopy hxc_han_shd.g_rec_type

297: --
298: -- {End Of Comments}
299: -- ----------------------------------------------------------------------------
300: Procedure convert_defs
301: (p_rec in out nocopy hxc_han_shd.g_rec_type
302: ) is
303: --
304: Begin
305: --

Line 313: hxc_han_shd.g_old_rec.notification_number_retries;

309: -- is being used then we must set to the 'current' argument value.
310: --
311: If (p_rec.notification_number_retries = hr_api.g_number) then
312: p_rec.notification_number_retries :=
313: hxc_han_shd.g_old_rec.notification_number_retries;
314: End If;
315: If (p_rec.notification_timeout_value = hr_api.g_number) then
316: p_rec.notification_timeout_value :=
317: hxc_han_shd.g_old_rec.notification_timeout_value;

Line 317: hxc_han_shd.g_old_rec.notification_timeout_value;

313: hxc_han_shd.g_old_rec.notification_number_retries;
314: End If;
315: If (p_rec.notification_timeout_value = hr_api.g_number) then
316: p_rec.notification_timeout_value :=
317: hxc_han_shd.g_old_rec.notification_timeout_value;
318: End If;
319: If (p_rec.notification_action_code = hr_api.g_varchar2) then
320: p_rec.notification_action_code :=
321: hxc_han_shd.g_old_rec.notification_action_code;

Line 321: hxc_han_shd.g_old_rec.notification_action_code;

317: hxc_han_shd.g_old_rec.notification_timeout_value;
318: End If;
319: If (p_rec.notification_action_code = hr_api.g_varchar2) then
320: p_rec.notification_action_code :=
321: hxc_han_shd.g_old_rec.notification_action_code;
322: End If;
323: If (p_rec.notification_recipient_code = hr_api.g_varchar2) then
324: p_rec.notification_recipient_code :=
325: hxc_han_shd.g_old_rec.notification_recipient_code;

Line 325: hxc_han_shd.g_old_rec.notification_recipient_code;

321: hxc_han_shd.g_old_rec.notification_action_code;
322: End If;
323: If (p_rec.notification_recipient_code = hr_api.g_varchar2) then
324: p_rec.notification_recipient_code :=
325: hxc_han_shd.g_old_rec.notification_recipient_code;
326: End If;
327: --
328: End convert_defs;
329: --

Line 334: (p_rec in out nocopy hxc_han_shd.g_rec_type

330: -- ----------------------------------------------------------------------------
331: -- |---------------------------------< upd >----------------------------------|
332: -- ----------------------------------------------------------------------------
333: Procedure upd
334: (p_rec in out nocopy hxc_han_shd.g_rec_type
335: ) is
336: --
337: l_proc varchar2(72) := g_package||'upd';
338: --

Line 348: hxc_han_shd.lck

344: -- We must lock the row which we need to update.
345: --
346:
347:
348: hxc_han_shd.lck
349: (p_rec.comp_notification_id
350: ,p_rec.object_version_number
351: );
352: --

Line 397: l_rec hxc_han_shd.g_rec_type;

393: ,p_notification_action_code in varchar2 default hr_api.g_varchar2
394: ,p_notification_recipient_code in varchar2 default hr_api.g_varchar2
395: ) is
396: --
397: l_rec hxc_han_shd.g_rec_type;
398: l_proc varchar2(72) := g_package||'upd';
399: --
400: Begin
401: if g_debug then

Line 409: hxc_han_shd.convert_args

405: -- Call conversion function to turn arguments into the
406: -- l_rec structure.
407: --
408: l_rec :=
409: hxc_han_shd.convert_args
410: (p_comp_notification_id
411: ,p_object_version_number
412: ,p_notification_number_retries
413: ,p_notification_timeout_value