APPS.BIS_VG_SECURITY SQL Statements

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

Line: 56

PROCEDURE parse_SEC_select
  ( p_View_Select_Table 	IN  BIS_VG_TYPES.View_Text_Table_Type
    , p_pointer    	IN  BIS_VG_TYPES.View_Character_Pointer_Type
    , x_tbl      		OUT VARCHAR2
    , x_app      		OUT VARCHAR2
    , x_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_pointer   BIS_VG_TYPES.View_Character_Pointer_Type;

Line: 70

     BIS_DEBUG_PUB.Add('>  parse_SEC_select');

Line: 74

       ( p_view_select_table
	 , p_pointer
	 , l_pointer
	 , x_return_status
	 , x_error_Tbl
	 );

Line: 82

     x_tbl := bis_vg_parser.get_token ( p_view_select_table
					, l_pointer
					, ':'''
					, l_pointer
					, x_return_status
					, x_error_Tbl
					);

Line: 93

	    , p_error_proc_name   => G_PKG_NAME||'.parse_SEC_select '
	    , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
	    , p_token1        => 'tag'
	    , p_value1        => l_tag
	    , p_error_table       => x_error_tbl
	    , x_error_table       => x_error_tbl
	    );

Line: 100

	bis_vg_log.update_failure_log( x_error_tbl
				       , x_return_status
				       , x_error_Tbl
				       );

Line: 107

     x_app := bis_vg_util.get_char(p_view_select_table
				   , l_pointer
				   , x_return_status
				   , x_error_Tbl
				   );

Line: 118

	l_pointer := bis_vg_util.increment_pointer( p_view_select_table
						    , l_pointer
						    , x_return_status
						    , x_error_Tbl
						    );

Line: 128

	x_tbl := bis_vg_parser.get_token_increment_pointer( p_view_select_table
							    , l_pointer
							    , ''''
							    , l_pointer
							    , x_return_status
							    , x_error_Tbl
							    );

Line: 151

		  , p_error_proc_name   => G_PKG_NAME||'. parse_SEC_select'
		  , p_error_table       => x_error_tbl
		  , p_token1        => 'tag'
		  , p_value1        => l_tag
		  , p_token2        => 'function'
		  , p_value2        => x_app
		  , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
		  , x_error_table       => x_error_tbl
		  );

Line: 160

	      bis_vg_log.update_failure_log( x_error_tbl
					     , x_return_status
					     , x_error_Tbl
					     );

Line: 176

     BIS_DEBUG_PUB.Add('<  parse_SEC_select');

Line: 191

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

Line: 195

      bis_vg_log.update_failure_log( x_error_tbl
				     , x_return_status
				     , x_error_Tbl
				     );

Line: 201

END parse_SEC_select;

Line: 218

( p_View_Select_Table IN  BIS_VG_TYPES.View_Text_Table_Type
, p_security_pointer  IN  BIS_VG_TYPES.view_character_pointer_type
, x_Select_Table      OUT BIS_VG_TYPES.view_text_table_type
, x_security_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_tbl      VARCHAR2(100);

Line: 236

      Parse_SEC_Select ( p_View_Select_Table
		      , p_security_pointer
		      , l_tbl
		      , l_app
		      , l_pointer
		      , x_return_status
		      , x_error_Tbl
		      );

Line: 259

     x_select_table(x_select_table.COUNT + 1) := l_result;

Line: 265

                                        ( p_View_Select_Table
                                        , l_table
                                        , l_pointer
					, x_return_status
					, x_error_Tbl
                                        );

Line: 274

       x_security_pointer := bis_vg_util.increment_pointer( p_view_select_table
                                                          , x_security_pointer
							  , x_return_status
							  , x_error_Tbl
                                                          );

Line: 299

      bis_vg_log.update_failure_log( x_error_tbl
				     , x_return_status
				     , x_error_Tbl
				     );