PACKAGE BODY: APPS.IRC_OFFER_EXTEND_METHOD_CHANGE

Source

1 PACKAGE BODY irc_offer_extend_method_change AS
2 /* $Header: irofrupg.pkb 120.1 2006/08/24 11:23:57 gaukumar noship $*/
3 
4 -- ----------------------------------------------------------------------------
5 -- |--------------------------< update_offer_extended_method >-----------------|
6 -- ----------------------------------------------------------------------------
7 procedure update_offer_extended_method(
8    p_process_ctrl   IN            varchar2,
9    p_start_pkid     IN            number,
10    p_end_pkid       IN            number,
11    p_rows_processed    OUT nocopy number)
12 is
13 --
14 begin
15   update irc_offers
16       set OFFER_EXTENDED_METHOD = fnd_profile.VALUE('IRC_OFFER_SEND_METHOD')
17       where OFFER_EXTENDED_METHOD is null;
18 
19   p_rows_processed := sql%rowcount;
20 end update_offer_extended_method;
21 end irc_offer_extend_method_change;