APPS.QP_VALIDATE_QUALIFIERS SQL Statements

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

Line: 25

       SELECT 1 INTO l_count
       FROM DUAL
       WHERE EXISTS( SELECT qualifier_id
                     FROM qp_qualifiers
                     WHERE qualifier_rule_id = p_QUALIFIERS_rec.qualifier_rule_id
                       AND qualifier_grouping_no = p_QUALIFIERS_rec.qualifier_grouping_no
          	       AND qualifier_context = p_QUALIFIERS_rec.qualifier_context
		       AND qualifier_attribute = p_QUALIFIERS_rec.qualifier_attribute
		       AND qualifier_attr_value = p_QUALIFIERS_rec.qualifier_attr_value
		       AND COMPARISON_OPERATOR_CODE = p_QUALIFIERS_rec.comparison_operator_code
		       AND nvl(QUALIFIER_ATTR_VALUE_TO,FND_API.G_MISS_NUM) =
		                    nvl(p_QUALIFIERS_rec.qualifier_attr_value_to,FND_API.G_MISS_NUM)
		       AND qualifier_id <> p_QUALIFIERS_rec.qualifier_id );

Line: 39

      SELECT 1 INTO l_count
      FROM DUAL
      WHERE EXISTS ( SELECT qualifier_id
                     FROM qp_qualifiers
                     WHERE list_header_id = p_QUALIFIERS_rec.list_header_id
                        AND qualifier_grouping_no = p_QUALIFIERS_rec.qualifier_grouping_no
            	        AND qualifier_context = p_QUALIFIERS_rec.qualifier_context
                        AND qualifier_attribute =  p_QUALIFIERS_rec.qualifier_attribute
	                AND qualifier_attr_value = p_QUALIFIERS_rec.qualifier_attr_value
                        AND COMPARISON_OPERATOR_CODE = p_QUALIFIERS_rec.comparison_operator_code
                        AND nvl(QUALIFIER_ATTR_VALUE_TO,FND_API.G_MISS_NUM) =
			        nvl(p_QUALIFIERS_rec.qualifier_attr_value_to,FND_API.G_MISS_NUM)
                        AND qualifier_rule_id is null
	                AND list_line_id = p_QUALIFIERS_rec.list_line_id
	                AND qualifier_id <> p_QUALIFIERS_rec.qualifier_id );

Line: 86

         SELECT 'CHANGED'
	    FROM  QP_QUALIFIERS
	    WHERE  qualifier_rule_id     =    p_qualifier_rule_id
	    AND    qualifier_grouping_no =    p_qualifier_grouping_no
	    AND    start_date_active    <>   p_start_date
	    AND    qualifier_id         <>   p_qualifier_id;

Line: 126

         SELECT 'CHANGED'
	    FROM  QP_QUALIFIERS
	    WHERE  qualifier_rule_id     =    p_qualifier_rule_id
	    AND    qualifier_grouping_no =    p_qualifier_grouping_no
	    AND    end_date_active    <>   p_end_date
	    AND    qualifier_id <> p_qualifier_id;

Line: 484

         select list_type_code
	    into   l_list_type_code
	    from   qp_list_headers_b
	    where  list_header_id = p_QUALIFIERS_rec.list_header_id;

Line: 656

     /* SELECT  qualifier_id
      INTO    l_qualifier_id
	 FROM    QP_QUALIFIERS
      WHERE   qualifier_id = p_QUALIFIERS_rec.qualifier_id;

Line: 691

      SELECT  lookup_code
	 INTO    l_comparison_operator_code
	 FROM    QP_LOOKUPS
      WHERE   LOOKUP_TYPE = 'COMPARISON_OPERATOR'
	 AND     LOOKUP_CODE = UPPER(p_QUALIFIERS_rec.comparison_operator_code);

Line: 828

  	       select gsa_indicator
	       into   l_gsa_indicator
	       from   qp_list_headers_b
	       where  list_header_id = p_QUALIFIERS_rec.list_header_id;

Line: 837

  	          select decode(party.party_type,'ORGANIZATION',party.gsa_indicator_flag,'N')
	          into   l_customer_gsa_indicator
	          from   hz_cust_accounts cust_acct,hz_parties party
	          where  cust_acct.party_id = party.party_id and
                    cust_acct.cust_account_id = to_number(p_QUALIFIERS_rec.qualifier_attr_value);

Line: 962

             SELECT    qualifier_rule_id
	        INTO      l_qualifier_rule_id
	        FROM      QP_QUALIFIER_RULES
	        WHERE     qualifier_rule_id = p_QUALIFIERS_rec.qualifier_rule_id;

Line: 988

             SELECT    qualifier_rule_id
	        INTO      l_qualifier_rule_id
	        FROM      QP_QUALIFIER_RULES
	        WHERE     qualifier_rule_id = p_QUALIFIERS_rec.created_from_rule_id;

Line: 1013

             SELECT    list_header_id
	        INTO      l_list_header_id
	        FROM      QP_LIST_HEADERS_B
	        WHERE     list_header_id = p_QUALIFIERS_rec.list_header_id;

Line: 1038

             SELECT    list_line_id
	        INTO      l_list_line_id
	        FROM      QP_LIST_LINES
	        WHERE     list_line_id = p_QUALIFIERS_rec.list_line_id;

Line: 1071

select start_date_active, end_date_active , list_header_id
into l_start_date_active, l_end_date_active, l_list_header_id_1
from qp_list_lines
where list_line_id = p_qualifiers_rec.list_line_id;

Line: 1080

QP_delayed_requests_pvt.Delete_Request
(   p_entity_code => QP_GLOBALS.G_ENTITY_ALL
,   p_entity_id    =>  p_qualifiers_rec.list_line_id
,   p_request_Type =>  QP_GLOBALS.G_DUPLICATE_MODIFIER_LINES
,   x_return_status		=> l_return_status
);

Line: 1099

select count(*) into p_attr_count
from qp_pricing_attributes
where list_line_id = p_qualifiers_rec.list_line_id;

Line: 1130

 Select product_attribute_context, product_attribute, product_attr_value
 into p_product_attribute_context, p_product_attribute, p_product_attr_value
 from qp_pricing_attributes
 where list_line_id =  p_qualifiers_rec.list_line_id
 and rownum < 2;

Line: 1263

              select modifier_level_code
                into l_modifier_level_code
                from qp_list_lines
               where list_header_id = p_qualifiers_rec.list_header_id
                 and list_line_id = p_qualifiers_rec.list_line_id;

Line: 1442

    IF  p_QUALIFIERS_rec.last_updated_by IS NOT NULL AND
        (   p_QUALIFIERS_rec.last_updated_by <>
            p_old_QUALIFIERS_rec.last_updated_by OR
            p_old_QUALIFIERS_rec.last_updated_by IS NULL )
    THEN
        IF NOT QP_Validate.Last_Updated_By(p_QUALIFIERS_rec.last_updated_by) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;

Line: 1457

    IF  p_QUALIFIERS_rec.last_update_date IS NOT NULL AND
        (   p_QUALIFIERS_rec.last_update_date <>
            p_old_QUALIFIERS_rec.last_update_date OR
            p_old_QUALIFIERS_rec.last_update_date IS NULL )
    THEN
        IF NOT QP_Validate.Last_Update_Date(p_QUALIFIERS_rec.last_update_date) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;

Line: 1472

    IF  p_QUALIFIERS_rec.last_update_login IS NOT NULL AND
        (   p_QUALIFIERS_rec.last_update_login <>
            p_old_QUALIFIERS_rec.last_update_login OR
            p_old_QUALIFIERS_rec.last_update_login IS NULL )
    THEN
        IF NOT QP_Validate.Last_Update_Login(p_QUALIFIERS_rec.last_update_login) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;

Line: 1549

    IF  p_QUALIFIERS_rec.program_update_date IS NOT NULL AND
        (   p_QUALIFIERS_rec.program_update_date <>
            p_old_QUALIFIERS_rec.program_update_date OR
            p_old_QUALIFIERS_rec.program_update_date IS NULL )
    THEN
        IF NOT QP_Validate.Program_Update_Date(p_QUALIFIERS_rec.program_update_date) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;

Line: 1937

PROCEDURE Entity_Delete
(   x_return_status                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
,   p_QUALIFIERS_rec                IN  QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
)
IS
l_return_status               VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line: 1978

            ,   'Entity_Delete'
            );

Line: 1982

END Entity_Delete;