1 PACKAGE PV_Ge_Chklst_PVT AUTHID CURRENT_USER AS
2 /* $Header: pvxvgcis.pls 120.1 2005/06/28 10:26:31 appldev ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- PV_Ge_Chklst_PVT
7 -- Purpose
8 --
9 -- History
10 -- 15 Nov 2002 anubhavk created
11 -- 19 Nov 2002 anubhavk Updated - For NOCOPY by running nocopy.sh
12 --
13 -- NOTE
14 --
15 -- This Api is generated with Latest version of
16 -- Rosetta, where g_miss indicates NULL and
17 -- NULL indicates missing value. Rosetta Version 1.55
18 -- End of Comments
19 -- ===============================================================
20
21 -- Default number of records fetch per call
22 -- G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
23 --===================================================================
24 -- Start of Comments
25 -- -------------------------------------------------------
26 -- Record name
27 -- ge_chklst_rec_type
28 -- -------------------------------------------------------
29 -- Parameters:
30 -- checklist_item_id
31 -- object_version_number
32 -- arc_used_by_entity_code
33 -- used_by_entity_id
34 -- sequence_num
35 -- is_required_flag
36 -- enabled_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 ge_chklst_rec_type IS RECORD
54 (
55 checklist_item_id NUMBER,
56 object_version_number NUMBER,
57 arc_used_by_entity_code VARCHAR2(30),
58 used_by_entity_id NUMBER,
59 sequence_num NUMBER,
60 is_required_flag VARCHAR2(1),
61 enabled_flag VARCHAR2(1),
62 created_by NUMBER,
63 creation_date DATE,
64 last_updated_by NUMBER,
65 last_update_date DATE,
66 last_update_login NUMBER,
67 checklist_item_name VARCHAR2(4000):= FND_API.G_MISS_CHAR
68 );
69
70 g_miss_ge_chklst_rec ge_chklst_rec_type := NULL;
71 TYPE ge_chklst_tbl_type IS TABLE OF ge_chklst_rec_type INDEX BY BINARY_INTEGER;
72 g_miss_ge_chklst_tbl ge_chklst_tbl_type;
73
74 -- ==============================================================================
75 -- Start of Comments
76 -- ==============================================================================
77 -- API Name
78 -- Create_Ge_Chklst
79 -- Type
80 -- Private
81 -- Pre-Req
82 --
83 -- Parameters
84 --
85 -- IN
86 -- p_api_version_number IN NUMBER Required
87 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
88 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
89 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
90 -- p_ge_chklst_rec IN ge_chklst_rec_type Required
91 --
92 -- OUT
93 -- x_return_status OUT VARCHAR2
94 -- x_msg_count OUT NUMBER
95 -- x_msg_data OUT VARCHAR2
96 -- Version : Current version 1.0
97 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
98 -- and basic operation, developer must manually add parameters and business logic as necessary.
99 --
100 -- History
101 --
102 -- NOTE
103 --
104 -- End of Comments
105 -- ==============================================================================
106
107 PROCEDURE Create_Ge_Chklst(
108 p_api_version_number IN NUMBER,
109 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
110 p_commit IN VARCHAR2 := FND_API.G_FALSE,
111 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
112
113 x_return_status OUT NOCOPY VARCHAR2,
114 x_msg_count OUT NOCOPY NUMBER,
115 x_msg_data OUT NOCOPY VARCHAR2,
116
117 p_ge_chklst_rec IN ge_chklst_rec_type := g_miss_ge_chklst_rec,
118 x_checklist_item_id OUT NOCOPY NUMBER
119 );
120
121 -- ==============================================================================
122 -- Start of Comments
123 -- ==============================================================================
124 -- API Name
125 -- Copy_Row
126 -- Type
127 -- Private
128 -- Pre-Req
129 --
130 -- Parameters
131 --
132 -- IN
133 -- p_api_version_number IN NUMBER Required
134 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
135 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
136 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
137 -- p_src_object_id IN NUMBER Required
138 -- p_tar_object_id IN NUMBER Required
139 --
140 -- OUT
141 -- x_return_status OUT VARCHAR2
142 -- x_msg_count OUT NUMBER
143 -- x_msg_data OUT VARCHAR2
144 -- Version : Current version 1.0
145 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
146 -- and basic operation, developer must manually add parameters and business logic as necessary.
147 --
148 -- History
149 --
150 -- NOTE
151 --
152 -- End of Comments
153 -- ==============================================================================
154 PROCEDURE Copy_Row
155 (
156 p_api_version_number IN NUMBER
157 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
158 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
159 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
160 ,x_return_status OUT NOCOPY VARCHAR2
161 ,x_msg_count OUT NOCOPY NUMBER
162 ,x_msg_data OUT NOCOPY VARCHAR2
163 ,p_src_object_id IN NUMBER
164 ,p_tar_object_id IN NUMBER
165 );
166
167 -- ==============================================================================
168 -- Start of Comments
169 -- ==============================================================================
170 -- API Name
171 -- Update_Ge_Chklst
172 -- Type
173 -- Private
174 -- Pre-Req
175 --
176 -- Parameters
177 --
178 -- IN
179 -- p_api_version_number IN NUMBER Required
180 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
181 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
182 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
183 -- p_ge_chklst_rec IN ge_chklst_rec_type Required
184 --
185 -- OUT
186 -- x_return_status OUT VARCHAR2
187 -- x_msg_count OUT NUMBER
188 -- x_msg_data OUT VARCHAR2
189 -- Version : Current version 1.0
190 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
191 -- and basic operation, developer must manually add parameters and business logic as necessary.
192 --
193 -- History
194 --
195 -- NOTE
196 --
197 -- End of Comments
198 -- ==============================================================================
199
200 PROCEDURE Update_Ge_Chklst(
201 p_api_version_number IN NUMBER,
202 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
203 p_commit IN VARCHAR2 := FND_API.G_FALSE,
204 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
205
206 x_return_status OUT NOCOPY VARCHAR2,
207 x_msg_count OUT NOCOPY NUMBER,
208 x_msg_data OUT NOCOPY VARCHAR2,
209
210 p_ge_chklst_rec IN ge_chklst_rec_type
211 );
212
213 -- ==============================================================================
214 -- Start of Comments
215 -- ==============================================================================
216 -- API Name
217 -- Delete_Ge_Chklst
218 -- Type
219 -- Private
220 -- Pre-Req
221 --
222 -- Parameters
223 --
224 -- IN
225 -- p_api_version_number IN NUMBER Required
226 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
227 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
228 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
229 -- p_checklist_item_id IN NUMBER
230 -- p_object_version_number IN NUMBER Optional Default = NULL
231 --
232 -- OUT
233 -- x_return_status OUT VARCHAR2
234 -- x_msg_count OUT NUMBER
235 -- x_msg_data OUT VARCHAR2
236 -- Version : Current version 1.0
237 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
238 -- and basic operation, developer must manually add parameters and business logic as necessary.
239 --
240 -- History
241 --
242 -- NOTE
243 --
244 -- End of Comments
245 -- ==============================================================================
246
247 PROCEDURE Delete_Ge_Chklst(
248 p_api_version_number IN NUMBER,
249 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
250 p_commit IN VARCHAR2 := FND_API.G_FALSE,
251 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
252 x_return_status OUT NOCOPY VARCHAR2,
253 x_msg_count OUT NOCOPY NUMBER,
254 x_msg_data OUT NOCOPY VARCHAR2,
255 p_checklist_item_id IN NUMBER,
256 p_object_version_number IN NUMBER
257 );
258
259 -- ==============================================================================
260 -- Start of Comments
261 -- ==============================================================================
262 -- API Name
263 -- Lock_Ge_Chklst
264 -- Type
265 -- Private
266 -- Pre-Req
267 --
268 -- Parameters
269 --
270 -- IN
271 -- p_api_version_number IN NUMBER Required
272 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
273 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
274 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
275 -- p_ge_chklst_rec IN ge_chklst_rec_type Required
276 --
277 -- OUT
278 -- x_return_status OUT VARCHAR2
279 -- x_msg_count OUT NUMBER
280 -- x_msg_data OUT VARCHAR2
281 -- Version : Current version 1.0
282 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
283 -- and basic operation, developer must manually add parameters and business logic as necessary.
284 --
285 -- History
286 --
287 -- NOTE
288 --
289 -- End of Comments
290 -- ==============================================================================
291
292 PROCEDURE Lock_Ge_Chklst(
293 p_api_version_number IN NUMBER,
294 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
295
296 x_return_status OUT NOCOPY VARCHAR2,
297 x_msg_count OUT NOCOPY NUMBER,
298 x_msg_data OUT NOCOPY VARCHAR2,
299
300 p_checklist_item_id IN NUMBER,
301 p_object_version IN NUMBER
302 );
303
304
305 -- ==============================================================================
306 -- Start of Comments
307 -- ==============================================================================
308 -- API Name
309 -- Validate_Ge_Chklst
310 --
311 -- Version : Current version 1.0
312 -- p_validation_mode is a constant defined in PV_UTILITY_PVT package
313 -- For create: G_CREATE, for update: G_UPDATE
314 -- Note: 1. This is automated generated item level validation procedure.
315 -- The actual validation detail is needed to be added.
316 -- 2. We can also validate table instead of record. There will be an option for user to choose.
317 --
318 -- History
319 --
320 -- NOTE
321 --
322 -- End of Comments
323 -- ==============================================================================
324
325
326 PROCEDURE Validate_Ge_Chklst(
327 p_api_version_number IN NUMBER,
328 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
329 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
330 p_ge_chklst_rec IN ge_chklst_rec_type,
331 p_validation_mode IN VARCHAR2,
332 x_return_status OUT NOCOPY VARCHAR2,
333 x_msg_count OUT NOCOPY NUMBER,
334 x_msg_data OUT NOCOPY VARCHAR2
335 );
336
337 -- ==============================================================================
338 -- Start of Comments
339 -- ==============================================================================
340 -- API Name
341 -- Ge_Chklst_Items
342 --
343 -- Version : Current version 1.0
344 -- p_validation_mode is a constant defined in PV_UTILITY_PVT package
345 -- For create: G_CREATE, for update: G_UPDATE
346 -- Note: 1. This is automated generated item level validation procedure.
347 -- The actual validation detail is needed to be added.
348 -- 2. Validate the unique keys, lookups here
349 --
350 -- History
351 --
352 -- NOTE
353 --
354 -- End of Comments
355 -- ==============================================================================
356
357
358 PROCEDURE Check_Ge_Chklst_Items (
359 P_ge_chklst_rec IN ge_chklst_rec_type,
360 p_validation_mode IN VARCHAR2,
361 x_return_status OUT NOCOPY VARCHAR2
362 );
363
364 -- ==============================================================================
365 -- Start of Comments
366 -- ==============================================================================
367 -- API Name
368 -- Validate_Ge_Chklst_Rec
369 --
370 -- Version : Current version 1.0
371 -- p_validation_mode is a constant defined in PV_UTILITY_PVT package
372 -- For create: G_CREATE, for update: G_UPDATE
373 -- Note: 1. This is automated generated item level validation procedure.
374 -- The actual validation detail is needed to be added.
375 -- 2. Developer can manually added inter-field level validation.
376 --
377 -- History
378 --
379 -- NOTE
380 --
381 -- End of Comments
382 -- ==============================================================================
383
384
385 PROCEDURE Validate_Ge_Chklst_Rec (
386 p_api_version_number IN NUMBER,
387 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
388 x_return_status OUT NOCOPY VARCHAR2,
389 x_msg_count OUT NOCOPY NUMBER,
390 x_msg_data OUT NOCOPY VARCHAR2,
391 p_ge_chklst_rec IN ge_chklst_rec_type
392 );
393
394 PROCEDURE Check_Item_In_Chklst_Resp (
395 p_checklist_item_id IN NUMBER,
396 x_response OUT NOCOPY NUMBER
397 );
398
399
400
401 END PV_Ge_Chklst_PVT;