[Home] [Help]
328: SELECT
329: node_id,
330: node_name,
331: node_description
332: FROM fnd_dm_nodes
333: WHERE node_name like p_find_criteria||'%'
334: ORDER BY node_name;
335:
336: BEGIN
341: IF (p_titles_only = 'N') THEN
342:
343: SELECT COUNT(*)
344: INTO l_row_count
345: FROM fnd_dm_nodes
346: WHERE node_name like p_find_criteria||'%';
347:
348: END IF;
349: