APPS.BIS_VG_LOG SQL Statements

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

Line: 101

  g_gen_success_table.DELETE;

Line: 102

  g_gen_failure_table.DELETE;

Line: 135

PROCEDURE update_success_log
    ( p_origbv IN bis_vg_types.view_name_type
    , p_genbv  IN bis_vg_types.view_name_type
    , x_return_status       OUT VARCHAR2
    , x_error_Tbl           OUT BIS_VG_UTIL.Error_Tbl_Type
    )
IS
l_result view_gen_success_type;

Line: 145

  bis_debug_pub.Add('> update_success_log');

Line: 150

  bis_debug_pub.Add('< update_success_log');

Line: 164

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

Line: 170

END update_success_log;

Line: 185

PROCEDURE update_failure_log
    ( p_origbv IN bis_vg_types.view_name_type
    , p_code   IN NUMBER
    , p_errm   IN VARCHAR2
    , x_return_status       OUT VARCHAR2
    , x_error_Tbl           OUT BIS_VG_UTIL.Error_Tbl_Type
    )
IS
l_result view_gen_failure_type;

Line: 196

  bis_debug_pub.Add('> update_failure_log');

Line: 205

  bis_debug_pub.Add('< update_failure_log');

Line: 219

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

Line: 225

END update_failure_log;

Line: 238

PROCEDURE update_failure_log
    ( p_error_Tbl           IN BIS_VG_UTIL.Error_Tbl_Type
    , x_return_status       OUT VARCHAR2
    , x_error_Tbl           OUT BIS_VG_UTIL.Error_Tbl_Type
    )
IS
l_result view_gen_failure_type;

Line: 247

  bis_debug_pub.Add('> update_failure_log');

Line: 264

  bis_debug_pub.Add('< update_failure_log');

Line: 279

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

Line: 285

END update_failure_log;