APPS.ASG_PROD_PKG SQL Statements

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

Line: 14

procedure insert_row (
  x_PROD_TOP in VARCHAR2,
  x_RUN_ORDER in NUMBER,
  x_INI_FILE in VARCHAR2,
  x_ZIP_FILE 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_PROD_INFO(
    PROD_TOP,
    RUN_ORDER,
    INI_FILE,
    ZIP_FILE,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    RELEASE_VERSION
  ) values (
    decode(X_PROD_TOP, FND_API.G_MISS_CHAR, NULL, x_PROD_TOP),
    decode(X_RUN_ORDER,FND_API.G_MISS_NUM, NULL, x_RUN_ORDER),
    decode(X_INI_FILE, FND_API.G_MISS_CHAR, NULL, x_INI_FILE),
    decode(X_ZIP_FILE, FND_API.G_MISS_CHAR, NULL, x_ZIP_FILE),
    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: 50

end insert_row;

Line: 53

procedure update_row (
  x_PROD_TOP in VARCHAR2,
  x_RUN_ORDER in NUMBER,
  x_INI_FILE in VARCHAR2,
  x_ZIP_FILE 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: 69

     update asg_PROD_INFO set
      RUN_ORDER = X_RUN_ORDER,
      PROD_TOP = x_PROD_TOP,
      INI_FILE = X_INI_FILE,
      ZIP_FILE = x_ZIP_FILE,
      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 PROD_TOP = X_PROD_TOP
     and nvl(RELEASE_VERSION,-1) <> x_RELEASE_VERSION;

Line: 86

          select count(*) into x_count from asg_prod_info
          where PROD_TOP = X_PROD_TOP;

Line: 97

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

Line: 108

END UPDATE_ROW;

Line: 118

  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: 131

  asg_prod_pkg.UPDATE_ROW (
    X_PROD_TOP                     => x_PROD_TOP,
    X_RUN_ORDER                    => x_RUN_ORDER,
    X_INI_FILE                     => x_INI_FILE,
    X_ZIP_FILE                     => x_ZIP_FILE,
    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: 145

  asg_prod_pkg.insert_row (
    X_PROD_TOP                     => x_PROD_TOP,
    X_RUN_ORDER                    => x_RUN_ORDER,
    X_INI_FILE                     => x_INI_FILE,
    X_ZIP_FILE                     => x_ZIP_FILE,
    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);