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

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

Line: 18


      p_action_code                  IN   NUMBER,    /* 0 = insert, 1 = update, 2 = delete */
      px_REPAIR_HISTORY_ID   OUT NOCOPY NUMBER ,
      p_OBJECT_VERSION_NUMBER    in NUMBER            := FND_API.G_MISS_NUM,
      p_REQUEST_ID    in NUMBER            := FND_API.G_MISS_NUM,
      p_PROGRAM_ID    in NUMBER            := FND_API.G_MISS_NUM,
      p_PROGRAM_APPLICATION_ID    in NUMBER            := FND_API.G_MISS_NUM,
      p_PROGRAM_UPDATE_DATE    in DATE            := FND_API.G_MISS_DATE,
      p_CREATED_BY    in NUMBER                   := FND_API.G_MISS_NUM,
      p_CREATION_DATE   in  DATE                  := FND_API.G_MISS_DATE,
      p_LAST_UPDATED_BY   in  NUMBER     :=  FND_API.G_MISS_NUM,
      p_LAST_UPDATE_DATE    in DATE     :=  FND_API.G_MISS_DATE,
      p_REPAIR_LINE_ID    in NUMBER := FND_API.G_MISS_NUM,
      p_EVENT_CODE    in VARCHAR2,
      p_EVENT_DATE    in DATE,
      p_QUANTITY    in NUMBER    := FND_API.G_MISS_NUM,
      p_PARAMN1    in NUMBER    := FND_API.G_MISS_NUM,
      p_PARAMN2    in NUMBER  := FND_API.G_MISS_NUM,
      p_PARAMN3    in NUMBER  := FND_API.G_MISS_NUM,
      p_PARAMN4    in NUMBER  := FND_API.G_MISS_NUM,
      p_PARAMN5    in NUMBER  := FND_API.G_MISS_NUM,
      p_PARAMN6    in NUMBER  := FND_API.G_MISS_NUM,
      p_PARAMN7    in NUMBER  := FND_API.G_MISS_NUM,
      p_PARAMN8    in NUMBER  := FND_API.G_MISS_NUM,
      p_PARAMN9    in NUMBER  := FND_API.G_MISS_NUM,
      p_PARAMN10   in NUMBER  := FND_API.G_MISS_NUM,
      p_PARAMC1    in VARCHAR2  := FND_API.G_MISS_CHAR,
      p_PARAMC2    in VARCHAR2  := FND_API.G_MISS_CHAR,
      p_PARAMC3    in VARCHAR2  := FND_API.G_MISS_CHAR,
      p_PARAMC4    in VARCHAR2  := FND_API.G_MISS_CHAR,
      p_PARAMC5    in VARCHAR2  := FND_API.G_MISS_CHAR,
      p_PARAMC6    in VARCHAR2  := FND_API.G_MISS_CHAR,
      p_PARAMC7    in VARCHAR2  := FND_API.G_MISS_CHAR,
      p_PARAMC8    in VARCHAR2  := FND_API.G_MISS_CHAR,
      p_PARAMC9    in VARCHAR2  := FND_API.G_MISS_CHAR,
      p_PARAMC10   in  VARCHAR2  := FND_API.G_MISS_CHAR,
      p_PARAMD1    in DATE  := FND_API.G_MISS_DATE,
      p_PARAMD2    in DATE  := FND_API.G_MISS_DATE,
      p_PARAMD3    in DATE  := FND_API.G_MISS_DATE,
      p_PARAMD4    in DATE  := FND_API.G_MISS_DATE,
      p_PARAMD5    in DATE  := FND_API.G_MISS_DATE,
      p_PARAMD6    in DATE  := FND_API.G_MISS_DATE,
      p_PARAMD7    in DATE  := FND_API.G_MISS_DATE,
      p_PARAMD8    in DATE  := FND_API.G_MISS_DATE,
      p_PARAMD9    in DATE  := FND_API.G_MISS_DATE,
      p_PARAMD10   in  DATE  := FND_API.G_MISS_DATE,
      p_ATTRIBUTE_CATEGORY    in VARCHAR2  := FND_API.G_MISS_CHAR,
      p_ATTRIBUTE1    in VARCHAR2  := FND_API.G_MISS_CHAR,
      p_ATTRIBUTE2    in VARCHAR2  := FND_API.G_MISS_CHAR,
      p_ATTRIBUTE3    in VARCHAR2  := FND_API.G_MISS_CHAR,
      p_ATTRIBUTE4    in VARCHAR2  := FND_API.G_MISS_CHAR,
      p_ATTRIBUTE5    in VARCHAR2  := FND_API.G_MISS_CHAR,
      p_ATTRIBUTE6    in VARCHAR2  := FND_API.G_MISS_CHAR,
      p_ATTRIBUTE7    in VARCHAR2  := FND_API.G_MISS_CHAR,
      p_ATTRIBUTE8    in VARCHAR2  := FND_API.G_MISS_CHAR,
      p_ATTRIBUTE9    in VARCHAR2  := FND_API.G_MISS_CHAR,
      p_ATTRIBUTE10    in VARCHAR2  := FND_API.G_MISS_CHAR,
      p_ATTRIBUTE11    in VARCHAR2  := FND_API.G_MISS_CHAR,
      p_ATTRIBUTE12    in VARCHAR2  := FND_API.G_MISS_CHAR,
      p_ATTRIBUTE13    in VARCHAR2  := FND_API.G_MISS_CHAR,
      p_ATTRIBUTE14    in VARCHAR2  := FND_API.G_MISS_CHAR,
      p_ATTRIBUTE15    in VARCHAR2  := FND_API.G_MISS_CHAR,
      p_LAST_UPDATE_LOGIN    in NUMBER  := FND_API.G_MISS_CHAR,
      X_Return_Status              OUT NOCOPY  VARCHAR2  ,
      X_Msg_Count                  OUT NOCOPY  NUMBER ,
      X_Msg_Data                   OUT NOCOPY  VARCHAR2
     )
  IS
      l_repair_hist_rec CSD_REPAIR_HISTORY_PVT.REPH_Rec_Type;

Line: 96


          X_Msg_Data := 'Invalid action codes should indicate an Insert, Delete or Update action.';

Line: 106


    L_REPAIR_HIST_REC.PROGRAM_UPDATE_DATE       :=        p_PROGRAM_UPDATE_DATE   ;

Line: 109


    L_REPAIR_HIST_REC.LAST_UPDATED_BY           :=        p_LAST_UPDATED_BY ;

Line: 110


    L_REPAIR_HIST_REC.LAST_UPDATE_DATE          :=        p_LAST_UPDATE_DATE ;

Line: 161


    L_REPAIR_HIST_REC.LAST_UPDATE_LOGIN   :=          p_LAST_UPDATE_LOGIN ;

Line: 190


          csd_gen_utility_pvt.add('CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write before CSD_REPAIR_HISTORY_PVT.Update_repair_history call');

Line: 194


           CSD_REPAIR_HISTORY_PVT.update_repair_history(
               P_Api_Version_Number    => p_api_version_number,
               P_Init_Msg_List         => p_init_msg_list,
               P_Commit                => p_commit,
               p_validation_level      => p_validation_level,
               P_reph_rec               => l_repair_hist_rec,
               X_Return_Status         => x_return_status,
               X_Msg_Count             => x_msg_count,
               X_Msg_Data              => x_msg_data
               );

Line: 206


          csd_gen_utility_pvt.add('CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write after CSD_REPAIR_HISTORY_PVT.Update_repair_history  x_return_status'||x_return_status);

Line: 214


          csd_gen_utility_pvt.add('CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write before CSD_REPAIR_HISTORY_PVT.Delete_repair_history call');

Line: 219


           CSD_REPAIR_HISTORY_PVT.delete_repair_history(
               P_Api_Version_Number    => p_api_version_number,
               P_Init_Msg_List         => p_init_msg_list,
               P_Commit                => p_commit,
               p_validation_level      => p_validation_level,
               P_reph_rec               => l_repair_hist_rec,
               X_Return_Status         => x_return_status,
               X_Msg_Count             => x_msg_count,
               X_Msg_Data              => x_msg_data
               );

Line: 231


          csd_gen_utility_pvt.add('CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write after CSD_REPAIR_HISTORY_PVT.Delete_repair_history  x_return_status'||x_return_status);