Advanced Pricing - EBS (MOSC)

MOSC Banner

all lines are updated with same value in modifier line in R12.1.3

edited Feb 20, 2019 4:00AM in Advanced Pricing - EBS (MOSC) 2 commentsAnswered

Hi All,

I have data in modifier line in custom table and now i want to update the operand value with 20.

            

RECORD_TYPEMODIFIER_NAMEMODIFIER_LEVEL_CODELIST_LINE_TYPE_CODEPRICING_PHASE_NAMEPRODUCT_ATTRIBUTE_TYPEPRODUCT_ATTR_VALUEARITHMETIC_OPERATOROPERANDPRICING_PHASE_IDPROD_SEQUENCE_IDPRODUCT_ATTRIBUTE
MLTESTLineDISList Line AdjustmentItem NumberABCNEWPRICE10.32220PRICING_ATTRIBUTE1
MLTESTLineDISList Line AdjustmentItem NumberABCNEWPRICE202220PRICING_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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center