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_OFFLINEDB_PKG dependencies on IBY_BATCHES_ALL

Line 215: procedure scheduleCCCancel(i_ecappid iby_batches_all.ecappid%type,

211: ** Procedure Name : scheduleCCCancel
212: ** Purpose : creates an entry for a CreditCard cancel request in the
213: ** iby_trxn_summaries_all table
214: */
215: procedure scheduleCCCancel(i_ecappid iby_batches_all.ecappid%type,
216: i_payeeid iby_batches_all.payeeid%type,
217: i_bepid iby_batches_all.bepid%type,
218: i_bepkey iby_batches_all.bepkey%type,
219: i_tangibleid iby_trxn_summaries_all.tangibleid%type,

Line 216: i_payeeid iby_batches_all.payeeid%type,

212: ** Purpose : creates an entry for a CreditCard cancel request in the
213: ** iby_trxn_summaries_all table
214: */
215: procedure scheduleCCCancel(i_ecappid iby_batches_all.ecappid%type,
216: i_payeeid iby_batches_all.payeeid%type,
217: i_bepid iby_batches_all.bepid%type,
218: i_bepkey iby_batches_all.bepkey%type,
219: i_tangibleid iby_trxn_summaries_all.tangibleid%type,
220: i_reqtype iby_trxn_summaries_all.reqtype%type,

Line 217: i_bepid iby_batches_all.bepid%type,

213: ** iby_trxn_summaries_all table
214: */
215: procedure scheduleCCCancel(i_ecappid iby_batches_all.ecappid%type,
216: i_payeeid iby_batches_all.payeeid%type,
217: i_bepid iby_batches_all.bepid%type,
218: i_bepkey iby_batches_all.bepkey%type,
219: i_tangibleid iby_trxn_summaries_all.tangibleid%type,
220: i_reqtype iby_trxn_summaries_all.reqtype%type,
221: i_reqdate iby_trxn_summaries_all.reqdate%type,

Line 218: i_bepkey iby_batches_all.bepkey%type,

214: */
215: procedure scheduleCCCancel(i_ecappid iby_batches_all.ecappid%type,
216: i_payeeid iby_batches_all.payeeid%type,
217: i_bepid iby_batches_all.bepid%type,
218: i_bepkey iby_batches_all.bepkey%type,
219: i_tangibleid iby_trxn_summaries_all.tangibleid%type,
220: i_reqtype iby_trxn_summaries_all.reqtype%type,
221: i_reqdate iby_trxn_summaries_all.reqdate%type,
222: i_pmtmethod iby_trxn_summaries_all.paymentmethodname%type,

Line 277: ** in the iby_batches_all table.

273:
274: /*
275: ** Procedure Name : scheduleCCbatch
276: ** Purpose : creates an entry for scheduling the CreditCard batch requests
277: ** in the iby_batches_all table.
278: **
279: ** Parameters:
280: **
281: ** In : i_ecappid, i_payeeid, i_bepid, i_batchid,

Line 286: procedure scheduleCCbatch(i_ecappid iby_batches_all.ecappid%type,

282: ** i_reqtype, i_reqdate, i_pmtmethod, i_desturl,
283: ** i_nlslang, i_terminalid
284: **
285: */
286: procedure scheduleCCbatch(i_ecappid iby_batches_all.ecappid%type,
287: i_payeeid iby_batches_all.payeeid%type,
288: i_bepid iby_batches_all.bepid%type,
289: i_bepkey iby_batches_all.bepkey%type,
290: i_batchid iby_batches_all.batchid%type,

Line 287: i_payeeid iby_batches_all.payeeid%type,

283: ** i_nlslang, i_terminalid
284: **
285: */
286: procedure scheduleCCbatch(i_ecappid iby_batches_all.ecappid%type,
287: i_payeeid iby_batches_all.payeeid%type,
288: i_bepid iby_batches_all.bepid%type,
289: i_bepkey iby_batches_all.bepkey%type,
290: i_batchid iby_batches_all.batchid%type,
291: i_reqtype iby_batches_all.reqtype%type,

Line 288: i_bepid iby_batches_all.bepid%type,

284: **
285: */
286: procedure scheduleCCbatch(i_ecappid iby_batches_all.ecappid%type,
287: i_payeeid iby_batches_all.payeeid%type,
288: i_bepid iby_batches_all.bepid%type,
289: i_bepkey iby_batches_all.bepkey%type,
290: i_batchid iby_batches_all.batchid%type,
291: i_reqtype iby_batches_all.reqtype%type,
292: i_reqdate iby_batches_all.reqdate%type,

Line 289: i_bepkey iby_batches_all.bepkey%type,

285: */
286: procedure scheduleCCbatch(i_ecappid iby_batches_all.ecappid%type,
287: i_payeeid iby_batches_all.payeeid%type,
288: i_bepid iby_batches_all.bepid%type,
289: i_bepkey iby_batches_all.bepkey%type,
290: i_batchid iby_batches_all.batchid%type,
291: i_reqtype iby_batches_all.reqtype%type,
292: i_reqdate iby_batches_all.reqdate%type,
293: i_pmtmethod iby_batches_all.paymentmethodname%type,

Line 290: i_batchid iby_batches_all.batchid%type,

286: procedure scheduleCCbatch(i_ecappid iby_batches_all.ecappid%type,
287: i_payeeid iby_batches_all.payeeid%type,
288: i_bepid iby_batches_all.bepid%type,
289: i_bepkey iby_batches_all.bepkey%type,
290: i_batchid iby_batches_all.batchid%type,
291: i_reqtype iby_batches_all.reqtype%type,
292: i_reqdate iby_batches_all.reqdate%type,
293: i_pmtmethod iby_batches_all.paymentmethodname%type,
294: i_desturl iby_batches_all.desturl%type,

Line 291: i_reqtype iby_batches_all.reqtype%type,

287: i_payeeid iby_batches_all.payeeid%type,
288: i_bepid iby_batches_all.bepid%type,
289: i_bepkey iby_batches_all.bepkey%type,
290: i_batchid iby_batches_all.batchid%type,
291: i_reqtype iby_batches_all.reqtype%type,
292: i_reqdate iby_batches_all.reqdate%type,
293: i_pmtmethod iby_batches_all.paymentmethodname%type,
294: i_desturl iby_batches_all.desturl%type,
295: i_nlslang iby_batches_all.nlslang%type,

Line 292: i_reqdate iby_batches_all.reqdate%type,

288: i_bepid iby_batches_all.bepid%type,
289: i_bepkey iby_batches_all.bepkey%type,
290: i_batchid iby_batches_all.batchid%type,
291: i_reqtype iby_batches_all.reqtype%type,
292: i_reqdate iby_batches_all.reqdate%type,
293: i_pmtmethod iby_batches_all.paymentmethodname%type,
294: i_desturl iby_batches_all.desturl%type,
295: i_nlslang iby_batches_all.nlslang%type,
296: i_terminalid iby_batches_all.terminalid%type,

Line 293: i_pmtmethod iby_batches_all.paymentmethodname%type,

289: i_bepkey iby_batches_all.bepkey%type,
290: i_batchid iby_batches_all.batchid%type,
291: i_reqtype iby_batches_all.reqtype%type,
292: i_reqdate iby_batches_all.reqdate%type,
293: i_pmtmethod iby_batches_all.paymentmethodname%type,
294: i_desturl iby_batches_all.desturl%type,
295: i_nlslang iby_batches_all.nlslang%type,
296: i_terminalid iby_batches_all.terminalid%type,
297: i_schedDate iby_batches_all.batchopendate%type)

Line 294: i_desturl iby_batches_all.desturl%type,

290: i_batchid iby_batches_all.batchid%type,
291: i_reqtype iby_batches_all.reqtype%type,
292: i_reqdate iby_batches_all.reqdate%type,
293: i_pmtmethod iby_batches_all.paymentmethodname%type,
294: i_desturl iby_batches_all.desturl%type,
295: i_nlslang iby_batches_all.nlslang%type,
296: i_terminalid iby_batches_all.terminalid%type,
297: i_schedDate iby_batches_all.batchopendate%type)
298: IS

Line 295: i_nlslang iby_batches_all.nlslang%type,

291: i_reqtype iby_batches_all.reqtype%type,
292: i_reqdate iby_batches_all.reqdate%type,
293: i_pmtmethod iby_batches_all.paymentmethodname%type,
294: i_desturl iby_batches_all.desturl%type,
295: i_nlslang iby_batches_all.nlslang%type,
296: i_terminalid iby_batches_all.terminalid%type,
297: i_schedDate iby_batches_all.batchopendate%type)
298: IS
299: -- 0011 indicates PENDING status

Line 296: i_terminalid iby_batches_all.terminalid%type,

292: i_reqdate iby_batches_all.reqdate%type,
293: i_pmtmethod iby_batches_all.paymentmethodname%type,
294: i_desturl iby_batches_all.desturl%type,
295: i_nlslang iby_batches_all.nlslang%type,
296: i_terminalid iby_batches_all.terminalid%type,
297: i_schedDate iby_batches_all.batchopendate%type)
298: IS
299: -- 0011 indicates PENDING status
300: l_status NUMBER := 0011;

Line 297: i_schedDate iby_batches_all.batchopendate%type)

293: i_pmtmethod iby_batches_all.paymentmethodname%type,
294: i_desturl iby_batches_all.desturl%type,
295: i_nlslang iby_batches_all.nlslang%type,
296: i_terminalid iby_batches_all.terminalid%type,
297: i_schedDate iby_batches_all.batchopendate%type)
298: IS
299: -- 0011 indicates PENDING status
300: l_status NUMBER := 0011;
301: l_mpayeeid iby_payee.mpayeeid%type;

Line 302: l_mbatchid iby_batches_all.mbatchid%type;

298: IS
299: -- 0011 indicates PENDING status
300: l_status NUMBER := 0011;
301: l_mpayeeid iby_payee.mpayeeid%type;
302: l_mbatchid iby_batches_all.mbatchid%type;
303:
304: BEGIN
305: -- call procedure to check if this is duplicate request
306: if (batchExists(i_payeeid, i_batchid, i_reqtype)) then

Line 317: INSERT INTO iby_batches_all

313: INTO l_mbatchid
314: FROM dual;
315:
316: iby_accppmtmthd_pkg.getMPayeeId(i_payeeid, l_mpayeeid);
317: INSERT INTO iby_batches_all
318: (MBatchID, BatchID, MPayeeID, PayeeID, BEPID, bepkey, ECAppID,
319: PaymentMethodName, BatchStatus,
320: ReqType, ReqDate, DestUrl,
321: Nlslang, TerminalID, BatchOpenDate,

Line 392: l_mbatchid iby_batches_all.mbatchid%type;

388: -- 0011 indicates PENDING status
389: l_status NUMBER := 0011;
390:
391: l_mpayeeid iby_payee.mpayeeid%type;
392: l_mbatchid iby_batches_all.mbatchid%type;
393: BEGIN
394: --if (upper(i_reqtype) = 'ORAPMTREQ') then
395: --if ( isPayeeRegistered(i_payeeid, i_bepid ) = false ) then
396: --raise_application_error(-20000, 'IBY_20605#', FALSE);

Line 487: procedure scheduleSETCancel(i_ecappid iby_batches_all.ecappid%type,

483: ** Purpose : creates an entry for a SET CreditCard cancel request in the
484: ** iby_trxn_summaries_all table
485: */
486: /*********should no longer be used
487: procedure scheduleSETCancel(i_ecappid iby_batches_all.ecappid%type,
488: i_payeeid iby_batches_all.payeeid%type,
489: i_bepid iby_batches_all.bepid%type,
490: i_tangibleid iby_trxn_summaries_all.tangibleid%type,
491: i_reqtype iby_trxn_summaries_all.reqtype%type,

Line 488: i_payeeid iby_batches_all.payeeid%type,

484: ** iby_trxn_summaries_all table
485: */
486: /*********should no longer be used
487: procedure scheduleSETCancel(i_ecappid iby_batches_all.ecappid%type,
488: i_payeeid iby_batches_all.payeeid%type,
489: i_bepid iby_batches_all.bepid%type,
490: i_tangibleid iby_trxn_summaries_all.tangibleid%type,
491: i_reqtype iby_trxn_summaries_all.reqtype%type,
492: i_reqdate iby_trxn_summaries_all.reqdate%type,

Line 489: i_bepid iby_batches_all.bepid%type,

485: */
486: /*********should no longer be used
487: procedure scheduleSETCancel(i_ecappid iby_batches_all.ecappid%type,
488: i_payeeid iby_batches_all.payeeid%type,
489: i_bepid iby_batches_all.bepid%type,
490: i_tangibleid iby_trxn_summaries_all.tangibleid%type,
491: i_reqtype iby_trxn_summaries_all.reqtype%type,
492: i_reqdate iby_trxn_summaries_all.reqdate%type,
493: i_pmtmethod iby_trxn_summaries_all.paymentmethodname%type,

Line 573: l_mbatchid iby_batches_all.mbatchid%type;

569: -- 0011 indicates PENDING status
570: l_status NUMBER := 0011;
571:
572: l_mpayeeid iby_payee.mpayeeid%type;
573: l_mbatchid iby_batches_all.mbatchid%type;
574: BEGIN
575: -- First check if this request is not duplicate
576: if (requestExists(i_payeeid,i_tangibleid, i_reqtype,i_bepid)) then
577: raise_application_error(-20000, 'IBY_20604#', FALSE);

Line 651: ** in the iby_batches_all table.

647: END scheduleSETOther;
648: /*
649: ** Procedure Name : scheduleSETbatch
650: ** Purpose : creates an entry for scheduling the CreditCard batch requests
651: ** in the iby_batches_all table.
652: **
653: ** Parameters:
654: **
655: ** In : i_ecappid, i_payeeid, i_bepid, i_batchid,

Line 660: procedure scheduleSETbatch(i_ecappid iby_batches_all.ecappid%type,

656: ** i_reqtype, i_reqdate, i_pmtmethod,
657: ** i_nlslang, i_terminalid
658: **
659: */
660: procedure scheduleSETbatch(i_ecappid iby_batches_all.ecappid%type,
661: i_payeeid iby_batches_all.payeeid%type,
662: i_bepid iby_batches_all.bepid%type,
663: i_batchid iby_batches_all.batchid%type,
664: i_reqtype iby_batches_all.reqtype%type,

Line 661: i_payeeid iby_batches_all.payeeid%type,

657: ** i_nlslang, i_terminalid
658: **
659: */
660: procedure scheduleSETbatch(i_ecappid iby_batches_all.ecappid%type,
661: i_payeeid iby_batches_all.payeeid%type,
662: i_bepid iby_batches_all.bepid%type,
663: i_batchid iby_batches_all.batchid%type,
664: i_reqtype iby_batches_all.reqtype%type,
665: i_reqdate iby_batches_all.reqdate%type,

Line 662: i_bepid iby_batches_all.bepid%type,

658: **
659: */
660: procedure scheduleSETbatch(i_ecappid iby_batches_all.ecappid%type,
661: i_payeeid iby_batches_all.payeeid%type,
662: i_bepid iby_batches_all.bepid%type,
663: i_batchid iby_batches_all.batchid%type,
664: i_reqtype iby_batches_all.reqtype%type,
665: i_reqdate iby_batches_all.reqdate%type,
666: i_pmtmethod iby_batches_all.paymentmethodname%type,

Line 663: i_batchid iby_batches_all.batchid%type,

659: */
660: procedure scheduleSETbatch(i_ecappid iby_batches_all.ecappid%type,
661: i_payeeid iby_batches_all.payeeid%type,
662: i_bepid iby_batches_all.bepid%type,
663: i_batchid iby_batches_all.batchid%type,
664: i_reqtype iby_batches_all.reqtype%type,
665: i_reqdate iby_batches_all.reqdate%type,
666: i_pmtmethod iby_batches_all.paymentmethodname%type,
667: i_desturl iby_batches_all.desturl%type,

Line 664: i_reqtype iby_batches_all.reqtype%type,

660: procedure scheduleSETbatch(i_ecappid iby_batches_all.ecappid%type,
661: i_payeeid iby_batches_all.payeeid%type,
662: i_bepid iby_batches_all.bepid%type,
663: i_batchid iby_batches_all.batchid%type,
664: i_reqtype iby_batches_all.reqtype%type,
665: i_reqdate iby_batches_all.reqdate%type,
666: i_pmtmethod iby_batches_all.paymentmethodname%type,
667: i_desturl iby_batches_all.desturl%type,
668: i_nlslang iby_batches_all.nlslang%type,

Line 665: i_reqdate iby_batches_all.reqdate%type,

661: i_payeeid iby_batches_all.payeeid%type,
662: i_bepid iby_batches_all.bepid%type,
663: i_batchid iby_batches_all.batchid%type,
664: i_reqtype iby_batches_all.reqtype%type,
665: i_reqdate iby_batches_all.reqdate%type,
666: i_pmtmethod iby_batches_all.paymentmethodname%type,
667: i_desturl iby_batches_all.desturl%type,
668: i_nlslang iby_batches_all.nlslang%type,
669: i_terminalid iby_batches_all.terminalid%type)

Line 666: i_pmtmethod iby_batches_all.paymentmethodname%type,

662: i_bepid iby_batches_all.bepid%type,
663: i_batchid iby_batches_all.batchid%type,
664: i_reqtype iby_batches_all.reqtype%type,
665: i_reqdate iby_batches_all.reqdate%type,
666: i_pmtmethod iby_batches_all.paymentmethodname%type,
667: i_desturl iby_batches_all.desturl%type,
668: i_nlslang iby_batches_all.nlslang%type,
669: i_terminalid iby_batches_all.terminalid%type)
670: IS

Line 667: i_desturl iby_batches_all.desturl%type,

663: i_batchid iby_batches_all.batchid%type,
664: i_reqtype iby_batches_all.reqtype%type,
665: i_reqdate iby_batches_all.reqdate%type,
666: i_pmtmethod iby_batches_all.paymentmethodname%type,
667: i_desturl iby_batches_all.desturl%type,
668: i_nlslang iby_batches_all.nlslang%type,
669: i_terminalid iby_batches_all.terminalid%type)
670: IS
671:

Line 668: i_nlslang iby_batches_all.nlslang%type,

664: i_reqtype iby_batches_all.reqtype%type,
665: i_reqdate iby_batches_all.reqdate%type,
666: i_pmtmethod iby_batches_all.paymentmethodname%type,
667: i_desturl iby_batches_all.desturl%type,
668: i_nlslang iby_batches_all.nlslang%type,
669: i_terminalid iby_batches_all.terminalid%type)
670: IS
671:
672: l_mpayeeid iby_payee.mpayeeid%type;

Line 669: i_terminalid iby_batches_all.terminalid%type)

665: i_reqdate iby_batches_all.reqdate%type,
666: i_pmtmethod iby_batches_all.paymentmethodname%type,
667: i_desturl iby_batches_all.desturl%type,
668: i_nlslang iby_batches_all.nlslang%type,
669: i_terminalid iby_batches_all.terminalid%type)
670: IS
671:
672: l_mpayeeid iby_payee.mpayeeid%type;
673: l_mbatchid iby_batches_all.mbatchid%type;

Line 673: l_mbatchid iby_batches_all.mbatchid%type;

669: i_terminalid iby_batches_all.terminalid%type)
670: IS
671:
672: l_mpayeeid iby_payee.mpayeeid%type;
673: l_mbatchid iby_batches_all.mbatchid%type;
674: BEGIN
675: -- call procedure to check if this is duplicate request
676: if (batchExists(i_payeeid, i_batchid, i_reqtype)) then
677: raise_application_error(-20000, 'IBY_20604#', FALSE);

Line 686: INSERT INTO iby_batches_all

682: SELECT iby_batches_s.NEXTVAL
683: INTO l_mbatchid
684: FROM dual;
685: iby_accppmtmthd_pkg.getMPayeeId(i_payeeid, l_mpayeeid);
686: INSERT INTO iby_batches_all
687: (MBatchID, BatchID, MPayeeID, PayeeID, BEPID, ECAppID,
688: ReqType, ReqDate, DestUrl, PaymentMethodName,
689: Nlslang, TerminalID,
690: last_update_date, last_updated_by, creation_date, created_by,

Line 757: FUNCTION batchExists(i_payeeid iby_batches_all.payeeid%type,

753:
754: END requestExists;
755:
756:
757: FUNCTION batchExists(i_payeeid iby_batches_all.payeeid%type,
758: i_batchid iby_batches_all.batchid%type,
759: i_reqtype iby_batches_all.reqtype%type)
760: return boolean
761: is

Line 758: i_batchid iby_batches_all.batchid%type,

754: END requestExists;
755:
756:
757: FUNCTION batchExists(i_payeeid iby_batches_all.payeeid%type,
758: i_batchid iby_batches_all.batchid%type,
759: i_reqtype iby_batches_all.reqtype%type)
760: return boolean
761: is
762: l_cnt int;

Line 759: i_reqtype iby_batches_all.reqtype%type)

755:
756:
757: FUNCTION batchExists(i_payeeid iby_batches_all.payeeid%type,
758: i_batchid iby_batches_all.batchid%type,
759: i_reqtype iby_batches_all.reqtype%type)
760: return boolean
761: is
762: l_cnt int;
763: BEGIN

Line 771: FROM iby_batches_all

767: ** otherwise does not exist.
768: */
769: SELECT count(*)
770: INTO l_cnt
771: FROM iby_batches_all
772: WHERE payeeId = i_payeeId
773: AND batchId = i_batchid
774: AND UPPER(reqType) = UPPER(i_reqType)
775: AND (batchstatus = 11 or batchstatus = 0);