1 package OKC_ASYNC_PVT AUTHID CURRENT_USER as
2 /* $Header: OKCRASNS.pls 120.3.12020000.2 2012/07/16 16:15:03 harchand ship $ */
3
4 G_WF_NAME varchar2(100);
5 G_PROCESS_NAME varchar2(100);
6
7 /*bugfix for 13079117*/
8 G_USER_ID NUMBER DEFAULT NULL;
9
10 TYPE par_rec_typ IS RECORD (
11 par_type varchar2(1),
12 par_name varchar2(100),
13 par_value varchar2(32000)
14 );
15 TYPE par_tbl_typ IS TABLE OF par_rec_typ
16 INDEX BY BINARY_INTEGER;
17 --
18 -- wf start API (Branch 2)
19 --
20 procedure wf_call(
21 --
22 -- common API parameters
23 --
24 p_api_version IN NUMBER,
25 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
26 x_return_status OUT NOCOPY VARCHAR2,
27 x_msg_count OUT NOCOPY NUMBER,
28 x_msg_data OUT NOCOPY VARCHAR2,
29 --
30 -- params for dynamic proc call
31 --
32 p_proc IN VARCHAR2 default NULL, -- plsql with one bind for in out x_return_status
33 p_subj_first_msg IN VARCHAR2 default OKC_API.G_TRUE, -- G_FALSE usefull when API errors
34 --
35 -- notification params
36 --
37 p_ntf_type IN VARCHAR2 default NULL, -- hidden attr for generic notification
38 p_e_recipient IN VARCHAR2 default NULL, -- performer on both on E and U
39 p_s_recipient IN VARCHAR2 default NULL, -- performer on S
40 --
41 -- extra wf params (wf attr. / other than 3 previous - i.e. CONTRACT_ID)
42 --
43 p_wf_par_tbl IN par_tbl_typ
44 );
45
46
47 --
48 -- wf start API (Branch 3)
49 --
50 procedure resolver_call(
51 --
52 -- common API parameters
53 --
54 p_api_version IN NUMBER,
55 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
56 x_return_status OUT NOCOPY VARCHAR2,
57 x_msg_count OUT NOCOPY NUMBER,
58 x_msg_data OUT NOCOPY VARCHAR2,
59 --
60 -- wf attributes
61 --
62 p_resolver IN VARCHAR2,
63 p_msg_subj_resolver IN VARCHAR2,
64 p_msg_body_resolver IN VARCHAR2,
65 p_note IN VARCHAR2 default NULL,-- usually null
66 p_accept_proc IN VARCHAR2,
67 p_reject_proc IN VARCHAR2,
68 p_timeout_proc IN VARCHAR2 default NULL,--if null p_reject_proc used instead
69 p_timeout_minutes IN NUMBER default 144000,--100 days default to force wf end
70 --
71 -- hidden notification attributes
72 --
73 p_ntf_type IN VARCHAR2 default NULL,
74 p_contract_id IN NUMBER default NULL,
75 p_task_id IN NUMBER default NULL,
76 p_extra_attr_num IN NUMBER default NULL,
77 p_extra_attr_text IN VARCHAR2 default NULL,
78 p_extra_attr_date IN DATE default NULL
79 );
80
81 --
82 -- Selector sets environment for version > 1
83 --
84 procedure Selector ( item_type in varchar2,
85 item_key in varchar2,
86 activity_id in number,
87 command in varchar2,
88 resultout out nocopy varchar2 );
89 --
90 -- get_version returns '1' for previous wf branch, '2' for new
91 --
92 procedure get_version( itemtype in varchar2,
93 itemkey in varchar2,
94 actid in number,
95 funcmode in varchar2,
96 resultout out nocopy varchar2);
97
98 --
99 -- fun_generic executes dynamic plsql and
100 -- returns 'S' if success and is wfo to notify about it
101 -- returns 'E' if error and is wfo to notify about it
102 -- returns 'X' if noone to be notified
103 --
104 procedure fun_generic( itemtype in varchar2,
105 itemkey in varchar2,
106 actid in number,
107 funcmode in varchar2,
108 resultout out nocopy varchar2);
109
110 --
111 -- accept
112 --
113 procedure accept( itemtype in varchar2,
114 itemkey in varchar2,
115 actid in number,
116 funcmode in varchar2,
117 resultout out nocopy varchar2);
118 --
119 -- reject
120 --
121 procedure reject( itemtype in varchar2,
122 itemkey in varchar2,
123 actid in number,
124 funcmode in varchar2,
125 resultout out nocopy varchar2);
126 --
127 -- timeout
128 --
129 procedure timeout( itemtype in varchar2,
130 itemkey in varchar2,
131 actid in number,
132 funcmode in varchar2,
133 resultout out nocopy varchar2);
134 --
135 -- periodic returns 'T'/'F'
136 --
137 procedure periodic( itemtype in varchar2,
138 itemkey in varchar2,
139 actid in number,
140 funcmode in varchar2,
141 resultout out nocopy varchar2 );
142
143 --
144 -- periodic returns 'T'/'F'
145 --
146 procedure time_over( itemtype in varchar2,
147 itemkey in varchar2,
148 actid in number,
149 funcmode in varchar2,
150 resultout out nocopy varchar2 );
151
152 --
153 -- calls p_doc_proc with types 'text/plain'
154 --
155 procedure get_doc(document_id in varchar2,
156 display_type in varchar2,
157 document in out nocopy CLOB,
158 document_type in out nocopy varchar2);
159
160 procedure loop_call(
161 --
162 -- common API parameters
163 --
164 p_api_version IN NUMBER,
165 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
166 x_return_status OUT NOCOPY VARCHAR2,
167 x_msg_count OUT NOCOPY NUMBER,
168 x_msg_data OUT NOCOPY VARCHAR2,
169 --
170 -- specific parameters
171 --
172 p_proc IN VARCHAR2,
173 --NPALEPU
174 --14-DEC-2005
175 --Added new parameter P_PROC_NAME for bug # 4699009.
176 p_proc_name IN VARCHAR2 DEFAULT NULL,
177 --END NPALEPU
178 p_s_recipient IN VARCHAR2 default NULL, -- normal recipient
179 p_e_recipient IN VARCHAR2 default NULL, -- error recipient
180 p_timeout_minutes IN NUMBER default NULL,
181 p_loops IN NUMBER default 0,--limit for loopbacks
182 p_subj_first_msg IN VARCHAR2 default 'T', -- 'F' for last fnd_msg as msg subject
183 --
184 -- hidden notification attributes
185 --
186 p_ntf_type IN VARCHAR2 default NULL,
187 p_contract_id IN NUMBER default NULL,
188 p_task_id IN NUMBER default NULL,
189 p_extra_attr_num IN NUMBER default NULL,
190 p_extra_attr_text IN VARCHAR2 default NULL,
191 p_extra_attr_date IN DATE default NULL
192 );
193
194 -- Start of comments
195 --
196 -- Procedure Name : No_Email
197 -- Description :
198 -- Business Rules :
199 -- Parameters :
200 -- Post_Approval : 1.0
201 -- End of comments
202
203 procedure No_Email( itemtype in varchar2,
204 itemkey in varchar2,
205 actid in number,
206 funcmode in varchar2,
207 resultout out nocopy varchar2 );
208
209 procedure success_mute( itemtype in varchar2,
210 itemkey in varchar2,
211 actid in number,
212 funcmode in varchar2,
213 resultout out nocopy varchar2 );
214
215 procedure error_mute( itemtype in varchar2,
216 itemkey in varchar2,
217 actid in number,
218 funcmode in varchar2,
219 resultout out nocopy varchar2 );
220
221 procedure fyi_mute( itemtype in varchar2,
222 itemkey in varchar2,
223 actid in number,
224 funcmode in varchar2,
225 resultout out nocopy varchar2 );
226
227 procedure mute_nxt_pfmr( itemtype in varchar2,
228 itemkey in varchar2,
229 actid in number,
230 funcmode in varchar2,
231 resultout out nocopy varchar2 );
232
233 procedure mute_k_admin( itemtype in varchar2,
234 itemkey in varchar2,
235 actid in number,
236 funcmode in varchar2,
237 resultout out nocopy varchar2 );
238
239 procedure mute_signer( itemtype in varchar2,
240 itemkey in varchar2,
241 actid in number,
242 funcmode in varchar2,
243 resultout out nocopy varchar2 );
244
245 procedure unmute(itemtype in varchar2,
246 itemkey in varchar2,
247 actid in number,
248 funcmode in varchar2,
249 resultout out nocopy varchar2 );
250
251 end OKC_ASYNC_PVT;