171:
172: Function get_asset_key_name (x_id in number, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return varchar2 is
173: cursor c is
174: select concatenated_segments
175: from fa_asset_keywords_kfv
176: where code_combination_id = x_id;
177:
178: v_concatenated_segments fa_asset_keywords_kfv.concatenated_segments%type;
179: begin
174: select concatenated_segments
175: from fa_asset_keywords_kfv
176: where code_combination_id = x_id;
177:
178: v_concatenated_segments fa_asset_keywords_kfv.concatenated_segments%type;
179: begin
180: open c;
181: fetch c into v_concatenated_segments;
182: close c;