REM dbdrv: sql ~PROD ~PATH ~FILE none none none package &phase=pls \
REM dbdrv: checkfile:~PROD:~PATH:~FILE
/*=======================================================================+
 |  Copyright (c) 1997 Oracle Corporation Redwood Shores, California, USA|
 |                            All rights reserved.                       |
 +=======================================================================+
 | FILENAME
 |   wfacas.sql
 | DESCRIPTION
 |   PL/SQL spec for package:  WF_ACTIVITY_ATTRIBUTES_PKG
 *=======================================================================*/
set verify off;
whenever sqlerror exit failure rollback;
WHENEVER OSERROR EXIT FAILURE ROLLBACK;

create or replace package WF_ACTIVITY_ATTRIBUTES_PKG as
/* $Header: wfacas.pls 26.3 2002/12/03 00:32:12 dlam ship $ */
procedure INSERT_ROW (
  X_ROWID in out nocopy VARCHAR2,
  X_ACTIVITY_ITEM_TYPE in VARCHAR2,
  X_ACTIVITY_NAME in VARCHAR2,
  X_ACTIVITY_VERSION in NUMBER,
  X_NAME in VARCHAR2,
  X_SEQUENCE in NUMBER,
  X_TYPE in VARCHAR2,
  X_VALUE_TYPE in VARCHAR2,
  X_PROTECT_LEVEL in NUMBER,
  X_CUSTOM_LEVEL in NUMBER,
  X_SUBTYPE in VARCHAR2,
  X_FORMAT in VARCHAR2,
  X_TEXT_DEFAULT in VARCHAR2,
  X_NUMBER_DEFAULT in NUMBER,
  X_DATE_DEFAULT in DATE,
  X_DISPLAY_NAME in VARCHAR2,
  X_DESCRIPTION in VARCHAR2
);
procedure LOCK_ROW (
  X_ACTIVITY_ITEM_TYPE in VARCHAR2,
  X_ACTIVITY_NAME in VARCHAR2,
  X_ACTIVITY_VERSION in NUMBER,
  X_NAME in VARCHAR2,
  X_SEQUENCE in NUMBER,
  X_TYPE in VARCHAR2,
  X_VALUE_TYPE in VARCHAR2,
  X_PROTECT_LEVEL in NUMBER,
  X_CUSTOM_LEVEL in NUMBER,
  X_SUBTYPE in VARCHAR2,
  X_FORMAT in VARCHAR2,
  X_TEXT_DEFAULT in VARCHAR2,
  X_NUMBER_DEFAULT in NUMBER,
  X_DATE_DEFAULT in DATE,
  X_DISPLAY_NAME in VARCHAR2,
  X_DESCRIPTION in VARCHAR2
);
procedure UPDATE_ROW (
  X_ACTIVITY_ITEM_TYPE in VARCHAR2,
  X_ACTIVITY_NAME in VARCHAR2,
  X_ACTIVITY_VERSION in NUMBER,
  X_NAME in VARCHAR2,
  X_SEQUENCE in NUMBER,
  X_TYPE in VARCHAR2,
  X_VALUE_TYPE in VARCHAR2,
  X_PROTECT_LEVEL in NUMBER,
  X_CUSTOM_LEVEL in NUMBER,
  X_SUBTYPE in VARCHAR2,
  X_FORMAT in VARCHAR2,
  X_TEXT_DEFAULT in VARCHAR2,
  X_NUMBER_DEFAULT in NUMBER,
  X_DATE_DEFAULT in DATE,
  X_DISPLAY_NAME in VARCHAR2,
  X_DESCRIPTION in VARCHAR2
);
procedure DELETE_ROW (
  X_ACTIVITY_ITEM_TYPE in VARCHAR2,
  X_ACTIVITY_NAME in VARCHAR2,
  X_ACTIVITY_VERSION in NUMBER,
  X_NAME in VARCHAR2
);
procedure ADD_LANGUAGE;
end WF_ACTIVITY_ATTRIBUTES_PKG;
/
-- show errors package WF_ACTIVITY_ATTRIBUTES_PKG
commit;
exit;