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

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

Line: 27


       x_pvt_CHK_RATING_REC.LAST_UPDATE_DATE     := P_CHK_RATING_Rec.LAST_UPDATE_DATE;

Line: 28


       x_pvt_CHK_RATING_REC.LAST_UPDATED_BY      := P_CHK_RATING_Rec.LAST_UPDATED_BY;

Line: 31


       x_pvt_CHK_RATING_REC.LAST_UPDATE_LOGIN    := P_CHK_RATING_Rec.LAST_UPDATE_LOGIN;

Line: 45


    p_LAST_UPDATE_DATE           IN   DATE,
    p_LAST_UPDATED_BY            IN   NUMBER,
    p_CREATION_DATE              IN   DATE,
    p_CREATED_BY                 IN   NUMBER,
    p_LAST_UPDATE_LOGIN          IN   NUMBER,
    p_SEEDED_FLAG                IN   VARCHAR2,
    X_Chk_rating_rec		   OUT NOCOPY  CHK_RATING_Rec_Type
  )
IS
BEGIN

    X_Chk_rating_rec.CHECK_ID	      := P_CHECK_ID;

Line: 67


    X_Chk_rating_rec.LAST_UPDATED_BY := P_LAST_UPDATED_BY;

Line: 68


    X_Chk_rating_rec.LAST_UPDATE_DATE := P_LAST_UPDATE_DATE;

Line: 69


    X_Chk_rating_rec.LAST_UPDATE_LOGIN := P_LAST_UPDATE_LOGIN;

Line: 89


    p_LAST_UPDATE_DATE           IN   DATE,
    p_LAST_UPDATED_BY            IN   NUMBER,
    p_CREATION_DATE              IN   DATE,
    p_CREATED_BY                 IN   NUMBER,
    p_LAST_UPDATE_LOGIN          IN   NUMBER,
    p_SEEDED_FLAG                IN   VARCHAR2,
    X_Return_Status              OUT NOCOPY  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY  NUMBER,
    X_Msg_Data                   OUT NOCOPY  VARCHAR2
    )
 IS
 l_chk_rating_rec CHK_RATING_Rec_Type  := G_MISS_CHK_RATING_Rec;

Line: 114


    P_LAST_UPDATED_BY 	=>    P_LAST_UPDATED_BY,
    P_LAST_UPDATE_DATE 	=>    P_LAST_UPDATE_DATE,
    P_LAST_UPDATE_LOGIN 	=>    P_LAST_UPDATE_LOGIN,
    p_SEEDED_FLAG       => p_SEEDED_FLAG,
    X_CHk_Rating_Rec	=> l_chk_rating_rec
    );

Line: 250


PROCEDURE Update_check_ratings(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    p_validation_level           IN   NUMBER  ,
    p_CHECK_RATING_ID            IN   NUMBER,
    p_CHECK_ID                   IN   NUMBER,
    p_CHECK_RATING_GRADE         IN   VARCHAR2,
    p_RATING_COLOR_ID            IN   NUMBER,
    p_RATING_CODE                IN   VARCHAR2,
    p_COLOR_CODE                 IN   VARCHAR2,
    p_RANGE_LOW_VALUE            IN   VARCHAR2,
    p_RANGE_HIGH_VALUE           IN   VARCHAR2,
    p_LAST_UPDATE_DATE           IN   DATE,
    p_LAST_UPDATED_BY            IN   NUMBER,
    p_CREATION_DATE              IN   DATE,
    p_CREATED_BY                 IN   NUMBER,
    p_LAST_UPDATE_LOGIN          IN   NUMBER,
    p_SEEDED_FLAG                IN   VARCHAR2,
    X_Return_Status              OUT NOCOPY  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY  NUMBER,
    X_Msg_Data                   OUT NOCOPY  VARCHAR2
    )
 IS
 l_chk_rating_rec CHK_RATING_Rec_Type  := G_MISS_CHK_RATING_Rec;

Line: 288


    P_LAST_UPDATED_BY 	=>    P_LAST_UPDATED_BY,
    P_LAST_UPDATE_DATE 	=>    P_LAST_UPDATE_DATE,
    P_LAST_UPDATE_LOGIN 	=>    P_LAST_UPDATE_LOGIN,
    P_SEEDED_FLAG       => P_SEEDED_FLAG,
    X_CHk_Rating_Rec	=> l_chk_rating_rec
    );

Line: 295


      Update_check_ratings(
      P_Api_Version_Number         => 1.0,
      P_Init_Msg_List              => CSC_CORE_UTILS_PVT.G_FALSE,
      P_Commit                     => CSC_CORE_UTILS_PVT.G_FALSE,
      P_Validation_Level           => CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
      P_CHK_RATING_Rec     	=>    l_CHK_RATING_Rec ,
      X_Return_Status              => x_return_status,
      X_Msg_Count                  => x_msg_count,
      X_Msg_Data                   => x_msg_data
      );

Line: 306


END Update_check_ratings;

Line: 308


PROCEDURE Update_check_ratings(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    p_validation_level           IN   NUMBER  ,
    P_CHK_RATING_Rec    	   IN   CHK_RATING_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) := 'Update_check_ratings';

Line: 325


      SAVEPOINT UPDATE_CHECK_RATINGS_PUB;

Line: 355


    CSC_check_ratings_PVT.Update_check_ratings(
     P_Api_Version_Number         => 1.0,
     P_Init_Msg_List              => CSC_CORE_UTILS_PVT.G_FALSE,
     P_Commit                     => CSC_CORE_UTILS_PVT.G_FALSE,
     P_Validation_Level           => CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
     P_CHK_RATING_Rec     	=>    l_PVT_CHK_RATING_Rec ,
     X_Return_Status              => x_return_status,
     X_Msg_Count                  => x_msg_count,
     X_Msg_Data                   => x_msg_data
     );

Line: 393


    		ROLLBACK TO Update_check_ratings_PUB;

Line: 400


    		ROLLBACK TO Update_check_ratings_PUB;

Line: 407


    		ROLLBACK TO Update_check_ratings_PUB;

Line: 416


End Update_check_ratings;

Line: 419


PROCEDURE Delete_check_ratings(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    p_validation_level           IN   NUMBER  ,
    P_CHECK_RATING_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_check_ratings';

Line: 435


      SAVEPOINT DELETE_CHECK_RATINGS_PUB;

Line: 462


    CSC_check_ratings_PVT.Delete_check_ratings(
    P_Api_Version_Number         => 1.0,
    P_Init_Msg_List              => CSC_CORE_UTILS_PVT.G_FALSE,
    P_Commit                     => p_commit,
    P_Validation_Level           => CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
    P_CHECK_RATING_Id  => p_CHECK_RATING_Id,
    X_Return_Status              => x_return_status,
    X_Msg_Count                  => x_msg_count,
    X_Msg_Data                   => x_msg_data );

Line: 500


    		ROLLBACK TO Delete_check_ratings_PUB;

Line: 507


    		ROLLBACK TO Delete_check_ratings_PUB;

Line: 514


    		ROLLBACK TO Delete_check_ratings_PUB;

Line: 524


End Delete_check_ratings;