1 package FND_REGISTRATION_PKG AUTHID CURRENT_USER as
2 /* $Header: AFREGS.pls 120.3 2005/11/04 14:36:10 rsheh noship $ */
3
4 /*
5 This Ref Cursor is used to move around collections of
6 FND_REGISTRATION_DETAILS rows. This is a Ref Cursor instead of
7 a row object to make it accessable from java, which it would not
8 be otherwise
9 */
10 TYPE fnd_reg_details_ref_cursor IS REF CURSOR RETURN fnd_registration_details%ROWTYPE;
11
12 /*
13 Insert row method for FND_REGISTRATIONS
14 RETURNS the new registration_id, generated from FND_REGISTRATIONS_S
15 */
16 function insert_fnd_reg(
17 p_application_id IN NUMBER,
18 p_party_id IN NUMBER,
19 p_registration_type IN VARCHAR2,
20 p_requested_user_name IN VARCHAR2,
21 p_assigned_user_name IN VARCHAR2,
22 p_registration_status IN VARCHAR2,
23 p_exists_in_fnd_user_flag IN VARCHAR2,
24 p_user_title IN VARCHAR2 default null,
25 p_first_name IN VARCHAR2 default null,
26 p_middle_name IN VARCHAR2 default null,
27 p_last_name IN VARCHAR2 default null,
28 p_user_suffix IN VARCHAR2 default null,
29 p_email_contact_point_id IN NUMBER default null,
30 p_email IN VARCHAR2 default null,
31 p_phone_contact_point_id IN NUMBER default null,
32 p_phone_country_code IN VARCHAR2 default null,
33 p_phone_area_code IN VARCHAR2 default null,
34 p_phone IN VARCHAR2 default null,
35 p_phone_extension IN VARCHAR2 default null,
36 p_fax_contact_point_id IN NUMBER default null,
37 p_fax_country_code IN VARCHAR2 default null,
38 p_fax_area_code IN VARCHAR2 default null,
39 p_fax IN VARCHAR2 default null,
40 p_fax_extension IN VARCHAR2 default null,
41 p_language_code IN VARCHAR2 default null,
42 p_time_zone IN VARCHAR2 default null,
43 p_territory_code IN VARCHAR2 default null,
44 p_location_id IN NUMBER default null,
45 p_address1 IN VARCHAR2 default null,
46 p_address2 IN VARCHAR2 default null,
47 p_city IN VARCHAR2 default null,
48 p_state IN VARCHAR2 default null,
49 p_province IN VARCHAR2 default null,
50 p_zip IN VARCHAR2 default null,
51 p_postal_code IN VARCHAR2 default null,
52 p_country IN VARCHAR2 default null)
53 return NUMBER;
54
55 /*
56 Update method for FND_REGISTRATIONS
57 Based on REGISTRATION_ID
58 */
59
60 procedure update_fnd_reg(
61 p_registration_id IN NUMBER,
62 p_application_id IN NUMBER,
63 p_party_id IN NUMBER,
64 p_registration_type IN VARCHAR2,
65 p_requested_user_name IN VARCHAR2,
66 p_assigned_user_name IN VARCHAR2,
67 p_registration_status IN VARCHAR2,
68 p_exists_in_fnd_user_flag IN VARCHAR2,
69 p_user_title IN VARCHAR2 default null,
70 p_first_name IN VARCHAR2 default null,
71 p_middle_name IN VARCHAR2 default null,
72 p_last_name IN VARCHAR2 default null,
73 p_user_suffix IN VARCHAR2 default null,
74 p_email_contact_point_id IN NUMBER default null,
75 p_email IN VARCHAR2 default null,
76 p_phone_contact_point_id IN NUMBER default null,
77 p_phone_country_code IN VARCHAR2 default null,
78 p_phone_area_code IN VARCHAR2 default null,
79 p_phone IN VARCHAR2 default null,
80 p_phone_extension IN VARCHAR2 default null,
81 p_fax_contact_point_id IN NUMBER default null,
82 p_fax_country_code IN VARCHAR2 default null,
83 p_fax_area_code IN VARCHAR2 default null,
84 p_fax IN VARCHAR2 default null,
85 p_fax_extension IN VARCHAR2 default null,
86 p_language_code IN VARCHAR2 default null,
87 p_time_zone IN VARCHAR2 default null,
88 p_territory_code IN VARCHAR2 default null,
89 p_location_id IN NUMBER default null,
90 p_address1 IN VARCHAR2 default null,
91 p_address2 IN VARCHAR2 default null,
92 p_city IN VARCHAR2 default null,
93 p_state IN VARCHAR2 default null,
94 p_province IN VARCHAR2 default null,
95 p_zip IN VARCHAR2 default null,
96 p_postal_code IN VARCHAR2 default null,
97 p_country IN VARCHAR2 default null);
98
99 /*
100 Delete method for FND_REGISTRATIONS
101 Deletes row specified by registration_id
102 */
103 procedure delete_fnd_reg(
104 p_registration_id IN VARCHAR2);
105
106 /*
107 Insert method for FND_REGISTRATION_DETAILS
108 */
109 procedure insert_fnd_reg_details(
110 p_registration_id IN NUMBER,
111 p_application_id IN NUMBER,
112 p_registration_type IN VARCHAR2,
113 p_field_name IN VARCHAR2,
114 p_field_type IN VARCHAR2,
115 p_field_format IN VARCHAR2 default null,
116 p_field_value_string IN VARCHAR2 default null,
117 p_field_value_number IN NUMBER default null,
118 p_field_value_date IN DATE default null);
119
120 /*
121 Update Method for FND_REGISTRATION_DETAILS
122 Updates row specified by REGISTRATION_ID + FIELD_NAME
123 */
124 procedure update_fnd_reg_details(
125 p_registration_id IN NUMBER,
126 p_field_name IN VARCHAR2,
127 p_field_type IN VARCHAR2,
128 p_field_format IN VARCHAR2 default null,
129 p_field_value_string IN VARCHAR2 default null,
130 p_field_value_number IN NUMBER default null,
131 p_field_value_date IN DATE default null);
132
133 /*
134 Delete method for FND_REGISTRATION_DETAILS
135 Updates row specified by REGISTRATION_ID + FIELD_NAME
136 */
137 procedure delete_fnd_reg_details(
138 p_registration_id IN NUMBER,
139 p_field_name IN VARCHAR2);
140
141 /*
142 Updates registration status field only in FND_REGISTRATIONS
143 Given a REGISTRATION_ID
144 */
145 procedure update_reg_status(
146 p_registration_id IN NUMBER,
147 p_new_status IN VARCHAR2);
148
149 /*
150 Updates registraiton status field only in FND_REGISTRATIONS
151 Given a REGISTRATION_KEY
152 */
153 procedure update_reg_status_by_key(
154 p_registration_key IN VARCHAR2,
155 p_new_status IN VARCHAR2);
156
157 /*
158 Updates FND_REGISTRATIONS given a registration_key instead of
159 id
160 */
161 procedure update_fnd_reg_by_key(
162 p_registration_key IN VARCHAR2,
163 p_application_id IN NUMBER,
164 p_party_id IN NUMBER,
165 p_registration_type IN VARCHAR2,
166 p_requested_user_name IN VARCHAR2,
167 p_assigned_user_name IN VARCHAR2,
168 p_registration_status IN VARCHAR2,
169 p_exists_in_fnd_user_flag IN VARCHAR2,
170 p_user_title IN VARCHAR2 default null,
171 p_first_name IN VARCHAR2 default null,
172 p_middle_name IN VARCHAR2 default null,
173 p_last_name IN VARCHAR2 default null,
174 p_user_suffix IN VARCHAR2 default null,
175 p_email_contact_point_id IN NUMBER default null,
176 p_email IN VARCHAR2 default null,
177 p_phone_contact_point_id IN NUMBER default null,
178 p_phone_country_code IN VARCHAR2 default null,
179 p_phone_area_code IN VARCHAR2 default null,
180 p_phone IN VARCHAR2 default null,
181 p_phone_extension IN VARCHAR2 default null,
182 p_fax_contact_point_id IN NUMBER default null,
183 p_fax_country_code IN VARCHAR2 default null,
184 p_fax_area_code IN VARCHAR2 default null,
185 p_fax IN VARCHAR2 default null,
186 p_fax_extension IN VARCHAR2 default null,
187 p_language_code IN VARCHAR2 default null,
188 p_time_zone IN VARCHAR2 default null,
189 p_territory_code IN VARCHAR2 default null,
190 p_location_id IN NUMBER default null,
191 p_address1 IN VARCHAR2 default null,
192 p_address2 IN VARCHAR2 default null,
193 p_city IN VARCHAR2 default null,
194 p_state IN VARCHAR2 default null,
195 p_province IN VARCHAR2 default null,
196 p_zip IN VARCHAR2 default null,
197 p_postal_code IN VARCHAR2 default null,
198 p_country IN VARCHAR2 default null);
199
200 /*
201 Deletes a row from FND_REGISTRATIONS given a REGISTRATION_KEY
202 rather than a registration_id
203 */
204 procedure delete_fnd_reg_by_key(
205 p_registration_key IN VARCHAR2);
206
207 /*
208 Inserts a row in FND_REGISTRATIONS and some number of rows in
209 FND_REGISTRATION_DETAILS.
210 Caller needs to ensure that the cursor of details is not NULL
211 (it can be empty).
212 Returns the new registration_id generated from FND_REGISTRATIONS_S
213 */
214 function insert_reg(
215 p_application_id IN NUMBER,
216 p_party_id IN NUMBER,
217 p_registration_type IN VARCHAR2,
218 p_requested_user_name IN VARCHAR2,
219 p_assigned_user_name IN VARCHAR2,
220 p_registration_status IN VARCHAR2,
221 p_exists_in_fnd_user_flag IN VARCHAR2,
222 p_reg_details IN fnd_reg_details_ref_cursor,
223 p_user_title IN VARCHAR2 default null,
224 p_first_name IN VARCHAR2 default null,
225 p_middle_name IN VARCHAR2 default null,
226 p_last_name IN VARCHAR2 default null,
227 p_user_suffix IN VARCHAR2 default null,
228 p_email_contact_point_id IN NUMBER default null,
229 p_email IN VARCHAR2 default null,
230 p_phone_contact_point_id IN NUMBER default null,
231 p_phone_country_code IN VARCHAR2 default null,
232 p_phone_area_code IN VARCHAR2 default null,
233 p_phone IN VARCHAR2 default null,
234 p_phone_extension IN VARCHAR2 default null,
235 p_fax_contact_point_id IN NUMBER default null,
236 p_fax_country_code IN VARCHAR2 default null,
237 p_fax_area_code IN VARCHAR2 default null,
238 p_fax IN VARCHAR2 default null,
239 p_fax_extension IN VARCHAR2 default null,
240 p_language_code IN VARCHAR2 default null,
241 p_time_zone IN VARCHAR2 default null,
242 p_territory_code IN VARCHAR2 default null,
243 p_location_id IN NUMBER default null,
244 p_address1 IN VARCHAR2 default null,
245 p_address2 IN VARCHAR2 default null,
246 p_city IN VARCHAR2 default null,
247 p_state IN VARCHAR2 default null,
248 p_province IN VARCHAR2 default null,
249 p_zip IN VARCHAR2 default null,
250 p_postal_code IN VARCHAR2 default null,
251 p_country IN VARCHAR2 default null)
252 return NUMBER;
253
254 /*
255 Updates both FND_REGISTRATIONS and FND_REGISTRATION_DETAILS
256 The RefCursor should be not null
257 */
258 procedure update_reg(
259 p_registration_id IN VARCHAR2,
260 p_application_id IN NUMBER,
261 p_party_id IN NUMBER,
262 p_registration_type IN VARCHAR2,
263 p_requested_user_name IN VARCHAR2,
264 p_assigned_user_name IN VARCHAR2,
265 p_registration_status IN VARCHAR2,
266 p_exists_in_fnd_user_flag IN VARCHAR2,
267 p_reg_details IN fnd_reg_details_ref_cursor,
268 p_user_title IN VARCHAR2 default null,
269 p_first_name IN VARCHAR2 default null,
270 p_middle_name IN VARCHAR2 default null,
271 p_last_name IN VARCHAR2 default null,
272 p_user_suffix IN VARCHAR2 default null,
273 p_email_contact_point_id IN NUMBER default null,
274 p_email IN VARCHAR2 default null,
275 p_phone_contact_point_id IN NUMBER default null,
276 p_phone_country_code IN VARCHAR2 default null,
277 p_phone_area_code IN VARCHAR2 default null,
278 p_phone IN VARCHAR2 default null,
279 p_phone_extension IN VARCHAR2 default null,
280 p_fax_contact_point_id IN NUMBER default null,
281 p_fax_country_code IN VARCHAR2 default null,
282 p_fax_area_code IN VARCHAR2 default null,
283 p_fax IN VARCHAR2 default null,
284 p_fax_extension IN VARCHAR2 default null,
285 p_language_code IN VARCHAR2 default null,
286 p_time_zone IN VARCHAR2 default null,
287 p_territory_code IN VARCHAR2 default null,
288 p_location_id IN NUMBER default null,
289 p_address1 IN VARCHAR2 default null,
290 p_address2 IN VARCHAR2 default null,
291 p_city IN VARCHAR2 default null,
292 p_state IN VARCHAR2 default null,
293 p_province IN VARCHAR2 default null,
294 p_zip IN VARCHAR2 default null,
295 p_postal_code IN VARCHAR2 default null,
296 p_country IN VARCHAR2 default null);
297
298 /*
299 Updates FND_REGISTRATIONS and FND_REGISTRATION_DETAILS
300 using the registration_key as the PK rather than the registration_id
301 */
302 procedure update_reg_by_key(
303 p_registration_key IN VARCHAR2,
304 p_application_id IN NUMBER,
305 p_party_id IN NUMBER,
306 p_registration_type IN VARCHAR2,
307 p_requested_user_name IN VARCHAR2,
308 p_assigned_user_name IN VARCHAR2,
309 p_registration_status IN VARCHAR2,
310 p_exists_in_fnd_user_flag IN VARCHAR2,
311 p_reg_details IN fnd_reg_details_ref_cursor,
312 p_user_title IN VARCHAR2 default null,
316 p_user_suffix IN VARCHAR2 default null,
313 p_first_name IN VARCHAR2 default null,
314 p_middle_name IN VARCHAR2 default null,
315 p_last_name IN VARCHAR2 default null,
317 p_email_contact_point_id IN NUMBER default null,
318 p_email IN VARCHAR2 default null,
319 p_phone_contact_point_id IN NUMBER default null,
320 p_phone_country_code IN VARCHAR2 default null,
321 p_phone_area_code IN VARCHAR2 default null,
322 p_phone IN VARCHAR2 default null,
323 p_phone_extension IN VARCHAR2 default null,
324 p_fax_contact_point_id IN NUMBER default null,
325 p_fax_country_code IN VARCHAR2 default null,
326 p_fax_area_code IN VARCHAR2 default null,
327 p_fax IN VARCHAR2 default null,
328 p_fax_extension IN VARCHAR2 default null,
329 p_language_code IN VARCHAR2 default null,
330 p_time_zone IN VARCHAR2 default null,
331 p_territory_code IN VARCHAR2 default null,
332 p_location_id IN NUMBER default null,
333 p_address1 IN VARCHAR2 default null,
334 p_address2 IN VARCHAR2 default null,
335 p_city IN VARCHAR2 default null,
336 p_state IN VARCHAR2 default null,
337 p_province IN VARCHAR2 default null,
338 p_zip IN VARCHAR2 default null,
339 p_postal_code IN VARCHAR2 default null,
340 p_country IN VARCHAR2 default null);
341
342 /*
343 Deletes an entire registration, from both FND_REGISTRATIONS
344 and FND_REGISTRATION_DETAILS, given a registration_id
345 */
346 procedure delete_reg(
347 p_registration_id IN NUMBER);
348
349 /*
350 Deletes an entire registration, from both FND_REGISTRATIONS
351 and FND_REGISTRATION_DETAILS, given a registration_key
352 */
353 procedure delete_reg_by_key(
354 p_registration_key IN VARCHAR2);
355
356 /*
357 Retrieves a row from FND_REGISTRATIONS
358 */
359 procedure retrieve_fnd_reg(
360 p_registration_id IN NUMBER,
361 x_application_id OUT nocopy NUMBER,
362 x_party_id OUT nocopy NUMBER,
363 x_registration_type OUT nocopy VARCHAR2,
364 x_requested_user_name OUT nocopy VARCHAR2,
365 x_assigned_user_name OUT nocopy VARCHAR2,
366 x_registration_status OUT nocopy VARCHAR2,
367 x_exists_in_fnd_user_flag OUT nocopy VARCHAR2,
368 x_user_title OUT nocopy VARCHAR2,
369 x_first_name OUT nocopy VARCHAR2,
370 x_middle_name OUT nocopy VARCHAR2,
371 x_last_name OUT nocopy VARCHAR2,
372 x_user_suffix OUT nocopy VARCHAR2,
373 x_email_contact_point_id OUT nocopy NUMBER,
374 x_email OUT nocopy VARCHAR2,
375 x_phone_contact_point_id OUT nocopy NUMBER,
376 x_phone_country_code OUT nocopy VARCHAR2,
377 x_phone_area_code OUT nocopy VARCHAR2,
378 x_phone OUT nocopy VARCHAR2,
379 x_phone_extension OUT nocopy VARCHAR2,
380 x_fax_contact_point_id OUT nocopy NUMBER,
381 x_fax_country_code OUT nocopy VARCHAR2,
382 x_fax_area_code OUT nocopy VARCHAR2,
383 x_fax OUT nocopy VARCHAR2,
384 x_fax_extension OUT nocopy VARCHAR2,
385 x_language_code OUT nocopy VARCHAR2,
386 x_time_zone OUT nocopy VARCHAR2,
387 x_territory_code OUT nocopy VARCHAR2,
388 x_location_id OUT nocopy NUMBER,
389 x_address1 OUT nocopy VARCHAR2,
390 x_address2 OUT nocopy VARCHAR2,
391 x_city OUT nocopy VARCHAR2,
392 x_state OUT nocopy VARCHAR2,
393 x_province OUT nocopy VARCHAR2,
394 x_zip OUT nocopy VARCHAR2,
395 x_postal_code OUT nocopy VARCHAR2,
396 x_country OUT nocopy VARCHAR2);
397
398 /*
399 Retrieves a row from FND_REGISTRATION_DETAILS
400 */
401 procedure retrieve_fnd_reg_details(
402 p_registration_id IN NUMBER,
403 p_field_name IN VARCHAR2,
404 x_field_type OUT nocopy VARCHAR2,
405 x_field_format OUT nocopy VARCHAR2,
406 x_field_value_string OUT nocopy VARCHAR2,
407 x_field_value_number OUT nocopy NUMBER,
408 x_field_value_date OUT nocopy DATE);
409
410 /*
411 Retrieves the relevant row from FND_REGISTRATIONS;
412 Also retrieves a cursor with the related details
413 */
414 procedure retrieve_reg(
415 p_registration_id IN NUMBER,
416 x_application_id OUT nocopy NUMBER,
420 x_assigned_user_name OUT nocopy VARCHAR2,
417 x_party_id OUT nocopy NUMBER,
418 x_registration_type OUT nocopy VARCHAR2,
419 x_requested_user_name OUT nocopy VARCHAR2,
421 x_registration_status OUT nocopy VARCHAR2,
422 x_exists_in_fnd_user_flag OUT nocopy VARCHAR2,
423 x_user_title OUT nocopy VARCHAR2,
424 x_first_name OUT nocopy VARCHAR2,
425 x_middle_name OUT nocopy VARCHAR2,
426 x_last_name OUT nocopy VARCHAR2,
427 x_user_suffix OUT nocopy VARCHAR2,
428 x_email_contact_point_id OUT nocopy NUMBER,
429 x_email OUT nocopy VARCHAR2,
430 x_phone_contact_point_id OUT nocopy NUMBER,
431 x_phone_country_code OUT nocopy VARCHAR2,
432 x_phone_area_code OUT nocopy VARCHAR2,
433 x_phone OUT nocopy VARCHAR2,
434 x_phone_extension OUT nocopy VARCHAR2,
435 x_fax_contact_point_id OUT nocopy NUMBER,
436 x_fax_country_code OUT nocopy VARCHAR2,
437 x_fax_area_code OUT nocopy VARCHAR2,
438 x_fax OUT nocopy VARCHAR2,
439 x_fax_extension OUT nocopy VARCHAR2,
440 x_language_code OUT nocopy VARCHAR2,
441 x_time_zone OUT nocopy VARCHAR2,
442 x_territory_code OUT nocopy VARCHAR2,
443 x_location_id OUT nocopy NUMBER,
444 x_address1 OUT nocopy VARCHAR2,
445 x_address2 OUT nocopy VARCHAR2,
446 x_city OUT nocopy VARCHAR2,
447 x_state OUT nocopy VARCHAR2,
448 x_province OUT nocopy VARCHAR2,
449 x_zip OUT nocopy VARCHAR2,
450 x_postal_code OUT nocopy VARCHAR2,
451 x_country OUT nocopy VARCHAR2,
452 x_reg_details OUT nocopy fnd_reg_details_ref_cursor);
453
454 /*
455 Retrieves a registration including data from both
456 FND_REGISTRATIONS and FND_REGISTRATION_DETAILS, but
457 uses a registration_key instead of a registration_id
458 */
459 procedure retrieve_invited_reg(
460 p_registration_key IN VARCHAR2,
461 x_application_id OUT nocopy NUMBER,
462 x_party_id OUT nocopy NUMBER,
463 x_registration_type OUT nocopy VARCHAR2,
464 x_requested_user_name OUT nocopy VARCHAR2,
465 x_assigned_user_name OUT nocopy VARCHAR2,
466 x_registration_status OUT nocopy VARCHAR2,
467 x_exists_in_fnd_user_flag OUT nocopy VARCHAR2,
468 x_user_title OUT nocopy VARCHAR2,
469 x_first_name OUT nocopy VARCHAR2,
470 x_middle_name OUT nocopy VARCHAR2,
471 x_last_name OUT nocopy VARCHAR2,
472 x_user_suffix OUT nocopy VARCHAR2,
473 x_email_contact_point_id OUT nocopy NUMBER,
474 x_email OUT nocopy VARCHAR2,
475 x_phone_contact_point_id OUT nocopy NUMBER,
476 x_phone_country_code OUT nocopy VARCHAR2,
477 x_phone_area_code OUT nocopy VARCHAR2,
478 x_phone OUT nocopy VARCHAR2,
479 x_phone_extension OUT nocopy VARCHAR2,
480 x_fax_contact_point_id OUT nocopy NUMBER,
481 x_fax_country_code OUT nocopy VARCHAR2,
482 x_fax_area_code OUT nocopy VARCHAR2,
483 x_fax OUT nocopy VARCHAR2,
484 x_fax_extension OUT nocopy VARCHAR2,
485 x_language_code OUT nocopy VARCHAR2,
486 x_time_zone OUT nocopy VARCHAR2,
487 x_territory_code OUT nocopy VARCHAR2,
488 x_location_id OUT nocopy NUMBER,
489 x_address1 OUT nocopy VARCHAR2,
490 x_address2 OUT nocopy VARCHAR2,
491 x_city OUT nocopy VARCHAR2,
492 x_state OUT nocopy VARCHAR2,
493 x_province OUT nocopy VARCHAR2,
494 x_zip OUT nocopy VARCHAR2,
495 x_postal_code OUT nocopy VARCHAR2,
496 x_country OUT nocopy VARCHAR2,
497 x_reg_details OUT nocopy fnd_reg_details_ref_cursor);
498
499 /*
500 Retrieves an active registration (including details) given
501 a username, application_id, and registration_type.
502 NB: There should be no more that one registration not in status
503 'REJECTED' with this triple.
504 NB: An active registration is one which is not 'REJECTED'
505 */
506 procedure retrieve_reg_by_username(
507 p_assigned_user_name IN VARCHAR2,
508 p_application_id IN NUMBER,
509 p_registration_type IN VARCHAR2,
510 x_party_id OUT nocopy NUMBER,
511 x_registration_status OUT nocopy VARCHAR2,
515 x_middle_name OUT nocopy VARCHAR2,
512 x_exists_in_fnd_user_flag OUT nocopy VARCHAR2,
513 x_user_title OUT nocopy VARCHAR2,
514 x_first_name OUT nocopy VARCHAR2,
516 x_last_name OUT nocopy VARCHAR2,
517 x_user_suffix OUT nocopy VARCHAR2,
518 x_email_contact_point_id OUT nocopy NUMBER,
519 x_email OUT nocopy VARCHAR2,
520 x_phone_contact_point_id OUT nocopy NUMBER,
521 x_phone_country_code OUT nocopy VARCHAR2,
522 x_phone_area_code OUT nocopy VARCHAR2,
523 x_phone OUT nocopy VARCHAR2,
524 x_phone_extension OUT nocopy VARCHAR2,
525 x_fax_contact_point_id OUT nocopy NUMBER,
526 x_fax_country_code OUT nocopy VARCHAR2,
527 x_fax_area_code OUT nocopy VARCHAR2,
528 x_fax OUT nocopy VARCHAR2,
529 x_fax_extension OUT nocopy VARCHAR2,
530 x_language_code OUT nocopy VARCHAR2,
531 x_time_zone OUT nocopy VARCHAR2,
532 x_territory_code OUT nocopy VARCHAR2,
533 x_location_id OUT nocopy NUMBER,
534 x_address1 OUT nocopy VARCHAR2,
535 x_address2 OUT nocopy VARCHAR2,
536 x_city OUT nocopy VARCHAR2,
537 x_state OUT nocopy VARCHAR2,
538 x_province OUT nocopy VARCHAR2,
539 x_zip OUT nocopy VARCHAR2,
540 x_postal_code OUT nocopy VARCHAR2,
541 x_country OUT nocopy VARCHAR2,
542 x_reg_details OUT nocopy fnd_reg_details_ref_cursor);
543
544 /*
545 Similar to retrieve_reg_by_user_name, but using party_id
546 instead of user_name. Once again, there should be no more than
547 one active registration with this triple, or an exception will be
548 thrown
549 */
550 procedure retrieve_reg_by_party_id(
551 p_party_id IN NUMBER,
552 p_application_id IN NUMBER,
553 P_registration_type IN VARCHAR2,
554 x_requested_user_name OUT nocopy VARCHAR2,
555 x_assigned_user_name OUT nocopy VARCHAR2,
556 x_registration_status OUT nocopy VARCHAR2,
557 x_exists_in_fnd_user_flag OUT nocopy VARCHAR2,
558 x_user_title OUT nocopy VARCHAR2,
559 x_first_name OUT nocopy VARCHAR2,
560 x_middle_name OUT nocopy VARCHAR2,
561 x_last_name OUT nocopy VARCHAR2,
562 x_user_suffix OUT nocopy VARCHAR2,
563 x_email_contact_point_id OUT nocopy NUMBER,
564 x_email OUT nocopy VARCHAR2,
565 x_phone_contact_point_id OUT nocopy NUMBER,
566 x_phone_country_code OUT nocopy VARCHAR2,
567 x_phone_area_code OUT nocopy VARCHAR2,
568 x_phone OUT nocopy VARCHAR2,
569 x_phone_extension OUT nocopy VARCHAR2,
570 x_fax_contact_point_id OUT nocopy NUMBER,
571 x_fax_country_code OUT nocopy VARCHAR2,
572 x_fax_area_code OUT nocopy VARCHAR2,
573 x_fax OUT nocopy VARCHAR2,
574 x_fax_extension OUT nocopy VARCHAR2,
575 x_language_code OUT nocopy VARCHAR2,
576 x_time_zone OUT nocopy VARCHAR2,
577 x_territory_code OUT nocopy VARCHAR2,
578 x_location_id OUT nocopy NUMBER,
579 x_address1 OUT nocopy VARCHAR2,
580 x_address2 OUT nocopy VARCHAR2,
581 x_city OUT nocopy VARCHAR2,
582 x_state OUT nocopy VARCHAR2,
583 x_province OUT nocopy VARCHAR2,
584 x_zip OUT nocopy VARCHAR2,
585 x_postal_code OUT nocopy VARCHAR2,
586 x_country OUT nocopy VARCHAR2,
587 x_reg_details OUT nocopy fnd_reg_details_ref_cursor);
588
589 /*
590 looks up the registration_id for a given registration_key.
591 Returns the REGISTRATION_ID for that key; will throw an exception
592 if the key is not in use
593 */
594 function get_registration_id_from_key(
595 p_registration_key IN VARCHAR2)
596 return NUMBER;
597
598 /*
599 looks up the registration_key for a given registration_id.
600 Returns the REGISTRATION_KEY for that id; will throw an exception
601 if the id is not in use
602 */
603 function get_registration_key_from_id(
604 p_registration_id IN NUMBER)
605 return VARCHAR2;
606
607 end FND_REGISTRATION_PKG;
608