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 330: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,

326: (l_mbatchid, i_batchid, l_mpayeeid, i_payeeid, i_bepid, i_bepkey, i_ecappid,
327: i_pmtmethod, l_status,
328: i_reqtype, sysdate, i_desturl,
329: i_nlslang, i_terminalid, i_schedDate,
330: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
331: fnd_global.login_id, 1);
332:
333: commit;
334: END scheduleCCbatch;

Line 331: fnd_global.login_id, 1);

327: i_pmtmethod, l_status,
328: i_reqtype, sysdate, i_desturl,
329: i_nlslang, i_terminalid, i_schedDate,
330: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
331: fnd_global.login_id, 1);
332:
333: commit;
334: END scheduleCCbatch;
335:

Line 449: sysdate, sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,

445: i_payerid, i_instrid, i_amount, i_currency,
446: l_status, i_trxntypeid, i_settledate, sysdate, i_reqtype,
447: i_reqseq,i_desturl,
448: i_nlslang, l_mbatchid, batchid,
449: sysdate, sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
450: fnd_global.login_id, 1,'Y');
451:
452: INSERT INTO iby_trxn_extended
453: (TRXNMID, RecurringFreq, RecurringExpDate, DestPostalCode,

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

446: l_status, i_trxntypeid, i_settledate, sysdate, i_reqtype,
447: i_reqseq,i_desturl,
448: i_nlslang, l_mbatchid, batchid,
449: sysdate, sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
450: fnd_global.login_id, 1,'Y');
451:
452: INSERT INTO iby_trxn_extended
453: (TRXNMID, RecurringFreq, RecurringExpDate, DestPostalCode,
454: CustRefNum, LocalTaxPrice, LocalTaxCurrency,

Line 464: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,

460: (l_mid, recurringfreq,recurringexpdate,destpostalcode,
461: custrefnum, localtaxprice, localtaxcurrency,
462: authprice, authcurrency, installtotaltrxns, splitshipment, splitid,
463: batchseqnum, terminalid,
464: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
465: fnd_global.login_id, 1);
466:
467: -- insert the authtype into core table
468: INSERT INTO iby_trxn_core

Line 465: fnd_global.login_id, 1);

461: custrefnum, localtaxprice, localtaxcurrency,
462: authprice, authcurrency, installtotaltrxns, splitshipment, splitid,
463: batchseqnum, terminalid,
464: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
465: fnd_global.login_id, 1);
466:
467: -- insert the authtype into core table
468: INSERT INTO iby_trxn_core
469: (TrxnMID, Authtype,

Line 474: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,

470: last_update_date, last_updated_by, creation_date, created_by,
471: last_update_login, object_version_number)
472: VALUES
473: (l_mid, i_authtype,
474: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
475: fnd_global.login_id, 1);
476:
477: commit;
478: END scheduleSET;

Line 475: fnd_global.login_id, 1);

471: last_update_login, object_version_number)
472: VALUES
473: (l_mid, i_authtype,
474: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
475: fnd_global.login_id, 1);
476:
477: commit;
478: END scheduleSET;
479:

Line 517: sysdate, sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,

513: last_update_login, object_version_number,needsupdt)
514: VALUES
515: (l_mid, i_transactionid, i_tangibleid,
516: l_mpayeeid, i_payeeid, i_bepid, i_ecappid, i_pmtmethod, l_status,
517: sysdate, sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
518: fnd_global.login_id, 1,'Y');
519:
520: commit;
521: EXCEPTION

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

514: VALUES
515: (l_mid, i_transactionid, i_tangibleid,
516: l_mpayeeid, i_payeeid, i_bepid, i_ecappid, i_pmtmethod, l_status,
517: sysdate, sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
518: fnd_global.login_id, 1,'Y');
519:
520: commit;
521: EXCEPTION
522: WHEN NO_DATA_FOUND THEN

Line 622: sysdate, sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,

618: i_payerid, i_instrid, i_amount, i_currency,
619: l_status, i_trxntypeid, i_settledate, sysdate, i_reqtype,
620: i_reqseq,i_desturl,
621: i_nlslang, l_mbatchid, batchid,
622: sysdate, sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
623: fnd_global.login_id, 1,'Y');
624:
625: INSERT INTO iby_trxn_extended
626: (TRXNMID, SplitId, PrevSplitId, SubAuthInd,

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

619: l_status, i_trxntypeid, i_settledate, sysdate, i_reqtype,
620: i_reqseq,i_desturl,
621: i_nlslang, l_mbatchid, batchid,
622: sysdate, sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
623: fnd_global.login_id, 1,'Y');
624:
625: INSERT INTO iby_trxn_extended
626: (TRXNMID, SplitId, PrevSplitId, SubAuthInd,
627: BatchSeqNum, TerminalId,

Line 633: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,

629: last_update_login, object_version_number)
630: VALUES
631: (l_mid, splitid, prevsplitid, subauthind,
632: batchseqnum, terminalid,
633: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
634: fnd_global.login_id, 1);
635:
636: -- insert the authtype into core table
637: INSERT INTO iby_trxn_core

Line 634: fnd_global.login_id, 1);

630: VALUES
631: (l_mid, splitid, prevsplitid, subauthind,
632: batchseqnum, terminalid,
633: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
634: fnd_global.login_id, 1);
635:
636: -- insert the authtype into core table
637: INSERT INTO iby_trxn_core
638: (TrxnMID, Authtype,

Line 643: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,

639: last_update_date, last_updated_by, creation_date, created_by,
640: last_update_login, object_version_number)
641: VALUES
642: (l_mid, i_authtype,
643: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
644: fnd_global.login_id, 1);
645:
646: commit;
647: END scheduleSETOther;

Line 644: fnd_global.login_id, 1);

640: last_update_login, object_version_number)
641: VALUES
642: (l_mid, i_authtype,
643: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
644: fnd_global.login_id, 1);
645:
646: commit;
647: END scheduleSETOther;
648: /*

Line 696: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,

692: VALUES
693: (l_mbatchid, i_batchid, l_mpayeeid, i_payeeid, i_bepid, i_ecappid,
694: i_reqtype, sysdate, i_desturl, i_pmtmethod,
695: i_nlslang, i_terminalid,
696: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
697: fnd_global.login_id, 1);
698:
699:
700: commit;

Line 697: fnd_global.login_id, 1);

693: (l_mbatchid, i_batchid, l_mpayeeid, i_payeeid, i_bepid, i_ecappid,
694: i_reqtype, sysdate, i_desturl, i_pmtmethod,
695: i_nlslang, i_terminalid,
696: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
697: fnd_global.login_id, 1);
698:
699:
700: commit;
701: END scheduleSETbatch;