1 PACKAGE JTF_UM_USER_ADMIN_PVT AUTHID CURRENT_USER as
2 /* $Header: JTFVUUAS.pls 115.5 2002/11/21 22:57:49 kching ship $ */
3
4 /**
5 * Procedure : INACTIVE_USER
6 * Type : Private
7 * Pre_reqs : WF_DIRECTORY.CreateAdHocUser and
8 * WF_DIRECTORY.SetAdHocUserAttr
9 * Description : Inactive an user with these Scenarios
10 * 1. Usertype Request is PENDING
11 * - call FND_USER_PKG.DisableUser API
12 * - Kill the usertype WF
13 * - Set the usertype_reg table status to REJECTED
14 * - Find all the *PENDING* Enrollments, and REJECT these
15 * (believe we have a USERTYPE_REJECTED status or similar)
16 * in the subscription_reg table
17 * - revoke the "PENDING_APPROVAL" responsibility
18 *
19 * 2. Usertype Request is UPGRADE_PENDING
20 * - call FND_USER_PKG.DisableUser API
21 * - Set the usertype_reg table status to REJECTED
22 * - Reject the old approval task
23 *
24 * 3. Usertype Request is APPROVED or UPGRADE
25 * - call FND_USER_PKG.DisableUser API
26 * - Do not set the usertype_reg table status (leave as APPROVED)
27 * - Find all the *PENDING* Enrollments, and REJECT these (REJECTED status)
28 * in the subscription_reg table
29 * - Do not change the status for any approved / rejected enrollments
30 * Parameters :
31 * input parameters
32 * p_username
33 * description: The inactive username.
34 * required : Y
35 * output parameters
36 * Errors : possible errors raised by this API
37 * Other Comments :
38 */
39 PROCEDURE INACTIVE_USER (p_api_version_number in number,
40 p_init_msg_list in varchar2 default FND_API.G_FALSE,
41 p_commit in varchar2 default FND_API.G_FALSE,
42 p_validation_level in number default FND_API.G_VALID_LEVEL_FULL,
43 p_username in varchar2,
44 x_return_status out NOCOPY varchar2,
45 x_msg_data out NOCOPY varchar2,
46 x_msg_count out NOCOPY number);
47
48 /**
49 * This API creates an entry into the jtf_usertype_reg table. It also sets the
50 * responsibility to "pending". If approval is required a workflow is initiated
51 * if not the credentials are assigned.
52 */
53
54 PROCEDURE Create_System_User(p_username in varchar2,
55 p_usertype_id in number,
56 p_user_id in number,
57 x_user_reg_id out NOCOPY number,
58 x_approval_id out NOCOPY number);
59
60 end JTF_UM_USER_ADMIN_PVT;