APPS.BIS_MEASURE_SECURITY_PUB SQL Statements

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

Line: 243

PROCEDURE Update_Measure_Security
( p_api_version      IN  NUMBER
, p_commit           IN  VARCHAR2   := FND_API.G_FALSE
,p_Measure_Security_Rec IN BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type
, x_return_status    OUT NOCOPY VARCHAR2
, x_error_Tbl        OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
)
is
l_Measure_Security_Rec BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type;

Line: 267

      , p_error_proc_name   => G_PKG_NAME||'.Update_Measure_Security'
      , p_error_type        => BIS_UTILITIES_PUB.G_ERROR
      , p_error_table       => l_error_tbl
      , x_error_table       => x_error_tbl
    );

Line: 275

  BIS_MEASURE_SECURITY_PVT.Update_Measure_Security
  ( p_api_version          => p_api_version
  , p_commit               => p_commit
  , p_Measure_Security_Rec => p_Measure_Security_Rec
  , x_return_status        => x_return_status
  , x_error_Tbl            => x_error_Tbl
  );

Line: 297

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

Line: 302

end Update_Measure_Security;

Line: 310

PROCEDURE Delete_Measure_Security
( p_api_version   IN  NUMBER
, p_commit        IN  VARCHAR2   := FND_API.G_FALSE
,p_Measure_Security_Rec IN BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type
, x_return_status OUT NOCOPY VARCHAR2
, x_error_Tbl     OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
)
is
l_Measure_Security_Rec BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type;

Line: 334

      , p_error_proc_name   => G_PKG_NAME||'.Delete_Measure_Security'
      , p_error_type        => BIS_UTILITIES_PUB.G_ERROR
      , p_error_table       => l_error_tbl
      , x_error_table       => x_error_tbl
    );

Line: 342

  BIS_MEASURE_SECURITY_PVT.Delete_Measure_Security
  ( p_api_version          => p_api_version
  , p_commit               => p_commit
  , p_Measure_Security_Rec => p_Measure_Security_Rec
  , x_return_status        => x_return_status
  , x_error_Tbl            => x_error_Tbl
  );

Line: 364

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

Line: 369

end Delete_Measure_Security;

Line: 499

PROCEDURE Delete_TargetLevel_Resp
( p_commit 				IN  VARCHAR2	 := FND_API.G_FALSE
, p_measure_short_name	IN  VARCHAR2
, 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: 509

  BIS_MEASURE_SECURITY_PVT.Delete_TargetLevel_Resp
    ( p_commit				 => p_commit
    , p_measure_short_name	 => p_measure_short_name
	, x_return_status        => x_return_status
  	, x_error_Tbl            => x_error_Tbl
  	);

Line: 529

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

Line: 533

END Delete_TargetLevel_Resp;