1 PACKAGE ASO_LINE_RLTSHIP_PVT AUTHID CURRENT_USER as
2 /* $Header: asovlins.pls 120.1 2005/06/29 12:42:10 appldev ship $ */
3 -- Start of Comments
4 -- Package name : ASO_LINE_RLTSHIP_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_RLTSHIP_Rec_Type
16 -- -------------------------------------------------------
17 -- Parameters:
18 -- LINE_RELATIONSHIP_ID
19 -- CREATION_DATE
20 -- CREATED_BY
21 -- LAST_UPDATED_BY
22 -- LAST_UPDATE_DATE
23 -- LAST_UPDATE_LOGIN
24 -- REQUEST_ID
25 -- PROGRAM_APPLICATION_ID
26 -- PROGRAM_ID
27 -- PROGRAM_UPDATE_DATE
28 -- QUOTE_LINE_ID
29 -- RELATED_QUOTE_LINE_ID
30 -- RELATIONAL_TYPE_CODE
31 -- RECIPROCAL_FLAG
32 -- RELATIONSHIP_TYPE_CODE
33 --
34 -- Required:
35 -- Defaults:
36 -- Note: This is automatic generated record definition, it includes all columns
37 -- defined in the table, developer must manually add or delete some of the attributes.
38 --
39 -- End of Comments
40 /*
41 TYPE LINE_RLTSHIP_Rec_Type IS RECORD
42 (
43 LINE_RELATIONSHIP_ID NUMBER := FND_API.G_MISS_NUM,
44 CREATION_DATE DATE := FND_API.G_MISS_DATE,
45 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
46 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
47 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
48 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
49 REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
50 PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
51 PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
52 PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
53 QUOTE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
54 RELATED_QUOTE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
55 RELATIONAL_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
56 RECIPROCAL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
57 RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
58 );
59
60 G_MISS_LINE_RLTSHIP_REC LINE_RLTSHIP_Rec_Type;
61 TYPE LINE_RLTSHIP_Tbl_Type IS TABLE OF LINE_RLTSHIP_Rec_Type
62 INDEX BY BINARY_INTEGER;
63 G_MISS_LINE_RLTSHIP_TBL LINE_RLTSHIP_Tbl_Type;
64 */
65 -- *******************************************************
66 -- Start of Comments
67 -- *******************************************************
68 -- API Name: Create_line_rltship
69 -- Type : Private
70 -- Pre-Req :
71 -- Parameters:
72 -- IN
73 -- p_api_version_number IN NUMBER Required
74 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
75 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
76 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
77 -- P_LINE_RLTSHIP_Rec IN LINE_RLTSHIP_Rec_Type Required
78 --
79 -- OUT:
80 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
81 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
82 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
83 -- Version : Current version 2.0
84 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
85 -- and basic operation, developer must manually add parameters and business logic as necessary.
86 --
87 -- End of Comments
88 --
89 PROCEDURE Create_line_rltship(
90 P_Api_Version_Number IN NUMBER,
91 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
92 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
93 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
94 P_LINE_RLTSHIP_Rec IN ASO_quote_PUB.LINE_RLTSHIP_Rec_Type := ASO_QUOTE_PUB.G_MISS_LINE_RLTSHIP_REC,
95 --Hint: Add detail tables as parameter lists if it's master-detail relationship.
96 X_LINE_RELATIONSHIP_ID OUT NOCOPY /* file.sql.39 change */ NUMBER,
97 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
98 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
99 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
100 );
101
102 -- *******************************************************
103 -- Start of Comments
104 -- *******************************************************
105 -- API Name: Update_line_rltship
106 -- Type : Private
107 -- Pre-Req :
108 -- Parameters:
109 -- IN
110 -- p_api_version_number IN NUMBER Required
111 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
112 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
113 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
114 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
115 -- P_LINE_RLTSHIP_Rec IN ASO_quote_PUB.LINE_RLTSHIP_Rec_Type Required
116 --
117 -- OUT:
118 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
119 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
120 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
121 -- Version : Current version 2.0
122 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
123 -- and basic operation, developer must manually add parameters and business logic as necessary.
124 --
125 -- End of Comments
126 --
127 -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
128 PROCEDURE Update_line_rltship(
129 P_Api_Version_Number IN NUMBER,
130 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
131 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
132 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
133 -- P_Identity_Salesforce_Id IN NUMBER := NULL,
134 P_LINE_RLTSHIP_Rec IN ASO_quote_PUB.LINE_RLTSHIP_Rec_Type,
135 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
136 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
137 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
138 );
139
140 -- *******************************************************
141 -- Start of Comments
142 -- *******************************************************
143 -- API Name: Delete_line_rltship
144 -- Type : Private
145 -- Pre-Req :
146 -- Parameters:
147 -- IN
148 -- p_api_version_number IN NUMBER Required
149 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
150 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
151 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
152 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
153 -- P_LINE_RLTSHIP_Rec IN ASO_quote_PUB.LINE_RLTSHIP_Rec_Type Required
154 --
155 -- OUT:
156 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
157 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
158 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
159 -- Version : Current version 2.0
160 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
161 -- and basic operation, developer must manually add parameters and business logic as necessary.
162 --
163 -- End of Comments
164 --
165 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
166 -- The Master delete procedure may not be needed depends on different business requirements.
167 PROCEDURE Delete_line_rltship(
168 P_Api_Version_Number IN NUMBER,
169 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
170 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
171 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
172 p_control_rec IN ASO_QUOTE_PUB.control_rec_type := ASO_QUOTE_PUB.G_MISS_Control_Rec,
173 -- P_identity_salesforce_id IN NUMBER := NULL,
174 P_LINE_RLTSHIP_Rec IN ASO_quote_PUB.LINE_RLTSHIP_Rec_Type,
175 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
176 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
177 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
178 );
179
180 -- *******************************************************
181 -- Start of Comments
182 -- *******************************************************
183 -- API Name: Get_line_rltship
184 -- Type : Private
185 -- Pre-Req :
186 -- Parameters:
187 -- IN
188 -- p_api_version_number IN NUMBER Required
189 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
190 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
191 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
192 -- P_LINE_RLTSHIP_Rec IN ASO_quote_PUB.LINE_RLTSHIP_Rec_Type Required
193 -- Hint: Add List of bind variables here
194 -- p_rec_requested IN NUMBER Optional Default = 30
195 -- p_start_rec_ptr IN NUMBER Optional Default = 1
196 --
197 -- Return Total Records Count Flag. This flag controls whether the total record count
198 -- and total record amount is returned.
199 --
200 -- p_return_tot_count IN VARCHAR2 Optional Default = FND_API.G_FALSE
201 -- Hint: User defined record type
202 -- p_order_by_tbl IN AS_UTILITY_PUB.UTIL_ORDER_BY_TBL_TYPE;
203 --
204 -- OUT:
205 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
206 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
207 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
208 -- X_LINE_RLTSHIP_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_quote_PUB.LINE_RLTSHIP_Rec_Type
209 -- x_returned_rec_count OUT NOCOPY /* file.sql.39 change */ NUMBER
210 -- x_next_rec_ptr OUT NOCOPY /* file.sql.39 change */ NUMBER
211 -- x_tot_rec_count OUT NOCOPY /* file.sql.39 change */ NUMBER
212 -- other optional OUT NOCOPY /* file.sql.39 change */ parameters
213 -- x_tot_rec_amount OUT NOCOPY /* file.sql.39 change */ NUMBER
214 -- Version : Current version 2.0
215 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
216 -- and basic operation, developer must manually add parameters and business logic as necessary.
217 --
218 -- End of Comments
219 --
220 -- Start of Comments
221 --
222 -- Item level validation procedures
223 --
224 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
225 -- For create: G_CREATE, for update: G_UPDATE
226 -- Note: 1. This is automated generated item level validation procedure.
227 -- The actual validation detail is needed to be added.
228 --
229 -- End of Comments
230
231 PROCEDURE Validate_LINE_RELATIONSHIP_ID (
232 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
233 P_Validation_mode IN VARCHAR2,
234 P_LINE_RELATIONSHIP_ID IN NUMBER,
235 -- 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.
236 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
237 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
238 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
239 );
240
241 -- Start of Comments
242 --
243 -- Item level validation procedures
244 --
245 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
246 -- For create: G_CREATE, for update: G_UPDATE
247 -- Note: 1. This is automated generated item level validation procedure.
248 -- The actual validation detail is needed to be added.
249 --
250 -- End of Comments
251
252 PROCEDURE Validate_REQUEST_ID (
253 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
254 P_Validation_mode IN VARCHAR2,
255 P_REQUEST_ID IN NUMBER,
256 -- 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.
257 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
258 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
259 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
260 );
261
262 -- Start of Comments
263 --
264 -- Item level validation procedures
265 --
266 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
267 -- For create: G_CREATE, for update: G_UPDATE
268 -- Note: 1. This is automated generated item level validation procedure.
269 -- The actual validation detail is needed to be added.
270 --
271 -- End of Comments
272
273 PROCEDURE Validate_PROG_APPL_ID (
274 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
275 P_Validation_mode IN VARCHAR2,
276 P_PROGRAM_APPLICATION_ID IN NUMBER,
277 -- 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.
278 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
279 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
280 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
281 );
282
283 -- Start of Comments
284 --
285 -- Item level validation procedures
286 --
287 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
288 -- For create: G_CREATE, for update: G_UPDATE
289 -- Note: 1. This is automated generated item level validation procedure.
290 -- The actual validation detail is needed to be added.
291 --
292 -- End of Comments
293
294 PROCEDURE Validate_PROGRAM_ID (
295 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
296 P_Validation_mode IN VARCHAR2,
297 P_PROGRAM_ID IN NUMBER,
298 -- 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.
299 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
300 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
301 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
302 );
303
304 -- Start of Comments
305 --
306 -- Item level validation procedures
307 --
308 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
309 -- For create: G_CREATE, for update: G_UPDATE
310 -- Note: 1. This is automated generated item level validation procedure.
311 -- The actual validation detail is needed to be added.
312 --
313 -- End of Comments
314
315 PROCEDURE Validate_PROGRAM_UPDATE_DATE (
316 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
317 P_Validation_mode IN VARCHAR2,
318 P_PROGRAM_UPDATE_DATE IN DATE,
322 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
319 -- 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.
320 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
321 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
323 );
324
325 -- Start of Comments
326 --
327 -- Item level validation procedures
328 --
329 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
330 -- For create: G_CREATE, for update: G_UPDATE
331 -- Note: 1. This is automated generated item level validation procedure.
332 -- The actual validation detail is needed to be added.
333 --
334 -- End of Comments
335
336 PROCEDURE Validate_QUOTE_LINE_ID (
337 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
338 P_Validation_mode IN VARCHAR2,
339 P_QUOTE_LINE_ID IN NUMBER,
340 -- 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.
341 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
342 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
343 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
344 );
345
346 -- Start of Comments
347 --
348 -- Item level validation procedures
349 --
350 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
351 -- For create: G_CREATE, for update: G_UPDATE
352 -- Note: 1. This is automated generated item level validation procedure.
353 -- The actual validation detail is needed to be added.
354 --
355 -- End of Comments
356
357 PROCEDURE Validate_RELATED_QUOTE_LINE_ID (
358 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
359 P_Validation_mode IN VARCHAR2,
360 P_RELATED_QUOTE_LINE_ID IN NUMBER,
361 -- 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.
362 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
363 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
364 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
365 );
366
367 -- Start of Comments
368 --
369 -- Item level validation procedures
370 --
371 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
372 -- For create: G_CREATE, for update: G_UPDATE
373 -- Note: 1. This is automated generated item level validation procedure.
374 -- The actual validation detail is needed to be added.
375 --
376 -- End of Comments
377
378 PROCEDURE Validate_RELATIONAL_TYPE_CODE (
379 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
380 P_Validation_mode IN VARCHAR2,
381 P_RELATIONAL_TYPE_CODE IN VARCHAR2,
382 -- 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.
383 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
384 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
385 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
386 );
387
388 -- Start of Comments
389 --
390 -- Item level validation procedures
391 --
392 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
393 -- For create: G_CREATE, for update: G_UPDATE
394 -- Note: 1. This is automated generated item level validation procedure.
395 -- The actual validation detail is needed to be added.
396 --
397 -- End of Comments
398
399 PROCEDURE Validate_RECIPROCAL_FLAG (
400 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
401 P_Validation_mode IN VARCHAR2,
402 P_RECIPROCAL_FLAG IN VARCHAR2,
403 -- 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.
404 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
405 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
406 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
407 );
408
409 -- Start of Comments
410 --
411 -- Item level validation procedures
412 --
413 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
414 -- For create: G_CREATE, for update: G_UPDATE
415 -- Note: 1. This is automated generated item level validation procedure.
416 -- The actual validation detail is needed to be added.
417 --
418 -- End of Comments
419
420 PROCEDURE Validate_RLTSHIP_TYPE_CODE (
421 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
422 P_Validation_mode IN VARCHAR2,
423 P_RELATIONSHIP_TYPE_CODE IN VARCHAR2,
424 -- 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.
425 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
426 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
427 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
428 );
429
430 -- Start of Comments
431 --
432 -- Record level validation procedures
433 --
434 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
438 -- 2. Developer can manually added inter-field level validation.
435 -- For create: G_CREATE, for update: G_UPDATE
436 -- Note: 1. This is automated generated item level validation procedure.
437 -- The actual validation detail is needed to be added.
439 -- End of Comments
440
441 PROCEDURE Validate_LINE_RLTSHIP_rec(
442 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
443 P_Validation_mode IN VARCHAR2,
444 P_LINE_RLTSHIP_Rec IN ASO_quote_PUB.LINE_RLTSHIP_Rec_Type,
445 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
446 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
447 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
448 );
449
450 -- Start of Comments
451 --
452 -- validation procedures
453 --
454 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
455 -- For create: G_CREATE, for update: G_UPDATE
456 -- Note: 1. This is automated generated item level validation procedure.
457 -- The actual validation detail is needed to be added.
458 -- 2. We can also validate table instead of record. There will be an option for user to choose.
459 -- End of Comments
460
461 PROCEDURE Validate_line_rltship(
462 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
463 P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
464 P_Validation_mode IN VARCHAR2,
465 P_LINE_RLTSHIP_Rec IN ASO_quote_PUB.LINE_RLTSHIP_Rec_Type,
466 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
467 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
468 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
469 );
470 End ASO_LINE_RLTSHIP_PVT;