[Home] [Help]
PACKAGE: APPS.AP_WEB_RECEIPTS_WF
Source
1 PACKAGE AP_WEB_RECEIPTS_WF AUTHID CURRENT_USER AS
2 /* $Header: apwrecpts.pls 120.8.12020000.2 2012/07/05 14:21:21 rveliche ship $ */
3
4 ------------------------
5 -- Item Types
6 ------------------------
7 C_APWRECPT CONSTANT VARCHAR2(8) := 'APWRECPT';
8 C_APEXP CONSTANT VARCHAR2(8) := 'APEXP';
9
10 ------------------------
11 -- Shortpay Processes
12 ------------------------
13 C_NO_RECEIPTS_SHORTPAY_PROCESS CONSTANT VARCHAR2(30) := 'NO_RECEIPTS_SHORTPAY_PROCESS'; -- missing
14 C_POLICY_VIOLATION_PROCESS CONSTANT VARCHAR2(30) := 'POLICY_VIOLATION_PROCESS'; -- policy
15
16 ------------------------
17 -- Shortpay Notifs
18 ------------------------
19 C_INFORM_PREPARER_SHORTPAY CONSTANT VARCHAR2(30) := 'INFORM_PREPARER_SHORTPAY'; -- missing
20 C_POLICY_SHORTPAY_NOTICE CONSTANT VARCHAR2(30) := 'POLICY_SHORTPAY_NOTICE'; -- policy
21
22 ------------------------
23 -- Shortpay Notifs Results
24 ------------------------
25 C_AP_WILL_SUBMIT CONSTANT VARCHAR2(30) := 'AP_WILL_SUBMIT'; -- missing
26 C_AP_PROVIDE_MISSING_INFO CONSTANT VARCHAR2(30) := 'AP_PROVIDE MISSING_INFO'; -- policy
27
28 ------------------------
29 -- Rules
30 ------------------------
31 C_NOTIFY_RULE CONSTANT ap_aud_rule_sets.rule_set_type%type := 'NOTIFY';
32
33 C_RECEIPT_RULE CONSTANT ap_aud_rule_sets.rule_set_type%type := 'RECEIPT';
34
35 ------------------------
36 -- Expense Report Sources
37 ------------------------
38 C_SELF_SERVICE_SOURCE CONSTANT ap_expense_report_headers.source%type := 'SelfService';
39 C_BOTHPAY CONSTANT ap_expense_report_headers.source%type := 'Both Pay';
40
41 ------------------------
42 -- Expense Report Statuses
43 ------------------------
44 C_INVOICED CONSTANT ap_expense_report_headers.expense_status_code%type := 'INVOICED';
45 C_PARPAID CONSTANT ap_expense_report_headers.expense_status_code%type := 'PARPAID';
46 C_PAID CONSTANT ap_expense_report_headers.expense_status_code%type := 'PAID';
47 C_PENDING_HOLDS CONSTANT ap_expense_report_headers.expense_status_code%type := 'PEND_HOLDS_CLEARANCE';
48 C_PAYMENT_HELD CONSTANT ap_expense_report_headers.expense_status_code%type := 'HOLD_PENDING_RECEIPTS';
49
50 ------------------------
51 -- Lookup: RECEIPTS STATUS
52 ------------------------
53 C_NOT_REQUIRED CONSTANT VARCHAR2(30) := 'NOT_REQUIRED';
54 C_REQUIRED CONSTANT VARCHAR2(30) := 'REQUIRED';
55 C_RECEIVED CONSTANT VARCHAR2(30) := 'RECEIVED';
56 C_RECEIVED_RESUBMITTED CONSTANT VARCHAR2(30) := 'RECEIVED_RESUBMITTED';
57 C_MISSING CONSTANT VARCHAR2(30) := 'MISSING';
58 C_WAIVED CONSTANT VARCHAR2(30) := 'WAIVED';
59 C_OVERDUE CONSTANT VARCHAR2(30) := 'OVERDUE';
60 C_IN_TRANSIT CONSTANT VARCHAR2(30) := 'IN_TRANSIT';
61 C_RESOLUTN CONSTANT VARCHAR2(30) := 'RESOLUTN';
62
63 ------------------------
64 -- Lookup: OIE_NOTIFY_RCT_RECEIVED
65 ------------------------
66 C_NEVER CONSTANT VARCHAR2(30) := 'NEVER';
67 C_RECEIPTS_OVERDUE CONSTANT VARCHAR2(30) := 'RECEIPTS_OVERDUE';
68 C_RECEIPTS_RECEIVED CONSTANT VARCHAR2(30) := 'RECEIPTS_RECEIVED';
69
70
71 ------------------------------------------------------------------------
72 FUNCTION IsNotifRuleSetup( p_org_id IN NUMBER,
73 p_report_submitted_date IN DATE) RETURN VARCHAR2;
74 ------------------------------------------------------------------------
75
76 ------------------------------------------------------------------------
77 PROCEDURE IsNotifRuleSetup( p_item_type IN VARCHAR2,
78 p_item_key IN VARCHAR2,
79 p_actid IN NUMBER,
80 p_funmode IN VARCHAR2,
81 p_result OUT NOCOPY VARCHAR2);
82 ------------------------------------------------------------------------
83
84 ------------------------------------------------------------------------
85 PROCEDURE RaiseOverdueEvent(
86 p_expense_report_id IN NUMBER);
87 ------------------------------------------------------------------------
88 ------------------------------------------------------------------------
89 PROCEDURE RaiseMissingEvent(
90 p_expense_report_id IN NUMBER);
91 ------------------------------------------------------------------------
92 ------------------------------------------------------------------------
93 PROCEDURE RaiseReceivedEvent(
94 p_expense_report_id IN NUMBER);
95 ------------------------------------------------------------------------
96 ------------------------------------------------------------------------
97 PROCEDURE RaiseAbortedEvent(
98 p_expense_report_id IN NUMBER);
99 ------------------------------------------------------------------------
100
101 ------------------------------------------------------------------------
102 PROCEDURE RaiseAbortedEvent(
103 p_item_type IN VARCHAR2,
104 p_item_key IN VARCHAR2,
105 p_actid IN NUMBER,
106 p_funmode IN VARCHAR2,
107 p_result OUT NOCOPY VARCHAR2);
108 ------------------------------------------------------------------------
109
110 ------------------------------------------------------------------------
111 PROCEDURE InitOverdue(
112 p_item_type IN VARCHAR2,
113 p_item_key IN VARCHAR2,
114 p_actid IN NUMBER,
115 p_funmode IN VARCHAR2,
116 p_result OUT NOCOPY VARCHAR2);
117 ------------------------------------------------------------------------
118
119 ------------------------------------------------------------------------
120 PROCEDURE InitMissing(
121 p_item_type IN VARCHAR2,
122 p_item_key IN VARCHAR2,
123 p_actid IN NUMBER,
124 p_funmode IN VARCHAR2,
125 p_result OUT NOCOPY VARCHAR2);
126 ------------------------------------------------------------------------
127
128 ------------------------------------------------------------------------
129 PROCEDURE CheckOverdueExists(
130 p_item_type IN VARCHAR2,
131 p_item_key IN VARCHAR2,
132 p_actid IN NUMBER,
133 p_funmode IN VARCHAR2,
134 p_result OUT NOCOPY VARCHAR2);
135 ------------------------------------------------------------------------
136
137 ------------------------------------------------------------------------
138 PROCEDURE CheckMissingExists(
139 p_item_type IN VARCHAR2,
140 p_item_key IN VARCHAR2,
141 p_actid IN NUMBER,
142 p_funmode IN VARCHAR2,
143 p_result OUT NOCOPY VARCHAR2);
144 ------------------------------------------------------------------------
145
146 ------------------------------------------------------------------------
147 PROCEDURE AbortOverdue(
148 p_item_type IN VARCHAR2,
149 p_item_key IN VARCHAR2,
150 p_actid IN NUMBER,
151 p_funmode IN VARCHAR2,
152 p_result OUT NOCOPY VARCHAR2);
153 ------------------------------------------------------------------------
154
155 ------------------------------------------------------------------------
156 PROCEDURE AbortMissing(
157 p_item_type IN VARCHAR2,
158 p_item_key IN VARCHAR2,
159 p_actid IN NUMBER,
160 p_funmode IN VARCHAR2,
161 p_result OUT NOCOPY VARCHAR2);
162 ------------------------------------------------------------------------
163
164 ------------------------------------------------------------------------
165 PROCEDURE AbortProcess(
166 p_item_type IN VARCHAR2,
167 p_item_key IN VARCHAR2,
168 p_event_key IN VARCHAR2);
169 ------------------------------------------------------------------------
170
171
172 ------------------------------------------------------------------------
173 PROCEDURE InitReceived(
174 p_item_type IN VARCHAR2,
175 p_item_key IN VARCHAR2,
176 p_actid IN NUMBER,
177 p_funmode IN VARCHAR2,
178 p_result OUT NOCOPY VARCHAR2);
179 ------------------------------------------------------------------------
180
181 ------------------------------------------------------------------------
182 PROCEDURE InitAborted(
183 p_item_type IN VARCHAR2,
184 p_item_key IN VARCHAR2,
185 p_actid IN NUMBER,
186 p_funmode IN VARCHAR2,
187 p_result OUT NOCOPY VARCHAR2);
188 ------------------------------------------------------------------------
189
190 ------------------------------------------------------------------------
191 FUNCTION GetReceiptsStatus(
192 p_report_header_id IN NUMBER) RETURN VARCHAR2;
193 ------------------------------------------------------------------------
194
195 ------------------------------------------------------------------------
196 PROCEDURE GetReceiptsStatus(
197 p_item_type IN VARCHAR2,
198 p_item_key IN VARCHAR2,
199 p_actid IN NUMBER,
200 p_funmode IN VARCHAR2,
201 p_result OUT NOCOPY VARCHAR2);
202 ------------------------------------------------------------------------
203 ------------------------------------------------------------------------
204 PROCEDURE SetReceiptsStatus(
205 p_report_header_id IN NUMBER,
206 p_receipts_status IN VARCHAR2);
207 ------------------------------------------------------------------------
208
209 ------------------------------------------------------------------------
210 PROCEDURE SetReceiptsStatus(
211 p_item_type IN VARCHAR2,
212 p_item_key IN VARCHAR2,
213 p_actid IN NUMBER,
214 p_funmode IN VARCHAR2,
215 p_result OUT NOCOPY VARCHAR2);
216 ------------------------------------------------------------------------
217
218 ------------------------------------------------------------------------
219 PROCEDURE SetDaysOverdue(
220 p_item_type IN VARCHAR2,
221 p_item_key IN VARCHAR2);
222 ------------------------------------------------------------------------
223
224 ------------------------------------------------------------------------
225 PROCEDURE SetDaysOverdue(
226 p_item_type IN VARCHAR2,
227 p_item_key IN VARCHAR2,
228 p_actid IN NUMBER,
229 p_funmode IN VARCHAR2,
230 p_result OUT NOCOPY VARCHAR2);
234 PROCEDURE CheckMissingDeclRequired(
231 ------------------------------------------------------------------------
232
233 ------------------------------------------------------------------------
235 p_item_type IN VARCHAR2,
236 p_item_key IN VARCHAR2,
237 p_actid IN NUMBER,
238 p_funmode IN VARCHAR2,
239 p_result OUT NOCOPY VARCHAR2);
240 ------------------------------------------------------------------------
241
242 ------------------------------------------------------------------------
243 PROCEDURE CheckNotifyReceived(
244 p_item_type IN VARCHAR2,
245 p_item_key IN VARCHAR2,
246 p_actid IN NUMBER,
247 p_funmode IN VARCHAR2,
248 p_result OUT NOCOPY VARCHAR2);
249 ------------------------------------------------------------------------
250
251 ------------------------------------------------------------------------
252 PROCEDURE IsReceivedWaived(
253 p_item_type IN VARCHAR2,
254 p_item_key IN VARCHAR2,
255 p_actid IN NUMBER,
256 p_funmode IN VARCHAR2,
257 p_result OUT NOCOPY VARCHAR2);
258 ------------------------------------------------------------------------
259
260 ------------------------------------------------------------------------
261 PROCEDURE IsMissingShortpay(
262 p_item_type IN VARCHAR2,
263 p_item_key IN VARCHAR2,
264 p_actid IN NUMBER,
265 p_funmode IN VARCHAR2,
266 p_result OUT NOCOPY VARCHAR2);
267 ------------------------------------------------------------------------
268
269 ------------------------------------------------------------------------
270 PROCEDURE IsPolicyShortpay(
271 p_item_type IN VARCHAR2,
272 p_item_key IN VARCHAR2,
273 p_actid IN NUMBER,
274 p_funmode IN VARCHAR2,
275 p_result OUT NOCOPY VARCHAR2);
276 ------------------------------------------------------------------------
277
278 ------------------------------------------------------------------------
279 PROCEDURE CompleteMissingShortpay(
280 p_item_type IN VARCHAR2,
281 p_item_key IN VARCHAR2,
282 p_actid IN NUMBER,
283 p_funmode IN VARCHAR2,
284 p_result OUT NOCOPY VARCHAR2);
285 ------------------------------------------------------------------------
286
287 ------------------------------------------------------------------------
288 PROCEDURE CompletePolicyShortpay(
289 p_item_type IN VARCHAR2,
290 p_item_key IN VARCHAR2,
291 p_actid IN NUMBER,
292 p_funmode IN VARCHAR2,
293 p_result OUT NOCOPY VARCHAR2);
294 ------------------------------------------------------------------------
295
296 ------------------------------------------------------------------------
297 PROCEDURE StoreNote(
298 p_item_type IN VARCHAR2,
299 p_item_key IN VARCHAR2,
300 p_actid IN NUMBER,
301 p_funmode IN VARCHAR2,
302 p_result OUT NOCOPY VARCHAR2);
303 ------------------------------------------------------------------------
304
305 ------------------------------------------------------------------------
306 PROCEDURE CallbackFunction( p_item_type IN VARCHAR2,
307 p_item_key IN VARCHAR2,
308 p_actid IN NUMBER,
309 p_funmode IN VARCHAR2,
310 p_result OUT NOCOPY VARCHAR2);
311 ------------------------------------------------------------------------
312
313 ------------------------------------------------------------------------
314 PROCEDURE TrackOverdue(
315 errbuf out nocopy varchar2,
316 retcode out nocopy number,
317 p_org_id in number,
318 p_mgr_notify in varchar2 DEFAULT 'N',
319 p_dummy_notify in number,
320 p_surrogate_mgr_id in number DEFAULT NULL) ;
321 ------------------------------------------------------------------------
322
323 ------------------------------------------------------------------------
324 PROCEDURE CheckReceiptType( p_item_type IN VARCHAR2,
325 p_item_key IN VARCHAR2,
326 p_actid IN NUMBER,
327 p_funmode IN VARCHAR2,
328 p_result OUT NOCOPY VARCHAR2);
329 ------------------------------------------------------------------------
330
331 ------------------------------------------------------------------------
332 FUNCTION GetImageReceiptsStatus(
333 p_report_header_id IN NUMBER) RETURN VARCHAR2;
334 ------------------------------------------------------------------------
335
339 p_receipts_status IN VARCHAR2);
336 ------------------------------------------------------------------------
337 PROCEDURE SetImageReceiptsStatus(
338 p_report_header_id IN NUMBER,
340 ------------------------------------------------------------------------
341
342 ------------------------------------------------------------------------
343 PROCEDURE CheckNotifyImageReceived(
344 p_item_type IN VARCHAR2,
345 p_item_key IN VARCHAR2,
346 p_actid IN NUMBER,
347 p_funmode IN VARCHAR2,
348 p_result OUT NOCOPY VARCHAR2);
349 ------------------------------------------------------------------------
350
351 ------------------------------------------------------------------------
352 PROCEDURE SetImageReceiptsStatus(
353 p_item_type IN VARCHAR2,
354 p_item_key IN VARCHAR2,
355 p_actid IN NUMBER,
356 p_funmode IN VARCHAR2,
357 p_result OUT NOCOPY VARCHAR2);
358 ------------------------------------------------------------------------
359
360 ------------------------------------------------------------------------
361 PROCEDURE GetImageReceiptsStatus(
362 p_item_type IN VARCHAR2,
363 p_item_key IN VARCHAR2,
364 p_actid IN NUMBER,
365 p_funmode IN VARCHAR2,
366 p_result OUT NOCOPY VARCHAR2);
367 ------------------------------------------------------------------------
368
369 ------------------------------------------------------------------------
370 PROCEDURE SetImageOverdueDays(
371 p_item_type IN VARCHAR2,
372 p_item_key IN VARCHAR2);
373 ------------------------------------------------------------------------
374
375 ------------------------------------------------------------------------
376 PROCEDURE SetImageOverdueDays(
377 p_item_type IN VARCHAR2,
378 p_item_key IN VARCHAR2,
379 p_actid IN NUMBER,
380 p_funmode IN VARCHAR2,
381 p_result OUT NOCOPY VARCHAR2);
382 ------------------------------------------------------------------------
383
384 ------------------------------------------------------------------------
385 PROCEDURE UpdateOriginalInTransit(
386 p_item_type IN VARCHAR2,
387 p_item_key IN VARCHAR2,
388 p_actid IN NUMBER,
389 p_funmode IN VARCHAR2,
390 p_result OUT NOCOPY VARCHAR2);
391 ------------------------------------------------------------------------
392
393 ------------------------------------------------------------------------
394 PROCEDURE RaiseMissingEvent(
395 p_item_type IN VARCHAR2,
396 p_item_key IN VARCHAR2,
397 p_actid IN NUMBER,
398 p_funmode IN VARCHAR2,
399 p_result OUT NOCOPY VARCHAR2);
400 ------------------------------------------------------------------------
401
402 ------------------------------------------------------------------------
403 PROCEDURE AcceptMissingReceiptDecl(
404 p_item_type IN VARCHAR2,
405 p_item_key IN VARCHAR2,
406 p_actid IN NUMBER,
407 p_funmode IN VARCHAR2,
408 p_result OUT NOCOPY VARCHAR2);
409 ------------------------------------------------------------------------
410
411 ------------------------------------------------------------------------
412 PROCEDURE InitOriginalRecptTrack(
413 p_item_type IN VARCHAR2,
414 p_item_key IN VARCHAR2,
415 p_actid IN NUMBER,
416 p_funmode IN VARCHAR2,
417 p_result OUT NOCOPY VARCHAR2);
418 ------------------------------------------------------------------------
419
420 ------------------------------------------------------------------------
421 PROCEDURE Check_Both_Required(
422 p_item_type IN VARCHAR2,
423 p_item_key IN VARCHAR2,
424 p_actid IN NUMBER,
425 p_funmode IN VARCHAR2,
426 p_result OUT NOCOPY VARCHAR2);
427 ------------------------------------------------------------------------
428
429 ------------------------------------------------------------------------
430 PROCEDURE CheckRecvdRecptType(
431 p_item_type IN VARCHAR2,
432 p_item_key IN VARCHAR2,
433 p_actid IN NUMBER,
434 p_funmode IN VARCHAR2,
435 p_result OUT NOCOPY VARCHAR2);
436 ------------------------------------------------------------------------
437 ------------------------------------------------------------------------
438 PROCEDURE RaiseReceivedEvent(
439 p_expense_report_id IN NUMBER,
443 PROCEDURE AbortOriginalOverdue(
440 p_receipt_type IN VARCHAR2);
441 ------------------------------------------------------------------------
442 -----------------------------------------------------------------------
444 p_item_type IN VARCHAR2,
445 p_item_key IN VARCHAR2,
446 p_actid IN NUMBER,
447 p_funmode IN VARCHAR2,
448 p_result OUT NOCOPY VARCHAR2);
449 ------------------------------------------------------------------------
450 -----------------------------------------------------------------------
451 PROCEDURE IsReportReturned(
452 p_item_type IN VARCHAR2,
453 p_item_key IN VARCHAR2,
454 p_actid IN NUMBER,
455 p_funmode IN VARCHAR2,
456 p_result OUT NOCOPY VARCHAR2);
457 ------------------------------------------------------------------------
458
459
460
461 END AP_WEB_RECEIPTS_WF;