APPS.AZ_PROFILEVALUE_CONVERT_PKG SQL Statements

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

Line: 149

    select ou.ORACLE_USERNAME into L_APP_CODE
      from   FND_ORACLE_USERID ou, FND_TABLES t
     where   ou.ORACLE_ID = t.APPLICATION_ID AND t.TABLE_NAME = P_TBL_NAME;

Line: 164

    select ou.ORACLE_USERNAME into L_APP_CODE
      from   FND_ORACLE_USERID ou, FND_VIEWS v
     where   ou.ORACLE_ID = v.APPLICATION_ID AND v.VIEW_NAME = P_TBL_NAME;

Line: 194

      select oracle_username into L_OWNER
        from fnd_oracle_userid where read_only_flag = 'U';

Line: 230

    SELECT DATA_TYPE into L_COL_TYPE
      from   dba_tab_columns
      where  COLUMN_NAME=P_COL_NAME AND TABLE_NAME=P_TBL_NAME AND OWNER=L_OWNER;

Line: 239

    SELECT DATA_TYPE into L_COL_TYPE
      from   dba_tab_columns
      where  COLUMN_NAME=P_COL_NAME AND TABLE_NAME=P_TBL_NAME AND OWNER=L_OWNER;

Line: 268

 STR_SELECT VARCHAR2(2000);

Line: 272

 SELECT1 VARCHAR2(256);

Line: 273

 SELECT2 VARCHAR2(256);

Line: 274

 SELECT3 VARCHAR2(256);

Line: 275

 SELECT4 VARCHAR2(256);

Line: 288

 v_SelectStmt VARCHAR2(2000);

Line: 296

  select SQL_VALIDATION into SQL_STR
    from   fnd_profile_options
    where  ( PROFILE_OPTION_NAME = P_PROFILE_NAME OR PROFILE_OPTION_NAME = UPPER(P_PROFILE_NAME) );

Line: 343

  STR_SELECT := LTRIM(RTRIM( SUBSTR(SQL_STR, 8, idx-8) ));  -- 8 is the length of "SELECT "+1

Line: 363

  IF ( SEARCH_SUBSTR(STR_SELECT, 'DECODE') > 0 OR SEARCH_SUBSTR(STR_SELECT, 'DISTINCT') > 0 ) THEN
    return P_PROFILE_VALUE;

Line: 367

  PARSE_COMMA( STR_SELECT, SELECT1, SELECT2, SELECT3, SELECT4 );

Line: 369

  IF    ( INTO1 = ':PROFILE_OPTION_VALUE' ) THEN SEL_CODE := SELECT1;

Line: 370

  ELSIF ( INTO2 = ':PROFILE_OPTION_VALUE' ) THEN SEL_CODE := SELECT2;

Line: 371

  ELSIF ( INTO3 = ':PROFILE_OPTION_VALUE' ) THEN SEL_CODE := SELECT3;

Line: 372

  ELSIF ( INTO4 = ':PROFILE_OPTION_VALUE' ) THEN SEL_CODE := SELECT4;

Line: 374

  IF    ( INTO1 = ':VISIBLE_OPTION_VALUE' ) THEN SEL_DISPLAY := SELECT1;

Line: 375

  ELSIF ( INTO2 = ':VISIBLE_OPTION_VALUE' ) THEN SEL_DISPLAY := SELECT2;

Line: 376

  ELSIF ( INTO3 = ':VISIBLE_OPTION_VALUE' ) THEN SEL_DISPLAY := SELECT3;

Line: 377

  ELSIF ( INTO4 = ':VISIBLE_OPTION_VALUE' ) THEN SEL_DISPLAY := SELECT4;

Line: 412

    v_SelectStmt := 'SELECT ' || SEL_DISPLAY || ' FROM ' || STR_FROM || ' WHERE ' || SEL_CODE || ' = ' || P_PROFILE_VALUE;

Line: 414

      v_SelectStmt := v_SelectStmt || ' AND ' || STR_WHERE;

Line: 420

    DBMS_SQL.PARSE( v_CursorID, v_SelectStmt, DBMS_SQL.NATIVE );

Line: 424

    OPEN sql_csr FOR v_SelectStmt;

Line: 446

    v_SelectStmt := 'SELECT ' || SEL_CODE || ' FROM ' || STR_FROM || ' WHERE LTRIM(RTRIM(' || SEL_DISPLAY || ')) = '
          || FND_GLOBAL.LOCAL_CHR(39) || LTRIM(RTRIM(P_PROFILE_VALUE)) || FND_GLOBAL.LOCAL_CHR(39);

Line: 449

      v_SelectStmt := v_SelectStmt || ' AND ' || STR_WHERE;

Line: 453

    DBMS_SQL.PARSE( v_CursorID, v_SelectStmt, DBMS_SQL.NATIVE );

Line: 457

    OPEN sql_csr FOR v_SelectStmt;