eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AK_REGION_PVT SQL Statements

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

Line: 52


select  region_style
from    AK_REGIONS
where   region_application_id = p_region_application_id
and     region_code = p_region_code;

Line: 142


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

Line: 153


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

Line: 247


p_update_flag              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_required_flag            IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_security_code            IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_default_value_varchar2   IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_default_value_number     IN      NUMBER := FND_API.G_MISS_NUM,
p_default_value_date       IN      DATE := FND_API.G_MISS_DATE,
p_nested_region_appl_id IN     NUMBER := FND_API.G_MISS_NUM,
p_nested_region_code       IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_lov_region_application_id IN     NUMBER := FND_API.G_MISS_NUM,
p_lov_region_code          IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_lov_foreign_key_name     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_lov_attribute_application_id IN  NUMBER := FND_API.G_MISS_NUM,
p_lov_attribute_code       IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_lov_default_flag         IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_region_defaulting_api_pkg IN     VARCHAR2 := FND_API.G_MISS_CHAR,
p_region_defaulting_api_proc IN    VARCHAR2 := FND_API.G_MISS_CHAR,
p_region_validation_api_pkg IN     VARCHAR2 := FND_API.G_MISS_CHAR,
p_region_validation_api_proc IN    VARCHAR2 := FND_API.G_MISS_CHAR,
p_order_sequence           IN      NUMBER := FND_API.G_MISS_NUM,
p_order_direction          IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_menu_name		     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_flexfield_name	     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_flexfield_application_id IN      NUMBER   := FND_API.G_MISS_NUM,
p_tabular_function_code    IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_tip_type                 IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_tip_message_name         IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_tip_message_application_id   IN      NUMBER   := FND_API.G_MISS_NUM,
p_flex_segment_list        IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_entity_id                IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_anchor                   IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_poplist_view_usage_name  IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_user_customizable	     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_sortby_view_attribute_name   IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_invoke_function_name     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_expansion		     IN      NUMBER := FND_API.G_MISS_NUM,
p_als_max_length	     IN      NUMBER := FND_API.G_MISS_NUM,
p_initial_sort_sequence    IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_customization_application_id IN  NUMBER := FND_API.G_MISS_NUM,
p_customization_code	     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute_label_long     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute_label_short    IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_caller                   IN      VARCHAR2,
p_pass                     IN      NUMBER := 2
) return BOOLEAN is
cursor l_check_region_csr is
select  database_object_name
from    AK_REGIONS
where   region_application_id = p_region_application_id
and     region_code = p_region_code;

Line: 297


select  1
from    AK_REGION_ITEMS
where   region_application_id = p_region_application_id
and     region_code = p_region_code
and     display_sequence = p_display_sequence
and     ( (attribute_application_id <> p_attribute_application_id)
or        (attribute_code <> p_attribute_code) );

Line: 305


select 1
from FND_MENUS_VL
where menu_name = param_menu_name;

Line: 310


select 1
from  FND_DESCRIPTIVE_FLEXS FLEX
where FLEX.DESCRIPTIVE_FLEXFIELD_NAME not like '$SRS$.%'
and   FLEX.DESCRIPTIVE_FLEXFIELD_NAME = param_flexfield_name
and   FLEX.APPLICATION_ID = param_flexfield_application_id
union
select 1
from  FND_ID_FLEXS FLEX
where FLEX.ID_FLEX_CODE = param_flexfield_name
and   FLEX.APPLICATION_ID = param_flexfield_application_id;

Line: 323


select 1
from  FND_NEW_MESSAGES MSG
where MSG.MESSAGE_NAME = param_message_name
and   MSG.APPLICATION_ID = param_message_application_id;

Line: 329


select 1
from FND_DOCUMENT_ENTITIES
where data_object_code = param_entity_id;

Line: 456


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

Line: 467


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

Line: 478


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

Line: 489


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

Line: 500


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

Line: 511


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

Line: 522


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

Line: 533


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

Line: 544


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

Line: 555


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

Line: 566


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

Line: 575


if ((p_update_flag is null) or
(p_update_flag = FND_API.G_MISS_CHAR and
p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
l_error := TRUE;

Line: 581


FND_MESSAGE.SET_TOKEN('COLUMN', 'UPDATE_FLAG');

Line: 588


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

Line: 723


if (p_update_flag <> FND_API.G_MISS_CHAR) then
if (NOT AK_ON_OBJECTS_PVT.VALID_YES_NO(p_update_flag)) then
l_error := TRUE;

Line: 728


FND_MESSAGE.SET_TOKEN('COLUMN','UPDATE_FLAG');

Line: 1044


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

Line: 1055


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

Line: 1066


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

Line: 1167


select *
from AK_REGION_GRAPH_COLUMNS
where REGION_APPLICATION_ID = p_region_application_id
and   REGION_CODE = p_region_code
and   GRAPH_NUMBER = p_graph_number;

Line: 1228


l_databuffer_tbl(l_index) := '      LAST_UPDATED_BY = "' ||
nvl(to_char(l_graph_columns_rec.last_updated_by),'') || '"';

Line: 1231


l_databuffer_tbl(l_index) := '      LAST_UPDATE_DATE = "' ||
to_char(l_graph_columns_rec.last_update_date,
AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

Line: 1235


l_databuffer_tbl(l_index) := '      LAST_UPDATE_LOGIN = "' ||
nvl(to_char(l_graph_columns_rec.last_update_login),'') || '"';

Line: 1327


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;

Line: 1412


FND_LOAD_UTIL.OWNER_NAME(l_category_usage_rec.last_updated_by) || '"';

Line: 1414


l_databuffer_tbl(l_index) := '      LAST_UPDATE_DATE = "' ||
to_char(l_category_usage_rec.last_update_date,
AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

Line: 1418


l_databuffer_tbl(l_index) := '      LAST_UPDATE_LOGIN = "' ||
nvl(to_char(l_category_usage_rec.last_update_login),'') || '"';

Line: 1507


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;

Line: 1600


FND_LOAD_UTIL.OWNER_NAME(l_lov_relation_rec.last_updated_by) || '"';

Line: 1602


l_databuffer_tbl(l_index) := '      LAST_UPDATE_DATE = "' ||
to_char(l_lov_relation_rec.last_update_date,
AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

Line: 1606


l_databuffer_tbl(l_index) := '      LAST_UPDATE_LOGIN = "' ||
nvl(to_char(l_lov_relation_rec.last_update_login),'') || '"';

Line: 1695


select *
from   AK_REGION_GRAPHS
where  REGION_APPLICATION_ID = p_region_application_id
and    REGION_CODE = p_region_code;

Line: 1700


select *
from   AK_REGION_GRAPHS_TL
where  REGION_APPLICATION_ID = p_region_application_id
and    REGION_CODE = p_region_code
and    GRAPH_NUMBER = graph_number
and    LANGUAGE = p_nls_language;

Line: 1709


select 1
from ak_region_graph_columns
where region_application_id = region_appl_id_param
and region_code = region_code_param
and graph_number = graph_number_param;

Line: 1791


l_databuffer_tbl(l_index) := '    LAST_UPDATED_BY = "' ||
nvl(to_char(l_graphs_rec.last_updated_by),'') || '"';

Line: 1794


l_databuffer_tbl(l_index) := '    LAST_UPDATE_DATE = "' ||
to_char(l_graphs_rec.last_update_date,
AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

Line: 1798


l_databuffer_tbl(l_index) := '    LAST_UPDATE_LOGIN = "' ||
nvl(to_char(l_graphs_rec.last_update_login),'') || '"';

Line: 1830


l_databuffer_tbl.delete;

Line: 1945


select *
from   AK_REGION_ITEMS
where  REGION_APPLICATION_ID = p_region_application_id
and    REGION_CODE = p_region_code;

Line: 1951


select *
from   AK_REGION_ITEMS_TL
where  REGION_APPLICATION_ID = p_region_application_id
and    REGION_CODE = p_region_code
and    ATTRIBUTE_APPLICATION_ID = attribute_appl_id_param
and    ATTRIBUTE_CODE = attribute_code_param
and    LANGUAGE = p_nls_language;

Line: 1964


select 1
from ak_region_lov_relations
where region_application_id = region_appl_id_param
and region_code = region_code_param
and attribute_application_id = attribute_appl_id_param
and attribute_code = attribute_code_param
and lov_region_appl_id = lov_region_appl_id_param
and lov_region_code = lov_region_code_param;

Line: 1976


select 1
from ak_category_usages acu, ak_region_items ari
where acu.region_code = region_code_param
and acu.region_application_id = region_appl_id_param
and acu.attribute_code = attribute_code_param
and acu.attribute_application_id = attribute_appl_id_param
and ari.region_code = acu.region_code
and ari.region_application_id = acu.region_application_id
and ari.attribute_code = acu.attribute_code
and ari.attribute_application_id = acu.attribute_application_id
and ( ari.item_style = 'ATTACHMENT_IMAGE'
or ari.item_style = 'ATTACHMENT_LINK');

Line: 2033


p_update_flag => l_items_rec.update_flag,
p_required_flag => l_items_rec.required_flag,
p_security_code => l_items_rec.security_code,
p_default_value_varchar2 => l_items_rec.default_value_varchar2,
p_default_value_number => l_items_rec.default_value_number,
p_default_value_date => l_items_rec.default_value_date,
p_nested_region_appl_id => l_items_rec.nested_region_application_id,
p_nested_region_code => l_items_rec.nested_region_code,
p_lov_region_application_id =>
l_items_rec.lov_region_application_id,
p_lov_region_code => l_items_rec.lov_region_code,
p_lov_foreign_key_name => l_items_rec.lov_foreign_key_name,
p_lov_attribute_application_id =>
l_items_rec.lov_attribute_application_id,
p_lov_attribute_code => l_items_rec.lov_attribute_code,
p_lov_default_flag => l_items_rec.lov_default_flag,
p_region_defaulting_api_pkg =>
l_items_rec.region_defaulting_api_pkg,
p_region_defaulting_api_proc =>
l_items_rec.region_defaulting_api_proc,
p_region_validation_api_pkg =>
l_items_rec.region_validation_api_pkg,
p_region_validation_api_proc =>
l_items_rec.region_validation_api_proc,
p_order_sequence => l_items_rec.order_sequence,
p_order_direction => l_items_rec.order_direction,
p_menu_name => l_items_rec.menu_name,
p_flexfield_name => l_items_rec.flexfield_name,
p_flexfield_application_id => l_items_rec.flexfield_application_id,
p_tabular_function_code    => l_items_rec.tabular_function_code,
p_tip_type                 => l_items_rec.tip_type,
p_tip_message_name         => l_items_rec.tip_message_name,
p_tip_message_application_id  => l_items_rec.tip_message_application_id ,
p_flex_segment_list        => l_items_rec.flex_segment_list,
p_entity_id  => l_items_rec.entity_id ,
p_anchor     => l_items_rec.anchor,
p_poplist_view_usage_name => l_items_rec.poplist_view_usage_name,
p_user_customizable => l_items_rec.user_customizable,
p_sortby_view_attribute_name => l_items_rec.sortby_view_attribute_name,
p_invoke_function_name => l_items_rec.invoke_function_name,
p_expansion => l_items_rec.expansion,
p_als_max_length => l_items_rec.als_max_length,
p_initial_sort_sequence => l_items_rec.initial_sort_sequence,
p_customization_application_id => l_items_rec.customization_application_id,
p_customization_code => l_items_rec.customization_code,
p_attribute_label_long => l_items_tl_rec.attribute_label_long,
p_attribute_label_short => l_items_tl_rec.attribute_label_short,
p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD) then
if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_NOT_DOWNLOADED');

Line: 2148


l_databuffer_tbl(l_index) := '    UPDATE_FLAG = "' ||
AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
l_items_rec.update_flag) || '"';

Line: 2659


FND_LOAD_UTIL.OWNER_NAME(l_items_rec.last_updated_by) || '"';

Line: 2661


l_databuffer_tbl(l_index) := '    LAST_UPDATE_DATE = "' ||
to_char(l_items_rec.last_update_date,
AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

Line: 2665


l_databuffer_tbl(l_index) := '    LAST_UPDATE_LOGIN = "' ||
nvl(to_char(l_items_rec.last_update_login),'') || '"';

Line: 2705


l_databuffer_tbl.delete;

Line: 2841


select *
from  AK_REGIONS
where REGION_APPLICATION_ID = p_region_application_id
and   REGION_CODE = p_region_code;

Line: 2846


select *
from  AK_REGIONS_TL
where REGION_APPLICATION_ID = p_region_application_id
and   REGION_CODE = p_region_code
and   LANGUAGE = p_nls_language;

Line: 3256


FND_LOAD_UTIL.OWNER_NAME(l_regions_rec.last_updated_by) || '"';

Line: 3258


l_databuffer_tbl(l_index) := '  LAST_UPDATE_DATE = "' ||
to_char(l_regions_rec.last_update_date,
AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

Line: 3262


l_databuffer_tbl(l_index) := '  LAST_UPDATE_LOGIN = "' ||
nvl(to_char(l_regions_rec.last_update_login),'') || '"';

Line: 3292


l_databuffer_tbl.delete;

Line: 3410


p_last_updated_by          IN     NUMBER := FND_API.G_MISS_NUM,
p_last_update_date         IN      DATE := FND_API.G_MISS_DATE,
p_last_update_login        IN     NUMBER := FND_API.G_MISS_NUM,
p_loader_timestamp         IN      DATE := FND_API.G_MISS_DATE,
p_pass                     IN      NUMBER,
p_copy_redo_flag           IN OUT NOCOPY  BOOLEAN
) is
l_api_version_number      CONSTANT number := 1.0;

Line: 3421


l_last_update_date		DATE;

Line: 3422


l_last_update_login		NUMBER;

Line: 3423


l_last_updated_by		NUMBER;

Line: 3505


AK_UPLOAD_GRP.G_UPLOAD_DATE := p_last_update_date;

Line: 3511


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

Line: 3517


        l_last_updated_by := p_last_updated_by;

Line: 3518


        l_last_update_login := p_last_update_login;

Line: 3521


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

Line: 3524


insert into AK_REGION_GRAPHS (
REGION_APPLICATION_ID,
REGION_CODE,
GRAPH_NUMBER,
GRAPH_STYLE,
DISPLAY_FLAG,
DEPTH_RADIUS,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN
) values (
p_region_application_id,
p_region_code,
p_graph_number,
p_graph_style,
p_display_flag,
l_depth_radius,
l_creation_date,
l_created_by,
l_last_update_date,
l_last_updated_by,
l_last_update_login
);

Line: 3558


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

Line: 3565


insert into AK_REGION_GRAPHS_TL (
REGION_APPLICATION_ID,
REGION_CODE,
GRAPH_NUMBER,
LANGUAGE,
GRAPH_TITLE,
Y_AXIS_LABEL,
SOURCE_LANG,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN
) select
p_region_application_id,
p_region_code,
p_graph_number,
L.LANGUAGE_CODE,
l_graph_title,
l_y_axis_label,
decode(L.LANGUAGE_CODE, l_lang, L.LANGUAGE_CODE, l_lang),
l_created_by,
l_creation_date,
l_last_updated_by,
l_last_update_date,
l_last_update_login
from FND_LANGUAGES L
where L.INSTALLED_FLAG in ('I', 'B')
and not exists
(select NULL
from AK_REGION_GRAPHS_TL T
where T.REGION_APPLICATION_ID = p_region_application_id
and T.REGION_CODE = p_region_code
and T.GRAPH_NUMBER = p_graph_number
and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 3706


p_update_flag              IN      VARCHAR2,
p_required_flag            IN      VARCHAR2,
p_security_code            IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_default_value_varchar2   IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_default_value_number     IN      NUMBER := FND_API.G_MISS_NUM,
p_default_value_date       IN      DATE := FND_API.G_MISS_DATE,
p_lov_region_application_id IN     NUMBER := FND_API.G_MISS_NUM,
p_lov_region_code          IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_lov_foreign_key_name     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_lov_attribute_application_id IN  NUMBER := FND_API.G_MISS_NUM,
p_lov_attribute_code       IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_lov_default_flag         IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_region_defaulting_api_pkg IN     VARCHAR2 := FND_API.G_MISS_CHAR,
p_region_defaulting_api_proc IN    VARCHAR2 := FND_API.G_MISS_CHAR,
p_region_validation_api_pkg IN     VARCHAR2 := FND_API.G_MISS_CHAR,
p_region_validation_api_proc IN    VARCHAR2 := FND_API.G_MISS_CHAR,
p_order_sequence           IN      NUMBER := FND_API.G_MISS_NUM,
p_order_direction          IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_display_height		IN	NUMBER := FND_API.G_MISS_NUM,
p_submit			IN		 VARCHAR2,
p_encrypt			IN		 VARCHAR2,
p_css_class_name				 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_view_usage_name			 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_view_attribute_name		 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_nested_region_appl_id	 IN		 NUMBER := FND_API.G_MISS_NUM,
p_nested_region_code		 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_url						 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_poplist_viewobject		 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_poplist_display_attr   	 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_poplist_value_attr		 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_image_file_name			 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_item_name				 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_css_label_class_name	 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_menu_name		     IN	     VARCHAR2 := FND_API.G_MISS_CHAR,
p_flexfield_name	     IN	     VARCHAR2 := FND_API.G_MISS_CHAR,
p_flexfield_application_id IN	     NUMBER   := FND_API.G_MISS_NUM,
p_tabular_function_code    IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_tip_type                 IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_tip_message_name         IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_tip_message_application_id   IN      NUMBER   := FND_API.G_MISS_NUM,
p_flex_segment_list            IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_entity_id                IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_anchor                   IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_poplist_view_usage_name  IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_user_customizable	     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_sortby_view_attribute_name   IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_admin_customizable	     IN	     VARCHAR2,
p_invoke_function_name     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_expansion		     IN      NUMBER   := FND_API.G_MISS_NUM,
p_als_max_length	     IN      NUMBER   := FND_API.G_MISS_NUM,
p_initial_sort_sequence    IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_customization_application_id IN  NUMBER   := FND_API.G_MISS_NUM,
p_customization_code	     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute_category       IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute1               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute2               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute3               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute4               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute5               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute6               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute7               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute8               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute9               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute10              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute11              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute12              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute13              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute14              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute15              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute_label_long     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute_label_short    IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_description			     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_created_by               IN     NUMBER := FND_API.G_MISS_NUM,
p_creation_date            IN      DATE := FND_API.G_MISS_DATE,
p_last_updated_by          IN     NUMBER := FND_API.G_MISS_NUM,
p_last_update_date         IN      DATE := FND_API.G_MISS_DATE,
p_last_update_login        IN     NUMBER := FND_API.G_MISS_NUM,
p_loader_timestamp         IN      DATE := FND_API.G_MISS_DATE,
p_pass                     IN      NUMBER,
p_copy_redo_flag           IN OUT NOCOPY  BOOLEAN

) is
l_api_version_number      CONSTANT number := 1.0;

Line: 3801


l_last_update_date        date;

Line: 3802


l_last_update_login       number;

Line: 3803


l_last_updated_by         number;

Line: 3869


l_update_flag             VARCHAR2(1) := 'Y';

Line: 3888


/* now if we hit that error the exception handling calls update_item */
/* --** check to see if row already exists **
if AK_REGION_PVT.ITEM_EXISTS (
p_api_version_number => 1.0,
p_return_status => l_return_status,
p_region_application_id => p_region_application_id,
p_region_code => p_region_code,
p_attribute_application_id => p_attribute_application_id,
p_attribute_code => p_attribute_code) then
if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_EXISTS');

Line: 3949


p_update_flag => p_update_flag,
p_required_flag => p_required_flag,
p_security_code => p_security_code,
p_default_value_varchar2 => p_default_value_varchar2,
p_default_value_number => p_default_value_number,
p_default_value_date => p_default_value_date,
p_nested_region_appl_id => p_nested_region_appl_id,
p_nested_region_code => p_nested_region_code,
p_lov_region_application_id => p_lov_region_application_id,
p_lov_region_code => p_lov_region_code,
p_lov_foreign_key_name => p_lov_foreign_key_name,
p_lov_attribute_application_id => p_lov_attribute_application_id,
p_lov_attribute_code => p_lov_attribute_code,
p_lov_default_flag => p_lov_default_flag,
p_region_defaulting_api_pkg => p_region_defaulting_api_pkg,
p_region_defaulting_api_proc => p_region_defaulting_api_proc,
p_region_validation_api_pkg => p_region_validation_api_pkg,
p_region_validation_api_proc => p_region_validation_api_proc,
p_order_sequence => p_order_sequence,
p_order_direction => p_order_direction,
p_menu_name => p_menu_name,
p_flexfield_name => p_flexfield_name,
p_flexfield_application_id => p_flexfield_application_id,
p_tabular_function_code    => p_tabular_function_code,
p_tip_type                 => p_tip_type,
p_tip_message_name         => p_tip_message_name,
p_tip_message_application_id  => p_tip_message_application_id ,
p_flex_segment_list        => p_flex_segment_list,
p_entity_id                => p_entity_id,
p_anchor                   => p_anchor,
p_poplist_view_usage_name  => p_poplist_view_usage_name,
p_user_customizable	       => p_user_customizable,
p_sortby_view_attribute_name => p_sortby_view_attribute_name,
p_invoke_function_name => p_invoke_function_name,
p_expansion => p_expansion,
p_als_max_length => p_als_max_length,
p_initial_sort_sequence => p_initial_sort_sequence,
p_customization_application_id => p_customization_application_id,
p_customization_code => p_customization_code,
p_attribute_label_long => p_attribute_label_long,
p_attribute_label_short => p_attribute_label_short,
p_caller => AK_ON_OBJECTS_PVT.G_CREATE,
p_pass => p_pass
) then
-- Do not raise an error if it's the first pass
if (p_pass = 1) then
p_copy_redo_flag := TRUE;

Line: 4007


l_update_flag := p_update_flag;

Line: 4025


l_update_flag := 'Y';

Line: 4320


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

Line: 4324


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

Line: 4328


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

Line: 4338


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

Line: 4351


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

Line: 4354


insert into AK_REGION_ITEMS (
REGION_APPLICATION_ID,
REGION_CODE,
ATTRIBUTE_APPLICATION_ID,
ATTRIBUTE_CODE,
DISPLAY_SEQUENCE,
NODE_DISPLAY_FLAG,
NODE_QUERY_FLAG,
ATTRIBUTE_LABEL_LENGTH,
DISPLAY_VALUE_LENGTH,
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,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
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_display_sequence,
p_node_display_flag,
p_node_query_flag,
p_attribute_label_length,
p_display_value_length,
p_bold,
p_italic,
p_vertical_alignment,
p_horizontal_alignment,
p_item_style,
p_object_attribute_flag,
l_icx_custom_call,
l_update_flag,
p_required_flag,
l_security_code,
l_default_value_varchar2,
l_default_value_number,
l_default_value_date,
l_lov_region_appl_id,
l_lov_region_code,
l_lov_foreign_key_name,
l_lov_attribute_appl_id,
l_lov_attribute_code,
l_lov_default_flag,
l_region_defaulting_api_pkg,
l_region_defaulting_api_proc,
l_region_validation_api_pkg,
l_region_validation_api_proc,
l_order_sequence,
l_order_direction,
l_display_height,
l_submit,
l_encrypt,
l_css_class_name,
l_view_usage_name,
l_view_attribute_name,
l_nested_region_appl_id,
l_nested_region_code,
l_url,
l_poplist_viewobject,
l_poplist_display_attr,
l_poplist_value_attr,
l_image_file_name,
l_item_name,
l_css_label_class_name,
l_menu_name,
l_flexfield_name,
l_flexfield_application_id,
l_tabular_function_code,
l_tip_type,
l_tip_message_name,
l_tip_message_application_id,
l_flex_segment_list,
l_entity_id,
l_anchor,
l_poplist_view_usage_name,
l_user_customizable,
l_sortby_view_attribute_name,
l_admin_customizable,
l_invoke_function_name,
l_expansion,
l_als_max_length,
l_initial_sort_sequence,
l_customization_application_id,
l_customization_code,
l_attribute_category,
l_attribute1,
l_attribute2,
l_attribute3,
l_attribute4,
l_attribute5,
l_attribute6,
l_attribute7,
l_attribute8,
l_attribute9,
l_attribute10,
l_attribute11,
l_attribute12,
l_attribute13,
l_attribute14,
l_attribute15,
l_creation_date,
l_created_by,
l_last_update_date,
l_last_updated_by,
l_last_update_login
);

Line: 4547


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

Line: 4554


insert into AK_REGION_ITEMS_TL (
REGION_APPLICATION_ID,
REGION_CODE,
ATTRIBUTE_APPLICATION_ID,
ATTRIBUTE_CODE,
LANGUAGE,
ATTRIBUTE_LABEL_LONG,
ATTRIBUTE_LABEL_SHORT,
DESCRIPTION,
SOURCE_LANG,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN
) select
p_region_application_id,
p_region_code,
p_attribute_application_id,
p_attribute_code,
L.LANGUAGE_CODE,
l_attribute_label_long,
l_attribute_label_short,
l_description,
decode(L.LANGUAGE_CODE, l_lang, L.LANGUAGE_CODE, l_lang),
l_created_by,
l_creation_date,
l_last_updated_by,
l_last_update_date,
l_last_update_login
from FND_LANGUAGES L
where L.INSTALLED_FLAG in ('I', 'B')
and not exists
(select NULL
from AK_REGION_ITEMS_TL T
where T.REGION_APPLICATION_ID = p_region_application_id
and T.REGION_CODE = p_region_code
and T.ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
and T.ATTRIBUTE_CODE = p_attribute_code
and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 4646


        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 => p_return_status,
          p_region_application_id => p_region_application_id,
          p_region_code => p_region_code,
          p_attribute_application_id => p_attribute_application_id,
          p_attribute_code => p_attribute_code,
          p_display_sequence => p_display_sequence,
          p_node_display_flag => p_node_display_flag,
          p_node_query_flag => p_node_query_flag,
          p_attribute_label_length => p_attribute_label_length,
          p_display_value_length => p_display_value_length,
          p_bold => p_bold,
          p_italic => p_italic,
          p_vertical_alignment => p_vertical_alignment,
          p_horizontal_alignment => p_horizontal_alignment,
          p_item_style => p_item_style,
          p_object_attribute_flag => p_object_attribute_flag,
          p_icx_custom_call => p_icx_custom_call,
          p_update_flag => p_update_flag,
          p_required_flag => p_required_flag,
          p_security_code => p_security_code,
          p_default_value_varchar2 => p_default_value_varchar2,
          p_default_value_number => p_default_value_number,
          p_default_value_date => p_default_value_date,
          p_lov_region_application_id => p_lov_region_application_id,
          p_lov_region_code => p_lov_region_code,
          p_lov_foreign_key_name => p_lov_foreign_key_name,
          p_lov_attribute_application_id => p_lov_attribute_application_id,
          p_lov_attribute_code => p_lov_attribute_code,
          p_lov_default_flag => p_lov_default_flag,
          p_region_defaulting_api_pkg => p_region_defaulting_api_pkg,
          p_region_defaulting_api_proc => p_region_defaulting_api_proc,
          p_region_validation_api_pkg => p_region_validation_api_pkg,
          p_region_validation_api_proc => p_region_validation_api_proc,
          p_order_sequence => p_order_sequence,
          p_order_direction => p_order_direction,
          p_display_height => p_display_height,
          p_submit => p_submit,
          p_encrypt => p_encrypt,
          p_css_class_name => p_css_class_name,
          p_view_usage_name => p_view_usage_name,
          p_view_attribute_name => p_view_attribute_name,
          p_nested_region_appl_id => p_nested_region_appl_id,
          p_nested_region_code => p_nested_region_code,
          p_url => p_url,
          p_poplist_viewobject => p_poplist_viewobject,
          p_poplist_display_attr => p_poplist_display_attr,
          p_poplist_value_attr => p_poplist_value_attr,
          p_image_file_name => p_image_file_name,
          p_item_name => p_item_name,
          p_css_label_class_name => p_css_label_class_name,
          p_menu_name => p_menu_name,
          p_flexfield_name => p_flexfield_name,
          p_flexfield_application_id => p_flexfield_application_id,
          p_tabular_function_code    => p_tabular_function_code,
          p_tip_type                 => p_tip_type,
          p_tip_message_name         => p_tip_message_name,
          p_tip_message_application_id  => p_tip_message_application_id ,
          p_flex_segment_list        => p_flex_segment_list,
          p_entity_id  => p_entity_id,
          p_anchor     => p_anchor,
          p_poplist_view_usage_name => p_poplist_view_usage_name,
          p_user_customizable => p_user_customizable,
          p_sortby_view_attribute_name => p_sortby_view_attribute_name,
          p_admin_customizable => p_admin_customizable,
          p_invoke_function_name => p_invoke_function_name,
          p_expansion => p_expansion,
          p_als_max_length => p_als_max_length,
          p_initial_sort_sequence => p_initial_sort_sequence,
          p_customization_application_id => p_customization_application_id,
          p_customization_code => p_customization_code,
          p_attribute_category => p_attribute_category,
          p_attribute1 => p_attribute1,
          p_attribute2 => p_attribute2,
          p_attribute3 => p_attribute3,
          p_attribute4 => p_attribute4,
          p_attribute5 => p_attribute5,
          p_attribute6 => p_attribute6,
          p_attribute7 => p_attribute7,
          p_attribute8 => p_attribute8,
          p_attribute9 => p_attribute9,
          p_attribute10 => p_attribute10,
          p_attribute11 => p_attribute11,
          p_attribute12 => p_attribute12,
          p_attribute13 => p_attribute13,
          p_attribute14 => p_attribute14,
          p_attribute15 => p_attribute15,
          p_attribute_label_long => p_attribute_label_long,
          p_attribute_label_short => p_attribute_label_short,
          p_description => p_description,
          p_created_by => p_created_by,
          p_creation_date => p_creation_date,
          p_last_updated_by => p_last_updated_by,
          p_last_update_date => p_last_update_date,
          p_last_update_login => p_last_update_login,
          p_loader_timestamp => p_loader_timestamp,
          p_pass => p_pass,
          p_copy_redo_flag => p_copy_redo_flag
          );

Line: 4845


p_last_updated_by          IN     NUMBER := FND_API.G_MISS_NUM,
p_last_update_date         IN      DATE := FND_API.G_MISS_DATE,
p_last_update_login        IN     NUMBER := FND_API.G_MISS_NUM,
p_loader_timestamp         IN      DATE := FND_API.G_MISS_DATE,
p_pass                     IN      NUMBER,
p_copy_redo_flag           IN OUT NOCOPY  BOOLEAN
) is
l_attribute_category VARCHAR2(30);

Line: 4875


l_last_update_date   date;

Line: 4876


l_last_update_login  number;

Line: 4877


l_last_updated_by    number;

Line: 5159


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

Line: 5163


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

Line: 5167


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

Line: 5177


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

Line: 5190


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

Line: 5193


insert into AK_REGIONS (
REGION_APPLICATION_ID,
REGION_CODE,
DATABASE_OBJECT_NAME,
REGION_STYLE,
ICX_CUSTOM_CALL,
NUM_COLUMNS,
REGION_DEFAULTING_API_PKG,
REGION_DEFAULTING_API_PROC,
REGION_VALIDATION_API_PKG,
REGION_VALIDATION_API_PROC,
APPLICATIONMODULE_OBJECT_TYPE,
NUM_ROWS_DISPLAY,
REGION_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,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN
) values (
p_region_application_id,
p_region_code,
p_database_object_name,
p_region_style,
l_icx_custom_call,
l_num_columns,
l_region_defaulting_api_pkg,
l_region_defaulting_api_proc,
l_region_validation_api_pkg,
l_region_validation_api_proc,
l_appmodule_object_type,
l_num_rows_display,
l_region_object_type,
l_image_file_name,
l_isform_flag,
l_help_target,
l_style_sheet_filename,
l_version,
l_appmodule_usage_name,
l_add_indexed_children,
l_stateful_flag,
l_function_name,
l_children_view_usage_name,
l_search_panel,
l_advanced_search_panel,
l_customize_panel,
l_default_search_panel,
l_results_based_search,
l_display_graph_table,
l_disable_header,
l_standalone,
l_auto_customization_criteria,
l_attribute_category,
l_attribute1,
l_attribute2,
l_attribute3,
l_attribute4,
l_attribute5,
l_attribute6,
l_attribute7,
l_attribute8,
l_attribute9,
l_attribute10,
l_attribute11,
l_attribute12,
l_attribute13,
l_attribute14,
l_attribute15,
l_creation_date,
l_created_by,
l_last_update_date,
l_last_updated_by,
l_last_update_login
);

Line: 5310


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

Line: 5317


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

Line: 5397


         AK_REGION_PVT.UPDATE_REGION(
           p_validation_level => p_validation_level,
           p_api_version_number => 1.0,
           p_msg_count => p_msg_count,
           p_msg_data => p_msg_data,
           p_return_status => p_return_status,
           p_region_application_id => p_region_application_id,
           p_region_code => p_region_code,
           p_database_object_name =>p_database_object_name,
           p_region_style => p_region_style,
           p_num_columns => p_num_columns,
           p_icx_custom_call => p_icx_custom_call,
           p_region_defaulting_api_pkg => p_region_defaulting_api_pkg,
           p_region_defaulting_api_proc => p_region_defaulting_api_proc,
           p_region_validation_api_pkg => p_region_validation_api_pkg,
           p_region_validation_api_proc => p_region_validation_api_proc,
           p_appmodule_object_type => p_appmodule_object_type,
           p_num_rows_display => p_num_rows_display,
           p_region_object_type => p_region_object_type,
           p_image_file_name => p_image_file_name,
           p_isform_flag => p_isform_flag,
           p_help_target => p_help_target,
           p_style_sheet_filename => p_style_sheet_filename,
           p_version => p_version,
           p_applicationmodule_usage_name => p_applicationmodule_usage_name,
           p_add_indexed_children => p_add_indexed_children,
           p_stateful_flag => p_stateful_flag,
           p_function_name => p_function_name,
           p_children_view_usage_name => p_children_view_usage_name,
          p_search_panel => p_search_panel,
          p_advanced_search_panel => p_advanced_search_panel,
          p_customize_panel => p_customize_panel,
          p_default_search_panel => p_default_search_panel,
          p_results_based_search => p_results_based_search,
          p_display_graph_table => p_display_graph_table,
          p_disable_header => p_disable_header,
          p_standalone => p_standalone,
          p_auto_customization_criteria => p_auto_customization_criteria,
           p_attribute_category => p_attribute_category,
           p_attribute1 => p_attribute1,
           p_attribute2 => p_attribute2,
           p_attribute3 => p_attribute3,
           p_attribute4 => p_attribute4,
           p_attribute5 => p_attribute5,
           p_attribute6 => p_attribute6,
           p_attribute7 => p_attribute7,
           p_attribute8 => p_attribute8,
           p_attribute9 => p_attribute9,
           p_attribute10 => p_attribute10,
           p_attribute11 => p_attribute11,
           p_attribute12 => p_attribute12,
           p_attribute13 => p_attribute13,
           p_attribute14 => p_attribute14,
           p_attribute15 => p_attribute15,
           p_name => p_name,
           p_description => p_description,
           p_created_by => p_created_by,
           p_creation_date => p_creation_date,
           p_last_updated_by => p_last_updated_by,
           p_last_update_date => p_last_update_date,
           p_last_update_login => p_last_update_login,
           p_loader_timestamp => p_loader_timestamp,
           p_pass => p_pass,
           p_copy_redo_flag => p_copy_redo_flag
           );

Line: 5503


procedure DELETE_GRAPH (
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,
p_region_code              IN      VARCHAR2,
p_graph_number	     IN	     NUMBER,
p_delete_cascade           IN      VARCHAR2
) is
cursor l_get_graph_column_csr is
select ATTRIBUTE_APPLICATION_ID, ATTRIBUTE_CODE
from AK_REGION_GRAPH_COLUMNS
where region_application_id = p_region_application_id
and region_code = p_region_code
and graph_number = p_graph_number;

Line: 5522


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

Line: 5542


savepoint start_delete_graph;

Line: 5560


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

Line: 5617


delete from ak_region_graphs
where region_application_id = p_region_application_id
and    region_code = p_region_code
and    graph_number = p_graph_number;

Line: 5630


delete from ak_region_graphs_tl
where  region_application_id = p_region_application_id
and    region_code = p_region_code
and    graph_number = p_graph_number;

Line: 5647


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

Line: 5663


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

Line: 5670


rollback to start_delete_graph;

Line: 5676


rollback to start_delete_graph;

Line: 5683


end DELETE_GRAPH;

Line: 5714


procedure DELETE_ITEM (
p_validation_level         IN      NUMBER := FND_API.G_VALID_LEVEL_FULL,
p_api_version_number       IN      NUMBER,
p_init_msg_tbl             IN      BOOLEAN := FALSE,
p_msg_count                OUT NOCOPY     NUMBER,
p_msg_data                 OUT NOCOPY     VARCHAR2,
p_return_status            OUT NOCOPY     VARCHAR2,
p_region_application_id    IN      NUMBER,
p_region_code              IN      VARCHAR2,
p_attribute_application_id IN      NUMBER,
p_attribute_code           IN      VARCHAR2,
p_delete_cascade           IN      VARCHAR2
) is
cursor l_get_lov_relations_csr is
select 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
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;

Line: 5737


select CATEGORY_ID
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;

Line: 5744


select FLOW_APPLICATION_ID, FLOW_CODE, PAGE_APPLICATION_ID, PAGE_CODE
from  AK_FLOW_PAGE_REGION_ITEMS
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;

Line: 5751


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

Line: 5783


savepoint start_delete_item;

Line: 5802


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

Line: 5835


delete 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 = l_lov_region_appl_id
and    lov_region_code = l_lov_region_code
and    lov_attribute_appl_id = l_lov_attribute_appl_id
and    lov_attribute_code = l_lov_attribute_code
and    base_attribute_appl_id = l_base_attribute_appl_id
and    base_attribute_code = l_base_attribute_code
and    direction_flag = l_direction_flag
and    base_region_appl_id = l_base_region_appl_id
and    base_region_code = l_base_region_code;

Line: 5868


delete 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_id = l_category_id;

Line: 5923


delete from ak_region_items
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;

Line: 5937


delete from ak_region_items_tl
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;

Line: 5955


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

Line: 5972


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

Line: 5980


rollback to start_delete_item;

Line: 5986


rollback to start_delete_item;

Line: 5993


end DELETE_ITEM;

Line: 6021


procedure DELETE_REGION (
p_validation_level         IN      NUMBER := FND_API.G_VALID_LEVEL_FULL,
p_api_version_number       IN      NUMBER,
p_init_msg_tbl             IN      BOOLEAN := FALSE,
p_msg_count                OUT NOCOPY     NUMBER,
p_msg_data                 OUT NOCOPY     VARCHAR2,
p_return_status            OUT NOCOPY     VARCHAR2,
p_region_application_id    IN      NUMBER,
p_region_code              IN      VARCHAR2,
p_delete_cascade           IN      VARCHAR2
) is
cursor l_is_region_a_child_csr is
select region_code, region_application_id
from AK_REGION_ITEMS
where region_code <> p_region_code
and   region_application_id <> p_region_application_id
and   (lov_region_code = p_region_code
and   lov_region_application_id = p_region_application_id)
or    (nested_region_code = p_region_code
and   nested_region_application_id = p_region_application_id);

Line: 6042


select FLOW_APPLICATION_ID, FLOW_CODE, PAGE_APPLICATION_ID, PAGE_CODE
from  AK_FLOW_PAGE_REGIONS
where region_application_id = p_region_application_id
and   region_code = p_region_code;

Line: 6047


select ATTRIBUTE_APPLICATION_ID, ATTRIBUTE_CODE
from  AK_REGION_ITEMS
where region_application_id = p_region_application_id
and   region_code = p_region_code;

Line: 6052


select DATABASE_OBJECT_NAME, ATTRIBUTE_APPLICATION_ID, ATTRIBUTE_CODE,
VALUE_VARCHAR2, VALUE_DATE, VALUE_NUMBER
from  AK_OBJECT_ATTRIBUTE_NAVIGATION
where to_region_appl_id = p_region_application_id
and   to_region_code = p_region_code;

Line: 6058


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

Line: 6088


savepoint start_delete_region;

Line: 6126


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

Line: 6186


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 => p_region_application_id,
p_region_code => p_region_code,
p_attribute_application_id => l_attribute_application_id,
p_attribute_code => l_attribute_code,
p_delete_cascade => p_delete_cascade
);

Line: 6271


delete from ak_regions
where  region_application_id = p_region_application_id
and    region_code = p_region_code;

Line: 6283


delete from ak_regions_tl
where  region_application_id = p_region_application_id
and    region_code = p_region_code;

Line: 6300


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

Line: 6316


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

Line: 6322


rollback to start_delete_region;

Line: 6328


rollback to start_delete_region;

Line: 6335


end DELETE_REGION;

Line: 6391


select region_application_id, region_code
from   AK_REGIONS
where  REGION_APPLICATION_ID = application_id;

Line: 6396


select ATTRIBUTE_APPLICATION_ID, ATTRIBUTE_CODE
from   AK_REGION_ITEMS
where  region_application_id = region_appl_id_param
and    region_code = region_code_param
and    object_attribute_flag = 'N';

Line: 6403


select distinct to_region_appl_id, to_region_code
from   AK_OBJECT_ATTRIBUTE_NAVIGATION aoan, AK_REGIONS ar
where  ar.region_application_id = region_appl_id_param
and    ar.region_code = region_code_param
and    aoan.database_object_name = ar.database_object_name;

Line: 6410


select DATABASE_OBJECT_NAME
from   AK_REGIONS
where  region_application_id = region_appl_id_param
and    region_code = region_code_param;

Line: 6416


select distinct lov_region_application_id, lov_region_code
from   AK_REGION_ITEMS
where  region_application_id = region_appl_id_param
and    region_code = region_code_param
and    lov_region_application_id is not null
and    lov_region_code is not null;

Line: 6424


select distinct aoa.lov_region_application_id, aoa.lov_region_code
from   AK_REGIONS ar, AK_OBJECT_ATTRIBUTES aoa
where  ar.region_application_id = region_appl_id_param
and    ar.region_code = region_code_param
and    ar.database_object_name = aoa.database_object_name
and    aoa.lov_region_application_id is not null
and    aoa.lov_region_code is not null;

Line: 6433


select distinct aa.lov_region_application_id, aa.lov_region_code
from   AK_REGION_ITEMS ar, AK_ATTRIBUTES aa
where  ar.region_application_id = region_appl_id_param
and    ar.region_code = region_code_param
and    ar.object_attribute_flag = 'N'
and    ar.attribute_application_id = aa.attribute_application_id
and    ar.attribute_code = aa.attribute_code
and    aa.lov_region_application_id is not null
and    aa.lov_region_code is not null;

Line: 6444


select region_application_id, region_code, attribute_application_id,
attribute_code
from   ak_region_items
where  region_application_id = region_appl_id_param
and    region_code = region_code_param
and    object_attribute_flag = 'N'
and    lov_region_application_id is not null
and    lov_region_code is not null;

Line: 6456


select distinct lov_region_appl_id, lov_region_code
from   ak_region_lov_relations
where  region_application_id = region_appl_id_param
and    region_code = region_code_param
and    attribute_application_id = attribute_appl_id_param
and    attribute_code = attribute_code_param;

Line: 6486


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

Line: 6535


ak_region_pvt.insert_region_pk_table(
p_return_status => l_return_status,
p_region_application_id => l_region_rec.to_region_appl_id,
p_region_code => l_region_rec.to_region_code,
p_region_pk_tbl => l_region_pk_tbl);

Line: 6553


AK_OBJECT_PVT.INSERT_OBJECT_PK_TABLE (
p_return_status => l_return_status,
p_database_object_name => l_object_rec.database_object_name,
p_object_pk_tbl => l_object_pk_tbl);

Line: 6565


AK_ATTRIBUTE_PVT.INSERT_ATTRIBUTE_PK_TABLE (
p_return_status => l_return_status,
p_attribute_application_id =>
l_attribute_rec.attribute_application_id,
p_attribute_code => l_attribute_rec.attribute_code,
p_attribute_pk_tbl => l_attribute_pk_tbl);

Line: 6579


AK_REGION_PVT.INSERT_REGION_PK_TABLE (
p_return_status => l_return_status,
p_region_application_id =>
l_region_rec.lov_region_application_id,
p_region_code => l_region_rec.lov_region_code,
p_region_pk_tbl => l_region_pk_tbl);

Line: 6592


AK_REGION_PVT.INSERT_REGION_PK_TABLE (
p_return_status => l_return_status,
p_region_application_id =>
l_region_rec.lov_region_application_id,
p_region_code => l_region_rec.lov_region_code,
p_region_pk_tbl => l_region_pk_tbl);

Line: 6605


AK_REGION_PVT.INSERT_REGION_PK_TABLE (
p_return_status => l_return_status,
p_region_application_id =>
l_region_rec.lov_region_application_id,
p_region_code => l_region_rec.lov_region_code,
p_region_pk_tbl => l_region_pk_tbl);

Line: 6621


AK_REGION_PVT.INSERT_REGION_PK_TABLE (
p_return_status => l_return_status,
p_region_application_id =>
l_region_rec.lov_region_appl_id,
p_region_code => l_region_rec.lov_region_code,
p_region_pk_tbl => l_region_pk_tbl);

Line: 6756


procedure INSERT_REGION_PK_TABLE (
p_return_status            OUT NOCOPY     VARCHAR2,
p_region_application_id    IN      NUMBER,
p_region_code              IN      VARCHAR2,
p_region_pk_tbl            IN OUT NOCOPY  AK_REGION_PUB.Region_PK_Tbl_Type
) is
l_api_version_number CONSTANT number := 1.0;

Line: 6763


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

Line: 6807


end INSERT_REGION_PK_TABLE;

Line: 6841


select 1
from  AK_REGION_GRAPHS
where region_application_id = p_region_application_id
and   region_code = p_region_code
and   graph_number = p_graph_number;

Line: 6915


select 1
from  AK_REGION_ITEMS
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;

Line: 6987


select 1
from  AK_REGIONS
where region_application_id = p_region_application_id
and   region_code = p_region_code;

Line: 7050


procedure UPDATE_GRAPH (
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,
p_region_code              IN      VARCHAR2,
p_graph_number	     IN      NUMBER,
p_graph_style		     IN      NUMBER := FND_API.G_MISS_NUM,
p_display_flag	     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_depth_radius	     IN      NUMBER := FND_API.G_MISS_NUM,
p_graph_title		     IN	     VARCHAR2 := FND_API.G_MISS_CHAR,
p_y_axis_label	     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_GRAPHS
where REGION_APPLICATION_ID = p_region_application_id
and   REGION_CODE = p_region_code
and   GRAPH_NUMBER = p_graph_number
for update of GRAPH_STYLE;

Line: 7082


select *
from  AK_REGION_GRAPHS_TL
where REGION_APPLICATION_ID = p_region_application_id
and   REGION_CODE = p_region_code
and   GRAPH_NUMBER = p_graph_number
and   LANGUAGE = lang_parm
for update of GRAPH_TITLE;

Line: 7090


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

Line: 7097


l_last_update_date       date;

Line: 7098


l_last_update_login      number;

Line: 7099


l_last_updated_by        number;

Line: 7118


savepoint start_update_graph;

Line: 7120


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

Line: 7167


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

Line: 7210


AK_UPLOAD_GRP.G_UPLOAD_DATE := p_last_update_date;

Line: 7216


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

Line: 7222


        l_last_updated_by := p_last_updated_by;

Line: 7223


        l_last_update_login := p_last_update_login;

Line: 7226


update AK_REGION_GRAPHS set
GRAPH_STYLE = l_graphs_rec.graph_style,
DISPLAY_FLAG = l_graphs_rec.display_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   GRAPH_NUMBER = p_graph_number;

Line: 7237


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

Line: 7244


update AK_REGION_GRAPHS_TL set
GRAPH_TITLE = l_graphs_tl_rec.graph_title,
Y_AXIS_LABEL = l_graphs_tl_rec.y_axis_label,
LAST_UPDATED_BY = l_last_updated_by,
LAST_UPDATE_DATE = l_last_update_date,
LAST_UPDATE_LOGIN = l_last_update_login,
SOURCE_LANG = l_lang
where REGION_APPLICATION_ID = p_region_application_id
and   REGION_CODE = p_region_code
and   GRAPH_NUMBER = p_graph_number
and   l_lang in (LANGUAGE, SOURCE_LANG);

Line: 7257


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

Line: 7268


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

Line: 7290


rollback to start_update_graph;

Line: 7297


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

Line: 7304


rollback to start_update_graph;

Line: 7311


end UPDATE_GRAPH;

Line: 7337


procedure UPDATE_ITEM (
p_validation_level         IN      NUMBER := FND_API.G_VALID_LEVEL_FULL,
p_api_version_number       IN      NUMBER,
p_init_msg_tbl             IN      BOOLEAN := FALSE,
p_msg_count                OUT NOCOPY     NUMBER,
p_msg_data                 OUT NOCOPY     VARCHAR2,
p_return_status            OUT NOCOPY     VARCHAR2,
p_region_application_id    IN      NUMBER,
p_region_code              IN      VARCHAR2,
p_attribute_application_id IN      NUMBER,
p_attribute_code           IN      VARCHAR2,
p_display_sequence         IN      NUMBER := FND_API.G_MISS_NUM,
p_node_display_flag        IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_node_query_flag          IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute_label_length   IN      NUMBER := FND_API.G_MISS_NUM,
p_display_value_length     IN      NUMBER := FND_API.G_MISS_NUM,
p_bold                     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_italic                   IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_vertical_alignment       IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_horizontal_alignment     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_item_style               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_object_attribute_flag    IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_icx_custom_call          IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_update_flag              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_required_flag            IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_security_code            IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_default_value_varchar2   IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_default_value_number     IN      NUMBER := FND_API.G_MISS_NUM,
p_default_value_date       IN      DATE := FND_API.G_MISS_DATE,
p_lov_region_application_id IN     NUMBER := FND_API.G_MISS_NUM,
p_lov_region_code          IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_lov_foreign_key_name     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_lov_attribute_application_id IN  NUMBER := FND_API.G_MISS_NUM,
p_lov_attribute_code       IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_lov_default_flag         IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_region_defaulting_api_pkg IN     VARCHAR2 := FND_API.G_MISS_CHAR,
p_region_defaulting_api_proc IN    VARCHAR2 := FND_API.G_MISS_CHAR,
p_region_validation_api_pkg IN     VARCHAR2 := FND_API.G_MISS_CHAR,
p_region_validation_api_proc IN    VARCHAR2 := FND_API.G_MISS_CHAR,
p_order_sequence           IN      NUMBER := FND_API.G_MISS_NUM,
p_order_direction          IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_display_height			 IN		 NUMBER := FND_API.G_MISS_NUM,
p_submit					 IN		 VARCHAR2,
p_encrypt					 IN		 VARCHAR2,
p_css_class_name				 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_view_usage_name			 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_view_attribute_name		 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_nested_region_appl_id	 IN		 NUMBER := FND_API.G_MISS_NUM,
p_nested_region_code		 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_url						 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_poplist_viewobject		 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_poplist_display_attr	 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_poplist_value_attr		 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_image_file_name			 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_item_name				 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_css_label_class_name	 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_menu_name		     IN	     VARCHAR2 := FND_API.G_MISS_CHAR,
p_flexfield_name	     IN	     VARCHAR2 := FND_API.G_MISS_CHAR,
p_flexfield_application_id IN	     NUMBER   := FND_API.G_MISS_NUM,
p_tabular_function_code    IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_tip_type                 IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_tip_message_name         IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_tip_message_application_id   IN      NUMBER   := FND_API.G_MISS_NUM,
p_flex_segment_list        IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_entity_id                IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_anchor                   IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_poplist_view_usage_name  IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_user_customizable	     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_sortby_view_attribute_name   IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_admin_customizable		IN	VARCHAR2,
p_invoke_function_name	IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_expansion		     IN      NUMBER   := FND_API.G_MISS_NUM,
p_als_max_length	     IN      NUMBER   := FND_API.G_MISS_NUM,
p_initial_sort_sequence    IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_customization_application_id IN  NUMBER   := FND_API.G_MISS_NUM,
p_customization_code	     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute_category       IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute1               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute2               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute3               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute4               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute5               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute6               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute7               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute8               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute9               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute10              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute11              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute12              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute13              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute14              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute15              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute_label_long     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute_label_short    IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_description				 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_created_by               IN     NUMBER := FND_API.G_MISS_NUM,
p_creation_date            IN      DATE := FND_API.G_MISS_DATE,
p_last_updated_by          IN     NUMBER := FND_API.G_MISS_NUM,
p_last_update_date         IN      DATE := FND_API.G_MISS_DATE,
p_last_update_login        IN     NUMBER := FND_API.G_MISS_NUM,
p_loader_timestamp         IN      DATE := FND_API.G_MISS_DATE,
p_pass                     IN      NUMBER,
p_copy_redo_flag           IN OUT NOCOPY  BOOLEAN
) is
cursor l_get_row_csr is
select *
from  AK_REGION_ITEMS
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
for   update of DISPLAY_SEQUENCE;

Line: 7450


select *
from  AK_REGION_ITEMS_TL
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   LANGUAGE = lang_parm
for update of ATTRIBUTE_LABEL_LONG;

Line: 7459


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

Line: 7466


l_last_update_date       date;

Line: 7467


l_last_update_login      number;

Line: 7468


l_last_updated_by        number;

Line: 7475


l_create_or_update       VARCHAR2(10);

Line: 7490


savepoint start_update_item;

Line: 7492


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

Line: 7575


p_update_flag => p_update_flag,
p_required_flag => p_required_flag,
p_security_code => p_security_code,
p_default_value_varchar2 => p_default_value_varchar2,
p_default_value_number => p_default_value_number,
p_default_value_date => p_default_value_date,
p_nested_region_appl_id => p_nested_region_appl_id,
p_nested_region_code => p_nested_region_code,
p_lov_region_application_id => p_lov_region_application_id,
p_lov_region_code => p_lov_region_code,
p_lov_foreign_key_name => p_lov_foreign_key_name,
p_lov_attribute_application_id => p_lov_attribute_application_id,
p_lov_attribute_code => p_lov_attribute_code,
p_lov_default_flag => p_lov_default_flag,
p_region_defaulting_api_pkg => p_region_defaulting_api_pkg,
p_region_defaulting_api_proc => p_region_defaulting_api_proc,
p_region_validation_api_pkg => p_region_validation_api_pkg,
p_region_validation_api_proc => p_region_validation_api_proc,
p_order_sequence => p_order_sequence,
p_order_direction => p_order_direction,
p_menu_name => p_menu_name,
p_flexfield_name => p_flexfield_name,
p_flexfield_application_id => p_flexfield_application_id,
p_tabular_function_code    => p_tabular_function_code,
p_tip_type                 => p_tip_type,
p_tip_message_name          => p_tip_message_name,
p_tip_message_application_id  => p_tip_message_application_id ,
p_flex_segment_list        => p_flex_segment_list,
p_entity_id                => p_entity_id,
p_anchor                   => p_anchor,
p_poplist_view_usage_name  => p_poplist_view_usage_name,
p_user_customizable	       => p_user_customizable,
p_sortby_view_attribute_name => p_sortby_view_attribute_name,
p_invoke_function_name	=> p_invoke_function_name,
p_expansion			=> p_expansion,
p_als_max_length		=> p_als_max_length,
p_initial_sort_sequence     => p_initial_sort_sequence,
p_customization_application_id => p_customization_application_id,
p_customization_code => p_customization_application_id,
p_attribute_label_long => p_attribute_label_long,
p_attribute_label_short => p_attribute_label_short,
p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,
p_pass => p_pass
) then
--dbms_output.put_line(l_api_name || ' validation failed');

Line: 7992


if (p_update_flag <> FND_API.G_MISS_CHAR) then
l_items_rec.update_flag := p_update_flag;

Line: 8017


l_items_rec.update_flag := 'Y';

Line: 8045


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

Line: 8048


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

Line: 8051


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

Line: 8055


  /* 5452422 - if display_sequence has been raised then force update */
  if (p_display_sequence >= 1000000) then
	l_create_or_update := 'FORCE';

Line: 8059


	l_create_or_update := 'UPDATE';

Line: 8062


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

update AK_REGION_ITEMS set
DISPLAY_SEQUENCE = l_items_rec.display_sequence,
NODE_DISPLAY_FLAG = l_items_rec.node_display_flag,
NODE_QUERY_FLAG = l_items_rec.node_query_flag,
ATTRIBUTE_LABEL_LENGTH = l_items_rec.attribute_label_length,
DISPLAY_VALUE_LENGTH = l_items_rec.display_value_length,
BOLD = l_items_rec.bold,
ITALIC = l_items_rec.italic,
VERTICAL_ALIGNMENT = l_items_rec.vertical_alignment,
HORIZONTAL_ALIGNMENT = l_items_rec.horizontal_alignment,
ITEM_STYLE = l_items_rec.item_style,
OBJECT_ATTRIBUTE_FLAG = l_items_rec.object_attribute_flag,
ICX_CUSTOM_CALL = l_items_rec.icx_custom_call,
UPDATE_FLAG = l_items_rec.update_flag,
REQUIRED_FLAG = l_items_rec.required_flag,
SECURITY_CODE = l_items_rec.security_code,
DEFAULT_VALUE_VARCHAR2 = l_items_rec.default_value_varchar2,
DEFAULT_VALUE_NUMBER = l_items_rec.default_value_number,
DEFAULT_VALUE_DATE = l_items_rec.default_value_date,
LOV_REGION_APPLICATION_ID = l_items_rec.lov_region_application_id,
LOV_REGION_CODE = l_items_rec.lov_region_code,
LOV_FOREIGN_KEY_NAME = l_items_rec.lov_foreign_key_name,
LOV_ATTRIBUTE_APPLICATION_ID =
l_items_rec.lov_attribute_application_id,
LOV_ATTRIBUTE_CODE = l_items_rec.lov_attribute_code,
LOV_DEFAULT_FLAG = l_items_rec.lov_default_flag,
REGION_DEFAULTING_API_PKG = l_items_rec.region_defaulting_api_pkg,
REGION_DEFAULTING_API_PROC = l_items_rec.region_defaulting_api_proc,
REGION_VALIDATION_API_PKG = l_items_rec.region_validation_api_pkg,
REGION_VALIDATION_API_PROC = l_items_rec.region_validation_api_proc,
ORDER_SEQUENCE = l_items_rec.order_sequence,
ORDER_DIRECTION = l_items_rec.order_direction,
DISPLAY_HEIGHT = l_items_rec.display_height,
SUBMIT = l_items_rec.submit,
ENCRYPT = l_items_rec.encrypt,
css_class_name = l_items_rec.css_class_name,
VIEW_USAGE_NAME = l_items_rec.view_usage_name,
VIEW_ATTRIBUTE_NAME = l_items_rec.view_attribute_name,
NESTED_REGION_APPLICATION_ID = l_items_rec.nested_region_application_id,
NESTED_REGION_CODE = l_items_rec.nested_region_code,
URL = l_items_rec.url,
POPLIST_VIEWOBJECT = l_items_rec.poplist_viewobject,
POPLIST_DISPLAY_ATTRIBUTE = l_items_rec.poplist_display_attribute,
POPLIST_VALUE_ATTRIBUTE = l_Items_rec.poplist_value_attribute,
IMAGE_FILE_NAME = l_items_rec.image_file_name,
ITEM_NAME = l_items_rec.item_name,
CSS_LABEL_CLASS_NAME = l_items_rec.css_label_class_name,
MENU_NAME = l_items_rec.menu_name,
FLEXFIELD_NAME = l_items_rec.flexfield_name,
FLEXFIELD_APPLICATION_ID = l_items_rec.flexfield_application_id,
TABULAR_FUNCTION_CODE = l_items_rec.tabular_function_code,
TIP_TYPE  = l_items_rec.tip_type,
TIP_MESSAGE_NAME = l_items_rec.tip_message_name,
TIP_MESSAGE_APPLICATION_ID = l_items_rec.tip_message_application_id,
FLEX_SEGMENT_LIST = l_items_rec.flex_segment_list,
ENTITY_ID = l_items_rec.entity_id,
ANCHOR = l_items_rec.anchor,
POPLIST_VIEW_USAGE_NAME = l_items_rec.poplist_view_usage_name,
USER_CUSTOMIZABLE = l_items_rec.user_customizable,
SORTBY_VIEW_ATTRIBUTE_NAME = l_items_rec.sortby_view_attribute_name,
ADMIN_CUSTOMIZABLE = l_items_rec.admin_customizable,
INVOKE_FUNCTION_NAME = l_items_rec.invoke_function_name,
EXPANSION = l_items_rec.expansion,
ALS_MAX_LENGTH = l_items_rec.als_max_length,
INITIAL_SORT_SEQUENCE = l_items_rec.initial_sort_sequence,
CUSTOMIZATION_APPLICATION_ID = l_items_rec.customization_application_id,
CUSTOMIZATION_CODE = l_items_rec.customization_code,
ATTRIBUTE_CATEGORY = l_items_rec.attribute_category,
ATTRIBUTE1 = l_items_rec.attribute1,
ATTRIBUTE2 = l_items_rec.attribute2,
ATTRIBUTE3 = l_items_rec.attribute3,
ATTRIBUTE4 = l_items_rec.attribute4,
ATTRIBUTE5 = l_items_rec.attribute5,
ATTRIBUTE6 = l_items_rec.attribute6,
ATTRIBUTE7 = l_items_rec.attribute7,
ATTRIBUTE8 = l_items_rec.attribute8,
ATTRIBUTE9 = l_items_rec.attribute9,
ATTRIBUTE10 = l_items_rec.attribute10,
ATTRIBUTE11 = l_items_rec.attribute11,
ATTRIBUTE12 = l_items_rec.attribute12,
ATTRIBUTE13 = l_items_rec.attribute13,
ATTRIBUTE14 = l_items_rec.attribute14,
ATTRIBUTE15 = l_items_rec.attribute15,
LAST_UPDATE_DATE = l_last_update_date,
LAST_UPDATED_BY = l_last_updated_by,
LAST_UPDATE_LOGIN = l_last_update_login
where REGION_APPLICATION_ID = p_region_application_id
and   REGION_CODE = p_region_code
and   attribute_application_id = p_attribute_application_id
and   attribute_code = p_attribute_code;

Line: 8165


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

Line: 8172


update AK_REGION_ITEMS_TL set
ATTRIBUTE_LABEL_LONG = l_items_tl_rec.attribute_label_long,
ATTRIBUTE_LABEL_SHORT = l_items_tl_rec.attribute_label_short,
DESCRIPTION = l_items_tl_rec.description,
LAST_UPDATED_BY = l_last_updated_by,
LAST_UPDATE_DATE = l_last_update_date,
LAST_UPDATE_LOGIN = l_last_update_login,
SOURCE_LANG = l_lang
where 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   l_lang in (LANGUAGE, SOURCE_LANG);

Line: 8187


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

Line: 8198


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

Line: 8223


rollback to start_update_item;

Line: 8230


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

Line: 8238


rollback to start_update_item;

Line: 8244


rollback to start_update_item;

Line: 8248


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

Line: 8257


end UPDATE_ITEM;

Line: 8282


procedure UPDATE_REGION (
p_validation_level         IN      NUMBER := FND_API.G_VALID_LEVEL_FULL,
p_api_version_number       IN      NUMBER,
p_init_msg_tbl             IN      BOOLEAN := FALSE,
p_msg_count                OUT NOCOPY     NUMBER,
p_msg_data                 OUT NOCOPY     VARCHAR2,
p_return_status            OUT NOCOPY     VARCHAR2,
p_region_application_id    IN      NUMBER,
p_region_code              IN      VARCHAR2,
p_database_object_name     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_region_style             IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_icx_custom_call          IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_num_columns              IN      NUMBER := FND_API.G_MISS_NUM,
p_region_defaulting_api_pkg IN     VARCHAR2 := FND_API.G_MISS_CHAR,
p_region_defaulting_api_proc IN    VARCHAR2 := FND_API.G_MISS_CHAR,
p_region_validation_api_pkg IN     VARCHAR2 := FND_API.G_MISS_CHAR,
p_region_validation_api_proc IN    VARCHAR2 := FND_API.G_MISS_CHAR,
p_appmodule_object_type	 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_num_rows_display		 IN		 NUMBER := FND_API.G_MISS_NUM,
p_region_object_type		 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_image_file_name			 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_isform_flag				 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_help_target				 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_style_sheet_filename	 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
p_version                  IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_applicationmodule_usage_name IN  VARCHAR2 := FND_API.G_MISS_CHAR,
p_add_indexed_children     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_stateful_flag	     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_function_name            IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_children_view_usage_name IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_search_panel	     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_advanced_search_panel    IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_customize_panel	     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_default_search_panel     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_results_based_search     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_display_graph_table	     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_disable_header	     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_standalone		     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_auto_customization_criteria IN   VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute_category       IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute1               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute2               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute3               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute4               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute5               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute6               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute7               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute8               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute9               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute10              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute11              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute12              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute13              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute14              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute15              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_name                     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_description              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_created_by               IN     NUMBER := FND_API.G_MISS_NUM,
p_creation_date            IN      DATE := FND_API.G_MISS_DATE,
p_last_updated_by          IN     NUMBER := FND_API.G_MISS_NUM,
p_last_update_date         IN      DATE := FND_API.G_MISS_DATE,
p_last_update_login        IN     NUMBER := FND_API.G_MISS_NUM,
p_loader_timestamp         IN      DATE := FND_API.G_MISS_DATE,
p_pass                     IN      NUMBER,
p_copy_redo_flag           IN OUT NOCOPY  BOOLEAN
) is
cursor l_get_row_csr is
select *
from  AK_REGIONS
where REGION_APPLICATION_ID = p_region_application_id
and   REGION_CODE = p_region_code
for update of REGION_STYLE;

Line: 8355


select *
from  AK_REGIONS_TL
where REGION_APPLICATION_ID = p_region_application_id
and   REGION_CODE = p_region_code
and   LANGUAGE = lang_parm
for update of NAME;

Line: 8362


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

Line: 8369


l_last_update_date        date;

Line: 8370


l_last_update_login       number;

Line: 8371


l_last_updated_by         number;

Line: 8388


savepoint start_update_region;

Line: 8390


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

Line: 8439


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

Line: 8660


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

Line: 8663


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

Line: 8666


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

Line: 8672


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

update AK_REGIONS set
DATABASE_OBJECT_NAME = l_regions_rec.database_object_name,
REGION_STYLE = l_regions_rec.region_style,
ICX_CUSTOM_CALL = l_regions_rec.icx_custom_call,
NUM_COLUMNS = l_regions_rec.num_columns,
REGION_DEFAULTING_API_PKG = l_regions_rec.region_defaulting_api_pkg,
REGION_DEFAULTING_API_PROC = l_regions_rec.region_defaulting_api_proc,
REGION_VALIDATION_API_PKG = l_regions_rec.region_validation_api_pkg,
REGION_VALIDATION_API_PROC = l_regions_rec.region_validation_api_proc,
APPLICATIONMODULE_OBJECT_TYPE = l_regions_rec.applicationmodule_object_type,
NUM_ROWS_DISPLAY = l_regions_rec.num_rows_display,
REGION_OBJECT_TYPE = l_regions_rec.region_object_type,
IMAGE_FILE_NAME = l_regions_rec.image_file_name,
ISFORM_FLAG = l_regions_rec.isform_flag,
HELP_TARGET = l_regions_rec.help_target,
STYLE_SHEET_FILENAME = l_regions_rec.style_sheet_filename,
VERSION = l_regions_rec.version,
APPLICATIONMODULE_USAGE_NAME = l_regions_rec.applicationmodule_usage_name,
ADD_INDEXED_CHILDREN = l_regions_rec.add_indexed_children,
STATEFUL_FLAG = l_regions_rec.stateful_flag,
FUNCTION_NAME = l_regions_rec.function_name,
CHILDREN_VIEW_USAGE_NAME = l_regions_rec.children_view_usage_name,
SEARCH_PANEL = l_regions_rec.search_panel,
ADVANCED_SEARCH_PANEL = l_regions_rec.advanced_search_panel,
CUSTOMIZE_PANEL = l_regions_rec.customize_panel,
DEFAULT_SEARCH_PANEL = l_regions_rec.default_search_panel,
RESULTS_BASED_SEARCH = l_regions_rec.results_based_search,
DISPLAY_GRAPH_TABLE = l_regions_rec.display_graph_table,
DISABLE_HEADER = l_regions_rec.disable_header,
STANDALONE = l_regions_rec.standalone,
AUTO_CUSTOMIZATION_CRITERIA = l_regions_rec.auto_customization_criteria,
ATTRIBUTE_CATEGORY = l_regions_rec.attribute_category,
ATTRIBUTE1 = l_regions_rec.attribute1,
ATTRIBUTE2 = l_regions_rec.attribute2,
ATTRIBUTE3 = l_regions_rec.attribute3,
ATTRIBUTE4 = l_regions_rec.attribute4,
ATTRIBUTE5 = l_regions_rec.attribute5,
ATTRIBUTE6 = l_regions_rec.attribute6,
ATTRIBUTE7 = l_regions_rec.attribute7,
ATTRIBUTE8 = l_regions_rec.attribute8,
ATTRIBUTE9 = l_regions_rec.attribute9,
ATTRIBUTE10 = l_regions_rec.attribute10,
ATTRIBUTE11 = l_regions_rec.attribute11,
ATTRIBUTE12 = l_regions_rec.attribute12,
ATTRIBUTE13 = l_regions_rec.attribute13,
ATTRIBUTE14 = l_regions_rec.attribute14,
ATTRIBUTE15 = l_regions_rec.attribute15,
LAST_UPDATE_DATE = l_last_update_date,
LAST_UPDATED_BY = l_last_updated_by,
LAST_UPDATE_LOGIN = l_last_update_login
where REGION_APPLICATION_ID = p_region_application_id
and   REGION_CODE = p_region_code;

Line: 8737


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

Line: 8743


update AK_REGIONS_TL set
NAME = l_regions_tl_rec.name,
DESCRIPTION = l_regions_tl_rec.description,
LAST_UPDATE_DATE = l_last_update_date,
LAST_UPDATED_BY = l_last_updated_by,
LAST_UPDATE_LOGIN = l_last_update_login,
SOURCE_LANG = l_lang
where REGION_APPLICATION_ID = p_region_application_id
and   REGION_CODE = p_region_code
and   l_lang in (LANGUAGE, SOURCE_LANG);

Line: 8756


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

Line: 8766


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

Line: 8791


rollback to start_update_region;

Line: 8798


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

Line: 8804


rollback to start_update_region;

Line: 8810


rollback to start_update_region;

Line: 8820


end UPDATE_REGION;

Line: 8855


select distinct nested_region_application_id, nested_region_code
from   AK_REGION_ITEMS
where  region_application_id = region_appl_id_param
and    region_code = region_code_param
and    nested_region_application_id is not null
and    nested_region_code is not null;

Line: 8863


select region_application_id, region_code
from ak_regions_vl
where region_application_id = region_appl_id_param
and region_code = region_code_param
and region_style <> 'TRAIN';

Line: 8881


AK_REGION_PVT.INSERT_REGION_PK_TABLE (
p_return_status => l_return_status,
p_region_application_id =>
l_region_rec.nested_region_application_id,
p_region_code => l_region_rec.nested_region_code,
p_region_pk_tbl => p_region_pk_tbl);