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

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

Line: 31


    P_LAST_UPDATE_DATE           IN   DATE,
    P_CREATED_BY                 IN   NUMBER,
    P_LAST_UPDATED_BY            IN   NUMBER,
    P_LAST_UPDATE_LOGIN          IN   NUMBER,
    P_ATTRIBUTE1                 IN   VARCHAR2,
    P_ATTRIBUTE2                 IN   VARCHAR2 ,
    P_ATTRIBUTE3                 IN   VARCHAR2,
    P_ATTRIBUTE4                 IN   VARCHAR2,
    P_ATTRIBUTE5                 IN   VARCHAR2,
    P_ATTRIBUTE6                 IN   VARCHAR2,
    P_ATTRIBUTE7                 IN   VARCHAR2,
    P_ATTRIBUTE8                 IN   VARCHAR2,
    P_ATTRIBUTE9                 IN   VARCHAR2,
    P_ATTRIBUTE10                IN   VARCHAR2,
    P_ATTRIBUTE11                IN   VARCHAR2,
    P_ATTRIBUTE12                IN   VARCHAR2,
    P_ATTRIBUTE13                IN   VARCHAR2,
    P_ATTRIBUTE14                IN   VARCHAR2,
    P_ATTRIBUTE15                IN   VARCHAR2,
    P_ATTRIBUTE_CATEGORY         IN   VARCHAR2,
    P_OBJECT_VERSION_NUMBER      IN   NUMBER ,
    x_csc_plan_lines_rec         OUT  NOCOPY CSC_PLAN_LINES_REC_TYPE)
IS
BEGIN
   x_csc_plan_lines_rec.LINE_ID               := P_LINE_ID;

Line: 59


   x_csc_plan_lines_rec.LAST_UPDATE_DATE      := P_LAST_UPDATE_DATE ;

Line: 61


   x_csc_plan_lines_rec.LAST_UPDATED_BY       := P_LAST_UPDATED_BY ;

Line: 62


   x_csc_plan_lines_rec.LAST_UPDATE_LOGIN     := P_LAST_UPDATE_LOGIN ;

Line: 96


    P_LAST_UPDATE_DATE           IN   DATE,
    P_CREATED_BY                 IN   NUMBER,
    P_LAST_UPDATED_BY            IN   NUMBER,
    P_LAST_UPDATE_LOGIN          IN   NUMBER,
    P_ATTRIBUTE1                 IN   VARCHAR2,
    P_ATTRIBUTE2                 IN   VARCHAR2,
    P_ATTRIBUTE3                 IN   VARCHAR2,
    P_ATTRIBUTE4                 IN   VARCHAR2,
    P_ATTRIBUTE5                 IN   VARCHAR2,
    P_ATTRIBUTE6                 IN   VARCHAR2,
    P_ATTRIBUTE7                 IN   VARCHAR2,
    P_ATTRIBUTE8                 IN   VARCHAR2,
    P_ATTRIBUTE9                 IN   VARCHAR2,
    P_ATTRIBUTE10                IN   VARCHAR2,
    P_ATTRIBUTE11                IN   VARCHAR2,
    P_ATTRIBUTE12                IN   VARCHAR2,
    P_ATTRIBUTE13                IN   VARCHAR2,
    P_ATTRIBUTE14                IN   VARCHAR2,
    P_ATTRIBUTE15                IN   VARCHAR2,
    P_ATTRIBUTE_CATEGORY         IN   VARCHAR2,
    P_OBJECT_VERSION_NUMBER      IN   NUMBER,
    X_LINE_ID                    OUT  NOCOPY NUMBER,
    X_OBJECT_VERSION_NUMBER      OUT  NOCOPY NUMBER,
    X_Return_Status              OUT  NOCOPY VARCHAR2,
    X_Msg_Count                  OUT  NOCOPY NUMBER,
    X_Msg_Data                   OUT  NOCOPY VARCHAR2
    )
IS
   l_csc_plan_lines_rec       CSC_PLAN_LINES_REC_TYPE;

Line: 132


      P_LAST_UPDATE_DATE      => p_last_update_date,
      P_CREATED_BY            => p_created_by,
      P_LAST_UPDATED_BY       => p_last_updated_by,
      P_LAST_UPDATE_LOGIN     => p_last_update_login,
      P_ATTRIBUTE1            => p_attribute1,
      P_ATTRIBUTE2            => p_attribute2,
      P_ATTRIBUTE3            => p_attribute3,
      P_ATTRIBUTE4            => p_attribute4,
      P_ATTRIBUTE5            => p_attribute5,
      P_ATTRIBUTE6            => p_attribute6,
      P_ATTRIBUTE7            => p_attribute7,
      P_ATTRIBUTE8            => p_attribute8,
      P_ATTRIBUTE9            => p_attribute9,
      P_ATTRIBUTE10           => p_attribute10,
      P_ATTRIBUTE11           => p_attribute11,
      P_ATTRIBUTE12           => p_attribute12,
      P_ATTRIBUTE13           => p_attribute13,
      P_ATTRIBUTE14           => p_attribute14,
      P_ATTRIBUTE15           => p_attribute15,
      P_ATTRIBUTE_CATEGORY    => p_attribute_category,
      P_OBJECT_VERSION_NUMBER => p_object_version_number,
      x_csc_plan_lines_rec    => l_csc_plan_lines_rec);

Line: 243


      CSC_PLAN_LINES_PKG.Insert_Row(
          px_LINE_ID               => x_LINE_ID,
          p_PLAN_ID                => p_CSC_PLAN_LINES_rec.PLAN_ID,
          p_CONDITION_ID           => p_CSC_PLAN_LINES_rec.CONDITION_ID,
          p_CREATION_DATE          => SYSDATE,
          p_LAST_UPDATE_DATE       => SYSDATE,
          p_CREATED_BY             => FND_GLOBAL.USER_ID,
          p_LAST_UPDATED_BY        => FND_GLOBAL.USER_ID,
          p_LAST_UPDATE_LOGIN      => FND_GLOBAL.CONC_LOGIN_ID,
          p_ATTRIBUTE1             => p_CSC_PLAN_LINES_rec.ATTRIBUTE1,
          p_ATTRIBUTE2             => p_CSC_PLAN_LINES_rec.ATTRIBUTE2,
          p_ATTRIBUTE3             => p_CSC_PLAN_LINES_rec.ATTRIBUTE3,
          p_ATTRIBUTE4             => p_CSC_PLAN_LINES_rec.ATTRIBUTE4,
          p_ATTRIBUTE5             => p_CSC_PLAN_LINES_rec.ATTRIBUTE5,
          p_ATTRIBUTE6             => p_CSC_PLAN_LINES_rec.ATTRIBUTE6,
          p_ATTRIBUTE7             => p_CSC_PLAN_LINES_rec.ATTRIBUTE7,
          p_ATTRIBUTE8             => p_CSC_PLAN_LINES_rec.ATTRIBUTE8,
          p_ATTRIBUTE9             => p_CSC_PLAN_LINES_rec.ATTRIBUTE9,
          p_ATTRIBUTE10            => p_CSC_PLAN_LINES_rec.ATTRIBUTE10,
          p_ATTRIBUTE11            => p_CSC_PLAN_LINES_rec.ATTRIBUTE11,
          p_ATTRIBUTE12            => p_CSC_PLAN_LINES_rec.ATTRIBUTE12,
          p_ATTRIBUTE13            => p_CSC_PLAN_LINES_rec.ATTRIBUTE13,
          p_ATTRIBUTE14            => p_CSC_PLAN_LINES_rec.ATTRIBUTE14,
          p_ATTRIBUTE15            => p_CSC_PLAN_LINES_rec.ATTRIBUTE15,
          p_ATTRIBUTE_CATEGORY     => p_CSC_PLAN_LINES_rec.ATTRIBUTE_CATEGORY,
          x_OBJECT_VERSION_NUMBER  => X_OBJECT_VERSION_NUMBER);

Line: 320


PROCEDURE Update_plan_lines(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    p_validation_level           IN   NUMBER,
    P_LINE_ID                    IN   NUMBER,
    P_PLAN_ID                    IN   NUMBER,
    P_CONDITION_ID               IN   NUMBER,
    P_CREATION_DATE              IN   DATE,
    P_LAST_UPDATE_DATE           IN   DATE,
    P_CREATED_BY                 IN   NUMBER,
    P_LAST_UPDATED_BY            IN   NUMBER,
    P_LAST_UPDATE_LOGIN          IN   NUMBER,
    P_ATTRIBUTE1                 IN   VARCHAR2,
    P_ATTRIBUTE2                 IN   VARCHAR2,
    P_ATTRIBUTE3                 IN   VARCHAR2,
    P_ATTRIBUTE4                 IN   VARCHAR2,
    P_ATTRIBUTE5                 IN   VARCHAR2,
    P_ATTRIBUTE6                 IN   VARCHAR2,
    P_ATTRIBUTE7                 IN   VARCHAR2,
    P_ATTRIBUTE8                 IN   VARCHAR2,
    P_ATTRIBUTE9                 IN   VARCHAR2,
    P_ATTRIBUTE10                IN   VARCHAR2,
    P_ATTRIBUTE11                IN   VARCHAR2,
    P_ATTRIBUTE12                IN   VARCHAR2,
    P_ATTRIBUTE13                IN   VARCHAR2,
    P_ATTRIBUTE14                IN   VARCHAR2,
    P_ATTRIBUTE15                IN   VARCHAR2,
    P_ATTRIBUTE_CATEGORY         IN   VARCHAR2,
    P_OBJECT_VERSION_NUMBER      IN   NUMBER,
    X_OBJECT_VERSION_NUMBER      OUT  NOCOPY NUMBER,
    X_Return_Status              OUT  NOCOPY VARCHAR2,
    X_Msg_Count                  OUT  NOCOPY NUMBER,
    X_Msg_Data                   OUT  NOCOPY VARCHAR2)
IS

   l_csc_plan_lines_rec       CSC_PLAN_LINES_REC_TYPE;

Line: 364


      P_LAST_UPDATE_DATE      => p_last_update_date,
      P_CREATED_BY            => p_created_by,
      P_LAST_UPDATED_BY       => p_last_updated_by,
      P_LAST_UPDATE_LOGIN     => p_last_update_login,
      P_ATTRIBUTE1            => p_attribute1,
      P_ATTRIBUTE2            => p_attribute2,
      P_ATTRIBUTE3            => p_attribute3,
      P_ATTRIBUTE4            => p_attribute4,
      P_ATTRIBUTE5            => p_attribute5,
      P_ATTRIBUTE6            => p_attribute6,
      P_ATTRIBUTE7            => p_attribute7,
      P_ATTRIBUTE8            => p_attribute8,
      P_ATTRIBUTE9            => p_attribute9,
      P_ATTRIBUTE10           => p_attribute10,
      P_ATTRIBUTE11           => p_attribute11,
      P_ATTRIBUTE12           => p_attribute12,
      P_ATTRIBUTE13           => p_attribute13,
      P_ATTRIBUTE14           => p_attribute14,
      P_ATTRIBUTE15           => p_attribute15,
      P_ATTRIBUTE_CATEGORY    => p_attribute_category,
      P_OBJECT_VERSION_NUMBER => p_object_version_number,
      x_csc_plan_lines_rec    => l_csc_plan_lines_rec);

Line: 389


   Update_plan_lines(
      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_CSC_PLAN_LINES_Rec    => l_csc_plan_lines_rec,
      X_OBJECT_VERSION_NUMBER => x_object_version_number,
      X_Return_Status         => x_return_status,
      X_Msg_Count             => x_msg_count,
      X_Msg_Data              => x_msg_data );

Line: 400


END  update_plan_lines;  /* end of overloaded update */

Line: 402


PROCEDURE Update_plan_lines(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    p_validation_level           IN   NUMBER,
    P_CSC_PLAN_LINES_Rec         IN   CSC_PLAN_LINES_Rec_Type,
    X_OBJECT_VERSION_NUMBER      OUT  NOCOPY NUMBER,
    X_Return_Status              OUT  NOCOPY VARCHAR2,
    X_Msg_Count                  OUT  NOCOPY NUMBER,
    X_Msg_Data                   OUT  NOCOPY VARCHAR2
    )
IS
   Cursor C_Get_plan_lines(C_LINE_ID Number) IS
    Select rowid,             LINE_ID,          PLAN_ID,
           CONDITION_ID,      LAST_UPDATE_DATE, CREATION_DATE,
           LAST_UPDATED_BY,   CREATED_BY,       LAST_UPDATE_LOGIN,
           ATTRIBUTE1,        ATTRIBUTE2,       ATTRIBUTE3,
           ATTRIBUTE4,        ATTRIBUTE5,       ATTRIBUTE6,
           ATTRIBUTE7,        ATTRIBUTE8,       ATTRIBUTE9,
           ATTRIBUTE10,       ATTRIBUTE11,      ATTRIBUTE12,
           ATTRIBUTE13,       ATTRIBUTE14,      ATTRIBUTE15,
           ATTRIBUTE_CATEGORY,OBJECT_VERSION_NUMBER
    From  CSC_PLAN_LINES
    where line_id = c_line_id
    For Update NOWAIT;

Line: 428


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

Line: 436


      SAVEPOINT UPDATE_PLAN_LINES_PVT;

Line: 463


               l_ref_CSC_PLAN_LINES_rec.LAST_UPDATE_DATE,
               l_ref_CSC_PLAN_LINES_rec.CREATION_DATE,
               l_ref_CSC_PLAN_LINES_rec.LAST_UPDATED_BY,
               l_ref_CSC_PLAN_LINES_rec.CREATED_BY,
               l_ref_CSC_PLAN_LINES_rec.LAST_UPDATE_LOGIN,
               l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE1,
               l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE2,
               l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE3,
               l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE4,
               l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE5,
               l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE6,
               l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE7,
               l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE8,
               l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE9,
               l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE10,
               l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE11,
               l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE12,
               l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE13,
               l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE14,
               l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE15,
               l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE_CATEGORY,
               l_ref_CSC_PLAN_LINES_rec.OBJECT_VERSION_NUMBER;

Line: 490


               FND_MESSAGE.Set_Name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'API_MISSING_UPDATE_TARGET');

Line: 505


              p_validation_mode     => CSC_CORE_UTILS_PVT.G_UPDATE,
              P_CSC_PLAN_LINES_Rec  => P_CSC_PLAN_LINES_Rec,
              x_return_status       => x_return_status,
              x_msg_count           => x_msg_count,
              x_msg_data            => x_msg_data);

Line: 517


      CSC_PLAN_LINES_PKG.Update_Row(
          p_LINE_ID                => p_CSC_PLAN_LINES_rec.LINE_ID,
          p_PLAN_ID                => p_CSC_PLAN_LINES_rec.PLAN_ID,
          p_CONDITION_ID           => p_CSC_PLAN_LINES_rec.CONDITION_ID,
          p_CREATION_DATE          => SYSDATE,
          p_LAST_UPDATE_DATE       => SYSDATE,
          p_CREATED_BY             => FND_GLOBAL.USER_ID,
          p_LAST_UPDATED_BY        => FND_GLOBAL.USER_ID,
          p_LAST_UPDATE_LOGIN      => FND_GLOBAL.CONC_LOGIN_ID,
          p_ATTRIBUTE1             => p_CSC_PLAN_LINES_rec.ATTRIBUTE1,
          p_ATTRIBUTE2             => p_CSC_PLAN_LINES_rec.ATTRIBUTE2,
          p_ATTRIBUTE3             => p_CSC_PLAN_LINES_rec.ATTRIBUTE3,
          p_ATTRIBUTE4             => p_CSC_PLAN_LINES_rec.ATTRIBUTE4,
          p_ATTRIBUTE5             => p_CSC_PLAN_LINES_rec.ATTRIBUTE5,
          p_ATTRIBUTE6             => p_CSC_PLAN_LINES_rec.ATTRIBUTE6,
          p_ATTRIBUTE7             => p_CSC_PLAN_LINES_rec.ATTRIBUTE7,
          p_ATTRIBUTE8             => p_CSC_PLAN_LINES_rec.ATTRIBUTE8,
          p_ATTRIBUTE9             => p_CSC_PLAN_LINES_rec.ATTRIBUTE9,
          p_ATTRIBUTE10            => p_CSC_PLAN_LINES_rec.ATTRIBUTE10,
          p_ATTRIBUTE11            => p_CSC_PLAN_LINES_rec.ATTRIBUTE11,
          p_ATTRIBUTE12            => p_CSC_PLAN_LINES_rec.ATTRIBUTE12,
          p_ATTRIBUTE13            => p_CSC_PLAN_LINES_rec.ATTRIBUTE13,
          p_ATTRIBUTE14            => p_CSC_PLAN_LINES_rec.ATTRIBUTE14,
          p_ATTRIBUTE15            => p_CSC_PLAN_LINES_rec.ATTRIBUTE15,
          p_ATTRIBUTE_CATEGORY     => p_CSC_PLAN_LINES_rec.ATTRIBUTE_CATEGORY,
          x_OBJECT_VERSION_NUMBER  => X_OBJECT_VERSION_NUMBER);

Line: 590


End Update_plan_lines;

Line: 593


PROCEDURE Delete_plan_lines(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    P_PLAN_ID                    IN   NUMBER,
    P_LINE_ID                    IN   NUMBER,
    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_plan_lines';

Line: 608


      SAVEPOINT DELETE_PLAN_LINES_PVT;

Line: 629


      CSC_PLAN_LINES_PKG.Delete_Row(
                            p_PLAN_ID  => P_PLAN_ID,
                            p_LINE_ID  => P_LINE_ID);

Line: 678


End Delete_plan_lines;

Line: 693


      select line_id
      from   CSC_PLAN_LINES
      where  line_id = p_line_id;

Line: 710


      IF( p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE ) THEN
         if ( p_line_id is NULL or p_line_id = FND_API.G_MISS_NUM ) then
            fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');

Line: 754


     select plan_id
     from   csc_plan_headers_b
     where  plan_id = p_plan_id;

Line: 815


      select id
      from   okc_condition_headers_b
      where  id = p_condition_id;

Line: 820


	 select 1
	 from   csc_plan_lines
	 where  plan_id      = p_plan_id
	 and    condition_id = p_condition_id;

Line: 865


      if ( (p_validation_mode <> CSC_CORE_UTILS_PVT.G_UPDATE) AND  (c2%FOUND) ) then
            fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_DUPLICATE_VALUE');

Line: 914


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