106: hr_utility.set_location(' Leaving:'||l_proc, 10);
107: end if;
108: --
109: Exception
110: When hr_api.check_integrity_violated Then
111: -- A check constraint has been violated
112: --
113: hxc_ulc_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.check_integrity_violated Then
111: -- A check constraint has been violated
112: --
113: hxc_ulc_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.parent_integrity_violated Then
116: -- Parent integrity has been violated
117: --
118: hxc_ulc_shd.constraint_error
111: -- A check constraint has been violated
112: --
113: hxc_ulc_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.parent_integrity_violated Then
116: -- Parent integrity has been violated
117: --
118: hxc_ulc_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.parent_integrity_violated Then
116: -- Parent integrity has been violated
117: --
118: hxc_ulc_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.unique_integrity_violated Then
121: -- Unique integrity has been violated
122: --
123: hxc_ulc_shd.constraint_error
116: -- Parent integrity has been violated
117: --
118: hxc_ulc_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.unique_integrity_violated Then
121: -- Unique integrity has been violated
122: --
123: hxc_ulc_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.unique_integrity_violated Then
121: -- Unique integrity has been violated
122: --
123: hxc_ulc_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When Others Then
126: --
127: Raise;
128: End update_dml;
302: );
303: --
304: exception
305: --
306: when hr_api.cannot_find_prog_unit then
307: --
308: hr_api.cannot_find_prog_unit_error
309: (p_module_name => 'HXC_LAYOUT_COMPONENTS'
310: ,p_hook_type => 'AU');
304: exception
305: --
306: when hr_api.cannot_find_prog_unit then
307: --
308: hr_api.cannot_find_prog_unit_error
309: (p_module_name => 'HXC_LAYOUT_COMPONENTS'
310: ,p_hook_type => 'AU');
311: --
312: end;
369: -- p_rec plsql record structure
370: -- to see if a system default is being used. If a system default
371: -- is being used then we must set to the 'current' argument value.
372: --
373: If (p_rec.layout_id = hr_api.g_number) then
374: p_rec.layout_id :=
375: hxc_ulc_shd.g_old_rec.layout_id;
376: End If;
377: If (p_rec.layout_comp_definition_id = hr_api.g_number) then
373: If (p_rec.layout_id = hr_api.g_number) then
374: p_rec.layout_id :=
375: hxc_ulc_shd.g_old_rec.layout_id;
376: End If;
377: If (p_rec.layout_comp_definition_id = hr_api.g_number) then
378: p_rec.layout_comp_definition_id :=
379: hxc_ulc_shd.g_old_rec.layout_comp_definition_id;
380: End If;
381: If (p_rec.parent_component_id = hr_api.g_number) then
377: If (p_rec.layout_comp_definition_id = hr_api.g_number) then
378: p_rec.layout_comp_definition_id :=
379: hxc_ulc_shd.g_old_rec.layout_comp_definition_id;
380: End If;
381: If (p_rec.parent_component_id = hr_api.g_number) then
382: p_rec.parent_component_id :=
383: hxc_ulc_shd.g_old_rec.parent_component_id;
384: End If;
385: If (p_rec.component_name = hr_api.g_varchar2) then
381: If (p_rec.parent_component_id = hr_api.g_number) then
382: p_rec.parent_component_id :=
383: hxc_ulc_shd.g_old_rec.parent_component_id;
384: End If;
385: If (p_rec.component_name = hr_api.g_varchar2) then
386: p_rec.component_name :=
387: hxc_ulc_shd.g_old_rec.component_name;
388: End If;
389: If (p_rec.component_value = hr_api.g_varchar2) then
385: If (p_rec.component_name = hr_api.g_varchar2) then
386: p_rec.component_name :=
387: hxc_ulc_shd.g_old_rec.component_name;
388: End If;
389: If (p_rec.component_value = hr_api.g_varchar2) then
390: p_rec.component_value :=
391: hxc_ulc_shd.g_old_rec.component_value;
392: End If;
393: If (p_rec.sequence = hr_api.g_number) then
389: If (p_rec.component_value = hr_api.g_varchar2) then
390: p_rec.component_value :=
391: hxc_ulc_shd.g_old_rec.component_value;
392: End If;
393: If (p_rec.sequence = hr_api.g_number) then
394: p_rec.sequence :=
395: hxc_ulc_shd.g_old_rec.sequence;
396: End If;
397: If (p_rec.name_value_string = hr_api.g_varchar2) then
393: If (p_rec.sequence = hr_api.g_number) then
394: p_rec.sequence :=
395: hxc_ulc_shd.g_old_rec.sequence;
396: End If;
397: If (p_rec.name_value_string = hr_api.g_varchar2) then
398: p_rec.name_value_string :=
399: hxc_ulc_shd.g_old_rec.name_value_string;
400: End If;
401: If (p_rec.region_code = hr_api.g_varchar2) then
397: If (p_rec.name_value_string = hr_api.g_varchar2) then
398: p_rec.name_value_string :=
399: hxc_ulc_shd.g_old_rec.name_value_string;
400: End If;
401: If (p_rec.region_code = hr_api.g_varchar2) then
402: p_rec.region_code :=
403: hxc_ulc_shd.g_old_rec.region_code;
404: End If;
405: If (p_rec.region_code_app_id = hr_api.g_number) then
401: If (p_rec.region_code = hr_api.g_varchar2) then
402: p_rec.region_code :=
403: hxc_ulc_shd.g_old_rec.region_code;
404: End If;
405: If (p_rec.region_code_app_id = hr_api.g_number) then
406: p_rec.region_code_app_id :=
407: hxc_ulc_shd.g_old_rec.region_code_app_id;
408: End If;
409: If (p_rec.attribute_code = hr_api.g_varchar2) then
405: If (p_rec.region_code_app_id = hr_api.g_number) then
406: p_rec.region_code_app_id :=
407: hxc_ulc_shd.g_old_rec.region_code_app_id;
408: End If;
409: If (p_rec.attribute_code = hr_api.g_varchar2) then
410: p_rec.attribute_code :=
411: hxc_ulc_shd.g_old_rec.attribute_code;
412: End If;
413: If (p_rec.attribute_code_app_id = hr_api.g_number) then
409: If (p_rec.attribute_code = hr_api.g_varchar2) then
410: p_rec.attribute_code :=
411: hxc_ulc_shd.g_old_rec.attribute_code;
412: End If;
413: If (p_rec.attribute_code_app_id = hr_api.g_number) then
414: p_rec.attribute_code_app_id :=
415: hxc_ulc_shd.g_old_rec.attribute_code_app_id;
416: End If;
417: If (p_rec.component_alias = hr_api.g_varchar2) then
413: If (p_rec.attribute_code_app_id = hr_api.g_number) then
414: p_rec.attribute_code_app_id :=
415: hxc_ulc_shd.g_old_rec.attribute_code_app_id;
416: End If;
417: If (p_rec.component_alias = hr_api.g_varchar2) then
418: p_rec.component_alias :=
419: hxc_ulc_shd.g_old_rec.component_alias;
420: End If;
421: If (p_rec.parent_bean = hr_api.g_varchar2) then
417: If (p_rec.component_alias = hr_api.g_varchar2) then
418: p_rec.component_alias :=
419: hxc_ulc_shd.g_old_rec.component_alias;
420: End If;
421: If (p_rec.parent_bean = hr_api.g_varchar2) then
422: p_rec.parent_bean :=
423: hxc_ulc_shd.g_old_rec.parent_bean;
424: End If;
425: If (p_rec.attribute1 = hr_api.g_varchar2) then
421: If (p_rec.parent_bean = hr_api.g_varchar2) then
422: p_rec.parent_bean :=
423: hxc_ulc_shd.g_old_rec.parent_bean;
424: End If;
425: If (p_rec.attribute1 = hr_api.g_varchar2) then
426: p_rec.attribute1 :=
427: hxc_ulc_shd.g_old_rec.attribute1;
428: End If;
429: If (p_rec.attribute2 = hr_api.g_varchar2) then
425: If (p_rec.attribute1 = hr_api.g_varchar2) then
426: p_rec.attribute1 :=
427: hxc_ulc_shd.g_old_rec.attribute1;
428: End If;
429: If (p_rec.attribute2 = hr_api.g_varchar2) then
430: p_rec.attribute2 :=
431: hxc_ulc_shd.g_old_rec.attribute2;
432: End If;
433: If (p_rec.attribute3 = hr_api.g_varchar2) then
429: If (p_rec.attribute2 = hr_api.g_varchar2) then
430: p_rec.attribute2 :=
431: hxc_ulc_shd.g_old_rec.attribute2;
432: End If;
433: If (p_rec.attribute3 = hr_api.g_varchar2) then
434: p_rec.attribute3 :=
435: hxc_ulc_shd.g_old_rec.attribute3;
436: End If;
437: If (p_rec.attribute4 = hr_api.g_varchar2) then
433: If (p_rec.attribute3 = hr_api.g_varchar2) then
434: p_rec.attribute3 :=
435: hxc_ulc_shd.g_old_rec.attribute3;
436: End If;
437: If (p_rec.attribute4 = hr_api.g_varchar2) then
438: p_rec.attribute4 :=
439: hxc_ulc_shd.g_old_rec.attribute4;
440: End If;
441: If (p_rec.attribute5 = hr_api.g_varchar2) then
437: If (p_rec.attribute4 = hr_api.g_varchar2) then
438: p_rec.attribute4 :=
439: hxc_ulc_shd.g_old_rec.attribute4;
440: End If;
441: If (p_rec.attribute5 = hr_api.g_varchar2) then
442: p_rec.attribute5 :=
443: hxc_ulc_shd.g_old_rec.attribute5;
444: End If;
445: --
499: -- ----------------------------------------------------------------------------
500: Procedure upd
501: (p_layout_component_id in number
502: ,p_object_version_number in out nocopy number
503: ,p_layout_id in number default hr_api.g_number
504: ,p_parent_component_id in number default hr_api.g_number
505: ,p_sequence in number default hr_api.g_number
506: ,p_component_name in varchar2 default hr_api.g_varchar2
507: ,p_component_value in varchar2 default hr_api.g_varchar2
500: Procedure upd
501: (p_layout_component_id in number
502: ,p_object_version_number in out nocopy number
503: ,p_layout_id in number default hr_api.g_number
504: ,p_parent_component_id in number default hr_api.g_number
505: ,p_sequence in number default hr_api.g_number
506: ,p_component_name in varchar2 default hr_api.g_varchar2
507: ,p_component_value in varchar2 default hr_api.g_varchar2
508: ,p_name_value_string in varchar2 default hr_api.g_varchar2
501: (p_layout_component_id in number
502: ,p_object_version_number in out nocopy number
503: ,p_layout_id in number default hr_api.g_number
504: ,p_parent_component_id in number default hr_api.g_number
505: ,p_sequence in number default hr_api.g_number
506: ,p_component_name in varchar2 default hr_api.g_varchar2
507: ,p_component_value in varchar2 default hr_api.g_varchar2
508: ,p_name_value_string in varchar2 default hr_api.g_varchar2
509: ,p_region_code in varchar2 default hr_api.g_varchar2
502: ,p_object_version_number in out nocopy number
503: ,p_layout_id in number default hr_api.g_number
504: ,p_parent_component_id in number default hr_api.g_number
505: ,p_sequence in number default hr_api.g_number
506: ,p_component_name in varchar2 default hr_api.g_varchar2
507: ,p_component_value in varchar2 default hr_api.g_varchar2
508: ,p_name_value_string in varchar2 default hr_api.g_varchar2
509: ,p_region_code in varchar2 default hr_api.g_varchar2
510: ,p_region_code_app_id in number default hr_api.g_number
503: ,p_layout_id in number default hr_api.g_number
504: ,p_parent_component_id in number default hr_api.g_number
505: ,p_sequence in number default hr_api.g_number
506: ,p_component_name in varchar2 default hr_api.g_varchar2
507: ,p_component_value in varchar2 default hr_api.g_varchar2
508: ,p_name_value_string in varchar2 default hr_api.g_varchar2
509: ,p_region_code in varchar2 default hr_api.g_varchar2
510: ,p_region_code_app_id in number default hr_api.g_number
511: ,p_attribute_code in varchar2 default hr_api.g_varchar2
504: ,p_parent_component_id in number default hr_api.g_number
505: ,p_sequence in number default hr_api.g_number
506: ,p_component_name in varchar2 default hr_api.g_varchar2
507: ,p_component_value in varchar2 default hr_api.g_varchar2
508: ,p_name_value_string in varchar2 default hr_api.g_varchar2
509: ,p_region_code in varchar2 default hr_api.g_varchar2
510: ,p_region_code_app_id in number default hr_api.g_number
511: ,p_attribute_code in varchar2 default hr_api.g_varchar2
512: ,p_attribute_code_app_id in number default hr_api.g_number
505: ,p_sequence in number default hr_api.g_number
506: ,p_component_name in varchar2 default hr_api.g_varchar2
507: ,p_component_value in varchar2 default hr_api.g_varchar2
508: ,p_name_value_string in varchar2 default hr_api.g_varchar2
509: ,p_region_code in varchar2 default hr_api.g_varchar2
510: ,p_region_code_app_id in number default hr_api.g_number
511: ,p_attribute_code in varchar2 default hr_api.g_varchar2
512: ,p_attribute_code_app_id in number default hr_api.g_number
513: ,p_layout_comp_definition_id in number default hr_api.g_number
506: ,p_component_name in varchar2 default hr_api.g_varchar2
507: ,p_component_value in varchar2 default hr_api.g_varchar2
508: ,p_name_value_string in varchar2 default hr_api.g_varchar2
509: ,p_region_code in varchar2 default hr_api.g_varchar2
510: ,p_region_code_app_id in number default hr_api.g_number
511: ,p_attribute_code in varchar2 default hr_api.g_varchar2
512: ,p_attribute_code_app_id in number default hr_api.g_number
513: ,p_layout_comp_definition_id in number default hr_api.g_number
514: ,p_component_alias in varchar2 default hr_api.g_varchar2
507: ,p_component_value in varchar2 default hr_api.g_varchar2
508: ,p_name_value_string in varchar2 default hr_api.g_varchar2
509: ,p_region_code in varchar2 default hr_api.g_varchar2
510: ,p_region_code_app_id in number default hr_api.g_number
511: ,p_attribute_code in varchar2 default hr_api.g_varchar2
512: ,p_attribute_code_app_id in number default hr_api.g_number
513: ,p_layout_comp_definition_id in number default hr_api.g_number
514: ,p_component_alias in varchar2 default hr_api.g_varchar2
515: ,p_parent_bean in varchar2 default hr_api.g_varchar2
508: ,p_name_value_string in varchar2 default hr_api.g_varchar2
509: ,p_region_code in varchar2 default hr_api.g_varchar2
510: ,p_region_code_app_id in number default hr_api.g_number
511: ,p_attribute_code in varchar2 default hr_api.g_varchar2
512: ,p_attribute_code_app_id in number default hr_api.g_number
513: ,p_layout_comp_definition_id in number default hr_api.g_number
514: ,p_component_alias in varchar2 default hr_api.g_varchar2
515: ,p_parent_bean in varchar2 default hr_api.g_varchar2
516: ,p_attribute1 in varchar2 default hr_api.g_varchar2
509: ,p_region_code in varchar2 default hr_api.g_varchar2
510: ,p_region_code_app_id in number default hr_api.g_number
511: ,p_attribute_code in varchar2 default hr_api.g_varchar2
512: ,p_attribute_code_app_id in number default hr_api.g_number
513: ,p_layout_comp_definition_id in number default hr_api.g_number
514: ,p_component_alias in varchar2 default hr_api.g_varchar2
515: ,p_parent_bean in varchar2 default hr_api.g_varchar2
516: ,p_attribute1 in varchar2 default hr_api.g_varchar2
517: ,p_attribute2 in varchar2 default hr_api.g_varchar2
510: ,p_region_code_app_id in number default hr_api.g_number
511: ,p_attribute_code in varchar2 default hr_api.g_varchar2
512: ,p_attribute_code_app_id in number default hr_api.g_number
513: ,p_layout_comp_definition_id in number default hr_api.g_number
514: ,p_component_alias in varchar2 default hr_api.g_varchar2
515: ,p_parent_bean in varchar2 default hr_api.g_varchar2
516: ,p_attribute1 in varchar2 default hr_api.g_varchar2
517: ,p_attribute2 in varchar2 default hr_api.g_varchar2
518: ,p_attribute3 in varchar2 default hr_api.g_varchar2
511: ,p_attribute_code in varchar2 default hr_api.g_varchar2
512: ,p_attribute_code_app_id in number default hr_api.g_number
513: ,p_layout_comp_definition_id in number default hr_api.g_number
514: ,p_component_alias in varchar2 default hr_api.g_varchar2
515: ,p_parent_bean in varchar2 default hr_api.g_varchar2
516: ,p_attribute1 in varchar2 default hr_api.g_varchar2
517: ,p_attribute2 in varchar2 default hr_api.g_varchar2
518: ,p_attribute3 in varchar2 default hr_api.g_varchar2
519: ,p_attribute4 in varchar2 default hr_api.g_varchar2
512: ,p_attribute_code_app_id in number default hr_api.g_number
513: ,p_layout_comp_definition_id in number default hr_api.g_number
514: ,p_component_alias in varchar2 default hr_api.g_varchar2
515: ,p_parent_bean in varchar2 default hr_api.g_varchar2
516: ,p_attribute1 in varchar2 default hr_api.g_varchar2
517: ,p_attribute2 in varchar2 default hr_api.g_varchar2
518: ,p_attribute3 in varchar2 default hr_api.g_varchar2
519: ,p_attribute4 in varchar2 default hr_api.g_varchar2
520: ,p_attribute5 in varchar2 default hr_api.g_varchar2
513: ,p_layout_comp_definition_id in number default hr_api.g_number
514: ,p_component_alias in varchar2 default hr_api.g_varchar2
515: ,p_parent_bean in varchar2 default hr_api.g_varchar2
516: ,p_attribute1 in varchar2 default hr_api.g_varchar2
517: ,p_attribute2 in varchar2 default hr_api.g_varchar2
518: ,p_attribute3 in varchar2 default hr_api.g_varchar2
519: ,p_attribute4 in varchar2 default hr_api.g_varchar2
520: ,p_attribute5 in varchar2 default hr_api.g_varchar2
521: ) is
514: ,p_component_alias in varchar2 default hr_api.g_varchar2
515: ,p_parent_bean in varchar2 default hr_api.g_varchar2
516: ,p_attribute1 in varchar2 default hr_api.g_varchar2
517: ,p_attribute2 in varchar2 default hr_api.g_varchar2
518: ,p_attribute3 in varchar2 default hr_api.g_varchar2
519: ,p_attribute4 in varchar2 default hr_api.g_varchar2
520: ,p_attribute5 in varchar2 default hr_api.g_varchar2
521: ) is
522: --
515: ,p_parent_bean in varchar2 default hr_api.g_varchar2
516: ,p_attribute1 in varchar2 default hr_api.g_varchar2
517: ,p_attribute2 in varchar2 default hr_api.g_varchar2
518: ,p_attribute3 in varchar2 default hr_api.g_varchar2
519: ,p_attribute4 in varchar2 default hr_api.g_varchar2
520: ,p_attribute5 in varchar2 default hr_api.g_varchar2
521: ) is
522: --
523: l_rec hxc_ulc_shd.g_rec_type;
516: ,p_attribute1 in varchar2 default hr_api.g_varchar2
517: ,p_attribute2 in varchar2 default hr_api.g_varchar2
518: ,p_attribute3 in varchar2 default hr_api.g_varchar2
519: ,p_attribute4 in varchar2 default hr_api.g_varchar2
520: ,p_attribute5 in varchar2 default hr_api.g_varchar2
521: ) is
522: --
523: l_rec hxc_ulc_shd.g_rec_type;
524: l_proc varchar2(72) ;