APPS.ASG_RESP_PKG SQL Statements

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

Line: 8

procedure insert_row (
  x_PUB_ID in VARCHAR2,
  x_RESPONSIBILITY_ID in NUMBER,
  x_CREATION_DATE in DATE,
  x_CREATED_BY in NUMBER,
  x_LAST_UPDATE_DATE in DATE,
  x_LAST_UPDATED_BY in NUMBER) IS


begin


  insert into ASG_PUB_RESPONSIBILITY (
    PUB_ID,
    RESPONSIBILITY_ID,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY
  ) values (
    x_pub_id,
    decode(x_RESPONSIBILITY_ID,FND_API.G_MISS_NUM, NULL, x_RESPONSIBILITY_ID),
    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)
  );

Line: 46

end insert_row;

Line: 48

procedure update_row (
   x_PUB_ID in VARCHAR2,
  x_RESPONSIBILITY_ID in NUMBER,
  x_CREATION_DATE in DATE,
  x_CREATED_BY in NUMBER,
  x_LAST_UPDATE_DATE in DATE,
  x_LAST_UPDATED_BY in NUMBER) IS
begin
   update asg_pub_RESPONSIBILITY set
    PUB_ID = X_PUB_ID,
    RESPONSIBILITY_ID = x_RESPONSIBILITY_ID,
    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 PUB_ID = X_PUB_ID
       and responsibility_id = x_RESPONSIBILITY_ID;

Line: 69

END UPDATE_ROW;

Line: 77

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

    l_user_id      number := 0;

Line: 90

  asg_resp_pkg.UPDATE_ROW (
    X_PUB_ID       		   => x_PUB_ID,
    X_RESPONSIBILITY_ID            => x_RESPONSIBILITY_ID,
    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: 101

  asg_resp_pkg.insert_row (
    X_PUB_ID       		   => x_PUB_ID,
    x_RESPONSIBILITY_ID            => x_RESPONSIBILITY_Id,
    X_CREATION_DATE                => sysdate,
    X_CREATED_BY                   => l_user_id,
    X_LAST_UPDATE_DATE             => sysdate,
    X_LAST_UPDATED_BY              => l_user_id);