296: p_shared_type_id in number,
297: p_shared_type_name in varchar2 ) is
298: cursor csr_ins_langs is
299: select l.language_code 300: from fnd_languages l 301: where l.installed_flag in ('I','B')
302: and not exists ( select null
303: from per_shared_types_tl stt
304: where stt.shared_type_id = p_shared_type_id