APPS.ASG_PUB_PKG SQL Statements

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

Line: 21

procedure insert_row (
  x_PUB_ID in VARCHAR2,
  x_NAME in VARCHAR2,
  x_ENABLED in VARCHAR2,
  x_STATUS  in VARCHAR2,
  x_LAST_RELEASE_VERSION in NUMBER,
  x_CURRENT_RELEASE_VERSION in NUMBER,
  x_WRAPPER_NAME    in VARCHAR2,
  x_DEVICE_TYPE in VARCHAR2,
  x_ENABLE_SYNCH in VARCHAR2,
  x_NEED_RESOURCEID in VARCHAR2,
  x_CUSTOM  in VARCHAR2,
  x_SHARED_BY in VARCHAR2,
  x_ADDITIONAL_DEVICE_TYPE 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


begin


  insert into ASG_PUB (
    PUB_ID,
    NAME,
    ENABLED,
    STATUS,
    LAST_RELEASE_VERSION,
    CURRENT_RELEASE_VERSION,
    WRAPPER_NAME,
    DEVICE_TYPE,
    ENABLE_SYNCH,
    NEED_RESOURCEID,
    CUSTOM,
    SHARED_BY,
    ADDITIONAL_DEVICE_TYPE,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY
  ) values (
    x_pub_id,
    decode(X_NAME,FND_API.G_MISS_CHAR, NULL, x_NAME),
    decode(X_ENABLED, FND_API.G_MISS_CHAR, NULL, x_ENABLED),
    'N',
    0,
    decode(x_CURRENT_release_version,FND_API.G_MISS_NUM, NULL, x_CURRENT_RELEASE_VERSION),
    decode(X_WRAPPER_NAME,FND_API.G_MISS_CHAR, NULL, x_wrapper_name),
    x_device_Type,
    'Y',
    decode(X_NEED_RESOURCEID, FND_API.G_MISS_CHAR, NULL, x_NEED_RESOURCEID),
    decode(X_CUSTOM, FND_API.G_MISS_CHAR, NULL, x_CUSTOM),
    decode(X_SHARED_BY, FND_API.G_MISS_CHAR, NULL, x_SHARED_BY),
    decode(X_ADDITIONAL_DEVICE_TYPE, FND_API.G_MISS_CHAR, NULL, x_ADDITIONAL_DEVICE_TYPE),
    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: 92

end insert_row;

Line: 94

procedure update_row (
   x_PUB_ID in VARCHAR2,
  x_NAME in VARCHAR2,
  x_ENABLED in VARCHAR2,
  x_STATUS  in VARCHAR2,
  x_LAST_RELEASE_VERSION in NUMBER,
  x_CURRENT_RELEASE_VERSION in NUMBER,
  x_WRAPPER_NAME    in VARCHAR2,
  x_DEVICE_TYPE in VARCHAR2,
  x_ENABLE_SYNCH in VARCHAR2,
  x_NEED_RESOURCEID in VARCHAR2,
  x_CUSTOM  in VARCHAR2,
  x_SHARED_BY in VARCHAR2,
  x_ADDITIONAL_DEVICE_TYPE 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

l_update_flag varchar2(1);

Line: 117

   select nvl(custom, 'N')
   into l_update_flag
   from asg_pub
   where pub_id = x_pub_id;

Line: 122

 if (l_update_flag = 'N' ) then
   update asg_pub set
    PUB_ID = X_PUB_ID,
    NAME = X_NAME,
    ENABLED = X_ENABLED,
--    STATUS = X_STATUS,
--    LAST_RELEASE_VERSION = X_LAST_RELEASE_VERSION,
    CURRENT_RELEASE_VERSION = X_CURRENT_RELEASE_VERSION,
    WRAPPER_NAME = X_WRAPPER_NAME,
    DEVICE_TYPE = X_DEVICE_TYPE,
    NEED_RESOURCEID = X_NEED_RESOURCEID,
    CUSTOM = X_CUSTOM,
    SHARED_BY = X_SHARED_BY,
    ADDITIONAL_DEVICE_TYPE = X_ADDITIONAL_DEVICE_TYPE,
--    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;

Line: 142

   update asg_pub set
       ADDITIONAL_DEVICE_TYPE = X_ADDITIONAL_DEVICE_TYPE
   where PUB_ID = X_PUB_ID;

Line: 150

END UPDATE_ROW;

Line: 169

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

    l_user_id      number := 0;

Line: 182

  asg_pub_pkg.UPDATE_ROW (
    X_PUB_ID       		   => x_PUB_ID,
    X_NAME	                   => x_NAME,
    X_ENABLED                      => x_ENABLED,
    X_STATUS			   => x_STATUS,
    X_LAST_RELEASE_VERSION         => x_LAST_release_version,
    X_CURRENT_RELEASE_VERSION      => x_CURRENT_release_version,
    X_WRAPPER_NAME                 => X_WRAPPER_NAME,
    x_DEVICE_TYPE		   => x_DEVICE_TYPE,
    x_ENABLE_SYNCH                 => x_ENABLE_SYNCH,
    x_NEED_RESOURCEID              => x_NEED_RESOURCEID,
    x_CUSTOM                       => x_CUSTOM,
    x_SHARED_BY                    => x_SHARED_BY,
    x_ADDITIONAL_DEVICE_TYPE       => x_ADDITIONAL_DEVICE_TYPE,
    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: 204

  asg_pub_pkg.insert_row (
    X_PUB_ID       		   => x_PUB_ID,
    X_NAME	                   => x_NAME,
    X_ENABLED                      => x_ENABLED,
    X_STATUS			   => x_STATUS,
    X_LAST_RELEASE_VERSION         => x_LAST_release_version,
    X_CURRENT_RELEASE_VERSION      => x_CURRENT_release_version,
    X_WRAPPER_NAME                 => X_WRAPPER_NAME,
    x_DEVICE_TYPE		   => x_DEVICE_TYPE,
    x_ENABLE_SYNCH                 => x_ENABLE_SYNCH,
    x_NEED_RESOURCEID              => x_NEED_RESOURCEID,
    x_CUSTOM                       => x_CUSTOM,
    x_SHARED_BY                    => x_SHARED_BY,
    x_ADDITIONAL_DEVICE_TYPE       => x_ADDITIONAL_DEVICE_TYPE,
    X_CREATION_DATE                => sysdate,
    X_CREATED_BY                   => l_user_id,
    X_LAST_UPDATE_DATE             => sysdate,
    X_LAST_UPDATED_BY              => l_user_id);