DBA Data[Home] [Help]

APPS.HXC_HAD_UPD dependencies on HR_API

Line 98: When hr_api.check_integrity_violated Then

94: hr_utility.set_location(' Leaving:'||l_proc, 10);
95: end if;
96: --
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));

Line 102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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: --
106: hxc_had_shd.constraint_error

Line 103: When hr_api.parent_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: --
106: hxc_had_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 107: (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: --
111: hxc_had_shd.constraint_error

Line 108: When hr_api.unique_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: --
111: hxc_had_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 112: (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;
116: End update_dml;

Line 245: when hr_api.cannot_find_prog_unit then

241: );
242: --
243: exception
244: --
245: when hr_api.cannot_find_prog_unit then
246: --
247: hr_api.cannot_find_prog_unit_error
248: (p_module_name => 'HXC_ALIAS_DEFINITIONS'
249: ,p_hook_type => 'AU');

Line 247: hr_api.cannot_find_prog_unit_error

243: exception
244: --
245: when hr_api.cannot_find_prog_unit then
246: --
247: hr_api.cannot_find_prog_unit_error
248: (p_module_name => 'HXC_ALIAS_DEFINITIONS'
249: ,p_hook_type => 'AU');
250: --
251: end;

Line 312: If (p_rec.description = hr_api.g_varchar2) then

308: -- p_rec plsql record structure
309: -- to see if a system default is being used. If a system default
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

Line 316: If (p_rec.alias_definition_name = hr_api.g_varchar2) then

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;
319: End If;
320: If (p_rec.alias_context_code = hr_api.g_varchar2) then

Line 320: If (p_rec.alias_context_code = hr_api.g_varchar2) then

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;
323: End If;
324: If (p_rec.business_group_id = hr_api.g_number) then

Line 324: If (p_rec.business_group_id = hr_api.g_number) then

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;
327: End If;
328: If (p_rec.legislation_code = hr_api.g_varchar2) then

Line 328: If (p_rec.legislation_code = hr_api.g_varchar2) then

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;
327: End If;
328: If (p_rec.legislation_code = hr_api.g_varchar2) then
329: p_rec.legislation_code :=
330: hxc_ter_shd.g_old_rec.legislation_code;
331: End If;
332: If (p_rec.timecard_field = hr_api.g_varchar2) then

Line 332: If (p_rec.timecard_field = hr_api.g_varchar2) then

328: If (p_rec.legislation_code = hr_api.g_varchar2) then
329: p_rec.legislation_code :=
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

Line 336: If (p_rec.alias_type_id = hr_api.g_number) then

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;
339: End If;
340: --

Line 398: ,p_alias_definition_name in varchar2 default hr_api.g_varchar2

394: -- ----------------------------------------------------------------------------
395: Procedure upd
396: (p_alias_definition_id in number
397: ,p_object_version_number in out nocopy number
398: ,p_alias_definition_name in varchar2 default hr_api.g_varchar2
399: ,p_alias_context_code in varchar2 default hr_api.g_varchar2
400: ,p_business_group_id in number default hr_api.g_number
401: ,p_legislation_code in varchar2 default hr_api.g_varchar2
402: ,p_timecard_field in varchar2 default hr_api.g_varchar2

Line 399: ,p_alias_context_code in varchar2 default hr_api.g_varchar2

395: Procedure upd
396: (p_alias_definition_id in number
397: ,p_object_version_number in out nocopy number
398: ,p_alias_definition_name in varchar2 default hr_api.g_varchar2
399: ,p_alias_context_code in varchar2 default hr_api.g_varchar2
400: ,p_business_group_id in number default hr_api.g_number
401: ,p_legislation_code in varchar2 default hr_api.g_varchar2
402: ,p_timecard_field in varchar2 default hr_api.g_varchar2
403: ,p_description in varchar2 default hr_api.g_varchar2

Line 400: ,p_business_group_id in number default hr_api.g_number

396: (p_alias_definition_id in number
397: ,p_object_version_number in out nocopy number
398: ,p_alias_definition_name in varchar2 default hr_api.g_varchar2
399: ,p_alias_context_code in varchar2 default hr_api.g_varchar2
400: ,p_business_group_id in number default hr_api.g_number
401: ,p_legislation_code in varchar2 default hr_api.g_varchar2
402: ,p_timecard_field in varchar2 default hr_api.g_varchar2
403: ,p_description in varchar2 default hr_api.g_varchar2
404: ,p_prompt in varchar2 default hr_api.g_varchar2

Line 401: ,p_legislation_code in varchar2 default hr_api.g_varchar2

397: ,p_object_version_number in out nocopy number
398: ,p_alias_definition_name in varchar2 default hr_api.g_varchar2
399: ,p_alias_context_code in varchar2 default hr_api.g_varchar2
400: ,p_business_group_id in number default hr_api.g_number
401: ,p_legislation_code in varchar2 default hr_api.g_varchar2
402: ,p_timecard_field in varchar2 default hr_api.g_varchar2
403: ,p_description in varchar2 default hr_api.g_varchar2
404: ,p_prompt in varchar2 default hr_api.g_varchar2
405: ,p_alias_type_id in number

Line 402: ,p_timecard_field in varchar2 default hr_api.g_varchar2

398: ,p_alias_definition_name in varchar2 default hr_api.g_varchar2
399: ,p_alias_context_code in varchar2 default hr_api.g_varchar2
400: ,p_business_group_id in number default hr_api.g_number
401: ,p_legislation_code in varchar2 default hr_api.g_varchar2
402: ,p_timecard_field in varchar2 default hr_api.g_varchar2
403: ,p_description in varchar2 default hr_api.g_varchar2
404: ,p_prompt in varchar2 default hr_api.g_varchar2
405: ,p_alias_type_id in number
406: ) is

Line 403: ,p_description in varchar2 default hr_api.g_varchar2

399: ,p_alias_context_code in varchar2 default hr_api.g_varchar2
400: ,p_business_group_id in number default hr_api.g_number
401: ,p_legislation_code in varchar2 default hr_api.g_varchar2
402: ,p_timecard_field in varchar2 default hr_api.g_varchar2
403: ,p_description in varchar2 default hr_api.g_varchar2
404: ,p_prompt in varchar2 default hr_api.g_varchar2
405: ,p_alias_type_id in number
406: ) is
407: --

Line 404: ,p_prompt in varchar2 default hr_api.g_varchar2

400: ,p_business_group_id in number default hr_api.g_number
401: ,p_legislation_code in varchar2 default hr_api.g_varchar2
402: ,p_timecard_field in varchar2 default hr_api.g_varchar2
403: ,p_description in varchar2 default hr_api.g_varchar2
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;