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

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

Line: 4


procedure INSERT_ROW (
X_ROWID in out NOCOPY VARCHAR2,
X_ATTRIBUTE_APPLICATION_ID in NUMBER,
X_ATTRIBUTE_CODE in VARCHAR2,
X_ATTRIBUTE_LABEL_LENGTH in NUMBER,
X_ATTRIBUTE_VALUE_LENGTH in NUMBER,
X_BOLD in VARCHAR2,
X_ITALIC in VARCHAR2,
X_UPPER_CASE_FLAG in VARCHAR2,
X_VERTICAL_ALIGNMENT in VARCHAR2,
X_HORIZONTAL_ALIGNMENT in VARCHAR2,
X_DEFAULT_VALUE_VARCHAR2 in VARCHAR2,
X_DEFAULT_VALUE_NUMBER in NUMBER,
X_DEFAULT_VALUE_DATE in DATE,
X_LOV_REGION_CODE in VARCHAR2,
X_LOV_REGION_APPLICATION_ID in NUMBER,
X_DATA_TYPE in VARCHAR2,
X_DISPLAY_HEIGHT IN NUMBER,
X_ITEM_STYLE in VARCHAR2,
X_CSS_CLASS_NAME IN VARCHAR2,
X_CSS_LABEL_CLASS_NAME IN VARCHAR2,
X_PRECISION IN NUMBER := NULL,
X_EXPANSION IN NUMBER := NULL,
X_ALS_MAX_LENGTH IN NUMBER := NULL,
X_POPLIST_VIEWOBJECT IN VARCHAR2,
X_POPLIST_DISPLAY_ATTRIBUTE IN VARCHAR2,
X_POPLIST_VALUE_ATTRIBUTE IN VARCHAR2,
X_ATTRIBUTE_CATEGORY in VARCHAR2,
X_ATTRIBUTE1 in VARCHAR2,
X_ATTRIBUTE2 in VARCHAR2,
X_ATTRIBUTE3 in VARCHAR2,
X_ATTRIBUTE4 in VARCHAR2,
X_ATTRIBUTE5 in VARCHAR2,
X_ATTRIBUTE6 in VARCHAR2,
X_ATTRIBUTE7 in VARCHAR2,
X_ATTRIBUTE8 in VARCHAR2,
X_ATTRIBUTE9 in VARCHAR2,
X_ATTRIBUTE10 in VARCHAR2,
X_ATTRIBUTE11 in VARCHAR2,
X_ATTRIBUTE12 in VARCHAR2,
X_ATTRIBUTE13 in VARCHAR2,
X_ATTRIBUTE14 in VARCHAR2,
X_ATTRIBUTE15 in VARCHAR2,
X_NAME in VARCHAR2,
X_ATTRIBUTE_LABEL_LONG in VARCHAR2,
X_ATTRIBUTE_LABEL_SHORT in VARCHAR2 := NULL,
X_DESCRIPTION in VARCHAR2,
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
) is
cursor C is select ROWID from AK_ATTRIBUTES
where ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;

Line: 62


insert into AK_ATTRIBUTES (
ATTRIBUTE_APPLICATION_ID,
ATTRIBUTE_CODE,
ATTRIBUTE_LABEL_LENGTH,
ATTRIBUTE_VALUE_LENGTH,
BOLD,
ITALIC,
UPPER_CASE_FLAG,
VERTICAL_ALIGNMENT,
HORIZONTAL_ALIGNMENT,
DEFAULT_VALUE_VARCHAR2,
DEFAULT_VALUE_NUMBER,
DEFAULT_VALUE_DATE,
LOV_REGION_CODE,
LOV_REGION_APPLICATION_ID,
DATA_TYPE,
DISPLAY_HEIGHT,
ITEM_STYLE,
CSS_CLASS_NAME,
CSS_LABEL_CLASS_NAME,
PRECISION,
EXPANSION,
ALS_MAX_LENGTH,
POPLIST_VIEWOBJECT,
POPLIST_DISPLAY_ATTRIBUTE,
POPLIST_VALUE_ATTRIBUTE,
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 (
X_ATTRIBUTE_APPLICATION_ID,
X_ATTRIBUTE_CODE,
X_ATTRIBUTE_LABEL_LENGTH,
X_ATTRIBUTE_VALUE_LENGTH,
X_BOLD,
X_ITALIC,
X_UPPER_CASE_FLAG,
X_VERTICAL_ALIGNMENT,
X_HORIZONTAL_ALIGNMENT,
X_DEFAULT_VALUE_VARCHAR2,
X_DEFAULT_VALUE_NUMBER,
X_DEFAULT_VALUE_DATE,
X_LOV_REGION_CODE,
X_LOV_REGION_APPLICATION_ID,
X_DATA_TYPE,
X_DISPLAY_HEIGHT,
X_ITEM_STYLE,
X_CSS_CLASS_NAME,
X_CSS_LABEL_CLASS_NAME,
X_PRECISION,
X_EXPANSION,
X_ALS_MAX_LENGTH,
X_POPLIST_VIEWOBJECT,
X_POPLIST_DISPLAY_ATTRIBUTE,
X_POPLIST_VALUE_ATTRIBUTE,
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,
X_CREATION_DATE,
X_CREATED_BY,
X_LAST_UPDATE_DATE,
X_LAST_UPDATED_BY,
X_LAST_UPDATE_LOGIN
);

Line: 166


insert into AK_ATTRIBUTES_TL (
ATTRIBUTE_APPLICATION_ID,
ATTRIBUTE_CODE,
LANGUAGE,
NAME,
ATTRIBUTE_LABEL_LONG,
ATTRIBUTE_LABEL_SHORT,
DESCRIPTION,
SOURCE_LANG,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN
) select
X_ATTRIBUTE_APPLICATION_ID,
X_ATTRIBUTE_CODE,
L.LANGUAGE_CODE,
X_NAME,
X_ATTRIBUTE_LABEL_LONG,
X_ATTRIBUTE_LABEL_SHORT,
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_ATTRIBUTES_TL T
where T.ATTRIBUTE_CODE = X_ATTRIBUTE_CODE
and T.ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 202


end INSERT_ROW;

Line: 251


cursor c is select
ATTRIBUTE_LABEL_LENGTH,
ATTRIBUTE_VALUE_LENGTH,
BOLD,
ITALIC,
UPPER_CASE_FLAG,
VERTICAL_ALIGNMENT,
HORIZONTAL_ALIGNMENT,
DEFAULT_VALUE_VARCHAR2,
DEFAULT_VALUE_NUMBER,
DEFAULT_VALUE_DATE,
LOV_REGION_CODE,
LOV_REGION_APPLICATION_ID,
DATA_TYPE,
DISPLAY_HEIGHT,
ITEM_STYLE,
CSS_CLASS_NAME,
CSS_LABEL_CLASS_NAME,
PRECISION,
EXPANSION,
ALS_MAX_LENGTH,
POPLIST_VIEWOBJECT,
POPLIST_DISPLAY_ATTRIBUTE,
POPLIST_VALUE_ATTRIBUTE,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15
from AK_ATTRIBUTES
where ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE
for update of ATTRIBUTE_APPLICATION_ID nowait;

Line: 297


cursor c1 is select
NAME,
ATTRIBUTE_LABEL_LONG,
ATTRIBUTE_LABEL_SHORT,
DESCRIPTION
from AK_ATTRIBUTES_TL
where ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE
and LANGUAGE = userenv('LANG')
for update of ATTRIBUTE_CODE nowait;

Line: 314


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

Line: 459


procedure UPDATE_ROW (
X_ATTRIBUTE_APPLICATION_ID in NUMBER,
X_ATTRIBUTE_CODE in VARCHAR2,
X_ATTRIBUTE_LABEL_LENGTH in NUMBER,
X_ATTRIBUTE_VALUE_LENGTH in NUMBER,
X_BOLD in VARCHAR2,
X_ITALIC in VARCHAR2,
X_UPPER_CASE_FLAG in VARCHAR2,
X_VERTICAL_ALIGNMENT in VARCHAR2,
X_HORIZONTAL_ALIGNMENT in VARCHAR2,
X_DEFAULT_VALUE_VARCHAR2 in VARCHAR2,
X_DEFAULT_VALUE_NUMBER in NUMBER,
X_DEFAULT_VALUE_DATE in DATE,
X_LOV_REGION_CODE in VARCHAR2,
X_LOV_REGION_APPLICATION_ID in NUMBER,
X_DATA_TYPE in VARCHAR2,
X_DISPLAY_HEIGHT IN NUMBER,
X_ITEM_STYLE in VARCHAR2,
X_CSS_CLASS_NAME IN VARCHAR2,
X_CSS_LABEL_CLASS_NAME IN VARCHAR2,
X_PRECISION IN NUMBER := NULL,
X_EXPANSION IN NUMBER := NULL,
X_ALS_MAX_LENGTH IN NUMBER := NULL,
X_POPLIST_VIEWOBJECT IN VARCHAR2,
X_POPLIST_DISPLAY_ATTRIBUTE IN VARCHAR2,
X_POPLIST_VALUE_ATTRIBUTE IN VARCHAR2,
X_ATTRIBUTE_CATEGORY in VARCHAR2,
X_ATTRIBUTE1 in VARCHAR2,
X_ATTRIBUTE2 in VARCHAR2,
X_ATTRIBUTE3 in VARCHAR2,
X_ATTRIBUTE4 in VARCHAR2,
X_ATTRIBUTE5 in VARCHAR2,
X_ATTRIBUTE6 in VARCHAR2,
X_ATTRIBUTE7 in VARCHAR2,
X_ATTRIBUTE8 in VARCHAR2,
X_ATTRIBUTE9 in VARCHAR2,
X_ATTRIBUTE10 in VARCHAR2,
X_ATTRIBUTE11 in VARCHAR2,
X_ATTRIBUTE12 in VARCHAR2,
X_ATTRIBUTE13 in VARCHAR2,
X_ATTRIBUTE14 in VARCHAR2,
X_ATTRIBUTE15 in VARCHAR2,
X_NAME in VARCHAR2,
X_ATTRIBUTE_LABEL_LONG in VARCHAR2,
X_ATTRIBUTE_LABEL_SHORT in VARCHAR2 := NULL,
X_DESCRIPTION in VARCHAR2,
X_LAST_UPDATE_DATE in DATE,
X_LAST_UPDATED_BY in NUMBER,
X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
update AK_ATTRIBUTES set
ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID,
ATTRIBUTE_CODE = X_ATTRIBUTE_CODE,
ATTRIBUTE_LABEL_LENGTH = X_ATTRIBUTE_LABEL_LENGTH,
ATTRIBUTE_VALUE_LENGTH = X_ATTRIBUTE_VALUE_LENGTH,
BOLD = X_BOLD,
ITALIC = X_ITALIC,
UPPER_CASE_FLAG = X_UPPER_CASE_FLAG,
VERTICAL_ALIGNMENT = X_VERTICAL_ALIGNMENT,
HORIZONTAL_ALIGNMENT = X_HORIZONTAL_ALIGNMENT,
DEFAULT_VALUE_VARCHAR2 = X_DEFAULT_VALUE_VARCHAR2,
DEFAULT_VALUE_NUMBER = X_DEFAULT_VALUE_NUMBER,
DEFAULT_VALUE_DATE = X_DEFAULT_VALUE_DATE,
LOV_REGION_CODE = X_LOV_REGION_CODE,
LOV_REGION_APPLICATION_ID = X_LOV_REGION_APPLICATION_ID,
DATA_TYPE = X_DATA_TYPE,
DISPLAY_HEIGHT = X_DISPLAY_HEIGHT,
ITEM_STYLE = X_ITEM_STYLE,
CSS_CLASS_NAME = X_CSS_CLASS_NAME,
CSS_LABEL_CLASS_NAME = X_CSS_LABEL_CLASS_NAME,
PRECISION = X_PRECISION,
EXPANSION = X_EXPANSION,
ALS_MAX_LENGTH = X_ALS_MAX_LENGTH,
POPLIST_VIEWOBJECT = X_POPLIST_VIEWOBJECT,
POPLIST_DISPLAY_ATTRIBUTE = X_POPLIST_DISPLAY_ATTRIBUTE,
POPLIST_VALUE_ATTRIBUTE = X_POPLIST_VALUE_ATTRIBUTE,
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,
LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
LAST_UPDATED_BY = X_LAST_UPDATED_BY,
LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
where ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;

Line: 561


update AK_ATTRIBUTES_TL set
NAME = X_NAME,
ATTRIBUTE_LABEL_LONG = X_ATTRIBUTE_LABEL_LONG,
ATTRIBUTE_LABEL_SHORT = X_ATTRIBUTE_LABEL_SHORT,
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 ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE
and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 577


end UPDATE_ROW;

Line: 579


procedure DELETE_ROW (
X_ATTRIBUTE_APPLICATION_ID in NUMBER,
X_ATTRIBUTE_CODE in VARCHAR2
) is
begin
delete from AK_ATTRIBUTES
where ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;

Line: 592


delete from AK_OBJECT_ATTRIBUTES
where ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;

Line: 599


delete from AK_ATTRIBUTES_TL
where ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;

Line: 605


end DELETE_ROW;

Line: 612


/* 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_ATTRIBUTES_TL T
where not exists
(select NULL
from AK_ATTRIBUTES B
where B.ATTRIBUTE_CODE = T.ATTRIBUTE_CODE
and B.ATTRIBUTE_APPLICATION_ID = T.ATTRIBUTE_APPLICATION_ID
);

Line: 625


update AK_ATTRIBUTES_TL T set (
NAME,
ATTRIBUTE_LABEL_LONG,
ATTRIBUTE_LABEL_SHORT,
DESCRIPTION
) = (select
B.NAME,
B.ATTRIBUTE_LABEL_LONG,
B.ATTRIBUTE_LABEL_SHORT,
B.DESCRIPTION
from AK_ATTRIBUTES_TL B
where B.ATTRIBUTE_CODE = T.ATTRIBUTE_CODE
and B.ATTRIBUTE_APPLICATION_ID = T.ATTRIBUTE_APPLICATION_ID
and B.LANGUAGE = T.SOURCE_LANG)
where (
T.ATTRIBUTE_CODE,
T.ATTRIBUTE_APPLICATION_ID,
T.LANGUAGE
) in (select
SUBT.ATTRIBUTE_CODE,
SUBT.ATTRIBUTE_APPLICATION_ID,
SUBT.LANGUAGE
from AK_ATTRIBUTES_TL SUBB, AK_ATTRIBUTES_TL SUBT
where SUBB.ATTRIBUTE_CODE = SUBT.ATTRIBUTE_CODE
and SUBB.ATTRIBUTE_APPLICATION_ID = SUBT.ATTRIBUTE_APPLICATION_ID
and SUBB.LANGUAGE = SUBT.SOURCE_LANG
and (SUBB.NAME <> SUBT.NAME
or SUBB.ATTRIBUTE_LABEL_LONG <> SUBT.ATTRIBUTE_LABEL_LONG
or (SUBB.ATTRIBUTE_LABEL_LONG is null and SUBT.ATTRIBUTE_LABEL_LONG is not null)
or (SUBB.ATTRIBUTE_LABEL_LONG is not null and SUBT.ATTRIBUTE_LABEL_LONG is null)
or SUBB.ATTRIBUTE_LABEL_SHORT <> SUBT.ATTRIBUTE_LABEL_SHORT
or (SUBB.ATTRIBUTE_LABEL_SHORT is null and SUBT.ATTRIBUTE_LABEL_SHORT is not null)
or (SUBB.ATTRIBUTE_LABEL_SHORT is not null and SUBT.ATTRIBUTE_LABEL_SHORT is null)
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: 664


insert /*+ append parallel(tt) */ into AK_ATTRIBUTES_TL tt (
ATTRIBUTE_APPLICATION_ID,
ATTRIBUTE_CODE,
NAME,
ATTRIBUTE_LABEL_LONG,
ATTRIBUTE_LABEL_SHORT,
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.ATTRIBUTE_APPLICATION_ID,
B.ATTRIBUTE_CODE,
B.NAME,
B.ATTRIBUTE_LABEL_LONG,
B.ATTRIBUTE_LABEL_SHORT,
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_ATTRIBUTES_TL B, FND_LANGUAGES L
where L.INSTALLED_FLAG in ('I', 'B')
and B.LANGUAGE = userenv('LANG')
) v, AK_ATTRIBUTES_TL t
where T.ATTRIBUTE_CODE(+) = v.ATTRIBUTE_CODE
and T.ATTRIBUTE_APPLICATION_ID(+) = v.ATTRIBUTE_APPLICATION_ID
and T.LANGUAGE(+) = v.LANGUAGE_CODE
and T.ATTRIBUTE_CODE is NULL
and T.ATTRIBUTE_APPLICATION_ID is NULL;