1 PACKAGE PV_USER_MGMT_PVT AUTHID CURRENT_USER as
2 /* $Header: pvxvumms.pls 120.9 2006/01/17 13:10:09 ktsao ship $ */
3
4 G_PARTNER_PERMISSION CONSTANT VARCHAR2(15) := 'PV_PARTNER_USER';
5 G_PRIMARY_PERMISSION VARCHAR2(20) := 'IBE_INT_PRIMARY_USER';
6
7 TYPE Partner_Rec_type IS RECORD
8 (
9 partner_party_id NUMBER(15,0)
10 ,member_type VARCHAR2(30)
11 ,global_prtnr_org_number VARCHAR2(360)
12 );
13
14 TYPE Partner_User_Rec_type IS RECORD
15 (
16 USER_ID NUMBER(15,0)
17 ,PERSON_REL_PARTY_ID NUMBER(15,0)
18 ,USER_NAME VARCHAR2(100)
19 ,USER_TYPE_ID NUMBER
20 );
21
22 TYPE partner_types_Rec_type IS RECORD
23 (
24 partner_type VARCHAR2(30)
25 );
26
27 TYPE partner_types_tbl_type IS TABLE OF partner_types_rec_type INDEX BY BINARY_INTEGER;
28
29
30 PROCEDURE register_partner_and_user
31 (
32 p_api_version_number IN NUMBER
33 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
34 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
35 ,p_partner_rec IN Partner_Rec_type
36 ,P_partner_type IN VARCHAR2
37 ,p_partner_user_rec IN partner_User_rec_type
38 ,x_return_status OUT NOCOPY VARCHAR2
39 ,x_msg_count OUT NOCOPY NUMBER
40 ,x_msg_data OUT NOCOPY VARCHAR2
41 );
42
43
44 PROCEDURE register_partner_user
45 (
46 p_api_version_number IN NUMBER
47 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
48 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
49 ,p_partner_user_rec IN partner_User_rec_type
50 ,x_return_status OUT NOCOPY VARCHAR2
51 ,x_msg_count OUT NOCOPY NUMBER
52 ,x_msg_data OUT NOCOPY VARCHAR2
53 );
54
55
56 PROCEDURE revoke_role
57 (
58 p_api_version_number IN NUMBER
59 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
60 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
61 ,p_role_name IN JTF_VARCHAR2_TABLE_1000
62 ,p_user_name IN VARCHAR2
63 ,x_return_status OUT NOCOPY VARCHAR2
64 ,x_msg_count OUT NOCOPY NUMBER
65 ,x_msg_data OUT NOCOPY VARCHAR2
66 );
67
68 PROCEDURE delete_role
69 (
70 p_api_version_number IN NUMBER
71 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
72 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
73 ,p_role_name IN JTF_VARCHAR2_TABLE_1000
74 ,x_return_status OUT NOCOPY VARCHAR2
75 ,x_msg_count OUT NOCOPY NUMBER
76 ,x_msg_data OUT NOCOPY VARCHAR2
77 );
78
79 PROCEDURE assign_role
80 (
81 p_api_version_number IN NUMBER
82 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
83 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
84 ,p_role_name IN JTF_VARCHAR2_TABLE_1000
85 ,p_user_name IN VARCHAR2
86 ,x_return_status OUT NOCOPY VARCHAR2
87 ,x_msg_count OUT NOCOPY NUMBER
88 ,x_msg_data OUT NOCOPY VARCHAR2
89 );
90
91 PROCEDURE update_role
92 (
93 p_api_version_number IN NUMBER
94 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
95 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
96 ,p_assigned_perms IN JTF_VARCHAR2_TABLE_1000
97 ,p_unassigned_perms IN JTF_VARCHAR2_TABLE_1000
98 ,p_role_name IN VARCHAR2
99 ,x_return_status OUT NOCOPY VARCHAR2
100 ,x_msg_count OUT NOCOPY NUMBER
101 ,x_msg_data OUT NOCOPY VARCHAR2
102 );
103
104 FUNCTION is_partner_user (p_rel_party_id IN NUMBER) RETURN VARCHAR2;
105
106
107 /*+====================================================================
108 | FUNCTION NAME
109 | post_approval
110 |
111 | DESCRIPTION
112 | This function is seeded as a subscription to the approval event
113 |
114 | USAGE
115 | - creates resps and resources when an approval event happens
116 |
117 +======================================================================*/
118
119 FUNCTION post_approval(
120 p_subscription_guid IN RAW,
121 p_event IN OUT NOCOPY wf_event_t)
122 RETURN VARCHAR2;
123
124
125 PROCEDURE update_elig_prgm_4_new_ptnr(
126 p_api_version_number IN NUMBER
127 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
128 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
129 ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
130 ,x_return_status OUT NOCOPY VARCHAR2
131 ,x_msg_count OUT NOCOPY NUMBER
132 ,x_msg_data OUT NOCOPY VARCHAR2
133 ,p_partner_id IN NUMBER
134 ,p_member_type IN VARCHAR2 := null
135 );
136
137
138 END PV_USER_MGMT_PVT;