[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE insert_hr_name_formats ( p_enterprise_code IN varchar2) AS
BEGIN
NULL;
END insert_hr_name_formats;
SELECT pet.enterprise_id
,pet.enterprise_name
,pet.description
,pet.source_lang
,pet.created_by
,pet.creation_date
FROM per_enterprises_tl pet
WHERE pet.language = userenv('LANG');
SELECT l.language_code
FROM fnd_languages l
WHERE l.installed_flag IN ('I','B')
AND NOT EXISTS (SELECT NULL
FROM per_enterprises_tl pet
WHERE pet.enterprise_id = c_enterprise_id
AND pet.language = l.language_code);
DELETE FROM per_enterprises_tl t
WHERE NOT EXISTS
( SELECT NULL
FROM per_enterprises b
WHERE b.enterprise_id = t.enterprise_id
);
UPDATE per_enterprises_tl t
SET ( enterprise_name,
description ) =
( SELECT b.enterprise_name,
b.description
FROM per_enterprises_tl b
WHERE b.enterprise_id = t.enterprise_id
AND b.language = t.source_lang )
WHERE ( t.enterprise_id,
t.language
) IN
( SELECT subt.enterprise_id,
subt.language
FROM per_enterprises_tl subb, per_enterprises_tl subt
WHERE subb.enterprise_id = subt.enterprise_id
AND subb.language = subt.source_lang
AND ( subb.enterprise_name <> subt.enterprise_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)
)
);
INSERT INTO per_enterprises_tl
(source_lang
,enterprise_id
,enterprise_name
,description
,language
,created_by
,creation_date
,last_updated_by
,last_update_date
) VALUES
(l_ent_data_group.source_lang
,l_ent_data_group.enterprise_id
,l_ent_data_group.enterprise_name
,l_ent_data_group.description
,l_lang.language_code
,fnd_global.user_id
,sysdate
,fnd_global.user_id
,sysdate
);