APPS.XDO_CONFIG_VALUES_PKG SQL Statements

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

Line: 4

procedure INSERT_ROW (
          P_VALUE_ID in NUMBER,
          P_CONFIG_LEVEL in NUMBER,
          P_APPLICATION_SHORT_NAME in VARCHAR2,
          P_DATA_SOURCE_CODE in VARCHAR2,
          P_TEMPLATE_CODE in VARCHAR2,
          P_PROPERTY_CODE in VARCHAR2,
          P_VALUE in VARCHAR2,
          P_BVALUE in RAW,
          P_CREATION_DATE in DATE,
          P_CREATED_BY in NUMBER,
          P_LAST_UPDATE_DATE in DATE,
          P_LAST_UPDATED_BY in NUMBER,
          P_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  insert into XDO_CONFIG_VALUES (
           VALUE_ID,
           CONFIG_LEVEL,
           APPLICATION_SHORT_NAME,
           DATA_SOURCE_CODE,
           TEMPLATE_CODE,
           PROPERTY_CODE,
           VALUE,
           BVALUE,
           CREATION_DATE,
           CREATED_BY,
           LAST_UPDATE_DATE,
           LAST_UPDATED_BY,
           LAST_UPDATE_LOGIN
  ) values (
          P_VALUE_ID,
          P_CONFIG_LEVEL,
          P_APPLICATION_SHORT_NAME,
          P_DATA_SOURCE_CODE,
          P_TEMPLATE_CODE,
          P_PROPERTY_CODE,
          P_VALUE,
          P_BVALUE,
          P_CREATION_DATE,
          P_CREATED_BY,
          P_LAST_UPDATE_DATE,
          P_LAST_UPDATED_BY,
          P_LAST_UPDATE_LOGIN
  );

Line: 49

end INSERT_ROW;

Line: 53

procedure UPDATE_ROW (
          P_CONFIG_LEVEL in NUMBER,
          P_APPLICATION_SHORT_NAME in VARCHAR2,
          P_DATA_SOURCE_CODE in VARCHAR2,
          P_TEMPLATE_CODE in VARCHAR2,
          P_PROPERTY_CODE in VARCHAR2,
          P_VALUE in VARCHAR2,
          P_BVALUE in RAW,
          P_LAST_UPDATE_DATE in DATE,
          P_LAST_UPDATED_BY in NUMBER,
          P_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update XDO_CONFIG_VALUES
     set VALUE = P_VALUE,
         BVALUE = P_BVALUE,
         LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
         LAST_UPDATED_BY = P_LAST_UPDATED_BY,
         LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN
  where CONFIG_LEVEL = P_CONFIG_LEVEL
    and (   (APPLICATION_SHORT_NAME is null and P_APPLICATION_SHORT_NAME is null)
         or (APPLICATION_SHORT_NAME = P_APPLICATION_SHORT_NAME))
    and (   (DATA_SOURCE_CODE is null and P_DATA_SOURCE_CODE is null)
         or (DATA_SOURCE_CODE = P_DATA_SOURCE_CODE))
    and (   (TEMPLATE_CODE is null and P_TEMPLATE_CODE is null)
         or (TEMPLATE_CODE = P_TEMPLATE_CODE))
    and PROPERTY_CODE = P_PROPERTY_CODE;

Line: 85

end UPDATE_ROW;

Line: 98

  select value_id
    into m_value_id
   from xdo_config_values
  where CONFIG_LEVEL = P_CONFIG_LEVEL
    and (   (APPLICATION_SHORT_NAME is null and P_APPLICATION_SHORT_NAME is null)
         or (APPLICATION_SHORT_NAME = P_APPLICATION_SHORT_NAME))
    and (   (DATA_SOURCE_CODE is null and P_DATA_SOURCE_CODE is null)
         or (DATA_SOURCE_CODE = P_DATA_SOURCE_CODE))
    and (   (TEMPLATE_CODE is null and P_TEMPLATE_CODE is null)
         or (TEMPLATE_CODE = P_TEMPLATE_CODE))
    and PROPERTY_CODE = P_PROPERTY_CODE;

Line: 119

procedure DELETE_ROW (
          P_CONFIG_LEVEL in NUMBER,
          P_APPLICATION_SHORT_NAME in VARCHAR2,
          P_DATA_SOURCE_CODE in VARCHAR2,
          P_TEMPLATE_CODE in VARCHAR2,
          P_PROPERTY_CODE in VARCHAR2
) is

  m_value_id number;

Line: 131

  select value_id
    into m_value_id
    from xdo_config_values
  where CONFIG_LEVEL = P_CONFIG_LEVEL
    and (   (APPLICATION_SHORT_NAME is null and P_APPLICATION_SHORT_NAME is null)
         or (APPLICATION_SHORT_NAME = P_APPLICATION_SHORT_NAME))
    and (   (DATA_SOURCE_CODE is null and P_DATA_SOURCE_CODE is null)
         or (DATA_SOURCE_CODE = P_DATA_SOURCE_CODE))
    and (   (TEMPLATE_CODE is null and P_TEMPLATE_CODE is null)
         or (TEMPLATE_CODE = P_TEMPLATE_CODE))
    and PROPERTY_CODE = P_PROPERTY_CODE;

Line: 148

    xdo_config_keys_pkg.delete_row(m_value_id);

Line: 153

  delete from XDO_CONFIG_VALUES
   where value_id = m_value_id;

Line: 156

end DELETE_ROW;

Line: 167

          P_LAST_UPDATE_DATE in DATE,
          P_LAST_UPDATED_BY in NUMBER,
          P_LAST_UPDATE_LOGIN in NUMBER
) is

  value_id number;

Line: 178

     UPDATE_ROW (
          P_CONFIG_LEVEL,
          P_APPLICATION_SHORT_NAME,
          P_DATA_SOURCE_CODE,
          P_TEMPLATE_CODE,
          P_PROPERTY_CODE,
          P_VALUE,
          null,
          P_LAST_UPDATE_DATE,
          P_LAST_UPDATED_BY,
          P_LAST_UPDATE_LOGIN
     );

Line: 193

      select xdo_config_values_seq.nextval into value_id from dual;

Line: 195

      INSERT_ROW (
          value_id,
          P_CONFIG_LEVEL,
          P_APPLICATION_SHORT_NAME,
          P_DATA_SOURCE_CODE,
          P_TEMPLATE_CODE,
          P_PROPERTY_CODE,
          P_VALUE,
          null,
          P_LAST_UPDATE_DATE,
          P_LAST_UPDATED_BY,
          P_LAST_UPDATE_DATE,
          P_LAST_UPDATED_BY,
          P_LAST_UPDATE_LOGIN
      );