1 package ZPB_WF AS
2 /* $Header: zpbwrkfl.pls 120.0.12010.4 2006/08/03 18:51:03 appldev noship $ */
3
4 procedure ACStart(ACID in number, PublishedBefore in varchar2, isEvent in varchar2 default 'N');
5 --
6 --
7 procedure RunNextTask (itemtype in varchar2,
8 itemkey in varchar2,
9 actid in number,
10 funcmode in varchar2,
11 resultout out nocopy varchar2);
12 --
13 --
14 procedure RunLoad (itemtype in varchar2,
15 itemkey in varchar2,
16 actid in number,
17 funcmode in varchar2,
18 resultout out nocopy varchar2);
19 --
20 --
21 procedure Selector(itemtype in varchar2,
22 itemkey in varchar2,
23 actid in number,
24 command in varchar2,
25 resultout out nocopy varchar2);
26
27 --
28 --
29 procedure WFbkgMgr (errbuf out nocopy varchar2,
30 retcode out nocopy number,
31 itemtype in varchar2,
32 itemkey in varchar2);
33
34 --
35 --
36 procedure STARTPRCMGR (errbuf out nocopy varchar2,
37 retcode out nocopy number,
38 TGT_ITEMTYPE in varchar2,
39 TGT_ITEMKEY in varchar2);
40 --
41 --
42 procedure DeleteWorkflow (errbuf out nocopy varchar2,
43 retcode out nocopy varchar2,
44 inACID in Number,
45 ACIDType in varchar2 default 'I');
46 --
47 --
48 Procedure CallDelWF(inACID in number,
49 ACIDType in varchar2 default 'I');
50
51 --
52 --
53 procedure MakeInstance (errbuf out nocopy varchar2,
54 retcode out nocopy varchar2,
55 ItemKey in varchar2,
56 ACID in Number,
57 P_BUSINESS_AREA_ID in Number);
58 --
59 --
60 procedure MarkforDelete (ACID in Number,
61 ownerID in number,
62 respID in number,
63 RespAppID in number);
64
65 --
66 --
67 procedure FrequencyInit (itemtype in varchar2,
68 itemkey in varchar2,
69 actid in number,
70 funcmode in varchar2,
71 resultout out nocopy varchar2);
72 --
73 --
74 procedure FrequencyMgr (itemtype in varchar2,
75 itemkey in varchar2,
76 actid in number,
77 funcmode in varchar2,
78 resultout out nocopy varchar2);
79 --
80 --
81 procedure SetCompDate (itemtype in varchar2,
82 itemkey in varchar2,
83 actid in number,
84 funcmode in varchar2,
85 resultout out nocopy varchar2);
86
87 procedure PAUSE_INSTANCE (InstanceID in number);
88 --
89 -- A. BUDNIK 07/17/2003 Added PResumeType
90 procedure RESUME_INSTANCE (InstanceID in number,
91 PResumeType varchar2 default 'NORMAL');
92 --
93 --
94 -- abudnik 17NOV2005 BUSINESS AREA ID.
95 procedure Concurrent_Wrapper (errbuf out nocopy varchar2,
96 retcode out nocopy varchar2,
97 ACID in Number,
98 TaskID in Number,
99 DataAW in Varchar2,
100 CodeAW in Varchar2,
101 AnnoAW in Varchar2,
102 P_BUSINESS_AREA_ID in Number);
103 --
104 --
105 procedure SET_CURRINST (itemtype in varchar2,
106 itemkey in varchar2,
107 actid in number,
108 funcmode in varchar2,
109 resultout out nocopy varchar2);
110 --
111 --
112 function GetEventACID(taskID in number) return varchar2;
113 --
114 --
115 procedure PREP_EVENT_ACID (itemtype in varchar2,
116 itemkey in varchar2,
117 actid in number,
118 funcmode in varchar2,
119 resultout out nocopy varchar2);
120 --
121 --
122 procedure ENABLE_CYCLE(Pacid in number, PStatus in varchar2);
123 --
124 --
125 procedure INIT_BUSINESS_PROCESS (ACID in Number,
126 InstanceID in Number,
127 TaskID in Number,
128 UserID in Number);
129 --
130 --
131 -- abudnik 17NOV2005 BUSINESS AREA ID
132 procedure RUN_SOLVE (errbuf out nocopy varchar2,
133 retcode out nocopy varchar2,
134 InstanceID in Number,
135 TaskID in Number,
136 UserID in Number,
137 P_BUSINESS_AREA_ID in number);
138 --
139 --
140 procedure UPDATE_STATUS (p_type in varchar2,
141 p_InstanceID in Number default NULL,
142 p_TaskID in Number default NULL,
143 p_UserID in Number default NULL);
144
145 --
146 -- Kicks off a CM to submit data up to the shared
147 --
148 procedure SUBMIT_TO_SHARED (p_user in number,
149 p_templateID in number,
150 p_retVal out nocopy number);
151
152
153 procedure INIT_PROC_RUN_DATA (ACID in Number,
154 InstanceID in Number,
155 TaskID in Number,
156 UserID in Number);
157 --
158 -- runs cm.delshints to remove AW instances.
159 --
160 -- abudnik 17NOV2005 BUSINESS AREA ID
161 procedure WF_DELAWINST (errbuf out nocopy varchar2,
162 retcode out nocopy varchar2,
163 InstanceID in Number,
164 UserID in Number,
165 P_BUSINESS_AREA_ID in Number);
166 --
167 -- calls abprtWorkflow
168 --
169 Procedure CallWFAbort(inACID in number);
170
171 --
172 -- aborts WF scheduler for ACID Can be updated to abort others
173 --
174
175 procedure AbortWorkflow (errbuf out nocopy varchar2,
176 retcode out nocopy varchar2,
177 inACID in Number,
178 ACIDType in varchar2 default 'A');
179
180 --
181 -- If BP has no active instances and no completed instances, deletes CurrentInstance measure from AW
182 -- If BP has no active instances and some completed instances, resets CurrentInstance measure to last started instance
183 -- If BP has active instances does nothing
184 --
185 procedure DeleteCurrInstMeas (ACId in number,
186 ownerId in number);
187
188 -- This procedure is called by a CM program. For instance P_InstanceId of BP P_ACId
189 -- it first deletes the AW measure associted with the instance, it then recreates and
190 -- initializes the AW measure. Used when enabling BPs ENABLE_FIRST
191
192 -- abudnik 17NOV2005 BUSINESS AREA ID
193 procedure CleanAndRestartInst (errbuf out nocopy varchar2,
194 retcode out nocopy varchar2,
195 P_ACId in number,
196 P_InstanceId in number,
197 P_BUSINESS_AREA_ID in number);
198
199 procedure RUN_MIGRATE_INST (p_InstanceID in NUMBER,
200 p_api_version IN NUMBER,
201 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
202 p_commit IN VARCHAR2 := FND_API.G_TRUE,
203 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
204 x_return_status OUT nocopy varchar2,
205 x_msg_count OUT nocopy number,
206 x_msg_data OUT nocopy varchar2);
207
208 procedure REVIEW_NOTIF_RESPONSE(itemtype in varchar2,
209 itemkey in varchar2,
210 actid in number,
211 funcmode in varchar2,
212 resultout out NOCOPY varchar2);
213
214
215 -- A. Budnik 04/26/2006 b 3126256
216 procedure SUBMIT_CONC_REQUEST (itemtype in varchar2,
217 itemkey in varchar2,
218 actid in number,
219 funcmode in varchar2,
220 resultout out nocopy varchar2);
221
222 end ZPB_WF;