APPS.PER_DELETE_UNWANTED_SEC_PROF SQL Statements

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

Line: 13

      SELECT  psp.security_profile_id
      FROM    per_security_profiles psp
      WHERE   psp.security_profile_name = p_security_profile_name;

Line: 18

    l_proc := 'per_delete_unwanted_sec_prof.concurrent_process';

Line: 23

    l_strong_delete := 'Y';

Line: 51

        del_all_unwanted_sec_prof (l_strong_delete);

Line: 80

            del_sec_prof (l_strong_delete
                         ,l_security_profile_id);

Line: 88

                              ,'Hence not deleted');

Line: 110

      SELECT  security_profile_id
             ,security_profile_name
      FROM    per_security_profiles
      WHERE   reporting_oracle_username IS NULL
      AND     view_all_flag <> 'Y';

Line: 117

      SELECT  responsibility_id
      FROM    per_sec_profile_assignments
      WHERE   security_profile_id = p_security_profile_id;

Line: 122

      SELECT  'Y'
      FROM    fnd_responsibility
      WHERE   responsibility_id = p_responsibility_id
      AND     sysdate BETWEEN start_date
                      AND     nvl (end_date
                                  ,hr_general.end_of_time);

Line: 130

      SELECT  'Y'
      FROM    fnd_user
      WHERE   user_id = p_user_id
      AND     sysdate BETWEEN start_date
                      AND     nvl (end_date
                                  ,hr_general.end_of_time);

Line: 138

      SELECT  level_value
      FROM    fnd_profile_option_values
      WHERE   profile_option_id =
              (
              SELECT  profile_option_id
              FROM    fnd_profile_options
              WHERE   profile_option_name = 'PER_SECURITY_PROFILE_ID'
              )
      AND     level_id = '10003'
      AND     profile_option_value = to_char (p_security_profile_id);

Line: 150

      SELECT  level_value
      FROM    fnd_profile_option_values
      WHERE   profile_option_id =
              (
              SELECT  profile_option_id
              FROM    fnd_profile_options
              WHERE   profile_option_name = 'PER_SECURITY_PROFILE_ID'
              )
      AND     level_id = '10004'
      AND     profile_option_value = to_char (p_security_profile_id);

Line: 162

      SELECT  'Y'
      FROM    fnd_profile_option_values
      WHERE   profile_option_id =
              (
              SELECT  profile_option_id
              FROM    fnd_profile_options
              WHERE   profile_option_name = 'PER_SECURITY_PROFILE_ID'
              )
      AND     level_id = '10001'
      AND     profile_option_value = to_char (p_security_profile_id);

Line: 174

      SELECT  level_value
      FROM    fnd_profile_option_values
      WHERE   profile_option_id =
              (
              SELECT  profile_option_id
              FROM    fnd_profile_options
              WHERE   profile_option_name = 'XLA_MO_SECURITY_PROFILE_LEVEL'
              )
      AND     level_id = '10003'
      AND     profile_option_value = to_char (p_security_profile_id);

Line: 186

      SELECT  'Y'
      FROM    fnd_profile_option_values
      WHERE   profile_option_id =
              (
              SELECT  profile_option_id
              FROM    fnd_profile_options
              WHERE   profile_option_name = 'XLA_MO_SECURITY_PROFILE_LEVEL'
              )
      AND     level_id = '10001'
      AND     profile_option_value = to_char (p_security_profile_id);

Line: 203

    l_proc := 'per_delete_unwanted_sec_prof.show_unwanted_sec_prof';

Line: 330

    (p_strong_delete       IN varchar2
    ,p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS
    CURSOR c_security_profile
      (l_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS
      SELECT  rowid
             ,security_profile_id
             ,view_all_flag
      FROM    per_security_profiles
      WHERE   security_profile_id = l_security_profile_id;

Line: 342

    l_proc := 'per_delete_unwanted_sec_prof.del_sec_prof';

Line: 359

      IF p_strong_delete <> 'Y' THEN
        hr_utility.set_location (l_proc
                                ,30);

Line: 363

        per_security_profiles_pkg.pre_delete_validation (csr_security_profile.security_profile_id
                                                        ,csr_security_profile.view_all_flag
                                                        ,l_secgen_warn);

Line: 385

        strong_delete_sec_prof (p_security_profile_id);

Line: 394

      per_security_profiles_pkg.delete_row (csr_security_profile.rowid);

Line: 404

  PROCEDURE strong_delete_sec_prof
    (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS
    l_security_profile_id per_security_profiles.security_profile_id%TYPE;

Line: 409

    l_proc := 'per_delete_unwanted_sec_prof.strong_delete_sec_prof';

Line: 417

      DELETE
      FROM    per_person_list
      WHERE   security_profile_id = l_security_profile_id;

Line: 429

      DELETE
      FROM    pay_payroll_list
      WHERE   security_profile_id = l_security_profile_id;

Line: 441

      DELETE
      FROM    per_organization_list
      WHERE   security_profile_id = l_security_profile_id;

Line: 453

      DELETE
      FROM    per_position_list
      WHERE   security_profile_id = l_security_profile_id;

Line: 465

      DELETE
      FROM    per_assignment_list
      WHERE   security_profile_id = l_security_profile_id;

Line: 477

      DELETE
      FROM    per_security_users
      WHERE   security_profile_id = l_security_profile_id;

Line: 489

      DELETE
      FROM    pay_security_payrolls
      WHERE   security_profile_id = l_security_profile_id;

Line: 501

      DELETE
      FROM    per_security_organizations
      WHERE   security_profile_id = l_security_profile_id;

Line: 513

      DELETE
      FROM    per_person_list_changes
      WHERE   security_profile_id = l_security_profile_id;

Line: 525

      DELETE
      FROM    per_sec_profile_assignments
      WHERE   security_profile_id = l_security_profile_id;

Line: 537

      UPDATE  fnd_profile_option_values
      SET     profile_option_value = NULL
      WHERE   profile_option_id =
              (
              SELECT  profile_option_id
              FROM    fnd_profile_options
              WHERE   profile_option_name = 'PER_SECURITY_PROFILE_ID'
              )
      AND     profile_option_value = to_char (l_security_profile_id);

Line: 553

  END strong_delete_sec_prof;

Line: 556

    (p_strong_delete IN varchar2) IS
    CURSOR c_security_profile IS
      SELECT  security_profile_id
             ,security_profile_name
      FROM    per_security_profiles
      WHERE   reporting_oracle_username IS NULL
      AND     view_all_flag <> 'Y';

Line: 565

      SELECT  responsibility_id
      FROM    per_sec_profile_assignments
      WHERE   security_profile_id = p_security_profile_id;

Line: 570

      SELECT  'Y'
      FROM    fnd_responsibility
      WHERE   responsibility_id = p_responsibility_id
      AND     sysdate BETWEEN start_date
                      AND     nvl (end_date
                                  ,hr_general.end_of_time);

Line: 578

      SELECT  'Y'
      FROM    fnd_user
      WHERE   user_id = p_user_id
      AND     sysdate BETWEEN start_date
                      AND     nvl (end_date
                                  ,hr_general.end_of_time);

Line: 586

      SELECT  level_value
      FROM    fnd_profile_option_values
      WHERE   profile_option_id =
              (
              SELECT  profile_option_id
              FROM    fnd_profile_options
              WHERE   profile_option_name = 'PER_SECURITY_PROFILE_ID'
              )
      AND     level_id = '10003'
      AND     profile_option_value = to_char (p_security_profile_id);

Line: 598

      SELECT  level_value
      FROM    fnd_profile_option_values
      WHERE   profile_option_id =
              (
              SELECT  profile_option_id
              FROM    fnd_profile_options
              WHERE   profile_option_name = 'PER_SECURITY_PROFILE_ID'
              )
      AND     level_id = '10004'
      AND     profile_option_value = to_char (p_security_profile_id);

Line: 610

      SELECT  'Y'
      FROM    fnd_profile_option_values
      WHERE   profile_option_id =
              (
              SELECT  profile_option_id
              FROM    fnd_profile_options
              WHERE   profile_option_name = 'PER_SECURITY_PROFILE_ID'
              )
      AND     level_id = '10001'
      AND     profile_option_value = to_char (p_security_profile_id);

Line: 622

      SELECT  level_value
      FROM    fnd_profile_option_values
      WHERE   profile_option_id =
              (
              SELECT  profile_option_id
              FROM    fnd_profile_options
              WHERE   profile_option_name = 'XLA_MO_SECURITY_PROFILE_LEVEL'
              )
      AND     level_id = '10003'
      AND     profile_option_value = to_char (p_security_profile_id);

Line: 634

      SELECT  'Y'
      FROM    fnd_profile_option_values
      WHERE   profile_option_id =
              (
              SELECT  profile_option_id
              FROM    fnd_profile_options
              WHERE   profile_option_name = 'XLA_MO_SECURITY_PROFILE_LEVEL'
              )
      AND     level_id = '10001'
      AND     profile_option_value = to_char (p_security_profile_id);

Line: 651

    l_proc := 'per_delete_unwanted_sec_prof.strong_delete_sec_prof';

Line: 766

        del_sec_prof (p_strong_delete
                     ,csr_security_profile.security_profile_id);

Line: 774

                      ,'All unused Security Profiles Deleted');

Line: 786

      SELECT  security_profile_id
      FROM    per_security_profiles
      WHERE   reporting_oracle_username IS NULL
      AND     view_all_flag <> 'Y'
      AND     security_profile_id = p_security_profile_id;

Line: 793

      SELECT  responsibility_id
      FROM    per_sec_profile_assignments
      WHERE   security_profile_id = p_security_profile_id;

Line: 798

      SELECT  'Y'
      FROM    fnd_responsibility
      WHERE   responsibility_id = p_responsibility_id
      AND     sysdate BETWEEN start_date
                      AND     nvl (end_date
                                  ,hr_general.end_of_time);

Line: 806

      SELECT  'Y'
      FROM    fnd_user
      WHERE   user_id = p_user_id
      AND     sysdate BETWEEN start_date
                      AND     nvl (end_date
                                  ,hr_general.end_of_time);

Line: 814

      SELECT  level_value
      FROM    fnd_profile_option_values
      WHERE   profile_option_id =
              (
              SELECT  profile_option_id
              FROM    fnd_profile_options
              WHERE   profile_option_name = 'PER_SECURITY_PROFILE_ID'
              )
      AND     level_id = '10003'
      AND     profile_option_value = to_char (p_security_profile_id);

Line: 826

      SELECT  level_value
      FROM    fnd_profile_option_values
      WHERE   profile_option_id =
              (
              SELECT  profile_option_id
              FROM    fnd_profile_options
              WHERE   profile_option_name = 'PER_SECURITY_PROFILE_ID'
              )
      AND     level_id = '10004'
      AND     profile_option_value = to_char (p_security_profile_id);

Line: 838

      SELECT  'Y'
      FROM    fnd_profile_option_values
      WHERE   profile_option_id =
              (
              SELECT  profile_option_id
              FROM    fnd_profile_options
              WHERE   profile_option_name = 'PER_SECURITY_PROFILE_ID'
              )
      AND     level_id = '10001'
      AND     profile_option_value = to_char (p_security_profile_id);

Line: 850

      SELECT  level_value
      FROM    fnd_profile_option_values
      WHERE   profile_option_id =
              (
              SELECT  profile_option_id
              FROM    fnd_profile_options
              WHERE   profile_option_name = 'XLA_MO_SECURITY_PROFILE_LEVEL'
              )
      AND     level_id = '10003'
      AND     profile_option_value = to_char (p_security_profile_id);

Line: 862

      SELECT  'Y'
      FROM    fnd_profile_option_values
      WHERE   profile_option_id =
              (
              SELECT  profile_option_id
              FROM    fnd_profile_options
              WHERE   profile_option_name = 'XLA_MO_SECURITY_PROFILE_LEVEL'
              )
      AND     level_id = '10001'
      AND     profile_option_value = to_char (p_security_profile_id);

Line: 878

    l_proc := 'per_delete_unwanted_sec_prof.check_unwanted_sec_prof';