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

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

Line: 51


       SELECT PV.PV_Attr_PrincipalS_s.NEXTVAL
       FROM dual;

Line: 55


       SELECT 1
       FROM PV_Attr_PrincipalS
       WHERE Attr_Principal_ID = l_id;

Line: 126


           l_Attr_Principal_rec.last_update_date      := SYSDATE;

Line: 127


           l_Attr_Principal_rec.last_updated_by       := G_USER_ID;

Line: 130


           l_Attr_Principal_rec.last_update_login     := G_LOGIN_ID;

Line: 159


       PV_Attr_PrincipalS_PKG.Insert_Row(
           px_Attr_Principal_id    => l_Attr_Principal_rec.Attr_Principal_id
          ,p_last_update_date       => l_Attr_Principal_rec.last_update_date
          ,p_last_updated_by        => l_Attr_Principal_rec.last_updated_by
          ,p_creation_date          => l_Attr_Principal_rec.creation_date
          ,p_created_by             => l_Attr_Principal_rec.created_by
          ,p_last_update_login      => l_Attr_Principal_rec.last_update_login
          ,px_object_version_number => l_Attr_Principal_rec.object_version_number
          ,p_attribute_id           => l_Attr_Principal_rec.attribute_id
          ,p_jtf_auth_principal_id  => l_Attr_Principal_rec.jtf_auth_principal_id
          --p_security_group_id  => l_Attr_Principal_rec.security_group_id
          );

Line: 242


 PROCEDURE Update_Attr_Principal(
     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_Attr_Principal_rec        IN   Attr_Principal_rec_type
    ,x_object_version_number      OUT NOCOPY  NUMBER
    )
  IS

 CURSOR c_get_Attr_Principal(cv_Attr_Principal_id NUMBER) IS
     SELECT *
     FROM  PV_Attr_PrincipalS
     WHERE Attr_Principal_id = cv_Attr_Principal_id;

Line: 262


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

Line: 274


       SAVEPOINT UPDATE_Attr_Principal_PVT;

Line: 302


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

Line: 312


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

Line: 333


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

Line: 360


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

Line: 377


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

Line: 381


       PV_Attr_PrincipalS_PKG.Update_Row(
           p_Attr_Principal_id     => p_Attr_Principal_rec.Attr_Principal_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_Attr_Principal_rec.object_version_number
          ,p_attribute_id           => p_Attr_Principal_rec.attribute_id
          ,p_jtf_auth_principal_id  => p_Attr_Principal_rec.jtf_auth_principal_id
          --p_security_group_id  => p_Attr_Principal_rec.security_group_id
          );

Line: 423


      ROLLBACK TO UPDATE_Attr_Principal_PVT;

Line: 433


      ROLLBACK TO UPDATE_Attr_Principal_PVT;

Line: 443


      ROLLBACK TO UPDATE_Attr_Principal_PVT;

Line: 455


 End Update_Attr_Principal;

Line: 458


 PROCEDURE Delete_Attr_Principal(
     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_Attr_Principal_id         IN   NUMBER
    ,p_object_version_number      IN   NUMBER
    )

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

Line: 480


       SAVEPOINT DELETE_Attr_Principal_PVT;

Line: 511


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

Line: 516


       PV_Attr_PrincipalS_PKG.Delete_Row(
           p_Attr_Principal_ID  => p_Attr_Principal_ID);

Line: 546


      ROLLBACK TO DELETE_Attr_Principal_PVT;

Line: 556


      ROLLBACK TO DELETE_Attr_Principal_PVT;

Line: 566


      ROLLBACK TO DELETE_Attr_Principal_PVT;

Line: 578


 End Delete_Attr_Principal;

Line: 602


    SELECT Attr_Principal_ID
    FROM PV_Attr_PrincipalS
    WHERE Attr_Principal_ID = p_Attr_Principal_ID
    AND object_version_number = p_object_version
    FOR UPDATE NOWAIT;

Line: 766


       IF p_Attr_Principal_rec.last_update_date = FND_API.g_miss_date
          OR p_Attr_Principal_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: 770


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

Line: 777


       IF p_Attr_Principal_rec.last_updated_by = FND_API.g_miss_num
          OR p_Attr_Principal_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: 781


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

Line: 856


       IF p_Attr_Principal_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: 859


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

Line: 866


       IF p_Attr_Principal_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: 869


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

Line: 1017


       SELECT *
       FROM pv_Attr_Principals
       WHERE Attr_Principal_id = p_Attr_Principal_rec.Attr_Principal_id;

Line: 1034


    IF p_Attr_Principal_rec.last_update_date = FND_API.g_miss_date THEN
       x_complete_rec.last_update_date := l_Attr_Principal_rec.last_update_date;

Line: 1039


    IF p_Attr_Principal_rec.last_updated_by = FND_API.g_miss_num THEN
       x_complete_rec.last_updated_by := l_Attr_Principal_rec.last_updated_by;

Line: 1054


    IF p_Attr_Principal_rec.last_update_login = FND_API.g_miss_num THEN
       x_complete_rec.last_update_login := l_Attr_Principal_rec.last_update_login;

Line: 1086


    ,p_validation_mode            IN   VARCHAR2     := JTF_PLSQL_API.G_UPDATE
    ,p_Attr_Principal_rec        IN   Attr_Principal_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_Attr_Principal';

Line: 1220


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