1 PACKAGE HZ_USER_PARTY_UTILS AUTHID CURRENT_USER AS
2 /* $Header: ARHUSRPS.pls 120.1 2005/06/16 21:16:16 jhuang noship $ */
3
4 /*=======================================================================+
5 | Declare PUBLIC Data Types and Variables
6 +=======================================================================*/
7
8 /*=======================================================================+
9 | Declare PUBLIC Exceptions
10 +=======================================================================*/
11
12 /*========================================================================
13 | PUBLIC procedure get_user_party_id
14 |
15 | DESCRIPTION
16 | Tries to find a party based on email-address. If party is found
17 | the party id is returned. If the party is NOT found a new party
18 | is created and party id returned.
19 |
20 | PSEUDO CODE/LOGIC
21 |
22 | PARAMETERS
23 | pv_user_name User Name
24 | pv_first_name First Name
25 | pv_last_name Last Name
26 | pv_party_email Email address
27 |
28 | RETURNS
29 | pn_party_id Party Identifier
30 | pv_return_status Return status
31 |
32 | KNOWN ISSUES
33 |
34 | NOTES
35 |
36 | MODIFICATION HISTORY
37 | Date Author Description of Changes
38 | 25-May-2001 J Rautiainen Created
39 *=======================================================================*/
40 PROCEDURE get_user_party_id(pv_user_name IN VARCHAR2,
41 pv_first_name IN VARCHAR2,
42 pv_last_name IN VARCHAR2,
43 pv_email_address IN VARCHAR2,
44 pn_party_id OUT NOCOPY NUMBER,
45 pv_return_status OUT NOCOPY VARCHAR2);
46
47 END HZ_USER_PARTY_UTILS;