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: -- Bug:8363526. : Inserting value for new column iby_batches_all

313: INTO l_mbatchid
314: FROM dual;
315:
316: iby_accppmtmthd_pkg.getMPayeeId(i_payeeid, l_mpayeeid);
317: -- Bug:8363526. : Inserting value for new column iby_batches_all
318: -- Inserted column settledate value will be sysdate.
319: INSERT INTO iby_batches_all
320: (MBatchID, BatchID, MPayeeID, PayeeID, BEPID, bepkey, ECAppID,
321: PaymentMethodName, BatchStatus,

Line 319: INSERT INTO iby_batches_all

315:
316: iby_accppmtmthd_pkg.getMPayeeId(i_payeeid, l_mpayeeid);
317: -- Bug:8363526. : Inserting value for new column iby_batches_all
318: -- Inserted column settledate value will be sysdate.
319: INSERT INTO iby_batches_all
320: (MBatchID, BatchID, MPayeeID, PayeeID, BEPID, bepkey, ECAppID,
321: PaymentMethodName, BatchStatus,
322: ReqType, ReqDate, DestUrl,
323: Nlslang, TerminalID, BatchOpenDate,

Line 394: l_mbatchid iby_batches_all.mbatchid%type;

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

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

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

Line 490: i_payeeid iby_batches_all.payeeid%type,

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

Line 491: i_bepid iby_batches_all.bepid%type,

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

Line 575: l_mbatchid iby_batches_all.mbatchid%type;

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

Line 653: ** in the iby_batches_all table.

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

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

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

Line 663: i_payeeid iby_batches_all.payeeid%type,

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

Line 664: i_bepid iby_batches_all.bepid%type,

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

Line 665: i_batchid iby_batches_all.batchid%type,

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

Line 666: i_reqtype iby_batches_all.reqtype%type,

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

Line 667: i_reqdate iby_batches_all.reqdate%type,

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

Line 668: i_pmtmethod iby_batches_all.paymentmethodname%type,

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

Line 669: i_desturl iby_batches_all.desturl%type,

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

Line 670: i_nlslang iby_batches_all.nlslang%type,

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

Line 671: i_terminalid iby_batches_all.terminalid%type)

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

Line 675: l_mbatchid iby_batches_all.mbatchid%type;

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

Line 688: -- Bug: 8363526: Inserted new column settledate for tableiby_batches_all

684: SELECT iby_batches_s.NEXTVAL
685: INTO l_mbatchid
686: FROM dual;
687: iby_accppmtmthd_pkg.getMPayeeId(i_payeeid, l_mpayeeid);
688: -- Bug: 8363526: Inserted new column settledate for tableiby_batches_all
689: INSERT INTO iby_batches_all
690: (MBatchID, BatchID, MPayeeID, PayeeID, BEPID, ECAppID,
691: ReqType, ReqDate, DestUrl, PaymentMethodName,
692: Nlslang, TerminalID,

Line 689: INSERT INTO iby_batches_all

685: INTO l_mbatchid
686: FROM dual;
687: iby_accppmtmthd_pkg.getMPayeeId(i_payeeid, l_mpayeeid);
688: -- Bug: 8363526: Inserted new column settledate for tableiby_batches_all
689: INSERT INTO iby_batches_all
690: (MBatchID, BatchID, MPayeeID, PayeeID, BEPID, ECAppID,
691: ReqType, ReqDate, DestUrl, PaymentMethodName,
692: Nlslang, TerminalID,
693: last_update_date, last_updated_by, creation_date, created_by,

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

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

Line 761: i_batchid iby_batches_all.batchid%type,

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

Line 762: i_reqtype iby_batches_all.reqtype%type)

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

Line 774: FROM iby_batches_all

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