DBA Data[Home] [Help]

APPS.HXC_HAD_UPD dependencies on HXC_HAD_SHD

Line 56: (p_rec in out nocopy hxc_had_shd.g_rec_type

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

Line 101: hxc_had_shd.constraint_error

97: Exception
98: When hr_api.check_integrity_violated Then
99: -- A check constraint has been violated
100: --
101: hxc_had_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.parent_integrity_violated Then
104: -- Parent integrity has been violated
105: --

Line 106: hxc_had_shd.constraint_error

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

Line 111: hxc_had_shd.constraint_error

107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When hr_api.unique_integrity_violated Then
109: -- Unique integrity has been violated
110: --
111: hxc_had_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When Others Then
114: --
115: Raise;

Line 151: (p_rec in hxc_had_shd.g_rec_type

147: --
148: -- {End Of Comments}
149: -- ----------------------------------------------------------------------------
150: Procedure pre_update
151: (p_rec in hxc_had_shd.g_rec_type
152: ) is
153: --
154: l_proc varchar2(72);
155: --

Line 198: (p_rec in hxc_had_shd.g_rec_type

194: --
195: -- {End Of Comments}
196: -- ----------------------------------------------------------------------------
197: Procedure post_update
198: (p_rec in hxc_had_shd.g_rec_type
199: ) is
200: --
201: l_proc varchar2(72);
202: --

Line 228: => hxc_had_shd.g_old_rec.description

224: => p_rec.object_version_number
225: ,p_alias_type_id
226: => p_rec.alias_type_id
227: ,p_description_o
228: => hxc_had_shd.g_old_rec.description
229: ,p_alias_definition_name_o
230: => hxc_had_shd.g_old_rec.alias_definition_name
231: ,p_alias_context_code_o
232: =>hxc_had_shd.g_old_rec.alias_context_code

Line 230: => hxc_had_shd.g_old_rec.alias_definition_name

226: => p_rec.alias_type_id
227: ,p_description_o
228: => hxc_had_shd.g_old_rec.description
229: ,p_alias_definition_name_o
230: => hxc_had_shd.g_old_rec.alias_definition_name
231: ,p_alias_context_code_o
232: =>hxc_had_shd.g_old_rec.alias_context_code
233: ,p_business_group_id_o => hxc_ter_shd.g_old_rec.business_group_id
234: ,p_legislation_code_o => hxc_ter_shd.g_old_rec.legislation_code

Line 232: =>hxc_had_shd.g_old_rec.alias_context_code

228: => hxc_had_shd.g_old_rec.description
229: ,p_alias_definition_name_o
230: => hxc_had_shd.g_old_rec.alias_definition_name
231: ,p_alias_context_code_o
232: =>hxc_had_shd.g_old_rec.alias_context_code
233: ,p_business_group_id_o => hxc_ter_shd.g_old_rec.business_group_id
234: ,p_legislation_code_o => hxc_ter_shd.g_old_rec.legislation_code
235: ,p_timecard_field_o
236: => hxc_had_shd.g_old_rec.timecard_field

Line 236: => hxc_had_shd.g_old_rec.timecard_field

232: =>hxc_had_shd.g_old_rec.alias_context_code
233: ,p_business_group_id_o => hxc_ter_shd.g_old_rec.business_group_id
234: ,p_legislation_code_o => hxc_ter_shd.g_old_rec.legislation_code
235: ,p_timecard_field_o
236: => hxc_had_shd.g_old_rec.timecard_field
237: ,p_object_version_number_o
238: => hxc_had_shd.g_old_rec.object_version_number
239: ,p_alias_type_id_o
240: => hxc_had_shd.g_old_rec.alias_type_id

Line 238: => hxc_had_shd.g_old_rec.object_version_number

234: ,p_legislation_code_o => hxc_ter_shd.g_old_rec.legislation_code
235: ,p_timecard_field_o
236: => hxc_had_shd.g_old_rec.timecard_field
237: ,p_object_version_number_o
238: => hxc_had_shd.g_old_rec.object_version_number
239: ,p_alias_type_id_o
240: => hxc_had_shd.g_old_rec.alias_type_id
241: );
242: --

Line 240: => hxc_had_shd.g_old_rec.alias_type_id

236: => hxc_had_shd.g_old_rec.timecard_field
237: ,p_object_version_number_o
238: => hxc_had_shd.g_old_rec.object_version_number
239: ,p_alias_type_id_o
240: => hxc_had_shd.g_old_rec.alias_type_id
241: );
242: --
243: exception
244: --

Line 302: (p_rec in out nocopy hxc_had_shd.g_rec_type

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

Line 314: hxc_had_shd.g_old_rec.description;

310: -- is being used then we must set to the 'current' argument value.
311: --
312: If (p_rec.description = hr_api.g_varchar2) then
313: p_rec.description :=
314: hxc_had_shd.g_old_rec.description;
315: End If;
316: If (p_rec.alias_definition_name = hr_api.g_varchar2) then
317: p_rec.alias_definition_name :=
318: hxc_had_shd.g_old_rec.alias_definition_name;

Line 318: hxc_had_shd.g_old_rec.alias_definition_name;

314: hxc_had_shd.g_old_rec.description;
315: End If;
316: If (p_rec.alias_definition_name = hr_api.g_varchar2) then
317: p_rec.alias_definition_name :=
318: hxc_had_shd.g_old_rec.alias_definition_name;
319: End If;
320: If (p_rec.alias_context_code = hr_api.g_varchar2) then
321: p_rec.alias_context_code :=
322: hxc_had_shd.g_old_rec.alias_context_code;

Line 322: hxc_had_shd.g_old_rec.alias_context_code;

318: hxc_had_shd.g_old_rec.alias_definition_name;
319: End If;
320: If (p_rec.alias_context_code = hr_api.g_varchar2) then
321: p_rec.alias_context_code :=
322: hxc_had_shd.g_old_rec.alias_context_code;
323: End If;
324: If (p_rec.business_group_id = hr_api.g_number) then
325: p_rec.business_group_id :=
326: hxc_ter_shd.g_old_rec.business_group_id;

Line 334: hxc_had_shd.g_old_rec.timecard_field;

330: hxc_ter_shd.g_old_rec.legislation_code;
331: End If;
332: If (p_rec.timecard_field = hr_api.g_varchar2) then
333: p_rec.timecard_field :=
334: hxc_had_shd.g_old_rec.timecard_field;
335: End If;
336: If (p_rec.alias_type_id = hr_api.g_number) then
337: p_rec.alias_type_id :=
338: hxc_had_shd.g_old_rec.alias_type_id;

Line 338: hxc_had_shd.g_old_rec.alias_type_id;

334: hxc_had_shd.g_old_rec.timecard_field;
335: End If;
336: If (p_rec.alias_type_id = hr_api.g_number) then
337: p_rec.alias_type_id :=
338: hxc_had_shd.g_old_rec.alias_type_id;
339: End If;
340: --
341: End convert_defs;
342: --

Line 347: (p_rec in out nocopy hxc_had_shd.g_rec_type

343: -- ----------------------------------------------------------------------------
344: -- |---------------------------------< upd >----------------------------------|
345: -- ----------------------------------------------------------------------------
346: Procedure upd
347: (p_rec in out nocopy hxc_had_shd.g_rec_type
348: ) is
349: --
350: l_proc varchar2(72);
351: --

Line 361: hxc_had_shd.lck

357: end if;
358: --
359: -- We must lock the row which we need to update.
360: --
361: hxc_had_shd.lck
362: (p_rec.alias_definition_id
363: ,p_rec.object_version_number
364: );
365: --

Line 408: l_rec hxc_had_shd.g_rec_type;

404: ,p_prompt in varchar2 default hr_api.g_varchar2
405: ,p_alias_type_id in number
406: ) is
407: --
408: l_rec hxc_had_shd.g_rec_type;
409: l_proc varchar2(72);
410: --
411: Begin
412: g_debug:=hr_utility.debug_enabled;

Line 422: hxc_had_shd.convert_args

418: -- Call conversion function to turn arguments into the
419: -- l_rec structure.
420: --
421: l_rec :=
422: hxc_had_shd.convert_args
423: (p_alias_definition_id
424: ,p_description
425: ,p_alias_definition_name
426: ,p_alias_context_code