1 PACKAGE CSP_picklist_lines_PVT AUTHID CURRENT_USER AS
2 /* $Header: cspvtpls.pls 115.8 2003/05/02 16:38:15 hhaugeru ship $ */
3 -- Start of Comments
4 -- Package name : CSP_picklist_lines_PVT
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 -- Default number of records fetch per call
11 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
12 -- *******************************************************
13 -- Start of Comments
14 -- -------------------------------------------------------
15 -- Record name:picklist_line_Rec_Type
16 -- -------------------------------------------------------
17 -- Parameters:
18 -- picklist_line_id
19 -- CREATED_BY
20 -- CREATION_DATE
21 -- LAST_UPDATED_BY
22 -- LAST_UPDATE_DATE
23 -- LAST_UPDATE_LOGIN
24 -- PICKLIST_LINE_NUMBER
25 -- picklist_header_id
26 -- LINE_ID
27 -- INVENTORY_ITEM_ID
28 -- UOM_CODE
29 -- REVISION
30 -- QUANTITY_PICKED
31 -- TRANSACTION_TEMP_ID
32 -- ATTRIBUTE_CATEGORY
33 -- ATTRIBUTE1
34 -- ATTRIBUTE2
35 -- ATTRIBUTE3
36 -- ATTRIBUTE4
37 -- ATTRIBUTE5
38 -- ATTRIBUTE6
39 -- ATTRIBUTE7
40 -- ATTRIBUTE8
41 -- ATTRIBUTE9
42 -- ATTRIBUTE10
43 -- ATTRIBUTE11
44 -- ATTRIBUTE12
45 -- ATTRIBUTE13
46 -- ATTRIBUTE14
47 -- ATTRIBUTE15
48 --
49 -- Required:
50 -- Defaults:
51 -- Note: This is automatic generated record definition, it includes all columns
52 -- defined in the table, developer must manually add or delete some of the attributes.
53 --
54 -- End of Comments
55
56 TYPE picklist_line_Rec_Type IS RECORD
57 (
58 picklist_line_id NUMBER := FND_API.G_MISS_NUM,
59 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
60 CREATION_DATE DATE := FND_API.G_MISS_DATE,
61 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
62 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
63 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
64 PICKLIST_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
65 picklist_header_id NUMBER := FND_API.G_MISS_NUM,
66 LINE_ID NUMBER := FND_API.G_MISS_NUM,
67 INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
68 UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
69 REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
70 QUANTITY_PICKED NUMBER := FND_API.G_MISS_NUM,
71 TRANSACTION_TEMP_ID NUMBER := FND_API.G_MISS_NUM,
72 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
73 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
88 );
89
90 G_MISS_picklist_line_REC picklist_line_Rec_Type;
91 TYPE picklist_line_Tbl_Type IS TABLE OF picklist_line_Rec_Type
92 INDEX BY BINARY_INTEGER;
93 G_MISS_picklist_line_TBL picklist_line_Tbl_Type;
94
95 -- *******************************************************
96 -- Start of Comments
97 -- *******************************************************
98 -- API Name: Create_picklist_lines
99 -- Type : Private
100 -- Pre-Req :
101 -- Parameters:
102 -- IN
103 -- p_api_version_number IN NUMBER Required
104 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
105 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
106 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
107 -- P_picklist_line_Rec IN picklist_line_Rec_Type Required
108 --
109 -- OUT:
110 -- x_return_status OUT NOCOPY VARCHAR2
111 -- x_msg_count OUT NOCOPY NUMBER
112 -- x_msg_data OUT NOCOPY VARCHAR2
113 -- Version : Current version 2.0
114 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
115 -- and basic operation, developer must manually add parameters and business logic as necessary.
116 --
117 -- End of Comments
118 --
119 PROCEDURE Create_picklist_lines(
120 P_Api_Version_Number IN NUMBER,
121 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
122 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
123 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
124 P_picklist_line_Rec IN picklist_line_Rec_Type := G_MISS_picklist_line_REC,
125 --Hint: Add detail tables as parameter lists if it's master-detail relationship.
126 X_picklist_line_id OUT NOCOPY NUMBER,
127 X_Return_Status OUT NOCOPY VARCHAR2,
128 X_Msg_Count OUT NOCOPY NUMBER,
129 X_Msg_Data OUT NOCOPY VARCHAR2
130 );
131
132 -- *******************************************************
133 -- Start of Comments
134 -- *******************************************************
135 -- API Name: Update_picklist_lines
136 -- Type : Private
137 -- Pre-Req :
138 -- Parameters:
139 -- IN
140 -- p_api_version_number IN NUMBER Required
141 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
142 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
143 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
144 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
145 -- P_picklist_line_Rec IN picklist_line_Rec_Type Required
146 --
147 -- OUT:
148 -- x_return_status OUT NOCOPY VARCHAR2
149 -- x_msg_count OUT NOCOPY NUMBER
150 -- x_msg_data OUT NOCOPY VARCHAR2
151 -- Version : Current version 2.0
152 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
153 -- and basic operation, developer must manually add parameters and business logic as necessary.
154 --
155 -- End of Comments
156 --
157 -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
158 PROCEDURE Update_picklist_lines(
159 P_Api_Version_Number IN NUMBER,
160 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
161 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
162 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
163 --P_Identity_Salesforce_Id IN NUMBER := NULL,
164 P_picklist_line_Rec IN picklist_line_Rec_Type,
165 X_Return_Status OUT NOCOPY VARCHAR2,
166 X_Msg_Count OUT NOCOPY NUMBER,
167 X_Msg_Data OUT NOCOPY VARCHAR2
168 );
169
170 -- *******************************************************
171 -- Start of Comments
172 -- *******************************************************
173 -- API Name: Delete_picklist_lines
174 -- Type : Private
175 -- Pre-Req :
176 -- Parameters:
177 -- IN
178 -- p_api_version_number IN NUMBER Required
179 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
180 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
181 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
182 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
183 -- P_picklist_line_Rec IN picklist_line_Rec_Type Required
184 --
185 -- OUT:
186 -- x_return_status OUT NOCOPY VARCHAR2
187 -- x_msg_count OUT NOCOPY NUMBER
188 -- x_msg_data OUT NOCOPY VARCHAR2
189 -- Version : Current version 2.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 -- End of Comments
194 --
195 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
196 -- The Master delete procedure may not be needed depends on different business requirements.
197 PROCEDURE Delete_picklist_lines(
198 P_Api_Version_Number IN NUMBER,
199 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
200 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
201 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
202 --P_identity_salesforce_id IN NUMBER := NULL,
203 P_picklist_line_Rec IN picklist_line_Rec_Type,
204 X_Return_Status OUT NOCOPY VARCHAR2,
205 X_Msg_Count OUT NOCOPY NUMBER,
206 X_Msg_Data OUT NOCOPY VARCHAR2
207 );
208
209 -- Start of Comments
210 --
211 -- Item level validation procedures
212 --
213 -- p_validation_mode is a constant defined in JTF_PLSQL_API package
214 -- For create: G_CREATE, for update: G_UPDATE
215 -- Note: 1. This is automated generated item level validation procedure.
216 -- The actual validation detail is needed to be added.
217 --
218 -- End of Comments
219
220 PROCEDURE Validate_picklist_line_id (
221 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
222 P_Validation_mode IN VARCHAR2,
223 P_picklist_line_id IN NUMBER,
224 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
225 X_Return_Status OUT NOCOPY VARCHAR2,
226 X_Msg_Count OUT NOCOPY NUMBER,
227 X_Msg_Data OUT NOCOPY VARCHAR2
228 );
229
230 -- Start of Comments
231 --
232 -- Item level validation procedures
233 --
234 -- p_validation_mode is a constant defined in JTF_PLSQL_API package
235 -- For create: G_CREATE, for update: G_UPDATE
236 -- Note: 1. This is automated generated item level validation procedure.
237 -- The actual validation detail is needed to be added.
238 --
239 -- End of Comments
240
241 PROCEDURE Validate_PICKLIST_LINE_NUMBER (
242 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
243 P_Validation_mode IN VARCHAR2,
244 P_PICKLIST_LINE_NUMBER IN NUMBER,
245 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
246 X_Return_Status OUT NOCOPY VARCHAR2,
247 X_Msg_Count OUT NOCOPY NUMBER,
248 X_Msg_Data OUT NOCOPY VARCHAR2
249 );
250
251 -- Start of Comments
252 --
253 -- Item level validation procedures
254 --
255 -- p_validation_mode is a constant defined in JTF_PLSQL_API package
256 -- For create: G_CREATE, for update: G_UPDATE
257 -- Note: 1. This is automated generated item level validation procedure.
258 -- The actual validation detail is needed to be added.
259 --
260 -- End of Comments
261
262 PROCEDURE Validate_picklist_header_id (
263 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
264 P_Validation_mode IN VARCHAR2,
265 P_picklist_header_id IN NUMBER,
266 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
267 X_Return_Status OUT NOCOPY VARCHAR2,
268 X_Msg_Count OUT NOCOPY NUMBER,
269 X_Msg_Data OUT NOCOPY VARCHAR2
270 );
271
272 -- Start of Comments
273 --
274 -- Item level validation procedures
275 --
276 -- p_validation_mode is a constant defined in JTF_PLSQL_API package
277 -- For create: G_CREATE, for update: G_UPDATE
278 -- Note: 1. This is automated generated item level validation procedure.
279 -- The actual validation detail is needed to be added.
280 --
281 -- End of Comments
282
283 PROCEDURE Validate_LINE_ID (
284 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
285 P_Validation_mode IN VARCHAR2,
286 P_LINE_ID IN NUMBER,
287 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
288 X_Return_Status OUT NOCOPY VARCHAR2,
289 X_Msg_Count OUT NOCOPY NUMBER,
290 X_Msg_Data OUT NOCOPY VARCHAR2
291 );
292
293 -- Start of Comments
294 --
295 -- Item level validation procedures
296 --
297 -- p_validation_mode is a constant defined in JTF_PLSQL_API package
298 -- For create: G_CREATE, for update: G_UPDATE
299 -- Note: 1. This is automated generated item level validation procedure.
300 -- The actual validation detail is needed to be added.
301 --
302 -- End of Comments
303
304 PROCEDURE Validate_INVENTORY_ITEM_ID (
305 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
306 P_Validation_mode IN VARCHAR2,
307 P_INVENTORY_ITEM_ID IN NUMBER,
308 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
309 X_Return_Status OUT NOCOPY VARCHAR2,
310 X_Msg_Count OUT NOCOPY NUMBER,
311 X_Msg_Data OUT NOCOPY VARCHAR2
312 );
313
314 -- Start of Comments
315 --
316 -- Item level validation procedures
317 --
318 -- p_validation_mode is a constant defined in JTF_PLSQL_API package
319 -- For create: G_CREATE, for update: G_UPDATE
320 -- Note: 1. This is automated generated item level validation procedure.
321 -- The actual validation detail is needed to be added.
322 --
323 -- End of Comments
324
325 PROCEDURE Validate_UOM_CODE (
326 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
327 P_Validation_mode IN VARCHAR2,
328 P_UOM_CODE IN VARCHAR2,
329 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
330 X_Return_Status OUT NOCOPY VARCHAR2,
331 X_Msg_Count OUT NOCOPY NUMBER,
332 X_Msg_Data OUT NOCOPY VARCHAR2
333 );
334
335 -- Start of Comments
336 --
337 -- Item level validation procedures
338 --
339 -- p_validation_mode is a constant defined in JTF_PLSQL_API package
340 -- For create: G_CREATE, for update: G_UPDATE
341 -- Note: 1. This is automated generated item level validation procedure.
342 -- The actual validation detail is needed to be added.
343 --
344 -- End of Comments
345
346 PROCEDURE Validate_REVISION (
347 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
348 P_Validation_mode IN VARCHAR2,
352 X_Msg_Count OUT NOCOPY NUMBER,
349 P_REVISION IN VARCHAR2,
350 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
351 X_Return_Status OUT NOCOPY VARCHAR2,
353 X_Msg_Data OUT NOCOPY VARCHAR2
354 );
355
356 -- Start of Comments
357 --
358 -- Item level validation procedures
359 --
360 -- p_validation_mode is a constant defined in JTF_PLSQL_API package
361 -- For create: G_CREATE, for update: G_UPDATE
362 -- Note: 1. This is automated generated item level validation procedure.
363 -- The actual validation detail is needed to be added.
364 --
365 -- End of Comments
366
367 PROCEDURE Validate_QUANTITY_PICKED (
368 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
369 P_Validation_mode IN VARCHAR2,
370 P_QUANTITY_PICKED IN NUMBER,
371 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
372 X_Return_Status OUT NOCOPY VARCHAR2,
373 X_Msg_Count OUT NOCOPY NUMBER,
374 X_Msg_Data OUT NOCOPY VARCHAR2
375 );
376
377 -- Start of Comments
378 --
379 -- Item level validation procedures
380 --
381 -- p_validation_mode is a constant defined in JTF_PLSQL_API package
382 -- For create: G_CREATE, for update: G_UPDATE
383 -- Note: 1. This is automated generated item level validation procedure.
384 -- The actual validation detail is needed to be added.
385 --
386 -- End of Comments
387
388 PROCEDURE Validate_TRANSACTION_TEMP_ID (
389 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
390 P_Validation_mode IN VARCHAR2,
391 P_TRANSACTION_TEMP_ID IN NUMBER,
392 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
393 X_Return_Status OUT NOCOPY VARCHAR2,
394 X_Msg_Count OUT NOCOPY NUMBER,
395 X_Msg_Data OUT NOCOPY VARCHAR2
396 );
397
398 -- Start of Comments
399 --
400 -- Record level validation procedures
401 --
402 -- p_validation_mode is a constant defined in JTF_PLSQL_API package
403 -- For create: G_CREATE, for update: G_UPDATE
404 -- Note: 1. This is automated generated item level validation procedure.
405 -- The actual validation detail is needed to be added.
406 -- 2. Developer can manually added inter-field level validation.
407 -- End of Comments
408
409 PROCEDURE Validate_picklist_line_rec(
410 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
411 P_Validation_mode IN VARCHAR2,
412 P_picklist_line_Rec IN picklist_line_Rec_Type,
413 X_Return_Status OUT NOCOPY VARCHAR2,
414 X_Msg_Count OUT NOCOPY NUMBER,
415 X_Msg_Data OUT NOCOPY VARCHAR2
416 );
417
418 -- Start of Comments
419 --
420 -- validation procedures
421 --
422 -- p_validation_mode is a constant defined in JTF_PLSQL_API package
423 -- For create: G_CREATE, for update: G_UPDATE
424 -- Note: 1. This is automated generated item level validation procedure.
425 -- The actual validation detail is needed to be added.
426 -- 2. We can also validate table instead of record. There will be an option for user to choose.
427 -- End of Comments
428
429 PROCEDURE Validate_picklist_lines(
430 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
431 P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
432 P_Validation_mode IN VARCHAR2,
433 P_picklist_line_Rec IN picklist_line_Rec_Type,
434 X_Return_Status OUT NOCOPY VARCHAR2,
435 X_Msg_Count OUT NOCOPY NUMBER,
436 X_Msg_Data OUT NOCOPY VARCHAR2
437 );
438 End CSP_picklist_lines_PVT;