Created
February 8, 2019 10:44
-
-
Save mentiflectax/97ab8a3e8fb0e15cfc3403b2a24ca766 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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 = "GERMAN" | |
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 "S1" | |
PROTECT_LEVEL = "100" | |
CUSTOM_LEVEL = "100" | |
DISPLAY_NAME = "Minimal workflow" | |
PERSISTENCE_TYPE = "TEMP" | |
PERSISTENCE_DAYS = "0" | |
END ITEM_TYPE | |
# BEGIN ACTIVITY is relevant (incl. values "S1" and "P1") | |
BEGIN ACTIVITY "S1" "P1" | |
# All assignments (incl. TYPE, ICON_NAME, ERROR_ITEM_TYPE, RUNNABLE etc.) are relevant | |
PROTECT_LEVEL = "100" | |
CUSTOM_LEVEL = "100" | |
DISPLAY_NAME = "P1" | |
TYPE = "PROCESS" | |
RESULT_TYPE = "*" | |
RERUN = "RESET" | |
COST = "0" | |
ICON_NAME = "PROCESS.ICO" | |
ERROR_ITEM_TYPE = "WFERROR" | |
RUNNABLE = "Y" | |
# BEGIN PROCESS_ACTIVITY "F1" is relevant | |
BEGIN PROCESS_ACTIVITY "F1" | |
# Again, all assignments inside "F1" are relevant | |
ACTIVITY_ITEM_TYPE = "S1" | |
ACTIVITY_NAME = "F1" | |
ICON_GEOMETRY = "-736,-240" | |
VALUE_TYPE = "CONSTANT" | |
# BEGIN ACTIVITY_TRANSITION is relevant (must include data, i. e. "*" and "F2") | |
BEGIN ACTIVITY_TRANSITION "*" "F2" | |
ARROW_GEOMETRY = "1;0;0;0;0.500000;-736,-240:-336,-240:" | |
END ACTIVITY_TRANSITION | |
END PROCESS_ACTIVITY | |
# BEGIN PROCESS_ACTIVITY is relevant (must include data, i. e. "F2") | |
BEGIN PROCESS_ACTIVITY "F2" | |
# Again, all assignments inside "F2" are relevant | |
ACTIVITY_ITEM_TYPE = "S1" | |
ACTIVITY_NAME = "F2" | |
ICON_GEOMETRY = "-336,-240" | |
VALUE_TYPE = "CONSTANT" | |
END PROCESS_ACTIVITY | |
# END ACTIVITY is relevant | |
END ACTIVITY | |
# Everything between the tokens 'BEGIN ACTIVITY' and 'END ACTIVITY' is relevant (incl. "S1" and "F1" in the first line) | |
BEGIN ACTIVITY "S1" "F1" | |
PROTECT_LEVEL = "100" | |
CUSTOM_LEVEL = "100" | |
DISPLAY_NAME = "F1" | |
TYPE = "FUNCTION" | |
FUNCTION = "functionName.sql" | |
RESULT_TYPE = "*" | |
RERUN = "RESET" | |
COST = "0" | |
ICON_NAME = "FUNCTION.ICO" | |
ERROR_ITEM_TYPE = "WFERROR" | |
RUNNABLE = "Y" | |
END ACTIVITY | |
# Everything between the tokens 'BEGIN ACTIVITY' and 'END ACTIVITY' is relevant (incl. "S1" and "F2" in the first line) | |
BEGIN ACTIVITY "S1" "F2" | |
PROTECT_LEVEL = "100" | |
CUSTOM_LEVEL = "100" | |
DISPLAY_NAME = "F2" | |
TYPE = "FUNCTION" | |
FUNCTION_TYPE = "EXTERNAL" | |
RESULT_TYPE = "*" | |
RERUN = "RESET" | |
COST = "0" | |
ICON_NAME = "FUNCTION.ICO" | |
ERROR_ITEM_TYPE = "WFERROR" | |
RUNNABLE = "Y" | |
END ACTIVITY | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment