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

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

Line: 140


      CSP_MOVEORDER_LINES_PKG.Insert_Row(
          p_LINE_ID  => p_mol_rec.LINE_ID,
          p_CREATED_BY  => G_USER_ID,
          p_CREATION_DATE  => sysdate,
          p_LAST_UPDATED_BY  => G_USER_ID,
          p_LAST_UPDATE_DATE  => sysdate,
          p_LAST_UPDATED_LOGIN  => G_LOGIN_ID,
          p_HEADER_ID  => p_mol_rec.HEADER_ID,
          p_CUSTOMER_PO  => p_mol_rec.CUSTOMER_PO,
          p_INCIDENT_ID  => p_mol_rec.INCIDENT_ID,
          p_TASK_ID  => p_mol_rec.TASK_ID,
          p_TASK_ASSIGNMENT_ID  => p_mol_rec.TASK_ASSIGNMENT_ID,
          p_COMMENTS  => p_mol_rec.COMMENTS,
          p_ATTRIBUTE_CATEGORY  => p_mol_rec.ATTRIBUTE_CATEGORY,
          p_ATTRIBUTE1  => p_mol_rec.ATTRIBUTE1,
          p_ATTRIBUTE2  => p_mol_rec.ATTRIBUTE2,
          p_ATTRIBUTE3  => p_mol_rec.ATTRIBUTE3,
          p_ATTRIBUTE4  => p_mol_rec.ATTRIBUTE4,
          p_ATTRIBUTE5  => p_mol_rec.ATTRIBUTE5,
          p_ATTRIBUTE6  => p_mol_rec.ATTRIBUTE6,
          p_ATTRIBUTE7  => p_mol_rec.ATTRIBUTE7,
          p_ATTRIBUTE8  => p_mol_rec.ATTRIBUTE8,
          p_ATTRIBUTE9  => p_mol_rec.ATTRIBUTE9,
          p_ATTRIBUTE10  => p_mol_rec.ATTRIBUTE10,
          p_ATTRIBUTE11  => p_mol_rec.ATTRIBUTE11,
          p_ATTRIBUTE12  => p_mol_rec.ATTRIBUTE12,
          p_ATTRIBUTE13  => p_mol_rec.ATTRIBUTE13,
          p_ATTRIBUTE14  => p_mol_rec.ATTRIBUTE14,
          p_ATTRIBUTE15  => p_mol_rec.ATTRIBUTE15);

Line: 249


PROCEDURE Update_orderlines(
    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_mol_Rec     IN    mol_Rec_Type,
    X_Return_Status              OUT NOCOPY  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY  NUMBER,
    X_Msg_Data                   OUT NOCOPY  VARCHAR2
    )

 IS
/*
Cursor C_Get_orderlines(LINE_ID Number) IS
    Select rowid,
           LINE_ID,
           CREATED_BY,
           CREATION_DATE,
           LAST_UPDATED_BY,
           LAST_UPDATE_DATE,
           LAST_UPDATED_LOGIN,
           HEADER_ID,
           CUSTOMER_PO,
           INCIDENT_ID,
           TASK_ID,
           TASK_ASSIGNMENT_ID,
           COMMENTS,
           ATTRIBUTE_CATEGORY,
           ATTRIBUTE1,
           ATTRIBUTE2,
           ATTRIBUTE3,
           ATTRIBUTE4,
           ATTRIBUTE5,
           ATTRIBUTE6,
           ATTRIBUTE7,
           ATTRIBUTE8,
           ATTRIBUTE9,
           ATTRIBUTE10,
           ATTRIBUTE11,
           ATTRIBUTE12,
           ATTRIBUTE13,
           ATTRIBUTE14,
           ATTRIBUTE15
    From  CSP_MOVEORDER_LINES
    -- Hint: Developer need to provide Where clause
    For Update NOWAIT;

Line: 297


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

Line: 306


      SAVEPOINT UPDATE_ORDERLINES_PVT;

Line: 340


          AS_CALLOUT_PKG.Update_orderlines_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_mol_Rec      =>  P_mol_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: 370


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

Line: 380


               l_ref_mol_rec.LAST_UPDATED_BY,
               l_ref_mol_rec.LAST_UPDATE_DATE,
               l_ref_mol_rec.LAST_UPDATED_LOGIN,
               l_ref_mol_rec.HEADER_ID,
               l_ref_mol_rec.CUSTOMER_PO,
               l_ref_mol_rec.INCIDENT_ID,
               l_ref_mol_rec.TASK_ID,
               l_ref_mol_rec.TASK_ASSIGNMENT_ID,
               l_ref_mol_rec.COMMENTS,
               l_ref_mol_rec.ATTRIBUTE_CATEGORY,
               l_ref_mol_rec.ATTRIBUTE1,
               l_ref_mol_rec.ATTRIBUTE2,
               l_ref_mol_rec.ATTRIBUTE3,
               l_ref_mol_rec.ATTRIBUTE4,
               l_ref_mol_rec.ATTRIBUTE5,
               l_ref_mol_rec.ATTRIBUTE6,
               l_ref_mol_rec.ATTRIBUTE7,
               l_ref_mol_rec.ATTRIBUTE8,
               l_ref_mol_rec.ATTRIBUTE9,
               l_ref_mol_rec.ATTRIBUTE10,
               l_ref_mol_rec.ATTRIBUTE11,
               l_ref_mol_rec.ATTRIBUTE12,
               l_ref_mol_rec.ATTRIBUTE13,
               l_ref_mol_rec.ATTRIBUTE14,
               l_ref_mol_rec.ATTRIBUTE15;

Line: 409


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

Line: 421


      If (l_tar_mol_rec.last_update_date is NULL or
          l_tar_mol_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: 426


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

Line: 433


      If (l_tar_mol_rec.last_update_date <> l_ref_mol_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: 452


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

Line: 466


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

Line: 469


      CSP_MOVEORDER_LINES_PKG.Update_Row(
          p_LINE_ID  => p_mol_rec.LINE_ID,
          p_CREATED_BY  => p_mol_rec.created_by,
          p_CREATION_DATE  => p_mol_rec.creation_date,
          p_LAST_UPDATED_BY  => p_mol_rec.last_updated_by,
          p_LAST_UPDATE_DATE  => SYSDATE,
          p_LAST_UPDATED_LOGIN  =>p_mol_rec.last_updated_login,
          p_HEADER_ID  => p_mol_rec.HEADER_ID,
          p_CUSTOMER_PO  => p_mol_rec.CUSTOMER_PO,
          p_INCIDENT_ID  => p_mol_rec.INCIDENT_ID,
          p_TASK_ID  => p_mol_rec.TASK_ID,
          p_TASK_ASSIGNMENT_ID  => p_mol_rec.TASK_ASSIGNMENT_ID,
          p_COMMENTS  => p_mol_rec.COMMENTS,
          p_ATTRIBUTE_CATEGORY  => p_mol_rec.ATTRIBUTE_CATEGORY,
          p_ATTRIBUTE1  => p_mol_rec.ATTRIBUTE1,
          p_ATTRIBUTE2  => p_mol_rec.ATTRIBUTE2,
          p_ATTRIBUTE3  => p_mol_rec.ATTRIBUTE3,
          p_ATTRIBUTE4  => p_mol_rec.ATTRIBUTE4,
          p_ATTRIBUTE5  => p_mol_rec.ATTRIBUTE5,
          p_ATTRIBUTE6  => p_mol_rec.ATTRIBUTE6,
          p_ATTRIBUTE7  => p_mol_rec.ATTRIBUTE7,
          p_ATTRIBUTE8  => p_mol_rec.ATTRIBUTE8,
          p_ATTRIBUTE9  => p_mol_rec.ATTRIBUTE9,
          p_ATTRIBUTE10  => p_mol_rec.ATTRIBUTE10,
          p_ATTRIBUTE11  => p_mol_rec.ATTRIBUTE11,
          p_ATTRIBUTE12  => p_mol_rec.ATTRIBUTE12,
          p_ATTRIBUTE13  => p_mol_rec.ATTRIBUTE13,
          p_ATTRIBUTE14  => p_mol_rec.ATTRIBUTE14,
          p_ATTRIBUTE15  => p_mol_rec.ATTRIBUTE15);

Line: 524


          AS_CALLOUT_PKG.Update_orderlines_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_mol_Rec      =>  P_mol_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: 567


End Update_orderlines;

Line: 572


PROCEDURE Delete_orderlines(
    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_mol_Rec     IN mol_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_orderlines';

Line: 590


      SAVEPOINT DELETE_ORDERLINES_PVT;

Line: 624


          AS_CALLOUT_PKG.Delete_orderlines_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_mol_Rec      =>  P_mol_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: 652


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

Line: 655


      CSP_MOVEORDER_LINES_PKG.Delete_Row(
          p_LINE_ID  => p_mol_rec.LINE_ID);

Line: 683


          AS_CALLOUT_PKG.Delete_orderlines_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_mol_Rec      =>  P_mol_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: 726


End Delete_orderlines;

Line: 741


      dbms_sql.define_column(p_cur_get_mol, 2, P_mol_Rec.LAST_UPDATED_LOGIN);

Line: 781


      dbms_sql.column_value(p_cur_get_mol, 2, X_mol_Rec.LAST_UPDATED_LOGIN);

Line: 875


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


      x_select_cl := 'Select ' ||
                'CSP_MOVEORDER_LINES_V.LINE_ID,' ||
                'CSP_MOVEORDER_LINES_V.CREATED_BY,' ||
                'CSP_MOVEORDER_LINES_V.CREATION_DATE,' ||
                'CSP_MOVEORDER_LINES_V.LAST_UPDATED_BY,' ||
                'CSP_MOVEORDER_LINES_V.LAST_UPDATE_DATE,' ||
                'CSP_MOVEORDER_LINES_V.LAST_UPDATED_LOGIN,' ||
                'CSP_MOVEORDER_LINES_V.HEADER_ID,' ||
                'CSP_MOVEORDER_LINES_V.CUSTOMER_PO,' ||
                'CSP_MOVEORDER_LINES_V.INCIDENT_ID,' ||
                'CSP_MOVEORDER_LINES_V.TASK_ID,' ||
                'CSP_MOVEORDER_LINES_V.TASK_ASSIGNMENT_ID,' ||
                'CSP_MOVEORDER_LINES_V.COMMENTS,' ||
                'CSP_MOVEORDER_LINES_V.ATTRIBUTE_CATEGORY,' ||
                'CSP_MOVEORDER_LINES_V.ATTRIBUTE1,' ||
                'CSP_MOVEORDER_LINES_V.ATTRIBUTE2,' ||
                'CSP_MOVEORDER_LINES_V.ATTRIBUTE3,' ||
                'CSP_MOVEORDER_LINES_V.ATTRIBUTE4,' ||
                'CSP_MOVEORDER_LINES_V.ATTRIBUTE5,' ||
                'CSP_MOVEORDER_LINES_V.ATTRIBUTE6,' ||
                'CSP_MOVEORDER_LINES_V.ATTRIBUTE7,' ||
                'CSP_MOVEORDER_LINES_V.ATTRIBUTE8,' ||
                'CSP_MOVEORDER_LINES_V.ATTRIBUTE9,' ||
                'CSP_MOVEORDER_LINES_V.ATTRIBUTE10,' ||
                'CSP_MOVEORDER_LINES_V.ATTRIBUTE11,' ||
                'CSP_MOVEORDER_LINES_V.ATTRIBUTE12,' ||
                'CSP_MOVEORDER_LINES_V.ATTRIBUTE13,' ||
                'CSP_MOVEORDER_LINES_V.ATTRIBUTE14,' ||
                'CSP_MOVEORDER_LINES_V.ATTRIBUTE15,' ||
                'from CSP_MOVEORDER_LINES_V';

Line: 914


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

Line: 916


END Gen_Select;

Line: 926


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

Line: 929


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

Line: 1070


            SELECT organization_id into l_check_line_id
            from mtl_txn_request_lines
            where header_id = p_header_id
            and line_id = p_line_id;

Line: 1086


      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;

Line: 1104


PROCEDURE Validate_LAST_UPDATED_LOGIN (
    P_Init_Msg_List              IN   VARCHAR2     := FND_API.G_FALSE,
    P_Validation_mode            IN   VARCHAR2,
    P_LAST_UPDATED_LOGIN                IN   NUMBER,
    -- Hint: You may add 'X_Item_Property_Rec  OUT NOCOPY     JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
    X_Return_Status              OUT NOCOPY  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY  NUMBER,
    X_Msg_Data                   OUT NOCOPY  VARCHAR2
    )
IS
BEGIN

      -- Initialize message list if p_init_msg_list is set to TRUE.
      IF FND_API.to_Boolean( p_init_msg_list )
      THEN
          FND_MSG_PUB.initialize;

Line: 1133


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

Line: 1148


END Validate_LAST_UPDATED_LOGIN;

Line: 1187


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


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

Line: 1281


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

Line: 1328


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

Line: 1375


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


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

Line: 1517


          Validate_LAST_UPDATED_LOGIN(
              p_init_msg_list          => FND_API.G_FALSE,
              p_validation_mode        => p_validation_mode,
              p_LAST_UPDATED_LOGIN   => P_mol_Rec.LAST_UPDATED_LOGIN,
              -- Hint: You may add x_item_property_rec as one of your OUT parameter if you'd like to pass back item property.
              x_return_status          => x_return_status,
              x_msg_count              => x_msg_count,
              x_msg_data               => x_msg_data);