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

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

Line: 144


      CSP_PICKLIST_HEADERS_PKG.Insert_Row(
          px_picklist_header_id  => x_picklist_header_id,
          p_CREATED_BY  => p_PICK_HEADER_rec.CREATED_BY,
          p_CREATION_DATE  => p_PICK_HEADER_rec.CREATION_DATE,
          p_LAST_UPDATED_BY  => p_PICK_HEADER_rec.LAST_UPDATED_BY,
          p_LAST_UPDATE_DATE  => p_PICK_HEADER_rec.LAST_UPDATE_DATE,
          p_LAST_UPDATE_LOGIN  => p_PICK_HEADER_rec.LAST_UPDATE_LOGIN,
          p_ORGANIZATION_ID  => p_PICK_HEADER_rec.ORGANIZATION_ID,
          p_PICKLIST_NUMBER  => p_PICK_HEADER_rec.PICKLIST_NUMBER,
          p_PICKLIST_STATUS  => p_PICK_HEADER_rec.PICKLIST_STATUS,
          p_DATE_CREATED  => p_PICK_HEADER_rec.DATE_CREATED,
          p_DATE_CONFIRMED  => p_PICK_HEADER_rec.DATE_CONFIRMED,
          p_ATTRIBUTE_CATEGORY  => p_PICK_HEADER_rec.ATTRIBUTE_CATEGORY,
          p_ATTRIBUTE1  => p_PICK_HEADER_rec.ATTRIBUTE1,
          p_ATTRIBUTE2  => p_PICK_HEADER_rec.ATTRIBUTE2,
          p_ATTRIBUTE3  => p_PICK_HEADER_rec.ATTRIBUTE3,
          p_ATTRIBUTE4  => p_PICK_HEADER_rec.ATTRIBUTE4,
          p_ATTRIBUTE5  => p_PICK_HEADER_rec.ATTRIBUTE5,
          p_ATTRIBUTE6  => p_PICK_HEADER_rec.ATTRIBUTE6,
          p_ATTRIBUTE7  => p_PICK_HEADER_rec.ATTRIBUTE7,
          p_ATTRIBUTE8  => p_PICK_HEADER_rec.ATTRIBUTE8,
          p_ATTRIBUTE9  => p_PICK_HEADER_rec.ATTRIBUTE9,
          p_ATTRIBUTE10  => p_PICK_HEADER_rec.ATTRIBUTE10,
          p_ATTRIBUTE11  => p_PICK_HEADER_rec.ATTRIBUTE11,
          p_ATTRIBUTE12  => p_PICK_HEADER_rec.ATTRIBUTE12,
          p_ATTRIBUTE13  => p_PICK_HEADER_rec.ATTRIBUTE13,
          p_ATTRIBUTE14  => p_PICK_HEADER_rec.ATTRIBUTE14,
          p_ATTRIBUTE15  => p_PICK_HEADER_rec.ATTRIBUTE15);

Line: 251


PROCEDURE Update_picklist_header(
    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_PICK_HEADER_Rec     IN    PICK_HEADER_Rec_Type,
    X_Return_Status              OUT NOCOPY  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY  NUMBER,
    X_Msg_Data                   OUT NOCOPY  VARCHAR2
    )

 IS
/*
Cursor C_Get_picklist_header(picklist_header_id Number) IS
    Select rowid,
           picklist_header_id,
           CREATED_BY,
           CREATION_DATE,
           LAST_UPDATED_BY,
           LAST_UPDATE_DATE,
           LAST_UPDATE_LOGIN,
           ORGANIZATION_ID,
           PICKLIST_NUMBER,
           PICKLIST_STATUS,
           DATE_CREATED,
           DATE_CONFIRMED,
           ATTRIBUTE_CATEGORY,
           ATTRIBUTE1,
           ATTRIBUTE2,
           ATTRIBUTE3,
           ATTRIBUTE4,
           ATTRIBUTE5,
           ATTRIBUTE6,
           ATTRIBUTE7,
           ATTRIBUTE8,
           ATTRIBUTE9,
           ATTRIBUTE10,
           ATTRIBUTE11,
           ATTRIBUTE12,
           ATTRIBUTE13,
           ATTRIBUTE14,
           ATTRIBUTE15
    From  CSP_PICKLIST_HEADERS
    -- Hint: Developer need to provide Where clause
    For Update NOWAIT;

Line: 298


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

Line: 307


      SAVEPOINT UPDATE_picklist_header_PVT;

Line: 341


          AS_CALLOUT_PKG.Update_picklist_header_BU(
                  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_PICK_HEADER_Rec      =>  P_PICK_HEADER_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: 368


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

Line: 378


               l_ref_PICK_HEADER_rec.LAST_UPDATED_BY,
               l_ref_PICK_HEADER_rec.LAST_UPDATE_DATE,
               l_ref_PICK_HEADER_rec.LAST_UPDATE_LOGIN,
               l_ref_PICK_HEADER_rec.ORGANIZATION_ID,
               l_ref_PICK_HEADER_rec.PICKLIST_NUMBER,
               l_ref_PICK_HEADER_rec.PICKLIST_STATUS,
               l_ref_PICK_HEADER_rec.DATE_CREATED,
               l_ref_PICK_HEADER_rec.DATE_CONFIRMED,
               l_ref_PICK_HEADER_rec.ATTRIBUTE_CATEGORY,
               l_ref_PICK_HEADER_rec.ATTRIBUTE1,
               l_ref_PICK_HEADER_rec.ATTRIBUTE2,
               l_ref_PICK_HEADER_rec.ATTRIBUTE3,
               l_ref_PICK_HEADER_rec.ATTRIBUTE4,
               l_ref_PICK_HEADER_rec.ATTRIBUTE5,
               l_ref_PICK_HEADER_rec.ATTRIBUTE6,
               l_ref_PICK_HEADER_rec.ATTRIBUTE7,
               l_ref_PICK_HEADER_rec.ATTRIBUTE8,
               l_ref_PICK_HEADER_rec.ATTRIBUTE9,
               l_ref_PICK_HEADER_rec.ATTRIBUTE10,
               l_ref_PICK_HEADER_rec.ATTRIBUTE11,
               l_ref_PICK_HEADER_rec.ATTRIBUTE12,
               l_ref_PICK_HEADER_rec.ATTRIBUTE13,
               l_ref_PICK_HEADER_rec.ATTRIBUTE14,
               l_ref_PICK_HEADER_rec.ATTRIBUTE15;

Line: 406


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

Line: 418


 /*     If (l_tar_PICK_HEADER_rec.last_update_date is NULL or
          l_tar_PICK_HEADER_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: 423


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

Line: 429


      If (l_tar_PICK_HEADER_rec.last_update_date <> l_ref_PICK_HEADER_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: 449


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

Line: 466


      CSP_PICKLIST_HEADERS_PKG.Update_Row(
          p_picklist_header_id  => p_PICK_HEADER_rec.picklist_header_id,
          p_CREATED_BY  => p_PICK_HEADER_rec.CREATED_BY,
          p_CREATION_DATE  => p_PICK_HEADER_rec.CREATION_DATE,
          p_LAST_UPDATED_BY  => p_PICK_HEADER_rec.LAST_UPDATED_BY ,
          p_LAST_UPDATE_DATE  => p_PICK_HEADER_rec.LAST_UPDATE_DATE,
          p_LAST_UPDATE_LOGIN  => p_PICK_HEADER_rec.LAST_UPDATE_LOGIN ,
          p_ORGANIZATION_ID  => p_PICK_HEADER_rec.ORGANIZATION_ID,
          p_PICKLIST_NUMBER  => p_PICK_HEADER_rec.PICKLIST_NUMBER,
          p_PICKLIST_STATUS  => p_PICK_HEADER_rec.PICKLIST_STATUS,
          p_DATE_CREATED  => p_PICK_HEADER_rec.DATE_CREATED,
          p_DATE_CONFIRMED  => p_PICK_HEADER_rec.DATE_CONFIRMED,
          p_ATTRIBUTE_CATEGORY  => p_PICK_HEADER_rec.ATTRIBUTE_CATEGORY,
          p_ATTRIBUTE1  => p_PICK_HEADER_rec.ATTRIBUTE1,
          p_ATTRIBUTE2  => p_PICK_HEADER_rec.ATTRIBUTE2,
          p_ATTRIBUTE3  => p_PICK_HEADER_rec.ATTRIBUTE3,
          p_ATTRIBUTE4  => p_PICK_HEADER_rec.ATTRIBUTE4,
          p_ATTRIBUTE5  => p_PICK_HEADER_rec.ATTRIBUTE5,
          p_ATTRIBUTE6  => p_PICK_HEADER_rec.ATTRIBUTE6,
          p_ATTRIBUTE7  => p_PICK_HEADER_rec.ATTRIBUTE7,
          p_ATTRIBUTE8  => p_PICK_HEADER_rec.ATTRIBUTE8,
          p_ATTRIBUTE9  => p_PICK_HEADER_rec.ATTRIBUTE9,
          p_ATTRIBUTE10  => p_PICK_HEADER_rec.ATTRIBUTE10,
          p_ATTRIBUTE11  => p_PICK_HEADER_rec.ATTRIBUTE11,
          p_ATTRIBUTE12  => p_PICK_HEADER_rec.ATTRIBUTE12,
          p_ATTRIBUTE13  => p_PICK_HEADER_rec.ATTRIBUTE13,
          p_ATTRIBUTE14  => p_PICK_HEADER_rec.ATTRIBUTE14,
          p_ATTRIBUTE15  => p_PICK_HEADER_rec.ATTRIBUTE15);

Line: 520


          AS_CALLOUT_PKG.Update_picklist_header_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_PICK_HEADER_Rec      =>  P_PICK_HEADER_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: 563


End Update_picklist_header;

Line: 568


PROCEDURE Delete_picklist_header(
    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_PICK_HEADER_Rec     IN PICK_HEADER_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_picklist_header';

Line: 586


      SAVEPOINT DELETE_picklist_header_PVT;

Line: 620


          AS_CALLOUT_PKG.Delete_picklist_header_BD(
                  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_PICK_HEADER_Rec      =>  P_PICK_HEADER_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: 650


      CSP_PICKLIST_HEADERS_PKG.Delete_Row(
          p_picklist_header_id  => p_PICK_HEADER_rec.picklist_header_id);

Line: 678


          AS_CALLOUT_PKG.Delete_picklist_header_AD(
                  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_PICK_HEADER_Rec      =>  P_PICK_HEADER_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: 721


End Delete_picklist_header;

Line: 866


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, 'Private API: Generate Select Begins');

Line: 874


      x_select_cl := 'Select ' ||
                'CSP_PICKLIST_HEADERS_V.picklist_header_id,' ||
                'CSP_PICKLIST_HEADERS_V.CREATED_BY,' ||
                'CSP_PICKLIST_HEADERS_V.CREATION_DATE,' ||
                'CSP_PICKLIST_HEADERS_V.LAST_UPDATED_BY,' ||
                'CSP_PICKLIST_HEADERS_V.LAST_UPDATE_DATE,' ||
                'CSP_PICKLIST_HEADERS_V.LAST_UPDATE_LOGIN,' ||
                'CSP_PICKLIST_HEADERS_V.ORGANIZATION_ID,' ||
                'CSP_PICKLIST_HEADERS_V.PICKLIST_NUMBER,' ||
                'CSP_PICKLIST_HEADERS_V.PICKLIST_STATUS,' ||
                'CSP_PICKLIST_HEADERS_V.DATE_CREATED,' ||
                'CSP_PICKLIST_HEADERS_V.DATE_CONFIRMED,' ||
                'CSP_PICKLIST_HEADERS_V.ATTRIBUTE_CATEGORY,' ||
                'CSP_PICKLIST_HEADERS_V.ATTRIBUTE1,' ||
                'CSP_PICKLIST_HEADERS_V.ATTRIBUTE2,' ||
                'CSP_PICKLIST_HEADERS_V.ATTRIBUTE3,' ||
                'CSP_PICKLIST_HEADERS_V.ATTRIBUTE4,' ||
                'CSP_PICKLIST_HEADERS_V.ATTRIBUTE5,' ||
                'CSP_PICKLIST_HEADERS_V.ATTRIBUTE6,' ||
                'CSP_PICKLIST_HEADERS_V.ATTRIBUTE7,' ||
                'CSP_PICKLIST_HEADERS_V.ATTRIBUTE8,' ||
                'CSP_PICKLIST_HEADERS_V.ATTRIBUTE9,' ||
                'CSP_PICKLIST_HEADERS_V.ATTRIBUTE10,' ||
                'CSP_PICKLIST_HEADERS_V.ATTRIBUTE11,' ||
                'CSP_PICKLIST_HEADERS_V.ATTRIBUTE12,' ||
                'CSP_PICKLIST_HEADERS_V.ATTRIBUTE13,' ||
                'CSP_PICKLIST_HEADERS_V.ATTRIBUTE14,' ||
                'CSP_PICKLIST_HEADERS_V.ATTRIBUTE15,' ||
                'from CSP_PICKLIST_HEADERS_V';

Line: 904


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

Line: 906


END Gen_Select;

Line: 916


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

Line: 919


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

Line: 1058


      ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
      THEN
          -- Hint: Validate data
          -- IF p_picklist_header_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 = 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: 1159


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

Line: 1213


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

Line: 1260


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

Line: 1307


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