APPS.BIS_BUCKET_PUB SQL Statements

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

Line: 41

PROCEDURE UPDATE_BIS_BUCKET (
  p_bis_bucket_rec	IN BIS_BUCKET_PUB.bis_bucket_rec_type
 ,x_return_status       OUT NOCOPY VARCHAR2
 ,x_error_tbl           OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
)
IS

l_error_tbl       BIS_UTILITIES_PUB.Error_Tbl_Type;

Line: 52

  BIS_BUCKET_PVT.UPDATE_BIS_BUCKET(
    p_bis_bucket_rec => p_bis_bucket_rec
   ,x_return_status  => x_return_status
   ,x_error_tbl      => x_error_tbl
  );

Line: 66

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

Line: 71

END UPDATE_BIS_BUCKET;

Line: 76

PROCEDURE DELETE_BIS_BUCKET (
  p_bucket_id   	IN BIS_BUCKET.bucket_id%TYPE	:= BIS_UTILITIES_PUB.G_NULL_NUM
 ,p_short_name		IN BIS_BUCKET.short_name%TYPE  	:= BIS_UTILITIES_PUB.G_NULL_CHAR
 ,x_return_status      	OUT NOCOPY VARCHAR2
 ,x_error_tbl     	OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
)
IS

l_error_tbl       BIS_UTILITIES_PUB.Error_Tbl_Type;

Line: 88

  BIS_BUCKET_PVT.DELETE_BIS_BUCKET(
    p_bucket_id	     => p_bucket_id
   ,p_short_name     => p_short_name
   ,x_return_status  => x_return_status
   ,x_error_tbl      => x_error_tbl
  );

Line: 103

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

Line: 108

END DELETE_BIS_BUCKET;

Line: 155

  SELECT 1
  FROM   bis_bucket
  WHERE  short_name = p_bis_bucket_rec.short_name;

Line: 174

    BIS_BUCKET_PVT.UPDATE_BIS_BUCKET (
      p_bis_bucket_rec    => l_bis_bucket_rec
     ,x_return_status     => x_return_status
     ,x_error_tbl         => x_error_tbl
    );