DBA Data[Home] [Help]

APPS.AS_CATALOG_MIGRATION dependencies on DBMS_UTILITY

Line 449: l_name_hash_val := DBMS_UTILITY.GET_HASH_VALUE(l_category_name,1,10000000);

445:
446: -- Append the count if duplicate found
447: BEGIN
448: -- Get the hash value of the category name
449: l_name_hash_val := DBMS_UTILITY.GET_HASH_VALUE(l_category_name,1,10000000);
450: p_name_count_tab(l_name_hash_val) := p_name_count_tab(l_name_hash_val) + 1;
451: x_category_name := l_category_name || '(' || p_name_count_tab(l_name_hash_val) || ')';
452: EXCEPTION
453: -- NO_DATA_FOUND Exception implies that the name occurs for the very first time in array

Line 482: l_name_hash_val := DBMS_UTILITY.GET_HASH_VALUE(l_legacy_category_name,1,10000000);

478:
479: -- Append the count if duplicate found
480: BEGIN
481: -- Get the hash value of the category name
482: l_name_hash_val := DBMS_UTILITY.GET_HASH_VALUE(l_legacy_category_name,1,10000000);
483: p_name_count_tab(l_name_hash_val) := p_name_count_tab(l_name_hash_val) + 1;
484: x_legacy_category_name := l_legacy_category_name || '(' || p_name_count_tab(l_name_hash_val) || ')' || ' LEGACY';
485: EXCEPTION
486: -- NO_DATA_FOUND Exception implies that the name occurs for the very first time in array