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,
          --bug#12697494, yvchen
          p_CREATED_BY  => p_REPH_rec.CREATED_BY, --p_CREATED_BY  => G_USER_ID,
          p_CREATION_DATE  => SYSDATE,
          --bug#12697494, yvchen
          p_LAST_UPDATED_BY  => p_REPH_rec.LAST_UPDATED_BY, --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: 224


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


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


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

Line: 401


      SAVEPOINT UPDATE_REPAIR_HISTORY_PVT;

Line: 435


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


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

Line: 474


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


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

Line: 546


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


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

Line: 557


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


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


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

Line: 596


      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,
          --bug#12697494, yvchen: does not allow updating of CREATED_BY
          p_CREATED_BY  => FND_API.G_MISS_NUM, --p_CREATED_BY  => G_USER_ID,
          p_CREATION_DATE  => SYSDATE,
          --bug#12697494, yvchen
          p_LAST_UPDATED_BY  => p_REPH_rec.LAST_UPDATED_BY, --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: 686


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


End Update_repair_history;

Line: 737


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


      SAVEPOINT DELETE_REPAIR_HISTORY_PVT;

Line: 788


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


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

Line: 819


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


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


End Delete_repair_history;

Line: 1103


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


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


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

Line: 1178


END Gen_Select;

Line: 1188


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

Line: 1191


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

Line: 1218


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


          OPEN c_chk_str2(P_REPH_Rec.PROGRAM_UPDATE_DATE);

Line: 1247


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

Line: 1335


l_select_cl              VARCHAR2(2000) := '';

Line: 1399


      Gen_Select(l_select_cl);

Line: 1598


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


        SELECT OBJECT_VERSION_NUMBER
          INTO l_OBJECT_VERSION_NUMBER
          FROM CSD_REPAIR_HISTORY
           WHERE REPAIR_HISTORY_ID = P_REPAIR_HISTORY_ID;

Line: 3987


    Select
         REPAIR_HISTORY_ID
        ,REQUEST_ID
        ,PROGRAM_ID
        ,PROGRAM_APPLICATION_ID
        ,PROGRAM_UPDATE_DATE
        ,CREATED_BY
        ,CREATION_DATE
        ,LAST_UPDATED_BY
        ,LAST_UPDATE_DATE
        ,LAST_UPDATE_LOGIN
        ,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
        ,OBJECT_VERSION_NUMBER
    From  CSD_REPAIR_HISTORY
    where repair_history_id = p_REPAIR_HISTORY_ID;

Line: 4053


    select user_name
    from fnd_user
    where user_id = p_user_id;

Line: 4058


    select meaning
    from fnd_lookups
    where lookup_type = p_lookup_type
    and lookup_code = p_status_code;

Line: 4065


    select repair_number
    from csd_repairs
    where repair_line_id = p_repair_line_id;

Line: 4078


            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.LAST_UPDATE_LOGIN     ,
            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.OBJECT_VERSION_NUMBER ;