APPS.ARH_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: 108

 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: 126

        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: 138

      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: 144

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

Line: 151

  end update_send_dunning_letters;

Line: 157

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: 168

        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: 180

END update_credit_hold;