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_SCHED dependencies on IBY_TRANS_PCARD_V

Line 274: SELECT iby_trans_pcard_v.TRANSACTIONID,

270: AND trxn.status not in (1, 0, 11, 100, 111)
271: AND trxn.ecappid = cin_ecappid;
272:
273: CURSOR c_trans_pcard (cin_ecappid in iby_ecapp.ecappid%type) IS
274: SELECT iby_trans_pcard_v.TRANSACTIONID,
275: iby_trans_pcard_v.STATUS,
276: iby_trans_pcard_v.UPDATEDATE,
277: iby_trans_pcard_v.REQTYPE,
278: iby_trans_pcard_v.REFERENCECODE,

Line 275: iby_trans_pcard_v.STATUS,

271: AND trxn.ecappid = cin_ecappid;
272:
273: CURSOR c_trans_pcard (cin_ecappid in iby_ecapp.ecappid%type) IS
274: SELECT iby_trans_pcard_v.TRANSACTIONID,
275: iby_trans_pcard_v.STATUS,
276: iby_trans_pcard_v.UPDATEDATE,
277: iby_trans_pcard_v.REQTYPE,
278: iby_trans_pcard_v.REFERENCECODE,
279: iby_trans_pcard_v.TRXNMID

Line 276: iby_trans_pcard_v.UPDATEDATE,

272:
273: CURSOR c_trans_pcard (cin_ecappid in iby_ecapp.ecappid%type) IS
274: SELECT iby_trans_pcard_v.TRANSACTIONID,
275: iby_trans_pcard_v.STATUS,
276: iby_trans_pcard_v.UPDATEDATE,
277: iby_trans_pcard_v.REQTYPE,
278: iby_trans_pcard_v.REFERENCECODE,
279: iby_trans_pcard_v.TRXNMID
280: FROM iby_trans_pcard_v

Line 277: iby_trans_pcard_v.REQTYPE,

273: CURSOR c_trans_pcard (cin_ecappid in iby_ecapp.ecappid%type) IS
274: SELECT iby_trans_pcard_v.TRANSACTIONID,
275: iby_trans_pcard_v.STATUS,
276: iby_trans_pcard_v.UPDATEDATE,
277: iby_trans_pcard_v.REQTYPE,
278: iby_trans_pcard_v.REFERENCECODE,
279: iby_trans_pcard_v.TRXNMID
280: FROM iby_trans_pcard_v
281: WHERE iby_trans_pcard_v.needsupdt IN ('Y','F')

Line 278: iby_trans_pcard_v.REFERENCECODE,

274: SELECT iby_trans_pcard_v.TRANSACTIONID,
275: iby_trans_pcard_v.STATUS,
276: iby_trans_pcard_v.UPDATEDATE,
277: iby_trans_pcard_v.REQTYPE,
278: iby_trans_pcard_v.REFERENCECODE,
279: iby_trans_pcard_v.TRXNMID
280: FROM iby_trans_pcard_v
281: WHERE iby_trans_pcard_v.needsupdt IN ('Y','F')
282: AND iby_trans_pcard_v.reqtype <> 'ORAPMTREQ'

Line 279: iby_trans_pcard_v.TRXNMID

275: iby_trans_pcard_v.STATUS,
276: iby_trans_pcard_v.UPDATEDATE,
277: iby_trans_pcard_v.REQTYPE,
278: iby_trans_pcard_v.REFERENCECODE,
279: iby_trans_pcard_v.TRXNMID
280: FROM iby_trans_pcard_v
281: WHERE iby_trans_pcard_v.needsupdt IN ('Y','F')
282: AND iby_trans_pcard_v.reqtype <> 'ORAPMTREQ'
283: AND iby_trans_pcard_v.status not in (1, 0, 11, 100, 111)

Line 280: FROM iby_trans_pcard_v

276: iby_trans_pcard_v.UPDATEDATE,
277: iby_trans_pcard_v.REQTYPE,
278: iby_trans_pcard_v.REFERENCECODE,
279: iby_trans_pcard_v.TRXNMID
280: FROM iby_trans_pcard_v
281: WHERE iby_trans_pcard_v.needsupdt IN ('Y','F')
282: AND iby_trans_pcard_v.reqtype <> 'ORAPMTREQ'
283: AND iby_trans_pcard_v.status not in (1, 0, 11, 100, 111)
284: AND iby_trans_pcard_v.ecappid = cin_ecappid;

Line 281: WHERE iby_trans_pcard_v.needsupdt IN ('Y','F')

277: iby_trans_pcard_v.REQTYPE,
278: iby_trans_pcard_v.REFERENCECODE,
279: iby_trans_pcard_v.TRXNMID
280: FROM iby_trans_pcard_v
281: WHERE iby_trans_pcard_v.needsupdt IN ('Y','F')
282: AND iby_trans_pcard_v.reqtype <> 'ORAPMTREQ'
283: AND iby_trans_pcard_v.status not in (1, 0, 11, 100, 111)
284: AND iby_trans_pcard_v.ecappid = cin_ecappid;
285:

Line 282: AND iby_trans_pcard_v.reqtype <> 'ORAPMTREQ'

278: iby_trans_pcard_v.REFERENCECODE,
279: iby_trans_pcard_v.TRXNMID
280: FROM iby_trans_pcard_v
281: WHERE iby_trans_pcard_v.needsupdt IN ('Y','F')
282: AND iby_trans_pcard_v.reqtype <> 'ORAPMTREQ'
283: AND iby_trans_pcard_v.status not in (1, 0, 11, 100, 111)
284: AND iby_trans_pcard_v.ecappid = cin_ecappid;
285:
286: l_ecappTab ecappTabType;

Line 283: AND iby_trans_pcard_v.status not in (1, 0, 11, 100, 111)

279: iby_trans_pcard_v.TRXNMID
280: FROM iby_trans_pcard_v
281: WHERE iby_trans_pcard_v.needsupdt IN ('Y','F')
282: AND iby_trans_pcard_v.reqtype <> 'ORAPMTREQ'
283: AND iby_trans_pcard_v.status not in (1, 0, 11, 100, 111)
284: AND iby_trans_pcard_v.ecappid = cin_ecappid;
285:
286: l_ecappTab ecappTabType;
287: l_ecapp_rec ecapp_rec_type;

Line 284: AND iby_trans_pcard_v.ecappid = cin_ecappid;

280: FROM iby_trans_pcard_v
281: WHERE iby_trans_pcard_v.needsupdt IN ('Y','F')
282: AND iby_trans_pcard_v.reqtype <> 'ORAPMTREQ'
283: AND iby_trans_pcard_v.status not in (1, 0, 11, 100, 111)
284: AND iby_trans_pcard_v.ecappid = cin_ecappid;
285:
286: l_ecappTab ecappTabType;
287: l_ecapp_rec ecapp_rec_type;
288:

Line 531: SELECT iby_trans_pcard_v.TRANSACTIONID,

527:
528: -- r_trans_bankacct c_trans_bankacct%ROWTYPE;
529:
530: CURSOR c_trans_pcard (cin_ecappid in iby_ecapp.ecappid%type) IS
531: SELECT iby_trans_pcard_v.TRANSACTIONID,
532: iby_trans_pcard_v.STATUS,
533: iby_trans_pcard_v.UPDATEDATE,
534: iby_trans_pcard_v.REQTYPE,
535: iby_trans_pcard_v.REFERENCECODE,

Line 532: iby_trans_pcard_v.STATUS,

528: -- r_trans_bankacct c_trans_bankacct%ROWTYPE;
529:
530: CURSOR c_trans_pcard (cin_ecappid in iby_ecapp.ecappid%type) IS
531: SELECT iby_trans_pcard_v.TRANSACTIONID,
532: iby_trans_pcard_v.STATUS,
533: iby_trans_pcard_v.UPDATEDATE,
534: iby_trans_pcard_v.REQTYPE,
535: iby_trans_pcard_v.REFERENCECODE,
536: iby_trans_pcard_v.TRXNMID

Line 533: iby_trans_pcard_v.UPDATEDATE,

529:
530: CURSOR c_trans_pcard (cin_ecappid in iby_ecapp.ecappid%type) IS
531: SELECT iby_trans_pcard_v.TRANSACTIONID,
532: iby_trans_pcard_v.STATUS,
533: iby_trans_pcard_v.UPDATEDATE,
534: iby_trans_pcard_v.REQTYPE,
535: iby_trans_pcard_v.REFERENCECODE,
536: iby_trans_pcard_v.TRXNMID
537: FROM iby_trans_pcard_v

Line 534: iby_trans_pcard_v.REQTYPE,

530: CURSOR c_trans_pcard (cin_ecappid in iby_ecapp.ecappid%type) IS
531: SELECT iby_trans_pcard_v.TRANSACTIONID,
532: iby_trans_pcard_v.STATUS,
533: iby_trans_pcard_v.UPDATEDATE,
534: iby_trans_pcard_v.REQTYPE,
535: iby_trans_pcard_v.REFERENCECODE,
536: iby_trans_pcard_v.TRXNMID
537: FROM iby_trans_pcard_v
538: WHERE iby_trans_pcard_v.needsupdt IN ('Y','F')

Line 535: iby_trans_pcard_v.REFERENCECODE,

531: SELECT iby_trans_pcard_v.TRANSACTIONID,
532: iby_trans_pcard_v.STATUS,
533: iby_trans_pcard_v.UPDATEDATE,
534: iby_trans_pcard_v.REQTYPE,
535: iby_trans_pcard_v.REFERENCECODE,
536: iby_trans_pcard_v.TRXNMID
537: FROM iby_trans_pcard_v
538: WHERE iby_trans_pcard_v.needsupdt IN ('Y','F')
539: AND iby_trans_pcard_v.ecappid = cin_ecappid;

Line 536: iby_trans_pcard_v.TRXNMID

532: iby_trans_pcard_v.STATUS,
533: iby_trans_pcard_v.UPDATEDATE,
534: iby_trans_pcard_v.REQTYPE,
535: iby_trans_pcard_v.REFERENCECODE,
536: iby_trans_pcard_v.TRXNMID
537: FROM iby_trans_pcard_v
538: WHERE iby_trans_pcard_v.needsupdt IN ('Y','F')
539: AND iby_trans_pcard_v.ecappid = cin_ecappid;
540:

Line 537: FROM iby_trans_pcard_v

533: iby_trans_pcard_v.UPDATEDATE,
534: iby_trans_pcard_v.REQTYPE,
535: iby_trans_pcard_v.REFERENCECODE,
536: iby_trans_pcard_v.TRXNMID
537: FROM iby_trans_pcard_v
538: WHERE iby_trans_pcard_v.needsupdt IN ('Y','F')
539: AND iby_trans_pcard_v.ecappid = cin_ecappid;
540:
541: BEGIN

Line 538: WHERE iby_trans_pcard_v.needsupdt IN ('Y','F')

534: iby_trans_pcard_v.REQTYPE,
535: iby_trans_pcard_v.REFERENCECODE,
536: iby_trans_pcard_v.TRXNMID
537: FROM iby_trans_pcard_v
538: WHERE iby_trans_pcard_v.needsupdt IN ('Y','F')
539: AND iby_trans_pcard_v.ecappid = cin_ecappid;
540:
541: BEGIN
542: txn_id_Tab := JTF_VARCHAR2_TABLE_100();

Line 539: AND iby_trans_pcard_v.ecappid = cin_ecappid;

535: iby_trans_pcard_v.REFERENCECODE,
536: iby_trans_pcard_v.TRXNMID
537: FROM iby_trans_pcard_v
538: WHERE iby_trans_pcard_v.needsupdt IN ('Y','F')
539: AND iby_trans_pcard_v.ecappid = cin_ecappid;
540:
541: BEGIN
542: txn_id_Tab := JTF_VARCHAR2_TABLE_100();
543: Status_Tab := JTF_NUMBER_TABLE();