DBA Data[Home] [Help]

APPS.QP_BUILD_SOURCING_PVT dependencies on QP_ATTR_MAPPING_PUB

Line 29: , x_qual_ctxts_result_tbl OUT NOCOPY QP_Attr_Mapping_PUB.CONTEXTS_RESULT_TBL_TYPE

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:

Line 30: , x_price_ctxts_result_tbl OUT NOCOPY QP_Attr_Mapping_PUB.CONTEXTS_RESULT_TBL_TYPE

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);

Line 35: v_attr_mvalue QP_Attr_Mapping_PUB.t_MultiRecord;

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;

Line 54: QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;

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:

Line 65: QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;

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:

Line 76: QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;

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

Line 100: QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;

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:

Line 111: QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;

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:

Line 122: QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;

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:

Line 133: QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;

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

Line 251: QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;

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

Line 336: QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;

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

Line 385: QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;

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

Line 409: QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;

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

Line 555: QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;

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

Line 646: QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;

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

Line 660: QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;

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:

Line 671: QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;

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:

Line 682: QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;

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:

Line 693: QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;

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

Line 738: QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;

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

Line 759: QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;

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

Line 791: QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;

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