APPS.FND_REGISTRATION_UTILS_PKG dependencies on FND_REGISTRATIONS

Line 26: FROM fnd_registrations

22:
23: -- determine if there is a non-rejected duplicate requested_user_name
24: SELECT count(*)
25: INTO l_duplicates
26: FROM fnd_registrations
27: WHERE requested_user_name = p_username
28: AND registration_status IN('REGISTERED')
29: AND rownum = 1;
30:

Line 52: FROM fnd_registrations

48:
49: -- lookup requested_user_name for given registration_id
50: SELECT requested_user_name
51: INTO l_username
52: FROM fnd_registrations
53: WHERE registration_id = p_registration_id;
54:
55: -- determine if a duplicate username exists
56: -- trying to do this as quickly as possible, but I find using

Line 71: FROM fnd_registrations

67:
68: -- determine if there is a non-rejected duplicate requested_user_name
69: SELECT count(*)
70: INTO l_duplicates
71: FROM fnd_registrations
72: WHERE requested_user_name = l_username
73: AND registration_status <> 'REJECTED'
74: AND rownum = 1;
75:

Line 107: FROM fnd_registrations

103:
104: -- determine if there is a non-rejected duplicate requested_user_name
105: SELECT count(*)
106: INTO l_duplicates
107: FROM fnd_registrations
108: WHERE requested_user_name = p_username
109: AND registration_status IN('REGISTERED')
110: AND registration_id <> p_registration_id
111: AND rownum = 1;

Line 132: lv_reg_type FND_REGISTRATIONS.REGISTRATION_TYPE%TYPE;

128:
129: l_registration_key VARCHAR2(255);
130: l_event_name VARCHAR2(255);
131: l_param_list WF_PARAMETER_LIST_T := wf_parameter_list_t();
132: lv_reg_type FND_REGISTRATIONS.REGISTRATION_TYPE%TYPE;
133: ln_application_id FND_REGISTRATIONS.APPLICATION_ID%TYPE;
134:
135: l_error_message VARCHAR2(4000);
136:

Line 133: ln_application_id FND_REGISTRATIONS.APPLICATION_ID%TYPE;

129: l_registration_key VARCHAR2(255);
130: l_event_name VARCHAR2(255);
131: l_param_list WF_PARAMETER_LIST_T := wf_parameter_list_t();
132: lv_reg_type FND_REGISTRATIONS.REGISTRATION_TYPE%TYPE;
133: ln_application_id FND_REGISTRATIONS.APPLICATION_ID%TYPE;
134:
135: l_error_message VARCHAR2(4000);
136:
137: BEGIN

Line 143: FROM fnd_registrations

139: l_registration_key := get_reg_key_from_id(p_registration_id);
140:
141: SELECT application_id, registration_type
142: INTO ln_application_id, lv_reg_type
143: FROM fnd_registrations
144: WHERE registration_id = p_registration_id;
145:
146: -- populate parameter list for event
147: wf_event.AddParameterToList( p_name => 'REGISTRATION_KEY',

Line 235: FROM fnd_registrations

231: l_registration_id NUMBER;
232: BEGIN
233: SELECT registration_id
234: INTO l_registration_id
235: FROM fnd_registrations
236: WHERE registration_key = p_registration_key;
237:
238: return l_registration_id;
239:

Line 250: FROM fnd_registrations

246: l_registration_key VARCHAR2(255);
247: BEGIN
248: SELECT registration_key
249: INTO l_registration_key
250: FROM fnd_registrations
251: WHERE registration_id = p_registration_id;
252: return l_registration_key;
253:
254: END get_reg_key_from_id;