11: --
12: procedure create_form_item
13: (p_validate in boolean default false
14: ,p_effective_date in date
15: ,p_language_code in varchar2 default hr_api.userenv_lang
16: ,p_application_id in number
17: ,p_form_id in number
18: ,p_full_item_name in varchar2
19: ,p_item_type in varchar2
126: -- instead of p_language_code from now on, to allow an IN OUT parameter to
127: -- be passed through.
128: --
129: l_language_code := p_language_code;
130: hr_api.validate_language_code(p_language_code => l_language_code);
131: --
132: hr_utility.set_location(l_proc, 20);
133: --
134: --
221: ,p_next_navigation_item_id => p_next_navigation_item_id
222: ,p_previous_navigation_item_id => p_previous_navigation_item_id);
223:
224: exception
225: when hr_api.cannot_find_prog_unit then
226: hr_api.cannot_find_prog_unit_error
227: (p_module_name => 'create_form_item'
228: ,p_hook_type => 'BP'
229: );
222: ,p_previous_navigation_item_id => p_previous_navigation_item_id);
223:
224: exception
225: when hr_api.cannot_find_prog_unit then
226: hr_api.cannot_find_prog_unit_error
227: (p_module_name => 'create_form_item'
228: ,p_hook_type => 'BP'
229: );
230: end;
440: -- ,p_form_item_property_id => l_form_item_property_id
441: ,p_object_version_number => l_object_version_number
442: ,p_override_value_warning => l_override_value_warning);
443: exception
444: when hr_api.cannot_find_prog_unit then
445: hr_api.cannot_find_prog_unit_error
446: (p_module_name => 'create_form_item'
447: ,p_hook_type => 'AP'
448: );
441: ,p_object_version_number => l_object_version_number
442: ,p_override_value_warning => l_override_value_warning);
443: exception
444: when hr_api.cannot_find_prog_unit then
445: hr_api.cannot_find_prog_unit_error
446: (p_module_name => 'create_form_item'
447: ,p_hook_type => 'AP'
448: );
449: end;
453: --
454: -- When in validation only mode raise the Validate_Enabled exception
455: --
456: if p_validate then
457: raise hr_api.validate_enabled;
458: end if;
459: --
460: -- Set all output arguments
461: --
464: p_override_value_warning := l_override_value_warning;
465: --
466: hr_utility.set_location(' Leaving:'||l_proc, 70);
467: exception
468: when hr_api.validate_enabled then
469: --
470: -- As the Validate_Enabled exception has been raised
471: -- we must rollback to the savepoint
472: --
522: (p_form_item_id => p_form_item_id
523: ,p_object_version_number => p_object_version_number
524: );
525: exception
526: when hr_api.cannot_find_prog_unit then
527: hr_api.cannot_find_prog_unit_error
528: (p_module_name => 'delete_form_item'
529: ,p_hook_type => 'BP'
530: );
523: ,p_object_version_number => p_object_version_number
524: );
525: exception
526: when hr_api.cannot_find_prog_unit then
527: hr_api.cannot_find_prog_unit_error
528: (p_module_name => 'delete_form_item'
529: ,p_hook_type => 'BP'
530: );
531: end;
563: (p_form_item_id => p_form_item_id
564: ,p_object_version_number => p_object_version_number
565: );
566: exception
567: when hr_api.cannot_find_prog_unit then
568: hr_api.cannot_find_prog_unit_error
569: (p_module_name => 'delete_form_item'
570: ,p_hook_type => 'AP'
571: );
564: ,p_object_version_number => p_object_version_number
565: );
566: exception
567: when hr_api.cannot_find_prog_unit then
568: hr_api.cannot_find_prog_unit_error
569: (p_module_name => 'delete_form_item'
570: ,p_hook_type => 'AP'
571: );
572: end;
575: --
576: hr_utility.set_location('At:'|| l_proc, 40);
577:
578: if p_validate then
579: raise hr_api.validate_enabled;
580: end if;
581: --
582: hr_utility.set_location(' Leaving:'||l_proc, 70);
583: exception
580: end if;
581: --
582: hr_utility.set_location(' Leaving:'||l_proc, 70);
583: exception
584: when hr_api.validate_enabled then
585: --
586: -- As the Validate_Enabled exception has been raised
587: -- we must rollback to the savepoint
588: --
608: --
609: procedure update_form_item
610: (p_validate in boolean default false
611: ,p_effective_date in date
612: ,p_language_code in varchar2 default hr_api.userenv_lang
613: ,p_form_item_id in number
614: ,p_object_version_number in out nocopy number
615: ,p_full_item_name in varchar2 default hr_api.g_varchar2
616: --,p_item_type in varchar2 default hr_api.g_varchar2
611: ,p_effective_date in date
612: ,p_language_code in varchar2 default hr_api.userenv_lang
613: ,p_form_item_id in number
614: ,p_object_version_number in out nocopy number
615: ,p_full_item_name in varchar2 default hr_api.g_varchar2
616: --,p_item_type in varchar2 default hr_api.g_varchar2
617: ,p_user_item_name in varchar2 default hr_api.g_varchar2
618: ,p_description in varchar2 default hr_api.g_varchar2
619: ,p_radio_button_name in varchar2 default hr_api.g_varchar2
612: ,p_language_code in varchar2 default hr_api.userenv_lang
613: ,p_form_item_id in number
614: ,p_object_version_number in out nocopy number
615: ,p_full_item_name in varchar2 default hr_api.g_varchar2
616: --,p_item_type in varchar2 default hr_api.g_varchar2
617: ,p_user_item_name in varchar2 default hr_api.g_varchar2
618: ,p_description in varchar2 default hr_api.g_varchar2
619: ,p_radio_button_name in varchar2 default hr_api.g_varchar2
620: ,p_required_override in number default hr_api.g_number
613: ,p_form_item_id in number
614: ,p_object_version_number in out nocopy number
615: ,p_full_item_name in varchar2 default hr_api.g_varchar2
616: --,p_item_type in varchar2 default hr_api.g_varchar2
617: ,p_user_item_name in varchar2 default hr_api.g_varchar2
618: ,p_description in varchar2 default hr_api.g_varchar2
619: ,p_radio_button_name in varchar2 default hr_api.g_varchar2
620: ,p_required_override in number default hr_api.g_number
621: ,p_form_tab_page_id_override in number default hr_api.g_number
614: ,p_object_version_number in out nocopy number
615: ,p_full_item_name in varchar2 default hr_api.g_varchar2
616: --,p_item_type in varchar2 default hr_api.g_varchar2
617: ,p_user_item_name in varchar2 default hr_api.g_varchar2
618: ,p_description in varchar2 default hr_api.g_varchar2
619: ,p_radio_button_name in varchar2 default hr_api.g_varchar2
620: ,p_required_override in number default hr_api.g_number
621: ,p_form_tab_page_id_override in number default hr_api.g_number
622: ,p_visible_override in number default hr_api.g_number
615: ,p_full_item_name in varchar2 default hr_api.g_varchar2
616: --,p_item_type in varchar2 default hr_api.g_varchar2
617: ,p_user_item_name in varchar2 default hr_api.g_varchar2
618: ,p_description in varchar2 default hr_api.g_varchar2
619: ,p_radio_button_name in varchar2 default hr_api.g_varchar2
620: ,p_required_override in number default hr_api.g_number
621: ,p_form_tab_page_id_override in number default hr_api.g_number
622: ,p_visible_override in number default hr_api.g_number
623: ,p_alignment in number default hr_api.g_number
616: --,p_item_type in varchar2 default hr_api.g_varchar2
617: ,p_user_item_name in varchar2 default hr_api.g_varchar2
618: ,p_description in varchar2 default hr_api.g_varchar2
619: ,p_radio_button_name in varchar2 default hr_api.g_varchar2
620: ,p_required_override in number default hr_api.g_number
621: ,p_form_tab_page_id_override in number default hr_api.g_number
622: ,p_visible_override in number default hr_api.g_number
623: ,p_alignment in number default hr_api.g_number
624: ,p_bevel in number default hr_api.g_number
617: ,p_user_item_name in varchar2 default hr_api.g_varchar2
618: ,p_description in varchar2 default hr_api.g_varchar2
619: ,p_radio_button_name in varchar2 default hr_api.g_varchar2
620: ,p_required_override in number default hr_api.g_number
621: ,p_form_tab_page_id_override in number default hr_api.g_number
622: ,p_visible_override in number default hr_api.g_number
623: ,p_alignment in number default hr_api.g_number
624: ,p_bevel in number default hr_api.g_number
625: ,p_case_restriction in number default hr_api.g_number
618: ,p_description in varchar2 default hr_api.g_varchar2
619: ,p_radio_button_name in varchar2 default hr_api.g_varchar2
620: ,p_required_override in number default hr_api.g_number
621: ,p_form_tab_page_id_override in number default hr_api.g_number
622: ,p_visible_override in number default hr_api.g_number
623: ,p_alignment in number default hr_api.g_number
624: ,p_bevel in number default hr_api.g_number
625: ,p_case_restriction in number default hr_api.g_number
626: ,p_default_value in varchar2 default hr_api.g_varchar2
619: ,p_radio_button_name in varchar2 default hr_api.g_varchar2
620: ,p_required_override in number default hr_api.g_number
621: ,p_form_tab_page_id_override in number default hr_api.g_number
622: ,p_visible_override in number default hr_api.g_number
623: ,p_alignment in number default hr_api.g_number
624: ,p_bevel in number default hr_api.g_number
625: ,p_case_restriction in number default hr_api.g_number
626: ,p_default_value in varchar2 default hr_api.g_varchar2
627: ,p_enabled in number default hr_api.g_number
620: ,p_required_override in number default hr_api.g_number
621: ,p_form_tab_page_id_override in number default hr_api.g_number
622: ,p_visible_override in number default hr_api.g_number
623: ,p_alignment in number default hr_api.g_number
624: ,p_bevel in number default hr_api.g_number
625: ,p_case_restriction in number default hr_api.g_number
626: ,p_default_value in varchar2 default hr_api.g_varchar2
627: ,p_enabled in number default hr_api.g_number
628: ,p_format_mask in varchar2 default hr_api.g_varchar2
621: ,p_form_tab_page_id_override in number default hr_api.g_number
622: ,p_visible_override in number default hr_api.g_number
623: ,p_alignment in number default hr_api.g_number
624: ,p_bevel in number default hr_api.g_number
625: ,p_case_restriction in number default hr_api.g_number
626: ,p_default_value in varchar2 default hr_api.g_varchar2
627: ,p_enabled in number default hr_api.g_number
628: ,p_format_mask in varchar2 default hr_api.g_varchar2
629: ,p_height in number default hr_api.g_number
622: ,p_visible_override in number default hr_api.g_number
623: ,p_alignment in number default hr_api.g_number
624: ,p_bevel in number default hr_api.g_number
625: ,p_case_restriction in number default hr_api.g_number
626: ,p_default_value in varchar2 default hr_api.g_varchar2
627: ,p_enabled in number default hr_api.g_number
628: ,p_format_mask in varchar2 default hr_api.g_varchar2
629: ,p_height in number default hr_api.g_number
630: ,p_information_formula_id in number default hr_api.g_number
623: ,p_alignment in number default hr_api.g_number
624: ,p_bevel in number default hr_api.g_number
625: ,p_case_restriction in number default hr_api.g_number
626: ,p_default_value in varchar2 default hr_api.g_varchar2
627: ,p_enabled in number default hr_api.g_number
628: ,p_format_mask in varchar2 default hr_api.g_varchar2
629: ,p_height in number default hr_api.g_number
630: ,p_information_formula_id in number default hr_api.g_number
631: ,p_information_param_item_id1 in number default hr_api.g_number
624: ,p_bevel in number default hr_api.g_number
625: ,p_case_restriction in number default hr_api.g_number
626: ,p_default_value in varchar2 default hr_api.g_varchar2
627: ,p_enabled in number default hr_api.g_number
628: ,p_format_mask in varchar2 default hr_api.g_varchar2
629: ,p_height in number default hr_api.g_number
630: ,p_information_formula_id in number default hr_api.g_number
631: ,p_information_param_item_id1 in number default hr_api.g_number
632: ,p_information_param_item_id2 in number default hr_api.g_number
625: ,p_case_restriction in number default hr_api.g_number
626: ,p_default_value in varchar2 default hr_api.g_varchar2
627: ,p_enabled in number default hr_api.g_number
628: ,p_format_mask in varchar2 default hr_api.g_varchar2
629: ,p_height in number default hr_api.g_number
630: ,p_information_formula_id in number default hr_api.g_number
631: ,p_information_param_item_id1 in number default hr_api.g_number
632: ,p_information_param_item_id2 in number default hr_api.g_number
633: ,p_information_param_item_id3 in number default hr_api.g_number
626: ,p_default_value in varchar2 default hr_api.g_varchar2
627: ,p_enabled in number default hr_api.g_number
628: ,p_format_mask in varchar2 default hr_api.g_varchar2
629: ,p_height in number default hr_api.g_number
630: ,p_information_formula_id in number default hr_api.g_number
631: ,p_information_param_item_id1 in number default hr_api.g_number
632: ,p_information_param_item_id2 in number default hr_api.g_number
633: ,p_information_param_item_id3 in number default hr_api.g_number
634: ,p_information_param_item_id4 in number default hr_api.g_number
627: ,p_enabled in number default hr_api.g_number
628: ,p_format_mask in varchar2 default hr_api.g_varchar2
629: ,p_height in number default hr_api.g_number
630: ,p_information_formula_id in number default hr_api.g_number
631: ,p_information_param_item_id1 in number default hr_api.g_number
632: ,p_information_param_item_id2 in number default hr_api.g_number
633: ,p_information_param_item_id3 in number default hr_api.g_number
634: ,p_information_param_item_id4 in number default hr_api.g_number
635: ,p_information_param_item_id5 in number default hr_api.g_number
628: ,p_format_mask in varchar2 default hr_api.g_varchar2
629: ,p_height in number default hr_api.g_number
630: ,p_information_formula_id in number default hr_api.g_number
631: ,p_information_param_item_id1 in number default hr_api.g_number
632: ,p_information_param_item_id2 in number default hr_api.g_number
633: ,p_information_param_item_id3 in number default hr_api.g_number
634: ,p_information_param_item_id4 in number default hr_api.g_number
635: ,p_information_param_item_id5 in number default hr_api.g_number
636: ,p_information_prompt in varchar2 default hr_api.g_varchar2
629: ,p_height in number default hr_api.g_number
630: ,p_information_formula_id in number default hr_api.g_number
631: ,p_information_param_item_id1 in number default hr_api.g_number
632: ,p_information_param_item_id2 in number default hr_api.g_number
633: ,p_information_param_item_id3 in number default hr_api.g_number
634: ,p_information_param_item_id4 in number default hr_api.g_number
635: ,p_information_param_item_id5 in number default hr_api.g_number
636: ,p_information_prompt in varchar2 default hr_api.g_varchar2
637: ,p_insert_allowed in number default hr_api.g_number
630: ,p_information_formula_id in number default hr_api.g_number
631: ,p_information_param_item_id1 in number default hr_api.g_number
632: ,p_information_param_item_id2 in number default hr_api.g_number
633: ,p_information_param_item_id3 in number default hr_api.g_number
634: ,p_information_param_item_id4 in number default hr_api.g_number
635: ,p_information_param_item_id5 in number default hr_api.g_number
636: ,p_information_prompt in varchar2 default hr_api.g_varchar2
637: ,p_insert_allowed in number default hr_api.g_number
638: ,p_label in varchar2 default hr_api.g_varchar2
631: ,p_information_param_item_id1 in number default hr_api.g_number
632: ,p_information_param_item_id2 in number default hr_api.g_number
633: ,p_information_param_item_id3 in number default hr_api.g_number
634: ,p_information_param_item_id4 in number default hr_api.g_number
635: ,p_information_param_item_id5 in number default hr_api.g_number
636: ,p_information_prompt in varchar2 default hr_api.g_varchar2
637: ,p_insert_allowed in number default hr_api.g_number
638: ,p_label in varchar2 default hr_api.g_varchar2
639: ,p_prompt_text in varchar2 default hr_api.g_varchar2
632: ,p_information_param_item_id2 in number default hr_api.g_number
633: ,p_information_param_item_id3 in number default hr_api.g_number
634: ,p_information_param_item_id4 in number default hr_api.g_number
635: ,p_information_param_item_id5 in number default hr_api.g_number
636: ,p_information_prompt in varchar2 default hr_api.g_varchar2
637: ,p_insert_allowed in number default hr_api.g_number
638: ,p_label in varchar2 default hr_api.g_varchar2
639: ,p_prompt_text in varchar2 default hr_api.g_varchar2
640: ,p_prompt_alignment_offset in number default hr_api.g_number
633: ,p_information_param_item_id3 in number default hr_api.g_number
634: ,p_information_param_item_id4 in number default hr_api.g_number
635: ,p_information_param_item_id5 in number default hr_api.g_number
636: ,p_information_prompt in varchar2 default hr_api.g_varchar2
637: ,p_insert_allowed in number default hr_api.g_number
638: ,p_label in varchar2 default hr_api.g_varchar2
639: ,p_prompt_text in varchar2 default hr_api.g_varchar2
640: ,p_prompt_alignment_offset in number default hr_api.g_number
641: ,p_prompt_display_style in number default hr_api.g_number
634: ,p_information_param_item_id4 in number default hr_api.g_number
635: ,p_information_param_item_id5 in number default hr_api.g_number
636: ,p_information_prompt in varchar2 default hr_api.g_varchar2
637: ,p_insert_allowed in number default hr_api.g_number
638: ,p_label in varchar2 default hr_api.g_varchar2
639: ,p_prompt_text in varchar2 default hr_api.g_varchar2
640: ,p_prompt_alignment_offset in number default hr_api.g_number
641: ,p_prompt_display_style in number default hr_api.g_number
642: ,p_prompt_edge in number default hr_api.g_number
635: ,p_information_param_item_id5 in number default hr_api.g_number
636: ,p_information_prompt in varchar2 default hr_api.g_varchar2
637: ,p_insert_allowed in number default hr_api.g_number
638: ,p_label in varchar2 default hr_api.g_varchar2
639: ,p_prompt_text in varchar2 default hr_api.g_varchar2
640: ,p_prompt_alignment_offset in number default hr_api.g_number
641: ,p_prompt_display_style in number default hr_api.g_number
642: ,p_prompt_edge in number default hr_api.g_number
643: ,p_prompt_edge_alignment in number default hr_api.g_number
636: ,p_information_prompt in varchar2 default hr_api.g_varchar2
637: ,p_insert_allowed in number default hr_api.g_number
638: ,p_label in varchar2 default hr_api.g_varchar2
639: ,p_prompt_text in varchar2 default hr_api.g_varchar2
640: ,p_prompt_alignment_offset in number default hr_api.g_number
641: ,p_prompt_display_style in number default hr_api.g_number
642: ,p_prompt_edge in number default hr_api.g_number
643: ,p_prompt_edge_alignment in number default hr_api.g_number
644: ,p_prompt_edge_offset in number default hr_api.g_number
637: ,p_insert_allowed in number default hr_api.g_number
638: ,p_label in varchar2 default hr_api.g_varchar2
639: ,p_prompt_text in varchar2 default hr_api.g_varchar2
640: ,p_prompt_alignment_offset in number default hr_api.g_number
641: ,p_prompt_display_style in number default hr_api.g_number
642: ,p_prompt_edge in number default hr_api.g_number
643: ,p_prompt_edge_alignment in number default hr_api.g_number
644: ,p_prompt_edge_offset in number default hr_api.g_number
645: ,p_prompt_text_alignment in number default hr_api.g_number
638: ,p_label in varchar2 default hr_api.g_varchar2
639: ,p_prompt_text in varchar2 default hr_api.g_varchar2
640: ,p_prompt_alignment_offset in number default hr_api.g_number
641: ,p_prompt_display_style in number default hr_api.g_number
642: ,p_prompt_edge in number default hr_api.g_number
643: ,p_prompt_edge_alignment in number default hr_api.g_number
644: ,p_prompt_edge_offset in number default hr_api.g_number
645: ,p_prompt_text_alignment in number default hr_api.g_number
646: ,p_query_allowed in number default hr_api.g_number
639: ,p_prompt_text in varchar2 default hr_api.g_varchar2
640: ,p_prompt_alignment_offset in number default hr_api.g_number
641: ,p_prompt_display_style in number default hr_api.g_number
642: ,p_prompt_edge in number default hr_api.g_number
643: ,p_prompt_edge_alignment in number default hr_api.g_number
644: ,p_prompt_edge_offset in number default hr_api.g_number
645: ,p_prompt_text_alignment in number default hr_api.g_number
646: ,p_query_allowed in number default hr_api.g_number
647: ,p_required in number default hr_api.g_number
640: ,p_prompt_alignment_offset in number default hr_api.g_number
641: ,p_prompt_display_style in number default hr_api.g_number
642: ,p_prompt_edge in number default hr_api.g_number
643: ,p_prompt_edge_alignment in number default hr_api.g_number
644: ,p_prompt_edge_offset in number default hr_api.g_number
645: ,p_prompt_text_alignment in number default hr_api.g_number
646: ,p_query_allowed in number default hr_api.g_number
647: ,p_required in number default hr_api.g_number
648: ,p_tooltip_text in varchar2 default hr_api.g_varchar2
641: ,p_prompt_display_style in number default hr_api.g_number
642: ,p_prompt_edge in number default hr_api.g_number
643: ,p_prompt_edge_alignment in number default hr_api.g_number
644: ,p_prompt_edge_offset in number default hr_api.g_number
645: ,p_prompt_text_alignment in number default hr_api.g_number
646: ,p_query_allowed in number default hr_api.g_number
647: ,p_required in number default hr_api.g_number
648: ,p_tooltip_text in varchar2 default hr_api.g_varchar2
649: ,p_update_allowed in number default hr_api.g_number
642: ,p_prompt_edge in number default hr_api.g_number
643: ,p_prompt_edge_alignment in number default hr_api.g_number
644: ,p_prompt_edge_offset in number default hr_api.g_number
645: ,p_prompt_text_alignment in number default hr_api.g_number
646: ,p_query_allowed in number default hr_api.g_number
647: ,p_required in number default hr_api.g_number
648: ,p_tooltip_text in varchar2 default hr_api.g_varchar2
649: ,p_update_allowed in number default hr_api.g_number
650: ,p_validation_formula_id in number default hr_api.g_number
643: ,p_prompt_edge_alignment in number default hr_api.g_number
644: ,p_prompt_edge_offset in number default hr_api.g_number
645: ,p_prompt_text_alignment in number default hr_api.g_number
646: ,p_query_allowed in number default hr_api.g_number
647: ,p_required in number default hr_api.g_number
648: ,p_tooltip_text in varchar2 default hr_api.g_varchar2
649: ,p_update_allowed in number default hr_api.g_number
650: ,p_validation_formula_id in number default hr_api.g_number
651: ,p_validation_param_item_id1 in number default hr_api.g_number
644: ,p_prompt_edge_offset in number default hr_api.g_number
645: ,p_prompt_text_alignment in number default hr_api.g_number
646: ,p_query_allowed in number default hr_api.g_number
647: ,p_required in number default hr_api.g_number
648: ,p_tooltip_text in varchar2 default hr_api.g_varchar2
649: ,p_update_allowed in number default hr_api.g_number
650: ,p_validation_formula_id in number default hr_api.g_number
651: ,p_validation_param_item_id1 in number default hr_api.g_number
652: ,p_validation_param_item_id2 in number default hr_api.g_number
645: ,p_prompt_text_alignment in number default hr_api.g_number
646: ,p_query_allowed in number default hr_api.g_number
647: ,p_required in number default hr_api.g_number
648: ,p_tooltip_text in varchar2 default hr_api.g_varchar2
649: ,p_update_allowed in number default hr_api.g_number
650: ,p_validation_formula_id in number default hr_api.g_number
651: ,p_validation_param_item_id1 in number default hr_api.g_number
652: ,p_validation_param_item_id2 in number default hr_api.g_number
653: ,p_validation_param_item_id3 in number default hr_api.g_number
646: ,p_query_allowed in number default hr_api.g_number
647: ,p_required in number default hr_api.g_number
648: ,p_tooltip_text in varchar2 default hr_api.g_varchar2
649: ,p_update_allowed in number default hr_api.g_number
650: ,p_validation_formula_id in number default hr_api.g_number
651: ,p_validation_param_item_id1 in number default hr_api.g_number
652: ,p_validation_param_item_id2 in number default hr_api.g_number
653: ,p_validation_param_item_id3 in number default hr_api.g_number
654: ,p_validation_param_item_id4 in number default hr_api.g_number
647: ,p_required in number default hr_api.g_number
648: ,p_tooltip_text in varchar2 default hr_api.g_varchar2
649: ,p_update_allowed in number default hr_api.g_number
650: ,p_validation_formula_id in number default hr_api.g_number
651: ,p_validation_param_item_id1 in number default hr_api.g_number
652: ,p_validation_param_item_id2 in number default hr_api.g_number
653: ,p_validation_param_item_id3 in number default hr_api.g_number
654: ,p_validation_param_item_id4 in number default hr_api.g_number
655: ,p_validation_param_item_id5 in number default hr_api.g_number
648: ,p_tooltip_text in varchar2 default hr_api.g_varchar2
649: ,p_update_allowed in number default hr_api.g_number
650: ,p_validation_formula_id in number default hr_api.g_number
651: ,p_validation_param_item_id1 in number default hr_api.g_number
652: ,p_validation_param_item_id2 in number default hr_api.g_number
653: ,p_validation_param_item_id3 in number default hr_api.g_number
654: ,p_validation_param_item_id4 in number default hr_api.g_number
655: ,p_validation_param_item_id5 in number default hr_api.g_number
656: ,p_visible in number default hr_api.g_number
649: ,p_update_allowed in number default hr_api.g_number
650: ,p_validation_formula_id in number default hr_api.g_number
651: ,p_validation_param_item_id1 in number default hr_api.g_number
652: ,p_validation_param_item_id2 in number default hr_api.g_number
653: ,p_validation_param_item_id3 in number default hr_api.g_number
654: ,p_validation_param_item_id4 in number default hr_api.g_number
655: ,p_validation_param_item_id5 in number default hr_api.g_number
656: ,p_visible in number default hr_api.g_number
657: ,p_width in number default hr_api.g_number
650: ,p_validation_formula_id in number default hr_api.g_number
651: ,p_validation_param_item_id1 in number default hr_api.g_number
652: ,p_validation_param_item_id2 in number default hr_api.g_number
653: ,p_validation_param_item_id3 in number default hr_api.g_number
654: ,p_validation_param_item_id4 in number default hr_api.g_number
655: ,p_validation_param_item_id5 in number default hr_api.g_number
656: ,p_visible in number default hr_api.g_number
657: ,p_width in number default hr_api.g_number
658: ,p_x_position in number default hr_api.g_number
651: ,p_validation_param_item_id1 in number default hr_api.g_number
652: ,p_validation_param_item_id2 in number default hr_api.g_number
653: ,p_validation_param_item_id3 in number default hr_api.g_number
654: ,p_validation_param_item_id4 in number default hr_api.g_number
655: ,p_validation_param_item_id5 in number default hr_api.g_number
656: ,p_visible in number default hr_api.g_number
657: ,p_width in number default hr_api.g_number
658: ,p_x_position in number default hr_api.g_number
659: ,p_y_position in number default hr_api.g_number
652: ,p_validation_param_item_id2 in number default hr_api.g_number
653: ,p_validation_param_item_id3 in number default hr_api.g_number
654: ,p_validation_param_item_id4 in number default hr_api.g_number
655: ,p_validation_param_item_id5 in number default hr_api.g_number
656: ,p_visible in number default hr_api.g_number
657: ,p_width in number default hr_api.g_number
658: ,p_x_position in number default hr_api.g_number
659: ,p_y_position in number default hr_api.g_number
660: ,p_information_category in varchar2 default hr_api.g_varchar2
653: ,p_validation_param_item_id3 in number default hr_api.g_number
654: ,p_validation_param_item_id4 in number default hr_api.g_number
655: ,p_validation_param_item_id5 in number default hr_api.g_number
656: ,p_visible in number default hr_api.g_number
657: ,p_width in number default hr_api.g_number
658: ,p_x_position in number default hr_api.g_number
659: ,p_y_position in number default hr_api.g_number
660: ,p_information_category in varchar2 default hr_api.g_varchar2
661: ,p_information1 in varchar2 default hr_api.g_varchar2
654: ,p_validation_param_item_id4 in number default hr_api.g_number
655: ,p_validation_param_item_id5 in number default hr_api.g_number
656: ,p_visible in number default hr_api.g_number
657: ,p_width in number default hr_api.g_number
658: ,p_x_position in number default hr_api.g_number
659: ,p_y_position in number default hr_api.g_number
660: ,p_information_category in varchar2 default hr_api.g_varchar2
661: ,p_information1 in varchar2 default hr_api.g_varchar2
662: ,p_information2 in varchar2 default hr_api.g_varchar2
655: ,p_validation_param_item_id5 in number default hr_api.g_number
656: ,p_visible in number default hr_api.g_number
657: ,p_width in number default hr_api.g_number
658: ,p_x_position in number default hr_api.g_number
659: ,p_y_position in number default hr_api.g_number
660: ,p_information_category in varchar2 default hr_api.g_varchar2
661: ,p_information1 in varchar2 default hr_api.g_varchar2
662: ,p_information2 in varchar2 default hr_api.g_varchar2
663: ,p_information3 in varchar2 default hr_api.g_varchar2
656: ,p_visible in number default hr_api.g_number
657: ,p_width in number default hr_api.g_number
658: ,p_x_position in number default hr_api.g_number
659: ,p_y_position in number default hr_api.g_number
660: ,p_information_category in varchar2 default hr_api.g_varchar2
661: ,p_information1 in varchar2 default hr_api.g_varchar2
662: ,p_information2 in varchar2 default hr_api.g_varchar2
663: ,p_information3 in varchar2 default hr_api.g_varchar2
664: ,p_information4 in varchar2 default hr_api.g_varchar2
657: ,p_width in number default hr_api.g_number
658: ,p_x_position in number default hr_api.g_number
659: ,p_y_position in number default hr_api.g_number
660: ,p_information_category in varchar2 default hr_api.g_varchar2
661: ,p_information1 in varchar2 default hr_api.g_varchar2
662: ,p_information2 in varchar2 default hr_api.g_varchar2
663: ,p_information3 in varchar2 default hr_api.g_varchar2
664: ,p_information4 in varchar2 default hr_api.g_varchar2
665: ,p_information5 in varchar2 default hr_api.g_varchar2
658: ,p_x_position in number default hr_api.g_number
659: ,p_y_position in number default hr_api.g_number
660: ,p_information_category in varchar2 default hr_api.g_varchar2
661: ,p_information1 in varchar2 default hr_api.g_varchar2
662: ,p_information2 in varchar2 default hr_api.g_varchar2
663: ,p_information3 in varchar2 default hr_api.g_varchar2
664: ,p_information4 in varchar2 default hr_api.g_varchar2
665: ,p_information5 in varchar2 default hr_api.g_varchar2
666: ,p_information6 in varchar2 default hr_api.g_varchar2
659: ,p_y_position in number default hr_api.g_number
660: ,p_information_category in varchar2 default hr_api.g_varchar2
661: ,p_information1 in varchar2 default hr_api.g_varchar2
662: ,p_information2 in varchar2 default hr_api.g_varchar2
663: ,p_information3 in varchar2 default hr_api.g_varchar2
664: ,p_information4 in varchar2 default hr_api.g_varchar2
665: ,p_information5 in varchar2 default hr_api.g_varchar2
666: ,p_information6 in varchar2 default hr_api.g_varchar2
667: ,p_information7 in varchar2 default hr_api.g_varchar2
660: ,p_information_category in varchar2 default hr_api.g_varchar2
661: ,p_information1 in varchar2 default hr_api.g_varchar2
662: ,p_information2 in varchar2 default hr_api.g_varchar2
663: ,p_information3 in varchar2 default hr_api.g_varchar2
664: ,p_information4 in varchar2 default hr_api.g_varchar2
665: ,p_information5 in varchar2 default hr_api.g_varchar2
666: ,p_information6 in varchar2 default hr_api.g_varchar2
667: ,p_information7 in varchar2 default hr_api.g_varchar2
668: ,p_information8 in varchar2 default hr_api.g_varchar2
661: ,p_information1 in varchar2 default hr_api.g_varchar2
662: ,p_information2 in varchar2 default hr_api.g_varchar2
663: ,p_information3 in varchar2 default hr_api.g_varchar2
664: ,p_information4 in varchar2 default hr_api.g_varchar2
665: ,p_information5 in varchar2 default hr_api.g_varchar2
666: ,p_information6 in varchar2 default hr_api.g_varchar2
667: ,p_information7 in varchar2 default hr_api.g_varchar2
668: ,p_information8 in varchar2 default hr_api.g_varchar2
669: ,p_information9 in varchar2 default hr_api.g_varchar2
662: ,p_information2 in varchar2 default hr_api.g_varchar2
663: ,p_information3 in varchar2 default hr_api.g_varchar2
664: ,p_information4 in varchar2 default hr_api.g_varchar2
665: ,p_information5 in varchar2 default hr_api.g_varchar2
666: ,p_information6 in varchar2 default hr_api.g_varchar2
667: ,p_information7 in varchar2 default hr_api.g_varchar2
668: ,p_information8 in varchar2 default hr_api.g_varchar2
669: ,p_information9 in varchar2 default hr_api.g_varchar2
670: ,p_information10 in varchar2 default hr_api.g_varchar2
663: ,p_information3 in varchar2 default hr_api.g_varchar2
664: ,p_information4 in varchar2 default hr_api.g_varchar2
665: ,p_information5 in varchar2 default hr_api.g_varchar2
666: ,p_information6 in varchar2 default hr_api.g_varchar2
667: ,p_information7 in varchar2 default hr_api.g_varchar2
668: ,p_information8 in varchar2 default hr_api.g_varchar2
669: ,p_information9 in varchar2 default hr_api.g_varchar2
670: ,p_information10 in varchar2 default hr_api.g_varchar2
671: ,p_information11 in varchar2 default hr_api.g_varchar2
664: ,p_information4 in varchar2 default hr_api.g_varchar2
665: ,p_information5 in varchar2 default hr_api.g_varchar2
666: ,p_information6 in varchar2 default hr_api.g_varchar2
667: ,p_information7 in varchar2 default hr_api.g_varchar2
668: ,p_information8 in varchar2 default hr_api.g_varchar2
669: ,p_information9 in varchar2 default hr_api.g_varchar2
670: ,p_information10 in varchar2 default hr_api.g_varchar2
671: ,p_information11 in varchar2 default hr_api.g_varchar2
672: ,p_information12 in varchar2 default hr_api.g_varchar2
665: ,p_information5 in varchar2 default hr_api.g_varchar2
666: ,p_information6 in varchar2 default hr_api.g_varchar2
667: ,p_information7 in varchar2 default hr_api.g_varchar2
668: ,p_information8 in varchar2 default hr_api.g_varchar2
669: ,p_information9 in varchar2 default hr_api.g_varchar2
670: ,p_information10 in varchar2 default hr_api.g_varchar2
671: ,p_information11 in varchar2 default hr_api.g_varchar2
672: ,p_information12 in varchar2 default hr_api.g_varchar2
673: ,p_information13 in varchar2 default hr_api.g_varchar2
666: ,p_information6 in varchar2 default hr_api.g_varchar2
667: ,p_information7 in varchar2 default hr_api.g_varchar2
668: ,p_information8 in varchar2 default hr_api.g_varchar2
669: ,p_information9 in varchar2 default hr_api.g_varchar2
670: ,p_information10 in varchar2 default hr_api.g_varchar2
671: ,p_information11 in varchar2 default hr_api.g_varchar2
672: ,p_information12 in varchar2 default hr_api.g_varchar2
673: ,p_information13 in varchar2 default hr_api.g_varchar2
674: ,p_information14 in varchar2 default hr_api.g_varchar2
667: ,p_information7 in varchar2 default hr_api.g_varchar2
668: ,p_information8 in varchar2 default hr_api.g_varchar2
669: ,p_information9 in varchar2 default hr_api.g_varchar2
670: ,p_information10 in varchar2 default hr_api.g_varchar2
671: ,p_information11 in varchar2 default hr_api.g_varchar2
672: ,p_information12 in varchar2 default hr_api.g_varchar2
673: ,p_information13 in varchar2 default hr_api.g_varchar2
674: ,p_information14 in varchar2 default hr_api.g_varchar2
675: ,p_information15 in varchar2 default hr_api.g_varchar2
668: ,p_information8 in varchar2 default hr_api.g_varchar2
669: ,p_information9 in varchar2 default hr_api.g_varchar2
670: ,p_information10 in varchar2 default hr_api.g_varchar2
671: ,p_information11 in varchar2 default hr_api.g_varchar2
672: ,p_information12 in varchar2 default hr_api.g_varchar2
673: ,p_information13 in varchar2 default hr_api.g_varchar2
674: ,p_information14 in varchar2 default hr_api.g_varchar2
675: ,p_information15 in varchar2 default hr_api.g_varchar2
676: ,p_information16 in varchar2 default hr_api.g_varchar2
669: ,p_information9 in varchar2 default hr_api.g_varchar2
670: ,p_information10 in varchar2 default hr_api.g_varchar2
671: ,p_information11 in varchar2 default hr_api.g_varchar2
672: ,p_information12 in varchar2 default hr_api.g_varchar2
673: ,p_information13 in varchar2 default hr_api.g_varchar2
674: ,p_information14 in varchar2 default hr_api.g_varchar2
675: ,p_information15 in varchar2 default hr_api.g_varchar2
676: ,p_information16 in varchar2 default hr_api.g_varchar2
677: ,p_information17 in varchar2 default hr_api.g_varchar2
670: ,p_information10 in varchar2 default hr_api.g_varchar2
671: ,p_information11 in varchar2 default hr_api.g_varchar2
672: ,p_information12 in varchar2 default hr_api.g_varchar2
673: ,p_information13 in varchar2 default hr_api.g_varchar2
674: ,p_information14 in varchar2 default hr_api.g_varchar2
675: ,p_information15 in varchar2 default hr_api.g_varchar2
676: ,p_information16 in varchar2 default hr_api.g_varchar2
677: ,p_information17 in varchar2 default hr_api.g_varchar2
678: ,p_information18 in varchar2 default hr_api.g_varchar2
671: ,p_information11 in varchar2 default hr_api.g_varchar2
672: ,p_information12 in varchar2 default hr_api.g_varchar2
673: ,p_information13 in varchar2 default hr_api.g_varchar2
674: ,p_information14 in varchar2 default hr_api.g_varchar2
675: ,p_information15 in varchar2 default hr_api.g_varchar2
676: ,p_information16 in varchar2 default hr_api.g_varchar2
677: ,p_information17 in varchar2 default hr_api.g_varchar2
678: ,p_information18 in varchar2 default hr_api.g_varchar2
679: ,p_information19 in varchar2 default hr_api.g_varchar2
672: ,p_information12 in varchar2 default hr_api.g_varchar2
673: ,p_information13 in varchar2 default hr_api.g_varchar2
674: ,p_information14 in varchar2 default hr_api.g_varchar2
675: ,p_information15 in varchar2 default hr_api.g_varchar2
676: ,p_information16 in varchar2 default hr_api.g_varchar2
677: ,p_information17 in varchar2 default hr_api.g_varchar2
678: ,p_information18 in varchar2 default hr_api.g_varchar2
679: ,p_information19 in varchar2 default hr_api.g_varchar2
680: ,p_information20 in varchar2 default hr_api.g_varchar2
673: ,p_information13 in varchar2 default hr_api.g_varchar2
674: ,p_information14 in varchar2 default hr_api.g_varchar2
675: ,p_information15 in varchar2 default hr_api.g_varchar2
676: ,p_information16 in varchar2 default hr_api.g_varchar2
677: ,p_information17 in varchar2 default hr_api.g_varchar2
678: ,p_information18 in varchar2 default hr_api.g_varchar2
679: ,p_information19 in varchar2 default hr_api.g_varchar2
680: ,p_information20 in varchar2 default hr_api.g_varchar2
681: ,p_information21 in varchar2 default hr_api.g_varchar2
674: ,p_information14 in varchar2 default hr_api.g_varchar2
675: ,p_information15 in varchar2 default hr_api.g_varchar2
676: ,p_information16 in varchar2 default hr_api.g_varchar2
677: ,p_information17 in varchar2 default hr_api.g_varchar2
678: ,p_information18 in varchar2 default hr_api.g_varchar2
679: ,p_information19 in varchar2 default hr_api.g_varchar2
680: ,p_information20 in varchar2 default hr_api.g_varchar2
681: ,p_information21 in varchar2 default hr_api.g_varchar2
682: ,p_information22 in varchar2 default hr_api.g_varchar2
675: ,p_information15 in varchar2 default hr_api.g_varchar2
676: ,p_information16 in varchar2 default hr_api.g_varchar2
677: ,p_information17 in varchar2 default hr_api.g_varchar2
678: ,p_information18 in varchar2 default hr_api.g_varchar2
679: ,p_information19 in varchar2 default hr_api.g_varchar2
680: ,p_information20 in varchar2 default hr_api.g_varchar2
681: ,p_information21 in varchar2 default hr_api.g_varchar2
682: ,p_information22 in varchar2 default hr_api.g_varchar2
683: ,p_information23 in varchar2 default hr_api.g_varchar2
676: ,p_information16 in varchar2 default hr_api.g_varchar2
677: ,p_information17 in varchar2 default hr_api.g_varchar2
678: ,p_information18 in varchar2 default hr_api.g_varchar2
679: ,p_information19 in varchar2 default hr_api.g_varchar2
680: ,p_information20 in varchar2 default hr_api.g_varchar2
681: ,p_information21 in varchar2 default hr_api.g_varchar2
682: ,p_information22 in varchar2 default hr_api.g_varchar2
683: ,p_information23 in varchar2 default hr_api.g_varchar2
684: ,p_information24 in varchar2 default hr_api.g_varchar2
677: ,p_information17 in varchar2 default hr_api.g_varchar2
678: ,p_information18 in varchar2 default hr_api.g_varchar2
679: ,p_information19 in varchar2 default hr_api.g_varchar2
680: ,p_information20 in varchar2 default hr_api.g_varchar2
681: ,p_information21 in varchar2 default hr_api.g_varchar2
682: ,p_information22 in varchar2 default hr_api.g_varchar2
683: ,p_information23 in varchar2 default hr_api.g_varchar2
684: ,p_information24 in varchar2 default hr_api.g_varchar2
685: ,p_information25 in varchar2 default hr_api.g_varchar2
678: ,p_information18 in varchar2 default hr_api.g_varchar2
679: ,p_information19 in varchar2 default hr_api.g_varchar2
680: ,p_information20 in varchar2 default hr_api.g_varchar2
681: ,p_information21 in varchar2 default hr_api.g_varchar2
682: ,p_information22 in varchar2 default hr_api.g_varchar2
683: ,p_information23 in varchar2 default hr_api.g_varchar2
684: ,p_information24 in varchar2 default hr_api.g_varchar2
685: ,p_information25 in varchar2 default hr_api.g_varchar2
686: ,p_information26 in varchar2 default hr_api.g_varchar2
679: ,p_information19 in varchar2 default hr_api.g_varchar2
680: ,p_information20 in varchar2 default hr_api.g_varchar2
681: ,p_information21 in varchar2 default hr_api.g_varchar2
682: ,p_information22 in varchar2 default hr_api.g_varchar2
683: ,p_information23 in varchar2 default hr_api.g_varchar2
684: ,p_information24 in varchar2 default hr_api.g_varchar2
685: ,p_information25 in varchar2 default hr_api.g_varchar2
686: ,p_information26 in varchar2 default hr_api.g_varchar2
687: ,p_information27 in varchar2 default hr_api.g_varchar2
680: ,p_information20 in varchar2 default hr_api.g_varchar2
681: ,p_information21 in varchar2 default hr_api.g_varchar2
682: ,p_information22 in varchar2 default hr_api.g_varchar2
683: ,p_information23 in varchar2 default hr_api.g_varchar2
684: ,p_information24 in varchar2 default hr_api.g_varchar2
685: ,p_information25 in varchar2 default hr_api.g_varchar2
686: ,p_information26 in varchar2 default hr_api.g_varchar2
687: ,p_information27 in varchar2 default hr_api.g_varchar2
688: ,p_information28 in varchar2 default hr_api.g_varchar2
681: ,p_information21 in varchar2 default hr_api.g_varchar2
682: ,p_information22 in varchar2 default hr_api.g_varchar2
683: ,p_information23 in varchar2 default hr_api.g_varchar2
684: ,p_information24 in varchar2 default hr_api.g_varchar2
685: ,p_information25 in varchar2 default hr_api.g_varchar2
686: ,p_information26 in varchar2 default hr_api.g_varchar2
687: ,p_information27 in varchar2 default hr_api.g_varchar2
688: ,p_information28 in varchar2 default hr_api.g_varchar2
689: ,p_information29 in varchar2 default hr_api.g_varchar2
682: ,p_information22 in varchar2 default hr_api.g_varchar2
683: ,p_information23 in varchar2 default hr_api.g_varchar2
684: ,p_information24 in varchar2 default hr_api.g_varchar2
685: ,p_information25 in varchar2 default hr_api.g_varchar2
686: ,p_information26 in varchar2 default hr_api.g_varchar2
687: ,p_information27 in varchar2 default hr_api.g_varchar2
688: ,p_information28 in varchar2 default hr_api.g_varchar2
689: ,p_information29 in varchar2 default hr_api.g_varchar2
690: ,p_information30 in varchar2 default hr_api.g_varchar2
683: ,p_information23 in varchar2 default hr_api.g_varchar2
684: ,p_information24 in varchar2 default hr_api.g_varchar2
685: ,p_information25 in varchar2 default hr_api.g_varchar2
686: ,p_information26 in varchar2 default hr_api.g_varchar2
687: ,p_information27 in varchar2 default hr_api.g_varchar2
688: ,p_information28 in varchar2 default hr_api.g_varchar2
689: ,p_information29 in varchar2 default hr_api.g_varchar2
690: ,p_information30 in varchar2 default hr_api.g_varchar2
691: ,p_next_navigation_item_id in number default hr_api.g_number
684: ,p_information24 in varchar2 default hr_api.g_varchar2
685: ,p_information25 in varchar2 default hr_api.g_varchar2
686: ,p_information26 in varchar2 default hr_api.g_varchar2
687: ,p_information27 in varchar2 default hr_api.g_varchar2
688: ,p_information28 in varchar2 default hr_api.g_varchar2
689: ,p_information29 in varchar2 default hr_api.g_varchar2
690: ,p_information30 in varchar2 default hr_api.g_varchar2
691: ,p_next_navigation_item_id in number default hr_api.g_number
692: ,p_previous_navigation_item_id in number default hr_api.g_number
685: ,p_information25 in varchar2 default hr_api.g_varchar2
686: ,p_information26 in varchar2 default hr_api.g_varchar2
687: ,p_information27 in varchar2 default hr_api.g_varchar2
688: ,p_information28 in varchar2 default hr_api.g_varchar2
689: ,p_information29 in varchar2 default hr_api.g_varchar2
690: ,p_information30 in varchar2 default hr_api.g_varchar2
691: ,p_next_navigation_item_id in number default hr_api.g_number
692: ,p_previous_navigation_item_id in number default hr_api.g_number
693: ,p_override_value_warning out nocopy boolean
686: ,p_information26 in varchar2 default hr_api.g_varchar2
687: ,p_information27 in varchar2 default hr_api.g_varchar2
688: ,p_information28 in varchar2 default hr_api.g_varchar2
689: ,p_information29 in varchar2 default hr_api.g_varchar2
690: ,p_information30 in varchar2 default hr_api.g_varchar2
691: ,p_next_navigation_item_id in number default hr_api.g_number
692: ,p_previous_navigation_item_id in number default hr_api.g_number
693: ,p_override_value_warning out nocopy boolean
694: ) is
687: ,p_information27 in varchar2 default hr_api.g_varchar2
688: ,p_information28 in varchar2 default hr_api.g_varchar2
689: ,p_information29 in varchar2 default hr_api.g_varchar2
690: ,p_information30 in varchar2 default hr_api.g_varchar2
691: ,p_next_navigation_item_id in number default hr_api.g_number
692: ,p_previous_navigation_item_id in number default hr_api.g_number
693: ,p_override_value_warning out nocopy boolean
694: ) is
695: --
688: ,p_information28 in varchar2 default hr_api.g_varchar2
689: ,p_information29 in varchar2 default hr_api.g_varchar2
690: ,p_information30 in varchar2 default hr_api.g_varchar2
691: ,p_next_navigation_item_id in number default hr_api.g_number
692: ,p_previous_navigation_item_id in number default hr_api.g_number
693: ,p_override_value_warning out nocopy boolean
694: ) is
695: --
696: -- Declare cursors and local variables
698: l_language_code fnd_languages.language_code%TYPE;
699:
700: CURSOR cur_override
701: IS
702: SELECT DECODE(p_required,hr_api.g_number,required,p_required),
703: DECODE(p_required_override,hr_api.g_number,required_override,p_required_override),
704: form_tab_page_id,
705: DECODE(p_form_tab_page_id_override,hr_api.g_number,form_tab_page_id_override,p_form_tab_page_id_override),
706: DECODE(p_visible,hr_api.g_number,visible,p_visible),
699:
700: CURSOR cur_override
701: IS
702: SELECT DECODE(p_required,hr_api.g_number,required,p_required),
703: DECODE(p_required_override,hr_api.g_number,required_override,p_required_override),
704: form_tab_page_id,
705: DECODE(p_form_tab_page_id_override,hr_api.g_number,form_tab_page_id_override,p_form_tab_page_id_override),
706: DECODE(p_visible,hr_api.g_number,visible,p_visible),
707: DECODE(p_visible_override,hr_api.g_number,visible_override,p_visible_override)
701: IS
702: SELECT DECODE(p_required,hr_api.g_number,required,p_required),
703: DECODE(p_required_override,hr_api.g_number,required_override,p_required_override),
704: form_tab_page_id,
705: DECODE(p_form_tab_page_id_override,hr_api.g_number,form_tab_page_id_override,p_form_tab_page_id_override),
706: DECODE(p_visible,hr_api.g_number,visible,p_visible),
707: DECODE(p_visible_override,hr_api.g_number,visible_override,p_visible_override)
708: FROM hr_form_items
709: WHERE form_item_id = p_form_item_id;
702: SELECT DECODE(p_required,hr_api.g_number,required,p_required),
703: DECODE(p_required_override,hr_api.g_number,required_override,p_required_override),
704: form_tab_page_id,
705: DECODE(p_form_tab_page_id_override,hr_api.g_number,form_tab_page_id_override,p_form_tab_page_id_override),
706: DECODE(p_visible,hr_api.g_number,visible,p_visible),
707: DECODE(p_visible_override,hr_api.g_number,visible_override,p_visible_override)
708: FROM hr_form_items
709: WHERE form_item_id = p_form_item_id;
710:
703: DECODE(p_required_override,hr_api.g_number,required_override,p_required_override),
704: form_tab_page_id,
705: DECODE(p_form_tab_page_id_override,hr_api.g_number,form_tab_page_id_override,p_form_tab_page_id_override),
706: DECODE(p_visible,hr_api.g_number,visible,p_visible),
707: DECODE(p_visible_override,hr_api.g_number,visible_override,p_visible_override)
708: FROM hr_form_items
709: WHERE form_item_id = p_form_item_id;
710:
711: l_required number ;
735: -- instead of p_language_code from now on, to allow an IN OUT parameter to
736: -- be passed through.
737: --
738: l_language_code := p_language_code;
739: hr_api.validate_language_code(p_language_code => l_language_code);
740: --
741: hr_utility.set_location(l_proc, 20);
742: --
743: --
827: ,p_information30 => p_information30
828: ,p_next_navigation_item_id => p_next_navigation_item_id
829: ,p_previous_navigation_item_id => p_previous_navigation_item_id);
830: exception
831: when hr_api.cannot_find_prog_unit then
832: hr_api.cannot_find_prog_unit_error
833: (p_module_name => 'update_form_item'
834: ,p_hook_type => 'BP'
835: );
828: ,p_next_navigation_item_id => p_next_navigation_item_id
829: ,p_previous_navigation_item_id => p_previous_navigation_item_id);
830: exception
831: when hr_api.cannot_find_prog_unit then
832: hr_api.cannot_find_prog_unit_error
833: (p_module_name => 'update_form_item'
834: ,p_hook_type => 'BP'
835: );
836: end;
1040: ,p_next_navigation_item_id => p_next_navigation_item_id
1041: ,p_previous_navigation_item_id => p_previous_navigation_item_id
1042: ,p_override_value_warning => l_override_value_warning);
1043: exception
1044: when hr_api.cannot_find_prog_unit then
1045: hr_api.cannot_find_prog_unit_error
1046: (p_module_name => 'update_form_item'
1047: ,p_hook_type => 'AP'
1048: );
1041: ,p_previous_navigation_item_id => p_previous_navigation_item_id
1042: ,p_override_value_warning => l_override_value_warning);
1043: exception
1044: when hr_api.cannot_find_prog_unit then
1045: hr_api.cannot_find_prog_unit_error
1046: (p_module_name => 'update_form_item'
1047: ,p_hook_type => 'AP'
1048: );
1049: end;
1053: --
1054: -- When in validation only mode raise the Validate_Enabled exception
1055: --
1056: if p_validate then
1057: raise hr_api.validate_enabled;
1058: end if;
1059: --
1060: -- Set all output arguments
1061: --
1063: p_override_value_warning := l_override_value_warning;
1064: --
1065: hr_utility.set_location(' Leaving:'||l_proc, 70);
1066: exception
1067: when hr_api.validate_enabled then
1068: --
1069: -- As the Validate_Enabled exception has been raised
1070: -- we must rollback to the savepoint
1071: --