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

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

Line: 25


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


    X_Chk_rating_rec.LAST_UPDATED_BY := P_LAST_UPDATED_BY;

Line: 48


    X_Chk_rating_rec.LAST_UPDATE_DATE := P_LAST_UPDATE_DATE;

Line: 49


    X_Chk_rating_rec.LAST_UPDATE_LOGIN := P_LAST_UPDATE_LOGIN;

Line: 69


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


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


      CSC_PROF_CHECK_RATINGS_PKG.Insert_Row(
          px_CHECK_RATING_ID  => px_CHECK_RATING_ID,
          p_CHECK_ID  => P_CHK_RATING_rec.CHECK_ID,
          p_CHECK_RATING_GRADE  => P_CHK_RATING_rec.CHECK_RATING_GRADE,
          --p_RATING_COLOR_ID  => P_CHK_RATING_rec.RATING_COLOR_ID,
          p_RATING_CODE  => P_CHK_RATING_rec.RATING_CODE,
          p_COLOR_CODE  => P_CHK_RATING_rec.COLOR_CODE,
          p_RANGE_LOW_VALUE  => P_CHK_RATING_rec.RANGE_LOW_VALUE,
          p_RANGE_HIGH_VALUE  => P_CHK_RATING_rec.RANGE_HIGH_VALUE,
          p_LAST_UPDATE_DATE  => SYSDATE,
          p_LAST_UPDATED_BY  => P_CHK_RATING_rec.LAST_UPDATED_BY,
          p_CREATION_DATE  => SYSDATE,
          p_CREATED_BY  => P_CHK_RATING_rec.CREATED_BY,
          p_LAST_UPDATE_LOGIN  => P_CHK_RATING_rec.LAST_UPDATE_LOGIN ,
          p_SEEDED_FLAG  =>  P_CHK_RATING_rec.SEEDED_FLAG);

Line: 245


PROCEDURE Update_check_ratings(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
    P_Commit                     IN   VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
    p_validation_level           IN   NUMBER   := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
    p_CHECK_RATING_ID            IN   NUMBER,
    p_CHECK_ID                   IN   NUMBER,
    p_CHECK_RATING_GRADE         IN   VARCHAR2,
    p_RATING_COLOR_ID            IN   NUMBER DEFAULT NULL,
    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: 283


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


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


END Update_check_ratings;

Line: 303


PROCEDURE Update_check_ratings(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2     := CSC_CORE_UTILS_PVT.G_FALSE,
    P_Commit                     IN   VARCHAR2     := CSC_CORE_UTILS_PVT.G_FALSE,
    p_validation_level           IN  NUMBER       := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
    P_CHK_RATING_Rec    	   IN    CHK_RATING_Rec_Type  := G_MISS_CHK_RATING_Rec,
    X_Return_Status              OUT NOCOPY VARCHAR2,
    X_Msg_Count                  OUT NOCOPY NUMBER,
    X_Msg_Data                   OUT NOCOPY VARCHAR2
    )

 IS

Cursor C_Get_check_ratings(c_CHECK_RATING_ID Number) IS
    Select rowid,
           CHECK_RATING_ID,
           CHECK_ID,
           CHECK_RATING_GRADE,
           RATING_CODE,
           COLOR_CODE,
           RANGE_LOW_VALUE,
           RANGE_HIGH_VALUE,
           LAST_UPDATE_DATE,
           LAST_UPDATED_BY,
           CREATION_DATE,
           CREATED_BY,
           LAST_UPDATE_LOGIN,
           SEEDED_FLAG
    From  CSC_PROF_CHECK_RATINGS
    Where check_id = c_CHECK_RATING_ID
    For Update NOWAIT;

Line: 334


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

Line: 342


      SAVEPOINT UPDATE_CHECK_RATINGS_PVT;

Line: 378


               l_old_CHK_RATING_rec.LAST_UPDATE_DATE,
               l_old_CHK_RATING_rec.LAST_UPDATED_BY,
               l_old_CHK_RATING_rec.CREATION_DATE,
               l_old_CHK_RATING_rec.CREATED_BY,
               l_old_CHK_RATING_rec.LAST_UPDATE_LOGIN,
               l_old_CHK_RATING_rec.SEEDED_FLAG;

Line: 399


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

Line: 411


      CSC_PROF_CHECK_RATINGS_PKG.Update_Row(
          p_CHECK_RATING_ID  => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.CHECK_RATING_ID,l_old_CHK_RATING_rec.CHECK_RATING_ID),
          p_CHECK_ID  => csc_core_utils_pvt.get_g_miss_char(p_CHK_RATING_REC.CHECK_ID,l_old_CHK_RATING_rec.CHECK_ID),
          p_CHECK_RATING_GRADE  => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.CHECK_RATING_GRADE,l_old_CHK_RATING_rec.CHECK_RATING_GRADE),
          p_RATING_CODE  => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.RATING_CODE,l_old_CHK_RATING_rec.RATING_CODE),
          p_COLOR_CODE  => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.COLOR_CODE,l_old_CHK_RATING_rec.COLOR_CODE),
          p_RANGE_LOW_VALUE  => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.RANGE_LOW_VALUE,l_old_CHK_RATING_rec.RANGE_LOW_VALUE),
          p_RANGE_HIGH_VALUE  => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.RANGE_HIGH_VALUE,l_old_CHK_RATING_rec.RANGE_HIGH_VALUE),
          p_LAST_UPDATE_DATE  => SYSDATE,
          p_LAST_UPDATED_BY  => csc_core_utils_pvt.get_g_miss_num(P_CHK_RATING_rec.LAST_UPDATED_BY,l_old_CHK_RATING_rec.LAST_UPDATED_BY),
          p_LAST_UPDATE_LOGIN  => csc_core_utils_pvt.get_g_miss_num(P_CHK_RATING_rec.LAST_UPDATE_LOGIN,l_old_CHK_RATING_rec.LAST_UPDATE_LOGIN),
          p_SEEDED_FLAG => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.SEEDED_FLAG,l_old_CHK_RATING_rec.SEEDED_FLAG) );

Line: 444


    		ROLLBACK TO Update_check_ratings_PVT;

Line: 452


    		ROLLBACK TO Update_check_ratings_PVT;

Line: 460


    		ROLLBACK TO Update_check_ratings_PVT;

Line: 468


End Update_check_ratings;

Line: 471


PROCEDURE Delete_check_ratings(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2     := CSC_CORE_UTILS_PVT.G_FALSE,
    P_Commit                     IN   VARCHAR2     := CSC_CORE_UTILS_PVT.G_FALSE,
    p_validation_level           IN   NUMBER       := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
    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: 487


      SAVEPOINT DELETE_CHECK_RATINGS_PVT;

Line: 513


      CSC_PROF_CHECK_RATINGS_PKG.Delete_Row(
          p_CHECK_RATING_ID  => p_CHECK_RATING_ID);

Line: 535


    		ROLLBACK TO Delete_check_ratings_PVT;

Line: 543


    		ROLLBACK TO Delete_check_ratings_PVT;

Line: 551


    		ROLLBACK TO Delete_check_ratings_PVT;

Line: 559


End Delete_check_ratings;

Line: 572


  Select check_id
  From csc_prof_checks_b
  Where check_id = p_Check_Id;

Line: 614


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

Line: 681


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

Line: 753


      ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
      THEN

        IF (p_RATING_CODE is NOT NULL) AND (p_RATING_CODE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR)
        THEN
           IF CSC_CORE_UTILS_PVT.csc_lookup_code_not_exists(
               p_effective_date => trunc(sysdate),
               p_lookup_type    => 'CSC_PROF_RATINGS',
               p_lookup_Code    => p_rating_code ) <> FND_API.G_RET_STS_SUCCESS
           THEN

               x_return_status := FND_API.G_RET_STS_ERROR;