The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row
(p_commit IN VARCHAR2,
p_called_by_form IN VARCHAR2,
p_phrase_code IN VARCHAR2,
p_language IN VARCHAR2,
p_source_lang IN VARCHAR2,
p_key_word1 IN VARCHAR2,
p_key_word2 IN VARCHAR2,
p_key_word3 IN VARCHAR2,
p_key_word4 IN VARCHAR2,
p_key_word5 IN VARCHAR2,
p_key_word6 IN VARCHAR2,
p_phrase_text IN VARCHAR2,
p_print_font IN VARCHAR2,
p_print_size IN NUMBER,
p_image_pathname IN VARCHAR2,
p_image_print_location IN VARCHAR2,
p_attribute_category IN VARCHAR2,
p_attribute1 IN VARCHAR2,
p_attribute2 IN VARCHAR2,
p_attribute3 IN VARCHAR2,
p_attribute4 IN VARCHAR2,
p_attribute5 IN VARCHAR2,
p_attribute6 IN VARCHAR2,
p_attribute7 IN VARCHAR2,
p_attribute8 IN VARCHAR2,
p_attribute9 IN VARCHAR2,
p_attribute10 IN VARCHAR2,
p_attribute11 IN VARCHAR2,
p_attribute12 IN VARCHAR2,
p_attribute13 IN VARCHAR2,
p_attribute14 IN VARCHAR2,
p_attribute15 IN VARCHAR2,
p_attribute16 IN VARCHAR2,
p_attribute17 IN VARCHAR2,
p_attribute18 IN VARCHAR2,
p_attribute19 IN VARCHAR2,
p_attribute20 IN VARCHAR2,
p_attribute21 IN VARCHAR2,
p_attribute22 IN VARCHAR2,
p_attribute23 IN VARCHAR2,
p_attribute24 IN VARCHAR2,
p_attribute25 IN VARCHAR2,
p_attribute26 IN VARCHAR2,
p_attribute27 IN VARCHAR2,
p_attribute28 IN VARCHAR2,
p_attribute29 IN VARCHAR2,
p_attribute30 IN VARCHAR2,
p_created_by IN NUMBER,
p_creation_date IN DATE,
p_last_updated_by IN NUMBER,
p_last_update_date IN DATE,
p_last_update_login IN NUMBER,
x_rowid OUT NOCOPY VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_oracle_error OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2)
IS
/* Alpha Variables */
L_RETURN_STATUS VARCHAR2(1) := 'S';
SAVEPOINT Insert_Row;
INSERT INTO gr_phrases_tl
(phrase_code,
language,
source_lang,
key_word1,
key_word2,
key_word3,
key_word4,
key_word5,
key_word6,
phrase_text,
print_font,
print_size,
image_pathname,
image_print_location,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute16,
attribute17,
attribute18,
attribute19,
attribute20,
attribute21,
attribute22,
attribute23,
attribute24,
attribute25,
attribute26,
attribute27,
attribute28,
attribute29,
attribute30,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login)
VALUES
(p_phrase_code,
p_language,
p_source_lang,
p_key_word1,
p_key_word2,
p_key_word3,
p_key_word4,
p_key_word5,
p_key_word6,
p_phrase_text,
p_print_font,
p_print_size,
p_image_pathname,
p_image_print_location,
p_attribute_category,
p_attribute1,
p_attribute2,
p_attribute3,
p_attribute4,
p_attribute5,
p_attribute6,
p_attribute7,
p_attribute8,
p_attribute9,
p_attribute10,
p_attribute11,
p_attribute12,
p_attribute13,
p_attribute14,
p_attribute15,
p_attribute16,
p_attribute17,
p_attribute18,
p_attribute19,
p_attribute20,
p_attribute21,
p_attribute22,
p_attribute23,
p_attribute24,
p_attribute25,
p_attribute26,
p_attribute27,
p_attribute28,
p_attribute29,
p_attribute30,
p_created_by,
p_creation_date,
p_last_updated_by,
p_last_update_date,
p_last_update_login);
/* Now get the row id of the inserted record */
Check_Primary_Key
(p_phrase_code,
p_language,
'F',
l_rowid,
l_key_exists);
ROLLBACK TO SAVEPOINT Insert_Row;
ROLLBACK TO SAVEPOINT Insert_Row;
ROLLBACK TO SAVEPOINT Insert_Row;
'GR_NO_RECORD_INSERTED');
ROLLBACK TO SAVEPOINT Insert_Row;
END Insert_Row;
PROCEDURE Update_Row
(p_commit IN VARCHAR2,
p_called_by_form IN VARCHAR2,
p_rowid IN VARCHAR2,
p_phrase_code IN VARCHAR2,
p_language IN VARCHAR2,
p_source_lang IN VARCHAR2,
p_key_word1 IN VARCHAR2,
p_key_word2 IN VARCHAR2,
p_key_word3 IN VARCHAR2,
p_key_word4 IN VARCHAR2,
p_key_word5 IN VARCHAR2,
p_key_word6 IN VARCHAR2,
p_phrase_text IN VARCHAR2,
p_print_font IN VARCHAR2,
p_print_size IN NUMBER,
p_image_pathname IN VARCHAR2,
p_image_print_location IN VARCHAR2,
p_attribute_category IN VARCHAR2,
p_attribute1 IN VARCHAR2,
p_attribute2 IN VARCHAR2,
p_attribute3 IN VARCHAR2,
p_attribute4 IN VARCHAR2,
p_attribute5 IN VARCHAR2,
p_attribute6 IN VARCHAR2,
p_attribute7 IN VARCHAR2,
p_attribute8 IN VARCHAR2,
p_attribute9 IN VARCHAR2,
p_attribute10 IN VARCHAR2,
p_attribute11 IN VARCHAR2,
p_attribute12 IN VARCHAR2,
p_attribute13 IN VARCHAR2,
p_attribute14 IN VARCHAR2,
p_attribute15 IN VARCHAR2,
p_attribute16 IN VARCHAR2,
p_attribute17 IN VARCHAR2,
p_attribute18 IN VARCHAR2,
p_attribute19 IN VARCHAR2,
p_attribute20 IN VARCHAR2,
p_attribute21 IN VARCHAR2,
p_attribute22 IN VARCHAR2,
p_attribute23 IN VARCHAR2,
p_attribute24 IN VARCHAR2,
p_attribute25 IN VARCHAR2,
p_attribute26 IN VARCHAR2,
p_attribute27 IN VARCHAR2,
p_attribute28 IN VARCHAR2,
p_attribute29 IN VARCHAR2,
p_attribute30 IN VARCHAR2,
p_created_by IN NUMBER,
p_creation_date IN DATE,
p_last_updated_by IN NUMBER,
p_last_update_date IN DATE,
p_last_update_login IN NUMBER,
x_return_status OUT NOCOPY VARCHAR2,
x_oracle_error OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2)
IS
/* Alpha Variables */
L_RETURN_STATUS VARCHAR2(1) := 'S';
SAVEPOINT Update_Row;
UPDATE gr_phrases_tl
SET phrase_code = p_phrase_code,
language = p_language,
source_lang = p_source_lang,
key_word1 = p_key_word1,
key_word2 = p_key_word2,
key_word3 = p_key_word3,
key_word4 = p_key_word4,
key_word5 = p_key_word5,
key_word6 = p_key_word6,
phrase_text = p_phrase_text,
print_font = p_print_font,
print_size = p_print_size,
image_pathname = p_image_pathname,
image_print_location = p_image_print_location,
attribute_category = p_attribute_category,
attribute1 = p_attribute1,
attribute2 = p_attribute2,
attribute3 = p_attribute3,
attribute4 = p_attribute4,
attribute5 = p_attribute5,
attribute6 = p_attribute6,
attribute7 = p_attribute7,
attribute8 = p_attribute8,
attribute9 = p_attribute9,
attribute10 = p_attribute10,
attribute11 = p_attribute11,
attribute12 = p_attribute12,
attribute13 = p_attribute13,
attribute14 = p_attribute14,
attribute15 = p_attribute15,
attribute16 = p_attribute16,
attribute17 = p_attribute17,
attribute18 = p_attribute18,
attribute19 = p_attribute19,
attribute20 = p_attribute20,
attribute21 = p_attribute11,
attribute22 = p_attribute22,
attribute23 = p_attribute23,
attribute24 = p_attribute24,
attribute25 = p_attribute25,
attribute26 = p_attribute26,
attribute27 = p_attribute27,
attribute28 = p_attribute28,
attribute29 = p_attribute29,
attribute30 = p_attribute30,
created_by = p_created_by,
creation_date = p_creation_date,
last_updated_by = p_last_updated_by,
last_update_date = p_last_update_date,
last_update_login = p_last_update_login
WHERE rowid = p_rowid;
ROLLBACK TO SAVEPOINT Update_Row;
ROLLBACK TO SAVEPOINT Update_Row;
'GR_NO_RECORD_INSERTED');
ROLLBACK TO SAVEPOINT Update_Row;
END Update_Row;
L_LAST_UPDATE_DATE DATE;
L_LAST_UPDATED_BY NUMBER;
L_LAST_UPDATE_LOGIN NUMBER;
SELECT pht.phrase_text,
pht.key_word1,
pht.key_word2,
pht.key_word3,
pht.key_word4,
pht.key_word5,
pht.key_word6,
pht.print_font,
pht.print_size,
pht.image_pathname,
pht.image_print_location,
pht.attribute_category,
pht.attribute1,
pht.attribute2,
pht.attribute3,
pht.attribute4,
pht.attribute5,
pht.attribute6,
pht.attribute7,
pht.attribute8,
pht.attribute9,
pht.attribute10,
pht.attribute11,
pht.attribute12,
pht.attribute13,
pht.attribute14,
pht.attribute15,
pht.attribute16,
pht.attribute17,
pht.attribute18,
pht.attribute19,
pht.attribute20,
pht.attribute21,
pht.attribute22,
pht.attribute23,
pht.attribute24,
pht.attribute25,
pht.attribute26,
pht.attribute27,
pht.attribute28,
pht.attribute29,
pht.attribute30,
pht.created_by,
pht.creation_date,
pht.last_updated_by,
pht.last_update_date,
pht.last_update_login
FROM gr_phrases_tl pht
WHERE pht.phrase_code = p_phrase_code
AND pht.language = l_language;
SELECT lng.language_code
FROM fnd_languages lng
WHERE lng.installed_flag IN ('I', 'B');
delete from GR_PHRASES_TL T
where not exists
(select NULL
from GR_PHRASES_B B
where B.PHRASE_CODE = T.PHRASE_CODE
);
update gr_phrases_tl t set (
phrase_text ) =
( select
B.PHRASE_TEXT
from GR_PHRASES_TL B
where B.PHRASE_CODE = T.PHRASE_CODE
and B.LANGUAGE = T.SOURCE_LANG)
where (
T.PHRASE_CODE,
T.LANGUAGE
) in (select
SUBT.PHRASE_CODE,
SUBT.LANGUAGE
from GR_PHRASES_TL SUBB, GR_PHRASES_TL SUBT
where SUBB.PHRASE_CODE = SUBT.PHRASE_CODE
and SUBB.LANGUAGE = SUBT.SOURCE_LANG
and (SUBB.PHRASE_TEXT <> SUBT.PHRASE_TEXT
or (SUBB.PHRASE_TEXT is null and SUBT.PHRASE_TEXT is not null)
or (SUBB.PHRASE_TEXT is not null and SUBT.PHRASE_TEXT is null)
));
l_last_updated_by := PhraseDesc.last_updated_by;
l_last_update_date := PhraseDesc.last_update_date;
l_last_update_login := PhraseDesc.last_update_login;
** insert it and go on to the next.
*/
OPEN c_get_installed_languages;
INSERT INTO gr_phrases_tl
(phrase_code,
language,
source_lang,
key_word1,
key_word2,
key_word3,
key_word4,
key_word5,
key_word6,
phrase_text,
print_font,
print_size,
image_pathname,
image_print_location,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute16,
attribute17,
attribute18,
attribute19,
attribute20,
attribute21,
attribute22,
attribute23,
attribute24,
attribute25,
attribute26,
attribute27,
attribute28,
attribute29,
attribute30,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login)
VALUES
(p_phrase_code,
l_language,
p_language,
l_key_word1,
l_key_word2,
l_key_word3,
l_key_word4,
l_key_word5,
l_key_word6,
l_base_desc,
l_print_font,
l_print_size,
l_image_pathname,
l_image_print_location,
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_attribute16,
l_attribute17,
l_attribute18,
l_attribute19,
l_attribute20,
l_attribute21,
l_attribute22,
l_attribute23,
l_attribute24,
l_attribute25,
l_attribute26,
l_attribute27,
l_attribute28,
l_attribute29,
l_attribute30,
l_created_by,
l_creation_date,
l_last_updated_by,
l_last_update_date,
l_last_update_login);
p_last_updated_by IN NUMBER,
p_last_update_date IN DATE,
p_last_update_login IN NUMBER,
x_return_status OUT NOCOPY VARCHAR2,
x_oracle_error OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2)
IS
/* Alpha Variables */
L_RETURN_STATUS VARCHAR2(1) := 'S';
SELECT last_update_date
FROM gr_phrases_tl
WHERE rowid = p_rowid
FOR UPDATE NOWAIT;
IF LockPhraseRcd.last_update_date <> p_last_update_date THEN
RAISE RECORD_CHANGED_ERROR;
PROCEDURE Delete_Row
(p_commit IN VARCHAR2,
p_called_by_form IN VARCHAR2,
p_rowid IN VARCHAR2,
p_phrase_code IN VARCHAR2,
p_language IN VARCHAR2,
p_source_lang IN VARCHAR2,
p_key_word1 IN VARCHAR2,
p_key_word2 IN VARCHAR2,
p_key_word3 IN VARCHAR2,
p_key_word4 IN VARCHAR2,
p_key_word5 IN VARCHAR2,
p_key_word6 IN VARCHAR2,
p_phrase_text IN VARCHAR2,
p_print_font IN VARCHAR2,
p_print_size IN NUMBER,
p_image_pathname IN VARCHAR2,
p_image_print_location IN VARCHAR2,
p_attribute_category IN VARCHAR2,
p_attribute1 IN VARCHAR2,
p_attribute2 IN VARCHAR2,
p_attribute3 IN VARCHAR2,
p_attribute4 IN VARCHAR2,
p_attribute5 IN VARCHAR2,
p_attribute6 IN VARCHAR2,
p_attribute7 IN VARCHAR2,
p_attribute8 IN VARCHAR2,
p_attribute9 IN VARCHAR2,
p_attribute10 IN VARCHAR2,
p_attribute11 IN VARCHAR2,
p_attribute12 IN VARCHAR2,
p_attribute13 IN VARCHAR2,
p_attribute14 IN VARCHAR2,
p_attribute15 IN VARCHAR2,
p_attribute16 IN VARCHAR2,
p_attribute17 IN VARCHAR2,
p_attribute18 IN VARCHAR2,
p_attribute19 IN VARCHAR2,
p_attribute20 IN VARCHAR2,
p_attribute21 IN VARCHAR2,
p_attribute22 IN VARCHAR2,
p_attribute23 IN VARCHAR2,
p_attribute24 IN VARCHAR2,
p_attribute25 IN VARCHAR2,
p_attribute26 IN VARCHAR2,
p_attribute27 IN VARCHAR2,
p_attribute28 IN VARCHAR2,
p_attribute29 IN VARCHAR2,
p_attribute30 IN VARCHAR2,
p_created_by IN NUMBER,
p_creation_date IN DATE,
p_last_updated_by IN NUMBER,
p_last_update_date IN DATE,
p_last_update_login IN NUMBER,
x_return_status OUT NOCOPY VARCHAR2,
x_oracle_error OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2)
IS
/* Alpha Variables */
L_RETURN_STATUS VARCHAR2(1) := 'S';
SAVEPOINT Delete_Row;
DELETE FROM gr_phrases_tl
WHERE rowid = p_rowid;
ROLLBACK TO SAVEPOINT Delete_Row;
ROLLBACK TO SAVEPOINT Delete_Row;
ROLLBACK TO SAVEPOINT Delete_Row;
END Delete_Row;
PROCEDURE Delete_Rows
(p_commit IN VARCHAR2,
p_called_by_form IN VARCHAR2,
p_phrase_code IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_oracle_error OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2)
IS
/* Alpha Variables */
L_RETURN_STATUS VARCHAR2(1) := 'S';
SAVEPOINT Delete_Rows;
DELETE FROM gr_phrases_tl
WHERE phrase_code = p_phrase_code;
ROLLBACK TO SAVEPOINT Delete_Rows;
END Delete_Rows;
SELECT lng.language_code
FROM fnd_languages lng
WHERE lng.language_code = l_language_code;
ROLLBACK TO SAVEPOINT Delete_Row;
SELECT lng.installed_flag
FROM fnd_languages lng
WHERE lng.language_code = p_language
AND lng.installed_flag IN ('B', 'I');
SELECT pht.rowid
FROM gr_phrases_tl pht
WHERE pht.phrase_code = p_phrase_code
AND pht.language = p_language;
UPDATE GR_PHRASES_TL SET
PHRASE_TEXT = X_PHRASE_TEXT,
SOURCE_LANG = USERENV('LANG'),
LAST_UPDATE_DATE = sysdate,
LAST_UPDATED_BY = 0,
LAST_UPDATE_LOGIN = 0
WHERE (PHRASE_CODE = X_PHRASE_CODE)
AND (USERENV('LANG') IN (LANGUAGE, SOURCE_LANG));
SELECT rowid
FROM GR_PHRASES_TL
WHERE (PHRASE_CODE = X_PHRASE_CODE)
AND (LANGUAGE = X_LANGUAGE);
GR_PHRASES_TL_PKG.UPDATE_ROW(
P_COMMIT => 'T'
,P_CALLED_BY_FORM => 'F'
,P_ROWID => l_row_id
,P_IMAGE_PRINT_LOCATION => X_IMAGE_PRINT_LOCATION
,P_PHRASE_CODE => X_PHRASE_CODE
,P_LANGUAGE => X_LANGUAGE
,P_SOURCE_LANG => X_SOURCE_LANG
,P_KEY_WORD1 => X_KEY_WORD1
,P_KEY_WORD2 => X_KEY_WORD2
,P_KEY_WORD3 => X_KEY_WORD3
,P_KEY_WORD4 => X_KEY_WORD4
,P_KEY_WORD5 => X_KEY_WORD5
,P_KEY_WORD6 => X_KEY_WORD6
,P_PHRASE_TEXT => X_PHRASE_TEXT
,P_PRINT_FONT => X_PRINT_FONT
,P_PRINT_SIZE => X_PRINT_SIZE
,P_IMAGE_PATHNAME => X_IMAGE_PATHNAME
,P_ATTRIBUTE_CATEGORY => NULL
,P_ATTRIBUTE1 => NULL
,P_ATTRIBUTE2 => NULL
,P_ATTRIBUTE3 => NULL
,P_ATTRIBUTE4 => NULL
,P_ATTRIBUTE5 => NULL
,P_ATTRIBUTE6 => NULL
,P_ATTRIBUTE7 => NULL
,P_ATTRIBUTE8 => NULL
,P_ATTRIBUTE9 => NULL
,P_ATTRIBUTE10 => NULL
,P_ATTRIBUTE11 => NULL
,P_ATTRIBUTE12 => NULL
,P_ATTRIBUTE13 => NULL
,P_ATTRIBUTE14 => NULL
,P_ATTRIBUTE15 => NULL
,P_ATTRIBUTE16 => NULL
,P_ATTRIBUTE17 => NULL
,P_ATTRIBUTE18 => NULL
,P_ATTRIBUTE19 => NULL
,P_ATTRIBUTE20 => NULL
,P_ATTRIBUTE21 => NULL
,P_ATTRIBUTE22 => NULL
,P_ATTRIBUTE23 => NULL
,P_ATTRIBUTE24 => NULL
,P_ATTRIBUTE25 => NULL
,P_ATTRIBUTE26 => NULL
,P_ATTRIBUTE27 => NULL
,P_ATTRIBUTE28 => NULL
,P_ATTRIBUTE29 => NULL
,P_ATTRIBUTE30 => NULL
,P_CREATED_BY => l_user_id
,P_CREATION_DATE => sysdate
,P_LAST_UPDATED_BY => l_user_id
,P_LAST_UPDATE_DATE => sysdate
,P_LAST_UPDATE_LOGIN => 0
,X_RETURN_STATUS => l_return_status
,X_ORACLE_ERROR => l_oracle_error
,X_MSG_DATA => l_msg_data);
GR_PHRASES_TL_PKG.INSERT_ROW(
P_COMMIT => 'T'
,P_CALLED_BY_FORM => 'F'
,P_IMAGE_PRINT_LOCATION => X_IMAGE_PRINT_LOCATION
,P_PHRASE_CODE => X_PHRASE_CODE
,P_LANGUAGE => X_LANGUAGE
,P_SOURCE_LANG => X_SOURCE_LANG
,P_KEY_WORD1 => X_KEY_WORD1
,P_KEY_WORD2 => X_KEY_WORD2
,P_KEY_WORD3 => X_KEY_WORD3
,P_KEY_WORD4 => X_KEY_WORD4
,P_KEY_WORD5 => X_KEY_WORD5
,P_KEY_WORD6 => X_KEY_WORD6
,P_PHRASE_TEXT => X_PHRASE_TEXT
,P_PRINT_FONT => X_PRINT_FONT
,P_PRINT_SIZE => X_PRINT_SIZE
,P_IMAGE_PATHNAME => X_IMAGE_PATHNAME
,P_ATTRIBUTE_CATEGORY => NULL
,P_ATTRIBUTE1 => NULL
,P_ATTRIBUTE2 => NULL
,P_ATTRIBUTE3 => NULL
,P_ATTRIBUTE4 => NULL
,P_ATTRIBUTE5 => NULL
,P_ATTRIBUTE6 => NULL
,P_ATTRIBUTE7 => NULL
,P_ATTRIBUTE8 => NULL
,P_ATTRIBUTE9 => NULL
,P_ATTRIBUTE10 => NULL
,P_ATTRIBUTE11 => NULL
,P_ATTRIBUTE12 => NULL
,P_ATTRIBUTE13 => NULL
,P_ATTRIBUTE14 => NULL
,P_ATTRIBUTE15 => NULL
,P_ATTRIBUTE16 => NULL
,P_ATTRIBUTE17 => NULL
,P_ATTRIBUTE18 => NULL
,P_ATTRIBUTE19 => NULL
,P_ATTRIBUTE20 => NULL
,P_ATTRIBUTE21 => NULL
,P_ATTRIBUTE22 => NULL
,P_ATTRIBUTE23 => NULL
,P_ATTRIBUTE24 => NULL
,P_ATTRIBUTE25 => NULL
,P_ATTRIBUTE26 => NULL
,P_ATTRIBUTE27 => NULL
,P_ATTRIBUTE28 => NULL
,P_ATTRIBUTE29 => NULL
,P_ATTRIBUTE30 => NULL
,P_CREATED_BY => l_user_id
,P_CREATION_DATE => sysdate
,P_LAST_UPDATED_BY => l_user_id
,P_LAST_UPDATE_DATE => sysdate
,P_LAST_UPDATE_LOGIN => 0
,X_ROWID => l_row_id
,X_RETURN_STATUS => l_return_status
,X_ORACLE_ERROR => l_oracle_error
,X_MSG_DATA => l_msg_data);
delete from GR_PHRASES_TL T
where not exists
(select NULL
from GR_PHRASES_B B
where B.PHRASE_CODE = T.PHRASE_CODE
);
update GR_PHRASES_TL T set (
PHRASE_TEXT
) = (select
B.PHRASE_TEXT
from GR_PHRASES_TL B
where B.PHRASE_CODE = T.PHRASE_CODE
and B.LANGUAGE = T.SOURCE_LANG)
where (
T.PHRASE_CODE,
T.LANGUAGE
) in (select
SUBT.PHRASE_CODE,
SUBT.LANGUAGE
from GR_PHRASES_TL SUBB, GR_PHRASES_TL SUBT
where SUBB.PHRASE_CODE = SUBT.PHRASE_CODE
and SUBB.LANGUAGE = SUBT.SOURCE_LANG
and (SUBB.PHRASE_TEXT <> SUBT.PHRASE_TEXT
));
insert into GR_PHRASES_TL (
IMAGE_PRINT_LOCATION,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
ATTRIBUTE16,
ATTRIBUTE17,
ATTRIBUTE18,
ATTRIBUTE19,
ATTRIBUTE20,
ATTRIBUTE21,
ATTRIBUTE22,
ATTRIBUTE23,
ATTRIBUTE24,
ATTRIBUTE25,
ATTRIBUTE26,
ATTRIBUTE27,
ATTRIBUTE28,
ATTRIBUTE29,
ATTRIBUTE30,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
PHRASE_CODE,
KEY_WORD1,
KEY_WORD2,
KEY_WORD3,
KEY_WORD4,
KEY_WORD5,
KEY_WORD6,
PHRASE_TEXT,
PRINT_FONT,
PRINT_SIZE,
IMAGE_PATHNAME,
LANGUAGE,
SOURCE_LANG
) select
B.IMAGE_PRINT_LOCATION,
B.ATTRIBUTE_CATEGORY,
B.ATTRIBUTE1,
B.ATTRIBUTE2,
B.ATTRIBUTE3,
B.ATTRIBUTE4,
B.ATTRIBUTE5,
B.ATTRIBUTE6,
B.ATTRIBUTE7,
B.ATTRIBUTE8,
B.ATTRIBUTE9,
B.ATTRIBUTE10,
B.ATTRIBUTE11,
B.ATTRIBUTE12,
B.ATTRIBUTE13,
B.ATTRIBUTE14,
B.ATTRIBUTE15,
B.ATTRIBUTE16,
B.ATTRIBUTE17,
B.ATTRIBUTE18,
B.ATTRIBUTE19,
B.ATTRIBUTE20,
B.ATTRIBUTE21,
B.ATTRIBUTE22,
B.ATTRIBUTE23,
B.ATTRIBUTE24,
B.ATTRIBUTE25,
B.ATTRIBUTE26,
B.ATTRIBUTE27,
B.ATTRIBUTE28,
B.ATTRIBUTE29,
B.ATTRIBUTE30,
B.CREATED_BY,
B.CREATION_DATE,
B.LAST_UPDATED_BY,
B.LAST_UPDATE_DATE,
B.LAST_UPDATE_LOGIN,
B.PHRASE_CODE,
B.KEY_WORD1,
B.KEY_WORD2,
B.KEY_WORD3,
B.KEY_WORD4,
B.KEY_WORD5,
B.KEY_WORD6,
B.PHRASE_TEXT,
B.PRINT_FONT,
B.PRINT_SIZE,
B.IMAGE_PATHNAME,
L.LANGUAGE_CODE,
B.SOURCE_LANG
from GR_PHRASES_TL B, FND_LANGUAGES L
where L.INSTALLED_FLAG in ('I', 'B')
and B.LANGUAGE = userenv('LANG')
and not exists
(select NULL
from GR_PHRASES_TL T
where T.PHRASE_CODE = B.PHRASE_CODE
and T.LANGUAGE = L.LANGUAGE_CODE);