eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIS_VG_DESC_FLEX SQL Statements

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

Line: 54


  SELECT descriptive_flex_context_code, descriptive_flex_context_name,
    description, global_flag, enabled_flag
    FROM fnd_descr_flex_contexts_vl
    WHERE application_id = flexfield.application_id
    AND descriptive_flexfield_name = flexfield.flexfield_name
    ORDER BY creation_date;

Line: 62


  SELECT /*+ leading(fnd_descr_flex_contexts_vl.t fnd_descr_flex_contexts_vl.b)
           use_nl(fnd_descr_flex_contexts_vl.b)
           index(fnd_descr_flex_contexts_vl.t
           FND_DESCR_FLEX_CONTEXTS_TL_U1)*/
    descriptive_flex_context_code, descriptive_flex_context_name,
    description, global_flag, enabled_flag
    FROM fnd_descr_flex_contexts_vl
    WHERE application_id = flexfield.application_id
    AND descriptive_flexfield_name = flexfield.flexfield_name
    ORDER BY creation_date;

Line: 74


  SELECT descriptive_flex_context_code, descriptive_flex_context_name,
    description, global_flag, enabled_flag
    FROM fnd_descr_flex_contexts_vl
    WHERE application_id = flexfield.application_id
    AND descriptive_flexfield_name = flexfield.flexfield_name
    ORDER BY creation_date, descriptive_flex_context_code ;

Line: 365


      bis_vg_log.update_failure_log( x_error_tbl
				     , x_return_status
				     , x_error_Tbl
				     );

Line: 390


	select 1
	  from   fnd_application_all_view
	  where  application_short_name = p_app;

Line: 421


PROCEDURE parse_DF_Select_Line
( p_View_Select_Table IN  bis_vg_types.View_Text_Table_Type
, p_Select_Pointer    IN  bis_vg_types.View_Character_Pointer_Type
, x_Select_Pointer    OUT bis_vg_types.View_Character_Pointer_Type
, x_Application_Name  OUT VARCHAR2
, x_Desc_Flex_Name    OUT VARCHAR2
, x_Table_Alias       OUT VARCHAR2
, x_DUMMY_flag        OUT BOOLEAN
, x_return_status     OUT VARCHAR2
, x_error_Tbl         OUT BIS_VG_UTIL.Error_Tbl_Type
)
IS
--
   l_whole_tag           VARCHAR2(2000);

Line: 438


  bis_debug_pub.Add('> parse_DF_Select_Line');

Line: 442


                            ( p_View_Select_Table
                            , p_Select_Pointer
                            , ':'''
                            , x_Select_Pointer
			    , x_return_status
			    , x_error_Tbl
			      );

Line: 450


  l_whole_tag := bis_vg_parser.get_expression( p_View_Select_Table
                                                 , p_Select_Pointer
                                                 , l_tmp_pointer
						 , x_return_status
						 , x_error_Tbl
						   );

Line: 457


      ( p_View_Select_Table
	, l_tmp_pointer
	, x_return_status
	, x_error_Tbl
	);

Line: 466


				, x_select_pointer
				, x_return_status
				, x_error_Tbl
				)
    THEN
     BIS_VG_UTIL.Add_Error_message
       ( p_error_msg_name => bis_vg_desc_flex.DFX_SEL_TAG_EXP_NO_APP_MSG
	 , p_error_proc_name   => G_PKG_NAME||'.parse_DF_Select_Line'
	 , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
	 , p_token1        => 'tag'
	 , p_value1        => l_whole_tag
	 , p_error_table       => x_error_tbl
	 , x_error_table       => x_error_tbl
	 );

Line: 480


     bis_vg_log.update_failure_log( x_error_tbl
				    , x_return_status
				    , x_error_Tbl
				    );

Line: 488


                            ( p_View_Select_Table
                            , x_Select_Pointer
                            , ':'''
                            , x_Select_Pointer
			    , x_return_status
			    , x_error_Tbl
                            );

Line: 500


				 , x_select_pointer
				 , x_return_status
				 , x_error_Tbl
				 )

      ) THEN
     BIS_VG_UTIL.Add_Error_message
       ( p_error_msg_name => bis_vg_desc_flex.DFX_SEL_TAG_EXP_NO_APP_MSG
	 , p_error_proc_name   => G_PKG_NAME||'.parse_DF_Select_Line'
	 , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
	 , p_token1        => 'tag'
	 , p_value1        => l_whole_tag
	 , p_error_table       => x_error_tbl
	 , x_error_table       => x_error_tbl
	 );

Line: 515


     bis_vg_log.update_failure_log( x_error_tbl
				    , x_return_status
				    , x_error_Tbl
				    );

Line: 528


       ( p_View_Select_Table
         , x_Select_Pointer
         , ':'
         , x_Select_Pointer
	 , x_return_status
	 , x_error_Tbl
         );

Line: 541


                                     ( p_View_Select_Table
                                     , x_Select_Pointer
                                     , ':'''
                                     , x_Select_Pointer
				     , x_return_status
				     , x_error_Tbl
                                     );

Line: 553


				 , x_select_pointer
				 , x_return_status
				 , x_error_Tbl
				 )

      ) THEN

     BIS_VG_UTIL.Add_Error_message
       ( p_error_msg_name => bis_vg_desc_flex.DFX_SEL_TAG_EXP_NO_NAME_MSG
	 , p_error_proc_name   => G_PKG_NAME||'.parse_DF_Select_Line'
	 , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
	 , p_token1        => 'tag'
	 , p_value1        => l_whole_tag
	 , p_error_table       => x_error_tbl
	 , x_error_table       => x_error_tbl
	 );

Line: 569


     bis_vg_log.update_failure_log( x_error_tbl
				    , x_return_status
				    , x_error_Tbl
				    );

Line: 579


                                  ( p_View_Select_Table
                                  , x_Select_Pointer
                                  , ':'''
                                  , x_Select_Pointer
				  , x_return_status
	        		  , x_error_Tbl
                                  );

Line: 593


				 , x_select_pointer
				 , x_return_status
				 , x_error_Tbl
				 )

      ) THEN
     BIS_VG_UTIL.Add_Error_message
       ( p_error_msg_name => bis_vg_desc_flex.DFX_SEL_TAG_EXP_NO_TABLE_MSG
	 , p_error_proc_name   => G_PKG_NAME||'.parse_DF_Select_Line'
	 , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
	 , p_token1        => 'tag'
	 , p_value1        => l_whole_tag
	 , p_error_table       => x_error_tbl
	 , x_error_table       => x_error_tbl
	 );

Line: 608


     bis_vg_log.update_failure_log( x_error_tbl
				    , x_return_status
				    , x_error_Tbl
				    );

Line: 618


     x_Select_Pointer := bis_vg_util.increment_pointer( p_View_Select_Table
                                                   , x_Select_Pointer
						   , x_return_status
						   , x_error_Tbl
                                                   );

Line: 623


     bis_debug_pub.Add('< parse_DF_Select_Line');

Line: 627


	 , p_error_proc_name   => G_PKG_NAME||'.parse_DF_Select_Line'
	 , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
	 , p_token1        => 'tag'
	 , p_value1        => l_whole_tag
	 , p_token2        => 'app'
	 , p_value2        => x_Application_Name
	 , p_error_table       => x_error_tbl
	 , x_error_table       => x_error_tbl
	 );

Line: 636


     bis_vg_log.update_failure_log( x_error_tbl
				    , x_return_status
				    , x_error_Tbl
				    );

Line: 658


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

Line: 662


      bis_vg_log.update_failure_log( x_error_tbl
				     , x_return_status
				     , x_error_Tbl
				     );

Line: 668


END parse_DF_Select_Line;

Line: 708


, x_Select_Table          OUT bis_vg_types.View_Text_Table_Type
, x_Column_Comment_Table  OUT bis_vg_types.Flex_Column_Comment_Table_Type
, p_attr_categ_flag       IN  BOOLEAN
, x_attr_categ_flag       OUT BOOLEAN
, x_return_status         OUT VARCHAR2
, x_error_Tbl             OUT BIS_VG_UTIL.Error_Tbl_Type
, p_schema                IN  VARCHAR2  --schema name
)
IS
--
l_segments          FND_DFLEX.SEGMENTS_DR;

Line: 777


	--      x_Select_Table(1) := '  ' || p_Table_Alias || '.'
	--                                || p_Flexinfo.context_column_name;

Line: 782


	   x_Select_Table(1) :=  'TO_CHAR(NULL)';

Line: 784


	   x_Select_Table(1) := '  '  || p_Table_Alias ||
	     '.' || p_Flexinfo.context_column_name;

Line: 807


        x_Select_Table(l_count) := ', '
                                || 'DECODE( '
                                ||p_flexinfo.context_column_name
                                || ', '
                                || ''''
                                ||p_context_code
                                ||''''
                                || ','
                                || p_Table_Alias
                                || '.'
                                || l_segments.APPLICATION_COLUMN_NAME(j)
                                || ', NULL'
                                || ')';

Line: 827


             select col.DATA_TYPE
             from  user_synonyms syn, all_tab_columns col
             where syn.synonym_name = p_flexinfo.table_name
               and col.column_name = l_segments.APPLICATION_COLUMN_NAME(j)
               and syn.table_owner = p_schema
               and syn.table_owner = col.owner
               and col.table_name = syn.table_name
             UNION
             select ucol.DATA_TYPE
             from user_tab_columns ucol
             where ucol.table_name = p_flexinfo.table_name
               and ucol.column_name = l_segments.APPLICATION_COLUMN_NAME(j);

Line: 844


		x_Select_Table(l_count) := ', TO_NUMBER(NULL)';

Line: 846


		x_Select_Table(l_count) := ', TO_DATE(NULL)';

Line: 848


		x_Select_Table(l_count) := ', TO_CHAR(NULL)';

Line: 851


	       x_Select_Table(l_count) := ', TO_CHAR(NULL)';

Line: 854


	    x_Select_Table(l_count) := ', ' || p_Table_Alias || '.'
	      || l_segments.APPLICATION_COLUMN_NAME(j);

Line: 859


      bis_debug_pub.Add('x_Select_Table('|| l_count||') = ' || x_Select_Table(l_count));

Line: 882


      bis_vg_log.update_failure_log( x_error_tbl
				     , x_return_status
				     , x_error_Tbl
				     );

Line: 922


PROCEDURE update_Desc_Flex_Tables
( p_EDW_Flag               IN  BOOLEAN    --EDW flag change
, p_DUMMY_Flag             IN  BOOLEAN    --EDW flag change
, p_Prefix                 IN  VARCHAR2
, p_decode                 IN  BOOLEAN
, p_column_table           IN  BIS_VG_TYPES.flexfield_column_table_type
, p_Application_Name       IN  VARCHAR2
, p_Desc_Flex_Name         IN  VARCHAR2
, p_Table_Alias            IN  VARCHAR2
, x_Column_Table           OUT bis_vg_types.View_Text_Table_Type
, x_Select_Table           OUT bis_vg_types.View_Text_Table_Type
, x_Column_Comment_Table   OUT bis_vg_types.Flex_Column_Comment_Table_Type
, x_return_status          OUT VARCHAR2
, x_error_Tbl              OUT BIS_VG_UTIL.Error_Tbl_Type
)
IS
--
i                   NUMBER;

Line: 949


l_Select_Table bis_vg_types.View_Text_Table_Type;

Line: 960


   bis_debug_pub.Add('> update_Desc_Flex_Tables');

Line: 1026


					, l_Select_Table
					, l_Column_Comment_Table
					, l_ATT_CATEGORY_flag
					, l_ATT_CATEGORY_flag
					, x_return_status
					, x_error_Tbl
					,l_schema --pass schema name

					);

Line: 1043


	   bis_vg_util.concatenate_Tables( x_Select_Table
                                    , l_Select_Table
                                    , x_Select_Table
    				    , x_return_status
				    , x_error_Tbl
                                    );

Line: 1086


		   x_select_table(l_count) := ', TO_NUMBER(NULL)';

Line: 1089


		   x_select_table(l_count) := ', TO_DATE(NULL)';

Line: 1091


		   x_select_table(l_count) := ', TO_CHAR(NULL)';

Line: 1094


		   x_select_table(l_count)
		  := ' , ' || p_Table_Alias || '.'
		  || p_column_table(i).application_column_name;

Line: 1110


	     x_Select_Table(1) :=  'NULL';

Line: 1112


	     x_Select_Table(1) := '  '
	       || p_Table_Alias
	       || '.' || l_Flexinfo.context_column_name;

Line: 1126


  bis_debug_pub.Add('< update_Desc_Flex_Tables');

Line: 1142


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

Line: 1146


      bis_vg_log.update_failure_log( x_error_tbl
				     , x_return_status
				     , x_error_Tbl
				     );

Line: 1153


END update_Desc_Flex_Tables;

Line: 1189


, p_View_Select_Table      IN  BIS_VG_TYPES.View_Text_Table_Type
, p_Mode                   IN  NUMBER
, p_column_table           IN  BIS_VG_TYPES.flexfield_column_table_type
, p_Column_Pointer         IN  BIS_VG_TYPES.View_Character_Pointer_Type
, p_Select_Pointer         IN  bis_vg_types.View_Character_Pointer_Type
, p_From_Pointer           IN  bis_vg_types.View_Character_Pointer_Type
, x_Column_Table           OUT bis_vg_types.View_Text_Table_Type
, x_Select_Table           OUT bis_vg_types.View_Text_Table_Type
, x_Column_Comment_Table   OUT BIS_VG_TYPES.Flex_Column_Comment_Table_Type
, x_Column_Pointer         OUT bis_vg_types.View_Character_Pointer_Type
, x_Select_Pointer         OUT bis_vg_types.View_Character_Pointer_Type
, x_return_status          OUT VARCHAR2
, x_error_Tbl              OUT BIS_VG_UTIL.Error_Tbl_Type
)
IS
--
l_Prefix           VARCHAR2(100);

Line: 1239


  parse_DF_Select_Line( p_View_Select_Table
                      , p_Select_Pointer
                      , x_Select_Pointer
                      , l_Application_Name
                      , l_Desc_Flex_Name
                      , l_Table_Alias
		      , l_DUMMY_Flag     --EDW flag change
		      , x_return_status
		      , x_error_Tbl
                      );

Line: 1267


    update_Desc_Flex_Tables( l_EDW_Flag      --EDW flag change
			   , l_DUMMY_Flag    --EDW flag change
			   , l_Prefix
                           , l_decode
			   , p_column_table
                           , l_Application_Name
                           , l_Desc_Flex_Name
                           , l_Table_Alias
                           , x_Column_Table
                           , x_Select_Table
                           , x_Column_Comment_Table
			   , x_return_status
			   , x_error_Tbl
                           );

Line: 1283


  bis_vg_util.print_View_Text(x_Select_Table, x_return_status, x_error_Tbl);

Line: 1289


  bis_debug_pub.Add('SELECT POINTER');

Line: 1290


  bis_vg_util.print_View_Pointer ( x_Select_Pointer
  				 , x_return_status
				 , x_error_Tbl
				 );

Line: 1317


      bis_vg_log.update_failure_log( x_error_tbl
				     , x_return_status
				     , x_error_Tbl
				     );