[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select application_id,
message_name,
message_text,
language_code
from fnd_new_messages_il
where industry_id = p_industry_id;
select
message_text
from fnd_new_messages
where application_id = p_app_id and
message_name = p_message_name and
language_code = p_language_code and
last_updated_by IN ('0','1','2');
update fnd_new_messages_il
set orig_message_text = v2.message_text
where application_id = v1.application_id and
message_name = v1.message_name and
language_code = v1.language_code and
industry_id = v_industry_id;
update fnd_new_messages
set message_text = v1.message_text,
last_updated_by = 8
where application_id = v1.application_id and
message_name = v1.message_name and
language_code = v1.language_code;
FND_FILE.PUT_LINE(FND_FILE.LOG, 'Update of industry translated message text completed.');
select application_id,
lookup_type,
lookup_code,
language_code,
meaning,
description
from fnd_lookup_values_il
where industry_id = p_industry_id;
select
meaning,
description
from fnd_lookup_values
where view_application_id = p_app_id and
lookup_type = p_lookup_type and
lookup_code = p_lookup_code and
language = p_language_code and
last_updated_by IN ('0','1','2');
update fnd_lookup_values_il
set orig_meaning = v2.meaning,
orig_description = v2.description
where application_id = v1.application_id and
lookup_type = v1.lookup_type and
lookup_code = v1.lookup_code and
language_code = v1.language_code and
industry_id = v_industry_id;
update fnd_lookup_values
set meaning = v1.meaning,
last_updated_by = 8
where view_application_id = v1.application_id and
lookup_type = v1.lookup_type and
lookup_code = v1.lookup_code and
language = v1.language_code;
update fnd_lookup_values
set description = v1.description,
last_updated_by = 8
where view_application_id = v1.application_id and
lookup_type = v1.lookup_type and
lookup_code = v1.lookup_code and
language = v1.language_code;
select il.application_id,
il.message_name,
il.language_code,
il.orig_message_text
from fnd_new_messages_il il,
fnd_new_messages n
where il.industry_id = v_industry_id and
il.application_id = n.application_id and
il.language_code = n.language_code and
il.message_name = n.message_name and
n.last_updated_by = 8;
select il.application_id,
il.lookup_type,
il.lookup_code,
il.language_code,
il.orig_meaning,
il.orig_description
from fnd_lookup_values_il il,
fnd_lookup_values lv
where il.industry_id = v_industry_id and
il.application_id = lv.view_application_id and
il.lookup_type = lv.lookup_type and
il.lookup_code = lv.lookup_code and
il.language_code = lv.language and
lv.last_updated_by = 8;
update fnd_new_messages
set message_text = v1.orig_message_text,
last_updated_by = 2
where application_id = v1.application_id and
message_name = v1.message_name and
language_code = v1.language_code;
update fnd_new_messages_il
set orig_message_text = null;
update fnd_lookup_values
set meaning = v2.orig_meaning,
description = v2.orig_description,
last_updated_by = 2
where view_application_id = v2.application_id
and lookup_type = v2.lookup_type
and lookup_code = v2.lookup_code
and language = v2.language_code;
update fnd_lookup_values_il
set orig_meaning = null,
orig_description = null;