DBA Data[Home] [Help]

APPS.HXC_ULP_UPD dependencies on HR_API

Line 99: When hr_api.check_integrity_violated Then

95: hr_utility.set_location(' Leaving:'||l_proc, 10);
96: end if;
97: --
98: Exception
99: When hr_api.check_integrity_violated Then
100: -- A check constraint has been violated
101: --
102: hxc_ulp_shd.constraint_error
103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

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

Line 104: When hr_api.parent_integrity_violated Then

100: -- A check constraint has been violated
101: --
102: hxc_ulp_shd.constraint_error
103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
104: When hr_api.parent_integrity_violated Then
105: -- Parent integrity has been violated
106: --
107: hxc_ulp_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

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

Line 109: When hr_api.unique_integrity_violated Then

105: -- Parent integrity has been violated
106: --
107: hxc_ulp_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When hr_api.unique_integrity_violated Then
110: -- Unique integrity has been violated
111: --
112: hxc_ulp_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

109: When hr_api.unique_integrity_violated Then
110: -- Unique integrity has been violated
111: --
112: hxc_ulp_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When Others Then
115: --
116: Raise;
117: End update_dml;

Line 251: when hr_api.cannot_find_prog_unit then

247: );
248: --
249: exception
250: --
251: when hr_api.cannot_find_prog_unit then
252: --
253: hr_api.cannot_find_prog_unit_error
254: (p_module_name => 'HXC_LAYOUT_COMP_PROMPTS'
255: ,p_hook_type => 'AU');

Line 253: hr_api.cannot_find_prog_unit_error

249: exception
250: --
251: when hr_api.cannot_find_prog_unit then
252: --
253: hr_api.cannot_find_prog_unit_error
254: (p_module_name => 'HXC_LAYOUT_COMP_PROMPTS'
255: ,p_hook_type => 'AU');
256: --
257: end;

Line 318: If (p_rec.layout_component_id = hr_api.g_number) then

314: -- p_rec plsql record structure
315: -- to see if a system default is being used. If a system default
316: -- is being used then we must set to the 'current' argument value.
317: --
318: If (p_rec.layout_component_id = hr_api.g_number) then
319: p_rec.layout_component_id :=
320: hxc_ulp_shd.g_old_rec.layout_component_id;
321: End If;
322: If (p_rec.prompt_alias = hr_api.g_varchar2) then

Line 322: If (p_rec.prompt_alias = hr_api.g_varchar2) then

318: If (p_rec.layout_component_id = hr_api.g_number) then
319: p_rec.layout_component_id :=
320: hxc_ulp_shd.g_old_rec.layout_component_id;
321: End If;
322: If (p_rec.prompt_alias = hr_api.g_varchar2) then
323: p_rec.prompt_alias :=
324: hxc_ulp_shd.g_old_rec.prompt_alias;
325: End If;
326: If (p_rec.prompt_type = hr_api.g_varchar2) then

Line 326: If (p_rec.prompt_type = hr_api.g_varchar2) then

322: If (p_rec.prompt_alias = hr_api.g_varchar2) then
323: p_rec.prompt_alias :=
324: hxc_ulp_shd.g_old_rec.prompt_alias;
325: End If;
326: If (p_rec.prompt_type = hr_api.g_varchar2) then
327: p_rec.prompt_type :=
328: hxc_ulp_shd.g_old_rec.prompt_type;
329: End If;
330: If (p_rec.region_code = hr_api.g_varchar2) then

Line 330: If (p_rec.region_code = hr_api.g_varchar2) then

326: If (p_rec.prompt_type = hr_api.g_varchar2) then
327: p_rec.prompt_type :=
328: hxc_ulp_shd.g_old_rec.prompt_type;
329: End If;
330: If (p_rec.region_code = hr_api.g_varchar2) then
331: p_rec.region_code :=
332: hxc_ulp_shd.g_old_rec.region_code;
333: End If;
334: If (p_rec.region_application_id = hr_api.g_number) then

Line 334: If (p_rec.region_application_id = hr_api.g_number) then

330: If (p_rec.region_code = hr_api.g_varchar2) then
331: p_rec.region_code :=
332: hxc_ulp_shd.g_old_rec.region_code;
333: End If;
334: If (p_rec.region_application_id = hr_api.g_number) then
335: p_rec.region_application_id :=
336: hxc_ulp_shd.g_old_rec.region_application_id;
337: End If;
338: If (p_rec.attribute_code = hr_api.g_varchar2) then

Line 338: If (p_rec.attribute_code = hr_api.g_varchar2) then

334: If (p_rec.region_application_id = hr_api.g_number) then
335: p_rec.region_application_id :=
336: hxc_ulp_shd.g_old_rec.region_application_id;
337: End If;
338: If (p_rec.attribute_code = hr_api.g_varchar2) then
339: p_rec.attribute_code :=
340: hxc_ulp_shd.g_old_rec.attribute_code;
341: End If;
342: If (p_rec.attribute_application_id = hr_api.g_number) then

Line 342: If (p_rec.attribute_application_id = hr_api.g_number) then

338: If (p_rec.attribute_code = hr_api.g_varchar2) then
339: p_rec.attribute_code :=
340: hxc_ulp_shd.g_old_rec.attribute_code;
341: End If;
342: If (p_rec.attribute_application_id = hr_api.g_number) then
343: p_rec.attribute_application_id :=
344: hxc_ulp_shd.g_old_rec.attribute_application_id;
345: End If;
346: --

Line 404: ,p_layout_component_id in number default hr_api.g_number

400: -- ----------------------------------------------------------------------------
401: Procedure upd
402: (p_layout_comp_prompt_id in number
403: ,p_object_version_number in out nocopy number
404: ,p_layout_component_id in number default hr_api.g_number
405: ,p_prompt_alias in varchar2 default hr_api.g_varchar2
406: ,p_prompt_type in varchar2 default hr_api.g_varchar2
407: ,p_region_code in varchar2 default hr_api.g_varchar2
408: ,p_region_application_id in number default hr_api.g_number

Line 405: ,p_prompt_alias in varchar2 default hr_api.g_varchar2

401: Procedure upd
402: (p_layout_comp_prompt_id in number
403: ,p_object_version_number in out nocopy number
404: ,p_layout_component_id in number default hr_api.g_number
405: ,p_prompt_alias in varchar2 default hr_api.g_varchar2
406: ,p_prompt_type in varchar2 default hr_api.g_varchar2
407: ,p_region_code in varchar2 default hr_api.g_varchar2
408: ,p_region_application_id in number default hr_api.g_number
409: ,p_attribute_code in varchar2 default hr_api.g_varchar2

Line 406: ,p_prompt_type in varchar2 default hr_api.g_varchar2

402: (p_layout_comp_prompt_id in number
403: ,p_object_version_number in out nocopy number
404: ,p_layout_component_id in number default hr_api.g_number
405: ,p_prompt_alias in varchar2 default hr_api.g_varchar2
406: ,p_prompt_type in varchar2 default hr_api.g_varchar2
407: ,p_region_code in varchar2 default hr_api.g_varchar2
408: ,p_region_application_id in number default hr_api.g_number
409: ,p_attribute_code in varchar2 default hr_api.g_varchar2
410: ,p_attribute_application_id in number default hr_api.g_number

Line 407: ,p_region_code in varchar2 default hr_api.g_varchar2

403: ,p_object_version_number in out nocopy number
404: ,p_layout_component_id in number default hr_api.g_number
405: ,p_prompt_alias in varchar2 default hr_api.g_varchar2
406: ,p_prompt_type in varchar2 default hr_api.g_varchar2
407: ,p_region_code in varchar2 default hr_api.g_varchar2
408: ,p_region_application_id in number default hr_api.g_number
409: ,p_attribute_code in varchar2 default hr_api.g_varchar2
410: ,p_attribute_application_id in number default hr_api.g_number
411: ) is

Line 408: ,p_region_application_id in number default hr_api.g_number

404: ,p_layout_component_id in number default hr_api.g_number
405: ,p_prompt_alias in varchar2 default hr_api.g_varchar2
406: ,p_prompt_type in varchar2 default hr_api.g_varchar2
407: ,p_region_code in varchar2 default hr_api.g_varchar2
408: ,p_region_application_id in number default hr_api.g_number
409: ,p_attribute_code in varchar2 default hr_api.g_varchar2
410: ,p_attribute_application_id in number default hr_api.g_number
411: ) is
412: --

Line 409: ,p_attribute_code in varchar2 default hr_api.g_varchar2

405: ,p_prompt_alias in varchar2 default hr_api.g_varchar2
406: ,p_prompt_type in varchar2 default hr_api.g_varchar2
407: ,p_region_code in varchar2 default hr_api.g_varchar2
408: ,p_region_application_id in number default hr_api.g_number
409: ,p_attribute_code in varchar2 default hr_api.g_varchar2
410: ,p_attribute_application_id in number default hr_api.g_number
411: ) is
412: --
413: l_rec hxc_ulp_shd.g_rec_type;

Line 410: ,p_attribute_application_id in number default hr_api.g_number

406: ,p_prompt_type in varchar2 default hr_api.g_varchar2
407: ,p_region_code in varchar2 default hr_api.g_varchar2
408: ,p_region_application_id in number default hr_api.g_number
409: ,p_attribute_code in varchar2 default hr_api.g_varchar2
410: ,p_attribute_application_id in number default hr_api.g_number
411: ) is
412: --
413: l_rec hxc_ulp_shd.g_rec_type;
414: l_proc varchar2(72) ;