APPS.ASG_CONFIG_PKG SQL Statements

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

Line: 14

procedure insert_row (
  x_NAME in VARCHAR2,
  x_VALUE 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_RELEASE_VERSION  in NUMBER) IS


begin


  insert into ASG_CONFIG (
    NAME,
    VALUE,
    DESCRIPTION,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    RELEASE_VERSION
  ) values (
    decode(X_NAME,FND_API.G_MISS_CHAR, NULL, x_NAME),
    decode(X_VALUE, FND_API.G_MISS_CHAR, NULL, x_VALUE),
    decode(X_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, x_DESCRIPTION),
    decode(X_CREATION_DATE,FND_API.G_MISS_DATE, NULL, x_creation_date),
    decode(X_CREATED_BY,FND_API.G_MISS_NUM, NULL,x_created_by),
    decode(X_LAST_UPDATE_DATE,FND_API.G_MISS_DATE, NULL, x_last_update_date),
    decode(X_LAST_UPDATED_BY,FND_API.G_MISS_NUM, NULL,x_last_updated_by),
    decode(X_RELEASE_VERSION, FND_API.G_MISS_NUM, NULL, x_release_version)
  );

Line: 58

end insert_row;

Line: 60

procedure update_row (
 x_NAME in VARCHAR2,
  x_VALUE 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) IS

x_count number;

Line: 72

     update asg_config set
      NAME = X_NAME,
      VALUE = x_VALUE,
      DESCRIPTION = X_DESCRIPTION,
      CREATION_DATE = X_CREATION_DATE,
      CREATED_BY = X_CREATED_BY,
      LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
      LAST_UPDATED_BY = X_LAST_UPDATED_BY
     where NAME = X_NAME;

Line: 86

END UPDATE_ROW;

Line: 89

procedure update_row (
 x_NAME in VARCHAR2,
  x_VALUE 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_RELEASE_VERSION in NUMBER) IS
x_count number;

Line: 103

     update asg_config set
      NAME = X_NAME,
      VALUE = x_VALUE,
      DESCRIPTION = X_DESCRIPTION,
      CREATION_DATE = X_CREATION_DATE,
      CREATED_BY = X_CREATED_BY,
      LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
      LAST_UPDATED_BY = X_LAST_UPDATED_BY,
      RELEASE_VERSION = X_RELEASE_VERSION
     where NAME = X_NAME
     and nvl(RELEASE_VERSION,-1) <> x_RELEASE_VERSION;

Line: 119

          select count(*) into x_count from asg_config
          where name = X_NAME;

Line: 130

       existing, we should raise and then insert_row will catch
      and insert it then. */
     begin
          select count(*) into x_count from asg_config
          where name = X_NAME;

Line: 141

END UPDATE_ROW;

Line: 150

  x_LAST_UPDATE_DATE in DATE,
  x_LAST_UPDATED_BY in NUMBER,
  p_owner in VARCHAR2)  IS

    l_user_id      number := 0;

Line: 162

  asg_config_pkg.UPDATE_ROW (
    X_NAME                         => x_NAME,
    X_VALUE                        => x_VALUE,
    X_DESCRIPTION                  => x_DESCRIPTION,
    X_CREATION_DATE                => X_CREATION_DATE,
    X_CREATED_BY                   => X_CREATED_BY,
    X_LAST_UPDATE_DATE             => sysdate,
    X_LAST_UPDATED_BY              => l_user_id);

Line: 185

  x_LAST_UPDATE_DATE in DATE,
  x_LAST_UPDATED_BY in NUMBER,
  x_RELEASE_VERSION in NUMBER,
  p_owner in VARCHAR2)  IS

    l_user_id      number := 0;

Line: 199

  asg_config_pkg.UPDATE_ROW (
    X_NAME	                   => x_NAME,
    X_VALUE	                   => x_VALUE,
    X_DESCRIPTION  	           => x_DESCRIPTION,
    X_CREATION_DATE                => X_CREATION_DATE,
    X_CREATED_BY                   => X_CREATED_BY,
    X_LAST_UPDATE_DATE             => sysdate,
    X_LAST_UPDATED_BY              => l_user_id,
    x_RELEASE_VERSION              => X_RELEASE_VERSION);

Line: 212

  asg_config_pkg.insert_row (
    X_NAME	                   => x_NAME,
    X_VALUE                       => x_VALUE,
    X_DESCRIPTION	           => x_DESCRIPTION,
    X_CREATION_DATE                => sysdate,
    X_CREATED_BY                   => l_user_id,
    X_LAST_UPDATE_DATE             => sysdate,
    X_LAST_UPDATED_BY              => l_user_id,
    X_RELEASE_VERSION              => X_RELEASE_VERSION);