[Home] [Help]
PACKAGE: APPS.OZF_RESALE_WF_PVT
Source
1 PACKAGE OZF_RESALE_WF_PVT AUTHID CURRENT_USER AS
2 /* $Header: ozfvrwfs.pls 120.4 2005/09/15 00:29:25 appldev ship $ */
3
4 -- Package name : OZF_RESALE_WF_PVT
5 -- Purpose :
6 -- History : CREATED VANSUB 02-18-2004
7 -- : MODIFICATIONS SLKRISHN 02-28-2004
8 -- NOTE :
9 -- End of Comments
10
11 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OZF_RESALE_WF_PVT';
12 G_FILE_NAME CONSTANT VARCHAR2(30) := 'ozfvrwfs.pls';
13
14 G_WF_ATTR_BATCH_ID CONSTANT VARCHAR2(30) := 'OZF_RESALE_BATCH_ID';
15 G_WF_ATTR_BATCH_NUMBER CONSTANT VARCHAR2(30) := 'OZF_BATCH_NUMBER';
16 G_WF_ATTR_ERROR_MESG CONSTANT VARCHAR2(30) := 'OZF_ERROR_MESSAGE';
17 G_WF_ATTR_BATCH_TYPE CONSTANT VARCHAR2(30) := 'OZF_RESALE_BATCH_TYPE';
18 G_WF_ATTR_BATCH_STATUS CONSTANT VARCHAR2(30) := 'OZF_RESALE_BATCH_STATUS';
19 G_WF_ATTR_BATCH_CALLER CONSTANT VARCHAR2(30) := 'OZF_RESALE_BATCH_CALLER';
20 G_WF_ATTR_WF_ADMINISTRATOR CONSTANT VARCHAR2(30) := 'WF_ADMINISTRATOR';
21 G_WF_ATTR_BATCH_NUM_W_DATE CONSTANT VARCHAR2(30) := 'OZF_BATCH_NUM_W_DATE';
22
23 G_WF_LKUP_CHARGEBACK CONSTANT VARCHAR2(30) := 'CHARGEBACK';
24 G_WF_LKUP_SPECIALPRICE CONSTANT VARCHAR2(30) := 'SHIP_DEBIT';
25 G_WF_LKUP_TRACING CONSTANT VARCHAR2(30) := 'TRACING';
26
27 G_WF_LKUP_UI CONSTANT VARCHAR2(30) := 'UI';
28 G_WF_LKUP_WEBADI CONSTANT VARCHAR2(30) := 'WEBADI';
29 G_WF_LKUP_XML CONSTANT VARCHAR2(30) := 'XML';
30
31 G_WF_LKUP_PENDING_PAYMENT CONSTANT VARCHAR2(30) := 'PENDING_PAYMENT';
32 G_WF_LKUP_PROCESSING CONSTANT VARCHAR2(30) := 'PROCESSING';
33
34 G_WF_LKUP_ERROR CONSTANT VARCHAR2(30) := 'ERROR';
35 G_WF_LKUP_SUCCESS CONSTANT VARCHAR2(30) := 'SUCCESS';
36
37 CURSOR g_batch_type_csr (p_id NUMBER)IS
38 SELECT batch_type
39 FROM ozf_resale_batches_all
40 WHERE resale_batch_id = p_id;
41
42
43 ---------------------------------------------------------------------
44 -- PROCEDURE
45 -- Check_Duplicates
46 --
47 -- PURPOSE
48 -- This procedure checks whether there is any duplicated lines in
49 -- the batch.
50 --
51 -- PARAMETERS
52 --
53 --
54 -- NOTES
55 ---------------------------------------------------------------------
56 PROCEDURE Check_Duplicates(
57 itemtype IN VARCHAR2,
58 itemkey IN VARCHAR2,
59 actid IN NUMBER,
60 funcmode IN VARCHAR2,
61 resultout IN OUT NOCOPY VARCHAR2
62 );
63
64 ---------------------------------------------------------------------
65 -- PROCEDURE
66 -- Get_Auto_Accrual_Flag
67 --
68 -- PURPOSE
69 -- This procedure returns values of auto_tp_accrual_flag from system parameter
70 --
71 -- PARAMETERS
72 --
73 --
74 -- NOTES
75 ---------------------------------------------------------------------
76 PROCEDURE Get_Auto_Accrual_Flag(
77 itemtype IN VARCHAR2,
78 itemkey IN VARCHAR2,
79 actid IN NUMBER,
80 funcmode IN VARCHAR2,
81 resultout IN OUT NOCOPY VARCHAR2
82 );
83
84 ---------------------------------------------------------------------
85 -- PROCEDURE
86 -- Get_Batch_Caller
87 --
88 -- PURPOSE
89 -- This procedure returns the value of OZF_RESALE_BATCH_CALLER
90 --
91 -- PARAMETERS
92 --
93 --
94 -- NOTES
95 ---------------------------------------------------------------------
96 PROCEDURE Get_Batch_Caller(
97 itemtype IN VARCHAR2,
98 itemkey IN VARCHAR2,
99 actid IN NUMBER,
100 funcmode IN VARCHAR2,
101 resultout IN OUT NOCOPY VARCHAR2
102 );
103
104 ---------------------------------------------------------------------
105 -- PROCEDURE
106 -- Get_Batch_Status
107 --
108 -- PURPOSE
109 -- This procedure returns the value of batch status
110 --
111 -- PARAMETERS
112 --
113 --
114 -- NOTES
115 ---------------------------------------------------------------------
116 PROCEDURE Get_Batch_Status (
117 itemtype IN VARCHAR2,
118 itemkey IN VARCHAR2,
119 actid IN NUMBER,
120 funcmode IN VARCHAR2,
121 resultout IN OUT NOCOPY VARCHAR2
122 );
123
124 ---------------------------------------------------------------------
125 -- PROCEDURE
126 -- Get_Batch_Type
127 --
128 -- PURPOSE
129 -- This procedure returns the value of OZF_RESALE_BATCH_TYPE
130 --
131 -- PARAMETERS
132 --
133 --
134 -- NOTES
135 ---------------------------------------------------------------------
136 PROCEDURE Get_Batch_Type(
137 itemtype IN VARCHAR2,
138 itemkey IN VARCHAR2,
139 actid IN NUMBER,
140 funcmode IN VARCHAR2,
141 resultout IN OUT NOCOPY VARCHAR2
142 );
143
144 ---------------------------------------------------------------------
145 -- PROCEDURE
146 -- Init_attributes
147 --
148 -- PURPOSE
149 -- This api will be initialize the attributes used IN the workflow
150 --
151 ---------------------------------------------------------------------
152 PROCEDURE Init_Attributes(
153 itemtype IN VARCHAR2,
154 itemkey IN VARCHAR2,
155 actid IN NUMBER,
156 funcmode IN VARCHAR2,
157 result OUT NOCOPY VARCHAR2
158 ) ;
159
160 ---------------------------------------------------------------------
161 -- PROCEDURE
162 -- Initiate_Payment
163 --
164 -- PURPOSE
165 -- This procedure inities payment processing
166 --
167 -- PARAMETERS
168 --
169 --
170 -- NOTES
171 ---------------------------------------------------------------------
172 PROCEDURE Initiate_Payment (
173 itemtype IN VARCHAR2,
174 itemkey IN VARCHAR2,
175 actid IN NUMBER,
176 funcmode IN VARCHAR2,
177 resultout IN OUT NOCOPY VARCHAR2
178 );
179
180
181 ---------------------------------------------------------------------
182 -- PROCEDURE
183 -- Initiate_Payment_chargeback
184 --
185 -- PURPOSE
186 -- This procedure inities payment processing for chargeback
187 --
188 -- PARAMETERS
189 --
190 --
191 -- NOTES
192 ---------------------------------------------------------------------
193 PROCEDURE Initiate_Payment_Chargeback (
194 itemtype IN VARCHAR2,
195 itemkey IN VARCHAR2,
196 actid IN NUMBER,
197 funcmode IN VARCHAR2,
198 resultout IN OUT NOCOPY VARCHAR2
199 );
200
201
202 ---------------------------------------------------------------------
203 -- PROCEDURE
204 -- Initiate_Payment_SPP
205 --
206 -- PURPOSE
207 -- This procedure inities payment processing for special pricing
208 --
209 -- PARAMETERS
210 --
211 --
212 -- NOTES
213 ---------------------------------------------------------------------
214 PROCEDURE Initiate_Payment_SPP(
215 itemtype IN VARCHAR2,
216 itemkey IN VARCHAR2,
217 actid IN NUMBER,
218 funcmode IN VARCHAR2,
219 resultout IN OUT NOCOPY VARCHAR2
220 );
221
222 ---------------------------------------------------------------------
223 -- PROCEDURE
224 -- Initiate_Payment_Tracing
225 --
226 -- PURPOSE
227 -- This procedure inities payment processing for tracing order
228 --
229 -- PARAMETERS
230 --
231 --
232 -- NOTES
233 ---------------------------------------------------------------------
234 PROCEDURE Initiate_Payment_Tracing (
235 itemtype IN VARCHAR2,
236 itemkey IN VARCHAR2,
237 actid IN NUMBER,
238 funcmode IN VARCHAR2,
239 resultout IN OUT NOCOPY VARCHAR2
240 );
241
242 ---------------------------------------------------------------------
243 -- PROCEDURE
244 -- Process_Chargeback
245 --
246 -- PURPOSE
247 -- This procedure initiates processing of orders for chargeback
248 --
249 -- PARAMETERS
250 --
251 --
252 -- NOTES
253 ---------------------------------------------------------------------
254 PROCEDURE Process_Chargeback(
255 itemtype IN VARCHAR2,
256 itemkey IN VARCHAR2,
257 actid IN NUMBER,
258 funcmode IN VARCHAR2,
259 resultout IN OUT NOCOPY VARCHAR2
260 );
261
262 ---------------------------------------------------------------------
263 -- PROCEDURE
264 -- Process_Resale
265 --
266 -- PURPOSE
267 -- This procedure initiates third party accrual process for resale data
268 --
269 -- PARAMETERS
270 --
271 --
272 -- NOTES
273 ---------------------------------------------------------------------
274 PROCEDURE Process_Resale(
275 itemtype IN VARCHAR2,
276 itemkey IN VARCHAR2,
277 actid IN NUMBER,
278 funcmode IN VARCHAR2,
279 resultout IN OUT NOCOPY VARCHAR2
280 );
281
282 ---------------------------------------------------------------------
283 -- PROCEDURE
284 -- Process_Special_Pricing
285 --
286 -- PURPOSE
287 -- This procedure initiates processing of orders for Special_Pricing
288 --
289 -- PARAMETERS
290 --
291 --
292 -- NOTES
293 ---------------------------------------------------------------------
294 PROCEDURE Process_Special_Pricing(
295 itemtype IN VARCHAR2,
296 itemkey IN VARCHAR2,
297 actid IN NUMBER,
298 funcmode IN VARCHAR2,
299 resultout IN OUT NOCOPY VARCHAR2
300 );
301
302 ---------------------------------------------------------------------
303 -- PROCEDURE
304 -- Process_Tracing
305 --
306 -- PURPOSE
307 -- This procedure initiates processing of orders for tracing data.
308 --
309 -- PARAMETERS
310 --
311 --
312 -- NOTES
313 ---------------------------------------------------------------------
314 PROCEDURE Process_Tracing(
315 itemtype IN VARCHAR2,
316 itemkey IN VARCHAR2,
317 actid IN NUMBER,
318 funcmode IN VARCHAR2,
319 resultout IN OUT NOCOPY VARCHAR2
320 );
321
322 ---------------------------------------------------------------------
323 -- PROCEDURE
324 -- Reset_Status
325 --
326 -- PURPOSE
327 -- This procedure is to reset the status of a batch in case of exceptions
328 --
329 -- PARAMETERS
330 --
331 --
332 -- NOTES
333 ---------------------------------------------------------------------
334 PROCEDURE Reset_Status(
335 itemtype IN VARCHAR2,
336 itemkey IN VARCHAR2,
337 actid IN NUMBER,
338 funcmode IN VARCHAR2,
339 result OUT NOCOPY VARCHAR2
340 );
341
342 ---------------------------------------------------------------------
343 -- PROCEDURE
344 -- Set_Batch_Status
345 --
346 -- PURPOSE
347 -- This procedure set the batch status
348 --
349 -- PARAMETERS
350 --
351 --
352 -- NOTES
353 ---------------------------------------------------------------------
354 PROCEDURE Set_Batch_Status(
355 itemtype IN VARCHAR2,
356 itemkey IN VARCHAR2,
357 actid IN NUMBER,
358 funcmode IN VARCHAR2,
359 resultout IN OUT NOCOPY VARCHAR2
360 );
361
362 ---------------------------------------------------------------------
363 -- PROCEDURE
364 -- Set_Payment_Pending
365 --
366 -- PURPOSE
367 -- This procedure set the batch status to Payment_Pending
368 --
369 -- PARAMETERS
370 --
371 --
372 -- NOTES
373 ---------------------------------------------------------------------
374 PROCEDURE Set_Payment_Pending(
375 itemtype IN VARCHAR2,
376 itemkey IN VARCHAR2,
380 );
377 actid IN NUMBER,
378 funcmode IN VARCHAR2,
379 resultout IN OUT NOCOPY VARCHAR2
381
382 ---------------------------------------------------------------------
383 -- PROCEDURE
384 -- Set_Tolerance_Level
385 --
386 -- PURPOSE
387 -- This procedure set the batch status
388 --
389 -- PARAMETERS
390 --
391 --
392 -- NOTES
393 ---------------------------------------------------------------------
394 PROCEDURE Set_Tolerance_Level(
395 itemtype IN VARCHAR2,
396 itemkey IN VARCHAR2,
397 actid IN NUMBER,
398 funcmode IN VARCHAR2,
399 resultout IN OUT NOCOPY VARCHAR2
400 );
401
402 ---------------------------------------------------------------------
403 -- PROCEDURE
404 -- Validate_Batch
405 --
406 -- PURPOSE
407 -- This procedure validates the batch details
408 --
409 -- PARAMETERS
410 --
411 --
412 -- NOTES
413 ---------------------------------------------------------------------
414 PROCEDURE Validate_Batch(
415 itemtype IN VARCHAR2,
416 itemkey IN VARCHAR2,
417 actid IN NUMBER,
418 funcmode IN VARCHAR2,
419 resultout IN OUT NOCOPY VARCHAR2
420 );
421
422 ---------------------------------------------------------------------
423 -- PROCEDURE
424 -- Validate_Order
425 --
426 -- PURPOSE
427 -- This procedure contains order level validations
428 --
429 -- PARAMETERS
430 --
431 --
432 -- NOTES
433 ---------------------------------------------------------------------
434 PROCEDURE Validate_Order(
435 itemtype IN VARCHAR2,
436 itemkey IN VARCHAR2,
437 actid IN NUMBER,
438 funcmode IN VARCHAR2,
439 resultout IN OUT NOCOPY VARCHAR2
440 );
441
442 ---------------------------------------------------------------------
443 -- PROCEDURE
444 -- Validate_Chargeback
445 --
446 -- PURPOSE
447 -- This procedure contains chargeback validations
448 --
449 -- PARAMETERS
450 --
451 --
452 -- NOTES
453 ---------------------------------------------------------------------
454 PROCEDURE Validate_Chargeback (
455 itemtype IN VARCHAR2,
456 itemkey IN VARCHAR2,
457 actid IN NUMBER,
458 funcmode IN VARCHAR2,
459 resultout IN OUT NOCOPY VARCHAR2
460 );
461
462 ---------------------------------------------------------------------
463 -- PROCEDURE
464 -- Validate_Special_Pricing
465 --
466 -- PURPOSE
467 -- This procedure contains Special Pricing data validations
468 --
469 -- PARAMETERS
470 --
471 --
472 -- NOTES
473 ---------------------------------------------------------------------
474 PROCEDURE Validate_Special_Pricing(
475 itemtype IN VARCHAR2,
476 itemkey IN VARCHAR2,
477 actid IN NUMBER,
478 funcmode IN VARCHAR2,
479 resultout IN OUT NOCOPY VARCHAR2
480 );
481
482 ---------------------------------------------------------------------
483 -- PROCEDURE
484 -- Validate_Tracing
485 --
486 -- PURPOSE
487 -- This procedure contains tracing data validations
488 --
489 -- PARAMETERS
490 --
491 --
492 -- NOTES
493 ---------------------------------------------------------------------
494 PROCEDURE Validate_Tracing(
495 itemtype IN VARCHAR2,
496 itemkey IN VARCHAR2,
497 actid IN NUMBER,
498 funcmode IN VARCHAR2,
499 resultout IN OUT NOCOPY VARCHAR2
500 );
501
502
503 ---------------------------------------------------------------------
504 -- PROCEDURE
505 -- Start_Data_Process
506 --
507 -- PURPOSE
508 --
509 --
510 -- PARAMETERS
511 --
512 --
513 -- NOTES
514 ---------------------------------------------------------------------
515 PROCEDURE Start_Data_Process(
516 p_resale_batch_id IN NUMBER
517 ,p_caller_type IN VARCHAR2
518 );
519
520 ---------------------------------------------------------------------
521 -- PROCEDURE
522 -- Start_Data_Process
523 --
524 -- PURPOSE
525 --
526 --
527 -- PARAMETERS
528 --
529 --
530 -- NOTES
531 ---------------------------------------------------------------------
532 PROCEDURE Start_Batch_Payment(
533 p_resale_batch_id IN NUMBER
534 ,p_caller_type IN VARCHAR2
535 );
536
537
538 END OZF_RESALE_WF_PVT;