DBA Data[Home] [Help]

PACKAGE: APPS.ASO_LINE_ATTRIBS_PVT

Source


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;