The following lines contain the word 'select', 'insert', 'update' or 'delete':
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;
FND_LOAD_UTIL.OWNER_NAME(l_items_rec.last_updated_by) || '"';
l_databuffer_tbl(l_index) := ' LAST_UPDATE_DATE = "' ||
to_char(l_items_rec.last_update_date,
AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
l_databuffer_tbl(l_index) := ' LAST_UPDATE_LOGIN = "' ||
nvl(to_char(l_items_rec.last_update_login),'') || '"';
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;
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 = region_appl_id_param
and TO_REGION_CODE = region_code_param;
FND_LOAD_UTIL.OWNER_NAME(l_regions_rec.last_updated_by) ||'"';
l_databuffer_tbl(l_index) := ' LAST_UPDATE_DATE = "' ||
to_char(l_regions_rec.last_update_date,
AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
l_databuffer_tbl(l_index) := ' LAST_UPDATE_LOGIN = "' ||
nvl(to_char(l_regions_rec.last_update_login),'') || '"';
l_databuffer_tbl.delete;
l_databuffer_tbl.delete;
select *
from AK_FLOW_PAGES
where FLOW_APPLICATION_ID = p_flow_application_id
and FLOW_CODE = p_flow_code;
select *
from AK_FLOW_PAGES_TL
where FLOW_APPLICATION_ID = p_flow_application_id
and FLOW_CODE = p_flow_code
and PAGE_APPLICATION_ID = page_appl_id_param
and PAGE_CODE = page_code_param
and LANGUAGE = p_nls_language;
FND_LOAD_UTIL.OWNER_NAME(l_pages_rec.last_updated_by) || '"';
l_databuffer_tbl(l_index) := ' LAST_UPDATE_DATE = "' ||
to_char(l_pages_rec.last_update_date,
AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
l_databuffer_tbl(l_index) := ' LAST_UPDATE_LOGIN = "' ||
nvl(to_char(l_pages_rec.last_update_login),'') || '"';
l_databuffer_tbl.delete;
l_databuffer_tbl.delete;
select *
from AK_FLOW_REGION_RELATIONS
where FLOW_APPLICATION_ID = p_flow_application_id
and FLOW_CODE = p_flow_code
and ( (FROM_PAGE_APPL_ID <> TO_PAGE_APPL_ID) or
(FROM_PAGE_CODE <> TO_PAGE_CODE) );
FND_LOAD_UTIL.OWNER_NAME(l_relations_rec.last_updated_by) || '"';
l_databuffer_tbl(l_index) := ' LAST_UPDATE_DATE = "' ||
to_char(l_relations_rec.last_update_date,
AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
l_databuffer_tbl(l_index) := ' LAST_UPDATE_LOGIN = "' ||
nvl(to_char(l_relations_rec.last_update_login),'') || '"';
select *
from AK_FLOWS
where flow_application_id = p_flow_application_id
and flow_code = p_flow_code;
select *
from AK_FLOWS_TL
where flow_application_id = p_flow_application_id
and flow_code = p_flow_code
and LANGUAGE = p_nls_language;
FND_LOAD_UTIL.OWNER_NAME(l_flows_rec.last_updated_by) || '"';
l_databuffer_tbl(l_index) := ' LAST_UPDATE_DATE = "' ||
to_char(l_flows_rec.last_update_date,
AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
l_databuffer_tbl(l_index) := ' LAST_UPDATE_LOGIN = "' ||
nvl(to_char(l_flows_rec.last_update_login),'') || '"';
l_databuffer_tbl.delete;
select flow_application_id, flow_code
from AK_FLOWS
where FLOW_APPLICATION_ID = appl_id_parm;
select distinct REGION_APPLICATION_ID, REGION_CODE
from AK_FLOW_PAGE_REGIONS
where flow_application_id = flow_appl_id_param
and flow_code = flow_code_param;
FND_MESSAGE.SET_NAME('AK','AK_NO_SELECTION');
AK_REGION_PVT.INSERT_REGION_PK_TABLE (
p_return_status => l_return_status,
p_region_application_id => l_region_appl_id,
p_region_code => l_region_code,
p_region_pk_tbl => l_region_pk_tbl);
l_update1 DATE;
l_update2 DATE;
(l_token = 'LAST_UPDATED_BY') or
(l_token = 'OWNER') or
(l_token = 'LAST_UPDATE_DATE') or
(l_token = 'LAST_UPDATE_LOGIN') then
l_column := l_token;
elsif (l_column = 'LAST_UPDATED_BY') then
l_flow_rec.last_updated_by := to_number(l_token);
l_flow_rec.last_updated_by := FND_LOAD_UTIL.OWNER_ID(l_token);
elsif (l_column = 'LAST_UPDATE_DATE') then
l_flow_rec.last_update_date := to_date(l_token,
AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
elsif (l_column = 'LAST_UPDATE_LOGIN') then
l_flow_rec.last_update_login := to_number(l_token);
(l_token = 'LAST_UPDATED_BY') or
(l_token = 'OWNER') or
(l_token = 'LAST_UPDATE_DATE') or
(l_token = 'LAST_UPDATE_LOGIN') then
l_column := l_token;
elsif (l_column = 'LAST_UPDATED_BY') then
l_page_rec.last_updated_by := to_number(l_token);
l_page_rec.last_updated_by := FND_LOAD_UTIL.OWNER_ID(l_token);
elsif (l_column = 'LAST_UPDATE_DATE') then
l_page_rec.last_update_date := to_date(l_token,
AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
elsif (l_column = 'LAST_UPDATE_LOGIN') then
l_page_rec.last_update_login := to_number(l_token);
(l_token = 'LAST_UPDATED_BY') or
(l_token = 'OWNER') or
(l_token = 'LAST_UPDATE_DATE') or
(l_token = 'LAST_UPDATE_LOGIN') then
l_column := l_token;
elsif (l_column = 'LAST_UPDATED_BY') then
l_relation_rec.last_updated_by := to_number(l_token);
l_relation_rec.last_updated_by := FND_LOAD_UTIL.OWNER_ID(l_token);
elsif (l_column = 'LAST_UPDATE_DATE') then
l_relation_rec.last_update_date := to_date(l_token,
AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
elsif (l_column = 'LAST_UPDATE_LOGIN') then
l_relation_rec.last_update_login := to_number(l_token);
(l_token = 'LAST_UPDATED_BY') or
(l_token = 'OWNER') or
(l_token = 'LAST_UPDATE_DATE') or
(l_token = 'LAST_UPDATE_LOGIN') then
l_column := l_token;
elsif (l_column = 'LAST_UPDATED_BY') then
l_region_rec.last_updated_by := to_number(l_token);
l_region_rec.last_updated_by := FND_LOAD_UTIL.OWNER_ID(l_token);
elsif (l_column = 'LAST_UPDATE_DATE') then
l_region_rec.last_update_date := to_date(l_token,
AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
elsif (l_column = 'LAST_UPDATE_LOGIN') then
l_region_rec.last_update_login := to_number(l_token);
(l_token = 'LAST_UPDATED_BY') or
(l_token = 'OWNER') or
(l_token = 'LAST_UPDATE_DATE') or
(l_token = 'LAST_UPDATE_LOGIN') then
l_column := l_token;
elsif (l_column = 'LAST_UPDATED_BY') then
l_item_rec.last_updated_by := to_number(l_token);
l_item_rec.last_updated_by := FND_LOAD_UTIL.OWNER_ID(l_token);
elsif (l_column = 'LAST_UPDATE_DATE') then
l_item_rec.last_update_date := to_date(l_token,
AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
elsif (l_column = 'LAST_UPDATE_LOGIN') then
l_item_rec.last_update_login := to_number(l_token);
p_last_updated_by => l_flow_tbl(l_index).last_updated_by,
p_last_update_date => l_flow_tbl(l_index).last_update_date,
p_last_update_login => l_flow_tbl(l_index).last_update_login,
p_loader_timestamp => p_loader_timestamp,
p_pass => p_pass,
p_copy_redo_flag => l_copy_redo_flag
);
p_last_updated_by => l_page_tbl(l_index).last_updated_by,
p_last_update_date => l_page_tbl(l_index).last_update_date,
p_last_update_login => l_page_tbl(l_index).last_update_login,
p_loader_timestamp => p_loader_timestamp,
p_pass => p_pass,
p_copy_redo_flag => l_copy_redo_flag
);
-- update all records
if ( AK_UPLOAD_GRP.G_UPDATE_MODE ) then
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 =>
l_flow_tbl(l_index).flow_application_id,
p_flow_code => l_flow_tbl(l_index).flow_code,
p_name => l_flow_tbl(l_index).name,
p_description => l_flow_tbl(l_index).description,
p_primary_page_appl_id => l_flow_tbl(l_index).primary_page_appl_id,
p_primary_page_code => l_flow_tbl(l_index).primary_page_code,
p_attribute_category => l_flow_tbl(l_index).attribute_category,
p_attribute1 => l_flow_tbl(l_index).attribute1,
p_attribute2 => l_flow_tbl(l_index).attribute2,
p_attribute3 => l_flow_tbl(l_index).attribute3,
p_attribute4 => l_flow_tbl(l_index).attribute4,
p_attribute5 => l_flow_tbl(l_index).attribute5,
p_attribute6 => l_flow_tbl(l_index).attribute6,
p_attribute7 => l_flow_tbl(l_index).attribute7,
p_attribute8 => l_flow_tbl(l_index).attribute8,
p_attribute9 => l_flow_tbl(l_index).attribute9,
p_attribute10 => l_flow_tbl(l_index).attribute10,
p_attribute11 => l_flow_tbl(l_index).attribute11,
p_attribute12 => l_flow_tbl(l_index).attribute12,
p_attribute13 => l_flow_tbl(l_index).attribute13,
p_attribute14 => l_flow_tbl(l_index).attribute14,
p_attribute15 => l_flow_tbl(l_index).attribute15,
p_created_by => l_flow_tbl(l_index).created_by,
p_creation_date => l_flow_tbl(l_index).creation_date,
p_last_updated_by => l_flow_tbl(l_index).last_updated_by,
p_last_update_date => l_flow_tbl(l_index).last_update_date,
p_last_update_login => l_flow_tbl(l_index).last_update_login,
p_loader_timestamp => p_loader_timestamp,
p_pass => p_pass,
p_copy_redo_flag => l_copy_redo_flag
);
-- update flow records if primary page has been changed or
-- update non-customized data
elsif ( AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE AND (NOT AK_UPLOAD_GRP.G_UPDATE_MODE) ) then
select af.primary_page_code, af.primary_page_appl_id, af.last_updated_by,
aft.last_updated_by,
af.last_update_date, aft.last_update_date
into l_temp_key_code, l_temp_key_appl_id, l_user_id1, l_user_id2, l_update1, l_update2
from ak_flows af, ak_flows_tl aft
where af.flow_code = l_flow_tbl(l_index).flow_code
and af.flow_application_id = l_flow_tbl(l_index).flow_application_id
and af.flow_code = aft.flow_code
and af.flow_application_id = aft.flow_application_id
and aft.language = userenv('LANG');
if ((AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
p_loader_timestamp => p_loader_timestamp,
p_created_by => l_flow_tbl(l_index).created_by,
p_creation_date => l_flow_tbl(l_index).creation_date,
p_last_updated_by => l_flow_tbl(l_index).last_updated_by,
p_db_last_updated_by => l_user_id1,
p_last_update_date => l_flow_tbl(l_index).last_update_date,
p_db_last_update_date => l_update1,
p_last_update_login => l_flow_tbl(l_index).last_update_login,
p_create_or_update => 'UPDATE') and
AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
p_loader_timestamp => p_loader_timestamp,
p_created_by => l_flow_tbl(l_index).created_by,
p_creation_date => l_flow_tbl(l_index).creation_date,
p_last_updated_by => l_flow_tbl(l_index).last_updated_by,
p_db_last_updated_by => l_user_id2,
p_last_update_date => l_flow_tbl(l_index).last_update_date,
p_db_last_update_date => l_update2,
p_last_update_login => l_flow_tbl(l_index).last_update_login,
p_create_or_update => 'UPDATE'))
or
( l_temp_key_code <> l_flow_tbl(l_index).primary_page_code and
l_temp_key_appl_id <> l_flow_tbl(l_index).primary_page_appl_id ) ) then
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 =>
l_flow_tbl(l_index).flow_application_id,
p_flow_code => l_flow_tbl(l_index).flow_code,
p_name => l_flow_tbl(l_index).name,
p_description => l_flow_tbl(l_index).description,
p_primary_page_appl_id => l_flow_tbl(l_index).primary_page_appl_id,
p_primary_page_code => l_flow_tbl(l_index).primary_page_code,
p_attribute_category => l_flow_tbl(l_index).attribute_category,
p_attribute1 => l_flow_tbl(l_index).attribute1,
p_attribute2 => l_flow_tbl(l_index).attribute2,
p_attribute3 => l_flow_tbl(l_index).attribute3,
p_attribute4 => l_flow_tbl(l_index).attribute4,
p_attribute5 => l_flow_tbl(l_index).attribute5,
p_attribute6 => l_flow_tbl(l_index).attribute6,
p_attribute7 => l_flow_tbl(l_index).attribute7,
p_attribute8 => l_flow_tbl(l_index).attribute8,
p_attribute9 => l_flow_tbl(l_index).attribute9,
p_attribute10 => l_flow_tbl(l_index).attribute10,
p_attribute11 => l_flow_tbl(l_index).attribute11,
p_attribute12 => l_flow_tbl(l_index).attribute12,
p_attribute13 => l_flow_tbl(l_index).attribute13,
p_attribute14 => l_flow_tbl(l_index).attribute14,
p_attribute15 => l_flow_tbl(l_index).attribute15,
p_created_by => l_flow_tbl(l_index).created_by,
p_creation_date => l_flow_tbl(l_index).creation_date,
p_last_updated_by => l_flow_tbl(l_index).last_updated_by,
p_last_update_date => l_flow_tbl(l_index).last_update_date,
p_last_update_login => l_flow_tbl(l_index).last_update_login,
p_loader_timestamp => p_loader_timestamp,
p_pass => p_pass,
p_copy_redo_flag => l_copy_redo_flag
);
end if; -- /* if G_UPDATE_MODE */
if (AK_UPLOAD_GRP.G_UPDATE_MODE) then
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 =>
l_region_tbl(l_index).flow_application_id,
p_flow_code => l_region_tbl(l_index).flow_code,
p_page_application_id =>
l_region_tbl(l_index).page_application_id,
p_page_code => l_region_tbl(l_index).page_code,
p_region_application_id =>
l_region_tbl(l_index).region_application_id,
p_region_code => l_region_tbl(l_index).region_code,
p_display_sequence => l_region_tbl(l_index).display_sequence,
p_region_style => l_region_tbl(l_index).region_style,
p_num_columns => l_region_tbl(l_index).num_columns,
p_icx_custom_call => l_region_tbl(l_index).icx_custom_call,
p_parent_region_application_id =>
l_region_tbl(l_index).parent_region_appl_id,
p_parent_region_code => l_region_tbl(l_index).parent_region_code,
p_foreign_key_name => l_region_tbl(l_index).foreign_key_name,
p_attribute_category => l_region_tbl(l_index).attribute_category,
p_attribute1 => l_region_tbl(l_index).attribute1,
p_attribute2 => l_region_tbl(l_index).attribute2,
p_attribute3 => l_region_tbl(l_index).attribute3,
p_attribute4 => l_region_tbl(l_index).attribute4,
p_attribute5 => l_region_tbl(l_index).attribute5,
p_attribute6 => l_region_tbl(l_index).attribute6,
p_attribute7 => l_region_tbl(l_index).attribute7,
p_attribute8 => l_region_tbl(l_index).attribute8,
p_attribute9 => l_region_tbl(l_index).attribute9,
p_attribute10 => l_region_tbl(l_index).attribute10,
p_attribute11 => l_region_tbl(l_index).attribute11,
p_attribute12 => l_region_tbl(l_index).attribute12,
p_attribute13 => l_region_tbl(l_index).attribute13,
p_attribute14 => l_region_tbl(l_index).attribute14,
p_attribute15 => l_region_tbl(l_index).attribute15,
p_created_by => l_region_tbl(l_index).created_by,
p_creation_date => l_region_tbl(l_index).creation_date,
p_last_updated_by => l_region_tbl(l_index).last_updated_by,
p_last_update_date => l_region_tbl(l_index).last_update_date,
p_last_update_login => l_region_tbl(l_index).last_update_login,
p_loader_timestamp => p_loader_timestamp,
p_pass => p_pass,
p_copy_redo_flag => l_copy_redo_flag
);
elsif ( AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE ) then
select last_updated_by, last_update_date
into l_user_id1, l_update1
from ak_flow_page_regions
where flow_code = l_region_tbl(l_index).flow_code
and flow_application_id = l_region_tbl(l_index).flow_application_id
and page_code = l_region_tbl(l_index).page_code
and page_application_id = l_region_tbl(l_index).page_application_id
and region_code = l_region_tbl(l_index).region_code
and region_application_id = l_region_tbl(l_index).region_application_id;
if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
p_loader_timestamp => p_loader_timestamp,
p_created_by => l_region_tbl(l_index).created_by,
p_creation_date => l_region_tbl(l_index).creation_date,
p_last_updated_by => l_region_tbl(l_index).last_updated_by,
p_db_last_updated_by => l_user_id1,
p_last_update_date => l_region_tbl(l_index).last_update_date,
p_db_last_update_date => l_update1,
p_last_update_login => l_region_tbl(l_index).last_update_login,
p_create_or_update => 'UPDATE') then
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 =>
l_region_tbl(l_index).flow_application_id,
p_flow_code => l_region_tbl(l_index).flow_code,
p_page_application_id =>
l_region_tbl(l_index).page_application_id,
p_page_code => l_region_tbl(l_index).page_code,
p_region_application_id =>
l_region_tbl(l_index).region_application_id,
p_region_code => l_region_tbl(l_index).region_code,
p_display_sequence => l_region_tbl(l_index).display_sequence,
p_region_style => l_region_tbl(l_index).region_style,
p_num_columns => l_region_tbl(l_index).num_columns,
p_icx_custom_call => l_region_tbl(l_index).icx_custom_call,
p_parent_region_application_id =>
l_region_tbl(l_index).parent_region_appl_id,
p_parent_region_code => l_region_tbl(l_index).parent_region_code,
p_foreign_key_name => l_region_tbl(l_index).foreign_key_name,
p_attribute_category => l_region_tbl(l_index).attribute_category,
p_attribute1 => l_region_tbl(l_index).attribute1,
p_attribute2 => l_region_tbl(l_index).attribute2,
p_attribute3 => l_region_tbl(l_index).attribute3,
p_attribute4 => l_region_tbl(l_index).attribute4,
p_attribute5 => l_region_tbl(l_index).attribute5,
p_attribute6 => l_region_tbl(l_index).attribute6,
p_attribute7 => l_region_tbl(l_index).attribute7,
p_attribute8 => l_region_tbl(l_index).attribute8,
p_attribute9 => l_region_tbl(l_index).attribute9,
p_attribute10 => l_region_tbl(l_index).attribute10,
p_attribute11 => l_region_tbl(l_index).attribute11,
p_attribute12 => l_region_tbl(l_index).attribute12,
p_attribute13 => l_region_tbl(l_index).attribute13,
p_attribute14 => l_region_tbl(l_index).attribute14,
p_attribute15 => l_region_tbl(l_index).attribute15,
p_created_by => l_region_tbl(l_index).created_by,
p_creation_date => l_region_tbl(l_index).creation_date,
p_last_updated_by => l_region_tbl(l_index).last_updated_by,
p_last_update_date => l_region_tbl(l_index).last_update_date,
p_last_update_login => l_region_tbl(l_index).last_update_login,
p_loader_timestamp => p_loader_timestamp,
p_pass => p_pass,
p_copy_redo_flag => l_copy_redo_flag
);
end if; -- /* if G_UPDATE_MODE G_NO_CUSTOM_UPDATE */
p_last_updated_by => l_region_tbl(l_index).last_updated_by,
p_last_update_date => l_region_tbl(l_index).last_update_date,
p_last_update_login => l_region_tbl(l_index).last_update_login,
p_loader_timestamp => p_loader_timestamp,
p_pass => p_pass,
p_copy_redo_flag => l_copy_redo_flag
);
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 =>
l_region_tbl(l_index).flow_application_id,
p_flow_code => l_region_tbl(l_index).flow_code,
p_page_application_id =>
l_region_tbl(l_index).page_application_id,
p_page_code => l_region_tbl(l_index).page_code,
p_region_application_id =>
l_region_tbl(l_index).region_application_id,
p_region_code => l_region_tbl(l_index).region_code,
p_parent_region_application_id =>
l_region_tbl(l_index).parent_region_appl_id,
p_parent_region_code => l_region_tbl(l_index).parent_region_code,
p_foreign_key_name => l_region_tbl(l_index).foreign_key_name,
p_attribute_category => l_region_tbl(l_index).attribute_category,
p_attribute1 => l_region_tbl(l_index).attribute1,
p_attribute2 => l_region_tbl(l_index).attribute2,
p_attribute3 => l_region_tbl(l_index).attribute3,
p_attribute4 => l_region_tbl(l_index).attribute4,
p_attribute5 => l_region_tbl(l_index).attribute5,
p_attribute6 => l_region_tbl(l_index).attribute6,
p_attribute7 => l_region_tbl(l_index).attribute7,
p_attribute8 => l_region_tbl(l_index).attribute8,
p_attribute9 => l_region_tbl(l_index).attribute9,
p_attribute10 => l_region_tbl(l_index).attribute10,
p_attribute11 => l_region_tbl(l_index).attribute11,
p_attribute12 => l_region_tbl(l_index).attribute12,
p_attribute13 => l_region_tbl(l_index).attribute13,
p_attribute14 => l_region_tbl(l_index).attribute14,
p_attribute15 => l_region_tbl(l_index).attribute15,
p_created_by => l_region_tbl(l_index).created_by,
p_creation_date => l_region_tbl(l_index).creation_date,
p_last_updated_by => l_region_tbl(l_index).last_updated_by,
p_last_update_date => l_region_tbl(l_index).last_update_date,
p_last_update_login => l_region_tbl(l_index).last_update_login,
p_loader_timestamp => p_loader_timestamp,
p_pass => p_pass,
p_copy_redo_flag => l_copy_redo_flag
);
-- update all records
if ( AK_UPLOAD_GRP.G_UPDATE_MODE ) then
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 =>
l_page_tbl(l_index).flow_application_id,
p_flow_code => l_page_tbl(l_index).flow_code,
p_page_application_id =>
l_page_tbl(l_index).page_application_id,
p_page_code => l_page_tbl(l_index).page_code,
p_primary_region_appl_id =>
l_page_tbl(l_index).primary_region_appl_id,
p_primary_region_code => l_page_tbl(l_index).primary_region_code,
p_attribute_category => l_page_tbl(l_index).attribute_category,
p_attribute1 => l_page_tbl(l_index).attribute1,
p_attribute2 => l_page_tbl(l_index).attribute2,
p_attribute3 => l_page_tbl(l_index).attribute3,
p_attribute4 => l_page_tbl(l_index).attribute4,
p_attribute5 => l_page_tbl(l_index).attribute5,
p_attribute6 => l_page_tbl(l_index).attribute6,
p_attribute7 => l_page_tbl(l_index).attribute7,
p_attribute8 => l_page_tbl(l_index).attribute8,
p_attribute9 => l_page_tbl(l_index).attribute9,
p_attribute10 => l_page_tbl(l_index).attribute10,
p_attribute11 => l_page_tbl(l_index).attribute11,
p_attribute12 => l_page_tbl(l_index).attribute12,
p_attribute13 => l_page_tbl(l_index).attribute13,
p_attribute14 => l_page_tbl(l_index).attribute14,
p_attribute15 => l_page_tbl(l_index).attribute15,
p_created_by => l_page_tbl(l_index).created_by,
p_creation_date => l_page_tbl(l_index).creation_date,
p_last_updated_by => l_page_tbl(l_index).last_updated_by,
p_last_update_date => l_page_tbl(l_index).last_update_date,
p_last_update_login => l_page_tbl(l_index).last_update_login,
p_name => l_page_tbl(l_index).name,
p_description => l_page_tbl(l_index).description,
p_loader_timestamp => p_loader_timestamp,
p_pass => p_pass,
p_copy_redo_flag => l_copy_redo_flag
);
elsif ( AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE or (NOT AK_UPLOAD_GRP.G_UPDATE_MODE) ) then
select afp.primary_region_code, afp.primary_region_appl_id, afp.last_updated_by,
afpt.last_updated_by,
afp.last_update_date, afpt.last_update_date
into l_temp_key_code, l_temp_key_appl_id,
l_user_id1 , l_user_id2, l_update1, l_update2
from ak_flow_pages afp, ak_flow_pages_tl afpt
where afp.flow_code = l_page_tbl(l_index).flow_code
and afp.flow_application_id = l_page_tbl(l_index).flow_application_id
and afp.page_code = l_page_tbl(l_index).page_code
and afp.page_application_id = l_page_tbl(l_index).page_application_id
and afp.flow_code = afpt.flow_code
and afp.flow_application_id = afpt.flow_application_id
and afp.page_code = afpt.page_code
and afp.page_application_id = afpt.page_application_id
and afpt.language = userenv('LANG');
if ((AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
p_loader_timestamp => p_loader_timestamp,
p_created_by => l_page_tbl(l_index).created_by,
p_creation_date => l_page_tbl(l_index).creation_date,
p_last_updated_by => l_page_tbl(l_index).last_updated_by,
p_db_last_updated_by => l_user_id1,
p_last_update_date => l_page_tbl(l_index).last_update_date,
p_db_last_update_date => l_update1,
p_last_update_login => l_page_tbl(l_index).last_update_login,
p_create_or_update => 'UPDATE') and
AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
p_loader_timestamp => p_loader_timestamp,
p_created_by => l_page_tbl(l_index).created_by,
p_creation_date => l_page_tbl(l_index).creation_date,
p_last_updated_by => l_page_tbl(l_index).last_updated_by,
p_db_last_updated_by => l_user_id2,
p_last_update_date => l_page_tbl(l_index).last_update_date,
p_db_last_update_date => l_update2,
p_last_update_login => l_page_tbl(l_index).last_update_login,
p_create_or_update => 'UPDATE'))
or
( l_temp_key_appl_id <> l_page_tbl(l_index).primary_region_appl_id and
l_temp_key_code <> l_page_tbl(l_index).primary_region_code ) ) then
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 =>
l_page_tbl(l_index).flow_application_id,
p_flow_code => l_page_tbl(l_index).flow_code,
p_page_application_id =>
l_page_tbl(l_index).page_application_id,
p_page_code => l_page_tbl(l_index).page_code,
p_primary_region_appl_id =>
l_page_tbl(l_index).primary_region_appl_id,
p_primary_region_code => l_page_tbl(l_index).primary_region_code,
p_attribute_category => l_page_tbl(l_index).attribute_category,
p_attribute1 => l_page_tbl(l_index).attribute1,
p_attribute2 => l_page_tbl(l_index).attribute2,
p_attribute3 => l_page_tbl(l_index).attribute3,
p_attribute4 => l_page_tbl(l_index).attribute4,
p_attribute5 => l_page_tbl(l_index).attribute5,
p_attribute6 => l_page_tbl(l_index).attribute6,
p_attribute7 => l_page_tbl(l_index).attribute7,
p_attribute8 => l_page_tbl(l_index).attribute8,
p_attribute9 => l_page_tbl(l_index).attribute9,
p_attribute10 => l_page_tbl(l_index).attribute10,
p_attribute11 => l_page_tbl(l_index).attribute11,
p_attribute12 => l_page_tbl(l_index).attribute12,
p_attribute13 => l_page_tbl(l_index).attribute13,
p_attribute14 => l_page_tbl(l_index).attribute14,
p_attribute15 => l_page_tbl(l_index).attribute15,
p_name => l_page_tbl(l_index).name,
p_description => l_page_tbl(l_index).description,
p_created_by => l_page_tbl(l_index).created_by,
p_creation_date => l_page_tbl(l_index).creation_date,
p_last_updated_by => l_page_tbl(l_index).last_updated_by,
p_last_update_date => l_page_tbl(l_index).last_update_date,
p_last_update_login => l_page_tbl(l_index).last_update_login,
p_loader_timestamp => p_loader_timestamp,
p_pass => p_pass,
p_copy_redo_flag => l_copy_redo_flag
);
end if; -- /* if G_UPDATE_MODE */
-- Update Flow Page Region Relation only if G_UPDATE_MODE is TRUE
--
if (AK_UPLOAD_GRP.G_UPDATE_MODE) then
AK_FLOW_PVT.UPDATE_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 =>
l_relation_tbl(l_index).flow_application_id,
p_flow_code => l_relation_tbl(l_index).flow_code,
p_foreign_key_name => l_relation_tbl(l_index).foreign_key_name,
p_from_page_appl_id => l_relation_tbl(l_index).from_page_appl_id,
p_from_page_code => l_relation_tbl(l_index).from_page_code,
p_from_region_appl_id =>
l_relation_tbl(l_index).from_region_appl_id,
p_from_region_code => l_relation_tbl(l_index).from_region_code,
p_to_page_appl_id => l_relation_tbl(l_index).to_page_appl_id,
p_to_page_code => l_relation_tbl(l_index).to_page_code,
p_to_region_appl_id =>
l_relation_tbl(l_index).to_region_appl_id,
p_to_region_code => l_relation_tbl(l_index).to_region_code,
p_application_id => l_relation_tbl(l_index).application_id,
p_attribute_category => l_relation_tbl(l_index).attribute_category,
p_attribute1 => l_relation_tbl(l_index).attribute1,
p_attribute2 => l_relation_tbl(l_index).attribute2,
p_attribute3 => l_relation_tbl(l_index).attribute3,
p_attribute4 => l_relation_tbl(l_index).attribute4,
p_attribute5 => l_relation_tbl(l_index).attribute5,
p_attribute6 => l_relation_tbl(l_index).attribute6,
p_attribute7 => l_relation_tbl(l_index).attribute7,
p_attribute8 => l_relation_tbl(l_index).attribute8,
p_attribute9 => l_relation_tbl(l_index).attribute9,
p_attribute10 => l_relation_tbl(l_index).attribute10,
p_attribute11 => l_relation_tbl(l_index).attribute11,
p_attribute12 => l_relation_tbl(l_index).attribute12,
p_attribute13 => l_relation_tbl(l_index).attribute13,
p_attribute14 => l_relation_tbl(l_index).attribute14,
p_attribute15 => l_relation_tbl(l_index).attribute15,
p_created_by => l_relation_tbl(l_index).created_by,
p_creation_date => l_relation_tbl(l_index).creation_date,
p_last_updated_by => l_relation_tbl(l_index).last_updated_by,
p_last_update_date => l_relation_tbl(l_index).last_update_date,
p_last_update_login => l_relation_tbl(l_index).last_update_login,
p_loader_timestamp => p_loader_timestamp,
p_pass => p_pass,
p_copy_redo_flag => l_copy_redo_flag
);
elsif ( AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE ) then
select last_updated_by, last_update_date
into l_user_id1, l_update1
from ak_flow_region_relations
where flow_code = l_relation_tbl(l_index).flow_code
and flow_application_id = l_relation_tbl(l_index).flow_application_id
and foreign_key_name = l_relation_tbl(l_index).foreign_key_name
and from_page_code = l_relation_tbl(l_index).from_page_code
and from_page_appl_id = l_relation_tbl(l_index).from_page_appl_id
and from_region_code = l_relation_tbl(l_index).from_region_code
and from_region_appl_id = l_relation_tbl(l_index).from_region_appl_id
and to_page_code = l_relation_tbl(l_index).to_page_code
and to_page_appl_id = l_relation_tbl(l_index).to_page_appl_id
and to_region_code = l_relation_tbl(l_index).to_region_code
and to_region_appl_id = l_relation_tbl(l_index).to_region_appl_id;
if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
p_loader_timestamp => p_loader_timestamp,
p_created_by => l_relation_tbl(l_index).created_by,
p_creation_date => l_relation_tbl(l_index).creation_date,
p_last_updated_by => l_relation_tbl(l_index).last_updated_by,
p_db_last_updated_by => l_user_id1,
p_last_update_date => l_relation_tbl(l_index).last_update_date,
p_db_last_update_date => l_update1,
p_last_update_login => l_relation_tbl(l_index).last_update_login,
p_create_or_update => 'UPDATE') then
AK_FLOW_PVT.UPDATE_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 =>
l_relation_tbl(l_index).flow_application_id,
p_flow_code => l_relation_tbl(l_index).flow_code,
p_foreign_key_name => l_relation_tbl(l_index).foreign_key_name,
p_from_page_appl_id => l_relation_tbl(l_index).from_page_appl_id,
p_from_page_code => l_relation_tbl(l_index).from_page_code,
p_from_region_appl_id =>
l_relation_tbl(l_index).from_region_appl_id,
p_from_region_code => l_relation_tbl(l_index).from_region_code,
p_to_page_appl_id => l_relation_tbl(l_index).to_page_appl_id,
p_to_page_code => l_relation_tbl(l_index).to_page_code,
p_to_region_appl_id =>
l_relation_tbl(l_index).to_region_appl_id,
p_to_region_code => l_relation_tbl(l_index).to_region_code,
p_application_id => l_relation_tbl(l_index).application_id,
p_attribute_category => l_relation_tbl(l_index).attribute_category,
p_attribute1 => l_relation_tbl(l_index).attribute1,
p_attribute2 => l_relation_tbl(l_index).attribute2,
p_attribute3 => l_relation_tbl(l_index).attribute3,
p_attribute4 => l_relation_tbl(l_index).attribute4,
p_attribute5 => l_relation_tbl(l_index).attribute5,
p_attribute6 => l_relation_tbl(l_index).attribute6,
p_attribute7 => l_relation_tbl(l_index).attribute7,
p_attribute8 => l_relation_tbl(l_index).attribute8,
p_attribute9 => l_relation_tbl(l_index).attribute9,
p_attribute10 => l_relation_tbl(l_index).attribute10,
p_attribute11 => l_relation_tbl(l_index).attribute11,
p_attribute12 => l_relation_tbl(l_index).attribute12,
p_attribute13 => l_relation_tbl(l_index).attribute13,
p_attribute14 => l_relation_tbl(l_index).attribute14,
p_attribute15 => l_relation_tbl(l_index).attribute15,
p_created_by => l_relation_tbl(l_index).created_by,
p_creation_date => l_relation_tbl(l_index).creation_date,
p_last_updated_by => l_relation_tbl(l_index).last_updated_by,
p_last_update_date => l_relation_tbl(l_index).last_update_date,
p_last_update_login => l_relation_tbl(l_index).last_update_login,
p_loader_timestamp => p_loader_timestamp,
p_pass => p_pass,
p_copy_redo_flag => l_copy_redo_flag
);
end if; -- /* if G_UPDATE_MODE G_NO_CUSTOM_UPDATE */
p_last_updated_by => l_relation_tbl(l_index).last_updated_by,
p_last_update_date => l_relation_tbl(l_index).last_update_date,
p_last_update_login => l_relation_tbl(l_index).last_update_login,
p_loader_timestamp => p_loader_timestamp,
p_pass => p_pass,
p_copy_redo_flag => l_copy_redo_flag
);
-- Update Flow Page Region Item only if G_UPDATE_MODE is TRUE
--
if (AK_UPLOAD_GRP.G_UPDATE_MODE) then
AK_FLOW_PVT.UPDATE_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 =>
l_item_tbl(l_index).flow_application_id,
p_flow_code => l_item_tbl(l_index).flow_code,
p_page_application_id =>
l_item_tbl(l_index).page_application_id,
p_page_code => l_item_tbl(l_index).page_code,
p_region_application_id =>
l_item_tbl(l_index).region_application_id,
p_region_code => l_item_tbl(l_index).region_code,
p_attribute_application_id =>
l_item_tbl(l_index).attribute_application_id,
p_attribute_code => l_item_tbl(l_index).attribute_code,
p_to_page_appl_id => l_item_tbl(l_index).to_page_appl_id,
p_to_page_code => l_item_tbl(l_index).to_page_code,
p_to_url_attribute_appl_id =>
l_item_tbl(l_index).to_url_attribute_appl_id,
p_to_url_attribute_code =>
l_item_tbl(l_index).to_url_attribute_code,
p_attribute_category => l_item_tbl(l_index).attribute_category,
p_attribute1 => l_item_tbl(l_index).attribute1,
p_attribute2 => l_item_tbl(l_index).attribute2,
p_attribute3 => l_item_tbl(l_index).attribute3,
p_attribute4 => l_item_tbl(l_index).attribute4,
p_attribute5 => l_item_tbl(l_index).attribute5,
p_attribute6 => l_item_tbl(l_index).attribute6,
p_attribute7 => l_item_tbl(l_index).attribute7,
p_attribute8 => l_item_tbl(l_index).attribute8,
p_attribute9 => l_item_tbl(l_index).attribute9,
p_attribute10 => l_item_tbl(l_index).attribute10,
p_attribute11 => l_item_tbl(l_index).attribute11,
p_attribute12 => l_item_tbl(l_index).attribute12,
p_attribute13 => l_item_tbl(l_index).attribute13,
p_attribute14 => l_item_tbl(l_index).attribute14,
p_attribute15 => l_item_tbl(l_index).attribute15,
p_created_by => l_item_tbl(l_index).created_by,
p_creation_date => l_item_tbl(l_index).creation_date,
p_last_updated_by => l_item_tbl(l_index).last_updated_by,
p_last_update_date => l_item_tbl(l_index).last_update_date,
p_last_update_login => l_item_tbl(l_index).last_update_login,
p_loader_timestamp => p_loader_timestamp,
p_pass => p_pass,
p_copy_redo_flag => l_copy_redo_flag
);
elsif ( AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE ) then
select last_updated_by, last_update_date
into l_user_id1, l_update1
from ak_flow_page_region_items
where flow_code = l_item_tbl(l_index).flow_code
and flow_application_id = l_item_tbl(l_index).flow_application_id
and page_code = l_item_tbl(l_index).page_code
and page_application_id = l_item_tbl(l_index).page_application_id
and region_code = l_item_tbl(l_index).region_code
and region_application_id = l_item_tbl(l_index).region_application_id
and attribute_code = l_item_tbl(l_index).attribute_code
and attribute_application_id = l_item_tbl(l_index).attribute_application_id;
if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
p_loader_timestamp => p_loader_timestamp,
p_created_by => l_item_tbl(l_index).created_by,
p_creation_date => l_item_tbl(l_index).creation_date,
p_last_updated_by => l_item_tbl(l_index).last_updated_by,
p_db_last_updated_by => l_user_id1,
p_last_update_date => l_item_tbl(l_index).last_update_date,
p_db_last_update_date => l_update1,
p_last_update_login => l_item_tbl(l_index).last_update_login,
p_create_or_update => 'UPDATE') then
AK_FLOW_PVT.UPDATE_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 =>
l_item_tbl(l_index).flow_application_id,
p_flow_code => l_item_tbl(l_index).flow_code,
p_page_application_id =>
l_item_tbl(l_index).page_application_id,
p_page_code => l_item_tbl(l_index).page_code,
p_region_application_id =>
l_item_tbl(l_index).region_application_id,
p_region_code => l_item_tbl(l_index).region_code,
p_attribute_application_id =>
l_item_tbl(l_index).attribute_application_id,
p_attribute_code => l_item_tbl(l_index).attribute_code,
p_to_page_appl_id => l_item_tbl(l_index).to_page_appl_id,
p_to_page_code => l_item_tbl(l_index).to_page_code,
p_to_url_attribute_appl_id =>
l_item_tbl(l_index).to_url_attribute_appl_id,
p_to_url_attribute_code =>
l_item_tbl(l_index).to_url_attribute_code,
p_attribute_category => l_item_tbl(l_index).attribute_category,
p_attribute1 => l_item_tbl(l_index).attribute1,
p_attribute2 => l_item_tbl(l_index).attribute2,
p_attribute3 => l_item_tbl(l_index).attribute3,
p_attribute4 => l_item_tbl(l_index).attribute4,
p_attribute5 => l_item_tbl(l_index).attribute5,
p_attribute6 => l_item_tbl(l_index).attribute6,
p_attribute7 => l_item_tbl(l_index).attribute7,
p_attribute8 => l_item_tbl(l_index).attribute8,
p_attribute9 => l_item_tbl(l_index).attribute9,
p_attribute10 => l_item_tbl(l_index).attribute10,
p_attribute11 => l_item_tbl(l_index).attribute11,
p_attribute12 => l_item_tbl(l_index).attribute12,
p_attribute13 => l_item_tbl(l_index).attribute13,
p_attribute14 => l_item_tbl(l_index).attribute14,
p_attribute15 => l_item_tbl(l_index).attribute15,
p_created_by => l_item_tbl(l_index).created_by,
p_creation_date => l_item_tbl(l_index).creation_date,
p_last_updated_by => l_item_tbl(l_index).last_updated_by,
p_last_update_date => l_item_tbl(l_index).last_update_date,
p_last_update_login => l_item_tbl(l_index).last_update_login,
p_loader_timestamp => p_loader_timestamp,
p_pass => p_pass,
p_copy_redo_flag => l_copy_redo_flag
);
end if; -- /* if G_UPDATE_MODE G_NO_CUSTOM_UPDATE */
p_last_updated_by => l_item_tbl(l_index).last_updated_by,
p_last_update_date => l_item_tbl(l_index).last_update_date,
p_last_update_login => l_item_tbl(l_index).last_update_login,
p_loader_timestamp => p_loader_timestamp,
p_pass => p_pass,
p_copy_redo_flag => l_copy_redo_flag
);
p_last_updated_by => G_FLOW_REDO_TBL(l_index).last_updated_by,
p_last_update_date => G_FLOW_REDO_TBL(l_index).last_update_date,
p_last_update_login => G_FLOW_REDO_TBL(l_index).last_update_login,
p_loader_timestamp => p_loader_timestamp,
p_pass => p_pass,
p_copy_redo_flag => l_copy_redo_flag
);
p_last_updated_by => G_PAGE_REDO_TBL(l_index).last_updated_by,
p_last_update_date => G_PAGE_REDO_TBL(l_index).last_update_date,
p_last_update_login => G_PAGE_REDO_TBL(l_index).last_update_login,
p_loader_timestamp => p_loader_timestamp,
p_pass => p_pass,
p_copy_redo_flag => l_copy_redo_flag
);
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 =>
G_FLOW_REDO_TBL(l_index).flow_application_id,
p_flow_code => G_FLOW_REDO_TBL(l_index).flow_code,
p_name => G_FLOW_REDO_TBL(l_index).name,
p_description => G_FLOW_REDO_TBL(l_index).description,
p_primary_page_appl_id => G_FLOW_REDO_TBL(l_index).primary_page_appl_id,
p_primary_page_code => G_FLOW_REDO_TBL(l_index).primary_page_code,
p_attribute_category => G_FLOW_REDO_TBL(l_index).attribute_category,
p_attribute1 => G_FLOW_REDO_TBL(l_index).attribute1,
p_attribute2 => G_FLOW_REDO_TBL(l_index).attribute2,
p_attribute3 => G_FLOW_REDO_TBL(l_index).attribute3,
p_attribute4 => G_FLOW_REDO_TBL(l_index).attribute4,
p_attribute5 => G_FLOW_REDO_TBL(l_index).attribute5,
p_attribute6 => G_FLOW_REDO_TBL(l_index).attribute6,
p_attribute7 => G_FLOW_REDO_TBL(l_index).attribute7,
p_attribute8 => G_FLOW_REDO_TBL(l_index).attribute8,
p_attribute9 => G_FLOW_REDO_TBL(l_index).attribute9,
p_attribute10 => G_FLOW_REDO_TBL(l_index).attribute10,
p_attribute11 => G_FLOW_REDO_TBL(l_index).attribute11,
p_attribute12 => G_FLOW_REDO_TBL(l_index).attribute12,
p_attribute13 => G_FLOW_REDO_TBL(l_index).attribute13,
p_attribute14 => G_FLOW_REDO_TBL(l_index).attribute14,
p_attribute15 => G_FLOW_REDO_TBL(l_index).attribute15,
p_created_by => G_FLOW_REDO_TBL(l_index).created_by,
p_creation_date => G_FLOW_REDO_TBL(l_index).creation_date,
p_last_updated_by => G_FLOW_REDO_TBL(l_index).last_updated_by,
p_last_update_date => G_FLOW_REDO_TBL(l_index).last_update_date,
p_last_update_login => G_FLOW_REDO_TBL(l_index).last_update_login,
p_loader_timestamp => p_loader_timestamp,
p_pass => p_pass,
p_copy_redo_flag => l_copy_redo_flag
);
G_FLOW_REDO_TBL.DELETE;
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 =>
G_PAGE_REGION_REDO_TBL(l_index).flow_application_id,
p_flow_code => G_PAGE_REGION_REDO_TBL(l_index).flow_code,
p_page_application_id =>
G_PAGE_REGION_REDO_TBL(l_index).page_application_id,
p_page_code => G_PAGE_REGION_REDO_TBL(l_index).page_code,
p_region_application_id =>
G_PAGE_REGION_REDO_TBL(l_index).region_application_id,
p_region_code => G_PAGE_REGION_REDO_TBL(l_index).region_code,
p_display_sequence => G_PAGE_REGION_REDO_TBL(l_index).display_sequence,
p_region_style => G_PAGE_REGION_REDO_TBL(l_index).region_style,
p_num_columns => G_PAGE_REGION_REDO_TBL(l_index).num_columns,
p_icx_custom_call => G_PAGE_REGION_REDO_TBL(l_index).icx_custom_call,
p_parent_region_application_id =>
G_PAGE_REGION_REDO_TBL(l_index).parent_region_appl_id,
p_parent_region_code => G_PAGE_REGION_REDO_TBL(l_index).parent_region_code,
p_foreign_key_name => G_PAGE_REGION_REDO_TBL(l_index).foreign_key_name,
p_attribute_category => G_PAGE_REGION_REDO_TBL(l_index).attribute_category,
p_attribute1 => G_PAGE_REGION_REDO_TBL(l_index).attribute1,
p_attribute2 => G_PAGE_REGION_REDO_TBL(l_index).attribute2,
p_attribute3 => G_PAGE_REGION_REDO_TBL(l_index).attribute3,
p_attribute4 => G_PAGE_REGION_REDO_TBL(l_index).attribute4,
p_attribute5 => G_PAGE_REGION_REDO_TBL(l_index).attribute5,
p_attribute6 => G_PAGE_REGION_REDO_TBL(l_index).attribute6,
p_attribute7 => G_PAGE_REGION_REDO_TBL(l_index).attribute7,
p_attribute8 => G_PAGE_REGION_REDO_TBL(l_index).attribute8,
p_attribute9 => G_PAGE_REGION_REDO_TBL(l_index).attribute9,
p_attribute10 => G_PAGE_REGION_REDO_TBL(l_index).attribute10,
p_attribute11 => G_PAGE_REGION_REDO_TBL(l_index).attribute11,
p_attribute12 => G_PAGE_REGION_REDO_TBL(l_index).attribute12,
p_attribute13 => G_PAGE_REGION_REDO_TBL(l_index).attribute13,
p_attribute14 => G_PAGE_REGION_REDO_TBL(l_index).attribute14,
p_attribute15 => G_PAGE_REGION_REDO_TBL(l_index).attribute15,
p_created_by => G_PAGE_REGION_REDO_TBL(l_index).created_by,
p_creation_date => G_PAGE_REGION_REDO_TBL(l_index).creation_date,
p_last_updated_by => G_PAGE_REGION_REDO_TBL(l_index).last_updated_by,
p_last_update_date => G_PAGE_REGION_REDO_TBL(l_index).last_update_date,
p_last_update_login => G_PAGE_REGION_REDO_TBL(l_index).last_update_login,
p_loader_timestamp => p_loader_timestamp,
p_pass => p_pass,
p_copy_redo_flag => l_copy_redo_flag
);
p_last_updated_by => G_PAGE_REGION_REDO_TBL(l_index).last_updated_by,
p_last_update_date => G_PAGE_REGION_REDO_TBL(l_index).last_update_date,
p_last_update_login => G_PAGE_REGION_REDO_TBL(l_index).last_update_login,
p_loader_timestamp => p_loader_timestamp,
p_pass => p_pass,
p_copy_redo_flag => l_copy_redo_flag
);
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 =>
G_PAGE_REGION_REDO_TBL(l_index).flow_application_id,
p_flow_code => G_PAGE_REGION_REDO_TBL(l_index).flow_code,
p_page_application_id =>
G_PAGE_REGION_REDO_TBL(l_index).page_application_id,
p_page_code => G_PAGE_REGION_REDO_TBL(l_index).page_code,
p_region_application_id =>
G_PAGE_REGION_REDO_TBL(l_index).region_application_id,
p_region_code => G_PAGE_REGION_REDO_TBL(l_index).region_code,
p_parent_region_application_id =>
G_PAGE_REGION_REDO_TBL(l_index).parent_region_appl_id,
p_parent_region_code => G_PAGE_REGION_REDO_TBL(l_index).parent_region_code,
p_attribute_category => G_PAGE_REGION_REDO_TBL(l_index).attribute_category,
p_attribute1 => G_PAGE_REGION_REDO_TBL(l_index).attribute1,
p_attribute2 => G_PAGE_REGION_REDO_TBL(l_index).attribute2,
p_attribute3 => G_PAGE_REGION_REDO_TBL(l_index).attribute3,
p_attribute4 => G_PAGE_REGION_REDO_TBL(l_index).attribute4,
p_attribute5 => G_PAGE_REGION_REDO_TBL(l_index).attribute5,
p_attribute6 => G_PAGE_REGION_REDO_TBL(l_index).attribute6,
p_attribute7 => G_PAGE_REGION_REDO_TBL(l_index).attribute7,
p_attribute8 => G_PAGE_REGION_REDO_TBL(l_index).attribute8,
p_attribute9 => G_PAGE_REGION_REDO_TBL(l_index).attribute9,
p_attribute10 => G_PAGE_REGION_REDO_TBL(l_index).attribute10,
p_attribute11 => G_PAGE_REGION_REDO_TBL(l_index).attribute11,
p_attribute12 => G_PAGE_REGION_REDO_TBL(l_index).attribute12,
p_attribute13 => G_PAGE_REGION_REDO_TBL(l_index).attribute13,
p_attribute14 => G_PAGE_REGION_REDO_TBL(l_index).attribute14,
p_attribute15 => G_PAGE_REGION_REDO_TBL(l_index).attribute15,
p_foreign_key_name => G_PAGE_REGION_REDO_TBL(l_index).foreign_key_name,
p_created_by => G_PAGE_REGION_REDO_TBL(l_index).created_by,
p_creation_date => G_PAGE_REGION_REDO_TBL(l_index).creation_date,
p_last_updated_by => G_PAGE_REGION_REDO_TBL(l_index).last_updated_by,
p_last_update_date => G_PAGE_REGION_REDO_TBL(l_index).last_update_date,
p_last_update_login => G_PAGE_REGION_REDO_TBL(l_index).last_update_login,
p_loader_timestamp => p_loader_timestamp,
p_pass => p_pass,
p_copy_redo_flag => l_copy_redo_flag
);
G_PAGE_REGION_REDO_TBL.DELETE;
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 =>
G_PAGE_REDO_TBL(l_index).flow_application_id,
p_flow_code => G_PAGE_REDO_TBL(l_index).flow_code,
p_page_application_id =>
G_PAGE_REDO_TBL(l_index).page_application_id,
p_page_code => G_PAGE_REDO_TBL(l_index).page_code,
p_name => G_PAGE_REDO_TBL(l_index).name,
p_description => G_PAGE_REDO_TBL(l_index).description,
p_primary_region_appl_id =>
G_PAGE_REDO_TBL(l_index).primary_region_appl_id,
p_primary_region_code => G_PAGE_REDO_TBL(l_index).primary_region_code,
p_attribute_category => G_PAGE_REDO_TBL(l_index).attribute_category,
p_attribute1 => G_PAGE_REDO_TBL(l_index).attribute1,
p_attribute2 => G_PAGE_REDO_TBL(l_index).attribute2,
p_attribute3 => G_PAGE_REDO_TBL(l_index).attribute3,
p_attribute4 => G_PAGE_REDO_TBL(l_index).attribute4,
p_attribute5 => G_PAGE_REDO_TBL(l_index).attribute5,
p_attribute6 => G_PAGE_REDO_TBL(l_index).attribute6,
p_attribute7 => G_PAGE_REDO_TBL(l_index).attribute7,
p_attribute8 => G_PAGE_REDO_TBL(l_index).attribute8,
p_attribute9 => G_PAGE_REDO_TBL(l_index).attribute9,
p_attribute10 => G_PAGE_REDO_TBL(l_index).attribute10,
p_attribute11 => G_PAGE_REDO_TBL(l_index).attribute11,
p_attribute12 => G_PAGE_REDO_TBL(l_index).attribute12,
p_attribute13 => G_PAGE_REDO_TBL(l_index).attribute13,
p_attribute14 => G_PAGE_REDO_TBL(l_index).attribute14,
p_attribute15 => G_PAGE_REDO_TBL(l_index).attribute15,
p_created_by => G_PAGE_REDO_TBL(l_index).created_by,
p_creation_date => G_PAGE_REDO_TBL(l_index).creation_date,
p_last_updated_by => G_PAGE_REDO_TBL(l_index).last_updated_by,
p_last_update_date => G_PAGE_REDO_TBL(l_index).last_update_date,
p_last_update_login => G_PAGE_REDO_TBL(l_index).last_update_login,
p_loader_timestamp => p_loader_timestamp,
p_pass => p_pass,
p_copy_redo_flag => l_copy_redo_flag
);
G_PAGE_REDO_TBL.DELETE;
AK_FLOW_PVT.UPDATE_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 =>
G_REGION_RELATION_REDO_TBL(l_index).flow_application_id,
p_flow_code => G_REGION_RELATION_REDO_TBL(l_index).flow_code,
p_foreign_key_name => G_REGION_RELATION_REDO_TBL(l_index).foreign_key_name,
p_from_page_appl_id => G_REGION_RELATION_REDO_TBL(l_index).from_page_appl_id,
p_from_page_code => G_REGION_RELATION_REDO_TBL(l_index).from_page_code,
p_from_region_appl_id =>
G_REGION_RELATION_REDO_TBL(l_index).from_region_appl_id,
p_from_region_code => G_REGION_RELATION_REDO_TBL(l_index).from_region_code,
p_to_page_appl_id => G_REGION_RELATION_REDO_TBL(l_index).to_page_appl_id,
p_to_page_code => G_REGION_RELATION_REDO_TBL(l_index).to_page_code,
p_to_region_appl_id =>
G_REGION_RELATION_REDO_TBL(l_index).to_region_appl_id,
p_to_region_code => G_REGION_RELATION_REDO_TBL(l_index).to_region_code,
p_application_id => G_REGION_RELATION_REDO_TBL(l_index).application_id,
p_attribute_category => G_REGION_RELATION_REDO_TBL(l_index).attribute_category,
p_attribute1 => G_REGION_RELATION_REDO_TBL(l_index).attribute1,
p_attribute2 => G_REGION_RELATION_REDO_TBL(l_index).attribute2,
p_attribute3 => G_REGION_RELATION_REDO_TBL(l_index).attribute3,
p_attribute4 => G_REGION_RELATION_REDO_TBL(l_index).attribute4,
p_attribute5 => G_REGION_RELATION_REDO_TBL(l_index).attribute5,
p_attribute6 => G_REGION_RELATION_REDO_TBL(l_index).attribute6,
p_attribute7 => G_REGION_RELATION_REDO_TBL(l_index).attribute7,
p_attribute8 => G_REGION_RELATION_REDO_TBL(l_index).attribute8,
p_attribute9 => G_REGION_RELATION_REDO_TBL(l_index).attribute9,
p_attribute10 => G_REGION_RELATION_REDO_TBL(l_index).attribute10,
p_attribute11 => G_REGION_RELATION_REDO_TBL(l_index).attribute11,
p_attribute12 => G_REGION_RELATION_REDO_TBL(l_index).attribute12,
p_attribute13 => G_REGION_RELATION_REDO_TBL(l_index).attribute13,
p_attribute14 => G_REGION_RELATION_REDO_TBL(l_index).attribute14,
p_attribute15 => G_REGION_RELATION_REDO_TBL(l_index).attribute15,
p_created_by => G_REGION_RELATION_REDO_TBL(l_index).created_by,
p_creation_date => G_REGION_RELATION_REDO_TBL(l_index).creation_date,
p_last_updated_by => G_REGION_RELATION_REDO_TBL(l_index).last_updated_by,
p_last_update_date => G_REGION_RELATION_REDO_TBL(l_index).last_update_date,
p_last_update_login => G_REGION_RELATION_REDO_TBL(l_index).last_update_login,
p_loader_timestamp => p_loader_timestamp,
p_pass => p_pass,
p_copy_redo_flag => l_copy_redo_flag
);
p_last_updated_by => G_REGION_RELATION_REDO_TBL(l_index).last_updated_by,
p_last_update_date => G_REGION_RELATION_REDO_TBL(l_index).last_update_date,
p_last_update_login => G_REGION_RELATION_REDO_TBL(l_index).last_update_login,
p_loader_timestamp => p_loader_timestamp,
p_pass => p_pass,
p_copy_redo_flag => l_copy_redo_flag
);
G_REGION_RELATION_REDO_TBL.DELETE;
AK_FLOW_PVT.UPDATE_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 =>
G_PAGE_REGION_ITEM_REDO_TBL(l_index).flow_application_id,
p_flow_code => G_PAGE_REGION_ITEM_REDO_TBL(l_index).flow_code,
p_page_application_id =>
G_PAGE_REGION_ITEM_REDO_TBL(l_index).page_application_id,
p_page_code => G_PAGE_REGION_ITEM_REDO_TBL(l_index).page_code,
p_region_application_id =>
G_PAGE_REGION_ITEM_REDO_TBL(l_index).region_application_id,
p_region_code => G_PAGE_REGION_ITEM_REDO_TBL(l_index).region_code,
p_attribute_application_id =>
G_PAGE_REGION_ITEM_REDO_TBL(l_index).attribute_application_id,
p_attribute_code => G_PAGE_REGION_ITEM_REDO_TBL(l_index).attribute_code,
p_to_page_appl_id => G_PAGE_REGION_ITEM_REDO_TBL(l_index).to_page_appl_id,
p_to_page_code => G_PAGE_REGION_ITEM_REDO_TBL(l_index).to_page_code,
p_to_url_attribute_appl_id =>
G_PAGE_REGION_ITEM_REDO_TBL(l_index).to_url_attribute_appl_id,
p_to_url_attribute_code =>
G_PAGE_REGION_ITEM_REDO_TBL(l_index).to_url_attribute_code,
p_attribute_category => G_PAGE_REGION_ITEM_REDO_TBL(l_index).attribute_category,
p_attribute1 => G_PAGE_REGION_ITEM_REDO_TBL(l_index).attribute1,
p_attribute2 => G_PAGE_REGION_ITEM_REDO_TBL(l_index).attribute2,
p_attribute3 => G_PAGE_REGION_ITEM_REDO_TBL(l_index).attribute3,
p_attribute4 => G_PAGE_REGION_ITEM_REDO_TBL(l_index).attribute4,
p_attribute5 => G_PAGE_REGION_ITEM_REDO_TBL(l_index).attribute5,
p_attribute6 => G_PAGE_REGION_ITEM_REDO_TBL(l_index).attribute6,
p_attribute7 => G_PAGE_REGION_ITEM_REDO_TBL(l_index).attribute7,
p_attribute8 => G_PAGE_REGION_ITEM_REDO_TBL(l_index).attribute8,
p_attribute9 => G_PAGE_REGION_ITEM_REDO_TBL(l_index).attribute9,
p_attribute10 => G_PAGE_REGION_ITEM_REDO_TBL(l_index).attribute10,
p_attribute11 => G_PAGE_REGION_ITEM_REDO_TBL(l_index).attribute11,
p_attribute12 => G_PAGE_REGION_ITEM_REDO_TBL(l_index).attribute12,
p_attribute13 => G_PAGE_REGION_ITEM_REDO_TBL(l_index).attribute13,
p_attribute14 => G_PAGE_REGION_ITEM_REDO_TBL(l_index).attribute14,
p_attribute15 => G_PAGE_REGION_ITEM_REDO_TBL(l_index).attribute15,
p_created_by => G_PAGE_REGION_ITEM_REDO_TBL(l_index).created_by,
p_creation_date => G_PAGE_REGION_ITEM_REDO_TBL(l_index).creation_date,
p_last_updated_by => G_PAGE_REGION_ITEM_REDO_TBL(l_index).last_updated_by,
p_last_update_date => G_PAGE_REGION_ITEM_REDO_TBL(l_index).last_update_date,
p_last_update_login => G_PAGE_REGION_ITEM_REDO_TBL(l_index).last_update_login,
p_loader_timestamp => p_loader_timestamp,
p_pass => p_pass,
p_copy_redo_flag => l_copy_redo_flag
);
p_last_updated_by => G_PAGE_REGION_ITEM_REDO_TBL(l_index).last_updated_by,
p_last_update_date => G_PAGE_REGION_ITEM_REDO_TBL(l_index).last_update_date,
p_last_update_login => G_PAGE_REGION_ITEM_REDO_TBL(l_index).last_update_login,
p_loader_timestamp => p_loader_timestamp,
p_pass => p_pass,
p_copy_redo_flag => l_copy_redo_flag
);
G_PAGE_REGION_ITEM_REDO_TBL.DELETE;
G_FLOW_REDO_TBL.DELETE;
G_PAGE_REGION_REDO_TBL.DELETE;
G_PAGE_REDO_TBL.DELETE;
G_REGION_RELATION_REDO_TBL.DELETE;
G_PAGE_REGION_ITEM_REDO_TBL.DELETE;
G_FLOW_REDO_TBL.DELETE;
G_PAGE_REGION_REDO_TBL.DELETE;
G_PAGE_REDO_TBL.DELETE;
G_REGION_RELATION_REDO_TBL.DELETE;
G_PAGE_REGION_ITEM_REDO_TBL.DELETE;