APPS.IRC_OFFER_EXTEND_METHOD_CHANGE SQL Statements

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

Line: 7

procedure update_offer_extended_method(
   p_process_ctrl   IN            varchar2,
   p_start_pkid     IN            number,
   p_end_pkid       IN            number,
   p_rows_processed    OUT nocopy number)
is
--
begin
  update irc_offers
      set OFFER_EXTENDED_METHOD = fnd_profile.VALUE('IRC_OFFER_SEND_METHOD')
      where OFFER_EXTENDED_METHOD is null;

Line: 20

end update_offer_extended_method;