APPS.PV_PARTNER_ATTR_RT_INSERT_PVT SQL Statements

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

Line: 30

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

Line: 80

      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 ;

Line: 131

END partner_attr_insert;