APPS.CSD_GENERIC_ERRMSGS_PKG SQL Statements

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

Line: 14

PROCEDURE Insert_Row(
          px_GENERIC_ERRMSGS_ID   IN OUT NOCOPY NUMBER
         ,p_MODULE_CODE    VARCHAR2
         ,p_SOURCE_ENTITY_ID1    NUMBER
         ,p_SOURCE_ENTITY_ID2    NUMBER
         ,p_SOURCE_ENTITY_TYPE_CODE    VARCHAR2
         ,p_MSG_TYPE_CODE    VARCHAR2
         ,p_MSG    VARCHAR2
         ,p_MSG_STATUS    VARCHAR2
         ,p_CREATED_BY    NUMBER
         ,p_CREATION_DATE    DATE
         ,p_LAST_UPDATED_BY    NUMBER
         ,p_LAST_UPDATE_DATE    DATE
         ,p_LAST_UPDATE_LOGIN    NUMBER
         ,p_OBJECT_VERSION_NUMBER    NUMBER)

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

Line: 38

   INSERT INTO CSD_GENERIC_ERRMSGS(
           GENERIC_ERRMSGS_ID
          ,MODULE_CODE
          ,SOURCE_ENTITY_ID1
          ,SOURCE_ENTITY_ID2
          ,SOURCE_ENTITY_TYPE_CODE
          ,MSG_TYPE_CODE
          ,MSG
          ,MSG_STATUS
          ,CREATED_BY
          ,CREATION_DATE
          ,LAST_UPDATED_BY
          ,LAST_UPDATE_DATE
          ,LAST_UPDATE_LOGIN
           ,OBJECT_VERSION_NUMBER
          ) VALUES (
           px_GENERIC_ERRMSGS_ID
          ,decode( p_MODULE_CODE, FND_API.G_MISS_CHAR, NULL, p_MODULE_CODE)
          ,decode( p_SOURCE_ENTITY_ID1, FND_API.G_MISS_NUM, NULL, p_SOURCE_ENTITY_ID1)
          ,decode( p_SOURCE_ENTITY_ID2, FND_API.G_MISS_NUM, NULL, p_SOURCE_ENTITY_ID2)
          ,decode( p_SOURCE_ENTITY_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_ENTITY_TYPE_CODE)
          ,decode( p_MSG_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_MSG_TYPE_CODE)
          ,decode( p_MSG, FND_API.G_MISS_CHAR, NULL, p_MSG)
          ,decode( p_MSG_STATUS, FND_API.G_MISS_CHAR, NULL, p_MSG_STATUS)
          ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
          ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_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, TO_DATE(NULL), p_LAST_UPDATE_DATE)
          ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
          ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER));

Line: 68

End Insert_Row;

Line: 70

PROCEDURE Update_Row(
          p_GENERIC_ERRMSGS_ID    NUMBER
         ,p_MODULE_CODE    VARCHAR2
         ,p_SOURCE_ENTITY_ID1    NUMBER
         ,p_SOURCE_ENTITY_ID2    NUMBER
         ,p_SOURCE_ENTITY_TYPE_CODE    VARCHAR2
         ,p_MSG_TYPE_CODE    VARCHAR2
         ,p_MSG    VARCHAR2
         ,p_MSG_STATUS    VARCHAR2
         ,p_CREATED_BY    NUMBER
         ,p_CREATION_DATE    DATE
         ,p_LAST_UPDATED_BY    NUMBER
         ,p_LAST_UPDATE_DATE    DATE
         ,p_LAST_UPDATE_LOGIN    NUMBER
         ,p_OBJECT_VERSION_NUMBER    NUMBER)

IS
BEGIN
    Update CSD_GENERIC_ERRMSGS
    SET
        MODULE_CODE = decode( p_MODULE_CODE, FND_API.G_MISS_CHAR,NULL,NULL, MODULE_CODE, p_MODULE_CODE)
       ,SOURCE_ENTITY_ID1 = decode( p_SOURCE_ENTITY_ID1, FND_API.G_MISS_NUM,NULL,NULL,  SOURCE_ENTITY_ID1, p_SOURCE_ENTITY_ID1)
       ,SOURCE_ENTITY_ID2 = decode( p_SOURCE_ENTITY_ID2, FND_API.G_MISS_NUM,NULL,NULL,  SOURCE_ENTITY_ID2, p_SOURCE_ENTITY_ID2)
       ,SOURCE_ENTITY_TYPE_CODE = decode( p_SOURCE_ENTITY_TYPE_CODE, FND_API.G_MISS_CHAR,NULL,NULL,  SOURCE_ENTITY_TYPE_CODE, p_SOURCE_ENTITY_TYPE_CODE)
       ,MSG_TYPE_CODE = decode( p_MSG_TYPE_CODE, FND_API.G_MISS_CHAR, NULL,NULL, MSG_TYPE_CODE, p_MSG_TYPE_CODE)
       ,MSG = decode( p_MSG, FND_API.G_MISS_CHAR,NULL,NULL,  MSG, p_MSG)
       ,MSG_STATUS = decode( p_MSG_STATUS, FND_API.G_MISS_CHAR, NULL,NULL, MSG_STATUS, p_MSG_STATUS)
       ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM,NULL,NULL,  CREATED_BY, p_CREATED_BY)
       ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE,NULL,NULL,  CREATION_DATE, p_CREATION_DATE)
       ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM,NULL,NULL,  LAST_UPDATED_BY, p_LAST_UPDATED_BY)
       ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,NULL,NULL,  LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
       ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,NULL,NULL,  LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
       ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,NULL,NULL,  OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
    where GENERIC_ERRMSGS_ID = p_GENERIC_ERRMSGS_ID;

Line: 108

END Update_Row;

Line: 110

PROCEDURE Delete_Row(
    p_GENERIC_ERRMSGS_ID  NUMBER)
IS
BEGIN
    DELETE FROM CSD_GENERIC_ERRMSGS
    WHERE GENERIC_ERRMSGS_ID = p_GENERIC_ERRMSGS_ID;

Line: 119

END Delete_Row;

Line: 132

         ,p_LAST_UPDATED_BY    NUMBER
         ,p_LAST_UPDATE_DATE    DATE
         ,p_LAST_UPDATE_LOGIN    NUMBER
         ,p_OBJECT_VERSION_NUMBER    NUMBER)

 IS
   CURSOR C IS
       SELECT *
       FROM CSD_GENERIC_ERRMSGS
       WHERE GENERIC_ERRMSGS_ID =  p_GENERIC_ERRMSGS_ID
       FOR UPDATE of GENERIC_ERRMSGS_ID NOWAIT;

Line: 149

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

Line: 182

       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.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER)
            OR (    ( Recinfo.OBJECT_VERSION_NUMBER IS NULL )
                AND (  p_OBJECT_VERSION_NUMBER IS NULL )))
        ) then
        return;