APPS.BIS_VG_REPOSITORY_MEDIATOR SQL Statements

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

Line: 47

                    := 'SELECT TEXT FROM USER_VIEWS WHERE VIEW_NAME = ';

Line: 170

PROCEDURE create_View_Select_Text_Table
  ( p_view_name              IN  BIS_VG_TYPES.View_name_Type := null
    , x_View_Select_Text_Table OUT BIS_VG_TYPES.View_Text_Table_Type
    , x_error_Tbl              OUT BIS_VG_UTIL.Error_Tbl_Type
    )
  IS
     --
     l_eod              BOOLEAN;

Line: 182

   BIS_DEBUG_PUB.Add('> create_View_Select_Text_Table');

Line: 200

      x_View_Select_Text_Table(x_View_Select_Text_Table.COUNT + 1):= l_string;

Line: 206

   BIS_DEBUG_PUB.Add('< create_View_Select_Text_Table');

Line: 224

	  , p_error_proc_name   => G_PKG_NAME||'.create_View_Select_Text_Table'
	  , p_error_table       => x_error_tbl
	  , x_error_table       => x_error_tbl
	  );

Line: 230

END create_View_Select_Text_Table;

Line: 248

   , x_View_Select_Text_Table OUT BIS_VG_TYPES.View_Text_Table_Type
   , x_error_Tbl              OUT BIS_VG_UTIL.Error_Tbl_Type
   )
  IS
     l_count           NUMBER;

Line: 262

	select COLUMN_NAME
	  from user_tab_columns
	  where TABLE_NAME=Upper(p_view_name)
	  order by COLUMN_ID;

Line: 277

     create_View_Select_Text_Table ( p_View_name
				     , x_View_Select_Text_Table
---				   , x_return_status
				     , x_error_Tbl
				     );

Line: 283

     BIS_DEBUG_PUB.Add('text count = '||x_View_Select_Text_Table.COUNT);

Line: 339

     SELECT application_id
       FROM fnd_application
       WHERE application_short_name = Lower(p_short_name);

Line: 496

        select
          view_name
        , text_length
        FROM user_views
        WHERE
          (
               view_name LIKE '__BV\_%' escape '\'
            OR view_name LIKE '__FV\_%' escape '\'
            OR view_name LIKE '___BV\_%' escape '\'
            OR view_name LIKE '___FV\_%' escape '\'
          )
          AND view_name IN (
                             SELECT
                               DISTINCT(table_name) view_name
                             FROM user_tab_columns
                             WHERE
                               column_name LIKE Upper(p_like_str) escape '\'
                            OR column_name LIKE Lower(p_like_str) escape '\'
                           )
                           ;

Line: 765

     select
       view_name
     , text_length
     FROM user_views
     WHERE view_name = Upper(p_view_name);

Line: 829

     select
       view_name
     , text_length
     FROM user_views
     WHERE view_name LIKE Upper(p_app_abbrev)||'BV\_%' escape '\'
       OR  view_name LIKE Upper(p_app_abbrev)||'FV\_%' escape '\';

Line: 837

     select
       view_name
     , text_length
     FROM user_views
     WHERE view_name LIKE 'HR'||'BV\_%' escape '\'
       OR  view_name LIKE 'HR'||'FV\_%' escape '\'
       OR  view_name LIKE 'IRC'||'BV\_%' escape '\'
       OR  view_name LIKE 'IRC'||'FV\_%' escape '\';

Line: 976

     select
       view_name
     , text_length
     FROM user_views
     WHERE view_name LIKE '__BV\_%' escape '\'
        OR view_name LIKE '__FV\_%' escape '\'
        OR view_name LIKE '___BV\_%' escape '\'
        OR view_name LIKE '___FV\_%' escape '\';