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

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

Line: 3


procedure INSERT_ROW (
X_ROWID in out NOCOPY VARCHAR2,
X_REGION_APPLICATION_ID in NUMBER,
X_REGION_CODE in VARCHAR2,
X_DATABASE_OBJECT_NAME in VARCHAR2,
X_REGION_STYLE in VARCHAR2,
X_NUM_COLUMNS in NUMBER,
X_ICX_CUSTOM_CALL in VARCHAR2,
X_NAME in VARCHAR2,
X_DESCRIPTION in VARCHAR2,
X_REGION_DEFAULTING_API_PKG in VARCHAR2,
X_REGION_DEFAULTING_API_PROC in VARCHAR2,
X_REGION_VALIDATION_API_PKG in VARCHAR2,
X_REGION_VALIDATION_API_PROC in VARCHAR2,
X_APPL_MODULE_OBJECT_TYPE in VARCHAR2,
X_NUM_ROWS_DISPLAY in NUMBER,
X_REGION_OBJECT_TYPE in VARCHAR2,
X_IMAGE_FILE_NAME in VARCHAR2,
X_ISFORM_FLAG in VARCHAR2,
X_HELP_TARGET in VARCHAR2,
X_STYLE_SHEET_FILENAME in VARCHAR2,
X_VERSION in VARCHAR2,
X_APPLICATIONMODULE_USAGE_NAME in VARCHAR2 := NULL,
X_ADD_INDEXED_CHILDREN in VARCHAR2 := NULL,
X_STATEFUL_FLAG in VARCHAR2 := NULL,
X_FUNCTION_NAME in VARCHAR2 := NULL,
X_CHILDREN_VIEW_USAGE_NAME in VARCHAR2 := NULL,
X_SEARCH_PANEL in VARCHAR2 := NULL,
X_ADVANCED_SEARCH_PANEL in VARCHAR2 := NULL,
X_CUSTOMIZE_PANEL in VARCHAR2 := NULL,
X_DEFAULT_SEARCH_PANEL in VARCHAR2 := NULL,
X_RESULTS_BASED_SEARCH in VARCHAR2 := NULL,
X_DISPLAY_GRAPH_TABLE in VARCHAR2 := NULL,
X_DISABLE_HEADER in VARCHAR2 := NULL,
X_STANDALONE in VARCHAR2 := 'Y',
X_AUTO_CUSTOMIZATION_CRITERIA in VARCHAR2 := NULL,
X_CREATION_DATE in DATE,
X_CREATED_BY in NUMBER,
X_LAST_UPDATE_DATE in DATE,
X_LAST_UPDATED_BY in NUMBER,
X_LAST_UPDATE_LOGIN 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
) is
cursor C is select ROWID from AK_REGIONS
where REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
and REGION_CODE = X_REGION_CODE;

Line: 65


insert into AK_REGIONS (
REGION_APPLICATION_ID,
REGION_CODE,
DATABASE_OBJECT_NAME,
REGION_STYLE,
NUM_COLUMNS,
ICX_CUSTOM_CALL,
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,
ISFORM_FLAG,
IMAGE_FILE_NAME,
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,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15
) values (
X_REGION_APPLICATION_ID,
X_REGION_CODE,
X_DATABASE_OBJECT_NAME,
X_REGION_STYLE,
X_NUM_COLUMNS,
X_ICX_CUSTOM_CALL,
X_REGION_DEFAULTING_API_PKG,
X_REGION_DEFAULTING_API_PROC,
X_REGION_VALIDATION_API_PKG,
X_REGION_VALIDATION_API_PROC,
X_APPL_MODULE_OBJECT_TYPE,
X_NUM_ROWS_DISPLAY,
X_REGION_OBJECT_TYPE,
X_ISFORM_FLAG,
X_IMAGE_FILE_NAME,
X_HELP_TARGET,
X_STYLE_SHEET_FILENAME,
X_VERSION,
X_APPLICATIONMODULE_USAGE_NAME,
X_ADD_INDEXED_CHILDREN,
X_STATEFUL_FLAG,
X_FUNCTION_NAME,
X_CHILDREN_VIEW_USAGE_NAME,
X_SEARCH_PANEL,
X_ADVANCED_SEARCH_PANEL,
X_CUSTOMIZE_PANEL,
X_DEFAULT_SEARCH_PANEL,
X_RESULTS_BASED_SEARCH,
X_DISPLAY_GRAPH_TABLE,
X_DISABLE_HEADER,
X_STANDALONE,
X_AUTO_CUSTOMIZATION_CRITERIA,
X_CREATION_DATE,
X_CREATED_BY,
X_LAST_UPDATE_DATE,
X_LAST_UPDATED_BY,
X_LAST_UPDATE_LOGIN,
X_ATTRIBUTE_CATEGORY,
X_ATTRIBUTE1,
X_ATTRIBUTE2,
X_ATTRIBUTE3,
X_ATTRIBUTE4,
X_ATTRIBUTE5,
X_ATTRIBUTE6,
X_ATTRIBUTE7,
X_ATTRIBUTE8,
X_ATTRIBUTE9,
X_ATTRIBUTE10,
X_ATTRIBUTE11,
X_ATTRIBUTE12,
X_ATTRIBUTE13,
X_ATTRIBUTE14,
X_ATTRIBUTE15
);

Line: 183


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
X_REGION_APPLICATION_ID,
X_REGION_CODE,
L.LANGUAGE_CODE,
X_NAME,
X_DESCRIPTION,
userenv('LANG'),
X_CREATED_BY,
X_CREATION_DATE,
X_LAST_UPDATED_BY,
X_LAST_UPDATE_DATE,
X_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 = X_REGION_APPLICATION_ID
and T.REGION_CODE = X_REGION_CODE
and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 215


end INSERT_ROW;

Line: 269


cursor c is select
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
DATABASE_OBJECT_NAME,
REGION_STYLE,
NUM_COLUMNS,
ICX_CUSTOM_CALL,
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,
ISFORM_FLAG,
IMAGE_FILE_NAME,
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_APPLICATION_ID = X_REGION_APPLICATION_ID
and REGION_CODE = X_REGION_CODE
for update of REGION_APPLICATION_ID nowait;

Line: 322


cursor c1 is select
NAME,
DESCRIPTION
from AK_REGIONS_TL
where REGION_CODE = X_REGION_CODE
and REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
and LANGUAGE = userenv('LANG')
for update of REGION_CODE nowait;

Line: 337


fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 504


procedure UPDATE_ROW (
X_REGION_APPLICATION_ID in NUMBER,
X_REGION_CODE in VARCHAR2,
X_DATABASE_OBJECT_NAME in VARCHAR2,
X_REGION_STYLE in VARCHAR2,
X_NUM_COLUMNS in NUMBER,
X_ICX_CUSTOM_CALL in VARCHAR2,
X_NAME in VARCHAR2,
X_DESCRIPTION in VARCHAR2,
X_REGION_DEFAULTING_API_PKG in VARCHAR2,
X_REGION_DEFAULTING_API_PROC in VARCHAR2,
X_REGION_VALIDATION_API_PKG in VARCHAR2,
X_REGION_VALIDATION_API_PROC in VARCHAR2,
X_APPL_MODULE_OBJECT_TYPE in VARCHAR2,
X_NUM_ROWS_DISPLAY in NUMBER,
X_REGION_OBJECT_TYPE in VARCHAR2,
X_IMAGE_FILE_NAME in VARCHAR2,
X_ISFORM_FLAG in VARCHAR2,
X_HELP_TARGET in VARCHAR2,
X_STYLE_SHEET_FILENAME in VARCHAR2,
X_VERSION in VARCHAR2,
X_APPLICATIONMODULE_USAGE_NAME in VARCHAR2 := NULL,
X_ADD_INDEXED_CHILDREN in VARCHAR2 := NULL,
X_STATEFUL_FLAG in VARCHAR2 := NULL,
X_FUNCTION_NAME in VARCHAR2 := NULL,
X_CHILDREN_VIEW_USAGE_NAME in VARCHAR2 := NULL,
X_SEARCH_PANEL in VARCHAR2 := NULL,
X_ADVANCED_SEARCH_PANEL in VARCHAR2 := NULL,
X_CUSTOMIZE_PANEL in VARCHAR2 := NULL,
X_DEFAULT_SEARCH_PANEL in VARCHAR2 := NULL,
X_RESULTS_BASED_SEARCH in VARCHAR2 := NULL,
X_DISPLAY_GRAPH_TABLE in VARCHAR2 := NULL,
X_DISABLE_HEADER in VARCHAR2 := NULL,
X_STANDALONE in VARCHAR2 := 'Y',
X_AUTO_CUSTOMIZATION_CRITERIA in VARCHAR2 := NULL,
X_LAST_UPDATE_DATE in DATE,
X_LAST_UPDATED_BY in NUMBER,
X_LAST_UPDATE_LOGIN 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
) is
begin
update AK_REGIONS set
REGION_APPLICATION_ID = X_REGION_APPLICATION_ID,
REGION_CODE = X_REGION_CODE,
DATABASE_OBJECT_NAME = X_DATABASE_OBJECT_NAME,
REGION_STYLE = X_REGION_STYLE,
NUM_COLUMNS = X_NUM_COLUMNS,
ICX_CUSTOM_CALL = X_ICX_CUSTOM_CALL,
REGION_DEFAULTING_API_PKG = X_REGION_DEFAULTING_API_PKG,
REGION_DEFAULTING_API_PROC = X_REGION_DEFAULTING_API_PROC,
REGION_VALIDATION_API_PKG = X_REGION_VALIDATION_API_PKG,
REGION_VALIDATION_API_PROC = X_REGION_VALIDATION_API_PROC,
APPLICATIONMODULE_OBJECT_TYPE =  X_APPL_MODULE_OBJECT_TYPE,
NUM_ROWS_DISPLAY =  X_NUM_ROWS_DISPLAY,
REGION_OBJECT_TYPE =  X_REGION_OBJECT_TYPE,
ISFORM_FLAG = X_ISFORM_FLAG,
IMAGE_FILE_NAME = X_IMAGE_FILE_NAME,
HELP_TARGET = X_HELP_TARGET,
STYLE_SHEET_FILENAME = X_STYLE_SHEET_FILENAME,
VERSION = X_VERSION,
APPLICATIONMODULE_USAGE_NAME = X_APPLICATIONMODULE_USAGE_NAME,
ADD_INDEXED_CHILDREN = X_ADD_INDEXED_CHILDREN,
STATEFUL_FLAG = X_STATEFUL_FLAG,
FUNCTION_NAME = X_FUNCTION_NAME,
CHILDREN_VIEW_USAGE_NAME = X_CHILDREN_VIEW_USAGE_NAME,
SEARCH_PANEL = X_SEARCH_PANEL,
ADVANCED_SEARCH_PANEL = X_ADVANCED_SEARCH_PANEL,
CUSTOMIZE_PANEL = X_CUSTOMIZE_PANEL,
DEFAULT_SEARCH_PANEL = X_DEFAULT_SEARCH_PANEL,
RESULTS_BASED_SEARCH = X_RESULTS_BASED_SEARCH,
DISPLAY_GRAPH_TABLE = X_DISPLAY_GRAPH_TABLE,
DISABLE_HEADER = X_DISABLE_HEADER,
STANDALONE = X_STANDALONE,
AUTO_CUSTOMIZATION_CRITERIA = X_AUTO_CUSTOMIZATION_CRITERIA,
LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
LAST_UPDATED_BY = X_LAST_UPDATED_BY,
LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
ATTRIBUTE1 = X_ATTRIBUTE1,
ATTRIBUTE2 = X_ATTRIBUTE2,
ATTRIBUTE3 = X_ATTRIBUTE3,
ATTRIBUTE4 = X_ATTRIBUTE4,
ATTRIBUTE5 = X_ATTRIBUTE5,
ATTRIBUTE6 = X_ATTRIBUTE6,
ATTRIBUTE7 = X_ATTRIBUTE7,
ATTRIBUTE8 = X_ATTRIBUTE8,
ATTRIBUTE9 = X_ATTRIBUTE9,
ATTRIBUTE10 = X_ATTRIBUTE10,
ATTRIBUTE11 = X_ATTRIBUTE11,
ATTRIBUTE12 = X_ATTRIBUTE12,
ATTRIBUTE13 = X_ATTRIBUTE13,
ATTRIBUTE14 = X_ATTRIBUTE14,
ATTRIBUTE15 = X_ATTRIBUTE15
where REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
and REGION_CODE = X_REGION_CODE;

Line: 618


update AK_REGIONS_TL set
NAME = X_NAME,
DESCRIPTION = X_DESCRIPTION,
LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
LAST_UPDATED_BY = X_LAST_UPDATED_BY,
LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
SOURCE_LANG = userenv('LANG')
where REGION_CODE = X_REGION_CODE
and REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 631


end UPDATE_ROW;

Line: 633


procedure DELETE_ROW (
X_REGION_APPLICATION_ID in NUMBER,
X_REGION_CODE in VARCHAR2
) is
begin
delete from AK_REGIONS
where REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
and REGION_CODE = X_REGION_CODE;

Line: 646


delete from AK_REGIONS_TL
where REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
and REGION_CODE = X_REGION_CODE;

Line: 653


end DELETE_ROW;

Line: 660


/* The following delete and update statements are commented out */
/* as a quick workaround to fix the time-consuming table handler issue */
/* Eventually we'll need to turn them into a separate fix_language procedure */
/*
delete from AK_REGIONS_TL T
where not exists
(select NULL
from AK_REGIONS B
where B.REGION_CODE = T.REGION_CODE
and B.REGION_APPLICATION_ID = T.REGION_APPLICATION_ID
);

Line: 672


update AK_REGIONS_TL T set (
NAME,
DESCRIPTION
) = (select
B.NAME,
B.DESCRIPTION
from AK_REGIONS_TL B
where B.REGION_CODE = T.REGION_CODE
and B.REGION_APPLICATION_ID = T.REGION_APPLICATION_ID
and B.LANGUAGE = T.SOURCE_LANG)
where (
T.REGION_CODE,
T.REGION_APPLICATION_ID,
T.LANGUAGE
) in (select
SUBT.REGION_CODE,
SUBT.REGION_APPLICATION_ID,
SUBT.LANGUAGE
from AK_REGIONS_TL SUBB, AK_REGIONS_TL SUBT
where SUBB.REGION_CODE = SUBT.REGION_CODE
and SUBB.REGION_APPLICATION_ID = SUBT.REGION_APPLICATION_ID
and SUBB.LANGUAGE = SUBT.SOURCE_LANG
and (SUBB.NAME <> SUBT.NAME
or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
));

Line: 701


insert /*+ append parallel(tt) */ into AK_REGIONS_TL tt (
REGION_APPLICATION_ID,
REGION_CODE,
NAME,
DESCRIPTION,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
LANGUAGE,
SOURCE_LANG
) select /*+ parallel(v) parallel(t) use_nl(t)  */ v.* from
(select /*+ no_merge ordered parallel(b) */
B.REGION_APPLICATION_ID,
B.REGION_CODE,
B.NAME,
B.DESCRIPTION,
B.CREATED_BY,
B.CREATION_DATE,
B.LAST_UPDATED_BY,
B.LAST_UPDATE_DATE,
B.LAST_UPDATE_LOGIN,
L.LANGUAGE_CODE,
B.SOURCE_LANG
from AK_REGIONS_TL B, FND_LANGUAGES L
where L.INSTALLED_FLAG in ('I', 'B')
and B.LANGUAGE = userenv('LANG')
) v, AK_REGIONS_TL t
where T.REGION_CODE(+) = v.REGION_CODE
and T.REGION_APPLICATION_ID(+) = v.REGION_APPLICATION_ID
and T.LANGUAGE(+) = v.LANGUAGE_CODE
and T.REGION_CODE is NULL
and T.REGION_APPLICATION_ID is NULL;