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

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

Line: 37


l_last_updated_by NUMBER := P_CSP_Rec.last_updated_by;

Line: 38


l_last_update_login NUMBER := P_CSP_Rec.last_update_login;

Line: 147


      IF p_CSP_rec.last_updated_by IS NULL THEN
        l_last_updated_by := G_USER_ID;

Line: 151


      IF p_CSP_rec.last_update_login IS NULL THEN
       l_last_update_login := G_LOGIN_ID;

Line: 156


      CSP_INV_LOC_ASSIGNMENTS_PKG.Insert_Row(
          px_CSP_INV_LOC_ASSIGNMENT_ID  => x_CSP_INV_LOC_ASSIGNMENT_ID,
          p_CREATED_BY  =>  l_created_by,
          p_CREATION_DATE  => SYSDATE,
          p_LAST_UPDATED_BY  => l_last_updated_by,
          p_LAST_UPDATE_DATE  => SYSDATE,
          p_LAST_UPDATE_LOGIN  =>  l_last_update_login,
          p_RESOURCE_ID  => p_CSP_rec.RESOURCE_ID,
          p_ORGANIZATION_ID  => p_CSP_rec.ORGANIZATION_ID,
          p_SUBINVENTORY_CODE  => p_CSP_rec.SUBINVENTORY_CODE,
          p_LOCATOR_ID  => p_CSP_rec.LOCATOR_ID,
          p_RESOURCE_TYPE  => p_CSP_rec.RESOURCE_TYPE,
          p_EFFECTIVE_DATE_START  => p_CSP_rec.EFFECTIVE_DATE_START,
          p_EFFECTIVE_DATE_END  => p_CSP_rec.EFFECTIVE_DATE_END,
          p_DEFAULT_CODE  => p_CSP_rec.DEFAULT_CODE,
          p_ATTRIBUTE_CATEGORY  => p_CSP_rec.ATTRIBUTE_CATEGORY,
          p_ATTRIBUTE1  => p_CSP_rec.ATTRIBUTE1,
          p_ATTRIBUTE2  => p_CSP_rec.ATTRIBUTE2,
          p_ATTRIBUTE3  => p_CSP_rec.ATTRIBUTE3,
          p_ATTRIBUTE4  => p_CSP_rec.ATTRIBUTE4,
          p_ATTRIBUTE5  => p_CSP_rec.ATTRIBUTE5,
          p_ATTRIBUTE6  => p_CSP_rec.ATTRIBUTE6,
          p_ATTRIBUTE7  => p_CSP_rec.ATTRIBUTE7,
          p_ATTRIBUTE8  => p_CSP_rec.ATTRIBUTE8,
          p_ATTRIBUTE9  => p_CSP_rec.ATTRIBUTE9,
          p_ATTRIBUTE10  => p_CSP_rec.ATTRIBUTE10,
          p_ATTRIBUTE11  => p_CSP_rec.ATTRIBUTE11,
          p_ATTRIBUTE12  => p_CSP_rec.ATTRIBUTE12,
          p_ATTRIBUTE13  => p_CSP_rec.ATTRIBUTE13,
          p_ATTRIBUTE14  => p_CSP_rec.ATTRIBUTE14,
          p_ATTRIBUTE15  => p_CSP_rec.ATTRIBUTE15);

Line: 265


PROCEDURE Update_resource(
    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_CSP_Rec     IN    CSP_Rec_Type,
    X_Return_Status              OUT NOCOPY  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY  NUMBER,
    X_Msg_Data                   OUT NOCOPY  VARCHAR2
    )

 IS
/*
Cursor C_Get_resource(CSP_INV_LOC_ASSIGNMENT_ID Number) IS
    Select rowid,
           CSP_INV_LOC_ASSIGNMENT_ID,
           CREATED_BY,
           CREATION_DATE,
           LAST_UPDATED_BY,
           LAST_UPDATE_DATE,
           LAST_UPDATE_LOGIN,
           RESOURCE_ID,
           ORGANIZATION_ID,
           SUBINVENTORY_CODE,
           LOCATOR_ID,
           RESOURCE_TYPE,
           EFFECTIVE_DATE_START,
           EFFECTIVE_DATE_END,
           DEFAULT_CODE,
           ATTRIBUTE_CATEGORY,
           ATTRIBUTE1,
           ATTRIBUTE2,
           ATTRIBUTE3,
           ATTRIBUTE4,
           ATTRIBUTE5,
           ATTRIBUTE6,
           ATTRIBUTE7,
           ATTRIBUTE8,
           ATTRIBUTE9,
           ATTRIBUTE10,
           ATTRIBUTE11,
           ATTRIBUTE12,
           ATTRIBUTE13,
           ATTRIBUTE14,
           ATTRIBUTE15
    From  CSP_INV_LOC_ASSIGNMENTS
    -- Hint: Developer need to provide Where clause
    For Update NOWAIT;

Line: 315


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

Line: 324


      SAVEPOINT UPDATE_RESOURCE_PVT;

Line: 358


          AS_CALLOUT_PKG.Update_resource_BU(
                  p_api_version_number   =>  2.0,
                  p_init_msg_list        =>  FND_API.G_FALSE,
                  p_commit               =>  FND_API.G_FALSE,
                  p_validation_level     =>  p_validation_level,
                  p_identity_salesforce_id => p_identity_salesforce_id,
                  P_CSP_Rec      =>  P_CSP_Rec,
          -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
                  x_return_status        =>  x_return_status,
                  x_msg_count            =>  x_msg_count,
                  x_msg_data             =>  x_msg_data);

Line: 385


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

Line: 395


               l_ref_CSP_rec.LAST_UPDATED_BY,
               l_ref_CSP_rec.LAST_UPDATE_DATE,
               l_ref_CSP_rec.LAST_UPDATE_LOGIN,
               l_ref_CSP_rec.RESOURCE_ID,
               l_ref_CSP_rec.ORGANIZATION_ID,
               l_ref_CSP_rec.SUBINVENTORY_CODE,
               l_ref_CSP_rec.LOCATOR_ID,
               l_ref_CSP_rec.RESOURCE_TYPE,
               l_ref_CSP_rec.EFFECTIVE_DATE_START,
               l_ref_CSP_rec.EFFECTIVE_DATE_END,
               l_ref_CSP_rec.DEFAULT_CODE,
               l_ref_CSP_rec.ATTRIBUTE_CATEGORY,
               l_ref_CSP_rec.ATTRIBUTE1,
               l_ref_CSP_rec.ATTRIBUTE2,
               l_ref_CSP_rec.ATTRIBUTE3,
               l_ref_CSP_rec.ATTRIBUTE4,
               l_ref_CSP_rec.ATTRIBUTE5,
               l_ref_CSP_rec.ATTRIBUTE6,
               l_ref_CSP_rec.ATTRIBUTE7,
               l_ref_CSP_rec.ATTRIBUTE8,
               l_ref_CSP_rec.ATTRIBUTE9,
               l_ref_CSP_rec.ATTRIBUTE10,
               l_ref_CSP_rec.ATTRIBUTE11,
               l_ref_CSP_rec.ATTRIBUTE12,
               l_ref_CSP_rec.ATTRIBUTE13,
               l_ref_CSP_rec.ATTRIBUTE14,
               l_ref_CSP_rec.ATTRIBUTE15;

Line: 426


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

Line: 438


      If (l_tar_CSP_rec.last_update_date is NULL or
          l_tar_CSP_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: 443


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

Line: 451


      If (l_tar_CSP_rec.last_update_date <> l_ref_CSP_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: 470


              p_validation_mode  => JTF_PLSQL_API.G_UPDATE,
              P_CSP_Rec  =>  P_CSP_Rec,
              x_return_status    => x_return_status,
              x_msg_count        => x_msg_count,
              x_msg_data         => x_msg_data);

Line: 484


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

Line: 487


      CSP_INV_LOC_ASSIGNMENTS_PKG.Update_Row(
          p_CSP_INV_LOC_ASSIGNMENT_ID  => p_CSP_rec.CSP_INV_LOC_ASSIGNMENT_ID,
          p_CREATED_BY  => p_CSP_rec.created_by,
          p_CREATION_DATE  => p_CSP_rec.creation_date,
          p_LAST_UPDATED_BY  => p_CSP_rec.last_updated_by,
          p_LAST_UPDATE_DATE  => p_CSP_rec.last_update_date,
          p_LAST_UPDATE_LOGIN  => p_CSP_rec.last_update_login,
          p_RESOURCE_ID  => p_CSP_rec.RESOURCE_ID,
          p_ORGANIZATION_ID  => p_CSP_rec.ORGANIZATION_ID,
          p_SUBINVENTORY_CODE  => p_CSP_rec.SUBINVENTORY_CODE,
          p_LOCATOR_ID  => p_CSP_rec.LOCATOR_ID,
          p_RESOURCE_TYPE  => p_CSP_rec.RESOURCE_TYPE,
          p_EFFECTIVE_DATE_START  => p_CSP_rec.EFFECTIVE_DATE_START,
          p_EFFECTIVE_DATE_END  => p_CSP_rec.EFFECTIVE_DATE_END,
          p_DEFAULT_CODE  => p_CSP_rec.DEFAULT_CODE,
          p_ATTRIBUTE_CATEGORY  => p_CSP_rec.ATTRIBUTE_CATEGORY,
          p_ATTRIBUTE1  => p_CSP_rec.ATTRIBUTE1,
          p_ATTRIBUTE2  => p_CSP_rec.ATTRIBUTE2,
          p_ATTRIBUTE3  => p_CSP_rec.ATTRIBUTE3,
          p_ATTRIBUTE4  => p_CSP_rec.ATTRIBUTE4,
          p_ATTRIBUTE5  => p_CSP_rec.ATTRIBUTE5,
          p_ATTRIBUTE6  => p_CSP_rec.ATTRIBUTE6,
          p_ATTRIBUTE7  => p_CSP_rec.ATTRIBUTE7,
          p_ATTRIBUTE8  => p_CSP_rec.ATTRIBUTE8,
          p_ATTRIBUTE9  => p_CSP_rec.ATTRIBUTE9,
          p_ATTRIBUTE10  => p_CSP_rec.ATTRIBUTE10,
          p_ATTRIBUTE11  => p_CSP_rec.ATTRIBUTE11,
          p_ATTRIBUTE12  => p_CSP_rec.ATTRIBUTE12,
          p_ATTRIBUTE13  => p_CSP_rec.ATTRIBUTE13,
          p_ATTRIBUTE14  => p_CSP_rec.ATTRIBUTE14,
          p_ATTRIBUTE15  => p_CSP_rec.ATTRIBUTE15);

Line: 545


          AS_CALLOUT_PKG.Update_resource_AU(
                  p_api_version_number   =>  2.0,
                  p_init_msg_list        =>  FND_API.G_FALSE,
                  p_commit               =>  FND_API.G_FALSE,
                  p_validation_level     =>  p_validation_level,
                  p_identity_salesforce_id => p_identity_salesforce_id,
                  P_CSP_Rec      =>  P_CSP_Rec,
          -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
                  x_return_status        =>  x_return_status,
                  x_msg_count            =>  x_msg_count,
                  x_msg_data             =>  x_msg_data);

Line: 589


End Update_resource;

Line: 594


PROCEDURE Delete_resource(
    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_CSP_Rec     IN CSP_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_resource';

Line: 612


      SAVEPOINT DELETE_RESOURCE_PVT;

Line: 646


          AS_CALLOUT_PKG.Delete_resource_BD(
                  p_api_version_number   =>  1.0,
                  p_init_msg_list        =>  FND_API.G_FALSE,
                  p_commit               =>  FND_API.G_FALSE,
                  p_validation_level     =>  p_validation_level,
                  p_identity_salesforce_id => p_identity_salesforce_id,
                  P_CSP_Rec      =>  P_CSP_Rec,
          -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
                  x_return_status        =>  x_return_status,
                  x_msg_count            =>  x_msg_count,
                  x_msg_data             =>  x_msg_data);

Line: 673


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

Line: 676


      CSP_INV_LOC_ASSIGNMENTS_PKG.Delete_Row(
          p_CSP_INV_LOC_ASSIGNMENT_ID  => p_CSP_rec.CSP_INV_LOC_ASSIGNMENT_ID);

Line: 704


          AS_CALLOUT_PKG.Delete_resource_AD(
                  p_api_version_number   =>  1.0,
                  p_init_msg_list        =>  FND_API.G_FALSE,
                  p_commit               =>  FND_API.G_FALSE,
                  p_validation_level     =>  p_validation_level,
                  p_identity_salesforce_id => p_identity_salesforce_id,
                  P_CSP_Rec      =>  P_CSP_Rec,
          -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
                  x_return_status        =>  x_return_status,
                  x_msg_count            =>  x_msg_count,
                  x_msg_data             =>  x_msg_data);

Line: 747


End Delete_resource;

Line: 867


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

Line: 875


      x_select_cl := 'Select ' ||
                'CSP_INV_LOC_ASSIGNMENTS_V.CSP_INV_LOC_ASSIGNMENT_ID,' ||
                'CSP_INV_LOC_ASSIGNMENTS_V.CREATED_BY,' ||
                'CSP_INV_LOC_ASSIGNMENTS_V.CREATION_DATE,' ||
                'CSP_INV_LOC_ASSIGNMENTS_V.LAST_UPDATED_BY,' ||
                'CSP_INV_LOC_ASSIGNMENTS_V.LAST_UPDATE_DATE,' ||
                'CSP_INV_LOC_ASSIGNMENTS_V.LAST_UPDATE_LOGIN,' ||
                'CSP_INV_LOC_ASSIGNMENTS_V.RESOURCE_ID,' ||
                'CSP_INV_LOC_ASSIGNMENTS_V.ORGANIZATION_ID,' ||
                'CSP_INV_LOC_ASSIGNMENTS_V.SUBINVENTORY_CODE,' ||
                'CSP_INV_LOC_ASSIGNMENTS_V.LOCATOR_ID,' ||
                'CSP_INV_LOC_ASSIGNMENTS_V.RESOURCE_TYPE,' ||
                'CSP_INV_LOC_ASSIGNMENTS_V.EFFECTIVE_DATE_START,' ||
                'CSP_INV_LOC_ASSIGNMENTS_V.EFFECTIVE_DATE_END,' ||
                'CSP_INV_LOC_ASSIGNMENTS_V.DEFAULT_CODE,' ||
                'from CSP_INV_LOC_ASSIGNMENTS_V';

Line: 892


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

Line: 894


END Gen_Select;

Line: 904


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

Line: 907


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

Line: 1043


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

Line: 1097


      ELSIF(p_validation_mode = JTF_PLSQL_API.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: 1151


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

Line: 1205


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

Line: 1252


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

Line: 1306


      ELSIF(p_validation_mode = JTF_PLSQL_API.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: 1360


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

Line: 1414


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

Line: 1461


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