APPS.POS_USER_ADMIN_PKG SQL Statements

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

Line: 22

      SELECT * FROM fnd_user WHERE user_id = p_user_id;

Line: 45

   fnd_user_pkg.updateuser
     ( x_user_name                 => l_fnd_user_rec.user_name,
       x_owner                      => NULL,
       x_end_date                   => l_fnd_user_rec.end_date,
       x_password_date              => fnd_user_pkg.null_date,
       x_password_accesses_left     => l_fnd_user_rec.password_accesses_left,
       x_password_lifespan_accesses => l_fnd_user_rec.password_lifespan_accesses,
       x_password_lifespan_days     => l_fnd_user_rec.password_lifespan_days,
       x_email_address              => l_fnd_user_rec.email_address,
       x_fax                        => l_fnd_user_rec.fax,
       x_customer_id                => l_fnd_user_rec.customer_id
       );

Line: 70

      p_prefix        => 'call fnd_user_pkg.update_user',
      p_return_status => x_return_status,
      p_msg_count     => x_msg_count,
      p_msg_data      => x_msg_data
      );

Line: 120

	SELECT user_name FROM fnd_user WHERE user_id = p_user_id;

Line: 139

    select start_date, end_date
    into l_start_date,l_old_inactive_date
    from fnd_user
    where user_name = l_fnd_user_rec.user_name;

Line: 150

   fnd_user_pkg.updateuser
     ( x_user_name  => l_fnd_user_rec.user_name,
       x_owner      => NULL,
       x_end_date   => l_end_date
       );

Line: 211

   SELECT responsibility_id INTO l_resp_id
     FROM fnd_responsibility
    WHERE responsibility_key = p_resp_key
      AND application_id = p_resp_app_id;

Line: 270

        SELECT start_date FROM fnd_user_resp_groups
          WHERE user_id = p_user_id AND responsibility_id = p_resp_id;

Line: 329

procedure update_user_info
  ( p_party_id          IN  NUMBER
  , p_user_name_prefix  IN  VARCHAR2
  , p_user_name_f       IN  VARCHAR2
  , p_user_name_m       IN  VARCHAR2
  , p_user_name_l       IN  VARCHAR2
  , p_user_title        IN  VARCHAR2
  , p_user_email        IN  VARCHAR2
  , p_user_phone        IN  VARCHAR2
  , p_user_extension    IN  VARCHAR2
  , p_user_fax          IN  VARCHAR2
  , x_return_status     OUT NOCOPY VARCHAR2
  , x_msg_count         OUT NOCOPY NUMBER
  , x_msg_data          OUT NOCOPY VARCHAR2
  )
IS
  l_person_rec            hz_party_v2pub.person_rec_type;

Line: 349

     SELECT user_name
       FROM fnd_user
       WHERE person_party_id = p_party_id;

Line: 354

     SELECT object_version_number, last_update_date
       FROM hz_parties
      WHERE party_id = p_party_id;

Line: 389

   UPDATE hz_person_profiles
     SET effective_start_date=trunc(SYSDATE)
     WHERE party_id = p_party_id;

Line: 393

   hz_party_v2pub.update_person
     ( p_person_rec                  => l_person_rec,
       p_party_object_version_number => l_party_rec.object_version_number,
       x_profile_id                  => l_profile_id,
       x_return_status               => x_return_status,
       x_msg_count                   => x_msg_count,
       x_msg_data                    => x_msg_data
       );

Line: 404

      p_prefix        => 'call hz_party_v2pub.update_person.update_person',
      p_return_status => x_return_status,
      p_msg_count     => x_msg_count,
      p_msg_data      => x_msg_data
      );

Line: 414

   pos_hz_contact_point_pkg.update_party_phone
     ( p_party_id          => p_party_id,
       p_country_code      => NULL,
       p_area_code         => NULL,
       p_number            => p_user_phone,
       p_extension         => p_user_extension,
       x_return_status     => x_return_status,
       x_msg_count         => x_msg_count,
       x_msg_data          => x_msg_data
     );

Line: 429

   pos_hz_contact_point_pkg.update_party_fax
     ( p_party_id          => p_party_id,
       p_country_code      => NULL,
       p_area_code         => NULL,
       p_number            => p_user_fax,
       p_extension         => NULL,
       x_return_status     => x_return_status,
       x_msg_count         => x_msg_count,
       x_msg_data          => x_msg_data
     );

Line: 445

      pos_hz_contact_point_pkg.update_party_email
       ( p_party_id          => p_party_id,
         p_email             => p_user_email,
         x_return_status     => x_return_status,
         x_msg_count         => x_msg_count,
         x_msg_data          => x_msg_data
       );

Line: 461

     fnd_user_pkg.updateuser
       ( x_user_name     => l_user_rec.user_name,
         x_owner         => NULL,
         x_email_address => p_user_email,
         x_customer_id   => p_party_id
         );

Line: 473

       pos_log.log_sqlerrm('POSADMB', 'in update_user_info');

Line: 474

       raise_application_error(-20002,'POSADMB:UPDATE_USER_INFO: Caught an exception', true);

Line: 475

END update_user_info;

Line: 503

       p_last_updated_by    => fnd_global.user_id,
       p_last_update_date   => Sysdate,
       p_last_update_login  => fnd_global.login_id
       );

Line: 534

PROCEDURE deletesecattr
  ( p_user_id        IN NUMBER
  , p_attribute_code IN VARCHAR2
  , p_app_id         IN NUMBER
  , p_varchar2_value IN VARCHAR2 DEFAULT NULL
  , p_date_value     IN DATE DEFAULT NULL
  , p_number_value   IN NUMBER DEFAULT NULL
  )
IS
   l_return_status VARCHAR2(1);

Line: 547

   icx_user_sec_attr_pvt.delete_user_sec_attr
     ( p_api_version_number => 1.0,
       p_return_status      => l_return_status,
       p_msg_count          => l_msg_count,
       p_msg_data           => l_msg_data,
       p_web_user_id        => p_user_id,
       p_attribute_code     => p_attribute_code,
       p_attribute_appl_id  => p_app_id,
       p_varchar2_value     => p_varchar2_value,
       p_date_value         => p_date_value,
       p_number_value       => p_number_value
       );

Line: 562

      p_prefix        => 'call icx_user_sec_attr_pvt.delete_user_sec_attr ',
      p_return_status => l_return_status,
      p_msg_count     => l_msg_count,
      p_msg_data      => l_msg_data
      );

Line: 574

                              ,'POSADMB.deletesecattr '
                              || ' return status ' || l_return_status
                              || ' msg count ' || l_msg_count
                              || ' msg data ' || l_msg_data
                              );

Line: 582

      pos_log.log_sqlerrm('POSADMB','in deletesecattr');

Line: 584

END deletesecattr;

Line: 660

procedure update_user_info
  ( p_party_id          IN  NUMBER
  , p_user_name_prefix  IN  VARCHAR2
  , p_user_name_f       IN  VARCHAR2
  , p_user_name_m       IN  VARCHAR2
  , p_user_name_l       IN  VARCHAR2
  , p_user_title        IN  VARCHAR2
  , p_user_email        IN  VARCHAR2
  , p_user_phone        IN  VARCHAR2
  , p_user_extension    IN  VARCHAR2
  , p_user_fax          IN  VARCHAR2
  , x_status            OUT NOCOPY VARCHAR2
  , x_exception_msg     OUT NOCOPY VARCHAR2
  )
IS
   l_return_status   VARCHAR2(1);

Line: 679

   update_user_info
      (p_party_id           => p_party_id,
       p_user_name_prefix   => p_user_name_prefix,
       p_user_name_f        => p_user_name_f,
       p_user_name_m        => p_user_name_m,
       p_user_name_l        => p_user_name_l,
       p_user_title         => p_user_title,
       p_user_email         => p_user_email,
       p_user_phone         => p_user_phone,
       p_user_extension     => p_user_extension,
       p_user_fax           => p_user_fax,
       x_return_status      => l_return_status,
       x_msg_count          => l_msg_count,
       x_msg_data           => l_msg_data
      );

Line: 705

END update_user_info;

Line: 729

         SELECT party_type, status
           FROM hz_parties
          WHERE party_id = p_person_party_id;

Line: 738

         SELECT user_id
           FROM fnd_user
          WHERE user_name = p_user_name;

Line: 859

   fnd_user_pkg.updateuserparty
    (x_user_name        => p_user_name,
     x_owner            => NULL,
     x_person_party_id  => p_person_party_id
     );

Line: 924

        SELECT email_address
          FROM fnd_user
         WHERE user_id = fnd_global.user_id;

Line: 1151

	 SELECT application_id INTO l_resp_app_id
	   FROM fnd_application WHERE application_short_name = 'PON';

Line: 1187

 select count(*)
 from pos_spmntf_subscription
 where user_id = p_user_id and
 event_type = 'SUPP_BUS_CLASS_RECERT_NTF';

Line: 1204

 insert into pos_spmntf_subscription
 (subscription_id,
  created_by,
  creation_date,
  last_updated_by,
  last_update_date,
  last_update_login,
  event_type,
  user_id)
 values
 (POS_SPMNTF_SUBSCRIPTION_S.nextval,
  fnd_global.user_id,
  sysdate,
  fnd_global.user_id,
  sysdate,
  fnd_global.login_id,
  'SUPP_BUS_CLASS_RECERT_NTF',
  p_user_id);

Line: 1241

 select count(*)
 from pos_spmntf_subscription
 where user_id = p_user_id and
 event_type = 'SUPP_BUS_CLASS_RECERT_NTF';

Line: 1258

    delete from pos_spmntf_subscription
    where event_type = 'SUPP_BUS_CLASS_RECERT_NTF'
      and user_id = p_user_id;

Line: 1279

    select 'Y'
    into x_subscr_exists
    from pos_spmntf_subscription
    where event_type = 'SUPP_BUS_CLASS_RECERT_NTF'
      and user_id = p_user_id;