DBA Data[Home] [Help]

APPS.BSC_AW_UTILITY dependencies on DBMS_UTILITY

Line 1082: dbms_utility.db_version(l_version,l_compatibility);

1078: if g_db_version is null then
1079: l_version:=get_parameter_value('DB VERSION');
1080: /*5335425. some languages have decimal representation as 10,2 instead od 10.2 */
1081: if l_version is null then
1082: dbms_utility.db_version(l_version,l_compatibility);
1083: l_version:=substr(l_version,1,instr(l_version,'.'))||replace(substr(l_version,instr(l_version,'.')+1),'.');
1084: l_version:=substr(l_version,1,instr(l_version,','))||replace(substr(l_version,instr(l_version,',')+1),',');
1085: end if;
1086: counter:=0;

Line 1216: return dbms_utility.get_hash_value(to_char(get_dbms_time),0,p_seed);

1212: End;
1213:
1214: function get_random_number(p_seed number) return number is
1215: Begin
1216: return dbms_utility.get_hash_value(to_char(get_dbms_time),0,p_seed);
1217: Exception when others then
1218: log_n('Exception in get_random_number '||sqlerrm);
1219: raise;
1220: End;

Line 1615: return dbms_utility.get_time;

1611:
1612: --used primarily as job_name in 10g multi threading to get a unique name
1613: function get_dbms_time return number is
1614: Begin
1615: return dbms_utility.get_time;
1616: Exception when others then
1617: log_n('Exception in get_dbms_time '||sqlerrm);
1618: raise;
1619: End;

Line 1694: l_hash_value:=dbms_utility.get_hash_value(p_string,p_start,p_end);

1690:
1691: function get_hash_value(p_string varchar2,p_start number,p_end number) return varchar2 is
1692: l_hash_value number;
1693: Begin
1694: l_hash_value:=dbms_utility.get_hash_value(p_string,p_start,p_end);
1695: return to_char(l_hash_value);
1696: Exception when others then
1697: log_n('Exception in get_hash_value '||sqlerrm);
1698: raise;