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_ATTRIBUTE_USAGE_PVT SQL Statements

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

Line: 51


       SELECT PV_ATTRIBUTE_USAGES_s.NEXTVAL
       FROM dual;

Line: 55


       SELECT 1
       FROM PV_ATTRIBUTE_USAGES
       WHERE ATTRIBUTE_USAGE_ID = l_id;

Line: 127


           l_attribute_usage_rec.last_update_date      := SYSDATE;

Line: 128


           l_attribute_usage_rec.last_updated_by       := G_USER_ID;

Line: 131


           l_attribute_usage_rec.last_update_login     := G_LOGIN_ID;

Line: 160


       PV_ATTRIBUTE_USAGES_PKG.Insert_Row(
           px_attribute_usage_id    => l_attribute_usage_rec.attribute_usage_id
          ,p_last_update_date       => l_attribute_usage_rec.last_update_date
          ,p_last_updated_by        => l_attribute_usage_rec.last_updated_by
          ,p_creation_date          => l_attribute_usage_rec.creation_date
          ,p_created_by             => l_attribute_usage_rec.created_by
          ,p_last_update_login      => l_attribute_usage_rec.last_update_login
          ,p_request_id             => l_attribute_usage_rec.request_id
          ,p_program_application_id => l_attribute_usage_rec.program_application_id
          ,p_program_id             => l_attribute_usage_rec.program_id
          ,p_program_update_date    => l_attribute_usage_rec.program_update_date
          ,px_object_version_number => l_attribute_usage_rec.object_version_number
          ,p_attribute_usage_type   => l_attribute_usage_rec.attribute_usage_type
          ,p_attribute_usage_code   => l_attribute_usage_rec.attribute_usage_code
          ,p_attribute_id           => l_attribute_usage_rec.attribute_id
          ,p_enabled_flag           => l_attribute_usage_rec.enabled_flag
          --p_security_group_id  => l_attribute_usage_rec.security_group_id
          );

Line: 249


 PROCEDURE Update_Attribute_Usage(
     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_attribute_usage_rec        IN   attribute_usage_rec_type
    ,x_object_version_number      OUT NOCOPY  NUMBER
    )
  IS

 CURSOR c_get_attribute_usage(cv_attribute_usage_id NUMBER) IS
     SELECT *
     FROM  PV_ATTRIBUTE_USAGES
     WHERE attribute_usage_id = cv_attribute_usage_id;

Line: 269


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

Line: 281


       SAVEPOINT UPDATE_Attribute_Usage_PVT;

Line: 309


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

Line: 319


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

Line: 340


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

Line: 367


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

Line: 384


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

Line: 388


       PV_ATTRIBUTE_USAGES_PKG.Update_Row(
           p_attribute_usage_id     => p_attribute_usage_rec.attribute_usage_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_request_id             => p_attribute_usage_rec.request_id
          ,p_program_application_id => p_attribute_usage_rec.program_application_id
          ,p_program_id             => p_attribute_usage_rec.program_id
          ,p_program_update_date    => p_attribute_usage_rec.program_update_date
          ,p_object_version_number  => p_attribute_usage_rec.object_version_number
          ,p_attribute_usage_type   => p_attribute_usage_rec.attribute_usage_type
          ,p_attribute_usage_code   => p_attribute_usage_rec.attribute_usage_code
          ,p_attribute_id           => p_attribute_usage_rec.attribute_id
          ,p_enabled_flag           => p_attribute_usage_rec.enabled_flag
          --p_security_group_id  => p_attribute_usage_rec.security_group_id
          );

Line: 436


      ROLLBACK TO UPDATE_Attribute_Usage_PVT;

Line: 446


      ROLLBACK TO UPDATE_Attribute_Usage_PVT;

Line: 456


      ROLLBACK TO UPDATE_Attribute_Usage_PVT;

Line: 468


 End Update_Attribute_Usage;

Line: 471


 PROCEDURE Delete_Attribute_Usage(
     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_attribute_usage_id         IN   NUMBER
    ,p_object_version_number      IN   NUMBER
    )

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

Line: 493


       SAVEPOINT DELETE_Attribute_Usage_PVT;

Line: 524


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

Line: 529


       PV_ATTRIBUTE_USAGES_PKG.Delete_Row(
           p_ATTRIBUTE_USAGE_ID  => p_ATTRIBUTE_USAGE_ID);

Line: 559


      ROLLBACK TO DELETE_Attribute_Usage_PVT;

Line: 569


      ROLLBACK TO DELETE_Attribute_Usage_PVT;

Line: 579


      ROLLBACK TO DELETE_Attribute_Usage_PVT;

Line: 591


 End Delete_Attribute_Usage;

Line: 615


    SELECT ATTRIBUTE_USAGE_ID
    FROM PV_ATTRIBUTE_USAGES
    WHERE ATTRIBUTE_USAGE_ID = p_ATTRIBUTE_USAGE_ID
    AND object_version_number = p_object_version
    FOR UPDATE NOWAIT;

Line: 781


       IF p_attribute_usage_rec.last_update_date = FND_API.g_miss_date
          OR p_attribute_usage_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: 785


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

Line: 793


       IF p_attribute_usage_rec.last_updated_by = FND_API.g_miss_num
          OR p_attribute_usage_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: 797


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

Line: 901


       IF p_attribute_usage_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: 904


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

Line: 912


       IF p_attribute_usage_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: 915


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

Line: 1089


       SELECT *
       FROM pv_attribute_usages
       WHERE attribute_usage_id = p_attribute_usage_rec.attribute_usage_id;

Line: 1107


    IF p_attribute_usage_rec.last_update_date = FND_API.g_miss_date THEN
       x_complete_rec.last_update_date := l_attribute_usage_rec.last_update_date;

Line: 1112


    IF p_attribute_usage_rec.last_updated_by = FND_API.g_miss_num THEN
       x_complete_rec.last_updated_by := l_attribute_usage_rec.last_updated_by;

Line: 1127


    IF p_attribute_usage_rec.last_update_login = FND_API.g_miss_num THEN
       x_complete_rec.last_update_login := l_attribute_usage_rec.last_update_login;

Line: 1147


    IF p_attribute_usage_rec.program_update_date = FND_API.g_miss_date THEN
       x_complete_rec.program_update_date := l_attribute_usage_rec.program_update_date;

Line: 1188


    ,p_validation_mode            IN   VARCHAR2     := JTF_PLSQL_API.G_UPDATE
    ,p_attribute_usage_rec        IN   attribute_usage_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_Attribute_Usage';

Line: 1326


    ,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;