eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AK_REGION_GRP SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 45


p_update_flag              IN      VARCHAR2,
p_required_flag            IN      VARCHAR2,
p_security_code            IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_default_value_varchar2   IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_default_value_number     IN      NUMBER := FND_API.G_MISS_NUM,
p_default_value_date       IN      DATE := FND_API.G_MISS_DATE,
p_lov_region_application_id IN     NUMBER := FND_API.G_MISS_NUM,
p_lov_region_code          IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_lov_foreign_key_name     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_lov_attribute_application_id IN  NUMBER := FND_API.G_MISS_NUM,
p_lov_attribute_code       IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_lov_default_flag         IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_region_defaulting_api_pkg IN     VARCHAR2 := FND_API.G_MISS_CHAR,
p_region_defaulting_api_proc IN    VARCHAR2 := FND_API.G_MISS_CHAR,
p_region_validation_api_pkg IN     VARCHAR2 := FND_API.G_MISS_CHAR,
p_region_validation_api_proc IN    VARCHAR2 := FND_API.G_MISS_CHAR,
p_order_sequence           IN      NUMBER := FND_API.G_MISS_NUM,
p_order_direction          IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_display_height			 IN		 NUMBER := FND_API.G_MISS_NUM,
p_submit					 IN		 VARCHAR2,
p_encrypt					 IN		 VARCHAR2,
p_css_class_name			 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_view_usage_name			 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_view_attribute_name		 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_nested_region_appl_id	 IN		 NUMBER := FND_API.G_MISS_NUM,
p_nested_region_code		 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_url						 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_poplist_viewobject		 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_poplist_display_attr	 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_poplist_value_attr		 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_image_file_name			 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_item_name				 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_css_label_class_name	 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_menu_name		     IN	     VARCHAR2 := FND_API.G_MISS_CHAR,
p_flexfield_name	     IN	     VARCHAR2 := FND_API.G_MISS_CHAR,
p_flexfield_application_id IN	     NUMBER   := FND_API.G_MISS_NUM,
p_tabular_function_code    IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_tip_type                 IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_tip_message_name         IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_tip_message_application_id   IN      NUMBER   := FND_API.G_MISS_NUM,
p_flex_segment_list  			 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_entity_id					 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_anchor					 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_poplist_view_usage_name  IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_user_customizable	     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_sortby_view_attribute_name   IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_admin_customizable		IN	VARCHAR2 := FND_API.G_MISS_CHAR,
p_invoke_function_name	IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_expansion			IN      NUMBER   := FND_API.G_MISS_NUM,
p_als_max_length		IN      NUMBER   := FND_API.G_MISS_NUM,
p_initial_sort_sequence       IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_customization_application_id   IN   NUMBER   := FND_API.G_MISS_NUM,
p_customization_code	 	   IN	VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute_label_long     IN      VARCHAR2,
p_attribute_label_short    IN      VARCHAR2,
p_description				 IN		 VARCHAR2 := FND_API.G_MISS_CHAR
) is
l_api_version_number CONSTANT number := 1.0;

Line: 147


p_update_flag => p_update_flag,
p_required_flag => p_required_flag,
p_security_code => p_security_code,
p_default_value_varchar2 => p_default_value_varchar2,
p_default_value_number => p_default_value_number,
p_default_value_date => p_default_value_date,
p_lov_region_application_id => p_lov_region_application_id,
p_lov_region_code => p_lov_region_code,
p_lov_foreign_key_name => p_lov_foreign_key_name,
p_lov_attribute_application_id => p_lov_attribute_application_id,
p_lov_attribute_code => p_lov_attribute_code,
p_lov_default_flag => p_lov_default_flag,
p_region_defaulting_api_pkg => p_region_defaulting_api_pkg,
p_region_defaulting_api_proc => p_region_defaulting_api_proc,
p_region_validation_api_pkg => p_region_validation_api_pkg,
p_region_validation_api_proc => p_region_validation_api_proc,
p_order_sequence => p_order_sequence,
p_order_direction => p_order_direction,
p_display_height => p_display_height,
p_submit => p_submit,
p_encrypt => p_encrypt,
p_css_class_name => p_css_class_name,
p_view_usage_name => p_view_usage_name,
p_view_attribute_name => p_view_attribute_name,
p_nested_region_appl_id => p_nested_region_appl_id,
p_nested_region_code => p_nested_region_code,
p_url => p_url,
p_poplist_viewobject => p_poplist_viewobject,
p_poplist_display_attr => p_poplist_display_attr,
p_poplist_value_attr => p_poplist_value_attr,
p_image_file_name => p_image_file_name,
p_item_name => p_item_name,
p_css_label_class_name => p_css_label_class_name,
p_menu_name => p_menu_name,
p_flexfield_name => p_flexfield_name,
p_flexfield_application_id => p_flexfield_application_id,
p_tabular_function_code    => p_tabular_function_code,
p_tip_type                 => p_tip_type,
p_tip_message_name          => p_tip_message_name,
p_tip_message_application_id  => p_tip_message_application_id ,
p_flex_segment_list			=> p_flex_segment_list,
p_entity_id					=> p_entity_id,
p_anchor					=> p_anchor,
p_poplist_view_usage_name   => p_poplist_view_usage_name,
p_user_customizable	    => p_user_customizable,
p_sortby_view_attribute_name => p_sortby_view_attribute_name,
p_admin_customizable => p_admin_customizable,
p_invoke_function_name => p_invoke_function_name,
p_expansion => p_expansion,
p_als_max_length => p_als_max_length,
p_initial_sort_sequence => p_initial_sort_sequence,
p_customization_application_id => p_customization_application_id,
p_customization_code => p_customization_code,
p_attribute_label_long => p_attribute_label_long,
p_attribute_label_short => p_attribute_label_short,
p_description => p_description,
p_pass => l_pass,
p_copy_redo_flag => l_copy_redo_flag
);

Line: 403


procedure DELETE_ITEM (
p_validation_level         IN      NUMBER := FND_API.G_VALID_LEVEL_FULL,
p_api_version_number       IN      NUMBER,
p_init_msg_tbl             IN      BOOLEAN := FALSE,
p_msg_count                OUT NOCOPY     NUMBER,
p_msg_data                 OUT NOCOPY     VARCHAR2,
p_return_status            OUT NOCOPY     VARCHAR2,
p_region_application_id    IN      NUMBER,
p_region_code              IN      VARCHAR2,
p_attribute_application_id IN      NUMBER,
p_attribute_code           IN      VARCHAR2,
p_delete_cascade           IN      VARCHAR2 := 'N'
) is
l_api_version_number CONSTANT number := 1.0;

Line: 417


l_api_name           CONSTANT varchar2(30) := 'Delete_Item';

Line: 434


savepoint start_delete_item;

Line: 437


AK_REGION_PVT.DELETE_ITEM (
p_validation_level => p_validation_level,
p_api_version_number => 1.0,
p_msg_count => p_msg_count,
p_msg_data => p_msg_data,
p_return_status => l_return_status,
p_region_application_id => p_region_application_id,
p_region_code => p_region_code,
p_attribute_application_id => p_attribute_application_id,
p_attribute_code => p_attribute_code,
p_delete_cascade => p_delete_cascade
);

Line: 461


rollback to start_delete_item;

Line: 464


rollback to start_delete_item;

Line: 468


end DELETE_ITEM;

Line: 495


procedure DELETE_REGION (
p_validation_level         IN      NUMBER := FND_API.G_VALID_LEVEL_FULL,
p_api_version_number       IN      NUMBER,
p_init_msg_tbl             IN      BOOLEAN := FALSE,
p_msg_count                OUT NOCOPY     NUMBER,
p_msg_data                 OUT NOCOPY     VARCHAR2,
p_return_status            OUT NOCOPY     VARCHAR2,
p_region_application_id    IN      NUMBER,
p_region_code              IN      VARCHAR2,
p_delete_cascade           IN      VARCHAR2 := 'N'
) is
l_api_version_number CONSTANT number := 1.0;

Line: 507


l_api_name           CONSTANT varchar2(30) := 'Delete_Region';

Line: 524


savepoint start_delete_region;

Line: 527


AK_REGION_PVT.DELETE_REGION (
p_validation_level => p_validation_level,
p_api_version_number => 1.0,
p_msg_count => p_msg_count,
p_msg_data => p_msg_data,
p_return_status => l_return_status,
p_region_application_id => p_region_application_id,
p_region_code => p_region_code,
p_delete_cascade => p_delete_cascade
);

Line: 549


rollback to start_delete_region;

Line: 552


rollback to start_delete_region;

Line: 556


end DELETE_REGION;

Line: 661


select userenv('LANG') into l_nls_language
from dual;

Line: 738


procedure UPDATE_ITEM (
p_validation_level         IN      NUMBER := FND_API.G_VALID_LEVEL_FULL,
p_api_version_number       IN      NUMBER,
p_init_msg_tbl             IN      BOOLEAN := FALSE,
p_msg_count                OUT NOCOPY     NUMBER,
p_msg_data                 OUT NOCOPY     VARCHAR2,
p_return_status            OUT NOCOPY     VARCHAR2,
p_region_application_id    IN      NUMBER,
p_region_code              IN      VARCHAR2,
p_attribute_application_id IN      NUMBER,
p_attribute_code           IN      VARCHAR2,
p_display_sequence         IN      NUMBER := FND_API.G_MISS_NUM,
p_node_display_flag        IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_node_query_flag          IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute_label_length   IN      NUMBER := FND_API.G_MISS_NUM,
p_display_value_length     IN      NUMBER := FND_API.G_MISS_NUM,
p_bold                     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_italic                   IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_vertical_alignment       IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_horizontal_alignment     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_item_style               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_object_attribute_flag    IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_icx_custom_call          IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_update_flag              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_required_flag            IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_security_code            IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_default_value_varchar2   IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_default_value_number     IN      NUMBER := FND_API.G_MISS_NUM,
p_default_value_date       IN      DATE := FND_API.G_MISS_DATE,
p_lov_region_application_id IN     NUMBER := FND_API.G_MISS_NUM,
p_lov_region_code          IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_lov_foreign_key_name     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_lov_attribute_application_id IN  NUMBER := FND_API.G_MISS_NUM,
p_lov_attribute_code       IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_lov_default_flag         IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_region_defaulting_api_pkg IN     VARCHAR2 := FND_API.G_MISS_CHAR,
p_region_defaulting_api_proc IN    VARCHAR2 := FND_API.G_MISS_CHAR,
p_region_validation_api_pkg IN     VARCHAR2 := FND_API.G_MISS_CHAR,
p_region_validation_api_proc IN    VARCHAR2 := FND_API.G_MISS_CHAR,
p_order_sequence           IN      NUMBER := FND_API.G_MISS_NUM,
p_order_direction          IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_display_height			 IN		 NUMBER := FND_API.G_MISS_NUM,
p_submit					 IN		 VARCHAR2,
p_encrypt					 IN		 VARCHAR2,
p_css_class_name				 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_view_usage_name			 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_view_attribute_name		 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_nested_region_appl_id	 IN		 NUMBER := FND_API.G_MISS_NUM,
p_nested_region_code		 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_url						 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_poplist_viewobject		 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_poplist_display_attr	 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_poplist_value_attr		 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_image_file_name			 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_item_name				 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_css_label_class_name	 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_menu_name                IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_flexfield_name           IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_flexfield_application_id IN      NUMBER   := FND_API.G_MISS_NUM,
p_tabular_function_code    IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_tip_type                 IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_tip_message_name         IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_tip_message_application_id   IN      NUMBER   := FND_API.G_MISS_NUM,
p_flex_segment_list 			 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_entity_id					 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_anchor					 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_poplist_view_usage_name  IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_user_customizable	     IN	     VARCHAR2 := FND_API.G_MISS_CHAR,
p_sortby_view_attribute_name   IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_admin_customizable		IN	VARCHAR2 := FND_API.G_MISS_CHAR,
p_invoke_function_name	IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_expansion			IN      NUMBER   := FND_API.G_MISS_NUM,
p_als_max_length		IN      NUMBER   := FND_API.G_MISS_NUM,
p_initial_sort_sequence       IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_customization_application_id  IN	NUMBER   := FND_API.G_MISS_NUM,
p_customization_code		IN	VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute_label_long     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute_label_short    IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_description				 IN		 VARCHAR2 := FND_API.G_MISS_CHAR
) is
l_api_version_number CONSTANT number := 1.0;

Line: 819


l_api_name           CONSTANT varchar2(30) := 'Update_Item';

Line: 838


savepoint start_update_item;

Line: 841


AK_REGION_PVT.UPDATE_ITEM (
p_validation_level => p_validation_level,
p_api_version_number => 1.0,
p_msg_count => p_msg_count,
p_msg_data => p_msg_data,
p_return_status => l_return_status,
p_region_application_id => p_region_application_id,
p_region_code => p_region_code,
p_attribute_application_id => p_attribute_application_id,
p_attribute_code => p_attribute_code,
p_display_sequence => p_display_sequence,
p_node_display_flag => p_node_display_flag,
p_node_query_flag => p_node_query_flag,
p_attribute_label_length => p_attribute_label_length,
p_display_value_length => p_display_value_length,
p_bold => p_bold,
p_italic => p_italic,
p_vertical_alignment => p_vertical_alignment,
p_horizontal_alignment => p_horizontal_alignment,
p_item_style => p_item_style,
p_object_attribute_flag => p_object_attribute_flag,
p_icx_custom_call => p_icx_custom_call,
p_update_flag => p_update_flag,
p_required_flag => p_required_flag,
p_security_code => p_security_code,
p_default_value_varchar2 => p_default_value_varchar2,
p_default_value_number => p_default_value_number,
p_default_value_date => p_default_value_date,
p_lov_region_application_id => p_lov_region_application_id,
p_lov_region_code => p_lov_region_code,
p_lov_foreign_key_name => p_lov_foreign_key_name,
p_lov_attribute_application_id => p_lov_attribute_application_id,
p_lov_attribute_code => p_lov_attribute_code,
p_lov_default_flag => p_lov_default_flag,
p_region_defaulting_api_pkg => p_region_defaulting_api_pkg,
p_region_defaulting_api_proc => p_region_defaulting_api_proc,
p_region_validation_api_pkg => p_region_validation_api_pkg,
p_region_validation_api_proc => p_region_validation_api_proc,
p_order_sequence => p_order_sequence,
p_order_direction => p_order_direction,
p_display_height => p_display_height,
p_submit => p_submit,
p_encrypt => p_encrypt,
p_css_class_name => p_css_class_name,
p_view_usage_name => p_view_usage_name,
p_view_attribute_name => p_view_attribute_name,
p_nested_region_appl_id => p_nested_region_appl_id,
p_nested_region_code => p_nested_region_code,
p_url => p_url,
p_poplist_viewobject => p_poplist_viewobject,
p_poplist_display_attr => p_poplist_display_attr,
p_poplist_value_attr => p_poplist_value_attr,
p_image_file_name => p_image_file_name,
p_item_name => p_item_name,
p_css_label_class_name => p_css_label_class_name,
p_menu_name => p_menu_name,
p_flexfield_name => p_flexfield_name,
p_flexfield_application_id => p_flexfield_application_id,
p_tabular_function_code    => p_tabular_function_code,
p_tip_type                 => p_tip_type,
p_tip_message_name          => p_tip_message_name,
p_tip_message_application_id  => p_tip_message_application_id ,
p_flex_segment_list	 		=> p_flex_segment_list,
p_entity_id					=> p_entity_id,
p_anchor					=> p_anchor,
p_poplist_view_usage_name   => p_poplist_view_usage_name,
p_user_customizable	    => p_user_customizable,
p_sortby_view_attribute_name => p_sortby_view_attribute_name,
p_admin_customizable	=> p_admin_customizable,
p_invoke_function_name  => p_invoke_function_name,
p_expansion => p_expansion,
p_als_max_length => p_als_max_length,
p_initial_sort_sequence => p_initial_sort_sequence,
p_customization_application_id => p_customization_application_id,
p_customization_code => p_customization_code,
p_attribute_label_long => p_attribute_label_long,
p_attribute_label_short => p_attribute_label_short,
p_description => p_description,
p_pass => l_pass,
p_copy_redo_flag => l_copy_redo_flag
);

Line: 935


rollback to start_update_item;

Line: 938


rollback to start_update_item;

Line: 942


end UPDATE_ITEM;

Line: 962


procedure UPDATE_REGION (
p_validation_level         IN      NUMBER := FND_API.G_VALID_LEVEL_FULL,
p_api_version_number       IN      NUMBER,
p_init_msg_tbl             IN      BOOLEAN := FALSE,
p_msg_count                OUT NOCOPY     NUMBER,
p_msg_data                 OUT NOCOPY     VARCHAR2,
p_return_status            OUT NOCOPY     VARCHAR2,
p_region_application_id    IN      NUMBER,
p_region_code              IN      VARCHAR2,
p_database_object_name     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_region_style             IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_icx_custom_call          IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_num_columns              IN      NUMBER := FND_API.G_MISS_NUM,
p_region_defaulting_api_pkg IN     VARCHAR2 := FND_API.G_MISS_CHAR,
p_region_defaulting_api_proc IN    VARCHAR2 := FND_API.G_MISS_CHAR,
p_region_validation_api_pkg IN     VARCHAR2 := FND_API.G_MISS_CHAR,
p_region_validation_api_proc IN    VARCHAR2 := FND_API.G_MISS_CHAR,
p_appmodule_object_type    IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_num_rows_display         IN      NUMBER := FND_API.G_MISS_NUM,
p_region_object_type       IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_image_file_name			 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_isform_flag				 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_help_target              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_style_sheet_filename     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_version                  IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_applicationmodule_usage_name IN  VARCHAR2 := FND_API.G_MISS_CHAR,
p_add_indexed_children     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_stateful_flag	     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_function_name            IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_children_view_usage_name IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_search_panel  	     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_advanced_search_panel    IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_customize_panel	     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_default_search_panel     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_results_based_search     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_display_graph_table      IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_disable_header	     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_standalone		     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_auto_customization_criteria IN   VARCHAR2 := FND_API.G_MISS_CHAR,
p_name                     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_description              IN      VARCHAR2 := FND_API.G_MISS_CHAR
) is
l_api_version_number CONSTANT number := 1.0;

Line: 1005


l_api_name           CONSTANT varchar2(30) := 'Update_Region';

Line: 1024


savepoint start_update_region;

Line: 1027


AK_REGION_PVT.UPDATE_REGION (
p_validation_level => p_validation_level,
p_api_version_number => 1.0,
p_msg_count => p_msg_count,
p_msg_data => p_msg_data,
p_return_status => l_return_status,
p_region_application_id => p_region_application_id,
p_region_code => p_region_code,
p_database_object_name => p_database_object_name,
p_region_style => p_region_style,
p_icx_custom_call => p_icx_custom_call,
p_num_columns => p_num_columns,
p_region_defaulting_api_pkg => p_region_defaulting_api_pkg,
p_region_defaulting_api_proc => p_region_defaulting_api_proc,
p_region_validation_api_pkg => p_region_validation_api_pkg,
p_region_validation_api_proc => p_region_validation_api_proc,
p_appmodule_object_type => p_appmodule_object_type,
p_num_rows_display => p_num_rows_display,
p_region_object_type => p_region_object_type,
p_image_file_name => p_image_file_name,
p_isform_flag => p_isform_flag,
p_help_target => p_help_target,
p_style_sheet_filename => p_style_sheet_filename,
p_version => p_version,
p_applicationmodule_usage_name => p_applicationmodule_usage_name,
p_add_indexed_children => p_add_indexed_children,
p_stateful_flag => p_stateful_flag,
p_function_name => p_function_name,
p_children_view_usage_name => p_children_view_usage_name,
p_search_panel => p_search_panel,
p_advanced_search_panel => p_advanced_search_panel,
p_customize_panel => p_customize_panel,
p_default_search_panel => p_default_search_panel,
p_results_based_search => p_results_based_search,
p_display_graph_table => p_display_graph_table,
p_disable_header => p_disable_header,
p_standalone => p_standalone,
p_auto_customization_criteria => p_auto_customization_criteria,
p_name => p_name,
p_description => p_description,
p_pass => l_pass,
p_copy_redo_flag => l_copy_redo_flag
);

Line: 1083


rollback to start_update_region;

Line: 1086


rollback to start_update_region;

Line: 1090


end UPDATE_REGION;