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
	(SELECT DATA_TYPE
        from   user_synonyms syn, dba_tab_columns col
        where  col.COLUMN_NAME=P_COL_NAME
	AND syn.synonym_name=P_TBL_NAME
	AND col.owner = syn.table_owner
	AND col.table_name = syn.table_name
	AND syn.table_OWNER=L_OWNER
	union
	select data_type
	from user_tab_columns col
	where col.table_name = P_TBL_NAME
	AND col.column_name = P_COL_NAME);

Line: 248

        SELECT DATA_TYPE into L_COL_TYPE FROM
        (SELECT DATA_TYPE
        from   user_synonyms syn, dba_tab_columns col
        where  col.COLUMN_NAME=P_COL_NAME
        AND syn.synonym_name=P_TBL_NAME
        AND col.owner = syn.table_owner
        AND col.table_name = syn.table_name
        AND syn.table_OWNER=L_OWNER
        union
        select data_type
        from user_tab_columns col
        where col.table_name = P_TBL_NAME
	AND col.column_name = P_COL_NAME);

Line: 286

 STR_SELECT VARCHAR2(2000);

Line: 290

 SELECT1 VARCHAR2(256);

Line: 291

 SELECT2 VARCHAR2(256);

Line: 292

 SELECT3 VARCHAR2(256);

Line: 293

 SELECT4 VARCHAR2(256);

Line: 306

 v_SelectStmt VARCHAR2(2000);

Line: 314

  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: 361

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

Line: 381

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

Line: 385

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

Line: 387

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

Line: 388

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

Line: 389

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

Line: 390

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

Line: 392

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

Line: 393

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

Line: 394

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

Line: 395

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

Line: 430

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

Line: 432

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

Line: 438

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

Line: 442

    OPEN sql_csr FOR v_SelectStmt;

Line: 464

    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: 467

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

Line: 471

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

Line: 475

    OPEN sql_csr FOR v_SelectStmt;