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

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

Line: 139


      CSP_PACKLIST_LINES_PKG.Insert_Row(
          px_PACKLIST_LINE_ID  => x_PACKLIST_LINE_ID,
          p_CREATED_BY  => p_PLL_rec.CREATED_BY,
          p_CREATION_DATE  => p_PLL_rec.CREATION_DATE,
          p_LAST_UPDATED_BY  => p_PLL_rec.LAST_UPDATED_BY,
          p_LAST_UPDATE_DATE  => p_PLL_rec.LAST_UPDATE_DATE,
          p_LAST_UPDATE_LOGIN  => p_PLL_rec.LAST_UPDATE_LOGIN,
          p_ORGANIZATION_ID  => p_PLL_rec.ORGANIZATION_ID,
          p_PACKLIST_LINE_NUMBER  => p_PLL_rec.PACKLIST_LINE_NUMBER,
          p_PACKLIST_HEADER_ID  => p_PLL_rec.PACKLIST_HEADER_ID,
          p_BOX_ID  => p_PLL_rec.BOX_ID,
          p_PICKLIST_LINE_ID  => p_PLL_rec.PICKLIST_LINE_ID,
          p_PACKLIST_LINE_STATUS  => p_PLL_rec.PACKLIST_LINE_STATUS,
          p_INVENTORY_ITEM_ID  => p_PLL_rec.INVENTORY_ITEM_ID,
          p_QUANTITY_PACKED  => p_PLL_rec.QUANTITY_PACKED,
          p_QUANTITY_SHIPPED  => p_PLL_rec.QUANTITY_SHIPPED,
          p_QUANTITY_RECEIVED  => p_PLL_rec.QUANTITY_RECEIVED,
          p_ATTRIBUTE_CATEGORY  => p_PLL_rec.ATTRIBUTE_CATEGORY,
          p_ATTRIBUTE1  => p_PLL_rec.ATTRIBUTE1,
          p_ATTRIBUTE2  => p_PLL_rec.ATTRIBUTE2,
          p_ATTRIBUTE3  => p_PLL_rec.ATTRIBUTE3,
          p_ATTRIBUTE4  => p_PLL_rec.ATTRIBUTE4,
          p_ATTRIBUTE5  => p_PLL_rec.ATTRIBUTE5,
          p_ATTRIBUTE6  => p_PLL_rec.ATTRIBUTE6,
          p_ATTRIBUTE7  => p_PLL_rec.ATTRIBUTE7,
          p_ATTRIBUTE8  => p_PLL_rec.ATTRIBUTE8,
          p_ATTRIBUTE9  => p_PLL_rec.ATTRIBUTE9,
          p_ATTRIBUTE10  => p_PLL_rec.ATTRIBUTE10,
          p_ATTRIBUTE11  => p_PLL_rec.ATTRIBUTE11,
          p_ATTRIBUTE12  => p_PLL_rec.ATTRIBUTE12,
          p_ATTRIBUTE13  => p_PLL_rec.ATTRIBUTE13,
          p_ATTRIBUTE14  => p_PLL_rec.ATTRIBUTE14,
          p_ATTRIBUTE15  => p_PLL_rec.ATTRIBUTE15,
          p_UOM_CODE  => p_PLL_rec.UOM_CODE,
          p_LINE_ID  => p_PLL_rec.LINE_ID);

Line: 253


PROCEDURE Update_packlist_lines(
    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_PLL_Rec     IN    PLL_Rec_Type,
    X_Return_Status              OUT NOCOPY  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY  NUMBER,
    X_Msg_Data                   OUT NOCOPY  VARCHAR2
    )

 IS
/*
Cursor C_Get_packlist_lines(PACKLIST_LINE_ID Number) IS
    Select rowid,
           PACKLIST_LINE_ID,
           CREATED_BY,
           CREATION_DATE,
           LAST_UPDATED_BY,
           LAST_UPDATE_DATE,
           LAST_UPDATE_LOGIN,
           ORGANIZATION_ID,
           PACKLIST_LINE_NUMBER,
           PACKLIST_HEADER_ID,
           BOX_ID,
           PICKLIST_LINE_ID,
           PACKLIST_LINE_STATUS,
           INVENTORY_ITEM_ID,
           QUANTITY_PACKED,
           QUANTITY_SHIPPED,
           QUANTITY_RECEIVED,
           ATTRIBUTE_CATEGORY,
           ATTRIBUTE1,
           ATTRIBUTE2,
           ATTRIBUTE3,
           ATTRIBUTE4,
           ATTRIBUTE5,
           ATTRIBUTE6,
           ATTRIBUTE7,
           ATTRIBUTE8,
           ATTRIBUTE9,
           ATTRIBUTE10,
           ATTRIBUTE11,
           ATTRIBUTE12,
           ATTRIBUTE13,
           ATTRIBUTE14,
           ATTRIBUTE15,
           UOM_CODE,
           LINE_ID
    From  CSP_PACKLIST_LINES
    -- Hint: Developer need to provide Where clause
    For Update NOWAIT;

Line: 307


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

Line: 316


      SAVEPOINT UPDATE_PACKLIST_LINES_PVT;

Line: 350


          AS_CALLOUT_PKG.Update_packlist_lines_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_PLL_Rec      =>  P_PLL_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: 377


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

Line: 387


               l_ref_PLL_rec.LAST_UPDATED_BY,
               l_ref_PLL_rec.LAST_UPDATE_DATE,
               l_ref_PLL_rec.LAST_UPDATE_LOGIN,
               l_ref_PLL_rec.ORGANIZATION_ID,
               l_ref_PLL_rec.PACKLIST_LINE_NUMBER,
               l_ref_PLL_rec.PACKLIST_HEADER_ID,
               l_ref_PLL_rec.BOX_ID,
               l_ref_PLL_rec.PICKLIST_LINE_ID,
               l_ref_PLL_rec.PACKLIST_LINE_STATUS,
               l_ref_PLL_rec.INVENTORY_ITEM_ID,
               l_ref_PLL_rec.QUANTITY_PACKED,
               l_ref_PLL_rec.QUANTITY_SHIPPED,
               l_ref_PLL_rec.QUANTITY_RECEIVED,
               l_ref_PLL_rec.ATTRIBUTE_CATEGORY,
               l_ref_PLL_rec.ATTRIBUTE1,
               l_ref_PLL_rec.ATTRIBUTE2,
               l_ref_PLL_rec.ATTRIBUTE3,
               l_ref_PLL_rec.ATTRIBUTE4,
               l_ref_PLL_rec.ATTRIBUTE5,
               l_ref_PLL_rec.ATTRIBUTE6,
               l_ref_PLL_rec.ATTRIBUTE7,
               l_ref_PLL_rec.ATTRIBUTE8,
               l_ref_PLL_rec.ATTRIBUTE9,
               l_ref_PLL_rec.ATTRIBUTE10,
               l_ref_PLL_rec.ATTRIBUTE11,
               l_ref_PLL_rec.ATTRIBUTE12,
               l_ref_PLL_rec.ATTRIBUTE13,
               l_ref_PLL_rec.ATTRIBUTE14,
               l_ref_PLL_rec.ATTRIBUTE15,
               l_ref_PLL_rec.UOM_CODE,
               l_ref_PLL_rec.LINE_ID;

Line: 422


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

Line: 434


      If (l_tar_PLL_rec.last_update_date is NULL or
          l_tar_PLL_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: 439


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

Line: 445


      If (l_tar_PLL_rec.last_update_date <> l_ref_PLL_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: 464


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

Line: 478


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

Line: 481


      CSP_PACKLIST_LINES_PKG.Update_Row(
          p_PACKLIST_LINE_ID  => p_PLL_rec.PACKLIST_LINE_ID,
          p_CREATED_BY  => p_PLL_rec.CREATED_BY,
          p_CREATION_DATE  => p_PLL_rec.creation_date,
          p_LAST_UPDATED_BY  => p_PLL_rec.LAST_UPDATED_BY,
          p_LAST_UPDATE_DATE  => p_PLL_rec.LAST_UPDATE_DATE,
          p_LAST_UPDATE_LOGIN  => p_PLL_rec.LAST_UPDATE_LOGIN,
          p_ORGANIZATION_ID  => p_PLL_rec.ORGANIZATION_ID,
          p_PACKLIST_LINE_NUMBER  => p_PLL_rec.PACKLIST_LINE_NUMBER,
          p_PACKLIST_HEADER_ID  => p_PLL_rec.PACKLIST_HEADER_ID,
          p_BOX_ID  => p_PLL_rec.BOX_ID,
          p_PICKLIST_LINE_ID  => p_PLL_rec.PICKLIST_LINE_ID,
          p_PACKLIST_LINE_STATUS  => p_PLL_rec.PACKLIST_LINE_STATUS,
          p_INVENTORY_ITEM_ID  => p_PLL_rec.INVENTORY_ITEM_ID,
          p_QUANTITY_PACKED  => p_PLL_rec.QUANTITY_PACKED,
          p_QUANTITY_SHIPPED  => p_PLL_rec.QUANTITY_SHIPPED,
          p_QUANTITY_RECEIVED  => p_PLL_rec.QUANTITY_RECEIVED,
          p_ATTRIBUTE_CATEGORY  => p_PLL_rec.ATTRIBUTE_CATEGORY,
          p_ATTRIBUTE1  => p_PLL_rec.ATTRIBUTE1,
          p_ATTRIBUTE2  => p_PLL_rec.ATTRIBUTE2,
          p_ATTRIBUTE3  => p_PLL_rec.ATTRIBUTE3,
          p_ATTRIBUTE4  => p_PLL_rec.ATTRIBUTE4,
          p_ATTRIBUTE5  => p_PLL_rec.ATTRIBUTE5,
          p_ATTRIBUTE6  => p_PLL_rec.ATTRIBUTE6,
          p_ATTRIBUTE7  => p_PLL_rec.ATTRIBUTE7,
          p_ATTRIBUTE8  => p_PLL_rec.ATTRIBUTE8,
          p_ATTRIBUTE9  => p_PLL_rec.ATTRIBUTE9,
          p_ATTRIBUTE10  => p_PLL_rec.ATTRIBUTE10,
          p_ATTRIBUTE11  => p_PLL_rec.ATTRIBUTE11,
          p_ATTRIBUTE12  => p_PLL_rec.ATTRIBUTE12,
          p_ATTRIBUTE13  => p_PLL_rec.ATTRIBUTE13,
          p_ATTRIBUTE14  => p_PLL_rec.ATTRIBUTE14,
          p_ATTRIBUTE15  => p_PLL_rec.ATTRIBUTE15,
          p_UOM_CODE  => p_PLL_rec.UOM_CODE,
          p_LINE_ID  => p_PLL_rec.LINE_ID);

Line: 542


          AS_CALLOUT_PKG.Update_packlist_lines_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_PLL_Rec      =>  P_PLL_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: 585


End Update_packlist_lines;

Line: 590


PROCEDURE Delete_packlist_lines(
    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_PLL_Rec     IN PLL_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_packlist_lines';

Line: 608


      SAVEPOINT DELETE_PACKLIST_LINES_PVT;

Line: 642


          AS_CALLOUT_PKG.Delete_packlist_lines_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_PLL_Rec      =>  P_PLL_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: 669


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

Line: 672


      CSP_PACKLIST_LINES_PKG.Delete_Row(
          p_PACKLIST_LINE_ID  => p_PLL_rec.PACKLIST_LINE_ID);

Line: 700


          AS_CALLOUT_PKG.Delete_packlist_lines_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_PLL_Rec      =>  P_PLL_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: 743


End Delete_packlist_lines;

Line: 902


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: 910


      x_select_cl := 'Select ' ||
                'CSP_PACKLIST_LINES_V.PACKLIST_LINE_ID,' ||
                'CSP_PACKLIST_LINES_V.CREATED_BY,' ||
                'CSP_PACKLIST_LINES_V.CREATION_DATE,' ||
                'CSP_PACKLIST_LINES_V.LAST_UPDATED_BY,' ||
                'CSP_PACKLIST_LINES_V.LAST_UPDATE_DATE,' ||
                'CSP_PACKLIST_LINES_V.LAST_UPDATE_LOGIN,' ||
                'CSP_PACKLIST_LINES_V.ORGANIZATION_ID,' ||
                'CSP_PACKLIST_LINES_V.PACKLIST_LINE_NUMBER,' ||
                'CSP_PACKLIST_LINES_V.PACKLIST_HEADER_ID,' ||
                'CSP_PACKLIST_LINES_V.BOX_ID,' ||
                'CSP_PACKLIST_LINES_V.PICKLIST_LINE_ID,' ||
                'CSP_PACKLIST_LINES_V.PACKLIST_LINE_STATUS,' ||
                'CSP_PACKLIST_LINES_V.INVENTORY_ITEM_ID,' ||
                'CSP_PACKLIST_LINES_V.QUANTITY_PACKED,' ||
                'CSP_PACKLIST_LINES_V.QUANTITY_SHIPPED,' ||
                'CSP_PACKLIST_LINES_V.QUANTITY_RECEIVED,' ||
                'CSP_PACKLIST_LINES_V.ATTRIBUTE_CATEGORY,' ||
                'CSP_PACKLIST_LINES_V.ATTRIBUTE1,' ||
                'CSP_PACKLIST_LINES_V.ATTRIBUTE2,' ||
                'CSP_PACKLIST_LINES_V.ATTRIBUTE3,' ||
                'CSP_PACKLIST_LINES_V.ATTRIBUTE4,' ||
                'CSP_PACKLIST_LINES_V.ATTRIBUTE5,' ||
                'CSP_PACKLIST_LINES_V.ATTRIBUTE6,' ||
                'CSP_PACKLIST_LINES_V.ATTRIBUTE7,' ||
                'CSP_PACKLIST_LINES_V.ATTRIBUTE8,' ||
                'CSP_PACKLIST_LINES_V.ATTRIBUTE9,' ||
                'CSP_PACKLIST_LINES_V.ATTRIBUTE10,' ||
                'CSP_PACKLIST_LINES_V.ATTRIBUTE11,' ||
                'CSP_PACKLIST_LINES_V.ATTRIBUTE12,' ||
                'CSP_PACKLIST_LINES_V.ATTRIBUTE13,' ||
                'CSP_PACKLIST_LINES_V.ATTRIBUTE14,' ||
                'CSP_PACKLIST_LINES_V.ATTRIBUTE15,' ||
                'CSP_PACKLIST_LINES_V.UOM_CODE,' ||
                'CSP_PACKLIST_LINES_V.LINE_ID,' ||
                'from CSP_PACKLIST_LINES_V';

Line: 947


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

Line: 949


END Gen_Select;

Line: 959


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

Line: 962


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

Line: 1098


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

Line: 1152


      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: 1206


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


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

Line: 1361


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

Line: 1415


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

Line: 1469


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

Line: 1523


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

Line: 1570


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

Line: 1617


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

Line: 1671


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

Line: 1718


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