APPS.CS_KB_SETS_PKG SQL Statements

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

Line: 33

 PROCEDURE Insert_Row(
   X_ROWID              IN OUT NOCOPY VARCHAR2,
   X_SET_ID             IN NUMBER,
   X_SET_NUMBER         IN VARCHAR2,
   X_SET_TYPE_ID        IN NUMBER,
   X_SET_NAME           IN VARCHAR2,
   X_GROUP_FLAG         IN NUMBER,
   X_STATUS             IN VARCHAR2,
   X_ACCESS_LEVEL       IN NUMBER,
   X_NAME               IN VARCHAR2,
   X_DESCRIPTION        IN VARCHAR2,
   X_CREATION_DATE      IN DATE,
   X_CREATED_BY         IN NUMBER,
   X_LAST_UPDATE_DATE   IN DATE,
   X_LAST_UPDATED_BY    IN NUMBER,
   X_LAST_UPDATE_LOGIN  IN NUMBER,
   X_LOCKED_BY          IN NUMBER,
   X_LOCK_DATE          IN DATE,
   X_ATTRIBUTE_CATEGORY IN VARCHAR2,
   X_ATTRIBUTE1         IN VARCHAR2,
   X_ATTRIBUTE2         IN VARCHAR2,
   X_ATTRIBUTE3         IN VARCHAR2,
   X_ATTRIBUTE4         IN VARCHAR2,
   X_ATTRIBUTE5         IN VARCHAR2,
   X_ATTRIBUTE6         IN VARCHAR2,
   X_ATTRIBUTE7         IN VARCHAR2,
   X_ATTRIBUTE8         IN VARCHAR2,
   X_ATTRIBUTE9         IN VARCHAR2,
   X_ATTRIBUTE10        IN VARCHAR2,
   X_ATTRIBUTE11        IN VARCHAR2,
   X_ATTRIBUTE12        IN VARCHAR2,
   X_ATTRIBUTE13        IN VARCHAR2,
   X_ATTRIBUTE14        IN VARCHAR2,
   X_ATTRIBUTE15        IN VARCHAR2,
   X_EMPLOYEE_ID        IN NUMBER,
   X_PARTY_ID           IN NUMBER,
   X_START_ACTIVE_DATE  IN DATE,
   X_END_ACTIVE_DATE    IN DATE,
   X_PRIORITY_CODE      IN NUMBER,
   X_VISIBILITY_ID      IN NUMBER )
 IS

  CURSOR c IS
  SELECT rowid
  FROM CS_KB_SETS_B
  WHERE set_id = x_set_id;

Line: 81

  INSERT INTO CS_KB_SETS_B (
    set_id,
    set_number,
    set_type_id,
    set_name,
    group_flag,
    status,
    access_level,
    creation_date,
    created_by,
    last_update_date,
    last_updated_by,
    last_update_login,
    locked_by,
    lock_date,
    attribute_category,
    attribute1,
    attribute2,
    attribute3,
    attribute4,
    attribute5,
    attribute6,
    attribute7,
    attribute8,
    attribute9,
    attribute10,
    attribute11,
    attribute12,
    attribute13,
    attribute14,
    attribute15,
    employee_id,
    party_id,
    start_active_date,
    end_active_date,
    priority_code,
    original_author,
    original_author_date,
    visibility_id,
    latest_version_flag,
    USAGE_SCORE )
  VALUES (
    x_set_id,
    x_set_number,
    x_set_type_id,
    x_set_name,
    x_group_flag,
    x_status,
    null, --l_access_level, --Commented out 14-Jul-2003 - Not required in 11.5.10
    x_creation_date,
    x_created_by,
    x_last_update_date,
    x_last_updated_by,
    x_last_update_login,
    x_locked_by,
    x_lock_date,
    x_attribute_category,
    x_attribute1,
    x_attribute2,
    x_attribute3,
    x_attribute4,
    x_attribute5,
    x_attribute6,
    x_attribute7,
    x_attribute8,
    x_attribute9,
    x_attribute10,
    x_attribute11,
    x_attribute12,
    x_attribute13,
    x_attribute14,
    x_attribute15,
    x_employee_id,
    x_party_id,
    x_start_active_date,
    x_end_active_date,
    4, --l_priority_code,
    x_created_by,
    x_creation_date,
    x_visibility_id,
    'Y',
    0 );

Line: 164

  INSERT INTO CS_KB_SETS_TL (
    set_id,
    name,
    description,
    creation_date,
    created_by,
    last_update_date,
    last_updated_by,
    last_update_login,
    language,
    source_lang
  ) SELECT
    x_set_id,
    x_name,
    x_description,
    x_creation_date,
    x_created_by,
    x_last_update_date,
    x_last_updated_by,
    x_last_update_login,
    l.language_code,
    USERENV('LANG')
  FROM fnd_languages l
  WHERE l.installed_flag IN ('I', 'B')
  AND NOT EXISTS
    (SELECT NULL
     FROM CS_KB_SETS_TL t
     WHERE t.set_id = x_set_id
     AND t.language = l.language_code);

Line: 202

 END Insert_Row;

Line: 240

   SELECT
      set_id,
      set_number,
      set_type_id,
      set_name,
      group_flag,
      status,
      access_level,
      locked_by,
      lock_date,
      attribute_category,
      attribute1,
      attribute2,
      attribute3,
      attribute4,
      attribute5,
      attribute6,
      attribute7,
      attribute8,
      attribute9,
      attribute10,
      attribute11,
      attribute12,
      attribute13,
      attribute14,
      attribute15,
      employee_id,
      party_id,
      start_active_date,
      end_active_date,
      priority_code
   FROM CS_KB_SETS_B
   WHERE set_id = x_set_id
   FOR UPDATE OF set_id NOWAIT;

Line: 278

   SELECT
      name,
      description,
      decode(language, USERENV('LANG'), 'Y', 'N') baselang
   FROM CS_KB_SETS_TL
   WHERE set_id = x_set_id
   AND USERENV('LANG') IN (language, source_lang)
   FOR UPDATE OF set_id NOWAIT;

Line: 292

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

Line: 381

 PROCEDURE Update_Row (
   X_SET_ID             IN NUMBER,
   X_SET_NUMBER         IN VARCHAR2,
   X_SET_TYPE_ID        IN NUMBER,
   X_SET_NAME           IN VARCHAR2,
   X_GROUP_FLAG         IN NUMBER,
   X_STATUS             IN VARCHAR2,
   X_ACCESS_LEVEL       IN NUMBER,
   X_NAME               IN VARCHAR2,
   X_DESCRIPTION        IN VARCHAR2,
   X_LAST_UPDATE_DATE   IN DATE,
   X_LAST_UPDATED_BY    IN NUMBER,
   X_LAST_UPDATE_LOGIN  IN NUMBER,
   X_LOCKED_BY          IN NUMBER,
   X_LOCK_DATE          IN DATE,
   X_ATTRIBUTE_CATEGORY IN VARCHAR2,
   X_ATTRIBUTE1         IN VARCHAR2,
   X_ATTRIBUTE2         IN VARCHAR2,
   X_ATTRIBUTE3         IN VARCHAR2,
   X_ATTRIBUTE4         IN VARCHAR2,
   X_ATTRIBUTE5         IN VARCHAR2,
   X_ATTRIBUTE6         IN VARCHAR2,
   X_ATTRIBUTE7         IN VARCHAR2,
   X_ATTRIBUTE8         IN VARCHAR2,
   X_ATTRIBUTE9         IN VARCHAR2,
   X_ATTRIBUTE10        IN VARCHAR2,
   X_ATTRIBUTE11        IN VARCHAR2,
   X_ATTRIBUTE12        IN VARCHAR2,
   X_ATTRIBUTE13        IN VARCHAR2,
   X_ATTRIBUTE14        IN VARCHAR2,
   X_ATTRIBUTE15        IN VARCHAR2,
   X_EMPLOYEE_ID        IN NUMBER,
   X_PARTY_ID           IN NUMBER,
   X_START_ACTIVE_DATE  IN DATE,
   X_END_ACTIVE_DATE    IN DATE,
   X_PRIORITY_CODE      IN NUMBER,
   X_VISIBILITY_ID      IN NUMBER )
 IS

 BEGIN

  UPDATE CS_KB_SETS_B SET
    set_type_id = x_set_type_id,
    set_name = x_set_name,
    group_flag = x_group_flag,
    status = x_status,
    --access_level = l_access_level,
    last_update_date = x_last_update_date,
    last_updated_by = x_last_updated_by,
    last_update_login = x_last_update_login,
    locked_by = x_locked_by,
    lock_date = x_lock_date,
    attribute_category = x_attribute_category,
    attribute1 = x_attribute1,
    attribute2 = x_attribute2,
    attribute3 = x_attribute3,
    attribute4 = x_attribute4,
    attribute5 = x_attribute5,
    attribute6 = x_attribute6,
    attribute7 = x_attribute7,
    attribute8 = x_attribute8,
    attribute9 = x_attribute9,
    attribute10 = x_attribute10,
    attribute11 = x_attribute11,
    attribute12 = x_attribute12,
    attribute13 = x_attribute13,
    attribute14 = x_attribute14,
    attribute15 = x_attribute15,
    employee_id = x_employee_id,
    party_id = x_party_id,
    start_active_date = x_start_active_date,
    end_active_date = x_end_active_date,
    --priority_code = l_priority_code,
    visibility_id = x_visibility_id
  WHERE set_id = x_set_id;

Line: 461

  UPDATE CS_KB_SETS_TL SET
    name = x_name,
    description = x_description,
    last_update_date = x_last_update_date,
    last_updated_by = x_last_updated_by,
    last_update_login = x_last_update_login,
    source_lang = USERENV('LANG')
  WHERE set_id = x_set_id
  AND USERENV('LANG') IN (language, source_lang);

Line: 475

 END Update_Row;

Line: 478

 PROCEDURE Delete_Row (
   X_SET_NUMBER IN VARCHAR2 )
 IS

 CURSOR c IS
  SELECT set_id
  FROM CS_KB_SETS_B
  WHERE set_number = X_SET_NUMBER;

Line: 490

    DELETE FROM CS_KB_SETS_TL
    WHERE set_id = rec.set_id;

Line: 494

  DELETE FROM CS_KB_SETS_B
  WHERE set_number = x_set_number;

Line: 500

 END Delete_Row;

Line: 508

  DELETE FROM CS_KB_SETS_TL t
  WHERE NOT EXISTS
    (SELECT NULL
     FROM CS_KB_SETS_B b
     WHERE b.set_id = t.set_id );

Line: 514

  UPDATE CS_KB_SETS_TL T SET (
      name,
      description
    ) = (SELECT
      b.name,
      b.description
    FROM CS_KB_SETS_TL b
    WHERE b.set_id = t.set_id
    AND b.language = t.source_lang)
  WHERE (
      t.set_id,
      t.language
  ) IN (SELECT
      subt.set_id,
      subt.language
    FROM CS_KB_SETS_TL subb, CS_KB_SETS_TL subt
    WHERE subb.set_id = subt.set_id
    AND subb.language = subt.source_lang
    AND (subb.name <> subt.name
      OR (subb.name IS NULL AND subt.name IS NOT NULL)
      OR (subb.name IS not NULL AND subt.name IS NULL)
      OR subb.description <> subt.description
      OR (subb.description IS NULL AND subt.description IS NOT NULL)
      OR (subb.description IS NOT NULL AND subt.description IS NULL)
  ));

Line: 540

  INSERT INTO CS_KB_SETS_TL (
    set_id,
    name,
    description,
    creation_date,
    created_by,
    last_update_date,
    last_update_login,
    last_updated_by,
    language,
    source_lang
  ) SELECT
    b.set_id,
    b.name,
    b.description,
    b.creation_date,
    b.created_by,
    b.last_update_date,
    b.last_update_login,
    b.last_updated_by,
    l.language_code,
    b.source_lang
  FROM CS_KB_SETS_TL b, fnd_languages l --bayu
  WHERE l.installed_flag IN ('I', 'B')
  AND b.language = USERENV('LANG')
  AND NOT EXISTS
    (SELECT NULL
    FROM CS_KB_SETS_TL t
    WHERE t.set_id = b.set_id
    AND t.language = l.language_code);

Line: 581

  UPDATE CS_KB_SETS_TL SET
	name = x_name,
	last_update_date  = SYSDATE,
    last_updated_by   = decode(x_owner, 'SEED', 1, 0),
    last_update_login = 0,
    source_lang       = USERENV('LANG')
  WHERE set_id = X_SET_ID
  AND USERENV('LANG') IN (language, source_lang);

Line: 619

    Update_Row(
      x_set_id => x_set_id,
      x_set_number => x_set_number,
      x_set_type_id => x_set_type_id,
      x_set_name => NULL,
      x_group_flag => NULL,
      x_status => x_status,
      x_access_level => x_access_level,
      x_name => x_name,
      x_description => NULL,
      x_last_update_date => SYSDATE,
      x_last_updated_by => l_user_id,
      x_last_update_login => 0,
      x_locked_by => l_locked_by,
      x_lock_date => l_lock_date,
      x_visibility_id => x_visibility_id);

Line: 638

        	Insert_Row(
       		  x_rowid => l_rowid,
              x_set_id => x_set_id,
              x_set_number => x_set_number,
              x_set_type_id => x_set_type_id,
              x_set_name => NULL,
              x_group_flag => NULL,
              x_status => x_status,
              x_access_level => x_access_level,
              x_name => x_name,
              x_description => NULL,
    		  x_creation_date => SYSDATE,
    		  x_created_by => l_user_id,
    		  x_last_update_date => SYSDATE,
    		  x_last_updated_by => l_user_id,
    		  x_last_update_login => 0,
              x_locked_by => NULL,
              x_lock_date => NULL,
              x_visibility_id => x_visibility_id);