1 PACKAGE IBE_USER_PVT AUTHID CURRENT_USER AS
2 /* $Header: IBEVUSRS.pls 120.3 2005/08/29 09:26:24 appldev ship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBE_USER_PVT';
5
6 null_char varchar2(8) := '*NULL*';
7 null_date date := to_date('2', 'J');
8 null_number number := -999;
9
10
11 /*+====================================================================
12 | PROCEDURE NAME
13 | Create_User
14 |
15 | DESCRIPTION
16 | This API is called by Create_Person,
17 | Create_Organization
18 | USAGE
19 | - Creates FND USer
20 |
21 | REFERENCED APIS
22 | This API calls the following APIs
23 | - FND_USER_PKG.Create_User
24 +======================================================================*/
25 Procedure Create_User(
26 p_user_name IN VARCHAR2,
27 p_password IN VARCHAR2,
28 p_start_date IN DATE,
29 p_end_date IN DATE,
30 p_password_date IN DATE,
31 p_email_address IN VARCHAR2,
32 p_customer_id IN NUMBER,
33 x_user_id OUT NOCOPY NUMBER );
34
35
36 /*+====================================================================
37 | PROCEDURE NAME
38 | Update_User
39 |
40 | DESCRIPTION
41 | This API is called by User Management to map a new Contact to the User Name
42 |
43 | USAGE
44 | - Updates FND User - Contact Mapping
45 |
46 | REFERENCED APIS
47 | This API calls the following APIs
48 | - FND_USER_PKG.UpdateUser
49 +======================================================================*/
50
51 Procedure Update_User(
52 p_user_name IN VARCHAR2,
53 p_password IN VARCHAR2,
54 p_start_date IN DATE,
55 p_end_date IN DATE,
56 p_old_password IN VARCHAR2,
57 p_party_id IN NUMBER
58 );
59
60
61 /*+====================================================================
62 | PROCEDURE NAME
63 | Create_User
64 |
65 | DESCRIPTION
66 | This API is called by while revoking sites from user in User Management
67 |
68 | USAGE
69 | - This API calls FND_USER_RESP_GROUPS_API and end dates the responsibility
70 |
71 | REFERENCED APIS
72 | This API calls the following APIs
73 | - FND_USER_RESP_GROUPS_API.update_assignmets
74 +======================================================================*/
75 Procedure Update_Assignment(
76 p_user_id IN NUMBER,
77 p_responsibility_id IN NUMBER,
78 p_resp_application_id IN NUMBER,
79 p_security_group_id IN NUMBER default null,
80 p_start_date IN DATE default null,
81 p_end_date IN DATE,
82 p_description IN VARCHAR2 default null);
83
84
85 /*+====================================================================
86 | FUNCTION NAME
87 | TestUserName
88 |
89 | DESCRIPTION
90 | This api test whether a username exists in FND and/or in OID.
91 |
92 | USAGE
93 | - This API is called for validating the username ion Registration
94 |
95 | REFERENCED APIS
96 | This API calls the following APIs
97 | - FND_USER_PKG.TestUserName
98 +======================================================================*/
99
100
101 function TestUserName(p_user_name in varchar2) return pls_integer;
102
103 end ibe_user_pvt;