1 PACKAGE CSP_RESOURCE_PVT AUTHID CURRENT_USER AS
2 /* $Header: cspvtres.pls 115.7 2003/05/02 16:38:46 hhaugeru ship $ */
3 -- Start of Comments
4 -- Package name : CSP_RESOURCE_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:CSP_Rec_Type
16 -- -------------------------------------------------------
17 -- Parameters:
18 -- CSP_INV_LOC_ASSIGNMENT_ID
19 -- CREATED_BY
20 -- CREATION_DATE
21 -- LAST_UPDATED_BY
22 -- LAST_UPDATE_DATE
23 -- LAST_UPDATE_LOGIN
24 -- RESOURCE_ID
25 -- ORGANIZATION_ID
26 -- SUBINVENTORY_CODE
27 -- LOCATOR_ID
28 -- RESOURCE_TYPE
29 -- EFFECTIVE_DATE_START
30 -- EFFECTIVE_DATE_END
31 -- DEFAULT_CODE
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 CSP_Rec_Type IS RECORD
57 (
58 CSP_INV_LOC_ASSIGNMENT_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 RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
65 ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
66 SUBINVENTORY_CODE VARCHAR2(20) := FND_API.G_MISS_CHAR,
67 LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
68 RESOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
69 EFFECTIVE_DATE_START DATE := FND_API.G_MISS_DATE,
70 EFFECTIVE_DATE_END DATE := FND_API.G_MISS_DATE,
71 DEFAULT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
72 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
73 ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74 ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75 ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76 ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77 ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78 ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79 ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80 ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81 ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82 ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83 ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84 ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85 ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86 ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87 ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR
88 );
89
90 G_MISS_CSP_REC CSP_Rec_Type;
91 TYPE CSP_Tbl_Type IS TABLE OF CSP_Rec_Type
92 INDEX BY BINARY_INTEGER;
93 G_MISS_CSP_TBL CSP_Tbl_Type;
94
95 -- *******************************************************
96 -- Start of Comments
97 -- *******************************************************
98 -- API Name: Create_resource
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_CSP_Rec IN CSP_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_resource(
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_CSP_Rec IN CSP_Rec_Type := G_MISS_CSP_REC,
125 --Hint: Add detail tables as parameter lists if it's master-detail relationship.
126 X_CSP_INV_LOC_ASSIGNMENT_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_resource
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_CSP_Rec IN CSP_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_resource(
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_CSP_Rec IN CSP_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_resource
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_CSP_Rec IN CSP_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_resource(
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_CSP_Rec IN CSP_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 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_CILA (
221 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
222 P_Validation_mode IN VARCHAR2,
223 P_CSP_INV_LOC_ASSIGNMENT_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 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_RESOURCE_ID (
242 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
243 P_Validation_mode IN VARCHAR2,
244 P_RESOURCE_ID 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 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_ORGANIZATION_ID (
263 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
264 P_Validation_mode IN VARCHAR2,
265 P_ORGANIZATION_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 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_SUBINVENTORY_CODE (
284 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
285 P_Validation_mode IN VARCHAR2,
286 P_SUBINVENTORY_CODE IN VARCHAR2,
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 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_LOCATOR_ID (
305 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
306 P_Validation_mode IN VARCHAR2,
307 P_LOCATOR_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.
312 );
309 X_Return_Status OUT NOCOPY VARCHAR2,
310 X_Msg_Count OUT NOCOPY NUMBER,
311 X_Msg_Data OUT NOCOPY VARCHAR2
313
314 -- Start of Comments
315 --
316 -- Item level validation procedures
317 --
318 -- p_validation_mode is a constant defined in 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_RESOURCE_TYPE (
326 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
327 P_Validation_mode IN VARCHAR2,
328 P_RESOURCE_TYPE 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 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_EFFECTIVE_DATE_START (
347 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
348 P_Validation_mode IN VARCHAR2,
349 P_EFFECTIVE_DATE_START IN DATE,
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,
352 X_Msg_Count OUT NOCOPY NUMBER,
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 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_EFFECTIVE_DATE_END (
368 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
369 P_Validation_mode IN VARCHAR2,
370 P_EFFECTIVE_DATE_END IN DATE,
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 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_DEFAULT_CODE (
389 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
390 P_Validation_mode IN VARCHAR2,
391 P_DEFAULT_CODE IN VARCHAR2,
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 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_CSP_rec(
410 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
411 P_Validation_mode IN VARCHAR2,
412 P_CSP_Rec IN CSP_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 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_resource(
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_CSP_Rec IN CSP_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_RESOURCE_PVT;