APPS.BIS_TARGET_PUB SQL Statements

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

Line: 257

PROCEDURE Update_Target
( p_api_version   IN  NUMBER
, p_commit        IN  VARCHAR2 := FND_API.G_FALSE
, p_Target_Rec    IN  BIS_TARGET_PUB.Target_Rec_Type
, x_return_status OUT NOCOPY VARCHAR2
, x_error_Tbl     OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
)
IS
--
l_Target_Rec BIS_TARGET_PUB.Target_Rec_Type;

Line: 281

  BIS_TARGET_PVT.Update_Target
                   ( p_api_version   => p_api_version
                   , p_commit      => p_commit
                   , p_Target_Rec    => l_Target_Rec
                   , x_return_status => x_return_status
                   , x_error_Tbl     => x_error_Tbl
                   );

Line: 293

      htp.p('BIS_TARGET_PUB.Update_Target:G_EXC_ERROR'); htp.para;

Line: 298

      htp.p('BIS_TARGET_PUB.Update_Target:G_EXC_UNEXPECTED_ERROR'); htp.para;

Line: 310

      htp.p('BIS_TARGET_PUB.Update_Target:OTHERS'); htp.para;

Line: 313

END Update_Target;

Line: 317

PROCEDURE Delete_Target
( p_api_version   IN  NUMBER
, p_commit        IN  VARCHAR2 := FND_API.G_FALSE
, p_Target_Rec    IN  BIS_TARGET_PUB.Target_Rec_Type
, x_return_status OUT NOCOPY VARCHAR2
, x_error_Tbl     OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
)
IS
--
l_Target_Rec BIS_TARGET_PUB.Target_Rec_Type;

Line: 340

  BIS_TARGET_PVT.Delete_Target
  ( p_api_version   => p_api_version
  , p_commit        => p_commit
  , p_Target_Rec    => l_Target_Rec
  , x_return_status => x_return_status
  , x_error_Tbl     => x_error_Tbl
  );

Line: 352

      htp.p('BIS_TARGET_PUB.Delete_Target:G_EXC_ERROR'); htp.para;

Line: 357

      htp.p('BIS_TARGET_PUB.Delete_Target:G_EXC_UNEXPECTED_ERROR'); htp.para;

Line: 369

      htp.p('BIS_TARGET_PUB.Delete_Target:OTHERS'); htp.para;

Line: 372

END Delete_Target;