The following lines contain the word 'select', 'insert', 'update' or 'delete':
X_LAST_UPDATE_DATE in VARCHAR2 DEFAULT NULL
) AS
l_user_id number := fnd_load_util.owner_id(x_owner);
f_ludate date; -- entity update date in file
db_ludate date; -- entity update date in db
f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
select LAST_UPDATED_BY, LAST_UPDATE_DATE
into db_luby, db_ludate
FROM JTF_AMV_ITEMS_B
where ITEM_ID = X_ITEM_ID;
UPDATE_ROW (
X_ITEM_ID => l_ITEM_ID,
X_OBJECT_VERSION_NUMBER => l_OBJECT_VERSION_NUMBER,
X_LAST_UPDATE_DATE => f_ludate,
X_LAST_UPDATED_BY => f_luby,
X_LAST_UPDATE_LOGIN => l_user_id,
X_APPLICATION_ID => l_APPLICATION_ID,
X_EXTERNAL_ACCESS_FLAG => X_EXTERNAL_ACCESS_FLAG,
X_ITEM_NAME => X_ITEM_NAME,
X_DESCRIPTION => X_DESCRIPTION,
X_TEXT_STRING => X_TEXT_STRING,
X_LANGUAGE_CODE => X_LANGUAGE_CODE,
X_STATUS_CODE => X_STATUS_CODE,
X_EFFECTIVE_START_DATE => l_EFFECTIVE_START_DATE,
X_EXPIRATION_DATE => l_EXPIRATION_DATE,
X_ITEM_TYPE => X_ITEM_TYPE,
X_URL_STRING => X_URL_STRING,
X_PUBLICATION_DATE => l_PUBLICATION_DATE,
X_PRIORITY => X_PRIORITY,
X_CONTENT_TYPE_ID => l_CONTENT_TYPE_ID,
X_OWNER_ID => l_OWNER_ID,
X_DEFAULT_APPROVER_ID => l_DEFAULT_APPROVER_ID,
X_ITEM_DESTINATION_TYPE => X_ITEM_DESTINATION_TYPE,
X_ACCESS_NAME => X_ACCESS_NAME,
X_DELIVERABLE_TYPE_CODE => X_DELIVERABLE_TYPE_CODE,
X_APPLICABLE_TO_CODE => X_APPLICABLE_TO_CODE,
X_ATTRIBUTE_CATEGORY => X_ATTRIBUTE_CATEGORY,
X_ATTRIBUTE1 => X_ATTRIBUTE1,
X_ATTRIBUTE2 => X_ATTRIBUTE2,
X_ATTRIBUTE3 => X_ATTRIBUTE3,
X_ATTRIBUTE4 => X_ATTRIBUTE4,
X_ATTRIBUTE5 => X_ATTRIBUTE5,
X_ATTRIBUTE6 => X_ATTRIBUTE6,
X_ATTRIBUTE7 => X_ATTRIBUTE7,
X_ATTRIBUTE8 => X_ATTRIBUTE8,
X_ATTRIBUTE9 => X_ATTRIBUTE9,
X_ATTRIBUTE10 => X_ATTRIBUTE10,
X_ATTRIBUTE11 => X_ATTRIBUTE11,
X_ATTRIBUTE12 => X_ATTRIBUTE12,
X_ATTRIBUTE13 => X_ATTRIBUTE13,
X_ATTRIBUTE14 => X_ATTRIBUTE14,
X_ATTRIBUTE15 => X_ATTRIBUTE15
);
INSERT_ROW (
X_ROWID => l_row_id,
X_ITEM_ID => l_ITEM_ID,
X_OBJECT_VERSION_NUMBER => l_OBJECT_VERSION_NUMBER,
X_CREATION_DATE => f_ludate,
X_CREATED_BY => f_luby,
X_LAST_UPDATE_DATE => f_ludate,
X_LAST_UPDATED_BY => f_luby,
X_LAST_UPDATE_LOGIN => l_user_id,
X_APPLICATION_ID => l_APPLICATION_ID,
X_EXTERNAL_ACCESS_FLAG => X_EXTERNAL_ACCESS_FLAG,
X_ITEM_NAME => X_ITEM_NAME,
X_DESCRIPTION => X_DESCRIPTION,
X_TEXT_STRING => X_TEXT_STRING,
X_LANGUAGE_CODE => X_LANGUAGE_CODE,
X_STATUS_CODE => X_STATUS_CODE,
X_EFFECTIVE_START_DATE => l_EFFECTIVE_START_DATE,
X_EXPIRATION_DATE => l_EXPIRATION_DATE,
X_ITEM_TYPE => X_ITEM_TYPE,
X_URL_STRING => X_URL_STRING,
X_PUBLICATION_DATE => l_PUBLICATION_DATE,
X_PRIORITY => X_PRIORITY,
X_CONTENT_TYPE_ID => l_CONTENT_TYPE_ID,
X_OWNER_ID => l_OWNER_ID,
X_DEFAULT_APPROVER_ID => l_DEFAULT_APPROVER_ID,
X_ITEM_DESTINATION_TYPE => X_ITEM_DESTINATION_TYPE,
X_ACCESS_NAME => X_ACCESS_NAME,
X_DELIVERABLE_TYPE_CODE => X_DELIVERABLE_TYPE_CODE,
X_APPLICABLE_TO_CODE => X_APPLICABLE_TO_CODE,
X_ATTRIBUTE_CATEGORY => X_ATTRIBUTE_CATEGORY,
X_ATTRIBUTE1 => X_ATTRIBUTE1,
X_ATTRIBUTE2 => X_ATTRIBUTE2,
X_ATTRIBUTE3 => X_ATTRIBUTE3,
X_ATTRIBUTE4 => X_ATTRIBUTE4,
X_ATTRIBUTE5 => X_ATTRIBUTE5,
X_ATTRIBUTE6 => X_ATTRIBUTE6,
X_ATTRIBUTE7 => X_ATTRIBUTE7,
X_ATTRIBUTE8 => X_ATTRIBUTE8,
X_ATTRIBUTE9 => X_ATTRIBUTE9,
X_ATTRIBUTE10 => X_ATTRIBUTE10,
X_ATTRIBUTE11 => X_ATTRIBUTE11,
X_ATTRIBUTE12 => X_ATTRIBUTE12,
X_ATTRIBUTE13 => X_ATTRIBUTE13,
X_ATTRIBUTE14 => X_ATTRIBUTE14,
X_ATTRIBUTE15 => X_ATTRIBUTE15
);
X_LAST_UPDATE_DATE in VARCHAR2 DEFAULT NULL
) AS
f_luby number; -- entity owner in file
f_ludate date; -- entity update date in file
db_ludate date; -- entity update date in db
f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
select LAST_UPDATED_BY, LAST_UPDATE_DATE
into db_luby, db_ludate
from JTF_AMV_ITEMS_TL
where userenv('LANG') in (LANGUAGE, SOURCE_LANG)
and ITEM_ID = X_ITEM_ID;
update JTF_AMV_ITEMS_TL set
ITEM_NAME = X_ITEM_NAME,
DESCRIPTION = x_description,
TEXT_STRING = X_TEXT_STRING,
LAST_UPDATE_DATE = f_ludate,
LAST_UPDATED_BY = f_luby,
LAST_UPDATE_LOGIN = 0,
SOURCE_LANG = userenv('LANG')
where userenv('LANG') in (LANGUAGE, SOURCE_LANG)
and ITEM_ID = X_ITEM_ID;
procedure INSERT_ROW (
X_ROWID in out NOCOPY VARCHAR2,
X_ITEM_ID in NUMBER,
X_OBJECT_VERSION_NUMBER in NUMBER,
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_APPLICATION_ID in NUMBER,
X_EXTERNAL_ACCESS_FLAG in VARCHAR2,
X_ITEM_NAME in VARCHAR2,
X_DESCRIPTION in VARCHAR2,
X_TEXT_STRING in VARCHAR2,
X_LANGUAGE_CODE in VARCHAR2,
X_STATUS_CODE in VARCHAR2,
X_EFFECTIVE_START_DATE in DATE,
X_EXPIRATION_DATE in DATE,
X_ITEM_TYPE in VARCHAR2,
X_URL_STRING in VARCHAR2,
X_PUBLICATION_DATE in DATE,
X_PRIORITY in VARCHAR2,
X_CONTENT_TYPE_ID in NUMBER,
X_OWNER_ID in NUMBER,
X_DEFAULT_APPROVER_ID in NUMBER,
X_ITEM_DESTINATION_TYPE in VARCHAR2,
X_ACCESS_NAME in VARCHAR2,
X_DELIVERABLE_TYPE_CODE in VARCHAR2,
X_APPLICABLE_TO_CODE in VARCHAR2,
X_ATTRIBUTE_CATEGORY in VARCHAR2,
X_ATTRIBUTE1 in VARCHAR2,
X_ATTRIBUTE2 in VARCHAR2,
X_ATTRIBUTE3 in VARCHAR2,
X_ATTRIBUTE4 in VARCHAR2,
X_ATTRIBUTE5 in VARCHAR2,
X_ATTRIBUTE6 in VARCHAR2,
X_ATTRIBUTE7 in VARCHAR2,
X_ATTRIBUTE8 in VARCHAR2,
X_ATTRIBUTE9 in VARCHAR2,
X_ATTRIBUTE10 in VARCHAR2,
X_ATTRIBUTE11 in VARCHAR2,
X_ATTRIBUTE12 in VARCHAR2,
X_ATTRIBUTE13 in VARCHAR2,
X_ATTRIBUTE14 in VARCHAR2,
X_ATTRIBUTE15 in VARCHAR2
) is
cursor C is select ROWID from JTF_AMV_ITEMS_B
where ITEM_ID = X_ITEM_ID
;
insert into JTF_AMV_ITEMS_B (
ITEM_ID,
EXTERNAL_ACCESS_FLAG,
PUBLICATION_DATE,
OBJECT_VERSION_NUMBER,
LANGUAGE_CODE,
APPLICATION_ID,
STATUS_CODE,
EFFECTIVE_START_DATE,
EXPIRATION_DATE,
ITEM_TYPE,
URL_STRING,
ATTRIBUTE14,
CONTENT_TYPE_ID,
OWNER_ID,
DEFAULT_APPROVER_ID,
ITEM_DESTINATION_TYPE,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE15,
PRIORITY,
ACCESS_NAME,
DELIVERABLE_TYPE_CODE,
APPLICABLE_TO_CODE,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN
) values (
X_ITEM_ID,
X_EXTERNAL_ACCESS_FLAG,
X_PUBLICATION_DATE,
X_OBJECT_VERSION_NUMBER,
X_LANGUAGE_CODE,
X_APPLICATION_ID,
X_STATUS_CODE,
X_EFFECTIVE_START_DATE,
X_EXPIRATION_DATE,
X_ITEM_TYPE,
X_URL_STRING,
X_ATTRIBUTE14,
X_CONTENT_TYPE_ID,
X_OWNER_ID,
X_DEFAULT_APPROVER_ID,
X_ITEM_DESTINATION_TYPE,
X_ATTRIBUTE_CATEGORY,
X_ATTRIBUTE1,
X_ATTRIBUTE2,
X_ATTRIBUTE3,
X_ATTRIBUTE4,
X_ATTRIBUTE5,
X_ATTRIBUTE6,
X_ATTRIBUTE7,
X_ATTRIBUTE15,
X_PRIORITY,
X_ACCESS_NAME,
X_DELIVERABLE_TYPE_CODE,
X_APPLICABLE_TO_CODE,
X_ATTRIBUTE8,
X_ATTRIBUTE9,
X_ATTRIBUTE10,
X_ATTRIBUTE11,
X_ATTRIBUTE12,
X_ATTRIBUTE13,
X_CREATION_DATE,
X_CREATED_BY,
X_LAST_UPDATE_DATE,
X_LAST_UPDATED_BY,
X_LAST_UPDATE_LOGIN
);
insert into JTF_AMV_ITEMS_TL (
ITEM_ID,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN,
ITEM_NAME,
DESCRIPTION,
TEXT_STRING,
LANGUAGE,
SOURCE_LANG
) select
X_ITEM_ID,
X_LAST_UPDATE_DATE,
X_LAST_UPDATED_BY,
X_CREATION_DATE,
X_CREATED_BY,
X_LAST_UPDATE_LOGIN,
X_ITEM_NAME,
X_DESCRIPTION,
X_TEXT_STRING,
L.LANGUAGE_CODE,
userenv('LANG')
from FND_LANGUAGES L
where L.INSTALLED_FLAG in ('I', 'B')
and not exists
(select NULL
from JTF_AMV_ITEMS_TL T
where T.ITEM_ID = X_ITEM_ID
and T.LANGUAGE = L.LANGUAGE_CODE);
end INSERT_ROW;
cursor c is select
EXTERNAL_ACCESS_FLAG,
PUBLICATION_DATE,
OBJECT_VERSION_NUMBER,
LANGUAGE_CODE,
APPLICATION_ID,
STATUS_CODE,
EFFECTIVE_START_DATE,
EXPIRATION_DATE,
ITEM_TYPE,
URL_STRING,
ATTRIBUTE14,
CONTENT_TYPE_ID,
OWNER_ID,
DEFAULT_APPROVER_ID,
ITEM_DESTINATION_TYPE,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE15,
PRIORITY,
ACCESS_NAME,
DELIVERABLE_TYPE_CODE,
APPLICABLE_TO_CODE,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13
from JTF_AMV_ITEMS_B
where ITEM_ID = X_ITEM_ID
for update of ITEM_ID nowait;
cursor c1 is select
ITEM_NAME,
DESCRIPTION,
TEXT_STRING,
decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
from JTF_AMV_ITEMS_TL
where ITEM_ID = X_ITEM_ID
and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
for update of ITEM_ID nowait;
fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
procedure UPDATE_ROW (
X_ITEM_ID in NUMBER,
X_OBJECT_VERSION_NUMBER in NUMBER,
X_LAST_UPDATE_DATE in DATE,
X_LAST_UPDATED_BY in NUMBER,
X_LAST_UPDATE_LOGIN in NUMBER,
X_APPLICATION_ID in NUMBER,
X_EXTERNAL_ACCESS_FLAG in VARCHAR2,
X_ITEM_NAME in VARCHAR2,
X_DESCRIPTION in VARCHAR2,
X_TEXT_STRING in VARCHAR2,
X_LANGUAGE_CODE in VARCHAR2,
X_STATUS_CODE in VARCHAR2,
X_EFFECTIVE_START_DATE in DATE,
X_EXPIRATION_DATE in DATE,
X_ITEM_TYPE in VARCHAR2,
X_URL_STRING in VARCHAR2,
X_PUBLICATION_DATE in DATE,
X_PRIORITY in VARCHAR2,
X_CONTENT_TYPE_ID in NUMBER,
X_OWNER_ID in NUMBER,
X_DEFAULT_APPROVER_ID in NUMBER,
X_ITEM_DESTINATION_TYPE in VARCHAR2,
X_ACCESS_NAME in VARCHAR2,
X_DELIVERABLE_TYPE_CODE in VARCHAR2,
X_APPLICABLE_TO_CODE in VARCHAR2,
X_ATTRIBUTE_CATEGORY in VARCHAR2,
X_ATTRIBUTE1 in VARCHAR2,
X_ATTRIBUTE2 in VARCHAR2,
X_ATTRIBUTE3 in VARCHAR2,
X_ATTRIBUTE4 in VARCHAR2,
X_ATTRIBUTE5 in VARCHAR2,
X_ATTRIBUTE6 in VARCHAR2,
X_ATTRIBUTE7 in VARCHAR2,
X_ATTRIBUTE8 in VARCHAR2,
X_ATTRIBUTE9 in VARCHAR2,
X_ATTRIBUTE10 in VARCHAR2,
X_ATTRIBUTE11 in VARCHAR2,
X_ATTRIBUTE12 in VARCHAR2,
X_ATTRIBUTE13 in VARCHAR2,
X_ATTRIBUTE14 in VARCHAR2,
X_ATTRIBUTE15 in VARCHAR2
) is
begin
update JTF_AMV_ITEMS_B set
OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
LAST_UPDATED_BY = X_LAST_UPDATED_BY,
LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
APPLICATION_ID = X_APPLICATION_ID,
EXTERNAL_ACCESS_FLAG = X_EXTERNAL_ACCESS_FLAG,
LANGUAGE_CODE = X_LANGUAGE_CODE,
STATUS_CODE = X_STATUS_CODE,
EFFECTIVE_START_DATE = X_EFFECTIVE_START_DATE,
EXPIRATION_DATE = X_EXPIRATION_DATE,
ITEM_TYPE = X_ITEM_TYPE,
URL_STRING = X_URL_STRING,
PUBLICATION_DATE = X_PUBLICATION_DATE,
PRIORITY = X_PRIORITY,
CONTENT_TYPE_ID = X_CONTENT_TYPE_ID,
OWNER_ID = X_OWNER_ID,
DEFAULT_APPROVER_ID = X_DEFAULT_APPROVER_ID,
ITEM_DESTINATION_TYPE = X_ITEM_DESTINATION_TYPE,
ACCESS_NAME = X_ACCESS_NAME,
DELIVERABLE_TYPE_CODE = X_DELIVERABLE_TYPE_CODE,
APPLICABLE_TO_CODE = X_APPLICABLE_TO_CODE,
ATTRIBUTE_CATEGORY = decode(X_ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR,
ATTRIBUTE_CATEGORY, X_ATTRIBUTE_CATEGORY),
ATTRIBUTE1 =decode(X_ATTRIBUTE1,FND_API.G_MISS_CHAR,ATTRIBUTE1,X_ATTRIBUTE1),
ATTRIBUTE2 =decode(X_ATTRIBUTE2,FND_API.G_MISS_CHAR,ATTRIBUTE2,X_ATTRIBUTE2),
ATTRIBUTE3 =decode(X_ATTRIBUTE3,FND_API.G_MISS_CHAR,ATTRIBUTE3,X_ATTRIBUTE3),
ATTRIBUTE4 =decode(X_ATTRIBUTE4,FND_API.G_MISS_CHAR,ATTRIBUTE4,X_ATTRIBUTE4),
ATTRIBUTE5 =decode(X_ATTRIBUTE5,FND_API.G_MISS_CHAR,ATTRIBUTE5,X_ATTRIBUTE5),
ATTRIBUTE6 =decode(X_ATTRIBUTE6,FND_API.G_MISS_CHAR,ATTRIBUTE6,X_ATTRIBUTE6),
ATTRIBUTE7 =decode(X_ATTRIBUTE7,FND_API.G_MISS_CHAR,ATTRIBUTE7,X_ATTRIBUTE7),
ATTRIBUTE8 =decode(X_ATTRIBUTE8,FND_API.G_MISS_CHAR,ATTRIBUTE8,X_ATTRIBUTE8),
ATTRIBUTE9 =decode(X_ATTRIBUTE9,FND_API.G_MISS_CHAR,ATTRIBUTE9,X_ATTRIBUTE9),
ATTRIBUTE10 = decode(X_ATTRIBUTE10,FND_API.G_MISS_CHAR,
ATTRIBUTE10, X_ATTRIBUTE10),
ATTRIBUTE11 = decode(X_ATTRIBUTE11,FND_API.G_MISS_CHAR,
ATTRIBUTE11, X_ATTRIBUTE11),
ATTRIBUTE12 = decode(X_ATTRIBUTE12,FND_API.G_MISS_CHAR,
ATTRIBUTE12, X_ATTRIBUTE12),
ATTRIBUTE13 = decode(X_ATTRIBUTE13,FND_API.G_MISS_CHAR,
ATTRIBUTE13, X_ATTRIBUTE13),
ATTRIBUTE14 = decode(X_ATTRIBUTE14,FND_API.G_MISS_CHAR,
ATTRIBUTE14, X_ATTRIBUTE14),
ATTRIBUTE15 = decode(X_ATTRIBUTE15,FND_API.G_MISS_CHAR,
ATTRIBUTE15, X_ATTRIBUTE15)
where ITEM_ID = X_ITEM_ID;
update JTF_AMV_ITEMS_TL set
ITEM_NAME = decode( X_ITEM_NAME,
FND_API.G_MISS_CHAR, ITEM_NAME, X_ITEM_NAME),
DESCRIPTION = decode( X_DESCRIPTION,
FND_API.G_MISS_CHAR, DESCRIPTION, X_DESCRIPTION),
TEXT_STRING = decode (X_TEXT_STRING,
FND_API.G_MISS_CHAR, TEXT_STRING, X_TEXT_STRING),
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 ITEM_ID = X_ITEM_ID
and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
end UPDATE_ROW ;
procedure DELETE_ROW (
X_ITEM_ID in NUMBER
) is
begin
delete from JTF_AMV_ITEMS_TL
where ITEM_ID = X_ITEM_ID;
delete from JTF_AMV_ITEMS_B
where ITEM_ID = X_ITEM_ID;
end DELETE_ROW;
delete from JTF_AMV_ITEMS_TL T
where not exists
(select NULL
from JTF_AMV_ITEMS_B B
where B.ITEM_ID = T.ITEM_ID
);
update JTF_AMV_ITEMS_TL T set (
ITEM_NAME,
DESCRIPTION,
TEXT_STRING
) = (select
B.ITEM_NAME,
B.DESCRIPTION,
B.TEXT_STRING
from JTF_AMV_ITEMS_TL B
where B.ITEM_ID = T.ITEM_ID
and B.LANGUAGE = T.SOURCE_LANG)
where (
T.ITEM_ID,
T.LANGUAGE
) in (select
SUBT.ITEM_ID,
SUBT.LANGUAGE
from JTF_AMV_ITEMS_TL SUBB, JTF_AMV_ITEMS_TL SUBT
where SUBB.ITEM_ID = SUBT.ITEM_ID
and SUBB.LANGUAGE = SUBT.SOURCE_LANG
and (SUBB.ITEM_NAME <> SUBT.ITEM_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)
or SUBB.TEXT_STRING <> SUBT.TEXT_STRING
or (SUBB.TEXT_STRING is null and SUBT.TEXT_STRING is not null)
or (SUBB.TEXT_STRING is not null and SUBT.TEXT_STRING is null)
));
insert into JTF_AMV_ITEMS_TL (
ITEM_ID,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN,
ITEM_NAME,
DESCRIPTION,
TEXT_STRING,
LANGUAGE,
SOURCE_LANG
) select
B.ITEM_ID,
B.LAST_UPDATE_DATE,
B.LAST_UPDATED_BY,
B.CREATION_DATE,
B.CREATED_BY,
B.LAST_UPDATE_LOGIN,
B.ITEM_NAME,
B.DESCRIPTION,
B.TEXT_STRING,
L.LANGUAGE_CODE,
B.SOURCE_LANG
from JTF_AMV_ITEMS_TL B, FND_LANGUAGES L
where L.INSTALLED_FLAG in ('I', 'B')
and B.LANGUAGE = userenv('LANG')
and not exists
(select NULL
from JTF_AMV_ITEMS_TL T
where T.ITEM_ID = B.ITEM_ID
and T.LANGUAGE = L.LANGUAGE_CODE);
x_last_update_date in varchar2
)
is
v_db_owner_id number;
, x_last_update_date => x_last_update_date
);
x_last_update_date=>x_last_update_date
);
x_last_update_date=>x_last_update_date
);