eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_ENTY_ATTR_VALIDATIONS_PVT SQL Statements

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

Line: 51


      SELECT PV_ENTY_ATTR_VALIDATIONS_S.NEXTVAL
      FROM dual;

Line: 55


      SELECT 1
      FROM PV_ENTY_ATTR_VALIDATIONS
      WHERE VALIDATION_ID = l_id;

Line: 130


           l_enty_attr_validation_rec.last_update_date      := SYSDATE;

Line: 131


           l_enty_attr_validation_rec.last_updated_by       := G_USER_ID;

Line: 134


           l_enty_attr_validation_rec.last_update_login     := G_LOGIN_ID;

Line: 167


      PV_ENTY_ATTR_VALIDATIONS_PKG.Insert_Row(
           px_enty_attr_validation_id			=> l_enty_attr_validation_rec.validation_id
          ,p_last_update_date					=> l_enty_attr_validation_rec.last_update_date
          ,p_last_updated_by					=> l_enty_attr_validation_rec.last_updated_by
          ,p_creation_date						=> l_enty_attr_validation_rec.creation_date
          ,p_created_by							=> l_enty_attr_validation_rec.created_by
          ,p_last_update_login					=> l_enty_attr_validation_rec.last_update_login
          ,px_object_version_number				=> l_object_version_number
          ,p_validation_date					=> p_enty_attr_validation_rec.validation_date
          ,p_validated_by_resource_id           => p_enty_attr_validation_rec.validated_by_resource_id
          ,p_validation_document_id             => p_enty_attr_validation_rec.validation_document_id
          ,p_validation_note					=> p_enty_attr_validation_rec.validation_note
          );

Line: 253


PROCEDURE Update_Enty_Attr_Validation(
     p_api_version_number         IN   NUMBER
    ,p_init_msg_list              IN   VARCHAR2     := FND_API.G_FALSE
    ,p_commit                     IN   VARCHAR2     := FND_API.G_FALSE
    ,p_validation_level           IN   NUMBER       := FND_API.G_VALID_LEVEL_FULL

    ,x_return_status              OUT NOCOPY  VARCHAR2
    ,x_msg_count                  OUT NOCOPY  NUMBER
    ,x_msg_data                   OUT NOCOPY  VARCHAR2

    ,p_enty_attr_validation_rec   IN   enty_attr_validation_rec_type
    ,x_object_version_number      OUT NOCOPY  NUMBER
    )
 IS

CURSOR c_get_enty_attr_validation(cv_enty_attr_validation_id NUMBER) IS
    SELECT *
    FROM  PV_ENTY_ATTR_VALIDATIONS
    WHERE validation_id = cv_enty_attr_validation_id;

Line: 273


l_api_name                 CONSTANT VARCHAR2(30) := 'Update_Enty_Attr_Validation';

Line: 285


      SAVEPOINT Update_Enty_Attr_Validation;

Line: 314


	  PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Open Cursor to Select');

Line: 324


			   FND_MESSAGE.set_token('MODE','Update');

Line: 343


			   FND_MESSAGE.set_token('COLUMN','Last_Update_Date');

Line: 370


            ,p_validation_mode      => JTF_PLSQL_API.g_update
            ,p_enty_attr_validation_rec    => p_enty_attr_validation_rec
            ,x_return_status        => x_return_status
            ,x_msg_count            => x_msg_count
            ,x_msg_data             => x_msg_data
            );

Line: 386


       PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling update table handler');

Line: 390


      PV_ENTY_ATTR_VALIDATIONS_PKG.Update_Row(
           p_enty_attr_validation_id			=> p_enty_attr_validation_rec.validation_id
          ,p_last_update_date					=> SYSDATE
          ,p_last_updated_by					=> G_USER_ID
          -- p_creation_date					=> SYSDATE
          -- p_created_by						=> G_USER_ID
          ,p_last_update_login					=> G_LOGIN_ID
          ,p_object_version_number				=> p_enty_attr_validation_rec.object_version_number
          ,p_validation_date					=> p_enty_attr_validation_rec.validation_date
          ,p_validated_by_resource_id           => p_enty_attr_validation_rec.validated_by_resource_id
          ,p_validation_document_id             => p_enty_attr_validation_rec.validation_document_id
          ,p_validation_note					=> p_enty_attr_validation_rec.validation_note

          );

Line: 433


     ROLLBACK TO Update_Enty_Attr_Validation;

Line: 443


     ROLLBACK TO Update_Enty_Attr_Validation;

Line: 453


     ROLLBACK TO Update_Enty_Attr_Validation;

Line: 465


End Update_Enty_Attr_Validation;

Line: 468


PROCEDURE Delete_Enty_Attr_Validation(
     p_api_version_number         IN   NUMBER
    ,p_init_msg_list              IN   VARCHAR2     := FND_API.G_FALSE
    ,p_commit                     IN   VARCHAR2     := FND_API.G_FALSE
    ,p_validation_level           IN   NUMBER       := FND_API.G_VALID_LEVEL_FULL

    ,x_return_status              OUT NOCOPY  VARCHAR2
    ,x_msg_count                  OUT NOCOPY  NUMBER
    ,x_msg_data                   OUT NOCOPY  VARCHAR2

    ,p_enty_attr_validation_id           IN  NUMBER
    ,p_object_version_number      IN   NUMBER
    )

 IS
l_api_name                  CONSTANT VARCHAR2(30) := 'Delete_Enty_Attr_Validation';

Line: 490


      SAVEPOINT Delete_Enty_Attr_Validation;

Line: 521


	   PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling delete table handler');

Line: 525


       PV_ENTY_ATTR_VALIDATIONS_PKG.Delete_Row(
          p_enty_attr_validation_id  => p_enty_attr_validation_id);

Line: 554


     ROLLBACK TO Delete_Enty_Attr_Validation;

Line: 564


     ROLLBACK TO Delete_Enty_Attr_Validation;

Line: 574


     ROLLBACK TO Delete_Enty_Attr_Validation;

Line: 586


End Delete_Enty_Attr_Validation;

Line: 610


   SELECT VALIDATION_ID
   FROM PV_ENTY_ATTR_VALIDATIONS
   WHERE VALIDATION_ID = p_ENTY_ATTR_VALIDATION_ID
   AND object_version_number = p_object_version
   FOR UPDATE NOWAIT;

Line: 781


      IF p_enty_attr_validation_rec.last_update_date = FND_API.g_miss_date
         OR p_enty_attr_validation_rec.last_update_date IS NULL THEN

          IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
          FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

Line: 786


          FND_MESSAGE.set_token('COLUMN','last_update_date');

Line: 794


      IF p_enty_attr_validation_rec.last_updated_by = FND_API.g_miss_num
         OR p_enty_attr_validation_rec.last_updated_by IS NULL THEN
          IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
			  FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

Line: 798


			  FND_MESSAGE.set_token('COLUMN','last_updated_by');

Line: 830


      IF p_enty_attr_validation_rec.last_update_login = FND_API.g_miss_num
         OR p_enty_attr_validation_rec.last_update_login IS NULL THEN
          IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
			  FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

Line: 834


			  FND_MESSAGE.set_token('COLUMN','last_update_login');

Line: 892


      IF p_enty_attr_validation_rec.last_update_date = FND_API.g_miss_date
         OR p_enty_attr_validation_rec.last_update_date IS NULL THEN

          IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
			  FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

Line: 897


			  FND_MESSAGE.set_token('COLUMN','last_update_date');

Line: 905


      IF p_enty_attr_validation_rec.last_updated_by = FND_API.g_miss_num
         OR p_enty_attr_validation_rec.last_updated_by IS NULL THEN
          IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
			  FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

Line: 909


			  FND_MESSAGE.set_token('COLUMN','last_updated_by');

Line: 941


      IF p_enty_attr_validation_rec.last_update_login = FND_API.g_miss_num
         OR p_enty_attr_validation_rec.last_update_login IS NULL THEN
          IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
			  FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

Line: 945


			  FND_MESSAGE.set_token('COLUMN','last_update_login');

Line: 1087


      SELECT *
      FROM pv_enty_attr_validations
      WHERE validation_id = p_enty_attr_validation_rec.validation_id;

Line: 1105


   IF p_enty_attr_validation_rec.last_update_date = FND_API.g_miss_date THEN
      x_complete_rec.last_update_date := l_pv_enty_attr_validation_rec.last_update_date;

Line: 1110


   IF p_enty_attr_validation_rec.last_updated_by = FND_API.g_miss_num THEN
      x_complete_rec.last_updated_by := l_pv_enty_attr_validation_rec.last_updated_by;

Line: 1125


   IF p_enty_attr_validation_rec.last_update_login = FND_API.g_miss_num THEN
      x_complete_rec.last_update_login := l_pv_enty_attr_validation_rec.last_update_login;

Line: 1169


    ,p_validation_mode      IN   VARCHAR2   := JTF_PLSQL_API.G_UPDATE
    ,p_enty_attr_validation_rec   IN   enty_attr_validation_rec_type

    ,x_return_status        OUT NOCOPY  VARCHAR2
    ,x_msg_count            OUT NOCOPY  NUMBER
    ,x_msg_data             OUT NOCOPY  VARCHAR2
    )
 IS
l_api_name                  CONSTANT VARCHAR2(30) := 'Validate_Enty_Attr_Validation';

Line: 1314


    ,p_validation_mode         IN   VARCHAR2     := JTF_PLSQL_API.G_UPDATE
	)
IS
BEGIN
      -- Initialize message list if p_init_msg_list is set to TRUE.
      IF FND_API.to_Boolean( p_init_msg_list )
      THEN
         FND_MSG_PUB.initialize;