[Home] [Help]
PACKAGE: APPS.PV_PARTNER_ACCESSES_PVT
Source
1 PACKAGE PV_Partner_Accesses_PVT AUTHID CURRENT_USER AS
2 /* $Header: pvxvpras.pls 115.0 2003/10/15 04:14:44 rdsharma noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- PV_Partner_Accesses_PVT
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- This Api is generated with Latest version of
14 -- Rosetta, where g_miss indicates NULL and
15 -- NULL indicates missing value. Rosetta Version 1.55
16 -- End of Comments
17 -- ===============================================================
18
19 -- Default number of records fetch per call
20 -- G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
21 --===================================================================
22 -- Start of Comments
23 -- -------------------------------------------------------
24 -- Record name
25 -- partner_access_rec_type
26 -- -------------------------------------------------------
27 -- Parameters:
28 -- partner_access_id
29 -- partner_id
30 -- resource_id
31 -- keep_flag
32 -- created_by_tap_flag
33 -- access_type
34 -- vad_partner_id
35 -- last_update_date
36 -- last_updated_by
37 -- creation_date
38 -- created_by
39 -- last_update_login
40 -- object_version_number
41 -- request_id
42 -- program_application_id
43 -- program_id
44 -- program_update_date
45 -- attribute_category
46 -- attribute1
47 -- attribute2
48 -- attribute3
49 -- attribute4
50 -- attribute5
51 -- attribute6
52 -- attribute7
53 -- attribute8
54 -- attribute9
55 -- attribute10
56 -- attribute11
57 -- attribute12
58 -- attribute13
59 -- attribute14
60 -- attribute15
61 --
62 -- Required
63 --
64 -- Defaults
65 --
66 -- Note: This is automatic generated record definition, it includes all columns
67 -- defined in the table, developer must manually add or delete some of the attributes.
68 --
69 -- End of Comments
70
71 --===================================================================
72 TYPE partner_access_rec_type IS RECORD
73 (
74 partner_access_id NUMBER,
75 partner_id NUMBER,
76 resource_id NUMBER,
77 keep_flag VARCHAR2(1),
78 created_by_tap_flag VARCHAR2(1),
79 access_type VARCHAR2(1),
80 vad_partner_id NUMBER,
81 last_update_date DATE,
82 last_updated_by NUMBER,
83 creation_date DATE,
84 created_by NUMBER,
85 last_update_login NUMBER,
86 object_version_number NUMBER,
87 request_id NUMBER,
88 program_application_id NUMBER,
89 program_id NUMBER,
90 program_update_date DATE,
91 attribute_category VARCHAR2(30),
92 attribute1 VARCHAR2(150),
93 attribute2 VARCHAR2(150),
94 attribute3 VARCHAR2(150),
95 attribute4 VARCHAR2(150),
96 attribute5 VARCHAR2(150),
97 attribute6 VARCHAR2(150),
98 attribute7 VARCHAR2(150),
99 attribute8 VARCHAR2(150),
100 attribute9 VARCHAR2(150),
101 attribute10 VARCHAR2(150),
102 attribute11 VARCHAR2(150),
103 attribute12 VARCHAR2(150),
104 attribute13 VARCHAR2(150),
105 attribute14 VARCHAR2(150),
106 attribute15 VARCHAR2(150)
107 );
108
109 g_miss_partner_access_rec partner_access_rec_type := NULL;
110 TYPE partner_access_tbl_type IS TABLE OF partner_access_rec_type INDEX BY BINARY_INTEGER;
111 g_miss_partner_access_tbl partner_access_tbl_type;
112
113 -- ==============================================================================
114 -- Start of Comments
115 -- ==============================================================================
116 -- API Name
117 -- Create_Partner_Accesses
118 -- Type
119 -- Private
120 -- Pre-Req
121 --
122 -- Parameters
123 --
124 -- IN
125 -- p_api_version_number IN NUMBER Required
126 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
127 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
128 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
129 -- p_partner_access_rec IN partner_access_rec_type Required
130 --
131 -- OUT
132 -- x_return_status OUT VARCHAR2
133 -- x_msg_count OUT NUMBER
134 -- x_msg_data OUT VARCHAR2
135 -- Version : Current version 1.0
136 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
137 -- and basic operation, developer must manually add parameters and business logic as necessary.
138 --
139 -- History
140 --
141 -- NOTE
142 --
143 -- End of Comments
144 -- ==============================================================================
145
146 PROCEDURE Create_Partner_Accesses(
147 p_api_version_number IN NUMBER,
148 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
149 p_commit IN VARCHAR2 := FND_API.G_FALSE,
150 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
151
152 x_return_status OUT NOCOPY VARCHAR2,
153 x_msg_count OUT NOCOPY NUMBER,
154 x_msg_data OUT NOCOPY VARCHAR2,
155
156 p_partner_access_rec IN partner_access_rec_type := g_miss_partner_access_rec,
157 x_partner_access_id OUT NOCOPY NUMBER
158 );
159
160 -- ==============================================================================
161 -- Start of Comments
162 -- ==============================================================================
163 -- API Name
164 -- Update_Partner_Accesses
165 -- Type
166 -- Private
167 -- Pre-Req
168 --
169 -- Parameters
170 --
171 -- IN
172 -- p_api_version_number IN NUMBER Required
173 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
174 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
175 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
176 -- p_partner_access_rec IN partner_access_rec_type Required
177 --
178 -- OUT
179 -- x_return_status OUT VARCHAR2
180 -- x_msg_count OUT NUMBER
181 -- x_msg_data OUT VARCHAR2
182 -- Version : Current version 1.0
183 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
184 -- and basic operation, developer must manually add parameters and business logic as necessary.
185 --
186 -- History
187 --
188 -- NOTE
189 --
190 -- End of Comments
191 -- ==============================================================================
192
193 PROCEDURE Update_Partner_Accesses(
194 p_api_version_number IN NUMBER,
195 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
196 p_commit IN VARCHAR2 := FND_API.G_FALSE,
197 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
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_partner_access_rec IN partner_access_rec_type
204 );
205
206 -- ==============================================================================
207 -- Start of Comments
208 -- ==============================================================================
209 -- API Name
210 -- Delete_Partner_Accesses
211 -- Type
212 -- Private
213 -- Pre-Req
214 --
215 -- Parameters
216 --
217 -- IN
218 -- p_api_version_number IN NUMBER Required
219 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
220 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
221 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
222 -- p_partner_access_id IN NUMBER
223 -- p_object_version_number IN NUMBER Optional Default = NULL
224 --
225 -- OUT
226 -- x_return_status OUT VARCHAR2
227 -- x_msg_count OUT NUMBER
228 -- x_msg_data OUT VARCHAR2
229 -- Version : Current version 1.0
230 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
231 -- and basic operation, developer must manually add parameters and business logic as necessary.
232 --
233 -- History
234 --
235 -- NOTE
236 --
237 -- End of Comments
238 -- ==============================================================================
239
240 PROCEDURE Delete_Partner_Accesses(
241 p_api_version_number IN NUMBER,
242 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
243 p_commit IN VARCHAR2 := FND_API.G_FALSE,
244 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
245 x_return_status OUT NOCOPY VARCHAR2,
246 x_msg_count OUT NOCOPY NUMBER,
247 x_msg_data OUT NOCOPY VARCHAR2,
248 p_partner_access_id IN NUMBER,
249 p_object_version_number IN NUMBER
250 );
251
252 -- ==============================================================================
253 -- Start of Comments
254 -- ==============================================================================
255 -- API Name
256 -- Lock_Partner_Accesses
257 -- Type
258 -- Private
259 -- Pre-Req
260 --
261 -- Parameters
262 --
263 -- IN
264 -- p_api_version_number IN NUMBER Required
265 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
266 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
267 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
268 -- p_partner_access_rec IN partner_access_rec_type Required
269 --
270 -- OUT
271 -- x_return_status OUT VARCHAR2
272 -- x_msg_count OUT NUMBER
273 -- x_msg_data OUT VARCHAR2
274 -- Version : Current version 1.0
275 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
276 -- and basic operation, developer must manually add parameters and business logic as necessary.
277 --
278 -- History
279 --
280 -- NOTE
281 --
282 -- End of Comments
283 -- ==============================================================================
284
285 PROCEDURE Lock_Partner_Accesses(
286 p_api_version_number IN NUMBER,
287 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
288
289 x_return_status OUT NOCOPY VARCHAR2,
290 x_msg_count OUT NOCOPY NUMBER,
291 x_msg_data OUT NOCOPY VARCHAR2,
292
293 p_partner_access_id IN NUMBER,
294 p_object_version_number IN NUMBER
295 );
296
297
298 -- ==============================================================================
299 -- Start of Comments
300 -- ==============================================================================
301 -- API Name
302 -- Validate_Partner_Accesses
303 --
304 -- Version : Current version 1.0
305 -- p_validation_mode is a constant defined in PV_UTILITY_PVT package
306 -- For create: G_CREATE, for update: G_UPDATE
307 -- Note: 1. This is automated generated item level validation procedure.
308 -- The actual validation detail is needed to be added.
309 -- 2. We can also validate table instead of record. There will be an option for user to choose.
310 --
311 -- History
312 --
313 -- NOTE
314 --
315 -- End of Comments
316 -- ==============================================================================
317
318
319 PROCEDURE Validate_Partner_Accesses(
320 p_api_version_number IN NUMBER,
321 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
322 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
323 p_partner_access_rec IN partner_access_rec_type,
324 p_validation_mode IN VARCHAR2,
325 x_return_status OUT NOCOPY VARCHAR2,
326 x_msg_count OUT NOCOPY NUMBER,
327 x_msg_data OUT NOCOPY VARCHAR2
328 );
329
330 -- ==============================================================================
331 -- Start of Comments
332 -- ==============================================================================
333 -- API Name
334 -- Partner_Access_Items
335 --
336 -- Version : Current version 1.0
337 -- p_validation_mode is a constant defined in PV_UTILITY_PVT package
338 -- For create: G_CREATE, for update: G_UPDATE
339 -- Note: 1. This is automated generated item level validation procedure.
340 -- The actual validation detail is needed to be added.
341 -- 2. Validate the unique keys, lookups here
342 --
343 -- History
344 --
345 -- NOTE
346 --
347 -- End of Comments
348 -- ==============================================================================
349
350
351 PROCEDURE Chk_Partner_Access_Items (
352 P_partner_access_rec IN partner_access_rec_type,
353 p_validation_mode IN VARCHAR2,
354 x_return_status OUT NOCOPY VARCHAR2
355 );
356
357 -- ==============================================================================
358 -- Start of Comments
359 -- ==============================================================================
360 -- API Name
361 -- Validate_Partner_Access_Rec
362 --
363 -- Version : Current version 1.0
364 -- p_validation_mode is a constant defined in PV_UTILITY_PVT package
365 -- For create: G_CREATE, for update: G_UPDATE
366 -- Note: 1. This is automated generated item level validation procedure.
367 -- The actual validation detail is needed to be added.
368 -- 2. Developer can manually added inter-field level validation.
369 --
370 -- History
371 --
372 -- NOTE
373 --
374 -- End of Comments
375 -- ==============================================================================
376
377
378 PROCEDURE Validate_Partner_Access_Rec (
379 p_api_version_number IN NUMBER,
380 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
381 x_return_status OUT NOCOPY VARCHAR2,
382 x_msg_count OUT NOCOPY NUMBER,
383 x_msg_data OUT NOCOPY VARCHAR2,
384 p_partner_access_rec IN partner_access_rec_type
385 );
386 END PV_Partner_Accesses_PVT;