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: 701

         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: 727

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

Line: 848

    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: 852

    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: 856

    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: 920

    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: 1045

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

Line: 1049

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

Line: 1053

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

Line: 1113

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

Line: 1143

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: 1155

SELECT ACTIVE_FLAG
       INTO   l_active_flag
       FROM   QP_LIST_HEADERS_ALL_B
       WHERE  LIST_HEADER_ID = p_PRICING_ATTR_rec.list_header_id;

Line: 1160

oe_debug_pub.add('BEGIN Update_Row in QPXUPRAB');

Line: 1189

    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: 1246

     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: 1260

     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: 1280

            ,   'Update_Row'
            );

Line: 1286

END Update_Row;

Line: 1290

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

Line: 1303

oe_debug_pub.add('BEGIN Update_Row in QPXUPRAB');

Line: 1304

SELECT ACTIVE_FLAG
       INTO   l_active_flag
       FROM   QP_LIST_HEADERS_ALL_B
       WHERE  LIST_HEADER_ID = p_PRICING_ATTR_rec.list_header_id;

Line: 1333

    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_ALL_B h where h.list_header_id=p_PRICING_ATTR_rec.list_header_id)
    );

Line: 1443

     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: 1458

     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: 1475

               p_request_type => QP_GLOBALS.G_UPDATE_PRICING_ATTR_PHASE,
			x_return_status => l_return_status);

Line: 1486

            ,   'Insert_Row'
            );

Line: 1492

END Insert_Row;

Line: 1496

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: 1517

            ,   'Delete_Row'
            );

Line: 1523

END Delete_Row;

Line: 1554

    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: 1656

        l_PRICING_ATTR_rec.last_updated_by := l_implicit_rec.LAST_UPDATED_BY;

Line: 1657

        l_PRICING_ATTR_rec.last_update_date := l_implicit_rec.LAST_UPDATE_DATE;

Line: 1658

        l_PRICING_ATTR_rec.last_update_login := l_implicit_rec.LAST_UPDATE_LOGIN;

Line: 1673

        l_PRICING_ATTR_rec.program_update_date := l_implicit_rec.PROGRAM_UPDATE_DATE;

Line: 1737

    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: 1957

	oe_debug_pub.ADD('last_updated_by		:'||l_PRICING_ATTR_rec.last_updated_by||':'||p_PRICING_ATTR_rec.last_updated_by||':');

Line: 1958

	oe_debug_pub.ADD('last_update_date		:'||l_PRICING_ATTR_rec.last_update_date||':'||p_PRICING_ATTR_rec.last_update_date||':');

Line: 1959

	oe_debug_pub.ADD('last_update_login		:'||l_PRICING_ATTR_rec.last_update_login||':'||p_PRICING_ATTR_rec.last_update_login||':');

Line: 1974

	oe_debug_pub.ADD('program_update_date		:'||l_PRICING_ATTR_rec.program_update_date||':'||p_PRICING_ATTR_rec.program_update_date||':');

Line: 2003

            FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');

Line: 2354

  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: 2372

          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: 2383

  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: 2391

                 p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
                 x_return_status => l_return_status);

Line: 2408

     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: 2419

     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);

Line: 2447

     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: 2458

     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);