[Home] [Help]
PACKAGE: APPS.AP_WEB_RECEIPTS_WF
Source
1 PACKAGE AP_WEB_RECEIPTS_WF AS
2 /* $Header: apwrecpts.pls 120.3 2006/02/24 10:20:50 sbalaji noship $ */
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 ------------------------
34 -- Expense Report Sources
35 ------------------------
36 C_SELF_SERVICE_SOURCE CONSTANT ap_expense_report_headers.source%type := 'SelfService';
37 C_BOTHPAY CONSTANT ap_expense_report_headers.source%type := 'Both Pay';
38
39 ------------------------
40 -- Expense Report Statuses
41 ------------------------
42 C_INVOICED CONSTANT ap_expense_report_headers.expense_status_code%type := 'INVOICED';
43 C_PENDING_HOLDS CONSTANT ap_expense_report_headers.expense_status_code%type := 'PEND_HOLDS_CLEARANCE';
44 C_PAYMENT_HELD CONSTANT ap_expense_report_headers.expense_status_code%type := 'HOLD_PENDING_RECEIPTS';
45
46 ------------------------
47 -- Lookup: RECEIPTS STATUS
48 ------------------------
49 C_NOT_REQUIRED CONSTANT VARCHAR2(30) := 'NOT_REQUIRED';
50 C_REQUIRED CONSTANT VARCHAR2(30) := 'REQUIRED';
51 C_RECEIVED CONSTANT VARCHAR2(30) := 'RECEIVED';
52 C_RECEIVED_RESUBMITTED CONSTANT VARCHAR2(30) := 'RECEIVED_RESUBMITTED';
53 C_MISSING CONSTANT VARCHAR2(30) := 'MISSING';
54 C_WAIVED CONSTANT VARCHAR2(30) := 'WAIVED';
55 C_OVERDUE CONSTANT VARCHAR2(30) := 'OVERDUE';
56 C_IN_TRANSIT CONSTANT VARCHAR2(30) := 'IN_TRANSIT';
57 C_RESOLUTN CONSTANT VARCHAR2(30) := 'RESOLUTN';
58
59 ------------------------
60 -- Lookup: OIE_NOTIFY_RCT_RECEIVED
61 ------------------------
62 C_NEVER CONSTANT VARCHAR2(30) := 'NEVER';
63 C_RECEIPTS_OVERDUE CONSTANT VARCHAR2(30) := 'RECEIPTS_OVERDUE';
64 C_RECEIPTS_RECEIVED CONSTANT VARCHAR2(30) := 'RECEIPTS_RECEIVED';
65
66
67 ------------------------------------------------------------------------
68 FUNCTION IsNotifRuleSetup( p_org_id IN NUMBER,
69 p_report_submitted_date IN DATE) RETURN VARCHAR2;
70 ------------------------------------------------------------------------
71
72 ------------------------------------------------------------------------
73 PROCEDURE IsNotifRuleSetup( p_item_type IN VARCHAR2,
74 p_item_key IN VARCHAR2,
75 p_actid IN NUMBER,
76 p_funmode IN VARCHAR2,
77 p_result OUT NOCOPY VARCHAR2);
78 ------------------------------------------------------------------------
79
80 ------------------------------------------------------------------------
81 PROCEDURE RaiseOverdueEvent(
82 p_expense_report_id IN NUMBER);
83 ------------------------------------------------------------------------
84 ------------------------------------------------------------------------
85 PROCEDURE RaiseMissingEvent(
86 p_expense_report_id IN NUMBER);
87 ------------------------------------------------------------------------
88 ------------------------------------------------------------------------
89 PROCEDURE RaiseReceivedEvent(
90 p_expense_report_id IN NUMBER);
91 ------------------------------------------------------------------------
92 ------------------------------------------------------------------------
93 PROCEDURE RaiseAbortedEvent(
94 p_expense_report_id IN NUMBER);
95 ------------------------------------------------------------------------
96
97 ------------------------------------------------------------------------
98 PROCEDURE RaiseAbortedEvent(
99 p_item_type IN VARCHAR2,
100 p_item_key IN VARCHAR2,
101 p_actid IN NUMBER,
102 p_funmode IN VARCHAR2,
103 p_result OUT NOCOPY VARCHAR2);
104 ------------------------------------------------------------------------
105
106 ------------------------------------------------------------------------
107 PROCEDURE InitOverdue(
108 p_item_type IN VARCHAR2,
109 p_item_key IN VARCHAR2,
110 p_actid IN NUMBER,
111 p_funmode IN VARCHAR2,
112 p_result OUT NOCOPY VARCHAR2);
113 ------------------------------------------------------------------------
114
115 ------------------------------------------------------------------------
116 PROCEDURE InitMissing(
117 p_item_type IN VARCHAR2,
118 p_item_key IN VARCHAR2,
119 p_actid IN NUMBER,
120 p_funmode IN VARCHAR2,
121 p_result OUT NOCOPY VARCHAR2);
122 ------------------------------------------------------------------------
123
124 ------------------------------------------------------------------------
125 PROCEDURE CheckOverdueExists(
126 p_item_type IN VARCHAR2,
127 p_item_key IN VARCHAR2,
128 p_actid IN NUMBER,
129 p_funmode IN VARCHAR2,
130 p_result OUT NOCOPY VARCHAR2);
131 ------------------------------------------------------------------------
132
133 ------------------------------------------------------------------------
134 PROCEDURE CheckMissingExists(
135 p_item_type IN VARCHAR2,
136 p_item_key IN VARCHAR2,
137 p_actid IN NUMBER,
138 p_funmode IN VARCHAR2,
139 p_result OUT NOCOPY VARCHAR2);
140 ------------------------------------------------------------------------
141
142 ------------------------------------------------------------------------
143 PROCEDURE AbortOverdue(
144 p_item_type IN VARCHAR2,
145 p_item_key IN VARCHAR2,
146 p_actid IN NUMBER,
147 p_funmode IN VARCHAR2,
148 p_result OUT NOCOPY VARCHAR2);
149 ------------------------------------------------------------------------
150
151 ------------------------------------------------------------------------
152 PROCEDURE AbortMissing(
153 p_item_type IN VARCHAR2,
154 p_item_key IN VARCHAR2,
155 p_actid IN NUMBER,
156 p_funmode IN VARCHAR2,
157 p_result OUT NOCOPY VARCHAR2);
158 ------------------------------------------------------------------------
159
160 ------------------------------------------------------------------------
161 PROCEDURE AbortProcess(
162 p_item_type IN VARCHAR2,
163 p_item_key IN VARCHAR2,
164 p_event_key IN VARCHAR2);
165 ------------------------------------------------------------------------
166
167
168 ------------------------------------------------------------------------
169 PROCEDURE InitReceived(
170 p_item_type IN VARCHAR2,
171 p_item_key IN VARCHAR2,
172 p_actid IN NUMBER,
173 p_funmode IN VARCHAR2,
174 p_result OUT NOCOPY VARCHAR2);
175 ------------------------------------------------------------------------
176
177 ------------------------------------------------------------------------
178 PROCEDURE InitAborted(
179 p_item_type IN VARCHAR2,
180 p_item_key IN VARCHAR2,
181 p_actid IN NUMBER,
182 p_funmode IN VARCHAR2,
183 p_result OUT NOCOPY VARCHAR2);
184 ------------------------------------------------------------------------
185
186 ------------------------------------------------------------------------
187 FUNCTION GetReceiptsStatus(
188 p_report_header_id IN NUMBER) RETURN VARCHAR2;
189 ------------------------------------------------------------------------
190
191 ------------------------------------------------------------------------
192 PROCEDURE GetReceiptsStatus(
193 p_item_type IN VARCHAR2,
194 p_item_key IN VARCHAR2,
195 p_actid IN NUMBER,
196 p_funmode IN VARCHAR2,
197 p_result OUT NOCOPY VARCHAR2);
198 ------------------------------------------------------------------------
199 ------------------------------------------------------------------------
200 PROCEDURE SetReceiptsStatus(
201 p_report_header_id IN NUMBER,
202 p_receipts_status IN VARCHAR2);
203 ------------------------------------------------------------------------
204
205 ------------------------------------------------------------------------
206 PROCEDURE SetReceiptsStatus(
207 p_item_type IN VARCHAR2,
208 p_item_key IN VARCHAR2,
209 p_actid IN NUMBER,
210 p_funmode IN VARCHAR2,
211 p_result OUT NOCOPY VARCHAR2);
212 ------------------------------------------------------------------------
213
214 ------------------------------------------------------------------------
215 PROCEDURE SetDaysOverdue(
216 p_item_type IN VARCHAR2,
217 p_item_key IN VARCHAR2);
218 ------------------------------------------------------------------------
219
220 ------------------------------------------------------------------------
221 PROCEDURE SetDaysOverdue(
222 p_item_type IN VARCHAR2,
223 p_item_key IN VARCHAR2,
224 p_actid IN NUMBER,
225 p_funmode IN VARCHAR2,
226 p_result OUT NOCOPY VARCHAR2);
227 ------------------------------------------------------------------------
228
229 ------------------------------------------------------------------------
230 PROCEDURE CheckMissingDeclRequired(
231 p_item_type IN VARCHAR2,
232 p_item_key IN VARCHAR2,
236 ------------------------------------------------------------------------
233 p_actid IN NUMBER,
234 p_funmode IN VARCHAR2,
235 p_result OUT NOCOPY VARCHAR2);
237
238 ------------------------------------------------------------------------
239 PROCEDURE CheckNotifyReceived(
240 p_item_type IN VARCHAR2,
241 p_item_key IN VARCHAR2,
242 p_actid IN NUMBER,
243 p_funmode IN VARCHAR2,
244 p_result OUT NOCOPY VARCHAR2);
245 ------------------------------------------------------------------------
246
247 ------------------------------------------------------------------------
248 PROCEDURE IsReceivedWaived(
249 p_item_type IN VARCHAR2,
250 p_item_key IN VARCHAR2,
251 p_actid IN NUMBER,
252 p_funmode IN VARCHAR2,
253 p_result OUT NOCOPY VARCHAR2);
254 ------------------------------------------------------------------------
255
256 ------------------------------------------------------------------------
257 PROCEDURE IsMissingShortpay(
258 p_item_type IN VARCHAR2,
259 p_item_key IN VARCHAR2,
260 p_actid IN NUMBER,
261 p_funmode IN VARCHAR2,
262 p_result OUT NOCOPY VARCHAR2);
263 ------------------------------------------------------------------------
264
265 ------------------------------------------------------------------------
266 PROCEDURE IsPolicyShortpay(
267 p_item_type IN VARCHAR2,
268 p_item_key IN VARCHAR2,
269 p_actid IN NUMBER,
270 p_funmode IN VARCHAR2,
271 p_result OUT NOCOPY VARCHAR2);
272 ------------------------------------------------------------------------
273
274 ------------------------------------------------------------------------
275 PROCEDURE CompleteMissingShortpay(
276 p_item_type IN VARCHAR2,
277 p_item_key IN VARCHAR2,
278 p_actid IN NUMBER,
279 p_funmode IN VARCHAR2,
280 p_result OUT NOCOPY VARCHAR2);
281 ------------------------------------------------------------------------
282
283 ------------------------------------------------------------------------
284 PROCEDURE CompletePolicyShortpay(
285 p_item_type IN VARCHAR2,
286 p_item_key IN VARCHAR2,
287 p_actid IN NUMBER,
288 p_funmode IN VARCHAR2,
289 p_result OUT NOCOPY VARCHAR2);
290 ------------------------------------------------------------------------
291
292 ------------------------------------------------------------------------
293 PROCEDURE StoreNote(
294 p_item_type IN VARCHAR2,
295 p_item_key IN VARCHAR2,
296 p_actid IN NUMBER,
297 p_funmode IN VARCHAR2,
298 p_result OUT NOCOPY VARCHAR2);
299 ------------------------------------------------------------------------
300
301 ------------------------------------------------------------------------
302 PROCEDURE CallbackFunction( p_item_type IN VARCHAR2,
303 p_item_key IN VARCHAR2,
304 p_actid IN NUMBER,
305 p_funmode IN VARCHAR2,
306 p_result OUT NOCOPY VARCHAR2);
307 ------------------------------------------------------------------------
308
309 ------------------------------------------------------------------------
310 PROCEDURE TrackOverdue(
311 errbuf out nocopy varchar2,
312 retcode out nocopy number,
313 p_org_id in number) ;
314 ------------------------------------------------------------------------
315
316 END AP_WEB_RECEIPTS_WF;