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

Line 1279: set_trxn_id_in IN iby_trxn_extended.SETTrxnID%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,
1283: batch_trxn_status_in IN iby_trxn_extended.BatchTrxnStatus%TYPE,

Line 1280: prev_set_trxn_id_in IN iby_trxn_extended.SETTrxnID%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,
1283: batch_trxn_status_in IN iby_trxn_extended.BatchTrxnStatus%TYPE,
1284: card_BIN_in IN iby_trxn_extended.Cardbin%TYPE,

Line 1282: batch_seq_num_in IN iby_trxn_extended.BatchSeqNum%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,
1286: vendor_code_in IN iby_trxn_summaries_all.BEPCode%TYPE,

Line 1283: batch_trxn_status_in IN iby_trxn_extended.BatchTrxnStatus%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,
1286: vendor_code_in IN iby_trxn_summaries_all.BEPCode%TYPE,
1287: vendor_message_in IN iby_trxn_summaries_all.BEPMessage%TYPE,

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

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

Line 1289: split_id_in_out IN OUT NOCOPY iby_trxn_extended.SplitID%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
1293: num_trxns NUMBER := 0;

Line 1304: FROM iby_trxn_extended extended, iby_trxn_summaries_all summary

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)

Line 1353: INSERT INTO iby_trxn_extended

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

Line 1371: FROM iby_trxn_extended extended, iby_trxn_summaries_all summary

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:

Line 1376: UPDATE iby_trxn_extended

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

Line 1388: FROM iby_trxn_extended extended, iby_trxn_summaries_all summary

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

Line 1398: FROM iby_trxn_extended extended, iby_trxn_summaries_all summary

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:

Line 1403: UPDATE iby_trxn_extended

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

Line 1417: FROM iby_trxn_extended extended, iby_trxn_summaries_all summary

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

Line 1421: UPDATE iby_trxn_extended

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
1422: SET TerminalID = terminal_id_in,
1423: last_update_date = sysdate,
1424: last_updated_by = fnd_global.user_id,
1425: last_update_login = fnd_global.login_id,

Line 1435: FROM iby_trxn_extended extended, iby_trxn_summaries_all summary

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

Line 1454: FROM iby_trxn_extended extended, iby_trxn_summaries_all summary

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

Line 1473: FROM iby_trxn_extended extended, iby_trxn_summaries_all summary

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

Line 1514: set_trxn_id_in IN iby_trxn_extended.SETTrxnID%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,
1518: terminal_id_in IN OUT NOCOPY iby_trxn_extended.TerminalID%TYPE,

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

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

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

Line 1522: split_id_in_out IN OUT NOCOPY iby_trxn_extended.SplitID%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,
1526: req_type_in IN iby_trxn_summaries_all.reqtype%type)

Line 1529: mid iby_trxn_extended.SplitID%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);
1531: trxn_mid NUMBER;
1532:
1533: l_mpayeeid iby_payee.mpayeeid%type;

Line 1560: FROM iby_trxn_extended extended, iby_trxn_summaries_all summary

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)

Line 1609: INSERT INTO iby_trxn_extended

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

Line 1626: FROM iby_trxn_summaries_all summary, iby_trxn_extended extended

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;

Line 1637: FROM iby_trxn_summaries_all summary, iby_trxn_extended extended

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

Line 1663: UPDATE iby_trxn_extended

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

Line 1690: prev_set_trxn_id_in IN iby_trxn_extended.SETTrxnID%TYPE,

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:
1694: num_trxns NUMBER := 0;

Line 1691: split_id_in_out IN OUT NOCOPY iby_trxn_extended.SplitID%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:
1694: num_trxns NUMBER := 0;
1695: mid iby_trxn_extended.SplitID%TYPE;

Line 1695: mid iby_trxn_extended.SplitID%TYPE;

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

Line 1703: FROM iby_trxn_extended extended, iby_trxn_summaries_all summary

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)

Line 1717: FROM iby_trxn_extended extended, iby_trxn_summaries_all summary

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;