APPS.BSC_SYS_IMAGES_PKG SQL Statements

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

Line: 4

PROCEDURE UPDATE_ROW
(
    X_FILE_NAME               IN VARCHAR2,
    X_DESCRIPTION             IN VARCHAR2,
    X_WIDTH                   IN NUMBER,
    X_HEIGHT                  IN NUMBER,
    X_LAST_UPDATE_DATE        IN VARCHAR2,
    X_LAST_UPDATED_BY         IN NUMBER,
    X_LAST_UPDATE_LOGIN       IN NUMBER
) IS
   -- L_BLOB     BLOB;

Line: 17

  UPDATE_ROW(
    X_FILE_NAME               => X_FILE_NAME,
    X_DESCRIPTION             => X_DESCRIPTION,
    X_WIDTH                   => X_WIDTH,
    X_HEIGHT                  => X_HEIGHT,
    X_MIME_TYPE               => '',
    X_LAST_UPDATE_DATE        => X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY         => X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN       => X_LAST_UPDATE_LOGIN
  );

Line: 27

END UPDATE_ROW;

Line: 32

PROCEDURE UPDATE_ROW
(
    X_FILE_NAME               IN VARCHAR2,
    X_DESCRIPTION             IN VARCHAR2,
    X_WIDTH                   IN NUMBER,
    X_HEIGHT                  IN NUMBER,
    X_MIME_TYPE               IN VARCHAR2,
    X_LAST_UPDATE_DATE        IN VARCHAR2,
    X_LAST_UPDATED_BY         IN NUMBER,
    X_LAST_UPDATE_LOGIN       IN NUMBER
) IS
   -- L_BLOB     BLOB;

Line: 46

    UPDATE  BSC_SYS_IMAGES
    SET     DESCRIPTION            =   X_DESCRIPTION,
            WIDTH                  =   X_WIDTH,
            HEIGHT                 =   X_HEIGHT,
            MIME_TYPE              =   X_MIME_TYPE,
            LAST_UPDATE_DATE       =   NVL(TO_DATE(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), SYSDATE),
            LAST_UPDATED_BY        =   X_LAST_UPDATED_BY,
            LAST_UPDATE_LOGIN      =   X_LAST_UPDATE_LOGIN,
            FILE_BODY              =   EMPTY_BLOB()
    WHERE   FILE_NAME              =   X_FILE_NAME
    AND     LAST_UPDATE_DATE      <=   TO_DATE(X_LAST_UPDATE_DATE, 'YYYY/MM/DD');

Line: 64

END UPDATE_ROW;

Line: 68

PROCEDURE INSERT_ROW
(
    X_IMAGE_ID                  IN  NUMBER,
    X_FILE_NAME                 IN  VARCHAR2,
    X_DESCRIPTION               IN  VARCHAR2,
    X_WIDTH                     IN  NUMBER,
    X_HEIGHT                    IN  NUMBER,
    X_CREATED_BY                IN  NUMBER,
    X_LAST_UPDATED_BY           IN  NUMBER,
    X_LAST_UPDATE_LOGIN         IN  NUMBER
) IS
BEGIN
  INSERT_ROW(
    X_IMAGE_ID                  => X_IMAGE_ID,
    X_FILE_NAME                 => X_FILE_NAME,
    X_DESCRIPTION               => X_DESCRIPTION,
    X_WIDTH                     => X_WIDTH,
    X_HEIGHT                    => X_HEIGHT,
    X_MIME_TYPE                 => '',
    X_CREATED_BY                => X_CREATED_BY,
    X_LAST_UPDATED_BY           => X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN         => X_LAST_UPDATE_LOGIN
  );

Line: 91

END INSERT_ROW;

Line: 96

PROCEDURE INSERT_ROW
(
    X_IMAGE_ID                  IN  NUMBER,
    X_FILE_NAME                 IN  VARCHAR2,
    X_DESCRIPTION               IN  VARCHAR2,
    X_WIDTH                     IN  NUMBER,
    X_HEIGHT                    IN  NUMBER,
    X_MIME_TYPE                 IN  VARCHAR2,
    X_CREATED_BY                IN  NUMBER,
    X_LAST_UPDATED_BY           IN  NUMBER,
    X_LAST_UPDATE_LOGIN         IN  NUMBER
) IS
    CURSOR C IS SELECT ROWID FROM BSC_SYS_IMAGES WHERE IMAGE_ID = X_IMAGE_ID;

Line: 113

        INSERT INTO BSC_SYS_IMAGES
        (
            IMAGE_ID,
            FILE_NAME,
            DESCRIPTION,
            FILE_BODY,
            WIDTH,
            HEIGHT,
            MIME_TYPE,
            CREATION_DATE,
            CREATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_LOGIN
        )
        VALUES
        (
            X_IMAGE_ID,
            X_FILE_NAME,
            X_DESCRIPTION,
            EMPTY_BLOB(),
            X_WIDTH,
            X_HEIGHT,
            X_MIME_TYPE,
            SYSDATE,
            X_CREATED_BY,
            SYSDATE,
            X_LAST_UPDATED_BY,
            0
        );

Line: 157

END INSERT_ROW;