APPS.BIS_MEASURE_PUB SQL Statements

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

Line: 28

REM | 27-JUL-2004 sawu      Propagated p_owner to PVT apis for create/update|
REM +=======================================================================+
*/
--
G_PKG_NAME CONSTANT VARCHAR2(30):='BIS_MEASURE_PUB';

Line: 238

Procedure Update_Measure
( p_api_version   IN  NUMBER
, p_commit        IN  VARCHAR2   := FND_API.G_FALSE
, p_Measure_Rec   IN  BIS_MEASURE_PUB.Measure_Rec_Type
, p_owner            IN  VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
, x_return_status OUT NOCOPY VARCHAR2
, x_error_Tbl     OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
)
IS
  l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;

Line: 286

  BIS_Measure_PVT.Update_Measure
  ( p_api_version   => p_api_version
  , p_commit        => p_commit
  , p_Measure_Rec   => l_Measure_Rec
  , p_owner         => p_owner
  , x_return_status => x_return_status
  , x_error_Tbl     => x_error_Tbl
  );

Line: 307

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

Line: 312

END Update_Measure;

Line: 320

Procedure Delete_Measure
( p_api_version   IN  NUMBER
, p_commit        IN  VARCHAR2   := FND_API.G_FALSE
, p_Measure_Rec   IN  BIS_MEASURE_PUB.Measure_Rec_Type
, x_return_status OUT NOCOPY VARCHAR2
, x_error_Tbl     OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
)
IS
  l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;

Line: 353

  BIS_Measure_PVT.Delete_Measure
  ( p_api_version   => p_api_version
  , p_commit        => p_commit
  , p_Measure_Rec   => l_Measure_Rec
  , x_return_status => x_return_status
  , x_error_Tbl     => x_error_Tbl
  );

Line: 372

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

Line: 377

END Delete_Measure;

Line: 662

     BIS_MEASURE_PVT.Update_Measure
    ( p_api_version       => p_api_version
    , p_commit            => p_commit
    , p_validation_level  => p_validation_level
    , p_Measure_Rec       => l_Measure_Rec
    , p_owner             => p_owner
    , x_return_status     => x_return_status
    , x_error_Tbl         => x_error_Tbl
    );

Line: 738

  l_msg := l_msg || ' could not be created/updated.';

Line: 879

     BIS_MEASURE_PVT.Update_Measure
     ( p_api_version       => p_api_version
     , p_commit            => p_commit
     , p_validation_level  => p_validation_level
     , p_Measure_Rec       => l_Measure_Rec
     , p_owner             => p_owner
     , p_Org_Dimension_ID  => l_Org_Dimension_ID
     , p_Time_Dimension_ID => l_Time_Dimension_ID
     , x_return_status     => x_return_status
     , x_error_Tbl         => x_error_Tbl
     );