eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.PMT_UTIL

Source


1 package PMT_UTIL AUTHID CURRENT_USER as
2 /* $Header: ARPSUTLS.pls 120.5 2005/10/30 03:56:24 appldev ship $*/
3 /*
4 Types created from SET extended operations. Since SET supports group
5 operations, we need to input a list of OapfOrderId, etc.
6 Therefore, SETOapfOrderId is declared as a table of OapfOrderId and
7 starts from 0 for compatibility with 1.0
8 */
9 TYPE SETOapfOrderId is table of varchar2(80) index by binary_integer;
10 TYPE SETOapfSplitId is table of varchar2(80) index by binary_integer;
11 TYPE SETOapfPrice is table of varchar2(80) index by binary_integer;
12 TYPE SETOapfCurr is table of varchar2(80) index by binary_integer;
13 TYPE SETOapfTerminalId is table of varchar2(80) index by binary_integer;
14 TYPE SETOapfMerchBatchId is table of varchar2(80) index by binary_integer;
15 TYPE SETOapfCapCode is table of varchar2(80) index by binary_integer;
16 TYPE SETOapfPmtInstrType is table of varchar2(80) index by binary_integer;
17 TYPE SETOapfRefcode is table of varchar2(80) index by binary_integer;
18 TYPE SETOapfCreditCounter is table of varchar2(80) index by binary_integer;
19 TYPE SETOapfBatchSequenceNum is table of varchar2(80) index by binary_integer;
20 TYPE in_oraauth IS RECORD (
21 	OapfAction char(7) NOT NULL := 'oraauth',
22 	OapfOrderId varchar2(80),
23 	OapfCurr varchar2(80),
24 	OapfPrice varchar2(80),
25 	OapfAuthType varchar2(80),
26 	OapfPmtType varchar2(80),
27 	OapfPmtInstrID varchar2(80),
28 	OapfPmtInstrExp varchar2(80),
29 	OapfStoreId varchar2(80),
30 	OapfcustName varchar2(80),
31 	OapfAddr1 varchar2(80),
32 	OapfAddr2 varchar2(80),
33 	OapfAddr3 varchar2(80),
34 	OapfCity varchar2(80),
35 	OapfCnty varchar2(80),
36 	OapfState varchar2(80),
37 	OapfCntry varchar2(80),
38 	OapfPostalCode varchar2(80),
39 	OapfPhone varchar2(80),
40 	OapfEmail varchar2(80),
41         OapfRefNumber varchar2(80),
42         OapfTrxnRef varchar2(80),
43 /*
44 SET name-value pairs.
45 */
46 	OapfNlsLang varchar2(80),
47 	OapfAPIScheme varchar2(80),
48 	OapfTerminalId varchar2(80),
49 	OapfMerchBatchId varchar2(80),
50 	OapfBatchSequenceNum varchar2(80),
51 	OapfSplitShipment varchar2(80),
52 	OapfAuthCurr varchar2(80),
53 	OapfAuthPrice varchar2(80),
54 	OapfInstallTotalTrans varchar2(80),
55 	OapfRecurringFreq varchar2(80),
56 	oapfRecurringExpiryDate varchar2(80),
57 	OapfCustomerReferenceNumber varchar2(80),
58 	OapfDestinationPostalCode varchar2(80),
59 	OapfLocalTaxPrice varchar2(80),
60 	OapfLocalTaxCurr varchar2(80)
61 	  );
62 TYPE out_oraauth IS RECORD (
63 	OapfOrderId varchar2(80),
64 	OapfTrxnType varchar2(80),
65 	OapfStatus varchar2(20), /* Modified for PS 2.0 */
66         OapfStatusMsg varchar2(200),     /* Added for PS 2.0 */
67         OapfApprovalCode varchar2(80),  /* Added for PS 2.0 */
68 	OapfRefcode varchar2(80),
69 	OapfAVScode varchar2(80),
70 	OapfTrxnDate varchar2(80),
71 	OapfPmtInstrType varchar2(80),
72 	OapfErrLocation varchar2(80),
73 	OapfVendErrCode varchar2(80),
74 	OapfVendErrmsg varchar2(255),
75 	OapfAcquirer varchar2(80),
76 	OapfAuxMsg varchar2(80),
77 /*
78 SET name-value pairs.
79 */
80 	OapfSplitId varchar2(80),
81 	OapfMerchBatchId varchar2(80),
82 	OapfCapCode varchar2(80),
83 	OapfCardCurr varchar2(80),
84 	OapfCurrConvRate varchar2(80),
85 	OapfTerminalId varchar2(80) );
86 procedure oraauth (baseurl in varchar2,
87                    inparam in in_oraauth,
88 		   outparam out NOCOPY out_oraauth);
89 
90 /*
91 --------------------------orasubsequentauth----------------------------
92 baseurl: URL address for payment server + /orapmt/OraPmt?
93 in_orasubsequentauth: input name-value pairs
94 out_orasubsequentauth:output name-value pairs
95 */
96 TYPE in_orasubsequentauth IS RECORD (
97 	OapfAction char(17) NOT NULL:='orasubsequentauth',
98 	OapfAPIScheme char(11) NOT NULL:='ExtendedSET',
99 	OapfOrderId varchar2(80),
100 	OapfPrevSplitId varchar2(80),
101 	OapfSplitId varchar2(80),
102 	OapfCurr varchar2(80),
103 	OapfPrice varchar2(80),
104 	OapfAuthType varchar2(80),
105 	OapfPmtType varchar2(80),
106 	OapfStoreId varchar2(80),
107 	OapfSubsequentAuthInd varchar2(80),
108 	OapfNlsLang varchar2(80));
109 TYPE out_orasubsequentauth IS RECORD (
110 	OapfOrderId varchar2(80),
111 	OapfSplitId varchar2(80),
112 	OapfTrxnType varchar2(80),
113 	OapfStatus varchar2(80),
114 	OapfAuthcode varchar2(80),
115 	OapfNlsLang varchar2(80),
116 	OapfRefcode varchar2(80),
117 	OapfAVScode varchar2(80),
118 	OapfTrxnDate varchar2(80),
119 	OapfPmtInstrType varchar2(80),
120 	OapfErrLocation varchar2(80),
121 	OapfVendErrCode varchar2(80),
122 	OapfVendErrmsg varchar2(80),
123 	OapfAcquirer varchar2(80),
124 	OapfMerchBatchId varchar2(80),
125 	OapfVpsBatchId varchar2(80),
126 	OapfAuxMsg varchar2(80),
127 	OapfCapCode varchar2(80));
128 procedure orasubsequentauth (baseurl in varchar2,
129 			     inparam in in_orasubsequentauth,
130 			     outparam out NOCOPY out_orasubsequentauth);
131 
132 /*
133 -----------------------------oracapture-------------------------------------
134 baseurl:url address for payment server + /orapmt/OraPmt?
135 in_oracapture: type record for input name-value pairs
136 out_oracapture: type record for output name-value pairs
137 
138 */
139 TYPE in_oracapture IS RECORD (
140         OapfAction varchar2(20) NOT NULL:= 'oracapture',
141         OapfOrderId varchar2(80),
142         OapfPrice varchar2(80),
143         OapfCurr varchar2(80),
144         OapfPmtType varchar2(80),
145         OapfStoreId varchar2(80),
146         OapfTrxnRef varchar2(80),
147         OapfCashRecId varchar2(80)
148 );
149 TYPE out_oracapture IS RECORD (
150         OapfOrderId varchar2(80),    /* Added for PS 2.0 */
151         OapfStatus varchar2(20),     /* Modified for PS 2.0 */
152         OapfStatusMsg varchar2(200),  /* Added for PS 2.0 */
153         OapfTrxnType varchar2(80),
154         OapfTrxnDate varchar2(80),
155         OapfPmtInstrType varchar2(80),
156         OapfRefcode varchar2(80),
157         OapfErrLocation varchar2(80),
158         OapfVendErrCode varchar2(80),
159         OapfVendErrmsg varchar2(255));
160 procedure oracapture(baseurl in varchar2,
161                      inparam in in_oracapture,
162                      outparam out NOCOPY out_oracapture);
163 
164 /*
165 ------------------------------oracapture for SET---------------------------
166 */
167 TYPE SETIN_oracapture IS RECORD (
168 	OapfAction char(10) NOT NULL := 'oracapture',
169 	OapfPmtType varchar2(80),
170 	OapfNlsLang varchar2(80),
171 	OapfAPIScheme char(11) NOT NULL := 'ExtendedSET',
172 	OapfNumTrxns number,
173 	OapfStoreId varchar2(80),
174 	OapfOrderId SETOapfOrderId,
175 	OapfSplitId SETOapfSplitId,
176 	OapfPrice SETOapfPrice,
177 	OapfCurr SETOapfCurr,
178 	OapfTerminalId SETOapfTerminalId,
179 	OapfMerchBatchId SETOapfMerchBatchId,
180 	OapfBatchSequenceNum SETOapfBatchSequenceNum);
181 TYPE SETsummary_oracapture IS RECORD (
182 	OapfStatus varchar2(80),
183 	OapfNumTrxns number,
184 	OapfTrxnType varchar2(80),
185 	OapfTrxnDate varchar2(80),
186 	OapfPmtInstrType varchar2(80),
187 	OapfRefcode varchar2(80),
188 	OapfErrLocation varchar2(80),
189 	OapfVendErrCode varchar2(80),
190 	OapfVendErrmsg varchar2(80));
191 TYPE SETreport_oracapture IS RECORD (
192 	OapfStatus varchar2(80),
193         OapfOrderId varchar2(80),
194 	OapfSplitId varchar2(80),
195 	OapfCurr varchar2(80),
196 	OapfPrice varchar2(80),
197 	OapfCapCode varchar2(80),
198 	OapfTerminalId varchar2(80),
199 	OapfPmtInstrType varchar2(80),
200 	OapfRefcode varchar2(80),
201 	OapfMerchBatchId varchar2(80),
202 	OapfBatchSequenceNum varchar2(80));
203 TYPE SETreportlst_oracapture is table of SETreport_oracapture index by binary_integer;
204 procedure oracapture(baseurl in varchar2,
205 		     inparam in SETIN_oracapture,
206 		     summary out NOCOPY SETsummary_oracapture,
207                      reportlst out NOCOPY SETreportlst_oracapture);
208 
209 
210 
211 /*
212 ------------------------------oravoid-----------------------------------------
213 baseurl:url address for payment server + /orapmt/OraPmt?
214 in_oravoid:type record for input name-value pairs
215            in_oravoid.OapfTrxnType should be number in according to the
216 	   corresponding actions such as Capture(8), MarkCapture(9),
217 	   Return(5). For details, see Appendix B in the developer's guide.
218 out_oravoid:type record for output name-value pairs
219 */
220 TYPE in_oravoid IS RECORD (
221         OapfAction varchar2(20) NOT NULL:= 'oravoid',
222 	OapfTrxnType varchar2(80) ,
223 	OapfPmtType varchar2(80),
224 	OapfOrderId varchar2(80),
225         OapfStoreId varchar2(80));
226 TYPE out_oravoid IS RECORD (
227         OapfStatus varchar2(80),
228         OapfTrxnType varchar2(80),
229         OapfTrxnDate varchar2(80),
230 	OapfPmtInstrType varchar2(80),
231 	OapfRefcode varchar2(80),
232 	OapfErrLocation varchar2(80),
233 	OapfVendErrCode varchar2(80),
234 	OapfVendErrmsg varchar2(80));
235 procedure oravoid (baseurl in varchar2,
236 		   inparam in in_oravoid,
237 	           outparam out NOCOPY out_oravoid);
238 
239 /*
240 ------------------------------oravoid for SET--------------------------------
241 */
242 TYPE SETIN_oravoid IS RECORD (
243 	OapfAction char(7) NOT NULL := 'oravoid',
244 	OapfTrxnType varchar2(80),
245 	OapfPmtType varchar2(80),
246 	OapfNlsLang varchar2(80),
247 	OapfAPIScheme varchar2(80) := 'ExtendedSET',
248 	OapfNumTrxns number,
249 	OapfStoreId varchar2(80),
250 	OapfOrderId  SETOapfOrderId,
251 	OapfSplitId SETOapfSplitId,
252 	OapfPrice   SETOapfPrice,
253 	OapfCurr    SETOapfCurr,
254 	OapfTerminalId SETOapfTerminalId,
255 	OapfMerchBatchId SETOapfMerchBatchId,
256 	OapfBatchSequenceNum SETOapfBatchSequenceNum);
257 TYPE SETsummary_oravoid IS RECORD (
258         OapfStatus varchar2(80),
259         OapfTrxnType varchar2(80),
260         OapfTrxnDate varchar2(80),
261         OapfPmtInstrType varchar2(80),
262         OapfRefcode varchar2(80),
263         OapfErrLocation varchar2(80),
264         OapfVendErrCode varchar2(80),
265         OapfNumTrxns number,
266         OapfVendErrmsg varchar2(80));
267 TYPE SETreport_oravoid IS RECORD (
268         OapfStatus varchar2(80),
269         OapfOrderId varchar2(80),
270         OapfSplitId varchar2(80),
271         OapfCapRevOrCreditCode varchar2(80),
272         OapfTerminalId varchar2(80),
273         OapfMerchBatchId varchar2(80),
274         OapfBatchSequenceNum varchar2(80));
275 TYPE SETreportlst_oravoid is table of SETreport_oravoid index by binary_integer;
276 procedure oravoid(baseurl in varchar2, inparam in SETIN_oravoid,
277 		  summary out NOCOPY SETsummary_oravoid,
278 		  reportlst out NOCOPY SETreportlst_oravoid);
279 
280 
281 /*
282 -------------------------------orareturn--------------------------------------
283 baseurl:url address for payment server + /orapmt/OraPmt?
284 in_orareturn:type record for input name-value pairs
285 out_orareturn:type record for output name-value pairs
286 */
287 TYPE in_orareturn IS RECORD (
288         OapfAction varchar2(20) NOT NULL:= 'orareturn',
289         OapfOrderId varchar2(80),
290         OapfPrice varchar2(80),
291         OapfCurr varchar2(80),
292         OapfStoreId varchar2(80),
293         OapfPmtType varchar2(80),
294         OapfPmtInstrID varchar2(80),
295         OapfPmtInstrExp varchar2(80),
296 	OapfMerchUsername varchar2(80),
297 	OapfMerchPasswd varchar2(80));
298 TYPE out_orareturn IS RECORD (
299         OapfStatus varchar2(80),
300         OapfTrxnType varchar2(80),
301         OapfTrxnDate varchar2(80),
302         OapfPmtInstrType varchar2(80),
303         OapfRefcode varchar2(80),
304         OapfErrLocation varchar2(80),
305         OapfVendErrCode varchar2(80),
306         OapfVendErrmsg varchar2(80));
307 procedure orareturn (baseurl in varchar2,
308                    inparam in in_orareturn,
309                    outparam out NOCOPY out_orareturn);
310 /*
311 ------------------------------orareturn for SET---------------------------
312 */
313 TYPE SETIN_orareturn IS RECORD (
314         OapfAction char(9) NOT NULL := 'orareturn',
315         OapfPrice SETOapfPrice,
316         OapfCurr SETOapfCurr,
317         OapfStoreId varchar2(80),
318         OapfSplitId SETOapfSplitId,
319         OapfPmtType varchar2(80),
320         OapfOrderId SETOapfOrderId,
321         OapfNlsLang varchar2(80),
322         OapfAPIScheme char(11) NOT NULL := 'ExtendedSET',
323         OapfNumTrxns number,
324 	OapfCreditCounter SETOapfCreditCounter,
325         OapfTerminalId SETOapfTerminalId,
326         OapfMerchBatchId SETOapfMerchBatchId,
327         OapfBatchSequenceNum SETOapfBatchSequenceNum);
328 TYPE SETsummary_orareturn IS RECORD (
329         OapfStatus varchar2(80),
330         OapfTrxnType varchar2(80),
331         OapfTrxnDate varchar2(80),
332         OapfPmtInstrType varchar2(80),
333         OapfNumTrxns number,
334         OapfRefcode varchar2(80),
335         OapfErrLocation varchar2(80),
336         OapfVendErrCode varchar2(80),
337         OapfVendErrmsg varchar2(80));
338 TYPE SETreport_orareturn IS RECORD (
339         OapfStatus varchar2(80),
340         OapfOrderId varchar2(80),
341         OapfSplitId varchar2(80),
342 	OapfCreditCounter varchar2(80),
343 	OapfCapRevOrCreditCode varchar2(80),
344         OapfTerminalId varchar2(80),
345         OapfMerchBatchId varchar2(80),
346         OapfBatchSequenceNum varchar2(80));
347 TYPE SETreportlst_orareturn is table of SETreport_orareturn index by binary_integer;
348 procedure orareturn(baseurl in varchar2,
349                     inparam in SETIN_orareturn,
350                     summary out NOCOPY SETsummary_orareturn,
351                     reportlst out NOCOPY SETreportlst_orareturn);
352 
353 
354 /*
355 ---------------------------------orapmtlist-------------------------------------
356 baseurl:url address for payment server + /orapmt/OraPmt?
357 in_orapmtlist:type record for input name-value pairs
358 summary_orapmtlist:type record for output summary name-value pairs
359 reportlst_orapmtlist:type table for an array of output name-value pairs
360 In this particular procedure, summary.OapfNumber gives the number of
361 the returning payment types. So the code to call orapmtlist would look
362 like:
363 PMT_UTIL.orapmtlist(baseurl, inparam, summary, reportlst);
364 for i in 0..summary.OapfNumber-1 loop
365 	dbms_output.put_line(reportlst(i).OapfPmtType);
366 end loop;
367 */
368 TYPE in_orapmtlist IS RECORD(
369 	OapfAction char(10) NOT NULL := 'orapmtlist',
370 	OapfStoreId varchar2(80),
371 	OapfEmail varchar2(80));
372 TYPE summary_orapmtlist IS RECORD (
373 	OapfNumber number);
374 TYPE report_orapmtlist IS RECORD (
375 	OapfPmtType varchar2(200));
376 TYPE reportlst_orapmtlist IS TABLE OF report_orapmtlist INDEX BY BINARY_INTEGER;
377 procedure orapmtlist(baseurl in varchar2,
378 		     inparam in in_orapmtlist,
379                      summary out NOCOPY summary_orapmtlist,
380 		     reportlst out NOCOPY reportlst_orapmtlist);
381 
382 
383 /*
384 --------------------------------oraclosebatch---------------------------------
385 baseurl:url address for payment server + /orapmt/OraPmt?
386 in_oraclosebatch:type record for input name-value pairs
387 summary_oraclosebatch:type record for output summary name-value pairs
388 reportlst_oraclosebatch:type table for an array of output name-value pairs
389 For each batch closed, a report of its OapfOrderId, OapfTrxnType and etc
390 information would soon follows. The total number of reports is stored in
391 summary_oraclosebatch.OapfNumTrxns. So the code to call oraclosebatch would
392 look like:
393 PMT_UTIL.oraclosebatch(baseurl, inparam, summary, reportlst);
394 --to print out NOCOPY the summary
395 dbms_output.put_line(summary.OapfMerchBatchID);
396 ...
397 --to print out NOCOPY individual report
398 for i in 0..summary.OapfNumTrxns-1 loop
399 	dbms_output.put_line(reportlst(i).OapfOrderId);
400 	dbms_output.put_line(reportlst(i).OapfTrxnType);
401 end loop;
402 */
403 TYPE in_oraclosebatch IS RECORD(
407 	OapfStoreId varchar2(80),
404 	OapfAction char(13) NOT NULL := 'oraclosebatch',
405 	OapfPmtType varchar2(80),
406 	OapfMerchBatchID varchar2(80),
408 /*
409 Added for 1.1
410 */
411 	OapfTerminalId varchar2(80),
412 	OapfNlsLang varchar2(80),
413 	OapfAPIScheme varchar2(80));
414 TYPE summary_oraclosebatch IS RECORD (
415 	OapfMerchBatchID varchar2(80),
416 	OapfStatus varchar2(80),
417 	OapfBatchState varchar2(80),
418 	OapfBatchDate varchar2(80),
419 	OapfCreditAmount varchar2(80),
420 	OapfSalesAmount varchar2(80),
421 	OapfBatchTotal varchar2(80),
422 	OapfCurr varchar2(80),
423 	OapfNumTrxns number,
424 	OapfStoreID varchar2(80),
425 	OapfVpsBatchID varchar2(80),
426 	OapfGWBatchID varchar2(80),
427 	OapfErrLocation varchar2(80),
428 	OapfVendErrCode varchar2(80),
429 	OapfVendErrmsg varchar2(80));
430 TYPE report_oraclosebatch IS RECORD (
431 	OapfOrderId varchar2(80),
432 	OapfTrxnType varchar2(80),
433 	OapfTrxnDate varchar2(80),
434 	OapfStatus varchar2(80),
435 	OapfErrLocation varchar2(80),
436 	OapfVendErrCode varchar2(80),
437 	OapfVendErrmsg varchar2(255),
438 /* Added for SET */
439 	OapfTrxnAmtType varchar2(80),
440 	OapfSplitId varchar2(80));
441 TYPE reportlst_oraclosebatch IS TABLE OF report_oraclosebatch INDEX BY BINARY_INTEGER;
442 procedure oraclosebatch(baseurl in varchar2, inparam in in_oraclosebatch,
443 summary out NOCOPY summary_oraclosebatch, reportlst out NOCOPY reportlst_oraclosebatch);
444 
445 
446 
447 /*
448 ------------------------------------oraqrytxstatus-------------------------------
449 baseurl: url address for payment server + /orapmt/OraPmt?
450 in_oraqrytxstatus: record type for input name-value pairs
451 summary_oraqrytxstatus:record type for output summary name-value pairs
452 reportlst_oraqrytxstatus:type table for an array of output name-value pairs.
453 Again, summary_oraqrytxstatus.OapfNumTrxns denotes the number of transactions
454 that follow.
455 */
456 TYPE in_oraqrytxstatus IS RECORD(
457 	OapfAction char(14) NOT NULL := 'oraqrytxstatus',
458 	OapfOrderId varchar2(80),
459 	OapfStoreId varchar2(80),
460 	OapfPmtType varchar2(80),
461 /* Added for 1.1 */
462 	OapfNlsLang varchar2(80),
463 	OapfAPIScheme varchar2(80));
464 TYPE summary_oraqrytxstatus IS RECORD (
465 	OapfNumTrxns number);
466 TYPE report_oraqrytxstatus IS RECORD (
467 	OapfOrderId varchar2(80),
468 	OapfTrxnType varchar2(80),
469 	OapfStatus varchar2(80),
470 	OapfPrice varchar2(80),
471 	OapfCurr varchar2(80),
472 	OapfAuthcode varchar2(80),
473 	OapfRefcode varchar2(80),
474 	OapfAVScode varchar2(80),
475 	OapfTrxnDate varchar2(80),
476 	OapfPmtInstrType varchar2(80),
477 	OapfErrLocation varchar2(80),
478 	OapfVendErrCode varchar2(80),
479 	OapfVendErrmsg varchar2(255),
480 	OapfAcquirer varchar2(80),
481 	OapfAuxMsg   varchar2(255),
482 	OapfVpsBatchID varchar2(80),
483 /* Added for Extended SET */
484 	OapfSplitId varchar2(80),
485 	OapfTerminalId varchar2(80),
486 	OapfMerchBatchId varchar2(80),
487 	OapfBatchSequenceNum varchar2(80));
488 TYPE reportlst_oraqrytxstatus IS TABLE OF report_oraqrytxstatus INDEX BY BINARY_INTEGER;
489 procedure oraqrytxstatus(baseurl in varchar2, inparam in in_oraqrytxstatus,
490 summary out NOCOPY summary_oraqrytxstatus, reportlst out NOCOPY reportlst_oraqrytxstatus);
491 
492 
493 /*
494 -----------------------------oraqrybatchstatus-------------------------------
495 baseurl : url for payment server + /orapmt/OraPmt?
496 in_oraqrybatchstatus: type record for input name-value pairs
497 summary_oraqrybatchstatus: type record for output summary name-value pairs
498 reportlst_oraqrybatchstatus:type table for output reports name-value pairs.
499 */
500 TYPE in_oraqrybatchstatus IS RECORD(
501 	OapfAction char(17) NOT NULL := 'oraqrybatchstatus',
502 	OapfVpsBatchID varchar2(80),
503 	OapfStoreId varchar2(80),
504 /*
505 Added for SET
506 */
507 	OapfTerminalId varchar2(80),
508 	OapfNlsLang varchar2(80),
509 	OapfAPIScheme varchar2(80));
510 TYPE summary_oraqrybatchstatus IS RECORD(
511 	OapfNumTrxns number);
512 TYPE report_oraqrybatchstatus IS RECORD(
513 	OapfOrderId varchar2(80),
514 	OapfTrxnType varchar2(80),
515 	OapfPrice varchar2(80),
516 	OapfCurr varchar2(80),
517 	OapfTrxnDate varchar2(80),
518 /* Added for SET */
519 	OapfTrxnAmtType varchar2(80),
520 	OapfSplitId varchar2(80));
521 TYPE reportlst_oraqrybatchstatus IS TABLE OF report_oraqrybatchstatus INDEX BY BINARY_INTEGER;
522 procedure oraqrybatchstatus(baseurl in varchar2, inparam in in_oraqrybatchstatus,
523 summary out NOCOPY summary_oraqrybatchstatus, reportlst out NOCOPY reportlst_oraqrybatchstatus);
524 
525 
526 /* Overloaded procedure for Web Group */
527 /*This is the new PS 2.0 version */
528 procedure oraauth ( p_baseurl           IN varchar2,
529                 p_OapfOrderId           IN OUT NOCOPY varchar2,
530                 p_OapfCurr              IN varchar2,
531                 p_OapfPrice             IN varchar2,
532                 p_OapfAuthType          IN varchar2,
533                 p_OapfPmtType           IN varchar2,
534                 p_OapfPmtInstrID        IN varchar2,
535                 p_OapfPmtInstrExp       IN varchar2,
536                 p_OapfStoreId           IN varchar2,
540                 p_OapfAddr3             IN varchar2,
537                 p_OapfcustName          IN varchar2,
538                 p_OapfAddr1             IN varchar2,
539                 p_OapfAddr2             IN varchar2,
541                 p_OapfCity              IN varchar2,
542                 p_OapfCnty              IN varchar2,
543                 p_OapfState             IN varchar2,
544                 p_OapfCntry             IN varchar2,
545                 p_OapfPostalCode        IN varchar2,
546                 p_OapfPhone             IN varchar2,
547                 p_OapfEmail             IN varchar2,
548 		p_OapfRefNumber         IN varchar2,
549 		p_OapfTrxnRef           IN varchar2,
550                 p_OapfStatus            OUT NOCOPY varchar2,
551                 p_OapfStatusMsg         OUT NOCOPY varchar2,
552                 p_OapfTrxnType          OUT NOCOPY varchar2,
553                 p_OapfTrxnDate          OUT NOCOPY varchar2,
554                 p_OapfApprovalCode      OUT NOCOPY varchar2,
555                 p_OapfRefcode           OUT NOCOPY varchar2,
556                 p_OapfAVScode           OUT NOCOPY varchar2,
557                 p_OapfPmtInstrType      OUT NOCOPY varchar2,
558                 p_OapfErrLocation       OUT NOCOPY varchar2,
559                 p_OapfVendErrCode       OUT NOCOPY varchar2,
560                 p_OapfVendErrmsg        OUT NOCOPY varchar2,
561                 p_OapfAcquirer          OUT NOCOPY varchar2,
562                 p_OapfAuxMsg            OUT NOCOPY varchar2 );
563 
564 /* This is the new PS 2.0 version */
565 procedure oracapture ( p_baseurl        IN varchar2,
566                 p_OapfOrderId           IN OUT NOCOPY varchar2,
567                 p_OapfCurr              IN varchar2,
568                 p_OapfPrice             IN varchar2,
569                 p_OapfPmtType           IN varchar2,
570                 p_OapfStoreId           IN varchar2,
571                 p_OapfTrxnRef           IN varchar2,
572                 p_OapfStatus            OUT NOCOPY varchar2,
573                 p_OapfStatusMsg         OUT NOCOPY varchar2,
574                 p_OapfTrxnType          OUT NOCOPY varchar2,
575                 p_OapfTrxnDate          OUT NOCOPY varchar2,
576                 p_OapfPmtInstrType      OUT NOCOPY varchar2,
577                 p_OapfRefcode           OUT NOCOPY varchar2,
578                 p_OapfErrLocation       OUT NOCOPY varchar2,
579                 p_OapfVendErrCode       OUT NOCOPY varchar2,
580                 p_OapfVendErrmsg        OUT NOCOPY varchar2,
581 		p_OapfCashRecId         IN VARCHAR2 DEFAULT null);
582 end PMT_UTIL;