APPS.CSP_PART_PRIORITIES_PKG SQL Statements

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

Line: 13

PROCEDURE Insert_Row(
          px_PART_PRIORITY_ID   IN OUT NOCOPY NUMBER,
          p_PRIORITY       VARCHAR2,
          p_LOWER_RANGE    NUMBER,
          p_UPPER_RANGE    NUMBER,
          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 CSP_PART_PRIORITIES_S1.nextval FROM sys.dual;

Line: 33

   INSERT INTO CSP_PART_PRIORITIES(
          PART_PRIORITY_ID,
          PRIORITY,
          LOWER_RANGE,
          UPPER_RANGE,
          CREATED_BY,
          CREATION_DATE,
          LAST_UPDATED_BY,
          LAST_UPDATE_DATE,
          LAST_UPDATE_LOGIN)
          VALUES (
          px_PART_PRIORITY_ID,
          decode( p_PRIORITY, FND_API.G_MISS_CHAR, NULL, p_PRIORITY),
          decode( p_LOWER_RANGE, FND_API.G_MISS_NUM, NULL, p_LOWER_RANGE),
          decode( p_UPPER_RANGE, FND_API.G_MISS_NUM, NULL, p_UPPER_RANGE),
          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: 53

End Insert_Row;

Line: 55

PROCEDURE Update_Row(
          p_PART_PRIORITY_ID   NUMBER,
          p_PRIORITY       VARCHAR2,
          p_LOWER_RANGE    NUMBER,
          p_UPPER_RANGE    NUMBER,
          p_CREATED_BY     NUMBER,
          p_CREATION_DATE  DATE,
          p_LAST_UPDATED_BY    NUMBER,
          p_LAST_UPDATE_DATE    DATE,
          p_LAST_UPDATE_LOGIN    NUMBER)

 IS
 BEGIN
    Update CSP_PART_PRIORITIES
    SET  PRIORITY = decode( p_PRIORITY, FND_API.G_MISS_CHAR, PRIORITY, p_PRIORITY),
         LOWER_RANGE = decode( p_LOWER_RANGE, FND_API.G_MISS_NUM, LOWER_RANGE, p_LOWER_RANGE),
         UPPER_RANGE = decode( p_UPPER_RANGE, FND_API.G_MISS_NUM, UPPER_RANGE, p_UPPER_RANGE),
         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 PART_PRIORITY_ID = p_PART_PRIORITY_ID;

Line: 82

END Update_Row;

Line: 84

PROCEDURE Delete_Row(
    p_PART_PRIORITY_ID  NUMBER)
 IS
 BEGIN
   DELETE FROM CSP_PART_PRIORITIES
    WHERE PART_PRIORITY_ID = p_PART_PRIORITY_ID;

Line: 93

 END Delete_Row;

Line: 102

          p_LAST_UPDATED_BY    NUMBER,
          p_LAST_UPDATE_DATE    DATE,
          p_LAST_UPDATE_LOGIN    NUMBER)

 IS
   CURSOR C IS
        SELECT *
         FROM CSP_PART_PRIORITIES
        WHERE PART_PRIORITY_ID =  p_PART_PRIORITY_ID
        FOR UPDATE of PART_PRIORITY_ID NOWAIT;

Line: 118

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

Line: 139

       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;