[Home] [Help]
PACKAGE: APPS.OZF_RESALE_WF_PVT
Source
1 PACKAGE OZF_RESALE_WF_PVT AUTHID CURRENT_USER AS
2 /* $Header: ozfvrwfs.pls 120.5.12020000.2 2012/07/20 08:50:55 nepanda 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 --//Bugfix : 10431933
38 G_WF_ATTR_USER_ID CONSTANT VARCHAR2(30) := 'OZF_USER_ID';
39 G_WF_ATTR_RESP_ID CONSTANT VARCHAR2(30) := 'OZF_RESPONSIBILITY_ID';
40 G_WF_ATTR_APPL_ID CONSTANT VARCHAR2(30) := 'OZF_APPLICATION_ID';
41
42 CURSOR g_batch_type_csr (p_id NUMBER)IS
43 SELECT batch_type
44 FROM ozf_resale_batches_all
45 WHERE resale_batch_id = p_id;
46
47
48 ---------------------------------------------------------------------
49 -- PROCEDURE
50 -- Check_Duplicates
51 --
52 -- PURPOSE
53 -- This procedure checks whether there is any duplicated lines in
54 -- the batch.
55 --
56 -- PARAMETERS
57 --
58 --
59 -- NOTES
60 ---------------------------------------------------------------------
61 PROCEDURE Check_Duplicates(
62 itemtype IN VARCHAR2,
63 itemkey IN VARCHAR2,
64 actid IN NUMBER,
65 funcmode IN VARCHAR2,
66 resultout IN OUT NOCOPY VARCHAR2
67 );
68
69 ---------------------------------------------------------------------
70 -- PROCEDURE
71 -- Get_Auto_Accrual_Flag
72 --
73 -- PURPOSE
74 -- This procedure returns values of auto_tp_accrual_flag from system parameter
75 --
76 -- PARAMETERS
77 --
78 --
79 -- NOTES
80 ---------------------------------------------------------------------
81 PROCEDURE Get_Auto_Accrual_Flag(
82 itemtype IN VARCHAR2,
83 itemkey IN VARCHAR2,
84 actid IN NUMBER,
85 funcmode IN VARCHAR2,
86 resultout IN OUT NOCOPY VARCHAR2
87 );
88
89 ---------------------------------------------------------------------
90 -- PROCEDURE
91 -- Get_Batch_Caller
92 --
93 -- PURPOSE
94 -- This procedure returns the value of OZF_RESALE_BATCH_CALLER
95 --
96 -- PARAMETERS
97 --
98 --
99 -- NOTES
100 ---------------------------------------------------------------------
101 PROCEDURE Get_Batch_Caller(
102 itemtype IN VARCHAR2,
103 itemkey IN VARCHAR2,
104 actid IN NUMBER,
105 funcmode IN VARCHAR2,
106 resultout IN OUT NOCOPY VARCHAR2
107 );
108
109 ---------------------------------------------------------------------
110 -- PROCEDURE
111 -- Get_Batch_Status
112 --
113 -- PURPOSE
114 -- This procedure returns the value of batch status
115 --
116 -- PARAMETERS
117 --
118 --
119 -- NOTES
120 ---------------------------------------------------------------------
121 PROCEDURE Get_Batch_Status (
122 itemtype IN VARCHAR2,
123 itemkey IN VARCHAR2,
124 actid IN NUMBER,
125 funcmode IN VARCHAR2,
126 resultout IN OUT NOCOPY VARCHAR2
127 );
128
129 ---------------------------------------------------------------------
130 -- PROCEDURE
131 -- Get_Batch_Type
132 --
133 -- PURPOSE
134 -- This procedure returns the value of OZF_RESALE_BATCH_TYPE
135 --
136 -- PARAMETERS
137 --
138 --
139 -- NOTES
140 ---------------------------------------------------------------------
141 PROCEDURE Get_Batch_Type(
142 itemtype IN VARCHAR2,
143 itemkey IN VARCHAR2,
144 actid IN NUMBER,
145 funcmode IN VARCHAR2,
146 resultout IN OUT NOCOPY VARCHAR2
147 );
148
149 ---------------------------------------------------------------------
150 -- PROCEDURE
151 -- Init_attributes
152 --
153 -- PURPOSE
154 -- This api will be initialize the attributes used IN the workflow
155 --
156 ---------------------------------------------------------------------
157 PROCEDURE Init_Attributes(
158 itemtype IN VARCHAR2,
159 itemkey IN VARCHAR2,
160 actid IN NUMBER,
161 funcmode IN VARCHAR2,
162 result OUT NOCOPY VARCHAR2
163 ) ;
164
165 ---------------------------------------------------------------------
166 -- PROCEDURE
167 -- Initiate_Payment
168 --
169 -- PURPOSE
170 -- This procedure inities payment processing
171 --
172 -- PARAMETERS
173 --
174 --
175 -- NOTES
176 ---------------------------------------------------------------------
177 PROCEDURE Initiate_Payment (
178 itemtype IN VARCHAR2,
179 itemkey IN VARCHAR2,
180 actid IN NUMBER,
181 funcmode IN VARCHAR2,
182 resultout IN OUT NOCOPY VARCHAR2
183 );
184
185
186 ---------------------------------------------------------------------
187 -- PROCEDURE
188 -- Initiate_Payment_chargeback
189 --
190 -- PURPOSE
191 -- This procedure inities payment processing for chargeback
192 --
193 -- PARAMETERS
194 --
195 --
196 -- NOTES
197 ---------------------------------------------------------------------
198 PROCEDURE Initiate_Payment_Chargeback (
199 itemtype IN VARCHAR2,
200 itemkey IN VARCHAR2,
201 actid IN NUMBER,
202 funcmode IN VARCHAR2,
203 resultout IN OUT NOCOPY VARCHAR2
204 );
205
206
207 ---------------------------------------------------------------------
208 -- PROCEDURE
209 -- Initiate_Payment_SPP
210 --
211 -- PURPOSE
212 -- This procedure inities payment processing for special pricing
213 --
214 -- PARAMETERS
215 --
216 --
217 -- NOTES
218 ---------------------------------------------------------------------
219 PROCEDURE Initiate_Payment_SPP(
220 itemtype IN VARCHAR2,
221 itemkey IN VARCHAR2,
222 actid IN NUMBER,
223 funcmode IN VARCHAR2,
224 resultout IN OUT NOCOPY VARCHAR2
225 );
226
227 ---------------------------------------------------------------------
228 -- PROCEDURE
229 -- Initiate_Payment_Tracing
230 --
231 -- PURPOSE
232 -- This procedure inities payment processing for tracing order
233 --
234 -- PARAMETERS
235 --
236 --
237 -- NOTES
238 ---------------------------------------------------------------------
239 PROCEDURE Initiate_Payment_Tracing (
240 itemtype IN VARCHAR2,
241 itemkey IN VARCHAR2,
242 actid IN NUMBER,
243 funcmode IN VARCHAR2,
244 resultout IN OUT NOCOPY VARCHAR2
245 );
246
247 ---------------------------------------------------------------------
248 -- PROCEDURE
249 -- Process_Chargeback
250 --
251 -- PURPOSE
252 -- This procedure initiates processing of orders for chargeback
253 --
254 -- PARAMETERS
255 --
256 --
257 -- NOTES
258 ---------------------------------------------------------------------
259 PROCEDURE Process_Chargeback(
260 itemtype IN VARCHAR2,
261 itemkey IN VARCHAR2,
262 actid IN NUMBER,
263 funcmode IN VARCHAR2,
264 resultout IN OUT NOCOPY VARCHAR2
265 );
266
267 ---------------------------------------------------------------------
268 -- PROCEDURE
269 -- Process_Resale
270 --
271 -- PURPOSE
272 -- This procedure initiates third party accrual process for resale data
273 --
274 -- PARAMETERS
275 --
276 --
277 -- NOTES
278 ---------------------------------------------------------------------
279 PROCEDURE Process_Resale(
280 itemtype IN VARCHAR2,
281 itemkey IN VARCHAR2,
282 actid IN NUMBER,
283 funcmode IN VARCHAR2,
284 resultout IN OUT NOCOPY VARCHAR2
285 );
286
287 ---------------------------------------------------------------------
288 -- PROCEDURE
289 -- Process_Special_Pricing
290 --
291 -- PURPOSE
292 -- This procedure initiates processing of orders for Special_Pricing
293 --
294 -- PARAMETERS
295 --
296 --
297 -- NOTES
298 ---------------------------------------------------------------------
299 PROCEDURE Process_Special_Pricing(
300 itemtype IN VARCHAR2,
301 itemkey IN VARCHAR2,
302 actid IN NUMBER,
303 funcmode IN VARCHAR2,
304 resultout IN OUT NOCOPY VARCHAR2
305 );
306
307 ---------------------------------------------------------------------
308 -- PROCEDURE
309 -- Process_Tracing
310 --
311 -- PURPOSE
312 -- This procedure initiates processing of orders for tracing data.
313 --
314 -- PARAMETERS
315 --
316 --
317 -- NOTES
318 ---------------------------------------------------------------------
319 PROCEDURE Process_Tracing(
320 itemtype IN VARCHAR2,
321 itemkey IN VARCHAR2,
322 actid IN NUMBER,
323 funcmode IN VARCHAR2,
324 resultout IN OUT NOCOPY VARCHAR2
325 );
326
327 ---------------------------------------------------------------------
328 -- PROCEDURE
329 -- Reset_Status
330 --
331 -- PURPOSE
332 -- This procedure is to reset the status of a batch in case of exceptions
333 --
334 -- PARAMETERS
335 --
336 --
337 -- NOTES
338 ---------------------------------------------------------------------
339 PROCEDURE Reset_Status(
340 itemtype IN VARCHAR2,
341 itemkey IN VARCHAR2,
342 actid IN NUMBER,
343 funcmode IN VARCHAR2,
344 result OUT NOCOPY VARCHAR2
348 -- PROCEDURE
345 );
346
347 ---------------------------------------------------------------------
349 -- Set_Batch_Status
350 --
351 -- PURPOSE
352 -- This procedure set the batch status
353 --
354 -- PARAMETERS
355 --
356 --
357 -- NOTES
358 ---------------------------------------------------------------------
359 PROCEDURE Set_Batch_Status(
360 itemtype IN VARCHAR2,
361 itemkey IN VARCHAR2,
362 actid IN NUMBER,
363 funcmode IN VARCHAR2,
364 resultout IN OUT NOCOPY VARCHAR2
365 );
366
367 ---------------------------------------------------------------------
368 -- PROCEDURE
369 -- Set_Payment_Pending
370 --
371 -- PURPOSE
372 -- This procedure set the batch status to Payment_Pending
373 --
374 -- PARAMETERS
375 --
376 --
377 -- NOTES
378 ---------------------------------------------------------------------
379 PROCEDURE Set_Payment_Pending(
380 itemtype IN VARCHAR2,
381 itemkey IN VARCHAR2,
382 actid IN NUMBER,
383 funcmode IN VARCHAR2,
384 resultout IN OUT NOCOPY VARCHAR2
385 );
386
387 ---------------------------------------------------------------------
388 -- PROCEDURE
389 -- Set_Tolerance_Level
390 --
391 -- PURPOSE
392 -- This procedure set the batch status
393 --
394 -- PARAMETERS
395 --
396 --
397 -- NOTES
398 ---------------------------------------------------------------------
399 PROCEDURE Set_Tolerance_Level(
400 itemtype IN VARCHAR2,
401 itemkey IN VARCHAR2,
402 actid IN NUMBER,
403 funcmode IN VARCHAR2,
404 resultout IN OUT NOCOPY VARCHAR2
405 );
406
407 ---------------------------------------------------------------------
408 -- PROCEDURE
409 -- Validate_Batch
410 --
411 -- PURPOSE
412 -- This procedure validates the batch details
413 --
414 -- PARAMETERS
415 --
416 --
417 -- NOTES
418 ---------------------------------------------------------------------
419 PROCEDURE Validate_Batch(
420 itemtype IN VARCHAR2,
421 itemkey IN VARCHAR2,
422 actid IN NUMBER,
423 funcmode IN VARCHAR2,
424 resultout IN OUT NOCOPY VARCHAR2
425 );
426
427 ---------------------------------------------------------------------
428 -- PROCEDURE
429 -- Validate_Order
430 --
431 -- PURPOSE
432 -- This procedure contains order level validations
433 --
434 -- PARAMETERS
435 --
436 --
437 -- NOTES
438 ---------------------------------------------------------------------
439 PROCEDURE Validate_Order(
440 itemtype IN VARCHAR2,
441 itemkey IN VARCHAR2,
442 actid IN NUMBER,
443 funcmode IN VARCHAR2,
444 resultout IN OUT NOCOPY VARCHAR2
445 );
446
447 ---------------------------------------------------------------------
448 -- PROCEDURE
449 -- Validate_Chargeback
450 --
451 -- PURPOSE
452 -- This procedure contains chargeback validations
453 --
454 -- PARAMETERS
455 --
456 --
457 -- NOTES
458 ---------------------------------------------------------------------
459 PROCEDURE Validate_Chargeback (
460 itemtype IN VARCHAR2,
461 itemkey IN VARCHAR2,
462 actid IN NUMBER,
463 funcmode IN VARCHAR2,
464 resultout IN OUT NOCOPY VARCHAR2
465 );
466
467 ---------------------------------------------------------------------
468 -- PROCEDURE
469 -- Validate_Special_Pricing
470 --
471 -- PURPOSE
472 -- This procedure contains Special Pricing data validations
473 --
474 -- PARAMETERS
475 --
476 --
477 -- NOTES
478 ---------------------------------------------------------------------
479 PROCEDURE Validate_Special_Pricing(
480 itemtype IN VARCHAR2,
481 itemkey IN VARCHAR2,
482 actid IN NUMBER,
483 funcmode IN VARCHAR2,
484 resultout IN OUT NOCOPY VARCHAR2
485 );
486
487 ---------------------------------------------------------------------
488 -- PROCEDURE
489 -- Validate_Tracing
490 --
491 -- PURPOSE
492 -- This procedure contains tracing data validations
493 --
494 -- PARAMETERS
495 --
496 --
497 -- NOTES
498 ---------------------------------------------------------------------
499 PROCEDURE Validate_Tracing(
500 itemtype IN VARCHAR2,
501 itemkey IN VARCHAR2,
502 actid IN NUMBER,
503 funcmode IN VARCHAR2,
504 resultout IN OUT NOCOPY VARCHAR2
505 );
506
507
508 ---------------------------------------------------------------------
509 -- PROCEDURE
510 -- Start_Data_Process
511 --
512 -- PURPOSE
513 --
514 --
515 -- PARAMETERS
516 --
517 --
518 -- NOTES
519 ---------------------------------------------------------------------
520 PROCEDURE Start_Data_Process(
521 p_resale_batch_id IN NUMBER
522 ,p_caller_type IN VARCHAR2
523 );
524
525 ---------------------------------------------------------------------
526 -- PROCEDURE
527 -- Start_Data_Process
528 --
529 -- PURPOSE
530 --
531 --
532 -- PARAMETERS
533 --
534 --
535 -- NOTES
536 ---------------------------------------------------------------------
537 PROCEDURE Start_Batch_Payment(
538 p_resale_batch_id IN NUMBER
539 ,p_caller_type IN VARCHAR2
540 );
541
542 --nepanda : Fix for Bug 13819601
543 ---------------------------------------------------------------------
544 -- PROCEDURE
545 -- SET_CONTEXT
546 --
547 -- PURPOSE
548 -- This is a selector function for OZF Resale Interface Data Processing.
549 -- This method is called everytime a new process is called in the above workflow for an Item.
550 -- Its 1st called in mode TEST_CTX, if the context is set properly then returns with result = TRUE.
551 -- if the context is not set, then returns with result = NOTSET .
552 -- If result is NOTSET then this procedure is called again with Mode SET_CTX and correct context is set.
553 --
554 -- PARAMETERS
555 --
556 --
557 -- NOTES
558 ---------------------------------------------------------------------
559 PROCEDURE SET_CONTEXT
560 ( p_itemtype in varchar2
561 , p_itemkey in varchar2
562 , p_actid in number
563 , p_funcmode in varchar2
564 , p_resultout in out nocopy varchar2
565 );
566
567 END OZF_RESALE_WF_PVT;