1 PACKAGE AS_OPP_LINE_PVT AUTHID CURRENT_USER as
2 /* $Header: asxvldls.pls 115.13 2003/11/13 10:11:15 gbatra ship $ */
3 -- Start of Comments
4 -- Package name : AS_OPP_LINE_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 -- *******************************************************
14 -- Start of Comments
15 -- *******************************************************
16 -- API Name: Create_opp_lines
17 -- Type : Private
18 -- Pre-Req :
19 -- Parameters:
20 -- IN
21 -- p_api_version_number IN NUMBER Required
22 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
23 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
24 -- p_validation_level IN NUMBER Optional Default =
25 -- FND_API.G_VALID_LEVEL_FULL
26 -- P_Line_Tbl IN AS_OPPORTUNITY_PUB.Line_Tbl_Type Required
27 --
28 -- OUT:
29 -- X_LINE_OUT_TBL OUT AS_OPPORTUNITY_PUB.Line_out_Tbl_type,
30 -- x_return_status OUT VARCHAR2
31 -- x_msg_count OUT NUMBER
32 -- x_msg_data OUT VARCHAR2
33 -- Version : Current version 2.0
34 --
35 -- End of Comments
36 --
37 PROCEDURE Create_opp_lines(
38 P_Api_Version_Number IN NUMBER,
39 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
40 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
41 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
42 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
43 P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
44 P_Admin_Group_Id IN NUMBER,
45 P_Identity_Salesforce_Id IN NUMBER := NULL,
46 p_salesgroup_id IN NUMBER := NULL,
47 P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
48 P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
49 P_Line_Tbl IN AS_OPPORTUNITY_PUB.Line_Tbl_Type :=
50 AS_OPPORTUNITY_PUB.G_MISS_Line_Tbl,
51 p_Header_Rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,
52 X_LINE_OUT_TBL OUT NOCOPY AS_OPPORTUNITY_PUB.Line_out_Tbl_type,
53 X_Return_Status OUT NOCOPY VARCHAR2,
54 X_Msg_Count OUT NOCOPY NUMBER,
55 X_Msg_Data OUT NOCOPY VARCHAR2
56 );
57
58 -- *******************************************************
59 -- Start of Comments
60 -- *******************************************************
61 -- API Name: Update_opp_lines
62 -- Type : Private
63 -- Pre-Req :
64 -- Parameters:
65 -- IN
66 -- p_api_version_number IN NUMBER Required
67 -- p_init_msg_list IN VARCHAR2 Optional Default =
68 -- FND_API_G_FALSE
69 -- p_commit IN VARCHAR2 Optional Default =
70 -- FND_API.G_FALSE
71 -- p_validation_level IN NUMBER Optional Default =
72 -- FND_API.G_VALID_LEVEL_FULL
73 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
74 -- P_Line_Tbl IN AS_OPPORTUNITY_PUB.Line_Tbl_Type
75 -- Required
76 --
77 -- OUT:
78 -- X_LINE_OUT_TBL OUT AS_OPPORTUNITY_PUB.Line_out_Tbl_type,
79 -- x_return_status OUT VARCHAR2
80 -- x_msg_count OUT NUMBER
81 -- x_msg_data OUT VARCHAR2
82 -- Version : Current version 2.0
83 --
84 -- End of Comments
85 --
86 PROCEDURE Update_opp_lines(
87 P_Api_Version_Number IN NUMBER,
88 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
89 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
90 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
91 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
92 P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
93 P_Admin_Group_Id IN NUMBER,
94 P_identity_salesforce_id IN NUMBER := NULL,
95 P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
96 P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
97 P_Line_Tbl IN AS_OPPORTUNITY_PUB.Line_Tbl_Type,
98 p_Header_Rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,
99 X_LINE_OUT_TBL OUT NOCOPY AS_OPPORTUNITY_PUB.Line_out_Tbl_type,
100 X_Return_Status OUT NOCOPY VARCHAR2,
101 X_Msg_Count OUT NOCOPY NUMBER,
102 X_Msg_Data OUT NOCOPY VARCHAR2
103 );
104
105 -- *******************************************************
106 -- Start of Comments
107 -- *******************************************************
108 -- API Name: Delete_opp_lines
109 -- Type : Private
110 -- Pre-Req :
111 -- Parameters:
112 -- IN
113 -- p_api_version_number IN NUMBER Required
114 -- p_init_msg_list IN VARCHAR2 Optional Default =
115 -- FND_API_G_FALSE
116 -- p_commit IN VARCHAR2 Optional Default =
117 -- FND_API.G_FALSE
118 -- p_validation_level IN NUMBER Optional Default =
119 -- FND_API.G_VALID_LEVEL_FULL
120 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
121 -- P_Line_Tbl IN AS_OPPORTUNITY_PUB.Line_Tbl_Type
122 -- Required
123 --
124 -- OUT:
125 -- X_LINE_OUT_TBL OUT AS_OPPORTUNITY_PUB.Line_out_Tbl_type,
126 -- x_return_status OUT VARCHAR2
127 -- x_msg_count OUT NUMBER
128 -- x_msg_data OUT VARCHAR2
129 -- Version : Current version 2.0
130 --
131 -- End of Comments
132 --
133 PROCEDURE Delete_opp_lines(
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_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
139 P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
140 P_Admin_Group_Id IN NUMBER,
141 P_identity_salesforce_id IN NUMBER := NULL,
142 P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
143 P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
144 P_Line_Tbl IN AS_OPPORTUNITY_PUB.Line_Tbl_Type,
145 p_Header_Rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,
146 X_LINE_OUT_TBL OUT NOCOPY AS_OPPORTUNITY_PUB.Line_out_Tbl_type,
147 X_Return_Status OUT NOCOPY VARCHAR2,
148 X_Msg_Count OUT NOCOPY NUMBER,
149 X_Msg_Data OUT NOCOPY VARCHAR2
150 );
151
152
153 -- Start of Comments
154 --
155 -- Item level validation procedures
156 --
157 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
158 -- For create: G_CREATE, for update: G_UPDATE
159 -- Note: 1. This is automated generated item level validation procedure.
160 -- The actual validation detail is needed to be added.
161 --
162 -- End of Comments
163
164 PROCEDURE Validate_LEAD_LINE_ID (
165 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
166 P_Validation_mode IN VARCHAR2,
167 P_LEAD_LINE_ID IN NUMBER,
168 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
169 X_Return_Status OUT NOCOPY VARCHAR2,
170 X_Msg_Count OUT NOCOPY NUMBER,
171 X_Msg_Data OUT NOCOPY VARCHAR2
172 );
173
174 -- Start of Comments
175 --
176 -- Item level validation procedures
177 --
178 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
179 -- For create: G_CREATE, for update: G_UPDATE
180 -- Note: 1. This is automated generated item level validation procedure.
181 -- The actual validation detail is needed to be added.
182 --
183 -- End of Comments
184
185 PROCEDURE Validate_REQUEST_ID (
186 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
187 P_Validation_mode IN VARCHAR2,
188 P_REQUEST_ID IN NUMBER,
189 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
190 X_Return_Status OUT NOCOPY VARCHAR2,
191 X_Msg_Count OUT NOCOPY NUMBER,
192 X_Msg_Data OUT NOCOPY VARCHAR2
193 );
194
195 -- Start of Comments
196 --
197 -- Item level validation procedures
198 --
199 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
200 -- For create: G_CREATE, for update: G_UPDATE
201 -- Note: 1. This is automated generated item level validation procedure.
202 -- The actual validation detail is needed to be added.
203 --
204 -- End of Comments
205
206 PROCEDURE Validate_LEAD_ID (
207 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
208 P_Validation_mode IN VARCHAR2,
209 P_LEAD_ID IN NUMBER,
210 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
211 X_Return_Status OUT NOCOPY VARCHAR2,
212 X_Msg_Count OUT NOCOPY NUMBER,
213 X_Msg_Data OUT NOCOPY VARCHAR2
214 );
215
216 -- Start of Comments
217 --
218 -- Item level validation procedures
219 --
220 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
221 -- For create: G_CREATE, for update: G_UPDATE
222 -- Note: 1. This is automated generated item level validation procedure.
223 -- The actual validation detail is needed to be added.
224 --
225 -- End of Comments
226 /*
227 PROCEDURE Validate_INTEREST_TYPE_ID (
228 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
229 P_Validation_mode IN VARCHAR2,
230 P_INTEREST_TYPE_ID IN NUMBER,
231 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
232 X_Return_Status OUT NOCOPY VARCHAR2,
233 X_Msg_Count OUT NOCOPY NUMBER,
234 X_Msg_Data OUT NOCOPY VARCHAR2
235 );
236 */
237 -- Start of Comments
238 --
239 -- Item level validation procedures
240 --
241 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
242 -- For create: G_CREATE, for update: G_UPDATE
243 -- Note: 1. This is automated generated item level validation procedure.
244 -- The actual validation detail is needed to be added.
245 --
246 -- End of Comments
247 /*
248 PROCEDURE Validate_P_INTEREST_CODE_ID (
249 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
250 P_Validation_mode IN VARCHAR2,
251 P_PRIMARY_INTEREST_CODE_ID IN NUMBER,
252 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
253 X_Return_Status OUT NOCOPY VARCHAR2,
254 X_Msg_Count OUT NOCOPY NUMBER,
255 X_Msg_Data OUT NOCOPY VARCHAR2
256 );
257 */
258 -- Start of Comments
259 --
260 -- Item level validation procedures
261 --
262 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
263 -- For create: G_CREATE, for update: G_UPDATE
264 -- Note: 1. This is automated generated item level validation procedure.
265 -- The actual validation detail is needed to be added.
266 --
267 -- End of Comments
268 /*
269 PROCEDURE Validate_S_INTEREST_CODE_ID (
270 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
271 P_Validation_mode IN VARCHAR2,
272 P_SECONDARY_INTEREST_CODE_ID IN NUMBER,
273 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
274 X_Return_Status OUT NOCOPY VARCHAR2,
275 X_Msg_Count OUT NOCOPY NUMBER,
276 X_Msg_Data OUT NOCOPY VARCHAR2
277 );
278
279 */
280
281
282 -- Start of Comments
283 --
284 -- Item level validation procedures
285 --
286 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
287 -- For create: G_CREATE, for update: G_UPDATE
288 -- Note: 1. This is automated generated item level validation procedure.
289 -- The actual validation detail is needed to be added.
290 --
291 -- End of Comments
292
293 PROCEDURE Validate_INVENTORY_ITEM_ID (
294 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
295 P_Validation_mode IN VARCHAR2,
296 P_INVENTORY_ITEM_ID IN NUMBER,
297 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
298 X_Return_Status OUT NOCOPY VARCHAR2,
299 X_Msg_Count OUT NOCOPY NUMBER,
300 X_Msg_Data OUT NOCOPY VARCHAR2
301 );
302
303 -- Start of Comments
304 --
305 -- Item level validation procedures
306 --
307 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
308 -- For create: G_CREATE, for update: G_UPDATE
309 -- Note: 1. This is automated generated item level validation procedure.
310 -- The actual validation detail is needed to be added.
311 --
312 -- End of Comments
313
314 PROCEDURE Validate_ORGANIZATION_ID (
315 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
316 P_Validation_mode IN VARCHAR2,
317 P_ORGANIZATION_ID IN NUMBER,
318 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
319 X_Return_Status OUT NOCOPY VARCHAR2,
320 X_Msg_Count OUT NOCOPY NUMBER,
321 X_Msg_Data OUT NOCOPY VARCHAR2
322 );
323
324 -- Start of Comments
325 --
326 -- Item level validation procedures
327 --
328 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
329 -- For create: G_CREATE, for update: G_UPDATE
330 -- Note: 1. This is automated generated item level validation procedure.
331 -- The actual validation detail is needed to be added.
332 --
333 -- End of Comments
334
335 PROCEDURE Validate_UOM_CODE (
336 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
337 P_Validation_mode IN VARCHAR2,
338 P_UOM_CODE IN VARCHAR2,
339 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
340 X_Return_Status OUT NOCOPY VARCHAR2,
341 X_Msg_Count OUT NOCOPY NUMBER,
342 X_Msg_Data OUT NOCOPY VARCHAR2
343 );
344
345 -- Start of Comments
346 --
347 -- Item level validation procedures
348 --
349 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
350 -- For create: G_CREATE, for update: G_UPDATE
351 -- Note: 1. This is automated generated item level validation procedure.
352 -- The actual validation detail is needed to be added.
353 --
354 -- End of Comments
355
356 PROCEDURE Validate_QUANTITY (
357 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
358 P_Validation_mode IN VARCHAR2,
362 X_Msg_Count OUT NOCOPY NUMBER,
359 P_QUANTITY IN NUMBER,
360 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
361 X_Return_Status OUT NOCOPY VARCHAR2,
363 X_Msg_Data OUT NOCOPY VARCHAR2
364 );
365
366 -- Start of Comments
367 --
368 -- Item level validation procedures
369 --
370 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
371 -- For create: G_CREATE, for update: G_UPDATE
372 -- Note: 1. This is automated generated item level validation procedure.
373 -- The actual validation detail is needed to be added.
374 --
375 -- End of Comments
376
377 PROCEDURE Validate_TOTAL_AMOUNT (
378 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
379 P_Validation_mode IN VARCHAR2,
380 P_TOTAL_AMOUNT IN NUMBER,
381 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
382 X_Return_Status OUT NOCOPY VARCHAR2,
383 X_Msg_Count OUT NOCOPY NUMBER,
384 X_Msg_Data OUT NOCOPY VARCHAR2
385 );
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_QUOTED_LINE_FLAG (
400 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
401 P_Validation_mode IN VARCHAR2,
402 P_QUOTED_LINE_FLAG IN VARCHAR2,
403 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
404 X_Return_Status OUT NOCOPY VARCHAR2,
405 X_Msg_Count OUT NOCOPY NUMBER,
406 X_Msg_Data OUT NOCOPY 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_PRICE (
421 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
422 P_Validation_mode IN VARCHAR2,
423 P_PRICE IN NUMBER,
424 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
425 X_Return_Status OUT NOCOPY VARCHAR2,
426 X_Msg_Count OUT NOCOPY NUMBER,
427 X_Msg_Data OUT NOCOPY VARCHAR2
428 );
429
430 -- Start of Comments
431 --
432 -- Item level validation procedures
433 --
434 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
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.
438 --
439 -- End of Comments
440
441 PROCEDURE Validate_PRICE_VOLUME_MARGIN (
442 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
443 P_Validation_mode IN VARCHAR2,
444 P_PRICE_VOLUME_MARGIN IN NUMBER,
445 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
446 X_Return_Status OUT NOCOPY VARCHAR2,
447 X_Msg_Count OUT NOCOPY NUMBER,
448 X_Msg_Data OUT NOCOPY VARCHAR2
449 );
450
451 -- Start of Comments
452 --
453 -- Item level validation procedures
454 --
455 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
456 -- For create: G_CREATE, for update: G_UPDATE
457 -- Note: 1. This is automated generated item level validation procedure.
458 -- The actual validation detail is needed to be added.
459 --
460 -- End of Comments
461
462 PROCEDURE Validate_SHIP_DATE (
463 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
464 P_Validation_mode IN VARCHAR2,
465 P_SHIP_DATE IN DATE,
466 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
467 X_Return_Status OUT NOCOPY VARCHAR2,
468 X_Msg_Count OUT NOCOPY NUMBER,
469 X_Msg_Data OUT NOCOPY VARCHAR2
470 );
471
472 -- Start of Comments
473 --
474 -- Item level validation procedures
475 --
476 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
477 -- For create: G_CREATE, for update: G_UPDATE
478 -- Note: 1. This is automated generated item level validation procedure.
479 -- The actual validation detail is needed to be added.
480 --
481 -- End of Comments
482
483 PROCEDURE Validate_O_OPPORTUNITY_LINE_ID (
484 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
485 P_Validation_mode IN VARCHAR2,
486 P_O_OPPORTUNITY_LINE_ID IN NUMBER,
490 X_Msg_Data OUT NOCOPY VARCHAR2
487 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
488 X_Return_Status OUT NOCOPY VARCHAR2,
489 X_Msg_Count OUT NOCOPY NUMBER,
491 );
492
493 -- Start of Comments
494 --
495 -- Item level validation procedures
496 --
497 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
498 -- For create: G_CREATE, for update: G_UPDATE
499 -- Note: 1. This is automated generated item level validation procedure.
500 -- The actual validation detail is needed to be added.
501 --
502 -- End of Comments
503
504 PROCEDURE Validate_SOURCE_PROMOTION_ID (
505 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
506 P_Validation_mode IN VARCHAR2,
507 P_SOURCE_PROMOTION_ID IN NUMBER,
508 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
509 X_Return_Status OUT NOCOPY VARCHAR2,
510 X_Msg_Count OUT NOCOPY NUMBER,
511 X_Msg_Data OUT NOCOPY VARCHAR2
512 );
513
514
515 -- Start of Comments
516 --
517 -- Item level validation procedures
518 --
519 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
520 -- For create: G_CREATE, for update: G_UPDATE
521 -- Note: 1. This is automated generated item level validation procedure.
522 -- The actual validation detail is needed to be added.
523 --
524 -- End of Comments
525
526 PROCEDURE Validate_OFFER_ID (
527 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
528 P_Validation_mode IN VARCHAR2,
529 P_OFFER_ID IN NUMBER,
530 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
531 X_Return_Status OUT NOCOPY VARCHAR2,
532 X_Msg_Count OUT NOCOPY NUMBER,
533 X_Msg_Data OUT NOCOPY VARCHAR2
534 );
535
536 -- Start of Comments
537 --
538 -- Record level validation procedures
539 --
540 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
541 -- For create: G_CREATE, for update: G_UPDATE
542 -- Note: 1. This is automated generated item level validation procedure.
543 -- The actual validation detail is needed to be added.
544 -- 2. Developer can manually added inter-field level validation.
545 -- End of Comments
546
547 PROCEDURE Validate_Line_rec(
548 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
549 P_Validation_mode IN VARCHAR2,
550 P_Line_Rec IN AS_OPPORTUNITY_PUB.Line_Rec_Type,
551 X_Return_Status OUT NOCOPY VARCHAR2,
552 X_Msg_Count OUT NOCOPY NUMBER,
553 X_Msg_Data OUT NOCOPY VARCHAR2
554 );
555
556 -- Start of Comments
557 --
558 -- validation procedures
559 --
560 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
561 -- For create: G_CREATE, for update: G_UPDATE
562 -- Note: 1. This is automated generated item level validation procedure.
563 -- The actual validation detail is needed to be added.
564 -- 2. We can also validate table instead of record. There will be an option for user to choose.
565 -- End of Comments
566
567 PROCEDURE Validate_opp_line(
568 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
569 P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
570 P_Validation_mode IN VARCHAR2,
571 P_Line_Rec IN AS_OPPORTUNITY_PUB.Line_Rec_Type,
572 X_Return_Status OUT NOCOPY VARCHAR2,
573 X_Msg_Count OUT NOCOPY NUMBER,
574 X_Msg_Data OUT NOCOPY VARCHAR2
575 );
576
577 -- Start of Comments
578 --
579 -- Product Category validation procedures
580 --
581 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
582 -- For create: G_CREATE, for update: G_UPDATE
583 -- Note: 1. This is automated generated item level validation procedure.
584 -- The actual validation detail is needed to be added.
585 --
586 -- End of Comments
587
588 PROCEDURE Validate_PRODUCT_CATEGORY (
589 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
590 P_Validation_mode IN VARCHAR2,
591 P_CATEGORY_SET_ID IN NUMBER,
592 P_CATEGORY_ID IN NUMBER,
593 P_LEAD_LINE_ID IN NUMBER,
594 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
595 X_Return_Status OUT NOCOPY VARCHAR2,
596 X_Msg_Count OUT NOCOPY NUMBER,
597 X_Msg_Data OUT NOCOPY VARCHAR2
598 );
599
600 -- Procedure validates product category ids and returns SUCCESS if all ids are
601 -- valid, ERROR otherwise
602 -- Procedure assumes that at least the product category exists
603 -- The validation level can have one of two values 'L' or 'H'
604 -- The validation level determines whether the validation will be low or high
605 -- If the validation level is High, the procedure determines that the product
606 -- category exists and is valid
607 -- If the validation level is Low, the procedure only determines that the product
608 -- category exists
609 --
610 PROCEDURE Validate_Prod_Cat_Fields ( p_product_category_id IN NUMBER,
611 p_product_cat_set_id IN NUMBER,
612 p_validation_level IN VARCHAR2 := 'L',
613 x_return_status OUT NOCOPY VARCHAR2
614 );
615
616 End AS_OPP_LINE_PVT;