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

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

Line: 66


    x_pvt_CSC_PLAN_LINES_rec.LAST_UPDATE_DATE := P_CSC_PLAN_LINES_Rec.LAST_UPDATE_DATE;

Line: 68


    x_pvt_CSC_PLAN_LINES_rec.LAST_UPDATED_BY := P_CSC_PLAN_LINES_Rec.LAST_UPDATED_BY;

Line: 69


    x_pvt_CSC_PLAN_LINES_rec.LAST_UPDATE_LOGIN := P_CSC_PLAN_LINES_Rec.LAST_UPDATE_LOGIN;

Line: 103


    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.ROW_ID                := P_ROW_ID;

Line: 132


   x_csc_plan_lines_rec.LAST_UPDATE_DATE      := P_LAST_UPDATE_DATE ;

Line: 134


   x_csc_plan_lines_rec.LAST_UPDATED_BY       := P_LAST_UPDATED_BY ;

Line: 135


   x_csc_plan_lines_rec.LAST_UPDATE_LOGIN     := P_LAST_UPDATE_LOGIN ;

Line: 169


    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_PUB.CSC_PLAN_LINES_REC_TYPE;

Line: 206


      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_attribute8,
      P_ATTRIBUTE10           => p_attribute9,
      P_ATTRIBUTE11           => p_attribute10,
      P_ATTRIBUTE12           => p_attribute11,
      P_ATTRIBUTE13           => p_attribute12,
      P_ATTRIBUTE14           => p_attribute13,
      P_ATTRIBUTE15           => p_attribute14,
      P_ATTRIBUTE_CATEGORY    => p_attribute15,
      P_OBJECT_VERSION_NUMBER => p_object_version_number,
      x_csc_plan_lines_rec    => l_csc_plan_lines_rec);

Line: 360


PROCEDURE Update_plan_lines(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    P_ROW_ID                     IN   ROWID,
    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_PUB.CSC_PLAN_LINES_REC_TYPE;

Line: 405


      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_attribute8,
      P_ATTRIBUTE10           => p_attribute9,
      P_ATTRIBUTE11           => p_attribute10,
      P_ATTRIBUTE12           => p_attribute11,
      P_ATTRIBUTE13           => p_attribute12,
      P_ATTRIBUTE14           => p_attribute13,
      P_ATTRIBUTE15           => p_attribute14,
      P_ATTRIBUTE_CATEGORY    => p_attribute15,
      P_OBJECT_VERSION_NUMBER => p_object_version_number,
      x_csc_plan_lines_rec    => l_csc_plan_lines_rec);

Line: 430


   Update_plan_lines(
      P_Api_Version_Number    => p_api_version_number,
      P_Init_Msg_List         => p_init_msg_list,
      P_Commit                => p_commit,
      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: 440


END  update_plan_lines;  /* end of overloaded update */

Line: 443


PROCEDURE Update_plan_lines(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    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
   l_api_name                CONSTANT VARCHAR2(30) := 'Update_plan_lines';

Line: 459


      SAVEPOINT UPDATE_PLAN_LINES_PUB;

Line: 485


      CSC_plan_lines_PVT.Update_plan_lines(
         P_Api_Version_Number         => 1.0,
         P_Init_Msg_List              => FND_API.G_FALSE,
         P_Commit                     => p_commit,
         P_Validation_Level           => FND_API.G_VALID_LEVEL_FULL,
         P_CSC_PLAN_LINES_Rec         => l_pvt_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: 548


End Update_plan_lines;

Line: 553


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


      SAVEPOINT DELETE_PLAN_LINES_PUB;

Line: 589


      CSC_plan_lines_PVT.Delete_plan_lines(
         P_Api_Version_Number         => 1.0,
         P_Init_Msg_List              => FND_API.G_FALSE,
         P_Commit                     => p_commit,
	    P_PLAN_ID                    => p_plan_id,
         P_LINE_ID                    => p_line_id,
         X_Return_Status              => x_return_status,
         X_Msg_Count                  => x_msg_count,
         X_Msg_Data                   => x_msg_data);

Line: 651


End Delete_plan_lines;