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

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

Line: 115


      PV_ENTITY_ROUTINGS_PKG.Insert_Row(
          px_ENTITY_ROUTING_ID  => x_ENTITY_ROUTING_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_ENTYROUT_rec.OBJECT_VERSION_NUMBER
         ,p_REQUEST_ID  => p_ENTYROUT_rec.REQUEST_ID
         ,p_PROGRAM_APPLICATION_ID  => p_ENTYROUT_rec.PROGRAM_APPLICATION_ID
         ,p_PROGRAM_ID  => p_ENTYROUT_rec.PROGRAM_ID
         ,p_PROGRAM_UPDATE_DATE  => p_ENTYROUT_rec.PROGRAM_UPDATE_DATE
         ,p_PROCESS_RULE_ID  => p_ENTYROUT_rec.PROCESS_RULE_ID
         ,p_DISTANCE_FROM_CUSTOMER  => p_ENTYROUT_rec.DISTANCE_FROM_CUSTOMER
         ,p_DISTANCE_UOM_CODE  => p_ENTYROUT_rec.DISTANCE_UOM_CODE
         ,p_MAX_NEAREST_PARTNER  => p_ENTYROUT_rec.MAX_NEAREST_PARTNER
         ,p_ROUTING_TYPE  => p_ENTYROUT_rec.ROUTING_TYPE
         ,p_BYPASS_CM_OK_FLAG  => p_ENTYROUT_rec.BYPASS_CM_OK_FLAG
         ,p_CM_TIMEOUT  => p_ENTYROUT_rec.CM_TIMEOUT
         ,p_CM_TIMEOUT_UOM_CODE  => p_ENTYROUT_rec.CM_TIMEOUT_UOM_CODE
         ,p_PARTNER_TIMEOUT  => p_ENTYROUT_rec.PARTNER_TIMEOUT
         ,p_PARTNER_TIMEOUT_UOM_CODE  => p_ENTYROUT_rec.PARTNER_TIMEOUT_UOM_CODE
         ,p_UNMATCHED_INT_RESOURCE_ID  => p_ENTYROUT_rec.UNMATCHED_INT_RESOURCE_ID
         ,p_UNMATCHED_CALL_TAP_FLAG  => p_ENTYROUT_rec.UNMATCHED_CALL_TAP_FLAG
         ,p_ATTRIBUTE_CATEGORY  => p_ENTYROUT_rec.ATTRIBUTE_CATEGORY
         ,p_ATTRIBUTE1  => p_ENTYROUT_rec.ATTRIBUTE1
         ,p_ATTRIBUTE2  => p_ENTYROUT_rec.ATTRIBUTE2
         ,p_ATTRIBUTE3  => p_ENTYROUT_rec.ATTRIBUTE3
         ,p_ATTRIBUTE4  => p_ENTYROUT_rec.ATTRIBUTE4
         ,p_ATTRIBUTE5  => p_ENTYROUT_rec.ATTRIBUTE5
         ,p_ATTRIBUTE6  => p_ENTYROUT_rec.ATTRIBUTE6
         ,p_ATTRIBUTE7  => p_ENTYROUT_rec.ATTRIBUTE7
         ,p_ATTRIBUTE8  => p_ENTYROUT_rec.ATTRIBUTE8
         ,p_ATTRIBUTE9  => p_ENTYROUT_rec.ATTRIBUTE9
         ,p_ATTRIBUTE10  => p_ENTYROUT_rec.ATTRIBUTE10
         ,p_ATTRIBUTE11  => p_ENTYROUT_rec.ATTRIBUTE11
         ,p_ATTRIBUTE12  => p_ENTYROUT_rec.ATTRIBUTE12
         ,p_ATTRIBUTE13  => p_ENTYROUT_rec.ATTRIBUTE13
         ,p_ATTRIBUTE14  => p_ENTYROUT_rec.ATTRIBUTE14
         ,p_ATTRIBUTE15  => p_ENTYROUT_rec.ATTRIBUTE15
);      -- Hint: Primary key should be returned.

Line: 222


PROCEDURE Update_entyrout(
    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_ENTYROUT_Rec             IN   PV_RULE_RECTYPE_PUB.ENTYROUT_Rec_Type,
    X_Return_Status              OUT NOCOPY  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY  NUMBER,
    X_Msg_Data                   OUT NOCOPY  VARCHAR2
    )

 IS

Cursor C_Get_entyrout(pc_ENTITY_ROUTING_ID Number) IS
    Select
           object_version_number
    From  PV_ENTITY_ROUTINGS
    where entity_routing_id = pc_entity_routing_id
    For Update NOWAIT;

Line: 243


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

Line: 251


      SAVEPOINT UPDATE_ENTYROUT_PVT;

Line: 287


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

Line: 298


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

Line: 344


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

Line: 359


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

Line: 363


      PV_ENTITY_ROUTINGS_PKG.Update_Row(
          p_ENTITY_ROUTING_ID  => p_ENTYROUT_rec.ENTITY_ROUTING_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_ENTYROUT_rec.OBJECT_VERSION_NUMBER
         ,p_REQUEST_ID  => p_ENTYROUT_rec.REQUEST_ID
         ,p_PROGRAM_APPLICATION_ID  => p_ENTYROUT_rec.PROGRAM_APPLICATION_ID
         ,p_PROGRAM_ID  => p_ENTYROUT_rec.PROGRAM_ID
         ,p_PROGRAM_UPDATE_DATE  => p_ENTYROUT_rec.PROGRAM_UPDATE_DATE
         ,p_PROCESS_RULE_ID  => p_ENTYROUT_rec.PROCESS_RULE_ID
         ,p_DISTANCE_FROM_CUSTOMER  => p_ENTYROUT_rec.DISTANCE_FROM_CUSTOMER
         ,p_DISTANCE_UOM_CODE  => p_ENTYROUT_rec.DISTANCE_UOM_CODE
         ,p_MAX_NEAREST_PARTNER  => p_ENTYROUT_rec.MAX_NEAREST_PARTNER
         ,p_ROUTING_TYPE  => p_ENTYROUT_rec.ROUTING_TYPE
         ,p_BYPASS_CM_OK_FLAG  => p_ENTYROUT_rec.BYPASS_CM_OK_FLAG
         ,p_CM_TIMEOUT  => p_ENTYROUT_rec.CM_TIMEOUT
         ,p_CM_TIMEOUT_UOM_CODE  => p_ENTYROUT_rec.CM_TIMEOUT_UOM_CODE
         ,p_PARTNER_TIMEOUT  => p_ENTYROUT_rec.PARTNER_TIMEOUT
         ,p_PARTNER_TIMEOUT_UOM_CODE  => p_ENTYROUT_rec.PARTNER_TIMEOUT_UOM_CODE
         ,p_UNMATCHED_INT_RESOURCE_ID  => p_ENTYROUT_rec.UNMATCHED_INT_RESOURCE_ID
         ,p_UNMATCHED_CALL_TAP_FLAG  => p_ENTYROUT_rec.UNMATCHED_CALL_TAP_FLAG
         ,p_ATTRIBUTE_CATEGORY  => p_ENTYROUT_rec.ATTRIBUTE_CATEGORY
         ,p_ATTRIBUTE1  => p_ENTYROUT_rec.ATTRIBUTE1
         ,p_ATTRIBUTE2  => p_ENTYROUT_rec.ATTRIBUTE2
         ,p_ATTRIBUTE3  => p_ENTYROUT_rec.ATTRIBUTE3
         ,p_ATTRIBUTE4  => p_ENTYROUT_rec.ATTRIBUTE4
         ,p_ATTRIBUTE5  => p_ENTYROUT_rec.ATTRIBUTE5
         ,p_ATTRIBUTE6  => p_ENTYROUT_rec.ATTRIBUTE6
         ,p_ATTRIBUTE7  => p_ENTYROUT_rec.ATTRIBUTE7
         ,p_ATTRIBUTE8  => p_ENTYROUT_rec.ATTRIBUTE8
         ,p_ATTRIBUTE9  => p_ENTYROUT_rec.ATTRIBUTE9
         ,p_ATTRIBUTE10  => p_ENTYROUT_rec.ATTRIBUTE10
         ,p_ATTRIBUTE11  => p_ENTYROUT_rec.ATTRIBUTE11
         ,p_ATTRIBUTE12  => p_ENTYROUT_rec.ATTRIBUTE12
         ,p_ATTRIBUTE13  => p_ENTYROUT_rec.ATTRIBUTE13
         ,p_ATTRIBUTE14  => p_ENTYROUT_rec.ATTRIBUTE14
         ,p_ATTRIBUTE15  => p_ENTYROUT_rec.ATTRIBUTE15
);      --

Line: 459


End Update_entyrout;

Line: 464


PROCEDURE Delete_entyrout(
    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_ENTYROUT_Rec             IN   PV_RULE_RECTYPE_PUB.ENTYROUT_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_entyrout';

Line: 481


      SAVEPOINT DELETE_ENTYROUT_PVT;

Line: 516


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

Line: 520


      PV_ENTITY_ROUTINGS_PKG.Delete_Row(
          p_ENTITY_ROUTING_ID  => p_ENTYROUT_rec.ENTITY_ROUTING_ID);

Line: 578


End Delete_entyrout;

Line: 592


      SELECT 'X'
      FROM  pv_entity_routings
      WHERE entity_routing_id = pc_entity_routing_id;

Line: 623


      ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
      THEN
          -- validate NOT NULL column
          IF (p_entity_routing_id IS NULL) OR
             (p_entity_routing_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');

Line: 691


      ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
      THEN
          -- Hint: Validate data
          -- IF p_UNMATCHED_INT_RESOURCE_ID <> G_MISS_CHAR
          -- verify if data is valid
          -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;