[Home] [Help]
PACKAGE: APPS.IBY_OFFLINEDB_PKG
Source
1 package iby_offlinedb_pkg as
2 /*$Header: ibyoffls.pls 120.2 2005/10/30 05:48:46 appldev ship $*/
3 /*
4 ** Procedure Name : scheduleCC
5 ** Purpose : creates an entry for scheduling the CreditCard payments
6 ** in the iby_trxn_summaries_all and iby_trxn_core
7 ** tables. Returns the transactionid created
8 ** by the system.
9 */
10 procedure scheduleCC( i_ecappid iby_trxn_summaries_all.ecappid%type,
11 i_payeeid iby_trxn_summaries_all.payeeid%type,
12 i_bepid iby_trxn_summaries_all.bepid%type,
13 i_bepkey iby_trxn_summaries_all.bepkey%type,
14 i_tangibleid iby_trxn_summaries_all.tangibleid%type,
15 i_reqtype iby_trxn_summaries_all.reqtype%type,
16 i_reqdate iby_trxn_summaries_all.reqdate%type,
17 i_pmtmethod iby_trxn_summaries_all.paymentmethodname%type,
18 i_desturl iby_trxn_summaries_all.desturl%type,
19 io_transactionid in out nocopy iby_trxn_summaries_all.transactionid%type,
20 i_amount iby_trxn_summaries_all.amount%type DEFAULT NULL,
21 i_currency iby_trxn_summaries_all.currencynamecode%type DEFAULT NULL,
22 i_trxntypeid iby_trxn_summaries_all.trxntypeid%type DEFAULT NULL,
23 i_nlslang iby_trxn_summaries_all.Nlslang%type DEFAULT NULL,
24 i_settledate iby_trxn_summaries_all.settledate%type DEFAULT NULL,
25 i_authtype iby_trxn_core.authtype%type DEFAULT NULL,
26 i_instrid iby_trxn_summaries_all.payerinstrid%type
27 DEFAULT NULL,
28 i_payerid iby_trxn_summaries_all.payerid%type
29 DEFAULT NULL,
30 i_org_id iby_trxn_summaries_all.org_id%type
31 DEFAULT NULL ,
32
33 i_instrtype iby_trxn_summaries_all.instrtype%type,
34
35 i_billeracct iby_tangible.acctno%type,
36 i_refinfo iby_tangible.refinfo%type,
37 i_memo iby_tangible.memo%type,
38 i_voiceauthflag iby_trxn_core.voiceauthflag%type DEFAULT NULL,
39 i_authcode iby_trxn_core.authcode%type DEFAULT NULL,
40 i_OrderMedium IN iby_tangible.Order_Medium%TYPE,
41 i_EftAuthMethod IN iby_tangible.Eft_Auth_Method%TYPE
42 );
43
44
45 /*
46 ** Procedure Name : schedulePC
47 ** Purpose : creates an entry for scheduling the PurchaseCard payments
48 ** in the iby_trxn_summaries_all and iby_trxn_core
49 ** tables. Returns the transactionid created
50 ** by the system.
51 */
52 procedure schedulePC( i_ecappid iby_trxn_summaries_all.ecappid%type,
53 i_payeeid iby_trxn_summaries_all.payeeid%type,
54 i_bepid iby_trxn_summaries_all.bepid%type,
55 i_bepkey iby_trxn_summaries_all.bepkey%type,
56 i_tangibleid iby_trxn_summaries_all.tangibleid%type,
57 i_reqtype iby_trxn_summaries_all.reqtype%type,
58 i_reqdate iby_trxn_summaries_all.reqdate%type,
59 i_pmtmethod iby_trxn_summaries_all.paymentmethodname%type,
60 i_desturl iby_trxn_summaries_all.desturl%type,
61 io_transactionid in out nocopy iby_trxn_summaries_all.transactionid%type,
62 i_amount iby_trxn_summaries_all.amount%type DEFAULT NULL,
63 i_currency iby_trxn_summaries_all.currencynamecode%type DEFAULT NULL,
64 i_trxntypeid iby_trxn_summaries_all.trxntypeid%type DEFAULT NULL,
65 i_nlslang iby_trxn_summaries_all.Nlslang%type DEFAULT NULL,
66 i_settledate iby_trxn_summaries_all.settledate%type DEFAULT NULL,
67 i_authtype iby_trxn_core.authtype%type DEFAULT NULL,
68 i_instrid iby_trxn_summaries_all.payerinstrid%type
69 DEFAULT NULL,
70 i_payerid iby_trxn_summaries_all.payerid%type
71 DEFAULT NULL,
72 i_org_id iby_trxn_summaries_all.org_id%type
73 DEFAULT NULL ,
74
75 i_instrtype iby_trxn_summaries_all.instrtype%type,
76
77 i_billeracct iby_tangible.acctno%type,
78 i_refinfo iby_tangible.refinfo%type,
79 i_memo iby_tangible.memo%type,
80 i_voiceauthflag iby_trxn_core.voiceauthflag%type DEFAULT NULL,
81 i_authcode iby_trxn_core.authcode%type DEFAULT NULL,
82 i_ponum iby_trxn_core.ponumber%type,
83 i_taxamt iby_trxn_core.taxamount%type,
84 i_shipfromzip iby_trxn_core.shipfromzip%type,
85 i_shiptozip iby_trxn_core.shiptozip%type,
86 i_OrderMedium IN iby_tangible.Order_Medium%TYPE,
87 i_EftAuthMethod IN iby_tangible.Eft_Auth_Method%TYPE
88 );
89
90 /*
91 ** Procedure Name : scheduleCCCancel
92 ** Purpose : creates an entry for a CreditCard cancel request in the
93 ** iby_trxn_summaries_all table
94 */
95 procedure scheduleCCCancel(i_ecappid iby_batches_all.ecappid%type,
96 i_payeeid iby_batches_all.payeeid%type,
97 i_bepid iby_batches_all.bepid%type,
98 i_bepkey iby_batches_all.bepkey%type,
99 i_tangibleid iby_trxn_summaries_all.tangibleid%type,
100 i_reqtype iby_trxn_summaries_all.reqtype%type,
101 i_reqdate iby_trxn_summaries_all.reqdate%type,
102 i_pmtmethod iby_trxn_summaries_all.paymentmethodname%type,
103 i_transactionid in
104 iby_trxn_summaries_all.transactionid%type,
105 i_reqtype_tocancel in iby_trxn_summaries_all.reqtype%type,
106 i_trxntypeid_tocancel in iby_trxn_summaries_all.trxntypeid%type
107 );
108 /*
109 ** Procedure Name : scheduleCCbatch
110 ** Purpose : creates an entry for scheduling the CreditCard batch requests
111 ** in the iby_batches_all table.
112 **
113 ** Parameters:
114 **
115 ** In : i_ecappid, i_payeeid, i_bepid, i_batchid,
116 ** i_reqtype, i_reqdate, i_pmtmethod,
117 ** i_nlslang, i_terminalid
118 **
119 */
120 procedure scheduleCCbatch(i_ecappid iby_batches_all.ecappid%type,
121 i_payeeid iby_batches_all.payeeid%type,
122 i_bepid iby_batches_all.bepid%type,
123 i_bepkey iby_batches_all.bepkey%type,
124 i_batchid iby_batches_all.batchid%type,
125 i_reqtype iby_batches_all.reqtype%type,
126 i_reqdate iby_batches_all.reqdate%type,
127 i_pmtmethod iby_batches_all.paymentmethodname%type,
128 i_desturl iby_batches_all.desturl%type,
129 i_nlslang iby_batches_all.nlslang%type DEFAULT NULL,
130 i_terminalid iby_batches_all.terminalid%type
131 DEFAULT NULL,
132 i_schedDate iby_batches_all.batchopendate%type);
133 /*
134 ** Procedure Name : scheduleSET
135 ** Purpose : creates an entry for scheduling the CreditCard payments
136 ** in the iby_trxn_summaries_all and iby_trxn_core
137 ** tables. Returns the transactionid created
138 ** by the system.
139 **
140 ** Parameters:
141 **
142 ** In : i_ecappid, i_payeeid, i_bepid, i_tangibleid,
143 ** i_reqtype, i_reqdate, i_pmtmethod,
144 ** i_amount, i_currency, i_authtype, i_trxntypeid,
145 ** i_instrid, i_payerid, i_settledate
146 ** Out : io_transactionid.
147 **
148 */
149 procedure scheduleSET( i_ecappid iby_trxn_summaries_all.ecappid%type,
150 i_payeeid iby_trxn_summaries_all.payeeid%type,
151 i_bepid iby_trxn_summaries_all.bepid%type,
152 i_tangibleid iby_trxn_summaries_all.tangibleid%type,
153 i_reqtype iby_trxn_summaries_all.reqtype%type,
154 i_reqdate iby_trxn_summaries_all.reqdate%type,
155 i_reqseq iby_trxn_summaries_all.reqseq%type,
156 i_pmtmethod iby_trxn_summaries_all.paymentmethodname%type,
157 i_desturl iby_trxn_summaries_all.desturl%type,
158 io_transactionid in out nocopy iby_trxn_summaries_all.transactionid%type,
159 i_amount iby_trxn_summaries_all.amount%type DEFAULT NULL,
160 i_currency iby_trxn_summaries_all.currencynamecode%type DEFAULT NULL,
161 i_trxntypeid iby_trxn_summaries_all.trxntypeid%type DEFAULT NULL,
162 i_nlslang iby_trxn_summaries_all.Nlslang%type DEFAULT NULL,
163 i_settledate iby_trxn_summaries_all.settledate%type DEFAULT NULL,
164 i_authtype iby_trxn_core.authtype%type DEFAULT NULL,
165 i_instrid iby_trxn_summaries_all.payerinstrid%type
166 DEFAULT NULL,
167 i_payerid iby_trxn_summaries_all.payerid%type
168 DEFAULT NULL,
169 recurringfreq iby_trxn_extended.RecurringFreq%type DEFAULT NULL,
170 recurringexpdate iby_trxn_extended.RecurringExpDate%type DEFAULT NULL,
171 destpostalcode iby_trxn_extended.DestPostalCode%type DEFAULT NULL,
172 custrefnum iby_trxn_extended.CustRefNum%type DEFAULT NULL,
173 localtaxprice iby_trxn_extended.LocalTaxPrice%type DEFAULT NULL,
174 localtaxcurrency iby_trxn_extended.LocalTaxCurrency%type DEFAULT NULL,
175 authprice iby_trxn_extended.AuthPrice%type DEFAULT NULL,
176 authcurrency iby_trxn_extended.AuthCurrency%type DEFAULT NULL,
177 splitshipment iby_trxn_extended.SplitShipment%type DEFAULT NULL,
178 installtotaltrxns iby_trxn_extended.InstallTotalTrxns%type DEFAULT NULL,
179 splitid iby_trxn_extended.SplitId%type DEFAULT NULL,
180 batchid iby_trxn_summaries_all.BatchId%type DEFAULT NULL,
181 batchseqnum iby_trxn_extended.BatchSeqNum%type DEFAULT NULL,
182 terminalid iby_trxn_extended.TerminalId%type DEFAULT NULL);
183 /*
184 ** Procedure Name : scheduleSETOther
185 ** Purpose : creates an entry for scheduling the SET payments
186 ** in the iby_trxn_summaries_all and iby_trxn_core and extended
187 ** tables. Returns the transactionid created
188 ** by the system.
189 **
190 ** This procedure is used by follow-on transactions (other than cancel) such as
191 ** capture, credit and subsequent auth
192 */
193 procedure scheduleSETOther( i_ecappid iby_trxn_summaries_all.ecappid%type,
194 i_payeeid iby_trxn_summaries_all.payeeid%type,
195 i_bepid iby_trxn_summaries_all.bepid%type,
196 i_tangibleid iby_trxn_summaries_all.tangibleid%type,
197 i_reqtype iby_trxn_summaries_all.reqtype%type,
198 i_reqdate iby_trxn_summaries_all.reqdate%type,
199 i_reqseq iby_trxn_summaries_all.reqseq%type,
200 i_pmtmethod iby_trxn_summaries_all.paymentmethodname%type,
201 i_desturl iby_trxn_summaries_all.desturl%type,
202 io_transactionid in out nocopy iby_trxn_summaries_all.transactionid%type,
203 i_amount iby_trxn_summaries_all.amount%type DEFAULT NULL,
204 i_currency iby_trxn_summaries_all.currencynamecode%type DEFAULT NULL,
205 i_trxntypeid iby_trxn_summaries_all.trxntypeid%type DEFAULT NULL,
206 i_nlslang iby_trxn_summaries_all.Nlslang%type DEFAULT NULL,
207 i_settledate iby_trxn_summaries_all.settledate%type DEFAULT NULL,
208 i_authtype iby_trxn_core.authtype%type DEFAULT NULL,
209 i_instrid iby_trxn_summaries_all.payerinstrid%type
210 DEFAULT NULL,
211 i_payerid iby_trxn_summaries_all.payerid%type
212 DEFAULT NULL,
213 splitid iby_trxn_extended.SplitId%type DEFAULT NULL,
214 prevsplitid iby_trxn_extended.PrevSplitId%type DEFAULT NULL,
215 subauthind iby_trxn_extended.SubAuthInd%type DEFAULT NULL,
216 batchid iby_trxn_summaries_all.BatchId%type DEFAULT NULL,
217 batchseqnum iby_trxn_extended.BatchSeqNum%type DEFAULT NULL,
218 terminalid iby_trxn_extended.TerminalId%type DEFAULT NULL);
219
220
221 /*
222 ** Procedure Name : scheduleSETCancel
223 ** Purpose : creates an entry for a CreditCard cancel request in the
224 ** iby_trxn_summaries_all table
225 */
226 /*********should no longer be used
227 procedure scheduleSETCancel(i_ecappid iby_batches_all.ecappid%type,
228 i_payeeid iby_batches_all.payeeid%type,
229 i_bepid iby_batches_all.bepid%type,
230 i_tangibleid iby_trxn_summaries_all.tangibleid%type,
231 i_reqtype iby_trxn_summaries_all.reqtype%type,
232 i_reqdate iby_trxn_summaries_all.reqdate%type,
233 i_pmtmethod iby_trxn_summaries_all.paymentmethodname%type,
234 i_transactionid in out nocopy iby_trxn_summaries_all.transactionid%type
235 );
236
237 *********/
238
239
240 /*
241 ** Procedure Name : scheduleCCbatch
242 ** Purpose : creates an entry for scheduling the CreditCard batch requests
243 ** in the iby_batches_all table.
244 **
245 ** Parameters:
246 **
247 ** In : i_ecappid, i_payeeid, i_bepid, i_batchid,
248 ** i_reqtype, i_reqdate, i_pmtmethod,
249 ** i_nlslang, i_terminalid
250 **
251 */
252 procedure scheduleSETbatch(i_ecappid iby_batches_all.ecappid%type,
253 i_payeeid iby_batches_all.payeeid%type,
254 i_bepid iby_batches_all.bepid%type,
255 i_batchid iby_batches_all.batchid%type,
256 i_reqtype iby_batches_all.reqtype%type,
257 i_reqdate iby_batches_all.reqdate%type,
258 i_pmtmethod iby_batches_all.paymentmethodname%type,
259 i_desturl iby_batches_all.desturl%type,
260 i_nlslang iby_batches_all.nlslang%type DEFAULT NULL,
261 i_terminalid iby_batches_all.terminalid%type DEFAULT NULL);
262 /*
263 ** Function Name: requestExists
264 ** Purpose: This is a function to check if a particular payment
265 ** request such as orapmtreq, oracapture, orareturn etc.
266 ** exists for offline transactions
267 ** In : i_payeeid, i_tangibleid, i_reqtype
268 ** Out : boolean to indicate if request exists
269 */
270 function requestExists(i_payeeid iby_trxn_summaries_all.payeeid%type,
271 i_tangibleid iby_trxn_summaries_all.tangibleid%type,
272 i_reqtype iby_trxn_summaries_all.reqtype%type,
273 i_bepid iby_trxn_summaries_all.bepid%type)
274 return boolean;
275
276 /*
277 ** Function Name: batchExists
278 ** Purpose: This is similar to requestExists above but checks
279 ** for duplicate batch requests.
280 ** In : i_payeeid, i_batchid, i_reqtype
281 ** Out : boolean to indicate if request exists
282 */
283 function batchExists(i_payeeid iby_batches_all.payeeid%type,
284 i_batchid iby_batches_all.batchid%type,
285 i_reqtype iby_batches_all.reqtype%type)
286 return boolean;
287
288
289 /*
290 ** Function: instrExists.
291 ** Purpose: Check if the specified instrid exists or not.
292 */
293 function instrExists(i_instrid in
294 iby_trxn_summaries_all.payerinstrid%type,
295 i_instrtype in
296 iby_trxn_summaries_all.instrtype%type)
297
298 return boolean;
301 end iby_offlinedb_pkg;
299
300