1 PACKAGE ARP_CMREQ_WF AS
2 /* $Header: ARWCMWFS.pls 120.3.12010000.2 2008/09/01 09:59:34 naneja ship $ */
3 -- <describe the activity here>
4 --
5 -- IN
6 -- itemtype - type of the current item
7 -- itemkey - key of the current item
8 -- actid - process activity instance id
9 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
10 -- OUT NOCOPY
11 -- result
12 -- - COMPLETE[:<result>]
13 -- activity has completed with the indicated result
14 -- - WAITING
15 -- activity is waiting for additional transitions
16 -- - DEFERED
17 -- execution should be defered to background
18 -- - NOTIFIED[:<notification_id>:<assigned_user>]
19 -- activity has notified an external entity that this
20 -- step must be performed. A call to wf_engine.CompleteActivty
21 -- will signal when this step is complete. Optional
22 -- return of notification ID and assigned user.
23 -- - ERROR[:<error_code>]
24 -- function encountered an error.
25
26 -----------------------------------------------------------------------------
27 -- Constants definition
28 ----------------------------------------------------------------------------
29 -- Max number of approver
30 C_MAX_NUMBER_APPROVER CONSTANT NUMBER := 200;
31
32 -----------------------------------------------------------------------------
33 PROCEDURE FindTrx(p_item_type IN VARCHAR2,
34 p_item_key IN VARCHAR2,
35 p_actid IN NUMBER,
36 p_funcmode IN VARCHAR2,
37 p_result OUT NOCOPY VARCHAR2);
38
39 /* 7367350 Passed new parameter for retrieving internal comment and inserting in Workflow attribute
40 For case of not using AME */
41 PROCEDURE GetCustomerTrxInfo(p_item_type IN VARCHAR2,
42 p_item_key IN VARCHAR2,
43 p_workflow_document_id OUT NOCOPY NUMBER,
44 p_customer_trx_id OUT NOCOPY NUMBER,
45 p_amount OUT NOCOPY NUMBER,
46 p_line_amount OUT NOCOPY NUMBER,
47 p_tax_amount OUT NOCOPY NUMBER,
48 p_freight_amount OUT NOCOPY NUMBER,
49 p_reason OUT NOCOPY VARCHAR2,
50 p_reason_meaning OUT NOCOPY VARCHAR2,
51 p_requestor_id OUT NOCOPY NUMBER,
52 p_comments OUT NOCOPY VARCHAR2,
53 p_orig_trx_number OUT NOCOPY VARCHAR2,
54 p_tax_ex_cert_num OUT NOCOPY VARCHAR2,
55 p_internal_comment OUT NOCOPY VARCHAR2);
56
57
58
59 PROCEDURE GetTrxAmount(p_item_type IN VARCHAR2,
60 p_item_key IN VARCHAR2,
61 p_customer_trx_id IN NUMBER,
62 p_original_line_amount OUT NOCOPY NUMBER,
63 p_original_tax_amount OUT NOCOPY NUMBER,
64 p_original_freight_amount OUT NOCOPY NUMBER,
65 p_original_total OUT NOCOPY NUMBER,
66 p_currency_code OUT NOCOPY VARCHAR2);
67
68 PROCEDURE FindCustomer(p_item_type IN VARCHAR2,
69 p_item_key IN VARCHAR2,
70 p_actid IN NUMBER,
71 p_funcmode IN VARCHAR2,
72 p_result OUT NOCOPY VARCHAR2);
73
74 PROCEDURE FindCustomerInfo(p_customer_trx_id IN NUMBER,
75 p_bill_to_site_use_id OUT NOCOPY NUMBER,
76 p_customer_id OUT NOCOPY NUMBER,
77 p_bill_to_customer_name OUT NOCOPY VARCHAR2,
78 p_bill_to_customer_number OUT NOCOPY VARCHAR2,
79 p_ship_to_customer_number OUT NOCOPY VARCHAR2,
80 p_ship_to_customer_name OUT NOCOPY VARCHAR2,
81 p_trx_number OUT NOCOPY VARCHAR2 );
82
83 PROCEDURE FindCollector(p_item_type IN VARCHAR2,
84 p_item_key IN VARCHAR2,
85 p_actid IN NUMBER,
86 p_funcmode IN VARCHAR2,
87 p_result OUT NOCOPY VARCHAR2);
88
89 PROCEDURE FindManager (p_item_type IN VARCHAR2,
90 p_item_key IN VARCHAR2,
91 p_actid IN NUMBER,
92 p_funcmode IN VARCHAR2,
93 p_result OUT NOCOPY VARCHAR2);
94
95
96 PROCEDURE FindCollectorInfo(p_customer_id IN NUMBER,
97 p_bill_to_site_use_id IN NUMBER,
98 p_collector_employee_id OUT NOCOPY NUMBER,
99 p_collector_id OUT NOCOPY NUMBER,
100 p_collector_name OUT NOCOPY VARCHAR2);
101
102
103 PROCEDURE DefaultSendTo (p_item_type IN VARCHAR2,
104 p_item_key IN VARCHAR2,
105 p_actid IN NUMBER,
106 p_funcmode IN VARCHAR2,
107 p_result OUT NOCOPY VARCHAR2);
108
109 PROCEDURE CheckPrimaryApprover(p_item_type IN VARCHAR2,
110 p_item_key IN VARCHAR2,
111 p_actid IN NUMBER,
112 p_funcmode IN VARCHAR2,
113 p_result OUT NOCOPY VARCHAR2);
114
115 PROCEDURE FindPrimaryApprover(p_item_type IN VARCHAR2,
116 p_item_key IN VARCHAR2,
117 p_actid IN NUMBER,
118 p_funcmode IN VARCHAR2,
119 p_result OUT NOCOPY VARCHAR2);
120
121 PROCEDURE FindNonPrimaryApprover(p_item_type IN VARCHAR2,
122 p_item_key IN VARCHAR2,
123 p_actid IN NUMBER,
124 p_funcmode IN VARCHAR2,
125 p_result OUT NOCOPY VARCHAR2);
126
127 PROCEDURE FindNextNonPrimaryApprover(p_item_type IN VARCHAR2,
128 p_item_key IN VARCHAR2,
129 p_actid IN NUMBER,
130 p_funcmode IN VARCHAR2,
131 p_result OUT NOCOPY VARCHAR2);
132
133 PROCEDURE SelectFirstPrimaryApproverId
134 (p_reason_code IN VARCHAR2,
135 p_currency_code IN VARCHAR2,
136 p_approver_employee_id OUT NOCOPY NUMBER);
137
138 PROCEDURE SelectPrimaryApproverId(p_reason_code IN VARCHAR2,
139 p_currency_code IN VARCHAR2,
140 p_approver_count IN NUMBER,
141 p_approver_employee_id OUT NOCOPY NUMBER);
142
143 PROCEDURE GetEmployeeInfo( p_user_id in number,
144 p_item_type in varchar2,
145 p_item_key in varchar2,
146 p_primary_approver_flag in varchar2);
147
148 PROCEDURE GetUserInfoFromTable(p_user_id IN NUMBER,
149 p_primary_approver_flag IN VARCHAR2,
150 p_user_name OUT NOCOPY VARCHAR2,
151 p_display_name OUT NOCOPY VARCHAR2);
152
153 PROCEDURE RecordCollectorAsApprover(p_item_type IN VARCHAR2,
154 p_item_key IN VARCHAR2,
155 p_actid IN NUMBER,
156 p_funcmode IN VARCHAR2,
157 p_result OUT NOCOPY VARCHAR2);
158
159 PROCEDURE RecordCollectorAsForwardFrom(p_item_type IN VARCHAR2,
160 p_item_key IN VARCHAR2,
161 p_actid IN NUMBER,
162 p_funcmode IN VARCHAR2,
163 p_result OUT NOCOPY VARCHAR2);
164
165
166 PROCEDURE RecordForwardToUserInfo(p_item_type IN VARCHAR2,
167 p_item_key IN VARCHAR2,
168 p_actid IN NUMBER,
169 p_funcmode IN VARCHAR2,
170 p_result OUT NOCOPY VARCHAR2);
171
172 PROCEDURE CheckForwardFromUser(p_item_type IN VARCHAR2,
173 p_item_key IN VARCHAR2,
174 p_actid IN NUMBER,
175 p_funcmode IN VARCHAR2,
176 p_result OUT NOCOPY VARCHAR2);
177
178
179 PROCEDURE RecordApproverAsForwardFrom(p_item_type IN VARCHAR2,
180 p_item_key IN VARCHAR2,
181 p_actid IN NUMBER,
182 p_funcmode IN VARCHAR2,
183 p_result OUT NOCOPY VARCHAR2);
184
185 PROCEDURE RemoveFromDispute (p_item_type IN VARCHAR2,
186 p_item_key IN VARCHAR2,
187 p_actid IN NUMBER,
188 p_funcmode IN VARCHAR2,
189 p_result OUT NOCOPY VARCHAR2);
190
191
192 PROCEDURE FinalApprover(p_item_type IN VARCHAR2,
193 p_item_key IN VARCHAR2,
194 p_actid IN NUMBER,
195 p_funcmode IN VARCHAR2,
196 p_result OUT NOCOPY VARCHAR2);
197
198 PROCEDURE CheckFinalApprover(p_reason_code IN VARCHAR2,
199 p_currency_code IN VARCHAR2,
200 p_amount IN VARCHAR2,
201 p_approver_id IN NUMBER,
202 p_result_flag OUT NOCOPY VARCHAR2);
203
204 PROCEDURE FindReceivableApprover(p_item_type IN VARCHAR2,
205 p_item_key IN VARCHAR2,
206 p_actid IN NUMBER,
207 p_funcmode IN VARCHAR2,
208 p_result OUT NOCOPY VARCHAR2);
209
210 PROCEDURE FindResponder (p_item_type IN VARCHAR2,
211 p_item_key IN VARCHAR2,
212 p_actid IN NUMBER,
213 p_funcmode IN VARCHAR2,
214 p_result OUT NOCOPY VARCHAR2);
215
216 PROCEDURE InsertSubmissionNotes(p_item_type IN VARCHAR2,
217 p_item_key IN VARCHAR2,
218 p_actid IN NUMBER,
219 p_funcmode IN VARCHAR2,
220 p_result OUT NOCOPY VARCHAR2);
221
222 PROCEDURE InsertEscalationNotes(p_item_type IN VARCHAR2,
223 p_item_key IN VARCHAR2,
224 p_actid IN NUMBER,
225 p_funcmode IN VARCHAR2,
226 p_result OUT NOCOPY VARCHAR2);
227
228 PROCEDURE InsertRequestManualNotes (p_item_type IN VARCHAR2,
229 p_item_key IN VARCHAR2,
230 p_actid IN NUMBER,
231 p_funcmode IN VARCHAR2,
232 p_result OUT NOCOPY VARCHAR2);
233
234 PROCEDURE InsertCompletedManualNotes(p_item_type IN VARCHAR2,
235 p_item_key IN VARCHAR2,
236 p_actid IN NUMBER,
237 p_funcmode IN VARCHAR2,
238 p_result OUT NOCOPY VARCHAR2);
239
240
241 PROCEDURE InsertRequestApprovalNotes(p_item_type IN VARCHAR2,
242 p_item_key IN VARCHAR2,
243 p_actid IN NUMBER,
244 p_funcmode IN VARCHAR2,
245 p_result OUT NOCOPY VARCHAR2);
246
247 PROCEDURE InsertApprovedResponseNotes(p_item_type IN VARCHAR2,
248 p_item_key IN VARCHAR2,
249 p_actid IN NUMBER,
250 p_funcmode IN VARCHAR2,
251 p_result OUT NOCOPY VARCHAR2);
252
253 PROCEDURE InsertRejectedResponseNotes(p_item_type IN VARCHAR2,
254 p_item_key IN VARCHAR2,
255 p_actid IN NUMBER,
256 p_funcmode IN VARCHAR2,
257 p_result OUT NOCOPY VARCHAR2);
258
259 PROCEDURE InsertSuccessfulAPINotes(p_item_type IN VARCHAR2,
260 p_item_key IN VARCHAR2,
261 p_actid IN NUMBER,
262 p_funcmode IN VARCHAR2,
263 p_result OUT NOCOPY VARCHAR2);
264
265
266 PROCEDURE InsertApprovalReminderNotes(p_item_type IN VARCHAR2,
267 p_item_key IN VARCHAR2,
268 p_actid IN NUMBER,
269 p_funcmode IN VARCHAR2,
270 p_result OUT NOCOPY VARCHAR2);
271
272
273 PROCEDURE InsertNotes(p_item_type IN VARCHAR2,
274 p_item_key IN VARCHAR2,
275 p_actid IN NUMBER,
276 p_funcmode IN VARCHAR2,
277 p_result OUT NOCOPY VARCHAR2);
278
279
280
281 PROCEDURE InsertTrxNotes(x_customer_call_id IN NUMBER,
282 x_customer_call_topic_id IN NUMBER,
283 x_action_id IN NUMBER,
284 x_customer_trx_id IN NUMBER,
285 x_note_type IN VARCHAR2,
286 x_text IN VARCHAR2,
287 x_note_id OUT NOCOPY NUMBER);
288
289
290 -- Sai's procedure
291
292 PROCEDURE CallTrxApi(p_item_type IN VARCHAR2,
293 p_item_key IN VARCHAR2,
294 p_actid IN NUMBER,
295 p_funcmode IN VARCHAR2,
296 p_result OUT NOCOPY VARCHAR2);
297
298
299 PROCEDURE CheckCreditMethods(p_item_type IN VARCHAR2,
300 p_item_key IN VARCHAR2,
301 p_actid IN NUMBER,
302 p_funcmode IN VARCHAR2,
303 p_result OUT NOCOPY VARCHAR2);
304
305 PROCEDURE SetOrgContext (p_item_key IN VARCHAR2);
306
307 PROCEDURE callback_routine (
308 p_item_type IN VARCHAR2,
309 p_item_key IN VARCHAR2,
310 p_activity_id IN NUMBER,
311 p_command IN VARCHAR2,
312 p_result IN OUT NOCOPY VARCHAR2);
313
314
315 end ARP_CMREQ_WF;