The following lines contain the word 'select', 'insert', 'update' or 'delete':
,p_insert_allowed in number default null
,p_label in varchar2 default null
,p_prompt_text in varchar2 default null
,p_prompt_alignment_offset in number default null
,p_prompt_display_style in number default null
,p_prompt_edge in number default null
,p_prompt_edge_alignment in number default null
,p_prompt_edge_offset in number default null
,p_prompt_text_alignment in number default null
,p_query_allowed in number default null
,p_required in number default null
,p_tooltip_text in varchar2 default null
,p_update_allowed in number default null
,p_validation_formula_id in number default null
,p_validation_param_item_id1 in number default null
,p_validation_param_item_id2 in number default null
,p_validation_param_item_id3 in number default null
,p_validation_param_item_id4 in number default null
,p_validation_param_item_id5 in number default null
,p_visible in number default null
,p_width in number default null
,p_x_position in number default null
,p_y_position in number default null
,p_information_category in varchar2 default null
,p_information1 in varchar2 default null
,p_information2 in varchar2 default null
,p_information3 in varchar2 default null
,p_information4 in varchar2 default null
,p_information5 in varchar2 default null
,p_information6 in varchar2 default null
,p_information7 in varchar2 default null
,p_information8 in varchar2 default null
,p_information9 in varchar2 default null
,p_information10 in varchar2 default null
,p_information11 in varchar2 default null
,p_information12 in varchar2 default null
,p_information13 in varchar2 default null
,p_information14 in varchar2 default null
,p_information15 in varchar2 default null
,p_information16 in varchar2 default null
,p_information17 in varchar2 default null
,p_information18 in varchar2 default null
,p_information19 in varchar2 default null
,p_information20 in varchar2 default null
,p_information21 in varchar2 default null
,p_information22 in varchar2 default null
,p_information23 in varchar2 default null
,p_information24 in varchar2 default null
,p_information25 in varchar2 default null
,p_information26 in varchar2 default null
,p_information27 in varchar2 default null
,p_information28 in varchar2 default null
,p_information29 in varchar2 default null
,p_information30 in varchar2 default null
,p_next_navigation_item_id in number default null
,p_previous_navigation_item_id in number default null
,p_form_item_id out nocopy number
,p_object_version_number out nocopy number
,p_override_value_warning out nocopy boolean
) is
--
-- Declare cursors and local variables
--
l_proc varchar2(72) := g_package||'create_form_item';
,p_insert_allowed => p_insert_allowed
,p_label => p_label
,p_prompt_text => p_prompt_text
,p_prompt_alignment_offset => p_prompt_alignment_offset
,p_prompt_display_style => p_prompt_display_style
,p_prompt_edge => p_prompt_edge
,p_prompt_edge_alignment => p_prompt_edge_alignment
,p_prompt_edge_offset => p_prompt_edge_offset
,p_prompt_text_alignment => p_prompt_text_alignment
,p_query_allowed => p_query_allowed
,p_required => p_required
,p_tooltip_text => p_tooltip_text
,p_update_allowed => p_update_allowed
,p_validation_formula_id => p_validation_formula_id
,p_validation_param_item_id1 => p_validation_param_item_id1
,p_validation_param_item_id2 => p_validation_param_item_id2
,p_validation_param_item_id3 => p_validation_param_item_id3
,p_validation_param_item_id4 => p_validation_param_item_id4
,p_validation_param_item_id5 => p_validation_param_item_id5
,p_visible => p_visible
,p_width => p_width
,p_x_position => p_x_position
,p_y_position => p_y_position
,p_information_category => p_information_category
,p_information1 => p_information1
,p_information2 => p_information2
,p_information3 => p_information3
,p_information4 => p_information4
,p_information5 => p_information5
,p_information6 => p_information6
,p_information7 => p_information7
,p_information8 => p_information8
,p_information9 => p_information9
,p_information10 => p_information10
,p_information11 => p_information11
,p_information12 => p_information12
,p_information13 => p_information13
,p_information14 => p_information14
,p_information15 => p_information15
,p_information16 => p_information16
,p_information17 => p_information17
,p_information18 => p_information18
,p_information19 => p_information19
,p_information20 => p_information20
,p_information21 => p_information21
,p_information22 => p_information22
,p_information23 => p_information23
,p_information24 => p_information24
,p_information25 => p_information25
,p_information26 => p_information26
,p_information27 => p_information27
,p_information28 => p_information28
,p_information29 => p_information29
,p_information30 => p_information30
,p_next_navigation_item_id => p_next_navigation_item_id
,p_previous_navigation_item_id => p_previous_navigation_item_id);
,p_insert_allowed => p_insert_allowed
,p_label => p_label
,p_prompt_text => p_prompt_text
,p_prompt_alignment_offset => p_prompt_alignment_offset
,p_prompt_display_style => p_prompt_display_style
,p_prompt_edge => p_prompt_edge
,p_prompt_edge_alignment => p_prompt_edge_alignment
,p_prompt_edge_offset => p_prompt_edge_offset
,p_prompt_text_alignment => p_prompt_text_alignment
,p_query_allowed => p_query_allowed
,p_required => p_required
,p_tooltip_text => p_tooltip_text
,p_update_allowed => p_update_allowed
,p_validation_formula_id => p_validation_formula_id
,p_validation_param_item_id1 => p_validation_param_item_id1
,p_validation_param_item_id2 => p_validation_param_item_id2
,p_validation_param_item_id3 => p_validation_param_item_id3
,p_validation_param_item_id4 => p_validation_param_item_id4
,p_validation_param_item_id5 => p_validation_param_item_id5
,p_visible => p_visible
,p_width => p_width
,p_x_position => p_x_position
,p_y_position => p_y_position
,p_information_category => p_information_category
,p_information1 => p_information1
,p_information2 => p_information2
,p_information3 => p_information3
,p_information4 => p_information4
,p_information5 => p_information5
,p_information6 => p_information6
,p_information7 => p_information7
,p_information8 => p_information8
,p_information9 => p_information9
,p_information10 => p_information10
,p_information11 => p_information11
,p_information12 => p_information12
,p_information13 => p_information13
,p_information14 => p_information14
,p_information15 => p_information15
,p_information16 => p_information16
,p_information17 => p_information17
,p_information18 => p_information18
,p_information19 => p_information19
,p_information20 => p_information20
,p_information21 => p_information21
,p_information22 => p_information22
,p_information23 => p_information23
,p_information24 => p_information24
,p_information25 => p_information25
,p_information26 => p_information26
,p_information27 => p_information27
,p_information28 => p_information28
,p_information29 => p_information29
,p_information30 => p_information30
,p_next_navigation_item_id => p_next_navigation_item_id
,p_previous_navigation_item_id => p_previous_navigation_item_id
,p_item_property_id => l_item_property_id
,p_object_version_number => l_object_version_number);
,p_insert_allowed => p_insert_allowed
,p_label => p_label
,p_prompt_text => p_prompt_text
,p_prompt_alignment_offset => p_prompt_alignment_offset
,p_prompt_display_style => p_prompt_display_style
,p_prompt_edge => p_prompt_edge
,p_prompt_edge_alignment => p_prompt_edge_alignment
,p_prompt_edge_offset => p_prompt_edge_offset
,p_prompt_text_alignment => p_prompt_text_alignment
,p_query_allowed => p_query_allowed
,p_required => p_required
,p_tooltip_text => p_tooltip_text
,p_update_allowed => p_update_allowed
,p_validation_formula_id => p_validation_formula_id
,p_validation_param_item_id1 => p_validation_param_item_id1
,p_validation_param_item_id2 => p_validation_param_item_id2
,p_validation_param_item_id3 => p_validation_param_item_id3
,p_validation_param_item_id4 => p_validation_param_item_id4
,p_validation_param_item_id5 => p_validation_param_item_id5
,p_visible => p_visible
,p_width => p_width
,p_x_position => p_x_position
,p_y_position => p_y_position
,p_information_category => p_information_category
,p_information1 => p_information1
,p_information2 => p_information2
,p_information3 => p_information3
,p_information4 => p_information4
,p_information5 => p_information5
,p_information6 => p_information6
,p_information7 => p_information7
,p_information8 => p_information8
,p_information9 => p_information9
,p_information10 => p_information10
,p_information11 => p_information11
,p_information12 => p_information12
,p_information13 => p_information13
,p_information14 => p_information14
,p_information15 => p_information15
,p_information16 => p_information16
,p_information17 => p_information17
,p_information18 => p_information18
,p_information19 => p_information19
,p_information20 => p_information20
,p_information21 => p_information21
,p_information22 => p_information22
,p_information23 => p_information23
,p_information24 => p_information24
,p_information25 => p_information25
,p_information26 => p_information26
,p_information27 => p_information27
,p_information28 => p_information28
,p_information29 => p_information29
,p_information30 => p_information30
,p_next_navigation_item_id => p_next_navigation_item_id
,p_previous_navigation_item_id => p_previous_navigation_item_id
,p_form_item_id => l_form_item_id
-- ,p_form_item_property_id => l_form_item_property_id
,p_object_version_number => l_object_version_number
,p_override_value_warning => l_override_value_warning);
procedure delete_form_item
(p_validate in boolean default false
,p_form_item_id in number
,p_object_version_number in number
) is
--
-- Declare cursors and local variables
--
l_proc varchar2(72) := g_package||'delete_form_item';
savepoint delete_form_item;
hr_form_items_api_bk2.delete_form_item_b
(p_form_item_id => p_form_item_id
,p_object_version_number => p_object_version_number
);
(p_module_name => 'delete_form_item'
,p_hook_type => 'BP'
);
hr_item_properties_bsi.delete_item_property
(p_form_item_id => p_form_item_id
,p_object_version_number => p_object_version_number);
hr_form_items_api_bk2.delete_form_item_b
(p_form_item_id => p_form_item_id
,p_object_version_number => p_object_version_number
);
(p_module_name => 'delete_form_item'
,p_hook_type => 'AP'
);
rollback to delete_form_item;
rollback to delete_form_item;
end delete_form_item;
procedure update_form_item
(p_validate in boolean default false
,p_effective_date in date
,p_language_code in varchar2 default hr_api.userenv_lang
,p_form_item_id in number
,p_object_version_number in out nocopy number
,p_full_item_name in varchar2 default hr_api.g_varchar2
--,p_item_type in varchar2 default hr_api.g_varchar2
,p_user_item_name in varchar2 default hr_api.g_varchar2
,p_description in varchar2 default hr_api.g_varchar2
,p_radio_button_name in varchar2 default hr_api.g_varchar2
,p_required_override in number default hr_api.g_number
,p_form_tab_page_id_override in number default hr_api.g_number
,p_visible_override in number default hr_api.g_number
,p_alignment in number default hr_api.g_number
,p_bevel in number default hr_api.g_number
,p_case_restriction in number default hr_api.g_number
,p_default_value in varchar2 default hr_api.g_varchar2
,p_enabled in number default hr_api.g_number
,p_format_mask in varchar2 default hr_api.g_varchar2
,p_height in number default hr_api.g_number
,p_information_formula_id in number default hr_api.g_number
,p_information_param_item_id1 in number default hr_api.g_number
,p_information_param_item_id2 in number default hr_api.g_number
,p_information_param_item_id3 in number default hr_api.g_number
,p_information_param_item_id4 in number default hr_api.g_number
,p_information_param_item_id5 in number default hr_api.g_number
,p_information_prompt in varchar2 default hr_api.g_varchar2
,p_insert_allowed in number default hr_api.g_number
,p_label in varchar2 default hr_api.g_varchar2
,p_prompt_text in varchar2 default hr_api.g_varchar2
,p_prompt_alignment_offset in number default hr_api.g_number
,p_prompt_display_style in number default hr_api.g_number
,p_prompt_edge in number default hr_api.g_number
,p_prompt_edge_alignment in number default hr_api.g_number
,p_prompt_edge_offset in number default hr_api.g_number
,p_prompt_text_alignment in number default hr_api.g_number
,p_query_allowed in number default hr_api.g_number
,p_required in number default hr_api.g_number
,p_tooltip_text in varchar2 default hr_api.g_varchar2
,p_update_allowed in number default hr_api.g_number
,p_validation_formula_id in number default hr_api.g_number
,p_validation_param_item_id1 in number default hr_api.g_number
,p_validation_param_item_id2 in number default hr_api.g_number
,p_validation_param_item_id3 in number default hr_api.g_number
,p_validation_param_item_id4 in number default hr_api.g_number
,p_validation_param_item_id5 in number default hr_api.g_number
,p_visible in number default hr_api.g_number
,p_width in number default hr_api.g_number
,p_x_position in number default hr_api.g_number
,p_y_position in number default hr_api.g_number
,p_information_category in varchar2 default hr_api.g_varchar2
,p_information1 in varchar2 default hr_api.g_varchar2
,p_information2 in varchar2 default hr_api.g_varchar2
,p_information3 in varchar2 default hr_api.g_varchar2
,p_information4 in varchar2 default hr_api.g_varchar2
,p_information5 in varchar2 default hr_api.g_varchar2
,p_information6 in varchar2 default hr_api.g_varchar2
,p_information7 in varchar2 default hr_api.g_varchar2
,p_information8 in varchar2 default hr_api.g_varchar2
,p_information9 in varchar2 default hr_api.g_varchar2
,p_information10 in varchar2 default hr_api.g_varchar2
,p_information11 in varchar2 default hr_api.g_varchar2
,p_information12 in varchar2 default hr_api.g_varchar2
,p_information13 in varchar2 default hr_api.g_varchar2
,p_information14 in varchar2 default hr_api.g_varchar2
,p_information15 in varchar2 default hr_api.g_varchar2
,p_information16 in varchar2 default hr_api.g_varchar2
,p_information17 in varchar2 default hr_api.g_varchar2
,p_information18 in varchar2 default hr_api.g_varchar2
,p_information19 in varchar2 default hr_api.g_varchar2
,p_information20 in varchar2 default hr_api.g_varchar2
,p_information21 in varchar2 default hr_api.g_varchar2
,p_information22 in varchar2 default hr_api.g_varchar2
,p_information23 in varchar2 default hr_api.g_varchar2
,p_information24 in varchar2 default hr_api.g_varchar2
,p_information25 in varchar2 default hr_api.g_varchar2
,p_information26 in varchar2 default hr_api.g_varchar2
,p_information27 in varchar2 default hr_api.g_varchar2
,p_information28 in varchar2 default hr_api.g_varchar2
,p_information29 in varchar2 default hr_api.g_varchar2
,p_information30 in varchar2 default hr_api.g_varchar2
,p_next_navigation_item_id in number default hr_api.g_number
,p_previous_navigation_item_id in number default hr_api.g_number
,p_override_value_warning out nocopy boolean
) is
--
-- Declare cursors and local variables
--
l_language_code fnd_languages.language_code%TYPE;
SELECT DECODE(p_required,hr_api.g_number,required,p_required),
DECODE(p_required_override,hr_api.g_number,required_override,p_required_override),
form_tab_page_id,
DECODE(p_form_tab_page_id_override,hr_api.g_number,form_tab_page_id_override,p_form_tab_page_id_override),
DECODE(p_visible,hr_api.g_number,visible,p_visible),
DECODE(p_visible_override,hr_api.g_number,visible_override,p_visible_override)
FROM hr_form_items
WHERE form_item_id = p_form_item_id;
l_proc varchar2(72) := g_package||'update_form_item';
savepoint update_form_item;
hr_form_items_api_bk3.update_form_item_b
(p_effective_date => TRUNC(p_effective_date)
,p_language_code => l_language_code
,p_form_item_id => p_form_item_id
,p_object_version_number => l_object_version_number
,p_full_item_name => p_full_item_name
--,p_item_type => p_item_type
,p_user_item_name => p_user_item_name
,p_description => p_description
,p_radio_button_name => p_radio_button_name
,p_required_override => p_required_override
,p_form_tab_page_id_override => p_form_tab_page_id_override
,p_visible_override => p_visible_override
,p_alignment => p_alignment
,p_bevel => p_bevel
,p_case_restriction => p_case_restriction
,p_default_value => p_default_value
,p_enabled => p_enabled
,p_format_mask => p_format_mask
,p_height => p_height
,p_information_formula_id => p_information_formula_id
,p_information_param_item_id1 => p_information_param_item_id1
,p_information_param_item_id2 => p_information_param_item_id2
,p_information_param_item_id3 => p_information_param_item_id3
,p_information_param_item_id4 => p_information_param_item_id4
,p_information_param_item_id5 => p_information_param_item_id5
,p_information_prompt => p_information_prompt
,p_insert_allowed => p_insert_allowed
,p_label => p_label
,p_prompt_text => p_prompt_text
,p_prompt_alignment_offset => p_prompt_alignment_offset
,p_prompt_display_style => p_prompt_display_style
,p_prompt_edge => p_prompt_edge
,p_prompt_edge_alignment => p_prompt_edge_alignment
,p_prompt_edge_offset => p_prompt_edge_offset
,p_prompt_text_alignment => p_prompt_text_alignment
,p_query_allowed => p_query_allowed
,p_required => p_required
,p_tooltip_text => p_tooltip_text
,p_update_allowed => p_update_allowed
,p_validation_formula_id => p_validation_formula_id
,p_validation_param_item_id1 => p_validation_param_item_id1
,p_validation_param_item_id2 => p_validation_param_item_id2
,p_validation_param_item_id3 => p_validation_param_item_id3
,p_validation_param_item_id4 => p_validation_param_item_id4
,p_validation_param_item_id5 => p_validation_param_item_id5
,p_visible => p_visible
,p_width => p_width
,p_x_position => p_x_position
,p_y_position => p_y_position
,p_information_category => p_information_category
,p_information1 => p_information1
,p_information2 => p_information2
,p_information3 => p_information3
,p_information4 => p_information4
,p_information5 => p_information5
,p_information6 => p_information6
,p_information7 => p_information7
,p_information8 => p_information8
,p_information9 => p_information9
,p_information10 => p_information10
,p_information11 => p_information11
,p_information12 => p_information12
,p_information13 => p_information13
,p_information14 => p_information14
,p_information15 => p_information15
,p_information16 => p_information16
,p_information17 => p_information17
,p_information18 => p_information18
,p_information19 => p_information19
,p_information20 => p_information20
,p_information21 => p_information21
,p_information22 => p_information22
,p_information23 => p_information23
,p_information24 => p_information24
,p_information25 => p_information25
,p_information26 => p_information26
,p_information27 => p_information27
,p_information28 => p_information28
,p_information29 => p_information29
,p_information30 => p_information30
,p_next_navigation_item_id => p_next_navigation_item_id
,p_previous_navigation_item_id => p_previous_navigation_item_id);
(p_module_name => 'update_form_item'
,p_hook_type => 'BP'
);
hr_item_properties_bsi.update_item_property(
p_effective_date => TRUNC(p_effective_date)
,p_language_code => l_language_code
,p_object_version_number => l_object_version_number
,p_form_item_id => p_form_item_id
,p_alignment => p_alignment
,p_bevel => p_bevel
,p_case_restriction => p_case_restriction
,p_default_value => p_default_value
,p_enabled => p_enabled
,p_format_mask => p_format_mask
,p_height => p_height
,p_information_formula_id => p_information_formula_id
,p_information_param_item_id1 => p_information_param_item_id1
,p_information_param_item_id2 => p_information_param_item_id2
,p_information_param_item_id3 => p_information_param_item_id3
,p_information_param_item_id4 => p_information_param_item_id4
,p_information_param_item_id5 => p_information_param_item_id5
,p_information_prompt => p_information_prompt
,p_insert_allowed => p_insert_allowed
,p_label => p_label
,p_prompt_text => p_prompt_text
,p_prompt_alignment_offset => p_prompt_alignment_offset
,p_prompt_display_style => p_prompt_display_style
,p_prompt_edge => p_prompt_edge
,p_prompt_edge_alignment => p_prompt_edge_alignment
,p_prompt_edge_offset => p_prompt_edge_offset
,p_prompt_text_alignment => p_prompt_text_alignment
,p_query_allowed => p_query_allowed
,p_required => p_required
,p_tooltip_text => p_tooltip_text
,p_update_allowed => p_update_allowed
,p_validation_formula_id => p_validation_formula_id
,p_validation_param_item_id1 => p_validation_param_item_id1
,p_validation_param_item_id2 => p_validation_param_item_id2
,p_validation_param_item_id3 => p_validation_param_item_id3
,p_validation_param_item_id4 => p_validation_param_item_id4
,p_validation_param_item_id5 => p_validation_param_item_id5
,p_visible => p_visible
,p_width => p_width
,p_x_position => p_x_position
,p_y_position => p_y_position
,p_information_category => p_information_category
,p_information1 => p_information1
,p_information2 => p_information2
,p_information3 => p_information3
,p_information4 => p_information4
,p_information5 => p_information5
,p_information6 => p_information6
,p_information7 => p_information7
,p_information8 => p_information8
,p_information9 => p_information9
,p_information10 => p_information10
,p_information11 => p_information11
,p_information12 => p_information12
,p_information13 => p_information13
,p_information14 => p_information14
,p_information15 => p_information15
,p_information16 => p_information16
,p_information17 => p_information17
,p_information18 => p_information18
,p_information19 => p_information19
,p_information20 => p_information20
,p_information21 => p_information21
,p_information22 => p_information22
,p_information23 => p_information23
,p_information24 => p_information24
,p_information25 => p_information25
,p_information26 => p_information26
,p_information27 => p_information27
,p_information28 => p_information28
,p_information29 => p_information29
,p_information30 => p_information30
,p_next_navigation_item_id => p_next_navigation_item_id
,p_previous_navigation_item_id => p_previous_navigation_item_id);
hr_form_items_api_bk3.update_form_item_a
(p_effective_date => TRUNC(p_effective_date)
,p_language_code => l_language_code
,p_form_item_id => p_form_item_id
,p_object_version_number => l_object_version_number
,p_full_item_name => p_full_item_name
--,p_item_type => p_item_type
,p_user_item_name => p_user_item_name
,p_description => p_description
,p_radio_button_name => p_radio_button_name
,p_required_override => p_required_override
,p_form_tab_page_id_override => p_form_tab_page_id_override
,p_visible_override => p_visible_override
,p_alignment => p_alignment
,p_bevel => p_bevel
,p_case_restriction => p_case_restriction
,p_default_value => p_default_value
,p_enabled => p_enabled
,p_format_mask => p_format_mask
,p_height => p_height
,p_information_formula_id => p_information_formula_id
,p_information_param_item_id1 => p_information_param_item_id1
,p_information_param_item_id2 => p_information_param_item_id2
,p_information_param_item_id3 => p_information_param_item_id3
,p_information_param_item_id4 => p_information_param_item_id4
,p_information_param_item_id5 => p_information_param_item_id5
,p_information_prompt => p_information_prompt
,p_insert_allowed => p_insert_allowed
,p_label => p_label
,p_prompt_text => p_prompt_text
,p_prompt_alignment_offset => p_prompt_alignment_offset
,p_prompt_display_style => p_prompt_display_style
,p_prompt_edge => p_prompt_edge
,p_prompt_edge_alignment => p_prompt_edge_alignment
,p_prompt_edge_offset => p_prompt_edge_offset
,p_prompt_text_alignment => p_prompt_text_alignment
,p_query_allowed => p_query_allowed
,p_required => p_required
,p_tooltip_text => p_tooltip_text
,p_update_allowed => p_update_allowed
,p_validation_formula_id => p_validation_formula_id
,p_validation_param_item_id1 => p_validation_param_item_id1
,p_validation_param_item_id2 => p_validation_param_item_id2
,p_validation_param_item_id3 => p_validation_param_item_id3
,p_validation_param_item_id4 => p_validation_param_item_id4
,p_validation_param_item_id5 => p_validation_param_item_id5
,p_visible => p_visible
,p_width => p_width
,p_x_position => p_x_position
,p_y_position => p_y_position
,p_information_category => p_information_category
,p_information1 => p_information1
,p_information2 => p_information2
,p_information3 => p_information3
,p_information4 => p_information4
,p_information5 => p_information5
,p_information6 => p_information6
,p_information7 => p_information7
,p_information8 => p_information8
,p_information9 => p_information9
,p_information10 => p_information10
,p_information11 => p_information11
,p_information12 => p_information12
,p_information13 => p_information13
,p_information14 => p_information14
,p_information15 => p_information15
,p_information16 => p_information16
,p_information17 => p_information17
,p_information18 => p_information18
,p_information19 => p_information19
,p_information20 => p_information20
,p_information21 => p_information21
,p_information22 => p_information22
,p_information23 => p_information23
,p_information24 => p_information24
,p_information25 => p_information25
,p_information26 => p_information26
,p_information27 => p_information27
,p_information28 => p_information28
,p_information29 => p_information29
,p_information30 => p_information30
,p_next_navigation_item_id => p_next_navigation_item_id
,p_previous_navigation_item_id => p_previous_navigation_item_id
,p_override_value_warning => l_override_value_warning);
(p_module_name => 'update_form_item'
,p_hook_type => 'AP'
);
rollback to update_form_item;
rollback to update_form_item;
end update_form_item;