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

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

Line: 128


             select count(*)
               into l_act_count
               from csd_repair_actuals
              where repair_line_id = px_CSD_REPAIR_ACTUALS_REC.repair_line_id;

Line: 162


                FND_LOG.STRING(Fnd_Log.Level_Procedure,l_mod_name,'Call to CSD_REPAIR_ACTUALS_PKG.Insert_Row');

Line: 168


          CSD_REPAIR_ACTUALS_PKG.Insert_Row(
              px_REPAIR_ACTUAL_ID      => px_CSD_REPAIR_ACTUALS_REC.REPAIR_ACTUAL_ID
             ,p_OBJECT_VERSION_NUMBER  => px_CSD_REPAIR_ACTUALS_REC.OBJECT_VERSION_NUMBER
             ,p_REPAIR_LINE_ID         => px_CSD_REPAIR_ACTUALS_REC.REPAIR_LINE_ID
             ,p_CREATED_BY             => FND_GLOBAL.USER_ID
             ,p_CREATION_DATE          => SYSDATE
             ,p_LAST_UPDATED_BY        => FND_GLOBAL.USER_ID
             ,p_LAST_UPDATE_DATE       => SYSDATE
             ,p_LAST_UPDATE_LOGIN      => FND_GLOBAL.CONC_LOGIN_ID
             ,p_ATTRIBUTE_CATEGORY     => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE_CATEGORY
             ,p_ATTRIBUTE1             => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE1
             ,p_ATTRIBUTE2             => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE2
             ,p_ATTRIBUTE3             => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE3
             ,p_ATTRIBUTE4             => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE4
             ,p_ATTRIBUTE5             => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE5
             ,p_ATTRIBUTE6             => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE6
             ,p_ATTRIBUTE7             => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE7
             ,p_ATTRIBUTE8             => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE8
             ,p_ATTRIBUTE9             => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE9
             ,p_ATTRIBUTE10            => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE10
             ,p_ATTRIBUTE11            => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE11
             ,p_ATTRIBUTE12            => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE12
             ,p_ATTRIBUTE13            => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE13
             ,p_ATTRIBUTE14            => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE14
             ,p_ATTRIBUTE15            => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE15
             ,p_BILL_TO_ACCOUNT_ID     => px_CSD_REPAIR_ACTUALS_REC.BILL_TO_ACCOUNT_ID
             ,p_BILL_TO_PARTY_ID       => px_CSD_REPAIR_ACTUALS_REC.BILL_TO_PARTY_ID
             ,p_BILL_TO_PARTY_SITE_ID  => px_CSD_REPAIR_ACTUALS_REC.BILL_TO_PARTY_SITE_ID
             );

Line: 201


                      FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Others exception n CSD_REPAIR_ACTUALS_PKG.Insert_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));

Line: 264


/* procedure name: UPDATE_REPAIR_ACTUALS                              */
/* description : procedure used to Update Repair Actuals              */
/*                                                                    */
/*                                                                    */
/*                                                                    */
/* Called from : Depot Repair Actuals UI                              */
/* Input Parm  :                                                      */
/*   p_api_version       NUMBER    Req Api Version number             */
/*   p_init_msg_list     VARCHAR2  Opt Initialize message stack       */
/*   p_commit            VARCHAR2  Opt Commits in API                 */
/*   p_validation_level  NUMBER    Opt validation steps               */
/*   px_CSD_REPAIR_ACTUALS_REC REC Req Actuals Record                 */
/* Output Parm :                                                      */
/*   x_return_status     VARCHAR2      Return status after the call.  */
/*   x_msg_count         NUMBER        Number of messages in stack    */
/*   x_msg_data          VARCHAR2      Mesg. text if x_msg_count >= 1 */
/* Change Hist :                                                      */
/*   08/11/03  travikan  Initial Creation.                            */
/*                                                                    */
/*                                                                    */
/*                                                                    */
/*--------------------------------------------------------------------*/
    PROCEDURE UPDATE_REPAIR_ACTUALS(
        P_Api_Version                IN            NUMBER,
        P_Commit                     IN            VARCHAR2,
        P_Init_Msg_List              IN            VARCHAR2,
        p_validation_level           IN            NUMBER,
        px_CSD_REPAIR_ACTUALS_REC    IN OUT NOCOPY CSD_REPAIR_ACTUALS_REC_TYPE,
        X_Return_Status              OUT    NOCOPY VARCHAR2,
        X_Msg_Count                  OUT    NOCOPY NUMBER,
        X_Msg_Data                   OUT    NOCOPY VARCHAR2
        )

     IS
      -- Variables used in FND Log
      l_stat_level   number   := FND_LOG.LEVEL_STATEMENT;

Line: 305


      l_mod_name     varchar2(2000) := 'csd.plsql.CSD_REPAIR_ACTUALS_PVT.UPDATE_REPAIR_ACTUALS';

Line: 307


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

Line: 318


      SELECT
         a.repair_actual_id,
         a.object_version_number
      FROM csd_repair_actuals a,
           csd_repairs b
      WHERE a.repair_line_id = b.repair_line_id
        and a.repair_actual_id  = p_actual_id;

Line: 328


          SAVEPOINT UPDATE_REPAIR_ACTUALS;

Line: 349


                FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'At the Beginning of update_repair_actual_lines');

Line: 425


                FND_LOG.STRING(Fnd_Log.Level_Procedure,l_mod_name,'Call to CSD_REPAIR_ACTUALS_PKG.Update_Row');

Line: 431


          CSD_REPAIR_ACTUALS_PKG.Update_Row(
              p_REPAIR_ACTUAL_ID       => px_CSD_REPAIR_ACTUALS_REC.REPAIR_ACTUAL_ID
             ,p_OBJECT_VERSION_NUMBER  => px_CSD_REPAIR_ACTUALS_REC.OBJECT_VERSION_NUMBER
             ,p_REPAIR_LINE_ID         => px_CSD_REPAIR_ACTUALS_REC.REPAIR_LINE_ID
             ,p_CREATED_BY             => FND_API.G_MISS_NUM
             ,p_CREATION_DATE          => FND_API.G_MISS_DATE
             ,p_LAST_UPDATED_BY        => FND_GLOBAL.USER_ID
             ,p_LAST_UPDATE_DATE       => SYSDATE
             ,p_LAST_UPDATE_LOGIN      => FND_GLOBAL.CONC_LOGIN_ID
             ,p_ATTRIBUTE_CATEGORY     => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE_CATEGORY
             ,p_ATTRIBUTE1             => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE1
             ,p_ATTRIBUTE2             => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE2
             ,p_ATTRIBUTE3             => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE3
             ,p_ATTRIBUTE4             => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE4
             ,p_ATTRIBUTE5             => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE5
             ,p_ATTRIBUTE6             => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE6
             ,p_ATTRIBUTE7             => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE7
             ,p_ATTRIBUTE8             => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE8
             ,p_ATTRIBUTE9             => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE9
             ,p_ATTRIBUTE10            => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE10
             ,p_ATTRIBUTE11            => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE11
             ,p_ATTRIBUTE12            => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE12
             ,p_ATTRIBUTE13            => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE13
             ,p_ATTRIBUTE14            => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE14
             ,p_ATTRIBUTE15            => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE15
             ,p_BILL_TO_ACCOUNT_ID     => px_CSD_REPAIR_ACTUALS_REC.BILL_TO_ACCOUNT_ID
             ,p_BILL_TO_PARTY_ID       => px_CSD_REPAIR_ACTUALS_REC.BILL_TO_PARTY_ID
             ,p_BILL_TO_PARTY_SITE_ID  => px_CSD_REPAIR_ACTUALS_REC.BILL_TO_PARTY_SITE_ID
             );

Line: 467


                      FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Others exception in CSD_REPAIR_ACTUALS_PKG.Update_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));

Line: 495


              ROLLBACK TO UPDATE_REPAIR_ACTUALS;

Line: 504


              ROLLBACK TO UPDATE_REPAIR_ACTUALS;

Line: 514


              ROLLBACK TO UPDATE_REPAIR_ACTUALS;

Line: 525


    End UPDATE_REPAIR_ACTUALS;

Line: 529


/* procedure name: DELETE_REPAIR_ACTUALS                              */
/* description : procedure used to Delete Repair Actuals              */
/*                                                                    */
/*                                                                    */
/*                                                                    */
/* Called from : Depot Repair Actuals UI                              */
/* Input Parm  :                                                      */
/*   p_api_version       NUMBER    Req Api Version number             */
/*   p_init_msg_list     VARCHAR2  Opt Initialize message stack       */
/*   p_commit            VARCHAR2  Opt Commits in API                 */
/*   p_validation_level  NUMBER    Opt validation steps               */
/*   px_CSD_REPAIR_ACTUALS_REC REC Req Actuals Record                 */
/* Output Parm :                                                      */
/*   x_return_status     VARCHAR2      Return status after the call.  */
/*   x_msg_count         NUMBER        Number of messages in stack    */
/*   x_msg_data          VARCHAR2      Mesg. text if x_msg_count >= 1 */
/* Change Hist :                                                      */
/*   08/11/03  travikan  Initial Creation.                            */
/*                                                                    */
/*                                                                    */
/*                                                                    */
/*--------------------------------------------------------------------*/
    PROCEDURE DELETE_REPAIR_ACTUALS(
        P_Api_Version                IN            NUMBER,
        P_Commit                     IN            VARCHAR2,
        P_Init_Msg_List              IN            VARCHAR2,
        p_validation_level           IN            NUMBER,
        px_CSD_REPAIR_ACTUALS_REC    IN OUT NOCOPY CSD_REPAIR_ACTUALS_REC_TYPE,
        X_Return_Status              OUT    NOCOPY VARCHAR2,
        X_Msg_Count                  OUT    NOCOPY NUMBER,
        X_Msg_Data                   OUT    NOCOPY VARCHAR2
        )

     IS
       -- Variables used in FND Log
       l_stat_level   number   := FND_LOG.LEVEL_STATEMENT;

Line: 570


       l_mod_name     varchar2(2000) := 'csd.plsql.CSD_REPAIR_ACTUALS_PVT.DELETE_REPAIR_ACTUALS';

Line: 572


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

Line: 583


      SELECT
         a.repair_actual_id,
         a.object_version_number
      FROM csd_repair_actuals a,
           csd_repairs b
      WHERE a.repair_line_id = b.repair_line_id
        and a.repair_actual_id  = p_actual_id;

Line: 593


          SAVEPOINT DELETE_REPAIR_ACTUALS;

Line: 614


                FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'At the Beginning of delete_repair_actual_lines');

Line: 697


             SELECT count(*)
               INTO l_act_line_count
               FROM csd_repair_actual_lines
              WHERE repair_actual_id = l_actual_id;

Line: 727


               FND_LOG.STRING(Fnd_Log.Level_Procedure,l_mod_name,'Call to  CSD_REPAIR_ACTUALS_PKG.Delete_Row');

Line: 733


          CSD_REPAIR_ACTUALS_PKG.Delete_Row(
              p_REPAIR_ACTUAL_ID       => px_CSD_REPAIR_ACTUALS_REC.REPAIR_ACTUAL_ID
             ,p_OBJECT_VERSION_NUMBER  => px_CSD_REPAIR_ACTUALS_REC.OBJECT_VERSION_NUMBER);

Line: 768


              ROLLBACK TO DELETE_REPAIR_ACTUALS;

Line: 777


              ROLLBACK TO DELETE_REPAIR_ACTUALS;

Line: 787


              ROLLBACK TO DELETE_REPAIR_ACTUALS;

Line: 798


    End DELETE_REPAIR_ACTUALS;