1 package WF_EVENT_SUBSCRIPTIONS_PKG as
2 /* $Header: WFEVSUBS.pls 120.1 2005/07/02 03:14:46 appldev ship $ */
3 /*#
4 * Provides APIs to communicate event subscription definitions to and
5 * from the WF_EVENT_SUBSCRIPTIONS table.
6 * @rep:scope public
7 * @rep:product OWF
8 * @rep:displayname Workflow Event Subscription
9 * @rep:lifecycle active
10 * @rep:compatibility S
11 * @rep:category BUSINESS_ENTITY WF_EVENT
12 * @rep:ihelp FND/@besrepapis See the related online help
13 */
14
15 -----------------------------------------------------------------------------
16 procedure INSERT_ROW (
17 X_ROWID in out nocopy varchar2,
18 X_GUID in raw,
19 X_SYSTEM_GUID in raw,
20 X_SOURCE_TYPE in varchar2,
21 X_SOURCE_AGENT_GUID in raw,
22 X_EVENT_FILTER_GUID in raw,
23 X_PHASE in number,
24 X_STATUS in varchar2,
25 X_RULE_DATA in varchar2,
26 X_OUT_AGENT_GUID in raw,
27 X_TO_AGENT_GUID in raw,
28 X_PRIORITY in number,
29 X_RULE_FUNCTION in varchar2,
30 X_WF_PROCESS_TYPE in varchar2,
31 X_WF_PROCESS_NAME in varchar2,
32 X_PARAMETERS in varchar2,
33 X_OWNER_NAME in varchar2,
34 X_OWNER_TAG in varchar2,
35 X_CUSTOMIZATION_LEVEL in varchar2,
36 X_LICENSED_FLAG in varchar2 default 'N',
37 X_DESCRIPTION in varchar2,
38 X_EXPRESSION in varchar2 default null,
39 X_ACTION_CODE in varchar2 default null,
40 X_ON_ERROR_CODE in varchar2 default 'ABORT',
41 X_JAVA_RULE_FUNC in varchar2 default null,
42 X_MAP_CODE in varchar2 default null,
43 X_STANDARD_CODE in varchar2 default null,
44 X_STANDARD_TYPE in varchar2 default null
45 );
46 -----------------------------------------------------------------------------
47 procedure UPDATE_ROW (
48 X_GUID in raw,
49 X_SYSTEM_GUID in raw,
50 X_SOURCE_TYPE in varchar2,
51 X_SOURCE_AGENT_GUID in raw,
52 X_EVENT_FILTER_GUID in raw,
53 X_PHASE in number,
54 X_STATUS in varchar2,
55 X_RULE_DATA in varchar2,
56 X_OUT_AGENT_GUID in raw,
57 X_TO_AGENT_GUID in raw,
58 X_PRIORITY in number,
59 X_RULE_FUNCTION in varchar2,
60 X_WF_PROCESS_TYPE in varchar2,
61 X_WF_PROCESS_NAME in varchar2,
62 X_PARAMETERS in varchar2,
63 X_OWNER_NAME in varchar2,
64 X_OWNER_TAG in varchar2,
65 X_CUSTOMIZATION_LEVEL in varchar2,
66 X_LICENSED_FLAG in varchar2 default 'N',
67 X_DESCRIPTION in varchar2,
68 X_EXPRESSION in varchar2 default null,
69 X_ACTION_CODE in varchar2 default null,
70 X_ON_ERROR_CODE in varchar2 default 'ABORT',
71 X_JAVA_RULE_FUNC in varchar2 default null,
72 X_MAP_CODE in varchar2 default null,
73 X_STANDARD_CODE in varchar2 default null,
74 X_STANDARD_TYPE in varchar2 default null
75 );
76 -----------------------------------------------------------------------------
77 procedure LOAD_ROW (
78 X_GUID in raw,
79 X_SYSTEM_GUID in raw,
80 X_SOURCE_TYPE in varchar2,
81 X_SOURCE_AGENT_GUID in raw,
82 X_EVENT_FILTER_GUID in raw,
83 X_PHASE in number,
84 X_STATUS in varchar2,
85 X_RULE_DATA in varchar2,
86 X_OUT_AGENT_GUID in raw,
87 X_TO_AGENT_GUID in raw,
88 X_PRIORITY in number,
89 X_RULE_FUNCTION in varchar2,
90 X_WF_PROCESS_TYPE in varchar2,
91 X_WF_PROCESS_NAME in varchar2,
92 X_PARAMETERS in varchar2,
93 X_OWNER_NAME in varchar2,
94 X_OWNER_TAG in varchar2,
95 X_CUSTOMIZATION_LEVEL in varchar2,
96 X_LICENSED_FLAG in varchar2 default 'N',
97 X_DESCRIPTION in varchar2,
98 X_EXPRESSION in varchar2 default null,
99 X_ACTION_CODE in varchar2 default null,
100 X_ON_ERROR_CODE in varchar2 default 'ABORT',
101 X_JAVA_RULE_FUNC in varchar2 default null,
102 X_MAP_CODE in varchar2 default null,
103 X_STANDARD_CODE in varchar2 default null,
104 X_STANDARD_TYPE in varchar2 default null
105 );
106 -----------------------------------------------------------------------------
107 procedure DELETE_ROW (
108 X_GUID in raw
109 );
110 -----------------------------------------------------------------------------
111 procedure DELETE_SET (
112 X_SYSTEM_GUID in raw default null,
113 X_SOURCE_TYPE in varchar2 default null,
114 X_SOURCE_AGENT_GUID in raw default null,
115 X_EVENT_FILTER_GUID in raw default null,
116 X_PHASE in number default null,
117 X_STATUS in varchar2 default null,
118 X_RULE_DATA in varchar2 default null,
119 X_OUT_AGENT_GUID in raw default null,
120 X_TO_AGENT_GUID in raw default null,
121 X_PRIORITY in number default null,
122 X_RULE_FUNCTION in varchar2 default null,
123 X_WF_PROCESS_TYPE in varchar2 default null,
124 X_WF_PROCESS_NAME in varchar2 default null,
125 X_PARAMETERS in varchar2 default null,
126 X_OWNER_NAME in varchar2 default null,
127 X_OWNER_TAG in varchar2 default null,
128 X_DESCRIPTION in varchar2 default null,
129 X_EXPRESSION in varchar2 default null,
130 X_ACTION_CODE in varchar2 default null,
131 X_ON_ERROR_CODE in varchar2 default 'ABORT',
132 X_JAVA_RULE_FUNC in varchar2 default null,
133 X_MAP_CODE in varchar2 default null,
134 X_STANDARD_CODE in varchar2 default null,
135 X_STANDARD_TYPE in varchar2 default null
136 );
137 -----------------------------------------------------------------------------
138 /*#
139 * Generates an XML message containing the complete information from the
140 * WF_EVENT_SUBSCRIPTIONS table for the specified event subscription definition.
141 * @param x_guid Event Subscription GUID
142 * @return Event Subscription XML Message
143 * @rep:scope public
144 * @rep:lifecycle active
145 * @rep:displayname Generate Event Subscription Message
146 * @rep:compatibility S
147 * @rep:ihelp FND/@besrepapis#a_evsubgen See the related online help
148 */
149 function GENERATE (
150 X_GUID in raw
151 ) return varchar2;
152 -----------------------------------------------------------------------------
153 /*#
154 * Receives an XML message containing the complete information for an event
155 * subscription definition and loads the information into the
156 * WF_EVENT_SUBSCRIPTIONS table.
157 * @param x_message Event Subscription XML Message
158 * @rep:scope public
159 * @rep:lifecycle active
160 * @rep:displayname Receive Event Subscription Message
161 * @rep:compatibility S
162 * @rep:ihelp FND/@besrepapis#a_evsubrec See the related online help
163 */
164 procedure RECEIVE (
165 X_MESSAGE in varchar2
166 );
167 -----------------------------------------------------------------------------
168 end WF_EVENT_SUBSCRIPTIONS_PKG;