APPS.POR_R12_UPGRADE_PVT SQL Statements

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

Line: 24

    select profile_option_id
      into l_old_ovr_requester_profile_id
      from fnd_profile_options
     where profile_option_name = 'ICX_REQ_OVERRIDE_REQUESTOR_CODE';

Line: 29

    select profile_option_id
      into l_new_ovr_requester_profile_id
      from fnd_profile_options
     where profile_option_name = 'POR_OVERRIDE_REQUESTER';

Line: 34

    select profile_option_id
      into l_old_ovr_location_profile_id
      from fnd_profile_options
     where profile_option_name = 'ICX_REQ_OVERRIDE_LOCATION_FLAG';

Line: 39

    select profile_option_id
      into l_new_ovr_location_profile_id
      from fnd_profile_options
     where profile_option_name = 'POR_OVERRIDE_LOCATION';

Line: 44

    select profile_option_id
      into l_old_days_need_by_profile_id
      from fnd_profile_options
     where profile_option_name = 'ICX_DAYS_NEEDED_BY';

Line: 49

    select profile_option_id
      into l_new_days_need_by_profile_id
      from fnd_profile_options
     where profile_option_name = 'POR_DAYS_NEEDED_BY';

Line: 71

        update fnd_profile_option_values v1
           set v1.profile_option_id = decode(v1.profile_option_id,
                                             l_old_ovr_requester_profile_id,
                                             l_new_ovr_requester_profile_id,
                                             l_old_ovr_location_profile_id,
                                             l_new_ovr_location_profile_id,
                                             l_old_days_need_by_profile_id,
                                             l_new_days_need_by_profile_id, -1)
         where v1.profile_option_id in (l_old_ovr_requester_profile_id,
                                        l_old_ovr_location_profile_id,
                                        l_old_days_need_by_profile_id)
           and v1.level_id <> 10001
           and not exists (select 1
                             from fnd_profile_option_values v2
                            where v2.profile_option_id =
                                decode(v1.profile_option_id,
                                       l_old_ovr_requester_profile_id,
                                       l_new_ovr_requester_profile_id,
                                       l_old_ovr_location_profile_id,
                                       l_new_ovr_location_profile_id,
                                       l_old_days_need_by_profile_id,
                                       l_new_days_need_by_profile_id, -1)
                              and v2.level_id = v1.level_id
                              and v2.level_value = v1.level_value)
           and rownum <= l_batchsize;

Line: 107

    update fnd_profile_option_values p1
       set p1.profile_option_value =
           (select p2.profile_option_value
              from fnd_profile_option_values p2
             where p2.profile_option_id = decode(p1.profile_option_id,
                                             l_new_ovr_requester_profile_id,
                                             l_old_ovr_requester_profile_id,
                                             l_new_ovr_location_profile_id,
                                             l_old_ovr_location_profile_id,
                                             l_new_days_need_by_profile_id,
                                             l_old_days_need_by_profile_id, -1)
               and p2.level_id = 10001)
     where p1.profile_option_id in (l_new_ovr_requester_profile_id,
                                    l_new_ovr_location_profile_id,
                                    l_new_days_need_by_profile_id)
       and p1.level_id = 10001;