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.

[Home] [Help]

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 DATA_TYPE
             from  all_tab_columns
             where table_name = p_flexinfo.table_name
               and column_name=l_segments.APPLICATION_COLUMN_NAME(j)
	       and owner =p_schema;

Line: 837


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

Line: 839


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

Line: 841


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

Line: 844


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

Line: 847


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

Line: 852


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

Line: 875


      bis_vg_log.update_failure_log( x_error_tbl
				     , x_return_status
				     , x_error_Tbl
				     );

Line: 915


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


l_Select_Table bis_vg_types.View_Text_Table_Type;

Line: 953


   bis_debug_pub.Add('> update_Desc_Flex_Tables');

Line: 1019


					, 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: 1036


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

Line: 1079


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

Line: 1082


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

Line: 1084


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

Line: 1087


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

Line: 1103


	     x_Select_Table(1) :=  'NULL';

Line: 1105


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

Line: 1119


  bis_debug_pub.Add('< update_Desc_Flex_Tables');

Line: 1135


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

Line: 1139


      bis_vg_log.update_failure_log( x_error_tbl
				     , x_return_status
				     , x_error_Tbl
				     );

Line: 1146


END update_Desc_Flex_Tables;

Line: 1182


, 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: 1232


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


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


  bis_vg_util.print_View_Text(x_Select_Table, x_return_status, x_error_Tbl);

Line: 1282


  bis_debug_pub.Add('SELECT POINTER');

Line: 1283


  bis_vg_util.print_View_Pointer ( x_Select_Pointer
  				 , x_return_status
				 , x_error_Tbl
				 );

Line: 1310


      bis_vg_log.update_failure_log( x_error_tbl
				     , x_return_status
				     , x_error_Tbl
				     );