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.

APPS.IBY_TRANSACTIONSET_PKG dependencies on IBY_TRXN_EXTENDED

Line 106: INSERT INTO iby_trxn_extended

102: sysdate, fnd_global.user_id,
103: sysdate, fnd_global.user_id,
104: fnd_global.login_id, 1,'Y');
105:
106: INSERT INTO iby_trxn_extended
107: (TrxnMID, SplitID,
108: last_update_date, last_updated_by,
109: creation_date, created_by,
110: last_update_login, object_version_number)

Line 150: UPDATE iby_trxn_extended

146: last_update_login = fnd_global.login_id,
147: object_version_number = 1
148: WHERE TrxnMID = trxn_mid;
149:
150: UPDATE iby_trxn_extended
151: SET SplitID = '1',
152: last_update_date = sysdate,
153: last_updated_by = fnd_global.user_id,
154: last_update_login = fnd_global.login_id,

Line 184: split_id_in IN iby_trxn_extended.SplitID%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,
188: time_in IN iby_trxn_summaries_all.UpdateDate%TYPE,

Line 192: completion_code_in IN iby_trxn_extended.CompletionCode%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,
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,

Line 193: set_trxn_id_in IN iby_trxn_extended.SETTrxnID%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,
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,

Line 195: batch_seq_num_in IN iby_trxn_extended.BatchSeqNum%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,
199: terminal_id_in IN iby_trxn_extended.TerminalID%TYPE,

Line 198: card_BIN_in IN iby_trxn_extended.Cardbin%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,
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,

Line 199: terminal_id_in IN iby_trxn_extended.TerminalID%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,
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,

Line 200: request_type_in IN iby_trxn_extended.SETReqType%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,
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,

Line 201: subseq_auth_ind_in IN iby_trxn_extended.SubAuthInd%TYPE,

197: ret_ref_num_in IN iby_trxn_core.ReferenceCode%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,

Line 371: INSERT INTO iby_trxn_extended

367: sysdate, fnd_global.user_id,
368: sysdate, fnd_global.user_id,
369: fnd_global.login_id, 1);
370:
371: INSERT INTO iby_trxn_extended
372: (TrxnMID, SplitID, CompletionCode, SETTrxnID,
373: BatchSeqNum,
374: Cardbin, TerminalID, SETReqType, SubAuthInd,
375: last_update_date, last_updated_by,

Line 435: UPDATE iby_trxn_extended

431: last_update_login = fnd_global.login_id,
432: object_version_number = 1
433: WHERE TrxnMID = trxn_mid;
434:
435: UPDATE iby_trxn_extended
436: SET SplitID = '1',
437: CompletionCode = completion_code_in,
438: SETTrxnID = set_trxn_id_in,
439: BatchSeqNum = batch_seq_num_in,

Line 478: split_id_in IN iby_trxn_extended.SplitID%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,
482: time_in IN iby_trxn_summaries_all.UpdateDate%TYPE,

Line 486: completion_code_in IN iby_trxn_extended.CompletionCode%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,
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,

Line 487: set_trxn_id_in IN iby_trxn_extended.SETTrxnID%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,
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,

Line 489: batch_seq_num_in IN OUT NOCOPY iby_trxn_extended.BatchSeqNum%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,
493: terminal_id_in IN OUT NOCOPY iby_trxn_extended.TerminalID%TYPE,

Line 492: card_BIN_in IN OUT NOCOPY iby_trxn_extended.Cardbin%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,
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,

Line 493: terminal_id_in IN OUT NOCOPY iby_trxn_extended.TerminalID%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,
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,

Line 494: subseq_auth_ind_in IN iby_trxn_extended.SubAuthInd%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,
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,

Line 636: INSERT INTO iby_trxn_extended

632: sysdate, fnd_global.user_id,
633: sysdate, fnd_global.user_id,
634: fnd_global.login_id, 1);
635:
636: INSERT INTO iby_trxn_extended
637: (TrxnMID, SplitID, CompletionCode, SETTrxnID,
638: BatchSeqNum,
639: Cardbin, TerminalID, SubAuthInd,
640: last_update_date, last_updated_by,

Line 698: UPDATE iby_trxn_extended

694: last_update_login = fnd_global.login_id,
695: object_version_number = 1
696: WHERE TrxnMID = trxn_mid;
697:
698: UPDATE iby_trxn_extended
699: SET SplitID = split_id_in,
700: CompletionCode = completion_code_in,
701: SETTrxnID = set_trxn_id_in,
702: BatchSeqNum = batch_seq_num_in,

Line 739: split_id_in IN iby_trxn_extended.SplitID%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,
743: time_in IN iby_trxn_summaries_all.UpdateDate%TYPE,

Line 746: set_trxn_id_in IN iby_trxn_extended.SETTrxnID%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,
749: terminal_id_in IN OUT NOCOPY iby_trxn_extended.TerminalID%TYPE,
750: subseq_auth_ind_in IN iby_trxn_extended.SubAuthInd%TYPE,

Line 748: batch_seq_num_in IN OUT NOCOPY iby_trxn_extended.BatchSeqNum%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,
752: vendor_message_in IN OUT NOCOPY iby_trxn_summaries_all.BEPMessage%TYPE,

Line 749: terminal_id_in IN OUT NOCOPY iby_trxn_extended.TerminalID%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,
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,

Line 750: subseq_auth_ind_in IN iby_trxn_extended.SubAuthInd%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,
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,

Line 799: FROM iby_trxn_summaries_all summary, iby_trxn_extended extended

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)

Line 898: INSERT INTO iby_trxn_extended

894: sysdate, fnd_global.user_id,
895: fnd_global.login_id, 1);
896:
897:
898: INSERT INTO iby_trxn_extended
899: (TrxnMID, SplitID, SETTrxnID,
900: BatchSeqNum,
901: TerminalID, SubAuthInd,
902: last_update_date, last_updated_by,

Line 919: FROM iby_trxn_summaries_all summary, iby_trxn_extended extended

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)

Line 962: UPDATE iby_trxn_extended

958: last_update_login = fnd_global.login_id,
959: object_version_number = 1
960: WHERE TrxnMID = trxn_mid;
961:
962: UPDATE iby_trxn_extended
963: SET SplitID = split_id_in,
964: SETTrxnID = set_trxn_id_in,
965: BatchSeqNum = batch_seq_num_in,
966: TerminalID = terminal_id_in,

Line 998: split_id_in IN iby_trxn_extended.SplitID%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,
1002: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,

Line 1083: INSERT INTO iby_trxn_extended

1079: sysdate, fnd_global.user_id,
1080: sysdate, fnd_global.user_id,
1081: fnd_global.login_id, 1,'Y');
1082:
1083: INSERT INTO iby_trxn_extended
1084: (TrxnMID, SplitID,
1085: last_update_date, last_updated_by,
1086: creation_date, created_by,
1087: last_update_login, object_version_number)

Line 1137: UPDATE iby_trxn_extended

1133: last_update_login = fnd_global.login_id,
1134: object_version_number = 1
1135: WHERE TrxnMID = trxn_mid;
1136:
1137: UPDATE iby_trxn_extended
1138: SET SplitID = '1',
1139: last_update_date = sysdate,
1140: last_updated_by = fnd_global.user_id,
1141: last_update_login = fnd_global.login_id,

Line 1272: split_id_in IN iby_trxn_extended.SplitID%TYPE,

1268: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
1269: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
1270: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
1271: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
1272: split_id_in IN iby_trxn_extended.SplitID%TYPE,
1273: payment_name_in IN iby_trxn_core.InstrName%TYPE,
1274: price_in IN iby_trxn_summaries_all.Amount%TYPE,
1275: currency_in IN iby_trxn_summaries_all.CurrencyNameCode%TYPE,
1276: time_in IN iby_trxn_summaries_all.UpdateDate%TYPE,

Line 1278: set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,

1274: price_in IN iby_trxn_summaries_all.Amount%TYPE,
1275: currency_in IN iby_trxn_summaries_all.CurrencyNameCode%TYPE,
1276: time_in IN iby_trxn_summaries_all.UpdateDate%TYPE,
1277: status_in IN iby_trxn_summaries_all.Status%TYPE,
1278: set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,
1279: prev_set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,
1280: batch_id_in IN iby_trxn_summaries_all.batchID%TYPE,
1281: batch_seq_num_in IN iby_trxn_extended.BatchSeqNum%TYPE,
1282: batch_trxn_status_in IN iby_trxn_extended.BatchTrxnStatus%TYPE,

Line 1279: prev_set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,

1275: currency_in IN iby_trxn_summaries_all.CurrencyNameCode%TYPE,
1276: time_in IN iby_trxn_summaries_all.UpdateDate%TYPE,
1277: status_in IN iby_trxn_summaries_all.Status%TYPE,
1278: set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,
1279: prev_set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,
1280: batch_id_in IN iby_trxn_summaries_all.batchID%TYPE,
1281: batch_seq_num_in IN iby_trxn_extended.BatchSeqNum%TYPE,
1282: batch_trxn_status_in IN iby_trxn_extended.BatchTrxnStatus%TYPE,
1283: card_BIN_in IN iby_trxn_extended.Cardbin%TYPE,

Line 1281: batch_seq_num_in IN iby_trxn_extended.BatchSeqNum%TYPE,

1277: status_in IN iby_trxn_summaries_all.Status%TYPE,
1278: set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,
1279: prev_set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,
1280: batch_id_in IN iby_trxn_summaries_all.batchID%TYPE,
1281: batch_seq_num_in IN iby_trxn_extended.BatchSeqNum%TYPE,
1282: batch_trxn_status_in IN iby_trxn_extended.BatchTrxnStatus%TYPE,
1283: card_BIN_in IN iby_trxn_extended.Cardbin%TYPE,
1284: terminal_id_in IN iby_trxn_extended.TerminalID%TYPE,
1285: vendor_code_in IN iby_trxn_summaries_all.BEPCode%TYPE,

Line 1282: batch_trxn_status_in IN iby_trxn_extended.BatchTrxnStatus%TYPE,

1278: set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,
1279: prev_set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,
1280: batch_id_in IN iby_trxn_summaries_all.batchID%TYPE,
1281: batch_seq_num_in IN iby_trxn_extended.BatchSeqNum%TYPE,
1282: batch_trxn_status_in IN iby_trxn_extended.BatchTrxnStatus%TYPE,
1283: card_BIN_in IN iby_trxn_extended.Cardbin%TYPE,
1284: terminal_id_in IN iby_trxn_extended.TerminalID%TYPE,
1285: vendor_code_in IN iby_trxn_summaries_all.BEPCode%TYPE,
1286: vendor_message_in IN iby_trxn_summaries_all.BEPMessage%TYPE,

Line 1283: card_BIN_in IN iby_trxn_extended.Cardbin%TYPE,

1279: prev_set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,
1280: batch_id_in IN iby_trxn_summaries_all.batchID%TYPE,
1281: batch_seq_num_in IN iby_trxn_extended.BatchSeqNum%TYPE,
1282: batch_trxn_status_in IN iby_trxn_extended.BatchTrxnStatus%TYPE,
1283: card_BIN_in IN iby_trxn_extended.Cardbin%TYPE,
1284: terminal_id_in IN iby_trxn_extended.TerminalID%TYPE,
1285: vendor_code_in IN iby_trxn_summaries_all.BEPCode%TYPE,
1286: vendor_message_in IN iby_trxn_summaries_all.BEPMessage%TYPE,
1287: error_location_in IN iby_trxn_summaries_all.ErrorLocation%TYPE,

Line 1284: terminal_id_in IN iby_trxn_extended.TerminalID%TYPE,

1280: batch_id_in IN iby_trxn_summaries_all.batchID%TYPE,
1281: batch_seq_num_in IN iby_trxn_extended.BatchSeqNum%TYPE,
1282: batch_trxn_status_in IN iby_trxn_extended.BatchTrxnStatus%TYPE,
1283: card_BIN_in IN iby_trxn_extended.Cardbin%TYPE,
1284: terminal_id_in IN iby_trxn_extended.TerminalID%TYPE,
1285: vendor_code_in IN iby_trxn_summaries_all.BEPCode%TYPE,
1286: vendor_message_in IN iby_trxn_summaries_all.BEPMessage%TYPE,
1287: error_location_in IN iby_trxn_summaries_all.ErrorLocation%TYPE,
1288: split_id_in_out IN OUT NOCOPY iby_trxn_extended.SplitID%TYPE,

Line 1288: split_id_in_out IN OUT NOCOPY iby_trxn_extended.SplitID%TYPE,

1284: terminal_id_in IN iby_trxn_extended.TerminalID%TYPE,
1285: vendor_code_in IN iby_trxn_summaries_all.BEPCode%TYPE,
1286: vendor_message_in IN iby_trxn_summaries_all.BEPMessage%TYPE,
1287: error_location_in IN iby_trxn_summaries_all.ErrorLocation%TYPE,
1288: split_id_in_out IN OUT NOCOPY iby_trxn_extended.SplitID%TYPE,
1289: org_id_in IN iby_trxn_summaries_all.org_id%TYPE)
1290:
1291: IS
1292: num_trxns NUMBER := 0;

Line 1303: FROM iby_trxn_extended extended, iby_trxn_summaries_all summary

1299: -- Check for idempotency: see if transaction already
1300: -- exists
1301: SELECT count(*)
1302: INTO num_trxns
1303: FROM iby_trxn_extended extended, iby_trxn_summaries_all summary
1304: WHERE extended.SETTrxnID = set_trxn_id_in
1305: AND summary.BEPID = vendor_id_in
1306: AND extended.TrxnMID = summary.TrxnMID;
1307: IF (num_trxns = 0)

Line 1352: INSERT INTO iby_trxn_extended

1348: sysdate, fnd_global.user_id,
1349: sysdate, fnd_global.user_id,
1350: fnd_global.login_id, 1,'Y');
1351:
1352: INSERT INTO iby_trxn_extended
1353: (TrxnMID, SplitID, SETTrxnID,
1354: BatchSeqNum, BatchTrxnStatus,
1355: Cardbin, TerminalID,
1356: last_update_date, last_updated_by, creation_date,

Line 1370: FROM iby_trxn_extended extended, iby_trxn_summaries_all summary

1366: THEN
1367: -- Update current row
1368: SELECT summary.TrxnMID
1369: INTO trxn_mid
1370: FROM iby_trxn_extended extended, iby_trxn_summaries_all summary
1371: WHERE extended.SETTrxnID = set_trxn_id_in
1372: AND summary.BEPID = vendor_id_in
1373: AND extended.TrxnMID = summary.TrxnMID;
1374:

Line 1375: UPDATE iby_trxn_extended

1371: WHERE extended.SETTrxnID = set_trxn_id_in
1372: AND summary.BEPID = vendor_id_in
1373: AND extended.TrxnMID = summary.TrxnMID;
1374:
1375: UPDATE iby_trxn_extended
1376: SET BatchSeqNum = batch_seq_num_in,
1377: BatchTrxnStatus = batch_trxn_status_in,
1378: last_update_date = sysdate,
1379: last_updated_by = fnd_global.user_id,

Line 1387: FROM iby_trxn_extended extended, iby_trxn_summaries_all summary

1383:
1384: -- Get split_id for output
1385: SELECT extended.SplitID
1386: INTO split_id_in_out
1387: FROM iby_trxn_extended extended, iby_trxn_summaries_all summary
1388: WHERE extended.SETTrxnID = set_trxn_id_in
1389: AND summary.BEPID = vendor_id_in
1390: AND extended.TrxnMID = summary.TrxnMID;
1391: -- Update card BIN only if it's not null

Line 1397: FROM iby_trxn_extended extended, iby_trxn_summaries_all summary

1393: (card_BIN_in IS NOT NULL))
1394: THEN
1395: SELECT summary.TrxnMID
1396: INTO trxn_mid
1397: FROM iby_trxn_extended extended, iby_trxn_summaries_all summary
1398: WHERE extended.SETTrxnID = set_trxn_id_in
1399: AND summary.BEPID = vendor_id_in
1400: AND extended.TrxnMID = summary.TrxnMID;
1401:

Line 1402: UPDATE iby_trxn_extended

1398: WHERE extended.SETTrxnID = set_trxn_id_in
1399: AND summary.BEPID = vendor_id_in
1400: AND extended.TrxnMID = summary.TrxnMID;
1401:
1402: UPDATE iby_trxn_extended
1403: SET Cardbin = card_BIN_in,
1404: last_update_date = sysdate,
1405: last_updated_by = fnd_global.user_id,
1406: last_update_login = fnd_global.login_id,

Line 1416: FROM iby_trxn_extended extended, iby_trxn_summaries_all summary

1412: (terminal_id_in IS NOT NULL))
1413: THEN
1414: SELECT summary.TrxnMID
1415: INTO trxn_mid
1416: FROM iby_trxn_extended extended, iby_trxn_summaries_all summary
1417: WHERE extended.SETTrxnID = set_trxn_id_in
1418: AND summary.BEPID = vendor_id_in
1419: AND extended.TrxnMID = summary.TrxnMID;
1420: UPDATE iby_trxn_extended

Line 1420: UPDATE iby_trxn_extended

1416: FROM iby_trxn_extended extended, iby_trxn_summaries_all summary
1417: WHERE extended.SETTrxnID = set_trxn_id_in
1418: AND summary.BEPID = vendor_id_in
1419: AND extended.TrxnMID = summary.TrxnMID;
1420: UPDATE iby_trxn_extended
1421: SET TerminalID = terminal_id_in,
1422: last_update_date = sysdate,
1423: last_updated_by = fnd_global.user_id,
1424: last_update_login = fnd_global.login_id,

Line 1434: FROM iby_trxn_extended extended, iby_trxn_summaries_all summary

1430: (error_location_in IS NOT NULL))
1431: THEN
1432: SELECT summary.TrxnMID
1433: INTO trxn_mid
1434: FROM iby_trxn_extended extended, iby_trxn_summaries_all summary
1435: WHERE extended.SETTrxnID = set_trxn_id_in
1436: AND summary.BEPID = vendor_id_in
1437: AND extended.TrxnMID = summary.TrxnMID;
1438: UPDATE iby_trxn_summaries_all

Line 1453: FROM iby_trxn_extended extended, iby_trxn_summaries_all summary

1449: (vendor_code_in IS NOT NULL))
1450: THEN
1451: SELECT summary.TrxnMID
1452: INTO trxn_mid
1453: FROM iby_trxn_extended extended, iby_trxn_summaries_all summary
1454: WHERE extended.SETTrxnID = set_trxn_id_in
1455: AND summary.BEPID = vendor_id_in
1456: AND extended.TrxnMID = summary.TrxnMID;
1457: UPDATE iby_trxn_summaries_all

Line 1472: FROM iby_trxn_extended extended, iby_trxn_summaries_all summary

1468: (vendor_message_in IS NOT NULL))
1469: THEN
1470: SELECT summary.TrxnMID
1471: INTO trxn_mid
1472: FROM iby_trxn_extended extended, iby_trxn_summaries_all summary
1473: WHERE extended.SETTrxnID = set_trxn_id_in
1474: AND summary.BEPID = vendor_id_in
1475: AND extended.TrxnMID = summary.TrxnMID;
1476: UPDATE iby_trxn_summaries_all

Line 1513: set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,

1509: price_in IN iby_trxn_summaries_all.Amount%TYPE,
1510: currency_in IN iby_trxn_summaries_all.CurrencyNameCode%TYPE,
1511: time_in IN iby_trxn_summaries_all.UpdateDate%TYPE,
1512: status_in IN iby_trxn_summaries_all.Status%TYPE,
1513: set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,
1514: prev_set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,
1515: ret_ref_num_in IN iby_trxn_core.ReferenceCode%TYPE,
1516: card_BIN_in IN OUT NOCOPY iby_trxn_extended.Cardbin%TYPE,
1517: terminal_id_in IN OUT NOCOPY iby_trxn_extended.TerminalID%TYPE,

Line 1514: prev_set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,

1510: currency_in IN iby_trxn_summaries_all.CurrencyNameCode%TYPE,
1511: time_in IN iby_trxn_summaries_all.UpdateDate%TYPE,
1512: status_in IN iby_trxn_summaries_all.Status%TYPE,
1513: set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,
1514: prev_set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,
1515: ret_ref_num_in IN iby_trxn_core.ReferenceCode%TYPE,
1516: card_BIN_in IN OUT NOCOPY iby_trxn_extended.Cardbin%TYPE,
1517: terminal_id_in IN OUT NOCOPY iby_trxn_extended.TerminalID%TYPE,
1518: vendor_code_in IN OUT NOCOPY iby_trxn_summaries_all.BEPCode%TYPE,

Line 1516: card_BIN_in IN OUT NOCOPY iby_trxn_extended.Cardbin%TYPE,

1512: status_in IN iby_trxn_summaries_all.Status%TYPE,
1513: set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,
1514: prev_set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,
1515: ret_ref_num_in IN iby_trxn_core.ReferenceCode%TYPE,
1516: card_BIN_in IN OUT NOCOPY iby_trxn_extended.Cardbin%TYPE,
1517: terminal_id_in IN OUT NOCOPY iby_trxn_extended.TerminalID%TYPE,
1518: vendor_code_in IN OUT NOCOPY iby_trxn_summaries_all.BEPCode%TYPE,
1519: vendor_message_in IN OUT NOCOPY iby_trxn_summaries_all.BEPMessage%TYPE,
1520: error_location_in IN OUT NOCOPY iby_trxn_summaries_all.ErrorLocation%TYPE,

Line 1517: terminal_id_in IN OUT NOCOPY iby_trxn_extended.TerminalID%TYPE,

1513: set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,
1514: prev_set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,
1515: ret_ref_num_in IN iby_trxn_core.ReferenceCode%TYPE,
1516: card_BIN_in IN OUT NOCOPY iby_trxn_extended.Cardbin%TYPE,
1517: terminal_id_in IN OUT NOCOPY iby_trxn_extended.TerminalID%TYPE,
1518: vendor_code_in IN OUT NOCOPY iby_trxn_summaries_all.BEPCode%TYPE,
1519: vendor_message_in IN OUT NOCOPY iby_trxn_summaries_all.BEPMessage%TYPE,
1520: error_location_in IN OUT NOCOPY iby_trxn_summaries_all.ErrorLocation%TYPE,
1521: split_id_in_out IN OUT NOCOPY iby_trxn_extended.SplitID%TYPE,

Line 1521: split_id_in_out IN OUT NOCOPY iby_trxn_extended.SplitID%TYPE,

1517: terminal_id_in IN OUT NOCOPY iby_trxn_extended.TerminalID%TYPE,
1518: vendor_code_in IN OUT NOCOPY iby_trxn_summaries_all.BEPCode%TYPE,
1519: vendor_message_in IN OUT NOCOPY iby_trxn_summaries_all.BEPMessage%TYPE,
1520: error_location_in IN OUT NOCOPY iby_trxn_summaries_all.ErrorLocation%TYPE,
1521: split_id_in_out IN OUT NOCOPY iby_trxn_extended.SplitID%TYPE,
1522: transaction_id_in IN iby_trxn_summaries_all.TransactionID%TYPE,
1523: payment_method_in IN iby_trxn_summaries_all.PaymentMethodName%TYPE,
1524: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
1525: req_type_in IN iby_trxn_summaries_all.reqtype%type)

Line 1528: mid iby_trxn_extended.SplitID%TYPE;

1524: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
1525: req_type_in IN iby_trxn_summaries_all.reqtype%type)
1526: IS
1527: num_trxns NUMBER := 0;
1528: mid iby_trxn_extended.SplitID%TYPE;
1529: err_msg VARCHAR2(100);
1530: trxn_mid NUMBER;
1531:
1532: l_mpayeeid iby_payee.mpayeeid%type;

Line 1559: FROM iby_trxn_extended extended, iby_trxn_summaries_all summary

1555: -- Check if row is already in table using unique
1556: -- key of set_trxn_id and vendor_id
1557: SELECT COUNT(*)
1558: INTO num_trxns
1559: FROM iby_trxn_extended extended, iby_trxn_summaries_all summary
1560: WHERE extended.SETTrxnID = set_trxn_id_in
1561: AND summary.BEPID = vendor_id_in
1562: AND extended.TrxnMID = summary.TrxnMID;
1563: IF (num_trxns = 0)

Line 1608: INSERT INTO iby_trxn_extended

1604: VALUES (trxn_mid, ret_ref_num_in,
1605: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
1606: fnd_global.login_id, 1);
1607:
1608: INSERT INTO iby_trxn_extended
1609: (TrxnMID, SplitID, SETTrxnID,
1610: -- BatchSeqNum,
1611: Cardbin, TerminalID,
1612: last_update_date, last_updated_by, creation_date, created_by,

Line 1625: FROM iby_trxn_summaries_all summary, iby_trxn_extended extended

1621: THEN
1622: -- Count number of successful transactions
1623: SELECT count(*)
1624: INTO num_trxns
1625: FROM iby_trxn_summaries_all summary, iby_trxn_extended extended
1626: WHERE extended.SETTrxnID = set_trxn_id_in
1627: AND summary.BEPID = vendor_id_in
1628: AND summary.Status = 0
1629: AND summary.TrxnMID = extended.TrxnMID;

Line 1636: FROM iby_trxn_summaries_all summary, iby_trxn_extended extended

1632: IF (num_trxns = 0)
1633: THEN
1634: SELECT summary.TrxnMID
1635: INTO trxn_mid
1636: FROM iby_trxn_summaries_all summary, iby_trxn_extended extended
1637: WHERE extended.SETTrxnID = set_trxn_id_in
1638: AND summary.BEPID = vendor_id_in
1639: AND summary.TrxnMID = extended.TrxnMID;
1640: UPDATE iby_trxn_summaries_all

Line 1662: UPDATE iby_trxn_extended

1658: last_update_login = fnd_global.login_id,
1659: object_version_number = 1
1660: WHERE TrxnMID = trxn_mid;
1661:
1662: UPDATE iby_trxn_extended
1663: SET Cardbin = card_bin_in,
1664: TerminalID = terminal_id_in,
1665: last_update_date = sysdate,
1666: last_updated_by = fnd_global.user_id,

Line 1689: prev_set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,

1685: (order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
1686: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
1687: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
1688: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
1689: prev_set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,
1690: split_id_in_out IN OUT NOCOPY iby_trxn_extended.SplitID%TYPE)
1691: IS
1692:
1693: num_trxns NUMBER := 0;

Line 1690: split_id_in_out IN OUT NOCOPY iby_trxn_extended.SplitID%TYPE)

1686: merchant_id_in IN iby_trxn_summaries_all.PayeeID%TYPE,
1687: vendor_id_in IN iby_trxn_summaries_all.BEPID%TYPE,
1688: trxn_type_in IN iby_trxn_summaries_all.TrxntypeID%TYPE,
1689: prev_set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,
1690: split_id_in_out IN OUT NOCOPY iby_trxn_extended.SplitID%TYPE)
1691: IS
1692:
1693: num_trxns NUMBER := 0;
1694: mid iby_trxn_extended.SplitID%TYPE;

Line 1694: mid iby_trxn_extended.SplitID%TYPE;

1690: split_id_in_out IN OUT NOCOPY iby_trxn_extended.SplitID%TYPE)
1691: IS
1692:
1693: num_trxns NUMBER := 0;
1694: mid iby_trxn_extended.SplitID%TYPE;
1695: err_msg VARCHAR2(100);
1696:
1697: BEGIN
1698: split_id_in_out := null;

Line 1702: FROM iby_trxn_extended extended, iby_trxn_summaries_all summary

1698: split_id_in_out := null;
1699: -- Find number of parents
1700: SELECT count(distinct extended.SplitID)
1701: INTO num_trxns
1702: FROM iby_trxn_extended extended, iby_trxn_summaries_all summary
1703: WHERE extended.SETTrxnID = prev_set_trxn_id_in
1704: AND summary.BEPID = vendor_id_in
1705: AND extended.TrxnMID = summary.TrxnMID;
1706: IF (num_trxns = 0)

Line 1716: FROM iby_trxn_extended extended, iby_trxn_summaries_all summary

1712: -- Even tho value is probably 1 (default), we'll make
1713: -- sure by getting it anyways
1714: SELECT distinct extended.SplitID
1715: INTO mid
1716: FROM iby_trxn_extended extended, iby_trxn_summaries_all summary
1717: WHERE extended.SETTrxnID = prev_set_trxn_id_in
1718: AND summary.BEPID = vendor_id_in
1719: AND extended.TrxnMID = summary.TrxnMID;
1720: split_id_in_out := mid;