DBA Data[Home] [Help]

APPS.QP_BUILD_SOURCING_PVT_TMP 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: v_tot_time NUMBER := 0;

Line 55: QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;

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:

Line 66: QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;

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:

Line 77: QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;

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

Line 101: QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;

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:

Line 112: QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;

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:

Line 123: QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;

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:

Line 134: QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;

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

Line 253: QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;

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

Line 339: QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;

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

Line 388: QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;

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

Line 412: QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;

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

Line 559: QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;

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

Line 651: QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;

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

Line 665: QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;

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:

Line 676: QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;

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:

Line 687: QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;

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:

Line 698: QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;

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

Line 743: QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;

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

Line 764: QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;

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

Line 796: QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;

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