The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE partner_attr_insert (
P_Api_Version_Number IN NUMBER,
P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
P_Commit IN VARCHAR2 := FND_API.G_FALSE,
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
p_partner_id IN NUMBER,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'partner_attr_insert';
INSERT INTO pv_search_attr_values
SELECT pv_search_attr_values_s.nextval
, partner_id
, null
, attr_text
, SYSDATE
, FND_GLOBAL.user_id
, SYSDATE
, FND_GLOBAL.user_id
, 1.0
, FND_GLOBAL.user_id
, null
, attribute_id
, null
from (
SELECT 19 attribute_id, attr_code attr_text, pp.partner_id partner_id
FROM pv_partner_profiles pp,
pv_attribute_codes_vl pac
WHERE pp.partner_level=to_char(pac.attr_code_id)
AND pp.partner_id = :1
AND pac.enabled_flag = ''Y''
UNION all
SELECT distinct 4 attribute_id, hl.country attr_text, pvpp.partner_id partner_id
FROM hz_locations hl,
hz_party_sites hs,
pv_partner_profiles pvpp
WHERE hl.location_id = hs.location_id
AND hs.party_id = pvpp.partner_party_id
AND pvpp.partner_id = :1
AND (hs.status = ''A'' OR hs.status IS NULL)
UNION all
SELECT 11 attribute_id,
hzp.party_name attr_text,
pvpp.partner_id partner_id
FROM pv_partner_profiles pvpp, hz_parties hzp
WHERE partner_id=:1
AND hzp.party_id = pvpp.partner_party_id
UNION all
SELECT 3 attribute_id,pear.attr_value attr_text, pear.entity_id partner_id
FROM pv_enty_attr_values pear
WHERE pear.entity_id = :1
AND pear.latest_flag = ''Y''
AND attr_value is not null
AND attribute_id = 3 )' USING p_partner_id,p_partner_id,p_partner_id,p_partner_id ;
END partner_attr_insert;