APPS.BIS_VG_COMPILE SQL Statements

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

Line: 338

  , p_View_Select_Text_Table    IN bis_vg_types.View_Text_Table_Type
  , p_applsys_schema            IN VARCHAR2
  , x_return_status             OUT NOCOPY VARCHAR2
  , x_error_Tbl                 OUT NOCOPY BIS_VG_UTIL.Error_Tbl_Type
)

  IS
   l_count  NUMBER;

Line: 364

    FOR l_count IN 1 .. p_View_Select_Text_Table.COUNT
      LOOP
   l_total := l_total+1;

Line: 367

   AD_DDL.build_statement(p_View_Select_Text_Table(l_count)
        , l_total);

Line: 371

      BIS_DEBUG_PUB.Add(p_View_Select_Text_Table(l_count));

Line: 401

      bis_vg_log.update_failure_log( x_error_tbl
             , x_return_status
             , x_error_Tbl
             );

Line: 428

  , p_View_Select_Text_Table    IN bis_vg_types.View_Text_Table_Type
  , p_applsys_schema            IN VARCHAR2
  , x_return_status             OUT NOCOPY VARCHAR2
  , x_error_Tbl                 OUT NOCOPY BIS_VG_UTIL.Error_Tbl_Type
)

  IS
     l_buffer VARCHAR2(29000);

Line: 456

  FOR l_count IN 1 .. p_View_Select_Text_Table.COUNT
    LOOP
       l_buffer:=l_buffer || p_View_Select_Text_Table(l_count);

Line: 459

       l_length := l_length  + length(p_View_Select_Text_Table(l_count));

Line: 464

    BIS_DEBUG_PUB.Add(p_View_Select_Text_Table(l_count) );

Line: 514

      bis_vg_log.update_failure_log( x_error_tbl
             , x_return_status
             , x_error_Tbl
             );

Line: 613

      bis_vg_log.update_failure_log( x_error_tbl
             , x_return_status
             , x_error_Tbl
             );

Line: 671

      bis_vg_log.update_failure_log( x_error_tbl
             , x_return_status
             , x_error_Tbl
             );

Line: 690

PROCEDURE insert_hat_in_column -- PRIVATE PROCEDURE
( p_column_name       IN  bis_vg_types.View_Text_Table_Rec_Type
, p_table_column_name IN  bis_vg_types.View_Text_Table_Rec_Type
, x_column_name       IN OUT NOCOPY bis_vg_types.View_Text_Table_Rec_Type
, x_return_status       OUT NOCOPY VARCHAR2
, x_error_Tbl           OUT NOCOPY BIS_VG_UTIL.Error_Tbl_Type
)
IS
--
l_pos NUMBER;

Line: 702

  bis_debug_pub.Add('> insert_hat_in_column');

Line: 711

  bis_debug_pub.Add('< insert_hat_in_column');

Line: 726

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

Line: 730

      bis_vg_log.update_failure_log( x_error_tbl
             , x_return_status
             , x_error_Tbl
             );

Line: 736

END insert_hat_in_column;

Line: 798

      insert_hat_in_column( l_column_name
                            , l_View_Text_Count_Table(l_index).Column_name
                            , l_column_name
                            , x_return_status
                            , x_error_Tbl
                           );

Line: 834

      bis_vg_log.update_failure_log( x_error_tbl
             , x_return_status
             , x_error_Tbl
             );

Line: 962

      bis_vg_log.update_failure_log( x_error_tbl
             , x_return_status
             , x_error_Tbl
             );

Line: 1111

      bis_vg_log.update_failure_log( x_error_tbl
             , l_dummy
             , x_error_Tbl
             );

Line: 1138

, p_View_Select_Text_Table    IN bis_vg_types.view_text_table_type
, p_View_Column_Comment_Table IN  bis_vg_types.Flex_Column_Comment_Table_Type
, x_View_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
--
l_View_Create_Text_Table bis_vg_types.View_Text_Table_Type;

Line: 1188

                   , p_View_Select_Text_Table
                   , l_applsys_schema
                   , dummy_char
                   , x_error_Tbl
                   );

Line: 1203

                , p_View_Select_Text_Table
                , l_applsys_schema
                , dummy_char
                , x_error_Tbl
               );

Line: 1229

      bis_vg_log.update_failure_log( x_error_tbl
             , dummy_char
             , x_error_Tbl
             );