DBA Data[Home] [Help]

APPS.EC_EXECUTION_UTILS dependencies on DBMS_UTILITY

Line 1145: -- Bug 2791195: Modified the hash string and used dbms_utility to create hash table..

1141: end loop;
1142:
1143: -- Bug 2617428.
1144: -- Build hash table to store positions of columns requiring code conversion.
1145: -- Bug 2791195: Modified the hash string and used dbms_utility to create hash table..
1146: if c4.conversion_group_id IS NOT NULL then
1147: hash_string:=to_char(c4.conversion_group_id)||'-'||
1148: to_char(c4.external_level)||'-'||
1149: to_char(c4.conversion_sequence);

Line 1150: hash_value := dbms_utility.get_hash_value(hash_string,1,8192);

1146: if c4.conversion_group_id IS NOT NULL then
1147: hash_string:=to_char(c4.conversion_group_id)||'-'||
1148: to_char(c4.external_level)||'-'||
1149: to_char(c4.conversion_sequence);
1150: hash_value := dbms_utility.get_hash_value(hash_string,1,8192);
1151: if ec_utils.g_code_conv_pos_tbl_1.exists(hash_value) then
1152: if ec_utils.g_code_conv_pos_tbl_1(hash_value).occr=1 then
1153: p_count:=ec_utils.g_code_conv_pos_tbl_1(hash_value).value;
1154: ec_utils.g_code_conv_pos_tbl_2(p_count):=hash_value;

Line 1171: hash_val := dbms_utility.get_hash_value(hash_string,1,8192);

1167:
1168: -- Build hash table to store positions of columns in g_file_tbl.
1169: -- bug 2721631
1170: hash_string:=to_char(c4.external_level)||'-'||upper(c4.interface_column_name);
1171: hash_val := dbms_utility.get_hash_value(hash_string,1,8192);
1172:
1173: -- Bug 2834366
1174: if ec_utils.g_col_pos_tbl_1.exists(hash_val) then
1175: if ec_utils.g_col_pos_tbl_1(hash_val).occr=1 then