DBA Data[Home] [Help]

APPS.AK_KEY_PVT SQL Statements

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

Line: 62

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,
p_loader_timestamp         IN      DATE := FND_API.G_MISS_DATE,
p_pass                     IN      NUMBER,
p_copy_redo_flag           IN OUT NOCOPY  BOOLEAN
) is
l_api_version_number  CONSTANT number := 1.0;
Line: 93

l_last_update_date    date;
Line: 94

l_last_update_login   number;
Line: 95

l_last_updated_by     number;
Line: 236

  if (p_last_updated_by <> FND_API.G_MISS_NUM) then
    l_last_updated_by := p_last_updated_by;
Line: 240

  if (p_last_update_date <> FND_API.G_MISS_DATE) then
    l_last_update_date := p_last_update_date;
Line: 244

  if (p_last_update_login <> FND_API.G_MISS_NUM) then
    l_last_update_login := p_last_update_login;
Line: 254

  if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
       p_loader_timestamp => p_loader_timestamp,
       p_created_by => l_created_by,
       p_creation_date => l_creation_date,
       p_last_updated_by => l_last_updated_by,
       p_db_last_updated_by => null,
       p_last_update_date => l_last_update_date,
       p_db_last_update_date => null,
       p_last_update_login => l_last_update_login,
       p_create_or_update => 'CREATE') then
     null;
Line: 267

select userenv('LANG') into l_lang
from dual;
Line: 270

insert into AK_FOREIGN_KEYS (
FOREIGN_KEY_NAME,
DATABASE_OBJECT_NAME,
UNIQUE_KEY_NAME,
APPLICATION_ID,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN
) values (
p_foreign_key_name,
p_database_object_name,
p_unique_key_name,
p_application_id,
l_attribute_category,
l_attribute1,
l_attribute2,
l_attribute3,
l_attribute4,
l_attribute5,
l_attribute6,
l_attribute7,
l_attribute8,
l_attribute9,
l_attribute10,
l_attribute11,
l_attribute12,
l_attribute13,
l_attribute14,
l_attribute15,
l_creation_date,
l_created_by,
l_last_update_date,
l_last_updated_by,
l_last_update_login
);
Line: 330

FND_MESSAGE.SET_NAME('AK','AK_INSERT_FK_FAILED');
Line: 337

insert into AK_FOREIGN_KEYS_TL (
FOREIGN_KEY_NAME,
LANGUAGE,
FROM_TO_NAME,
FROM_TO_DESCRIPTION,
TO_FROM_NAME,
TO_FROM_DESCRIPTION,
SOURCE_LANG,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN
) select
p_foreign_key_name,
L.LANGUAGE_CODE,
l_from_to_name,
l_from_to_description,
l_to_from_name,
l_to_from_description,
decode(L.LANGUAGE_CODE, l_lang, L.LANGUAGE_CODE, l_lang),
l_creation_date,
l_created_by,
l_last_update_date,
l_last_updated_by,
l_last_update_login
from FND_LANGUAGES L
where L.INSTALLED_FLAG in ('I', 'B')
and not exists
(select NULL
from AK_FOREIGN_KEYS_TL T
where T.FOREIGN_KEY_NAME = p_foreign_key_name
and T.LANGUAGE = L.LANGUAGE_CODE);
Line: 473

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,
p_loader_timestamp         IN      DATE := FND_API.G_MISS_DATE,
p_pass                     IN      NUMBER,
p_copy_redo_flag           IN OUT NOCOPY  BOOLEAN
) is
l_api_version_number CONSTANT number := 1.0;
Line: 501

l_last_update_date   date;
Line: 502

l_last_update_login  number;
Line: 503

l_last_updated_by    number;
Line: 627

  if (p_last_updated_by <> FND_API.G_MISS_NUM) then
    l_last_updated_by := p_last_updated_by;
Line: 631

  if (p_last_update_date <> FND_API.G_MISS_DATE) then
    l_last_update_date := p_last_update_date;
Line: 635

  if (p_last_update_login <> FND_API.G_MISS_NUM) then
    l_last_update_login := p_last_update_login;
Line: 645

  if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
       p_loader_timestamp => p_loader_timestamp,
       p_created_by => l_created_by,
       p_creation_date => l_creation_date,
       p_last_updated_by => l_last_updated_by,
       p_db_last_updated_by => null,
       p_last_update_date => l_last_update_date,
       p_db_last_update_date => null,
       p_last_update_login => l_last_update_login,
       p_create_or_update => 'CREATE') then
     null;
Line: 658

insert into AK_FOREIGN_KEY_COLUMNS (
FOREIGN_KEY_NAME,
ATTRIBUTE_APPLICATION_ID,
ATTRIBUTE_CODE,
FOREIGN_KEY_SEQUENCE,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN
) values (
p_foreign_key_name,
p_attribute_application_id,
p_attribute_code,
p_foreign_key_sequence,
l_attribute_category,
l_attribute1,
l_attribute2,
l_attribute3,
l_attribute4,
l_attribute5,
l_attribute6,
l_attribute7,
l_attribute8,
l_attribute9,
l_attribute10,
l_attribute11,
l_attribute12,
l_attribute13,
l_attribute14,
l_attribute15,
l_creation_date,
l_created_by,
l_last_update_date,
l_last_updated_by,
l_last_update_login
);
Line: 824

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,
p_loader_timestamp         IN      DATE := FND_API.G_MISS_DATE,
p_pass                     IN      NUMBER,
p_copy_redo_flag           IN OUT NOCOPY  BOOLEAN
) is
l_attribute_category VARCHAR2(30);
Line: 853

l_last_update_date   date;
Line: 854

l_last_update_login  number;
Line: 855

l_last_updated_by    number;
Line: 976

  if (p_last_updated_by <> FND_API.G_MISS_NUM) then
    l_last_updated_by := p_last_updated_by;
Line: 980

  if (p_last_update_date <> FND_API.G_MISS_DATE) then
    l_last_update_date := p_last_update_date;
Line: 984

  if (p_last_update_login <> FND_API.G_MISS_NUM) then
    l_last_update_login := p_last_update_login;
Line: 994

  if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
       p_loader_timestamp => p_loader_timestamp,
       p_created_by => l_created_by,
       p_creation_date => l_creation_date,
       p_last_updated_by => l_last_updated_by,
       p_db_last_updated_by => null,
       p_last_update_date => l_last_update_date,
       p_db_last_update_date => null,
       p_last_update_login => l_last_update_login,
       p_create_or_update => 'CREATE') then
     null;
Line: 1007

insert into AK_UNIQUE_KEYS (
UNIQUE_KEY_NAME,
DATABASE_OBJECT_NAME,
APPLICATION_ID,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN
) values (
p_unique_key_name,
p_database_object_name,
p_application_id,
l_attribute_category,
l_attribute1,
l_attribute2,
l_attribute3,
l_attribute4,
l_attribute5,
l_attribute6,
l_attribute7,
l_attribute8,
l_attribute9,
l_attribute10,
l_attribute11,
l_attribute12,
l_attribute13,
l_attribute14,
l_attribute15,
l_creation_date,
l_created_by,
l_last_update_date,
l_last_updated_by,
l_last_update_login
);
Line: 1159

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,
p_loader_timestamp         IN      DATE := FND_API.G_MISS_DATE,
p_pass                     IN      NUMBER,
p_copy_redo_flag           IN OUT NOCOPY  BOOLEAN
) is
l_attribute_category VARCHAR2(30);
Line: 1187

l_last_update_date   date;
Line: 1188

l_last_update_login  number;
Line: 1189

l_last_updated_by    number;
Line: 1314

  if (p_last_updated_by <> FND_API.G_MISS_NUM) then
    l_last_updated_by := p_last_updated_by;
Line: 1318

  if (p_last_update_date <> FND_API.G_MISS_DATE) then
    l_last_update_date := p_last_update_date;
Line: 1322

  if (p_last_update_login <> FND_API.G_MISS_NUM) then
    l_last_update_login := p_last_update_login;
Line: 1332

  if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
       p_loader_timestamp => p_loader_timestamp,
       p_created_by => l_created_by,
       p_creation_date => l_creation_date,
       p_last_updated_by => l_last_updated_by,
       p_db_last_updated_by => null,
       p_last_update_date => l_last_update_date,
       p_db_last_update_date => null,
       p_last_update_login => l_last_update_login,
       p_create_or_update => 'CREATE') then
     null;
Line: 1345

insert into AK_UNIQUE_KEY_COLUMNS (
UNIQUE_KEY_NAME,
ATTRIBUTE_APPLICATION_ID,
ATTRIBUTE_CODE,
UNIQUE_KEY_SEQUENCE,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN
) values (
p_unique_key_name,
p_attribute_application_id,
p_attribute_code,
p_unique_key_sequence,
l_attribute_category,
l_attribute1,
l_attribute2,
l_attribute3,
l_attribute4,
l_attribute5,
l_attribute6,
l_attribute7,
l_attribute8,
l_attribute9,
l_attribute10,
l_attribute11,
l_attribute12,
l_attribute13,
l_attribute14,
l_attribute15,
l_creation_date,
l_created_by,
l_last_update_date,
l_last_updated_by,
l_last_update_login
);
Line: 1476

procedure DELETE_FOREIGN_KEY (
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_foreign_key_name         IN      VARCHAR2,
p_delete_cascade           IN      VARCHAR2
) is
cursor l_get_columns_csr is
select ATTRIBUTE_APPLICATION_ID, ATTRIBUTE_CODE
from   AK_FOREIGN_KEY_COLUMNS
where  FOREIGN_KEY_NAME = p_foreign_key_name;
Line: 1491

select FLOW_APPLICATION_ID, FLOW_CODE, FROM_PAGE_APPL_ID, FROM_PAGE_CODE,
FROM_REGION_APPL_ID, FROM_REGION_CODE, TO_PAGE_APPL_ID,
TO_PAGE_CODE, TO_REGION_APPL_ID, TO_REGION_CODE
from  AK_FLOW_REGION_RELATIONS
where FOREIGN_KEY_NAME = p_foreign_key_name;
Line: 1497

l_api_name              CONSTANT varchar2(30):= 'Delete_Foreign_Key';
Line: 1527

savepoint start_delete_foreign_key;
Line: 1543

if (p_delete_cascade = 'N') then
--
-- If we are not deleting any referencing records, we cannot
-- delete the foreign key if it is being referenced in any of
-- following tables.
--
-- AK_FOREIGN_KEY_COLUMNS
--
open l_get_columns_csr;
Line: 1591

AK_KEY_PVT.DELETE_FOREIGN_KEY_COLUMN (
p_validation_level => p_validation_level,
p_api_version_number => 1.0,
p_msg_count => l_msg_count,
p_msg_data => l_msg_data,
p_return_status => l_return_status,
p_foreign_key_name => p_foreign_key_name,
p_attribute_application_id => l_attribute_appl_id,
p_attribute_code => l_attribute_code,
p_delete_cascade => p_delete_cascade
);
Line: 1620

AK_FLOW_PVT.DELETE_REGION_RELATION (
p_validation_level => p_validation_level,
p_api_version_number => 1.0,
p_return_status => l_return_status,
p_msg_count => l_msg_count,
p_msg_data => l_msg_data,
p_flow_application_id => l_flow_application_id,
p_flow_code => l_flow_code,
p_foreign_key_name => p_foreign_key_name,
p_from_page_appl_id => l_from_page_appl_id,
p_from_page_code => l_from_page_code,
p_from_region_appl_id => l_from_region_appl_id,
p_from_region_code => l_from_region_code,
p_to_page_appl_id => l_to_page_appl_id,
p_to_page_code => l_to_page_code,
p_to_region_appl_id => l_to_region_appl_id,
p_to_region_code => l_to_region_code,
p_delete_cascade => p_delete_cascade
);
Line: 1653

delete from ak_foreign_keys
where  foreign_key_name = p_foreign_key_name;
Line: 1664

delete from ak_foreign_keys_tl
where  foreign_key_name = p_foreign_key_name;
Line: 1679

FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_DELETED');
Line: 1693

FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_NOT_DELETED');
Line: 1698

rollback to start_delete_foreign_key;
Line: 1704

rollback to start_delete_foreign_key;
Line: 1711

end DELETE_FOREIGN_KEY;
Line: 1740

procedure DELETE_FOREIGN_KEY_COLUMN (
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_foreign_key_name         IN      VARCHAR2,
p_attribute_application_id IN      NUMBER,
p_attribute_code           IN      VARCHAR2,
p_delete_cascade           IN      VARCHAR2
) is
l_api_version_number    CONSTANT number := 1.0;
Line: 1753

l_api_name              CONSTANT varchar2(30):= 'Delete_Foreign_Key_Column';
Line: 1769

savepoint start_delete_key_column;
Line: 1787

if (p_delete_cascade = 'N') then
--
-- If we are not deleting any referencing records, we cannot
-- delete the foreign key column if it is being referenced in any of
-- following tables.
--
-- (currently none - add logic here in the future)
--
null;
Line: 1809

delete from ak_foreign_key_columns
where  foreign_key_name = p_foreign_key_name
and    attribute_application_id = p_attribute_application_id
and    attribute_code = p_attribute_code;
Line: 1827

FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_DELETED');
Line: 1843

FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_NOT_DELETED');
Line: 1850

rollback to start_delete_key_column;
Line: 1856

rollback to start_delete_key_column;
Line: 1863

end DELETE_FOREIGN_KEY_COLUMN;
Line: 1890

procedure DELETE_UNIQUE_KEY (
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_unique_key_name          IN      VARCHAR2,
p_delete_cascade           IN      VARCHAR2
) is
cursor l_get_columns_csr is
select ATTRIBUTE_APPLICATION_ID, ATTRIBUTE_CODE
from   AK_UNIQUE_KEY_COLUMNS
where  UNIQUE_KEY_NAME = p_unique_key_name;
Line: 1905

select FOREIGN_KEY_NAME
from   AK_FOREIGN_KEYS
where  UNIQUE_KEY_NAME = p_unique_key_name;
Line: 1910

l_api_name              CONSTANT varchar2(30):= 'Delete_Unique_Key';
Line: 1931

savepoint start_delete_unique_key;
Line: 1947

if (p_delete_cascade = 'N') then
--
-- If we are not deleting any referencing records, we cannot
-- delete the primary key if it is being referenced in any of
-- following tables.
--
-- AK_UNIQUE_KEY_COLUMNS
--
open l_get_columns_csr;
Line: 1991

AK_KEY_PVT.DELETE_UNIQUE_KEY_COLUMN (
p_validation_level => p_validation_level,
p_api_version_number => 1.0,
p_msg_count => l_msg_count,
p_msg_data => l_msg_data,
p_return_status => l_return_status,
p_unique_key_name => p_unique_key_name,
p_attribute_application_id => l_attribute_appl_id,
p_attribute_code => l_attribute_code,
p_delete_cascade => p_delete_cascade
);
Line: 2016

AK_KEY_PVT.DELETE_FOREIGN_KEY (
p_validation_level => p_validation_level,
p_api_version_number => 1.0,
p_msg_count => l_msg_count,
p_msg_data => l_msg_data,
p_return_status => l_return_status,
p_foreign_key_name => l_foreign_key_name,
p_delete_cascade => p_delete_cascade
);
Line: 2039

delete from ak_unique_keys
where  unique_key_name = p_unique_key_name;
Line: 2054

FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_KEY_DELETED');
Line: 2068

FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_KEY_NOT_DELETED');
Line: 2073

rollback to start_delete_unique_key;
Line: 2079

rollback to start_delete_unique_key;
Line: 2086

end DELETE_UNIQUE_KEY;
Line: 2115

procedure DELETE_UNIQUE_KEY_COLUMN (
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_unique_key_name          IN      VARCHAR2,
p_attribute_application_id IN      NUMBER,
p_attribute_code           IN      VARCHAR2,
p_delete_cascade           IN      VARCHAR2,
p_override                 IN      VARCHAR2 := 'N'
) is
cursor l_get_fkc_csr is
select fkc.FOREIGN_KEY_NAME, fkc.ATTRIBUTE_APPLICATION_ID,
fkc.ATTRIBUTE_CODE
from   AK_FOREIGN_KEY_COLUMNS fkc,
AK_FOREIGN_KEYS fk,
AK_UNIQUE_KEY_COLUMNS pkc
where  fk.unique_key_name = pkc.unique_key_name
and    fk.foreign_key_name = fkc.foreign_key_name
and    fkc.foreign_key_sequence = pkc.unique_key_sequence
and    pkc.unique_key_name = p_unique_key_name
and    pkc.attribute_application_id = p_attribute_application_id
and    pkc.attribute_code = p_attribute_code;
Line: 2141

l_api_name              CONSTANT varchar2(30):= 'Delete_Unique_Key_Column';
Line: 2162

savepoint start_delete_key_column;
Line: 2183

if (p_delete_cascade = 'N') then
--
-- If we are not deleting any referencing records, we cannot
-- delete the unique key column if it is being referenced in any of
-- following tables.
--
-- AK_FOREIGN_KEY_COLUMNS
--
open l_get_fkc_csr;
Line: 2214

AK_KEY_PVT.DELETE_FOREIGN_KEY_COLUMN(
p_validation_level => p_validation_level,
p_api_version_number => 1.0,
p_msg_count => l_msg_count,
p_msg_data => l_msg_data,
p_return_status => l_return_status,
p_foreign_key_name => l_foreign_key_name,
p_attribute_application_id => l_attribute_appl_id,
p_attribute_code => l_attribute_code,
p_delete_cascade => p_delete_cascade
);
Line: 2232

end if; -- /* if p_delete_cascade */
Line: 2238

delete from ak_unique_key_columns
where  unique_key_name = p_unique_key_name
and    attribute_application_id = p_attribute_application_id
and    attribute_code = p_attribute_code;
Line: 2255

FND_MESSAGE.SET_NAME('AK','AK_UK_COLUMN_DELETED');
Line: 2271

FND_MESSAGE.SET_NAME('AK','AK_UK_COLUMN_NOT_DELETED');
Line: 2278

rollback to start_delete_key_column;
Line: 2284

rollback to start_delete_key_column;
Line: 2291

end DELETE_UNIQUE_KEY_COLUMN;
Line: 2322

select 1
from  AK_FOREIGN_KEYS
where FOREIGN_KEY_NAME = p_foreign_key_name;
Line: 2392

select 1
from  AK_FOREIGN_KEY_COLUMNS
where FOREIGN_KEY_NAME = p_foreign_key_name
and   ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
and   ATTRIBUTE_CODE = p_attribute_code;
Line: 2456

select 1
from  AK_UNIQUE_KEYS
where UNIQUE_KEY_NAME = p_unique_key_name;
Line: 2519

select 1
from  AK_UNIQUE_KEY_COLUMNS
where UNIQUE_KEY_NAME = p_unique_key_name
and   ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
and   ATTRIBUTE_CODE = p_attribute_code;
Line: 2576

procedure UPDATE_FOREIGN_KEY (
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_foreign_key_name         IN      VARCHAR2,
p_database_object_name     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_unique_key_name          IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_application_id           IN      NUMBER := FND_API.G_MISS_NUM,
p_attribute_category       IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute1               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute2               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute3               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute4               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute5               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute6               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute7               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute8               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute9               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute10              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute11              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute12              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute13              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute14              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute15              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_from_to_name             IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_from_to_description      IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_to_from_name             IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_to_from_description      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,
p_loader_timestamp         IN      DATE := FND_API.G_MISS_DATE,
p_pass                     IN      NUMBER,
p_copy_redo_flag           IN OUT NOCOPY  BOOLEAN
) is
cursor l_get_row_csr is
select *
from  AK_FOREIGN_KEYS
where FOREIGN_KEY_NAME = p_foreign_key_name
for   update of DATABASE_OBJECT_NAME;
Line: 2622

select *
from  AK_FOREIGN_KEYS_TL
where FOREIGN_KEY_NAME = p_foreign_key_name
and   LANGUAGE = lang_parm
for   update of FROM_TO_NAME;
Line: 2628

l_api_name              CONSTANT varchar2(30):= 'Update_Foreign_Key';
Line: 2635

l_last_update_date      date;
Line: 2636

l_last_update_login     number;
Line: 2637

l_last_updated_by       number;
Line: 2655

savepoint start_update_foreign_key;
Line: 2657

select userenv('LANG') into l_lang
from dual;
Line: 2702

p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,
p_pass => p_pass
) then
--dbms_output.put_line(l_api_name || ' validation failed');
Line: 2814

  if (p_last_updated_by <> FND_API.G_MISS_NUM) then
    l_last_updated_by := p_last_updated_by;
Line: 2817

  if (p_last_update_date <> FND_API.G_MISS_DATE) then
    l_last_update_date := p_last_update_date;
Line: 2820

  if (p_last_update_login <> FND_API.G_MISS_NUM) then
    l_last_update_login := p_last_update_login;
Line: 2824

  if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
       p_loader_timestamp => p_loader_timestamp,
       p_created_by => l_created_by,
       p_creation_date => l_creation_date,
       p_last_updated_by => l_last_updated_by,
       p_db_last_updated_by => l_foreign_key_rec.last_updated_by,
       p_last_update_date => l_last_update_date,
       p_db_last_update_date => l_foreign_key_rec.last_update_date,
       p_last_update_login => l_last_update_login,
       p_create_or_update => 'UPDATE') then

update AK_FOREIGN_KEYS set
DATABASE_OBJECT_NAME = l_foreign_key_rec.database_object_name,
UNIQUE_KEY_NAME = l_foreign_key_rec.unique_key_name,
APPLICATION_ID = l_foreign_key_rec.application_id,
ATTRIBUTE_CATEGORY = l_foreign_key_rec.attribute_category,
ATTRIBUTE1 = l_foreign_key_rec.attribute1,
ATTRIBUTE2 = l_foreign_key_rec.attribute2,
ATTRIBUTE3 = l_foreign_key_rec.attribute3,
ATTRIBUTE4 = l_foreign_key_rec.attribute4,
ATTRIBUTE5 = l_foreign_key_rec.attribute5,
ATTRIBUTE6 = l_foreign_key_rec.attribute6,
ATTRIBUTE7 = l_foreign_key_rec.attribute7,
ATTRIBUTE8 = l_foreign_key_rec.attribute8,
ATTRIBUTE9 = l_foreign_key_rec.attribute9,
ATTRIBUTE10 = l_foreign_key_rec.attribute10,
ATTRIBUTE11 = l_foreign_key_rec.attribute11,
ATTRIBUTE12 = l_foreign_key_rec.attribute12,
ATTRIBUTE13 = l_foreign_key_rec.attribute13,
ATTRIBUTE14 = l_foreign_key_rec.attribute14,
ATTRIBUTE15 = l_foreign_key_rec.attribute15,
LAST_UPDATE_DATE = l_last_update_date,
LAST_UPDATED_BY = l_last_updated_by,
LAST_UPDATE_LOGIN = l_last_update_login
where foreign_key_name = p_foreign_key_name;
Line: 2861

FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_UPDATE_FAILED');
Line: 2868

update AK_FOREIGN_KEYS_TL set
FROM_TO_NAME = l_foreign_key_tl_rec.from_to_name,
FROM_TO_DESCRIPTION = l_foreign_key_tl_rec.from_to_description,
TO_FROM_NAME = l_foreign_key_tl_rec.to_from_name,
TO_FROM_DESCRIPTION = l_foreign_key_tl_rec.to_from_description,
LAST_UPDATE_DATE = l_last_update_date,
LAST_UPDATED_BY = l_last_updated_by,
LAST_UPDATE_LOGIN = l_last_update_login,
SOURCE_LANG = l_lang
where foreign_key_name = p_foreign_key_name
and   l_lang in (LANGUAGE, SOURCE_LANG);
Line: 2881

FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_UPDATE_FAILED');
Line: 2889

FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_UPDATED');
Line: 2908

rollback to start_update_foreign_key;
Line: 2915

FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_NOT_UPDATED');
Line: 2920

rollback to start_update_foreign_key;
Line: 2926

rollback to start_update_foreign_key;
Line: 2933

end UPDATE_FOREIGN_KEY;
Line: 2958

procedure UPDATE_FOREIGN_KEY_COLUMN (
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_foreign_key_name         IN      VARCHAR2,
p_attribute_application_id IN      NUMBER,
p_attribute_code           IN      VARCHAR2,
p_foreign_key_sequence     IN      NUMBER := FND_API.G_MISS_NUM,
p_attribute_category       IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute1               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute2               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute3               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute4               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute5               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute6               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute7               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute8               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute9               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute10              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute11              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute12              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute13              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute14              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute15              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,
p_loader_timestamp         IN      DATE := FND_API.G_MISS_DATE,
p_pass                     IN      NUMBER,
p_copy_redo_flag           IN OUT NOCOPY  BOOLEAN
) is
cursor l_get_row_csr is
select *
from  AK_FOREIGN_KEY_COLUMNS
where FOREIGN_KEY_NAME = p_foreign_key_name
and   ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
and   ATTRIBUTE_CODE = p_attribute_code
for   update of FOREIGN_KEY_SEQUENCE;
Line: 3002

l_api_name              CONSTANT varchar2(30):= 'Update_Foreign_Key_Column';
Line: 3007

l_last_update_date      date;
Line: 3008

l_last_update_login     number;
Line: 3009

l_last_updated_by       number;
Line: 3026

savepoint start_update_key_column;
Line: 3051

p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,
p_pass => p_pass
) then
raise FND_API.G_EXC_ERROR;
Line: 3138

  if (p_last_updated_by <> FND_API.G_MISS_NUM) then
    l_last_updated_by := p_last_updated_by;
Line: 3141

  if (p_last_update_date <> FND_API.G_MISS_DATE) then
    l_last_update_date := p_last_update_date;
Line: 3144

  if (p_last_update_login <> FND_API.G_MISS_NUM) then
    l_last_update_login := p_last_update_login;
Line: 3148

  if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
       p_loader_timestamp => p_loader_timestamp,
       p_created_by => l_created_by,
       p_creation_date => l_creation_date,
       p_last_updated_by => l_last_updated_by,
       p_db_last_updated_by => l_key_column_rec.last_updated_by,
       p_last_update_date => l_last_update_date,
       p_db_last_update_date => l_key_column_rec.last_update_date,
       p_last_update_login => l_last_update_login,
       p_create_or_update => 'UPDATE') then

update AK_FOREIGN_KEY_COLUMNS set
FOREIGN_KEY_SEQUENCE = l_key_column_rec.foreign_key_sequence,
ATTRIBUTE_CATEGORY = l_key_column_rec.attribute_category,
ATTRIBUTE1 = l_key_column_rec.attribute1,
ATTRIBUTE2 = l_key_column_rec.attribute2,
ATTRIBUTE3 = l_key_column_rec.attribute3,
ATTRIBUTE4 = l_key_column_rec.attribute4,
ATTRIBUTE5 = l_key_column_rec.attribute5,
ATTRIBUTE6 = l_key_column_rec.attribute6,
ATTRIBUTE7 = l_key_column_rec.attribute7,
ATTRIBUTE8 = l_key_column_rec.attribute8,
ATTRIBUTE9 = l_key_column_rec.attribute9,
ATTRIBUTE10 = l_key_column_rec.attribute10,
ATTRIBUTE11 = l_key_column_rec.attribute11,
ATTRIBUTE12 = l_key_column_rec.attribute12,
ATTRIBUTE13 = l_key_column_rec.attribute13,
ATTRIBUTE14 = l_key_column_rec.attribute14,
ATTRIBUTE15 = l_key_column_rec.attribute15,
LAST_UPDATE_DATE = l_last_update_date,
LAST_UPDATED_BY = l_last_updated_by,
LAST_UPDATE_LOGIN = l_last_update_login
where foreign_key_name = p_foreign_key_name
and   attribute_application_id = p_attribute_application_id
and   attribute_code = p_attribute_code;
Line: 3185

FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_UPDATE_FAILED');
Line: 3193

FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_UPDATED');
Line: 3217

rollback to start_update_key_column;
Line: 3224

FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_NOT_UPDATED');
Line: 3231

rollback to start_update_key_column;
Line: 3237

rollback to start_update_key_column;
Line: 3244

end UPDATE_FOREIGN_KEY_COLUMN;
Line: 3269

procedure UPDATE_UNIQUE_KEY (
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_unique_key_name          IN      VARCHAR2,
p_database_object_name     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_application_id           IN      NUMBER := FND_API.G_MISS_NUM,
p_attribute_category       IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute1               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute2               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute3               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute4               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute5               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute6               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute7               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute8               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute9               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute10              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute11              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute12              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute13              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute14              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute15              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,
p_loader_timestamp         IN      DATE := FND_API.G_MISS_DATE,
p_pass                     IN      NUMBER,
p_copy_redo_flag           IN OUT NOCOPY  BOOLEAN
) is
cursor l_get_row_csr is
select *
from  AK_UNIQUE_KEYS
where UNIQUE_KEY_NAME = p_unique_key_name
for   update of DATABASE_OBJECT_NAME;
Line: 3310

l_api_name              CONSTANT varchar2(30):= 'Update_Unique_Key';
Line: 3315

l_last_update_date      date;
Line: 3316

l_last_update_login     number;
Line: 3317

l_last_updated_by       number;
Line: 3334

savepoint start_update_unique_key;
Line: 3359

p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,
p_pass => p_pass
) then
--dbms_output.put_line(l_api_name || ' validation failed');
Line: 3447

  if (p_last_updated_by <> FND_API.G_MISS_NUM) then
    l_last_updated_by := p_last_updated_by;
Line: 3450

  if (p_last_update_date <> FND_API.G_MISS_DATE) then
    l_last_update_date := p_last_update_date;
Line: 3453

  if (p_last_update_login <> FND_API.G_MISS_NUM) then
    l_last_update_login := p_last_update_login;
Line: 3457

  if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
       p_loader_timestamp => p_loader_timestamp,
       p_created_by => l_created_by,
       p_creation_date => l_creation_date,
       p_last_updated_by => l_last_updated_by,
       p_db_last_updated_by => l_unique_key_rec.last_updated_by,
       p_last_update_date => l_last_update_date,
       p_db_last_update_date => l_unique_key_rec.last_update_date,
       p_last_update_login => l_last_update_login,
       p_create_or_update => 'UPDATE') then

update AK_UNIQUE_KEYS set
DATABASE_OBJECT_NAME = l_unique_key_rec.database_object_name,
APPLICATION_ID = l_unique_key_rec.application_id,
ATTRIBUTE_CATEGORY = l_unique_key_rec.attribute_category,
ATTRIBUTE1 = l_unique_key_rec.attribute1,
ATTRIBUTE2 = l_unique_key_rec.attribute2,
ATTRIBUTE3 = l_unique_key_rec.attribute3,
ATTRIBUTE4 = l_unique_key_rec.attribute4,
ATTRIBUTE5 = l_unique_key_rec.attribute5,
ATTRIBUTE6 = l_unique_key_rec.attribute6,
ATTRIBUTE7 = l_unique_key_rec.attribute7,
ATTRIBUTE8 = l_unique_key_rec.attribute8,
ATTRIBUTE9 = l_unique_key_rec.attribute9,
ATTRIBUTE10 = l_unique_key_rec.attribute10,
ATTRIBUTE11 = l_unique_key_rec.attribute11,
ATTRIBUTE12 = l_unique_key_rec.attribute12,
ATTRIBUTE13 = l_unique_key_rec.attribute13,
ATTRIBUTE14 = l_unique_key_rec.attribute14,
ATTRIBUTE15 = l_unique_key_rec.attribute15,
LAST_UPDATE_DATE = l_last_update_date,
LAST_UPDATED_BY = l_last_updated_by,
LAST_UPDATE_LOGIN = l_last_update_login
where unique_key_name = p_unique_key_name;
Line: 3493

FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_KEY_UPDATE_FAILED');
Line: 3501

FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_KEY_UPDATED');
Line: 3520

rollback to start_update_unique_key;
Line: 3527

FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_KEY_NOT_UPDATED');
Line: 3532

rollback to start_update_unique_key;
Line: 3538

rollback to start_update_unique_key;
Line: 3545

end UPDATE_UNIQUE_KEY;
Line: 3570

procedure UPDATE_UNIQUE_KEY_COLUMN (
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_unique_key_name          IN      VARCHAR2,
p_attribute_application_id IN      NUMBER,
p_attribute_code           IN      VARCHAR2,
p_unique_key_sequence      IN      NUMBER := FND_API.G_MISS_NUM,
p_attribute_category       IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute1               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute2               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute3               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute4               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute5               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute6               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute7               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute8               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute9               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute10              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute11              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute12              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute13              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute14              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute15              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,
p_loader_timestamp         IN      DATE := FND_API.G_MISS_DATE,
p_pass                     IN      NUMBER,
p_copy_redo_flag           IN OUT NOCOPY  BOOLEAN
) is
cursor l_get_row_csr is
select *
from  AK_UNIQUE_KEY_COLUMNS
where UNIQUE_KEY_NAME = p_unique_key_name
and   ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
and   ATTRIBUTE_CODE = p_attribute_code
for   update of UNIQUE_KEY_SEQUENCE;
Line: 3614

l_api_name              CONSTANT varchar2(30):= 'Update_Unique_Key_Column';
Line: 3619

l_last_update_date      date;
Line: 3620

l_last_update_login     number;
Line: 3621

l_last_updated_by       number;
Line: 3638

savepoint start_update_key_column;
Line: 3664

p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,
p_pass => p_pass
) then
--dbms_output.put_line(l_api_name || ' validation failed');
Line: 3749

  if (p_last_updated_by <> FND_API.G_MISS_NUM) then
    l_last_updated_by := p_last_updated_by;
Line: 3752

  if (p_last_update_date <> FND_API.G_MISS_DATE) then
    l_last_update_date := p_last_update_date;
Line: 3755

  if (p_last_update_login <> FND_API.G_MISS_NUM) then
    l_last_update_login := p_last_update_login;
Line: 3759

  if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
       p_loader_timestamp => p_loader_timestamp,
       p_created_by => l_created_by,
       p_creation_date => l_creation_date,
       p_last_updated_by => l_last_updated_by,
       p_db_last_updated_by => l_key_column_rec.last_updated_by,
       p_last_update_date => l_last_update_date,
       p_db_last_update_date => l_key_column_rec.last_update_date,
       p_last_update_login => l_last_update_login,
       p_create_or_update => 'UPDATE') then

update AK_UNIQUE_KEY_COLUMNS set
UNIQUE_KEY_SEQUENCE = l_key_column_rec.unique_key_sequence,
ATTRIBUTE_CATEGORY = l_key_column_rec.attribute_category,
ATTRIBUTE1 = l_key_column_rec.attribute1,
ATTRIBUTE2 = l_key_column_rec.attribute2,
ATTRIBUTE3 = l_key_column_rec.attribute3,
ATTRIBUTE4 = l_key_column_rec.attribute4,
ATTRIBUTE5 = l_key_column_rec.attribute5,
ATTRIBUTE6 = l_key_column_rec.attribute6,
ATTRIBUTE7 = l_key_column_rec.attribute7,
ATTRIBUTE8 = l_key_column_rec.attribute8,
ATTRIBUTE9 = l_key_column_rec.attribute9,
ATTRIBUTE10 = l_key_column_rec.attribute10,
ATTRIBUTE11 = l_key_column_rec.attribute11,
ATTRIBUTE12 = l_key_column_rec.attribute12,
ATTRIBUTE13 = l_key_column_rec.attribute13,
ATTRIBUTE14 = l_key_column_rec.attribute14,
ATTRIBUTE15 = l_key_column_rec.attribute15,
LAST_UPDATE_DATE = l_last_update_date,
LAST_UPDATED_BY = l_last_updated_by,
LAST_UPDATE_LOGIN = l_last_update_login
where unique_key_name = p_unique_key_name
and   attribute_application_id = p_attribute_application_id
and   attribute_code = p_attribute_code;
Line: 3796

FND_MESSAGE.SET_NAME('AK','AK_UK_COLUMN_UPDATE_FAILED');
Line: 3804

FND_MESSAGE.SET_NAME('AK','AK_UK_COLUMN_UPDATED');
Line: 3827

rollback to start_update_key_column;
Line: 3834

FND_MESSAGE.SET_NAME('AK','AK_UK_COLUMN_NOT_UPDATED');
Line: 3841

rollback to start_update_key_column;
Line: 3847

rollback to start_update_key_column;
Line: 3854

end UPDATE_UNIQUE_KEY_COLUMN;
Line: 3958

p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE))
then
l_error := TRUE;
Line: 3970

p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
l_error := TRUE;
Line: 3981

p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
l_error := TRUE;
Line: 4082

select  database_object_name
from    AK_FOREIGN_KEYS
where   FOREIGN_KEY_NAME = p_foreign_key_name;
Line: 4086

select  1
from    AK_UNIQUE_KEY_COLUMNS pkc, AK_FOREIGN_KEYS fk
where   fk.FOREIGN_KEY_NAME = p_foreign_key_name
and     fk.UNIQUE_KEY_NAME = pkc.UNIQUE_KEY_NAME
and     pkc.UNIQUE_KEY_SEQUENCE = p_foreign_key_sequence;
Line: 4182

p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE))
then
l_error := TRUE;
Line: 4325

p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
l_error := TRUE;
Line: 4336

p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
l_error := TRUE;
Line: 4423

select  database_object_name
from    AK_UNIQUE_KEYS
where   UNIQUE_KEY_NAME = p_unique_key_name;
Line: 4427

select  1
from    AK_UNIQUE_KEY_COLUMNS
where   UNIQUE_KEY_NAME = p_unique_key_name
and     UNIQUE_KEY_SEQUENCE = p_unique_key_sequence
and     ( (ATTRIBUTE_APPLICATION_ID <> p_attribute_application_id)
or        (ATTRIBUTE_CODE <> p_attribute_code) );
Line: 4523

p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE))
then
l_error := TRUE;
Line: 4602

select ATTRIBUTE_CODE, ATTRIBUTE_APPLICATION_ID
from  AK_FOREIGN_KEY_COLUMNS
where FOREIGN_KEY_NAME = p_foreign_key_name
and   FOREIGN_KEY_SEQUENCE = p_foreign_key_sequence;
Line: 4630

AK_KEY_PVT.DELETE_FOREIGN_KEY_COLUMN (
p_validation_level => p_validation_level,
p_api_version_number => 1.0,
p_msg_count => l_msg_count,
p_msg_data => l_msg_data,
p_return_status => l_return_status,
p_foreign_key_name => p_foreign_key_name,
p_attribute_application_id => l_attribute_application_id,
p_attribute_code => l_attribute_code,
p_delete_cascade => 'Y'
);
Line: 4685

procedure DELETE_RELATED_FOREIGN_KEY_COL (
p_validation_level         IN      NUMBER := FND_API.G_VALID_LEVEL_FULL,
p_api_version_number       IN      NUMBER,
p_msg_count                OUT NOCOPY     NUMBER,
p_msg_data                 OUT NOCOPY     VARCHAR2,
p_return_status            OUT NOCOPY     VARCHAR2,
p_foreign_key_name         IN      VARCHAR2
) is

cursor l_get_columns_csr is
select ATTRIBUTE_APPLICATION_ID, ATTRIBUTE_CODE
from   AK_FOREIGN_KEY_COLUMNS
where  FOREIGN_KEY_NAME = p_foreign_key_name;
Line: 4699

l_api_name                 CONSTANT varchar2(30):= 'Delete_Related_Foreign_Key_Col';
Line: 4708

savepoint start_delete_rel_foreign_col;
Line: 4711

AK_KEY_PVT.DELETE_FOREIGN_KEY_COLUMN (
p_validation_level => p_validation_level,
p_api_version_number => 1.0,
p_msg_count => l_msg_count,
p_msg_data => l_msg_data,
p_return_status => l_return_status,
p_foreign_key_name => p_foreign_key_name,
p_attribute_application_id => csr_rec.attribute_application_id,
p_attribute_code => csr_rec.attribute_code,
p_delete_cascade => 'Y'
);
Line: 4735

FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_NOT_DELETED');
Line: 4742

rollback to start_delete_rel_foreign_col;
Line: 4749

rollback to start_delete_rel_foreign_col;
Line: 4756

end DELETE_RELATED_FOREIGN_KEY_COL;
Line: 4778

procedure DELETE_RELATED_UNIQUE_KEY_COL (
p_validation_level         IN      NUMBER := FND_API.G_VALID_LEVEL_FULL,
p_api_version_number       IN      NUMBER,
p_msg_count                OUT NOCOPY     NUMBER,
p_msg_data                 OUT NOCOPY     VARCHAR2,
p_return_status            OUT NOCOPY     VARCHAR2,
p_unique_key_name          IN      VARCHAR2
) is

cursor l_get_columns_csr is
select ATTRIBUTE_APPLICATION_ID, ATTRIBUTE_CODE
from   AK_UNIQUE_KEY_COLUMNS
where  UNIQUE_KEY_NAME = p_unique_key_name;
Line: 4792

l_api_name                 CONSTANT varchar2(30):= 'Delete_Related_Unique_Key_Col';
Line: 4800

savepoint start_delete_rel_unique_col;
Line: 4807

AK_KEY_PVT.DELETE_UNIQUE_KEY_COLUMN (
p_validation_level => p_validation_level,
p_api_version_number => 1.0,
p_msg_count => l_msg_count,
p_msg_data => l_msg_data,
p_return_status => l_return_status,
p_unique_key_name => p_unique_key_name,
p_attribute_application_id => csr_rec.attribute_application_id,
p_attribute_code => csr_rec.attribute_code,
p_delete_cascade => 'N',
p_override => 'Y'
);
Line: 4833

FND_MESSAGE.SET_NAME('AK','AK_UK_COLUMN_NOT_DELETED');
Line: 4841

rollback to start_delete_rel_unique_col;
Line: 4847

rollback to start_delete_rel_unique_col;
Line: 4854

end DELETE_RELATED_UNIQUE_KEY_COL;