The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT attribute9
FROM ak_region_items
WHERE region_code = p_region_code
AND region_application_id = p_region_app_id
AND attribute_code = p_compare_code
AND attribute1 IN (BIS_AK_REGION_PUB.C_MEASURE, BIS_AK_REGION_PUB.C_MEASURE_NO_TARGET);
SELECT measure_name
FROM Bisbv_Performance_Measures
WHERE measure_short_name = p_short_name;
SELECT attribute2
FROM Ak_Region_Items
WHERE REGION_CODE = p_region_code
AND REGION_APPLICATION_ID = p_region_app_id
AND ATTRIBUTE_CODE = p_compare_code
AND ATTRIBUTE1 IN (BIS_AK_REGION_PUB.C_MEASURE, BIS_AK_REGION_PUB.C_MEASURE_NO_TARGET);
procedure INSERT_REGION_ROW (
X_ROWID in out NOCOPY VARCHAR2,
X_USER_ID in NUMBER,
X_REGION_APPLICATION_ID in NUMBER,
X_REGION_CODE in VARCHAR2,
X_DATABASE_OBJECT_NAME in VARCHAR2,
X_NAME in VARCHAR2,
X_DESCRIPTION in VARCHAR2,
X_NUM_ROWS_DISPLAY in NUMBER,
X_REGION_STYLE in VARCHAR2,
X_REGION_OBJECT_TYPE in VARCHAR2,
X_ISFORM_FLAG in VARCHAR2,
X_ATTRIBUTE_CATEGORY in VARCHAR2,
X_ATTRIBUTE1 in VARCHAR2,
X_ATTRIBUTE2 in VARCHAR2,
X_ATTRIBUTE3 in VARCHAR2,
X_ATTRIBUTE4 in VARCHAR2,
X_ATTRIBUTE5 in VARCHAR2,
X_ATTRIBUTE6 in VARCHAR2,
X_ATTRIBUTE7 in VARCHAR2,
X_ATTRIBUTE8 in VARCHAR2,
X_ATTRIBUTE9 in VARCHAR2,
X_ATTRIBUTE10 in VARCHAR2,
X_ATTRIBUTE11 in VARCHAR2,
X_ATTRIBUTE12 in VARCHAR2,
X_ATTRIBUTE13 in VARCHAR2,
X_ATTRIBUTE14 in VARCHAR2,
X_ATTRIBUTE15 in VARCHAR2) is
begin
IF valid_database_object(X_DATABASE_OBJECT_NAME) and not AK_OBJECT_EXISTS(X_DATABASE_OBJECT_NAME) THEN
INSERT_AK_OBJECT(
P_DATABASE_OBJECT_NAME => X_DATABASE_OBJECT_NAME,
P_APPLICATION_ID => X_REGION_APPLICATION_ID);
AK_REGIONS_PKG.INSERT_ROW(
X_ROWID => X_ROWID,
X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
X_REGION_CODE => upper(X_REGION_CODE),
X_DATABASE_OBJECT_NAME => X_DATABASE_OBJECT_NAME,
X_REGION_STYLE => X_REGION_STYLE,
X_NUM_COLUMNS => null,
X_ICX_CUSTOM_CALL => null,
X_NAME => X_NAME,
X_DESCRIPTION => X_DESCRIPTION,
X_REGION_DEFAULTING_API_PKG => null,
X_REGION_DEFAULTING_API_PROC => null,
X_REGION_VALIDATION_API_PKG => null,
X_REGION_VALIDATION_API_PROC => null,
X_APPL_MODULE_OBJECT_TYPE => null,
X_NUM_ROWS_DISPLAY => X_NUM_ROWS_DISPLAY,
X_REGION_OBJECT_TYPE => X_REGION_OBJECT_TYPE,
X_IMAGE_FILE_NAME => null,
X_ISFORM_FLAG => X_ISFORM_FLAG,
X_HELP_TARGET => null,
X_STYLE_SHEET_FILENAME => null,
X_VERSION => null,
X_APPLICATIONMODULE_USAGE_NAME=>null,
X_CREATION_DATE => sysdate,
X_CREATED_BY => X_USER_ID,
X_LAST_UPDATE_DATE => sysdate,
X_LAST_UPDATED_BY => X_USER_ID,
X_LAST_UPDATE_LOGIN => X_USER_ID,
X_ATTRIBUTE_CATEGORY => X_ATTRIBUTE_CATEGORY,
X_ATTRIBUTE1 => X_ATTRIBUTE1,
X_ATTRIBUTE2 => X_ATTRIBUTE2,
X_ATTRIBUTE3 => X_ATTRIBUTE3,
X_ATTRIBUTE4 => X_ATTRIBUTE4,
X_ATTRIBUTE5 => X_ATTRIBUTE5,
X_ATTRIBUTE6 => X_ATTRIBUTE6,
X_ATTRIBUTE7 => X_ATTRIBUTE7,
X_ATTRIBUTE8 => X_ATTRIBUTE8,
X_ATTRIBUTE9 => X_ATTRIBUTE9,
X_ATTRIBUTE10 => X_ATTRIBUTE10,
X_ATTRIBUTE11 => X_ATTRIBUTE11,
X_ATTRIBUTE12 => X_ATTRIBUTE12,
X_ATTRIBUTE13 => X_ATTRIBUTE13,
X_ATTRIBUTE14 => X_ATTRIBUTE14,
X_ATTRIBUTE15 => X_ATTRIBUTE15);
end INSERT_REGION_ROW;
procedure UPDATE_REGION_ROW (
X_USER_ID in NUMBER,
X_REGION_APPLICATION_ID in NUMBER,
X_REGION_CODE in VARCHAR2,
X_DATABASE_OBJECT_NAME in VARCHAR2,
X_NAME in VARCHAR2,
X_DESCRIPTION in VARCHAR2,
X_NUM_ROWS_DISPLAY in NUMBER,
X_REGION_STYLE in VARCHAR2,
X_REGION_OBJECT_TYPE in VARCHAR2,
X_ATTRIBUTE_CATEGORY in VARCHAR2,
X_ATTRIBUTE1 in VARCHAR2,
X_ATTRIBUTE2 in VARCHAR2,
X_ATTRIBUTE3 in VARCHAR2,
X_ATTRIBUTE4 in VARCHAR2,
X_ATTRIBUTE5 in VARCHAR2,
X_ATTRIBUTE6 in VARCHAR2,
X_ATTRIBUTE7 in VARCHAR2,
X_ATTRIBUTE8 in VARCHAR2,
X_ATTRIBUTE9 in VARCHAR2,
X_ATTRIBUTE10 in VARCHAR2,
X_ATTRIBUTE11 in VARCHAR2,
X_ATTRIBUTE12 in VARCHAR2,
X_ATTRIBUTE13 in VARCHAR2,
X_ATTRIBUTE14 in VARCHAR2,
X_ATTRIBUTE15 in VARCHAR2) is
l_region_rec AK_REGION_PUB.Region_Rec_Type;
select icx_custom_call,
num_columns,
region_defaulting_api_pkg,
region_defaulting_api_proc,
region_validation_api_pkg,
region_validation_api_proc,
applicationmodule_object_type,
image_file_name,
isform_flag,
help_target,
style_sheet_filename,
version,
applicationmodule_usage_name,
add_indexed_children,
stateful_flag,
function_name,
children_view_usage_name,
search_panel,
advanced_search_panel,
customize_panel,
default_search_panel,
results_based_search,
display_graph_table,
disable_header,
standalone,
auto_customization_criteria
from ak_regions
where region_code = X_REGION_CODE
and region_application_id = X_REGION_APPLICATION_ID;
AK_REGIONS_PKG.UPDATE_ROW(
X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
X_REGION_CODE => X_REGION_CODE,
X_DATABASE_OBJECT_NAME => X_DATABASE_OBJECT_NAME,
X_REGION_STYLE => X_REGION_STYLE,
X_NUM_COLUMNS =>l_region_rec.num_columns,
X_ICX_CUSTOM_CALL => l_region_rec.icx_custom_call,
X_NAME => X_NAME,
X_DESCRIPTION => X_DESCRIPTION,
X_REGION_DEFAULTING_API_PKG => l_region_rec.region_defaulting_api_pkg,
X_REGION_DEFAULTING_API_PROC => l_region_rec.region_defaulting_api_proc,
X_REGION_VALIDATION_API_PKG => l_region_rec.region_validation_api_pkg,
X_REGION_VALIDATION_API_PROC => l_region_rec.region_validation_api_proc,
X_APPL_MODULE_OBJECT_TYPE => l_region_rec.applicationmodule_object_type,
X_NUM_ROWS_DISPLAY => X_NUM_ROWS_DISPLAY,
X_REGION_OBJECT_TYPE => X_REGION_OBJECT_TYPE,
X_IMAGE_FILE_NAME => l_region_rec.image_file_name,
X_ISFORM_FLAG => l_region_rec.isform_flag,
X_HELP_TARGET => l_region_rec.help_target,
X_STYLE_SHEET_FILENAME => l_region_rec.style_sheet_filename,
X_VERSION => l_region_rec.version,
X_APPLICATIONMODULE_USAGE_NAME => l_region_rec.applicationmodule_usage_name,
X_ADD_INDEXED_CHILDREN => l_region_rec.add_indexed_children,
X_STATEFUL_FLAG => l_region_rec.stateful_flag,
X_FUNCTION_NAME => l_region_rec.function_name,
X_CHILDREN_VIEW_USAGE_NAME => l_region_rec.children_view_usage_name,
X_SEARCH_PANEL => l_region_rec.search_panel,
X_ADVANCED_SEARCH_PANEL =>l_region_rec.advanced_search_panel,
X_CUSTOMIZE_PANEL => l_region_rec.customize_panel,
X_DEFAULT_SEARCH_PANEL => l_region_rec.default_search_panel,
X_RESULTS_BASED_SEARCH => l_region_rec.results_based_search,
X_DISPLAY_GRAPH_TABLE => l_region_rec.display_graph_table,
X_DISABLE_HEADER => l_region_rec.disable_header,
X_STANDALONE => l_region_rec.standalone,
X_AUTO_CUSTOMIZATION_CRITERIA =>l_region_rec.auto_customization_criteria,
X_LAST_UPDATE_DATE => sysdate,
X_LAST_UPDATED_BY => X_USER_ID,
X_LAST_UPDATE_LOGIN => X_USER_ID,
X_ATTRIBUTE_CATEGORY => X_ATTRIBUTE_CATEGORY,
X_ATTRIBUTE1 => X_ATTRIBUTE1,
X_ATTRIBUTE2 => X_ATTRIBUTE2,
X_ATTRIBUTE3 => X_ATTRIBUTE3,
X_ATTRIBUTE4 => X_ATTRIBUTE4,
X_ATTRIBUTE5 => X_ATTRIBUTE5,
X_ATTRIBUTE6 => X_ATTRIBUTE6,
X_ATTRIBUTE7 => X_ATTRIBUTE7,
X_ATTRIBUTE8 => X_ATTRIBUTE8,
X_ATTRIBUTE9 => X_ATTRIBUTE9,
X_ATTRIBUTE10 => X_ATTRIBUTE10,
X_ATTRIBUTE11 => X_ATTRIBUTE11,
X_ATTRIBUTE12 => X_ATTRIBUTE12,
X_ATTRIBUTE13 => X_ATTRIBUTE13,
X_ATTRIBUTE14 => X_ATTRIBUTE14,
X_ATTRIBUTE15 => X_ATTRIBUTE15);
end UPDATE_REGION_ROW;
procedure INSERT_REGION_ITEM_ROW (
X_ROWID in out NOCOPY VARCHAR2,
X_USER_ID in NUMBER,
X_REGION_APPLICATION_ID in NUMBER,
X_REGION_CODE in VARCHAR2,
X_ATTRIBUTE_APPLICATION_ID in NUMBER,
X_ATTRIBUTE_CODE in VARCHAR2,
X_DISPLAY_SEQUENCE in number,
X_NODE_DISPLAY_FLAG in VARCHAR2,
X_NODE_QUERY_FLAG in VARCHAR2,
X_ATTRIBUTE_LABEL_LONG in VARCHAR2,
X_ATTRIBUTE_LABEL_LENGTH in NUMBER,
X_DISPLAY_VALUE_LENGTH in number,
X_ITEM_STYLE in VARCHAR2,
X_REQUIRED_FLAG in VARCHAR2,
X_NESTED_REGION_CODE IN VARCHAR2,
X_NESTED_REGION_APPL_ID IN NUMBER,
X_ATTRIBUTE_CATEGORY in VARCHAR2,
X_ATTRIBUTE1 in VARCHAR2,
X_ATTRIBUTE2 in VARCHAR2,
X_ATTRIBUTE3 in VARCHAR2,
X_ATTRIBUTE4 in VARCHAR2,
X_ATTRIBUTE5 in VARCHAR2,
X_ATTRIBUTE6 in VARCHAR2,
X_ATTRIBUTE7 in VARCHAR2,
X_ATTRIBUTE8 in VARCHAR2,
X_ATTRIBUTE9 in VARCHAR2,
X_ATTRIBUTE10 in VARCHAR2,
X_ATTRIBUTE11 in VARCHAR2,
X_ATTRIBUTE12 in VARCHAR2,
X_ATTRIBUTE13 in VARCHAR2,
X_ATTRIBUTE14 in VARCHAR2,
X_ATTRIBUTE15 in VARCHAR2,
X_URL in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR,
X_ORDER_SEQUENCE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR,
X_ORDER_DIRECTION in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR) is
l_display_value_length number;
select count(1)
from ak_attributes
where attribute_code = X_ATTRIBUTE_CODE
and attribute_application_id = X_ATTRIBUTE_APPLICATION_ID;
AK_ATTRIBUTES_PKG.INSERT_ROW (
X_ROWID => l_attribute_rowid,
X_ATTRIBUTE_APPLICATION_ID => X_ATTRIBUTE_APPLICATION_ID,
X_ATTRIBUTE_CODE => X_ATTRIBUTE_CODE,
X_ATTRIBUTE_LABEL_LENGTH => c_ATTR_LABEL_LENGTH,
X_ATTRIBUTE_VALUE_LENGTH => c_ATTR_VALUE_LENGTH,
X_BOLD => c_BOLD ,
X_ITALIC => c_ITALIC,
X_UPPER_CASE_FLAG => c_UPPER_CASE_FLAG,
X_VERTICAL_ALIGNMENT => c_VERTICAL_ALIGNMENT,
X_HORIZONTAL_ALIGNMENT => c_HORIZONTAL_ALIGNMENT,
X_DEFAULT_VALUE_VARCHAR2 => null,
X_DEFAULT_VALUE_NUMBER => null,
X_DEFAULT_VALUE_DATE => null,
X_LOV_REGION_CODE => null,
X_LOV_REGION_APPLICATION_ID => null,
X_DATA_TYPE => c_ATTR_DATATYPE,
X_DISPLAY_HEIGHT => null,
X_ITEM_STYLE => X_ITEM_STYLE,
X_CSS_CLASS_NAME => null,
X_CSS_LABEL_CLASS_NAME => null,
X_PRECISION => null,
X_EXPANSION => null,
X_ALS_MAX_LENGTH => null,
X_POPLIST_VIEWOBJECT => null,
X_POPLIST_DISPLAY_ATTRIBUTE => null,
X_POPLIST_VALUE_ATTRIBUTE => null,
X_ATTRIBUTE_CATEGORY => X_ATTRIBUTE_CATEGORY,
X_ATTRIBUTE1 => null,
X_ATTRIBUTE2 => null,
X_ATTRIBUTE3 => null,
X_ATTRIBUTE4 => null,
X_ATTRIBUTE5 => null,
X_ATTRIBUTE6 => null,
X_ATTRIBUTE7 => null,
X_ATTRIBUTE8 => null,
X_ATTRIBUTE9 => null,
X_ATTRIBUTE10 => null,
X_ATTRIBUTE11 => null,
X_ATTRIBUTE12 => null,
X_ATTRIBUTE13 => null,
X_ATTRIBUTE14 => null,
X_ATTRIBUTE15 => null,
X_NAME => X_ATTRIBUTE_CODE,
X_ATTRIBUTE_LABEL_LONG => null,
X_ATTRIBUTE_LABEL_SHORT => null,
X_DESCRIPTION => null,
X_CREATION_DATE => sysdate,
X_CREATED_BY => X_USER_ID,
X_LAST_UPDATE_DATE => sysdate,
X_LAST_UPDATED_BY => X_USER_ID,
X_LAST_UPDATE_LOGIN => X_USER_ID);
AK_REGION_ITEMS_PKG.INSERT_ROW (
X_ROWID => X_ROWID,
X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
X_REGION_CODE => upper(X_REGION_CODE),
X_ATTRIBUTE_APPLICATION_ID => X_ATTRIBUTE_APPLICATION_ID,
X_ATTRIBUTE_CODE => upper(X_ATTRIBUTE_CODE),
X_DISPLAY_SEQUENCE => X_DISPLAY_SEQUENCE,
X_NODE_DISPLAY_FLAG => X_NODE_DISPLAY_FLAG,
X_NODE_QUERY_FLAG => X_NODE_QUERY_FLAG,
X_ATTRIBUTE_LABEL_LENGTH => X_ATTRIBUTE_LABEL_LENGTH,
X_BOLD => c_BOLD,
X_ITALIC => c_ITALIC,
X_VERTICAL_ALIGNMENT => c_VERTICAL_ALIGNMENT,
X_HORIZONTAL_ALIGNMENT => c_HORIZONTAL_ALIGNMENT,
X_ITEM_STYLE => X_ITEM_STYLE,
X_OBJECT_ATTRIBUTE_FLAG => c_OBJECT_ATTRIBUTE_FLAG,
X_ATTRIBUTE_LABEL_LONG => X_ATTRIBUTE_LABEL_LONG,
X_DESCRIPTION => null,
X_SECURITY_CODE => null,
X_UPDATE_FLAG => c_UPDATE_FLAG,
X_REQUIRED_FLAG => X_REQUIRED_FLAG,
X_DISPLAY_VALUE_LENGTH => X_DISPLAY_VALUE_LENGTH,
X_LOV_REGION_APPLICATION_ID => null,
X_LOV_REGION_CODE => null,
X_LOV_FOREIGN_KEY_NAME => null,
X_LOV_ATTRIBUTE_APPLICATION_ID => null,
X_LOV_ATTRIBUTE_CODE => null,
X_LOV_DEFAULT_FLAG => null,
X_REGION_DEFAULTING_API_PKG => null,
X_REGION_DEFAULTING_API_PROC => null,
X_REGION_VALIDATION_API_PKG => null,
X_REGION_VALIDATION_API_PROC => null,
X_ORDER_SEQUENCE => X_ORDER_SEQUENCE,
X_ORDER_DIRECTION => x_ORDER_DIRECTION,
X_DEFAULT_VALUE_VARCHAR2 => null,
X_DEFAULT_VALUE_NUMBER => null,
X_DEFAULT_VALUE_DATE => null,
X_ITEM_NAME => replace(initcap(X_ATTRIBUTE_CODE), '_', ''),
X_DISPLAY_HEIGHT => c_DISPLAY_HEIGHT,
X_SUBMIT => c_SUBMIT,
X_ENCRYPT => c_ENCRYPT,
X_VIEW_USAGE_NAME => null,
X_VIEW_ATTRIBUTE_NAME => null,
X_CSS_CLASS_NAME => null,
X_CSS_LABEL_CLASS_NAME => null,
X_URL => l_URL,
X_POPLIST_VIEWOBJECT => null,
X_POPLIST_DISPLAY_ATTRIBUTE => null,
X_POPLIST_VALUE_ATTRIBUTE => null,
X_IMAGE_FILE_NAME => null,
X_NESTED_REGION_CODE => upper(X_NESTED_REGION_CODE),
X_NESTED_REGION_APPL_ID => l_NESTED_REGION_APPL_ID,
X_MENU_NAME => null,
X_FLEXFIELD_NAME => null,
X_FLEXFIELD_APPLICATION_ID => null,
X_TABULAR_FUNCTION_CODE => null,
X_TIP_TYPE => null,
X_TIP_MESSAGE_NAME => null,
X_TIP_MESSAGE_APPLICATION_ID => null,
X_FLEX_SEGMENT_LIST => null,
X_ENTITY_ID => null,
X_ANCHOR => null,
X_POPLIST_VIEW_USAGE_NAME => null,
X_USER_CUSTOMIZABLE => null,
X_ADMIN_CUSTOMIZABLE => c_ADMIN_CUSTOMIZABLE,
X_INVOKE_FUNCTION_NAME => null,
X_ATTRIBUTE_LABEL_SHORT => null,
X_EXPANSION => null,
X_ALS_MAX_LENGTH => null,
X_SORTBY_VIEW_ATTRIBUTE_NAME => null,
X_ICX_CUSTOM_CALL => null,
X_INITIAL_SORT_SEQUENCE => null,
X_CUSTOMIZATION_APPLICATION_ID => null,
X_CUSTOMIZATION_CODE => null,
X_CREATION_DATE => sysdate,
X_CREATED_BY => X_USER_ID,
X_LAST_UPDATE_DATE => sysdate,
X_LAST_UPDATED_BY => X_USER_ID,
X_LAST_UPDATE_LOGIN => X_USER_ID,
X_ATTRIBUTE_CATEGORY => X_ATTRIBUTE_CATEGORY,
X_ATTRIBUTE1 => X_ATTRIBUTE1,
X_ATTRIBUTE2 => X_ATTRIBUTE2,
X_ATTRIBUTE3 => X_ATTRIBUTE3,
X_ATTRIBUTE4 => X_ATTRIBUTE4,
X_ATTRIBUTE5 => X_ATTRIBUTE5,
X_ATTRIBUTE6 => X_ATTRIBUTE6,
X_ATTRIBUTE7 => X_ATTRIBUTE7,
X_ATTRIBUTE8 => X_ATTRIBUTE8,
X_ATTRIBUTE9 => X_ATTRIBUTE9,
X_ATTRIBUTE10 => X_ATTRIBUTE10,
X_ATTRIBUTE11 => X_ATTRIBUTE11,
X_ATTRIBUTE12 => X_ATTRIBUTE12,
X_ATTRIBUTE13 => X_ATTRIBUTE13,
X_ATTRIBUTE14 => X_ATTRIBUTE14,
X_ATTRIBUTE15 => X_ATTRIBUTE15);
end INSERT_REGION_ITEM_ROW;
procedure UPDATE_REGION_ITEM_ROW (
X_USER_ID in NUMBER,
X_REGION_APPLICATION_ID in NUMBER,
X_REGION_CODE in VARCHAR2,
X_ATTRIBUTE_APPLICATION_ID in NUMBER,
X_ATTRIBUTE_CODE in VARCHAR2,
X_DISPLAY_SEQUENCE in VARCHAR2,
X_NODE_DISPLAY_FLAG in VARCHAR2,
X_NODE_QUERY_FLAG in VARCHAR2,
X_ATTRIBUTE_LABEL_LONG in VARCHAR2,
X_ATTRIBUTE_LABEL_LENGTH in NUMBER,
X_DISPLAY_VALUE_LENGTH in number,
X_ITEM_STYLE in VARCHAR2,
X_REQUIRED_FLAG in VARCHAR2,
X_NESTED_REGION_CODE IN VARCHAR2,
X_NESTED_REGION_APPL_ID IN NUMBER,
X_ATTRIBUTE_CATEGORY in VARCHAR2,
X_ATTRIBUTE1 in VARCHAR2,
X_ATTRIBUTE2 in VARCHAR2,
X_ATTRIBUTE3 in VARCHAR2,
X_ATTRIBUTE4 in VARCHAR2,
X_ATTRIBUTE5 in VARCHAR2,
X_ATTRIBUTE6 in VARCHAR2,
X_ATTRIBUTE7 in VARCHAR2,
X_ATTRIBUTE8 in VARCHAR2,
X_ATTRIBUTE9 in VARCHAR2,
X_ATTRIBUTE10 in VARCHAR2,
X_ATTRIBUTE11 in VARCHAR2,
X_ATTRIBUTE12 in VARCHAR2,
X_ATTRIBUTE13 in VARCHAR2,
X_ATTRIBUTE14 in VARCHAR2,
X_ATTRIBUTE15 in VARCHAR2,
X_URL in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR,
X_ORDER_SEQUENCE in VARCHAR2 := NULL,
X_ORDER_DIRECTION in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR)
is
l_regionItem_rec AK_REGION_PUB.Item_Rec_Type;
select display_sequence,
bold,
italic,
vertical_alignment,
horizontal_alignment,
item_style,
object_attribute_flag,
icx_custom_call,
update_flag,
required_flag,
security_code,
default_value_varchar2,
default_value_number,
default_value_date,
lov_region_application_id,
lov_region_code,
lov_foreign_key_name,
lov_attribute_application_id,
lov_attribute_code,
lov_default_flag,
region_defaulting_api_pkg,
region_defaulting_api_proc,
region_validation_api_pkg,
region_validation_api_proc,
order_sequence,
order_direction,
display_height,
submit,
encrypt,
css_class_name,
view_usage_name,
view_attribute_name,
url,
poplist_viewobject,
poplist_display_attribute,
poplist_value_attribute,
image_file_name,
item_name,
css_label_class_name,
menu_name,
flexfield_name,
flexfield_application_id,
tabular_function_code,
tip_type,
tip_message_name,
tip_message_application_id,
flex_segment_list,
entity_id,
anchor,
poplist_view_usage_name,
user_customizable,
sortby_view_attribute_name,
admin_customizable,
invoke_function_name,
expansion,
als_max_length,
initial_sort_sequence,
customization_application_id,
customization_code,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute12,
attribute13,
attribute14,
attribute15,
attribute_label_short,
description
from ak_region_items_vl
where region_code = X_REGION_CODE
and region_application_id = X_REGION_APPLICATION_ID
and attribute_code = X_ATTRIBUTE_CODE
and attribute_application_id = X_ATTRIBUTE_APPLICATION_ID;
l_regionItem_rec.update_flag,
l_regionItem_rec.required_flag,
l_regionItem_rec.security_code,
l_regionItem_rec.default_value_varchar2,
l_regionItem_rec.default_value_number,
l_regionItem_rec.default_value_date,
l_regionItem_rec.lov_region_application_id,
l_regionItem_rec.lov_region_code,
l_regionItem_rec.lov_foreign_key_name,
l_regionItem_rec.lov_attribute_application_id,
l_regionItem_rec.lov_attribute_code,
l_regionItem_rec.lov_default_flag,
l_regionItem_rec.region_defaulting_api_pkg,
l_regionItem_rec.region_defaulting_api_proc,
l_regionItem_rec.region_validation_api_pkg,
l_regionItem_rec.region_validation_api_proc,
l_regionItem_rec.order_sequence,
l_regionItem_rec.order_direction,
l_regionItem_rec.display_height,
l_regionItem_rec.submit,
l_regionItem_rec.encrypt,
l_regionItem_rec.css_class_name,
l_regionItem_rec.view_usage_name,
l_regionItem_rec.view_attribute_name,
l_regionItem_rec.url,
l_regionItem_rec.poplist_viewobject,
l_regionItem_rec.poplist_display_attr,
l_regionItem_rec.poplist_value_attr,
l_regionItem_rec.image_file_name,
l_regionItem_rec.item_name,
l_regionItem_rec.css_label_class_name,
l_regionItem_rec.menu_name,
l_regionItem_rec.flexfield_name,
l_regionItem_rec.flexfield_application_id,
l_regionItem_rec.tabular_function_code,
l_regionItem_rec.tip_type,
l_regionItem_rec.tip_message_name,
l_regionItem_rec.tip_message_application_id,
l_regionItem_rec.flex_segment_list,
l_regionItem_rec.entity_id,
l_regionItem_rec.anchor,
l_regionItem_rec.poplist_view_usage_name,
l_regionItem_rec.user_customizable,
l_regionItem_rec.sortby_view_attribute_name,
l_regionItem_rec.admin_customizable,
l_regionItem_rec.invoke_function_name,
l_regionItem_rec.expansion,
l_regionItem_rec.als_max_length,
l_regionItem_rec.initial_sort_sequence,
l_regionItem_rec.customization_application_id,
l_regionItem_rec.customization_code,
l_regionItem_rec.attribute_category,
l_regionItem_rec.attribute1,
l_regionItem_rec.attribute2,
l_regionItem_rec.attribute3,
l_regionItem_rec.attribute4,
l_regionItem_rec.attribute5,
l_regionItem_rec.attribute6,
l_regionItem_rec.attribute7,
l_regionItem_rec.attribute8,
l_regionItem_rec.attribute9,
l_regionItem_rec.attribute10,
l_regionItem_rec.attribute12,
l_regionItem_rec.attribute13,
l_regionItem_rec.attribute14,
l_regionItem_rec.attribute15,
l_regionItem_rec.attribute_label_short,
l_regionItem_rec.description;
AK_REGION_ITEMS_PKG.UPDATE_ROW (
X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
X_REGION_CODE => X_REGION_CODE,
X_ATTRIBUTE_APPLICATION_ID => X_ATTRIBUTE_APPLICATION_ID,
X_ATTRIBUTE_CODE => X_ATTRIBUTE_CODE,
X_DISPLAY_SEQUENCE => X_DISPLAY_SEQUENCE,
X_NODE_DISPLAY_FLAG => X_NODE_DISPLAY_FLAG,
X_NODE_QUERY_FLAG => X_NODE_QUERY_FLAG,
X_ATTRIBUTE_LABEL_LENGTH => X_ATTRIBUTE_LABEL_LENGTH,
X_BOLD => l_regionItem_rec.bold,
X_ITALIC => l_regionItem_rec.italic,
X_VERTICAL_ALIGNMENT => l_regionItem_rec.VERTICAL_ALIGNMENT,
X_HORIZONTAL_ALIGNMENT => l_regionItem_rec.HORIZONTAL_ALIGNMENT,
X_ITEM_STYLE => l_regionItem_rec.ITEM_STYLE,
X_OBJECT_ATTRIBUTE_FLAG => l_regionItem_rec.OBJECT_ATTRIBUTE_FLAG,
X_ATTRIBUTE_LABEL_LONG => X_ATTRIBUTE_LABEL_LONG,
X_DESCRIPTION => l_regionItem_rec.description,
X_SECURITY_CODE => l_regionItem_rec.security_code,
X_UPDATE_FLAG => l_regionItem_rec.UPDATE_FLAG,
X_REQUIRED_FLAG => l_regionItem_rec.REQUIRED_FLAG,
X_DISPLAY_VALUE_LENGTH => X_DISPLAY_VALUE_LENGTH,
X_LOV_REGION_APPLICATION_ID => l_regionItem_rec.lov_region_application_id,
X_LOV_REGION_CODE => l_regionItem_rec.lov_region_code,
X_LOV_FOREIGN_KEY_NAME => l_regionItem_rec.lov_foreign_key_name,
X_LOV_ATTRIBUTE_APPLICATION_ID => l_regionItem_rec.lov_attribute_application_id,
X_LOV_ATTRIBUTE_CODE => l_regionItem_rec.lov_attribute_code,
X_LOV_DEFAULT_FLAG => l_regionItem_rec.lov_default_flag,
X_REGION_DEFAULTING_API_PKG => l_regionItem_rec.region_defaulting_api_pkg,
X_REGION_DEFAULTING_API_PROC => l_regionItem_rec.region_defaulting_api_proc,
X_REGION_VALIDATION_API_PKG => l_regionItem_rec.region_validation_api_pkg,
X_REGION_VALIDATION_API_PROC => l_regionItem_rec.region_validation_api_proc,
X_ORDER_SEQUENCE => X_ORDER_SEQUENCE,
X_ORDER_DIRECTION => l_regionItem_rec.order_direction,
X_DEFAULT_VALUE_VARCHAR2 => l_regionItem_rec.default_value_varchar2,
X_DEFAULT_VALUE_NUMBER => l_regionItem_rec.default_value_number,
X_DEFAULT_VALUE_DATE => l_regionItem_rec.default_value_date,
X_ITEM_NAME => l_regionItem_rec.item_name,
X_DISPLAY_HEIGHT => l_regionItem_rec.display_height,
X_SUBMIT => l_regionItem_rec.submit,
X_ENCRYPT => l_regionItem_rec.encrypt,
X_VIEW_USAGE_NAME => l_regionItem_rec.view_usage_name,
X_VIEW_ATTRIBUTE_NAME => l_regionItem_rec.view_attribute_name,
X_CSS_CLASS_NAME => l_regionItem_rec.css_class_name,
X_CSS_LABEL_CLASS_NAME => l_regionItem_rec.css_label_class_name,
X_URL => l_regionItem_rec.url,
X_POPLIST_VIEWOBJECT => l_regionItem_rec.poplist_viewobject,
X_POPLIST_DISPLAY_ATTRIBUTE => l_regionItem_rec.poplist_display_attr,
X_POPLIST_VALUE_ATTRIBUTE => l_regionItem_rec.poplist_value_attr,
X_IMAGE_FILE_NAME => l_regionItem_rec.image_file_name,
X_NESTED_REGION_CODE => X_NESTED_REGION_CODE,
X_NESTED_REGION_APPL_ID => X_NESTED_REGION_APPL_ID,
X_MENU_NAME =>l_regionItem_rec.menu_name,
X_FLEXFIELD_NAME => l_regionItem_rec.flexfield_name,
X_FLEXFIELD_APPLICATION_ID => l_regionItem_rec.flexfield_application_id,
X_TABULAR_FUNCTION_CODE => l_regionItem_rec.tabular_function_code,
X_TIP_TYPE => l_regionItem_rec.tip_type,
X_TIP_MESSAGE_NAME => l_regionItem_rec.tip_message_name,
X_TIP_MESSAGE_APPLICATION_ID => l_regionItem_rec.tip_message_application_id,
X_FLEX_SEGMENT_LIST => l_regionItem_rec.flex_segment_list,
X_ENTITY_ID => l_regionItem_rec.entity_id,
X_ANCHOR => l_regionItem_rec.anchor,
X_POPLIST_VIEW_USAGE_NAME => l_regionItem_rec.poplist_view_usage_name,
X_USER_CUSTOMIZABLE => l_regionItem_rec.user_customizable,
X_ADMIN_CUSTOMIZABLE => l_regionItem_rec.admin_customizable,
X_INVOKE_FUNCTION_NAME => l_regionItem_rec.invoke_function_name,
X_EXPANSION =>l_regionItem_rec.expansion,
X_ALS_MAX_LENGTH => l_regionItem_rec.als_max_length,
X_SORTBY_VIEW_ATTRIBUTE_NAME =>l_regionItem_rec.sortby_view_attribute_name,
X_ICX_CUSTOM_CALL => l_regionItem_rec.icx_custom_call,
X_INITIAL_SORT_SEQUENCE => l_regionItem_rec.initial_sort_sequence,
X_CUSTOMIZATION_APPLICATION_ID => l_regionItem_rec.customization_application_id,
X_CUSTOMIZATION_CODE => l_regionItem_rec.customization_code,
X_LAST_UPDATE_DATE => sysdate,
X_LAST_UPDATED_BY => X_USER_ID,
X_LAST_UPDATE_LOGIN => X_USER_ID,
X_ATTRIBUTE_CATEGORY => X_ATTRIBUTE_CATEGORY,
X_ATTRIBUTE1 => X_ATTRIBUTE1,
X_ATTRIBUTE2 => X_ATTRIBUTE2,
X_ATTRIBUTE3 => X_ATTRIBUTE3,
X_ATTRIBUTE4 => X_ATTRIBUTE4,
X_ATTRIBUTE5 => X_ATTRIBUTE5,
X_ATTRIBUTE6 => X_ATTRIBUTE6,
X_ATTRIBUTE7 => X_ATTRIBUTE7,
X_ATTRIBUTE8 => X_ATTRIBUTE8,
X_ATTRIBUTE9 => X_ATTRIBUTE9,
X_ATTRIBUTE10 => X_ATTRIBUTE10,
X_ATTRIBUTE11 => X_ATTRIBUTE11,
X_ATTRIBUTE12 => X_ATTRIBUTE12,
X_ATTRIBUTE13 => X_ATTRIBUTE13,
X_ATTRIBUTE14 => X_ATTRIBUTE14,
X_ATTRIBUTE15 => X_ATTRIBUTE15);
end UPDATE_REGION_ITEM_ROW;
PROCEDURE DELETE_REGION_ITEM_ROW (
X_REGION_APPLICATION_ID IN NUMBER,
X_REGION_CODE IN VARCHAR2,
X_ATTRIBUTE_APPLICATION_ID IN NUMBER,
X_ATTRIBUTE_CODE IN VARCHAR2
) IS
BEGIN
AK_REGION_ITEMS_PKG.DELETE_ROW(
X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
X_REGION_CODE => X_REGION_CODE,
X_ATTRIBUTE_APPLICATION_ID => X_ATTRIBUTE_APPLICATION_ID,
X_ATTRIBUTE_CODE => X_ATTRIBUTE_CODE
);
END DELETE_REGION_ITEM_ROW;
procedure INSERT_REGION_ROW (
p_REGION_CODE in VARCHAR2
,p_REGION_APPLICATION_ID in NUMBER
,p_DATABASE_OBJECT_NAME in VARCHAR2
,p_NAME in VARCHAR2
,p_REGION_STYLE in VARCHAR2 := c_TABLE_LAYOUT_STYLE
,p_DESCRIPTION in VARCHAR2 := NULL
,p_APPL_MODULE_OBJECT_TYPE in VARCHAR2 := NULL
,p_ATTRIBUTE_CATEGORY in VARCHAR2 := NULL
,p_ATTRIBUTE1 in VARCHAR2 := NULL
,p_ATTRIBUTE2 in VARCHAR2 := NULL
,p_ATTRIBUTE3 in VARCHAR2 := NULL
,p_ATTRIBUTE4 in VARCHAR2 := NULL
,p_ATTRIBUTE5 in VARCHAR2 := NULL
,p_ATTRIBUTE6 in VARCHAR2 := NULL
,p_ATTRIBUTE7 in VARCHAR2 := NULL
,p_ATTRIBUTE8 in VARCHAR2 := NULL
,p_ATTRIBUTE9 in VARCHAR2 := NULL
,p_ATTRIBUTE10 in VARCHAR2 := NULL
,p_ATTRIBUTE11 in VARCHAR2 := NULL
,p_ATTRIBUTE12 in VARCHAR2 := NULL
,p_ATTRIBUTE13 in VARCHAR2 := NULL
,p_ATTRIBUTE14 in VARCHAR2 := NULL
,p_ATTRIBUTE15 in VARCHAR2 := NULL
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
) is
l_rowid Varchar2(30);
INSERT_AK_OBJECT(
P_DATABASE_OBJECT_NAME => p_DATABASE_OBJECT_NAME ,
P_APPLICATION_ID => p_REGION_APPLICATION_ID);
AK_REGIONS_PKG.INSERT_ROW(
X_ROWID => l_ROWID,
X_REGION_APPLICATION_ID => p_REGION_APPLICATION_ID,
X_REGION_CODE => upper(p_REGION_CODE),
X_DATABASE_OBJECT_NAME => p_DATABASE_OBJECT_NAME,
X_REGION_STYLE => p_REGION_STYLE,
X_NUM_COLUMNS => null,
X_ICX_CUSTOM_CALL => null,
X_NAME => p_NAME,
X_DESCRIPTION => p_DESCRIPTION,
X_REGION_DEFAULTING_API_PKG => null,
X_REGION_DEFAULTING_API_PROC => null,
X_REGION_VALIDATION_API_PKG => null,
X_REGION_VALIDATION_API_PROC => null,
X_APPL_MODULE_OBJECT_TYPE => p_appl_module_object_type,
X_NUM_ROWS_DISPLAY => null,
X_REGION_OBJECT_TYPE => null,
X_IMAGE_FILE_NAME => l_image_file_name,
X_ISFORM_FLAG => c_ISFORM_FLAG,
X_HELP_TARGET => null,
X_STYLE_SHEET_FILENAME => null,
X_VERSION => null,
X_APPLICATIONMODULE_USAGE_NAME=>null,
X_ADD_INDEXED_CHILDREN => c_ADD_INDEXED_CHILDREN,
X_CREATION_DATE => sysdate,
X_CREATED_BY => fnd_global.user_id,
X_LAST_UPDATE_DATE => sysdate,
X_LAST_UPDATED_BY => fnd_global.user_id,
X_LAST_UPDATE_LOGIN => fnd_global.user_id,
X_ATTRIBUTE_CATEGORY => p_ATTRIBUTE_CATEGORY,
X_ATTRIBUTE1 => p_ATTRIBUTE1,
X_ATTRIBUTE2 => p_ATTRIBUTE2,
X_ATTRIBUTE3 => p_ATTRIBUTE3,
X_ATTRIBUTE4 => p_ATTRIBUTE4,
X_ATTRIBUTE5 => p_ATTRIBUTE5,
X_ATTRIBUTE6 => p_ATTRIBUTE6,
X_ATTRIBUTE7 => p_ATTRIBUTE7,
X_ATTRIBUTE8 => p_ATTRIBUTE8,
X_ATTRIBUTE9 => p_ATTRIBUTE9,
X_ATTRIBUTE10 => p_ATTRIBUTE10,
X_ATTRIBUTE11 => p_ATTRIBUTE11,
X_ATTRIBUTE12 => p_ATTRIBUTE12,
X_ATTRIBUTE13 => p_ATTRIBUTE13,
X_ATTRIBUTE14 => p_ATTRIBUTE14,
X_ATTRIBUTE15 => p_ATTRIBUTE15);
x_msg_data := 'BIS_AK_REGION_PUB.INSERT_ROW: ' || SQLERRM;
end INSERT_REGION_ROW;
PROCEDURE INSERT_REGION_ROW
( p_commit IN VARCHAR2 := FND_API.G_TRUE
, p_Report_Region_Rec IN BIS_AK_REGION_PUB.Bis_Region_Rec_Type
, x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
) IS
l_rowid VARCHAR2(30);
INSERT_AK_OBJECT(
P_DATABASE_OBJECT_NAME => p_Report_Region_Rec.Database_Object_Name,
P_APPLICATION_ID => p_Report_Region_Rec.Region_Application_Id);
AK_REGIONS_PKG.INSERT_ROW
( X_ROWID => l_rowid
, X_REGION_APPLICATION_ID => p_Report_Region_Rec.Region_Application_Id
, X_REGION_CODE => UPPER(p_Report_Region_Rec.Region_Code)
, X_DATABASE_OBJECT_NAME => p_Report_Region_Rec.Database_Object_Name
, X_REGION_STYLE => p_Report_Region_Rec.Region_Style
, X_NUM_COLUMNS => NULL
, X_ICX_CUSTOM_CALL => NULL
, X_NAME => p_Report_Region_Rec.Region_Name
, X_DESCRIPTION => p_Report_Region_Rec.Region_Description
, X_REGION_DEFAULTING_API_PKG => NULL
, X_REGION_DEFAULTING_API_PROC => NULL
, X_REGION_VALIDATION_API_PKG => NULL
, X_REGION_VALIDATION_API_PROC => NULL
, X_APPL_MODULE_OBJECT_TYPE => NULL
, X_NUM_ROWS_DISPLAY => p_Report_Region_Rec.Display_Rows
, X_REGION_OBJECT_TYPE => p_Report_Region_Rec.Region_Object_Type
, X_IMAGE_FILE_NAME => NULL
, X_ISFORM_FLAG => c_ISFORM_FLAG
, X_HELP_TARGET => p_Report_Region_Rec.Help_Target
, X_STYLE_SHEET_FILENAME => NULL
, X_VERSION => NULL
, X_APPLICATIONMODULE_USAGE_NAME => NULL
, X_ADD_INDEXED_CHILDREN => c_ADD_INDEXED_CHILDREN
, X_CREATION_DATE => SYSDATE
, X_CREATED_BY => fnd_global.user_id
, X_LAST_UPDATE_DATE => SYSDATE
, X_LAST_UPDATED_BY => fnd_global.user_id
, X_LAST_UPDATE_LOGIN => fnd_global.user_id
, X_ATTRIBUTE_CATEGORY => C_ATTRIBUTE_CATEGORY
, X_ATTRIBUTE1 => p_Report_Region_Rec.Disable_View_By
, X_ATTRIBUTE2 => p_Report_Region_Rec.No_Of_Portlet_Rows
, X_ATTRIBUTE3 => p_Report_Region_Rec.Schedule
, X_ATTRIBUTE4 => p_Report_Region_Rec.Header_File_Procedure
, X_ATTRIBUTE5 => p_Report_Region_Rec.Footer_File_Procedure
, X_ATTRIBUTE6 => p_Report_Region_Rec.Group_By
, X_ATTRIBUTE7 => p_Report_Region_Rec.Order_By
, X_ATTRIBUTE8 => p_Report_Region_Rec.Plsql_For_Report_Query
, X_ATTRIBUTE9 => p_Report_Region_Rec.Display_Subtotals
, X_ATTRIBUTE10 => p_Report_Region_Rec.Data_Source
, X_ATTRIBUTE11 => p_Report_Region_Rec.Where_Clause
, X_ATTRIBUTE12 => p_Report_Region_Rec.Dimension_Group
, X_ATTRIBUTE13 => p_Report_Region_Rec.Parameter_Layout
, X_ATTRIBUTE14 => NULL
, X_ATTRIBUTE15 => NULL
);
x_msg_data := 'BIS_AK_REGION_PUB.INSERT_REGION_ROW: ' || SQLERRM;
END INSERT_REGION_ROW;
procedure UPDATE_REGION_ROW (
p_REGION_CODE in VARCHAR2
,p_REGION_APPLICATION_ID in NUMBER
,p_DATABASE_OBJECT_NAME in VARCHAR2
,p_NAME in VARCHAR2
,p_REGION_STYLE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
,p_DESCRIPTION in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
,p_APPL_MODULE_OBJECT_TYPE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
,p_ATTRIBUTE_CATEGORY in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
,p_ATTRIBUTE1 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
,p_ATTRIBUTE2 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
,p_ATTRIBUTE3 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
,p_ATTRIBUTE4 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
,p_ATTRIBUTE5 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
,p_ATTRIBUTE6 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
,p_ATTRIBUTE7 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
,p_ATTRIBUTE8 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
,p_ATTRIBUTE9 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
,p_ATTRIBUTE10 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
,p_ATTRIBUTE11 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
,p_ATTRIBUTE12 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
,p_ATTRIBUTE13 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
,p_ATTRIBUTE14 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
,p_ATTRIBUTE15 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
) is
l_region_rec AK_REGION_PUB.Region_Rec_Type;
select icx_custom_call,
num_columns,
region_defaulting_api_pkg,
region_defaulting_api_proc,
region_validation_api_pkg,
region_validation_api_proc,
applicationmodule_object_type,
image_file_name,
isform_flag,
help_target,
style_sheet_filename,
version,
applicationmodule_usage_name,
add_indexed_children,
stateful_flag,
function_name,
children_view_usage_name,
search_panel,
advanced_search_panel,
customize_panel,
default_search_panel,
results_based_search,
display_graph_table,
disable_header,
standalone,
auto_customization_criteria,
region_style,
name,
description,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15
from ak_regions_vl
where region_code = p_REGION_CODE
and region_application_id = p_REGION_APPLICATION_ID;
AK_REGIONS_PKG.UPDATE_ROW(
X_REGION_APPLICATION_ID => p_REGION_APPLICATION_ID,
X_REGION_CODE => p_REGION_CODE,
X_DATABASE_OBJECT_NAME => p_DATABASE_OBJECT_NAME,
X_REGION_STYLE => l_region_rec.region_style,
X_NUM_COLUMNS =>l_region_rec.num_columns,
X_ICX_CUSTOM_CALL => l_region_rec.icx_custom_call,
X_NAME => l_region_rec.name,
X_DESCRIPTION => l_region_rec.description,
X_REGION_DEFAULTING_API_PKG => l_region_rec.region_defaulting_api_pkg,
X_REGION_DEFAULTING_API_PROC => l_region_rec.region_defaulting_api_proc,
X_REGION_VALIDATION_API_PKG => l_region_rec.region_validation_api_pkg,
X_REGION_VALIDATION_API_PROC => l_region_rec.region_validation_api_proc,
X_APPL_MODULE_OBJECT_TYPE => l_region_rec.applicationmodule_object_type,
X_NUM_ROWS_DISPLAY => null,
X_REGION_OBJECT_TYPE => Null,
X_IMAGE_FILE_NAME => l_region_rec.image_file_name,
X_ISFORM_FLAG => l_region_rec.isform_flag,
X_HELP_TARGET => l_region_rec.help_target,
X_STYLE_SHEET_FILENAME => l_region_rec.style_sheet_filename,
X_VERSION => l_region_rec.version,
X_APPLICATIONMODULE_USAGE_NAME => l_region_rec.applicationmodule_usage_name,
X_ADD_INDEXED_CHILDREN => l_region_rec.add_indexed_children,
X_STATEFUL_FLAG => l_region_rec.stateful_flag,
X_FUNCTION_NAME => l_region_rec.function_name,
X_CHILDREN_VIEW_USAGE_NAME => l_region_rec.children_view_usage_name,
X_SEARCH_PANEL => l_region_rec.search_panel,
X_ADVANCED_SEARCH_PANEL =>l_region_rec.advanced_search_panel,
X_CUSTOMIZE_PANEL => l_region_rec.customize_panel,
X_DEFAULT_SEARCH_PANEL => l_region_rec.default_search_panel,
X_RESULTS_BASED_SEARCH => l_region_rec.results_based_search,
X_DISPLAY_GRAPH_TABLE => l_region_rec.display_graph_table,
X_DISABLE_HEADER => l_region_rec.disable_header,
X_STANDALONE => l_region_rec.standalone,
X_AUTO_CUSTOMIZATION_CRITERIA =>l_region_rec.auto_customization_criteria,
X_LAST_UPDATE_DATE => sysdate,
X_LAST_UPDATED_BY => fnd_global.user_id,
X_LAST_UPDATE_LOGIN => fnd_global.user_id,
X_ATTRIBUTE_CATEGORY => l_region_rec.ATTRIBUTE_CATEGORY,
X_ATTRIBUTE1 => l_region_rec.attribute1,
X_ATTRIBUTE2 => l_region_rec.attribute2,
X_ATTRIBUTE3 => l_region_rec.attribute3,
X_ATTRIBUTE4 => l_region_rec.attribute4,
X_ATTRIBUTE5 => l_region_rec.attribute5,
X_ATTRIBUTE6 => l_region_rec.attribute6,
X_ATTRIBUTE7 => l_region_rec.attribute7,
X_ATTRIBUTE8 => l_region_rec.attribute8,
X_ATTRIBUTE9 => l_region_rec.attribute9,
X_ATTRIBUTE10 => l_region_rec.attribute10,
X_ATTRIBUTE11 => l_region_rec.attribute11,
X_ATTRIBUTE12 => l_region_rec.attribute12,
X_ATTRIBUTE13 => l_region_rec.attribute13,
X_ATTRIBUTE14 => l_region_rec.attribute14,
X_ATTRIBUTE15 => l_region_rec.attribute15);
x_msg_data := 'BIS_AK_REGION_PUB.UPDATE_REGION_ROW: ' || SQLERRM;
end UPDATE_REGION_ROW;
PROCEDURE UPDATE_REGION_ROW
( p_commit IN VARCHAR2 := FND_API.G_TRUE
, p_Report_Region_Rec IN BIS_AK_REGION_PUB.Bis_Region_Rec_Type
, x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
) IS
l_region_rec AK_REGION_PUB.Region_Rec_Type;
SELECT icx_custom_call,
num_columns,
region_defaulting_api_pkg,
region_defaulting_api_proc,
region_validation_api_pkg,
region_validation_api_proc,
applicationmodule_object_type,
image_file_name,
isform_flag,
help_target,
style_sheet_filename,
version,
applicationmodule_usage_name,
add_indexed_children,
stateful_flag,
function_name,
children_view_usage_name,
search_panel,
advanced_search_panel,
customize_panel,
default_search_panel,
results_based_search,
display_graph_table,
disable_header,
standalone,
auto_customization_criteria,
region_style,
name,
description,
num_rows_display,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15
FROM ak_regions_vl
WHERE region_code = p_Report_Region_Rec.Region_Code
AND region_application_id = p_Report_Region_Rec.Region_Application_Id;
AK_REGIONS_PKG.UPDATE_ROW(
X_REGION_APPLICATION_ID => p_Report_Region_Rec.Region_Application_Id,
X_REGION_CODE => p_Report_Region_Rec.Region_Code,
X_DATABASE_OBJECT_NAME => p_Report_Region_Rec.Database_Object_Name,
X_REGION_STYLE => l_region_rec.region_style,
X_NUM_COLUMNS => l_region_rec.num_columns,
X_ICX_CUSTOM_CALL => l_region_rec.icx_custom_call,
X_NAME => l_region_rec.name,
X_DESCRIPTION => l_region_rec.description,
X_REGION_DEFAULTING_API_PKG => l_region_rec.region_defaulting_api_pkg,
X_REGION_DEFAULTING_API_PROC => l_region_rec.region_defaulting_api_proc,
X_REGION_VALIDATION_API_PKG => l_region_rec.region_validation_api_pkg,
X_REGION_VALIDATION_API_PROC => l_region_rec.region_validation_api_proc,
X_APPL_MODULE_OBJECT_TYPE => l_region_rec.applicationmodule_object_type,
X_NUM_ROWS_DISPLAY => l_region_rec.num_rows_display,
X_REGION_OBJECT_TYPE => p_Report_Region_Rec.Region_Object_Type,
X_IMAGE_FILE_NAME => l_region_rec.image_file_name,
X_ISFORM_FLAG => l_region_rec.isform_flag,
X_HELP_TARGET => p_Report_Region_Rec.Help_Target,
X_STYLE_SHEET_FILENAME => l_region_rec.style_sheet_filename,
X_VERSION => l_region_rec.version,
X_APPLICATIONMODULE_USAGE_NAME => l_region_rec.applicationmodule_usage_name,
X_ADD_INDEXED_CHILDREN => l_region_rec.add_indexed_children,
X_STATEFUL_FLAG => l_region_rec.stateful_flag,
X_FUNCTION_NAME => l_region_rec.function_name,
X_CHILDREN_VIEW_USAGE_NAME => l_region_rec.children_view_usage_name,
X_SEARCH_PANEL => l_region_rec.search_panel,
X_ADVANCED_SEARCH_PANEL =>l_region_rec.advanced_search_panel,
X_CUSTOMIZE_PANEL => l_region_rec.customize_panel,
X_DEFAULT_SEARCH_PANEL => l_region_rec.default_search_panel,
X_RESULTS_BASED_SEARCH => l_region_rec.results_based_search,
X_DISPLAY_GRAPH_TABLE => l_region_rec.display_graph_table,
X_DISABLE_HEADER => l_region_rec.disable_header,
X_STANDALONE => l_region_rec.standalone,
X_AUTO_CUSTOMIZATION_CRITERIA =>l_region_rec.auto_customization_criteria,
X_LAST_UPDATE_DATE => SYSDATE,
X_LAST_UPDATED_BY => fnd_global.user_id,
X_LAST_UPDATE_LOGIN => fnd_global.user_id,
X_ATTRIBUTE_CATEGORY => l_region_rec.ATTRIBUTE_CATEGORY,
X_ATTRIBUTE1 => l_region_rec.attribute1,
X_ATTRIBUTE2 => l_region_rec.attribute2,
X_ATTRIBUTE3 => l_region_rec.attribute3,
X_ATTRIBUTE4 => l_region_rec.attribute4,
X_ATTRIBUTE5 => l_region_rec.attribute5,
X_ATTRIBUTE6 => l_region_rec.attribute6,
X_ATTRIBUTE7 => l_region_rec.attribute7,
X_ATTRIBUTE8 => l_region_rec.attribute8,
X_ATTRIBUTE9 => l_region_rec.attribute9,
X_ATTRIBUTE10 => l_region_rec.attribute10,
X_ATTRIBUTE11 => l_region_rec.attribute11,
X_ATTRIBUTE12 => l_region_rec.attribute12,
X_ATTRIBUTE13 => l_region_rec.attribute13,
X_ATTRIBUTE14 => l_region_rec.attribute14,
X_ATTRIBUTE15 => l_region_rec.attribute15);
x_msg_data := 'BIS_AK_REGION_PUB.UPDATE_REGION_ROW: ' || SQLERRM;
END UPDATE_REGION_ROW;
PROCEDURE DELETE_REGION_ROW
(p_REGION_CODE in VARCHAR2
,p_REGION_APPLICATION_ID in NUMBER
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
,p_commit IN VARCHAR2 := FND_API.G_FALSE
) IS
BEGIN
x_Return_Status := FND_API.G_RET_STS_SUCCESS;
AK_REGIONS_PKG.DELETE_ROW(
X_REGION_APPLICATION_ID => p_REGION_APPLICATION_ID,
X_REGION_CODE => p_REGION_CODE
);
x_msg_data := 'BIS_AK_REGION_PUB.DELETE_REGION_ROW: ' || SQLERRM;
END DELETE_REGION_ROW;
procedure INSERT_REGION_ITEM_ROW (
p_REGION_CODE in VARCHAR2
,p_REGION_APPLICATION_ID in NUMBER
,p_ATTRIBUTE_CODE in VARCHAR2
,p_ATTRIBUTE_APPLICATION_ID in NUMBER
,p_DISPLAY_SEQUENCE in number
,p_NODE_DISPLAY_FLAG in VARCHAR2 := 'Y'
,p_ATTRIBUTE_LABEL_LONG in VARCHAR2 := NULL
,p_NESTED_REGION_CODE in VARCHAR2 := NULL
,p_NESTED_REGION_APPL_ID in NUMBER := NULL
,p_ATTRIBUTE_CATEGORY in VARCHAR2 := NULL
,p_ATTRIBUTE1 in VARCHAR2 := NULL
,p_ATTRIBUTE2 in VARCHAR2 := NULL
,p_ATTRIBUTE3 in VARCHAR2 := NULL
,p_ATTRIBUTE4 in VARCHAR2 := NULL
,p_ATTRIBUTE5 in VARCHAR2 := NULL
,p_ATTRIBUTE6 in VARCHAR2 := NULL
,p_ATTRIBUTE7 in VARCHAR2 := NULL
,p_ATTRIBUTE8 in VARCHAR2 := NULL
,p_ATTRIBUTE9 in VARCHAR2 := NULL
,p_ATTRIBUTE10 in VARCHAR2 := NULL
,p_ATTRIBUTE11 in VARCHAR2 := NULL
,p_ATTRIBUTE12 in VARCHAR2 := NULL
,p_ATTRIBUTE13 in VARCHAR2 := NULL
,p_ATTRIBUTE14 in VARCHAR2 := NULL
,p_ATTRIBUTE15 in VARCHAR2 := NULL
,p_URL in VARCHAR2 := NULL
,p_ORDER_SEQUENCE in VARCHAR2 := NULL
,p_ORDER_DIRECTION in VARCHAR2 := NULL
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
) is
l_label_length number;
select count(1)
from ak_attributes
where attribute_code = p_ATTRIBUTE_CODE
and attribute_application_id = p_ATTRIBUTE_APPLICATION_ID;
AK_ATTRIBUTES_PKG.INSERT_ROW (
X_ROWID => l_attribute_rowid,
X_ATTRIBUTE_APPLICATION_ID => p_ATTRIBUTE_APPLICATION_ID,
X_ATTRIBUTE_CODE => p_ATTRIBUTE_CODE,
X_ATTRIBUTE_LABEL_LENGTH => c_ATTR_LABEL_LENGTH,
X_ATTRIBUTE_VALUE_LENGTH => c_ATTR_VALUE_LENGTH,
X_BOLD => c_BOLD,
X_ITALIC => c_ITALIC,
X_UPPER_CASE_FLAG => c_UPPER_CASE_FLAG,
X_VERTICAL_ALIGNMENT => c_VERTICAL_ALIGNMENT,
X_HORIZONTAL_ALIGNMENT => c_HORIZONTAL_ALIGNMENT,
X_DEFAULT_VALUE_VARCHAR2 => null,
X_DEFAULT_VALUE_NUMBER => null,
X_DEFAULT_VALUE_DATE => null,
X_LOV_REGION_CODE => null,
X_LOV_REGION_APPLICATION_ID => null,
X_DATA_TYPE => c_ATTR_DATATYPE,
X_DISPLAY_HEIGHT => null,
X_ITEM_STYLE => c_TEXT_STYLE,
X_CSS_CLASS_NAME => null,
X_CSS_LABEL_CLASS_NAME => null,
X_PRECISION => null,
X_EXPANSION => null,
X_ALS_MAX_LENGTH => null,
X_POPLIST_VIEWOBJECT => null,
X_POPLIST_DISPLAY_ATTRIBUTE => null,
X_POPLIST_VALUE_ATTRIBUTE => null,
X_ATTRIBUTE_CATEGORY => null,
X_ATTRIBUTE1 => null,
X_ATTRIBUTE2 => null,
X_ATTRIBUTE3 => null,
X_ATTRIBUTE4 => null,
X_ATTRIBUTE5 => null,
X_ATTRIBUTE6 => null,
X_ATTRIBUTE7 => null,
X_ATTRIBUTE8 => null,
X_ATTRIBUTE9 => null,
X_ATTRIBUTE10 => null,
X_ATTRIBUTE11 => null,
X_ATTRIBUTE12 => null,
X_ATTRIBUTE13 => null,
X_ATTRIBUTE14 => null,
X_ATTRIBUTE15 => null,
X_NAME => p_ATTRIBUTE_CODE,
X_ATTRIBUTE_LABEL_LONG => null,
X_ATTRIBUTE_LABEL_SHORT => null,
X_DESCRIPTION => null,
X_CREATION_DATE => sysdate,
X_CREATED_BY => fnd_global.user_id,
X_LAST_UPDATE_DATE => sysdate,
X_LAST_UPDATED_BY => fnd_global.user_id,
X_LAST_UPDATE_LOGIN => fnd_global.user_id);
AK_REGION_ITEMS_PKG.INSERT_ROW (
X_ROWID => l_ROWID,
X_REGION_APPLICATION_ID => p_REGION_APPLICATION_ID,
X_REGION_CODE => upper(p_REGION_CODE),
X_ATTRIBUTE_APPLICATION_ID => p_ATTRIBUTE_APPLICATION_ID,
X_ATTRIBUTE_CODE => upper(p_ATTRIBUTE_CODE),
X_DISPLAY_SEQUENCE => p_DISPLAY_SEQUENCE,
X_NODE_DISPLAY_FLAG => c_NODE_DISPLAY_FLAG,
X_NODE_QUERY_FLAG => c_NODE_QUERY_FLAG,
X_ATTRIBUTE_LABEL_LENGTH => l_label_length,
X_BOLD => c_BOLD,
X_ITALIC => c_ITALIC,
X_VERTICAL_ALIGNMENT => c_VERTICAL_ALIGNMENT,
X_HORIZONTAL_ALIGNMENT => c_HORIZONTAL_ALIGNMENT,
X_ITEM_STYLE => l_item_style,
X_OBJECT_ATTRIBUTE_FLAG => c_OBJECT_ATTRIBUTE_FLAG,
X_ATTRIBUTE_LABEL_LONG => p_ATTRIBUTE_LABEL_LONG,
X_DESCRIPTION => null,
X_SECURITY_CODE => null,
X_UPDATE_FLAG => c_UPDATE_FLAG,
X_REQUIRED_FLAG => c_REQUIRED_FLAG,
X_DISPLAY_VALUE_LENGTH => 0,
X_LOV_REGION_APPLICATION_ID => null,
X_LOV_REGION_CODE => null,
X_LOV_FOREIGN_KEY_NAME => null,
X_LOV_ATTRIBUTE_APPLICATION_ID => null,
X_LOV_ATTRIBUTE_CODE => null,
X_LOV_DEFAULT_FLAG => null,
X_REGION_DEFAULTING_API_PKG => null,
X_REGION_DEFAULTING_API_PROC => null,
X_REGION_VALIDATION_API_PKG => null,
X_REGION_VALIDATION_API_PROC => null,
X_ORDER_SEQUENCE => p_ORDER_SEQUENCE,
X_ORDER_DIRECTION => p_ORDER_DIRECTION,
X_DEFAULT_VALUE_VARCHAR2 => null,
X_DEFAULT_VALUE_NUMBER => null,
X_DEFAULT_VALUE_DATE => null,
X_ITEM_NAME => replace(initcap(p_ATTRIBUTE_CODE), '_', ''),
X_DISPLAY_HEIGHT => c_DISPLAY_HEIGHT,
X_SUBMIT => c_SUBMIT,
X_ENCRYPT => c_ENCRYPT,
X_VIEW_USAGE_NAME => null,
X_VIEW_ATTRIBUTE_NAME => null,
X_CSS_CLASS_NAME => null,
X_CSS_LABEL_CLASS_NAME => null,
X_URL => p_URL,
X_POPLIST_VIEWOBJECT => null,
X_POPLIST_DISPLAY_ATTRIBUTE => null,
X_POPLIST_VALUE_ATTRIBUTE => null,
X_IMAGE_FILE_NAME => null,
X_NESTED_REGION_CODE => upper(p_NESTED_REGION_CODE),
X_NESTED_REGION_APPL_ID => l_NESTED_REGION_APPL_ID,
X_MENU_NAME => null,
X_FLEXFIELD_NAME => null,
X_FLEXFIELD_APPLICATION_ID => null,
X_TABULAR_FUNCTION_CODE => null,
X_TIP_TYPE => null,
X_TIP_MESSAGE_NAME => null,
X_TIP_MESSAGE_APPLICATION_ID => null,
X_FLEX_SEGMENT_LIST => null,
X_ENTITY_ID => null,
X_ANCHOR => null,
X_POPLIST_VIEW_USAGE_NAME => null,
X_USER_CUSTOMIZABLE => null,
X_ADMIN_CUSTOMIZABLE => c_ADMIN_CUSTOMIZABLE,
X_INVOKE_FUNCTION_NAME => null,
X_ATTRIBUTE_LABEL_SHORT => null,
X_EXPANSION => null,
X_ALS_MAX_LENGTH => null,
X_SORTBY_VIEW_ATTRIBUTE_NAME => null,
X_ICX_CUSTOM_CALL => null,
X_INITIAL_SORT_SEQUENCE => null,
X_CUSTOMIZATION_APPLICATION_ID => null,
X_CUSTOMIZATION_CODE => null,
X_CREATION_DATE => sysdate,
X_CREATED_BY => fnd_global.user_id,
X_LAST_UPDATE_DATE => sysdate,
X_LAST_UPDATED_BY => fnd_global.user_id,
X_LAST_UPDATE_LOGIN => fnd_global.user_id,
X_ATTRIBUTE_CATEGORY => p_ATTRIBUTE_CATEGORY,
X_ATTRIBUTE1 => p_ATTRIBUTE1,
X_ATTRIBUTE2 => p_ATTRIBUTE2,
X_ATTRIBUTE3 => p_ATTRIBUTE3,
X_ATTRIBUTE4 => p_ATTRIBUTE4,
X_ATTRIBUTE5 => p_ATTRIBUTE5,
X_ATTRIBUTE6 => p_ATTRIBUTE6,
X_ATTRIBUTE7 => p_ATTRIBUTE7,
X_ATTRIBUTE8 => p_ATTRIBUTE8,
X_ATTRIBUTE9 => p_ATTRIBUTE9,
X_ATTRIBUTE10 => p_ATTRIBUTE10,
X_ATTRIBUTE11 => p_ATTRIBUTE11,
X_ATTRIBUTE12 => p_ATTRIBUTE12,
X_ATTRIBUTE13 => p_ATTRIBUTE13,
X_ATTRIBUTE14 => p_ATTRIBUTE14,
X_ATTRIBUTE15 => p_ATTRIBUTE15);
x_msg_data := 'BIS_AK_REGION_PUB.INSERT_REGION_ITEM_ROW: ' || SQLERRM;
end INSERT_REGION_ITEM_ROW;
PROCEDURE INSERT_REGION_ITEM_ROW
( p_commit IN VARCHAR2 := FND_API.G_TRUE
, p_region_code IN VARCHAR2
, p_region_application_id IN NUMBER
, p_Region_Item_Rec IN BIS_AK_REGION_PUB.Bis_Region_Item_Rec_Type
, x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
) IS
l_attribute_rowid VARCHAR2(30);
SELECT COUNT(1)
FROM ak_attributes
WHERE attribute_code = p_Region_Item_Rec.Attribute_Code
AND attribute_application_id = p_Region_Item_Rec.Attribute_Application_Id;
AK_ATTRIBUTES_PKG.INSERT_ROW (
X_ROWID => l_attribute_rowid,
X_ATTRIBUTE_APPLICATION_ID => p_Region_Item_Rec.Attribute_Application_Id,
X_ATTRIBUTE_CODE => UPPER(p_Region_Item_Rec.Attribute_Code),
X_ATTRIBUTE_LABEL_LENGTH => c_ATTR_LABEL_LENGTH,
X_ATTRIBUTE_VALUE_LENGTH => c_ATTR_VALUE_LENGTH,
X_BOLD => c_BOLD,
X_ITALIC => c_ITALIC,
X_UPPER_CASE_FLAG => c_UPPER_CASE_FLAG,
X_VERTICAL_ALIGNMENT => c_VERTICAL_ALIGNMENT,
X_HORIZONTAL_ALIGNMENT => c_HORIZONTAL_ALIGNMENT,
X_DEFAULT_VALUE_VARCHAR2 => NULL,
X_DEFAULT_VALUE_NUMBER => NULL,
X_DEFAULT_VALUE_DATE => NULL,
X_LOV_REGION_CODE => NULL,
X_LOV_REGION_APPLICATION_ID => NULL,
X_DATA_TYPE => c_ATTR_DATATYPE,
X_DISPLAY_HEIGHT => NULL,
X_ITEM_STYLE => c_TEXT_STYLE,
X_CSS_CLASS_NAME => NULL,
X_CSS_LABEL_CLASS_NAME => NULL,
X_PRECISION => NULL,
X_EXPANSION => NULL,
X_ALS_MAX_LENGTH => NULL,
X_POPLIST_VIEWOBJECT => NULL,
X_POPLIST_DISPLAY_ATTRIBUTE => NULL,
X_POPLIST_VALUE_ATTRIBUTE => NULL,
X_ATTRIBUTE_CATEGORY => NULL,
X_ATTRIBUTE1 => NULL,
X_ATTRIBUTE2 => NULL,
X_ATTRIBUTE3 => NULL,
X_ATTRIBUTE4 => NULL,
X_ATTRIBUTE5 => NULL,
X_ATTRIBUTE6 => NULL,
X_ATTRIBUTE7 => NULL,
X_ATTRIBUTE8 => NULL,
X_ATTRIBUTE9 => NULL,
X_ATTRIBUTE10 => NULL,
X_ATTRIBUTE11 => NULL,
X_ATTRIBUTE12 => NULL,
X_ATTRIBUTE13 => NULL,
X_ATTRIBUTE14 => NULL,
X_ATTRIBUTE15 => NULL,
X_NAME => p_Region_Item_Rec.Attribute_Code,
X_ATTRIBUTE_LABEL_LONG => NULL,
X_ATTRIBUTE_LABEL_SHORT => NULL,
X_DESCRIPTION => NULL,
X_CREATION_DATE => SYSDATE,
X_CREATED_BY => fnd_global.user_id,
X_LAST_UPDATE_DATE => SYSDATE,
X_LAST_UPDATED_BY => fnd_global.user_id,
X_LAST_UPDATE_LOGIN => fnd_global.user_id);
AK_REGION_ITEMS_PKG.INSERT_ROW (
X_ROWID => l_rowid,
X_REGION_APPLICATION_ID => p_region_application_id,
X_REGION_CODE => UPPER(p_region_code),
X_ATTRIBUTE_APPLICATION_ID => p_Region_Item_Rec.Attribute_Application_Id,
X_ATTRIBUTE_CODE => UPPER(p_Region_Item_Rec.Attribute_Code),
X_DISPLAY_SEQUENCE => p_Region_Item_Rec.Display_Sequence,
X_NODE_DISPLAY_FLAG => p_Region_Item_Rec.Node_Display_Flag,
X_NODE_QUERY_FLAG => p_Region_Item_Rec.Queryable_Flag,
X_ATTRIBUTE_LABEL_LENGTH => l_label_length,
X_BOLD => c_BOLD,
X_ITALIC => c_ITALIC,
X_VERTICAL_ALIGNMENT => c_VERTICAL_ALIGNMENT,
X_HORIZONTAL_ALIGNMENT => c_HORIZONTAL_ALIGNMENT,
X_ITEM_STYLE => l_Item_Style,
X_OBJECT_ATTRIBUTE_FLAG => c_OBJECT_ATTRIBUTE_FLAG,
X_ATTRIBUTE_LABEL_LONG => p_Region_Item_Rec.Long_Label,
X_DESCRIPTION => NULL,
X_SECURITY_CODE => NULL,
X_UPDATE_FLAG => c_UPDATE_FLAG,
X_REQUIRED_FLAG => p_Region_Item_Rec.Required_Flag,
X_DISPLAY_VALUE_LENGTH => p_Region_Item_Rec.Display_Length,
X_LOV_REGION_APPLICATION_ID => NULL,
X_LOV_REGION_CODE => NULL,
X_LOV_FOREIGN_KEY_NAME => NULL,
X_LOV_ATTRIBUTE_APPLICATION_ID => NULL,
X_LOV_ATTRIBUTE_CODE => NULL,
X_LOV_DEFAULT_FLAG => NULL,
X_REGION_DEFAULTING_API_PKG => NULL,
X_REGION_DEFAULTING_API_PROC => NULL,
X_REGION_VALIDATION_API_PKG => NULL,
X_REGION_VALIDATION_API_PROC => NULL,
X_ORDER_SEQUENCE => p_Region_Item_Rec.Sort_Sequence,
X_ORDER_DIRECTION => p_Region_Item_Rec.Sort_Direction,
X_DEFAULT_VALUE_VARCHAR2 => NULL,
X_DEFAULT_VALUE_NUMBER => NULL,
X_DEFAULT_VALUE_DATE => NULL,
X_ITEM_NAME => REPLACE(INITCAP(p_Region_Item_Rec.Attribute_Code), '_', ''),
X_DISPLAY_HEIGHT => c_DISPLAY_HEIGHT,
X_SUBMIT => c_SUBMIT,
X_ENCRYPT => c_ENCRYPT,
X_VIEW_USAGE_NAME => NULL,
X_VIEW_ATTRIBUTE_NAME => NULL,
X_CSS_CLASS_NAME => NULL,
X_CSS_LABEL_CLASS_NAME => NULL,
X_URL => p_Region_Item_Rec.Url,
X_POPLIST_VIEWOBJECT => NULL,
X_POPLIST_DISPLAY_ATTRIBUTE => NULL,
X_POPLIST_VALUE_ATTRIBUTE => NULL,
X_IMAGE_FILE_NAME => NULL,
X_NESTED_REGION_CODE => p_Region_Item_Rec.Nested_Region_Code,
X_NESTED_REGION_APPL_ID => p_Region_Item_Rec.Nested_Region_Application_Id,
X_MENU_NAME => NULL,
X_FLEXFIELD_NAME => NULL,
X_FLEXFIELD_APPLICATION_ID => NULL,
X_TABULAR_FUNCTION_CODE => NULL,
X_TIP_TYPE => NULL,
X_TIP_MESSAGE_NAME => NULL,
X_TIP_MESSAGE_APPLICATION_ID => NULL,
X_FLEX_SEGMENT_LIST => NULL,
X_ENTITY_ID => NULL,
X_ANCHOR => NULL,
X_POPLIST_VIEW_USAGE_NAME => NULL,
X_USER_CUSTOMIZABLE => NULL,
X_ADMIN_CUSTOMIZABLE => c_ADMIN_CUSTOMIZABLE,
X_INVOKE_FUNCTION_NAME => NULL,
X_ATTRIBUTE_LABEL_SHORT => NULL,
X_EXPANSION => NULL,
X_ALS_MAX_LENGTH => NULL,
X_SORTBY_VIEW_ATTRIBUTE_NAME => NULL,
X_ICX_CUSTOM_CALL => NULL,
X_INITIAL_SORT_SEQUENCE => p_Region_Item_Rec.Initial_Sort_Sequence,
X_CUSTOMIZATION_APPLICATION_ID => NULL,
X_CUSTOMIZATION_CODE => NULL,
X_CREATION_DATE => SYSDATE,
X_CREATED_BY => fnd_global.user_id,
X_LAST_UPDATE_DATE => SYSDATE,
X_LAST_UPDATED_BY => fnd_global.user_id,
X_LAST_UPDATE_LOGIN => fnd_global.user_id,
X_ATTRIBUTE_CATEGORY => C_ATTRIBUTE_CATEGORY,
X_ATTRIBUTE1 => p_Region_Item_Rec.Attribute_Type,
X_ATTRIBUTE2 => p_Region_Item_Rec.Measure_Level,
X_ATTRIBUTE3 => p_Region_Item_Rec.Base_Column,
X_ATTRIBUTE4 => p_Region_Item_Rec.Lov_Where_Clause,
X_ATTRIBUTE5 => p_Region_Item_Rec.Graph_Position,
X_ATTRIBUTE6 => p_Region_Item_Rec.Graph_Style,
X_ATTRIBUTE7 => p_Region_Item_Rec.Display_Format,
X_ATTRIBUTE8 => p_Region_Item_Rec.Schedule,
X_ATTRIBUTE9 => p_Region_Item_Rec.Aggregate_Function,
X_ATTRIBUTE10 => p_Region_Item_Rec.Display_Total,
X_ATTRIBUTE11 => p_Region_Item_Rec.Override_Hierarchy,
X_ATTRIBUTE12 => NULL,
X_ATTRIBUTE13 => p_Region_Item_Rec.Variance,
X_ATTRIBUTE14 => p_Region_Item_Rec.Display_Type,
X_ATTRIBUTE15 => p_Region_Item_Rec.Lov_Table);
x_msg_data := 'BIS_AK_REGION_PUB.INSERT_REGION_ITEM_ROW: ' || SQLERRM;
END INSERT_REGION_ITEM_ROW;
PROCEDURE UPDATE_REGION_ITEM_ROW
( p_commit IN VARCHAR2 := FND_API.G_TRUE
, p_region_code IN VARCHAR2
, p_region_application_id IN NUMBER
, p_Region_Item_Rec IN BIS_AK_REGION_PUB.Bis_Region_Item_Rec_Type
, x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
) IS
l_regionItem_rec AK_REGION_PUB.Item_Rec_Type;
SELECT display_sequence,
bold,
italic,
vertical_alignment,
horizontal_alignment,
item_style,
object_attribute_flag,
icx_custom_call,
update_flag,
required_flag,
security_code,
default_value_varchar2,
default_value_number,
default_value_date,
lov_region_application_id,
lov_region_code,
lov_foreign_key_name,
lov_attribute_application_id,
lov_attribute_code,
lov_default_flag,
region_defaulting_api_pkg,
region_defaulting_api_proc,
region_validation_api_pkg,
region_validation_api_proc,
order_sequence,
order_direction,
display_height,
submit,
encrypt,
css_class_name,
view_usage_name,
view_attribute_name,
nested_region_application_id,
nested_region_code,
url,
poplist_viewobject,
poplist_display_attribute,
poplist_value_attribute,
image_file_name,
item_name,
css_label_class_name,
menu_name,
flexfield_name,
flexfield_application_id,
tabular_function_code,
tip_type,
tip_message_name,
tip_message_application_id,
flex_segment_list,
entity_id,
anchor,
poplist_view_usage_name,
user_customizable,
sortby_view_attribute_name,
admin_customizable,
invoke_function_name,
expansion,
als_max_length,
initial_sort_sequence,
customization_application_id,
customization_code,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute12,
attribute13,
attribute14,
attribute15,
attribute_label_short,
description
FROM ak_region_items_vl
WHERE region_code = p_region_code
AND region_application_id = p_region_application_id
AND attribute_code = p_Region_Item_Rec.Attribute_Code
AND attribute_application_id = p_Region_Item_Rec.Attribute_Application_Id;
l_regionItem_rec.update_flag := c_region_item_rec.update_flag;
AK_REGION_ITEMS_PKG.UPDATE_ROW (
X_REGION_APPLICATION_ID => p_region_application_id,
X_REGION_CODE => p_region_code,
X_ATTRIBUTE_APPLICATION_ID => p_Region_Item_Rec.Attribute_Application_Id,
X_ATTRIBUTE_CODE => p_Region_Item_Rec.Attribute_Code,
X_DISPLAY_SEQUENCE => p_Region_Item_Rec.Display_Sequence,
X_NODE_DISPLAY_FLAG => p_Region_Item_Rec.Node_Display_Flag,
X_NODE_QUERY_FLAG => p_Region_Item_Rec.Queryable_Flag,
X_ATTRIBUTE_LABEL_LENGTH => l_label_length,
X_BOLD => l_regionItem_rec.bold,
X_ITALIC => l_regionItem_rec.italic,
X_VERTICAL_ALIGNMENT => l_regionItem_rec.VERTICAL_ALIGNMENT,
X_HORIZONTAL_ALIGNMENT => l_regionItem_rec.HORIZONTAL_ALIGNMENT,
X_ITEM_STYLE => l_regionItem_rec.ITEM_STYLE,
X_OBJECT_ATTRIBUTE_FLAG => l_regionItem_rec.OBJECT_ATTRIBUTE_FLAG,
X_ATTRIBUTE_LABEL_LONG => p_Region_Item_Rec.Long_Label,
X_DESCRIPTION => l_regionItem_rec.description,
X_SECURITY_CODE => l_regionItem_rec.security_code,
X_UPDATE_FLAG => l_regionItem_rec.UPDATE_FLAG,
X_REQUIRED_FLAG => p_Region_Item_Rec.Required_Flag,
X_DISPLAY_VALUE_LENGTH => p_Region_Item_Rec.Display_Length,
X_LOV_REGION_APPLICATION_ID => l_regionItem_rec.lov_region_application_id,
X_LOV_REGION_CODE => l_regionItem_rec.lov_region_code,
X_LOV_FOREIGN_KEY_NAME => l_regionItem_rec.lov_foreign_key_name,
X_LOV_ATTRIBUTE_APPLICATION_ID => l_regionItem_rec.lov_attribute_application_id,
X_LOV_ATTRIBUTE_CODE => l_regionItem_rec.lov_attribute_code,
X_LOV_DEFAULT_FLAG => l_regionItem_rec.lov_default_flag,
X_REGION_DEFAULTING_API_PKG => l_regionItem_rec.region_defaulting_api_pkg,
X_REGION_DEFAULTING_API_PROC => l_regionItem_rec.region_defaulting_api_proc,
X_REGION_VALIDATION_API_PKG => l_regionItem_rec.region_validation_api_pkg,
X_REGION_VALIDATION_API_PROC => l_regionItem_rec.region_validation_api_proc,
X_ORDER_SEQUENCE => p_Region_Item_Rec.Sort_Sequence,
X_ORDER_DIRECTION => p_Region_Item_Rec.Sort_Direction,
X_DEFAULT_VALUE_VARCHAR2 => l_regionItem_rec.default_value_varchar2,
X_DEFAULT_VALUE_NUMBER => l_regionItem_rec.default_value_number,
X_DEFAULT_VALUE_DATE => l_regionItem_rec.default_value_date,
X_ITEM_NAME => l_regionItem_rec.item_name,
X_DISPLAY_HEIGHT => l_regionItem_rec.display_height,
X_SUBMIT => l_regionItem_rec.submit,
X_ENCRYPT => l_regionItem_rec.encrypt,
X_VIEW_USAGE_NAME => l_regionItem_rec.view_usage_name,
X_VIEW_ATTRIBUTE_NAME => l_regionItem_rec.view_attribute_name,
X_CSS_CLASS_NAME => l_regionItem_rec.css_class_name,
X_CSS_LABEL_CLASS_NAME => l_regionItem_rec.css_label_class_name,
X_URL => p_Region_Item_Rec.Url,
X_POPLIST_VIEWOBJECT => l_regionItem_rec.poplist_viewobject,
X_POPLIST_DISPLAY_ATTRIBUTE => l_regionItem_rec.poplist_display_attr,
X_POPLIST_VALUE_ATTRIBUTE => l_regionItem_rec.poplist_value_attr,
X_IMAGE_FILE_NAME => l_regionItem_rec.image_file_name,
X_NESTED_REGION_CODE => l_regionItem_rec.nested_region_code,
X_NESTED_REGION_APPL_ID => l_regionItem_rec.nested_region_application_id,
X_MENU_NAME =>l_regionItem_rec.menu_name,
X_FLEXFIELD_NAME => l_regionItem_rec.flexfield_name,
X_FLEXFIELD_APPLICATION_ID => l_regionItem_rec.flexfield_application_id,
X_TABULAR_FUNCTION_CODE => l_regionItem_rec.tabular_function_code,
X_TIP_TYPE => l_regionItem_rec.tip_type,
X_TIP_MESSAGE_NAME => l_regionItem_rec.tip_message_name,
X_TIP_MESSAGE_APPLICATION_ID => l_regionItem_rec.tip_message_application_id,
X_FLEX_SEGMENT_LIST => l_regionItem_rec.flex_segment_list,
X_ENTITY_ID => l_regionItem_rec.entity_id,
X_ANCHOR => l_regionItem_rec.anchor,
X_POPLIST_VIEW_USAGE_NAME => l_regionItem_rec.poplist_view_usage_name,
X_USER_CUSTOMIZABLE => l_regionItem_rec.user_customizable,
X_ADMIN_CUSTOMIZABLE => l_regionItem_rec.admin_customizable,
X_INVOKE_FUNCTION_NAME => l_regionItem_rec.invoke_function_name,
X_EXPANSION =>l_regionItem_rec.expansion,
X_ALS_MAX_LENGTH => l_regionItem_rec.als_max_length,
X_SORTBY_VIEW_ATTRIBUTE_NAME =>l_regionItem_rec.sortby_view_attribute_name,
X_ICX_CUSTOM_CALL => l_regionItem_rec.icx_custom_call,
X_INITIAL_SORT_SEQUENCE => p_Region_Item_Rec.Initial_Sort_Sequence,
X_CUSTOMIZATION_APPLICATION_ID => l_regionItem_rec.customization_application_id,
X_CUSTOMIZATION_CODE => l_regionItem_rec.customization_code,
X_LAST_UPDATE_DATE => SYSDATE,
X_LAST_UPDATED_BY => fnd_global.user_id,
X_LAST_UPDATE_LOGIN => fnd_global.user_id,
X_ATTRIBUTE_CATEGORY => C_ATTRIBUTE_CATEGORY,
X_ATTRIBUTE1 => p_Region_Item_Rec.Attribute_Type,
X_ATTRIBUTE2 => p_Region_Item_Rec.Measure_Level,
X_ATTRIBUTE3 => p_Region_Item_Rec.Base_Column,
X_ATTRIBUTE4 => p_Region_Item_Rec.Lov_Where_Clause,
X_ATTRIBUTE5 => p_Region_Item_Rec.Graph_Position,
X_ATTRIBUTE6 => p_Region_Item_Rec.Graph_Style,
X_ATTRIBUTE7 => p_Region_Item_Rec.Display_Format,
X_ATTRIBUTE8 => p_Region_Item_Rec.Schedule,
X_ATTRIBUTE9 => p_Region_Item_Rec.Aggregate_Function,
X_ATTRIBUTE10 => p_Region_Item_Rec.Display_Total,
X_ATTRIBUTE11 => p_Region_Item_Rec.Override_Hierarchy,
X_ATTRIBUTE12 => NULL,
X_ATTRIBUTE13 => p_Region_Item_Rec.Variance,
X_ATTRIBUTE14 => p_Region_Item_Rec.Display_Type,
X_ATTRIBUTE15 => p_Region_Item_Rec.Lov_Table);
x_msg_data := 'BIS_AK_REGION_PUB.UPDATE_REGION_ITEM_ROW: ' || SQLERRM;
END UPDATE_REGION_ITEM_ROW;
PROCEDURE DELETE_REGION_ITEM_ROW
(p_REGION_CODE in VARCHAR2
,p_REGION_APPLICATION_ID in NUMBER
,p_ATTRIBUTE_CODE in VARCHAR2
,p_ATTRIBUTE_APPLICATION_ID in NUMBER
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
,p_commit IN VARCHAR2 := FND_API.G_FALSE
) IS
BEGIN
x_Return_Status := FND_API.G_RET_STS_SUCCESS;
AK_REGION_ITEMS_PKG.DELETE_ROW(
X_REGION_APPLICATION_ID => p_REGION_APPLICATION_ID,
X_REGION_CODE => p_REGION_CODE,
X_ATTRIBUTE_APPLICATION_ID => p_ATTRIBUTE_APPLICATION_ID,
X_ATTRIBUTE_CODE => p_ATTRIBUTE_CODE
);
x_msg_data := 'BIS_AK_REGION_PUB.DELETE_REGION_ITEM_ROW: ' || SQLERRM;
END DELETE_REGION_ITEM_ROW;
PROCEDURE DELETE_REGION_AND_REGION_ITEMS(
p_REGION_CODE IN VARCHAR2
,p_REGION_APPLICATION_ID IN NUMBER
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
) is
begin
delete_region_items(
p_REGION_CODE => p_REGION_CODE,
p_REGION_APPLICATION_ID => p_REGION_APPLICATION_ID,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data =>x_msg_data);
BIS_AK_REGION_PUB.DELETE_REGION_ROW(
p_REGION_CODE => p_REGION_CODE ,
p_REGION_APPLICATION_ID => p_REGION_APPLICATION_ID,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data =>x_msg_data);
delete_ext_region_items(
p_REGION_CODE => p_REGION_CODE,
p_REGION_APPLICATION_ID => p_REGION_APPLICATION_ID,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data =>x_msg_data);
BIS_REGION_EXTENSION_PVT.DELETE_REGION_EXTN_RECORD(
p_commit => FND_API.G_FALSE,
pRegionCode => p_REGION_CODE,
pRegionAppId => p_REGION_APPLICATION_ID);
BIS_CUSTOMIZATIONS_PVT.delete_region_customizations
( p_region_code => p_region_code
, p_region_application_id => p_region_application_id
, x_return_status => x_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
);
x_msg_data := 'BIS_AK_REGION_PUB.DELETE_REGION_AND_REGION_ITEMS: ' || SQLERRM;
END DELETE_REGION_AND_REGION_ITEMS;
PROCEDURE DELETE_REGION_ITEMS (
p_REGION_CODE IN VARCHAR2
,p_REGION_APPLICATION_ID IN NUMBER
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
) is
cursor items_cursor IS
select attribute_code, attribute_application_id
from ak_region_items
where region_code = p_REGION_CODE
and region_application_id = p_REGION_APPLICATION_ID;
BIS_AK_REGION_PUB.DELETE_REGION_ITEM_ROW(
p_REGION_CODE => p_REGION_CODE,
p_REGION_APPLICATION_ID => p_REGION_APPLICATION_ID,
p_ATTRIBUTE_CODE => cr.attribute_code,
p_ATTRIBUTE_APPLICATION_ID => cr.attribute_application_id,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data =>x_msg_data);
x_msg_data := 'BIS_AK_REGION_PUB.DELETE_REGION_ITEMS: ' || SQLERRM;
END DELETE_REGION_ITEMS;
PROCEDURE DELETE_EXT_REGION_ITEMS (
p_REGION_CODE IN VARCHAR2
,p_REGION_APPLICATION_ID IN NUMBER
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
) is
cursor items_cursor IS
select attribute_code, attribute_application_id
from bis_ak_region_item_extension
where region_code = p_REGION_CODE
and region_application_id = p_REGION_APPLICATION_ID;
BIS_REGION_ITEM_EXTENSION_PVT.DELETE_REGION_ITEM_RECORD(
p_commit => FND_API.G_FALSE,
pRegionCode => p_REGION_CODE,
pRegionAppId => p_REGION_APPLICATION_ID,
pAttributeCode => cr.attribute_code,
pAttributeAppId => cr.attribute_application_id);
x_msg_data := 'BIS_AK_REGION_PUB.DELETE_EXT_ITEMS: ' || SQLERRM;
END DELETE_EXT_REGION_ITEMS;
select count(1) into l_count from user_objects
where object_type in ('VIEW', 'MATERIALIZED VIEW','SYNONYM')
and object_name = p_database_object_name;
SELECT count(1) into l_count
FROM ak_objects
WHERE database_object_name = P_DATABASE_OBJECT_NAME;
procedure INSERT_AK_OBJECT (
P_DATABASE_OBJECT_NAME IN VARCHAR2
,P_APPLICATION_ID IN NUMBER) IS
l_object_rowid varchar2(50);
AK_OBJECTS_PKG.INSERT_ROW(
X_ROWID => l_object_rowid,
X_DATABASE_OBJECT_NAME => upper(P_DATABASE_OBJECT_NAME),
X_APPLICATION_ID => P_APPLICATION_ID,
X_NAME => SUBSTR(P_DATABASE_OBJECT_NAME, 1, 23), -- bug#4289493
X_DESCRIPTION => null,
X_PRIMARY_KEY_NAME => null,
X_DEFAULTING_API_PKG => null,
X_DEFAULTING_API_PROC => null,
X_VALIDATION_API_PKG => null,
X_VALIDATION_API_PROC => null,
X_CREATION_DATE => sysdate,
X_CREATED_BY => fnd_global.user_id,
X_LAST_UPDATE_DATE => sysdate,
X_LAST_UPDATED_BY => fnd_global.user_id,
X_LAST_UPDATE_LOGIN => fnd_global.user_id,
X_ATTRIBUTE_CATEGORY => null,
X_ATTRIBUTE1 => null,
X_ATTRIBUTE2 => null,
X_ATTRIBUTE3 => null,
X_ATTRIBUTE4 => null,
X_ATTRIBUTE5 => null,
X_ATTRIBUTE6 => null,
X_ATTRIBUTE7 => null,
X_ATTRIBUTE8 => null,
X_ATTRIBUTE9 => null,
X_ATTRIBUTE10 => null,
X_ATTRIBUTE11 => null,
X_ATTRIBUTE12 => null,
X_ATTRIBUTE13 => null,
X_ATTRIBUTE14 => null,
X_ATTRIBUTE15 => null);
end INSERT_AK_OBJECT;
SELECT display_sequence,
node_display_flag,
required_flag,
node_query_flag,
display_value_length,
attribute_label_long,
order_sequence,
initial_sort_sequence,
order_direction,
url,
attribute1,
attribute7,
attribute14,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute15,
attribute9,
attribute10,
attribute13,
attribute8,
attribute11
FROM ak_region_items_vl
WHERE region_code = p_region_code
AND region_application_id = p_region_application_id
AND attribute_code = p_Attribute_Code
AND attribute_application_id = p_Attribute_Application_Id;
PROCEDURE UPDATE_REGION_ITEM_ATTR
( p_commit IN VARCHAR2 := FND_API.G_TRUE
, p_region_code IN VARCHAR2
, p_region_application_id IN NUMBER
, p_Attribute_Code IN AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE
, p_Attribute_Application_Id IN AK_REGION_ITEMS.ATTRIBUTE_APPLICATION_ID%TYPE
, p_Short_Name IN VARCHAR2
, x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
) IS
l_Region_Item_Rec BIS_AK_REGION_PUB.Bis_Region_Item_Rec_Type;
BIS_AK_REGION_PUB.UPDATE_REGION_ITEM_ATTR
( p_commit => p_commit
, p_region_code => p_region_code
, p_region_application_id => p_region_application_id
, p_Attribute_Code => p_Attribute_Code
, p_Attribute_Application_Id => p_Attribute_Application_Id
, p_Short_Name => p_Short_Name
, p_type => NULL
, p_Meas_Name => NULL
, x_return_status => x_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
);
x_msg_data := 'BIS_AK_REGION_PUB.UPDATE_REGION_ITEM_ATTR: ' || SQLERRM;
END UPDATE_REGION_ITEM_ATTR;
PROCEDURE UPDATE_REGION_ITEM_ATTR
( p_commit IN VARCHAR2 := FND_API.G_TRUE
, p_region_code IN VARCHAR2
, p_region_application_id IN NUMBER
, p_Attribute_Code IN AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE
, p_Attribute_Application_Id IN AK_REGION_ITEMS.ATTRIBUTE_APPLICATION_ID%TYPE
, p_Short_Name IN VARCHAR2
, p_type IN VARCHAR2
, p_Meas_Name IN VARCHAR2
, x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
) IS
l_Region_Item_Rec BIS_AK_REGION_PUB.Bis_Region_Item_Rec_Type;
BIS_AK_REGION_PUB.UPDATE_REGION_ITEM_ROW
( p_commit => p_commit
, p_region_code => p_region_code
, p_region_application_id => p_region_application_id
, p_Region_Item_Rec => l_Region_Item_Rec
, x_return_status => x_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
);
x_msg_data := 'BIS_AK_REGION_PUB.UPDATE_REGION_ITEM_ATTR: ' || SQLERRM;
END UPDATE_REGION_ITEM_ATTR;
, p_last_update_date IN VARCHAR2
, x_record_status OUT NOCOPY VARCHAR2
) IS
l_last_update_date date;
cursor cRegion is select last_update_date
from ak_regions
where region_code = p_region_code
and region_application_id = p_region_application_id
for update of region_application_id nowait;
FETCH cRegion INTO l_last_update_date;
x_record_status := BIS_AK_REGION_PUB.c_RECORD_DELETED;
if p_last_update_date is not null then
if p_last_update_date <> TO_CHAR(l_last_update_date, BIS_AK_REGION_PUB.C_LAST_UPDATE_DATE_FORMAT) then
x_record_status := BIS_AK_REGION_PUB.c_RECORD_CHANGED;
SELECT a.attribute2
FROM ak_region_items a
WHERE a.region_code = p_region_code
AND a.region_application_id = p_region_app_id
AND a.attribute1 IN ('MEASURE', 'MEASURE_NOTARGET')
AND a.attribute_code = p_attr_code
AND a.attribute2 = p_measure_short_name;
SELECT sc.attribute2
FROM ak_region_items sc, ak_region_items cc
WHERE sc.region_code = p_region_code
AND sc.region_code = cc.region_code
AND sc.region_application_id = p_region_app_id
AND (sc.attribute1 IN ('MEASURE','MEASURE_NOTARGET') AND sc.attribute_code = p_source_code)
AND (cc.attribute1 = 'COMPARE_TO_MEASURE_NO_TARGET' AND cc.attribute_code = p_compare_code)
AND sc.attribute_code = cc.attribute2
AND sc.attribute2 = p_measure_short_name;
SELECT attribute10 INTO l_attribute10
FROM ak_regions
WHERE region_code = p_region_code
AND region_application_id = p_region_app_id;
SELECT attribute1 INTO l_attribute1
FROM ak_regions
WHERE region_code = p_region_code
AND region_application_id = p_region_app_id;
SELECT COUNT(0) INTO l_count
FROM ak_region_items
WHERE region_code = p_region_code
AND region_application_id = p_region_app_id
AND attribute9 IS NOT NULL;
, x_Region_Last_Updated_By OUT NOCOPY Ak_Regions_Tl.LAST_UPDATED_BY%TYPE
, x_Region_Last_Update_Date OUT NOCOPY Ak_Regions_Tl.LAST_UPDATE_DATE%TYPE
, x_Region_Last_Update_Login OUT NOCOPY Ak_Regions_Tl.LAST_UPDATE_LOGIN%TYPE
, x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
) IS
CURSOR c_AkRegionsTl IS
SELECT
A.REGION_CODE
, A.REGION_APPLICATION_ID
, A.NAME
, A.DESCRIPTION
, A.CREATED_BY
, A.CREATION_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_DATE
, A.LAST_UPDATE_LOGIN
FROM AK_REGIONS_VL A
WHERE A.REGION_CODE = p_Region_Code
AND A.REGION_APPLICATION_ID = p_Region_Application_Id;
x_Region_Last_Updated_By := c_AkRTl.LAST_UPDATED_BY;
x_Region_Last_Update_Date := c_AkRTl.LAST_UPDATE_DATE;
x_Region_Last_Update_Login := c_AkRTl.LAST_UPDATE_LOGIN;
SELECT attribute_code, attribute_application_id
FROM ak_region_items
WHERE region_code = p_region_code
AND region_application_id = p_region_application_id;
UPDATE ak_region_items
SET display_sequence = l_counter
WHERE attribute_code = cr.attribute_code
AND attribute_application_id = cr.attribute_application_id
AND region_code = p_region_code
AND region_application_id = p_region_application_id;