APPS.QP_PRICING_ATTR_UTIL dependencies on QP_PRICING_ATTRIBUTES

Line 785: UPDATE qp_pricing_attributes

781:
782: -- for updating price breaks rassharm bug no 7315129
783: IF p_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE
784: THEN
785: UPDATE qp_pricing_attributes
786: SET product_uom_code = p_PRICING_ATTR_rec.product_uom_code
787: WHERE list_line_id = p_PRICING_ATTR_rec.list_line_id;
788:
789: -- for updating price breaks rassharm bug no 7315129

Line 791: update qp_pricing_attributes

787: WHERE list_line_id = p_PRICING_ATTR_rec.list_line_id;
788:
789: -- for updating price breaks rassharm bug no 7315129
790:
791: update qp_pricing_attributes
792: SET product_uom_code = p_PRICING_ATTR_rec.product_uom_code
793: where list_line_id in
794: (
795: select to_rltd_modifier_id

Line 1273: l_Pricing_Attr_rec QP_PRICING_ATTRIBUTES%rowtype;

1269:
1270: l_status NUMBER;
1271: l_list_line_id NUMBER;
1272: l_list_line_type_code VARCHAR2(30);
1273: l_Pricing_Attr_rec QP_PRICING_ATTRIBUTES%rowtype;
1274:
1275: Cursor C_child_records(l_list_line_id number) IS
1276: SELECT *
1277: FROM QP_PRICING_ATTRIBUTES qll

Line 1277: FROM QP_PRICING_ATTRIBUTES qll

1273: l_Pricing_Attr_rec QP_PRICING_ATTRIBUTES%rowtype;
1274:
1275: Cursor C_child_records(l_list_line_id number) IS
1276: SELECT *
1277: FROM QP_PRICING_ATTRIBUTES qll
1278: WHERE qll.list_line_id IN (select
1279: to_rltd_modifier_id from
1280: qp_rltd_modifiers qrm where from_rltd_modifier_id
1281: = l_list_line_id);

Line 1305: update qp_Pricing_Attributes set

1301: EXIT WHEN C_child_records%NOTFOUND;
1302:
1303:
1304:
1305: update qp_Pricing_Attributes set
1306: Product_attribute_context =
1307: p_Pricing_Attr_rec.Product_attribute_context
1308: ,Product_attribute =
1309: p_Pricing_Attr_rec.Product_attribute

Line 1482: UPDATE QP_PRICING_ATTRIBUTES

1478: end if;
1479:
1480: /*changes by spgopal to include list_header_id ,pricing_phase_id in pricing attr for performance problems*/
1481:
1482: UPDATE QP_PRICING_ATTRIBUTES
1483: SET ACCUMULATE_FLAG = p_PRICING_ATTR_rec.accumulate_flag
1484: , ATTRIBUTE1 = p_PRICING_ATTR_rec.attribute1
1485: , ATTRIBUTE10 = p_PRICING_ATTR_rec.attribute10
1486: , ATTRIBUTE11 = p_PRICING_ATTR_rec.attribute11

Line 1699: INSERT INTO QP_PRICING_ATTRIBUTES

1695: end if;
1696:
1697: /*changs by spgopal to include list_header_id ,pricing_phase_id in pricing attr for performance problems*/
1698:
1699: INSERT INTO QP_PRICING_ATTRIBUTES
1700: (
1701: --ACCUMULATE_FLAG
1702: ATTRIBUTE1
1703: , ATTRIBUTE10

Line 1889: DELETE FROM QP_PRICING_ATTRIBUTES

1885: BEGIN
1886: oe_debug_pub.add('BEGIN Delete_Row in QPXUPRAB');
1887:
1888:
1889: DELETE FROM QP_PRICING_ATTRIBUTES
1890: WHERE PRICING_ATTRIBUTE_ID = p_pricing_attribute_id
1891: RETURNING LIST_LINE_ID INTO l_list_line_id
1892: ;
1893:

Line 1994: FROM QP_PRICING_ATTRIBUTES

1990: , PRICING_PHASE_ID
1991: , PRICING_ATTR_VALUE_FROM_NUMBER
1992: , PRICING_ATTR_VALUE_TO_NUMBER
1993: , QUALIFICATION_IND
1994: FROM QP_PRICING_ATTRIBUTES
1995: WHERE ( PRICING_ATTRIBUTE_ID = p_pricing_attribute_id
1996: )
1997: OR ( LIST_LINE_ID = p_list_line_id
1998: );

Line 2227: FROM QP_PRICING_ATTRIBUTES

2223: , l_PRICING_ATTR_rec.pricing_attribute_datatype
2224: , l_PRICING_ATTR_rec.comparison_operator_code
2225: -- , l_PRICING_ATTR_rec.list_header_id
2226: -- , l_PRICING_ATTR_rec.pricing_phase_id
2227: FROM QP_PRICING_ATTRIBUTES
2228: WHERE PRICING_ATTRIBUTE_ID = p_PRICING_ATTR_rec.pricing_attribute_id
2229: FOR UPDATE NOWAIT;
2230:
2231: -- Row locked. Compare IN attributes to DB attributes.

Line 2857: update qp_pricing_attributes

2853: IF ((p_old_PRICING_ATTR_rec.product_attribute <> p_PRICING_ATTR_rec.product_attribute) OR
2854: (p_old_PRICING_ATTR_rec.product_attr_value <> p_PRICING_ATTR_rec.product_attr_value))
2855: THEN
2856: begin
2857: update qp_pricing_attributes
2858: set product_attribute = p_PRICING_ATTR_rec.product_attribute
2859: , product_attr_value = p_PRICING_ATTR_rec.product_attr_value
2860: where list_line_id = p_PRICING_ATTR_rec.list_line_id;
2861: exception

Line 2869: update qp_pricing_attributes

2865: END IF;
2866:
2867: ELSIF ( p_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE AND p_PRICING_ATTR_rec.excluder_flag = 'N') THEN --14603635
2868: begin
2869: update qp_pricing_attributes
2870: set product_attribute = p_PRICING_ATTR_rec.product_attribute
2871: , product_attr_value = p_PRICING_ATTR_rec.product_attr_value
2872: where list_line_id = p_PRICING_ATTR_rec.list_line_id;
2873: exception