DBA Data[Home] [Help]

APPS.PER_KR_ADDRESS_UPDATE_HOOK_PKG SQL Statements

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

Line: 31

     update per_addresses
        set address_line1     = l_kr_address
     where person_id          = p_person_id
       and business_group_id  = p_business_group_id
       and  address_id        = p_address_id;
Line: 42

 end update_address_line1_ai;
Line: 44

 procedure update_address_line1_au(
           p_address_id           in number
          ,p_business_group_id_o  in number
          ,p_person_id_o          in number
          ,p_style_o              in varchar2
          ,p_add_information17    in varchar2)
 is

 begin

   update_address_line1_ai(p_address_id          => p_address_id
                          ,p_business_group_id   => p_business_group_id_o
                          ,p_person_id           => p_person_id_o
                          ,p_style               => p_style_o
                          ,p_add_information17   => p_add_information17);
Line: 60

 end update_address_line1_au;
Line: 62

end per_kr_address_update_hook_pkg;