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

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

Line: 145


      CSD_REPAIR_JOB_XREF_PKG.Insert_Row(
          px_REPAIR_JOB_XREF_ID  => x_REPAIR_JOB_XREF_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_UPDATE_LOGIN  => G_LOGIN_ID,
          p_REPAIR_LINE_ID  => p_REPJOBXREF_rec.REPAIR_LINE_ID,
          p_WIP_ENTITY_ID  => p_REPJOBXREF_rec.WIP_ENTITY_ID,
          p_GROUP_ID  => p_REPJOBXREF_rec.GROUP_ID,
          p_ORGANIZATION_ID  => p_REPJOBXREF_rec.ORGANIZATION_ID,
          p_QUANTITY  => p_REPJOBXREF_rec.QUANTITY,
          p_INVENTORY_ITEM_ID => p_REPJOBXREF_rec.INVENTORY_ITEM_ID,
          p_ITEM_REVISION  => p_REPJOBXREF_rec.ITEM_REVISION,
          p_SOURCE_TYPE_CODE => p_REPJOBXREF_rec.SOURCE_TYPE_CODE,
          p_SOURCE_ID1       => p_REPJOBXREF_rec.SOURCE_ID1,
          p_RO_SERVICE_CODE_ID => p_REPJOBXREF_rec.RO_SERVICE_CODE_ID,
          p_JOB_NAME       =>  p_REPJOBXREF_rec.JOB_NAME,
          p_OBJECT_VERSION_NUMBER => p_REPJOBXREF_rec.OBJECT_VERSION_NUMBER,
          p_ATTRIBUTE_CATEGORY  => p_REPJOBXREF_rec.ATTRIBUTE_CATEGORY,
          p_ATTRIBUTE1  => p_REPJOBXREF_rec.ATTRIBUTE1,
          p_ATTRIBUTE2  => p_REPJOBXREF_rec.ATTRIBUTE2,
          p_ATTRIBUTE3  => p_REPJOBXREF_rec.ATTRIBUTE3,
          p_ATTRIBUTE4  => p_REPJOBXREF_rec.ATTRIBUTE4,
          p_ATTRIBUTE5  => p_REPJOBXREF_rec.ATTRIBUTE5,
          p_ATTRIBUTE6  => p_REPJOBXREF_rec.ATTRIBUTE6,
          p_ATTRIBUTE7  => p_REPJOBXREF_rec.ATTRIBUTE7,
          p_ATTRIBUTE8  => p_REPJOBXREF_rec.ATTRIBUTE8,
          p_ATTRIBUTE9  => p_REPJOBXREF_rec.ATTRIBUTE9,
          p_ATTRIBUTE10  => p_REPJOBXREF_rec.ATTRIBUTE10,
          p_ATTRIBUTE11  => p_REPJOBXREF_rec.ATTRIBUTE11,
          p_ATTRIBUTE12  => p_REPJOBXREF_rec.ATTRIBUTE12,
          p_ATTRIBUTE13  => p_REPJOBXREF_rec.ATTRIBUTE13,
          p_ATTRIBUTE14  => p_REPJOBXREF_rec.ATTRIBUTE14,
          p_ATTRIBUTE15  => p_REPJOBXREF_rec.ATTRIBUTE15,
        p_QUANTITY_COMPLETED => p_REPJOBXREF_rec.QUANTITY_COMPLETED);

Line: 263


PROCEDURE Update_repjobxref(
    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_REPJOBXREF_Rec     IN    REPJOBXREF_Rec_Type,
    X_Return_Status              OUT NOCOPY  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY  NUMBER,
    X_Msg_Data                   OUT NOCOPY  VARCHAR2
    )

 IS
/*
Cursor C_Get_repjobxref(REPAIR_JOB_XREF_ID Number) IS
    Select rowid,
           REPAIR_JOB_XREF_ID,
           CREATED_BY,
           CREATION_DATE,
           LAST_UPDATED_BY,
           LAST_UPDATE_DATE,
           LAST_UPDATE_LOGIN,
           REPAIR_LINE_ID,
           WIP_ENTITY_ID,
           GROUP_ID,
           ORGANIZATION_ID,
           QUANTITY,
         INVENTORY_ITEM_ID,
         ITEM_REVISION,
         OBJECT_VERSION_NUMBER,
           ATTRIBUTE_CATEGORY,
           ATTRIBUTE1,
           ATTRIBUTE2,
           ATTRIBUTE3,
           ATTRIBUTE4,
           ATTRIBUTE5,
           ATTRIBUTE6,
           ATTRIBUTE7,
           ATTRIBUTE8,
           ATTRIBUTE9,
           ATTRIBUTE10,
           ATTRIBUTE11,
           ATTRIBUTE12,
           ATTRIBUTE13,
           ATTRIBUTE14,
           ATTRIBUTE15,
         QUANTITY_COMPLETED
    From  CSD_REPAIR_JOB_XREF
    -- Hint: Developer need to provide Where clause
    For Update OBJECT_VERSION_NUMBER NOWAIT;

Line: 314


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

Line: 323


      SAVEPOINT UPDATE_REPJOBXREF_PVT;

Line: 357


          AS_CALLOUT_PKG.Update_repjobxref_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_REPJOBXREF_Rec      =>  P_REPJOBXREF_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, 'CSD', 'Private API: - Open Cursor to Select');

Line: 396


               l_ref_REPJOBXREF_rec.LAST_UPDATED_BY,
               l_ref_REPJOBXREF_rec.LAST_UPDATE_DATE,
               l_ref_REPJOBXREF_rec.LAST_UPDATE_LOGIN,
               l_ref_REPJOBXREF_rec.REPAIR_LINE_ID,
               l_ref_REPJOBXREF_rec.WIP_ENTITY_ID,
               l_ref_REPJOBXREF_rec.GROUP_ID,
               l_ref_REPJOBXREF_rec.ORGANIZATION_ID,
               l_ref_REPJOBXREF_rec.QUANTITY,
             l_ref_REPJOBXREF_rec.INVENTORY_ITEM_ID,
             l_ref_REPJOBXREF_rec.ITEM_REVISION,
             l_ref_REPJOBXREF_rec.OBJECT_VERSION_NUMBER,
               l_ref_REPJOBXREF_rec.ATTRIBUTE_CATEGORY,
               l_ref_REPJOBXREF_rec.ATTRIBUTE1,
               l_ref_REPJOBXREF_rec.ATTRIBUTE2,
               l_ref_REPJOBXREF_rec.ATTRIBUTE3,
               l_ref_REPJOBXREF_rec.ATTRIBUTE4,
               l_ref_REPJOBXREF_rec.ATTRIBUTE5,
               l_ref_REPJOBXREF_rec.ATTRIBUTE6,
               l_ref_REPJOBXREF_rec.ATTRIBUTE7,
               l_ref_REPJOBXREF_rec.ATTRIBUTE8,
               l_ref_REPJOBXREF_rec.ATTRIBUTE9,
               l_ref_REPJOBXREF_rec.ATTRIBUTE10,
               l_ref_REPJOBXREF_rec.ATTRIBUTE11,
               l_ref_REPJOBXREF_rec.ATTRIBUTE12,
               l_ref_REPJOBXREF_rec.ATTRIBUTE13,
               l_ref_REPJOBXREF_rec.ATTRIBUTE14,
               l_ref_REPJOBXREF_rec.ATTRIBUTE15,
            l_ref_REPJOBXREF_rec.QUANTITY_COMPLETED;

Line: 428


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

Line: 440


      If (l_tar_REPJOBXREF_rec.last_update_date is NULL or
          l_tar_REPJOBXREF_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('CSD', 'API_MISSING_ID');

Line: 445


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

Line: 451


      If (l_tar_REPJOBXREF_rec.last_update_date <> l_ref_REPJOBXREF_rec.last_update_date) Then
          IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
          THEN
              FND_MESSAGE.Set_Name('CSD', 'API_RECORD_CHANGED');

Line: 470


              p_validation_mode  => JTF_PLSQL_API.G_UPDATE,
              P_REPJOBXREF_Rec  =>  P_REPJOBXREF_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, 'CSD', 'Private API: Calling update table handler');

Line: 488


      CSD_REPAIR_JOB_XREF_PKG.Update_Row(
          p_REPAIR_JOB_XREF_ID  => p_REPJOBXREF_rec.REPAIR_JOB_XREF_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_UPDATE_LOGIN  => G_LOGIN_ID,
          p_REPAIR_LINE_ID  => p_REPJOBXREF_rec.REPAIR_LINE_ID,
          p_WIP_ENTITY_ID  => p_REPJOBXREF_rec.WIP_ENTITY_ID,
          p_GROUP_ID  => p_REPJOBXREF_rec.GROUP_ID,
          p_ORGANIZATION_ID  => p_REPJOBXREF_rec.ORGANIZATION_ID,
          p_QUANTITY  => p_REPJOBXREF_rec.QUANTITY,
          p_INVENTORY_ITEM_ID  => p_REPJOBXREF_rec.INVENTORY_ITEM_ID,
          p_ITEM_REVISION  => p_REPJOBXREF_rec.ITEM_REVISION,
          p_OBJECT_VERSION_NUMBER  => p_REPJOBXREF_rec.OBJECT_VERSION_NUMBER,
          p_ATTRIBUTE_CATEGORY  => p_REPJOBXREF_rec.ATTRIBUTE_CATEGORY,
          p_ATTRIBUTE1  => p_REPJOBXREF_rec.ATTRIBUTE1,
          p_ATTRIBUTE2  => p_REPJOBXREF_rec.ATTRIBUTE2,
          p_ATTRIBUTE3  => p_REPJOBXREF_rec.ATTRIBUTE3,
          p_ATTRIBUTE4  => p_REPJOBXREF_rec.ATTRIBUTE4,
          p_ATTRIBUTE5  => p_REPJOBXREF_rec.ATTRIBUTE5,
          p_ATTRIBUTE6  => p_REPJOBXREF_rec.ATTRIBUTE6,
          p_ATTRIBUTE7  => p_REPJOBXREF_rec.ATTRIBUTE7,
          p_ATTRIBUTE8  => p_REPJOBXREF_rec.ATTRIBUTE8,
          p_ATTRIBUTE9  => p_REPJOBXREF_rec.ATTRIBUTE9,
          p_ATTRIBUTE10  => p_REPJOBXREF_rec.ATTRIBUTE10,
          p_ATTRIBUTE11  => p_REPJOBXREF_rec.ATTRIBUTE11,
          p_ATTRIBUTE12  => p_REPJOBXREF_rec.ATTRIBUTE12,
          p_ATTRIBUTE13  => p_REPJOBXREF_rec.ATTRIBUTE13,
          p_ATTRIBUTE14  => p_REPJOBXREF_rec.ATTRIBUTE14,
          p_ATTRIBUTE15  => p_REPJOBXREF_rec.ATTRIBUTE15,
        p_QUANTITY_COMPLETED => p_REPJOBXREF_rec.QUANTITY_COMPLETED);

Line: 546


          AS_CALLOUT_PKG.Update_repjobxref_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_REPJOBXREF_Rec      =>  P_REPJOBXREF_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: 592


End Update_repjobxref;

Line: 597


PROCEDURE Delete_repjobxref(
    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_REPJOBXREF_Rec     IN REPJOBXREF_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_repjobxref';

Line: 614


      SAVEPOINT DELETE_REPJOBXREF_PVT;

Line: 648


          AS_CALLOUT_PKG.Delete_repjobxref_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_REPJOBXREF_Rec      =>  P_REPJOBXREF_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: 676


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

Line: 679


      CSD_REPAIR_JOB_XREF_PKG.Delete_Row(
          p_REPAIR_JOB_XREF_ID  => p_REPJOBXREF_rec.REPAIR_JOB_XREF_ID);

Line: 707


          AS_CALLOUT_PKG.Delete_repjobxref_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_REPJOBXREF_Rec      =>  P_REPJOBXREF_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: 753


End Delete_repjobxref;

Line: 910


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

Line: 919


      x_select_cl := 'Select ' ||
                'CSD_REPAIR_JOB_XREF_V.REPAIR_JOB_XREF_ID,' ||
                'CSD_REPAIR_JOB_XREF_V.CREATED_BY,' ||
                'CSD_REPAIR_JOB_XREF_V.CREATION_DATE,' ||
                'CSD_REPAIR_JOB_XREF_V.LAST_UPDATED_BY,' ||
                'CSD_REPAIR_JOB_XREF_V.LAST_UPDATE_DATE,' ||
                'CSD_REPAIR_JOB_XREF_V.LAST_UPDATE_LOGIN,' ||
                'CSD_REPAIR_JOB_XREF_V.REPAIR_LINE_ID,' ||
                'CSD_REPAIR_JOB_XREF_V.WIP_ENTITY_ID,' ||
                'CSD_REPAIR_JOB_XREF_V.GROUP_ID,' ||
                'CSD_REPAIR_JOB_XREF_V.ORGANIZATION_ID,' ||
                'CSD_REPAIR_JOB_XREF_V.QUANTITY,' ||
                'CSD_REPAIR_JOB_XREF_V.INVENTORY_ITEM_ID,' ||
                'CSD_REPAIR_JOB_XREF_V.ITEM_REVISION,' ||
                'CSD_REPAIR_JOB_XREF_V.OBJECT_VERSION_NUMBER,' ||
                'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE_CATEGORY,' ||
                'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE1,' ||
                'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE2,' ||
                'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE3,' ||
                'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE4,' ||
                'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE5,' ||
                'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE6,' ||
                'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE7,' ||
                'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE8,' ||
                'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE9,' ||
                'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE10,' ||
                'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE11,' ||
                'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE12,' ||
                'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE13,' ||
                'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE14,' ||
                'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE15,' ||
                'CSD_REPAIR_JOB_XREF_V.QUANTITY_COMPLETED,' ||
                'from CSD_REPAIR_JOB_XREF_V';

Line: 953


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

Line: 955


END Gen_Select;

Line: 965


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

Line: 968


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

Line: 1112


l_select_cl              VARCHAR2(2000) := '';

Line: 1176


      Gen_Select(l_select_cl);

Line: 1376


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

Line: 1430


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


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

Line: 1538


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

Line: 1592


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


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

Line: 1713


      ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
      THEN

IF (g_debug > 0 ) THEN
     csd_gen_utility_pvt.add('CSD_REPAIR_JOB_XREF_PVT.Validate_OBJECT_VERSION_NUMBER in update');

Line: 1726


        SELECT OBJECT_VERSION_NUMBER
          INTO l_OBJECT_VERSION_NUMBER
          FROM CSD_REPAIR_JOB_XREF
           WHERE REPAIR_JOB_XREF_ID = P_REPAIR_JOB_XREF_ID;