[Home] [Help]
PACKAGE: APPS.ASO_RELATED_OBJ_PVT
Source
1 PACKAGE aso_RELATED_OBJ_PVT AUTHID CURRENT_USER as
2 /* $Header: asovobjs.pls 120.1 2005/06/29 12:42:26 appldev ship $ */
3 -- Start of Comments
4 -- Package name : aso_RELATED_OBJ_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:RELATED_OBJ_Rec_Type
16 -- -------------------------------------------------------
17 -- Parameters:
18 -- RELATED_OBJECT_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_OBJECT_TYPE_CODE
29 -- QUOTE_OBJECT_ID
30 -- OBJECT_TYPE_CODE
31 -- OBJECT_ID
32 -- RELATIONSHIP_TYPE_CODE
33 -- RECIPROCAL_FLAG
34 -- QUOTE_OBJECT_CODE
35 --
36 -- Required:
37 -- Defaults:
38 -- Note: This is automatic generated record definition, it includes all columns
39 -- defined in the table, developer must manually add or delete some of the attributes.
40 --
41 -- End of Comments
42
43 /*TYPE RELATED_OBJ_Rec_Type IS RECORD
44 (
45 RELATED_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
46 CREATION_DATE DATE := FND_API.G_MISS_DATE,
47 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
48 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
49 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
50 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
51 REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
52 PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
53 PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
54 PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
55 QUOTE_OBJECT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
56 QUOTE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
57 OBJECT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
58 OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
59 RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
60 RECIPROCAL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
61 QUOTE_OBJECT_CODE NUMBER := FND_API.G_MISS_NUM
62 );
63
64 G_MISS_RELATED_OBJ_REC RELATED_OBJ_Rec_Type;
65 TYPE RELATED_OBJ_Tbl_Type IS TABLE OF RELATED_OBJ_Rec_Type
66 INDEX BY BINARY_INTEGER;
67 G_MISS_RELATED_OBJ_TBL RELATED_OBJ_Tbl_Type;
68 */
69
70 -- *******************************************************
71 -- Start of Comments
72 -- *******************************************************
73 -- API Name: Create_related_obj
74 -- Type : Private
75 -- Pre-Req :
76 -- Parameters:
77 -- IN
78 -- p_api_version_number IN NUMBER Required
79 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
80 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
81 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
82 -- P_RELATED_OBJ_Rec IN RELATED_OBJ_Rec_Type Required
83 --
84 -- OUT:
85 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
86 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
87 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
88 -- Version : Current version 2.0
89 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
90 -- and basic operation, developer must manually add parameters and business logic as necessary.
91 --
92 -- End of Comments
93 --
94 PROCEDURE Create_related_obj(
95 P_Api_Version_Number IN NUMBER,
96 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
97 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
98 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
99 P_RELATED_OBJ_Rec IN ASO_quote_PUB.RELATED_OBJ_Rec_Type := ASO_quote_PUB.G_MISS_RELATED_OBJ_REC,
100 --Hint: Add detail tables as parameter lists if it's master-detail relationship.
101 X_RELATED_OBJECT_ID OUT NOCOPY /* file.sql.39 change */ NUMBER,
102 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
103 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
104 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
105 );
106
107 -- *******************************************************
108 -- Start of Comments
109 -- *******************************************************
110 -- API Name: Update_related_obj
111 -- Type : Private
112 -- Pre-Req :
113 -- Parameters:
114 -- IN
115 -- p_api_version_number IN NUMBER Required
116 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
117 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
118 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
119 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
120 -- P_RELATED_OBJ_Rec IN RELATED_OBJ_Rec_Type Required
121 --
122 -- OUT:
123 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
124 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
125 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
126 -- Version : Current version 2.0
127 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
128 -- and basic operation, developer must manually add parameters and business logic as necessary.
129 --
130 -- End of Comments
131 --
132 -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
133 PROCEDURE Update_related_obj(
134 P_Api_Version_Number IN NUMBER,
135 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
136 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
137 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
138 -- P_Identity_Salesforce_Id IN NUMBER := NULL,
139 P_RELATED_OBJ_Rec IN ASO_QUOTE_PUB.RELATED_OBJ_Rec_Type,
140 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
141 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
142 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
143 );
144
145 -- *******************************************************
146 -- Start of Comments
147 -- *******************************************************
148 -- API Name: Delete_related_obj
149 -- Type : Private
150 -- Pre-Req :
151 -- Parameters:
152 -- IN
153 -- p_api_version_number IN NUMBER Required
154 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
155 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
156 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
157 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
158 -- P_RELATED_OBJ_Rec IN RELATED_OBJ_Rec_Type Required
159 --
160 -- OUT:
161 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
162 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
163 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
164 -- Version : Current version 2.0
165 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
166 -- and basic operation, developer must manually add parameters and business logic as necessary.
167 --
168 -- End of Comments
169 --
170 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
171 -- The Master delete procedure may not be needed depends on different business requirements.
172 PROCEDURE Delete_related_obj(
173 P_Api_Version_Number IN NUMBER,
174 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
175 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
176 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
177 -- P_identity_salesforce_id IN NUMBER := NULL,
178 P_RELATED_OBJ_Rec IN ASO_QUOTE_PUB.RELATED_OBJ_Rec_Type,
179 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
180 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
181 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
182 );
183
184 -- *******************************************************
185 -- Start of Comments
186 -- *******************************************************
187 -- API Name: Get_related_obj
188 -- Type : Private
189 -- Pre-Req :
190 -- Parameters:
191 -- IN
192 -- p_api_version_number IN NUMBER Required
193 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
194 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
195 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
196 -- P_RELATED_OBJ_Rec IN RELATED_OBJ_Rec_Type Required
197 -- Hint: Add List of bind variables here
198 -- p_rec_requested IN NUMBER Optional Default = 30
199 -- p_start_rec_ptr IN NUMBER Optional Default = 1
200 --
201 -- Return Total Records Count Flag. This flag controls whether the total record count
202 -- and total record amount is returned.
203 --
204 -- p_return_tot_count IN VARCHAR2 Optional Default = FND_API.G_FALSE
205 -- Hint: User defined record type
206 -- p_order_by_tbl IN AS_UTILITY_PUB.UTIL_ORDER_BY_TBL_TYPE;
207 --
208 -- OUT:
209 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
210 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
211 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
212 -- X_RELATED_OBJ_Tbl OUT NOCOPY /* file.sql.39 change */ RELATED_OBJ_Rec_Type
213 -- x_returned_rec_count OUT NOCOPY /* file.sql.39 change */ NUMBER
214 -- x_next_rec_ptr OUT NOCOPY /* file.sql.39 change */ NUMBER
215 -- x_tot_rec_count OUT NOCOPY /* file.sql.39 change */ NUMBER
216 -- other optional OUT NOCOPY /* file.sql.39 change */ parameters
217 -- x_tot_rec_amount OUT NOCOPY /* file.sql.39 change */ NUMBER
218 -- Version : Current version 2.0
219 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
220 -- and basic operation, developer must manually add parameters and business logic as necessary.
221 --
222 -- End of Comments
223 --
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_RELATED_OBJECT_ID (
238 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
239 P_Validation_mode IN VARCHAR2,
240 P_RELATED_OBJECT_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_REQUEST_ID (
259 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
260 P_Validation_mode IN VARCHAR2,
261 P_REQUEST_ID IN NUMBER,
262 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
263 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
264 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
265 );
266
267 -- Start of Comments
268 --
269 -- Item level validation procedures
270 --
271 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
272 -- For create: G_CREATE, for update: G_UPDATE
273 -- Note: 1. This is automated generated item level validation procedure.
274 -- The actual validation detail is needed to be added.
275 --
276 -- End of Comments
277
278 PROCEDURE Validate_PROGRAM_APPL_ID (
279 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
280 P_Validation_mode IN VARCHAR2,
281 P_PROGRAM_APPLICATION_ID IN NUMBER,
282 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
283 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
284 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
285 );
286
287 -- Start of Comments
288 --
289 -- Item level validation procedures
290 --
294 -- The actual validation detail is needed to be added.
291 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
292 -- For create: G_CREATE, for update: G_UPDATE
293 -- Note: 1. This is automated generated item level validation procedure.
295 --
296 -- End of Comments
297
298 PROCEDURE Validate_PROGRAM_ID (
299 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
300 P_Validation_mode IN VARCHAR2,
301 P_PROGRAM_ID IN NUMBER,
302 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
303 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
304 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
305 );
306
307 -- Start of Comments
308 --
309 -- Item level validation procedures
310 --
311 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
312 -- For create: G_CREATE, for update: G_UPDATE
313 -- Note: 1. This is automated generated item level validation procedure.
314 -- The actual validation detail is needed to be added.
315 --
316 -- End of Comments
317
318 PROCEDURE Validate_PROGRAM_UPDATE_DATE (
319 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
320 P_Validation_mode IN VARCHAR2,
321 P_PROGRAM_UPDATE_DATE IN DATE,
322 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
323 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
324 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
325 );
326
327 -- Start of Comments
328 --
329 -- Item level validation procedures
330 --
331 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
332 -- For create: G_CREATE, for update: G_UPDATE
333 -- Note: 1. This is automated generated item level validation procedure.
334 -- The actual validation detail is needed to be added.
335 --
336 -- End of Comments
337
338 PROCEDURE Validate_QTE_OBJ_TYPE_CODE (
339 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
340 P_Validation_mode IN VARCHAR2,
341 P_QUOTE_OBJECT_TYPE_CODE IN VARCHAR2,
342 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
343 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
344 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
345 );
346
347 -- Start of Comments
348 --
349 -- Item level validation procedures
350 --
351 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
352 -- For create: G_CREATE, for update: G_UPDATE
353 -- Note: 1. This is automated generated item level validation procedure.
354 -- The actual validation detail is needed to be added.
355 --
356 -- End of Comments
357
358 PROCEDURE Validate_QUOTE_OBJECT_ID (
359 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
360 P_Validation_mode IN VARCHAR2,
361 P_QUOTE_OBJECT_ID IN NUMBER,
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_OBJECT_TYPE_CODE (
379 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
380 P_Validation_mode IN VARCHAR2,
381 P_OBJECT_TYPE_CODE IN VARCHAR2,
382 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
383 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
384 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
385 );
386
387 -- Start of Comments
388 --
389 -- Item level validation procedures
390 --
391 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
392 -- For create: G_CREATE, for update: G_UPDATE
393 -- Note: 1. This is automated generated item level validation procedure.
394 -- The actual validation detail is needed to be added.
395 --
396 -- End of Comments
397
398 PROCEDURE Validate_OBJECT_ID (
399 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
400 P_Validation_mode IN VARCHAR2,
401 P_OBJECT_ID IN NUMBER,
402 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
403 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
404 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
405 );
406
407 -- Start of Comments
408 --
409 -- Item level validation procedures
410 --
411 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
412 -- For create: G_CREATE, for update: G_UPDATE
413 -- Note: 1. This is automated generated item level validation procedure.
414 -- The actual validation detail is needed to be added.
415 --
416 -- End of Comments
417
418 PROCEDURE Validate_RLTSHIP_TYPE_CODE (
419 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
420 P_Validation_mode IN VARCHAR2,
421 P_RELATIONSHIP_TYPE_CODE IN VARCHAR2,
422 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
423 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
424 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
425 );
426
427 -- Start of Comments
428 --
429 -- Item level validation procedures
430 --
431 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
432 -- For create: G_CREATE, for update: G_UPDATE
433 -- Note: 1. This is automated generated item level validation procedure.
434 -- The actual validation detail is needed to be added.
435 --
436 -- End of Comments
437
438 PROCEDURE Validate_RECIPROCAL_FLAG (
439 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
440 P_Validation_mode IN VARCHAR2,
441 P_RECIPROCAL_FLAG IN VARCHAR2,
442 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
443 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
444 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
445 );
446
447 -- Start of Comments
448 --
449 -- Item level validation procedures
450 --
451 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
452 -- For create: G_CREATE, for update: G_UPDATE
453 -- Note: 1. This is automated generated item level validation procedure.
454 -- The actual validation detail is needed to be added.
455 --
456 -- End of Comments
457
458 PROCEDURE Validate_QUOTE_OBJECT_CODE (
459 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
460 P_Validation_mode IN VARCHAR2,
461 P_QUOTE_OBJECT_CODE IN NUMBER,
462 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
463 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
464 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
465 );
466
467 -- Start of Comments
468 --
469 -- Record level validation procedures
470 --
471 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
472 -- For create: G_CREATE, for update: G_UPDATE
473 -- Note: 1. This is automated generated item level validation procedure.
474 -- The actual validation detail is needed to be added.
475 -- 2. Developer can manually added inter-field level validation.
476 -- End of Comments
477
478 PROCEDURE Validate_RELATED_OBJ_rec(
479 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
480 P_Validation_mode IN VARCHAR2,
481 P_RELATED_OBJ_Rec IN ASO_QUOTE_PUB.RELATED_OBJ_Rec_Type,
482 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
483 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
484 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
485 );
486
487 -- Start of Comments
488 --
489 -- validation procedures
490 --
491 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
492 -- For create: G_CREATE, for update: G_UPDATE
493 -- Note: 1. This is automated generated item level validation procedure.
494 -- The actual validation detail is needed to be added.
495 -- 2. We can also validate table instead of record. There will be an option for user to choose.
496 -- End of Comments
497
498 PROCEDURE Validate_related_obj(
499 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
500 P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
501 P_Validation_mode IN VARCHAR2,
502 P_RELATED_OBJ_Rec IN ASO_QUOTE_PUB.RELATED_OBJ_Rec_Type,
503 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
504 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
505 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
506 );
507 End aso_RELATED_OBJ_PVT;