APPS.CSC_COLOR_CODES_PKG SQL Statements

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

Line: 20

PROCEDURE Insert_Row(
          px_COLOR_CODE   IN OUT NOCOPY VARCHAR2,
          p_RATING_CODE     VARCHAR2,
          p_LAST_UPDATE_DATE    DATE,
          p_LAST_UPDATED_BY    NUMBER,
          p_CREATION_DATE    DATE,
          p_CREATED_BY    NUMBER,
          p_LAST_UPDATE_LOGIN    NUMBER)

 IS
BEGIN
   INSERT INTO CSC_COLOR_CODES(
           COLOR_CODE,
           RATING_CODE,
           LAST_UPDATE_DATE,
           LAST_UPDATED_BY,
           CREATION_DATE,
           CREATED_BY,
           LAST_UPDATE_LOGIN
          ) VALUES (
           px_COLOR_CODE,
		 p_rating_code,
           decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
           decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
           decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
           decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
           decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN));

Line: 47

End Insert_Row;

Line: 49

PROCEDURE Update_Row(
          p_COLOR_CODE    VARCHAR2,
          p_RATING_CODE    VARCHAR2,
          p_LAST_UPDATE_DATE    DATE,
          p_LAST_UPDATED_BY    NUMBER,
          p_LAST_UPDATE_LOGIN    NUMBER)

 IS
 BEGIN
    Update CSC_COLOR_CODES
    SET
              COLOR_CODE = p_COLOR_CODE,
              LAST_UPDATE_DATE =p_LAST_UPDATE_DATE,
              LAST_UPDATED_BY = p_LAST_UPDATED_BY,
              LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN
    where RATING_CODE = p_RATING_CODE;

Line: 69

END Update_Row;

Line: 71

PROCEDURE Delete_Row(
    p_COLOR_CODE  VARCHAR2)
 IS
 BEGIN
   DELETE FROM CSC_COLOR_CODES
    WHERE COLOR_CODE = p_COLOR_CODE;

Line: 80

 END Delete_Row;

Line: 85

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

 IS
   CURSOR C IS
        SELECT *
         FROM CSC_COLOR_CODES
        WHERE RATING_CODE =  p_RATING_CODE
        FOR UPDATE of RATING_CODE NOWAIT;

Line: 103

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

Line: 112

       AND (    ( Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE)
            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.CREATION_DATE = p_CREATION_DATE)
            OR (    ( Recinfo.CREATION_DATE IS NULL )
                AND (  p_CREATION_DATE IS NULL )))
       AND (    ( Recinfo.CREATED_BY = p_CREATED_BY)
            OR (    ( Recinfo.CREATED_BY IS NULL )
                AND (  p_CREATED_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: 138

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

Line: 149

 	Csc_Color_Codes_Pkg.Update_Row(
           	p_COLOR_CODE          => p_color_code,
           	p_RATING_CODE         => p_rating_code,
           	p_LAST_UPDATE_DATE    => p_last_update_date,
           	p_LAST_UPDATED_BY     => p_last_updated_by,
           	p_LAST_UPDATE_LOGIN   => 0);

Line: 159

         Csc_Color_Codes_Pkg.Insert_Row(
           	px_COLOR_CODE         => l_color_code,
            	p_RATING_CODE         => p_rating_code,
           	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);