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 1189: UPDATE QP_PRICING_ATTRIBUTES

1185: IF G_PRODUCT_UOM_CODE IS NULL
1186: THEN G_PRODUCT_UOM_CODE :=p_PRICING_ATTR_rec.product_uom_code;
1187: END IF;
1188:
1189: UPDATE QP_PRICING_ATTRIBUTES
1190: SET ACCUMULATE_FLAG = p_PRICING_ATTR_rec.accumulate_flag
1191: , ATTRIBUTE1 = p_PRICING_ATTR_rec.attribute1
1192: , ATTRIBUTE10 = p_PRICING_ATTR_rec.attribute10
1193: , ATTRIBUTE11 = p_PRICING_ATTR_rec.attribute11

Line 1333: INSERT INTO QP_PRICING_ATTRIBUTES

1329: NULL;
1330: END;
1331:
1332:
1333: INSERT INTO QP_PRICING_ATTRIBUTES
1334: ( ACCUMULATE_FLAG
1335: , ATTRIBUTE1
1336: , ATTRIBUTE10
1337: , ATTRIBUTE11

Line 1504: DELETE FROM QP_PRICING_ATTRIBUTES

1500: BEGIN
1501:
1502:
1503:
1504: DELETE FROM QP_PRICING_ATTRIBUTES
1505: WHERE PRICING_ATTRIBUTE_ID = p_pricing_attribute_id
1506: ;
1507:
1508:

Line 1600: FROM QP_PRICING_ATTRIBUTES

1596: , PRODUCT_ATTRIBUTE_DATATYPE
1597: , PRICING_ATTR_VALUE_FROM_NUMBER
1598: , PRICING_ATTR_VALUE_TO_NUMBER
1599: , QUALIFICATION_IND
1600: FROM QP_PRICING_ATTRIBUTES
1601: WHERE ( PRICING_ATTRIBUTE_ID = p_pricing_attribute_id
1602: )
1603: OR ( LIST_LINE_ID = p_list_line_id
1604: );

Line 1823: FROM QP_PRICING_ATTRIBUTES

1819: , l_PRICING_ATTR_rec.request_id
1820: , l_PRICING_ATTR_rec.comparison_operator_code
1821: , l_PRICING_ATTR_rec.pricing_attribute_datatype
1822: , l_PRICING_ATTR_rec.product_attribute_datatype
1823: FROM QP_PRICING_ATTRIBUTES
1824: WHERE PRICING_ATTRIBUTE_ID = p_PRICING_ATTR_rec.pricing_attribute_id
1825: FOR UPDATE NOWAIT;
1826:
1827: -- Row locked. Compare IN attributes to DB attributes.

Line 2360: update qp_pricing_attributes

2356: IF ((p_old_PRICING_ATTR_rec.product_attribute <> p_PRICING_ATTR_rec.product_attribute) OR
2357: (p_old_PRICING_ATTR_rec.product_attr_value <> p_PRICING_ATTR_rec.product_attr_value))
2358: THEN
2359: begin
2360: update qp_pricing_attributes
2361: set product_attribute = p_PRICING_ATTR_rec.product_attribute
2362: , product_attr_value = p_PRICING_ATTR_rec.product_attr_value
2363: where list_line_id = p_PRICING_ATTR_rec.list_line_id;
2364: exception

Line 2372: update qp_pricing_attributes

2368: END IF;
2369:
2370: ELSIF ( p_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE ) THEN
2371: begin
2372: update qp_pricing_attributes
2373: set product_attribute = p_PRICING_ATTR_rec.product_attribute
2374: , product_attr_value = p_PRICING_ATTR_rec.product_attr_value
2375: where list_line_id = p_PRICING_ATTR_rec.list_line_id;
2376: exception