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

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

Line: 153


          csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Create_repair_history before CSD_REPAIR_HISTORY_PKG.Insert_Row');

Line: 157


      CSD_REPAIR_HISTORY_PKG.Insert_Row(
          px_REPAIR_HISTORY_ID  => x_REPAIR_HISTORY_ID,
          p_OBJECT_VERSION_NUMBER  => 1, -- travi p_REPH_rec.OBJECT_VERSION_NUMBER,
          p_REQUEST_ID  => p_REPH_rec.REQUEST_ID,
          p_PROGRAM_ID  => p_REPH_rec.PROGRAM_ID,
          p_PROGRAM_APPLICATION_ID  => p_REPH_rec.PROGRAM_APPLICATION_ID,
          p_PROGRAM_UPDATE_DATE  => p_REPH_rec.PROGRAM_UPDATE_DATE,
          p_CREATED_BY  => G_USER_ID,
          p_CREATION_DATE  => SYSDATE,
          p_LAST_UPDATED_BY  => G_USER_ID,
          p_LAST_UPDATE_DATE  => SYSDATE,
          p_REPAIR_LINE_ID  => p_REPH_rec.REPAIR_LINE_ID,
          p_EVENT_CODE  => p_REPH_rec.EVENT_CODE,
          p_EVENT_DATE  => p_REPH_rec.EVENT_DATE,
          p_QUANTITY  => p_REPH_rec.QUANTITY,
          p_PARAMN1  => p_REPH_rec.PARAMN1,
          p_PARAMN2  => p_REPH_rec.PARAMN2,
          p_PARAMN3  => p_REPH_rec.PARAMN3,
          p_PARAMN4  => p_REPH_rec.PARAMN4,
          p_PARAMN5  => p_REPH_rec.PARAMN5,
          p_PARAMN6  => p_REPH_rec.PARAMN6,
          p_PARAMN7  => p_REPH_rec.PARAMN7,
          p_PARAMN8  => p_REPH_rec.PARAMN8,
          p_PARAMN9  => p_REPH_rec.PARAMN9,
          p_PARAMN10  => p_REPH_rec.PARAMN10,
          p_PARAMC1  => p_REPH_rec.PARAMC1,
          p_PARAMC2  => p_REPH_rec.PARAMC2,
          p_PARAMC3  => p_REPH_rec.PARAMC3,
          p_PARAMC4  => p_REPH_rec.PARAMC4,
          p_PARAMC5  => p_REPH_rec.PARAMC5,
          p_PARAMC6  => p_REPH_rec.PARAMC6,
          p_PARAMC7  => p_REPH_rec.PARAMC7,
          p_PARAMC8  => p_REPH_rec.PARAMC8,
          p_PARAMC9  => p_REPH_rec.PARAMC9,
          p_PARAMC10  => p_REPH_rec.PARAMC10,
          p_PARAMD1  => p_REPH_rec.PARAMD1,
          p_PARAMD2  => p_REPH_rec.PARAMD2,
          p_PARAMD3  => p_REPH_rec.PARAMD3,
          p_PARAMD4  => p_REPH_rec.PARAMD4,
          p_PARAMD5  => p_REPH_rec.PARAMD5,
          p_PARAMD6  => p_REPH_rec.PARAMD6,
          p_PARAMD7  => p_REPH_rec.PARAMD7,
          p_PARAMD8  => p_REPH_rec.PARAMD8,
          p_PARAMD9  => p_REPH_rec.PARAMD9,
          p_PARAMD10  => p_REPH_rec.PARAMD10,
          p_ATTRIBUTE_CATEGORY  => p_REPH_rec.ATTRIBUTE_CATEGORY,
          p_ATTRIBUTE1  => p_REPH_rec.ATTRIBUTE1,
          p_ATTRIBUTE2  => p_REPH_rec.ATTRIBUTE2,
          p_ATTRIBUTE3  => p_REPH_rec.ATTRIBUTE3,
          p_ATTRIBUTE4  => p_REPH_rec.ATTRIBUTE4,
          p_ATTRIBUTE5  => p_REPH_rec.ATTRIBUTE5,
          p_ATTRIBUTE6  => p_REPH_rec.ATTRIBUTE6,
          p_ATTRIBUTE7  => p_REPH_rec.ATTRIBUTE7,
          p_ATTRIBUTE8  => p_REPH_rec.ATTRIBUTE8,
          p_ATTRIBUTE9  => p_REPH_rec.ATTRIBUTE9,
          p_ATTRIBUTE10  => p_REPH_rec.ATTRIBUTE10,
          p_ATTRIBUTE11  => p_REPH_rec.ATTRIBUTE11,
          p_ATTRIBUTE12  => p_REPH_rec.ATTRIBUTE12,
          p_ATTRIBUTE13  => p_REPH_rec.ATTRIBUTE13,
          p_ATTRIBUTE14  => p_REPH_rec.ATTRIBUTE14,
          p_ATTRIBUTE15  => p_REPH_rec.ATTRIBUTE15,
          p_LAST_UPDATE_LOGIN  => p_REPH_rec.LAST_UPDATE_LOGIN);

Line: 222


          csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Create_repair_history after CSD_REPAIR_HISTORY_PKG.Insert_Row x_return_status'||x_return_status);

Line: 306


PROCEDURE Update_repair_history(
    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_REPH_Rec     IN    REPH_Rec_Type,
    X_Return_Status              OUT NOCOPY  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY  NUMBER,
    X_Msg_Data                   OUT NOCOPY  VARCHAR2
    )

 IS
/*
Cursor C_Get_repair_history(REPAIR_HISTORY_ID Number) IS
    Select rowid,
           REPAIR_HISTORY_ID,
           OBJECT_VERSION_NUMBER,
           REQUEST_ID,
           PROGRAM_ID,
           PROGRAM_APPLICATION_ID,
           PROGRAM_UPDATE_DATE,
           CREATED_BY,
           CREATION_DATE,
           LAST_UPDATED_BY,
           LAST_UPDATE_DATE,
           REPAIR_LINE_ID,
           EVENT_CODE,
           EVENT_DATE,
           QUANTITY,
           PARAMN1,
           PARAMN2,
           PARAMN3,
           PARAMN4,
           PARAMN5,
           PARAMN6,
           PARAMN7,
           PARAMN8,
           PARAMN9,
           PARAMN10,
           PARAMC1,
           PARAMC2,
           PARAMC3,
           PARAMC4,
           PARAMC5,
           PARAMC6,
           PARAMC7,
           PARAMC8,
           PARAMC9,
           PARAMC10,
           PARAMD1,
           PARAMD2,
           PARAMD3,
           PARAMD4,
           PARAMD5,
           PARAMD6,
           PARAMD7,
           PARAMD8,
           PARAMD9,
           PARAMD10,
           ATTRIBUTE_CATEGORY,
           ATTRIBUTE1,
           ATTRIBUTE2,
           ATTRIBUTE3,
           ATTRIBUTE4,
           ATTRIBUTE5,
           ATTRIBUTE6,
           ATTRIBUTE7,
           ATTRIBUTE8,
           ATTRIBUTE9,
           ATTRIBUTE10,
           ATTRIBUTE11,
           ATTRIBUTE12,
           ATTRIBUTE13,
           ATTRIBUTE14,
           ATTRIBUTE15,
           LAST_UPDATE_LOGIN
    From  CSD_REPAIR_HISTORY
    -- Hint: Developer need to provide Where clause
    For Update NOWAIT;

Line: 386


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

Line: 399


      SAVEPOINT UPDATE_REPAIR_HISTORY_PVT;

Line: 433


          AS_CALLOUT_PKG.Update_repair_history_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_REPH_Rec      =>  P_REPH_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: 460


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

Line: 472


               l_ref_REPH_rec.PROGRAM_UPDATE_DATE,
               l_ref_REPH_rec.CREATED_BY,
               l_ref_REPH_rec.CREATION_DATE,
               l_ref_REPH_rec.LAST_UPDATED_BY,
               l_ref_REPH_rec.LAST_UPDATE_DATE,
               l_ref_REPH_rec.REPAIR_LINE_ID,
               l_ref_REPH_rec.EVENT_CODE,
               l_ref_REPH_rec.EVENT_DATE,
               l_ref_REPH_rec.QUANTITY,
               l_ref_REPH_rec.PARAMN1,
               l_ref_REPH_rec.PARAMN2,
               l_ref_REPH_rec.PARAMN3,
               l_ref_REPH_rec.PARAMN4,
               l_ref_REPH_rec.PARAMN5,
               l_ref_REPH_rec.PARAMN6,
               l_ref_REPH_rec.PARAMN7,
               l_ref_REPH_rec.PARAMN8,
               l_ref_REPH_rec.PARAMN9,
               l_ref_REPH_rec.PARAMN10,
               l_ref_REPH_rec.PARAMC1,
               l_ref_REPH_rec.PARAMC2,
               l_ref_REPH_rec.PARAMC3,
               l_ref_REPH_rec.PARAMC4,
               l_ref_REPH_rec.PARAMC5,
               l_ref_REPH_rec.PARAMC6,
               l_ref_REPH_rec.PARAMC7,
               l_ref_REPH_rec.PARAMC8,
               l_ref_REPH_rec.PARAMC9,
               l_ref_REPH_rec.PARAMC10,
               l_ref_REPH_rec.PARAMD1,
               l_ref_REPH_rec.PARAMD2,
               l_ref_REPH_rec.PARAMD3,
               l_ref_REPH_rec.PARAMD4,
               l_ref_REPH_rec.PARAMD5,
               l_ref_REPH_rec.PARAMD6,
               l_ref_REPH_rec.PARAMD7,
               l_ref_REPH_rec.PARAMD8,
               l_ref_REPH_rec.PARAMD9,
               l_ref_REPH_rec.PARAMD10,
               l_ref_REPH_rec.ATTRIBUTE_CATEGORY,
               l_ref_REPH_rec.ATTRIBUTE1,
               l_ref_REPH_rec.ATTRIBUTE2,
               l_ref_REPH_rec.ATTRIBUTE3,
               l_ref_REPH_rec.ATTRIBUTE4,
               l_ref_REPH_rec.ATTRIBUTE5,
               l_ref_REPH_rec.ATTRIBUTE6,
               l_ref_REPH_rec.ATTRIBUTE7,
               l_ref_REPH_rec.ATTRIBUTE8,
               l_ref_REPH_rec.ATTRIBUTE9,
               l_ref_REPH_rec.ATTRIBUTE10,
               l_ref_REPH_rec.ATTRIBUTE11,
               l_ref_REPH_rec.ATTRIBUTE12,
               l_ref_REPH_rec.ATTRIBUTE13,
               l_ref_REPH_rec.ATTRIBUTE14,
               l_ref_REPH_rec.ATTRIBUTE15,
               l_ref_REPH_rec.LAST_UPDATE_LOGIN;

Line: 532


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

Line: 544


      If (l_tar_REPH_rec.last_update_date is NULL or
          l_tar_REPH_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: 549


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

Line: 555


      If (l_tar_REPH_rec.last_update_date <> l_ref_REPH_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: 574


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

Line: 588


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

Line: 594


      CSD_REPAIR_HISTORY_PKG.Update_Row(
          p_REPAIR_HISTORY_ID  => p_REPH_rec.REPAIR_HISTORY_ID,
          p_OBJECT_VERSION_NUMBER  => l_OBJECT_VERSION_NUMBER, -- travi p_REPH_rec.OBJECT_VERSION_NUMBER,
          p_REQUEST_ID  => p_REPH_rec.REQUEST_ID,
          p_PROGRAM_ID  => p_REPH_rec.PROGRAM_ID,
          p_PROGRAM_APPLICATION_ID  => p_REPH_rec.PROGRAM_APPLICATION_ID,
          p_PROGRAM_UPDATE_DATE  => p_REPH_rec.PROGRAM_UPDATE_DATE,
          p_CREATED_BY  => G_USER_ID,
          p_CREATION_DATE  => SYSDATE,
          p_LAST_UPDATED_BY  => G_USER_ID,
          p_LAST_UPDATE_DATE  => SYSDATE,
          p_REPAIR_LINE_ID  => p_REPH_rec.REPAIR_LINE_ID,
          p_EVENT_CODE  => p_REPH_rec.EVENT_CODE,
          p_EVENT_DATE  => p_REPH_rec.EVENT_DATE,
          p_QUANTITY  => p_REPH_rec.QUANTITY,
          p_PARAMN1  => p_REPH_rec.PARAMN1,
          p_PARAMN2  => p_REPH_rec.PARAMN2,
          p_PARAMN3  => p_REPH_rec.PARAMN3,
          p_PARAMN4  => p_REPH_rec.PARAMN4,
          p_PARAMN5  => p_REPH_rec.PARAMN5,
          p_PARAMN6  => p_REPH_rec.PARAMN6,
          p_PARAMN7  => p_REPH_rec.PARAMN7,
          p_PARAMN8  => p_REPH_rec.PARAMN8,
          p_PARAMN9  => p_REPH_rec.PARAMN9,
          p_PARAMN10  => p_REPH_rec.PARAMN10,
          p_PARAMC1  => p_REPH_rec.PARAMC1,
          p_PARAMC2  => p_REPH_rec.PARAMC2,
          p_PARAMC3  => p_REPH_rec.PARAMC3,
          p_PARAMC4  => p_REPH_rec.PARAMC4,
          p_PARAMC5  => p_REPH_rec.PARAMC5,
          p_PARAMC6  => p_REPH_rec.PARAMC6,
          p_PARAMC7  => p_REPH_rec.PARAMC7,
          p_PARAMC8  => p_REPH_rec.PARAMC8,
          p_PARAMC9  => p_REPH_rec.PARAMC9,
          p_PARAMC10  => p_REPH_rec.PARAMC10,
          p_PARAMD1  => p_REPH_rec.PARAMD1,
          p_PARAMD2  => p_REPH_rec.PARAMD2,
          p_PARAMD3  => p_REPH_rec.PARAMD3,
          p_PARAMD4  => p_REPH_rec.PARAMD4,
          p_PARAMD5  => p_REPH_rec.PARAMD5,
          p_PARAMD6  => p_REPH_rec.PARAMD6,
          p_PARAMD7  => p_REPH_rec.PARAMD7,
          p_PARAMD8  => p_REPH_rec.PARAMD8,
          p_PARAMD9  => p_REPH_rec.PARAMD9,
          p_PARAMD10  => p_REPH_rec.PARAMD10,
          p_ATTRIBUTE_CATEGORY  => p_REPH_rec.ATTRIBUTE_CATEGORY,
          p_ATTRIBUTE1  => p_REPH_rec.ATTRIBUTE1,
          p_ATTRIBUTE2  => p_REPH_rec.ATTRIBUTE2,
          p_ATTRIBUTE3  => p_REPH_rec.ATTRIBUTE3,
          p_ATTRIBUTE4  => p_REPH_rec.ATTRIBUTE4,
          p_ATTRIBUTE5  => p_REPH_rec.ATTRIBUTE5,
          p_ATTRIBUTE6  => p_REPH_rec.ATTRIBUTE6,
          p_ATTRIBUTE7  => p_REPH_rec.ATTRIBUTE7,
          p_ATTRIBUTE8  => p_REPH_rec.ATTRIBUTE8,
          p_ATTRIBUTE9  => p_REPH_rec.ATTRIBUTE9,
          p_ATTRIBUTE10  => p_REPH_rec.ATTRIBUTE10,
          p_ATTRIBUTE11  => p_REPH_rec.ATTRIBUTE11,
          p_ATTRIBUTE12  => p_REPH_rec.ATTRIBUTE12,
          p_ATTRIBUTE13  => p_REPH_rec.ATTRIBUTE13,
          p_ATTRIBUTE14  => p_REPH_rec.ATTRIBUTE14,
          p_ATTRIBUTE15  => p_REPH_rec.ATTRIBUTE15,
          p_LAST_UPDATE_LOGIN  => p_REPH_rec.LAST_UPDATE_LOGIN);

Line: 682


          AS_CALLOUT_PKG.Update_repair_history_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_REPH_Rec      =>  P_REPH_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: 728


End Update_repair_history;

Line: 733


PROCEDURE Delete_repair_history(
    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_REPH_Rec     IN REPH_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_repair_history';

Line: 750


      SAVEPOINT DELETE_REPAIR_HISTORY_PVT;

Line: 784


          AS_CALLOUT_PKG.Delete_repair_history_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_REPH_Rec      =>  P_REPH_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: 812


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

Line: 815


      CSD_REPAIR_HISTORY_PKG.Delete_Row(
          p_REPAIR_HISTORY_ID  => p_REPH_rec.REPAIR_HISTORY_ID,
          p_OBJECT_VERSION_NUMBER  => p_REPH_rec.OBJECT_VERSION_NUMBER);

Line: 844


          AS_CALLOUT_PKG.Delete_repair_history_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_REPH_Rec      =>  P_REPH_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: 890


End Delete_repair_history;

Line: 1099


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


      x_select_cl := 'Select ' ||
                'CSD_REPAIR_HISTORY_V.REPAIR_HISTORY_ID,' ||
                'CSD_REPAIR_HISTORY_V.REQUEST_ID,' ||
                'CSD_REPAIR_HISTORY_V.PROGRAM_ID,' ||
                'CSD_REPAIR_HISTORY_V.PROGRAM_APPLICATION_ID,' ||
                'CSD_REPAIR_HISTORY_V.PROGRAM_UPDATE_DATE,' ||
                'CSD_REPAIR_HISTORY_V.CREATED_BY,' ||
                'CSD_REPAIR_HISTORY_V.CREATION_DATE,' ||
                'CSD_REPAIR_HISTORY_V.LAST_UPDATED_BY,' ||
                'CSD_REPAIR_HISTORY_V.LAST_UPDATE_DATE,' ||
                'CSD_REPAIR_HISTORY_V.LAST_UPDATE_LOGIN,' ||
                'CSD_REPAIR_HISTORY_V.REPAIR_LINE_ID,' ||
                'CSD_REPAIR_HISTORY_V.EVENT_CODE,' ||
                'CSD_REPAIR_HISTORY_V.EVENT_MEANING,' ||
                'CSD_REPAIR_HISTORY_V.EVENT_DATE,' ||
                'CSD_REPAIR_HISTORY_V.QUANTITY,' ||
                'CSD_REPAIR_HISTORY_V.PARAMN1,' ||
                'CSD_REPAIR_HISTORY_V.PARAMN2,' ||
                'CSD_REPAIR_HISTORY_V.PARAMN3,' ||
                'CSD_REPAIR_HISTORY_V.PARAMN4,' ||
                'CSD_REPAIR_HISTORY_V.PARAMN5,' ||
                'CSD_REPAIR_HISTORY_V.PARAMN6,' ||
                'CSD_REPAIR_HISTORY_V.PARAMN7,' ||
                'CSD_REPAIR_HISTORY_V.PARAMN8,' ||
                'CSD_REPAIR_HISTORY_V.PARAMN9,' ||
                'CSD_REPAIR_HISTORY_V.PARAMN10,' ||
                'CSD_REPAIR_HISTORY_V.PARAMC1,' ||
                'CSD_REPAIR_HISTORY_V.PARAMC2,' ||
                'CSD_REPAIR_HISTORY_V.PARAMC3,' ||
                'CSD_REPAIR_HISTORY_V.PARAMC4,' ||
                'CSD_REPAIR_HISTORY_V.PARAMC5,' ||
                'CSD_REPAIR_HISTORY_V.PARAMC6,' ||
                'CSD_REPAIR_HISTORY_V.PARAMC7,' ||
                'CSD_REPAIR_HISTORY_V.PARAMC8,' ||
                'CSD_REPAIR_HISTORY_V.PARAMC9,' ||
                'CSD_REPAIR_HISTORY_V.PARAMC10,' ||
                'CSD_REPAIR_HISTORY_V.PARAMD1,' ||
                'CSD_REPAIR_HISTORY_V.PARAMD2,' ||
                'CSD_REPAIR_HISTORY_V.PARAMD3,' ||
                'CSD_REPAIR_HISTORY_V.PARAMD4,' ||
                'CSD_REPAIR_HISTORY_V.PARAMD5,' ||
                'CSD_REPAIR_HISTORY_V.PARAMD6,' ||
                'CSD_REPAIR_HISTORY_V.PARAMD7,' ||
                'CSD_REPAIR_HISTORY_V.PARAMD8,' ||
                'CSD_REPAIR_HISTORY_V.PARAMD9,' ||
                'CSD_REPAIR_HISTORY_V.PARAMD10,' ||
                'CSD_REPAIR_HISTORY_V.ATTRIBUTE_CATEGORY,' ||
                'CSD_REPAIR_HISTORY_V.ATTRIBUTE1,' ||
                'CSD_REPAIR_HISTORY_V.ATTRIBUTE2,' ||
                'CSD_REPAIR_HISTORY_V.ATTRIBUTE3,' ||
                'CSD_REPAIR_HISTORY_V.ATTRIBUTE4,' ||
                'CSD_REPAIR_HISTORY_V.ATTRIBUTE5,' ||
                'CSD_REPAIR_HISTORY_V.ATTRIBUTE6,' ||
                'CSD_REPAIR_HISTORY_V.ATTRIBUTE7,' ||
                'CSD_REPAIR_HISTORY_V.ATTRIBUTE8,' ||
                'CSD_REPAIR_HISTORY_V.ATTRIBUTE9,' ||
                'CSD_REPAIR_HISTORY_V.ATTRIBUTE10,' ||
                'CSD_REPAIR_HISTORY_V.ATTRIBUTE11,' ||
                'CSD_REPAIR_HISTORY_V.ATTRIBUTE12,' ||
                'CSD_REPAIR_HISTORY_V.ATTRIBUTE13,' ||
                'CSD_REPAIR_HISTORY_V.ATTRIBUTE14,' ||
                'CSD_REPAIR_HISTORY_V.ATTRIBUTE15,' ||
                'CSD_REPAIR_HISTORY_V.OBJECT_VERSION_NUMBER' ||
                'from CSD_REPAIR_HISTORY_V';

Line: 1172


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

Line: 1174


END Gen_Select;

Line: 1184


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

Line: 1187


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

Line: 1214


      IF( (P_REPH_Rec.PROGRAM_UPDATE_DATE IS NOT NULL) AND (P_REPH_Rec.PROGRAM_UPDATE_DATE <> FND_API.G_MISS_DATE) )
      THEN
          -- check if item value contains '%' wildcard
          OPEN c_chk_str1(P_REPH_Rec.PROGRAM_UPDATE_DATE);

Line: 1228


          OPEN c_chk_str2(P_REPH_Rec.PROGRAM_UPDATE_DATE);

Line: 1243


          x_REPH_where := x_REPH_where || 'P_REPH_Rec.PROGRAM_UPDATE_DATE ' || l_operator || ' :p_PROGRAM_UPDATE_DATE';

Line: 1331


l_select_cl              VARCHAR2(2000) := '';

Line: 1395


      Gen_Select(l_select_cl);

Line: 1594


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

Line: 1641


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

Line: 1695


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


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

Line: 1805


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

Line: 1859


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

Line: 1906


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


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

Line: 2000


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

Line: 2047


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

Line: 2094


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

Line: 2141


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

Line: 2188


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

Line: 2235


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

Line: 2282


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

Line: 2329


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

Line: 2376


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

Line: 2423


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

Line: 2470


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

Line: 2517


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

Line: 2564


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

Line: 2611


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

Line: 2658


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

Line: 2705


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

Line: 2752


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

Line: 2799


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

Line: 2846


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

Line: 2893


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

Line: 2940


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

Line: 2987


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

Line: 3034


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

Line: 3081


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

Line: 3128


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

Line: 3175


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

Line: 3222


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

Line: 3269


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

Line: 3316


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

Line: 3370


      ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
      THEN

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

Line: 3383


        SELECT OBJECT_VERSION_NUMBER
          INTO l_OBJECT_VERSION_NUMBER
          FROM CSD_REPAIR_HISTORY
           WHERE REPAIR_HISTORY_ID = P_REPAIR_HISTORY_ID;