DBA Data[Home] [Help]

APPS.AHL_WF_NOTIFICATION_PVT dependencies on DBMS_RANDOM

Line 66: l_item_key VARCHAR2(60) := p_object||':'||TO_CHAR(sysdate, 'DD-MON-YYYY_HH:MM:SSSSS')||':'||dbms_random.string('U', 5);

62: l_process_name VARCHAR2(30) := NVL(p_process_name, 'AHL_OA_NOTIFY');
63: l_item_type VARCHAR2(8) := NVL(p_item_type, 'AHLOANTF');
64: --sukhwsin::Changed key generation to generate unique keys. Also increased length of l_item_key.
65: --l_item_key VARCHAR2(30) := p_object||':'||TO_CHAR(sysdate, 'DD-MON-YYYY_HH:MM:SSSSS')
66: l_item_key VARCHAR2(60) := p_object||':'||TO_CHAR(sysdate, 'DD-MON-YYYY_HH:MM:SSSSS')||':'||dbms_random.string('U', 5);
67:
68:
69: l_dummy1 NUMBER;
70: l_dummy2 VARCHAR2(80);