1 PACKAGE PVX_Misc_PVT AUTHID CURRENT_USER AS
2 /* $Header: pvxvmiss.pls 120.0.12000000.2 2007/07/24 00:09:20 hekkiral ship $ */
3
4 /* ADMIN RECORD*/
5 TYPE admin_rec_type IS RECORD
6 (
7 partner_profile_id NUMBER DEFAULT NULL -- Partner profile
8 ,logged_resource_id NUMBER DEFAULT NULL -- Logged user
9 ,cm_id NUMBER DEFAULT NULL -- Channel Manager
10 ,ph_support_rep NUMBER DEFAULT NULL -- Phone Support Rep
11 ,cmm_id NUMBER DEFAULT NULL -- Channel Marketing Manager
12 ,partner_id NUMBER DEFAULT NULL -- Party_ID in the HZ_Party_RelationShip, use it as source_id for resource creation
13 ,partner_relationship_id NUMBER DEFAULT NULL -- Relationship_ID of the relationship
14 ,contact_id NUMBER DEFAULT NULL -- Contact_ID for the resource
15 ,user_id NUMBER DEFAULT NULL -- user_id for resource creation
16 ,resource_type VARCHAR2(30) DEFAULT NULL -- Type of resource
17 ,role_resource_id NUMBER DEFAULT NULL -- Resource for which the role is to be related
18 ,role_resource_type VARCHAR2(30) DEFAULT NULL -- Resource type for which the role is to be related
19 ,role_code VARCHAR2(30) DEFAULT NULL -- Role code to which the role_resource_id is to be related
20 ,resource_number VARCHAR2(30) DEFAULT NULL -- Resource number
21 ,group_id NUMBER DEFAULT NULL -- Group_ID
22 ,group_number VARCHAR2(30) DEFAULT NULL -- Group_Number
23 ,group_usage VARCHAR2(240) DEFAULT 'PRM' -- Group Usage
24 ,source_name VARCHAR2(360) DEFAULT NULL -- Source Name (Must while creating resource)
25 ,resource_name VARCHAR2(360) DEFAULT NULL -- Resource Name
26 ,source_org_name VARCHAR2(360) DEFAULT NULL -- Organization Name
27 ,source_org_id NUMBER DEFAULT NULL -- Organization relationship id
28 ,user_name VARCHAR2(100) DEFAULT NULL -- User Name
29 ,source_first_name VARCHAR2(360) DEFAULT NULL -- First Name
30 ,source_middle_name VARCHAR2(360) DEFAULT NULL -- Middle Name
31 ,source_last_name VARCHAR2(360) DEFAULT NULL -- Last Name
32 ,party_site_id NUMBER DEFAULT NULL -- Party Site ID for the address
33 ,object_version_number NUMBER DEFAULT 1 -- Object version number
34 );
35
36
37 /* FND RECORD*/
38 TYPE fnd_rec_type IS RECORD
39 (
40 user_id NUMBER DEFAULT NULL
41 ,user_name VARCHAR2(100) DEFAULT NULL
42 ,owner VARCHAR2(100) DEFAULT NULL
43 ,start_date DATE DEFAULT NULL
44 ,end_date DATE DEFAULT NULL
45 ,email_address VARCHAR2(240) DEFAULT NULL
46 ,resp_app_short_name VARCHAR2(100) DEFAULT NULL
47 ,resp_key VARCHAR2(30) DEFAULT NULL
48 ,security_group VARCHAR2(100) DEFAULT NULL
49 ,resp_id NUMBER DEFAULT NULL
50 ,resp_app_id NUMBER DEFAULT NULL
51 );
52
53 ---------------------------------------------------------------------
54 -- PROCEDURE
55 -- Admin_Access
56 --
57 -- PURPOSE
58 -- Create/delete/update access for the specified sales_force_id.
59 --
60 -- PARAMETERS
61 -- p_admin_rec: the new record to be administered
62 -- x_access_id: return the access_id
63 --
64 -- NOTES
65 -- 1. object_version_number will be set to 1.
66 -- 2. Please don't pass in any FND_API.g_mess_char/num/date.
67 ---------------------------------------------------------------------
68 PROCEDURE Admin_Access(
69 p_api_version IN NUMBER
70 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
71 ,p_commit IN VARCHAR2 := FND_API.g_false
72 ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
73
74 ,x_return_status OUT NOCOPY VARCHAR2
75 ,x_msg_count OUT NOCOPY NUMBER
76 ,x_msg_data OUT NOCOPY VARCHAR2
77
78 ,p_admin_rec IN admin_rec_type
79 ,p_mode IN VARCHAR2 := FND_API.G_MISS_CHAR
80 ,x_access_id OUT NOCOPY NUMBER
81 );
82
83
84 --------------------------------------------------------------------
85 -- PROCEDURE
86 -- Admin_Resource
87 --
88 -- PURPOSE
89 -- Create a resource for the party_id of Relationship in the HZ_PARTY_RELATIONSHIPS
90 --
91 -- PARAMETERS
92 -- p_admin_rec: the new record to be administered
93 -- x_resource_id: return the x_resource_id
94 --
95 -- NOTES
96 -- 1. Raise exception if the object_version_number doesn't match.
97 --------------------------------------------------------------------
98 PROCEDURE Admin_Resource(
99 p_api_version IN NUMBER
100 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
101 ,p_commit IN VARCHAR2 := FND_API.g_false
102
103 ,x_return_status OUT NOCOPY VARCHAR2
104 ,x_msg_count OUT NOCOPY NUMBER
105 ,x_msg_data OUT NOCOPY VARCHAR2
106
107 ,p_admin_rec IN admin_rec_type
108 ,p_mode IN VARCHAR2 := FND_API.G_MISS_CHAR
109 ,x_resource_id OUT NOCOPY NUMBER
110 ,x_resource_number OUT NOCOPY VARCHAR2
111 );
112
113
114 -------------------------------------------------------------------
115 -- PROCEDURE
116 -- Admin_Role
117 --
118 -- PURPOSE
119 -- Create a Role
120 --
121 -- PARAMETERS
122 -- p_admin_rec: the new record to be administered
123 -- x_role_relate_id: return the x_role_relate_id
124 --
125 -- NOTES
126 -- 1. Raise exception if the object_version_number doesn't match.
127 --------------------------------------------------------------------
128 PROCEDURE Admin_Role(
129 p_api_version IN NUMBER
130 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
131 ,p_commit IN VARCHAR2 := FND_API.g_false
132
133 ,x_return_status OUT NOCOPY VARCHAR2
134 ,x_msg_count OUT NOCOPY NUMBER
135 ,x_msg_data OUT NOCOPY VARCHAR2
136
137 ,p_admin_rec IN admin_rec_type
138 ,p_mode IN VARCHAR2 := FND_API.G_MISS_CHAR
139 ,x_role_relate_id OUT NOCOPY NUMBER
140 );
141
142 -------------------------------------------------------------------
143 -- PROCEDURE
144 -- Admin_Group
145 --
146 -- PURPOSE
147 -- Create a Group, Group Usage, Group Member (map resource to a group)
148 --
149 -- PARAMETERS
150 -- p_admin_rec: the new record to be administered
151 -- x_group_id: return the x_group_id
152 -- x_group_number: return the x_group_number
153 -- x_group_usage_id: return the x_group_usage_id
154 -- x_group_member_id: return the x_group_member_id
155 --
156 -- NOTES
157 -- This wrapper internally calls the following :
158 -- a) JTF_RS_GROUPS_PUB.Create_Resource_Group
159 -- b) JTF_RS_GROUP_USAGES_PUB.Create_Group_Usage
160 -- c) JTF_RS_GROUP_MEMBERS_PUB.Create_Resource_Group_Members
161 --------------------------------------------------------------------
162 PROCEDURE Admin_Group(
163 p_api_version IN NUMBER
164 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
165 ,p_commit IN VARCHAR2 := FND_API.g_false
166
167 ,x_return_status OUT NOCOPY VARCHAR2
168 ,x_msg_count OUT NOCOPY NUMBER
169 ,x_msg_data OUT NOCOPY VARCHAR2
170
171 ,p_admin_rec IN admin_rec_type
172 ,p_mode IN VARCHAR2 := FND_API.G_MISS_CHAR
173 ,x_group_id OUT NOCOPY NUMBER
174 ,x_group_number OUT NOCOPY VARCHAR2
175 ,x_group_usage_id OUT NOCOPY NUMBER
176 ,x_group_member_id OUT NOCOPY NUMBER
177 );
178
179 -------------------------------------------------------------------
180 -- PROCEDURE
181 -- Admin_Group_Member
182 --
183 -- PURPOSE
184 -- Create a Group Member (map resource to a group)
185 --
186 -- PARAMETERS
187 -- p_admin_rec: the new record to be administered
188 -- x_group_member_id: return the x_group_member_id
189 --
190 -- NOTES
191 -- This wrapper internally calls the following :
192 -- a) JTF_RS_GROUP_MEMBERS_PUB.Create_Resource_Group_Members
193 --------------------------------------------------------------------
194 PROCEDURE Admin_Group_Member(
195 p_api_version IN NUMBER
196 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
197 ,p_commit IN VARCHAR2 := FND_API.g_false
198
199 ,x_return_status OUT NOCOPY VARCHAR2
200 ,x_msg_count OUT NOCOPY NUMBER
201 ,x_msg_data OUT NOCOPY VARCHAR2
202
203 ,p_admin_rec IN admin_rec_type
204 ,p_mode IN VARCHAR2 := FND_API.G_MISS_CHAR
205 ,x_group_member_id OUT NOCOPY NUMBER
206 );
207
208 ---------------------------------------------------------------------
209 -- PROCEDURE
210 -- Update_User
211 --
212 -- PURPOSE
213 -- Update Fnd_user Record
214 --
215 -- PARAMETERS
216 -- p_fnd_rec : the new record to be administered
217 --
218 --
219 -- NOTES
220 -- 1. object_version_number will be set to 1.
221 ---------------------------------------------------------------------
222 PROCEDURE Update_User(
223 p_api_version IN NUMBER
224 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
225 ,p_commit IN VARCHAR2 := FND_API.g_false
226
227 ,x_return_status OUT NOCOPY VARCHAR2
228 ,x_msg_count OUT NOCOPY NUMBER
229 ,x_msg_data OUT NOCOPY VARCHAR2
230
231 ,p_fnd_rec IN fnd_rec_type
232
233 );
234
235
236 -------------------------------------------------------------------
237 -- PROCEDURE
238 -- Disable_Responsibility
239 --
240 -- PURPOSE
241 -- Disables the user responsibility
242 --
243 -- PARAMETERS
244 -- p_fnd_rec: the fnd record for disabling the responsibility
245 --
246 -- NOTES
247 --
248 --
249 --------------------------------------------------------------------
250 PROCEDURE Disable_Responsibility(
251 p_api_version IN NUMBER
252 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
253 ,p_commit IN VARCHAR2 := FND_API.g_false
254
255 ,x_return_status OUT NOCOPY VARCHAR2
256 ,x_msg_count OUT NOCOPY NUMBER
257 ,x_msg_data OUT NOCOPY VARCHAR2
258
259 ,p_fnd_rec IN fnd_rec_type
260 ,p_mode IN VARCHAR2 := FND_API.G_MISS_CHAR
261 );
262
263
264 -------------------------------------------------------------------
265 -- PROCEDURE
266 -- Update_Partner_Status
267 --
268 -- PURPOSE
269 -- Procedure to update partner status in pv_partner_profiles table
270 -- using the Update Partner Status (PVXUPDPS) concurrent program
271 --
272 -- PARAMETERS
273 -- None
274 --
275 -- NOTES
276 --
277 --
278 --------------------------------------------------------------------
279
280 PROCEDURE update_partner_status (
281 ERRBUF OUT NOCOPY VARCHAR2,
282 RETCODE OUT NOCOPY VARCHAR2
283 );
284
285 -------------------------------------------------------------------
286 -- PROCEDURE
287 -- Cr_As_Accts_With_Partner_User
288 --
289 -- PURPOSE
290 -- Procedure to Create and Associate the customer Accounts with
291 -- Partner Users.
292 --
293 -- PARAMETERS
294 -- None
295 --
296 -- NOTES
297 --
298 --
299 --------------------------------------------------------------------
300
301 PROCEDURE Cr_As_Accts_With_Partner_User (
302 ERRBUF OUT NOCOPY VARCHAR2,
303 RETCODE OUT NOCOPY VARCHAR2
304 );
305
306 END PVX_Misc_PVT;