eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE BODY: APPS.QP_BUILD_SOURCING_PVT_TMP

Source


1 PACKAGE BODY QP_BUILD_SOURCING_PVT_TMP AS
2 /* $Header: QPXVBSTB.pls 115.0 30-MAR-09 23:23:31 appldev ship $ */
3  
4 --  
5 --  Copyright (c) 1996 Oracle Corporation, Redwood Shores, CA, USA
6 --  All rights reserved.
7 --  
8 --  FILENAME
9 --  
10 --      QP_BUILD_SOURCING_PVT_TMP
11 --  
12 --  DESCRIPTION
13 --  
14 --      Body of package QP_BUILD_SOURCING_PVT_TMP
15 --  
16 --  NOTES
17 --  
18 --  HISTORY
19 --  
20 --  30-MAR-09 Created
21 --  
22  
23 --  Global constant holding the package name
24  
25  
26 PROCEDURE Get_Attribute_Values
27 (    p_req_type_code                IN VARCHAR2
28 ,    p_pricing_type_code            IN VARCHAR2
29 ,    x_qual_ctxts_result_tbl        OUT NOCOPY QP_Attr_Mapping_PUB.CONTEXTS_RESULT_TBL_TYPE
30 ,    x_price_ctxts_result_tbl       OUT NOCOPY QP_Attr_Mapping_PUB.CONTEXTS_RESULT_TBL_TYPE
31 )
32 IS
33  
34 v_attr_value         VARCHAR2(240);
35 v_attr_mvalue        QP_Attr_Mapping_PUB.t_MultiRecord;
36 q_count              NUMBER := 1;
37 p_count              NUMBER := 1;
38 v_index              NUMBER := 1;
39 prev_header_id 	   NUMBER := FND_API.G_MISS_NUM;
40  
41 l_debug              VARCHAR2(3);
42 BEGIN
43 qp_debug_util.tstart('FETCH_ATTRIBUTES','Fetching the Attribute Values');
44  
45   l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
46 if p_pricing_type_code = 'H' and qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_no then
47   qp_preq_grp.g_new_pricing_call := qp_preq_grp.g_yes;
48   IF l_debug = FND_API.G_TRUE THEN
49     oe_debug_pub.add('hw/src/H: change to g_yes');
50   END IF;
51 end if;
52  
53   If QP_Util_PUB.HVOP_Pricing_On= 'N' Then --Follow Non-HVOP Path
54   QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;
55 IF p_req_type_code = 'MSD' THEN
56  
57   IF p_pricing_type_code = 'L' THEN
58  
59     NULL;
60  
61   END IF;
62  
63 END IF;
64  
65   QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;
66 IF p_req_type_code = 'MSD' THEN
67  
68   IF p_pricing_type_code = 'H' THEN
69  
70     NULL;
71  
72   END IF;
73  
74 END IF;
75  
76   QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;
77 --  Attribute not used
78 --  Attribute not used
79 --  Attribute not used
80 --  Attribute not used
81 --  Attribute not used
82 --  Attribute not used
83 --  Attribute not used
84 --  Attribute not used
85 --  Attribute not used
86 --  Attribute not used
87 --  Attribute not used
88 --  Attribute not used
89 --  Attribute not used
90 IF p_req_type_code = 'IC' THEN
91  
92   IF p_pricing_type_code = 'L' THEN
93  
94     NULL;
95  
96   END IF;
97  
98 END IF;
99  
100   QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;
101 IF p_req_type_code = 'IC' THEN
102  
103   IF p_pricing_type_code = 'H' THEN
104  
105     NULL;
106  
107   END IF;
108  
109 END IF;
110  
111   QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;
112 IF p_req_type_code = 'FTE' THEN
113  
114   IF p_pricing_type_code = 'L' THEN
115  
116     NULL;
117  
118   END IF;
119  
120 END IF;
121  
122   QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;
123 IF p_req_type_code = 'FTE' THEN
124  
125   IF p_pricing_type_code = 'H' THEN
126  
127     NULL;
128  
129   END IF;
130  
131 END IF;
132  
133   QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;
134 --  Attribute not used
135 --  Attribute not used
136 --  Attribute not used
137 --  Attribute not used
138 --  Attribute not used
139 --  Attribute not used
140 --  Attribute not used
141 --  Attribute not used
142 --  Attribute not used
143 --  Attribute not used
144 --  Attribute not used
145 --  Attribute not used
146 --  Attribute not used
147 --  Attribute not used
148 --  Attribute not used
149 --  Attribute not used
150 --  Attribute not used
151 --  Attribute not used
152 --  Attribute not used
153 --  Attribute not used
154 --  Attribute not used
155 --  Attribute not used
156 --  Attribute not used
157 --  Attribute not used
158 --  Attribute not used
159 --  Attribute not used
160 --  Attribute not used
161 --  Attribute not used
162 --  Attribute not used
163 --  Attribute not used
164 --  Attribute not used
165 --  Attribute not used
166 --  Attribute not used
167 --  Attribute not used
168 --  Attribute not used
169 --  Attribute not used
170 --  Attribute not used
171 --  Attribute not used
172 --  Attribute not used
173 --  Attribute not used
174 --  Attribute not used
175 --  Attribute not used
176 --  Attribute not used
177 --  Attribute not used
178 --  Attribute not used
179 --  Attribute not used
180 --  Attribute not used
181 --  Attribute not used
182 --  Attribute not used
183 --  Attribute not used
184 --  Attribute not used
185 --  Attribute not used
186 --  Attribute not used
187 --  Attribute not used
188 --  Attribute not used
189 --  Attribute not used
190 --  Attribute not used
191 --  Attribute not used
192 --  Attribute not used
193 --  Attribute not used
194 --  Attribute not used
195 --  Attribute not used
196 --  Attribute not used
197 --  Attribute not used
198 --  Attribute not used
199 --  Attribute not used
200 --  Attribute not used
201 --  Attribute not used
202 --  Attribute not used
203 --  Attribute not used
204 --  Attribute not used
205 --  Attribute not used
206 --  Attribute not used
207 --  Attribute not used
208 --  Attribute not used
209 IF p_req_type_code = 'ASO' THEN
210  
211   IF p_pricing_type_code = 'L' THEN
212  
213     NULL;
214  
215 --  Src_Type: API
216     BEGIN
217       v_attr_value := 
218                       ASO_PRICING_INT.G_LINE_REC.price_list_id;
219     EXCEPTION
220       WHEN OTHERS THEN
221         v_attr_value := NULL;
222     END;
223  
224     BEGIN
225     IF v_attr_value = FND_API.G_MISS_NUM THEN
226       v_attr_value := NULL;
227     END IF;
228     EXCEPTION
229       WHEN VALUE_ERROR THEN
230         IF v_attr_value = FND_API.G_MISS_CHAR THEN
231           v_attr_value := NULL;
232         END IF;
233       WHEN OTHERS THEN
234         v_attr_value := NULL;
235     END;
236  
237     IF (v_attr_value IS NOT NULL) THEN
238  
239       x_qual_ctxts_result_tbl(q_count).context_name := 'MODLIST';
240       x_qual_ctxts_result_tbl(q_count).attribute_name := 'QUALIFIER_ATTRIBUTE4';
241       x_qual_ctxts_result_tbl(q_count).attribute_value := v_attr_value;
242       q_count := q_count + 1;
243         IF l_debug = FND_API.G_TRUE THEN
244           oe_debug_pub.add('After product assigned');
245         END IF;
246     END IF;--v_attr_(m)value
247   END IF;
248  
249 END IF;
250  
251   QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;
252 --  Attribute not used
253 --  Attribute not used
254 --  Attribute not used
255 --  Attribute not used
256 --  Attribute not used
257 --  Attribute not used
258 --  Attribute not used
259 --  Attribute not used
260 --  Attribute not used
261 --  Attribute not used
262 --  Attribute not used
263 --  Attribute not used
264 --  Attribute not used
265 --  Attribute not used
266 --  Attribute not used
267 --  Attribute not used
268 --  Attribute not used
269 --  Attribute not used
270 --  Attribute not used
271 --  Attribute not used
272 --  Attribute not used
273 --  Attribute not used
274 --  Attribute not used
275 --  Attribute not used
276 --  Attribute not used
277 --  Attribute not used
278 --  Attribute not used
279 --  Attribute not used
280 --  Attribute not used
281 --  Attribute not used
282 --  Attribute not used
283 --  Attribute not used
284 --  Attribute not used
285 --  Attribute not used
286 --  Attribute not used
287 --  Attribute not used
288 --  Attribute not used
289 --  Attribute not used
290 --  Attribute not used
291 --  Attribute not used
292 --  Attribute not used
293 --  Attribute not used
294 IF p_req_type_code = 'ASO' THEN
295  
296   IF p_pricing_type_code = 'H' THEN
297  
298     NULL;
299  
300 --  Src_Type: API
301     BEGIN
302       v_attr_value := 
303                       ASO_PRICING_INT.G_HEADER_REC.price_list_id;
304     EXCEPTION
305       WHEN OTHERS THEN
306         v_attr_value := NULL;
307     END;
308  
309     BEGIN
310     IF v_attr_value = FND_API.G_MISS_NUM THEN
311       v_attr_value := NULL;
312     END IF;
313     EXCEPTION
314       WHEN VALUE_ERROR THEN
315         IF v_attr_value = FND_API.G_MISS_CHAR THEN
316           v_attr_value := NULL;
317         END IF;
318       WHEN OTHERS THEN
319         v_attr_value := NULL;
320     END;
321  
322     IF (v_attr_value IS NOT NULL) THEN
323  
324       x_qual_ctxts_result_tbl(q_count).context_name := 'MODLIST';
325       x_qual_ctxts_result_tbl(q_count).attribute_name := 'QUALIFIER_ATTRIBUTE4';
326       x_qual_ctxts_result_tbl(q_count).attribute_value := v_attr_value;
327       q_count := q_count + 1;
328         IF l_debug = FND_API.G_TRUE THEN
329           oe_debug_pub.add('After product assigned');
330         END IF;
331     END IF;--v_attr_(m)value
332   END IF;
333  
334 END IF;
335  
336   QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;
337 --  Attribute not used
338 --  Attribute not used
339 --  Attribute not used
340 --  Attribute not used
341 --  Attribute not used
342 --  Attribute not used
343 --  Attribute not used
344 --  Attribute not used
345 --  Attribute not used
346 --  Attribute not used
347 --  Attribute not used
348 --  Attribute not used
349 --  Attribute not used
350 --  Attribute not used
351 --  Attribute not used
352 --  Attribute not used
353 --  Attribute not used
354 --  Attribute not used
355 --  Attribute not used
356 --  Attribute not used
357 --  Attribute not used
358 --  Attribute not used
359 --  Attribute not used
360 --  Attribute not used
361 --  Attribute not used
362 --  Attribute not used
363 --  Attribute not used
364 --  Attribute not used
365 --  Attribute not used
366 --  Attribute not used
367 --  Attribute not used
368 --  Attribute not used
369 --  Attribute not used
370 --  Attribute not used
371 --  Attribute not used
372 --  Attribute not used
373 --  Attribute not used
374 --  Attribute not used
375 IF p_req_type_code = 'OKC' THEN
376  
377   IF p_pricing_type_code = 'L' THEN
378  
379     NULL;
380  
381   END IF;
382  
383 END IF;
384  
385   QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;
386 --  Attribute not used
387 --  Attribute not used
388 --  Attribute not used
389 --  Attribute not used
390 --  Attribute not used
391 --  Attribute not used
392 --  Attribute not used
393 --  Attribute not used
394 --  Attribute not used
395 --  Attribute not used
396 --  Attribute not used
397 --  Attribute not used
398 --  Attribute not used
399 IF p_req_type_code = 'OKC' THEN
400  
401   IF p_pricing_type_code = 'H' THEN
402  
403     NULL;
404  
405   END IF;
406  
407 END IF;
408  
409   QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;
410 --  Attribute not used
411 --  Attribute not used
412 --  Attribute not used
413 --  Attribute not used
414 --  Attribute not used
415 --  Attribute not used
416 --  Attribute not used
417 --  Attribute not used
418 --  Attribute not used
419 --  Attribute not used
420 --  Attribute not used
421 --  Attribute not used
422 --  Attribute not used
423 --  Attribute not used
424 --  Attribute not used
425 --  Attribute not used
426 --  Attribute not used
427 --  Attribute not used
428 --  Attribute not used
429 --  Attribute not used
430 --  Attribute not used
431 --  Attribute not used
432 --  Attribute not used
433 --  Attribute not used
434 --  Attribute not used
435 --  Attribute not used
436 --  Attribute not used
437 --  Attribute not used
438 --  Attribute not used
439 --  Attribute not used
440 --  Attribute not used
441 --  Attribute not used
442 --  Attribute not used
443 --  Attribute not used
444 --  Attribute not used
445 --  Attribute not used
446 --  Attribute not used
447 --  Attribute not used
448 --  Attribute not used
449 --  Attribute not used
450 --  Attribute not used
451 --  Attribute not used
452 --  Attribute not used
453 --  Attribute not used
454 --  Attribute not used
455 --  Attribute not used
456 --  Attribute not used
457 --  Attribute not used
458 --  Attribute not used
459 --  Attribute not used
460 --  Attribute not used
461 --  Attribute not used
462 --  Attribute not used
463 --  Attribute not used
464 --  Attribute not used
465 --  Attribute not used
466 --  Attribute not used
467 --  Attribute not used
468 --  Attribute not used
469 --  Attribute not used
470 --  Attribute not used
471 --  Attribute not used
472 --  Attribute not used
473 --  Attribute not used
474 --  Attribute not used
475 --  Attribute not used
476 --  Attribute not used
477 --  Attribute not used
478 --  Attribute not used
479 --  Attribute not used
480 --  Attribute not used
481 --  Attribute not used
482 --  Attribute not used
483 --  Attribute not used
484 --  Attribute not used
485 --  Attribute not used
486 --  Attribute not used
487 --  Attribute not used
488 --  Attribute not used
489 --  Attribute not used
490 --  Attribute not used
491 --  Attribute not used
492 --  Attribute not used
493 --  Attribute not used
494 --  Attribute not used
495 --  Attribute not used
496 --  Attribute not used
497 --  Attribute not used
498 --  Attribute not used
499 --  Attribute not used
500 --  Attribute not used
501 --  Attribute not used
502 --  Attribute not used
503 --  Attribute not used
504 --  Attribute not used
505 --  Attribute not used
506 --  Attribute not used
507 --  Attribute not used
508 --  Attribute not used
509 --  Attribute not used
510 --  Attribute not used
511 --  Attribute not used
512 --  Attribute not used
513 IF p_req_type_code = 'ONT' THEN
514  
515   IF p_pricing_type_code = 'L' THEN
516  
517     NULL;
518  
519 --  Src_Type: API
520     BEGIN
521       v_attr_value := 
522                       OE_ORDER_PUB.G_LINE.price_list_id;
523     EXCEPTION
524       WHEN OTHERS THEN
525         v_attr_value := NULL;
526     END;
527  
528     BEGIN
529     IF v_attr_value = FND_API.G_MISS_NUM THEN
530       v_attr_value := NULL;
531     END IF;
532     EXCEPTION
533       WHEN VALUE_ERROR THEN
534         IF v_attr_value = FND_API.G_MISS_CHAR THEN
535           v_attr_value := NULL;
536         END IF;
537       WHEN OTHERS THEN
538         v_attr_value := NULL;
539     END;
540  
541     IF (v_attr_value IS NOT NULL) THEN
542  
543       x_qual_ctxts_result_tbl(q_count).context_name := 'MODLIST';
544       x_qual_ctxts_result_tbl(q_count).attribute_name := 'QUALIFIER_ATTRIBUTE4';
545       x_qual_ctxts_result_tbl(q_count).attribute_value := v_attr_value;
546       q_count := q_count + 1;
547         IF l_debug = FND_API.G_TRUE THEN
548           oe_debug_pub.add('After product assigned');
549         END IF;
550     END IF;--v_attr_(m)value
551   END IF;
552  
553 END IF;
554  
555   QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;
556 --  Attribute not used
557 --  Attribute not used
558 --  Attribute not used
559 --  Attribute not used
560 --  Attribute not used
561 --  Attribute not used
562 --  Attribute not used
563 --  Attribute not used
564 --  Attribute not used
565 --  Attribute not used
566 --  Attribute not used
567 --  Attribute not used
568 --  Attribute not used
569 --  Attribute not used
570 --  Attribute not used
571 --  Attribute not used
572 --  Attribute not used
573 --  Attribute not used
574 --  Attribute not used
575 --  Attribute not used
576 --  Attribute not used
577 --  Attribute not used
578 --  Attribute not used
579 --  Attribute not used
580 --  Attribute not used
581 --  Attribute not used
582 --  Attribute not used
583 --  Attribute not used
584 --  Attribute not used
585 --  Attribute not used
586 --  Attribute not used
587 --  Attribute not used
588 --  Attribute not used
589 --  Attribute not used
590 --  Attribute not used
591 --  Attribute not used
592 --  Attribute not used
593 --  Attribute not used
594 --  Attribute not used
595 --  Attribute not used
596 --  Attribute not used
597 --  Attribute not used
598 --  Attribute not used
599 --  Attribute not used
600 --  Attribute not used
601 --  Attribute not used
602 --  Attribute not used
603 --  Attribute not used
604 IF p_req_type_code = 'ONT' THEN
605  
606   IF p_pricing_type_code = 'H' THEN
607  
608     NULL;
609  
610 --  Src_Type: API
611     BEGIN
612       v_attr_value := 
613                       OE_ORDER_PUB.G_HDR.price_list_id;
614     EXCEPTION
615       WHEN OTHERS THEN
616         v_attr_value := NULL;
617     END;
618  
619     BEGIN
620     IF v_attr_value = FND_API.G_MISS_NUM THEN
621       v_attr_value := NULL;
622     END IF;
623     EXCEPTION
624       WHEN VALUE_ERROR THEN
625         IF v_attr_value = FND_API.G_MISS_CHAR THEN
626           v_attr_value := NULL;
627         END IF;
628       WHEN OTHERS THEN
629         v_attr_value := NULL;
630     END;
631  
632     IF (v_attr_value IS NOT NULL) THEN
633  
634       x_qual_ctxts_result_tbl(q_count).context_name := 'MODLIST';
635       x_qual_ctxts_result_tbl(q_count).attribute_name := 'QUALIFIER_ATTRIBUTE4';
636       x_qual_ctxts_result_tbl(q_count).attribute_value := v_attr_value;
637       q_count := q_count + 1;
638         IF l_debug = FND_API.G_TRUE THEN
639           oe_debug_pub.add('After product assigned');
640         END IF;
641     END IF;--v_attr_(m)value
642   END IF;
643  
644 END IF;
645  
646   QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;
647 --  Attribute not used
648 --  Attribute not used
649 --  Attribute not used
650 IF p_req_type_code = 'INTORG' THEN
651  
652   IF p_pricing_type_code = 'L' THEN
653  
654     NULL;
655  
656   END IF;
657  
658 END IF;
659  
660   QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;
661 IF p_req_type_code = 'INTORG' THEN
662  
663   IF p_pricing_type_code = 'H' THEN
664  
665     NULL;
666  
667   END IF;
668  
669 END IF;
670  
671   QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;
672 IF p_req_type_code = 'AHL' THEN
673  
674   IF p_pricing_type_code = 'L' THEN
675  
676     NULL;
677  
678   END IF;
679  
680 END IF;
681  
682   QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;
683 IF p_req_type_code = 'AHL' THEN
684  
685   IF p_pricing_type_code = 'H' THEN
686  
687     NULL;
688  
689   END IF;
690  
691 END IF;
692  
693   QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;
694 --  Attribute not used
695 --  Attribute not used
696 --  Attribute not used
697 --  Attribute not used
698 --  Attribute not used
699 --  Attribute not used
700 --  Attribute not used
701 --  Attribute not used
702 --  Attribute not used
703 --  Attribute not used
704 --  Attribute not used
705 --  Attribute not used
706 --  Attribute not used
707 --  Attribute not used
708 --  Attribute not used
709 --  Attribute not used
710 --  Attribute not used
711 --  Attribute not used
712 --  Attribute not used
713 --  Attribute not used
714 --  Attribute not used
715 --  Attribute not used
716 --  Attribute not used
717 --  Attribute not used
718 --  Attribute not used
719 --  Attribute not used
720 --  Attribute not used
721 --  Attribute not used
722 --  Attribute not used
723 --  Attribute not used
724 --  Attribute not used
725 --  Attribute not used
726 --  Attribute not used
727 --  Attribute not used
728 IF p_req_type_code = 'OKS' THEN
729  
730   IF p_pricing_type_code = 'L' THEN
731  
732     NULL;
733  
734   END IF;
735  
736 END IF;
737  
738   QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;
739 --  Attribute not used
740 --  Attribute not used
741 --  Attribute not used
742 --  Attribute not used
743 --  Attribute not used
744 --  Attribute not used
745 --  Attribute not used
746 --  Attribute not used
747 --  Attribute not used
748 --  Attribute not used
749 IF p_req_type_code = 'OKS' THEN
750  
751   IF p_pricing_type_code = 'H' THEN
752  
753     NULL;
754  
755   END IF;
756  
757 END IF;
758  
759   QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;
760 --  Attribute not used
761 --  Attribute not used
762 --  Attribute not used
763 --  Attribute not used
764 --  Attribute not used
765 --  Attribute not used
766 --  Attribute not used
767 --  Attribute not used
768 --  Attribute not used
769 --  Attribute not used
770 --  Attribute not used
771 --  Attribute not used
772 --  Attribute not used
773 --  Attribute not used
774 --  Attribute not used
775 --  Attribute not used
776 --  Attribute not used
777 --  Attribute not used
778 --  Attribute not used
779 --  Attribute not used
780 --  Attribute not used
781 IF p_req_type_code = 'PO' THEN
782  
783   IF p_pricing_type_code = 'L' THEN
784  
785     NULL;
786  
787   END IF;
788  
789 END IF;
790  
791   QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;
792 --  Attribute not used
793 --  Attribute not used
794 --  Attribute not used
795 --  Attribute not used
796 --  Attribute not used
797 --  Attribute not used
798 --  Attribute not used
799 --  Attribute not used
800 --  Attribute not used
801 --  Attribute not used
802 --  Attribute not used
803 --  Attribute not used
804 --  Attribute not used
805 --  Attribute not used
806 --  Attribute not used
807 IF p_req_type_code = 'PO' THEN
808  
809   IF p_pricing_type_code = 'H' THEN
810  
811     NULL;
812  
813   END IF;
814  
815 END IF;
816  
817  
818   Else --Follow HVOP Path
819   NULL;
820  
821   End If; --HVOP Path
822  
823   If QP_Util_PUB.HVOP_Pricing_On = 'N' Then
824     if p_pricing_type_code = 'L' and qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_yes then
825       qp_preq_grp.g_new_pricing_call := qp_preq_grp.g_no;
826       IF l_debug = FND_API.G_TRUE THEN
827         oe_debug_pub.add('hw/src/L: change to g_no');
828       END IF;
829     end if;
830   End If;
831  
832 qp_debug_util.tstop('FETCH_ATTRIBUTES');
833 END Get_Attribute_Values;
834  
835 FUNCTION Is_Attribute_Used (p_attribute_context IN VARCHAR2, p_attribute_code IN VARCHAR2)
836 RETURN VARCHAR2
837  
838 IS
839  
840 x_out	VARCHAR2(1) := 'N';
841 BEGIN
842  
843 IF (p_attribute_context = 'VOLUME') and (p_attribute_code = 'PRICING_ATTRIBUTE10')
844 THEN
845 x_out := 'N';
846 END IF;
847 IF (p_attribute_context = 'VOLUME') and (p_attribute_code = 'PRICING_ATTRIBUTE12')
848 THEN
849 x_out := 'N';
850 END IF;
851  
852 RETURN x_out;
853  
854 END Is_Attribute_Used;
855  
856 END QP_BUILD_SOURCING_PVT_TMP;