1 package FND_REGISTRATION_UTILS_PKG AUTHID CURRENT_USER as
2 /* $Header: AFREGUS.pls 115.6 2003/01/09 00:35:35 bfreeman noship $ */
3
4 /*
5 returns 'Y' if the requested username field is unique against
6 FND_USER.USER_NAME and REQUESTED_USER_NAME
7 where status <> 'REJECTED' in FND_REGISTRATIONS
8
9 Arguement is registration_id for row with requested username to be
10 tested. Will throw exception if registration_id is invalid.
11 */
12 EVENT_SUCCESS CONSTANT VARCHAR2(7) := 'SUCCESS';
13 APPROVAL_WF_ITEM_TYPE CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'APPR_WF_ITEM_TYPE';
14 APPROVAL_WF_ITEM_KEY CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'APPR_WF_ITEM_KEY';
15 INVITATION_WF_ITEM_TYPE CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'INV_WF_ITEM_TYPE';
16 INVITATION_WF_ITEM_KEY CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'INV_WF_ITEM_';
17 REGISTRATION_WF_ITEM_TYPE CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'REG_WF_ITEM_TYPE';
18 REGISTRATION_WF_ITEM_KEY CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'REG_WF_ITEM_KEY';
19 REJECTION_WF_ITEM_TYPE CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'REJ_WF_ITEM_TYPE';
20 REJECTION_WF_ITEM_KEY CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'REJ_WF_ITEM_KEY';
21
22 function is_requested_username_unique(
23 p_username IN VARCHAR2)
24 return VARCHAR2;
25
26 function is_requested_username_unique(
27 p_registration_id IN NUMBER)
28 return VARCHAR2;
29
30 function is_requested_username_unique(
31 p_registration_id IN NUMBER,
32 p_username IN VARCHAR2)
33 return VARCHAR2;
34
35 /*
36 publishes event for registration_id indicating
37 an invitation has occurred, using BES
38 'N' indicates a failure
39 */
40 function publish_invitation_event(
41 p_registration_id IN NUMBER)
42 return VARCHAR2;
43
44 /*
45 publishes event for registration_id indicating
46 a registration has occurred, using BES
47 'N' indicates a failure
48 */
49 function publish_registration_event(
50 p_registration_id IN NUMBER)
51 return VARCHAR2;
52
53 /*
54 publishes event for registration_id indicating
55 an approval has occurred, using BES
56 'N' indicates a failure
57 */
58 function publish_approval_event(
59 p_registration_id IN NUMBER)
60 return VARCHAR2;
61
62 /*
63 publishes event for registration_id indicating
64 an approval has occurred, using BES
65 'N' indicates a failure
66 */
67 function publish_rejection_event(
68 p_registration_id IN NUMBER)
69 return VARCHAR2;
70
71 /*
72 returns a REGISTRATION_ID given a valid registration_key
73 registration_key must be valid or exception occurs
74 */
75 function get_reg_id_from_key(
76 p_registration_key IN VARCHAR2)
77 return NUMBER;
78
79 /*
80 returns a REGISTRATION_KEY given a valid registration_id
81 registration_id must be valid or exception occurs
82 */
83 function get_reg_key_from_id(
84 p_registration_id IN NUMBER)
85 return VARCHAR2;
86
87 /*
88 runs insert_reg (from FND_REGISTRATION_PKG),
89 providing 'INVITE' as the status also calls publish event
90 returns new registration_id
91 */
92 function invite(
93 p_application_id IN NUMBER,
94 p_party_id IN NUMBER,
95 p_registration_type IN VARCHAR2,
96 p_requested_user_name IN VARCHAR2,
97 p_assigned_user_name IN VARCHAR2,
98 p_exists_in_fnd_user_flag IN VARCHAR2,
99 p_user_title IN VARCHAR2,
100 p_first_name IN VARCHAR2,
101 p_middle_name IN VARCHAR2,
102 p_last_name IN VARCHAR2,
103 p_user_suffix IN VARCHAR2,
104 p_email_contact_point_id IN NUMBER,
105 p_email IN VARCHAR2,
106 p_phone_contact_point_id IN NUMBER,
107 p_phone_country_code IN VARCHAR2,
108 p_phone_area_code IN VARCHAR2,
109 p_phone IN VARCHAR2,
110 p_phone_extension IN VARCHAR2,
111 p_fax_contact_point_id IN NUMBER,
112 p_fax_country_code IN VARCHAR2,
113 p_fax_area_code IN VARCHAR2,
114 p_fax IN VARCHAR2,
115 p_fax_extension IN VARCHAR2,
116 p_language_code IN VARCHAR2,
117 p_time_zone IN VARCHAR2,
118 p_territory_code IN VARCHAR2,
119 p_location_id IN NUMBER,
120 p_address1 IN VARCHAR2,
121 p_address2 IN VARCHAR2,
122 p_city IN VARCHAR2,
123 p_state IN VARCHAR2,
124 p_province IN VARCHAR2,
125 p_zip IN VARCHAR2,
126 p_postal_code IN VARCHAR2,
127 p_country IN VARCHAR2,
128 p_reg_details IN fnd_registration_pkg.fnd_reg_details_ref_cursor,
129 x_event_result OUT NOCOPY VARCHAR2)
130 return NUMBER;
131
132 /*
133 runs insert_reg (from FND_REGISTSTRATION_PKG),
134 providing 'REGISTER' as the status also calls publish event
135 returns new registration_id
136 */
137 function register(
138 p_registration_key IN VARCHAR2,
139 p_application_id IN NUMBER,
140 p_party_id IN NUMBER,
141 p_registration_type IN VARCHAR2,
142 p_requested_user_name IN VARCHAR2,
143 p_assigned_user_name IN VARCHAR2,
144 p_registration_status IN VARCHAR2,
145 p_exists_in_fnd_user_flag IN VARCHAR2,
146 p_user_title IN VARCHAR2,
147 p_first_name IN VARCHAR2,
148 p_middle_name IN VARCHAR2,
149 p_last_name IN VARCHAR2,
150 p_user_suffix IN VARCHAR2,
151 p_email_contact_point_id IN NUMBER,
152 p_email IN VARCHAR2,
153 p_phone_contact_point_id IN NUMBER,
154 p_phone_country_code IN VARCHAR2,
155 p_phone_area_code IN VARCHAR2,
156 p_phone IN VARCHAR2,
157 p_phone_extension IN VARCHAR2,
158 p_fax_contact_point_id IN NUMBER,
159 p_fax_country_code IN VARCHAR2,
160 p_fax_area_code IN VARCHAR2,
161 p_fax IN VARCHAR2,
162 p_fax_extension IN VARCHAR2,
163 p_language_code IN VARCHAR2,
164 p_time_zone IN VARCHAR2,
165 p_territory_code IN VARCHAR2,
166 p_location_id IN NUMBER,
167 p_address1 IN VARCHAR2,
168 p_address2 IN VARCHAR2,
169 p_city IN VARCHAR2,
170 p_state IN VARCHAR2,
171 p_province IN VARCHAR2,
172 p_zip IN VARCHAR2,
173 p_postal_code IN VARCHAR2,
174 p_country IN VARCHAR2,
175 p_reg_details IN fnd_registration_pkg.fnd_reg_details_ref_cursor,
176 x_event_result OUT NOCOPY VARCHAR2)
177 return NUMBER;
178
179 /*
180 Updates registration status to 'APPROVED' and publishes
181 approval event using BES
182 */
183 procedure approve(
184 p_registration_id IN NUMBER,
185 x_event_result OUT NOCOPY VARCHAR2);
186
187 /*
188 Updates registration status to 'REJECTED' and publishes
189 rejection event using BES
190 */
191 procedure reject(
192 p_registration_id IN NUMBER,
193 x_event_result OUT NOCOPY VARCHAR2);
194
195 end FND_REGISTRATION_UTILS_PKG;
196