[Home] [Help]
APPS.PER_RI_CREATE_CRP_EMPLOYEE dependencies on DBMS_UTILITY
Line 270: select to_char(sysdate,'J')||to_char(sysdate,'HH24MISS')||dbms_utility.get_hash_value(p_last_name||p_sex||p_first_name,0,1000)
266:
267:
268: Else
269:
270: select to_char(sysdate,'J')||to_char(sysdate,'HH24MISS')||dbms_utility.get_hash_value(p_last_name||p_sex||p_first_name,0,1000)
271: into l_temp
272: from dual;
273:
274: l_person_user_key := 'RI~PER~'||l_temp;