281: p_shared_type_id in number,
282: p_shared_type_name in varchar2 ) is
283: cursor csr_ins_langs is
284: select l.language_code 285: from fnd_languages l 286: where l.installed_flag in ('I','B')
287: and not exists ( select null
288: from per_shared_types_tl stt
289: where stt.shared_type_id = p_shared_type_id