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_OBJECT_GRP SQL Statements

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

Line: 60


p_last_updated_by          IN     NUMBER := FND_API.G_MISS_NUM,
p_last_update_date         IN      DATE := FND_API.G_MISS_DATE,
p_last_update_login        IN     NUMBER := FND_API.G_MISS_NUM
) is
l_api_version_number CONSTANT number := 1.0;

Line: 124


p_last_updated_by => p_last_updated_by,
p_last_update_date => p_last_update_date,
p_last_update_login => p_lasT_update_login,
p_pass => l_pass,
p_copy_redo_flag => l_copy_redo_flag
);

Line: 188


p_last_updated_by          IN     NUMBER := FND_API.G_MISS_NUM,
p_last_update_date         IN      DATE := FND_API.G_MISS_DATE,
p_last_update_login        IN     NUMBER := FND_API.G_MISS_NUM
) is
l_api_version_number CONSTANT number := 1.0;

Line: 231


p_last_updated_by => p_last_updated_by,
p_last_update_date => p_last_update_date,
p_last_update_login => p_lasT_update_login,
p_pass => l_pass,
p_copy_redo_flag => l_copy_redo_flag
);

Line: 303


p_last_updated_by          IN     NUMBER := FND_API.G_MISS_NUM,
p_last_update_date         IN      DATE := FND_API.G_MISS_DATE,
p_last_update_login        IN     NUMBER := FND_API.G_MISS_NUM
) is
l_api_version_number CONSTANT number := 1.0;

Line: 352


p_last_updated_by => p_last_updated_by,
p_last_update_date => p_last_update_date,
p_last_update_login => p_lasT_update_login
);

Line: 413


p_last_updated_by          IN     NUMBER := FND_API.G_MISS_NUM,
p_last_update_date         IN      DATE := FND_API.G_MISS_DATE,
p_last_update_login        IN     NUMBER := FND_API.G_MISS_NUM
) is
l_api_version_number CONSTANT number := 1.0;

Line: 457


p_last_updated_by => p_last_updated_by,
p_last_update_date => p_last_update_date,
p_last_update_login => p_lasT_update_login,
p_pass => l_pass,
p_copy_redo_flag => l_copy_redo_flag
);

Line: 511


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_database_object_name     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: 524


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

Line: 541


savepoint start_delete_attribute;

Line: 544


AK_OBJECT_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_database_object_name => p_database_object_name,
p_attribute_application_id => p_attribute_application_id,
p_attribute_code => p_attribute_code,
p_delete_cascade => p_delete_cascade
);

Line: 567


rollback to start_delete_attribute;

Line: 573


rollback to start_delete_attribute;

Line: 574


end DELETE_ATTRIBUTE;

Line: 607


procedure DELETE_ATTRIBUTE_NAVIGATION (
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_database_object_name     IN      VARCHAR2,
p_attribute_application_id IN      NUMBER,
p_attribute_code           IN      VARCHAR2,
p_value_varchar2           IN      VARCHAR2,
p_value_date               IN      DATE,
p_value_number             IN      NUMBER,
p_delete_cascade           IN      VARCHAR2 := 'N'
) is
l_api_version_number CONSTANT number := 1.0;

Line: 623


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

Line: 640


savepoint start_delete_navigation;

Line: 643


AK_OBJECT_PVT.DELETE_ATTRIBUTE_NAVIGATION(
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_database_object_name => p_database_object_name,
p_attribute_application_id => p_attribute_application_id,
p_attribute_code => p_attribute_code,
p_value_varchar2 => p_value_varchar2,
p_value_date => p_value_date,
p_value_number => p_value_number,
p_delete_cascade => p_delete_cascade
);

Line: 669


rollback to start_delete_navigation;

Line: 675


rollback to start_delete_navigation;

Line: 676


end DELETE_ATTRIBUTE_NAVIGATION;

Line: 708


procedure DELETE_ATTRIBUTE_VALUE (
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_database_object_name     IN      VARCHAR2,
p_attribute_application_id IN      NUMBER,
p_attribute_code           IN      VARCHAR2,
p_key_value1               IN      VARCHAR2,
p_key_value2               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_key_value3               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_key_value4               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_key_value5               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_key_value6               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_key_value7               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_key_value8               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_key_value9               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_key_value10              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_delete_cascade           IN      VARCHAR2 := 'N'
) is
l_api_version_number CONSTANT number := 1.0;

Line: 731


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

Line: 748


savepoint start_delete_value;

Line: 751


AK_OBJECT_PVT.DELETE_ATTRIBUTE_VALUE(
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_database_object_name => p_database_object_name,
p_attribute_application_id => p_attribute_application_id,
p_attribute_code => p_attribute_code,
p_key_value1 => p_key_value1,
p_key_value2 => p_key_value2,
p_key_value3 => p_key_value3,
p_key_value4 => p_key_value4,
p_key_value5 => p_key_value5,
p_key_value6 => p_key_value6,
p_key_value7 => p_key_value7,
p_key_value8 => p_key_value8,
p_key_value9 => p_key_value9,
p_key_value10 => p_key_value10,
p_delete_cascade => p_delete_cascade
);

Line: 784


rollback to start_delete_value;

Line: 790


rollback to start_delete_value;

Line: 791


end DELETE_ATTRIBUTE_VALUE;

Line: 817


procedure DELETE_OBJECT (
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_database_object_name     IN      VARCHAR2,
p_delete_cascade           IN      VARCHAR2 := 'N'
) is
l_api_version_number CONSTANT number := 1.0;

Line: 828


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

Line: 845


savepoint start_delete_object;

Line: 848


AK_OBJECT_PVT.DELETE_OBJECT(
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_database_object_name => p_database_object_name,
p_delete_cascade => p_delete_cascade
);

Line: 869


rollback to start_delete_object;

Line: 875


rollback to start_delete_object;

Line: 876


end DELETE_OBJECT;

Line: 980


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

Line: 1065


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_database_object_name     IN      VARCHAR2,
p_attribute_application_id IN      NUMBER,
p_attribute_code           IN      VARCHAR2,
p_column_name              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_data_source_type         IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_data_storage_type        IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_table_name               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_base_table_column_name   IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_required_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_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_defaulting_api_pkg       IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_defaulting_api_proc      IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_validation_api_pkg       IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_validation_api_proc      IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute_value_length   IN      NUMBER := FND_API.G_MISS_NUM,
p_attribute_label_long     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute_label_short    IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_created_by               IN     NUMBER := FND_API.G_MISS_NUM,
p_creation_date            IN      DATE := FND_API.G_MISS_DATE,
p_last_updated_by          IN     NUMBER := FND_API.G_MISS_NUM,
p_last_update_date         IN      DATE := FND_API.G_MISS_DATE,
p_last_update_login        IN     NUMBER := FND_API.G_MISS_NUM
) is
l_api_version_number CONSTANT number := 1.0;

Line: 1109


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

Line: 1128


savepoint start_update_attribute;

Line: 1131


AK_OBJECT3_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_database_object_name => p_database_object_name,
p_attribute_application_id => p_attribute_application_id,
p_attribute_code => p_attribute_code,
p_column_name => p_column_name,
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_data_source_type => p_data_source_type,
p_data_storage_type => p_data_storage_type,
p_table_name => p_table_name,
p_base_table_column_name => p_base_table_column_name,
p_required_flag => p_required_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_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_defaulting_api_pkg => p_defaulting_api_pkg,
p_defaulting_api_proc => p_defaulting_api_proc,
p_validation_api_pkg => p_validation_api_pkg,
p_validation_api_proc => p_validation_api_proc,
p_attribute_label_long => p_attribute_label_long,
p_attribute_label_short => p_attribute_label_short,
p_created_by => p_created_by,
p_creation_date => p_creation_date,
p_last_updated_by => p_last_updated_by,
p_last_update_date => p_last_update_date,
p_last_update_login => p_lasT_update_login,
p_pass => l_pass,
p_copy_redo_flag => l_copy_redo_flag
);

Line: 1187


rollback to start_update_attribute;

Line: 1190


rollback to start_update_attribute;

Line: 1194


end UPDATE_ATTRIBUTE;

Line: 1215


procedure UPDATE_ATTRIBUTE_NAVIGATION (
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_database_object_name     IN      VARCHAR2,
p_attribute_application_id IN      NUMBER,
p_attribute_code           IN      VARCHAR2,
p_value_varchar2           IN      VARCHAR2,
p_value_date               IN      DATE,
p_value_number             IN      NUMBER,
p_to_region_appl_id        IN      NUMBER := FND_API.G_MISS_NUM,
p_to_region_code           IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_created_by               IN     NUMBER := FND_API.G_MISS_NUM,
p_creation_date            IN      DATE := FND_API.G_MISS_DATE,
p_last_updated_by          IN     NUMBER := FND_API.G_MISS_NUM,
p_last_update_date         IN      DATE := FND_API.G_MISS_DATE,
p_last_update_login        IN     NUMBER := FND_API.G_MISS_NUM
) is
l_api_version_number CONSTANT number := 1.0;

Line: 1237


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

Line: 1256


savepoint start_update_navigation;

Line: 1259


AK_OBJECT3_PVT.UPDATE_ATTRIBUTE_NAVIGATION (
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_database_object_name => p_database_object_name,
p_attribute_application_id => p_attribute_application_id,
p_attribute_code => p_attribute_code,
p_value_varchar2 => p_value_varchar2,
p_value_date => p_value_date,
p_value_number => p_value_number,
p_to_region_appl_id => p_to_region_appl_id,
p_to_region_code => p_to_region_code,
p_created_by => p_created_by,
p_creation_date => p_creation_date,
p_last_updated_by => p_last_updated_by,
p_last_update_date => p_last_update_date,
p_last_update_login => p_lasT_update_login,
p_pass => l_pass,
p_copy_redo_flag => l_copy_redo_flag
);

Line: 1294


rollback to start_update_navigation;

Line: 1297


rollback to start_update_navigation;

Line: 1301


end UPDATE_ATTRIBUTE_NAVIGATION;

Line: 1322


procedure UPDATE_ATTRIBUTE_VALUE (
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_database_object_name     IN      VARCHAR2,
p_attribute_application_id IN      NUMBER,
p_attribute_code           IN      VARCHAR2,
p_key_value1               IN      VARCHAR2,
p_key_value2               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_key_value3               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_key_value4               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_key_value5               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_key_value6               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_key_value7               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_key_value8               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_key_value9               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_key_value10              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_value_varchar2           IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_value_date               IN      DATE := FND_API.G_MISS_DATE,
p_value_number             IN      NUMBER := FND_API.G_MISS_NUM,
p_created_by               IN     NUMBER := FND_API.G_MISS_NUM,
p_creation_date            IN      DATE := FND_API.G_MISS_DATE,
p_last_updated_by          IN     NUMBER := FND_API.G_MISS_NUM,
p_last_update_date         IN      DATE := FND_API.G_MISS_DATE,
p_last_update_login        IN     NUMBER := FND_API.G_MISS_NUM
) is
l_api_version_number CONSTANT number := 1.0;

Line: 1352


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

Line: 1369


savepoint start_update_value;

Line: 1372


AK_OBJECT3_PVT.UPDATE_ATTRIBUTE_VALUE (
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_database_object_name => p_database_object_name,
p_attribute_application_id => p_attribute_application_id,
p_attribute_code => p_attribute_code,
p_key_value1 => p_key_value1,
p_key_value2 => p_key_value2,
p_key_value3 => p_key_value3,
p_key_value4 => p_key_value4,
p_key_value5 => p_key_value5,
p_key_value6 => p_key_value6,
p_key_value7 => p_key_value7,
p_key_value8 => p_key_value8,
p_key_value9 => p_key_value9,
p_key_value10 => p_key_value10,
p_value_varchar2 => p_value_varchar2,
p_value_date => p_value_date,
p_value_number => p_value_number,
p_created_by => p_created_by,
p_creation_date => p_creation_date,
p_last_updated_by => p_last_updated_by,
p_last_update_date => p_last_update_date,
p_last_update_login => p_lasT_update_login
);

Line: 1413


rollback to start_update_value;

Line: 1416


rollback to start_update_value;

Line: 1420


end UPDATE_ATTRIBUTE_VALUE;

Line: 1440


procedure UPDATE_OBJECT (
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_database_object_name     IN      VARCHAR2,
p_name                     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_description              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_application_id           IN      NUMBER := FND_API.G_MISS_NUM,
p_primary_key_name         IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_defaulting_api_pkg       IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_defaulting_api_proc      IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_validation_api_pkg       IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_validation_api_proc      IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_created_by               IN     NUMBER := FND_API.G_MISS_NUM,
p_creation_date            IN      DATE := FND_API.G_MISS_DATE,
p_last_updated_by          IN     NUMBER := FND_API.G_MISS_NUM,
p_last_update_date         IN      DATE := FND_API.G_MISS_DATE,
p_last_update_login        IN     NUMBER := FND_API.G_MISS_NUM
) is
l_api_version_number CONSTANT number := 1.0;

Line: 1463


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

Line: 1482


savepoint start_update_object;

Line: 1485


AK_OBJECT3_PVT.UPDATE_OBJECT (
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_database_object_name => p_database_object_name,
p_name => p_name,
p_description => p_description,
p_application_id => p_application_id,
p_primary_key_name => p_primary_key_name,
p_defaulting_api_pkg => p_defaulting_api_pkg,
p_defaulting_api_proc => p_defaulting_api_proc,
p_validation_api_pkg => p_validation_api_pkg,
p_validation_api_proc => p_validation_api_proc,
p_created_by => p_created_by,
p_creation_date => p_creation_date,
p_last_updated_by => p_last_updated_by,
p_last_update_date => p_last_update_date,
p_last_update_login => p_lasT_update_login,
p_pass => l_pass,
p_copy_redo_flag => l_copy_redo_flag
);

Line: 1521


rollback to start_update_object;

Line: 1527


rollback to start_update_object;

Line: 1528


end UPDATE_OBJECT;