eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_RATE_DIM_TIERS_PKG SQL Statements

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

Line: 4


procedure INSERT_ROW (
  X_RATE_DIM_TIER_ID      IN OUT NOCOPY CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE,
  X_RATE_DIMENSION_ID     IN     CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
  X_DIM_UNIT_CODE         IN     CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE  := NULL,
  X_MINIMUM_AMOUNT        IN     CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := NULL,
  X_MAXIMUM_AMOUNT        IN     CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := NULL,
  X_MIN_EXP_ID            IN     CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE     := NULL,
  X_MAX_EXP_ID            IN     CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE     := NULL,
  X_STRING_VALUE          IN     CN_RATE_DIM_TIERS.STRING_VALUE%TYPE   := NULL,
  X_TIER_SEQUENCE         IN     CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,
  -- R12 MOAC Changes--Start
  X_ORG_ID                IN     CN_RATE_DIM_TIERS.ORG_ID%TYPE, --new
  -- R12 MOAC Changes--End
  X_ATTRIBUTE_CATEGORY    IN     CN_RATE_DIM_TIERS.ATTRIBUTE_CATEGORY%TYPE := NULL,
  X_ATTRIBUTE1            IN     CN_RATE_DIM_TIERS.ATTRIBUTE1%TYPE  := NULL,
  X_ATTRIBUTE2            IN     CN_RATE_DIM_TIERS.ATTRIBUTE2%TYPE  := NULL,
  X_ATTRIBUTE3            IN     CN_RATE_DIM_TIERS.ATTRIBUTE3%TYPE  := NULL,
  X_ATTRIBUTE4            IN     CN_RATE_DIM_TIERS.ATTRIBUTE4%TYPE  := NULL,
  X_ATTRIBUTE5            IN     CN_RATE_DIM_TIERS.ATTRIBUTE5%TYPE  := NULL,
  X_ATTRIBUTE6            IN     CN_RATE_DIM_TIERS.ATTRIBUTE6%TYPE  := NULL,
  X_ATTRIBUTE7            IN     CN_RATE_DIM_TIERS.ATTRIBUTE7%TYPE  := NULL,
  X_ATTRIBUTE8            IN     CN_RATE_DIM_TIERS.ATTRIBUTE8%TYPE  := NULL,
  X_ATTRIBUTE9            IN     CN_RATE_DIM_TIERS.ATTRIBUTE9%TYPE  := NULL,
  X_ATTRIBUTE10           IN     CN_RATE_DIM_TIERS.ATTRIBUTE10%TYPE := NULL,
  X_ATTRIBUTE11           IN     CN_RATE_DIM_TIERS.ATTRIBUTE11%TYPE := NULL,
  X_ATTRIBUTE12           IN     CN_RATE_DIM_TIERS.ATTRIBUTE12%TYPE := NULL,
  X_ATTRIBUTE13           IN     CN_RATE_DIM_TIERS.ATTRIBUTE13%TYPE := NULL,
  X_ATTRIBUTE14           IN     CN_RATE_DIM_TIERS.ATTRIBUTE14%TYPE := NULL,
  X_ATTRIBUTE15           IN     CN_RATE_DIM_TIERS.ATTRIBUTE15%TYPE := NULL,
  X_CREATION_DATE         IN     CN_RATE_DIM_TIERS.CREATION_DATE%TYPE     := SYSDATE,
  X_CREATED_BY            IN     CN_RATE_DIM_TIERS.CREATED_BY%TYPE        := FND_GLOBAL.USER_ID,
  X_LAST_UPDATE_DATE      IN     CN_RATE_DIM_TIERS.LAST_UPDATE_DATE%TYPE  := SYSDATE,
  X_LAST_UPDATED_BY       IN     CN_RATE_DIM_TIERS.LAST_UPDATED_BY%TYPE   := FND_GLOBAL.USER_ID,
  X_LAST_UPDATE_LOGIN     IN     CN_RATE_DIM_TIERS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID) IS

  cursor C is select rate_dim_tier_id from CN_RATE_DIM_TIERS
    where RATE_DIM_TIER_ID = x_rate_dim_tier_id;

Line: 42


  CURSOR id IS SELECT cn_rate_dim_tiers_s.NEXTVAL FROM dual;

Line: 54


  insert into CN_RATE_DIM_TIERS (
    RATE_DIM_TIER_ID,
    RATE_DIMENSION_ID,
    DIM_UNIT_CODE,
    MINIMUM_AMOUNT,
    MAXIMUM_AMOUNT,
    MIN_EXP_ID,
    MAX_EXP_ID,
    STRING_VALUE,
    TIER_SEQUENCE,
    -- R12 MOAC Changes--Start
    ORG_ID,
    -- R12 MOAC Changes--End
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATE_LOGIN,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    OBJECT_VERSION_NUMBER
  ) VALUES (
    X_RATE_DIM_TIER_ID,
    X_RATE_DIMENSION_ID,
    X_DIM_UNIT_CODE,
    X_MINIMUM_AMOUNT,
    X_MAXIMUM_AMOUNT,
    X_MIN_EXP_ID,
    X_MAX_EXP_ID,
    X_STRING_VALUE,
    X_TIER_SEQUENCE,
    -- R12 MOAC Changes--Start
    X_ORG_ID,
    -- R12 MOAC Changes--End
    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_CREATED_BY,
    X_CREATION_DATE,
    X_LAST_UPDATE_LOGIN,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    1);

Line: 133


end INSERT_ROW;

Line: 140


   select object_version_number
     from CN_RATE_DIM_TIERS
    where RATE_DIM_TIER_ID = X_RATE_DIM_TIER_ID
      for update of RATE_DIM_TIER_ID nowait;

Line: 151


      fnd_message.set_name('CN', 'CN_RECORD_DELETED');

Line: 165


procedure UPDATE_ROW (
  X_RATE_DIM_TIER_ID      IN     CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE,
  X_RATE_DIMENSION_ID     IN     CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
  X_DIM_UNIT_CODE         IN     CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE  := FND_API.G_MISS_CHAR,
  X_MINIMUM_AMOUNT        IN     CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := FND_API.G_MISS_NUM,
  X_MAXIMUM_AMOUNT        IN     CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := FND_API.G_MISS_NUM,
  X_MIN_EXP_ID            IN     CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE     := FND_API.G_MISS_NUM,
  X_MAX_EXP_ID            IN     CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE     := FND_API.G_MISS_NUM,
  X_STRING_VALUE          IN     CN_RATE_DIM_TIERS.STRING_VALUE%TYPE   := FND_API.G_MISS_CHAR,
  X_TIER_SEQUENCE         IN     CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE  := FND_API.G_MISS_NUM,
  X_ATTRIBUTE_CATEGORY    IN     CN_RATE_DIM_TIERS.ATTRIBUTE_CATEGORY%TYPE := FND_API.G_MISS_CHAR,
  X_ATTRIBUTE1            IN     CN_RATE_DIM_TIERS.ATTRIBUTE1%TYPE  := FND_API.G_MISS_CHAR,
  X_ATTRIBUTE2            IN     CN_RATE_DIM_TIERS.ATTRIBUTE2%TYPE  := FND_API.G_MISS_CHAR,
  X_ATTRIBUTE3            IN     CN_RATE_DIM_TIERS.ATTRIBUTE3%TYPE  := FND_API.G_MISS_CHAR,
  X_ATTRIBUTE4            IN     CN_RATE_DIM_TIERS.ATTRIBUTE4%TYPE  := FND_API.G_MISS_CHAR,
  X_ATTRIBUTE5            IN     CN_RATE_DIM_TIERS.ATTRIBUTE5%TYPE  := FND_API.G_MISS_CHAR,
  X_ATTRIBUTE6            IN     CN_RATE_DIM_TIERS.ATTRIBUTE6%TYPE  := FND_API.G_MISS_CHAR,
  X_ATTRIBUTE7            IN     CN_RATE_DIM_TIERS.ATTRIBUTE7%TYPE  := FND_API.G_MISS_CHAR,
  X_ATTRIBUTE8            IN     CN_RATE_DIM_TIERS.ATTRIBUTE8%TYPE  := FND_API.G_MISS_CHAR,
  X_ATTRIBUTE9            IN     CN_RATE_DIM_TIERS.ATTRIBUTE9%TYPE  := FND_API.G_MISS_CHAR,
  X_ATTRIBUTE10           IN     CN_RATE_DIM_TIERS.ATTRIBUTE10%TYPE := FND_API.G_MISS_CHAR,
  X_ATTRIBUTE11           IN     CN_RATE_DIM_TIERS.ATTRIBUTE11%TYPE := FND_API.G_MISS_CHAR,
  X_ATTRIBUTE12           IN     CN_RATE_DIM_TIERS.ATTRIBUTE12%TYPE := FND_API.G_MISS_CHAR,
  X_ATTRIBUTE13           IN     CN_RATE_DIM_TIERS.ATTRIBUTE13%TYPE := FND_API.G_MISS_CHAR,
  X_ATTRIBUTE14           IN     CN_RATE_DIM_TIERS.ATTRIBUTE14%TYPE := FND_API.G_MISS_CHAR,
  X_ATTRIBUTE15           IN     CN_RATE_DIM_TIERS.ATTRIBUTE15%TYPE := FND_API.G_MISS_CHAR,
  X_LAST_UPDATE_DATE      IN     CN_RATE_DIM_TIERS.LAST_UPDATE_DATE%TYPE  := SYSDATE,
  X_LAST_UPDATED_BY       IN     CN_RATE_DIM_TIERS.LAST_UPDATED_BY%TYPE   := FND_GLOBAL.USER_ID,
  X_LAST_UPDATE_LOGIN     IN     CN_RATE_DIM_TIERS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID,
  X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_RATE_DIM_TIERS.OBJECT_VERSION_NUMBER%TYPE) IS

BEGIN
  X_OBJECT_VERSION_NUMBER := X_OBJECT_VERSION_NUMBER + 1;

Line: 198


  update CN_RATE_DIM_TIERS set
    DIM_UNIT_CODE = Decode(X_DIM_UNIT_CODE, fnd_api.g_miss_char, dim_unit_code, x_dim_unit_code),
    MINIMUM_AMOUNT = Decode(X_MINIMUM_AMOUNT, fnd_api.g_miss_num, minimum_amount, x_minimum_amount),
    MAXIMUM_AMOUNT = Decode(X_MAXIMUM_AMOUNT, fnd_api.g_miss_num, maximum_amount, x_maximum_amount),
    MIN_EXP_ID = Decode(X_MIN_EXP_ID, fnd_api.g_miss_num, min_exp_id, x_min_exp_id),
    MAX_EXP_ID = Decode(X_MAX_EXP_ID, fnd_api.g_miss_num, max_exp_id, x_max_exp_id),
    STRING_VALUE = Decode(X_STRING_VALUE, fnd_api.g_miss_char, string_value, x_string_value),
    TIER_SEQUENCE = Decode(X_TIER_SEQUENCE, fnd_api.g_miss_num, tier_sequence, x_tier_sequence),
    ATTRIBUTE_CATEGORY = Decode(X_ATTRIBUTE_CATEGORY, fnd_api.g_miss_char, attribute_category, x_attribute_category),
    ATTRIBUTE1 = Decode(X_ATTRIBUTE1, fnd_api.g_miss_char, attribute1, x_attribute1),
    ATTRIBUTE2 = Decode(X_ATTRIBUTE2, fnd_api.g_miss_char, attribute2, x_attribute2),
    ATTRIBUTE3 = Decode(X_ATTRIBUTE3, fnd_api.g_miss_char, attribute3, x_attribute3),
    ATTRIBUTE4 = Decode(X_ATTRIBUTE4, fnd_api.g_miss_char, attribute4, x_attribute4),
    ATTRIBUTE5 = Decode(X_ATTRIBUTE5, fnd_api.g_miss_char, attribute5, x_attribute5),
    ATTRIBUTE6 = Decode(X_ATTRIBUTE6, fnd_api.g_miss_char, attribute6, x_attribute6),
    ATTRIBUTE7 = Decode(X_ATTRIBUTE7, fnd_api.g_miss_char, attribute7, x_attribute7),
    ATTRIBUTE8 = Decode(X_ATTRIBUTE8, fnd_api.g_miss_char, attribute8, x_attribute8),
    ATTRIBUTE9 = Decode(X_ATTRIBUTE9, fnd_api.g_miss_char, attribute9, x_attribute9),
    ATTRIBUTE10 = Decode(X_ATTRIBUTE10, fnd_api.g_miss_char, attribute10, x_attribute10),
    ATTRIBUTE11 = Decode(X_ATTRIBUTE11, fnd_api.g_miss_char, attribute11, x_attribute11),
    ATTRIBUTE12 = Decode(X_ATTRIBUTE12, fnd_api.g_miss_char, attribute12, x_attribute12),
    ATTRIBUTE13 = Decode(X_ATTRIBUTE13, fnd_api.g_miss_char, attribute13, x_attribute13),
    ATTRIBUTE14 = Decode(X_ATTRIBUTE14, fnd_api.g_miss_char, attribute14, x_attribute14),
    ATTRIBUTE15 = Decode(X_ATTRIBUTE15, fnd_api.g_miss_char, attribute15, x_attribute15),
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER
  where RATE_DIM_TIER_ID = x_rate_dim_tier_id;

Line: 229


     fnd_message.set_name('CN', 'CN_RECORD_DELETED');

Line: 233


end UPDATE_ROW;

Line: 235


procedure DELETE_ROW (
   X_RATE_DIM_TIER_ID      IN     CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE) is
begin
  delete from CN_RATE_DIM_TIERS
  where RATE_DIM_TIER_ID = X_RATE_DIM_TIER_ID;

Line: 242


     fnd_message.set_name('CN', 'CN_RECORD_DELETED');

Line: 247


end DELETE_ROW;