141: l_mpayeeid, i_payeeid, i_bepid, i_bepkey, i_ecappid, i_pmtmethod,
142: i_payerid, l_instrid, i_amount, i_currency,
143: l_status, i_trxntypeid, i_settledate, sysdate, i_reqtype, i_desturl,
144: i_nlslang, l_tmid, l_org_id, i_instrtype,
145: sysdate, sysdate, fnd_global.user_id, sysdate, fnd_global.user_id, fnd_global.login_id, 1,'Y');
146:
147: -- insert the authtype into core table
148: INSERT INTO iby_trxn_core
149: (TrxnMID, Authtype, PONumber, TaxAmount, ShipFromZip, ShipToZip,
150: last_update_date, last_updated_by, creation_date, created_by,
151: last_update_login, object_version_number, AuthCode, VoiceAuthFlag)
152: VALUES
153: (l_mid, i_authtype, i_ponum, i_taxamt, i_shipfromzip, i_shiptozip,
154: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
155: fnd_global.login_id, 1, i_authcode, i_voiceauthflag);
156:
157: commit;
158: END schedulePC;
151: last_update_login, object_version_number, AuthCode, VoiceAuthFlag)
152: VALUES
153: (l_mid, i_authtype, i_ponum, i_taxamt, i_shipfromzip, i_shiptozip,
154: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
155: fnd_global.login_id, 1, i_authcode, i_voiceauthflag);
156:
157: commit;
158: END schedulePC;
159:
257: (l_mid, i_transactionid, i_tangibleid,
258: l_mpayeeid, i_payeeid, i_bepid, i_bepkey, i_ecappid, i_pmtmethod,
259: l_status, l_tmid, i_trxntypeid_tocancel,
260: i_reqtype, sysdate, l_instrid,
261: sysdate, sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
262: fnd_global.login_id, 1,'Y');
263:
264: commit;
265:
258: l_mpayeeid, i_payeeid, i_bepid, i_bepkey, i_ecappid, i_pmtmethod,
259: l_status, l_tmid, i_trxntypeid_tocancel,
260: i_reqtype, sysdate, l_instrid,
261: sysdate, sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
262: fnd_global.login_id, 1,'Y');
263:
264: commit;
265:
266: EXCEPTION
328: (l_mbatchid, i_batchid, l_mpayeeid, i_payeeid, i_bepid, i_bepkey, i_ecappid,
329: i_pmtmethod, l_status,
330: i_reqtype, sysdate, i_desturl,
331: i_nlslang, i_terminalid, i_schedDate,
332: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
333: fnd_global.login_id, 1,sysdate);
334:
335: commit;
336: END scheduleCCbatch;
329: i_pmtmethod, l_status,
330: i_reqtype, sysdate, i_desturl,
331: i_nlslang, i_terminalid, i_schedDate,
332: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
333: fnd_global.login_id, 1,sysdate);
334:
335: commit;
336: END scheduleCCbatch;
337:
447: i_payerid, i_instrid, i_amount, i_currency,
448: l_status, i_trxntypeid, i_settledate, sysdate, i_reqtype,
449: i_reqseq,i_desturl,
450: i_nlslang, l_mbatchid, batchid,
451: sysdate, sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
452: fnd_global.login_id, 1,'Y');
453:
454: INSERT INTO iby_trxn_extended
455: (TRXNMID, RecurringFreq, RecurringExpDate, DestPostalCode,
448: l_status, i_trxntypeid, i_settledate, sysdate, i_reqtype,
449: i_reqseq,i_desturl,
450: i_nlslang, l_mbatchid, batchid,
451: sysdate, sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
452: fnd_global.login_id, 1,'Y');
453:
454: INSERT INTO iby_trxn_extended
455: (TRXNMID, RecurringFreq, RecurringExpDate, DestPostalCode,
456: CustRefNum, LocalTaxPrice, LocalTaxCurrency,
462: (l_mid, recurringfreq,recurringexpdate,destpostalcode,
463: custrefnum, localtaxprice, localtaxcurrency,
464: authprice, authcurrency, installtotaltrxns, splitshipment, splitid,
465: batchseqnum, terminalid,
466: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
467: fnd_global.login_id, 1);
468:
469: -- insert the authtype into core table
470: INSERT INTO iby_trxn_core
463: custrefnum, localtaxprice, localtaxcurrency,
464: authprice, authcurrency, installtotaltrxns, splitshipment, splitid,
465: batchseqnum, terminalid,
466: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
467: fnd_global.login_id, 1);
468:
469: -- insert the authtype into core table
470: INSERT INTO iby_trxn_core
471: (TrxnMID, Authtype,
472: last_update_date, last_updated_by, creation_date, created_by,
473: last_update_login, object_version_number)
474: VALUES
475: (l_mid, i_authtype,
476: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
477: fnd_global.login_id, 1);
478:
479: commit;
480: END scheduleSET;
473: last_update_login, object_version_number)
474: VALUES
475: (l_mid, i_authtype,
476: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
477: fnd_global.login_id, 1);
478:
479: commit;
480: END scheduleSET;
481:
515: last_update_login, object_version_number,needsupdt)
516: VALUES
517: (l_mid, i_transactionid, i_tangibleid,
518: l_mpayeeid, i_payeeid, i_bepid, i_ecappid, i_pmtmethod, l_status,
519: sysdate, sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
520: fnd_global.login_id, 1,'Y');
521:
522: commit;
523: EXCEPTION
516: VALUES
517: (l_mid, i_transactionid, i_tangibleid,
518: l_mpayeeid, i_payeeid, i_bepid, i_ecappid, i_pmtmethod, l_status,
519: sysdate, sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
520: fnd_global.login_id, 1,'Y');
521:
522: commit;
523: EXCEPTION
524: WHEN NO_DATA_FOUND THEN
620: i_payerid, i_instrid, i_amount, i_currency,
621: l_status, i_trxntypeid, i_settledate, sysdate, i_reqtype,
622: i_reqseq,i_desturl,
623: i_nlslang, l_mbatchid, batchid,
624: sysdate, sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
625: fnd_global.login_id, 1,'Y');
626:
627: INSERT INTO iby_trxn_extended
628: (TRXNMID, SplitId, PrevSplitId, SubAuthInd,
621: l_status, i_trxntypeid, i_settledate, sysdate, i_reqtype,
622: i_reqseq,i_desturl,
623: i_nlslang, l_mbatchid, batchid,
624: sysdate, sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
625: fnd_global.login_id, 1,'Y');
626:
627: INSERT INTO iby_trxn_extended
628: (TRXNMID, SplitId, PrevSplitId, SubAuthInd,
629: BatchSeqNum, TerminalId,
631: last_update_login, object_version_number)
632: VALUES
633: (l_mid, splitid, prevsplitid, subauthind,
634: batchseqnum, terminalid,
635: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
636: fnd_global.login_id, 1);
637:
638: -- insert the authtype into core table
639: INSERT INTO iby_trxn_core
632: VALUES
633: (l_mid, splitid, prevsplitid, subauthind,
634: batchseqnum, terminalid,
635: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
636: fnd_global.login_id, 1);
637:
638: -- insert the authtype into core table
639: INSERT INTO iby_trxn_core
640: (TrxnMID, Authtype,
641: last_update_date, last_updated_by, creation_date, created_by,
642: last_update_login, object_version_number)
643: VALUES
644: (l_mid, i_authtype,
645: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
646: fnd_global.login_id, 1);
647:
648: commit;
649: END scheduleSETOther;
642: last_update_login, object_version_number)
643: VALUES
644: (l_mid, i_authtype,
645: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
646: fnd_global.login_id, 1);
647:
648: commit;
649: END scheduleSETOther;
650: /*
695: VALUES
696: (l_mbatchid, i_batchid, l_mpayeeid, i_payeeid, i_bepid, i_ecappid,
697: i_reqtype, sysdate, i_desturl, i_pmtmethod,
698: i_nlslang, i_terminalid,
699: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
700: fnd_global.login_id, 1,sysdate);
701:
702:
703: commit;
696: (l_mbatchid, i_batchid, l_mpayeeid, i_payeeid, i_bepid, i_ecappid,
697: i_reqtype, sysdate, i_desturl, i_pmtmethod,
698: i_nlslang, i_terminalid,
699: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
700: fnd_global.login_id, 1,sysdate);
701:
702:
703: commit;
704: END scheduleSETbatch;