DBA Data[Home] [Help]

APPS.IBY_OFFLINEDB_PKG dependencies on FND_GLOBAL

Line 145: sysdate, sysdate, fnd_global.user_id, sysdate, fnd_global.user_id, fnd_global.login_id, 1,'Y');

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,

Line 154: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,

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;

Line 155: fnd_global.login_id, 1, i_authcode, i_voiceauthflag);

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:

Line 261: sysdate, sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,

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:

Line 262: fnd_global.login_id, 1,'Y');

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

Line 332: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,

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;

Line 333: fnd_global.login_id, 1,sysdate);

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:

Line 451: sysdate, sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,

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,

Line 452: fnd_global.login_id, 1,'Y');

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,

Line 466: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,

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

Line 467: fnd_global.login_id, 1);

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,

Line 476: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,

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;

Line 477: fnd_global.login_id, 1);

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:

Line 519: sysdate, sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,

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

Line 520: fnd_global.login_id, 1,'Y');

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

Line 624: sysdate, sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,

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,

Line 625: fnd_global.login_id, 1,'Y');

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,

Line 635: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,

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

Line 636: fnd_global.login_id, 1);

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,

Line 645: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,

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;

Line 646: fnd_global.login_id, 1);

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: /*

Line 699: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,

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;

Line 700: fnd_global.login_id, 1,sysdate);

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;