all lines are updated with same value in modifier line in R12.1.3
Hi All,
I have data in modifier line in custom table and now i want to update the operand value with 20.
RECORD_TYPE | MODIFIER_NAME | MODIFIER_LEVEL_CODE | LIST_LINE_TYPE_CODE | PRICING_PHASE_NAME | PRODUCT_ATTRIBUTE_TYPE | PRODUCT_ATTR_VALUE | ARITHMETIC_OPERATOR | OPERAND | PRICING_PHASE_ID | PROD_SEQUENCE_ID | PRODUCT_ATTRIBUTE |
ML | TEST | Line | DIS | List Line Adjustment | Item Number | ABC | NEWPRICE | 10.3 | 2 | 220 | PRICING_ATTRIBUTE1 |
ML | TEST | Line | DIS | List Line Adjustment | Item Number | ABC | NEWPRICE | 20 | 2 | 220 | PRICING_ATTRIBUTE1 |
Here is my code...
l_modifiers_tbl (1).operation := qp_globals.g_opr_create; l_pricing_attr_tbl (1).operation := qp_globals.g_opr_create;x_line_id := null;Begin SELECT qll.list_line_id INTO x_line_id FROM qp_list_lines qll , qp_pricing_attributes qpr , qp_list_headers qlh WHERE qlh.list_header_id = qll.list_header_id AND qll.list_header_id = qpr.list_header_id AND qll.list_line_id = qpr.list_line_id AND UPPER(qlh.NAME) = UPPER (fetch_xxqp_list_headers_stg.MODIFIER_NAME) AND qpr.product_attribute = fetch_xxqp_list_lines_stg.product_attribute AND qpr.product_attribute_context = UPPER (fetch_xxqp_list_lines_stg.product_attribute_context) AND qpr.product_attr_value = TO_CHAR (fetch_xxqp_list_lines_stg.product_attr_value_id) AND (qll.end_date_active is null OR TRUNC (qll.end_date_active) > SYSDATE); fnd_file.put_line(fnd_file.log,'x_line_id.. '||x_line_id );IF x_line_id > 0 THEN l_modifiers_tbl (1).list_line_id := x_line_id; l_modifiers_tbl (1).operation := qp_globals.g_opr_update;END IF; EXCEPTIONWHEN OTHERS THEN l_modifiers_tbl (1).operation := qp_globals.g_opr_create; END;
0