1 PACKAGE CSP_picklist_header_PVT AUTHID CURRENT_USER AS
2 /* $Header: cspvtphs.pls 115.8 2003/05/02 16:37:53 hhaugeru ship $ */
3 -- Start of Comments
4 -- Package name : CSP_picklist_header_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:PICK_HEADER_Rec_Type
16 -- -------------------------------------------------------
17 -- Parameters:
18 -- picklist_header_id
19 -- CREATED_BY
20 -- CREATION_DATE
21 -- LAST_UPDATED_BY
22 -- LAST_UPDATE_DATE
23 -- LAST_UPDATE_LOGIN
24 -- ORGANIZATION_ID
25 -- PICKLIST_NUMBER
26 -- PICKLIST_STATUS
27 -- DATE_CREATED
28 -- DATE_CONFIRMED
29 -- ATTRIBUTE_CATEGORY
30 -- ATTRIBUTE1
31 -- ATTRIBUTE2
32 -- ATTRIBUTE3
33 -- ATTRIBUTE4
34 -- ATTRIBUTE5
35 -- ATTRIBUTE6
36 -- ATTRIBUTE7
37 -- ATTRIBUTE8
38 -- ATTRIBUTE9
39 -- ATTRIBUTE10
40 -- ATTRIBUTE11
41 -- ATTRIBUTE12
42 -- ATTRIBUTE13
43 -- ATTRIBUTE14
44 -- ATTRIBUTE15
45 --
46 -- Required:
47 -- Defaults:
48 -- Note: This is automatic generated record definition, it includes all columns
49 -- defined in the table, developer must manually add or delete some of the attributes.
50 --
51 -- End of Comments
52
53 TYPE PICK_HEADER_Rec_Type IS RECORD
54 (
55 picklist_header_id NUMBER := FND_API.G_MISS_NUM,
56 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
57 CREATION_DATE DATE := FND_API.G_MISS_DATE,
58 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
59 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
60 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
61 ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
62 PICKLIST_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
63 PICKLIST_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
64 DATE_CREATED DATE := FND_API.G_MISS_DATE,
65 DATE_CONFIRMED DATE := FND_API.G_MISS_DATE,
66 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
67 ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
68 ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
69 ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
70 ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
71 ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
72 ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73 ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74 ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75 ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76 ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77 ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78 ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79 ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80 ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81 ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR
82 );
83
84 G_MISS_PICK_HEADER_REC PICK_HEADER_Rec_Type;
85 TYPE PICK_HEADER_Tbl_Type IS TABLE OF PICK_HEADER_Rec_Type
86 INDEX BY BINARY_INTEGER;
87 G_MISS_PICK_HEADER_TBL PICK_HEADER_Tbl_Type;
88
89 -- *******************************************************
90 -- Start of Comments
91 -- *******************************************************
92 -- API Name: Create_picklist_header
93 -- Type : Private
94 -- Pre-Req :
95 -- Parameters:
96 -- IN
97 -- p_api_version_number IN NUMBER Required
98 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
99 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
100 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
101 -- P_PICK_HEADER_Rec IN PICK_HEADER_Rec_Type Required
102 --
103 -- OUT:
104 -- x_return_status OUT NOCOPY VARCHAR2
105 -- x_msg_count OUT NOCOPY NUMBER
106 -- x_msg_data OUT NOCOPY VARCHAR2
107 -- Version : Current version 2.0
108 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
109 -- and basic operation, developer must manually add parameters and business logic as necessary.
110 --
111 -- End of Comments
112 --
113 PROCEDURE Create_picklist_header(
114 P_Api_Version_Number IN NUMBER,
115 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
116 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
117 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
118 P_PICK_HEADER_Rec IN PICK_HEADER_Rec_Type := G_MISS_PICK_HEADER_REC,
119 --Hint: Add detail tables as parameter lists if it's master-detail relationship.
120 X_picklist_header_id OUT NOCOPY NUMBER,
121 X_Return_Status OUT NOCOPY VARCHAR2,
122 X_Msg_Count OUT NOCOPY NUMBER,
123 X_Msg_Data OUT NOCOPY VARCHAR2
124 );
125
126 -- *******************************************************
127 -- Start of Comments
128 -- *******************************************************
129 -- API Name: Update_picklist_header
130 -- Type : Private
131 -- Pre-Req :
132 -- Parameters:
133 -- IN
134 -- p_api_version_number IN NUMBER Required
135 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
136 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
137 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
138 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
139 -- P_PICK_HEADER_Rec IN PICK_HEADER_Rec_Type Required
140 --
141 -- OUT:
142 -- x_return_status OUT NOCOPY VARCHAR2
143 -- x_msg_count OUT NOCOPY NUMBER
144 -- x_msg_data OUT NOCOPY VARCHAR2
145 -- Version : Current version 2.0
146 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
147 -- and basic operation, developer must manually add parameters and business logic as necessary.
148 --
149 -- End of Comments
150 --
151 -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
152 PROCEDURE Update_picklist_header(
153 P_Api_Version_Number IN NUMBER,
154 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
155 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
156 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
157 --P_Identity_Salesforce_Id IN NUMBER := NULL,
158 P_PICK_HEADER_Rec IN PICK_HEADER_Rec_Type,
159 X_Return_Status OUT NOCOPY VARCHAR2,
160 X_Msg_Count OUT NOCOPY NUMBER,
161 X_Msg_Data OUT NOCOPY VARCHAR2
162 );
163
164 -- *******************************************************
165 -- Start of Comments
166 -- *******************************************************
167 -- API Name: Delete_picklist_header
168 -- Type : Private
169 -- Pre-Req :
170 -- Parameters:
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_identity_salesforce_id IN NUMBER Optional Default = NULL
177 -- P_PICK_HEADER_Rec IN PICK_HEADER_Rec_Type Required
178 --
179 -- OUT:
180 -- x_return_status OUT NOCOPY VARCHAR2
181 -- x_msg_count OUT NOCOPY NUMBER
182 -- x_msg_data OUT NOCOPY VARCHAR2
183 -- Version : Current version 2.0
184 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
185 -- and basic operation, developer must manually add parameters and business logic as necessary.
186 --
187 -- End of Comments
188 --
189 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
190 -- The Master delete procedure may not be needed depends on different business requirements.
191 PROCEDURE Delete_picklist_header(
192 P_Api_Version_Number IN NUMBER,
193 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
194 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
195 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
196 --P_identity_salesforce_id IN NUMBER := NULL,
197 P_PICK_HEADER_Rec IN PICK_HEADER_Rec_Type,
198 X_Return_Status OUT NOCOPY VARCHAR2,
199 X_Msg_Count OUT NOCOPY NUMBER,
200 X_Msg_Data OUT NOCOPY VARCHAR2
201 );
202
203
204
205 -- Start of Comments
206 --
207 -- Item level validation procedures
208 --
209 -- p_validation_mode is a constant defined in JTF_PLSQL_API package
210 -- For create: G_CREATE, for update: G_UPDATE
211 -- Note: 1. This is automated generated item level validation procedure.
212 -- The actual validation detail is needed to be added.
213 --
214 -- End of Comments
215
216 PROCEDURE Validate_picklist_header_id (
217 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
218 P_Validation_mode IN VARCHAR2,
219 P_picklist_header_id IN NUMBER,
220 -- 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.
221 X_Return_Status OUT NOCOPY VARCHAR2,
222 X_Msg_Count OUT NOCOPY NUMBER,
223 X_Msg_Data OUT NOCOPY VARCHAR2
224 );
225
226 -- Start of Comments
227 --
228 -- Item level validation procedures
229 --
230 -- p_validation_mode is a constant defined in JTF_PLSQL_API package
231 -- For create: G_CREATE, for update: G_UPDATE
232 -- Note: 1. This is automated generated item level validation procedure.
233 -- The actual validation detail is needed to be added.
234 --
235 -- End of Comments
236
237 PROCEDURE Validate_ORGANIZATION_ID (
238 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
239 P_Validation_mode IN VARCHAR2,
240 P_ORGANIZATION_ID IN NUMBER,
241 -- 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.
242 X_Return_Status OUT NOCOPY VARCHAR2,
243 X_Msg_Count OUT NOCOPY NUMBER,
244 X_Msg_Data OUT NOCOPY VARCHAR2
245 );
246
247 -- Start of Comments
248 --
249 -- Item level validation procedures
250 --
251 -- p_validation_mode is a constant defined in JTF_PLSQL_API package
252 -- For create: G_CREATE, for update: G_UPDATE
253 -- Note: 1. This is automated generated item level validation procedure.
254 -- The actual validation detail is needed to be added.
255 --
256 -- End of Comments
257
258 PROCEDURE Validate_PICKLIST_NUMBER (
259 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
260 P_Validation_mode IN VARCHAR2,
261 P_PICKLIST_NUMBER IN VARCHAR2,
262 -- 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.
263 X_Return_Status OUT NOCOPY VARCHAR2,
264 X_Msg_Count OUT NOCOPY NUMBER,
265 X_Msg_Data OUT NOCOPY VARCHAR2
266 );
267
268 -- Start of Comments
269 --
270 -- Item level validation procedures
271 --
272 -- p_validation_mode is a constant defined in JTF_PLSQL_API package
273 -- For create: G_CREATE, for update: G_UPDATE
274 -- Note: 1. This is automated generated item level validation procedure.
275 -- The actual validation detail is needed to be added.
276 --
277 -- End of Comments
278
279 PROCEDURE Validate_PICKLIST_STATUS (
280 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
281 P_Validation_mode IN VARCHAR2,
282 P_PICKLIST_STATUS IN VARCHAR2,
283 -- 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.
284 X_Return_Status OUT NOCOPY VARCHAR2,
285 X_Msg_Count OUT NOCOPY NUMBER,
286 X_Msg_Data OUT NOCOPY VARCHAR2
287 );
288
289 -- Start of Comments
290 --
291 -- Item level validation procedures
292 --
293 -- p_validation_mode is a constant defined in JTF_PLSQL_API package
294 -- For create: G_CREATE, for update: G_UPDATE
295 -- Note: 1. This is automated generated item level validation procedure.
296 -- The actual validation detail is needed to be added.
297 --
298 -- End of Comments
299
300 PROCEDURE Validate_DATE_CREATED (
301 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
302 P_Validation_mode IN VARCHAR2,
303 P_DATE_CREATED IN DATE,
304 -- 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.
305 X_Return_Status OUT NOCOPY VARCHAR2,
306 X_Msg_Count OUT NOCOPY NUMBER,
307 X_Msg_Data OUT NOCOPY VARCHAR2
308 );
309
310 -- Start of Comments
311 --
312 -- Item level validation procedures
313 --
314 -- p_validation_mode is a constant defined in JTF_PLSQL_API package
315 -- For create: G_CREATE, for update: G_UPDATE
316 -- Note: 1. This is automated generated item level validation procedure.
317 -- The actual validation detail is needed to be added.
318 --
319 -- End of Comments
320
321 PROCEDURE Validate_DATE_CONFIRMED (
322 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
323 P_Validation_mode IN VARCHAR2,
324 P_DATE_CONFIRMED IN DATE,
325 -- 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.
326 X_Return_Status OUT NOCOPY VARCHAR2,
327 X_Msg_Count OUT NOCOPY NUMBER,
328 X_Msg_Data OUT NOCOPY VARCHAR2
329 );
330
331 -- Start of Comments
332 --
333 -- Record level validation procedures
334 --
335 -- p_validation_mode is a constant defined in JTF_PLSQL_API package
336 -- For create: G_CREATE, for update: G_UPDATE
337 -- Note: 1. This is automated generated item level validation procedure.
338 -- The actual validation detail is needed to be added.
339 -- 2. Developer can manually added inter-field level validation.
340 -- End of Comments
341
342 PROCEDURE Validate_PICK_HEADER_rec(
343 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
344 P_Validation_mode IN VARCHAR2,
345 P_PICK_HEADER_Rec IN PICK_HEADER_Rec_Type,
346 X_Return_Status OUT NOCOPY VARCHAR2,
347 X_Msg_Count OUT NOCOPY NUMBER,
351 -- Start of Comments
348 X_Msg_Data OUT NOCOPY VARCHAR2
349 );
350
352 --
353 -- validation procedures
354 --
355 -- p_validation_mode is a constant defined in JTF_PLSQL_API package
356 -- For create: G_CREATE, for update: G_UPDATE
357 -- Note: 1. This is automated generated item level validation procedure.
358 -- The actual validation detail is needed to be added.
359 -- 2. We can also validate table instead of record. There will be an option for user to choose.
360 -- End of Comments
361
362 PROCEDURE Validate_picklist_header(
363 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
364 P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
365 P_Validation_mode IN VARCHAR2,
366 P_PICK_HEADER_Rec IN PICK_HEADER_Rec_Type,
367 X_Return_Status OUT NOCOPY VARCHAR2,
368 X_Msg_Count OUT NOCOPY NUMBER,
369 X_Msg_Data OUT NOCOPY VARCHAR2
370 );
371 End CSP_picklist_header_PVT;