APPS.QP_PLL_PRICING_ATTR_UTIL dependencies on QP_PRICING_ATTRIBUTES

Line 664: UPDATE qp_pricing_attributes

660: G_PRODUCT_UOM_CODE := p_PRICING_ATTR_rec.product_uom_code;
661: -- added for bug 2912834
662: IF p_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE
663: THEN
664: UPDATE qp_pricing_attributes
665: SET product_uom_code = p_PRICING_ATTR_rec.product_uom_code
666: WHERE list_line_id = p_PRICING_ATTR_rec.list_line_id;
667:
668: -- for updating price breaks rassharm bug no 5965155

Line 669: update qp_pricing_attributes

665: SET product_uom_code = p_PRICING_ATTR_rec.product_uom_code
666: WHERE list_line_id = p_PRICING_ATTR_rec.list_line_id;
667:
668: -- for updating price breaks rassharm bug no 5965155
669: update qp_pricing_attributes
670: SET product_uom_code = p_PRICING_ATTR_rec.product_uom_code
671: where list_line_id in
672: (
673: select to_rltd_modifier_id

Line 1173: UPDATE QP_PRICING_ATTRIBUTES

1169: IF G_PRODUCT_UOM_CODE IS NULL
1170: THEN G_PRODUCT_UOM_CODE :=p_PRICING_ATTR_rec.product_uom_code;
1171: END IF;
1172:
1173: UPDATE QP_PRICING_ATTRIBUTES
1174: SET ACCUMULATE_FLAG = p_PRICING_ATTR_rec.accumulate_flag
1175: , ATTRIBUTE1 = p_PRICING_ATTR_rec.attribute1
1176: , ATTRIBUTE10 = p_PRICING_ATTR_rec.attribute10
1177: , ATTRIBUTE11 = p_PRICING_ATTR_rec.attribute11

Line 1317: INSERT INTO QP_PRICING_ATTRIBUTES

1313: NULL;
1314: END;
1315:
1316:
1317: INSERT INTO QP_PRICING_ATTRIBUTES
1318: ( ACCUMULATE_FLAG
1319: , ATTRIBUTE1
1320: , ATTRIBUTE10
1321: , ATTRIBUTE11

Line 1488: DELETE FROM QP_PRICING_ATTRIBUTES

1484: BEGIN
1485:
1486:
1487:
1488: DELETE FROM QP_PRICING_ATTRIBUTES
1489: WHERE PRICING_ATTRIBUTE_ID = p_pricing_attribute_id
1490: ;
1491:
1492:

Line 1584: FROM QP_PRICING_ATTRIBUTES

1580: , PRODUCT_ATTRIBUTE_DATATYPE
1581: , PRICING_ATTR_VALUE_FROM_NUMBER
1582: , PRICING_ATTR_VALUE_TO_NUMBER
1583: , QUALIFICATION_IND
1584: FROM QP_PRICING_ATTRIBUTES
1585: WHERE ( PRICING_ATTRIBUTE_ID = p_pricing_attribute_id
1586: )
1587: OR ( LIST_LINE_ID = p_list_line_id
1588: );

Line 1807: FROM QP_PRICING_ATTRIBUTES

1803: , l_PRICING_ATTR_rec.request_id
1804: , l_PRICING_ATTR_rec.comparison_operator_code
1805: , l_PRICING_ATTR_rec.pricing_attribute_datatype
1806: , l_PRICING_ATTR_rec.product_attribute_datatype
1807: FROM QP_PRICING_ATTRIBUTES
1808: WHERE PRICING_ATTRIBUTE_ID = p_PRICING_ATTR_rec.pricing_attribute_id
1809: FOR UPDATE NOWAIT;
1810:
1811: -- Row locked. Compare IN attributes to DB attributes.

Line 2294: update qp_pricing_attributes

2290: IF ((p_old_PRICING_ATTR_rec.product_attribute <> p_PRICING_ATTR_rec.product_attribute) OR
2291: (p_old_PRICING_ATTR_rec.product_attr_value <> p_PRICING_ATTR_rec.product_attr_value))
2292: THEN
2293: begin
2294: update qp_pricing_attributes
2295: set product_attribute = p_PRICING_ATTR_rec.product_attribute
2296: , product_attr_value = p_PRICING_ATTR_rec.product_attr_value
2297: where list_line_id = p_PRICING_ATTR_rec.list_line_id;
2298: exception

Line 2306: update qp_pricing_attributes

2302: END IF;
2303:
2304: ELSIF ( p_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE ) THEN
2305: begin
2306: update qp_pricing_attributes
2307: set product_attribute = p_PRICING_ATTR_rec.product_attribute
2308: , product_attr_value = p_PRICING_ATTR_rec.product_attr_value
2309: where list_line_id = p_PRICING_ATTR_rec.list_line_id;
2310: exception