1 PACKAGE PV_Gq_Elements_PVT AUTHID CURRENT_USER AS
2 /* $Header: pvxvgqes.pls 120.1 2005/06/28 10:33:13 appldev ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- PV_Gq_Elements_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 -- qsnr_element_rec_type
26 -- -------------------------------------------------------
27 -- Parameters:
28 -- qsnr_element_id
29 -- object_version_number
30 -- arc_used_by_entity_code
31 -- used_by_entity_id
32 -- qsnr_elmt_seq_num
33 -- qsnr_elmt_type
34 -- entity_attr_id
35 -- qsnr_elmt_page_num
36 -- is_required_flag
37 -- created_by
38 -- creation_date
39 -- last_updated_by
40 -- last_update_date
41 -- last_update_login
42 --
43 -- Required
44 --
45 -- Defaults
46 --
47 -- Note: This is automatic generated record definition, it includes all columns
48 -- defined in the table, developer must manually add or delete some of the attributes.
49 --
50 -- End of Comments
51
52 --===================================================================
53 TYPE qsnr_element_rec_type IS RECORD
54 (
55 qsnr_element_id NUMBER,
56 object_version_number NUMBER,
57 arc_used_by_entity_code VARCHAR2(30),
58 used_by_entity_id NUMBER,
59 qsnr_elmt_seq_num NUMBER,
60 qsnr_elmt_type VARCHAR2(30),
61 entity_attr_id NUMBER,
62 qsnr_elmt_page_num NUMBER,
63 is_required_flag VARCHAR2(1),
64 created_by NUMBER,
65 creation_date DATE,
66 last_updated_by NUMBER,
67 last_update_date DATE,
68 last_update_login NUMBER,
69 elmt_content VARCHAR2(1600):= FND_API.G_MISS_CHAR
70 );
71
72 g_miss_qsnr_element_rec qsnr_element_rec_type := NULL;
73 TYPE qsnr_element_tbl_type IS TABLE OF qsnr_element_rec_type INDEX BY BINARY_INTEGER;
74 g_miss_qsnr_element_tbl qsnr_element_tbl_type;
75
76 -- ==============================================================================
77 -- Start of Comments
78 -- ==============================================================================
79 -- API Name
80 -- Create_Gq_Elements
81 -- Type
82 -- Private
83 -- Pre-Req
84 --
85 -- Parameters
86 --
87 -- IN
88 -- p_api_version_number IN NUMBER Required
89 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
90 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
91 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
92 -- p_qsnr_element_rec IN qsnr_element_rec_type Required
93 --
94 -- OUT
95 -- x_return_status OUT VARCHAR2
96 -- x_msg_count OUT NUMBER
97 -- x_msg_data OUT VARCHAR2
98 -- Version : Current version 1.0
99 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
100 -- and basic operation, developer must manually add parameters and business logic as necessary.
101 --
102 -- History
103 --
104 -- NOTE
105 --
106 -- End of Comments
107 -- ==============================================================================
108
109 PROCEDURE Create_Gq_Elements(
110 p_api_version_number IN NUMBER,
111 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
112 p_commit IN VARCHAR2 := FND_API.G_FALSE,
113 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
114
115 x_return_status OUT NOCOPY VARCHAR2,
116 x_msg_count OUT NOCOPY NUMBER,
117 x_msg_data OUT NOCOPY VARCHAR2,
118
119 p_qsnr_element_rec IN qsnr_element_rec_type := g_miss_qsnr_element_rec,
120 x_qsnr_element_id OUT NOCOPY NUMBER
121 );
122
123 -- ==============================================================================
124 -- Start of Comments
125 -- ==============================================================================
126 -- API Name
127 -- Copy_Row
128 -- Type
129 -- Private
130 -- Pre-Req
131 --
132 -- Parameters
133 --
134 -- IN
135 -- p_api_version_number IN NUMBER Required
136 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
137 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
138 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
139 -- p_src_object_id IN NUMBER Required
140 -- p_tar_object_id IN NUMBER Required
141 --
142 -- OUT
143 -- x_return_status OUT VARCHAR2
144 -- x_msg_count OUT NUMBER
145 -- x_msg_data OUT VARCHAR2
146 -- Version : Current version 1.0
147 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
148 -- and basic operation, developer must manually add parameters and business logic as necessary.
149 --
150 -- History
151 --
152 -- NOTE
153 --
154 -- End of Comments
155 -- ==============================================================================
156 PROCEDURE Copy_Row
157 (
158 p_api_version_number IN NUMBER
159 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
160 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
161 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
162 ,x_return_status OUT NOCOPY VARCHAR2
163 ,x_msg_count OUT NOCOPY NUMBER
164 ,x_msg_data OUT NOCOPY VARCHAR2
165 ,p_src_object_id IN NUMBER
166 ,p_tar_object_id IN NUMBER
167 );
168
169 -- ==============================================================================
170 -- Start of Comments
171 -- ==============================================================================
172 -- API Name
173 -- Update_Gq_Elements
174 -- Type
175 -- Private
176 -- Pre-Req
177 --
178 -- Parameters
179 --
180 -- IN
181 -- p_api_version_number IN NUMBER Required
182 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
183 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
184 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
185 -- p_qsnr_element_rec IN qsnr_element_rec_type Required
186 --
187 -- OUT
188 -- x_return_status OUT VARCHAR2
189 -- x_msg_count OUT NUMBER
190 -- x_msg_data OUT VARCHAR2
191 -- Version : Current version 1.0
192 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
193 -- and basic operation, developer must manually add parameters and business logic as necessary.
194 --
195 -- History
196 --
197 -- NOTE
198 --
199 -- End of Comments
200 -- ==============================================================================
201
202 PROCEDURE Update_Gq_Elements(
203 p_api_version_number IN NUMBER,
204 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
205 p_commit IN VARCHAR2 := FND_API.G_FALSE,
206 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
207
208 x_return_status OUT NOCOPY VARCHAR2,
209 x_msg_count OUT NOCOPY NUMBER,
210 x_msg_data OUT NOCOPY VARCHAR2,
211
212 p_qsnr_element_rec IN qsnr_element_rec_type,
213 x_object_version_number OUT NOCOPY NUMBER
214 );
215
216 -- ==============================================================================
217 -- Start of Comments
218 -- ==============================================================================
219 -- API Name
220 -- Delete_Gq_Elements
221 -- Type
222 -- Private
223 -- Pre-Req
224 --
225 -- Parameters
226 --
227 -- IN
228 -- p_api_version_number IN NUMBER Required
229 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
230 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
231 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
232 -- p_qsnr_element_id IN NUMBER
233 -- p_object_version_number IN NUMBER Optional Default = NULL
234 --
235 -- OUT
236 -- x_return_status OUT VARCHAR2
237 -- x_msg_count OUT NUMBER
238 -- x_msg_data OUT VARCHAR2
239 -- Version : Current version 1.0
240 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
241 -- and basic operation, developer must manually add parameters and business logic as necessary.
242 --
243 -- History
244 --
245 -- NOTE
246 --
247 -- End of Comments
248 -- ==============================================================================
249
250 PROCEDURE Delete_Gq_Elements(
251 p_api_version_number IN NUMBER,
252 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
253 p_commit IN VARCHAR2 := FND_API.G_FALSE,
254 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
255 x_return_status OUT NOCOPY VARCHAR2,
256 x_msg_count OUT NOCOPY NUMBER,
257 x_msg_data OUT NOCOPY VARCHAR2,
258 p_qsnr_element_id IN NUMBER,
259 p_object_version_number IN NUMBER
260 );
261
262
263 -- ==============================================================================
264 -- Start of Comments
265 -- ==============================================================================
266 -- API Name
267 -- Delete_Gq_PB_Elements
268 -- Type
269 -- Private
270 -- Pre-Req
271 --
272 -- Parameters
273 --
274 -- IN
275 -- p_api_version_number IN NUMBER Required
276 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
277 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
278 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
279 -- p_qsnr_element_id IN NUMBER
280 -- p_object_version_number IN NUMBER Optional Default = NULL
281 --
282 -- OUT
283 -- x_return_status OUT VARCHAR2
284 -- x_msg_count OUT NUMBER
285 -- x_msg_data OUT VARCHAR2
286 -- Version : Current version 1.0
287 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
288 -- and basic operation, developer must manually add parameters and business logic as necessary.
289 --
290 -- History
291 --
292 -- NOTE
293 --
294 -- End of Comments
295 -- ==============================================================================
296 PROCEDURE Delete_Gq_PB_Elements(
297 p_api_version_number IN NUMBER,
298 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
299 p_commit IN VARCHAR2 := FND_API.G_FALSE,
300 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
301 x_return_status OUT NOCOPY VARCHAR2,
302 x_msg_count OUT NOCOPY NUMBER,
303 x_msg_data OUT NOCOPY VARCHAR2,
304 p_qsnr_element_id IN NUMBER,
305 p_object_version_number IN NUMBER
306 );
307
308 -- ==============================================================================
309 -- Start of Comments
310 -- ==============================================================================
311 -- API Name
312 -- Lock_Gq_Elements
313 -- Type
314 -- Private
315 -- Pre-Req
316 --
317 -- Parameters
318 --
319 -- IN
320 -- p_api_version_number IN NUMBER Required
321 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
322 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
323 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
324 -- p_qsnr_element_rec IN qsnr_element_rec_type Required
325 --
326 -- OUT
327 -- x_return_status OUT VARCHAR2
328 -- x_msg_count OUT NUMBER
329 -- x_msg_data OUT VARCHAR2
330 -- Version : Current version 1.0
331 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
332 -- and basic operation, developer must manually add parameters and business logic as necessary.
333 --
334 -- History
335 --
336 -- NOTE
337 --
338 -- End of Comments
339 -- ==============================================================================
340
341 PROCEDURE Lock_Gq_Elements(
342 p_api_version_number IN NUMBER,
343 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
344
345 x_return_status OUT NOCOPY VARCHAR2,
346 x_msg_count OUT NOCOPY NUMBER,
347 x_msg_data OUT NOCOPY VARCHAR2,
348
349 p_qsnr_element_id IN NUMBER,
350 p_object_version IN NUMBER
351 );
352
353
354 -- ==============================================================================
355 -- Start of Comments
356 -- ==============================================================================
357 -- API Name
358 -- Validate_Gq_Elements
359 --
360 -- Version : Current version 1.0
361 -- p_validation_mode is a constant defined in PV_UTILITY_PVT package
362 -- For create: G_CREATE, for update: G_UPDATE
363 -- Note: 1. This is automated generated item level validation procedure.
364 -- The actual validation detail is needed to be added.
365 -- 2. We can also validate table instead of record. There will be an option for user to choose.
366 --
367 -- History
368 --
369 -- NOTE
370 --
371 -- End of Comments
372 -- ==============================================================================
373
374
375 PROCEDURE Validate_Gq_Elements(
376 p_api_version_number IN NUMBER,
377 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
378 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
379 p_qsnr_element_rec IN qsnr_element_rec_type,
380 p_validation_mode IN VARCHAR2,
381 x_return_status OUT NOCOPY VARCHAR2,
382 x_msg_count OUT NOCOPY NUMBER,
383 x_msg_data OUT NOCOPY VARCHAR2
384 );
385
386 -- ==============================================================================
387 -- Start of Comments
388 -- ==============================================================================
389 -- API Name
390 -- Qsnr_Element_Items
391 --
392 -- Version : Current version 1.0
393 -- p_validation_mode is a constant defined in PV_UTILITY_PVT package
394 -- For create: G_CREATE, for update: G_UPDATE
395 -- Note: 1. This is automated generated item level validation procedure.
396 -- The actual validation detail is needed to be added.
397 -- 2. Validate the unique keys, lookups here
398 --
399 -- History
400 --
401 -- NOTE
402 --
403 -- End of Comments
404 -- ==============================================================================
405
406
407 PROCEDURE Check_Qsnr_Element_Items (
408 P_qsnr_element_rec IN qsnr_element_rec_type,
409 p_validation_mode IN VARCHAR2,
410 x_return_status OUT NOCOPY VARCHAR2
411 );
412
413 -- ==============================================================================
414 -- Start of Comments
415 -- ==============================================================================
416 -- API Name
417 -- Validate_Qsnr_Element_Rec
418 --
419 -- Version : Current version 1.0
420 -- p_validation_mode is a constant defined in PV_UTILITY_PVT package
421 -- For create: G_CREATE, for update: G_UPDATE
422 -- Note: 1. This is automated generated item level validation procedure.
423 -- The actual validation detail is needed to be added.
424 -- 2. Developer can manually added inter-field level validation.
425 --
426 -- History
427 --
428 -- NOTE
429 --
430 -- End of Comments
431 -- ==============================================================================
432
433
434 PROCEDURE Validate_Qsnr_Element_Rec (
435 p_api_version_number IN NUMBER,
436 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
437 x_return_status OUT NOCOPY VARCHAR2,
438 x_msg_count OUT NOCOPY NUMBER,
439 x_msg_data OUT NOCOPY VARCHAR2,
440 p_qsnr_element_rec IN qsnr_element_rec_type
441 );
442
443
444 -- ==============================================================================
445 -- Start of Comments
446 -- ==============================================================================
447 -- API Name
448 -- Move_Qsnr_Element
449 -- Type
450 -- Private
451 -- Pre-Req
452 --
453 -- Parameters
454 --
455 -- IN
456 -- p_api_version_number IN NUMBER Required
457 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
458 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
459 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
460 -- p_qsnr_element_id IN NUMBER
461 -- p_object_version_number IN NUMBER
462 --
463 -- OUT
464 -- x_return_status OUT VARCHAR2
465 -- x_msg_count OUT NUMBER
466 -- x_msg_data OUT VARCHAR2
467 -- Version : Current version 1.0
468 --
469 -- History
470 --
471 -- NOTE
472 --
473 -- End of Comments
474 -- ==============================================================================
475
476 PROCEDURE Move_Qsnr_Element (
477 p_api_version_number IN NUMBER
478 ,p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE
479 ,p_commit IN VARCHAR2 := Fnd_Api.G_FALSE
480 ,p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL
481
482 ,x_return_status OUT NOCOPY VARCHAR2
483 ,x_msg_count OUT NOCOPY NUMBER
484 ,x_msg_data OUT NOCOPY VARCHAR2
485
486 ,p_qsnr_element_rec IN qsnr_element_rec_type
487 ,p_movement IN VARCHAR2
488 )
489 ;
490 END PV_Gq_Elements_PVT;