approve.wft

这是大家学习oracle数据流的好工具的介绍

# Oracle Workflow Process Definition
# dbdrv: exec fnd bin WFLOAD bin &phase=daa+52 checkfile:~PROD:~PATH:~FILE \
# dbdrv: &ui_apps 0 Y UPGRADE @~PROD:~PATH/~FILE
# $Header$


VERSION_MAJOR = "2"
VERSION_MINOR = "6"
LANGUAGE = "SIMPLIFIED CHINESE"

ACCESS_LEVEL = "100"

DEFINE ITEM_TYPE
  KEY NAME VARCHAR2(8)
  TRANS DISPLAY_NAME VARCHAR2(80)
  TRANS DESCRIPTION VARCHAR2(240)
  BASE PROTECT_LEVEL NUMBER
  BASE CUSTOM_LEVEL NUMBER
  BASE WF_SELECTOR VARCHAR2(240)
  BASE READ_ROLE REFERENCES ROLE
  BASE WRITE_ROLE REFERENCES ROLE
  BASE EXECUTE_ROLE REFERENCES ROLE
  BASE PERSISTENCE_TYPE VARCHAR2(8)
  BASE PERSISTENCE_DAYS NUMBER

  DEFINE ITEM_ATTRIBUTE
    KEY NAME VARCHAR2(30)
    TRANS DISPLAY_NAME VARCHAR2(80)
    TRANS DESCRIPTION VARCHAR2(240)
    BASE PROTECT_LEVEL NUMBER
    BASE CUSTOM_LEVEL NUMBER
    BASE TYPE VARCHAR2(8)
    BASE FORMAT VARCHAR2(240)
    BASE VALUE_TYPE VARCHAR2(8)
    BASE DEFAULT VARCHAR2(4000)
  END ITEM_ATTRIBUTE
END ITEM_TYPE

DEFINE LOOKUP_TYPE
  KEY NAME VARCHAR2(30)
  TRANS DISPLAY_NAME VARCHAR2(80)
  TRANS DESCRIPTION VARCHAR2(240)
  BASE PROTECT_LEVEL NUMBER
  BASE CUSTOM_LEVEL NUMBER
  BASE ITEM_TYPE REFERENCES ITEM_TYPE

  DEFINE LOOKUP_CODE
    KEY NAME VARCHAR2(30)
    TRANS MEANING VARCHAR2(80)
    TRANS DESCRIPTION VARCHAR2(240)
  END LOOKUP_CODE
END LOOKUP_TYPE

DEFINE MESSAGE
  KEY ITEM_TYPE REFERENCES ITEM_TYPE
  KEY NAME VARCHAR2(30)
  TRANS DISPLAY_NAME VARCHAR2(80)
  TRANS DESCRIPTION VARCHAR2(240)
  BASE PROTECT_LEVEL NUMBER
  BASE CUSTOM_LEVEL NUMBER
  TRANS SUBJECT VARCHAR2(240)
  TRANS BODY VARCHAR2(4000)
  TRANS HTML_BODY VARCHAR2(4000)
  BASE DEFAULT_PRIORITY NUMBER
  BASE READ_ROLE REFERENCES ROLE
  BASE WRITE_ROLE REFERENCES ROLE

  DEFINE MESSAGE_ATTRIBUTE
    KEY NAME VARCHAR2(30)
    TRANS DISPLAY_NAME VARCHAR2(80)
    TRANS DESCRIPTION VARCHAR2(240)
    BASE TYPE VARCHAR2(8)
    BASE SUBTYPE VARCHAR2(8)
    BASE FORMAT VARCHAR2(240)
    BASE VALUE_TYPE VARCHAR2(8)
    BASE DEFAULT VARCHAR2(4000)
    BASE ATTACH VARCHAR2(1)
  END MESSAGE_ATTRIBUTE
END MESSAGE

DEFINE ACTIVITY
  KEY ITEM_TYPE REFERENCES ITEM_TYPE
  KEY NAME VARCHAR2(30)
  TRANS DISPLAY_NAME VARCHAR2(80)
  TRANS DESCRIPTION VARCHAR2(240)
  BASE PROTECT_LEVEL NUMBER
  BASE CUSTOM_LEVEL NUMBER
  BASE TYPE VARCHAR2(8)
  BASE FUNCTION VARCHAR2(240)
  BASE FUNCTION_TYPE VARCHAR2(30)
  BASE RESULT_TYPE VARCHAR2(30)
  BASE RERUN VARCHAR2(8)
  BASE COST NUMBER
  BASE READ_ROLE REFERENCES ROLE
  BASE WRITE_ROLE REFERENCES ROLE
  BASE EXECUTE_ROLE REFERENCES ROLE
  BASE ICON_NAME VARCHAR2(30)
  BASE MESSAGE VARCHAR2(30)
  BASE ERROR_PROCESS VARCHAR2(30)
  BASE ERROR_ITEM_TYPE VARCHAR2(8)
  BASE EXPAND_ROLE VARCHAR2(1)
  BASE RUNNABLE VARCHAR2(1)
  BASE EVENT_FILTER VARCHAR2(240)
  BASE EVENT_TYPE VARCHAR2(30)

  DEFINE ACTIVITY_ATTRIBUTE
    KEY NAME VARCHAR2(30)
    TRANS DISPLAY_NAME VARCHAR2(80)
    TRANS DESCRIPTION VARCHAR2(240)
    BASE TYPE VARCHAR2(8)
    BASE FORMAT VARCHAR2(240)
    BASE VALUE_TYPE VARCHAR2(8)
    BASE DEFAULT VARCHAR2(4000)
  END ACTIVITY_ATTRIBUTE

  DEFINE PROCESS_ACTIVITY
    KEY LABEL VARCHAR2(30)
    BASE ACTIVITY_ITEM_TYPE REFERENCES ITEM_TYPE
    BASE ACTIVITY_NAME VARCHAR2(30)
    BASE START_END VARCHAR2(8)
    BASE DEFAULT_RESULT VARCHAR2(30)
    BASE ICON_GEOMETRY VARCHAR2(2000)
    BASE VALUE_TYPE VARCHAR2(8)
    BASE PERFORM_ROLE REFERENCES ROLE
    BASE USER_COMMENT VARCHAR2(4000)

    DEFINE ACTIVITY_ATTRIBUTE_VALUE
      KEY NAME VARCHAR2(30)
      BASE VALUE_TYPE VARCHAR2(8)
      BASE VALUE VARCHAR2(4000)
    END ACTIVITY_ATTRIBUTE_VALUE

    DEFINE ACTIVITY_TRANSITION
      KEY FROM REFERENCES PROCESS_ACTIVITY
      KEY TO REFERENCES PROCESS_ACTIVITY
      BASE ARROW_GEOMETRY VARCHAR2(2000)
    END ACTIVITY_TRANSITION
  END PROCESS_ACTIVITY
END ACTIVITY

DEFINE ROLE
  KEY NAME VARCHAR2(320)
  BASE DISPLAY_NAME VARCHAR2(360)
  BASE DESCRIPTION VARCHAR2(1000)
  BASE NOTIFICATION_PREFERENCE VARCHAR2(8)
  BASE LANGUAGE VARCHAR2(30)
  BASE TERRITORY VARCHAR2(30)
  BASE EMAIL_ADDRESS VARCHAR2(320)
  BASE FAX VARCHAR2(240)
  BASE STATUS VARCHAR2(8)
  BASE EXPIRATION_DATE DATE
END ROLE

BEGIN ITEM_TYPE "APPROVE"
  PROTECT_LEVEL = "100"
  CUSTOM_LEVEL = "100"
  DISPLAY_NAME = "@@审批出差报销工作流"
  DESCRIPTION = "营销部门费用审批工作流"
  PERSISTENCE_TYPE = "TEMP"
  PERSISTENCE_DAYS = "0"

  BEGIN ITEM_ATTRIBUTE "BXR"
  PROTECT_LEVEL = "100"
  CUSTOM_LEVEL = "100"
    DISPLAY_NAME = "报销人名称"
    TYPE = "ROLE"
    VALUE_TYPE = "CONSTANT"
  END ITEM_ATTRIBUTE

  BEGIN ITEM_ATTRIBUTE "SPR"
  PROTECT_LEVEL = "100"
  CUSTOM_LEVEL = "100"
    DISPLAY_NAME = "审批人名称"
    TYPE = "ROLE"
    VALUE_TYPE = "CONSTANT"
  END ITEM_ATTRIBUTE

  BEGIN ITEM_ATTRIBUTE "BXJE"
  PROTECT_LEVEL = "100"
  CUSTOM_LEVEL = "100"
    DISPLAY_NAME = "报销金额"
    TYPE = "NUMBER"
    VALUE_TYPE = "CONSTANT"
  END ITEM_ATTRIBUTE

  BEGIN ITEM_ATTRIBUTE "URL"
  PROTECT_LEVEL = "100"
  CUSTOM_LEVEL = "100"
    DISPLAY_NAME = "（GOOGLE）"
    TYPE = "URL"
    FORMAT = "_blank"
    VALUE_TYPE = "CONSTANT"
  END ITEM_ATTRIBUTE

  BEGIN ITEM_ATTRIBUTE "FORM"
  PROTECT_LEVEL = "100"
  CUSTOM_LEVEL = "100"
    DISPLAY_NAME = "打开一个新的功能"
    DESCRIPTION = "打开一个新的功能"
    TYPE = "FORM"
    VALUE_TYPE = "CONSTANT"
  END ITEM_ATTRIBUTE

  BEGIN ITEM_ATTRIBUTE "DOC"
  PROTECT_LEVEL = "100"
  CUSTOM_LEVEL = "100"
    DISPLAY_NAME = "文档示例"
    TYPE = "DOCUMENT"
    FORMAT = "_top"
    VALUE_TYPE = "CONSTANT"
  END ITEM_ATTRIBUTE

  BEGIN ITEM_ATTRIBUTE "ID"
  PROTECT_LEVEL = "100"
  CUSTOM_LEVEL = "100"
    DISPLAY_NAME = "主键"
    TYPE = "VARCHAR2"
    VALUE_TYPE = "CONSTANT"
  END ITEM_ATTRIBUTE

  BEGIN ITEM_ATTRIBUTE "DATE"
  PROTECT_LEVEL = "100"
  CUSTOM_LEVEL = "100"
    DISPLAY_NAME = "date"
    TYPE = "DATE"
    FORMAT = "YYYY-MM-DD HH24:MI:SS"
    VALUE_TYPE = "CONSTANT"
  END ITEM_ATTRIBUTE
END ITEM_TYPE

BEGIN LOOKUP_TYPE "APPROVE"
  PROTECT_LEVEL = "100"
  CUSTOM_LEVEL = "100"
  DISPLAY_NAME = "@审批动作"
  ITEM_TYPE = "APPROVE"

  BEGIN LOOKUP_CODE "APP"
    MEANING = "审批"
  END LOOKUP_CODE

  BEGIN LOOKUP_CODE "JECT"
    MEANING = "拒绝"
  END LOOKUP_CODE
END LOOKUP_TYPE

BEGIN LOOKUP_TYPE "DAXIAO"
  PROTECT_LEVEL = "100"
  CUSTOM_LEVEL = "100"
  DISPLAY_NAME = "金额大小"
  ITEM_TYPE = "APPROVE"

  BEGIN LOOKUP_CODE "DAYU"
    MEANING = "大于等于1000"
  END LOOKUP_CODE

  BEGIN LOOKUP_CODE "XIAOYU"
    MEANING = "小于1000"
  END LOOKUP_CODE
END LOOKUP_TYPE

BEGIN LOOKUP_TYPE "ENTER"
  PROTECT_LEVEL = "100"
  CUSTOM_LEVEL = "100"
  DISPLAY_NAME = "@@确认"
  ITEM_TYPE = "APPROVE"

  BEGIN LOOKUP_CODE "ENTER"
    MEANING = "确认（ENTER）"
  END LOOKUP_CODE
END LOOKUP_TYPE

BEGIN LOOKUP_TYPE "ISCOMMIT"
  PROTECT_LEVEL = "100"
  CUSTOM_LEVEL = "100"
  DISPLAY_NAME = "是否已经提交"
  ITEM_TYPE = "APPROVE"

  BEGIN LOOKUP_CODE "COMMIT"
    MEANING = "提交"
  END LOOKUP_CODE

  BEGIN LOOKUP_CODE "SAVE"
    MEANING = "保存状态"
  END LOOKUP_CODE
END LOOKUP_TYPE

BEGIN LOOKUP_TYPE "SUBMIT"
  PROTECT_LEVEL = "100"
  CUSTOM_LEVEL = "100"
  DISPLAY_NAME = "更新为提交状态"
  ITEM_TYPE = "APPROVE"

  BEGIN LOOKUP_CODE "N"
    MEANING = "不更新"
  END LOOKUP_CODE

  BEGIN LOOKUP_CODE "Y"
    MEANING = "更新"
  END LOOKUP_CODE
END LOOKUP_TYPE

BEGIN MESSAGE "APPROVE" "BAOXIAO"
  PROTECT_LEVEL = "100"
  CUSTOM_LEVEL = "100"
  DISPLAY_NAME = "费用已经报销"
  SUBJECT = "费用已经报销"
  BODY = "费用已经报销,请查收"
  DEFAULT_PRIORITY = "50"

  BEGIN MESSAGE_ATTRIBUTE "RESULT"
    DISPLAY_NAME = "qq"
    FORMAT = "ENTER"
    VALUE_TYPE = "CONSTANT"
    DEFAULT = "ENTER"
  END MESSAGE_ATTRIBUTE
END MESSAGE

BEGIN MESSAGE "APPROVE" "COMMIT"
  PROTECT_LEVEL = "100"
  CUSTOM_LEVEL = "100"
  DISPLAY_NAME = "已经记帐"
  SUBJECT = "是否已经记帐"
  HTML_BODY = "<table width=200 border=1>\n\
<tr>\n\
  <td>\n\
    报销人:&BXR\n\
  </td>\n\
</tr>\n\
<tr>\n\
  <td>\n\
    报销金额:&BXJE\n\
  </td>\n\
</tr>\n\
<tr>\n\
  <td>\n\
    已经记帐\n\
  </td>\n\
</tr>\n\
</table>"
  DEFAULT_PRIORITY = "50"

  BEGIN MESSAGE_ATTRIBUTE "BXR"
    DISPLAY_NAME = "报销人名称"
    TYPE = "ROLE"
    SUBTYPE = "SEND"
    VALUE_TYPE = "ITEMATTR"
    DEFAULT = "BXR"
  END MESSAGE_ATTRIBUTE

  BEGIN MESSAGE_ATTRIBUTE "BXJE"
    DISPLAY_NAME = "报销金额"
    TYPE = "NUMBER"
    SUBTYPE = "SEND"
    VALUE_TYPE = "ITEMATTR"
    DEFAULT = "BXJE"
  END MESSAGE_ATTRIBUTE
END MESSAGE

BEGIN MESSAGE "APPROVE" "COMMITIT"
  PROTECT_LEVEL = "100"
  CUSTOM_LEVEL = "100"
  DISPLAY_NAME = "是否更新为已提交状态"
  SUBJECT = "是否更新为已提交状态"
  HTML_BODY = "是否更新为提交状态???\n\
请\
打\
开\
&URL"
  DEFAULT_PRIORITY = "50"

  BEGIN MESSAGE_ATTRIBUTE "RESULT"
    DISPLAY_NAME = "是否更新呢?"
    FORMAT = "SUBMIT"
    VALUE_TYPE = "CONSTANT"
    DEFAULT = "Y"
  END MESSAGE_ATTRIBUTE

  BEGIN MESSAGE_ATTRIBUTE "URL"
    DISPLAY_NAME = "（GOOGLE）"
    TYPE = "URL"
    SUBTYPE = "SEND"
    FORMAT = "_top"
    VALUE_TYPE = "ITEMATTR"
    DEFAULT = "URL"
  END MESSAGE_ATTRIBUTE
END MESSAGE

BEGIN MESSAGE "APPROVE" "DAYU"
  PROTECT_LEVEL = "100"
  CUSTOM_LEVEL = "100"
  DISPLAY_NAME = "大于1000的提示"
  SUBJECT = "大于1000"
  BODY = "金额大于1000,请总经理审批!&DOC&DATE"
  DEFAULT_PRIORITY = "50"

  BEGIN MESSAGE_ATTRIBUTE "RESULT"
    DISPLAY_NAME = "是否审批?"
    FORMAT = "APPROVE"
    VALUE_TYPE = "CONSTANT"
    DEFAULT = "JECT"
  END MESSAGE_ATTRIBUTE

  BEGIN MESSAGE_ATTRIBUTE "SPR"
    DISPLAY_NAME = "审批人名称"
    TYPE = "ROLE"
    SUBTYPE = "SEND"
    VALUE_TYPE = "ITEMATTR"
    DEFAULT = "SPR"
  END MESSAGE_ATTRIBUTE

  BEGIN MESSAGE_ATTRIBUTE "BXR"
    DISPLAY_NAME = "报销人名称"
    TYPE = "ROLE"
    SUBTYPE = "SEND"
    VALUE_TYPE = "ITEMATTR"
    DEFAULT = "BXR"
  END MESSAGE_ATTRIBUTE

  BEGIN MESSAGE_ATTRIBUTE "BXJE"
    DISPLAY_NAME = "报销金额"
    TYPE = "NUMBER"
    SUBTYPE = "SEND"
    VALUE_TYPE = "ITEMATTR"
    DEFAULT = "BXJE"
  END MESSAGE_ATTRIBUTE

  BEGIN MESSAGE_ATTRIBUTE "DOC"
    DISPLAY_NAME = "文档示例"
    TYPE = "DOCUMENT"
    SUBTYPE = "SEND"
    FORMAT = "_top"
    VALUE_TYPE = "ITEMATTR"
    DEFAULT = "DOC"
  END MESSAGE_ATTRIBUTE

  BEGIN MESSAGE_ATTRIBUTE "DATE"
    DISPLAY_NAME = "date"
    TYPE = "DATE"
    SUBTYPE = "SEND"
    FORMAT = "YYYY-MM-DD HH24:MI:SS"
    VALUE_TYPE = "ITEMATTR"
    DEFAULT = "DATE"
  END MESSAGE_ATTRIBUTE
END MESSAGE

BEGIN MESSAGE "APPROVE" "REJECTINFOR"
  PROTECT_LEVEL = "100"
  CUSTOM_LEVEL = "100"
  DISPLAY_NAME = "拒绝信息"
  SUBJECT = "拒绝信息"
  HTML_BODY = "<table width=200 border=1>\n\
<tr>\n\
  <td>\n\
    报销人:&BXR\n\
  </td>\n\
</tr>\n\
<tr>\n\
  <td>\n\
    报销金额:&BXJE\n\
  </td>\n\
</tr>\n\
<tr>\n\
  <td>\n\
    您的报销已被&SPR拒绝！！\n\
  </td>\n\
</tr>\n\
</table>"
  DEFAULT_PRIORITY = "50"

  BEGIN MESSAGE_ATTRIBUTE "RESULT"
    DISPLAY_NAME = "确认"
    FORMAT = "ENTER"
    VALUE_TYPE = "CONSTANT"
    DEFAULT = "ENTER"
  END MESSAGE_ATTRIBUTE

  BEGIN MESSAGE_ATTRIBUTE "BXR"
    DISPLAY_NAME = "报销人名称"
    TYPE = "ROLE"
    SUBTYPE = "SEND"
    VALUE_TYPE = "ITEMATTR"
    DEFAULT = "BXR"
  END MESSAGE_ATTRIBUTE

  BEGIN MESSAGE_ATTRIBUTE "BXJE"
    DISPLAY_NAME = "报销金额"
    TYPE = "NUMBER"
    SUBTYPE = "SEND"
    VALUE_TYPE = "ITEMATTR"
    DEFAULT = "BXJE"
  END MESSAGE_ATTRIBUTE

  BEGIN MESSAGE_ATTRIBUTE "SPR"
    DISPLAY_NAME = "审批人名称"
    TYPE = "ROLE"
    SUBTYPE = "SEND"
    VALUE_TYPE = "ITEMATTR"
    DEFAULT = "SPR"
  END MESSAGE_ATTRIBUTE
END MESSAGE

BEGIN MESSAGE "APPROVE" "XIAOYU"
  PROTECT_LEVEL = "100"
  CUSTOM_LEVEL = "100"
  DISPLAY_NAME = "小于"
  SUBJECT = "小于"
  HTML_BODY = "<table width=200 border=1>\n\
<tr>\n\
  <td>\n\
    报销人:&BXR\n\
  </td>\n\
</tr>\n\
<tr>\n\
  <td>\n\
    报销金额:&BXJE\n\
  </td>\n\
</tr>\n\
<tr>\n\
  <td>\n\
    处于提交状态，金额小于1000，《&FORM》\n\
  </td>\n\
</tr>\n\
</table>"
  DEFAULT_PRIORITY = "50"