APPS.AK_ATTRIBUTE_GRP SQL Statements

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

Line: 170

procedure DELETE_ATTRIBUTE (
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_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: 182

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

Line: 201

savepoint start_delete_attribute;

Line: 206

AK_ATTRIBUTE_PVT.DELETE_ATTRIBUTE(
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_attribute_application_id => p_attribute_application_id,
p_attribute_code => p_attribute_code,
p_delete_cascade => p_delete_cascade
);

Line: 230

rollback to start_delete_attribute;

Line: 236

rollback to start_delete_attribute;

Line: 237

end DELETE_ATTRIBUTE;

Line: 339

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

Line: 414

procedure UPDATE_ATTRIBUTE (
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_attribute_application_id IN      NUMBER,
p_attribute_code           IN      VARCHAR2,
p_attribute_label_length   IN      NUMBER := FND_API.G_MISS_NUM,
p_attribute_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_data_type                IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_upper_case_flag          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_item_style               IN      VARCHAR2,
p_display_height           IN      NUMBER := FND_API.G_MISS_NUM,
p_css_class_name           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_css_label_class_name     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_precision		     IN      NUMBER := FND_API.G_MISS_NUM,
p_expansion		     IN      NUMBER := FND_API.G_MISS_NUM,
p_als_max_length	     IN	     NUMBER := FND_API.G_MISS_NUM,
p_name                     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: 452

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

Line: 473

savepoint start_update_attribute;

Line: 478

AK_ATTRIBUTE_PVT.UPDATE_ATTRIBUTE(
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_attribute_application_id => p_attribute_application_id,
p_attribute_code => p_attribute_code,
p_attribute_label_length => p_attribute_label_length,
p_attribute_value_length => p_attribute_value_length,
p_bold => p_bold,
p_italic => p_italic,
p_vertical_alignment => p_vertical_alignment,
p_horizontal_alignment => p_horizontal_alignment,
p_data_type => p_data_type,
p_upper_case_flag => p_upper_case_flag,
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_item_style => p_item_style,
p_display_height => p_display_height,
p_css_class_name => p_css_class_name,
p_poplist_viewobject => p_poplist_viewobject,
p_poplist_display_attr => p_poplist_display_attr,
p_poplist_value_attr => p_poplist_value_attr,
p_css_label_class_name => p_css_label_class_name,
p_precision => p_precision,
p_expansion => p_expansion,
p_als_max_length => p_als_max_length,
p_name => p_name,
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: 531

rollback to start_update_attribute;

Line: 537

rollback to start_update_attribute;

Line: 538

end UPDATE_ATTRIBUTE;