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

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

Line: 44


select 1
from  AK_FLOWS
where flow_application_id = p_flow_application_id
and   flow_code = p_flow_code;

Line: 115


select 1
from  AK_FLOW_PAGES
where flow_application_id = p_flow_application_id
and   flow_code = p_flow_code
and   page_application_id = p_page_application_id
and   page_code = p_page_code;

Line: 190


select 1
from  AK_FLOW_PAGE_REGIONS
where flow_application_id = p_flow_application_id
and   flow_code = p_flow_code
and   page_application_id = p_page_application_id
and   page_code = p_page_code
and   region_application_id = p_region_application_id
and   region_code = p_region_code;

Line: 269


select 1
from  AK_FLOW_PAGE_REGION_ITEMS
where flow_application_id = p_flow_application_id
and   flow_code = p_flow_code
and   page_application_id = p_page_application_id
and   page_code = p_page_code
and   region_application_id = p_region_application_id
and   region_code = p_region_code
and   attribute_application_id = p_attribute_application_id
and   attribute_code = p_attribute_code;

Line: 353


select 1
from  AK_FLOW_REGION_RELATIONS
where flow_application_id = p_flow_application_id
and   flow_code = p_flow_code
and   foreign_key_name = p_foreign_key_name
and   from_page_appl_id = p_from_page_appl_id
and   from_page_code = p_from_page_code
and   from_region_appl_id = p_from_region_appl_id
and   from_region_code = p_from_region_code
and   to_page_appl_id = p_to_page_appl_id
and   to_page_code = p_to_page_code
and   to_region_appl_id = p_to_region_appl_id
and   to_region_code = p_to_region_code;

Line: 457


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: 471


l_last_update_date     date;

Line: 472


l_last_update_login    number;

Line: 473


l_last_updated_by      number;

Line: 634


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

Line: 638


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

Line: 642


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

Line: 652


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: 665


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

Line: 668


insert into AK_FLOWS (
FLOW_APPLICATION_ID,
FLOW_CODE,
PRIMARY_PAGE_APPL_ID,
PRIMARY_PAGE_CODE,
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_flow_application_id,
p_flow_code,
l_primary_page_appl_id,
l_primary_page_code,
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: 729


FND_MESSAGE.SET_NAME('AK','AK_INSERT_FLOW_FAILED');

Line: 735


insert into AK_FLOWS_TL (
FLOW_APPLICATION_ID,
FLOW_CODE,
LANGUAGE,
NAME,
DESCRIPTION,
SOURCE_LANG,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN
) select
p_flow_application_id,
p_flow_code,
L.LANGUAGE_CODE,
p_name,
l_description,
decode(L.LANGUAGE_CODE, l_lang, L.LANGUAGE_CODE, l_lang),
l_created_by,
l_creation_date,
l_last_updated_by,
l_last_update_date,
l_last_update_login
from FND_LANGUAGES L
where L.INSTALLED_FLAG in ('I', 'B')
and not exists
(select NULL
from AK_FLOWS_TL T
where T.FLOW_APPLICATION_ID = p_flow_application_id
and T.FLOW_CODE = p_flow_code
and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 884


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: 900


l_last_update_date     date;

Line: 901


l_last_update_login    number;

Line: 902


l_last_updated_by      number;

Line: 1067


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

Line: 1071


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

Line: 1075


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

Line: 1085


  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: 1098


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

Line: 1101


insert into AK_FLOW_PAGES (
FLOW_APPLICATION_ID,
FLOW_CODE,
PAGE_APPLICATION_ID,
PAGE_CODE,
PRIMARY_REGION_APPL_ID,
PRIMARY_REGION_CODE,
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_flow_application_id,
p_flow_code,
p_page_application_id,
p_page_code,
l_primary_region_appl_id,
l_primary_region_code,
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: 1168


FND_MESSAGE.SET_NAME('AK','AK_INSERT_FLOW_PAGE_FAILED');

Line: 1174


insert into AK_FLOW_PAGES_TL (
FLOW_APPLICATION_ID,
FLOW_CODE,
PAGE_APPLICATION_ID,
PAGE_CODE,
LANGUAGE,
NAME,
DESCRIPTION,
SOURCE_LANG,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN
) select
p_flow_application_id,
p_flow_code,
p_page_application_id,
p_page_code,
L.LANGUAGE_CODE,
p_name,
l_description,
decode(L.NLS_LANGUAGE, l_lang, L.NLS_LANGUAGE, l_lang),
l_created_by,
l_creation_date,
l_last_updated_by,
l_last_update_date,
l_last_update_login
from FND_LANGUAGES L
where L.INSTALLED_FLAG in ('I', 'B')
and not exists
(select NULL
from AK_FLOW_PAGES_TL T
where T.FLOW_APPLICATION_ID = p_flow_application_id
and T.FLOW_CODE = p_flow_code
and T.PAGE_APPLICATION_ID = p_page_application_id
and T.PAGE_CODE = p_page_code
and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 1221


AK_FLOW_PVT.UPDATE_FLOW (
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_flow_application_id => p_flow_application_id,
p_flow_code => p_flow_code,
p_primary_page_appl_id => p_page_application_id,
p_primary_page_code => p_page_code,
p_attribute_category => l_attribute_category,
p_attribute1 => l_attribute1,
p_attribute2 => l_attribute2,
p_attribute3 => l_attribute3,
p_attribute4 => l_attribute4,
p_attribute5 => l_attribute5,
p_attribute6 => l_attribute6,
p_attribute7 => l_attribute7,
p_attribute8 => l_attribute8,
p_attribute9 => l_attribute9,
p_attribute10 => l_attribute10,
p_attribute11 => l_attribute11,
p_attribute12 => l_attribute12,
p_attribute13 => l_attribute13,
p_attribute14 => l_attribute14,
p_attribute15 => l_attribute15,
p_created_by => l_created_by,
p_creation_date => l_creation_date,
p_last_updated_by => l_last_updated_by,
p_last_update_date => l_last_update_date,
p_last_update_login => l_last_update_login,
p_pass => p_pass,
p_copy_redo_flag => p_copy_redo_flag
);

Line: 1394


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: 1411


l_last_update_date     date;

Line: 1412


l_last_update_login    number;

Line: 1413


l_last_updated_by      number;

Line: 1613


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

Line: 1617


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

Line: 1621


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

Line: 1631


  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: 1644


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

Line: 1647


insert into AK_FLOW_PAGE_REGIONS (
FLOW_APPLICATION_ID,
FLOW_CODE,
PAGE_APPLICATION_ID,
PAGE_CODE,
REGION_APPLICATION_ID,
REGION_CODE,
DISPLAY_SEQUENCE,
REGION_STYLE,
NUM_COLUMNS,
ICX_CUSTOM_CALL,
PARENT_REGION_APPLICATION_ID,
PARENT_REGION_CODE,
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_flow_application_id,
p_flow_code,
p_page_application_id,
p_page_code,
p_region_application_id,
p_region_code,
l_display_sequence,
p_region_style,
l_num_columns,
l_icx_custom_call,
l_parent_region_appl_id,
l_parent_region_code,
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: 1725


AK_FLOW_PVT.UPDATE_PAGE (
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_flow_application_id => p_flow_application_id,
p_flow_code => p_flow_code,
p_page_application_id => p_page_application_id,
p_page_code => p_page_code,
p_primary_region_appl_id => p_region_application_id,
p_primary_region_code => p_region_code,
p_attribute1 => l_attribute1,
p_attribute2 => l_attribute2,
p_attribute3 => l_attribute3,
p_attribute4 => l_attribute4,
p_attribute5 => l_attribute5,
p_attribute6 => l_attribute6,
p_attribute7 => l_attribute7,
p_attribute8 => l_attribute8,
p_attribute9 => l_attribute9,
p_attribute10 => l_attribute10,
p_attribute11 => l_attribute11,
p_attribute12 => l_attribute12,
p_attribute13 => l_attribute13,
p_attribute14 => l_attribute14,
p_attribute15 => l_attribute15,
p_created_by => l_created_by,
p_creation_date => l_creation_date,
p_last_updated_by => l_last_updated_by,
p_last_update_date => l_last_update_date,
p_last_update_login => l_last_update_login,
p_pass => p_pass,
p_copy_redo_flag => p_copy_redo_flag
);

Line: 1798


p_last_updated_by => l_last_updated_by,
p_last_update_date => l_last_update_date,
p_last_update_login => l_last_update_login,
p_pass => p_pass,
p_copy_redo_flag => p_copy_redo_flag
);

Line: 1935


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: 1950


l_last_update_date     date;

Line: 1951


l_last_update_login    number;

Line: 1952


l_last_updated_by      number;

Line: 2131


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

Line: 2135


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

Line: 2139


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

Line: 2149


  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: 2162


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

Line: 2165


insert into AK_FLOW_PAGE_REGION_ITEMS (
FLOW_APPLICATION_ID,
FLOW_CODE,
PAGE_APPLICATION_ID,
PAGE_CODE,
REGION_APPLICATION_ID,
REGION_CODE,
ATTRIBUTE_APPLICATION_ID,
ATTRIBUTE_CODE,
TO_PAGE_APPL_ID,
TO_PAGE_CODE,
TO_URL_ATTRIBUTE_APPL_ID,
TO_URL_ATTRIBUTE_CODE,
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_flow_application_id,
p_flow_code,
p_page_application_id,
p_page_code,
p_region_application_id,
p_region_code,
p_attribute_application_id,
p_attribute_code,
l_to_page_appl_id,
l_to_page_code,
l_to_url_attribute_appl_id,
l_to_url_attribute_code,
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: 2367


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: 2379


l_last_update_date   date;

Line: 2380


l_last_update_login  number;

Line: 2381


l_last_updated_by    number;

Line: 2542


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

Line: 2546


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

Line: 2550


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

Line: 2560


  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: 2573


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

Line: 2576


insert into AK_FLOW_REGION_RELATIONS (
FLOW_APPLICATION_ID,
FLOW_CODE,
FOREIGN_KEY_NAME,
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,
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_flow_application_id,
p_flow_code,
p_foreign_key_name,
p_from_page_appl_id,
p_from_page_code,
p_from_region_appl_id,
p_from_region_code,
p_to_page_appl_id,
p_to_page_code,
p_to_region_appl_id,
p_to_region_code,
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: 2751


procedure DELETE_FLOW (
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_flow_application_id      IN      NUMBER,
p_flow_code                IN      VARCHAR2,
p_delete_cascade           IN      VARCHAR2
) is
cursor l_get_pages_csr is
select PAGE_APPLICATION_ID, PAGE_CODE
from   AK_FLOW_PAGES
where  flow_application_id = p_flow_application_id
and    flow_code = p_flow_code;

Line: 2768


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

Line: 2788


savepoint start_delete_flow;

Line: 2805


if (p_delete_cascade = 'N') then
--
-- If we are not deleting any referencing records, we cannot
-- delete the flow if it is being referenced in any of
-- following tables.
--
-- AK_FLOW_PAGES
--
open l_get_pages_csr;

Line: 2834


AK_FLOW_PVT.DELETE_PAGE (
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_flow_application_id => p_flow_application_id,
p_flow_code => p_flow_code,
p_page_application_id => l_page_application_id,
p_page_code => l_page_code,
p_delete_cascade => p_delete_cascade
);

Line: 2859


delete from ak_flows
where  flow_application_id = p_flow_application_id
and    flow_code = p_flow_code;

Line: 2871


delete from ak_flows_tl
where  flow_application_id = p_flow_application_id
and    flow_code = p_flow_code;

Line: 2887


FND_MESSAGE.SET_NAME('AK','AK_FLOW_DELETED');

Line: 2902


FND_MESSAGE.SET_NAME('AK','AK_FLOW_NOT_DELETED');

Line: 2908


rollback to start_delete_flow;

Line: 2914


rollback to start_delete_flow;

Line: 2921


end DELETE_FLOW;

Line: 2951


procedure DELETE_PAGE (
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_flow_application_id      IN      NUMBER,
p_flow_code                IN      VARCHAR2,
p_page_application_id      IN      NUMBER,
p_page_code                IN      VARCHAR2,
p_delete_cascade           IN      VARCHAR2
) is
cursor l_get_page_regions_csr is
select REGION_APPLICATION_ID, REGION_CODE
from   AK_FLOW_PAGE_REGIONS
where  flow_application_id = p_flow_application_id
and    flow_code = p_flow_code
and    page_application_id = p_page_application_id
and    page_code = p_page_code;

Line: 2972


select 1
from   AK_FLOWS
where  flow_application_id = p_flow_application_id
and    flow_code = p_flow_code
and    primary_page_appl_id = p_page_application_id
and    primary_page_code = p_page_code;

Line: 2979


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

Line: 3002


savepoint start_delete_page;

Line: 3021


if (p_delete_cascade = 'N') then
--
-- If we are not deleting any referencing records, we cannot
-- delete the flow page if it is being referenced in any of
-- following tables.
--
-- AK_FLOW_PAGE_REGIONS
--
open l_get_page_regions_csr;

Line: 3064


AK_FLOW_PVT.DELETE_PAGE_REGION (
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_flow_application_id => p_flow_application_id,
p_flow_code => p_flow_code,
p_page_application_id => p_page_application_id,
p_page_code => p_page_code,
p_region_application_id => l_region_application_id,
p_region_code => l_region_code,
p_delete_cascade => p_delete_cascade
);

Line: 3093


AK_FLOW_PVT.UPDATE_FLOW (
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_flow_application_id => p_flow_application_id,
p_flow_code => p_flow_code,
p_primary_page_code => G_NO_PRIMARY_PAGE_CODE,
p_pass => l_pass,
p_copy_redo_flag => l_copy_redo_flag
);

Line: 3128


delete from ak_flow_pages
where  flow_application_id = p_flow_application_id
and    flow_code = p_flow_code
and    page_application_id = p_page_application_id
and    page_code = p_page_code;

Line: 3142


delete from ak_flow_pages_tl
where  flow_application_id = p_flow_application_id
and    flow_code = p_flow_code
and    page_application_id = p_page_application_id
and    page_code = p_page_code;

Line: 3160


FND_MESSAGE.SET_NAME('AK','AK_FLOW_PAGE_DELETED');

Line: 3177


FND_MESSAGE.SET_NAME('AK','AK_FLOW_PAGE_NOT_DELETED');

Line: 3185


rollback to start_delete_page;

Line: 3191


rollback to start_delete_page;

Line: 3198


end DELETE_PAGE;

Line: 3230


procedure DELETE_PAGE_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_flow_application_id      IN      NUMBER,
p_flow_code                IN      VARCHAR2,
p_page_application_id      IN      NUMBER,
p_page_code                IN      VARCHAR2,
p_region_application_id    IN      NUMBER,
p_region_code              IN      VARCHAR2,
p_delete_cascade           IN      VARCHAR2
) is
cursor l_get_items_csr is
select ATTRIBUTE_APPLICATION_ID, ATTRIBUTE_CODE
from   AK_FLOW_PAGE_REGION_ITEMS
where  flow_application_id = p_flow_application_id
and    flow_code = p_flow_code
and    page_application_id = p_page_application_id
and    page_code = p_page_code
and    region_application_id = p_region_application_id
and    region_code = p_region_code;

Line: 3255


select FOREIGN_KEY_NAME, TO_PAGE_APPL_ID, TO_PAGE_CODE,
TO_REGION_APPL_ID, TO_REGION_CODE
from   AK_FLOW_REGION_RELATIONS
where  flow_application_id = p_flow_application_id
and    flow_code = p_flow_code
and    from_page_appl_id = p_page_application_id
and    from_page_code = p_page_code
and    from_region_appl_id = p_region_application_id
and    from_region_code = p_region_code;

Line: 3265


select FOREIGN_KEY_NAME, FROM_PAGE_APPL_ID, FROM_PAGE_CODE,
FROM_REGION_APPL_ID, FROM_REGION_CODE
from   AK_FLOW_REGION_RELATIONS
where  flow_application_id = p_flow_application_id
and    flow_code = p_flow_code
and    to_page_appl_id = p_page_application_id
and    to_page_code = p_page_code
and    to_region_appl_id = p_region_application_id
and    to_region_code = p_region_code;

Line: 3275


select 1
from   AK_FLOW_PAGES
where  flow_application_id = p_flow_application_id
and    flow_code = p_flow_code
and    page_application_id = p_page_application_id
and    page_code = p_page_code
and    primary_region_appl_id = p_region_application_id
and    primary_region_code = p_region_code;

Line: 3284


select region_application_id, region_code
from   AK_FLOW_PAGE_REGIONS
where  flow_application_id = p_flow_application_id
and    flow_code = p_flow_code
and    page_application_id = p_page_application_id
and    page_code = p_page_code
and    parent_region_application_id = p_region_application_id
and    parent_region_code = p_region_code;

Line: 3293


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

Line: 3321


savepoint start_delete_page_region;

Line: 3342


if (p_delete_cascade = 'N') then
--
-- If we are not deleting any referencing records, we cannot
-- delete the flow page region if it is being referenced in any of
-- following tables.
--
-- AK_FLOW_PAGE_REGION_ITEMS
--
open l_get_items_csr;

Line: 3429


AK_FLOW_PVT.DELETE_PAGE_REGION_ITEM (
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_flow_application_id => p_flow_application_id,
p_flow_code => p_flow_code,
p_page_application_id => p_page_application_id,
p_page_code => p_page_code,
p_region_application_id => p_region_application_id,
p_region_code => p_region_code,
p_attribute_application_id => l_attribute_appl_id,
p_attribute_code => l_attribute_code,
p_delete_cascade => p_delete_cascade
);

Line: 3460


AK_FLOW_PVT.DELETE_REGION_RELATION (
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_flow_application_id => p_flow_application_id,
p_flow_code => p_flow_code,
p_foreign_key_name => l_foreign_key_name,
p_from_page_appl_id => p_page_application_id,
p_from_page_code => p_page_code,
p_from_region_appl_id => p_region_application_id,
p_from_region_code => p_region_code,
p_to_page_appl_id => l_page_appl_id,
p_to_page_code => l_page_code,
p_to_region_appl_id => l_region_appl_id,
p_to_region_code => l_region_code,
p_delete_cascade => p_delete_cascade
);

Line: 3494


AK_FLOW_PVT.DELETE_REGION_RELATION (
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_flow_application_id => p_flow_application_id,
p_flow_code => p_flow_code,
p_foreign_key_name => l_foreign_key_name,
p_from_page_appl_id => l_page_appl_id,
p_from_page_code => l_page_code,
p_from_region_appl_id => l_region_appl_id,
p_from_region_code => l_region_code,
p_to_page_appl_id => p_page_application_id,
p_to_page_code => p_page_code,
p_to_region_appl_id => p_region_application_id,
p_to_region_code => p_region_code,
p_delete_cascade => p_delete_cascade
);

Line: 3529


AK_FLOW_PVT.UPDATE_PAGE_REGION (
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_flow_application_id => p_flow_application_id,
p_flow_code => p_flow_code,
p_page_application_id => p_page_application_id,
p_page_code => p_page_code,
p_region_application_id => l_region_appl_id,
p_region_code => l_region_code,
p_parent_region_application_id => null,
p_parent_region_code => null,
p_pass => l_pass,
p_copy_redo_flag => l_copy_redo_flag
);

Line: 3561


AK_FLOW_PVT.UPDATE_PAGE (
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_flow_application_id => p_flow_application_id,
p_flow_code => p_flow_code,
p_page_application_id => p_page_application_id,
p_page_code => p_page_code,
p_primary_region_code => G_NO_PRIMARY_REGION_CODE,
p_pass => l_pass,
p_copy_redo_flag => l_copy_redo_flag
);

Line: 3600


delete from ak_flow_page_regions
where  flow_application_id = p_flow_application_id
and    flow_code = p_flow_code
and    page_application_id = p_page_application_id
and    page_code = p_page_code
and    region_application_id = p_region_application_id
and    region_code = p_region_code;

Line: 3620


FND_MESSAGE.SET_NAME('AK','AK_PAGE_REGION_DELETED');

Line: 3639


FND_MESSAGE.SET_NAME('AK','AK_PG_REGION_NOT_DELETED');

Line: 3649


rollback to start_delete_page_region;

Line: 3655


rollback to start_delete_page_region;

Line: 3662


end DELETE_PAGE_REGION;

Line: 3696


procedure DELETE_PAGE_REGION_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_flow_application_id      IN      NUMBER,
p_flow_code                IN      VARCHAR2,
p_page_application_id      IN      NUMBER,
p_page_code                IN      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
) is
l_api_version_number    CONSTANT number := 1.0;

Line: 3714


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

Line: 3730


savepoint start_delete_region_item;

Line: 3753


if (p_delete_cascade = 'N') then
--
-- If we are not deleting any referencing records, we cannot
-- delete the page region item if it is being referenced in any of
-- following tables.
--
-- none
--
null;

Line: 3775


delete from ak_flow_page_region_items
where  flow_application_id = p_flow_application_id
and    flow_code = p_flow_code
and    page_application_id = p_page_application_id
and    page_code = p_page_code
and    region_application_id = p_region_application_id
and    region_code = p_region_code
and    attribute_application_id = p_attribute_application_id
and    attribute_code = p_attribute_code;

Line: 3797


FND_MESSAGE.SET_NAME('AK','AK_PG_REG_ITEM_DELETED');

Line: 3818


FND_MESSAGE.SET_NAME('AK','AK_PG_REG_ITEM_NOT_DELETED');

Line: 3830


rollback to start_delete_region_item;

Line: 3836


rollback to start_delete_region_item;

Line: 3843


end DELETE_PAGE_REGION_ITEM;

Line: 3880


procedure DELETE_REGION_RELATION (
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_flow_application_id      IN      NUMBER,
p_flow_code                IN      VARCHAR2,
p_foreign_key_name         IN      VARCHAR2,
p_from_page_appl_id        IN      NUMBER,
p_from_page_code           IN      VARCHAR2,
p_from_region_appl_id      IN      NUMBER,
p_from_region_code         IN      VARCHAR2,
p_to_page_appl_id          IN      NUMBER,
p_to_page_code             IN      VARCHAR2,
p_to_region_appl_id        IN      NUMBER,
p_to_region_code           IN      VARCHAR2,
p_delete_cascade           IN      VARCHAR2
) is
cursor l_get_items_csr is
select ATTRIBUTE_APPLICATION_ID, ATTRIBUTE_CODE
from   AK_FLOW_PAGE_REGION_ITEMS
where  flow_application_id = p_flow_application_id
and    flow_code = p_flow_code
and    page_application_id = p_from_page_appl_id
and    page_code = p_from_page_code
and    region_application_id = p_from_region_appl_id
and    region_code = p_from_region_code
and    to_page_appl_id = p_to_page_appl_id
and    to_page_code = p_to_page_code;

Line: 3912


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

Line: 3932


savepoint start_delete_relation;

Line: 3958


if (p_delete_cascade = 'N') then
--
-- If we are not deleting any referencing records, we cannot
-- delete the region relation if it is being referenced in any of
-- following tables.
--
-- AK_FLOW_PAGE_REGION_ITEMS
--
open l_get_items_csr;

Line: 3987


AK_FLOW_PVT.DELETE_PAGE_REGION_ITEM (
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_flow_application_id => p_flow_application_id,
p_flow_code => p_flow_code,
p_page_application_id => p_from_page_appl_id,
p_page_code => p_from_page_code,
p_region_application_id => p_from_region_appl_id,
p_region_code => p_from_region_code,
p_attribute_application_id => l_attribute_application_id,
p_attribute_code => l_attribute_code,
p_delete_cascade => p_delete_cascade
);

Line: 4016


delete from ak_flow_region_relations
where  flow_application_id = p_flow_application_id
and    flow_code = p_flow_code
and    foreign_key_name = p_foreign_key_name
and    from_page_appl_id = p_from_page_appl_id
and    from_page_code = p_from_page_code
and    from_region_appl_id = p_from_region_appl_id
and    from_region_code = p_from_region_code
and    to_page_appl_id = p_to_page_appl_id
and    to_page_code = p_to_page_code
and    to_region_appl_id = p_to_region_appl_id
and    to_region_code = p_to_region_code;

Line: 4041


FND_MESSAGE.SET_NAME('AK','AK_RELATION_DELETED');

Line: 4065


FND_MESSAGE.SET_NAME('AK','AK_RELATION_NOT_DELETED');

Line: 4080


rollback to start_delete_relation;

Line: 4086


rollback to start_delete_relation;

Line: 4093


end DELETE_REGION_RELATION;

Line: 4118


procedure UPDATE_FLOW (
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_flow_application_id      IN      NUMBER,
p_flow_code                IN      VARCHAR2,
p_primary_page_appl_id     IN      NUMBER := FND_API.G_MISS_NUM,
p_primary_page_code        IN      VARCHAR2 := FND_API.G_MISS_CHAR,
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_name                     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_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_FLOWS
where FLOW_APPLICATION_ID = p_flow_application_id
and   FLOW_CODE = p_flow_code
for   update of primary_page_appl_id;

Line: 4163


select *
from  AK_FLOWS_TL
where FLOW_APPLICATION_ID = p_flow_application_id
and   FLOW_CODE = p_flow_code
and   LANGUAGE = lang_parm
for update of name;

Line: 4170


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

Line: 4177


l_last_update_date       date;

Line: 4178


l_last_update_login      number;

Line: 4179


l_last_updated_by        number;

Line: 4196


savepoint start_update_flow;

Line: 4198


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

Line: 4251


p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,
p_pass => p_pass
) then
-- Do not raise an error if it's the first pass
if (p_pass = 1) then
p_copy_redo_flag := TRUE;

Line: 4359


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

Line: 4362


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

Line: 4365


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

Line: 4370


  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_flows_rec.last_updated_by,
       p_last_update_date => l_last_update_date,
       p_db_last_update_date => l_flows_rec.last_update_date,
       p_last_update_login => l_last_update_login,
       p_create_or_update => 'UPDATE') then

update AK_FLOWS set
PRIMARY_PAGE_APPL_ID = l_flows_rec.primary_page_appl_id,
PRIMARY_PAGE_CODE = l_flows_rec.primary_page_code,
ATTRIBUTE_CATEGORY = l_flows_rec.attribute_category,
ATTRIBUTE1 = l_flows_rec.attribute1,
ATTRIBUTE2 = l_flows_rec.attribute2,
ATTRIBUTE3 = l_flows_rec.attribute3,
ATTRIBUTE4 = l_flows_rec.attribute4,
ATTRIBUTE5 = l_flows_rec.attribute5,
ATTRIBUTE6 = l_flows_rec.attribute6,
ATTRIBUTE7 = l_flows_rec.attribute7,
ATTRIBUTE8 = l_flows_rec.attribute8,
ATTRIBUTE9 = l_flows_rec.attribute9,
ATTRIBUTE10 = l_flows_rec.attribute10,
ATTRIBUTE11 = l_flows_rec.attribute11,
ATTRIBUTE12 = l_flows_rec.attribute12,
ATTRIBUTE13 = l_flows_rec.attribute13,
ATTRIBUTE14 = l_flows_rec.attribute14,
ATTRIBUTE15 = l_flows_rec.attribute15,
LAST_UPDATE_DATE = l_last_update_date,
LAST_UPDATED_BY = l_last_updated_by,
LAST_UPDATE_LOGIN = l_last_update_login
where FLOW_APPLICATION_ID = p_flow_application_id
and   FLOW_CODE = p_flow_code;

Line: 4407


FND_MESSAGE.SET_NAME('AK','AK_FLOW_UPDATE_FAILED');

Line: 4413


update AK_FLOWS_TL set
NAME = l_flows_tl_rec.name,
DESCRIPTION = l_flows_tl_rec.description,
LAST_UPDATED_BY = l_last_updated_by,
LAST_UPDATE_DATE = l_last_update_date,
LAST_UPDATE_LOGIN = l_last_update_login,
SOURCE_LANG = l_lang
where FLOW_APPLICATION_ID = p_flow_application_id
and   FLOW_CODE = p_flow_code
and   l_lang in (LANGUAGE, SOURCE_LANG);

Line: 4425


FND_MESSAGE.SET_NAME('AK','AK_FLOW_UPDATE_FAILED');

Line: 4435


FND_MESSAGE.SET_NAME('AK','AK_FLOW_UPDATED');

Line: 4456


rollback to start_update_flow;

Line: 4463


FND_MESSAGE.SET_NAME('AK','AK_FLOW_NOT_UPDATED');

Line: 4469


rollback to start_update_flow;

Line: 4475


rollback to start_update_flow;

Line: 4482


end UPDATE_FLOW;

Line: 4510


procedure UPDATE_PAGE (
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_flow_application_id      IN      NUMBER,
p_flow_code                IN      VARCHAR2,
p_page_application_id      IN      NUMBER,
p_page_code                IN      VARCHAR2,
p_primary_region_appl_id   IN      NUMBER := FND_API.G_MISS_NUM,
p_primary_region_code      IN      VARCHAR2 := FND_API.G_MISS_CHAR,
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_name                     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_description              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_set_primary_page         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_FLOW_PAGES
where FLOW_APPLICATION_ID = p_flow_application_id
and   FLOW_CODE = p_flow_code
and   page_application_id = p_page_application_id
and   page_code = p_page_code
for   update of primary_region_appl_id;

Line: 4560


select *
from  AK_FLOW_PAGES_TL
where FLOW_APPLICATION_ID = p_flow_application_id
and   FLOW_CODE = p_flow_code
and   page_application_id = p_page_application_id
and   page_code = p_page_code
and   LANGUAGE = lang_parm
for  update of name;

Line: 4569


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

Line: 4576


l_last_update_date       date;

Line: 4577


l_last_update_login      number;

Line: 4578


l_last_updated_by        number;

Line: 4597


savepoint start_update_page;

Line: 4599


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

Line: 4654


p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,
p_pass => p_pass
) then
-- Do not raise an error if it's the first pass
if (p_pass = 1) then
p_copy_redo_flag := TRUE;

Line: 4762


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

Line: 4765


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

Line: 4768


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

Line: 4772


  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_pages_rec.last_updated_by,
       p_last_update_date => l_last_update_date,
       p_db_last_update_date => l_pages_rec.last_update_date,
       p_last_update_login => l_last_update_login,
       p_create_or_update => 'UPDATE') then

update AK_FLOW_PAGES set
PRIMARY_REGION_APPL_ID = l_pages_rec.primary_region_appl_id,
PRIMARY_REGION_CODE = l_pages_rec.primary_region_code,
ATTRIBUTE_CATEGORY = l_pages_rec.attribute_category,
ATTRIBUTE1 = l_pages_rec.attribute1,
ATTRIBUTE2 = l_pages_rec.attribute2,
ATTRIBUTE3 = l_pages_rec.attribute3,
ATTRIBUTE4 = l_pages_rec.attribute4,
ATTRIBUTE5 = l_pages_rec.attribute5,
ATTRIBUTE6 = l_pages_rec.attribute6,
ATTRIBUTE7 = l_pages_rec.attribute7,
ATTRIBUTE8 = l_pages_rec.attribute8,
ATTRIBUTE9 = l_pages_rec.attribute9,
ATTRIBUTE10 = l_pages_rec.attribute10,
ATTRIBUTE11 = l_pages_rec.attribute11,
ATTRIBUTE12 = l_pages_rec.attribute12,
ATTRIBUTE13 = l_pages_rec.attribute13,
ATTRIBUTE14 = l_pages_rec.attribute14,
ATTRIBUTE15 = l_pages_rec.attribute15,
LAST_UPDATE_DATE = l_last_update_date,
LAST_UPDATED_BY = l_last_updated_by,
LAST_UPDATE_LOGIN = l_last_update_login
where FLOW_APPLICATION_ID = p_flow_application_id
and   FLOW_CODE = p_flow_code
and   PAGE_APPLICATION_ID = p_page_application_id
and   PAGE_CODE = p_page_code;

Line: 4811


FND_MESSAGE.SET_NAME('AK','AK_FLOW_PAGE_UPDATE_FAILED');

Line: 4817


update AK_FLOW_PAGES_TL set
NAME = l_pages_tl_rec.name,
DESCRIPTION = l_pages_tl_rec.description,
LAST_UPDATED_BY = l_last_updated_by,
LAST_UPDATE_DATE = l_last_update_date,
LAST_UPDATE_LOGIN = l_last_update_login,
SOURCE_LANG = l_lang
where FLOW_APPLICATION_ID = p_flow_application_id
and   FLOW_CODE = p_flow_code
and   PAGE_APPLICATION_ID = p_page_application_id
and   PAGE_CODE = p_page_code
and   l_lang in (LANGUAGE, SOURCE_LANG);

Line: 4831


FND_MESSAGE.SET_NAME('AK','AK_FLOW_PAGE_UPDATE_FAILED');

Line: 4845


AK_FLOW_PVT.UPDATE_FLOW (
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_flow_application_id => p_flow_application_id,
p_flow_code => p_flow_code,
p_primary_page_appl_id => p_page_application_id,
p_primary_page_code => p_page_code,
p_created_by => l_created_by,
p_creation_date => l_creation_date,
p_last_updated_by => l_last_updated_by,
p_last_update_date => l_last_update_date,
p_last_update_login => l_last_update_login,
p_pass => p_pass,
p_copy_redo_flag => p_copy_redo_flag);

Line: 4871


FND_MESSAGE.SET_NAME('AK','AK_FLOW_PAGE_UPDATED');

Line: 4896


rollback to start_update_page;

Line: 4903


FND_MESSAGE.SET_NAME('AK','AK_FLOW_PAGE_NOT_UPDATED');

Line: 4911


rollback to start_update_page;

Line: 4917


rollback to start_update_page;

Line: 4924


end UPDATE_PAGE;

Line: 4961


procedure UPDATE_PAGE_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_flow_application_id      IN      NUMBER,
p_flow_code                IN      VARCHAR2,
p_page_application_id      IN      NUMBER,
p_page_code                IN      VARCHAR2,
p_region_application_id    IN      NUMBER,
p_region_code              IN      VARCHAR2,
p_display_sequence         IN      NUMBER := FND_API.G_MISS_NUM,
p_region_style             IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_num_columns              IN      NUMBER := FND_API.G_MISS_NUM,
p_icx_custom_call          IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_parent_region_application_id IN  NUMBER := FND_API.G_MISS_NUM,
p_parent_region_code       IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_foreign_key_name         IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_set_primary_region       IN      VARCHAR2 := FND_API.G_MISS_CHAR,
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_FLOW_PAGE_REGIONS
where FLOW_APPLICATION_ID = p_flow_application_id
and   FLOW_CODE = p_flow_code
and   page_application_id = p_page_application_id
and   page_code = p_page_code
and   region_application_id = p_region_application_id
and   region_code = p_region_code
for   update of display_sequence;

Line: 5019


select foreign_key_name
from   AK_FLOW_REGION_RELATIONS
where  flow_application_id = p_flow_application_id
and    flow_code = p_flow_code
and    from_page_appl_id = p_page_application_id
and    from_page_code = p_page_code
and    from_region_appl_id = parent_region_appl_id_param
and    from_region_code = parent_region_code_param
and    to_page_appl_id = p_page_application_id
and    to_page_code = p_page_code
and    to_region_appl_id = p_region_application_id
and    to_region_code = p_region_code;

Line: 5032


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

Line: 5041


l_last_update_date       date;

Line: 5042


l_last_update_login      number;

Line: 5043


l_last_updated_by        number;

Line: 5062


savepoint start_update_page_region;

Line: 5064


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

Line: 5122


p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,
p_pass => p_pass
) then
-- Do not raise an error if it's the first pass
if (p_pass = 1) then
p_copy_redo_flag := TRUE;

Line: 5169


AK_FLOW_PVT.DELETE_REGION_RELATION (
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_flow_application_id => l_regions_rec.flow_application_id,
p_flow_code => l_regions_rec.flow_code,
p_foreign_key_name => l_foreign_key_name_old,
p_from_page_appl_id => l_regions_rec.page_application_id,
p_from_page_code => l_regions_rec.page_code,
p_from_region_appl_id => l_regions_rec.parent_region_application_id,
p_from_region_code => l_regions_rec.parent_region_code,
p_to_page_appl_id => l_regions_rec.page_application_id,
p_to_page_code => l_regions_rec.page_code,
p_to_region_appl_id => l_regions_rec.region_application_id,
p_to_region_code => l_regions_rec.region_code,
p_delete_cascade => 'Y'
);

Line: 5295


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

Line: 5298


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

Line: 5301


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

Line: 5305


  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_regions_rec.last_updated_by,
       p_last_update_date => l_last_update_date,
       p_db_last_update_date => l_regions_rec.last_update_date,
       p_last_update_login => l_last_update_login,
       p_create_or_update => 'UPDATE') then

--
-- Create a new intrapage relation if the foreign key name is changed,
-- or a different (non-null) parent region is specified.
--
if ( (p_foreign_key_name <> FND_API.G_MISS_CHAR) and
(p_foreign_key_name is not null) and
(p_foreign_key_name <> NVL(l_foreign_key_name_old, l_dummy) ) ) or
(l_parent_region_changed = 'Y') then
--
-- Create region relation only if it doesn't already exists,
-- and a parent region is given.
--
if NOT AK_FLOW_PVT.REGION_RELATION_EXISTS (
p_api_version_number => 1.0,
p_return_status => l_return_status,
p_flow_application_id => l_regions_rec.flow_application_id,
p_flow_code => l_regions_rec.flow_code,
p_foreign_key_name => p_foreign_key_name,
p_from_page_appl_id => l_regions_rec.page_application_id,
p_from_page_code => l_regions_rec.page_code,
p_from_region_appl_id => l_regions_rec.parent_region_application_id,
p_from_region_code => l_regions_rec.parent_region_code,
p_to_page_appl_id => l_regions_rec.page_application_id,
p_to_page_code => l_regions_rec.page_code,
p_to_region_appl_id => l_regions_rec.region_application_id,
p_to_region_code => l_regions_rec.region_code
) and
(l_regions_rec.parent_region_application_id is not null) and
(l_regions_rec.parent_region_code is not null) then
AK_FLOW_PVT.CREATE_REGION_RELATION (
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_flow_application_id => l_regions_rec.flow_application_id,
p_flow_code => l_regions_rec.flow_code,
p_foreign_key_name => p_foreign_key_name,
p_from_page_appl_id => l_regions_rec.page_application_id,
p_from_page_code => l_regions_rec.page_code,
p_from_region_appl_id => l_regions_rec.parent_region_application_id,
p_from_region_code => l_regions_rec.parent_region_code,
p_to_page_appl_id => l_regions_rec.page_application_id,
p_to_page_code => l_regions_rec.page_code,
p_to_region_appl_id => l_regions_rec.region_application_id,
p_to_region_code => l_regions_rec.region_code,
p_application_id => l_regions_rec.flow_application_id,
p_created_by => l_created_by,
p_creation_date => l_creation_date,
p_last_updated_by => l_last_updated_by,
p_last_update_date => l_last_update_date,
p_last_update_login => l_last_update_login,
p_pass => p_pass,
p_copy_redo_flag => p_copy_redo_flag
);

Line: 5382


update AK_FLOW_PAGE_REGIONS set
DISPLAY_SEQUENCE = l_regions_rec.display_sequence,
REGION_STYLE = l_regions_rec.region_style,
NUM_COLUMNS = l_regions_rec.num_columns,
PARENT_REGION_APPLICATION_ID =l_regions_rec.parent_region_application_id,
PARENT_REGION_CODE = l_regions_rec.parent_region_code,
ICX_CUSTOM_CALL = l_regions_rec.icx_custom_call,
ATTRIBUTE_CATEGORY = l_regions_rec.attribute_category,
ATTRIBUTE1 = l_regions_rec.attribute1,
ATTRIBUTE2 = l_regions_rec.attribute2,
ATTRIBUTE3 = l_regions_rec.attribute3,
ATTRIBUTE4 = l_regions_rec.attribute4,
ATTRIBUTE5 = l_regions_rec.attribute5,
ATTRIBUTE6 = l_regions_rec.attribute6,
ATTRIBUTE7 = l_regions_rec.attribute7,
ATTRIBUTE8 = l_regions_rec.attribute8,
ATTRIBUTE9 = l_regions_rec.attribute9,
ATTRIBUTE10 = l_regions_rec.attribute10,
ATTRIBUTE11 = l_regions_rec.attribute11,
ATTRIBUTE12 = l_regions_rec.attribute12,
ATTRIBUTE13 = l_regions_rec.attribute13,
ATTRIBUTE14 = l_regions_rec.attribute14,
ATTRIBUTE15 = l_regions_rec.attribute15,
LAST_UPDATE_DATE = l_last_update_date,
LAST_UPDATED_BY = l_last_updated_by,
LAST_UPDATE_LOGIN = l_last_update_login
where FLOW_APPLICATION_ID = p_flow_application_id
and   FLOW_CODE = p_flow_code
and   PAGE_APPLICATION_ID = p_page_application_id
and   PAGE_CODE = p_page_code
and   REGION_APPLICATION_ID = p_region_application_id
and   REGION_CODE = p_region_code;

Line: 5416


FND_MESSAGE.SET_NAME('AK','AK_PG_REGION_UPDATE_FAILED');

Line: 5431


AK_FLOW_PVT.UPDATE_PAGE (
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_flow_application_id => p_flow_application_id,
p_flow_code => p_flow_code,
p_page_application_id => p_page_application_id,
p_page_code => p_page_code,
p_primary_region_appl_id => p_region_application_id,
p_primary_region_code => p_region_code,
p_created_by => l_created_by,
p_creation_date => l_creation_date,
p_last_updated_by => l_last_updated_by,
p_last_update_date => l_last_update_date,
p_last_update_login => l_last_update_login,
p_pass => p_pass,
p_copy_redo_flag => p_copy_redo_flag
);

Line: 5460


FND_MESSAGE.SET_NAME('AK','AK_PAGE_REGION_UPDATED');

Line: 5489


rollback to start_update_page_region;

Line: 5496


FND_MESSAGE.SET_NAME('AK','AK_PG_REGION_NOT_UPDATED');

Line: 5506


rollback to start_update_page_region;

Line: 5512


rollback to start_update_page_region;

Line: 5519


end UPDATE_PAGE_REGION;

Line: 5545


procedure UPDATE_PAGE_REGION_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_flow_application_id      IN      NUMBER,
p_flow_code                IN      VARCHAR2,
p_page_application_id      IN      NUMBER,
p_page_code                IN      VARCHAR2,
p_region_application_id    IN      NUMBER,
p_region_code              IN      VARCHAR2,
p_attribute_application_id IN      NUMBER,
p_attribute_code           IN      VARCHAR2,
p_to_page_appl_id          IN      NUMBER := FND_API.G_MISS_NUM,
p_to_page_code             IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_to_url_attribute_appl_id IN      NUMBER := FND_API.G_MISS_NUM,
p_to_url_attribute_code    IN      VARCHAR2 := FND_API.G_MISS_CHAR,
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_FLOW_PAGE_REGION_ITEMS
where FLOW_APPLICATION_ID = p_flow_application_id
and   FLOW_CODE = p_flow_code
and   page_application_id = p_page_application_id
and   page_code = p_page_code
and   region_application_id = p_region_application_id
and   region_code = p_region_code
and   attribute_application_id = p_attribute_application_id
and   attribute_code = p_attribute_code
for   update of to_page_appl_id;

Line: 5602


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

Line: 5607


l_last_update_date       date;

Line: 5608


l_last_update_login      number;

Line: 5609


l_last_updated_by        number;

Line: 5627


savepoint start_update_item;

Line: 5629


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

Line: 5667


p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,
p_pass => p_pass
) then
-- Do not raise an error if it's the first pass
if (p_pass = 1) then
p_copy_redo_flag := TRUE;

Line: 5773


FND_MESSAGE.SET_NAME('AK','AK_NO_LINK_SELECTED');

Line: 5792


FND_MESSAGE.SET_NAME('AK','AK_TWO_LINK_SELECTED');

Line: 5804


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

Line: 5807


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

Line: 5810


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

Line: 5814


  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_items_rec.last_updated_by,
       p_last_update_date => l_last_update_date,
       p_db_last_update_date => l_items_rec.last_update_date,
       p_last_update_login => l_last_update_login,
       p_create_or_update => 'UPDATE') then

update AK_FLOW_PAGE_REGION_ITEMS set
TO_PAGE_APPL_ID = l_items_rec.to_page_appl_id,
TO_PAGE_CODE = l_items_rec.to_page_code,
TO_URL_ATTRIBUTE_APPL_ID = l_items_rec.to_url_attribute_appl_id,
TO_URL_ATTRIBUTE_CODE = l_items_rec.to_url_attribute_code,
ATTRIBUTE_CATEGORY = l_items_rec.attribute_category,
ATTRIBUTE1 = l_items_rec.attribute1,
ATTRIBUTE2 = l_items_rec.attribute2,
ATTRIBUTE3 = l_items_rec.attribute3,
ATTRIBUTE4 = l_items_rec.attribute4,
ATTRIBUTE5 = l_items_rec.attribute5,
ATTRIBUTE6 = l_items_rec.attribute6,
ATTRIBUTE7 = l_items_rec.attribute7,
ATTRIBUTE8 = l_items_rec.attribute8,
ATTRIBUTE9 = l_items_rec.attribute9,
ATTRIBUTE10 = l_items_rec.attribute10,
ATTRIBUTE11 = l_items_rec.attribute11,
ATTRIBUTE12 = l_items_rec.attribute12,
ATTRIBUTE13 = l_items_rec.attribute13,
ATTRIBUTE14 = l_items_rec.attribute14,
ATTRIBUTE15 = l_items_rec.attribute15,
LAST_UPDATE_DATE = l_last_update_date,
LAST_UPDATED_BY = l_last_updated_by,
LAST_UPDATE_LOGIN = l_last_update_login
where FLOW_APPLICATION_ID = p_flow_application_id
and   FLOW_CODE = p_flow_code
and   PAGE_APPLICATION_ID = p_page_application_id
and   PAGE_CODE = p_page_code
and   REGION_APPLICATION_ID = p_region_application_id
and   REGION_CODE = p_region_code
and   ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
and   ATTRIBUTE_CODE = p_attribute_code;

Line: 5859


FND_MESSAGE.SET_NAME('AK','AK_PG_REG_ITEM_UPDATE_FAILED');

Line: 5869


FND_MESSAGE.SET_NAME('AK','AK_PG_REG_ITEM_UPDATED');

Line: 5902


rollback to start_update_item;

Line: 5909


FND_MESSAGE.SET_NAME('AK','AK_PG_REG_ITEM_NOT_UPDATED');

Line: 5923


rollback to start_update_item;

Line: 5929


rollback to start_update_item;

Line: 5936


end UPDATE_PAGE_REGION_ITEM;

Line: 5962


procedure UPDATE_REGION_RELATION (
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_flow_application_id      IN      NUMBER,
p_flow_code                IN      VARCHAR2,
p_foreign_key_name         IN      VARCHAR2,
p_from_page_appl_id        IN      NUMBER,
p_from_page_code           IN      VARCHAR2,
p_from_region_appl_id      IN      NUMBER,
p_from_region_code         IN      VARCHAR2,
p_to_page_appl_id          IN      NUMBER,
p_to_page_code             IN      VARCHAR2,
p_to_region_appl_id        IN      NUMBER,
p_to_region_code           IN      VARCHAR2,
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_FLOW_REGION_RELATIONS
where  flow_application_id = p_flow_application_id
and    flow_code = p_flow_code
and    foreign_key_name = p_foreign_key_name
and    from_page_appl_id = p_from_page_appl_id
and    from_page_code = p_from_page_code
and    from_region_appl_id = p_from_region_appl_id
and    from_region_code = p_from_region_code
and    to_page_appl_id = p_to_page_appl_id
and    to_page_code = p_to_page_code
and    to_region_appl_id = p_to_region_appl_id
and    to_region_code = p_to_region_code
for    update of application_id;

Line: 6022


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

Line: 6027


l_last_update_date       date;

Line: 6028


l_last_update_login      number;

Line: 6029


l_last_updated_by        number;

Line: 6046


savepoint start_update_relation;

Line: 6048


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

Line: 6082


p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,
p_pass => p_pass
) then
-- Do not raise an error if it's the first pass
if (p_pass = 1) then
p_copy_redo_flag := TRUE;

Line: 6174


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

Line: 6177


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

Line: 6180


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

Line: 6184


  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_relations_rec.last_updated_by,
       p_last_update_date => l_last_update_date,
       p_db_last_update_date => l_relations_rec.last_update_date,
       p_last_update_login => l_last_update_login,
       p_create_or_update => 'UPDATE') then

update AK_FLOW_REGION_RELATIONS set
APPLICATION_ID = l_relations_rec.application_id,
ATTRIBUTE_CATEGORY = l_relations_rec.attribute_category,
ATTRIBUTE1 = l_relations_rec.attribute1,
ATTRIBUTE2 = l_relations_rec.attribute2,
ATTRIBUTE3 = l_relations_rec.attribute3,
ATTRIBUTE4 = l_relations_rec.attribute4,
ATTRIBUTE5 = l_relations_rec.attribute5,
ATTRIBUTE6 = l_relations_rec.attribute6,
ATTRIBUTE7 = l_relations_rec.attribute7,
ATTRIBUTE8 = l_relations_rec.attribute8,
ATTRIBUTE9 = l_relations_rec.attribute9,
ATTRIBUTE10 = l_relations_rec.attribute10,
ATTRIBUTE11 = l_relations_rec.attribute11,
ATTRIBUTE12 = l_relations_rec.attribute12,
ATTRIBUTE13 = l_relations_rec.attribute13,
ATTRIBUTE14 = l_relations_rec.attribute14,
ATTRIBUTE15 = l_relations_rec.attribute15,
LAST_UPDATE_DATE = l_last_update_date,
LAST_UPDATED_BY = l_last_updated_by,
LAST_UPDATE_LOGIN = l_last_update_login
where  flow_application_id = p_flow_application_id
and    flow_code = p_flow_code
and    foreign_key_name = p_foreign_key_name
and    from_page_appl_id = p_from_page_appl_id
and    from_page_code = p_from_page_code
and    from_region_appl_id = p_from_region_appl_id
and    from_region_code = p_from_region_code
and    to_page_appl_id = p_to_page_appl_id
and    to_page_code = p_to_page_code
and    to_region_appl_id = p_to_region_appl_id
and    to_region_code = p_to_region_code;

Line: 6240


FND_MESSAGE.SET_NAME('AK','AK_RELATION_UPDATED');

Line: 6280


rollback to start_update_relation;

Line: 6287


FND_MESSAGE.SET_NAME('AK','AK_RELATION_NOT_UPDATED');

Line: 6303


rollback to start_update_relation;

Line: 6309


rollback to start_update_relation;

Line: 6319


end UPDATE_REGION_RELATION;

Line: 6358


select *
from   ak_flow_page_regions
where  flow_code = flow_code_param
and    flow_application_id = flow_application_id_param
and    page_code = page_code_param
and    page_application_id = page_application_id_param
and    display_sequence = display_sequence_param;

Line: 6412


AK_FLOW_PVT.UPDATE_PAGE_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_flow_application_id => l_orig_fpr_rec.flow_application_id,
p_flow_code => l_orig_fpr_rec.flow_code,
p_page_application_id => l_orig_fpr_rec.page_application_id,
p_page_code => l_orig_fpr_rec.page_code,
p_region_application_id => l_orig_fpr_rec.region_application_id,
p_region_code => l_orig_fpr_rec.region_code,
p_display_sequence => l_new_display_sequence,
p_region_style => l_orig_fpr_rec.region_style,
p_num_columns => l_orig_fpr_rec.num_columns,
p_parent_region_application_id => l_orig_fpr_rec.parent_region_application_id,
p_parent_region_code => l_orig_fpr_rec.parent_region_code,
p_icx_custom_call => l_orig_fpr_rec.icx_custom_call,

p_pass => p_pass,
p_copy_redo_flag => p_copy_redo_flag);