98: price_in, currency_in, time_in, status_in,
99: order_id_in, l_mpayeeid, merchant_id_in, vendor_id_in,l_tmid,
100: vendor_code_in, vendor_message_in, error_location_in,
101: payerinstrid_in, instrnum_in,
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
99: order_id_in, l_mpayeeid, merchant_id_in, vendor_id_in,l_tmid,
100: vendor_code_in, vendor_message_in, error_location_in,
101: payerinstrid_in, instrnum_in,
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,
100: vendor_code_in, vendor_message_in, error_location_in,
101: payerinstrid_in, instrnum_in,
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,
108: last_update_date, last_updated_by,
109: creation_date, created_by,
110: last_update_login, object_version_number)
111: VALUES (trxn_mid, '1',
112: sysdate, fnd_global.user_id,
113: sysdate, fnd_global.user_id,
114: fnd_global.login_id, 1);
115:
116: ELSIF (num_trxns = 1)
109: creation_date, created_by,
110: last_update_login, object_version_number)
111: VALUES (trxn_mid, '1',
112: sysdate, fnd_global.user_id,
113: sysdate, fnd_global.user_id,
114: fnd_global.login_id, 1);
115:
116: ELSIF (num_trxns = 1)
117: THEN
110: last_update_login, object_version_number)
111: VALUES (trxn_mid, '1',
112: sysdate, fnd_global.user_id,
113: sysdate, fnd_global.user_id,
114: fnd_global.login_id, 1);
115:
116: ELSIF (num_trxns = 1)
117: THEN
118: -- One previous transaction, so update previous row
141: payerinstrid = payerinstrid_in,
142: instrnumber = instrnum_in,
143:
144: last_update_date = sysdate,
145: last_updated_by = fnd_global.user_id,
146: last_update_login = fnd_global.login_id,
147: object_version_number = 1
148: WHERE TrxnMID = trxn_mid;
149:
142: instrnumber = instrnum_in,
143:
144: last_update_date = sysdate,
145: last_updated_by = fnd_global.user_id,
146: last_update_login = fnd_global.login_id,
147: object_version_number = 1
148: WHERE TrxnMID = trxn_mid;
149:
150: UPDATE iby_trxn_extended
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,
155: object_version_number = 1
156: WHERE TrxnMID = trxn_mid;
157:
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,
155: object_version_number = 1
156: WHERE TrxnMID = trxn_mid;
157:
158: ELSE
353: merchant_id_in, vendor_id_in,
354: vendor_code_in, vendor_message_in, error_location_in,
355: payment_method_in,status_in,
356: payerinstrid_in, instrnum_in,
357: sysdate, sysdate, fnd_global.user_id,
358: sysdate, fnd_global.user_id,
359: fnd_global.login_id, 1,'Y');
360:
361: INSERT INTO iby_trxn_core
354: vendor_code_in, vendor_message_in, error_location_in,
355: payment_method_in,status_in,
356: payerinstrid_in, instrnum_in,
357: sysdate, sysdate, fnd_global.user_id,
358: sysdate, fnd_global.user_id,
359: fnd_global.login_id, 1,'Y');
360:
361: INSERT INTO iby_trxn_core
362: (TrxnMID, OperationCode, AVSCode, ReferenceCode,
355: payment_method_in,status_in,
356: payerinstrid_in, instrnum_in,
357: sysdate, sysdate, fnd_global.user_id,
358: sysdate, fnd_global.user_id,
359: fnd_global.login_id, 1,'Y');
360:
361: INSERT INTO iby_trxn_core
362: (TrxnMID, OperationCode, AVSCode, ReferenceCode,
363: last_update_date, last_updated_by,
363: last_update_date, last_updated_by,
364: creation_date, created_by,
365: last_update_login, object_version_number)
366: VALUES (trxn_mid, oper_code, avs_result_in, ret_ref_num_in,
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
364: creation_date, created_by,
365: last_update_login, object_version_number)
366: VALUES (trxn_mid, oper_code, avs_result_in, ret_ref_num_in,
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,
365: last_update_login, object_version_number)
366: VALUES (trxn_mid, oper_code, avs_result_in, ret_ref_num_in,
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,
378: VALUES
379: (trxn_mid, '1', completion_code_in, set_trxn_id_in,
380: batch_seq_num_in,
381: card_bin_in, terminal_id_in, request_type_in, subseq_auth_ind_in,
382: sysdate, fnd_global.user_id,
383: sysdate, fnd_global.user_id,
384: fnd_global.login_id, 1);
385:
386: ELSIF (num_trxns = 1)
379: (trxn_mid, '1', completion_code_in, set_trxn_id_in,
380: batch_seq_num_in,
381: card_bin_in, terminal_id_in, request_type_in, subseq_auth_ind_in,
382: sysdate, fnd_global.user_id,
383: sysdate, fnd_global.user_id,
384: fnd_global.login_id, 1);
385:
386: ELSIF (num_trxns = 1)
387: THEN
380: batch_seq_num_in,
381: card_bin_in, terminal_id_in, request_type_in, subseq_auth_ind_in,
382: sysdate, fnd_global.user_id,
383: sysdate, fnd_global.user_id,
384: fnd_global.login_id, 1);
385:
386: ELSIF (num_trxns = 1)
387: THEN
388: -- One previous transaction, so update previous row
416: MBatchID = l_mbatchid,
417: payerinstrid = payerinstrid_in,
418: instrnumber = instrnum_in,
419: last_update_date = sysdate,
420: last_updated_by = fnd_global.user_id,
421: last_update_login = fnd_global.login_id,
422: object_version_number = 1
423: WHERE TrxnMID = trxn_mid;
424:
417: payerinstrid = payerinstrid_in,
418: instrnumber = instrnum_in,
419: last_update_date = sysdate,
420: last_updated_by = fnd_global.user_id,
421: last_update_login = fnd_global.login_id,
422: object_version_number = 1
423: WHERE TrxnMID = trxn_mid;
424:
425: UPDATE iby_trxn_core
426: SET OperationCode = oper_code,
427: AvsCode = avs_result_in,
428: ReferenceCode = ret_ref_num_in,
429: last_update_date = sysdate,
430: last_updated_by = fnd_global.user_id,
431: last_update_login = fnd_global.login_id,
432: object_version_number = 1
433: WHERE TrxnMID = trxn_mid;
434:
427: AvsCode = avs_result_in,
428: ReferenceCode = ret_ref_num_in,
429: last_update_date = sysdate,
430: last_updated_by = fnd_global.user_id,
431: last_update_login = fnd_global.login_id,
432: object_version_number = 1
433: WHERE TrxnMID = trxn_mid;
434:
435: UPDATE iby_trxn_extended
441: TerminalID = terminal_id_in,
442: SETReqType = request_type_in,
443: SubAuthInd = subseq_auth_ind_in,
444: last_update_date = sysdate,
445: last_updated_by = fnd_global.user_id,
446: last_update_login = fnd_global.login_id,
447: object_version_number = 1
448: WHERE TrxnMID = trxn_mid;
449:
442: SETReqType = request_type_in,
443: SubAuthInd = subseq_auth_ind_in,
444: last_update_date = sysdate,
445: last_updated_by = fnd_global.user_id,
446: last_update_login = fnd_global.login_id,
447: object_version_number = 1
448: WHERE TrxnMID = trxn_mid;
449:
450: ELSE
618: price_in, currency_in, time_in, status_in, l_mbatchid,
619: batch_id_in,
620: vendor_code_in, vendor_message_in, error_location_in,
621: payerinstrid_in, instrnum_in,
622: sysdate, fnd_global.user_id,
623: sysdate, fnd_global.user_id,
624: fnd_global.login_id, 1,'Y');
625:
626: INSERT INTO iby_trxn_core
619: batch_id_in,
620: vendor_code_in, vendor_message_in, error_location_in,
621: payerinstrid_in, instrnum_in,
622: sysdate, fnd_global.user_id,
623: sysdate, fnd_global.user_id,
624: fnd_global.login_id, 1,'Y');
625:
626: INSERT INTO iby_trxn_core
627: (TrxnMID, OperationCode, AVSCode, ReferenceCode,
620: vendor_code_in, vendor_message_in, error_location_in,
621: payerinstrid_in, instrnum_in,
622: sysdate, fnd_global.user_id,
623: sysdate, fnd_global.user_id,
624: fnd_global.login_id, 1,'Y');
625:
626: INSERT INTO iby_trxn_core
627: (TrxnMID, OperationCode, AVSCode, ReferenceCode,
628: last_update_date, last_updated_by,
628: last_update_date, last_updated_by,
629: creation_date, created_by,
630: last_update_login, object_version_number)
631: VALUES (trxn_mid, oper_code, avs_result_in, ret_ref_num_in,
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
629: creation_date, created_by,
630: last_update_login, object_version_number)
631: VALUES (trxn_mid, oper_code, avs_result_in, ret_ref_num_in,
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,
630: last_update_login, object_version_number)
631: VALUES (trxn_mid, oper_code, avs_result_in, ret_ref_num_in,
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,
643: VALUES
644: (trxn_mid, split_id_in, completion_code_in, set_trxn_id_in,
645: batch_seq_num_in,
646: card_bin_in, terminal_id_in, subseq_auth_ind_in,
647: sysdate, fnd_global.user_id,
648: sysdate, fnd_global.user_id,
649: fnd_global.login_id, 1);
650:
651: ELSIF (num_trxns = 1)
644: (trxn_mid, split_id_in, completion_code_in, set_trxn_id_in,
645: batch_seq_num_in,
646: card_bin_in, terminal_id_in, subseq_auth_ind_in,
647: sysdate, fnd_global.user_id,
648: sysdate, fnd_global.user_id,
649: fnd_global.login_id, 1);
650:
651: ELSIF (num_trxns = 1)
652: THEN
645: batch_seq_num_in,
646: card_bin_in, terminal_id_in, subseq_auth_ind_in,
647: sysdate, fnd_global.user_id,
648: sysdate, fnd_global.user_id,
649: fnd_global.login_id, 1);
650:
651: ELSIF (num_trxns = 1)
652: THEN
653: -- One previous transaction, so update previous row
679: MBatchID = l_mbatchid,
680: payerinstrid = payerinstrid_in,
681: instrnumber = instrnum_in,
682: last_update_date = sysdate,
683: last_updated_by = fnd_global.user_id,
684: last_update_login = fnd_global.login_id,
685: object_version_number = 1
686: WHERE TrxnMID = trxn_mid;
687:
680: payerinstrid = payerinstrid_in,
681: instrnumber = instrnum_in,
682: last_update_date = sysdate,
683: last_updated_by = fnd_global.user_id,
684: last_update_login = fnd_global.login_id,
685: object_version_number = 1
686: WHERE TrxnMID = trxn_mid;
687:
688: UPDATE iby_trxn_core
689: SET OperationCode = oper_code,
690: AvsCode = avs_result_in,
691: ReferenceCode = ret_ref_num_in,
692: last_update_date = sysdate,
693: last_updated_by = fnd_global.user_id,
694: last_update_login = fnd_global.login_id,
695: object_version_number = 1
696: WHERE TrxnMID = trxn_mid;
697:
690: AvsCode = avs_result_in,
691: ReferenceCode = ret_ref_num_in,
692: last_update_date = sysdate,
693: last_updated_by = fnd_global.user_id,
694: last_update_login = fnd_global.login_id,
695: object_version_number = 1
696: WHERE TrxnMID = trxn_mid;
697:
698: UPDATE iby_trxn_extended
703: Cardbin = card_bin_in,
704: TerminalID = terminal_id_in,
705: SubAuthInd = subseq_auth_ind_in,
706: last_update_date = sysdate,
707: last_updated_by = fnd_global.user_id,
708: last_update_login = fnd_global.login_id,
709: object_version_number = 1
710: WHERE TrxnMID = trxn_mid;
711:
704: TerminalID = terminal_id_in,
705: SubAuthInd = subseq_auth_ind_in,
706: last_update_date = sysdate,
707: last_updated_by = fnd_global.user_id,
708: last_update_login = fnd_global.login_id,
709: object_version_number = 1
710: WHERE TrxnMID = trxn_mid;
711:
712: ELSE
878: l_mbatchid, batch_id_in,
879: vendor_code_in, vendor_message_in, error_location_in,
880: payment_name_in,
881: payerinstrid_in, instrnum_in,
882: sysdate, fnd_global.user_id,
883: sysdate, fnd_global.user_id,
884: fnd_global.login_id, 1,'Y');
885:
886: INSERT INTO iby_trxn_core
879: vendor_code_in, vendor_message_in, error_location_in,
880: payment_name_in,
881: payerinstrid_in, instrnum_in,
882: sysdate, fnd_global.user_id,
883: sysdate, fnd_global.user_id,
884: fnd_global.login_id, 1,'Y');
885:
886: INSERT INTO iby_trxn_core
887: (TrxnMID, OperationCode,
880: payment_name_in,
881: payerinstrid_in, instrnum_in,
882: sysdate, fnd_global.user_id,
883: sysdate, fnd_global.user_id,
884: fnd_global.login_id, 1,'Y');
885:
886: INSERT INTO iby_trxn_core
887: (TrxnMID, OperationCode,
888: last_update_date, last_updated_by,
889: creation_date, created_by,
890: last_update_login, object_version_number)
891:
892: VALUES (trxn_mid, operation_code_in,
893: sysdate, fnd_global.user_id,
894: sysdate, fnd_global.user_id,
895: fnd_global.login_id, 1);
896:
897:
890: last_update_login, object_version_number)
891:
892: VALUES (trxn_mid, operation_code_in,
893: sysdate, fnd_global.user_id,
894: sysdate, fnd_global.user_id,
895: fnd_global.login_id, 1);
896:
897:
898: INSERT INTO iby_trxn_extended
891:
892: VALUES (trxn_mid, operation_code_in,
893: sysdate, fnd_global.user_id,
894: sysdate, fnd_global.user_id,
895: fnd_global.login_id, 1);
896:
897:
898: INSERT INTO iby_trxn_extended
899: (TrxnMID, SplitID, SETTrxnID,
905: VALUES
906: (trxn_mid, split_id_in, set_trxn_id_in,
907: batch_seq_num_in,
908: terminal_id_in, subseq_auth_ind_in,
909: sysdate, fnd_global.user_id,
910: sysdate, fnd_global.user_id,
911: fnd_global.login_id, 1);
912:
913:
906: (trxn_mid, split_id_in, set_trxn_id_in,
907: batch_seq_num_in,
908: terminal_id_in, subseq_auth_ind_in,
909: sysdate, fnd_global.user_id,
910: sysdate, fnd_global.user_id,
911: fnd_global.login_id, 1);
912:
913:
914: ELSIF (num_trxns = 1)
907: batch_seq_num_in,
908: terminal_id_in, subseq_auth_ind_in,
909: sysdate, fnd_global.user_id,
910: sysdate, fnd_global.user_id,
911: fnd_global.login_id, 1);
912:
913:
914: ELSIF (num_trxns = 1)
915: THEN
945: MBatchID = l_mbatchid,
946: payerinstrid = payerinstrid_in,
947: instrnumber = instrnum_in,
948: last_update_date = sysdate,
949: last_updated_by = fnd_global.user_id,
950: last_update_login = fnd_global.login_id,
951: object_version_number = 1
952: WHERE TrxnMID = trxn_mid;
953:
946: payerinstrid = payerinstrid_in,
947: instrnumber = instrnum_in,
948: last_update_date = sysdate,
949: last_updated_by = fnd_global.user_id,
950: last_update_login = fnd_global.login_id,
951: object_version_number = 1
952: WHERE TrxnMID = trxn_mid;
953:
954: UPDATE iby_trxn_core
953:
954: UPDATE iby_trxn_core
955: SET OperationCode = operation_code_in,
956: last_update_date = sysdate,
957: last_updated_by = fnd_global.user_id,
958: last_update_login = fnd_global.login_id,
959: object_version_number = 1
960: WHERE TrxnMID = trxn_mid;
961:
954: UPDATE iby_trxn_core
955: SET OperationCode = operation_code_in,
956: last_update_date = sysdate,
957: last_updated_by = fnd_global.user_id,
958: last_update_login = fnd_global.login_id,
959: object_version_number = 1
960: WHERE TrxnMID = trxn_mid;
961:
962: UPDATE iby_trxn_extended
965: BatchSeqNum = batch_seq_num_in,
966: TerminalID = terminal_id_in,
967: SubAuthInd = subseq_auth_ind_in,
968: last_update_date = sysdate,
969: last_updated_by = fnd_global.user_id,
970: last_update_login = fnd_global.login_id,
971: object_version_number = 1
972: WHERE TrxnMID = trxn_mid;
973:
966: TerminalID = terminal_id_in,
967: SubAuthInd = subseq_auth_ind_in,
968: last_update_date = sysdate,
969: last_updated_by = fnd_global.user_id,
970: last_update_login = fnd_global.login_id,
971: object_version_number = 1
972: WHERE TrxnMID = trxn_mid;
973:
974: ELSE
1075: payment_name_in,
1076: trxn_type_in, req_type_in, time_in, l_tmid,
1077: time_in, status_in,
1078: payerinstrid_in, instrnum_in,
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
1076: trxn_type_in, req_type_in, time_in, l_tmid,
1077: time_in, status_in,
1078: payerinstrid_in, instrnum_in,
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,
1077: time_in, status_in,
1078: payerinstrid_in, instrnum_in,
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,
1085: last_update_date, last_updated_by,
1086: creation_date, created_by,
1087: last_update_login, object_version_number)
1088: VALUES (trxn_mid, '1',
1089: sysdate, fnd_global.user_id,
1090: sysdate, fnd_global.user_id,
1091: fnd_global.login_id, 1);
1092:
1093: INSERT INTO iby_trxn_core
1086: creation_date, created_by,
1087: last_update_login, object_version_number)
1088: VALUES (trxn_mid, '1',
1089: sysdate, fnd_global.user_id,
1090: sysdate, fnd_global.user_id,
1091: fnd_global.login_id, 1);
1092:
1093: INSERT INTO iby_trxn_core
1094: (TrxnMID, InstrName,
1087: last_update_login, object_version_number)
1088: VALUES (trxn_mid, '1',
1089: sysdate, fnd_global.user_id,
1090: sysdate, fnd_global.user_id,
1091: fnd_global.login_id, 1);
1092:
1093: INSERT INTO iby_trxn_core
1094: (TrxnMID, InstrName,
1095: last_update_date, last_updated_by,
1095: last_update_date, last_updated_by,
1096: creation_date, created_by,
1097: last_update_login, object_version_number)
1098: VALUES (trxn_mid, payment_name_in,
1099: sysdate, fnd_global.user_id,
1100: sysdate, fnd_global.user_id,
1101: fnd_global.login_id, 1);
1102:
1103: ELSIF (num_trxns = 1)
1096: creation_date, created_by,
1097: last_update_login, object_version_number)
1098: VALUES (trxn_mid, payment_name_in,
1099: sysdate, fnd_global.user_id,
1100: sysdate, fnd_global.user_id,
1101: fnd_global.login_id, 1);
1102:
1103: ELSIF (num_trxns = 1)
1104: THEN
1097: last_update_login, object_version_number)
1098: VALUES (trxn_mid, payment_name_in,
1099: sysdate, fnd_global.user_id,
1100: sysdate, fnd_global.user_id,
1101: fnd_global.login_id, 1);
1102:
1103: ELSIF (num_trxns = 1)
1104: THEN
1105: -- One previous transaction, so update previous row
1128: payerinstrid = payerinstrid_in,
1129: instrnumber = instrnum_in,
1130:
1131: last_update_date = sysdate,
1132: last_updated_by = fnd_global.user_id,
1133: last_update_login = fnd_global.login_id,
1134: object_version_number = 1
1135: WHERE TrxnMID = trxn_mid;
1136:
1129: instrnumber = instrnum_in,
1130:
1131: last_update_date = sysdate,
1132: last_updated_by = fnd_global.user_id,
1133: last_update_login = fnd_global.login_id,
1134: object_version_number = 1
1135: WHERE TrxnMID = trxn_mid;
1136:
1137: UPDATE iby_trxn_extended
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,
1142: object_version_number = 1
1143: WHERE TrxnMID = trxn_mid;
1144: ELSE
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,
1142: object_version_number = 1
1143: WHERE TrxnMID = trxn_mid;
1144: ELSE
1145: raise_application_error(-20000, 'IBY_20401#', FALSE);
1218: sale_trxn_count_in + credit_trxn_count_in,
1219: open_date_in, close_date_in, status_in,
1220: vendor_code_in, vendor_message_in, error_location_in,
1221: req_type_in, sysdate,
1222: sysdate, fnd_global.user_id,
1223: sysdate, fnd_global.user_id,
1224: fnd_global.login_id, 1,sysdate);
1225:
1226: ELSIF (num_trxns = 1)
1219: open_date_in, close_date_in, status_in,
1220: vendor_code_in, vendor_message_in, error_location_in,
1221: req_type_in, sysdate,
1222: sysdate, fnd_global.user_id,
1223: sysdate, fnd_global.user_id,
1224: fnd_global.login_id, 1,sysdate);
1225:
1226: ELSIF (num_trxns = 1)
1227: THEN
1220: vendor_code_in, vendor_message_in, error_location_in,
1221: req_type_in, sysdate,
1222: sysdate, fnd_global.user_id,
1223: sysdate, fnd_global.user_id,
1224: fnd_global.login_id, 1,sysdate);
1225:
1226: ELSIF (num_trxns = 1)
1227: THEN
1228: -- Update batch status row
1242: BEPCode = vendor_code_in,
1243: BEPMessage = vendor_message_in,
1244: ErrorLocation = error_location_in,
1245: last_update_date = sysdate,
1246: last_updated_by = fnd_global.user_id,
1247: last_update_login = fnd_global.login_id,
1248: object_version_number = 1
1249: WHERE BatchID = batch_id_in
1250: AND PayeeID = merchant_id_in;
1243: BEPMessage = vendor_message_in,
1244: ErrorLocation = error_location_in,
1245: last_update_date = sysdate,
1246: last_updated_by = fnd_global.user_id,
1247: last_update_login = fnd_global.login_id,
1248: object_version_number = 1
1249: WHERE BatchID = batch_id_in
1250: AND PayeeID = merchant_id_in;
1251:
1345: trxn_type_in, ecapp_id_in,org_id_in,
1346: price_in, currency_in, time_in, status_in,
1347: l_mbatchid, batch_id_in,
1348: vendor_code_in, vendor_message_in, error_location_in,
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
1346: price_in, currency_in, time_in, status_in,
1347: l_mbatchid, batch_id_in,
1348: vendor_code_in, vendor_message_in, error_location_in,
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,
1347: l_mbatchid, batch_id_in,
1348: vendor_code_in, vendor_message_in, error_location_in,
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,
1359: VALUES
1360: (trxn_mid, '1', set_trxn_id_in,
1361: batch_seq_num_in, batch_trxn_status_in,
1362: card_bin_in, terminal_id_in,
1363: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
1364: fnd_global.login_id, 1);
1365:
1366: ELSIF (num_trxns = 1)
1367: THEN
1360: (trxn_mid, '1', set_trxn_id_in,
1361: batch_seq_num_in, batch_trxn_status_in,
1362: card_bin_in, terminal_id_in,
1363: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
1364: fnd_global.login_id, 1);
1365:
1366: ELSIF (num_trxns = 1)
1367: THEN
1368: -- Update current row
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,
1381: last_update_login = fnd_global.login_id,
1382: object_version_number = 1
1383: WHERE TrxnMID = trxn_mid;
1384:
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,
1381: last_update_login = fnd_global.login_id,
1382: object_version_number = 1
1383: WHERE TrxnMID = trxn_mid;
1384:
1385: -- Get split_id for output
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,
1408: object_version_number = 1
1409: WHERE TrxnMID = trxn_mid;
1410: END IF;
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,
1408: object_version_number = 1
1409: WHERE TrxnMID = trxn_mid;
1410: END IF;
1411: -- Update terminal id only if it's not null
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,
1426: object_version_number = 1
1427: WHERE TrxnMID = trxn_mid;
1428: END IF;
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,
1426: object_version_number = 1
1427: WHERE TrxnMID = trxn_mid;
1428: END IF;
1429: -- Update error location only if it's not null
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,
1444: last_update_login = fnd_global.login_id,
1445: object_version_number = 1
1446: WHERE TrxnMID = trxn_mid;
1447: END IF;
1440: SET ErrorLocation = error_location_in,
1441: last_update_date = sysdate,
1442: updatedate = sysdate,
1443: last_updated_by = fnd_global.user_id,
1444: last_update_login = fnd_global.login_id,
1445: object_version_number = 1
1446: WHERE TrxnMID = trxn_mid;
1447: END IF;
1448: -- Update vendor code only if it's not null
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,
1463: last_update_login = fnd_global.login_id,
1464: object_version_number = 1
1465: WHERE TrxnMID = trxn_mid;
1466: END IF;
1459: SET BEPCode = vendor_code_in,
1460: last_update_date = sysdate,
1461: updatedate = sysdate,
1462: last_updated_by = fnd_global.user_id,
1463: last_update_login = fnd_global.login_id,
1464: object_version_number = 1
1465: WHERE TrxnMID = trxn_mid;
1466: END IF;
1467: -- Update vendor message only if it's not null
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,
1482: last_update_login = fnd_global.login_id,
1483: object_version_number = 1
1484: WHERE TrxnMID = trxn_mid;
1485: END IF;
1478: SET BEPMessage = vendor_message_in,
1479: last_update_date = sysdate,
1480: updatedate = sysdate,
1481: last_updated_by = fnd_global.user_id,
1482: last_update_login = fnd_global.login_id,
1483: object_version_number = 1
1484: WHERE TrxnMID = trxn_mid;
1485: END IF;
1486:
1593: order_id_in, l_mpayeeid, merchant_id_in, vendor_id_in,
1594: trxn_type_in, ecapp_id_in, org_id_in, time_in,req_type_in,
1595: price_in, currency_in, time_in, status_in,
1596: vendor_code_in, vendor_message_in, error_location_in,
1597: sysdate, fnd_global.user_id,
1598: sysdate, fnd_global.user_id,
1599: fnd_global.login_id, 1,'Y');
1600:
1601: INSERT INTO iby_trxn_core
1594: trxn_type_in, ecapp_id_in, org_id_in, time_in,req_type_in,
1595: price_in, currency_in, time_in, status_in,
1596: vendor_code_in, vendor_message_in, error_location_in,
1597: sysdate, fnd_global.user_id,
1598: sysdate, fnd_global.user_id,
1599: fnd_global.login_id, 1,'Y');
1600:
1601: INSERT INTO iby_trxn_core
1602: (TrxnMID, ReferenceCode,
1595: price_in, currency_in, time_in, status_in,
1596: vendor_code_in, vendor_message_in, error_location_in,
1597: sysdate, fnd_global.user_id,
1598: sysdate, fnd_global.user_id,
1599: fnd_global.login_id, 1,'Y');
1600:
1601: INSERT INTO iby_trxn_core
1602: (TrxnMID, ReferenceCode,
1603: last_update_date, last_updated_by, creation_date, created_by,
1602: (TrxnMID, ReferenceCode,
1603: last_update_date, last_updated_by, creation_date, created_by,
1604: last_update_login, object_version_number)
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,
1603: last_update_date, last_updated_by, creation_date, created_by,
1604: last_update_login, object_version_number)
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,
1615: VALUES
1616: (trxn_mid,split_id_in_out, set_trxn_id_in,
1617: -- batch_seq_num_in,
1618: card_bin_in, terminal_id_in,
1619: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
1620: fnd_global.login_id, 1);
1621: ELSIF (num_trxns = 1)
1622: THEN
1623: -- Count number of successful transactions
1616: (trxn_mid,split_id_in_out, set_trxn_id_in,
1617: -- batch_seq_num_in,
1618: card_bin_in, terminal_id_in,
1619: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
1620: fnd_global.login_id, 1);
1621: ELSIF (num_trxns = 1)
1622: THEN
1623: -- Count number of successful transactions
1624: SELECT count(*)
1646: ErrorLocation = error_location_in,
1647: BEPCode = vendor_code_in,
1648: BEPMessage = vendor_message_in,
1649: last_update_date = sysdate,
1650: last_updated_by = fnd_global.user_id,
1651: last_update_login = fnd_global.login_id,
1652: object_version_number = 1
1653: WHERE TrxnMID = trxn_mid;
1654:
1647: BEPCode = vendor_code_in,
1648: BEPMessage = vendor_message_in,
1649: last_update_date = sysdate,
1650: last_updated_by = fnd_global.user_id,
1651: last_update_login = fnd_global.login_id,
1652: object_version_number = 1
1653: WHERE TrxnMID = trxn_mid;
1654:
1655: UPDATE iby_trxn_core
1654:
1655: UPDATE iby_trxn_core
1656: SET ReferenceCode = ret_ref_num_in,
1657: last_update_date = sysdate,
1658: last_updated_by = fnd_global.user_id,
1659: last_update_login = fnd_global.login_id,
1660: object_version_number = 1
1661: WHERE TrxnMID = trxn_mid;
1662:
1655: UPDATE iby_trxn_core
1656: SET ReferenceCode = ret_ref_num_in,
1657: last_update_date = sysdate,
1658: last_updated_by = fnd_global.user_id,
1659: last_update_login = fnd_global.login_id,
1660: object_version_number = 1
1661: WHERE TrxnMID = trxn_mid;
1662:
1663: UPDATE iby_trxn_extended
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,
1668: last_update_login = fnd_global.login_id,
1669: object_version_number = 1
1670: WHERE TrxnMID = trxn_mid;
1671: END IF;
1664: SET Cardbin = card_bin_in,
1665: TerminalID = terminal_id_in,
1666: last_update_date = sysdate,
1667: last_updated_by = fnd_global.user_id,
1668: last_update_login = fnd_global.login_id,
1669: object_version_number = 1
1670: WHERE TrxnMID = trxn_mid;
1671: END IF;
1672: END IF;