APPS.POS_SPM_WF_PKG1 dependencies on FND_CRYPTO

Line 146: x_itemkey := 'POSSPM1_' || p_process || '_' || p_idstr || '_' || fnd_crypto.smallrandomnumber;

142: p_idstr IN VARCHAR2,
143: x_itemkey OUT NOCOPY VARCHAR2)
144: IS
145: BEGIN
146: x_itemkey := 'POSSPM1_' || p_process || '_' || p_idstr || '_' || fnd_crypto.smallrandomnumber;
147: END get_wf_item_key;
148:
149: PROCEDURE get_adhoc_role_name
150: (p_process IN VARCHAR2,

Line 156: To_char(Sysdate, 'MMDDYYYY_HH24MISS') || '_' || fnd_crypto.smallrandomnumber;

152: --l_name wf_roles.name%TYPE;
153: --l_index NUMBER := 1;
154: BEGIN
155: x_name := 'POSSPM1_' || p_process || '_' ||
156: To_char(Sysdate, 'MMDDYYYY_HH24MISS') || '_' || fnd_crypto.smallrandomnumber;
157: -- bug 3569374
158: --l_name := x_name;
159: --WHILE(wf_directory.getroledisplayname(l_name) IS NOT NULL) LOOP
160: -- l_name := x_name || '_' || l_index;

Line 3162: L_ADHOC_USER:='ADHOC_USER_'||l_rec.first_name||'_'||TO_CHAR(SYSDATE, 'MMDDYYYY_HH24MISS')||FND_CRYPTO.SMALLRANDOMNUMBER;

3158: END IF;
3159: CLOSE l_cur;
3160:
3161: IF (l_rec.email_address IS NOT NULL) THEN
3162: L_ADHOC_USER:='ADHOC_USER_'||l_rec.first_name||'_'||TO_CHAR(SYSDATE, 'MMDDYYYY_HH24MISS')||FND_CRYPTO.SMALLRANDOMNUMBER;
3163: L_DISPLAY_NAME:=l_rec.last_name||','||l_rec.first_name;
3164: -- CREATING ADHOC USER
3165: --Bug 10113987 Don't need to set the NOTIFICATION_PREFERENCE here
3166: WF_DIRECTORY.CREATEADHOCUSER(

Line 3689: l_role_name := l_process||' '||To_Char(l_vendor_id)||' '||to_char(sysdate, 'JSSSSS')||To_Char(fnd_crypto.smallrandomnumber);

3685: aname => 'BC_RECERT_DUE_DATE',
3686: avalue => l_due_date
3687: );
3688:
3689: l_role_name := l_process||' '||To_Char(l_vendor_id)||' '||to_char(sysdate, 'JSSSSS')||To_Char(fnd_crypto.smallrandomnumber);
3690: /*
3691: select vendor_name
3692: into l_role_display_name
3693: from ap_suppliers