APPS.FND_REGISTRATION_UTILS_PKG SQL Statements

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

Line: 13

    SELECT count(*)
    INTO   l_duplicates
    FROM   fnd_user
    WHERE  user_name = UPPER(p_username)
    AND    rownum = 1;

Line: 24

    SELECT count(*)
    INTO   l_duplicates
    FROM   fnd_registrations
    WHERE  requested_user_name = p_username
    AND    registration_status IN('REGISTERED')
    AND    rownum = 1;

Line: 50

    SELECT requested_user_name
    INTO   l_username
    FROM   fnd_registrations
    WHERE  registration_id = p_registration_id;

Line: 58

    SELECT count(*)
    INTO   l_duplicates
    FROM   fnd_user
    WHERE  user_name = UPPER(l_username)
    AND    rownum = 1;

Line: 69

    SELECT count(*)
    INTO   l_duplicates
    FROM   fnd_registrations
    WHERE  requested_user_name = l_username
    AND    registration_status <> 'REJECTED'
    AND    rownum = 1;

Line: 94

    SELECT count(*)
    INTO   l_duplicates
    FROM   fnd_user
    WHERE  user_name = UPPER(p_username)
    AND    rownum = 1;

Line: 105

    SELECT count(*)
    INTO   l_duplicates
    FROM   fnd_registrations
    WHERE  requested_user_name = p_username
    AND    registration_status IN('REGISTERED')
    AND    registration_id <> p_registration_id
    AND    rownum = 1;

Line: 141

  SELECT application_id, registration_type
  INTO   ln_application_id, lv_reg_type
  FROM   fnd_registrations
  WHERE  registration_id = p_registration_id;

Line: 170

  l_param_list.DELETE;

Line: 233

    SELECT registration_id
    INTO   l_registration_id
    FROM   fnd_registrations
    WHERE  registration_key = p_registration_key;

Line: 248

    SELECT  registration_key
    INTO    l_registration_key
    FROM    fnd_registrations
    WHERE   registration_id = p_registration_id;

Line: 299

    l_registration_id := fnd_registration_pkg.insert_reg(
         p_application_id,
         p_party_id,
         p_registration_type,
         p_requested_user_name,
         p_assigned_user_name,
         'INVITED',
         p_exists_in_fnd_user_flag,
         p_reg_details,
         p_user_title,
         p_first_name,
         p_middle_name,
         p_last_name,
         p_user_suffix,
         p_email_contact_point_id,
         p_email,
         p_phone_contact_point_id,
         p_phone_country_code,
         p_phone_area_code,
         p_phone,
         p_phone_extension,
         p_fax_contact_point_id,
         p_fax_country_code,
         p_fax_area_code,
         p_fax,
         p_fax_extension,
         p_language_code,
         p_time_zone,
         p_territory_code,
         p_location_id,
         p_address1,
         p_address2,
         p_city,
         p_state,
         p_province,
         p_zip,
         p_postal_code,
         p_country);

Line: 390

        l_registration_id := fnd_registration_pkg.insert_reg(
             p_application_id,
             p_party_id,
             p_registration_type,
             p_requested_user_name,
             p_assigned_user_name,
             'REGISTERED',
             p_exists_in_fnd_user_flag,
             p_reg_details,
             p_user_title,
             p_first_name,
             p_middle_name,
             p_last_name,
             p_user_suffix,
             p_email_contact_point_id,
             p_email,
             p_phone_contact_point_id,
             p_phone_country_code,
             p_phone_area_code,
             p_phone,
             p_phone_extension,
             p_fax_contact_point_id,
             p_fax_country_code,
             p_fax_area_code,
             p_fax,
             p_fax_extension,
             p_language_code,
             p_time_zone,
             p_territory_code,
             p_location_id,
             p_address1,
             p_address2,
             p_city,
             p_state,
             p_province,
             p_zip,
             p_postal_code,
             p_country);

Line: 431

        my_val2 := fnd_registration_pkg.insert_reg(
             p_application_id,
             p_party_id,
             p_registration_type,
             p_requested_user_name,
             p_assigned_user_name,                                                             'REGISTERED',
             p_exists_in_fnd_user_flag,
             p_reg_details,
             p_user_title,
             p_first_name,
             p_middle_name,
             p_last_name,
             p_user_suffix,
             p_email_contact_point_id,
             p_email,
             p_phone_contact_point_id,
             p_phone_country_code,
             p_phone_area_code,
             p_phone,
             p_phone_extension,
             p_fax_contact_point_id,
             p_fax_country_code,
             p_fax_area_code,
             p_fax,
             p_fax_extension,
             p_language_code,                                                                  p_time_zone,
             p_territory_code,
             p_location_id,
             p_address1,
             p_address2,
             p_city,
             p_state,
             p_province,
             p_zip,
             p_postal_code,
             p_country);

Line: 478

    fnd_registration_pkg.update_reg_status(p_registration_id, 'APPROVED');

Line: 488

    fnd_registration_pkg.update_reg_status(p_registration_id, 'REJECTED');