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 1257: l_Pricing_Attr_rec QP_PRICING_ATTRIBUTES%rowtype;

1253:
1254: l_status NUMBER;
1255: l_list_line_id NUMBER;
1256: l_list_line_type_code VARCHAR2(30);
1257: l_Pricing_Attr_rec QP_PRICING_ATTRIBUTES%rowtype;
1258:
1259: Cursor C_child_records(l_list_line_id number) IS
1260: SELECT *
1261: FROM QP_PRICING_ATTRIBUTES qll

Line 1261: FROM QP_PRICING_ATTRIBUTES qll

1257: l_Pricing_Attr_rec QP_PRICING_ATTRIBUTES%rowtype;
1258:
1259: Cursor C_child_records(l_list_line_id number) IS
1260: SELECT *
1261: FROM QP_PRICING_ATTRIBUTES qll
1262: WHERE qll.list_line_id IN (select
1263: to_rltd_modifier_id from
1264: qp_rltd_modifiers qrm where from_rltd_modifier_id
1265: = l_list_line_id);

Line 1289: update qp_Pricing_Attributes set

1285: EXIT WHEN C_child_records%NOTFOUND;
1286:
1287:
1288:
1289: update qp_Pricing_Attributes set
1290: Product_attribute_context =
1291: p_Pricing_Attr_rec.Product_attribute_context
1292: ,Product_attribute =
1293: p_Pricing_Attr_rec.Product_attribute

Line 1466: UPDATE QP_PRICING_ATTRIBUTES

1462: end if;
1463:
1464: /*changes by spgopal to include list_header_id ,pricing_phase_id in pricing attr for performance problems*/
1465:
1466: UPDATE QP_PRICING_ATTRIBUTES
1467: SET ACCUMULATE_FLAG = p_PRICING_ATTR_rec.accumulate_flag
1468: , ATTRIBUTE1 = p_PRICING_ATTR_rec.attribute1
1469: , ATTRIBUTE10 = p_PRICING_ATTR_rec.attribute10
1470: , ATTRIBUTE11 = p_PRICING_ATTR_rec.attribute11

Line 1683: INSERT INTO QP_PRICING_ATTRIBUTES

1679: end if;
1680:
1681: /*changs by spgopal to include list_header_id ,pricing_phase_id in pricing attr for performance problems*/
1682:
1683: INSERT INTO QP_PRICING_ATTRIBUTES
1684: (
1685: --ACCUMULATE_FLAG
1686: ATTRIBUTE1
1687: , ATTRIBUTE10

Line 1873: DELETE FROM QP_PRICING_ATTRIBUTES

1869: BEGIN
1870: oe_debug_pub.add('BEGIN Delete_Row in QPXUPRAB');
1871:
1872:
1873: DELETE FROM QP_PRICING_ATTRIBUTES
1874: WHERE PRICING_ATTRIBUTE_ID = p_pricing_attribute_id
1875: RETURNING LIST_LINE_ID INTO l_list_line_id
1876: ;
1877:

Line 1978: FROM QP_PRICING_ATTRIBUTES

1974: , PRICING_PHASE_ID
1975: , PRICING_ATTR_VALUE_FROM_NUMBER
1976: , PRICING_ATTR_VALUE_TO_NUMBER
1977: , QUALIFICATION_IND
1978: FROM QP_PRICING_ATTRIBUTES
1979: WHERE ( PRICING_ATTRIBUTE_ID = p_pricing_attribute_id
1980: )
1981: OR ( LIST_LINE_ID = p_list_line_id
1982: );

Line 2211: FROM QP_PRICING_ATTRIBUTES

2207: , l_PRICING_ATTR_rec.pricing_attribute_datatype
2208: , l_PRICING_ATTR_rec.comparison_operator_code
2209: -- , l_PRICING_ATTR_rec.list_header_id
2210: -- , l_PRICING_ATTR_rec.pricing_phase_id
2211: FROM QP_PRICING_ATTRIBUTES
2212: WHERE PRICING_ATTRIBUTE_ID = p_PRICING_ATTR_rec.pricing_attribute_id
2213: FOR UPDATE NOWAIT;
2214:
2215: -- Row locked. Compare IN attributes to DB attributes.