APPS.POS_USER_REG_HELPER_PKG dependencies on WF_CORE

Line 25: -- This procedure uses wf_core to generate the registration key.

21: l_registration_key fnd_registrations.registration_key%TYPE;
22:
23: BEGIN
24:
25: -- This procedure uses wf_core to generate the registration key.
26: -- This approach is different from the code in java/schema/FndRegistrationEOImpl.java.
27: -- We can not use that approach as this is in PLSQL.
28:
29: -- loop 20 times to generate registration key

Line 41: l_random := wf_core.random;

37: x_return_status := 'E';
38: x_error := 'Can not generate a unique registration key';
39: END IF;
40:
41: l_random := wf_core.random;
42:
43: -- the registration key is varchar2(100) in fnd_registrations table
44:
45: l_registration_key := Substr(Substr(l_random,1,4) || To_char(Sysdate,'MMDDYYYYMISS') ||

Line 46: To_char(p_registration_id) || wf_core.random,1,100);

42:
43: -- the registration key is varchar2(100) in fnd_registrations table
44:
45: l_registration_key := Substr(Substr(l_random,1,4) || To_char(Sysdate,'MMDDYYYYMISS') ||
46: To_char(p_registration_id) || wf_core.random,1,100);
47:
48: -- check if the registration key already exists, and if not, we got a good key
49: OPEN l_cur(l_registration_key);
50: FETCH l_cur INTO l_id;