APPS.POS_USER_REG_HELPER_PKG dependencies on FND_REGISTRATIONS

Line 17: FROM fnd_registrations

13: l_max_run INTEGER;
14:
15: CURSOR l_cur (p_reg_key IN VARCHAR2) IS
16: SELECT registration_id
17: FROM fnd_registrations
18: WHERE registration_key = p_reg_key;
19:
20: l_id NUMBER;
21: l_registration_key fnd_registrations.registration_key%TYPE;

Line 21: l_registration_key fnd_registrations.registration_key%TYPE;

17: FROM fnd_registrations
18: WHERE registration_key = p_reg_key;
19:
20: l_id NUMBER;
21: l_registration_key fnd_registrations.registration_key%TYPE;
22:
23: BEGIN
24:
25: -- This procedure uses wf_core to generate the registration key.

Line 43: -- the registration key is varchar2(100) in fnd_registrations table

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') ||
46: To_char(p_registration_id) || wf_core.random,1,100);
47:

Line 83: l_registration_key fnd_registrations.registration_key%TYPE;

79: l_reg_type VARCHAR2(10);
80: l_app_id NUMBER;
81:
82: l_registration_id NUMBER;
83: l_registration_key fnd_registrations.registration_key%TYPE;
84: l_supplier_name po_vendors.vendor_name%TYPE;
85: l_return_status VARCHAR2(100);
86:
87: BEGIN

Line 131: UPDATE fnd_registrations SET registration_key = l_registration_key WHERE registration_id = l_registration_id;

127: ROLLBACK TO pos_user_reg_helper_sp1;
128: RETURN;
129: END IF;
130:
131: UPDATE fnd_registrations SET registration_key = l_registration_key WHERE registration_id = l_registration_id;
132:
133: -- create details rows similar to the invite supplier user UI
134: -- Note: some rows are created with null values as in the UI
135: -- Dont think it matters but just to be consistent