37: BEGIN
38:
39: -- Validating Uniqueness for Name in a particular directory
40: FOR r_dirnode IN c_dirnode(p_child_dir_node_id) LOOP
41: IF IBC_UTILITIES_PVT.is_name_already_used(
42: p_dir_node_id => p_parent_dir_node_id,
43: p_name => r_dirnode.directory_node_code,
44: p_language => USERENV('lang'),
45: p_chk_dir_node_id => p_child_dir_node_id,
150: BEGIN
151:
152: -- Validating Uniqueness for Name in a particular directory
153: FOR r_dirnode IN c_dirnode(p_child_dir_node_id) LOOP
154: IF IBC_UTILITIES_PVT.is_name_already_used(
155: p_dir_node_id => p_parent_dir_node_id,
156: p_name => r_dirnode.directory_node_code,
157: p_language => USERENV('lang'),
158: p_chk_dir_node_id => p_child_dir_node_id,
221: BEGIN
222:
223: -- Validating Uniqueness for Name in a particular directory
224: FOR r_dirnode IN c_dirnode(p_child_dir_node_id) LOOP
225: IF IBC_UTILITIES_PVT.is_name_already_used(
226: p_dir_node_id => p_parent_dir_node_id,
227: p_name => r_dirnode.directory_node_code,
228: p_language => USERENV('lang'),
229: p_chk_dir_node_id => p_child_dir_node_id,