1 package WF_EVENTS_PKG as
2 /* $Header: WFEVEVTS.pls 120.2 2008/01/10 19:29:23 vshanmug ship $ */
3 /*#
4 * Provides APIs to communicate event definitions to and from the
5 * WF_EVENTS table.
6 * @rep:scope public
7 * @rep:product OWF
8 * @rep:displayname Workflow Event
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 g_seeduser varchar2(320) := 'DATAMERGE';
16 g_Mode varchar2(8) := null;
17
18 procedure setMode;
19
20 procedure FWKsetMode;
21
22 procedure LoadersetMode(x_mode in varchar2);
23
24 function is_product_licensed( X_OWNER_TAG in varchar2)
25 return varchar2;
26
27 function is_update_allowed(X_CUSTOM_LEVEL_NEW in varchar2,
28 X_CUSTOM_LEVEL_OLD in varchar2) return varchar2;
29
30 procedure INSERT_ROW (
31 X_ROWID in out nocopy varchar2,
32 X_GUID in raw,
33 X_NAME in varchar2,
34 X_TYPE in varchar2,
35 X_STATUS in varchar2,
36 X_GENERATE_FUNCTION in varchar2,
37 X_OWNER_NAME in varchar2,
38 X_OWNER_TAG in varchar2,
39 X_DISPLAY_NAME in varchar2,
40 X_DESCRIPTION in varchar2,
41 X_CUSTOMIZATION_LEVEL in varchar2 default 'L',
42 X_LICENSED_FLAG in varchar2 default 'Y',
43 X_JAVA_GENERATE_FUNC in varchar2 default null,
44 X_IREP_ANNOTATION in varchar2 default null
45 );
46 -----------------------------------------------------------------------------
47 procedure UPDATE_ROW (
48 X_GUID in raw,
49 X_NAME in varchar2,
50 X_TYPE in varchar2,
51 X_STATUS in varchar2,
52 X_GENERATE_FUNCTION in varchar2,
53 X_OWNER_NAME in varchar2,
54 X_OWNER_TAG in varchar2,
55 X_DISPLAY_NAME in varchar2,
56 X_DESCRIPTION in varchar2,
57 X_CUSTOMIZATION_LEVEL in varchar2 default 'L',
58 X_LICENSED_FLAG in varchar2 default 'Y',
59 X_JAVA_GENERATE_FUNC in varchar2 default null,
60 X_IREP_ANNOTATION in varchar2 default null
61 );
62 -----------------------------------------------------------------------------
63 procedure DELETE_ROW (
64 X_GUID in raw
65 );
66 -----------------------------------------------------------------------------
67 procedure LOAD_ROW (
68 X_GUID in raw,
69 X_NAME in varchar2,
70 X_TYPE in varchar2,
71 X_STATUS in varchar2,
72 X_GENERATE_FUNCTION in varchar2,
73 X_OWNER_NAME in varchar2,
74 X_OWNER_TAG in varchar2,
75 X_DISPLAY_NAME in varchar2,
76 X_DESCRIPTION in varchar2,
77 X_CUSTOMIZATION_LEVEL in varchar2 default 'L',
78 X_LICENSED_FLAG in varchar2 default 'Y',
79 X_JAVA_GENERATE_FUNC in varchar2 default null,
80 X_IREP_ANNOTATION in varchar2 default null
81 );
82 -----------------------------------------------------------------------------
83 procedure ADD_LANGUAGE;
84 -----------------------------------------------------------------------------
85 /*#
86 * Generates an XML message containing the complete information from the
87 * WF_EVENTS table for the specified event definition.
88 * @param x_guid Event GUID
89 * @return Event XML Message
90 * @rep:scope public
91 * @rep:lifecycle active
92 * @rep:displayname Generate Event Message
93 * @rep:compatibility S
94 * @rep:ihelp FND/@besrepapis#a_evtgen See the related online help
95 */
96 function GENERATE (
97 X_GUID in raw
98 ) return varchar2;
99 -----------------------------------------------------------------------------
100 /*#
101 * Receives an XML message containing the complete information for an event
102 * definition and loads the information into the WF_EVENTS table.
103 * @param x_message Event XML Message
104 * @rep:scope public
105 * @rep:lifecycle active
106 * @rep:displayname Receive Event Message
107 * @rep:compatibility S
108 * @rep:ihelp FND/@besrepapis#a_evtrec See the related online help
109 */
110 procedure RECEIVE (
111 X_MESSAGE in varchar2
112 );
113 -----------------------------------------------------------------------------
114 end WF_EVENTS_PKG;