[Home] [Help]
PACKAGE: APPS.WF_EVENT_SYNCHRONIZE_PKG
Source
1 package WF_EVENT_SYNCHRONIZE_PKG as
2 /* $Header: WFEVSYNS.pls 120.1 2005/07/02 03:14:55 appldev ship $ */
3 ------------------------------------------------------------------------------
4 function SYNCHRONIZE (
5 P_SUBSCRIPTION_GUID in raw,
6 P_EVENT in out nocopy wf_event_t
7 ) return varchar2;
8 ------------------------------------------------------------------------------
9 function SYNCHRONIZEUPLOAD (
10 P_SUBSCRIPTION_GUID in raw,
11 P_EVENT in out nocopy wf_event_t
12 ) return varchar2;
13 ------------------------------------------------------------------------------
14 procedure CREATESYNCCLOB (
15 P_OBJECTTYPE in varchar2 DEFAULT NULL,
16 P_OBJECTKEY in varchar2 DEFAULT NULL,
17 P_ISEXACTNUM in integer DEFAULT 1,
18 P_OWNERTAG in varchar2 DEFAULT NULL,
19 P_EVENTDATA out nocopy clob
20 );
21 ------------------------------------------------------------------------------
22 procedure CREATEFILE (
23 P_DIRECTORY in varchar2,
24 P_FILENAME in varchar2,
25 P_OBJECTTYPE in varchar2 DEFAULT NULL,
26 P_OBJECTKEY in varchar2 DEFAULT NULL,
27 P_ISEXACT in boolean DEFAULT TRUE
28 );
29 ------------------------------------------------------------------------------
30 procedure CREATECLOBFILE (
31 P_DIRECTORY in varchar2,
32 P_FILENAME in varchar2,
33 P_CLOB in clob
34 );
35 ------------------------------------------------------------------------------
36 procedure UPLOADFILE (
37 P_DIRECTORY in varchar2,
38 P_FILENAME in varchar2
39 );
40 ------------------------------------------------------------------------------
41 procedure UPLOADSYNCCLOB (
42 P_EVENTDATA in clob
43 );
44 ------------------------------------------------------------------------------
45 function GETSYSTEMS (
46 P_KEY in varchar2 DEFAULT NULL
47 ) return clob;
48 ------------------------------------------------------------------------------
49 function GETAGENTS (
50 P_KEY in varchar2 DEFAULT NULL,
51 P_ISEXACT in boolean DEFAULT FALSE
52 ) return clob;
53 ------------------------------------------------------------------------------
54 function GETAGENTGROUPS (
55 P_KEY in varchar2 DEFAULT NULL
56 ) return clob;
57 /*
58 ------------------------------------------------------------------------------
59 function GETEVENTS (
60 P_KEY in varchar2 DEFAULT NULL
61 ) return clob;
62 ------------------------------------------------------------------------------
63 */
64 function GETEVENTS (
65 P_KEY in varchar2 DEFAULT NULL,
66 P_OWNERTAG in varchar2 DEFAULT NULL
67 ) return clob;
68 /*
69 ------------------------------------------------------------------------------
70 function GETEVENTGROUPS (
71 P_KEY in varchar2 DEFAULT NULL
72 ) return clob;
73 ------------------------------------------------------------------------------
74 */
75 function GETEVENTGROUPS (
76 P_KEY in varchar2,
77 P_OWNERTAG in varchar2 DEFAULT NULL
78 ) return clob;
79 ------------------------------------------------------------------------------
80 function GETGROUPS (
81 P_KEY in varchar2,
82 P_OWNERTAG in varchar2 DEFAULT NULL
83 ) return clob;
84 ------------------------------------------------------------------------------
85 function GETEVENTGROUPBYGROUP (
86 P_KEY in varchar2,
87 P_OWNERTAG in varchar2 DEFAULT NULL
88 ) return clob;
89 /*
90 ------------------------------------------------------------------------------
91 function GETSUBSCRIPTIONS (
92 P_KEY in varchar2 DEFAULT NULL,
93 P_ISEXACT in boolean DEFAULT FALSE
94 ) return clob;
95 ------------------------------------------------------------------------------
96 */
97 function GETSUBSCRIPTIONS (
98 P_KEY in varchar2 DEFAULT NULL,
99 P_ISEXACT in boolean DEFAULT FALSE,
100 P_OWNERTAG in varchar2 DEFAULT NULL
101 ) return clob;
102 ------------------------------------------------------------------------------
103 function GETOBJECTTYPE(
104 P_MESSAGEDATA in varchar2
105 ) return varchar2;
106 ------------------------------------------------------------------------------
107 procedure UploadObject(
108 P_OBJECTTYPE in varchar2,
109 P_MESSAGEDATA in varchar2,
110 P_ERROR out nocopy varchar2
111 );
112 ------------------------------------------------------------------------------
113 procedure UpdateGUID (
114 g_guid in varchar2 default null
115 );
116 ------------------------------------------------------------------------------
117 function ReplaceContent (
118 begTag in varchar2 default null,
119 endTag in varchar2 default null,
120 replaceTarget in varchar2 default null,
121 newData in varchar2 default null,
122 dataStr in varchar2 default null
123 ) return varchar2;
124 ------------------------------------------------------------------------------
125 function SetGUID (
126 dataStr in varchar2 default null
127 ) return varchar2;
128 ------------------------------------------------------------------------------
129 function SetSYSTEMGUID (
130 dataStr in varchar2 default null
131 ) return varchar2;
132 ------------------------------------------------------------------------------
133 function GetSID return varchar2;
134 ------------------------------------------------------------------------------
135 function GetQOwner return varchar2;
136 ------------------------------------------------------------------------------
137 function SetSID (
138 dataStr in varchar2 default null
139 ) return varchar2;
140 ------------------------------------------------------------------------------
141 function SetAgent (
142 dataStr in varchar2 default null
143 ) return varchar2;
144 ------------------------------------------------------------------------------
145 function SetPound (
146 startPos in number default 0,
147 dataStr in varchar2 default null,
148 begTag in varchar2 default null,
149 endTag in varchar2 default null,
150 pound in varchar2 default null,
151 matchStr in varchar2 default null
152 ) return varchar2;
153 ------------------------------------------------------------------------------
154 function SetNull (
155 startPos in number default 0,
156 dataStr in varchar2 default null,
157 tag in varchar2 default null
158 ) return varchar2;
159 ------------------------------------------------------------------------------
160 procedure CREATEEMPTYCLOB (
161 P_OUTCLOB out nocopy clob
162 );
163 ------------------------------------------------------------------------------
164 function GetAgent (
165 begTag in varchar2,
166 endTag in varchar2,
167 dataStr in varchar2
168 ) return varchar2 ;
169 ------------------------------------------------------------------------------
170 function SetAgent2 (
171 begTag in varchar2,
172 endTag in varchar2,
173 dataStr in varchar2
174 ) return varchar2;
175 ------------------------------------------------------------------------------
176 procedure CREATESYNCCLOB2 (
177 P_OBJECTTYPE in varchar2 DEFAULT NULL,
178 P_OBJECTKEY in varchar2 DEFAULT NULL,
179 P_ISEXACTNUM in integer DEFAULT 1,
180 P_OWNERTAG in varchar2 DEFAULT NULL,
181 P_EVENTDATA out nocopy clob,
182 P_ERROR_CODE out nocopy varchar2,
183 P_ERROR_MSG out nocopy varchar2
184 );
185 ------------------------------------------------------------------------------
186
187 end WF_EVENT_SYNCHRONIZE_PKG;