1 PACKAGE CSP_ORDERHEADERS_PVT AUTHID CURRENT_USER AS
2 /* $Header: cspvtmhs.pls 115.11 2003/05/02 16:37:09 hhaugeru ship $ */
3 -- Start of Comments
4 -- Package name : CSP_ORDERHEADERS_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:MOH_Rec_Type
16 -- -------------------------------------------------------
17 -- Parameters:
18 -- HEADER_ID
19 -- CREATED_BY
20 -- CREATION_DATE
21 -- LAST_UPDATED_BY
22 -- LAST_UPDATE_DATE
23 -- LAST_UPDATE_LOGIN
24 -- CARRIER
25 -- SHIPMENT_METHOD
26 -- AUTORECEIPT_FLAG
27 -- ATTRIBUTE_CATEGORY
28 -- ATTRIBUTE1
29 -- ATTRIBUTE2
30 -- ATTRIBUTE3
31 -- ATTRIBUTE4
32 -- ATTRIBUTE5
33 -- ATTRIBUTE6
34 -- ATTRIBUTE7
35 -- ATTRIBUTE8
36 -- ATTRIBUTE9
37 -- ATTRIBUTE10
38 -- ATTRIBUTE11
39 -- ATTRIBUTE12
40 -- ATTRIBUTE13
41 -- ATTRIBUTE14
42 -- ATTRIBUTE15
43 -- ADDRESS1
44 -- ADDRESS2
45 -- ADDRESS3
46 -- ADDRESS4
47 -- CITY
48 -- POSTAL_CODE
49 -- STATE
50 -- PROVINCE
51 -- COUNTRY
52 --
53 -- Required:
54 -- Defaults:
55 -- Note: This is automatic generated record definition, it includes all columns
56 -- defined in the table, developer must manually add or delete some of the attributes.
57 --
58 -- End of Comments
59
60 TYPE MOH_Rec_Type IS RECORD
61 (
62 HEADER_ID NUMBER := FND_API.G_MISS_NUM,
63 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
64 CREATION_DATE DATE := FND_API.G_MISS_DATE,
65 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
66 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
67 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
68 CARRIER VARCHAR2(50) := FND_API.G_MISS_CHAR,
69 SHIPMENT_METHOD VARCHAR2(50) := FND_API.G_MISS_CHAR,
70 AUTORECEIPT_FLAG VARCHAR2(10) := FND_API.G_MISS_CHAR,
71 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
72 ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73 ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74 ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75 ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76 ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77 ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78 ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79 ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80 ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81 ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82 ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83 ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84 ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85 ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86 ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87 LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
88 PARTY_SITE_ID NUMBER DEFAULT FND_API.G_MISS_NUM
89 );
90
91 G_MISS_MOH_REC MOH_Rec_Type;
92 TYPE MOH_Tbl_Type IS TABLE OF MOH_Rec_Type
93 INDEX BY BINARY_INTEGER;
94 G_MISS_MOH_TBL MOH_Tbl_Type;
95
96 -- *******************************************************
97 -- Start of Comments
98 -- *******************************************************
99 -- API Name: Create_orderheaders
100 -- Type : Private
101 -- Pre-Req :
102 -- Parameters:
103 -- IN
104 -- p_api_version_number IN NUMBER Required
105 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
106 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
107 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
108 -- P_MOH_Rec IN MOH_Rec_Type Required
109 --
110 -- OUT:
111 -- x_return_status OUT NOCOPY VARCHAR2
112 -- x_msg_count OUT NOCOPY NUMBER
113 -- x_msg_data OUT NOCOPY VARCHAR2
114 -- Version : Current version 2.0
115 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
116 -- and basic operation, developer must manually add parameters and business logic as necessary.
117 --
118 -- End of Comments
119 --
120 PROCEDURE Create_orderheaders(
121 P_Api_Version_Number IN NUMBER,
122 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
123 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
124 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
125 P_MOH_Rec IN MOH_Rec_Type := G_MISS_MOH_REC,
126 --Hint: Add detail tables as parameter lists if it's master-detail relationship.
127 X_HEADER_ID OUT NOCOPY NUMBER,
128 X_Return_Status OUT NOCOPY VARCHAR2,
129 X_Msg_Count OUT NOCOPY NUMBER,
130 X_Msg_Data OUT NOCOPY VARCHAR2
131 );
132
133 -- *******************************************************
134 -- Start of Comments
135 -- *******************************************************
136 -- API Name: Update_orderheaders
137 -- Type : Private
138 -- Pre-Req :
139 -- Parameters:
140 -- IN
141 -- p_api_version_number IN NUMBER Required
142 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
143 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
144 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
145 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
146 -- P_MOH_Rec IN MOH_Rec_Type Required
147 --
148 -- OUT:
149 -- x_return_status OUT NOCOPY VARCHAR2
150 -- x_msg_count OUT NOCOPY NUMBER
151 -- x_msg_data OUT NOCOPY VARCHAR2
152 -- Version : Current version 2.0
153 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
154 -- and basic operation, developer must manually add parameters and business logic as necessary.
155 --
156 -- End of Comments
157 --
158 -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
159 PROCEDURE Update_orderheaders(
160 P_Api_Version_Number IN NUMBER,
161 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
162 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
163 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
164 P_Identity_Salesforce_Id IN NUMBER := NULL,
165 P_MOH_Rec IN MOH_Rec_Type,
166 X_Return_Status OUT NOCOPY VARCHAR2,
167 X_Msg_Count OUT NOCOPY NUMBER,
168 X_Msg_Data OUT NOCOPY VARCHAR2
169 );
170
171 -- *******************************************************
172 -- Start of Comments
173 -- *******************************************************
174 -- API Name: Delete_orderheaders
175 -- Type : Private
176 -- Pre-Req :
177 -- Parameters:
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_identity_salesforce_id IN NUMBER Optional Default = NULL
184 -- P_MOH_Rec IN MOH_Rec_Type Required
185 --
186 -- OUT:
187 -- x_return_status OUT NOCOPY VARCHAR2
188 -- x_msg_count OUT NOCOPY NUMBER
189 -- x_msg_data OUT NOCOPY VARCHAR2
190 -- Version : Current version 2.0
191 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
192 -- and basic operation, developer must manually add parameters and business logic as necessary.
193 --
194 -- End of Comments
195 --
196 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
197 -- The Master delete procedure may not be needed depends on different business requirements.
198 PROCEDURE Delete_orderheaders(
199 P_Api_Version_Number IN NUMBER,
200 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
201 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
202 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
203 P_identity_salesforce_id IN NUMBER := NULL,
204 P_MOH_Rec IN MOH_Rec_Type,
205 X_Return_Status OUT NOCOPY VARCHAR2,
206 X_Msg_Count OUT NOCOPY NUMBER,
207 X_Msg_Data OUT NOCOPY VARCHAR2
208 );
209
210 -- Start of Comments
211 --
212 -- Item level validation procedures
213 --
214 -- p_validation_mode is a constant defined in package
215 -- For create: G_CREATE, for update: G_UPDATE
216 -- Note: 1. This is automated generated item level validation procedure.
217 -- The actual validation detail is needed to be added.
218 --
219 -- End of Comments
220
221 PROCEDURE Validate_HEADER_ID (
222 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
223 P_Validation_mode IN VARCHAR2,
224 P_HEADER_ID IN NUMBER,
225 -- 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.
226 X_Return_Status OUT NOCOPY VARCHAR2,
227 X_Msg_Count OUT NOCOPY NUMBER,
228 X_Msg_Data OUT NOCOPY VARCHAR2
229 );
230
231 -- Start of Comments
232 --
233 -- Item level validation procedures
234 --
235 -- p_validation_mode is a constant defined in package
236 -- For create: G_CREATE, for update: G_UPDATE
237 -- Note: 1. This is automated generated item level validation procedure.
238 -- The actual validation detail is needed to be added.
239 --
240 -- End of Comments
241
242 PROCEDURE Validate_CARRIER (
243 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
244 P_Validation_mode IN VARCHAR2,
245 P_CARRIER IN VARCHAR2,
246 -- 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.
247 X_Return_Status OUT NOCOPY VARCHAR2,
248 X_Msg_Count OUT NOCOPY NUMBER,
249 X_Msg_Data OUT NOCOPY VARCHAR2
250 );
251
252 -- Start of Comments
253 --
254 -- Item level validation procedures
255 --
256 -- p_validation_mode is a constant defined in package
257 -- For create: G_CREATE, for update: G_UPDATE
258 -- Note: 1. This is automated generated item level validation procedure.
259 -- The actual validation detail is needed to be added.
260 --
261 -- End of Comments
262
263 PROCEDURE Validate_SHIPMENT_METHOD (
264 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
265 P_Validation_mode IN VARCHAR2,
266 P_SHIPMENT_METHOD IN VARCHAR2,
267 -- 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.
268 X_Return_Status OUT NOCOPY VARCHAR2,
269 X_Msg_Count OUT NOCOPY NUMBER,
270 X_Msg_Data OUT NOCOPY VARCHAR2
271 );
272
273 -- Start of Comments
274 --
275 -- Item level validation procedures
276 --
277 -- p_validation_mode is a constant defined in package
278 -- For create: G_CREATE, for update: G_UPDATE
279 -- Note: 1. This is automated generated item level validation procedure.
280 -- The actual validation detail is needed to be added.
281 --
282 -- End of Comments
283
284 PROCEDURE Validate_AUTORECEIPT_FLAG (
285 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
286 P_Validation_mode IN VARCHAR2,
287 P_AUTORECEIPT_FLAG IN VARCHAR2,
288 -- 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.
289 X_Return_Status OUT NOCOPY VARCHAR2,
290 X_Msg_Count OUT NOCOPY NUMBER,
291 X_Msg_Data OUT NOCOPY VARCHAR2
292 );
293
294 -- Start of Comments
295 --
296 -- Item level validation procedures
297 --
298 -- p_validation_mode is a constant defined in package
299 -- For create: G_CREATE, for update: G_UPDATE
300 -- Note: 1. This is automated generated item level validation procedure.
301 -- The actual validation detail is needed to be added.
302 --
303 -- End of Comments
304
305 /* START OF CHANGES - PHEGDE 02/28
306
307 PROCEDURE Validate_ADDRESS1 (
308 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
309 P_Validation_mode IN VARCHAR2,
310 P_ADDRESS1 IN VARCHAR2,
311 -- 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 X_Return_Status OUT NOCOPY VARCHAR2,
313 X_Msg_Count OUT NOCOPY NUMBER,
314 X_Msg_Data OUT NOCOPY VARCHAR2
315 );
316
317 -- Start of Comments
318 --
319 -- Item level validation procedures
320 --
321 -- p_validation_mode is a constant defined in package
322 -- For create: G_CREATE, for update: G_UPDATE
323 -- Note: 1. This is automated generated item level validation procedure.
324 -- The actual validation detail is needed to be added.
325 --
326 -- End of Comments
327
328 PROCEDURE Validate_ADDRESS2 (
329 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
330 P_Validation_mode IN VARCHAR2,
331 P_ADDRESS2 IN VARCHAR2,
332 -- 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.
333 X_Return_Status OUT NOCOPY VARCHAR2,
334 X_Msg_Count OUT NOCOPY NUMBER,
335 X_Msg_Data OUT NOCOPY VARCHAR2
336 );
337
338 -- Start of Comments
339 --
340 -- Item level validation procedures
341 --
342 -- p_validation_mode is a constant defined in package
343 -- For create: G_CREATE, for update: G_UPDATE
344 -- Note: 1. This is automated generated item level validation procedure.
345 -- The actual validation detail is needed to be added.
346 --
347 -- End of Comments
348
349 PROCEDURE Validate_ADDRESS3 (
350 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
351 P_Validation_mode IN VARCHAR2,
352 P_ADDRESS3 IN VARCHAR2,
353 -- 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.
354 X_Return_Status OUT NOCOPY VARCHAR2,
358
355 X_Msg_Count OUT NOCOPY NUMBER,
356 X_Msg_Data OUT NOCOPY VARCHAR2
357 );
359 -- Start of Comments
360 --
361 -- Item level validation procedures
362 --
363 -- p_validation_mode is a constant defined in package
364 -- For create: G_CREATE, for update: G_UPDATE
365 -- Note: 1. This is automated generated item level validation procedure.
366 -- The actual validation detail is needed to be added.
367 --
368 -- End of Comments
369
370 PROCEDURE Validate_ADDRESS4 (
371 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
372 P_Validation_mode IN VARCHAR2,
373 P_ADDRESS4 IN VARCHAR2,
374 -- 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.
375 X_Return_Status OUT NOCOPY VARCHAR2,
376 X_Msg_Count OUT NOCOPY NUMBER,
377 X_Msg_Data OUT NOCOPY VARCHAR2
378 );
379
380 -- Start of Comments
381 --
382 -- Item level validation procedures
383 --
384 -- p_validation_mode is a constant defined in package
385 -- For create: G_CREATE, for update: G_UPDATE
386 -- Note: 1. This is automated generated item level validation procedure.
387 -- The actual validation detail is needed to be added.
388 --
389 -- End of Comments
390
391 PROCEDURE Validate_CITY (
392 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
393 P_Validation_mode IN VARCHAR2,
394 P_CITY IN VARCHAR2,
395 -- 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.
396 X_Return_Status OUT NOCOPY VARCHAR2,
397 X_Msg_Count OUT NOCOPY NUMBER,
398 X_Msg_Data OUT NOCOPY VARCHAR2
399 );
400
401 -- Start of Comments
402 --
403 -- Item level validation procedures
404 --
405 -- p_validation_mode is a constant defined in package
406 -- For create: G_CREATE, for update: G_UPDATE
407 -- Note: 1. This is automated generated item level validation procedure.
408 -- The actual validation detail is needed to be added.
409 --
410 -- End of Comments
411
412 PROCEDURE Validate_POSTAL_CODE (
413 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
414 P_Validation_mode IN VARCHAR2,
415 P_POSTAL_CODE IN VARCHAR2,
416 -- 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.
417 X_Return_Status OUT NOCOPY VARCHAR2,
418 X_Msg_Count OUT NOCOPY NUMBER,
419 X_Msg_Data OUT NOCOPY VARCHAR2
420 );
421
422 -- Start of Comments
423 --
424 -- Item level validation procedures
425 --
426 -- p_validation_mode is a constant defined in package
427 -- For create: G_CREATE, for update: G_UPDATE
428 -- Note: 1. This is automated generated item level validation procedure.
429 -- The actual validation detail is needed to be added.
430 --
431 -- End of Comments
432
433 PROCEDURE Validate_STATE (
434 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
435 P_Validation_mode IN VARCHAR2,
436 P_STATE IN VARCHAR2,
437 -- 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.
438 X_Return_Status OUT NOCOPY VARCHAR2,
439 X_Msg_Count OUT NOCOPY NUMBER,
440 X_Msg_Data OUT NOCOPY VARCHAR2
441 );
442
443 -- Start of Comments
444 --
445 -- Item level validation procedures
446 --
447 -- p_validation_mode is a constant defined in package
448 -- For create: G_CREATE, for update: G_UPDATE
449 -- Note: 1. This is automated generated item level validation procedure.
450 -- The actual validation detail is needed to be added.
451 --
452 -- End of Comments
453
454 PROCEDURE Validate_PROVINCE (
455 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
456 P_Validation_mode IN VARCHAR2,
457 P_PROVINCE IN VARCHAR2,
458 -- 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.
459 X_Return_Status OUT NOCOPY VARCHAR2,
460 X_Msg_Count OUT NOCOPY NUMBER,
461 X_Msg_Data OUT NOCOPY VARCHAR2
462 );
463
464 -- Start of Comments
465 --
466 -- Item level validation procedures
467 --
468 -- p_validation_mode is a constant defined in package
469 -- For create: G_CREATE, for update: G_UPDATE
470 -- Note: 1. This is automated generated item level validation procedure.
471 -- The actual validation detail is needed to be added.
472 --
473 -- End of Comments
474
475 PROCEDURE Validate_COUNTRY (
476 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
477 P_Validation_mode IN VARCHAR2,
478 P_COUNTRY IN VARCHAR2,
482 X_Msg_Data OUT NOCOPY VARCHAR2
479 -- 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.
480 X_Return_Status OUT NOCOPY VARCHAR2,
481 X_Msg_Count OUT NOCOPY NUMBER,
483 );
484 */
485 -- END OF CHANGES PHEGDE 02/28
486
487
488 -- Start of Comments
489 --
490 -- Record level validation procedures
491 --
492 -- p_validation_mode is a constant defined in package
493 -- For create: G_CREATE, for update: G_UPDATE
494 -- Note: 1. This is automated generated item level validation procedure.
495 -- The actual validation detail is needed to be added.
496 -- 2. Developer can manually added inter-field level validation.
497 -- End of Comments
498
499 PROCEDURE Validate_MOH_rec(
500 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
501 P_Validation_mode IN VARCHAR2,
502 P_MOH_Rec IN MOH_Rec_Type,
503 X_Return_Status OUT NOCOPY VARCHAR2,
504 X_Msg_Count OUT NOCOPY NUMBER,
505 X_Msg_Data OUT NOCOPY VARCHAR2
506 );
507
508 -- Start of Comments
509 --
510 -- validation procedures
511 --
512 -- p_validation_mode is a constant defined in package
513 -- For create: G_CREATE, for update: G_UPDATE
514 -- Note: 1. This is automated generated item level validation procedure.
515 -- The actual validation detail is needed to be added.
516 -- 2. We can also validate table instead of record. There will be an option for user to choose.
517 -- End of Comments
518
519 PROCEDURE Validate_orderheaders(
520 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
521 P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
522 P_Validation_mode IN VARCHAR2,
523 P_MOH_Rec IN MOH_Rec_Type,
524 X_Return_Status OUT NOCOPY VARCHAR2,
525 X_Msg_Count OUT NOCOPY NUMBER,
526 X_Msg_Data OUT NOCOPY VARCHAR2
527 );
528
529
530 End CSP_ORDERHEADERS_PVT;