APPS.CSC_PROF_CHECK_RATINGS_PKG SQL Statements

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

Line: 24

PROCEDURE Insert_Row(
          px_CHECK_RATING_ID   IN OUT NOCOPY NUMBER,
          p_CHECK_ID             NUMBER,
          p_CHECK_RATING_GRADE   VARCHAR2,
          p_RATING_CODE          VARCHAR2,
          p_COLOR_CODE           VARCHAR2,
          p_RANGE_LOW_VALUE      VARCHAR2,
          p_RANGE_HIGH_VALUE     VARCHAR2,
          p_LAST_UPDATE_DATE     DATE,
          p_LAST_UPDATED_BY      NUMBER,
          p_CREATION_DATE        DATE,
          p_CREATED_BY           NUMBER,
          p_LAST_UPDATE_LOGIN    NUMBER,
          p_SEEDED_FLAG          VARCHAR2)

 IS
   CURSOR C2 IS SELECT CSC_PROF_CHECK_RATINGS_S.nextval FROM sys.dual;

Line: 61

   INSERT INTO CSC_PROF_CHECK_RATINGS(
           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
          ) VALUES (
           px_CHECK_RATING_ID,
           decode( p_CHECK_ID, G_MISS_NUM, NULL, p_CHECK_ID),
           decode( p_CHECK_RATING_GRADE, G_MISS_CHAR, NULL, p_CHECK_RATING_GRADE),
           decode( p_RATING_CODE, G_MISS_CHAR, NULL, p_RATING_CODE),
           decode( p_COLOR_CODE, G_MISS_CHAR, NULL, p_COLOR_CODE),
           decode( p_RANGE_LOW_VALUE, G_MISS_CHAR, NULL, p_RANGE_LOW_VALUE),
           decode( p_RANGE_HIGH_VALUE,G_MISS_CHAR, NULL, p_RANGE_HIGH_VALUE),
           decode( p_LAST_UPDATE_DATE, G_MISS_DATE, to_date(NULL), p_LAST_UPDATE_DATE),
           decode( p_LAST_UPDATED_BY, G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
           decode( p_CREATION_DATE, G_MISS_DATE, to_date(NULL), p_CREATION_DATE),
           decode( p_CREATED_BY, G_MISS_NUM, NULL, p_CREATED_BY),
           decode( p_LAST_UPDATE_LOGIN, G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
           decode( p_SEEDED_FLAG, G_MISS_CHAR, NULL, ps_SEEDED_FLAG));

Line: 89

End Insert_Row;

Line: 91

PROCEDURE Update_Row(
          p_CHECK_RATING_ID    NUMBER,
          p_CHECK_ID    NUMBER,
          p_CHECK_RATING_GRADE    VARCHAR2,
          p_RATING_CODE    VARCHAR2,
          p_COLOR_CODE    VARCHAR2,
          p_RANGE_LOW_VALUE    VARCHAR2,
          p_RANGE_HIGH_VALUE    VARCHAR2,
          p_LAST_UPDATE_DATE    DATE,
          p_LAST_UPDATED_BY    NUMBER,
          p_LAST_UPDATE_LOGIN    NUMBER,
          p_SEEDED_FLAG      VARCHAR2)

 IS
 BEGIN
    Update CSC_PROF_CHECK_RATINGS
    SET
              CHECK_ID = p_CHECK_ID,
              CHECK_RATING_GRADE = p_CHECK_RATING_GRADE,
              RATING_CODE = p_RATING_CODE,
              COLOR_CODE = p_COLOR_CODE,
              RANGE_LOW_VALUE = p_RANGE_LOW_VALUE,
              RANGE_HIGH_VALUE = p_RANGE_HIGH_VALUE,
              LAST_UPDATE_DATE = p_LAST_UPDATE_DATE,
              LAST_UPDATED_BY = p_LAST_UPDATED_BY,
              LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN,
              SEEDED_FLAG  = p_SEEDED_FLAG
    where CHECK_RATING_ID = p_CHECK_RATING_ID;

Line: 123

END Update_Row;

Line: 135

          p_LAST_UPDATE_DATE    DATE,
          p_LAST_UPDATED_BY    NUMBER,
          p_CREATION_DATE    DATE,
          p_CREATED_BY    NUMBER,
          p_LAST_UPDATE_LOGIN    NUMBER,
          p_SEEDED_FLAG    VARCHAR2)

 IS
   CURSOR C IS
        SELECT *
         FROM CSC_PROF_CHECK_RATINGS
        WHERE CHECK_RATING_ID =  p_CHECK_RATING_ID
        FOR UPDATE of CHECK_RATING_ID NOWAIT;

Line: 154

        FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');

Line: 164

       AND (    ( to_char(Recinfo.LAST_UPDATE_DATE,'dd-mon-rrrr') = to_char(p_LAST_UPDATE_DATE,'dd-mon-rrrr'))
            OR (    ( Recinfo.LAST_UPDATE_DATE IS NULL )
                AND (  p_LAST_UPDATE_DATE IS NULL )))
       AND (    ( Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY)
            OR (    ( Recinfo.LAST_UPDATED_BY IS NULL )
                AND (  p_LAST_UPDATED_BY IS NULL )))
       AND (    ( Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN)
            OR (    ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
                AND (  p_LAST_UPDATE_LOGIN IS NULL )))

       ) then
       return;

Line: 185

PROCEDURE Delete_Row(
    p_CHECK_RATING_ID  NUMBER)
 IS
 BEGIN
   DELETE FROM CSC_PROF_CHECK_RATINGS
    WHERE CHECK_RATING_ID = p_CHECK_RATING_ID;

Line: 194

 END Delete_Row;

Line: 204

          p_LAST_UPDATE_DATE     DATE,
          p_LAST_UPDATED_BY      NUMBER,
          p_LAST_UPDATE_LOGIN    NUMBER,
          p_SEEDED_FLAG          VARCHAR2,
		P_Owner			   VARCHAR2)
  IS
	     l_user_id	number := 0;

Line: 215

		  check_rating_id returned from insert_row is not used.

		**/
   BEGIN

         l_check_rating_id := p_check_rating_id;

Line: 222

 	 Csc_Prof_Check_Ratings_Pkg.Update_Row(
           	p_CHECK_RATING_ID   	=> p_check_rating_id,
           	p_CHECK_ID    	        => p_check_id,
          	p_CHECK_RATING_GRADE    => p_check_rating_grade,
          	p_RATING_CODE           => p_rating_code,
          	p_COLOR_CODE            => p_color_code,
          	p_RANGE_LOW_VALUE    	=> p_range_low_value,
          	p_RANGE_HIGH_VALUE      => p_range_high_value,
          	p_LAST_UPDATE_DATE   	=> p_last_update_date,
          	p_LAST_UPDATED_BY    	=> p_last_updated_by,
          	p_LAST_UPDATE_LOGIN  	=> 0,
                p_SEEDED_FLAG           => p_seeded_flag);

Line: 238

         Csc_Prof_Check_Ratings_Pkg.Insert_Row(
          		px_CHECK_RATING_ID     => l_check_rating_id,
          		p_CHECK_ID    	       => p_check_id,
          		p_CHECK_RATING_GRADE   => p_check_rating_grade,
          		p_RATING_CODE          => p_rating_code,
          		p_COLOR_CODE           => p_color_code,
          		p_RANGE_LOW_VALUE      => p_range_low_value,
          		p_RANGE_HIGH_VALUE     => p_range_high_value,
                        p_LAST_UPDATE_DATE     => p_last_update_date,
          		p_LAST_UPDATED_BY      => p_last_updated_by,
          		p_CREATION_DATE        => p_last_update_date,
          		p_CREATED_BY           => p_last_updated_by,
          		p_LAST_UPDATE_LOGIN    => 0,
                        p_SEEDED_FLAG          => p_seeded_flag);