APPS.IBC_CITEM_KEYWORDS_PKG SQL Statements

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

Line: 19

PROCEDURE INSERT_ROW (
  x_ROWID OUT NOCOPY VARCHAR2,
  p_CONTENT_ITEM_ID IN NUMBER,
  p_KEYWORD IN VARCHAR2,
  p_OBJECT_VERSION_NUMBER IN NUMBER,
  p_CREATION_DATE IN DATE 	  		DEFAULT NULL,
  p_CREATED_BY IN NUMBER	  		DEFAULT NULL,
  p_LAST_UPDATE_DATE IN DATE  		DEFAULT NULL,
  p_LAST_UPDATED_BY IN NUMBER 		DEFAULT NULL
) IS
  CURSOR C IS SELECT ROWID FROM IBC_CITEM_KEYWORDS
    WHERE CONTENT_ITEM_ID = p_CONTENT_ITEM_ID
      AND KEYWORD = p_KEYWORD;

Line: 33

  G_API_NAME   CONSTANT VARCHAR2(30) := 'INSERT_ROW';

Line: 40

  INSERT INTO IBC_CITEM_KEYWORDS(
    CONTENT_ITEM_ID,
    KEYWORD,
    OBJECT_VERSION_NUMBER,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY
  ) VALUES (
     p_content_item_id
    ,p_keyword
    ,DECODE(p_object_version_number,NULL,1,NULL,1,p_object_version_number)
    ,DECODE(p_creation_date,NULL,SYSDATE,NULL,SYSDATE,p_creation_date)
    ,DECODE(p_created_by,NULL,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
    ,DECODE(p_last_update_date,NULL,SYSDATE,NULL,SYSDATE,p_last_update_date)
    ,DECODE(p_last_updated_by,NULL,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
  );

Line: 60

END INSERT_ROW;

Line: 68

  CURSOR c IS SELECT
      OBJECT_VERSION_NUMBER
    FROM IBC_CITEM_KEYWORDS
    WHERE CONTENT_ITEM_ID = p_CONTENT_ITEM_ID
    FOR UPDATE OF CONTENT_ITEM_ID NOWAIT;

Line: 83

    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 95

PROCEDURE UPDATE_ROW (
   p_CONTENT_ITEM_ID		IN  NUMBER,
   p_KEYWORD	IN  VARCHAR2,
   px_OBJECT_VERSION_NUMBER	IN OUT NOCOPY NUMBER -- DEFAULT  NULL
   ,p_last_update_date                IN DATE  --        DEFAULT NULL
    ,p_last_updated_by                 IN NUMBER  --      DEFAULT NULL
) IS

  G_API_NAME   CONSTANT VARCHAR2(30) := 'UPDATE_ROW';

Line: 106

  UPDATE IBC_CITEM_KEYWORDS SET
     object_version_number          = NVL(object_version_number,0) + 1
    ,last_update_date               = DECODE(p_last_update_date,NULL,SYSDATE,NULL,SYSDATE,p_last_update_date)
    ,last_updated_by                = DECODE(p_last_updated_by,NULL,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
 WHERE CONTENT_ITEM_ID = p_CONTENT_ITEM_ID
    AND KEYWORD = p_KEYWORD
    AND object_version_number = DECODE(px_object_version_number,
                                       NULL,
                                       object_version_number,
                                       NULL,
                                       object_version_number,
                                       px_object_version_number);

Line: 129

END UPDATE_ROW;

Line: 132

PROCEDURE DELETE_ROW (
  p_CONTENT_ITEM_ID IN NUMBER
  ,p_KEYWORD IN VARCHAR2
) IS

  G_API_NAME   CONSTANT VARCHAR2(30) := 'DELETE_ROW';

Line: 141

  DELETE FROM IBC_CITEM_KEYWORDS
   WHERE CONTENT_ITEM_ID = p_CONTENT_ITEM_ID
     AND KEYWORD = p_KEYWORD;

Line: 153

END DELETE_ROW;

Line: 171

    UPDATE_ROW (
                p_content_item_id              => p_content_item_id
               ,p_keyword                      => p_keyword
               ,p_last_updated_by              => l_user_id
               ,p_last_update_date             => SYSDATE
               ,px_object_version_number       => lx_object_version_number
               );

Line: 181

       INSERT_ROW (
          X_ROWID => l_row_id,
          p_CONTENT_ITEM_ID    => p_CONTENT_ITEM_ID,
          p_KEYWORD  => p_KEYWORD,
          p_OBJECT_VERSION_NUMBER => 1,
          p_CREATION_DATE     => SYSDATE,
          p_CREATED_BY      => l_user_id,
          p_LAST_UPDATE_DATE    => SYSDATE,
          p_LAST_UPDATED_BY    => l_user_id);