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_CUSTOM_REGION_ITEMS_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_CUSTOMIZATION_APPLICATION_ID in     NUMBER,
X_CUSTOMIZATION_CODE           in     VARCHAR2,
X_REGION_APPLICATION_ID        in     NUMBER,
X_REGION_CODE                  in     VARCHAR2,
X_ATTRIBUTE_APPLICATION_ID     in     NUMBER,
X_ATTRIBUTE_CODE               in     VARCHAR2,
X_PROPERTY_NAME                in     VARCHAR2,
X_PROPERTY_VARCHAR2_VALUE      in     VARCHAR2,
X_PROPERTY_NUMBER_VALUE        in     NUMBER,
X_PROPERTY_DATE_VALUE          in     DATE,
X_CREATED_BY                   in     NUMBER,
X_CREATION_DATE                in     DATE,
X_LAST_UPDATED_BY              in     NUMBER,
X_LAST_UPDATE_DATE             in     DATE,
X_LAST_UPDATE_LOGIN            in     NUMBER
) is
cursor C is select ROWID from AK_CUSTOM_REGION_ITEMS
where CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
and   CUSTOMIZATION_CODE           = X_CUSTOMIZATION_CODE
and   REGION_APPLICATION_ID        = X_REGION_APPLICATION_ID
and   REGION_CODE                  = X_REGION_CODE
and   ATTRIBUTE_APPLICATION_ID     = X_ATTRIBUTE_APPLICATION_ID
and   ATTRIBUTE_CODE               = X_ATTRIBUTE_CODE
and   PROPERTY_NAME                = X_PROPERTY_NAME;

Line: 30


insert into AK_CUSTOM_REGION_ITEMS (
CUSTOMIZATION_APPLICATION_ID,
CUSTOMIZATION_CODE,
REGION_APPLICATION_ID,
REGION_CODE,
ATTRIBUTE_APPLICATION_ID,
ATTRIBUTE_CODE,
PROPERTY_NAME,
PROPERTY_VARCHAR2_VALUE,
PROPERTY_NUMBER_VALUE,
PROPERTY_DATE_VALUE,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN
) values (
X_CUSTOMIZATION_APPLICATION_ID,
X_CUSTOMIZATION_CODE,
X_REGION_APPLICATION_ID,
X_REGION_CODE,
X_ATTRIBUTE_APPLICATION_ID,
X_ATTRIBUTE_CODE,
X_PROPERTY_NAME,
X_PROPERTY_VARCHAR2_VALUE,
X_PROPERTY_NUMBER_VALUE,
X_PROPERTY_DATE_VALUE,
X_CREATED_BY,
X_CREATION_DATE,
X_LAST_UPDATED_BY,
X_LAST_UPDATE_DATE,
X_LAST_UPDATE_LOGIN
);

Line: 72


insert into AK_CUSTOM_REGION_ITEMS_TL (
CUSTOMIZATION_APPLICATION_ID,
CUSTOMIZATION_CODE,
REGION_APPLICATION_ID,
REGION_CODE,
ATTRIBUTE_APPLICATION_ID,
ATTRIBUTE_CODE,
PROPERTY_NAME,
PROPERTY_VARCHAR2_VALUE,
LANGUAGE,
SOURCE_LANG,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN
) select
X_CUSTOMIZATION_APPLICATION_ID,
X_CUSTOMIZATION_CODE,
X_REGION_APPLICATION_ID,
X_REGION_CODE,
X_ATTRIBUTE_APPLICATION_ID,
X_ATTRIBUTE_CODE,
X_PROPERTY_NAME,
X_PROPERTY_VARCHAR2_VALUE,
L.LANGUAGE_CODE,
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_CUSTOM_REGION_ITEMS_TL T
where T.CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
and   T.CUSTOMIZATION_CODE           = X_CUSTOMIZATION_CODE
and   T.REGION_APPLICATION_ID        = X_REGION_APPLICATION_ID
and   T.REGION_CODE                  = X_REGION_CODE
and   T.ATTRIBUTE_APPLICATION_ID     = X_ATTRIBUTE_APPLICATION_ID
and   T.ATTRIBUTE_CODE               = X_ATTRIBUTE_CODE
and   T.PROPERTY_NAME                = X_PROPERTY_NAME
and   T.LANGUAGE                     = L.LANGUAGE_CODE);

Line: 117


end INSERT_ROW;

Line: 132


X_LAST_UPDATED_BY              in     NUMBER,
X_LAST_UPDATE_DATE             in     DATE,
X_LAST_UPDATE_LOGIN            in     NUMBER
) is
cursor C is select
CUSTOMIZATION_APPLICATION_ID,
CUSTOMIZATION_CODE,
REGION_APPLICATION_ID,
REGION_CODE,
ATTRIBUTE_APPLICATION_ID,
ATTRIBUTE_CODE,
PROPERTY_NAME,
PROPERTY_VARCHAR2_VALUE,
PROPERTY_NUMBER_VALUE,
PROPERTY_DATE_VALUE
from AK_CUSTOM_REGION_ITEMS
where CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
and   CUSTOMIZATION_CODE           = X_CUSTOMIZATION_CODE
and   REGION_APPLICATION_ID        = X_REGION_APPLICATION_ID
and   REGION_CODE                  = X_REGION_CODE
and   ATTRIBUTE_APPLICATION_ID     = X_ATTRIBUTE_APPLICATION_ID
and   ATTRIBUTE_CODE               = X_ATTRIBUTE_CODE
and   PROPERTY_NAME                = X_PROPERTY_NAME
for update of CUSTOMIZATION_APPLICATION_ID nowait;

Line: 158


cursor C1 is select
PROPERTY_VARCHAR2_VALUE
from AK_CUSTOM_REGION_ITEMS_TL
where CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
and   CUSTOMIZATION_CODE           = X_CUSTOMIZATION_CODE
and   REGION_APPLICATION_ID        = X_REGION_APPLICATION_ID
and   REGION_CODE                  = X_REGION_CODE
and   ATTRIBUTE_APPLICATION_ID     = X_ATTRIBUTE_APPLICATION_ID
and   ATTRIBUTE_CODE               = X_ATTRIBUTE_CODE
and   PROPERTY_NAME                = X_PROPERTY_NAME
and   LANGUAGE                     = userenv('LANG')
for update of CUSTOMIZATION_CODE nowait;

Line: 176


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

Line: 237


procedure UPDATE_ROW (
X_CUSTOMIZATION_APPLICATION_ID in     NUMBER,
X_CUSTOMIZATION_CODE           in     VARCHAR2,
X_REGION_APPLICATION_ID        in     NUMBER,
X_REGION_CODE                  in     VARCHAR2,
X_ATTRIBUTE_APPLICATION_ID     in     NUMBER,
X_ATTRIBUTE_CODE               in     VARCHAR2,
X_PROPERTY_NAME                in     VARCHAR2,
X_PROPERTY_VARCHAR2_VALUE      in     VARCHAR2,
X_PROPERTY_NUMBER_VALUE        in     NUMBER,
X_PROPERTY_DATE_VALUE          in     DATE,
X_LAST_UPDATED_BY              in     NUMBER,
X_LAST_UPDATE_DATE             in     DATE,
X_LAST_UPDATE_LOGIN            in     NUMBER
) is
begin
update AK_CUSTOM_REGION_ITEMS set
CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID,
CUSTOMIZATION_CODE           = X_CUSTOMIZATION_CODE,
REGION_APPLICATION_ID        = X_REGION_APPLICATION_ID,
REGION_CODE                  = X_REGION_CODE,
ATTRIBUTE_APPLICATION_ID     = X_ATTRIBUTE_APPLICATION_ID,
ATTRIBUTE_CODE               = X_ATTRIBUTE_CODE,
PROPERTY_NAME                = X_PROPERTY_NAME,
PROPERTY_VARCHAR2_VALUE      = X_PROPERTY_VARCHAR2_VALUE,
PROPERTY_NUMBER_VALUE        = X_PROPERTY_NUMBER_VALUE,
PROPERTY_DATE_VALUE          = X_PROPERTY_DATE_VALUE,
LAST_UPDATED_BY              = X_LAST_UPDATED_BY,
LAST_UPDATE_DATE             = X_LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN            = X_LAST_UPDATE_LOGIN
where CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
and   CUSTOMIZATION_CODE           = X_CUSTOMIZATION_CODE
and   REGION_APPLICATION_ID        = X_REGION_APPLICATION_ID
and   REGION_CODE                  = X_REGION_CODE
and   ATTRIBUTE_APPLICATION_ID     = X_ATTRIBUTE_APPLICATION_ID
and   ATTRIBUTE_CODE               = X_ATTRIBUTE_CODE
and   PROPERTY_NAME                = X_PROPERTY_NAME;

Line: 279


update AK_CUSTOM_REGION_ITEMS_TL set
PROPERTY_VARCHAR2_VALUE = X_PROPERTY_VARCHAR2_VALUE,
LAST_UPDATED_BY         = X_LAST_UPDATED_BY,
LAST_UPDATE_DATE        = X_LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN       = X_LAST_UPDATE_LOGIN,
SOURCE_LANG             = userenv('LANG')
where CUSTOMIZATION_APPLICATION_ID =  X_CUSTOMIZATION_APPLICATION_ID
and   CUSTOMIZATION_CODE           =  X_CUSTOMIZATION_CODE
and   REGION_APPLICATION_ID        =  X_REGION_APPLICATION_ID
and   REGION_CODE                  =  X_REGION_CODE
and   ATTRIBUTE_APPLICATION_ID     = X_ATTRIBUTE_APPLICATION_ID
and   ATTRIBUTE_CODE               = X_ATTRIBUTE_CODE
and   PROPERTY_NAME                =  X_PROPERTY_NAME
and   userenv('LANG')              in (LANGUAGE, SOURCE_LANG);

Line: 297


end UPDATE_ROW;

Line: 299


procedure DELETE_ROW (
X_CUSTOMIZATION_APPLICATION_ID in NUMBER,
X_CUSTOMIZATION_CODE           in VARCHAR2,
X_REGION_APPLICATION_ID        in NUMBER,
X_REGION_CODE                  in VARCHAR2,
X_ATTRIBUTE_APPLICATION_ID     in NUMBER,
X_ATTRIBUTE_CODE               in VARCHAR2,
X_PROPERTY_NAME                in VARCHAR2
) is
begin
delete from AK_CUSTOM_REGION_ITEMS
where CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
and   CUSTOMIZATION_CODE           = X_CUSTOMIZATION_CODE
and   REGION_APPLICATION_ID        = X_REGION_APPLICATION_ID
and   REGION_CODE                  = X_REGION_CODE
and   ATTRIBUTE_APPLICATION_ID     = X_ATTRIBUTE_APPLICATION_ID
and   ATTRIBUTE_CODE               = X_ATTRIBUTE_CODE
and   PROPERTY_NAME                = X_PROPERTY_NAME;

Line: 322


delete from AK_CUSTOM_REGION_ITEMS_TL
where CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
and   CUSTOMIZATION_CODE           = X_CUSTOMIZATION_CODE
and   REGION_APPLICATION_ID        = X_REGION_APPLICATION_ID
and   REGION_CODE                  = X_REGION_CODE
and   ATTRIBUTE_APPLICATION_ID     = X_ATTRIBUTE_APPLICATION_ID
and   ATTRIBUTE_CODE               = X_ATTRIBUTE_CODE
and   PROPERTY_NAME                = X_PROPERTY_NAME;

Line: 334


end DELETE_ROW;

Line: 341


/* 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_CUSTOM_REGION_ITEMS_TL T
where not exists
(select NULL
from AK_CUSTOM_REGION_ITEMS B
where B.CUSTOMIZATION_APPLICATION_ID = T.CUSTOMIZATION_APPLICATION_ID
and   B.CUSTOMIZATION_CODE           = T.CUSTOMIZATION_CODE
and   B.REGION_APPLICATION_ID        = T.REGION_APPLICATION_ID
and   B.REGION_CODE                  = T.REGION_CODE
and   B.ATTRIBUTE_APPLICATION_ID     = T.ATTRIBUTE_APPLICATION_ID
and   B.ATTRIBUTE_CODE               = T.ATTRIBUTE_CODE
and   B.PROPERTY_NAME                = T.PROPERTY_NAME
);

Line: 358


update AK_CUSTOM_REGION_ITEMS_TL T set (
PROPERTY_VARCHAR2_VALUE
) = (select
B.PROPERTY_VARCHAR2_VALUE
from AK_CUSTOM_REGION_ITEMS_TL B
where B.CUSTOMIZATION_APPLICATION_ID = T.CUSTOMIZATION_APPLICATION_ID
and   B.CUSTOMIZATION_CODE           = T.CUSTOMIZATION_CODE
and   B.REGION_APPLICATION_ID        = T.REGION_APPLICATION_ID
and   B.REGION_CODE                  = T.REGION_CODE
and   B.ATTRIBUTE_APPLICATION_ID     = T.ATTRIBUTE_APPLICATION_ID
and   B.ATTRIBUTE_CODE               = T.ATTRIBUTE_CODE
and   B.PROPERTY_NAME                = T.PROPERTY_NAME
and   B.LANGUAGE                     = T.SOURCE_LANG)
where (
T.CUSTOMIZATION_APPLICATION_ID,
T.CUSTOMIZATION_CODE,
T.REGION_APPLICATION_ID,
T.REGION_CODE,
T.ATTRIBUTE_APPLICATION_ID,
T.ATTRIBUTE_CODE,
T.PROPERTY_NAME,
T.LANGUAGE
) in (select SUBT.CUSTOMIZATION_APPLICATION_ID,
SUBT.CUSTOMIZATION_CODE,
SUBT.REGION_APPLICATION_ID,
SUBT.REGION_CODE,
SUBT.ATTRIBUTE_APPLICATION_ID,
SUBT.ATTRIBUTE_CODE,
SUBT.PROPERTY_NAME,
SUBT.LANGUAGE
from AK_CUSTOM_REGION_ITEMS_TL SUBB,
AK_CUSTOM_REGION_ITEMS_TL SUBT
where SUBB.CUSTOMIZATION_APPLICATION_ID = SUBT.CUSTOMIZATION_APPLICATION_ID
and   SUBB.CUSTOMIZATION_CODE           = SUBT.CUSTOMIZATION_CODE
and   SUBB.REGION_APPLICATION_ID        = SUBT.REGION_APPLICATION_ID
and   SUBB.REGION_CODE                  = SUBT.REGION_CODE
and   SUBB.ATTRIBUTE_APPLICATION_ID     = SUBT.ATTRIBUTE_APPLICATION_ID
and   SUBB.ATTRIBUTE_CODE               = SUBT.ATTRIBUTE_CODE
and   SUBB.PROPERTY_NAME                = SUBT.PROPERTY_NAME
and   SUBB.LANGUAGE                     = SUBT.SOURCE_LANG
and   (SUBB.PROPERTY_VARCHAR2_VALUE <> SUBT.PROPERTY_VARCHAR2_VALUE
or (SUBB.PROPERTY_VARCHAR2_VALUE is null and SUBT.PROPERTY_VARCHAR2_VALUE is not null)
or (SUBB.PROPERTY_VARCHAR2_VALUE is not null and SUBT.PROPERTY_VARCHAR2_VALUE is null))
);

Line: 404


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