APPS.BNE_PARAM_LIST_ITEMS_PKG SQL Statements

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

Line: 4

procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_APPLICATION_ID in NUMBER,
  X_PARAM_LIST_CODE in VARCHAR2,
  X_SEQUENCE_NUM in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_PARAM_DEFN_APP_ID in NUMBER,
  X_PARAM_DEFN_CODE in VARCHAR2,
  X_ATTRIBUTE_APP_ID in NUMBER,
  X_ATTRIBUTE_CODE in VARCHAR2,
  X_STRING_VALUE in VARCHAR2,
  X_DATE_VALUE in DATE,
  X_NUMBER_VALUE in NUMBER,
  X_BOOLEAN_VALUE_FLAG in VARCHAR2,
  X_FORMULA_VALUE in VARCHAR2,
  X_DESC_VALUE in VARCHAR2,
  X_PARAM_NAME 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
) is
  cursor C is select ROWID from BNE_PARAM_LIST_ITEMS
    where APPLICATION_ID = X_APPLICATION_ID
    and PARAM_LIST_CODE = X_PARAM_LIST_CODE
    and SEQUENCE_NUM = X_SEQUENCE_NUM
    ;

Line: 33

  insert into BNE_PARAM_LIST_ITEMS (
    APPLICATION_ID,
    PARAM_LIST_CODE,
    SEQUENCE_NUM,
    OBJECT_VERSION_NUMBER,
    PARAM_DEFN_APP_ID,
    PARAM_DEFN_CODE,
    PARAM_NAME,
    ATTRIBUTE_APP_ID,
    ATTRIBUTE_CODE,
    STRING_VALUE,
    DATE_VALUE,
    NUMBER_VALUE,
    BOOLEAN_VALUE_FLAG,
    FORMULA_VALUE,
    DESC_VALUE,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN
  ) values (
    X_APPLICATION_ID,
    X_PARAM_LIST_CODE,
    X_SEQUENCE_NUM,
    X_OBJECT_VERSION_NUMBER,
    X_PARAM_DEFN_APP_ID,
    X_PARAM_DEFN_CODE,
    X_PARAM_NAME,
    X_ATTRIBUTE_APP_ID,
    X_ATTRIBUTE_CODE,
    X_STRING_VALUE,
    X_DATE_VALUE,
    X_NUMBER_VALUE,
    X_BOOLEAN_VALUE_FLAG,
    X_FORMULA_VALUE,
    X_DESC_VALUE,
    X_CREATED_BY,
    X_CREATION_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATE_LOGIN
  );

Line: 85

end INSERT_ROW;

Line: 104

  cursor c1 is select
      OBJECT_VERSION_NUMBER,
      PARAM_DEFN_APP_ID,
      PARAM_DEFN_CODE,
      ATTRIBUTE_APP_ID,
      ATTRIBUTE_CODE,
      STRING_VALUE,
      DATE_VALUE,
      NUMBER_VALUE,
      BOOLEAN_VALUE_FLAG,
      FORMULA_VALUE,
      DESC_VALUE,
      PARAM_NAME
    from BNE_PARAM_LIST_ITEMS
    where APPLICATION_ID = X_APPLICATION_ID
    and PARAM_LIST_CODE = X_PARAM_LIST_CODE
    and SEQUENCE_NUM = X_SEQUENCE_NUM
    for update of APPLICATION_ID nowait;

Line: 157

procedure UPDATE_ROW (
  X_APPLICATION_ID in NUMBER,
  X_PARAM_LIST_CODE in VARCHAR2,
  X_SEQUENCE_NUM in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_PARAM_DEFN_APP_ID in NUMBER,
  X_PARAM_DEFN_CODE in VARCHAR2,
  X_ATTRIBUTE_APP_ID in NUMBER,
  X_ATTRIBUTE_CODE in VARCHAR2,
  X_STRING_VALUE in VARCHAR2,
  X_DATE_VALUE in DATE,
  X_NUMBER_VALUE in NUMBER,
  X_BOOLEAN_VALUE_FLAG in VARCHAR2,
  X_FORMULA_VALUE in VARCHAR2,
  X_DESC_VALUE in VARCHAR2,
  X_PARAM_NAME in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update BNE_PARAM_LIST_ITEMS set
    OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
    PARAM_DEFN_APP_ID = X_PARAM_DEFN_APP_ID,
    PARAM_DEFN_CODE = X_PARAM_DEFN_CODE,
    ATTRIBUTE_APP_ID = X_ATTRIBUTE_APP_ID,
    ATTRIBUTE_CODE = X_ATTRIBUTE_CODE,
    STRING_VALUE = X_STRING_VALUE,
    DATE_VALUE = X_DATE_VALUE,
    NUMBER_VALUE = X_NUMBER_VALUE,
    BOOLEAN_VALUE_FLAG = X_BOOLEAN_VALUE_FLAG,
    FORMULA_VALUE = X_FORMULA_VALUE,
    DESC_VALUE = X_DESC_VALUE,
    PARAM_NAME = X_PARAM_NAME,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where APPLICATION_ID = X_APPLICATION_ID
  and PARAM_LIST_CODE = X_PARAM_LIST_CODE
  and SEQUENCE_NUM = X_SEQUENCE_NUM;

Line: 202

end UPDATE_ROW;

Line: 204

procedure DELETE_ROW (
  X_APPLICATION_ID in NUMBER,
  X_PARAM_LIST_CODE in VARCHAR2,
  X_SEQUENCE_NUM in NUMBER
) is
begin
  delete from BNE_PARAM_LIST_ITEMS
  where APPLICATION_ID = X_APPLICATION_ID
  and PARAM_LIST_CODE = X_PARAM_LIST_CODE
  and SEQUENCE_NUM = X_SEQUENCE_NUM;

Line: 219

end DELETE_ROW;

Line: 257

  x_last_update_date      IN VARCHAR2,
  x_custom_mode           IN VARCHAR2
)
is
  l_app_id            number;

Line: 268

  f_ludate            date;    -- entity update date in file

Line: 270

  db_ludate           date;    -- entity update date in db

Line: 292

  f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);

Line: 294

    select LAST_UPDATED_BY, LAST_UPDATE_DATE
    into db_luby, db_ludate
    from BNE_PARAM_LIST_ITEMS
    where APPLICATION_ID  = l_app_id
    and   PARAM_LIST_CODE = x_param_list_code
    and   SEQUENCE_NUM    = x_sequence_num;

Line: 305

      BNE_PARAM_LIST_ITEMS_PKG.Update_Row(
        X_APPLICATION_ID        => l_app_id,
        X_PARAM_LIST_CODE       => x_param_list_code,
        X_SEQUENCE_NUM          => x_sequence_num,
        X_OBJECT_VERSION_NUMBER => x_object_version_number,
        X_PARAM_DEFN_APP_ID     => l_param_defn_app_id,
        X_PARAM_DEFN_CODE       => x_param_defn_code,
        X_ATTRIBUTE_APP_ID      => l_attr_app_id,
        X_ATTRIBUTE_CODE        => x_attribute_code,
        X_STRING_VALUE          => x_string_value,
        X_DATE_VALUE            => l_date_value,
        X_NUMBER_VALUE          => l_number_value,
        X_BOOLEAN_VALUE_FLAG    => x_boolean_value_flag,
        X_FORMULA_VALUE         => x_formula_value,
        X_DESC_VALUE            => x_desc_value,
        X_PARAM_NAME            => x_param_name,
        X_LAST_UPDATE_DATE      => f_ludate,
        X_LAST_UPDATED_BY       => f_luby,
        X_LAST_UPDATE_LOGIN     => 0
      );

Line: 329

      BNE_PARAM_LIST_ITEMS_PKG.Insert_Row(
        X_ROWID                 => l_row_id,
        X_APPLICATION_ID        => l_app_id,
        X_PARAM_LIST_CODE       => x_param_list_code,
        X_SEQUENCE_NUM          => x_sequence_num,
        X_OBJECT_VERSION_NUMBER => x_object_version_number,
        X_PARAM_DEFN_APP_ID     => l_param_defn_app_id,
        X_PARAM_DEFN_CODE       => x_param_defn_code,
        X_ATTRIBUTE_APP_ID      => l_attr_app_id,
        X_ATTRIBUTE_CODE        => x_attribute_code,
        X_STRING_VALUE          => x_string_value,
        X_DATE_VALUE            => l_date_value,
        X_NUMBER_VALUE          => l_number_value,
        X_BOOLEAN_VALUE_FLAG    => x_boolean_value_flag,
        X_FORMULA_VALUE         => x_formula_value,
        X_DESC_VALUE            => x_desc_value,
        X_PARAM_NAME            => x_param_name,
        X_CREATION_DATE         => f_ludate,
        X_CREATED_BY            => f_luby,
        X_LAST_UPDATE_DATE      => f_ludate,
        X_LAST_UPDATED_BY       => f_luby,
        X_LAST_UPDATE_LOGIN     => 0
      );