[Home] [Help]
7: /* application has returned. It does not perform any error checking */
8: /* to make sure that the row already exists since the programmer */
9: /* should have called queryset.listvendor to check beforehand. */
10: PROCEDURE insert_init_txn
11: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
12: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
13: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
14: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
15: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
8: /* to make sure that the row already exists since the programmer */
9: /* should have called queryset.listvendor to check beforehand. */
10: PROCEDURE insert_init_txn
11: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
12: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
13: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
14: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
15: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
16: trxn_type_in IN OUT NOCOPY iby_trxn_summaries_all.TrxntypeID%TYPE,
9: /* should have called queryset.listvendor to check beforehand. */
10: PROCEDURE insert_init_txn
11: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
12: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
13: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
14: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
15: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
16: trxn_type_in IN OUT NOCOPY iby_trxn_summaries_all.TrxntypeID%TYPE,
17: payment_name_in IN iby_trxn_core.InstrName%TYPE,
10: PROCEDURE insert_init_txn
11: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
12: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
13: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
14: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
15: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
16: trxn_type_in IN OUT NOCOPY iby_trxn_summaries_all.TrxntypeID%TYPE,
17: payment_name_in IN iby_trxn_core.InstrName%TYPE,
18: price_in IN iby_trxn_summaries_all.Amount%TYPE,
11: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
12: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
13: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
14: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
15: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
16: trxn_type_in IN OUT NOCOPY iby_trxn_summaries_all.TrxntypeID%TYPE,
17: payment_name_in IN iby_trxn_core.InstrName%TYPE,
18: price_in IN iby_trxn_summaries_all.Amount%TYPE,
19: currency_in IN iby_trxn_summaries_all.CurrencyNameCode%TYPE,
12: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
13: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
14: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
15: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
16: trxn_type_in IN OUT NOCOPY iby_trxn_summaries_all.TrxntypeID%TYPE,
17: payment_name_in IN iby_trxn_core.InstrName%TYPE,
18: price_in IN iby_trxn_summaries_all.Amount%TYPE,
19: currency_in IN iby_trxn_summaries_all.CurrencyNameCode%TYPE,
20: time_in IN iby_trxn_summaries_all.UpdateDate%TYPE,
14: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
15: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
16: trxn_type_in IN OUT NOCOPY iby_trxn_summaries_all.TrxntypeID%TYPE,
17: payment_name_in IN iby_trxn_core.InstrName%TYPE,
18: price_in IN iby_trxn_summaries_all.Amount%TYPE,
19: currency_in IN iby_trxn_summaries_all.CurrencyNameCode%TYPE,
20: time_in IN iby_trxn_summaries_all.UpdateDate%TYPE,
21: status_in IN iby_trxn_summaries_all.Status%TYPE,
22: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
15: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
16: trxn_type_in IN OUT NOCOPY iby_trxn_summaries_all.TrxntypeID%TYPE,
17: payment_name_in IN iby_trxn_core.InstrName%TYPE,
18: price_in IN iby_trxn_summaries_all.Amount%TYPE,
19: currency_in IN iby_trxn_summaries_all.CurrencyNameCode%TYPE,
20: time_in IN iby_trxn_summaries_all.UpdateDate%TYPE,
21: status_in IN iby_trxn_summaries_all.Status%TYPE,
22: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
23: vendor_code_in IN iby_trxn_summaries_all.BEPCode%TYPE,
16: trxn_type_in IN OUT NOCOPY iby_trxn_summaries_all.TrxntypeID%TYPE,
17: payment_name_in IN iby_trxn_core.InstrName%TYPE,
18: price_in IN iby_trxn_summaries_all.Amount%TYPE,
19: currency_in IN iby_trxn_summaries_all.CurrencyNameCode%TYPE,
20: time_in IN iby_trxn_summaries_all.UpdateDate%TYPE,
21: status_in IN iby_trxn_summaries_all.Status%TYPE,
22: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
23: vendor_code_in IN iby_trxn_summaries_all.BEPCode%TYPE,
24: vendor_message_in IN iby_trxn_summaries_all.BEPMessage%TYPE,
17: payment_name_in IN iby_trxn_core.InstrName%TYPE,
18: price_in IN iby_trxn_summaries_all.Amount%TYPE,
19: currency_in IN iby_trxn_summaries_all.CurrencyNameCode%TYPE,
20: time_in IN iby_trxn_summaries_all.UpdateDate%TYPE,
21: status_in IN iby_trxn_summaries_all.Status%TYPE,
22: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
23: vendor_code_in IN iby_trxn_summaries_all.BEPCode%TYPE,
24: vendor_message_in IN iby_trxn_summaries_all.BEPMessage%TYPE,
25: error_location_in IN iby_trxn_summaries_all.ErrorLocation%TYPE,
18: price_in IN iby_trxn_summaries_all.Amount%TYPE,
19: currency_in IN iby_trxn_summaries_all.CurrencyNameCode%TYPE,
20: time_in IN iby_trxn_summaries_all.UpdateDate%TYPE,
21: status_in IN iby_trxn_summaries_all.Status%TYPE,
22: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
23: vendor_code_in IN iby_trxn_summaries_all.BEPCode%TYPE,
24: vendor_message_in IN iby_trxn_summaries_all.BEPMessage%TYPE,
25: error_location_in IN iby_trxn_summaries_all.ErrorLocation%TYPE,
26: billeracct_in IN iby_tangible.acctno%type,
19: currency_in IN iby_trxn_summaries_all.CurrencyNameCode%TYPE,
20: time_in IN iby_trxn_summaries_all.UpdateDate%TYPE,
21: status_in IN iby_trxn_summaries_all.Status%TYPE,
22: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
23: vendor_code_in IN iby_trxn_summaries_all.BEPCode%TYPE,
24: vendor_message_in IN iby_trxn_summaries_all.BEPMessage%TYPE,
25: error_location_in IN iby_trxn_summaries_all.ErrorLocation%TYPE,
26: billeracct_in IN iby_tangible.acctno%type,
27: refinfo_in IN iby_tangible.refinfo%type,
20: time_in IN iby_trxn_summaries_all.UpdateDate%TYPE,
21: status_in IN iby_trxn_summaries_all.Status%TYPE,
22: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
23: vendor_code_in IN iby_trxn_summaries_all.BEPCode%TYPE,
24: vendor_message_in IN iby_trxn_summaries_all.BEPMessage%TYPE,
25: error_location_in IN iby_trxn_summaries_all.ErrorLocation%TYPE,
26: billeracct_in IN iby_tangible.acctno%type,
27: refinfo_in IN iby_tangible.refinfo%type,
28: memo_in IN iby_tangible.memo%type,
21: status_in IN iby_trxn_summaries_all.Status%TYPE,
22: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
23: vendor_code_in IN iby_trxn_summaries_all.BEPCode%TYPE,
24: vendor_message_in IN iby_trxn_summaries_all.BEPMessage%TYPE,
25: error_location_in IN iby_trxn_summaries_all.ErrorLocation%TYPE,
26: billeracct_in IN iby_tangible.acctno%type,
27: refinfo_in IN iby_tangible.refinfo%type,
28: memo_in IN iby_tangible.memo%type,
29: order_medium_in IN iby_tangible.order_medium%TYPE,
27: refinfo_in IN iby_tangible.refinfo%type,
28: memo_in IN iby_tangible.memo%type,
29: order_medium_in IN iby_tangible.order_medium%TYPE,
30: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
31: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
32: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
33: instrnum_in IN iby_trxn_summaries_all.instrnumber%type)
34: IS
35: num_trxns NUMBER := 0;
28: memo_in IN iby_tangible.memo%type,
29: order_medium_in IN iby_tangible.order_medium%TYPE,
30: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
31: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
32: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
33: instrnum_in IN iby_trxn_summaries_all.instrnumber%type)
34: IS
35: num_trxns NUMBER := 0;
36: err_msg VARCHAR2(100);
29: order_medium_in IN iby_tangible.order_medium%TYPE,
30: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
31: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
32: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
33: instrnum_in IN iby_trxn_summaries_all.instrnumber%type)
34: IS
35: num_trxns NUMBER := 0;
36: err_msg VARCHAR2(100);
37: trxn_mid NUMBER;
35: num_trxns NUMBER := 0;
36: err_msg VARCHAR2(100);
37: trxn_mid NUMBER;
38: transaction_id NUMBER;
39: l_tmid iby_trxn_summaries_all.mtangibleid%type;
40: l_mpayeeid iby_payee.mpayeeid%type;
41:
42: BEGIN
43: -- Check trxn_type
48: END IF;
49: -- Count number of previous transactions
50: SELECT count(*)
51: INTO num_trxns
52: FROM iby_trxn_summaries_all
53: WHERE TangibleID = order_id_in
54: AND UPPER(ReqType) = UPPER(req_type_in)
55: AND PayeeID = merchant_id_in;
56: IF (num_trxns = 0)
80: billeracct_in,refinfo_in, memo_in,
81: order_medium_in, eft_auth_method_in,
82: l_tmid);
83:
84: INSERT INTO iby_trxn_summaries_all
85: (TrxnMID, TransactionID,TrxntypeID, ECAPPID, org_id,
86: ReqType, ReqDate,
87: Amount,CurrencyNameCode, UpdateDate,Status,
88: TangibleID,MPayeeID, PayeeID,BEPID,MtangibleId,
117: THEN
118: -- One previous transaction, so update previous row
119: SELECT TrxnMID, TransactionID,MtangibleId
120: INTO trxn_mid, transaction_id_in_out,l_tmid
121: FROM iby_trxn_summaries_all
122: WHERE TangibleID = order_id_in
123: AND UPPER(ReqType) = UPPER(req_type_in)
124: AND PayeeID = merchant_id_in;
125:
127: iby_bill_pkg.modBill(l_tmid,order_id_in,price_in,currency_in,
128: billeracct_in,refinfo_in,memo_in,
129: order_medium_in, eft_auth_method_in);
130:
131: UPDATE iby_trxn_summaries_all
132: SET Amount = price_in,
133: CurrencyNameCode = currency_in,
134: --ReqDate = time_in,
135: updatedate = time_in,
174: /* transaction occurred. Since SET is idempotent, the procedure */
175: /* checks to see if the row already exists based upon order_id, */
176: /* merchant_id, trxn_type, and request_type. */
177: PROCEDURE insert_set_txn
178: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
179: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
180: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
181: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
182: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
175: /* checks to see if the row already exists based upon order_id, */
176: /* merchant_id, trxn_type, and request_type. */
177: PROCEDURE insert_set_txn
178: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
179: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
180: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
181: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
182: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
183: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
176: /* merchant_id, trxn_type, and request_type. */
177: PROCEDURE insert_set_txn
178: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
179: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
180: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
181: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
182: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
183: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
184: split_id_in IN iby_trxn_extended.SplitID%TYPE,
177: PROCEDURE insert_set_txn
178: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
179: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
180: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
181: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
182: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
183: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
184: split_id_in IN iby_trxn_extended.SplitID%TYPE,
185: payment_name_in IN iby_trxn_core.InstrName%TYPE,
178: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
179: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
180: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
181: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
182: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
183: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
184: split_id_in IN iby_trxn_extended.SplitID%TYPE,
185: payment_name_in IN iby_trxn_core.InstrName%TYPE,
186: price_in IN iby_trxn_summaries_all.Amount%TYPE,
179: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
180: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
181: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
182: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
183: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
184: split_id_in IN iby_trxn_extended.SplitID%TYPE,
185: payment_name_in IN iby_trxn_core.InstrName%TYPE,
186: price_in IN iby_trxn_summaries_all.Amount%TYPE,
187: currency_in IN iby_trxn_summaries_all.CurrencyNameCode%TYPE,
182: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
183: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
184: split_id_in IN iby_trxn_extended.SplitID%TYPE,
185: payment_name_in IN iby_trxn_core.InstrName%TYPE,
186: price_in IN iby_trxn_summaries_all.Amount%TYPE,
187: currency_in IN iby_trxn_summaries_all.CurrencyNameCode%TYPE,
188: time_in IN iby_trxn_summaries_all.UpdateDate%TYPE,
189: status_in IN iby_trxn_summaries_all.Status%TYPE,
190: authcode_in IN iby_trxn_core.AuthCode%TYPE,
183: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
184: split_id_in IN iby_trxn_extended.SplitID%TYPE,
185: payment_name_in IN iby_trxn_core.InstrName%TYPE,
186: price_in IN iby_trxn_summaries_all.Amount%TYPE,
187: currency_in IN iby_trxn_summaries_all.CurrencyNameCode%TYPE,
188: time_in IN iby_trxn_summaries_all.UpdateDate%TYPE,
189: status_in IN iby_trxn_summaries_all.Status%TYPE,
190: authcode_in IN iby_trxn_core.AuthCode%TYPE,
191: capcode_in IN iby_trxn_core.OperationCode%TYPE,
184: split_id_in IN iby_trxn_extended.SplitID%TYPE,
185: payment_name_in IN iby_trxn_core.InstrName%TYPE,
186: price_in IN iby_trxn_summaries_all.Amount%TYPE,
187: currency_in IN iby_trxn_summaries_all.CurrencyNameCode%TYPE,
188: time_in IN iby_trxn_summaries_all.UpdateDate%TYPE,
189: status_in IN iby_trxn_summaries_all.Status%TYPE,
190: authcode_in IN iby_trxn_core.AuthCode%TYPE,
191: capcode_in IN iby_trxn_core.OperationCode%TYPE,
192: completion_code_in IN iby_trxn_extended.CompletionCode%TYPE,
185: payment_name_in IN iby_trxn_core.InstrName%TYPE,
186: price_in IN iby_trxn_summaries_all.Amount%TYPE,
187: currency_in IN iby_trxn_summaries_all.CurrencyNameCode%TYPE,
188: time_in IN iby_trxn_summaries_all.UpdateDate%TYPE,
189: status_in IN iby_trxn_summaries_all.Status%TYPE,
190: authcode_in IN iby_trxn_core.AuthCode%TYPE,
191: capcode_in IN iby_trxn_core.OperationCode%TYPE,
192: completion_code_in IN iby_trxn_extended.CompletionCode%TYPE,
193: set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,
190: authcode_in IN iby_trxn_core.AuthCode%TYPE,
191: capcode_in IN iby_trxn_core.OperationCode%TYPE,
192: completion_code_in IN iby_trxn_extended.CompletionCode%TYPE,
193: set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,
194: batch_id_in IN iby_trxn_summaries_all.batchID%TYPE,
195: batch_seq_num_in IN iby_trxn_extended.BatchSeqNum%TYPE,
196: AVS_result_in IN iby_trxn_core.AVSCode%TYPE,
197: ret_ref_num_in IN iby_trxn_core.ReferenceCode%TYPE,
198: card_BIN_in IN iby_trxn_extended.Cardbin%TYPE,
198: card_BIN_in IN iby_trxn_extended.Cardbin%TYPE,
199: terminal_id_in IN iby_trxn_extended.TerminalID%TYPE,
200: request_type_in IN iby_trxn_extended.SETReqType%TYPE,
201: subseq_auth_ind_in IN iby_trxn_extended.SubAuthInd%TYPE,
202: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
203: payment_method_in IN iby_trxn_summaries_all.PAYMENTMETHODNAME%TYPE,
204: vendor_code_in IN iby_trxn_summaries_all.BEPCode%TYPE,
205: vendor_message_in IN iby_trxn_summaries_all.BEPMessage%TYPE,
206: error_location_in IN iby_trxn_summaries_all.ErrorLocation%TYPE,
199: terminal_id_in IN iby_trxn_extended.TerminalID%TYPE,
200: request_type_in IN iby_trxn_extended.SETReqType%TYPE,
201: subseq_auth_ind_in IN iby_trxn_extended.SubAuthInd%TYPE,
202: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
203: payment_method_in IN iby_trxn_summaries_all.PAYMENTMETHODNAME%TYPE,
204: vendor_code_in IN iby_trxn_summaries_all.BEPCode%TYPE,
205: vendor_message_in IN iby_trxn_summaries_all.BEPMessage%TYPE,
206: error_location_in IN iby_trxn_summaries_all.ErrorLocation%TYPE,
207: billeracct_in IN iby_tangible.acctno%type ,
200: request_type_in IN iby_trxn_extended.SETReqType%TYPE,
201: subseq_auth_ind_in IN iby_trxn_extended.SubAuthInd%TYPE,
202: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
203: payment_method_in IN iby_trxn_summaries_all.PAYMENTMETHODNAME%TYPE,
204: vendor_code_in IN iby_trxn_summaries_all.BEPCode%TYPE,
205: vendor_message_in IN iby_trxn_summaries_all.BEPMessage%TYPE,
206: error_location_in IN iby_trxn_summaries_all.ErrorLocation%TYPE,
207: billeracct_in IN iby_tangible.acctno%type ,
208: refinfo_in IN iby_tangible.refinfo%type,
201: subseq_auth_ind_in IN iby_trxn_extended.SubAuthInd%TYPE,
202: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
203: payment_method_in IN iby_trxn_summaries_all.PAYMENTMETHODNAME%TYPE,
204: vendor_code_in IN iby_trxn_summaries_all.BEPCode%TYPE,
205: vendor_message_in IN iby_trxn_summaries_all.BEPMessage%TYPE,
206: error_location_in IN iby_trxn_summaries_all.ErrorLocation%TYPE,
207: billeracct_in IN iby_tangible.acctno%type ,
208: refinfo_in IN iby_tangible.refinfo%type,
209: memo_in IN iby_tangible.memo%type ,
202: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
203: payment_method_in IN iby_trxn_summaries_all.PAYMENTMETHODNAME%TYPE,
204: vendor_code_in IN iby_trxn_summaries_all.BEPCode%TYPE,
205: vendor_message_in IN iby_trxn_summaries_all.BEPMessage%TYPE,
206: error_location_in IN iby_trxn_summaries_all.ErrorLocation%TYPE,
207: billeracct_in IN iby_tangible.acctno%type ,
208: refinfo_in IN iby_tangible.refinfo%type,
209: memo_in IN iby_tangible.memo%type ,
210: order_medium_in IN iby_tangible.order_medium%TYPE,
208: refinfo_in IN iby_tangible.refinfo%type,
209: memo_in IN iby_tangible.memo%type ,
210: order_medium_in IN iby_tangible.order_medium%TYPE,
211: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
212: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
213: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
214: instrnum_in IN iby_trxn_summaries_all.instrnumber%type)
215: IS
216:
209: memo_in IN iby_tangible.memo%type ,
210: order_medium_in IN iby_tangible.order_medium%TYPE,
211: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
212: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
213: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
214: instrnum_in IN iby_trxn_summaries_all.instrnumber%type)
215: IS
216:
217: num_trxns NUMBER;
210: order_medium_in IN iby_tangible.order_medium%TYPE,
211: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
212: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
213: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
214: instrnum_in IN iby_trxn_summaries_all.instrnumber%type)
215: IS
216:
217: num_trxns NUMBER;
218: counter NUMBER;
219: oper_code iby_trxn_core.OperationCode%TYPE;
220: err_msg VARCHAR2(100);
221: trxn_mid NUMBER;
222: transaction_id NUMBER;
223: l_tmid iby_trxn_summaries_all.mtangibleid%type;
224: l_order_id iby_trxn_summaries_all.tangibleid%type;
225:
226: l_mpayeeid iby_payee.mpayeeid%type;
227: l_mbatchid iby_batches_all.mbatchid%type;
220: err_msg VARCHAR2(100);
221: trxn_mid NUMBER;
222: transaction_id NUMBER;
223: l_tmid iby_trxn_summaries_all.mtangibleid%type;
224: l_order_id iby_trxn_summaries_all.tangibleid%type;
225:
226: l_mpayeeid iby_payee.mpayeeid%type;
227: l_mbatchid iby_batches_all.mbatchid%type;
228: BEGIN
273: --Check for idempotency: see if transaction already
274: -- exists
275: SELECT count(*)
276: INTO num_trxns
277: FROM iby_trxn_summaries_all
278: WHERE TangibleID = order_id_in
279: AND UPPER(ReqType) = UPPER(req_type_in)
280: AND PayeeID = merchant_id_in;
281: IF (num_trxns = 0)
295: THEN
296:
297: SELECT count(*)
298: INTO counter
299: FROM iby_trxn_summaries_all
300: WHERE TangibleID = order_id_in
301: AND PayeeID = merchant_id_in;
302:
303:
310:
311: ELSE
312: SELECT DISTINCT TransactionId
313: INTO transaction_id
314: FROM iby_trxn_summaries_all
315: WHERE TangibleID = order_id_in
316: AND PayeeID = merchant_id_in;
317:
318: END IF;
330: --tangible info should already exist, get them based on
331: --transactionid
332: SELECT DISTINCT mtangibleid, tangibleid
333: INTO l_tmid, l_order_id
334: FROM iby_trxn_summaries_all
335: WHERE transactionid = transaction_id_in_out;
336:
337: transaction_id := transaction_id_in_out;
338: END IF;
337: transaction_id := transaction_id_in_out;
338: END IF;
339: iby_accppmtmthd_pkg.getMPayeeId(merchant_id_in, l_mpayeeid);
340:
341: INSERT INTO iby_trxn_summaries_all
342: (TrxnMID, TransactionID,TrxntypeID,
343: ECAPPID, org_id, ReqType, ReqDate, MtangibleId,
344: Amount,CurrencyNameCode, TangibleID,MPayeeID, PayeeID,BEPID,
345: BEPCode, BEPMessage,Errorlocation,PAYMENTMETHODNAME,status,
387: THEN
388: -- One previous transaction, so update previous row
389: SELECT TrxnMID, TransactionID,MtangibleId
390: INTO trxn_mid, transaction_id_in_out,l_tmid
391: FROM iby_trxn_summaries_all
392: WHERE TangibleID = order_id_in
393: AND UPPER(ReqType) = UPPER(req_type_in)
394: AND PayeeID = merchant_id_in;
395:
403: billeracct_in,refinfo_in,memo_in,
404: order_medium_in, eft_auth_method_in);
405: END IF;
406:
407: UPDATE iby_trxn_summaries_all
408: SET Amount = price_in,
409: CurrencyNameCode = currency_in,
410: UpdateDate = time_in,
411: Status = status_in,
468: /* transaction occurred. Since AUTH and AUTHREV are idempotent, the */
469: /* procedure checks to see if the row already exists based upon */
470: /* order_id, merchant_id, and split_id. */
471: PROCEDURE insert_auth_txn
472: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
473: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
474: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
475: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
476: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
469: /* procedure checks to see if the row already exists based upon */
470: /* order_id, merchant_id, and split_id. */
471: PROCEDURE insert_auth_txn
472: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
473: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
474: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
475: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
476: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
477: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
470: /* order_id, merchant_id, and split_id. */
471: PROCEDURE insert_auth_txn
472: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
473: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
474: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
475: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
476: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
477: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
478: split_id_in IN iby_trxn_extended.SplitID%TYPE,
471: PROCEDURE insert_auth_txn
472: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
473: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
474: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
475: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
476: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
477: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
478: split_id_in IN iby_trxn_extended.SplitID%TYPE,
479: payment_name_in IN iby_trxn_summaries_all.PaymentMethodName%TYPE,
472: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
473: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
474: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
475: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
476: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
477: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
478: split_id_in IN iby_trxn_extended.SplitID%TYPE,
479: payment_name_in IN iby_trxn_summaries_all.PaymentMethodName%TYPE,
480: price_in IN iby_trxn_summaries_all.Amount%TYPE,
473: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
474: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
475: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
476: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
477: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
478: split_id_in IN iby_trxn_extended.SplitID%TYPE,
479: payment_name_in IN iby_trxn_summaries_all.PaymentMethodName%TYPE,
480: price_in IN iby_trxn_summaries_all.Amount%TYPE,
481: currency_in IN iby_trxn_summaries_all.CurrencyNameCode%TYPE,
475: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
476: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
477: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
478: split_id_in IN iby_trxn_extended.SplitID%TYPE,
479: payment_name_in IN iby_trxn_summaries_all.PaymentMethodName%TYPE,
480: price_in IN iby_trxn_summaries_all.Amount%TYPE,
481: currency_in IN iby_trxn_summaries_all.CurrencyNameCode%TYPE,
482: time_in IN iby_trxn_summaries_all.UpdateDate%TYPE,
483: status_in IN iby_trxn_summaries_all.Status%TYPE,
476: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
477: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
478: split_id_in IN iby_trxn_extended.SplitID%TYPE,
479: payment_name_in IN iby_trxn_summaries_all.PaymentMethodName%TYPE,
480: price_in IN iby_trxn_summaries_all.Amount%TYPE,
481: currency_in IN iby_trxn_summaries_all.CurrencyNameCode%TYPE,
482: time_in IN iby_trxn_summaries_all.UpdateDate%TYPE,
483: status_in IN iby_trxn_summaries_all.Status%TYPE,
484: authcode_in IN iby_trxn_core.AuthCode%TYPE,
477: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
478: split_id_in IN iby_trxn_extended.SplitID%TYPE,
479: payment_name_in IN iby_trxn_summaries_all.PaymentMethodName%TYPE,
480: price_in IN iby_trxn_summaries_all.Amount%TYPE,
481: currency_in IN iby_trxn_summaries_all.CurrencyNameCode%TYPE,
482: time_in IN iby_trxn_summaries_all.UpdateDate%TYPE,
483: status_in IN iby_trxn_summaries_all.Status%TYPE,
484: authcode_in IN iby_trxn_core.AuthCode%TYPE,
485: capcode_in IN iby_trxn_core.OperationCode%TYPE,
478: split_id_in IN iby_trxn_extended.SplitID%TYPE,
479: payment_name_in IN iby_trxn_summaries_all.PaymentMethodName%TYPE,
480: price_in IN iby_trxn_summaries_all.Amount%TYPE,
481: currency_in IN iby_trxn_summaries_all.CurrencyNameCode%TYPE,
482: time_in IN iby_trxn_summaries_all.UpdateDate%TYPE,
483: status_in IN iby_trxn_summaries_all.Status%TYPE,
484: authcode_in IN iby_trxn_core.AuthCode%TYPE,
485: capcode_in IN iby_trxn_core.OperationCode%TYPE,
486: completion_code_in IN iby_trxn_extended.CompletionCode%TYPE,
479: payment_name_in IN iby_trxn_summaries_all.PaymentMethodName%TYPE,
480: price_in IN iby_trxn_summaries_all.Amount%TYPE,
481: currency_in IN iby_trxn_summaries_all.CurrencyNameCode%TYPE,
482: time_in IN iby_trxn_summaries_all.UpdateDate%TYPE,
483: status_in IN iby_trxn_summaries_all.Status%TYPE,
484: authcode_in IN iby_trxn_core.AuthCode%TYPE,
485: capcode_in IN iby_trxn_core.OperationCode%TYPE,
486: completion_code_in IN iby_trxn_extended.CompletionCode%TYPE,
487: set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,
484: authcode_in IN iby_trxn_core.AuthCode%TYPE,
485: capcode_in IN iby_trxn_core.OperationCode%TYPE,
486: completion_code_in IN iby_trxn_extended.CompletionCode%TYPE,
487: set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,
488: batch_id_in IN OUT NOCOPY iby_trxn_summaries_all.batchID%TYPE,
489: batch_seq_num_in IN OUT NOCOPY iby_trxn_extended.BatchSeqNum%TYPE,
490: AVS_result_in IN OUT NOCOPY iby_trxn_core.AVSCode%TYPE,
491: ret_ref_num_in IN iby_trxn_core.ReferenceCode%TYPE,
492: card_BIN_in IN OUT NOCOPY iby_trxn_extended.Cardbin%TYPE,
491: ret_ref_num_in IN iby_trxn_core.ReferenceCode%TYPE,
492: card_BIN_in IN OUT NOCOPY iby_trxn_extended.Cardbin%TYPE,
493: terminal_id_in IN OUT NOCOPY iby_trxn_extended.TerminalID%TYPE,
494: subseq_auth_ind_in IN iby_trxn_extended.SubAuthInd%TYPE,
495: vendor_code_in IN OUT NOCOPY iby_trxn_summaries_all.BEPCode%TYPE,
496: vendor_message_in IN OUT NOCOPY iby_trxn_summaries_all.BEPMessage%TYPE,
497: error_location_in IN OUT NOCOPY iby_trxn_summaries_all.ErrorLocation%TYPE,
498: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
499: payment_method_in IN
492: card_BIN_in IN OUT NOCOPY iby_trxn_extended.Cardbin%TYPE,
493: terminal_id_in IN OUT NOCOPY iby_trxn_extended.TerminalID%TYPE,
494: subseq_auth_ind_in IN iby_trxn_extended.SubAuthInd%TYPE,
495: vendor_code_in IN OUT NOCOPY iby_trxn_summaries_all.BEPCode%TYPE,
496: vendor_message_in IN OUT NOCOPY iby_trxn_summaries_all.BEPMessage%TYPE,
497: error_location_in IN OUT NOCOPY iby_trxn_summaries_all.ErrorLocation%TYPE,
498: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
499: payment_method_in IN
500: iby_trxn_summaries_all.PAYMENTMETHODNAME%TYPE,
493: terminal_id_in IN OUT NOCOPY iby_trxn_extended.TerminalID%TYPE,
494: subseq_auth_ind_in IN iby_trxn_extended.SubAuthInd%TYPE,
495: vendor_code_in IN OUT NOCOPY iby_trxn_summaries_all.BEPCode%TYPE,
496: vendor_message_in IN OUT NOCOPY iby_trxn_summaries_all.BEPMessage%TYPE,
497: error_location_in IN OUT NOCOPY iby_trxn_summaries_all.ErrorLocation%TYPE,
498: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
499: payment_method_in IN
500: iby_trxn_summaries_all.PAYMENTMETHODNAME%TYPE,
501: billeracct_in IN iby_tangible.acctno%type,
494: subseq_auth_ind_in IN iby_trxn_extended.SubAuthInd%TYPE,
495: vendor_code_in IN OUT NOCOPY iby_trxn_summaries_all.BEPCode%TYPE,
496: vendor_message_in IN OUT NOCOPY iby_trxn_summaries_all.BEPMessage%TYPE,
497: error_location_in IN OUT NOCOPY iby_trxn_summaries_all.ErrorLocation%TYPE,
498: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
499: payment_method_in IN
500: iby_trxn_summaries_all.PAYMENTMETHODNAME%TYPE,
501: billeracct_in IN iby_tangible.acctno%type,
502: refinfo_in IN iby_tangible.refinfo%type,
496: vendor_message_in IN OUT NOCOPY iby_trxn_summaries_all.BEPMessage%TYPE,
497: error_location_in IN OUT NOCOPY iby_trxn_summaries_all.ErrorLocation%TYPE,
498: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
499: payment_method_in IN
500: iby_trxn_summaries_all.PAYMENTMETHODNAME%TYPE,
501: billeracct_in IN iby_tangible.acctno%type,
502: refinfo_in IN iby_tangible.refinfo%type,
503: memo_in IN iby_tangible.memo%type,
504: order_medium_in IN iby_tangible.order_medium%TYPE,
502: refinfo_in IN iby_tangible.refinfo%type,
503: memo_in IN iby_tangible.memo%type,
504: order_medium_in IN iby_tangible.order_medium%TYPE,
505: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
506: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
507: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
508: instrnum_in IN iby_trxn_summaries_all.instrnumber%type)
509: IS
510: num_trxns NUMBER := 0;
503: memo_in IN iby_tangible.memo%type,
504: order_medium_in IN iby_tangible.order_medium%TYPE,
505: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
506: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
507: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
508: instrnum_in IN iby_trxn_summaries_all.instrnumber%type)
509: IS
510: num_trxns NUMBER := 0;
511: oper_code iby_trxn_core.OperationCode%TYPE;
504: order_medium_in IN iby_tangible.order_medium%TYPE,
505: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
506: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
507: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
508: instrnum_in IN iby_trxn_summaries_all.instrnumber%type)
509: IS
510: num_trxns NUMBER := 0;
511: oper_code iby_trxn_core.OperationCode%TYPE;
512: err_msg VARCHAR2(100);
511: oper_code iby_trxn_core.OperationCode%TYPE;
512: err_msg VARCHAR2(100);
513: trxn_mid NUMBER;
514: transaction_id NUMBER;
515: l_tmid iby_trxn_summaries_all.mtangibleid%type;
516: l_mpayeeid iby_payee.mpayeeid%type;
517: l_mbatchid iby_batches_all.mbatchid%type;
518: BEGIN
519: -- NULL optional parameters if they are empty string
566: -- Check for idempotency: see if transaction already
567: -- exists
568: SELECT count(*)
569: INTO num_trxns
570: FROM iby_trxn_summaries_all
571: WHERE TangibleID = order_id_in
572: AND UPPER(ReqType) = UPPER(req_type_in)
573: AND PayeeID = merchant_id_in;
574: IF (num_trxns = 0)
599: billeracct_in,refinfo_in, memo_in,
600: order_medium_in, eft_auth_method_in,
601: l_tmid);
602:
603: INSERT INTO iby_trxn_summaries_all
604: (TrxnMID, TangibleID,MPayeeID, PayeeID,BEPID, PaymentMethodName,
605: TransactionID,TrxntypeID, ECAPPID, org_id,
606: ReqType, ReqDate, MtangibleId,
607: Amount,CurrencyNameCode,
652: THEN
653: -- One previous transaction, so update previous row
654: SELECT TrxnMID, TransactionID,MtangibleId
655: INTO trxn_mid, transaction_id_in_out, l_tmid
656: FROM iby_trxn_summaries_all
657: WHERE TangibleID = order_id_in
658: AND UPPER(ReqType) = UPPER(req_type_in)
659: AND PayeeID = merchant_id_in;
660:
666: billeracct_in,refinfo_in,memo_in,
667: order_medium_in, eft_auth_method_in);
668:
669:
670: UPDATE iby_trxn_summaries_all
671: SET Amount = price_in,
672: CurrencyNameCode = currency_in,
673: UpdateDate = time_in,
674: Status = status_in,
729: /* would be called every time a SET CAPTURE, CAPTUREREV, CREDIT, or */
730: /* CREDITREV operation is performed. */
731:
732: PROCEDURE insert_other_txn
733: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
734: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
735: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
736: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
737: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
730: /* CREDITREV operation is performed. */
731:
732: PROCEDURE insert_other_txn
733: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
734: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
735: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
736: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
737: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
738: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
731:
732: PROCEDURE insert_other_txn
733: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
734: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
735: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
736: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
737: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
738: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
739: split_id_in IN iby_trxn_extended.SplitID%TYPE,
732: PROCEDURE insert_other_txn
733: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
734: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
735: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
736: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
737: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
738: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
739: split_id_in IN iby_trxn_extended.SplitID%TYPE,
740: payment_name_in IN iby_trxn_summaries_all.PAYMENTMETHODNAME%TYPE,
733: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
734: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
735: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
736: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
737: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
738: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
739: split_id_in IN iby_trxn_extended.SplitID%TYPE,
740: payment_name_in IN iby_trxn_summaries_all.PAYMENTMETHODNAME%TYPE,
741: price_in IN iby_trxn_summaries_all.Amount%TYPE,
734: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
735: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
736: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
737: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
738: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
739: split_id_in IN iby_trxn_extended.SplitID%TYPE,
740: payment_name_in IN iby_trxn_summaries_all.PAYMENTMETHODNAME%TYPE,
741: price_in IN iby_trxn_summaries_all.Amount%TYPE,
742: currency_in IN iby_trxn_summaries_all.CurrencyNameCode%TYPE,
736: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
737: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
738: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
739: split_id_in IN iby_trxn_extended.SplitID%TYPE,
740: payment_name_in IN iby_trxn_summaries_all.PAYMENTMETHODNAME%TYPE,
741: price_in IN iby_trxn_summaries_all.Amount%TYPE,
742: currency_in IN iby_trxn_summaries_all.CurrencyNameCode%TYPE,
743: time_in IN iby_trxn_summaries_all.UpdateDate%TYPE,
744: status_in IN iby_trxn_summaries_all.Status%TYPE,
737: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
738: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
739: split_id_in IN iby_trxn_extended.SplitID%TYPE,
740: payment_name_in IN iby_trxn_summaries_all.PAYMENTMETHODNAME%TYPE,
741: price_in IN iby_trxn_summaries_all.Amount%TYPE,
742: currency_in IN iby_trxn_summaries_all.CurrencyNameCode%TYPE,
743: time_in IN iby_trxn_summaries_all.UpdateDate%TYPE,
744: status_in IN iby_trxn_summaries_all.Status%TYPE,
745: operation_code_in IN iby_trxn_core.OperationCode%TYPE,
738: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
739: split_id_in IN iby_trxn_extended.SplitID%TYPE,
740: payment_name_in IN iby_trxn_summaries_all.PAYMENTMETHODNAME%TYPE,
741: price_in IN iby_trxn_summaries_all.Amount%TYPE,
742: currency_in IN iby_trxn_summaries_all.CurrencyNameCode%TYPE,
743: time_in IN iby_trxn_summaries_all.UpdateDate%TYPE,
744: status_in IN iby_trxn_summaries_all.Status%TYPE,
745: operation_code_in IN iby_trxn_core.OperationCode%TYPE,
746: set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,
739: split_id_in IN iby_trxn_extended.SplitID%TYPE,
740: payment_name_in IN iby_trxn_summaries_all.PAYMENTMETHODNAME%TYPE,
741: price_in IN iby_trxn_summaries_all.Amount%TYPE,
742: currency_in IN iby_trxn_summaries_all.CurrencyNameCode%TYPE,
743: time_in IN iby_trxn_summaries_all.UpdateDate%TYPE,
744: status_in IN iby_trxn_summaries_all.Status%TYPE,
745: operation_code_in IN iby_trxn_core.OperationCode%TYPE,
746: set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,
747: batch_id_in IN OUT NOCOPY iby_trxn_summaries_all.batchID%TYPE,
740: payment_name_in IN iby_trxn_summaries_all.PAYMENTMETHODNAME%TYPE,
741: price_in IN iby_trxn_summaries_all.Amount%TYPE,
742: currency_in IN iby_trxn_summaries_all.CurrencyNameCode%TYPE,
743: time_in IN iby_trxn_summaries_all.UpdateDate%TYPE,
744: status_in IN iby_trxn_summaries_all.Status%TYPE,
745: operation_code_in IN iby_trxn_core.OperationCode%TYPE,
746: set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,
747: batch_id_in IN OUT NOCOPY iby_trxn_summaries_all.batchID%TYPE,
748: batch_seq_num_in IN OUT NOCOPY iby_trxn_extended.BatchSeqNum%TYPE,
743: time_in IN iby_trxn_summaries_all.UpdateDate%TYPE,
744: status_in IN iby_trxn_summaries_all.Status%TYPE,
745: operation_code_in IN iby_trxn_core.OperationCode%TYPE,
746: set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,
747: batch_id_in IN OUT NOCOPY iby_trxn_summaries_all.batchID%TYPE,
748: batch_seq_num_in IN OUT NOCOPY iby_trxn_extended.BatchSeqNum%TYPE,
749: terminal_id_in IN OUT NOCOPY iby_trxn_extended.TerminalID%TYPE,
750: subseq_auth_ind_in IN iby_trxn_extended.SubAuthInd%TYPE,
751: vendor_code_in IN OUT NOCOPY iby_trxn_summaries_all.BEPCode%TYPE,
747: batch_id_in IN OUT NOCOPY iby_trxn_summaries_all.batchID%TYPE,
748: batch_seq_num_in IN OUT NOCOPY iby_trxn_extended.BatchSeqNum%TYPE,
749: terminal_id_in IN OUT NOCOPY iby_trxn_extended.TerminalID%TYPE,
750: subseq_auth_ind_in IN iby_trxn_extended.SubAuthInd%TYPE,
751: vendor_code_in IN OUT NOCOPY iby_trxn_summaries_all.BEPCode%TYPE,
752: vendor_message_in IN OUT NOCOPY iby_trxn_summaries_all.BEPMessage%TYPE,
753: error_location_in IN OUT NOCOPY iby_trxn_summaries_all.ErrorLocation%TYPE,
754: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
755: billeracct_in IN iby_tangible.acctno%type,
748: batch_seq_num_in IN OUT NOCOPY iby_trxn_extended.BatchSeqNum%TYPE,
749: terminal_id_in IN OUT NOCOPY iby_trxn_extended.TerminalID%TYPE,
750: subseq_auth_ind_in IN iby_trxn_extended.SubAuthInd%TYPE,
751: vendor_code_in IN OUT NOCOPY iby_trxn_summaries_all.BEPCode%TYPE,
752: vendor_message_in IN OUT NOCOPY iby_trxn_summaries_all.BEPMessage%TYPE,
753: error_location_in IN OUT NOCOPY iby_trxn_summaries_all.ErrorLocation%TYPE,
754: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
755: billeracct_in IN iby_tangible.acctno%type,
756: refinfo_in IN iby_tangible.refinfo%type,
749: terminal_id_in IN OUT NOCOPY iby_trxn_extended.TerminalID%TYPE,
750: subseq_auth_ind_in IN iby_trxn_extended.SubAuthInd%TYPE,
751: vendor_code_in IN OUT NOCOPY iby_trxn_summaries_all.BEPCode%TYPE,
752: vendor_message_in IN OUT NOCOPY iby_trxn_summaries_all.BEPMessage%TYPE,
753: error_location_in IN OUT NOCOPY iby_trxn_summaries_all.ErrorLocation%TYPE,
754: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
755: billeracct_in IN iby_tangible.acctno%type,
756: refinfo_in IN iby_tangible.refinfo%type,
757: memo_in IN iby_tangible.memo%type,
750: subseq_auth_ind_in IN iby_trxn_extended.SubAuthInd%TYPE,
751: vendor_code_in IN OUT NOCOPY iby_trxn_summaries_all.BEPCode%TYPE,
752: vendor_message_in IN OUT NOCOPY iby_trxn_summaries_all.BEPMessage%TYPE,
753: error_location_in IN OUT NOCOPY iby_trxn_summaries_all.ErrorLocation%TYPE,
754: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
755: billeracct_in IN iby_tangible.acctno%type,
756: refinfo_in IN iby_tangible.refinfo%type,
757: memo_in IN iby_tangible.memo%type,
758: order_medium_in IN iby_tangible.order_medium%TYPE,
756: refinfo_in IN iby_tangible.refinfo%type,
757: memo_in IN iby_tangible.memo%type,
758: order_medium_in IN iby_tangible.order_medium%TYPE,
759: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
760: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
761: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
762: instrnum_in IN iby_trxn_summaries_all.instrnumber%type)
763: IS
764: num_trxns NUMBER := 0;
757: memo_in IN iby_tangible.memo%type,
758: order_medium_in IN iby_tangible.order_medium%TYPE,
759: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
760: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
761: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
762: instrnum_in IN iby_trxn_summaries_all.instrnumber%type)
763: IS
764: num_trxns NUMBER := 0;
765: counter NUMBER := 0;
758: order_medium_in IN iby_tangible.order_medium%TYPE,
759: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
760: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
761: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
762: instrnum_in IN iby_trxn_summaries_all.instrnumber%type)
763: IS
764: num_trxns NUMBER := 0;
765: counter NUMBER := 0;
766: err_msg VARCHAR2(100);
765: counter NUMBER := 0;
766: err_msg VARCHAR2(100);
767: trxn_mid NUMBER;
768: transaction_id NUMBER;
769: l_tmid iby_trxn_summaries_all.mtangibleid%type;
770: l_order_id iby_trxn_summaries_all.tangibleid%type;
771: l_mpayeeid iby_payee.mpayeeid%type;
772: l_mbatchid iby_batches_all.mbatchid%type;
773: BEGIN
766: err_msg VARCHAR2(100);
767: trxn_mid NUMBER;
768: transaction_id NUMBER;
769: l_tmid iby_trxn_summaries_all.mtangibleid%type;
770: l_order_id iby_trxn_summaries_all.tangibleid%type;
771: l_mpayeeid iby_payee.mpayeeid%type;
772: l_mbatchid iby_batches_all.mbatchid%type;
773: BEGIN
774: -- NULL optional parameters if they are empty string
795: -- Check for idempotency: see if transaction already
796: -- exists
797: SELECT count(*)
798: INTO num_trxns
799: FROM iby_trxn_summaries_all summary, iby_trxn_extended extended
800: WHERE summary.TangibleID = order_id_in
801: AND summary.PayeeID = merchant_id_in
802: AND extended.SplitID = split_id_in
803: AND UPPER(summary.ReqType) = UPPER(req_type_in)
814: THEN
815:
816: SELECT count(*)
817: INTO counter
818: FROM iby_trxn_summaries_all
819: WHERE TangibleID = order_id_in
820: AND PayeeID = merchant_id_in;
821:
822: IF (counter = 0)
828:
829: ELSE
830: SELECT DISTINCT TransactionId
831: INTO transaction_id
832: FROM iby_trxn_summaries_all
833: WHERE TangibleID = order_id_in
834: AND PayeeID = merchant_id_in;
835:
836: END IF;
847: --tangible info should already exist, get them based on
848: --transactionid
849: SELECT DISTINCT mtangibleid, tangibleid
850: INTO l_tmid, l_order_id
851: FROM iby_trxn_summaries_all
852: WHERE transactionid = transaction_id_in_out;
853:
854: transaction_id := transaction_id_in_out;
855: END IF;
859: iby_accppmtmthd_pkg.getMPayeeId(merchant_id_in, l_mpayeeid);
860:
861:
862:
863: INSERT INTO iby_trxn_summaries_all
864: (TrxnMID, TangibleID,MPayeeID, PayeeID,BEPID,
865: TransactionID,TrxntypeID, ECAPPID, org_id, ReqType, ReqDate,
866: MtangibleId,
867: Amount,CurrencyNameCode, UpdateDate,Status,MBatchID, BatchID,
915: THEN
916: -- One previous transaction, so update previous row
917: SELECT summary.TrxnMID, summary.TransactionID,MtangibleId
918: INTO trxn_mid, transaction_id_in_out,l_tmid
919: FROM iby_trxn_summaries_all summary, iby_trxn_extended extended
920: WHERE summary.TangibleID = order_id_in
921: AND summary.PayeeID = merchant_id_in
922: AND extended.SplitID = split_id_in
923: AND UPPER(summary.ReqType) = UPPER(req_type_in)
932: billeracct_in,refinfo_in,memo_in,
933: order_medium_in, eft_auth_method_in);
934: END IF;
935:
936: UPDATE iby_trxn_summaries_all
937: SET Amount = price_in,
938: CurrencyNameCode = currency_in,
939: UpdateDate = time_in,
940: Status = status_in,
988:
989: /* Inserts or updates a row in the PS_TRXN_TABLE if the */
990: /* operation timed out from calling the vendor. */
991: PROCEDURE insert_timeout_txn
992: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
993: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
994: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
995: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
996: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
989: /* Inserts or updates a row in the PS_TRXN_TABLE if the */
990: /* operation timed out from calling the vendor. */
991: PROCEDURE insert_timeout_txn
992: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
993: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
994: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
995: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
996: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
997: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
990: /* operation timed out from calling the vendor. */
991: PROCEDURE insert_timeout_txn
992: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
993: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
994: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
995: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
996: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
997: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
998: split_id_in IN iby_trxn_extended.SplitID%TYPE,
991: PROCEDURE insert_timeout_txn
992: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
993: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
994: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
995: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
996: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
997: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
998: split_id_in IN iby_trxn_extended.SplitID%TYPE,
999: payment_name_in IN iby_trxn_core.InstrName%TYPE,
992: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
993: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
994: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
995: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
996: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
997: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
998: split_id_in IN iby_trxn_extended.SplitID%TYPE,
999: payment_name_in IN iby_trxn_core.InstrName%TYPE,
1000: time_in IN iby_trxn_summaries_all.UpdateDate%TYPE,
993: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
994: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
995: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
996: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
997: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
998: split_id_in IN iby_trxn_extended.SplitID%TYPE,
999: payment_name_in IN iby_trxn_core.InstrName%TYPE,
1000: time_in IN iby_trxn_summaries_all.UpdateDate%TYPE,
1001: status_in IN iby_trxn_summaries_all.Status%TYPE,
996: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
997: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
998: split_id_in IN iby_trxn_extended.SplitID%TYPE,
999: payment_name_in IN iby_trxn_core.InstrName%TYPE,
1000: time_in IN iby_trxn_summaries_all.UpdateDate%TYPE,
1001: status_in IN iby_trxn_summaries_all.Status%TYPE,
1002: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
1003: currency_in IN iby_tangible.currencynamecode%type,
1004: amount_in IN iby_transactions_v.amount%TYPE,
997: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
998: split_id_in IN iby_trxn_extended.SplitID%TYPE,
999: payment_name_in IN iby_trxn_core.InstrName%TYPE,
1000: time_in IN iby_trxn_summaries_all.UpdateDate%TYPE,
1001: status_in IN iby_trxn_summaries_all.Status%TYPE,
1002: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
1003: currency_in IN iby_tangible.currencynamecode%type,
1004: amount_in IN iby_transactions_v.amount%TYPE,
1005: billeracct_in IN iby_tangible.acctno%type,
998: split_id_in IN iby_trxn_extended.SplitID%TYPE,
999: payment_name_in IN iby_trxn_core.InstrName%TYPE,
1000: time_in IN iby_trxn_summaries_all.UpdateDate%TYPE,
1001: status_in IN iby_trxn_summaries_all.Status%TYPE,
1002: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
1003: currency_in IN iby_tangible.currencynamecode%type,
1004: amount_in IN iby_transactions_v.amount%TYPE,
1005: billeracct_in IN iby_tangible.acctno%type,
1006: refinfo_in IN iby_tangible.refinfo%type,
1006: refinfo_in IN iby_tangible.refinfo%type,
1007: memo_in IN iby_tangible.memo%type,
1008: order_medium_in IN iby_tangible.order_medium%TYPE,
1009: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
1010: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
1011: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
1012: instrnum_in IN iby_trxn_summaries_all.instrnumber%type)
1013: IS
1014: num_trxns NUMBER := 0;
1007: memo_in IN iby_tangible.memo%type,
1008: order_medium_in IN iby_tangible.order_medium%TYPE,
1009: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
1010: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
1011: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
1012: instrnum_in IN iby_trxn_summaries_all.instrnumber%type)
1013: IS
1014: num_trxns NUMBER := 0;
1015: err_msg VARCHAR2(100);
1008: order_medium_in IN iby_tangible.order_medium%TYPE,
1009: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
1010: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
1011: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
1012: instrnum_in IN iby_trxn_summaries_all.instrnumber%type)
1013: IS
1014: num_trxns NUMBER := 0;
1015: err_msg VARCHAR2(100);
1016: trxn_mid NUMBER;
1014: num_trxns NUMBER := 0;
1015: err_msg VARCHAR2(100);
1016: trxn_mid NUMBER;
1017: transaction_id NUMBER;
1018: l_tmid iby_trxn_summaries_all.mtangibleid%type;
1019: l_order_id iby_trxn_summaries_all.tangibleid%type;
1020: l_mpayeeid iby_payee.mpayeeid%type;
1021: BEGIN
1022: -- Count number of previous transactions
1015: err_msg VARCHAR2(100);
1016: trxn_mid NUMBER;
1017: transaction_id NUMBER;
1018: l_tmid iby_trxn_summaries_all.mtangibleid%type;
1019: l_order_id iby_trxn_summaries_all.tangibleid%type;
1020: l_mpayeeid iby_payee.mpayeeid%type;
1021: BEGIN
1022: -- Count number of previous transactions
1023: SELECT count(*)
1021: BEGIN
1022: -- Count number of previous transactions
1023: SELECT count(*)
1024: INTO num_trxns
1025: FROM iby_trxn_summaries_all
1026: WHERE TangibleID = order_id_in
1027: AND UPPER(ReqType) = UPPER(req_type_in)
1028: AND PayeeID = merchant_id_in;
1029: IF (num_trxns = 0)
1052: l_order_id := order_id_in;
1053: ELSE
1054: SELECT DISTINCT mtangibleid, tangibleid
1055: INTO l_tmid, l_order_id
1056: FROM iby_trxn_summaries_all
1057: WHERE transactionid = transaction_id_in_out;
1058:
1059: transaction_id := transaction_id_in_out;
1060: END IF;
1058:
1059: transaction_id := transaction_id_in_out;
1060: END IF;
1061:
1062: INSERT INTO iby_trxn_summaries_all
1063: (TrxnMID, TransactionID, ECAPPID, org_id,
1064: TangibleID, MPayeeID, PayeeID, BEPID, PaymentMethodName,
1065: TrxntypeID, ReqType, ReqDate, MtangibleId,
1066: UpdateDate,Status,
1104: THEN
1105: -- One previous transaction, so update previous row
1106: SELECT TrxnMID, MtangibleId
1107: INTO trxn_mid, l_tmid
1108: FROM iby_trxn_summaries_all
1109: WHERE TangibleID = order_id_in
1110: AND UPPER(ReqType) = UPPER(req_type_in)
1111: AND PayeeID = merchant_id_in;
1112:
1118: order_medium_in, eft_auth_method_in);
1119: END IF;
1120:
1121:
1122: UPDATE iby_trxn_summaries_all
1123: SET
1124: UpdateDate = time_in,
1125: --ReqDate = time_in,
1126: Status = status_in,
1264:
1265: /* Inserts or updates the batch detail record upon the */
1266: /* closebatch or querybatch operations. */
1267: PROCEDURE insert_batch_txn
1268: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
1269: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
1270: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
1271: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
1272: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
1265: /* Inserts or updates the batch detail record upon the */
1266: /* closebatch or querybatch operations. */
1267: PROCEDURE insert_batch_txn
1268: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
1269: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
1270: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
1271: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
1272: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
1273: split_id_in IN iby_trxn_extended.SplitID%TYPE,
1266: /* closebatch or querybatch operations. */
1267: PROCEDURE insert_batch_txn
1268: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
1269: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
1270: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
1271: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
1272: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
1273: split_id_in IN iby_trxn_extended.SplitID%TYPE,
1274: payment_name_in IN iby_trxn_core.InstrName%TYPE,
1267: PROCEDURE insert_batch_txn
1268: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
1269: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
1270: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
1271: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
1272: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
1273: split_id_in IN iby_trxn_extended.SplitID%TYPE,
1274: payment_name_in IN iby_trxn_core.InstrName%TYPE,
1275: price_in IN iby_trxn_summaries_all.Amount%TYPE,
1268: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
1269: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
1270: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
1271: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
1272: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
1273: split_id_in IN iby_trxn_extended.SplitID%TYPE,
1274: payment_name_in IN iby_trxn_core.InstrName%TYPE,
1275: price_in IN iby_trxn_summaries_all.Amount%TYPE,
1276: currency_in IN iby_trxn_summaries_all.CurrencyNameCode%TYPE,
1271: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
1272: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
1273: split_id_in IN iby_trxn_extended.SplitID%TYPE,
1274: payment_name_in IN iby_trxn_core.InstrName%TYPE,
1275: price_in IN iby_trxn_summaries_all.Amount%TYPE,
1276: currency_in IN iby_trxn_summaries_all.CurrencyNameCode%TYPE,
1277: time_in IN iby_trxn_summaries_all.UpdateDate%TYPE,
1278: status_in IN iby_trxn_summaries_all.Status%TYPE,
1279: set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,
1272: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
1273: split_id_in IN iby_trxn_extended.SplitID%TYPE,
1274: payment_name_in IN iby_trxn_core.InstrName%TYPE,
1275: price_in IN iby_trxn_summaries_all.Amount%TYPE,
1276: currency_in IN iby_trxn_summaries_all.CurrencyNameCode%TYPE,
1277: time_in IN iby_trxn_summaries_all.UpdateDate%TYPE,
1278: status_in IN iby_trxn_summaries_all.Status%TYPE,
1279: set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,
1280: prev_set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,
1273: split_id_in IN iby_trxn_extended.SplitID%TYPE,
1274: payment_name_in IN iby_trxn_core.InstrName%TYPE,
1275: price_in IN iby_trxn_summaries_all.Amount%TYPE,
1276: currency_in IN iby_trxn_summaries_all.CurrencyNameCode%TYPE,
1277: time_in IN iby_trxn_summaries_all.UpdateDate%TYPE,
1278: status_in IN iby_trxn_summaries_all.Status%TYPE,
1279: set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,
1280: prev_set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,
1281: batch_id_in IN iby_trxn_summaries_all.batchID%TYPE,
1274: payment_name_in IN iby_trxn_core.InstrName%TYPE,
1275: price_in IN iby_trxn_summaries_all.Amount%TYPE,
1276: currency_in IN iby_trxn_summaries_all.CurrencyNameCode%TYPE,
1277: time_in IN iby_trxn_summaries_all.UpdateDate%TYPE,
1278: status_in IN iby_trxn_summaries_all.Status%TYPE,
1279: set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,
1280: prev_set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,
1281: batch_id_in IN iby_trxn_summaries_all.batchID%TYPE,
1282: batch_seq_num_in IN iby_trxn_extended.BatchSeqNum%TYPE,
1277: time_in IN iby_trxn_summaries_all.UpdateDate%TYPE,
1278: status_in IN iby_trxn_summaries_all.Status%TYPE,
1279: set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,
1280: prev_set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,
1281: batch_id_in IN iby_trxn_summaries_all.batchID%TYPE,
1282: batch_seq_num_in IN iby_trxn_extended.BatchSeqNum%TYPE,
1283: batch_trxn_status_in IN iby_trxn_extended.BatchTrxnStatus%TYPE,
1284: card_BIN_in IN iby_trxn_extended.Cardbin%TYPE,
1285: terminal_id_in IN iby_trxn_extended.TerminalID%TYPE,
1282: batch_seq_num_in IN iby_trxn_extended.BatchSeqNum%TYPE,
1283: batch_trxn_status_in IN iby_trxn_extended.BatchTrxnStatus%TYPE,
1284: card_BIN_in IN iby_trxn_extended.Cardbin%TYPE,
1285: terminal_id_in IN iby_trxn_extended.TerminalID%TYPE,
1286: vendor_code_in IN iby_trxn_summaries_all.BEPCode%TYPE,
1287: vendor_message_in IN iby_trxn_summaries_all.BEPMessage%TYPE,
1288: error_location_in IN iby_trxn_summaries_all.ErrorLocation%TYPE,
1289: split_id_in_out IN OUT NOCOPY iby_trxn_extended.SplitID%TYPE,
1290: org_id_in IN iby_trxn_summaries_all.org_id%TYPE)
1283: batch_trxn_status_in IN iby_trxn_extended.BatchTrxnStatus%TYPE,
1284: card_BIN_in IN iby_trxn_extended.Cardbin%TYPE,
1285: terminal_id_in IN iby_trxn_extended.TerminalID%TYPE,
1286: vendor_code_in IN iby_trxn_summaries_all.BEPCode%TYPE,
1287: vendor_message_in IN iby_trxn_summaries_all.BEPMessage%TYPE,
1288: error_location_in IN iby_trxn_summaries_all.ErrorLocation%TYPE,
1289: split_id_in_out IN OUT NOCOPY iby_trxn_extended.SplitID%TYPE,
1290: org_id_in IN iby_trxn_summaries_all.org_id%TYPE)
1291:
1284: card_BIN_in IN iby_trxn_extended.Cardbin%TYPE,
1285: terminal_id_in IN iby_trxn_extended.TerminalID%TYPE,
1286: vendor_code_in IN iby_trxn_summaries_all.BEPCode%TYPE,
1287: vendor_message_in IN iby_trxn_summaries_all.BEPMessage%TYPE,
1288: error_location_in IN iby_trxn_summaries_all.ErrorLocation%TYPE,
1289: split_id_in_out IN OUT NOCOPY iby_trxn_extended.SplitID%TYPE,
1290: org_id_in IN iby_trxn_summaries_all.org_id%TYPE)
1291:
1292: IS
1286: vendor_code_in IN iby_trxn_summaries_all.BEPCode%TYPE,
1287: vendor_message_in IN iby_trxn_summaries_all.BEPMessage%TYPE,
1288: error_location_in IN iby_trxn_summaries_all.ErrorLocation%TYPE,
1289: split_id_in_out IN OUT NOCOPY iby_trxn_extended.SplitID%TYPE,
1290: org_id_in IN iby_trxn_summaries_all.org_id%TYPE)
1291:
1292: IS
1293: num_trxns NUMBER := 0;
1294: err_msg VARCHAR2(100);
1300: -- Check for idempotency: see if transaction already
1301: -- exists
1302: SELECT count(*)
1303: INTO num_trxns
1304: FROM iby_trxn_extended extended, iby_trxn_summaries_all summary
1305: WHERE extended.SETTrxnID = set_trxn_id_in
1306: AND summary.BEPID = vendor_id_in
1307: AND extended.TrxnMID = summary.TrxnMID;
1308: IF (num_trxns = 0)
1332:
1333: iby_transactioncc_pkg.getMBatchID(batch_id_in, merchant_id_in,
1334: l_mbatchid);
1335: iby_accppmtmthd_pkg.getMPayeeId(merchant_id_in, l_mpayeeid);
1336: INSERT INTO iby_trxn_summaries_all
1337: (TrxnMID, TangibleID,MPayeeID, PayeeID,BEPID,
1338: TrxntypeID, ECAPPID, org_id,
1339: Amount,CurrencyNameCode, UpdateDate,Status,MBatchID, BatchID,
1340: BEPCode, BEPMessage,Errorlocation,
1367: THEN
1368: -- Update current row
1369: SELECT summary.TrxnMID
1370: INTO trxn_mid
1371: FROM iby_trxn_extended extended, iby_trxn_summaries_all summary
1372: WHERE extended.SETTrxnID = set_trxn_id_in
1373: AND summary.BEPID = vendor_id_in
1374: AND extended.TrxnMID = summary.TrxnMID;
1375:
1384:
1385: -- Get split_id for output
1386: SELECT extended.SplitID
1387: INTO split_id_in_out
1388: FROM iby_trxn_extended extended, iby_trxn_summaries_all summary
1389: WHERE extended.SETTrxnID = set_trxn_id_in
1390: AND summary.BEPID = vendor_id_in
1391: AND extended.TrxnMID = summary.TrxnMID;
1392: -- Update card BIN only if it's not null
1394: (card_BIN_in IS NOT NULL))
1395: THEN
1396: SELECT summary.TrxnMID
1397: INTO trxn_mid
1398: FROM iby_trxn_extended extended, iby_trxn_summaries_all summary
1399: WHERE extended.SETTrxnID = set_trxn_id_in
1400: AND summary.BEPID = vendor_id_in
1401: AND extended.TrxnMID = summary.TrxnMID;
1402:
1413: (terminal_id_in IS NOT NULL))
1414: THEN
1415: SELECT summary.TrxnMID
1416: INTO trxn_mid
1417: FROM iby_trxn_extended extended, iby_trxn_summaries_all summary
1418: WHERE extended.SETTrxnID = set_trxn_id_in
1419: AND summary.BEPID = vendor_id_in
1420: AND extended.TrxnMID = summary.TrxnMID;
1421: UPDATE iby_trxn_extended
1431: (error_location_in IS NOT NULL))
1432: THEN
1433: SELECT summary.TrxnMID
1434: INTO trxn_mid
1435: FROM iby_trxn_extended extended, iby_trxn_summaries_all summary
1436: WHERE extended.SETTrxnID = set_trxn_id_in
1437: AND summary.BEPID = vendor_id_in
1438: AND extended.TrxnMID = summary.TrxnMID;
1439: UPDATE iby_trxn_summaries_all
1435: FROM iby_trxn_extended extended, iby_trxn_summaries_all summary
1436: WHERE extended.SETTrxnID = set_trxn_id_in
1437: AND summary.BEPID = vendor_id_in
1438: AND extended.TrxnMID = summary.TrxnMID;
1439: UPDATE iby_trxn_summaries_all
1440: SET ErrorLocation = error_location_in,
1441: last_update_date = sysdate,
1442: updatedate = sysdate,
1443: last_updated_by = fnd_global.user_id,
1450: (vendor_code_in IS NOT NULL))
1451: THEN
1452: SELECT summary.TrxnMID
1453: INTO trxn_mid
1454: FROM iby_trxn_extended extended, iby_trxn_summaries_all summary
1455: WHERE extended.SETTrxnID = set_trxn_id_in
1456: AND summary.BEPID = vendor_id_in
1457: AND extended.TrxnMID = summary.TrxnMID;
1458: UPDATE iby_trxn_summaries_all
1454: FROM iby_trxn_extended extended, iby_trxn_summaries_all summary
1455: WHERE extended.SETTrxnID = set_trxn_id_in
1456: AND summary.BEPID = vendor_id_in
1457: AND extended.TrxnMID = summary.TrxnMID;
1458: UPDATE iby_trxn_summaries_all
1459: SET BEPCode = vendor_code_in,
1460: last_update_date = sysdate,
1461: updatedate = sysdate,
1462: last_updated_by = fnd_global.user_id,
1469: (vendor_message_in IS NOT NULL))
1470: THEN
1471: SELECT summary.TrxnMID
1472: INTO trxn_mid
1473: FROM iby_trxn_extended extended, iby_trxn_summaries_all summary
1474: WHERE extended.SETTrxnID = set_trxn_id_in
1475: AND summary.BEPID = vendor_id_in
1476: AND extended.TrxnMID = summary.TrxnMID;
1477: UPDATE iby_trxn_summaries_all
1473: FROM iby_trxn_extended extended, iby_trxn_summaries_all summary
1474: WHERE extended.SETTrxnID = set_trxn_id_in
1475: AND summary.BEPID = vendor_id_in
1476: AND extended.TrxnMID = summary.TrxnMID;
1477: UPDATE iby_trxn_summaries_all
1478: SET BEPMessage = vendor_message_in,
1479: last_update_date = sysdate,
1480: updatedate = sysdate,
1481: last_updated_by = fnd_global.user_id,
1501:
1502:
1503: /* Inserts transaction record for transaction query operation */
1504: PROCEDURE insert_query_txn
1505: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
1506: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
1507: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
1508: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
1509: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
1502:
1503: /* Inserts transaction record for transaction query operation */
1504: PROCEDURE insert_query_txn
1505: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
1506: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
1507: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
1508: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
1509: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
1510: price_in IN iby_trxn_summaries_all.Amount%TYPE,
1503: /* Inserts transaction record for transaction query operation */
1504: PROCEDURE insert_query_txn
1505: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
1506: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
1507: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
1508: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
1509: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
1510: price_in IN iby_trxn_summaries_all.Amount%TYPE,
1511: currency_in IN iby_trxn_summaries_all.CurrencyNameCode%TYPE,
1504: PROCEDURE insert_query_txn
1505: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
1506: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
1507: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
1508: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
1509: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
1510: price_in IN iby_trxn_summaries_all.Amount%TYPE,
1511: currency_in IN iby_trxn_summaries_all.CurrencyNameCode%TYPE,
1512: time_in IN iby_trxn_summaries_all.UpdateDate%TYPE,
1505: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
1506: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
1507: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
1508: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
1509: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
1510: price_in IN iby_trxn_summaries_all.Amount%TYPE,
1511: currency_in IN iby_trxn_summaries_all.CurrencyNameCode%TYPE,
1512: time_in IN iby_trxn_summaries_all.UpdateDate%TYPE,
1513: status_in IN iby_trxn_summaries_all.Status%TYPE,
1506: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
1507: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
1508: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
1509: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
1510: price_in IN iby_trxn_summaries_all.Amount%TYPE,
1511: currency_in IN iby_trxn_summaries_all.CurrencyNameCode%TYPE,
1512: time_in IN iby_trxn_summaries_all.UpdateDate%TYPE,
1513: status_in IN iby_trxn_summaries_all.Status%TYPE,
1514: set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,
1507: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
1508: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
1509: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
1510: price_in IN iby_trxn_summaries_all.Amount%TYPE,
1511: currency_in IN iby_trxn_summaries_all.CurrencyNameCode%TYPE,
1512: time_in IN iby_trxn_summaries_all.UpdateDate%TYPE,
1513: status_in IN iby_trxn_summaries_all.Status%TYPE,
1514: set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,
1515: prev_set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,
1508: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
1509: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
1510: price_in IN iby_trxn_summaries_all.Amount%TYPE,
1511: currency_in IN iby_trxn_summaries_all.CurrencyNameCode%TYPE,
1512: time_in IN iby_trxn_summaries_all.UpdateDate%TYPE,
1513: status_in IN iby_trxn_summaries_all.Status%TYPE,
1514: set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,
1515: prev_set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,
1516: ret_ref_num_in IN iby_trxn_core.ReferenceCode%TYPE,
1509: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
1510: price_in IN iby_trxn_summaries_all.Amount%TYPE,
1511: currency_in IN iby_trxn_summaries_all.CurrencyNameCode%TYPE,
1512: time_in IN iby_trxn_summaries_all.UpdateDate%TYPE,
1513: status_in IN iby_trxn_summaries_all.Status%TYPE,
1514: set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,
1515: prev_set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,
1516: ret_ref_num_in IN iby_trxn_core.ReferenceCode%TYPE,
1517: card_BIN_in IN OUT NOCOPY iby_trxn_extended.Cardbin%TYPE,
1515: prev_set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,
1516: ret_ref_num_in IN iby_trxn_core.ReferenceCode%TYPE,
1517: card_BIN_in IN OUT NOCOPY iby_trxn_extended.Cardbin%TYPE,
1518: terminal_id_in IN OUT NOCOPY iby_trxn_extended.TerminalID%TYPE,
1519: vendor_code_in IN OUT NOCOPY iby_trxn_summaries_all.BEPCode%TYPE,
1520: vendor_message_in IN OUT NOCOPY iby_trxn_summaries_all.BEPMessage%TYPE,
1521: error_location_in IN OUT NOCOPY iby_trxn_summaries_all.ErrorLocation%TYPE,
1522: split_id_in_out IN OUT NOCOPY iby_trxn_extended.SplitID%TYPE,
1523: transaction_id_in IN iby_trxn_summaries_all.TransactionID%TYPE,
1516: ret_ref_num_in IN iby_trxn_core.ReferenceCode%TYPE,
1517: card_BIN_in IN OUT NOCOPY iby_trxn_extended.Cardbin%TYPE,
1518: terminal_id_in IN OUT NOCOPY iby_trxn_extended.TerminalID%TYPE,
1519: vendor_code_in IN OUT NOCOPY iby_trxn_summaries_all.BEPCode%TYPE,
1520: vendor_message_in IN OUT NOCOPY iby_trxn_summaries_all.BEPMessage%TYPE,
1521: error_location_in IN OUT NOCOPY iby_trxn_summaries_all.ErrorLocation%TYPE,
1522: split_id_in_out IN OUT NOCOPY iby_trxn_extended.SplitID%TYPE,
1523: transaction_id_in IN iby_trxn_summaries_all.TransactionID%TYPE,
1524: payment_method_in IN iby_trxn_summaries_all.PaymentMethodName%TYPE,
1517: card_BIN_in IN OUT NOCOPY iby_trxn_extended.Cardbin%TYPE,
1518: terminal_id_in IN OUT NOCOPY iby_trxn_extended.TerminalID%TYPE,
1519: vendor_code_in IN OUT NOCOPY iby_trxn_summaries_all.BEPCode%TYPE,
1520: vendor_message_in IN OUT NOCOPY iby_trxn_summaries_all.BEPMessage%TYPE,
1521: error_location_in IN OUT NOCOPY iby_trxn_summaries_all.ErrorLocation%TYPE,
1522: split_id_in_out IN OUT NOCOPY iby_trxn_extended.SplitID%TYPE,
1523: transaction_id_in IN iby_trxn_summaries_all.TransactionID%TYPE,
1524: payment_method_in IN iby_trxn_summaries_all.PaymentMethodName%TYPE,
1525: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
1519: vendor_code_in IN OUT NOCOPY iby_trxn_summaries_all.BEPCode%TYPE,
1520: vendor_message_in IN OUT NOCOPY iby_trxn_summaries_all.BEPMessage%TYPE,
1521: error_location_in IN OUT NOCOPY iby_trxn_summaries_all.ErrorLocation%TYPE,
1522: split_id_in_out IN OUT NOCOPY iby_trxn_extended.SplitID%TYPE,
1523: transaction_id_in IN iby_trxn_summaries_all.TransactionID%TYPE,
1524: payment_method_in IN iby_trxn_summaries_all.PaymentMethodName%TYPE,
1525: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
1526: req_type_in IN iby_trxn_summaries_all.reqtype%type)
1527: IS
1520: vendor_message_in IN OUT NOCOPY iby_trxn_summaries_all.BEPMessage%TYPE,
1521: error_location_in IN OUT NOCOPY iby_trxn_summaries_all.ErrorLocation%TYPE,
1522: split_id_in_out IN OUT NOCOPY iby_trxn_extended.SplitID%TYPE,
1523: transaction_id_in IN iby_trxn_summaries_all.TransactionID%TYPE,
1524: payment_method_in IN iby_trxn_summaries_all.PaymentMethodName%TYPE,
1525: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
1526: req_type_in IN iby_trxn_summaries_all.reqtype%type)
1527: IS
1528: num_trxns NUMBER := 0;
1521: error_location_in IN OUT NOCOPY iby_trxn_summaries_all.ErrorLocation%TYPE,
1522: split_id_in_out IN OUT NOCOPY iby_trxn_extended.SplitID%TYPE,
1523: transaction_id_in IN iby_trxn_summaries_all.TransactionID%TYPE,
1524: payment_method_in IN iby_trxn_summaries_all.PaymentMethodName%TYPE,
1525: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
1526: req_type_in IN iby_trxn_summaries_all.reqtype%type)
1527: IS
1528: num_trxns NUMBER := 0;
1529: mid iby_trxn_extended.SplitID%TYPE;
1522: split_id_in_out IN OUT NOCOPY iby_trxn_extended.SplitID%TYPE,
1523: transaction_id_in IN iby_trxn_summaries_all.TransactionID%TYPE,
1524: payment_method_in IN iby_trxn_summaries_all.PaymentMethodName%TYPE,
1525: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
1526: req_type_in IN iby_trxn_summaries_all.reqtype%type)
1527: IS
1528: num_trxns NUMBER := 0;
1529: mid iby_trxn_extended.SplitID%TYPE;
1530: err_msg VARCHAR2(100);
1556: -- Check if row is already in table using unique
1557: -- key of set_trxn_id and vendor_id
1558: SELECT COUNT(*)
1559: INTO num_trxns
1560: FROM iby_trxn_extended extended, iby_trxn_summaries_all summary
1561: WHERE extended.SETTrxnID = set_trxn_id_in
1562: AND summary.BEPID = vendor_id_in
1563: AND extended.TrxnMID = summary.TrxnMID;
1564: IF (num_trxns = 0)
1579: --transaction_id_in_out := transaction_id;
1580:
1581:
1582: iby_accppmtmthd_pkg.getMPayeeId(merchant_id_in, l_mpayeeid);
1583: INSERT INTO iby_trxn_summaries_all
1584: (TrxnMID, TransactionID, paymentMethodName,
1585: TangibleID,MPayeeID, PayeeID,BEPID,
1586: TrxntypeID, ECAPPID, org_id, ReqDate, ReqType,
1587: Amount,CurrencyNameCode, UpdateDate,Status,
1622: THEN
1623: -- Count number of successful transactions
1624: SELECT count(*)
1625: INTO num_trxns
1626: FROM iby_trxn_summaries_all summary, iby_trxn_extended extended
1627: WHERE extended.SETTrxnID = set_trxn_id_in
1628: AND summary.BEPID = vendor_id_in
1629: AND summary.Status = 0
1630: AND summary.TrxnMID = extended.TrxnMID;
1633: IF (num_trxns = 0)
1634: THEN
1635: SELECT summary.TrxnMID
1636: INTO trxn_mid
1637: FROM iby_trxn_summaries_all summary, iby_trxn_extended extended
1638: WHERE extended.SETTrxnID = set_trxn_id_in
1639: AND summary.BEPID = vendor_id_in
1640: AND summary.TrxnMID = extended.TrxnMID;
1641: UPDATE iby_trxn_summaries_all
1637: FROM iby_trxn_summaries_all summary, iby_trxn_extended extended
1638: WHERE extended.SETTrxnID = set_trxn_id_in
1639: AND summary.BEPID = vendor_id_in
1640: AND summary.TrxnMID = extended.TrxnMID;
1641: UPDATE iby_trxn_summaries_all
1642: SET Amount = price_in,
1643: CurrencyNameCode = currency_in,
1644: UpdateDate = time_in,
1645: Status = status_in,
1682:
1683: /* Internal procedure to get the split_id of the parent */
1684: /* transaction. */
1685: PROCEDURE find_parent_splitid
1686: (order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
1687: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
1688: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
1689: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
1690: prev_set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,
1683: /* Internal procedure to get the split_id of the parent */
1684: /* transaction. */
1685: PROCEDURE find_parent_splitid
1686: (order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
1687: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
1688: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
1689: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
1690: prev_set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,
1691: split_id_in_out IN OUT NOCOPY iby_trxn_extended.SplitID%TYPE)
1684: /* transaction. */
1685: PROCEDURE find_parent_splitid
1686: (order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
1687: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
1688: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
1689: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
1690: prev_set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,
1691: split_id_in_out IN OUT NOCOPY iby_trxn_extended.SplitID%TYPE)
1692: IS
1685: PROCEDURE find_parent_splitid
1686: (order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
1687: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
1688: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
1689: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
1690: prev_set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,
1691: split_id_in_out IN OUT NOCOPY iby_trxn_extended.SplitID%TYPE)
1692: IS
1693:
1699: split_id_in_out := null;
1700: -- Find number of parents
1701: SELECT count(distinct extended.SplitID)
1702: INTO num_trxns
1703: FROM iby_trxn_extended extended, iby_trxn_summaries_all summary
1704: WHERE extended.SETTrxnID = prev_set_trxn_id_in
1705: AND summary.BEPID = vendor_id_in
1706: AND extended.TrxnMID = summary.TrxnMID;
1707: IF (num_trxns = 0)
1713: -- Even tho value is probably 1 (default), we'll make
1714: -- sure by getting it anyways
1715: SELECT distinct extended.SplitID
1716: INTO mid
1717: FROM iby_trxn_extended extended, iby_trxn_summaries_all summary
1718: WHERE extended.SETTrxnID = prev_set_trxn_id_in
1719: AND summary.BEPID = vendor_id_in
1720: AND extended.TrxnMID = summary.TrxnMID;
1721: split_id_in_out := mid;