APPS.CSC_PROF_GROUP_CATEGORIES_PKG SQL Statements

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

Line: 17

PROCEDURE Insert_Row(
          px_GROUP_CATEGORY_ID   IN OUT NOCOPY NUMBER,
          p_GROUP_ID    NUMBER,
          p_CATEGORY_CODE    VARCHAR2,
          p_CATEGORY_SEQUENCE    NUMBER,
          p_CREATED_BY    NUMBER,
          p_CREATION_DATE    DATE,
          p_LAST_UPDATED_BY    NUMBER,
          p_LAST_UPDATE_DATE    DATE,
          p_LAST_UPDATE_LOGIN    NUMBER,
          p_SEEDED_FLAG     VARCHAR2)

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

Line: 51

   INSERT INTO CSC_PROF_GROUP_CATEGORIES(
           GROUP_CATEGORY_ID,
           GROUP_ID,
           CATEGORY_CODE,
           CATEGORY_SEQUENCE,
           CREATED_BY,
           CREATION_DATE,
           LAST_UPDATED_BY,
           LAST_UPDATE_DATE,
           LAST_UPDATE_LOGIN,
           SEEDED_FLAG
          ) VALUES (
           px_GROUP_CATEGORY_ID,
           decode( p_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_GROUP_ID),
           decode( p_CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, p_CATEGORY_CODE),
           decode( p_CATEGORY_SEQUENCE, FND_API.G_MISS_NUM, NULL, p_CATEGORY_SEQUENCE),
           decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
           decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
           decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
           decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
           decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
           decode( p_SEEDED_FLAG,CSC_CORE_UTILS_PVT.G_MISS_CHAR, NULL, ps_SEEDED_FLAG));

Line: 73

End Insert_Row;

Line: 75

PROCEDURE Update_Row(
          p_GROUP_CATEGORY_ID    NUMBER,
          p_GROUP_ID    NUMBER,
          p_CATEGORY_CODE    VARCHAR2,
          p_CATEGORY_SEQUENCE    NUMBER,
          p_LAST_UPDATED_BY    NUMBER,
          p_LAST_UPDATE_DATE    DATE,
          p_LAST_UPDATE_LOGIN    NUMBER,
          p_SEEDED_FLAG       VARCHAR2)

 IS
 BEGIN
    Update CSC_PROF_GROUP_CATEGORIES
    SET
              GROUP_ID = p_GROUP_ID,
              CATEGORY_CODE = p_CATEGORY_CODE,
              CATEGORY_SEQUENCE =p_CATEGORY_SEQUENCE,
              LAST_UPDATED_BY = p_LAST_UPDATED_BY,
              LAST_UPDATE_DATE = p_LAST_UPDATE_DATE,
              LAST_UPDATE_LOGIN =p_LAST_UPDATE_LOGIN,
              SEEDED_FLAG= p_SEEDED_FLAG
    where GROUP_CATEGORY_ID = p_GROUP_CATEGORY_ID;

Line: 101

END Update_Row;

Line: 103

PROCEDURE Delete_Row(
    p_GROUP_CATEGORY_ID  NUMBER)
 IS
 BEGIN
   DELETE FROM CSC_PROF_GROUP_CATEGORIES
    WHERE GROUP_CATEGORY_ID = p_GROUP_CATEGORY_ID;

Line: 112

 END Delete_Row;

Line: 121

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

 IS
   CURSOR C IS
        SELECT *
         FROM CSC_PROF_GROUP_CATEGORIES
        WHERE GROUP_CATEGORY_ID =  p_GROUP_CATEGORY_ID
        FOR UPDATE of GROUP_CATEGORY_ID NOWAIT;

Line: 138

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

Line: 159

       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 )))
        AND (    ( Recinfo.SEEDED_FLAG = p_SEEDED_FLAG)
            OR (    ( Recinfo.SEEDED_FLAG IS NULL )
                AND (  p_SEEDED_FLAG IS NULL )))

       ) then
       return;

Line: 186

 p_last_updated_by      IN NUMBER,
 p_last_update_date     IN DATE
 ) is

 l_user_id               number := 0;

Line: 195

 Csc_Prof_Group_Categories_Pkg.Update_Row(
    p_GROUP_CATEGORY_ID     => p_GROUP_CATEGORY_ID,
    p_GROUP_ID              => p_GROUP_ID,
    p_CATEGORY_CODE         => p_CATEGORY_CODE,
    p_CATEGORY_SEQUENCE     => p_CATEGORY_SEQUENCE,
    p_LAST_UPDATED_BY       => p_last_updated_by,
    p_LAST_UPDATE_DATE      => p_last_update_date,
    p_LAST_UPDATE_LOGIN     => 0,
    p_SEEDED_FLAG           => p_SEEDED_FLAG);

Line: 207

    Csc_Prof_Group_Categories_Pkg.Insert_Row(
      px_GROUP_CATEGORY_ID    => l_group_category_id,
      p_GROUP_ID              => p_GROUP_ID,
      p_CATEGORY_CODE         => p_CATEGORY_CODE,
      p_CATEGORY_SEQUENCE     => p_CATEGORY_SEQUENCE,
      p_CREATED_BY            => p_last_updated_by,
      p_CREATION_DATE         => p_last_update_date,
      p_LAST_UPDATED_BY       => p_last_updated_by,
      p_LAST_UPDATE_DATE      => p_last_update_date,
      p_LAST_UPDATE_LOGIN     => 0,
      p_SEEDED_FLAG           => p_SEEDED_FLAG );