DBA Data[Home] [Help]

APPS.QP_PRICE_LIST_UTIL SQL Statements

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

Line: 182

        IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_updated_by,p_old_PRICE_LIST_rec.last_updated_by)
        THEN
            l_index := l_index + 1;
Line: 185

            l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_LAST_UPDATED_BY;
Line: 188

        IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_date,p_old_PRICE_LIST_rec.last_update_date)
        THEN
            l_index := l_index + 1;
Line: 191

            l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_LAST_UPDATE_DATE;
Line: 194

        IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_login,p_old_PRICE_LIST_rec.last_update_login)
        THEN
            l_index := l_index + 1;
Line: 197

            l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_LAST_UPDATE_LOGIN;
Line: 277

        IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_update_date,p_old_PRICE_LIST_rec.program_update_date)
        THEN
            l_index := l_index + 1;
Line: 280

            l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_PROGRAM_UPDATE_DATE;
Line: 443

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

        l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_LAST_UPDATED_BY;
Line: 446

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

        l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_LAST_UPDATE_DATE;
Line: 449

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

        l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_LAST_UPDATE_LOGIN;
Line: 470

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

        l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_PROGRAM_UPDATE_DATE;
Line: 637

	  IF(p_PRICE_LIST_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_PRICE_LIST_rec.list_header_id,
		p_request_unique_key1 => NULL,
		p_request_unique_key2 => 'UD',
		p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_requesting_entity_id => p_PRICE_LIST_rec.list_header_id,
		p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
		x_return_status => x_PRICE_LIST_rec.return_status);
Line: 653

         IF(p_PRICE_LIST_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_PRICE_LIST_rec.list_header_id,
		p_request_unique_key1 => NULL,
		p_request_unique_key2 => 'UD',
		p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_requesting_entity_id => p_PRICE_LIST_rec.list_header_id,
		p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
		x_return_status => x_PRICE_LIST_rec.return_status);
Line: 680

         IF (p_PRICE_LIST_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_PRICE_LIST_rec.list_header_id,
		p_request_unique_key1 => NULL,
		p_request_unique_key2 => 'UD',
		p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_requesting_entity_id => p_PRICE_LIST_rec.list_header_id,
		p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
		x_return_status => x_PRICE_LIST_rec.return_status);
Line: 701

          IF (p_PRICE_LIST_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_PRICE_LIST_rec.list_header_id,
		p_request_unique_key1 => NULL,
		p_request_unique_key2 => 'UD',
		p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_requesting_entity_id => p_PRICE_LIST_rec.list_header_id,
		p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
		x_return_status => x_PRICE_LIST_rec.return_status);
Line: 717

         IF (p_PRICE_LIST_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_PRICE_LIST_rec.list_header_id,
		p_request_unique_key1 => NULL,
		p_request_unique_key2 => 'UD',
		p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_requesting_entity_id => p_PRICE_LIST_rec.list_header_id,
		p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
		x_return_status => x_PRICE_LIST_rec.return_status);
Line: 733

   IF p_PRICE_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE
   THEN

        UPDATE qp_qualifiers
          SET active_flag = p_PRICE_LIST_rec.active_flag
         WHERE list_header_id = p_PRICE_LIST_rec.list_header_id;
Line: 743

	update qp_pte_segments d set used_in_setup='Y'
	where nvl(used_in_setup,'N')='N'
	and exists
	(select 'x'
	from qp_segments_b a,qp_prc_contexts_b b,qp_qualifiers c
	where c.list_header_id         = p_PRICE_LIST_rec.list_header_id
	and   a.segment_mapping_column = c .qualifier_attribute
        and   a.segment_id             = d.segment_id
	and   a.prc_context_id         = b.prc_context_id
	and   b.prc_context_type       = 'QUALIFIER'
	and   b.prc_context_code       = c.qualifier_context);
Line: 755

	update qp_pte_segments d set used_in_setup='Y'
	where nvl(used_in_setup,'N')='N'
	and exists
	(select 'x'
	from qp_segments_b a,qp_prc_contexts_b b,qp_pricing_attributes c
	where c.list_header_id         = p_PRICE_LIST_rec.list_header_id
	and   a.segment_mapping_column = c.pricing_attribute
        and   a.segment_id             = d.segment_id
	and   a.prc_context_id         = b.prc_context_id
	and   b.prc_context_type       = 'PRICING_ATTRIBUTE'
	and   b.prc_context_code       = c.pricing_attribute_context);
Line: 767

	update qp_pte_segments d set used_in_setup='Y'
	where nvl(used_in_setup,'N')='N'
	and exists
	(select 'x'
	from qp_segments_b a,qp_prc_contexts_b b,qp_pricing_attributes c
	where c.list_header_id         = p_PRICE_LIST_rec.list_header_id
	and   a.segment_mapping_column = c.product_attribute
        and   a.segment_id             = d.segment_id
	and   a.prc_context_id         = b.prc_context_id
	and   b.prc_context_type       = 'PRODUCT'
	and   b.prc_context_code       = c.product_attribute_context);
Line: 797

         IF (p_PRICE_LIST_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_PRICE_LIST_rec.list_header_id,
		p_request_unique_key1 => NULL,
		p_request_unique_key2 => 'UD',
		p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_requesting_entity_id => p_PRICE_LIST_rec.list_header_id,
		p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
		x_return_status => x_PRICE_LIST_rec.return_status);
Line: 822

              select BASE_ROUNDING_FACTOR
                into x_PRICE_LIST_rec.rounding_factor
                from QP_CURRENCY_LISTS_VL
               where currency_header_id = p_PRICE_LIST_rec.currency_header_id;
Line: 830

         IF (p_PRICE_LIST_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_PRICE_LIST_rec.list_header_id,
		p_request_unique_key1 => NULL,
		p_request_unique_key2 => 'UD',
		p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_requesting_entity_id => p_PRICE_LIST_rec.list_header_id,
		p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
		x_return_status => x_PRICE_LIST_rec.return_status);
Line: 862

    IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_updated_by,p_old_PRICE_LIST_rec.last_updated_by)
    THEN
        NULL;
Line: 867

    IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_date,p_old_PRICE_LIST_rec.last_update_date)
    THEN
        NULL;
Line: 872

    IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_login,p_old_PRICE_LIST_rec.last_update_login)
    THEN
        NULL;
Line: 899

	  IF(p_PRICE_LIST_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_PRICE_LIST_rec.list_header_id,
		p_request_unique_key1 => NULL,
		p_request_unique_key2 => 'UD',
		p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_requesting_entity_id => p_PRICE_LIST_rec.list_header_id,
		p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
		x_return_status => x_PRICE_LIST_rec.return_status);
Line: 915

         IF(p_PRICE_LIST_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_PRICE_LIST_rec.list_header_id,
		p_request_unique_key1 => NULL,
		p_request_unique_key2 => 'UD',
		p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_requesting_entity_id => p_PRICE_LIST_rec.list_header_id,
		p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
		x_return_status => x_PRICE_LIST_rec.return_status);
Line: 947

    IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_update_date,p_old_PRICE_LIST_rec.program_update_date)
    THEN
        NULL;
Line: 985

         IF (p_PRICE_LIST_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_PRICE_LIST_rec.list_header_id,
		p_request_unique_key1 => NULL,
		p_request_unique_key2 => 'UD',
		p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_requesting_entity_id => p_PRICE_LIST_rec.list_header_id,
		p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
		x_return_status => x_PRICE_LIST_rec.return_status);
Line: 1022

	  IF( p_PRICE_LIST_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_PRICE_LIST_rec.list_header_id,
		p_request_unique_key1 => NULL,
		p_request_unique_key2 => 'UD',
		p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_requesting_entity_id => p_PRICE_LIST_rec.list_header_id,
		p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
		x_return_status => x_PRICE_LIST_rec.return_status);
Line: 1038

         IF( p_PRICE_LIST_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_PRICE_LIST_rec.list_header_id,
		p_request_unique_key1 => NULL,
		p_request_unique_key2 => 'UD',
		p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_requesting_entity_id => p_PRICE_LIST_rec.list_header_id,
		p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
		x_return_status => x_PRICE_LIST_rec.return_status);
Line: 1187

    IF l_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN
        l_PRICE_LIST_rec.last_updated_by := p_old_PRICE_LIST_rec.last_updated_by;
Line: 1191

    IF l_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN
        l_PRICE_LIST_rec.last_update_date := p_old_PRICE_LIST_rec.last_update_date;
Line: 1195

    IF l_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN
        l_PRICE_LIST_rec.last_update_login := p_old_PRICE_LIST_rec.last_update_login;
Line: 1228

    IF l_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN
        l_PRICE_LIST_rec.program_update_date := p_old_PRICE_LIST_rec.program_update_date;
Line: 1424

    IF l_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN
        l_PRICE_LIST_rec.last_updated_by := NULL;
Line: 1428

    IF l_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN
        l_PRICE_LIST_rec.last_update_date := NULL;
Line: 1432

    IF l_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN
        l_PRICE_LIST_rec.last_update_login := NULL;
Line: 1456

    IF l_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN
        l_PRICE_LIST_rec.program_update_date := NULL;
Line: 1502

PROCEDURE Update_Row
(   p_PRICE_LIST_rec                IN  QP_Price_List_PUB.Price_List_Rec_Type
)
IS
l_price_list_exists number := 0;
Line: 1509

  IF QP_security.check_function( p_function_name => QP_Security.G_FUNCTION_UPDATE,
                                 p_instance_type => QP_Security.G_PRICELIST_OBJECT,
                                 p_instance_pk1  => p_PRICE_LIST_rec.list_header_id) <> 'F' THEN

    --for moac changes QP_LIST_HEADERS_B to all_b to enable updates to PL with orig_org_id
    --that do not belong to the responsibility when the user has update privilges
    UPDATE  QP_LIST_HEADERS_ALL_B
    SET     ATTRIBUTE1                     = p_PRICE_LIST_rec.attribute1
    ,       ATTRIBUTE10                    = p_PRICE_LIST_rec.attribute10
    ,       ATTRIBUTE11                    = p_PRICE_LIST_rec.attribute11
    ,       ATTRIBUTE12                    = p_PRICE_LIST_rec.attribute12
    ,       ATTRIBUTE13                    = p_PRICE_LIST_rec.attribute13
    ,       ATTRIBUTE14                    = p_PRICE_LIST_rec.attribute14
    ,       ATTRIBUTE15                    = p_PRICE_LIST_rec.attribute15
    ,       ATTRIBUTE2                     = p_PRICE_LIST_rec.attribute2
    ,       ATTRIBUTE3                     = p_PRICE_LIST_rec.attribute3
    ,       ATTRIBUTE4                     = p_PRICE_LIST_rec.attribute4
    ,       ATTRIBUTE5                     = p_PRICE_LIST_rec.attribute5
    ,       ATTRIBUTE6                     = p_PRICE_LIST_rec.attribute6
    ,       ATTRIBUTE7                     = p_PRICE_LIST_rec.attribute7
    ,       ATTRIBUTE8                     = p_PRICE_LIST_rec.attribute8
    ,       ATTRIBUTE9                     = p_PRICE_LIST_rec.attribute9
    ,       AUTOMATIC_FLAG                 = p_PRICE_LIST_rec.automatic_flag
    ,       COMMENTS                       = p_PRICE_LIST_rec.comments
    ,       CONTEXT                        = p_PRICE_LIST_rec.context
    ,       CREATED_BY                     = p_PRICE_LIST_rec.created_by
    ,       CREATION_DATE                  = p_PRICE_LIST_rec.creation_date
    ,       CURRENCY_CODE                  = p_PRICE_LIST_rec.currency_code
    ,       DISCOUNT_LINES_FLAG            = p_PRICE_LIST_rec.discount_lines_flag
    ,       END_DATE_ACTIVE                = trunc(p_PRICE_LIST_rec.end_date_active)
    ,       FREIGHT_TERMS_CODE             = p_PRICE_LIST_rec.freight_terms_code
    ,       GSA_INDICATOR                  = p_PRICE_LIST_rec.gsa_indicator
    ,       LAST_UPDATED_BY                = p_PRICE_LIST_rec.last_updated_by
    ,       LAST_UPDATE_DATE               = p_PRICE_LIST_rec.last_update_date
    ,       LAST_UPDATE_LOGIN              = p_PRICE_LIST_rec.last_update_login
    ,       LIST_HEADER_ID                 = p_PRICE_LIST_rec.list_header_id
    ,       LIST_TYPE_CODE                 = p_PRICE_LIST_rec.list_type_code
    ,       PROGRAM_APPLICATION_ID         = p_PRICE_LIST_rec.program_application_id
    ,       PROGRAM_ID                     = p_PRICE_LIST_rec.program_id
    ,       PROGRAM_UPDATE_DATE            = p_PRICE_LIST_rec.program_update_date
    ,       PRORATE_FLAG                   = p_PRICE_LIST_rec.prorate_flag
    ,       REQUEST_ID                     = p_PRICE_LIST_rec.request_id
    ,       ROUNDING_FACTOR                = p_PRICE_LIST_rec.rounding_factor
    ,       SHIP_METHOD_CODE               = p_PRICE_LIST_rec.ship_method_code
    ,       START_DATE_ACTIVE              = trunc(p_PRICE_LIST_rec.start_date_active)
    ,       TERMS_ID                       = p_PRICE_LIST_rec.terms_id
    ,       ASK_FOR_FLAG                   = 'N'
    ,       ACTIVE_FLAG                    =
                            decode(p_PRICE_LIST_rec.active_flag, FND_API.G_MISS_CHAR, ACTIVE_FLAG, --dhgupta for 2052900
				    p_PRICE_LIST_rec.active_flag)
    ,       MOBILE_DOWNLOAD                =
                          decode(p_PRICE_LIST_rec.mobile_download, FND_API.G_MISS_CHAR, MOBILE_DOWNLOAD,--dhgupta for 2052900
				    p_PRICE_LIST_rec.mobile_download) -- mkarya for bug 1944882
    ,       CURRENCY_HEADER_ID             = p_PRICE_LIST_rec.currency_header_id
    ,       PTE_CODE             = p_PRICE_LIST_rec.pte_code  -- Giri for Attributes Manager
    ,	    LIST_SOURCE_CODE     = p_PRICE_LIST_rec.list_source_code --Blanket Sales Order
    , 	    ORIG_SYSTEM_HEADER_REF = p_PRICE_LIST_rec.orig_system_header_ref --Blanket Sales Order
    ,       GLOBAL_FLAG                    =
                          decode(p_PRICE_LIST_rec.global_flag, FND_API.G_MISS_CHAR, GLOBAL_FLAG,
				    p_PRICE_LIST_rec.global_flag) -- Pricing Security gtippire
    ,       SOURCE_SYSTEM_CODE     = p_PRICE_LIST_rec.source_system_code
    ,       SHAREABLE_FLAG         = p_PRICE_LIST_rec.shareable_flag
    ,       SOLD_TO_ORG_ID         = p_PRICE_LIST_rec.sold_to_org_id
    ,       LOCKED_FROM_LIST_HEADER_ID =
                 p_PRICE_LIST_rec.locked_from_list_header_id --Pricelist locking
            --added for MOAC
    ,       ORIG_ORG_ID   = p_PRICE_LIST_rec.org_id
    WHERE   LIST_HEADER_ID = p_PRICE_LIST_rec.list_header_id
    ;
Line: 1579

    update QP_LIST_HEADERS_TL set
      NAME = p_PRICE_LIST_rec.name,
      DESCRIPTION = p_PRICE_LIST_rec.description,
      LAST_UPDATE_DATE = p_PRICE_LIST_rec.LAST_UPDATE_DATE,
      LAST_UPDATED_BY = p_PRICE_LIST_rec.LAST_UPDATED_BY,
      LAST_UPDATE_LOGIN = p_PRICE_LIST_rec.LAST_UPDATE_LOGIN,
      VERSION_NO = p_PRICE_LIST_rec.version_no,
      SOURCE_LANG = userenv('LANG')
      where LIST_HEADER_ID = p_PRICE_LIST_rec.LIST_HEADER_ID
        and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
Line: 1604

            ,   'Update_Row'
            );
Line: 1610

END Update_Row;
Line: 1614

PROCEDURE Insert_Row
(   p_PRICE_LIST_rec                IN  QP_Price_List_PUB.Price_List_Rec_Type
)
IS

--l_source_system_code  varchar2(30);
Line: 1633

    INSERT  INTO QP_LIST_HEADERS_B
    (       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       AUTOMATIC_FLAG
    ,       COMMENTS
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       CURRENCY_CODE
    ,       DISCOUNT_LINES_FLAG
    ,       END_DATE_ACTIVE
    ,       FREIGHT_TERMS_CODE
    ,       GSA_INDICATOR
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       LIST_HEADER_ID
    ,       LIST_TYPE_CODE
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       PRORATE_FLAG
    ,       REQUEST_ID
    ,       ROUNDING_FACTOR
    ,       SHIP_METHOD_CODE
    ,       START_DATE_ACTIVE
    ,       TERMS_ID
    ,       ASK_FOR_FLAG
    ,       SOURCE_SYSTEM_CODE
    ,       ACTIVE_FLAG
    ,       MOBILE_DOWNLOAD -- mkarya for bug 1944882
    ,       CURRENCY_HEADER_ID -- Multi-Currency SunilPandey
    ,       PTE_CODE -- Attributes Manager Giri
    ,	    LIST_SOURCE_CODE --Blanket Sales Order
    , 	    ORIG_SYSTEM_HEADER_REF --Blanket Sales Order
    , 	    GLOBAL_FLAG --Pricing Security gtippire
    ,       ORIG_ORG_ID -- Pricing Security sfiresto
    ,       SHAREABLE_FLAG
    ,       SOLD_TO_ORG_ID
    ,       LOCKED_FROM_LIST_HEADER_ID
    )
    VALUES
    (       p_PRICE_LIST_rec.attribute1
    ,       p_PRICE_LIST_rec.attribute10
    ,       p_PRICE_LIST_rec.attribute11
    ,       p_PRICE_LIST_rec.attribute12
    ,       p_PRICE_LIST_rec.attribute13
    ,       p_PRICE_LIST_rec.attribute14
    ,       p_PRICE_LIST_rec.attribute15
    ,       p_PRICE_LIST_rec.attribute2
    ,       p_PRICE_LIST_rec.attribute3
    ,       p_PRICE_LIST_rec.attribute4
    ,       p_PRICE_LIST_rec.attribute5
    ,       p_PRICE_LIST_rec.attribute6
    ,       p_PRICE_LIST_rec.attribute7
    ,       p_PRICE_LIST_rec.attribute8
    ,       p_PRICE_LIST_rec.attribute9
    ,       p_PRICE_LIST_rec.automatic_flag
    ,       p_PRICE_LIST_rec.comments
    ,       p_PRICE_LIST_rec.context
    ,       p_PRICE_LIST_rec.created_by
    ,       p_PRICE_LIST_rec.creation_date
    ,       p_PRICE_LIST_rec.currency_code
    ,       p_PRICE_LIST_rec.discount_lines_flag
    ,       trunc(p_PRICE_LIST_rec.end_date_active)
    ,       p_PRICE_LIST_rec.freight_terms_code
    ,       p_PRICE_LIST_rec.gsa_indicator
    ,       p_PRICE_LIST_rec.last_updated_by
    ,       p_PRICE_LIST_rec.last_update_date
    ,       p_PRICE_LIST_rec.last_update_login
    ,       p_PRICE_LIST_rec.list_header_id
    ,       p_PRICE_LIST_rec.list_type_code
    ,       p_PRICE_LIST_rec.program_application_id
    ,       p_PRICE_LIST_rec.program_id
    ,       p_PRICE_LIST_rec.program_update_date
    ,       p_PRICE_LIST_rec.prorate_flag
    ,       p_PRICE_LIST_rec.request_id
    ,       p_PRICE_LIST_rec.rounding_factor
    ,       p_PRICE_LIST_rec.ship_method_code
    ,       trunc(p_PRICE_LIST_rec.start_date_active)
    ,       p_PRICE_LIST_rec.terms_id
    ,       'N' /* ask_for_flag */
--    ,       l_source_system_code
    ,       p_PRICE_LIST_rec.source_system_code
    ,       decode(p_PRICE_LIST_rec.active_flag, FND_API.G_MISS_CHAR, 'Y',
			    p_PRICE_LIST_rec.active_flag)
    ,       decode(p_PRICE_LIST_rec.mobile_download, FND_API.G_MISS_CHAR, 'N',
			    p_PRICE_LIST_rec.mobile_download) -- mkarya for bug 1944882
    ,       p_PRICE_LIST_rec.currency_header_id
    ,       p_PRICE_LIST_rec.pte_code  -- Giri for Attributes Manager
    ,	    p_PRICE_LIST_rec.list_source_code -- Blanket Sales Order
            --ENH Upgrade BOAPI for orig_sys...ref RAVI
    ,	    nvl(p_PRICE_LIST_rec.orig_system_header_ref,QP_PRICE_LIST_UTIL.Get_Orig_Sys_Hdr(p_PRICE_LIST_rec.list_header_id)) -- Blanket Sales Order
    ,       decode(p_PRICE_LIST_rec.global_flag, FND_API.G_MISS_CHAR, 'N',
			    p_PRICE_LIST_rec.global_flag) -- Pricing Security gtippire
            --added for MOAC
    ,       p_PRICE_LIST_rec.org_id
    ,       p_PRICE_LIST_rec.shareable_flag
    ,       p_PRICE_LIST_rec.sold_to_org_id
    ,       p_PRICE_LIST_rec.locked_from_list_header_id
    );
Line: 1748

    insert into QP_LIST_HEADERS_TL (
    LAST_UPDATE_LOGIN,
    NAME,
    DESCRIPTION,
    VERSION_NO,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LIST_HEADER_ID,
    LANGUAGE,
    SOURCE_LANG
  ) select
    p_PRICE_LIST_rec.LAST_UPDATE_LOGIN,
    p_PRICE_LIST_rec.NAME,
    p_PRICE_LIST_rec.DESCRIPTION,
    p_PRICE_LIST_rec.version_no,
    p_PRICE_LIST_rec.CREATION_DATE,
    p_PRICE_LIST_rec.CREATED_BY,
    p_PRICE_LIST_rec.LAST_UPDATE_DATE,
    p_PRICE_LIST_rec.LAST_UPDATED_BY,
    p_PRICE_LIST_rec.LIST_HEADER_ID,
    L.LANGUAGE_CODE,
    userenv('LANG')
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from QP_LIST_HEADERS_TL T
    where T.LIST_HEADER_ID = p_PRICE_LIST_rec.LIST_HEADER_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);
Line: 1798

            ,   'Insert_Row'
            );
Line: 1804

END Insert_Row;
Line: 1808

PROCEDURE Delete_Row
(   p_list_header_id                IN  NUMBER
)
IS
cursor lines is
select list_line_id
from qp_list_lines
where list_header_id = p_list_header_id;
Line: 1821

    QP_PRICE_LIST_LINE_UTIL.DELETE_ROW(lines_rec.list_line_id);
Line: 1825

  /* delete all qualifiers which refer to this list_header_id */

  delete from qp_qualifiers
  where list_header_id = p_list_header_id
  or ( qualifier_attr_value = to_char(p_list_header_id)
	  and qualifier_context = 'MODLIST'
	  and qualifier_attribute = 'QUALIFIER_ATTRIBUTE4' );
Line: 1834

  delete from QP_LIST_HEADERS_TL
  where LIST_HEADER_ID = p_list_header_id;
Line: 1843

    DELETE  FROM QP_LIST_HEADERS_B
    WHERE   LIST_HEADER_ID = p_list_header_id;
Line: 1856

            ,   'Delete_Row'
            );
Line: 1862

END Delete_Row;
Line: 1873

    SELECT  ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       AUTOMATIC_FLAG
    ,       COMMENTS
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       CURRENCY_CODE
    ,       DISCOUNT_LINES_FLAG
    ,       END_DATE_ACTIVE
    ,       FREIGHT_TERMS_CODE
    ,       GSA_INDICATOR
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       LIST_HEADER_ID
    ,       LIST_TYPE_CODE
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       PRORATE_FLAG
    ,       REQUEST_ID
    ,       ROUNDING_FACTOR
    ,       SHIP_METHOD_CODE
    ,       START_DATE_ACTIVE
    ,       TERMS_ID
    ,       ACTIVE_FLAG
    ,       MOBILE_DOWNLOAD --mkarya for bug 1944882
    ,       CURRENCY_HEADER_ID --Multi-Currency SunilPandey
    ,       PTE_CODE --Attributes Manager Giri
    ,	    LIST_SOURCE_CODE --Blanket Sales Order
    ,	    ORIG_SYSTEM_HEADER_REF --Blanket Sales Order
    ,	    GLOBAL_FLAG --Pricing Security gtippire
    ,       SOURCE_SYSTEM_CODE
    ,       SHAREABLE_FLAG
    ,       SOLD_TO_ORG_ID
    ,       LOCKED_FROM_LIST_HEADER_ID
            --added for MOAC
    ,       ORIG_ORG_ID
    INTO    l_PRICE_LIST_rec.attribute1
    ,       l_PRICE_LIST_rec.attribute10
    ,       l_PRICE_LIST_rec.attribute11
    ,       l_PRICE_LIST_rec.attribute12
    ,       l_PRICE_LIST_rec.attribute13
    ,       l_PRICE_LIST_rec.attribute14
    ,       l_PRICE_LIST_rec.attribute15
    ,       l_PRICE_LIST_rec.attribute2
    ,       l_PRICE_LIST_rec.attribute3
    ,       l_PRICE_LIST_rec.attribute4
    ,       l_PRICE_LIST_rec.attribute5
    ,       l_PRICE_LIST_rec.attribute6
    ,       l_PRICE_LIST_rec.attribute7
    ,       l_PRICE_LIST_rec.attribute8
    ,       l_PRICE_LIST_rec.attribute9
    ,       l_PRICE_LIST_rec.automatic_flag
    ,       l_PRICE_LIST_rec.comments
    ,       l_PRICE_LIST_rec.context
    ,       l_PRICE_LIST_rec.created_by
    ,       l_PRICE_LIST_rec.creation_date
    ,       l_PRICE_LIST_rec.currency_code
    ,       l_PRICE_LIST_rec.discount_lines_flag
    ,       l_PRICE_LIST_rec.end_date_active
    ,       l_PRICE_LIST_rec.freight_terms_code
    ,       l_PRICE_LIST_rec.gsa_indicator
    ,       l_PRICE_LIST_rec.last_updated_by
    ,       l_PRICE_LIST_rec.last_update_date
    ,       l_PRICE_LIST_rec.last_update_login
    ,       l_PRICE_LIST_rec.list_header_id
    ,       l_PRICE_LIST_rec.list_type_code
    ,       l_PRICE_LIST_rec.program_application_id
    ,       l_PRICE_LIST_rec.program_id
    ,       l_PRICE_LIST_rec.program_update_date
    ,       l_PRICE_LIST_rec.prorate_flag
    ,       l_PRICE_LIST_rec.request_id
    ,       l_PRICE_LIST_rec.rounding_factor
    ,       l_PRICE_LIST_rec.ship_method_code
    ,       l_PRICE_LIST_rec.start_date_active
    ,       l_PRICE_LIST_rec.terms_id
    ,       l_PRICE_LIST_rec.active_flag
    ,       l_PRICE_LIST_rec.mobile_download -- mkarya for bug 1944882
    ,       l_PRICE_LIST_rec.currency_header_id -- Multi-Currency SunilPandey
    ,       l_PRICE_LIST_rec.pte_code -- Attributes Manager Giri
    ,	    l_PRICE_LIST_rec.list_source_code -- Blanket Sales Order
    ,       l_PRICE_LIST_rec.orig_system_header_ref -- Blanket Sales Order
    ,       l_PRICE_LIST_rec.global_flag -- Pricing Security gtippire
    ,       l_PRICE_LIST_rec.source_system_code
    ,       l_PRICE_LIST_rec.shareable_flag
    ,       l_PRICE_LIST_rec.sold_to_org_id
    ,       l_PRICE_LIST_rec.locked_from_list_header_id
            --added for MOAC
    ,       l_PRICE_LIST_rec.org_id
    FROM    QP_LIST_HEADERS_B
    WHERE   LIST_HEADER_ID = p_list_header_id
    ;
Line: 1981

    SELECT NAME
    ,      DESCRIPTION
    ,      VERSION_NO
    INTO   l_PRICE_LIST_rec.name
    ,      l_PRICE_LIST_rec.description
    ,      l_PRICE_LIST_rec.version_no
    FROM   QP_LIST_HEADERS_TL
    WHERE  LIST_HEADER_ID = p_list_header_id
    AND    LANGUAGE = userenv('LANG');
Line: 2019

cursor c1 is select
      NAME,
      DESCRIPTION,
	 VERSION_NO,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from QP_LIST_HEADERS_TL
    where LIST_HEADER_ID = p_PRICE_LIST_rec.LIST_HEADER_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of LIST_HEADER_ID nowait;
Line: 2032

    SELECT  ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       AUTOMATIC_FLAG
    ,       COMMENTS
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       CURRENCY_CODE
    ,       DISCOUNT_LINES_FLAG
    ,       END_DATE_ACTIVE
    ,       FREIGHT_TERMS_CODE
    ,       GSA_INDICATOR
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       LIST_HEADER_ID
    ,       LIST_TYPE_CODE
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       PRORATE_FLAG
    ,       REQUEST_ID
    ,       ROUNDING_FACTOR
    ,       SHIP_METHOD_CODE
    ,       START_DATE_ACTIVE
    ,       TERMS_ID
    ,       ACTIVE_FLAG  -- Added by dhgupta for bug 2144903
    ,       MOBILE_DOWNLOAD  -- Added by dhgupta for bug 2144903
    ,       CURRENCY_HEADER_ID  --Multi-Currency Change SunilPandey; new change
Line: 2109

    ,       l_PRICE_LIST_rec.last_updated_by
    ,       l_PRICE_LIST_rec.last_update_date
    ,       l_PRICE_LIST_rec.last_update_login
    ,       l_PRICE_LIST_rec.list_header_id
    ,       l_PRICE_LIST_rec.list_type_code
    ,       l_PRICE_LIST_rec.program_application_id
    ,       l_PRICE_LIST_rec.program_id
    ,       l_PRICE_LIST_rec.program_update_date
    ,       l_PRICE_LIST_rec.prorate_flag
    ,       l_PRICE_LIST_rec.request_id
    ,       l_PRICE_LIST_rec.rounding_factor
    ,       l_PRICE_LIST_rec.ship_method_code
    ,       l_PRICE_LIST_rec.start_date_active
    ,       l_PRICE_LIST_rec.terms_id
    ,       l_PRICE_LIST_rec.active_flag  -- Added by dhgupta for bug 2144903
    ,       l_PRICE_LIST_rec.mobile_download -- Added by dhgupta for bug 2144903
    ,       l_PRICE_LIST_rec.currency_header_id --Multi-Currency Change SunilPandey; new change
Line: 2140

        FOR UPDATE NOWAIT;
Line: 2194

    AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_updated_by,
                         l_PRICE_LIST_rec.last_updated_by)
    AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_date,
                         l_PRICE_LIST_rec.last_update_date)
    AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_login,
                         l_PRICE_LIST_rec.last_update_login)
    AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_header_id,
                         l_PRICE_LIST_rec.list_header_id)
    AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_type_code,
                         l_PRICE_LIST_rec.list_type_code)
    AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_application_id,
                         l_PRICE_LIST_rec.program_application_id)
    AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_id,
                         l_PRICE_LIST_rec.program_id)
    AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_update_date,
                         l_PRICE_LIST_rec.program_update_date)
    AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.prorate_flag,
                         l_PRICE_LIST_rec.prorate_flag)
    AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.request_id,
                         l_PRICE_LIST_rec.request_id)
    AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.rounding_factor,
                         l_PRICE_LIST_rec.rounding_factor)
    AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.ship_method_code,
                         l_PRICE_LIST_rec.ship_method_code)
    AND QP_GLOBALS.Equal(to_date(to_char(p_PRICE_LIST_rec.start_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'),
                         to_date(to_char(l_PRICE_LIST_rec.start_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'))
    AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.terms_id,
                         l_PRICE_LIST_rec.terms_id)
    AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.active_flag,    -- Added by dhgupta for bug 2144903
                         l_PRICE_LIST_rec.active_flag)
    AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.mobile_download,  -- Added by dhgupta for bug 2144903
                         l_PRICE_LIST_rec.mobile_download)
    -- Multi-Currency Change SunilPandey
    AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.currency_header_id,
                         l_PRICE_LIST_rec.currency_header_id)
    -- Blanket Sales Order
    AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_source_code,
                         l_PRICE_LIST_rec.list_source_code)
    -- Bug # 5128941
    --AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.orig_system_header_ref,
    --                     l_PRICE_LIST_rec.orig_system_header_ref)
    AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.global_flag,  -- Pricing Security gtippire
                         l_PRICE_LIST_rec.global_flag)
    -- Blanket Pricing
    AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.source_system_code,
                         l_PRICE_LIST_rec.source_system_code)
    AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.shareable_flag,
                         l_PRICE_LIST_rec.shareable_flag)
    AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.sold_to_org_id,
	                 l_PRICE_LIST_rec.sold_to_org_id)
    AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.locked_from_list_header_id,
	                 l_PRICE_LIST_rec.locked_from_list_header_id)
    --added for MOAC
    AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.org_id,
                         l_PRICE_LIST_rec.org_id)
    THEN

        --  Row has not changed. Set out parameter.

        x_PRICE_LIST_rec               := l_PRICE_LIST_rec;
Line: 2384

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

    Select COUNT(*) into l_exist
    from qp_list_headers_b h
    where h.orig_system_header_ref=to_char(p_LIST_HEADER_ID);