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

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

Line: 116


      PV_ENTITY_RULES_APPLIED_PKG.Insert_Row(
          px_ENTITY_RULE_APPLIED_ID  => x_ENTITY_RULE_APPLIED_ID
         ,p_LAST_UPDATE_DATE  => SYSDATE
         ,p_LAST_UPDATED_BY  => FND_GLOBAL.USER_ID
         ,p_CREATION_DATE  => SYSDATE
         ,p_CREATED_BY  => FND_GLOBAL.USER_ID
         ,p_LAST_UPDATE_LOGIN  => FND_GLOBAL.CONC_LOGIN_ID
         ,p_OBJECT_VERSION_NUMBER  => p_ENTYRLS_rec.OBJECT_VERSION_NUMBER
         ,p_REQUEST_ID  => p_ENTYRLS_rec.REQUEST_ID
         ,p_PROGRAM_APPLICATION_ID  => p_ENTYRLS_rec.PROGRAM_APPLICATION_ID
         ,p_PROGRAM_ID  => p_ENTYRLS_rec.PROGRAM_ID
         ,p_PROGRAM_UPDATE_DATE  => p_ENTYRLS_rec.PROGRAM_UPDATE_DATE
         ,p_ENTITY  => p_ENTYRLS_rec.ENTITY
         ,p_ENTITY_ID  => p_ENTYRLS_rec.ENTITY_ID
         ,p_PROCESS_RULE_ID  => p_ENTYRLS_rec.PROCESS_RULE_ID
         ,p_PARENT_PROCESS_RULE_ID  => p_ENTYRLS_rec.PARENT_PROCESS_RULE_ID
         ,p_LATEST_FLAG  => p_ENTYRLS_rec.LATEST_FLAG
         ,p_ACTION_VALUE  => p_ENTYRLS_rec.ACTION_VALUE
         ,p_PROCESS_TYPE  => p_ENTYRLS_rec.PROCESS_TYPE
         ,p_WINNING_RULE_FLAG  => p_ENTYRLS_rec.WINNING_RULE_FLAG
         ,p_ENTITY_DETAIL  => p_ENTYRLS_rec.ENTITY_DETAIL
         ,p_ATTRIBUTE_CATEGORY  => p_ENTYRLS_rec.ATTRIBUTE_CATEGORY
         ,p_ATTRIBUTE1  => p_ENTYRLS_rec.ATTRIBUTE1
         ,p_ATTRIBUTE2  => p_ENTYRLS_rec.ATTRIBUTE2
         ,p_ATTRIBUTE3  => p_ENTYRLS_rec.ATTRIBUTE3
         ,p_ATTRIBUTE4  => p_ENTYRLS_rec.ATTRIBUTE4
         ,p_ATTRIBUTE5  => p_ENTYRLS_rec.ATTRIBUTE5
         ,p_ATTRIBUTE6  => p_ENTYRLS_rec.ATTRIBUTE6
         ,p_ATTRIBUTE7  => p_ENTYRLS_rec.ATTRIBUTE7
         ,p_ATTRIBUTE8  => p_ENTYRLS_rec.ATTRIBUTE8
         ,p_ATTRIBUTE9  => p_ENTYRLS_rec.ATTRIBUTE9
         ,p_ATTRIBUTE10  => p_ENTYRLS_rec.ATTRIBUTE10
         ,p_ATTRIBUTE11  => p_ENTYRLS_rec.ATTRIBUTE11
         ,p_ATTRIBUTE12  => p_ENTYRLS_rec.ATTRIBUTE12
         ,p_ATTRIBUTE13  => p_ENTYRLS_rec.ATTRIBUTE13
         ,p_ATTRIBUTE14  => p_ENTYRLS_rec.ATTRIBUTE14
         ,p_ATTRIBUTE15  => p_ENTYRLS_rec.ATTRIBUTE15
         ,p_PROCESS_STATUS  => p_ENTYRLS_rec.PROCESS_STATUS);

Line: 221


PROCEDURE Update_entyrls(
    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,
    P_Identity_Resource_Id     IN   NUMBER,
    P_ENTYRLS_Rec     IN    PV_RULE_RECTYPE_PUB.ENTYRLS_Rec_Type,
    X_Return_Status              OUT NOCOPY  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY  NUMBER,
    X_Msg_Data                   OUT NOCOPY  VARCHAR2
    )

 IS
Cursor C_Get_entyrls(pc_ENTITY_RULE_APPLIED_ID Number) IS
    Select object_version_number
    From  PV_ENTITY_RULES_APPLIED
    where entity_rule_applied_id = pc_entity_rule_applied_id
    For Update NOWAIT;

Line: 240


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

Line: 248


      SAVEPOINT UPDATE_ENTYRLS_PVT;

Line: 284


      AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Open Cursor to Select');

Line: 295


               FND_MESSAGE.Set_Name('PV', 'API_MISSING_UPDATE_TARGET');

Line: 341


          p_validation_mode  => AS_UTILITY_PVT.G_UPDATE,
          P_ENTYRLS_Rec  =>  P_ENTYRLS_Rec,
          x_return_status    => x_return_status,
          x_msg_count        => x_msg_count,
          x_msg_data         => x_msg_data);

Line: 356


      AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');

Line: 360


      PV_ENTITY_RULES_APPLIED_PKG.Update_Row(
          p_ENTITY_RULE_APPLIED_ID  => p_ENTYRLS_rec.ENTITY_RULE_APPLIED_ID
         ,p_LAST_UPDATE_DATE  => SYSDATE
         ,p_LAST_UPDATED_BY  => FND_GLOBAL.USER_ID
         ,p_CREATION_DATE  => FND_API.G_MISS_DATE
         ,p_CREATED_BY     => FND_API.G_MISS_NUM
         ,p_LAST_UPDATE_LOGIN  => FND_GLOBAL.CONC_LOGIN_ID
         ,p_OBJECT_VERSION_NUMBER  => p_ENTYRLS_rec.OBJECT_VERSION_NUMBER
         ,p_REQUEST_ID  => p_ENTYRLS_rec.REQUEST_ID
         ,p_PROGRAM_APPLICATION_ID  => p_ENTYRLS_rec.PROGRAM_APPLICATION_ID
         ,p_PROGRAM_ID  => p_ENTYRLS_rec.PROGRAM_ID
         ,p_PROGRAM_UPDATE_DATE  => p_ENTYRLS_rec.PROGRAM_UPDATE_DATE
         ,p_ENTITY  => p_ENTYRLS_rec.ENTITY
         ,p_ENTITY_ID  => p_ENTYRLS_rec.ENTITY_ID
         ,p_PROCESS_RULE_ID  => p_ENTYRLS_rec.PROCESS_RULE_ID
         ,p_PARENT_PROCESS_RULE_ID  => p_ENTYRLS_rec.PARENT_PROCESS_RULE_ID
         ,p_LATEST_FLAG  => p_ENTYRLS_rec.LATEST_FLAG
         ,p_ACTION_VALUE  => p_ENTYRLS_rec.ACTION_VALUE
         ,p_PROCESS_TYPE  => p_ENTYRLS_rec.PROCESS_TYPE
         ,p_WINNING_RULE_FLAG  => p_ENTYRLS_rec.WINNING_RULE_FLAG
         ,p_ENTITY_DETAIL  => p_ENTYRLS_rec.ENTITY_DETAIL
         ,p_ATTRIBUTE_CATEGORY  => p_ENTYRLS_rec.ATTRIBUTE_CATEGORY
         ,p_ATTRIBUTE1  => p_ENTYRLS_rec.ATTRIBUTE1
         ,p_ATTRIBUTE2  => p_ENTYRLS_rec.ATTRIBUTE2
         ,p_ATTRIBUTE3  => p_ENTYRLS_rec.ATTRIBUTE3
         ,p_ATTRIBUTE4  => p_ENTYRLS_rec.ATTRIBUTE4
         ,p_ATTRIBUTE5  => p_ENTYRLS_rec.ATTRIBUTE5
         ,p_ATTRIBUTE6  => p_ENTYRLS_rec.ATTRIBUTE6
         ,p_ATTRIBUTE7  => p_ENTYRLS_rec.ATTRIBUTE7
         ,p_ATTRIBUTE8  => p_ENTYRLS_rec.ATTRIBUTE8
         ,p_ATTRIBUTE9  => p_ENTYRLS_rec.ATTRIBUTE9
         ,p_ATTRIBUTE10  => p_ENTYRLS_rec.ATTRIBUTE10
         ,p_ATTRIBUTE11  => p_ENTYRLS_rec.ATTRIBUTE11
         ,p_ATTRIBUTE12  => p_ENTYRLS_rec.ATTRIBUTE12
         ,p_ATTRIBUTE13  => p_ENTYRLS_rec.ATTRIBUTE13
         ,p_ATTRIBUTE14  => p_ENTYRLS_rec.ATTRIBUTE14
         ,p_ATTRIBUTE15  => p_ENTYRLS_rec.ATTRIBUTE15
         ,p_PROCESS_STATUS  => p_ENTYRLS_rec.PROCESS_STATUS);

Line: 454


End Update_entyrls;

Line: 459


PROCEDURE Delete_entyrls(
    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,
    P_Identity_Resource_Id     IN   NUMBER,
    P_ENTYRLS_Rec     IN PV_RULE_RECTYPE_PUB.ENTYRLS_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) := 'Delete_entyrls';

Line: 476


      SAVEPOINT DELETE_ENTYRLS_PVT;

Line: 512


      AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling delete table handler');

Line: 516


      PV_ENTITY_RULES_APPLIED_PKG.Delete_Row(
          p_ENTITY_RULE_APPLIED_ID  => p_ENTYRLS_rec.ENTITY_RULE_APPLIED_ID);

Line: 574


End Delete_entyrls;

Line: 588


    SELECT 'X'
    FROM  pv_entity_rules_applied
    WHERE entity_rule_applied_id = pc_entity_rule_applied_id;

Line: 619


      ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
      THEN
          -- validate NOT NULL column
          IF (p_entity_rule_applied_id IS NULL) OR
             (p_entity_rule_applied_id = FND_API.G_MISS_NUM)
          THEN
              AS_UTILITY_PVT.Set_Message(
                  p_msg_level     => FND_MSG_PUB.G_MSG_LVL_ERROR,
                  p_msg_name      => 'API_MISSING_LEAD_ID');