APPS.CSD_RO_BULLETINS_PKG SQL Statements

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

Line: 14

/* procedure name: Insert_Row                       */
/* description   : Inserts a row                    */
/*                 CSD_RO_BULLETINS                 */
/* params:    p_RO_BULLETIN_ID  NUMBER  not req     */
/*            p_REPAIR_LINE_ID  NUMBER  not req     */
/*            p_BULLETIN_ID     NUMBER  not req     */
/*            p_LAST_VIEWED_DATE  DATE  not req     */
/*            p_SOURCE_TYPE     VARCHAR2 not req    */
/*            p_SOURCE_ID       VARCHAR2 not req    */
/*            p_OBJECT_VERSION_NUMBER NUMBER req    */
/*            p_CREATED_BY      NUMBER  req         */
/*            p_CREATION_DATE   DATE    req         */
/*            p_LAST_UPDATED_BY NUMBER  req         */
/*            p_LAST_UPDATE_DATE DATE   req         */
/*            p_LAST_UPDATE_LOGIN       not req     */
/*                                                  */
/*--------------------------------------------------*/
PROCEDURE Insert_Row(
          px_RO_BULLETIN_ID   IN OUT NOCOPY NUMBER
         ,p_REPAIR_LINE_ID    IN     NUMBER
         ,p_BULLETIN_ID       IN     NUMBER
         ,p_LAST_VIEWED_DATE  IN     DATE
         ,p_LAST_VIEWED_BY    IN     NUMBER
         ,p_SOURCE_TYPE       IN     VARCHAR2
         ,p_SOURCE_ID         IN     NUMBER
         ,p_OBJECT_VERSION_NUMBER IN NUMBER
         ,p_CREATED_BY            IN NUMBER
         ,p_CREATION_DATE         IN DATE
         ,p_LAST_UPDATED_BY       IN NUMBER
         ,p_LAST_UPDATE_DATE      IN DATE
         ,p_LAST_UPDATE_LOGIN     IN NUMBER)
 IS
   CURSOR C2 IS SELECT CSD_RO_BULLETINS_S1.nextval FROM sys.dual;

Line: 53

   INSERT INTO CSD_RO_BULLETINS(
           RO_BULLETIN_ID
          ,REPAIR_LINE_ID
          ,BULLETIN_ID
          ,LAST_VIEWED_DATE
          ,LAST_VIEWED_BY
          ,SOURCE_TYPE
          ,SOURCE_ID
          ,OBJECT_VERSION_NUMBER
          ,CREATED_BY
          ,CREATION_DATE
          ,LAST_UPDATED_BY
          ,LAST_UPDATE_DATE
          ,LAST_UPDATE_LOGIN
          ) VALUES (
           px_RO_BULLETIN_ID
          ,decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_LINE_ID)
          ,decode( p_BULLETIN_ID, FND_API.G_MISS_NUM, NULL, p_BULLETIN_ID)
          ,decode( p_LAST_VIEWED_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_VIEWED_DATE)
          ,decode( p_LAST_VIEWED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_VIEWED_BY)
          ,decode( p_SOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_TYPE)
          ,decode( p_SOURCE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_ID)
          ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
          ,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));

Line: 81

END Insert_Row;

Line: 84

/* procedure name: Update_Row                       */
/* description   : Updates a row                    */
/*                 CSD_RO_BULLETINS                 */
/* params:    p_RO_BULLETIN_ID  NUMBER  required    */
/*            p_REPAIR_LINE_ID  NUMBER  not req     */
/*            p_BULLETIN_ID     NUMBER  not req     */
/*            p_LAST_VIEWED_DATE  DATE  not req     */
/*            p_SOURCE_TYPE     VARCHAR2 not req    */
/*            p_SOURCE_ID       VARCHAR2 not req    */
/*            p_OBJECT_VERSION_NUMBER NUMBER req    */
/*            p_CREATED_BY      NUMBER  req         */
/*            p_CREATION_DATE   DATE    req         */
/*            p_LAST_UPDATED_BY NUMBER  req         */
/*            p_LAST_UPDATE_DATE DATE   req         */
/*            p_LAST_UPDATE_LOGIN       not req     */
/*                                                  */
/*--------------------------------------------------*/
PROCEDURE Update_Row(
          p_RO_BULLETIN_ID        IN NUMBER
         ,p_REPAIR_LINE_ID        IN NUMBER
         ,p_BULLETIN_ID           IN NUMBER
         ,p_LAST_VIEWED_DATE      IN DATE
         ,p_LAST_VIEWED_BY        IN NUMBER
         ,p_SOURCE_TYPE           IN VARCHAR2
         ,p_SOURCE_ID             IN NUMBER
         ,p_OBJECT_VERSION_NUMBER IN NUMBER
         ,p_CREATED_BY            IN NUMBER
         ,p_CREATION_DATE         IN DATE
         ,p_LAST_UPDATED_BY       IN NUMBER
         ,p_LAST_UPDATE_DATE      IN DATE
         ,p_LAST_UPDATE_LOGIN     IN NUMBER)
IS
BEGIN
    Update CSD_RO_BULLETINS
    SET
        REPAIR_LINE_ID = decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, REPAIR_LINE_ID, p_REPAIR_LINE_ID)
       ,BULLETIN_ID = decode( p_BULLETIN_ID, FND_API.G_MISS_NUM, BULLETIN_ID, p_BULLETIN_ID)
       ,LAST_VIEWED_DATE = decode( p_LAST_VIEWED_DATE, FND_API.G_MISS_DATE, LAST_VIEWED_DATE, p_LAST_VIEWED_DATE)
       ,LAST_VIEWED_BY = decode( p_LAST_VIEWED_BY, FND_API.G_MISS_NUM, LAST_VIEWED_BY, p_LAST_VIEWED_BY)
       ,SOURCE_TYPE = decode( p_SOURCE_TYPE, FND_API.G_MISS_CHAR, SOURCE_TYPE, p_SOURCE_TYPE)
       ,SOURCE_ID = decode( p_SOURCE_ID, FND_API.G_MISS_NUM, SOURCE_ID, p_SOURCE_ID)
       ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
       ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
       ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
       ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
       ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
       ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
    where RO_BULLETIN_ID = p_RO_BULLETIN_ID;

Line: 136

END Update_Row;

Line: 141

/* procedure name: Delete_Row                        */
/* description   : Deletes a row in CSD_RO_BULLETINS */
/* params:    P_RO_BULLETIN_ID  NUMBER  required     */
/*                                                   */
/*-------------------------------------------------- */
PROCEDURE Delete_Row(
    p_RO_BULLETIN_ID IN NUMBER)
IS
BEGIN
    DELETE FROM CSD_RO_BULLETINS
    WHERE RO_BULLETIN_ID = p_RO_BULLETIN_ID;

Line: 155

END Delete_Row;

Line: 171

       SELECT *
       FROM CSD_RO_BULLETINS
       WHERE RO_BULLETIN_ID =  p_RO_BULLETIN_ID
       FOR UPDATE of RO_BULLETIN_ID NOWAIT;

Line: 181

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

Line: 216

       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 )))*/
       ) /*END: if (...)*/ THEN
        return;