APPS.MSD_VALIDATE SQL Statements

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

Line: 22

  insert into msd_test values(p_text);*/

Line: 29

  /*insert into msd_test values(p_text);*/

Line: 105

        select DECODE(p_detail,'1','2','2','1') into lv_report_type from DUAL;

Line: 139

 TYPE SelectRec is record(c1 msd_audit_sql_statements.column1%TYPE,
                          c2 msd_audit_sql_statements.column1%TYPE,
                          c3 msd_audit_sql_statements.column1%TYPE,
                          c4 msd_audit_sql_statements.column1%TYPE,
                          c5 msd_audit_sql_statements.column1%TYPE,
                          c6 msd_audit_sql_statements.column1%TYPE,
                          c7 msd_audit_sql_statements.column1%TYPE,
                          c8 msd_audit_sql_statements.column1%TYPE,
                          c9 msd_audit_sql_statements.column1%TYPE,
                          c10 msd_audit_sql_statements.column1%TYPE,
                          c11 msd_audit_sql_statements.column1%TYPE);

Line: 167

 selrow SelectRec;

Line: 175

  select * from msd_audit_sql_statements
  where function = p_function
  and application_code = c_application_code
  and nvl(enabled, 'Y') = 'Y'
  order by statement_id, STATEMENT_DESCRIPTION;

Line: 182

 SELECT DECODE( M2A_DBLINK, NULL, NULL_DBLINK, '@'||M2A_DBLINK||' ') M2A_DBLINK,
                INSTANCE_TYPE, apps_ver,
               DECODE( A2M_DBLINK, NULL, NULL_DBLINK, '@'||A2M_DBLINK||' ') A2M_DBLINK,
               instance_code,
                instance_id
 FROM MSC_APPS_INSTANCES
 where instance_id = decode(c_instance_id, -1, instance_id,
                                            0, instance_id,
                                               c_instance_id);

Line: 245

         SELECT DECODE( M2A_DBLINK, NULL, NULL_DBLINK, '@'||M2A_DBLINK||' '),
                INSTANCE_TYPE, apps_ver,
               DECODE( A2M_DBLINK, NULL, NULL_DBLINK, '@'||A2M_DBLINK||' '),
               instance_code
           INTO v_m2a_dblink,
                v_instance_type, v_apps_ver,
                v_a2m_dblink,
                v_instance_code
           FROM MSC_APPS_INSTANCES
          WHERE INSTANCE_ID= p_INSTANCE_ID;

Line: 274

  SELECT FND_GLOBAL.USER_NAME,
          FND_GLOBAL.RESP_NAME,
          FND_GLOBAL.APPLICATION_NAME
          INTO  v_user_name,
                v_resp_name,
                v_application_name
          FROM  dual;

Line: 298

    select meaning
    into v_function_name
    from fnd_lookup_values_vl
    where lookup_type = 'MSD_AUDIT_REPORT'
      and lookup_code = p_function;

Line: 337

       'SELECT ' ||
         get_td_tag('msd_validate.get_translated_string(' ||
                    '''' || s.summary_message          || ''', ' ||
                    '''' || v_application_code         || ''', ' ||
                    '''' || s.summary_token1           || ''', ' ||
                    nvl(s.summary_token1_value,'''''') || ',   ' ||
                    '''' || s.summary_token2           || ''', ' ||
                    nvl(s.summary_token2_value,'''''') || ',   ' ||
                    '''' || s.summary_token3           || ''', ' ||
                    nvl(s.summary_token3_value,'''''') || ')')   ||
         ', '''', '''', '''', '''', '''', '''', '''', '''', '''', '''' ';

Line: 349

     /* select all query columns */
      v_sql_stmt :=
       'SELECT ' ||
         get_td_tag(s.column1) || ',' ||
         get_td_tag(s.column2) || ',' ||
         get_td_tag(s.column3) || ',' ||
         get_td_tag(s.column4) || ',' ||
         get_td_tag(s.column5) || ',' ||
         get_td_tag(s.column6) || ',' ||
         get_td_tag(s.column7) || ',' ||
         get_td_tag(s.column8) || ',' ||
         get_td_tag(s.column9) || ',' ||
         get_td_tag(s.column10) || ',' ||
         get_td_tag(s.column11);

Line: 365

    select decode(nvl(s.where_clause,'N'),'N','N','Y') into lv_where_clause  from dual;

Line: 579

      select application_name
      into v_appl_name
      from fnd_application_vl
      where application_short_name = v_application_code;

Line: 741

  select count(*)
  into v_count
  from msd_level_values
  where level_id = p_level_id
    and instance = p_instance
    and sr_level_pk = p_sr_pk;