DBA Data[Home] [Help]

APPS.QP_PLL_PRICING_ATTR_UTIL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 158

        IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_updated_by,p_old_PRICING_ATTR_rec.last_updated_by)
        THEN
            l_index := l_index + 1;
Line: 161

            l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_LAST_UPDATED_BY;
Line: 164

        IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_update_date,p_old_PRICING_ATTR_rec.last_update_date)
        THEN
            l_index := l_index + 1;
Line: 167

            l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_LAST_UPDATE_DATE;
Line: 170

        IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_update_login,p_old_PRICING_ATTR_rec.last_update_login)
        THEN
            l_index := l_index + 1;
Line: 173

            l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_LAST_UPDATE_LOGIN;
Line: 268

        IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_update_date,p_old_PRICING_ATTR_rec.program_update_date)
        THEN
            l_index := l_index + 1;
Line: 271

            l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PROGRAM_UPDATE_DATE;
Line: 361

    ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
        l_index := l_index + 1;
Line: 363

        l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_LAST_UPDATED_BY;
Line: 364

    ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
        l_index := l_index + 1;
Line: 366

        l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_LAST_UPDATE_DATE;
Line: 367

    ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
        l_index := l_index + 1;
Line: 369

        l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_LAST_UPDATE_LOGIN;
Line: 412

    ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN
        l_index := l_index + 1;
Line: 414

        l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PROGRAM_UPDATE_DATE;
Line: 455

          SELECT list_header_id
          INTO   l_list_header_id
          FROM   qp_list_lines
          WHERE  list_line_id = p_PRICING_ATTR_rec.list_line_id;
Line: 574

    IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_updated_by,p_old_PRICING_ATTR_rec.last_updated_by)
    THEN
        NULL;
Line: 579

    IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_update_date,p_old_PRICING_ATTR_rec.last_update_date)
    THEN
        NULL;
Line: 584

    IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_update_login,p_old_PRICING_ATTR_rec.last_update_login)
    THEN
        NULL;
Line: 596

                 p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
                 x_return_status => l_return_status);
Line: 662

        IF p_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE
        THEN
          UPDATE qp_pricing_attributes
          SET product_uom_code = p_PRICING_ATTR_rec.product_uom_code
          WHERE list_line_id = p_PRICING_ATTR_rec.list_line_id;
Line: 669

         update qp_pricing_attributes
         SET product_uom_code = p_PRICING_ATTR_rec.product_uom_code
         where list_line_id in
        (
        select to_rltd_modifier_id
        from qp_list_lines ql, qp_rltd_modifiers qrm
        where from_rltd_modifier_id= p_PRICING_ATTR_rec.list_line_id
        AND qrm.to_rltd_modifier_id = ql.list_line_id
        AND qrm.rltd_modifier_grp_type = 'PRICE BREAK'
        ) ;
Line: 685

	  IF(p_PRICING_ATTR_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
              qp_delayed_requests_pvt.log_request(
		p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_entity_id => p_PRICING_ATTR_rec.list_header_id,
		p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
		p_request_unique_key2 => 'UD',
		p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_requesting_entity_id => p_PRICING_ATTR_rec.list_header_id,
		p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,
		x_return_status => l_return_status);
Line: 711

    IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_update_date,p_old_PRICING_ATTR_rec.program_update_date)
    THEN
        NULL;
Line: 832

    IF l_PRICING_ATTR_rec.last_updated_by = FND_API.G_MISS_NUM THEN
        l_PRICING_ATTR_rec.last_updated_by := p_old_PRICING_ATTR_rec.last_updated_by;
Line: 836

    IF l_PRICING_ATTR_rec.last_update_date = FND_API.G_MISS_DATE THEN
        l_PRICING_ATTR_rec.last_update_date := p_old_PRICING_ATTR_rec.last_update_date;
Line: 840

    IF l_PRICING_ATTR_rec.last_update_login = FND_API.G_MISS_NUM THEN
        l_PRICING_ATTR_rec.last_update_login := p_old_PRICING_ATTR_rec.last_update_login;
Line: 904

    IF l_PRICING_ATTR_rec.program_update_date = FND_API.G_MISS_DATE THEN
        l_PRICING_ATTR_rec.program_update_date := p_old_PRICING_ATTR_rec.program_update_date;
Line: 1029

    IF l_PRICING_ATTR_rec.last_updated_by = FND_API.G_MISS_NUM THEN
        l_PRICING_ATTR_rec.last_updated_by := NULL;
Line: 1033

    IF l_PRICING_ATTR_rec.last_update_date = FND_API.G_MISS_DATE THEN
        l_PRICING_ATTR_rec.last_update_date := NULL;
Line: 1037

    IF l_PRICING_ATTR_rec.last_update_login = FND_API.G_MISS_NUM THEN
        l_PRICING_ATTR_rec.last_update_login := NULL;
Line: 1097

    IF l_PRICING_ATTR_rec.program_update_date = FND_API.G_MISS_DATE THEN
        l_PRICING_ATTR_rec.program_update_date := NULL;
Line: 1127

PROCEDURE Update_Row
(   p_PRICING_ATTR_rec              IN  QP_Price_List_PUB.Pricing_Attr_Rec_Type
)
IS
l_pric_attr_value_from_number NUMBER := NULL;
Line: 1139

SELECT ACTIVE_FLAG
       INTO   l_active_flag
       FROM   QP_LIST_HEADERS_B
       WHERE  LIST_HEADER_ID = p_PRICING_ATTR_rec.list_header_id;
Line: 1144

oe_debug_pub.add('BEGIN Update_Row in QPXUPRAB');
Line: 1173

    UPDATE  QP_PRICING_ATTRIBUTES
    SET     ACCUMULATE_FLAG                = p_PRICING_ATTR_rec.accumulate_flag
    ,       ATTRIBUTE1                     = p_PRICING_ATTR_rec.attribute1
    ,       ATTRIBUTE10                    = p_PRICING_ATTR_rec.attribute10
    ,       ATTRIBUTE11                    = p_PRICING_ATTR_rec.attribute11
    ,       ATTRIBUTE12                    = p_PRICING_ATTR_rec.attribute12
    ,       ATTRIBUTE13                    = p_PRICING_ATTR_rec.attribute13
    ,       ATTRIBUTE14                    = p_PRICING_ATTR_rec.attribute14
    ,       ATTRIBUTE15                    = p_PRICING_ATTR_rec.attribute15
    ,       ATTRIBUTE2                     = p_PRICING_ATTR_rec.attribute2
    ,       ATTRIBUTE3                     = p_PRICING_ATTR_rec.attribute3
    ,       ATTRIBUTE4                     = p_PRICING_ATTR_rec.attribute4
    ,       ATTRIBUTE5                     = p_PRICING_ATTR_rec.attribute5
    ,       ATTRIBUTE6                     = p_PRICING_ATTR_rec.attribute6
    ,       ATTRIBUTE7                     = p_PRICING_ATTR_rec.attribute7
    ,       ATTRIBUTE8                     = p_PRICING_ATTR_rec.attribute8
    ,       ATTRIBUTE9                     = p_PRICING_ATTR_rec.attribute9
    ,       ATTRIBUTE_GROUPING_NO          = p_PRICING_ATTR_rec.attribute_grouping_no
    ,       CONTEXT                        = p_PRICING_ATTR_rec.context
    ,       CREATED_BY                     = p_PRICING_ATTR_rec.created_by
    ,       CREATION_DATE                  = p_PRICING_ATTR_rec.creation_date
    ,       EXCLUDER_FLAG                  = p_PRICING_ATTR_rec.excluder_flag
    ,       LAST_UPDATED_BY                = p_PRICING_ATTR_rec.last_updated_by
    ,       LAST_UPDATE_DATE               = p_PRICING_ATTR_rec.last_update_date
    ,       LAST_UPDATE_LOGIN              = p_PRICING_ATTR_rec.last_update_login
    ,       LIST_LINE_ID                   = p_PRICING_ATTR_rec.list_line_id
    ,       LIST_HEADER_ID                 = p_PRICING_ATTR_rec.list_header_id
    ,       PRICING_PHASE_ID               = p_PRICING_ATTR_rec.pricing_phase_id
    ,       PRICING_ATTRIBUTE              = p_PRICING_ATTR_rec.pricing_attribute
    ,       PRICING_ATTRIBUTE_CONTEXT      = p_PRICING_ATTR_rec.pricing_attribute_context
    ,       PRICING_ATTRIBUTE_ID           = p_PRICING_ATTR_rec.pricing_attribute_id
    ,       PRICING_ATTR_VALUE_FROM        = l_pric_attr_value_from
    ,       PRICING_ATTR_VALUE_TO          = p_PRICING_ATTR_rec.pricing_attr_value_to
    ,       PRODUCT_ATTRIBUTE              = p_PRICING_ATTR_rec.product_attribute
    ,       PRODUCT_ATTRIBUTE_CONTEXT      = p_PRICING_ATTR_rec.product_attribute_context
    ,       PRODUCT_ATTR_VALUE             = p_PRICING_ATTR_rec.product_attr_value
    --,       PRODUCT_UOM_CODE               = p_PRICING_ATTR_rec.product_uom_code
    ,       PRODUCT_UOM_CODE               = G_PRODUCT_UOM_CODE
    ,       PROGRAM_APPLICATION_ID         = p_PRICING_ATTR_rec.program_application_id
    ,       PROGRAM_ID                     = p_PRICING_ATTR_rec.program_id
    ,       PROGRAM_UPDATE_DATE            = p_PRICING_ATTR_rec.program_update_date
    ,       REQUEST_ID                     = p_PRICING_ATTR_rec.request_id
    ,       COMPARISON_OPERATOR_CODE       = p_PRICING_ATTR_rec.comparison_operator_code
    ,       PRICING_ATTRIBUTE_DATATYPE     = p_PRICING_ATTR_rec.pricing_attribute_datatype
    ,       PRODUCT_ATTRIBUTE_DATATYPE     = p_PRICING_ATTR_rec.product_attribute_datatype
    ,       PRICING_ATTR_VALUE_FROM_NUMBER = l_pric_attr_value_from_number
    ,       PRICING_ATTR_VALUE_TO_NUMBER   = l_pric_attr_value_to_number
    ,       QUALIFICATION_IND             = p_PRICING_ATTR_rec.qualification_ind
    WHERE   PRICING_ATTRIBUTE_ID = p_PRICING_ATTR_rec.pricing_attribute_id
    ;
Line: 1230

     UPDATE qp_pte_segments set used_in_setup='Y'
     WHERE  nvl(used_in_setup,'N')='N'
     AND    segment_id IN
      (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b
       WHERE  a.segment_mapping_column=p_PRICING_ATTR_rec.pricing_attribute
       AND    a.prc_context_id=b.prc_context_id
       AND    b.prc_context_type='PRICING_ATTRIBUTE'
       AND    b.prc_context_code=p_PRICING_ATTR_rec.pricing_attribute_context);
Line: 1244

     UPDATE qp_pte_segments set used_in_setup='Y'
     WHERE  nvl(used_in_setup,'N')='N'
     AND    segment_id IN
      (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b
       WHERE  a.segment_mapping_column=p_PRICING_ATTR_rec.product_attribute
       AND    a.prc_context_id=b.prc_context_id
       AND    b.prc_context_type='PRODUCT'
       AND    b.prc_context_code=p_PRICING_ATTR_rec.product_attribute_context);
Line: 1264

            ,   'Update_Row'
            );
Line: 1270

END Update_Row;
Line: 1274

PROCEDURE Insert_Row
(   p_PRICING_ATTR_rec              IN  QP_Price_List_PUB.Pricing_Attr_Rec_Type
)
IS
l_check_active_flag VARCHAR2(1);
Line: 1287

oe_debug_pub.add('BEGIN Update_Row in QPXUPRAB');
Line: 1288

SELECT ACTIVE_FLAG
       INTO   l_active_flag
       FROM   QP_LIST_HEADERS_B
       WHERE  LIST_HEADER_ID = p_PRICING_ATTR_rec.list_header_id;
Line: 1317

    INSERT  INTO QP_PRICING_ATTRIBUTES
    (       ACCUMULATE_FLAG
    ,       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       ATTRIBUTE_GROUPING_NO
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       EXCLUDER_FLAG
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       LIST_LINE_ID
    ,       LIST_HEADER_ID
    ,       PRICING_PHASE_ID
    ,       PRICING_ATTRIBUTE
    ,       PRICING_ATTRIBUTE_CONTEXT
    ,       PRICING_ATTRIBUTE_ID
    ,       PRICING_ATTR_VALUE_FROM
    ,       PRICING_ATTR_VALUE_TO
    ,       PRODUCT_ATTRIBUTE
    ,       PRODUCT_ATTRIBUTE_CONTEXT
    ,       PRODUCT_ATTR_VALUE
    ,       PRODUCT_UOM_CODE
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       REQUEST_ID
    ,       COMPARISON_OPERATOR_CODE
    ,       PRICING_ATTRIBUTE_DATATYPE
    ,       PRODUCT_ATTRIBUTE_DATATYPE
    ,       PRICING_ATTR_VALUE_FROM_NUMBER
    ,       PRICING_ATTR_VALUE_TO_NUMBER
    ,       QUALIFICATION_IND
     --ENH Upgrade BOAPI for orig_sys...ref RAVI
     ,ORIG_SYS_PRICING_ATTR_REF
     ,ORIG_SYS_LINE_REF
     ,ORIG_SYS_HEADER_REF
    )
    VALUES
    (       p_PRICING_ATTR_rec.accumulate_flag
    ,       p_PRICING_ATTR_rec.attribute1
    ,       p_PRICING_ATTR_rec.attribute10
    ,       p_PRICING_ATTR_rec.attribute11
    ,       p_PRICING_ATTR_rec.attribute12
    ,       p_PRICING_ATTR_rec.attribute13
    ,       p_PRICING_ATTR_rec.attribute14
    ,       p_PRICING_ATTR_rec.attribute15
    ,       p_PRICING_ATTR_rec.attribute2
    ,       p_PRICING_ATTR_rec.attribute3
    ,       p_PRICING_ATTR_rec.attribute4
    ,       p_PRICING_ATTR_rec.attribute5
    ,       p_PRICING_ATTR_rec.attribute6
    ,       p_PRICING_ATTR_rec.attribute7
    ,       p_PRICING_ATTR_rec.attribute8
    ,       p_PRICING_ATTR_rec.attribute9
    ,       p_PRICING_ATTR_rec.attribute_grouping_no
    ,       p_PRICING_ATTR_rec.context
    ,       p_PRICING_ATTR_rec.created_by
    ,       p_PRICING_ATTR_rec.creation_date
    ,       p_PRICING_ATTR_rec.excluder_flag
    ,       p_PRICING_ATTR_rec.last_updated_by
    ,       p_PRICING_ATTR_rec.last_update_date
    ,       p_PRICING_ATTR_rec.last_update_login
    ,       p_PRICING_ATTR_rec.list_line_id
    ,       p_PRICING_ATTR_rec.list_header_id
    ,       p_PRICING_ATTR_rec.pricing_phase_id
    ,       p_PRICING_ATTR_rec.pricing_attribute
    ,       p_PRICING_ATTR_rec.pricing_attribute_context
    ,       p_PRICING_ATTR_rec.pricing_attribute_id
    ,       l_pric_attr_value_from
    ,       p_PRICING_ATTR_rec.pricing_attr_value_to
    ,       p_PRICING_ATTR_rec.product_attribute
    ,       p_PRICING_ATTR_rec.product_attribute_context
    ,       p_PRICING_ATTR_rec.product_attr_value
    ,       p_PRICING_ATTR_rec.product_uom_code
    ,       p_PRICING_ATTR_rec.program_application_id
    ,       p_PRICING_ATTR_rec.program_id
    ,       p_PRICING_ATTR_rec.program_update_date
    ,       p_PRICING_ATTR_rec.request_id
    ,       p_PRICING_ATTR_rec.comparison_operator_code
    ,       p_PRICING_ATTR_rec.pricing_attribute_datatype
    ,       p_PRICING_ATTR_rec.product_attribute_datatype
    ,       l_pric_attr_value_from_number
    ,       l_pric_attr_value_to_number
    ,       p_PRICING_ATTR_rec.qualification_ind --euro bug 2138996
     --ENH Upgrade BOAPI for orig_sys...ref RAVI
     ,to_char(p_PRICING_ATTR_rec.pricing_attribute_id)
     ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=p_PRICING_ATTR_rec.list_line_id)
     ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=p_PRICING_ATTR_rec.list_header_id)
    );
Line: 1427

     UPDATE qp_pte_segments set used_in_setup='Y'
     WHERE  nvl(used_in_setup,'N')='N'
     AND    segment_id IN
      (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b
       WHERE  a.segment_mapping_column=p_PRICING_ATTR_rec.pricing_attribute
       AND    a.prc_context_id=b.prc_context_id
       AND    b.prc_context_type='PRICING_ATTRIBUTE'
       AND    b.prc_context_code=p_PRICING_ATTR_rec.pricing_attribute_context);
Line: 1442

     UPDATE qp_pte_segments set used_in_setup='Y'
     WHERE  nvl(used_in_setup,'N')='N'
     AND    segment_id IN
      (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b
       WHERE  a.segment_mapping_column=p_PRICING_ATTR_rec.product_attribute
       AND    a.prc_context_id=b.prc_context_id
       AND    b.prc_context_type='PRODUCT'
       AND    b.prc_context_code=p_PRICING_ATTR_rec.product_attribute_context);
Line: 1459

               p_request_type => QP_GLOBALS.G_UPDATE_PRICING_ATTR_PHASE,
			x_return_status => l_return_status);
Line: 1470

            ,   'Insert_Row'
            );
Line: 1476

END Insert_Row;
Line: 1480

PROCEDURE Delete_Row
(   p_pricing_attribute_id          IN  NUMBER
)
IS
BEGIN



    DELETE  FROM QP_PRICING_ATTRIBUTES
    WHERE   PRICING_ATTRIBUTE_ID = p_pricing_attribute_id
    ;
Line: 1501

            ,   'Delete_Row'
            );
Line: 1507

END Delete_Row;
Line: 1538

    SELECT  ACCUMULATE_FLAG
    ,       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       ATTRIBUTE_GROUPING_NO
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       EXCLUDER_FLAG
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       LIST_LINE_ID
    ,       LIST_HEADER_ID
    ,       PRICING_PHASE_ID
    ,       PRICING_ATTRIBUTE
    ,       PRICING_ATTRIBUTE_CONTEXT
    ,       PRICING_ATTRIBUTE_ID
    ,       PRICING_ATTR_VALUE_FROM
    ,       PRICING_ATTR_VALUE_TO
    ,       PRODUCT_ATTRIBUTE
    ,       PRODUCT_ATTRIBUTE_CONTEXT
    ,       PRODUCT_ATTR_VALUE
    ,       PRODUCT_UOM_CODE
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       REQUEST_ID
    ,       COMPARISON_OPERATOR_CODE
    ,       PRICING_ATTRIBUTE_DATATYPE
    ,       PRODUCT_ATTRIBUTE_DATATYPE
    ,       PRICING_ATTR_VALUE_FROM_NUMBER
    ,       PRICING_ATTR_VALUE_TO_NUMBER
    ,       QUALIFICATION_IND
    FROM    QP_PRICING_ATTRIBUTES
    WHERE ( PRICING_ATTRIBUTE_ID = p_pricing_attribute_id
    )
    OR (    LIST_LINE_ID = p_list_line_id
    );
Line: 1640

        l_PRICING_ATTR_rec.last_updated_by := l_implicit_rec.LAST_UPDATED_BY;
Line: 1641

        l_PRICING_ATTR_rec.last_update_date := l_implicit_rec.LAST_UPDATE_DATE;
Line: 1642

        l_PRICING_ATTR_rec.last_update_login := l_implicit_rec.LAST_UPDATE_LOGIN;
Line: 1657

        l_PRICING_ATTR_rec.program_update_date := l_implicit_rec.PROGRAM_UPDATE_DATE;
Line: 1721

    SELECT  ACCUMULATE_FLAG
    ,       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       ATTRIBUTE_GROUPING_NO
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       EXCLUDER_FLAG
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       LIST_LINE_ID
    ,       LIST_HEADER_ID
    ,       PRICING_PHASE_ID
    ,       PRICING_ATTRIBUTE
    ,       PRICING_ATTRIBUTE_CONTEXT
    ,       PRICING_ATTRIBUTE_ID
    ,       PRICING_ATTR_VALUE_FROM
    ,       PRICING_ATTR_VALUE_TO
    ,       PRODUCT_ATTRIBUTE
    ,       PRODUCT_ATTRIBUTE_CONTEXT
    ,       PRODUCT_ATTR_VALUE
    ,       PRODUCT_UOM_CODE
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       REQUEST_ID
    ,       COMPARISON_OPERATOR_CODE
    ,       PRICING_ATTRIBUTE_DATATYPE
    ,       PRODUCT_ATTRIBUTE_DATATYPE
    INTO    l_PRICING_ATTR_rec.accumulate_flag
    ,       l_PRICING_ATTR_rec.attribute1
    ,       l_PRICING_ATTR_rec.attribute10
    ,       l_PRICING_ATTR_rec.attribute11
    ,       l_PRICING_ATTR_rec.attribute12
    ,       l_PRICING_ATTR_rec.attribute13
    ,       l_PRICING_ATTR_rec.attribute14
    ,       l_PRICING_ATTR_rec.attribute15
    ,       l_PRICING_ATTR_rec.attribute2
    ,       l_PRICING_ATTR_rec.attribute3
    ,       l_PRICING_ATTR_rec.attribute4
    ,       l_PRICING_ATTR_rec.attribute5
    ,       l_PRICING_ATTR_rec.attribute6
    ,       l_PRICING_ATTR_rec.attribute7
    ,       l_PRICING_ATTR_rec.attribute8
    ,       l_PRICING_ATTR_rec.attribute9
    ,       l_PRICING_ATTR_rec.attribute_grouping_no
    ,       l_PRICING_ATTR_rec.context
    ,       l_PRICING_ATTR_rec.created_by
    ,       l_PRICING_ATTR_rec.creation_date
    ,       l_PRICING_ATTR_rec.excluder_flag
    ,       l_PRICING_ATTR_rec.last_updated_by
    ,       l_PRICING_ATTR_rec.last_update_date
    ,       l_PRICING_ATTR_rec.last_update_login
    ,       l_PRICING_ATTR_rec.list_line_id
    ,       l_PRICING_ATTR_rec.list_header_id
    ,       l_PRICING_ATTR_rec.pricing_phase_id
    ,       l_PRICING_ATTR_rec.pricing_attribute
    ,       l_PRICING_ATTR_rec.pricing_attribute_context
    ,       l_PRICING_ATTR_rec.pricing_attribute_id
    ,       l_PRICING_ATTR_rec.pricing_attr_value_from
    ,       l_PRICING_ATTR_rec.pricing_attr_value_to
    ,       l_PRICING_ATTR_rec.product_attribute
    ,       l_PRICING_ATTR_rec.product_attribute_context
    ,       l_PRICING_ATTR_rec.product_attr_value
    ,       l_PRICING_ATTR_rec.product_uom_code
    ,       l_PRICING_ATTR_rec.program_application_id
    ,       l_PRICING_ATTR_rec.program_id
    ,       l_PRICING_ATTR_rec.program_update_date
    ,       l_PRICING_ATTR_rec.request_id
    ,       l_PRICING_ATTR_rec.comparison_operator_code
    ,       l_PRICING_ATTR_rec.pricing_attribute_datatype
    ,       l_PRICING_ATTR_rec.product_attribute_datatype
    FROM    QP_PRICING_ATTRIBUTES
    WHERE   PRICING_ATTRIBUTE_ID = p_PRICING_ATTR_rec.pricing_attribute_id
        FOR UPDATE NOWAIT;
Line: 1937

            FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
Line: 2288

  IF ( p_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE)
  THEN
     IF ((p_old_PRICING_ATTR_rec.product_attribute  <> p_PRICING_ATTR_rec.product_attribute) OR
         (p_old_PRICING_ATTR_rec.product_attr_value <> p_PRICING_ATTR_rec.product_attr_value))
     THEN
       begin
          update qp_pricing_attributes
          set product_attribute = p_PRICING_ATTR_rec.product_attribute
          ,   product_attr_value = p_PRICING_ATTR_rec.product_attr_value
          where list_line_id = p_PRICING_ATTR_rec.list_line_id;
Line: 2306

          update qp_pricing_attributes
          set product_attribute = p_PRICING_ATTR_rec.product_attribute
          ,   product_attr_value = p_PRICING_ATTR_rec.product_attr_value
          where list_line_id = p_PRICING_ATTR_rec.list_line_id;
Line: 2317

  IF   ( p_PRICING_ATTR_rec.operation = OE_GLOBALS.G_OPR_DELETE) THEN

    oe_debug_pub.add('Logging a request to update qualification_ind  ', 1);
Line: 2325

                 p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
                 x_return_status => l_return_status);
Line: 2342

     IF (p_PRICING_ATTR_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
	    qp_delayed_requests_pvt.log_request(
		p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_entity_id => p_PRICING_ATTR_rec.list_header_id,
		p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
		p_request_unique_key2 => 'U',
		p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_requesting_entity_id => p_PRICING_ATTR_rec.list_header_id,
		p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,
		x_return_status => l_return_status);
Line: 2353

     IF (p_PRICING_ATTR_rec.operation = OE_GLOBALS.G_OPR_DELETE) THEN
	    qp_delayed_requests_pvt.log_request(
		p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_entity_id => p_PRICING_ATTR_rec.list_header_id,
		p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
		p_request_unique_key2 => 'D',
		p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_requesting_entity_id => p_PRICING_ATTR_rec.list_header_id,
		p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,
		x_return_status => l_return_status);