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

Source


1 PACKAGE BODY QP_BUILD_SOURCING_PVT AS
2 /* $Header: QPXVBSTB.pls 115.0 27-NOV-12 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 --  27-NOV-12 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 v_tot_time           NUMBER := 0;
40 prev_header_id 	   NUMBER := FND_API.G_MISS_NUM;
41  
42 l_debug              VARCHAR2(3);
43 BEGIN
44 qp_debug_util.tstart('FETCH_ATTRIBUTES','Fetching the Attribute Values');
45  
46   l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
47 if p_pricing_type_code = 'H' and qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_no then
48   qp_preq_grp.g_new_pricing_call := qp_preq_grp.g_yes;
49   IF l_debug = FND_API.G_TRUE THEN
50     oe_debug_pub.add('hw/src/H: change to g_yes');
51   END IF;
52 end if;
53  
54   If QP_Util_PUB.HVOP_Pricing_On= 'N' Then --Follow Non-HVOP Path
55   QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;
56 IF p_req_type_code = 'MSD' THEN
57  
58   IF p_pricing_type_code = 'L' THEN
59  
60     NULL;
61  
62   END IF;
63  
64 END IF;
65  
66   QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;
67 IF p_req_type_code = 'MSD' THEN
68  
69   IF p_pricing_type_code = 'H' THEN
70  
71     NULL;
72  
73   END IF;
74  
75 END IF;
76  
77   QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;
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 --  Attribute not used
91 IF p_req_type_code = 'IC' THEN
92  
93   IF p_pricing_type_code = 'L' THEN
94  
95     NULL;
96  
97   END IF;
98  
99 END IF;
100  
101   QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;
102 IF p_req_type_code = 'IC' THEN
103  
104   IF p_pricing_type_code = 'H' THEN
105  
106     NULL;
107  
108   END IF;
109  
110 END IF;
111  
112   QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;
113 IF p_req_type_code = 'FTE' THEN
114  
115   IF p_pricing_type_code = 'L' THEN
116  
117     NULL;
118  
119   END IF;
120  
121 END IF;
122  
123   QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;
124 IF p_req_type_code = 'FTE' THEN
125  
126   IF p_pricing_type_code = 'H' THEN
127  
128     NULL;
129  
130   END IF;
131  
132 END IF;
133  
134   QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;
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 --  Attribute not used
210 --  Attribute not used
211 IF p_req_type_code = 'ASO' THEN
212  
213   IF p_pricing_type_code = 'L' THEN
214  
215     NULL;
216  
217 --  Src_Type: API
218     BEGIN
219       v_attr_value := 
220                       ASO_PRICING_INT.G_LINE_REC.price_list_id;
221     EXCEPTION
222       WHEN OTHERS THEN
223         v_attr_value := NULL;
224     END;
225  
226     BEGIN
227     IF v_attr_value = FND_API.G_MISS_NUM THEN
228       v_attr_value := NULL;
229     END IF;
230     EXCEPTION
231       WHEN VALUE_ERROR THEN
232         IF v_attr_value = FND_API.G_MISS_CHAR THEN
233           v_attr_value := NULL;
234         END IF;
235       WHEN OTHERS THEN
236         v_attr_value := NULL;
237     END;
238  
239     IF (v_attr_value IS NOT NULL) THEN
240  
241       x_qual_ctxts_result_tbl(q_count).context_name := 'MODLIST';
242       x_qual_ctxts_result_tbl(q_count).attribute_name := 'QUALIFIER_ATTRIBUTE4';
243       x_qual_ctxts_result_tbl(q_count).attribute_value := v_attr_value;
244       q_count := q_count + 1;
245         IF l_debug = FND_API.G_TRUE THEN
246           oe_debug_pub.add('After product assigned');
247         END IF;
248     END IF;--v_attr_(m)value
249   END IF;
250  
251 END IF;
252  
253   QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;
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 --  Attribute not used
295 --  Attribute not used
296 --  Attribute not used
297 IF p_req_type_code = 'ASO' THEN
298  
299   IF p_pricing_type_code = 'H' THEN
300  
301     NULL;
302  
303 --  Src_Type: API
304     BEGIN
305       v_attr_value := 
306                       ASO_PRICING_INT.G_HEADER_REC.price_list_id;
307     EXCEPTION
308       WHEN OTHERS THEN
309         v_attr_value := NULL;
310     END;
311  
312     BEGIN
313     IF v_attr_value = FND_API.G_MISS_NUM THEN
314       v_attr_value := NULL;
315     END IF;
316     EXCEPTION
317       WHEN VALUE_ERROR THEN
318         IF v_attr_value = FND_API.G_MISS_CHAR THEN
319           v_attr_value := NULL;
320         END IF;
321       WHEN OTHERS THEN
322         v_attr_value := NULL;
323     END;
324  
325     IF (v_attr_value IS NOT NULL) THEN
326  
327       x_qual_ctxts_result_tbl(q_count).context_name := 'MODLIST';
328       x_qual_ctxts_result_tbl(q_count).attribute_name := 'QUALIFIER_ATTRIBUTE4';
329       x_qual_ctxts_result_tbl(q_count).attribute_value := v_attr_value;
330       q_count := q_count + 1;
331         IF l_debug = FND_API.G_TRUE THEN
332           oe_debug_pub.add('After product assigned');
333         END IF;
334     END IF;--v_attr_(m)value
335   END IF;
336  
337 END IF;
338  
339   QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;
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 --  Attribute not used
376 --  Attribute not used
377 --  Attribute not used
378 IF p_req_type_code = 'OKC' THEN
379  
380   IF p_pricing_type_code = 'L' THEN
381  
382     NULL;
383  
384   END IF;
385  
386 END IF;
387  
388   QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;
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 --  Attribute not used
400 --  Attribute not used
401 --  Attribute not used
402 IF p_req_type_code = 'OKC' THEN
403  
404   IF p_pricing_type_code = 'H' THEN
405  
406     NULL;
407  
408   END IF;
409  
410 END IF;
411  
412   QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;
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 --  Attribute not used
514 --  Attribute not used
515 --  Attribute not used
516 --  Attribute not used
517 IF p_req_type_code = 'ONT' THEN
518  
519   IF p_pricing_type_code = 'L' THEN
520  
521     NULL;
522  
523 --  Src_Type: API
524     BEGIN
525       v_attr_value := 
526                       OE_ORDER_PUB.G_LINE.price_list_id;
527     EXCEPTION
528       WHEN OTHERS THEN
529         v_attr_value := NULL;
530     END;
531  
532     BEGIN
533     IF v_attr_value = FND_API.G_MISS_NUM THEN
534       v_attr_value := NULL;
535     END IF;
536     EXCEPTION
537       WHEN VALUE_ERROR THEN
538         IF v_attr_value = FND_API.G_MISS_CHAR THEN
539           v_attr_value := NULL;
540         END IF;
541       WHEN OTHERS THEN
542         v_attr_value := NULL;
543     END;
544  
545     IF (v_attr_value IS NOT NULL) THEN
546  
547       x_qual_ctxts_result_tbl(q_count).context_name := 'MODLIST';
548       x_qual_ctxts_result_tbl(q_count).attribute_name := 'QUALIFIER_ATTRIBUTE4';
549       x_qual_ctxts_result_tbl(q_count).attribute_value := v_attr_value;
550       q_count := q_count + 1;
551         IF l_debug = FND_API.G_TRUE THEN
552           oe_debug_pub.add('After product assigned');
553         END IF;
554     END IF;--v_attr_(m)value
555   END IF;
556  
557 END IF;
558  
559   QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;
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 --  Attribute not used
605 --  Attribute not used
606 --  Attribute not used
607 --  Attribute not used
608 --  Attribute not used
609 IF p_req_type_code = 'ONT' THEN
610  
611   IF p_pricing_type_code = 'H' THEN
612  
613     NULL;
614  
615 --  Src_Type: API
616     BEGIN
617       v_attr_value := 
618                       OE_ORDER_PUB.G_HDR.price_list_id;
619     EXCEPTION
620       WHEN OTHERS THEN
621         v_attr_value := NULL;
622     END;
623  
624     BEGIN
625     IF v_attr_value = FND_API.G_MISS_NUM THEN
626       v_attr_value := NULL;
627     END IF;
628     EXCEPTION
629       WHEN VALUE_ERROR THEN
630         IF v_attr_value = FND_API.G_MISS_CHAR THEN
631           v_attr_value := NULL;
632         END IF;
633       WHEN OTHERS THEN
634         v_attr_value := NULL;
635     END;
636  
637     IF (v_attr_value IS NOT NULL) THEN
638  
639       x_qual_ctxts_result_tbl(q_count).context_name := 'MODLIST';
640       x_qual_ctxts_result_tbl(q_count).attribute_name := 'QUALIFIER_ATTRIBUTE4';
641       x_qual_ctxts_result_tbl(q_count).attribute_value := v_attr_value;
642       q_count := q_count + 1;
643         IF l_debug = FND_API.G_TRUE THEN
644           oe_debug_pub.add('After product assigned');
645         END IF;
646     END IF;--v_attr_(m)value
647   END IF;
648  
649 END IF;
650  
651   QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;
652 --  Attribute not used
653 --  Attribute not used
654 --  Attribute not used
655 IF p_req_type_code = 'INTORG' THEN
656  
657   IF p_pricing_type_code = 'L' THEN
658  
659     NULL;
660  
661   END IF;
662  
663 END IF;
664  
665   QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;
666 IF p_req_type_code = 'INTORG' THEN
667  
668   IF p_pricing_type_code = 'H' THEN
669  
670     NULL;
671  
672   END IF;
673  
674 END IF;
675  
676   QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;
677 IF p_req_type_code = 'AHL' THEN
678  
679   IF p_pricing_type_code = 'L' THEN
680  
681     NULL;
682  
683   END IF;
684  
685 END IF;
686  
687   QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;
688 IF p_req_type_code = 'AHL' THEN
689  
690   IF p_pricing_type_code = 'H' THEN
691  
692     NULL;
693  
694   END IF;
695  
696 END IF;
697  
698   QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;
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 --  Attribute not used
729 --  Attribute not used
730 --  Attribute not used
731 --  Attribute not used
732 --  Attribute not used
733 IF p_req_type_code = 'OKS' THEN
734  
735   IF p_pricing_type_code = 'L' THEN
736  
737     NULL;
738  
739   END IF;
740  
741 END IF;
742  
743   QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;
744 --  Attribute not used
745 --  Attribute not used
746 --  Attribute not used
747 --  Attribute not used
748 --  Attribute not used
749 --  Attribute not used
750 --  Attribute not used
751 --  Attribute not used
752 --  Attribute not used
753 --  Attribute not used
754 IF p_req_type_code = 'OKS' THEN
755  
756   IF p_pricing_type_code = 'H' THEN
757  
758     NULL;
759  
760   END IF;
761  
762 END IF;
763  
764   QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;
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 --  Attribute not used
782 --  Attribute not used
783 --  Attribute not used
784 --  Attribute not used
785 --  Attribute not used
786 IF p_req_type_code = 'PO' THEN
787  
788   IF p_pricing_type_code = 'L' THEN
789  
790     NULL;
791  
792   END IF;
793  
794 END IF;
795  
796   QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;
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 --  Attribute not used
808 --  Attribute not used
809 --  Attribute not used
810 --  Attribute not used
811 --  Attribute not used
812 IF p_req_type_code = 'PO' THEN
813  
814   IF p_pricing_type_code = 'H' THEN
815  
816     NULL;
817  
818   END IF;
819  
820 END IF;
821  
822  
823   Else --Follow HVOP Path
824   NULL;
825  
826   End If; --HVOP Path
827  
828   If QP_Util_PUB.HVOP_Pricing_On = 'N' Then
829     if p_pricing_type_code = 'L' and qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_yes then
830       qp_preq_grp.g_new_pricing_call := qp_preq_grp.g_no;
831       IF l_debug = FND_API.G_TRUE THEN
832         oe_debug_pub.add('hw/src/L: change to g_no');
833       END IF;
834     end if;
835   End If;
836  
837 qp_debug_util.tstop('FETCH_ATTRIBUTES',v_tot_time);
838 qp_debug_util.setAttribute('BLD_CNTXT_ACCUM_TIME', to_char(v_tot_time));
839 END Get_Attribute_Values;
840  
841 FUNCTION Is_Attribute_Used (p_attribute_context IN VARCHAR2, p_attribute_code IN VARCHAR2)
842 RETURN VARCHAR2
843  
844 IS
845  
846 x_out	VARCHAR2(1) := 'N';
847 BEGIN
848  
849 IF (p_attribute_context = 'VOLUME') and (p_attribute_code = 'PRICING_ATTRIBUTE10')
850 THEN
851 x_out := 'N';
852 END IF;
853 IF (p_attribute_context = 'VOLUME') and (p_attribute_code = 'PRICING_ATTRIBUTE12')
854 THEN
855 x_out := 'N';
856 END IF;
857  
858 RETURN x_out;
859  
860 END Is_Attribute_Used;
861  
862 END QP_BUILD_SOURCING_PVT;