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