The following lines contain the word 'select', 'insert', 'update' or 'delete':
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;
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;
select list_type_code
into l_list_type_code
from qp_list_headers_b
where list_header_id = p_QUALIFIERS_rec.list_header_id;
/* SELECT qualifier_id
INTO l_qualifier_id
FROM QP_QUALIFIERS
WHERE qualifier_id = p_QUALIFIERS_rec.qualifier_id;
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);
select gsa_indicator
into l_gsa_indicator
from qp_list_headers_b
where list_header_id = p_QUALIFIERS_rec.list_header_id;
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);
SELECT qualifier_rule_id
INTO l_qualifier_rule_id
FROM QP_QUALIFIER_RULES
WHERE qualifier_rule_id = p_QUALIFIERS_rec.qualifier_rule_id;
SELECT qualifier_rule_id
INTO l_qualifier_rule_id
FROM QP_QUALIFIER_RULES
WHERE qualifier_rule_id = p_QUALIFIERS_rec.created_from_rule_id;
SELECT list_header_id
INTO l_list_header_id
FROM QP_LIST_HEADERS_B
WHERE list_header_id = p_QUALIFIERS_rec.list_header_id;
SELECT list_line_id
INTO l_list_line_id
FROM QP_LIST_LINES
WHERE list_line_id = p_QUALIFIERS_rec.list_line_id;
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;
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
);
select count(*) into p_attr_count
from qp_pricing_attributes
where list_line_id = p_qualifiers_rec.list_line_id;
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;
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;
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;
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;
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;
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;
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;
, 'Entity_Delete'
);
END Entity_Delete;