The following lines contain the word 'select', 'insert', 'update' or 'delete':
select name
from fnd_document_categories
where category_id = p_category_id;
select category_id
from fnd_document_categories
where name =p_category_name;
select ATTRIBUTE_APPLICATION_ID, ATTRIBUTE_CODE
from AK_REGION_ITEMS
where region_application_id = region_appl_id_param
and region_code = region_code_param;
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_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 = 'UPDATE_FLAG') or
(l_token = 'REQUIRED_FLAG') or
(l_token = 'SECURITY_CODE') or
(l_token = 'DEFAULT_VALUE_VARCHAR2') or
(l_token = 'DEFAULT_VALUE_NUMBER') or
(l_token = 'DEFAULT_VALUE_DATE') or
(l_token = 'LOV_REGION') or
(l_token = 'LOV_FOREIGN_KEY_NAME') or
(l_token = 'LOV_ATTRIBUTE') or
(l_token = 'LOV_DEFAULT_FLAG') or
(l_token = 'REGION_DEFAULTING_API_PKG') or
(l_token = 'REGION_DEFAULTING_API_PROC') or
(l_token = 'REGION_VALIDATION_API_PKG') or
(l_token = 'REGION_VALIDATION_API_PROC') or
(l_token = 'ORDER_SEQUENCE') or
(l_token = 'INITIAL_SORT_SEQUENCE') or
(l_token = 'CUSTOMIZATION_APPLICATION_ID') or
(l_token = 'CUSTOMIZATION_CODE') or
(l_token = 'ORDER_DIRECTION') or
(l_token = 'SUBMIT') or
(l_token = 'ENCRYPT') or
(l_token = 'DISPLAY_HEIGHT') or
(l_token = 'CSS_CLASS_NAME') or
(l_token = 'VIEW_USAGE_NAME') or
(l_token = 'VIEW_ATTRIBUTE_NAME') or
(l_token = 'NESTED_REGION_APPLICATION_ID') or
(l_token = 'NESTED_REGION_CODE') or
(l_token = 'URL') or
(l_token = 'POPLIST_VIEWOBJECT') or
(l_token = 'POPLIST_DISPLAY_ATTRIBUTE') or
(l_token = 'POPLIST_VALUE_ATTRIBUTE') or
(l_token = 'IMAGE_FILE_NAME') or
(l_token = 'ITEM_NAME') or
(l_token = 'CSS_LABEL_CLASS_NAME') or
(l_token = 'MENU_NAME') or
(l_token = 'FLEXFIELD_NAME') or
(l_token = 'FLEXFIELD_APPLICATION_ID') or
(l_token = 'TABULAR_FUNCTION_CODE') or
(l_token = 'TIP_TYPE') or
(l_token = 'TIP_MESSAGE_NAME') or
(l_token = 'TIP_MESSAGE_APPLICATION_ID') or
(l_token = 'FLEX_SEGMENT_LIST') or
(l_token = 'ENTITY_ID') or
(l_token = 'ANCHOR') or
(l_token = 'POPLIST_VIEW_USAGE_NAME') or
(l_token = 'USER_CUSTOMIZABLE') or
(l_token = 'SORTBY_VIEW_ATTRIBUTE_NAME') or
(l_token = 'ADMIN_CUSTOMIZABLE') or
(l_token = 'INVOKE_FUNCTION_NAME') or
(l_token = 'EXPANSION') or
(l_token = 'ALS_MAX_LENGTH') or
(l_token = 'ATTRIBUTE_CATEGORY') or
(l_token = 'ATTRIBUTE1') or
(l_token = 'ATTRIBUTE2') or
(l_token = 'ATTRIBUTE3') or
(l_token = 'ATTRIBUTE4') or
(l_token = 'ATTRIBUTE5') or
(l_token = 'ATTRIBUTE6') or
(l_token = 'ATTRIBUTE7') or
(l_token = 'ATTRIBUTE8') or
(l_token = 'ATTRIBUTE9') or
(l_token = 'ATTRIBUTE10') or
(l_token = 'ATTRIBUTE11') or
(l_token = 'ATTRIBUTE12') or
(l_token = 'ATTRIBUTE13') or
(l_token = 'ATTRIBUTE14') or
(l_token = 'ATTRIBUTE15') or
(l_token = 'CREATED_BY') or
(l_token = 'CREATION_DATE') or
(l_token = 'LAST_UPDATED_BY') or
(l_token = 'OWNER') or
(l_token = 'LAST_UPDATE_DATE') or
(l_token = 'LAST_UPDATE_LOGIN') or
(l_token = 'ATTRIBUTE_LABEL_LONG') or
(l_token = 'ATTRIBUTE_LABEL_SHORT') or
(l_token = 'DESCRIPTION') then
l_column := l_token;
elsif (l_column = 'UPDATE_FLAG') then
l_item_rec.update_flag := 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);
(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_lov_relation_rec.last_updated_by := to_number(l_token);
l_lov_relation_rec.last_updated_by := FND_LOAD_UTIL.OWNER_ID(l_token);
elsif (l_column = 'LAST_UPDATE_DATE') then
l_lov_relation_rec.last_update_date := to_date(l_token,
AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
elsif (l_column = 'LAST_UPDATE_LOGIN') then
l_lov_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_category_usage_rec.last_updated_by := to_number(l_token);
l_category_usage_rec.last_updated_by := FND_LOAD_UTIL.OWNER_ID(l_token);
elsif (l_column = 'LAST_UPDATE_DATE') then
l_category_usage_rec.last_update_date := to_date(l_token,
AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
elsif (l_column = 'LAST_UPDATE_LOGIN') then
l_category_usage_rec.last_update_login := to_number(l_token);
(l_token = 'LAST_UPDATED_BY') 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_graph_rec.last_updated_by := to_number(l_token);
elsif (l_column = 'LAST_UPDATE_DATE') then
-- l_graph_rec.last_update_date := to_date(l_token,
-- AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
elsif (l_column = 'LAST_UPDATE_LOGIN') then
-- l_graph_rec.last_update_login := to_number(l_token);
/* REMOVE DELETE FUNCTIONALITY DURING UPLOAD
--Delete all region items under this region only when the
--jlt file was extracted in the REGION mode
if (AK_UPLOAD_GRP.G_EXTRACT_OBJ = 'REGION') then
for l_item_rec in l_get_region_item_csr(
l_region_tbl(l_index).region_application_id,
l_region_tbl(l_index).region_code) LOOP
AK_REGION_PVT.DELETE_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_region_application_id =>
l_region_tbl(l_index).region_application_id,
p_region_code => l_region_tbl(l_index).region_code,
p_attribute_application_id =>
l_item_rec.attribute_application_id,
p_attribute_code => l_item_rec.attribute_code,
p_delete_cascade => 'N');
if (AK_UPLOAD_GRP.G_UPDATE_MODE) then
AK_REGION_PVT.UPDATE_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_region_application_id =>
l_region_tbl(l_index).region_application_id,
p_region_code => l_region_tbl(l_index).region_code,
p_database_object_name =>l_region_tbl(l_index).database_object_name,
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_region_defaulting_api_pkg =>
l_region_tbl(l_index).region_defaulting_api_pkg,
p_region_defaulting_api_proc =>
l_region_tbl(l_index).region_defaulting_api_proc,
p_region_validation_api_pkg =>
l_region_tbl(l_index).region_validation_api_pkg,
p_region_validation_api_proc =>
l_region_tbl(l_index).region_validation_api_proc,
p_appmodule_object_type =>
l_region_tbl(l_index).applicationmodule_object_type,
p_num_rows_display =>
l_region_tbl(l_index).num_rows_display,
p_region_object_type =>
l_region_tbl(l_index).region_object_type,
p_image_file_name =>
l_region_tbl(l_index).image_file_name,
p_isform_flag => l_region_tbl(l_index).isform_flag,
p_help_target => l_region_tbl(l_index).help_target,
p_style_sheet_filename => l_region_tbl(l_index).style_sheet_filename,
p_version => l_region_tbl(l_index).version,
p_applicationmodule_usage_name => l_region_tbl(l_index).applicationmodule_usage_name,
p_add_indexed_children => l_region_tbl(l_index).add_indexed_children,
p_stateful_flag => l_region_tbl(l_index).stateful_flag,
p_function_name => l_region_tbl(l_index).function_name,
p_children_view_usage_name => l_region_tbl(l_index).children_view_usage_name,
p_search_panel => l_region_tbl(l_index).search_panel,
p_advanced_search_panel => l_region_tbl(l_index).advanced_search_panel,
p_customize_panel => l_region_tbl(l_index).customize_panel,
p_default_search_panel => l_region_tbl(l_index).default_search_panel,
p_results_based_search => l_region_tbl(l_index).results_based_search,
p_display_graph_table => l_region_tbl(l_index).display_graph_table,
p_disable_header => l_region_tbl(l_index).disable_header,
p_standalone => l_region_tbl(l_index).standalone,
p_auto_customization_criteria => l_region_tbl(l_index).auto_customization_criteria,
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_name => l_region_tbl(l_index).name,
p_description => l_region_tbl(l_index).description,
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
-- do not update customized data
select ar.last_updated_by, art.last_updated_by,
ar.last_update_date, art.last_update_date
into l_user_id1, l_user_id2, l_update1, l_update2
from ak_regions ar, ak_regions_tl art
where ar.region_code = l_region_tbl(l_index).region_code
and ar.region_application_id = l_region_tbl(l_index).region_application_id
and ar.region_code = art.region_code
and ar.region_application_id = art.region_application_id
and art.language = userenv('LANG');
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') and
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_id2,
p_last_update_date => l_region_tbl(l_index).last_update_date,
p_db_last_update_date => l_update2,
p_last_update_login => l_region_tbl(l_index).last_update_login,
p_create_or_update => 'UPDATE')) then
AK_REGION_PVT.UPDATE_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_region_application_id =>
l_region_tbl(l_index).region_application_id,
p_region_code => l_region_tbl(l_index).region_code,
p_database_object_name =>l_region_tbl(l_index).database_object_name,
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_region_defaulting_api_pkg =>
l_region_tbl(l_index).region_defaulting_api_pkg,
p_region_defaulting_api_proc =>
l_region_tbl(l_index).region_defaulting_api_proc,
p_region_validation_api_pkg =>
l_region_tbl(l_index).region_validation_api_pkg,
p_region_validation_api_proc =>
l_region_tbl(l_index).region_validation_api_proc,
p_appmodule_object_type =>
l_region_tbl(l_index).applicationmodule_object_type,
p_num_rows_display =>
l_region_tbl(l_index).num_rows_display,
p_region_object_type =>
l_region_tbl(l_index).region_object_type,
p_image_file_name =>
l_region_tbl(l_index).image_file_name,
p_isform_flag => l_region_tbl(l_index).isform_flag,
p_help_target => l_region_tbl(l_index).help_target,
p_style_sheet_filename => l_region_tbl(l_index).style_sheet_filename,
p_version => l_region_tbl(l_index).version,
p_applicationmodule_usage_name => l_region_tbl(l_index).applicationmodule_usage_name,
p_add_indexed_children => l_region_tbl(l_index).add_indexed_children,
p_stateful_flag => l_region_tbl(l_index).stateful_flag,
p_function_name => l_region_tbl(l_index).function_name,
p_children_view_usage_name => l_region_tbl(l_index).children_view_usage_name,
p_search_panel => l_region_tbl(l_index).search_panel,
p_advanced_search_panel => l_region_tbl(l_index).advanced_search_panel,
p_customize_panel => l_region_tbl(l_index).customize_panel,
p_default_search_panel => l_region_tbl(l_index).default_search_panel,
p_results_based_search => l_region_tbl(l_index).results_based_search,
p_display_graph_table => l_region_tbl(l_index).display_graph_table,
p_disable_header => l_region_tbl(l_index).disable_header,
p_standalone => l_region_tbl(l_index).standalone,
p_auto_customization_criteria => l_region_tbl(l_index).auto_customization_criteria,
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_name => l_region_tbl(l_index).name,
p_description => l_region_tbl(l_index).description,
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_NC_UPDATE_MODE*/
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
);
if (AK_UPLOAD_GRP.G_UPDATE_MODE) then
AK_REGION_PVT.UPDATE_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_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_display_sequence => l_item_tbl(l_index).display_sequence,
p_node_display_flag => l_item_tbl(l_index).node_display_flag,
p_node_query_flag => l_item_tbl(l_index).node_query_flag,
p_attribute_label_length =>
l_item_tbl(l_index).attribute_label_length,
p_display_value_length =>
l_item_tbl(l_index).display_value_length,
p_bold => l_item_tbl(l_index).bold,
p_italic => l_item_tbl(l_index).italic,
p_vertical_alignment => l_item_tbl(l_index).vertical_alignment,
p_horizontal_alignment => l_item_tbl(l_index).horizontal_alignment,
p_item_style => l_item_tbl(l_index).item_style,
p_object_attribute_flag =>l_item_tbl(l_index).object_attribute_flag,
p_icx_custom_call => l_item_tbl(l_index).icx_custom_call,
p_update_flag => l_item_tbl(l_index).update_flag,
p_required_flag => l_item_tbl(l_index).required_flag,
p_security_code => l_item_tbl(l_index).security_code,
p_default_value_varchar2 =>
l_item_tbl(l_index).default_value_varchar2,
p_default_value_number =>
l_item_tbl(l_index).default_value_number,
p_default_value_date =>
l_item_tbl(l_index).default_value_date,
p_lov_region_application_id =>
l_item_tbl(l_index).lov_region_application_id,
p_lov_region_code => l_item_tbl(l_index).lov_region_code,
p_lov_foreign_key_name => l_item_tbl(l_index).lov_foreign_key_name,
p_lov_attribute_application_id =>
l_item_tbl(l_index).lov_attribute_application_id,
p_lov_attribute_code => l_item_tbl(l_index).lov_attribute_code,
p_lov_default_flag => l_item_tbl(l_index).lov_default_flag,
p_region_defaulting_api_pkg =>
l_item_tbl(l_index).region_defaulting_api_pkg,
p_region_defaulting_api_proc =>
l_item_tbl(l_index).region_defaulting_api_proc,
p_region_validation_api_pkg =>
l_item_tbl(l_index).region_validation_api_pkg,
p_region_validation_api_proc =>
l_item_tbl(l_index).region_validation_api_proc,
p_order_sequence => l_item_tbl(l_index).order_sequence,
p_order_direction => l_item_tbl(l_index).order_direction,
p_display_height => l_item_tbl(l_index).display_height,
p_submit => l_item_tbl(l_index).submit,
p_encrypt => l_item_tbl(l_index).encrypt,
p_css_class_name => l_item_tbl(l_index).css_class_name,
p_view_usage_name =>l_item_tbl(l_index).view_usage_name,
p_view_attribute_name =>l_item_tbl(l_index).view_attribute_name,
p_nested_region_appl_id =>l_item_tbl(l_index).nested_region_application_id,
p_nested_region_code =>l_item_tbl(l_index).nested_region_code,
p_url =>l_item_tbl(l_index).url,
p_poplist_viewobject =>l_item_tbl(l_index).poplist_viewobject,
p_poplist_display_attr =>l_item_tbl(l_index).poplist_display_attr,
p_poplist_value_attr =>l_item_tbl(l_index).poplist_value_attr,
p_image_file_name =>l_item_tbl(l_index).image_file_name,
p_item_name =>l_item_tbl(l_index).item_name,
p_css_label_class_name => l_item_tbl(l_index).css_label_class_name,
p_menu_name => l_item_tbl(l_index).menu_name,
p_flexfield_name => l_item_tbl(l_index).flexfield_name,
p_flexfield_application_id => l_item_tbl(l_index).flexfield_application_id,
p_tabular_function_code => l_item_tbl(l_index).tabular_function_code,
p_tip_type => l_item_tbl(l_index).tip_type,
p_tip_message_name => l_item_tbl(l_index).tip_message_name,
p_tip_message_application_id => l_item_tbl(l_index).tip_message_application_id ,
p_flex_segment_list => l_item_tbl(l_index).flex_segment_list,
p_entity_id => l_item_tbl(l_index).entity_id,
p_anchor => l_item_tbl(l_index).anchor,
p_poplist_view_usage_name => l_item_tbl(l_index).poplist_view_usage_name,
p_user_customizable => l_item_tbl(l_index).user_customizable,
p_sortby_view_attribute_name => l_item_tbl(l_index).sortby_view_attribute_name,
p_admin_customizable => l_item_tbl(l_index).admin_customizable,
p_invoke_function_name => l_item_tbl(l_index).invoke_function_name,
p_expansion => l_item_tbl(l_index).expansion,
p_als_max_length => l_item_tbl(l_index).als_max_length,
p_initial_sort_sequence => l_item_tbl(l_index).initial_sort_sequence,
p_customization_application_id => l_item_tbl(l_index).customization_application_id,
p_customization_code => l_item_tbl(l_index).customization_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_attribute_label_long => l_item_tbl(l_index).attribute_label_long,
p_attribute_label_short =>l_item_tbl(l_index).attribute_label_short,
p_description =>l_item_tbl(l_index).description,
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
);
-- update non-customized data only
elsif ( AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE ) then
select ari.last_updated_by, arit.last_updated_by,
ari.last_update_date, arit.last_update_date
into l_user_id1, l_user_id2, l_update1, l_update2
from ak_region_items ari, ak_region_items_tl arit
where ari.region_code = l_item_tbl(l_index).region_code
and ari.region_application_id = l_item_tbl(l_index).region_application_id
and ari.attribute_code = l_item_tbl(l_index).attribute_code
and ari.attribute_application_id = l_item_tbl(l_index).attribute_application_id
and ari.region_code = arit.region_code
and ari.region_application_id = arit.region_application_id
and ari.attribute_code = arit.attribute_code
and ari.attribute_application_id = arit.attribute_application_id
and arit.language = userenv('LANG');
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') and
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_id2,
p_last_update_date => l_item_tbl(l_index).last_update_date,
p_db_last_update_date => l_update2,
p_last_update_login => l_item_tbl(l_index).last_update_login,
p_create_or_update => 'UPDATE')) then
AK_REGION_PVT.UPDATE_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_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_display_sequence => l_item_tbl(l_index).display_sequence,
p_node_display_flag => l_item_tbl(l_index).node_display_flag,
p_node_query_flag => l_item_tbl(l_index).node_query_flag,
p_attribute_label_length =>
l_item_tbl(l_index).attribute_label_length,
p_display_value_length =>
l_item_tbl(l_index).display_value_length,
p_bold => l_item_tbl(l_index).bold,
p_italic => l_item_tbl(l_index).italic,
p_vertical_alignment => l_item_tbl(l_index).vertical_alignment,
p_horizontal_alignment => l_item_tbl(l_index).horizontal_alignment,
p_item_style => l_item_tbl(l_index).item_style,
p_object_attribute_flag =>l_item_tbl(l_index).object_attribute_flag,
p_icx_custom_call => l_item_tbl(l_index).icx_custom_call,
p_update_flag => l_item_tbl(l_index).update_flag,
p_required_flag => l_item_tbl(l_index).required_flag,
p_security_code => l_item_tbl(l_index).security_code,
p_default_value_varchar2 =>
l_item_tbl(l_index).default_value_varchar2,
p_default_value_number =>
l_item_tbl(l_index).default_value_number,
p_default_value_date =>
l_item_tbl(l_index).default_value_date,
p_lov_region_application_id =>
l_item_tbl(l_index).lov_region_application_id,
p_lov_region_code => l_item_tbl(l_index).lov_region_code,
p_lov_foreign_key_name => l_item_tbl(l_index).lov_foreign_key_name,
p_lov_attribute_application_id =>
l_item_tbl(l_index).lov_attribute_application_id,
p_lov_attribute_code => l_item_tbl(l_index).lov_attribute_code,
p_lov_default_flag => l_item_tbl(l_index).lov_default_flag,
p_region_defaulting_api_pkg =>
l_item_tbl(l_index).region_defaulting_api_pkg,
p_region_defaulting_api_proc =>
l_item_tbl(l_index).region_defaulting_api_proc,
p_region_validation_api_pkg =>
l_item_tbl(l_index).region_validation_api_pkg,
p_region_validation_api_proc =>
l_item_tbl(l_index).region_validation_api_proc,
p_order_sequence => l_item_tbl(l_index).order_sequence,
p_order_direction => l_item_tbl(l_index).order_direction,
p_display_height => l_item_tbl(l_index).display_height,
p_submit => l_item_tbl(l_index).submit,
p_encrypt => l_item_tbl(l_index).encrypt,
p_css_class_name => l_item_tbl(l_index).css_class_name,
p_view_usage_name =>l_item_tbl(l_index).view_usage_name,
p_view_attribute_name =>l_item_tbl(l_index).view_attribute_name,
p_nested_region_appl_id =>l_item_tbl(l_index).nested_region_application_id,
p_nested_region_code =>l_item_tbl(l_index).nested_region_code,
p_url =>l_item_tbl(l_index).url,
p_poplist_viewobject =>l_item_tbl(l_index).poplist_viewobject,
p_poplist_display_attr =>l_item_tbl(l_index).poplist_display_attr,
p_poplist_value_attr =>l_item_tbl(l_index).poplist_value_attr,
p_image_file_name =>l_item_tbl(l_index).image_file_name,
p_item_name =>l_item_tbl(l_index).item_name,
p_css_label_class_name => l_item_tbl(l_index).css_label_class_name,
p_menu_name => l_item_tbl(l_index).menu_name,
p_flexfield_name => l_item_tbl(l_index).flexfield_name,
p_flexfield_application_id => l_item_tbl(l_index).flexfield_application_id,
p_tabular_function_code => l_item_tbl(l_index).tabular_function_code,
p_tip_type => l_item_tbl(l_index).tip_type,
p_tip_message_name => l_item_tbl(l_index).tip_message_name,
p_tip_message_application_id => l_item_tbl(l_index).tip_message_application_id ,
p_flex_segment_list => l_item_tbl(l_index).flex_segment_list,
p_entity_id => l_item_tbl(l_index).entity_id,
p_anchor => l_item_tbl(l_index).anchor,
p_poplist_view_usage_name => l_item_tbl(l_index).poplist_view_usage_name,
p_user_customizable => l_item_tbl(l_index).user_customizable,
p_sortby_view_attribute_name => l_item_tbl(l_index).sortby_view_attribute_name,
p_admin_customizable => l_item_tbl(l_index).admin_customizable,
p_invoke_function_name => l_item_tbl(l_index).invoke_function_name,
p_expansion => l_item_tbl(l_index).expansion,
p_als_max_length => l_item_tbl(l_index).als_max_length,
p_initial_sort_sequence => l_item_tbl(l_index).initial_sort_sequence,
p_customization_application_id => l_item_tbl(l_index).customization_application_id,
p_customization_code => l_item_tbl(l_index).customization_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_attribute_label_long => l_item_tbl(l_index).attribute_label_long,
p_attribute_label_short =>l_item_tbl(l_index).attribute_label_short,
p_description => l_item_tbl(l_index).description,
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_update_flag => l_item_tbl(l_index).update_flag,
p_required_flag => l_item_tbl(l_index).required_flag,
p_security_code => l_item_tbl(l_index).security_code,
p_default_value_varchar2 =>
l_item_tbl(l_index).default_value_varchar2,
p_default_value_number =>
l_item_tbl(l_index).default_value_number,
p_default_value_date =>
l_item_tbl(l_index).default_value_date,
p_lov_region_application_id =>
l_item_tbl(l_index).lov_region_application_id,
p_lov_region_code => l_item_tbl(l_index).lov_region_code,
p_lov_foreign_key_name => l_item_tbl(l_index).lov_foreign_key_name,
p_lov_attribute_application_id =>
l_item_tbl(l_index).lov_attribute_application_id,
p_lov_attribute_code => l_item_tbl(l_index).lov_attribute_code,
p_lov_default_flag => l_item_tbl(l_index).lov_default_flag,
p_region_defaulting_api_pkg =>
l_item_tbl(l_index).region_defaulting_api_pkg,
p_region_defaulting_api_proc =>
l_item_tbl(l_index).region_defaulting_api_proc,
p_region_validation_api_pkg =>
l_item_tbl(l_index).region_validation_api_pkg,
p_region_validation_api_proc =>
l_item_tbl(l_index).region_validation_api_proc,
p_order_sequence => l_item_tbl(l_index).order_sequence,
p_order_direction => l_item_tbl(l_index).order_direction,
p_display_height => l_item_tbl(l_index).display_height,
p_submit => l_item_tbl(l_index).submit,
p_encrypt => l_item_tbl(l_index).encrypt,
p_css_class_name => l_item_tbl(l_index).css_class_name,
p_view_usage_name =>l_item_tbl(l_index).view_usage_name,
p_view_attribute_name =>l_item_tbl(l_index).view_attribute_name,
p_nested_region_appl_id =>l_item_tbl(l_index).nested_region_application_id,
p_nested_region_code =>l_item_tbl(l_index).nested_region_code,
p_url =>l_item_tbl(l_index).url,
p_poplist_viewobject =>l_item_tbl(l_index).poplist_viewobject,
p_poplist_display_attr =>l_item_tbl(l_index).poplist_display_attr,
p_poplist_value_attr =>l_item_tbl(l_index).poplist_value_attr,
p_image_file_name =>l_item_tbl(l_index).image_file_name,
p_item_name => l_item_tbl(l_index).item_name,
p_css_label_class_name => l_item_tbl(l_index).css_label_class_name,
p_menu_name => l_item_tbl(l_index).menu_name,
p_flexfield_name => l_item_tbl(l_index).flexfield_name,
p_flexfield_application_id => l_item_tbl(l_index).flexfield_application_id,
p_tabular_function_code => l_item_tbl(l_index).tabular_function_code,
p_tip_type => l_item_tbl(l_index).tip_type,
p_tip_message_name => l_item_tbl(l_index).tip_message_name,
p_tip_message_application_id => l_item_tbl(l_index).tip_message_application_id ,
p_flex_segment_list => l_item_tbl(l_index).flex_segment_list,
p_entity_id => l_item_tbl(l_index).entity_id ,
p_anchor => l_item_tbl(l_index).anchor,
p_poplist_view_usage_name => l_item_tbl(l_index).poplist_view_usage_name,
p_user_customizable => l_item_tbl(l_index).user_customizable,
p_sortby_view_attribute_name => l_item_tbl(l_index).sortby_view_attribute_name,
p_admin_customizable => l_item_tbl(l_index).admin_customizable,
p_invoke_function_name => l_item_tbl(l_index).invoke_function_name,
p_expansion => l_item_tbl(l_index).expansion,
p_als_max_length => l_item_tbl(l_index).als_max_length,
p_initial_sort_sequence => l_item_tbl(l_index).initial_sort_sequence,
p_customization_application_id => l_item_tbl(l_index).customization_application_id,
p_customization_code => l_item_tbl(l_index).customization_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_attribute_label_long => l_item_tbl(l_index).attribute_label_long,
p_attribute_label_short =>l_item_tbl(l_index).attribute_label_short,
p_description => l_item_tbl(l_index).description,
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
);
-- no customized data in this table, do not update if G_NO_UPDATE_MODE
--
if (AK_UPLOAD_GRP.G_UPDATE_MODE or AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE) then
AK_REGION2_PVT.UPDATE_LOV_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_region_application_id =>
l_lov_relation_tbl(l_index).region_application_id,
p_region_code => l_lov_relation_tbl(l_index).region_code,
p_attribute_application_id =>
l_lov_relation_tbl(l_index).attribute_application_id,
p_attribute_code => l_lov_relation_tbl(l_index).attribute_code,
p_lov_region_appl_id => l_lov_relation_tbl(l_index).lov_region_appl_id,
p_lov_region_code => l_lov_relation_tbl(l_index).lov_region_code,
p_lov_attribute_appl_id => l_lov_relation_tbl(l_index).lov_attribute_appl_id,
p_lov_attribute_code => l_lov_relation_tbl(l_index).lov_attribute_code,
p_base_attribute_appl_id => l_lov_relation_tbl(l_index).base_attribute_appl_id,
p_base_attribute_code => l_lov_relation_tbl(l_index).base_attribute_code,
p_direction_flag => l_lov_relation_tbl(l_index).direction_flag,
p_base_region_appl_id => l_lov_relation_tbl(l_index).base_region_appl_id,
p_base_region_code => l_lov_relation_tbl(l_index).base_region_code,
p_required_flag => l_lov_relation_tbl(l_index).required_flag,
p_created_by => l_lov_relation_tbl(l_index).created_by,
p_creation_date => l_lov_relation_tbl(l_index).creation_date,
p_last_updated_by => l_lov_relation_tbl(l_index).last_updated_by,
p_last_update_date => l_lov_relation_tbl(l_index).last_update_date,
p_last_update_login => l_lov_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
);
p_last_updated_by => l_lov_relation_tbl(l_index).last_updated_by,
p_last_update_date => l_lov_relation_tbl(l_index).last_update_date,
p_last_update_login => l_lov_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
);
p_last_updated_by => l_category_usage_tbl(l_index).last_updated_by,
p_last_update_date => l_category_usage_tbl(l_index).last_update_date,
p_last_update_login => l_category_usage_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_REGION2_PVT.UPDATE_CATEGORY_USAGE (
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_region_application_id =>
l_category_usage_tbl(l_index).region_application_id,
p_region_code => l_category_usage_tbl(l_index).region_code,
p_attribute_application_id =>
l_category_usage_tbl(l_index).attribute_application_id,
p_attribute_code => l_category_usage_tbl(l_index).attribute_code,
p_category_name => l_category_usage_tbl(l_index).category_name,
p_category_id => l_category_usage_tbl(l_index).category_id,
p_application_id => l_category_usage_tbl(l_index).application_id,
p_show_all => l_category_usage_tbl(l_index).show_all,
p_created_by => l_category_usage_tbl(l_index).created_by,
p_creation_date => l_category_usage_tbl(l_index).creation_date,
p_last_updated_by => l_category_usage_tbl(l_index).last_updated_by,
p_last_update_date => l_category_usage_tbl(l_index).last_update_date,
p_last_update_login => l_category_usage_tbl(l_index).last_update_login,
p_loader_timestamp => p_loader_timestamp,
p_pass => p_pass,
p_copy_redo_flag => l_copy_redo_flag
);
if (AK_UPLOAD_GRP.G_UPDATE_MODE) then
AK_REGION_PVT.UPDATE_GRAPH (
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_region_application_id =>l_graph_tbl(l_index).region_application_id,
p_region_code => l_graph_tbl(l_index).region_code,
p_graph_number => l_graph_tbl(l_index).graph_number,
p_graph_style => l_graph_tbl(l_index).graph_style,
p_display_flag => l_graph_tbl(l_index).display_flag,
p_depth_radius => l_graph_tbl(l_index).depth_radius,
p_graph_title => l_graph_tbl(l_index).graph_title,
p_y_axis_label => l_graph_tbl(l_index).y_axis_label,
p_created_by => l_graph_tbl(l_index).created_by,
p_creation_date => l_graph_tbl(l_index).creation_date,
p_last_updated_by => l_graph_tbl(l_index).last_updated_by,
p_last_update_date => l_graph_tbl(l_index).last_update_date,
p_last_update_login => l_graph_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 arg.last_updated_by, argt.last_updated_by into l_user_id1, l_user_id2
from ak_region_graphs arg, ak_region_graphs_tl argt
where arg.region_code = l_graph_tbl(l_index).region_code
and arg.region_application_id = l_graph_tbl(l_index).region_application_id
and arg.graph_number = l_graph_tbl(l_index).graph_number
and arg.region_code = argt.region_code
and arg.region_application_id = argt.region_application_id
and arg.graph_number = argt.graph_number
and argt.language = userenv('LANG');
AK_REGION_PVT.UPDATE_GRAPH (
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_region_application_id =>l_graph_tbl(l_index).region_application_id,
p_region_code => l_graph_tbl(l_index).region_code,
p_graph_number => l_graph_tbl(l_index).graph_number,
p_graph_style => l_graph_tbl(l_index).graph_style,
p_display_flag => l_graph_tbl(l_index).display_flag,
p_depth_Radius => l_graph_tbl(l_index).depth_radius,
p_graph_title => l_graph_tbl(l_index).graph_title,
p_y_axis_label => l_graph_tbl(l_index).y_axis_label,
p_created_by => l_graph_tbl(l_index).created_by,
p_creation_date => l_graph_tbl(l_index).creation_date,
p_last_updated_by => l_graph_tbl(l_index).last_updated_by,
p_last_update_date => l_graph_tbl(l_index).last_update_date,
p_last_update_login => l_graph_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_graph_tbl(l_index).last_updated_by,
p_last_update_date => l_graph_tbl(l_index).last_update_date,
p_last_update_login => l_graph_tbl(l_index).last_update_login,
p_loader_timestamp => p_loader_timestamp,
p_pass => p_pass,
p_copy_redo_flag => l_copy_redo_flag
);
if (AK_UPLOAD_GRP.G_UPDATE_MODE) then
AK_REGION2_PVT.UPDATE_GRAPH_COLUMN (
p_validation_level => p_validation_level,
p_api_version_number => 1.0,
p_msg_count => l_msg_count,
p_msg_data => l_msg_data,
p_return_status => l_return_status,
p_region_application_id =>l_graph_column_tbl(l_index).region_application_id,
p_region_code => l_graph_column_tbl(l_index).region_code,
p_graph_number => l_graph_column_tbl(l_index).graph_number,
p_attribute_application_id => l_graph_column_tbl(l_index).attribute_application_id,
p_attribute_code => l_graph_column_tbl(l_index).attribute_code,
p_created_by => l_graph_column_tbl(l_index).created_by,
p_creation_date => l_graph_column_tbl(l_index).creation_date,
p_last_updated_by => l_graph_column_tbl(l_index).last_updated_by,
p_last_update_date => l_graph_column_tbl(l_index).last_update_date,
p_last_update_login => l_graph_column_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 into l_user_id1
from ak_region_graph_columns
where region_code = l_graph_column_tbl(l_index).region_code
and region_application_id = l_graph_column_tbl(l_index).region_application_id
and graph_number = l_graph_column_tbl(l_index).graph_number
and attribute_application_id = l_graph_column_tbl(l_index).attribute_application_id
and attribute_code = l_graph_column_tbl(l_index).attribute_code;
AK_REGION2_PVT.UPDATE_GRAPH_COLUMN (
p_validation_level => p_validation_level,
p_api_version_number => 1.0,
p_msg_count => l_msg_count,
p_msg_data => l_msg_data,
p_return_status => l_return_status,
p_region_application_id => l_graph_column_tbl(l_index).region_application_id,
p_region_code => l_graph_column_tbl(l_index).region_code,
p_graph_number => l_graph_column_tbl(l_index).graph_number,
p_attribute_application_id => l_graph_column_tbl(l_index).attribute_application_id,
p_attribute_code => l_graph_column_tbl(l_index).attribute_code,
p_created_by => l_graph_column_tbl(l_index).created_by,
p_creation_date => l_graph_column_tbl(l_index).creation_date,
p_last_updated_by => l_graph_column_tbl(l_index).last_updated_by,
p_last_update_date => l_graph_column_tbl(l_index).last_update_date,
p_last_update_login => l_graph_column_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_graph_column_tbl(l_index).last_updated_by,
p_last_update_date => l_graph_column_tbl(l_index).last_update_date,
p_last_update_login => l_graph_column_tbl(l_index).last_update_login,
p_loader_timestamp => p_loader_timestamp,
p_pass => p_pass,
p_copy_redo_flag => l_copy_redo_flag
);
l_update1 DATE;
l_update2 DATE;
AK_REGION_PVT.UPDATE_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_region_application_id =>
G_REGION_REDO_TBL(l_index).region_application_id,
p_region_code => G_REGION_REDO_TBL(l_index).region_code,
p_database_object_name =>G_REGION_REDO_TBL(l_index).database_object_name,
p_region_style => G_REGION_REDO_TBL(l_index).region_style,
p_num_columns => G_REGION_REDO_TBL(l_index).num_columns,
p_icx_custom_call => G_REGION_REDO_TBL(l_index).icx_custom_call,
p_region_defaulting_api_pkg =>
G_REGION_REDO_TBL(l_index).region_defaulting_api_pkg,
p_region_defaulting_api_proc =>
G_REGION_REDO_TBL(l_index).region_defaulting_api_proc,
p_region_validation_api_pkg =>
G_REGION_REDO_TBL(l_index).region_validation_api_pkg,
p_region_validation_api_proc =>
G_REGION_REDO_TBL(l_index).region_validation_api_proc,
p_appmodule_object_type =>
G_REGION_REDO_TBL(l_index).applicationmodule_object_type,
p_num_rows_display =>
G_REGION_REDO_TBL(l_index).num_rows_display,
p_region_object_type =>
G_REGION_REDO_TBL(l_index).region_object_type,
p_image_file_name =>
G_REGION_REDO_TBL(l_index).image_file_name,
p_isform_flag => G_REGION_REDO_TBL(l_index).isform_flag,
p_help_target => G_REGION_REDO_TBL(l_index).help_target,
p_style_sheet_filename => G_REGION_REDO_TBL(l_index).style_sheet_filename,
p_version => G_REGION_REDO_TBL(l_index).version,
p_applicationmodule_usage_name => G_REGION_REDO_TBL(l_index).applicationmodule_usage_name,
p_add_indexed_children => G_REGION_REDO_TBL(l_index).add_indexed_children,
p_stateful_flag => G_REGION_REDO_TBL(l_index).stateful_flag,
p_function_name => G_REGION_REDO_TBL(l_index).function_name,
p_children_view_usage_name => G_REGION_REDO_TBL(l_index).children_view_usage_name,
p_search_panel => G_REGION_REDO_TBL(l_index).search_panel,
p_advanced_search_panel => G_REGION_REDO_TBL(l_index).advanced_search_panel,
p_customize_panel => G_REGION_REDO_TBL(l_index).customize_panel,
p_default_search_panel => G_REGION_REDO_TBL(l_index).default_search_panel,
p_results_based_search => G_REGION_REDO_TBL(l_index).results_based_search,
p_display_graph_table => G_REGION_REDO_TBL(l_index).display_graph_table,
p_disable_header => G_REGION_REDO_TBL(l_index).disable_header,
p_standalone => G_REGION_REDO_TBL(l_index).standalone,
p_auto_customization_criteria => G_REGION_REDO_TBL(l_index).auto_customization_criteria,
p_attribute_category => G_REGION_REDO_TBL(l_index).attribute_category,
p_attribute1 => G_REGION_REDO_TBL(l_index).attribute1,
p_attribute2 => G_REGION_REDO_TBL(l_index).attribute2,
p_attribute3 => G_REGION_REDO_TBL(l_index).attribute3,
p_attribute4 => G_REGION_REDO_TBL(l_index).attribute4,
p_attribute5 => G_REGION_REDO_TBL(l_index).attribute5,
p_attribute6 => G_REGION_REDO_TBL(l_index).attribute6,
p_attribute7 => G_REGION_REDO_TBL(l_index).attribute7,
p_attribute8 => G_REGION_REDO_TBL(l_index).attribute8,
p_attribute9 => G_REGION_REDO_TBL(l_index).attribute9,
p_attribute10 => G_REGION_REDO_TBL(l_index).attribute10,
p_attribute11 => G_REGION_REDO_TBL(l_index).attribute11,
p_attribute12 => G_REGION_REDO_TBL(l_index).attribute12,
p_attribute13 => G_REGION_REDO_TBL(l_index).attribute13,
p_attribute14 => G_REGION_REDO_TBL(l_index).attribute14,
p_attribute15 => G_REGION_REDO_TBL(l_index).attribute15,
p_name => G_REGION_REDO_TBL(l_index).name,
p_description => G_REGION_REDO_TBL(l_index).description,
p_created_by => G_REGION_REDO_TBL(l_index).created_by,
p_creation_date => G_REGION_REDO_TBL(l_index).creation_date,
p_last_updated_by => G_REGION_REDO_TBL(l_index).last_updated_by,
p_last_update_date => G_REGION_REDO_TBL(l_index).last_update_date,
p_last_update_login => G_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_REGION_REDO_TBL(l_index).last_updated_by,
p_last_update_date => G_REGION_REDO_TBL(l_index).last_update_date,
p_last_update_login => G_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
);
if (AK_UPLOAD_GRP.G_UPDATE_MODE) then
AK_REGION_PVT.UPDATE_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_region_application_id =>G_ITEM_REDO_TBL(l_index).region_application_id,
p_region_code => G_ITEM_REDO_TBL(l_index).region_code,
p_attribute_application_id =>
G_ITEM_REDO_TBL(l_index).attribute_application_id,
p_attribute_code => G_ITEM_REDO_TBL(l_index).attribute_code,
p_display_sequence => G_ITEM_REDO_TBL(l_index).display_sequence,
p_node_display_flag => G_ITEM_REDO_TBL(l_index).node_display_flag,
p_node_query_flag => G_ITEM_REDO_TBL(l_index).node_query_flag,
p_attribute_label_length =>
G_ITEM_REDO_TBL(l_index).attribute_label_length,
p_display_value_length =>
G_ITEM_REDO_TBL(l_index).display_value_length,
p_bold => G_ITEM_REDO_TBL(l_index).bold,
p_italic => G_ITEM_REDO_TBL(l_index).italic,
p_vertical_alignment => G_ITEM_REDO_TBL(l_index).vertical_alignment,
p_horizontal_alignment => G_ITEM_REDO_TBL(l_index).horizontal_alignment,
p_item_style => G_ITEM_REDO_TBL(l_index).item_style,
p_object_attribute_flag =>G_ITEM_REDO_TBL(l_index).object_attribute_flag,
p_icx_custom_call => G_ITEM_REDO_TBL(l_index).icx_custom_call,
p_update_flag => G_ITEM_REDO_TBL(l_index).update_flag,
p_required_flag => G_ITEM_REDO_TBL(l_index).required_flag,
p_security_code => G_ITEM_REDO_TBL(l_index).security_code,
p_default_value_varchar2 =>
G_ITEM_REDO_TBL(l_index).default_value_varchar2,
p_default_value_number =>
G_ITEM_REDO_TBL(l_index).default_value_number,
p_default_value_date =>
G_ITEM_REDO_TBL(l_index).default_value_date,
p_lov_region_application_id =>
G_ITEM_REDO_TBL(l_index).lov_region_application_id,
p_lov_region_code => G_ITEM_REDO_TBL(l_index).lov_region_code,
p_lov_foreign_key_name => G_ITEM_REDO_TBL(l_index).lov_foreign_key_name,
p_lov_attribute_application_id =>
G_ITEM_REDO_TBL(l_index).lov_attribute_application_id,
p_lov_attribute_code => G_ITEM_REDO_TBL(l_index).lov_attribute_code,
p_lov_default_flag => G_ITEM_REDO_TBL(l_index).lov_default_flag,
p_region_defaulting_api_pkg =>
G_ITEM_REDO_TBL(l_index).region_defaulting_api_pkg,
p_region_defaulting_api_proc =>
G_ITEM_REDO_TBL(l_index).region_defaulting_api_proc,
p_region_validation_api_pkg =>
G_ITEM_REDO_TBL(l_index).region_validation_api_pkg,
p_region_validation_api_proc =>
G_ITEM_REDO_TBL(l_index).region_validation_api_proc,
p_order_sequence => G_ITEM_REDO_TBL(l_index).order_sequence,
p_order_direction => G_ITEM_REDO_TBL(l_index).order_direction,
p_display_height => G_ITEM_REDO_TBL(l_index).display_height,
p_submit => G_ITEM_REDO_TBL(l_index).submit,
p_encrypt => G_ITEM_REDO_TBL(l_index).encrypt,
p_css_class_name => G_ITEM_REDO_TBL(l_index).css_class_name,
p_view_usage_name => G_ITEM_REDO_TBL(l_index).view_usage_name,
p_view_attribute_name => G_ITEM_REDO_TBL(l_index).view_attribute_name,
p_nested_region_appl_id => G_ITEM_REDO_TBL(l_index).nested_region_application_id,
p_nested_region_code => G_ITEM_REDO_TBL(l_index).nested_region_code,
p_url => G_ITEM_REDO_TBL(l_index).url,
p_poplist_viewobject => G_ITEM_REDO_TBL(l_index).poplist_viewobject,
p_poplist_display_attr => G_ITEM_REDO_TBL(l_index).poplist_display_attr,
p_poplist_value_attr => G_ITEM_REDO_TBL(l_index).poplist_value_attr,
p_image_file_name => G_ITEM_REDO_TBL(l_index).image_file_name,
p_item_name => G_ITEM_REDO_TBL(l_index).description,
p_css_label_class_name => G_ITEM_REDO_TBL(l_index).css_label_class_name,
p_menu_name => G_ITEM_REDO_TBL(l_index).menu_name,
p_flexfield_name => G_ITEM_REDO_TBL(l_index).flexfield_name,
p_flexfield_application_id => G_ITEM_REDO_TBL(l_index).flexfield_application_id,
p_tabular_function_code => G_ITEM_REDO_TBL(l_index).tabular_function_code,
p_tip_type => G_ITEM_REDO_TBL(l_index).tip_type,
p_tip_message_name => G_ITEM_REDO_TBL(l_index).tip_message_name,
p_tip_message_application_id => G_ITEM_REDO_TBL(l_index).tip_message_application_id ,
p_flex_segment_list => G_ITEM_REDO_TBL(l_index).flex_segment_list,
p_entity_id => G_ITEM_REDO_TBL(l_index).entity_id ,
p_anchor => G_ITEM_REDO_TBL(l_index).anchor,
p_poplist_view_usage_name => G_ITEM_REDO_TBL(l_index).poplist_view_usage_name,
p_user_customizable => G_ITEM_REDO_TBL(l_index).user_customizable,
p_sortby_view_attribute_name => G_ITEM_REDO_TBL(l_index).sortby_view_attribute_name,
p_admin_customizable => G_ITEM_REDO_TBL(l_index).admin_customizable,
p_invoke_function_name => G_ITEM_REDO_TBL(l_index).invoke_function_name,
p_expansion => G_ITEM_REDO_TBL(l_index).expansion,
p_als_max_length => G_ITEM_REDO_TBL(l_index).als_max_length,
p_initial_sort_sequence => G_ITEM_REDO_TBL(l_index).initial_sort_sequence,
p_customization_application_id => G_ITEM_REDO_TBL(l_index).customization_application_id,
p_customization_code => G_ITEM_REDO_TBL(l_index).customization_code,
p_attribute_category => G_ITEM_REDO_TBL(l_index).attribute_category,
p_attribute1 => G_ITEM_REDO_TBL(l_index).attribute1,
p_attribute2 => G_ITEM_REDO_TBL(l_index).attribute2,
p_attribute3 => G_ITEM_REDO_TBL(l_index).attribute3,
p_attribute4 => G_ITEM_REDO_TBL(l_index).attribute4,
p_attribute5 => G_ITEM_REDO_TBL(l_index).attribute5,
p_attribute6 => G_ITEM_REDO_TBL(l_index).attribute6,
p_attribute7 => G_ITEM_REDO_TBL(l_index).attribute7,
p_attribute8 => G_ITEM_REDO_TBL(l_index).attribute8,
p_attribute9 => G_ITEM_REDO_TBL(l_index).attribute9,
p_attribute10 => G_ITEM_REDO_TBL(l_index).attribute10,
p_attribute11 => G_ITEM_REDO_TBL(l_index).attribute11,
p_attribute12 => G_ITEM_REDO_TBL(l_index).attribute12,
p_attribute13 => G_ITEM_REDO_TBL(l_index).attribute13,
p_attribute14 => G_ITEM_REDO_TBL(l_index).attribute14,
p_attribute15 => G_ITEM_REDO_TBL(l_index).attribute15,
p_attribute_label_long => G_ITEM_REDO_TBL(l_index).attribute_label_long,
p_attribute_label_short =>G_ITEM_REDO_TBL(l_index).attribute_label_short,
p_description => G_ITEM_REDO_TBL(l_index).description,
p_created_by => G_ITEM_REDO_TBL(l_index).created_by,
p_creation_date => G_ITEM_REDO_TBL(l_index).creation_date,
p_last_updated_by => G_ITEM_REDO_TBL(l_index).last_updated_by,
p_last_update_date => G_ITEM_REDO_TBL(l_index).last_update_date,
p_last_update_login => G_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
);
elsif ( AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE ) then
select ari.last_updated_by, arit.last_updated_by,
ari.last_update_date, arit.last_update_date
into l_user_id1, l_user_id2, l_update1, l_update2
from ak_region_items ari, ak_region_items_tl arit
where ari.region_code = G_ITEM_REDO_TBL(l_index).region_code
and ari.region_application_id = G_ITEM_REDO_TBL(l_index).region_application_id
and ari.attribute_code = G_ITEM_REDO_TBL(l_index).attribute_code
and ari.attribute_application_id = G_ITEM_REDO_TBL(l_index).attribute_application_id
and ari.region_code = arit.region_code
and ari.region_application_id = arit.region_application_id
and ari.attribute_code = arit.attribute_code
and ari.attribute_application_id = arit.attribute_application_id
and arit.language = userenv('LANG');
if (AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
p_loader_timestamp => p_loader_timestamp,
p_created_by => G_ITEM_REDO_TBL(l_index).created_by,
p_creation_date => G_ITEM_REDO_TBL(l_index).creation_date,
p_last_updated_by => G_ITEM_REDO_TBL(l_index).last_updated_by,
p_db_last_updated_by => l_user_id1,
p_last_update_date => G_ITEM_REDO_TBL(l_index).last_update_date,
p_db_last_update_date => l_update1,
p_last_update_login => G_ITEM_REDO_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 => G_ITEM_REDO_TBL(l_index).created_by,
p_creation_date => G_ITEM_REDO_TBL(l_index).creation_date,
p_last_updated_by => G_ITEM_REDO_TBL(l_index).last_updated_by,
p_db_last_updated_by => l_user_id2,
p_last_update_date => G_ITEM_REDO_TBL(l_index).last_update_date,
p_db_last_update_date => l_update2,
p_last_update_login => G_ITEM_REDO_TBL(l_index).last_update_login,
p_create_or_update => 'UPDATE')) then
AK_REGION_PVT.UPDATE_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_region_application_id =>G_ITEM_REDO_TBL(l_index).region_application_id,
p_region_code => G_ITEM_REDO_TBL(l_index).region_code,
p_attribute_application_id =>
G_ITEM_REDO_TBL(l_index).attribute_application_id,
p_attribute_code => G_ITEM_REDO_TBL(l_index).attribute_code,
p_display_sequence => G_ITEM_REDO_TBL(l_index).display_sequence,
p_node_display_flag => G_ITEM_REDO_TBL(l_index).node_display_flag,
p_node_query_flag => G_ITEM_REDO_TBL(l_index).node_query_flag,
p_attribute_label_length =>
G_ITEM_REDO_TBL(l_index).attribute_label_length,
p_display_value_length =>
G_ITEM_REDO_TBL(l_index).display_value_length,
p_bold => G_ITEM_REDO_TBL(l_index).bold,
p_italic => G_ITEM_REDO_TBL(l_index).italic,
p_vertical_alignment => G_ITEM_REDO_TBL(l_index).vertical_alignment,
p_horizontal_alignment => G_ITEM_REDO_TBL(l_index).horizontal_alignment,
p_item_style => G_ITEM_REDO_TBL(l_index).item_style,
p_object_attribute_flag =>G_ITEM_REDO_TBL(l_index).object_attribute_flag,
p_icx_custom_call => G_ITEM_REDO_TBL(l_index).icx_custom_call,
p_update_flag => G_ITEM_REDO_TBL(l_index).update_flag,
p_required_flag => G_ITEM_REDO_TBL(l_index).required_flag,
p_security_code => G_ITEM_REDO_TBL(l_index).security_code,
p_default_value_varchar2 =>
G_ITEM_REDO_TBL(l_index).default_value_varchar2,
p_default_value_number =>
G_ITEM_REDO_TBL(l_index).default_value_number,
p_default_value_date =>
G_ITEM_REDO_TBL(l_index).default_value_date,
p_lov_region_application_id =>
G_ITEM_REDO_TBL(l_index).lov_region_application_id,
p_lov_region_code => G_ITEM_REDO_TBL(l_index).lov_region_code,
p_lov_foreign_key_name => G_ITEM_REDO_TBL(l_index).lov_foreign_key_name,
p_lov_attribute_application_id =>
G_ITEM_REDO_TBL(l_index).lov_attribute_application_id,
p_lov_attribute_code => G_ITEM_REDO_TBL(l_index).lov_attribute_code,
p_lov_default_flag => G_ITEM_REDO_TBL(l_index).lov_default_flag,
p_region_defaulting_api_pkg =>
G_ITEM_REDO_TBL(l_index).region_defaulting_api_pkg,
p_region_defaulting_api_proc =>
G_ITEM_REDO_TBL(l_index).region_defaulting_api_proc,
p_region_validation_api_pkg =>
G_ITEM_REDO_TBL(l_index).region_validation_api_pkg,
p_region_validation_api_proc =>
G_ITEM_REDO_TBL(l_index).region_validation_api_proc,
p_order_sequence => G_ITEM_REDO_TBL(l_index).order_sequence,
p_order_direction => G_ITEM_REDO_TBL(l_index).order_direction,
p_display_height => G_ITEM_REDO_TBL(l_index).display_height,
p_submit => G_ITEM_REDO_TBL(l_index).submit,
p_encrypt => G_ITEM_REDO_TBL(l_index).encrypt,
p_css_class_name => G_ITEM_REDO_TBL(l_index).css_class_name,
p_view_usage_name => G_ITEM_REDO_TBL(l_index).view_usage_name,
p_view_attribute_name => G_ITEM_REDO_TBL(l_index).view_attribute_name,
p_nested_region_appl_id => G_ITEM_REDO_TBL(l_index).nested_region_application_id,
p_nested_region_code => G_ITEM_REDO_TBL(l_index).nested_region_code,
p_url => G_ITEM_REDO_TBL(l_index).url,
p_poplist_viewobject => G_ITEM_REDO_TBL(l_index).poplist_viewobject,
p_poplist_display_attr => G_ITEM_REDO_TBL(l_index).poplist_display_attr,
p_poplist_value_attr => G_ITEM_REDO_TBL(l_index).poplist_value_attr,
p_image_file_name => G_ITEM_REDO_TBL(l_index).image_file_name,
p_item_name => G_ITEM_REDO_TBL(l_index).item_name,
p_css_label_class_name => G_ITEM_REDO_TBL(l_index).css_label_class_name,
p_menu_name => G_ITEM_REDO_TBL(l_index).menu_name,
p_flexfield_name => G_ITEM_REDO_TBL(l_index).flexfield_name,
p_flexfield_application_id => G_ITEM_REDO_TBL(l_index).flexfield_application_id,
p_tabular_function_code => G_ITEM_REDO_TBL(l_index).tabular_function_code,
p_tip_type => G_ITEM_REDO_TBL(l_index).tip_type,
p_tip_message_name => G_ITEM_REDO_TBL(l_index).tip_message_name,
p_tip_message_application_id => G_ITEM_REDO_TBL(l_index).tip_message_application_id ,
p_flex_segment_list => G_ITEM_REDO_TBL(l_index).flex_segment_list,
p_entity_id => G_ITEM_REDO_TBL(l_index).entity_id ,
p_anchor => G_ITEM_REDO_TBL(l_index).anchor,
p_poplist_view_usage_name => G_ITEM_REDO_TBL(l_index).poplist_view_usage_name,
p_user_customizable => G_ITEM_REDO_TBL(l_index).user_customizable,
p_sortby_view_attribute_name => G_ITEM_REDO_TBL(l_index).sortby_view_attribute_name,
p_admin_customizable => G_ITEM_REDO_TBL(l_index).admin_customizable,
p_invoke_function_name => G_ITEM_REDO_TBL(l_index).invoke_function_name,
p_expansion => G_ITEM_REDO_TBL(l_index).expansion,
p_als_max_length => G_ITEM_REDO_TBL(l_index).als_max_length,
p_initial_sort_sequence => G_ITEM_REDO_TBL(l_index).initial_sort_sequence,
p_customization_application_id => G_ITEM_REDO_TBL(l_index).customization_application_id,
p_customization_code => G_ITEM_REDO_TBL(l_index).customization_code,
p_attribute_category => G_ITEM_REDO_TBL(l_index).attribute_category,
p_attribute1 => G_ITEM_REDO_TBL(l_index).attribute1,
p_attribute2 => G_ITEM_REDO_TBL(l_index).attribute2,
p_attribute3 => G_ITEM_REDO_TBL(l_index).attribute3,
p_attribute4 => G_ITEM_REDO_TBL(l_index).attribute4,
p_attribute5 => G_ITEM_REDO_TBL(l_index).attribute5,
p_attribute6 => G_ITEM_REDO_TBL(l_index).attribute6,
p_attribute7 => G_ITEM_REDO_TBL(l_index).attribute7,
p_attribute8 => G_ITEM_REDO_TBL(l_index).attribute8,
p_attribute9 => G_ITEM_REDO_TBL(l_index).attribute9,
p_attribute10 => G_ITEM_REDO_TBL(l_index).attribute10,
p_attribute11 => G_ITEM_REDO_TBL(l_index).attribute11,
p_attribute12 => G_ITEM_REDO_TBL(l_index).attribute12,
p_attribute13 => G_ITEM_REDO_TBL(l_index).attribute13,
p_attribute14 => G_ITEM_REDO_TBL(l_index).attribute14,
p_attribute15 => G_ITEM_REDO_TBL(l_index).attribute15,
p_attribute_label_long => G_ITEM_REDO_TBL(l_index).attribute_label_long,
p_attribute_label_short =>G_ITEM_REDO_TBL(l_index).attribute_label_short,
p_description => G_ITEM_REDO_TBL(l_index).description,
p_created_by => G_ITEM_REDO_TBL(l_index).created_by,
p_creation_date => G_ITEM_REDO_TBL(l_index).creation_date,
p_last_updated_by => G_ITEM_REDO_TBL(l_index).last_updated_by,
p_last_update_date => G_ITEM_REDO_TBL(l_index).last_update_date,
p_last_update_login => G_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
);
end if; -- /* if G_UPDATE_MODE G_NO_CUSTOM_UPDATE*/
p_update_flag => G_ITEM_REDO_TBL(l_index).update_flag,
p_required_flag => G_ITEM_REDO_TBL(l_index).required_flag,
p_security_code => G_ITEM_REDO_TBL(l_index).security_code,
p_default_value_varchar2 =>
G_ITEM_REDO_TBL(l_index).default_value_varchar2,
p_default_value_number =>
G_ITEM_REDO_TBL(l_index).default_value_number,
p_default_value_date =>
G_ITEM_REDO_TBL(l_index).default_value_date,
p_lov_region_application_id =>
G_ITEM_REDO_TBL(l_index).lov_region_application_id,
p_lov_region_code => G_ITEM_REDO_TBL(l_index).lov_region_code,
p_lov_foreign_key_name => G_ITEM_REDO_TBL(l_index).lov_foreign_key_name,
p_lov_attribute_application_id =>
G_ITEM_REDO_TBL(l_index).lov_attribute_application_id,
p_lov_attribute_code => G_ITEM_REDO_TBL(l_index).lov_attribute_code,
p_lov_default_flag => G_ITEM_REDO_TBL(l_index).lov_default_flag,
p_region_defaulting_api_pkg =>
G_ITEM_REDO_TBL(l_index).region_defaulting_api_pkg,
p_region_defaulting_api_proc =>
G_ITEM_REDO_TBL(l_index).region_defaulting_api_proc,
p_region_validation_api_pkg =>
G_ITEM_REDO_TBL(l_index).region_validation_api_pkg,
p_region_validation_api_proc =>
G_ITEM_REDO_TBL(l_index).region_validation_api_proc,
p_order_sequence => G_ITEM_REDO_TBL(l_index).order_sequence,
p_order_direction => G_ITEM_REDO_TBL(l_index).order_direction,
p_display_height => G_ITEM_REDO_TBL(l_index).display_height,
p_submit => G_ITEM_REDO_TBL(l_index).submit,
p_encrypt => G_ITEM_REDO_TBL(l_index).encrypt,
p_css_class_name => G_ITEM_REDO_TBL(l_index).css_class_name,
p_view_usage_name => G_ITEM_REDO_TBL(l_index).view_usage_name,
p_view_attribute_name => G_ITEM_REDO_TBL(l_index).view_attribute_name,
p_nested_region_appl_id => G_ITEM_REDO_TBL(l_index).nested_region_application_id,
p_nested_region_code => G_ITEM_REDO_TBL(l_index).nested_region_code,
p_url => G_ITEM_REDO_TBL(l_index).url,
p_poplist_viewobject => G_ITEM_REDO_TBL(l_index).poplist_viewobject,
p_poplist_display_attr => G_ITEM_REDO_TBL(l_index).poplist_display_attr,
p_poplist_value_attr => G_ITEM_REDO_TBL(l_index).poplist_value_attr,
p_image_file_name => G_ITEM_REDO_TBL(l_index).image_file_name,
p_css_label_class_name => G_ITEM_REDO_TBL(l_index).css_label_class_name,
p_menu_name => G_ITEM_REDO_TBL(l_index).menu_name,
p_flexfield_name => G_ITEM_REDO_TBL(l_index).flexfield_name,
p_flexfield_application_id => G_ITEM_REDO_TBL(l_index).flexfield_application_id,
p_tabular_function_code => G_ITEM_REDO_TBL(l_index).tabular_function_code,
p_tip_type => G_ITEM_REDO_TBL(l_index).tip_type,
p_tip_message_name => G_ITEM_REDO_TBL(l_index).tip_message_name,
p_tip_message_application_id => G_ITEM_REDO_TBL(l_index).tip_message_application_id ,
p_flex_segment_list => G_ITEM_REDO_TBL(l_index).flex_segment_list,
p_entity_id => G_ITEM_REDO_TBL(l_index).entity_id ,
p_anchor => G_ITEM_REDO_TBL(l_index).anchor,
p_poplist_view_usage_name => G_ITEM_REDO_TBL(l_index).poplist_view_usage_name,
p_user_customizable => G_ITEM_REDO_TBL(l_index).user_customizable,
p_sortby_view_attribute_name => G_ITEM_REDO_TBL(l_index).sortby_view_attribute_name,
p_admin_customizable => G_ITEM_REDO_TBL(l_index).admin_customizable,
p_invoke_function_name => G_ITEM_REDO_TBL(l_index).invoke_function_name,
p_expansion => G_ITEM_REDO_TBL(l_index).expansion,
p_als_max_length => G_ITEM_REDO_TBL(l_index).als_max_length,
p_initial_sort_sequence => G_ITEM_REDO_TBL(l_index).initial_sort_sequence,
p_customization_application_id => G_ITEM_REDO_TBL(l_index).customization_application_id,
p_customization_code => G_ITEM_REDO_TBL(l_index).customization_code,
p_attribute_category => G_ITEM_REDO_TBL(l_index).attribute_category,
p_attribute1 => G_ITEM_REDO_TBL(l_index).attribute1,
p_attribute2 => G_ITEM_REDO_TBL(l_index).attribute2,
p_attribute3 => G_ITEM_REDO_TBL(l_index).attribute3,
p_attribute4 => G_ITEM_REDO_TBL(l_index).attribute4,
p_attribute5 => G_ITEM_REDO_TBL(l_index).attribute5,
p_attribute6 => G_ITEM_REDO_TBL(l_index).attribute6,
p_attribute7 => G_ITEM_REDO_TBL(l_index).attribute7,
p_attribute8 => G_ITEM_REDO_TBL(l_index).attribute8,
p_attribute9 => G_ITEM_REDO_TBL(l_index).attribute9,
p_attribute10 => G_ITEM_REDO_TBL(l_index).attribute10,
p_attribute11 => G_ITEM_REDO_TBL(l_index).attribute11,
p_attribute12 => G_ITEM_REDO_TBL(l_index).attribute12,
p_attribute13 => G_ITEM_REDO_TBL(l_index).attribute13,
p_attribute14 => G_ITEM_REDO_TBL(l_index).attribute14,
p_attribute15 => G_ITEM_REDO_TBL(l_index).attribute15,
p_attribute_label_long => G_ITEM_REDO_TBL(l_index).attribute_label_long,
p_attribute_label_short =>G_ITEM_REDO_TBL(l_index).attribute_label_short,
p_description => G_ITEM_REDO_TBL(l_index).description,
p_created_by => G_ITEM_REDO_TBL(l_index).created_by,
p_creation_date => G_ITEM_REDO_TBL(l_index).creation_date,
p_last_updated_by => G_ITEM_REDO_TBL(l_index).last_updated_by,
p_last_update_date => G_ITEM_REDO_TBL(l_index).lasT_update_date,
p_last_update_login => G_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
);
AK_REGION2_PVT.UPDATE_LOV_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_region_application_id =>
G_LOV_RELATION_REDO_TBL(l_index).region_application_id,
p_region_code => G_LOV_RELATION_REDO_TBL(l_index).region_code,
p_attribute_application_id =>
G_LOV_RELATION_REDO_TBL(l_index).attribute_application_id,
p_attribute_code => G_LOV_RELATION_REDO_TBL(l_index).attribute_code,
p_lov_region_appl_id => G_LOV_RELATION_REDO_TBL(l_index).lov_region_appl_id,
p_lov_region_code => G_LOV_RELATION_REDO_TBL(l_index).lov_region_code,
p_lov_attribute_appl_id => G_LOV_RELATION_REDO_TBL(l_index).lov_attribute_appl_id,
p_lov_attribute_code => G_LOV_RELATION_REDO_TBL(l_index).lov_attribute_code,
p_base_attribute_appl_id => G_LOV_RELATION_REDO_TBL(l_index).base_attribute_appl_id,
p_base_attribute_code => G_LOV_RELATION_REDO_TBL(l_index).base_attribute_code,
p_direction_flag => G_LOV_RELATION_REDO_TBL(l_index).direction_flag,
p_base_region_appl_id => G_LOV_RELATION_REDO_TBL(l_index).base_region_appl_id,
p_base_region_code => G_LOV_RELATION_REDO_TBL(l_index).base_region_code,
p_required_flag => G_LOV_RELATION_REDO_TBL(l_index).required_flag,
p_loader_timestamp => p_loader_timestamp,
p_pass => p_pass,
p_copy_redo_flag => l_copy_redo_flag
);
p_last_updated_by => G_LOV_RELATION_REDO_TBL(l_index).last_updated_by,
p_last_update_date => G_LOV_RELATION_REDO_TBL(l_index).last_update_date,
p_last_update_login => G_LOV_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
);
select *
from ak_region_items
where region_code = region_code_param
and region_application_id = region_application_id_param
and display_sequence = display_sequence_param;
select *
from ak_region_items_tl
where region_code = region_code_param
and region_application_id = region_application_id_param
and attribute_code = attribute_code_param
and attribute_application_id = attribute_application_id_param
and language = lang_param;
select userenv('LANG') into l_lang from dual;
AK_REGION_PVT.UPDATE_ITEM (
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_region_application_id =>l_orig_ri_rec.region_application_id,
p_region_code => l_orig_ri_rec.region_code,
p_attribute_application_id => l_orig_ri_rec.attribute_application_id,
p_attribute_code => l_orig_ri_rec.attribute_code,
p_display_sequence => l_new_display_sequence,
p_node_display_flag => l_orig_ri_rec.node_display_flag,
p_node_query_flag => l_orig_ri_rec.node_query_flag,
p_attribute_label_length => l_orig_ri_rec.attribute_label_length,
p_display_value_length => l_orig_ri_rec.display_value_length,
p_bold => l_orig_ri_rec.bold,
p_italic => l_orig_ri_rec.italic,
p_vertical_alignment => l_orig_ri_rec.vertical_alignment,
p_horizontal_alignment => l_orig_ri_rec.horizontal_alignment,
p_item_style => l_orig_ri_rec.item_style,
p_object_attribute_flag =>l_orig_ri_rec.object_attribute_flag,
p_icx_custom_call => l_orig_ri_rec.icx_custom_call,
p_update_flag => l_orig_ri_rec.update_flag,
p_required_flag => l_orig_ri_rec.required_flag,
p_security_code => l_orig_ri_rec.security_code,
p_default_value_varchar2 => l_orig_ri_rec.default_value_varchar2,
p_default_value_number => l_orig_ri_rec.default_value_number,
p_default_value_date => l_orig_ri_rec.default_value_date,
p_lov_region_application_id => l_orig_ri_rec.lov_region_application_id,
p_lov_region_code => l_orig_ri_rec.lov_region_code,
p_lov_foreign_key_name => l_orig_ri_rec.lov_foreign_key_name,
p_lov_attribute_application_id => l_orig_ri_rec.lov_attribute_application_id,
p_lov_attribute_code => l_orig_ri_rec.lov_attribute_code,
p_lov_default_flag => l_orig_ri_rec.lov_default_flag,
p_region_defaulting_api_pkg => l_orig_ri_rec.region_defaulting_api_pkg,
p_region_defaulting_api_proc => l_orig_ri_rec.region_defaulting_api_proc,
p_region_validation_api_pkg => l_orig_ri_rec.region_validation_api_pkg,
p_region_validation_api_proc => l_orig_ri_rec.region_validation_api_proc,
p_order_sequence => l_orig_ri_rec.order_sequence,
p_order_direction => l_orig_ri_rec.order_direction,
p_display_height => l_orig_ri_rec.display_height,
p_submit => l_orig_ri_rec.submit,
p_encrypt => l_orig_ri_rec.encrypt,
p_css_class_name => l_orig_ri_rec.css_class_name,
p_view_usage_name =>l_orig_ri_rec.view_usage_name,
p_view_attribute_name =>l_orig_ri_rec.view_attribute_name,
p_nested_region_appl_id =>l_orig_ri_rec.nested_region_application_id,
p_nested_region_code =>l_orig_ri_rec.nested_region_code,
p_url =>l_orig_ri_rec.url,
p_poplist_viewobject =>l_orig_ri_rec.poplist_viewobject,
p_poplist_display_attr =>l_orig_ri_rec.poplist_display_attribute,
p_poplist_value_attr =>l_orig_ri_rec.poplist_value_attribute,
p_image_file_name =>l_orig_ri_rec.image_file_name,
p_item_name => l_orig_ri_rec.item_name,
p_css_label_class_name => l_orig_ri_rec.css_label_class_name,
p_menu_name => l_orig_ri_rec.menu_name,
p_flexfield_name => l_orig_ri_rec.flexfield_name,
p_flexfield_application_id => l_orig_ri_rec.flexfield_application_id,
p_tabular_function_code => l_orig_ri_rec.tabular_function_code,
p_tip_type => l_orig_ri_rec.tip_type,
p_tip_message_name => l_orig_ri_rec.tip_message_name,
p_tip_message_application_id => l_orig_ri_rec.tip_message_application_id ,
p_flex_segment_list => l_orig_ri_rec.flex_segment_list,
p_entity_id => l_orig_ri_rec.entity_id,
p_anchor => l_orig_ri_rec.anchor,
p_poplist_view_usage_name => l_orig_ri_rec.poplist_view_usage_name,
p_user_customizable => l_orig_ri_rec.user_customizable,
p_sortby_view_attribute_name => l_orig_ri_rec.sortby_view_attribute_name,
p_admin_customizable => l_orig_ri_rec.admin_customizable,
p_invoke_function_name => l_orig_ri_rec.invoke_function_name,
p_expansion => l_orig_ri_rec.expansion,
p_als_max_length => l_orig_ri_rec.als_max_length,
p_initial_sort_sequence => l_orig_ri_rec.initial_sort_sequence,
p_customization_application_id => l_orig_ri_rec.customization_application_id,
p_customization_code => l_orig_ri_rec.customization_code,
p_attribute_category => l_orig_ri_rec.attribute_category,
p_attribute1 => l_orig_ri_rec.attribute1,
p_attribute2 => l_orig_ri_rec.attribute2,
p_attribute3 => l_orig_ri_rec.attribute3,
p_attribute4 => l_orig_ri_rec.attribute4,
p_attribute5 => l_orig_ri_rec.attribute5,
p_attribute6 => l_orig_ri_rec.attribute6,
p_attribute7 => l_orig_ri_rec.attribute7,
p_attribute8 => l_orig_ri_rec.attribute8,
p_attribute9 => l_orig_ri_rec.attribute9,
p_attribute10 => l_orig_ri_rec.attribute10,
p_attribute11 => l_orig_ri_rec.attribute11,
p_attribute12 => l_orig_ri_rec.attribute12,
p_attribute13 => l_orig_ri_rec.attribute13,
p_attribute14 => l_orig_ri_rec.attribute14,
p_attribute15 => l_orig_ri_rec.attribute15,
p_attribute_label_long => l_ri_tl_rec.attribute_label_long,
p_attribute_label_short =>l_ri_tl_rec.attribute_label_short,
p_description => l_ri_tl_rec.description,
p_created_by => l_ri_tl_rec.created_by,
p_creation_date => l_ri_tl_rec.creation_date,
p_last_updated_by => l_ri_tl_rec.last_updated_by,
p_last_update_date => l_ri_tl_rec.last_update_date,
p_last_update_login => l_ri_tl_rec.last_update_login,
p_pass => p_pass,
p_copy_redo_flag => p_copy_redo_flag
);
select 1
from AK_REGION_GRAPH_COLUMNS
where 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
and graph_number = p_graph_number;
select 1
from AK_REGION_LOV_RELATIONS
where 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
and lov_region_appl_id = p_lov_region_appl_id
and lov_region_code = p_lov_region_code
and lov_attribute_appl_id = p_lov_attribute_appl_id
and lov_attribute_code = p_lov_attribute_code
and base_attribute_appl_id = p_base_attribute_appl_id
and base_attribute_code = p_base_attribute_code
and direction_flag = p_direction_flag
and base_region_appl_id = p_base_region_appl_id
and base_region_code = p_base_region_code;
select 1
from AK_REGION_GRAPHS
where region_application_id = param_region_appl_id
and region_code = param_region_code
and graph_number = param_graph_number;
select 1
from AK_REGION_ITEMS
where region_application_id = param_region_appl_id
and region_code = param_region_code
and attribute_application_id = param_attr_appl_id
and attribute_code = param_attr_code;
select 1
from AK_REGIONS
where region_application_id = param_region_appl_id
and region_code = param_region_code;
select 1
from AK_REGION_ITEMS
where region_application_id = param_region_appl_id
and region_code = param_region_code
and attribute_application_id = param_attr_appl_id;
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;
l_last_update_date date;
l_last_update_login number;
l_last_updated_by number;
AK_UPLOAD_GRP.G_UPLOAD_DATE := p_last_update_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);
l_last_updated_by := p_last_updated_by;
l_last_update_login := p_last_update_login;
insert into AK_REGION_GRAPH_COLUMNS (
REGION_APPLICATION_ID,
REGION_CODE,
ATTRIBUTE_APPLICATION_ID,
ATTRIBUTE_CODE,
GRAPH_NUMBER,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN
) values (
p_region_application_id,
p_region_code,
p_attribute_application_id,
p_attribute_code,
p_graph_number,
l_creation_date,
l_created_by,
l_last_update_date,
l_last_updated_by,
l_last_update_login
);
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;
l_last_update_date date;
l_last_update_login number;
l_last_updated_by number;
if (p_last_updated_by <> FND_API.G_MISS_NUM) then
l_last_updated_by := p_last_updated_by;
if (p_last_update_date <> FND_API.G_MISS_DATE) then
l_last_update_date := p_last_update_date;
if (p_last_update_login <> FND_API.G_MISS_NUM) then
l_last_update_login := p_last_update_login;
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;
insert into AK_REGION_LOV_RELATIONS (
REGION_APPLICATION_ID,
REGION_CODE,
ATTRIBUTE_APPLICATION_ID,
ATTRIBUTE_CODE,
LOV_REGION_APPL_ID,
LOV_REGION_CODE,
LOV_ATTRIBUTE_APPL_ID,
LOV_ATTRIBUTE_CODE,
BASE_ATTRIBUTE_APPL_ID,
BASE_ATTRIBUTE_CODE,
DIRECTION_FLAG,
BASE_REGION_APPL_ID,
BASE_REGION_CODE,
REQUIRED_FLAG,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN
) values (
p_region_application_id,
p_region_code,
p_attribute_application_id,
p_attribute_code,
p_lov_region_appl_id,
p_lov_region_code,
p_lov_attribute_appl_id,
p_lov_attribute_code,
p_base_attribute_appl_id,
p_base_attribute_code,
p_direction_flag,
p_base_region_appl_id,
p_base_region_code,
l_required_flag,
l_creation_date,
l_created_by,
l_last_update_date,
l_last_updated_by,
l_last_update_login
);
PROCEDURE UPDATE_GRAPH_COLUMN (
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
p_api_version_number IN NUMBER,
p_init_msg_tbl IN BOOLEAN := FALSE,
p_msg_count OUT NOCOPY NUMBER,
p_msg_data OUT NOCOPY VARCHAR2,
p_return_status OUT NOCOPY VARCHAR2,
p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_graph_number IN NUMBER := FND_API.G_MISS_NUM,
p_created_by IN NUMBER := FND_API.G_MISS_NUM,
p_creation_date IN DATE := FND_API.G_MISS_DATE,
p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
p_last_update_date IN DATE := FND_API.G_MISS_DATE,
p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
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_REGION_GRAPH_COLUMNS
where 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
and GRAPH_NUMBER = p_graph_number
for update of GRAPH_NUMBER;
l_api_name CONSTANT varchar2(30) := 'Update_Graph_Column';
l_last_update_date date;
l_last_update_login number;
l_last_updated_by number;
savepoint start_update_graph_columns;
p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,
p_pass => p_pass
) then
--dbms_output.put_line(l_api_name || 'validation failed');
AK_UPLOAD_GRP.G_UPLOAD_DATE := p_last_update_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);
l_last_updated_by := p_last_updated_by;
l_last_update_login := p_last_update_login;
update AK_REGION_GRAPH_COLUMNS set
LAST_UPDATE_DATE = l_last_update_date,
LAST_UPDATED_BY = l_last_updated_by,
LAST_UPDATE_LOGIN = l_last_update_login
where 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
and GRAPH_NUMBER = p_graph_number;
FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_UPDATE_FAILED');
FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_UPDATED');
rollback to start_update_graph_column;
FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_NOT_UPDATED');
rollback to start_update_graph_column;
rollback to start_update_graph_column;
end UPDATE_GRAPH_COLUMN;
PROCEDURE UPDATE_LOV_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_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_lov_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_lov_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_base_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
p_base_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_direction_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_base_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
p_base_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_required_flag 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_REGION_LOV_RELATIONS
where 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
and LOV_REGION_APPL_ID = p_lov_region_appl_id
and LOV_REGION_CODE = p_lov_region_code
and LOV_ATTRIBUTE_APPL_ID = p_lov_attribute_appl_id
and LOV_ATTRIBUTE_CODE = p_lov_attribute_code
and BASE_ATTRIBUTE_APPL_ID = p_base_attribute_appl_id
and BASE_ATTRIBUTE_CODE = p_base_attribute_code
and DIRECTION_FLAG =p_direction_flag
and BASE_REGION_APPL_ID = p_base_region_appl_id
and BASE_REGION_CODE = p_base_region_code
for update of REQUIRED_FLAG;
l_api_name CONSTANT varchar2(30) := 'Update_Lov_Relation';
l_last_update_date date;
l_last_update_login number;
l_last_updated_by number;
savepoint start_update_lov_relation;
p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,
p_pass => p_pass
) then
--dbms_output.put_line(l_api_name || 'validation failed');
if (p_last_updated_by <> FND_API.G_MISS_NUM) then
l_last_updated_by := p_last_updated_by;
if (p_last_update_date <> FND_API.G_MISS_DATE) then
l_last_update_date := p_last_update_date;
if (p_last_update_login <> FND_API.G_MISS_NUM) then
l_last_update_login := p_last_update_login;
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_lov_relation_rec.last_updated_by,
p_last_update_date => l_last_update_date,
p_db_last_update_date => l_lov_relation_rec.last_update_date,
p_last_update_login => l_last_update_login,
p_create_or_update => 'UPDATE') then
update AK_REGION_LOV_RELATIONS set
REQUIRED_FLAG = l_lov_relation_rec.required_flag,
LAST_UPDATE_DATE = l_last_update_date,
LAST_UPDATED_BY = l_last_updated_by,
LAST_UPDATE_LOGIN = l_last_update_login
where 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
and LOV_REGION_APPL_ID = p_lov_region_appl_id
and LOV_REGION_CODE = p_lov_region_code
and LOV_ATTRIBUTE_APPL_ID = p_lov_attribute_appl_id
and LOV_ATTRIBUTE_CODE = p_lov_attribute_code
and BASE_ATTRIBUTE_APPL_ID = p_base_attribute_appl_id
and BASE_ATTRIBUTE_CODE = p_base_attribute_code
and DIRECTION_FLAG = p_direction_flag
and BASE_REGION_APPL_ID = p_base_region_appl_id
and BASE_REGION_CODE = p_base_region_code;
FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_UPDATE_FAILED');
FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_UPDATED');
rollback to start_update_lov_relation;
FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_NOT_UPDATED');
rollback to start_update_lov_relation;
rollback to start_update_lov_relation;
end UPDATE_LOV_RELATION;
select 1
from AK_CATEGORY_USAGES
where 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
and category_name = p_category_name;
select item_style
from AK_REGION_ITEMS
where region_application_id = param_region_appl_id
and region_code = param_region_code
and attribute_application_id = param_attr_appl_id
and attribute_code = param_attr_code;
select 1
from fnd_document_categories_vl
where name = param_category_name;
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;
l_last_update_date date;
l_last_update_login number;
l_last_updated_by number;
if (p_last_updated_by <> FND_API.G_MISS_NUM) then
l_last_updated_by := p_last_updated_by;
if (p_last_update_date <> FND_API.G_MISS_DATE) then
l_last_update_date := p_last_update_date;
if (p_last_update_login <> FND_API.G_MISS_NUM) then
l_last_update_login := p_last_update_login;
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;
insert into AK_CATEGORY_USAGES (
REGION_APPLICATION_ID,
REGION_CODE,
ATTRIBUTE_APPLICATION_ID,
ATTRIBUTE_CODE,
CATEGORY_NAME,
CATEGORY_ID,
APPLICATION_ID,
SHOW_ALL,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN
) values (
p_region_application_id,
p_region_code,
p_attribute_application_id,
p_attribute_code,
p_category_name,
p_category_id,
p_application_id,
p_show_all,
l_creation_date,
l_created_by,
l_last_update_date,
l_last_updated_by,
l_last_update_login
);
PROCEDURE UPDATE_CATEGORY_USAGE (
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_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_category_id IN NUMBER := FND_API.G_MISS_NUM,
p_application_id IN NUMBER := FND_API.G_MISS_NUM,
p_show_all 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_CATEGORY_USAGES
where 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
and CATEGORY_NAME = p_category_name;
l_api_name CONSTANT varchar2(30) := 'Update_Category_Usage';
l_last_update_date date;
l_last_update_login number;
l_last_updated_by number;
savepoint start_update_category_usage;
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;
if (p_last_updated_by <> FND_API.G_MISS_NUM) then
l_last_updated_by := p_last_updated_by;
if (p_last_update_date <> FND_API.G_MISS_DATE) then
l_last_update_date := p_last_update_date;
if (p_last_update_login <> FND_API.G_MISS_NUM) then
l_last_update_login := p_last_update_login;
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_category_usage_rec.last_updated_by,
p_last_update_date => l_last_update_date,
p_db_last_update_date => l_category_usage_rec.last_update_date,
p_last_update_login => l_last_update_login,
p_create_or_update => 'UPDATE') then
update AK_CATEGORY_USAGES set
SHOW_ALL = p_show_all,
APPLICATION_ID = p_application_id,
LAST_UPDATE_DATE = l_last_update_date,
LAST_UPDATED_BY = l_last_updated_by,
LAST_UPDATE_LOGIN = l_last_update_login
where 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
and CATEGORY_NAME = p_category_name;
FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_UPDATE_FAILED');
FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_UPDATED');
rollback to start_update_category_usage;
rollback to start_update_category_usage;
end UPDATE_CATEGORY_USAGE;