APPS.ADX_PRF_PKG SQL Statements

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

Line: 38

                      p_update_only         in boolean default FALSE,
                      p_insert_only         in boolean default FALSE,
                      p_level_value2        in varchar2 default NULL)
IS
    old_pv_rec fnd_profile_option_values%rowtype;

Line: 45

    update_flag varchar2(1);

Line: 46

    insert_flag varchar2(1);

Line: 52

        select *
        into   old_pv_rec
        from   fnd_profile_option_values
        where  (application_id, profile_option_id) in (
          select application_id, profile_option_id
          from   fnd_profile_options
          where  application_id = p_application_id
          and    profile_option_name = p_profile_option_name)
          and    level_id = p_level_id;

Line: 62

        select *
        into   old_pv_rec
        from   fnd_profile_option_values
        where  (application_id, profile_option_id) in (
          select application_id, profile_option_id
          from   fnd_profile_options
          where  application_id = p_application_id
          and    profile_option_name = p_profile_option_name)
          and    level_id = p_level_id
          and    level_value = p_level_value
          and    level_value2 = p_level_value2;

Line: 81

         select tname into tablename from tab where tname ='ADX_PRE_AUTOCONFIG' and tabtype in ('TABLE', 'SYNONYM');

Line: 91

             update_only              varchar2(1),
             insert_only              varchar2(1),
             level_value2             varchar2(100)
          )';

Line: 104

          select column_name into columnname from user_tab_columns where table_name like 'ADX_PRE_AUTOCONFIG' and column_name like 'LEVEL_VALUE2';

Line: 133

     if (p_insert_only = FALSE) then
       insert_flag := 'F';

Line: 135

       if (p_update_only = FALSE)then
         update_flag := 'F';

Line: 138

         update_flag := 'T';

Line: 141

       insert_flag := 'T';

Line: 142

       if (p_update_only = FALSE) then
         update_flag := 'F';

Line: 145

         update_flag := 'T';

Line: 159

         str := 'select count(*)
                 from ADX_PRE_AUTOCONFIG where
                 application_id=:1 and
                 profile_option_name=:2 and
                 level_id=:3  and
                 level_value=:4 and
                 context_name=:5 and
                 update_only= :6 and
                 insert_only= :7';

Line: 170

                     p_level_value, p_context_name,update_flag,insert_flag;

Line: 172

         if (countrow>0) then -- update table since row already exist
            str := 'update ADX_PRE_AUTOCONFIG set
                    profile_value=:1 where
                    application_id=:2 and profile_option_name=:3 and
                    level_id=:4 and level_value=:5 and
                    context_name=:6 and update_only=:7 and
                    insert_only=:8';

Line: 182

                        p_context_name, update_flag, insert_flag;

Line: 184

         else  -- insert new row into table since one does not exist yet
            str:='insert into ADX_PRE_AUTOCONFIG
                  (application_id, profile_option_name,
                   level_id,level_value,profile_value,
                   level_value_app_id,context_name,
                   update_only,insert_only)
                  values(:1, :2, :3, :4, :5, :6, :7, :8, :9)';

Line: 194

                        level_value_app_id_temp, p_context_name, update_flag,
                        insert_flag;

Line: 207

         str:= 'select count(*)
                from ADX_PRE_AUTOCONFIG where
                application_id=:1 and
                profile_option_name=:2 and
                level_id=:3  and
                level_value=:4 and
                level_value_app_id=:5 and
                context_name=:6 and
                update_only= :7 and
                insert_only= :8 and
                level_value2= :9';

Line: 221

                     update_flag,insert_flag, p_level_value2;

Line: 223

         if (countrow>0) then -- update table since row already exist
            str := 'update ADX_PRE_AUTOCONFIG set
                    profile_value=:1 where
                    application_id=:2 and profile_option_name=:3 and
                    level_id=:4 and level_value=:5 and
                    level_value_app_id=:6 and
                    context_name=:7 and update_only=:8 and
                    insert_only=:9 and  level_value2=:10';

Line: 234

                        level_value_app_id_temp, p_context_name, update_flag,
                        insert_flag, p_level_value2;

Line: 237

         else -- insert new row into table since one does not exist yet
           str:='insert into ADX_PRE_AUTOCONFIG
                 values(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10)';

Line: 243

                       level_value_app_id_temp, p_context_name, update_flag,
                       insert_flag, p_level_value2;

Line: 266

        println(' INFO           : Updated/created profile option value.');