APPS.ARP_CPROF1_PKG SQL Statements

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

Line: 36

         select credit_hold
         from   hz_customer_profiles
         where  CUST_ACCOUNT_ID =  p_customer_id
         and    site_use_id is null;

Line: 59

        select credit_hold
        from   hz_customer_profiles
        where  CUST_ACCOUNT_ID = p_customer_id
        and    site_use_id = p_site_use_id;

Line: 109

 PROCEDURE update_send_dunning_letters ( p_send_dunning_letters IN varchar2,
                                         p_customer_id          IN number,
                                         p_site_use_id          IN number
                                       ) is
  begin

    if p_site_use_id is not null then

    --
    -- UPDATE THE SITE LEVEL PROFILE
    --

      update hz_customer_profiles
      set    dunning_letters = p_send_dunning_letters
      where  CUST_ACCOUNT_ID = p_customer_id
      and    site_use_id     = p_site_use_id;

Line: 127

        update hz_customer_profiles
        set    dunning_letters = p_send_dunning_letters
        where  CUST_ACCOUNT_ID = p_customer_id
        and    site_use_id     is null;

Line: 139

      update hz_customer_profiles
      set    dunning_letters = p_send_dunning_letters
      where  CUST_ACCOUNT_ID = p_customer_id
      and    site_use_id     is null;

Line: 145

        app_exception.invalid_argument('arp_cprof_pkg.update_send_dunning_letters',
                                       'p_customer_id', p_customer_id);

Line: 152

  end update_send_dunning_letters;

Line: 158

FUNCTION update_credit_hold(p_customer_id IN number,
                            p_site_use_id IN number,
                            p_credit_hold IN varchar2) RETURN BOOLEAN AS

BEGIN
    if (p_site_use_id is null) then
        update hz_customer_profiles
           set credit_hold = p_credit_hold
         where CUST_ACCOUNT_ID= p_customer_id
           and site_use_id is null;

Line: 169

        update hz_customer_profiles
           set credit_hold = p_credit_hold
         where CUST_ACCOUNT_ID = p_customer_id
           and site_use_id = p_site_use_id;

Line: 181

END update_credit_hold;