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.CSP_RS_CUST_RELATION_PVT SQL Statements

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

Line: 123


      CSP_RS_CUST_RELATIONS_PKG.Insert_Row(
          px_RS_CUST_RELATION_ID  => x_RS_CUST_RELATION_ID,
          p_RESOURCE_TYPE  => p_RCR_rec.RESOURCE_TYPE,
          p_RESOURCE_ID  => p_RCR_rec.RESOURCE_ID,
          p_CUSTOMER_ID  => p_RCR_rec.CUSTOMER_ID,
          p_CREATED_BY  => FND_GLOBAL.USER_ID,
          p_CREATION_DATE  => SYSDATE,
          p_LAST_UPDATED_BY  => FND_GLOBAL.USER_ID,
          p_LAST_UPDATE_DATE  => SYSDATE,
          p_LAST_UPDATE_LOGIN  => FND_GLOBAL.CONC_LOGIN_ID,
          p_ATTRIBUTE_CATEGORY  => p_RCR_rec.ATTRIBUTE_CATEGORY,
          p_ATTRIBUTE1  => p_RCR_rec.ATTRIBUTE1,
          p_ATTRIBUTE2  => p_RCR_rec.ATTRIBUTE2,
          p_ATTRIBUTE3  => p_RCR_rec.ATTRIBUTE3,
          p_ATTRIBUTE4  => p_RCR_rec.ATTRIBUTE4,
          p_ATTRIBUTE5  => p_RCR_rec.ATTRIBUTE5,
          p_ATTRIBUTE6  => p_RCR_rec.ATTRIBUTE6,
          p_ATTRIBUTE7  => p_RCR_rec.ATTRIBUTE7,
          p_ATTRIBUTE8  => p_RCR_rec.ATTRIBUTE8,
          p_ATTRIBUTE9  => p_RCR_rec.ATTRIBUTE9,
          p_ATTRIBUTE10  => p_RCR_rec.ATTRIBUTE10,
          p_ATTRIBUTE11  => p_RCR_rec.ATTRIBUTE11,
          p_ATTRIBUTE12  => p_RCR_rec.ATTRIBUTE12,
          p_ATTRIBUTE13  => p_RCR_rec.ATTRIBUTE13,
          p_ATTRIBUTE14  => p_RCR_rec.ATTRIBUTE14,
          p_ATTRIBUTE15  => p_RCR_rec.ATTRIBUTE15);

Line: 213


PROCEDURE Update_rs_cust_relation(
    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_Salesforce_Id     IN   NUMBER       := NULL,
    P_RCR_Rec     IN    RCR_Rec_Type,
    X_Return_Status              OUT NOCOPY  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY  NUMBER,
    X_Msg_Data                   OUT NOCOPY  VARCHAR2
    )

 IS
/*
Cursor C_Get_rs_cust_relation(RS_CUST_RELATION_ID Number) IS
    Select rowid,
           RS_CUST_RELATION_ID,
           RESOURCE_TYPE,
           RESOURCE_ID,
           CUSTOMER_ID,
           CREATED_BY,
           CREATION_DATE,
           LAST_UPDATED_BY,
           LAST_UPDATE_DATE,
           LAST_UPDATE_LOGIN,
           ATTRIBUTE_CATEGORY,
           ATTRIBUTE1,
           ATTRIBUTE2,
           ATTRIBUTE3,
           ATTRIBUTE4,
           ATTRIBUTE5,
           ATTRIBUTE6,
           ATTRIBUTE7,
           ATTRIBUTE8,
           ATTRIBUTE9,
           ATTRIBUTE10,
           ATTRIBUTE11,
           ATTRIBUTE12,
           ATTRIBUTE13,
           ATTRIBUTE14,
           ATTRIBUTE15
    From  CSP_RS_CUST_RELATIONS
    -- Hint: Developer need to provide Where clause
    For Update NOWAIT;

Line: 258


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

Line: 267


      SAVEPOINT UPDATE_RS_CUST_RELATION_PVT;

Line: 317


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

Line: 330


               l_ref_RCR_rec.LAST_UPDATED_BY,
               l_ref_RCR_rec.LAST_UPDATE_DATE,
               l_ref_RCR_rec.LAST_UPDATE_LOGIN,
               l_ref_RCR_rec.ATTRIBUTE_CATEGORY,
               l_ref_RCR_rec.ATTRIBUTE1,
               l_ref_RCR_rec.ATTRIBUTE2,
               l_ref_RCR_rec.ATTRIBUTE3,
               l_ref_RCR_rec.ATTRIBUTE4,
               l_ref_RCR_rec.ATTRIBUTE5,
               l_ref_RCR_rec.ATTRIBUTE6,
               l_ref_RCR_rec.ATTRIBUTE7,
               l_ref_RCR_rec.ATTRIBUTE8,
               l_ref_RCR_rec.ATTRIBUTE9,
               l_ref_RCR_rec.ATTRIBUTE10,
               l_ref_RCR_rec.ATTRIBUTE11,
               l_ref_RCR_rec.ATTRIBUTE12,
               l_ref_RCR_rec.ATTRIBUTE13,
               l_ref_RCR_rec.ATTRIBUTE14,
               l_ref_RCR_rec.ATTRIBUTE15;

Line: 353


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

Line: 366


      If (l_tar_RCR_rec.last_update_date is NULL or
          l_tar_RCR_rec.last_update_date = FND_API.G_MISS_Date ) Then
          IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
          THEN
              FND_MESSAGE.Set_Name('CSP', 'API_MISSING_ID');

Line: 371


              FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);

Line: 377


      If (l_tar_RCR_rec.last_update_date <> l_ref_RCR_rec.last_update_date) Then
          IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
          THEN
              FND_MESSAGE.Set_Name('CSP', 'API_RECORD_CHANGED');

Line: 394


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

Line: 407


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

Line: 410


      CSP_RS_CUST_RELATIONS_PKG.Update_Row(
          p_RS_CUST_RELATION_ID  => p_RCR_rec.RS_CUST_RELATION_ID,
          p_RESOURCE_TYPE  => p_RCR_rec.RESOURCE_TYPE,
          p_RESOURCE_ID  => p_RCR_rec.RESOURCE_ID,
          p_CUSTOMER_ID  => p_RCR_rec.CUSTOMER_ID,
          p_CREATED_BY     => FND_API.G_MISS_NUM,
          p_CREATION_DATE  => FND_API.G_MISS_DATE,
          p_LAST_UPDATED_BY  => FND_GLOBAL.USER_ID,
          p_LAST_UPDATE_DATE  => SYSDATE,
          p_LAST_UPDATE_LOGIN  => FND_GLOBAL.CONC_LOGIN_ID,
          p_ATTRIBUTE_CATEGORY  => p_RCR_rec.ATTRIBUTE_CATEGORY,
          p_ATTRIBUTE1  => p_RCR_rec.ATTRIBUTE1,
          p_ATTRIBUTE2  => p_RCR_rec.ATTRIBUTE2,
          p_ATTRIBUTE3  => p_RCR_rec.ATTRIBUTE3,
          p_ATTRIBUTE4  => p_RCR_rec.ATTRIBUTE4,
          p_ATTRIBUTE5  => p_RCR_rec.ATTRIBUTE5,
          p_ATTRIBUTE6  => p_RCR_rec.ATTRIBUTE6,
          p_ATTRIBUTE7  => p_RCR_rec.ATTRIBUTE7,
          p_ATTRIBUTE8  => p_RCR_rec.ATTRIBUTE8,
          p_ATTRIBUTE9  => p_RCR_rec.ATTRIBUTE9,
          p_ATTRIBUTE10  => p_RCR_rec.ATTRIBUTE10,
          p_ATTRIBUTE11  => p_RCR_rec.ATTRIBUTE11,
          p_ATTRIBUTE12  => p_RCR_rec.ATTRIBUTE12,
          p_ATTRIBUTE13  => p_RCR_rec.ATTRIBUTE13,
          p_ATTRIBUTE14  => p_RCR_rec.ATTRIBUTE14,
          p_ATTRIBUTE15  => p_RCR_rec.ATTRIBUTE15);

Line: 489


End Update_rs_cust_relation;

Line: 494


PROCEDURE Delete_rs_cust_relation(
    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_Salesforce_Id     IN   NUMBER       := NULL,
    P_RCR_Rec     IN RCR_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_rs_cust_relation';

Line: 512


      SAVEPOINT DELETE_RS_CUST_RELATION_PVT;

Line: 563


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

Line: 566


      CSP_RS_CUST_RELATIONS_PKG.Delete_Row(
          p_RS_CUST_RELATION_ID  => p_RCR_rec.RS_CUST_RELATION_ID);

Line: 621


End Delete_rs_cust_relation;

Line: 762


PROCEDURE Gen_Select(
    x_select_cl   OUT NOCOPY   VARCHAR2
)
IS
BEGIN
      -- Debug Message
      AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Select Begins');

Line: 770


      x_select_cl := 'Select ' ||
                'CSP_RS_CUST_RELATIONS.RS_CUST_RELATION_ID,' ||
                'CSP_RS_CUST_RELATIONS.RESOURCE_TYPE,' ||
                'CSP_RS_CUST_RELATIONS.RESOURCE_ID,' ||
                'CSP_RS_CUST_RELATIONS.CUSTOMER_ID,' ||
                'CSP_RS_CUST_RELATIONS.CREATED_BY,' ||
                'CSP_RS_CUST_RELATIONS.CREATION_DATE,' ||
                'CSP_RS_CUST_RELATIONS.LAST_UPDATED_BY,' ||
                'CSP_RS_CUST_RELATIONS.LAST_UPDATE_DATE,' ||
                'CSP_RS_CUST_RELATIONS.LAST_UPDATE_LOGIN,' ||
                'CSP_RS_CUST_RELATIONS.ATTRIBUTE_CATEGORY,' ||
                'CSP_RS_CUST_RELATIONS.ATTRIBUTE1,' ||
                'CSP_RS_CUST_RELATIONS.ATTRIBUTE2,' ||
                'CSP_RS_CUST_RELATIONS.ATTRIBUTE3,' ||
                'CSP_RS_CUST_RELATIONS.ATTRIBUTE4,' ||
                'CSP_RS_CUST_RELATIONS.ATTRIBUTE5,' ||
                'CSP_RS_CUST_RELATIONS.ATTRIBUTE6,' ||
                'CSP_RS_CUST_RELATIONS.ATTRIBUTE7,' ||
                'CSP_RS_CUST_RELATIONS.ATTRIBUTE8,' ||
                'CSP_RS_CUST_RELATIONS.ATTRIBUTE9,' ||
                'CSP_RS_CUST_RELATIONS.ATTRIBUTE10,' ||
                'CSP_RS_CUST_RELATIONS.ATTRIBUTE11,' ||
                'CSP_RS_CUST_RELATIONS.ATTRIBUTE12,' ||
                'CSP_RS_CUST_RELATIONS.ATTRIBUTE13,' ||
                'CSP_RS_CUST_RELATIONS.ATTRIBUTE14,' ||
                'CSP_RS_CUST_RELATIONS.ATTRIBUTE15 ' ||
                'from CSP_RS_CUST_RELATIONS';

Line: 798


      AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Select Ends');

Line: 800


END Gen_Select;

Line: 810


    SELECT INSTR(p_rec_item, '%', 1, 1)
    FROM DUAL;

Line: 813


    SELECT INSTR(p_rec_item, '_', 1, 1)
    FROM DUAL;

Line: 950


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

Line: 1004


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

Line: 1058


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

Line: 1112


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