1 PACKAGE ASO_LINE_ATTRIBS_PVT AUTHID CURRENT_USER as
2 /* $Header: asovlats.pls 120.1 2005/06/29 12:42:02 appldev ship $ */
3 -- Start of Comments
4 -- Package name : ASO_LINE_ATTRIBS_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:LINE_ATTRIBS_Rec_Type
16 -- -------------------------------------------------------
17 -- Parameters:
18 -- LINE_ATTRIBUTE_ID
19 -- CREATION_DATE
20 -- CREATED_BY
21 -- LAST_UPDATE_DATE
22 -- LAST_UPDATED_BY
23 -- LAST_UPDATE_LOGIN
24 -- REQUEST_ID
25 -- PROGRAM_APPLICATION_ID
26 -- PROGRAM_ID
27 -- PROGRAM_UPDATE_DATE
28 -- QUOTE_LINE_ID
29 -- ATTRIBUTE_TYPE_CODE
30 -- NAME
31 -- VALUE
32 -- START_DATE_ACTIVE
33 -- END_DATE_ACTIVE
34 --
35 -- Required:
36 -- Defaults:
37 -- Note: This is automatic generated record definition, it includes all columns
38 -- defined in the table, developer must manually add or delete some of the attributes.
39 --
40 -- End of Comments
41 /*
42 TYPE LINE_ATTRIBS_Rec_Type IS RECORD
43 (
44 LINE_ATTRIBUTE_ID NUMBER := FND_API.G_MISS_NUM,
45 CREATION_DATE DATE := FND_API.G_MISS_DATE,
46 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
47 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
48 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
49 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
50 REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
51 PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
52 PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
53 PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
54 QUOTE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
55 ATTRIBUTE_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
56 NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
57 VALUE VARCHAR2(2000) := FND_API.G_MISS_CHAR,
58 START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
59 END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE
60 );
61
62 G_MISS_LINE_ATTRIBS_REC ASO_quote_PUB.LINE_ATTRIBS_EXT_rec_type;
63 TYPE LINE_ATTRIBS_Tbl_Type IS TABLE OF LINE_ATTRIBS_Rec_Type
64 INDEX BY BINARY_INTEGER;
65 G_MISS_LINE_ATTRIBS_TBL LINE_ATTRIBS_Tbl_Type;
66 */
67 -- *******************************************************
68 -- Start of Comments
69 -- *******************************************************
70 -- API Name: Create_line_attribs
71 -- Type : Private
72 -- Pre-Req :
73 -- Parameters:
74 -- IN
75 -- p_api_version_number IN NUMBER Required
76 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
77 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
78 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
79 -- P_LINE_ATTRIBS_Rec IN LINE_ATTRIBS_Rec_Type Required
80 --
81 -- OUT:
82 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
83 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
84 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
85 -- Version : Current version 2.0
86 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
87 -- and basic operation, developer must manually add parameters and business logic as necessary.
88 --
89 -- End of Comments
90 --
91 PROCEDURE Create_line_attribs(
92 P_Api_Version_Number IN NUMBER,
93 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
94 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
95 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
96 P_LINE_ATTRIBS_Rec IN ASO_quote_PUB.LINE_ATTRIBS_EXT_rec_type := ASO_quote_PUB.G_MISS_LINE_ATTRIBS_EXT_REC,
97 --Hint: Add detail tables as parameter lists if it's master-detail relationship.
98 X_LINE_ATTRIB_ID OUT NOCOPY /* file.sql.39 change */ NUMBER,
99 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
100 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
101 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
102 );
103
104 -- *******************************************************
105 -- Start of Comments
106 -- *******************************************************
107 -- API Name: Update_line_attribs
108 -- Type : Private
109 -- Pre-Req :
110 -- Parameters:
111 -- IN
112 -- p_api_version_number IN NUMBER Required
113 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
114 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
115 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
116 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
117 -- P_LINE_ATTRIBS_Rec IN ASO_quote_PUB.LINE_ATTRIBS_EXT_rec_type Required
118 --
119 -- OUT:
120 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
121 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
122 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
123 -- Version : Current version 2.0
124 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
125 -- and basic operation, developer must manually add parameters and business logic as necessary.
126 --
127 -- End of Comments
128 --
129 -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
130 PROCEDURE Update_line_attribs(
131 P_Api_Version_Number IN NUMBER,
132 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
133 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
134 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
135 -- P_Identity_Salesforce_Id IN NUMBER := NULL,
136 P_LINE_ATTRIBS_Rec IN ASO_quote_PUB.LINE_ATTRIBS_EXT_rec_type,
137 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
138 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
139 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
140 );
141
142 -- *******************************************************
143 -- Start of Comments
144 -- *******************************************************
145 -- API Name: Delete_line_attribs
146 -- Type : Private
147 -- Pre-Req :
148 -- Parameters:
149 -- IN
150 -- p_api_version_number IN NUMBER Required
151 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
152 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
153 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
154 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
155 -- P_LINE_ATTRIBS_Rec IN ASO_quote_PUB.LINE_ATTRIBS_EXT_rec_type Required
156 --
157 -- OUT:
158 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
159 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
160 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
161 -- Version : Current version 2.0
162 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
163 -- and basic operation, developer must manually add parameters and business logic as necessary.
164 --
165 -- End of Comments
166 --
167 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
168 -- The Master delete procedure may not be needed depends on different business requirements.
169 PROCEDURE Delete_line_attribs(
170 P_Api_Version_Number IN NUMBER,
171 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
172 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
173 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
174 -- P_identity_salesforce_id IN NUMBER := NULL,
175 P_LINE_ATTRIBS_Rec IN ASO_quote_PUB.LINE_ATTRIBS_EXT_rec_type,
176 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
177 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
178 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
179 );
180
181
182
183
184 -- Start of Comments
185 --
186 -- Item level validation procedures
187 --
188 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
189 -- For create: G_CREATE, for update: G_UPDATE
190 -- Note: 1. This is automated generated item level validation procedure.
191 -- The actual validation detail is needed to be added.
192 --
193 -- End of Comments
194
195 PROCEDURE Validate_LINE_ATTRIBUTE_ID (
196 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
197 P_Validation_mode IN VARCHAR2,
198 P_LINE_ATTRIBUTE_ID IN NUMBER,
199 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
200 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
201 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
202 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
203 );
204
205 -- Start of Comments
206 --
207 -- Item level validation procedures
208 --
209 -- p_validation_mode is a constant defined in AS_UTILITY_PVT 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_REQUEST_ID (
217 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
218 P_Validation_mode IN VARCHAR2,
219 P_REQUEST_ID IN NUMBER,
220 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
221 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
222 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
223 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
224 );
225
226 -- Start of Comments
227 --
228 -- Item level validation procedures
229 --
230 -- p_validation_mode is a constant defined in AS_UTILITY_PVT 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_PROG_APPL_ID (
238 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
239 P_Validation_mode IN VARCHAR2,
240 P_PROGRAM_APPLICATION_ID IN NUMBER,
241 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
242 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
243 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
244 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
245 );
246
247 -- Start of Comments
248 --
249 -- Item level validation procedures
250 --
251 -- p_validation_mode is a constant defined in AS_UTILITY_PVT 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_PROGRAM_ID (
259 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
260 P_Validation_mode IN VARCHAR2,
261 P_PROGRAM_ID IN NUMBER,
262 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
263 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
267
264 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
265 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
266 );
268 -- Start of Comments
269 --
270 -- Item level validation procedures
271 --
272 -- p_validation_mode is a constant defined in AS_UTILITY_PVT 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_PROGRAM_UPDATE_DATE (
280 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
281 P_Validation_mode IN VARCHAR2,
282 P_PROGRAM_UPDATE_DATE IN DATE,
283 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
284 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
285 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
286 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
287 );
288
289 -- Start of Comments
290 --
291 -- Item level validation procedures
292 --
293 -- p_validation_mode is a constant defined in AS_UTILITY_PVT 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_QUOTE_LINE_ID (
301 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
302 P_Validation_mode IN VARCHAR2,
303 P_QUOTE_LINE_ID IN NUMBER,
304 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
305 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
306 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
307 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
308 );
309
310
311 PROCEDURE Validate_ATTRIBUTE_TYPE_CODE(
312 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
313 P_Validation_mode IN VARCHAR2,
314 P_ATTRIBUTE_TYPE_CODE IN VARCHAR2,
315 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
316 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
317 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
318 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
319
320
321 PROCEDURE Validate_STATUS(
322 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
323 P_Validation_mode IN VARCHAR2,
324 P_STATUS IN VARCHAR2,
325 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
326 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
327 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
328 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
329
330
331
332
333 -- Start of Comments
334 --
335 -- Item level validation procedures
336 --
337 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
338 -- For create: G_CREATE, for update: G_UPDATE
339 -- Note: 1. This is automated generated item level validation procedure.
340 -- The actual validation detail is needed to be added.
341 --
342 -- End of Comments
343
344 PROCEDURE Validate_NAME (
345 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
346 P_Validation_mode IN VARCHAR2,
347 P_NAME IN VARCHAR2,
348 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
349 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
350 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
351 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
352 );
353
354 -- Start of Comments
355 --
356 -- Item level validation procedures
357 --
358 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
359 -- For create: G_CREATE, for update: G_UPDATE
360 -- Note: 1. This is automated generated item level validation procedure.
361 -- The actual validation detail is needed to be added.
362 --
363 -- End of Comments
364
365 PROCEDURE Validate_VALUE (
366 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
367 P_Validation_mode IN VARCHAR2,
368 P_VALUE IN VARCHAR2,
369 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
370 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
371 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
372 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
373 );
374
375 -- Start of Comments
376 --
377 -- Item level validation procedures
378 --
379 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
380 -- For create: G_CREATE, for update: G_UPDATE
384 -- End of Comments
381 -- Note: 1. This is automated generated item level validation procedure.
382 -- The actual validation detail is needed to be added.
383 --
385
386 PROCEDURE Validate_START_DATE_ACTIVE (
387 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
388 P_Validation_mode IN VARCHAR2,
389 P_START_DATE_ACTIVE IN DATE,
390 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
391 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
392 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
393 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
394 );
395
396 -- Start of Comments
397 --
398 -- Item level validation procedures
399 --
400 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
401 -- For create: G_CREATE, for update: G_UPDATE
402 -- Note: 1. This is automated generated item level validation procedure.
403 -- The actual validation detail is needed to be added.
404 --
405 -- End of Comments
406
407 PROCEDURE Validate_END_DATE_ACTIVE (
408 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
409 P_Validation_mode IN VARCHAR2,
410 P_END_DATE_ACTIVE IN DATE,
411 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
412 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
413 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
414 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
415 );
416
417 -- Start of Comments
418 --
419 -- Record level validation procedures
420 --
421 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
422 -- For create: G_CREATE, for update: G_UPDATE
423 -- Note: 1. This is automated generated item level validation procedure.
424 -- The actual validation detail is needed to be added.
425 -- 2. Developer can manually added inter-field level validation.
426 -- End of Comments
427
428 PROCEDURE Validate_LINE_ATTRIBS_rec(
429 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
430 P_Validation_mode IN VARCHAR2,
431 P_LINE_ATTRIBS_Rec IN ASO_quote_PUB.LINE_ATTRIBS_EXT_rec_type,
432 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
433 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
434 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
435 );
436
437 -- Start of Comments
438 --
439 -- validation procedures
440 --
441 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
442 -- For create: G_CREATE, for update: G_UPDATE
443 -- Note: 1. This is automated generated item level validation procedure.
444 -- The actual validation detail is needed to be added.
445 -- 2. We can also validate table instead of record. There will be an option for user to choose.
446 -- End of Comments
447
448 PROCEDURE Validate_line_attribs(
449 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
450 P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
451 P_Validation_mode IN VARCHAR2,
452 P_LINE_ATTRIBS_Rec IN ASO_quote_PUB.LINE_ATTRIBS_EXT_rec_type,
453 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
454 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
455 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
456 );
457 End ASO_LINE_ATTRIBS_PVT;