APPS.CSC_PROF_GROUP_CHECKS_PKG SQL Statements

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

Line: 20

PROCEDURE Insert_Row(
          p_GROUP_ID    NUMBER,
          p_CHECK_ID    NUMBER,
          p_CHECK_SEQUENCE  NUMBER,
          p_END_DATE_ACTIVE    DATE,
          p_START_DATE_ACTIVE    DATE,
          p_CATEGORY_CODE    VARCHAR2,
          p_CATEGORY_SEQUENCE    NUMBER,
          p_THRESHOLD_FLAG    VARCHAR2,
	  p_CRITICAL_FLAG     VARCHAR2,
          p_SEEDED_FLAG       VARCHAR2,
          p_CREATED_BY    NUMBER,
          p_CREATION_DATE    DATE,
          p_LAST_UPDATED_BY    NUMBER,
          p_LAST_UPDATE_DATE    DATE,
          p_LAST_UPDATE_LOGIN    NUMBER)

 IS
   CURSOR C2 IS SELECT MAX(nvl(check_sequence,0)) + 1
		    FROM CSC_PROF_GROUP_CHECKS
		    WHERE check_id = p_CHECK_ID;

Line: 58

   INSERT INTO CSC_PROF_GROUP_CHECKS(
           GROUP_ID,
           CHECK_ID,
           CHECK_SEQUENCE,
           END_DATE_ACTIVE,
           START_DATE_ACTIVE,
           CATEGORY_CODE,
           CATEGORY_SEQUENCE,
           THRESHOLD_FLAG,
	   CRITICAL_FLAG,
           CREATED_BY,
           CREATION_DATE,
           LAST_UPDATED_BY,
           LAST_UPDATE_DATE,
           LAST_UPDATE_LOGIN,
           SEEDED_FLAG
          ) VALUES (
           p_GROUP_ID,
           decode( p_CHECK_ID, G_MISS_NUM, NULL, p_CHECK_ID),
           decode(p_CHECK_SEQUENCE,G_MISS_NUM,NULL,P_CHECK_SEQUENCE),
           decode( p_END_DATE_ACTIVE, G_MISS_DATE, NULL, p_END_DATE_ACTIVE),
           decode( p_START_DATE_ACTIVE, G_MISS_DATE, NULL, p_START_DATE_ACTIVE),
           decode( p_CATEGORY_CODE, G_MISS_CHAR, NULL, p_CATEGORY_CODE),
           decode( p_CATEGORY_SEQUENCE,G_MISS_NUM, NULL, p_CATEGORY_SEQUENCE),
           decode( p_THRESHOLD_FLAG, G_MISS_CHAR, NULL, p_THRESHOLD_FLAG),
	   decode( p_CRITICAL_FLAG, G_MISS_CHAR, NULL, p_CRITICAL_FLAG),
           decode( p_CREATED_BY, G_MISS_NUM, NULL, p_CREATED_BY),
           decode( p_CREATION_DATE,G_MISS_DATE, NULL, p_CREATION_DATE),
           decode( p_LAST_UPDATED_BY, G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
           decode( p_LAST_UPDATE_DATE,G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
           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: 90

End Insert_Row;

Line: 92

PROCEDURE Update_Row(
          p_GROUP_ID    NUMBER,
          p_CHECK_ID    NUMBER,
          p_CHECK_SEQUENCE    NUMBER,
          p_END_DATE_ACTIVE    DATE,
          p_START_DATE_ACTIVE    DATE,
          p_CATEGORY_CODE    VARCHAR2,
          p_CATEGORY_SEQUENCE    NUMBER,
          p_THRESHOLD_FLAG    VARCHAR2,
	  p_CRITICAL_FLAG     VARCHAR2,
          p_SEEDED_FLAG       VARCHAR2,
          p_LAST_UPDATED_BY    NUMBER,
          p_LAST_UPDATE_DATE    DATE,
          p_LAST_UPDATE_LOGIN    NUMBER)

 IS
 BEGIN
    Update CSC_PROF_GROUP_CHECKS
    SET
              CHECK_SEQUENCE = p_CHECK_SEQUENCE,
              END_DATE_ACTIVE = p_END_DATE_ACTIVE,
              START_DATE_ACTIVE = p_START_DATE_ACTIVE,
              CATEGORY_CODE = p_CATEGORY_CODE,
              CATEGORY_SEQUENCE = p_CATEGORY_SEQUENCE,
              THRESHOLD_FLAG = p_THRESHOLD_FLAG,
	      CRITICAL_FLAG = p_CRITICAL_FLAG,
              SEEDED_FLAG = p_SEEDED_FLAG,
              LAST_UPDATED_BY = p_LAST_UPDATED_BY,
              LAST_UPDATE_DATE = p_LAST_UPDATE_DATE,
              LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN
    where GROUP_ID = p_GROUP_ID
    and check_id = p_check_id;

Line: 128

END Update_Row;

Line: 144

          p_LAST_UPDATED_BY    NUMBER,
          p_LAST_UPDATE_DATE    DATE,
          p_LAST_UPDATE_LOGIN    NUMBER)

 IS
   CURSOR C IS
        SELECT *
         FROM CSC_PROF_GROUP_CHECKS
        WHERE GROUP_ID =  p_GROUP_ID
	   AND CHECK_ID = P_CHECK_ID
        FOR UPDATE of GROUP_ID NOWAIT;

Line: 161

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

Line: 200

       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_DATE = p_LAST_UPDATE_DATE)
            OR (    ( Recinfo.LAST_UPDATE_DATE IS NULL )
                AND (  p_LAST_UPDATE_DATE 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: 218

PROCEDURE Delete_Row(
    p_GROUP_ID  NUMBER,
    p_CHECK_ID  NUMBER,
    p_CHECK_SEQUENCE  NUMBER)
 IS
 BEGIN
   DELETE FROM CSC_PROF_GROUP_CHECKS
    WHERE GROUP_ID = p_GROUP_ID
     AND CHECK_ID = p_CHECK_ID
     AND CHECK_SEQUENCE = p_CHECK_SEQUENCE;

Line: 232

 END Delete_Row;