APPS.MSC_PROFILE_PRE_PROCESS SQL Statements

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

Line: 30

  select profile_option_name,profile_option_value,level_type,level_name,application_name from msc_profiles where    preference_set_name=p_preference_set_name;

Line: 59

  SELECT user_id into usr_id from fnd_user where user_name=cur_rec.level_name;

Line: 72

  SELECT application_id into appl_id from fnd_application where application_short_name=cur_rec.application_name;

Line: 76

  SELECT responsibility_id into resp_id from fnd_responsibility_vl where responsibility_name=cur_rec.level_name and    application_id=appl_id;

Line: 88

  select application_id into appl_id from fnd_application where application_short_name=cur_rec.level_name;

Line: 136

 SELECT
  preference_set_name,
  level_type,
  level_name,
  profile_option_name,
  profile_option_value,
  application_name,
  process_flag
FROM  MSC_ST_PROFILES
WHERE preference_set_name = p_preference_set_name
  AND process_flag=1;

Line: 153

  UPDATE MSC_ST_PROFILES msp1
        SET PROCESS_FLAG = 3
        WHERE EXISTS (select 1 from msc_st_profiles msp2
                      where msp2.preference_set_name=msp1.preference_set_name
                      and   nvl(msp2.level_name,'-27323')=nvl(msp1.level_name,'-27323')
                      and   nvl(msp2.level_type,'-27323')=nvl(msp1.level_type,'-27323')
                      and   msp2.profile_option_name = msp1.profile_option_name
                      and   nvl(msp2.application_name,'-27323') = nvl(msp1.application_name,'-27323')
                      and   msp2.rowid <> msp1.rowid
                      and   msp2.process_flag=1
                      )
         AND PROCESS_FLAG = 1
         AND PREFERENCE_SET_NAME = p_preference_set_name;

Line: 170

  DELETE FROM MSC_PROFILES
    WHERE PREFERENCE_SET_NAME = p_preference_set_name ;

Line: 176

 /* UPDATE MSC_PROFILES SET
           PROFILE_OPTION_VALUE = c_rec.PROFILE_OPTION_VALUE
         WHERE PREFERENCE_SET_NAME = c_rec.PREFERENCE_SET_NAME
                AND nvl(level_name,'-27323') = nvl(c_rec.level_name,'-27323')
                AND nvl(level_type,'-27323') = nvl(c_rec.level_type,'-27323')
                AND PROFILE_OPTION_NAME = c_rec.PROFILE_OPTION_NAME
                AND nvl(APPLICATION_NAME,'-27323') = nvl(c_rec.APPLICATION_NAME,'-27323')
                AND c_rec.PROCESS_FLAG=1;

Line: 188

 insert into msc_profiles
 (
  PREFERENCE_SET_NAME,
  LEVEL_TYPE,
  LEVEL_NAME,
  PROFILE_OPTION_NAME,
  PROFILE_OPTION_VALUE,
  APPLICATION_NAME,
  LAST_UPDATE_DATE,
  LAST_UPDATED_BY,
  CREATION_DATE,
  CREATED_BY,
  LAST_UPDATE_LOGIN
  )
 values
 (
  c_rec.PREFERENCE_SET_NAME,
  c_rec.LEVEL_TYPE,
  c_rec.LEVEL_NAME,
  c_rec.PROFILE_OPTION_NAME,
  c_rec.PROFILE_OPTION_VALUE,
  c_rec.APPLICATION_NAME,
  SYSDATE,
  v_current_user,
  SYSDATE,
  v_current_user,
  v_current_user
  );

Line: 219

 UPDATE msc_st_profiles set process_flag = 5
    WHERE PREFERENCE_SET_NAME =  c_rec.PREFERENCE_SET_NAME
      AND nvl(LEVEL_NAME,'-27223') = nvl(c_rec.LEVEL_NAME,'-27223')
      AND nvl(level_type,'-27323') = nvl(c_rec.level_type,'-27323')
      AND PROFILE_OPTION_NAME = c_rec.PROFILE_OPTION_NAME
      AND nvl(APPLICATION_NAME,'-27323') = nvl(c_rec.APPLICATION_NAME,'-27323')
      AND nvl(PROFILE_OPTION_VALUE,'-27223') = nvl(c_rec.PROFILE_OPTION_VALUE,'-27223')
      AND process_flag = 1;

Line: 233

  DELETE from msc_st_profiles where process_flag=5;